[Phpbb-checkins] CVS: phpBB2/db/schemas mssql_schema.sql,1.17,1.18

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

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

Modified Files:
	mssql_schema.sql 
Log Message:
Updated themes_name field lengths to 50 as per other schemas

Index: mssql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mssql_schema.sql,v
retrieving revision 1.17
retrieving revision 1.18
diff -C2 -r1.17 -r1.18
*** mssql_schema.sql	2002/01/03 02:27:31	1.17
--- mssql_schema.sql	2002/01/28 01:37:50	1.18
***************
*** 244,277 ****
  CREATE TABLE [phpbb_themes_name] (
  	[themes_id] [int] NOT NULL ,
! 	[tr_color1_name] [varchar] (25) NULL ,
! 	[tr_color2_name] [varchar] (25) NULL ,
! 	[tr_color3_name] [varchar] (25) NULL ,
! 	[tr_class1_name] [varchar] (25) NULL ,
! 	[tr_class2_name] [varchar] (25) NULL ,
! 	[tr_class3_name] [varchar] (25) NULL ,
! 	[th_color1_name] [varchar] (25) NULL ,
! 	[th_color2_name] [varchar] (25) NULL ,
! 	[th_color3_name] [varchar] (25) NULL ,
! 	[th_class1_name] [varchar] (25) NULL ,
! 	[th_class2_name] [varchar] (25) NULL ,
! 	[th_class3_name] [varchar] (25) NULL ,
! 	[td_color1_name] [varchar] (25) NULL ,
! 	[td_color2_name] [varchar] (25) NULL ,
! 	[td_color3_name] [varchar] (25) NULL ,
! 	[td_class1_name] [varchar] (25) NULL ,
! 	[td_class2_name] [varchar] (25) NULL ,
! 	[td_class3_name] [varchar] (25) NULL ,
! 	[fontface1_name] [varchar] (25) NULL ,
! 	[fontface2_name] [varchar] (25) NULL ,
! 	[fontface3_name] [varchar] (25) NULL ,
! 	[fontsize1_name] [varchar] (25) NULL ,
! 	[fontsize2_name] [varchar] (25) NULL ,
! 	[fontsize3_name] [varchar] (25) NULL ,
! 	[fontcolor1_name] [varchar] (25) NULL ,
! 	[fontcolor2_name] [varchar] (25) NULL ,
! 	[fontcolor3_name] [varchar] (25) NULL ,
! 	[span_class1_name] [varchar] (25) NULL ,
! 	[span_class2_name] [varchar] (25) NULL ,
! 	[span_class3_name] [varchar] (25) NULL
  ) ON [PRIMARY]
  GO
--- 244,277 ----
  CREATE TABLE [phpbb_themes_name] (
  	[themes_id] [int] NOT NULL ,
! 	[tr_color1_name] [varchar] (50) NULL ,
! 	[tr_color2_name] [varchar] (50) NULL ,
! 	[tr_color3_name] [varchar] (50) NULL ,
! 	[tr_class1_name] [varchar] (50) NULL ,
! 	[tr_class2_name] [varchar] (50) NULL ,
! 	[tr_class3_name] [varchar] (50) NULL ,
! 	[th_color1_name] [varchar] (50) NULL ,
! 	[th_color2_name] [varchar] (50) NULL ,
! 	[th_color3_name] [varchar] (50) NULL ,
! 	[th_class1_name] [varchar] (50) NULL ,
! 	[th_class2_name] [varchar] (50) NULL ,
! 	[th_class3_name] [varchar] (50) NULL ,
! 	[td_color1_name] [varchar] (50) NULL ,
! 	[td_color2_name] [varchar] (50) NULL ,
! 	[td_color3_name] [varchar] (50) NULL ,
! 	[td_class1_name] [varchar] (50) NULL ,
! 	[td_class2_name] [varchar] (50) NULL ,
! 	[td_class3_name] [varchar] (50) NULL ,
! 	[fontface1_name] [varchar] (50) NULL ,
! 	[fontface2_name] [varchar] (50) NULL ,
! 	[fontface3_name] [varchar] (50) NULL ,
! 	[fontsize1_name] [varchar] (50) NULL ,
! 	[fontsize2_name] [varchar] (50) NULL ,
! 	[fontsize3_name] [varchar] (50) NULL ,
! 	[fontcolor1_name] [varchar] (50) NULL ,
! 	[fontcolor2_name] [varchar] (50) NULL ,
! 	[fontcolor3_name] [varchar] (50) NULL ,
! 	[span_class1_name] [varchar] (50) NULL ,
! 	[span_class2_name] [varchar] (50) NULL ,
! 	[span_class3_name] [varchar] (50) NULL
  ) ON [PRIMARY]
  GO
***************
*** 616,620 ****
  GO
  
!  CREATE  INDEX [IX_phpbb_ranks] ON [phpbb_ranks]([rank_min], [rank_max], [rank_special]) ON [PRIMARY]
  GO
  
--- 616,620 ----
  GO
  
!  CREATE  INDEX [IX_phpbb_ranks] ON [phpbb_ranks]([rank_min], [rank_special]) ON [PRIMARY]
  GO