aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install
diff options
context:
space:
mode:
Diffstat (limited to 'phpBB/install')
-rw-r--r--phpBB/install/schemas/firebird_schema.sql1
-rw-r--r--phpBB/install/schemas/mssql_schema.sql5
-rw-r--r--phpBB/install/schemas/mysql_schema.sql1
-rw-r--r--phpBB/install/schemas/oracle_schema.sql1
-rw-r--r--phpBB/install/schemas/postgres_schema.sql3
-rw-r--r--phpBB/install/schemas/sqlite_schema.sql1
6 files changed, 11 insertions, 1 deletions
diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql
index 74e5dbef8f..04e86d0035 100644
--- a/phpBB/install/schemas/firebird_schema.sql
+++ b/phpBB/install/schemas/firebird_schema.sql
@@ -284,6 +284,7 @@ CREATE TABLE phpbb_moderator_cache (
CREATE TABLE phpbb_modules (
module_id INTEGER NOT NULL,
module_enabled INTEGER DEFAULT 1 NOT NULL,
+ module_display INTEGER DEFAULT 1 NOT NULL,
module_name VARCHAR(20) NOT NULL,
module_class VARCHAR(4) NOT NULL,
parent_id INTEGER NOT NULL,
diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql
index 74a8b3be0c..6308ddb60a 100644
--- a/phpBB/install/schemas/mssql_schema.sql
+++ b/phpBB/install/schemas/mssql_schema.sql
@@ -289,6 +289,7 @@ GO
CREATE TABLE [phpbb_modules] (
[module_id] [int] IDENTITY (1, 1) NOT NULL ,
[module_enabled] [int] NOT NULL ,
+ [module_display] [int] NOT NULL ,
[module_name] [varchar] (20) NOT NULL ,
[module_class] [varchar] (4) NOT NULL ,
[parent_id] [int] NOT NULL ,
@@ -1343,6 +1344,10 @@ ALTER TABLE [phpbb_modules] WITH NOCHECK ADD
CONSTRAINT [DF_module_module_enabled] DEFAULT (1) FOR [module_enabled]
GO
+ALTER TABLE [phpbb_modules] WITH NOCHECK ADD
+ CONSTRAINT [DF_module_module_display] DEFAULT (1) FOR [module_display]
+GO
+
ALTER TABLE [phpbb_poll_results] WITH NOCHECK ADD
CONSTRAINT [DF_poll_r_poll_option_id] DEFAULT (0) FOR [poll_option_id],
CONSTRAINT [DF_poll_r_topic_id] DEFAULT (0) FOR [topic_id],
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql
index f7e5fea293..fa8702dbf7 100644
--- a/phpBB/install/schemas/mysql_schema.sql
+++ b/phpBB/install/schemas/mysql_schema.sql
@@ -334,6 +334,7 @@ CREATE TABLE phpbb_moderator_cache (
CREATE TABLE phpbb_modules (
module_id smallint(5) unsigned NOT NULL auto_increment,
module_enabled tinyint(1) NOT NULL default '1',
+ module_display tinyint(1) NOT NULL default '1',
module_name varchar(20) NOT NULL default '',
module_class varchar(4) NOT NULL default '',
parent_id smallint(5) unsigned NOT NULL default '0',
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql
index 5b9f14baea..2e281a3d65 100644
--- a/phpBB/install/schemas/oracle_schema.sql
+++ b/phpBB/install/schemas/oracle_schema.sql
@@ -700,6 +700,7 @@ CREATE INDEX forum_id03 on phpbb_moderator_cache (forum_id)
CREATE TABLE phpbb_modules (
module_id number(8) NOT NULL,
module_enabled number(1) DEFAULT '1' NOT NULL,
+ module_display number(1) DEFAULT '1' NOT NULL,
module_name varchar2(20) DEFAULT '' NOT NULL,
module_class varchar2(4) DEFAULT '' NOT NULL,
parent_id number(5) DEFAULT '0' NOT NULL,
diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql
index 805001e2fc..7dc0e2bbd6 100644
--- a/phpBB/install/schemas/postgres_schema.sql
+++ b/phpBB/install/schemas/postgres_schema.sql
@@ -457,7 +457,8 @@ CREATE SEQUENCE phpbb_modules_module_id_seq;
CREATE TABLE phpbb_modules (
module_id INT4 DEFAULT nextval('phpbb_modules_module_id_seq'),
- module_enabled INT2 DEFAULT '1' NOT NULL,
+ module_enabled INT2 DEFAULT '1' NOT NULL,
+ module_display INT2 DEFAULT '1' NOT NULL,
module_name varchar(20) DEFAULT '' NOT NULL,
module_class varchar(4) DEFAULT '' NOT NULL,
parent_id INT4 DEFAULT '0' NOT NULL,
diff --git a/phpBB/install/schemas/sqlite_schema.sql b/phpBB/install/schemas/sqlite_schema.sql
index 320d86d8f3..128605bcc9 100644
--- a/phpBB/install/schemas/sqlite_schema.sql
+++ b/phpBB/install/schemas/sqlite_schema.sql
@@ -335,6 +335,7 @@ CREATE INDEX forum_id_phpbb_moderator_cache on phpbb_moderator_cache (forum_id);
CREATE TABLE phpbb_modules (
module_id INTEGER PRIMARY KEY NOT NULL,
module_enabled tinyint(1) NOT NULL DEFAULT '1',
+ module_display tinyint(1) NOT NULL DEFAULT '1',
module_name varchar(20) NOT NULL DEFAULT '',
module_class varchar(4) NOT NULL DEFAULT '',
parent_id smallint(5) NOT NULL DEFAULT '0',