diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-03-29 16:27:50 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-03-29 16:27:50 +0000 |
| commit | ea2f85d4582cafe6a61649531d6d2595b14b2a1b (patch) | |
| tree | c1b7dd728e8f23c806c257336b6a9b8923ea5c5b /phpBB/install | |
| parent | de6cbb063aeae3d75036a76b7c9b02d23fb7b2ae (diff) | |
| download | forums-ea2f85d4582cafe6a61649531d6d2595b14b2a1b.tar forums-ea2f85d4582cafe6a61649531d6d2595b14b2a1b.tar.gz forums-ea2f85d4582cafe6a61649531d6d2595b14b2a1b.tar.bz2 forums-ea2f85d4582cafe6a61649531d6d2595b14b2a1b.tar.xz forums-ea2f85d4582cafe6a61649531d6d2595b14b2a1b.zip | |
Imageset schema changes ... drop your old imageset table and replace with this + data
git-svn-id: file:///svn/phpbb/trunk@3744 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install')
| -rw-r--r-- | phpBB/install/schemas/mysql_basic.sql | 3 | ||||
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 81 |
2 files changed, 42 insertions, 42 deletions
diff --git a/phpBB/install/schemas/mysql_basic.sql b/phpBB/install/schemas/mysql_basic.sql index 5b6951de6c..a9908c69c5 100644 --- a/phpBB/install/schemas/mysql_basic.sql +++ b/phpBB/install/schemas/mysql_basic.sql @@ -169,6 +169,7 @@ INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_authmods', 1); INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_authadmins', 1); INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_authusers', 1); INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_authgroups', 1); +INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_authdeps', 1); INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_backup', 1); INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_restore', 1); INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('a_search', 1); @@ -193,7 +194,7 @@ INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('u_search', 1); INSERT INTO phpbb_styles (style_id, template_id, theme_id, imageset_id, style_name) VALUES (1, 1, 1, 1, 'subSilver'); # -- 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_profile, icon_pm, icon_delete, icon_ip, icon_quote, icon_report, icon_search, icon_edit, icon_email, icon_www, icon_icq, icon_aim, icon_yim, icon_msnm, icon_no_email, icon_no_www, icon_no_icq, icon_no_aim, icon_no_yim, icon_no_msnm, icon_online, icon_offline, item_unapproved, item_reported, goto_post, goto_post_new, goto_post_latest, goto_post_newest, forum, forum_new, forum_locked, sub_forum, sub_forum_new, 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, folder_posted, folder_new_posted, folder_locked_posted, folder_locked_new_posted, folder_sticky_posted, folder_sticky_new_posted, folder_announce_posted, folder_announce_new_posted, folder_hot_posted, folder_hot_new_posted) 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="25" border="0"', '"imagesets/subSilver/{LANG}/reply.gif" width="88" height="25" border="0"', '"imagesets/subSilver/{LANG}/reply-locked.gif" width="82" height="25" 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/icon_delete.gif" width="16" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_ip.gif" width="16" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_quote.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_report.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_search.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_edit.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/{LANG}/online.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/offline.gif" width="59" height="18" border="0"', '', '"imagesets/subSilver/{LANG}/report.gif" width="59" 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/subfolder_big.gif" width="46" height="25" border="0"', '"imagesets/subSilver/subfolder_new_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_bar.gif" height="12" border="0"', '"imagesets/subSilver/voting_rcap.gif" width="4" height="12" border="0"', '"imagesets/subSilver/ratings/{RATE}.gif" width="45" height="17" border="0"', '"imagesets/subSilver/folder_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_new_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_lock_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_lock_new_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_sticky_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_sticky_new_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_announce_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_announce_new_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_hot_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_new_hot_posted.gif" width="19" height="18" border="0"'); +INSERT INTO phpbb_styles_imageset (imageset_id, imageset_name, imageset_path, btn_post, btn_post_pm, btn_reply, btn_reply_pm, btn_locked, btn_profile, btn_pm, btn_delete, btn_ip, btn_quote, btn_search, btn_edit, btn_report, btn_email, btn_www, btn_icq, btn_aim, btn_yim, btn_msnm, btn_no_email, btn_no_www, btn_no_icq, btn_no_aim, btn_no_yim, btn_no_msnm, btn_online, btn_offline, btn_topic_watch, btn_topic_unwatch, icon_unapproved, icon_reported, icon_attach, icon_post, icon_post_new, icon_post_latest, icon_post_newest, forum, forum_new, forum_locked, sub_forum, sub_forum_new, folder, folder_posted, folder_new, folder_new_posted, folder_hot, folder_hot_posted, folder_hot_new, folder_hot_new_posted, folder_locked, folder_locked_posted, folder_locked_new, folder_locked_new_posted, folder_sticky, folder_sticky_posted, folder_sticky_new, folder_sticky_new_posted, folder_announce, folder_announce_posted, folder_announce_new, folder_announce_new_posted, poll_left, poll_center, poll_right) VALUES (1, 'subSilver © phpBB Group', 'subSilver', '"imagesets/subSilver/{LANG}/btn_post.gif" width="82" height="25" border="0"', '"imagesets/subSilver/{LANG}/btn_post_pm.gif" width="82" height="25" border="0"', '"imagesets/subSilver/{LANG}/btn_reply.gif" width="88" height="25" border="0"', '"imagesets/subSilver/{LANG}/reply.gif" width="88" height="25" border="0"', '"imagesets/subSilver/{LANG}/btn_locked.gif" width="82" height="25" border="0"', '"imagesets/subSilver/{LANG}/btn_profile.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_pm.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_delete.gif" width="16" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_ip.gif" width="16" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_quote.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_search.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_edit.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_report.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_email.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_www.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_icq.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_aim.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_yim.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_msnm.gif" width="59" height="18" border="0"', '', '', '', '', '', '', '"imagesets/subSilver/{LANG}/btn_online.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_offline.gif" width="59" height="18" border="0"', NULL, NULL, '"imagesets/subSilver/icon_unapproved.gif" width="19" height="18" border="0"', '"imagesets/subSilver/icon_reported.gif" width="19" height="18" border="0"', '"imagesets/subSilver/icon_minipost.gif" width="14" 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/subfolder_big.gif" width="46" height="25" border="0"', '"imagesets/subSilver/subfolder_new_big.gif" width="46" height="25" border="0"', '"imagesets/subSilver/folder.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_new.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_new_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_hot.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_hot_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_new_hot.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_new_hot_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_lock.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_lock_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_lock_new.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_lock_new_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_sticky.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_sticky_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_sticky_new.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_sticky_new_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_announce.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_announce_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_announce_new.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_announce_new_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/voting_lcap.gif" width="4" height="12" border="0"', '"imagesets/subSilver/voting_bar.gif" height="12" border="0"', '"imagesets/subSilver/voting_rcap.gif" width="4" height="12" 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, ''); diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index bedf2ad060..63409ccfcf 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -622,9 +622,8 @@ 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, + poll_length smallint(5) UNSIGNED NOT NULL, + pm_box_length smallint(5) UNSIGNED NOT NULL, PRIMARY KEY (template_id) ); @@ -650,40 +649,42 @@ CREATE TABLE phpbb_styles_imageset ( imageset_id tinyint(4) unsigned NOT NULL auto_increment, imageset_name varchar(100) default NULL, imageset_path varchar(30) default NULL, - post_new varchar(200) default NULL, - post_locked varchar(200) default NULL, - post_pm varchar(200) default NULL, - reply_new varchar(200) default NULL, - reply_pm varchar(200) default NULL, - reply_locked varchar(200) default NULL, - icon_profile varchar(200) default NULL, - icon_pm varchar(200) default NULL, - icon_delete varchar(200) default NULL, - icon_ip varchar(200) default NULL, - icon_quote varchar(200) default NULL, - icon_search varchar(200) default NULL, - icon_edit varchar(200) default NULL, - icon_report varchar(200) default NULL, - icon_email varchar(200) default NULL, - icon_www varchar(200) default NULL, - icon_icq varchar(200) default NULL, - icon_aim varchar(200) default NULL, - icon_yim varchar(200) default NULL, - icon_msnm varchar(200) default NULL, - 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 '', - icon_online varchar(200) default '', - icon_offline varchar(200) default '', - item_unapproved varchar(200) NOT NULL default '', - item_reported varchar(200) NOT NULL default '', - goto_post varchar(200) default NULL, - goto_post_new varchar(200) default NULL, - goto_post_latest varchar(200) default NULL, - goto_post_newest varchar(200) default NULL, + btn_post varchar(200) default NULL, + btn_post_pm varchar(200) default NULL, + btn_reply varchar(200) default NULL, + btn_reply_pm varchar(200) default NULL, + btn_locked varchar(200) default NULL, + btn_profile varchar(200) default NULL, + btn_pm varchar(200) default NULL, + btn_delete varchar(200) default NULL, + btn_ip varchar(200) default NULL, + btn_quote varchar(200) default NULL, + btn_search varchar(200) default NULL, + btn_edit varchar(200) default NULL, + btn_report varchar(200) default NULL, + btn_email varchar(200) default NULL, + btn_www varchar(200) default NULL, + btn_icq varchar(200) default NULL, + btn_aim varchar(200) default NULL, + btn_yim varchar(200) default NULL, + btn_msnm varchar(200) default NULL, + btn_no_email varchar(200) default '', + btn_no_www varchar(200) default '', + btn_no_icq varchar(200) default '', + btn_no_aim varchar(200) default '', + btn_no_yim varchar(200) default '', + btn_no_msnm varchar(200) default '', + btn_online varchar(200) default '', + btn_offline varchar(200) default '', + btn_topic_watch varchar(200) default NULL, + btn_topic_unwatch varchar(200) default NULL, + icon_unapproved varchar(200) NOT NULL default '', + icon_reported varchar(200) NOT NULL default '', + icon_attach varchar(200) default '', + icon_post varchar(200) default NULL, + icon_post_new varchar(200) default NULL, + icon_post_latest varchar(200) default NULL, + icon_post_newest varchar(200) default NULL, forum varchar(200) default NULL, forum_new varchar(200) default NULL, forum_locked varchar(200) default NULL, @@ -709,12 +710,9 @@ CREATE TABLE phpbb_styles_imageset ( folder_announce_posted varchar(200) NOT NULL default '', folder_announce_new varchar(200) default NULL, folder_announce_new_posted varchar(200) NOT NULL default '', - topic_watch varchar(200) default NULL, - topic_unwatch varchar(200) default NULL, poll_left varchar(200) default NULL, poll_center varchar(200) default NULL, poll_right varchar(200) default NULL, - rating varchar(200) default NULL, PRIMARY KEY (imageset_id) ); @@ -805,7 +803,8 @@ CREATE TABLE phpbb_user_group ( CREATE TABLE phpbb_users ( user_id mediumint(8) UNSIGNED NOT NULL auto_increment, user_active tinyint(1) DEFAULT '1', - user_founder tinyint(1) DEFAULT '0' NOT NULL, + user_founder tinyint(1) DEFAULT '0', + group_id mediumint(8) DEFAULT '3' NOT NULL user_permissions text NULL, user_ip varchar(40), user_regdate int(11) DEFAULT '0' NOT NULL, |