1 files changed, 21 insertions, 0 deletions
diff --git a/migrations/2016_07_18_144435_create_addresses_messages_table.py b/migrations/2016_07_18_144435_create_addresses_messages_table.py
new file mode 100644
index 0000000..e23c8da
--- /dev/null
+++ b/migrations/2016_07_18_144435_create_addresses_messages_table.py
@@ -0,0 +1,21 @@
+from orator.migrations import Migration
+
+
+class CreateAddressesMessagesTable(Migration):
+
+    def up(self):
+        """
+        Run the migrations.
+        """
+        with self.schema.create('addresses_messages') as table:
+            table.integer('message_id').unsigned().references('id').on('messages')
+            table.integer('address_id').unsigned().references('id').on('addresses')
+            table.enum('type', ['to', 'from', 'cc'])
+
+            table.primary(['message_id', 'address_id', 'type'])
+
+    def down(self):
+        """
+        Revert the migrations.
+        """
+        self.schema.drop('addresses_messages')