From 4d919723513c0723847762890e9e6226e0cf32a2 Mon Sep 17 00:00:00 2001
From: Camil Staps
Date: Mon, 18 Jul 2016 19:50:48 +0200
Subject: Initial commit

---
 .../2016_07_18_144136_create_folders_table.py      | 17 +++++++++++++++++
 .../2016_07_18_144145_create_addresses_table.py    | 19 +++++++++++++++++++
 .../2016_07_18_144155_create_messages_table.py     | 22 ++++++++++++++++++++++
 ...07_18_144435_create_addresses_messages_table.py | 21 +++++++++++++++++++++
 migrations/__init__.py                             |  0
 5 files changed, 79 insertions(+)
 create mode 100644 migrations/2016_07_18_144136_create_folders_table.py
 create mode 100644 migrations/2016_07_18_144145_create_addresses_table.py
 create mode 100644 migrations/2016_07_18_144155_create_messages_table.py
 create mode 100644 migrations/2016_07_18_144435_create_addresses_messages_table.py
 create mode 100644 migrations/__init__.py

(limited to 'migrations')

diff --git a/migrations/2016_07_18_144136_create_folders_table.py b/migrations/2016_07_18_144136_create_folders_table.py
new file mode 100644
index 0000000..8ac9bf7
--- /dev/null
+++ b/migrations/2016_07_18_144136_create_folders_table.py
@@ -0,0 +1,17 @@
+from orator.migrations import Migration
+
+
+class CreateFoldersTable(Migration):
+
+    def up(self):
+        """
+        Run the migrations.
+        """
+        with self.schema.create('folders') as table:
+            table.string('name').primary()
+
+    def down(self):
+        """
+        Revert the migrations.
+        """
+        self.schema.drop('folders')
diff --git a/migrations/2016_07_18_144145_create_addresses_table.py b/migrations/2016_07_18_144145_create_addresses_table.py
new file mode 100644
index 0000000..3b69a70
--- /dev/null
+++ b/migrations/2016_07_18_144145_create_addresses_table.py
@@ -0,0 +1,19 @@
+from orator.migrations import Migration
+
+
+class CreateAddressesTable(Migration):
+
+    def up(self):
+        """
+        Run the migrations.
+        """
+        with self.schema.create('addresses') as table:
+            table.increments('id')
+            table.string('email')
+            table.string('domain')
+
+    def down(self):
+        """
+        Revert the migrations.
+        """
+        self.schema.drop('addresses')
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')
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')
diff --git a/migrations/__init__.py b/migrations/__init__.py
new file mode 100644
index 0000000..e69de29
-- 
cgit v1.2.3