diff options
Diffstat (limited to 'phpBB/install')
| -rw-r--r-- | phpBB/install/schemas/firebird_schema.sql | 1 | ||||
| -rw-r--r-- | phpBB/install/schemas/mssql_schema.sql | 5 | ||||
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 1 | ||||
| -rw-r--r-- | phpBB/install/schemas/oracle_schema.sql | 1 | ||||
| -rw-r--r-- | phpBB/install/schemas/postgres_schema.sql | 3 | ||||
| -rw-r--r-- | phpBB/install/schemas/sqlite_schema.sql | 1 |
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', |
