<?php $CalendarSettingsArray = array(
	'calendar_slot_time' => '30',		// 30 min slots
	'day_start_time' => '10:00 AM',		// 10:00 AM
	'day_end_time' => '5:00 PM',		// 5:00 PM
	'calendar_view' => 'month',			// month
	'calendar_start_day' => '1',		// monday
	'booking_button_text' => 'Schedule An Appointment',		// Schedule An Appointment
	'booking_time_slot' => 30,			// booking time slot
    'show_service_cost' => 'yes',       // for service cost hide or show
    'show_service_duration' => 'yes',    // for service duration hide or show
    'apcal_booking_instructions' => 'Put your booking instructions here.<br>Or you can save It blank in case of nothing want to display.' // booking instruction befor booking button
);
add_option('apcal_calendar_settings',serialize($CalendarSettingsArray));

global $wpdb;
//create a ap_appointments table
$table_name = $wpdb->prefix . "ap_appointments";
$appointments = "CREATE TABLE $table_name (
	`id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY,
	`name` VARCHAR( 30 ) NOT NULL ,
	`email` VARCHAR( 256 ) NOT NULL ,
	`service_id` INT( 11 ) NOT NULL ,
	`phone` BIGINT( 21 ) NOT NULL ,
	`start_time` VARCHAR( 10 ) NOT NULL ,
	`end_time` VARCHAR( 10 ) NOT NULL ,
	`date` DATE NOT NULL ,
	`note` TEXT NOT NULL ,
	`appointment_key` VARCHAR( 32 ) NOT NULL ,
	`status` VARCHAR( 10 ) NOT NULL ,
	`appointment_by` VARCHAR( 10 ) NOT NULL 
	)DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;";
$wpdb->query($appointments); 
	
	
// create ap_events table
$table_name = $wpdb->prefix . "ap_events";
$events = "CREATE TABLE $table_name (
	`id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY,
	`name` VARCHAR( 30 ) NOT NULL ,
	`allday` VARCHAR( 10 ) NOT NULL ,
	`start_time` VARCHAR( 10 ) NOT NULL ,
	`end_time` VARCHAR( 10 ) NOT NULL ,
	`repeat` VARCHAR( 10 ) NOT NULL ,
	`start_date` DATE NOT NULL ,
	`end_date` DATE NOT NULL ,
	`note` TEXT NOT NULL ,
	`status` VARCHAR( 10 ) NOT NULL 
	)DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;";
$wpdb->query($events); 
	
	
// create ap_services table
$table_name = $wpdb->prefix . "ap_services";
$services = "CREATE TABLE $table_name (
	`id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY,
	`name` VARCHAR( 50 ) NOT NULL ,
	`desc` TEXT NOT NULL ,
	`duration` INT( 11 ) NOT NULL ,
	`unit` VARCHAR( 10 ) NOT NULL ,
	`paddingtime` INT( 11 ) NOT NULL ,
	`cost` FLOAT NOT NULL ,
	`capacity` INT( 11 ) NOT NULL ,
	`availability` VARCHAR( 10 ) NOT NULL ,
	`business_id` INT( 11 ) NOT NULL ,
	`category_id` INT( 11 ) NOT NULL ,
	`staff_id` VARCHAR( 300 ) NOT NULL 
	)DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;";
$wpdb->query($services); 
	
	
// inserting service 'Default'
$table_name = $wpdb->prefix . "ap_services";
$insert_service = "INSERT INTO $table_name (
	`id` ,
	`name` ,
	`desc` ,
	`duration` ,
	`unit` ,
	`paddingtime`,
	`cost` ,
	`capacity`,
	`availability`,
	`business_id`,
	`category_id`,
	`staff_id`
	)
	VALUES ('1', 'Default', 'This is default service. You can edit this service.', '30', 'minute', '10', '100', '10', 'yes', '1', '1', '1');";
$wpdb->query($insert_service);
	
	
// create a service Category
$table_name = $wpdb->prefix . "ap_service_category";
$service_category = "CREATE TABLE $table_name (
	`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
	`name` VARCHAR( 100 ) NOT NULL 
	)DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;";
$wpdb->query($service_category);
	
	
// inserting a 'Default' service category
$table_name = $wpdb->prefix . "ap_service_category";
$insert_service_category = "INSERT INTO $table_name (
	`id` ,
	`name` 
	)
	VALUES (
	'1', 'Default'
	);";
$wpdb->query($insert_service_category);
	
	
// create a calendar settings table
$table_name = $wpdb->prefix . "ap_calendar_settings";
$calendar_settings = "CREATE TABLE $table_name (
	`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
	`view` VARCHAR( 20 ) NOT NULL ,
	`timeslots` INT( 11 ) NOT NULL 
	)DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;";
$wpdb->query($calendar_settings);

add_option('emailstatus', 'on');			//on	
add_option('emailtype', 'wpmail');			//wpmail
$EmailDetails =  array ( 'wpemail' => get_settings('admin_email') );
add_option( 'emaildetails', serialize($EmailDetails));	// current admin email ?>