[Phpbb-checkins] CVS: phpBB2/db mssql_schema.sql,1.17,1.18 mysql_schema.sql,1.81,1.82 postgres_schema.sql,1.54,1.55

[Paul S. O. <ps...@us...>]

Update of /cvsroot/phpbb/phpBB2/db
In directory usw-pr-cvs1:/tmp/cvs-serv7342/db

Modified Files:
	mssql_schema.sql mysql_schema.sql postgres_schema.sql 
Log Message:
Preliminary avatar gallery support

Index: mssql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/mssql_schema.sql,v
retrieving revision 1.17
retrieving revision 1.18
diff -C2 -r1.17 -r1.18
*** mssql_schema.sql	2001/10/01 23:22:18	1.17
--- mssql_schema.sql	2001/10/11 22:01:11	1.18
***************
*** 434,438 ****
  	[user_regdate] [int] NOT NULL ,
  	[user_rank] [int] NULL ,
! 	[user_avatar] [varchar] (100) NULL ,
  	[user_email] [varchar] (25) NULL ,
  	[user_icq] [varchar] (15) NULL ,
--- 434,439 ----
  	[user_regdate] [int] NOT NULL ,
  	[user_rank] [int] NULL ,
! 	[user_avatar] [varchar] (100) NULL , 
! 	[user_avatar_type] [smallint] NOT NULL, 
  	[user_email] [varchar] (25) NULL ,
  	[user_icq] [varchar] (15) NULL ,
***************
*** 653,657 ****
  	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]
  GO
  
--- 654,659 ----
  	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_avatar_type] DEFAULT (0) FOR [user_avatar_type]
  GO
  

Index: mysql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/mysql_schema.sql,v
retrieving revision 1.81
retrieving revision 1.82
diff -C2 -r1.81 -r1.82
*** mysql_schema.sql	2001/10/04 23:56:03	1.81
--- mysql_schema.sql	2001/10/11 22:01:11	1.82
***************
*** 472,475 ****
--- 472,476 ----
     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),

Index: postgres_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/postgres_schema.sql,v
retrieving revision 1.54
retrieving revision 1.55
diff -C2 -r1.54 -r1.55
*** postgres_schema.sql	2001/10/01 23:22:18	1.54
--- postgres_schema.sql	2001/10/11 22:01:11	1.55
***************
*** 449,453 ****
     user_allow_viewonline int2 DEFAULT '1' NOT NULL,
     user_rank int4 DEFAULT '0',
!    user_avatar varchar(100),
     user_level int4 DEFAULT '1',
     user_lang varchar(255),
--- 449,454 ----
     user_allow_viewonline int2 DEFAULT '1' NOT NULL,
     user_rank int4 DEFAULT '0',
!    user_avatar varchar(100), 
!    user_avatar_type int2 DEFAULT '0' NOT NULL, 
     user_level int4 DEFAULT '1',
     user_lang varchar(255),