From 7077b817bff797c769191046f0019508ddb20eba Mon Sep 17 00:00:00 2001
From: Tharre <tharre3@gmail.com>
Date: Thu, 3 May 2018 23:43:27 +0200
Subject: Add missing hasNef attr. to VehicleVersion table

---
 src/main/resources/sql/database.sql | 1 +
 1 file changed, 1 insertion(+)

(limited to 'src/main/resources/sql/database.sql')

diff --git a/src/main/resources/sql/database.sql b/src/main/resources/sql/database.sql
index 9d1b0e1..bb23c91 100644
--- a/src/main/resources/sql/database.sql
+++ b/src/main/resources/sql/database.sql
@@ -3,6 +3,7 @@ CREATE TABLE IF NOT EXISTS VehicleVersion (
   name VARCHAR(100) NOT NULL,
   constructionType ENUM('Normal', 'Hochdach', 'Mittelhochdach') NOT NULL,
   type ENUM('BKTW', 'KTW-B', 'KTW', 'RTW', 'NEF', 'NAH') NOT NULL,
+  hasNef BOOLEAN NOT NULL,
 );
 
 CREATE TABLE IF NOT EXISTS Vehicle (
-- 
cgit v1.2.3-70-g09d2

