CREATE TABLE "armor" ("item_id" integer(11) NOT NULL DEFAULT 0, "name" character varying(70), "bodypart" character varying(15) NOT NULL, "crystallizable" character varying(5) NOT NULL, "armor_type" character varying(5) NOT NULL, "weight" integer(5) NOT NULL DEFAULT 0, "material" character varying(15), "crystal_type" character varying(4) NOT NULL, "avoid_modify" integer(1) NOT NULL DEFAULT 0, "durability" integer(3) NOT NULL DEFAULT 0, "p_def" integer(3) NOT NULL DEFAULT 0, "m_def" integer(2) NOT NULL DEFAULT 0, "mp_bonus" integer(3) NOT NULL DEFAULT 0,"price" integer(11) NOT NULL DEFAULT 0, "crystal_count" integer(4) NOT NULL DEFAULT 0, "sellable" character varying(5))