· 9 years ago · Dec 19, 2016, 07:24 PM
1-- -----------------------------------------------------
2-- Table `yp038645_trash`.`Comments`
3-- -----------------------------------------------------
4CREATE TABLE IF NOT EXISTS `yp038645_trash`.`Comments` (
5`id` INT NOT NULL AUTO_INCREMENT ,
6`Users_id` INT NOT NULL ,
7`comment` TEXT( 500 ) NOT NULL ,
8`date` TIMESTAMP( 12 ) NOT NULL ,
9PRIMARY KEY ( `id` ) ,
10INDEX `fk_Comments_Users1_idx` ( `Users_id` ASC ) ,
11CONSTRAINT `fk_Comments_Users1` FOREIGN KEY ( `Users_id` ) REFERENCES `yp038645_trash`.`Users` (
12`id`
13) ON DELETE NO ACTION ON UPDATE NO ACTION
14) ENGINE = InnoDB;
15
16#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(12) NOT NULL,
17 PRIMARY KEY (`id`),
18 INDEX `fk_Comments_Users1_idx` (`Users_' at line 8