From adddd3ff8630bb8c5fc7355bcd0d09f226353f67 Mon Sep 17 00:00:00 2001
From: Camil Staps
Date: Wed, 14 Oct 2015 19:40:29 +0200
Subject: Using Orator migrations

---
 ...7201444836054_create_translated_verses_table.py | 26 ++++++++++++++++++++++
 1 file changed, 26 insertions(+)
 create mode 100644 migrations/2015_10_14_17201444836054_create_translated_verses_table.py

(limited to 'migrations/2015_10_14_17201444836054_create_translated_verses_table.py')

diff --git a/migrations/2015_10_14_17201444836054_create_translated_verses_table.py b/migrations/2015_10_14_17201444836054_create_translated_verses_table.py
new file mode 100644
index 0000000..43703e3
--- /dev/null
+++ b/migrations/2015_10_14_17201444836054_create_translated_verses_table.py
@@ -0,0 +1,26 @@
+from orator.migrations import Migration
+
+
+class CreateTranslatedVersesTable(Migration):
+
+    def up(self):
+        """
+        Run the migrations.
+        """
+        with self.schema.create('translated_verses') as table:
+            table.string('translation')
+            table.string('book')
+            table.small_integer('chapter')
+            table.small_integer('nr')
+            table.string('text')
+            table.foreign('translation').references('name').on('translations')
+            table.foreign(['book', 'chapter', 'nr'])\
+                    .references(['book', 'chapter', 'nr']).on('verses')\
+                    .on_delete('restrict').on_update('cascade')
+            table.primary(['translation', 'book', 'chapter', 'nr'])
+
+    def down(self):
+        """
+        Revert the migrations.
+        """
+        self.schema.drop('translated_verses')
-- 
cgit v1.2.3