<?php

/**
 * This file should contain only hooks relating to installing, enabling, disabling, and uninstalling this module.
 *  
*/


/**
 * Hook install.  Called when the module is installed on the admin modules page.
 * 
 */
function calendar_install() {

  $q = "
CREATE TABLE `content__appointment` (
  `cid` int(10) unsigned NOT NULL,
  `vid` int(10) unsigned NOT NULL, 
  `field__appointment_datetime` datetime DEFAULT NULL,
  `field__appointment_duration_minutes` int(11) DEFAULT NULL,
  `field__faculty_id` varchar(255) DEFAULT NULL,
  `field__student_id` varchar(255) DEFAULT NULL,
  `field__appointment_type` varchar(255) DEFAULT NULL,
  `field__appointment_msg` longtext DEFAULT NULL,
  `field__video_data` longtext DEFAULT NULL,
  PRIMARY KEY (`vid`),
  KEY `cid` (`cid`),
  KEY `field__appointment_datetime` (`field__appointment_datetime`),
  KEY `field__duration_minutes` (`field__appointment_duration_minutes`),
  KEY `faculty_id` (`field__faculty_id`),
  KEY `student_id` (`field__student_id`),
  KEY `appointment_type` (`field__appointment_type`)
);  
  ";
  db_query($q);
  

  $q = "
CREATE TABLE `content__schedule_event_type` (
  `cid` int(10) unsigned NOT NULL,
  `vid` int(10) unsigned NOT NULL,
  `field__faculty_id` varchar(255) DEFAULT NULL,
  `field__enabled` varchar(50) DEFAULT NULL,
  `field__event_duration_minutes` int(11) DEFAULT NULL,
  `field__event_buffer_minutes` int(11) DEFAULT NULL,
  `field__prevent_less_than_hours` int(11) DEFAULT NULL,
  `field__additional_email_msg` longtext DEFAULT NULL,
  `field__description` longtext DEFAULT NULL,
  `field__video_meeting` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`vid`),
  KEY `cid` (`cid`),
  KEY `field__faculty_id` (`field__faculty_id`),
  KEY `field__event_duration_minutes` (`field__event_duration_minutes`),
  KEY `field__event_buffer_minutes` (`field__event_buffer_minutes`),
  KEY `field__prevent_less_than_hours` (`field__prevent_less_than_hours`),
  KEY `field__enabled` (`field__enabled`),
  KEY `field__video_meeting` (`field__video_meeting`)
);   
  ";
  db_query($q);


  $q = "
CREATE TABLE `content__schedule_unavailable_time` (
  `cid` int(10) unsigned NOT NULL,
  `vid` int(10) unsigned NOT NULL,
  `field__faculty_id` varchar(255) DEFAULT NULL,
  `field__days` text DEFAULT NULL,
  `field__time_selector` varchar(255) DEFAULT NULL,
  `field__day_start_hour` varchar(255) DEFAULT NULL,
  `field__day_stop_hour` varchar(255) DEFAULT NULL,
  `field__start_time` varchar(255) DEFAULT NULL,
  `field__end_time` varchar(255) DEFAULT NULL,
  `field__ics_url` text DEFAULT NULL,
  PRIMARY KEY (`vid`),
  KEY `cid` (`cid`),
  KEY `field__start_time` (`field__start_time`),
  KEY `field__end_time` (`field__end_time`),
  KEY `field__ics_url` (`field__ics_url`(700)),
  KEY `field__faculty_id` (`field__faculty_id`),
  KEY `field__time_selector` (`field__time_selector`),
  KEY `field__day_start_hour` (`field__day_start_hour`),
  KEY `field__day_stop_hour` (`field__day_stop_hour`)
);  
  ";
  db_query($q);








    
}
  

function calendar_update($old_schema, $new_schema) {
  
  if (intval($old_schema) < 2) {
    // Convert text fields to longtext.
    db_query("ALTER TABLE content__appointment MODIFY field__appointment_msg LONGTEXT");
    db_query("ALTER TABLE content__appointment MODIFY field__video_data LONGTEXT");
    db_query("ALTER TABLE content__schedule_event_type MODIFY field__additional_email_msg LONGTEXT");
    db_query("ALTER TABLE content__schedule_event_type MODIFY field__description LONGTEXT");
    
  } 

  
  if (intval($old_schema) < 3) {
    // Converted ics_url to text
    db_query("DROP INDEX `field__ics_url` ON content__schedule_unavailable_time ");
    db_query("ALTER TABLE content__schedule_unavailable_time MODIFY field__ics_url text");
    db_query("CREATE INDEX `field__ics_url` ON content__schedule_unavailable_time (`field__ics_url`(700)) ");
    
  } 
  



    
}