From 22e94e6851d6d39544b1c192122814d964e54a29 Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Fri, 11 Mar 2022 13:04:24 +0000 Subject: [PATCH] Bug 30275: Generated kohastructure.sql This kohastructure update was generated using `koha-dump --schema-only` in koha-testing-docker once the atomicupdate had been run against the previous atomicupdate patch. Signed-off-by: Owen Leonard Signed-off-by: Tomas Cohen Arazi --- installer/data/mysql/kohastructure.sql | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index f7ec7186b9..583145978d 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1681,6 +1681,26 @@ CREATE TABLE `categories_branches` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `checkout_renewals` +-- + +DROP TABLE IF EXISTS `checkout_renewals`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `checkout_renewals` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `issue_id` int(11) DEFAULT NULL COMMENT 'the id of the issue this renewal pertains to', + `renewer_id` int(11) DEFAULT NULL COMMENT 'the id of the user who processed the renewal', + `seen` tinyint(1) DEFAULT 0 COMMENT 'boolean denoting whether the item was present or not', + `interface` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'the interface this renewal took place on', + `timestamp` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'the date and time the renewal took place', + PRIMARY KEY (`id`), + KEY `renewer_id` (`renewer_id`), + CONSTRAINT `renewals_renewer_id` FOREIGN KEY (`renewer_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + -- -- Table structure for table `circulation_rules` -- -- 2.20.1