add new ttype field to match table

[brisk.git] / 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 (file)
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;
+