SQLite format 3@ ''°"ûöñìçâÝØÓÎÉÄ¿ºµ°!+ )'%#!          ŽŽ 5:{|[tableUserUserCREATE TABLE User ( Username TEXT PRIMARY KEY NOT NULL, Name TEXT NOT NULL, Email TEXT NOT NULL )';indexsqlite_autoindex_User_1Userd!!ƒtableConferenceConferenceCREATE TABLE Conference ( Code INTEGER PRIMARY KEY NOT NULL, Name TEXT NOT NULL, Location TEXT NOT NULL, Admin INTEGER NOT NULL CONSTRAINT fk_User_Username REFERENCES User(Username) )‚--ƒitableProgramCommitteeProgramCommitteeCREATE TABLE ProgramCommittee ( User TEXT NOT NULL CONSTRAINT fk_User_Username REFERENCES User(Username), Conference INTEGER NOT NULL CONSTRAINT fk_Conference_Code REFERENCES Conference(Code), PRIMARY KEY(User, Conference) )?S-indexsqlite_autoindex_ProgramCommittee_1ProgramCommitteectablePaperPaperCREATE TABLE Paper ( Code INTEGER PRIMARY KEY NOT NULL, Title TEXT NOT NULL, Abstract TEXT NOT NULL ) !!bË‚>„WtableAuthorAuthorCREATE TABLE Author ( User TEXT NOT NULL CONSTRAINT fk_User_Username REFERENCES User(Username), Paper INTEGER NOT NULL CONSTRAINT fk_Paper_Code REFERENCES Paper(Code), OrderInPaper INTEGER NOT NULL, Affiliation TEXT NOT NULL, Email TEXT NOT NULL, PRIMARY KEY(User, Paper) )+?indexsqlite_autoindex_Author_1Author ‚9 !!„=tableSubmissionSubmission CREATE TABLE Submission ( Conference INTEGER NOT NULL CONSTRAINT fk_Conference_Code REFERENCES Conference(Code), SubmissionCode INTEGER NOT NULL, Description TEXT NOT NULL, Open BOOLEAN NOT NULL, DueDate DATETIME NOT NULL, PRIMARY KEY(Conference, SubmissionCode) )3 G!indexsqlite_autoindex_Submission_1Submission     ggW̓. ++†tablePaperSubmissionPaperSubmissionCREATE TABLE PaperSubmission ( Conference INTEGER NOT NULL, SubmissionCode INTEGER NOT NULL, Paper INTEGER NOT NULL CONSTRAINT fk_Paper_Code REFERENCES Paper(Code), PDF BLOB NOT NULL, Accepted BOOLEAN, CONSTRAINT fk_Submission_pk FOREIGN KEY(Conference, SubmissionCode) REFERENCES Submission(Conference, SubmissionCode), PRIMARY KEY(Conference, SubmissionCode, Paper) )= Q+indexsqlite_autoindex_PaperSubmission_1PaperSubmission‚s …5tableCanSubmitCanSubmitCREATE TABLE CanSubmit ( Conference INTEGER NOT NULL, SubmissionCode INTEGER NOT NULL, Paper INTEGER NOT NULL CONSTRAINT fk_Paper_Code REFERENCES Paper(Code), CONSTRAINT fk_Submission_pk FOREIGN KEY(Conference, SubmissionCode) REFERENCES Submission(Conference, SubmissionCode), PRIMARY KEY(Conference, SubmissionCode, Paper) )1Eindexsqlite_autoindex_CanSubmit_1CanSubmit     vvg–ƒn‡3tableReviewsReviewsCREATE TABLE Reviews ( User TEXT NOT NULL CONSTRAINT fk_User_Username REFERENCES User(Username), Conference INTEGER NOT NULL, SubmissionCode INTEGER NOT NULL, Paper INTEGER NOT NULL CONSTRAINT fk_Paper_Code REFERENCES Paper(Code), Recommendation INTEGER, Comments TEXT, CONSTRAINT fk_Submission_pk FOREIGN KEY(Conference, SubmissionCode) REFERENCES Submission(Conference, SubmissionCode), PRIMARY KEY(User, Conference, SubmissionCode, Paper) )-Aindexsqlite_autoindex_Reviews_1Reviews‚gQ!„etriggerfki_Conference_Admin_User_UsernameConferenceCREATE TRIGGER fki_Conference_Admin_User_Username BEFORE INSERT ON [Conference] FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'insert on table "Conference" violates foreign key constraint "fki_Conference_Admin_User_Username"') WHERE (SELECT Username FROM User WHERE Username = NEW.Admin) IS NULL; END 33£‚mQ!„qtriggerfku_Conference_Admin_User_UsernameConferenceCREATE TRIGGER fku_Conference_Admin_User_Username BEFORE UPDATE ON [Conference] FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'update on table "Conference" violates foreign key constraint "fku_Conference_Admin_User_Username"') WHERE (SELECT Username FROM User WHERE Username = NEW.Admin) IS NULL; END‚ZQ„Wtriggerfkd_Conference_Admin_User_UsernameUserCREATE TRIGGER fkd_Conference_Admin_User_Username BEFORE DELETE ON User FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'delete on table "User" violates foreign key constraint "fkd_Conference_Admin_User_Username"') WHERE (SELECT Admin FROM Conference WHERE Admin = OLD.Username) IS NOT NULL; END ææpƒ[-…triggerfki_ProgramCommittee_User_User_UsernameProgramCommitteeCREATE TRIGGER fki_ProgramCommittee_User_User_Username BEFORE INSERT ON [ProgramCommittee] FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'insert on table "ProgramCommittee" violates foreign key constraint "fki_ProgramCommittee_User_User_Username"') WHERE (SELECT Username FROM User WHERE Username = NEW.User) IS NULL; ENDƒ [-…triggerfku_ProgramCommittee_User_User_UsernameProgramCommitteeCREATE TRIGGER fku_ProgramCommittee_User_User_Username BEFORE UPDATE ON [ProgramCommittee] FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'update on table "ProgramCommittee" violates foreign key constraint "fku_ProgramCommittee_User_User_Username"') WHERE (SELECT Username FROM User WHERE Username = NEW.User) IS NULL; END êêZ‚m[„striggerfkd_ProgramCommittee_User_User_UsernameUserCREATE TRIGGER fkd_ProgramCommittee_User_User_Username BEFORE DELETE ON User FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'delete on table "User" violates foreign key constraint "fkd_ProgramCommittee_User_User_Username"') WHERE (SELECT User FROM ProgramCommittee WHERE User = OLD.Username) IS NOT NULL; ENDƒ#k-…7triggerfki_ProgramCommittee_Conference_Conference_CodeProgramCommitteeCREATE TRIGGER fki_ProgramCommittee_Conference_Conference_Code BEFORE INSERT ON [ProgramCommittee] FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'insert on table "ProgramCommittee" violates foreign key constraint "fki_ProgramCommittee_Conference_Conference_Code"') WHERE (SELECT Code FROM Conference WHERE Code = NEW.Conference) IS NULL; END ²²^ƒ)k-…Ctriggerfku_ProgramCommittee_Conference_Conference_CodeProgramCommitteeCREATE TRIGGER fku_ProgramCommittee_Conference_Conference_Code BEFORE UPDATE ON [ProgramCommittee] FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'update on table "ProgramCommittee" violates foreign key constraint "fku_ProgramCommittee_Conference_Conference_Code"') WHERE (SELECT Code FROM Conference WHERE Code = NEW.Conference) IS NULL; ENDƒk!…;triggerfkd_ProgramCommittee_Conference_Conference_CodeConferenceCREATE TRIGGER fkd_ProgramCommittee_Conference_Conference_Code BEFORE DELETE ON Conference FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'delete on table "Conference" violates foreign key constraint "fkd_ProgramCommittee_Conference_Conference_Code"') WHERE (SELECT Conference FROM ProgramCommittee WHERE Conference = OLD.Code) IS NOT NULL; END d¸‚KG„?triggerfki_Author_User_User_UsernameAuthorCREATE TRIGGER fki_Author_User_User_Username BEFORE INSERT ON [Author] FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'insert on table "Author" violates foreign key constraint "fki_Author_User_User_Username"') WHERE (SELECT Username FROM User WHERE Username = NEW.User) IS NULL; END‚QG„Ktriggerfku_Author_User_User_UsernameAuthorCREATE TRIGGER fku_Author_User_User_Username BEFORE UPDATE ON [Author] FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'update on table "Author" violates foreign key constraint "fku_Author_User_User_Username"') WHERE (SELECT Username FROM User WHERE Username = NEW.User) IS NULL; END‚EG„7triggerfkd_Author_User_User_UsernameUserCREATE TRIGGER fkd_Author_User_User_Username BEFORE DELETE ON User FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'delete on table "User" violates foreign key constraint "fkd_Author_User_User_Username"') WHERE (SELECT User FROM Author WHERE User = OLD.Username) IS NOT NULL; END 33u½‚?C„+triggerfki_Author_Paper_Paper_CodeAuthorCREATE TRIGGER fki_Author_Paper_Paper_Code BEFORE INSERT ON [Author] FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'insert on table "Author" violates foreign key constraint "fki_Author_Paper_Paper_Code"') WHERE (SELECT Code FROM Paper WHERE Code = NEW.Paper) IS NULL; END‚EC„7triggerfku_Author_Paper_Paper_CodeAuthorCREATE TRIGGER fku_Author_Paper_Paper_Code BEFORE UPDATE ON [Author] FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'update on table "Author" violates foreign key constraint "fku_Author_Paper_Paper_Code"') WHERE (SELECT Code FROM Paper WHERE Code = NEW.Paper) IS NULL; END‚@C„/triggerfkd_Author_Paper_Paper_CodePaperCREATE TRIGGER fkd_Author_Paper_Paper_Code BEFORE DELETE ON Paper FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'delete on table "Paper" violates foreign key constraint "fkd_Author_Paper_Paper_Code"') WHERE (SELECT Paper FROM Author WHERE Paper = OLD.Code) IS NOT NULL; END ööx‚ _!…triggerfki_Submission_Conference_Conference_CodeSubmissionCREATE TRIGGER fki_Submission_Conference_Conference_Code BEFORE INSERT ON [Submission] FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'insert on table "Submission" violates foreign key constraint "fki_Submission_Conference_Conference_Code"') WHERE (SELECT Code FROM Conference WHERE Code = NEW.Conference) IS NULL; ENDƒ!_!…triggerfku_Submission_Conference_Conference_CodeSubmissionCREATE TRIGGER fku_Submission_Conference_Conference_Code BEFORE UPDATE ON [Submission] FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'update on table "Submission" violates foreign key constraint "fku_Submission_Conference_Conference_Code"') WHERE (SELECT Code FROM Conference WHERE Code = NEW.Conference) IS NULL; END þþˆƒ"_!…triggerfkd_Submission_Conference_Conference_CodeConferenceCREATE TRIGGER fkd_Submission_Conference_Conference_Code BEFORE DELETE ON Conference FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'delete on table "Conference" violates foreign key constraint "fkd_Submission_Conference_Conference_Code"') WHERE (SELECT Conference FROM Submission WHERE Conference = OLD.Code) IS NOT NULL; END‚u#U+„striggerfki_PaperSubmission_Paper_Paper_CodePaperSubmissionCREATE TRIGGER fki_PaperSubmission_Paper_Paper_Code BEFORE INSERT ON [PaperSubmission] FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'insert on table "PaperSubmission" violates foreign key constraint "fki_PaperSubmission_Paper_Paper_Code"') WHERE (SELECT Code FROM Paper WHERE Code = NEW.Paper) IS NULL; END ™‚{$U+„triggerfku_PaperSubmission_Paper_Paper_CodePaperSubmissionCREATE TRIGGER fku_PaperSubmission_Paper_Paper_Code BEFORE UPDATE ON [PaperSubmission] FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'update on table "PaperSubmission" violates foreign key constraint "fku_PaperSubmission_Paper_Paper_Code"') WHERE (SELECT Code FROM Paper WHERE Code = NEW.Paper) IS NULL; END‚d%U„etriggerfkd_PaperSubmission_Paper_Paper_CodePaperCREATE TRIGGER fkd_PaperSubmission_Paper_Paper_Code BEFORE DELETE ON Paper FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'delete on table "Paper" violates foreign key constraint "fkd_PaperSubmission_Paper_Paper_Code"') WHERE (SELECT Paper FROM PaperSubmission WHERE Paper = OLD.Code) IS NOT NULL; END RR¦‚Q&I„Ctriggerfki_CanSubmit_Paper_Paper_CodeCanSubmitCREATE TRIGGER fki_CanSubmit_Paper_Paper_Code BEFORE INSERT ON [CanSubmit] FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'insert on table "CanSubmit" violates foreign key constraint "fki_CanSubmit_Paper_Paper_Code"') WHERE (SELECT Code FROM Paper WHERE Code = NEW.Paper) IS NULL; END‚W'I„Otriggerfku_CanSubmit_Paper_Paper_CodeCanSubmitCREATE TRIGGER fku_CanSubmit_Paper_Paper_Code BEFORE UPDATE ON [CanSubmit] FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'update on table "CanSubmit" violates foreign key constraint "fku_CanSubmit_Paper_Paper_Code"') WHERE (SELECT Code FROM Paper WHERE Code = NEW.Paper) IS NULL; END ]]¬‚L(I„Atriggerfkd_CanSubmit_Paper_Paper_CodePaperCREATE TRIGGER fkd_CanSubmit_Paper_Paper_Code BEFORE DELETE ON Paper FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'delete on table "Paper" violates foreign key constraint "fkd_CanSubmit_Paper_Paper_Code"') WHERE (SELECT Paper FROM CanSubmit WHERE Paper = OLD.Code) IS NOT NULL; END‚Q)I„Gtriggerfki_Reviews_User_User_UsernameReviewsCREATE TRIGGER fki_Reviews_User_User_Username BEFORE INSERT ON [Reviews] FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'insert on table "Reviews" violates foreign key constraint "fki_Reviews_User_User_Username"') WHERE (SELECT Username FROM User WHERE Username = NEW.User) IS NULL; END ZZ´‚W*I„Striggerfku_Reviews_User_User_UsernameReviewsCREATE TRIGGER fku_Reviews_User_User_Username BEFORE UPDATE ON [Reviews] FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'update on table "Reviews" violates foreign key constraint "fku_Reviews_User_User_Username"') WHERE (SELECT Username FROM User WHERE Username = NEW.User) IS NULL; END‚I+I„=triggerfkd_Reviews_User_User_UsernameUserCREATE TRIGGER fkd_Reviews_User_User_Username BEFORE DELETE ON User FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'delete on table "User" violates foreign key constraint "fkd_Reviews_User_User_Username"') WHERE (SELECT User FROM Reviews WHERE User = OLD.Username) IS NOT NULL; END #j²#‚D.E„5triggerfkd_Reviews_Paper_Paper_CodePaperCREATE TRIGGER fkd_Reviews_Paper_Paper_Code BEFORE DELETE ON Paper FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'delete on table "Paper" violates foreign key constraint "fkd_Reviews_Paper_Paper_Code"') WHERE (SELECT Paper FROM Reviews WHERE Paper = OLD.Code) IS NOT NULL; END‚E,E„3triggerfki_Reviews_Paper_Paper_CodeReviewsCREATE TRIGGER fki_Reviews_Paper_Paper_Code BEFORE INSERT ON [Reviews] FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'insert on table "Reviews" violates foreign key constraint "fki_Reviews_Paper_Paper_Code"') WHERE (SELECT Code FROM Paper WHERE Code = NEW.Paper) IS NULL; END‚K-E„?triggerfku_Reviews_Paper_Paper_CodeReviewsCREATE TRIGGER fku_Reviews_Paper_Paper_Code BEFORE UPDATE ON [Reviews] FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'update on table "Reviews" violates foreign key constraint "fku_Reviews_Paper_Paper_Code"') WHERE (SELECT Code FROM Paper WHERE Code = NEW.Paper) IS NULL; END