mysql.sql

在综合英文版XOOPS 2.09, 2.091, 2.092 的基础上正式发布XOOPS 2.09中文版 XOOPS 2.09x 版主要是PHP5升级、bug修正和安全补正： 1 全面兼容PHP 5.

  UNIQUE KEY `option_id` (`option_id`,`optionvalue`(255)),
  KEY `option_id_2` (`option_id`,`optionvalue_seq`)
);

#
# Table Dump data wp_optionvalues
#

INSERT INTO wp_optionvalues (`option_id`, `optionvalue`, `optionvalue_desc`, `optionvalue_max`, `optionvalue_min`, `optionvalue_seq`) VALUES (49, 'days', '天数', NULL, NULL, 1);
INSERT INTO wp_optionvalues (`option_id`, `optionvalue`, `optionvalue_desc`, `optionvalue_max`, `optionvalue_min`, `optionvalue_seq`) VALUES (49, 'posts', '文章数', NULL, NULL, 2);
INSERT INTO wp_optionvalues (`option_id`, `optionvalue`, `optionvalue_desc`, `optionvalue_max`, `optionvalue_min`, `optionvalue_seq`) VALUES (49, 'paged', '页数', NULL, NULL, 3);
INSERT INTO wp_optionvalues (`option_id`, `optionvalue`, `optionvalue_desc`, `optionvalue_max`, `optionvalue_min`, `optionvalue_seq`) VALUES (50, 'daily', '每天', NULL, NULL, 1);
INSERT INTO wp_optionvalues (`option_id`, `optionvalue`, `optionvalue_desc`, `optionvalue_max`, `optionvalue_min`, `optionvalue_seq`) VALUES (50, 'weekly', '每周', NULL, NULL, 2);
INSERT INTO wp_optionvalues (`option_id`, `optionvalue`, `optionvalue_desc`, `optionvalue_max`, `optionvalue_min`, `optionvalue_seq`) VALUES (50, 'monthly', '每月', NULL, NULL, 3);
INSERT INTO wp_optionvalues (`option_id`, `optionvalue`, `optionvalue_desc`, `optionvalue_max`, `optionvalue_min`, `optionvalue_seq`) VALUES (50, 'postbypost', '每篇日志', NULL, NULL, 4);
INSERT INTO wp_optionvalues (`option_id`, `optionvalue`, `optionvalue_desc`, `optionvalue_max`, `optionvalue_min`, `optionvalue_seq`) VALUES (51, 'hours', '小时', 23, -23, NULL);
INSERT INTO wp_optionvalues (`option_id`, `optionvalue`, `optionvalue_desc`, `optionvalue_max`, `optionvalue_min`, `optionvalue_seq`) VALUES (9, '0', '星期天', NULL, NULL, 1);
INSERT INTO wp_optionvalues (`option_id`, `optionvalue`, `optionvalue_desc`, `optionvalue_max`, `optionvalue_min`, `optionvalue_seq`) VALUES (9, '1', '星期一', NULL, NULL, 2);
INSERT INTO wp_optionvalues (`option_id`, `optionvalue`, `optionvalue_desc`, `optionvalue_max`, `optionvalue_min`, `optionvalue_seq`) VALUES (9, '6', '星期六', NULL, NULL, 3);
INSERT INTO wp_optionvalues (`option_id`, `optionvalue`, `optionvalue_desc`, `optionvalue_max`, `optionvalue_min`, `optionvalue_seq`) VALUES (55, 'publish', '发表', NULL, NULL, 1);
INSERT INTO wp_optionvalues (`option_id`, `optionvalue`, `optionvalue_desc`, `optionvalue_max`, `optionvalue_min`, `optionvalue_seq`) VALUES (55, 'draft', '草稿', NULL, NULL, 2);
INSERT INTO wp_optionvalues (`option_id`, `optionvalue`, `optionvalue_desc`, `optionvalue_max`, `optionvalue_min`, `optionvalue_seq`) VALUES (55, 'private', '私人', NULL, NULL, 3);
INSERT INTO wp_optionvalues (`option_id`, `optionvalue`, `optionvalue_desc`, `optionvalue_max`, `optionvalue_min`, `optionvalue_seq`) VALUES (56, 'open', '启用', NULL, NULL, 1);
INSERT INTO wp_optionvalues (`option_id`, `optionvalue`, `optionvalue_desc`, `optionvalue_max`, `optionvalue_min`, `optionvalue_seq`) VALUES (56, 'closed', '关闭', NULL, NULL, 2);
INSERT INTO wp_optionvalues (`option_id`, `optionvalue`, `optionvalue_desc`, `optionvalue_max`, `optionvalue_min`, `optionvalue_seq`) VALUES (57, 'open', '启用', NULL, NULL, 1);
INSERT INTO wp_optionvalues (`option_id`, `optionvalue`, `optionvalue_desc`, `optionvalue_max`, `optionvalue_min`, `optionvalue_seq`) VALUES (57, 'closed', '关闭', NULL, NULL, 2);
INSERT INTO wp_optionvalues (`option_id`, `optionvalue`, `optionvalue_desc`, `optionvalue_max`, `optionvalue_min`, `optionvalue_seq`) VALUES (58, '1', '选中', NULL, NULL, 1);
INSERT INTO wp_optionvalues (`option_id`, `optionvalue`, `optionvalue_desc`, `optionvalue_max`, `optionvalue_min`, `optionvalue_seq`) VALUES (58, '0', '不选中', NULL, NULL, 1);
INSERT INTO wp_optionvalues (`option_id`, `optionvalue`, `optionvalue_desc`, `optionvalue_max`, `optionvalue_min`, `optionvalue_seq`) VALUES (62, 'number', '数字', NULL, NULL, 1);
INSERT INTO wp_optionvalues (`option_id`, `optionvalue`, `optionvalue_desc`, `optionvalue_max`, `optionvalue_min`, `optionvalue_seq`) VALUES (62, 'char', '字符', NULL, NULL, 2);
INSERT INTO wp_optionvalues (`option_id`, `optionvalue`, `optionvalue_desc`, `optionvalue_max`, `optionvalue_min`, `optionvalue_seq`) VALUES (62, 'image', '图形', NULL, NULL, 3);
INSERT INTO wp_optionvalues (`option_id`, `optionvalue`, `optionvalue_desc`, `optionvalue_max`, `optionvalue_min`, `optionvalue_seq`) VALUES (88, 'none', '不启用', NULL, NULL, 1);
INSERT INTO wp_optionvalues (`option_id`, `optionvalue`, `optionvalue_desc`, `optionvalue_max`, `optionvalue_min`, `optionvalue_seq`) VALUES (88, 'manual', '启用', NULL, NULL, 2);

