aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas/oracle_schema.sql
diff options
context:
space:
mode:
authorNils Adermann <naderman@naderman.de>2014-02-10 13:52:12 +0100
committerNils Adermann <naderman@naderman.de>2014-02-10 13:52:12 +0100
commit840ab75520726e4db689ab1a92de6c17d86b107b (patch)
tree887704c33fe0ebebbceceee0544969e0ff1f631b /phpBB/install/schemas/oracle_schema.sql
parent02674de89367895642b57450b5444ab23488ab9b (diff)
parent4663ea7c8288ae56e00e2270aee49cb14a7c0276 (diff)
downloadforums-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/oracle_schema.sql')
-rw-r--r--phpBB/install/schemas/oracle_schema.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql
index ea5cfdf321..b752908ef8 100644
--- a/phpBB/install/schemas/oracle_schema.sql
+++ b/phpBB/install/schemas/oracle_schema.sql
@@ -1265,6 +1265,8 @@ END;
*/
CREATE TABLE phpbb_profile_fields_data (
user_id number(8) DEFAULT '0' NOT NULL,
+ pf_phpbb_interests clob DEFAULT '' ,
+ pf_phpbb_occupation clob DEFAULT '' ,
CONSTRAINT pk_phpbb_profile_fields_data PRIMARY KEY (user_id)
)
/
@@ -1856,8 +1858,6 @@ CREATE TABLE phpbb_users (
user_msnm varchar2(765) DEFAULT '' ,
user_jabber varchar2(765) DEFAULT '' ,
user_website varchar2(600) DEFAULT '' ,
- user_occ clob DEFAULT '' ,
- user_interests clob DEFAULT '' ,
user_actkey varchar2(32) DEFAULT '' ,
user_newpasswd varchar2(120) DEFAULT '' ,
user_form_salt varchar2(96) DEFAULT '' ,