 INSERT INTO attribs VALUES('sf_spir', 'SPELL_FOCUS_SPIRIT', 'Spell Focus Spirit');
 INSERT INTO attribs VALUES('sf_sum', 'SPELL_FOCUS_SUMMONING', 'Spell Focus Summoning');
 INSERT INTO attribs VALUES('sf_tele', 'SPELL_FOCUS_TELEPORTATION', 'Spell Focus Teleportation');
-CREATE TABLE effects(effect_abbr varchar(10) PRIMARY KEY, effect_name varchar(25),
-effect_display varchar(25));
+CREATE TABLE effects(
+	effect_abbr varchar(10) PRIMARY KEY
+	,effect_name varchar(25)
+	,effect_display varchar(25)
+);
 INSERT INTO effects VALUES('pr_evil', 'PR-EVIL', 'Protection From Evil');
 INSERT INTO effects VALUES('pr_good', 'PR-GOOD', 'Protection From Good');
 INSERT INTO effects VALUES('dm', 'DET-MAGIC', 'Detect Magic');

INSERT INTO effects VALUES('blind', 'BLINDNESS', 'Blindness');
INSERT INTO effects VALUES('slow', 'SLOW', 'Slowness');
INSERT INTO effects VALUES('ultra', 'ULTRA', 'Ultravision');
CREATE TABLE resists(resist_abbr varchar(10) PRIMARY KEY, resist_name varchar(25),
resist_display varchar(25));
INSERT INTO resists VALUES('fire', 'Fire', 'Fire');
INSERT INTO resists VALUES('cold', 'Cold', 'Cold');
INSERT INTO resists VALUES('acid', 'Acid', 'Acid');

INSERT INTO item_types VALUES('trash', 'TRASH', 'Trash');
INSERT INTO item_types VALUES('other', 'OTHER', 'Other');
INSERT INTO item_types VALUES('teleport', 'TELEPORT', 'Teleport');
CREATE TABLE zones(
	zone_abbr varchar(25) PRIMARY KEY
	,zone_name varchar(150)
);
INSERT INTO zones VALUES('SF', 'Southern Forest');
INSERT INTO zones VALUES('Jot', 'Jotunheim');
INSERT INTO zones VALUES('Monastery', 'Abandoned Monastery');
