 );
     
 CREATE TABLE damage_types (
-	damage_type varchar(32),
-    primary key (damage_type)
+    damage_type VARCHAR(32),
+    PRIMARY KEY (damage_type)
 );
 
 CREATE TABLE conditions (
-	`condition` varchar(32),
-    primary key (`condition`)
+    `condition` VARCHAR(32),
+    PRIMARY KEY (`condition`)
 );
 
 CREATE TABLE creature_damage_type_modifiers (
-	creature_entry_id int(11),
-    damage_type varchar(32),
-    modifier double DEFAULT 1,
+    creature_entry_id INT(11),
+    damage_type VARCHAR(32),
+    modifier DOUBLE DEFAULT 1,
     FOREIGN KEY (creature_entry_id)
         REFERENCES creatures (entry_id)
         ON UPDATE CASCADE ON DELETE CASCADE,
     FOREIGN KEY (damage_type)
         REFERENCES damage_types (damage_type)
         ON UPDATE CASCADE ON DELETE CASCADE,
-    primary key (creature_entry_id, damage_type)
+    PRIMARY KEY (creature_entry_id , damage_type)
 );
 
 CREATE TABLE creature_condition_immunities (
-	creature_entry_id int(11),
-    `condition` varchar(32),
+    creature_entry_id INT(11),
+    `condition` VARCHAR(32),
     FOREIGN KEY (creature_entry_id)
         REFERENCES creatures (entry_id)
         ON UPDATE CASCADE ON DELETE CASCADE,
     FOREIGN KEY (`condition`)
         REFERENCES creature_damage_type_modifiers (`condition`)
         ON UPDATE CASCADE ON DELETE CASCADE,
-    primary key (creature_entry_id, `condition`)
+    PRIMARY KEY (creature_entry_id , `condition`)
 );
 
 

    wisdom INT(11),
    charisma INT(11),
    alignment VARCHAR(32),
    proficiency_bonus int(11) default 2,
    size varchar(16) DEFAULT "medium",
	base_speed int(11) DEFAULT 30,
	burrow_speed int(11) DEFAULT 0,
	climb_speed int(11) DEFAULT 15,
	fly_speed int(11) DEFAULT 0,
	swim_speed int(11) DEFAULT 15,
	languages varchar(128) DEFAULT '',
	senses varchar(128) DEFAULT '',
	constitution_saving_throw_modifier int(11) DEFAULT 0,
	strength_saving_throw_modifier int(11) DEFAULT 0,
	dexterity_saving_throw_modifier int(11) DEFAULT 0,
	intelligence_saving_throw_modifier int(11) DEFAULT 0,
	wisdom_saving_throw_modifier int(11) DEFAULT 0,
	charisma_saving_throw_modifier int(11) DEFAULT 0,
	acrobatics_proficiency_modifier int(11) DEFAULT 0,
	arcana_proficiency_modifier int(11) DEFAULT 0,
	athletics_proficiency_modifier int(11) DEFAULT 0,
	deception_proficiency_modifier int(11) DEFAULT 0,
	history_proficiency_modifier int(11) DEFAULT 0,
	insight_proficiency_modifier int(11) DEFAULT 0,
	intimidation_proficiency_modifier int(11) DEFAULT 0,
	investigation_proficiency_modifier int(11) DEFAULT 0,
	medicine_proficiency_modifier int(11) DEFAULT 0,
	nature_proficiency_modifier int(11) DEFAULT 0,
	perception_proficiency_modifier int(11) DEFAULT 0,
	performance_proficiency_modifier int(11) DEFAULT 0,
	persuasion_proficiency_modifier int(11) DEFAULT 0,
	religion_proficiency_modifier int(11) DEFAULT 0,
	slight_of_hand_proficiency_modifier int(11) DEFAULT 0,
	stealth_proficiency_modifier int(11) DEFAULT 0,
	survival_proficiency_modifier int(11) DEFAULT 0,
	special_traits text DEFAULT '',
	class_levels varchar(128) default '',
    FOREIGN KEY (entry_id)
        REFERENCES entries (id)
        ON UPDATE CASCADE ON DELETE CASCADE,

insert into alignments (alignment) values ('lawful-good'), ('lawful-neutral'), ('lawful-evil'), ('neutral-good'), ('neutral-neutral'), ('neutral-evil'), ('chaotic-good'), ('chaotic-neutral'), ('chaotic-evil');

CREATE TABLE creature_types (
    creature_type VARCHAR(32),
    PRIMARY KEY (creature_type)
);

insert into creature_types (creature_type) values ('Aberation'), ('Beast'), ('Celestial'), ('Construct'), ('Dragon'), ('Elemental'), ('Fey'), ('Fiend'), ('Giant'), ('Humanoid'), ('Monstrosity'), ('Ooze'), ('Plant'), ('Undead');

CREATE TABLE creatures (
    entry_id INT(11),
    `type` VARCHAR(32),
    race VARCHAR(32),
    gender VARCHAR(16),
    max_hit_points INT(11),
    average_max_hit_points VARCHAR(32),
    constitution INT(11),
    strength INT(11),
    dexterity INT(11),
