· 6 years ago · Jun 25, 2019, 05:26 AM
1CREATE TABLE IF NOT EXISTS `table_news` (
2 `id_new` INT NULL AUTO_INCREMENT,
3 `name_new` TEXT NOT NULL,
4 `subtitile_new` TEXT NOT NULL,
5 `data_new` DATETIME NOT NULL,
6 `description_new` TEXT NULL,
7 `id_image_new` INT(11) NULL,
8 `id_category` INT(11) NULL,
9 `comments_id` INT(11) NULL,
10 `id_user` INT(11) NULL,
11 `typenew` TEXT NULL,
12 PRIMARY KEY (`id_new`, `id_category`, `comments_id`, `id_user`, `id_image_new`),
13 INDEX `id_category_idx` (`id_category` ASC),
14 INDEX `id_image_new_idx` (`id_image_new` ASC),
15 INDEX `comments_id_idx` (`comments_id` ASC),
16 INDEX `id_user_idx` (`id_user` ASC),
17 CONSTRAINT `id_category`
18 FOREIGN KEY (`id_category`)
19 REFERENCES `table_category` (`id_category`)
20 ON DELETE NO ACTION
21 ON UPDATE NO ACTION,
22 CONSTRAINT `id_image_new`
23 FOREIGN KEY (`id_image_new`)
24 REFERENCES `table_images` (`id_image_new`)
25 ON DELETE NO ACTION
26 ON UPDATE NO ACTION,
27 CONSTRAINT `comments_id`
28 FOREIGN KEY (`comments_id`)
29 REFERENCES `table_comments` (`id_comment`)
30 ON DELETE NO ACTION
31 ON UPDATE NO ACTION,
32 CONSTRAINT `id_user`
33 FOREIGN KEY (`id_user`)
34 REFERENCES `table_comments` (`user_id`)
35 ON DELETE NO ACTION
36 ON UPDATE NO ACTION)
37ENGINE = InnoDB;
38
39CREATE TABLE IF NOT EXISTS `table_comments` (
40 `id_comment` INT(11) NULL,
41 `comments_id` INT(11) NOT NULL,
42 `comments` VARCHAR(255) NOT NULL,
43 `user_id` INT(11) NULL,
44 `data_comment` DATE NOT NULL,
45 PRIMARY KEY (`id_comment`),
46 INDEX `user_id_idx` (`user_id` ASC),
47 CONSTRAINT `user_id`
48 FOREIGN KEY (`user_id`)
49 REFERENCES `user_table` (`user_id`)
50 ON DELETE NO ACTION
51 ON UPDATE NO ACTION)
52ENGINE = InnoDB;
53
54CREATE TABLE IF NOT EXISTS `user_table` (
55 `user_id` INT(11) NULL AUTO_INCREMENT,
56 `username` VARCHAR(50) NOT NULL,
57 `password` VARCHAR(255) NOT NULL,
58 `user_email` VARCHAR(255) NOT NULL,
59 `name_user` VARCHAR(55) NOT NULL,
60 `lastname_user` VARCHAR(55) NOT NULL,
61 `user_type` TEXT NOT NULL,
62 PRIMARY KEY (`user_id`))
63ENGINE = InnoDB;
64
65<br />
66<b>Fatal error</b>: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'PRIMARY' in C:xampphtdocsportalphpclassUser.Class.php:89
67Stack trace:
68#0 C:xampphtdocsportalphpclassUser.Class.php(89): PDOStatement->execute()
69#1 C:xampphtdocsportalphpdatacommentUser.php(34): User->publicarComentario('1', 'fdsfsddf', '1')
70#2 {main}
71 thrown in <b>C:xampphtdocsportalphpclassUser.Class.php</b> on line <b>89</b><br />