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

(-)a/installer/data/mysql/kohastructure.sql (-5 / +4 lines)
Lines 371-377 CREATE TABLE borrower_sync ( Link Here
371
  PRIMARY KEY (borrowersyncid),
371
  PRIMARY KEY (borrowersyncid),
372
  KEY borrowernumber (borrowernumber),
372
  KEY borrowernumber (borrowernumber),
373
  CONSTRAINT borrower_sync_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE
373
  CONSTRAINT borrower_sync_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE
374
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
374
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
375
375
376
376
377
--
377
--
Lines 3014-3020 CREATE TABLE aqcontacts ( Link Here
3014
  PRIMARY KEY  (id),
3014
  PRIMARY KEY  (id),
3015
  CONSTRAINT booksellerid_aqcontacts_fk FOREIGN KEY (booksellerid)
3015
  CONSTRAINT booksellerid_aqcontacts_fk FOREIGN KEY (booksellerid)
3016
       REFERENCES aqbooksellers (id) ON DELETE CASCADE ON UPDATE CASCADE
3016
       REFERENCES aqbooksellers (id) ON DELETE CASCADE ON UPDATE CASCADE
3017
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3017
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
3018
3018
3019
--
3019
--
3020
-- Table structure for table 'aqcontract'
3020
-- Table structure for table 'aqcontract'
Lines 3483-3489 CREATE TABLE IF NOT EXISTS columns_settings ( Link Here
3483
    cannot_be_toggled int(1) NOT NULL DEFAULT 0,
3483
    cannot_be_toggled int(1) NOT NULL DEFAULT 0,
3484
    is_hidden int(1) NOT NULL DEFAULT 0,
3484
    is_hidden int(1) NOT NULL DEFAULT 0,
3485
    PRIMARY KEY(module, page, tablename, columnname)
3485
    PRIMARY KEY(module, page, tablename, columnname)
3486
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3486
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3487
3487
3488
--
3488
--
3489
-- Table structure for table 'items_search_fields'
3489
-- Table structure for table 'items_search_fields'
Lines 3500-3506 CREATE TABLE items_search_fields ( Link Here
3500
  CONSTRAINT items_search_fields_authorised_values_category
3500
  CONSTRAINT items_search_fields_authorised_values_category
3501
    FOREIGN KEY (authorised_values_category) REFERENCES authorised_values (category)
3501
    FOREIGN KEY (authorised_values_category) REFERENCES authorised_values (category)
3502
    ON DELETE SET NULL ON UPDATE CASCADE
3502
    ON DELETE SET NULL ON UPDATE CASCADE
3503
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3503
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3504
3504
3505
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3505
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3506
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3506
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3507
- 

Return to bug 13577