Using Orator migrations

1 files changed, 23 insertions, 0 deletions

diff --git a/migrations/2015_10_14_17211444836066_create_cross_references_table.py b/migrations/2015_10_14_17211444836066_create_cross_references_table.py
new file mode 100644
index 0000000..a1607f2
--- /dev/null
+++ b/migrations/2015_10_14_17211444836066_create_cross_references_table.py
@@ -0,0 +1,23 @@
+from orator.migrations import Migration
+
+
+class CreateCrossReferencesTable(Migration):
+
+    def up(self):
+        """
+        Run the migrations.
+        """
+        with self.schema.create('crossreferences') as table:
+            table.integer('passage_id1')
+            table.integer('passage_id2')
+            table.timestamps()
+            table.small_integer('relevance').default(0)
+            table.foreign('passage_id1').references('id').on('passages')
+            table.foreign('passage_id2').references('id').on('passages')
+            table.primary(['passage_id1', 'passage_id2'])
+
+    def down(self):
+        """
+        Revert the migrations.
+        """
+        self.schema.drop('crossreferences')