From d36c70016d1452dbc2d985fee07ee26be864b2bf Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Fri, 24 Mar 2023 16:15:00 +0000 Subject: [PATCH] Bug 31028: (follow-up) Unify table creation This patch updates kohastructure to use the same syntax we use everywhere else. --- installer/data/mysql/kohastructure.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index cba889d5e0..b267e2dc0b 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -5747,7 +5747,7 @@ CREATE TABLE `tags_index` ( DROP TABLE IF EXISTS `tickets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; -CREATE TABLE IF NOT EXISTS `tickets` ( +CREATE TABLE `tickets` ( `id` int(11) NOT NULL auto_increment COMMENT 'primary key', `reporter_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id of the patron who reported the ticket', `reported_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this ticket was reported', @@ -5770,7 +5770,7 @@ CREATE TABLE IF NOT EXISTS `tickets` ( DROP TABLE IF EXISTS `ticket_updates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; -CREATE TABLE IF NOT EXISTS `ticket_updates` ( +CREATE TABLE `ticket_updates` ( `id` int(11) NOT NULL auto_increment COMMENT 'primary key', `ticket_id` int(11) NOT NULL COMMENT 'id of catalog ticket the update relates to', `user_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id of the user who logged the update', -- 2.40.0