13 lines
622 B
SQL
13 lines
622 B
SQL
-- 模板演示表（与 api/model/tpl_demo.js 一致；无 createdAt/updatedAt）
|
||
|
||
CREATE TABLE IF NOT EXISTS `tpl_demo` (
|
||
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
||
`title` varchar(200) NOT NULL COMMENT '标题',
|
||
`remark` varchar(500) DEFAULT NULL COMMENT '备注',
|
||
`create_time` datetime NOT NULL COMMENT '创建时间',
|
||
`last_modify_time` datetime NOT NULL COMMENT '最后修改时间',
|
||
`is_delete` tinyint NOT NULL DEFAULT '0' COMMENT '0 正常 1 已删除',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_tpl_demo_is_delete` (`is_delete`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='前后端模板演示表';
|