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

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

Return to bug 10486