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

(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 2904-2910 CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquis Link Here
2904
  PRIMARY KEY  (`id`),
2904
  PRIMARY KEY  (`id`),
2905
  KEY `listprice` (`listprice`),
2905
  KEY `listprice` (`listprice`),
2906
  KEY `invoiceprice` (`invoiceprice`),
2906
  KEY `invoiceprice` (`invoiceprice`),
2907
  KEY `name` (`name`(255)),
2907
  KEY `name` (`name`),
2908
  CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE,
2908
  CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE,
2909
  CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE
2909
  CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE
2910
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2910
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2911
- 

Return to bug 14053