diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-08-16 13:26:23 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-08-16 13:26:23 +0000 |
| commit | c2a42988c78747e1a14459866809db75910b81cf (patch) | |
| tree | db6e71e6c63af975a386888c53273cf0be48dbf5 /phpBB/install | |
| parent | 8e0214256cda881278e2e557c2b443912359f1dd (diff) | |
| download | forums-c2a42988c78747e1a14459866809db75910b81cf.tar forums-c2a42988c78747e1a14459866809db75910b81cf.tar.gz forums-c2a42988c78747e1a14459866809db75910b81cf.tar.bz2 forums-c2a42988c78747e1a14459866809db75910b81cf.tar.xz forums-c2a42988c78747e1a14459866809db75910b81cf.zip | |
They look changed ... :D
git-svn-id: file:///svn/phpbb/trunk@4410 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install')
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 13 | ||||
| -rw-r--r-- | phpBB/install/schemas/schema_data.sql | 1 |
2 files changed, 8 insertions, 6 deletions
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index fcabd12a19..a4d903ec36 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -456,6 +456,7 @@ CREATE TABLE phpbb_styles ( theme_id tinyint(4) UNSIGNED NOT NULL, imageset_id tinyint(4) UNSIGNED NOT NULL, PRIMARY KEY (style_id), + UNIQUE style_name (style_name), KEY (template_id), KEY (theme_id), KEY (imageset_id) @@ -469,7 +470,8 @@ CREATE TABLE phpbb_styles_template ( template_path varchar(30) NOT NULL, bbcode_bitfield int(11) UNSIGNED DEFAULT '0' NOT NULL, template_storedb tinyint(1) DEFAULT '0' NOT NULL, - PRIMARY KEY (template_id) + PRIMARY KEY (template_id), + UNIQUE template_name (template_name) ); # Table: 'phpbb_styles_template_data' @@ -492,7 +494,8 @@ CREATE TABLE phpbb_styles_theme ( theme_storedb tinyint(1) DEFAULT '0' NOT NULL, theme_mtime int(11) DEFAULT '0' NOT NULL, theme_data text DEFAULT '' NOT NULL, - PRIMARY KEY (theme_id) + PRIMARY KEY (theme_id), + UNIQUE theme_name (theme_name) ); # Table: 'phpbb_styles_imageset' @@ -523,8 +526,6 @@ CREATE TABLE phpbb_styles_imageset ( btn_jabber varchar(200) DEFAULT '' NOT NULL, btn_online varchar(200) DEFAULT '' NOT NULL, btn_offline varchar(200) DEFAULT '' NOT NULL, - btn_topic_watch varchar(200) DEFAULT '' NOT NULL, - btn_topic_unwatch varchar(200) DEFAULT '' NOT NULL, icon_unapproved varchar(200) DEFAULT '' NOT NULL, icon_reported varchar(200) DEFAULT '' NOT NULL, icon_attach varchar(200) DEFAULT '' NOT NULL, @@ -561,7 +562,8 @@ CREATE TABLE phpbb_styles_imageset ( poll_left varchar(200) DEFAULT '' NOT NULL, poll_center varchar(200) DEFAULT '' NOT NULL, poll_right varchar(200) DEFAULT '' NOT NULL, - PRIMARY KEY (imageset_id) + PRIMARY KEY (imageset_id), + UNIQUE imageset_name (imageset_name) ); # Table: 'phpbb_topics' @@ -669,7 +671,6 @@ CREATE TABLE phpbb_users ( user_sortby_type varchar(1) DEFAULT '' NOT NULL, user_sortby_dir varchar(1) DEFAULT '' NOT NULL, user_show_days tinyint(1) DEFAULT '' NOT NULL, - user_viewimg tinyint(1) DEFAULT '1' NOT NULL, user_notify tinyint(1) DEFAULT '0' NOT NULL, user_notify_pm tinyint(1) DEFAULT '1' NOT NULL, diff --git a/phpBB/install/schemas/schema_data.sql b/phpBB/install/schemas/schema_data.sql index 715ef1909b..18335fcf65 100644 --- a/phpBB/install/schemas/schema_data.sql +++ b/phpBB/install/schemas/schema_data.sql @@ -225,6 +225,7 @@ INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('u_sendemail', 1 INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('u_readpm', 1); INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('u_sendpm', 1); INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('u_sendim', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('u_hideonline', 1); INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('u_viewonline', 1); INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('u_viewprofile', 1); INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('u_chgavatar', 1); |