1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54
| /************************************************/
/* CREATION TABLE ECOLE AVEC TRIGGER */
/************************************************/
CREATE TABLE tb_ecole (
pk_ecole INTEGER NOT NULL,
nom_ecole VARCHAR(30),
date_debut_ecole VARCHAR(25),
date_fin_ecole VARCHAR(25),
CONSTRAINT CT_PK_ECOLE PRIMARY KEY (PK_ECOLE)
);
SET TERM ^ ;
CREATE TRIGGER TRI_BEF_INSE_TB_ECOLE FOR TB_ECOLE
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
IF(new.pk_ecole IS NULL) THEN
new.pk_ecole=GEN_ID(gen_tb_ecole,1);
END
^
COMMIT WORK ^
SET TERM ;^
COMMIT;
/************************************************/
/* CREATION TABLE SECTION AVEC TRIGGER */
/************************************************/
CREATE TABLE TB_SECTION
(
PK_SECTION INTEGER NOT NULL,
NOM_SECTION VARCHAR(30) NOT NULL,
FK_ECOLE_SECTION INTEGER NOT NULL,
CONSTRAINT CT_AK_UN_NOM_SECTION_TB_SECTI UNIQUE (NOM_SECTION),
CONSTRAINT CT_PK_TB_SECTION PRIMARY KEY (PK_SECTION),
CONSTRAINT ct_fk_ecole_section FOREIGN KEY (fk_ecole_section) REFERENCES TB_ECOLE (PK_ECOLE)
);
Erreur
Unsuccessful metadata update
object TB_ECOLE is in use
Statement: CREATE TABLE TB_SECTION
(
PK_SECTION INTEGER NOT NULL,
NOM_SECTION VARCHAR(30) NOT NULL,
FK_ECOLE_SECTION INTEGER NOT NULL,
CONSTRAINT CT_AK_UN_NOM_SECTION_TB_SECTI UNIQUE (NOM_SECTION),
CONSTRAINT CT_PK_TB_SECTION PRIMARY KEY (PK_SECTION),
CONSTRAINT CT_FK_ECOLE_SECTION FOREIGN KEY (FK_ECOLE_SECTION) REFERENCES TB_ECOLE (PK_ECOLE)
) |
Partager