From fb393415bbbb0d943f0716bafa95ba8e7889e33b Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Sun, 8 Jan 2006 16:32:08 +0000 Subject: - Patch #43833 by killes: give the first user a default role. --- database/database.mysql | 8 +++++--- database/database.pgsql | 8 +++++--- 2 files changed, 10 insertions(+), 6 deletions(-) (limited to 'database') 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";'); -- cgit v1.2.3