sql/init/Stock.sql

   1 \p CREATE TABLE Stock
   2 CREATE CACHED TABLE "Stock"
   3   ( ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL
   4   , lieu INTEGER NOT NULL
   5   , produit INTEGER NOT NULL
   6   , quantité DECIMAL(100,3) DEFAULT 1.000 NOT NULL
   7   , CONSTRAINT "Stock_PK" PRIMARY KEY(ID)
   8   );
   9 ALTER TABLE "Stock"
  10   ADD CONSTRAINT "Stock_lieu_FK" FOREIGN KEY(lieu) REFERENCES "Lieu"(ID)
  11   ON UPDATE CASCADE;
  12 ALTER TABLE "Stock"
  13   ADD CONSTRAINT "Stock_produit_FK" FOREIGN KEY(produit) REFERENCES "Produit"(ID)
  14   ON UPDATE CASCADE;