Added directory with SQL scripts
authorThadeu Lima de Souza Cascardo <cascardo@vespa.holoscopio.com>
Tue, 9 Oct 2007 04:06:09 +0000 (01:06 -0300)
committerThadeu Lima de Souza Cascardo <cascardo@vespa.holoscopio.com>
Tue, 9 Oct 2007 04:06:09 +0000 (01:06 -0300)
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.

migration.sql [deleted file]
sql/add_aprovado.sql [new file with mode: 0644]
sql/add_dia.sql [new file with mode: 0644]

diff --git a/migration.sql b/migration.sql
deleted file mode 100644 (file)
index ecea9b6..0000000
+++ /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 (file)
index 0000000..ecea9b6
--- /dev/null
@@ -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 (file)
index 0000000..bbce8d5
--- /dev/null
@@ -0,0 +1 @@
+ALTER TABLE eventos_trabalho ADD "dia" int;