# MySQL-Front Dump 1.16 beta
#
# Host: localhost Database: planeshift
#--------------------------------------------------------
# Server version 4.0.18-max-nt
#
# Table structure for table 'loot_rule_details'
#

CREATE TABLE loot_rule_details (
  id int(10) unsigned NOT NULL auto_increment,
  loot_rule_id int(10) unsigned NOT NULL DEFAULT '0' ,
  item_stat_id int(10) unsigned NOT NULL DEFAULT '0' ,
  probability float(5,4) NOT NULL DEFAULT '0.0000' ,
  min_money int(10) unsigned NOT NULL DEFAULT '0' ,
  max_money int(10) unsigned NOT NULL DEFAULT '0' ,
  randomize tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (id)
);


#
# Dumping data for table 'loot_rule_details'
#

INSERT INTO loot_rule_details VALUES (1,1,8,0.5,0,0,0);
INSERT INTO loot_rule_details VALUES (2,1,7,0.35,0,0,1);
INSERT INTO loot_rule_details VALUES (3,1,6,0.15,10,35,0);
INSERT INTO loot_rule_details VALUES (4,2,3,1,0,0,1);