diff options
| author | Joas Schilling <nickvergessen@gmx.de> | 2014-02-02 21:45:59 +0100 |
|---|---|---|
| committer | Joas Schilling <nickvergessen@gmx.de> | 2014-02-06 11:32:11 +0100 |
| commit | bbada27ee9e797c7f6ce997152bc1efb8c8f125d (patch) | |
| tree | 230477d8febe599c1be6082cc4a5fcd8dc639333 /phpBB/install/schemas/firebird_schema.sql | |
| parent | 0ad726768c569cf4987aa93e2d6f2e5d185c7dc5 (diff) | |
| download | forums-bbada27ee9e797c7f6ce997152bc1efb8c8f125d.tar forums-bbada27ee9e797c7f6ce997152bc1efb8c8f125d.tar.gz forums-bbada27ee9e797c7f6ce997152bc1efb8c8f125d.tar.bz2 forums-bbada27ee9e797c7f6ce997152bc1efb8c8f125d.tar.xz forums-bbada27ee9e797c7f6ce997152bc1efb8c8f125d.zip | |
[ticket/12115] Also port user interests to profile fields
PHPBB3-12115
Diffstat (limited to 'phpBB/install/schemas/firebird_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/firebird_schema.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql index 6dd2696dea..c717cb7416 100644 --- a/phpBB/install/schemas/firebird_schema.sql +++ b/phpBB/install/schemas/firebird_schema.sql @@ -947,6 +947,7 @@ END;; # Table: 'phpbb_profile_fields_data' CREATE TABLE phpbb_profile_fields_data ( user_id INTEGER DEFAULT 0 NOT NULL, + pf_phpbb_interests BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL, pf_phpbb_occupation BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL );; @@ -1424,7 +1425,6 @@ CREATE TABLE phpbb_users ( user_msnm VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE, user_jabber VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE, user_website VARCHAR(200) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE, - user_interests BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL, user_actkey VARCHAR(32) CHARACTER SET NONE DEFAULT '' NOT NULL, user_newpasswd VARCHAR(40) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE, user_form_salt VARCHAR(32) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE, |