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/mysql_schema.sql | |
| 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/mysql_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 24 |
1 files changed, 12 insertions, 12 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) ); |