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');
}
}
|
