sql/init/Panier.sql

   1 \p CREATE TABLE Panier
   2 CREATE CACHED TABLE "Panier"
   3   ( ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL
   4   , date DATE NOT NULL
   5   , client INTEGER NOT NULL
   6   , facture INTEGER
   7   , CONSTRAINT "PK_Panier" PRIMARY KEY(ID)
   8   );
   9 ALTER TABLE "Panier"
  10   ADD CONSTRAINT "FK_Panier_facture" FOREIGN KEY(facture) REFERENCES "Facture"(ID)
  11   ON UPDATE CASCADE;
  12 ALTER TABLE "Panier"
  13   ADD CONSTRAINT "FK_Panier_client" FOREIGN KEY(client) REFERENCES "Client"(ID)
  14   ON UPDATE CASCADE;