SET TERM; ^
/* Fields descriptions */
COMMENT ON COLUMN BIBLIOTEKOR. NOMER_BIBLIOTEKORYA IS
VALUE gt; 0 raquo ;; ON COLUMN BIBLIOTEKOR. NOMER_OTDELA IS
VALUE gt; 0 raquo ;;
КнігіTABLE KNIGI (_KNIGI D_INDEXTYPE NOT NULL/* D_INDEXTYPE=INTEGER NOT NULL * /, _ OTDELA D_INDEXTYPE/* D_INDEXTYPE=INTEGER NOT NULL * /, _ KNIGI D_NAME/* D_NAME=VARCHAR (45) NOT NULL */, _ VO_STRANIC D_INDEXTYPE/* D_INDEXTYPE=INTEGER NOT NULL * /, D_NAME/* D_NAME=VARCHAR (45) NOT NULL */
);
/***************************************** *******************/
/*** Primary Keys ***/
/***************************************** *******************/TABLE KNIGI ADD CONSTRAINT PK_KNIGI PRIMARY KEY (NOMER_KNIGI);
/***************************************** ******************/
/*** Foreign Keys ***/
/***************************************** *******************/TABLE KNIGI ADD CONSTRAINT FK_KNIGI_1 FOREIGN KEY (NOMER_OTDELA) REFERENCES OTDEL_KNIG (NOMER_OTDELA);
/***************************************** *******************/
/*** Indices ***/
/***************************************** *******************/INDEX _KNIGA ON KNIGI (NAZVANIE_KNIGI);
/***************************************** *******************/
/*** Triggers ***/
/***************************************** *******************/
SET TERM ^;
/***************************************** *******************/
/*** Triggers for tables ***/
/***************************************** *******************/
/* Trigger: KNIGI_BI0 */OR ALTER TRIGGER KNIGI_BI0 FOR KNIGIBEFORE INSERT OR UPDATE POSITION 0 (NEW. nomer_knigi is null) then. nomer_knigi=gen_id (gen_knigi, 1);
^
/* Trigger: KNIGI_HIST_BI0 */OR ALTER TRIGGER KNIGI_HIST_BI0 FOR KNIGI
ACTIVE BEFORE INSERT POSITION 0
ASvariable nomer_knigi_tr smallint; variable nomer_otdela_tr smallint; variable nazvanie_knigi_tr varchar (45); variable kol_vo_stranic_tr smallint; variable avtor_tr varchar (45); variable IZMEN_TR varchar (45); variable DATA_TR date; _TR=current_date; ( inserting) then_TR=current_date; _knigi_tr=new. nomer_knigi; _TR= додавання raquo ;; _ otdela_tr=new. nomer_otdela; _knigi_tr=new. nazvanie_knigi; _vo_stranic_tr=new. kol_vo_stranic; _tr=new. avtor;
^
SET TERM; ^
/* Fields descriptions */
COMMENT ON COLUMN KNIGI. NOMER_KNIGI IS
VALUE gt; 0 raquo ;; ON COLUMN KNIGI. NOMER_OTDELA IS
VALUE gt; 0 raquo ;; ON COLUMN KNIGI. KOL_VO_STRANIC IS
VALUE gt; 0 raquo ;;
Исторя
CREATE TABLE NEW_TABLE (SMALLINT NOT NULL, _KNIGI SMALLINT, _OTDELA SMALLINT, _KNIGI VARCHAR (45), _ VO_STRANIC SMALLINT, VARCHAR (45), VARCHAR (45), _ TR DATE
);
/***************************************** *******************/
/*** Primary Keys ***/
/***************************************** *******************/
ALTER TABLE NEW_TABLE ADD CONSTRAINT PK_NEW_TABLE_1 PRIMARY KEY (ID);
Відділ книг
CREATE TABLE OTDEL_KNIG (_OTDELA D_NAME/* D_NAME=VARCHAR (45) NOT NULL * /, _ OTDELA D_INDEXTYPE NOT NULL/* D_INDEXTYPE=INTEGER NOT NULL * /, _ VO_KNIG D_INDEXTYPE/* D_INDEXTYPE=INTEGER NOT NULL * /, D_TEL/* D_TEL=VARCHAR (15) * /, _ BIBLIOTEKORYA D_INDEXTYPE/* D_INDEXTYPE=INTEGER NOT NULL */
);
/***************************************** *******************/
/*** Primary Keys ***/
/***************************************** *******************/TABLE OTDEL_KNIG ADD CONSTRAINT PK_OTDEL_KNIG PRIMARY KEY (NOMER_OTDELA);
/***************************************** *******************/
/*** Indices ***/
/***************************************** *******************/INDEX NAZV ON OTDEL_KNIG (NAZVANIE_OTDELA);
/***************************************** *******************/
/*** Triggers ***/
/***************************************** *...
