diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-09-06 00:29:07 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-09-06 00:29:07 +0000 |
| commit | ef36331c3e4201f36c3ff76a0d450e11292c2bea (patch) | |
| tree | c16a511dc7173edad0e349a95d3c9dd6e0b4e340 /phpBB/db/mysql_schema.sql | |
| parent | 620e60adbb21fcbae5d330900183f66a32f6a746 (diff) | |
| download | forums-ef36331c3e4201f36c3ff76a0d450e11292c2bea.tar forums-ef36331c3e4201f36c3ff76a0d450e11292c2bea.tar.gz forums-ef36331c3e4201f36c3ff76a0d450e11292c2bea.tar.bz2 forums-ef36331c3e4201f36c3ff76a0d450e11292c2bea.tar.xz forums-ef36331c3e4201f36c3ff76a0d450e11292c2bea.zip | |
Numerous updates and additions for polling and assorted fixes ... or bugs, whichever they turn out to be
git-svn-id: file:///svn/phpbb/trunk@987 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db/mysql_schema.sql')
| -rw-r--r-- | phpBB/db/mysql_schema.sql | 174 |
1 files changed, 110 insertions, 64 deletions
diff --git a/phpBB/db/mysql_schema.sql b/phpBB/db/mysql_schema.sql index 5e3a8c168a..22e7c9913d 100644 --- a/phpBB/db/mysql_schema.sql +++ b/phpBB/db/mysql_schema.sql @@ -7,7 +7,6 @@ # # Table structure for table 'phpbb_auth_access' # - DROP TABLE IF EXISTS phpbb_auth_access; CREATE TABLE phpbb_auth_access ( group_id int(11) DEFAULT '0' NOT NULL, @@ -18,25 +17,25 @@ CREATE TABLE phpbb_auth_access ( 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_announce tinyint(1) DEFAULT '0' NOT NULL, auth_sticky tinyint(1) DEFAULT '0' NOT NULL, - auth_votecreate tinyint(1) DEFAULT '0' NOT NULL, - auth_attachments tinyint(1) DEFAULT '0' NOT NULL, + auth_announce tinyint(1) DEFAULT '0' NOT NULL, auth_vote tinyint(1) DEFAULT '0' NOT NULL, - auth_mod 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' # - DROP TABLE IF EXISTS phpbb_user_group; CREATE TABLE phpbb_user_group ( group_id int(11) DEFAULT '0' NOT NULL, user_id int(11) DEFAULT '0' NOT NULL, - user_pending tinyint(1), + user_pending tinyint(1), KEY group_id (group_id), KEY user_id (user_id) ); @@ -47,15 +46,16 @@ CREATE TABLE phpbb_user_group ( DROP TABLE IF EXISTS phpbb_groups; CREATE TABLE phpbb_groups ( group_id int(11) NOT NULL auto_increment, - group_type tinyint(4) DEFAULT '1' NOT NULL, + group_type tinyint(4) DEFAULT '1' NOT NULL, group_name varchar(40) NOT NULL, group_description varchar(255) NOT NULL, group_moderator int(11) DEFAULT '0' NOT NULL, group_single_user tinyint(1) DEFAULT '0' NOT NULL, - PRIMARY KEY (group_id), + PRIMARY KEY (group_id), KEY group_single_user (group_single_user) ); + # -------------------------------------------------------- # # Table structure for table 'phpbb_banlist' @@ -66,7 +66,7 @@ CREATE TABLE phpbb_banlist ( ban_userid int(11) NOT NULL, ban_ip char(8) NOT NULL, ban_email varchar(255), - PRIMARY KEY (ban_id), + PRIMARY KEY (ban_id), KEY ban_ip_user_id (ban_ip, ban_userid) ); @@ -80,7 +80,7 @@ CREATE TABLE phpbb_categories ( cat_id int(11) NOT NULL auto_increment, cat_title varchar(100), cat_order int(11) NOT NULL, - PRIMARY KEY (cat_id), + PRIMARY KEY (cat_id), KEY cat_order (cat_order) ); @@ -92,46 +92,47 @@ CREATE TABLE phpbb_categories ( DROP TABLE IF EXISTS phpbb_config; CREATE TABLE phpbb_config ( config_id int(11) NOT NULL auto_increment, - board_disable tinyint(1) DEFAULT '0' NOT NULL, - board_startdate int(11), + board_disable tinyint(1) DEFAULT '0' NOT NULL, + board_startdate int(11), sitename varchar(100), cookie_name char(20), cookie_path char(25), - cookie_domain char(50), - cookie_secure tinyint(1), - session_length int(11), + cookie_domain char(50), + cookie_secure tinyint(1), + session_length int(11), allow_html tinyint(1), - allow_html_tags char(255) DEFAULT 'b,u,i,pre,font color' NOT NULL, + allow_html_tags char(255) DEFAULT 'b,u,i,pre,font color' NOT NULL, allow_bbcode tinyint(1), allow_smilies tinyint(1), allow_sig tinyint(1), allow_namechange tinyint(1), allow_theme_create tinyint(1), - allow_avatar_local tinyint(1) DEFAULT '0' NOT NULL, - allow_avatar_remote tinyint(1) DEFAULT '0' NOT NULL, + allow_avatar_local tinyint(1) DEFAULT '0' NOT NULL, + allow_avatar_remote tinyint(1) DEFAULT '0' NOT NULL, allow_avatar_upload tinyint(1) DEFAULT '0' NOT NULL, override_themes tinyint(3), posts_per_page int(11), topics_per_page int(11), hot_threshold int(11), + max_poll_options int(11), email_sig varchar(255), - email_from varchar(100), - smtp_delivery smallint(1) DEFAULT '0' NOT NULL, - smtp_host varchar(50), - require_activation tinyint(1) DEFAULT '0' NOT NULL, + email_from varchar(100), + smtp_delivery tinyint(1) DEFAULT '0' NOT NULL, + smtp_host varchar(50), + require_activation tinyint(1) DEFAULT '0' NOT NULL, flood_interval int(4) NOT NULL, avatar_filesize int(11) DEFAULT '6144' NOT NULL, - avatar_max_width smallint(6) DEFAULT '70' NOT NULL, - avatar_max_height smallint(6) DEFAULT '70' NOT NULL, + avatar_max_width smallint(6) DEFAULT '70' NOT NULL, + avatar_max_height smallint(6) DEFAULT '70' NOT NULL, avatar_path varchar(255) DEFAULT 'images/avatars' NOT NULL, - smilies_path char(100) DEFAULT 'images/smiles' NOT NULL, + smilies_path char(100) DEFAULT 'images/smiles' NOT NULL, default_theme int(11) DEFAULT '1' NOT NULL, default_lang varchar(255), default_dateformat varchar(14) DEFAULT 'd M Y H:i' NOT NULL, system_timezone int(11) DEFAULT '0' NOT NULL, sys_template varchar(100) DEFAULT 'Default' NOT NULL, - prune_enable tinyint(1) DEFAULT '0' NOT NULL, - gzip_compress tinyint(1) DEFAULT '0' NOT NULL, + prune_enable tinyint(1) DEFAULT '1' NOT NULL, + gzip_compress tinyint(1) DEFAULT '0' NOT NULL, PRIMARY KEY (config_id) ); @@ -162,6 +163,7 @@ CREATE TABLE phpbb_forum_prune ( KEY forum_id (forum_id) ); + # -------------------------------------------------------- # # Table structure for table 'phpbb_forums' @@ -172,33 +174,32 @@ CREATE TABLE phpbb_forums ( cat_id int(11) NOT NULL, forum_name varchar(150), forum_desc text, - forum_status tinyint(4) DEFAULT '0' NOT NULL, + forum_status tinyint(4) DEFAULT '0' NOT NULL, forum_order int(11) DEFAULT '1' NOT NULL, forum_posts int(11) DEFAULT '0' NOT NULL, - forum_topics tinyint(4) DEFAULT '0' NOT NULL, + forum_topics int(11) DEFAULT '0' NOT NULL, forum_last_post_id int(11) DEFAULT '0' NOT NULL, prune_next int(11), prune_enable tinyint(1) DEFAULT '1' 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, + 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 forum_id (forum_id), KEY forums_order (forum_order), - KEY cat_id (cat_id), + KEY cat_id (cat_id), KEY forum_last_post_id (forum_last_post_id) ); - # -------------------------------------------------------- # # Table structure for table 'phpbb_posts' @@ -210,14 +211,14 @@ CREATE TABLE phpbb_posts ( forum_id int(11) DEFAULT '0' NOT NULL, poster_id int(11) DEFAULT '0' NOT NULL, post_time int(11) DEFAULT '0' NOT NULL, - poster_ip char(8) NOT NULL, - post_username varchar(30), - enable_bbcode smallint(1) DEFAULT '1' NOT NULL, - enable_html smallint(1) DEFAULT '0' NOT NULL, - enable_smilies smallint(1) DEFAULT '1' NOT NULL, + poster_ip char(8) NOT NULL, + post_username varchar(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, bbcode_uid char(10) NOT NULL, post_edit_time int(11), - post_edit_count smallint(4) DEFAULT '0' NOT NULL, + post_edit_count smallint(6) DEFAULT '0' NOT NULL, PRIMARY KEY (post_id), KEY forum_id (forum_id), KEY topic_id (topic_id), @@ -242,7 +243,6 @@ CREATE TABLE phpbb_posts_text ( # # Table structure for table 'phpbb_privmsgs' # - DROP TABLE IF EXISTS phpbb_privmsgs; CREATE TABLE phpbb_privmsgs ( privmsgs_id int(11) NOT NULL auto_increment, @@ -252,10 +252,10 @@ CREATE TABLE phpbb_privmsgs ( privmsgs_to_userid int(11) DEFAULT '0' NOT NULL, privmsgs_date int(11) DEFAULT '0' NOT NULL, privmsgs_ip char(8) NOT NULL, - privmsgs_enable_bbcode smallint(1) DEFAULT '1' NOT NULL, - privmsgs_enable_html smallint(1) DEFAULT '0' NOT NULL, - privmsgs_enable_smilies smallint(1) DEFAULT '1' NOT NULL, - privmsgs_bbcode_uid char(10) DEFAULT '0' NOT NULL, + privmsgs_enable_bbcode tinyint(1) DEFAULT '1' NOT NULL, + privmsgs_enable_html tinyint(1) DEFAULT '0' NOT NULL, + privmsgs_enable_smilies tinyint(1) DEFAULT '1' NOT NULL, + privmsgs_bbcode_uid char(10) DEFAULT '0' NOT NULL, PRIMARY KEY (privmsgs_id), KEY privmsgs_from_userid (privmsgs_from_userid), KEY privmsgs_to_userid (privmsgs_to_userid) @@ -266,7 +266,6 @@ CREATE TABLE phpbb_privmsgs ( # # Table structure for table 'phpbb_privmsgs_text' # - DROP TABLE IF EXISTS phpbb_privmsgs_text; CREATE TABLE phpbb_privmsgs_text ( privmsgs_text_id int(11) DEFAULT '0' NOT NULL, @@ -287,7 +286,7 @@ CREATE TABLE phpbb_ranks ( rank_max int(11) DEFAULT '0' NOT NULL, rank_special tinyint(1) DEFAULT '0', rank_image varchar(255), - PRIMARY KEY (rank_id) + PRIMARY KEY (rank_id) ); @@ -299,7 +298,7 @@ CREATE TABLE phpbb_ranks ( # this table a type HEAP. This type of table is stored # within system memory and therefore for big busy boards # is likely to be noticeably faster than continually -# writing to disk ... +# writing to disk ... # # I must admit I read about this type on vB's board. # Hey, I never said you cannot get basic ideas from @@ -442,6 +441,7 @@ CREATE TABLE phpbb_topics ( topic_views int(11) DEFAULT '0' NOT NULL, topic_replies int(11) DEFAULT '0' 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, topic_last_post_id int(11) DEFAULT '0' NOT NULL, topic_moved_id int(11), @@ -460,7 +460,7 @@ CREATE TABLE phpbb_topics_watch ( user_id int(11) NOT NULL DEFAULT '0', notify_status tinyint(1) NOT NULL default '0', KEY topic_id (topic_id), - KEY user_id (user_id), + KEY user_id (user_id), KEY notify_status (notify_status) ); @@ -487,12 +487,12 @@ CREATE TABLE phpbb_users ( user_attachsig tinyint(1), user_allowhtml tinyint(1), user_allowbbcode tinyint(1), - user_allowsmile tinyint(1), - user_allowavatar tinyint(1) DEFAULT '1' NOT NULL, - user_allow_pm tinyint(1) DEFAULT '1' NOT NULL, - user_allow_viewonline tinyint(1) DEFAULT '1' NOT NULL, + user_allowsmile tinyint(1), + user_allowavatar tinyint(1) DEFAULT '1' NOT NULL, + user_allow_pm tinyint(1) DEFAULT '1' NOT NULL, + user_allow_viewonline tinyint(1) DEFAULT '1' NOT NULL, user_notify tinyint(1) DEFAULT '1' NOT NULL, - user_notify_pm tinyint(1) DEFAULT '1' NOT NULL, + user_notify_pm tinyint(1) DEFAULT '1' NOT NULL, user_regdate int(11) DEFAULT '0' NOT NULL, user_rank int(11) DEFAULT '0', user_avatar varchar(100), @@ -514,6 +514,52 @@ CREATE TABLE phpbb_users ( # -------------------------------------------------------- # +# Table structure for table 'phpbb_vote_desc' +# +DROP TABLE IF EXISTS phpbb_vote_desc; +CREATE TABLE phpbb_vote_desc ( + vote_id int(11) NOT NULL auto_increment, + topic_id int(11) 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' +# +DROP TABLE IF EXISTS phpbb_vote_results; +CREATE TABLE phpbb_vote_results ( + vote_id int(11) NOT NULL DEFAULT '0', + vote_option_id int(11) 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' +# +DROP TABLE IF EXISTS phpbb_vote_voters; +CREATE TABLE phpbb_vote_voters ( + vote_id int(11) NOT NULL DEFAULT '0', + vote_user_id int(11) NOT NULL DEFAULT '0', + vote_user_ip char(8) 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_words' # DROP TABLE IF EXISTS phpbb_words; @@ -522,4 +568,4 @@ CREATE TABLE phpbb_words ( word varchar(100) NOT NULL, replacement varchar(100) NOT NULL, PRIMARY KEY (word_id) -); +);
\ No newline at end of file |