spawn_prototype.sql

-- --------------------------------------------------------
-- HeidiSQL Version:             9.4.0.5125
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

-- Dumping structure for table ace_world.ace_creature_generators
CREATE TABLE IF NOT EXISTS `ace_creature_generators` (
  `generatorid` int(10) unsigned NOT NULL,
  `name` text NOT NULL,
  PRIMARY KEY (`generatorid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Generators (=groups) for all type of creatures: Drudges, Eaters, Banderlings, etc.';

-- Dumping data for table ace_world.ace_creature_generators: ~2 rows (approximately)
/*!40000 ALTER TABLE `ace_creature_generators` DISABLE KEYS */;
INSERT INTO `ace_creature_generators` (`generatorid`, `name`) VALUES
    (3, 'Drduges (Black)'),
    (8, 'Drduges (Normal)');
/*!40000 ALTER TABLE `ace_creature_generators` ENABLE KEYS */;

-- Dumping structure for table ace_world.ace_creature_generator_data
CREATE TABLE IF NOT EXISTS `ace_creature_generator_data` (
  `generatorid` int(10) unsigned NOT NULL,
  `weenieClassId` smallint(5) unsigned NOT NULL,
  `probability` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY (`generatorid`,`weenieClassId`),
  KEY `FKace_creature_generator_data__weenieClassId` (`weenieClassId`),
  CONSTRAINT `FKace_creature_generator_data__generatorId` FOREIGN KEY (`generatorid`) REFERENCES `ace_creature_generators` (`generatorid`),
  CONSTRAINT `FKace_creature_generator_data__weenieClassId` FOREIGN KEY (`weenieClassId`) REFERENCES `weenie_class` (`weenieClassId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Creature templates that all belong into one generator: i.e. all normal drudges. Probability of spawning this particular creature from this group.';

-- Dumping data for table ace_world.ace_creature_generator_data: ~2 rows (approximately)
/*!40000 ALTER TABLE `ace_creature_generator_data` DISABLE KEYS */;
INSERT INTO `ace_creature_generator_data` (`generatorid`, `weenieClassId`, `probability`) VALUES
    (8, 35440, 50),
    (8, 35441, 40),
    (8, 42437, 10);
/*!40000 ALTER TABLE `ace_creature_generator_data` ENABLE KEYS */;

-- Dumping structure for table ace_world.ace_creature_generator_locations
CREATE TABLE IF NOT EXISTS `ace_creature_generator_locations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `generatorId` int(10) unsigned NOT NULL,
  `quantity` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `landblock` smallint(5) unsigned DEFAULT NULL,
  `cell` smallint(5) unsigned DEFAULT NULL,
  `posX` float DEFAULT NULL,
  `posY` float DEFAULT NULL,
  `posZ` float DEFAULT NULL,
  `qW` float DEFAULT NULL,
  `qX` float DEFAULT NULL,
  `qY` float DEFAULT NULL,
  `qZ` float DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKace_creature_generator_locations__generatorId` (`generatorId`),
  CONSTRAINT `FKace_creature_generator_locations__generatorId` FOREIGN KEY (`generatorId`) REFERENCES `ace_creature_generators` (`generatorid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COMMENT='Locations for the random generated creatures. Specify the quantitiy of how many creatures from this generator should be spawned around this location.';

-- Dumping data for table ace_world.ace_creature_generator_locations: ~0 rows (approximately)
/*!40000 ALTER TABLE `ace_creature_generator_locations` DISABLE KEYS */;
INSERT INTO `ace_creature_generator_locations` (`id`, `generatorId`, `quantity`, `landblock`, `cell`, `posX`, `posY`, `posZ`, `qW`, `qX`, `qY`, `qZ`) VALUES
    (1, 8, 3, 4344, 25, 82.1302, 9.98661, 94.005, 0.983917, 0, 0, 0.178627);
/*!40000 ALTER TABLE `ace_creature_generator_locations` ENABLE KEYS */;

-- Dumping structure for table ace_world.ace_creature_static_locations
CREATE TABLE IF NOT EXISTS `ace_creature_static_locations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `weenieClassId` smallint(5) unsigned NOT NULL,
  `landblock` smallint(5) unsigned DEFAULT NULL,
  `cell` smallint(5) unsigned DEFAULT NULL,
  `posX` float DEFAULT NULL,
  `posY` float DEFAULT NULL,
  `posZ` float DEFAULT NULL,
  `qW` float DEFAULT NULL,
  `qX` float DEFAULT NULL,
  `qY` float DEFAULT NULL,
  `qZ` float DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKace_creature_static_locations__weenieClassId` (`weenieClassId`),
  CONSTRAINT `FKace_creature_static_locations__weenieClassId` FOREIGN KEY (`weenieClassId`) REFERENCES `weenie_class` (`weenieClassId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COMMENT='Location for an exact - not random - creature to spawn: i.e. the 3 (?) water golems on Mayoi beach would be in here.';

-- Dumping data for table ace_world.ace_creature_static_locations: ~0 rows (approximately)
/*!40000 ALTER TABLE `ace_creature_static_locations` DISABLE KEYS */;
INSERT INTO `ace_creature_static_locations` (`id`, `weenieClassId`, `landblock`, `cell`, `posX`, `posY`, `posZ`, `qW`, `qX`, `qY`, `qZ`) VALUES
    (1, 35442, 4344, 25, 82.1302, 9.98661, 94.005, 0.983917, 0, 0, 0.178627);
/*!40000 ALTER TABLE `ace_creature_static_locations` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;