diff options
| author | Joas Schilling <nickvergessen@gmx.de> | 2014-02-02 15:41:49 +0100 |
|---|---|---|
| committer | Joas Schilling <nickvergessen@gmx.de> | 2014-02-06 11:32:06 +0100 |
| commit | 3c640e57c5815c970e706f724fb29a3114826352 (patch) | |
| tree | 1a707ce2f7c51c60ff289c0cb5cb0cfd9705edc1 /phpBB/install/schemas/firebird_schema.sql | |
| parent | 344baf91809bbfd5a224191e13472b94f77b421c (diff) | |
| download | forums-3c640e57c5815c970e706f724fb29a3114826352.tar forums-3c640e57c5815c970e706f724fb29a3114826352.tar.gz forums-3c640e57c5815c970e706f724fb29a3114826352.tar.bz2 forums-3c640e57c5815c970e706f724fb29a3114826352.tar.xz forums-3c640e57c5815c970e706f724fb29a3114826352.zip | |
[ticket/12115] Convert user occupation to a profile field
PHPBB3-12115
Diffstat (limited to 'phpBB/install/schemas/firebird_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/firebird_schema.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql index 791e4ce6b3..6dd2696dea 100644 --- a/phpBB/install/schemas/firebird_schema.sql +++ b/phpBB/install/schemas/firebird_schema.sql @@ -946,7 +946,8 @@ END;; # Table: 'phpbb_profile_fields_data' CREATE TABLE phpbb_profile_fields_data ( - user_id INTEGER DEFAULT 0 NOT NULL + user_id INTEGER DEFAULT 0 NOT NULL, + pf_phpbb_occupation BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL );; ALTER TABLE phpbb_profile_fields_data ADD PRIMARY KEY (user_id);; @@ -1423,7 +1424,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_occ BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL, 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, |