diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2006-07-17 15:32:46 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2006-07-17 15:32:46 +0000 |
| commit | 99a7ce5bbe92b1313a22db2d8dad51046dca26d9 (patch) | |
| tree | 7926a5350a86f06e1c0b209d5a16674002750e98 /phpBB/install/schemas/mysql_schema.sql | |
| parent | 1a5e4f446a681b9dbf02951445bb1e2088bd435a (diff) | |
| download | forums-99a7ce5bbe92b1313a22db2d8dad51046dca26d9.tar forums-99a7ce5bbe92b1313a22db2d8dad51046dca26d9.tar.gz forums-99a7ce5bbe92b1313a22db2d8dad51046dca26d9.tar.bz2 forums-99a7ce5bbe92b1313a22db2d8dad51046dca26d9.tar.xz forums-99a7ce5bbe92b1313a22db2d8dad51046dca26d9.zip | |
fix the schema files as well as other tiny bugs.
git-svn-id: file:///svn/phpbb/trunk@6190 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas/mysql_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 8 |
1 files changed, 4 insertions, 4 deletions
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) ); |