Show
Ignore:
Timestamp:
04/26/06 16:52:54 (7 years ago)
Author:
rcourtna
Message:

#702
-add did-to-extension option for users/extens.
-Specify dial options for outbound trunks (in general page).
-Bring newinstall.sql up to date.
-Add some dialplan hooks specific to findmefollow module (need to find a way to avoid doing this)
-Clear out default IP address in amportal.conf

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • freepbx/trunk/SQL/newinstall.sql

    r1458 r1719  
    7878INSERT INTO `globals` VALUES ('CALLFILENAME', '""'); 
    7979INSERT INTO `globals` VALUES ('DIAL_OPTIONS', 'tr'); 
     80INSERT INTO `globals` VALUES ('TRUNK_OPTIONS', 'r'); 
    8081INSERT INTO `globals` VALUES ('DIAL_OUT', '9'); 
    8182INSERT INTO `globals` VALUES ('FAX', ''); 
    …… 
    183184) TYPE = MYISAM ; 
    184185 
    185 CREATE TABLE IF NOT EXISTS users (extension VARCHAR( 20 ) NOT NULL , password VARCHAR( 20 ) , name VARCHAR( 50 ) , voicemail VARCHAR( 50 ) , ringtimer INT(3) , noanswer VARCHAR( 100 ) , recording VARCHAR( 50 ) ,  outboundcid VARCHAR( 50 )); 
    186  
    187 CREATE TABLE IF NOT EXISTS `incoming` ( `cidnum` VARCHAR( 20 ) , `extension` VARCHAR( 20 ) , `destination` VARCHAR( 50 ) , `faxexten` VARCHAR( 20 ) , `faxemail` VARCHAR( 50 ) , `answer` TINYINT( 1 ) , `wait` INT( 2 ) , `privacyman` TINYINT( 1 ) , alertinfo VARCHAR( 32 ) ); 
     186CREATE TABLE IF NOT EXISTS users (extension VARCHAR( 20 ) NOT NULL , password VARCHAR( 20 ) , name VARCHAR( 50 ) , voicemail VARCHAR( 50 ) , ringtimer INT(3) , noanswer VARCHAR( 100 ) , recording VARCHAR( 50 ) ,  outboundcid VARCHAR( 50 ) , directdid VARCHAR( 50 ) NULL, didalert VARCHAR ( 50 ) NULL ); 
     187 
     188-- 
     189-- Needs to be changed to their new structure, comment out for now 
     190-- 
     191CREATE TABLE IF NOT EXISTS `incoming` ( `cidnum` VARCHAR( 20 ) , `extension` VARCHAR( 20 ) , `destination` VARCHAR( 50 ) , `faxexten` VARCHAR( 20 ) , `faxemail` VARCHAR( 50 ) , `answer` TINYINT( 1 ) , `wait` INT( 2 ) , `privacyman` TINYINT( 1 ) , alertinfo VARCHAR( 32 ) , `channel` VARCHAR( 20 ) ); 
     192-- 
     193-- 
    188194 
    189195CREATE TABLE IF NOT EXISTS `Backup` (`Name` varchar(50) default NULL,`Voicemail` varchar(50) default NULL,`Recordings` varchar(50) default NULL,`Configurations` varchar(50) default NULL,`CDR` varchar(55) default NULL,`FOP` varchar(50) default NULL,`Minutes` varchar(50) default NULL,`Hours` varchar(50) default NULL,`Days` varchar(50) default NULL,`Months` varchar(50) default NULL,`Weekdays` varchar(50) default NULL,`Command` varchar(200) default NULL,`Method` varchar(50) default NULL,`ID` int(11) NOT NULL auto_increment,PRIMARY KEY  (ID)); 

  • freepbx/trunk/SQL/newinstall.sqlite.sql

    r1458 r1719  
    7878INSERT INTO globals VALUES ('CALLFILENAME', '""'); 
    7979INSERT INTO globals VALUES ('DIAL_OPTIONS', 'tr'); 
     80INSERT INTO globals VALUES ('TRUNK_OPTIONS', 'r'); 
    8081INSERT INTO globals VALUES ('DIAL_OUT', '9'); 
    8182INSERT INTO globals VALUES ('FAX', ''); 
    …… 
    176177CREATE TABLE devices (id VARCHAR( 20 ) NOT NULL , tech VARCHAR( 10 ) NOT NULL , dial VARCHAR( 50 ) NOT NULL , devicetype VARCHAR( 5 ) NOT NULL , user VARCHAR( 50 ) , description VARCHAR( 50 ), emergency_cid VARCHAR( 100 )); 
    177178 
    178 CREATE TABLE users (extension VARCHAR( 20 ) NOT NULL , password VARCHAR( 20 ) , name VARCHAR( 50 ) , voicemail VARCHAR( 50 ) , ringtimer INT(3) , noanswer VARCHAR( 100 ) , recording VARCHAR( 50 ) ,  outboundcid VARCHAR( 50 )); 
    179  
    180 CREATE TABLE incoming ( cidnum VARCHAR( 20 ) , extension VARCHAR( 20 ) , destination VARCHAR( 50 ) , faxexten VARCHAR( 20 ) , faxemail VARCHAR( 50 ) , answer TINYINT( 1 ) , wait INT( 2 ) , privacyman TINYINT( 1 ) , alertinfo VARCHAR( 32 )); 
     179CREATE TABLE users (extension VARCHAR( 20 ) NOT NULL , password VARCHAR( 20 ) , name VARCHAR( 50 ) , voicemail VARCHAR( 50 ) , ringtimer INT(3) , noanswer VARCHAR( 100 ) , recording VARCHAR( 50 ) ,  outboundcid VARCHAR( 50 ) , directdid VARCHAR( 50 ) NULL , didalert VARCHAR ( 50 ) NULL ); 
     180 
     181-- 
     182-- Need to incorporate their changes, comment out for now 
     183-- 
     184CREATE TABLE incoming ( cidnum VARCHAR( 20 ) , extension VARCHAR( 20 ) , destination VARCHAR( 50 ) , faxexten VARCHAR( 20 ) , faxemail VARCHAR( 50 ) , answer TINYINT( 1 ) , wait INT( 2 ) , privacyman TINYINT( 1 ) , alertinfo VARCHAR( 32 ) , channel VARCHAR( 20 )); 
     185-- 
     186-- 
    181187 
    182188CREATE TABLE Backup (Name varchar(50) default NULL,Voicemail varchar(50) default NULL,Recordings varchar(50) default NULL,Configurations varchar(50) default NULL,CDR varchar(55) default NULL,FOP varchar(50) default NULL,Minutes varchar(50) default NULL,Hours varchar(50) default NULL,Days varchar(50) default NULL,Months varchar(50) default NULL,Weekdays varchar(50) default NULL,Command varchar(200) default NULL,Method varchar(50) default NULL,ID int(11) NOT NULL,PRIMARY KEY  (ID));