Автоматизация проверки знаний и навыков студентов в области прикладной математики и информатики
Дипломная работа - Компьютеры, программирование
Другие дипломы по предмету Компьютеры, программирование
ARENT_TABLE="Questions"_OWNER="", CHILD_TABLE="Answers"C_VERB_PHRASE="R/6", C2P_VERB_PHRASE="R/6", _CONSTRAINT="R_6", FK_COLUMNS="Answer_question_id" */
/* %ChildFK(" OR",UPDATE) */(Answer_question_id)@nullcnt = 0@validcnt = count(*)inserted,Questions
/* %JoinFKPK(inserted,Questions) */.Answer_question_id = Questions.Question_id
/* %NotnullFK(inserted," IS NULL","select @nullcnt = count(*) from inserted where"," AND") */
@validcnt + @nullcnt != @NUMROWS@errno = 30007,
@errmsg = Cannot update Answers because Questions does not exist.ERROR
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */:@errno @errmsgtransaction
TRIGGER tD_Group_sections ON Group_sections FOR DELETE AS
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* DELETE trigger on Group_sections */@errno int,
@errmsg varchar(255)
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* Sections R/9 Group_sections on child delete no action */
/* ERWIN_RELATION:CHECKSUM="0002881c", PARENT_OWNER="", PARENT_TABLE="Sections"_OWNER="", CHILD_TABLE="Group_sections"C_VERB_PHRASE="R/9", C2P_VERB_PHRASE="R/9", _CONSTRAINT="R_9", FK_COLUMNS="Gs_section_id" */EXISTS (SELECT * FROM deleted,Sections
/* %JoinFKPK(deleted,Sections," = "," AND") */.Gs_section_id = Sections.Section_id ANDEXISTS (* FROM Group_sections
/* %JoinFKPK(Group_sections,Sections," = "," AND") */_sections.Gs_section_id = Sections.Section_id
)
)@errno = 30010,
@errmsg = Cannot delete last Group_sections because Sections exists.ERROR
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* Groups R/10 Group_sections on child delete no action */
/* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="Groups"_OWNER="", CHILD_TABLE="Group_sections"C_VERB_PHRASE="R/10", C2P_VERB_PHRASE="R/10", _CONSTRAINT="R_10", FK_COLUMNS="Gs_groupe_id" */EXISTS (SELECT * FROM deleted,Groups
/* %JoinFKPK(deleted,Groups," = "," AND") */.Gs_groupe_id = Groups.Groupe_id ANDEXISTS (* FROM Group_sections
/* %JoinFKPK(Group_sections,Groups," = "," AND") */_sections.Gs_groupe_id = Groups.Groupe_id
)
)@errno = 30010,
@errmsg = Cannot delete last Group_sections because Groups exists.ERROR
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */:@errno @errmsgtransactionTRIGGER tU_Group_sections ON Group_sections FOR UPDATE AS
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* UPDATE trigger on Group_sections */@NUMROWS int,
@nullcnt int,
@validcnt int,
@insGs_id int,
@errno int,
@errmsg varchar(255)
@NUMROWS = @@rowcount
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* Sections R/9 Group_sections on child update no action */
/* ERWIN_RELATION:CHECKSUM="0002f0e4", PARENT_OWNER="", PARENT_TABLE="Sections"_OWNER="", CHILD_TABLE="Group_sections"C_VERB_PHRASE="R/9", C2P_VERB_PHRASE="R/9", _CONSTRAINT="R_9", FK_COLUMNS="Gs_section_id" */
/* %ChildFK(" OR",UPDATE) */(Gs_section_id)@nullcnt = 0@validcnt = count(*)inserted,Sections
/* %JoinFKPK(inserted,Sections) */.Gs_section_id = Sections.Section_id
/* %NotnullFK(inserted," IS NULL","select @nullcnt = count(*) from inserted where"," AND") */@nullcnt = count(*) from inserted where.Gs_section_id IS NULL@validcnt + @nullcnt != @NUMROWS@errno = 30007,
@errmsg = Cannot update Group_sections because Sections does not exist.ERROR
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* Groups R/10 Group_sections on child update no action */
/* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="Groups"_OWNER="", CHILD_TABLE="Group_sections"C_VERB_PHRASE="R/10", C2P_VERB_PHRASE="R/10", _CONSTRAINT="R_10", FK_COLUMNS="Gs_groupe_id" */
/* %ChildFK(" OR",UPDATE) */(Gs_groupe_id)@nullcnt = 0@validcnt = count(*)inserted,Groups
/* %JoinFKPK(inserted,Groups) */.Gs_groupe_id = Groups.Groupe_id
/* %NotnullFK(inserted," IS NULL","select @nullcnt = count(*) from inserted where"," AND") */@nullcnt = count(*) from inserted where.Gs_groupe_id IS NULL@validcnt + @nullcnt != @NUMROWS@errno = 30007,
@errmsg = Cannot update Group_sections because Groups does not exist.ERROR
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */:@errno @errmsgtransactionTRIGGER tD_Groups ON Groups FOR DELETE AS
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* DELETE trigger on Groups */@errno int,
@errmsg varchar(255)
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* Groups R/7 Users on parent delete cascade */
/* ERWIN_RELATION:CHECKSUM="0001bdd4", PARENT_OWNER="", PARENT_TABLE="Groups"_OWNER="", CHILD_TABLE="Users"C_VERB_PHRASE="R/7", C2P_VERB_PHRASE="R/7", _CONSTRAINT="R_7", FK_COLUMNS="User_group_id" */UsersUsers,deleted
/* %JoinFKPK(Users,deleted," = "," AND") */.User_group_id = deleted.Groupe_id
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* Groups R/10 Group_sections on parent delete no action */
/* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="Groups"_OWNER="", CHILD_TABLE="Group_sections"C_VERB_PHRASE="R/10", C2P_VERB_PHRASE="R/10", _CONSTRAINT="R_10", FK_COLUMNS="Gs_groupe_id" */EXISTS (* FROM deleted,Group_sections
/* %JoinFKPK(Group_sections,deleted," = "," AND") */_sections.Gs_groupe_id = deleted.Groupe_id
)@errno = 30001,
@errmsg = Cannot delete Groups because Group_sections exists.ERROR
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */:@errno @errmsgtransaction
TRIGGER tU_Groups ON Groups FOR UPDATE AS
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* UPDATE trigger on Groups */@NUMROWS int,
@nullcnt int,
@validcnt int,
@insGroupe_id int,
@errno int,
@errmsg varchar(255)
@NUMROWS = @@rowcount
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* Groups R/7 Users on parent update no action */
/* ERWIN_RELATION:CHECKSUM="00022ae6", PARENT_OWNER="", PARENT_TABLE="Groups"_OWNER="", CHILD_TABLE="Users"C_VERB_PHRASE="R/7", C2P_VERB_PHRASE="R/7", _CONSTRAINT="R_7", FK_COLUMNS="User_group_id" */
/* %ParentPK(" OR",UPDATE) */(Groupe_id)EXISTS (* FROM deleted,Users
/* %JoinFKPK(Users,deleted," = "," AND") */.User_group_id = deleted.Groupe_id
)@errno = 30005,
@errmsg = Cannot update Groups because Users exists.ERROR
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* Groups R/10 Group_sections on parent update no action */
/* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="Groups"_OWNER="", CHILD_TABLE="Group_sections"C_VERB_PHRASE="R/10", C2P_VERB_PHRASE="R/10", _CONSTRAINT="R_10", FK_COLUMNS="Gs_groupe_id" */
/* %ParentPK(" OR",UPDATE) */(Groupe_id)EXISTS (* FROM deleted,Group_sections
/* %JoinFKPK(Group_sections,deleted," = "," AND") */_sections.Gs_groupe_id = deleted.Groupe_id
)@errno = 30005,
@errmsg = Cannot update Groups because Group_sections exists.ERROR
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */:@errno @errmsgtransaction
TRIGGER tD_Questions ON Questions FOR DELETE AS
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* DELETE trigger on Questions */@errno int,
@errmsg varchar(255)
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* Questions R/6 Answers on parent delete cascade */
/* ERWIN_RELATION:CHECKSUM="0001fbb8", PARENT_OWNER="", PARENT_TABLE="Questions"_OWNER="", CHILD_TABLE="Answers"C_VERB_PHRASE="R/6", C2P_VERB_PHRASE="R/6", _CONSTRAINT="R_6", FK_COLUMNS="Answer_question_id" */AnswersAnswers,deleted
/* %JoinFKPK(Answers,deleted," = "," AND") */.Answer_question_id = deleted.Question_id
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* Tests R/5 Questions on child delete no action */
/* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="Tests"_OWNER="", CHILD_TABLE="Questions"C_VERB_PHRASE="R/5", C2P_VERB_PHRASE="R/5", _CONSTRAINT="R_5", FK_COLUMNS="Question_test_id" */EXISTS (SELECT * FROM deleted,Tests
/* %JoinFKPK(