diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2008-06-21 16:04:13 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2008-06-21 16:04:13 +0000 |
| commit | b8647dc952b8992e3a09d31f27a5f3834fb4e8b5 (patch) | |
| tree | 75f2510be2fb9e8863f1e5e1c519c1d79a1497a9 /phpBB/install/schemas/oracle_schema.sql | |
| parent | aa2baa7eaa51234e6807905a726c9593c7106679 (diff) | |
| download | forums-b8647dc952b8992e3a09d31f27a5f3834fb4e8b5.tar forums-b8647dc952b8992e3a09d31f27a5f3834fb4e8b5.tar.gz forums-b8647dc952b8992e3a09d31f27a5f3834fb4e8b5.tar.bz2 forums-b8647dc952b8992e3a09d31f27a5f3834fb4e8b5.tar.xz forums-b8647dc952b8992e3a09d31f27a5f3834fb4e8b5.zip | |
change subject/title column length
git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@8666 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas/oracle_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/oracle_schema.sql | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql index b87fe4527a..19f09bcebd 100644 --- a/phpBB/install/schemas/oracle_schema.sql +++ b/phpBB/install/schemas/oracle_schema.sql @@ -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 varchar2(300) DEFAULT '' , + draft_subject varchar2(765) DEFAULT '' , draft_message clob DEFAULT '' , CONSTRAINT pk_phpbb_drafts PRIMARY KEY (draft_id) ) @@ -500,7 +500,7 @@ CREATE TABLE phpbb_forums ( forum_topics_real number(8) DEFAULT '0' NOT NULL, forum_last_post_id number(8) DEFAULT '0' NOT NULL, forum_last_poster_id number(8) DEFAULT '0' NOT NULL, - forum_last_post_subject varchar2(300) DEFAULT '' , + forum_last_post_subject varchar2(765) DEFAULT '' , forum_last_post_time number(11) DEFAULT '0' NOT NULL, forum_last_poster_name varchar2(765) DEFAULT '' , forum_last_poster_colour varchar2(6) DEFAULT '' , @@ -849,7 +849,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(765) DEFAULT '' , - post_subject varchar2(300) DEFAULT '' , + post_subject varchar2(765) DEFAULT '' , post_text clob DEFAULT '' , post_checksum varchar2(32) DEFAULT '' , post_attachment number(1) DEFAULT '0' NOT NULL, @@ -908,7 +908,7 @@ 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 varchar2(300) DEFAULT '' , + message_subject varchar2(765) DEFAULT '' , message_text clob DEFAULT '' , message_edit_reason varchar2(765) DEFAULT '' , message_edit_user number(8) DEFAULT '0' NOT NULL, @@ -1300,7 +1300,7 @@ CREATE INDEX phpbb_sessions_session_time ON phpbb_sessions (session_time) / CREATE INDEX phpbb_sessions_session_user_id ON phpbb_sessions (session_user_id) / -CREATE INDEX phpbb_sessions_session_forum_id ON phpbb_sessions (session_forum_id) +CREATE INDEX phpbb_sessions_session_fid ON phpbb_sessions (session_forum_id) / /* @@ -1577,7 +1577,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 varchar2(300) DEFAULT '' , + topic_title varchar2(765) DEFAULT '' , 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, @@ -1593,7 +1593,7 @@ CREATE TABLE phpbb_topics ( topic_last_poster_id number(8) DEFAULT '0' NOT NULL, topic_last_poster_name varchar2(765) DEFAULT '' , topic_last_poster_colour varchar2(6) DEFAULT '' , - topic_last_post_subject varchar2(300) DEFAULT '' , + topic_last_post_subject varchar2(765) DEFAULT '' , topic_last_post_time number(11) DEFAULT '0' NOT NULL, topic_last_view_time number(11) DEFAULT '0' NOT NULL, topic_moved_id number(8) DEFAULT '0' NOT NULL, |