QJENFZKA

1Create
2
3CREATE TABLE Category (CategoryID int(10) NOT NULL AUTO_INCREMENT, Name varchar(255), PRIMARY KEY (CategoryID));
4CREATE TABLE Client (ClientID 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 (ClientID));
5CREATE TABLE Event (EventID int(10) NOT NULL AUTO_INCREMENT, CategoryID 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 (EventID));
6CREATE TABLE `Order` (OrderID int(10) NOT NULL AUTO_INCREMENT, ClientID int(10) NOT NULL, OrderDate date NOT NULL, IsPaid int(1) NOT NULL, PRIMARY KEY (OrderID));
7CREATE TABLE Ticket (TicketID int(10) NOT NULL AUTO_INCREMENT, EventID int(10) NOT NULL, OrderID int(10) NOT NULL, Price numeric(19, 0) NOT NULL, Discount real, PRIMARY KEY (TicketID));
8ALTER TABLE Ticket ADD CONSTRAINT FKTicket454186 FOREIGN KEY (EventID) REFERENCES Event (EventID);
9ALTER TABLE Ticket ADD CONSTRAINT FKTicket554930 FOREIGN KEY (OrderID) REFERENCES `Order` (OrderID);
10ALTER TABLE Event ADD CONSTRAINT FKEvent450393 FOREIGN KEY (CategoryID) REFERENCES Category (CategoryID);
11ALTER TABLE `Order` ADD CONSTRAINT FKOrder286870 FOREIGN KEY (ClientID) REFERENCES Client (ClientID);
12
13
14
15
16Drop:
17ALTER TABLE Ticket DROP FOREIGN KEY FKTicket454186;
18ALTER TABLE Ticket DROP FOREIGN KEY FKTicket554930;
19ALTER TABLE Event DROP FOREIGN KEY FKEvent450393;
20ALTER TABLE `Order` DROP FOREIGN KEY FKOrder286870;
21DROP TABLE IF EXISTS Category;
22DROP TABLE IF EXISTS Client;
23DROP TABLE IF EXISTS Event;
24DROP TABLE IF EXISTS `Order`;
25DROP TABLE IF EXISTS Ticket;