68 lines
2.3 KiB
Plaintext
68 lines
2.3 KiB
Plaintext
DROP TABLE IF EXISTS sys_user;
|
|
CREATE TABLE `sys_user` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(100) NOT NULL DEFAULT '',
|
|
`password` varchar(100) NOT NULL DEFAULT '',
|
|
`roleId` int(8) NOT NULL,
|
|
`create_time` datetime DEFAULT NULL,
|
|
`last_modify_time` datetime DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
|
|
|
|
|
|
|
|
|
|
DROP TABLE IF EXISTS sys_role;
|
|
CREATE TABLE `sys_role` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(100) NOT NULL DEFAULT '',
|
|
`type` int(1) NOT NULL DEFAULT '0',
|
|
`menus` json NOT NULL,
|
|
`create_time` datetime DEFAULT NULL,
|
|
`last_modify_time` datetime DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
|
|
|
|
DROP TABLE IF EXISTS sys_menu;
|
|
CREATE TABLE `sys_menu` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(100) NOT NULL DEFAULT '',
|
|
`parent_id` int(5) unsigned DEFAULT '0',
|
|
`model_id` int(11) unsigned DEFAULT NULL,
|
|
`form_id` int(11) DEFAULT NULL,
|
|
`icon` varchar(100) NOT NULL DEFAULT '',
|
|
`path` varchar(255) NOT NULL DEFAULT '',
|
|
`component` varchar(100) NOT NULL DEFAULT '',
|
|
`api_path` varchar(100) DEFAULT NULL,
|
|
`is_show_menu` tinyint(1) NOT NULL DEFAULT '1',
|
|
`is_show` tinyint(1) NOT NULL DEFAULT '1',
|
|
`type` enum('菜单','页面','外链','功能') NOT NULL DEFAULT '页面',
|
|
`sort` int(11) DEFAULT '0',
|
|
`create_time` datetime DEFAULT NULL,
|
|
`last_modify_time` datetime DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=120 DEFAULT CHARSET=utf8;
|
|
|
|
DROP TABLE IF EXISTS sys_log;
|
|
CREATE TABLE `sys_log` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`table_name` varchar(100) NOT NULL DEFAULT '',
|
|
`user_id` int(11) unsigned NOT NULL DEFAULT '0',
|
|
`operate` varchar(100) NOT NULL DEFAULT '',
|
|
`content` json NOT NULL,
|
|
`create_time` datetime DEFAULT NULL,
|
|
`last_modify_time` datetime DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=1388 DEFAULT CHARSET=utf8;
|
|
|
|
DROP TABLE IF EXISTS sys_parameter;
|
|
CREATE TABLE `sys_parameter` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`key` varchar(100) NOT NULL DEFAULT '',
|
|
`value` varchar(100) NOT NULL DEFAULT '',
|
|
`is_modified` int(2) DEFAULT '0',
|
|
`remark` varchar(500) NOT NULL DEFAULT '',
|
|
`create_time` datetime DEFAULT NULL,
|
|
`last_modify_time` datetime DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; |