aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorPaul S. Owen <psotfx@users.sourceforge.net>2001-05-31 14:11:57 +0000
committerPaul S. Owen <psotfx@users.sourceforge.net>2001-05-31 14:11:57 +0000
commit09f0b8836576fc792a5704ee2a2295ba94e6a4f6 (patch)
tree44f40059bfd85dd46d175f795ea162759376008b
parente512745c016905d332ece116f9b3514057c8202e (diff)
downloadforums-09f0b8836576fc792a5704ee2a2295ba94e6a4f6.tar
forums-09f0b8836576fc792a5704ee2a2295ba94e6a4f6.tar.gz
forums-09f0b8836576fc792a5704ee2a2295ba94e6a4f6.tar.bz2
forums-09f0b8836576fc792a5704ee2a2295ba94e6a4f6.tar.xz
forums-09f0b8836576fc792a5704ee2a2295ba94e6a4f6.zip
Added some basic auth info for new auth system
git-svn-id: file:///svn/phpbb/trunk@384 89ea8834-ac86-4346-8a33-228a782c2dd0
-rw-r--r--phpBB/db/mysql_basic.sql14
1 files changed, 14 insertions, 0 deletions
diff --git a/phpBB/db/mysql_basic.sql b/phpBB/db/mysql_basic.sql
index 0442343f0b..dcfcab8e2e 100644
--- a/phpBB/db/mysql_basic.sql
+++ b/phpBB/db/mysql_basic.sql
@@ -19,6 +19,20 @@ INSERT INTO phpbb_forum_mods VALUES (1,1,0);
INSERT INTO phpbb_users VALUES (-1,1,'Anonymous',NOW(),'','','Default','','-8','d M Y H:i',0,'',1,'','','','','','','',0,1,'','','',0,0,0,0,0,'','',0);
INSERT INTO phpbb_users VALUES (1,1,'admin',NOW(),'','','','','-8','d M Y H:i','0','','4','admin@yourdomain.com','','','','','','This is just a stupid sig',1,1,'','','',0,1,0,0,0,'','',0);
+# -- Groups
+INSERT INTO phpbb_groups (group_id, group_name, group_note, single_user) VALUES (1, 'Anonymous', 'Personal User', 1);
+INSERT INTO phpbb_groups (group_id, group_name, group_note, single_user) VALUES (2, 'admin', 'Personal User', 1);
+
+# -- User -> Group
+INSERT INTO phpbb_user_group (group_id, user_id) VALUES (1, 1);
+INSERT INTO phpbb_user_group (group_id, user_id) VALUES (2, 2);
+
+# -- Forum Access (Open access to ALL)
+INSERT INTO phpbb_auth_forums (forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_votecreate, auth_vote) VALUES (1, 0, 0, 0, 0, 0, 0, 0, 0);
+
+# -- User Access (admin is just that, an admin)
+INSER INTO phpbb_auth_access (group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_votecreate, auth_vote, auth_mod, auth_admin) VALUES (2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
+
# -- Demo Topic
INSERT INTO phpbb_topics VALUES(1,1,'Demo Topic', 1,NOW(), 0,0,0,0,1);