diff options
| author | Nils Adermann <naderman@naderman.de> | 2014-02-10 13:52:12 +0100 |
|---|---|---|
| committer | Nils Adermann <naderman@naderman.de> | 2014-02-10 13:52:12 +0100 |
| commit | 840ab75520726e4db689ab1a92de6c17d86b107b (patch) | |
| tree | 887704c33fe0ebebbceceee0544969e0ff1f631b /phpBB/install/schemas/postgres_schema.sql | |
| parent | 02674de89367895642b57450b5444ab23488ab9b (diff) | |
| parent | 4663ea7c8288ae56e00e2270aee49cb14a7c0276 (diff) | |
| download | forums-840ab75520726e4db689ab1a92de6c17d86b107b.tar forums-840ab75520726e4db689ab1a92de6c17d86b107b.tar.gz forums-840ab75520726e4db689ab1a92de6c17d86b107b.tar.bz2 forums-840ab75520726e4db689ab1a92de6c17d86b107b.tar.xz forums-840ab75520726e4db689ab1a92de6c17d86b107b.zip | |
Merge pull request #1988 from nickvergessen/ticket/12115
[ticket/12115] Convert occupation profile field to custom field
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 f06bcdf2a9..229a57a11b 100644 --- a/phpBB/install/schemas/postgres_schema.sql +++ b/phpBB/install/schemas/postgres_schema.sql @@ -882,6 +882,8 @@ CREATE INDEX phpbb_profile_fields_fld_ordr ON phpbb_profile_fields (field_order) */ CREATE TABLE phpbb_profile_fields_data ( user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0), + pf_phpbb_interests varchar(4000) DEFAULT '' NOT NULL, + pf_phpbb_occupation varchar(4000) DEFAULT '' NOT NULL, PRIMARY KEY (user_id) ); @@ -1304,8 +1306,6 @@ CREATE TABLE phpbb_users ( user_msnm varchar(255) DEFAULT '' NOT NULL, user_jabber varchar(255) DEFAULT '' NOT NULL, user_website varchar(200) DEFAULT '' NOT NULL, - user_occ varchar(4000) DEFAULT '' NOT NULL, - user_interests varchar(4000) DEFAULT '' NOT NULL, user_actkey varchar(32) DEFAULT '' NOT NULL, user_newpasswd varchar(40) DEFAULT '' NOT NULL, user_form_salt varchar(32) DEFAULT '' NOT NULL, |