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 |
- |
|
|