| Index: trunk/phase3/maintenance/postgres/tables.sql |
| — | — | @@ -29,8 +29,8 @@ |
| 30 | 30 | CREATE INDEX user_email_token_idx ON "user" (user_email_token); |
| 31 | 31 | |
| 32 | 32 | -- Create a dummy user to satisfy fk contraints especially with revisions |
| 33 | | -INSERT INTO "user" VALUES |
| 34 | | - (DEFAULT,'Anonymous','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,now(),now()); |
| | 33 | +INSERT INTO "user" |
| | 34 | + VALUES (DEFAULT,'Anonymous','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,now(),now()); |
| 35 | 35 | |
| 36 | 36 | CREATE TABLE user_groups ( |
| 37 | 37 | ug_user INTEGER NULL REFERENCES "user"(user_id) ON DELETE CASCADE, |
| — | — | @@ -78,12 +78,12 @@ |
| 79 | 79 | $mw$; |
| 80 | 80 | |
| 81 | 81 | CREATE TRIGGER page_deleted AFTER DELETE ON page |
| 82 | | -FOR EACH ROW EXECUTE PROCEDURE page_deleted(); |
| | 82 | + FOR EACH ROW EXECUTE PROCEDURE page_deleted(); |
| 83 | 83 | |
| 84 | 84 | |
| 85 | 85 | -- Create a dummy page to satisfy fk contraints where a page_id of "0" is added |
| 86 | 86 | INSERT INTO page (page_id,page_namespace,page_title,page_random,page_latest,page_len) |
| 87 | | -VALUES (0,0,'',0.0,0,0); |
| | 87 | + VALUES (0,0,'',0.0,0,0); |
| 88 | 88 | |
| 89 | 89 | |
| 90 | 90 | CREATE SEQUENCE rev_rev_id_val; |
| — | — | @@ -421,7 +421,7 @@ |
| 422 | 422 | $mw$; |
| 423 | 423 | |
| 424 | 424 | CREATE TRIGGER ts2_page_title BEFORE INSERT OR UPDATE ON page |
| 425 | | -FOR EACH ROW EXECUTE PROCEDURE ts2_page_title(); |
| | 425 | + FOR EACH ROW EXECUTE PROCEDURE ts2_page_title(); |
| 426 | 426 | |
| 427 | 427 | |
| 428 | 428 | ALTER TABLE text ADD textvector tsvector; |
| — | — | @@ -439,9 +439,9 @@ |
| 440 | 440 | $mw$; |
| 441 | 441 | |
| 442 | 442 | CREATE TRIGGER ts2_page_text BEFORE INSERT OR UPDATE ON text |
| 443 | | -FOR EACH ROW EXECUTE PROCEDURE ts2_page_text(); |
| | 443 | + FOR EACH ROW EXECUTE PROCEDURE ts2_page_text(); |
| 444 | 444 | |
| 445 | | -CREATE OR REPLACE FUNCTION add_interwiki (TEXT,INT,CHAR) RETURNS INT LANGUAGE SQL AS |
| | 445 | +CREATE FUNCTION add_interwiki (TEXT,INT,CHAR) RETURNS INT LANGUAGE SQL AS |
| 446 | 446 | $mw$ |
| 447 | 447 | INSERT INTO interwiki (iw_prefix, iw_url, iw_local) VALUES ($1,$2,$3); |
| 448 | 448 | SELECT 1; |
| — | — | @@ -464,7 +464,7 @@ |
| 465 | 465 | ); |
| 466 | 466 | |
| 467 | 467 | INSERT INTO mediawiki_version (type,mw_version,sql_version,sql_date) |
| 468 | | -VALUES ('Creation','??','$LastChangedRevision$','$LastChangedDate$'); |
| | 468 | + VALUES ('Creation','??','$LastChangedRevision$','$LastChangedDate$'); |
| 469 | 469 | |
| 470 | 470 | |
| 471 | 471 | COMMIT; |