diff -r 79fb483807f6 -r 45e887f23282 install/schemas/postgresql_stage2.sql --- a/install/schemas/postgresql_stage2.sql Mon Feb 16 16:04:31 2009 -0500 +++ b/install/schemas/postgresql_stage2.sql Mon Feb 16 16:04:54 2009 -0500 @@ -11,15 +11,15 @@ -- postgresql_stage2.sql - PostgreSQL installation schema, main payload CREATE TABLE {{TABLE_PREFIX}}categories( - page_id varchar(64), - namespace varchar(64), + page_id varchar(512), + namespace varchar(16), category_id varchar(64) ); CREATE TABLE {{TABLE_PREFIX}}comments( comment_id SERIAL, - page_id text, - namespace text, + page_id varchar(512), + namespace varchar(16), subject text, comment_data text, name text, @@ -36,8 +36,8 @@ action varchar(16), time_id int NOT NULL DEFAULT '0', date_string varchar(63), - page_id text, - namespace text, + page_id varchar(512), + namespace varchar(16), page_text text, char_tag varchar(40), author varchar(63), @@ -48,7 +48,7 @@ ); CREATE TABLE {{TABLE_PREFIX}}page_text( - page_id varchar(255), + page_id varchar(512), namespace varchar(16) NOT NULL DEFAULT 'Article', page_text text, char_tag varchar(63) @@ -62,6 +62,7 @@ special smallint DEFAULT '0', visible smallint DEFAULT '1', comments_on smallint DEFAULT '1', + page_format varchar(16) NOT NULL DEFAULT 'wikitext', protected smallint NOT NULL DEFAULT 0, wiki_mode smallint NOT NULL DEFAULT 2, delvotes int NOT NULL DEFAULT 0, @@ -149,7 +150,7 @@ CREATE TABLE {{TABLE_PREFIX}}files( file_id SERIAL, time_id int NOT NULL, - page_id varchar(63) NOT NULL, + page_id varchar(512) NOT NULL, filename varchar(127) DEFAULT NULL, size bigint NOT NULL, mimetype varchar(63) DEFAULT NULL, @@ -193,8 +194,8 @@ hit_id SERIAL, username varchar(63) NOT NULL, time int NOT NULL DEFAULT 0, - page_id varchar(63), - namespace varchar(63), + page_id varchar(512), + namespace varchar(16), PRIMARY KEY ( hit_id ) ); @@ -227,8 +228,8 @@ rule_id SERIAL, target_type smallint NOT NULL, target_id int NOT NULL, - page_id varchar(255), - namespace varchar(24), + page_id varchar(512), + namespace varchar(16), rules text, PRIMARY KEY ( rule_id ) ); @@ -248,8 +249,8 @@ CREATE TABLE {{TABLE_PREFIX}}page_group_members( pg_member_id SERIAL, pg_id int NOT NULL, - page_id varchar(63) NOT NULL, - namespace varchar(63) NOT NULL DEFAULT 'Article', + page_id varchar(512) NOT NULL, + namespace varchar(16) NOT NULL DEFAULT 'Article', PRIMARY KEY ( pg_member_id ) ); @@ -258,8 +259,8 @@ CREATE TABLE {{TABLE_PREFIX}}tags( tag_id SERIAL, tag_name varchar(63) NOT NULL DEFAULT 'bla', - page_id varchar(255) NOT NULL, - namespace varchar(255) NOT NULL, + page_id varchar(512) NOT NULL, + namespace varchar(16) NOT NULL, user_id int NOT NULL DEFAULT 1, PRIMARY KEY ( tag_id ) );