CREATE TABLE play (
  id                 VARCHAR(255) NOT NULL,
  theater            VARCHAR(255) NOT NULL,
  date               VARCHAR(255) NOT NULL,
  reservationEndDate VARCHAR(255) NOT NULL,
  show               VARCHAR(255) NOT NULL,
  PRIMARY KEY (id),
  FOREIGN KEY (theater) REFERENCES theater (id),
  FOREIGN KEY (show) REFERENCES show (id)
);

CREATE TABLE play_price (
  id        VARCHAR(255) NOT NULL,
  name      VARCHAR(255) NOT NULL,
  value     NUMERIC      NOT NULL,
  condition TEXT         NULL,
  play      VARCHAR(255) NOT NULL,
  PRIMARY KEY (id),
  FOREIGN KEY (play) REFERENCES play (id)
)
CREATE TABLE play (
  id                 VARCHAR(255) NOT NULL,
  theater            VARCHAR(255) NOT NULL,
  date               TIMESTAMP NOT NULL,
  reservationEndDate TIMESTAMP NOT NULL,
  show               VARCHAR(255) NOT NULL,
  PRIMARY KEY (id),
  FOREIGN KEY (theater) REFERENCES theater (id),
  FOREIGN KEY (show) REFERENCES show (id)
);

CREATE TABLE play_price (
  id        VARCHAR(255) NOT NULL,
  name      VARCHAR(255) NOT NULL,
  value     NUMERIC      NOT NULL,
  condition TEXT         NULL,
  play      VARCHAR(255) NOT NULL,
  PRIMARY KEY (id),
  FOREIGN KEY (play) REFERENCES play (id)
)
Correct the script creating tables for plays
Correct the script creating tables for plays

The date were defined as `varchar`, but dates should not be managed as it.
This commit changes the script to accept timestamp instead.

This script was updated instead of creating another file
because there is no other person currently developing the application
and no distribution was done.
