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 |
- |
|
|