phpcms.sql

phpcms2007很好的cms内容管理系统,操作方便

DROP TABLE IF EXISTS `phpcms_admin`;
CREATE TABLE IF NOT EXISTS `phpcms_admin` (
  `userid` int(11) unsigned NOT NULL default '0',
  `username` varchar(30) NOT NULL default '',
  `grade` tinyint(2) unsigned NOT NULL default '0',
  `purviewids` text NOT NULL,
  `modules` text NOT NULL,
  `channelids` text NOT NULL,
  `catids` text NOT NULL,
  `specialids` text NOT NULL,
  `disabled` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`userid`),
  KEY `grade` (`grade`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_attachment`;
CREATE TABLE IF NOT EXISTS `phpcms_attachment` (
  `aid` int(11) unsigned NOT NULL auto_increment,
  `username` varchar(20) NOT NULL default '',
  `keyid` varchar(20) NOT NULL default '',
  `catid` smallint(5) unsigned NOT NULL default '0',
  `itemid` int(11) unsigned NOT NULL default '0',
  `fileurl` varchar(255) NOT NULL default '',
  `filetype` varchar(10) NOT NULL default '',
  `filesize` int(11) unsigned NOT NULL default '0',
  `addtime` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`aid`),
  KEY `username` (`username`),
  KEY `itemid` (`itemid`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_author`;
CREATE TABLE IF NOT EXISTS `phpcms_author` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `keyid` varchar(30) NOT NULL default '',
  `name` varchar(100) NOT NULL default '',
  `note` varchar(255) NOT NULL default '',
  `items` int(10) unsigned NOT NULL default '0',
  `updatetime` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `channelid` (`keyid`,`updatetime`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_banip`;
CREATE TABLE IF NOT EXISTS `phpcms_banip` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `ip` varchar(15) NOT NULL default '',
  `ifban` tinyint(1) NOT NULL default '0',
  `username` varchar(30) NOT NULL default '',
  `overtime` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `ifban` (`ifban`),
  KEY `username` (`username`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_category`;
CREATE TABLE IF NOT EXISTS `phpcms_category` (
  `catid` smallint(6) unsigned NOT NULL auto_increment,
  `module` varchar(20) NOT NULL default '',
  `channelid` tinyint(3) unsigned NOT NULL default '0',
  `catname` varchar(50) NOT NULL default '',
  `catpic` varchar(255) NOT NULL default '',
  `style` varchar(50) NOT NULL default '',
  `introduce` text NOT NULL,
  `islink` tinyint(1) unsigned NOT NULL default '0',
  `catdir` varchar(20) NOT NULL default '',
  `parentid` smallint(6) unsigned NOT NULL default '0',
  `arrparentid` varchar(255) NOT NULL default '',
  `parentdir` varchar(255) NOT NULL default '',
  `child` tinyint(1) NOT NULL default '0',
  `arrchildid` text NOT NULL,
  `itemtarget` tinyint(3) unsigned NOT NULL default '0',
  `itemordertype` tinyint(3) unsigned NOT NULL default '0',
  `listorder` smallint(6) unsigned NOT NULL default '0',
  `ismenu` tinyint(1) NOT NULL default '0',
  `islist` tinyint(1) NOT NULL default '0',
  `ishtml` tinyint(1) unsigned NOT NULL default '0',
  `htmldir` varchar(20) NOT NULL default '',
  `prefix` varchar(20) NOT NULL default '',
  `urlruleid` tinyint(1) unsigned NOT NULL default '0',
  `item_htmldir` varchar(20) NOT NULL default '',
  `item_prefix` varchar(20) NOT NULL default '',
  `item_html_urlruleid` tinyint(1) NOT NULL default '0',
  `item_php_urlruleid` tinyint(1) NOT NULL default '0',
  `linkurl` varchar(255) NOT NULL default '',
  `setting` text NOT NULL,
  `items` int(11) unsigned NOT NULL default '0',
  `hits` int(11) unsigned NOT NULL default '0',
  `disabled` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`catid`),
  KEY `module` (`module`,`disabled`),
  KEY `channelid` (`channelid`,`disabled`),
  KEY `ismenu` (`ismenu`),
  KEY `islist` (`islist`),
  KEY `listorder` (`listorder`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_channel`;
CREATE TABLE IF NOT EXISTS `phpcms_channel` (
  `channelid` tinyint(3) unsigned NOT NULL auto_increment,
  `module` varchar(20) NOT NULL default '',
  `channelname` varchar(20) NOT NULL default '',
  `style` varchar(50) NOT NULL default '',
  `channelpic` varchar(255) NOT NULL default '',
  `introduce` text NOT NULL,
  `seo_title` varchar(50) NOT NULL default '',
  `seo_keywords` varchar(255) NOT NULL default '',
  `seo_description` text NOT NULL,
  `listorder` tinyint(3) unsigned NOT NULL default '0',
  `islink` tinyint(1) unsigned NOT NULL default '0',
  `channeldir` varchar(30) NOT NULL default '',
  `channeldomain` varchar(50) NOT NULL default '',
  `disabled` tinyint(1) NOT NULL default '0',
  `templateid` varchar(20) NOT NULL default '0',
  `skinid` varchar(20) NOT NULL default '',
  `items` int(11) unsigned NOT NULL default '0',
  `comments` int(11) unsigned NOT NULL default '0',
  `categorys` smallint(6) unsigned NOT NULL default '0',
  `specials` smallint(6) unsigned NOT NULL default '0',
  `hits` int(11) unsigned NOT NULL default '0',
  `enablepurview` tinyint(1) NOT NULL default '0',
  `arrgroupid_browse` text NOT NULL,
  `purview_message` text NOT NULL,
  `point_message` text NOT NULL,
  `enablecontribute` tinyint(1) NOT NULL default '0',
  `enablecheck` tinyint(1) NOT NULL default '0',
  `emailofreject` text NOT NULL,
  `emailofpassed` text NOT NULL,
  `enableupload` tinyint(1) NOT NULL default '0',
  `uploaddir` varchar(50) NOT NULL default '',
  `maxfilesize` int(11) unsigned NOT NULL default '0',
  `uploadfiletype` varchar(255) NOT NULL default '',
  `linkurl` varchar(255) NOT NULL default '',
  `setting` text NOT NULL,
  `ishtml` tinyint(1) unsigned NOT NULL default '0',
  `cat_html_urlruleid` tinyint(1) NOT NULL default '0',
  `item_html_urlruleid` tinyint(1) NOT NULL default '0',
  `special_html_urlruleid` tinyint(1) NOT NULL default '0',
  `cat_php_urlruleid` tinyint(1) NOT NULL default '0',
  `item_php_urlruleid` tinyint(1) NOT NULL default '0',
  `special_php_urlruleid` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`channelid`),
  KEY `module` (`module`),
  KEY `disabled` (`disabled`),
  KEY `listorder` (`listorder`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_city`;
CREATE TABLE IF NOT EXISTS `phpcms_city` (
  `cityid` int(11) NOT NULL auto_increment,
  `province` varchar(20) NOT NULL default '',
  `city` varchar(50) NOT NULL default '',
  `area` varchar(50) NOT NULL default '',
  `postcode` varchar(10) NOT NULL default '',
  `areacode` varchar(5) NOT NULL default '',
  PRIMARY KEY  (`cityid`),
  KEY `province` (`province`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_copyfrom`;
CREATE TABLE IF NOT EXISTS `phpcms_copyfrom` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `keyid` varchar(30) NOT NULL default '',
  `name` varchar(100) NOT NULL default '',
  `url` varchar(255) NOT NULL default '',
  `hits` int(10) unsigned NOT NULL default '0',
  `updatetime` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `channelid` (`keyid`,`updatetime`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_field`;
CREATE TABLE IF NOT EXISTS `phpcms_field` (
  `fieldid` int(11) NOT NULL auto_increment,
  `tablename` varchar(25) NOT NULL default '',
  `name` varchar(50) NOT NULL default '',
  `size` int(10) unsigned NOT NULL default '0',
  `title` varchar(100) NOT NULL default '',
  `note` text NOT NULL,
  `type` varchar(20) NOT NULL default '',
  `defaultvalue` text NOT NULL,
  `options` text NOT NULL,
  `formtype` varchar(20) NOT NULL default '',
  `inputtool` varchar(20) NOT NULL default '',
  `inputlimit` varchar(20) NOT NULL default '',
  `listorder` smallint(5) unsigned NOT NULL default '0',
  `enablehtml` tinyint(1) unsigned NOT NULL default '0',
  `enablelist` tinyint(1) unsigned NOT NULL default '0',
  `enablesearch` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`fieldid`),
  KEY `tablename` (`tablename`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_keylink`;
CREATE TABLE IF NOT EXISTS `phpcms_keylink` (
  `linkid` int(11) NOT NULL auto_increment,
  `linktext` varchar(255) NOT NULL default '',
  `linkurl` varchar(255) NOT NULL default '',
  `passed` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`linkid`),
  KEY `linktext` (`linktext`,`passed`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_keywords`;
CREATE TABLE IF NOT EXISTS `phpcms_keywords` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `keyid` varchar(30) NOT NULL default '',
  `keywords` varchar(100) NOT NULL default '',
  `hits` int(10) unsigned NOT NULL default '0',
  `updatetime` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `channelid` (`keyid`,`updatetime`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_log`;
CREATE TABLE IF NOT EXISTS `phpcms_log` (
  `logid` int(11) NOT NULL auto_increment,
  `mod` varchar(20) NOT NULL default '',
  `file` varchar(20) NOT NULL default '',
  `action` varchar(20) NOT NULL default '',
  `channelid` int(11) NOT NULL default '0',
  `querystring` text NOT NULL,
  `username` varchar(30) NOT NULL default '',
  `addtime` int(11) NOT NULL default '0',
  `ip` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`logid`),
  KEY `mod` (`mod`,`file`,`action`,`username`),
  KEY `addtime` (`addtime`),
  KEY `ip` (`ip`),
  KEY `channelid` (`channelid`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_member`;
CREATE TABLE IF NOT EXISTS `phpcms_member` (
  `userid` int(11) unsigned NOT NULL auto_increment,
  `username` varchar(20) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  `question` varchar(50) NOT NULL default '',
  `answer` varchar(32) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `showemail` tinyint(1) NOT NULL default '0',
  `groupid` smallint(5) unsigned NOT NULL default '0',
  `arrgroupid` varchar(100) NOT NULL default '',
  `regip` varchar(15) NOT NULL default '',
  `regtime` int(11) unsigned NOT NULL default '0',
  `lastloginip` varchar(15) NOT NULL default '',
  `lastlogintime` int(11) unsigned NOT NULL default '0',
  `logintimes` smallint(5) unsigned NOT NULL default '0',
  `chargetype` tinyint(1) NOT NULL default '0',
  `begindate` date NOT NULL default '0000-00-00',