1 files changed, 21 insertions, 0 deletions
diff --git a/migrations/2015_10_14_17201444836042_create_verses_table.py b/migrations/2015_10_14_17201444836042_create_verses_table.py
new file mode 100644
index 0000000..b95aa50
--- /dev/null
+++ b/migrations/2015_10_14_17201444836042_create_verses_table.py
@@ -0,0 +1,21 @@
+from orator.migrations import Migration
+
+
+class CreateVersesTable(Migration):
+
+    def up(self):
+        """
+        Run the migrations.
+        """
+        with self.schema.create('verses') as table:
+            table.string('book')
+            table.small_integer('chapter')
+            table.small_integer('nr')
+            table.foreign('book').references('canonical_name').on('books')
+            table.primary(['book', 'chapter', 'nr'])
+
+    def down(self):
+        """
+        Revert the migrations.
+        """
+        self.schema.drop('verses')