Changeset 498 for branches/omcollab_MW1140/_InstallationResources

Timestamp:

04/21/2009 09:34:34 AM (3 years ago)

Author:

Xiping.Wang

Message:

update for mediawiki 1.14.0

File:

• branches/omcollab_MW1140/_InstallationResources/omwiki.sql (modified) (12 diffs)

branches/omcollab_MW1140/_InstallationResources/omwiki.sql

@@ -30 +30 @@
   `ar_len` int(10) unsigned default NULL,
   `ar_page_id` int(10) unsigned default NULL,
+  `ar_parent_id` int(10) unsigned DEFAULT NULL,
   KEY `name_title_timestamp` (`ar_namespace`,`ar_title`,`ar_timestamp`),
   KEY `usertext_timestamp` (`ar_user_text`,`ar_timestamp`)
@@ -42 +43 @@
 
 -- 
+-- Table structure for table `{omcollab_db_table_prefix}category`
+--
+
+CREATE TABLE IF NOT EXISTS `{omcollab_db_table_prefix}category` (
+  `cat_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `cat_title` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
+  `cat_pages` int(11) NOT NULL DEFAULT '0',
+  `cat_subcats` int(11) NOT NULL DEFAULT '0',
+  `cat_files` int(11) NOT NULL DEFAULT '0',
+  `cat_hidden` tinyint(1) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`cat_id`),
+  UNIQUE KEY `cat_title` (`cat_title`),
+  KEY `cat_pages` (`cat_pages`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `{omcollab_db_table_prefix}category`
+--
+
+
+-- --------------------------------------------------------
+
+--
 -- Table structure for table `{omcollab_db_table_prefix}categorylinks`
 -- 
@@ -125 +149 @@
   KEY `fa_storage_group` (`fa_storage_group`,`fa_storage_key`),
   KEY `fa_deleted_timestamp` (`fa_deleted_timestamp`),
-  KEY `fa_deleted_user` (`fa_deleted_user`)
+  KEY `fa_user_timestamp` (`fa_user_text`,`fa_timestamp`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
@@ -416 +440 @@
   `ipb_deleted` tinyint(1) NOT NULL default '0',
   `ipb_block_email` tinyint(1) NOT NULL default '0',
+  `ipb_by_text` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
+   `ipb_allow_usertalk` tinyint(1) NOT NULL DEFAULT '1',
   PRIMARY KEY  (`ipb_id`),
   UNIQUE KEY `ipb_address` (`ipb_address`(255),`ipb_user`,`ipb_auto`,`ipb_anon_only`),
@@ -662 +688 @@
 
 -- 
+-- Table structure for table `{omcollab_db_table_prefix}page_props`
+--
+
+CREATE TABLE IF NOT EXISTS `{omcollab_db_table_prefix}page_props` (
+  `pp_page` int(11) NOT NULL,
+  `pp_propname` varbinary(60) NOT NULL,
+  `pp_value` blob NOT NULL,
+  PRIMARY KEY (`pp_page`,`pp_propname`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+--
+-- Dumping data for table `{omcollab_db_table_prefix}page_props`
+--
+
+
+-- --------------------------------------------------------
+
+--
 -- Table structure for table `{omcollab_db_table_prefix}page_restrictions`
 -- 
@@ -695 +739 @@
 CREATE TABLE `{omcollab_db_table_prefix}protected_titles` (
   `pt_namespace` int(11) NOT NULL,
-  `pt_title` varchar(255) NOT NULL,
+  `pt_title` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
   `pt_user` int(10) unsigned NOT NULL,
   `pt_reason` tinyblob,
@@ -895 +939 @@
 
 INSERT INTO `{omcollab_db_table_prefix}revision` (`rev_id`, `rev_page`, `rev_text_id`, `rev_comment`, `rev_user`, `rev_user_text`, `rev_timestamp`, `rev_minor_edit`, `rev_deleted`, `rev_len`, `rev_parent_id`) VALUES 
-(1, 1, 1, '', 0, 0x4d6564696157696b692064656661756c74, 0x3230303830363035313033383034, 0, 0, 449, NULL),
-(7, 1, 7, '', 1, 0x41646d696e, 0x3230303830363133303934393338, 0, 0, 462, NULL),
-(8, 1, 8, '', 1, 0x41646d696e, 0x3230303830363133303935313239, 0, 0, 449, NULL),
-(9, 1, 9, '', 1, 0x41646d696e, 0x3230303830363133313031353339, 0, 0, 462, NULL),
-(11, 1, 11, '', 1, 0x41646d696e, 0x3230303830373031303933333337, 0, 0, 2739, NULL),
-(12, 1, 12, 0x2f2a204578616d706c6520323a20426f6f6b6d61726b732066726f6d20616e2065787465726e616c206f6d436f6c6c616220426f6f6b6d61726b732073697465202a2f, 1, 0x41646d696e, 0x3230303830373031303933353131, 0, 0, 2723, NULL),
-(13, 1, 13, 0x2f2a204578616d706c6520333a204c6f63616c6c7920426f6f6b6d61726b656420417373657473202a2f, 1, 0x41646d696e, 0x3230303830373031303933353438, 0, 0, 2719, NULL),
-(14, 1, 14, 0x2f2a204578616d706c6520333a204c6f63616c6c7920426f6f6b6d61726b656420417373657473202a2f, 1, 0x41646d696e, 0x3230303830373031303933363330, 0, 0, 2718, NULL),
-(15, 1, 15, 0x2f2a204578616d706c6520333a204c6f63616c6c7920426f6f6b6d61726b656420417373657473202a2f, 1, 0x41646d696e, 0x3230303830373031303933373234, 0, 0, 2708, NULL),
-(16, 1, 16, 0x2f2a204578616d706c6520333a204c6f63616c6c7920426f6f6b6d61726b656420417373657473202a2f, 1, 0x41646d696e, 0x3230303830373031303933383537, 0, 0, 2720, NULL),
-(17, 1, 17, 0x2f2a204578616d706c6520313a204c696e6b7320746f20617373657473206f66206120706172746963756c617220747970652c206f6e20616e2065787465726e616c2077696b69202a2f, 1, 0x41646d696e, 0x3230303830373031303933393431, 0, 0, 2715, NULL),
-(18, 1, 18, 0x2f2a204578616d706c6520333a204c6f63616c6c7920426f6f6b6d61726b656420417373657473202a2f, 1, 0x41646d696e, 0x3230303830373031303934303233, 0, 0, 2722, NULL),
-(2, 2, 2, 0x4e657720706167653a207b7b236d656e753a202a5b5b6d61696e706167657c6d61696e706167655d5d202a5b5b5370656369616c3a526563656e746368616e6765737c526563656e74204368616e6765735d5d202a5b5b5370656369616c3a4e657770616765737c4e65776573742050616765735d5d202a5b5b5370656369616c3a52616e646f6d7c52616e646f6d20506167655d5d207d7d203c64697620636c6173733d2276697375616c436c656172223e3c2f6469763e5f5f4e4f4544495453454354492e2e2e, 1, 0x41646d696e, 0x3230303830363131303934363539, 0, 0, 192, NULL),
-(3, 2, 3, '', 1, 0x41646d696e, 0x3230303830363131303934383030, 0, 0, 227, NULL),
-(4, 2, 4, '', 1, 0x41646d696e, 0x3230303830363131303934393130, 0, 0, 224, NULL),
-(5, 3, 5, 0x4e657720706167653a204e6176696761746520746f202f6f6d57696b692f4d6564696157696b693a5369646562617220616e642065646974206173207265717569726564, 1, 0x41646d696e, 0x3230303830363131313030393135, 0, 0, 58, NULL),
-(6, 3, 6, '', 1, 0x41646d696e, 0x3230303830363131313031353130, 0, 0, 62, NULL),
-(19, 3, 19, '', 1, 0x41646d696e, 0x3230303830373031303934373132, 0, 0, 58, NULL),
-(20, 3, 20, '', 1, 0x41646d696e, 0x3230303830373031303934373436, 0, 0, 42, NULL),
-(21, 3, 21, '', 1, 0x41646d696e, 0x3230303830373031303934383134, 0, 0, 30, NULL),
-(10, 4, 10, 0x696d706f727420757365722077696b69, 1, 0x41646d696e, 0x3230303830363133313231303234, 0, 0, 262, NULL);
+(1, 1, 1, '', 0, 'MediaWiki default', '20080605103804', 0, 0, 449, 0),
+(7, 1, 7, '', 1, 'Admin', '20080613094938', 0, 0, 462, 1),
+(8, 1, 8, '', 1, 'Admin', '20080613095129', 0, 0, 449, 7),
+(9, 1, 9, '', 1, 'Admin', '20080613101539', 0, 0, 462, 8),
+(11, 1, 11, '', 1, 'Admin', '20080701093337', 0, 0, 2739, 9),
+(12, 1, 12, 0x2f2a204578616d706c6520323a20426f6f6b6d61726b732066726f6d20616e2065787465726e616c206f6d436f6c6c616220426f6f6b6d61726b732073697465202a2f, 1, 'Admin', '20080701093511', 0, 0, 2723, 11),
+(13, 1, 13, 0x2f2a204578616d706c6520333a204c6f63616c6c7920426f6f6b6d61726b656420417373657473202a2f, 1, 'Admin', '20080701093548', 0, 0, 2719, 12),
+(14, 1, 14, 0x2f2a204578616d706c6520333a204c6f63616c6c7920426f6f6b6d61726b656420417373657473202a2f, 1, 'Admin', '20080701093630', 0, 0, 2718, 13),
+(15, 1, 15, 0x2f2a204578616d706c6520333a204c6f63616c6c7920426f6f6b6d61726b656420417373657473202a2f, 1, 'Admin', '20080701093724', 0, 0, 2708, 14),
+(16, 1, 16, 0x2f2a204578616d706c6520333a204c6f63616c6c7920426f6f6b6d61726b656420417373657473202a2f, 1, 'Admin', '20080701093857', 0, 0, 2720, 15),
+(17, 1, 17, 0x2f2a204578616d706c6520313a204c696e6b7320746f20617373657473206f66206120706172746963756c617220747970652c206f6e20616e2065787465726e616c2077696b69202a2f, 1, 'Admin', '20080701093941', 0, 0, 2715, 16),
+(18, 1, 18, 0x2f2a204578616d706c6520333a204c6f63616c6c7920426f6f6b6d61726b656420417373657473202a2f, 1, 'Admin', '20080701094023', 0, 0, 2722, 17),
+(2, 2, 2, 0x4e657720706167653a207b7b236d656e753a202a5b5b6d61696e706167657c6d61696e706167655d5d202a5b5b5370656369616c3a526563656e746368616e6765737c526563656e74204368616e6765735d5d202a5b5b5370656369616c3a4e657770616765737c4e65776573742050616765735d5d202a5b5b5370656369616c3a52616e646f6d7c52616e646f6d20506167655d5d207d7d203c64697620636c6173733d2276697375616c436c656172223e3c2f6469763e5f5f4e4f4544495453454354492e2e2e, 1, 'Admin', '20080611094659', 0, 0, 192, 0),
+(3, 2, 3, '', 1, 'Admin', '20080611094800', 0, 0, 227, 2),
+(4, 2, 4, '', 1, 'Admin', '20080611094910', 0, 0, 224, 3),
+(5, 3, 5, 0x4e657720706167653a204e6176696761746520746f202f6f6d57696b692f4d6564696157696b693a5369646562617220616e642065646974206173207265717569726564, 1, 'Admin', '20080611100915', 0, 0, 58, 0),
+(6, 3, 6, '', 1, 'Admin', '20080611101510', 0, 0, 62, 5),
+(19, 3, 19, '', 1, 'Admin', '20080701094712', 0, 0, 58, 6),
+(20, 3, 20, '', 1, 'Admin', '20080701094746', 0, 0, 42, 19),
+(21, 3, 21, '', 1, 'Admin', '20080701094814', 0, 0, 30, 20),
+(10, 4, 10, 0x696d706f727420757365722077696b69, 1, 'Admin', '20080613121024', 0, 0, 262, 0)
 
 -- --------------------------------------------------------
@@ -959 +1003 @@
   `ss_admins` int(11) default '-1',
   `ss_images` int(11) default '0',
+  `ss_active_users` bigint(20) DEFAULT '-1',
   UNIQUE KEY `ss_row_id` (`ss_row_id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
@@ -965 +1010 @@
 -- Dumping data for table `{omcollab_db_table_prefix}site_stats`
 -- 
-
-INSERT INTO `{omcollab_db_table_prefix}site_stats` (`ss_row_id`, `ss_total_views`, `ss_total_edits`, `ss_good_articles`, `ss_total_pages`, `ss_users`, `ss_admins`, `ss_images`) VALUES 
-(1, 100, 22, 2, 4, 1, 1, 0);
+INSERT INTO `{omcollab_db_table_prefix}site_stats` (`ss_row_id`, `ss_total_views`, `ss_total_edits`, `ss_good_articles`, `ss_total_pages`, `ss_users`, `ss_admins`, `ss_images`, `ss_active_users`) VALUES
+(1, 100, 22, 2, 4, 1, 1, 0, 0);
 
 -- --------------------------------------------------------
@@ -1076 +1120 @@
 
 -- 
+-- Table structure for table `{omcollab_db_table_prefix}updatelog`
+--
+
+CREATE TABLE IF NOT EXISTS `{omcollab_db_table_prefix}updatelog` (
+  `ul_key` varchar(255) NOT NULL,
+  PRIMARY KEY (`ul_key`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+--
+-- Dumping data for table `{omcollab_db_table_prefix}updatelog`
+--
+
+INSERT INTO `{omcollab_db_table_prefix}updatelog` (`ul_key`) VALUES
+('password format'),
+('populate category'),
+('populate rev_parent_id');
+
+-- --------------------------------------------------------
+
+--
 -- Table structure for table `{omcollab_db_table_prefix}user`
 -- 
@@ -1106 +1170 @@
 
 INSERT INTO `{omcollab_db_table_prefix}user` (`user_id`, `user_name`, `user_real_name`, `user_password`, `user_newpassword`, `user_newpass_time`, `user_email`, `user_options`, `user_touched`, `user_token`, `user_email_authenticated`, `user_email_token`, `user_email_token_expires`, `user_registration`, `user_editcount`) VALUES 
-(1, 0x41646d696e, '', 0x6264663633303162383232653737373865333862663130373261373465346538, '', NULL, '', 0x717569636b6261723d310a756e6465726c696e653d320a636f6c733d38300a726f77733d32350a7365617263686c696d69743d32300a636f6e746578746c696e65733d350a636f6e7465787463686172733d35300a736b696e3d6d696b65320a6d6174683d310a7263646179733d370a72636c696d69743d35300a776c6c696d69743d3235300a686967686c6967687462726f6b656e3d310a737475627468726573686f6c643d300a707265766965776f6e746f703d310a6564697473656374696f6e3d310a6564697473656374696f6e6f6e7269676874636c69636b3d300a73686f77746f633d310a73686f77746f6f6c6261723d310a646174653d64656661756c740a696d61676573697a653d320a7468756d6273697a653d320a72656d656d62657270617373776f72643d300a656e6f74696677617463686c69737470616765733d300a656e6f7469667573657274616c6b70616765733d310a656e6f7469666d696e6f7265646974733d300a656e6f74696672657665616c616464723d300a73686f776e756d626572737761746368696e673d300a66616e63797369673d300a65787465726e616c656469746f723d300a65787465726e616c646966663d300a73686f776a756d706c696e6b733d310a6e756d62657268656164696e67733d300a7573656c697665707265766965773d300a77617463686c697374646179733d330a76617269616e743d0a6c616e67756167653d656e0a7365617263684e73303d310a6e69636b6e616d653d0a74696d65636f7272656374696f6e3d0a616a61787365617263683d0a7365617263684e73313d300a7365617263684e73323d300a7365617263684e73333d300a7365617263684e73343d300a7365617263684e73353d300a7365617263684e73363d300a7365617263684e73373d300a7365617263684e73383d300a7365617263684e73393d300a7365617263684e7331303d300a7365617263684e7331313d300a7365617263684e7331323d300a7365617263684e7331333d300a7365617263684e7331343d300a7365617263684e7331353d300a64697361626c656d61696c3d300a6a7573746966793d300a686964656d696e6f723d300a657874656e6477617463686c6973743d300a7573656e657772633d300a656469746f6e64626c636c69636b3d300a6564697477696474683d300a77617463686372656174696f6e733d300a776174636864656661756c743d300a77617463686d6f7665733d300a776174636864656c6574696f6e3d300a6d696e6f7264656661756c743d300a707265766965776f6e66697273743d300a6e6f63616368653d300a666f7263656564697473756d6d6172793d300a77617463686c697374686964656f776e3d300a77617463686c69737468696465626f74733d300a77617463686c697374686964656d696e6f723d300a63636d656f6e656d61696c733d300a646966666f6e6c793d300a7365617263684e733130303d300a7365617263684e733130313d30, 0x3230303830373031303934383139, 0x3962633035646234353464656531386530663430336461373664636563323638, NULL, NULL, NULL, 0x3230303830363035313033383034, 20);
+(1, 'Admin', '', 0x3a423a313a6264663633303162383232653737373865333862663130373261373465346538, '', NULL, '', 0x717569636b6261723d310a756e6465726c696e653d320a636f6c733d38300a726f77733d32350a7365617263686c696d69743d32300a636f6e746578746c696e65733d350a636f6e7465787463686172733d35300a736b696e3d6d696b65320a6d6174683d310a7263646179733d370a72636c696d69743d35300a776c6c696d69743d3235300a686967686c6967687462726f6b656e3d310a737475627468726573686f6c643d300a707265766965776f6e746f703d310a6564697473656374696f6e3d310a6564697473656374696f6e6f6e7269676874636c69636b3d300a73686f77746f633d310a73686f77746f6f6c6261723d310a646174653d64656661756c740a696d61676573697a653d320a7468756d6273697a653d320a72656d656d62657270617373776f72643d300a656e6f74696677617463686c69737470616765733d300a656e6f7469667573657274616c6b70616765733d310a656e6f7469666d696e6f7265646974733d300a656e6f74696672657665616c616464723d300a73686f776e756d626572737761746368696e673d300a66616e63797369673d300a65787465726e616c656469746f723d300a65787465726e616c646966663d300a73686f776a756d706c696e6b733d310a6e756d62657268656164696e67733d300a7573656c697665707265766965773d300a77617463686c697374646179733d330a76617269616e743d0a6c616e67756167653d656e0a7365617263684e73303d310a6e69636b6e616d653d0a74696d65636f7272656374696f6e3d0a616a61787365617263683d0a7365617263684e73313d300a7365617263684e73323d300a7365617263684e73333d300a7365617263684e73343d300a7365617263684e73353d300a7365617263684e73363d300a7365617263684e73373d300a7365617263684e73383d300a7365617263684e73393d300a7365617263684e7331303d300a7365617263684e7331313d300a7365617263684e7331323d300a7365617263684e7331333d300a7365617263684e7331343d300a7365617263684e7331353d300a64697361626c656d61696c3d300a6a7573746966793d300a686964656d696e6f723d300a657874656e6477617463686c6973743d300a7573656e657772633d300a656469746f6e64626c636c69636b3d300a6564697477696474683d300a77617463686372656174696f6e733d300a776174636864656661756c743d300a77617463686d6f7665733d300a776174636864656c6574696f6e3d300a6d696e6f7264656661756c743d300a707265766965776f6e66697273743d300a6e6f63616368653d300a666f7263656564697473756d6d6172793d300a77617463686c697374686964656f776e3d300a77617463686c69737468696465626f74733d300a77617463686c697374686964656d696e6f723d300a63636d656f6e656d61696c733d300a646966666f6e6c793d300a7365617263684e733130303d300a7365617263684e733130313d30, 0x3230303830373031303934383139, 0x3962633035646234353464656531386530663430336461373664636563323638, NULL, NULL, NULL, 0x3230303830363035313033383034, 20);
 
 -- --------------------------------------------------------
@@ -1167 +1231 @@
   `user_id` int(11) NOT NULL default '0',
   `user_ip` varbinary(40) NOT NULL default '',
+  `user_last_timestamp` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
   KEY `user_id` (`user_id`),
   KEY `user_ip` (`user_ip`)