From: Thomas T. <to...@us...> - 2003-11-01 22:57:09
|
Update of /cvsroot/planeshift/planeshift/src/server/database/mysql In directory sc8-pr-cvs1:/tmp/cvs-serv14089 Added Files: trade_combinations.sql trade_patterns.sql trade_transformations.sql Log Message: Added trade SQL tables. --- NEW FILE: trade_combinations.sql --- # MySQL-Front Dump 1.16 beta # # Host: localhost Database: planeshift #-------------------------------------------------------- # Server version 3.23.52-max-nt # # Table structure for table 'trade_combinations' # CREATE TABLE trade_combinations ( id int(10) unsigned NOT NULL auto_increment, pattern_id int(10) unsigned , result_id int(10) unsigned , item_id int(10) unsigned , min_qty int(10) unsigned DEFAULT '0' , max_qty int(10) unsigned DEFAULT '0' , animation_id int(10) unsigned DEFAULT '0' , container_id int(10) unsigned , description varchar(255) NOT NULL DEFAULT '' , PRIMARY KEY (id) ); # # Dumping data for table 'trade_combinations' # INSERT INTO trade_combinations VALUES(1,1,69,60,1,2,0,70,'Egg in a mixing bowl making waybread batter'); INSERT INTO trade_combinations VALUES(2,1,69,61,7,12,0,70,'Flower in mixing bowl making waybread batter'); INSERT INTO trade_combinations VALUES(3,1,69,62,2,5,0,70,'Milk in mixing bowl making waybread batter'); --- NEW FILE: trade_patterns.sql --- # MySQL-Front Dump 1.16 beta # # Host: localhost Database: planeshift #-------------------------------------------------------- # Server version 3.23.52-max-nt # # Table structure for table 'trade_patterns' # CREATE TABLE trade_patterns ( id int(10) unsigned NOT NULL auto_increment, item_id int(10) unsigned , description varchar(255) NOT NULL DEFAULT '' , PRIMARY KEY (id) ); # # Dumping data for table 'trade_patterns' # INSERT INTO trade_patterns VALUES(1,71,'Waybread with Gareth recipe'); --- NEW FILE: trade_transformations.sql --- # MySQL-Front Dump 1.16 beta # # Host: localhost Database: planeshift #-------------------------------------------------------- # Server version 3.23.52-max-nt # # Table structure for table 'trade_transformations' # CREATE TABLE trade_transformations ( id int(10) unsigned NOT NULL auto_increment, pattern_id int(10) unsigned , result_id int(10) unsigned , item_id int(10) unsigned , min_qty int(10) unsigned DEFAULT '0' , max_qty int(10) unsigned DEFAULT '0' , animation_id int(10) unsigned DEFAULT '0' , container_id int(10) unsigned , equipment_id int(10) unsigned DEFAULT '0' , description varchar(255) NOT NULL DEFAULT '' , PRIMARY KEY (id) ); # # Dumping data for table 'trade_transformations' # INSERT INTO trade_combinations VALUES(1,1,72,69,10,0,0,70,65,'Your mix waybread batter in mixing bowl.'); INSERT INTO trade_combinations VALUES(2,1,73,72,20,50,0,74,0,'Your bake waybread mix in oven.'); |