From 4542fee714762f3f2d1b29ad276dd44f24be3aaa Mon Sep 17 00:00:00 2001
From: Matteo Nastasi <nastasi@alternativeoutput.it>
Date: Tue, 28 Apr 2020 17:48:45 +0200
Subject: [PATCH] add new ttype field to match table

---
 sql/sql.d/095-type-of-match-add.sql | 8 ++++++++
 1 file changed, 8 insertions(+)
 create mode 100644 sql/sql.d/095-type-of-match-add.sql

diff --git a/sql/sql.d/095-type-of-match-add.sql b/sql/sql.d/095-type-of-match-add.sql
new file mode 100644
index 0000000..17aa400
--- /dev/null
+++ b/sql/sql.d/095-type-of-match-add.sql
@@ -0,0 +1,8 @@
+--
+-- ttype = 1 -> certified
+-- ttype = 2 -> guaranteed
+-- ttype = 3 -> authorized
+
+ALTER TABLE #PFX#bin5_matches DROP COLUMN ttype;
+ALTER TABLE #PFX#bin5_matches ADD COLUMN ttype integer DEFAULT 2;
+
-- 
2.17.1