<commit_before>-- Remember to set as <<[client] default-character-set   = utf8>>
-- in /etc/mysql/my.cnf or foreign characters will be corrupted to db

INSERT INTO `hd0`.`Service` (`company`, `type`, `location`, `username`, `password`, `namespace`) 
	VALUES ('<NAME>.', 'OTRS', 'http://localhost/otrs/nph-genericinterface.pl/Webservice/GenericTicketConnector', 'hd0', 'hd0', 'http://www.otrs.org/TicketConnector/');
	

INSERT INTO `hd0`.`Filter` (`id`, `code`, `responce`, `question`, `askedBy_id`)
	VALUES	(NULL, 'q05ar', NULL, 'Da quale dispositivo hai acceduto al servizio?',
			NULL);

INSERT INTO `hd0`.`Filter` (`id`, `code`, `responce`, `question`, `askedBy_id`)
	SELECT NULL, 'q05ar1',
		'PC', 'Che browser hai utilizzato per accedere al servizio?',
		id FROM `hd0`.`Filter` WHERE code = 'q05ar';
INSERT INTO `hd0`.`Filter` (`id`, `code`, `responce`, `question`, `askedBy_id`)
	SELECT NULL, 'q05ar2',
		'Terminale', 'In che momento si è riscontrato il problema?',
		id FROM `hd0`.`Filter` WHERE code = 'q05ar';
INSERT INTO `hd0`.`Filter` (`id`, `code`, `responce`, `question`, `askedBy_id`)
	SELECT NULL, 'q05ar3',
		'Smartphone',
		'Che modello di smarphone hai utilizzato per accedere al servizio?',
		id FROM `hd0`.`Filter` WHERE code = 'q05ar';
INSERT INTO `hd0`.`Filter` (`id`, `code`, `responce`, `question`, `askedBy_id`)
	SELECT NULL, 'q05ar4',
		'Altro',
		'Nono sono supportati altri dispositivi per questo applicativo!',
		id FROM `hd0`.`Filter` WHERE code = 'q05ar';
INSERT INTO `hd0`.`Filter` (`id`, `code`, `responce`, `question`, `askedBy_id`)
	SELECT NULL, 'q05ar5',
		'Non ricordo',
		NULL,
		id FROM `hd0`.`Filter` WHERE code = 'q05ar';		
		
INSERT INTO `hd0`.`Filter` (`id`, `code`, `responce`, `question`, `askedBy_id`)
	SELECT NULL, 'q05a1r1',
		'Internet Explorer', NULL,
		id FROM `hd0`.`Filter` WHERE code = 'q05ar1';
INSERT INTO `hd0`.`Filter` (`id`, `code`, `responce`, `question`, `askedBy_id`)
	SELECT NULL, 'q05a1r2',
		'Firefox', NULL,
		id FROM `hd0`.`Filter` WHERE code = 'q05ar1';
INSERT INTO `hd0`.`Filter` (`id`, `code`, `responce`, `question`, `askedBy_id`)
	SELECT NULL, 'q05a1r3',
		'Chrome', NULL,
		id FROM `hd0`.`Filter` WHERE code = 'q05ar1';
INSERT INTO `hd0`.`Filter` (`id`, `code`, `responce`, `question`, `askedBy_id`)
	SELECT NULL, 'q05a1r4',
		'Altro', NULL,
		id FROM `hd0`.`Filter` WHERE code = 'q05ar1';

INSERT INTO `hd0`.`Filter` (`id`, `code`, `responce`, `question`, `askedBy_id`)
	SELECT NULL, 'q05a4r1',
		'Accesso al servizio', NULL,
		id FROM `hd0`.`Filter` WHERE code = 'q05ar2';
INSERT INTO `hd0`.`Filter` (`id`, `code`, `responce`, `question`, `askedBy_id`)
	SELECT NULL, 'q05a4r2',
		'Gestione delle utenze', NULL,
		id FROM `hd0`.`Filter` WHERE code = 'q05ar2';
INSERT INTO `hd0`.`Filter` (`id`, `code`, `responce`, `question`, `askedBy_id`)
	SELECT NULL, 'q05a4r3',<commit_msg>little text change<commit_after>-- Remember to set as <<[client] default-character-set   = utf8>>
-- in /etc/mysql/my.cnf or foreign characters will be corrupted to db

