User:Tim Starling/Schema diffs
Following are schema diffs generated by upgradeTest.py for 1.15 pre-release. The SQL dump is the final schema when upgrading from the version in question to 1.15. So lines that are added and then removed again show detritus that was removed from tables.sql but not removed with a patch. Lines showing changes to column specifications mean that the column was changed in tables.sql without adding a patch.
--- 1.2.sql 2009-05-14 18:17:41.000000000 +1000
+++ 1.3.sql 2009-05-14 18:18:10.000000000 +1000
@@ -1,6 +1,6 @@
-- MySQL dump 10.11
--
--- Host: localhost Database: uptest1_2
+-- Host: localhost Database: uptest1_3
-- ------------------------------------------------------
-- Server version 5.0.75-0ubuntu10
@@ -44,6 +44,20 @@
SET character_set_client = @saved_cs_client;
--
+-- Table structure for table `blobs`
+--
+
+DROP TABLE IF EXISTS `blobs`;
+SET @saved_cs_client = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `blobs` (
+ `blob_index` char(255) character set latin1 collate latin1_bin NOT NULL default '',
+ `blob_data` longblob NOT NULL,
+ UNIQUE KEY `blob_index` (`blob_index`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
-- Table structure for table `brokenlinks`
--
@@ -86,14 +100,14 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `categorylinks` (
- `cl_from` int(10) unsigned NOT NULL default '0',
+ `cl_from` int(8) unsigned NOT NULL default '0',
`cl_to` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
- `cl_sortkey` varchar(70) character set latin1 collate latin1_bin NOT NULL default '',
+ `cl_sortkey` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
`cl_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
UNIQUE KEY `cl_from` (`cl_from`,`cl_to`),
KEY `cl_timestamp` (`cl_to`,`cl_timestamp`),
KEY `cl_sortkey` (`cl_to`,`cl_sortkey`,`cl_from`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -149,7 +163,7 @@
KEY `user_timestamp` (`cur_user`,`inverse_timestamp`),
KEY `usertext_timestamp` (`cur_user_text`,`inverse_timestamp`),
KEY `namespace_redirect_timestamp` (`cur_namespace`,`cur_is_redirect`,`cur_timestamp`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1;
+) ENGINE=MyISAM AUTO_INCREMENT=725 DEFAULT CHARSET=latin1 PACK_KEYS=1;
SET character_set_client = @saved_cs_client;
--
@@ -256,10 +270,10 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `imagelinks` (
- `il_from` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
+ `il_from` int(8) unsigned NOT NULL default '0',
`il_to` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
- UNIQUE KEY `il_to` (`il_to`,`il_from`),
- KEY `il_from` (`il_from`(10))
+ UNIQUE KEY `il_from` (`il_from`,`il_to`),
+ UNIQUE KEY `il_to` (`il_to`,`il_from`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
@@ -388,21 +402,6 @@
SET character_set_client = @saved_cs_client;
--
--- Table structure for table `links_backup`
---
-
-DROP TABLE IF EXISTS `links_backup`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `links_backup` (
- `l_from` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
- `l_to` int(8) unsigned NOT NULL default '0',
- UNIQUE KEY `l_from` (`l_from`,`l_to`),
- KEY `l_to` (`l_to`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
-- Table structure for table `linkscc`
--
@@ -411,10 +410,8 @@
SET character_set_client = utf8;
CREATE TABLE `linkscc` (
`lcc_pageid` int(10) unsigned NOT NULL,
- `lcc_title` varchar(255) character set latin1 collate latin1_bin NOT NULL,
`lcc_cacheobj` mediumblob NOT NULL,
- UNIQUE KEY `lcc_pageid` (`lcc_pageid`),
- UNIQUE KEY `lcc_title` (`lcc_title`)
+ UNIQUE KEY `lcc_pageid` (`lcc_pageid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
@@ -441,7 +438,7 @@
KEY `user_time` (`log_user`,`log_timestamp`),
KEY `page_time` (`log_namespace`,`log_title`,`log_timestamp`),
KEY `times` (`log_timestamp`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=725 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -469,12 +466,12 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `objectcache` (
- `keyname` varbinary(255) NOT NULL default '',
+ `keyname` char(255) character set latin1 collate latin1_bin NOT NULL default '',
`value` mediumblob,
`exptime` datetime default NULL,
UNIQUE KEY `keyname` (`keyname`),
KEY `exptime` (`exptime`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -531,7 +528,7 @@
UNIQUE KEY `name_title` (`page_namespace`,`page_title`),
KEY `page_random` (`page_random`),
KEY `page_len` (`page_len`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=725 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -569,7 +566,7 @@
KEY `pr_typelevel` (`pr_type`,`pr_level`),
KEY `pr_level` (`pr_level`),
KEY `pr_cascade` (`pr_cascade`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=1449 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -616,12 +613,12 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `querycache` (
- `qc_type` varbinary(32) NOT NULL,
- `qc_value` int(10) unsigned NOT NULL default '0',
- `qc_namespace` int(11) NOT NULL default '0',
- `qc_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
+ `qc_type` char(32) NOT NULL,
+ `qc_value` int(5) unsigned NOT NULL default '0',
+ `qc_namespace` int(11) NOT NULL,
+ `qc_title` char(255) character set latin1 collate latin1_bin NOT NULL default '',
KEY `qc_type` (`qc_type`,`qc_value`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -682,7 +679,7 @@
`rc_type` tinyint(3) unsigned NOT NULL default '0',
`rc_moved_to_ns` tinyint(3) unsigned NOT NULL default '0',
`rc_moved_to_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
- `rc_ip` varbinary(40) NOT NULL default '',
+ `rc_ip` char(15) NOT NULL default '',
`rc_id` int(11) NOT NULL auto_increment,
`rc_patrolled` tinyint(3) unsigned NOT NULL default '0',
`rc_old_len` int(11) default NULL,
@@ -700,7 +697,7 @@
KEY `rc_ip` (`rc_ip`),
KEY `rc_ns_usertext` (`rc_namespace`,`rc_user_text`),
KEY `rc_user_text` (`rc_user_text`,`rc_timestamp`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1;
+) ENGINE=MyISAM AUTO_INCREMENT=725 DEFAULT CHARSET=latin1 PACK_KEYS=1;
SET character_set_client = @saved_cs_client;
--
@@ -744,7 +741,7 @@
KEY `page_timestamp` (`rev_page`,`rev_timestamp`),
KEY `user_timestamp` (`rev_user`,`rev_timestamp`),
KEY `usertext_timestamp` (`rev_user_text`,`rev_timestamp`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=725 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -844,7 +841,7 @@
KEY `name_title_timestamp` (`old_namespace`,`old_title`,`inverse_timestamp`),
KEY `user_timestamp` (`old_user`,`inverse_timestamp`),
KEY `usertext_timestamp` (`old_user_text`,`inverse_timestamp`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1;
+) ENGINE=MyISAM AUTO_INCREMENT=725 DEFAULT CHARSET=latin1 PACK_KEYS=1;
SET character_set_client = @saved_cs_client;
--
@@ -904,12 +901,12 @@
CREATE TABLE `user` (
`user_id` int(5) unsigned NOT NULL auto_increment,
`user_name` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
+ `user_real_name` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
`user_password` tinyblob NOT NULL,
`user_newpassword` tinyblob NOT NULL,
`user_email` tinytext NOT NULL,
`user_options` blob NOT NULL,
`user_touched` char(14) character set latin1 collate latin1_bin NOT NULL default '',
- `user_real_name` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
`user_token` binary(32) NOT NULL default '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
`user_email_authenticated` binary(14) default NULL,
`user_email_token` binary(32) default NULL,
@@ -1007,4 +1004,4 @@
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2009-05-14 8:17:41
+-- Dump completed on 2009-05-14 8:18:10
--- 1.3.sql 2009-05-14 18:18:10.000000000 +1000
+++ 1.4.sql 2009-05-14 18:18:50.000000000 +1000
@@ -1,6 +1,6 @@
-- MySQL dump 10.11
--
--- Host: localhost Database: uptest1_3
+-- Host: localhost Database: uptest1_4
-- ------------------------------------------------------
-- Server version 5.0.75-0ubuntu10
@@ -40,7 +40,7 @@
`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`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -154,16 +154,17 @@
`cur_random` double unsigned NOT NULL,
`cur_touched` char(14) character set latin1 collate latin1_bin NOT NULL default '',
`inverse_timestamp` char(14) character set latin1 collate latin1_bin NOT NULL default '',
- UNIQUE KEY `cur_id` (`cur_id`),
- KEY `cur_namespace` (`cur_namespace`),
+ PRIMARY KEY (`cur_id`),
+ UNIQUE KEY `name_title` (`cur_namespace`,`cur_title`),
KEY `cur_title` (`cur_title`(20)),
KEY `cur_timestamp` (`cur_timestamp`),
KEY `cur_random` (`cur_random`),
KEY `name_title_timestamp` (`cur_namespace`,`cur_title`,`inverse_timestamp`),
KEY `user_timestamp` (`cur_user`,`inverse_timestamp`),
KEY `usertext_timestamp` (`cur_user_text`,`inverse_timestamp`),
- KEY `namespace_redirect_timestamp` (`cur_namespace`,`cur_is_redirect`,`cur_timestamp`)
-) ENGINE=MyISAM AUTO_INCREMENT=725 DEFAULT CHARSET=latin1 PACK_KEYS=1;
+ KEY `namespace_redirect_timestamp` (`cur_namespace`,`cur_is_redirect`,`cur_timestamp`),
+ KEY `id_title_ns_red` (`cur_id`,`cur_title`,`cur_namespace`,`cur_is_redirect`)
+) ENGINE=MyISAM AUTO_INCREMENT=934 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -259,7 +260,7 @@
KEY `img_timestamp` (`img_timestamp`),
KEY `img_usertext_timestamp` (`img_user_text`,`img_timestamp`),
KEY `img_sha1` (`img_sha1`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -345,11 +346,11 @@
`ipb_expiry` char(14) character set latin1 collate latin1_bin NOT NULL default '',
`ipb_range_start` tinyblob NOT NULL,
`ipb_range_end` tinyblob NOT NULL,
- UNIQUE KEY `ipb_id` (`ipb_id`),
+ PRIMARY KEY (`ipb_id`),
KEY `ipb_address` (`ipb_address`),
KEY `ipb_user` (`ipb_user`),
KEY `ipb_range` (`ipb_range_start`(8),`ipb_range_end`(8))
-) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -423,11 +424,11 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `logging` (
- `log_type` varbinary(10) NOT NULL default '',
- `log_action` varbinary(10) NOT NULL default '',
- `log_timestamp` binary(14) NOT NULL default '19700101000000',
+ `log_type` char(10) NOT NULL default '',
+ `log_action` char(10) NOT NULL default '',
+ `log_timestamp` char(14) NOT NULL default '19700101000000',
`log_user` int(10) unsigned NOT NULL default '0',
- `log_namespace` int(11) NOT NULL default '0',
+ `log_namespace` int(11) NOT NULL,
`log_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
`log_comment` varchar(255) NOT NULL default '',
`log_params` blob NOT NULL,
@@ -438,7 +439,7 @@
KEY `user_time` (`log_user`,`log_timestamp`),
KEY `page_time` (`log_namespace`,`log_title`,`log_timestamp`),
KEY `times` (`log_timestamp`)
-) ENGINE=InnoDB AUTO_INCREMENT=725 DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM AUTO_INCREMENT=934 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -502,7 +503,7 @@
KEY `oi_name_archive_name` (`oi_name`,`oi_archive_name`(14)),
KEY `oi_usertext_timestamp` (`oi_user_text`,`oi_timestamp`),
KEY `oi_sha1` (`oi_sha1`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -528,7 +529,7 @@
UNIQUE KEY `name_title` (`page_namespace`,`page_title`),
KEY `page_random` (`page_random`),
KEY `page_len` (`page_len`)
-) ENGINE=InnoDB AUTO_INCREMENT=725 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=934 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -566,7 +567,7 @@
KEY `pr_typelevel` (`pr_type`,`pr_level`),
KEY `pr_level` (`pr_level`),
KEY `pr_cascade` (`pr_cascade`)
-) ENGINE=InnoDB AUTO_INCREMENT=1449 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=1867 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -663,6 +664,7 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `recentchanges` (
+ `rc_id` int(8) NOT NULL auto_increment,
`rc_timestamp` varchar(14) character set latin1 collate latin1_bin NOT NULL default '',
`rc_cur_time` varchar(14) character set latin1 collate latin1_bin NOT NULL default '',
`rc_user` int(10) unsigned NOT NULL default '0',
@@ -679,9 +681,8 @@
`rc_type` tinyint(3) unsigned NOT NULL default '0',
`rc_moved_to_ns` tinyint(3) unsigned NOT NULL default '0',
`rc_moved_to_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
- `rc_ip` char(15) NOT NULL default '',
- `rc_id` int(11) NOT NULL auto_increment,
`rc_patrolled` tinyint(3) unsigned NOT NULL default '0',
+ `rc_ip` char(15) NOT NULL default '',
`rc_old_len` int(11) default NULL,
`rc_new_len` int(11) default NULL,
`rc_deleted` tinyint(3) unsigned NOT NULL default '0',
@@ -697,7 +698,7 @@
KEY `rc_ip` (`rc_ip`),
KEY `rc_ns_usertext` (`rc_namespace`,`rc_user_text`),
KEY `rc_user_text` (`rc_user_text`,`rc_timestamp`)
-) ENGINE=MyISAM AUTO_INCREMENT=725 DEFAULT CHARSET=latin1 PACK_KEYS=1;
+) ENGINE=MyISAM AUTO_INCREMENT=934 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -741,7 +742,7 @@
KEY `page_timestamp` (`rev_page`,`rev_timestamp`),
KEY `user_timestamp` (`rev_user`,`rev_timestamp`),
KEY `usertext_timestamp` (`rev_user_text`,`rev_timestamp`)
-) ENGINE=InnoDB AUTO_INCREMENT=725 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=934 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -758,7 +759,7 @@
UNIQUE KEY `si_page` (`si_page`),
FULLTEXT KEY `si_title` (`si_title`),
FULLTEXT KEY `si_text` (`si_text`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -769,13 +770,13 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `site_stats` (
- `ss_row_id` int(8) unsigned NOT NULL,
+ `ss_row_id` int(8) unsigned NOT NULL default '1',
`ss_total_views` bigint(20) unsigned default '0',
`ss_total_edits` bigint(20) unsigned default '0',
`ss_good_articles` bigint(20) unsigned default '0',
`ss_total_pages` bigint(20) default '-1',
`ss_users` bigint(20) default '-1',
- `ss_admins` int(11) default '-1',
+ `ss_admins` int(10) default '-1',
`ss_images` int(11) default '0',
`ss_active_users` bigint(20) default '-1',
UNIQUE KEY `ss_row_id` (`ss_row_id`)
@@ -835,13 +836,12 @@
`old_minor_edit` tinyint(1) NOT NULL default '0',
`old_flags` tinyblob NOT NULL,
`inverse_timestamp` char(14) character set latin1 collate latin1_bin NOT NULL default '',
- UNIQUE KEY `old_id` (`old_id`),
- KEY `old_namespace` (`old_namespace`,`old_title`(20)),
+ PRIMARY KEY (`old_id`),
KEY `old_timestamp` (`old_timestamp`),
KEY `name_title_timestamp` (`old_namespace`,`old_title`,`inverse_timestamp`),
KEY `user_timestamp` (`old_user`,`inverse_timestamp`),
KEY `usertext_timestamp` (`old_user_text`,`inverse_timestamp`)
-) ENGINE=MyISAM AUTO_INCREMENT=725 DEFAULT CHARSET=latin1 PACK_KEYS=1;
+) ENGINE=MyISAM AUTO_INCREMENT=934 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -907,17 +907,17 @@
`user_email` tinytext NOT NULL,
`user_options` blob NOT NULL,
`user_touched` char(14) character set latin1 collate latin1_bin NOT NULL default '',
- `user_token` binary(32) NOT NULL default '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
+ `user_token` char(32) character set latin1 collate latin1_bin NOT NULL default '',
`user_email_authenticated` binary(14) default NULL,
`user_email_token` binary(32) default NULL,
`user_email_token_expires` binary(14) default NULL,
`user_registration` binary(14) default NULL,
`user_newpass_time` binary(14) default NULL,
`user_editcount` int(11) default NULL,
- UNIQUE KEY `user_id` (`user_id`),
+ PRIMARY KEY (`user_id`),
UNIQUE KEY `user_name` (`user_name`),
KEY `user_email_token` (`user_email_token`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -959,10 +959,10 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `user_rights` (
- `ur_user` int(10) unsigned NOT NULL,
+ `ur_user` int(5) unsigned NOT NULL,
`ur_rights` tinyblob NOT NULL,
UNIQUE KEY `ur_user` (`ur_user`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -979,6 +979,24 @@
SET character_set_client = @saved_cs_client;
--
+-- Table structure for table `validate`
+--
+
+DROP TABLE IF EXISTS `validate`;
+SET @saved_cs_client = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `validate` (
+ `val_user` int(11) NOT NULL default '0',
+ `val_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
+ `val_timestamp` varchar(14) character set latin1 collate latin1_bin NOT NULL default '',
+ `val_type` int(10) unsigned NOT NULL default '0',
+ `val_value` int(11) default '0',
+ `val_comment` varchar(255) NOT NULL default '',
+ KEY `val_user` (`val_user`,`val_title`,`val_timestamp`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
-- Table structure for table `watchlist`
--
@@ -992,7 +1010,7 @@
`wl_notificationtimestamp` varbinary(14) default NULL,
UNIQUE KEY `wl_user` (`wl_user`,`wl_namespace`,`wl_title`),
KEY `namespace_title` (`wl_namespace`,`wl_title`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -1004,4 +1022,4 @@
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2009-05-14 8:18:10
+-- Dump completed on 2009-05-14 8:18:50
--- 1.4.sql 2009-05-14 18:18:50.000000000 +1000
+++ 1.5.sql 2009-05-14 18:20:10.000000000 +1000
@@ -1,6 +1,6 @@
-- MySQL dump 10.11
--
--- Host: localhost Database: uptest1_4
+-- Host: localhost Database: uptest1_5
-- ------------------------------------------------------
-- Server version 5.0.75-0ubuntu10
@@ -23,53 +23,24 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `archive` (
- `ar_namespace` int(11) NOT NULL,
+ `ar_namespace` int(11) NOT NULL default '0',
`ar_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
- `ar_text` mediumtext NOT NULL,
+ `ar_text` mediumblob NOT NULL,
`ar_comment` tinyblob NOT NULL,
`ar_user` int(5) unsigned NOT NULL default '0',
`ar_user_text` varchar(255) character set latin1 collate latin1_bin NOT NULL,
`ar_timestamp` char(14) character set latin1 collate latin1_bin NOT NULL default '',
`ar_minor_edit` tinyint(1) NOT NULL default '0',
`ar_flags` tinyblob NOT NULL,
- `ar_rev_id` int(10) unsigned default NULL,
- `ar_text_id` int(10) unsigned default NULL,
+ `ar_rev_id` int(8) unsigned default NULL,
+ `ar_text_id` int(8) unsigned default NULL,
`ar_deleted` tinyint(3) unsigned NOT NULL default '0',
`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`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `blobs`
---
-
-DROP TABLE IF EXISTS `blobs`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `blobs` (
- `blob_index` char(255) character set latin1 collate latin1_bin NOT NULL default '',
- `blob_data` longblob NOT NULL,
- UNIQUE KEY `blob_index` (`blob_index`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `brokenlinks`
---
-
-DROP TABLE IF EXISTS `brokenlinks`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `brokenlinks` (
- `bl_from` int(8) unsigned NOT NULL default '0',
- `bl_to` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
- UNIQUE KEY `bl_from` (`bl_from`,`bl_to`),
- KEY `bl_to` (`bl_to`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -102,12 +73,12 @@
CREATE TABLE `categorylinks` (
`cl_from` int(8) unsigned NOT NULL default '0',
`cl_to` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
- `cl_sortkey` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
+ `cl_sortkey` varchar(86) character set latin1 collate latin1_bin NOT NULL default '',
`cl_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
UNIQUE KEY `cl_from` (`cl_from`,`cl_to`),
KEY `cl_timestamp` (`cl_to`,`cl_timestamp`),
KEY `cl_sortkey` (`cl_to`,`cl_sortkey`,`cl_from`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -131,43 +102,6 @@
SET character_set_client = @saved_cs_client;
--
--- Table structure for table `cur`
---
-
-DROP TABLE IF EXISTS `cur`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `cur` (
- `cur_id` int(8) unsigned NOT NULL auto_increment,
- `cur_namespace` tinyint(2) unsigned NOT NULL default '0',
- `cur_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
- `cur_text` mediumtext NOT NULL,
- `cur_comment` tinyblob NOT NULL,
- `cur_user` int(5) unsigned NOT NULL default '0',
- `cur_user_text` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
- `cur_timestamp` char(14) character set latin1 collate latin1_bin NOT NULL default '',
- `cur_restrictions` tinyblob NOT NULL,
- `cur_counter` bigint(20) unsigned NOT NULL default '0',
- `cur_is_redirect` tinyint(1) unsigned NOT NULL default '0',
- `cur_minor_edit` tinyint(1) unsigned NOT NULL default '0',
- `cur_is_new` tinyint(1) unsigned NOT NULL default '0',
- `cur_random` double unsigned NOT NULL,
- `cur_touched` char(14) character set latin1 collate latin1_bin NOT NULL default '',
- `inverse_timestamp` char(14) character set latin1 collate latin1_bin NOT NULL default '',
- PRIMARY KEY (`cur_id`),
- UNIQUE KEY `name_title` (`cur_namespace`,`cur_title`),
- KEY `cur_title` (`cur_title`(20)),
- KEY `cur_timestamp` (`cur_timestamp`),
- KEY `cur_random` (`cur_random`),
- KEY `name_title_timestamp` (`cur_namespace`,`cur_title`,`inverse_timestamp`),
- KEY `user_timestamp` (`cur_user`,`inverse_timestamp`),
- KEY `usertext_timestamp` (`cur_user_text`,`inverse_timestamp`),
- KEY `namespace_redirect_timestamp` (`cur_namespace`,`cur_is_redirect`,`cur_timestamp`),
- KEY `id_title_ns_red` (`cur_id`,`cur_title`,`cur_namespace`,`cur_is_redirect`)
-) ENGINE=MyISAM AUTO_INCREMENT=934 DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
-- Table structure for table `externallinks`
--
@@ -243,24 +177,24 @@
CREATE TABLE `image` (
`img_name` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
`img_size` int(8) unsigned NOT NULL default '0',
+ `img_width` int(5) NOT NULL default '0',
+ `img_height` int(5) NOT NULL default '0',
+ `img_metadata` mediumblob NOT NULL,
+ `img_bits` int(3) NOT NULL default '0',
+ `img_media_type` enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') default NULL,
+ `img_major_mime` enum('unknown','application','audio','image','text','video','message','model','multipart') NOT NULL default 'unknown',
+ `img_minor_mime` varchar(32) NOT NULL default 'unknown',
`img_description` tinyblob NOT NULL,
`img_user` int(5) unsigned NOT NULL default '0',
`img_user_text` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
`img_timestamp` char(14) character set latin1 collate latin1_bin NOT NULL default '',
- `img_width` int(11) NOT NULL default '0',
- `img_height` int(11) NOT NULL default '0',
- `img_bits` int(11) NOT NULL default '0',
- `img_metadata` mediumblob NOT NULL,
- `img_media_type` enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') default NULL,
- `img_major_mime` enum('unknown','application','audio','image','text','video','message','model','multipart') NOT NULL default 'unknown',
- `img_minor_mime` varbinary(32) NOT NULL default 'unknown',
`img_sha1` varbinary(32) NOT NULL default '',
PRIMARY KEY (`img_name`),
KEY `img_size` (`img_size`),
KEY `img_timestamp` (`img_timestamp`),
KEY `img_usertext_timestamp` (`img_user_text`,`img_timestamp`),
KEY `img_sha1` (`img_sha1`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -275,7 +209,7 @@
`il_to` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
UNIQUE KEY `il_from` (`il_from`,`il_to`),
UNIQUE KEY `il_to` (`il_to`,`il_from`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -289,9 +223,9 @@
`iw_prefix` char(32) NOT NULL,
`iw_url` char(127) NOT NULL,
`iw_local` tinyint(1) NOT NULL,
- `iw_trans` tinyint(4) NOT NULL default '0',
+ `iw_trans` tinyint(1) NOT NULL default '0',
UNIQUE KEY `iw_prefix` (`iw_prefix`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -350,7 +284,7 @@
KEY `ipb_address` (`ipb_address`),
KEY `ipb_user` (`ipb_user`),
KEY `ipb_range` (`ipb_range_start`(8),`ipb_range_end`(8))
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -388,35 +322,6 @@
SET character_set_client = @saved_cs_client;
--
--- Table structure for table `links`
---
-
-DROP TABLE IF EXISTS `links`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `links` (
- `l_from` int(8) unsigned NOT NULL default '0',
- `l_to` int(8) unsigned NOT NULL default '0',
- UNIQUE KEY `l_from` (`l_from`,`l_to`),
- KEY `l_to` (`l_to`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
--- Table structure for table `linkscc`
---
-
-DROP TABLE IF EXISTS `linkscc`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `linkscc` (
- `lcc_pageid` int(10) unsigned NOT NULL,
- `lcc_cacheobj` mediumblob NOT NULL,
- UNIQUE KEY `lcc_pageid` (`lcc_pageid`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
-- Table structure for table `logging`
--
@@ -428,7 +333,7 @@
`log_action` char(10) NOT NULL default '',
`log_timestamp` char(14) NOT NULL default '19700101000000',
`log_user` int(10) unsigned NOT NULL default '0',
- `log_namespace` int(11) NOT NULL,
+ `log_namespace` int(11) NOT NULL default '0',
`log_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
`log_comment` varchar(255) NOT NULL default '',
`log_params` blob NOT NULL,
@@ -439,7 +344,7 @@
KEY `user_time` (`log_user`,`log_timestamp`),
KEY `page_time` (`log_namespace`,`log_title`,`log_timestamp`),
KEY `times` (`log_timestamp`)
-) ENGINE=MyISAM AUTO_INCREMENT=934 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=1281 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -456,7 +361,7 @@
`math_html` text,
`math_mathml` text,
UNIQUE KEY `math_inputhash` (`math_inputhash`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -472,7 +377,7 @@
`exptime` datetime default NULL,
UNIQUE KEY `keyname` (`keyname`),
KEY `exptime` (`exptime`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -486,13 +391,13 @@
`oi_name` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
`oi_archive_name` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
`oi_size` int(8) unsigned NOT NULL default '0',
+ `oi_width` int(5) NOT NULL default '0',
+ `oi_height` int(5) NOT NULL default '0',
+ `oi_bits` int(3) NOT NULL default '0',
`oi_description` tinyblob NOT NULL,
`oi_user` int(5) unsigned NOT NULL default '0',
`oi_user_text` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
`oi_timestamp` char(14) character set latin1 collate latin1_bin NOT NULL default '',
- `oi_width` int(11) NOT NULL default '0',
- `oi_height` int(11) NOT NULL default '0',
- `oi_bits` int(11) NOT NULL default '0',
`oi_metadata` mediumblob NOT NULL,
`oi_media_type` enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') default NULL,
`oi_major_mime` enum('unknown','application','audio','image','text','video','message','model','multipart') NOT NULL default 'unknown',
@@ -503,7 +408,7 @@
KEY `oi_name_archive_name` (`oi_name`,`oi_archive_name`(14)),
KEY `oi_usertext_timestamp` (`oi_user_text`,`oi_timestamp`),
KEY `oi_sha1` (`oi_sha1`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -529,7 +434,7 @@
UNIQUE KEY `name_title` (`page_namespace`,`page_title`),
KEY `page_random` (`page_random`),
KEY `page_len` (`page_len`)
-) ENGINE=InnoDB AUTO_INCREMENT=934 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=1281 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -567,7 +472,7 @@
KEY `pr_typelevel` (`pr_type`,`pr_level`),
KEY `pr_level` (`pr_level`),
KEY `pr_cascade` (`pr_cascade`)
-) ENGINE=InnoDB AUTO_INCREMENT=1867 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=2561 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -578,7 +483,7 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `pagelinks` (
- `pl_from` int(10) unsigned NOT NULL default '0',
+ `pl_from` int(8) unsigned NOT NULL default '0',
`pl_namespace` int(11) NOT NULL default '0',
`pl_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
UNIQUE KEY `pl_from` (`pl_from`,`pl_namespace`,`pl_title`),
@@ -616,10 +521,10 @@
CREATE TABLE `querycache` (
`qc_type` char(32) NOT NULL,
`qc_value` int(5) unsigned NOT NULL default '0',
- `qc_namespace` int(11) NOT NULL,
+ `qc_namespace` int(11) NOT NULL default '0',
`qc_title` char(255) character set latin1 collate latin1_bin NOT NULL default '',
KEY `qc_type` (`qc_type`,`qc_value`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -669,7 +574,7 @@
`rc_cur_time` varchar(14) character set latin1 collate latin1_bin NOT NULL default '',
`rc_user` int(10) unsigned NOT NULL default '0',
`rc_user_text` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
- `rc_namespace` int(11) NOT NULL,
+ `rc_namespace` int(11) NOT NULL default '0',
`rc_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
`rc_comment` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
`rc_minor` tinyint(3) unsigned NOT NULL default '0',
@@ -698,7 +603,7 @@
KEY `rc_ip` (`rc_ip`),
KEY `rc_ns_usertext` (`rc_namespace`,`rc_user_text`),
KEY `rc_user_text` (`rc_user_text`,`rc_timestamp`)
-) ENGINE=MyISAM AUTO_INCREMENT=934 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=1281 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -727,22 +632,22 @@
CREATE TABLE `revision` (
`rev_id` int(8) unsigned NOT NULL auto_increment,
`rev_page` int(8) unsigned NOT NULL,
+ `rev_text_id` int(8) unsigned NOT NULL,
`rev_comment` tinyblob NOT NULL,
`rev_user` int(5) unsigned NOT NULL default '0',
`rev_user_text` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
`rev_timestamp` char(14) character set latin1 collate latin1_bin NOT NULL default '',
`rev_minor_edit` tinyint(1) unsigned NOT NULL default '0',
`rev_deleted` tinyint(1) unsigned NOT NULL default '0',
- `rev_len` int(8) unsigned default NULL,
- `rev_parent_id` int(8) unsigned default NULL,
- `rev_text_id` int(10) unsigned NOT NULL,
+ `rev_parent_id` int(10) unsigned default NULL,
+ `rev_len` int(10) unsigned default NULL,
PRIMARY KEY (`rev_page`,`rev_id`),
UNIQUE KEY `rev_id` (`rev_id`),
KEY `rev_timestamp` (`rev_timestamp`),
KEY `page_timestamp` (`rev_page`,`rev_timestamp`),
KEY `user_timestamp` (`rev_user`,`rev_timestamp`),
KEY `usertext_timestamp` (`rev_user_text`,`rev_timestamp`)
-) ENGINE=InnoDB AUTO_INCREMENT=934 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=1281 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -770,7 +675,7 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `site_stats` (
- `ss_row_id` int(8) unsigned NOT NULL default '1',
+ `ss_row_id` int(8) unsigned NOT NULL,
`ss_total_views` bigint(20) unsigned default '0',
`ss_total_edits` bigint(20) unsigned default '0',
`ss_good_articles` bigint(20) unsigned default '0',
@@ -780,7 +685,7 @@
`ss_images` int(11) default '0',
`ss_active_users` bigint(20) default '-1',
UNIQUE KEY `ss_row_id` (`ss_row_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -826,22 +731,10 @@
SET character_set_client = utf8;
CREATE TABLE `text` (
`old_id` int(8) unsigned NOT NULL auto_increment,
- `old_namespace` tinyint(2) unsigned NOT NULL default '0',
- `old_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
- `old_text` mediumtext NOT NULL,
- `old_comment` tinyblob NOT NULL,
- `old_user` int(5) unsigned NOT NULL default '0',
- `old_user_text` varchar(255) character set latin1 collate latin1_bin NOT NULL,
- `old_timestamp` char(14) character set latin1 collate latin1_bin NOT NULL default '',
- `old_minor_edit` tinyint(1) NOT NULL default '0',
+ `old_text` mediumblob NOT NULL,
`old_flags` tinyblob NOT NULL,
- `inverse_timestamp` char(14) character set latin1 collate latin1_bin NOT NULL default '',
- PRIMARY KEY (`old_id`),
- KEY `old_timestamp` (`old_timestamp`),
- KEY `name_title_timestamp` (`old_namespace`,`old_title`,`inverse_timestamp`),
- KEY `user_timestamp` (`old_user`,`inverse_timestamp`),
- KEY `usertext_timestamp` (`old_user_text`,`inverse_timestamp`)
-) ENGINE=MyISAM AUTO_INCREMENT=934 DEFAULT CHARSET=latin1;
+ PRIMARY KEY (`old_id`)
+) ENGINE=InnoDB AUTO_INCREMENT=1281 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -855,12 +748,12 @@
`tb_id` int(11) NOT NULL auto_increment,
`tb_page` int(11) default NULL,
`tb_title` varchar(255) NOT NULL,
- `tb_url` blob NOT NULL,
+ `tb_url` varchar(255) NOT NULL,
`tb_ex` text,
`tb_name` varchar(255) default NULL,
PRIMARY KEY (`tb_id`),
KEY `tb_page` (`tb_page`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -871,7 +764,7 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `transcache` (
- `tc_url` varbinary(255) NOT NULL,
+ `tc_url` varchar(255) NOT NULL,
`tc_contents` text,
`tc_time` int(11) NOT NULL,
UNIQUE KEY `tc_url_idx` (`tc_url`)
@@ -908,16 +801,16 @@
`user_options` blob NOT NULL,
`user_touched` char(14) character set latin1 collate latin1_bin NOT NULL default '',
`user_token` char(32) character set latin1 collate latin1_bin NOT NULL default '',
- `user_email_authenticated` binary(14) default NULL,
- `user_email_token` binary(32) default NULL,
- `user_email_token_expires` binary(14) default NULL,
+ `user_email_authenticated` char(14) character set latin1 collate latin1_bin default NULL,
+ `user_email_token` char(32) character set latin1 collate latin1_bin default NULL,
+ `user_email_token_expires` char(14) character set latin1 collate latin1_bin default NULL,
`user_registration` binary(14) default NULL,
`user_newpass_time` binary(14) default NULL,
`user_editcount` int(11) default NULL,
PRIMARY KEY (`user_id`),
UNIQUE KEY `user_name` (`user_name`),
KEY `user_email_token` (`user_email_token`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -928,8 +821,8 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `user_groups` (
- `ug_user` int(10) unsigned NOT NULL default '0',
- `ug_group` varbinary(16) NOT NULL default '',
+ `ug_user` int(5) unsigned NOT NULL default '0',
+ `ug_group` char(16) NOT NULL default '',
PRIMARY KEY (`ug_user`,`ug_group`),
KEY `ug_group` (`ug_group`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
@@ -952,20 +845,6 @@
SET character_set_client = @saved_cs_client;
--
--- Table structure for table `user_rights`
---
-
-DROP TABLE IF EXISTS `user_rights`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `user_rights` (
- `ur_user` int(5) unsigned NOT NULL,
- `ur_rights` tinyblob NOT NULL,
- UNIQUE KEY `ur_user` (`ur_user`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
-- Table structure for table `valid_tag`
--
@@ -987,13 +866,14 @@
SET character_set_client = utf8;
CREATE TABLE `validate` (
`val_user` int(11) NOT NULL default '0',
- `val_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
- `val_timestamp` varchar(14) character set latin1 collate latin1_bin NOT NULL default '',
- `val_type` int(10) unsigned NOT NULL default '0',
+ `val_page` int(11) unsigned NOT NULL default '0',
+ `val_revision` int(11) unsigned NOT NULL default '0',
+ `val_type` int(11) unsigned NOT NULL default '0',
`val_value` int(11) default '0',
`val_comment` varchar(255) NOT NULL default '',
- KEY `val_user` (`val_user`,`val_title`,`val_timestamp`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+ `val_ip` varchar(20) NOT NULL default '',
+ KEY `val_user` (`val_user`,`val_revision`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -1005,12 +885,12 @@
SET character_set_client = utf8;
CREATE TABLE `watchlist` (
`wl_user` int(5) unsigned NOT NULL,
- `wl_namespace` int(11) NOT NULL,
+ `wl_namespace` int(11) NOT NULL default '0',
`wl_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
`wl_notificationtimestamp` varbinary(14) default NULL,
UNIQUE KEY `wl_user` (`wl_user`,`wl_namespace`,`wl_title`),
KEY `namespace_title` (`wl_namespace`,`wl_title`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -1022,4 +902,4 @@
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2009-05-14 8:18:50
+-- Dump completed on 2009-05-14 8:20:10
--- 1.5.sql 2009-05-14 18:20:10.000000000 +1000
+++ 1.6.sql 2009-05-14 18:21:44.000000000 +1000
@@ -1,6 +1,6 @@
-- MySQL dump 10.11
--
--- Host: localhost Database: uptest1_5
+-- Host: localhost Database: uptest1_6
-- ------------------------------------------------------
-- Server version 5.0.75-0ubuntu10
@@ -278,8 +278,8 @@
`ipb_timestamp` char(14) character set latin1 collate latin1_bin NOT NULL default '',
`ipb_auto` tinyint(1) NOT NULL default '0',
`ipb_expiry` char(14) character set latin1 collate latin1_bin NOT NULL default '',
- `ipb_range_start` tinyblob NOT NULL,
- `ipb_range_end` tinyblob NOT NULL,
+ `ipb_range_start` varchar(32) NOT NULL default '',
+ `ipb_range_end` varchar(32) NOT NULL default '',
PRIMARY KEY (`ipb_id`),
KEY `ipb_address` (`ipb_address`),
KEY `ipb_user` (`ipb_user`),
@@ -295,8 +295,8 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `job` (
- `job_id` int(10) unsigned NOT NULL auto_increment,
- `job_cmd` varbinary(60) NOT NULL default '',
+ `job_id` int(9) unsigned NOT NULL auto_increment,
+ `job_cmd` varchar(255) NOT NULL default '',
`job_namespace` int(11) NOT NULL,
`job_title` varchar(255) character set latin1 collate latin1_bin NOT NULL,
`job_params` blob NOT NULL,
@@ -344,7 +344,7 @@
KEY `user_time` (`log_user`,`log_timestamp`),
KEY `page_time` (`log_namespace`,`log_title`,`log_timestamp`),
KEY `times` (`log_timestamp`)
-) ENGINE=InnoDB AUTO_INCREMENT=1281 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=1368 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -434,7 +434,7 @@
UNIQUE KEY `name_title` (`page_namespace`,`page_title`),
KEY `page_random` (`page_random`),
KEY `page_len` (`page_len`)
-) ENGINE=InnoDB AUTO_INCREMENT=1281 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=1368 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -472,7 +472,7 @@
KEY `pr_typelevel` (`pr_type`,`pr_level`),
KEY `pr_level` (`pr_level`),
KEY `pr_cascade` (`pr_cascade`)
-) ENGINE=InnoDB AUTO_INCREMENT=2561 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=2735 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -603,7 +603,7 @@
KEY `rc_ip` (`rc_ip`),
KEY `rc_ns_usertext` (`rc_namespace`,`rc_user_text`),
KEY `rc_user_text` (`rc_user_text`,`rc_timestamp`)
-) ENGINE=InnoDB AUTO_INCREMENT=1281 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=1368 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -647,7 +647,7 @@
KEY `page_timestamp` (`rev_page`,`rev_timestamp`),
KEY `user_timestamp` (`rev_user`,`rev_timestamp`),
KEY `usertext_timestamp` (`rev_user_text`,`rev_timestamp`)
-) ENGINE=InnoDB AUTO_INCREMENT=1281 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=1368 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -682,7 +682,7 @@
`ss_total_pages` bigint(20) default '-1',
`ss_users` bigint(20) default '-1',
`ss_admins` int(10) default '-1',
- `ss_images` int(11) default '0',
+ `ss_images` int(10) default '0',
`ss_active_users` bigint(20) default '-1',
UNIQUE KEY `ss_row_id` (`ss_row_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
@@ -714,7 +714,7 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `templatelinks` (
- `tl_from` int(10) unsigned NOT NULL default '0',
+ `tl_from` int(8) unsigned NOT NULL default '0',
`tl_namespace` int(11) NOT NULL default '0',
`tl_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
UNIQUE KEY `tl_from` (`tl_from`,`tl_namespace`,`tl_title`),
@@ -734,7 +734,7 @@
`old_text` mediumblob NOT NULL,
`old_flags` tinyblob NOT NULL,
PRIMARY KEY (`old_id`)
-) ENGINE=InnoDB AUTO_INCREMENT=1281 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=1368 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -804,7 +804,7 @@
`user_email_authenticated` char(14) character set latin1 collate latin1_bin default NULL,
`user_email_token` char(32) character set latin1 collate latin1_bin default NULL,
`user_email_token_expires` char(14) character set latin1 collate latin1_bin default NULL,
- `user_registration` binary(14) default NULL,
+ `user_registration` char(14) character set latin1 collate latin1_bin default NULL,
`user_newpass_time` binary(14) default NULL,
`user_editcount` int(11) default NULL,
PRIMARY KEY (`user_id`),
@@ -887,7 +887,7 @@
`wl_user` int(5) unsigned NOT NULL,
`wl_namespace` int(11) NOT NULL default '0',
`wl_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
- `wl_notificationtimestamp` varbinary(14) default NULL,
+ `wl_notificationtimestamp` varchar(14) character set latin1 collate latin1_bin default NULL,
UNIQUE KEY `wl_user` (`wl_user`,`wl_namespace`,`wl_title`),
KEY `namespace_title` (`wl_namespace`,`wl_title`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
@@ -902,4 +902,4 @@
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2009-05-14 8:20:10
+-- Dump completed on 2009-05-14 8:21:44
--- 1.6.sql 2009-05-14 18:21:44.000000000 +1000
+++ 1.7.sql 2009-05-14 18:23:03.000000000 +1000
@@ -1,6 +1,6 @@
-- MySQL dump 10.11
--
--- Host: localhost Database: uptest1_6
+-- Host: localhost Database: uptest1_7
-- ------------------------------------------------------
-- Server version 5.0.75-0ubuntu10
@@ -129,23 +129,23 @@
`fa_id` int(11) NOT NULL auto_increment,
`fa_name` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
`fa_archive_name` varchar(255) character set latin1 collate latin1_bin default '',
- `fa_storage_group` varbinary(16) default NULL,
- `fa_storage_key` varbinary(64) default '',
+ `fa_storage_group` varchar(16) default NULL,
+ `fa_storage_key` varchar(64) character set latin1 collate latin1_bin default '',
`fa_deleted_user` int(11) default NULL,
- `fa_deleted_timestamp` binary(14) default '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
+ `fa_deleted_timestamp` char(14) character set latin1 collate latin1_bin default '',
`fa_deleted_reason` text,
- `fa_size` int(10) unsigned default '0',
- `fa_width` int(11) default '0',
- `fa_height` int(11) default '0',
+ `fa_size` int(8) unsigned default '0',
+ `fa_width` int(5) default '0',
+ `fa_height` int(5) default '0',
`fa_metadata` mediumblob,
- `fa_bits` int(11) default '0',
+ `fa_bits` int(3) default '0',
`fa_media_type` enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') default NULL,
`fa_major_mime` enum('unknown','application','audio','image','text','video','message','model','multipart') default 'unknown',
- `fa_minor_mime` varbinary(32) default 'unknown',
+ `fa_minor_mime` varchar(32) default 'unknown',
`fa_description` tinyblob,
- `fa_user` int(10) unsigned default '0',
+ `fa_user` int(5) unsigned default '0',
`fa_user_text` varchar(255) character set latin1 collate latin1_bin default '',
- `fa_timestamp` binary(14) default '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
+ `fa_timestamp` char(14) character set latin1 collate latin1_bin default '',
`fa_deleted` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`fa_id`),
KEY `fa_name` (`fa_name`,`fa_timestamp`),
@@ -313,8 +313,8 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `langlinks` (
- `ll_from` int(10) unsigned NOT NULL default '0',
- `ll_lang` varbinary(20) NOT NULL default '',
+ `ll_from` int(8) unsigned NOT NULL default '0',
+ `ll_lang` varchar(10) character set latin1 collate latin1_bin NOT NULL default '',
`ll_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
UNIQUE KEY `ll_from` (`ll_from`,`ll_lang`),
KEY `ll_lang` (`ll_lang`,`ll_title`)
@@ -344,7 +344,7 @@
KEY `user_time` (`log_user`,`log_timestamp`),
KEY `page_time` (`log_namespace`,`log_title`,`log_timestamp`),
KEY `times` (`log_timestamp`)
-) ENGINE=InnoDB AUTO_INCREMENT=1368 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=1404 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -434,7 +434,7 @@
UNIQUE KEY `name_title` (`page_namespace`,`page_title`),
KEY `page_random` (`page_random`),
KEY `page_len` (`page_len`)
-) ENGINE=InnoDB AUTO_INCREMENT=1368 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=1404 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -472,7 +472,7 @@
KEY `pr_typelevel` (`pr_type`,`pr_level`),
KEY `pr_level` (`pr_level`),
KEY `pr_cascade` (`pr_cascade`)
-) ENGINE=InnoDB AUTO_INCREMENT=2735 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -535,8 +535,8 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `querycache_info` (
- `qci_type` varbinary(32) NOT NULL default '',
- `qci_timestamp` binary(14) NOT NULL default '19700101000000',
+ `qci_type` varchar(32) NOT NULL default '',
+ `qci_timestamp` char(14) NOT NULL default '19700101000000',
UNIQUE KEY `qci_type` (`qci_type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
@@ -603,7 +603,7 @@
KEY `rc_ip` (`rc_ip`),
KEY `rc_ns_usertext` (`rc_namespace`,`rc_user_text`),
KEY `rc_user_text` (`rc_user_text`,`rc_timestamp`)
-) ENGINE=InnoDB AUTO_INCREMENT=1368 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=1404 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -647,7 +647,7 @@
KEY `page_timestamp` (`rev_page`,`rev_timestamp`),
KEY `user_timestamp` (`rev_user`,`rev_timestamp`),
KEY `usertext_timestamp` (`rev_user_text`,`rev_timestamp`)
-) ENGINE=InnoDB AUTO_INCREMENT=1368 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=1404 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -734,7 +734,7 @@
`old_text` mediumblob NOT NULL,
`old_flags` tinyblob NOT NULL,
PRIMARY KEY (`old_id`)
-) ENGINE=InnoDB AUTO_INCREMENT=1368 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=1404 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -858,25 +858,6 @@
SET character_set_client = @saved_cs_client;
--
--- Table structure for table `validate`
---
-
-DROP TABLE IF EXISTS `validate`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `validate` (
- `val_user` int(11) NOT NULL default '0',
- `val_page` int(11) unsigned NOT NULL default '0',
- `val_revision` int(11) unsigned NOT NULL default '0',
- `val_type` int(11) unsigned NOT NULL default '0',
- `val_value` int(11) default '0',
- `val_comment` varchar(255) NOT NULL default '',
- `val_ip` varchar(20) NOT NULL default '',
- KEY `val_user` (`val_user`,`val_revision`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
-- Table structure for table `watchlist`
--
@@ -902,4 +883,4 @@
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2009-05-14 8:21:44
+-- Dump completed on 2009-05-14 8:23:03
--- 1.7.sql 2009-05-14 18:23:03.000000000 +1000
+++ 1.8.sql 2009-05-14 18:24:30.000000000 +1000
@@ -1,6 +1,6 @@
-- MySQL dump 10.11
--
--- Host: localhost Database: uptest1_7
+-- Host: localhost Database: uptest1_8
-- ------------------------------------------------------
-- Server version 5.0.75-0ubuntu10
@@ -236,16 +236,16 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `ipblocks` (
- `ipb_id` int(11) NOT NULL auto_increment,
+ `ipb_id` int(8) NOT NULL auto_increment,
`ipb_address` tinyblob NOT NULL,
- `ipb_user` int(10) unsigned NOT NULL default '0',
- `ipb_by` int(10) unsigned NOT NULL default '0',
+ `ipb_user` int(8) unsigned NOT NULL default '0',
+ `ipb_by` int(8) unsigned NOT NULL default '0',
`ipb_reason` tinyblob NOT NULL,
- `ipb_timestamp` binary(14) NOT NULL default '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
+ `ipb_timestamp` char(14) character set latin1 collate latin1_bin NOT NULL default '',
`ipb_auto` tinyint(1) NOT NULL default '0',
`ipb_anon_only` tinyint(1) NOT NULL default '0',
`ipb_create_account` tinyint(1) NOT NULL default '1',
- `ipb_expiry` varbinary(14) NOT NULL default '',
+ `ipb_expiry` char(14) character set latin1 collate latin1_bin NOT NULL default '',
`ipb_range_start` tinyblob NOT NULL,
`ipb_range_end` tinyblob NOT NULL,
`ipb_enable_autoblock` tinyint(1) NOT NULL default '1',
@@ -254,7 +254,7 @@
`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_unique` (`ipb_address`(255),`ipb_user`,`ipb_auto`),
+ UNIQUE KEY `ipb_address` (`ipb_address`(255),`ipb_user`,`ipb_auto`,`ipb_anon_only`),
KEY `ipb_user` (`ipb_user`),
KEY `ipb_range` (`ipb_range_start`(8),`ipb_range_end`(8)),
KEY `ipb_timestamp` (`ipb_timestamp`),
@@ -263,31 +263,6 @@
SET character_set_client = @saved_cs_client;
--
--- Table structure for table `ipblocks_old`
---
-
-DROP TABLE IF EXISTS `ipblocks_old`;
-SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `ipblocks_old` (
- `ipb_id` int(8) NOT NULL auto_increment,
- `ipb_address` varchar(40) character set latin1 collate latin1_bin NOT NULL default '',
- `ipb_user` int(8) unsigned NOT NULL default '0',
- `ipb_by` int(8) unsigned NOT NULL default '0',
- `ipb_reason` tinyblob NOT NULL,
- `ipb_timestamp` char(14) character set latin1 collate latin1_bin NOT NULL default '',
- `ipb_auto` tinyint(1) NOT NULL default '0',
- `ipb_expiry` char(14) character set latin1 collate latin1_bin NOT NULL default '',
- `ipb_range_start` varchar(32) NOT NULL default '',
- `ipb_range_end` varchar(32) NOT NULL default '',
- PRIMARY KEY (`ipb_id`),
- KEY `ipb_address` (`ipb_address`),
- KEY `ipb_user` (`ipb_user`),
- KEY `ipb_range` (`ipb_range_start`(8),`ipb_range_end`(8))
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
-
---
-- Table structure for table `job`
--
@@ -344,7 +319,7 @@
KEY `user_time` (`log_user`,`log_timestamp`),
KEY `page_time` (`log_namespace`,`log_title`,`log_timestamp`),
KEY `times` (`log_timestamp`)
-) ENGINE=InnoDB AUTO_INCREMENT=1404 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=1496 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -434,7 +409,7 @@
UNIQUE KEY `name_title` (`page_namespace`,`page_title`),
KEY `page_random` (`page_random`),
KEY `page_len` (`page_len`)
-) ENGINE=InnoDB AUTO_INCREMENT=1404 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=1496 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -603,7 +578,7 @@
KEY `rc_ip` (`rc_ip`),
KEY `rc_ns_usertext` (`rc_namespace`,`rc_user_text`),
KEY `rc_user_text` (`rc_user_text`,`rc_timestamp`)
-) ENGINE=InnoDB AUTO_INCREMENT=1404 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=1496 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -647,7 +622,7 @@
KEY `page_timestamp` (`rev_page`,`rev_timestamp`),
KEY `user_timestamp` (`rev_user`,`rev_timestamp`),
KEY `usertext_timestamp` (`rev_user_text`,`rev_timestamp`)
-) ENGINE=InnoDB AUTO_INCREMENT=1404 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=1496 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -734,7 +709,7 @@
`old_text` mediumblob NOT NULL,
`old_flags` tinyblob NOT NULL,
PRIMARY KEY (`old_id`)
-) ENGINE=InnoDB AUTO_INCREMENT=1404 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=1496 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -841,7 +816,7 @@
`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`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -883,4 +858,4 @@
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2009-05-14 8:23:03
+-- Dump completed on 2009-05-14 8:24:30
--- 1.8.sql 2009-05-14 18:24:30.000000000 +1000
+++ 1.9.sql 2009-05-14 18:24:38.000000000 +1000
@@ -1,6 +1,6 @@
-- MySQL dump 10.11
--
--- Host: localhost Database: uptest1_8
+-- Host: localhost Database: uptest1_9
-- ------------------------------------------------------
-- Server version 5.0.75-0ubuntu10
@@ -144,7 +144,7 @@
`fa_minor_mime` varchar(32) default 'unknown',
`fa_description` tinyblob,
`fa_user` int(5) unsigned default '0',
- `fa_user_text` varchar(255) character set latin1 collate latin1_bin default '',
+ `fa_user_text` varchar(255) character set latin1 collate latin1_bin default NULL,
`fa_timestamp` char(14) character set latin1 collate latin1_bin default '',
`fa_deleted` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`fa_id`),
@@ -186,7 +186,7 @@
`img_minor_mime` varchar(32) NOT NULL default 'unknown',
`img_description` tinyblob NOT NULL,
`img_user` int(5) unsigned NOT NULL default '0',
- `img_user_text` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
+ `img_user_text` varchar(255) character set latin1 collate latin1_bin NOT NULL,
`img_timestamp` char(14) character set latin1 collate latin1_bin NOT NULL default '',
`img_sha1` varbinary(32) NOT NULL default '',
PRIMARY KEY (`img_name`),
@@ -245,10 +245,10 @@
`ipb_auto` tinyint(1) NOT NULL default '0',
`ipb_anon_only` tinyint(1) NOT NULL default '0',
`ipb_create_account` tinyint(1) NOT NULL default '1',
+ `ipb_enable_autoblock` tinyint(1) NOT NULL default '1',
`ipb_expiry` char(14) character set latin1 collate latin1_bin NOT NULL default '',
`ipb_range_start` tinyblob NOT NULL,
`ipb_range_end` tinyblob NOT NULL,
- `ipb_enable_autoblock` tinyint(1) NOT NULL default '1',
`ipb_deleted` tinyint(1) NOT NULL default '0',
`ipb_block_email` tinyint(4) NOT NULL default '0',
`ipb_by_text` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
@@ -319,7 +319,7 @@
KEY `user_time` (`log_user`,`log_timestamp`),
KEY `page_time` (`log_namespace`,`log_title`,`log_timestamp`),
KEY `times` (`log_timestamp`)
-) ENGINE=InnoDB AUTO_INCREMENT=1496 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -371,7 +371,7 @@
`oi_bits` int(3) NOT NULL default '0',
`oi_description` tinyblob NOT NULL,
`oi_user` int(5) unsigned NOT NULL default '0',
- `oi_user_text` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
+ `oi_user_text` varchar(255) character set latin1 collate latin1_bin NOT NULL,
`oi_timestamp` char(14) character set latin1 collate latin1_bin NOT NULL default '',
`oi_metadata` mediumblob NOT NULL,
`oi_media_type` enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') default NULL,
@@ -409,7 +409,7 @@
UNIQUE KEY `name_title` (`page_namespace`,`page_title`),
KEY `page_random` (`page_random`),
KEY `page_len` (`page_len`)
-) ENGINE=InnoDB AUTO_INCREMENT=1496 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -524,12 +524,12 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `querycachetwo` (
- `qcc_type` varbinary(32) NOT NULL,
- `qcc_value` int(10) unsigned NOT NULL default '0',
+ `qcc_type` char(32) NOT NULL,
+ `qcc_value` int(5) unsigned NOT NULL default '0',
`qcc_namespace` int(11) NOT NULL default '0',
- `qcc_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
+ `qcc_title` char(255) character set latin1 collate latin1_bin NOT NULL default '',
`qcc_namespacetwo` int(11) NOT NULL default '0',
- `qcc_titletwo` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
+ `qcc_titletwo` char(255) character set latin1 collate latin1_bin NOT NULL default '',
KEY `qcc_type` (`qcc_type`,`qcc_value`),
KEY `qcc_title` (`qcc_type`,`qcc_namespace`,`qcc_title`),
KEY `qcc_titletwo` (`qcc_type`,`qcc_namespacetwo`,`qcc_titletwo`)
@@ -548,7 +548,7 @@
`rc_timestamp` varchar(14) character set latin1 collate latin1_bin NOT NULL default '',
`rc_cur_time` varchar(14) character set latin1 collate latin1_bin NOT NULL default '',
`rc_user` int(10) unsigned NOT NULL default '0',
- `rc_user_text` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
+ `rc_user_text` varchar(255) character set latin1 collate latin1_bin NOT NULL,
`rc_namespace` int(11) NOT NULL default '0',
`rc_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
`rc_comment` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
@@ -563,8 +563,8 @@
`rc_moved_to_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
`rc_patrolled` tinyint(3) unsigned NOT NULL default '0',
`rc_ip` char(15) NOT NULL default '',
- `rc_old_len` int(11) default NULL,
- `rc_new_len` int(11) default NULL,
+ `rc_old_len` int(10) default NULL,
+ `rc_new_len` int(10) default NULL,
`rc_deleted` tinyint(3) unsigned NOT NULL default '0',
`rc_logid` int(10) unsigned NOT NULL default '0',
`rc_log_type` varbinary(255) default NULL,
@@ -578,7 +578,7 @@
KEY `rc_ip` (`rc_ip`),
KEY `rc_ns_usertext` (`rc_namespace`,`rc_user_text`),
KEY `rc_user_text` (`rc_user_text`,`rc_timestamp`)
-) ENGINE=InnoDB AUTO_INCREMENT=1496 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -589,7 +589,7 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `redirect` (
- `rd_from` int(10) unsigned NOT NULL default '0',
+ `rd_from` int(8) unsigned NOT NULL default '0',
`rd_namespace` int(11) NOT NULL default '0',
`rd_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
PRIMARY KEY (`rd_from`),
@@ -622,7 +622,7 @@
KEY `page_timestamp` (`rev_page`,`rev_timestamp`),
KEY `user_timestamp` (`rev_user`,`rev_timestamp`),
KEY `usertext_timestamp` (`rev_user_text`,`rev_timestamp`)
-) ENGINE=InnoDB AUTO_INCREMENT=1496 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -709,7 +709,7 @@
`old_text` mediumblob NOT NULL,
`old_flags` tinyblob NOT NULL,
PRIMARY KEY (`old_id`)
-) ENGINE=InnoDB AUTO_INCREMENT=1496 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -772,6 +772,7 @@
`user_real_name` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
`user_password` tinyblob NOT NULL,
`user_newpassword` tinyblob NOT NULL,
+ `user_newpass_time` char(14) character set latin1 collate latin1_bin default NULL,
`user_email` tinytext NOT NULL,
`user_options` blob NOT NULL,
`user_touched` char(14) character set latin1 collate latin1_bin NOT NULL default '',
@@ -780,7 +781,6 @@
`user_email_token` char(32) character set latin1 collate latin1_bin default NULL,
`user_email_token_expires` char(14) character set latin1 collate latin1_bin default NULL,
`user_registration` char(14) character set latin1 collate latin1_bin default NULL,
- `user_newpass_time` binary(14) default NULL,
`user_editcount` int(11) default NULL,
PRIMARY KEY (`user_id`),
UNIQUE KEY `user_name` (`user_name`),
@@ -858,4 +858,4 @@
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2009-05-14 8:24:30
+-- Dump completed on 2009-05-14 8:24:38
--- 1.9.sql 2009-05-14 18:24:38.000000000 +1000
+++ 1.10.sql 2009-05-14 18:24:46.000000000 +1000
@@ -1,6 +1,6 @@
-- MySQL dump 10.11
--
--- Host: localhost Database: uptest1_9
+-- Host: localhost Database: uptest1_10
-- ------------------------------------------------------
-- Server version 5.0.75-0ubuntu10
@@ -27,20 +27,20 @@
`ar_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
`ar_text` mediumblob NOT NULL,
`ar_comment` tinyblob NOT NULL,
- `ar_user` int(5) unsigned NOT NULL default '0',
+ `ar_user` int(10) unsigned NOT NULL default '0',
`ar_user_text` varchar(255) character set latin1 collate latin1_bin NOT NULL,
- `ar_timestamp` char(14) character set latin1 collate latin1_bin NOT NULL default '',
- `ar_minor_edit` tinyint(1) NOT NULL default '0',
+ `ar_timestamp` binary(14) NOT NULL default '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
+ `ar_minor_edit` tinyint(4) NOT NULL default '0',
`ar_flags` tinyblob NOT NULL,
- `ar_rev_id` int(8) unsigned default NULL,
- `ar_text_id` int(8) unsigned default NULL,
+ `ar_rev_id` int(10) unsigned default NULL,
+ `ar_text_id` int(10) unsigned default NULL,
`ar_deleted` tinyint(3) unsigned NOT NULL default '0',
`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`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -71,14 +71,14 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `categorylinks` (
- `cl_from` int(8) unsigned NOT NULL default '0',
+ `cl_from` int(10) unsigned NOT NULL default '0',
`cl_to` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
- `cl_sortkey` varchar(86) character set latin1 collate latin1_bin NOT NULL default '',
+ `cl_sortkey` varchar(70) character set latin1 collate latin1_bin NOT NULL default '',
`cl_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
UNIQUE KEY `cl_from` (`cl_from`,`cl_to`),
KEY `cl_timestamp` (`cl_to`,`cl_timestamp`),
KEY `cl_sortkey` (`cl_to`,`cl_sortkey`,`cl_from`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -109,13 +109,13 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `externallinks` (
- `el_from` int(8) unsigned NOT NULL default '0',
+ `el_from` int(10) unsigned NOT NULL default '0',
`el_to` blob NOT NULL,
`el_index` blob NOT NULL,
KEY `el_from` (`el_from`,`el_to`(40)),
KEY `el_to` (`el_to`(60),`el_from`),
KEY `el_index` (`el_index`(60))
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -129,30 +129,30 @@
`fa_id` int(11) NOT NULL auto_increment,
`fa_name` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
`fa_archive_name` varchar(255) character set latin1 collate latin1_bin default '',
- `fa_storage_group` varchar(16) default NULL,
- `fa_storage_key` varchar(64) character set latin1 collate latin1_bin default '',
+ `fa_storage_group` varbinary(16) default NULL,
+ `fa_storage_key` varbinary(64) default '',
`fa_deleted_user` int(11) default NULL,
- `fa_deleted_timestamp` char(14) character set latin1 collate latin1_bin default '',
+ `fa_deleted_timestamp` binary(14) default '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
`fa_deleted_reason` text,
- `fa_size` int(8) unsigned default '0',
- `fa_width` int(5) default '0',
- `fa_height` int(5) default '0',
+ `fa_size` int(10) unsigned default '0',
+ `fa_width` int(11) default '0',
+ `fa_height` int(11) default '0',
`fa_metadata` mediumblob,
- `fa_bits` int(3) default '0',
+ `fa_bits` int(11) default '0',
`fa_media_type` enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') default NULL,
`fa_major_mime` enum('unknown','application','audio','image','text','video','message','model','multipart') default 'unknown',
- `fa_minor_mime` varchar(32) default 'unknown',
+ `fa_minor_mime` varbinary(32) default 'unknown',
`fa_description` tinyblob,
- `fa_user` int(5) unsigned default '0',
+ `fa_user` int(10) unsigned default '0',
`fa_user_text` varchar(255) character set latin1 collate latin1_bin default NULL,
- `fa_timestamp` char(14) character set latin1 collate latin1_bin default '',
+ `fa_timestamp` binary(14) default '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
`fa_deleted` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`fa_id`),
KEY `fa_name` (`fa_name`,`fa_timestamp`),
KEY `fa_storage_group` (`fa_storage_group`,`fa_storage_key`),
KEY `fa_deleted_timestamp` (`fa_deleted_timestamp`),
KEY `fa_user_timestamp` (`fa_user_text`,`fa_timestamp`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -176,25 +176,25 @@
SET character_set_client = utf8;
CREATE TABLE `image` (
`img_name` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
- `img_size` int(8) unsigned NOT NULL default '0',
- `img_width` int(5) NOT NULL default '0',
- `img_height` int(5) NOT NULL default '0',
+ `img_size` int(10) unsigned NOT NULL default '0',
+ `img_width` int(11) NOT NULL default '0',
+ `img_height` int(11) NOT NULL default '0',
`img_metadata` mediumblob NOT NULL,
- `img_bits` int(3) NOT NULL default '0',
+ `img_bits` int(11) NOT NULL default '0',
`img_media_type` enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') default NULL,
`img_major_mime` enum('unknown','application','audio','image','text','video','message','model','multipart') NOT NULL default 'unknown',
- `img_minor_mime` varchar(32) NOT NULL default 'unknown',
+ `img_minor_mime` varbinary(32) NOT NULL default 'unknown',
`img_description` tinyblob NOT NULL,
- `img_user` int(5) unsigned NOT NULL default '0',
+ `img_user` int(10) unsigned NOT NULL default '0',
`img_user_text` varchar(255) character set latin1 collate latin1_bin NOT NULL,
- `img_timestamp` char(14) character set latin1 collate latin1_bin NOT NULL default '',
+ `img_timestamp` varbinary(14) NOT NULL default '',
`img_sha1` varbinary(32) NOT NULL default '',
PRIMARY KEY (`img_name`),
KEY `img_size` (`img_size`),
KEY `img_timestamp` (`img_timestamp`),
KEY `img_usertext_timestamp` (`img_user_text`,`img_timestamp`),
KEY `img_sha1` (`img_sha1`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -205,11 +205,11 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `imagelinks` (
- `il_from` int(8) unsigned NOT NULL default '0',
+ `il_from` int(10) unsigned NOT NULL default '0',
`il_to` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
UNIQUE KEY `il_from` (`il_from`,`il_to`),
UNIQUE KEY `il_to` (`il_to`,`il_from`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -220,12 +220,12 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `interwiki` (
- `iw_prefix` char(32) NOT NULL,
- `iw_url` char(127) NOT NULL,
+ `iw_prefix` varchar(32) NOT NULL,
+ `iw_url` blob NOT NULL,
`iw_local` tinyint(1) NOT NULL,
- `iw_trans` tinyint(1) NOT NULL default '0',
+ `iw_trans` tinyint(4) NOT NULL default '0',
UNIQUE KEY `iw_prefix` (`iw_prefix`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -236,17 +236,17 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `ipblocks` (
- `ipb_id` int(8) NOT NULL auto_increment,
+ `ipb_id` int(11) NOT NULL auto_increment,
`ipb_address` tinyblob NOT NULL,
- `ipb_user` int(8) unsigned NOT NULL default '0',
- `ipb_by` int(8) unsigned NOT NULL default '0',
+ `ipb_user` int(10) unsigned NOT NULL default '0',
+ `ipb_by` int(10) unsigned NOT NULL default '0',
`ipb_reason` tinyblob NOT NULL,
- `ipb_timestamp` char(14) character set latin1 collate latin1_bin NOT NULL default '',
+ `ipb_timestamp` binary(14) NOT NULL default '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
`ipb_auto` tinyint(1) NOT NULL default '0',
`ipb_anon_only` tinyint(1) NOT NULL default '0',
`ipb_create_account` tinyint(1) NOT NULL default '1',
`ipb_enable_autoblock` tinyint(1) NOT NULL default '1',
- `ipb_expiry` char(14) character set latin1 collate latin1_bin NOT NULL default '',
+ `ipb_expiry` varbinary(14) NOT NULL default '',
`ipb_range_start` tinyblob NOT NULL,
`ipb_range_end` tinyblob NOT NULL,
`ipb_deleted` tinyint(1) NOT NULL default '0',
@@ -259,7 +259,7 @@
KEY `ipb_range` (`ipb_range_start`(8),`ipb_range_end`(8)),
KEY `ipb_timestamp` (`ipb_timestamp`),
KEY `ipb_expiry` (`ipb_expiry`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -270,14 +270,14 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `job` (
- `job_id` int(9) unsigned NOT NULL auto_increment,
- `job_cmd` varchar(255) NOT NULL default '',
+ `job_id` int(10) unsigned NOT NULL auto_increment,
+ `job_cmd` varbinary(60) NOT NULL default '',
`job_namespace` int(11) NOT NULL,
`job_title` varchar(255) character set latin1 collate latin1_bin NOT NULL,
`job_params` blob NOT NULL,
PRIMARY KEY (`job_id`),
KEY `job_cmd` (`job_cmd`,`job_namespace`,`job_title`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -288,12 +288,12 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `langlinks` (
- `ll_from` int(8) unsigned NOT NULL default '0',
- `ll_lang` varchar(10) character set latin1 collate latin1_bin NOT NULL default '',
+ `ll_from` int(10) unsigned NOT NULL default '0',
+ `ll_lang` varbinary(20) NOT NULL default '',
`ll_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
UNIQUE KEY `ll_from` (`ll_from`,`ll_lang`),
KEY `ll_lang` (`ll_lang`,`ll_title`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -304,9 +304,9 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `logging` (
- `log_type` char(10) NOT NULL default '',
- `log_action` char(10) NOT NULL default '',
- `log_timestamp` char(14) NOT NULL default '19700101000000',
+ `log_type` varbinary(10) NOT NULL default '',
+ `log_action` varbinary(10) NOT NULL default '',
+ `log_timestamp` binary(14) NOT NULL default '19700101000000',
`log_user` int(10) unsigned NOT NULL default '0',
`log_namespace` int(11) NOT NULL default '0',
`log_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
@@ -319,7 +319,7 @@
KEY `user_time` (`log_user`,`log_timestamp`),
KEY `page_time` (`log_namespace`,`log_title`,`log_timestamp`),
KEY `times` (`log_timestamp`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -330,13 +330,13 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `math` (
- `math_inputhash` varchar(16) NOT NULL,
- `math_outputhash` varchar(16) NOT NULL,
- `math_html_conservativeness` tinyint(1) NOT NULL,
+ `math_inputhash` varbinary(16) NOT NULL,
+ `math_outputhash` varbinary(16) NOT NULL,
+ `math_html_conservativeness` tinyint(4) NOT NULL,
`math_html` text,
`math_mathml` text,
UNIQUE KEY `math_inputhash` (`math_inputhash`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -347,12 +347,12 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `objectcache` (
- `keyname` char(255) character set latin1 collate latin1_bin NOT NULL default '',
+ `keyname` varbinary(255) NOT NULL default '',
`value` mediumblob,
`exptime` datetime default NULL,
UNIQUE KEY `keyname` (`keyname`),
KEY `exptime` (`exptime`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -365,14 +365,14 @@
CREATE TABLE `oldimage` (
`oi_name` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
`oi_archive_name` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
- `oi_size` int(8) unsigned NOT NULL default '0',
- `oi_width` int(5) NOT NULL default '0',
- `oi_height` int(5) NOT NULL default '0',
- `oi_bits` int(3) NOT NULL default '0',
+ `oi_size` int(10) unsigned NOT NULL default '0',
+ `oi_width` int(11) NOT NULL default '0',
+ `oi_height` int(11) NOT NULL default '0',
+ `oi_bits` int(11) NOT NULL default '0',
`oi_description` tinyblob NOT NULL,
- `oi_user` int(5) unsigned NOT NULL default '0',
+ `oi_user` int(10) unsigned NOT NULL default '0',
`oi_user_text` varchar(255) character set latin1 collate latin1_bin NOT NULL,
- `oi_timestamp` char(14) character set latin1 collate latin1_bin NOT NULL default '',
+ `oi_timestamp` binary(14) NOT NULL default '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
`oi_metadata` mediumblob NOT NULL,
`oi_media_type` enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') default NULL,
`oi_major_mime` enum('unknown','application','audio','image','text','video','message','model','multipart') NOT NULL default 'unknown',
@@ -383,7 +383,7 @@
KEY `oi_name_archive_name` (`oi_name`,`oi_archive_name`(14)),
KEY `oi_usertext_timestamp` (`oi_user_text`,`oi_timestamp`),
KEY `oi_sha1` (`oi_sha1`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -394,22 +394,22 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `page` (
- `page_id` int(8) unsigned NOT NULL auto_increment,
+ `page_id` int(10) unsigned NOT NULL auto_increment,
`page_namespace` int(11) NOT NULL,
`page_title` varchar(255) character set latin1 collate latin1_bin NOT NULL,
`page_restrictions` tinyblob NOT NULL,
`page_counter` bigint(20) unsigned NOT NULL default '0',
- `page_is_redirect` tinyint(1) unsigned NOT NULL default '0',
- `page_is_new` tinyint(1) unsigned NOT NULL default '0',
+ `page_is_redirect` tinyint(3) unsigned NOT NULL default '0',
+ `page_is_new` tinyint(3) unsigned NOT NULL default '0',
`page_random` double unsigned NOT NULL,
- `page_touched` char(14) character set latin1 collate latin1_bin NOT NULL default '',
- `page_latest` int(8) unsigned NOT NULL,
- `page_len` int(8) unsigned NOT NULL,
+ `page_touched` binary(14) NOT NULL default '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
+ `page_latest` int(10) unsigned NOT NULL,
+ `page_len` int(10) unsigned NOT NULL,
PRIMARY KEY (`page_id`),
UNIQUE KEY `name_title` (`page_namespace`,`page_title`),
KEY `page_random` (`page_random`),
KEY `page_len` (`page_len`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -444,10 +444,11 @@
`pr_id` int(10) unsigned NOT NULL auto_increment,
PRIMARY KEY (`pr_page`,`pr_type`),
UNIQUE KEY `pr_id` (`pr_id`),
+ KEY `pr_page` (`pr_page`),
KEY `pr_typelevel` (`pr_type`,`pr_level`),
KEY `pr_level` (`pr_level`),
KEY `pr_cascade` (`pr_cascade`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -458,12 +459,12 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `pagelinks` (
- `pl_from` int(8) unsigned NOT NULL default '0',
+ `pl_from` int(10) unsigned NOT NULL default '0',
`pl_namespace` int(11) NOT NULL default '0',
`pl_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
UNIQUE KEY `pl_from` (`pl_from`,`pl_namespace`,`pl_title`),
UNIQUE KEY `pl_namespace` (`pl_namespace`,`pl_title`,`pl_from`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -494,12 +495,12 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `querycache` (
- `qc_type` char(32) NOT NULL,
- `qc_value` int(5) unsigned NOT NULL default '0',
+ `qc_type` varbinary(32) NOT NULL,
+ `qc_value` int(10) unsigned NOT NULL default '0',
`qc_namespace` int(11) NOT NULL default '0',
`qc_title` char(255) character set latin1 collate latin1_bin NOT NULL default '',
KEY `qc_type` (`qc_type`,`qc_value`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -510,10 +511,10 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `querycache_info` (
- `qci_type` varchar(32) NOT NULL default '',
- `qci_timestamp` char(14) NOT NULL default '19700101000000',
+ `qci_type` varbinary(32) NOT NULL default '',
+ `qci_timestamp` binary(14) NOT NULL default '19700101000000',
UNIQUE KEY `qci_type` (`qci_type`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -524,8 +525,8 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `querycachetwo` (
- `qcc_type` char(32) NOT NULL,
- `qcc_value` int(5) unsigned NOT NULL default '0',
+ `qcc_type` varbinary(32) NOT NULL,
+ `qcc_value` int(10) unsigned NOT NULL default '0',
`qcc_namespace` int(11) NOT NULL default '0',
`qcc_title` char(255) character set latin1 collate latin1_bin NOT NULL default '',
`qcc_namespacetwo` int(11) NOT NULL default '0',
@@ -533,7 +534,7 @@
KEY `qcc_type` (`qcc_type`,`qcc_value`),
KEY `qcc_title` (`qcc_type`,`qcc_namespace`,`qcc_title`),
KEY `qcc_titletwo` (`qcc_type`,`qcc_namespacetwo`,`qcc_titletwo`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -544,9 +545,9 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `recentchanges` (
- `rc_id` int(8) NOT NULL auto_increment,
- `rc_timestamp` varchar(14) character set latin1 collate latin1_bin NOT NULL default '',
- `rc_cur_time` varchar(14) character set latin1 collate latin1_bin NOT NULL default '',
+ `rc_id` int(11) NOT NULL auto_increment,
+ `rc_timestamp` varbinary(14) NOT NULL default '',
+ `rc_cur_time` varbinary(14) NOT NULL default '',
`rc_user` int(10) unsigned NOT NULL default '0',
`rc_user_text` varchar(255) character set latin1 collate latin1_bin NOT NULL,
`rc_namespace` int(11) NOT NULL default '0',
@@ -562,14 +563,14 @@
`rc_moved_to_ns` tinyint(3) unsigned NOT NULL default '0',
`rc_moved_to_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
`rc_patrolled` tinyint(3) unsigned NOT NULL default '0',
- `rc_ip` char(15) NOT NULL default '',
- `rc_old_len` int(10) default NULL,
- `rc_new_len` int(10) default NULL,
+ `rc_ip` varbinary(40) NOT NULL default '',
+ `rc_old_len` int(11) default NULL,
+ `rc_new_len` int(11) default NULL,
`rc_deleted` tinyint(3) unsigned NOT NULL default '0',
`rc_logid` int(10) unsigned NOT NULL default '0',
`rc_log_type` varbinary(255) default NULL,
`rc_log_action` varbinary(255) default NULL,
- `rc_params` blob,
+ `rc_params` blob NOT NULL,
PRIMARY KEY (`rc_id`),
KEY `rc_timestamp` (`rc_timestamp`),
KEY `rc_namespace_title` (`rc_namespace`,`rc_title`),
@@ -578,7 +579,7 @@
KEY `rc_ip` (`rc_ip`),
KEY `rc_ns_usertext` (`rc_namespace`,`rc_user_text`),
KEY `rc_user_text` (`rc_user_text`,`rc_timestamp`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -589,12 +590,12 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `redirect` (
- `rd_from` int(8) unsigned NOT NULL default '0',
+ `rd_from` int(10) unsigned NOT NULL default '0',
`rd_namespace` int(11) NOT NULL default '0',
`rd_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
PRIMARY KEY (`rd_from`),
KEY `rd_ns_title` (`rd_namespace`,`rd_title`,`rd_from`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -605,24 +606,24 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `revision` (
- `rev_id` int(8) unsigned NOT NULL auto_increment,
- `rev_page` int(8) unsigned NOT NULL,
- `rev_text_id` int(8) unsigned NOT NULL,
+ `rev_id` int(10) unsigned NOT NULL auto_increment,
+ `rev_page` int(10) unsigned NOT NULL,
+ `rev_text_id` int(10) unsigned NOT NULL,
`rev_comment` tinyblob NOT NULL,
- `rev_user` int(5) unsigned NOT NULL default '0',
+ `rev_user` int(10) unsigned NOT NULL default '0',
`rev_user_text` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
- `rev_timestamp` char(14) character set latin1 collate latin1_bin NOT NULL default '',
- `rev_minor_edit` tinyint(1) unsigned NOT NULL default '0',
- `rev_deleted` tinyint(1) unsigned NOT NULL default '0',
- `rev_parent_id` int(10) unsigned default NULL,
+ `rev_timestamp` binary(14) NOT NULL default '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
+ `rev_minor_edit` tinyint(3) unsigned NOT NULL default '0',
+ `rev_deleted` tinyint(3) unsigned NOT NULL default '0',
`rev_len` int(10) unsigned default NULL,
+ `rev_parent_id` int(10) unsigned default NULL,
PRIMARY KEY (`rev_page`,`rev_id`),
UNIQUE KEY `rev_id` (`rev_id`),
KEY `rev_timestamp` (`rev_timestamp`),
KEY `page_timestamp` (`rev_page`,`rev_timestamp`),
KEY `user_timestamp` (`rev_user`,`rev_timestamp`),
KEY `usertext_timestamp` (`rev_user_text`,`rev_timestamp`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 MAX_ROWS=10000000 AVG_ROW_LENGTH=1024;
SET character_set_client = @saved_cs_client;
--
@@ -633,7 +634,7 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `searchindex` (
- `si_page` int(8) unsigned NOT NULL,
+ `si_page` int(10) unsigned NOT NULL,
`si_title` varchar(255) NOT NULL default '',
`si_text` mediumtext NOT NULL,
UNIQUE KEY `si_page` (`si_page`),
@@ -650,17 +651,17 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `site_stats` (
- `ss_row_id` int(8) unsigned NOT NULL,
+ `ss_row_id` int(10) unsigned NOT NULL,
`ss_total_views` bigint(20) unsigned default '0',
`ss_total_edits` bigint(20) unsigned default '0',
`ss_good_articles` bigint(20) unsigned default '0',
`ss_total_pages` bigint(20) default '-1',
`ss_users` bigint(20) default '-1',
- `ss_admins` int(10) default '-1',
- `ss_images` int(10) default '0',
+ `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;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -689,12 +690,12 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `templatelinks` (
- `tl_from` int(8) unsigned NOT NULL default '0',
+ `tl_from` int(10) unsigned NOT NULL default '0',
`tl_namespace` int(11) NOT NULL default '0',
`tl_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
UNIQUE KEY `tl_from` (`tl_from`,`tl_namespace`,`tl_title`),
UNIQUE KEY `tl_namespace` (`tl_namespace`,`tl_title`,`tl_from`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -705,11 +706,11 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `text` (
- `old_id` int(8) unsigned NOT NULL auto_increment,
+ `old_id` int(10) unsigned NOT NULL auto_increment,
`old_text` mediumblob NOT NULL,
`old_flags` tinyblob NOT NULL,
PRIMARY KEY (`old_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 MAX_ROWS=10000000 AVG_ROW_LENGTH=10240;
SET character_set_client = @saved_cs_client;
--
@@ -723,12 +724,12 @@
`tb_id` int(11) NOT NULL auto_increment,
`tb_page` int(11) default NULL,
`tb_title` varchar(255) NOT NULL,
- `tb_url` varchar(255) NOT NULL,
+ `tb_url` blob NOT NULL,
`tb_ex` text,
`tb_name` varchar(255) default NULL,
PRIMARY KEY (`tb_id`),
KEY `tb_page` (`tb_page`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -739,11 +740,11 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `transcache` (
- `tc_url` varchar(255) NOT NULL,
+ `tc_url` varbinary(255) NOT NULL,
`tc_contents` text,
`tc_time` int(11) NOT NULL,
UNIQUE KEY `tc_url_idx` (`tc_url`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -767,25 +768,25 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `user` (
- `user_id` int(5) unsigned NOT NULL auto_increment,
+ `user_id` int(10) unsigned NOT NULL auto_increment,
`user_name` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
`user_real_name` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
`user_password` tinyblob NOT NULL,
`user_newpassword` tinyblob NOT NULL,
- `user_newpass_time` char(14) character set latin1 collate latin1_bin default NULL,
+ `user_newpass_time` binary(14) default NULL,
`user_email` tinytext NOT NULL,
`user_options` blob NOT NULL,
- `user_touched` char(14) character set latin1 collate latin1_bin NOT NULL default '',
- `user_token` char(32) character set latin1 collate latin1_bin NOT NULL default '',
- `user_email_authenticated` char(14) character set latin1 collate latin1_bin default NULL,
- `user_email_token` char(32) character set latin1 collate latin1_bin default NULL,
- `user_email_token_expires` char(14) character set latin1 collate latin1_bin default NULL,
- `user_registration` char(14) character set latin1 collate latin1_bin default NULL,
+ `user_touched` binary(14) NOT NULL default '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
+ `user_token` binary(32) NOT NULL default '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
+ `user_email_authenticated` binary(14) default NULL,
+ `user_email_token` binary(32) default NULL,
+ `user_email_token_expires` binary(14) default NULL,
+ `user_registration` binary(14) default NULL,
`user_editcount` int(11) default NULL,
PRIMARY KEY (`user_id`),
UNIQUE KEY `user_name` (`user_name`),
KEY `user_email_token` (`user_email_token`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -796,11 +797,11 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `user_groups` (
- `ug_user` int(5) unsigned NOT NULL default '0',
- `ug_group` char(16) NOT NULL default '',
+ `ug_user` int(10) unsigned NOT NULL default '0',
+ `ug_group` varbinary(16) NOT NULL default '',
PRIMARY KEY (`ug_user`,`ug_group`),
KEY `ug_group` (`ug_group`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -811,12 +812,12 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `user_newtalk` (
- `user_id` int(5) NOT NULL default '0',
- `user_ip` varchar(40) NOT NULL default '',
+ `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`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -840,13 +841,13 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `watchlist` (
- `wl_user` int(5) unsigned NOT NULL,
+ `wl_user` int(10) unsigned NOT NULL,
`wl_namespace` int(11) NOT NULL default '0',
`wl_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
- `wl_notificationtimestamp` varchar(14) character set latin1 collate latin1_bin default NULL,
+ `wl_notificationtimestamp` varbinary(14) default NULL,
UNIQUE KEY `wl_user` (`wl_user`,`wl_namespace`,`wl_title`),
KEY `namespace_title` (`wl_namespace`,`wl_title`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -858,4 +859,4 @@
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2009-05-14 8:24:38
+-- Dump completed on 2009-05-14 8:24:46
--- 1.10.sql 2009-05-14 18:24:46.000000000 +1000
+++ 1.11.sql 2009-05-14 18:24:54.000000000 +1000
@@ -1,6 +1,6 @@
-- MySQL dump 10.11
--
--- Host: localhost Database: uptest1_10
+-- Host: localhost Database: uptest1_11
-- ------------------------------------------------------
-- Server version 5.0.75-0ubuntu10
@@ -76,8 +76,8 @@
`cl_sortkey` varchar(70) character set latin1 collate latin1_bin NOT NULL default '',
`cl_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
UNIQUE KEY `cl_from` (`cl_from`,`cl_to`),
- KEY `cl_timestamp` (`cl_to`,`cl_timestamp`),
- KEY `cl_sortkey` (`cl_to`,`cl_sortkey`,`cl_from`)
+ KEY `cl_sortkey` (`cl_to`,`cl_sortkey`,`cl_from`),
+ KEY `cl_timestamp` (`cl_to`,`cl_timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
@@ -190,9 +190,9 @@
`img_timestamp` varbinary(14) NOT NULL default '',
`img_sha1` varbinary(32) NOT NULL default '',
PRIMARY KEY (`img_name`),
+ KEY `img_usertext_timestamp` (`img_user_text`,`img_timestamp`),
KEY `img_size` (`img_size`),
KEY `img_timestamp` (`img_timestamp`),
- KEY `img_usertext_timestamp` (`img_user_text`,`img_timestamp`),
KEY `img_sha1` (`img_sha1`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
@@ -250,7 +250,7 @@
`ipb_range_start` tinyblob NOT NULL,
`ipb_range_end` tinyblob NOT NULL,
`ipb_deleted` tinyint(1) NOT NULL default '0',
- `ipb_block_email` tinyint(4) 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`),
@@ -379,9 +379,9 @@
`oi_minor_mime` varbinary(32) NOT NULL default 'unknown',
`oi_deleted` tinyint(3) unsigned NOT NULL default '0',
`oi_sha1` varbinary(32) NOT NULL default '',
+ KEY `oi_usertext_timestamp` (`oi_user_text`,`oi_timestamp`),
KEY `oi_name_timestamp` (`oi_name`,`oi_timestamp`),
KEY `oi_name_archive_name` (`oi_name`,`oi_archive_name`(14)),
- KEY `oi_usertext_timestamp` (`oi_user_text`,`oi_timestamp`),
KEY `oi_sha1` (`oi_sha1`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
@@ -444,7 +444,6 @@
`pr_id` int(10) unsigned NOT NULL auto_increment,
PRIMARY KEY (`pr_page`,`pr_type`),
UNIQUE KEY `pr_id` (`pr_id`),
- KEY `pr_page` (`pr_page`),
KEY `pr_typelevel` (`pr_type`,`pr_level`),
KEY `pr_level` (`pr_level`),
KEY `pr_cascade` (`pr_cascade`)
@@ -498,7 +497,7 @@
`qc_type` varbinary(32) NOT NULL,
`qc_value` int(10) unsigned NOT NULL default '0',
`qc_namespace` int(11) NOT NULL default '0',
- `qc_title` char(255) character set latin1 collate latin1_bin NOT NULL default '',
+ `qc_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
KEY `qc_type` (`qc_type`,`qc_value`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
@@ -528,9 +527,9 @@
`qcc_type` varbinary(32) NOT NULL,
`qcc_value` int(10) unsigned NOT NULL default '0',
`qcc_namespace` int(11) NOT NULL default '0',
- `qcc_title` char(255) character set latin1 collate latin1_bin NOT NULL default '',
+ `qcc_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
`qcc_namespacetwo` int(11) NOT NULL default '0',
- `qcc_titletwo` char(255) character set latin1 collate latin1_bin NOT NULL default '',
+ `qcc_titletwo` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
KEY `qcc_type` (`qcc_type`,`qcc_value`),
KEY `qcc_title` (`qcc_type`,`qcc_namespace`,`qcc_title`),
KEY `qcc_titletwo` (`qcc_type`,`qcc_namespacetwo`,`qcc_titletwo`)
@@ -570,7 +569,7 @@
`rc_logid` int(10) unsigned NOT NULL default '0',
`rc_log_type` varbinary(255) default NULL,
`rc_log_action` varbinary(255) default NULL,
- `rc_params` blob NOT NULL,
+ `rc_params` blob,
PRIMARY KEY (`rc_id`),
KEY `rc_timestamp` (`rc_timestamp`),
KEY `rc_namespace_title` (`rc_namespace`,`rc_title`),
@@ -859,4 +858,4 @@
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2009-05-14 8:24:46
+-- Dump completed on 2009-05-14 8:24:54
--- 1.11.sql 2009-05-14 18:24:54.000000000 +1000
+++ 1.12.sql 2009-05-14 18:25:01.000000000 +1000
@@ -1,6 +1,6 @@
-- MySQL dump 10.11
--
--- Host: localhost Database: uptest1_11
+-- Host: localhost Database: uptest1_12
-- ------------------------------------------------------
-- Server version 5.0.75-0ubuntu10
@@ -483,7 +483,7 @@
`pt_create_perm` varbinary(60) NOT NULL,
PRIMARY KEY (`pt_namespace`,`pt_title`),
KEY `pt_timestamp` (`pt_timestamp`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -858,4 +858,4 @@
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2009-05-14 8:24:54
+-- Dump completed on 2009-05-14 8:25:01
--- 1.12.sql 2009-05-14 18:25:01.000000000 +1000
+++ 1.13.sql 2009-05-14 18:25:08.000000000 +1000
@@ -1,6 +1,6 @@
-- MySQL dump 10.11
--
--- Host: localhost Database: uptest1_12
+-- Host: localhost Database: uptest1_13
-- ------------------------------------------------------
-- Server version 5.0.75-0ubuntu10
@@ -56,11 +56,11 @@
`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',
+ `cat_hidden` tinyint(3) 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;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -240,6 +240,7 @@
`ipb_address` tinyblob NOT NULL,
`ipb_user` int(10) unsigned NOT NULL default '0',
`ipb_by` int(10) unsigned NOT NULL default '0',
+ `ipb_by_text` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
`ipb_reason` tinyblob NOT NULL,
`ipb_timestamp` binary(14) NOT NULL default '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
`ipb_auto` tinyint(1) NOT NULL default '0',
@@ -251,7 +252,6 @@
`ipb_range_end` tinyblob NOT NULL,
`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`),
@@ -304,6 +304,7 @@
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `logging` (
+ `log_id` int(10) unsigned NOT NULL auto_increment,
`log_type` varbinary(10) NOT NULL default '',
`log_action` varbinary(10) NOT NULL default '',
`log_timestamp` binary(14) NOT NULL default '19700101000000',
@@ -312,7 +313,6 @@
`log_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
`log_comment` varchar(255) NOT NULL default '',
`log_params` blob NOT NULL,
- `log_id` int(10) unsigned NOT NULL auto_increment,
`log_deleted` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`log_id`),
KEY `type_time` (`log_type`,`log_timestamp`),
@@ -424,7 +424,7 @@
`pp_propname` varbinary(60) NOT NULL,
`pp_value` blob NOT NULL,
PRIMARY KEY (`pp_page`,`pp_propname`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -756,7 +756,7 @@
CREATE TABLE `updatelog` (
`ul_key` varchar(255) NOT NULL,
PRIMARY KEY (`ul_key`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
@@ -858,4 +858,4 @@
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2009-05-14 8:25:01
+-- Dump completed on 2009-05-14 8:25:08
--- 1.13.sql 2009-05-14 18:25:08.000000000 +1000
+++ 1.14.sql 2009-05-14 18:25:16.000000000 +1000
@@ -1,6 +1,6 @@
-- MySQL dump 10.11
--
--- Host: localhost Database: uptest1_13
+-- Host: localhost Database: uptest1_14
-- ------------------------------------------------------
-- Server version 5.0.75-0ubuntu10
@@ -252,7 +252,7 @@
`ipb_range_end` tinyblob NOT NULL,
`ipb_deleted` tinyint(1) NOT NULL default '0',
`ipb_block_email` tinyint(1) NOT NULL default '0',
- `ipb_allow_usertalk` tinyint(1) NOT NULL default '1',
+ `ipb_allow_usertalk` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`ipb_id`),
UNIQUE KEY `ipb_address` (`ipb_address`(255),`ipb_user`,`ipb_auto`,`ipb_anon_only`),
KEY `ipb_user` (`ipb_user`),
@@ -350,7 +350,7 @@
`keyname` varbinary(255) NOT NULL default '',
`value` mediumblob,
`exptime` datetime default NULL,
- UNIQUE KEY `keyname` (`keyname`),
+ PRIMARY KEY (`keyname`),
KEY `exptime` (`exptime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
@@ -656,9 +656,9 @@
`ss_good_articles` bigint(20) unsigned default '0',
`ss_total_pages` bigint(20) default '-1',
`ss_users` bigint(20) default '-1',
+ `ss_active_users` bigint(20) default '-1',
`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=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
@@ -858,4 +858,4 @@
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2009-05-14 8:25:08
+-- Dump completed on 2009-05-14 8:25:16