# --------------------------------------------------------
#
# 帝国网站管理系统
#
# 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',
`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(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_doc_data`;
CREATE TABLE `phome_ecms_article_doc_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_doc_index`;
CREATE TABLE `phome_ecms_article_doc_index` (
`id` int(10) unsigned NOT NULL auto_increment,
`classid` smallint(5) unsigned NOT NULL default '0',
`checked` tinyint(1) NOT NULL default '0',
`newstime` int(10) unsigned 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',
PRIMARY KEY (`id`),
KEY `classid` (`classid`),
KEY `checked` (`checked`),
KEY `newstime` (`newstime`),
KEY `truetime` (`truetime`,`id`),
KEY `havehtml` (`classid`,`truetime`,`havehtml`,`checked`,`id`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_article_index`;
CREATE TABLE `phome_ecms_article_index` (
`id` int(10) unsigned NOT NULL auto_increment,
`classid` smallint(5) unsigned NOT NULL default '0',
`checked` tinyint(1) NOT NULL default '0',
`newstime` int(10) unsigned 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',
PRIMARY KEY (`id`),
KEY `classid` (`classid`),
KEY `checked` (`checked`),
KEY `newstime` (`newstime`),
KEY `truetime` (`truetime`,`id`),
KEY `havehtml` (`classid`,`truetime`,`havehtml`,`checked`,`id`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_infoclass_article`;
CREATE TABLE `phome_ecms_infoclass_article` (
`classid` int(10) unsigned NOT NULL default '0',
`zz_title` text NOT NULL,
`z_title` varchar(255) NOT NULL default '',
`qz_title` varchar(255) NOT NULL default '',
`save_title` varchar(10) NOT NULL default '',
`zz_titlepic` text NOT NULL,
`z_titlepic` varchar(255) NOT NULL default '',
`qz_titlepic` varchar(255) NOT NULL default '',
`save_titlepic` varchar(10) NOT NULL default '',
`zz_newstime` text NOT NULL,
`z_newstime` varchar(255) NOT NULL default '',
`qz_newstime` varchar(255) NOT NULL default '',
`save_newstime` varchar(10) NOT NULL default '',
`zz_ftitle` text NOT NULL,
`z_ftitle` varchar(255) NOT NULL default '',
`qz_ftitle` varchar(255) NOT NULL default '',
`save_ftitle` varchar(10) NOT NULL default '',
`zz_smalltext` text NOT NULL,
`z_smalltext` varchar(255) NOT NULL default '',
`qz_smalltext` varchar(255) NOT NULL default '',
`save_smalltext` varchar(10) NOT NULL default '',
`zz_writer` text NOT NULL,
`z_writer` varchar(255) NOT NULL default '',
`qz_writer` varchar(255) NOT NULL default '',
`save_writer` varchar(10) NOT NULL default '',
`zz_befrom` text NOT NULL,
`z_befrom` varchar(255) NOT NULL default '',
`qz_befrom` varchar(255) NOT NULL default '',
`save_befrom` varchar(10) NOT NULL default '',
`zz_newstext` text NOT NULL,
`z_newstext` varchar(255) NOT NULL default '',
`qz_newstext` varchar(255) NOT NULL default '',
`save_newstext` varchar(10) NOT NULL default '',
`zz_diggtop` text NOT NULL,
`z_diggtop` varchar(255) NOT NULL default '',
`qz_diggtop` varchar(255) NOT NULL default '',
`save_diggtop` varchar(10) NOT NULL default '',
PRIMARY KEY (`classid`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_infotmp_article`;
CREATE TABLE `phome_ecms_infotmp_article` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`classid` int(10) unsigned NOT NULL default '0',
`oldurl` varchar(200) NOT NULL default '',
`checked` tinyint(1) NOT NULL default '0',
`tmptime` datetime NOT NULL default '0000-00-00 00:00:00',
`userid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(20) NOT NULL default '',
`truetime` int(10) unsigned NOT NULL default '0',
`keyboard` varchar(100) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`newstime` datetime NOT NULL default '0000-00-00 00:00:00',
`titlepic` varchar(120) NOT NULL default '',
`ftitle` varchar(120) NOT NULL default '',
`smalltext` varchar(255) NOT NULL default '',
`writer` varchar(30) NOT NULL default '',
`befrom` varchar(60) NOT NULL default '',
`newstext` mediumtext NOT NULL,
`diggtop` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `classid` (`classid`),
KEY `checked` (`checked`)
) TYPE=MyISAM;
# --------------------------- download -----------------------------
DROP TABLE IF EXISTS `phome_ecms_download`;
CREATE TABLE `phome_ecms_download` (
`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` varchar(20) NOT NULL default '',
`filename` varchar(36) NOT NULL default '',
`userid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(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` varchar(14) NOT NULL default '',
`titleurl` varchar(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` varchar(80) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`newstime` int(10) unsigned NOT NULL default '0',
`titlepic` varchar(120) NOT NULL default '',
`eckuid` int(11) NOT NULL default '0',
`softfj` varchar(255) NOT NULL default '',
`language` varchar(16) NOT NULL default '',
`softtype` varchar(16) NOT NULL default '',
`softsq` varchar(16) NOT NULL default '',
`star` tinyint(1) NOT NULL default '0',
`filetype` varchar(10) NOT NULL default '',
`filesize` varchar(16) NOT NULL default '',
`softsay` text NOT NULL,
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_download_check`;
CREATE TABLE `phome_ecms_download_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` varchar(20) NOT NULL default '',
`filename` varchar(36) NOT NULL default '',
`userid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(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` varchar(14) NOT NULL default '',
`titleurl` varchar(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` varchar(80) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`newstime` int(10) unsigned NOT NULL default '0',
`titlepic` varchar(120) NOT NULL default '',
`eckuid` int(11) NOT NULL default '0',
`softfj` varchar(255) NOT NULL default '',
`language` varchar(16) NOT NULL default '',
`softtype` varchar(16) NOT NULL default '',
`softsq` varchar(16) NOT NULL default '',
`star` tinyint(1) NOT NULL default '0',
`filetype` varchar(10) NOT NULL default '',
`filesize` varchar(16) NOT NULL default '',
`softsay` text NOT NULL,
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_download_check_data`;
CREATE TABLE `phome_ecms_download_check_data` (
`id` int(10) unsigned NOT NULL default '0',
`classid` smallint(5) unsigned NOT NULL default '0',
`keyid` varchar(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` varchar(80) NOT NULL default '',
`softwriter` varchar(30) NOT NULL default '',
`homepage` varchar(80) NOT NULL default '',
`demo` varchar(120) NOT NULL default '',
`downpath` mediumtext NOT NULL,
PRIMARY KEY (`id`),
KEY `classid` (`classid`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_download_data_1`;
CREATE TABLE `phome_ecms_download_data_1` (
`id` int(10) unsigned NOT NULL default '0',
`classid` smallint(5) unsigned NOT NULL default '0',
`keyid` varchar(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` varchar(80) NOT NULL default '',
`softwriter` varchar(30) NOT NULL default '',
`homepage` varchar(80) NOT NULL default '',
`demo` varchar(120) NOT NULL default '',
`downpath` mediumtext NOT NULL,
PRIMARY KEY (`id`),
KEY `classid` (`classid`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_download_doc`;
CREATE TABLE `phome_ecms_download_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` varchar(20) NOT NULL default '',
`filename` varchar(36) NOT NULL default '',
`userid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(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` varchar(14) NOT NULL default '',
`titleurl` varchar(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` varchar(80) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`newstime` int(10) unsigned NOT NULL default '0',
`titlepic` varchar(120) NOT NULL default '',
`eckuid` int(11) NOT NULL default '0',
`softfj` varchar(255) NOT NULL default '',
`language` varchar(16) NOT NULL default '',
`softtype` varchar(16) NOT NULL default '',
`softsq` varchar(16) NOT NULL default '',
`star` tinyint(1) NOT NULL default '0',
`filetype` varchar(10) NOT NULL default '',
`filesize` varchar(16) NOT NULL default '',
`softsay` text NOT NULL,
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_download_doc_data`;
CREATE TABLE `phome_ecms_download_doc_data` (
`id` int(10) unsigned NOT NULL default '0',
`classid` smallint(5) unsigned NOT NULL default '0',
`keyid` varchar(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` varchar(80) NOT NULL default '',
`softwriter` varchar(30) NOT NULL default '',
`homepage` varchar(80) NOT NULL default '',
`demo` varchar(120) NOT NULL default '',
`downpath` mediumtext NOT NULL,
PRIMARY KEY (`id`),
KEY `classid` (`classid`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_download_doc_index`;
CREATE TABLE `phome_ecms_download_doc_index` (
`id` int(10) unsigned NOT NULL auto_increment,
`classid` smallint(5) unsigned NOT NULL default '0',
`checked` tinyint(1) NOT NULL default '0',
`newstime` int(10) unsigned 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',
PRIMARY KEY (`id`),
KEY `classid` (`classid`),
KEY `checked` (`checked`),
KEY `newstime` (`newstime`),
KEY `truetime` (`truetime`,`id`),
KEY `havehtml` (`classid`,`truetime`,`havehtml`,`checked`,`id`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_download_index`;
CREATE TABLE `phome_ecms_download_index` (
`id` int(10) unsigned NOT NULL auto_increment,
`classid` smallint(5) unsigned NOT NULL default '0',
`checked` tinyint(1) NOT NULL default '0',
`newstime` int(10) unsigned 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',
PRIMARY KEY (`id`),
KEY `classid` (`classid`),
KEY `checked` (`checked`),
KEY `newstime` (`newstime`),
KEY `truetime` (`truetime`,`id`),
KEY `havehtml` (`classid`,`truetime`,`havehtml`,`checked`,`id`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_infoclass_download`;
CREATE TABLE `phome_ecms_infoclass_download` (
`classid` int(10) unsigned NOT NULL default '0',
`zz_title` text NOT NULL,
`z_title` varchar(255) NOT NULL default '',
`qz_title` varchar(255) NOT NULL default '',
`save_title` varchar(10) NOT NULL default '',
`zz_titlepic` text NOT NULL,
`z_titlepic` varchar(255) NOT NULL default '',
`qz_titlepic` varchar(255) NOT NULL default '',
`save_titlepic` varchar(10) NOT NULL default '',
`zz_newstime` text NOT NULL,
`z_newstime` varchar(255) NOT NULL default '',
`qz_newstime` varchar(255) NOT NULL default '',
`save_newstime` varchar(10) NOT NULL default '',
`zz_softwriter` text NOT NULL,
`z_softwriter` varchar(255) NOT NULL default '',
`qz_softwriter` varchar(255) NOT NULL default '',
`save_softwriter` varchar(10) NOT NULL default '',
`zz_homepage` text NOT NULL,
`z_homepage` varchar(255) NOT NULL default '',
`qz_homepage` varchar(255) NOT NULL default '',
`save_homepage` varchar(10) NOT NULL default '',
`zz_demo` text NOT NULL,
`z_demo` varchar(255) NOT NULL default '',
`qz_demo` varchar(255) NOT NULL default '',
`save_demo` varchar(10) NOT NULL default '',
`zz_softfj` text NOT NULL,
`z_softfj` varchar(255) NOT NULL default '',
`qz_softfj` varchar(255) NOT NULL default '',
`save_softfj` varchar(10) NOT NULL default '',
`zz_language` text NOT NULL,
`z_language` varchar(255) NOT NULL default '',
`qz_language` varchar(255) NOT NULL default '',
`save_language` varchar(10) NOT NULL default '',
`zz_softtype` text NOT NULL,
`z_softtype` varchar(255) NOT NULL default '',
`qz_softtype` varchar(255) NOT NULL default '',
`save_softtype` varchar(10) NOT NULL default '',
`zz_softsq` text NOT NULL,
`z_softsq` varchar(255) NOT NULL default '',
`qz_softsq` varchar(255) NOT NULL default '',
`save_softsq` varchar(10) NOT NULL default '',
`zz_star` text NOT NULL,
`z_star` varchar(255) NOT NULL default '',
`qz_star` varchar(255) NOT NULL default '',
`save_star` varchar(10) NOT NULL default '',
`zz_filetype` text NOT NULL,
`z_filetype` varchar(255) NOT NULL default '',
`qz_filetype` varchar(255) NOT NULL default '',
`save_filetype` varchar(10) NOT NULL default '',
`zz_filesize` text NOT NULL,
`z_filesize` varchar(255) NOT NULL default '',
`qz_filesize` varchar(255) NOT NULL default '',
`save_filesize` varchar(10) NOT NULL default '',
`zz_downpath` text NOT NULL,
`z_downpath` varchar(255) NOT NULL default '',
`qz_downpath` varchar(255) NOT NULL default '',
`save_downpath` varchar(10) NOT NULL default '',
`zz_softsay` text NOT NULL,
`z_softsay` varchar(255) NOT NULL default '',
`qz_softsay` varchar(255) NOT NULL default '',
`save_softsay` varchar(10) NOT NULL default '',
PRIMARY KEY (`classid`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_infotmp_download`;
CREATE TABLE `phome_ecms_infotmp_download` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`classid` int(10) unsigned NOT NULL default '0',
`oldurl` varchar(200) NOT NULL default '',
`checked` tinyint(1) NOT NULL default '0',
`tmptime` datetime NOT NULL default '0000-00-00 00:00:00',
`userid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(20) NOT NULL default '',
`truetime` int(10) unsigned NOT NULL default '0',
`keyboard` varchar(100) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`newstime` datetime NOT NULL default '0000-00-00 00:00:00',
`titlepic` varchar(120) NOT NULL default '',
`softwriter` varchar(30) NOT NULL default '',
`homepage` varchar(80) NOT NULL default '',
`demo` varchar(120) NOT NULL default '',
`softfj` varchar(255) NOT NULL default '',
`language` varchar(16) NOT NULL default '',
`softtype` varchar(16) NOT NULL default '',
`softsq` varchar(16) NOT NULL default '',
`star` tinyint(1) NOT NULL default '0',
`filetype` varchar(10) NOT NULL default '',
`filesize` varchar(16) NOT NULL default '',
`downpath` mediumtext NOT NULL,
`softsay` text NOT NULL,
PRIMARY KEY (`id`),
KEY `classid` (`classid`),
KEY `checked` (`checked`)
) TYPE=MyISAM;
# --------------------------- flash ------------------------------
DROP TABLE IF EXISTS `phome_ecms_flash`;
CREATE TABLE `phome_ecms_flash` (
`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` varchar(20) NOT NULL default '',
`filename` varchar(36) NOT NULL default '',
`userid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(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` varchar(14) NOT NULL default '',
`titleurl` varchar(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` varchar(80) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`newstime` int(10) unsigned NOT NULL default '0',
`titlepic` varchar(120) NOT NULL default '',
`eckuid` int(11) NOT NULL default '0',
`flashwriter` varchar(30) NOT NULL default '',
`email` varchar(80) NOT NULL default '',
`star` tinyint(1) NOT NULL default '0',
`filesize` varchar(16) NOT NULL default '',
`flashurl` varchar(255) NOT NULL default '',
`width` varchar(12) NOT NULL default '',
`height` varchar(12) NOT NULL default '',
`flashsay` text NOT NULL,
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_flash_check`;
CREATE TABLE `phome_ecms_flash_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` varchar(20) NOT NULL default '',
`filename` varchar(36) NOT NULL default '',
`userid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(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` varchar(14) NOT NULL default '',
`titleurl` varchar(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` varchar(80) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`newstime` int(10) unsigned NOT NULL default '0',
`titlepic` varchar(120) NOT NULL default '',
`eckuid` int(11) NOT NULL default '0',
`flashwriter` varchar(30) NOT NULL default '',
`email` varchar(80) NOT NULL default '',
`star` tinyint(1) NOT NULL default '0',
`filesize` varchar(16) NOT NULL default '',
`flashurl` varchar(255) NOT NULL default '',
`width` varchar(12) NOT NULL default '',
`height` varchar(12) NOT NULL default '',
`flashsay` text NOT NULL,
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_flash_check_data`;
CREATE TABLE `phome_ecms_flash_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_flash_data_1`;
CREATE TABLE `phome_ecms_flash_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_flash_doc`;
CREATE TABLE `phome_ecms_flash_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` varchar(20) NOT NULL default '',
`filename` varchar(36) NOT NULL default '',
`userid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(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` varchar(14) NOT NULL default '',
`titleurl` varchar(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` varchar(80) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`newstime` int(10) unsigned NOT NULL default '0',
`titlepic` varchar(120) NOT NULL default '',
`eckuid` int(11) NOT NULL default '0',
`flashwriter` varchar(30) NOT NULL default '',
`email` varchar(80) NOT NULL default '',
`star` tinyint(1) NOT NULL default '0',
`filesize` varchar(16) NOT NULL default '',
`flashurl` varchar(255) NOT NULL default '',
`width` varchar(12) NOT NULL default '',
`height` varchar(12) NOT NULL default '',
`flashsay` text NOT NULL,
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_flash_doc_data`;
CREATE TABLE `phome_ecms_flash_doc_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_flash_doc_index`;
CREATE TABLE `phome_ecms_flash_doc_index` (
`id` int(10) unsigned NOT NULL auto_increment,
`classid` smallint(5) unsigned NOT NULL default '0',
`checked` tinyint(1) NOT NULL default '0',
`newstime` int(10) unsigned 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',
PRIMARY KEY (`id`),
KEY `classid` (`classid`),
KEY `checked` (`checked`),
KEY `newstime` (`newstime`),
KEY `truetime` (`truetime`,`id`),
KEY `havehtml` (`classid`,`truetime`,`havehtml`,`checked`,`id`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_flash_index`;
CREATE TABLE `phome_ecms_flash_index` (
`id` int(10) unsigned NOT NULL auto_increment,
`classid` smallint(5) unsigned NOT NULL default '0',
`checked` tinyint(1) NOT NULL default '0',
`newstime` int(10) unsigned 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',
PRIMARY KEY (`id`),
KEY `classid` (`classid`),
KEY `checked` (`checked`),
KEY `newstime` (`newstime`),
KEY `truetime` (`truetime`,`id`),
KEY `havehtml` (`classid`,`truetime`,`havehtml`,`checked`,`id`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_infoclass_flash`;
CREATE TABLE `phome_ecms_infoclass_flash` (
`classid` int(10) unsigned NOT NULL default '0',
`zz_title` text NOT NULL,
`z_title` varchar(255) NOT NULL default '',
`qz_title` varchar(255) NOT NULL default '',
`save_title` varchar(10) NOT NULL default '',
`zz_titlepic` text NOT NULL,
`z_titlepic` varchar(255) NOT NULL default '',
`qz_titlepic` varchar(255) NOT NULL default '',
`save_titlepic` varchar(10) NOT NULL default '',
`zz_newstime` text NOT NULL,
`z_newstime` varchar(255) NOT NULL default '',
`qz_newstime` varchar(255) NOT NULL default '',
`save_newstime` varchar(10) NOT NULL default '',
`zz_flashwriter` text NOT NULL,
`z_flashwriter` varchar(255) NOT NULL default '',
`qz_flashwriter` varchar(255) NOT NULL default '',
`save_flashwriter` varchar(10) NOT NULL default '',
`zz_email` text NOT NULL,
`z_email` varchar(255) NOT NULL default '',
`qz_email` varchar(255) NOT NULL default '',
`save_email` varchar(10) NOT NULL default '',
`zz_star` text NOT NULL,
`z_star` varchar(255) NOT NULL default '',
`qz_star` varchar(255) NOT NULL default '',
`save_star` varchar(10) NOT NULL default '',
`zz_filesize` text NOT NULL,
`z_filesize` varchar(255) NOT NULL default '',
`qz_filesize` varchar(255) NOT NULL default '',
`save_filesize` varchar(10) NOT NULL default '',
`zz_flashurl` text NOT NULL,
`z_flashurl` varchar(255) NOT NULL default '',
`qz_flashurl` varchar(255) NOT NULL default '',
`save_flashurl` varchar(10) NOT NULL default '',
`zz_width` text NOT NULL,
`z_width` varchar(255) NOT NULL default '',
`qz_width` varchar(255) NOT NULL default '',
`save_width` varchar(10) NOT NULL default '',
`zz_height` text NOT NULL,
`z_height` varchar(255) NOT NULL default '',
`qz_height` varchar(255) NOT NULL default '',
`save_height` varchar(10) NOT NULL default '',
`zz_flashsay` text NOT NULL,
`z_flashsay` varchar(255) NOT NULL default '',
`qz_flashsay` varchar(255) NOT NULL default '',
`save_flashsay` varchar(10) NOT NULL default '',
PRIMARY KEY (`classid`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_infotmp_flash`;
CREATE TABLE `phome_ecms_infotmp_flash` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`classid` int(10) unsigned NOT NULL default '0',
`oldurl` varchar(200) NOT NULL default '',
`checked` tinyint(1) NOT NULL default '0',
`tmptime` datetime NOT NULL default '0000-00-00 00:00:00',
`userid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(20) NOT NULL default '',
`truetime` int(10) unsigned NOT NULL default '0',
`keyboard` varchar(100) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`newstime` datetime NOT NULL default '0000-00-00 00:00:00',
`titlepic` varchar(120) NOT NULL default '',
`flashwriter` varchar(30) NOT NULL default '',
`email` varchar(80) NOT NULL default '',
`star` tinyint(1) NOT NULL default '0',
`filesize` varchar(16) NOT NULL default '',
`flashurl` varchar(255) NOT NULL default '',
`width` varchar(12) NOT NULL default '',
`height` varchar(12) NOT NULL default '',
`flashsay` text NOT NULL,
PRIMARY KEY (`id`),
KEY `classid` (`classid`),
KEY `checked` (`checked`)
) TYPE=MyISAM;
# --------------------------- info -----------------------------
DROP TABLE IF EXISTS `phome_ecms_info`;
CREATE TABLE `phome_ecms_info` (
`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` varchar(20) NOT NULL default '',
`filename` varchar(36) NOT NULL default '',
`userid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(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` varchar(14) NOT NULL default '',
`titleurl` varchar(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` varchar(80) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`newstime` int(10) unsigned NOT NULL default '0',
`titlepic` varchar(120) NOT NULL default '',
`eckuid` int(11) NOT NULL default '0',
`smalltext` text NOT NULL,
`myarea` varchar(30) NOT NULL default '',
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_info_check`;
CREATE TABLE `phome_ecms_info_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` varchar(20) NOT NULL default '',
`filename` varchar(36) NOT NULL default '',
`userid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(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` varchar(14) NOT NULL default '',
`titleurl` varchar(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` varchar(80) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`newstime` int(10) unsigned NOT NULL default '0',
`titlepic` varchar(120) NOT NULL default '',
`eckuid` int(11) NOT NULL default '0',
`smalltext` text NOT NULL,
`myarea` varchar(30) NOT NULL default '',
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_info_check_data`;
CREATE TABLE `phome_ecms_info_check_data` (
`id` int(10) unsigned NOT NULL default '0',
`classid` smallint(5) unsigned NOT NULL default '0',
`keyid` varchar(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` varchar(80) NOT NULL default '',
`email` varchar(80) NOT NULL default '',
`mycontact` varchar(255) NOT NULL default '',
`address` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `classid` (`classid`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_info_data_1`;
CREATE TABLE `phome_ecms_info_data_1` (
`id` int(10) unsigned NOT NULL default '0',
`classid` smallint(5) unsigned NOT NULL default '0',
`keyid` varchar(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` varchar(80) NOT NULL default '',
`email` varchar(80) NOT NULL default '',
`mycontact` varchar(255) NOT NULL default '',
`address` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `classid` (`classid`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_info_doc`;
CREATE TABLE `phome_ecms_info_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` varchar(20) NOT NULL default '',
`filename` varchar(36) NOT NULL default '',
`userid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(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` varchar(14) NOT NULL default '',
`titleurl` varchar(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` varchar(80) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`newstime` int(10) unsigned NOT NULL default '0',
`titlepic` varchar(120) NOT NULL default '',
`eckuid` int(11) NOT NULL default '0',
`smalltext` text NOT NULL,
`myarea` varchar(30) NOT NULL default '',
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_info_doc_data`;
CREATE TABLE `phome_ecms_info_doc_data` (
`id` int(10) unsigned NOT NULL default '0',
`classid` smallint(5) unsigned NOT NULL default '0',
`keyid` varchar(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` varchar(80) NOT NULL default '',
`email` varchar(80) NOT NULL default '',
`mycontact` varchar(255) NOT NULL default '',
`address` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `classid` (`classid`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_info_doc_index`;
CREATE TABLE `phome_ecms_info_doc_index` (
`id` int(10) unsigned NOT NULL auto_increment,
`classid` smallint(5) unsigned NOT NULL default '0',
`checked` tinyint(1) NOT NULL default '0',
`newstime` int(10) unsigned 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',
PRIMARY KEY (`id`),
KEY `classid` (`classid`),
KEY `checked` (`checked`),
KEY `newstime` (`newstime`),
KEY `truetime` (`truetime`,`id`),
KEY `havehtml` (`classid`,`truetime`,`havehtml`,`checked`,`id`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_info_index`;
CREATE TABLE `phome_ecms_info_index` (
`id` int(10) unsigned NOT NULL auto_increment,
`classid` smallint(5) unsigned NOT NULL default '0',
`checked` tinyint(1) NOT NULL default '0',
`newstime` int(10) unsigned 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',
PRIMARY KEY (`id`),
KEY `classid` (`classid`),
KEY `checked` (`checked`),
KEY `newstime` (`newstime`),
KEY `truetime` (`truetime`,`id`),
KEY `havehtml` (`classid`,`truetime`,`havehtml`,`checked`,`id`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_infoclass_info`;
CREATE TABLE `phome_ecms_infoclass_info` (
`classid` int(10) unsigned NOT NULL default '0',
`zz_title` text NOT NULL,
`z_title` varchar(255) NOT NULL default '',
`qz_title` varchar(255) NOT NULL default '',
`save_title` varchar(10) NOT NULL default '',
`zz_titlepic` text NOT NULL,
`z_titlepic` varchar(255) NOT NULL default '',
`qz_titlepic` varchar(255) NOT NULL default '',
`save_titlepic` varchar(10) NOT NULL default '',
`zz_newstime` text NOT NULL,
`z_newstime` varchar(255) NOT NULL default '',
`qz_newstime` varchar(255) NOT NULL default '',
`save_newstime` varchar(10) NOT NULL default '',
`zz_smalltext` text NOT NULL,
`z_smalltext` varchar(255) NOT NULL default '',
`qz_smalltext` varchar(255) NOT NULL default '',
`save_smalltext` varchar(10) NOT NULL default '',
`zz_myarea` text NOT NULL,
`z_myarea` varchar(255) NOT NULL default '',
`qz_myarea` varchar(255) NOT NULL default '',
`save_myarea` varchar(10) NOT NULL default '',
`zz_email` text NOT NULL,
`z_email` varchar(255) NOT NULL default '',
`qz_email` varchar(255) NOT NULL default '',
`save_email` varchar(10) NOT NULL default '',
`zz_mycontact` text NOT NULL,
`z_mycontact` varchar(255) NOT NULL default '',
`qz_mycontact` varchar(255) NOT NULL default '',
`save_mycontact` varchar(10) NOT NULL default '',
`zz_address` text NOT NULL,
`z_address` varchar(255) NOT NULL default '',
`qz_address` varchar(255) NOT NULL default '',
`save_address` varchar(10) NOT NULL default '',
PRIMARY KEY (`classid`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_infotmp_info`;
CREATE TABLE `phome_ecms_infotmp_info` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`classid` int(10) unsigned NOT NULL default '0',
`oldurl` varchar(200) NOT NULL default '',
`checked` tinyint(1) NOT NULL default '0',
`tmptime` datetime NOT NULL default '0000-00-00 00:00:00',
`userid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(20) NOT NULL default '',
`truetime` int(10) unsigned NOT NULL default '0',
`keyboard` varchar(100) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`newstime` datetime NOT NULL default '0000-00-00 00:00:00',
`titlepic` varchar(120) NOT NULL default '',
`smalltext` text NOT NULL,
`myarea` varchar(30) NOT NULL default '',
`email` varchar(80) NOT NULL default '',
`mycontact` varchar(255) NOT NULL default '',
`address` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `classid` (`classid`),
KEY `checked` (`checked`)
) TYPE=MyISAM;
# --------------------------- movie -----------------------------
DROP TABLE IF EXISTS `phome_ecms_infoclass_movie`;
CREATE TABLE `phome_ecms_infoclass_movie` (
`classid` int(10) unsigned NOT NULL default '0',
`zz_title` text NOT NULL,
`z_title` varchar(255) NOT NULL default '',
`qz_title` varchar(255) NOT NULL default '',
`save_title` varchar(10) NOT NULL default '',
`zz_titlepic` text NOT NULL,
`z_titlepic` varchar(255) NOT NULL default '',
`qz_titlepic` varchar(255) NOT NULL default '',
`save_titlepic` varchar(10) NOT NULL default '',
`zz_newstime` text NOT NULL,
`z_newstime` varchar(255) NOT NULL default '',
`qz_newstime` varchar(255) NOT NULL default '',
`save_newstime` varchar(10) NOT NULL default '',
`zz_movietype` text NOT NULL,
`z_movietype` varchar(255) NOT NULL default '',
`qz_movietype` varchar(255) NOT NULL default '',
`save_movietype` varchar(10) NOT NULL default '',
`zz_company` text NOT NULL,
`z_company` varchar(255) NOT NULL default '',
`qz_company` varchar(255) NOT NULL default '',
`save_company` varchar(10) NOT NULL default '',
`zz_movietime` text NOT NULL,
`z_movietime` varchar(255) NOT NULL default '',
`qz_movietime` varchar(255) NOT NULL default '',
`save_movietime` varchar(10) NOT NULL default '',
`zz_player` text NOT NULL,
`z_player` varchar(255) NOT NULL default '',
`qz_player` varchar(255) NOT NULL default '',
`save_player` varchar(10) NOT NULL default '',
`zz_playadmin` text NOT NULL,
`z_playadmin` varchar(255) NOT NULL default '',
`qz_playadmin` varchar(255) NOT NULL default '',
`save_playadmin` varchar(10) NOT NULL default '',
`zz_filetype` text NOT NULL,
`z_filetype` varchar(255) NOT NULL default '',
`qz_filetype` varchar(255) NOT NULL default '',
`save_filetype` varchar(10) NOT NULL default '',
`zz_filesize` text NOT NULL,
`z_filesize` varchar(255) NOT NULL default '',
`qz_filesize` varchar(255) NOT NULL default '',
`save_filesize` varchar(10) NOT NULL default '',
`zz_star` text NOT NULL,
`z_star` varchar(255) NOT NULL default '',
`qz_star` varchar(255) NOT NULL default '',
`save_star` varchar(10) NOT NULL default '',
`zz_playdk` text NOT NULL,
`z_playdk` varchar(255) NOT NULL default '',
`qz_playdk` varchar(255) NOT NULL default '',
`save_playdk` varchar(10) NOT NULL default '',
`zz_playtime` text NOT NULL,
`z_playtime` varchar(255) NOT NULL default '',
`qz_playtime` varchar(255) NOT NULL default '',
`save_playtime` varchar(10) NOT NULL default '',
`zz_moviefen` text NOT NULL,
`z_moviefen` varchar(255) NOT NULL default '',
`qz_moviefen` varchar(255) NOT NULL default '',
`save_moviefen` varchar(10) NOT NULL default '',
`zz_downpath` text NOT NULL,
`z_downpath` varchar(255) NOT NULL default '',
`qz_downpath` varchar(255) NOT NULL default '',
`save_downpath` varchar(10) NOT NULL default '',
`zz_playerid` text NOT NULL,
`z_playerid` varchar(255) NOT NULL default '',
`qz_playerid` varchar(255) NOT NULL default '',
`save_playerid` varchar(10) NOT NULL default '',
`zz_onlinepath` text NOT NULL,
`z_onlinepath` varchar(255) NOT NULL default '',
`qz_onlinepath` varchar(255) NOT NULL default '',
`save_onlinepath` varchar(10) NOT NULL default '',
`zz_moviesay` text NOT NULL,
`z_moviesay` varchar(255) NOT NULL default '',
`qz_moviesay` varchar(255) NOT NULL default '',
`save_moviesay` varchar(10) NOT NULL default '',
PRIMARY KEY (`classid`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_infotmp_movie`;
CREATE TABLE `phome_ecms_infotmp_movie` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`classid` int(10) unsigned NOT NULL default '0',
`oldurl` varchar(200) NOT NULL default '',
`checked` tinyint(1) NOT NULL default '0',
`tmptime` datetime NOT NULL default '0000-00-00 00:00:00',
`userid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(20) NOT NULL default '',
`truetime` int(10) unsigned NOT NULL default '0',
`keyboard` varchar(100) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`newstime` datetime NOT NULL default '0000-00-00 00:00:00',
`titlepic` varchar(120) NOT NULL default '',
`movietype` varchar(16) NOT NULL default '',
`company` varchar(200) NOT NULL default '',
`movietime` varchar(20) NOT NULL default '',
`player` varchar(255) NOT NULL default '',
`playadmin` varchar(255) NOT NULL default '',
`filetype` varchar(10) NOT NULL default '',
`filesize` varchar(16) NOT NULL default '',
`star` tinyint(1) NOT NULL default '0',
`playdk` varchar(30) NOT NULL default '',
`playtime` varchar(20) NOT NULL default '',
`moviefen` int(11) NOT NULL default '0',
`downpath` mediumtext NOT NULL,
`playerid` smallint(6) NOT NULL default '0',
`onlinepath` mediumtext NOT NULL,
`moviesay` text NOT NULL,
PRIMARY KEY (`id`),
KEY `classid` (`classid`),
KEY `checked` (`checked`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_movie`;
CREATE TABLE `phome_ecms_movie` (
`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` varchar(20) NOT NULL default '',
`filename` varchar(36) NOT NULL default '',
`userid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(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` varchar(14) NOT NULL default '',
`titleurl` varchar(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` varchar(80) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`newstime` int(10) unsigned NOT NULL default '0',
`titlepic` varchar(120) NOT NULL default '',
`eckuid` int(11) NOT NULL default '0',
`movietype` varchar(16) NOT NULL default '',
`company` varchar(200) NOT NULL default '',
`movietime` varchar(20) NOT NULL default '',
`player` varchar(255) NOT NULL default '',
`playadmin` varchar(255) NOT NULL default '',
`filetype` varchar(10) NOT NULL default '',
`filesize` varchar(16) NOT NULL default '',
`star` tinyint(1) NOT NULL default '0',
`moviefen` int(11) NOT NULL default '0',
`moviesay` text NOT NULL,
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_movie_check`;
CREATE TABLE `phome_ecms_movie_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` varchar(20) NOT NULL default '',
`filename` varchar(36) NOT NULL default '',
`userid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(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` varchar(14) NOT NULL default '',
`titleurl` varchar(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` varchar(80) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`newstime` int(10) unsigned NOT NULL default '0',
`titlepic` varchar(120) NOT NULL default '',
`eckuid` int(11) NOT NULL default '0',
`movietype` varchar(16) NOT NULL default '',
`company` varchar(200) NOT NULL default '',
`movietime` varchar(20) NOT NULL default '',
`player` varchar(255) NOT NULL default '',
`playadmin` varchar(255) NOT NULL default '',
`filetype` varchar(10) NOT NULL default '',
`filesize` varchar(16) NOT NULL default '',
`star` tinyint(1) NOT NULL default '0',
`moviefen` int(11) NOT NULL default '0',
`moviesay` text NOT NULL,
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_movie_check_data`;
CREATE TABLE `phome_ecms_movie_check_data` (
`id` int(10) unsigned NOT NULL default '0',
`classid` smallint(5) unsigned NOT NULL default '0',
`keyid` varchar(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` varchar(80) NOT NULL default '',
`playdk` varchar(30) NOT NULL default '',
`playtime` varchar(20) NOT NULL default '',
`downpath` mediumtext NOT NULL,
`playerid` smallint(6) NOT NULL default '0',
`onlinepath` mediumtext NOT NULL,
PRIMARY KEY (`id`),
KEY `classid` (`classid`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_movie_data_1`;
CREATE TABLE `phome_ecms_movie_data_1` (
`id` int(10) unsigned NOT NULL default '0',
`classid` smallint(5) unsigned NOT NULL default '0',
`keyid` varchar(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` varchar(80) NOT NULL default '',
`playdk` varchar(30) NOT NULL default '',
`playtime` varchar(20) NOT NULL default '',
`downpath` mediumtext NOT NULL,
`playerid` smallint(6) NOT NULL default '0',
`onlinepath` mediumtext NOT NULL,
PRIMARY KEY (`id`),
KEY `classid` (`classid`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_movie_doc`;
CREATE TABLE `phome_ecms_movie_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` varchar(20) NOT NULL default '',
`filename` varchar(36) NOT NULL default '',
`userid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(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` varchar(14) NOT NULL default '',
`titleurl` varchar(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` varchar(80) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`newstime` int(10) unsigned NOT NULL default '0',
`titlepic` varchar(120) NOT NULL default '',
`eckuid` int(11) NOT NULL default '0',
`movietype` varchar(16) NOT NULL default '',
`company` varchar(200) NOT NULL default '',
`movietime` varchar(20) NOT NULL default '',
`player` varchar(255) NOT NULL default '',
`playadmin` varchar(255) NOT NULL default '',
`filetype` varchar(10) NOT NULL default '',
`filesize` varchar(16) NOT NULL default '',
`star` tinyint(1) NOT NULL default '0',
`moviefen` int(11) NOT NULL default '0',
`moviesay` text NOT NULL,
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_movie_doc_data`;
CREATE TABLE `phome_ecms_movie_doc_data` (
`id` int(10) unsigned NOT NULL default '0',
`classid` smallint(5) unsigned NOT NULL default '0',
`keyid` varchar(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` varchar(80) NOT NULL default '',
`playdk` varchar(30) NOT NULL default '',
`playtime` varchar(20) NOT NULL default '',
`downpath` mediumtext NOT NULL,
`playerid` smallint(6) NOT NULL default '0',
`onlinepath` mediumtext NOT NULL,
PRIMARY KEY (`id`),
KEY `classid` (`classid`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_movie_doc_index`;
CREATE TABLE `phome_ecms_movie_doc_index` (
`id` int(10) unsigned NOT NULL auto_increment,
`classid` smallint(5) unsigned NOT NULL default '0',
`checked` tinyint(1) NOT NULL default '0',
`newstime` int(10) unsigned 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',
PRIMARY KEY (`id`),
KEY `classid` (`classid`),
KEY `checked` (`checked`),
KEY `newstime` (`newstime`),
KEY `truetime` (`truetime`,`id`),
KEY `havehtml` (`classid`,`truetime`,`havehtml`,`checked`,`id`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_movie_index`;
CREATE TABLE `phome_ecms_movie_index` (
`id` int(10) unsigned NOT NULL auto_increment,
`classid` smallint(5) unsigned NOT NULL default '0',
`checked` tinyint(1) NOT NULL default '0',
`newstime` int(10) unsigned 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',
PRIMARY KEY (`id`),
KEY `classid` (`classid`),
KEY `checked` (`checked`),
KEY `newstime` (`newstime`),
KEY `truetime` (`truetime`,`id`),
KEY `havehtml` (`classid`,`truetime`,`havehtml`,`checked`,`id`)
) TYPE=MyISAM;
# --------------------------- news -----------------------------
DROP TABLE IF EXISTS `phome_ecms_infoclass_news`;
CREATE TABLE `phome_ecms_infoclass_news` (
`classid` int(10) unsigned NOT NULL default '0',
`zz_title` text NOT NULL,
`z_title` varchar(255) NOT NULL default '',
`qz_title` varchar(255) NOT NULL default '',
`save_title` varchar(10) NOT NULL default '',
`zz_titlepic` text NOT NULL,
`z_titlepic` varchar(255) NOT NULL default '',
`qz_titlepic` varchar(255) NOT NULL default '',
`save_titlepic` varchar(10) NOT NULL default '',
`zz_newstime` text NOT NULL,
`z_newstime` varchar(255) NOT NULL default '',
`qz_newstime` varchar(255) NOT NULL default '',
`save_newstime` varchar(10) NOT NULL default '',
`zz_ftitle` text NOT NULL,
`z_ftitle` varchar(255) NOT NULL default '',
`qz_ftitle` varchar(255) NOT NULL default '',
`save_ftitle` varchar(10) NOT NULL default '',
`zz_smalltext` text NOT NULL,
`z_smalltext` varchar(255) NOT NULL default '',
`qz_smalltext` varchar(255) NOT NULL default '',
`save_smalltext` varchar(10) NOT NULL default '',
`zz_writer` text NOT NULL,
`z_writer` varchar(255) NOT NULL default '',
`qz_writer` varchar(255) NOT NULL default '',
`save_writer` varchar(10) NOT NULL default '',
`zz_befrom` text NOT NULL,
`z_befrom` varchar(255) NOT NULL default '',
`qz_befrom` varchar(255) NOT NULL default '',
`save_befrom` varchar(10) NOT NULL default '',
`zz_newstext` text NOT NULL,
`z_newstext` varchar(255) NOT NULL default '',
`qz_newstext` varchar(255) NOT NULL default '',
`save_newstext` varchar(10) NOT NULL default '',
`zz_diggtop` text NOT NULL,
`z_diggtop` varchar(255) NOT NULL default '',
`qz_diggtop` varchar(255) NOT NULL default '',
`save_diggtop` varchar(10) NOT NULL default '',
PRIMARY KEY (`classid`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_infotmp_news`;
CREATE TABLE `phome_ecms_infotmp_news` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`classid` int(10) unsigned NOT NULL default '0',
`oldurl` varchar(200) NOT NULL default '',
`checked` tinyint(1) NOT NULL default '0',
`tmptime` datetime NOT NULL default '0000-00-00 00:00:00',
`userid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(20) NOT NULL default '',
`truetime` int(10) unsigned NOT NULL default '0',
`keyboard` varchar(100) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`newstime` datetime NOT NULL default '0000-00-00 00:00:00',
`titlepic` varchar(120) NOT NULL default '',
`ftitle` varchar(120) NOT NULL default '',
`smalltext` varchar(255) NOT NULL default '',
`writer` varchar(30) NOT NULL default '',
`befrom` varchar(60) NOT NULL default '',
`newstext` mediumtext NOT NULL,
`diggtop` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `classid` (`classid`),
KEY `checked` (`checked`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_news`;
CREATE TABLE `phome_ecms_news` (
`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 '',
`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_news_check`;
CREATE TABLE `phome_ecms_news_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 '',
`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_news_check_data`;
CREATE TABLE `phome_ecms_news_check_data` (
`id` int(10) unsigned NOT NULL default '0',
`classid` smallint(5) unsigned NOT NULL default '0',
`keyid` varchar(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` varchar(80) NOT NULL default '',
`writer` varchar(30) NOT NULL default '',
`befrom` varchar(60) NOT NULL default '',
`newstext` mediumtext NOT NULL,
PRIMARY KEY (`id`),
KEY `classid` (`classid`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_news_data_1`;
CREATE TABLE `phome_ecms_news_data_1` (
`id` int(10) unsigned NOT NULL default '0',
`classid` smallint(5) unsigned NOT NULL default '0',
`keyid` varchar(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` varchar(80) NOT NULL default '',
`writer` varchar(30) NOT NULL default '',
`befrom` varchar(60) NOT NULL default '',
`newstext` mediumtext NOT NULL,
PRIMARY KEY (`id`),
KEY `classid` (`classid`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_news_doc`;
CREATE TABLE `phome_ecms_news_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(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 '',
`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_news_doc_data`;
CREATE TABLE `phome_ecms_news_doc_data` (
`id` int(10) unsigned NOT NULL default '0',
`classid` smallint(5) unsigned NOT NULL default '0',
`keyid` varchar(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` varchar(80) NOT NULL default '',
`writer` varchar(30) NOT NULL default '',
`befrom` varchar(60) NOT NULL default '',
`newstext` mediumtext NOT NULL,
PRIMARY KEY (`id`),
KEY `classid` (`classid`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_news_doc_index`;
CREATE TABLE `phome_ecms_news_doc_index` (
`id` int(10) unsigned NOT NULL auto_increment,
`classid` smallint(5) unsigned NOT NULL default '0',
`checked` tinyint(1) NOT NULL default '0',
`newstime` int(10) unsigned 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',
PRIMARY KEY (`id`),
KEY `classid` (`classid`),
KEY `checked` (`checked`),
KEY `newstime` (`newstime`),
KEY `truetime` (`truetime`,`id`),
KEY `havehtml` (`classid`,`truetime`,`havehtml`,`checked`,`id`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_news_index`;
CREATE TABLE `phome_ecms_news_index` (
`id` int(10) unsigned NOT NULL auto_increment,
`classid` smallint(5) unsigned NOT NULL default '0',
`checked` tinyint(1) NOT NULL default '0',
`newstime` int(10) unsigned 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',
PRIMARY KEY (`id`),
KEY `classid` (`classid`),
KEY `checked` (`checked`),
KEY `newstime` (`newstime`),
KEY `truetime` (`truetime`,`id`),
KEY `havehtml` (`classid`,`truetime`,`havehtml`,`checked`,`id`)
) TYPE=MyISAM;
# --------------------------- photo -----------------------------
DROP TABLE IF EXISTS `phome_ecms_infoclass_photo`;
CREATE TABLE `phome_ecms_infoclass_photo` (
`classid` int(10) unsigned NOT NULL default '0',
`zz_title` text NOT NULL,
`z_title` varchar(255) NOT NULL default '',
`qz_title` varchar(255) NOT NULL default '',
`save_title` varchar(10) NOT NULL default '',
`zz_titlepic` text NOT NULL,
`z_titlepic` varchar(255) NOT NULL default '',
`qz_titlepic` varchar(255) NOT NULL default '',
`save_titlepic` varchar(10) NOT NULL default '',
`zz_newstime` text NOT NULL,
`z_newstime` varchar(255) NOT NULL default '',
`qz_newstime` varchar(255) NOT NULL default '',
`save_newstime` varchar(10) NOT NULL default '',
`zz_filesize` text NOT NULL,
`z_filesize` varchar(255) NOT NULL default '',
`qz_filesize` varchar(255) NOT NULL default '',
`save_filesize` varchar(10) NOT NULL default '',
`zz_picsize` text NOT NULL,
`z_picsize` varchar(255) NOT NULL default '',
`qz_picsize` varchar(255) NOT NULL default '',
`save_picsize` varchar(10) NOT NULL default '',
`zz_picfbl` text NOT NULL,
`z_picfbl` varchar(255) NOT NULL default '',
`qz_picfbl` varchar(255) NOT NULL default '',
`save_picfbl` varchar(10) NOT NULL default '',
`zz_picfrom` text NOT NULL,
`z_picfrom` varchar(255) NOT NULL default '',
`qz_picfrom` varchar(255) NOT NULL default '',
`save_picfrom` varchar(10) NOT NULL default '',
`zz_picurl` text NOT NULL,
`z_picurl` varchar(255) NOT NULL default '',
`qz_picurl` varchar(255) NOT NULL default '',
`save_picurl` varchar(10) NOT NULL default '',
`zz_morepic` text NOT NULL,
`z_morepic` varchar(255) NOT NULL default '',
`qz_morepic` varchar(255) NOT NULL default '',
`save_morepic` varchar(10) NOT NULL default '',
`zz_num` text NOT NULL,
`z_num` varchar(255) NOT NULL default '',
`qz_num` varchar(255) NOT NULL default '',
`save_num` varchar(10) NOT NULL default '',
`zz_width` text NOT NULL,
`z_width` varchar(255) NOT NULL default '',
`qz_width` varchar(255) NOT NULL default '',
`save_width` varchar(10) NOT NULL default '',
`zz_height` text NOT NULL,
`z_height` varchar(255) NOT NULL default '',
`qz_height` varchar(255) NOT NULL default '',
`save_height` varchar(10) NOT NULL default '',
`zz_picsay` text NOT NULL,
`z_picsay` varchar(255) NOT NULL default '',
`qz_picsay` varchar(255) NOT NULL default '',
`save_picsay` varchar(10) NOT NULL default '',
PRIMARY KEY (`classid`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_infotmp_photo`;
CREATE TABLE `phome_ecms_infotmp_photo` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`classid` int(10) unsigned NOT NULL default '0',
`oldurl` varchar(200) NOT NULL default '',
`checked` tinyint(1) NOT NULL default '0',
`tmptime` datetime NOT NULL default '0000-00-00 00:00:00',
`userid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(20) NOT NULL default '',
`truetime` int(10) unsigned NOT NULL default '0',
`keyboard` varchar(100) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`newstime` datetime NOT NULL default '0000-00-00 00:00:00',
`titlepic` varchar(120) NOT NULL default '',
`filesize` varchar(10) NOT NULL default '',
`picsize` varchar(20) NOT NULL default '',
`picfbl` varchar(20) NOT NULL default '',
`picfrom` varchar(120) NOT NULL default '',
`picurl` varchar(200) NOT NULL default '',
`morepic` mediumtext NOT NULL,
`num` tinyint(4) NOT NULL default '0',
`width` varchar(12) NOT NULL default '',
`height` varchar(12) NOT NULL default '',
`picsay` text NOT NULL,
PRIMARY KEY (`id`),
KEY `classid` (`classid`),
KEY `checked` (`checked`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_photo`;
CREATE TABLE `phome_ecms_photo` (
`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` varchar(20) NOT NULL default '',
`filename` varchar(36) NOT NULL default '',
`userid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(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` varchar(14) NOT NULL default '',
`titleurl` varchar(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` varchar(80) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`newstime` int(10) unsigned NOT NULL default '0',
`titlepic` varchar(120) NOT NULL default '',
`eckuid` int(11) NOT NULL default '0',
`picurl` varchar(200) NOT NULL default '',
`picsay` text NOT NULL,
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_photo_check`;
CREATE TABLE `phome_ecms_photo_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` varchar(20) NOT NULL default '',
`filename` varchar(36) NOT NULL default '',
`userid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(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` varchar(14) NOT NULL default '',
`titleurl` varchar(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` varchar(80) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`newstime` int(10) unsigned NOT NULL default '0',
`titlepic` varchar(120) NOT NULL default '',
`eckuid` int(11) NOT NULL default '0',
`picurl` varchar(200) NOT NULL default '',
`picsay` text NOT NULL,
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_photo_check_data`;
CREATE TABLE `phome_ecms_photo_check_data` (
`id` int(10) unsigned NOT NULL default '0',
`classid` smallint(5) unsigned NOT NULL default '0',
`keyid` varchar(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` varchar(80) NOT NULL default '',
`filesize` varchar(10) NOT NULL default '',
`picsize` varchar(20) NOT NULL default '',
`picfbl` varchar(20) NOT NULL default '',
`picfrom` varchar(120) NOT NULL default '',
`morepic` mediumtext NOT NULL,
`num` tinyint(4) NOT NULL default '0',
`width` varchar(12) NOT NULL default '',
`height` varchar(12) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `classid` (`classid`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_photo_data_1`;
CREATE TABLE `phome_ecms_photo_data_1` (
`id` int(10) unsigned NOT NULL default '0',
`classid` smallint(5) unsigned NOT NULL default '0',
`keyid` varchar(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` varchar(80) NOT NULL default '',
`filesize` varchar(10) NOT NULL default '',
`picsize` varchar(20) NOT NULL default '',
`picfbl` varchar(20) NOT NULL default '',
`picfrom` varchar(120) NOT NULL default '',
`morepic` mediumtext NOT NULL,
`num` tinyint(4) NOT NULL default '0',
`width` varchar(12) NOT NULL default '',
`height` varchar(12) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `classid` (`classid`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_photo_doc`;
CREATE TABLE `phome_ecms_photo_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` varchar(20) NOT NULL default '',
`filename` varchar(36) NOT NULL default '',
`userid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(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` varchar(14) NOT NULL default '',
`titleurl` varchar(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` varchar(80) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`newstime` int(10) unsigned NOT NULL default '0',
`titlepic` varchar(120) NOT NULL default '',
`eckuid` int(11) NOT NULL default '0',
`picurl` varchar(200) NOT NULL default '',
`picsay` text NOT NULL,
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_photo_doc_data`;
CREATE TABLE `phome_ecms_photo_doc_data` (
`id` int(10) unsigned NOT NULL default '0',
`classid` smallint(5) unsigned NOT NULL default '0',
`keyid` varchar(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` varchar(80) NOT NULL default '',
`filesize` varchar(10) NOT NULL default '',
`picsize` varchar(20) NOT NULL default '',
`picfbl` varchar(20) NOT NULL default '',
`picfrom` varchar(120) NOT NULL default '',
`morepic` mediumtext NOT NULL,
`num` tinyint(4) NOT NULL default '0',
`width` varchar(12) NOT NULL default '',
`height` varchar(12) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `classid` (`classid`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_photo_doc_index`;
CREATE TABLE `phome_ecms_photo_doc_index` (
`id` int(10) unsigned NOT NULL auto_increment,
`classid` smallint(5) unsigned NOT NULL default '0',
`checked` tinyint(1) NOT NULL default '0',
`newstime` int(10) unsigned 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',
PRIMARY KEY (`id`),
KEY `classid` (`classid`),
KEY `checked` (`checked`),
KEY `newstime` (`newstime`),
KEY `truetime` (`truetime`,`id`),
KEY `havehtml` (`classid`,`truetime`,`havehtml`,`checked`,`id`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_photo_index`;
CREATE TABLE `phome_ecms_photo_index` (
`id` int(10) unsigned NOT NULL auto_increment,
`classid` smallint(5) unsigned NOT NULL default '0',
`checked` tinyint(1) NOT NULL default '0',
`newstime` int(10) unsigned 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',
PRIMARY KEY (`id`),
KEY `classid` (`classid`),
KEY `checked` (`checked`),
KEY `newstime` (`newstime`),
KEY `truetime` (`truetime`,`id`),
KEY `havehtml` (`classid`,`truetime`,`havehtml`,`checked`,`id`)
) TYPE=MyISAM;
# --------------------------- shop -----------------------------
DROP TABLE IF EXISTS `phome_ecms_infoclass_shop`;
CREATE TABLE `phome_ecms_infoclass_shop` (
`classid` int(10) unsigned NOT NULL default '0',
`zz_title` text NOT NULL,
`z_title` varchar(255) NOT NULL default '',
`qz_title` varchar(255) NOT NULL default '',
`save_title` varchar(10) NOT NULL default '',
`zz_titlepic` text NOT NULL,
`z_titlepic` varchar(255) NOT NULL default '',
`qz_titlepic` varchar(255) NOT NULL default '',
`save_titlepic` varchar(10) NOT NULL default '',
`zz_newstime` text NOT NULL,
`z_newstime` varchar(255) NOT NULL default '',
`qz_newstime` varchar(255) NOT NULL default '',
`save_newstime` varchar(10) NOT NULL default '',
`zz_productno` text NOT NULL,
`z_productno` varchar(255) NOT NULL default '',
`qz_productno` varchar(255) NOT NULL default '',
`save_productno` varchar(10) NOT NULL default '',
`zz_pbrand` text NOT NULL,
`z_pbrand` varchar(255) NOT NULL default '',
`qz_pbrand` varchar(255) NOT NULL default '',
`save_pbrand` varchar(10) NOT NULL default '',
`zz_intro` text NOT NULL,
`z_intro` varchar(255) NOT NULL default '',
`qz_intro` varchar(255) NOT NULL default '',
`save_intro` varchar(10) NOT NULL default '',
`zz_unit` text NOT NULL,
`z_unit` varchar(255) NOT NULL default '',
`qz_unit` varchar(255) NOT NULL default '',
`save_unit` varchar(10) NOT NULL default '',
`zz_weight` text NOT NULL,
`z_weight` varchar(255) NOT NULL default '',
`qz_weight` varchar(255) NOT NULL default '',
`save_weight` varchar(10) NOT NULL default '',
`zz_tprice` text NOT NULL,
`z_tprice` varchar(255) NOT NULL default '',
`qz_tprice` varchar(255) NOT NULL default '',
`save_tprice` varchar(10) NOT NULL default '',
`zz_price` text NOT NULL,
`z_price` varchar(255) NOT NULL default '',
`qz_price` varchar(255) NOT NULL default '',
`save_price` varchar(10) NOT NULL default '',
`zz_buyfen` text NOT NULL,
`z_buyfen` varchar(255) NOT NULL default '',
`qz_buyfen` varchar(255) NOT NULL default '',
`save_buyfen` varchar(10) NOT NULL default '',
`zz_pmaxnum` text NOT NULL,
`z_pmaxnum` varchar(255) NOT NULL default '',
`qz_pmaxnum` varchar(255) NOT NULL default '',
`save_pmaxnum` varchar(10) NOT NULL default '',
`zz_productpic` text NOT NULL,
`z_productpic` varchar(255) NOT NULL default '',
`qz_productpic` varchar(255) NOT NULL default '',
`save_productpic` varchar(10) NOT NULL default '',
`zz_newstext` text NOT NULL,
`z_newstext` varchar(255) NOT NULL default '',
`qz_newstext` varchar(255) NOT NULL default '',
`save_newstext` varchar(10) NOT NULL default '',
`zz_psalenum` text NOT NULL,
`z_psalenum` varchar(255) NOT NULL default '',
`qz_psalenum` varchar(255) NOT NULL default '',
`save_psalenum` varchar(10) NOT NULL default '',
PRIMARY KEY (`classid`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_infotmp_shop`;
CREATE TABLE `phome_ecms_infotmp_shop` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`classid` int(10) unsigned NOT NULL default '0',
`oldurl` varchar(200) NOT NULL default '',
`checked` tinyint(1) NOT NULL default '0',
`tmptime` datetime NOT NULL default '0000-00-00 00:00:00',
`userid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(20) NOT NULL default '',
`truetime` int(10) unsigned NOT NULL default '0',
`keyboard` varchar(100) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`newstime` datetime NOT NULL default '0000-00-00 00:00:00',
`titlepic` varchar(120) NOT NULL default '',
`productno` varchar(30) NOT NULL default '',
`pbrand` varchar(30) NOT NULL default '',
`intro` text NOT NULL,
`unit` varchar(16) NOT NULL default '',
`weight` varchar(20) NOT NULL default '',
`tprice` float(11,2) NOT NULL default '0.00',
`price` float(11,2) NOT NULL default '0.00',
`buyfen` int(11) NOT NULL default '0',
`pmaxnum` int(11) NOT NULL default '0',
`productpic` varchar(255) NOT NULL default '',
`newstext` mediumtext NOT NULL,
`psalenum` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `classid` (`classid`),
KEY `checked` (`checked`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_shop`;
CREATE TABLE `phome_ecms_shop` (
`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` varchar(20) NOT NULL default '',
`filename` varchar(36) NOT NULL default '',
`userid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(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` varchar(14) NOT NULL default '',
`titleurl` varchar(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` varchar(80) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`newstime` int(10) unsigned NOT NULL default '0',
`titlepic` varchar(120) NOT NULL default '',
`eckuid` int(11) NOT NULL default '0',
`productno` varchar(30) NOT NULL default '',
`pbrand` varchar(30) NOT NULL default '',
`intro` text NOT NULL,
`unit` varchar(16) NOT NULL default '',
`weight` varchar(20) NOT NULL default '',
`tprice` float(11,2) NOT NULL default '0.00',
`price` float(11,2) NOT NULL default '0.00',
`buyfen` int(11) NOT NULL default '0',
`pmaxnum` int(11) NOT NULL default '0',
`productpic` varchar(255) NOT NULL default '',
`newstext` mediumtext NOT NULL,
`psalenum` 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_shop_check`;
CREATE TABLE `phome_ecms_shop_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` varchar(20) NOT NULL default '',
`filename` varchar(36) NOT NULL default '',
`userid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(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` varchar(14) NOT NULL default '',
`titleurl` varchar(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` varchar(80) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`newstime` int(10) unsigned NOT NULL default '0',
`titlepic` varchar(120) NOT NULL default '',
`eckuid` int(11) NOT NULL default '0',
`productno` varchar(30) NOT NULL default '',
`pbrand` varchar(30) NOT NULL default '',
`intro` text NOT NULL,
`unit` varchar(16) NOT NULL default '',
`weight` varchar(20) NOT NULL default '',
`tprice` float(11,2) NOT NULL default '0.00',
`price` float(11,2) NOT NULL default '0.00',
`buyfen` int(11) NOT NULL default '0',
`pmaxnum` int(11) NOT NULL default '0',
`productpic` varchar(255) NOT NULL default '',
`newstext` mediumtext NOT NULL,
`psalenum` 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_shop_check_data`;
CREATE TABLE `phome_ecms_shop_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_shop_data_1`;
CREATE TABLE `phome_ecms_shop_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_shop_doc`;
CREATE TABLE `phome_ecms_shop_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` varchar(20) NOT NULL default '',
`filename` varchar(36) NOT NULL default '',
`userid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(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` varchar(14) NOT NULL default '',
`titleurl` varchar(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` varchar(80) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`newstime` int(10) unsigned NOT NULL default '0',
`titlepic` varchar(120) NOT NULL default '',
`eckuid` int(11) NOT NULL default '0',
`productno` varchar(30) NOT NULL default '',
`pbrand` varchar(30) NOT NULL default '',
`intro` text NOT NULL,
`unit` varchar(16) NOT NULL default '',
`weight` varchar(20) NOT NULL default '',
`tprice` float(11,2) NOT NULL default '0.00',
`price` float(11,2) NOT NULL default '0.00',
`buyfen` int(11) NOT NULL default '0',
`pmaxnum` int(11) NOT NULL default '0',
`productpic` varchar(255) NOT NULL default '',
`newstext` mediumtext NOT NULL,
`psalenum` 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_shop_doc_data`;
CREATE TABLE `phome_ecms_shop_doc_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_shop_doc_index`;
CREATE TABLE `phome_ecms_shop_doc_index` (
`id` int(10) unsigned NOT NULL auto_increment,
`classid` smallint(5) unsigned NOT NULL default '0',
`checked` tinyint(1) NOT NULL default '0',
`newstime` int(10) unsigned 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',
PRIMARY KEY (`id`),
KEY `classid` (`classid`),
KEY `checked` (`checked`),
KEY `newstime` (`newstime`),
KEY `truetime` (`truetime`,`id`),
KEY `havehtml` (`classid`,`truetime`,`havehtml`,`checked`,`id`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_shop_index`;
CREATE TABLE `phome_ecms_shop_index` (
`id` int(10) unsigned NOT NULL auto_increment,
`classid` smallint(5) unsigned NOT NULL default '0',
`checked` tinyint(1) NOT NULL default '0',
`newstime` int(10) unsigned 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',
PRIMARY KEY (`id`),
KEY `classid` (`classid`),
KEY `checked` (`checked`),
KEY `newstime` (`newstime`),
KEY `truetime` (`truetime`,`id`),
KEY `havehtml` (`classid`,`truetime`,`havehtml`,`checked`,`id`)
) TYPE=MyISAM;
# --------------------------------------------------------
INSERT INTO `phome_enewsf` VALUES (1, 'title', '标题', 'text', '', '标题', 0, 1, 1, ' \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
', 0, 'CHAR', '100', 1, 1, 'news', 0, '', 0, 0, 0, '\\">', 0, '', 0, '60', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (2, 'special.field', '特殊属性', '', '', '特殊属性', 0, 1, 0, '', 1, '', '', 0, 1, 'news', 0, '', 0, 0, 0, '\\">\r\n(多个请用","隔开)', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (3, 'titlepic', '标题图片', 'img', '\\" size=\\"45\\">\r\n&infoid=&filepass=&sinfo=1&doing=1&field=titlepic\\\',\\\'\\\',\\\'width=700,height=550,scrollbars=yes\\\');\\" title=\\"选择已上传的图片\\">![](\\"../data/images/changeimg.gif\\")
', '标题图片', 0, 1, 1, ' \r\n [!--enews.name--]正则：
\r\n ( \r\n \r\n ) | \r\n | \r\n
\r\n', 2, 'CHAR', '120', 1, 1, 'news', 0, '', 0, 0, 0, '', 0, '', 0, '60', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (4, 'newstime', '发布时间', 'text', '\\" size=\\"28\\" class=\\"Wdate\\" onClick=\\"WdatePicker({skin:\\\'default\\\',dateFmt:\\\'yyyy-MM-dd HH:mm:ss\\\'})\\">\\\'\\">', '发布时间', 0, 1, 1, ' \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
', 1, 'INT', '11', 1, 1, 'news', 0, '', 1, 0, 0, '', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (5, 'ftitle', '副标题', 'text', '\\">\r\n', '副标题', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 0, 'CHAR', '120', 1, 1, 'news', 0, '', 0, 0, 1, '\\">\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (6, 'smalltext', '内容简介', 'textarea', '\r\n', '内容简介', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 2, 'CHAR', '255', 1, 1, 'news', 0, '', 0, 1, 1, '\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 1, '');
INSERT INTO `phome_enewsf` VALUES (7, 'writer', '作者', 'text', 'query(\\"select writer from {$dbtbpre}enewswriter\\");\r\nwhile($w_r=$empire->fetch($writer_sql))\r\n{\r\n $w_class.=\\"\\";\r\n}\r\n?>\r\n\\" size=\\"\\"> \r\n \r\n&addwritername=\\\'+document.add.writer.value);\\">\r\n', '作者', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 2, 'CHAR', '30', 1, 1, 'news', 0, '', 0, 0, 1, '\\" size=\\"\\">\r\n', 0, '', 0, '', 1, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (8, 'befrom', '信息来源', 'text', 'query(\\"select sitename from {$dbtbpre}enewsbefrom\\");\r\nwhile($b_r=$empire->fetch($befrom_sql))\r\n{\r\n $b_class.=\\"\\";\r\n}\r\n?>\r\n\\" size=\\"\\"> \r\n \r\n&addsitename=\\\'+document.add.befrom.value);\\">\r\n', '信息来源', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 2, 'CHAR', '60', 1, 1, 'news', 0, '', 0, 0, 1, '\\" size=\\"\\">\r\n', 0, '', 0, '', 1, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (9, 'newstext', '新闻正文', 'editor', '\r\n\r\n', '新闻正文', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 2, 'MEDIUMTEXT', '', 1, 1, 'news', 0, '', 0, 1, 1, '\r\n', 0, '', 0, '', 1, 1, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (10, 'diggtop', '顶', 'text', '\r\n" size="">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 3, 'INT', '', 1, 1, 'news', 0, '', 0, 0, 1, '\r\n" size="">\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (11, 'title', '标题', 'text', '\r\n', '标题', 0, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 0, 'CHAR', '100', 1, 2, 'download', 0, '', 0, 0, 0, '\\">\r\n', 0, '', 0, '60', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (12, 'special.field', '特殊属性', '', '\r\n\r\n', '特殊属性', 0, 1, 0, '\r\n\r\n', 0, '', '0', 0, 2, 'download', 0, '', 0, 0, 0, '\r\n\r\n(多个请用","隔开)\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (13, 'titlepic', '标题图片', 'img', '\\" size=\\"45\\">\r\n&infoid=&filepass=&sinfo=1&doing=1&field=titlepic\\\',\\\'\\\',\\\'width=700,height=550,scrollbars=yes\\\');\\" title=\\"选择已上传的图片\\"> \r\n', '标题图片', 0, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n ( \r\n \r\n ) | \r\n | \r\n
\r\n', 1, 'CHAR', '120', 1, 2, 'download', 0, '', 0, 0, 0, '\r\n', 0, '', 0, '60', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (14, 'newstime', '发布时间', 'text', '\\" size=\\"28\\" class=\\"Wdate\\" onClick=\\"WdatePicker({skin:\\\'default\\\',dateFmt:\\\'yyyy-MM-dd HH:mm:ss\\\'})\\">\\\'\\">\r\n', '发布时间', 0, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 0, 'INT', '11', 1, 2, 'download', 0, '', 1, 0, 0, '\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (15, 'softwriter', '作者', 'text', '\\" size=\\"60\\">\r\n', '作者', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'VARCHAR', '30', 1, 2, 'download', 0, '', 0, 0, 1, '\\" size=\\"42\\">\r\n', 0, '', 0, '', 1, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (16, 'homepage', '官方网站', 'text', '\\" size=\\"60\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'VARCHAR', '80', 1, 2, 'download', 0, 'http://', 0, 0, 1, '\\" size=\\"42\\">\r\n', 0, '', 0, '', 1, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (17, 'demo', '系统演示', 'text', '\\" size=\\"60\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'VARCHAR', '120', 1, 2, 'download', 0, 'http://', 0, 0, 1, '\\" size=\\"42\\">\r\n', 0, '', 0, '', 1, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (18, 'softfj', '运行环境', 'text', '\\" size=\\"60\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'VARCHAR', '255', 1, 2, 'download', 0, '', 0, 0, 1, '\\" size=\\"42\\">\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (19, 'language', '软件语言', 'select', '', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'VARCHAR', '16', 1, 2, 'download', 0, '简体中文|繁体中文|英文|多国语言', 0, 0, 1, '', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (20, 'softtype', '软件类型', 'select', '', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'VARCHAR', '16', 1, 2, 'download', 0, '国产软件|汉化软件|国外软件', 0, 0, 1, '', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (21, 'softsq', '授权形式', 'select', '', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'VARCHAR', '16', 1, 2, 'download', 0, '共享软件|免费软件|自由软件|试用软件|演示软件|商业软件', 0, 0, 1, '', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (22, 'star', '软件等级', 'select', '', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'TINYINT', '1', 1, 2, 'download', 0, '1|2:default|3|4|5', 0, 0, 1, '', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (23, 'filetype', '文件类型', 'text', '\\" size=\\"\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'VARCHAR', '10', 1, 2, 'download', 0, '', 0, 0, 1, '\\" size=\\"10\\">\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (24, 'filesize', '文件大小', 'text', '\\" size=\\"\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'VARCHAR', '16', 1, 2, 'download', 0, '', 0, 0, 1, '\\" size=\\"10\\">\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (25, 'downpath', '下载地址', 'text', '\r\n\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n (\r\n \r\n
\r\n \r\n )
\r\n 格式:地址正则(url)[!empirecms!]名称正则(name) | \r\n | \r\n
\r\n', 1, 'MEDIUMTEXT', '', 1, 2, 'download', 0, '', 0, 0, 1, '\r\n', 0, '', 0, '', 1, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (26, 'softsay', '软件简介', 'textarea', '\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'TEXT', '', 1, 2, 'download', 0, '', 0, 1, 1, '\r\n', 0, '', 0, '80,10', 0, 0, '', '', '', '', '', '', 0, 1, '');
INSERT INTO `phome_enewsf` VALUES (27, 'title', '标题', 'text', '\r\n', '标题', 0, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 0, 'CHAR', '100', 1, 3, 'photo', 0, '', 0, 0, 0, '\\">\r\n', 0, '', 0, '60', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (28, 'special.field', '特殊属性', '', '\r\n\r\n', '特殊属性', 0, 1, 0, '\r\n\r\n', 0, '', '0', 0, 3, 'photo', 0, '', 0, 0, 0, '\r\n\r\n(多个请用","隔开)\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (29, 'titlepic', '标题图片', 'img', '\\" size=\\"45\\">\r\n&infoid=&filepass=&sinfo=1&doing=1&field=titlepic\\\',\\\'\\\',\\\'width=700,height=550,scrollbars=yes\\\');\\" title=\\"选择已上传的图片\\"> \r\n', '标题图片', 0, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n ( \r\n \r\n ) | \r\n | \r\n
\r\n', 2, 'CHAR', '120', 1, 3, 'photo', 0, '', 0, 0, 0, '\r\n', 0, '', 0, '60', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (30, 'newstime', '发布时间', 'text', '\\" size=\\"28\\" class=\\"Wdate\\" onClick=\\"WdatePicker({skin:\\\'default\\\',dateFmt:\\\'yyyy-MM-dd HH:mm:ss\\\'})\\">\\\'\\">\r\n', '发布时间', 0, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 0, 'INT', '11', 1, 3, 'photo', 0, '', 1, 0, 0, '\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (31, 'filesize', '文件大小', 'text', '\\" size=\\"60\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'VARCHAR', '10', 1, 3, 'photo', 0, '', 0, 0, 1, '\\" size=\\"42\\">\r\n', 0, '', 0, '', 1, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (32, 'picsize', '图片尺寸', 'text', '\\" size=\\"\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'VARCHAR', '20', 1, 3, 'photo', 0, '', 0, 0, 1, '\\" size=\\"42\\">\r\n', 0, '', 0, '', 1, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (33, 'picfbl', '图片分辨率', 'text', '\\" size=\\"\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'VARCHAR', '20', 1, 3, 'photo', 0, '', 0, 0, 1, '\\" size=\\"42\\">\r\n', 0, '', 0, '', 1, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (34, 'picfrom', '来源', 'text', '\\" size=\\"60\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'VARCHAR', '120', 1, 3, 'photo', 0, '', 0, 0, 1, '\\" size=\\"42\\">\r\n', 0, '', 0, '', 1, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (35, 'picurl', '图片大图', 'img', '\\" size=\\"45\\">\r\n&infoid=&filepass=&sinfo=1&doing=1&field=picurl\\\',\\\'\\\',\\\'width=700,height=550,scrollbars=yes\\\');\\" title=\\"选择已上传的图片\\"> \r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n ( \r\n \r\n ) | \r\n | \r\n
\r\n', 2, 'VARCHAR', '200', 1, 3, 'photo', 0, '', 0, 0, 1, '\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (36, 'morepic', '图片集', 'text', '\r\n\r\n', '', 1, 1, 1, ' \r\n [!--enews.name--]正则：
\r\n (\r\n \r\n
\r\n \r\n
\r\n \r\n )
\r\n 格式:缩略图[!empirecms!]大图[!empirecms!]名称 | \r\n | \r\n
\r\n', 2, 'MEDIUMTEXT', '', 1, 3, 'photo', 0, '', 0, 0, 1, '\r\n\r\n', 0, '', 0, '', 1, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (37, 'num', '每行显示条数', 'text', '\\" size=\\"\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 2, 'TINYINT', '', 1, 3, 'photo', 0, '3', 0, 0, 1, '\\" size=\\"3\\">\r\n', 0, '', 0, '', 1, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (38, 'width', '缩图宽度', 'text', '\\" size=\\"6\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 2, 'VARCHAR', '12', 1, 3, 'photo', 0, '', 0, 0, 1, '\\" size=\\"6\\">\r\n', 0, '', 0, '', 1, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (39, 'height', '缩图高度', 'text', '\\" size=\\"6\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 2, 'VARCHAR', '12', 1, 3, 'photo', 0, '', 0, 0, 1, '\\" size=\\"6\\">\r\n', 0, '', 0, '', 1, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (40, 'picsay', '图片简介', 'textarea', '\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 2, 'TEXT', '', 1, 3, 'photo', 0, '', 0, 1, 1, '\r\n', 0, '', 0, '80,10', 0, 0, '', '', '', '', '', '', 0, 1, '');
INSERT INTO `phome_enewsf` VALUES (41, 'title', '标题', 'text', '\r\n', '标题', 0, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 0, 'CHAR', '100', 1, 4, 'flash', 0, '', 0, 0, 0, '\\">\r\n', 0, '', 0, '60', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (42, 'special.field', '特殊属性', '', '\r\n\r\n', '特殊属性', 0, 1, 0, '\r\n\r\n', 0, '', '0', 0, 4, 'flash', 0, '', 0, 0, 0, '\r\n\r\n(多个请用","隔开)\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (43, 'titlepic', '标题图片', 'img', '\\" size=\\"45\\">\r\n&infoid=&filepass=&sinfo=1&doing=1&field=titlepic\\\',\\\'\\\',\\\'width=700,height=550,scrollbars=yes\\\');\\" title=\\"选择已上传的图片\\"> \r\n', '标题图片', 0, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n ( \r\n \r\n ) | \r\n | \r\n
\r\n', 1, 'CHAR', '120', 1, 4, 'flash', 0, '', 0, 0, 0, '\r\n', 0, '', 0, '60', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (44, 'newstime', '发布时间', 'text', '\\" size=\\"28\\" class=\\"Wdate\\" onClick=\\"WdatePicker({skin:\\\'default\\\',dateFmt:\\\'yyyy-MM-dd HH:mm:ss\\\'})\\">\\\'\\">\r\n', '发布时间', 0, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 0, 'INT', '11', 1, 4, 'flash', 0, '', 1, 0, 0, '\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (45, 'flashwriter', '作者', 'text', '\\" size=\\"60\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'VARCHAR', '30', 1, 4, 'flash', 0, '', 0, 0, 1, '\\" size=\\"42\\">\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (46, 'email', '作者邮箱', 'text', '\\" size=\\"60\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'VARCHAR', '80', 1, 4, 'flash', 0, '', 0, 0, 1, '\\" size=\\"42\\">\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (47, 'star', '作品等级', 'select', '', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'TINYINT', '1', 1, 4, 'flash', 0, '1|2:default|3|4|5', 0, 0, 1, '', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (48, 'filesize', '文件大小', 'text', '\\" size=\\"60\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'VARCHAR', '16', 1, 4, 'flash', 0, '', 0, 0, 1, '\\" size=\\"42\\">\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (49, 'flashurl', 'Flash地址', 'flash', '\\" size=\\"45\\">\r\n&infoid=&filepass=&sinfo=1&doing=1&field=flashurl\\\',\\\'\\\',\\\'width=700,height=550,scrollbars=yes\\\');\\" title=\\"选择已上传的FLASH\\">![](\\"../data/images/changeflash.gif\\")
\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n ( \r\n \r\n ) | \r\n | \r\n
\r\n', 1, 'VARCHAR', '255', 1, 4, 'flash', 0, '', 0, 0, 1, '\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (50, 'width', 'Flash宽度', 'text', '\\" size=\\"6\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'VARCHAR', '12', 1, 4, 'flash', 0, '600', 0, 0, 1, '\\" size=\\"6\\">\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (51, 'height', 'Flash高度', 'text', '\\" size=\\"6\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'VARCHAR', '12', 1, 4, 'flash', 0, '450', 0, 0, 1, '\\" size=\\"6\\">\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (52, 'flashsay', '作品简介', 'textarea', '\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'TEXT', '', 1, 4, 'flash', 0, '', 0, 1, 1, '\r\n', 0, '', 0, '80,10', 0, 0, '', '', '', '', '', '', 0, 1, '');
INSERT INTO `phome_enewsf` VALUES (53, 'title', '标题', 'text', '\r\n', '标题', 0, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 0, 'CHAR', '100', 1, 5, 'movie', 0, '', 0, 0, 0, '\\">\r\n', 0, '', 0, '60', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (54, 'special.field', '特殊属性', '', '\r\n\r\n', '特殊属性', 0, 1, 0, '\r\n\r\n', 0, '', '0', 0, 5, 'movie', 0, '', 0, 0, 0, '\r\n\r\n(多个请用","隔开)\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (55, 'titlepic', '标题图片', 'img', '\\" size=\\"45\\">\r\n&infoid=&filepass=&sinfo=1&doing=1&field=titlepic\\\',\\\'\\\',\\\'width=700,height=550,scrollbars=yes\\\');\\" title=\\"选择已上传的图片\\"> \r\n', '标题图片', 0, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n ( \r\n \r\n ) | \r\n | \r\n
\r\n', 1, 'CHAR', '120', 1, 5, 'movie', 0, '', 0, 0, 0, '\r\n', 0, '', 0, '60', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (56, 'newstime', '发布时间', 'text', '\\" size=\\"28\\" class=\\"Wdate\\" onClick=\\"WdatePicker({skin:\\\'default\\\',dateFmt:\\\'yyyy-MM-dd HH:mm:ss\\\'})\\">\\\'\\">\r\n', '发布时间', 0, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 0, 'INT', '11', 1, 5, 'movie', 0, '', 1, 0, 0, '\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (57, 'movietype', '影片类型', 'select', '', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'VARCHAR', '16', 1, 5, 'movie', 0, '港台影视|海外影视|大陆影视|日韩影视', 0, 0, 1, '', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (58, 'company', '出品公司', 'text', '\r\n\\" size=\\"\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'VARCHAR', '200', 1, 5, 'movie', 0, '', 0, 0, 1, '\r\n\\" size=\\"\\">\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (59, 'movietime', '出品时间', 'text', '\r\n\\" size=\\"\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'VARCHAR', '20', 1, 5, 'movie', 0, '', 0, 0, 1, '\r\n\\" size=\\"\\">\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (60, 'player', '主演', 'text', '\r\n\\" size=\\"\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'VARCHAR', '255', 1, 5, 'movie', 0, '', 0, 0, 1, '\r\n\\" size=\\"\\">\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (61, 'playadmin', '导演', 'text', '\r\n\\" size=\\"\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'VARCHAR', '255', 1, 5, 'movie', 0, '', 0, 0, 1, '\r\n\\" size=\\"\\">\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (62, 'filetype', '影片格式', 'text', '\\" size=\\"8\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'VARCHAR', '10', 1, 5, 'movie', 0, '', 0, 0, 1, '\\" size=\\"\\">\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (63, 'filesize', '影片大小', 'text', '\\" size=\\"12\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'VARCHAR', '16', 1, 5, 'movie', 0, '', 0, 0, 1, '\\" size=\\"\\">\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (64, 'star', '推荐等级', 'select', '', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'TINYINT', '1', 1, 5, 'movie', 0, '1|2:default|3|4|5', 0, 0, 1, '', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (65, 'playdk', '带宽要求', 'text', '\r\n\\" size=\\"\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'VARCHAR', '30', 1, 5, 'movie', 0, '', 0, 0, 1, '\r\n\\" size=\\"\\">\r\n', 0, '', 0, '', 1, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (66, 'playtime', '片长', 'text', '\r\n\\" size=\\"\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'VARCHAR', '20', 1, 5, 'movie', 0, '', 0, 0, 1, '\r\n\\" size=\\"\\">\r\n', 0, '', 0, '', 1, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (67, 'moviefen', '扣除点数', 'text', '\r\n\\" size=\\"\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'INT', '', 1, 5, 'movie', 0, '', 0, 0, 1, '\r\n\\" size=\\"\\">\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (68, 'downpath', '下载地址', 'text', '\r\n\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n (\r\n \r\n
\r\n \r\n )
\r\n 格式:地址正则(url)[!empirecms!]名称正则(name) | \r\n | \r\n
\r\n', 1, 'MEDIUMTEXT', '', 1, 5, 'movie', 0, '', 0, 0, 1, '\r\n', 0, '', 0, '', 1, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (69, 'playerid', '播放器', 'text', '\r\nquery(\\"select id,player from {$dbtbpre}enewsplayer\\");\r\nwhile($player_r=$empire->fetch($player_sql))\r\n{\r\n $select_player=\\\'\\\';\r\n if($r[playerid]==$player_r[id])\r\n {\r\n $select_player=\\\' selected\\\';\r\n }\r\n $player_class.=\\"\\";\r\n}\r\n?>\r\n\r\n', '视频播放器', 1, 1, 1, '\r\nquery(\\"select id,player from {$dbtbpre}enewsplayer\\");\r\nwhile($player_r=$empire->fetch($player_sql))\r\n{\r\n $select_player=\\\'\\\';\r\n if($r[z_playerid]==$player_r[id])\r\n {\r\n $select_player=\\\' selected\\\';\r\n }\r\n $player_class.=\\"\\";\r\n}\r\n?>\r\n \r\n [!--enews.name--]：
\r\n () | \r\n | \r\n
\r\n', 1, 'SMALLINT', '', 1, 5, 'movie', 0, '', 0, 0, 1, '\r\nquery(\\"select id,player from {$dbtbpre}enewsplayer\\");\r\nwhile($player_r=$empire->fetch($player_sql))\r\n{\r\n $select_player=\\\'\\\';\r\n if($r[playerid]==$player_r[id])\r\n {\r\n $select_player=\\\' selected\\\';\r\n }\r\n $player_class.=\\"\\";\r\n}\r\n?>\r\n\r\n', 0, '', 0, '', 1, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (70, 'onlinepath', '在线观看地址', 'text', '\r\n\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n (\r\n \r\n
\r\n \r\n )
\r\n 格式:地址正则(url)[!empirecms!]名称正则(name) | \r\n \r\n | \r\n
\r\n', 2, 'MEDIUMTEXT', '', 1, 5, 'movie', 0, '', 0, 0, 1, '\r\n\r\n', 0, '', 0, '', 1, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (71, 'moviesay', '影片简介', 'textarea', '\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 2, 'TEXT', '', 1, 5, 'movie', 0, '', 0, 1, 1, '\r\n', 0, '', 0, '80,10', 0, 0, '', '', '', '', '', '', 0, 1, '');
INSERT INTO `phome_enewsf` VALUES (72, 'title', '标题', 'text', '\r\n', '标题', 0, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 0, 'CHAR', '100', 1, 6, 'shop', 0, '', 0, 0, 0, '\\">\r\n', 0, '', 0, '60', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (73, 'special.field', '特殊属性', '', '\r\n\r\n', '特殊属性', 0, 1, 0, '\r\n\r\n', 0, '', '0', 0, 6, 'shop', 0, '', 0, 0, 0, '\r\n\r\n(多个请用","隔开)\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (74, 'titlepic', '标题图片', 'img', '\\" size=\\"60\\">\r\n&infoid=&filepass=&sinfo=1&doing=1&field=titlepic\\\',\\\'\\\',\\\'width=700,height=550,scrollbars=yes\\\');\\" title=\\"选择已上传的图片\\"> \r\n', '标题图片', 0, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n ( \r\n \r\n ) | \r\n | \r\n
\r\n', 1, 'CHAR', '120', 1, 6, 'shop', 0, '', 0, 0, 0, '\r\n', 0, '', 0, '60', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (75, 'newstime', '发布时间', 'text', '\\" size=\\"28\\" class=\\"Wdate\\" onClick=\\"WdatePicker({skin:\\\'default\\\',dateFmt:\\\'yyyy-MM-dd HH:mm:ss\\\'})\\">\\\'\\">\r\n', '发布时间', 0, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 0, 'INT', '11', 1, 6, 'shop', 0, '', 1, 0, 0, '\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (76, 'productno', '商品编号', 'text', '\\" size=\\"60\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 0, 'VARCHAR', '30', 1, 6, 'shop', 0, '', 0, 0, 1, '\\" size=\\"42\\">\r\n', 0, '', 0, '60', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (77, 'pbrand', '品牌', 'text', '\\" size=\\"60\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 0, 'VARCHAR', '30', 1, 6, 'shop', 0, '', 0, 0, 1, '\\" size=\\"42\\">\r\n', 0, '', 0, '60', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (78, 'intro', '简单描述', 'textarea', '\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 0, 'TEXT', '', 1, 6, 'shop', 0, '', 0, 1, 1, '\r\n', 0, '', 0, '80,10', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (79, 'unit', '计量单位', 'text', '\\" size=\\"60\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 0, 'VARCHAR', '16', 1, 6, 'shop', 0, '', 0, 0, 1, '\\" size=\\"\\">\r\n', 0, '', 0, '60', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (80, 'weight', '单位重量', 'text', '\\" size=\\"60\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 0, 'VARCHAR', '20', 1, 6, 'shop', 0, '', 0, 0, 1, '\\" size=\\"\\">\r\n', 0, '', 0, '60', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (81, 'tprice', '市场价格', 'text', '\\" size=\\"60\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 0, 'FLOAT', '11,2', 1, 6, 'shop', 0, '', 0, 0, 1, '\\" size=\\"\\">\r\n', 0, '', 0, '60', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (82, 'price', '购买价格', 'text', '\\" size=\\"60\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 0, 'FLOAT', '11,2', 1, 6, 'shop', 0, '', 0, 0, 1, '\\" size=\\"\\">\r\n', 0, '', 0, '60', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (83, 'buyfen', '积分购买', 'text', '\\" size=\\"60\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 0, 'INT', '', 1, 6, 'shop', 0, '', 0, 0, 1, '\\" size=\\"\\">\r\n', 0, '', 0, '60', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (84, 'pmaxnum', '库存', 'text', '\\" size=\\"60\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 0, 'INT', '', 1, 6, 'shop', 0, '100', 0, 0, 1, '\\" size=\\"\\">\r\n', 0, '', 0, '60', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (85, 'productpic', '商品大图', 'img', '\\" size=\\"60\\">\r\n&infoid=&filepass=&sinfo=1&doing=1&field=productpic\\\',\\\'\\\',\\\'width=700,height=550,scrollbars=yes\\\');\\" title=\\"选择已上传的图片\\"> \r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n ( \r\n \r\n ) | \r\n | \r\n
\r\n', 1, 'VARCHAR', '255', 1, 6, 'shop', 0, '', 0, 0, 1, '\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (86, 'newstext', '商品介绍', 'editor', '\r\n\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'MEDIUMTEXT', '', 1, 6, 'shop', 0, '', 0, 1, 1, '\r\n', 0, '', 0, '', 0, 1, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (87, 'psalenum', '销售量', 'text', '\r\n\\" size=\\"60\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'INT', '', 1, 6, 'shop', 0, '', 0, 0, 1, '\r\n\\" size=\\"60\\">\r\n', 0, '', 0, '60', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (88, 'title', '标题', 'text', '\r\n', '标题', 0, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 0, 'CHAR', '100', 1, 7, 'article', 0, '', 0, 0, 0, '\\">\r\n', 0, '', 0, '60', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (89, 'special.field', '特殊属性', '', '\r\n\r\n', '特殊属性', 0, 1, 0, '\r\n\r\n', 1, '', '0', 0, 7, 'article', 0, '', 0, 0, 0, '\r\n\r\n(多个请用","隔开)\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (90, 'titlepic', '标题图片', 'img', '\\" size=\\"45\\">\r\n&infoid=&filepass=&sinfo=1&doing=1&field=titlepic\\\',\\\'\\\',\\\'width=700,height=550,scrollbars=yes\\\');\\" title=\\"选择已上传的图片\\"> \r\n', '标题图片', 0, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n ( \r\n \r\n ) | \r\n | \r\n
\r\n', 2, 'CHAR', '120', 1, 7, 'article', 0, '', 0, 0, 0, '\r\n', 0, '', 0, '60', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (91, 'newstime', '发布时间', 'text', '\\" size=\\"28\\" class=\\"Wdate\\" onClick=\\"WdatePicker({skin:\\\'default\\\',dateFmt:\\\'yyyy-MM-dd HH:mm:ss\\\'})\\">\\\'\\">\r\n', '发布时间', 0, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'INT', '11', 1, 7, 'article', 0, '', 1, 0, 0, '\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (92, 'ftitle', '副标题', 'text', '\\" size=\\"60\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 0, 'CHAR', '120', 1, 7, 'article', 0, '', 0, 0, 1, '\\" size=\\"42\\">\r\n', 0, '', 0, '60', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (93, 'smalltext', '内容简介', 'textarea', '\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 2, 'CHAR', '255', 1, 7, 'article', 0, '', 0, 1, 1, '\r\n', 0, '', 0, '80,10', 0, 0, '', '', '', '', '', '', 0, 1, '');
INSERT INTO `phome_enewsf` VALUES (94, 'writer', '作者', 'text', 'query(\\"select writer from {$dbtbpre}enewswriter\\");\r\nwhile($w_r=$empire->fetch($writer_sql))\r\n{\r\n $w_class.=\\"\\";\r\n}\r\n?>\r\n\\" size=\\"\\"> \r\n \r\n&addwritername=\\\'+document.add.writer.value);\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 2, 'CHAR', '30', 1, 7, 'article', 0, '', 0, 0, 1, '\\" size=\\"\\">\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (95, 'befrom', '信息来源', 'text', 'query(\\"select sitename from {$dbtbpre}enewsbefrom\\");\r\nwhile($b_r=$empire->fetch($befrom_sql))\r\n{\r\n $b_class.=\\"\\";\r\n}\r\n?>\r\n\\" size=\\"\\"> \r\n \r\n&addsitename=\\\'+document.add.befrom.value);\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 2, 'CHAR', '60', 1, 7, 'article', 0, '', 0, 0, 1, '\\" size=\\"\\">\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (96, 'newstext', '新闻正文', 'editor', '\r\n\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 2, 'CHAR', '50', 1, 7, 'article', 1, '', 0, 1, 1, '\r\n', 0, '', 0, '', 0, 1, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (97, 'diggtop', '顶', 'text', '\r\n\\" size=\\"\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 3, 'INT', '', 1, 7, 'article', 0, '', 0, 0, 1, '\r\n\\" size=\\"\\">\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (98, 'title', '标题', 'text', '\r\n', '标题', 0, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 0, 'CHAR', '100', 1, 8, 'info', 0, '', 0, 0, 0, '\\">\r\n', 0, '', 0, '60', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (99, 'special.field', '特殊属性', '', '\r\n\r\n', '特殊属性', 0, 1, 0, '\r\n\r\n', 0, '', '0', 0, 8, 'info', 0, '', 0, 0, 0, '\r\n\r\n(多个请用","隔开)\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (100, 'titlepic', '标题图片', 'img', '\\" size=\\"45\\">\r\n&infoid=&filepass=&sinfo=1&doing=1&field=titlepic\\\',\\\'\\\',\\\'width=700,height=550,scrollbars=yes\\\');\\" title=\\"选择已上传的图片\\"> \r\n', '标题图片', 0, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n ( \r\n \r\n ) | \r\n | \r\n
\r\n', 1, 'CHAR', '120', 1, 8, 'info', 0, '', 0, 0, 0, '\r\n', 0, '', 0, '60', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (101, 'newstime', '发布时间', 'text', '\\" size=\\"28\\" class=\\"Wdate\\" onClick=\\"WdatePicker({skin:\\\'default\\\',dateFmt:\\\'yyyy-MM-dd HH:mm:ss\\\'})\\">\\\'\\">\r\n', '发布时间', 0, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 0, 'INT', '11', 1, 8, 'info', 0, '', 1, 0, 0, '\r\n', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (102, 'smalltext', '信息内容', 'textarea', '\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 0, 'TEXT', '', 1, 8, 'info', 0, '', 0, 1, 1, '\r\n', 0, '', 0, '80,10', 0, 0, '', '', '', '', '', '', 0, 1, '');
INSERT INTO `phome_enewsf` VALUES (103, 'myarea', '所在地', 'select', '', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 1, 'VARCHAR', '30', 1, 8, 'info', 0, '东城区:default|西城区|崇文区|宣武区|朝阳区|海淀区|丰台区|石景山区|通州区|昌平区|大兴区|其它', 0, 0, 1, '', 0, '', 0, '', 0, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (104, 'email', '邮箱', 'text', '\\" size=\\"60\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 2, 'VARCHAR', '80', 1, 8, 'info', 0, '$memberinfor[email]', 0, 0, 1, '\\" size=\\"46\\">\r\n', 0, '', 0, '46', 1, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (105, 'mycontact', '联系方式', 'text', '\\" size=\\"60\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 2, 'VARCHAR', '255', 1, 8, 'info', 0, '', 0, 0, 1, '\\" size=\\"46\\">\r\n', 0, '', 0, '46', 1, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsf` VALUES (106, 'address', '联系地址', 'text', '\\" size=\\"60\\">\r\n', '', 1, 1, 1, '\r\n \r\n [!--enews.name--]正则：
\r\n () | \r\n | \r\n
\r\n', 2, 'VARCHAR', '255', 1, 8, 'info', 0, '$memberinfor[address]', 0, 0, 1, '\\" size=\\"46\\">\r\n', 0, '', 0, '46', 1, 0, '', '', '', '', '', '', 0, 0, '');
INSERT INTO `phome_enewsmod` VALUES (1, '新闻系统模型', '| 标题(*) | [!--title--] |
| 副标题 | [!--ftitle--] |
| 特殊属性 | [!--special.field--] |
| 发布时间 | [!--newstime--] |
| 标题图片 | [!--titlepic--] |
| 内容简介 | [!--smalltext--] |
| 作者 | [!--writer--] |
| 信息来源 | [!--befrom--] |
新闻正文(*) |
[!--newstext--]
', '新闻系统模型', '标题title副标题ftitle发布时间newstime标题图片titlepic内容简介smalltext作者writer信息来源befrom新闻正文newstext', '标题title副标题ftitle特殊属性special.field发布时间newstime标题图片titlepic内容简介smalltext作者writer信息来源befrom新闻正文newstext', '标题title副标题ftitle发布时间newstime标题图片titlepic内容简介smalltext作者writer信息来源befrom新闻正文newstext顶diggtop', '|34|35|36|37|', ',title,smalltext,', 1, 'news', '标题title副标题ftitle特殊属性special.field标题图片titlepic内容简介smalltext作者writer信息来源befrom新闻正文newstext', ',title,newstext,', '| 标题(*) | [!--title--] |
| 副标题 | [!--ftitle--] |
| 关键字 | [!--special.field--] |
| 标题图片 | [!--titlepic--] |
| 内容简介 | [!--smalltext--] |
| 作者 | [!--writer--] |
| 信息来源 | [!--befrom--] |
新闻正文(*) |
[!--newstext--]
', '', 0, '标题title副标题ftitle发布时间newstime标题图片titlepic内容简介smalltext顶diggtop', '新闻', ',title,ftitle,newstime,titlepic,smalltext,writer,befrom,newstext,', ',title,ftitle,newstime,titlepic,smalltext,writer,befrom,newstext,', 0, 0, 0, 0, '', 1, '', 0, '', '', '', '');
INSERT INTO `phome_enewsmod` VALUES (2, '下载系统模型', '\r\n', '', '软件名称title发布时间newstime软件预览图titlepic软件作者softwriter厂商主页homepage系统演示demo运行环境softfj软件语言language软件类型softtype授权形式softsq软件评价star文件类型filetype文件大小filesize下载地址downpath软件简介softsay', '软件名称title特殊属性special.field发布时间newstime软件预览图titlepic软件作者softwriter厂商主页homepage系统演示demo运行环境softfj软件语言language软件类型softtype授权形式softsq软件评价star文件类型filetype文件大小filesize下载地址downpath软件简介softsay', '软件名称title发布时间newstime软件预览图titlepic软件作者softwriter厂商主页homepage系统演示demo运行环境softfj软件语言language软件类型softtype授权形式softsq软件评价star文件类型filetype文件大小filesize下载地址downpath软件简介softsay', '|38|39|40|41|', ',title,softsay,', 2, 'download', '软件名称title特殊属性special.field软件预览图titlepic软件作者softwriter厂商主页homepage系统演示demo运行环境softfj软件语言language软件类型softtype授权形式softsq文件类型filetype文件大小filesize下载地址downpath软件简介softsay', ',title,downpath,softsay,', '\r\n', '', 0, '软件名称title发布时间newstime软件预览图titlepic运行环境softfj软件语言language软件类型softtype授权形式softsq软件评价star文件类型filetype文件大小filesize软件简介softsay', '软件', ',title,newstime,titlepic,softwriter,homepage,demo,softfj,language,softtype,softsq,star,filetype,filesize,downpath,softsay,', ',title,newstime,titlepic,softwriter,homepage,demo,softfj,language,softtype,softsq,star,filetype,filesize,downpath,softsay,', 0, 0, 0, 0, '', 1, '', 0, '', '', '', '');
INSERT INTO `phome_enewsmod` VALUES (3, '图片系统模型', '\r\n \r\n | 图片名称(*) | \r\n [!--title--] | \r\n
\r\n \r\n | 特殊属性 | \r\n [!--special.field--] | \r\n
\r\n \r\n | 发布时间 | \r\n [!--newstime--] | \r\n
\r\n \r\n | 文件大小 | \r\n [!--filesize--] | \r\n
\r\n \r\n | 单图属性 | \r\n 图片尺寸：[!--picsize--]，图片分辨率：[!--picfbl--] | \r\n
\r\n \r\n | 来源 | \r\n [!--picfrom--] | \r\n
\r\n \r\n | 图片小图 | \r\n [!--titlepic--] | \r\n
\r\n \r\n | 图片大图 | \r\n [!--picurl--] | \r\n
\r\n \r\n | 图片集 | \r\n [!--morepic--] | \r\n
\r\n \r\n | 图集属性 | \r\n 每行显示条数：[!--num--]，缩图大小：[!--width--]*[!--height--](宽*高) | \r\n
\r\n \r\n | 图片简介(*) | \r\n [!--picsay--] | \r\n
\r\n
', '', '图片名称title发布时间newstime文件大小filesize图片尺寸picsize图片分辨率picfbl来源picfrom图片小图titlepic图片大图picurl图片集morepic每行显示条数num缩图宽度width缩图高度height图片简介picsay', '图片名称title特殊属性special.field发布时间newstime文件大小filesize图片尺寸picsize图片分辨率picfbl来源picfrom图片小图titlepic图片大图picurl图片集morepic每行显示条数num缩图宽度width缩图高度height图片简介picsay', '图片名称title发布时间newstime文件大小filesize图片尺寸picsize图片分辨率picfbl来源picfrom图片小图titlepic图片大图picurl图片集morepic每行显示条数num缩图宽度width缩图高度height图片简介picsay', '|52|53|54|', ',title,picsay,', 3, 'photo', '图片名称title特殊属性special.field文件大小filesize图片尺寸picsize图片分辨率picfbl来源picfrom图片小图titlepic图片大图picurl图片简介picsay', ',title,picsay,', '| 图片名称 | [!--title--] |
\r\n \r\n | 关键字 | \r\n [!--special.field--] | \r\n
\r\n| 文件大小 | [!--filesize--] |
| 图片尺寸 | [!--picsize--] |
| 图片分辨率 | [!--picfbl--] |
| 来源 | [!--picfrom--] |
| 图片小图 | [!--titlepic--] |
| 图片大图 | [!--picurl--] |
| 图片简介 | [!--picsay--] |
', '', 0, '图片名称title发布时间newstime图片小图titlepic图片大图picurl图片简介picsay', '图片', ',title,newstime,filesize,picsize,picfbl,picfrom,titlepic,picurl,morepic,num,width,height,picsay,', ',title,newstime,filesize,picsize,picfbl,picfrom,titlepic,picurl,morepic,num,width,height,picsay,', 0, 0, 0, 0, '', 1, '', 0, '', '', '', '');
INSERT INTO `phome_enewsmod` VALUES (4, 'FLASH系统模型', '\r\n \r\n | 作品名(*) | \r\n [!--title--] | \r\n
\r\n \r\n | 特殊属性 | \r\n [!--special.field--] | \r\n
\r\n \r\n | 发布时间 | \r\n [!--newstime--] | \r\n
\r\n \r\n | 作品预览图 | \r\n [!--titlepic--] | \r\n
\r\n \r\n | 作者 | \r\n [!--flashwriter--] | \r\n
\r\n \r\n | 作者邮箱 | \r\n [!--email--] | \r\n
\r\n \r\n | 作品评价 | \r\n [!--star--] | \r\n
\r\n \r\n | 文件大小 | \r\n [!--filesize--] | \r\n
\r\n \r\n | Flash地址(*) | \r\n [!--flashurl--] | \r\n
\r\n \r\n | Flash规格 | \r\n [!--width--]*[!--height--](宽度*高度) | \r\n
\r\n \r\n | 作品简介(*) | \r\n [!--flashsay--] | \r\n
\r\n
', '', '作品名title发布时间newstime作品预览图titlepic作者flashwriter作者邮箱email作品评价star文件大小filesizeFlash地址flashurlFlash宽度widthFlash高度height作品简介flashsay', '作品名title特殊属性special.field发布时间newstime作品预览图titlepic作者flashwriter作者邮箱email作品评价star文件大小filesizeFlash地址flashurlFlash宽度widthFlash高度height作品简介flashsay', '作品名title发布时间newstime作品预览图titlepic作者flashwriter作者邮箱email作品评价star文件大小filesizeFlash地址flashurlFlash宽度widthFlash高度height作品简介flashsay', '|50|51|', ',title,flashwriter,flashsay,', 4, 'flash', '作品名title特殊属性special.field作品预览图titlepic作者flashwriter作者邮箱email文件大小filesizeFlash地址flashurlFlash宽度widthFlash高度height作品简介flashsay', ',title,flashurl,flashsay,', '\r\n \r\n | 作品名(*) | \r\n [!--title--] | \r\n
\r\n \r\n | 关键字 | \r\n [!--special.field--] | \r\n
\r\n \r\n | 作品预览图 | \r\n [!--titlepic--] | \r\n
\r\n \r\n | 作者 | \r\n [!--flashwriter--] | \r\n
\r\n \r\n | 作者邮箱 | \r\n [!--email--] | \r\n
\r\n \r\n | 文件大小 | \r\n [!--filesize--] | \r\n
\r\n \r\n | 上传Flash(*) | \r\n [!--flashurl--] | \r\n
\r\n \r\n | Flash规格 | \r\n [!--width--]*[!--height--](宽度*高度) | \r\n
\r\n \r\n | 作品简介(*) | \r\n [!--flashsay--] | \r\n
\r\n
\r\n', '', 0, '作品名title发布时间newstime作品预览图titlepic作者flashwriter作品评价star文件大小filesizeFlash地址flashurl作品简介flashsay', 'FLASH', ',title,newstime,titlepic,flashwriter,email,star,filesize,flashurl,width,height,flashsay,', ',title,newstime,titlepic,flashwriter,email,star,filesize,flashurl,width,height,flashsay,', 0, 0, 0, 0, '', 1, '', 0, '', '', '', '');
INSERT INTO `phome_enewsmod` VALUES (5, '电影系统模型', '\r\n \r\n | 影片名(*) | \r\n [!--title--] | \r\n
\r\n \r\n | 特殊属性 | \r\n [!--special.field--] | \r\n
\r\n \r\n | 发布时间 | \r\n [!--newstime--] | \r\n
\r\n \r\n | 影片缩略图 | \r\n [!--titlepic--] | \r\n
\r\n \r\n | 影片类型 | \r\n [!--movietype--]，推荐等级：[!--star--]，扣除点数：[!--moviefen--] | \r\n
\r\n \r\n | 出品公司 | \r\n [!--company--]，出品时间：[!--movietime--] | \r\n
\r\n \r\n | 主演 | \r\n [!--player--]，导演 ：[!--playadmin--] | \r\n
\r\n \r\n | 影片文件 | \r\n 影片格式：[!--filetype--]，影片大小：[!--filesize--] | \r\n
\r\n \r\n | 影片属性 | \r\n 带宽要求：[!--playdk--]，片长：[!--playtime--] | \r\n
\r\n \r\n | 下载地址 | \r\n [!--downpath--] | \r\n
\r\n \r\n | 在线观看播放器 | \r\n [!--playerid--] | \r\n
\r\n \r\n | 在线观看地址 | \r\n [!--onlinepath--] | \r\n
\r\n \r\n | 影片简介(*) | \r\n [!--moviesay--] | \r\n
\r\n
\r\n', '', '影片名title发布时间newstime影片缩略图titlepic影片类型movietype出品公司company出品时间movietime主演player导演playadmin影片格式filetype影片大小filesize推荐等级star带宽要求playdk片长playtime扣除点数moviefen下载地址downpath播放器playerid在线观看地址onlinepath影片简介moviesay', '影片名title特殊属性special.field发布时间newstime影片缩略图titlepic影片类型movietype出品公司company出品时间movietime主演player导演playadmin影片格式filetype影片大小filesize推荐等级star带宽要求playdk片长playtime扣除点数moviefen下载地址downpath播放器playerid在线观看地址onlinepath影片简介moviesay', '影片名title发布时间newstime影片缩略图titlepic影片类型movietype出品公司company出品时间movietime主演player导演playadmin影片格式filetype影片大小filesize推荐等级star带宽要求playdk片长playtime扣除点数moviefen下载地址downpath播放器playerid在线观看地址onlinepath影片简介moviesay', '|42|43|44|45|', ',title,movietype,company,player,playadmin,moviesay,', 5, 'movie', '', ',title,moviesay,', '', '', 0, '影片名title发布时间newstime影片缩略图titlepic影片类型movietype出品公司company出品时间movietime主演player导演playadmin影片格式filetype影片大小filesize推荐等级star扣除点数moviefen影片简介moviesay', '电影', ',title,newstime,titlepic,movietype,company,movietime,player,playadmin,filetype,filesize,star,playdk,playtime,moviefen,downpath,playerid,onlinepath,moviesay,', ',title,newstime,titlepic,movietype,company,movietime,player,playadmin,filetype,filesize,star,playdk,playtime,moviefen,downpath,playerid,onlinepath,moviesay,', 0, 0, 0, 0, '', 1, '', 0, '', '', '', '');
INSERT INTO `phome_enewsmod` VALUES (6, '商城系统模型', '\r\n \r\n | 商品名称(*) | \r\n [!--title--] | \r\n
\r\n | 特殊属性 | [!--special.field--] |
\r\n \r\n | 发布时间 | \r\n [!--newstime--] | \r\n
\r\n \r\n | 商品编号 | \r\n [!--productno--] | \r\n
\r\n \r\n | 品牌 | \r\n [!--pbrand--] | \r\n
\r\n \r\n | 简单描述 | \r\n [!--intro--] | \r\n
\r\n \r\n | 计量单位 | \r\n [!--unit--] | \r\n
\r\n \r\n | 单位重量 | \r\n [!--weight--] | \r\n
\r\n \r\n | 市场价格 | \r\n [!--tprice--]元 | \r\n
\r\n \r\n | 购买价格 | \r\n [!--price--]元 | \r\n
\r\n \r\n | 积分购买 | \r\n [!--buyfen--]点 | \r\n
\r\n \r\n | 库存 | \r\n [!--pmaxnum--] | \r\n
\r\n \r\n | 商品缩略片 | \r\n [!--titlepic--] | \r\n
\r\n \r\n | 商品大图 | \r\n [!--productpic--] | \r\n
\r\n \r\n 商品介绍(*) | \r\n
\r\n
\r\n[!--newstext--]
', '', '商品名称title发布时间newstime商品编号productno品牌pbrand简单描述intro计量单位unit单位重量weight市场价格tprice购买价格price积分购买buyfen库存pmaxnum商品缩略片titlepic商品大图productpic商品介绍newstext', '商品名称title特殊属性special.field发布时间newstime商品编号productno品牌pbrand简单描述intro计量单位unit单位重量weight市场价格tprice购买价格price积分购买buyfen库存pmaxnum商品缩略片titlepic商品大图productpic商品介绍newstext', '商品名称title发布时间newstime商品编号productno品牌pbrand简单描述intro计量单位unit单位重量weight市场价格tprice购买价格price积分购买buyfen库存pmaxnum商品缩略片titlepic商品大图productpic商品介绍newstext销售量psalenum', '|46|47|48|49|', ',title,productno,pbrand,intro,price,newstext,', 6, 'shop', '', ',title,newstext,', '', '', 0, '商品名称title发布时间newstime商品编号productno品牌pbrand简单描述intro计量单位unit单位重量weight市场价格tprice购买价格price积分购买buyfen库存pmaxnum商品缩略片titlepic商品大图productpic商品介绍newstext销售量psalenum', '商品', ',title,newstime,productno,pbrand,intro,unit,weight,tprice,price,buyfen,pmaxnum,titlepic,productpic,newstext,', ',title,newstime,productno,pbrand,intro,unit,weight,tprice,price,buyfen,pmaxnum,titlepic,productpic,newstext,', 0, 0, 0, 0, '', 1, '', 0, '', '', '', '');
INSERT INTO `phome_enewsmod` VALUES (7, '文章系统模型', '| 标题(*) | [!--title--] |
| 副标题 | [!--ftitle--] |
| 特殊属性 | [!--special.field--] |
| 发布时间 | [!--newstime--] |
| 标题图片 | [!--titlepic--] |
| 内容简介 | [!--smalltext--] |
| 作者 | [!--writer--] |
| 信息来源 | [!--befrom--] |
新闻正文(*) |
[!--newstext--]
', '', '标题title副标题ftitle发布时间newstime标题图片titlepic内容简介smalltext作者writer信息来源befrom新闻正文newstext', '标题title副标题ftitle特殊属性special.field发布时间newstime标题图片titlepic内容简介smalltext作者writer信息来源befrom新闻正文newstext', '标题title副标题ftitle发布时间newstime标题图片titlepic内容简介smalltext作者writer信息来源befrom新闻正文newstext顶diggtop', '|55|56|57|', ',title,smalltext,', 7, 'article', '标题title副标题ftitle特殊属性special.field标题图片titlepic内容简介smalltext作者writer信息来源befrom新闻正文newstext', ',title,newstext,', '| 标题(*) | [!--title--] |
| 副标题 | [!--ftitle--] |
| 关键字 | [!--special.field--] |
| 标题图片 | [!--titlepic--] |
| 内容简介 | [!--smalltext--] |
| 作者 | [!--writer--] |
| 信息来源 | [!--befrom--] |
新闻正文(*) |
[!--newstext--]
', '', 0, '标题title副标题ftitle发布时间newstime标题图片titlepic内容简介smalltext顶diggtop', '文章', ',title,ftitle,newstime,titlepic,smalltext,writer,befrom,newstext,', ',title,ftitle,newstime,titlepic,smalltext,writer,befrom,newstext,', 0, 0, 0, 0, '', 1, '', 0, '', '', '', '');
INSERT INTO `phome_enewsmod` VALUES (8, '分类信息系统模型', '| 标题 | [!--title--] |
| 特殊属性 | [!--special.field--] |
| 发布时间 | [!--newstime--] |
| 信息内容 | [!--smalltext--] |
| 图片 | [!--titlepic--] |
| 所在地 | [!--myarea--] |
| 联系邮箱 | [!--email--] |
| 联系方式 | [!--mycontact--] |
| 联系地址 | [!--address--] |
', '', '标题title发布时间newstime信息内容smalltext图片titlepic所在地myarea联系邮箱email联系方式mycontact联系地址address', '标题title特殊属性special.field发布时间newstime信息内容smalltext图片titlepic所在地myarea联系邮箱email联系方式mycontact联系地址address', '标题title发布时间newstime信息内容smalltext图片titlepic所在地myarea联系邮箱email联系方式mycontact联系地址address', '|11|12|13|14|15|16|18|19|20|21|23|24|25|26|28|29|30|31|', ',title,smalltext,myarea,', 8, 'info', '标题title信息内容smalltext图片titlepic所在地myarea联系邮箱email联系方式mycontact联系地址address', ',title,smalltext,myarea,email,', '\r\n | 信息标题(*) | \r\n [!--title--] |
\r\n | 信息内容(*) | \r\n [!--smalltext--] |
| 图片 | [!--titlepic--] |
\r\n | 所在地(*) | \r\n [!--myarea--] |
\r\n | 联系邮箱(*) | \r\n [!--email--] |
| 联系方式 | [!--mycontact--] |
| 联系地址 | [!--address--] |
', ',myarea,', 0, '标题title发布时间newstime信息内容smalltext图片titlepic所在地myarea', '分类信息', ',title,newstime,smalltext,titlepic,myarea,email,mycontact,address,', ',title,newstime,smalltext,titlepic,myarea,email,mycontact,address,', 0, 0, 0, 0, '', 1, '', 0, '', '', '', '');
INSERT INTO `phome_enewstable` VALUES (1, 'news', '新闻系统数据表', '新闻系统数据表', 1, ',1,', '1', 0, 1, 0);
INSERT INTO `phome_enewstable` VALUES (2, 'download', '下载系统数据表', '下载系统数据表', 0, ',1,', '1', 0, 2, 0);
INSERT INTO `phome_enewstable` VALUES (3, 'photo', '图片系统数据表', '图片系统数据表', 0, ',1,', '1', 0, 3, 0);
INSERT INTO `phome_enewstable` VALUES (4, 'flash', 'FLASH系统数据表', 'FLASH系统数据表', 0, ',1,', '1', 0, 4, 0);
INSERT INTO `phome_enewstable` VALUES (5, 'movie', '电影系统数据表', '电影系统数据表', 0, ',1,', '1', 0, 5, 0);
INSERT INTO `phome_enewstable` VALUES (6, 'shop', '商城系统数据表', '商城系统数据表', 0, ',1,', '1', 0, 6, 0);
INSERT INTO `phome_enewstable` VALUES (7, 'article', '文章系统数据表', '文章系统数据表(内容存文本)', 0, ',1,', '1', 0, 7, 0);
INSERT INTO `phome_enewstable` VALUES (8, 'info', '分类信息数据表', '分类信息数据表', 0, ',1,', '1', 0, 8, 0);