From 87f617e47c1e3f0ab67665d4440b98cdeecc3cdb Mon Sep 17 00:00:00 2001 From: Domas Mituzas Date: Thu, 9 Sep 2004 08:33:00 +0000 Subject: [PATCH] specify defaults for cur_user and cur_user_text --- maintenance/postgresql/pg_tables.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/maintenance/postgresql/pg_tables.sql b/maintenance/postgresql/pg_tables.sql index 5e0324e21f..5070ae848a 100644 --- a/maintenance/postgresql/pg_tables.sql +++ b/maintenance/postgresql/pg_tables.sql @@ -10,8 +10,8 @@ CREATE TABLE cur ( cur_title varchar(255) NOT NULL, cur_text text NOT NULL, cur_comment text, - cur_user integer NOT NULL, - cur_user_text varchar(255) NOT NULL, + cur_user integer DEFAULT 0 NOT NULL, + cur_user_text varchar(255) DEFAULT '' NOT NULL, cur_timestamp timestamp without time zone NOT NULL, cur_restrictions text DEFAULT '':text NOT NULL, cur_counter bigint DEFAULT 0 NOT NULL, -- 2.20.1