8kXfQ1ZX

1DROP TABLE SHOPS IF EXISTS;
2DROP TABLE CHOCOLATE IF EXISTS;
3DROP TABLE COMPANIES IF EXISTS;
4DROP TABLE COUNTRIES IF EXISTS;
5CREATE TABLE COUNTRIES (
6IDCOUNTRY INTEGER GENERATED BY DEFAULT AS IDENTITY,
7TITLE VARCHAR(30) NOT NULL,
8CAPITAL VARCHAR(30) NOT NULL,
9PRESIDENT VARCHAR(120) NOT NULL
10);
11//-----------------------------------------—
12CREATE TABLE COMPANIES (
13IDCOMPANY INTEGER GENERATED BY DEFAULT AS IDENTITY,
14IDCOUNTRY INTEGER NOT NULL,
15TITLE VARCHAR(30) NOT NULL,
16YEAR INTEGER NOT NULL,  
17FOREIGN KEY (IDCOUNTRY) REFERENCES COUNTRIES (IDCOUNTRY)
18);
19//------------------------------------—
20CREATE TABLE SHOPS (
21IDSHOP INTEGER GENERATED BY DEFAULT AS IDENTITY,
22CITY VARCHAR(30) NOT NULL,
23ADDRESS VARCHAR(120) NOT NULL,
24PHONE INTEGER NOT NULL
25);
26//------------------------------—
27CREATE TABLE CHOCOLATE (
28IDCHOCOLATE INTEGER NOT NULL,
29IDSHOP INTEGER NOT NULL,
30IDCOMPANY INTEGER NOT NULL,
31TITLE VARCHAR(30) NOT NULL,
32PRICE INTEGER NOT NULL,  
33CALORIES INTEGER NOT NULL,
34PRIMARY KEY (IDSHOP, IDCOMPANY),
35FOREIGN KEY (IDSHOP) REFERENCES SHOPS (IDSHOP),
36FOREIGN KEY (IDCOMPANY) REFERENCES COMPANIES (IDCOMPANY)
37);