From f5cf795458a5afd3083107e74d493f68c20dc93d Mon Sep 17 00:00:00 2001 From: Domas Mituzas Date: Sun, 26 Sep 2004 09:03:45 +0000 Subject: [PATCH] create schema mediawiki and store all objects in it add user_token --- maintenance/postgresql/pg_tables.sql | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) diff --git a/maintenance/postgresql/pg_tables.sql b/maintenance/postgresql/pg_tables.sql index 5d5c561d6d..217440bc0c 100644 --- a/maintenance/postgresql/pg_tables.sql +++ b/maintenance/postgresql/pg_tables.sql @@ -4,6 +4,9 @@ -- -- +CREATE SCHEMA mediawiki; +SET search_path=mediawiki; + CREATE TABLE cur ( cur_id serial PRIMARY KEY, cur_namespace smallint NOT NULL, @@ -18,7 +21,7 @@ CREATE TABLE cur ( cur_is_redirect smallint DEFAULT 0 NOT NULL, cur_minor_edit smallint DEFAULT 0 NOT NULL, cur_is_new smallint DEFAULT 0 NOT NULL, - cur_random double precision, + cur_random double precision DEFAULT random(), cur_touched timestamp without time zone, inverse_timestamp varchar(14) ); @@ -115,7 +118,8 @@ CREATE TABLE "user" ( user_newpassword text DEFAULT ''::text NOT NULL, user_email text DEFAULT ''::text NOT NULL, user_options text DEFAULT ''::text NOT NULL, - user_touched timestamp without time zone DEFAULT '1900-01-01 00:00:00'::timestamp without time zone NOT NULL + user_touched timestamp without time zone DEFAULT '1900-01-01 00:00:00'::timestamp without time zone NOT NULL, + user_token char(32) DEFAULT '' NOT NULL ); -- 2.20.1