Автоматизация проверки знаний и навыков студентов в области прикладной математики и информатики
Дипломная работа - Компьютеры, программирование
Другие дипломы по предмету Компьютеры, программирование
ed.Test_ID
)@errno = 30005,
@errmsg = Cannot update Tests because User_results exists.ERROR
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* Sections R/8 Tests on child update no action */
/* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="Sections"_OWNER="", CHILD_TABLE="Tests"C_VERB_PHRASE="R/8", C2P_VERB_PHRASE="R/8", _CONSTRAINT="R_8", FK_COLUMNS="Test_section_ID" */
/* %ChildFK(" OR",UPDATE) */(Test_section_ID)@nullcnt = 0@validcnt = count(*)inserted,Sections
/* %JoinFKPK(inserted,Sections) */.Test_section_ID = Sections.Section_id
/* %NotnullFK(inserted," IS NULL","select @nullcnt = count(*) from inserted where"," AND") */@nullcnt = count(*) from inserted where.Test_section_ID IS NULL@validcnt + @nullcnt != @NUMROWS@errno = 30007,
@errmsg = Cannot update Tests because Sections does not exist.ERROR
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */:@errno @errmsgtransactionTRIGGER tD_User_answers ON User_answers FOR DELETE AS
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* DELETE trigger on User_answers */@errno int,
@errmsg varchar(255)
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* User_results R/16 User_answers on child delete no action */
/* ERWIN_RELATION:CHECKSUM="00017376", PARENT_OWNER="", PARENT_TABLE="User_results"_OWNER="", CHILD_TABLE="User_answers"C_VERB_PHRASE="R/16", C2P_VERB_PHRASE="R/16", _CONSTRAINT="R_16", FK_COLUMNS="User_answer_user_result_id" */EXISTS (SELECT * FROM deleted,User_results
/* %JoinFKPK(deleted,User_results," = "," AND") */.User_answer_user_result_id = User_results.User_result_id ANDEXISTS (* FROM User_answers
/* %JoinFKPK(User_answers,User_results," = "," AND") */_answers.User_answer_user_result_id = User_results.User_result_id
)
)@errno = 30010,
@errmsg = Cannot delete last User_answers because User_results exists.ERROR
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */:@errno @errmsgtransactionTRIGGER tU_User_answers ON User_answers FOR UPDATE AS
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* UPDATE trigger on User_answers */@NUMROWS int,
@nullcnt int,
@validcnt int,
@insUser_answer_ID int,
@errno int,
@errmsg varchar(255)@NUMROWS = @@rowcount
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* User_results R/16 User_answers on child update no action */
/* ERWIN_RELATION:CHECKSUM="0001ac05", PARENT_OWNER="", PARENT_TABLE="User_results"_OWNER="", CHILD_TABLE="User_answers"C_VERB_PHRASE="R/16", C2P_VERB_PHRASE="R/16", _CONSTRAINT="R_16", FK_COLUMNS="User_answer_user_result_id" */
/* %ChildFK(" OR",UPDATE) */(User_answer_user_result_id)@nullcnt = 0@validcnt = count(*)inserted,User_results
/* %JoinFKPK(inserted,User_results) */.User_answer_user_result_id = User_results.User_result_id
/* %NotnullFK(inserted," IS NULL","select @nullcnt = count(*) from inserted where"," AND") */@nullcnt = count(*) from inserted where.User_answer_user_result_id IS NULL@validcnt + @nullcnt != @NUMROWS@errno = 30007,
@errmsg = Cannot update User_answers because User_results does not exist.ERROR
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */:@errno @errmsgtransactionTRIGGER tD_User_results ON User_results FOR DELETE AS
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* DELETE trigger on User_results */@errno int,
@errmsg varchar(255)
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* User_results R/16 User_answers on parent delete no action */
/* ERWIN_RELATION:CHECKSUM="0003a738", PARENT_OWNER="", PARENT_TABLE="User_results"_OWNER="", CHILD_TABLE="User_answers"C_VERB_PHRASE="R/16", C2P_VERB_PHRASE="R/16", _CONSTRAINT="R_16", FK_COLUMNS="User_answer_user_result_id" */EXISTS (* FROM deleted,User_answers
/* %JoinFKPK(User_answers,deleted," = "," AND") */_answers.User_answer_user_result_id = deleted.User_result_id
)@errno = 30001,
@errmsg = Cannot delete User_results because User_answers exists.ERROR
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* Users R/14 User_results on child delete no action */
/* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="Users"_OWNER="", CHILD_TABLE="User_results"C_VERB_PHRASE="R/14", C2P_VERB_PHRASE="R/14", _CONSTRAINT="R_14", FK_COLUMNS="User_result_User_id" */EXISTS (SELECT * FROM deleted,Users
/* %JoinFKPK(deleted,Users," = "," AND") */.User_result_User_id = Users.User_id ANDEXISTS (* FROM User_results
/* %JoinFKPK(User_results,Users," = "," AND") */_results.User_result_User_id = Users.User_id
)
)@errno = 30010,
@errmsg = Cannot delete last User_results because Users exists.ERROR
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* Tests R/15 User_results on child delete no action */
/* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="Tests"_OWNER="", CHILD_TABLE="User_results"C_VERB_PHRASE="R/15", C2P_VERB_PHRASE="R/15", _CONSTRAINT="R_15", FK_COLUMNS="User_result_test_id" */EXISTS (SELECT * FROM deleted,Tests
/* %JoinFKPK(deleted,Tests," = "," AND") */.User_result_test_id = Tests.Test_ID ANDEXISTS (* FROM User_results
/* %JoinFKPK(User_results,Tests," = "," AND") */_results.User_result_test_id = Tests.Test_ID
)
)@errno = 30010,
@errmsg = Cannot delete last User_results because Tests exists.ERROR
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */:@errno @errmsgtransactionTRIGGER tU_User_results ON User_results FOR UPDATE AS
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* UPDATE trigger on User_results */@NUMROWS int,
@nullcnt int,
@validcnt int,
@insUser_result_id int,
@errno int,
@errmsg varchar(255)
@NUMROWS = @@rowcount
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* User_results R/16 User_answers on parent update no action */
/* ERWIN_RELATION:CHECKSUM="000452af", PARENT_OWNER="", PARENT_TABLE="User_results"_OWNER="", CHILD_TABLE="User_answers"C_VERB_PHRASE="R/16", C2P_VERB_PHRASE="R/16", _CONSTRAINT="R_16", FK_COLUMNS="User_answer_user_result_id" */
/* %ParentPK(" OR",UPDATE) */(User_result_id)EXISTS (* FROM deleted,User_answers
/* %JoinFKPK(User_answers,deleted," = "," AND") */_answers.User_answer_user_result_id = deleted.User_result_id
)@errno = 30005,
@errmsg = Cannot update User_results because User_answers exists.ERROR
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* Users R/14 User_results on child update no action */
/* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="Users"_OWNER="", CHILD_TABLE="User_results"C_VERB_PHRASE="R/14", C2P_VERB_PHRASE="R/14", _CONSTRAINT="R_14", FK_COLUMNS="User_result_User_id" */
/* %ChildFK(" OR",UPDATE) */(User_result_User_id)@nullcnt = 0@validcnt = count(*)inserted,Users
/* %JoinFKPK(inserted,Users) */.User_result_User_id = Users.User_id
/* %NotnullFK(inserted," IS NULL","select @nullcnt = count(*) from inserted where"," AND") */@nullcnt = count(*) from inserted where.User_result_User_id IS NULL@validcnt + @nullcnt != @NUMROWS@errno = 30007,
@errmsg = Cannot update User_results because Users does not exist.ERROR
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* Tests R/15 User_results on child update no action */
/* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="Tests"_OWNER="", CHILD_TABLE="User_results"C_VERB_PHRASE="R/15", C2P_VERB_PHRASE="R/15", _CONSTRAINT="R_15", FK_COLUMNS="User_result_test_id" */
/* %ChildFK(" OR",UPDATE) */(User_result_test_id)@nullcnt = 0@validcnt = count(*)inserted,Tests
/* %JoinFKPK(inserted,Tests) */.User_result_test_id = Tests.Test_ID
/* %NotnullFK(inserted," IS NULL","select @nullcnt = count(*) from inserted where"," AND") */@nullcnt = count(*) from inserted where.User_result_test_id IS NULL@validcnt + @nullcnt != @NUMROWS@errno = 30007,
@errmsg = Cannot update User_results because Tests does not exist.ERROR
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */:@errno @errmsgtransactionTRIGGER tD_Users ON Users FOR DELETE AS
/* ERwin Builtin 2 февраля 2009 г. 2:18:54 */
/* DELETE trigger on Users */@errno int,
@errmsg varcha