"Fossies" - the Fresh Open Source Software Archive 
As a special service "Fossies" has tried to format the requested source page into HTML format using (guessed) PL/SQL source code syntax highlighting (style:
standard) with prefixed line numbers.
Alternatively you can here
view or
download the uninterpreted source code file.
1 START TRANSACTION;
2
3 ALTER TABLE treport_content ADD COLUMN `recursion` TINYINT(1) default NULL;
4
5 ALTER TABLE tevent_filter ADD COLUMN `user_comment` text NOT NULL;
6 ALTER TABLE tevent_filter ADD COLUMN `source` tinytext NOT NULL;
7 ALTER TABLE tevent_filter ADD COLUMN `id_extra` tinytext NOT NULL;
8
9 ALTER TABLE tagente_modulo ALTER COLUMN `parent_module_id` SET default 0;
10
11 -- Changes for the 'service like status' feature (Carrefour)
12 ALTER TABLE `tlayout_data` ADD COLUMN `linked_layout_status_type` ENUM ('default', 'weight', 'service') DEFAULT 'default';
13 ALTER TABLE `tlayout_data` ADD COLUMN `linked_layout_status_as_service_warning` FLOAT(20, 3) NOT NULL default 0;
14 ALTER TABLE `tlayout_data` ADD COLUMN `linked_layout_status_as_service_critical` FLOAT(20, 3) NOT NULL default 0;
15 ALTER TABLE `tlayout_data` ADD COLUMN `linked_layout_node_id` INT(10) NOT NULL default 0;
16 ALTER TABLE `tlayout_template_data` ADD COLUMN `linked_layout_status_type` ENUM ('default', 'weight', 'service') DEFAULT 'default';
17 ALTER TABLE `tlayout_template_data` ADD COLUMN `linked_layout_status_as_service_warning` FLOAT(20, 3) NOT NULL default 0;
18 ALTER TABLE `tlayout_template_data` ADD COLUMN `linked_layout_status_as_service_critical` FLOAT(20, 3) NOT NULL default 0;
19 ALTER TABLE `tlayout_template_data` ADD COLUMN `linked_layout_node_id` INT(10) NOT NULL default 0;
20
21 -- -----------------------------------------------------
22 -- Add column in table `treport`
23 -- -----------------------------------------------------
24
25 ALTER TABLE `treport` ADD COLUMN `hidden` tinyint(1) NOT NULL DEFAULT 0;
26
27 ALTER TABLE `trecon_task` ADD COLUMN `snmp_version` varchar(5) NOT NULL default '1';
28 ALTER TABLE `trecon_task` ADD COLUMN `snmp_auth_user` varchar(255) NOT NULL default '';
29 ALTER TABLE `trecon_task` ADD COLUMN `snmp_auth_pass` varchar(255) NOT NULL default '';
30 ALTER TABLE `trecon_task` ADD COLUMN `snmp_auth_method` varchar(25) NOT NULL default '';
31 ALTER TABLE `trecon_task` ADD COLUMN `snmp_privacy_method` varchar(25) NOT NULL default '';
32 ALTER TABLE `trecon_task` ADD COLUMN `snmp_privacy_pass` varchar(255) NOT NULL default '';
33 ALTER TABLE `trecon_task` ADD COLUMN `snmp_security_level` varchar(25) NOT NULL default '';
34 ALTER TABLE `tpolicy_modules_inventory` ADD COLUMN `custom_fields` MEDIUMBLOB NOT NULL;
35
36 CREATE TABLE IF NOT EXISTS `tlog_graph_models` (
37 `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
38 `title` TEXT NOT NULL,
39 `regexp` TEXT NOT NULL,
40 `fields` TEXT NOT NULL,
41 `average` tinyint(1) NOT NULL default '0',
42 PRIMARY KEY(`id`)
43 ) ENGINE = InnoDB DEFAULT CHARSET=utf8;
44
45 INSERT INTO tlog_graph_models VALUES (1, 'Apache log model',
46 '^.*?\s+.*".*?\s(\/.*?)\?.*1.1"\s+(.*?)\s+(.*?)\s+',
47 'pagina, html_err_code, _tiempo_', 1);
48
49 COMMIT;