5 lines
685 B
Plaintext
5 lines
685 B
Plaintext
CREATE TABLE pp_newsletter_templates ( id int(11) NOT NULL, name varchar(255) COLLATE utf8_polish_ci NOT NULL, text text COLLATE utf8_polish_ci NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
|
|
ALTER TABLE pp_newsletter_send ADD id_template INT NULL AFTER dates;
|
|
ALTER TABLE pp_newsletter_send CHANGE email email VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_polish_ci NULL, CHANGE dates dates VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_polish_ci NULL;
|
|
ALTER TABLE pp_newsletter_send ADD INDEX( id_template );
|
|
ALTER TABLE pp_newsletter_send ADD FOREIGN KEY (id_template) REFERENCES pp_newsletter_templates(id) ON DELETE CASCADE ON UPDATE CASCADE; |