25 lines
859 B
SQL
25 lines
859 B
SQL
CREATE TABLE `django_admin_log` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`action_time` DATETIME(6) NOT NULL,
|
|
`object_id` LONGTEXT DEFAULT NULL,
|
|
`object_repr` VARCHAR(200) NOT NULL,
|
|
`action_flag` SMALLINT(5) UNSIGNED NOT NULL CHECK (`action_flag` >= 0),
|
|
`change_message` LONGTEXT NOT NULL,
|
|
`content_type_id` INT(11) DEFAULT NULL,
|
|
`user_id` INT(11) NOT NULL,
|
|
PRIMARY KEY (id)
|
|
)
|
|
ENGINE = INNODB,
|
|
AUTO_INCREMENT = 22,
|
|
AVG_ROW_LENGTH = 819,
|
|
CHARACTER SET utf8mb4,
|
|
COLLATE utf8mb4_general_ci,
|
|
ROW_FORMAT = DYNAMIC;
|
|
|
|
ALTER TABLE `django_admin_log`
|
|
ADD CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (content_type_id)
|
|
REFERENCES django_content_type(id);
|
|
|
|
ALTER TABLE `django_admin_log`
|
|
ADD CONSTRAINT `django_admin_log_user_id_c564eba6_fk_auth_user_id` FOREIGN KEY (user_id)
|
|
REFERENCES auth_user(id); |