root/contributed_modules/modules/bosssecretary/install.php

<?php


$fcc = new featurecode('bosssecretary', 'bsc_toggle');
$fcc->setDescription('Bosssecretary Toggle');
$fcc->setDefault('*152');
$fcc->update();
unset($fcc);

$fcc = new featurecode('bosssecretary', 'bsc_on');
$fcc->setDescription('Bosssecretary On');
$fcc->setDefault('*153');
$fcc->update();
unset($fcc);


$fcc = new featurecode('bosssecretary', 'bsc_off');
$fcc->setDescription('Bosssecretary Off');
$fcc->setDefault('*154');
$fcc->update();
unset($fcc);



$sql = " DROP TABLE IF EXISTS  `bosssecretary_config`";
$check = $db->query($sql);
if(DB::IsError($check)) {
  die_freepbx("Can not drop bosssecretary_config table");
}

 


$sql = "
CREATE TABLE IF NOT EXISTS `bosssecretary_chief` (
  `id_group` int(10) unsigned NOT NULL,
  `chief_extension` varchar(20) NOT NULL,
  PRIMARY KEY (`id_group`,`chief_extension`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
";
$check = $db->query($sql);
if(DB::IsError($check)) {
  die_freepbx("Can not create bosssecretary_chief table");
}

$sql = "
CREATE TABLE IF NOT EXISTS `bosssecretary_boss` (
  `id_group` int(10) unsigned NOT NULL,
  `boss_extension` varchar(20) NOT NULL,
  PRIMARY KEY (`id_group`,`boss_extension`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
";
$check = $db->query($sql);
if(DB::IsError($check)) {
        die_freepbx("Can not create bosssecretary_boss table");
}



$sql = "
CREATE TABLE IF NOT EXISTS `bosssecretary_group` (
  `id_group` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `label` varchar(20) NOT NULL,
  PRIMARY KEY (`id_group`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
";
$check = $db->query($sql);
if(DB::IsError($check)) {
  die_freepbx("Can not create bosssecretary_group table");
}



$sql = "SHOW COLUMNS FROM `bosssecretary_group`";
$results = $db->getAll($sql);
if(DB::IsError($results)) {
  die_freepbx("Can not check bosssecretary_group table");
}

foreach ($results as $column)
{

  if (trim(strtolower($column["Field"])) == "dring")
  {
    $sql = "ALTER TABLE `bosssecretary_group` DROP `".$column["Field"]."` ";
    $check = $db->query($sql);
    if(DB::IsError($check)) {
      die_freepbx("Can not alter bosssecretary_group table");
    }
  }
  if (trim(strtolower($column["Field"])) == "ringtime")
  {
    $sql = "ALTER TABLE `bosssecretary_group` DROP `".$column["Field"]."` ";
    $check = $db->query($sql);
    if(DB::IsError($check)) {
      die_freepbx("Can not alter bosssecretary_group table");
    }
  }
}

$sql = "ALTER TABLE bosssecretary_group MODIFY id_group INT(10) NOT NULL";
$results = $db->getAll($sql);
if(DB::IsError($results)) {
  die_freepbx("Can not modify bosssecretary_group.id_group column");
}

$sql = "
CREATE TABLE IF NOT EXISTS `bosssecretary_secretary` (
  `id_group` int(11) NOT NULL,
  `secretary_extension` varchar(20) NOT NULL,
  PRIMARY KEY (`id_group`,`secretary_extension`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
";
$check = $db->query($sql);
if(DB::IsError($check)) {
  die_freepbx("Can not create bosssecretary_secretary table");
}


$sql = "
CREATE TABLE IF NOT EXISTS `bosssecretary_group_numbers_free` (
  `group_number` int(10) unsigned NOT NULL,
  PRIMARY KEY (`group_number`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
";

$check = $db->query($sql);
if(DB::IsError($check)) {
  die_freepbx("Can not create bosssecretary_group_numbers_free");
}



?>