diff options
Diffstat (limited to 'phpBB/install')
-rw-r--r-- | phpBB/install/schemas/firebird_schema.sql | 2 | ||||
-rw-r--r-- | phpBB/install/schemas/mssql_schema.sql | 2 | ||||
-rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 2 | ||||
-rw-r--r-- | phpBB/install/schemas/oracle_schema.sql | 2 | ||||
-rw-r--r-- | phpBB/install/schemas/postgres_schema.sql | 2 | ||||
-rw-r--r-- | phpBB/install/schemas/sqlite_schema.sql | 2 |
6 files changed, 6 insertions, 6 deletions
diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql index 93c0340fc7..b2dd3aa0f2 100644 --- a/phpBB/install/schemas/firebird_schema.sql +++ b/phpBB/install/schemas/firebird_schema.sql @@ -1331,7 +1331,7 @@ CREATE TABLE phpbb_users ( user_lastpost_time INTEGER DEFAULT 0 NOT NULL, user_lastpage VARCHAR(200) DEFAULT '' NOT NULL, user_last_confirm_key VARCHAR(10) DEFAULT '', - user_last_search INTEGER DEFAULT 0 NOT NULL, + user_last_search INTEGER DEFAULT 0, user_warnings INTEGER DEFAULT 0, user_last_warning INTEGER DEFAULT 0, user_login_attempts INTEGER DEFAULT 0, diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql index 2756815c97..a5406b51c0 100644 --- a/phpBB/install/schemas/mssql_schema.sql +++ b/phpBB/install/schemas/mssql_schema.sql @@ -2128,7 +2128,7 @@ CREATE TABLE [phpbb_users] ( [user_lastpost_time] [int] NOT NULL , [user_lastpage] [varchar] (200) NOT NULL , [user_last_confirm_key] [varchar] (10) NULL , - [user_last_search] [int] NOT NULL , + [user_last_search] [int] NULL , [user_warnings] [int] NULL , [user_last_warning] [int] NULL , [user_login_attempts] [int] NULL , diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index bd00968c39..8d7318e682 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -887,8 +887,8 @@ CREATE TABLE phpbb_users ( user_lastmark int(11) DEFAULT '0' NOT NULL, user_lastpost_time int(11) DEFAULT '0' NOT NULL, user_lastpage varchar(200) DEFAULT '' NOT NULL, - user_last_search int(11) DEFAULT '0' NOT NULL, user_last_confirm_key varchar(10) DEFAULT '' NULL, + user_last_search int(11) DEFAULT '0' NULL, user_warnings tinyint(4) DEFAULT '0' NULL, user_last_warning int(11) DEFAULT '0' NULL, user_login_attempts smallint(4) DEFAULT '0' NULL, diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql index b58407fd82..2a41231626 100644 --- a/phpBB/install/schemas/oracle_schema.sql +++ b/phpBB/install/schemas/oracle_schema.sql @@ -1729,7 +1729,7 @@ CREATE TABLE phpbb_users ( user_lastpost_time number(11) DEFAULT '0' NOT NULL, user_lastpage varchar2(200) DEFAULT '' NOT NULL, user_last_confirm_key varchar2(10) DEFAULT '' NULL, - user_last_search number(11) DEFAULT '0' NOT NULL, + user_last_search number(11) DEFAULT '0' NULL, user_warnings number(4) DEFAULT '0' NULL, user_last_warning number(11) DEFAULT '0' NULL, user_login_attempts number(4) DEFAULT '0' NULL, diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql index 9b3b3f20b5..e0157b7efd 100644 --- a/phpBB/install/schemas/postgres_schema.sql +++ b/phpBB/install/schemas/postgres_schema.sql @@ -1305,7 +1305,7 @@ CREATE TABLE phpbb_users ( user_lastpost_time INT4 DEFAULT '0' NOT NULL, user_lastpage varchar(200) DEFAULT '' NOT NULL, user_last_confirm_key varchar(10) DEFAULT '' NULL, - user_last_search INT4 DEFAULT '0' NOT NULL, + user_last_search INT4 DEFAULT '0' NULL, user_warnings INT2 DEFAULT '0' NULL, user_last_warning INT4 DEFAULT '0' NULL, user_login_attempts INT2 DEFAULT '0' NULL, diff --git a/phpBB/install/schemas/sqlite_schema.sql b/phpBB/install/schemas/sqlite_schema.sql index 3bf6ac0c36..5cba79713f 100644 --- a/phpBB/install/schemas/sqlite_schema.sql +++ b/phpBB/install/schemas/sqlite_schema.sql @@ -950,7 +950,7 @@ CREATE TABLE phpbb_users ( user_lastpost_time int(11) NOT NULL DEFAULT '0', user_lastpage varchar(200) NOT NULL DEFAULT '', user_last_confirm_key varchar(10) NULL DEFAULT '', - user_last_search int(11) NOT NULL DEFAULT '0', + user_last_search int(11) NULL DEFAULT '0', user_warnings tinyint(4) NULL DEFAULT '0', user_last_warning int(11) NULL DEFAULT '0', user_login_attempts smallint(4) NULL DEFAULT '0', |