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