phpcms_speed.sql

Phpcms2008 是一款基于 PHP+Mysql 架构的网站内容管理系统

  `content` mediumtext NOT NULL,
  `version` varchar(20) NOT NULL default '',
  `classtype` varchar(20) NOT NULL default '国产软件',
  `language` varchar(20) NOT NULL default '简体中文',
  `copytype` varchar(15) NOT NULL default '免费版',
  `systems` varchar(100) NOT NULL default 'Win2000/WinXP/Win2003',
  `stars` varchar(20) NOT NULL default '★★★☆☆',
  `filesize` varchar(20) NOT NULL default '未知',
  `downurl` varchar(255) NOT NULL default '',
  `downurls` text NOT NULL,
  `groupids_view` tinyint(1) unsigned NOT NULL default '0',
  `readpoint` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`contentid`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_c_info`;
CREATE TABLE `phpcms_c_info` (
  `contentid` mediumint(8) unsigned NOT NULL,
  `template` char(30) NOT NULL,
  `content` mediumtext NOT NULL,
  `endtime` date NOT NULL default '0000-00-00',
  `telephone` varchar(100) NOT NULL default '',
  `email` varchar(40) NOT NULL default '',
  `address` varchar(255) NOT NULL default '',
  `groupids_view` tinyint(1) unsigned NOT NULL default '0',
  `readpoint` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`contentid`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_c_news`;
