Wian Drs
8 lines
748 B
PHP
8 lines
748 B
PHP
<?php
|
|
defined('BASEPATH') OR exit('No direct script access allowed');
|
|
class Migration_Finalize_purchase_approval_status extends CI_Migration
|
|
{
|
|
public function up(){if($this->db->table_exists('purchase_orders'))$this->db->query("ALTER TABLE purchase_orders MODIFY status ENUM('draft','submitted','approved','rejected','partially_received','received','closed','cancelled') NOT NULL DEFAULT 'draft'");}
|
|
public function down(){if($this->db->table_exists('purchase_orders')){$this->db->where('status','rejected')->update('purchase_orders',array('status'=>'cancelled'));$this->db->query("ALTER TABLE purchase_orders MODIFY status ENUM('draft','submitted','approved','partially_received','received','closed','cancelled') NOT NULL DEFAULT 'draft'");}}
|
|
}
|