[Planeshift-cvs] CVS: planeshift/src/server/database/mysql upgrade_schema.sql,1.29,1.30

[Luca P. <lpa...@us...>]

Update of /cvsroot/planeshift/planeshift/src/server/database/mysql
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv24408

Modified Files:
	upgrade_schema.sql 
Log Message:
fixed errors

Index: upgrade_schema.sql
===================================================================
RCS file: /cvsroot/planeshift/planeshift/src/server/database/mysql/upgrade_schema.sql,v
retrieving revision 1.29
retrieving revision 1.30
diff -C2 -d -r1.29 -r1.30
*** upgrade_schema.sql	22 Mar 2006 06:12:05 -0000	1.29
--- upgrade_schema.sql	22 Mar 2006 18:12:23 -0000	1.30
***************
*** 135,142 ****
  #from 1103 to 1104
  
! ALTER TABLE sectors ADD COLUMN rain_min_fade_in int(int) unsigned NOT NULL DEFAULT '0' AFTER rain_max_drops;
! ALTER TABLE sectors ADD COLUMN rain_max_fade_in int(int) unsigned NOT NULL DEFAULT '0' AFTER rain_max_fade_in;
! ALTER TABLE sectors ADD COLUMN rain_min_fade_out int(int) unsigned NOT NULL DEFAULT '0' AFTER rain_min_fade_out;
! ALTER TABLE sectors ADD COLUMN rain_max_fade_out int(int) unsigned NOT NULL DEFAULT '0' AFTER rain_max_fade_out;
  
  UPDATE server_options SET option_value=1104 where option_name='db_version';
--- 135,142 ----
  #from 1103 to 1104
  
! ALTER TABLE sectors ADD COLUMN rain_min_fade_in int(10) unsigned NOT NULL DEFAULT '0' AFTER rain_max_drops;
! ALTER TABLE sectors ADD COLUMN rain_max_fade_in int(10) unsigned NOT NULL DEFAULT '0' AFTER rain_min_fade_in;
! ALTER TABLE sectors ADD COLUMN rain_min_fade_out int(10) unsigned NOT NULL DEFAULT '0' AFTER rain_max_fade_in;
! ALTER TABLE sectors ADD COLUMN rain_max_fade_out int(10) unsigned NOT NULL DEFAULT '0' AFTER rain_min_fade_out;
  
  UPDATE server_options SET option_value=1104 where option_name='db_version';