# --------------------------------------------------------

#
# Table Structure wp_post2cat
#

CREATE TABLE wp_post2cat (
  `rel_id` int(11) NOT NULL auto_increment,
  `post_id` int(11) NOT NULL default '0',
  `category_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`rel_id`),
  KEY `post_id` (`post_id`,`category_id`)
);

#
# Table Dump data wp_post2cat
#

INSERT INTO wp_post2cat (`rel_id`, `post_id`, `category_id`) VALUES (1, 1, 1);

# --------------------------------------------------------

#
# Table Structure wp_posts
#

CREATE TABLE wp_posts (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `post_author` int(4) NOT NULL default '0',
  `post_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `post_content` text NOT NULL,
  `post_title` text NOT NULL,
  `post_category` int(4) NOT NULL default '0',
  `post_excerpt` text NOT NULL,
  `post_lat` float default NULL,
  `post_lon` float default NULL,
  `post_status` enum('publish','draft','private') NOT NULL default 'publish',
  `comment_status` enum('open','closed') NOT NULL default 'open',
  `ping_status` enum('open','closed') NOT NULL default 'open',
  `post_password` varchar(20) NOT NULL default '',
  `post_name` varchar(200) NOT NULL default '',
  `to_ping` text NOT NULL,
  `pinged` text NOT NULL,
  `post_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `post_content_filtered` text NOT NULL,
  PRIMARY KEY  (`ID`),
  KEY `post_name` (`post_name`),
  KEY `post_status` (`post_status`)
);


# --------------------------------------------------------

#
# Table Structure wp_users
#

CREATE TABLE wp_users (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `user_login` varchar(20) NOT NULL default '',
  `user_pass` varchar(20) NOT NULL default '',
  `user_firstname` varchar(50) NOT NULL default '',
  `user_lastname` varchar(50) NOT NULL default '',
  `user_nickname` varchar(50) NOT NULL default '',
  `user_icq` int(10) unsigned NOT NULL default '0',
  `user_email` varchar(100) NOT NULL default '',
  `user_url` varchar(100) NOT NULL default '',
  `user_ip` varchar(15) NOT NULL default '',
  `user_domain` varchar(200) NOT NULL default '',
  `user_browser` varchar(200) NOT NULL default '',
  `dateYMDhour` datetime NOT NULL default '0000-00-00 00:00:00',
  `user_level` int(2) unsigned NOT NULL default '0',
  `user_aim` varchar(50) NOT NULL default '',
  `user_msn` varchar(100) NOT NULL default '',
  `user_yim` varchar(50) NOT NULL default '',
  `user_idmode` varchar(20) NOT NULL default '',
  `user_description` text NOT NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `user_login` (`user_login`)
);

# --------------------------------------------------------

#
# Table Structure wp_blacklist
#

CREATE TABLE wp_blacklist (
  `id` int(11) NOT NULL auto_increment,
  `domain` varchar(255) NOT NULL default '',
  KEY `id` (`id`),
  FULLTEXT KEY `domain` (`domain`)
) TYPE=MyISAM;