adding a migration for the expire column additions on the user permissions and groups tables

1 files changed, 24 insertions, 0 deletions

diff --git a/migrations/20150703015048_add_user_permission_group_expire.php b/migrations/20150703015048_add_user_permission_group_expire.php
new file mode 100644
index 0000000..ffe3595
--- /dev/null
+++ b/migrations/20150703015048_add_user_permission_group_expire.php
@@ -0,0 +1,24 @@
+<?php
+
+use Phinx\Migration\AbstractMigration;
+
+class AddUserPermissionGroupExpire extends \Psecio\Gatekeeper\PhinxMigration
+{
+    /**
+     * Migrate Up.
+     */
+    public function up()
+    {
+        $this->execute('alter table user_permission add expire INT');
+        $this->execute('alter table group_permission add expire INT');
+    }
+
+    /**
+     * Migrate Down.
+     */
+    public function down()
+    {
+        $this->execute('alter table user_permission drop column expire');
+        $this->execute('alter table group_permission drop column expire');
+    }
+}
\ No newline at end of file