From: Thadeu Lima de Souza Cascardo <cascardo@vespa.holoscopio.com>
Date: Tue, 9 Oct 2007 04:06:09 +0000 (-0300)
Subject: Added directory with SQL scripts
X-Git-Url: http://git.cascardo.eti.br/?p=cascardo%2Feventmanager.git;a=commitdiff_plain;h=2a4e8aaf7136ab56368a25e4ccf168fc08b58828

Added directory with SQL scripts

SQL scripts used to alter tables and other changes in the database
are added to a directory now.
The existing script used to add "aprovado" field to "trabalhos" table
was put there.
Another script to add "dia" field to "trabalhos" table was also written.
---

diff --git a/migration.sql b/migration.sql
deleted file mode 100644
index ecea9b6..0000000
--- a/migration.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE eventos_trabalho ADD "aprovado" bool NOT NULL default false;
diff --git a/sql/add_aprovado.sql b/sql/add_aprovado.sql
new file mode 100644
index 0000000..ecea9b6
--- /dev/null
+++ b/sql/add_aprovado.sql
@@ -0,0 +1 @@
+ALTER TABLE eventos_trabalho ADD "aprovado" bool NOT NULL default false;
diff --git a/sql/add_dia.sql b/sql/add_dia.sql
new file mode 100644
index 0000000..bbce8d5
--- /dev/null
+++ b/sql/add_dia.sql
@@ -0,0 +1 @@
+ALTER TABLE eventos_trabalho ADD "dia" int;