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

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

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

Modified Files:
	upgrade_schema.sql 
Log Message:
accounts.status column is needed for web registration

Index: upgrade_schema.sql
===================================================================
RCS file: /cvsroot/planeshift/planeshift/src/server/database/mysql/upgrade_schema.sql,v
retrieving revision 1.20
retrieving revision 1.21
diff -C2 -d -r1.20 -r1.21
*** upgrade_schema.sql	22 Jan 2006 16:48:35 -0000	1.20
--- upgrade_schema.sql	25 Jan 2006 06:53:09 -0000	1.21
***************
*** 78,82 ****
  SOURCE bans.sql;
  
- ALTER TABLE accounts DROP COLUMN status;
  ALTER TABLE accounts DROP COLUMN banned_until;
  ALTER TABLE accounts ADD COLUMN last_login_hostname varchar(255) default NULL AFTER last_login_ip;
--- 78,81 ----
***************
*** 84,87 ****
--- 83,88 ----
  UPDATE server_options SET option_value=1098 where option_name='db_version';
  
+ #from 1098 to 1099
+ 
  ALTER TABLE item_stats MODIFY COLUMN id bigint(20);
  ALTER TABLE hunt_locations MODIFY COLUMN itemid bigint(20);