Cloudlog/application/migrations/077_add_userid_to_notes.php

22 wiersze
412 B
PHP

<?php
defined('BASEPATH') or exit('No direct script access allowed');
class Migration_add_userid_to_notes extends CI_Migration
{
public function up()
{
$fields = array(
'user_id BIGINT(20) DEFAULT NULL',
);
if (!$this->db->field_exists('user_id', 'notes')) {
$this->dbforge->add_column('notes', $fields);
}
}
public function down()
{
$this->dbforge->drop_column('notes', 'user_id');
}
}