| Index: trunk/extensions/Wikidata/Database scripts/Convenience/wikidataCoreTables.sql |
| — | — | @@ -1,3 +1,9 @@ |
| | 2 | +ALTER TABLE page MODIFY COLUMN page_restrictions TINYBLOB DEFAULT NULL; |
| | 3 | +ALTER TABLE page MODIFY COLUMN page_random DOUBLE UNSIGNED NOT NULL DEFAULT 0; |
| | 4 | +ALTER TABLE page MODIFY COLUMN page_latest INT(8) UNSIGNED NOT NULL DEFAULT 0; |
| | 5 | +ALTER TABLE page MODIFY COLUMN page_len INT(8) UNSIGNED NOT NULL DEFAULT 0; |
| | 6 | +ALTER TABLE revision MODIFY COLUMN rev_text_id INT(8) UNSIGNED NOT NULL DEFAULT 0; |
| | 7 | + |
| 2 | 8 | -- |
| 3 | 9 | -- Add the wikidata specific namespaces |
| 4 | 10 | -- |
| — | — | @@ -126,8 +132,4 @@ |
| 127 | 133 | set_dmid int(10) default NULL |
| 128 | 134 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
| 129 | 135 | |
| 130 | | -INSERT INTO wikidata_sets (set_prefix,set_fallback_name,set_dmid) VALUES |
| 131 | | - ('uw','OmegaWiki community',0), |
| 132 | | - ('umls','Unified Medical Language System',0), |
| 133 | | - ('sp','Swiss-Prot',0); |
| 134 | 136 | |
| \ No newline at end of file |