Changeset 41170 for branches/eam_branches/ipp-20191011/ippMonitor/czartool/czarDbSchema.sql

Timestamp:

Nov 27, 2019, 11:39:38 AM (7 years ago)

Author:

eugene

Message:

merge changes from trunk (mostly Ohana & ippMonitor improvements, some work on ippTools)

Location:

branches/eam_branches/ipp-20191011

Files:

• . (modified) (1 prop)
• ippMonitor (modified) (1 prop)
• ippMonitor/czartool/czarDbSchema.sql (modified) (1 diff)

branches/eam_branches/ipp-20191011/ippMonitor/czartool/czarDbSchema.sql

@@ -404 +404 @@
 
 --
+-- Table structure for table `science_labels` (from current_labels)
+--
+
+DROP TABLE IF EXISTS `science_labels`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `science_labels` (
+  `server` varchar(128) default NULL,
+  `label` varchar(128) default NULL,
+  `telescope` varchar(128) NOT NULL,
+  `priority` int(11) NOT NULL default '0',
+  KEY `science_labels` (`server`,`label`, `telescope`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Table structure for table `science_nightlyscience` (from nightlyscience)
+--
+
+DROP TABLE IF EXISTS `science_nightlyscience`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `science_nightlyscience` (
+  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
+  `status` varchar(128) default 'NONE',
+  `telescope` varchar(128) NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Table structure for table `science_reverts` (from reverts)
+--
+
+DROP TABLE IF EXISTS `science_reverts`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `science_reverts` (
+  `stage` varchar(128) default NULL,
+  `telescope` varchar(128) NOT NULL,
+  `reverting` tinyint(4) default NULL
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Table structure for table `science_server_dates` (from server_dates)
+--
+
+DROP TABLE IF EXISTS `science_server_dates`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `science_server_dates` (
+  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
+  `server` varchar(64) default 'NONE',
+  `telescope` varchar(128) NOT NULL,
+  `date` varchar(64) default 'NONE'
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Table structure for table `science_servers` (from servers)
+--
+
+DROP TABLE IF EXISTS `science_servers`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `science_servers` (
+  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
+  `server` varchar(128) default NULL,
+  `telescope` varchar(128) NOT NULL,
+  `alive` tinyint(4) default NULL,
+  `running` tinyint(4) default NULL
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Table structure for table `live_servers` (from servers)
+--
+
+DROP TABLE IF EXISTS `live_servers`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `live_servers` (
+  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
+  `server` varchar(128) default NULL,
+  `telescope` varchar(128) NOT NULL,
+  `alive` tinyint(4) default NULL,
+  `running` tinyint(4) default NULL
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
 -- Table structure for table `server_dates`
 --