commit 8b80c7a9e564aa7cdde8eca7401c2addee1704f5
author Marc Kupietz <kupietz@ids-mannheim.de> Tue Mar 28 21:41:39 2023 +0200
committer Marc Kupietz <kupietz@ids-mannheim.de> Tue Mar 28 21:41:39 2023 +0200
tree 688a4a0b06ca4befcccfe01b7dd27ef5669f3dd8
parent fdb1f47b21ec68782403057d6bfcc18a4d68348c

Add excursion option

Change-Id: I70133582d92c3a6385fefb46a99743d47f68cd46

create_user_table.sql

diff --git a/create_user_table.sql b/create_user_table.sql
index d5abe47..8559b27 100644
--- a/create_user_table.sql
+++ b/create_user_table.sql
@@ -26,6 +26,7 @@
     lunch_day_1 varchar(32) not null default '',
     lunch_day_2 varchar(32) not null default '',
     lunch_day_3 varchar(32) not null default '',
+    excursion boolean not null default false,
     total_due decimal(10,2) not null default 0.00,
     registered_at timestamp default '0000-00-00 00:00:00', 
     updated_at timestamp default now() on update now(),