From 46af817cb058e2eecd89081af4a40075426a32ef Mon Sep 17 00:00:00 2001
From: Meik Sievertsen <acydburn@phpbb.com>
Date: Sun, 9 Jul 2006 16:23:57 +0000
Subject: - tackle some usability issues - fix bug #3147 - added the
 lock-images made by SHS` - fixed MSSQL errors (adding the correct ESCAPE
 sequence)

git-svn-id: file:///svn/phpbb/trunk@6161 89ea8834-ac86-4346-8a33-228a782c2dd0
---
 phpBB/install/schemas/mysql_schema.sql | 14 +++++++++++++-
 1 file changed, 13 insertions(+), 1 deletion(-)

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

diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql
index 7fa9194e81..acfc3a53b7 100644
--- a/phpBB/install/schemas/mysql_schema.sql
+++ b/phpBB/install/schemas/mysql_schema.sql
@@ -221,7 +221,7 @@ CREATE TABLE phpbb_forums (
   forum_last_poster_id mediumint(8) DEFAULT '0' NOT NULL,
   forum_last_post_time int(11) DEFAULT '0' NOT NULL,
   forum_last_poster_name varchar(255),
-  forum_flags tinyint(4) DEFAULT '0' NOT NULL,
+  forum_flags tinyint(4) DEFAULT '32' NOT NULL,
   display_on_index tinyint(1) DEFAULT '1' NOT NULL,
   enable_indexing tinyint(1) DEFAULT '1' NOT NULL,
   enable_icons tinyint(1) DEFAULT '1' NOT NULL,
@@ -753,6 +753,18 @@ CREATE TABLE phpbb_styles_imageset (
   folder_locked_posted varchar(200) DEFAULT '' NOT NULL,
   folder_locked_new varchar(200) DEFAULT '' NOT NULL,
   folder_locked_new_posted varchar(200) DEFAULT '' NOT NULL,
+  folder_locked_announce varchar(200) DEFAULT '' NOT NULL,
+  folder_locked_announce_new varchar(200) DEFAULT '' NOT NULL,
+  folder_locked_announce_posted varchar(200) DEFAULT '' NOT NULL,
+  folder_locked_announce_new_posted varchar(200) DEFAULT '' NOT NULL,
+  folder_locked_global varchar(200) DEFAULT '' NOT NULL,
+  folder_locked_global_new varchar(200) DEFAULT '' NOT NULL,
+  folder_locked_global_posted varchar(200) DEFAULT '' NOT NULL,
+  folder_locked_global_new_posted varchar(200) DEFAULT '' NOT NULL,
+  folder_locked_sticky varchar(200) DEFAULT '' NOT NULL,
+  folder_locked_sticky_new varchar(200) DEFAULT '' NOT NULL,
+  folder_locked_sticky_posted varchar(200) DEFAULT '' NOT NULL,
+  folder_locked_sticky_new_posted varchar(200) DEFAULT '' NOT NULL,
   folder_sticky varchar(200) DEFAULT '' NOT NULL,
   folder_sticky_posted varchar(200) DEFAULT '' NOT NULL,
   folder_sticky_new varchar(200) DEFAULT '' NOT NULL,
-- 
cgit v1.2.1

