summaryrefslogtreecommitdiff
path: root/database/database.pgsql
diff options
context:
space:
mode:
authorDries Buytaert <dries@buytaert.net>2004-05-19 14:55:19 +0000
committerDries Buytaert <dries@buytaert.net>2004-05-19 14:55:19 +0000
commitd0090e69e67cdd213be259281cbb008bca0d4006 (patch)
treef5f9814771191cebe6b59f2371a16fecad2ebbf0 /database/database.pgsql
parentcd2f2bc0f9d01ef091e3e1d967849786461cb18b (diff)
downloadbrdo-d0090e69e67cdd213be259281cbb008bca0d4006.tar.gz
brdo-d0090e69e67cdd213be259281cbb008bca0d4006.tar.bz2
- Patch #7614 by jhriggs: fixed some role related problems.
Diffstat (limited to 'database/database.pgsql')
-rw-r--r--database/database.pgsql4
1 files changed, 2 insertions, 2 deletions
diff --git a/database/database.pgsql b/database/database.pgsql
index 35331592e..3b7812599 100644
--- a/database/database.pgsql
+++ b/database/database.pgsql
@@ -587,7 +587,6 @@ CREATE TABLE users (
picture varchar(255) NOT NULL DEFAULT '',
init varchar(64) default '',
data text default '',
- rid integer NOT NULL default '0',
PRIMARY KEY (uid),
UNIQUE (name)
);
@@ -665,7 +664,8 @@ INSERT INTO system VALUES ('themes/xtemplate/xtemplate.theme','xtemplate','theme
INSERT INTO variable(name,value) VALUES('update_start', 's:10:"2004-02-21";');
INSERT INTO variable(name,value) VALUES('theme_default','s:9:"xtemplate";');
-INSERT INTO users(uid,name,mail,rid) VALUES(0,'','', '1');
+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 permission VALUES (1,'access content',0);