[Phpbb-checkins] CVS: phpBB2/db/schemas mssql_schema.sql,1.23,1.24 mysql_schema.sql,1.16,1.17 postgres_schema.sql,1.18,1.19

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

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

Modified Files:
	mssql_schema.sql mysql_schema.sql postgres_schema.sql 
Log Message:
Re-fix schemas to allow decimal/real numbers in timezone ...

Index: mssql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mssql_schema.sql,v
retrieving revision 1.23
retrieving revision 1.24
diff -C2 -r1.23 -r1.24
*** mssql_schema.sql	19 Mar 2002 22:00:17 -0000	1.23
--- mssql_schema.sql	21 Mar 2002 13:59:33 -0000	1.24
***************
*** 319,323 ****
  	[user_level] [smallint] NOT NULL ,
  	[user_posts] [int] NOT NULL ,
! 	[user_timezone] [smallint] NOT NULL ,
  	[user_style] [int] NULL ,
  	[user_lang] [varchar] (255) NULL ,
--- 319,323 ----
  	[user_level] [smallint] NOT NULL ,
  	[user_posts] [int] NOT NULL ,
! 	[user_timezone] [real] NOT NULL ,
  	[user_style] [int] NULL ,
  	[user_lang] [varchar] (255) NULL ,

Index: mysql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mysql_schema.sql,v
retrieving revision 1.16
retrieving revision 1.17
diff -C2 -r1.16 -r1.17
*** mysql_schema.sql	11 Feb 2002 13:11:36 -0000	1.16
--- mysql_schema.sql	21 Mar 2002 13:59:33 -0000	1.17
***************
*** 464,468 ****
     user_level tinyint(4) DEFAULT '0',
     user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
!    user_timezone tinyint(4) DEFAULT '0' NOT NULL,
     user_style tinyint(4),
     user_lang varchar(255),
--- 464,468 ----
     user_level tinyint(4) DEFAULT '0',
     user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
!    user_timezone float DEFAULT '0' NOT NULL,
     user_style tinyint(4),
     user_lang varchar(255),

Index: postgres_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/postgres_schema.sql,v
retrieving revision 1.18
retrieving revision 1.19
diff -C2 -r1.18 -r1.19
*** postgres_schema.sql	11 Feb 2002 13:11:36 -0000	1.18
--- postgres_schema.sql	21 Mar 2002 13:59:33 -0000	1.19
***************
*** 479,483 ****
     user_level int4 DEFAULT '1',
     user_lang varchar(255),
!    user_timezone int4 DEFAULT '0' NOT NULL,
     user_dateformat varchar(14) DEFAULT 'd M Y H:m' NOT NULL,
     user_notify_pm int2 DEFAULT '1' NOT NULL,
--- 479,483 ----
     user_level int4 DEFAULT '1',
     user_lang varchar(255),
!    user_timezone real DEFAULT '0' NOT NULL,
     user_dateformat varchar(14) DEFAULT 'd M Y H:m' NOT NULL,
     user_notify_pm int2 DEFAULT '1' NOT NULL,