state

CREATE TABLE phones ( extension VARCHAR(100), dialplan_number VARCHAR(20), voicemail_id VARCHAR(10), phone_ip VARCHAR(15), computer_ip VARCHAR(15), server_ip VARCHAR(15), login VARCHAR(15), pass VARCHAR(10), status VARCHAR(10), active ENUM(‘Y’,’N’), phone_type VARCHAR(50), fullname VARCHAR(50), company VARCHAR(10), picture VARCHAR(19), messages INT(4), old_messages INT(4), protocol ENUM(‘SIP’,’Zap’,’IAX2′,’EXTERNAL’) default ‘SIP’, local_gmt VARCHAR(6) default ‘-5.00’, ASTmgrUSERNAME VARCHAR(20) default ‘cron’, ASTmgrSECRET VARCHAR(20) default ‘1234’, login_user VARCHAR(20), login_pass … Read more