Index: /branches/ccl_branches/ipp-20190806/ippMonitor/czartool/czarDbSchema.sql
===================================================================
--- /branches/ccl_branches/ipp-20190806/ippMonitor/czartool/czarDbSchema.sql	(revision 41000)
+++ /branches/ccl_branches/ipp-20190806/ippMonitor/czartool/czarDbSchema.sql	(revision 41001)
@@ -404,4 +404,79 @@
 
 --
+-- 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`
 --