phpcms V9 安装发生的sql语句

最新推荐文章于 2022-09-10 18:27:21 发布
最新推荐文章于 2022-09-10 18:27:21 发布
阅读量337 收藏
点赞数
分类专栏： php mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/taotaobaobei/article/details/89296100
版权
php 同时被 2 个专栏收录
118 篇文章 0 订阅
订阅专栏
mysql
25 篇文章 0 订阅
订阅专栏 
CREATE DATABASE `phpcmsv9`

Init DB	phpcmsv9

SHOW TABLES FROM `phpcmsv9`

SET NAMES 'utf8'

SET sql_mode=''

Init DB	phpcmsv9

SET FOREIGN_KEY_CHECKS=0

DROP TABLE IF EXISTS `v9_admin`

CREATE TABLE `v9_admin` ( `userid` mediumint(6) unsigned NOT NULL AUTO_INCREMENT, `username` varCHAR(20) DEFAULT NULL, `password` varCHAR(32) DEFAULT NULL, `roleid` smallint(5) DEFAULT '0', `encrypt` varCHAR(6) DEFAULT NULL, `lastloginip` varCHAR(15) DEFAULT NULL, `lastlogintime` int(10) unsigned DEFAULT '0', `email` varCHAR(40) DEFAULT NULL, `realname` varCHAR(50) NOT NULL DEFAULT '', `card` varCHAR(255) NOT NULL, `lang` VARCHAR(6) NOT NULL, PRIMARY KEY (`userid`), KEY `username` (`username`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_admin_panel`

CREATE TABLE `v9_admin_panel` ( `menuid` mediumint(8) unsigned NOT NULL, `userid` mediumint(8) unsigned NOT NULL DEFAULT '0', `name` CHAR(32) DEFAULT NULL, `url` CHAR(255) DEFAULT NULL, `datetime` int(10) unsigned DEFAULT '0', UNIQUE KEY `userid` (`menuid`,`userid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_admin_role`

CREATE TABLE `v9_admin_role` ( `roleid` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, `rolename` varCHAR(50) NOT NULL, `description` text NOT NULL, `listorder` smallint(5) unsigned NOT NULL DEFAULT '0', `disabled` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`roleid`), KEY `listorder` (`listorder`), KEY `disabled` (`disabled`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_admin_role_priv`

CREATE TABLE `v9_admin_role_priv` ( `roleid` tinyint(3) unsigned NOT NULL DEFAULT '0', `m` CHAR(20) NOT NULL, `c` CHAR(20) NOT NULL, `a` CHAR(20) NOT NULL, `data` CHAR(30) NOT NULL DEFAULT '', `siteid` smallint(5) unsigned NOT NULL DEFAULT '0', KEY `roleid` (`roleid`,`m`,`c`,`a`,`siteid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_attachment`

CREATE TABLE `v9_attachment` ( `aid` int(10) unsigned NOT NULL AUTO_INCREMENT, `module` CHAR(15) NOT NULL, `catid` smallint(5) unsigned NOT NULL DEFAULT '0', `filename` CHAR(50) NOT NULL, `filepath` CHAR(200) NOT NULL, `filesize` int(10) unsigned NOT NULL DEFAULT '0', `fileext` CHAR(10) NOT NULL, `isimage` tinyint(1) unsigned NOT NULL DEFAULT '0', `isthumb` tinyint(1) unsigned NOT NULL DEFAULT '0', `downloads` mediumint(8) unsigned NOT NULL DEFAULT '0', `userid` mediumint(8) unsigned NOT NULL DEFAULT '0', `uploadtime` int(10) unsigned NOT NULL DEFAULT '0', `uploadip` CHAR(15) NOT NULL, `status` tinyint(1) NOT NULL DEFAULT '0', `authcode` CHAR(32) NOT NULL, `siteid` smallint(5) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`aid`), KEY `authcode` (`authcode`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_attachment_index`

CREATE TABLE `v9_attachment_index` ( `keyid` CHAR(30) NOT NULL, `aid` CHAR(10) NOT NULL, KEY `keyid` (`keyid`), KEY `aid` (`aid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_badword`

CREATE TABLE `v9_badword` ( `badid` smallint(5) unsigned NOT NULL auto_increment, `badword` CHAR(20) NOT NULL, `level` tinyint(5) NOT NULL default '1', `replaceword` CHAR(20) NOT NULL default '0', `lastusetime` int(10) unsigned NOT NULL default '0', `listorder` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`badid`), UNIQUE KEY `badword` (`badword`), KEY `usetimes` (`replaceword`,`listorder`), KEY `hits` (`listorder`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_block`

CREATE TABLE `v9_block` ( `id` int(10) NOT NULL AUTO_INCREMENT, `siteid` smallint(5) unsigned DEFAULT '0', `name` CHAR(50) DEFAULT NULL, `pos` CHAR(30) DEFAULT NULL, `type` tinyint(1) DEFAULT '0', `data` text, `template` text, PRIMARY KEY (`id`), KEY `pos` (`pos`), KEY `type` (`type`), KEY `siteid` (`siteid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_block_history`

CREATE TABLE `v9_block_history` ( `id` int(10) NOT NULL AUTO_INCREMENT, `blockid` int(10) unsigned DEFAULT '0', `data` text, `creat_at` int(10) unsigned DEFAULT '0', `userid` mediumint(8) unsigned DEFAULT '0', `username` CHAR(20) DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_block_priv`

CREATE TABLE `v9_block_priv` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `roleid` tinyint(3) unsigned DEFAULT '0', `siteid` smallint(5) unsigned DEFAULT '0', `blockid` int(10) unsigned DEFAULT '0', PRIMARY KEY (`id`), KEY `blockid` (`blockid`), KEY `roleid` (`roleid`,`siteid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_cache`

CREATE TABLE `v9_cache` ( `filename` CHAR(50) NOT NULL, `path` CHAR(50) NOT NULL, `data` mediumtext NOT NULL, PRIMARY KEY (`filename`,`path`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_category`

CREATE TABLE `v9_category` ( `catid` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `siteid` smallint(5) unsigned NOT NULL DEFAULT '0', `module` varCHAR(15) NOT NULL, `type` tinyint(1) unsigned NOT NULL DEFAULT '0', `modelid` smallint(5) unsigned NOT NULL DEFAULT '0', `parentid` smallint(5) unsigned NOT NULL DEFAULT '0', `arrparentid` varCHAR(255) NOT NULL, `child` tinyint(1) unsigned NOT NULL DEFAULT '0', `arrchildid` mediumtext NOT NULL, `catname` varCHAR(30) NOT NULL, `style` varCHAR(5) NOT NULL, `image` varCHAR(100) NOT NULL, `description` mediumtext NOT NULL, `parentdir` varCHAR(100) NOT NULL, `catdir` varCHAR(30) NOT NULL, `url` varCHAR(100) NOT NULL, `items` mediumint(8) unsigned NOT NULL DEFAULT '0', `hits` int(10) unsigned NOT NULL DEFAULT '0', `setting` mediumtext NOT NULL, `listorder` smallint(5) unsigned NOT NULL DEFAULT '0', `ismenu` tinyint(1) unsigned NOT NULL DEFAULT '1', `sethtml` tinyint(1) unsigned NOT NULL DEFAULT '0', `letter` varCHAR(30) NOT NULL, `usable_type` varCHAR(255) NOT NULL, PRIMARY KEY (`catid`), KEY `module` (`module`,`parentid`,`listorder`,`catid`), KEY `siteid` (`siteid`,`type`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_category_priv`

CREATE TABLE `v9_category_priv` ( `catid` smallint(5) unsigned NOT NULL DEFAULT '0', `siteid` smallint(5) unsigned NOT NULL DEFAULT '0', `roleid` smallint(5) unsigned NOT NULL DEFAULT '0', `is_admin` tinyint(1) unsigned NOT NULL DEFAULT '0', `action` CHAR(30) NOT NULL, KEY `catid` (`catid`,`roleid`,`is_admin`,`action`), KEY `siteid` (`siteid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

190414 13:57:01	DROP TABLE IF EXISTS `v9_collection_content`

CREATE TABLE `v9_collection_content` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `nodeid` int(10) unsigned NOT NULL DEFAULT '0', `siteid` mediumint(5) unsigned NOT NULL DEFAULT '0', `status` tinyint(1) unsigned NOT NULL DEFAULT '0', `url` CHAR(255) NOT NULL, `title` CHAR(100) NOT NULL, `data` text NOT NULL, PRIMARY KEY (`id`), KEY `nodeid` (`nodeid`,`siteid`), KEY `status` (`status`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_collection_history`

CREATE TABLE `v9_collection_history` ( `md5` CHAR(32) NOT NULL, `siteid` smallint(5) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`md5`,`siteid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_collection_node`

CREATE TABLE `v9_collection_node` ( `nodeid` smallint(6) unsigned NOT NULL AUTO_INCREMENT, `name` varCHAR(20) NOT NULL, `lastdate` int(10) unsigned NOT NULL DEFAULT '0', `siteid` smallint(5) unsigned NOT NULL DEFAULT '0', `sourcecharset` varCHAR(8) NOT NULL, `sourcetype` tinyint(1) unsigned NOT NULL DEFAULT '0', `urlpage` text NOT NULL, `pagesize_start` tinyint(3) unsigned NOT NULL DEFAULT '0', `pagesize_end` mediumint(8) unsigned NOT NULL DEFAULT '0', `page_base` CHAR(255) NOT NULL, `par_num` tinyint(3) unsigned NOT NULL DEFAULT '1', `url_contain` CHAR(100) NOT NULL, `url_except` CHAR(100) NOT NULL, `url_start` CHAR(100) NOT NULL DEFAULT '', `url_end` CHAR(100) NOT NULL DEFAULT '', `title_rule` CHAR(100) NOT NULL, `title_html_rule` text NOT NULL, `author_rule` CHAR(100) NOT NULL, `author_html_rule` text NOT NULL, `comeform_rule` CHAR(100) NOT NULL, `comeform_html_rule` text NOT NULL, `time_rule` CHAR(100) NOT NULL, `time_html_rule` text NOT NULL, `content_rule` CHAR(100) NOT NULL, `content_html_rule` text NOT NULL, `content_page_start` CHAR(100) NOT NULL, `content_page_end` CHAR(100) NOT NULL, `content_page_rule` tinyint(1) unsigned NOT NULL DEFAULT '0', `content_page` tinyint(1) unsigned NOT NULL DEFAULT '0', `content_nextpage` CHAR(100) NOT NULL, `down_attachment` tinyint(1) unsigned NOT NULL DEFAULT '0', `watermark` tinyint(1) unsigned NOT NULL DEFAULT '0', `coll_order` tinyint(3) unsigned NOT NULL DEFAULT '0', `customize_config` text NOT NULL, PRIMARY KEY (`nodeid`), KEY `siteid` (`siteid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_collection_program`

CREATE TABLE `v9_collection_program` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `siteid` smallint(5) unsigned NOT NULL DEFAULT '0', `nodeid` int(10) unsigned NOT NULL DEFAULT '0', `modelid` mediumint(6) unsigned NOT NULL DEFAULT '0', `catid` int(10) unsigned NOT NULL DEFAULT '0', `config` text NOT NULL, PRIMARY KEY (`id`), KEY `siteid` (`siteid`), KEY `nodeid` (`nodeid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_content_check`

CREATE TABLE `v9_content_check` ( `checkid` CHAR(15) NOT NULL, `catid` smallint(5) unsigned NOT NULL DEFAULT '0', `siteid` smallint(5) unsigned NOT NULL DEFAULT '0', `title` CHAR(80) NOT NULL, `username` CHAR(20) NOT NULL, `inputtime` int(10) unsigned NOT NULL DEFAULT '0', `status` tinyint(1) unsigned NOT NULL DEFAULT '0', KEY `username` (`username`), KEY `checkid` (`checkid`), KEY `status` (`status`,`inputtime`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_datacall`

CREATE TABLE `v9_datacall` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` CHAR(40) DEFAULT NULL, `dis_type` tinyint(1) unsigned DEFAULT '0', `type` tinyint(1) DEFAULT '0', `module` CHAR(20) DEFAULT NULL, `action` CHAR(20) DEFAULT NULL, `data` text, `template` text, `cache` mediumint(8) DEFAULT NULL, `num` smallint(6) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `type` (`type`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_dbsource`

CREATE TABLE `v9_dbsource` ( `id` int(10) NOT NULL AUTO_INCREMENT, `siteid` smallint(5) unsigned NOT NULL DEFAULT '0', `name` varCHAR(50) NOT NULL, `host` varCHAR(20) NOT NULL, `port` int(5) NOT NULL DEFAULT '3306', `username` varCHAR(50) NOT NULL, `password` varCHAR(50) NOT NULL, `dbname` varCHAR(50) NOT NULL, `dbtablepre` varCHAR(30) NOT NULL , `charset` varCHAR(10) NOT NULL, PRIMARY KEY (`id`), KEY `siteid` (`siteid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_downservers`

CREATE TABLE `v9_downservers` ( `id` mediumint(8) NOT NULL AUTO_INCREMENT, `sitename` varCHAR(100) DEFAULT NULL, `siteurl` varCHAR(255) DEFAULT NULL, `listorder` smallint(5) unsigned NOT NULL DEFAULT '0', `siteid` smallint(5) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_favorite`

CREATE TABLE `v9_favorite` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `userid` mediumint(8) unsigned NOT NULL DEFAULT '0', `title` CHAR(100) NOT NULL, `url` CHAR(100) NOT NULL, `adddate` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `userid` (`userid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_hits`

CREATE TABLE `v9_hits` ( `hitsid` CHAR(30) NOT NULL, `catid` smallint(5) unsigned NOT NULL DEFAULT '0', `views` int(10) unsigned NOT NULL DEFAULT '0', `yesterdayviews` int(10) unsigned NOT NULL DEFAULT '0', `dayviews` int(10) unsigned NOT NULL DEFAULT '0', `weekviews` int(10) unsigned NOT NULL DEFAULT '0', `monthviews` int(10) unsigned NOT NULL DEFAULT '0', `updatetime` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`hitsid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_ipbanned`

CREATE TABLE `v9_ipbanned` ( `ipbannedid` smallint(5) NOT NULL auto_increment, `ip` CHAR(15) NOT NULL, `expires` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`ipbannedid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_keylink`

CREATE TABLE `v9_keylink` ( `keylinkid` smallint(5) unsigned NOT NULL auto_increment, `word` CHAR(40) NOT NULL, `url` CHAR(100) NOT NULL, PRIMARY KEY (`keylinkid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_keyword`

CREATE TABLE IF NOT EXISTS `v9_keyword` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `siteid` smallint(5) unsigned NOT NULL DEFAULT '0', `keyword` CHAR(100) NOT NULL, `pinyin` CHAR(100) NOT NULL, `videonum` int(11) NOT NULL DEFAULT '0', `searchnums` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `keyword` (`keyword`,`siteid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

190414 13:57:02	DROP TABLE IF EXISTS `v9_keyword_data`

CREATE TABLE IF NOT EXISTS `v9_keyword_data` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `tagid` int(10) unsigned NOT NULL DEFAULT '0', `siteid` smallint(5) unsigned NOT NULL DEFAULT '0', `contentid` CHAR(30) NOT NULL, PRIMARY KEY (`id`), KEY `tagid` (`tagid`,`siteid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_linkage`

CREATE TABLE `v9_linkage` ( `linkageid` smallint(5) unsigned NOT NULL auto_increment, `name` varCHAR(30) NOT NULL, `style` varCHAR(35) NOT NULL, `parentid` smallint(5) unsigned NOT NULL default '0', `child` tinyint(1) NOT NULL, `arrchildid` mediumtext NOT NULL, `keyid` smallint(5) unsigned NOT NULL default '0', `listorder` smallint(5) unsigned NOT NULL default '0', `description` varCHAR(255) default NULL, `setting` varCHAR(255) default NULL, `siteid` smallint(5) NOT NULL default '0', PRIMARY KEY (`linkageid`,`keyid`), KEY `parentid` (`parentid`,`listorder`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_log`

CREATE TABLE `v9_log` ( `logid` int(10) unsigned NOT NULL auto_increment, `field` varCHAR(15) NOT NULL, `value` int(10) unsigned NOT NULL default '0', `module` varCHAR(15) NOT NULL, `file` varCHAR(20) NOT NULL, `action` varCHAR(20) NOT NULL, `querystring` varCHAR(255) NOT NULL, `data` mediumtext NOT NULL, `userid` mediumint(8) unsigned NOT NULL default '0', `username` varCHAR(20) NOT NULL, `ip` varCHAR(15) NOT NULL, `time` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`logid`), KEY `module` (`module`,`file`,`action`), KEY `username` (`username`,`action`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_member`

CREATE TABLE `v9_member` ( `userid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `phpssouid` mediumint(8) unsigned NOT NULL, `username` CHAR(20) NOT NULL DEFAULT '', `password` CHAR(32) NOT NULL DEFAULT '', `encrypt` CHAR(6) NOT NULL, `nickname` CHAR(20) NOT NULL, `regdate` int(10) unsigned NOT NULL DEFAULT '0', `lastdate` int(10) unsigned NOT NULL DEFAULT '0', `regip` CHAR(15) NOT NULL DEFAULT '', `lastip` CHAR(15) NOT NULL DEFAULT '', `loginnum` smallint(5) unsigned NOT NULL DEFAULT '0', `email` CHAR(32) NOT NULL DEFAULT '', `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0', `areaid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` decimal(8,2) unsigned NOT NULL DEFAULT '0.00', `point` smallint(5) unsigned NOT NULL DEFAULT '0', `modelid` smallint(5) unsigned NOT NULL DEFAULT '0', `message` tinyint(1) unsigned NOT NULL DEFAULT '0', `islock` tinyint(1) unsigned NOT NULL DEFAULT '0', `vip` tinyint(1) unsigned NOT NULL DEFAULT '0', `overduedate` int(10) unsigned NOT NULL DEFAULT '0', `siteid` smallint(5) unsigned NOT NULL DEFAULT '1', `connectid` CHAR(40) NOT NULL DEFAULT '', `from` CHAR(10) NOT NULL DEFAULT '', `mobile` CHAR(11) NOT NULL DEFAULT '', PRIMARY KEY (`userid`), UNIQUE KEY `username` (`username`), KEY `email` (`email`(20)), KEY `phpssouid` (`phpssouid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_member_detail`

CREATE TABLE `v9_member_detail` ( `userid` mediumint(8) unsigned NOT NULL DEFAULT '0', `birthday` date DEFAULT NULL, UNIQUE KEY `userid` (`userid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_member_group`

CREATE TABLE `v9_member_group` ( `groupid` tinyint(3) unsigned NOT NULL auto_increment, `name` CHAR(15) NOT NULL, `issystem` tinyint(1) unsigned NOT NULL default '0', `starnum` tinyint(2) unsigned NOT NULL, `point` smallint(6) unsigned NOT NULL, `allowmessage` smallint(5) unsigned NOT NULL default '0', `allowvisit` tinyint(1) unsigned NOT NULL default '0', `allowpost` tinyint(1) unsigned NOT NULL default '0', `allowpostverify` tinyint(1) unsigned NOT NULL, `allowsearch` tinyint(1) unsigned NOT NULL default '0', `allowupgrade` tinyint(1) unsigned NOT NULL default '1', `allowsendmessage` tinyint(1) unsigned NOT NULL, `allowpostnum` smallint(5) unsigned NOT NULL default '0', `allowattachment` tinyint(1) NOT NULL, `price_y` decimal(8,2) unsigned NOT NULL default '0.00', `price_m` decimal(8,2) unsigned NOT NULL default '0.00', `price_d` decimal(8,2) unsigned NOT NULL default '0.00', `icon` CHAR(30) NOT NULL, `usernamecolor` CHAR(7) NOT NULL, `description` CHAR(100) NOT NULL, `sort` tinyint(3) unsigned NOT NULL default '0', `disabled` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`groupid`), KEY `disabled` (`disabled`), KEY `listorder` (`sort`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_member_verify`

CREATE TABLE `v9_member_verify` ( `userid` mediumint(8) unsigned NOT NULL auto_increment, `username` CHAR(20) NOT NULL, `password` CHAR(32) NOT NULL, `encrypt` CHAR(6) NOT NULL, `nickname` CHAR(20) NOT NULL, `regdate` int(10) unsigned NOT NULL, `regip` CHAR(15) NOT NULL, `email` CHAR(32) NOT NULL, `modelid` tinyint(3) unsigned NOT NULL default '0', `point` smallint(5) unsigned NOT NULL default '0', `amount` decimal(8,2) unsigned NOT NULL default '0.00', `modelinfo` CHAR(255) NOT NULL default '0', `status` tinyint(1) unsigned NOT NULL default '0', `siteid` tinyint(1) unsigned NOT NULL DEFAULT '1', `message` CHAR(100) default NULL, `mobile` CHAR(11) NOT NULL DEFAULT '', PRIMARY KEY (`userid`), UNIQUE KEY `username` (`username`), KEY `email` (`email`(20))) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_member_menu`

CREATE TABLE `v9_member_menu` ( `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT, `name` CHAR(40) NOT NULL DEFAULT '', `parentid` smallint(6) NOT NULL DEFAULT '0', `m` CHAR(20) NOT NULL DEFAULT '', `c` CHAR(20) NOT NULL DEFAULT '', `a` CHAR(20) NOT NULL DEFAULT '', `data` CHAR(100) NOT NULL DEFAULT '', `listorder` smallint(6) unsigned NOT NULL DEFAULT '0', `display` enum('1','0') NOT NULL DEFAULT '1', `isurl` enum('1','0') NOT NULL DEFAULT '0', `url` CHAR(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `listorder` (`listorder`), KEY `parentid` (`parentid`), KEY `module` (`m`,`c`,`a`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_member_vip`

CREATE TABLE `v9_member_vip` ( `userid` mediumint(8) unsigned NOT NULL DEFAULT '0', UNIQUE KEY `userid` (`userid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_menu`

CREATE TABLE `v9_menu` ( `id` smallint(6) unsigned NOT NULL auto_increment, `name` CHAR(40) NOT NULL default '', `parentid` smallint(6) NOT NULL default '0', `m` CHAR(20) NOT NULL default '', `c` CHAR(20) NOT NULL default '', `a` CHAR(20) NOT NULL default '', `data` CHAR(100) NOT NULL default '', `listorder` smallint(6) unsigned NOT NULL default '0', `display` enum('1','0') NOT NULL default '1', `project1` tinyint(1) unsigned NOT NULL DEFAULT '1', `project2` tinyint(1) unsigned NOT NULL DEFAULT '1', `project3` tinyint(1) unsigned NOT NULL DEFAULT '1', `project4` tinyint(1) unsigned NOT NULL DEFAULT '1', `project5` tinyint(1) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `listorder` (`listorder`), KEY `parentid` (`parentid`), KEY `module` (`m`,`c`,`a`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_model`

CREATE TABLE IF NOT EXISTS `v9_model` ( `modelid` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `siteid` smallint(5) unsigned NOT NULL DEFAULT '0', `name` CHAR(30) NOT NULL, `description` CHAR(100) NOT NULL, `tablename` CHAR(20) NOT NULL, `setting` text NOT NULL , `addtime` int(10) unsigned NOT NULL DEFAULT '0' , `items` smallint(5) unsigned NOT NULL DEFAULT '0' , `enablesearch` tinyint(1) unsigned NOT NULL DEFAULT '1', `disabled` tinyint(1) unsigned NOT NULL DEFAULT '0', `default_style` CHAR(30) NOT NULL, `category_template` CHAR(30) NOT NULL, `list_template` CHAR(30) NOT NULL, `show_template` CHAR(30) NOT NULL, `js_template` varCHAR(30) NOT NULL , `admin_list_template` CHAR(30) NOT NULL, `member_add_template` varCHAR(30) NOT NULL , `member_list_template` varCHAR(30) NOT NULL , `sort` tinyint(3) NOT NULL, `type` tinyint(1) NOT NULL, PRIMARY KEY (`modelid`), KEY `type` (`type`,`siteid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_model_field`

CREATE TABLE IF NOT EXISTS `v9_model_field` ( `fieldid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `modelid` smallint(5) unsigned NOT NULL DEFAULT '0', `siteid` smallint(5) unsigned NOT NULL DEFAULT '0', `field` varCHAR(20) NOT NULL, `name` varCHAR(30) NOT NULL, `tips` text NOT NULL, `css` varCHAR(30) NOT NULL, `minlength` int(10) unsigned NOT NULL DEFAULT '0', `maxlength` int(10) unsigned NOT NULL DEFAULT '0', `pattern` varCHAR(255) NOT NULL, `errortips` varCHAR(255) NOT NULL, `formtype` varCHAR(20) NOT NULL, `setting` mediumtext NOT NULL, `formattribute` varCHAR(255) NOT NULL, `unsetgroupids` varCHAR(255) NOT NULL, `unsetroleids` varCHAR(255) NOT NULL, `iscore` tinyint(1) unsigned NOT NULL DEFAULT '0', `issystem` tinyint(1) unsigned NOT NULL DEFAULT '0', `isunique` tinyint(1) unsigned NOT NULL DEFAULT '0', `isbase` tinyint(1) unsigned NOT NULL DEFAULT '0', `issearch` tinyint(1) unsigned NOT NULL DEFAULT '0', `isadd` tinyint(1) unsigned NOT NULL DEFAULT '0', `isfulltext` tinyint(1) unsigned NOT NULL DEFAULT '0', `isposition` tinyint(1) unsigned NOT NULL DEFAULT '0', `listorder` mediumint(8) unsigned NOT NULL DEFAULT '0', `disabled` tinyint(1) unsigned NOT NULL DEFAULT '0', `isomnipotent` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`fieldid`), KEY `modelid` (`modelid`,`disabled`), KEY `field` (`field`,`modelid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

190414 13:57:03	DROP TABLE IF EXISTS `v9_module`

CREATE TABLE `v9_module` ( `module` varCHAR(15) NOT NULL, `name` varCHAR(20) NOT NULL, `url` varCHAR(50) NOT NULL, `iscore` tinyint(1) unsigned NOT NULL default '0', `version` varCHAR(50) NOT NULL default '', `description` varCHAR(255) NOT NULL, `setting` mediumtext NOT NULL, `listorder` tinyint(3) unsigned NOT NULL default '0', `disabled` tinyint(1) unsigned NOT NULL default '0', `installdate` date NOT NULL default '0000-00-00', `updatedate` date NOT NULL default '0000-00-00', PRIMARY KEY (`module`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_page`

CREATE TABLE `v9_page` ( `catid` smallint(5) unsigned NOT NULL DEFAULT '0', `title` varCHAR(160) NOT NULL, `style` varCHAR(24) NOT NULL, `keywords` varCHAR(40) NOT NULL, `content` text NOT NULL, `template` varCHAR(30) NOT NULL, `updatetime` int(10) unsigned NOT NULL DEFAULT '0', KEY `catid` (`catid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_pay_account`

CREATE TABLE `v9_pay_account` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `trade_sn` CHAR(50) NOT NULL, `userid` mediumint(8) unsigned NOT NULL DEFAULT '0', `username` CHAR(20) NOT NULL, `contactname` CHAR(50) NOT NULL, `email` CHAR(40) NOT NULL, `telephone` CHAR(20) NOT NULL, `discount` float(8,2) NOT NULL DEFAULT '0.00', `money` CHAR(8) NOT NULL, `quantity` int(8) unsigned NOT NULL DEFAULT '1', `addtime` int(10) NOT NULL DEFAULT '0', `paytime` int(10) NOT NULL DEFAULT '0', `usernote` CHAR(255) NOT NULL, `pay_id` tinyint(3) NOT NULL, `pay_type` enum('offline','recharge','selfincome','online') NOT NULL DEFAULT 'recharge', `payment` CHAR(90) NOT NULL, `type` tinyint(3) NOT NULL DEFAULT '1', `ip` CHAR(15) NOT NULL DEFAULT '0.0.0.0', `status` enum('succ','failed','error','progress','timeout','cancel','waitting','unpay') NOT NULL DEFAULT 'unpay', `adminnote` CHAR(20) NOT NULL, PRIMARY KEY (`id`), KEY `status` (`status`), KEY `userid` (`userid`), KEY `trade_sn` (`trade_sn`,`money`,`status`,`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_pay_payment`

CREATE TABLE `v9_pay_payment` ( `pay_id` tinyint(3) unsigned NOT NULL auto_increment, `name` varCHAR(120) NOT NULL, `pay_name` varCHAR(120) NOT NULL, `pay_code` varCHAR(20) NOT NULL, `pay_desc` text NOT NULL, `pay_method` tinyint(1) default NULL, `pay_fee` varCHAR(10) NOT NULL, `config` text NOT NULL, `is_cod` tinyint(1) unsigned NOT NULL default '0', `is_online` tinyint(1) unsigned NOT NULL default '0', `pay_order` tinyint(3) unsigned NOT NULL default '0', `enabled` tinyint(1) unsigned NOT NULL default '0', `author` varCHAR(100) NOT NULL, `website` varCHAR(100) NOT NULL, `version` varCHAR(20) NOT NULL, PRIMARY KEY (`pay_id`), KEY `pay_code` (`pay_code`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_pay_spend`

CREATE TABLE `v9_pay_spend` ( `id` int(10) unsigned NOT NULL auto_increment, `creat_at` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `username` varCHAR(20) NOT NULL, `type` tinyint(1) unsigned NOT NULL default '0', `logo` varCHAR(20) NOT NULL, `value` int(5) NOT NULL, `op_userid` int(10) unsigned NOT NULL default '0', `op_username` CHAR(20) NOT NULL, `msg` varCHAR(255) NOT NULL, PRIMARY KEY (`id`), KEY `type` (`type`), KEY `creat_at` (`creat_at`), KEY `logo` (`logo`), KEY `userid` (`userid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_position`

CREATE TABLE `v9_position` ( `posid` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `modelid` smallint(5) unsigned DEFAULT '0', `catid` smallint(5) unsigned DEFAULT '0', `name` CHAR(30) NOT NULL DEFAULT '', `maxnum` smallint(5) NOT NULL DEFAULT '20', `extention` CHAR(100) DEFAULT NULL, `listorder` smallint(5) unsigned NOT NULL DEFAULT '0', `siteid` smallint(5) unsigned NOT NULL DEFAULT '0', `thumb` varCHAR(150) NOT NULL DEFAULT '', PRIMARY KEY (`posid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

INSERT INTO `v9_position` (`posid`, `modelid`, `catid`, `name`, `maxnum`, `listorder`, `siteid`) VALUES(1, 0, 0, '首页焦点图推荐', 20, 1, 1)

INSERT INTO `v9_position` (`posid`, `modelid`, `catid`, `name`, `maxnum`, `listorder`, `siteid`) VALUES(2, 0, 0, '首页头条推荐', 20, 4, 1)

INSERT INTO `v9_position` (`posid`, `modelid`, `catid`, `name`, `maxnum`, `listorder`, `siteid`) VALUES(13, 82, 0, '栏目页焦点图', 20, 0, 1)

INSERT INTO `v9_position` (`posid`, `modelid`, `catid`, `name`, `maxnum`, `listorder`, `siteid`) VALUES(5, 69, 0, '推荐下载', 20, 0, 1)

INSERT INTO `v9_position` (`posid`, `modelid`, `catid`, `name`, `maxnum`, `listorder`, `siteid`) VALUES(8, 30, 54, '图片频道首页焦点图', 20, 0, 1)

INSERT INTO `v9_position` (`posid`, `modelid`, `catid`, `name`, `maxnum`, `listorder`, `siteid`) VALUES(9, 0, 0, '网站顶部推荐', 20, 0, 1)

INSERT INTO `v9_position` (`posid`, `modelid`, `catid`, `name`, `maxnum`, `listorder`, `siteid`) VALUES(10, 0, 0, '栏目首页推荐', 20, 0, 1)

INSERT INTO `v9_position` (`posid`, `modelid`, `catid`, `name`, `maxnum`, `listorder`, `siteid`) VALUES(12, 0, 0, '首页图片推荐', 20, 0, 1)

INSERT INTO `v9_position` (`posid`, `modelid`, `catid`, `name`, `maxnum`, `extention`, `listorder`, `siteid`) VALUES(14, 0, 0, '视频首页焦点图', 20, '', 0, 1),(15, 0, 0, '视频首页头条推荐', 20, '', 0, 1),(16, 0, 0, '视频首页每日热点', 20, '', 0, 1),(17, 0, 0, '视频栏目精彩推荐', 20, '', 0, 1)

DROP TABLE IF EXISTS `v9_position_data`

CREATE TABLE `v9_position_data` ( `id` mediumint(8) unsigned NOT NULL DEFAULT '0', `catid` smallint(5) unsigned NOT NULL DEFAULT '0', `posid` smallint(5) unsigned NOT NULL DEFAULT '0', `module` CHAR(20) DEFAULT NULL, `modelid` smallint(6) unsigned DEFAULT '0', `thumb` tinyint(1) NOT NULL DEFAULT '0', `data` mediumtext, `siteid` smallint(5) unsigned NOT NULL DEFAULT '1', `listorder` mediumint(8) DEFAULT '0', `expiration` int(10) NOT NULL, `extention` CHAR(30) DEFAULT NULL, `synedit` tinyint(1) DEFAULT '0', KEY `posid` (`posid`), KEY `listorder` (`listorder`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_queue`

CREATE TABLE `v9_queue` ( `id` int(10) NOT NULL AUTO_INCREMENT, `type` CHAR(5) DEFAULT NULL, `siteid` smallint(5) unsigned DEFAULT '0', `path` varCHAR(100) DEFAULT NULL, `status1` tinyint(1) DEFAULT '0', `status2` tinyint(1) DEFAULT '0', `status3` tinyint(1) DEFAULT '0', `status4` tinyint(1) DEFAULT '0', `times` int(10) unsigned DEFAULT '0', PRIMARY KEY (`id`), KEY `siteid` (`siteid`), KEY `times` (`times`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_release_point`

CREATE TABLE `v9_release_point` ( `id` mediumint(8) NOT NULL auto_increment, `name` varCHAR(30) default NULL, `host` varCHAR(100) default NULL, `username` varCHAR(50) default NULL, `password` varCHAR(50) default NULL, `port` varCHAR(10) default '21', `pasv` tinyint(1) default '0', `ssl` tinyint(1) default '0', `path` varCHAR(50) default NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_search`

CREATE TABLE `v9_search` ( `searchid` int(10) unsigned NOT NULL AUTO_INCREMENT, `typeid` smallint(5) unsigned NOT NULL DEFAULT '0', `id` mediumint(8) unsigned NOT NULL DEFAULT '0', `adddate` int(10) unsigned NOT NULL, `data` text NOT NULL, `siteid` smallint(5) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`searchid`), KEY `typeid` (`typeid`,`id`), KEY `siteid` (`siteid`), FULLTEXT KEY `data` (`data`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_search_keyword`

CREATE TABLE `v9_search_keyword` ( `keyword` CHAR(20) NOT NULL, `pinyin` CHAR(20) NOT NULL, `searchnums` int(10) unsigned NOT NULL, `data` CHAR(20) NOT NULL, UNIQUE KEY `keyword` (`keyword`), UNIQUE KEY `pinyin` (`pinyin`), FULLTEXT KEY `data` (`data`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_session`

CREATE TABLE `v9_session` ( `sessionid` CHAR(32) NOT NULL, `userid` mediumint(8) unsigned NOT NULL default '0', `ip` CHAR(15) NOT NULL, `lastvisit` int(10) unsigned NOT NULL default '0', `roleid` tinyint(3) unsigned default '0', `groupid` tinyint(3) unsigned NOT NULL default '0', `m` CHAR(20) NOT NULL, `c` CHAR(20) NOT NULL, `a` CHAR(20) NOT NULL, `data` CHAR(255) NOT NULL, PRIMARY KEY (`sessionid`), KEY `lastvisit` (`lastvisit`)) ENGINE=MEMORY DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_site`

CREATE TABLE `v9_site` ( `siteid` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `name` CHAR(30) DEFAULT '', `dirname` CHAR(255) DEFAULT '', `domain` CHAR(255) DEFAULT '', `site_title` CHAR(255) DEFAULT '', `keywords` CHAR(255) DEFAULT '', `description` CHAR(255) DEFAULT '', `release_point` text, `default_style` CHAR(50) DEFAULT NULL, `template` text, `setting` mediumtext, `uuid` CHAR(40) DEFAULT '', PRIMARY KEY (`siteid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_special`

CREATE TABLE IF NOT EXISTS `v9_special` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `siteid` smallint(5) unsigned NOT NULL DEFAULT '0', `aid` int(10) unsigned NOT NULL DEFAULT '0', `title` CHAR(60) NOT NULL, `typeids` CHAR(100) NOT NULL, `thumb` CHAR(100) NOT NULL, `banner` CHAR(100) NOT NULL, `description` CHAR(255) NOT NULL, `url` CHAR(100) NOT NULL, `ishtml` tinyint(1) unsigned NOT NULL DEFAULT '0', `ispage` tinyint(1) unsigned NOT NULL, `filename` CHAR(40) NOT NULL, `pics` CHAR(100) NOT NULL, `voteid` CHAR(60) NOT NULL, `style` CHAR(20) NOT NULL, `index_template` CHAR(40) NOT NULL, `list_template` CHAR(40) NOT NULL, `show_template` CHAR(60) NOT NULL, `css` text NOT NULL, `username` CHAR(40) NOT NULL, `userid` mediumint(8) unsigned NOT NULL DEFAULT '0', `createtime` int(10) unsigned NOT NULL DEFAULT '0', `listorder` smallint(5) unsigned NOT NULL, `elite` tinyint(1) unsigned NOT NULL DEFAULT '0', `disabled` tinyint(1) unsigned NOT NULL DEFAULT '0', `isvideo` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `disabled` (`disabled`,`siteid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

190414 13:57:04	DROP TABLE IF EXISTS `v9_special_c_data`

CREATE TABLE IF NOT EXISTS `v9_special_c_data` ( `id` mediumint(8) unsigned NOT NULL DEFAULT '0', `author` varCHAR(40) NOT NULL, `content` text NOT NULL, `paginationtype` tinyint(1) unsigned NOT NULL DEFAULT '0', `maxcharperpage` mediumint(6) unsigned NOT NULL DEFAULT '0', `style` CHAR(20) NOT NULL, `show_template` varCHAR(30) NOT NULL, UNIQUE KEY `id` (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_special_content`

CREATE TABLE IF NOT EXISTS `v9_special_content` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `specialid` smallint(5) unsigned NOT NULL DEFAULT '0', `title` CHAR(80) NOT NULL, `style` CHAR(24) NOT NULL, `typeid` smallint(5) unsigned NOT NULL DEFAULT '0', `thumb` CHAR(100) NOT NULL, `keywords` CHAR(40) NOT NULL, `description` CHAR(255) NOT NULL, `url` CHAR(100) NOT NULL, `curl` CHAR(15) NOT NULL, `listorder` mediumint(8) unsigned NOT NULL DEFAULT '0', `userid` mediumint(8) unsigned NOT NULL DEFAULT '0', `username` CHAR(20) NOT NULL, `inputtime` int(10) unsigned NOT NULL DEFAULT '0', `updatetime` int(10) unsigned NOT NULL DEFAULT '0', `searchid` mediumint(8) unsigned NOT NULL DEFAULT '0', `islink` tinyint(1) unsigned NOT NULL DEFAULT '0', `isdata` tinyint(1) unsigned NOT NULL DEFAULT '0', `videoid` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `specialid` (`specialid`,`typeid`,`isdata`), KEY `typeid` (`typeid`,`isdata`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_sphinx_counter`

CREATE TABLE `v9_sphinx_counter` ( `counter_id` int(11) unsigned NOT NULL, `max_doc_id` int(11) unsigned NOT NULL, PRIMARY KEY (`counter_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_template_bak`

CREATE TABLE `v9_template_bak` ( `id` int(10) NOT NULL AUTO_INCREMENT, `creat_at` int(10) unsigned DEFAULT '0', `fileid` CHAR(50) DEFAULT NULL, `userid` mediumint(8) DEFAULT NULL, `username` CHAR(20) DEFAULT NULL, `template` text, PRIMARY KEY (`id`), KEY `fileid` (`fileid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_times`

CREATE TABLE `v9_times` ( `username` CHAR(40) NOT NULL, `ip` CHAR(15) NOT NULL, `logintime` int(10) unsigned NOT NULL default '0', `isadmin` tinyint(1) NOT NULL default '0', `times` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`username`,`isadmin`)) ENGINE=MEMORY DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_type`

CREATE TABLE `v9_type` ( `typeid` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `siteid` smallint(5) unsigned NOT NULL DEFAULT '0', `module` CHAR(15) NOT NULL, `modelid` smallint(5) unsigned NOT NULL DEFAULT '0', `name` CHAR(30) NOT NULL, `parentid` smallint(5) unsigned NOT NULL DEFAULT '0', `typedir` CHAR(20) NOT NULL, `url` CHAR(100) NOT NULL, `template` CHAR(30) NOT NULL, `listorder` smallint(5) unsigned NOT NULL DEFAULT '0', `description` varCHAR(255) NOT NULL, PRIMARY KEY (`typeid`), KEY `module` (`module`,`parentid`,`siteid`,`listorder`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_urlrule`

CREATE TABLE `v9_urlrule` ( `urlruleid` smallint(5) unsigned NOT NULL auto_increment, `module` varCHAR(15) NOT NULL, `file` varCHAR(20) NOT NULL, `ishtml` tinyint(1) unsigned NOT NULL default '0', `urlrule` varCHAR(255) NOT NULL, `example` varCHAR(255) NOT NULL, PRIMARY KEY (`urlruleid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_workflow`

CREATE TABLE `v9_workflow` ( `workflowid` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `siteid` smallint(5) unsigned NOT NULL DEFAULT '0', `steps` tinyint(1) unsigned NOT NULL DEFAULT '1', `workname` varCHAR(20) NOT NULL, `description` varCHAR(255) NOT NULL, `setting` text NOT NULL, `flag` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`workflowid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

INSERT INTO `v9_workflow` (`workflowid`, `siteid`, `steps`, `workname`, `description`, `setting`) VALUES(1, 1, 1, '一级审核', '审核一次', '')

INSERT INTO `v9_workflow` (`workflowid`, `siteid`, `steps`, `workname`, `description`, `setting`) VALUES(2, 1, 2, '二级审核', '审核两次', '')

INSERT INTO `v9_workflow` (`workflowid`, `siteid`, `steps`, `workname`, `description`, `setting`) VALUES(3, 1, 3, '三级审核', '审核三次', '')

INSERT INTO `v9_workflow` (`workflowid`, `siteid`, `steps`, `workname`, `description`, `setting`) VALUES(4, 1, 4, '四级审核', '四级审核', '')

DROP TABLE IF EXISTS `v9_copyfrom`

CREATE TABLE IF NOT EXISTS `v9_copyfrom` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `siteid` smallint(5) unsigned NOT NULL DEFAULT '0', `sitename` varCHAR(30) NOT NULL, `siteurl` varCHAR(100) NOT NULL, `thumb` varCHAR(100) NOT NULL, `listorder` smallint(5) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_download`

CREATE TABLE IF NOT EXISTS `v9_download` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `catid` smallint(5) unsigned NOT NULL DEFAULT '0', `typeid` smallint(5) unsigned NOT NULL, `title` CHAR(80) NOT NULL DEFAULT '', `style` CHAR(24) NOT NULL DEFAULT '', `thumb` varCHAR(100) NOT NULL DEFAULT '', `keywords` CHAR(40) NOT NULL DEFAULT '', `description` CHAR(255) NOT NULL DEFAULT '', `posids` tinyint(1) unsigned NOT NULL DEFAULT '0', `url` CHAR(100) NOT NULL, `listorder` tinyint(3) unsigned NOT NULL DEFAULT '0', `status` tinyint(2) unsigned NOT NULL DEFAULT '1', `sysadd` tinyint(1) unsigned NOT NULL DEFAULT '0', `islink` tinyint(1) unsigned NOT NULL DEFAULT '0', `username` CHAR(20) NOT NULL, `inputtime` int(10) unsigned NOT NULL DEFAULT '0', `updatetime` int(10) unsigned NOT NULL DEFAULT '0', `systems` varCHAR(100) NOT NULL DEFAULT 'Win2000/WinXP/Win2003', `copytype` varCHAR(15) NOT NULL DEFAULT '', `language` varCHAR(10) NOT NULL DEFAULT '', `classtype` varCHAR(20) NOT NULL DEFAULT '', `version` varCHAR(20) NOT NULL DEFAULT '', `filesize` varCHAR(10) NOT NULL DEFAULT 'Unkown', `stars` varCHAR(20) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `status` (`status`,`listorder`,`id`), KEY `listorder` (`catid`,`status`,`listorder`,`id`), KEY `catid` (`catid`,`status`,`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_download_data`

CREATE TABLE IF NOT EXISTS `v9_download_data` ( `id` mediumint(8) unsigned DEFAULT '0', `content` text NOT NULL, `readpoint` smallint(5) unsigned NOT NULL DEFAULT '0', `groupids_view` varCHAR(100) NOT NULL, `paginationtype` tinyint(1) NOT NULL, `maxcharperpage` mediumint(6) NOT NULL, `template` varCHAR(30) NOT NULL, `paytype` tinyint(1) unsigned NOT NULL DEFAULT '0', `relation` varCHAR(255) NOT NULL DEFAULT '', `allow_comment` tinyint(1) unsigned NOT NULL DEFAULT '1', `downfiles` mediumtext NOT NULL, `downfile` varCHAR(255) NOT NULL DEFAULT '', KEY `id` (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

190414 13:57:05	DROP TABLE IF EXISTS `v9_news`

CREATE TABLE IF NOT EXISTS `v9_news` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `catid` smallint(5) unsigned NOT NULL DEFAULT '0', `typeid` smallint(5) unsigned NOT NULL, `title` varCHAR(80) NOT NULL DEFAULT '', `style` CHAR(24) NOT NULL DEFAULT '', `thumb` varCHAR(100) NOT NULL DEFAULT '', `keywords` CHAR(40) NOT NULL DEFAULT '', `description` mediumtext NOT NULL, `posids` tinyint(1) unsigned NOT NULL DEFAULT '0', `url` CHAR(100) NOT NULL, `listorder` tinyint(3) unsigned NOT NULL DEFAULT '0', `status` tinyint(2) unsigned NOT NULL DEFAULT '1', `sysadd` tinyint(1) unsigned NOT NULL DEFAULT '0', `islink` tinyint(1) unsigned NOT NULL DEFAULT '0', `username` CHAR(20) NOT NULL, `inputtime` int(10) unsigned NOT NULL DEFAULT '0', `updatetime` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `status` (`status`,`listorder`,`id`), KEY `listorder` (`catid`,`status`,`listorder`,`id`), KEY `catid` (`catid`,`status`,`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_news_data`

CREATE TABLE IF NOT EXISTS `v9_news_data` ( `id` mediumint(8) unsigned DEFAULT '0', `content` mediumtext NOT NULL, `readpoint` smallint(5) unsigned NOT NULL DEFAULT '0', `groupids_view` varCHAR(100) NOT NULL, `paginationtype` tinyint(1) NOT NULL, `maxcharperpage` mediumint(6) NOT NULL, `template` varCHAR(30) NOT NULL, `paytype` tinyint(1) unsigned NOT NULL DEFAULT '0', `relation` varCHAR(255) NOT NULL DEFAULT '', `voteid` mediumint(8) unsigned NOT NULL DEFAULT '0', `allow_comment` tinyint(1) unsigned NOT NULL DEFAULT '1', `copyfrom` varCHAR(100) NOT NULL DEFAULT '', KEY `id` (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_picture`

CREATE TABLE IF NOT EXISTS `v9_picture` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `catid` smallint(5) unsigned NOT NULL DEFAULT '0', `typeid` smallint(5) unsigned NOT NULL, `title` CHAR(80) NOT NULL DEFAULT '', `style` CHAR(24) NOT NULL DEFAULT '', `thumb` CHAR(100) NOT NULL DEFAULT '', `keywords` CHAR(40) NOT NULL DEFAULT '', `description` CHAR(255) NOT NULL DEFAULT '', `posids` tinyint(1) unsigned NOT NULL DEFAULT '0', `url` CHAR(100) NOT NULL, `listorder` tinyint(3) unsigned NOT NULL DEFAULT '0', `status` tinyint(2) unsigned NOT NULL DEFAULT '1', `sysadd` tinyint(1) unsigned NOT NULL DEFAULT '0', `islink` tinyint(1) unsigned NOT NULL DEFAULT '0', `username` CHAR(20) NOT NULL, `inputtime` int(10) unsigned NOT NULL DEFAULT '0', `updatetime` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `status` (`status`,`listorder`,`id`), KEY `listorder` (`catid`,`status`,`listorder`,`id`), KEY `catid` (`catid`,`status`,`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_picture_data`

CREATE TABLE IF NOT EXISTS `v9_picture_data` ( `id` mediumint(8) unsigned DEFAULT '0', `content` text NOT NULL, `readpoint` smallint(5) unsigned NOT NULL DEFAULT '0', `groupids_view` varCHAR(100) NOT NULL, `paginationtype` tinyint(1) NOT NULL, `maxcharperpage` mediumint(6) NOT NULL, `template` varCHAR(30) NOT NULL, `paytype` tinyint(1) unsigned NOT NULL DEFAULT '0', `relation` varCHAR(255) NOT NULL DEFAULT '', `pictureurls` mediumtext NOT NULL, `copyfrom` varCHAR(255) NOT NULL DEFAULT '', `allow_comment` tinyint(1) unsigned NOT NULL DEFAULT '1', KEY `id` (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_video`

CREATE TABLE IF NOT EXISTS `v9_video` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `catid` smallint(5) unsigned NOT NULL DEFAULT '0', `typeid` smallint(5) unsigned NOT NULL, `title` CHAR(80) NOT NULL DEFAULT '', `style` CHAR(24) NOT NULL DEFAULT '', `thumb` CHAR(100) NOT NULL DEFAULT '', `keywords` CHAR(40) NOT NULL DEFAULT '', `description` CHAR(255) NOT NULL DEFAULT '', `posids` tinyint(1) unsigned NOT NULL DEFAULT '0', `url` CHAR(100) NOT NULL, `listorder` tinyint(3) unsigned NOT NULL DEFAULT '0', `status` tinyint(2) unsigned NOT NULL DEFAULT '1', `sysadd` tinyint(1) unsigned NOT NULL DEFAULT '0', `islink` tinyint(1) unsigned NOT NULL DEFAULT '0', `username` CHAR(20) NOT NULL, `inputtime` int(10) unsigned NOT NULL DEFAULT '0', `updatetime` int(10) unsigned NOT NULL DEFAULT '0', `vision` varCHAR(255) NOT NULL DEFAULT '', `video_category` varCHAR(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `status` (`status`,`listorder`,`id`), KEY `listorder` (`catid`,`status`,`listorder`,`id`), KEY `catid` (`catid`,`status`,`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_video_data`

CREATE TABLE IF NOT EXISTS `v9_video_data` ( `id` mediumint(8) unsigned DEFAULT '0', `content` text NOT NULL, `readpoint` smallint(5) unsigned NOT NULL DEFAULT '0', `groupids_view` varCHAR(100) NOT NULL, `paginationtype` tinyint(1) NOT NULL, `maxcharperpage` mediumint(6) NOT NULL, `template` varCHAR(30) NOT NULL, `paytype` tinyint(1) unsigned NOT NULL DEFAULT '0', `allow_comment` tinyint(1) unsigned NOT NULL DEFAULT '1', `relation` varCHAR(255) NOT NULL DEFAULT '', `video` tinyint(3) unsigned NOT NULL DEFAULT '0', KEY `id` (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

DROP TABLE IF EXISTS `v9_extend_setting`

CREATE TABLE IF NOT EXISTS `v9_extend_setting` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `key` CHAR(30) NOT NULL, `data` mediumtext, PRIMARY KEY (`id`), KEY `key` (`key`)) ENGINE=MyISAM DEFAULT CHARSET=utf8

完整带数据版本见github:https://github.com/sunjdk/pca.git   的 phpcms-v9.sql

 

桃根仙
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
PHPCMS V9 数据库操作方法
01-26
数据库的操作基本也就增删改查四类，本文主要列出PHPCMS V9的数据库操作类常用的增删改查的使用方法，为我们对PHPCMS二次开发时对数据库操作时提供帮助。
PHPCMS V9 SQL查询篇
weixin_34195364的博客
03-12 188
1.添加查询条件 {php $sql5 = " pay_type_int = 24"} {pc:content action="lists" catid="11" moreinfo="1" where="$sql5" num="1" order="listorder asc,inputtime asc" page="$page" cache="$cachetime" } 2.同时调用指定栏目和...
php v9 sql,PHPCMS v9 SQL注入
weixin_29920697的博客
03-17 414
2013 年 2 月 4 日 by lanu文章题目：[漏洞分析]PHPCMS v9 SQL注入作 者：L.N. && n3w1yb1r7h时 间：2013-02-03声 明：此漏洞非本人首发，在此只作代码分析。漏洞分析：漏洞文件：/phpcms/modules/member/index.php[php]public functi...
phpcms V9自定义评论字段UTF8_CMSYOU修正版
09-29
1. **创建专用表**：首先执行SQL语句，创建`v9_comment_plfield`表（这里的`v9_`应替换为你的网站表前缀）。 2. **备份并覆盖文件**：备份`phpcms\modules\comment\index.php`，然后将修正后的phpcms目录覆盖到网站...
PHPCMS V9代码生成器 2.0
11-06
5. **数据库操作**：代码生成器自动处理与数据库的交互，包括创建、更新、删除和查询SQL语句的生成。这样，开发者无需手动编写复杂的SQL，降低了出错的可能性。 6. **API接口生成**：随着前后端分离的趋势，代码...
如何给phpcms v9增加类似于phpcms 2008中的关键词表
10-27
可以使用以下SQL语句创建表： ```sql CREATE TABLE `t_v9_keyword_ext` ( `tagid` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `tag` char(50) NOT NULL, `style` char(5) NOT NULL, `usetimes` smallint(5...
PhpCms V9 数据结构 Excel 版.rar
07-09
开发者可以根据数据表结构编写SQL语句，实现自定义查询、更新或插入操作。同时，对于系统性能优化、数据迁移、数据备份等工作也大有裨益。 六、注意事项 在使用和修改PHP CMS V9的数据结构时，务必遵循数据库设计...
phpcms v9使用GET调用指定id文章内容、页面数据方法(get标签什么方法)
09-29
在这个例子中，`sql`参数定义了SQL查询语句，用于从`cmsyou_page`表中选取所有字段，其中`catid='55'`是我们的筛选条件，表示我们要获取分类ID为55的页面内容。`cache`参数设定了缓存时间（3600秒，即1小时），`...
phpcms set inc.php,phpcms V9 sql注入漏洞测试
weixin_30618305的博客
03-23 494
phpcms V9 版本存在SQL注入漏洞，漏洞复现如下0x00 以GET方式访问如下链接,得到返回包里mvbpqw_siteid值：http://127.0.0.1/index.php?m=wap&c=index&a=init&siteid=10x01 构造SQL语句，将0x00中的mvbpqw_siteid值代入下面链接，以POST方式发起请求0x02 将0x01步中的...
v9教你输出最后一次sql语句
redsen的专栏
09-24 876
mysql.class.php 位于phpcms/libs/classes 在public $lastqueryid = null;后面加入代码 public $lastquerysql = null; //最后一次查询sql 复制代码 修改execute方法 private function execute($sql) {   
PHPCMS V9中get标签sql语句中不能带有limit语句的解决办法
大海哪蓝
10-19 393
1.比如{pc:get sql="SELECT title,url FROM v9_news where catid=9 and status=99  order by updatetime desc" start="0" num="4" return="v"}可以加入start 和 num 来控制。2.（比较绝的方法）{pc:get sql="SELECT title,url FROM v9_n...
phpcmsv9入门总结
mousesQi的博客
06-09 1404
一、pc标签的使用栏目调取：{pc:content action=”category” catid=”$catid” order=”listorder ASC” return=”data1” num=”10” page="$_GET[page]" } {loop $data1 $r} <div> <a href=”{$r[url]}”></a> <di...
PHPCMS v9安装时出错
yh_bxhl的专栏
08-13 481
PHPCMSv9安装时报MySQL Query :SELECT * FROM `1993_com`.`v9_module` WHERE `module` = 'announce' LIMIT 1 找到原因了，MYSQL查询语句写法 TYPE=MyISAM 太老了，在MYSQL 5.5上已经被禁用，将安装程序包的TYPE=MyISAM 全部改成ENGINE=MyISAM就能正常安装了。。 目录在...
php v9 如何获取超级管理员权限,phpcms v9 增加后台管理员其他权限角色可以查看信息不能修改信息...
weixin_33593741的博客
03-18 297
phpcms v9 增加后台管理员其他角色可以查看信息不能修改信息phpcms\modules\content\templates\content_list.tpl.php这里面判断是不是管理员角色，如果不是原来的编辑链接改为查看链接，php代码如下if ($_SESSION['roleid']!=1){?>查看详情}else{?>查看/修改}?>创建 content_view....
数据库插入insert into value/values的区别
CQk先生的博客
09-10 8450
数据库插入insert into value/values的区别
SQL基础_数据插入（INSERT INTO...VALUES...）
热门推荐
A0.618的博客
07-13 3万+
学习重点 insert 原则上每次执行一行数据插入。 对表中所有列进行insert 操作时可以省略表明后的列清单。 插入NULL时需要在VALUES子句的值清单中写入NULL。 可以为表中的列设置默认值（初始值）。默认值可以通过在create table语句中，为列设置default约束来设定。 插入默认值方法有两种： ①create table … default… ②insert 。。。va...
phpcms v9安装
最新发布
08-30
要安装phpcms v9，您可以按照以下步骤进行操作： 1. 首先，您需要下载phpcms v9的安装包，您可以从官方网站（https://www.phpcms.cn/）获取最新版本的安装包。 2. 解压下载的安装包，并将文件上传到您的Web服务器...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值