DROP TABLE IF EXISTS characterClass; CREATE TABLE characterClass ( id int(10) unsigned NOT NULL, name varchar(45) NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; INSERT INTO characterClass (id,name) VALUES (1,'Cleric'); INSERT INTO characterClass (id,name) VALUES (2,'Fighter'); INSERT INTO characterClass (id,name) VALUES (3,'Paladin'); INSERT INTO characterClass (id,name) VALUES (4,'Ranger'); INSERT INTO characterClass (id,name) VALUES (5,'Rogue'); INSERT INTO characterClass (id,name) VALUES (6,'Warlock'); INSERT INTO characterClass (id,name) VALUES (7,'Warlord'); INSERT INTO characterClass (id,name) VALUES (8,'Wizard');

DROP TABLE IF EXISTS characterCondition; CREATE TABLE characterCondition ( id int(10) unsigned NOT NULL, name varchar(45) NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; INSERT INTO characterCondition (id,name) VALUES (1,'blinded'); INSERT INTO characterCondition (id,name) VALUES (2,'dazed'); INSERT INTO characterCondition (id,name) VALUES (3,'deafened'); INSERT INTO characterCondition (id,name) VALUES (4,'dominated'); INSERT INTO characterCondition (id,name) VALUES (5,'dying'); INSERT INTO characterCondition (id,name) VALUES (6,'helpless'); INSERT INTO characterCondition (id,name) VALUES (7,'immobilized'); INSERT INTO characterCondition (id,name) VALUES (8,'petrified'); INSERT INTO characterCondition (id,name) VALUES (9,'prone'); INSERT INTO characterCondition (id,name) VALUES (10,'restrained'); INSERT INTO characterCondition (id,name) VALUES (11,'slowed'); INSERT INTO characterCondition (id,name) VALUES (12,'stunned'); INSERT INTO characterCondition (id,name) VALUES (13,'surprised'); INSERT INTO characterCondition (id,name) VALUES (14,'unconscious'); INSERT INTO characterCondition (id,name) VALUES (15,'weakened'); INSERT INTO characterCondition (id,name) VALUES (16,'insubstantial'); INSERT INTO characterCondition (id,name) VALUES (17,'invisible');

DROP TABLE IF EXISTS damageType; CREATE TABLE damageType ( id int(10) unsigned NOT NULL, name varchar(45) NOT NULL, PRIMARY KEY (id) ) 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'); INSERT INTO damageType (id,name) VALUES (10,'thunder');

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

DROP TABLE IF EXISTS encounterGroupItemInstance; CREATE TABLE encounterGroupItemInstance ( id int(10) unsigned NOT NULL AUTO_INCREMENT, encounterGroupInstanceId int(10) unsigned NOT NULL, encounterGroupItemId int(10) unsigned NOT NULL, name varchar(45) NOT NULL, hp int(10) unsigned NOT NULL, power1 int(10) unsigned NULL, power2 int(10) unsigned NULL, power3 int(10) unsigned NULL, power4 int(10) unsigned NULL, power5 int(10) unsigned NULL, power6 int(10) unsigned NULL, power7 int(10) unsigned NULL, power8 int(10) unsigned NULL, power9 int(10) unsigned NULL, init int(10) unsigned NOT NULL, round int(10) unsigned NOT NULL, alive int(10) unsigned NOT NULL, actionPoints int(10) unsigned NOT NULL, secondWind int(10) unsigned NOT NULL, tempHitPoints int(10) unsigned NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS ongoingDamage; CREATE TABLE ongoingDamage ( id int(10) unsigned NOT NULL AUTO_INCREMENT, encounterGroupItemInstanceId int(10) unsigned NOT NULL, damageTypeId int(10) unsigned NOT NULL, damageAmountId int(10) unsigned NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS pcInstance; CREATE TABLE pcInstance ( id int(10) unsigned NOT NULL AUTO_INCREMENT, pcId int(10) unsigned NOT NULL, hp int(10) unsigned NOT NULL, tempHitPoints int(10) unsigned NOT NULL, secondWind int(10) unsigned NOT NULL, actionPoints int(10) unsigned NOT NULL, xp int(10) NOT NULL, power1 int(10) unsigned NULL, power2 int(10) unsigned NULL, power3 int(10) unsigned NULL, power4 int(10) unsigned NULL, power5 int(10) unsigned NULL, power6 int(10) unsigned NULL, power7 int(10) unsigned NULL, power8 int(10) unsigned NULL, power9 int(10) unsigned NULL, init int(10) NULL, round int(10) unsigned NULL, alive int(10) unsigned NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS pc; CREATE TABLE pc ( id int(10) unsigned NOT NULL AUTO_INCREMENT, playerId int(10) unsigned NOT NULL, campaignId int(10) unsigned NOT NULL, name varchar(45) NOT NULL, level int(10) unsigned NOT NULL, classId int(10) unsigned NOT 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, savingThrows 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, 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 player; CREATE TABLE player ( id int(10) unsigned NOT NULL, name varchar(45) NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; INSERT INTO player (id,name) VALUES (1,'Ben'); INSERT INTO player (id,name) VALUES (2,'Ian'); INSERT INTO player (id,name) VALUES (3,'Jes'); INSERT INTO player (id,name) VALUES (4,'Jim'); INSERT INTO player (id,name) VALUES (5,'Rob');

DROP TABLE IF EXISTS playerPref; CREATE TABLE playerPref ( id int(10) unsigned NOT NULL AUTO_INCREMENT, playerId int(10) NOT NULL, auto int(10) NOT NULL, addD20 int(10) NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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