Menu
▾
▴
[Phpbb-checkins] CVS: phpBB2/db/schemas mysql_basic.sql,1.20,1.21 mysql_schema.sql,1.25,1.26
|
From: Paul S. O. <ps...@us...> - 2002-07-14 14:40:20
|
Update of /cvsroot/phpbb/phpBB2/db/schemas
In directory usw-pr-cvs1:/tmp/cvs-serv13716/db/schemas
Modified Files:
mysql_basic.sql mysql_schema.sql
Log Message:
Latest schema
Index: mysql_basic.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mysql_basic.sql,v
retrieving revision 1.20
retrieving revision 1.21
diff -C2 -r1.20 -r1.21
*** mysql_basic.sql 21 Jun 2002 22:40:29 -0000 1.20
--- mysql_basic.sql 14 Jul 2002 14:40:17 -0000 1.21
***************
*** 7,14 ****
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');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_name','phpbb2mysql');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_path','/');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_domain','');
--- 7,14 ----
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','');
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');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_name','phpbb22');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_path','/');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_domain','');
***************
*** 50,54 ****
INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_width','80');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_height','80');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_path','images/avatars');
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');
--- 50,54 ----
INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_width','80');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_height','80');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_path','images/avatars/upload');
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');
***************
*** 73,121 ****
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');
--- 73,141 ----
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 ('session_gc', '3600');
+ INSERT INTO phpbb_config (config_name, config_value) VALUES ('session_last_gc', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '2.1.0 [20020430]');
# -- auth options
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('forum', 'list');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('forum', 'read');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('forum', 'post');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('forum', 'reply');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('forum', 'edit');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('forum', 'delete');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('forum', 'poll');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('forum', 'vote');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('forum', 'announce');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('forum', 'sticky');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('forum', 'attach');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('forum', 'download');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('forum', 'html');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('forum', 'bbcode');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('forum', 'smilies');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('forum', 'img');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('forum', 'flash');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('forum', 'sigs');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('forum', 'search');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('forum', 'email');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('forum', 'rate');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('forum', 'print');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('forum', 'ignoreflood');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('forum', 'ignorequeue');
!
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('mod', 'edit');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('mod', 'delete');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('mod', 'move');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('mod', 'lock');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('mod', 'split');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('mod', 'merge');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('mod', 'approve');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('mod', 'unrate');
! INSERT INTO phpbb_auth_options auth_type, (auth_option) VALUES ('mod', 'auth');
!
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('admin', 'general');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('admin', 'user');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('admin', 'group');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('admin', 'forum');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('admin', 'post');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('admin', 'ban');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('admin', 'auth');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('admin', 'email');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('admin', 'styles');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('admin', 'backup');
! INSERT INTO phpbb_auth_options (auth_type, auth_option) VALUES ('admin', 'clearlogs');
!
!
! # -- phpbb_styles
! INSERT INTO phpbb_styles (style_id, template_id, theme_id, imageset_id, style_name, style_default) VALUES (1, 1, 1, 1, 'subSilver', 1);
!
! # -- phpbb_styles_imageset
! INSERT INTO phpbb_styles_imageset (imageset_id, imageset_name, imageset_path, post_new, post_locked, post_pm, reply_new, reply_pm, reply_locked, icon_quote, icon_edit, icon_search, icon_profile, icon_pm, icon_email, icon_www, icon_icq, icon_aim, icon_yim, icon_msnm, icon_no_edit, icon_no_email, icon_no_www, icon_no_icq, icon_no_aim, icon_no_yim, icon_no_msnm, icon_delete, icon_ip, goto_post, goto_post_new, goto_post_latest, goto_post_newest, forum, forum_new, forum_locked, folder, folder_new, folder_hot, folder_hot_new, folder_locked, folder_locked_new, folder_sticky, folder_sticky_new, folder_announce, folder_announce_new, topic_watch, topic_unwatch, poll_left, poll_center, poll_right, rating) VALUES (1, 'subSilver © phpBB Group', 'subSilver', '"imagesets/subSilver/{LANG}/post.gif" width="82" height="25" border="0"', '"imagesets/subSilver/{LANG}/reply-locked.gif" width="82" height="25" border="0"', '"imagesets/subSilver/{LANG}/post.gif" width="82" height="25" border="0"', '"imagesets/subSilver/{LANG}/reply.gif" width="88" height="27" border="0"', '"imagesets/subSilver/{LANG}/reply.gif" width="88" height="27" border="0"', '"imagesets/subSilver/{LANG}/reply-locked.gif" width="82" height="25" border="0"', '"imagesets/subSilver/{LANG}/icon_quote.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_edit.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_search.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_profile.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_pm.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_email.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_www.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_icq_add.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_aim.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_yim.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_msnm.gif" width="59" height="18" border="0"', '', '', '', '', '', '', '', '"imagesets/subSilver/icon_delete.gif" width="16" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_ip.gif" width="16" height="18" border="0"', '"imagesets/subSilver/icon_minipost.gif" width="12" height="9" border="0"', '"imagesets/subSilver/icon_minipost_new.gif" width="12" height="9" border="0"', '"imagesets/subSilver/icon_latest_reply.gif" width="18" height="9" border="0"', '"imagesets/subSilver/icon_newest_reply.gif" width="18" height="9" border="0"', '"imagesets/subSilver/folder_big.gif" width="46" height="25" border="0"', '"imagesets/subSilver/folder_new_big.gif" width="46" height="25" border="0"', '"imagesets/subSilver/folder_locked_big.gif" width="46" height="25" border="0"', '"imagesets/subSilver/folder.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_new.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_hot.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_new_hot.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_lock.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_lock_new.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_sticky.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_sticky_new.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_announce.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_announce_new.gif" width="19" height="18" border="0"', '', '', '"imagesets/subSilver/voting_lcap.gif" width="4" height="12" border="0"', '"imagesets/subSilver/voting_rcap.gif" height="12" border="0"', '"imagesets/subSilver/voting_bar.gif" width="4" height="12" border="0"', '"imagesets/subSilver/ratings/{RATE}.gif" width="45" height="17" border="0"');
!
! # -- phpbb_styles_template
! INSERT INTO phpbb_styles_template (template_id, template_name, template_path, poll_length, pm_box_length, compile_crc) VALUES (1, 'subSilver © phpBB Group', 'subSilver', 205, 175, '');
!
! # -- phpbb_styles_theme
! INSERT INTO phpbb_styles_theme (theme_id, css_data, css_external) VALUES (1, 'th { background-image: url(templates/subSilver/images/cellpic3.gif) }\r\ntd.cat { background-image: url(templates/subSilver/images/cellpic1.gif) }\r\ntd.rowpic { background-image: url(templates/subSilver/images/cellpic2.jpg); background-repeat: repeat-y }\r\ntd.icqback { background-image: url(templates/subSilver/images/icon_icq_add.gif); background-repeat: no-repeat }\r\ntd.catHead,td.catSides,td.catLeft,td.catRight,td.catBottom { background-image: url(templates/subSilver/images/cellpic1.gif) }\r\nTH.thTop { background-image: url(templates/subSilver/images/cellpic3.gif) }', 'subSilver/subSilver.css');
***************
*** 125,129 ****
# -- 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_pollcreate, auth_vote, auth_attachments) VALUES (1, 'Test Forum 1', 'This is just a test forum.', 1, 10, 1, 1, 1, 0, 0, 0, 0, 1, 1, 3, 1, 1, 1, 3);
--- 145,149 ----
# -- 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.', 1, 10, 1, 1, 1);
***************
*** 141,144 ****
--- 161,165 ----
# -- Groups
INSERT INTO phpbb_groups (group_id, group_name, group_type) VALUES (1, 'REGISTERED', 0);
+ INSERT INTO phpbb_groups (group_id, group_name, group_type) VALUES (1, 'ADMINISTRATOR', 0);
***************
*** 152,208 ****
# -- 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, 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!');
# -- Topic icons
! INSERT INTO phpbb_icons (icons_id, icons_url, icons_width, icons_height) VALUES (0, '', 0, 0);
# -- Smilies
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 1, ':D', 'icon_biggrin.gif', 'Very Happy');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 2, ':-D', 'icon_biggrin.gif', 'Very Happy');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 3, ':grin:', 'icon_biggrin.gif', 'Very Happy');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 4, ':)', 'icon_smile.gif', 'Smile');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 5, ':-)', 'icon_smile.gif', 'Smile');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 6, ':smile:', 'icon_smile.gif', 'Smile');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 7, ':(', 'icon_sad.gif', 'Sad');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 8, ':-(', 'icon_sad.gif', 'Sad');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 9, ':sad:', 'icon_sad.gif', 'Sad');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 10, ':o', 'icon_surprised.gif', 'Surprised');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 11, ':-o', 'icon_surprised.gif', 'Surprised');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 12, ':eek:', 'icon_surprised.gif', 'Surprised');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 13, '8O', 'icon_eek.gif', 'Shocked');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 14, '8-O', 'icon_eek.gif', 'Shocked');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 15, ':shock:', 'icon_eek.gif', 'Shocked');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 16, ':?', 'icon_confused.gif', 'Confused');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 17, ':-?', 'icon_confused.gif', 'Confused');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 18, ':???:', 'icon_confused.gif', 'Confused');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 19, '8)', 'icon_cool.gif', 'Cool');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 20, '8-)', 'icon_cool.gif', 'Cool');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 21, ':cool:', 'icon_cool.gif', 'Cool');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 22, ':lol:', 'icon_lol.gif', 'Laughing');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 23, ':x', 'icon_mad.gif', 'Mad');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 24, ':-x', 'icon_mad.gif', 'Mad');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 25, ':mad:', 'icon_mad.gif', 'Mad');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 26, ':P', 'icon_razz.gif', 'Razz');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 27, ':-P', 'icon_razz.gif', 'Razz');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 28, ':razz:', 'icon_razz.gif', 'Razz');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 29, ':oops:', 'icon_redface.gif', 'Embarassed');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 30, ':cry:', 'icon_cry.gif', 'Crying or Very sad');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 31, ':evil:', 'icon_evil.gif', 'Evil or Very Mad');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 32, ':twisted:', 'icon_twisted.gif', 'Twisted Evil');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 33, ':roll:', 'icon_rolleyes.gif', 'Rolling Eyes');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 34, ':wink:', 'icon_wink.gif', 'Wink');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 35, ';)', 'icon_wink.gif', 'Wink');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 36, ';-)', 'icon_wink.gif', 'Wink');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 37, ':!:', 'icon_exclaim.gif', 'Exclamation');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 38, ':?:', 'icon_question.gif', 'Question');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 39, ':idea:', 'icon_idea.gif', 'Idea');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 40, ':arrow:', 'icon_arrow.gif', 'Arrow');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 41, ':|', 'icon_neutral.gif', 'Neutral');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 42, ':-|', 'icon_neutral.gif', 'Neutral');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 43, ':neutral:', 'icon_neutral.gif', 'Neutral');
! INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 44, ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green');
--- 173,229 ----
# -- 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, NULL, '127.0.0.1');
! INSERT INTO phpbb_posts_text (post_id, post_subject, post_text) VALUES (1, NULL, 'This is an example post in your phpBB 2.2 installation. You may delete this post, this topic and even this forum if you like since everything seems to be working!');
# -- Topic icons
! INSERT INTO phpbb_icons (icons_id, icons_url, icons_width, icons_height) VALUES (1, '', 0, 0);
# -- Smilies
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':D', 'icon_biggrin.gif', 'Very Happy');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':-D', 'icon_biggrin.gif', 'Very Happy');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':grin:', 'icon_biggrin.gif', 'Very Happy');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':)', 'icon_smile.gif', 'Smile');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':-)', 'icon_smile.gif', 'Smile');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':smile:', 'icon_smile.gif', 'Smile');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':(', 'icon_sad.gif', 'Sad');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':-(', 'icon_sad.gif', 'Sad');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':sad:', 'icon_sad.gif', 'Sad');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':o', 'icon_surprised.gif', 'Surprised');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':-o', 'icon_surprised.gif', 'Surprised');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':eek:', 'icon_surprised.gif', 'Surprised');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( '8O', 'icon_eek.gif', 'Shocked');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( '8-O', 'icon_eek.gif', 'Shocked');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':shock:', 'icon_eek.gif', 'Shocked');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':?', 'icon_confused.gif', 'Confused');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':-?', 'icon_confused.gif', 'Confused');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':???:', 'icon_confused.gif', 'Confused');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( '8)', 'icon_cool.gif', 'Cool');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( '8-)', 'icon_cool.gif', 'Cool');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':cool:', 'icon_cool.gif', 'Cool');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':lol:', 'icon_lol.gif', 'Laughing');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':x', 'icon_mad.gif', 'Mad');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':-x', 'icon_mad.gif', 'Mad');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':mad:', 'icon_mad.gif', 'Mad');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':P', 'icon_razz.gif', 'Razz');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':-P', 'icon_razz.gif', 'Razz');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':razz:', 'icon_razz.gif', 'Razz');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':oops:', 'icon_redface.gif', 'Embarassed');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':cry:', 'icon_cry.gif', 'Crying or Very sad');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':evil:', 'icon_evil.gif', 'Evil or Very Mad');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':twisted:', 'icon_twisted.gif', 'Twisted Evil');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':roll:', 'icon_rolleyes.gif', 'Rolling Eyes');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':wink:', 'icon_wink.gif', 'Wink');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ';)', 'icon_wink.gif', 'Wink');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ';-)', 'icon_wink.gif', 'Wink');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':!:', 'icon_exclaim.gif', 'Exclamation');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':?:', 'icon_question.gif', 'Question');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':idea:', 'icon_idea.gif', 'Idea');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':arrow:', 'icon_arrow.gif', 'Arrow');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':|', 'icon_neutral.gif', 'Neutral');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':-|', 'icon_neutral.gif', 'Neutral');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':neutral:', 'icon_neutral.gif', 'Neutral');
! INSERT INTO phpbb_smilies (code, smile_url, emoticon) VALUES ( ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green');
Index: mysql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mysql_schema.sql,v
retrieving revision 1.25
retrieving revision 1.26
diff -C2 -r1.25 -r1.26
*** mysql_schema.sql 27 Jun 2002 19:55:26 -0000 1.25
--- mysql_schema.sql 14 Jul 2002 14:40:17 -0000 1.26
***************
*** 7,13 ****
# --------------------------------------------------------
#
# Table structure for table `phpbb_auth_groups`
#
- DROP TABLE IF EXISTS phpbb_auth_groups;
CREATE TABLE phpbb_auth_groups (
group_id mediumint(8) unsigned NOT NULL default '0',
--- 7,28 ----
# --------------------------------------------------------
#
+ # Table structure for table 'phpbb_attach_desc'
+ #
+ CREATE TABLE phpbb_attach_desc (
+ attach_id mediumint(8) UNSIGNED NOT NULL auto_increment,
+ attach_filename varchar(255) NOT NULL,
+ download_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
+ filename varchar(255) NOT NULL,
+ comment varchar(60),
+ mimetype varchar(60),
+ filesize int(20) NOT NULL,
+ filetime int(11) DEFAULT '0' NOT NULL,
+ PRIMARY KEY (attach_id)
+ );
+
+ # --------------------------------------------------------
+ #
# Table structure for table `phpbb_auth_groups`
#
CREATE TABLE phpbb_auth_groups (
group_id mediumint(8) unsigned NOT NULL default '0',
***************
*** 59,64 ****
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)
--- 74,81 ----
ban_id mediumint(8) UNSIGNED NOT NULL auto_increment,
ban_userid mediumint(8) NOT NULL,
! ban_ip varchar(40) NOT NULL,
! ban_email varchar(50),
! ban_start int(11),
! ban_length int(11),
PRIMARY KEY (ban_id),
KEY ban_ip_user_id (ban_ip, ban_userid)
***************
*** 72,76 ****
CREATE TABLE phpbb_categories (
cat_id mediumint(8) UNSIGNED NOT NULL auto_increment,
! cat_title char(60),
cat_order mediumint(8) UNSIGNED NOT NULL,
PRIMARY KEY (cat_id),
--- 89,93 ----
CREATE TABLE phpbb_categories (
cat_id mediumint(8) UNSIGNED NOT NULL auto_increment,
! cat_title varchar(60),
cat_order mediumint(8) UNSIGNED NOT NULL,
PRIMARY KEY (cat_id),
***************
*** 92,100 ****
# --------------------------------------------------------
#
# Table structure for table 'phpbb_disallow' <- combine with banlist
#
CREATE TABLE phpbb_disallow (
disallow_id mediumint(8) UNSIGNED NOT NULL auto_increment,
! disallow_username char(30),
PRIMARY KEY (disallow_id)
);
--- 109,127 ----
# --------------------------------------------------------
#
+ # Table structure for table 'phpbb_config_defaults'
+ #
+ CREATE TABLE phpbb_config_defaults (
+ config_name varchar(255) NOT NULL,
+ config_value varchar(255) NOT NULL,
+ PRIMARY KEY (config_name)
+ );
+
+ # --------------------------------------------------------
+ #
# Table structure for table 'phpbb_disallow' <- combine with banlist
#
CREATE TABLE phpbb_disallow (
disallow_id mediumint(8) UNSIGNED NOT NULL auto_increment,
! disallow_username varchar(30),
PRIMARY KEY (disallow_id)
);
***************
*** 179,183 ****
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,
--- 206,210 ----
CREATE TABLE phpbb_icons (
icons_id tinyint(4) UNSIGNED NOT NULL auto_increment,
! icons_url varchar(50),
icons_width tinyint(4) UNSIGNED NOT NULL,
icons_height tinyint(4) UNSIGNED NOT NULL,
***************
*** 196,200 ****
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),
--- 223,228 ----
log_ip varchar(40) NOT NULL,
log_time int(11) NOT NULL,
! log_operation text,
! log_data text,
PRIMARY KEY (log_id),
KEY forum_id (forum_id),
***************
*** 205,208 ****
--- 233,252 ----
# --------------------------------------------------------
#
+ # Table structure for table 'phpbb_log_admin'
+ #
+ CREATE TABLE phpbb_log_admin (
+ log_id mediumint(5) UNSIGNED NOT NULL DEFAULT '0',
+ user_id mediumint(8) NOT NULL DEFAULT '0',
+ log_ip varchar(40) NOT NULL,
+ log_time int(11) NOT NULL,
+ log_operation text,
+ log_data text,
+ PRIMARY KEY (log_id),
+ KEY user_id (user_id)
+ );
+
+
+ # --------------------------------------------------------
+ #
# Table structure for table 'phpbb_vote_results'
#
***************
*** 224,228 ****
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),
--- 268,272 ----
poll_option_id tinyint(4) UNSIGNED NOT NULL DEFAULT '0',
vote_user_id mediumint(8) NOT NULL DEFAULT '0',
! vote_user_ip varchar(40) NOT NULL,
KEY vote_id (vote_id),
KEY vote_user_id (vote_user_id),
***************
*** 240,250 ****
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,
--- 284,295 ----
forum_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
poster_id mediumint(8) DEFAULT '0' NOT NULL,
! attach_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
! poster_ip varchar(40) NOT NULL,
post_time int(11) DEFAULT '0' NOT NULL,
post_approved tinyint(1) DEFAULT '1' 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,
enable_magic_url tinyint(1) DEFAULT '1' NOT NULL,
enable_sig tinyint(1) DEFAULT '1' NOT NULL,
***************
*** 265,270 ****
CREATE TABLE phpbb_posts_text (
post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
! bbcode_uid char(10) NOT NULL,
! post_subject char(60),
post_text text,
PRIMARY KEY (post_id)
--- 310,315 ----
CREATE TABLE phpbb_posts_text (
post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
! bbcode_uid varchar(10) NOT NULL,
! post_subject varchar(60),
post_text text,
PRIMARY KEY (post_id)
***************
*** 278,287 ****
CREATE TABLE phpbb_privmsgs (
privmsgs_id mediumint(8) UNSIGNED NOT NULL auto_increment,
privmsgs_type tinyint(4) DEFAULT '0' NOT NULL,
! privmsgs_subject char(60) DEFAULT '0' NOT NULL,
privmsgs_from_userid mediumint(8) DEFAULT '0' NOT NULL,
privmsgs_to_userid mediumint(8) DEFAULT '0' NOT NULL,
privmsgs_date int(11) DEFAULT '0' NOT NULL,
! privmsgs_ip char(40) NOT NULL,
privmsgs_enable_bbcode tinyint(1) DEFAULT '1' NOT NULL,
privmsgs_enable_html tinyint(1) DEFAULT '0' NOT NULL,
--- 323,333 ----
CREATE TABLE phpbb_privmsgs (
privmsgs_id mediumint(8) UNSIGNED NOT NULL auto_increment,
+ attach_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
privmsgs_type tinyint(4) DEFAULT '0' NOT NULL,
! privmsgs_subject varchar(60) DEFAULT '0' NOT NULL,
privmsgs_from_userid mediumint(8) DEFAULT '0' NOT NULL,
privmsgs_to_userid mediumint(8) DEFAULT '0' NOT NULL,
privmsgs_date int(11) DEFAULT '0' NOT NULL,
! privmsgs_ip varchar(40) NOT NULL,
privmsgs_enable_bbcode tinyint(1) DEFAULT '1' NOT NULL,
privmsgs_enable_html tinyint(1) DEFAULT '0' NOT NULL,
***************
*** 300,304 ****
CREATE TABLE phpbb_privmsgs_text (
privmsgs_text_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
! privmsgs_bbcode_uid char(10) DEFAULT '0' NOT NULL,
privmsgs_text text,
PRIMARY KEY (privmsgs_text_id)
--- 346,350 ----
CREATE TABLE phpbb_privmsgs_text (
privmsgs_text_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
! privmsgs_bbcode_uid varchar(10) DEFAULT '0' NOT NULL,
privmsgs_text text,
PRIMARY KEY (privmsgs_text_id)
***************
*** 371,377 ****
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),
! KEY session_id_user_id (session_id, session_user_id)
);
--- 417,421 ----
session_browser varchar(100) DEFAULT '' NULL,
session_page varchar(50) DEFAULT '0' NOT NULL,
! PRIMARY KEY (session_id)
);
***************
*** 398,407 ****
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)
);
--- 442,453 ----
CREATE TABLE phpbb_styles (
style_id tinyint(4) UNSIGNED NOT NULL auto_increment,
+ template_id char(50) NOT NULL,
theme_id tinyint(4) UNSIGNED NOT NULL,
! imageset_id tinyint(4) UNSIGNED NOT NULL,
style_name char(30) NOT NULL,
PRIMARY KEY (style_id),
! KEY (template_id),
! KEY (theme_id),
! KEY (imageset_id)
);
***************
*** 409,419 ****
# --------------------------------------------------------
#
! # 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)
);
--- 455,481 ----
# --------------------------------------------------------
#
! # Table structure for table 'phpbb_styles_template'
! #
! CREATE TABLE phpbb_styles_template (
! template_id tinyint(4) UNSIGNED NOT NULL auto_increment,
! template_name varchar(30) NOT NULL,
! template_path varchar(50) NOT NULL,
! poll_length smallint(5) UNSIGNED NOT NULL,
! pm_box_length smallint(5) UNSIGNED NOT NULL,
! compile_crc text,
! PRIMARY KEY (template_id)
! );
!
!
! # --------------------------------------------------------
#
! # Table structure for table 'phpbb_styles_theme'
! #
! CREATE TABLE phpbb_styles_theme (
! theme_id tinyint(4) UNSIGNED NOT NULL auto_increment,
! theme_name varchar(60),
! css_external varchar(100),
! css_data text,
! PRIMARY KEY (theme_id)
);
***************
*** 421,424 ****
--- 483,546 ----
# --------------------------------------------------------
#
+ # Table structure for table 'phpbb_styles_imageset'
+ #
+ CREATE TABLE phpbb_styles_imageset (
+ imageset_id tinyint(4) UNSIGNED NOT NULL auto_increment,
+ imageset_name varchar(100),
+ imageset_path varchar(30),
+ post_new varchar(200),
+ post_locked varchar(200),
+ post_pm varchar(200),
+ reply_new varchar(200),
+ reply_pm varchar(200),
+ reply_locked varchar(200),
+ icon_profile varchar(200),
+ icon_pm varchar(200),
+ icon_delete varchar(200),
+ icon_ip varchar(200),
+ icon_quote varchar(200),
+ icon_search varchar(200),
+ icon_edit varchar(200),
+ icon_email varchar(200),
+ icon_www varchar(200),
+ icon_icq varchar(200),
+ icon_aim varchar(200),
+ icon_yim varchar(200),
+ icon_msnm varchar(200),
+ icon_no_email varchar(200) DEFAULT '',
+ icon_no_www varchar(200) DEFAULT '',
+ icon_no_icq varchar(200) DEFAULT '',
+ icon_no_aim varchar(200) DEFAULT '',
+ icon_no_yim varchar(200) DEFAULT '',
+ icon_no_msnm varchar(200) DEFAULT '',
+ goto_post varchar(200),
+ goto_post_new varchar(200),
+ goto_post_latest varchar(200),
+ goto_post_newest varchar(200),
+ forum varchar(200),
+ forum_new varchar(200),
+ forum_locked varchar(200),
+ folder varchar(200),
+ folder_new varchar(200),
+ folder_hot varchar(200),
+ folder_hot_new varchar(200),
+ folder_locked varchar(200),
+ folder_locked_new varchar(200),
+ folder_sticky varchar(200),
+ folder_sticky_new varchar(200),
+ folder_announce varchar(200),
+ folder_announce_new varchar(200),
+ topic_watch varchar(200),
+ topic_unwatch varchar(200),
+ poll_left varchar(200),
+ poll_center varchar(200),
+ poll_right varchar(200),
+ rating varchar(200),
+ PRIMARY KEY (imageset_id)
+ );
+
+
+ # --------------------------------------------------------
+ #
# Table structure for table 'phpbb_topics'
#
***************
*** 429,433 ****
topic_poster mediumint(8) DEFAULT '0' NOT NULL,
topic_time int(11) DEFAULT '0' NOT NULL,
! topic_icon tinyint(4) UNSIGNED DEFAULT '0' NOT NULL,
topic_views mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
topic_replies mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
--- 551,556 ----
topic_poster mediumint(8) DEFAULT '0' NOT NULL,
topic_time int(11) DEFAULT '0' NOT NULL,
! topic_icon tinyint(4) UNSIGNED DEFAULT '1' NOT NULL,
! topic_rating tinyint(4) DEFAULT '0' NOT NULL,
topic_views mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
topic_replies mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
***************
*** 445,449 ****
KEY forum_id (forum_id),
KEY topic_moved_id (topic_moved_id),
- KEY topic_status (topic_status),
KEY topic_type (topic_type)
);
--- 568,571 ----
***************
*** 452,455 ****
--- 574,590 ----
# --------------------------------------------------------
#
+ # Table structure for table 'phpbb_topics_rating'
+ #
+ CREATE TABLE phpbb_topics_rating (
+ topic_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
+ user_id tinyint(4) UNSIGNED NOT NULL DEFAULT '0',
+ rating tinyint(4) NOT NULL,
+ KEY topic_id (topic_id),
+ KEY user_id (user_id)
+ );
+
+
+ # --------------------------------------------------------
+ #
# Table structure for table 'phpbb_topics_watch'
#
***************
*** 483,509 ****
CREATE TABLE phpbb_users (
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,
user_lastvisit int(11) DEFAULT '0' NOT NULL,
! user_regdate int(11) DEFAULT '0' NOT NULL,
! user_level tinyint(4) DEFAULT '0',
! user_colourise varchar(6) DEFAULT '' NOT NULL,
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',
--- 618,654 ----
CREATE TABLE phpbb_users (
user_id mediumint(8) NOT NULL auto_increment,
+
user_active tinyint(1) DEFAULT '1',
+ user_ip varchar(40),
+ user_regdate int(11) DEFAULT '0' NOT NULL,
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,
user_lastvisit int(11) DEFAULT '0' NOT NULL,
!
! user_colour varchar(6) DEFAULT '' NOT NULL,
user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
user_lang varchar(50),
user_timezone decimal(4,2) DEFAULT '0' NOT NULL,
+ user_dst tinyint(1) 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_sortby_type varchar(1) DEFAULT 'l' NOT NULL,
+ user_sortby_dir varchar(1) DEFAULT 'd' NOT NULL,
+ user_show_days tinyint(1) DEFAULT '0' NOT NULL,
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',
***************
*** 517,520 ****
--- 662,666 ----
user_notify_pm tinyint(1) DEFAULT '1' NOT NULL,
user_popup_pm tinyint(1) DEFAULT '0' NOT NULL,
+
user_rank int(11) DEFAULT '0',
user_avatar char(100),
***************
*** 522,527 ****
--- 668,675 ----
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),
***************
*** 530,541 ****
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)
);
--- 678,689 ----
user_msnm varchar(255),
user_website varchar(100),
user_occ varchar(100),
user_interests varchar(255),
! user_actkey varchar(32),
! user_newpasswd varchar(32),
!
! PRIMARY KEY (user_id)
);
|
