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 INTEGER NOT NULL
   5   , facture INTEGER NOT NULL
   6   , client INTEGER NOT NULL
   7   , CONSTRAINT "Panier_PK" PRIMARY KEY(ID)
   8   );
   9 ALTER TABLE "Panier"
  10   ADD CONSTRAINT "Panier_facture_FK" FOREIGN KEY(facture) REFERENCES "Facture"(ID)
  11   ON UPDATE CASCADE;
  12 ALTER TABLE "Panier"
  13   ADD CONSTRAINT "Panier_client_FK" FOREIGN KEY(client) REFERENCES "Client"(ID)
  14   ON UPDATE CASCADE;