DROP TABLE IF EXISTS actionType; CREATE TABLE actionType ( id int(10) unsigned NOT NULL, name varchar(45) NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; INSERT INTO actionType (id,name) VALUES (1,'Standard'); INSERT INTO actionType (id,name) VALUES (2,'Movement'); INSERT INTO actionType (id,name) VALUES (3,'Minor'); INSERT INTO actionType (id,name) VALUES (4,'Free'); INSERT INTO actionType (id,name) VALUES (5,'Immediate Interrupt'); INSERT INTO actionType (id,name) VALUES (6,'Immediate Reaction');

DROP TABLE IF EXISTS alignment; CREATE TABLE alignment ( id int(10) unsigned NOT NULL, displayOrder int(10) unsigned NOT NULL, name varchar(45) NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; INSERT INTO alignment (id,displayOrder,name) VALUES (1,1,'Any'); INSERT INTO alignment (id,displayOrder,name) VALUES (2,2,'Lawful Good'); INSERT INTO alignment (id,displayOrder,name) VALUES (3,3,'Good'); INSERT INTO alignment (id,displayOrder,name) VALUES (4,4,'Unaligned'); INSERT INTO alignment (id,displayOrder,name) VALUES (5,5,'Evil'); INSERT INTO alignment (id,displayOrder,name) VALUES (6,6,'Chaotic Evil');

-- damage, status effects, ongoing damage... -- hit, afterEffect, firstFailed, secondFailed, miss DROP TABLE IF EXISTS attack; CREATE TABLE attack ( id int(10) unsigned NOT NULL, monsterId int(10) unsigned NOT NULL, name varchar(45) NOT NULL, note varchar(256) NULL, attackTypeId int(10) NOT NULL, range int(10) NULL, toHitBonus int(10) NOT NULL, defenseId int(10) NOT NULL, actionTypeId int(10) NOT NULL, powerTypeId int(10) NOT NULL, triggerId int(10) NULL, bloodiedOnly bit(1) NULL, notBloodiedOnly bit(1) NULL, mustHaveCombatAdvantage bit(1) NULL, -- if the attack also heals the attacker healDieCount1 int(10) NOT NULL, healDieType1 int(10) NOT NULL, healDieBonus1 int(10) NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS attackEffect; CREATE TABLE attackEffect ( id int(10) unsigned NOT NULL, damageTypeId1 int(10) NOT NULL, damageDieCount1 int(10) NOT NULL, damageDieType1 int(10) NOT NULL, damageDieBonus1 int(10) NOT NULL, damageTypeId2 int(10) NOT NULL, damageDieCount2 int(10) NOT NULL, damageDieType2 int(10) NOT NULL, damageDieBonus2 int(10) NOT NULL, statusBlinded bit(1) NULL, statusDazed bit(1) NULL, statusDeafened bit(1) NULL, statusDominated bit(1) NULL, statusHelpless bit(1) NULL, statusImmobilized bit(1) NULL, statusMarked bit(1) NULL, statusPetrified bit(1) NULL, statusProne bit(1) NULL, statusRestrained bit(1) NULL, statusSlowed bit(1) NULL, statusStunned bit(1) NULL, statusSurprised bit(1) NULL, statusUnconscious bit(1) NULL, statusWeakened bit(1) NULL, statusEndParamId int(10) NULL, ongoingNoType int(10) NULL, ongoingAcid int(10) NULL, ongoingCold int(10) NULL, ongoingFire int(10) NULL, ongoingLightning int(10) NULL, ongoingNecrotic int(10) NULL, ongoingPoison int(10) NULL, ongoingPsychic int(10) NULL, ongoingRadiant int(10) NULL, ongoingEndParamId int(10) NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS attackEffectLink; CREATE TABLE attackEffectLink ( id int(10) unsigned NOT NULL, attackId int(10) unsigned NOT NULL, attackEffectId int(10) unsigned NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS attackTrigger; CREATE TABLE attackTrigger ( id int(10) unsigned NOT NULL, name varchar(45) NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; INSERT INTO attackTrigger (id,name) VALUES (,'');

DROP TABLE IF EXISTS attackType; CREATE TABLE attackType ( id int(10) unsigned NOT NULL, name varchar(45) NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; INSERT INTO attackType (id,name) VALUES (1,'Melee Attack'); INSERT INTO attackType (id,name) VALUES (2,'Ranged Attack'); INSERT INTO attackType (id,name) VALUES (3,'Close Blast'); INSERT INTO attackType (id,name) VALUES (4,'Close Burst'); INSERT INTO attackType (id,name) VALUES (5,'Close Wall'); INSERT INTO attackType (id,name) VALUES (6,'Area Blast'); INSERT INTO attackType (id,name) VALUES (7,'Area Burst'); INSERT INTO attackType (id,name) VALUES (8,'Area Wall'); INSERT INTO attackType (id,name) VALUES (9,'Melee Basic Attack'); INSERT INTO attackType (id,name) VALUES (10,'Ranged Basic Attack');

DROP TABLE IF EXISTS campaign; CREATE TABLE campaign ( id int(10) unsigned NOT NULL AUTO_INCREMENT, name varchar(45) NOT NULL, level int(10) unsigned NOT NULL, playerCount int(10) unsigned NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; INSERT INTO campaign (name,level,playerCount) VALUES ('BreakNeck',5,4);

DROP TABLE IF EXISTS campaign2monster; CREATE TABLE campaign2monster ( campaignId int(10) unsigned NOT NULL, monsterId int(10) unsigned NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS damageType; CREATE TABLE damageType ( id int(10) unsigned NOT NULL, name int(10) unsigned NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; INSERT INTO damageType (id,name) VALUES (1,'Acid'); INSERT INTO damageType (id,name) VALUES (2,'Cold'); INSERT INTO damageType (id,name) VALUES (3,'Fire'); INSERT INTO damageType (id,name) VALUES (4,'Force'); INSERT INTO damageType (id,name) VALUES (5,'Lightning'); INSERT INTO damageType (id,name) VALUES (6,'Necrotic'); INSERT INTO damageType (id,name) VALUES (7,'Poison'); INSERT INTO damageType (id,name) VALUES (8,'Psychic'); INSERT INTO damageType (id,name) VALUES (9,'Radiant');

DROP TABLE IF EXISTS defense; CREATE TABLE defense ( id int(10) unsigned NOT NULL, name int(10) unsigned NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; INSERT INTO defense (id,name) VALUES (1,'Armor Class'); INSERT INTO defense (id,name) VALUES (2,'Fortitude'); INSERT INTO defense (id,name) VALUES (3,'Reflex'); INSERT INTO defense (id,name) VALUES (4,'Will');

DROP TABLE IF EXISTS difficulty; CREATE TABLE difficulty ( id int(10) unsigned NOT NULL, name varchar(45) NOT NULL, displayOrder int(10) unsigned NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; INSERT INTO difficulty (id,name,displayOrder) VALUES (1,'Easy',1); INSERT INTO difficulty (id,name,displayOrder) VALUES (2,'Standard',2); INSERT INTO difficulty (id,name,displayOrder) VALUES (3,'Hard',3);

DROP TABLE IF EXISTS encounterGroup; CREATE TABLE encounterGroup ( id int(10) unsigned NOT NULL AUTO_INCREMENT, name varchar(45) NOT NULL, XP int(10) unsigned NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS encounterGroupItem; CREATE TABLE encounterGroupItem ( id int(10) unsigned NOT NULL AUTO_INCREMENT, encounterGroupId int(10) unsigned NOT NULL, monsterId int(10) unsigned NULL, monsterRoleId1 int(10) unsigned NULL, monsterRoleId2 int(10) unsigned NULL, elite int(10) unsigned NULL, eliteNot int(10) unsigned NULL, solo int(10) unsigned NULL, soloNot int(10) unsigned NULL, leader int(10) unsigned NULL, leaderNot int(10) unsigned NULL, level int(10) unsigned NULL, keyword int(10) unsigned NULL, levelAdjust int(10) NOT NULL, monsterCount int(10) NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS endParam; CREATE TABLE endParam ( id int(10) unsigned NOT NULL, name varchar(20) NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; INSERT INTO endParam (id,name) VALUES (1,'save ends'); INSERT INTO endParam (id,name) VALUES (2,'end of attacker\'s next turn'); INSERT INTO endParam (id,name) VALUES (3,'end of encounter');

DROP TABLE IF EXISTS flyType; CREATE TABLE flyType ( id int(10) unsigned NOT NULL, displayOrder int(10) unsigned NOT NULL, name varchar(45) NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; INSERT INTO flyType (id,displayOrder,name) VALUES (1,1,'Clumbsy'); INSERT INTO flyType (id,displayOrder,name) VALUES (2,2,'Normal'); INSERT INTO flyType (id,displayOrder,name) VALUES (3,3,'Hover');

DROP TABLE IF EXISTS groupTemplate; CREATE TABLE groupTemplate ( id int(10) unsigned NOT NULL, name varchar(45) NOT NULL, difficultyId int(10) unsigned NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; INSERT INTO groupTemplate (id,name,difficultyId) VALUES (1,'Battlefield Control',1); INSERT INTO groupTemplate (id,name,difficultyId) VALUES (2,'Battlefield Control',2); INSERT INTO groupTemplate (id,name,difficultyId) VALUES (3,'Battlefield Control',3); INSERT INTO groupTemplate (id,name,difficultyId) VALUES (4,'Commander and Troops',1); INSERT INTO groupTemplate (id,name,difficultyId) VALUES (5,'Commander and Troops',2); INSERT INTO groupTemplate (id,name,difficultyId) VALUES (6,'Commander and Troops',3); INSERT INTO groupTemplate (id,name,difficultyId) VALUES (7,'Dragon\'s Den',1); INSERT INTO groupTemplate (id,name,difficultyId) VALUES (8,'Dragon\'s Den',2); INSERT INTO groupTemplate (id,name,difficultyId) VALUES (9,'Dragon\'s Den, solo only',3); INSERT INTO groupTemplate (id,name,difficultyId) VALUES (10,'Dragon\'s Den, with elite',3); INSERT INTO groupTemplate (id,name,difficultyId) VALUES (11,'Double Line',1); INSERT INTO groupTemplate (id,name,difficultyId) VALUES (12,'Double Line, standard',2); INSERT INTO groupTemplate (id,name,difficultyId) VALUES (13,'Double Line, strong artillery',2); INSERT INTO groupTemplate (id,name,difficultyId) VALUES (14,'Double Line, standard',3); INSERT INTO groupTemplate (id,name,difficultyId) VALUES (15,'Double Line, with lurker',3); INSERT INTO groupTemplate (id,name,difficultyId) VALUES (16,'Wolf Pack',1); INSERT INTO groupTemplate (id,name,difficultyId) VALUES (17,'Wolf Pack, 7',2); INSERT INTO groupTemplate (id,name,difficultyId) VALUES (18,'Wolf Pack, 5',2); INSERT INTO groupTemplate (id,name,difficultyId) VALUES (19,'Wolf Pack, 3',3); INSERT INTO groupTemplate (id,name,difficultyId) VALUES (20,'Wolf Pack, 4',3); INSERT INTO groupTemplate (id,name,difficultyId) VALUES (21,'Wolf Pack, 6',3);

DROP TABLE IF EXISTS groupTemplateItem; CREATE TABLE groupTemplateItem ( groupTemplateId int(10) unsigned NOT NULL, count int(10) unsigned NOT NULL, monsterRoleId1 int(10) unsigned NULL, monsterRoleId2 int(10) unsigned NULL, elite int(10) unsigned NULL, solo int(10) unsigned NULL, leader int(10) unsigned NULL, levelOffset int(10) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (1,1,3,null,null,null,null,-2); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (1,6,6,null,null,null,null,-4); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (2,1,3,null,null,null,null,1); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (2,6,6,null,null,null,null,-2); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (3,1,3,null,null,null,null,5); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (3,5,6,null,null,null,null,1); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (4,1,3,7,null,null,null,0); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (4,4,2,7,null,null,null,-3); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (5,1,3,7,null,null,null,3); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (5,5,2,7,null,null,null,-2); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (6,1,3,7,null,null,null,6); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (6,3,2,7,null,null,null,1); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (6,2,1,null,null,null,null,1); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (7,1,null,null,null,1,null,-2); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (8,1,null,null,null,1,null,1); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (9,1,null,null,null,1,null,3); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (10,1,null,null,null,1,null,1); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (10,1,null,null,1,null,null,0); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (11,3,2,7,null,null,null,-4); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (11,2,1,3,null,null,null,-2); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (12,3,2,7,null,null,null,0); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (12,2,1,3,null,null,null,0); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (13,3,2,7,null,null,null,-2); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (13,2,1,3,null,null,null,3); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (14,3,2,7,null,null,null,2); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (14,1,3,null,null,null,null,4); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (14,1,1,4,null,null,null,4); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (15,3,2,7,null,null,null,0); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (15,2,1,null,null,null,null,1); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (15,1,3,null,null,null,null,2); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (15,1,4,null,null,null,null,2); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (16,7,6,null,null,null,null,-4); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (17,7,6,null,null,null,null,-2); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (18,5,6,null,null,null,null,0); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (19,3,6,null,null,null,null,7); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (20,4,6,null,null,null,null,5); INSERT INTO groupTemplateItem (groupTemplateId,count,monsterRoleId1,monsterRoleId2,elite,solo,leader,levelOffset) VALUES (21,6,6,null,null,null,null,2);

DROP TABLE IF EXISTS monster; CREATE TABLE monster ( id int(10) unsigned NOT NULL AUTO_INCREMENT, page int(10) unsigned NULL, name varchar(45) NOT NULL, level int(10) unsigned NOT NULL, monsterRoleId int(10) unsigned NOT NULL, elite int(10) unsigned NULL, solo int(10) unsigned NULL, leader int(10) unsigned NULL, sizeId int(10) unsigned NOT NULL, shapeLong int(10) unsigned NULL, shapeTall int(10) unsigned NULL, originId int(10) unsigned NOT NULL, monsterTypeId int(10) unsigned NOT NULL, keywordAir int(10) unsigned NULL, keywordAngel int(10) unsigned NULL, keywordAquatic int(10) unsigned NULL, keywordBlind int(10) unsigned NULL, keywordCold int(10) unsigned NULL, keywordConstruct int(10) unsigned NULL, keywordDemon int(10) unsigned NULL, keywordDevil int(10) unsigned NULL, keywordDragon int(10) unsigned NULL, keywordEarth int(10) unsigned NULL, keywordFire int(10) unsigned NULL, keywordGiant int(10) unsigned NULL, keywordHomunculus int(10) unsigned NULL, keywordLivingConstruct int(10) unsigned NULL, keywordMount int(10) unsigned NULL, keywordOoze int(10) unsigned NULL, keywordPlant int(10) unsigned NULL, keywordReptile int(10) unsigned NULL, keywordShapechanger int(10) unsigned NULL, keywordSpider int(10) unsigned NULL, keywordSwarm int(10) unsigned NULL, keywordUndead int(10) unsigned NULL, keywordWater int(10) unsigned NULL, initiative int(10) NOT NULL, blindsight int(10) unsigned NULL, tremorsense int(10) unsigned NULL, truesight int(10) unsigned NULL, visionAllAround int(10) unsigned NULL, visionDark int(10) unsigned NULL, visionLowLight int(10) unsigned NULL, hitPoints int(10) unsigned NOT NULL, regeneration int(10) unsigned NULL, armorClass int(10) unsigned NOT NULL, fortitude int(10) unsigned NOT NULL, reflex int(10) unsigned NOT NULL, will int(10) unsigned NOT NULL, immuneAcid int(10) unsigned NULL, immuneCharm int(10) unsigned NULL, immuneCold int(10) unsigned NULL, immuneDisease int(10) unsigned NULL, immuneFear int(10) unsigned NULL, immuneFire int(10) unsigned NULL, immuneGaze int(10) unsigned NULL, immuneIllusion int(10) unsigned NULL, immuneLightning int(10) unsigned NULL, immuneNecrotic int(10) unsigned NULL, immunePetrification int(10) unsigned NULL, immunePoison int(10) unsigned NULL, immunePsychic int(10) unsigned NULL, immuneRadiant int(10) unsigned NULL, immuneSleep int(10) unsigned NULL, resistAcid int(10) unsigned NULL, resistAll int(10) unsigned NULL, resistCold int(10) unsigned NULL, resistFire int(10) unsigned NULL, resistLightning int(10) unsigned NULL, resistNecrotic int(10) unsigned NULL, resistPoison int(10) unsigned NULL, resistPsychic int(10) unsigned NULL, resistRadiant int(10) unsigned NULL, resistVariable int(10) unsigned NULL, insubstantial int(10) unsigned NULL, vulnerableAcid int(10) unsigned NULL, vulnerableCold int(10) unsigned NULL, vulnerableFire int(10) unsigned NULL, vulnerableLightning int(10) unsigned NULL, vulnerableNecrotic int(10) unsigned NULL, vulnerablePoison int(10) unsigned NULL, vulnerablePsychic int(10) unsigned NULL, vulnerableRadiant int(10) unsigned NULL, savingThrow int(10) NULL, speedWalk int(10) unsigned NULL, walkEarth int(10) unsigned NULL, walkForest int(10) unsigned NULL, walkIce int(10) unsigned NULL, walkSwamp int(10) unsigned NULL, speedBurrow int(10) unsigned NULL, tunneling int(10) unsigned NULL, speedClimb int(10) unsigned NULL, spiderClimb int(10) unsigned NULL, speedFly int(10) unsigned NULL, flyTypeId int(10) unsigned NULL, speedOverlandFlight int(10) unsigned NULL, phasing int(10) unsigned NULL, speedSwim int(10) unsigned NULL, teleport int(10) unsigned NULL, actionPoints int(10) unsigned NULL, alignmentId int(10) unsigned NOT NULL, languageAbyssal int(10) unsigned NULL, languageCommon int(10) unsigned NULL, languageDeepSpeech int(10) unsigned NULL, languageDraconic int(10) unsigned NULL, languageDwarven int(10) unsigned NULL, languageElven int(10) unsigned NULL, languageGiant int(10) unsigned NULL, languageGoblin int(10) unsigned NULL, languagePrimordial int(10) unsigned NULL, languageSupernal int(10) unsigned NULL, telepathy int(10) unsigned NULL, skillAcrobatics int(10) NULL, skillArcana int(10) NULL, skillAthletics int(10) NULL, skillBluff int(10) NULL, skillDiplomacy int(10) NULL, skillDungeoneering int(10) NULL, skillEndurance int(10) NULL, skillHeal int(10) NULL, skillHistory int(10) NULL, skillInsight int(10) NULL, skillIntimidate int(10) NULL, skillNature int(10) NULL, skillPerception int(10) NULL, skillReligion int(10) NULL, skillStealth int(10) NULL, skillStreetwise int(10) NULL, skillThievery int(10) NULL, strength int(10) unsigned NOT NULL, dexterity int(10) unsigned NOT NULL, wisdom int(10) unsigned NOT NULL, constitution int(10) unsigned NOT NULL, intelligence int(10) unsigned NOT NULL, charisma int(10) unsigned NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS monsterCompanions; CREATE TABLE monsterCompanions ( id int(10) unsigned NOT NULL AUTO_INCREMENT, monsterId1 int(10) unsigned NOT NULL, monsterId2 int(10) unsigned NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS monsterRole; CREATE TABLE monsterRole ( id int(10) unsigned NOT NULL, name varchar(45) NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; INSERT INTO monsterRole (id,name) VALUES (1,'Artillery'); INSERT INTO monsterRole (id,name) VALUES (2,'Brute'); INSERT INTO monsterRole (id,name) VALUES (3,'Controller'); INSERT INTO monsterRole (id,name) VALUES (4,'Lurker'); INSERT INTO monsterRole (id,name) VALUES (5,'Minion'); INSERT INTO monsterRole (id,name) VALUES (6,'Skirmisher'); INSERT INTO monsterRole (id,name) VALUES (7,'Soldier');

DROP TABLE IF EXISTS monsterType; CREATE TABLE monsterType ( id int(10) unsigned NOT NULL, displayOrder int(10) unsigned NOT NULL, name varchar(45) NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; INSERT INTO monsterType (id,displayOrder,name) VALUES (1,1,'Animate'); INSERT INTO monsterType (id,displayOrder,name) VALUES (2,2,'Beast'); INSERT INTO monsterType (id,displayOrder,name) VALUES (3,3,'Humanoid'); INSERT INTO monsterType (id,displayOrder,name) VALUES (4,4,'Magical Beast');

DROP TABLE IF EXISTS origin; CREATE TABLE origin ( id int(10) unsigned NOT NULL, displayOrder int(10) unsigned NOT NULL, name varchar(45) NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; INSERT INTO origin (id,displayOrder,name) VALUES (1,1,'Aberrant'); INSERT INTO origin (id,displayOrder,name) VALUES (2,2,'Elemental'); INSERT INTO origin (id,displayOrder,name) VALUES (3,3,'Fey'); INSERT INTO origin (id,displayOrder,name) VALUES (4,4,'Immortal'); INSERT INTO origin (id,displayOrder,name) VALUES (5,5,'Natural'); INSERT INTO origin (id,displayOrder,name) VALUES (6,6,'Shadow');

DROP TABLE IF EXISTS powerType; CREATE TABLE powerType ( id int(10) unsigned NOT NULL, name varchar(45) NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; INSERT INTO powerType (id,name) VALUES (1,'At-Will'); INSERT INTO powerType (id,name) VALUES (2,'Recharge 2-6'); INSERT INTO powerType (id,name) VALUES (3,'Recharge 3-6'); INSERT INTO powerType (id,name) VALUES (4,'Recharge 4-6'); INSERT INTO powerType (id,name) VALUES (5,'Recharge 5-6'); INSERT INTO powerType (id,name) VALUES (6,'Recharge 6'); INSERT INTO powerType (id,name) VALUES (7,'Encounter'); INSERT INTO powerType (id,name) VALUES (8,'Daily');

DROP TABLE IF EXISTS size; CREATE TABLE size ( id int(10) unsigned NOT NULL, displayOrder int(10) unsigned NOT NULL, name varchar(45) NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; INSERT INTO size (id,displayOrder,name) VALUES (1,1,'Tiny'); INSERT INTO size (id,displayOrder,name) VALUES (2,2,'Small'); INSERT INTO size (id,displayOrder,name) VALUES (3,3,'Medium'); INSERT INTO size (id,displayOrder,name) VALUES (4,4,'Large'); INSERT INTO size (id,displayOrder,name) VALUES (5,5,'Huge'); INSERT INTO size (id,displayOrder,name) VALUES (6,6,'Gargantuan');