Initial commit

1 files changed, 22 insertions, 0 deletions

diff --git a/migrations/2016_07_18_144155_create_messages_table.py b/migrations/2016_07_18_144155_create_messages_table.py
new file mode 100644
index 0000000..369bbc6
--- /dev/null
+++ b/migrations/2016_07_18_144155_create_messages_table.py
@@ -0,0 +1,22 @@
+from orator.migrations import Migration
+
+
+class CreateMessagesTable(Migration):
+
+    def up(self):
+        """
+        Run the migrations.
+        """
+        with self.schema.create('messages') as table:
+            table.increments('id')
+            table.string('filename')
+            table.string('folder').references('name').on('folders')
+            table.string('subject', 1023).nullable()
+            table.datetime('date').nullable()
+            table.string('content_type')
+
+    def down(self):
+        """
+        Revert the migrations.
+        """
+        self.schema.drop('messages')