188 lines
8.7 KiB
SQL
188 lines
8.7 KiB
SQL
UPDATE system_settings SET db_schema_version='1379',version='2.9rc1tk',db_schema_update_date=NOW() where db_schema_version < 1379;
|
|
|
|
UPDATE system_settings SET db_schema_version='1380',version='2.10b0.5',db_schema_update_date=NOW() where db_schema_version < 1380;
|
|
|
|
ALTER TABLE vicidial_users ADD wrapup_seconds_override SMALLINT(4) default '-1';
|
|
|
|
UPDATE system_settings SET db_schema_version='1381',db_schema_update_date=NOW() where db_schema_version < 1381;
|
|
|
|
ALTER TABLE vicidial_inbound_dids ADD no_agent_ingroup_redirect ENUM('DISABLED','Y','NO_PAUSED','READY_ONLY') default 'DISABLED';
|
|
ALTER TABLE vicidial_inbound_dids ADD no_agent_ingroup_id VARCHAR(20) default '';
|
|
ALTER TABLE vicidial_inbound_dids ADD no_agent_ingroup_extension VARCHAR(50) default '9998811112';
|
|
ALTER TABLE vicidial_inbound_dids ADD pre_filter_phone_group_id VARCHAR(20) default '';
|
|
ALTER TABLE vicidial_inbound_dids ADD pre_filter_extension VARCHAR(50) default '';
|
|
|
|
UPDATE system_settings SET db_schema_version='1382',db_schema_update_date=NOW() where db_schema_version < 1382;
|
|
|
|
ALTER TABLE vicidial_campaigns ADD wrapup_bypass ENUM('DISABLED','ENABLED') default 'ENABLED';
|
|
|
|
UPDATE system_settings SET db_schema_version='1383',db_schema_update_date=NOW() where db_schema_version < 1383;
|
|
|
|
ALTER TABLE vicidial_campaigns ADD wrapup_after_hotkey ENUM('DISABLED','ENABLED') default 'DISABLED';
|
|
|
|
UPDATE system_settings SET db_schema_version='1384',db_schema_update_date=NOW() where db_schema_version < 1384;
|
|
|
|
ALTER TABLE system_settings ADD callback_time_24hour ENUM('0','1') default '0';
|
|
|
|
UPDATE system_settings SET db_schema_version='1385',db_schema_update_date=NOW() where db_schema_version < 1385;
|
|
|
|
ALTER TABLE vicidial_campaigns ADD callback_active_limit SMALLINT(5) UNSIGNED default '0';
|
|
ALTER TABLE vicidial_campaigns ADD callback_active_limit_override ENUM('N','Y') default 'N';
|
|
|
|
UPDATE system_settings SET db_schema_version='1386',db_schema_update_date=NOW() where db_schema_version < 1386;
|
|
|
|
ALTER TABLE system_settings ADD active_modules TEXT;
|
|
ALTER TABLE system_settings ADD allow_chats ENUM('0','1') default '0';
|
|
ALTER TABLE vicidial_campaigns ADD allow_chats ENUM('Y','N') default 'N';
|
|
ALTER TABLE vicidial_user_groups MODIFY shift_enforcement ENUM('OFF','START','ALL','ADMIN_EXEMPT') default 'OFF';
|
|
|
|
CREATE TABLE vicidial_avatars (
|
|
avatar_id VARCHAR(100) PRIMARY KEY NOT NULL,
|
|
avatar_name VARCHAR(100),
|
|
avatar_notes TEXT,
|
|
avatar_api_user VARCHAR(20) default '',
|
|
avatar_api_pass VARCHAR(20) default '',
|
|
active ENUM('Y','N') default 'Y',
|
|
audio_functions VARCHAR(100) default 'PLAY-STOP-RESTART',
|
|
audio_display VARCHAR(100) default 'FILE-NAME',
|
|
user_group VARCHAR(20) default '---ALL---'
|
|
) ENGINE=MyISAM;
|
|
|
|
CREATE TABLE vicidial_avatar_audio (
|
|
avatar_id VARCHAR(100) NOT NULL,
|
|
audio_filename VARCHAR(255) NOT NULL,
|
|
audio_name TEXT,
|
|
rank SMALLINT(5) default '0',
|
|
h_ord SMALLINT(5) default '1',
|
|
level SMALLINT(5) default '1',
|
|
parent_audio_filename VARCHAR(255) default '',
|
|
parent_rank VARCHAR(2) default '',
|
|
index (avatar_id)
|
|
) ENGINE=MyISAM;
|
|
|
|
UPDATE system_settings SET db_schema_version='1387',db_schema_update_date=NOW() where db_schema_version < 1387;
|
|
|
|
ALTER TABLE vicidial_campaigns ADD comments_all_tabs ENUM('DISABLED','ENABLED') default 'DISABLED';
|
|
ALTER TABLE vicidial_campaigns ADD comments_dispo_screen ENUM('DISABLED','ENABLED','REPLACE_CALL_NOTES') default 'DISABLED';
|
|
ALTER TABLE vicidial_campaigns ADD comments_callback_screen ENUM('DISABLED','ENABLED','REPLACE_CB_NOTES') default 'DISABLED';
|
|
ALTER TABLE vicidial_campaigns ADD qc_comment_history ENUM('CLICK','AUTO_OPEN','CLICK_ALLOW_MINIMIZE','AUTO_OPEN_ALLOW_MINIMIZE') default 'CLICK';
|
|
|
|
UPDATE system_settings SET db_schema_version='1388',db_schema_update_date=NOW() where db_schema_version < 1388;
|
|
|
|
ALTER TABLE vicidial_campaigns ADD show_previous_callback ENUM('DISABLED','ENABLED') default 'ENABLED';
|
|
|
|
UPDATE system_settings SET db_schema_version='1389',db_schema_update_date=NOW() where db_schema_version < 1389;
|
|
|
|
ALTER TABLE vicidial_campaigns ADD clear_script ENUM('DISABLED','ENABLED') default 'DISABLED';
|
|
|
|
UPDATE system_settings SET db_schema_version='1390',db_schema_update_date=NOW() where db_schema_version < 1390;
|
|
|
|
ALTER TABLE vicidial_comments MODIFY user_id VARCHAR(20) NOT NULL;
|
|
ALTER TABLE vicidial_comments MODIFY campaign_id VARCHAR(8) NOT NULL;
|
|
|
|
UPDATE system_settings SET db_schema_version='1391',db_schema_update_date=NOW() where db_schema_version < 1391;
|
|
|
|
CREATE TABLE audio_store_details (
|
|
audio_filename VARCHAR(255) NOT NULL,
|
|
audio_format VARCHAR(10) default 'unknown',
|
|
audio_filesize BIGINT(20) UNSIGNED default '0',
|
|
audio_epoch BIGINT(20) UNSIGNED default '0',
|
|
audio_length INT(10) UNSIGNED default '0',
|
|
unique index (audio_filename)
|
|
) ENGINE=MyISAM;
|
|
|
|
UPDATE system_settings SET db_schema_version='1392',db_schema_update_date=NOW() where db_schema_version < 1392;
|
|
|
|
CREATE TABLE www_phrases (
|
|
phrase_id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
|
|
phrase_text VARCHAR(10000) default '',
|
|
php_filename VARCHAR(255) NOT NULL,
|
|
php_directory VARCHAR(255) default '',
|
|
source VARCHAR(20) default '',
|
|
index (phrase_text)
|
|
) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci;
|
|
|
|
ALTER TABLE vicidial_webservers MODIFY webserver VARCHAR(125) default '';
|
|
ALTER TABLE vicidial_webservers MODIFY hostname VARCHAR(125) default '';
|
|
|
|
ALTER TABLE vicidial_urls MODIFY url VARCHAR(255) default '';
|
|
|
|
UPDATE system_settings SET db_schema_version='1393',db_schema_update_date=NOW() where db_schema_version < 1393;
|
|
|
|
ALTER TABLE system_settings ADD enable_languages ENUM('0','1') default '0';
|
|
|
|
ALTER TABLE vicidial_users ADD modify_languages ENUM('1','0') default '0';
|
|
|
|
CREATE TABLE vicidial_languages (
|
|
language_id VARCHAR(100) NOT NULL,
|
|
language_code VARCHAR(20) default '',
|
|
language_description VARCHAR(255) default '',
|
|
user_group VARCHAR(20) default '---ALL---',
|
|
modify_date TIMESTAMP,
|
|
unique index (language_id)
|
|
) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci;
|
|
|
|
CREATE TABLE vicidial_language_phrases (
|
|
phrase_id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
|
|
language_id VARCHAR(100) NOT NULL,
|
|
english_text VARCHAR(10000) default '',
|
|
translated_text TEXT,
|
|
source VARCHAR(20) default '',
|
|
modify_date TIMESTAMP,
|
|
index (language_id),
|
|
index (english_text)
|
|
) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci;
|
|
|
|
UPDATE system_settings SET db_schema_version='1394',db_schema_update_date=NOW() where db_schema_version < 1394;
|
|
|
|
ALTER TABLE vicidial_campaigns ADD cpd_unknown_action ENUM('DISABLED','DISPO','MESSAGE','CALLMENU','INGROUP') default 'DISABLED';
|
|
|
|
ALTER TABLE vicidial_lists ADD na_call_url TEXT;
|
|
|
|
ALTER TABLE www_phrases ADD insert_date DATETIME;
|
|
|
|
UPDATE system_settings SET db_schema_version='1395',db_schema_update_date=NOW() where db_schema_version < 1395;
|
|
|
|
ALTER TABLE vicidial_users ADD selected_language VARCHAR(100) default 'default English';
|
|
ALTER TABLE vicidial_users ADD user_choose_language ENUM('1','0') default '0';
|
|
|
|
ALTER TABLE vicidial_languages ADD active ENUM('Y','N') default 'N';
|
|
|
|
ALTER TABLE system_settings ADD language_method VARCHAR(20) default 'DISABLED';
|
|
|
|
UPDATE system_settings SET db_schema_version='1396',db_schema_update_date=NOW() where db_schema_version < 1396;
|
|
|
|
ALTER TABLE vicidial_users ADD ignore_group_on_search ENUM('1','0') default '0';
|
|
|
|
UPDATE system_settings SET db_schema_version='1397',db_schema_update_date=NOW() where db_schema_version < 1397;
|
|
|
|
CREATE INDEX vlali on vicidial_live_agents (lead_id);
|
|
CREATE INDEX vlaus on vicidial_live_agents (user);
|
|
|
|
UPDATE system_settings SET db_schema_version='1398',db_schema_update_date=NOW() where db_schema_version < 1398;
|
|
|
|
ALTER TABLE vicidial_live_agents MODIFY external_transferconf VARCHAR(120) default '';
|
|
|
|
UPDATE system_settings SET db_schema_version='1399',db_schema_update_date=NOW() where db_schema_version < 1399;
|
|
|
|
ALTER TABLE vicidial_lists ADD local_call_time VARCHAR(10) NOT NULL DEFAULT 'campaign';
|
|
|
|
ALTER TABLE vicidial_campaigns ADD manual_dial_search_filter VARCHAR(50) default 'NONE';
|
|
|
|
UPDATE system_settings SET db_schema_version='1400',db_schema_update_date=NOW() where db_schema_version < 1400;
|
|
|
|
ALTER TABLE vicidial_campaigns MODIFY manual_dial_search_checkbox ENUM('SELECTED','SELECTED_RESET','UNSELECTED','UNSELECTED_RESET','SELECTED_LOCK','UNSELECTED_LOCK') default 'SELECTED';
|
|
|
|
UPDATE system_settings SET db_schema_version='1401',db_schema_update_date=NOW() where db_schema_version < 1401;
|
|
|
|
ALTER TABLE vicidial_voicemail ADD on_login_report enum('Y','N') NOT NULL default 'N';
|
|
|
|
ALTER TABLE phones ADD on_login_report enum('Y','N') NOT NULL default 'N';
|
|
|
|
UPDATE system_settings SET db_schema_version='1402',db_schema_update_date=NOW() where db_schema_version < 1402;
|
|
|
|
CREATE TABLE vicidial_callbacks_archive LIKE vicidial_callbacks;
|
|
ALTER TABLE vicidial_callbacks_archive MODIFY callback_id INT(9) UNSIGNED NOT NULL;
|
|
|
|
UPDATE system_settings SET db_schema_version='1403',db_schema_update_date=NOW() where db_schema_version < 1403;
|