CREATE TABLE IF NOT EXISTS `wp_6535_dopbs_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `calendar_id` int(11) NOT NULL,
  `available_days` varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'true,true,true,true,true,true,true',
  `first_day` int(11) NOT NULL DEFAULT '1',
  `currency` int(11) NOT NULL DEFAULT '108',
  `date_type` int(11) NOT NULL DEFAULT '1',
  `template` varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'default',
  `template_email` varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'default',
  `min_stay` int(11) NOT NULL DEFAULT '1',
  `max_stay` int(11) NOT NULL DEFAULT '0',
  `no_items_enabled` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'true',
  `view_only` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'false',
  `page_url` varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `notifications_email` varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `smtp_enabled` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'false',
  `smtp_host_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `smtp_host_port` int(11) NOT NULL DEFAULT '25',
  `smtp_ssl` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'false',
  `smtp_user` varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `smtp_password` varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `multiple_days_select` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'true',
  `morning_check_out` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'false',
  `hours_enabled` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'false',
  `hours_definitions` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `multiple_hours_select` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'true',
  `hours_ampm` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'false',
  `last_hour_to_total_price` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'true',
  `hours_interval_enabled` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'false',
  `discounts_no_days` varchar(256) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',
  `deposit` float NOT NULL DEFAULT '0',
  `form` int(11) NOT NULL DEFAULT '1',
  `instant_booking` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'false',
  `no_people_enabled` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'true',
  `min_no_people` int(11) NOT NULL DEFAULT '1',
  `max_no_people` int(11) NOT NULL DEFAULT '4',
  `no_children_enabled` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'true',
  `min_no_children` int(11) NOT NULL DEFAULT '0',
  `max_no_children` int(11) NOT NULL DEFAULT '2',
  `terms_and_conditions_enabled` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'false',
  `terms_and_conditions_link` varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `payment_arrival_enabled` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'true',
  `payment_paypal_enabled` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'false',
  `payment_paypal_username` varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `payment_paypal_password` varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `payment_paypal_signature` varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `payment_paypal_credit_card` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'false',
  `payment_paypal_sandbox_enabled` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'false',
  `max_year` int(11) NOT NULL DEFAULT '2014',
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
TRUNCATE TABLE `wp_6535_dopbs_settings`;
 
INSERT INTO `wp_6535_dopbs_settings` VALUES ('1', '1', 'true,true,true,true,true,true,true', '1', '108', '1', 'default', 'default', '1', '0', 'true', 'false', '', '', 'false', '', '25', 'false', '', '', 'true', 'false', 'false', '[{"value": "00:00"}]', 'true', 'false', 'true', 'false', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0', '0', '1', 'false', 'true', '1', '4', 'true', '0', '2', 'false', '', 'true', 'false', '', '', '', 'false', 'false', '2014');
# --------------------------------------------------------

