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
|
--Table: MATERIAU
--DROP TABLE MATERIAU;
CREATE TABLE MATERIAU (
ID INTEGER NOT NULL,
DESIGNATION VARCHAR(70),
UNITE VARCHAR(3),
PRIX DECIMAL(9,3),
COND DECIMAL(6,3),
MARGE DECIMAL(3,3),
STOCK_MINI DECIMAL(9,3),
FAMILLE VARCHAR(20),
PRIX_DE_VENTE DECIMAL(6,2),
EMPLACEMENT VARCHAR(20),
PRIX_VENTE_FIXE INTEGER,
Q_STOCK DECIMAL(9,3),
COMMENTAIRE VARCHAR(200),
STOCK_MAXI DECIMAL(9,3),
GERER_EN_STOCK INTEGER,
TEST NUMERIC(5,1) DEFAULT NULL,
/* Clés */
PRIMARY KEY (ID)
);
SET TERM ^ ;
CREATE TRIGGER MATERIAU_BI FOR MATERIAU
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
IF (NEW.ID IS NULL) THEN
NEW.ID = GEN_ID(GEN_MATERIAU_ID,1);
END^
SET TERM ; ^ |
Partager