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;