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