27 lines
1.9 KiB
Plaintext
27 lines
1.9 KiB
Plaintext
ALTER TABLE pp_newsletter_send DROP INDEX id_template_20;
|
|
ALTER TABLE pp_newsletter_send DROP INDEX id_template_19;
|
|
ALTER TABLE pp_newsletter_send DROP INDEX id_template_18;
|
|
ALTER TABLE pp_newsletter_send DROP INDEX id_template_17;
|
|
ALTER TABLE pp_newsletter_send DROP INDEX id_template_16;
|
|
ALTER TABLE pp_newsletter_send DROP INDEX id_template_15;
|
|
ALTER TABLE pp_newsletter_send DROP INDEX id_template_14;
|
|
ALTER TABLE pp_newsletter_send DROP INDEX id_template_13;
|
|
ALTER TABLE pp_newsletter_send DROP INDEX id_template_12;
|
|
ALTER TABLE pp_newsletter_send DROP INDEX id_template_11;
|
|
ALTER TABLE pp_newsletter_send DROP INDEX id_template_10;
|
|
ALTER TABLE pp_newsletter_send DROP INDEX id_template_9;
|
|
ALTER TABLE pp_newsletter_send DROP INDEX id_template_8;
|
|
ALTER TABLE pp_newsletter_send DROP INDEX id_template_7;
|
|
ALTER TABLE pp_newsletter_send DROP INDEX id_template_6;
|
|
ALTER TABLE pp_newsletter_send DROP INDEX id_template_5;
|
|
ALTER TABLE pp_newsletter_send DROP INDEX id_template_4;
|
|
ALTER TABLE pp_newsletter_send DROP INDEX id_template_3;
|
|
ALTER TABLE pp_newsletter_send DROP INDEX id_template_2;
|
|
ALTER TABLE pp_newsletter_send DROP INDEX id_template;
|
|
ALTER TABLE pp_newsletter_send ADD INDEX(id_template);
|
|
ALTER TABLE pp_newsletter_send ADD FOREIGN KEY (id_template) REFERENCES pp_newsletter(id) ON DELETE CASCADE ON UPDATE CASCADE;
|
|
ALTER TABLE pp_newsletter_send ADD only_once INT NOT NULL DEFAULT '0' AFTER id_template;
|
|
ALTER TABLE pp_newsletter_send ADD mailed INT NOT NULL DEFAULT '0' AFTER only_once;
|
|
ALTER TABLE pp_newsletter_send DROP FOREIGN KEY pp_newsletter_send_ibfk_1; ALTER TABLE pp_newsletter_send ADD CONSTRAINT pp_newsletter_send_ibfk_1 FOREIGN KEY (id_template) REFERENCES pp_newsletter_templates(id) ON DELETE CASCADE ON UPDATE CASCADE;
|
|
ALTER TABLE pp_newsletter_send DROP INDEX id_template_2;
|
|
ALTER TABLE admin_zaufany-ksiegowy-com-pl.pp_newsletter_send DROP FOREIGN KEY pp_newsletter_send_ibfk_21; |