Solved Duplicate entry '0' for key 'PRIMARY'
- Thread starter otfun
- Start date
i solved bro, database execute sql
CREATE TABLE `death_list` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`player_id` int(11) NOT NULL,
`date` bigint(20) unsigned NOT NULL,
`level` int(11) NOT NULL,
`killer_name` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB;
CREATE TABLE `death_list` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`player_id` int(11) NOT NULL,
`date` bigint(20) unsigned NOT NULL,
`level` int(11) NOT NULL,
`killer_name` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB;
