aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas
diff options
context:
space:
mode:
authorDavid M <davidmj@users.sourceforge.net>2006-07-17 03:23:31 +0000
committerDavid M <davidmj@users.sourceforge.net>2006-07-17 03:23:31 +0000
commitfa205b922dcfa09bab26b6cf9d406d2afe1a0518 (patch)
treeb442ec1e2e368bdf2476028e7b4de82ad83e5a97 /phpBB/install/schemas
parent29d92430c5e364d63a5ec7db96d306cdf1c02e72 (diff)
downloadforums-fa205b922dcfa09bab26b6cf9d406d2afe1a0518.tar
forums-fa205b922dcfa09bab26b6cf9d406d2afe1a0518.tar.gz
forums-fa205b922dcfa09bab26b6cf9d406d2afe1a0518.tar.bz2
forums-fa205b922dcfa09bab26b6cf9d406d2afe1a0518.tar.xz
forums-fa205b922dcfa09bab26b6cf9d406d2afe1a0518.zip
hmm... This commit does not increase the number of BBCodes. However, this does other things that we need to do first. This splits the usage of allow_* from the BBCode bitfield in forum descriptions, forum rules and group descriptions. This also fixes a tiny, tiny severe issue that nobody found :D I hope it works :P
git-svn-id: file:///svn/phpbb/trunk@6188 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas')
-rw-r--r--phpBB/install/schemas/firebird_schema.sql3
-rw-r--r--phpBB/install/schemas/mssql_schema.sql3
-rw-r--r--phpBB/install/schemas/mysql_schema.sql3
-rw-r--r--phpBB/install/schemas/oracle_schema.sql3
-rw-r--r--phpBB/install/schemas/sqlite_schema.sql3
5 files changed, 15 insertions, 0 deletions
diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql
index d421482310..0c8d0af6e1 100644
--- a/phpBB/install/schemas/firebird_schema.sql
+++ b/phpBB/install/schemas/firebird_schema.sql
@@ -329,6 +329,7 @@ CREATE TABLE phpbb_forums (
forum_name BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
forum_desc BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
forum_desc_bitfield INTEGER DEFAULT 0 NOT NULL,
+ forum_desc_options INTEGER DEFAULT 0 NOT NULL,
forum_desc_uid VARCHAR(5) DEFAULT '' NOT NULL,
forum_link VARCHAR(255) DEFAULT '' NOT NULL,
forum_password VARCHAR(40) DEFAULT '' NOT NULL,
@@ -337,6 +338,7 @@ CREATE TABLE phpbb_forums (
forum_rules BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
forum_rules_link VARCHAR(255) DEFAULT '' NOT NULL,
forum_rules_bitfield INTEGER DEFAULT 0 NOT NULL,
+ forum_rules_options INTEGER DEFAULT 0 NOT NULL,
forum_rules_uid VARCHAR(5) DEFAULT '' NOT NULL,
forum_topics_per_page INTEGER DEFAULT 0 NOT NULL,
forum_type INTEGER DEFAULT 0 NOT NULL,
@@ -413,6 +415,7 @@ CREATE TABLE phpbb_groups (
group_name VARCHAR(255) DEFAULT '' NOT NULL,
group_desc BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
group_desc_bitfield INTEGER DEFAULT 0 NOT NULL,
+ group_desc_options INTEGER DEFAULT 0 NOT NULL,
group_desc_uid VARCHAR(5) DEFAULT '' NOT NULL,
group_display INTEGER DEFAULT 0 NOT NULL,
group_avatar VARCHAR(255) DEFAULT '' NOT NULL,
diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql
index dd3e0ab6b4..01dc57fcf6 100644
--- a/phpBB/install/schemas/mssql_schema.sql
+++ b/phpBB/install/schemas/mssql_schema.sql
@@ -353,6 +353,7 @@ CREATE TABLE [phpbb_forums] (
[forum_name] [varchar] (3000) DEFAULT ('') NOT NULL ,
[forum_desc] [varchar] (8000) DEFAULT ('') NOT NULL ,
[forum_desc_bitfield] [int] DEFAULT (0) NOT NULL ,
+ [forum_desc_options] [int] DEFAULT (0) NOT NULL ,
[forum_desc_uid] [varchar] (5) DEFAULT ('') NOT NULL ,
[forum_link] [varchar] (255) DEFAULT ('') NOT NULL ,
[forum_password] [varchar] (40) DEFAULT ('') NOT NULL ,
@@ -361,6 +362,7 @@ CREATE TABLE [phpbb_forums] (
[forum_rules] [varchar] (8000) DEFAULT ('') NOT NULL ,
[forum_rules_link] [varchar] (255) DEFAULT ('') NOT NULL ,
[forum_rules_bitfield] [int] DEFAULT (0) NOT NULL ,
+ [forum_rules_options] [int] DEFAULT (0) NOT NULL ,
[forum_rules_uid] [varchar] (5) DEFAULT ('') NOT NULL ,
[forum_topics_per_page] [int] DEFAULT (0) NOT NULL ,
[forum_type] [int] DEFAULT (0) NOT NULL ,
@@ -458,6 +460,7 @@ CREATE TABLE [phpbb_groups] (
[group_name] [varchar] (255) DEFAULT ('') NOT NULL ,
[group_desc] [varchar] (8000) DEFAULT ('') NOT NULL ,
[group_desc_bitfield] [int] DEFAULT (0) NOT NULL ,
+ [group_desc_options] [int] DEFAULT (0) NOT NULL ,
[group_desc_uid] [varchar] (5) DEFAULT ('') NOT NULL ,
[group_display] [int] DEFAULT (0) NOT NULL ,
[group_avatar] [varchar] (255) DEFAULT ('') NOT NULL ,
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql
index d4ab54a9b5..0cd3bd1c92 100644
--- a/phpBB/install/schemas/mysql_schema.sql
+++ b/phpBB/install/schemas/mysql_schema.sql
@@ -217,6 +217,7 @@ CREATE TABLE phpbb_forums (
forum_name text DEFAULT '' NOT NULL,
forum_desc text DEFAULT '' NOT NULL,
forum_desc_bitfield int(11) UNSIGNED DEFAULT '0' NOT NULL,
+ forum_desc_options int(11) UNSIGNED DEFAULT '0' NOT NULL,
forum_desc_uid varchar(5) DEFAULT '' NOT NULL,
forum_link varchar(255) DEFAULT '' NOT NULL,
forum_password varchar(40) DEFAULT '' NOT NULL,
@@ -225,6 +226,7 @@ CREATE TABLE phpbb_forums (
forum_rules text DEFAULT '' NOT NULL,
forum_rules_link varchar(255) DEFAULT '' NOT NULL,
forum_rules_bitfield int(11) UNSIGNED DEFAULT '0' NOT NULL,
+ forum_rules_options int(11) UNSIGNED DEFAULT '0' NOT NULL,
forum_rules_uid varchar(5) DEFAULT '' NOT NULL,
forum_topics_per_page tinyint(4) DEFAULT '0' NOT NULL,
forum_type tinyint(4) DEFAULT '0' NOT NULL,
@@ -287,6 +289,7 @@ CREATE TABLE phpbb_groups (
group_name varchar(255) DEFAULT '' NOT NULL,
group_desc text DEFAULT '' NOT NULL,
group_desc_bitfield int(11) UNSIGNED DEFAULT '0' NOT NULL,
+ group_desc_options int(11) UNSIGNED DEFAULT '0' NOT NULL,
group_desc_uid varchar(5) DEFAULT '' NOT NULL,
group_display tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
group_avatar varchar(255) DEFAULT '' NOT NULL,
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql
index 2ac992ed0c..2fdd4ed96d 100644
--- a/phpBB/install/schemas/oracle_schema.sql
+++ b/phpBB/install/schemas/oracle_schema.sql
@@ -433,6 +433,7 @@ CREATE TABLE phpbb_forums (
forum_name varchar2(3000) DEFAULT '' NOT NULL,
forum_desc clob DEFAULT '' NOT NULL,
forum_desc_bitfield number(11) DEFAULT '0' NOT NULL,
+ forum_desc_options number(1) DEFAULT '0' NOT NULL,
forum_desc_uid varchar2(5) DEFAULT '' NOT NULL,
forum_link varchar2(255) DEFAULT '' NOT NULL,
forum_password varchar2(40) DEFAULT '' NOT NULL,
@@ -441,6 +442,7 @@ CREATE TABLE phpbb_forums (
forum_rules clob DEFAULT '' NOT NULL,
forum_rules_link varchar2(255) DEFAULT '' NOT NULL,
forum_rules_bitfield number(11) DEFAULT '0' NOT NULL,
+ forum_rules_options number(1) DEFAULT '0' NOT NULL,
forum_rules_uid varchar2(5) DEFAULT '' NOT NULL,
forum_topics_per_page number(4) DEFAULT '0' NOT NULL,
forum_type number(4) DEFAULT '0' NOT NULL,
@@ -528,6 +530,7 @@ CREATE TABLE phpbb_groups (
group_name varchar2(255) DEFAULT '' NOT NULL,
group_desc clob DEFAULT '' NOT NULL,
group_desc_bitfield number(11) DEFAULT '0' NOT NULL,
+ group_desc_options number(1) DEFAULT '0' NOT NULL,
group_desc_uid varchar2(5) DEFAULT '' NOT NULL,
group_display number(1) DEFAULT '0' NOT NULL,
group_avatar varchar2(255) DEFAULT '' NOT NULL,
diff --git a/phpBB/install/schemas/sqlite_schema.sql b/phpBB/install/schemas/sqlite_schema.sql
index f77a0cca16..a2b2202337 100644
--- a/phpBB/install/schemas/sqlite_schema.sql
+++ b/phpBB/install/schemas/sqlite_schema.sql
@@ -206,6 +206,7 @@ CREATE TABLE phpbb_forums (
forum_name text(65535) NOT NULL DEFAULT '',
forum_desc text(65535) NOT NULL DEFAULT '',
forum_desc_bitfield int(11) UNSIGNED NOT NULL DEFAULT '0',
+ forum_desc_options tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
forum_desc_uid varchar(5) NOT NULL DEFAULT '',
forum_link varchar(255) NOT NULL DEFAULT '',
forum_password varchar(40) NOT NULL DEFAULT '',
@@ -214,6 +215,7 @@ CREATE TABLE phpbb_forums (
forum_rules text(65535) NOT NULL DEFAULT '',
forum_rules_link varchar(255) NOT NULL DEFAULT '',
forum_rules_bitfield int(11) UNSIGNED NOT NULL DEFAULT '0',
+ forum_rules_options tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
forum_rules_uid varchar(5) NOT NULL DEFAULT '',
forum_topics_per_page tinyint(4) NOT NULL DEFAULT '0',
forum_type tinyint(4) NOT NULL DEFAULT '0',
@@ -273,6 +275,7 @@ CREATE TABLE phpbb_groups (
group_name varchar(255) NOT NULL DEFAULT '',
group_desc text(65535) NOT NULL DEFAULT '',
group_desc_bitfield int(11) UNSIGNED NOT NULL DEFAULT '0',
+ group_desc_options tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
group_desc_uid varchar(5) NOT NULL DEFAULT '',
group_display tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
group_avatar varchar(255) NOT NULL DEFAULT '',
generated by cgit v1.2.1 (git 2.21.0) at 2026-02-06 21:19:03 +0000