function merci_update_6209 in MERCI (Manage Equipment Reservations, Checkout and Inventory) 6.2

File

./merci.install, line 673

merci Installer / Uninstaller

Code

function merci_update_6209() {
  $ret = array();
  $ret[] = update_sql("ALTER TABLE {merci_bucket_node}\n    CHANGE default_availability merci_default_availability TINYINT(4) NOT NULL DEFAULT '0',\n    CHANGE late_fee_per_hour merci_late_fee_per_hour FLOAT NOT NULL DEFAULT '0',\n    CHANGE rate_per_hour merci_rate_per_hour FLOAT NOT NULL DEFAULT '0',\n    CHANGE daypart1_price merci_daypart1_price FLOAT NOT NULL DEFAULT '0',\n    CHANGE daypart2_price merci_daypart2_price FLOAT NOT NULL DEFAULT '0',\n    CHANGE daypart3_price merci_daypart3_price FLOAT NOT NULL DEFAULT '0',\n    CHANGE weekend_price merci_weekend_price FLOAT NOT NULL DEFAULT '0',\n    CHANGE fee_free_hours merci_fee_free_hours FLOAT NOT NULL DEFAULT '0',\n    CHANGE min_cancel_hours merci_min_cancel_hours INT(11) NOT NULL DEFAULT '0',\n    CHANGE autocheckout merci_autocheckout TINYINT(4) NOT NULL DEFAULT '0',\n    CHANGE autocheckin merci_autocheckin TINYINT(4) NOT NULL DEFAULT '0',\n    CHANGE selfcheckout merci_selfcheckout TINYINT(4) NOT NULL DEFAULT '0',\n    CHANGE sub_type merci_sub_type INT(11) NOT NULL DEFAULT '0'");
  $ret[] = update_sql("ALTER TABLE  {merci_node_type}\n    CHANGE  type_setting  merci_type_setting VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  'disabled',\n    CHANGE  max_hours_per_reservation  merci_max_hours_per_reservation INT( 11 ) NOT NULL DEFAULT  '0',\n    CHANGE  allow_overnight  merci_allow_overnight TINYINT( 4 ) NOT NULL DEFAULT  '0',\n    CHANGE  allow_weekends  merci_allow_weekends TINYINT( 4 ) NOT NULL DEFAULT  '0',\n    CHANGE  late_fee_per_hour  merci_late_fee_per_hour FLOAT NOT NULL DEFAULT  '0',\n    CHANGE  rate_per_hour  merci_rate_per_hour FLOAT NOT NULL DEFAULT  '0',\n    CHANGE  fee_free_hours merci_fee_free_hours FLOAT NOT NULL DEFAULT  '0',\n    CHANGE  daypart1_price  merci_daypart1_price FLOAT NOT NULL DEFAULT  '0',\n    CHANGE  daypart2_price  merci_daypart2_price FLOAT NOT NULL DEFAULT  '0',\n    CHANGE  daypart3_price  merci_daypart3_price FLOAT NOT NULL DEFAULT  '0',\n    CHANGE  weekend_price  merci_weekend_price FLOAT NOT NULL DEFAULT  '0',\n    CHANGE  status  merci_active_status INT( 11 ) NOT NULL DEFAULT  '0',\n    CHANGE  spare_items  merci_spare_items INT( 11 ) NOT NULL DEFAULT  '0',\n    CHANGE  min_cancel_hours  merci_min_cancel_hours INT( 11 ) NOT NULL DEFAULT  '0',\n    CHANGE  autocheckout  merci_autocheckout TINYINT( 4 ) NOT NULL DEFAULT  '0',\n    CHANGE  autocheckin  merci_autocheckin TINYINT( 4 ) NOT NULL DEFAULT  '0',\n    CHANGE  selfcheckout  merci_selfcheckout TINYINT( 4 ) NOT NULL DEFAULT  '0',\n    CHANGE  grouping  merci_grouping TINYINT( 4 ) NULL DEFAULT NULL ,\n    CHANGE  auto_assign_bucket_item  merci_auto_assign_bucket_item TINYINT( 4 ) NULL DEFAULT NULL\n    ");
  $ret[] = update_sql("ALTER TABLE  {merci_reservation} CHANGE  status  merci_reservation_status TINYINT( 4 ) NOT NULL DEFAULT  '1'");
  $ret[] = update_sql("ALTER TABLE  {merci_reservation_detail}\n    CHANGE  placeholder_nid  merci_placeholder_nid INT( 11 ) NOT NULL DEFAULT  '0',\n    CHANGE  item_nid  merci_item_nid INT( 11 ) NOT NULL DEFAULT  '0',\n    CHANGE  item_status  merci_item_status INT( 11 ) NOT NULL DEFAULT  '0'\n    ");
  $ret[] = update_sql("ALTER TABLE  {merci_reservation_item_node}\n    CHANGE  default_availability  merci_default_availability TINYINT( 4 ) NOT NULL DEFAULT  '0',\n    CHANGE  sub_type  merci_sub_type INT( 11 ) NOT NULL DEFAULT  '0',\n    CHANGE  item_status  merci_item_status INT( 11 ) NOT NULL DEFAULT  '0'\n    ");
  $ret[] = update_sql("ALTER TABLE  {merci_resource_node}\n    CHANGE  default_availability  merci_default_availability TINYINT( 4 ) NOT NULL DEFAULT  '0',\n    CHANGE  late_fee_per_hour  merci_late_fee_per_hour FLOAT NOT NULL DEFAULT  '0',\n    CHANGE  rate_per_hour  merci_rate_per_hour FLOAT NOT NULL DEFAULT  '0',\n    CHANGE  daypart1_price  merci_daypart1_price FLOAT NOT NULL DEFAULT  '0',\n    CHANGE  daypart2_price  merci_daypart2_price FLOAT NOT NULL DEFAULT  '0',\n    CHANGE  daypart3_price  merci_daypart3_price FLOAT NOT NULL DEFAULT  '0',\n    CHANGE  weekend_price  merci_weekend_price FLOAT NOT NULL DEFAULT  '0',\n    CHANGE  fee_free_hours  merci_fee_free_hours FLOAT NOT NULL DEFAULT  '0',\n    CHANGE  min_cancel_hours  merci_min_cancel_hours INT( 11 ) NOT NULL DEFAULT  '0',\n    CHANGE  autocheckout  merci_autocheckout TINYINT( 4 ) NOT NULL DEFAULT  '0',\n    CHANGE  autocheckin  merci_autocheckin TINYINT( 4 ) NOT NULL DEFAULT  '0',\n    CHANGE  selfcheckout  merci_selfcheckout TINYINT( 4 ) NOT NULL DEFAULT  '0',\n    CHANGE  sub_type  merci_sub_type INT( 11 ) NOT NULL DEFAULT  '0'");
  cache_clear_all('merci_content_type_info', 'cache');
  return $ret;
}