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 | |
| 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')
| -rw-r--r-- | phpBB/db/mysql_basic.sql | 25 | ||||
| -rw-r--r-- | phpBB/db/mysql_schema.sql | 174 |
2 files changed, 122 insertions, 77 deletions
diff --git a/phpBB/db/mysql_basic.sql b/phpBB/db/mysql_basic.sql index 4fe9540df2..055fedc285 100644 --- a/phpBB/db/mysql_basic.sql +++ b/phpBB/db/mysql_basic.sql @@ -4,13 +4,13 @@ # $Id$ # -- Config -INSERT INTO phpbb_config (config_id, board_disable, sitename, cookie_name, cookie_path, cookie_domain, cookie_secure, session_length, allow_html, allow_bbcode, allow_smilies, allow_sig, allow_namechange, posts_per_page, hot_threshold, topics_per_page, flood_interval, allow_theme_create, override_themes, email_sig, email_from, default_theme, default_lang, default_dateformat, system_timezone, sys_template, avatar_filesize, avatar_path, allow_avatar_upload, avatar_max_width, avatar_max_height, allow_avatar_local, allow_avatar_remote) VALUES ( '1', '0', 'phpbb.com', 'phpbb2mysql', '/', '', '0', 600, '0', '1', '1', '1', '0', '10', '10', '25', '10', '0', '0', '', '', '2', 'english', 'd M Y H:i', '0', 'PSO', '6144', 'images/avatars', '0', '70', '70', '0', '0'); +INSERT INTO phpbb_config (config_id, board_disable, sitename, cookie_name, cookie_path, cookie_domain, cookie_secure, session_length, allow_html, allow_html_tags, allow_bbcode, allow_smilies, allow_sig, allow_namechange, allow_theme_create, allow_avatar_local, allow_avatar_remote, allow_avatar_upload, override_themes, posts_per_page, topics_per_page, hot_threshold, max_poll_options, email_sig, email_from, require_activation, flood_interval, avatar_filesize, avatar_max_width, avatar_max_height, avatar_path, smilies_path, default_theme, default_lang, default_dateformat, system_timezone, sys_template, prune_enable, gzip_compress, board_startdate, smtp_delivery, smtp_host) VALUES (1,0,'yourdomain.com','phpbb2mysql','/','','',900,'','b,i,u,pre',1,1,1,'','','',1,1,'',15,50,25,10,'Thanks, The Management','youraddress@yourdomain.com','',15,6144,80,80,'images/avatars','images/smiles',2,'english','D M d, Y g:i a',-8,'PSO',1,1,994190324,'',''); # -- Categories 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, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_announce, auth_sticky, auth_votecreate, auth_vote, auth_attachments) VALUES (1, 'Test Forum 1', 'This is just a test forum, nothing special here.', 1, 1, 1, 1, 1, 0, 0, 0, 0, 1, 1, 3, 3, 3, 3, 3); +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_pollcreate, auth_vote, auth_attachments) VALUES (1, 'Test Forum 1', 'This is just a test forum, nothing special here.', 1, 1, 1, 1, 1, 0, 0, 0, 0, 1, 1, 3, 1, 1, 1, 3); # -- Users 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_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, user_template) VALUES ( '-1', 'Anonymous', '0', '972086460', '', '', '', '', '', '', '', '', '', '0', '0', '', '', '', '', '', '', '', '0', '0', '1', '', '', '', '', '', '', '', '', '0', '0', ''); @@ -34,10 +34,10 @@ 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); # -- 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) VALUES (2, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1); +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_pollcreate, auth_vote, auth_mod) VALUES (2, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1); # -- Demo Topic -INSERT INTO phpbb_topics (topic_id, topic_title, topic_poster, topic_time, topic_views, topic_replies, forum_id, topic_status, topic_type, topic_last_post_id) VALUES (1, 'Demo Topic', 2, '972086460', 0, 0, 1, 0, 0, 1); +INSERT INTO phpbb_topics (topic_id, topic_title, topic_poster, topic_time, topic_views, topic_replies, forum_id, topic_status, topic_type, topic_vote, topic_last_post_id) VALUES (1, 'Demo Topic', 2, '972086460', 0, 0, 1, 0, 0, 0, 1); # -- Demo Post INSERT INTO phpbb_posts (post_id, topic_id, forum_id, poster_id, post_time, post_username, poster_ip) VALUES (1, 1, 1, 2, '972086460', '', '7F000001'); @@ -128,12 +128,11 @@ INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '26', 'dickweed', INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '27', 'dickwad', '*beep*'); INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '28', 'frig*', '*beep*'); INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '29', 'hore', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '30', 'fag*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '31', 'asswipe', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '32', 'asstool*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '33', '*cock*', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '34', 'b!tch', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '35', 'masturbation', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '36', 'dickhead', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '37', 'spunk', '*beep*'); -INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '38', '*crap*', '*beep*'); +INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '30', 'asswipe', '*beep*'); +INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '31', 'asstool*', '*beep*'); +INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '32', '*cock*', '*beep*'); +INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '33', 'b!tch', '*beep*'); +INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '34', 'masturbat*', '*beep*'); +INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '35', 'dickhead', '*beep*'); +INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '36', 'spunk', '*beep*'); +INSERT INTO phpbb_words (word_id, word, replacement) VALUES ( '37', '*crap*', '*beep*'); 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 |