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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +30 lines)
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
- 

Return to bug 10486