1 -- update script 2003-11-22 by Zapata
2 -- * added a bunch of fields to webdb_user: is_disabled, email, profile, creation date,
4 -- This script will terminate with an error the second time it's run,
5 -- so running this script when it isn't needed can't do any harm.
10 ALTER TABLE "webdb_users" RENAME TO "webdb_users_old";
11 DROP INDEX "webdb_users_pkey";
13 CREATE TABLE "webdb_users" (
14 "id" integer DEFAULT nextval('webdb_users_id_seq'::text) NOT NULL,
15 "login" character varying(16) NOT NULL,
16 "password" character varying(255) NOT NULL,
17 "is_admin" boolean DEFAULT '0' NOT NULL,
19 "is_disabled" boolean DEFAULT '0' NOT NULL,
20 "email" character varying(255) DEFAULT '' NOT NULL,
22 "webdb_create" timestamp with time zone NOT NULL,
23 "lastlogin" timestamp with time zone,
24 CONSTRAINT "webdb_users_pkey" Primary Key ("id")
27 INSERT INTO "webdb_users" (
50 FROM "webdb_users_old";
54 relowner = (SELECT relowner FROM pg_class WHERE relname='webdb_users_old'),
55 relacl = (SELECT relacl FROM pg_class WHERE relname='webdb_users_old')
57 relname = 'webdb_users';
60 -- to prevent this script from being run successfully for a second time
61 INSERT INTO webdb_users_old(login, password, is_admin) values('','','t');
63 DROP TABLE "webdb_users_old";