51 lines
2.3 KiB
SQL
51 lines
2.3 KiB
SQL
CREATE TABLE IF NOT EXISTS "country"
|
|
(
|
|
id uuid,
|
|
iso_name char(2) UNIQUE NOT NULL,
|
|
name varchar(45) NOT NULL,
|
|
|
|
primary key (id)
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS "holiday"
|
|
(
|
|
id uuid,
|
|
country char(2) NOT NULL,
|
|
date date NOT NULL,
|
|
name varchar(64) NOT NULL,
|
|
description varchar(512),
|
|
is_state boolean NOT NULL,
|
|
is_religious boolean NOT NULL,
|
|
|
|
primary key (id),
|
|
constraint fk_country_id foreign key (country)
|
|
references country(iso_name) on delete cascade on update cascade
|
|
);
|
|
|
|
INSERT INTO "country" (id, iso_name, name)
|
|
VALUES
|
|
('096ca6c4-5c04-47a4-0063-4b4cc6f6b671', 'HR', 'Croatia'),
|
|
('096ca6c4-5c04-47a4-0063-4b4cc6f6b672', 'US', 'USA'),
|
|
('096ca6c4-5c04-47a4-0063-4b4cc6f6b673', 'FR', 'France'),
|
|
('096ca6c4-5c04-47a4-0063-4b4cc6f6b674', 'GB', 'Great Britain');
|
|
|
|
INSERT INTO "holiday" (id, country, date, name, description, is_state, is_religious)
|
|
VALUES
|
|
('096ca6c4-5c04-47a4-b363-4b4cc6f6b671', 'HR', '2023-01-01', 'Nova godina', '', true, false),
|
|
('096ca6c4-5c04-47a4-b363-4b4cc6f6b672', 'HR', '2023-01-06', 'Sveta tri kralja', '', true, true),
|
|
('096ca6c4-5c04-47a4-b363-4b4cc6f6b673', 'HR', '2023-04-09', 'Uskrs', '', true, true),
|
|
('096ca6c4-5c04-47a4-b363-4b4cc6f6b674', 'HR', '2023-04-10', 'Uskrsni ponedjeljak', '', true, true),
|
|
('096ca6c4-5c04-47a4-b363-4b4cc6f6b675', 'HR', '2023-05-01', 'Praznik rada', '', true, false),
|
|
('096ca6c4-5c04-47a4-b363-4b4cc6f6b676', 'HR', '2023-05-30', 'Dan državnosti', '', true, false),
|
|
('096ca6c4-5c04-47a4-b363-4b4cc6f6b677', 'HR', '2023-06-08', 'Tijelovo', '', true, true),
|
|
('096ca6c4-5c04-47a4-b363-4b4cc6f6b678', 'HR', '2023-06-22', 'Dan antifašističke borbe', '', true, false),
|
|
('096ca6c4-5c04-47a4-b363-4b4cc6f6b679', 'HR', '2023-08-05', 'Dan pobjede i domovinske zahvalnost', '', true, false),
|
|
('096ca6c4-5c04-47a4-b363-4b4cc6f6b680', 'HR', '2023-08-15', 'Velika gospa', '', true, true),
|
|
('096ca6c4-5c04-47a4-b363-4b4cc6f6b681', 'HR', '2023-11-01', 'Dan svih svetih', '', true, true),
|
|
('096ca6c4-5c04-47a4-b363-4b4cc6f6b682', 'HR', '2023-11-18', 'Dan sjećanja na žrtve Domovinskog rata', '', true, false),
|
|
('096ca6c4-5c04-47a4-b363-4b4cc6f6b683', 'HR', '2023-12-25', 'Božić', '', true, true),
|
|
('096ca6c4-5c04-47a4-b363-4b4cc6f6b684', 'HR', '2023-12-26', 'Štefanje', '', true, true);
|
|
|
|
|
|
|