mysql.sql

来自「在综合英文版XOOPS 2.09, 2.091, 2.092 的基础上正式发布X」· SQL 代码 · 共 521 行 · 第 1/4 页

INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (1, 53, 6);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (2, 9, 1);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (2, 11, 3);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (2, 12, 4);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (2, 13, 5);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (2, 14, 6);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (2, 15, 7);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (2, 16, 8);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (2, 17, 9);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (2, 18, 10);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (2, 19, 11);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (2, 20, 12);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (3, 21, 1);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (3, 22, 2);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (3, 23, 3);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (3, 24, 4);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (3, 25, 5);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (3, 26, 6);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (3, 27, 7);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (3, 28, 8);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (3, 29, 9);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (3, 30, 10);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (4, 31, 1);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (4, 32, 2);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (4, 33, 3);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (4, 34, 4);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (4, 35, 5);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (4, 36, 6);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (4, 37, 7);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (5, 38, 1);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (5, 39, 2);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (5, 40, 3);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (5, 41, 4);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (5, 42, 5);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (5, 43, 6);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (5, 44, 7);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (5, 45, 8);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (5, 46, 9);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (5, 47, 10);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (6, 1, 1);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (6, 2, 2);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (6, 3, 3);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (6, 4, 4);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (6, 7, 6);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (6, 8, 7);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (6, 54, 8);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (7, 55, 1);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (7, 56, 2);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (7, 57, 3);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (7, 58, 4);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (7, 59, 5);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (7, 83, 5);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (8, 60, 1);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (8, 61, 2);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (8, 62, 3);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (8, 63, 4);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (8, 64, 5);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (8, 65, 6);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (8, 66, 7);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (8, 67, 8);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (8, 68, 9);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (8, 69, 10);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (8, 70, 11);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (8, 71, 12);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (8, 72, 13);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (8, 73, 14);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (8, 74, 15);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (8, 75, 16);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (8, 76, 17);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (8, 77, 18);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (8, 78, 19);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (8, 79, 20);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (8, 80, 21);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (8, 81, 22);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (8, 82, 23);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (9, 84, 1);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (9, 85, 1);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (9, 86, 1);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (9, 87, 1);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (2, 88, 13);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (2, 89, 14);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (2, 91, 5);
INSERT INTO wp_optiongroup_options (`group_id`, `option_id`, `seq`) VALUES (2, 92, 5);

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

#
# Table Structure wp_optiongroups
#

CREATE TABLE wp_optiongroups (
  `group_id` int(11) NOT NULL auto_increment,
  `group_name` varchar(64) NOT NULL default '',
  `group_desc` varchar(255) default NULL,
  `group_longdesc` tinytext,
  PRIMARY KEY  (`group_id`)
);

#
# Table Dump data wp_optiongroups
#

INSERT INTO wp_optiongroups (`group_id`, `group_name`, `group_desc`, `group_longdesc`) VALUES (1, '其他设置', '_LANG_INST_BASE_HELP1', NULL);
INSERT INTO wp_optiongroups (`group_id`, `group_name`, `group_desc`, `group_longdesc`) VALUES (2, '一般设置', '_LANG_INST_BASE_HELP2', NULL);
INSERT INTO wp_optiongroups (`group_id`, `group_name`, `group_desc`, `group_longdesc`) VALUES (3, 'RSS/RDF Feeds, Track/Ping-backs', '_LANG_INST_BASE_HELP3', NULL);
INSERT INTO wp_optiongroups (`group_id`, `group_name`, `group_desc`, `group_longdesc`) VALUES (4, '文件上传', '_LANG_INST_BASE_HELP4', NULL);
INSERT INTO wp_optiongroups (`group_id`, `group_name`, `group_desc`, `group_longdesc`) VALUES (5, '使用Email提交日志', '_LANG_INST_BASE_HELP5', NULL);
INSERT INTO wp_optiongroups (`group_id`, `group_name`, `group_desc`, `group_longdesc`) VALUES (6, '基本设置', '_LANG_INST_BASE_HELP6', NULL);
INSERT INTO wp_optiongroups (`group_id`, `group_name`, `group_desc`, `group_longdesc`) VALUES (7, '文章缺省设置', '_LANG_INST_BASE_HELP7', NULL);
INSERT INTO wp_optiongroups (`group_id`, `group_name`, `group_desc`, `group_longdesc`) VALUES (8, '链接管理设置', '_LANG_INST_BASE_HELP8', NULL);
INSERT INTO wp_optiongroups (`group_id`, `group_name`, `group_desc`, `group_longdesc`) VALUES (9, '地理位置设置', '_LANG_INST_BASE_HELP9', NULL);

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

#
# Table Structure wp_options
#

CREATE TABLE wp_options (
  `option_id` int(11) NOT NULL auto_increment,
  `blog_id` int(11) NOT NULL default '0',
  `option_name` varchar(64) NOT NULL default '',
  `option_can_override` enum('Y','N') NOT NULL default 'Y',
  `option_type` int(11) NOT NULL default '1',
  `option_value` varchar(255) NOT NULL default '',
  `option_width` int(11) NOT NULL default '20',
  `option_height` int(11) NOT NULL default '8',
  `option_description` tinytext NOT NULL,
  `option_admin_level` int(11) NOT NULL default '1',
  PRIMARY KEY  (`option_id`,`blog_id`,`option_name`)
);