Changeset 36815 for trunk/ippToPsps/config/ippToPspsDbSchema.sql

Timestamp:

Jun 4, 2014, 3:42:24 PM (12 years ago)

Author:

heather

Message:

current ipptopsps before we discovered we need skinny objects

File:

• trunk/ippToPsps/config/ippToPspsDbSchema.sql (modified) (1 diff)

trunk/ippToPsps/config/ippToPspsDbSchema.sql

@@ -278 +278 @@
 
 -- Dump completed on 2012-04-10  6:00:59
+
+
+DROP TABLE IF EXISTS `dvodb`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `dvodb` (
+  `dvo_db` varchar(30) default NULL,
+  `batch_type` varchar(10) default NULL,
+  `stage_id` bigint(20) unsigned default NULL,
+  `ra_center` float default NULL,
+  `dec_center` float default NULL,
+  `uniq_key` varchar(30) default NULL,
+  UNIQUE KEY `uniq_key` (`uniq_key`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+