ALTER TABLE yii_doc.seo_model_izdelie_image
    DROP FOREIGN KEY seo_model_izdelie_image_ibfk_1
    , MODIFY seo_izdelie_id SMALLINT null
;

# DELETE FROM yii_doc.seo_izdelie
# WHERE alias = '';

alter table yii_doc.seo_izdelie
    modify id smallint unsigned auto_increment
    , modify dok_rubrika_id tinyint unsigned
    , modify dok_podrubrika_id tinyint unsigned
    , modify dok_izdelie_id smallint unsigned
    , modify redirect smallint unsigned
    , modify prior tinyint unsigned
    , modify popular_sort tinyint unsigned
    , modify main_menu BIT(1) DEFAULT 0
    , modify is_hidden BIT(1) NOT NULL DEFAULT 0;

alter table yii_doc.seo_izdelie
    add foreign key (dok_rubrika_id) references yii_doc.dok_rubrika (id)
            on update cascade
    , add foreign key (dok_podrubrika_id) references yii_doc.dok_podrubrica (id)
            on update cascade
    , add foreign key (dok_izdelie_id) references yii_doc.dok_izdelie (id)
            on update cascade
    , add foreign key (redirect) references yii_doc.seo_izdelie (id)
            on update cascade
    , add unique index (alias, prior)
    , drop index dok_razdel
    , drop index ALIAS
;

ALTER TABLE yii_doc.seo_model_izdelie_image
    MODIFY seo_izdelie_id smallint unsigned null
;

ALTER TABLE yii_doc.seo_model_izdelie_image
    ADD FOREIGN KEY (seo_izdelie_id) REFERENCES yii_doc.seo_izdelie(id)
;

alter table yii_doc.search_priority_seo_izdelie
    modify seo_izdelie_id smallint unsigned auto_increment;



DELETE t
FROM yii_doc.seo_model_izdelie_text t
LEFT JOIN yii_doc.seo_izdelie si ON si.id = t.seo_izdelie_id
WHERE si.id IS NULL;

alter table yii_doc.seo_model_izdelie_text
    modify seo_izdelie_id smallint unsigned
    , modify seo_model_id int(5) default 0 not null
    , modify active BIT(1) NOT NULL DEFAULT 0
;

alter table yii_doc.seo_model_izdelie_text
    add foreign key (seo_izdelie_id) references yii_doc.seo_izdelie (id)
        on update cascade
    , add foreign key (seo_model_id) references yii_doc.seo_model (id)
        on update cascade
;


UPDATE yii_doc.dok_razdel
SET id_group = id
WHERE id_group IS NULL;

DELETE st.*
FROM yii_doc.dok_razdel dr
LEFT JOIN yii_doc.dok_izdelie di ON di.id = dr.parent_id
LEFT JOIN yii_doc.new_categories_seo_text st ON st.dok_razdel_id = dr.id
WHERE dr.parent_id IS NOT NULL
  AND di.id IS NULL;

UPDATE yii_doc.dok_razdel dr
LEFT JOIN yii_doc.dok_izdelie di ON di.id = dr.parent_id
SET dr.parent_id = NULL
WHERE dr.parent_id IS NOT NULL
  AND di.id IS NULL;

UPDATE yii_doc.dok_razdel dr
LEFT JOIN yii_doc.seo_izdelie si ON si.id = dr.seo_izdelie_id
SET dr.seo_izdelie_id = NULL
WHERE si.id IS NULL
  AND dr.seo_izdelie_id IS NOT NULL;

alter table yii_doc.dok_razdel
    modify parent_id smallint unsigned
    , modify seo_izdelie_id smallint unsigned
    , modify id_group int(5) not null;

alter table yii_doc.dok_razdel
    add foreign key (parent_id) references yii_doc.dok_izdelie (id)
            on update cascade
    , add foreign key (id_group) references yii_doc.dok_razdel (id)
            on update cascade
    , add foreign key (seo_izdelie_id) references yii_doc.seo_izdelie (id)
            on update cascade;