<commit_before>-- DROP PROCEDURE IF EXISTS sp_infoticos;
-- DELIMITER //
-- Delimiter isn't need on php
CREATE PROCEDURE sp_install_routines
()
BEGIN
###### default users
INSERT INTO users
(id, user_name, user_hash, system_generated_password, <PASSWORD>, authenticate_id, sugar_login, first_name, last_name, is_admin, external_auth_only, receive_notifications, description, date_entered, date_modified, modified_user_id, created_by, title, photo, department, phone_home, phone_mobile, phone_work, phone_other, phone_fax, status, address_street, address_city, address_state, address_country, address_postalcode, deleted, portal_only, show_on_employees, employee_status, messenger_id, messenger_type, reports_to_id, is_group)
VALUES('2', 'sync', md5(utc_timestamp()), 1, utc_timestamp(), NULL, 1, 'Sync Bot', 'Lionix evolve', 0, 0, 1, '', utc_timestamp(), utc_timestamp(), '1', '1', '', NULL, '', '', '', '', '', '', 'Active', '', '', '', 'Costa Rica', '', 0, 0, 1, 'Active', '', '', '', 0);

INSERT INTO users
(id, user_name, user_hash, system_generated_password, <PASSWORD>, authenticate_id, sugar_login, first_name, last_name, is_admin, external_auth_only, receive_notifications, description, date_entered, date_modified, modified_user_id, created_by, title, photo, department, phone_home, phone_mobile, phone_work, phone_other, phone_fax, status, address_street, address_city, address_state, address_country, address_postalcode, deleted, portal_only, show_on_employees, employee_status, messenger_id, messenger_type, reports_to_id, is_group)
VALUES('reasignar', 'reasignar', md5(utc_timestamp()), 1, utc_timestamp(), NULL, 1, 'Reasignar - Usuario Temporal', 'Lionix evolve', 0, 0, 1, '', utc_timestamp(), utc_timestamp(), '1', '1', '', NULL, '', '', '', '', '', '', 'Active', '', '', '', '', '', 0, 0, 0, 'Active', '', '', '', 0);

INSERT INTO users
(id, user_name, user_hash, system_generated_password, <PASSWORD>, authenticate_id, sugar_login, first_name, last_name, is_admin, external_auth_only, receive_notifications, description, date_entered, date_modified, modified_user_id, created_by, title, photo, department, phone_home, phone_mobile, phone_work, phone_other, phone_fax, status, address_street, address_city, address_state, address_country, address_postalcode, deleted, portal_only, show_on_employees, employee_status, messenger_id, messenger_type, reports_to_id, is_group)
VALUES('bot', 'bot', md5(utc_timestamp()), 1, utc_timestamp(), NULL, 1, 'Bot', 'Lionix evolve', 0, 0, 1, '', utc_timestamp(), utc_timestamp(), '1', '1', '', NULL, '', '', '', '', '', '', 'Active', '', '', '', '', '', 0, 0, 0, 'Active', '', '', '', 0);

