自学网在线课程教育网站源码 自适应手机端 帝国cms内核.zip

# -------------------------------------------------------- # # 帝国网站管理系统 # # http://www.PHome.Net # # EmpireCMS Version 7.2 # # -------------------------------------------------------- # --------------------------- article ----------------------------- DROP TABLE IF EXISTS `phome_ecms_article`; CREATE TABLE `phome_ecms_article` ( `id` int(10) unsigned NOT NULL auto_increment, `classid` smallint(5) unsigned NOT NULL default '0', `ttid` smallint(5) unsigned NOT NULL default '0', `onclick` int(10) unsigned NOT NULL default '0', `plnum` mediumint(8) unsigned NOT NULL default '0', `totaldown` mediumint(8) unsigned NOT NULL default '0', `newspath` char(20) NOT NULL default '', `filename` char(36) NOT NULL default '', `userid` mediumint(8) unsigned NOT NULL default '0', `username` char(20) NOT NULL default '', `firsttitle` tinyint(1) NOT NULL default '0', `isgood` tinyint(1) NOT NULL default '0', `ispic` tinyint(1) NOT NULL default '0', `istop` tinyint(1) NOT NULL default '0', `isqf` tinyint(1) NOT NULL default '0', `ismember` tinyint(1) NOT NULL default '0', `isurl` tinyint(1) NOT NULL default '0', `truetime` int(10) unsigned NOT NULL default '0', `lastdotime` int(10) unsigned NOT NULL default '0', `havehtml` tinyint(1) NOT NULL default '0', `groupid` smallint(5) unsigned NOT NULL default '0', `userfen` smallint(5) unsigned NOT NULL default '0', `titlefont` char(14) NOT NULL default '', `titleurl` char(200) NOT NULL default '', `stb` tinyint(3) unsigned NOT NULL default '1', `fstb` tinyint(3) unsigned NOT NULL default '1', `restb` tinyint(3) unsigned NOT NULL default '1', `keyboard` char(80) NOT NULL default '', `title` char(100) NOT NULL default '', `newstime` int(10) unsigned NOT NULL default '0', `titlepic` char(120) NOT NULL default '', `ftitle` char(120) NOT NULL default '', `smalltext` char(255) NOT NULL default '', `writer` char(30) NOT NULL default '', `befrom` char(60) NOT NULL default '', `newstext` char(50) NOT NULL default '', `diggtop` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `classid` (`classid`), KEY `newstime` (`newstime`), KEY `ttid` (`ttid`), KEY `firsttitle` (`firsttitle`), KEY `isgood` (`isgood`), KEY `ispic` (`ispic`), KEY `useridis` (`userid`,`ismember`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_ecms_article_check`; CREATE TABLE `phome_ecms_article_check` ( `id` int(10) unsigned NOT NULL auto_increment, `classid` smallint(5) unsigned NOT NULL default '0', `ttid` smallint(5) unsigned NOT NULL default '0', `onclick` int(10) unsigned NOT NULL default '0', `plnum` mediumint(8) unsigned NOT NULL default '0', `totaldown` mediumint(8) unsigned NOT NULL default '0', `newspath` char(20) NOT NULL default '', `filename` char(36) NOT NULL default '', `userid` mediumint(8) unsigned NOT NULL default '0', `username` char(20) NOT NULL default '', `firsttitle` tinyint(1) NOT NULL default '0', `isgood` tinyint(1) NOT NULL default '0', `ispic` tinyint(1) NOT NULL default '0', `istop` tinyint(1) NOT NULL default '0', `isqf` tinyint(1) NOT NULL default '0', `ismember` tinyint(1) NOT NULL default '0', `isurl` tinyint(1) NOT NULL default '0', `truetime` int(10) unsigned NOT NULL default '0', `lastdotime` int(10) unsigned NOT NULL default '0', `havehtml` tinyint(1) NOT NULL default '0', `groupid` smallint(5) unsigned NOT NULL default '0', `userfen` smallint(5) unsigned NOT NULL default '0', `titlefont` char(14) NOT NULL default '', `titleurl` char(200) NOT NULL default '', `stb` tinyint(3) unsigned NOT NULL default '1', `fstb` tinyint(3) unsigned NOT NULL default '1', `restb` tinyint(3) unsigned NOT NULL default '1', `keyboard` char(80) NOT NULL default '', `title` char(100) NOT NULL default '', `newstime` int(10) unsigned NOT NULL default '0', `titlepic` char(120) NOT NULL default '', `ftitle` char(120) NOT NULL default '', `smalltext` char(255) NOT NULL default '', `writer` char(30) NOT NULL default '', `befrom` char(60) NOT NULL default '', `newstext` char(50) NOT NULL default '', `diggtop` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `classid` (`classid`), KEY `newstime` (`newstime`), KEY `ttid` (`ttid`), KEY `firsttitle` (`firsttitle`), KEY `isgood` (`isgood`), KEY `ispic` (`ispic`), KEY `useridis` (`userid`,`ismember`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_ecms_article_check_data`; CREATE TABLE `phome_ecms_article_check_data` ( `id` int(10) unsigned NOT NULL default '0', `classid` smallint(5) unsigned NOT NULL default '0', `keyid` char(255) NOT NULL default '', `dokey` tinyint(1) NOT NULL default '0', `newstempid` smallint(5) unsigned NOT NULL default '0', `closepl` tinyint(1) NOT NULL default '0', `haveaddfen` tinyint(1) NOT NULL default '0', `infotags` char(80) NOT NULL default '', PRIMARY KEY (`id`), KEY `classid` (`classid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_ecms_article_data_1`; CREATE TABLE `phome_ecms_article_data_1` ( `id` int(10) unsigned NOT NULL default '0', `classid` smallint(5) unsigned NOT NULL default '0', `keyid` char(255) NOT NULL default '', `dokey` tinyint(1) NOT NULL default '0', `newstempid` smallint(5) unsigned NOT NULL default '0', `closepl` tinyint(1) NOT NULL default '0', `haveaddfen` tinyint(1) NOT NULL default '0', `infotags` char(80) NOT NULL default '', PRIMARY KEY (`id`), KEY `classid` (`classid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_ecms_article_doc`; CREATE TABLE `phome_ecms_article_doc` ( `id` int(10) unsigned NOT NULL auto_increment, `classid` smallint(5) unsigned NOT NULL default '0', `ttid` smallint(5) unsigned NOT NULL default '0', `onclick` int(10) unsigned NOT NULL default '0', `plnum` mediumint(8) unsigned NOT NULL default '0', `totaldown` mediumint(8) unsigned NOT NULL default '0', `newspath` char(20) NOT NULL default '', `filename` char(36) NOT NULL default '', `userid` mediumint(8) unsigned NOT NULL default '0', `username` char(20) NOT NULL default '', `firsttitle` tinyint(1) NOT NULL default '0', `isgood` tinyint(1) NOT NULL default '0', `ispic` tinyint(1) NOT NULL default '0', `istop` tinyint(1) NOT NULL default '0', `isqf` tinyint(1) NOT NULL default '0', `ismember` tinyint(1) NOT NULL default '0', `isurl` tinyint(1) NOT NULL default '0', `truetime` int(10) unsigned NOT NULL default '0', `lastdotime` int(10) unsigned NOT NULL default '0', `havehtml` tinyint(1) NOT NULL default '0', `groupid` smallint(5) unsigned NOT NULL default '0', `userfen` smallint(5) unsigned NOT NULL default '0', `titlefont` char(14) NOT NULL default '', `titleurl` char(200) NOT NULL default '', `stb` tinyint(3) unsigned NOT NULL default '1', `fstb` tinyint(3) unsigned NOT NULL default '1', `restb` tinyint(3) unsigned NOT NULL default '1', `keyboard` char(80) NOT NULL default '', `title` char(100) NOT NULL default '', `newstime` int(10) unsigned NOT NULL default '0', `titlepic` char(120) NOT NULL default '', `ftitle` char(120) NOT NULL default '', `smalltext` char(255) NOT NULL default '', `writer` char(30) NOT NULL default '', `befrom` char(60) NOT NULL default '', `newstext` char(50) NOT NULL default '', `diggtop` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `classid` (`classid`), KEY `newstime` (`newstime`), KEY `ttid` (`ttid`), KEY `firsttitle` (`firsttitle`), KEY `isgood` (`isgood`), KEY `ispic` (`ispic`), KEY `userid