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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +3 lines)
Lines 2203-2208 CREATE TABLE `suggestions` ( -- purchase suggestions Link Here
2203
  PRIMARY KEY  (`suggestionid`),
2203
  PRIMARY KEY  (`suggestionid`),
2204
  KEY `suggestedby` (`suggestedby`),
2204
  KEY `suggestedby` (`suggestedby`),
2205
  KEY `managedby` (`managedby`),
2205
  KEY `managedby` (`managedby`),
2206
  KEY `status` (`STATUS`),
2207
  KEY `biblionumber` (`biblionumber`),
2208
  KEY `branchcode` (`branchcode`),
2206
  CONSTRAINT `suggestions_budget_id_fk` FOREIGN KEY (`budgetid`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE SET NULL ON UPDATE CASCADE
2209
  CONSTRAINT `suggestions_budget_id_fk` FOREIGN KEY (`budgetid`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE SET NULL ON UPDATE CASCADE
2207
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2210
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2208
2211
2209
- 

Return to bug 14132