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);