summaryrefslogtreecommitdiff
path: root/database
diff options
context:
space:
mode:
authorDries Buytaert <dries@buytaert.net>2006-01-08 16:32:08 +0000
committerDries Buytaert <dries@buytaert.net>2006-01-08 16:32:08 +0000
commitfb393415bbbb0d943f0716bafa95ba8e7889e33b (patch)
tree470bc247ffeff97a64fd8037a2c8b9712941408e /database
parent748c69985e7839ad645974460e75c033ea6102d2 (diff)
downloadbrdo-fb393415bbbb0d943f0716bafa95ba8e7889e33b.tar.gz
brdo-fb393415bbbb0d943f0716bafa95ba8e7889e33b.tar.bz2
- Patch #43833 by killes: give the first user a default role.
Diffstat (limited to 'database')
-rw-r--r--database/database.mysql8
-rw-r--r--database/database.pgsql8
2 files changed, 10 insertions, 6 deletions
diff --git a/database/database.mysql b/database/database.mysql
index 68671f14b..11ae9aec4 100644
--- a/database/database.mysql
+++ b/database/database.mysql
@@ -863,12 +863,14 @@ INSERT INTO system (filename, name, type, description, status, throttle, bootstr
INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('themes/engines/phptemplate/phptemplate.engine', 'phptemplate', 'theme_engine', '', 1, 0, 0, 0);
INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('themes/bluemarine/page.tpl.php', 'bluemarine', 'theme', 'themes/engines/phptemplate/phptemplate.engine', 1, 0, 0, 0);
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);
-
INSERT INTO role (rid, name) VALUES (2, 'authenticated user');
+
+INSERT INTO users_roles (uid, rid) VALUES (0, 1);
+INSERT INTO users_roles (uid, rid) VALUES (1, 2);
+
+INSERT INTO permission VALUES (1,'access content',0);
INSERT INTO permission VALUES (2,'access comments, access content, post comments, post comments without approval',0);
REPLACE variable SET name='theme_default', value='s:10:"bluemarine";';
diff --git a/database/database.pgsql b/database/database.pgsql
index 1529901dd..4eb0f7095 100644
--- a/database/database.pgsql
+++ b/database/database.pgsql
@@ -861,12 +861,14 @@ INSERT INTO system (filename, name, type, description, status, throttle, bootstr
INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('themes/bluemarine/page.tpl.php', 'bluemarine', 'theme', 'themes/engines/phptemplate/phptemplate.engine', 1, 0, 0, 0);
INSERT INTO users(uid,name,mail) VALUES(0,'','');
-INSERT INTO users_roles(uid,rid) VALUES(0, 1);
INSERT INTO role (name) VALUES ('anonymous user');
-INSERT INTO permission VALUES (1,'access content',0);
-
INSERT INTO role (name) VALUES ('authenticated user');
+
+INSERT INTO users_roles(uid,rid) VALUES(0, 1);
+INSERT INTO users_roles(uid,rid) VALUES(1, 2);
+
+INSERT INTO permission VALUES (1,'access content',0);
INSERT INTO permission VALUES (2,'access comments, access content, post comments, post comments without approval',0);
INSERT INTO variable(name,value) VALUES('theme_default', 's:10:"bluemarine";');