phpcms.sql

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

  `enddate` date NOT NULL default '0000-00-00',
  `money` float NOT NULL default '0',
  `payment` float unsigned NOT NULL default '0',
  `point` smallint(5) unsigned NOT NULL default '0',
  `credit` smallint(5) unsigned NOT NULL default '0',
  `hits` int(11) unsigned NOT NULL default '0',
  `items` smallint(5) unsigned NOT NULL default '0',
  `newmessages` tinyint(3) unsigned NOT NULL default '0',
  `authstr` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`userid`),
  UNIQUE KEY `username` (`username`),
  KEY `groupid` (`groupid`),
  KEY `email` (`email`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_member_group`;
CREATE TABLE IF NOT EXISTS `phpcms_member_group` (
  `groupid` tinyint(3) unsigned NOT NULL auto_increment,
  `groupname` varchar(50) NOT NULL default '',
  `introduce` varchar(255) NOT NULL default '',
  `grouptype` enum('system','special') NOT NULL default 'special',
  `chargetype` tinyint(1) unsigned NOT NULL default '0',
  `defaultpoint` smallint(5) unsigned NOT NULL default '0',
  `defaultvalidday` smallint(6) NOT NULL default '0',
  `discount` int(3) unsigned NOT NULL default '100',
  `enableaddalways` tinyint(1) unsigned NOT NULL default '0',
  `messagelimit` tinyint(3) unsigned NOT NULL default '20',
  PRIMARY KEY  (`groupid`),
  KEY `grouptype` (`grouptype`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_member_info`;
CREATE TABLE IF NOT EXISTS `phpcms_member_info` (
  `userid` int(11) NOT NULL default '0',
  `userface` varchar(255) NOT NULL default '',
  `facewidth` char(3) NOT NULL default '',
  `faceheight` char(3) NOT NULL default '',
  `sign` text NOT NULL,
  `truename` varchar(50) NOT NULL default '',
  `gender` tinyint(1) NOT NULL default '0',
  `birthday` date NOT NULL default '0000-00-00',
  `idtype` varchar(20) NOT NULL default '',
  `idcard` varchar(50) NOT NULL default '',
  `province` varchar(30) NOT NULL default '',
  `city` varchar(30) NOT NULL default '',
  `area` varchar(30) NOT NULL default '',
  `industry` varchar(50) NOT NULL default '',
  `edulevel` varchar(20) NOT NULL default '',
  `occupation` varchar(20) NOT NULL default '',
  `income` varchar(50) NOT NULL default '',
  `telephone` varchar(50) NOT NULL default '',
  `mobile` varchar(15) NOT NULL default '',
  `address` varchar(255) NOT NULL default '',
  `postid` varchar(6) NOT NULL default '',
  `homepage` varchar(255) NOT NULL default '',
  `qq` varchar(20) NOT NULL default '',
  `msn` varchar(50) NOT NULL default '',
  `icq` varchar(20) NOT NULL default '',
  `skype` varchar(50) NOT NULL default '',
  `alipay` varchar(50) NOT NULL default '',
  `paypal` varchar(50) NOT NULL default '',
  `note` text NOT NULL,
  `my_mobile` varchar(255) NOT NULL default '',
  `my_special` text NOT NULL,
  PRIMARY KEY  (`userid`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_menu`;
CREATE TABLE IF NOT EXISTS `phpcms_menu` (
  `menuid` smallint(5) unsigned NOT NULL auto_increment,
  `position` varchar(20) NOT NULL default '',
  `name` varchar(50) NOT NULL default '',
  `title` varchar(100) NOT NULL default '',
  `url` varchar(200) NOT NULL default '',
  `target` varchar(20) NOT NULL default '',
  `style` varchar(50) NOT NULL default '',
  `listorder` smallint(5) unsigned NOT NULL default '0',
  `arrgroupid` varchar(255) NOT NULL default '',
  `arrgrade` varchar(255) NOT NULL default '',
  `username` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`menuid`),
  KEY `position` (`position`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_module`;
CREATE TABLE IF NOT EXISTS `phpcms_module` (
  `moduleid` int(11) NOT NULL auto_increment,
  `name` varchar(20) NOT NULL default '',
  `module` varchar(20) NOT NULL default '',
  `moduledir` varchar(20) NOT NULL default '',
  `moduledomain` varchar(50) NOT NULL default '',
  `iscore` tinyint(1) NOT NULL default '0',
  `iscopy` tinyint(1) NOT NULL default '0',
  `isshare` tinyint(1) NOT NULL default '0',
  `version` varchar(50) NOT NULL default '',
  `author` varchar(50) NOT NULL default '',
  `site` varchar(100) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `introduce` text NOT NULL,
  `license` text NOT NULL,
  `faq` mediumtext NOT NULL,
  `setting` text NOT NULL,
  `disabled` tinyint(1) NOT NULL default '0',
  `publishdate` date NOT NULL default '0000-00-00',
  `installdate` date NOT NULL default '0000-00-00',
  `updatedate` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`moduleid`),
  UNIQUE KEY `module_2` (`module`),
  KEY `module` (`module`,`iscopy`,`isshare`,`disabled`,`publishdate`,`installdate`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_mytag`;
CREATE TABLE IF NOT EXISTS `phpcms_mytag` (
  `tagid` int(10) unsigned NOT NULL auto_increment,
  `tagname` varchar(50) NOT NULL default '',
  `content` text NOT NULL,
  `introduce` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`tagid`),
  UNIQUE KEY `tagname` (`tagname`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_position`;
CREATE TABLE IF NOT EXISTS `phpcms_position` (
  `posid` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  `keyid` varchar(20) NOT NULL default '',
  `listorder` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`posid`)
) TYPE=MyISAM;

INSERT INTO `phpcms_position` VALUES (1, '网站首页推荐', '', 1);
INSERT INTO `phpcms_position` VALUES (2, '频道首页焦点', '', 2);
INSERT INTO `phpcms_position` VALUES (3, '频道首页推荐', '', 3);

DROP TABLE IF EXISTS `phpcms_province`;
CREATE TABLE IF NOT EXISTS `phpcms_province` (
  `provinceid` int(11) NOT NULL auto_increment,
  `province` varchar(20) NOT NULL default '',
  KEY `provinceid` (`provinceid`)
) TYPE=MyISAM;

INSERT INTO `phpcms_province` (`provinceid`, `province`) VALUES (1, '北京市');
INSERT INTO `phpcms_province` (`provinceid`, `province`) VALUES (2, '上海市');
INSERT INTO `phpcms_province` (`provinceid`, `province`) VALUES (3, '天津市');
INSERT INTO `phpcms_province` (`provinceid`, `province`) VALUES (4, '重庆市');
INSERT INTO `phpcms_province` (`provinceid`, `province`) VALUES (5, '河北省');
INSERT INTO `phpcms_province` (`provinceid`, `province`) VALUES (6, '山西省');
INSERT INTO `phpcms_province` (`provinceid`, `province`) VALUES (7, '内蒙古自治区');
INSERT INTO `phpcms_province` (`provinceid`, `province`) VALUES (8, '辽宁省');
INSERT INTO `phpcms_province` (`provinceid`, `province`) VALUES (9, '吉林省');
INSERT INTO `phpcms_province` (`provinceid`, `province`) VALUES (10, '黑龙江省');
INSERT INTO `phpcms_province` (`provinceid`, `province`) VALUES (11, '江苏省');
INSERT INTO `phpcms_province` (`provinceid`, `province`) VALUES (12, '浙江省');
INSERT INTO `phpcms_province` (`provinceid`, `province`) VALUES (13, '安徽省');
INSERT INTO `phpcms_province` (`provinceid`, `province`) VALUES (14, '福建省');
INSERT INTO `phpcms_province` (`provinceid`, `province`) VALUES (15, '江西省');
INSERT INTO `phpcms_province` (`provinceid`, `province`) VALUES (16, '山东省');
INSERT INTO `phpcms_province` (`provinceid`, `province`) VALUES (17, '河南省');
INSERT INTO `phpcms_province` (`provinceid`, `province`) VALUES (18, '湖北省');
INSERT INTO `phpcms_province` (`provinceid`, `province`) VALUES (19, '湖南省');
INSERT INTO `phpcms_province` (`provinceid`, `province`) VALUES (20, '广东省');
INSERT INTO `phpcms_province` (`provinceid`, `province`) VALUES (21, '广西壮族自治区');
INSERT INTO `phpcms_province` (`provinceid`, `province`) VALUES (22, '海南省');
INSERT INTO `phpcms_province` (`provinceid`, `province`) VALUES (23, '四川省');
INSERT INTO `phpcms_province` (`provinceid`, `province`) VALUES (24, '贵州省');
INSERT INTO `phpcms_province` (`provinceid`, `province`) VALUES (25, '云南省');
INSERT INTO `phpcms_province` (`provinceid`, `province`) VALUES (26, '西藏自治区');
INSERT INTO `phpcms_province` (`provinceid`, `province`) VALUES (27, '陕西省');
INSERT INTO `phpcms_province` (`provinceid`, `province`) VALUES (28, '甘肃省');
INSERT INTO `phpcms_province` (`provinceid`, `province`) VALUES (29, '青海省');
INSERT INTO `phpcms_province` (`provinceid`, `province`) VALUES (30, '宁夏回族自治区');
INSERT INTO `phpcms_province` (`provinceid`, `province`) VALUES (31, '新疆维吾尔自治区');
INSERT INTO `phpcms_province` (`provinceid`, `province`) VALUES (32, '台湾省');
INSERT INTO `phpcms_province` (`provinceid`, `province`) VALUES (33, '香港特别行政区');
INSERT INTO `phpcms_province` (`provinceid`, `province`) VALUES (34, '澳门特别行政区');

DROP TABLE IF EXISTS `phpcms_reword`;
CREATE TABLE IF NOT EXISTS `phpcms_reword` (
  `rid` int(11) NOT NULL auto_increment,
  `word` varchar(255) NOT NULL default '',
  `replacement` varchar(255) NOT NULL default '',
  `passed` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`rid`),
  KEY `word` (`word`,`passed`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_special`;
CREATE TABLE IF NOT EXISTS `phpcms_special` (
  `specialid` smallint(5) unsigned NOT NULL auto_increment,
  `parentid` smallint(5) unsigned NOT NULL default '0',
  `arrchildid` varchar(50) NOT NULL default '',
  `keyid` varchar(20) NOT NULL default '',
  `specialname` varchar(100) NOT NULL default '',
  `style` varchar(50) NOT NULL default '',
  `specialpic` varchar(255) NOT NULL default '',
  `specialbanner` varchar(255) NOT NULL default '',
  `prefix` varchar(50) 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,
  `templateid` varchar(20) NOT NULL default '0',
  `skinid` varchar(20) NOT NULL default '',
  `elite` tinyint(1) NOT NULL default '0',
  `listorder` smallint(4) unsigned NOT NULL default '9999',
  `addtime` int(10) unsigned NOT NULL default '0',
  `items` smallint(5) unsigned NOT NULL default '0',
  `hits` int(10) unsigned NOT NULL default '0',
  `closed` tinyint(1) NOT NULL default '0',
  `linkurl` varchar(255) NOT NULL default '',
  `disabled` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`specialid`),
  KEY `channelid` (`keyid`,`disabled`,`listorder`,`specialid`),
  KEY `module` (`disabled`,`listorder`,`specialid`),
  KEY `parentid` (`disabled`,`listorder`,`specialid`),
  KEY `elite` (`elite`,`disabled`,`listorder`,`specialid`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_type`;
CREATE TABLE IF NOT EXISTS `phpcms_type` (
  `typeid` smallint(5) unsigned NOT NULL auto_increment,
  `keyid` varchar(30) NOT NULL default '',
  `name` varchar(50) NOT NULL default '',
  `style` varchar(50) NOT NULL default '',
  `introduce` varchar(255) NOT NULL default '',
  `type` varchar(20) NOT NULL default '',
  `listorder` smallint(5) unsigned NOT NULL default '0',
  `items` int(11) NOT NULL default '0',
  `disabled` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`typeid`)
) TYPE=MyISAM;

INSERT INTO `phpcms_menu` (`menuid`, `position`, `name`, `title`, `url`, `target`, `style`, `listorder`, `arrgroupid`, `arrgrade`, `username`) VALUES (7, 'admin_top', '使用帮助', '', 'http://help.phpcms.cn/faq.php?action=user_admin', 'left', '', 6, '1', '', '');
INSERT INTO `phpcms_menu` (`menuid`, `position`, `name`, `title`, `url`, `target`, `style`, `listorder`, `arrgroupid`, `arrgrade`, `username`) VALUES (6, 'admin_top', '模板风格', '', '?mod=phpcms&file=index&action=template', 'left', '', 5, '', '0', '');
INSERT INTO `phpcms_menu` (`menuid`, `position`, `name`, `title`, `url`, `target`, `style`, `listorder`, `arrgroupid`, `arrgrade`, `username`) VALUES (5, 'admin_top', '功能模块', '', '?mod=phpcms&file=index&action=module', 'left', '', 3, '', '0', '');
INSERT INTO `phpcms_menu` (`menuid`, `position`, `name`, `title`, `url`, `target`, `style`, `listorder`, `arrgroupid`, `arrgrade`, `username`) VALUES (4, 'admin_top', '会员管理', '', '?mod=member&file=left', 'left', '', 4, '1', '0', '');
INSERT INTO `phpcms_menu` (`menuid`, `position`, `name`, `title`, `url`, `target`, `style`, `listorder`, `arrgroupid`, `arrgrade`, `username`) VALUES (3, 'admin_top', '网站频道', '', '?mod=phpcms&file=index&action=channel', 'left', '', 2, '', '0', '');
INSERT INTO `phpcms_menu` (`menuid`, `position`, `name`, `title`, `url`, `target`, `style`, `listorder`, `arrgroupid`, `arrgrade`, `username`) VALUES (2, 'admin_top', '系统设置', '', '?mod=phpcms&file=index&action=left', 'left', '', 1, '1', '0', '');
INSERT INTO `phpcms_menu` (`menuid`, `position`, `name`, `title`, `url`, `target`, `style`, `listorder`, `arrgroupid`, `arrgrade`, `username`) VALUES (1,'admin_top', '我的面板', '', '?mod=phpcms&file=index&action=mymenu', 'left', '', 0, '1', '', 'phpcms');

INSERT INTO `phpcms_module` (`moduleid`, `name`, `module`, `moduledir`, `moduledomain`, `iscore`, `iscopy`, `isshare`, `version`, `author`, `site`, `email`, `introduce`, `license`, `faq`, `setting`, `disabled`, `publishdate`, `installdate`, `updatedate`) VALUES (1, 'phpcms', 'phpcms', '', '', 1, 0, 0, '1.0.0', 'phpcms团队', 'http://www.phpcms.cn/', '[e-mail]', 'PHPCMS(PHP CMS)网站管理系统是一个基于PHP+MYSQL的全站生成html的建站系统，经过完善设计并适用于各种服务器环境(如UNIX、LINUX、WINDOWS等)的高效、全新、快速、优秀的网站解决方案，包括文章、下载、图片和信息四大功能模块，支持内容收费、广告管理和论坛整合，适合政府、学校、企业以及其他各种资讯类网站使用……', '', '帮助内容', '', 0, '0000-00-00', '0000-00-00', '0000-00-00');

DROP TABLE IF EXISTS `phpcms_sessions`;
CREATE TABLE `phpcms_sessions` (
  `sessionid` varchar(32) NOT NULL default '',
  `data` mediumtext NOT NULL,
  `lastvisit` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`sessionid`)
) TYPE=MyISAM;