ALTER TABLE forum_for_kategory
ADD FOREIGN KEY (id_kategory)
REFERENCES forum_kategory_table(id)

ON UPDATE CASCADE 
ON DELETE CASCADE ;

CREATE TABLE  `test`.`forum_kategory_table` (
`id` INT NOT NULL AUTO_INCREMENT ,
`name_forum_kategory` VARCHAR( 255 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL ,
`position_forum_kategory` INT NOT NULL ,
PRIMARY KEY (  `id` )
) ENGINE = INNODB;

CREATE TABLE  `test`.`forum_for_kategory` (
`id` INT NOT NULL AUTO_INCREMENT ,
`name_for_kategory` VARCHAR( 255 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL ,
`position` INT NOT NULL ,
`id_kategory` INT NOT NULL ,
`description` VARCHAR( 255 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL ,
PRIMARY KEY (  `id` )
) ENGINE = INNODB;

ALTER TABLE forum_for_kategory
ADD FOREIGN KEY (id_kategory)
REFERENCES forum_kategory_table(id)
ON UPDATE CASCADE 
ON DELETE CASCADE ;

CREATE TABLE  `test`.`forum_for_kategory` (
`id` INT NOT NULL AUTO_INCREMENT ,
`name_for_kategory` VARCHAR( 255 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL ,
`position` INT NOT NULL ,
`id_kategory` INT NULL ,
`description` VARCHAR( 255 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL ,
PRIMARY KEY (  `id` )
) ENGINE = INNODB;

CREATE TABLE  `test`.`forum_kategory_table` (
`id` INT NOT NULL AUTO_INCREMENT ,
`name_forum_kategory` VARCHAR( 255 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL ,
`position_forum_kategory` INT NOT NULL ,
PRIMARY KEY (  `id` )
) ENGINE = INNODB;

NSERT INTO  `forum_kategory_table` 
SET  `name_forum_kategory` =  'Первая категория форума',
`position_forum_kategory` =  '1';

CREATE TABLE  `test`.`forum_for_kategory` (
`id` INT NOT NULL AUTO_INCREMENT ,
`name_for_kategory` VARCHAR( 255 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL ,
`position` INT NOT NULL ,
`id_kategory` INT NOT NULL ,
`description` VARCHAR( 255 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL ,
PRIMARY KEY (  `id` )
) ENGINE = INNODB;

INSERT INTO  `romanzorin`.`forum_for_kategory` (
`id` ,
`name_for_kategory` ,
`position` ,
`id_kategory` ,
`description`
)
VALUES (
NULL ,  'имя',  '1',  '1',  'описание'
);

--
-- Структура таблицы `forum_kategory_table`
--

CREATE TABLE IF NOT EXISTS `forum_kategory_table` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name_forum_kategory` varchar(255) NOT NULL,
  `position_forum_kategory` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Дамп данных таблицы `forum_kategory_table`
--

INSERT INTO `forum_kategory_table` (`id`, `name_forum_kategory`, `position_forum_kategory`) VALUES
(1, 'Первая категория форума', 1);

--
-- Структура таблицы `forum_for_kategory`
--

CREATE TABLE IF NOT EXISTS `forum_for_kategory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name_for_kategory` varchar(255) NOT NULL,
  `position` int(11) NOT NULL,
  `id_kategory` int(11) NOT NULL,
  `description` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Дамп данных таблицы `forum_for_kategory`
--

INSERT INTO `forum_for_kategory` (`id`, `name_for_kategory`, `position`, `id_kategory`, `description`) VALUES
(1, 'бла-бла-бла', 1, 1, 'вфыв'),
(2, 'бла-бла2-бла', 1, 0, '2вфыв'),
(3, 'бла-бла-бла', 0, 0, 'вфыв');

--
-- Структура таблицы `forum_kategory_table`
--

CREATE TABLE IF NOT EXISTS `forum_kategory_table` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name_forum_kategory` varchar(255) NOT NULL,
  `position_forum_kategory` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Дамп данных таблицы `forum_kategory_table`
--

INSERT INTO `forum_kategory_table` (`id`, `name_forum_kategory`, `position_forum_kategory`) VALUES
(1, 'Первая категория форума', 1);

--
-- Структура таблицы `forum_for_kategory`
--

CREATE TABLE IF NOT EXISTS `forum_for_kategory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name_for_kategory` varchar(255) NOT NULL,
  `position` int(11) NOT NULL,
  `id_kategory` int(11) NOT NULL,
  `description` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id_kategory` (`id_kategory`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Дамп данных таблицы `forum_for_kategory`
--

INSERT INTO `forum_for_kategory` (`id`, `name_for_kategory`, `position`, `id_kategory`, `description`) VALUES
(4, 'имя', 123, 1, 'дескрипшин');

--
-- Ограничения внешнего ключа сохраненных таблиц
--

ALTER TABLE `forum_for_kategory` ADD INDEX ( `id_kategory` );

--
-- Ограничения внешнего ключа таблицы `forum_for_kategory`
--
ALTER TABLE `forum_for_kategory` ADD CONSTRAINT `tree_fk_1` FOREIGN KEY (`id_kategory`) REFERENCES `forum_kategory_table` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

ALTER TABLE `forum_for_kategory` ADD INDEX ( `id_kategory` );

ALTER TABLE `forum_for_kategory` ADD CONSTRAINT `tree_fk_1` FOREIGN KEY (`id_kategory`) REFERENCES `forum_kategory_table` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

CONSTRAINT `tree_fk_1`