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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +20 lines)
Lines 1695-1700 CREATE TABLE `categories_branches` ( Link Here
1695
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1695
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1696
/*!40101 SET character_set_client = @saved_cs_client */;
1696
/*!40101 SET character_set_client = @saved_cs_client */;
1697
1697
1698
--
1699
-- Table structure for table `checkout_renewals`
1700
--
1701
1702
DROP TABLE IF EXISTS `checkout_renewals`;
1703
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1704
/*!40101 SET character_set_client = utf8 */;
1705
CREATE TABLE `checkout_renewals` (
1706
  `id` int(11) NOT NULL AUTO_INCREMENT,
1707
  `issue_id` int(11) DEFAULT NULL COMMENT 'the id of the issue this renewal pertains to',
1708
  `renewer_id` int(11) DEFAULT NULL COMMENT 'the id of the user who processed the renewal',
1709
  `seen` tinyint(1) DEFAULT 0 COMMENT 'boolean denoting whether the item was present or not',
1710
  `interface` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'the interface this renewal took place on',
1711
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'the date and time the renewal took place',
1712
  PRIMARY KEY (`id`),
1713
  KEY `renewer_id` (`renewer_id`),
1714
  CONSTRAINT `renewals_renewer_id` FOREIGN KEY (`renewer_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE
1715
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1716
/*!40101 SET character_set_client = @saved_cs_client */;
1717
1698
--
1718
--
1699
-- Table structure for table `circulation_rules`
1719
-- Table structure for table `circulation_rules`
1700
--
1720
--
1701
- 

Return to bug 30275