CREATE TABLE `vtiger_asterisk` (
`extension` VARCHAR( 25 ) NOT NULL ,
`timestamp` BIGINT( 12 ) NOT NULL ,
`callerid` VARCHAR( 20 ) NOT NULL
) ENGINE = MYISAM ;


ALTER TABLE `vtiger_asterisk` ADD PRIMARY KEY ( `extension` ); 

ALTER table vtiger_users add extension varchar( 25 ) default NULL;

INSERT INTO `vtiger_field` ( `tabid` , `fieldid` , `columnname` , `tablename` , `generatedtype` , `uitype` , `fieldname` , `fieldlabel` , `readonly` , `presence` , `selected` , `maximumlength` , `sequence` , `block` , `displaytype` , `typeofdata` , `quickcreate` , `quickcreatesequence` , `info_type` ) VALUES ('29', NULL , 'extension', 'vtiger_users', '1', '1', 'ast_extension', 'Asterisk Extension', '1', '0', '0', '50', '13', '80', '1', 'V~O', '1', NULL , 'BAS');