viet

USE Hamster;

CREATE TABLE User (
  ID        INT AUTO_INCREMENT PRIMARY KEY,
  FirstName VARCHAR(255),
  LastName  VARCHAR(255),
  Birthday  DATE,
  Email     VARCHAR(255) UNIQUE
)ENGINE=INNODB;

CREATE TABLE Place (
  ID          INT AUTO_INCREMENT  PRIMARY KEY,
  Name        VARCHAR(255),
  Description VARCHAR(255),
  Location    VARCHAR(255),
  URL         VARCHAR(255)
)ENGINE=INNODB;

CREATE TABLE Event (
  ID          INT AUTO_INCREMENT PRIMARY KEY,
  Name        VARCHAR(255),
  Description VARCHAR(255),
  Date        DATETIME,
  Picture     VARCHAR(255)
)ENGINE=INNODB;


CREATE TABLE Sponsor (
  ID    INT AUTO_INCREMENT PRIMARY KEY,
  Name  VARCHAR(255),
  Email VARCHAR(255)
)ENGINE=INNODB;

CREATE TABLE Mood (
  Name VARCHAR(30) PRIMARY KEY
)ENGINE=INNODB;

CREATE TABLE Tag (
  Name        VARCHAR(30) PRIMARY KEY,
  Description VARCHAR(255)
)ENGINE=INNODB;

CREATE TABLE EventLikes (
  UserID   INT,
  EventID  INT,
  MoodN     VARCHAR(30),
  Location VARCHAR(255),
  PRIMARY KEY (UserID,EventID),
  FOREIGN KEY (MoodN) REFERENCES Mood(Name)
)ENGINE=INNODB;

CREATE TABLE PlaceLikes (
  UserID   INT,
  PlaceID  INT,
  Mood     VARCHAR(30),
  Location VARCHAR(255),
  FOREIGN KEY (UserID) REFERENCES User(UserID),
  FOREIGN KEY (PlaceID) REFERENCES Place(PlaceID),
  FOREIGN KEY (Mood) REFERENCES Mood(Mood)
)ENGINE=INNODB;


CREATE TABLE PlaceTags (
  PlaceID INT PRIMARY KEY,
  Tag     VARCHAR(30),
  FOREIGN KEY (Tag)
  REFERENCES Tag (Name)
)ENGINE=INNODB;

CREATE TABLE EventTags (
  EventID INT PRIMARY KEY,
  Tag     VARCHAR(30),
  FOREIGN KEY (Tag)
  REFERENCES Tag (Name)
)ENGINE=INNODB;

CREATE TABLE Tariff (
  TariffID INT PRIMARY KEY,
  Amount   INT,
  Term     INT,
  Is_VIP   BOOLEAN
)ENGINE=INNODB;

CREATE TABLE Payment (
  PaymentID        INT PRIMARY KEY,
  Payment_date     TIMESTAMP,
  Expir_date  DATETIME,
  TariffID         INT,
  FOREIGN KEY (TariffID)
    REFERENCES Tariff (TariffID)
)ENGINE=INNODB;

CREATE TABLE SponsorPayments (
  SponsorID INT,
  PaymentID INT PRIMARY KEY
)ENGINE=INNODB;

CREATE TABLE SponsorPlaces (
  SponsorID INT,
  PlaceID   INT PRIMARY KEY
)ENGINE=INNODB;

CREATE TABLE SponsorEvents (
  SponsorID INT,
  EventID   INT PRIMARY KEY
)ENGINE=INNODB;

USE test;

CREATE TABLE Sale(
    sale_id CHAR(40),
    PRIMARY KEY(sale_id),
    discount DOUBLE,
    type VARCHAR(255),
    price DOUBLE
) ENGINE=INNODB;

CREATE TABLE Normal_Sale(
    sale_id CHAR(40),
    PRIMARY KEY(sale_id),
    FOREIGN KEY (sale_id) REFERENCES Sale(sale_id)
) ENGINE=INNODB;

CREATE TABLE Special_Sale(
    sale_id CHAR(40),
    PRIMARY KEY(sale_id),
    FOREIGN KEY (sale_id) REFERENCES Sale(sale_id)
) ENGINE=INNODB;