.
ДОДАТОК А
Вихідний код системи
/ ***************************************** ********************
***************** /
/ *** Generated by IBExpert 2012.9.2.1 18.06.2013 23:24:13 *** /
/ ***************************************** ********************
***************** / SQL DIALECT 3; NAMES WIN1251; DATABASE «127.0.0.1: C: Documents and Settings Admin Рабочий стіл SMUZ2.FDB »« SYSDBA » PASSWORD «masterkey» _SIZE 16384CHARACTER SET WIN1251;
/ ***************************************** ************************************* /
/ *** Domains *** /
/******************************************************************************/DOMAIN D1024VARCHAR AS (1024); DOMAIN D10CHAR AS (10); DOMAIN D128VARCHAR AS (128); DOMAIN D512VARCHAR AS (512); DOMAIN D60CHAR AS (60); DOMAIN D60VARCHAR AS (60); DOMAIN DATES AS; DOMAIN DOUBLE_PREC ASPRECISION; DOMAIN INTT AS; DOMAIN PRK ASNULL; DOMAIN TIMEST AS;
/ ***************************************** ************************************* /
/ *** Generators *** /
/******************************************************************************/GENERATOR G_ID_ANSWER; GENERATOR G_ID_ANSWER TO 21; GENERATOR G_ID_GROUP; GENERATOR G_ID_GROUP TO 0; GENERATOR G_ID_QUERY; GENERATOR G_ID_QUERY TO 3; GENERATOR G_ID_QUERY_TYPE; GENERATOR G_ID_QUERY_TYPE TO 10; GENERATOR G_ID_RES_ANSWER; GENERATOR G_ID_RES_ANSWER TO 0; GENERATOR G_ID_RES_TEST; GENERATOR G_ID_RES_TEST TO 0; GENERATOR G_ID_SESSION; GENERATOR G_ID_SESSION TO 0; GENERATOR G_ID_TEST; GENERATOR G_ID_TEST TO 1; GENERATOR G_ID_THEM; GENERATOR G_ID_THEM TO 0; GENERATOR G_ID_USER; GENERATOR G_ID_USER TO 0; GENERATOR G_ID_USER_GROUP; GENERATOR G_ID_USER_GROUP TO 0; TERM ^;
/ ***************************************** ************************************* /
/ *** Stored Procedures *** /
/******************************************************************************/PROCEDURE ADD_VARIANT (_ID_QUESTION INTEGER, _TEXT VARCHAR (128), _IS_CORRECT INTEGER, _SCORE DOUBLE PRECISION) (INTEGER); ^ PROCEDURE GENERATE_TRIGGER (_TRIG_TEXT VARCHAR (10000)); ^ PROCEDURE REP_GET_QUERY_TEXT (_ID_QUERY INTEGER) (VARCHAR (512)); ^ PROCEDURE REP_GET_QUESTION_LIST (_ID_TEST INTEGER) (_ID_TEST INTEGER, _ID_QUESTION INTEGER, _NUM INTEGER, _QUESTION_DESCRIPTION VARCHAR (128)); ^ PROCEDURE REP_GET_VARIANT (_QUESTION_NUMBER INTEGER) (_ID_ANSWER INTEGER, _IS_CORRECT INTEGER, _TEXT VARCHAR (128), _SCORE DOUBLE PRECISION, _NUMBER INTEGER, _AUERY_TEXT VARCHAR (512)); ^ PROCEDURE W_ADD_QUERY (_ID_TEST INTEGER) (_ID_QUERY INTEGER); ^ PROCEDURE W_SAVE_QUERY (_ID_QUERY INTEGER, _QUERY_TEXT VARCHAR (512), _TEXT_1 VARCHAR (128), _TEXT_2 VARCHAR (128), _TEXT_3 VARCHAR (128), _TEXT_4 VARCHAR (128), _TEXT_5 VARCHAR (128), _CORRECT_1 VARCHAR (5), _CORRECT_2 VARCHAR (5), _CORRECT_3 ??VARCHAR (5), _CORRECT_4 VARCHAR (5), _CORRECT_5 VARCHAR (5), _SCORE_1 DOUBLE PRECISION, _SCORE_2 DOUBLE PRECISION, _SCORE_3 DOUBLE PRECISION, _SCORE_4 DOUBLE PRECISION, _SCORE_5 DOUBLE PRECISION) (_SUCCESS INTEGER, _MESSAGE VARCHAR (128)); ^ TERM; ^
