aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas
diff options
context:
space:
mode:
authorJames Atkinson <thefinn@users.sourceforge.net>2003-03-04 17:52:50 +0000
committerJames Atkinson <thefinn@users.sourceforge.net>2003-03-04 17:52:50 +0000
commitfd629c7a9ff83de74635b403de31c42c65860ab1 (patch)
tree734b05a784fcf87500fafb2f9d9a3b6a3eeca545 /phpBB/install/schemas
parentc5b9e64505ee45e416a77bb988101c340be0dfa9 (diff)
downloadforums-fd629c7a9ff83de74635b403de31c42c65860ab1.tar
forums-fd629c7a9ff83de74635b403de31c42c65860ab1.tar.gz
forums-fd629c7a9ff83de74635b403de31c42c65860ab1.tar.bz2
forums-fd629c7a9ff83de74635b403de31c42c65860ab1.tar.xz
forums-fd629c7a9ff83de74635b403de31c42c65860ab1.zip
Tons of work on the UCP, see my topic in the development forum for more info
on the bigger changes. Registration should still work, the basic layout of the UCP is also done with the start on the profile settings area. git-svn-id: file:///svn/phpbb/trunk@3591 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas')
-rw-r--r--phpBB/install/schemas/mysql_basic.sql5
-rw-r--r--phpBB/install/schemas/mysql_schema.sql13
2 files changed, 17 insertions, 1 deletions
diff --git a/phpBB/install/schemas/mysql_basic.sql b/phpBB/install/schemas/mysql_basic.sql
index 92fe433e8a..449a6d63fc 100644
--- a/phpBB/install/schemas/mysql_basic.sql
+++ b/phpBB/install/schemas/mysql_basic.sql
@@ -297,7 +297,10 @@ INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, disp
INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('smile/question.gif', 19, 19, 6, 1);
INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('smile/exclaim.gif', 19, 19, 7, 1);
-
+# -- ucp modules
+INSERT INTO phpbb_ucp_modules (module_id, module_name, module_filename, module_order) VALUES (1, 'Profile Settings', 'ucp/usercp_profile', 1);
+INSERT INTO phpbb_ucp_modules (module_id, module_name, module_filename, module_order) VALUES (2, 'Black/While Lists', 'ucp/usercp_lists', 2);
+
# -- wordlist
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 1, 'example', 0 );
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 2, 'post', 0 );
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql
index 40417f45f5..9b4adac724 100644
--- a/phpBB/install/schemas/mysql_schema.sql
+++ b/phpBB/install/schemas/mysql_schema.sql
@@ -654,6 +654,19 @@ CREATE TABLE phpbb_topics_watch (
KEY notify_status (notify_status)
);
+# --------------------------------------------------------
+#
+# Table structure for table 'phpbb_ucp_modules'
+#
+CREATE TABLE phpbb_ucp_modules (
+ module_id mediumint(8) DEFAULT '0' AUTO_INCREMENT NOT NULL,
+ module_name varchar(50) NOT NULL,
+ module_filename varchar(50) NOT NULL,
+ module_order mediumint(4) DEFAULT '0' NOT NULL,
+ KEY module_order (module_order),
+ PRIMARY KEY (module_id)
+);
+
# --------------------------------------------------------
#