From 40d9f2cf184bb9b3c93c54a4500b6aa5d86d0ccf Mon Sep 17 00:00:00 2001
From: Katrin Fischer <katrin.fischer@bsz-bw.de>
Date: Tue, 17 Sep 2024 10:33:13 +0000
Subject: [PATCH] Bug 37601: DBIC schema update

Signed-off-by: Katrin Fischer <katrin.fischer@bsz-bw.de>
---
 Koha/Schema/Result/Booking.pm | 52 +++++++++++++++++++++++++++++++++--
 1 file changed, 50 insertions(+), 2 deletions(-)

diff --git a/Koha/Schema/Result/Booking.pm b/Koha/Schema/Result/Booking.pm
index 73aaa74908..9596c07ffc 100644
--- a/Koha/Schema/Result/Booking.pm
+++ b/Koha/Schema/Result/Booking.pm
@@ -82,6 +82,33 @@ the start date of the booking
 
 the end date of the booking
 
+=head2 creation_date
+
+  data_type: 'timestamp'
+  datetime_undef_if_invalid: 1
+  default_value: current_timestamp
+  is_nullable: 0
+
+the timestamp for when a booking was created
+
+=head2 modification_date
+
+  data_type: 'timestamp'
+  datetime_undef_if_invalid: 1
+  default_value: current_timestamp
+  is_nullable: 0
+
+the timestamp for when a booking has been updated
+
+=head2 status
+
+  data_type: 'enum'
+  default_value: 'created'
+  extra: {list => ["created","cancelled"]}
+  is_nullable: 0
+
+current status of the booking
+
 =cut
 
 __PACKAGE__->add_columns(
@@ -117,6 +144,27 @@ __PACKAGE__->add_columns(
     datetime_undef_if_invalid => 1,
     is_nullable => 1,
   },
+  "creation_date",
+  {
+    data_type => "timestamp",
+    datetime_undef_if_invalid => 1,
+    default_value => \"current_timestamp",
+    is_nullable => 0,
+  },
+  "modification_date",
+  {
+    data_type => "timestamp",
+    datetime_undef_if_invalid => 1,
+    default_value => \"current_timestamp",
+    is_nullable => 0,
+  },
+  "status",
+  {
+    data_type => "enum",
+    default_value => "created",
+    extra => { list => ["created", "cancelled"] },
+    is_nullable => 0,
+  },
 );
 
 =head1 PRIMARY KEY
@@ -199,8 +247,8 @@ __PACKAGE__->belongs_to(
 );
 
 
-# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-05-03 13:13:25
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pgq1xPy2zo3pdkJb801djA
+# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-09-17 10:13:03
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3v9+L1G6GK0Um3fF0t251w
 
 
 # You can replace this text with custom code or comments, and it will be preserved on regeneration
-- 
2.39.5