6 lines
925 B
Plaintext
6 lines
925 B
Plaintext
CREATE TABLE pp_authors ( id INT NOT NULL AUTO_INCREMENT, author VARCHAR(255) NOT NULL, PRIMARY KEY (id) ) COLLATE='utf8_polish_ci' ENGINE=InnoDB;
|
|
CREATE TABLE pp_authors_langs ( id INT NOT NULL AUTO_INCREMENT, id_author INT NOT NULL DEFAULT '0', id_lang VARCHAR(5) NOT NULL DEFAULT '0', description TEXT NULL DEFAULT NULL, PRIMARY KEY (id), CONSTRAINT FK__pp_authors FOREIGN KEY (id_author) REFERENCES pp_authors (id) ON UPDATE CASCADE ON DELETE CASCADE, CONSTRAINT FK__pp_langs FOREIGN KEY (id_lang) REFERENCES pp_langs (id) ON UPDATE CASCADE ON DELETE CASCADE ) COLLATE='utf8_polish_ci' ENGINE=InnoDB;
|
|
ALTER TABLE pp_authors ADD COLUMN image VARCHAR(255) NULL DEFAULT NULL AFTER author;
|
|
ALTER TABLE pp_articles ADD COLUMN id_author INT NULL DEFAULT NULL AFTER views;
|
|
ALTER TABLE pp_articles ADD CONSTRAINT FK_pp_articles_pp_authors FOREIGN KEY (id_author) REFERENCES pp_authors (id) ON UPDATE SET NULL ON DELETE SET NULL;
|