From 21de871aff0392803dd98ab8a895fabac35f4219 Mon Sep 17 00:00:00 2001
From: Meik Sievertsen <acydburn@phpbb.com>
Date: Tue, 21 Mar 2006 19:23:34 +0000
Subject: - a bunch of bugfixes. :P

git-svn-id: file:///svn/phpbb/trunk@5678 89ea8834-ac86-4346-8a33-228a782c2dd0
---
 phpBB/install/schemas/oracle_schema.sql | 5 ++---
 1 file changed, 2 insertions(+), 3 deletions(-)

(limited to 'phpBB/install/schemas/oracle_schema.sql')

diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql
index 25ffabbb32..a181532783 100644
--- a/phpBB/install/schemas/oracle_schema.sql
+++ b/phpBB/install/schemas/oracle_schema.sql
@@ -864,7 +864,6 @@ CREATE TABLE phpbb_privmsgs (
   message_text clob,
   message_edit_reason varchar2(100),
   message_edit_user number(8) DEFAULT '0' NOT NULL,
-  message_checksum varchar2(32) DEFAULT '',
   message_encoding varchar2(11) DEFAULT 'iso-8859-1',
   message_attachment number(1) DEFAULT '0' NOT NULL,
   bbcode_bitfield number(11) DEFAULT '0' NOT NULL,
@@ -1551,7 +1550,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 varchar2(255),
+  poll_title varchar2(255) DEFAULT '' NOT NULL,
   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,
@@ -1672,7 +1671,7 @@ CREATE TABLE phpbb_users (
   user_lang varchar2(30) DEFAULT '',
   user_timezone number(5, 2) DEFAULT '1' NOT NULL,
   user_dst number(1) DEFAULT '0' NOT NULL,
-  user_dateformat varchar2(15) DEFAULT 'd M Y H:i',
+  user_dateformat varchar2(30) DEFAULT 'd M Y H:i',
   user_style number(4) DEFAULT '0' NOT NULL,
   user_rank number(11) DEFAULT '0',
   user_colour varchar2(6) DEFAULT '',
-- 
cgit v1.2.1

