-- MySQL dump 10.13  Distrib 5.1.34, for Win32 (ia32)
--
-- Host: 192.168.1.101    Database: cpv
-- ------------------------------------------------------
-- Server version	5.1.34-community

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `ivcurve`
--

DROP TABLE IF EXISTS `ivcurve`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ivcurve` (
  `idivcurve` int(11) NOT NULL AUTO_INCREMENT,
  `platform` varchar(45) DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  `guid` varchar(36) NOT NULL,
  `type` int(11) NOT NULL,
  `DUT` varchar(45) DEFAULT NULL,
  `location` varchar(45) DEFAULT NULL,
  `user` varchar(45) DEFAULT NULL,
  `notes` text,
  `Aperture` double DEFAULT NULL,
  PRIMARY KEY (`idivcurve`),
  KEY `user` (`user`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ivcurve`
--

LOCK TABLES `ivcurve` WRITE;
/*!40000 ALTER TABLE `ivcurve` DISABLE KEYS */;
INSERT INTO `ivcurve` VALUES (1,NULL,NULL,'0841a8db-5a34-11de-8ecf-2ce1e5d88926',1,NULL,NULL,NULL,NULL,NULL),(2,'laptop','2009-01-01 00:00:00','4ff38fd2-5a34-11de-8ecf-2ce1e5d88926',1,'1234567890',NULL,NULL,NULL,NULL),(3,'laptop','2009-01-01 00:00:00','74286675-5a34-11de-8ecf-2ce1e5d88926',1,'1234567890','San Francisco','abc','notes',0.001);
/*!40000 ALTER TABLE `ivcurve` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ivcurve_analysis`
--

DROP TABLE IF EXISTS `ivcurve_analysis`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ivcurve_analysis` (
  `idivcurve_analysis` int(11) NOT NULL,
  `idivcurve` int(11) DEFAULT NULL,
  `Gsh` double DEFAULT NULL,
  `Rse` double DEFAULT NULL,
  `Isc` double DEFAULT NULL,
  `Voc` double DEFAULT NULL,
  `Pmax` double DEFAULT NULL,
  `Imp` double DEFAULT NULL,
  `Vmp` double DEFAULT NULL,
  `FF` double DEFAULT NULL,
  `Eff` double DEFAULT NULL,
  `meanGni` double DEFAULT NULL,
  `meanDni` double DEFAULT NULL,
  `GniMp` double DEFAULT NULL,
  `DniMp` double DEFAULT NULL,
  `GshR2` double DEFAULT NULL,
  `RseR2` double DEFAULT NULL,
  PRIMARY KEY (`idivcurve_analysis`),
  KEY `ivcurve` (`idivcurve`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ivcurve_analysis`
--

LOCK TABLES `ivcurve_analysis` WRITE;
/*!40000 ALTER TABLE `ivcurve_analysis` DISABLE KEYS */;
/*!40000 ALTER TABLE `ivcurve_analysis` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ivcurve_hardware`
--

DROP TABLE IF EXISTS `ivcurve_hardware`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ivcurve_hardware` (
  `idivcurve_hardware` int(11) NOT NULL,
  `idivcurve` int(11) DEFAULT NULL,
  `smuMake` varchar(45) DEFAULT NULL,
  `smuModel` varchar(45) DEFAULT NULL,
  `smuSerial` varchar(45) DEFAULT NULL COMMENT '		',
  `daqMake` varchar(45) DEFAULT NULL,
  `daqModel` varchar(45) DEFAULT NULL,
  `daqSerial` varchar(45) DEFAULT NULL,
  `gniMake` varchar(45) DEFAULT NULL,
  `gniModel` varchar(45) DEFAULT NULL,
  `gniSerial` varchar(45) DEFAULT NULL,
  `gniCal` double DEFAULT NULL COMMENT '		',
  `dniMake` varchar(45) DEFAULT NULL,
  `dniModel` varchar(45) DEFAULT NULL,
  `dniSerial` varchar(45) DEFAULT NULL,
  `dniCal` double DEFAULT NULL COMMENT '		',
  `psmMake` varchar(45) DEFAULT NULL,
  `psmModel` varchar(45) DEFAULT NULL,
  `psmSerial` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`idivcurve_hardware`),
  KEY `ivcurve` (`idivcurve`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ivcurve_hardware`
--

LOCK TABLES `ivcurve_hardware` WRITE;
/*!40000 ALTER TABLE `ivcurve_hardware` DISABLE KEYS */;
/*!40000 ALTER TABLE `ivcurve_hardware` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ivcurve_params`
--

DROP TABLE IF EXISTS `ivcurve_params`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ivcurve_params` (
  `idivcurve_params` int(11) NOT NULL,
  `idivcurve` int(11) DEFAULT NULL,
  `startV` double DEFAULT NULL,
  `endV` double DEFAULT NULL,
  `numPoints` int(11) DEFAULT NULL,
  `iComp` double DEFAULT NULL,
  `numSweeps` int(11) DEFAULT NULL,
  `settle` double DEFAULT NULL,
  `idle` double DEFAULT NULL,
  `measure` double DEFAULT NULL,
  `dc` double DEFAULT NULL,
  PRIMARY KEY (`idivcurve_params`),
  KEY `idivcurve` (`idivcurve`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ivcurve_params`
--

LOCK TABLES `ivcurve_params` WRITE;
/*!40000 ALTER TABLE `ivcurve_params` DISABLE KEYS */;
/*!40000 ALTER TABLE `ivcurve_params` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ivcurve_sweep`
--

DROP TABLE IF EXISTS `ivcurve_sweep`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ivcurve_sweep` (
  `idivcurve_sweep` int(11) NOT NULL AUTO_INCREMENT,
  `idivcurve` int(11) NOT NULL,
  `time` double DEFAULT NULL,
  `voltage` double DEFAULT NULL,
  `current` double DEFAULT NULL,
  `power` double DEFAULT NULL,
  `DNI` double DEFAULT NULL,
  `GNI` double DEFAULT NULL,
  `azimuth` double DEFAULT NULL,
  `elevation` double DEFAULT NULL,
  `psmX` double DEFAULT NULL,
  `psmY` double DEFAULT NULL,
  `TC1` double DEFAULT NULL,
  `TC2` double DEFAULT NULL,
  `TC3` double DEFAULT NULL,
  `TC4` double DEFAULT NULL,
  PRIMARY KEY (`idivcurve_sweep`),
  KEY `idivcurve` (`idivcurve`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ivcurve_sweep`
--

LOCK TABLES `ivcurve_sweep` WRITE;
/*!40000 ALTER TABLE `ivcurve_sweep` DISABLE KEYS */;
/*!40000 ALTER TABLE `ivcurve_sweep` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ivcurve_type`
--

DROP TABLE IF EXISTS `ivcurve_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ivcurve_type` (
  `idivcurve_type` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(45) NOT NULL,
  `desc` varchar(512) DEFAULT NULL,
  PRIMARY KEY (`idivcurve_type`,`type`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ivcurve_type`
--

LOCK TABLES `ivcurve_type` WRITE;
/*!40000 ALTER TABLE `ivcurve_type` DISABLE KEYS */;
INSERT INTO `ivcurve_type` VALUES (1,'DarkIV',NULL),(2,'LightIV',NULL);
/*!40000 ALTER TABLE `ivcurve_type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `params`
--

DROP TABLE IF EXISTS `params`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `params` (
  `idparams` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) NOT NULL,
  `value` varchar(45) NOT NULL,
  `TS` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `user` varchar(45) DEFAULT NULL,
  `note` text,
  PRIMARY KEY (`idparams`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `params`
--

LOCK TABLES `params` WRITE;
/*!40000 ALTER TABLE `params` DISABLE KEYS */;
INSERT INTO `params` VALUES (1,'dbversion','0.1','2009-05-25 06:33:23',NULL,NULL),(2,'platform','1a219ec1-48f6-11de-a68f-53187c264c0a','2009-05-25 06:34:30',NULL,NULL);
/*!40000 ALTER TABLE `params` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `program_params`
--

DROP TABLE IF EXISTS `program_params`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `program_params` (
  `idparams` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) NOT NULL,
  `value` text NOT NULL,
  `TS` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `user` varchar(45) DEFAULT NULL,
  `note` text,
  PRIMARY KEY (`idparams`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `program_params`
--

LOCK TABLES `program_params` WRITE;
/*!40000 ALTER TABLE `program_params` DISABLE KEYS */;
/*!40000 ALTER TABLE `program_params` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `idusers` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(45) NOT NULL,
  `firstname` varchar(45) DEFAULT NULL,
  `lastname` varchar(45) DEFAULT NULL,
  `enabled` int(11) NOT NULL,
  PRIMARY KEY (`idusers`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'cpv'
--
/*!50003 DROP PROCEDURE IF EXISTS `addDarkIVCurve` */;
/*!50003 SET @saved_cs_client      = @@character_set_client */ ;
/*!50003 SET @saved_cs_results     = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client  = utf8 */ ;
/*!50003 SET character_set_results = utf8 */ ;
/*!50003 SET collation_connection  = utf8_general_ci */ ;
/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
/*!50003 SET sql_mode              = 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50020 DEFINER=`cpv`@`%`*/ /*!50003 PROCEDURE `addDarkIVCurve`(

  IN in_platform varchar(45),

  IN in_time datetime,

  IN in_DUT varchar(45),

  IN in_location varchar(45),

  IN in_user varchar(45),

  IN in_notes text(65535),

  IN in_Aperture double

)
BEGIN



SELECT  @type:=idivcurve_type FROM ivcurve_type WHERE type='DarkIV';



INSERT INTO ivcurve

  (`guid`,`type`, `time`, `platform`,`DUT`, `location`,`user`,`notes`,`aperture`)

VALUES

  (UUID(),@type, in_time, in_platform,in_DUT,in_location,in_user,in_notes,in_aperture);



SELECT guid FROM ivcurve WHERE idivcurve=LAST_INSERT_ID();







END */;;
DELIMITER ;
/*!50003 SET sql_mode              = @saved_sql_mode */ ;
/*!50003 SET character_set_client  = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection  = @saved_col_connection */ ;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2009-06-25 16:51:13