Live Helper Chat Adding MySQL table for Twilio
Live Helper Chat Adding MySQL table for Twilio
https://github.com/LiveHelperChat/twilio
1. Pasts the Twilio extension to your Live Helper Chat web server extension folder.
2. Copy extension/twilio/settings.ini.default.php to extension/twilio/settings.ini.php
3. Login into phpAdmin and select the Live Helper Chat DB, Click the SQL tab, copy two lines below then click Go
CREATE TABLE `lhc_twilio_chat` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `chat_id` bigint(20) unsigned NOT NULL, `phone` varchar(35) NOT NULL, `ctime` int(11) NOT NULL, `utime` int(11) NOT NULL, `tphone_id` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `phone_utime` (`phone`,`utime`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `lhc_twilio_phone` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `phone` varchar(35) NOT NULL, `base_phone` varchar(35) NOT NULL, `originator` varchar(35) NOT NULL, `account_sid` varchar(35), `auth_token` varchar(35), `dep_id` int(11) unsigned NOT NULL, `chat_timeout` int(11) unsigned NOT NULL, `responder_timeout` int(11) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `phone` (`phone`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;4. Enable the extension in settings/settings.ini.php
'extensions' =>
array (
'twilio'
),5. Clear cache from the setting.
Comments
Post a Comment