Changeset 41001

Timestamp:

Oct 29, 2019, 3:33:36 PM (7 years ago)

Author:

cclin33

Message:

add tables science_labels, science_nightlyscience, science_reverts, science_server_dates, science_servers

File:

• branches/ccl_branches/ipp-20190806/ippMonitor/czartool/czarDbSchema.sql (modified) (1 diff)

branches/ccl_branches/ipp-20190806/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 `server_dates`
 --