[Planeshift-cvs] CVS: planeshift/src/server/database/mysql create_all.sql,1.42,1.43 npc_spawn_rules.sql,1.4,1.5 server_options.sql,1.80,1.81

[Keith F. <ven...@us...>]

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

Modified Files:
	create_all.sql npc_spawn_rules.sql server_options.sql 
Log Message:
Added human-readable name columns to npc_spawn_rules.
Incremented server db version number.

Index: create_all.sql
===================================================================
RCS file: /cvsroot/planeshift/planeshift/src/server/database/mysql/create_all.sql,v
retrieving revision 1.42
retrieving revision 1.43
diff -C2 -d -r1.42 -r1.43
*** create_all.sql	6 Mar 2005 22:24:39 -0000	1.42
--- create_all.sql	22 Mar 2005 07:07:25 -0000	1.43
***************
*** 22,26 ****
  source item_stats.sql;
  source item_animations.sql;
! source loot_categories.sql;
  source merchant_item_cats.sql;
  source migration.sql;
--- 22,27 ----
  source item_stats.sql;
  source item_animations.sql;
! source loot_rules.sql;
! source loot_rule_details.sql;
  source merchant_item_cats.sql;
  source migration.sql;

Index: npc_spawn_rules.sql
===================================================================
RCS file: /cvsroot/planeshift/planeshift/src/server/database/mysql/npc_spawn_rules.sql,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** npc_spawn_rules.sql	29 Oct 2004 13:12:25 -0000	1.4
--- npc_spawn_rules.sql	22 Mar 2005 07:07:25 -0000	1.5
***************
*** 3,7 ****
  # Host: localhost Database: planeshift
  #--------------------------------------------------------
! # Server version 3.23.52-max-nt
  #
  # Table structure for table 'npc_spawn_rules'
--- 3,7 ----
  # Host: localhost Database: planeshift
  #--------------------------------------------------------
! # Server version 4.0.18-max-nt
  #
  # Table structure for table 'npc_spawn_rules'
***************
*** 21,24 ****
--- 21,25 ----
    loot_category_id int(10) unsigned NOT NULL DEFAULT '0' ,
    dead_remain_time int(10) unsigned NOT NULL DEFAULT '0' ,
+   name varchar(40) ,
    PRIMARY KEY (id)
  );
***************
*** 29,33 ****
  #
  
! INSERT INTO npc_spawn_rules VALUES("1","10000","20000","0.0000","0","0.00","0.00","0.00","0.0000","startlocation","1","30000");
! INSERT INTO npc_spawn_rules VALUES("100","10000","20000","0.0000","0","10.00","0.00","-110.00","0.0000","NPCroom","1","30000");
! INSERT INTO npc_spawn_rules VALUES("999","25000","60000","0.0000","0","-4.50","-1.10","-4.00","4.5500","hydlaa_plaza","0","0");
--- 30,34 ----
  #
  
! INSERT INTO npc_spawn_rules VALUES("1","10000","20000","0.0000","0","0.00","0.00","0.00","0.0000","startlocation","1","30000","Respawn at Orig Location");
! INSERT INTO npc_spawn_rules VALUES("100","10000","20000","0.0000","0","10.00","0.00","-110.00","0.0000","NPCroom","1","30000","Anywhere in npcroom forest-quick");
! INSERT INTO npc_spawn_rules VALUES("999","25000","60000","0.0000","0","-4.50","-1.10","-4.00","4.5500","hydlaa_plaza","0","0","Test Hydlaa Plaza");

Index: server_options.sql
===================================================================
RCS file: /cvsroot/planeshift/planeshift/src/server/database/mysql/server_options.sql,v
retrieving revision 1.80
retrieving revision 1.81
diff -C2 -d -r1.80 -r1.81
*** server_options.sql	13 Mar 2005 12:15:53 -0000	1.80
--- server_options.sql	22 Mar 2005 07:07:25 -0000	1.81
***************
*** 19,22 ****
  #
  
! INSERT INTO server_options VALUES("db_version","1078");
  INSERT INTO server_options VALUES("standard_motd","This is the message of the day from server_options table.");
--- 19,22 ----
  #
  
! INSERT INTO server_options VALUES("db_version","1080");
  INSERT INTO server_options VALUES("standard_motd","This is the message of the day from server_options table.");