predictive_added.sql
957 Bytes
CREATE TABLE `cut_off_time` (
`id` int(11) NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`user_id` int(11) NOT NULL,
`hangup_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`avg_dispo` int(11) NOT NULL,
`avg_ring` int(11) NOT NULL,
`c_id` int(11) NOT NULL,
`c_name` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
ALTER TABLE `cut_off_time`
ADD PRIMARY KEY (`id`);
ALTER TABLE `cut_off_time`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
ALTER TABLE `diallines` ADD `user_id` INT NOT NULL AFTER `server`;
ALTER TABLE `sipids` ADD `patched` TINYINT(1) NOT NULL AFTER `ready`, ADD `prepare_call` TINYINT(1) NOT NULL AFTER `patched`;
ALTER TABLE `users` ADD `sel_campaign` VARCHAR(50) NOT NULL AFTER `dialmode_assign`, ADD `current_dialmode` VARCHAR(20) NOT NULL AFTER `sel_campaign`, CHANGE `dialmode_assign` `dialmode_assign` VARCHAR(200) NOT NULL;