SQLite format 3@    MzpZM Calculon /Judge John Whitey Morbo'John Zoidfarb'John Zoidberg+Ogden Wernstrom)Al Gore's Head)Zapp BranniganLrrr Leo Wong'Barbados Slim IIx`?j)%Phillip J. FryDelivery boyLNot to be confused with the Philip J. Fry from Hovering Squid World 97ae5Scruffy ScruffingtonJanitordf'!Hermes ConradBureaucratdg Amy WongInterndh-Jo#5Scruffy ScruffingtonJanitor'!Hermes ConradBureaucrat' Amy WongIntern -John A. ZoidbergPhysician5 Hubert J. FarnsworthCEON %= Bender Bending RodriguezRobotL' Turanga LeelaCaptain'    ! iQ!Undeclared?9!Undeclared!Undeclared !Undeclared !Undeclaredd !Undeclared !Undeclared !Undeclared!Undeclared/A bucket of krill!Undeclared        ~WYtableClientClientCREATE TABLE Client ( AccountNumber INTEGER PRIMARY KEY NOT NULL, Name TEXT NOT NULL )VtableEmployeeEmployeeCREATE TABLE Employee ( EmployeeID INTEGER PRIMARY KEY NOT NULL, Name TEXT NOT NULL, Position TEXT NOT NULL, Salary REAL NOT NULL, Remarks TEXT )k''tableHas_ClearanceHas_ClearanceCREATE TABLE Has_Clearance ( Employee INTEGER NOT NULL CONSTRAINT fk_Employee_EmployeeID REFERENCES Employee(EmployeeID), Planet INTEGER NOT NULL CONSTRAINT fk_Planet_PlanetID REFERENCES Planet(PlanetID), Level INTEGER NOT NULL, PRIMARY KEY(Employee, Planet) )9M'indexsqlite_autoindex_Has_Clearance_1Has_Clearance 1`('tablePackagePackageCREATE TABLE Package ( Shipment INTEGER NOT NULL CONSTRAINT fk_Shipment_ShipmentID REFERENCES Shipment(ShipmentID), PackageNumber INTEGER NOT NULL, Contents TEXT NOT NULL, Weight REAL NOT NULL, Sender INTEGER NOT NULL CONSTRAINT fk_Client_AccountNumber REFERENCES Client(AccountNumber), Recipient INTEGER NOT NULL CONSTRAINT fk_Client_AccountNumber REFERENCES Client(AccountNumber), PRIMARY KEY(Shipment, PackageNumber) )-Aindexsqlite_autoindex_Package_1PackagetablePlanetPlanet CREATE TABLE Planet ( PlanetID INTEGER PRIMARY KEY NOT NULL, Name TEXT NOT NULL, Coordinates REAL NOT NULL )   kP6  AmazoniaB.xRWO3%Nintenduu 64A`bz'Tarantulon VIAS -eM-Omicron Persei 8AU$Ek G!DogDoo VIIB.X`?!CannibalonAÀOmega IIIAw/{MarsA~yDecapod XB.wn !11/05/3004!11/04/3004   hXtableShipmentShipment CREATE TABLE Shipment ( ShipmentID INTEGER PRIMARY KEY NOT NULL, Date TEXT, Manager INTEGER NOT NULL CONSTRAINT fk_Employee_EmployeeID REFERENCES Employee(EmployeeID), Planet INTEGER NOT NULL CONSTRAINT fk_Planet_PlanetID REFERENCES Planet(PlanetID) ) i-triggerfkd_Has_Clearance_Employee_Employee_EmployeeIDEmployeeCREATE TRIGGER fkd_Has_Clearance_Employee_Employee_EmployeeID BEFORE DELETE ON Employee FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'delete on table "Employee" violates foreign key constraint "fkd_Has_Clearance_Employee_Employee_EmployeeID"') WHERE (SELECT Employee FROM Has_Clearance WHERE Employee = OLD.EmployeeID) IS NOT NULL; END {w ]triggerfkd_Has_Clearance_Planet_Planet_PlanetIDPlanetCREATE TRIGGER fkd_Has_Clearance_Planet_Planet_PlanetID BEFORE DELETE ON Planet FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'delete on table "Planet" violates foreign key constraint "fkd_Has_Clearance_Planet_Planet_PlanetID"') WHERE (SELECT Planet FROM Has_Clearance WHERE Planet = OLD.PlanetID) IS NOT NULL; END atriggerfkd_Package_Recipient_Client_AccountNumberClientCREATE TRIGGER fkd_Package_Recipient_Client_AccountNumber BEFORE DELETE ON Client FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'delete on table "Client" violates foreign key constraint "fkd_Package_Recipient_Client_AccountNumber"') WHERE (SELECT Recipient FROM Package WHERE Recipient = OLD.AccountNumber) IS NOT NULL; END   s [{triggerfkd_Package_Sender_Client_AccountNumberClientCREATE TRIGGER fkd_Package_Sender_Client_AccountNumber BEFORE DELETE ON Client FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'delete on table "Client" violates foreign key constraint "fkd_Package_Sender_Client_AccountNumber"') WHERE (SELECT Sender FROM Package WHERE Sender = OLD.AccountNumber) IS NOT NULL; END} ] triggerfkd_Package_Shipment_Shipment_ShipmentIDShipmentCREATE TRIGGER fkd_Package_Shipment_Shipment_ShipmentID BEFORE DELETE ON Shipment FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'delete on table "Shipment" violates foreign key constraint "fkd_Package_Shipment_Shipment_ShipmentID"') WHERE (SELECT Shipment FROM Package WHERE Shipment = OLD.ShipmentID) IS NOT NULL; END |]triggerfkd_Shipment_Manager_Employee_EmployeeIDEmployeeCREATE TRIGGER fkd_Shipment_Manager_Employee_EmployeeID BEFORE DELETE ON Employee FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'delete on table "Employee" violates foreign key constraint "fkd_Shipment_Manager_Employee_EmployeeID"') WHERE (SELECT Manager FROM Shipment WHERE Manager = OLD.EmployeeID) IS NOT NULL; ENDcSctriggerfkd_Shipment_Planet_Planet_PlanetIDPlanetCREATE TRIGGER fkd_Shipment_Planet_Planet_PlanetID BEFORE DELETE ON Planet FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'delete on table "Planet" violates foreign key constraint "fkd_Shipment_Planet_Planet_PlanetID"') WHERE (SELECT Planet FROM Shipment WHERE Planet = OLD.PlanetID) IS NOT NULL; END xi'7triggerfki_Has_Clearance_Employee_Employee_EmployeeIDHas_ClearanceCREATE TRIGGER fki_Has_Clearance_Employee_Employee_EmployeeID BEFORE INSERT ON [Has_Clearance] FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'insert on table "Has_Clearance" violates foreign key constraint "fki_Has_Clearance_Employee_Employee_EmployeeID"') WHERE (SELECT EmployeeID FROM Employee WHERE EmployeeID = NEW.Employee) IS NULL; END]'triggerfki_Has_Clearance_Planet_Planet_PlanetIDHas_ClearanceCREATE TRIGGER fki_Has_Clearance_Planet_Planet_PlanetID BEFORE INSERT ON [Has_Clearance] FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'insert on table "Has_Clearance" violates foreign key constraint "fki_Has_Clearance_Planet_Planet_PlanetID"') WHERE (SELECT PlanetID FROM Planet WHERE PlanetID = NEW.Planet) IS NULL; END atriggerfki_Package_Recipient_Client_AccountNumberPackageCREATE TRIGGER fki_Package_Recipient_Client_AccountNumber BEFORE INSERT ON [Package] FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'insert on table "Package" violates foreign key constraint "fki_Package_Recipient_Client_AccountNumber"') WHERE (SELECT AccountNumber FROM Client WHERE AccountNumber = NEW.Recipient) IS NULL; ENDz[triggerfki_Package_Sender_Client_AccountNumberPackageCREATE TRIGGER fki_Package_Sender_Client_AccountNumber BEFORE INSERT ON [Package] FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'insert on table "Package" violates foreign key constraint "fki_Package_Sender_Client_AccountNumber"') WHERE (SELECT AccountNumber FROM Client WHERE AccountNumber = NEW.Sender) IS NULL; END {]triggerfki_Package_Shipment_Shipment_ShipmentIDPackageCREATE TRIGGER fki_Package_Shipment_Shipment_ShipmentID BEFORE INSERT ON [Package] FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'insert on table "Package" violates foreign key constraint "fki_Package_Shipment_Shipment_ShipmentID"') WHERE (SELECT ShipmentID FROM Shipment WHERE ShipmentID = NEW.Shipment) IS NULL; END}] triggerfki_Shipment_Manager_Employee_EmployeeIDShipmentCREATE TRIGGER fki_Shipment_Manager_Employee_EmployeeID BEFORE INSERT ON [Shipment] FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'insert on table "Shipment" violates foreign key constraint "fki_Shipment_Manager_Employee_EmployeeID"') WHERE (SELECT EmployeeID FROM Employee WHERE EmployeeID = NEW.Manager) IS NULL; END XgSgtriggerfki_Shipment_Planet_Planet_PlanetIDShipmentCREATE TRIGGER fki_Shipment_Planet_Planet_PlanetID BEFORE INSERT ON [Shipment] FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'insert on table "Shipment" violates foreign key constraint "fki_Shipment_Planet_Planet_PlanetID"') WHERE (SELECT PlanetID FROM Planet WHERE PlanetID = NEW.Planet) IS NULL; END%i'Ctriggerfku_Has_Clearance_Employee_Employee_EmployeeIDHas_ClearanceCREATE TRIGGER fku_Has_Clearance_Employee_Employee_EmployeeID BEFORE UPDATE ON [Has_Clearance] FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'update on table "Has_Clearance" violates foreign key constraint "fku_Has_Clearance_Employee_Employee_EmployeeID"') WHERE (SELECT EmployeeID FROM Employee WHERE EmployeeID = NEW.Employee) IS NULL; END q ]'triggerfku_Has_Clearance_Planet_Planet_PlanetIDHas_ClearanceCREATE TRIGGER fku_Has_Clearance_Planet_Planet_PlanetID BEFORE UPDATE ON [Has_Clearance] FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'update on table "Has_Clearance" violates foreign key constraint "fku_Has_Clearance_Planet_Planet_PlanetID"') WHERE (SELECT PlanetID FROM Planet WHERE PlanetID = NEW.Planet) IS NULL; END a%triggerfku_Package_Recipient_Client_AccountNumberPackageCREATE TRIGGER fku_Package_Recipient_Client_AccountNumber BEFORE UPDATE ON [Package] FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'update on table "Package" violates foreign key constraint "fku_Package_Recipient_Client_AccountNumber"') WHERE (SELECT AccountNumber FROM Client WHERE AccountNumber = NEW.Recipient) IS NULL; END |[triggerfku_Package_Sender_Client_AccountNumberPackageCREATE TRIGGER fku_Package_Sender_Client_AccountNumber BEFORE UPDATE ON [Package] FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'update on table "Package" violates foreign key constraint "fku_Package_Sender_Client_AccountNumber"') WHERE (SELECT AccountNumber FROM Client WHERE AccountNumber = NEW.Sender) IS NULL; END]triggerfku_Package_Shipment_Shipment_ShipmentIDPackageCREATE TRIGGER fku_Package_Shipment_Shipment_ShipmentID BEFORE UPDATE ON [Package] FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'update on table "Package" violates foreign key constraint "fku_Package_Shipment_Shipment_ShipmentID"') WHERE (SELECT ShipmentID FROM Shipment WHERE ShipmentID = NEW.Shipment) IS NULL; END  z mSstriggerfku_Shipment_Planet_Planet_PlanetIDShipmentCREATE TRIGGER fku_Shipment_Planet_Planet_PlanetID BEFORE UPDATE ON [Shipment] FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'update on table "Shipment" violates foreign key constraint "fku_Shipment_Planet_Planet_PlanetID"') WHERE (SELECT PlanetID FROM Planet WHERE PlanetID = NEW.Planet) IS NULL; END]triggerfku_Shipment_Manager_Employee_EmployeeIDShipmentCREATE TRIGGER fku_Shipment_Manager_Employee_EmployeeID BEFORE UPDATE ON [Shipment] FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'update on table "Shipment" violates foreign key constraint "fku_Shipment_Manager_Employee_EmployeeID"') WHERE (SELECT EmployeeID FROM Employee WHERE EmployeeID = NEW.Manager) IS NULL; END