View | Details | Raw Unified | Return to bug 22343
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_22343_smtp_servers.perl (-2 / +2 lines)
Lines 30-37 if( CheckVersion( $DBversion ) ) { Link Here
30
                PRIMARY KEY (`id`),
30
                PRIMARY KEY (`id`),
31
                UNIQUE KEY `library_id_idx` (`library_id`),
31
                UNIQUE KEY `library_id_idx` (`library_id`),
32
                KEY `smtp_server_id_idx` (`smtp_server_id`),
32
                KEY `smtp_server_id_idx` (`smtp_server_id`),
33
                CONSTRAINT `library_id_fk` FOREIGN KEY (`library_id`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
33
                CONSTRAINT `library_smtp_servers_library_fk` FOREIGN KEY (`library_id`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
34
                CONSTRAINT `smtp_server_id_fk` FOREIGN KEY (`smtp_server_id`) REFERENCES `smtp_servers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
34
                CONSTRAINT `library_smtp_servers_smtp_servers_fk` FOREIGN KEY (`smtp_server_id`) REFERENCES `smtp_servers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
35
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
35
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
36
        });
36
        });
37
    }
37
    }
(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
Lines 4624-4631 CREATE TABLE `library_smtp_servers` ( Link Here
4624
    PRIMARY KEY (`id`),
4624
    PRIMARY KEY (`id`),
4625
    UNIQUE KEY `library_id_idx` (`library_id`),
4625
    UNIQUE KEY `library_id_idx` (`library_id`),
4626
    KEY `smtp_server_id_idx` (`smtp_server_id`),
4626
    KEY `smtp_server_id_idx` (`smtp_server_id`),
4627
    CONSTRAINT `library_id_fk` FOREIGN KEY (`library_id`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
4627
    CONSTRAINT `library_smtp_servers_library_fk` FOREIGN KEY (`library_id`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
4628
    CONSTRAINT `smtp_server_id_fk` FOREIGN KEY (`smtp_server_id`) REFERENCES `smtp_servers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
4628
    CONSTRAINT `library_smtp_servers_smtp_servers_fk` FOREIGN KEY (`smtp_server_id`) REFERENCES `smtp_servers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
4629
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
4629
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
4630
4630
4631
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
4631
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
4632
- 

Return to bug 22343