Lines 6124-6134
CREATE TABLE `statistics` (
Link Here
|
6124 |
KEY `timeidx` (`datetime`), |
6124 |
KEY `timeidx` (`datetime`), |
6125 |
KEY `branch_idx` (`branch`), |
6125 |
KEY `branch_idx` (`branch`), |
6126 |
KEY `type_idx` (`type`), |
6126 |
KEY `type_idx` (`type`), |
6127 |
KEY `illrequest_idx` (`illrequest_id`), |
|
|
6128 |
KEY `itemnumber_idx` (`itemnumber`), |
6127 |
KEY `itemnumber_idx` (`itemnumber`), |
6129 |
KEY `itemtype_idx` (`itemtype`), |
6128 |
KEY `itemtype_idx` (`itemtype`), |
6130 |
KEY `borrowernumber_idx` (`borrowernumber`), |
6129 |
KEY `borrowernumber_idx` (`borrowernumber`), |
6131 |
KEY `ccode_idx` (`ccode`) |
6130 |
KEY `ccode_idx` (`ccode`), |
|
|
6131 |
KEY `illrequest_idx` (`illrequest_id`) |
6132 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
6132 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
6133 |
/*!40101 SET character_set_client = @saved_cs_client */; |
6133 |
/*!40101 SET character_set_client = @saved_cs_client */; |
6134 |
|
6134 |
|
6135 |
- |
|
|