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
| SET SQL DIALECT 3;
CREATE DATABASE 'c:\Base\TEST'
PAGE_SIZE 4096
DEFAULT CHARACTER SET NONE;
/* Table: BL_ENTETE, Owner: SYSDBA */
CREATE TABLE "BL_ENTETE"
(
"BLE_ID" INTEGER NOT NULL,
"BLE_NO" VARCHAR(32),
"CLT_ID" INTEGER NOT NULL,
CONSTRAINT "PK_BL_ENTETE" PRIMARY KEY ("BLE_ID")
);
/* Table: BL_LIGNE, Owner: SYSDBA */
CREATE TABLE "BL_LIGNE"
(
"BLL_ID" INTEGER NOT NULL,
"BLE_ID" INTEGER NOT NULL,
"LCT_ID" INTEGER NOT NULL,
CONSTRAINT "PK_BL_LIGNE" PRIMARY KEY ("BLL_ID")
);
/* Table: LANCEMENT, Owner: SYSDBA */
CREATE TABLE "LANCEMENT"
(
"LCT_ID" INTEGER NOT NULL,
"OFR_ID" INTEGER NOT NULL,
"CDE_ID" INTEGER NOT NULL,
"ETAT_ID" INTEGER NOT NULL,
CONSTRAINT "PK_LANCEMENT" PRIMARY KEY ("LCT_ID")
);
/* Table: OFFRE, Owner: SYSDBA */
CREATE TABLE "OFFRE"
(
"OFR_ID" INTEGER NOT NULL,
"NO_OFFRE" VARCHAR(32) NOT NULL,
CONSTRAINT "PK_OFFRE" PRIMARY KEY ("OFR_ID")
);
/* Index definitions for all user tables */
CREATE INDEX "IDX_LANCEMENT_1" ON "LANCEMENT"("CDE_ID");
CREATE INDEX "IDX_LANCEMENT_2" ON "LANCEMENT"("ETAT_ID");
ALTER TABLE "BL_LIGNE" ADD CONSTRAINT "FK_BL_LIGNE_1" FOREIGN KEY ("BLE_ID") REFERENCES "BL_ENTETE" ("BLE_ID") ON UPDATE CASCADE ON DELETE NO ACTION;
ALTER TABLE "BL_LIGNE" ADD CONSTRAINT "FK_BL_LIGNE_2" FOREIGN KEY ("LCT_ID") REFERENCES "LANCEMENT" ("LCT_ID") ON UPDATE CASCADE ON DELETE NO ACTION;
ALTER TABLE "LANCEMENT" ADD CONSTRAINT "FK_LANCEMENT_1" FOREIGN KEY ("OFR_ID") REFERENCES "OFFRE" ("OFR_ID") ON UPDATE CASCADE ON DELETE NO ACTION;
ALTER TABLE "LANCEMENT" ADD CONSTRAINT "FK_LANCEMENT_2" FOREIGN KEY ("LCT_ID") REFERENCES "LANCEMENT" ("LCT_ID") ON UPDATE CASCADE ON DELETE NO ACTION; |
Partager