install.php

<?php
if (!defined('FREEPBX_IS_AUTH')) { die('No direct script access allowed'); }

global $db;
global $amp_conf;

$freepbx_conf =& freepbx_conf::create();
$set=[];
$set['value'] = true;
$set['defaultval'] =& $set['value'];
$set['readonly'] = 0;
$set['hidden'] = 0;
$set['level'] = 0;
$set['module'] = '';
$set['category'] = 'Dialplan and Operational';
$set['emptyok'] = 1;
$set['sortorder'] = 0;
$set['name'] = 'Attended Transfer Caller ID Override';
$set['description'] = 'Use transferor\'s extension number when doing an attended transfer of an external outgoing call';
$set['type'] = CONF_TYPE_BOOL;
$freepbx_conf->define_conf_setting('ATX_CID_OVERRIDE',$set,true);

$sql='
    CREATE TABLE IF NOT EXISTS `offhour` (
      `id` int(11) NOT NULL auto_increment,
      `displayname` varchar(50) default NULL,
      `didcidnum` varchar(20) default NULL,
      `didextension` varchar(20) default NULL,
      `tsbegin` int(10) unsigned default 0,
      `tsend` int(10) unsigned default 0,
      `message` varchar(500) default NULL,
      `action` int(1) DEFAULT NULL,
      `param` varchar(50) DEFAULT NULL,
      `destination` varchar(500) DEFAULT "",
      `enabled` tinyint(1) DEFAULT "0",
      PRIMARY KEY  (`id`)
   ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
';

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