# --------------------------------------------------------
#
# 帝国网站管理系统
#
# http://www.PHome.Net
#
# EmpireCMS Version 7.5
#
# --------------------------------------------------------
# --------------------------- 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(3) unsigned NOT NULL default '0',
`isgood` tinyint(3) unsigned 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(6) 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 '',
`eckuid` int(11) NOT NULL default '0',
`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(3) unsigned NOT NULL default '0',
`isgood` tinyint(3) unsigned 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(6) 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 '',
`eckuid` int(11) NOT NULL default '0',
`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',
本文地址：http://ww.kub2b.com/news/10657.html
企库往 http://ww.kub2b.com/ , 查看更多