diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2006-04-26 12:06:21 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2006-04-26 12:06:21 +0000 |
| commit | db56792e91fa33da53bcd169c1fc45f092186b1d (patch) | |
| tree | f7cc8faac2a399c0df234b02e226d8d2e8cb3e08 /phpBB | |
| parent | 31947017c4766ddbcc572619393c2b6a11321570 (diff) | |
| download | forums-db56792e91fa33da53bcd169c1fc45f092186b1d.tar forums-db56792e91fa33da53bcd169c1fc45f092186b1d.tar.gz forums-db56792e91fa33da53bcd169c1fc45f092186b1d.tar.bz2 forums-db56792e91fa33da53bcd169c1fc45f092186b1d.tar.xz forums-db56792e91fa33da53bcd169c1fc45f092186b1d.zip | |
- use varchar2 in favor of clob for some columns...
git-svn-id: file:///svn/phpbb/trunk@5847 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB')
| -rw-r--r-- | phpBB/install/schemas/oracle_schema.sql | 22 |
1 files changed, 11 insertions, 11 deletions
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql index 7abf28e542..297b346631 100644 --- a/phpBB/install/schemas/oracle_schema.sql +++ b/phpBB/install/schemas/oracle_schema.sql @@ -215,8 +215,8 @@ CREATE TABLE phpbb_banlist ( ban_start number(11) DEFAULT '0' NOT NULL, ban_end number(11) DEFAULT '0' NOT NULL, ban_exclude number(1) DEFAULT '0' NOT NULL, - ban_reason clob, - ban_give_reason clob, + ban_reason varchar2(1000), + ban_give_reason varchar2(1000), CONSTRAINT pk_phpbb_banlist PRIMARY KEY (ban_id) ) / @@ -280,7 +280,7 @@ CREATE INDEX phpbb_bookmarks_topic_user_id on phpbb_bookmarks (topic_id, user_id CREATE TABLE phpbb_bots ( bot_id number(3) NOT NULL, bot_active number(1) DEFAULT '1' NOT NULL, - bot_name clob, + bot_name varchar2(1000), user_id number(8) DEFAULT '0' NOT NULL, bot_agent varchar2(255) DEFAULT '', bot_ip varchar2(255) DEFAULT '', @@ -382,7 +382,7 @@ CREATE TABLE phpbb_drafts ( topic_id number(8) DEFAULT '0' NOT NULL, forum_id number(8) DEFAULT '0' NOT NULL, save_time number(11) DEFAULT '0' NOT NULL, - draft_subject clob, + draft_subject varchar2(1000), draft_message clob, CONSTRAINT pk_phpbb_drafts PRIMARY KEY (draft_id) ) @@ -476,7 +476,7 @@ CREATE TABLE phpbb_forums ( left_id number(5) NOT NULL, right_id number(5) NOT NULL, forum_parents clob, - forum_name clob, + forum_name varchar2(1000), forum_desc clob, forum_desc_bitfield number(11) DEFAULT '0' NOT NULL, forum_desc_uid varchar2(5) DEFAULT '', @@ -837,7 +837,7 @@ CREATE TABLE phpbb_posts ( enable_magic_url number(1) DEFAULT '1' NOT NULL, enable_sig number(1) DEFAULT '1' NOT NULL, post_username varchar2(255), - post_subject clob, + post_subject varchar2(1000), post_text clob, post_checksum varchar2(32), post_encoding varchar2(20) DEFAULT 'iso-8859-1', @@ -845,7 +845,7 @@ CREATE TABLE phpbb_posts ( bbcode_bitfield number(11) DEFAULT '0' NOT NULL, bbcode_uid varchar2(5) DEFAULT '', post_edit_time number(11) DEFAULT '0' NOT NULL, - post_edit_reason clob, + post_edit_reason varchar2(1000), post_edit_user number(8) DEFAULT '0' NOT NULL, post_edit_count number(5) DEFAULT '0' NOT NULL, post_edit_locked number(1) DEFAULT '0' NOT NULL, @@ -896,9 +896,9 @@ CREATE TABLE phpbb_privmsgs ( enable_smilies number(1) DEFAULT '1' NOT NULL, enable_magic_url number(1) DEFAULT '1' NOT NULL, enable_sig number(1) DEFAULT '1' NOT NULL, - message_subject clob, + message_subject varchar2(1000), message_text clob, - message_edit_reason clob, + message_edit_reason varchar2(1000), message_edit_user number(8) DEFAULT '0' NOT NULL, message_encoding varchar2(20) DEFAULT 'iso-8859-1', message_attachment number(1) DEFAULT '0' NOT NULL, @@ -1591,7 +1591,7 @@ CREATE TABLE phpbb_topics ( topic_attachment number(1) DEFAULT '0' NOT NULL, topic_approved number(1) DEFAULT '1' NOT NULL, topic_reported number(1) DEFAULT '0' NOT NULL, - topic_title clob, + topic_title varchar2(1000), topic_poster number(8) DEFAULT '0' NOT NULL, topic_time number(11) DEFAULT '0' NOT NULL, topic_time_limit number(11) DEFAULT '0' NOT NULL, @@ -1610,7 +1610,7 @@ CREATE TABLE phpbb_topics ( topic_moved_id number(8) DEFAULT '0' NOT NULL, topic_bumped number(1) DEFAULT '0' NOT NULL, topic_bumper number(8) DEFAULT '0' NOT NULL, - poll_title clob, + poll_title varchar2(1000), poll_start number(11) DEFAULT '0' NOT NULL, poll_length number(11) DEFAULT '0' NOT NULL, poll_max_options number(4) DEFAULT '1' NOT NULL, |