-- MySQL dump 10.11
--
-- Host: localhost    Database: inseco
-- ------------------------------------------------------
-- Server version	5.0.92-rs

/*!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 `emails`
--

DROP TABLE IF EXISTS `emails`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `emails` (
  `nombre` varchar(200) NOT NULL default '',
  `position` varchar(200) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `id` varchar(50) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `emails`
--

LOCK TABLES `emails` WRITE;
/*!40000 ALTER TABLE `emails` DISABLE KEYS */;
INSERT INTO `emails` VALUES ('Rafael Espinal','General Manager','Rafael_Espinal@insecopr.com','5106221.28133'),('Jorge Santaella','Operations Manager','Jorge_Santaella@insecopr.com','3400038.18464'),('Scheila Semidei','Administrative Assistant','Scheila_Semidei@insecopr.com','1468472.28210'),('Carmen Rodriguez','Accountant','Carmen_Rodriguez@insecopr.com','5652108.28278'),('Jesús Raymond','Senior Sales Engineer','Jesus_Raymond@insecopr.com','9010261.28298'),('Alexis Amador','Sales Engineer','Alexis_Amador@insecopr.com','5124462.29320'),('Josean Rivera','Sales Engineer','Josean_Rivera@insecopr.com','2307261.29479'),('Edwin Colon','Field Sales','Edwin_Colon@insecopr.com','6300564.30383'),('Jose Miranda','Service Engineer','Jose_Miranda@insecopr.com','6300564.30391'),('Ivette González','Spare Parts & Service Coordinator','Sales@insecopr.com','5577649.30478'),('Alberto Olmo','Service Technician','Alberto_Olmo@insecopr.com','6598401.31135'),('Aida Rosario','Customer Service','Aida_Rosario@insecopr.com','5858249.18664'),('Jannella Toledo','Customer Service','Jannella_Toledo@insecopr.com','7821856.18754');
/*!40000 ALTER TABLE `emails` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `noticias`
--

DROP TABLE IF EXISTS `noticias`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `noticias` (
  `titulo` varchar(200) NOT NULL default '',
  `fecha` date NOT NULL default '0000-00-00',
  `texto` text NOT NULL,
  `id` varchar(50) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `noticias`
--

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

--
-- Table structure for table `survey`
--

DROP TABLE IF EXISTS `survey`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `survey` (
  `name` varchar(200) NOT NULL,
  `company` varchar(200) NOT NULL,
  `position` varchar(200) NOT NULL,
  `equipment` varchar(200) NOT NULL,
  `timeOfResponse` int(11) NOT NULL,
  `flexibility` int(11) NOT NULL,
  `officePersonnel` int(11) NOT NULL,
  `fieldPersonnel` int(11) NOT NULL,
  `charges` int(11) NOT NULL,
  `timeToComplete` int(11) NOT NULL,
  `workCompleted` varchar(30) NOT NULL,
  `workCompleted2` text NOT NULL,
  `reason` varchar(200) NOT NULL,
  `unresolvedQuestions` text NOT NULL,
  `overallSatisfaction` int(11) NOT NULL,
  `id` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `survey`
--

LOCK TABLES `survey` WRITE;
/*!40000 ALTER TABLE `survey` DISABLE KEYS */;
INSERT INTO `survey` VALUES ('jorge santaella','inseco','opmgr','computadora ',5,3,3,3,3,3,'no','se devolvio para reparacion y update software','Work performed did not correct the problem','',0,'4'),('JORGE SANTAELLA','INSECO','OPM',' COMPUTER LENOVO',5,4,5,5,3,2,'no','SE REENVIO PARA SERVICIO ','Failed/broke after being fixed','NADIE ME HA CONTACTADO ',2,'1'),('test','test','test','test',1,2,2,1,2,4,'yes','asdf','Other','asdf',2,'1');
/*!40000 ALTER TABLE `survey` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'inseco'
--
DELIMITER ;;
DELIMITER ;
/*!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 2011-04-20  0:00:37
