     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 '',
+    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,

);
    
CREATE TABLE damage_types (
	damage_type varchar(32),
    primary key (damage_type)
);

CREATE TABLE conditions (
	`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,
    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)
);

CREATE TABLE creature_condition_immunities (
	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`)
);



    FOREIGN KEY (relation_type_id)
        REFERENCES creature_creature_relation_types (id)
        ON UPDATE CASCADE ON DELETE CASCADE,
    PRIMARY KEY (creature_a , creature_b , relation_type_id)
)
