- Patch by Adrian: postgresql fixes

1 files changed, 3 insertions, 3 deletions

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);