diff options
| author | Nils Adermann <naderman@naderman.de> | 2014-02-11 02:18:16 +0100 |
|---|---|---|
| committer | Nils Adermann <naderman@naderman.de> | 2014-02-11 02:18:16 +0100 |
| commit | 0b2b76f9514fed54c92e439eadbef6dc80290cd3 (patch) | |
| tree | 779a80bc5d106afaff20a28675ba7e69771a7262 /phpBB/install/schemas/oracle_schema.sql | |
| parent | b088bf864bf5827c1801c53c0af1b5a2f89f5b16 (diff) | |
| parent | 5550f0fa870d531879d53d1bfdd76dcd29a16ce6 (diff) | |
| download | forums-0b2b76f9514fed54c92e439eadbef6dc80290cd3.tar forums-0b2b76f9514fed54c92e439eadbef6dc80290cd3.tar.gz forums-0b2b76f9514fed54c92e439eadbef6dc80290cd3.tar.bz2 forums-0b2b76f9514fed54c92e439eadbef6dc80290cd3.tar.xz forums-0b2b76f9514fed54c92e439eadbef6dc80290cd3.zip | |
Merge pull request #2010 from nickvergessen/ticket/12169
Ticket/12169 Convert location user field to profile field
Diffstat (limited to 'phpBB/install/schemas/oracle_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/oracle_schema.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql index b752908ef8..ad8d354db9 100644 --- a/phpBB/install/schemas/oracle_schema.sql +++ b/phpBB/install/schemas/oracle_schema.sql @@ -1230,6 +1230,7 @@ CREATE TABLE phpbb_profile_fields ( field_show_on_reg number(1) DEFAULT '0' NOT NULL, field_show_on_pm number(1) DEFAULT '0' NOT NULL, field_show_on_vt number(1) DEFAULT '0' NOT NULL, + field_show_on_ml number(1) DEFAULT '0' NOT NULL, field_show_profile number(1) DEFAULT '0' NOT NULL, field_hide number(1) DEFAULT '0' NOT NULL, field_no_view number(1) DEFAULT '0' NOT NULL, @@ -1265,6 +1266,7 @@ END; */ CREATE TABLE phpbb_profile_fields_data ( user_id number(8) DEFAULT '0' NOT NULL, + pf_phpbb_location varchar2(255) DEFAULT '' , pf_phpbb_interests clob DEFAULT '' , pf_phpbb_occupation clob DEFAULT '' , CONSTRAINT pk_phpbb_profile_fields_data PRIMARY KEY (user_id) @@ -1851,7 +1853,6 @@ CREATE TABLE phpbb_users ( user_sig clob DEFAULT '' , user_sig_bbcode_uid varchar2(8) DEFAULT '' , user_sig_bbcode_bitfield varchar2(255) DEFAULT '' , - user_from varchar2(300) DEFAULT '' , user_icq varchar2(15) DEFAULT '' , user_aim varchar2(765) DEFAULT '' , user_yim varchar2(765) DEFAULT '' , |