G4x6PKht

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