diff options
Diffstat (limited to 'phpBB/db')
| -rw-r--r-- | phpBB/db/mysql_basic.sql | 5 | ||||
| -rw-r--r-- | phpBB/db/mysql_schema.sql | 20 | ||||
| -rw-r--r-- | phpBB/db/postgres_schema.sql | 18 |
3 files changed, 1 insertions, 42 deletions
diff --git a/phpBB/db/mysql_basic.sql b/phpBB/db/mysql_basic.sql index 477b4ac8d3..41f20e790c 100644 --- a/phpBB/db/mysql_basic.sql +++ b/phpBB/db/mysql_basic.sql @@ -10,7 +10,7 @@ INSERT INTO phpbb_config (config_id, sitename, allow_html, allow_bbcode, allow_s INSERT INTO phpbb_categories (cat_id, cat_title, cat_order) VALUES (1, 'Test category 1', 1); # -- Forums -INSERT INTO phpbb_forums (forum_id, forum_name, forum_desc, cat_id, forum_order, forum_posts, forum_topics, forum_last_post_id) VALUES (1, 'Test Forum 1', 'This is just a test forum, nothing special here.', 1, 1, 1, 1, 1); +INSERT INTO phpbb_forums (forum_id, forum_name, forum_desc, cat_id, forum_order, forum_posts, forum_topics, forum_last_post_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_announce, auth_sticky, auth_votecreate, auth_vote) VALUES (1, 'Test Forum 1', 'This is just a test forum, nothing special here.', 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); # -- Users (admin is set as that, an admin ... password is null, change it once online!) INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_password, user_autologin_key, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_theme, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_rank, user_avatar, user_lang, user_timezone, user_dateformat, user_actkey, user_newpasswd, user_notify, user_active, user_template) VALUES ( '-1', 'Anonymous', '0', '972086460', '', '', '', '', '', '', '', '', '', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '0', ''); @@ -31,9 +31,6 @@ INSERT INTO phpbb_groups (group_id, group_name, group_description, group_single_ 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_announce, auth_sticky, auth_votecreate, auth_vote) VALUES (1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); - # -- User Access (admin is set as ... an admin) INSERT INTO phpbb_auth_access (group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_announce, auth_sticky, auth_votecreate, auth_vote, auth_mod, auth_admin) VALUES (2, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1); diff --git a/phpBB/db/mysql_schema.sql b/phpBB/db/mysql_schema.sql index dd6e6811a8..7a977429ae 100644 --- a/phpBB/db/mysql_schema.sql +++ b/phpBB/db/mysql_schema.sql @@ -28,26 +28,6 @@ CREATE TABLE phpbb_auth_access ( ); # -# Table structure for table 'phpbb_auth_forums' -# - -DROP TABLE IF EXISTS phpbb_auth_forums; -CREATE TABLE phpbb_auth_forums ( - forum_id int(11) DEFAULT '0' NOT NULL, - auth_view tinyint(4) DEFAULT '0' NOT NULL, - auth_read tinyint(4) DEFAULT '0' NOT NULL, - auth_post tinyint(4) DEFAULT '0' NOT NULL, - auth_reply tinyint(4) DEFAULT '0' NOT NULL, - auth_edit tinyint(4) DEFAULT '0' NOT NULL, - auth_delete tinyint(4) DEFAULT '0' NOT NULL, - auth_announce tinyint(4) DEFAULT '0' NOT NULL, - auth_sticky tinyint(4) DEFAULT '0' NOT NULL, - auth_votecreate tinyint(4) DEFAULT '0' NOT NULL, - auth_vote tinyint(4) DEFAULT '0' NOT NULL, - auth_attachments tinyint(4) DEFAULT '0' NOT NULL -); - -# # Table structure for table 'phpbb_user_group' # diff --git a/phpBB/db/postgres_schema.sql b/phpBB/db/postgres_schema.sql index 081e9f20ad..c3b6fecd5f 100644 --- a/phpBB/db/postgres_schema.sql +++ b/phpBB/db/postgres_schema.sql @@ -20,24 +20,6 @@ CREATE SEQUENCE phpbb_users_id_seq start 1 increment 1 maxvalue 2147483647 minva CREATE SEQUENCE phpbb_words_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; CREATE SEQUENCE phpbb_groups_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; -/* -------------------------------------------------------- - Table structure for table phpbb_auth_forums --------------------------------------------------------- */ -CREATE TABLE phpbb_auth_forums ( - forum_id int4 DEFAULT '0' NOT NULL, - auth_view int2 DEFAULT '0' NOT NULL, - auth_read int2 DEFAULT '0' NOT NULL, - auth_post int2 DEFAULT '0' NOT NULL, - auth_reply int2 DEFAULT '0' NOT NULL, - auth_edit int2 DEFAULT '0' NOT NULL, - auth_delete int2 DEFAULT '0' NOT NULL, - auth_announce int2 DEFAULT '0' NOT NULL, - auth_sticky int2 DEFAULT '0' NOT NULL, - auth_votecreate int2 DEFAULT '0' NOT NULL, - auth_vote int2 DEFAULT '0' NOT NULL, - auth_attachments int2 DEFAULT '0' NOT NULL -); - /* -------------------------------------------------------- Table structure for table phpbb_auth_access |