[Phpbb-checkins] CVS: phpBB2/db/schemas mssql_schema.sql,1.24,1.24.2.1 mysql_schema.sql,1.17,1.17.2.1 postgres_schema.sql,1.19,1.19.2.1

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

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

Modified Files:
      Tag: phpBB-2_0_0
	mssql_schema.sql mysql_schema.sql postgres_schema.sql 
Log Message:
Change user_timezone type to decimal

Index: mssql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mssql_schema.sql,v
retrieving revision 1.24
retrieving revision 1.24.2.1
diff -C2 -r1.24 -r1.24.2.1
*** mssql_schema.sql	21 Mar 2002 13:59:33 -0000	1.24
--- mssql_schema.sql	8 Apr 2002 00:17:41 -0000	1.24.2.1
***************
*** 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 ,
--- 319,323 ----
  	[user_level] [smallint] NOT NULL ,
  	[user_posts] [int] NOT NULL ,
! 	[user_timezone] [decimal] (4,2) 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.17
retrieving revision 1.17.2.1
diff -C2 -r1.17 -r1.17.2.1
*** mysql_schema.sql	21 Mar 2002 13:59:33 -0000	1.17
--- mysql_schema.sql	8 Apr 2002 00:17:41 -0000	1.17.2.1
***************
*** 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),
--- 464,468 ----
     user_level tinyint(4) DEFAULT '0',
     user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
!    user_timezone decimal(4,2) 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.19
retrieving revision 1.19.2.1
diff -C2 -r1.19 -r1.19.2.1
*** postgres_schema.sql	21 Mar 2002 13:59:33 -0000	1.19
--- postgres_schema.sql	8 Apr 2002 00:17:41 -0000	1.19.2.1
***************
*** 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,
--- 479,483 ----
     user_level int4 DEFAULT '1',
     user_lang varchar(255),
!    user_timezone decimal(4) DEFAULT '0' NOT NULL,
     user_dateformat varchar(14) DEFAULT 'd M Y H:m' NOT NULL,
     user_notify_pm int2 DEFAULT '1' NOT NULL,