diff options
| author | Joas Schilling <nickvergessen@gmx.de> | 2014-01-17 21:53:08 +0100 |
|---|---|---|
| committer | Joas Schilling <nickvergessen@gmx.de> | 2014-01-17 21:53:08 +0100 |
| commit | 39ff387d36001c14dc2130feaf811d51e946c886 (patch) | |
| tree | 3aaa960357e2bdca651a46c7a6bd89c415c8e47a /phpBB/install/schemas/postgres_schema.sql | |
| parent | aa2f0a652ff19490def8137bc73255dff282f305 (diff) | |
| download | forums-39ff387d36001c14dc2130feaf811d51e946c886.tar forums-39ff387d36001c14dc2130feaf811d51e946c886.tar.gz forums-39ff387d36001c14dc2130feaf811d51e946c886.tar.bz2 forums-39ff387d36001c14dc2130feaf811d51e946c886.tar.xz forums-39ff387d36001c14dc2130feaf811d51e946c886.zip | |
[ticket/11201] Update schema files and unit test
PHPBB3-11201
Diffstat (limited to 'phpBB/install/schemas/postgres_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/postgres_schema.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql index 7773602c16..0b34b8b22c 100644 --- a/phpBB/install/schemas/postgres_schema.sql +++ b/phpBB/install/schemas/postgres_schema.sql @@ -853,7 +853,7 @@ CREATE SEQUENCE phpbb_profile_fields_seq; CREATE TABLE phpbb_profile_fields ( field_id INT4 DEFAULT nextval('phpbb_profile_fields_seq'), field_name varchar(255) DEFAULT '' NOT NULL, - field_type INT2 DEFAULT '0' NOT NULL, + field_type varchar(100) DEFAULT '' NOT NULL, field_ident varchar(20) DEFAULT '' NOT NULL, field_length varchar(20) DEFAULT '' NOT NULL, field_minlen varchar(255) DEFAULT '' NOT NULL, @@ -893,7 +893,7 @@ CREATE TABLE phpbb_profile_fields_lang ( field_id INT4 DEFAULT '0' NOT NULL CHECK (field_id >= 0), lang_id INT4 DEFAULT '0' NOT NULL CHECK (lang_id >= 0), option_id INT4 DEFAULT '0' NOT NULL CHECK (option_id >= 0), - field_type INT2 DEFAULT '0' NOT NULL, + field_type varchar(100) DEFAULT '' NOT NULL, lang_value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (field_id, lang_id, option_id) ); |