diff options
Diffstat (limited to 'phpBB/db')
| -rw-r--r-- | phpBB/db/mssql_schema.sql | 6 | ||||
| -rw-r--r-- | phpBB/db/mysql_schema.sql | 1 | ||||
| -rw-r--r-- | phpBB/db/postgres_schema.sql | 3 |
3 files changed, 7 insertions, 3 deletions
diff --git a/phpBB/db/mssql_schema.sql b/phpBB/db/mssql_schema.sql index e0e4fdcb0d..8cc34abcdb 100644 --- a/phpBB/db/mssql_schema.sql +++ b/phpBB/db/mssql_schema.sql @@ -433,7 +433,8 @@ CREATE TABLE [phpbb_users] ( [user_notify_pm] [smallint] NOT NULL , [user_regdate] [int] NOT NULL , [user_rank] [int] NULL , - [user_avatar] [varchar] (100) NULL , + [user_avatar] [varchar] (100) NULL , + [user_avatar_type] [smallint] NOT NULL, [user_email] [varchar] (25) NULL , [user_icq] [varchar] (15) NULL , [user_website] [varchar] (50) NULL , @@ -652,7 +653,8 @@ ALTER TABLE [phpbb_users] WITH NOCHECK ADD CONSTRAINT [DF_phpbb_users_user_allow_pm] DEFAULT (1) FOR [user_allow_pm], CONSTRAINT [DF_phpbb_users_user_allow_viewonline] DEFAULT (1) FOR [user_allow_viewonline], CONSTRAINT [DF_phpbb_users_user_notify] DEFAULT (1) FOR [user_notify], - CONSTRAINT [DF_phpbb_users_user_notify_pm] DEFAULT (1) FOR [user_notify_pm] + CONSTRAINT [DF_phpbb_users_user_notify_pm] DEFAULT (1) FOR [user_notify_pm], + CONSTRAINT [DF_phpbb_users_user_avatar_type] DEFAULT (0) FOR [user_avatar_type] GO CREATE INDEX [IX_phpbb_auth_access] ON [phpbb_auth_access]([group_id], [forum_id]) ON [PRIMARY] diff --git a/phpBB/db/mysql_schema.sql b/phpBB/db/mysql_schema.sql index 6cba16d5d0..9efe409650 100644 --- a/phpBB/db/mysql_schema.sql +++ b/phpBB/db/mysql_schema.sql @@ -471,6 +471,7 @@ CREATE TABLE phpbb_users ( user_regdate int(11) DEFAULT '0' NOT NULL, user_rank int(11) DEFAULT '0', user_avatar varchar(100), + user_avatar_type tinyint(4) DEFAULT '0' NOT NULL, user_email varchar(255), user_icq varchar(15), user_website varchar(100), diff --git a/phpBB/db/postgres_schema.sql b/phpBB/db/postgres_schema.sql index 17e5237494..f91f01d1c7 100644 --- a/phpBB/db/postgres_schema.sql +++ b/phpBB/db/postgres_schema.sql @@ -448,7 +448,8 @@ CREATE TABLE phpbb_users ( user_allowavatar int2 DEFAULT '1' NOT NULL, user_allow_viewonline int2 DEFAULT '1' NOT NULL, user_rank int4 DEFAULT '0', - user_avatar varchar(100), + user_avatar varchar(100), + user_avatar_type int2 DEFAULT '0' NOT NULL, user_level int4 DEFAULT '1', user_lang varchar(255), user_timezone int4 DEFAULT '0' NOT NULL, |