application/migrations/001_add_files.php


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

<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Migration_Add_files extends CI_Migration {

	public function up()
	{
		$this->db->query("
			CREATE TABLE IF NOT EXISTS `files` (
			  `hash` varchar(32) CHARACTER SET ascii NOT NULL,
			  `id` varchar(6) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
			  `filename` varchar(256) COLLATE utf8_bin NOT NULL,
			  `password` varchar(40) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL,
			  `date` int(11) unsigned NOT NULL,
			  `mimetype` varchar(255) CHARACTER SET ascii NOT NULL,
			  PRIMARY KEY (`id`),
			  KEY `date` (`date`),
			  KEY `hash` (`hash`,`id`)
			) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
		");
	}

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