From 1c83d517410a013aba23bb44e4620cff7d9e9824 Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Thu, 14 Apr 2005 19:37:11 +0000 Subject: - Patch by Adrian: postgresql fixes --- database/database.pgsql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'database/database.pgsql') diff --git a/database/database.pgsql b/database/database.pgsql index 92f5dc0b7..54a1426fb 100644 --- a/database/database.pgsql +++ b/database/database.pgsql @@ -573,7 +573,7 @@ CREATE INDEX search_index_word_idx ON search_index(word); CREATE TABLE search_total ( word varchar(50) NOT NULL default '', - count integer default NULL + count float default NULL ); CREATE INDEX search_total_word_idx ON search_total(word); @@ -794,10 +794,10 @@ INSERT INTO variable(name,value) VALUES('theme_default','s:10:"bluemarine";'); INSERT INTO users(uid,name,mail) VALUES(0,'',''); INSERT INTO users_roles(uid,rid) VALUES(0, 1); -INSERT INTO role (rid, name) VALUES (1, 'anonymous user'); +INSERT INTO role (name) VALUES ('anonymous user'); INSERT INTO permission VALUES (1,'access content',0); -INSERT INTO role (rid, name) VALUES (2, 'authenticated user'); +INSERT INTO role (name) VALUES ('authenticated user'); INSERT INTO permission VALUES (2,'access comments, access content, post comments, post comments without approval',0); INSERT INTO blocks(module,delta,status) VALUES('user', 0, 1); -- cgit v1.2.3