mysql.sql

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

#
# Table Structure `wp_categories`
#

CREATE TABLE wp_categories (
  `cat_ID` int(4) NOT NULL auto_increment,
  `cat_name` varchar(55) NOT NULL default '',
  `category_nicename` varchar(200) NOT NULL default '',
  `category_description` text NOT NULL,
  `category_parent` int(4) NOT NULL default '0',
  PRIMARY KEY  (`cat_ID`),
  UNIQUE KEY `cat_name` (`cat_name`),
  KEY `category_nicename` (`category_nicename`)
) ;

#
# Table Dump data `wp_categories`
#

INSERT INTO wp_categories (`cat_ID`, `cat_name`, `category_nicename`, `category_description`, `category_parent`) VALUES (1, 'General', 'general', '', 0);

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

#
# Table Structure wp_comments
#

CREATE TABLE wp_comments (
  `comment_ID` int(11) unsigned NOT NULL auto_increment,
  `comment_post_ID` int(11) NOT NULL default '0',
  `comment_author` tinytext NOT NULL,
  `comment_author_email` varchar(100) NOT NULL default '',
  `comment_author_url` varchar(100) NOT NULL default '',
  `comment_author_IP` varchar(100) NOT NULL default '',
  `comment_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `comment_content` text NOT NULL,
  `comment_karma` int(11) NOT NULL default '0',
  `comment_approved` enum('0','1') NOT NULL default '1',
  PRIMARY KEY  (`comment_ID`),
  KEY `comment_approved` (`comment_approved`),
  KEY `comment_post_ID` (`comment_post_ID`)
);

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

#
# Table Structure `wp_linkcategories`
#

CREATE TABLE wp_linkcategories (
  `cat_id` int(11) NOT NULL auto_increment,
  `cat_name` tinytext NOT NULL,
  `auto_toggle` enum('Y','N') NOT NULL default 'N',
  `show_images` enum('Y','N') NOT NULL default 'Y',
  `show_description` enum('Y','N') NOT NULL default 'N',
  `show_rating` enum('Y','N') NOT NULL default 'Y',
  `show_updated` enum('Y','N') NOT NULL default 'Y',
  `sort_order` varchar(64) NOT NULL default 'id',
  `sort_desc` enum('Y','N') NOT NULL default 'N',
  `text_before_link` varchar(128) NOT NULL default '<li>',
  `text_after_link` varchar(128) NOT NULL default '<br />',
  `text_after_all` varchar(128) NOT NULL default '</li>',
  `list_limit` int(11) NOT NULL default '-1',
  PRIMARY KEY  (`cat_id`)
);

#
# Table Dump data `wp_linkcategories`
#

INSERT INTO wp_linkcategories (`cat_id`, `cat_name`, `auto_toggle`, `show_images`, `show_description`, `show_rating`, `show_updated`, `sort_order`, `sort_desc`, `text_before_link`, `text_after_link`, `text_after_all`, `list_limit`) VALUES (1, 'Links', 'N', 'Y', 'Y', 'Y', 'Y', 'id', 'N', '<li>', '<br />', '</li>', -1);

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

#
# Table Structure wp_links
#

CREATE TABLE wp_links (
  `link_id` int(11) NOT NULL auto_increment,
  `link_url` varchar(255) NOT NULL default '',
  `link_name` varchar(255) NOT NULL default '',
  `link_image` varchar(255) NOT NULL default '',
  `link_target` varchar(25) NOT NULL default '',
  `link_category` int(11) NOT NULL default '0',
  `link_description` varchar(255) NOT NULL default '',
  `link_visible` enum('Y','N') NOT NULL default 'Y',
  `link_owner` int(11) NOT NULL default '1',
  `link_rating` int(11) NOT NULL default '0',
  `link_updated` datetime NOT NULL default '0000-00-00 00:00:00',
  `link_rel` varchar(255) NOT NULL default '',
  `link_notes` mediumtext NOT NULL,
  `link_rss` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`link_id`),
  KEY `link_category` (`link_category`),
  KEY `link_visible` (`link_visible`)
);

#
# Table Dump data wp_links
#

INSERT INTO wp_links (`link_id`, `link_url`, `link_name`, `link_image`, `link_target`, `link_category`, `link_description`, `link_visible`, `link_owner`, `link_rating`, `link_updated`, `link_rel`, `link_notes`, `link_rss`) VALUES (1, 'http://wordpress.org/', 'WordPress官方', '', '', 1, '', 'Y', 1, 0, '0000-00-00 00:00:00', '', '', '');
INSERT INTO wp_links (`link_id`, `link_url`, `link_name`, `link_image`, `link_target`, `link_category`, `link_description`, `link_visible`, `link_owner`, `link_rating`, `link_updated`, `link_rel`, `link_notes`, `link_rss`) VALUES (2, 'http://wordpress.xoops.org.cn/', 'WP for Xoops中文', '', '', 1, '', 'Y', 1, 0, '0000-00-00 00:00:00', '', '', '');
INSERT INTO wp_links (`link_id`, `link_url`, `link_name`, `link_image`, `link_target`, `link_category`, `link_description`, `link_visible`, `link_owner`, `link_rating`, `link_updated`, `link_rel`, `link_notes`, `link_rss`) VALUES (3, 'http://xoops.org/', 'Xoops官方', '', '', 1, '', 'Y', 1, 0, '0000-00-00 00:00:00', '', '', '');
INSERT INTO wp_links (`link_id`, `link_url`, `link_name`, `link_image`, `link_target`, `link_category`, `link_description`, `link_visible`, `link_owner`, `link_rating`, `link_updated`, `link_rel`, `link_notes`, `link_rss`) VALUES (4, 'http://xoops.org.cn/', 'Xoops中文官方', '', '', 1, '', 'Y', 1, 0, '0000-00-00 00:00:00', '', '', '');
INSERT INTO wp_links (`link_id`, `link_url`, `link_name`, `link_image`, `link_target`, `link_category`, `link_description`, `link_visible`, `link_owner`, `link_rating`, `link_updated`, `link_rel`, `link_notes`, `link_rss`) VALUES (5, 'http://wp.hsyong.com/', 'Xoops & Design', '', '', 1, '', 'Y', 1, 0, '00-00-00 00:00:00', '', '', '');
INSERT INTO wp_links (`link_id`, `link_url`, `link_name`, `link_image`, `link_target`, `link_category`, `link_description`, `link_visible`, `link_owner`, `link_rating`, `link_updated`, `link_rel`, `link_notes`, `link_rss`) VALUES (6, 'http://weciti.com/cnwp/', 'WordPress中文化', '', '', 1, '', 'Y', 1, 0, '0000-00-00 00:00:00', '', '', '');

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

#
# Table Structure wp_optiongroup_options
#

CREATE TABLE wp_optiongroup_options (
  `group_id` int(11) NOT NULL default '0',
  `option_id` int(11) NOT NULL default '0',
  `seq` int(11) NOT NULL default '0',
  PRIMARY KEY  (`group_id`,`option_id`)
);

#
# Table Dump data wp_optiongroup_options
#

INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (1, 48, 1);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (1, 49, 2);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (1, 50, 3);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (1, 51, 4);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (1, 52, 5);