** This file contains an SQLite 2.1 database **(uãÚ € ¸€ ,.tableagent_specialtyagent_specialty6CREATE TABLE agent_specialty ( agent_specialtyID INTEGER PRIMARY KEY, agentID int, specialtyID int )4 ¸€   "¸tablephonelistphonelist8CREATE table phonelist ( id INTEGER PRIMARY KEY, firstname VARCHAR(15), lastname VARCHAR(15), email VARCHAR(20), phone VARCHAR(15) )€Ä$ € Bond1D € Falcon1d€ Cardinal2„€Blackford2  € Rahab3€James Bland29<à € Rahab3ü € Rahab3 €  Rahab34 €  Rahab3 €  Rahab3°ôP7€07Dancing ElephantInfiltrate suspicious zooLondon¤A€5AEnduring AngstMake bad guys feel really guiltyLower Volta€|@€6@Furious DandelionPlant crabgrass in enemy lawnsEast Java Ð(€ElectronicsP€Counterintelligencel € SabotageŒ€Doily Design¬€Explosives€Flower Arranging0° €128€13P€21h€26€€32˜€44€45Pp(U€ .?OURahabElectronics, CounterintelligenceRaging DandelionPlant CrabgrassSudanÜ[€):T[Gold ElbowSabatoge, Doily designDancing ElephantInfiltrate suspicious zooLondonDW€"3PWFalconCounterintelligenceDancing ElephantInfiltrate suspicious circusLondon¬U€(IUCardinalSabatogeEnduring AngstMake bad guys feel really guiltyLower Voltaj€.=^jBlackfordExplosives, Flower arrangingEnduring AngstMake bad guys feel really guiltyLower Votla/Ø„H0€ '0AndyHarrisaharris@cs.iupui.edu123-4567*€ !*JoeSlowjslow@noplace.net987-6543|Ø”z€ ztableagentagent3CREATE TABLE agent ( agentID INTEGER PRIMARY KEY, name varchar(50), operationID int )9P«€  "«tableoperationoperation4CREATE TABLE operation ( operationID INTEGER PRIMARY KEY, name varchar(50), description varchar(50), location varchar(50) )|w€  "wtablespecialtyspecialty5CREATE TABLE specialty ( specialtyID INTEGER PRIMARY KEY, name varchar(50) )(ŒìÓ€ Ótablebadspybadspy7CREATE TABLE badspy ( agentID INTEGER PRIMARY KEY, name varchar(30), specialty varchar(40), assignment varchar(40), description varchar(40), location varchar(20) )ÐÑ€  #Ñtableadventureadventure12CREATE TABLE adventure ( id INTEGER PRIMARY KEY, name varchar(20), description varchar(200), north int(11), east int(11), south int(11), west int(11) )4«€  «tableherohero11CREATE TABLE hero ( id INTEGER PRIMARY KEY, name varchar(30), power varchar(30), weapon varchar(30), transportation varchar(30) )|tœ\C€*8CProfessor OneEarthquake generationLaser PointerBinary Cow|œ.€%.Bat WormSuper SpeedWorm beltBat taxiôH€&6HMillennium PantherDeath BreathPanther BulletsPanther SubmarineLF€&7FLightning GuardianElectric ToeGuardian MisslesGuardian Moped9>€0>Yak-BotSuper YurtYakbutter flamethrowerYak DirigibledD ˆn€behknjump outYou decide to jump out of the box, but you are cornered at the end of the wharf.15191515«€ ¢¥§©«wait with enigmaYou wait, but the sailors discover that enigma is missing and scour the sub for it. You are discovered and cast out in the torpedo tube.15000|¼TH-€ %')+-lostYou cannot go that way!1000¸^€VXZ\^startYou are at a submarine yard, looking for the famous Enigma code machine0302`˜€Œ’•˜sub deckAs you step on the submarine deck, a guard approaches you. Your only choice is to jump off the sub before you are caught.15151515àp€hjlnpwarehouseYou wait inside the warehouse. You see a doorway to the south and a box to the east.0450L\€RTWY\doorwayYou walked right into a group of guards. It does not look good...019015Ü€€ xz|~€boxYou crawl inside the box and wait. Suddenly, you feel the box being picked up and carried across the wharf!6007f€ ^`bdfwait..You wait until the box settles in a dark space. You can move forward or aft...8090¬Œs€gjmpsforwardAs you move forward, two rough sailors grab you and hurl you out of the conning tower.15151515k€  _behkaftIn a darkened room, you see the enigma device. How will you get it out of the sub?13111012´™€ “•—™signal on enigmaYou use the enigma device to send a signal. Allied forces recognize your signal and surround the ship when it surfaces14000òS€ JMOQSshoot your way outA gunfight on a submerged sub is a bad idea...19000ÿèP̱€ ¨«­¯±replace enigma and wYou put the enigma back in place and wait patiently, but you never get another chance. You are discovered when the sub pulls in to harbor.19000‘|8Y€ QSUWYWinCongratulations! You have captured the device and shortened the war!1000ˆ3œQ€HKMOQWaterYou are in the water. The sub moves away. It looks bad...19000ÿÿÿÀ€ 0000ä€ 0000€ 00006€.0246Game OverThe game is over. You lose.10009°on WHERE agent.operationID = operation.operationIDÄðØ€  +-Øviewagent_operationagent_operation0CREATE VIEW agent_operation AS SELECT agent.name as 'agent', operation.name as 'operation' FROM agent, operation WHERE agent.operationID = operation.operationIDÌÉ€  ÉviewagOpViewagOpView0CREATE VIEW agOpView AS SELECT agent.name AS 'agent', operation.name AS 'operation' FROM agent, operation WHERE agent.operationID = operation.operationIDüÈ€ %'viewbetterSpybetterSpy0CREATE VIEW betterSpy AS SELECT agent.name AS 'agent', operation.name AS 'operation', operation.description AS 'description', operation.location AS 'location' FROM agent, operati'€ ')'viewagSpecViewagSpecView0CREATE VIEW agSpecView AS SELECT agent.name AS 'agent', specialty.name AS 'specialty' FROM agent, specialty, agent_specialty WHERE agent_specialty.agentID = agent.agent<ID AND agent_specialty.specialtyID = specialty.specialtyID