export.sql

-- H2 2.1.214; 
;              
CREATE USER IF NOT EXISTS "SA" SALT '41d33bd02fe12dff' HASH '13b105e206a45ed12235fb479772abcdf15992c13cc1319cbc872df90affa11d' ADMIN;          
CREATE CACHED TABLE "PUBLIC"."CART"(
    "ID" BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1 RESTART WITH 3) NOT NULL,
    "USER_ID" BIGINT
);           
ALTER TABLE "PUBLIC"."CART" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_1" PRIMARY KEY("ID");          
-- 2 +/- SELECT COUNT(*) FROM PUBLIC.CART;     
INSERT INTO "PUBLIC"."CART" VALUES
(1, 1),
(2, 2);             
CREATE CACHED TABLE "PUBLIC"."CART_PRODUCTS"(
    "CART_ID" BIGINT NOT NULL,
    "NUMBER" INTEGER,
    "PRODUCT_ID" BIGINT NOT NULL
);         
ALTER TABLE "PUBLIC"."CART_PRODUCTS" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_3" PRIMARY KEY("CART_ID", "PRODUCT_ID");              
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CART_PRODUCTS;            
CREATE CACHED TABLE "PUBLIC"."PRODUCT"(
    "ID" BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1 RESTART WITH 8) NOT NULL,
    "NAME" CHARACTER VARYING(255),
    "PRICE" FLOAT(53) NOT NULL
);           
ALTER TABLE "PUBLIC"."PRODUCT" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_18" PRIMARY KEY("ID");      
-- 6 +/- SELECT COUNT(*) FROM PUBLIC.PRODUCT;  
INSERT INTO "PUBLIC"."PRODUCT" VALUES
(1, U&'C\00f3mo entrenar a tu drag\00f3n', 6.7),
(2, 'Lo imposible', 4.99),
(3, 'Shrek 3', 12.75),
(4, 'Terminator', 3.75),
(6, 'Inside Out', 3.0),
(7, U&'Harry Potter y la orden del f\00e9nix', 12.5);
CREATE CACHED TABLE "PUBLIC"."USERS"(
    "ID" BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1 RESTART WITH 3) NOT NULL,
    "PASSWORD" CHARACTER VARYING(255),
    "ROLE" CHARACTER VARYING(255),
    "USERNAME" CHARACTER VARYING(255)
);               
ALTER TABLE "PUBLIC"."USERS" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_4" PRIMARY KEY("ID");         
-- 2 +/- SELECT COUNT(*) FROM PUBLIC.USERS;    
INSERT INTO "PUBLIC"."USERS" VALUES
(1, '$2a$10$RKhNTHlflD3zvqLSDjkJwOijIfTadXKCNkHjX8w411Cpjrp9fEaM.', 'admin', 'admin'),
(2, '$2a$10$wIufVON2MXxa74BPqj802uWtOznGsPQX5X/KFfNt7EWU4fRi8o.F.', 'user', 'user');
ALTER TABLE "PUBLIC"."CART" ADD CONSTRAINT "PUBLIC"."UK_9EMLP6M95V5ER2BCQKJSW48HE" UNIQUE("USER_ID");          
ALTER TABLE "PUBLIC"."CART" ADD CONSTRAINT "PUBLIC"."FKG5UHI8VPSUY0LGLOXK2H4W5O6" FOREIGN KEY("USER_ID") REFERENCES "PUBLIC"."USERS"("ID") NOCHECK;            
ALTER TABLE "PUBLIC"."CART_PRODUCTS" ADD CONSTRAINT "PUBLIC"."FKNLHJC091RDU9K5C8U9XWP280W" FOREIGN KEY("CART_ID") REFERENCES "PUBLIC"."CART"("ID") NOCHECK;    
ALTER TABLE "PUBLIC"."CART_PRODUCTS" ADD CONSTRAINT "PUBLIC"."FKH72X9G1EXPJJCNYXGLWHBV4XU" FOREIGN KEY("PRODUCT_ID") REFERENCES "PUBLIC"."PRODUCT"("ID") NOCHECK;