# -------------------------------------------------------- # # 帝国网站管理系统 # # http://www.PHome.Net # # EmpireCMS Version 7.5 # # -------------------------------------------------------- # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsad`; CREATE TABLE `phome_enewsad` ( `adid` int(10) unsigned NOT NULL auto_increment, `picurl` varchar(255) NOT NULL default '', `url` text NOT NULL, `pic_width` int(10) unsigned NOT NULL default '0', `pic_height` int(10) unsigned NOT NULL default '0', `onclick` int(10) unsigned NOT NULL default '0', `classid` smallint(5) unsigned NOT NULL default '0', `adtype` tinyint(3) unsigned NOT NULL default '0', `title` varchar(100) NOT NULL default '', `target` varchar(10) NOT NULL default '', `alt` varchar(120) NOT NULL default '', `starttime` date NOT NULL default '0000-00-00', `endtime` date NOT NULL default '0000-00-00', `adsay` varchar(255) NOT NULL default '', `titlefont` varchar(14) NOT NULL default '', `titlecolor` varchar(10) NOT NULL default '', `htmlcode` text NOT NULL, `t` tinyint(3) unsigned NOT NULL default '0', `ylink` tinyint(1) NOT NULL default '0', `reptext` text NOT NULL, PRIMARY KEY (`adid`), KEY `classid` (`classid`), KEY `t` (`t`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsadclass`; CREATE TABLE `phome_enewsadclass` ( `classid` smallint(5) unsigned NOT NULL auto_increment, `classname` char(30) NOT NULL default '', PRIMARY KEY (`classid`) ) TYPE=MyISAM; INSERT INTO `phome_enewsadclass` VALUES (1, '默认广告分类'); # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsadminstyle`; CREATE TABLE `phome_enewsadminstyle` ( `styleid` smallint(5) unsigned NOT NULL auto_increment, `stylename` char(30) NOT NULL default '', `path` smallint(5) unsigned NOT NULL default '0', `isdefault` tinyint(1) NOT NULL default '0', PRIMARY KEY (`styleid`) ) TYPE=MyISAM; INSERT INTO `phome_enewsadminstyle` VALUES (1, '管理员后台界面', 1, 1); INSERT INTO `phome_enewsadminstyle` VALUES (2, '编辑后台界面', 2, 0); # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsag`; CREATE TABLE `phome_enewsag` ( `agid` int(10) unsigned NOT NULL auto_increment, `agname` varchar(60) NOT NULL default '', `isadmin` tinyint(1) NOT NULL default '0', `auids` text NOT NULL, PRIMARY KEY (`agid`), KEY `isadmin` (`isadmin`) ) TYPE=MyISAM; INSERT INTO `phome_enewsag` VALUES (1, '管理员', 9, ''); INSERT INTO `phome_enewsag` VALUES (2, '版主', 5, ''); # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsautodo`; CREATE TABLE `phome_enewsautodo` ( `doid` bigint(20) unsigned NOT NULL auto_increment, `dotype` char(50) NOT NULL default '', `classid` int(11) NOT NULL default '0', `id` int(10) unsigned NOT NULL default '0', `tid` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `dotime` int(10) unsigned NOT NULL default '0', `addtime` int(10) unsigned NOT NULL default '0', `pid` int(11) NOT NULL default '0', `ckstr` char(32) NOT NULL default '', `fname` char(255) NOT NULL default '', `ecmspno` char(32) NOT NULL default '', `ckpass` char(32) NOT NULL default '', PRIMARY KEY (`doid`), KEY `userid` (`userid`), KEY `pid` (`pid`), KEY `dotime` (`dotime`), KEY `ckstr` (`ckstr`), KEY `ecmspno` (`ecmspno`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsbefrom`; CREATE TABLE `phome_enewsbefrom` ( `befromid` smallint(5) unsigned NOT NULL auto_increment, `sitename` char(60) NOT NULL default '', `siteurl` char(200) NOT NULL default '', PRIMARY KEY (`befromid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsbq`; CREATE TABLE `phome_enewsbq` ( `bqid` smallint(5) unsigned NOT NULL auto_increment, `bqname` varchar(60) NOT NULL default '', `bqsay` text NOT NULL, `funname` varchar(60) NOT NULL default '', `bq` varchar(60) NOT NULL default '', `issys` tinyint(1) NOT NULL default '0', `bqgs` text NOT NULL, `isclose` tinyint(1) NOT NULL default '0', `classid` smallint(5) unsigned NOT NULL default '0', `myorder` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`bqid`), KEY `classid` (`classid`), KEY `isclose` (`isclose`), KEY `myorder` (`myorder`) ) TYPE=MyISAM; INSERT INTO `phome_enewsbq` VALUES (1, '文字调用标签', '\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n
参数
\r\n 		参数说明
\r\n
栏目ID
\r\n 		查看栏目ID点这里，查看标题分类ID点这里,当前ID=\\\'selfinfo\\\'
\r\n 多个栏目ID与标题分类ID可用,号格开，如\\\'1,2\\\'
\r\n
显示条数
\r\n 		显示前几条记录
\r\n
标题截取数
\r\n 		截取几个字符
\r\n
是否显示时间
\r\n 		是否在标题后显示时间，0为不显示，1为显示
\r\n
操作类型
\r\n 		具体看操作类型说明
\r\n
是否显示栏目名
\r\n 		0为不显示，1为显示
\r\n
时间格式化
\r\n 		形式：Y-m-d H:i:s．默认为：\\\'(m-d)\\\'
\r\n
附加SQL条件
\r\n 		附加调用条件，如："title=\\\'帝国\\\'"
\r\n
显示排序
\r\n 		可指定按相应的字段排序，如："id desc"
\r\n
（注：在栏目ID中写大栏目，系统会自己搜索子栏目的信息）
\r\n
', 'sys_GetClassNews', 'phomenews', 1, '[phomenews]栏目ID,显示条数,标题截取数,是否显示时间,操作类型,是否显示栏目名,\\\'时间格式化\\\',附加SQL条件,显示排序[/phomenews]', 0, 1, 9); INSERT INTO `phome_enewsbq` VALUES (22, '留言板调用', '\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n
参数
\r\n 		参数说明
\r\n
显示信息数
\r\n 		显示记录数
\r\n
标签模板ID
\r\n 		\r\n
查看标签模板ID点这里
\r\n
\r\n
 
\r\n 		模板标签变量说明：
\r\n 留言ID：[!--lyid--]，留言内容：[!--lytext--]
\r\n 回复内容：[!--retext--]，留言时间：[!--lytime--]
\r\n 留言者：[!--name--]，留言者邮箱：[!--email--]
\r\n 序号：[!--no--]
\r\n
留言分类ID
\r\n 		\r\n
点击这里查看分类ID，0为不限制
\r\n
', 'sys_ShowLyInfo', 'gbookinfo', 1, '[gbookinfo]显示信息数,标签模板ID,留言分类ID[/gbookinfo]', 0, 3, 5); INSERT INTO `phome_enewsbq` VALUES (23, '专题调用标签', '\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n
参数
\r\n 		参数说明
\r\n
\r\n
标签模板ID
\r\n
\r\n 		查看标签模板ID点这里
\r\n
 
\r\n 		\r\n

模板标签变量说明：(list.var)
\r\n [!--classurl--]：专题链接，[!--classname--]：专题名称
\r\n [!--classid--]：专题id，[!--classimg--]：专题图片
\r\n [!--intro--]：专题简介,[!--no--]：序号

\r\n
\r\n
专题类别ID
\r\n 		\r\n
点击这里查看分类ID，0为不限制，多个分类ID用逗号隔开，如\\\'1,2\\\'
\r\n
\r\n
显示专题数
\r\n 		0为不限制
\r\n
所属栏目ID
\r\n 		点击这里查看栏目ID，0为不限制，多个栏目ID用逗号隔开，如\\\'1,2\\\'
', 'sys_ShowZtData', 'eshowzt', 1, '[eshowzt]标签模板ID,专题类别ID,显示专题数,所属栏目ID[/eshowzt]', 0, 2, 6); INSERT INTO `phome_enewsbq` VALUES (2, '图文信息调用(标题图片的信息)', '\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n
参数
\r\n 		参数说明
\r\n
栏目ID
\r\n 		查看栏目ID点这里，查看标题分类ID点这里,当前ID=\\\'selfinfo\\\'
\r\n 多个栏目ID与标题分类ID可用,号格开，如\\\'1,2\\\'
\r\n
每行显示条数
\r\n 		每行显示几个图片
\r\n
显示总信息数
\r\n 		显示信息总数
\r\n
图片宽度，图片高度
\r\n 		图文信息图片大小
\r\n
是否显示标题
\r\n 		是否在图片下显示标题，0为不显示，1为显示
\r\n
标题截取数
\r\n 		截取几个字符
\r\n
操作类型说明
\r\n 		具体看操作类型说明
\r\n
附加SQL条件
\r\n 		附加调用条件，如："title=\\\'帝国\\\'"
\r\n
显示排序
\r\n 		可指定按相应的字段排序，如："id desc"
', 'sys_GetClassNewsPic', 'phomenewspic', 1, '[phomenewspic]栏目ID,每行显示条数,显示总信息数,图片宽度,图片高度,是否显示标题,标题截取数,操作类型,附加SQL条件,显示排序[/phomenewspic]', 0, 1, 9); INSERT INTO `phome_enewsbq` VALUES (5, '广告标签', '\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n
参数
\r\n 		参数说明
\r\n
广告ID
\r\n 		查看广告ID点这里
', 'sys_GetAd', 'phomead', 1, '[phomead]广告ID[/phomead]', 0, 3, 5); INSERT INTO `phome_enewsbq` VALUES (6, '投票标签', '\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n
参数
\r\n 		参数说明
\r\n
投票ID
\r\n 		查看投票ID点这里
', 'sys_GetVote', 'phomevote', 1, '[phomevote]投票ID[/phomevote]', 0, 3, 5); INSERT INTO `phome_enewsbq` VALUES (11, '带模板的信息调用标签[万能标签]', '\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n
参数
\r\n 		参数说明
\r\n
栏目ID
\r\n 		查看栏目ID点这里，查看标题分类ID点这里,当前ID=\\\'selfinfo\\\'
\r\n 多个栏目ID与标题分类ID可用,号格开，如\\\'1,2\\\'
\r\n
显示条数
\r\n 		显示前几条记录
\r\n
标题截取数
\r\n 		截取几个字符
\r\n
是否显示栏目名
\r\n 		0为不显示，1为显示
\r\n
操作类型
\r\n 		具体看操作类型说明
\r\n
标签模板ID
\r\n 		查看标签模板ID点这里
\r\n
只显示有标题图片
\r\n 		0为不限制，1为只显示有标题图片的信息
\r\n
附加SQL条件
\r\n 		附加调用条件，如："title=\\\'帝国\\\'"
\r\n
显示排序
\r\n 		可指定按相应的字段排序，如："id desc"
', 'sys_GetEcmsInfo', 'ecmsinfo', 1, '[ecmsinfo]栏目ID,显示条数,标题截取数,是否显示栏目名,操作类型,模板ID,只显示有标题图片,附加SQL条件,显示排序[/ecmsinfo]', 0, 1, 10); INSERT INTO `phome_enewsbq` VALUES (12, '友情链接标签', '\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n
参数
\r\n 		参数说明
\r\n
每行显示记录数
\r\n 		每行显示记录数
\r\n
显示总记录数
\r\n 		\r\n
总记录数
\r\n
\r\n
操作类型
\r\n 		\r\n
0为所有记录，1为图片链接，2为文字链接
\r\n
\r\n
分类ID
\r\n 		\r\n
点击这里查看分类ID，0为不限制
\r\n
\r\n
是否显示原链接
\r\n 		\r\n
0为统计点击链接，1为显示原链接
\r\n
', 'sys_GetSitelink', 'phomelink', 1, '[phomelink]每行显示数,显示总数,操作类型,分类id,是否显示原链接[/phomelink]', 0, 3, 5); INSERT INTO `phome_enewsbq` VALUES (15, '引用文件标签', '

[includefile]\\\'文件地址\\\'[/includefile]
\r\n文件地址需要为相对地址,并且从后台目录算起："../../header.html"（这个地址的header.html是放在ecms根目录）

', 'sys_IncludeFile', 'includefile', 1, '[includefile]\\\'文件地址\\\'[/includefile]', 1, 4, 4); INSERT INTO `phome_enewsbq` VALUES (16, '读取远程页面', '

[readhttp]\\\'页面地址\\\'[/readhttp]

', 'sys_ReadFile', 'readhttp', 1, '[readhttp]\\\'页面地址\\\'[/readhttp]', 1, 4, 4); INSERT INTO `phome_enewsbq` VALUES (17, '网站信息统计', '

操作类型说明：\r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n
操作类型
\r\n 		内容
\r\n
0
\r\n 		统计栏目数据
\r\n
1
\r\n 		统计标题分类
\r\n
2
\r\n 		统计数据表
\r\n
\r\n时间范围：0为不限；1为今日；2为本月；3为本年。
\r\n统计类型：0为统计信息数；1为统计评论数；2为统计点击数；3为统计下载数。
\r\n如果操作类型是“统计数据表”，栏目ID=\\\'数据表名\\\'

', 'sys_TotalData', 'totaldata', 1, '[totaldata]栏目ID,操作类型,时间范围,统计类型[/totaldata]', 0, 1, 7); INSERT INTO `phome_enewsbq` VALUES (18, 'FLASH幻灯信息调用', '\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n
参数
\r\n 		参数说明
\r\n
\r\n
栏目ID
\r\n
\r\n 		查看栏目ID点这里，查看标题分类ID点这里,当前ID=\\\'selfinfo\\\'
\r\n 多个栏目ID与标题分类ID可用,号格开，如\\\'1,2\\\'
\r\n
显示总数
\r\n 		显示信息总数
\r\n
图片宽度，图片高度
\r\n 		图文信息图片大小
\r\n
是否显示标题
\r\n 		是否在图片下显示标题，0为不显示，1为显示
\r\n
标题截取数
\r\n 		截取几个字符
\r\n
操作类型说明
\r\n 		具体看操作类型说明
\r\n
附加SQL条件
\r\n 		附加调用条件，如："title=\\\'帝国\\\'"
\r\n
显示排序
\r\n 		可指定按相应的字段排序，如："id desc"
', 'sys_FlashPixpic', 'phomeflashpic', 1, '[phomeflashpic]栏目ID,显示总数,图片宽度,图片高度,是否显示标题,标题截取数,操作类型,停顿秒数,附加SQL条件,显示排序[/phomeflashpic]', 0, 1, 9); INSERT INTO `phome_enewsbq` VALUES (19, '搜索关键字调用标签', '

栏目id为0，则显示所有栏目的关键字

\r\n

操作类型：0为搜索热门排行，1为最新搜索排行

', 'sys_ShowSearchKey', 'showsearch', 1, '[showsearch]每行显示条数,总条数,栏目id,操作类型[/showsearch]', 0, 1, 7); INSERT INTO `phome_enewsbq` VALUES (20, '循环子栏目数据标签', '\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n
参数
\r\n 		参数说明
\r\n
栏目ID
\r\n 		查看栏目ID点这里，单个为父栏目ID，多栏目可用","格开
\r\n 当前栏目ID用：\\\'selfinfo\\\'
\r\n
显示条数
\r\n 		显示前几条记录
\r\n
标题截取数
\r\n 		截取几个字符
\r\n
是否显示栏目名
\r\n 		0为不显示，1为显示
\r\n
操作类型
\r\n 		0：栏目最新
\r\n 1：栏目热门
\r\n 2：栏目推荐
\r\n 3：栏目评论排行
\r\n 4：栏目头条
\r\n 5：栏目下载排行
\r\n
标签模板ID
\r\n 		查看标签模板ID点这里
\r\n
只显示有标题图片
\r\n 		0为不限制，1为只显示有标题图片的信息
\r\n
显示栏目数
\r\n 		0为不限制
\r\n
显示头条操作类型
\r\n 		0：不显示栏目头条
\r\n 1：栏目内容简介
\r\n 2：栏目推荐信息
\r\n 3：栏目头条信息
\r\n 4：栏目最新信息
\r\n
头条标题截取数
\r\n 		截取几个字符
\r\n
头条简介截取数
\r\n 		截取几个字符
\r\n
头条只显示有标题图片
\r\n 		0为不限制，1为只显示有标题图片的信息
\r\n
附加SQL条件
\r\n 		附加调用条件，如："title=\\\'帝国\\\'"
\r\n
显示排序
\r\n 		可指定按相应的字段排序，如："id desc"
\r\n
头条的模板变量
\r\n (标签模板的页面模板内容中使用)
\r\n 		[!--sonclass.id--]：信息ID
\r\n [!--sonclass.title--]：信息标题
\r\n [!--sonclass.oldtitle--]：信息标题(不截取字数)
\r\n [!--sonclass.titlepic--]：标题图片
\r\n [!--sonclass.titleurl--]：信息链接
\r\n [!--sonclass.text--]：信息简介
', 'sys_ForSonclassData', 'listsonclass', 1, '[listsonclass]栏目ID,显示条数,标题截取数,是否显示栏目名,操作类型,模板ID,只显示有标题图片,显示栏目数,显示头条操作类型,头条标题截取数,头条简介截取数,头条只显示有标题图片,附加SQL条件,显示排序[/listsonclass]', 0, 1, 9); INSERT INTO `phome_enewsbq` VALUES (21, '带模板的栏目导航标签', '\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n
参数
\r\n 		参数说明
\r\n
父栏目ID
\r\n 		查看栏目ID点这里
\r\n \\\'0\\\'为显示所有一级栏目
\r\n \\\'selfinfo\\\'显示本栏目下级栏目
\r\n
\r\n
标签模板ID
\r\n
\r\n 		查看标签模板ID点这里
\r\n
 
\r\n 		\r\n

模板标签变量说明：[!--bclassname--]：父栏目名,[!--bclassurl--]：父栏目链接,[!--bclassid--]：父栏目id

\r\n

list.var模板标签：
\r\n [!--classurl--]：栏目链接,[!--classname--]：栏目名称,[!--classid--]：栏目id,[!--classimg--]：栏目图片,[!--intro--]：栏目简介,[!--num--]：信息数,[!--no--]：序号

\r\n
\r\n
是否显示栏目信息数
\r\n 		0为不显示，1为显示
\r\n
显示栏目数
\r\n 		0为不限制
', 'sys_ShowClassByTemp', 'showclasstemp', 1, '[showclasstemp]父栏目ID,标签模板ID,是否显示栏目信息数,显示栏目数[/showclasstemp]', 0, 2, 6); INSERT INTO `phome_enewsbq` VALUES (24, '图库模型分页标签', '

\r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n
参数
\r\n 		参数说明
\r\n
\r\n
标签模板ID
\r\n
\r\n 		查看标签模板ID点这里
\r\n
 
\r\n 		\r\n

模板标签变量说明：
\r\n 图片集JS数组：[!--photor--]，缩略图导航：[!--smalldh--]
\r\n 分页导航：[!--select--]，标题分页导航：[!--titleselect--]，分页列表式导航：[!--listpage--]

\r\n

list.var模板标签：
\r\n 图片名称：[!--picname--]，图片地址：[!--picurl--]

\r\n
\r\n
导航图片宽度
\r\n 导航图片高度
\r\n 		0为按原图大小
\r\n

', 'sys_PhotoMorepage', 'eshowphoto', 1, '[eshowphoto]标签模板ID,导航图片宽度,导航图片高度[/eshowphoto]', 0, 1, 7); INSERT INTO `phome_enewsbq` VALUES (25, '复选项输出函数', '

如：[echocheckbox]\\\'title\\\',\\\'<br>\\\'[/echocheckbox]：表示按回车分隔输出title字段的项

', 'sys_EchoCheckboxFValue', 'echocheckbox', 1, '[echocheckbox]\\\'字段\\\',\\\'分隔符\\\'[/echocheckbox]', 0, 3, 5); INSERT INTO `phome_enewsbq` VALUES (26, '相关链接标签', '

标签模板ID：查看标签模板ID点这里
\r\n操作类型：0为默认；1为按表；2为按栏目；3为按标题分类
\r\n操作对象：对应操作类型的表/栏目/标题分类。空则为默认。
\r\n是否显示栏目名：0为不显示；1为显示
\r\n只显示标题图片的信息：0为不限；1为只显示标题图片的信息

', 'sys_GetOtherLinkInfo', 'otherlink', 1, '[otherlink]标签模板ID,操作对象,调用条数,标题截取字数,是否显示栏目名,操作类型,只显示标题图片的信息[/otherlink]', 0, 1, 9); INSERT INTO `phome_enewsbq` VALUES (27, '评论调用标签', '

标签模板ID：查看标签模板ID点这里
\r\n栏目ID：0为不限调用栏目，父栏目会应用于子栏目
\r\n信息ID：0为不限
\r\n显示推荐评论：0为不限；1为只显示推荐评论
\r\n操作类型：0为按发布时间；1为按支持数；2为按反对数
\r\n标签模板说明：[!--title--]:信息标题；[!--titleurl--]:信息链接；[!--titlepic--]:信息标题图片；[!--id--]:信息ID
\r\n[!--classid--]:栏目ID；[!--plid--]:评论ID；[!--username--]:发表者；[!--no--]:编号
\r\n[!--pltext--]:评论内容；[!--pltime--]:评论时间；[!--zcnum--]:支持数；[!--fdnum--]:反对数

', 'sys_ShowPlInfo', 'showplinfo', 1, '[showplinfo]调用条数,标签模板ID,栏目ID,信息ID,显示推荐评论,操作类型[/showplinfo]', 0, 3, 5); INSERT INTO `phome_enewsbq` VALUES (28, '循环栏目导航标签', '

\r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n
参数
\r\n 		参数说明
\r\n
父栏目ID
\r\n 		查看栏目ID点这里
\r\n \\\'0\\\'为显示所有一级栏目
\r\n \\\'selfinfo\\\'显示本栏目下级栏目
\r\n 多栏目固定调用可用","格开
\r\n
\r\n
标签模板ID
\r\n
\r\n 		查看标签模板ID点这里
\r\n
 
\r\n 		\r\n

模板标签变量说明：[!--bclassname--]：父栏目名,[!--bclassurl--]：父栏目链接,[!--bclassid--]：父栏目id，[!--bclassimg--]：父栏目图片,[!--bintro--]：父栏目简介,[!--bnum--]：父栏目信息数,[!--bno--]：父栏目序号

\r\n

list.var模板标签：
\r\n [!--classurl--]：栏目链接,[!--classname--]：栏目名称,[!--classid--]：栏目id,[!--classimg--]：栏目图片,[!--intro--]：栏目简介,[!--num--]：信息数,[!--no--]：序号

\r\n
\r\n
是否显示栏目信息数
\r\n 		0为不显示，1为显示
\r\n
显示栏目数
\r\n 		0为不限制
\r\n

', 'sys_ForShowSonClass', 'listshowclass', 1, '[listshowclass]父栏目ID,标签模板ID,是否显示栏目信息数,显示栏目数[/listshowclass]', 0, 2, 6); INSERT INTO `phome_enewsbq` VALUES (29, '调用TAGS的信息标签', '\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n
参数
\r\n 		参数说明
\r\n
TAGS的ID
\r\n 		查看TAGS的ID点这里
\r\n 多个ID可以用,号格开，如\\\'1,2\\\'
\r\n
显示条数
\r\n 		显示前几条记录
\r\n
标题截取数
\r\n 		截取几个字符
\r\n
标签模板ID
\r\n 		查看标签模板ID点这里
\r\n
栏目ID
\r\n 		限制只调用某一个或多个栏目的信息
\r\n 多个ID可以用,号格开，如\\\'1,2\\\'
\r\n
系统模型ID
\r\n 		限制只调用某一个或多个系统模型的信息
\r\n 多个ID可以用,号格开，如\\\'1,2\\\'
', 'sys_eShowTagsInfo', 'tagsinfo', 0, '[tagsinfo]TAGS的ID,显示条数,标题截取数,标签模板ID,栏目ID,系统模型ID[/tagsinfo]', 0, 0, 9); INSERT INTO `phome_enewsbq` VALUES (30, '调用碎片的信息标签', '\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n
参数
\r\n 		参数说明
\r\n
碎片变量名
\r\n 		查看碎片变量名点这里
\r\n
显示条数
\r\n 		显示前几条记录
\r\n
标题截取数
\r\n 		截取几个字符
\r\n


\r\n 

\r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n
碎片标签模板变量说明
\r\n
\r\n
静态碎片
\r\n 		模板标签变量说明：[!--the.spname--]：碎片名称,[!--the.spid--]：碎片ID,[!--the.sppic--]：碎片效果图,[!--the.spsay--]：碎片描述\r\n

list.var模板标签：
\r\n [!--title--]：标题,[!--oldtitle--]：标题ALT,[!--newstime--]：发布时间,[!--id--]：碎片信息ID,[!--titleurl--]：标题链接,[!--titlepic--]：标题缩图,[!--bigpic--]：标题大图,[!--titlepre--]：标题左边,[!--titlenext--]：标题右边,[!--smalltext--]：内容简介,[!--no.num--]：编号

\r\n
\r\n
动态碎片
\r\n 		模板标签变量说明：[!--the.spname--]：碎片名称,[!--the.spid--]：碎片ID,[!--the.sppic--]：碎片效果图,[!--the.spsay--]：碎片描述\r\n

list.var模板标签：
\r\n 支持变量同模型信息调用

\r\n
\r\n
代码碎片
\r\n 		无需标签模板，直接显示代码内容
', 'sys_eShowSpInfo', 'spinfo', 0, '[spinfo]碎片变量名,显示条数,标题截取数[/spinfo]', 0, 0, 9); INSERT INTO `phome_enewsbq` VALUES (31, '调用TAGS标签', '\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n
参数
\r\n 		参数说明
\r\n
分类ID
\r\n 		\\\'\\\'空为不限制，查看TAGS分类ID点这里
\r\n 多个可以用,号格开，如\\\'1,2\\\'
\r\n 内容页显示当前TAGS可以用\\\'selfinfo\\\'
\r\n
显示数量
\r\n 		显示前几条记录，0为显示所有（\\\'selfinfo\\\'本设置无效）
\r\n
每行显示数量
\r\n 		一行显示多少个TAGS，0为不换行
\r\n
显示排序
\r\n 		使用默认设置\\\'\\\'空就可以，默认是\\\'tagid desc\\\'（\\\'selfinfo\\\'本设置无效）
\r\n
只显示推荐
\r\n 		只显示推荐的TAGS，0为不限制，1为限制（\\\'selfinfo\\\'本设置无效）
\r\n
推荐TAGS属性
\r\n 		如果是推荐的TAGS，内容是否要加粗或加红（\\\'selfinfo\\\'本设置无效）
\r\n 设置\\\'s\\\'表示加粗、\\\'r\\\'表示加红、同时加粗加红用\\\'s,r\\\'
\r\n
显示间隔符
\r\n 		TAGS之间显示间隔符，默认是\\\' &nbsp; \\\'
\r\n
是否显示信息数量
\r\n 		是否在TAGS后显示信息数量，0为不显示，1为显示（\\\'selfinfo\\\'本设置无效）
\r\n
链接附加参数
\r\n 		可指定在TAGS链接后面增加参数，比如：\\\'&tempid=模板ID\\\'
\r\n
链接变量名
\r\n 		可指定在链接使用的变量名(需加引号)：tagname或tagid，默认为tagname，比如：\\\'tagname\\\'
', 'sys_eShowTags', 'showtags', 0, '[showtags]分类ID,显示数量,每行显示数量,显示排序,只显示推荐,推荐TAGS属性,显示间隔符,是否显示信息数,链接附加参数,链接变量名[/showtags]', 0, 0, 9); # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsbqclass`; CREATE TABLE `phome_enewsbqclass` ( `classid` smallint(5) unsigned NOT NULL auto_increment, `classname` char(30) NOT NULL default '', PRIMARY KEY (`classid`) ) TYPE=MyISAM; INSERT INTO `phome_enewsbqclass` VALUES (1, '信息调用'); INSERT INTO `phome_enewsbqclass` VALUES (2, '栏目调用'); INSERT INTO `phome_enewsbqclass` VALUES (3, '非信息调用'); INSERT INTO `phome_enewsbqclass` VALUES (4, '其它标签'); # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsbuybak`; CREATE TABLE `phome_enewsbuybak` ( `id` int(10) unsigned NOT NULL auto_increment, `username` char(20) NOT NULL default '', `card_no` char(120) NOT NULL default '', `buytime` datetime NOT NULL default '0000-00-00 00:00:00', `cardfen` int(10) unsigned NOT NULL default '0', `money` int(10) unsigned NOT NULL default '0', `userid` mediumint(8) unsigned NOT NULL default '0', `userdate` int(10) unsigned NOT NULL default '0', `type` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`), KEY `userid` (`userid`), KEY `type` (`type`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsbuygroup`; CREATE TABLE `phome_enewsbuygroup` ( `id` smallint(5) unsigned NOT NULL auto_increment, `gname` varchar(255) NOT NULL default '', `gmoney` int(10) unsigned NOT NULL default '0', `gfen` int(10) unsigned NOT NULL default '0', `gdate` int(10) unsigned NOT NULL default '0', `ggroupid` smallint(5) unsigned NOT NULL default '0', `gzgroupid` smallint(5) unsigned NOT NULL default '0', `buygroupid` smallint(5) unsigned NOT NULL default '0', `gsay` text NOT NULL, `myorder` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewscard`; CREATE TABLE `phome_enewscard` ( `cardid` int(10) unsigned NOT NULL auto_increment, `card_no` char(30) NOT NULL default '', `password` char(20) NOT NULL default '', `money` int(10) unsigned NOT NULL default '0', `cardfen` int(10) unsigned NOT NULL default '0', `endtime` date NOT NULL default '0000-00-00', `cardtime` datetime NOT NULL default '0000-00-00 00:00:00', `carddate` int(10) unsigned NOT NULL default '0', `cdgroupid` smallint(5) unsigned NOT NULL default '0', `cdzgroupid` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`cardid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsclass`; CREATE TABLE `phome_enewsclass` ( `classid` smallint(5) unsigned NOT NULL auto_increment, `bclassid` smallint(5) unsigned NOT NULL default '0', `classname` varchar(50) NOT NULL default '', `sonclass` text NOT NULL, `is_zt` tinyint(1) NOT NULL default '0', `lencord` smallint(6) NOT NULL default '0', `link_num` tinyint(4) NOT NULL default '0', `newstempid` smallint(6) NOT NULL default '0', `onclick` int(11) NOT NULL default '0', `listtempid` smallint(6) NOT NULL default '0', `featherclass` text NOT NULL, `islast` tinyint(1) NOT NULL default '0', `classpath` text NOT NULL, `classtype` varchar(10) NOT NULL default '', `newspath` varchar(20) NOT NULL default '', `filename` tinyint(1) NOT NULL default '0', `filetype` varchar(10) NOT NULL default '', `openpl` tinyint(1) NOT NULL default '0', `openadd` tinyint(1) NOT NULL default '0', `newline` int(11) NOT NULL default '0', `hotline` int(11) NOT NULL default '0', `goodline` int(11) NOT NULL default '0', `classurl` varchar(200) NOT NULL default '', `groupid` smallint(6) NOT NULL default '0', `myorder` smallint(6) NOT NULL default '0', `filename_qz` varchar(20) NOT NULL default '', `hotplline` tinyint(4) NOT NULL default '0', `modid` smallint(6) NOT NULL default '0', `checked` tinyint(1) NOT NULL default '0', `firstline` tinyint(4) NOT NULL default '0', `bname` varchar(50) NOT NULL default '', `islist` tinyint(1) NOT NULL default '0', `searchtempid` smallint(6) NOT NULL default '0', `tid` smallint(6) NOT NULL default '0', `tbname` varchar(60) NOT NULL default '', `maxnum` int(11) NOT NULL default '0', `checkpl` tinyint(1) NOT NULL default '0', `down_num` tinyint(4) NOT NULL default '0', `online_num` tinyint(4) NOT NULL default '0', `listorder` varchar(50) NOT NULL default '', `reorder` varchar(50) NOT NULL default '', `intro` text NOT NULL, `classimg` varchar(255) NOT NULL default '', `jstempid` smallint(6) NOT NULL default '0', `addinfofen` int(11) NOT NULL default '0', `listdt` tinyint(1) NOT NULL default '0', `showclass` tinyint(1) NOT NULL default '0', `showdt` tinyint(1) NOT NULL default '0', `checkqadd` tinyint(1) NOT NULL default '0', `qaddlist` tinyint(1) NOT NULL default '0', `qaddgroupid` text NOT NULL, `qaddshowkey` tinyint(1) NOT NULL default '0', `adminqinfo` tinyint(1) NOT NULL default '0', `doctime` smallint(6) NOT NULL default '0', `classpagekey` varchar(255) NOT NULL default '', `dtlisttempid` smallint(6) NOT NULL default '0', `classtempid` smallint(6) NOT NULL default '0', `nreclass` tinyint(1) NOT NULL default '0', `nreinfo` tinyint(1) NOT NULL default '0', `nrejs` tinyint(1) NOT NULL default '0', `nottobq` tinyint(1) NOT NULL default '0', `ipath` varchar(255) NOT NULL default '', `addreinfo` tinyint(1) NOT NULL default '0', `haddlist` tinyint(4) NOT NULL default '0', `sametitle` tinyint(1) NOT NULL default '0', `definfovoteid` smallint(6) NOT NULL default '0', `wburl` varchar(255) NOT NULL default '', `qeditchecked` tinyint(1) NOT NULL default '0', `wapstyleid` smallint(6) NOT NULL default '0', `repreinfo` tinyint(1) NOT NULL default '0', `pltempid` smallint(6) NOT NULL default '0', `cgroupid` text NOT NULL, `yhid` smallint(6) NOT NULL default '0', `wfid` smallint(6) NOT NULL default '0', `cgtoinfo` tinyint(1) NOT NULL default '0', `bdinfoid` varchar(25) NOT NULL default '', `repagenum` smallint(5) unsigned NOT NULL default '0', `keycid` smallint(6) NOT NULL default '0', `allinfos` int(10) unsigned NOT NULL default '0', `infos` int(10) unsigned NOT NULL default '0', `addtime` int(10) unsigned NOT NULL default '0', `oneinfo` tinyint(1) NOT NULL default '0', `addsql` varchar(255) NOT NULL default '', `wapislist` tinyint(1) NOT NULL default '0', `fclast` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`classid`), KEY `bclassid` (`bclassid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsclass_stats`; CREATE TABLE `phome_enewsclass_stats` ( `classid` smallint(5) unsigned NOT NULL default '0', `uptime` int(10) unsigned NOT NULL default '0', `pvall` int(10) unsigned NOT NULL default '0', `pvyear` int(10) unsigned NOT NULL default '0', `pvhalfyear` int(10) unsigned NOT NULL default '0', `pvquarter` int(10) unsigned NOT NULL default '0', `pvmonth` int(10) unsigned NOT NULL default '0', `pvweek` int(10) unsigned NOT NULL default '0', `pvday` int(10) unsigned NOT NULL default '0', `pvyesterday` int(10) unsigned NOT NULL default '0', `ipall` int(10) unsigned NOT NULL default '0', `ipyear` int(10) unsigned NOT NULL default '0', `iphalfyear` int(10) unsigned NOT NULL default '0', `ipquarter` int(10) unsigned NOT NULL default '0', `ipmonth` int(10) unsigned NOT NULL default '0', `ipweek` int(10) unsigned NOT NULL default '0', `ipday` int(10) unsigned NOT NULL default '0', `ipyesterday` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`classid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsclass_stats_ip`; CREATE TABLE `phome_enewsclass_stats_ip` ( `ip` char(21) NOT NULL default '', PRIMARY KEY (`ip`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsclass_stats_set`; CREATE TABLE `phome_enewsclass_stats_set` ( `openstats` tinyint(1) NOT NULL default '0', `pvtime` int(10) unsigned NOT NULL default '0', `statsdate` int(10) unsigned NOT NULL default '0', `changedate` int(10) unsigned NOT NULL default '0' ) TYPE=MyISAM; INSERT INTO `phome_enewsclass_stats_set` VALUES (0, 3600, 0, 20170227); # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsclassadd`; CREATE TABLE `phome_enewsclassadd` ( `classid` smallint(5) unsigned NOT NULL default '0', `classtext` mediumtext NOT NULL, `ttids` text NOT NULL, `eclasspagetext` mediumtext NOT NULL, PRIMARY KEY (`classid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsclassf`; CREATE TABLE `phome_enewsclassf` ( `fid` smallint(5) unsigned NOT NULL auto_increment, `f` varchar(30) NOT NULL default '', `fname` varchar(30) NOT NULL default '', `fform` varchar(20) NOT NULL default '', `fhtml` mediumtext NOT NULL, `fzs` varchar(255) NOT NULL default '', `myorder` smallint(5) unsigned NOT NULL default '0', `ftype` varchar(30) NOT NULL default '', `flen` varchar(20) NOT NULL default '', `fvalue` text NOT NULL, `fformsize` varchar(12) NOT NULL default '', PRIMARY KEY (`fid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsclassnavcache`; CREATE TABLE `phome_enewsclassnavcache` ( `navtype` char(16) NOT NULL default '', `userid` int(10) unsigned NOT NULL default '0', `modid` smallint(5) unsigned NOT NULL default '0', KEY `navtype` (`navtype`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsdiggips`; CREATE TABLE `phome_enewsdiggips` ( `classid` smallint(5) unsigned NOT NULL default '0', `id` int(11) NOT NULL default '0', `ips` mediumtext NOT NULL, KEY `classid` (`classid`,`id`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsdo`; CREATE TABLE `phome_enewsdo` ( `doid` smallint(5) unsigned NOT NULL auto_increment, `doname` varchar(60) NOT NULL default '', `dotime` smallint(6) NOT NULL default '0', `isopen` tinyint(1) NOT NULL default '0', `doing` tinyint(4) NOT NULL default '0', `classid` text NOT NULL, `lasttime` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`doid`) ) TYPE=MyISAM; INSERT INTO `phome_enewsdo` VALUES (1, '自动刷新首页', 12, 0, 0, ',', 1273215883); # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsdolog`; CREATE TABLE `phome_enewsdolog` ( `logid` bigint(20) NOT NULL auto_increment, `logip` varchar(20) NOT NULL default '', `logtime` datetime NOT NULL default '0000-00-00 00:00:00', `username` varchar(30) NOT NULL default '', `enews` varchar(30) NOT NULL default '', `doing` varchar(255) NOT NULL default '', `pubid` bigint(16) unsigned NOT NULL default '0', `ipport` varchar(6) NOT NULL default '', PRIMARY KEY (`logid`), KEY `pubid` (`pubid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsdownerror`; CREATE TABLE `phome_enewsdownerror` ( `errorid` int(10) unsigned NOT NULL auto_increment, `id` int(10) unsigned NOT NULL default '0', `errortext` varchar(255) NOT NULL default '', `errortime` datetime NOT NULL default '0000-00-00 00:00:00', `errorip` varchar(20) NOT NULL default '', `email` varchar(80) NOT NULL default '', `classid` smallint(5) unsigned NOT NULL default '0', `cid` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`errorid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsdownrecord`; CREATE TABLE `phome_enewsdownrecord` ( `id` int(11) NOT NULL default '0', `pathid` int(11) NOT NULL default '0', `userid` int(11) NOT NULL default '0', `username` varchar(30) NOT NULL default '', `title` varchar(120) NOT NULL default '', `cardfen` int(11) NOT NULL default '0', `truetime` int(11) NOT NULL default '0', `classid` smallint(6) NOT NULL default '0', `online` tinyint(1) NOT NULL default '0', KEY `userid` (`userid`), KEY `truetime` (`truetime`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsdownurlqz`; CREATE TABLE `phome_enewsdownurlqz` ( `urlid` smallint(5) unsigned NOT NULL auto_increment, `urlname` varchar(30) NOT NULL default '', `url` varchar(255) NOT NULL default '', `downtype` tinyint(1) NOT NULL default '0', PRIMARY KEY (`urlid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewserrorclass`; CREATE TABLE `phome_enewserrorclass` ( `classid` smallint(5) unsigned NOT NULL auto_increment, `classname` varchar(30) NOT NULL default '', PRIMARY KEY (`classid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsf`; CREATE TABLE `phome_enewsf` ( `fid` smallint(5) unsigned NOT NULL auto_increment, `f` varchar(30) NOT NULL default '', `fname` varchar(30) NOT NULL default '', `fform` varchar(20) NOT NULL default '', `fhtml` mediumtext NOT NULL, `fzs` varchar(255) NOT NULL default '', `isadd` tinyint(1) NOT NULL default '0', `isshow` tinyint(1) NOT NULL default '0', `iscj` tinyint(1) NOT NULL default '0', `cjhtml` mediumtext NOT NULL, `myorder` smallint(6) NOT NULL default '0', `ftype` varchar(30) NOT NULL default '', `flen` varchar(20) NOT NULL default '', `dotemp` tinyint(1) NOT NULL default '0', `tid` smallint(6) NOT NULL default '0', `tbname` varchar(60) NOT NULL default '', `savetxt` tinyint(1) NOT NULL default '0', `fvalue` text NOT NULL, `iskey` tinyint(1) NOT NULL default '0', `tobr` tinyint(1) NOT NULL default '0', `dohtml` tinyint(1) NOT NULL default '0', `qfhtml` mediumtext NOT NULL, `isonly` tinyint(1) NOT NULL default '0', `linkfieldval` varchar(30) NOT NULL default '', `samedata` tinyint(1) NOT NULL default '0', `fformsize` varchar(12) NOT NULL default '', `tbdataf` tinyint(1) NOT NULL default '0', `ispage` tinyint(1) NOT NULL default '0', `adddofun` varchar(255) NOT NULL default '', `editdofun` varchar(255) NOT NULL default '', `qadddofun` varchar(255) NOT NULL default '', `qeditdofun` varchar(255) NOT NULL default '', `linkfieldtb` varchar(60) NOT NULL default '', `linkfieldshow` varchar(30) NOT NULL default '', `editorys` tinyint(1) NOT NULL default '0', `issmalltext` tinyint(1) NOT NULL default '0', `fmvnum` varchar(30) NOT NULL default '', PRIMARY KEY (`fid`), KEY `tid` (`tid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsfava`; CREATE TABLE `phome_enewsfava` ( `favaid` bigint(20) NOT NULL auto_increment, `id` int(11) NOT NULL default '0', `favatime` datetime NOT NULL default '0000-00-00 00:00:00', `userid` int(11) NOT NULL default '0', `username` varchar(30) NOT NULL default '', `classid` smallint(6) NOT NULL default '0', `cid` int(11) NOT NULL default '0', PRIMARY KEY (`favaid`), KEY `userid` (`userid`), KEY `cid` (`cid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsfavaclass`; CREATE TABLE `phome_enewsfavaclass` ( `cid` int(11) NOT NULL auto_increment, `cname` varchar(30) NOT NULL default '', `userid` int(11) NOT NULL default '0', PRIMARY KEY (`cid`), KEY `userid` (`userid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsfeedback`; CREATE TABLE `phome_enewsfeedback` ( `id` int(10) unsigned NOT NULL auto_increment, `bid` smallint(5) unsigned NOT NULL default '0', `title` varchar(120) NOT NULL default '', `saytext` text NOT NULL, `name` varchar(30) NOT NULL default '', `email` varchar(80) NOT NULL default '', `mycall` varchar(30) NOT NULL default '', `homepage` varchar(160) NOT NULL default '', `company` varchar(80) NOT NULL default '', `address` varchar(255) NOT NULL default '', `saytime` datetime NOT NULL default '0000-00-00 00:00:00', `job` varchar(36) NOT NULL default '', `ip` varchar(20) NOT NULL default '', `filepath` varchar(20) NOT NULL default '', `filename` text NOT NULL, `userid` mediumint(8) unsigned NOT NULL default '0', `username` varchar(20) NOT NULL default '', `haveread` tinyint(1) NOT NULL default '0', `eipport` varchar(6) NOT NULL default '', PRIMARY KEY (`id`), KEY `bid` (`bid`), KEY `haveread` (`haveread`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsfeedbackclass`; CREATE TABLE `phome_enewsfeedbackclass` ( `bid` smallint(5) unsigned NOT NULL auto_increment, `bname` varchar(60) NOT NULL default '', `btemp` mediumtext NOT NULL, `bzs` varchar(255) NOT NULL default '', `enter` text NOT NULL, `mustenter` text NOT NULL, `filef` varchar(255) NOT NULL default '', `groupid` smallint(6) NOT NULL default '0', `checkboxf` text NOT NULL, `usernames` text NOT NULL, PRIMARY KEY (`bid`) ) TYPE=MyISAM; INSERT INTO `phome_enewsfeedbackclass` VALUES (1, '默认反馈分类', '[!--cp.header--]\r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
您的姓名:
\r\n (*)
职务:
公司名称:
联系邮箱:
联系电话:
\r\n (*)
网站:
联系地址:
信息标题:
 (*)
信息内容(*):
 \r\n
\r\n[!--cp.footer--]', '', '您的姓名name职务job公司名称company联系邮箱email联系电话mycall网站homepage联系地址address信息标题title信息内容saytext', ',name,mycall,title,saytext,', ',', 0, '', ''); # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsfeedbackf`; CREATE TABLE `phome_enewsfeedbackf` ( `fid` smallint(5) unsigned NOT NULL auto_increment, `f` varchar(30) NOT NULL default '', `fname` varchar(30) NOT NULL default '', `fform` varchar(20) NOT NULL default '', `fzs` varchar(255) NOT NULL default '', `myorder` smallint(6) NOT NULL default '0', `ftype` varchar(30) NOT NULL default '', `flen` varchar(20) NOT NULL default '', `fformsize` varchar(12) NOT NULL default '', `fvalue` text NOT NULL, PRIMARY KEY (`fid`) ) TYPE=MyISAM; INSERT INTO `phome_enewsfeedbackf` VALUES (1, 'title', '标题', 'text', '', 7, 'VARCHAR', '120', '', ''); INSERT INTO `phome_enewsfeedbackf` VALUES (2, 'saytext', '内容', 'textarea', '', 8, 'TEXT', '', '', ''); INSERT INTO `phome_enewsfeedbackf` VALUES (3, 'name', '姓名', 'text', '', 0, 'VARCHAR', '30', '', ''); INSERT INTO `phome_enewsfeedbackf` VALUES (4, 'email', '邮箱', 'text', '', 3, 'VARCHAR', '80', '', ''); INSERT INTO `phome_enewsfeedbackf` VALUES (5, 'mycall', '电话', 'text', '', 4, 'VARCHAR', '30', '', ''); INSERT INTO `phome_enewsfeedbackf` VALUES (6, 'homepage', '网站', 'text', '', 5, 'VARCHAR', '160', '', ''); INSERT INTO `phome_enewsfeedbackf` VALUES (7, 'company', '公司名称', 'text', '', 2, 'VARCHAR', '80', '', ''); INSERT INTO `phome_enewsfeedbackf` VALUES (8, 'address', '联系地址', 'text', '', 6, 'VARCHAR', '255', '', ''); INSERT INTO `phome_enewsfeedbackf` VALUES (9, 'job', '职务', 'text', '', 1, 'VARCHAR', '36', '', ''); # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsfile_1`; CREATE TABLE `phome_enewsfile_1` ( `fileid` int(10) unsigned NOT NULL auto_increment, `pubid` bigint(16) unsigned NOT NULL default '0', `filename` char(60) NOT NULL default '', `filesize` int(10) unsigned NOT NULL default '0', `path` char(20) NOT NULL default '', `adduser` char(30) NOT NULL default '', `filetime` int(10) unsigned NOT NULL default '0', `classid` smallint(5) unsigned NOT NULL default '0', `no` char(60) NOT NULL default '', `type` tinyint(1) unsigned NOT NULL default '0', `onclick` mediumint(8) unsigned NOT NULL default '0', `id` int(10) unsigned NOT NULL default '0', `cjid` int(10) unsigned NOT NULL default '0', `fpath` tinyint(1) NOT NULL default '0', `modtype` tinyint(1) NOT NULL default '0', PRIMARY KEY (`fileid`), KEY `id` (`id`), KEY `type` (`type`), KEY `classid` (`classid`), KEY `pubid` (`pubid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsfile_member`; CREATE TABLE `phome_enewsfile_member` ( `fileid` int(10) unsigned NOT NULL auto_increment, `pubid` tinyint(1) NOT NULL default '0', `filename` char(60) NOT NULL default '', `filesize` int(10) unsigned NOT NULL default '0', `path` char(20) NOT NULL default '', `adduser` char(30) NOT NULL default '', `filetime` int(10) unsigned NOT NULL default '0', `classid` tinyint(1) NOT NULL default '0', `no` char(60) NOT NULL default '', `type` tinyint(1) unsigned NOT NULL default '0', `onclick` mediumint(8) unsigned NOT NULL default '0', `id` int(10) unsigned NOT NULL default '0', `cjid` int(10) unsigned NOT NULL default '0', `fpath` tinyint(1) NOT NULL default '0', `modtype` tinyint(1) NOT NULL default '0', PRIMARY KEY (`fileid`), KEY `id` (`id`), KEY `type` (`type`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsfile_other`; CREATE TABLE `phome_enewsfile_other` ( `fileid` int(10) unsigned NOT NULL auto_increment, `pubid` tinyint(1) NOT NULL default '0', `filename` char(60) NOT NULL default '', `filesize` int(10) unsigned NOT NULL default '0', `path` char(20) NOT NULL default '', `adduser` char(30) NOT NULL default '', `filetime` int(10) unsigned NOT NULL default '0', `classid` tinyint(1) NOT NULL default '0', `no` char(60) NOT NULL default '', `type` tinyint(1) unsigned NOT NULL default '0', `onclick` mediumint(8) unsigned NOT NULL default '0', `id` int(10) unsigned NOT NULL default '0', `cjid` int(10) unsigned NOT NULL default '0', `fpath` tinyint(1) NOT NULL default '0', `modtype` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`fileid`), KEY `id` (`id`), KEY `type` (`type`), KEY `modtype` (`modtype`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsfile_public`; CREATE TABLE `phome_enewsfile_public` ( `fileid` int(10) unsigned NOT NULL auto_increment, `pubid` tinyint(1) NOT NULL default '0', `filename` char(60) NOT NULL default '', `filesize` int(10) unsigned NOT NULL default '0', `path` char(20) NOT NULL default '', `adduser` char(30) NOT NULL default '', `filetime` int(10) unsigned NOT NULL default '0', `classid` tinyint(1) NOT NULL default '0', `no` char(60) NOT NULL default '', `type` tinyint(1) unsigned NOT NULL default '0', `onclick` mediumint(8) unsigned NOT NULL default '0', `id` int(10) unsigned NOT NULL default '0', `cjid` int(10) unsigned NOT NULL default '0', `fpath` tinyint(1) NOT NULL default '0', `modtype` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`fileid`), KEY `id` (`id`), KEY `type` (`type`), KEY `modtype` (`modtype`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsgbook`; CREATE TABLE `phome_enewsgbook` ( `lyid` int(10) unsigned NOT NULL auto_increment, `name` varchar(30) NOT NULL default '', `email` varchar(80) NOT NULL default '', `mycall` varchar(30) NOT NULL default '', `lytime` datetime NOT NULL default '0000-00-00 00:00:00', `lytext` text NOT NULL, `retext` text NOT NULL, `bid` smallint(5) unsigned NOT NULL default '0', `ip` varchar(20) NOT NULL default '', `checked` tinyint(1) NOT NULL default '0', `userid` mediumint(8) unsigned NOT NULL default '0', `username` varchar(20) NOT NULL default '', `eipport` varchar(6) NOT NULL default '', PRIMARY KEY (`lyid`), KEY `bid` (`bid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsgbookclass`; CREATE TABLE `phome_enewsgbookclass` ( `bid` smallint(5) unsigned NOT NULL auto_increment, `bname` varchar(60) NOT NULL default '', `checked` tinyint(1) NOT NULL default '0', `groupid` smallint(6) NOT NULL default '0', PRIMARY KEY (`bid`) ) TYPE=MyISAM; INSERT INTO `phome_enewsgbookclass` VALUES (1, '默认留言分类', 0, 0); # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsgfenip`; CREATE TABLE `phome_enewsgfenip` ( `ip` varchar(20) NOT NULL default '', `addtime` int(11) NOT NULL default '0', UNIQUE KEY `ip` (`ip`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsgoodtype`; CREATE TABLE `phome_enewsgoodtype` ( `tid` smallint(5) unsigned NOT NULL auto_increment, `tname` varchar(60) NOT NULL default '', `ttype` tinyint(1) NOT NULL default '0', `levelid` tinyint(3) unsigned NOT NULL default '0', `myorder` smallint(6) NOT NULL default '0', `groupid` varchar(255) NOT NULL default '', `showall` tinyint(1) NOT NULL default '0', `showcid` text NOT NULL, `hiddencid` text NOT NULL, PRIMARY KEY (`tid`), KEY `ttype` (`ttype`), KEY `levelid` (`levelid`), KEY `myorder` (`myorder`) ) TYPE=MyISAM; INSERT INTO `phome_enewsgoodtype` VALUES (1, '一级头条', 1, 1, 0, '', 0, '', ''); INSERT INTO `phome_enewsgoodtype` VALUES (2, '二级头条', 1, 2, 0, '', 0, '', ''); INSERT INTO `phome_enewsgoodtype` VALUES (3, '三级头条', 1, 3, 0, '', 0, '', ''); INSERT INTO `phome_enewsgoodtype` VALUES (4, '四级头条', 1, 4, 0, '', 0, '', ''); INSERT INTO `phome_enewsgoodtype` VALUES (5, '五级头条', 1, 5, 0, '', 0, '', ''); INSERT INTO `phome_enewsgoodtype` VALUES (6, '六级头条', 1, 6, 0, '', 0, '', ''); INSERT INTO `phome_enewsgoodtype` VALUES (7, '七级头条', 1, 7, 0, '', 0, '', ''); INSERT INTO `phome_enewsgoodtype` VALUES (8, '八级头条', 1, 8, 0, '', 0, '', ''); INSERT INTO `phome_enewsgoodtype` VALUES (9, '九级头条', 1, 9, 0, '', 0, '', ''); INSERT INTO `phome_enewsgoodtype` VALUES (10, '一级推荐', 0, 1, 0, '', 0, '', ''); INSERT INTO `phome_enewsgoodtype` VALUES (11, '二级推荐', 0, 2, 0, '', 0, '', ''); INSERT INTO `phome_enewsgoodtype` VALUES (12, '三级推荐', 0, 3, 0, '', 0, '', ''); INSERT INTO `phome_enewsgoodtype` VALUES (13, '四级推荐', 0, 4, 0, '', 0, '', ''); INSERT INTO `phome_enewsgoodtype` VALUES (14, '五级推荐', 0, 5, 0, '', 0, '', ''); INSERT INTO `phome_enewsgoodtype` VALUES (15, '六级推荐', 0, 6, 0, '', 0, '', ''); INSERT INTO `phome_enewsgoodtype` VALUES (16, '七级推荐', 0, 7, 0, '', 0, '', ''); INSERT INTO `phome_enewsgoodtype` VALUES (17, '八级推荐', 0, 8, 0, '', 0, '', ''); INSERT INTO `phome_enewsgoodtype` VALUES (18, '九级推荐', 0, 9, 0, '', 0, '', ''); # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsgroup`; CREATE TABLE `phome_enewsgroup` ( `groupid` smallint(6) NOT NULL auto_increment, `groupname` varchar(50) NOT NULL default '', `dopublic` tinyint(1) NOT NULL default '0', `doclass` tinyint(1) NOT NULL default '0', `dotemplate` tinyint(1) NOT NULL default '0', `dopicnews` tinyint(1) NOT NULL default '0', `dofile` tinyint(1) NOT NULL default '0', `douser` tinyint(1) NOT NULL default '0', `dolog` tinyint(1) NOT NULL default '0', `domember` tinyint(1) NOT NULL default '0', `dobefrom` tinyint(1) NOT NULL default '0', `doword` tinyint(1) NOT NULL default '0', `dokey` tinyint(1) NOT NULL default '0', `doad` tinyint(1) NOT NULL default '0', `dovote` tinyint(1) NOT NULL default '0', `dogroup` tinyint(1) NOT NULL default '0', `doall` tinyint(1) NOT NULL default '0', `docj` tinyint(1) NOT NULL default '0', `dobq` tinyint(1) NOT NULL default '0', `domovenews` tinyint(1) NOT NULL default '0', `dopostdata` tinyint(1) NOT NULL default '0', `dochangedata` tinyint(1) NOT NULL default '0', `dopl` tinyint(1) NOT NULL default '0', `dof` tinyint(1) NOT NULL default '0', `dom` tinyint(1) NOT NULL default '0', `dodo` tinyint(1) NOT NULL default '0', `dodbdata` tinyint(1) NOT NULL default '0', `dorepnewstext` tinyint(1) NOT NULL default '0', `dotempvar` tinyint(1) NOT NULL default '0', `dostats` tinyint(1) NOT NULL default '0', `dowriter` tinyint(1) NOT NULL default '0', `dototaldata` tinyint(1) NOT NULL default '0', `dosearchkey` tinyint(1) NOT NULL default '0', `dozt` tinyint(1) NOT NULL default '0', `docard` tinyint(1) NOT NULL default '0', `dolink` tinyint(1) NOT NULL default '0', `doselfinfo` tinyint(1) NOT NULL default '0', `doexecsql` tinyint(1) NOT NULL default '0', `dotable` tinyint(1) NOT NULL default '0', `dodownurl` tinyint(1) NOT NULL default '0', `dodeldownrecord` tinyint(1) NOT NULL default '0', `doshoppayfs` tinyint(1) NOT NULL default '0', `doshopps` tinyint(1) NOT NULL default '0', `doshopdd` tinyint(1) NOT NULL default '0', `dogbook` tinyint(1) NOT NULL default '0', `dofeedback` tinyint(1) NOT NULL default '0', `douserpage` tinyint(1) NOT NULL default '0', `donotcj` tinyint(1) NOT NULL default '0', `dodownerror` tinyint(1) NOT NULL default '0', `dodelinfodata` tinyint(1) NOT NULL default '0', `doaddinfo` tinyint(1) NOT NULL default '0', `doeditinfo` tinyint(1) NOT NULL default '0', `dodelinfo` tinyint(1) NOT NULL default '0', `doadminstyle` tinyint(1) NOT NULL default '0', `dorepdownpath` tinyint(1) NOT NULL default '0', `douserjs` tinyint(1) NOT NULL default '0', `douserlist` tinyint(1) NOT NULL default '0', `domsg` tinyint(1) NOT NULL default '0', `dosendemail` tinyint(1) NOT NULL default '0', `dosetmclass` tinyint(1) NOT NULL default '0', `doinfodoc` tinyint(1) NOT NULL default '0', `dotempgroup` tinyint(1) NOT NULL default '0', `dofeedbackf` tinyint(1) NOT NULL default '0', `dotask` tinyint(1) NOT NULL default '0', `domemberf` tinyint(1) NOT NULL default '0', `dospacestyle` tinyint(1) NOT NULL default '0', `dospacedata` tinyint(1) NOT NULL default '0', `dovotemod` tinyint(1) NOT NULL default '0', `doplayer` tinyint(1) NOT NULL default '0', `dowap` tinyint(1) NOT NULL default '0', `dopay` tinyint(1) NOT NULL default '0', `dobuygroup` tinyint(1) NOT NULL default '0', `dosearchall` tinyint(1) NOT NULL default '0', `doinfotype` tinyint(1) NOT NULL default '0', `doplf` tinyint(1) NOT NULL default '0', `dopltable` tinyint(1) NOT NULL default '0', `dochadminstyle` tinyint(1) NOT NULL default '0', `dotags` tinyint(1) NOT NULL default '0', `dosp` tinyint(1) NOT NULL default '0', `doyh` tinyint(1) NOT NULL default '0', `dofirewall` tinyint(1) NOT NULL default '0', `dosetsafe` tinyint(1) NOT NULL default '0', `douserclass` tinyint(1) NOT NULL default '0', `doworkflow` tinyint(1) NOT NULL default '0', `domenu` tinyint(1) NOT NULL default '0', `dopubvar` tinyint(1) NOT NULL default '0', `doclassf` tinyint(1) NOT NULL default '0', `doztf` tinyint(1) NOT NULL default '0', `dofiletable` tinyint(1) NOT NULL default '0', `docheckinfo` tinyint(1) NOT NULL default '0', `dogoodinfo` tinyint(1) NOT NULL default '0', `dodocinfo` tinyint(1) NOT NULL default '0', `domoveinfo` tinyint(1) NOT NULL default '0', `dodttemp` tinyint(1) NOT NULL default '0', `doloadcj` tinyint(1) NOT NULL default '0', `domustcheck` tinyint(1) NOT NULL default '0', `docheckedit` tinyint(1) NOT NULL default '0', `domemberconnect` tinyint(1) NOT NULL default '0', `doprecode` tinyint(1) NOT NULL default '0', `domoreport` tinyint(1) NOT NULL default '0', `docanhtml` tinyint(1) NOT NULL default '0', `dodelclass` tinyint(1) NOT NULL default '0', `doinfofile` tinyint(1) NOT NULL default '0', `doingroup` tinyint(1) NOT NULL default '0', `domembergroup` tinyint(1) NOT NULL default '0', `doviewgroup` tinyint(1) NOT NULL default '0', `domadmingroup` tinyint(1) NOT NULL default '0', `dochmoreport` tinyint(1) NOT NULL default '0', `doisqf` tinyint(1) NOT NULL default '0', PRIMARY KEY (`groupid`) ) TYPE=MyISAM; INSERT INTO `phome_enewsgroup` VALUES (1, '超级管理员', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0); # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewshmsg`; CREATE TABLE `phome_enewshmsg` ( `mid` int(10) unsigned NOT NULL auto_increment, `title` varchar(80) NOT NULL default '', `msgtext` text NOT NULL, `haveread` tinyint(1) NOT NULL default '0', `msgtime` datetime NOT NULL default '0000-00-00 00:00:00', `to_username` varchar(30) NOT NULL default '', `from_userid` int(10) unsigned NOT NULL default '0', `from_username` varchar(30) NOT NULL default '', `isadmin` tinyint(1) NOT NULL default '0', `issys` tinyint(1) NOT NULL default '0', PRIMARY KEY (`mid`), KEY `to_username` (`to_username`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewshnotice`; CREATE TABLE `phome_enewshnotice` ( `mid` int(10) unsigned NOT NULL auto_increment, `title` varchar(80) NOT NULL default '', `msgtext` text NOT NULL, `haveread` tinyint(1) NOT NULL default '0', `msgtime` datetime NOT NULL default '0000-00-00 00:00:00', `to_username` varchar(30) NOT NULL default '', `from_userid` int(10) unsigned NOT NULL default '0', `from_username` varchar(30) NOT NULL default '', PRIMARY KEY (`mid`), KEY `to_username` (`to_username`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewshy`; CREATE TABLE `phome_enewshy` ( `fid` bigint(20) NOT NULL auto_increment, `userid` int(11) NOT NULL default '0', `fname` varchar(30) NOT NULL default '', `cid` int(11) NOT NULL default '0', `fsay` varchar(255) NOT NULL default '', PRIMARY KEY (`fid`), KEY `userid` (`userid`), KEY `cid` (`cid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewshyclass`; CREATE TABLE `phome_enewshyclass` ( `cid` int(11) NOT NULL auto_increment, `cname` varchar(30) NOT NULL default '', `userid` int(11) NOT NULL default '0', PRIMARY KEY (`cid`), KEY `userid` (`userid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsinfoclass`; CREATE TABLE `phome_enewsinfoclass` ( `classid` int(11) NOT NULL auto_increment, `bclassid` int(11) NOT NULL default '0', `classname` varchar(100) NOT NULL default '', `infourl` mediumtext NOT NULL, `newsclassid` smallint(6) NOT NULL default '0', `startday` date NOT NULL default '0000-00-00', `endday` date NOT NULL default '0000-00-00', `bz` text NOT NULL, `num` smallint(6) NOT NULL default '0', `copyimg` tinyint(1) NOT NULL default '0', `renum` smallint(6) NOT NULL default '0', `keyboard` text NOT NULL, `oldword` text NOT NULL, `newword` text NOT NULL, `titlelen` smallint(6) NOT NULL default '0', `retitlewriter` tinyint(1) NOT NULL default '0', `smalltextlen` smallint(6) NOT NULL default '0', `zz_smallurl` text NOT NULL, `zz_newsurl` text NOT NULL, `httpurl` varchar(255) NOT NULL default '', `repad` text NOT NULL, `imgurl` varchar(255) NOT NULL default '', `relistnum` smallint(6) NOT NULL default '0', `zz_titlepicl` text NOT NULL, `z_titlepicl` varchar(255) NOT NULL default '', `qz_titlepicl` varchar(255) NOT NULL default '', `save_titlepicl` varchar(10) NOT NULL default '', `keynum` tinyint(4) NOT NULL default '0', `insertnum` smallint(6) NOT NULL default '0', `copyflash` tinyint(1) NOT NULL default '0', `tid` smallint(6) NOT NULL default '0', `tbname` varchar(60) NOT NULL default '', `pagetype` tinyint(1) NOT NULL default '0', `smallpagezz` text NOT NULL, `pagezz` text NOT NULL, `smallpageallzz` text NOT NULL, `pageallzz` text NOT NULL, `mark` tinyint(1) NOT NULL default '0', `enpagecode` tinyint(1) NOT NULL default '0', `recjtheurl` tinyint(1) NOT NULL default '0', `hiddenload` tinyint(1) NOT NULL default '0', `justloadin` tinyint(1) NOT NULL default '0', `justloadcheck` tinyint(1) NOT NULL default '0', `delloadinfo` tinyint(1) NOT NULL default '0', `pagerepad` mediumtext NOT NULL, `newsztid` text NOT NULL, `getfirstpic` tinyint(4) NOT NULL default '0', `oldpagerep` text NOT NULL, `newpagerep` text NOT NULL, `keeptime` smallint(6) NOT NULL default '0', `lasttime` int(11) NOT NULL default '0', `newstextisnull` tinyint(1) NOT NULL default '0', `getfirstspic` tinyint(1) NOT NULL default '0', `getfirstspicw` smallint(6) NOT NULL default '0', `getfirstspich` smallint(6) NOT NULL default '0', `doaddtextpage` tinyint(1) NOT NULL default '0', `infourlispage` tinyint(1) NOT NULL default '0', `repf` varchar(255) NOT NULL default '', `repadf` varchar(255) NOT NULL default '', `loadkeeptime` smallint(6) NOT NULL default '0', `isnullf` varchar(255) NOT NULL default '', PRIMARY KEY (`classid`), KEY `newsclassid` (`newsclassid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsinfotype`; CREATE TABLE `phome_enewsinfotype` ( `typeid` smallint(5) unsigned NOT NULL auto_increment, `tname` varchar(30) NOT NULL default '', `mid` smallint(6) NOT NULL default '0', `myorder` smallint(6) NOT NULL default '0', `yhid` smallint(6) NOT NULL default '0', `tnum` tinyint(3) unsigned NOT NULL default '0', `listtempid` smallint(5) unsigned NOT NULL default '0', `tpath` varchar(100) NOT NULL default '', `ttype` varchar(10) NOT NULL default '', `maxnum` int(10) unsigned NOT NULL default '0', `reorder` varchar(50) NOT NULL default '', `tid` smallint(5) unsigned NOT NULL default '0', `tbname` varchar(60) NOT NULL default '', `timg` varchar(200) NOT NULL default '', `intro` varchar(255) NOT NULL default '', `pagekey` varchar(255) NOT NULL default '', `newline` tinyint(3) unsigned NOT NULL default '0', `hotline` tinyint(3) unsigned NOT NULL default '0', `goodline` tinyint(3) unsigned NOT NULL default '0', `hotplline` tinyint(3) unsigned NOT NULL default '0', `firstline` tinyint(3) unsigned NOT NULL default '0', `jstempid` smallint(5) unsigned NOT NULL default '0', `nrejs` tinyint(1) NOT NULL default '0', `listdt` tinyint(1) NOT NULL default '0', `repagenum` smallint(5) unsigned NOT NULL default '0', `fclast` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`typeid`), KEY `mid` (`mid`), KEY `myorder` (`myorder`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsinfovote`; CREATE TABLE `phome_enewsinfovote` ( `pubid` bigint(16) unsigned NOT NULL default '0', `id` int(10) unsigned NOT NULL default '0', `classid` smallint(5) unsigned NOT NULL default '0', `title` varchar(120) NOT NULL default '', `votenum` int(10) unsigned NOT NULL default '0', `voteip` mediumtext NOT NULL, `votetext` text NOT NULL, `voteclass` tinyint(1) NOT NULL default '0', `doip` tinyint(1) NOT NULL default '0', `dotime` date NOT NULL default '0000-00-00', `tempid` smallint(5) unsigned NOT NULL default '0', `width` int(10) unsigned NOT NULL default '0', `height` int(10) unsigned NOT NULL default '0', `diyotherlink` tinyint(1) NOT NULL default '0', `infouptime` int(10) unsigned NOT NULL default '0', `infodowntime` int(10) unsigned NOT NULL default '0', `copyids` varchar(255) NOT NULL default '', PRIMARY KEY (`pubid`), KEY `id` (`id`,`classid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsingroup`; CREATE TABLE `phome_enewsingroup` ( `gid` smallint(5) unsigned NOT NULL auto_increment, `gname` char(60) NOT NULL default '', `myorder` smallint(6) NOT NULL default '0', PRIMARY KEY (`gid`), KEY `myorder` (`myorder`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewskey`; CREATE TABLE `phome_enewskey` ( `keyid` smallint(5) unsigned NOT NULL auto_increment, `keyname` char(50) NOT NULL default '', `keyurl` char(200) NOT NULL default '', `cid` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`keyid`), KEY `cid` (`cid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewskeyclass`; CREATE TABLE `phome_enewskeyclass` ( `classid` smallint(5) unsigned NOT NULL auto_increment, `classname` char(30) NOT NULL default '', PRIMARY KEY (`classid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewslink`; CREATE TABLE `phome_enewslink` ( `lid` smallint(5) unsigned NOT NULL auto_increment, `lname` varchar(100) NOT NULL default '', `lpic` varchar(255) NOT NULL default '', `lurl` varchar(255) NOT NULL default '', `ltime` datetime NOT NULL default '0000-00-00 00:00:00', `onclick` int(11) NOT NULL default '0', `width` varchar(10) NOT NULL default '', `height` varchar(10) NOT NULL default '', `target` varchar(10) NOT NULL default '', `myorder` tinyint(4) NOT NULL default '0', `email` varchar(60) NOT NULL default '', `lsay` text NOT NULL, `checked` tinyint(1) NOT NULL default '0', `ltype` smallint(6) NOT NULL default '0', `classid` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`lid`), KEY `classid` (`classid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewslinkclass`; CREATE TABLE `phome_enewslinkclass` ( `classid` smallint(5) unsigned NOT NULL auto_increment, `classname` varchar(30) NOT NULL default '', PRIMARY KEY (`classid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewslinktmp`; CREATE TABLE `phome_enewslinktmp` ( `newsurl` varchar(255) NOT NULL default '', `checkrnd` varchar(50) NOT NULL default '', `linkid` bigint(20) NOT NULL auto_increment, `titlepic` varchar(255) NOT NULL default '', PRIMARY KEY (`linkid`), KEY `checkrnd` (`checkrnd`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewslog`; CREATE TABLE `phome_enewslog` ( `loginid` int(10) unsigned NOT NULL auto_increment, `username` varchar(30) NOT NULL default '', `logintime` datetime NOT NULL default '0000-00-00 00:00:00', `loginip` varchar(20) NOT NULL default '', `status` tinyint(1) NOT NULL default '0', `password` varchar(30) NOT NULL default '', `loginauth` tinyint(1) NOT NULL default '0', `ipport` varchar(6) NOT NULL default '', PRIMARY KEY (`loginid`), KEY `status` (`status`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsloginfail`; CREATE TABLE `phome_enewsloginfail` ( `ip` varchar(20) NOT NULL default '', `num` tinyint(4) NOT NULL default '0', `lasttime` int(11) NOT NULL default '0', PRIMARY KEY (`ip`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsmember`; CREATE TABLE `phome_enewsmember` ( `userid` int(10) unsigned NOT NULL auto_increment, `username` char(20) NOT NULL default '', `password` char(32) NOT NULL default '', `rnd` char(20) NOT NULL default '', `email` char(50) NOT NULL default '', `registertime` int(10) unsigned NOT NULL default '0', `groupid` smallint(5) unsigned NOT NULL default '0', `userfen` mediumint(8) unsigned NOT NULL default '0', `userdate` int(10) unsigned NOT NULL default '0', `money` float(11,2) NOT NULL default '0.00', `zgroupid` smallint(5) unsigned NOT NULL default '0', `havemsg` tinyint(1) NOT NULL default '0', `checked` tinyint(1) NOT NULL default '0', `salt` char(8) NOT NULL default '', `userkey` char(12) NOT NULL default '', `ingid` smallint(5) unsigned NOT NULL default '0', `agid` smallint(5) unsigned NOT NULL default '0', `isern` tinyint(1) NOT NULL default '0', PRIMARY KEY (`userid`), UNIQUE KEY `username` (`username`), KEY `groupid` (`groupid`), KEY `ingid` (`ingid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsmember_connect`; CREATE TABLE `phome_enewsmember_connect` ( `id` int(10) unsigned NOT NULL auto_increment, `userid` mediumint(8) unsigned NOT NULL default '0', `apptype` char(20) NOT NULL default '', `bindkey` char(32) NOT NULL default '', `bindtime` int(10) unsigned NOT NULL default '0', `loginnum` int(10) unsigned NOT NULL default '0', `lasttime` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `userid` (`userid`), KEY `bindkey` (`bindkey`), KEY `apptype` (`apptype`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsmember_connect_app`; CREATE TABLE `phome_enewsmember_connect_app` ( `id` smallint(5) unsigned NOT NULL auto_increment, `apptype` char(20) NOT NULL default '', `appname` char(30) NOT NULL default '', `appid` char(60) NOT NULL default '', `appkey` char(120) NOT NULL default '', `isclose` tinyint(1) NOT NULL default '0', `myorder` smallint(5) unsigned NOT NULL default '0', `qappname` char(30) NOT NULL default '', `appsay` char(255) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `apptype` (`apptype`), KEY `isclose` (`isclose`), KEY `myorder` (`myorder`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsmemberadd`; CREATE TABLE `phome_enewsmemberadd` ( `userid` int(10) unsigned NOT NULL default '0', `truename` varchar(20) NOT NULL default '', `oicq` varchar(25) NOT NULL default '', `msn` varchar(120) NOT NULL default '', `mycall` varchar(30) NOT NULL default '', `phone` varchar(30) NOT NULL default '', `address` varchar(255) NOT NULL default '', `zip` varchar(8) NOT NULL default '', `spacestyleid` smallint(6) NOT NULL default '0', `homepage` varchar(200) NOT NULL default '', `saytext` text NOT NULL, `company` varchar(255) NOT NULL default '', `fax` varchar(30) NOT NULL default '', `userpic` varchar(200) NOT NULL default '', `spacename` varchar(255) NOT NULL default '', `spacegg` text NOT NULL, `viewstats` int(11) NOT NULL default '0', `regip` varchar(20) NOT NULL default '', `lasttime` int(10) unsigned NOT NULL default '0', `lastip` varchar(20) NOT NULL default '', `loginnum` int(10) unsigned NOT NULL default '0', `regipport` varchar(6) NOT NULL default '', `lastipport` varchar(6) NOT NULL default '', PRIMARY KEY (`userid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsmemberf`; CREATE TABLE `phome_enewsmemberf` ( `fid` smallint(5) unsigned NOT NULL auto_increment, `f` varchar(30) NOT NULL default '', `fname` varchar(30) NOT NULL default '', `fform` varchar(20) NOT NULL default '', `fhtml` mediumtext NOT NULL, `fzs` varchar(255) NOT NULL default '', `myorder` smallint(6) NOT NULL default '0', `ftype` varchar(30) NOT NULL default '', `flen` varchar(20) NOT NULL default '', `fvalue` text NOT NULL, `fformsize` varchar(12) NOT NULL default '', PRIMARY KEY (`fid`) ) TYPE=MyISAM; INSERT INTO `phome_enewsmemberf` VALUES (1, 'truename', '真实姓名', 'text', '\r\n">\r\n', '', 1, 'VARCHAR', '20', '', ''); INSERT INTO `phome_enewsmemberf` VALUES (2, 'oicq', 'QQ号码', 'text', '\\">\r\n', '', 5, 'VARCHAR', '25', '', ''); INSERT INTO `phome_enewsmemberf` VALUES (3, 'msn', 'MSN', 'text', '\\">\r\n', '', 6, 'VARCHAR', '120', '', ''); INSERT INTO `phome_enewsmemberf` VALUES (4, 'mycall', '联系电话', 'text', '\\">\r\n', '', 2, 'VARCHAR', '30', '', ''); INSERT INTO `phome_enewsmemberf` VALUES (5, 'phone', '手机', 'text', '\\">\r\n', '', 4, 'VARCHAR', '30', '', ''); INSERT INTO `phome_enewsmemberf` VALUES (6, 'address', '联系地址', 'text', '\\" size=\\"50\\">\r\n', '', 9, 'VARCHAR', '255', '', ''); INSERT INTO `phome_enewsmemberf` VALUES (7, 'zip', '邮编', 'text', '\\" size=\\"8\\">\r\n', '', 10, 'VARCHAR', '8', '', ''); INSERT INTO `phome_enewsmemberf` VALUES (9, 'homepage', '网址', 'text', '\r\n">\r\n', '', 7, 'VARCHAR', '200', '', ''); INSERT INTO `phome_enewsmemberf` VALUES (10, 'saytext', '简介', 'textarea', '\r\n', '', 11, 'TEXT', '', '', ''); INSERT INTO `phome_enewsmemberf` VALUES (11, 'company', '公司名称', 'text', '\\" size=\\"38\\">\r\n', '', 0, 'VARCHAR', '255', '', ''); INSERT INTO `phome_enewsmemberf` VALUES (12, 'fax', '传真', 'text', '\r\n">\r\n', '', 3, 'VARCHAR', '30', '', ''); INSERT INTO `phome_enewsmemberf` VALUES (13, 'userpic', '会员头像', 'img', '  \r\n\\"?>', '', 8, 'VARCHAR', '200', '', ''); # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsmemberfeedback`; CREATE TABLE `phome_enewsmemberfeedback` ( `fid` int(10) unsigned NOT NULL auto_increment, `name` varchar(12) NOT NULL default '', `company` varchar(80) NOT NULL default '', `phone` varchar(30) NOT NULL default '', `fax` varchar(20) NOT NULL default '', `email` varchar(80) NOT NULL default '', `address` varchar(255) NOT NULL default '', `zip` varchar(8) NOT NULL default '', `title` varchar(120) NOT NULL default '', `ftext` text NOT NULL, `userid` mediumint(8) unsigned NOT NULL default '0', `ip` varchar(15) NOT NULL default '', `uid` mediumint(8) unsigned NOT NULL default '0', `uname` varchar(20) NOT NULL default '', `addtime` datetime NOT NULL default '0000-00-00 00:00:00', `eipport` varchar(6) NOT NULL default '', PRIMARY KEY (`fid`), KEY `userid` (`userid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsmemberform`; CREATE TABLE `phome_enewsmemberform` ( `fid` smallint(5) unsigned NOT NULL auto_increment, `fname` varchar(60) NOT NULL default '', `ftemp` mediumtext NOT NULL, `fzs` varchar(255) NOT NULL default '', `enter` text NOT NULL, `mustenter` text NOT NULL, `filef` varchar(255) NOT NULL default '', `imgf` varchar(255) NOT NULL default '0', `tobrf` text NOT NULL, `viewenter` text NOT NULL, `searchvar` varchar(255) NOT NULL default '', `canaddf` text NOT NULL, `caneditf` text NOT NULL, `checkboxf` text NOT NULL, PRIMARY KEY (`fid`) ) TYPE=MyISAM; INSERT INTO `phome_enewsmemberform` VALUES (1, '个人注册表单', '\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
真实姓名[!--truename--]
QQ号码[!--oicq--]
MSN[!--msn--]
联系电话[!--mycall--]
手机[!--phone--]
网站地址[!--homepage--]
会员头像[!--userpic--]
联系地址[!--address--] 邮编: [!--zip--]
个人介绍[!--saytext--]
', '', '真实姓名truename联系电话mycall手机phoneQQ号码oicqMSNmsn网站地址homepage会员头像userpic联系地址address邮编zip简介saytext', '', ',', ',userpic,', ',saytext,', '真实姓名truename联系电话mycall手机phoneQQ号码oicqMSNmsn网站地址homepage会员头像userpic联系地址address邮编zip简介saytext', '', ',truename,mycall,phone,oicq,msn,homepage,userpic,address,zip,saytext,', ',truename,mycall,phone,oicq,msn,homepage,userpic,address,zip,saytext,', ','); INSERT INTO `phome_enewsmemberform` VALUES (2, '企员注册表单', '\r\n\r\n
公司名称[!--company--](*)
联系人[!--truename--](*)
联系电话[!--mycall--](*)
传真[!--fax--]
手机[!--phone--]
QQ号码[!--oicq--]
MSN[!--msn--]
网址[!--homepage--]
会员头像[!--userpic--]
联系地址[!--address--] 邮编: [!--zip--]
公司介绍[!--saytext--]
', '', '公司名称company联系人truename联系电话mycall传真fax手机phoneQQ号码oicqMSNmsn网址homepage会员头像userpic联系地址address邮编zip公司介绍saytext', ',company,truename,mycall,', ',', ',userpic,', ',saytext,', '公司名称company联系人truename联系电话mycall传真fax手机phoneQQ号码oicqMSNmsn网址homepage会员头像userpic联系地址address邮编zip公司介绍saytext', ',company,', ',company,truename,mycall,fax,phone,oicq,msn,homepage,userpic,address,zip,saytext,', ',company,truename,mycall,fax,phone,oicq,msn,homepage,userpic,address,zip,saytext,', ','); # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsmembergbook`; CREATE TABLE `phome_enewsmembergbook` ( `gid` int(10) unsigned NOT NULL auto_increment, `userid` mediumint(8) unsigned NOT NULL default '0', `isprivate` tinyint(1) NOT NULL default '0', `uid` mediumint(8) unsigned NOT NULL default '0', `uname` varchar(20) NOT NULL default '', `ip` varchar(15) NOT NULL default '', `addtime` datetime NOT NULL default '0000-00-00 00:00:00', `gbtext` text NOT NULL, `retext` text NOT NULL, `checked` tinyint(1) NOT NULL default '0', `eipport` varchar(6) NOT NULL default '', PRIMARY KEY (`gid`), KEY `userid` (`userid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsmembergroup`; CREATE TABLE `phome_enewsmembergroup` ( `groupid` smallint(6) NOT NULL auto_increment, `groupname` varchar(60) NOT NULL default '', `level` smallint(6) NOT NULL default '0', `checked` tinyint(1) NOT NULL default '0', `favanum` smallint(6) NOT NULL default '0', `daydown` int(11) NOT NULL default '0', `msglen` int(11) NOT NULL default '0', `msgnum` int(11) NOT NULL default '0', `canreg` tinyint(1) NOT NULL default '0', `formid` smallint(6) NOT NULL default '0', `regchecked` tinyint(1) NOT NULL default '0', `spacestyleid` smallint(6) NOT NULL default '0', `dayaddinfo` smallint(6) NOT NULL default '0', `infochecked` tinyint(1) NOT NULL default '0', `plchecked` tinyint(1) NOT NULL default '0', PRIMARY KEY (`groupid`) ) TYPE=MyISAM; INSERT INTO `phome_enewsmembergroup` VALUES (1, '普通会员', 1, 0, 120, 0, 255, 50, 1, 1, 0, 1, 0, 0, 0); INSERT INTO `phome_enewsmembergroup` VALUES (2, 'VIP会员', 2, 0, 200, 0, 255, 120, 0, 1, 0, 1, 0, 0, 0); INSERT INTO `phome_enewsmembergroup` VALUES (3, '企业会员', 1, 0, 120, 0, 255, 50, 1, 2, 0, 2, 0, 0, 0); INSERT INTO `phome_enewsmembergroup` VALUES (4, '企业VIP会员', 2, 0, 200, 0, 255, 120, 0, 2, 0, 2, 0, 0, 0); # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsmemberpub`; CREATE TABLE `phome_enewsmemberpub` ( `userid` mediumint(8) unsigned NOT NULL auto_increment, `todayinfodate` char(10) NOT NULL default '', `todayaddinfo` mediumint(8) unsigned NOT NULL default '0', `todaydate` char(10) NOT NULL default '', `todaydown` mediumint(8) unsigned NOT NULL default '0', `authstr` char(30) NOT NULL default '', PRIMARY KEY (`userid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsmenu`; CREATE TABLE `phome_enewsmenu` ( `menuid` int(10) unsigned NOT NULL auto_increment, `menuname` varchar(60) NOT NULL default '', `menuurl` varchar(255) NOT NULL default '', `myorder` smallint(5) unsigned NOT NULL default '0', `classid` smallint(5) unsigned NOT NULL default '0', `addhash` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`menuid`), KEY `myorder` (`myorder`), KEY `classid` (`classid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsmenuclass`; CREATE TABLE `phome_enewsmenuclass` ( `classid` smallint(5) unsigned NOT NULL auto_increment, `classname` varchar(60) NOT NULL default '', `issys` tinyint(1) NOT NULL default '0', `myorder` smallint(5) unsigned NOT NULL default '0', `classtype` tinyint(1) NOT NULL default '0', `groupids` varchar(255) NOT NULL default '', PRIMARY KEY (`classid`), KEY `myorder` (`myorder`), KEY `classtype` (`classtype`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsmod`; CREATE TABLE `phome_enewsmod` ( `mid` smallint(5) unsigned NOT NULL auto_increment, `mname` varchar(100) NOT NULL default '', `mtemp` mediumtext NOT NULL, `mzs` varchar(255) NOT NULL default '', `cj` mediumtext NOT NULL, `enter` mediumtext NOT NULL, `tempvar` mediumtext NOT NULL, `sonclass` text NOT NULL, `searchvar` varchar(255) NOT NULL default '', `tid` smallint(5) unsigned NOT NULL default '0', `tbname` varchar(60) NOT NULL default '', `qenter` mediumtext NOT NULL, `mustqenterf` text NOT NULL, `qmtemp` mediumtext NOT NULL, `listandf` text NOT NULL, `setandf` tinyint(1) NOT NULL default '0', `listtempvar` mediumtext NOT NULL, `qmname` varchar(30) NOT NULL default '', `canaddf` text NOT NULL, `caneditf` text NOT NULL, `definfovoteid` smallint(6) NOT NULL default '0', `showmod` tinyint(1) NOT NULL default '0', `usemod` tinyint(1) NOT NULL default '0', `myorder` smallint(6) NOT NULL default '0', `orderf` text NOT NULL, `isdefault` tinyint(1) NOT NULL default '0', `listfile` varchar(30) NOT NULL default '', `printtempid` smallint(6) NOT NULL default '0', `maddfun` varchar(255) NOT NULL default '', `meditfun` varchar(255) NOT NULL default '', `qmaddfun` varchar(255) NOT NULL default '', `qmeditfun` varchar(255) NOT NULL default '', PRIMARY KEY (`mid`), KEY `tid` (`tid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsmoreport`; CREATE TABLE `phome_enewsmoreport` ( `pid` int(11) NOT NULL auto_increment, `pname` char(60) NOT NULL default '', `purl` char(255) NOT NULL default '', `ppath` char(255) NOT NULL default '', `postpass` char(120) NOT NULL default '', `postfile` char(255) NOT NULL default '', `tempgid` smallint(5) unsigned NOT NULL default '0', `mustdt` tinyint(1) NOT NULL default '0', `isclose` tinyint(1) NOT NULL default '0', `closeadd` tinyint(1) NOT NULL default '0', `headersign` char(255) NOT NULL default '', `openadmin` tinyint(1) NOT NULL default '0', `rehtml` tinyint(4) NOT NULL default '0', PRIMARY KEY (`pid`), KEY `isclose` (`isclose`) ) TYPE=MyISAM; INSERT INTO `phome_enewsmoreport` VALUES (1, '主访问端', '', '', '', '', 0, 0, 0, 0, '', 0, 0); # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsnotcj`; CREATE TABLE `phome_enewsnotcj` ( `id` smallint(5) unsigned NOT NULL auto_increment, `word` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM; INSERT INTO `phome_enewsnotcj` VALUES (1, ''); INSERT INTO `phome_enewsnotcj` VALUES (2, ''); INSERT INTO `phome_enewsnotcj` VALUES (3, ''); INSERT INTO `phome_enewsnotcj` VALUES (4, '
\r\nEmpire CMS,phome.net\r\n
'); INSERT INTO `phome_enewsnotcj` VALUES (5, '
\r\n拥有帝国一切，皆有可能。欢迎访问phome.net\r\n
'); # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsnotice`; CREATE TABLE `phome_enewsnotice` ( `mid` int(10) unsigned NOT NULL auto_increment, `title` varchar(80) NOT NULL default '', `msgtext` text NOT NULL, `haveread` tinyint(1) NOT NULL default '0', `msgtime` datetime NOT NULL default '0000-00-00 00:00:00', `to_username` varchar(30) NOT NULL default '', `from_userid` int(10) unsigned NOT NULL default '0', `from_username` varchar(30) NOT NULL default '', PRIMARY KEY (`mid`), KEY `to_username` (`to_username`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewspage`; CREATE TABLE `phome_enewspage` ( `id` int(10) unsigned NOT NULL auto_increment, `title` varchar(120) NOT NULL default '', `pagetext` mediumtext NOT NULL, `path` varchar(255) NOT NULL default '', `classid` smallint(5) unsigned NOT NULL default '0', `pagetitle` varchar(120) NOT NULL default '', `pagekeywords` varchar(255) NOT NULL default '', `pagedescription` varchar(255) NOT NULL default '', `tempid` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `classid` (`classid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewspageclass`; CREATE TABLE `phome_enewspageclass` ( `classid` smallint(5) unsigned NOT NULL auto_increment, `classname` varchar(30) NOT NULL default '', PRIMARY KEY (`classid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewspayapi`; CREATE TABLE `phome_enewspayapi` ( `payid` smallint(5) unsigned NOT NULL auto_increment, `paytype` varchar(20) NOT NULL default '', `myorder` tinyint(4) NOT NULL default '0', `payfee` varchar(10) NOT NULL default '', `payuser` varchar(60) NOT NULL default '', `partner` varchar(60) NOT NULL default '', `paykey` varchar(120) NOT NULL default '', `paylogo` varchar(200) NOT NULL default '', `paysay` text NOT NULL, `payname` varchar(120) NOT NULL default '', `isclose` tinyint(1) NOT NULL default '0', `payemail` varchar(120) NOT NULL default '', `paymethod` tinyint(1) NOT NULL default '0', PRIMARY KEY (`payid`), UNIQUE KEY `paytype` (`paytype`) ) TYPE=MyISAM; INSERT INTO `phome_enewspayapi` VALUES (1, 'tenpay', 1, '0', '', '', '', '', '财付通（www.tenpay.com） - 腾讯旗下在线支付平台，通过国家权威安全认证，支持各大银行网上支付。', '财付通', 0, '', 0); INSERT INTO `phome_enewspayapi` VALUES (2, 'chinabank', 2, '0', '', '', '', '', '网银在线与中国工商银行、招商银行、中国建设银行、农业银行、民生银行等数十家金融机构达成协议。全面支持全国19家银行的信用卡及借记卡实现网上支付。（网址：http://www.chinabank.com.cn）', '网银在线', 0, '', 0); INSERT INTO `phome_enewspayapi` VALUES (3, 'alipay', 0, '0', '', '', '', '', '支付宝网站(www.alipay.com) 是国内先进的网上支付平台。', '支付宝接口', 0, '', 1); # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewspayrecord`; CREATE TABLE `phome_enewspayrecord` ( `id` int(10) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', `username` varchar(30) NOT NULL default '', `orderid` varchar(50) NOT NULL default '', `money` varchar(20) NOT NULL default '', `posttime` datetime NOT NULL default '0000-00-00 00:00:00', `paybz` varchar(255) NOT NULL default '', `type` varchar(12) NOT NULL default '', `payip` varchar(20) NOT NULL default '', PRIMARY KEY (`id`), KEY `userid` (`userid`,`orderid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewspic`; CREATE TABLE `phome_enewspic` ( `picid` int(10) unsigned NOT NULL auto_increment, `title` varchar(120) NOT NULL default '', `pic_url` varchar(200) NOT NULL default '', `url` varchar(200) NOT NULL default '', `pic_width` varchar(20) NOT NULL default '', `pic_height` varchar(20) NOT NULL default '', `open_pic` varchar(20) NOT NULL default '', `border` tinyint(1) NOT NULL default '0', `pictext` text NOT NULL, `classid` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`picid`), KEY `classid` (`classid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewspicclass`; CREATE TABLE `phome_enewspicclass` ( `classid` smallint(5) unsigned NOT NULL auto_increment, `classname` varchar(60) NOT NULL default '', PRIMARY KEY (`classid`) ) TYPE=MyISAM; INSERT INTO `phome_enewspicclass` VALUES (1, '默认图片信息类别'); # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewspl_1`; CREATE TABLE `phome_enewspl_1` ( `plid` int(10) unsigned NOT NULL auto_increment, `pubid` bigint(16) NOT NULL default '0', `username` varchar(20) NOT NULL default '', `sayip` varchar(20) NOT NULL default '', `saytime` int(10) unsigned NOT NULL default '0', `id` int(10) unsigned NOT NULL default '0', `checked` tinyint(1) NOT NULL default '0', `classid` smallint(5) unsigned NOT NULL default '0', `zcnum` smallint(5) unsigned NOT NULL default '0', `fdnum` smallint(5) unsigned NOT NULL default '0', `userid` mediumint(8) unsigned NOT NULL default '0', `isgood` tinyint(1) NOT NULL default '0', `saytext` text NOT NULL, `eipport` varchar(6) NOT NULL default '', PRIMARY KEY (`plid`), KEY `id` (`id`), KEY `classid` (`classid`), KEY `pubid` (`pubid`,`checked`,`plid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewspl_set`; CREATE TABLE `phome_enewspl_set` ( `id` tinyint(3) unsigned NOT NULL auto_increment, `pltime` smallint(5) unsigned NOT NULL default '0', `plsize` smallint(5) unsigned NOT NULL default '0', `plincludesize` smallint(5) unsigned NOT NULL default '0', `plkey_ok` tinyint(1) NOT NULL default '0', `plface` text NOT NULL, `plfacenum` tinyint(3) unsigned NOT NULL default '0', `plgroupid` smallint(5) unsigned NOT NULL default '0', `plclosewords` text NOT NULL, `plf` text NOT NULL, `plmustf` text NOT NULL, `pldatatbs` text NOT NULL, `defpltempid` smallint(5) unsigned NOT NULL default '0', `pl_num` smallint(5) unsigned NOT NULL default '0', `pldeftb` smallint(5) unsigned NOT NULL default '0', `plurl` varchar(200) NOT NULL default '', `plmaxfloor` smallint(5) unsigned NOT NULL default '0', `plquotetemp` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM; INSERT INTO `phome_enewspl_set` VALUES (1, 20, 500, 0, 1, '||[~e.jy~]##1.gif||[~e.kq~]##2.gif||[~e.se~]##3.gif||[~e.sq~]##4.gif||[~e.lh~]##5.gif||[~e.ka~]##6.gif||[~e.hh~]##7.gif||[~e.ys~]##8.gif||[~e.ng~]##9.gif||[~e.ot~]##10.gif||', 10, 0, '', '', '', ',1,', 1, 12, 1, '/ecms75/e/pl/', 0, '
\r\n网友 [!--username--] 的原文：\r\n

[!--pltext--]

\r\n
'); # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsplayer`; CREATE TABLE `phome_enewsplayer` ( `id` smallint(5) unsigned NOT NULL auto_increment, `player` varchar(30) NOT NULL default '', `filename` varchar(20) NOT NULL default '', `bz` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM; INSERT INTO `phome_enewsplayer` VALUES (1, 'RealPlayer', 'realplayer.php', 'RealPlayer播放器'); INSERT INTO `phome_enewsplayer` VALUES (2, 'MediaPlayer', 'mediaplayer.php', 'MediaPlayer播放器'); INSERT INTO `phome_enewsplayer` VALUES (3, 'FLASH', 'flasher.php', 'FLASH播放器'); INSERT INTO `phome_enewsplayer` VALUES (4, 'FLV播放器', 'flver.php', 'FLV播放器'); INSERT INTO `phome_enewsplayer` VALUES (5, 'HTML5Video', 'htmlvideo.php', 'HTML5的video播放标签'); INSERT INTO `phome_enewsplayer` VALUES (6, 'JWPlayer', 'jwplayer.php', 'JWPlayer播放器'); INSERT INTO `phome_enewsplayer` VALUES (7, 'HTML5Audio', 'htmlaudio.php', 'HTML5的audio播放标签'); # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsplf`; CREATE TABLE `phome_enewsplf` ( `fid` smallint(5) unsigned NOT NULL auto_increment, `f` varchar(30) NOT NULL default '', `fname` varchar(30) NOT NULL default '', `fzs` varchar(255) NOT NULL default '', `ftype` varchar(30) NOT NULL default '', `flen` varchar(20) NOT NULL default '', `ismust` tinyint(1) NOT NULL default '0', PRIMARY KEY (`fid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewspostdata`; CREATE TABLE `phome_enewspostdata` ( `postid` bigint(20) unsigned NOT NULL auto_increment, `rnd` varchar(32) NOT NULL default '', `postdata` varchar(255) NOT NULL default '', `ispath` tinyint(1) NOT NULL default '0', PRIMARY KEY (`postid`), KEY `rnd` (`rnd`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewspostserver`; CREATE TABLE `phome_enewspostserver` ( `pid` smallint(5) unsigned NOT NULL auto_increment, `pname` varchar(60) NOT NULL default '', `purl` varchar(255) NOT NULL default '', `ptype` tinyint(1) NOT NULL default '0', `ftphost` varchar(255) NOT NULL default '', `ftpport` varchar(20) NOT NULL default '', `ftpusername` varchar(120) NOT NULL default '', `ftppassword` varchar(120) NOT NULL default '', `ftppath` varchar(255) NOT NULL default '', `ftpmode` tinyint(1) NOT NULL default '0', `ftpssl` tinyint(1) NOT NULL default '0', `ftppasv` tinyint(1) NOT NULL default '0', `ftpouttime` smallint(5) unsigned NOT NULL default '0', `lastposttime` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`pid`), KEY `ptype` (`ptype`) ) TYPE=MyISAM; INSERT INTO `phome_enewspostserver` VALUES (1, '附件服务器', '', 1, '', '', '', '', '', 0, 0, 0, 0, 0); # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewspublic`; CREATE TABLE `phome_enewspublic` ( `id` tinyint(3) unsigned NOT NULL auto_increment, `newsurl` varchar(120) NOT NULL default '', `sitename` varchar(60) NOT NULL default '', `email` varchar(50) NOT NULL default '', `filetype` text NOT NULL, `filesize` int(11) NOT NULL default '0', `hotnum` tinyint(4) NOT NULL default '0', `newnum` tinyint(4) NOT NULL default '0', `relistnum` int(11) NOT NULL default '0', `renewsnum` int(11) NOT NULL default '0', `min_keyboard` tinyint(4) NOT NULL default '0', `max_keyboard` tinyint(4) NOT NULL default '0', `search_num` tinyint(4) NOT NULL default '0', `search_pagenum` tinyint(4) NOT NULL default '0', `newslink` tinyint(4) NOT NULL default '0', `checked` tinyint(1) NOT NULL default '0', `searchtime` int(11) NOT NULL default '0', `loginnum` smallint(6) NOT NULL default '0', `logintime` int(11) NOT NULL default '0', `addnews_ok` tinyint(1) NOT NULL default '0', `register_ok` tinyint(1) NOT NULL default '0', `indextype` varchar(10) NOT NULL default '', `goodlencord` tinyint(4) NOT NULL default '0', `goodtype` varchar(10) NOT NULL default '', `goodnum` tinyint(4) NOT NULL default '0', `searchtype` varchar(10) NOT NULL default '', `exittime` smallint(6) NOT NULL default '0', `smalltextlen` smallint(6) NOT NULL default '0', `defaultgroupid` smallint(6) NOT NULL default '0', `fileurl` varchar(255) NOT NULL default '', `phpmode` tinyint(1) NOT NULL default '0', `ftphost` varchar(255) NOT NULL default '', `ftpport` varchar(20) NOT NULL default '21', `ftpusername` varchar(120) NOT NULL default '', `ftppassword` varchar(120) NOT NULL default '', `ftppath` varchar(255) NOT NULL default '', `ftpmode` tinyint(1) NOT NULL default '0', `install` tinyint(1) NOT NULL default '0', `hotplnum` tinyint(4) NOT NULL default '0', `softversion` varchar(30) NOT NULL default '0', `lctime` int(11) NOT NULL default '0', `dorepnum` smallint(6) NOT NULL default '0', `loadtempnum` smallint(6) NOT NULL default '0', `firstnum` tinyint(4) NOT NULL default '0', `bakdbpath` varchar(50) NOT NULL default '', `bakdbzip` varchar(50) NOT NULL default '', `downpass` varchar(32) NOT NULL default '', `min_userlen` tinyint(4) NOT NULL default '0', `max_userlen` tinyint(4) NOT NULL default '0', `min_passlen` tinyint(4) NOT NULL default '0', `max_passlen` tinyint(4) NOT NULL default '0', `filechmod` tinyint(1) NOT NULL default '0', `tid` smallint(6) NOT NULL default '0', `tbname` varchar(60) NOT NULL default '', `loginkey_ok` tinyint(1) NOT NULL default '0', `limittype` tinyint(1) NOT NULL default '0', `redodown` smallint(6) NOT NULL default '0', `candocode` tinyint(1) NOT NULL default '0', `opennotcj` tinyint(1) NOT NULL default '0', `reuserpagenum` int(11) NOT NULL default '0', `revotejsnum` int(11) NOT NULL default '0', `readjsnum` int(11) NOT NULL default '0', `qaddtran` tinyint(1) NOT NULL default '0', `qaddtransize` int(11) NOT NULL default '0', `ebakthisdb` tinyint(1) NOT NULL default '0', `delnewsnum` int(11) NOT NULL default '0', `markpos` tinyint(4) NOT NULL default '0', `markimg` varchar(80) NOT NULL default '', `marktext` varchar(80) NOT NULL default '', `markfontsize` varchar(12) NOT NULL default '', `markfontcolor` varchar(12) NOT NULL default '', `markfont` varchar(80) NOT NULL default '', `adminloginkey` tinyint(1) NOT NULL default '0', `php_outtime` int(11) NOT NULL default '0', `listpagefun` varchar(36) NOT NULL default '', `textpagefun` varchar(36) NOT NULL default '', `adfile` varchar(30) NOT NULL default '', `notsaveurl` text NOT NULL, `jstempid` smallint(6) NOT NULL default '0', `rssnum` smallint(6) NOT NULL default '0', `rsssub` smallint(6) NOT NULL default '0', `savetxtf` text NOT NULL, `dorepdlevelnum` int(11) NOT NULL default '0', `listpagelistfun` varchar(36) NOT NULL default '', `listpagelistnum` smallint(6) NOT NULL default '0', `infolinknum` int(11) NOT NULL default '0', `searchgroupid` smallint(6) NOT NULL default '0', `opencopytext` tinyint(1) NOT NULL default '0', `reuserjsnum` int(11) NOT NULL default '0', `reuserlistnum` int(11) NOT NULL default '0', `opentitleurl` tinyint(1) NOT NULL default '0', `qaddtranimgtype` text NOT NULL, `qaddtranfile` tinyint(1) NOT NULL default '0', `qaddtranfilesize` int(11) NOT NULL default '0', `qaddtranfiletype` text NOT NULL, `sendmailtype` tinyint(1) NOT NULL default '0', `smtphost` varchar(255) NOT NULL default '', `fromemail` varchar(120) NOT NULL default '', `loginemail` tinyint(1) NOT NULL default '0', `emailusername` varchar(60) NOT NULL default '', `emailpassword` varchar(60) NOT NULL default '', `smtpport` varchar(20) NOT NULL default '', `emailname` varchar(120) NOT NULL default '', `deftempid` smallint(6) NOT NULL default '0', `feedbacktfile` tinyint(1) NOT NULL default '0', `feedbackfilesize` int(11) NOT NULL default '0', `feedbackfiletype` text NOT NULL, `searchtempvar` tinyint(1) NOT NULL default '0', `showinfolevel` smallint(6) NOT NULL default '0', `navfh` varchar(20) NOT NULL default '', `spicwidth` smallint(6) NOT NULL default '0', `spicheight` smallint(6) NOT NULL default '0', `spickill` tinyint(1) NOT NULL default '0', `jpgquality` tinyint(4) NOT NULL default '0', `markpct` tinyint(4) NOT NULL default '0', `redoview` smallint(6) NOT NULL default '0', `reggetfen` smallint(6) NOT NULL default '0', `regbooktime` smallint(6) NOT NULL default '0', `revotetime` smallint(6) NOT NULL default '0', `nreclass` text NOT NULL, `nreinfo` text NOT NULL, `nrejs` text NOT NULL, `fpath` tinyint(1) NOT NULL default '0', `filepath` varchar(30) NOT NULL default '', `openmembertranimg` tinyint(1) NOT NULL default '0', `memberimgsize` int(11) NOT NULL default '0', `memberimgtype` text NOT NULL, `openmembertranfile` tinyint(1) NOT NULL default '0', `memberfilesize` int(11) NOT NULL default '0', `memberfiletype` text NOT NULL, `nottobq` text NOT NULL, `defspacestyleid` smallint(6) NOT NULL default '0', `canposturl` text NOT NULL, `openspace` tinyint(1) NOT NULL default '0', `defadminstyle` smallint(6) NOT NULL default '0', `realltime` smallint(6) NOT NULL default '0', `closeip` text NOT NULL, `openip` text NOT NULL, `hopenip` text NOT NULL, `closewords` text NOT NULL, `closewordsf` text NOT NULL, `textpagelistnum` smallint(6) NOT NULL default '0', `memberlistlevel` smallint(6) NOT NULL default '0', `wapopen` tinyint(1) NOT NULL default '0', `wapdefstyle` smallint(6) NOT NULL default '0', `wapshowmid` varchar(255) NOT NULL default '', `waplistnum` tinyint(4) NOT NULL default '0', `wapsubtitle` tinyint(4) NOT NULL default '0', `wapshowdate` varchar(50) NOT NULL default '', `wapchar` tinyint(1) NOT NULL default '0', `ebakcanlistdb` tinyint(1) NOT NULL default '0', `paymoneytofen` int(11) NOT NULL default '0', `payminmoney` int(11) NOT NULL default '0', `keytog` tinyint(1) NOT NULL default '0', `keyrnd` varchar(60) NOT NULL default '', `keytime` int(11) NOT NULL default '0', `regkey_ok` tinyint(1) NOT NULL default '0', `opengetdown` tinyint(1) NOT NULL default '0', `gbkey_ok` tinyint(1) NOT NULL default '0', `fbkey_ok` tinyint(1) NOT NULL default '0', `newaddinfotime` smallint(6) NOT NULL default '0', `classnavline` smallint(6) NOT NULL default '0', `classnavfh` varchar(120) NOT NULL default '', `adminstyle` text NOT NULL, `sitekey` varchar(255) NOT NULL default '', `siteintro` text NOT NULL, `docnewsnum` int(11) NOT NULL default '0', `openschall` tinyint(1) NOT NULL default '0', `schallfield` tinyint(1) NOT NULL default '0', `schallminlen` tinyint(4) NOT NULL default '0', `schallmaxlen` tinyint(4) NOT NULL default '0', `schallnotcid` text NOT NULL, `schallnum` smallint(6) NOT NULL default '0', `schallpagenum` smallint(6) NOT NULL default '0', `dtcanbq` tinyint(1) NOT NULL default '0', `dtcachetime` int(11) NOT NULL default '0', `regretime` smallint(6) NOT NULL default '0', `regclosewords` text NOT NULL, `regemailonly` tinyint(1) NOT NULL default '0', `repkeynum` smallint(6) NOT NULL default '0', `getpasstime` int(11) NOT NULL default '0', `acttime` int(11) NOT NULL default '0', `regacttype` tinyint(1) NOT NULL default '0', `acttext` text NOT NULL, `getpasstext` text NOT NULL, `acttitle` varchar(120) NOT NULL default '', `getpasstitle` varchar(120) NOT NULL default '', `opengetpass` tinyint(1) NOT NULL default '0', `hlistinfonum` int(11) NOT NULL default '0', `qlistinfonum` int(11) NOT NULL default '0', `dtncanbq` tinyint(1) NOT NULL default '0', `dtncachetime` int(11) NOT NULL default '0', `readdinfotime` smallint(6) NOT NULL default '0', `qeditinfotime` int(11) NOT NULL default '0', `ftpssl` tinyint(1) NOT NULL default '0', `ftppasv` tinyint(1) NOT NULL default '0', `ftpouttime` smallint(6) NOT NULL default '0', `onclicktype` tinyint(1) NOT NULL default '0', `onclickfilesize` int(11) NOT NULL default '0', `onclickfiletime` int(11) NOT NULL default '0', `schalltime` smallint(6) NOT NULL default '0', `defprinttempid` smallint(6) NOT NULL default '0', `opentags` tinyint(1) NOT NULL default '0', `tagstempid` smallint(6) NOT NULL default '0', `usetags` text NOT NULL, `chtags` text NOT NULL, `tagslistnum` smallint(6) NOT NULL default '0', `closeqdt` tinyint(1) NOT NULL default '0', `settop` tinyint(1) NOT NULL default '0', `qlistinfomod` tinyint(1) NOT NULL default '0', `gb_num` tinyint(4) NOT NULL default '0', `member_num` tinyint(4) NOT NULL default '0', `space_num` tinyint(4) NOT NULL default '0', `opendoip` text NOT NULL, `closedoip` text NOT NULL, `doiptype` varchar(255) NOT NULL default '', `filelday` int(11) NOT NULL default '0', `infolday` int(11) NOT NULL default '0', `baktempnum` tinyint(4) NOT NULL default '0', `dorepkey` tinyint(1) NOT NULL default '0', `dorepword` tinyint(1) NOT NULL default '0', `onclickrnd` varchar(20) NOT NULL default '', `indexpagedt` tinyint(1) NOT NULL default '0', `keybgcolor` varchar(8) NOT NULL default '', `keyfontcolor` varchar(8) NOT NULL default '', `keydistcolor` varchar(8) NOT NULL default '', `indexpageid` smallint(6) NOT NULL default '0', `closeqdtmsg` varchar(255) NOT NULL default '', `openfileserver` tinyint(1) NOT NULL default '0', `closemods` varchar(255) NOT NULL default '', `fieldandtop` tinyint(1) NOT NULL default '0', `fieldandclosetb` text NOT NULL, `filedatatbs` text NOT NULL, `filedeftb` smallint(5) unsigned NOT NULL default '0', `closelisttemp` varchar(255) NOT NULL default '', `chclasscolor` varchar(8) NOT NULL default '', `timeclose` varchar(255) NOT NULL default '', `timeclosedo` varchar(255) NOT NULL default '', `ipaddinfonum` int(10) unsigned NOT NULL default '0', `ipaddinfotime` smallint(5) unsigned NOT NULL default '0', `rewriteinfo` varchar(120) NOT NULL default '', `rewriteclass` varchar(120) NOT NULL default '', `rewriteinfotype` varchar(120) NOT NULL default '', `rewritetags` varchar(120) NOT NULL default '', `closehmenu` varchar(80) NOT NULL default '', `indexaddpage` tinyint(1) NOT NULL default '0', `rewritepl` varchar(150) NOT NULL default '', `modmemberedittran` tinyint(1) NOT NULL default '0', `modinfoedittran` tinyint(1) NOT NULL default '0', `php_adminouttime` int(11) NOT NULL default '0', `httptype` tinyint(1) NOT NULL default '0', `qinfoaddfen` tinyint(1) NOT NULL default '0', `bakescapetype` tinyint(1) NOT NULL default '0', `hkeytime` int(11) NOT NULL default '0', `hkeyrnd` varchar(60) NOT NULL default '', `mhavedatedo` tinyint(1) NOT NULL default '0', `reportkey` tinyint(1) NOT NULL default '0', `wapchstyle` tinyint(1) NOT NULL default '0', `usetotalnum` tinyint(1) NOT NULL default '0', `spacegids` varchar(255) NOT NULL default '', `candocodetag` tinyint(1) NOT NULL default '0', `openern` varchar(255) NOT NULL default '', `ernurl` varchar(200) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM; INSERT INTO `phome_enewspublic` VALUES (1, '/ecms75/', '帝国网站管理系统', 'admin@phome.net', '|.gif|.jpg|.swf|.rar|.zip|.mp3|.wmv|.txt|.doc|', 2048, 10, 10, 8, 100, 2, 20, 20, 10, 0, 0, 30, 5, 60, 0, 0, '.html', 0, '', 10, '.html', 40, 160, 1, '/ecms75/d/file/', 0, '', '21', '', '', '', 0, 0, 10, '7.2,1421510410', 1222406370, 300, 50, 10, 'bdata', 'zip', 'BEA0edeiQmotdkzjcA38', 3, 20, 6, 20, 1, 1, 'news', 0, 0, 1, 1, 0, 50, 100, 100, 1, 50, 1, 300, 5, '../data/mark/maskdef.gif', '', '5', '', '../data/mark/cour.ttf', 1, 0, 'sys_ShowListPage', 'sys_ShowTextPage', 'thea', '', 1, 50, 300, ',article.newstext,', 300, 'sys_ShowListMorePage', 10, 100, 0, 0, 100, 8, 1, '|.gif|.jpg|', 1, 500, '|.zip|.rar|', 1, 'smtp.163.com', 'ecms@163.com', 1, 'ecms', 'ecms', '25', '帝国CMS', 0, 1, 500, '|.zip|.rar|', 1, 0, '>', 105, 118, 1, 80, 65, 24, 0, 30, 30, ',', ',', ',', 1, 'Y/m-d', 1, 50, '|.gif|.jpg|', 1, 500, '|.zip|.rar|', ',', 1, '', 0, 1, 0, '', '', '', '', '', 6, 0, 1, 1, '', 10, 30, 'm-d', 2, 0, 10, 1, 2, '0ZR0hHW2Pgn0O49QoTh5FzinsUv9DdvGeT7cYoq0Js', 30, 0, 0, 0, 0, 0, 20, ' | ', ',1,2,', '帝国网站管理系统,EmpireCMS', '　　帝国软件是一家专注于网络软件开发的科技公司，其主营产品“帝国网站管理系统(EmpireCMS)”是目前国内应用超高广泛的CMS程序。通过十多年的不断创新与完善，使系统集安全、稳定、强大、灵活于一身。目前EmpireCMS程序已经广泛应用在国内上百万家网站，覆盖国内数千万上网人群，并经过上千家知名网站的严格检测，被称为国内超高安全、超高稳定的开源CMS系统。', 300, 0, 1, 3, 20, ',,', 20, 10, 1, 43200, 0, '', 1, 0, 72, 720, 0, '[!--username--] ，\r\n这封信是由 [!--sitename--] 发送的。\r\n\r\n您收到这封邮件，是因为在我们网站的新用户注册 Email 使用\r\n了您的地址。如果您并没有访问过我们的网站，或没有进行上述操作，请忽\r\n略这封邮件。您不需要退订或进行其他进一步的操作。\r\n\r\n----------------------------------------------------------------------\r\n帐号激活说明\r\n----------------------------------------------------------------------\r\n\r\n您是我们网站的新用户，注册 Email 时使用了本地址，我们需\r\n要对您的地址有效性进行验证以避免垃圾邮件或地址被滥用。\r\n\r\n您只需点击下面的链接即可激活您的帐号：\r\n\r\n[!--pageurl--]\r\n\r\n(如果上面不是链接形式，请将地址手工粘贴到浏览器地址栏再访问)\r\n\r\n感谢您的访问，祝您使用愉快！\r\n\r\n\r\n\r\n此致\r\n\r\n[!--sitename--] 管理团队.\r\n[!--news.url--]', '[!--username--] ，\r\n这封信是由 [!--sitename--] 发送的。\r\n\r\n您收到这封邮件，是因为在我们的网站上这个邮箱地址被登记为用户邮箱，\r\n且该用户请求使用 Email 密码重置功能所致。\r\n\r\n----------------------------------------------------------------------\r\n重要！\r\n----------------------------------------------------------------------\r\n\r\n如果您没有提交密码重置的请求或不是我们网站的注册用户，请立即忽略\r\n并删除这封邮件。只在您确认需要重置密码的情况下，才继续阅读下面的\r\n内容。\r\n\r\n----------------------------------------------------------------------\r\n密码重置说明\r\n----------------------------------------------------------------------\r\n\r\n您只需在提交请求后的三天之内，通过点击下面的链接重置您的密码：\r\n\r\n[!--pageurl--]\r\n\r\n(如果上面不是链接形式，请将地址手工粘贴到浏览器地址栏再访问)\r\n\r\n上面的页面打开后，输入新的密码后提交，之后您即可使用新的密码登录\r\n网站了。您可以在用户控制面板中随时修改您的密码。\r\n\r\n\r\n\r\n此致\r\n\r\n[!--sitename--] 管理团队.\r\n[!--news.url--]', '[[!--sitename--]] Email 地址验证', '[[!--sitename--]] 取回密码说明', 0, 30, 25, 1, 43200, 60, 0, 0, 0, 0, 0, 10, 60, 0, 1, 1, 1, ',1,2,3,4,5,6,7,8,', '', 25, 0, 0, 0, 20, 20, 25, '', '', '', 0, 0, 3, 0, 0, '', 0, '', '', '', 0, '', 0, '', 0, '', ',1,', 1, '', '99C4E3', '', '', 0, 0, '', '', '', '', '', 0, '', 0, 0, 1000, 0, 0, 1, 30, 's065M0bBWmmJPPDdqYf2T4BXgKY1rOpc53C', 0, 0, 0, 0, '', 0, '', ''); UPDATE `phome_enewspublic` SET openspace=1,keytime='900',wapopen=0,memberlistlevel=2,showinfolevel=2,addnews_ok=1,closemods=',error,gb,fb,'; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewspublic_fc`; CREATE TABLE `phome_enewspublic_fc` ( `id` tinyint(3) unsigned NOT NULL auto_increment, `fclastindex` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM; INSERT INTO `phome_enewspublic_fc` VALUES (1, 0); # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewspublic_up`; CREATE TABLE `phome_enewspublic_up` ( `id` tinyint(3) unsigned NOT NULL auto_increment, `lasttimeinfo` int(10) unsigned NOT NULL default '0', `lasttimepl` int(10) unsigned NOT NULL default '0', `lastnuminfo` int(10) unsigned NOT NULL default '0', `lastnumpl` int(10) unsigned NOT NULL default '0', `lastnuminfotb` text NOT NULL, `lastnumpltb` text NOT NULL, `todaytimeinfo` int(10) unsigned NOT NULL default '0', `todaytimepl` int(10) unsigned NOT NULL default '0', `todaynuminfo` int(10) unsigned NOT NULL default '0', `yesterdaynuminfo` int(10) unsigned NOT NULL default '0', `todaynumpl` int(10) unsigned NOT NULL default '0', `yesterdaynumpl` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM; INSERT INTO `phome_enewspublic_up` VALUES (1, 1355124469, 1355124476, 0, 0, '', '', 1408520771, 1408520771, 0, 0, 0, 0); # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewspublicadd`; CREATE TABLE `phome_enewspublicadd` ( `id` tinyint(3) unsigned NOT NULL auto_increment, `ctimeopen` tinyint(1) NOT NULL default '0', `ctimelast` int(10) unsigned NOT NULL default '0', `ctimeindex` int(11) NOT NULL default '0', `ctimeclass` int(11) NOT NULL default '0', `ctimelist` int(11) NOT NULL default '0', `ctimetext` int(11) NOT NULL default '0', `ctimett` int(11) NOT NULL default '0', `ctimetags` int(11) NOT NULL default '0', `ctimegids` varchar(255) NOT NULL default '', `ctimecids` varchar(255) NOT NULL default '', `ctimernd` varchar(60) NOT NULL default '', `ctimeaddre` tinyint(4) NOT NULL default '0', `ctimeqaddre` tinyint(4) NOT NULL default '0', `autodoopen` tinyint(1) NOT NULL default '0', `autodouser` varchar(30) NOT NULL default '', `autodopass` varchar(32) NOT NULL default '', `autodosalt` varchar(20) NOT NULL default '', `autodoshowkey` tinyint(1) NOT NULL default '0', `autodotime` int(11) NOT NULL default '0', `autodoline` int(11) NOT NULL default '0', `autodovar` varchar(20) NOT NULL default '', `autodoval` varchar(60) NOT NULL default '', `autodoshow` tinyint(1) NOT NULL default '0', `autodofile` tinyint(1) NOT NULL default '0', `autodopostpass` varchar(120) NOT NULL default '', `autodoss` tinyint(1) NOT NULL default '0', `autodoaction` varchar(200) NOT NULL default '', `autodock` tinyint(1) NOT NULL default '0', `digglevel` int(11) NOT NULL default '0', `diggcmids` varchar(255) NOT NULL default '', `toqjf` text NOT NULL, `qtoqjf` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM; INSERT INTO `phome_enewspublicadd` VALUES (1, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 'pLnmZpF4fqbKQmhv82WQAekQAyktoARuFccZjnLb21', 0, 0, 0, '', '', '', 0, 100, 12, '', '', 1, 0, 'EmpireCMS', 0, ',emp,', 0, 0, '', '', ''); # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewspubvar`; CREATE TABLE `phome_enewspubvar` ( `varid` smallint(5) unsigned NOT NULL auto_increment, `myvar` varchar(60) NOT NULL default '', `varname` varchar(20) NOT NULL default '', `varvalue` text NOT NULL, `varsay` varchar(255) NOT NULL default '', `myorder` smallint(5) unsigned NOT NULL default '0', `classid` smallint(5) unsigned NOT NULL default '0', `tocache` tinyint(1) NOT NULL default '0', PRIMARY KEY (`varid`), UNIQUE KEY `varname` (`varname`), KEY `classid` (`classid`), KEY `tocache` (`tocache`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewspubvarclass`; CREATE TABLE `phome_enewspubvarclass` ( `classid` smallint(5) unsigned NOT NULL auto_increment, `classname` varchar(30) NOT NULL default '', `classsay` varchar(255) NOT NULL default '', PRIMARY KEY (`classid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsqmsg`; CREATE TABLE `phome_enewsqmsg` ( `mid` int(10) unsigned NOT NULL auto_increment, `title` varchar(80) NOT NULL default '', `msgtext` text NOT NULL, `haveread` tinyint(1) NOT NULL default '0', `msgtime` datetime NOT NULL default '0000-00-00 00:00:00', `to_username` varchar(30) NOT NULL default '', `from_userid` int(10) unsigned NOT NULL default '0', `from_username` varchar(30) NOT NULL default '', `isadmin` tinyint(1) NOT NULL default '0', `issys` tinyint(1) NOT NULL default '0', PRIMARY KEY (`mid`), KEY `to_username` (`to_username`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewssearch`; CREATE TABLE `phome_enewssearch` ( `searchid` bigint(20) unsigned NOT NULL auto_increment, `keyboard` varchar(255) NOT NULL default '', `searchtime` int(10) unsigned NOT NULL default '0', `searchclass` varchar(255) NOT NULL default '', `result_num` int(10) unsigned NOT NULL default '0', `searchip` varchar(20) NOT NULL default '', `classid` varchar(255) NOT NULL default '', `onclick` int(10) unsigned NOT NULL default '0', `orderby` varchar(30) NOT NULL default '0', `myorder` tinyint(1) NOT NULL default '0', `checkpass` varchar(32) NOT NULL default '', `tbname` varchar(60) NOT NULL default '', `tempid` smallint(5) unsigned NOT NULL default '0', `iskey` tinyint(1) NOT NULL default '0', `andsql` text NOT NULL, `trueclassid` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`searchid`), KEY `checkpass` (`checkpass`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewssearchall`; CREATE TABLE `phome_enewssearchall` ( `sid` int(10) unsigned NOT NULL auto_increment, `id` int(10) unsigned NOT NULL default '0', `classid` smallint(5) unsigned NOT NULL default '0', `title` text NOT NULL, `infotime` int(10) unsigned NOT NULL default '0', `infotext` mediumtext NOT NULL, PRIMARY KEY (`sid`), KEY `id` (`id`,`classid`,`infotime`), FULLTEXT KEY `title` (`title`,`infotext`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewssearchall_load`; CREATE TABLE `phome_enewssearchall_load` ( `lid` smallint(5) unsigned NOT NULL auto_increment, `tbname` varchar(60) NOT NULL default '', `titlefield` varchar(30) NOT NULL default '', `infotextfield` varchar(30) NOT NULL default '', `smalltextfield` varchar(30) NOT NULL default '', `loadnum` smallint(5) unsigned NOT NULL default '0', `lasttime` int(10) unsigned NOT NULL default '0', `lastid` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`lid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsshop_address`; CREATE TABLE `phome_enewsshop_address` ( `addressid` int(10) unsigned NOT NULL auto_increment, `addressname` char(50) NOT NULL default '', `userid` mediumint(8) unsigned NOT NULL default '0', `truename` char(20) NOT NULL default '', `oicq` char(20) NOT NULL default '', `msn` char(60) NOT NULL default '', `email` char(60) NOT NULL default '', `address` char(255) NOT NULL default '', `zip` char(8) NOT NULL default '', `mycall` char(30) NOT NULL default '', `phone` char(30) NOT NULL default '', `signbuild` char(100) NOT NULL default '', `besttime` char(120) NOT NULL default '', `isdefault` tinyint(1) NOT NULL default '0', PRIMARY KEY (`addressid`), KEY `userid` (`userid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsshop_ddlog`; CREATE TABLE `phome_enewsshop_ddlog` ( `logid` int(10) unsigned NOT NULL auto_increment, `ddid` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `username` varchar(30) NOT NULL default '', `ecms` varchar(30) NOT NULL default '', `bz` varchar(255) NOT NULL default '', `addbz` varchar(255) NOT NULL default '', `logtime` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`logid`), KEY `ddid` (`ddid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsshop_precode`; CREATE TABLE `phome_enewsshop_precode` ( `id` int(10) unsigned NOT NULL auto_increment, `prename` varchar(30) NOT NULL default '', `precode` varchar(36) NOT NULL default '', `premoney` int(10) unsigned NOT NULL default '0', `pretype` tinyint(1) NOT NULL default '0', `reuse` tinyint(1) NOT NULL default '0', `addtime` int(10) unsigned NOT NULL default '0', `endtime` int(10) unsigned NOT NULL default '0', `groupid` varchar(255) NOT NULL default '', `classid` text NOT NULL, `musttotal` int(10) unsigned NOT NULL default '0', `usenum` int(11) NOT NULL default '0', `haveusenum` int(11) NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `precode` (`precode`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsshop_set`; CREATE TABLE `phome_enewsshop_set` ( `id` tinyint(3) unsigned NOT NULL auto_increment, `shopddgroupid` smallint(5) unsigned NOT NULL default '0', `buycarnum` smallint(5) unsigned NOT NULL default '0', `havefp` tinyint(1) NOT NULL default '0', `fpnum` smallint(5) unsigned NOT NULL default '0', `fpname` text NOT NULL, `ddmust` text NOT NULL, `haveatt` tinyint(1) NOT NULL default '0', `shoptbs` varchar(255) NOT NULL default '', `buystep` tinyint(3) unsigned NOT NULL default '0', `shoppsmust` tinyint(1) NOT NULL default '0', `shoppayfsmust` tinyint(1) NOT NULL default '0', `dddeltime` smallint(5) unsigned NOT NULL default '0', `cutnumtype` tinyint(1) NOT NULL default '0', `cutnumtime` int(10) unsigned NOT NULL default '0', `freepstotal` int(10) unsigned NOT NULL default '0', `singlenum` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM; INSERT INTO `phome_enewsshop_set` VALUES (1, 0, 0, 0, 10, '商品名称\r\n办公用品\r\n日用品', ',truename,mycall,address,', 0, ',shop,', 0, 1, 1, 0, 0, 120, 0, 0); # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsshopdd`; CREATE TABLE `phome_enewsshopdd` ( `ddid` int(10) unsigned NOT NULL auto_increment, `ddno` varchar(30) NOT NULL default '', `ddtime` datetime NOT NULL default '0000-00-00 00:00:00', `userid` mediumint(8) unsigned NOT NULL default '0', `username` varchar(30) NOT NULL default '', `outproduct` tinyint(1) NOT NULL default '0', `haveprice` tinyint(1) NOT NULL default '0', `checked` tinyint(1) NOT NULL default '0', `truename` varchar(20) NOT NULL default '', `oicq` varchar(25) NOT NULL default '', `msn` varchar(120) NOT NULL default '', `email` varchar(120) NOT NULL default '', `mycall` varchar(30) NOT NULL default '', `phone` varchar(30) NOT NULL default '', `address` varchar(255) NOT NULL default '', `zip` varchar(8) NOT NULL default '', `psid` smallint(6) NOT NULL default '0', `psname` varchar(60) NOT NULL default '', `pstotal` float(11,2) NOT NULL default '0.00', `alltotal` float(11,2) NOT NULL default '0.00', `payfsid` smallint(6) NOT NULL default '0', `payfsname` varchar(60) NOT NULL default '', `payby` tinyint(4) NOT NULL default '0', `alltotalfen` float(11,2) NOT NULL default '0.00', `fp` tinyint(1) NOT NULL default '0', `fptt` varchar(255) NOT NULL default '', `fptotal` float(11,2) NOT NULL default '0.00', `fpname` varchar(50) NOT NULL default '', `userip` varchar(20) NOT NULL default '', `signbuild` varchar(100) NOT NULL default '', `besttime` varchar(120) NOT NULL default '', `pretotal` float(11,2) NOT NULL default '0.00', `ddtruetime` int(10) unsigned NOT NULL default '0', `havecutnum` tinyint(1) NOT NULL default '0', PRIMARY KEY (`ddid`), KEY `ddno` (`ddno`), KEY `userid` (`userid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsshopdd_add`; CREATE TABLE `phome_enewsshopdd_add` ( `ddid` int(10) unsigned NOT NULL default '0', `buycar` mediumtext NOT NULL, `bz` text NOT NULL, `retext` text NOT NULL, PRIMARY KEY (`ddid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsshoppayfs`; CREATE TABLE `phome_enewsshoppayfs` ( `payid` smallint(5) unsigned NOT NULL auto_increment, `payname` varchar(60) NOT NULL default '', `payurl` varchar(255) NOT NULL default '', `paysay` text NOT NULL, `userpay` tinyint(1) NOT NULL default '0', `userfen` tinyint(1) NOT NULL default '0', `isclose` tinyint(1) NOT NULL default '0', `isdefault` tinyint(1) NOT NULL default '0', PRIMARY KEY (`payid`) ) TYPE=MyISAM; INSERT INTO `phome_enewsshoppayfs` VALUES (1, '邮政汇款', '', '邮政汇款地址:******', 0, 0, 0, 0); INSERT INTO `phome_enewsshoppayfs` VALUES (2, '银行转帐', '', '银行转帐帐号:******', 0, 0, 0, 0); INSERT INTO `phome_enewsshoppayfs` VALUES (3, '网银支付', '/ecms75/e/payapi/ShopPay.php?paytype=alipay', '

网银支付

', 0, 0, 0, 1); INSERT INTO `phome_enewsshoppayfs` VALUES (4, '预付款支付', '', '预付款支付', 1, 0, 0, 0); INSERT INTO `phome_enewsshoppayfs` VALUES (5, '货到付款(或上门收款)', '', '货到付款(或上门收款)说明', 0, 0, 0, 0); INSERT INTO `phome_enewsshoppayfs` VALUES (6, '点数购买', '', '点数购买', 0, 1, 0, 0); # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsshopps`; CREATE TABLE `phome_enewsshopps` ( `pid` smallint(5) unsigned NOT NULL auto_increment, `pname` varchar(60) NOT NULL default '', `price` float(11,2) NOT NULL default '0.00', `otherprice` text NOT NULL, `psay` text NOT NULL, `isclose` tinyint(1) NOT NULL default '0', `isdefault` tinyint(1) NOT NULL default '0', PRIMARY KEY (`pid`) ) TYPE=MyISAM; INSERT INTO `phome_enewsshopps` VALUES (1, '送货上门', '10.00', '', '送货上门', 0, 0); INSERT INTO `phome_enewsshopps` VALUES (2, '特快专递（EMS）', '25.00', '', '特快专递（EMS）', 0, 0); INSERT INTO `phome_enewsshopps` VALUES (3, '普通邮递', '5.00', '', '普通邮递', 0, 1); INSERT INTO `phome_enewsshopps` VALUES (4, '邮局快邮', '12.00', '', '邮局快邮', 0, 0); # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewssp`; CREATE TABLE `phome_enewssp` ( `spid` int(10) unsigned NOT NULL auto_increment, `spname` varchar(30) NOT NULL default '', `varname` varchar(30) NOT NULL default '', `sppic` varchar(255) NOT NULL default '', `spsay` varchar(255) NOT NULL default '', `sptype` tinyint(1) NOT NULL default '0', `cid` smallint(5) unsigned NOT NULL default '0', `classid` smallint(5) unsigned NOT NULL default '0', `tempid` smallint(5) unsigned NOT NULL default '0', `maxnum` int(11) NOT NULL default '0', `sptime` int(10) unsigned NOT NULL default '0', `groupid` text NOT NULL, `userclass` text NOT NULL, `username` text NOT NULL, `isclose` tinyint(1) NOT NULL default '0', `cladd` tinyint(1) NOT NULL default '0', `refile` tinyint(1) NOT NULL default '0', `spfile` varchar(255) NOT NULL default '', `spfileline` smallint(6) NOT NULL default '0', `spfilesub` smallint(6) NOT NULL default '0', PRIMARY KEY (`spid`), UNIQUE KEY `varname` (`varname`), KEY `refile` (`refile`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewssp_1`; CREATE TABLE `phome_enewssp_1` ( `sid` int(10) unsigned NOT NULL auto_increment, `spid` int(10) unsigned NOT NULL default '0', `title` varchar(200) NOT NULL default '', `titlepic` varchar(200) NOT NULL default '', `bigpic` varchar(200) NOT NULL default '', `titleurl` varchar(200) NOT NULL default '', `smalltext` varchar(255) NOT NULL default '', `titlefont` varchar(20) NOT NULL default '', `newstime` int(10) unsigned NOT NULL default '0', `titlepre` varchar(30) NOT NULL default '', `titlenext` varchar(30) NOT NULL default '', PRIMARY KEY (`sid`), KEY `spid` (`spid`), KEY `newstime` (`newstime`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewssp_2`; CREATE TABLE `phome_enewssp_2` ( `sid` int(10) unsigned NOT NULL auto_increment, `spid` int(10) unsigned NOT NULL default '0', `classid` smallint(5) unsigned NOT NULL default '0', `id` int(10) unsigned NOT NULL default '0', `newstime` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`sid`), KEY `spid` (`spid`), KEY `newstime` (`newstime`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewssp_3`; CREATE TABLE `phome_enewssp_3` ( `sid` int(10) unsigned NOT NULL auto_increment, `spid` int(10) unsigned NOT NULL default '0', `sptext` mediumtext NOT NULL, PRIMARY KEY (`sid`), UNIQUE KEY `spid` (`spid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewssp_3_bak`; CREATE TABLE `phome_enewssp_3_bak` ( `bid` int(10) unsigned NOT NULL auto_increment, `sid` int(10) unsigned NOT NULL default '0', `spid` int(10) unsigned NOT NULL default '0', `sptext` mediumtext NOT NULL, `lastuser` varchar(30) NOT NULL default '', `lasttime` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`bid`), KEY `sid` (`sid`), KEY `spid` (`spid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsspacestyle`; CREATE TABLE `phome_enewsspacestyle` ( `styleid` smallint(5) unsigned NOT NULL auto_increment, `stylename` varchar(30) NOT NULL default '', `stylepic` varchar(255) NOT NULL default '', `stylesay` varchar(255) NOT NULL default '', `stylepath` varchar(30) NOT NULL default '0', `isdefault` tinyint(1) NOT NULL default '0', `membergroup` varchar(255) NOT NULL default '', PRIMARY KEY (`styleid`) ) TYPE=MyISAM; INSERT INTO `phome_enewsspacestyle` VALUES (1, '默认个人空间模板', '', '默认个人空间模板', 'default', 1, ',1,2,'); INSERT INTO `phome_enewsspacestyle` VALUES (2, '默认企业空间模板', '', '默认企业空间模板', 'comdefault', 0, ',3,4,'); # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsspclass`; CREATE TABLE `phome_enewsspclass` ( `classid` smallint(5) unsigned NOT NULL auto_increment, `classname` varchar(30) NOT NULL default '', `classsay` varchar(255) NOT NULL default '', PRIMARY KEY (`classid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewssql`; CREATE TABLE `phome_enewssql` ( `id` smallint(5) unsigned NOT NULL auto_increment, `sqlname` varchar(60) NOT NULL default '', `sqltext` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewstable`; CREATE TABLE `phome_enewstable` ( `tid` smallint(5) unsigned NOT NULL auto_increment, `tbname` varchar(60) NOT NULL default '', `tname` varchar(60) NOT NULL default '', `tsay` text NOT NULL, `isdefault` tinyint(1) NOT NULL default '0', `datatbs` text NOT NULL, `deftb` varchar(6) NOT NULL default '', `yhid` smallint(5) unsigned NOT NULL default '0', `mid` smallint(5) unsigned NOT NULL default '0', `intb` tinyint(1) NOT NULL default '0', PRIMARY KEY (`tid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewstags`; CREATE TABLE `phome_enewstags` ( `tagid` int(10) unsigned NOT NULL auto_increment, `tagname` char(20) NOT NULL default '', `num` int(10) unsigned NOT NULL default '0', `isgood` tinyint(1) NOT NULL default '0', `cid` smallint(5) unsigned NOT NULL default '0', `tagtitle` char(60) NOT NULL default '', `tagkey` char(100) NOT NULL default '', `tagdes` char(255) NOT NULL default '', `fclast` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`tagid`), UNIQUE KEY `tagname` (`tagname`), KEY `isgood` (`isgood`), KEY `cid` (`cid`), KEY `num` (`num`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewstagsclass`; CREATE TABLE `phome_enewstagsclass` ( `classid` smallint(5) unsigned NOT NULL auto_increment, `classname` varchar(60) NOT NULL default '', PRIMARY KEY (`classid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewstagsdata`; CREATE TABLE `phome_enewstagsdata` ( `tid` int(10) unsigned NOT NULL auto_increment, `tagid` int(10) unsigned NOT NULL default '0', `classid` smallint(5) unsigned NOT NULL default '0', `id` int(10) unsigned NOT NULL default '0', `newstime` int(10) unsigned NOT NULL default '0', `mid` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`tid`), KEY `tagid` (`tagid`), KEY `classid` (`classid`), KEY `id` (`id`), KEY `newstime` (`newstime`), KEY `mid` (`mid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewstask`; CREATE TABLE `phome_enewstask` ( `id` smallint(5) unsigned NOT NULL auto_increment, `taskname` varchar(60) NOT NULL default '', `userid` int(10) unsigned NOT NULL default '0', `isopen` tinyint(1) NOT NULL default '0', `filename` varchar(60) NOT NULL default '', `lastdo` int(10) unsigned NOT NULL default '0', `doweek` char(1) NOT NULL default '0', `doday` char(2) NOT NULL default '0', `dohour` char(2) NOT NULL default '0', `dominute` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewstogzts`; CREATE TABLE `phome_enewstogzts` ( `togid` int(10) unsigned NOT NULL auto_increment, `keyboard` varchar(255) NOT NULL default '', `searchf` varchar(255) NOT NULL default '', `query` text NOT NULL, `specialsearch` varchar(255) NOT NULL default '', `classid` smallint(5) unsigned NOT NULL default '0', `retype` tinyint(1) NOT NULL default '0', `startday` varchar(20) NOT NULL default '', `endday` varchar(20) NOT NULL default '', `startid` int(10) unsigned NOT NULL default '0', `endid` int(10) unsigned NOT NULL default '0', `pline` int(11) NOT NULL default '0', `doecmszt` tinyint(1) NOT NULL default '0', `togztname` varchar(30) NOT NULL default '', PRIMARY KEY (`togid`), KEY `togztname` (`togztname`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsuser`; CREATE TABLE `phome_enewsuser` ( `userid` int(10) unsigned NOT NULL auto_increment, `username` varchar(30) NOT NULL default '', `password` varchar(32) NOT NULL default '', `rnd` varchar(20) NOT NULL default '', `adminclass` mediumtext NOT NULL, `groupid` smallint(5) unsigned NOT NULL default '0', `checked` tinyint(1) NOT NULL default '0', `styleid` smallint(5) unsigned NOT NULL default '0', `filelevel` tinyint(1) NOT NULL default '0', `salt` varchar(8) NOT NULL default '', `loginnum` int(10) unsigned NOT NULL default '0', `lasttime` int(10) unsigned NOT NULL default '0', `lastip` varchar(20) NOT NULL default '', `truename` varchar(20) NOT NULL default '', `email` varchar(120) NOT NULL default '', `classid` smallint(5) unsigned NOT NULL default '0', `pretime` int(10) unsigned NOT NULL default '0', `preip` varchar(20) NOT NULL default '', `addtime` int(10) unsigned NOT NULL default '0', `addip` varchar(20) NOT NULL default '', `userprikey` varchar(50) NOT NULL default '', `salt2` varchar(20) NOT NULL default '', `lastipport` varchar(6) NOT NULL default '', `preipport` varchar(6) NOT NULL default '', `addipport` varchar(6) NOT NULL default '', `uprnd` varchar(32) NOT NULL default '', `wname` varchar(60) NOT NULL default '', `tel` varchar(20) NOT NULL default '', `wxno` varchar(80) NOT NULL default '', `qq` varchar(20) NOT NULL default '', PRIMARY KEY (`userid`), UNIQUE KEY `username` (`username`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsuseradd`; CREATE TABLE `phome_enewsuseradd` ( `userid` int(10) unsigned NOT NULL auto_increment, `equestion` tinyint(4) NOT NULL default '0', `eanswer` varchar(32) NOT NULL default '', `openip` text NOT NULL, `certkey` varchar(60) NOT NULL default '', `certtime` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`userid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsuserclass`; CREATE TABLE `phome_enewsuserclass` ( `classid` smallint(5) unsigned NOT NULL auto_increment, `classname` varchar(30) NOT NULL default '', PRIMARY KEY (`classid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsuserjs`; CREATE TABLE `phome_enewsuserjs` ( `jsid` smallint(5) unsigned NOT NULL auto_increment, `jsname` varchar(60) NOT NULL default '', `jssql` text NOT NULL, `jstempid` smallint(5) unsigned NOT NULL default '0', `jsfilename` varchar(120) NOT NULL default '', `classid` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`jsid`), KEY `classid` (`classid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsuserjsclass`; CREATE TABLE `phome_enewsuserjsclass` ( `classid` smallint(5) unsigned NOT NULL auto_increment, `classname` varchar(30) NOT NULL default '', PRIMARY KEY (`classid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsuserlist`; CREATE TABLE `phome_enewsuserlist` ( `listid` smallint(5) unsigned NOT NULL auto_increment, `listname` varchar(60) NOT NULL default '', `pagetitle` varchar(120) NOT NULL default '', `filepath` varchar(120) NOT NULL default '', `filetype` varchar(12) NOT NULL default '', `totalsql` text NOT NULL, `listsql` text NOT NULL, `maxnum` int(11) NOT NULL default '0', `lencord` int(11) NOT NULL default '0', `listtempid` smallint(5) unsigned NOT NULL default '0', `pagekeywords` varchar(255) NOT NULL default '', `pagedescription` varchar(255) NOT NULL default '', `classid` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`listid`), KEY `classid` (`classid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsuserlistclass`; CREATE TABLE `phome_enewsuserlistclass` ( `classid` smallint(5) unsigned NOT NULL auto_increment, `classname` varchar(30) NOT NULL default '', PRIMARY KEY (`classid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsuserloginck`; CREATE TABLE `phome_enewsuserloginck` ( `userid` int(10) unsigned NOT NULL auto_increment, `andauth` varchar(32) NOT NULL default '', PRIMARY KEY (`userid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsvg`; CREATE TABLE `phome_enewsvg` ( `vgid` smallint(5) unsigned NOT NULL auto_increment, `gname` char(60) NOT NULL default '', `gids` char(255) NOT NULL default '', `ingids` char(255) NOT NULL default '', `agids` char(255) NOT NULL default '', `mlist` tinyint(1) NOT NULL default '0', PRIMARY KEY (`vgid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsvglist`; CREATE TABLE `phome_enewsvglist` ( `vgid` smallint(5) unsigned NOT NULL default '0', `addtime` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `outtime` int(10) unsigned NOT NULL default '0', KEY `vgid` (`vgid`), KEY `userid` (`userid`), KEY `addtime` (`addtime`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsvote`; CREATE TABLE `phome_enewsvote` ( `voteid` int(10) unsigned NOT NULL auto_increment, `title` varchar(120) NOT NULL default '', `votenum` int(10) unsigned NOT NULL default '0', `voteip` mediumtext NOT NULL, `votetext` text NOT NULL, `voteclass` tinyint(1) NOT NULL default '0', `doip` tinyint(1) NOT NULL default '0', `votetime` int(10) unsigned NOT NULL default '0', `dotime` date NOT NULL default '0000-00-00', `width` int(11) NOT NULL default '0', `height` int(11) NOT NULL default '0', `addtime` datetime NOT NULL default '0000-00-00 00:00:00', `tempid` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`voteid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsvotemod`; CREATE TABLE `phome_enewsvotemod` ( `voteid` smallint(5) unsigned NOT NULL auto_increment, `title` varchar(120) NOT NULL default '', `votetext` text NOT NULL, `voteclass` tinyint(1) NOT NULL default '0', `doip` tinyint(1) NOT NULL default '0', `dotime` date NOT NULL default '0000-00-00', `tempid` smallint(5) unsigned NOT NULL default '0', `width` int(11) NOT NULL default '0', `height` int(11) NOT NULL default '0', `votenum` int(10) unsigned NOT NULL default '0', `ysvotename` varchar(60) NOT NULL default '', PRIMARY KEY (`voteid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewswapstyle`; CREATE TABLE `phome_enewswapstyle` ( `styleid` smallint(5) unsigned NOT NULL auto_increment, `stylename` varchar(60) NOT NULL default '', `path` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`styleid`) ) TYPE=MyISAM; INSERT INTO `phome_enewswapstyle` VALUES (1, '新闻模板', 1); INSERT INTO `phome_enewswapstyle` VALUES (2, '分类信息模板', 2); # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewswfinfo`; CREATE TABLE `phome_enewswfinfo` ( `id` int(10) unsigned NOT NULL default '0', `classid` smallint(5) unsigned NOT NULL default '0', `wfid` smallint(5) unsigned NOT NULL default '0', `tid` int(10) unsigned NOT NULL default '0', `groupid` text NOT NULL, `userclass` text NOT NULL, `username` text NOT NULL, `checknum` tinyint(4) NOT NULL default '0', `tstatus` varchar(30) NOT NULL default '0', `checktno` tinyint(4) NOT NULL default '0', KEY `id` (`id`,`classid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewswfinfolog`; CREATE TABLE `phome_enewswfinfolog` ( `logid` int(10) unsigned NOT NULL auto_increment, `id` int(10) unsigned NOT NULL default '0', `classid` smallint(5) unsigned NOT NULL default '0', `wfid` smallint(5) unsigned NOT NULL default '0', `tid` int(10) unsigned NOT NULL default '0', `username` varchar(30) NOT NULL default '', `checktime` int(10) unsigned NOT NULL default '0', `checktext` text NOT NULL, `checknum` tinyint(4) NOT NULL default '0', `checktype` tinyint(1) NOT NULL default '0', PRIMARY KEY (`logid`), KEY `id` (`id`,`classid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewswords`; CREATE TABLE `phome_enewswords` ( `wordid` smallint(5) unsigned NOT NULL auto_increment, `oldword` varchar(255) NOT NULL default '', `newword` varchar(255) NOT NULL default '', PRIMARY KEY (`wordid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsworkflow`; CREATE TABLE `phome_enewsworkflow` ( `wfid` smallint(5) unsigned NOT NULL auto_increment, `wfname` varchar(60) NOT NULL default '', `wftext` varchar(255) NOT NULL default '', `myorder` smallint(5) unsigned NOT NULL default '0', `addtime` int(10) unsigned NOT NULL default '0', `adduser` varchar(30) NOT NULL default '', `canedit` tinyint(1) NOT NULL default '0', PRIMARY KEY (`wfid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsworkflowitem`; CREATE TABLE `phome_enewsworkflowitem` ( `tid` int(10) unsigned NOT NULL auto_increment, `wfid` smallint(5) unsigned NOT NULL default '0', `tname` varchar(60) NOT NULL default '', `tno` int(11) NOT NULL default '0', `ttext` varchar(255) NOT NULL default '', `groupid` text NOT NULL, `userclass` text NOT NULL, `username` text NOT NULL, `lztype` tinyint(1) NOT NULL default '0', `tbdo` int(10) unsigned NOT NULL default '0', `tddo` int(10) unsigned NOT NULL default '0', `tstatus` varchar(30) NOT NULL default '', PRIMARY KEY (`tid`), KEY `wfid` (`wfid`), KEY `tno` (`tno`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewswriter`; CREATE TABLE `phome_enewswriter` ( `wid` smallint(5) unsigned NOT NULL auto_increment, `writer` varchar(30) NOT NULL default '', `email` varchar(120) NOT NULL default '', PRIMARY KEY (`wid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsyh`; CREATE TABLE `phome_enewsyh` ( `id` smallint(5) unsigned NOT NULL auto_increment, `yhname` varchar(30) NOT NULL default '', `yhtext` varchar(255) NOT NULL default '', `hlist` int(11) NOT NULL default '0', `qlist` int(11) NOT NULL default '0', `bqnew` int(11) NOT NULL default '0', `bqhot` int(11) NOT NULL default '0', `bqpl` int(11) NOT NULL default '0', `bqgood` int(11) NOT NULL default '0', `bqfirst` int(11) NOT NULL default '0', `bqdown` int(11) NOT NULL default '0', `otherlink` int(11) NOT NULL default '0', `qmlist` int(11) NOT NULL default '0', `dobq` tinyint(1) NOT NULL default '0', `dojs` tinyint(1) NOT NULL default '0', `dosbq` tinyint(1) NOT NULL default '0', `rehtml` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewszt`; CREATE TABLE `phome_enewszt` ( `ztid` smallint(5) unsigned NOT NULL auto_increment, `ztname` varchar(60) NOT NULL default '', `onclick` int(10) unsigned NOT NULL default '0', `ztnum` tinyint(3) unsigned NOT NULL default '0', `listtempid` smallint(5) unsigned NOT NULL default '0', `ztpath` varchar(255) NOT NULL default '', `zttype` varchar(10) NOT NULL default '', `zturl` varchar(200) NOT NULL default '', `classid` smallint(5) unsigned NOT NULL default '0', `islist` tinyint(1) NOT NULL default '0', `maxnum` int(11) NOT NULL default '0', `reorder` varchar(50) NOT NULL default '', `intro` text NOT NULL, `ztimg` varchar(255) NOT NULL default '', `zcid` smallint(5) unsigned NOT NULL default '0', `showzt` tinyint(1) NOT NULL default '0', `ztpagekey` varchar(255) NOT NULL default '', `classtempid` smallint(5) unsigned NOT NULL default '0', `myorder` smallint(5) unsigned NOT NULL default '0', `usezt` tinyint(1) NOT NULL default '0', `yhid` smallint(5) unsigned NOT NULL default '0', `endtime` int(10) unsigned NOT NULL default '0', `closepl` tinyint(1) NOT NULL default '0', `checkpl` tinyint(1) NOT NULL default '0', `restb` tinyint(3) unsigned NOT NULL default '0', `usernames` varchar(255) NOT NULL default '', `addtime` int(10) unsigned NOT NULL default '0', `pltempid` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`ztid`), KEY `classid` (`classid`), KEY `zcid` (`zcid`), KEY `usezt` (`usezt`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsztadd`; CREATE TABLE `phome_enewsztadd` ( `ztid` smallint(5) unsigned NOT NULL default '0', `classtext` mediumtext NOT NULL, PRIMARY KEY (`ztid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsztclass`; CREATE TABLE `phome_enewsztclass` ( `classid` smallint(5) unsigned NOT NULL auto_increment, `classname` varchar(30) NOT NULL default '', PRIMARY KEY (`classid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsztf`; CREATE TABLE `phome_enewsztf` ( `fid` smallint(5) unsigned NOT NULL auto_increment, `f` varchar(30) NOT NULL default '', `fname` varchar(30) NOT NULL default '', `fform` varchar(20) NOT NULL default '', `fhtml` mediumtext NOT NULL, `fzs` varchar(255) NOT NULL default '', `myorder` smallint(5) unsigned NOT NULL default '0', `ftype` varchar(30) NOT NULL default '', `flen` varchar(20) NOT NULL default '', `fvalue` text NOT NULL, `fformsize` varchar(12) NOT NULL default '', PRIMARY KEY (`fid`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewsztinfo`; CREATE TABLE `phome_enewsztinfo` ( `zid` int(10) unsigned NOT NULL auto_increment, `ztid` smallint(5) unsigned NOT NULL default '0', `cid` mediumint(8) unsigned NOT NULL default '0', `classid` smallint(5) unsigned NOT NULL default '0', `id` int(10) unsigned NOT NULL default '0', `newstime` int(10) unsigned NOT NULL default '0', `mid` smallint(5) unsigned NOT NULL default '0', `isgood` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`zid`), KEY `ztid` (`ztid`), KEY `cid` (`cid`), KEY `classid` (`classid`), KEY `id` (`id`), KEY `newstime` (`newstime`), KEY `mid` (`mid`), KEY `isgood` (`isgood`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewszttype`; CREATE TABLE `phome_enewszttype` ( `cid` mediumint(8) unsigned NOT NULL auto_increment, `ztid` smallint(5) unsigned NOT NULL default '0', `cname` varchar(20) NOT NULL default '', `myorder` smallint(5) unsigned NOT NULL default '0', `islist` tinyint(1) NOT NULL default '0', `listtempid` smallint(5) unsigned NOT NULL default '0', `maxnum` int(10) unsigned NOT NULL default '0', `tnum` tinyint(3) unsigned NOT NULL default '0', `reorder` varchar(50) NOT NULL default '', `ttype` varchar(10) NOT NULL default '', `endtime` int(10) unsigned NOT NULL default '0', `tfile` varchar(60) NOT NULL default '', PRIMARY KEY (`cid`), KEY `ztid` (`ztid`), KEY `myorder` (`myorder`) ) TYPE=MyISAM; # -------------------------------------------------------- DROP TABLE IF EXISTS `phome_enewszttypeadd`; CREATE TABLE `phome_enewszttypeadd` ( `cid` mediumint(8) unsigned NOT NULL default '0', `classtext` mediumtext NOT NULL, PRIMARY KEY (`cid`) ) TYPE=MyISAM;