summaryrefslogtreecommitdiffstats
path: root/database
diff options
context:
space:
mode:
authorDries Buytaert2003-09-30 08:55:03 (GMT)
committerDries Buytaert2003-09-30 08:55:03 (GMT)
commit52c4240600f3140bbf646c1b22b50187d333f917 (patch)
treed7cd3609c7f0d32069ba55fe7ffd273d9b6532a4 /database
parent1127b04b6b5e139b925d053f1f1bc79fbf18898e (diff)
- Added PostgreSQL support to the update script. Patch by Adrian.
- Making Adrian the new PostgreSQL maintainer.
Diffstat (limited to 'database')
-rw-r--r--database/database.mysql2
-rw-r--r--database/database.pgsql11
2 files changed, 10 insertions, 3 deletions
diff --git a/database/database.mysql b/database/database.mysql
index accb2ac..1a53c39 100644
--- a/database/database.mysql
+++ b/database/database.mysql
@@ -580,7 +580,7 @@ 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 users (uid, name, mail, rid) VALUES ('0', 'Anonymous', 'root@localhost', '1');
-REPLACE variable SET name='update_start', value='s:10:"2003-04-19;"';
+REPLACE variable SET name='update_start', value='s:10:"2003-09-29;"';
REPLACE variable SET name='theme_default', value='s:6:"marvin";';
REPLACE blocks SET module = 'user', delta = '0', status = '1';
diff --git a/database/database.pgsql b/database/database.pgsql
index 559293d..3e2d318 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';