6 files changed, 18 insertions, 18 deletions
diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql
index 0c8d0af6e1..be7c161a9c 100644
--- a/phpBB/install/schemas/firebird_schema.sql
+++ b/phpBB/install/schemas/firebird_schema.sql
@@ -11,7 +11,7 @@ CREATE TABLE phpbb_attachments (
 	topic_id INTEGER DEFAULT 0 NOT NULL,
 	in_message INTEGER DEFAULT 0 NOT NULL,
 	poster_id INTEGER DEFAULT 0 NOT NULL,
-	pysical_filename VARCHAR(255) DEFAULT '' NOT NULL,
+	physical_filename VARCHAR(255) DEFAULT '' NOT NULL,
 	real_filename VARCHAR(255) DEFAULT '' NOT NULL,
 	download_count INTEGER DEFAULT 0 NOT NULL,
 	attach_comment BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
@@ -472,7 +472,7 @@ END;;
 # Table: 'phpbb_lang'
 CREATE TABLE phpbb_lang (
 	lang_id INTEGER NOT NULL,
-	lang_iso VARCHAR(5) DEFAULT '' NOT NULL,
+	lang_iso VARCHAR(30) DEFAULT '' NOT NULL,
 	lang_dir VARCHAR(30) DEFAULT '' NOT NULL,
 	lang_english_name VARCHAR(100) DEFAULT '' NOT NULL,
 	lang_local_name VARCHAR(255) DEFAULT '' NOT NULL,
diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql
index 01dc57fcf6..67699a3d80 100644
--- a/phpBB/install/schemas/mssql_schema.sql
+++ b/phpBB/install/schemas/mssql_schema.sql
@@ -15,7 +15,7 @@ CREATE TABLE [phpbb_attachments] (
 	[topic_id] [int] DEFAULT (0) NOT NULL ,
 	[in_message] [int] DEFAULT (0) NOT NULL ,
 	[poster_id] [int] DEFAULT (0) NOT NULL ,
-	[pysical_filename] [varchar] (255) DEFAULT ('') NOT NULL ,
+	[physical_filename] [varchar] (255) DEFAULT ('') NOT NULL ,
 	[real_filename] [varchar] (255) DEFAULT ('') NOT NULL ,
 	[download_count] [int] DEFAULT (0) NOT NULL ,
 	[attach_comment] [varchar] (8000) DEFAULT ('') NOT NULL ,
@@ -509,7 +509,7 @@ GO
 /* Table: 'phpbb_lang' */
 CREATE TABLE [phpbb_lang] (
 	[lang_id] [int] IDENTITY (1, 1) NOT NULL ,
-	[lang_iso] [varchar] (5) DEFAULT ('') NOT NULL ,
+	[lang_iso] [varchar] (30) DEFAULT ('') NOT NULL ,
 	[lang_dir] [varchar] (30) DEFAULT ('') NOT NULL ,
 	[lang_english_name] [varchar] (100) DEFAULT ('') NOT NULL ,
 	[lang_local_name] [varchar] (255) DEFAULT ('') NOT NULL ,
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql
index 0cd3bd1c92..e1d39e7c97 100644
--- a/phpBB/install/schemas/mysql_schema.sql
+++ b/phpBB/install/schemas/mysql_schema.sql
@@ -11,7 +11,7 @@ CREATE TABLE phpbb_attachments (
 	topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	in_message tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 	poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-	pysical_filename varchar(255) DEFAULT '' NOT NULL,
+	physical_filename varchar(255) DEFAULT '' NOT NULL,
 	real_filename varchar(255) DEFAULT '' NOT NULL,
 	download_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	attach_comment text DEFAULT '' NOT NULL,
@@ -322,7 +322,7 @@ CREATE TABLE phpbb_icons (
 # Table: 'phpbb_lang'
 CREATE TABLE phpbb_lang (
 	lang_id tinyint(4) NOT NULL auto_increment,
-	lang_iso varchar(5) DEFAULT '' NOT NULL,
+	lang_iso varchar(30) DEFAULT '' NOT NULL,
 	lang_dir varchar(30) DEFAULT '' NOT NULL,
 	lang_english_name varchar(100) DEFAULT '' NOT NULL,
 	lang_local_name varchar(255) DEFAULT '' NOT NULL,
@@ -500,7 +500,7 @@ CREATE TABLE phpbb_privmsgs_rules (
 	rule_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	rule_group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	rule_action mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-	rule_folder_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
+	rule_folder_id int(4) DEFAULT '0' NOT NULL,
 	PRIMARY KEY (rule_id)
 );
 
@@ -516,7 +516,7 @@ CREATE TABLE phpbb_privmsgs_to (
 	pm_replied tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 	pm_marked tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 	pm_forwarded tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
-	folder_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
+	folder_id int(4) DEFAULT '0' NOT NULL,
 	KEY msg_id (msg_id),
 	KEY user_folder_id (user_id, folder_id)
 );
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql
index 2fdd4ed96d..2e6331ac40 100644
--- a/phpBB/install/schemas/oracle_schema.sql
+++ b/phpBB/install/schemas/oracle_schema.sql
@@ -49,7 +49,7 @@ CREATE TABLE phpbb_attachments (
 	topic_id number(8) DEFAULT '0' NOT NULL,
 	in_message number(1) DEFAULT '0' NOT NULL,
 	poster_id number(8) DEFAULT '0' NOT NULL,
-	pysical_filename varchar2(255) DEFAULT '' NOT NULL,
+	physical_filename varchar2(255) DEFAULT '' NOT NULL,
 	real_filename varchar2(255) DEFAULT '' NOT NULL,
 	download_count number(8) DEFAULT '0' NOT NULL,
 	attach_comment clob DEFAULT '' NOT NULL,
@@ -598,7 +598,7 @@ END;
 /* Table: 'phpbb_lang' */
 CREATE TABLE phpbb_lang (
 	lang_id number(4) NOT NULL,
-	lang_iso varchar2(5) DEFAULT '' NOT NULL,
+	lang_iso varchar2(30) DEFAULT '' NOT NULL,
 	lang_dir varchar2(30) DEFAULT '' NOT NULL,
 	lang_english_name varchar2(100) DEFAULT '' NOT NULL,
 	lang_local_name varchar2(255) DEFAULT '' NOT NULL,
diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql
index b91142d6a2..8ccf2a6468 100644
--- a/phpBB/install/schemas/postgres_schema.sql
+++ b/phpBB/install/schemas/postgres_schema.sql
@@ -85,7 +85,7 @@ CREATE TABLE phpbb_attachments (
 	topic_id INT4 DEFAULT '0' NOT NULL CHECK (topic_id >= 0),
 	in_message INT2 DEFAULT '0' NOT NULL CHECK (in_message >= 0),
 	poster_id INT4 DEFAULT '0' NOT NULL CHECK (poster_id >= 0),
-	pysical_filename varchar(255) DEFAULT '' NOT NULL,
+	physical_filename varchar(255) DEFAULT '' NOT NULL,
 	real_filename varchar(255) DEFAULT '' NOT NULL,
 	download_count INT4 DEFAULT '0' NOT NULL CHECK (download_count >= 0),
 	attach_comment varchar(8000) DEFAULT '' NOT NULL,
@@ -417,7 +417,7 @@ CREATE SEQUENCE phpbb_lang_seq;
 
 CREATE TABLE phpbb_lang (
 	lang_id INT2 DEFAULT nextval('phpbb_lang_seq'),
-	lang_iso varchar(5) DEFAULT '' NOT NULL,
+	lang_iso varchar(30) DEFAULT '' NOT NULL,
 	lang_dir varchar(30) DEFAULT '' NOT NULL,
 	lang_english_name varchar(100) DEFAULT '' NOT NULL,
 	lang_local_name varchar(255) DEFAULT '' NOT NULL,
@@ -607,7 +607,7 @@ CREATE TABLE phpbb_privmsgs_rules (
 	rule_user_id INT4 DEFAULT '0' NOT NULL CHECK (rule_user_id >= 0),
 	rule_group_id INT4 DEFAULT '0' NOT NULL CHECK (rule_group_id >= 0),
 	rule_action INT4 DEFAULT '0' NOT NULL CHECK (rule_action >= 0),
-	rule_folder_id INT4 DEFAULT '0' NOT NULL CHECK (rule_folder_id >= 0),
+	rule_folder_id INT4 DEFAULT '0' NOT NULL,
 	PRIMARY KEY (rule_id)
 );
 
@@ -623,7 +623,7 @@ CREATE TABLE phpbb_privmsgs_to (
 	pm_replied INT2 DEFAULT '0' NOT NULL CHECK (pm_replied >= 0),
 	pm_marked INT2 DEFAULT '0' NOT NULL CHECK (pm_marked >= 0),
 	pm_forwarded INT2 DEFAULT '0' NOT NULL CHECK (pm_forwarded >= 0),
-	folder_id INT4 DEFAULT '0' NOT NULL CHECK (folder_id >= 0)
+	folder_id INT4 DEFAULT '0' NOT NULL
 );
 
 CREATE INDEX phpbb_privmsgs_to_msg_id ON phpbb_privmsgs_to (msg_id);
diff --git a/phpBB/install/schemas/sqlite_schema.sql b/phpBB/install/schemas/sqlite_schema.sql
index a2b2202337..6b39fe7c15 100644
--- a/phpBB/install/schemas/sqlite_schema.sql
+++ b/phpBB/install/schemas/sqlite_schema.sql
@@ -13,7 +13,7 @@ CREATE TABLE phpbb_attachments (
 	topic_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
 	in_message tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
 	poster_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
-	pysical_filename varchar(255) NOT NULL DEFAULT '',
+	physical_filename varchar(255) NOT NULL DEFAULT '',
 	real_filename varchar(255) NOT NULL DEFAULT '',
 	download_count mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
 	attach_comment text(65535) NOT NULL DEFAULT '',
@@ -306,7 +306,7 @@ CREATE TABLE phpbb_icons (
 # Table: 'phpbb_lang'
 CREATE TABLE phpbb_lang (
 	lang_id INTEGER PRIMARY KEY NOT NULL ,
-	lang_iso varchar(5) NOT NULL DEFAULT '',
+	lang_iso varchar(30) NOT NULL DEFAULT '',
 	lang_dir varchar(30) NOT NULL DEFAULT '',
 	lang_english_name varchar(100) NOT NULL DEFAULT '',
 	lang_local_name varchar(255) NOT NULL DEFAULT '',
@@ -478,7 +478,7 @@ CREATE TABLE phpbb_privmsgs_rules (
 	rule_user_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
 	rule_group_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
 	rule_action mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
-	rule_folder_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0'
+	rule_folder_id int(4) NOT NULL DEFAULT '0'
 );
 
 
@@ -493,7 +493,7 @@ CREATE TABLE phpbb_privmsgs_to (
 	pm_replied tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
 	pm_marked tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
 	pm_forwarded tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
-	folder_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0'
+	folder_id int(4) NOT NULL DEFAULT '0'
 );
 
 CREATE INDEX phpbb_privmsgs_to_msg_id ON phpbb_privmsgs_to (msg_id);