齐博地方门户系统 V5.0官方商业版 官方5.0风格

DROP TABLE IF EXISTS qb_members; CREATE TABLE `qb_members` ( `uid` mediumint(7) unsigned NOT NULL auto_increment, `username` varchar(30) NOT NULL default '', `password` varchar(32) NOT NULL default '', PRIMARY KEY (`uid`) ) TYPE=MyISAM; DROP TABLE IF EXISTS qb_memberdata; CREATE TABLE `qb_memberdata` ( `uid` mediumint(7) unsigned NOT NULL default '0', `username` varchar(50) NOT NULL default '', `qq_api` varchar(32) NOT NULL default '', `question` varchar(32) NOT NULL default '', `groupid` smallint(4) NOT NULL default '0', `grouptype` tinyint(1) NOT NULL default '0', `groups` varchar(255) NOT NULL default '', `yz` tinyint(1) NOT NULL default '0', `newpm` tinyint(1) NOT NULL default '0', `medals` varchar(255) NOT NULL default '', `money` mediumint(7) unsigned NOT NULL default '0', `totalspace` bigint(13) NOT NULL default '0', `usespace` bigint(13) NOT NULL default '0', `oltime` int(10) NOT NULL default '0', `lastvist` int(10) NOT NULL default '0', `lastip` varchar(15) NOT NULL default '', `regdate` int(10) NOT NULL default '0', `regip` varchar(15) NOT NULL default '', `sex` tinyint(1) NOT NULL default '0', `bday` date NOT NULL default '0000-00-00', `icon` varchar(150) NOT NULL default '', `introduce` text NOT NULL, `hits` int(7) NOT NULL default '0', `lastview` int(10) NOT NULL default '0', `oicq` varchar(11) NOT NULL default '', `msn` varchar(50) NOT NULL default '', `homepage` varchar(150) NOT NULL default '', `email` varchar(50) NOT NULL default '', `provinceid` mediumint(6) NOT NULL default '0', `cityid` mediumint(7) NOT NULL default '0', `address` varchar(255) NOT NULL default '', `postalcode` varchar(6) NOT NULL default '', `mobphone` varchar(12) NOT NULL default '', `telephone` varchar(25) NOT NULL default '', `idcard` varchar(20) NOT NULL default '', `truename` varchar(20) NOT NULL default '', `config` text NOT NULL, `moneycard` mediumint(7) unsigned NOT NULL default '0', `email_yz` tinyint(1) NOT NULL default '0', `mob_yz` tinyint(1) NOT NULL default '0', `idcard_yz` tinyint(1) NOT NULL default '0', `rmb` float NOT NULL default '0', `rmb_freeze` float NOT NULL default '0', `rmb_pwd` varchar(32) NOT NULL default '', PRIMARY KEY (`uid`), KEY `groups` (`groups`), KEY `sex` (`sex`,`bday`,`cityid`), KEY `qq_api` (`qq_api`) ) TYPE=MyISAM; DROP TABLE IF EXISTS qb_group; CREATE TABLE `qb_group` ( `gid` smallint(4) NOT NULL auto_increment, `gptype` tinyint(1) NOT NULL default '0', `grouptitle` varchar(50) NOT NULL default '', `levelnum` mediumint(7) NOT NULL default '0', `totalspace` int(10) NOT NULL default '0', `allowsearch` tinyint(1) NOT NULL default '0', `powerdb` text NOT NULL, `allowadmin` tinyint(1) NOT NULL default '0', `allowadmindb` text, PRIMARY KEY (`gid`) ) TYPE=MyISAM; DROP TABLE IF EXISTS qb_menu; CREATE TABLE `qb_menu` ( `id` mediumint(5) NOT NULL auto_increment, `fid` mediumint(5) NOT NULL default '0', `name` varchar(80) NOT NULL default '', `linkurl` varchar(150) NOT NULL default '', `color` varchar(15) NOT NULL default '', `target` tinyint(1) NOT NULL default '0', `moduleid` tinyint(2) NOT NULL default '0', `type` tinyint(2) NOT NULL default '0', `hide` tinyint(1) NOT NULL default '0', `list` smallint(4) NOT NULL default '0', `extend` varchar(30) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM; DROP TABLE IF EXISTS qb_admin_menu; CREATE TABLE `qb_admin_menu` ( `id` mediumint(5) NOT NULL auto_increment, `fid` mediumint(5) NOT NULL default '0', `name` text NOT NULL, `linkurl` varchar(150) NOT NULL default '', `color` varchar(15) NOT NULL default '', `target` tinyint(1) NOT NULL default '0', `list` smallint(4) NOT NULL default '0', `groupid` mediumint(5) NOT NULL default '0', `iftier` tinyint(1) NOT NULL default '0', `ifcompany` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`), KEY `groupid` (`groupid`) ) TYPE=MyISAM; DROP TABLE IF EXISTS qb_module; CREATE TABLE `qb_module` ( `id` mediumint(5) NOT NULL auto_increment, `type` tinyint(1) NOT NULL default '0', `name` varchar(30) NOT NULL default '', `pre` varchar(20) NOT NULL default '', `dirname` varchar(30) NOT NULL default '', `domain` varchar(100) NOT NULL default '', `admindir` varchar(20) NOT NULL default '', `config` text NOT NULL, `list` mediumint(5) NOT NULL default '0', `admingroup` varchar(150) NOT NULL default '', `adminmember` text NOT NULL, `ifclose` tinyint(1) NOT NULL default '0', `ifsys` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM; DROP TABLE IF EXISTS qb_alonepage; CREATE TABLE `qb_alonepage` ( `id` mediumint(5) NOT NULL auto_increment, `fid` mediumint(5) NOT NULL default '0', `name` varchar(100) NOT NULL default '', `title` varchar(100) NOT NULL default '', `posttime` int(10) NOT NULL default '0', `uid` mediumint(7) NOT NULL default '0', `username` varchar(30) NOT NULL default '', `style` varchar(15) NOT NULL default '', `tpl_head` varchar(50) NOT NULL default '', `tpl_main` varchar(50) NOT NULL default '', `tpl_foot` varchar(50) NOT NULL default '', `filename` varchar(100) default NULL, `filepath` varchar(30) NOT NULL default '', `descrip` text NOT NULL, `keywords` varchar(255) NOT NULL default '', `content` text NOT NULL, `hits` int(7) NOT NULL default '0', `ishtml` tinyint(1) NOT NULL default '0', `ifclose` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM; DROP TABLE IF EXISTS qb_config; CREATE TABLE `qb_config` ( `c_key` varchar(50) NOT NULL default '', `c_value` text NOT NULL, `c_descrip` text NOT NULL, PRIMARY KEY (`c_key`) ) TYPE=MyISAM; DROP TABLE IF EXISTS qb_copyfrom; CREATE TABLE `qb_copyfrom` ( `id` mediumint(5) NOT NULL auto_increment, `name` varchar(40) NOT NULL default '', `list` int(10) NOT NULL default '0', `uid` mediumint(7) NOT NULL default '0', PRIMARY KEY (`id`), KEY `keywords` (`name`) ) TYPE=MyISAM; DROP TABLE IF EXISTS qb_hack; CREATE TABLE `qb_hack` ( `keywords` varchar(30) NOT NULL default '', `name` varchar(30) NOT NULL default '', `isclose` tinyint(1) NOT NULL default '0', `author` varchar(30) NOT NULL default '', `config` text NOT NULL, `htmlcode` text NOT NULL, `hackfile` text NOT NULL, `hacksqltable` text NOT NULL, `adminurl` varchar(150) NOT NULL default '', `about` text NOT NULL, `class1` varchar(30) NOT NULL default '', `class2` varchar(30) NOT NULL default '', `list` int(10) NOT NULL default '0', `linkname` text NOT NULL, `isbiz` tinyint(1) NOT NULL default '0', UNIQUE KEY `keywords` (`keywords`) ) TYPE=MyISAM; DROP TABLE IF EXISTS qb_label; CREATE TABLE `qb_label` ( `lid` int(10) NOT NULL auto_increment, `name` varchar(100) NOT NULL default '', `ch` smallint(4) NOT NULL default '0', `chtype` tinyint(2) NOT NULL default '0', `tag` varchar(255) NOT NULL default '', `type` varchar(30) NOT NULL default '', `typesystem` tinyint(1) NOT NULL default '0', `code` text NOT NULL, `divcode` text, `hide` tinyint(1) NOT NULL default '0', `js_time` int(10) NOT NULL default '0', `uid` mediumint(7) NOT NULL default '0', `username` varchar(30) NOT NULL default '', `posttime` int(10) NOT NULL default '0', `pagetype` tinyint(3) NOT NULL default '0', `module` mediumint(6) NOT NULL default '0', `fid` mediumint(7) NOT NULL default '0', `if_js` tinyint(1) NOT NULL default '0', `style` varchar(40) NOT NULL default '', PRIMARY KEY (`lid`), KEY `ch` (`ch`,`pagetype`,`module`,`fid`,`chtype`), KEY `tag` (`tag`) ) TYPE=MyISAM; DROP TABLE IF EXISTS qb_form_config; CREATE TABLE `qb_form_config` ( `c_key` varchar(50) NOT NULL default '', `c_value` text NOT NULL, `c_descrip` text NOT NULL, PRIMARY KEY (`c_key`) ) TYPE=MyISAM; DROP TABLE IF EXISTS qb_form_content; CREATE TABLE `qb_form_content` ( `id` mediumint(7) NOT NULL auto_increment, `title