17 lines
1.2 KiB
SQL
17 lines
1.2 KiB
SQL
-- mysql语句
|
|
CREATE TABLE `t_subordinate` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
|
|
`unit_name` varchar(255) DEFAULT NULL COMMENT '单位名称',
|
|
`jump_url` varchar(500) DEFAULT NULL COMMENT '跳转路径',
|
|
`user_name` varchar(255) DEFAULT NULL COMMENT '用户名称',
|
|
`is_opne` char(1) DEFAULT '0' COMMENT '0开启 1 关闭',
|
|
`files_url` varchar(500) DEFAULT NULL COMMENT '档案总数地址',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
INSERT INTO `enterprise_digital_archives`.`t_menu`(`name`, `url`, `pid`, `remark`, `orders`, `icon`, `funcType`, `funcTypeCode`) VALUES ( '下属单位', '/subordinate/units', -1, NULL, 5, 'zd', NULL, NULL);
|
|
INSERT INTO `enterprise_digital_archives`.`t_button` ( `name`, `menuid`, `key`) VALUES ( '四性检测', '148', 'sxjc');
|
|
INSERT INTO `enterprise_digital_archives`.`t_button` ( `name`, `menuid`, `key`) VALUES ( '批量替换', '153', 'plxg');
|
|
INSERT INTO `enterprise_digital_archives`.`t_button` ( `name`, `menuid`, `key`) VALUES ( '批量修改档号', '148', 'plxgdh');
|
|
|