Revize 1231
Přidáno uživatelem Ondřej Fibich před asi 13 roky(ů)
| freenetis/branches/testing/application/upgrade_sql/upgrade_sql.php | ||
|---|---|---|
|
|
||
|
"ALTER TABLE `job_reports` ADD FOREIGN KEY ( `approval_template_id` ) REFERENCES `approval_templates` ( `id` ) ON DELETE RESTRICT;",
|
||
|
|
||
|
"ALTER TABLE `jobs` DROP FOREIGN KEY `jobs_ibfk_1` ;",
|
||
|
|
||
|
"ALTER TABLE `jobs` ADD FOREIGN KEY ( `job_report_id` ) REFERENCES `job_reports` ( `id` ) ON DELETE CASCADE ;",
|
||
|
|
||
|
"ALTER TABLE `job_reports` CHANGE `description` `description` TEXT CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL;"
|
||
|
);
|
||
Také k dispozici: Unified diff
Opravy:
- oprava chyby v predchozim upgrade scriptu