<?php defined('SYSPATH') OR die('No direct script access.'); /** * create_table($table_name, $fields, array('id' => TRUE, 'options' => '')) * drop_table($table_name) * rename_table($old_name, $new_name) * add_column($table_name, $column_name, $params) * rename_column($table_name, $column_name, $new_column_name) * change_column($table_name, $column_name, $params) * remove_column($table_name, $column_name) * add_index($table_name, $index_name, $columns, $index_type = 'normal') * remove_index($table_name, $index_name) */ class Drop_Table_Actions extends Migration { public function up() { $this->drop_table('actions'); } public function down() { $this->create_table('actions', array( 'id' => array("type" => 'int', "limit" => '11', "auto" => TRUE, "primary" => TRUE, "null" => TRUE), 'user_id' => array("type" => 'int', "limit" => '11'), 'type' => array("type" => 'varchar', "limit" => '255'), 'object_model' => array("type" => 'varchar', "limit" => '255', "null" => TRUE), 'object_id' => array("type" => 'int', "limit" => '11'), 'creation_time' => array("type" => 'datetime') ), array()); } } Thursday, November 1, 12