| Index: trunk/phase3/maintenance/postgres/tables.sql |
| — | — | @@ -555,11 +555,11 @@ |
| 556 | 556 | CREATE INDEX category_pages ON category(cat_pages); |
| 557 | 557 | |
| 558 | 558 | CREATE TABLE change_tag ( |
| 559 | | - ct_rc_id INTEGER NULL, |
| 560 | | - ct_log_id INTEGER NULL, |
| 561 | | - ct_rev_id INTEGER NULL, |
| 562 | | - ct_tag TEXT NOT NULL, |
| 563 | | - ct_params TEXT NULL |
| | 559 | + ct_rc_id INTEGER NULL, |
| | 560 | + ct_log_id INTEGER NULL, |
| | 561 | + ct_rev_id INTEGER NULL, |
| | 562 | + ct_tag TEXT NOT NULL, |
| | 563 | + ct_params TEXT NULL |
| 564 | 564 | ); |
| 565 | 565 | CREATE UNIQUE INDEX change_tag_rc_tag ON change_tag(ct_rc_id,ct_tag); |
| 566 | 566 | CREATE UNIQUE INDEX change_tag_log_tag ON change_tag(ct_log_id,ct_tag); |
| — | — | @@ -567,17 +567,17 @@ |
| 568 | 568 | CREATE INDEX change_tag_tag_id ON change_tag(ct_tag,ct_rc_id,ct_rev_id,ct_log_id); |
| 569 | 569 | |
| 570 | 570 | CREATE TABLE tag_summary ( |
| 571 | | - ts_rc_id INTEGER NULL, |
| 572 | | - ts_log_id INTEGER NULL, |
| 573 | | - ts_rev_id INTEGER NULL, |
| 574 | | - ts_tags TEXT NOT NULL |
| | 571 | + ts_rc_id INTEGER NULL, |
| | 572 | + ts_log_id INTEGER NULL, |
| | 573 | + ts_rev_id INTEGER NULL, |
| | 574 | + ts_tags TEXT NOT NULL |
| 575 | 575 | ); |
| 576 | 576 | CREATE UNIQUE INDEX tag_summary_rc_id ON tag_summary(ts_rc_id); |
| 577 | 577 | CREATE UNIQUE INDEX tag_summary_log_id ON tag_summary(ts_log_id); |
| 578 | 578 | CREATE UNIQUE INDEX tag_summary_rev_id ON tag_summary(ts_rev_id); |
| 579 | 579 | |
| 580 | 580 | CREATE TABLE valid_tag ( |
| 581 | | - vt_tag TEXT NOT NULL PRIMARY KEY |
| | 581 | + vt_tag TEXT NOT NULL PRIMARY KEY |
| 582 | 582 | ); |
| 583 | 583 | |
| 584 | 584 | CREATE TABLE mediawiki_version ( |
| Index: trunk/phase3/maintenance/tables.sql |
| — | — | @@ -966,7 +966,7 @@ |
| 967 | 967 | math_html text, |
| 968 | 968 | |
| 969 | 969 | -- MathML output from texvc, if any |
| 970 | | - math_mathml text |
| | 970 | + math_mathml text |
| 971 | 971 | ) /*$wgDBTableOptions*/; |
| 972 | 972 | |
| 973 | 973 | CREATE UNIQUE INDEX /*i*/math_inputhash ON /*_*/math (math_inputhash); |
| — | — | @@ -1237,11 +1237,11 @@ |
| 1238 | 1238 | |
| 1239 | 1239 | -- A table to track tags for revisions, logs and recent changes. |
| 1240 | 1240 | CREATE TABLE /*_*/change_tag ( |
| 1241 | | - ct_rc_id int NULL, |
| 1242 | | - ct_log_id int NULL, |
| 1243 | | - ct_rev_id int NULL, |
| 1244 | | - ct_tag varchar(255) NOT NULL, |
| 1245 | | - ct_params BLOB NULL |
| | 1241 | + ct_rc_id int NULL, |
| | 1242 | + ct_log_id int NULL, |
| | 1243 | + ct_rev_id int NULL, |
| | 1244 | + ct_tag varchar(255) NOT NULL, |
| | 1245 | + ct_params blob NULL |
| 1246 | 1246 | ) /*$wgDBTableOptions*/; |
| 1247 | 1247 | |
| 1248 | 1248 | CREATE UNIQUE INDEX /*i*/change_tag_rc_tag ON /*_*/change_tag (ct_rc_id,ct_tag); |
| — | — | @@ -1253,10 +1253,10 @@ |
| 1254 | 1254 | |
| 1255 | 1255 | -- Rollup table to pull a LIST of tags simply without ugly GROUP_CONCAT that only works on MySQL 4.1+ |
| 1256 | 1256 | CREATE TABLE /*_*/tag_summary ( |
| 1257 | | - ts_rc_id int NULL, |
| 1258 | | - ts_log_id int NULL, |
| 1259 | | - ts_rev_id int NULL, |
| 1260 | | - ts_tags BLOB NOT NULL |
| | 1257 | + ts_rc_id int NULL, |
| | 1258 | + ts_log_id int NULL, |
| | 1259 | + ts_rev_id int NULL, |
| | 1260 | + ts_tags blob NOT NULL |
| 1261 | 1261 | ) /*$wgDBTableOptions*/; |
| 1262 | 1262 | |
| 1263 | 1263 | CREATE UNIQUE INDEX /*i*/tag_summary_rc_id ON /*_*/tag_summary (ts_rc_id); |
| — | — | @@ -1265,7 +1265,7 @@ |
| 1266 | 1266 | |
| 1267 | 1267 | |
| 1268 | 1268 | CREATE TABLE /*_*/valid_tag ( |
| 1269 | | - vt_tag varchar(255) NOT NULL PRIMARY KEY |
| | 1269 | + vt_tag varchar(255) NOT NULL PRIMARY KEY |
| 1270 | 1270 | ) /*$wgDBTableOptions*/; |
| 1271 | 1271 | |
| 1272 | 1272 | |