Changeset 40055 for trunk/ippMonitor/czartool/czarDbSchema.sql

Timestamp:

May 24, 2017, 2:55:55 PM (9 years ago)

Author:

watersc1

Message:

Update to czartool to populate summit/download/new/raw Exp tables, and plot those results with the other stages. Fixes bug that allowed plot temp files to remain undeleted

File:

• trunk/ippMonitor/czartool/czarDbSchema.sql (modified) (2 diffs)

trunk/ippMonitor/czartool/czarDbSchema.sql

@@ -520 +520 @@
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 SET character_set_client = @saved_cs_client;
+
+
+--
+-- Table structure for table `summitExp`
+--
+
+DROP TABLE IF EXISTS `summitExp`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `summitExp` (
+  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
+  `label` varchar(128) default 'NONE',
+  `dbname` varchar(128) default 'NONE',
+  `pending` bigint(20) NOT NULL,
+  `faults` bigint(20) NOT NULL,
+  `processed` bigint(20) NOT NULL default '0',
+  KEY `summitExpIndex` (`timestamp`,`label`, `dbname`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Table structure for table `downloadExp`
+--
+
+DROP TABLE IF EXISTS `downloadExp`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `downloadExp` (
+  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
+  `label` varchar(128) default 'NONE',
+  `dbname` varchar(128) default 'NONE',
+  `pending` bigint(20) NOT NULL,
+  `faults` bigint(20) NOT NULL,
+  `processed` bigint(20) NOT NULL default '0',
+  KEY `downloadExpIndex` (`timestamp`,`label`, `dbname`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Table structure for table `newExp`
+--
+
+DROP TABLE IF EXISTS `newExp`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `newExp` (
+  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
+  `label` varchar(128) default 'NONE',
+  `dbname` varchar(128) default 'NONE',
+  `pending` bigint(20) NOT NULL,
+  `faults` bigint(20) NOT NULL,
+  `processed` bigint(20) NOT NULL default '0',
+  KEY `newExpIndex` (`timestamp`,`label`, `dbname`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Table structure for table `rawExp`
+--
+
+DROP TABLE IF EXISTS `rawExp`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `rawExp` (
+  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
+  `label` varchar(128) default 'NONE',
+  `dbname` varchar(128) default 'NONE',
+  `pending` bigint(20) NOT NULL,
+  `faults` bigint(20) NOT NULL,
+  `processed` bigint(20) NOT NULL default '0',
+  KEY `rawExpIndex` (`timestamp`,`label`, `dbname`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+
+
 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
 
@@ -529 +605 @@
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
+