summaryrefslogtreecommitdiff
path: root/database
diff options
context:
space:
mode:
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";');