summaryrefslogtreecommitdiffstats
path: root/application/migrations/001_add_files.php
blob: 8af2022859f355718738e2850c56b4038642f3a3 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Migration_Add_files extends CI_Migration {

	public function up()
	{
		// Set database engine for MySQL drivers
		if (strpos($this->db->dbdriver, 'mysql') !== FALSE) {
			$this->db->query('SET storage_engine=MYISAM');
		}

		$this->dbforge->add_field([
			'hash'     => [ 'type' => 'varchar', 'constraint' => 32, 'null' => FALSE ],
			'id'       => [ 'type' => 'varchar', 'constraint' => 6, 'null' => FALSE ],
			'filename' => [ 'type' => 'varchar', 'constraint' => 256, 'null' => FALSE ],
			'password' => [ 'type' => 'varchar', 'constraint' => 40, 'null' => TRUE ],
			'date'     => [ 'type' => 'integer', 'unsigned' => TRUE, 'null' => FALSE ],
			'mimetype' => [ 'type' => 'varchar', 'constraint' => 255, 'null' => FALSE ],
		]);
		$this->dbforge->add_key('id', TRUE);
		$this->dbforge->add_key([ 'hash', 'id' ]);
		$this->dbforge->create_table('files', TRUE);
	}

	public function down()
	{
		$this->dbforge->drop_table('files');
	}
}