DROP TABLE IF EXISTS location;

CREATE TABLE location 
(
    id int(10) NOT NULL auto_increment,

    date datetime NOT NULL,
    title char(50) NOT NULL,
    location varchar(100) NOT NULL,

    PRIMARY KEY (id),
    UNIQUE KEY (date, title)
);
