YLq8TsWc

1create database if not exists TravelAgency;
2
3use TravelAgency;
4
5drop table if exists offer;
6
7create table offer(
8		ID int AUTO_INCREMENT NOT NULL,
9		LOCALE varchar(8) NOT NULL,
10		COUNTRY varchar(64) NOT NULL,
11        START_DATE date NOT NULL,
12        END_DATE date NOT NULL,
13        PLACE varchar(64) NOT NULL,
14		PRICE decimal(13,2) NOT NULL,
15		CURRENCY varchar(8) NOT NULL,
16        constraint id_pk PRIMARY KEY (id)
17);