· 8 years ago · Feb 07, 2018, 06:56 PM
1DROP TABLE IF EXISTS `runs`
22018-02-07T18:40:28.729945Z 43 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
32018-02-07T18:40:28.736712Z 43 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
42018-02-07T18:40:28.742367Z 43 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
52018-02-07T18:40:28.747146Z 43 Query SELECT DATABASE()
62018-02-07T18:40:28.747339Z 43 Init DB tarari
72018-02-07T18:40:28.747814Z 43 Query /*!40101 SET @saved_cs_client = @@character_set_client */
82018-02-07T18:40:28.748563Z 43 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
92018-02-07T18:40:28.752249Z 43 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
102018-02-07T18:40:28.754979Z 43 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
112018-02-07T18:40:28.757700Z 43 Query SELECT DATABASE()
122018-02-07T18:40:28.757809Z 43 Init DB tarari
132018-02-07T18:40:28.758117Z 43 Query /*!40101 SET character_set_client = utf8 */
142018-02-07T18:40:28.758570Z 43 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
152018-02-07T18:40:28.764154Z 43 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
162018-02-07T18:40:28.766257Z 43 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
172018-02-07T18:40:28.768374Z 43 Query SELECT DATABASE()
182018-02-07T18:40:28.768490Z 43 Init DB tarari
192018-02-07T18:40:28.768740Z 43 Query CREATE TABLE `runs` (
20 `RunID` int(11) NOT NULL DEFAULT '0',
21 `StartTime` timestamp NULL DEFAULT NULL,
22 `Ruleset` varchar(150) DEFAULT NULL,
23 `Dataset` varchar(150) DEFAULT NULL,
24 `OutputFile` varchar(150) DEFAULT NULL,
25 `EndTime` timestamp NULL DEFAULT NULL,
26 `NumMatches` int(11) DEFAULT NULL,
27 `preserve` varchar(5) DEFAULT NULL,
28 `User` varchar(45) DEFAULT NULL,
29 `file_count` int(11) NOT NULL,
30 `size_of_files` bigint(12) NOT NULL,
31 `result_count` int(11) NOT NULL,
32 `pro_bytes` bigint(11) NOT NULL,
33 `pro_time` int(11) NOT NULL,
34 `dataset_start_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
35 `dataset_end_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
36 `table_s` varchar(255) DEFAULT NULL,
37 `table_i` varchar(255) DEFAULT NULL,
38 `description` text,
39 PRIMARY KEY (`RunID`)
40) ENGINE=InnoDB DEFAULT CHARSET=latin1
412018-02-07T18:40:28.787196Z 43 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
422018-02-07T18:40:28.790459Z 43 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
432018-02-07T18:40:28.792796Z 43 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
442018-02-07T18:40:28.795163Z 43 Query SELECT DATABASE()
452018-02-07T18:40:28.795390Z 43 Init DB tarari
462018-02-07T18:40:28.795714Z 43 Query /*!40101 SET character_set_client = @saved_cs_client */
472018-02-07T18:40:28.796464Z 43 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
482018-02-07T18:40:28.802057Z 43 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
492018-02-07T18:40:28.806726Z 43 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
502018-02-07T18:40:28.812304Z 43 Query SELECT DATABASE()
512018-02-07T18:40:28.812575Z 43 Init DB tarari
522018-02-07T18:40:28.813153Z 43 Query --
53-- Dumping data for table `runs`
54--
55-- WHERE: runid=430864838
56
57LOCK TABLES `runs` WRITE
582018-02-07T18:40:28.814929Z 43 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
592018-02-07T18:40:28.820997Z 43 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
602018-02-07T18:40:28.826619Z 43 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
612018-02-07T18:40:28.831938Z 43 Query SELECT DATABASE()
622018-02-07T18:40:28.832295Z 43 Init DB tarari
632018-02-07T18:40:28.833114Z 43 Query /*!40000 ALTER TABLE `runs` DISABLE KEYS */
642018-02-07T18:40:28.834375Z 43 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
652018-02-07T18:45:03.710109Z 44 Quit
66
67-- MySQL dump 10.13 Distrib 5.7.16, for Linux (x86_64)
68--
69-- Host: localhost Database: tarari
70-- ------------------------------------------------------
71-- Server version 5.7.16-log
72
73/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
74/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
75/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
76/*!40101 SET NAMES utf8 */;
77/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
78/*!40103 SET TIME_ZONE='+00:00' */;
79/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
80/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
81/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
82/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
83
84--
85-- Table structure for table `runs`
86--
87
88DROP TABLE IF EXISTS `runs`;
89/*!40101 SET @saved_cs_client = @@character_set_client */;
90/*!40101 SET character_set_client = utf8 */;
91CREATE TABLE `runs` (
92 `RunID` int(11) NOT NULL DEFAULT '0',
93 `StartTime` timestamp NULL DEFAULT NULL,
94 `Ruleset` varchar(150) DEFAULT NULL,
95 `Dataset` varchar(150) DEFAULT NULL,
96 `OutputFile` varchar(150) DEFAULT NULL,
97 `EndTime` timestamp NULL DEFAULT NULL,
98 `NumMatches` int(11) DEFAULT NULL,
99 `preserve` varchar(5) DEFAULT NULL,
100 `User` varchar(45) DEFAULT NULL,
101 `file_count` int(11) NOT NULL,
102 `size_of_files` bigint(12) NOT NULL,
103 `result_count` int(11) NOT NULL,
104 `pro_bytes` bigint(11) NOT NULL,
105 `pro_time` int(11) NOT NULL,
106 `dataset_start_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
107 `dataset_end_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
108 `table_s` varchar(255) DEFAULT NULL,
109 `table_i` varchar(255) DEFAULT NULL,
110 `description` text,
111 PRIMARY KEY (`RunID`)
112) ENGINE=InnoDB DEFAULT CHARSET=latin1;
113/*!40101 SET character_set_client = @saved_cs_client */;
114
115--
116-- Dumping data for table `runs`
117--
118-- WHERE: runid=430864838
119
120LOCK TABLES `runs` WRITE;
121/*!40000 ALTER TABLE `runs` DISABLE KEYS */;
122INSERT INTO `runs` VALUES (430864838,'2017-05-28 16:58:43','/home/typhon/work/cyber/unipart/nhs/full-scan-May-2017/TC/Snapshot_10_05_2017b/ipreputation_TC.x','/home/typhon/work/cyber/unipart/nhs/full-scan-May-2017/data/ZDD-Day-Reports/','/home/typhon/output-28-05-17-17-38-32.csv','2017-05-28 16:58:57',25202,'True','typhon',71,6710577260,25298,6710577260,4683242,'2017-03-12 00:03:11','2017-05-21 22:59:43','hits_TC_100517','ipreputation_TC_100517','');
123/*!40000 ALTER TABLE `runs` ENABLE KEYS */;
124UNLOCK TABLES;
125/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
126
127/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
128/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
129/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
130/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
131/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
132/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
133/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
134
135-- Dump completed on 2017-12-10 14:18:17