CREATE TABLE `phpcms_c_news` (
  `contentid` mediumint(8) unsigned NOT NULL,
  `template` varchar(30) NOT NULL default '',
  `titleintact` varchar(200) NOT NULL default '',
  `content` mediumtext NOT NULL,
  `groupids_view` tinyint(1) unsigned NOT NULL default '0',
  `readpoint` smallint(5) unsigned NOT NULL default '0',
  `author` varchar(30) NOT NULL default '',
  `copyfrom` varchar(100) NOT NULL,
  PRIMARY KEY  (`contentid`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_c_picture`;
CREATE TABLE `phpcms_c_picture` (
  `contentid` mediumint(8) unsigned NOT NULL,
  `template` char(30) NOT NULL,
  `content` mediumtext NOT NULL,
  `pictureurls` tinyint(1) unsigned NOT NULL default '0',
  `author` varchar(30) NOT NULL default '',
  `copyfrom` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`contentid`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_c_product`;
CREATE TABLE `phpcms_c_product` (
  `contentid` mediumint(8) unsigned NOT NULL,
  `template` varchar(255) NOT NULL default '',
  `content` mediumtext NOT NULL,
  `price` float unsigned NOT NULL default '0',
  `size` varchar(50) NOT NULL default '',
  `pictureurls` tinyint(1) unsigned NOT NULL default '0',
  `unit` varchar(4) NOT NULL default '个',
  `stock` varchar(20) NOT NULL default '',
  `stars` varchar(20) NOT NULL default '★★★☆☆',
  PRIMARY KEY  (`contentid`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_cache_count`;
CREATE TABLE `phpcms_cache_count` (
  `id` char(32) NOT NULL default '',
  `count` mediumint(8) unsigned NOT NULL default '0',
  `updatetime` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MEMORY;

DROP TABLE IF EXISTS `phpcms_category`;
CREATE TABLE `phpcms_category` (
  `catid` smallint(5) unsigned NOT NULL auto_increment,
  `module` varchar(15) NOT NULL,
  `type` tinyint(1) unsigned NOT NULL default '0',
  `modelid` tinyint(3) 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,
  `content` mediumtext 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',
  PRIMARY KEY  (`catid`),
  KEY `module` (`module`,`parentid`,`listorder`,`catid`)
) TYPE=MyISAM;

INSERT INTO `phpcms_category` (`catid`, `module`, `type`, `modelid`, `parentid`, `arrparentid`, `child`, `arrchildid`, `catname`, `style`, `image`, `description`, `parentdir`, `catdir`, `url`, `content`, `items`, `hits`, `setting`, `listorder`, `ismenu`) VALUES (1, 'phpcms', 1, 0, 0, '0', 1, '1,2,3,4,5', '网站介绍', '', '', '', '', 'about', 'about/index.html', '网站介绍', 0, 0, 'array (\n  ''template'' => ''page'',\n  ''ishtml'' => ''1'',\n  ''category_urlruleid'' => ''1'',\n  ''meta_title'' => '''',\n  ''meta_keywords'' => '''',\n  ''meta_description'' => '''',\n)', 1, 0);
INSERT INTO `phpcms_category` (`catid`, `module`, `type`, `modelid`, `parentid`, `arrparentid`, `child`, `arrchildid`, `catname`, `style`, `image`, `description`, `parentdir`, `catdir`, `url`, `content`, `items`, `hits`, `setting`, `listorder`, `ismenu`) VALUES (2, 'phpcms', 1, 0, 1, '0,1', 0, '2', '关于我们', '', '', '', 'about/', 'aboutus', 'about/aboutus/index.html', '关于我们', 0, 0, 'array (\n  ''template'' => ''page'',\n  ''ishtml'' => ''1'',\n  ''category_urlruleid'' => ''1'',\n  ''meta_title'' => ''关于我们'',\n  ''meta_keywords'' => ''关于我们'',\n  ''meta_description'' => ''关于我们'',\n)', 2, 0);
INSERT INTO `phpcms_category` (`catid`, `module`, `type`, `modelid`, `parentid`, `arrparentid`, `child`, `arrchildid`, `catname`, `style`, `image`, `description`, `parentdir`, `catdir`, `url`, `content`, `items`, `hits`, `setting`, `listorder`, `ismenu`) VALUES (3, 'phpcms', 1, 0, 1, '0,1', 0, '3', '联系方式', '', '', '', 'about/', 'contactus', 'about/contactus/index.html', '联系方式', 0, 0, 'array (\n  ''template'' => ''page'',\n  ''ishtml'' => ''1'',\n  ''category_urlruleid'' => ''1'',\n  ''meta_title'' => ''联系方式'',\n  ''meta_keywords'' => ''联系方式'',\n  ''meta_description'' => ''联系方式'',\n)', 3, 0);
INSERT INTO `phpcms_category` (`catid`, `module`, `type`, `modelid`, `parentid`, `arrparentid`, `child`, `arrchildid`, `catname`, `style`, `image`, `description`, `parentdir`, `catdir`, `url`, `content`, `items`, `hits`, `setting`, `listorder`, `ismenu`) VALUES (4, 'phpcms', 1, 0, 1, '0,1', 0, '4', '招聘信息', '', '', '', 'about/', 'joinus', 'about/joinus/index.html', '招聘信息', 0, 0, 'array (\n  ''template'' => ''page'',\n  ''ishtml'' => ''1'',\n  ''category_urlruleid'' => ''1'',\n  ''meta_title'' => ''招聘信息'',\n  ''meta_keywords'' => ''招聘信息'',\n  ''meta_description'' => ''招聘信息'',\n)', 4, 0);
INSERT INTO `phpcms_category` (`catid`, `module`, `type`, `modelid`, `parentid`, `arrparentid`, `child`, `arrchildid`, `catname`, `style`, `image`, `description`, `parentdir`, `catdir`, `url`, `content`, `items`, `hits`, `setting`, `listorder`, `ismenu`) VALUES (5, 'phpcms', 1, 0, 1, '0,1', 0, '5', '版权声明', '', '', '', 'about/', 'copyright', 'about/copyright/index.html', '版权声明', 0, 0, 'array (\n  ''template'' => ''page'',\n  ''ishtml'' => ''1'',\n  ''category_urlruleid'' => ''1'',\n  ''meta_title'' => ''版权声明'',\n  ''meta_keywords'' => ''版权声明'',\n  ''meta_description'' => ''版权声明'',\n)', 5, 0);
INSERT INTO `phpcms_category` (`catid`, `module`, `type`, `modelid`, `parentid`, `arrparentid`, `child`, `arrchildid`, `catname`, `style`, `image`, `description`, `parentdir`, `catdir`, `url`, `content`, `items`, `hits`, `setting`, `listorder`, `ismenu`) VALUES (7, 'phpcms', 2, 0, 0, '0', 0, '7', '专题', '', '', '', '', '', 'special/', '', 0, 0, '', 501, 1);
INSERT INTO `phpcms_category` (`catid`, `module`, `type`, `modelid`, `parentid`, `arrparentid`, `child`, `arrchildid`, `catname`, `style`, `image`, `description`, `parentdir`, `catdir`, `url`, `content`, `items`, `hits`, `setting`, `listorder`, `ismenu`) VALUES (9, 'phpcms', 2, 0, 0, '0', 0, '9', '问吧', '', '', '', '', '', 'ask/', '', 0, 0, '', 502, 1);
INSERT INTO `phpcms_category` (`catid`, `module`, `type`, `modelid`, `parentid`, `arrparentid`, `child`, `arrchildid`, `catname`, `style`, `image`, `description`, `parentdir`, `catdir`, `url`, `content`, `items`, `hits`, `setting`, `listorder`, `ismenu`) VALUES (8, 'phpcms', 2, 0, 0, '0', 0, '8', '搜索', '', '', '', '', '', 'search/', '', 0, 0, '', 503, 1);
INSERT INTO `phpcms_category` (`catid`, `module`, `type`, `modelid`, `parentid`, `arrparentid`, `child`, `arrchildid`, `catname`, `style`, `image`, `description`, `parentdir`, `catdir`, `url`, `content`, `items`, `hits`, `setting`, `listorder`, `ismenu`) VALUES (6, 'phpcms', 2, 0, 0, '0', 0, '6', '会员', '', '', '', '', '', 'member/list.php?modelid=10', '', 0, 0, '', 504, 1);
INSERT INTO `phpcms_category` (`catid`, `module`, `type`, `modelid`, `parentid`, `arrparentid`, `child`, `arrchildid`, `catname`, `style`, `image`, `description`, `parentdir`, `catdir`, `url`, `content`, `items`, `hits`, `setting`, `listorder`, `ismenu`) VALUES (10, 'phpcms', 2, 0, 0, '0', 0, '10', '论坛', '', '', '', '', '', 'http://bbs.phpcms.cn', '', 0, 0, '', 505, 1);

DROP TABLE IF EXISTS `phpcms_content`;
CREATE TABLE `phpcms_content` (
  `contentid` mediumint(8) unsigned NOT NULL auto_increment,
  `catid` smallint(5) unsigned NOT NULL default '0',