create table PHPBB_POSTS_TEXT_CLOB
(
  POST_ID      NUMBER default '0' not null,
  BBCODE_UID   VARCHAR2(10),
  POST_SUBJECT VARCHAR2(60),
  POST_TEXT    CLOB
)
/
insert into phpbb_posts_text_clob (post_id, bbcode_uid, post_subject, post_text)
select post_id, bbcode_uid, post_subject, post_text
from phpbb_posts_text
/
commit
/
create index PHPBB_POSTS_TEXT_C_POST_ID on PHPBB_POSTS_TEXT_CLOB (POST_ID)
/
create table PHPBB_SEARCH_WORDLIST_TEMP
(
  WORD_TEXT   VARCHAR2(50) default '' not null,
  WORD_COMMON VARCHAR2(1) default '0' not null,
  POST_ID     NUMBER not null
)
/
create index PHPBB_SEARCH_WL_TEMP_POSTID on PHPBB_SEARCH_WORDLIST_TEMP (POST_ID)
/
create index PHPBB_SEARCH_WL_TEMP_TEXT on PHPBB_SEARCH_WORDLIST_TEMP (WORD_TEXT)
/
create table PHPBB_PRUNE_TOPICS_TEMP
(
  TOPIC_ID NUMBER not null
)
/
create table PHPBB_PRIVMSGS_TEXT_CLOB
(
  PRIVMSGS_TEXT_ID    NUMBER default '0' not null,
  PRIVMSGS_BBCODE_UID VARCHAR2(10) default '0' not null,
  PRIVMSGS_TEXT       CLOB
)
/
insert into phpbb_privmsgs_text_clob (privmsgs_text_id, privmsgs_bbcode_uid, privmsgs_text)
select privmsgs_text_id, privmsgs_bbcode_uid, privmsgs_text from phpbb_privmsgs_text
/
commit
/
create index PHPBB_PRIVMSGS_TEXT_C_ID on PHPBB_PRIVMSGS_TEXT_CLOB (PRIVMSGS_TEXT_ID)
/
create table PHPBB_FORUMS_CLOB
(
  FORUM_ID           NUMBER not null,
  CAT_ID             NUMBER not null,
  FORUM_NAME         VARCHAR2(150),
  FORUM_DESC         CLOB,
  FORUM_STATUS       NUMBER default '0' not null,
  FORUM_ORDER        NUMBER default '1' not null,
  FORUM_POSTS        NUMBER default '0' not null,
  FORUM_TOPICS       NUMBER default '0' not null,
  FORUM_LAST_POST_ID NUMBER default '0' not null,
  PRUNE_NEXT         NUMBER,
  PRUNE_ENABLE       VARCHAR2(1) default '0' not null,
  AUTH_VIEW          VARCHAR2(2) default '0' not null,
  AUTH_READ          VARCHAR2(2) default '0' not null,
  AUTH_POST          VARCHAR2(2) default '0' not null,
  AUTH_REPLY         VARCHAR2(2) default '0' not null,
  AUTH_EDIT          VARCHAR2(2) default '0' not null,
  AUTH_DELETE        VARCHAR2(2) default '0' not null,
  AUTH_STICKY        VARCHAR2(2) default '0' not null,
  AUTH_ANNOUNCE      VARCHAR2(2) default '0' not null,
  AUTH_VOTE          VARCHAR2(2) default '0' not null,
  AUTH_POLLCREATE    VARCHAR2(2) default '0' not null,
  AUTH_ATTACHMENTS   VARCHAR2(2) default '0' not null
)
/
insert into phpbb_forums_clob (forum_id, cat_id, forum_name, forum_desc, forum_status, 
forum_order, forum_posts, forum_topics, forum_last_post_id, prune_next, prune_enable, 
auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, 
auth_announce, auth_vote, auth_pollcreate, auth_attachments)
select forum_id, cat_id, forum_name, forum_desc, forum_status, 
forum_order, forum_posts, forum_topics, forum_last_post_id, prune_next, prune_enable, 
auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, 
auth_announce, auth_vote, auth_pollcreate, auth_attachments
from phpbb_forums
/
commit
/
create index PHPBB_FORUMS_C_CAT_ID on PHPBB_FORUMS_CLOB (CAT_ID)
/
create index PHPBB_FORUMS_C_FORUM_ID on PHPBB_FORUMS_CLOB (FORUM_ID)
/
create index PHPBB_FORUMS_C_FORUM_ORDER on PHPBB_FORUMS_CLOB (FORUM_ORDER)
/
create index PHPBB_FORUMS_C_LAST_POST_ID on PHPBB_FORUMS_CLOB (FORUM_LAST_POST_ID)
/