5 lines
787 B
Plaintext
5 lines
787 B
Plaintext
CREATE TABLE pp_banners_langs ( id INT NOT NULL AUTO_INCREMENT, id_lang VARCHAR(5) NOT NULL, id_banner INT NOT NULL, src VARCHAR(255) NULL DEFAULT NULL, url VARCHAR(255) NULL DEFAULT NULL, html TEXT NULL DEFAULT NULL, text TEXT NULL DEFAULT NULL, PRIMARY KEY (id), INDEX (id_lang), INDEX (id_banner)) ENGINE = InnoDB CHARSET=utf8 COLLATE utf8_polish_ci;
|
|
ALTER TABLE pp_banners_langs ADD FOREIGN KEY (id_lang) REFERENCES pp_langs(id) ON DELETE CASCADE ON UPDATE CASCADE;
|
|
ALTER TABLE pp_banners_langs ADD FOREIGN KEY (id_banner) REFERENCES pp_banners(id) ON DELETE CASCADE ON UPDATE CASCADE;
|
|
UPDATE pp_banners_langs AS pbl SET url = ( SELECT url FROM pp_banners WHERE id = pbl.id_banner );
|
|
UPDATE pp_banners_langs AS pbl SET text = ( SELECT text FROM pp_banners WHERE id = pbl.id_banner ); |