r23080 MediaWiki - Code Review archive

Repository:MediaWiki
Revision:r23079‎ | r23080 | r23081 >
Date:20:18, 18 June 2007
Author:mulligen
Status:old
Tags:
Comment:
small fixes to the definition of tables
Modified paths:
  • /trunk/extensions/Wikidata/Database+scripts/Convenience/wikidataCoreTables.sql (modified) (history)
  • /trunk/extensions/Wikidata/Database+scripts/Convenience/wikidataSourceTables.sql (modified) (history)

Diff [purge]

Index: trunk/extensions/Wikidata/Database scripts/Convenience/wikidataCoreTables.sql
@@ -49,7 +49,7 @@
5050 DELETE FROM namespace where ns_id = 25;
5151
5252 INSERT INTO `namespace` (`ns_id`,`ns_system`,`ns_parent`, `ns_count`, `ns_class` ) VALUES
53 - (16,'NS_EXPRESSION', NULL,0,'Expression'),
 53+ (16,'NS_EXPRESSION', NULL,0,'OmegaWiki'),
5454 (17,'NS_EXPRESSION_TALK', 16, 0,NULL),
5555 (24,'NS_DEFINEDMEANING', NULL,0,'DefinedMeaning'),
5656 (25,'NS_DEFINEDMEANING_TALK',24, 0,NULL);
Index: trunk/extensions/Wikidata/Database scripts/Convenience/wikidataSourceTables.sql
@@ -4,18 +4,6 @@
55 DROP TABLE IF EXISTS translated_content;
66 DROP TABLE IF EXISTS transactions;
77
8 -DROP TABLE IF EXISTS `uw_text`;
9 -
10 -CREATE TABLE `uw_text` (
11 - `text_id` int(8) unsigned NOT NULL auto_increment,
12 - `text_text` mediumblob NOT NULL,
13 - `text_flags` tinyblob NOT NULL,
14 - PRIMARY KEY (`text_id`)
15 -) DEFAULT CHARSET=utf8;
16 -
178 DROP TABLE IF EXISTS /*$wgWDprefix*/alt_meaningtexts;
189
1910 CREATE TABLE /*$wgWDprefix*/alt_meaningtexts (
@@ -358,7 +346,7 @@
359347 CREATE TABLE /*$wgWDprefix*/text (
360348 `text_id` int(8) unsigned NOT NULL auto_increment,
361349 `text_text` mediumblob NOT NULL,
362 - `text_flags` tinyblob,
 350+ `text_flags` tinyblob default NULL,
363351 PRIMARY KEY (`text_id`)
364352 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
365353

Status & tagging log