From: Matteo Nastasi <nastasi@alternativeoutput.it>
Date: Tue, 28 Apr 2020 15:48:45 +0000 (+0200)
Subject: add new ttype field to match table
X-Git-Tag: v5.10.0~41
X-Git-Url: https://mop.ddnsfree.com/gitweb/?p=brisk.git;a=commitdiff_plain;h=4542fee714762f3f2d1b29ad276dd44f24be3aaa

add new ttype field to match table
---

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;
+