From 52c4240600f3140bbf646c1b22b50187d333f917 Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Tue, 30 Sep 2003 08:55:03 +0000 Subject: - Added PostgreSQL support to the update script. Patch by Adrian. - Making Adrian the new PostgreSQL maintainer. --- database/database.pgsql | 11 +++++++++-- 1 file changed, 9 insertions(+), 2 deletions(-) (limited to 'database/database.pgsql') diff --git a/database/database.pgsql b/database/database.pgsql index 559293d17..3e2d3183b 100644 --- a/database/database.pgsql +++ b/database/database.pgsql @@ -124,7 +124,7 @@ CREATE TABLE comments ( link varchar(16) NOT NULL default '', score integer NOT NULL default '0', status smallint NOT NULL default '0', - thread varchar(255) NOT NULL, + thread varchar(255) default '', users text default '', PRIMARY KEY (cid) ); @@ -521,6 +521,8 @@ CREATE TABLE users ( ); CREATE INDEX users_timestamp_idx ON users(timestamp); +CREATE SEQUENCE users_uid_seq INCREMENT 1 START 1; + -- -- Table structure for variable -- @@ -578,7 +580,7 @@ INSERT INTO system VALUES ('modules/story.module','story','module','',1); INSERT INTO system VALUES ('modules/taxonomy.module','taxonomy','module','',1); INSERT INTO system VALUES ('themes/marvin/marvin.theme','marvin','theme','Internet explorer, Netscape, Opera',1); -INSERT INTO variable(name,value) VALUES('update_start', 's:10:"2003-04-19";'); +INSERT INTO variable(name,value) VALUES('update_start', 's:10:"2003-09-29";'); INSERT INTO variable(name,value) VALUES('theme_default','s:6:"marvin";'); INSERT INTO users(uid,name,mail,rid) VALUES(0,'Anonymous','root@localhost', '1'); @@ -598,3 +600,8 @@ BEGIN END; ' LANGUAGE 'plpgsql'; +CREATE FUNCTION "rand"() RETURNS float AS ' +BEGIN + RETURN random(); +END; +' LANGUAGE 'plpgsql'; -- cgit v1.2.3