4TCJPYTm

1CREATE TABLE IF NOT EXISTS `tb_category` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `id_parent` int(11) NOT NULL,
4  `eng_title` varchar(255) NOT NULL,
5  `title` varchar(255) NOT NULL,
6  `image` varchar(63) NOT NULL,
7  PRIMARY KEY (`id`),
8) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
9	
10CREATE TABLE parent (
11    id INT NOT NULL,
12    PRIMARY KEY (id)
13) ENGINE=INNODB;
14
15CREATE TABLE child (
16    id INT,
17    parent_id INT,
18    INDEX par_ind (parent_id),
19    FOREIGN KEY (parent_id)
20        REFERENCES parent(id)
21        ON DELETE CASCADE
22) ENGINE=INNODB;
23	
24CREATE TABLE just_table (
25    id INT,
26    parent_id INT,
27    INDEX par_ind (parent_id),
28    FOREIGN KEY (parent_id)
29        REFERENCES just_table(id)
30        ON DELETE CASCADE
31) ENGINE=INNODB;
32	
33alter table `tb_category` add foreign key (`id`) references `tb_category`(`id_parent`) ON DELETE CASCADE;