INSERT INTO `hd0`.`Service` (`company`, `type`, `location`, `username`, `password`, `namespace`) 
	VALUES ('Zenatek S.P.A.', 'OTRS', 'http://localhost/otrs/nph-genericinterface.pl/Webservice/GenericTicketConnector', 'hd0', 'hd0', 'http://www.otrs.org/TicketConnector/');
	

INSERT INTO `hd0`.`Filter` (`id`, `code`, `responce`, `question`, `askedBy_id`)
	VALUES	(NULL, 'q05ar', NULL, 'Da quale dispositivo hai acceduto al servizio?',
			NULL);

INSERT INTO `hd0`.`Filter` (`id`, `code`, `responce`, `question`, `askedBy_id`)
	SELECT NULL, 'q05ar1',
		'PC', 'Che browser hai utilizzato per accedere al servizio?',
		id FROM `hd0`.`Filter` WHERE code = 'q05ar';
INSERT INTO `hd0`.`Filter` (`id`, `code`, `responce`, `question`, `askedBy_id`)
	SELECT NULL, 'q05ar2',
		'Terminale', 'In che momento si è riscontrato il problema?',
		id FROM `hd0`.`Filter` WHERE code = 'q05ar';
INSERT INTO `hd0`.`Filter` (`id`, `code`, `responce`, `question`, `askedBy_id`)
	SELECT NULL, 'q05ar3',
		'Smartphone',
		'Che modello di smarphone hai utilizzato per accedere al servizio?',
		id FROM `hd0`.`Filter` WHERE code = 'q05ar';
INSERT INTO `hd0`.`Filter` (`id`, `code`, `responce`, `question`, `askedBy_id`)
	SELECT NULL, 'q05ar4',
		'Altro',
		'Nono sono supportati altri dispositivi per questo applicativo!',
		id FROM `hd0`.`Filter` WHERE code = 'q05ar';
INSERT INTO `hd0`.`Filter` (`id`, `code`, `responce`, `question`, `askedBy_id`)
	SELECT NULL, 'q05ar5',
		'Non ricordo / Non saprei',
		NULL,
		id FROM `hd0`.`Filter` WHERE code = 'q05ar';		
		
INSERT INTO `hd0`.`Filter` (`id`, `code`, `responce`, `question`, `askedBy_id`)
	SELECT NULL, 'q05a1r1',
		'Internet Explorer', NULL,
		id FROM `hd0`.`Filter` WHERE code = 'q05ar1';
INSERT INTO `hd0`.`Filter` (`id`, `code`, `responce`, `question`, `askedBy_id`)
	SELECT NULL, 'q05a1r2',
		'Firefox', NULL,
		id FROM `hd0`.`Filter` WHERE code = 'q05ar1';
INSERT INTO `hd0`.`Filter` (`id`, `code`, `responce`, `question`, `askedBy_id`)
	SELECT NULL, 'q05a1r3',
		'Chrome', NULL,
		id FROM `hd0`.`Filter` WHERE code = 'q05ar1';
INSERT INTO `hd0`.`Filter` (`id`, `code`, `responce`, `question`, `askedBy_id`)
	SELECT NULL, 'q05a1r4',
		'Altro', NULL,
		id FROM `hd0`.`Filter` WHERE code = 'q05ar1';

INSERT INTO `hd0`.`Filter` (`id`, `code`, `responce`, `question`, `askedBy_id`)
	SELECT NULL, 'q05a4r1',
		'Accesso al servizio', NULL,
		id FROM `hd0`.`Filter` WHERE code = 'q05ar2';
INSERT INTO `hd0`.`Filter` (`id`, `code`, `responce`, `question`, `askedBy_id`)
	SELECT NULL, 'q05a4r2',
		'Gestione delle utenze', NULL,
		id FROM `hd0`.`Filter` WHERE code = 'q05ar2';
INSERT INTO `hd0`.`Filter` (`id`, `code`, `responce`, `question`, `askedBy_id`)
	SELECT NULL, 'q05a4r3',
{'fraction_non_alphanumeric': 0.19965065502183407, 'fraction_numerical': 0.03528384279475982, 'mean_word_length': 5.251091703056769, 'pattern_counts': {'":': 0, '<': 8, '<?xml version=': 0, '>': 8, 'https://': 0, 'lorem ipsum': 0, 'www.': 2, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3177004', 'n_tokens_mistral': 2374, 'n_tokens_neox': 2206, 'n_words': 624}