|
Lines 3339-3345
CREATE TABLE `linktracker` (
Link Here
|
| 3339 |
KEY `bibidx` (`biblionumber`), |
3339 |
KEY `bibidx` (`biblionumber`), |
| 3340 |
KEY `itemidx` (`itemnumber`), |
3340 |
KEY `itemidx` (`itemnumber`), |
| 3341 |
KEY `borridx` (`borrowernumber`), |
3341 |
KEY `borridx` (`borrowernumber`), |
| 3342 |
KEY `dateidx` (`timeclicked`) |
3342 |
KEY `dateidx` (`timeclicked`), |
|
|
3343 |
CONSTRAINT `linktracker_biblio_ibfk` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE SET NULL, |
| 3344 |
CONSTRAINT `linktracker_item_ibfk` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL, |
| 3345 |
CONSTRAINT `linktracker_borrower_ibfk` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL |
| 3343 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3346 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 3344 |
/*!40101 SET character_set_client = @saved_cs_client */; |
3347 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 3345 |
|
3348 |
|
| 3346 |
- |
|
|