DROP TABLE user_table;
DROP TABLE movieman_table;
DROP TABLE like_table;
DROP TABLE hate_table;

CREATE TABLE user_table (
      seq INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, 
      udid VARCHAR(40) NOT NULL,
      device VARCHAR(10) DEFAULT NULL,
      PRIMARY KEY (seq)
)
ENGINE=InnoDB;

CREATE TABLE movieman_table (
       seq INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
       mname VARCHAR(10) NOT NULL,
       birthday VARCHAR(10) NOT NULL,
       PRIMARY KEY (seq)
)
ENGINE=InnoDB;

CREATE TABLE like_table (
       seq INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
       user_fkey  INT(10) UNSIGNED NOT NULL,
       movieman_fkey INT(10) NOT NULL DEFAULT '0',
       movieman_fkey_str VARCHAR(20) NOT NULL DEFAULT '0',
       created_date DATE NOT NULL,
       PRIMARY KEY (seq),
       FOREIGN KEY (user_fkey) REFERENCES user_table (seq)
       	       ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB;

CREATE TABLE hate_table (
       seq INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
       user_fkey  INT(10) UNSIGNED NOT NULL,
       movieman_fkey INT(10) NOT NULL DEFAULT '0',
       movieman_fkey_str VARCHAR(20) NOT NULL DEFAULT '0',
       created_date DATE NOT NULL,
       PRIMARY KEY (seq),
       FOREIGN KEY (user_fkey) REFERENCES user_table (seq)
       	       ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB;