diff options
| author | Graham Eames <grahamje@users.sourceforge.net> | 2006-06-21 20:18:02 +0000 |
|---|---|---|
| committer | Graham Eames <grahamje@users.sourceforge.net> | 2006-06-21 20:18:02 +0000 |
| commit | daa0435614af7bed95e71f3b11aa2c372df3958d (patch) | |
| tree | 414e9c56eed966f4c842576e9b7d3d4aa5c43ac1 /phpBB/install/schemas | |
| parent | 8dbef23cea5436c87431d1222ca4ae4ec8bcf4f9 (diff) | |
| download | forums-daa0435614af7bed95e71f3b11aa2c372df3958d.tar forums-daa0435614af7bed95e71f3b11aa2c372df3958d.tar.gz forums-daa0435614af7bed95e71f3b11aa2c372df3958d.tar.bz2 forums-daa0435614af7bed95e71f3b11aa2c372df3958d.tar.xz forums-daa0435614af7bed95e71f3b11aa2c372df3958d.zip | |
Improve i18n by installing all available language packs on install
+ unb0rk the mysql schema ;)
git-svn-id: file:///svn/phpbb/trunk@6113 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas')
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 24 | ||||
| -rw-r--r-- | phpBB/install/schemas/schema_data.sql | 3 |
2 files changed, 12 insertions, 15 deletions
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index fad2c457e3..b996eea287 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -195,9 +195,9 @@ CREATE TABLE phpbb_extension_groups ( # Table: 'phpbb_forums' CREATE TABLE phpbb_forums ( forum_id smallint(5) UNSIGNED NOT NULL auto_increment, - parent_id smallint(5) DEFAULT '0' UNSIGNED NOT NULL, - left_id smallint(5) DEFAULT '0' UNSIGNED NOT NULL, - right_id smallint(5) DEFAULT '0' UNSIGNED NOT NULL, + parent_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL, + left_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL, + right_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL, forum_parents text, forum_name text, forum_desc text, @@ -227,8 +227,8 @@ CREATE TABLE phpbb_forums ( enable_icons tinyint(1) DEFAULT '1' NOT NULL, enable_prune tinyint(1) DEFAULT '0' NOT NULL, prune_next int(11) UNSIGNED, - prune_days tinyint(4) DEFAULT '0' UNSIGNED NOT NULL, - prune_viewed tinyint(4) DEFAULT '0' UNSIGNED NOT NULL, + prune_days tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, + prune_viewed tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, prune_freq tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, PRIMARY KEY (forum_id), KEY left_right_id (left_id, right_id), @@ -289,9 +289,9 @@ CREATE TABLE phpbb_groups ( CREATE TABLE phpbb_icons ( icons_id tinyint(4) UNSIGNED NOT NULL auto_increment, icons_url varchar(255), - icons_width tinyint(4) DEFAULT '0' UNSIGNED NOT NULL, - icons_height tinyint(4) DEFAULT '0' UNSIGNED NOT NULL, - icons_order tinyint(4) DEFAULT '0' UNSIGNED NOT NULL, + icons_width tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, + icons_height tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, + icons_order tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, display_on_posting tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, PRIMARY KEY (icons_id) ); @@ -329,7 +329,7 @@ CREATE TABLE phpbb_log ( # Table: 'phpbb_moderator_cache' CREATE TABLE phpbb_moderator_cache ( - forum_id mediumint(8) DEFAULT '0' UNSIGNED NOT NULL, + forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, username varchar(255) DEFAULT '' NOT NULL, group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, @@ -637,9 +637,9 @@ CREATE TABLE phpbb_smilies ( code varchar(50), emotion varchar(50), smiley_url varchar(50), - smiley_width tinyint(4) DEFAULT '0' UNSIGNED NOT NULL, - smiley_height tinyint(4) DEFAULT '0' UNSIGNED NOT NULL, - smiley_order tinyint(4) DEFAULT '0' UNSIGNED NOT NULL, + smiley_width tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, + smiley_height tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, + smiley_order tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, display_on_posting tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, PRIMARY KEY (smiley_id) ); diff --git a/phpBB/install/schemas/schema_data.sql b/phpBB/install/schemas/schema_data.sql index 80901a23b8..ac34328cfa 100644 --- a/phpBB/install/schemas/schema_data.sql +++ b/phpBB/install/schemas/schema_data.sql @@ -389,9 +389,6 @@ INSERT INTO phpbb_styles_template (template_name, template_copyright, template_p # -- phpbb_styles_theme INSERT INTO phpbb_styles_theme (theme_name, theme_copyright, theme_path, theme_data) VALUES ('subSilver', '© phpBB Group', 'subSilver', ''); -# -- Language -INSERT INTO phpbb_lang (lang_iso, lang_dir, lang_english_name, lang_local_name, lang_author) VALUES ('en', 'en', 'English [ GB ]', 'English [ GB ]', 'phpBB Group'); - # -- Forums INSERT INTO phpbb_forums (forum_name, forum_desc, left_id, right_id, parent_id, forum_type, forum_posts, forum_topics, forum_topics_real, forum_last_post_id, forum_last_poster_id, forum_last_poster_name, forum_last_post_time, forum_link, forum_password, forum_image, forum_rules, forum_rules_link, forum_rules_uid, forum_desc_uid, prune_days, prune_viewed) VALUES ('My first Category', '', 1, 4, 0, 0, 1, 1, 1, 1, 2, 'Admin', 972086460, '', '', '', '', '', '', '', 0, 0); |