summaryrefslogtreecommitdiffstats
path: root/application/migrations/005_drop_file_password.php
diff options
context:
space:
mode:
authorFlorian Pritz <bluewind@xinu.at>2012-05-02 20:11:50 +0200
committerFlorian Pritz <bluewind@xinu.at>2012-05-03 00:50:19 +0200
commit8c0f9fc3e755d46e0ee266a85225bb73cf7fc3c7 (patch)
tree8fd2ea75c0398d0b0207f7ee2d2cbeab10f294c2 /application/migrations/005_drop_file_password.php
parentd6c76b1fe30fc8065c985c31df633c3c6cbbed9f (diff)
remove password column from `files`
Signed-off-by: Florian Pritz <bluewind@xinu.at>
Diffstat (limited to 'application/migrations/005_drop_file_password.php')
-rw-r--r--application/migrations/005_drop_file_password.php21
1 files changed, 21 insertions, 0 deletions
diff --git a/application/migrations/005_drop_file_password.php b/application/migrations/005_drop_file_password.php
new file mode 100644
index 000000000..bf03490a8
--- /dev/null
+++ b/application/migrations/005_drop_file_password.php
@@ -0,0 +1,21 @@
+<?php
+defined('BASEPATH') OR exit('No direct script access allowed');
+
+class Migration_Drop_file_password extends CI_Migration {
+
+ public function up()
+ {
+ $this->db->query("
+ ALTER TABLE `files`
+ DROP `password`;
+ ");
+ }
+
+ public function down()
+ {
+ $this->db->query("
+ ALTER TABLE `files`
+ ADD `password` varchar(40) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL;
+ ");
+ }
+}