Lines 3374-3379
CREATE TABLE IF NOT EXISTS marc_modification_template_actions (
Link Here
|
3374 |
CONSTRAINT `mmta_ibfk_1` FOREIGN KEY (`template_id`) REFERENCES `marc_modification_templates` (`template_id`) ON DELETE CASCADE ON UPDATE CASCADE |
3374 |
CONSTRAINT `mmta_ibfk_1` FOREIGN KEY (`template_id`) REFERENCES `marc_modification_templates` (`template_id`) ON DELETE CASCADE ON UPDATE CASCADE |
3375 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
3375 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
3376 |
|
3376 |
|
|
|
3377 |
-- |
3378 |
-- Table structure for table 'external_targets' |
3379 |
-- |
3380 |
|
3381 |
CREATE TABLE `external_targets` ( |
3382 |
`target_id` int(11) NOT NULL AUTO_INCREMENT, |
3383 |
`host` varchar(128) NOT NULL, |
3384 |
`port` int(11) NOT NULL, |
3385 |
`db` varchar(64) NOT NULL, |
3386 |
`userid` varchar(64) DEFAULT '', |
3387 |
`password` varchar(64) DEFAULT '', |
3388 |
`name` varchar(64) NOT NULL, |
3389 |
`syntax` varchar(64) NOT NULL, |
3390 |
`encoding` varchar(16) DEFAULT 'MARC-8', |
3391 |
PRIMARY KEY (`target_id`) |
3392 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
3393 |
|
3394 |
-- |
3395 |
-- Table structure for table 'external_target_restrictions' |
3396 |
-- |
3397 |
|
3398 |
CREATE TABLE `external_target_restrictions` ( |
3399 |
`branchcode` varchar(10) NOT NULL, |
3400 |
`target_id` int(11) NOT NULL, |
3401 |
KEY `branchcode` (`branchcode`), |
3402 |
KEY `target_id` (`target_id`), |
3403 |
CONSTRAINT `external_target_restrictions_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE, |
3404 |
CONSTRAINT `external_target_restrictions_ibfk_2` FOREIGN KEY (`target_id`) REFERENCES `external_targets` (`target_id`) ON DELETE CASCADE |
3405 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
3406 |
|
3377 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
3407 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
3378 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
3408 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
3379 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
3409 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
3380 |
- |
|
|