Cloudlog/application/migrations/042_modify_modes_table.php

27 wiersze
728 B
PHP

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Migration_modify_modes_table extends CI_Migration {
public function up() {
$fields = array(
'submode' => array(
'name' => 'submode',
'type' => 'VARCHAR',
'constraint' => '25',
)
);
$this->dbforge->modify_column('adif_modes', $fields);
$this->db->query("UPDATE `adif_modes` set submode = 'OLIVIA 16/500' where submode = 'OLIVIA 16/50';");
$this->db->query("UPDATE `adif_modes` set submode = 'OLIVIA 16/1000' where submode = 'OLIVIA 16/10';");
$this->db->query("UPDATE `adif_modes` set submode = 'OLIVIA 32/1000' where submode = 'OLIVIA 32/10';");
}
public function down(){
echo "Not possible, sorry.";
}
}