Menu
▾
▴
[Phpbb-checkins] CVS: phpBB2/db/schemas mysql_basic.sql,1.18,1.19 mysql_schema.sql,1.22,1.23
|
From: Paul S. O. <ps...@us...> - 2002-06-21 20:12:16
|
Update of /cvsroot/phpbb/phpBB2/db/schemas
In directory usw-pr-cvs1:/tmp/cvs-serv8411/db/schemas
Modified Files:
mysql_basic.sql mysql_schema.sql
Log Message:
A few suggested or preliminary changes ... these aren't fixed and again I suggest no one install (or even manually update) this version at present.
Index: mysql_basic.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mysql_basic.sql,v
retrieving revision 1.18
retrieving revision 1.19
diff -C2 -r1.18 -r1.19
*** mysql_basic.sql 30 Apr 2002 17:56:50 -0000 1.18
--- mysql_basic.sql 21 Jun 2002 20:12:06 -0000 1.19
***************
*** 7,10 ****
--- 7,11 ----
INSERT INTO phpbb_config (config_name, config_value) VALUES ('config_id','1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_disable','0');
+ INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_disable_msg','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('sitename','yourdomain.com');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('site_desc','A _little_ text to describe your forum');
***************
*** 20,36 ****
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_sig','1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_namechange','0');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_theme_create','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_local','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_remote','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_upload','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('override_user_style','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('posts_per_page','15');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('topics_per_page','50');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('hot_threshold','25');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_poll_options','10');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sig_chars','255');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_inbox_privmsgs','50');
- INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sentbox_privmsgs','25');
- INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_savebox_privmsgs','50');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_sig','Thanks, The Management');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email','you...@yo...');
--- 21,40 ----
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_sig','1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_namechange','0');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_topic_notify','1');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_forum_notify','1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_local','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_remote','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_upload','0');
+ INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_style','1');
+ INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_dateformat','D M d, Y g:i a');
+ INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_timezone','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('override_user_style','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('posts_per_page','15');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('topics_per_page','50');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('hot_threshold','25');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_post_chars', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sig_chars','255');
+ INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_poll_options','10');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_inbox_privmsgs','50');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_sig','Thanks, The Management');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email','you...@yo...');
***************
*** 39,42 ****
--- 43,47 ----
INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_username','');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_password','');
+ INSERT INTO phpbb_config (config_name, config_value) VALUES ('ldap_enable','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('require_activation','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('flood_interval','15');
***************
*** 48,57 ****
INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_gallery_path','images/avatars/gallery');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('smilies_path','images/smiles');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_style','1');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_dateformat','D M d, Y g:i a');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_timezone','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('prune_enable','1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('privmsg_disable','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('gzip_compress','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_fax', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_mail', '');
--- 53,62 ----
INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_gallery_path','images/avatars/gallery');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('smilies_path','images/smiles');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('icons_path','images/icons');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('prune_enable','1');
+ INSERT INTO phpbb_config (config_name, config_value) VALUES ('prune_logs_enable','1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('privmsg_disable','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('gzip_compress','0');
+ INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_enable','1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_fax', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_mail', '');
***************
*** 61,68 ****
INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', '80');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '/phpBB2/');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('newest_user_id', 2);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('newest_username', 'Admin');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('num_users', 1);
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.1.0 [20020430]');
--- 66,121 ----
INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', '80');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '/phpBB2/');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('newest_user_id', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('newest_username', 'Admin');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('num_users', '1');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('num_posts', '1');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('num_topics', '1');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('limit_load', '1.0');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('active_sessions', '0');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '2.1.0 [20020430]');
!
!
! # -- auth options
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('forum_list');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('forum_read');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('forum_post');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('forum_reply');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('forum_edit');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('forum_delete');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('forum_poll');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('forum_vote');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('forum_announce');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('forum_sticky');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('forum_attach');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('forum_html');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('forum_bbcode');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('forum_smilies');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('forum_img');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('forum_flash');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('forum_sigs');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('forum_download');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('forum_search');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('forum_email');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('forum_print');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('forum_ignoreflood');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('forum_ignorequeue');
!
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('mod_edit');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('mod_delete');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('mod_move');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('mod_lock');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('mod_split');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('mod_merge');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('mod_approve');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('mod_ban');
!
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('admin_config');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('admin_user');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('admin_group');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('admin_forum');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('admin_posts');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('admin_ban');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('admin_email');
! INSERT INTO phpbb_auth_options (auth_option) VALUES ('admin_backup');
***************
*** 76,83 ****
# -- Users
! INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_style, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_dateformat, user_actkey, user_newpasswd, user_notify, user_active) VALUES ( -1, 'Anonymous', 0, 0, '', '', '', '', '', '', '', '', 0, NULL, '', '', '', 0, 0, 1, 0, 1, 0, 1, 1, NULL, '', '', '', '', '', '', 0, 0);
# -- username: admin password: admin (change this or remove it once everything is working!)
! INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_style, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_popup_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_dateformat, user_actkey, user_newpasswd, user_notify, user_active) VALUES ( 2, 'Admin', 1, 0, '21232f297a57a5a743894a0e4a801fc3', 'ad...@yo...', '', '', '', '', '', '', 1, 1, '', '', '', 1, 0, 1, 0, 1, 1, 1, 1, 1, 1, '', 'english', 0, 'd M Y h:i a', '', '', 0, 1);
--- 129,136 ----
# -- Users
! INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_style, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_dateformat, user_actkey, user_newpasswd, user_notify, user_active) VALUES ( 0, 'Anonymous', 0, 0, '', '', '', '', '', '', '', '', 0, NULL, '', '', '', 0, 0, 1, 0, 1, 0, 1, 1, NULL, '', '', '', '', '', '', 0, 0);
# -- username: admin password: admin (change this or remove it once everything is working!)
! INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_style, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_popup_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_dateformat, user_actkey, user_newpasswd, user_notify, user_active) VALUES ( 1, 'Admin', 1, 0, '21232f297a57a5a743894a0e4a801fc3', 'ad...@yo...', '', '', '', '', '', '', 1, 1, '', '', '', 1, 0, 1, 0, 1, 1, 1, 1, 1, 1, '', 'english', 0, 'd M Y h:i a', '', '', 0, 1);
***************
*** 87,97 ****
# -- Groups
! INSERT INTO phpbb_groups (group_id, group_name, group_description, group_single_user) VALUES (1, 'Anonymous', 'Personal User', 1);
! INSERT INTO phpbb_groups (group_id, group_name, group_description, group_single_user) VALUES (2, 'Admin', 'Personal User', 1);
# -- User -> Group
! INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (1, -1, 0);
! INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (2, 2, 0);
--- 140,148 ----
# -- Groups
! INSERT INTO phpbb_groups (group_id, group_name, group_type) VALUES (1, 'REGISTERED', 0);
# -- User -> Group
! INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (1, 1, 0);
***************
*** 103,112 ****
INSERT INTO phpbb_posts (post_id, topic_id, forum_id, poster_id, post_time, post_username, poster_ip) VALUES (1, 1, 1, 2, 972086460, NULL, '7F000001');
INSERT INTO phpbb_posts_text (post_id, post_subject, post_text) VALUES (1, NULL, 'This is an example post in your phpBB 2 installation. You may delete this post, this topic and even this forum if you like since everything seems to be working!');
-
-
- # -- Themes
- INSERT INTO phpbb_themes (themes_id, template_name, style_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (1, 'subSilver', 'subSilver', 'subSilver.css', '', 'E5E5E5', '000000', '006699', '5493B4', '', 'DD6900', 'EFEFEF', 'DEE3E7', 'D1D7DC', '', '', '', '98AAB1', '006699', 'FFFFFF', 'cellpic1.gif', 'cellpic3.gif', 'cellpic2.jpg', 'FAFAFA', 'FFFFFF', '', 'row1', 'row2', '', 'Verdana, Arial, Helvetica, sans-serif', 'Trebuchet MS', 'Courier, \'Courier New\', sans-serif', 10, 11, 12, '444444', '006600', 'FFA34F', '', '', '');
-
- INSERT INTO phpbb_themes_name (themes_id, tr_color1_name, tr_color2_name, tr_color3_name, tr_class1_name, tr_class2_name, tr_class3_name, th_color1_name, th_color2_name, th_color3_name, th_class1_name, th_class2_name, th_class3_name, td_color1_name, td_color2_name, td_color3_name, td_class1_name, td_class2_name, td_class3_name, fontface1_name, fontface2_name, fontface3_name, fontsize1_name, fontsize2_name, fontsize3_name, fontcolor1_name, fontcolor2_name, fontcolor3_name, span_class1_name, span_class2_name, span_class3_name) VALUES (1, 'The lightest row colour', 'The medium row color', 'The darkest row colour', '', '', '', 'Border round the whole page', 'Outer table border', 'Inner table border', 'Silver gradient picture', 'Blue gradient picture', 'Fade-out gradient on index', 'Background for quote boxes', 'All white areas', '', 'Background for topic posts', '2nd background for topic posts', '', 'Main fonts', 'Additional topic title font', 'Form fonts', 'Smallest font size', 'Medium font size', 'Normal font size (post body etc)', 'Quote & copyright text', 'Code text colour', 'Main table header text colour', '', '', '');
--- 154,157 ----
Index: mysql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mysql_schema.sql,v
retrieving revision 1.22
retrieving revision 1.23
diff -C2 -r1.22 -r1.23
*** mysql_schema.sql 8 Jun 2002 20:31:56 -0000 1.22
--- mysql_schema.sql 21 Jun 2002 20:12:08 -0000 1.23
***************
*** 5,8 ****
--- 5,9 ----
#
+ # --------------------------------------------------------
#
# Table structure for table `phpbb_auth_groups`
***************
*** 15,24 ****
auth_allow_deny tinyint(4) NOT NULL default '1'
)
! # --------------------------------------------------------
#
# Table structure for table `phpbb_auth_options`
#
- DROP TABLE IF EXISTS phpbb_auth_options;
CREATE TABLE phpbb_auth_options (
auth_option_id tinyint(4) NOT NULL auto_increment,
--- 16,24 ----
auth_allow_deny tinyint(4) NOT NULL default '1'
)
!
#
# Table structure for table `phpbb_auth_options`
#
CREATE TABLE phpbb_auth_options (
auth_option_id tinyint(4) NOT NULL auto_increment,
***************
*** 26,35 ****
PRIMARY KEY (auth_option_id,auth_option)
)
- # --------------------------------------------------------
#
# Table structure for table `phpbb_auth_prefetch`
#
- DROP TABLE IF EXISTS phpbb_auth_prefetch;
CREATE TABLE phpbb_auth_prefetch (
user_id mediumint(8) unsigned NOT NULL default '0',
--- 26,35 ----
PRIMARY KEY (auth_option_id,auth_option)
)
+
+ # --------------------------------------------------------
#
# Table structure for table `phpbb_auth_prefetch`
#
CREATE TABLE phpbb_auth_prefetch (
user_id mediumint(8) unsigned NOT NULL default '0',
***************
*** 38,47 ****
auth_allow_deny tinyint(4) NOT NULL default '1')
)
- # --------------------------------------------------------
#
# Table structure for table `phpbb_auth_users`
#
- DROP TABLE IF EXISTS phpbb_auth_users;
CREATE TABLE phpbb_auth_users (
user_id mediumint(8) unsigned NOT NULL default '0',
--- 38,47 ----
auth_allow_deny tinyint(4) NOT NULL default '1')
)
+
+ # --------------------------------------------------------
#
# Table structure for table `phpbb_auth_users`
#
CREATE TABLE phpbb_auth_users (
user_id mediumint(8) unsigned NOT NULL default '0',
***************
*** 51,77 ****
)
- #
- # Table structure for table 'phpbb_auth_access'
- #
- CREATE TABLE phpbb_auth_access (
- group_id mediumint(8) DEFAULT '0' NOT NULL,
- forum_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
- auth_view tinyint(1) DEFAULT '0' NOT NULL,
- auth_read tinyint(1) DEFAULT '0' NOT NULL,
- auth_post tinyint(1) DEFAULT '0' NOT NULL,
- auth_reply tinyint(1) DEFAULT '0' NOT NULL,
- auth_edit tinyint(1) DEFAULT '0' NOT NULL,
- auth_delete tinyint(1) DEFAULT '0' NOT NULL,
- auth_sticky tinyint(1) DEFAULT '0' NOT NULL,
- auth_announce tinyint(1) DEFAULT '0' NOT NULL,
- auth_vote tinyint(1) DEFAULT '0' NOT NULL,
- auth_pollcreate tinyint(1) DEFAULT '0' NOT NULL,
- auth_attachments tinyint(1) DEFAULT '0' NOT NULL,
- auth_mod tinyint(1) DEFAULT '0' NOT NULL,
- KEY group_id (group_id),
- KEY forum_id (forum_id)
- );
-
#
# Table structure for table 'phpbb_user_group'
--- 51,56 ----
)
+ # --------------------------------------------------------
#
# Table structure for table 'phpbb_user_group'
***************
*** 85,88 ****
--- 64,69 ----
);
+
+ # --------------------------------------------------------
#
# Table structure for table 'phpbb_groups'
***************
*** 99,102 ****
--- 80,84 ----
+ # --------------------------------------------------------
#
# Table structure for table 'phpbb_groups_moderator'
***************
*** 113,120 ****
#
CREATE TABLE phpbb_banlist (
! ban_id mediumint(8) UNSIGNED NOT NULL auto_increment,
! ban_userid mediumint(8) NOT NULL,
! ban_ip char(40) NOT NULL,
! ban_email char(50),
PRIMARY KEY (ban_id),
KEY ban_ip_user_id (ban_ip, ban_userid)
--- 95,102 ----
#
CREATE TABLE phpbb_banlist (
! ban_id mediumint(8) UNSIGNED NOT NULL auto_increment,
! ban_userid mediumint(8) NOT NULL,
! ban_ip char(40) NOT NULL,
! ban_email char(50),
PRIMARY KEY (ban_id),
KEY ban_ip_user_id (ban_ip, ban_userid)
***************
*** 124,128 ****
# --------------------------------------------------------
#
! # Table structure for table 'phpbb_categories'
#
CREATE TABLE phpbb_categories (
--- 106,110 ----
# --------------------------------------------------------
#
! # Table structure for table 'phpbb_categories' <- DUMP THIS?
#
CREATE TABLE phpbb_categories (
***************
*** 159,176 ****
# --------------------------------------------------------
#
- # Table structure for table 'phpbb_forum_prune'
- #
- CREATE TABLE phpbb_forum_prune (
- prune_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- forum_id smallint(5) UNSIGNED NOT NULL,
- prune_days tinyint(4) UNSIGNED NOT NULL,
- prune_freq tinyint(4) UNSIGNED NOT NULL,
- PRIMARY KEY(prune_id),
- KEY forum_id (forum_id)
- );
-
-
- # --------------------------------------------------------
- #
# Table structure for table 'phpbb_forums'
#
--- 141,144 ----
***************
*** 178,188 ****
forum_id smallint(5) UNSIGNED NOT NULL,
parent_id smallint(5) UNSIGNED NOT NULL,
! cat_id mediumint(8) UNSIGNED NOT NULL,
! forum_name varchar(150),
forum_desc text,
forum_status tinyint(4) DEFAULT '0' NOT NULL,
- forum_order mediumint(8) UNSIGNED DEFAULT '1' NOT NULL,
forum_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
forum_topics mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
--- 146,158 ----
forum_id smallint(5) UNSIGNED NOT NULL,
parent_id smallint(5) UNSIGNED NOT NULL,
+ forum_order smallint(5) UNSIGNED DEFAULT '1' NOT NULL,
! left_id smallint(5) UNSIGNED NOT NULL,
! right_id smallint(5) UNSIGNED NOT NULL,
! forum_name varchar(150) NOT NULL,
forum_desc text,
+ forum_image varchar(50),
forum_status tinyint(4) DEFAULT '0' NOT NULL,
forum_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
forum_topics mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
***************
*** 191,212 ****
prune_next int(11) UNSIGNED,
prune_days tinyint(4) UNSIGNED NOT NULL,
! prune_freq tinyint(4) UNSIGNED DEFAULT '0' NOT NULL,
!
! prune_enable tinyint(1) DEFAULT '0' NOT NULL,
! auth_view tinyint(2) DEFAULT '0' NOT NULL,
! auth_read tinyint(2) DEFAULT '0' NOT NULL,
! auth_post tinyint(2) DEFAULT '0' NOT NULL,
! auth_reply tinyint(2) DEFAULT '0' NOT NULL,
! auth_edit tinyint(2) DEFAULT '0' NOT NULL,
! auth_delete tinyint(2) DEFAULT '0' NOT NULL,
! auth_sticky tinyint(2) DEFAULT '0' NOT NULL,
! auth_announce tinyint(2) DEFAULT '0' NOT NULL,
! auth_vote tinyint(2) DEFAULT '0' NOT NULL,
! auth_pollcreate tinyint(2) DEFAULT '0' NOT NULL,
! auth_attachments tinyint(2) DEFAULT '0' NOT NULL,
!
! PRIMARY KEY (forum_id),
! KEY forums_order (forum_order),
! KEY cat_id (cat_id),
KEY forum_last_post_id (forum_last_post_id)
);
--- 161,170 ----
prune_next int(11) UNSIGNED,
prune_days tinyint(4) UNSIGNED NOT NULL,
! prune_freq tinyint(4) UNSIGNED DEFAULT '0' NOT NULL,
! default_style tinyint(4) UNSIGNED,
! default_group mediumint(8) UNSIGNED,
! default_user mediumint(8) UNSIGNED,
! PRIMARY KEY (forum_id),
! KEY forums_order (forum_order),
KEY forum_last_post_id (forum_last_post_id)
);
***************
*** 229,232 ****
--- 187,248 ----
# --------------------------------------------------------
#
+ # Table structure for table 'phpbb_icons'
+ #
+ CREATE TABLE phpbb_icons (
+ icons_id tinyint(4) UNSIGNED NOT NULL auto_increment,
+ icons_url char(50),
+ icons_width tinyint(4) UNSIGNED NOT NULL,
+ icons_height tinyint(4) UNSIGNED NOT NULL,
+ PRIMARY KEY (icons_id)
+ );
+
+
+ # --------------------------------------------------------
+ #
+ # Table structure for table 'phpbb_log_moderator'
+ #
+ CREATE TABLE phpbb_log_moderator (
+ log_id mediumint(5) UNSIGNED NOT NULL DEFAULT '0',
+ user_id mediumint(8) NOT NULL DEFAULT '0',
+ forum_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
+ log_ip varchar(40) NOT NULL,
+ log_time int(11) NOT NULL,
+ log_operation varchar(255),
+ PRIMARY KEY (log_id),
+ KEY forum_id (forum_id),
+ KEY user_id (user_id)
+ );
+
+
+ # --------------------------------------------------------
+ #
+ # Table structure for table 'phpbb_vote_results'
+ #
+ CREATE TABLE phpbb_poll_results (
+ poll_option_id tinyint(4) UNSIGNED NOT NULL DEFAULT '0',
+ topic_id mediumint(8) UNSIGNED NOT NULL,
+ poll_option_text varchar(255) NOT NULL,
+ KEY poll_option_id (poll_option_id),
+ KEY topic_id (topic_id)
+ );
+
+
+ # --------------------------------------------------------
+ #
+ # Table structure for table 'phpbb_vote_voters'
+ #
+ CREATE TABLE phpbb_poll_voters (
+ vote_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
+ poll_option_id tinyint(4) UNSIGNED NOT NULL DEFAULT '0',
+ vote_user_id mediumint(8) NOT NULL DEFAULT '0',
+ vote_user_ip char(40) NOT NULL,
+ KEY vote_id (vote_id),
+ KEY vote_user_id (vote_user_id),
+ KEY vote_user_ip (vote_user_ip)
+ );
+
+
+ # --------------------------------------------------------
+ #
# Table structure for table 'phpbb_posts'
#
***************
*** 236,248 ****
forum_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
poster_id mediumint(8) DEFAULT '0' NOT NULL,
- post_time int(11) DEFAULT '0' NOT NULL,
poster_ip char(40) NOT NULL,
! post_username varchar(25),
enable_bbcode tinyint(1) DEFAULT '1' NOT NULL,
enable_html tinyint(1) DEFAULT '0' NOT NULL,
enable_smilies tinyint(1) DEFAULT '1' NOT NULL,
enable_sig tinyint(1) DEFAULT '1' NOT NULL,
! post_edit_time int(11),
! post_edit_count smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
PRIMARY KEY (post_id),
KEY forum_id (forum_id),
--- 252,266 ----
forum_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
poster_id mediumint(8) DEFAULT '0' NOT NULL,
poster_ip char(40) NOT NULL,
! post_time int(11) DEFAULT '0' NOT NULL,
! post_approved tinyint(1) DEFAULT '1' NOT NULL,
! post_username char(30),
enable_bbcode tinyint(1) DEFAULT '1' NOT NULL,
enable_html tinyint(1) DEFAULT '0' NOT NULL,
enable_smilies tinyint(1) DEFAULT '1' NOT NULL,
+ enable_magic_url tinyint(1) DEFAULT '1' NOT NULL,
enable_sig tinyint(1) DEFAULT '1' NOT NULL,
! post_edit_time int(11),
! post_edit_count smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
PRIMARY KEY (post_id),
KEY forum_id (forum_id),
***************
*** 306,313 ****
CREATE TABLE phpbb_ranks (
rank_id smallint(5) UNSIGNED NOT NULL auto_increment,
! rank_title char(50) NOT NULL,
rank_min mediumint(8) DEFAULT '0' NOT NULL,
rank_special tinyint(1) DEFAULT '0',
! rank_image char(100),
PRIMARY KEY (rank_id)
);
--- 324,332 ----
CREATE TABLE phpbb_ranks (
rank_id smallint(5) UNSIGNED NOT NULL auto_increment,
! rank_title varchar(50) NOT NULL,
rank_min mediumint(8) DEFAULT '0' NOT NULL,
rank_special tinyint(1) DEFAULT '0',
! rank_image varchar(100),
! rank_colour varchar(6),
PRIMARY KEY (rank_id)
);
***************
*** 320,324 ****
CREATE TABLE phpbb_search_results (
search_id int(11) UNSIGNED NOT NULL default '0',
! session_id char(32) NOT NULL default '',
search_array text NOT NULL,
PRIMARY KEY (search_id),
--- 339,343 ----
CREATE TABLE phpbb_search_results (
search_id int(11) UNSIGNED NOT NULL default '0',
! session_id varchar(32) NOT NULL default '',
search_array text NOT NULL,
PRIMARY KEY (search_id),
***************
*** 332,336 ****
#
CREATE TABLE phpbb_search_wordlist (
! word_text char(25) binary NOT NULL default '',
word_id mediumint(8) UNSIGNED NOT NULL auto_increment,
word_common tinyint(1) unsigned NOT NULL default '0',
--- 351,355 ----
#
CREATE TABLE phpbb_search_wordlist (
! word_text varchar(25) binary NOT NULL default '',
word_id mediumint(8) UNSIGNED NOT NULL auto_increment,
word_common tinyint(1) unsigned NOT NULL default '0',
***************
*** 339,342 ****
--- 358,362 ----
);
+
# --------------------------------------------------------
#
***************
*** 356,366 ****
#
CREATE TABLE phpbb_sessions (
! session_id char(32) DEFAULT '' NOT NULL,
session_user_id mediumint(8) DEFAULT '0' NOT NULL,
session_start int(11) DEFAULT '0' NOT NULL,
session_time int(11) DEFAULT '0' NOT NULL,
! session_ip char(40) DEFAULT '0' NOT NULL,
! session_browser char(100) DEFAULT '' NOT NULL,
! session_page char(50) DEFAULT '0' NOT NULL,
PRIMARY KEY (session_id),
KEY session_user_id (session_user_id),
--- 376,386 ----
#
CREATE TABLE phpbb_sessions (
! session_id varchar(32) DEFAULT '' NOT NULL,
session_user_id mediumint(8) DEFAULT '0' NOT NULL,
session_start int(11) DEFAULT '0' NOT NULL,
session_time int(11) DEFAULT '0' NOT NULL,
! session_ip varchar(40) DEFAULT '0' NOT NULL,
! session_browser varchar(100) DEFAULT '' NULL,
! session_page varchar(50) DEFAULT '0' NOT NULL,
PRIMARY KEY (session_id),
KEY session_user_id (session_user_id),
***************
*** 369,377 ****
CREATE TABLE phpbb_smilies (
smilies_id tinyint(4) UNSIGNED NOT NULL auto_increment,
! code char(10),
! smile_url char(50),
! emoticon char(50),
PRIMARY KEY (smilies_id)
);
--- 389,403 ----
+ # --------------------------------------------------------
+ #
+ # Table structure for table 'phpbb_smilies'
+ #
CREATE TABLE phpbb_smilies (
smilies_id tinyint(4) UNSIGNED NOT NULL auto_increment,
! code char(10),
! smile_url char(50),
! smile_width tinyint(4) UNSIGNED NOT NULL,
! smile_height tinyint(4) UNSIGNED NOT NULL,
! emoticon char(50),
PRIMARY KEY (smilies_id)
);
***************
*** 380,430 ****
# --------------------------------------------------------
#
! # Table structure for table 'phpbb_themes'
#
! CREATE TABLE phpbb_themes (
! themes_id mediumint(8) UNSIGNED NOT NULL auto_increment,
! template_name char(30) NOT NULL default '',
! style_name char(30) NOT NULL default '',
! head_stylesheet char(100) default NULL,
! body_background char(100) default NULL,
! body_bgcolor char(6) default NULL,
! body_text char(6) default NULL,
! body_link char(6) default NULL,
! body_vlink char(6) default NULL,
! body_alink char(6) default NULL,
! body_hlink char(6) default NULL,
! tr_color1 char(6) default NULL,
! tr_color2 char(6) default NULL,
! tr_color3 char(6) default NULL,
! tr_class1 char(25) default NULL,
! tr_class2 char(25) default NULL,
! tr_class3 char(25) default NULL,
! th_color1 char(6) default NULL,
! th_color2 char(6) default NULL,
! th_color3 char(6) default NULL,
! th_class1 char(25) default NULL,
! th_class2 char(25) default NULL,
! th_class3 char(25) default NULL,
! td_color1 char(6) default NULL,
! td_color2 char(6) default NULL,
! td_color3 char(6) default NULL,
! td_class1 char(25) default NULL,
! td_class2 char(25) default NULL,
! td_class3 char(25) default NULL,
! fontface1 char(50) default NULL,
! fontface2 char(50) default NULL,
! fontface3 char(50) default NULL,
! fontsize1 tinyint(4) default NULL,
! fontsize2 tinyint(4) default NULL,
! fontsize3 tinyint(4) default NULL,
! fontcolor1 char(6) default NULL,
! fontcolor2 char(6) default NULL,
! fontcolor3 char(6) default NULL,
! span_class1 char(25) default NULL,
! span_class2 char(25) default NULL,
! span_class3 char(25) default NULL,
! img_size_poll smallint(5) UNSIGNED,
! img_size_privmsg smallint(5) UNSIGNED,
! PRIMARY KEY (themes_id)
);
--- 406,419 ----
# --------------------------------------------------------
#
! # Table structure for table 'phpbb_styles'
#
! CREATE TABLE phpbb_styles (
! style_id tinyint(4) UNSIGNED NOT NULL auto_increment,
! theme_id tinyint(4) UNSIGNED NOT NULL,
! template_name char(50) NOT NULL,
! style_name char(30) NOT NULL,
! style_default tinyint(1) DEFAULT '1' NOT NULL,
! PRIMARY KEY (style_id),
! KEY (theme_id)
);
***************
*** 432,470 ****
# --------------------------------------------------------
#
! # Table structure for table 'phpbb_themes_name'
! #
! CREATE TABLE phpbb_themes_name (
! themes_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
! tr_color1_name char(50),
! tr_color2_name char(50),
! tr_color3_name char(50),
! tr_class1_name char(50),
! tr_class2_name char(50),
! tr_class3_name char(50),
! th_color1_name char(50),
! th_color2_name char(50),
! th_color3_name char(50),
! th_class1_name char(50),
! th_class2_name char(50),
! th_class3_name char(50),
! td_color1_name char(50),
! td_color2_name char(50),
! td_color3_name char(50),
! td_class1_name char(50),
! td_class2_name char(50),
! td_class3_name char(50),
! fontface1_name char(50),
! fontface2_name char(50),
! fontface3_name char(50),
! fontsize1_name char(50),
! fontsize2_name char(50),
! fontsize3_name char(50),
! fontcolor1_name char(50),
! fontcolor2_name char(50),
! fontcolor3_name char(50),
! span_class1_name char(50),
! span_class2_name char(50),
! span_class3_name char(50),
! PRIMARY KEY (themes_id)
);
--- 421,431 ----
# --------------------------------------------------------
#
! # Table structure for table 'phpbb_styles_css'
! #
! CREATE TABLE phpbb_styles_css (
! theme_id mediumint(8) UNSIGNED NOT NULL auto_increment,
! css_data text NOT NULL,
! css_extra_data text NOT NULL,
! KEY (theme_id)
);
***************
*** 477,496 ****
topic_id mediumint(8) UNSIGNED NOT NULL auto_increment,
forum_id smallint(8) UNSIGNED DEFAULT '0' NOT NULL,
! topic_title char(60) NOT NULL,
topic_poster mediumint(8) DEFAULT '0' NOT NULL,
topic_time int(11) DEFAULT '0' NOT NULL,
topic_views mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
topic_replies mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- topic_approved tinyint(1) DEFAULT '1' NOT NULL,
topic_status tinyint(3) DEFAULT '0' NOT NULL,
- topic_vote tinyint(1) DEFAULT '0' NOT NULL,
topic_type tinyint(3) DEFAULT '0' NOT NULL,
! increment_post_count tinyint(1) DEFAULT '1' NOT NULL,
! topic_first_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
! topic_last_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
! topic_moved_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
PRIMARY KEY (topic_id),
! KEY forum_id (forum_id),
! KEY topic_moved_id (topic_moved_id),
KEY topic_status (topic_status),
KEY topic_type (topic_type)
--- 438,460 ----
topic_id mediumint(8) UNSIGNED NOT NULL auto_increment,
forum_id smallint(8) UNSIGNED DEFAULT '0' NOT NULL,
! topic_title varchar(60) NOT NULL,
topic_poster mediumint(8) DEFAULT '0' NOT NULL,
topic_time int(11) DEFAULT '0' NOT NULL,
+ topic_icon tinyint(4) UNSIGNED,
topic_views mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
topic_replies mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
topic_status tinyint(3) DEFAULT '0' NOT NULL,
topic_type tinyint(3) DEFAULT '0' NOT NULL,
! topic_first_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
! topic_last_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
! topic_moved_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
! post_count_inc tinyint(1) DEFAULT '1' NOT NULL,
! poll_title varchar(255) NOT NULL,
! poll_start int(11) NOT NULL DEFAULT '0',
! poll_length int(11) NOT NULL DEFAULT '0',
! poll_last_vote int(11),
PRIMARY KEY (topic_id),
! KEY forum_id (forum_id),
! KEY topic_moved_id (topic_moved_id),
KEY topic_status (topic_status),
KEY topic_type (topic_type)
***************
*** 520,525 ****
user_id mediumint(8) NOT NULL auto_increment,
user_active tinyint(1) DEFAULT '1',
! username char(30) NOT NULL,
! user_password char(32) NOT NULL,
user_session_time int(11) DEFAULT '0' NOT NULL,
user_session_page smallint(5) DEFAULT '0' NOT NULL,
--- 484,490 ----
user_id mediumint(8) NOT NULL auto_increment,
user_active tinyint(1) DEFAULT '1',
! username varchar(30) NOT NULL,
! user_password varchar(32) NOT NULL,
! user_email varchar(60),
user_session_time int(11) DEFAULT '0' NOT NULL,
user_session_page smallint(5) DEFAULT '0' NOT NULL,
***************
*** 528,540 ****
user_level tinyint(4) DEFAULT '0',
user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
user_timezone decimal(4,2) DEFAULT '0' NOT NULL,
! user_style tinyint(4),
! user_lang char(50),
! user_dateformat char(15) DEFAULT 'd M Y H:i' NOT NULL,
user_new_privmsg smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
user_unread_privmsg smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
user_last_privmsg int(11) DEFAULT '0' NOT NULL,
user_emailtime int(11),
! user_viewemail tinyint(1),
user_attachsig tinyint(1),
user_allowhtml tinyint(1) DEFAULT '1',
--- 493,508 ----
user_level tinyint(4) DEFAULT '0',
user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
+ user_lang varchar(50),
user_timezone decimal(4,2) DEFAULT '0' NOT NULL,
! user_dateformat varchar(15) DEFAULT 'd M Y H:i' NOT NULL,
! user_style tinyint(4),
user_new_privmsg smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
user_unread_privmsg smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
user_last_privmsg int(11) DEFAULT '0' NOT NULL,
user_emailtime int(11),
! user_viewemail tinyint(1) DEFAULT '1' NOT NULL,
! user_viewsigs tinyint(1) DEFAULT '1' NOT NULL,
! user_viewavatars tinyint(1) DEFAULT '1' NOT NULL,
! user_viewimg tinyint(1) DEFAULT '1' NOT NULL,
user_attachsig tinyint(1),
user_allowhtml tinyint(1) DEFAULT '1',
***************
*** 544,547 ****
--- 512,516 ----
user_allow_pm tinyint(1) DEFAULT '1' NOT NULL,
user_allow_viewonline tinyint(1) DEFAULT '1' NOT NULL,
+ user_allow_email tinyint(1) DEFAULT '1' NOT NULL,
user_notify tinyint(1) DEFAULT '1' NOT NULL,
user_notify_pm tinyint(1) DEFAULT '1' NOT NULL,
***************
*** 550,613 ****
user_avatar char(100),
user_avatar_type tinyint(4) DEFAULT '0' NOT NULL,
! user_email char(60),
user_sig text,
! user_sig_bbcode_uid char(10),
- user_icq varchar(15),
- user_website varchar(100),
- user_from varchar(100),
- user_aim varchar(255),
- user_yim varchar(255),
- user_msnm varchar(255),
user_occ varchar(100),
user_interests varchar(255),
- user_actkey varchar(32),
- user_newpasswd varchar(32),
PRIMARY KEY (user_id),
KEY user_session_time (user_session_time)
- );
-
-
- # --------------------------------------------------------
- #
- # Table structure for table 'phpbb_vote_desc'
- #
- CREATE TABLE phpbb_vote_desc (
- vote_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- topic_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- vote_text text NOT NULL,
- vote_start int(11) NOT NULL DEFAULT '0',
- vote_length int(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (vote_id),
- KEY topic_id (topic_id)
- );
-
-
- # --------------------------------------------------------
- #
- # Table structure for table 'phpbb_vote_results'
- #
- CREATE TABLE phpbb_vote_results (
- vote_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- vote_option_id tinyint(4) UNSIGNED NOT NULL DEFAULT '0',
- vote_option_text varchar(255) NOT NULL,
- vote_result int(11) NOT NULL DEFAULT '0',
- KEY vote_option_id (vote_option_id),
- KEY vote_id (vote_id)
- );
-
-
- # --------------------------------------------------------
- #
- # Table structure for table 'phpbb_vote_voters'
- #
- CREATE TABLE phpbb_vote_voters (
- vote_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- vote_user_id mediumint(8) NOT NULL DEFAULT '0',
- vote_user_ip char(40) NOT NULL,
- KEY vote_id (vote_id),
- KEY vote_user_id (vote_user_id),
- KEY vote_user_ip (vote_user_ip)
);
--- 519,540 ----
user_avatar char(100),
user_avatar_type tinyint(4) DEFAULT '0' NOT NULL,
! user_avatar_width tinyint(4) UNSIGNED,
! user_avatar_height tinyint(4) UNSIGNED,
user_sig text,
! user_sig_bbcode_uid varchar(10),
! user_from varchar(100),
! user_icq varchar(15),
! user_aim varchar(255),
! user_yim varchar(255),
! user_msnm varchar(255),
! user_website varchar(100),
! user_actkey varchar(32),
! user_newpasswd varchar(32),
user_occ varchar(100),
user_interests varchar(255),
PRIMARY KEY (user_id),
KEY user_session_time (user_session_time)
);
|
