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

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

Return to bug 10486