· 7 years ago · Jan 02, 2019, 08:56 AM
1-- MySQL dump 10.13 Distrib 8.0.12, for Win64 (x86_64)
2--
3-- Host: dt-319 Database: sentinel_2_log
4-- ------------------------------------------------------
5-- Server version 8.0.12
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10 SET NAMES utf8 ;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Temporary view structure for view `active_tasks_list`
20--
21
22DROP TABLE IF EXISTS `active_tasks_list`;
23/*!50001 DROP VIEW IF EXISTS `active_tasks_list`*/;
24SET @saved_cs_client = @@character_set_client;
25SET character_set_client = utf8mb4;
26/*!50001 CREATE VIEW `active_tasks_list` AS SELECT
27 1 AS `ID`,
28 1 AS `Command`,
29 1 AS `Arguments`,
30 1 AS `Status`*/;
31SET character_set_client = @saved_cs_client;
32
33--
34-- Table structure for table `group_agregator`
35--
36
37DROP TABLE IF EXISTS `group_agregator`;
38/*!40101 SET @saved_cs_client = @@character_set_client */;
39 SET character_set_client = utf8mb4 ;
40CREATE TABLE `group_agregator` (
41 `ID` int(11) NOT NULL AUTO_INCREMENT,
42 `ID_group` int(11) NOT NULL,
43 `ID_node` int(11) NOT NULL,
44 PRIMARY KEY (`ID`),
45 KEY `ID_group` (`ID_group`),
46 KEY `ID_node` (`ID_node`),
47 CONSTRAINT `group_agregator_ibfk_1` FOREIGN KEY (`ID_group`) REFERENCES `groups` (`id`),
48 CONSTRAINT `group_agregator_ibfk_2` FOREIGN KEY (`ID_node`) REFERENCES `node_list` (`id`)
49) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
50/*!40101 SET character_set_client = @saved_cs_client */;
51
52--
53-- Dumping data for table `group_agregator`
54--
55
56LOCK TABLES `group_agregator` WRITE;
57/*!40000 ALTER TABLE `group_agregator` DISABLE KEYS */;
58INSERT INTO `group_agregator` VALUES (1,1,1),(2,4,10);
59/*!40000 ALTER TABLE `group_agregator` ENABLE KEYS */;
60UNLOCK TABLES;
61
62--
63-- Table structure for table `groups`
64--
65
66DROP TABLE IF EXISTS `groups`;
67/*!40101 SET @saved_cs_client = @@character_set_client */;
68 SET character_set_client = utf8mb4 ;
69CREATE TABLE `groups` (
70 `ID` int(11) NOT NULL AUTO_INCREMENT,
71 `type` int(11) NOT NULL,
72 `logical_operator` int(11) NOT NULL,
73 `value` varchar(128) DEFAULT NULL,
74 PRIMARY KEY (`ID`),
75 KEY `type` (`type`),
76 KEY `logical_operator` (`logical_operator`),
77 CONSTRAINT `groups_ibfk_1` FOREIGN KEY (`type`) REFERENCES `groups_type` (`id`),
78 CONSTRAINT `groups_ibfk_2` FOREIGN KEY (`logical_operator`) REFERENCES `logical_operators` (`id`)
79) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
80/*!40101 SET character_set_client = @saved_cs_client */;
81
82--
83-- Dumping data for table `groups`
84--
85
86LOCK TABLES `groups` WRITE;
87/*!40000 ALTER TABLE `groups` DISABLE KEYS */;
88INSERT INTO `groups` VALUES (1,10,1,'DT-328'),(2,9,1,'2.0'),(3,8,6,'4.5'),(4,1,5,'16'),(5,1,2,'32');
89/*!40000 ALTER TABLE `groups` ENABLE KEYS */;
90UNLOCK TABLES;
91
92--
93-- Table structure for table `groups_type`
94--
95
96DROP TABLE IF EXISTS `groups_type`;
97/*!40101 SET @saved_cs_client = @@character_set_client */;
98 SET character_set_client = utf8mb4 ;
99CREATE TABLE `groups_type` (
100 `ID` int(11) NOT NULL AUTO_INCREMENT,
101 `group_type` varchar(128) DEFAULT NULL,
102 PRIMARY KEY (`ID`)
103) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
104/*!40101 SET character_set_client = @saved_cs_client */;
105
106--
107-- Dumping data for table `groups_type`
108--
109
110LOCK TABLES `groups_type` WRITE;
111/*!40000 ALTER TABLE `groups_type` DISABLE KEYS */;
112INSERT INTO `groups_type` VALUES (1,'total_ram'),(2,'quantity_of_processor'),(3,'free_disc_space'),(4,'available_ram'),(5,'processor_freuency'),(6,'core_quantity_per_processor'),(7,'processor_cache'),(8,'version_of_.NET_framework'),(9,'version_of_.NET_core'),(10,'node');
113/*!40000 ALTER TABLE `groups_type` ENABLE KEYS */;
114UNLOCK TABLES;
115
116--
117-- Temporary view structure for view `log_list_view`
118--
119
120DROP TABLE IF EXISTS `log_list_view`;
121/*!50001 DROP VIEW IF EXISTS `log_list_view`*/;
122SET @saved_cs_client = @@character_set_client;
123SET character_set_client = utf8mb4;
124/*!50001 CREATE VIEW `log_list_view` AS SELECT
125 1 AS `ID`,
126 1 AS `Log type`,
127 1 AS `Machine name`,
128 1 AS `Log value`,
129 1 AS `Date and time`,
130 1 AS `Task ID`*/;
131SET character_set_client = @saved_cs_client;
132
133--
134-- Table structure for table `log_types`
135--
136
137DROP TABLE IF EXISTS `log_types`;
138/*!40101 SET @saved_cs_client = @@character_set_client */;
139 SET character_set_client = utf8mb4 ;
140CREATE TABLE `log_types` (
141 `ID` int(11) NOT NULL AUTO_INCREMENT,
142 `log_type` varchar(255) NOT NULL,
143 PRIMARY KEY (`ID`)
144) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
145/*!40101 SET character_set_client = @saved_cs_client */;
146
147--
148-- Dumping data for table `log_types`
149--
150
151LOCK TABLES `log_types` WRITE;
152/*!40000 ALTER TABLE `log_types` DISABLE KEYS */;
153INSERT INTO `log_types` VALUES (1,'ERROR'),(2,'Warning'),(3,'Information'),(4,'CRITICAL_ERROR'),(5,'Status');
154/*!40000 ALTER TABLE `log_types` ENABLE KEYS */;
155UNLOCK TABLES;
156
157--
158-- Table structure for table `logical_operators`
159--
160
161DROP TABLE IF EXISTS `logical_operators`;
162/*!40101 SET @saved_cs_client = @@character_set_client */;
163 SET character_set_client = utf8mb4 ;
164CREATE TABLE `logical_operators` (
165 `ID` int(11) NOT NULL AUTO_INCREMENT,
166 `operator` varchar(16) DEFAULT NULL,
167 PRIMARY KEY (`ID`)
168) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
169/*!40101 SET character_set_client = @saved_cs_client */;
170
171--
172-- Dumping data for table `logical_operators`
173--
174
175LOCK TABLES `logical_operators` WRITE;
176/*!40000 ALTER TABLE `logical_operators` DISABLE KEYS */;
177INSERT INTO `logical_operators` VALUES (1,'='),(2,'>='),(3,'<='),(4,'!='),(5,'<'),(6,'>');
178/*!40000 ALTER TABLE `logical_operators` ENABLE KEYS */;
179UNLOCK TABLES;
180
181--
182-- Table structure for table `logs_list`
183--
184
185DROP TABLE IF EXISTS `logs_list`;
186/*!40101 SET @saved_cs_client = @@character_set_client */;
187 SET character_set_client = utf8mb4 ;
188CREATE TABLE `logs_list` (
189 `ID` int(11) NOT NULL AUTO_INCREMENT,
190 `node_unique_name` int(11) NOT NULL,
191 `Log_value` varchar(1024) NOT NULL,
192 `log_type` int(11) NOT NULL,
193 `task` int(11) DEFAULT NULL,
194 `data_and_time` datetime NOT NULL,
195 PRIMARY KEY (`ID`),
196 KEY `log_type` (`log_type`),
197 KEY `node_unique_name` (`node_unique_name`),
198 KEY `task` (`task`),
199 CONSTRAINT `logs_list_ibfk_1` FOREIGN KEY (`log_type`) REFERENCES `log_types` (`id`),
200 CONSTRAINT `logs_list_ibfk_2` FOREIGN KEY (`node_unique_name`) REFERENCES `node_list_archive` (`id`),
201 CONSTRAINT `logs_list_ibfk_3` FOREIGN KEY (`task`) REFERENCES `tasks_archive` (`id`)
202) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
203/*!40101 SET character_set_client = @saved_cs_client */;
204
205--
206-- Dumping data for table `logs_list`
207--
208
209LOCK TABLES `logs_list` WRITE;
210/*!40000 ALTER TABLE `logs_list` DISABLE KEYS */;
211INSERT INTO `logs_list` VALUES (1,13,'Image X loaded.',3,NULL,'2018-12-30 01:49:26'),(2,2,'Selected X classes for classification',3,NULL,'2018-12-30 01:49:26'),(3,3,'Error while reading file X',1,NULL,'2018-12-30 01:49:26'),(4,3,'Training done in X seconds. ',3,NULL,'2018-12-30 01:49:26'),(5,4,'Not enough points (X) for class Y. Class omitted.',2,NULL,'2018-12-30 01:49:26'),(6,13,'Skończyły się ciastka',4,NULL,'2018-12-30 01:49:26'),(7,13,'Porcja kawy w automacie jest za mała',4,NULL,'2018-12-30 01:49:26'),(8,10,'Unspecified error. Line X, file Y.',1,NULL,'2018-12-30 01:49:26'),(9,5,'Incorrect configuration file.',1,NULL,'2018-12-30 01:49:26'),(10,11,'Current tasks: [X, Y]',5,NULL,'2018-12-30 01:49:26'),(11,2,'New task created.',3,1,'2018-12-30 01:49:28'),(12,2,'Change status to processing.',3,1,'2018-12-30 01:49:28'),(13,2,'Change status to stopped.',3,1,'2018-12-30 01:49:28'),(14,2,'Change status to processing.',3,1,'2018-12-30 01:49:28'),(15,2,'Compleate task.',3,1,'2018-12-30 01:49:28'),(16,13,'New task was created.',3,6,'2018-12-30 01:49:29'),(17,13,'New task was created.',3,7,'2018-12-30 01:49:29'),(18,13,'Task changed status to notStarted.',3,1,'2018-12-30 01:49:29'),(19,14,'New node was added.',3,NULL,'2018-12-30 01:49:30');
212/*!40000 ALTER TABLE `logs_list` ENABLE KEYS */;
213UNLOCK TABLES;
214
215--
216-- Table structure for table `node_atribute_list`
217--
218
219DROP TABLE IF EXISTS `node_atribute_list`;
220/*!40101 SET @saved_cs_client = @@character_set_client */;
221 SET character_set_client = utf8mb4 ;
222CREATE TABLE `node_atribute_list` (
223 `ID` int(11) NOT NULL AUTO_INCREMENT,
224 `node_unique_name` int(11) NOT NULL,
225 `node_artribute_type` int(11) NOT NULL,
226 `node_artribute_value` varchar(1024) DEFAULT NULL,
227 `data_and_time` datetime NOT NULL,
228 PRIMARY KEY (`ID`),
229 KEY `node_artribute_type` (`node_artribute_type`),
230 KEY `node_unique_name` (`node_unique_name`),
231 CONSTRAINT `node_atribute_list_ibfk_1` FOREIGN KEY (`node_artribute_type`) REFERENCES `nodes_atributes_types` (`id`),
232 CONSTRAINT `node_atribute_list_ibfk_2` FOREIGN KEY (`node_unique_name`) REFERENCES `node_list` (`id`)
233) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
234/*!40101 SET character_set_client = @saved_cs_client */;
235
236--
237-- Dumping data for table `node_atribute_list`
238--
239
240LOCK TABLES `node_atribute_list` WRITE;
241/*!40000 ALTER TABLE `node_atribute_list` DISABLE KEYS */;
242INSERT INTO `node_atribute_list` VALUES (1,13,4,'8','2018-12-30 01:49:25');
243/*!40000 ALTER TABLE `node_atribute_list` ENABLE KEYS */;
244UNLOCK TABLES;
245
246--
247-- Temporary view structure for view `node_atributes`
248--
249
250DROP TABLE IF EXISTS `node_atributes`;
251/*!50001 DROP VIEW IF EXISTS `node_atributes`*/;
252SET @saved_cs_client = @@character_set_client;
253SET character_set_client = utf8mb4;
254/*!50001 CREATE VIEW `node_atributes` AS SELECT
255 1 AS `ID`,
256 1 AS `Node name`,
257 1 AS `Atribute type`,
258 1 AS `Value`,
259 1 AS `Date and time`*/;
260SET character_set_client = @saved_cs_client;
261
262--
263-- Table structure for table `node_list`
264--
265
266DROP TABLE IF EXISTS `node_list`;
267/*!40101 SET @saved_cs_client = @@character_set_client */;
268 SET character_set_client = utf8mb4 ;
269CREATE TABLE `node_list` (
270 `ID` int(11) NOT NULL AUTO_INCREMENT,
271 `node_unique_name` varchar(255) NOT NULL,
272 PRIMARY KEY (`ID`),
273 UNIQUE KEY `node_unique_name` (`node_unique_name`)
274) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
275/*!40101 SET character_set_client = @saved_cs_client */;
276
277--
278-- Dumping data for table `node_list`
279--
280
281LOCK TABLES `node_list` WRITE;
282/*!40000 ALTER TABLE `node_list` DISABLE KEYS */;
283INSERT INTO `node_list` VALUES (6,'compute-node'),(13,'DT-328'),(14,'DT-355'),(1,'node-0'),(2,'node-1'),(3,'node-2'),(4,'node-3'),(5,'node-4'),(12,'PC-100'),(7,'PC-390'),(9,'PC-420'),(10,'PC-440'),(8,'PC-720'),(11,'PC-800');
284/*!40000 ALTER TABLE `node_list` ENABLE KEYS */;
285UNLOCK TABLES;
286
287--
288-- Table structure for table `node_list_archive`
289--
290
291DROP TABLE IF EXISTS `node_list_archive`;
292/*!40101 SET @saved_cs_client = @@character_set_client */;
293 SET character_set_client = utf8mb4 ;
294CREATE TABLE `node_list_archive` (
295 `ID` int(11) NOT NULL AUTO_INCREMENT,
296 `node_unique_name` varchar(255) NOT NULL,
297 PRIMARY KEY (`ID`),
298 UNIQUE KEY `node_unique_name` (`node_unique_name`)
299) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
300/*!40101 SET character_set_client = @saved_cs_client */;
301
302--
303-- Dumping data for table `node_list_archive`
304--
305
306LOCK TABLES `node_list_archive` WRITE;
307/*!40000 ALTER TABLE `node_list_archive` DISABLE KEYS */;
308INSERT INTO `node_list_archive` VALUES (6,'compute-node'),(13,'DT-328'),(14,'DT-355'),(1,'node-0'),(2,'node-1'),(3,'node-2'),(4,'node-3'),(5,'node-4'),(12,'PC-100'),(7,'PC-390'),(9,'PC-420'),(10,'PC-440'),(8,'PC-720'),(11,'PC-800');
309/*!40000 ALTER TABLE `node_list_archive` ENABLE KEYS */;
310UNLOCK TABLES;
311
312--
313-- Table structure for table `nodes_atributes_types`
314--
315
316DROP TABLE IF EXISTS `nodes_atributes_types`;
317/*!40101 SET @saved_cs_client = @@character_set_client */;
318 SET character_set_client = utf8mb4 ;
319CREATE TABLE `nodes_atributes_types` (
320 `ID` int(11) NOT NULL AUTO_INCREMENT,
321 `type_value` varchar(512) NOT NULL,
322 PRIMARY KEY (`ID`)
323) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
324/*!40101 SET character_set_client = @saved_cs_client */;
325
326--
327-- Dumping data for table `nodes_atributes_types`
328--
329
330LOCK TABLES `nodes_atributes_types` WRITE;
331/*!40000 ALTER TABLE `nodes_atributes_types` DISABLE KEYS */;
332INSERT INTO `nodes_atributes_types` VALUES (1,'IPv4'),(2,'IPv6'),(3,'mac_address'),(4,'processor_count'),(5,'running_time'),(6,'vesion'),(7,'architecture_(32_or_64-bit)'),(8,'memory_page'),(9,'.NET_Framework_version'),(10,'machine_data'),(11,'user_name'),(12,'logical_drivers'),(13,'operating_system_version'),(14,'total_phisical_memory'),(15,'available_phisical_memory'),(16,'virtual_memory_available'),(17,'virtual_memory_max_size'),(18,'virtual_memory_in_use'),(19,'virtual_memory_shared'),(20,'virtual_memory_buffered_or_cache');
333/*!40000 ALTER TABLE `nodes_atributes_types` ENABLE KEYS */;
334UNLOCK TABLES;
335
336--
337-- Table structure for table `permission`
338--
339
340DROP TABLE IF EXISTS `permission`;
341/*!40101 SET @saved_cs_client = @@character_set_client */;
342 SET character_set_client = utf8mb4 ;
343CREATE TABLE `permission` (
344 `ID` int(16) NOT NULL AUTO_INCREMENT,
345 `task` int(16) NOT NULL,
346 `group` int(16) NOT NULL,
347 PRIMARY KEY (`ID`),
348 KEY `group` (`group`),
349 KEY `task` (`task`),
350 CONSTRAINT `permission_ibfk_1` FOREIGN KEY (`group`) REFERENCES `groups` (`id`),
351 CONSTRAINT `permission_ibfk_2` FOREIGN KEY (`task`) REFERENCES `tasks` (`id`)
352) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
353/*!40101 SET character_set_client = @saved_cs_client */;
354
355--
356-- Dumping data for table `permission`
357--
358
359LOCK TABLES `permission` WRITE;
360/*!40000 ALTER TABLE `permission` DISABLE KEYS */;
361INSERT INTO `permission` VALUES (1,1,1),(2,1,5),(3,4,3),(4,3,2),(5,4,5);
362/*!40000 ALTER TABLE `permission` ENABLE KEYS */;
363UNLOCK TABLES;
364
365--
366-- Temporary view structure for view `permission_list`
367--
368
369DROP TABLE IF EXISTS `permission_list`;
370/*!50001 DROP VIEW IF EXISTS `permission_list`*/;
371SET @saved_cs_client = @@character_set_client;
372SET character_set_client = utf8mb4;
373/*!50001 CREATE VIEW `permission_list` AS SELECT
374 1 AS `ID`,
375 1 AS `Permission type`,
376 1 AS `Logical operator`,
377 1 AS `permission value`*/;
378SET character_set_client = @saved_cs_client;
379
380--
381-- Temporary view structure for view `permission_on_task`
382--
383
384DROP TABLE IF EXISTS `permission_on_task`;
385/*!50001 DROP VIEW IF EXISTS `permission_on_task`*/;
386SET @saved_cs_client = @@character_set_client;
387SET character_set_client = utf8mb4;
388/*!50001 CREATE VIEW `permission_on_task` AS SELECT
389 1 AS `ID`,
390 1 AS `Task ID`,
391 1 AS `Command`,
392 1 AS `Arguments`,
393 1 AS `Status`,
394 1 AS `Permission type`,
395 1 AS `Logical operator`,
396 1 AS `permission value`*/;
397SET character_set_client = @saved_cs_client;
398
399--
400-- Table structure for table `task_status`
401--
402
403DROP TABLE IF EXISTS `task_status`;
404/*!40101 SET @saved_cs_client = @@character_set_client */;
405 SET character_set_client = utf8mb4 ;
406CREATE TABLE `task_status` (
407 `ID` int(11) NOT NULL AUTO_INCREMENT,
408 `status` varchar(128) NOT NULL,
409 PRIMARY KEY (`ID`)
410) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
411/*!40101 SET character_set_client = @saved_cs_client */;
412
413--
414-- Dumping data for table `task_status`
415--
416
417LOCK TABLES `task_status` WRITE;
418/*!40000 ALTER TABLE `task_status` DISABLE KEYS */;
419INSERT INTO `task_status` VALUES (1,'undefined'),(2,'notStarted'),(3,'waiting'),(4,'running'),(5,'stopped'),(6,'finishedGood'),(7,'finishedBad');
420/*!40000 ALTER TABLE `task_status` ENABLE KEYS */;
421UNLOCK TABLES;
422
423--
424-- Table structure for table `tasks`
425--
426
427DROP TABLE IF EXISTS `tasks`;
428/*!40101 SET @saved_cs_client = @@character_set_client */;
429 SET character_set_client = utf8mb4 ;
430CREATE TABLE `tasks` (
431 `ID` int(11) NOT NULL AUTO_INCREMENT,
432 `status` int(11) NOT NULL,
433 `command` varchar(512) NOT NULL,
434 `argument` varchar(512) DEFAULT NULL,
435 PRIMARY KEY (`ID`),
436 KEY `status` (`status`),
437 CONSTRAINT `tasks_ibfk_1` FOREIGN KEY (`status`) REFERENCES `task_status` (`id`)
438) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
439/*!40101 SET character_set_client = @saved_cs_client */;
440
441--
442-- Dumping data for table `tasks`
443--
444
445LOCK TABLES `tasks` WRITE;
446/*!40000 ALTER TABLE `tasks` DISABLE KEYS */;
447INSERT INTO `tasks` VALUES (1,2,'mathlab','input file C: est_data.txt'),(2,1,'echo hello world','-n -l'),(3,1,'echo test','-c -d'),(4,1,'jedz ciastka','-dobre -smaczne'),(5,1,'mysl','-logicznie'),(6,3,'notepad.exe','Insert \"hello world\" to new file.'),(7,1,'paint.exe','Draw image with smile.');
448/*!40000 ALTER TABLE `tasks` ENABLE KEYS */;
449UNLOCK TABLES;
450
451--
452-- Table structure for table `tasks_archive`
453--
454
455DROP TABLE IF EXISTS `tasks_archive`;
456/*!40101 SET @saved_cs_client = @@character_set_client */;
457 SET character_set_client = utf8mb4 ;
458CREATE TABLE `tasks_archive` (
459 `ID` int(11) NOT NULL AUTO_INCREMENT,
460 `status` int(11) NOT NULL,
461 `command` varchar(512) NOT NULL,
462 `argument` varchar(512) DEFAULT NULL,
463 PRIMARY KEY (`ID`),
464 KEY `status` (`status`),
465 CONSTRAINT `tasks_archive_ibfk_1` FOREIGN KEY (`status`) REFERENCES `task_status` (`id`)
466) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
467/*!40101 SET character_set_client = @saved_cs_client */;
468
469--
470-- Dumping data for table `tasks_archive`
471--
472
473LOCK TABLES `tasks_archive` WRITE;
474/*!40000 ALTER TABLE `tasks_archive` DISABLE KEYS */;
475INSERT INTO `tasks_archive` VALUES (1,1,'mathlab','input file C: est_data.txt'),(2,1,'echo hello world','-n -l'),(3,1,'echo test','-c -d'),(4,1,'jedz ciastka','-dobre -smaczne'),(5,1,'mysl','-logicznie'),(6,1,'notepad.exe','Insert \"hello world\" to new file.'),(7,1,'paint.exe','Draw image with smile.');
476/*!40000 ALTER TABLE `tasks_archive` ENABLE KEYS */;
477UNLOCK TABLES;
478
479--
480-- Dumping routines for database 'sentinel_2_log'
481--
482/*!50003 DROP PROCEDURE IF EXISTS `change_task_status` */;
483/*!50003 SET @saved_cs_client = @@character_set_client */ ;
484/*!50003 SET @saved_cs_results = @@character_set_results */ ;
485/*!50003 SET @saved_col_connection = @@collation_connection */ ;
486/*!50003 SET character_set_client = utf8mb4 */ ;
487/*!50003 SET character_set_results = utf8mb4 */ ;
488/*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ;
489/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
490/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;
491DELIMITER ;;
492CREATE DEFINER=`cbk`@`%` PROCEDURE `change_task_status`( IN task_id int(16),
493 IN input_status varchar(512))
494BEGIN
495 DECLARE STATUS_ID INT(16);
496 SET STATUS_ID = (
497 select `ID`
498 from `task_status`
499 where `status`=input_status
500 );
501
502 update `tasks`
503 SET `status` = STATUS_ID
504 where `ID`=task_id;
505END ;;
506DELIMITER ;
507/*!50003 SET sql_mode = @saved_sql_mode */ ;
508/*!50003 SET character_set_client = @saved_cs_client */ ;
509/*!50003 SET character_set_results = @saved_cs_results */ ;
510/*!50003 SET collation_connection = @saved_col_connection */ ;
511/*!50003 DROP PROCEDURE IF EXISTS `change_task_status_with_log` */;
512/*!50003 SET @saved_cs_client = @@character_set_client */ ;
513/*!50003 SET @saved_cs_results = @@character_set_results */ ;
514/*!50003 SET @saved_col_connection = @@collation_connection */ ;
515/*!50003 SET character_set_client = utf8mb4 */ ;
516/*!50003 SET character_set_results = utf8mb4 */ ;
517/*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ;
518/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
519/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;
520DELIMITER ;;
521CREATE DEFINER=`cbk`@`%` PROCEDURE `change_task_status_with_log`( IN task_id int(16),
522 IN input_status varchar(512),
523 IN author varchar(128))
524BEGIN
525 DECLARE STATUS_ID INT(16);
526 DECLARE LOG_VALUE varchar(1024);
527 SET STATUS_ID = (
528 select `ID`
529 from `task_status`
530 where `status`=input_status
531 );
532 update `tasks`
533 SET `status` = STATUS_ID
534 where `ID`=task_id;
535
536 SET LOG_VALUE = CONCAT("Task changed status to ",input_status,".");
537 call insert_log_with_task('Information',author,LOG_VALUE,task_id);
538END ;;
539DELIMITER ;
540/*!50003 SET sql_mode = @saved_sql_mode */ ;
541/*!50003 SET character_set_client = @saved_cs_client */ ;
542/*!50003 SET character_set_results = @saved_cs_results */ ;
543/*!50003 SET collation_connection = @saved_col_connection */ ;
544/*!50003 DROP PROCEDURE IF EXISTS `delete_task` */;
545/*!50003 SET @saved_cs_client = @@character_set_client */ ;
546/*!50003 SET @saved_cs_results = @@character_set_results */ ;
547/*!50003 SET @saved_col_connection = @@collation_connection */ ;
548/*!50003 SET character_set_client = utf8mb4 */ ;
549/*!50003 SET character_set_results = utf8mb4 */ ;
550/*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ;
551/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
552/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;
553DELIMITER ;;
554CREATE DEFINER=`cbk`@`%` PROCEDURE `delete_task`(IN task_id int(16))
555BEGIN
556 begin
557
558 DECLARE `ID_TO_DELETE` INT(16);
559 DECLARE `GROUP_TO_DELETE` INT(16);
560 #DECLARE LOG_VALUE varchar(1024);
561 while exists(SELECT * FROM `permission` where `task`= task_id limit 1)
562 DO
563 SET @ID_TO_DELETE = (
564 SELECT `ID`
565 FROM `permission`
566 where `task`= task_id
567 limit 1
568 );
569 #SELECT @ID_TO_DELETE;
570 #SELECT sleep(5);
571 SET @GROUP_TO_DELETE = (
572 SELECT `group`
573 FROM `permission`
574 where `ID`= @ID_TO_DELETE
575 );
576 #SELECT @GROUP_TO_DELETE;
577 #SELECT sleep(5);
578 DELETE FROM `permission`
579 where `ID`= @ID_TO_DELETE;
580 #SET LOG_VALUE = CONCAT("Permission ID: ",`GROUP`," was deleted.");
581 #call insert_log_with_task('Information',author,LOG_VALUE,task_id);
582 end while;
583 end;
584 begin
585 DELETE FROM `tasks`
586 where `ID`= task_id;
587 end;
588END ;;
589DELIMITER ;
590/*!50003 SET sql_mode = @saved_sql_mode */ ;
591/*!50003 SET character_set_client = @saved_cs_client */ ;
592/*!50003 SET character_set_results = @saved_cs_results */ ;
593/*!50003 SET collation_connection = @saved_col_connection */ ;
594/*!50003 DROP PROCEDURE IF EXISTS `delete_task_with_log` */;
595/*!50003 SET @saved_cs_client = @@character_set_client */ ;
596/*!50003 SET @saved_cs_results = @@character_set_results */ ;
597/*!50003 SET @saved_col_connection = @@collation_connection */ ;
598/*!50003 SET character_set_client = utf8mb4 */ ;
599/*!50003 SET character_set_results = utf8mb4 */ ;
600/*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ;
601/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
602/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;
603DELIMITER ;;
604CREATE DEFINER=`cbk`@`%` PROCEDURE `delete_task_with_log`( IN task_id int(16),
605 IN author varchar(128))
606BEGIN
607 begin
608
609 DECLARE `ID_TO_DELETE` INT(16);
610 DECLARE `GROUP_TO_DELETE` INT(16);
611 DECLARE LOG_VALUE varchar(1024);
612 while exists(SELECT * FROM `permission` where `task`= task_id limit 1)
613 DO
614 SET @ID_TO_DELETE = (
615 SELECT `ID`
616 FROM `permission`
617 where `task`= task_id
618 limit 1
619 );
620 #SELECT @ID_TO_DELETE;
621 #SELECT sleep(5);
622 SET @GROUP_TO_DELETE = (
623 SELECT `group`
624 FROM `permission`
625 where `ID`= @ID_TO_DELETE
626 );
627 #SELECT @GROUP_TO_DELETE;
628 #SELECT sleep(5);
629 DELETE FROM `permission`
630 where `ID`= @ID_TO_DELETE;
631 SET LOG_VALUE = CONCAT("Permission ID: ",@GROUP_TO_DELETE," was deleted.");
632 call insert_log_with_task('Information',author,LOG_VALUE,task_id);
633 end while;
634 end;
635 begin
636 DELETE FROM `tasks`
637 where `ID`= task_id;
638 call insert_log_with_task('Information',author,'Task was deleted.',task_id);
639 end;
640END ;;
641DELIMITER ;
642/*!50003 SET sql_mode = @saved_sql_mode */ ;
643/*!50003 SET character_set_client = @saved_cs_client */ ;
644/*!50003 SET character_set_results = @saved_cs_results */ ;
645/*!50003 SET collation_connection = @saved_col_connection */ ;
646/*!50003 DROP PROCEDURE IF EXISTS `get_tasks_not_taken` */;
647/*!50003 SET @saved_cs_client = @@character_set_client */ ;
648/*!50003 SET @saved_cs_results = @@character_set_results */ ;
649/*!50003 SET @saved_col_connection = @@collation_connection */ ;
650/*!50003 SET character_set_client = utf8mb4 */ ;
651/*!50003 SET character_set_results = utf8mb4 */ ;
652/*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ;
653/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
654/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;
655DELIMITER ;;
656CREATE DEFINER=`cbk`@`%` PROCEDURE `get_tasks_not_taken`(IN QUANTITY_INPUT int)
657begin
658 select `tasks`.`ID`
659 from `tasks` join `task_status` on `tasks`.`status`=`task_status`.`ID`
660 where task_status.status='undefined'
661 order by ID asc
662 limit QUANTITY_INPUT;
663end ;;
664DELIMITER ;
665/*!50003 SET sql_mode = @saved_sql_mode */ ;
666/*!50003 SET character_set_client = @saved_cs_client */ ;
667/*!50003 SET character_set_results = @saved_cs_results */ ;
668/*!50003 SET collation_connection = @saved_col_connection */ ;
669/*!50003 DROP PROCEDURE IF EXISTS `get_task_to_node` */;
670/*!50003 SET @saved_cs_client = @@character_set_client */ ;
671/*!50003 SET @saved_cs_results = @@character_set_results */ ;
672/*!50003 SET @saved_col_connection = @@collation_connection */ ;
673/*!50003 SET character_set_client = utf8mb4 */ ;
674/*!50003 SET character_set_results = utf8mb4 */ ;
675/*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ;
676/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
677/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;
678DELIMITER ;;
679CREATE DEFINER=`cbk`@`%` PROCEDURE `get_task_to_node`( node_name varchar(128) )
680BEGIN
681 SELECT `ID`, `Task ID`, `Command`, `Arguments`, `Status`
682 FROM sentinel_2_log.permission_on_task
683 where `permission value`= node_name and `Logical operator`='=';
684END ;;
685DELIMITER ;
686/*!50003 SET sql_mode = @saved_sql_mode */ ;
687/*!50003 SET character_set_client = @saved_cs_client */ ;
688/*!50003 SET character_set_results = @saved_cs_results */ ;
689/*!50003 SET collation_connection = @saved_col_connection */ ;
690/*!50003 DROP PROCEDURE IF EXISTS `insert_log` */;
691/*!50003 SET @saved_cs_client = @@character_set_client */ ;
692/*!50003 SET @saved_cs_results = @@character_set_results */ ;
693/*!50003 SET @saved_col_connection = @@collation_connection */ ;
694/*!50003 SET character_set_client = utf8mb4 */ ;
695/*!50003 SET character_set_results = utf8mb4 */ ;
696/*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ;
697/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
698/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;
699DELIMITER ;;
700CREATE DEFINER=`cbk`@`%` PROCEDURE `insert_log`(IN inserted_log_type varchar(128),
701 IN inserted_machine_name varchar(255),
702 IN inserted_log_value varchar(512) )
703BEGIN
704 DECLARE LOG_TYPE_ID INT(16);
705 DECLARE MACHINE_ID INT(16);
706 SET LOG_TYPE_ID = (
707 select id
708 from sentinel_2_log.log_types
709 where log_type=inserted_log_type
710 );
711 SET MACHINE_ID = (
712 select ID
713 from sentinel_2_log.node_list
714 where node_unique_name=inserted_machine_name
715 );
716 insert into `logs_list` (
717 node_unique_name,
718 Log_value,
719 log_type,
720 data_and_time
721 )
722 values(MACHINE_ID, inserted_log_value, LOG_TYPE_ID, NOW());
723
724END ;;
725DELIMITER ;
726/*!50003 SET sql_mode = @saved_sql_mode */ ;
727/*!50003 SET character_set_client = @saved_cs_client */ ;
728/*!50003 SET character_set_results = @saved_cs_results */ ;
729/*!50003 SET collation_connection = @saved_col_connection */ ;
730/*!50003 DROP PROCEDURE IF EXISTS `insert_log_with_task` */;
731/*!50003 SET @saved_cs_client = @@character_set_client */ ;
732/*!50003 SET @saved_cs_results = @@character_set_results */ ;
733/*!50003 SET @saved_col_connection = @@collation_connection */ ;
734/*!50003 SET character_set_client = utf8mb4 */ ;
735/*!50003 SET character_set_results = utf8mb4 */ ;
736/*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ;
737/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
738/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;
739DELIMITER ;;
740CREATE DEFINER=`cbk`@`%` PROCEDURE `insert_log_with_task`(IN inserted_log_type varchar(128),
741 IN inserted_machine_name varchar(255),
742 IN inserted_log_value varchar(1024),
743 IN inserted_task INT)
744BEGIN
745 DECLARE LOG_TYPE_ID INT(16);
746 DECLARE MACHINE_ID INT(16);
747 SET LOG_TYPE_ID = (
748 select id
749 from sentinel_2_log.log_types
750 where log_type=inserted_log_type
751 );
752 SET MACHINE_ID = (
753 select ID
754 from sentinel_2_log.node_list
755 where node_unique_name=inserted_machine_name
756 );
757 insert into `logs_list` (
758 node_unique_name,
759 Log_value,
760 log_type,
761 task,
762 data_and_time
763 )
764 values(MACHINE_ID, inserted_log_value, LOG_TYPE_ID, inserted_task, NOW());
765
766END ;;
767DELIMITER ;
768/*!50003 SET sql_mode = @saved_sql_mode */ ;
769/*!50003 SET character_set_client = @saved_cs_client */ ;
770/*!50003 SET character_set_results = @saved_cs_results */ ;
771/*!50003 SET collation_connection = @saved_col_connection */ ;
772/*!50003 DROP PROCEDURE IF EXISTS `insert_node` */;
773/*!50003 SET @saved_cs_client = @@character_set_client */ ;
774/*!50003 SET @saved_cs_results = @@character_set_results */ ;
775/*!50003 SET @saved_col_connection = @@collation_connection */ ;
776/*!50003 SET character_set_client = utf8mb4 */ ;
777/*!50003 SET character_set_results = utf8mb4 */ ;
778/*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ;
779/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
780/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;
781DELIMITER ;;
782CREATE DEFINER=`cbk`@`%` PROCEDURE `insert_node`(IN node_name varchar(255))
783BEGIN
784 IF NOT EXISTS (
785 SELECT *
786 FROM node_list
787 WHERE node_unique_name = node_name
788 )
789 THEN
790 INSERT INTO node_list(node_unique_name)
791 VALUES(node_name);
792 INSERT INTO node_list_archive(node_unique_name)
793 VALUES(node_name);
794 END IF;
795END ;;
796DELIMITER ;
797/*!50003 SET sql_mode = @saved_sql_mode */ ;
798/*!50003 SET character_set_client = @saved_cs_client */ ;
799/*!50003 SET character_set_results = @saved_cs_results */ ;
800/*!50003 SET collation_connection = @saved_col_connection */ ;
801/*!50003 DROP PROCEDURE IF EXISTS `insert_node_atribute` */;
802/*!50003 SET @saved_cs_client = @@character_set_client */ ;
803/*!50003 SET @saved_cs_results = @@character_set_results */ ;
804/*!50003 SET @saved_col_connection = @@collation_connection */ ;
805/*!50003 SET character_set_client = utf8mb4 */ ;
806/*!50003 SET character_set_results = utf8mb4 */ ;
807/*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ;
808/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
809/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;
810DELIMITER ;;
811CREATE DEFINER=`cbk`@`%` PROCEDURE `insert_node_atribute`( IN atribute_type varchar(128),
812 IN machine_name varchar(255),
813 IN log_value varchar(1024))
814BEGIN
815 DECLARE ATRIBUTE_TYPE_ID INT(16);
816 DECLARE MACHINE_ID INT(16);
817 SET ATRIBUTE_TYPE_ID = (
818 select id
819 from sentinel_2_log.nodes_atributes_types
820 where type_value=atribute_type
821 );
822 SET MACHINE_ID = (
823 select ID
824 from sentinel_2_log.node_list
825 where node_unique_name=machine_name
826 );
827 IF NOT EXISTS (
828 select *
829 from sentinel_2_log.node_atribute_list
830 where
831 node_unique_name=MACHINE_ID and
832 node_artribute_type=ATRIBUTE_TYPE_ID and
833 node_artribute_value=log_value
834 order by data_and_time desc
835 limit 1
836 )
837
838 then
839 insert into `node_atribute_list`(node_unique_name,
840 node_artribute_type,
841 node_artribute_value,
842 data_and_time)
843 values(MACHINE_ID, ATRIBUTE_TYPE_ID, log_value, NOW());
844 end if;
845
846END ;;
847DELIMITER ;
848/*!50003 SET sql_mode = @saved_sql_mode */ ;
849/*!50003 SET character_set_client = @saved_cs_client */ ;
850/*!50003 SET character_set_results = @saved_cs_results */ ;
851/*!50003 SET collation_connection = @saved_col_connection */ ;
852/*!50003 DROP PROCEDURE IF EXISTS `insert_node_with_log` */;
853/*!50003 SET @saved_cs_client = @@character_set_client */ ;
854/*!50003 SET @saved_cs_results = @@character_set_results */ ;
855/*!50003 SET @saved_col_connection = @@collation_connection */ ;
856/*!50003 SET character_set_client = utf8mb4 */ ;
857/*!50003 SET character_set_results = utf8mb4 */ ;
858/*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ;
859/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
860/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;
861DELIMITER ;;
862CREATE DEFINER=`cbk`@`%` PROCEDURE `insert_node_with_log`(IN node_name varchar(255))
863BEGIN
864 IF NOT EXISTS (
865 SELECT *
866 FROM node_list
867 WHERE node_unique_name = node_name
868 )
869 THEN
870 INSERT INTO node_list(node_unique_name)
871 VALUES(node_name);
872 INSERT INTO node_list_archive(node_unique_name)
873 VALUES(node_name);
874 call insert_log('Information',node_name,'New node was added.');
875 END IF;
876END ;;
877DELIMITER ;
878/*!50003 SET sql_mode = @saved_sql_mode */ ;
879/*!50003 SET character_set_client = @saved_cs_client */ ;
880/*!50003 SET character_set_results = @saved_cs_results */ ;
881/*!50003 SET collation_connection = @saved_col_connection */ ;
882/*!50003 DROP PROCEDURE IF EXISTS `is_task_taken` */;
883/*!50003 SET @saved_cs_client = @@character_set_client */ ;
884/*!50003 SET @saved_cs_results = @@character_set_results */ ;
885/*!50003 SET @saved_col_connection = @@collation_connection */ ;
886/*!50003 SET character_set_client = utf8mb4 */ ;
887/*!50003 SET character_set_results = utf8mb4 */ ;
888/*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ;
889/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
890/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;
891DELIMITER ;;
892CREATE DEFINER=`cbk`@`%` PROCEDURE `is_task_taken`(IN TASK_ID_INPUT int)
893begin
894 DECLARE `STATUS_ID` INT(16);
895
896 SET STATUS_ID = (
897 SELECT `status`
898 FROM sentinel_2_log.tasks
899 where ID = TASK_ID_INPUT
900 );
901 #select STATUS_ID as 'STATUS';
902 IF EXISTS (
903 WITH CT0 as
904 (
905 SELECT `ID`
906 FROM sentinel_2_log.task_status
907 where `status`='undefined'
908 )
909 Select ID from CT0 where CT0.ID=STATUS_ID
910 )
911 THEN
912 SELECT '0' AS 'STATUS';
913 ELSE
914 SELECT '1' AS 'STATUS';
915 END IF;
916end ;;
917DELIMITER ;
918/*!50003 SET sql_mode = @saved_sql_mode */ ;
919/*!50003 SET character_set_client = @saved_cs_client */ ;
920/*!50003 SET character_set_results = @saved_cs_results */ ;
921/*!50003 SET collation_connection = @saved_col_connection */ ;
922/*!50003 DROP PROCEDURE IF EXISTS `new_task` */;
923/*!50003 SET @saved_cs_client = @@character_set_client */ ;
924/*!50003 SET @saved_cs_results = @@character_set_results */ ;
925/*!50003 SET @saved_col_connection = @@collation_connection */ ;
926/*!50003 SET character_set_client = utf8mb4 */ ;
927/*!50003 SET character_set_results = utf8mb4 */ ;
928/*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ;
929/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
930/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;
931DELIMITER ;;
932CREATE DEFINER=`cbk`@`%` PROCEDURE `new_task`( IN input_command varchar(512),
933 IN input_arguments varchar(512))
934BEGIN
935 DECLARE TASK_STATUS INT(16);
936 SET TASK_STATUS = (
937 select `ID`
938 from `task_status`
939 where `status`='undefined'
940 );
941 insert into tasks(`status`, `command`, `argument`)
942 values (TASK_STATUS,input_command, input_arguments);
943 insert into tasks_archive(`status`, `command`, `argument`)
944 values (TASK_STATUS,input_command, input_arguments);
945END ;;
946DELIMITER ;
947/*!50003 SET sql_mode = @saved_sql_mode */ ;
948/*!50003 SET character_set_client = @saved_cs_client */ ;
949/*!50003 SET character_set_results = @saved_cs_results */ ;
950/*!50003 SET collation_connection = @saved_col_connection */ ;
951/*!50003 DROP PROCEDURE IF EXISTS `new_task_with_log` */;
952/*!50003 SET @saved_cs_client = @@character_set_client */ ;
953/*!50003 SET @saved_cs_results = @@character_set_results */ ;
954/*!50003 SET @saved_col_connection = @@collation_connection */ ;
955/*!50003 SET character_set_client = utf8mb4 */ ;
956/*!50003 SET character_set_results = utf8mb4 */ ;
957/*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ;
958/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
959/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;
960DELIMITER ;;
961CREATE DEFINER=`cbk`@`%` PROCEDURE `new_task_with_log`( IN input_command varchar(512),
962 IN input_arguments varchar(512),
963 IN author varchar(128))
964BEGIN
965 call `new_task`(input_command,input_arguments);
966 call insert_log_with_task('Information',author,'New task was created.',LAST_INSERT_ID());
967END ;;
968DELIMITER ;
969/*!50003 SET sql_mode = @saved_sql_mode */ ;
970/*!50003 SET character_set_client = @saved_cs_client */ ;
971/*!50003 SET character_set_results = @saved_cs_results */ ;
972/*!50003 SET collation_connection = @saved_col_connection */ ;
973/*!50003 DROP PROCEDURE IF EXISTS `select_task_life_history` */;
974/*!50003 SET @saved_cs_client = @@character_set_client */ ;
975/*!50003 SET @saved_cs_results = @@character_set_results */ ;
976/*!50003 SET @saved_col_connection = @@collation_connection */ ;
977/*!50003 SET character_set_client = utf8mb4 */ ;
978/*!50003 SET character_set_results = utf8mb4 */ ;
979/*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ;
980/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
981/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;
982DELIMITER ;;
983CREATE DEFINER=`cbk`@`%` PROCEDURE `select_task_life_history`( task_id int(16) )
984BEGIN
985 SELECT *
986 FROM sentinel_2_log.log_list_view
987 where `Task ID`=task_id
988 order by `Date and time`;
989END ;;
990DELIMITER ;
991/*!50003 SET sql_mode = @saved_sql_mode */ ;
992/*!50003 SET character_set_client = @saved_cs_client */ ;
993/*!50003 SET character_set_results = @saved_cs_results */ ;
994/*!50003 SET collation_connection = @saved_col_connection */ ;
995
996--
997-- Final view structure for view `active_tasks_list`
998--
999
1000/*!50001 DROP VIEW IF EXISTS `active_tasks_list`*/;
1001/*!50001 SET @saved_cs_client = @@character_set_client */;
1002/*!50001 SET @saved_cs_results = @@character_set_results */;
1003/*!50001 SET @saved_col_connection = @@collation_connection */;
1004/*!50001 SET character_set_client = utf8mb4 */;
1005/*!50001 SET character_set_results = utf8mb4 */;
1006/*!50001 SET collation_connection = utf8mb4_0900_ai_ci */;
1007/*!50001 CREATE ALGORITHM=UNDEFINED */
1008/*!50013 DEFINER=`cbk`@`%` SQL SECURITY DEFINER */
1009/*!50001 VIEW `active_tasks_list` AS select `tasks`.`ID` AS `ID`,`tasks`.`command` AS `Command`,`tasks`.`argument` AS `Arguments`,`task_status`.`status` AS `Status` from (`tasks` join `task_status` on((`task_status`.`ID` = `tasks`.`status`))) */;
1010/*!50001 SET character_set_client = @saved_cs_client */;
1011/*!50001 SET character_set_results = @saved_cs_results */;
1012/*!50001 SET collation_connection = @saved_col_connection */;
1013
1014--
1015-- Final view structure for view `log_list_view`
1016--
1017
1018/*!50001 DROP VIEW IF EXISTS `log_list_view`*/;
1019/*!50001 SET @saved_cs_client = @@character_set_client */;
1020/*!50001 SET @saved_cs_results = @@character_set_results */;
1021/*!50001 SET @saved_col_connection = @@collation_connection */;
1022/*!50001 SET character_set_client = utf8mb4 */;
1023/*!50001 SET character_set_results = utf8mb4 */;
1024/*!50001 SET collation_connection = utf8mb4_0900_ai_ci */;
1025/*!50001 CREATE ALGORITHM=UNDEFINED */
1026/*!50013 DEFINER=`cbk`@`%` SQL SECURITY DEFINER */
1027/*!50001 VIEW `log_list_view` AS select `logs_list`.`ID` AS `ID`,`log_types`.`log_type` AS `Log type`,`node_list`.`node_unique_name` AS `Machine name`,`logs_list`.`Log_value` AS `Log value`,`logs_list`.`data_and_time` AS `Date and time`,`logs_list`.`task` AS `Task ID` from ((`logs_list` join `log_types` on((`log_types`.`ID` = `logs_list`.`log_type`))) join `node_list` on((`node_list`.`ID` = `logs_list`.`node_unique_name`))) */;
1028/*!50001 SET character_set_client = @saved_cs_client */;
1029/*!50001 SET character_set_results = @saved_cs_results */;
1030/*!50001 SET collation_connection = @saved_col_connection */;
1031
1032--
1033-- Final view structure for view `node_atributes`
1034--
1035
1036/*!50001 DROP VIEW IF EXISTS `node_atributes`*/;
1037/*!50001 SET @saved_cs_client = @@character_set_client */;
1038/*!50001 SET @saved_cs_results = @@character_set_results */;
1039/*!50001 SET @saved_col_connection = @@collation_connection */;
1040/*!50001 SET character_set_client = utf8mb4 */;
1041/*!50001 SET character_set_results = utf8mb4 */;
1042/*!50001 SET collation_connection = utf8mb4_0900_ai_ci */;
1043/*!50001 CREATE ALGORITHM=UNDEFINED */
1044/*!50013 DEFINER=`cbk`@`%` SQL SECURITY DEFINER */
1045/*!50001 VIEW `node_atributes` AS select `node_atribute_list`.`ID` AS `ID`,`node_list`.`node_unique_name` AS `Node name`,`nodes_atributes_types`.`type_value` AS `Atribute type`,`node_atribute_list`.`node_artribute_value` AS `Value`,`node_atribute_list`.`data_and_time` AS `Date and time` from ((`node_atribute_list` join `node_list` on((`node_list`.`ID` = `node_atribute_list`.`node_unique_name`))) join `nodes_atributes_types` on((`nodes_atributes_types`.`ID` = `node_atribute_list`.`node_artribute_type`))) */;
1046/*!50001 SET character_set_client = @saved_cs_client */;
1047/*!50001 SET character_set_results = @saved_cs_results */;
1048/*!50001 SET collation_connection = @saved_col_connection */;
1049
1050--
1051-- Final view structure for view `permission_list`
1052--
1053
1054/*!50001 DROP VIEW IF EXISTS `permission_list`*/;
1055/*!50001 SET @saved_cs_client = @@character_set_client */;
1056/*!50001 SET @saved_cs_results = @@character_set_results */;
1057/*!50001 SET @saved_col_connection = @@collation_connection */;
1058/*!50001 SET character_set_client = utf8mb4 */;
1059/*!50001 SET character_set_results = utf8mb4 */;
1060/*!50001 SET collation_connection = utf8mb4_0900_ai_ci */;
1061/*!50001 CREATE ALGORITHM=UNDEFINED */
1062/*!50013 DEFINER=`cbk`@`%` SQL SECURITY DEFINER */
1063/*!50001 VIEW `permission_list` AS select `groups`.`ID` AS `ID`,`groups_type`.`group_type` AS `Permission type`,`logical_operators`.`operator` AS `Logical operator`,`groups`.`value` AS `permission value` from ((`groups` join `logical_operators` on((`logical_operators`.`ID` = `groups`.`logical_operator`))) join `groups_type` on((`groups_type`.`ID` = `groups`.`type`))) */;
1064/*!50001 SET character_set_client = @saved_cs_client */;
1065/*!50001 SET character_set_results = @saved_cs_results */;
1066/*!50001 SET collation_connection = @saved_col_connection */;
1067
1068--
1069-- Final view structure for view `permission_on_task`
1070--
1071
1072/*!50001 DROP VIEW IF EXISTS `permission_on_task`*/;
1073/*!50001 SET @saved_cs_client = @@character_set_client */;
1074/*!50001 SET @saved_cs_results = @@character_set_results */;
1075/*!50001 SET @saved_col_connection = @@collation_connection */;
1076/*!50001 SET character_set_client = utf8mb4 */;
1077/*!50001 SET character_set_results = utf8mb4 */;
1078/*!50001 SET collation_connection = utf8mb4_0900_ai_ci */;
1079/*!50001 CREATE ALGORITHM=UNDEFINED */
1080/*!50013 DEFINER=`cbk`@`%` SQL SECURITY DEFINER */
1081/*!50001 VIEW `permission_on_task` AS select `permission`.`ID` AS `ID`,`active_tasks_list`.`ID` AS `Task ID`,`active_tasks_list`.`Command` AS `Command`,`active_tasks_list`.`Arguments` AS `Arguments`,`active_tasks_list`.`Status` AS `Status`,`permission_list`.`Permission type` AS `Permission type`,`permission_list`.`Logical operator` AS `Logical operator`,`permission_list`.`permission value` AS `permission value` from ((`permission` join `active_tasks_list` on((`active_tasks_list`.`ID` = `permission`.`task`))) join `permission_list` on((`permission_list`.`ID` = `permission`.`group`))) */;
1082/*!50001 SET character_set_client = @saved_cs_client */;
1083/*!50001 SET character_set_results = @saved_cs_results */;
1084/*!50001 SET collation_connection = @saved_col_connection */;
1085/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1086
1087/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1088/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1089/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1090/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1091/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1092/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1093/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1094
1095-- Dump completed on 2018-12-31 11:28:22