[Planeshift-cvs] CVS: planeshift/src/server/database/mysql char_create_affinity.sql,NONE,1.1 create_all.sql,1.58,1.59 upgrade_schema.sql,1.34,1.35

[Borrillis <bor...@us...>]

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

Modified Files:
	create_all.sql upgrade_schema.sql 
Added Files:
	char_create_affinity.sql 
Log Message:
- Added <animalaffinity /> progression operation to manipulate the affinity categories.
  Syntax: <animalaffinity adjust="[set|add|mul|pct]" category="[name]" value="###" />

--- NEW FILE: char_create_affinity.sql ---
# MySQL-Front Dump 1.16 beta
#
# Host: localhost Database: planeshift
#--------------------------------------------------------
# Server version 3.23.52-max-nt
#
# Table structure for table 'char_create_affinity'
#

CREATE TABLE animalaffinity_categories (
  attribute varchar(20) NOT NULL,
  category varchar(20) NOT NULL,
  PRIMARY KEY (category)
);


#
# Dumping data for table 'char_create_affinity'
#

INSERT INTO char_create_affinity VALUES ('Type','arachnid');
INSERT INTO char_create_affinity VALUES ('Type','crustaceans');
INSERT INTO char_create_affinity VALUES ('Type','amphibians');
INSERT INTO char_create_affinity VALUES ('Type','reptiles');
INSERT INTO char_create_affinity VALUES ('Type','feline');
INSERT INTO char_create_affinity VALUES ('Type','birds');
INSERT INTO char_create_affinity VALUES ('Type','rodents');
INSERT INTO char_create_affinity VALUES ('Lifecycle','daylight');
INSERT INTO char_create_affinity VALUES ('Lifecycle','night-darkness');
INSERT INTO char_create_affinity VALUES ('Attack','slashing');
INSERT INTO char_create_affinity VALUES ('Attack','bludgeoning');
INSERT INTO char_create_affinity VALUES ('Attack','piercing');
INSERT INTO char_create_affinity VALUES ('Attack','acid');
INSERT INTO char_create_affinity VALUES ('Attack','fire');
INSERT INTO char_create_affinity VALUES ('Attack','ice');
INSERT INTO char_create_affinity VALUES ('Attack','earth');
INSERT INTO char_create_affinity VALUES ('Attack','water');

Index: create_all.sql
===================================================================
RCS file: /cvsroot/planeshift/planeshift/src/server/database/mysql/create_all.sql,v
retrieving revision 1.58
retrieving revision 1.59
diff -C2 -d -r1.58 -r1.59
*** create_all.sql	6 Mar 2006 20:56:30 -0000	1.58
--- create_all.sql	7 Apr 2006 19:46:49 -0000	1.59
***************
*** 70,71 ****
--- 70,72 ----
  source trade_constraints.sql;
  source tips.sql;
+ source char_create_affinity.sql;

Index: upgrade_schema.sql
===================================================================
RCS file: /cvsroot/planeshift/planeshift/src/server/database/mysql/upgrade_schema.sql,v
retrieving revision 1.34
retrieving revision 1.35
diff -C2 -d -r1.34 -r1.35
*** upgrade_schema.sql	7 Apr 2006 16:53:57 -0000	1.34
--- upgrade_schema.sql	7 Apr 2006 19:46:49 -0000	1.35
***************
*** 176,179 ****
--- 176,180 ----
  #from 1107 to 1108
  ALTER TABLE characters DROP COLUMN familiar_id;
+ SOURCE char_create_affinity.sql;
  
  UPDATE server_options SET option_value=1108 where option_name='db_version';