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

(-)a/installer/data/mysql/kohastructure.sql (-15 / +18 lines)
Lines 4460-4465 CREATE TABLE `letter` ( Link Here
4460
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4460
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4461
/*!40101 SET character_set_client = @saved_cs_client */;
4461
/*!40101 SET character_set_client = @saved_cs_client */;
4462
4462
4463
--
4464
-- Table structure for table `library_float_limits`
4465
--
4466
4467
DROP TABLE IF EXISTS `library_float_limits`;
4468
/*!40101 SET @saved_cs_client     = @@character_set_client */;
4469
/*!40101 SET character_set_client = utf8mb4 */;
4470
CREATE TABLE `library_float_limits` (
4471
  `branchcode` varchar(10) NOT NULL,
4472
  `itemtype` varchar(10) NOT NULL,
4473
  `float_limit` int(11) DEFAULT NULL,
4474
  PRIMARY KEY (`branchcode`,`itemtype`),
4475
  KEY `itemtype_idx` (`itemtype`),
4476
  CONSTRAINT `library_float_limits_ibfk_bc` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
4477
  CONSTRAINT `library_float_limits_ibfk_it` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE
4478
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4479
/*!40101 SET character_set_client = @saved_cs_client */;
4480
4463
--
4481
--
4464
-- Table structure for table `library_groups`
4482
-- Table structure for table `library_groups`
4465
--
4483
--
Lines 6887-6906 CREATE TABLE `transport_cost` ( Link Here
6887
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
6905
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
6888
/*!40101 SET character_set_client = @saved_cs_client */;
6906
/*!40101 SET character_set_client = @saved_cs_client */;
6889
6907
6890
DROP TABLE IF EXISTS `library_float_limits`;
6891
/*!40101 SET @saved_cs_client     = @@character_set_client */;
6892
/*!40101 SET character_set_client = utf8 */;
6893
CREATE TABLE `library_float_limits` (
6894
  `branchcode` varchar(10) NOT NULL,
6895
  `itemtype` varchar(10) NOT NULL,
6896
  `float_limit` int(11) NULL DEFAULT NULL,
6897
  PRIMARY KEY (`branchcode`,`itemtype`),
6898
  KEY `itemtype_idx` (`itemtype`),
6899
  CONSTRAINT `library_float_limits_ibfk_bc` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
6900
  CONSTRAINT `library_float_limits_ibfk_it` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE
6901
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
6902
/*!40101 SET character_set_client = @saved_cs_client */;
6903
6904
--
6908
--
6905
-- Table structure for table `uploaded_files`
6909
-- Table structure for table `uploaded_files`
6906
--
6910
--
6907
- 

Return to bug 28530