| Index: trunk/phase3/maintenance/postgres/tables.sql |
| — | — | @@ -136,7 +136,7 @@ |
| 137 | 137 | ar_rev_id INTEGER, |
| 138 | 138 | ar_text_id INTEGER, |
| 139 | 139 | ar_deleted INTEGER NOT NULL DEFAULT '0', |
| 140 | | - ar_len INTEGER NULL, |
| | 140 | + ar_len INTEGER NULL |
| 141 | 141 | ); |
| 142 | 142 | CREATE INDEX archive_name_title_timestamp ON archive (ar_namespace,ar_title,ar_timestamp); |
| 143 | 143 | |
| — | — | @@ -224,8 +224,8 @@ |
| 225 | 225 | ipb_enable_autoblock CHAR NOT NULL DEFAULT '1', |
| 226 | 226 | ipb_expiry TIMESTAMPTZ NOT NULL, |
| 227 | 227 | ipb_range_start TEXT, |
| 228 | | - ipb_range_end TEXT |
| 229 | | - ipb_deleted INTEGER NOT NULL, DEFAULT '0', |
| | 228 | + ipb_range_end TEXT, |
| | 229 | + ipb_deleted INTEGER NOT NULL DEFAULT '0' |
| 230 | 230 | ); |
| 231 | 231 | CREATE INDEX ipb_address ON ipblocks (ipb_address); |
| 232 | 232 | CREATE INDEX ipb_user ON ipblocks (ipb_user); |
| — | — | @@ -285,8 +285,8 @@ |
| 286 | 286 | fa_description TEXT NOT NULL, |
| 287 | 287 | fa_user INTEGER NULL REFERENCES mwuser(user_id) ON DELETE SET NULL, |
| 288 | 288 | fa_user_text TEXT NOT NULL, |
| 289 | | - fa_timestamp TIMESTAMPTZ |
| 290 | | - fa_deleted INTEGER NOT NULL DEFAULT '0', |
| | 289 | + fa_timestamp TIMESTAMPTZ, |
| | 290 | + fa_deleted INTEGER NOT NULL DEFAULT '0' |
| 291 | 291 | ); |
| 292 | 292 | CREATE INDEX fa_name_time ON filearchive (fa_name, fa_timestamp); |
| 293 | 293 | CREATE INDEX fa_dupe ON filearchive (fa_storage_group, fa_storage_key); |
| — | — | @@ -321,7 +321,7 @@ |
| 322 | 322 | rc_logid INTEGER NOT NULL DEFAULT '0', |
| 323 | 323 | rc_log_type TEXT, |
| 324 | 324 | rc_log_action TEXT, |
| 325 | | - rc_params TEXT, |
| | 325 | + rc_params TEXT |
| 326 | 326 | ); |
| 327 | 327 | CREATE INDEX rc_timestamp ON recentchanges (rc_timestamp); |
| 328 | 328 | CREATE INDEX rc_namespace_title ON recentchanges (rc_namespace, rc_title); |
| — | — | @@ -407,7 +407,7 @@ |
| 408 | 408 | log_comment TEXT, |
| 409 | 409 | log_params TEXT, |
| 410 | 410 | log_deleted INTEGER NOT NULL DEFAULT '0', |
| 411 | | - log_id INTEGER NOT NULL PRIMARY KEY DEFAULT nextval('log_log_id_seq'), |
| | 411 | + log_id INTEGER NOT NULL PRIMARY KEY DEFAULT nextval('log_log_id_seq') |
| 412 | 412 | ); |
| 413 | 413 | CREATE INDEX logging_type_name ON logging (log_type, log_timestamp); |
| 414 | 414 | CREATE INDEX logging_user_time ON logging (log_timestamp, log_user); |