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

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

Return to bug 10486