PHP DatabaseHelper::check_meta_table_is_workingの例

コード例 #1

ファイル: class.admin.neworder.data.php プロジェクト: DaddyFool/travelTest

 public function _check_table_order()
 {
     $dbhelper = new DatabaseHelper('1.0.1');
     $dbhelper->setTableName($this->table);
     $column = array('id' => array('type' => 'bigint', 'length' => 9, 'AUTO_INCREMENT' => true), 'order_item_id' => array('type' => 'INT', 'length' => 255), 'type' => array('type' => 'varchar', 'length' => 255), 'check_in' => array('type' => 'varchar', 'length' => 255), 'check_out' => array('type' => 'varchar', 'length' => 255), 'st_booking_post_type' => array('type' => 'varchar', 'length' => 255), 'st_booking_id' => array('type' => 'INT'), 'duration' => array('type' => 'varchar', 'length' => 255), 'adult_number' => array('type' => 'varchar', 'length' => 255), 'child_number' => array('type' => 'varchar', 'length' => 255), 'infant_number' => array('type' => 'varchar', 'length' => 255), 'discount' => array('type' => 'varchar', 'length' => 255), 'room_id' => array('type' => 'varchar', 'length' => 255), 'room_num_search' => array('type' => 'varchar', 'length' => 255), 'check_in_timestamp' => array('type' => 'varchar', 'length' => 255), 'check_out_timestamp' => array('type' => 'varchar', 'length' => 255), 'status' => array('type' => 'varchar', 'length' => 255), 'wc_order_id' => array('type' => 'INT'), 'user_id' => array('type' => 'INT'), 'partner_id' => array('type' => 'INT'), 'created' => array('type' => 'date'), 'commission' => array('type' => 'varchar', 'length' => 255), 'total_order' => array('type' => 'varchar', 'length' => 255), 'origin_id' => array('type' => 'INT'));
     $dbhelper->setDefaultColums($column);
     $dbhelper->check_meta_table_is_working('neworder_table_version');
 }

コード例 #2

ファイル: class.admin.availability.php プロジェクト: DaddyFool/travelTest

 public function _check_table_availability()
 {
     $dbhelper = new DatabaseHelper('1.0.0');
     $dbhelper->setTableName($this->table);
     $column = array('id' => array('type' => 'bigint', 'length' => 9, 'AUTO_INCREMENT' => TRUE), 'post_id' => array('type' => 'INT'), 'post_type' => array('type' => 'varchar', 'length' => 255), 'check_in' => array('type' => 'varchar', 'length' => 255), 'check_out' => array('type' => 'varchar', 'length' => 255), 'number' => array('type' => 'varchar', 'length' => 255), 'price' => array('type' => 'varchar', 'length' => 255), 'adult_price' => array('type' => 'varchar', 'length' => 255), 'child_price' => array('type' => 'varchar', 'length' => 255), 'infant_price' => array('type' => 'varchar', 'length' => 255), 'status' => array('type' => 'varchar', 'length' => 255), 'groupday' => array('type' => 'INT'), 'priority' => array('type' => 'INT'));
     $this->column = $column;
     $dbhelper->setDefaultColums($column);
     $dbhelper->check_meta_table_is_working('availability_table_version');
 }