INSERT INTO users
(id, user_name, user_hash, system_generated_password, <PASSWORD>, authenticate_id, sugar_login, first_name, last_name, reports_to_id, is_admin, external_auth_only, receive_notifications, description, date_entered, date_modified, modified_user_id, created_by, title, department, phone_home, phone_mobile, phone_work, phone_other, phone_fax, status, address_street, address_city, address_state, address_country, address_postalcode, deleted, portal_only, employee_status, messenger_id, messenger_type, is_group, show_on_employees)
VALUES('test', 'test', 'md5(utc_timestamp())', 0, NULL, NULL, 1, 'Usuario Pruebas', 'Lionix evolve', NULL, 0, 0, 1, NULL, utc_timestamp(), utc_timestamp(), '1', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Active', NULL, NULL, NULL, NULL, NULL, 0, 0, 'Active', NULL, NULL, 0, 1);

INSERT INTO users
(id, user_name, user_hash, system_generated_password, <PASSWORD>_<PASSWORD>_changed, authenticate_id, sugar_login, first_name, last_name, is_admin, external_auth_only, receive_notifications, description, date_entered, date_modified, modified_user_id, created_by, title, photo, department, phone_home, phone_mobile, phone_work, phone_other, phone_fax, status, address_street, address_city, address_state, address_country, address_postalcode, deleted, portal_only, show_on_employees, employee_status, messenger_id, messenger_type, reports_to_id, is_group)
VALUES('support', 'support', md5(utc_timestamp()), 1, utc_timestamp(), NULL, 1, 'Soporte', 'Lionix evolve', 0, 0, 1, '', utc_timestamp(), utc_timestamp(), '1', '1', '', NULL, '', '', '', '', '', '', 'Active', '', '', '', '', '', 0, 0, 0, 'Active', '', '', '', 0);

###### custom fields on cases module
ALTER TABLE cases_cstm add COLUMN elapsedtimeinmins_c int(255) DEFAULT '0' NULL;

INSERT INTO fields_meta_data (id,name,vname,comments,help,custom_module,type,len,required,default_value,date_modified,deleted,audited,massupdate,duplicate_merge,reportable,importable,ext1,ext2,ext3,ext4) VALUES ('Caseselapsedtimeinmins_c','elapsedtimeinmins_c','LBL_ELAPSEDTIMEINMINS','This time is calculated on schedulers with function WORKDAY_TIME_DIFF_HOLIDAY_TABLE','This time is calculated on schedulers with function WORKDAY_TIME_DIFF_HOLIDAY_TABLE','Cases','int','255','0','0',utc_timestamp(),'0','0','0','0','1','false','','','1','');

###### custom fields on campaigns module
CREATE TABLE campaigns_cstm (id_c char(36) NOT NULL, PRIMARY KEY (id_c)) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE campaigns_cstm add COLUMN emailmaner_c bool DEFAULT '0' NULL;
ALTER TABLE campaigns_cstm add COLUMN clearcamplogdaily_c bool DEFAULT '0' NULL;

INSERT INTO fields_meta_data (id,name,vname,comments,help,custom_module,type,len,required,default_value,date_modified,deleted,audited,massupdate,duplicate_merge,reportable,importable,ext1,ext2,ext3,ext4)
VALUES ('Campaignsemailmaner_c','emailmaner_c','LBL_EMAILMANER','','','Campaigns','bool',255,0,'0',utc_timestamp(),0,0,0,0,1,'false','','','','');

INSERT INTO fields_meta_data (id,name,vname,comments,help,custom_module,type,len,required,default_value,date_modified,deleted,audited,massupdate,duplicate_merge,reportable,importable,ext1,ext2,ext3,ext4)
VALUES ('Campaignsclearcamplogdaily_c','clearcamplogdaily_c','LBL_CLEARCAMPLOGDAILY','','','Campaigns','bool',255,0,'0',utc_timestamp(),0,0,0,0,1,'false','','','','');

###### custom fields and records on prospect_lists module
CREATE TABLE prospect_lists_cstm (id_c char(36) NOT NULL, PRIMARY KEY (id_c)) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE prospect_lists_cstm add COLUMN autofill_c bool DEFAULT '0' NULL;
ALTER TABLE prospect_lists_cstm add COLUMN autoclean_c bool DEFAULT '0' NULL;
<commit_msg>refactor: users labels<commit_after>-- DROP PROCEDURE IF EXISTS sp_infoticos;
-- DELIMITER //
-- Delimiter isn't need on php
CREATE PROCEDURE sp_install_routines
()
BEGIN
###### default users
INSERT INTO users
(id, user_name, user_hash, system_generated_password, <PASSWORD>, authenticate_id, sugar_login, first_name, last_name, is_admin, external_auth_only, receive_notifications, description, date_entered, date_modified, modified_user_id, created_by, title, photo, department, phone_home, phone_mobile, phone_work, phone_other, phone_fax, status, address_street, address_city, address_state, address_country, address_postalcode, deleted, portal_only, show_on_employees, employee_status, messenger_id, messenger_type, reports_to_id, is_group)
VALUES('2', 'sync', md5(utc_timestamp()), 1, utc_timestamp(), NULL, 1, 'Sync Bot', 'Lionix evolve', 0, 0, 1, '', utc_timestamp(), utc_timestamp(), '1', '1', '', NULL, '', '', '', '', '', '', 'Active', '', '', '', 'Costa Rica', '', 0, 0, 1, 'Active', '', '', '', 0);

INSERT INTO users
(id, user_name, user_hash, system_generated_password, <PASSWORD>, authenticate_id, sugar_login, first_name, last_name, is_admin, external_auth_only, receive_notifications, description, date_entered, date_modified, modified_user_id, created_by, title, photo, department, phone_home, phone_mobile, phone_work, phone_other, phone_fax, status, address_street, address_city, address_state, address_country, address_postalcode, deleted, portal_only, show_on_employees, employee_status, messenger_id, messenger_type, reports_to_id, is_group)
VALUES('reasignar', 'reasignar', md5(utc_timestamp()), 1, utc_timestamp(), NULL, 1, 'Reasignar', 'Usuario temporal', 0, 0, 1, '', utc_timestamp(), utc_timestamp(), '1', '1', '', NULL, '', '', '', '', '', '', 'Active', '', '', '', '', '', 0, 0, 0, 'Active', '', '', '', 0);

INSERT INTO users
(id, user_name, user_hash, system_generated_password, <PASSWORD>, authenticate_id, sugar_login, first_name, last_name, is_admin, external_auth_only, receive_notifications, description, date_entered, date_modified, modified_user_id, created_by, title, photo, department, phone_home, phone_mobile, phone_work, phone_other, phone_fax, status, address_street, address_city, address_state, address_country, address_postalcode, deleted, portal_only, show_on_employees, employee_status, messenger_id, messenger_type, reports_to_id, is_group)
VALUES('bot', 'bot', md5(utc_timestamp()), 1, utc_timestamp(), NULL, 1, 'Multi Purpose Bot', 'Lionix evolve', 0, 0, 1, '', utc_timestamp(), utc_timestamp(), '1', '1', '', NULL, '', '', '', '', '', '', 'Active', '', '', '', '', '', 0, 0, 0, 'Active', '', '', '', 0);

INSERT INTO users
(id, user_name, user_hash, system_generated_password, <PASSWORD>, authenticate_id, sugar_login, first_name, last_name, reports_to_id, is_admin, external_auth_only, receive_notifications, description, date_entered, date_modified, modified_user_id, created_by, title, department, phone_home, phone_mobile, phone_work, phone_other, phone_fax, status, address_street, address_city, address_state, address_country, address_postalcode, deleted, portal_only, employee_status, messenger_id, messenger_type, is_group, show_on_employees)
VALUES('test', 'test', 'md5(utc_timestamp())', 0, NULL, NULL, 1, 'Usuario Pruebas', 'Lionix evolve', NULL, 0, 0, 1, NULL, utc_timestamp(), utc_timestamp(), '1', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Active', NULL, NULL, NULL, NULL, NULL, 0, 0, 'Active', NULL, NULL, 0, 1);

INSERT INTO users
(id, user_name, user_hash, system_generated_password, pwd_last_changed, authenticate_id, sugar_login, first_name, last_name, is_admin, external_auth_only, receive_notifications, description, date_entered, date_modified, modified_user_id, created_by, title, photo, department, phone_home, phone_mobile, phone_work, phone_other, phone_fax, status, address_street, address_city, address_state, address_country, address_postalcode, deleted, portal_only, show_on_employees, employee_status, messenger_id, messenger_type, reports_to_id, is_group)
VALUES('support', 'support', md5(utc_timestamp()), 1, utc_timestamp(), NULL, 1, 'Soporte', 'Lionix evolve', 0, 0, 1, '', utc_timestamp(), utc_timestamp(), '1', '1', '', NULL, '', '', '', '', '', '', 'Active', '', '', '', '', '', 0, 0, 0, 'Active', '', '', '', 0);

###### custom fields on cases module
ALTER TABLE cases_cstm add COLUMN elapsedtimeinmins_c int(255) DEFAULT '0' NULL;

INSERT INTO fields_meta_data (id,name,vname,comments,help,custom_module,type,len,required,default_value,date_modified,deleted,audited,massupdate,duplicate_merge,reportable,importable,ext1,ext2,ext3,ext4) VALUES ('Caseselapsedtimeinmins_c','elapsedtimeinmins_c','LBL_ELAPSEDTIMEINMINS','This time is calculated on schedulers with function WORKDAY_TIME_DIFF_HOLIDAY_TABLE','This time is calculated on schedulers with function WORKDAY_TIME_DIFF_HOLIDAY_TABLE','Cases','int','255','0','0',utc_timestamp(),'0','0','0','0','1','false','','','1','');

###### custom fields on campaigns module
CREATE TABLE campaigns_cstm (id_c char(36) NOT NULL, PRIMARY KEY (id_c)) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE campaigns_cstm add COLUMN emailmaner_c bool DEFAULT '0' NULL;
ALTER TABLE campaigns_cstm add COLUMN clearcamplogdaily_c bool DEFAULT '0' NULL;

INSERT INTO fields_meta_data (id,name,vname,comments,help,custom_module,type,len,required,default_value,date_modified,deleted,audited,massupdate,duplicate_merge,reportable,importable,ext1,ext2,ext3,ext4)
VALUES ('Campaignsemailmaner_c','emailmaner_c','LBL_EMAILMANER','','','Campaigns','bool',255,0,'0',utc_timestamp(),0,0,0,0,1,'false','','','','');

INSERT INTO fields_meta_data (id,name,vname,comments,help,custom_module,type,len,required,default_value,date_modified,deleted,audited,massupdate,duplicate_merge,reportable,importable,ext1,ext2,ext3,ext4)
VALUES ('Campaignsclearcamplogdaily_c','clearcamplogdaily_c','LBL_CLEARCAMPLOGDAILY','','','Campaigns','bool',255,0,'0',utc_timestamp(),0,0,0,0,1,'false','','','','');

###### custom fields and records on prospect_lists module
CREATE TABLE prospect_lists_cstm (id_c char(36) NOT NULL, PRIMARY KEY (id_c)) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE prospect_lists_cstm add COLUMN autofill_c bool DEFAULT '0' NULL;
ALTER TABLE prospect_lists_cstm add COLUMN autoclean_c bool DEFAULT '0' NULL;

{'fraction_non_alphanumeric': 0.1537614101353478, 'fraction_numerical': 0.018885741265344664, 'mean_word_length': 9.761219305673158, 'pattern_counts': {'":': 0, '<': 13, '<?xml version=': 0, '>': 13, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 14, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '1083845', 'n_tokens_mistral': 4409, 'n_tokens_neox': 4179, 'n_words': 1000}