11 lines
792 B
SQL
11 lines
792 B
SQL
|
|
-- 广播信息表
|
|
CREATE TABLE `manage_broadcast` (
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
|
`content` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '消息内容',
|
|
`create_user` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '创建人',
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 COLLATE=utf8mb4_bin COMMENT='广播表';
|