9 lines
1.2 KiB
Plaintext
9 lines
1.2 KiB
Plaintext
CREATE TABLE pp_articles_additional_params ( id INT NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL, display_name VARCHAR(255) NOT NULL, language INT NOT NULL DEFAULT '0', status INT NOT NULL DEFAULT '0', PRIMARY KEY (id)) ENGINE = InnoDB CHARSET=utf8 COLLATE utf8_polish_ci;
|
|
ALTER TABLE pp_articles_additional_params ADD type VARCHAR(255) NOT NULL AFTER display_name;
|
|
CREATE TABLE pp_articles_additional_values ( id INT NOT NULL AUTO_INCREMENT, param_id INT NOT NULL, value TEXT NOT NULL, language_id VARCHAR(5) NOT NULL, PRIMARY KEY (id)) ENGINE = InnoDB CHARSET=utf8 COLLATE utf8_polish_ci;
|
|
ALTER TABLE pp_articles_additional_values ADD INDEX(param_id);
|
|
ALTER TABLE pp_articles_additional_values ADD FOREIGN KEY (param_id) REFERENCES pp_articles_additional_params(id) ON DELETE CASCADE ON UPDATE CASCADE;
|
|
ALTER TABLE pp_articles_additional_values ADD article_id INT NOT NULL AFTER value;
|
|
ALTER TABLE pp_articles_additional_values ADD INDEX(article_id);
|
|
ALTER TABLE pp_articles_additional_values ADD FOREIGN KEY (article_id) REFERENCES pp_articles(id) ON DELETE CASCADE ON UPDATE CASCADE;
|
|
ALTER TABLE pp_articles_additional_values CHANGE language_id language_id VARCHAR(5) CHARACTER SET utf8 COLLATE utf8_polish_ci NULL DEFAULT NULL; |