SET DATABASE UNIQUE NAME HSQLDB9665464260
SET DATABASE DEFAULT RESULT MEMORY ROWS 0
SET DATABASE EVENT LOG LEVEL 0
SET DATABASE TRANSACTION CONTROL LOCKS
SET DATABASE DEFAULT ISOLATION LEVEL READ COMMITTED
SET DATABASE TRANSACTION ROLLBACK ON CONFLICT TRUE
SET DATABASE TEXT TABLE DEFAULTS ''
SET DATABASE SQL NAMES FALSE
SET DATABASE SQL RESTRICT EXEC FALSE
SET DATABASE SQL REFERENCES FALSE
SET DATABASE SQL SIZE TRUE
SET DATABASE SQL TYPES FALSE
SET DATABASE SQL TDC DELETE TRUE
SET DATABASE SQL TDC UPDATE TRUE
SET DATABASE SQL SYS INDEX NAMES TRUE
SET DATABASE SQL CONCAT NULLS TRUE
SET DATABASE SQL UNIQUE NULLS TRUE
SET DATABASE SQL CONVERT TRUNCATE TRUE
SET DATABASE SQL AVG SCALE 0
SET DATABASE SQL DOUBLE NAN TRUE
SET FILES WRITE DELAY 500 MILLIS
SET FILES BACKUP INCREMENT TRUE
SET FILES CACHE SIZE 10000
SET FILES CACHE ROWS 50000
SET FILES SCALE 32
SET FILES LOB SCALE 32
SET FILES DEFRAG 0
SET FILES NIO TRUE
SET FILES NIO SIZE 256
SET FILES LOG TRUE
SET FILES LOG SIZE 50
SET FILES CHECK 11676
ALTER CATALOG PUBLIC RENAME TO D
SET DATABASE COLLATION "French" PAD SPACE
CREATE USER SA PASSWORD DIGEST 'd41d8cd98f00b204e9800998ecf8427e'
ALTER USER SA SET LOCAL TRUE
CREATE SCHEMA B AUTHORIZATION DBA
CREATE CACHED TABLE B."Produit"(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL,NOM VARCHAR(100) NOT NULL,UNIT\u00c9 VARCHAR(100),QUANTIT\u00c9 DECIMAL(100,3) DEFAULT 1.000 NOT NULL,CONDITIONNEMENT VARCHAR(100),CONSTRAINT "PK_Produit" PRIMARY KEY(ID))
ALTER TABLE B."Produit" ALTER COLUMN ID RESTART WITH 37
CREATE CACHED TABLE B."Ingr\u00e9dient"(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL,PRODUIT INTEGER NOT NULL,CONSO INTEGER NOT NULL,QUANTIT\u00c9 DECIMAL(100,3) DEFAULT 1.000 NOT NULL,CONSTRAINT "PK_Ingr\u00e9dient" PRIMARY KEY(ID),CONSTRAINT "Un produit ne se liste pas lui-m\u00eame comme consommation" CHECK(B."Ingr\u00e9dient".PRODUIT!=B."Ingr\u00e9dient".CONSO),CONSTRAINT "FK_Ingr\u00e9dient_produit" FOREIGN KEY(PRODUIT) REFERENCES B."Produit"(ID) ON UPDATE CASCADE,CONSTRAINT "FK_Ingr\u00e9dient_conso" FOREIGN KEY(CONSO) REFERENCES B."Produit"(ID) ON UPDATE CASCADE)
ALTER TABLE B."Ingr\u00e9dient" ALTER COLUMN ID RESTART WITH 2
CREATE UNIQUE INDEX "Ingr\u00e9dient_index_produit_et_conso" ON B."Ingr\u00e9dient"(PRODUIT,CONSO)
CREATE CACHED TABLE B."Lieu"(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL,NOM VARCHAR(100) NOT NULL,CONSTRAINT "PK_Lieu" PRIMARY KEY(ID))
ALTER TABLE B."Lieu" ALTER COLUMN ID RESTART WITH 10
CREATE CACHED TABLE B."Client"(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL,NOM VARCHAR(100) NOT NULL,LIEU INTEGER NOT NULL,T\u00c9L VARCHAR(100),M\u00c9L VARCHAR(100),CONSTRAINT "PK_Client" PRIMARY KEY(ID),CONSTRAINT "FK_Client_lieu" FOREIGN KEY(LIEU) REFERENCES B."Lieu"(ID) ON UPDATE CASCADE)
ALTER TABLE B."Client" ALTER COLUMN ID RESTART WITH 3
CREATE CACHED TABLE B."P\u00e9riode"(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL,NOM VARCHAR(100) NOT NULL,CONSTRAINT "PK_P\u00e9riode" PRIMARY KEY(ID))
ALTER TABLE B."P\u00e9riode" ALTER COLUMN ID RESTART WITH 8
CREATE CACHED TABLE B."Abonnement"(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL,CLIENT INTEGER NOT NULL,LIEU INTEGER,P\u00c9RIODE INTEGER NOT NULL,PRODUIT INTEGER NOT NULL,QUANTIT\u00c9 DECIMAL(100,3) DEFAULT 1.000 NOT NULL,CONSTRAINT "PK_Abonnement" PRIMARY KEY(ID),CONSTRAINT "FK_Abonnement_client" FOREIGN KEY(CLIENT) REFERENCES B."Client"(ID) ON DELETE CASCADE,CONSTRAINT "FK_Abonnement_produit" FOREIGN KEY(PRODUIT) REFERENCES B."Produit"(ID) ON UPDATE CASCADE,CONSTRAINT "FK_Abonnement_p\u00e9riode" FOREIGN KEY(P\u00c9RIODE) REFERENCES B."P\u00e9riode"(ID) ON UPDATE CASCADE,CONSTRAINT "FK_Abonnement_lieu" FOREIGN KEY(LIEU) REFERENCES B."Lieu"(ID) ON UPDATE CASCADE)
ALTER TABLE B."Abonnement" ALTER COLUMN ID RESTART WITH 4
CREATE CACHED TABLE B."Facture"(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL,DATE INTEGER NOT NULL,CONSTRAINT "PK_Facture" PRIMARY KEY(ID))
ALTER TABLE B."Facture" ALTER COLUMN ID RESTART WITH 0
CREATE CACHED TABLE B."Panier"(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL,DATE DATE NOT NULL,CLIENT INTEGER NOT NULL,FACTURE INTEGER,CONSTRAINT "PK_Panier" PRIMARY KEY(ID),CONSTRAINT "FK_Panier_facture" FOREIGN KEY(FACTURE) REFERENCES B."Facture"(ID) ON UPDATE CASCADE,CONSTRAINT "FK_Panier_client" FOREIGN KEY(CLIENT) REFERENCES B."Client"(ID) ON UPDATE CASCADE)
ALTER TABLE B."Panier" ALTER COLUMN ID RESTART WITH 5
CREATE CACHED TABLE B."Vente"(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL,PRODUIT INTEGER NOT NULL,QUANTIT\u00c9 DECIMAL(100,3) DEFAULT 1.000 NOT NULL,PANIER INTEGER NOT NULL,CONSTRAINT "PK_Vente" PRIMARY KEY(ID),CONSTRAINT "FK_Vente_produit" FOREIGN KEY(PRODUIT) REFERENCES B."Produit"(ID) ON UPDATE CASCADE,CONSTRAINT "FK_Vente_panier" FOREIGN KEY(PANIER) REFERENCES B."Panier"(ID) ON UPDATE CASCADE)
ALTER TABLE B."Vente" ALTER COLUMN ID RESTART WITH 7
CREATE CACHED TABLE B."Stock"(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL,LIEU INTEGER NOT NULL,PRODUIT INTEGER NOT NULL,QUANTIT\u00c9 DECIMAL(100,3) DEFAULT 1.000 NOT NULL,CONSTRAINT "PK_Stock" PRIMARY KEY(ID),CONSTRAINT "FK_Stock_lieu" FOREIGN KEY(LIEU) REFERENCES B."Lieu"(ID) ON UPDATE CASCADE,CONSTRAINT "FK_Stock_produit" FOREIGN KEY(PRODUIT) REFERENCES B."Produit"(ID) ON UPDATE CASCADE)
ALTER TABLE B."Stock" ALTER COLUMN ID RESTART WITH 0
CREATE CACHED TABLE B."Prix"(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL,DATE DATE NOT NULL,PRODUIT INTEGER NOT NULL,EUROS DECIMAL(100,2) DEFAULT 0.00 NOT NULL,CONSTRAINT "PK_Prix" PRIMARY KEY(ID))
ALTER TABLE B."Prix" ALTER COLUMN ID RESTART WITH 9
CREATE PROCEDURE B.INSERTVENTE(IN VENTEDATE DATE,IN VENTECLIENT INTEGER,IN VENTEPRODUIT INTEGER,IN VENTEQUANTIT\u00c9 DECIMAL(128)) SPECIFIC INSERTVENTE_14705 LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA NEW SAVEPOINT LEVEL BEGIN ATOMIC DECLARE PANIERID INTEGER DEFAULT NULL;DECLARE VENTEID INTEGER DEFAULT NULL;SET PANIERID=SELECT ID FROM B."Panier" WHERE "Panier".DATE=VENTEDATE AND "Panier".CLIENT=VENTECLIENT;IF PANIERID IS NULL THEN INSERT INTO B."Panier"(DATE,CLIENT)VALUES(VENTEDATE,VENTECLIENT);SET PANIERID=IDENTITY();END IF;SET VENTEID=SELECT ID FROM B."Vente" WHERE "Vente".PANIER=PANIERID AND "Vente".PRODUIT=VENTEPRODUIT;IF VENTEID IS NULL THEN INSERT INTO B."Vente"(PANIER,PRODUIT,QUANTIT\u00c9)VALUES(PANIERID,VENTEPRODUIT,VENTEQUANTIT\u00c9);END IF;END
CREATE PROCEDURE B.INSERTVENTESPARABONNEMENT(IN FINALDATE DATE) SPECIFIC INSERTVENTESPARABONNEMENT_14709 LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA NEW SAVEPOINT LEVEL BEGIN ATOMIC FOR_DAYS:FOR SELECT DAY FROM UNNEST(SEQUENCE_ARRAY(DATE'2025-04-07',FINALDATE,1 DAY))WITH ORDINALITY AS T(DAY,I)DO FOR_ABOS:FOR SELECT ID AS ABOID,CLIENT AS ABOCLIENT,PRODUIT AS ABOPRODUIT,QUANTIT\u00c9 AS ABOQUANTIT\u00c9,P\u00c9RIODE AS ABOP FROM B."Abonnement" JOIN B."P\u00e9riode" ON "P\u00e9riode".ID="Abonnement".P\u00c9RIODE AND "P\u00e9riode".NOM=DAYNAME(DAY)DO CALL INSERTVENTE(DAY,ABOCLIENT,ABOPRODUIT,ABOQUANTIT\u00c9);END FOR FOR_ABOS;END FOR FOR_DAYS;END
ALTER SEQUENCE SYSTEM_LOBS.LOB_ID RESTART WITH 1
SET DATABASE DEFAULT INITIAL SCHEMA B
SET TABLE B."Produit" INDEX '3977 0 37'
SET TABLE B."Ingr\u00e9dient" INDEX '4077 4077 4077 4077 0 0 0 0 1'
SET TABLE B."Lieu" INDEX '3922 0 10'
SET TABLE B."Client" INDEX '4056 4056 0 0 3'
SET TABLE B."P\u00e9riode" INDEX '4045 0 7'
SET TABLE B."Abonnement" INDEX '4065 4065 4065 4065 4065 0 0 0 0 0 4'
SET TABLE B."Panier" INDEX '4100 4100 4100 0 0 0 5'
SET TABLE B."Vente" INDEX '4112 4106 4112 0 0 0 7'
SET TABLE B."Prix" INDEX '4086 0 9'
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CARDINAL_NUMBER TO PUBLIC
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.YES_OR_NO TO PUBLIC
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CHARACTER_DATA TO PUBLIC
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.SQL_IDENTIFIER TO PUBLIC
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.TIME_STAMP TO PUBLIC
GRANT DBA TO SA
SET SCHEMA SYSTEM_LOBS
INSERT INTO BLOCKS VALUES(0,2147483647,0)