6HwLgMW5

1CREATE
2
3CREATE TABLE Category (ID_Category int(10) NOT NULL AUTO_INCREMENT, Name varchar(255), PRIMARY KEY (ID_Category));
4CREATE TABLE Client (ID_Client int(10) NOT NULL AUTO_INCREMENT, Name varchar(255) NOT NULL, Surname varchar(255) NOT NULL, Email varchar(255) NOT NULL, Phone int(10) NOT NULL, Login varchar(255) NOT NULL, Password varchar(255) NOT NULL, IsAdmin int(1) NOT NULL, PRIMARY KEY (ID_Client));
5CREATE TABLE Event (ID_Event int(10) NOT NULL AUTO_INCREMENT, ID_Category int(10) NOT NULL, Name varchar(255) NOT NULL, EventDate date NOT NULL, EventAddress varchar(255), AmountOfTickets int(6) NOT NULL, Description varchar(255), PRIMARY KEY (ID_Event));
6CREATE TABLE `Order` (ID_Order int(10) NOT NULL AUTO_INCREMENT, ID_Client int(10) NOT NULL, OrderDate date NOT NULL, IsPaid int(1) NOT NULL, PRIMARY KEY (ID_Order));
7CREATE TABLE Ticket (ID_Ticket int(10) NOT NULL AUTO_INCREMENT, ID_Event int(10) NOT NULL, ID_Order int(10) NOT NULL, Price numeric(19, 0) NOT NULL, Discount real, PRIMARY KEY (ID_Ticket));
8ALTER TABLE Ticket ADD CONSTRAINT FKTicket150311 FOREIGN KEY (ID_Event) REFERENCES Event (ID_Event);
9ALTER TABLE Ticket ADD CONSTRAINT FKTicket494750 FOREIGN KEY (ID_Order) REFERENCES `Order` (ID_Order);
10ALTER TABLE Event ADD CONSTRAINT FKEvent86712 FOREIGN KEY (ID_Category) REFERENCES Category (ID_Category);
11ALTER TABLE `Order` ADD CONSTRAINT FKOrder486917 FOREIGN KEY (ID_Client) REFERENCES Client (ID_Client);
12
13
14DROP
15
16ALTER TABLE Ticket DROP FOREIGN KEY FKTicket150311;
17ALTER TABLE Ticket DROP FOREIGN KEY FKTicket494750;
18ALTER TABLE Event DROP FOREIGN KEY FKEvent86712;
19ALTER TABLE `Order` DROP FOREIGN KEY FKOrder486917;
20DROP TABLE IF EXISTS Category;
21DROP TABLE IF EXISTS Client;
22DROP TABLE IF EXISTS Event;
23DROP TABLE IF EXISTS `Order`;
24DROP TABLE IF EXISTS Ticket;