CREATE TABLE IF NOT EXISTS `notice` (
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
`title` varchar(200) NOT NULL,
|
`description` mediumtext NOT NULL,
|
`register_id` bigint(20) NOT NULL,
|
`modify_id` bigint(20) NOT NULL,
|
`register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
`modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
PRIMARY KEY (`id`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|
