Edit D:\chineseall_products\chineseall_digitallib\digitallib\digitalLib6\sql\screen-ver-1.0.sql
set names utf8; DROP TABLE IF EXISTS `screen_menu`; CREATE TABLE `screen_menu` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL, `link` varchar(255) NOT NULL DEFAULT '0', `type` int(1) NOT NULL DEFAULT '0' COMMENT '0????????????1????????', `status` int(1) NOT NULL DEFAULT '0' COMMENT '0??????1?????', `postion` int(2) DEFAULT NULL, `code` int(2) DEFAULT NULL, `icon` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `screen_rank_recommend`; CREATE TABLE `screen_rank_recommend` ( `id` int(11) NOT NULL AUTO_INCREMENT, `objectId` int(11) NOT NULL, `orderIndex` int(2) NOT NULL, `type` int(1) NOT NULL COMMENT '1??????2?????', `createTime` datetime NOT NULL, PRIMARY KEY (`id`), KEY `idx_rank_type` (`type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `screen_resource_recommend`; CREATE TABLE `screen_resource_recommend` ( `id` int(11) NOT NULL AUTO_INCREMENT, `objectId` int(11) NOT NULL, `title` varchar(200) NOT NULL, `type` int(1) NOT NULL COMMENT '1?????????2????????', `createTime` datetime NOT NULL, PRIMARY KEY (`id`), KEY `idx_resource_type` (`type`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `screen_roll_picture`; CREATE TABLE `screen_roll_picture` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(100) DEFAULT NULL, `picturePath` varchar(255) NOT NULL, `websit` varchar(200) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `screen_school`; CREATE TABLE `screen_school` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(200) NOT NULL, `content` text NOT NULL, `createTime` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; insert into sys_function(name, link, levelCode, lanFunc, netFunc, status) values('?????????', NULL, '82', 1, 2, 1); insert into sys_function(name, link, levelCode, lanFunc, netFunc, status) values('?????????', '/admin/screen/listMenu.action', '8201', 1, 2, 1); insert into sys_function(name, link, levelCode, lanFunc, netFunc, status) values('?????????', '/admin/screen/settingSchool.action', '8204', 1, 2, 1);
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de