CREATE TABLE gameEvents (
 ID CHAR(1) NOT NULL PRIMARY KEY,
 title VARCHAR(20) NOT NULL UNIQUE KEY,
 javaClass VARCHAR(100) NOT NULL
);

INSERT INTO gameEvents
 VALUES ('Z', 'Zap Attack', 'com.tootsville.game.ZapAttack');

ALTER TABLE roomList ADD COLUMN gameEvent CHAR(1) NULL DEFAULT NULL;
ALTER TABLE roomList ADD CONSTRAINT FOREIGN KEY (gameEvent) REFERENCES gameEvents (ID);

ALTER TABLE roomList DROP KEY title;
ALTER TABLE roomList CHANGE COLUMN moniker moniker VARCHAR(50) NOT NULL UNIQUE KEY;

INSERT INTO roomList (moniker, filename, skyVisible, gameEvent, title)
 VALUES
 ('moonbaseTrans', 'moonbaseTrans.swf', 'N', NULL, 'Moonbase Transporter'),
 ('zapLobby', 'zapLobby.swf', 'N', NULL, 'Zap Attack Bridge'),
 ('zapArena1', 'zapArena1.swf', 'N', 'Z', 'Zap Attack'),
 ('zapArena2', 'zapArena2.swf', 'N', 'Z', 'Zap Attack'),
 ('zapArena3', 'zapArena3.swf', 'N', 'Z', 'Zap Attack'),
 ('zapArena4', 'zapArena4.swf', 'N', 'Z', 'Zap Attack');

