-- MySQL dump 10.8
--
-- Host: localhost    Database: proerp
-- ------------------------------------------------------
-- Server version	4.1.7-Max-log

/*!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 */;
/*!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" */;

--
-- Table structure for table `accessProfile`
--

DROP TABLE IF EXISTS `accessProfile`;
CREATE TABLE `accessProfile` (
  `idAccessProfile` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`idAccessProfile`),
  UNIQUE KEY `AP_unique` (`name`),
  KEY `AP_name` (`name`,`idAccessProfile`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `accessProfile`
--


/*!40000 ALTER TABLE `accessProfile` DISABLE KEYS */;
LOCK TABLES `accessProfile` WRITE;
INSERT INTO `accessProfile` (`idAccessProfile`, `name`) VALUES (1,'Administrador'),(2,'Director'),(4,'Gerente de proyecto'),(3,'Tesorero');
UNLOCK TABLES;
/*!40000 ALTER TABLE `accessProfile` ENABLE KEYS */;

--
-- Table structure for table `accessProfileRoles`
--

DROP TABLE IF EXISTS `accessProfileRoles`;
CREATE TABLE `accessProfileRoles` (
  `idAccessProfile` int(11) NOT NULL default '0',
  `idSystemModule` int(11) NOT NULL default '0',
  `roles` varchar(255) NOT NULL default '',
  UNIQUE KEY `APR_unique` (`idAccessProfile`,`idSystemModule`),
  KEY `APR_idAccessProfile` (`idAccessProfile`),
  KEY `APR_idSystemModule` (`idSystemModule`),
  KEY `APR_roles` (`roles`),
  CONSTRAINT `FK_systemModule1` FOREIGN KEY (`idSystemModule`) REFERENCES `systemModule` (`idSystemModule`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_accessProfile1` FOREIGN KEY (`idAccessProfile`) REFERENCES `accessProfile` (`idAccessProfile`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `accessProfileRoles`
--


/*!40000 ALTER TABLE `accessProfileRoles` DISABLE KEYS */;
LOCK TABLES `accessProfileRoles` WRITE;
INSERT INTO `accessProfileRoles` (`idAccessProfile`, `idSystemModule`, `roles`) VALUES (4,200,'create,modify,delete,viewShort'),(4,300,'create,modify,delete,viewShort'),(4,301,'create,modify,delete,viewShort'),(4,302,'create,modify,delete,viewShort'),(4,303,'create,modify,delete,viewShort'),(4,304,'create,modify,delete,viewShort'),(4,305,'create,modify,delete,viewShort'),(4,306,'create,modify,delete,viewShort'),(4,310,'create,modify,delete,viewShort'),(4,1000,'create,modify,delete,viewShort'),(4,1031,'create,modify,delete,viewShort'),(4,1040,'create,modify,delete,viewShort'),(4,1050,'create,modify,delete,viewShort'),(1,100,'create,modify,delete,viewShort,viewFull'),(1,101,'create,modify,delete,viewShort,viewFull'),(1,102,'create,modify,delete,viewShort,viewFull'),(1,103,'create,modify,delete,viewShort,viewFull'),(1,104,'create,modify,delete,viewShort,viewFull'),(1,105,'create,modify,delete,viewShort,viewFull'),(1,106,'create,modify,delete,viewShort,viewFull'),(1,107,'create,modify,delete,viewShort,viewFull'),(1,108,'create,modify,delete,viewShort,viewFull'),(1,109,'create,modify,delete,viewShort,viewFull'),(1,110,'create,modify,delete,viewShort,viewFull'),(1,111,'create,modify,delete,viewShort,viewFull'),(1,200,'create,modify,delete,viewShort,viewFull'),(1,201,'create,modify,delete,viewShort,viewFull'),(1,203,'create,modify,delete,viewShort,viewFull'),(1,204,'create,modify,delete,viewShort,viewFull'),(1,300,'create,modify,delete,viewShort,viewFull'),(1,301,'create,modify,delete,viewShort,viewFull'),(1,302,'create,modify,delete,viewShort,viewFull'),(1,303,'create,modify,delete,viewShort,viewFull'),(1,304,'create,modify,delete,viewShort,viewFull'),(1,305,'create,modify,delete,viewShort,viewFull'),(1,306,'create,modify,delete,viewShort,viewFull'),(1,307,'create,modify,delete,viewShort,viewFull'),(1,308,'create,modify,delete,viewShort,viewFull'),(1,310,'create,modify,delete,viewShort,viewFull'),(1,1000,'create,modify,delete,viewShort,viewFull'),(1,1010,'create,modify,delete,viewShort,viewFull'),(1,1020,'create,modify,delete,viewShort,viewFull'),(1,1030,'create,modify,delete,viewShort,viewFull'),(1,1031,'create,modify,delete,viewShort,viewFull'),(1,1032,'create,modify,delete,viewShort,viewFull'),(1,1040,'create,modify,delete,viewShort,viewFull'),(1,1050,'create,modify,delete,viewShort,viewFull'),(2,200,'create,modify,delete,viewShort,viewFull'),(2,300,'create,modify,delete,viewShort,viewFull'),(2,301,'create,modify,delete,viewShort,viewFull'),(2,302,'create,modify,delete,viewShort,viewFull'),(2,303,'create,modify,delete,viewShort,viewFull'),(2,304,'create,modify,delete,viewShort,viewFull'),(2,305,'create,modify,delete,viewShort,viewFull'),(2,306,'create,modify,delete,viewShort,viewFull'),(2,307,'create,modify,delete,viewShort,viewFull'),(2,308,'create,modify,delete,viewShort,viewFull'),(2,310,'create,modify,delete,viewShort,viewFull'),(2,1000,'create,modify,delete,viewShort,viewFull'),(2,1031,'create,modify,delete,viewShort,viewFull'),(2,1040,'create,modify,delete,viewShort,viewFull'),(2,1050,'create,modify,delete,viewShort,viewFull'),(3,200,'create,modify,delete,viewShort,viewFull'),(3,300,'create,modify,delete,viewShort,viewFull'),(3,301,'create,modify,delete,viewShort,viewFull'),(3,302,'create,modify,delete,viewShort,viewFull'),(3,303,'create,modify,delete,viewShort,viewFull'),(3,304,'create,modify,delete,viewShort,viewFull'),(3,305,'create,modify,delete,viewShort,viewFull'),(3,306,'create,modify,delete,viewShort,viewFull'),(3,307,'create,modify,delete,viewShort,viewFull'),(3,308,'create,modify,delete,viewShort,viewFull'),(3,310,'create,modify,delete,viewShort,viewFull'),(3,1000,'create,modify,delete,viewShort,viewFull'),(3,1031,'create,modify,delete,viewShort,viewFull'),(3,1040,'create,modify,delete,viewShort,viewFull'),(3,1050,'create,modify,delete,viewShort,viewFull'),(4,307,'create,modify,delete,viewShort,viewFull'),(3,201,'viewShort'),(3,203,'viewShort'),(3,204,'viewShort'),(4,201,'viewShort'),(4,203,'viewShort'),(4,204,'viewShort'),(4,308,'viewShort'),(2,201,'viewShort,viewFull,create,modify,delete'),(2,203,'viewShort,viewFull,create,modify,delete'),(2,204,'viewShort,viewFull,create,modify,delete');
UNLOCK TABLES;
/*!40000 ALTER TABLE `accessProfileRoles` ENABLE KEYS */;

--
-- Table structure for table `company`
--

DROP TABLE IF EXISTS `company`;
CREATE TABLE `company` (
  `idCompany` int(11) NOT NULL auto_increment,
  `idServerFile` int(11) default NULL,
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`idCompany`),
  UNIQUE KEY `COMP_unique` (`name`),
  KEY `FK_serverFile1` (`idServerFile`),
  CONSTRAINT `FK_serverFile1` FOREIGN KEY (`idServerFile`) REFERENCES `serverFile` (`idServerFile`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `company`
--


/*!40000 ALTER TABLE `company` DISABLE KEYS */;
LOCK TABLES `company` WRITE;
INSERT INTO `company` (`idCompany`, `idServerFile`, `name`) VALUES (1,1,'Higuera & Sanchez'),(2,NULL,'MMLV'),(3,NULL,'Promotora Unica, S.A. de C.V.'),(4,NULL,'Administradora Sanchez Higuera, S.A. de C.V.');
UNLOCK TABLES;
/*!40000 ALTER TABLE `company` ENABLE KEYS */;

--
-- Table structure for table `companyData`
--

DROP TABLE IF EXISTS `companyData`;
CREATE TABLE `companyData` (
  `idCompany` int(11) NOT NULL default '0',
  `documentNumber` varchar(255) default NULL,
  `address` varchar(255) default NULL,
  `address1` varchar(255) default NULL,
  `address2` varchar(255) default NULL,
  `city` varchar(255) default NULL,
  `state` varchar(255) default NULL,
  `postalCode` varchar(255) default NULL,
  `phone1` varchar(255) default NULL,
  `phone2` varchar(255) default NULL,
  `phone3` varchar(255) default NULL,
  `email` varchar(255) default NULL,
  UNIQUE KEY `COMPD_unique` (`idCompany`),
  CONSTRAINT `FK_company3` FOREIGN KEY (`idCompany`) REFERENCES `company` (`idCompany`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `companyData`
--


/*!40000 ALTER TABLE `companyData` DISABLE KEYS */;
LOCK TABLES `companyData` WRITE;
INSERT INTO `companyData` (`idCompany`, `documentNumber`, `address`, `address1`, `address2`, `city`, `state`, `postalCode`, `phone1`, `phone2`, `phone3`, `email`) VALUES (2,'','','','','','','','','','',''),(3,'PUN000125MK1','Merida 16','Roma','Cuauhtemoc','México','Distrito Federal','06700','','','',''),(4,'ASH0106182N9','Merida 16','Roma','Cuauhtemoc','México','Distrito Federal','06700','55147616','52071183','52070904','');
UNLOCK TABLES;
/*!40000 ALTER TABLE `companyData` ENABLE KEYS */;

--
-- Table structure for table `companyDepartment`
--

DROP TABLE IF EXISTS `companyDepartment`;
CREATE TABLE `companyDepartment` (
  `idCompanyDepartment` int(11) NOT NULL auto_increment,
  `idCompany` int(11) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`idCompanyDepartment`),
  UNIQUE KEY `COMPDEP_unique` (`name`,`idCompany`),
  KEY `FK_company1` (`idCompany`),
  CONSTRAINT `FK_company1` FOREIGN KEY (`idCompany`) REFERENCES `company` (`idCompany`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `companyDepartment`
--


/*!40000 ALTER TABLE `companyDepartment` DISABLE KEYS */;
LOCK TABLES `companyDepartment` WRITE;
INSERT INTO `companyDepartment` (`idCompanyDepartment`, `idCompany`, `name`) VALUES (6,3,''),(1,1,'Administración'),(4,1,'Director'),(3,1,'Gerencia de proyectos'),(7,4,'Tecnico'),(5,1,'Tesorero'),(2,1,'Ventas');
UNLOCK TABLES;
/*!40000 ALTER TABLE `companyDepartment` ENABLE KEYS */;

--
-- Table structure for table `currency`
--

DROP TABLE IF EXISTS `currency`;
CREATE TABLE `currency` (
  `idCurrency` int(11) NOT NULL auto_increment,
  `name` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`idCurrency`),
  KEY `CURR_name` (`name`,`idCurrency`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `currency`
--


/*!40000 ALTER TABLE `currency` DISABLE KEYS */;
LOCK TABLES `currency` WRITE;
INSERT INTO `currency` (`idCurrency`, `name`) VALUES (1,'Pesos'),(3,'UDI'),(2,'USD');
UNLOCK TABLES;
/*!40000 ALTER TABLE `currency` ENABLE KEYS */;

--
-- Table structure for table `currencyChangeRate`
--

DROP TABLE IF EXISTS `currencyChangeRate`;
CREATE TABLE `currencyChangeRate` (
  `idCurrencyFrom` int(11) NOT NULL default '0',
  `idCurrencyTo` int(11) NOT NULL default '0',
  `idEmployee` int(11) default NULL,
  `value` double NOT NULL default '0',
  `dateRegistration` datetime NOT NULL default '0000-00-00 00:00:00',
  UNIQUE KEY `CURCHRT_unique` (`idCurrencyFrom`,`idCurrencyTo`,`dateRegistration`),
  KEY `FK_currency4` (`idCurrencyTo`),
  KEY `FK_employee8` (`idEmployee`),
  CONSTRAINT `FK_employee8` FOREIGN KEY (`idEmployee`) REFERENCES `employee` (`idEmployee`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `FK_currency3` FOREIGN KEY (`idCurrencyFrom`) REFERENCES `currency` (`idCurrency`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_currency4` FOREIGN KEY (`idCurrencyTo`) REFERENCES `currency` (`idCurrency`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `currencyChangeRate`
--


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

--
-- Table structure for table `employee`
--

DROP TABLE IF EXISTS `employee`;
CREATE TABLE `employee` (
  `idEmployee` int(11) NOT NULL auto_increment,
  `idEmployeeType` int(11) NOT NULL default '0',
  `nameFirst` varchar(255) NOT NULL default '',
  `nameFirst1` varchar(255) NOT NULL default '',
  `nameLast` varchar(255) NOT NULL default '',
  `nameLast1` varchar(255) NOT NULL default '',
  `documentNumber` varchar(255) NOT NULL default '',
  `dateRegistered` date NOT NULL default '0000-00-00',
  `dateBirthday` date default NULL,
  PRIMARY KEY  (`idEmployee`),
  UNIQUE KEY `EMP_unique` (`documentNumber`),
  KEY `EMP_idEmployeeType` (`idEmployeeType`),
  CONSTRAINT `FK_infEmployeeType` FOREIGN KEY (`idEmployeeType`) REFERENCES `employeeType` (`idEmployeeType`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `employee`
--


/*!40000 ALTER TABLE `employee` DISABLE KEYS */;
LOCK TABLES `employee` WRITE;
INSERT INTO `employee` (`idEmployee`, `idEmployeeType`, `nameFirst`, `nameFirst1`, `nameLast`, `nameLast1`, `documentNumber`, `dateRegistered`, `dateBirthday`) VALUES (1,1,'Admin','','Admin','','YAVI771214FM9','2005-02-01','1980-05-10'),(3,1,'Analía','Verónica','Diaz','','DIXA711014MNEZXN01','2003-09-17','1971-10-14'),(8,1,'Pablo','Miguel','Degregorio','Vega','DEVP730810HNEGGB03','2001-09-01','1973-08-10'),(10,1,'Alex','','Manon','','3','2005-02-07',NULL),(11,1,'Juan','Ignacio','Reyes','Gonzalez','REGJ760424HDFYNN08','2002-11-01','1976-04-24'),(13,1,'Ruben','','Lechuga','Gomez','LEGR670811HZSCMB03','1996-01-01','1967-08-11'),(14,1,'Alvaro','','Becker','Corral','BECA760114HDFCRL07','2003-01-01','1976-01-14'),(15,1,'Rosalba','','Olivares','Serrano','OISR670904MDFLRS09','2000-04-01','1967-09-04'),(16,1,'Efren','','Ortiz','Perez','OIPE640801HDFRRF01','2004-04-01','1964-08-01'),(17,1,'Waldo','','Higuera','Zogaib','HIZW700705HDFGGL03','1996-10-23','1970-07-05'),(18,1,'Santiago','','Sanchez','Corral','SACS750703HDFNRN01','2001-09-01','1975-07-03'),(19,1,'Ada','Ruth','Pizano','Sanchez','PISA740728MDFZND05','2002-05-06','1974-07-28'),(20,1,'Magdalena','','Dominguez','Ortega','DOOM670414MDFRMRG09','1994-01-11','1967-04-14'),(21,1,'Socorro','Andrea','Zogaib','Achar','ZOAS491130MNEGCC01','2003-10-01','1949-11-30'),(22,1,'Claudia','','Gonzalez','Ramos','GORC680523MDFNML06','2002-09-09','1968-05-23'),(23,1,'Mirna','Elizabeth','Lopez','Pamatz','LOPM800102MDFPMY00','2003-08-01','1980-01-02'),(24,1,'Rodrigo','','Higuera','Zogaib','HIZR721019HDFGGD05','1999-01-01','1972-10-19'),(25,1,'Francisco','','Castañeda','Montiel','CAMF700214HDFSNR03','2004-06-01','1970-02-14'),(26,1,'Jose','Luis','Garcia','Jimenez','GAJL740110HMCRMS05','2000-05-01','1974-01-10'),(27,1,'Jose','Luis','Gonzalez','Ramirez','GORL720825HDFNM500','2004-06-16','1972-08-25'),(28,1,'Jesus','','Mendoza','Lamadird','MELJ651104HDFNMS00','2004-03-01','1965-11-04'),(29,1,'Fernando','','Valdivia','Saldivar','c','2003-06-16',NULL),(30,1,'Bertha','Elena','Corral','Ybarrondo','COYB450818MDFRBR08','2002-11-01','1945-08-18'),(31,1,'Alfredo','Guillermo','Flores','Zuazua','FOZA680827HDFLZL02','2004-06-16','1968-08-27'),(32,1,'Ricardo','','Puente','Gonzalez','PUGR740705','2003-10-16','1974-07-05'),(33,1,'Gustavo','','Aguilar','Coronado','AUCG720217','2003-07-01','1972-02-17'),(34,1,'Raul','','Franco','Martinez','FAMR760704','2001-10-01','1976-07-04'),(35,1,'Jose','Antonio','Hernandez','Santos','HESA600408HDFRNN04','2002-01-14','1960-04-08'),(36,1,'Hugo','','Rivera','Ala torre','RIAH620701C18','2003-04-16','1962-07-01'),(37,1,'Gerardo','','Verges','Flores','VEFG780922HDFRLR02','2004-07-05','1978-09-22');
UNLOCK TABLES;
/*!40000 ALTER TABLE `employee` ENABLE KEYS */;

--
-- Table structure for table `employeeAccessProfile`
--

DROP TABLE IF EXISTS `employeeAccessProfile`;
CREATE TABLE `employeeAccessProfile` (
  `idEmployee` int(11) NOT NULL default '0',
  `idAccessProfile` int(11) NOT NULL default '0',
  `idProject` int(11) default NULL,
  UNIQUE KEY `EAP_unique` (`idEmployee`,`idAccessProfile`,`idProject`),
  KEY `EAP_idEmployee` (`idEmployee`),
  KEY `EAP_idAccessProfile` (`idAccessProfile`),
  KEY `FK_project7` (`idProject`),
  CONSTRAINT `FK_project7` FOREIGN KEY (`idProject`) REFERENCES `project` (`idProject`) ON DELETE SET NULL,
  CONSTRAINT `FK_accessProfile2` FOREIGN KEY (`idAccessProfile`) REFERENCES `accessProfile` (`idAccessProfile`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_employee3` FOREIGN KEY (`idEmployee`) REFERENCES `employee` (`idEmployee`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `employeeAccessProfile`
--


/*!40000 ALTER TABLE `employeeAccessProfile` DISABLE KEYS */;
LOCK TABLES `employeeAccessProfile` WRITE;
INSERT INTO `employeeAccessProfile` (`idEmployee`, `idAccessProfile`, `idProject`) VALUES (1,1,NULL),(3,4,NULL),(3,4,2),(8,4,4),(10,4,3),(11,4,NULL),(13,4,NULL),(14,4,NULL),(14,4,2),(14,4,3),(14,4,4),(15,1,NULL),(15,1,2),(15,1,3),(15,1,4),(15,1,7),(16,3,NULL),(16,3,2),(16,3,3),(16,3,4),(16,3,7),(17,2,NULL),(17,2,2),(17,2,3),(17,2,4),(17,2,7),(18,2,NULL),(18,2,2),(18,2,3),(18,2,4),(18,2,7);
UNLOCK TABLES;
/*!40000 ALTER TABLE `employeeAccessProfile` ENABLE KEYS */;

--
-- Table structure for table `employeeCompany`
--

DROP TABLE IF EXISTS `employeeCompany`;
CREATE TABLE `employeeCompany` (
  `idEmployee` int(11) NOT NULL default '0',
  `idCompany` int(11) NOT NULL default '0',
  `idCompanyDepartment` int(11) NOT NULL default '0',
  UNIQUE KEY `EMPLCOMP_unique` (`idEmployee`),
  KEY `FK_company2` (`idCompany`),
  KEY `FK_companyDepartment1` (`idCompanyDepartment`),
  CONSTRAINT `FK_employee5` FOREIGN KEY (`idEmployee`) REFERENCES `employee` (`idEmployee`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_company2` FOREIGN KEY (`idCompany`) REFERENCES `company` (`idCompany`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_companyDepartment1` FOREIGN KEY (`idCompanyDepartment`) REFERENCES `companyDepartment` (`idCompanyDepartment`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `employeeCompany`
--


/*!40000 ALTER TABLE `employeeCompany` DISABLE KEYS */;
LOCK TABLES `employeeCompany` WRITE;
INSERT INTO `employeeCompany` (`idEmployee`, `idCompany`, `idCompanyDepartment`) VALUES (3,1,3),(8,1,3),(10,1,3),(11,1,3),(13,1,3),(14,1,2),(15,1,1),(16,1,5),(17,1,4),(18,1,4),(19,1,1),(20,1,1),(21,1,1),(22,1,1),(23,1,1),(24,1,1),(25,4,7),(26,4,7),(27,4,7),(28,4,7),(29,4,7),(30,1,2),(31,1,2),(32,1,2),(33,4,7),(34,4,7),(35,4,7),(36,1,1),(37,4,7);
UNLOCK TABLES;
/*!40000 ALTER TABLE `employeeCompany` ENABLE KEYS */;

--
-- Table structure for table `employeeData`
--

DROP TABLE IF EXISTS `employeeData`;
CREATE TABLE `employeeData` (
  `idEmployee` int(11) NOT NULL default '0',
  `address` varchar(255) NOT NULL default '',
  `address1` varchar(255) NOT NULL default '',
  `address2` varchar(255) NOT NULL default '',
  `city` varchar(255) NOT NULL default '',
  `state` varchar(255) NOT NULL default '',
  `postalCode` varchar(255) NOT NULL default '',
  `phone1` varchar(255) NOT NULL default '',
  `phone2` varchar(255) NOT NULL default '',
  `phone3` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  UNIQUE KEY `ED_idEmployee` (`idEmployee`),
  CONSTRAINT `FK_employee1` FOREIGN KEY (`idEmployee`) REFERENCES `employee` (`idEmployee`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `employeeData`
--


/*!40000 ALTER TABLE `employeeData` DISABLE KEYS */;
LOCK TABLES `employeeData` WRITE;
INSERT INTO `employeeData` (`idEmployee`, `address`, `address1`, `address2`, `city`, `state`, `postalCode`, `phone1`, `phone2`, `phone3`, `email`) VALUES (3,'Durango 327 alt 502','Roma','Cuauhtémoc','México','D.F.','06700','','','',''),(8,'Patricio Sanz 1870','Del Valle','Benito Juárez','México','D.F.','03100','','','',''),(14,'Veracruz 79-301','Condesa','Cuauhtémoc','México','D.F.','06140','','','',''),(17,'Merida 16','Roma','Cuauhtémoc','México','D.F.','06700','','','','');
UNLOCK TABLES;
/*!40000 ALTER TABLE `employeeData` ENABLE KEYS */;

--
-- Table structure for table `employeeType`
--

DROP TABLE IF EXISTS `employeeType`;
CREATE TABLE `employeeType` (
  `idEmployeeType` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`idEmployeeType`),
  UNIQUE KEY `EMPT_unique` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `employeeType`
--


/*!40000 ALTER TABLE `employeeType` DISABLE KEYS */;
LOCK TABLES `employeeType` WRITE;
INSERT INTO `employeeType` (`idEmployeeType`, `name`) VALUES (2,'Externo'),(1,'Interno');
UNLOCK TABLES;
/*!40000 ALTER TABLE `employeeType` ENABLE KEYS */;

--
-- Table structure for table `employeeUser`
--

DROP TABLE IF EXISTS `employeeUser`;
CREATE TABLE `employeeUser` (
  `idEmployee` int(11) NOT NULL default '0',
  `username` varchar(255) NOT NULL default '',
  `password` varchar(255) NOT NULL default '',
  `roles` varchar(255) NOT NULL default '',
  UNIQUE KEY `EU_unique` (`username`),
  UNIQUE KEY `EU_idEmployee` (`idEmployee`),
  CONSTRAINT `FK_employee2` FOREIGN KEY (`idEmployee`) REFERENCES `employee` (`idEmployee`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `employeeUser`
--


/*!40000 ALTER TABLE `employeeUser` DISABLE KEYS */;
LOCK TABLES `employeeUser` WRITE;
INSERT INTO `employeeUser` (`idEmployee`, `username`, `password`, `roles`) VALUES (1,'admin','admin',''),(10,'alex.manon','manal56',''),(14,'alvaro.becker01','albek55',''),(3,'analia.diaz','ana',''),(16,'efren.ortiz','ortef19',''),(11,'juan.reyes','reyju38',''),(8,'pablo.degregorio','pdbdeg01',''),(15,'rosalba.olivares','olros29',''),(13,'ruben.lechuga','benle98',''),(18,'santiago.sanchez','sahis73',''),(17,'waldo.higuera','hsiwa83','');
UNLOCK TABLES;
/*!40000 ALTER TABLE `employeeUser` ENABLE KEYS */;

--
-- Table structure for table `fieldType`
--

DROP TABLE IF EXISTS `fieldType`;
CREATE TABLE `fieldType` (
  `idFieldType` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `sqlType` varchar(255) NOT NULL default '',
  `sqlSize` varchar(255) default NULL,
  `cfType` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`idFieldType`),
  KEY `FT_name` (`name`,`idFieldType`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fieldType`
--


/*!40000 ALTER TABLE `fieldType` DISABLE KEYS */;
LOCK TABLES `fieldType` WRITE;
INSERT INTO `fieldType` (`idFieldType`, `name`, `sqlType`, `sqlSize`, `cfType`) VALUES (1,'Number','double','','cf_sql_double'),(2,'Currency','double','','cf_sql_money'),(3,'Date','date','','cf_sql_date'),(4,'Date and time','datetime','','cf_sql_timestamp'),(5,'Text','varchar','255','cf_sql_varchar'),(6,'Big text','text','','cf_sql_clob'),(7,'Image','varchar','255','cf_sql_varchar'),(8,'File','varchar','255','cf_sql_varchar');
UNLOCK TABLES;
/*!40000 ALTER TABLE `fieldType` ENABLE KEYS */;

--
-- Table structure for table `paymentRequest`
--

DROP TABLE IF EXISTS `paymentRequest`;
CREATE TABLE `paymentRequest` (
  `idPaymentRequest` int(11) NOT NULL auto_increment,
  `idPaymentRequestState` int(11) NOT NULL default '0',
  `idEmployee` int(11) default NULL,
  `idProject` int(11) NOT NULL default '0',
  `idProvider` int(11) NOT NULL default '0',
  `idServerFile` int(11) default NULL,
  `idPaymentType` int(11) default NULL,
  `idCurrency` int(11) default NULL,
  `dateRegistered` datetime NOT NULL default '0000-00-00 00:00:00',
  `billNumber` varchar(255) NOT NULL default '',
  `billConcept` varchar(255) NOT NULL default '',
  `billDate` date default NULL,
  `amountNoTax` double NOT NULL default '0',
  `amountTaxToPay` double NOT NULL default '0',
  `amountTaxToHold` double NOT NULL default '0',
  `amount` double NOT NULL default '0',
  `paymentTypeInfo` text,
  `comment` text,
  PRIMARY KEY  (`idPaymentRequest`),
  UNIQUE KEY `PAYREQ_unique` (`idProject`,`idProvider`,`billNumber`,`billConcept`),
  KEY `FK_currency8` (`idCurrency`),
  KEY `FK_employee13` (`idEmployee`),
  KEY `FK_paymentRequestState1` (`idPaymentRequestState`),
  KEY `FK_paymentType1` (`idPaymentType`),
  KEY `FK_provider2` (`idProvider`),
  KEY `FK_serverFile4` (`idServerFile`),
  CONSTRAINT `FK_serverFile4` FOREIGN KEY (`idServerFile`) REFERENCES `serverFile` (`idServerFile`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `FK_currency8` FOREIGN KEY (`idCurrency`) REFERENCES `currency` (`idCurrency`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `FK_employee13` FOREIGN KEY (`idEmployee`) REFERENCES `employee` (`idEmployee`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `FK_paymentRequestState1` FOREIGN KEY (`idPaymentRequestState`) REFERENCES `paymentRequestState` (`idPaymentRequestState`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_paymentType1` FOREIGN KEY (`idPaymentType`) REFERENCES `paymentType` (`idPaymentType`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `FK_project12` FOREIGN KEY (`idProject`) REFERENCES `project` (`idProject`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_provider2` FOREIGN KEY (`idProvider`) REFERENCES `provider` (`idProvider`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `paymentRequest`
--


/*!40000 ALTER TABLE `paymentRequest` DISABLE KEYS */;
LOCK TABLES `paymentRequest` WRITE;
INSERT INTO `paymentRequest` (`idPaymentRequest`, `idPaymentRequestState`, `idEmployee`, `idProject`, `idProvider`, `idServerFile`, `idPaymentType`, `idCurrency`, `dateRegistered`, `billNumber`, `billConcept`, `billDate`, `amountNoTax`, `amountTaxToPay`, `amountTaxToHold`, `amount`, `paymentTypeInfo`, `comment`) VALUES (4,1,3,2,2,NULL,NULL,NULL,'2005-02-01 18:17:55','00','Corte Inicio',NULL,3613180.8,0,0,3613180.8,'',''),(5,1,3,2,2,NULL,NULL,NULL,'2005-02-01 18:20:17','001','Corte inicio',NULL,618358.45,0,0,618358.45,'',''),(6,1,3,2,2,NULL,NULL,NULL,'2005-02-01 18:23:56','002','Corte Inicio',NULL,250177.97,0,0,250177.97,'',''),(7,1,3,2,2,NULL,NULL,NULL,'2005-02-01 18:27:49','003','Corte Inicio',NULL,330704.99,0,0,330704.99,'',''),(8,1,3,2,2,NULL,NULL,NULL,'2005-02-01 18:29:01','004','Corte Inicio',NULL,552235.05,0,0,552235.05,'',''),(9,1,3,2,2,NULL,NULL,NULL,'2005-02-01 18:30:14','005','Corte Inicio',NULL,3008765.08,0,0,3008765.08,'',''),(10,1,3,2,2,NULL,NULL,NULL,'2005-02-01 18:31:40','006','Corte Inicio',NULL,396370.4,0,0,396370.4,'',''),(11,30,3,2,2,NULL,NULL,NULL,'2005-02-01 18:33:04','007','Corte Inicio',NULL,202975,0,0,202975,'',''),(15,1,3,2,1,NULL,1,NULL,'2005-02-07 18:28:08','005','Mat y Mo Estruct.',NULL,124503.78,18675.57,0,143179.35,'',''),(16,1,3,2,3,NULL,1,NULL,'2005-02-07 18:30:09','006','Supervision',NULL,5021.74,753.26,0,5775,'',''),(17,1,3,2,4,NULL,1,NULL,'2005-02-07 18:34:28','010','Gerencia',NULL,13948.7,2092.3,0,16041,'','');
UNLOCK TABLES;
/*!40000 ALTER TABLE `paymentRequest` ENABLE KEYS */;

--
-- Table structure for table `paymentRequestDetails`
--

DROP TABLE IF EXISTS `paymentRequestDetails`;
CREATE TABLE `paymentRequestDetails` (
  `idPaymentRequestDetails` int(11) NOT NULL auto_increment,
  `idPaymentRequest` int(11) NOT NULL default '0',
  `idProjectActivity` int(11) default NULL,
  `idProjectTask` int(11) default NULL,
  `idProjectParcel` int(11) default NULL,
  `idProjectSubParcel` int(11) default NULL,
  `amount` double NOT NULL default '0',
  PRIMARY KEY  (`idPaymentRequestDetails`),
  UNIQUE KEY `PAYREQDET_unique` (`idPaymentRequest`,`idProjectActivity`,`idProjectTask`,`idProjectParcel`,`idProjectSubParcel`),
  KEY `FK_projectActivity4` (`idProjectActivity`),
  KEY `FK_projectParcel2` (`idProjectParcel`),
  KEY `FK_projectSubParcel1` (`idProjectSubParcel`),
  KEY `FK_projectTask3` (`idProjectTask`),
  CONSTRAINT `FK_projectTask3` FOREIGN KEY (`idProjectTask`) REFERENCES `projectTask` (`idProjectTask`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `FK_paymentRequest1` FOREIGN KEY (`idPaymentRequest`) REFERENCES `paymentRequest` (`idPaymentRequest`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_projectActivity4` FOREIGN KEY (`idProjectActivity`) REFERENCES `projectActivity` (`idProjectActivity`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `FK_projectParcel2` FOREIGN KEY (`idProjectParcel`) REFERENCES `projectParcel` (`idProjectParcel`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `FK_projectSubParcel1` FOREIGN KEY (`idProjectSubParcel`) REFERENCES `projectSubParcel` (`idProjectSubParcel`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `paymentRequestDetails`
--


/*!40000 ALTER TABLE `paymentRequestDetails` DISABLE KEYS */;
LOCK TABLES `paymentRequestDetails` WRITE;
INSERT INTO `paymentRequestDetails` (`idPaymentRequestDetails`, `idPaymentRequest`, `idProjectActivity`, `idProjectTask`, `idProjectParcel`, `idProjectSubParcel`, `amount`) VALUES (3,4,12,NULL,NULL,NULL,3613180.8),(4,5,14,NULL,NULL,NULL,618358.45),(5,6,15,NULL,NULL,NULL,250177.97),(6,7,16,NULL,NULL,NULL,330704.99),(7,8,17,NULL,NULL,NULL,552235.05),(8,9,18,NULL,NULL,NULL,3008765.08),(9,10,22,NULL,NULL,NULL,396370.4),(10,11,19,NULL,NULL,NULL,202975),(13,17,16,NULL,NULL,NULL,16041),(15,15,18,NULL,NULL,NULL,143179.35),(17,16,19,NULL,NULL,NULL,5775);
UNLOCK TABLES;
/*!40000 ALTER TABLE `paymentRequestDetails` ENABLE KEYS */;

--
-- Table structure for table `paymentRequestState`
--

DROP TABLE IF EXISTS `paymentRequestState`;
CREATE TABLE `paymentRequestState` (
  `idPaymentRequestState` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`idPaymentRequestState`),
  UNIQUE KEY `PRQST_unique` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `paymentRequestState`
--


/*!40000 ALTER TABLE `paymentRequestState` DISABLE KEYS */;
LOCK TABLES `paymentRequestState` WRITE;
INSERT INTO `paymentRequestState` (`idPaymentRequestState`, `name`) VALUES (20,'Aprobado por director'),(10,'Aprobado por tesorero'),(1,'Creado'),(30,'Pagado'),(120,'Rechazado por director'),(110,'Rechazado por tesorero');
UNLOCK TABLES;
/*!40000 ALTER TABLE `paymentRequestState` ENABLE KEYS */;

--
-- Table structure for table `paymentRequestStateHistory`
--

DROP TABLE IF EXISTS `paymentRequestStateHistory`;
CREATE TABLE `paymentRequestStateHistory` (
  `idPaymentRequestStateHistory` int(11) NOT NULL auto_increment,
  `idPaymentRequest` int(11) NOT NULL default '0',
  `idPaymentRequestState` int(11) NOT NULL default '0',
  `idEmployee` int(11) default NULL,
  `dateRegistered` datetime NOT NULL default '0000-00-00 00:00:00',
  `comment` blob NOT NULL,
  PRIMARY KEY  (`idPaymentRequestStateHistory`),
  UNIQUE KEY `paymentRequestStateHistory_unique` (`idPaymentRequest`,`idPaymentRequestState`),
  KEY `FK_paymentRequestState2` (`idPaymentRequestState`),
  KEY `Fk_employee14` (`idEmployee`),
  CONSTRAINT `Fk_employee14` FOREIGN KEY (`idEmployee`) REFERENCES `employee` (`idEmployee`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `FK_paymentRequest2` FOREIGN KEY (`idPaymentRequest`) REFERENCES `paymentRequest` (`idPaymentRequest`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_paymentRequestState2` FOREIGN KEY (`idPaymentRequestState`) REFERENCES `paymentRequestState` (`idPaymentRequestState`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `paymentRequestStateHistory`
--


/*!40000 ALTER TABLE `paymentRequestStateHistory` DISABLE KEYS */;
LOCK TABLES `paymentRequestStateHistory` WRITE;
INSERT INTO `paymentRequestStateHistory` (`idPaymentRequestStateHistory`, `idPaymentRequest`, `idPaymentRequestState`, `idEmployee`, `dateRegistered`, `comment`) VALUES (4,4,1,3,'2005-02-01 18:17:55',''),(5,5,1,3,'2005-02-01 18:20:17',''),(6,6,1,3,'2005-02-01 18:23:56',''),(7,7,1,3,'2005-02-01 18:27:49',''),(8,8,1,3,'2005-02-01 18:29:01',''),(9,9,1,3,'2005-02-01 18:30:14',''),(10,10,1,3,'2005-02-01 18:31:40',''),(11,11,1,3,'2005-02-01 18:33:04',''),(17,11,10,NULL,'2005-02-03 17:37:25',''),(18,11,20,NULL,'2005-02-03 17:37:50',''),(21,11,30,NULL,'2005-02-03 17:38:51',''),(22,15,1,3,'2005-02-07 18:28:08',''),(23,16,1,3,'2005-02-07 18:30:09',''),(24,17,1,3,'2005-02-07 18:34:28','');
UNLOCK TABLES;
/*!40000 ALTER TABLE `paymentRequestStateHistory` ENABLE KEYS */;

--
-- Table structure for table `paymentType`
--

DROP TABLE IF EXISTS `paymentType`;
CREATE TABLE `paymentType` (
  `idPaymentType` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`idPaymentType`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `paymentType`
--


/*!40000 ALTER TABLE `paymentType` DISABLE KEYS */;
LOCK TABLES `paymentType` WRITE;
INSERT INTO `paymentType` (`idPaymentType`, `name`) VALUES (1,'Cheque'),(2,'Transferencia bancaria'),(3,'Efectivo');
UNLOCK TABLES;
/*!40000 ALTER TABLE `paymentType` ENABLE KEYS */;

--
-- Table structure for table `project`
--

DROP TABLE IF EXISTS `project`;
CREATE TABLE `project` (
  `idProject` int(11) NOT NULL auto_increment,
  `idServerFile` int(11) default NULL,
  `idCurrency` int(11) default NULL,
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`idProject`),
  KEY `FK_currency1` (`idCurrency`),
  KEY `FK_serverFile2` (`idServerFile`),
  CONSTRAINT `FK_serverFile2` FOREIGN KEY (`idServerFile`) REFERENCES `serverFile` (`idServerFile`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `FK_currency1` FOREIGN KEY (`idCurrency`) REFERENCES `currency` (`idCurrency`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `project`
--


/*!40000 ALTER TABLE `project` DISABLE KEYS */;
LOCK TABLES `project` WRITE;
INSERT INTO `project` (`idProject`, `idServerFile`, `idCurrency`, `name`) VALUES (2,NULL,1,'Tres picos'),(3,NULL,1,'Spartta'),(4,NULL,1,'Amsterdam 309'),(7,NULL,1,'Zacatecas'),(13,NULL,1,'Chihuahua');
UNLOCK TABLES;
/*!40000 ALTER TABLE `project` ENABLE KEYS */;

--
-- Table structure for table `projectActivity`
--

DROP TABLE IF EXISTS `projectActivity`;
CREATE TABLE `projectActivity` (
  `idProjectActivity` int(11) NOT NULL auto_increment,
  `idParent` int(11) default NULL,
  `idProject` int(11) NOT NULL default '0',
  `idCurrency` int(11) default NULL,
  `idEmployee` int(11) default NULL,
  `name` varchar(255) NOT NULL default '',
  `amountAuthorized` double NOT NULL default '0',
  `amountUsed` double NOT NULL default '0',
  `dateStart` date default NULL,
  `dateEnd` date default NULL,
  `dateEndReal` date default NULL,
  PRIMARY KEY  (`idProjectActivity`),
  UNIQUE KEY `PRJACT_unique` (`idProject`,`name`),
  KEY `FK_currency5` (`idCurrency`),
  KEY `FK_employee9` (`idEmployee`),
  CONSTRAINT `FK_project8` FOREIGN KEY (`idProject`) REFERENCES `project` (`idProject`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_currency5` FOREIGN KEY (`idCurrency`) REFERENCES `currency` (`idCurrency`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `FK_employee9` FOREIGN KEY (`idEmployee`) REFERENCES `employee` (`idEmployee`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `projectActivity`
--


/*!40000 ALTER TABLE `projectActivity` DISABLE KEYS */;
LOCK TABLES `projectActivity` WRITE;
INSERT INTO `projectActivity` (`idProjectActivity`, `idParent`, `idProject`, `idCurrency`, `idEmployee`, `name`, `amountAuthorized`, `amountUsed`, `dateStart`, `dateEnd`, `dateEndReal`) VALUES (12,NULL,2,1,NULL,'01. Terreno',3613180.8,0,NULL,NULL,NULL),(13,NULL,2,1,NULL,'02. Escrituracion',0,0,NULL,NULL,NULL),(14,NULL,2,1,NULL,'03. Licencias / Legales',647583.45,0,NULL,NULL,NULL),(15,NULL,2,1,NULL,'04. Comision Venta',266312.7,0,NULL,NULL,NULL),(16,NULL,2,1,NULL,'05. Gerencia de Proyecto',539200,0,NULL,NULL,NULL),(17,NULL,2,1,NULL,'06. Proyecto Ejecutivo',609429.45,0,NULL,NULL,NULL),(18,NULL,2,1,NULL,'07. Construcción',7258220.89,0,NULL,NULL,NULL),(19,NULL,2,1,NULL,'08. Supervisión',289100,202975,NULL,NULL,NULL),(20,NULL,2,1,NULL,'09. Credito Puente',0,0,NULL,NULL,NULL),(21,NULL,2,1,NULL,'10. Estudios / SP Luz / Factibilidad',0,0,NULL,NULL,NULL),(22,NULL,2,1,NULL,'11. Otros',396370,0,NULL,NULL,NULL),(23,NULL,3,1,NULL,'01. Terreno',0,0,NULL,NULL,NULL),(24,NULL,3,1,NULL,'02. Escrituracion',0,0,NULL,NULL,NULL),(25,NULL,3,1,NULL,'03. Licencias / Legales',0,0,NULL,NULL,NULL),(26,NULL,3,1,NULL,'04. Comision Venta',0,0,NULL,NULL,NULL),(27,NULL,3,1,NULL,'05. Gerencia de Proyecto',0,0,NULL,NULL,NULL),(28,NULL,3,1,NULL,'06. Proyecto Ejecutivo',0,0,NULL,NULL,NULL),(29,NULL,3,1,NULL,'07. Construcción',0,0,NULL,NULL,NULL),(30,NULL,3,1,NULL,'08. Supervisión',0,0,NULL,NULL,NULL),(31,NULL,3,1,NULL,'09. Credito Puente',0,0,NULL,NULL,NULL),(32,NULL,3,1,NULL,'10. Estudios / SP Luz / Factibilidad',0,0,NULL,NULL,NULL),(33,NULL,3,1,NULL,'11. Otros',0,0,NULL,NULL,NULL),(35,NULL,7,1,13,'01. Terreno',9600000,0,'2004-05-03','2004-05-31','2004-05-31'),(36,35,7,1,18,'02. Escrituracion',480000,0,'2004-05-31','2006-01-17',NULL),(37,NULL,7,1,13,'03. Licencias / Legales',930516,0,'2004-05-10','2005-02-10','2005-02-10'),(38,40,7,1,13,'04. Comision Venta',1861032,0,'2004-05-31','2005-11-14',NULL),(39,NULL,7,1,13,'05. Gerencia de Proyecto',861300,0,'2004-05-03','2006-01-31',NULL),(40,35,7,1,13,'06. Proyecto Ejecutivo',787494,0,'2004-05-03','2005-11-10','2005-11-10'),(41,37,7,1,13,'07. Construcción',22200000,0,'2005-01-17','2006-01-17',NULL),(42,40,7,1,13,'08. Supervisión',658205.22,0,'2004-11-01','2006-01-31',NULL),(43,NULL,7,1,1,'09. Credito Puente',1536450,0,'2005-01-03','2005-02-28',NULL),(44,NULL,7,1,13,'10. Estudios / SP Luz / Factibilidad',300000,0,'2004-02-16','2005-08-11',NULL),(45,NULL,7,1,NULL,'11. Otros',0,0,NULL,NULL,NULL);
UNLOCK TABLES;
/*!40000 ALTER TABLE `projectActivity` ENABLE KEYS */;

--
-- Table structure for table `projectActivityHelper`
--

DROP TABLE IF EXISTS `projectActivityHelper`;
CREATE TABLE `projectActivityHelper` (
  `idProjectActivity` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`idProjectActivity`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `projectActivityHelper`
--


/*!40000 ALTER TABLE `projectActivityHelper` DISABLE KEYS */;
LOCK TABLES `projectActivityHelper` WRITE;
INSERT INTO `projectActivityHelper` (`idProjectActivity`, `name`) VALUES (1,'01. Terreno'),(2,'02. Escrituracion'),(3,'03. Licencias / Legales'),(4,'04. Comision Venta'),(5,'05. Gerencia de Proyecto'),(6,'06. Proyecto Ejecutivo'),(7,'07. Construcción'),(8,'08. Supervisión'),(9,'09. Credito Puente'),(10,'10. Estudios / SP Luz / Factibilidad'),(11,'11. Otros');
UNLOCK TABLES;
/*!40000 ALTER TABLE `projectActivityHelper` ENABLE KEYS */;

--
-- Table structure for table `projectInfo`
--

DROP TABLE IF EXISTS `projectInfo`;
CREATE TABLE `projectInfo` (
  `idProject` int(11) NOT NULL default '0',
  `phrase` varchar(255) NOT NULL default '',
  `address` text NOT NULL,
  `siteURL` varchar(255) NOT NULL default '',
  `arquitect` varchar(255) NOT NULL default '',
  `descriptionUnits` text NOT NULL,
  `descriptionGeneral` text NOT NULL,
  `descriptionAccessory` text NOT NULL,
  `descriptionAttributes` text NOT NULL,
  `descriptionAdditional` text NOT NULL,
  `dateStart` date NOT NULL default '0000-00-00',
  `dateEnd` date NOT NULL default '0000-00-00',
  KEY `FK_project2` (`idProject`),
  CONSTRAINT `FK_project2` FOREIGN KEY (`idProject`) REFERENCES `project` (`idProject`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `projectInfo`
--


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

--
-- Table structure for table `projectParcel`
--

DROP TABLE IF EXISTS `projectParcel`;
CREATE TABLE `projectParcel` (
  `idProjectParcel` int(11) NOT NULL auto_increment,
  `idParent` int(11) default NULL,
  `idProjectTask` int(11) NOT NULL default '0',
  `idProjectActivity` int(11) NOT NULL default '0',
  `idProject` int(11) NOT NULL default '0',
  `idCurrency` int(11) default NULL,
  `idEmployee` int(11) default NULL,
  `name` varchar(255) NOT NULL default '',
  `amountAuthorized` double NOT NULL default '0',
  `amountUsed` double NOT NULL default '0',
  `dateStart` date default NULL,
  `dateEnd` date default NULL,
  `dateEndReal` date default NULL,
  PRIMARY KEY  (`idProjectParcel`),
  UNIQUE KEY `PRJPRCL_unique` (`idProjectTask`,`name`),
  KEY `FK_currency7` (`idCurrency`),
  KEY `FK_employee11` (`idEmployee`),
  KEY `FK_project10` (`idProject`),
  KEY `FK_projectActivity2` (`idProjectActivity`),
  CONSTRAINT `FK_projectTask1` FOREIGN KEY (`idProjectTask`) REFERENCES `projectTask` (`idProjectTask`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_currency7` FOREIGN KEY (`idCurrency`) REFERENCES `currency` (`idCurrency`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `FK_employee11` FOREIGN KEY (`idEmployee`) REFERENCES `employee` (`idEmployee`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `FK_project10` FOREIGN KEY (`idProject`) REFERENCES `project` (`idProject`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_projectActivity2` FOREIGN KEY (`idProjectActivity`) REFERENCES `projectActivity` (`idProjectActivity`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `projectParcel`
--


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

--
-- Table structure for table `projectPhoto`
--

DROP TABLE IF EXISTS `projectPhoto`;
CREATE TABLE `projectPhoto` (
  `idProjectPhoto` int(11) NOT NULL auto_increment,
  `idProject` int(11) NOT NULL default '0',
  `idServerFile` int(11) NOT NULL default '0',
  PRIMARY KEY  (`idProjectPhoto`),
  KEY `FK_project1` (`idProject`),
  KEY `FK_serverFile3` (`idServerFile`),
  CONSTRAINT `FK_serverFile3` FOREIGN KEY (`idServerFile`) REFERENCES `serverFile` (`idServerFile`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_project1` FOREIGN KEY (`idProject`) REFERENCES `project` (`idProject`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `projectPhoto`
--


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

--
-- Table structure for table `projectSubParcel`
--

DROP TABLE IF EXISTS `projectSubParcel`;
CREATE TABLE `projectSubParcel` (
  `idProjectSubParcel` int(11) NOT NULL auto_increment,
  `idParent` int(11) default NULL,
  `idProjectParcel` int(11) NOT NULL default '0',
  `idProjectTask` int(11) NOT NULL default '0',
  `idProjectActivity` int(11) NOT NULL default '0',
  `idProject` int(11) NOT NULL default '0',
  `idCurrency` int(11) default NULL,
  `idEmployee` int(11) default NULL,
  `name` varchar(255) NOT NULL default '',
  `amountAuthorized` double NOT NULL default '0',
  `amountUsed` double NOT NULL default '0',
  `dateStart` date default NULL,
  `dateEnd` date default NULL,
  `dateEndReal` date default NULL,
  PRIMARY KEY  (`idProjectSubParcel`),
  UNIQUE KEY `PRJSUBPRCL_unique` (`idProjectParcel`,`name`),
  KEY `FK_currency9` (`idCurrency`),
  KEY `FK_employee12` (`idEmployee`),
  KEY `FK_project11` (`idProject`),
  KEY `FK_projectActivity3` (`idProjectActivity`),
  KEY `FK_projectTask2` (`idProjectTask`),
  CONSTRAINT `FK_projectTask2` FOREIGN KEY (`idProjectTask`) REFERENCES `projectTask` (`idProjectTask`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_currency9` FOREIGN KEY (`idCurrency`) REFERENCES `currency` (`idCurrency`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `FK_employee12` FOREIGN KEY (`idEmployee`) REFERENCES `employee` (`idEmployee`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `FK_project11` FOREIGN KEY (`idProject`) REFERENCES `project` (`idProject`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_projectActivity3` FOREIGN KEY (`idProjectActivity`) REFERENCES `projectActivity` (`idProjectActivity`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_projectParcel1` FOREIGN KEY (`idProjectParcel`) REFERENCES `projectParcel` (`idProjectParcel`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `projectSubParcel`
--


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

--
-- Table structure for table `projectTask`
--

DROP TABLE IF EXISTS `projectTask`;
CREATE TABLE `projectTask` (
  `idProjectTask` int(11) NOT NULL auto_increment,
  `idParent` int(11) default NULL,
  `idProjectActivity` int(11) NOT NULL default '0',
  `idProject` int(11) NOT NULL default '0',
  `idCurrency` int(11) default NULL,
  `idEmployee` int(11) default NULL,
  `name` varchar(255) NOT NULL default '',
  `amountAuthorized` double NOT NULL default '0',
  `amountUsed` double NOT NULL default '0',
  `dateStart` date default NULL,
  `dateEnd` date default NULL,
  `dateEndReal` date default NULL,
  PRIMARY KEY  (`idProjectTask`),
  UNIQUE KEY `PRJTSK_unique` (`idProjectActivity`,`name`),
  KEY `FK_currency6` (`idCurrency`),
  KEY `FK_employee10` (`idEmployee`),
  KEY `FK_project9` (`idProject`),
  CONSTRAINT `FK_projectActivity1` FOREIGN KEY (`idProjectActivity`) REFERENCES `projectActivity` (`idProjectActivity`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_currency6` FOREIGN KEY (`idCurrency`) REFERENCES `currency` (`idCurrency`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `FK_employee10` FOREIGN KEY (`idEmployee`) REFERENCES `employee` (`idEmployee`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `FK_project9` FOREIGN KEY (`idProject`) REFERENCES `project` (`idProject`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `projectTask`
--


/*!40000 ALTER TABLE `projectTask` DISABLE KEYS */;
LOCK TABLES `projectTask` WRITE;
INSERT INTO `projectTask` (`idProjectTask`, `idParent`, `idProjectActivity`, `idProject`, `idCurrency`, `idEmployee`, `name`, `amountAuthorized`, `amountUsed`, `dateStart`, `dateEnd`, `dateEndReal`) VALUES (33,NULL,12,2,1,NULL,'01-A. Factibilidad / Normatividad',0,0,NULL,NULL,NULL),(34,NULL,12,2,1,NULL,'01-B. Revisión fiscal',0,0,NULL,NULL,NULL),(35,NULL,12,2,1,NULL,'01-C. Revisión financiera',0,0,NULL,NULL,NULL),(36,NULL,12,2,1,NULL,'01-D. Revisión legal',0,0,NULL,NULL,NULL),(37,NULL,12,2,1,NULL,'01-E. Compra',0,0,NULL,NULL,NULL),(38,NULL,13,2,1,NULL,'02-A. Pago derechos hacienda',0,0,NULL,NULL,NULL),(39,NULL,13,2,1,NULL,'02-B. Pago notario',0,0,NULL,NULL,NULL),(40,NULL,13,2,1,NULL,'02-C. Pago escritura',0,0,NULL,NULL,NULL),(41,NULL,13,2,1,NULL,'02-D. Pago comisión vendedor',0,0,NULL,NULL,NULL),(42,NULL,14,2,1,NULL,'03-A. Pago derechos',0,0,NULL,NULL,NULL),(43,NULL,14,2,1,NULL,'03-B. Gestoría',0,0,NULL,NULL,NULL),(44,NULL,14,2,1,NULL,'03-C. Factibilidad',0,0,NULL,NULL,NULL),(45,NULL,14,2,1,NULL,'03-D. Regimen Condominio',0,0,NULL,NULL,NULL),(46,NULL,14,2,1,NULL,'03-E. Asesoria Fiscal / Legal',0,0,NULL,NULL,NULL),(47,NULL,15,2,1,NULL,'04-A. Comisiones',0,0,NULL,NULL,NULL),(48,NULL,15,2,1,NULL,'04-B. Gastos indirectos ventas',0,0,NULL,NULL,NULL),(49,NULL,15,2,1,NULL,'04-C. Promoción / Publicidad',0,0,NULL,NULL,NULL),(50,NULL,16,2,1,NULL,'05-A. Crédito / Cobranza',0,0,NULL,NULL,NULL),(51,NULL,16,2,1,NULL,'05-B. Ventas',0,0,NULL,NULL,NULL),(52,NULL,16,2,1,NULL,'05-C. Asignación indirectos',0,0,NULL,NULL,NULL),(53,NULL,17,2,1,NULL,'06-A. Anteproyecto',0,0,NULL,NULL,NULL),(54,NULL,17,2,1,NULL,'06-B. Proyecto arquitectónico',0,0,NULL,NULL,NULL),(55,NULL,17,2,1,NULL,'06-C. Ingenierias',0,0,NULL,NULL,NULL),(56,NULL,17,2,1,NULL,'06-D. Especificaciones y detalles',0,0,NULL,NULL,NULL),(57,NULL,18,2,1,NULL,'07-A. Demolición',0,0,NULL,NULL,NULL),(58,NULL,18,2,1,NULL,'07-B. Subcontratista',0,0,NULL,NULL,NULL),(59,NULL,18,2,1,NULL,'07-C. Administración obra',0,0,NULL,NULL,NULL),(60,NULL,19,2,1,NULL,'08-A. Catalogo conceptos',0,0,NULL,NULL,NULL),(61,NULL,19,2,1,NULL,'08-B. Supervisión',0,0,NULL,NULL,NULL),(62,NULL,21,2,1,NULL,'10-A. Estudio ambiental',0,0,NULL,NULL,NULL),(63,NULL,21,2,1,NULL,'10-B. SP luz',0,0,NULL,NULL,NULL),(64,NULL,21,2,1,NULL,'10-C. Otros',0,0,NULL,NULL,NULL),(65,NULL,23,3,1,NULL,'01-A. Factibilidad / Normatividad',0,0,NULL,NULL,NULL),(66,NULL,23,3,1,NULL,'01-B. Revisión fiscal',0,0,NULL,NULL,NULL),(67,NULL,23,3,1,NULL,'01-C. Revisión financiera',0,0,NULL,NULL,NULL),(68,NULL,23,3,1,NULL,'01-D. Revisión legal',0,0,NULL,NULL,NULL),(69,NULL,23,3,1,NULL,'01-E. Compra',0,0,NULL,NULL,NULL),(70,NULL,24,3,1,NULL,'02-A. Pago derechos hacienda',0,0,NULL,NULL,NULL),(71,NULL,24,3,1,NULL,'02-B. Pago notario',0,0,NULL,NULL,NULL),(72,NULL,24,3,1,NULL,'02-C. Pago escritura',0,0,NULL,NULL,NULL),(73,NULL,24,3,1,NULL,'02-D. Pago comisión vendedor',0,0,NULL,NULL,NULL),(74,NULL,25,3,1,NULL,'03-A. Pago derechos',0,0,NULL,NULL,NULL),(75,NULL,25,3,1,NULL,'03-B. Gestoría',0,0,NULL,NULL,NULL),(76,NULL,25,3,1,NULL,'03-C. Factibilidad',0,0,NULL,NULL,NULL),(77,NULL,25,3,1,NULL,'03-D. Regimen Condominio',0,0,NULL,NULL,NULL),(78,NULL,25,3,1,NULL,'03-E. Asesoria Fiscal / Legal',0,0,NULL,NULL,NULL),(79,NULL,26,3,1,NULL,'04-A. Comisiones',0,0,NULL,NULL,NULL),(80,NULL,26,3,1,NULL,'04-B. Gastos indirectos ventas',0,0,NULL,NULL,NULL),(81,NULL,26,3,1,NULL,'04-C. Promoción / Publicidad',0,0,NULL,NULL,NULL),(82,NULL,27,3,1,NULL,'05-A. Crédito / Cobranza',0,0,NULL,NULL,NULL),(83,NULL,27,3,1,NULL,'05-B. Ventas',0,0,NULL,NULL,NULL),(84,NULL,27,3,1,NULL,'05-C. Asignación indirectos',0,0,NULL,NULL,NULL),(85,NULL,28,3,1,NULL,'06-A. Anteproyecto',0,0,NULL,NULL,NULL),(86,NULL,28,3,1,NULL,'06-B. Proyecto arquitectónico',0,0,NULL,NULL,NULL),(87,NULL,28,3,1,NULL,'06-C. Ingenierias',0,0,NULL,NULL,NULL),(88,NULL,28,3,1,NULL,'06-D. Especificaciones y detalles',0,0,NULL,NULL,NULL),(89,NULL,29,3,1,NULL,'07-A. Demolición',0,0,NULL,NULL,NULL),(90,NULL,29,3,1,NULL,'07-B. Subcontratista',0,0,NULL,NULL,NULL),(91,NULL,29,3,1,NULL,'07-C. Administración obra',0,0,NULL,NULL,NULL),(92,NULL,30,3,1,NULL,'08-A. Catalogo conceptos',0,0,NULL,NULL,NULL),(93,NULL,30,3,1,NULL,'08-B. Supervisión',0,0,NULL,NULL,NULL),(94,NULL,32,3,1,NULL,'10-A. Estudio ambiental',0,0,NULL,NULL,NULL),(95,NULL,32,3,1,NULL,'10-B. SP luz',0,0,NULL,NULL,NULL),(96,NULL,32,3,1,NULL,'10-C. Otros',0,0,NULL,NULL,NULL),(97,NULL,35,7,1,NULL,'01-A. Factibilidad / Normatividad',0,0,NULL,NULL,NULL),(98,NULL,35,7,1,NULL,'01-B. Revisión fiscal',0,0,NULL,NULL,NULL),(99,NULL,35,7,1,NULL,'01-C. Revisión financiera',0,0,NULL,NULL,NULL),(100,NULL,35,7,1,NULL,'01-D. Revisión legal',0,0,NULL,NULL,NULL),(101,NULL,35,7,1,NULL,'01-E. Compra',0,0,NULL,NULL,NULL),(102,NULL,36,7,1,NULL,'02-A. Pago derechos hacienda',0,0,NULL,NULL,NULL),(103,NULL,36,7,1,NULL,'02-B. Pago notario',0,0,NULL,NULL,NULL),(104,NULL,36,7,1,NULL,'02-C. Pago escritura',0,0,NULL,NULL,NULL),(105,NULL,36,7,1,NULL,'02-D. Pago comisión vendedor',0,0,NULL,NULL,NULL),(106,NULL,37,7,1,NULL,'03-A. Pago derechos',0,0,NULL,NULL,NULL),(107,NULL,37,7,1,NULL,'03-B. Gestoría',0,0,NULL,NULL,NULL),(108,NULL,37,7,1,NULL,'03-C. Factibilidad',0,0,NULL,NULL,NULL),(109,NULL,37,7,1,NULL,'03-D. Regimen Condominio',0,0,NULL,NULL,NULL),(110,NULL,37,7,1,NULL,'03-E. Asesoria Fiscal / Legal',0,0,NULL,NULL,NULL),(111,NULL,38,7,1,NULL,'04-A. Comisiones',0,0,NULL,NULL,NULL),(112,NULL,38,7,1,NULL,'04-B. Gastos indirectos ventas',0,0,NULL,NULL,NULL),(113,NULL,38,7,1,NULL,'04-C. Promoción / Publicidad',0,0,NULL,NULL,NULL),(114,NULL,39,7,1,NULL,'05-A. Crédito / Cobranza',0,0,NULL,NULL,NULL),(115,NULL,39,7,1,NULL,'05-B. Ventas',0,0,NULL,NULL,NULL),(116,NULL,39,7,1,NULL,'05-C. Asignación indirectos',0,0,NULL,NULL,NULL),(117,NULL,40,7,1,NULL,'06-A. Anteproyecto',0,0,NULL,NULL,NULL),(118,NULL,40,7,1,NULL,'06-B. Proyecto arquitectónico',0,0,NULL,NULL,NULL),(119,NULL,40,7,1,NULL,'06-C. Ingenierias',0,0,NULL,NULL,NULL),(120,NULL,40,7,1,NULL,'06-D. Especificaciones y detalles',0,0,NULL,NULL,NULL),(121,NULL,41,7,1,13,'07-A. Demolición',660335.2,0,'2004-09-20','2005-01-15','2005-01-15'),(122,121,41,7,1,13,'07-B. Subcontratista',19083665.4,0,'2005-01-17','2006-01-17',NULL),(123,122,41,7,1,13,'07-C. Administración obra',2456076.8,0,'2005-03-01','2005-12-06',NULL),(124,NULL,42,7,1,NULL,'08-A. Catalogo conceptos',0,0,NULL,NULL,NULL),(125,NULL,42,7,1,NULL,'08-B. Supervisión',0,0,NULL,NULL,NULL),(126,NULL,44,7,1,NULL,'10-A. Estudio ambiental',0,0,NULL,NULL,NULL),(127,NULL,44,7,1,NULL,'10-B. SP luz',0,0,NULL,NULL,NULL),(128,NULL,44,7,1,NULL,'10-C. Otros',0,0,NULL,NULL,NULL);
UNLOCK TABLES;
/*!40000 ALTER TABLE `projectTask` ENABLE KEYS */;

--
-- Table structure for table `projectTaskHelper`
--

DROP TABLE IF EXISTS `projectTaskHelper`;
CREATE TABLE `projectTaskHelper` (
  `idProjectTask` int(11) NOT NULL auto_increment,
  `idProjectActivity` int(11) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`idProjectTask`),
  KEY `FK_projectActivityHelper1` (`idProjectActivity`),
  CONSTRAINT `FK_projectActivityHelper1` FOREIGN KEY (`idProjectActivity`) REFERENCES `projectActivityHelper` (`idProjectActivity`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `projectTaskHelper`
--


/*!40000 ALTER TABLE `projectTaskHelper` DISABLE KEYS */;
LOCK TABLES `projectTaskHelper` WRITE;
INSERT INTO `projectTaskHelper` (`idProjectTask`, `idProjectActivity`, `name`) VALUES (1,1,'01-A. Factibilidad / Normatividad'),(2,1,'01-B. Revisión fiscal'),(3,1,'01-C. Revisión financiera'),(4,1,'01-D. Revisión legal'),(5,1,'01-E. Compra'),(6,2,'02-A. Pago derechos hacienda'),(7,2,'02-B. Pago notario'),(8,2,'02-C. Pago escritura'),(9,2,'02-D. Pago comisión vendedor'),(10,3,'03-A. Pago derechos'),(11,3,'03-B. Gestoría'),(12,3,'03-C. Factibilidad'),(13,3,'03-D. Regimen Condominio'),(14,3,'03-E. Asesoria Fiscal / Legal'),(15,4,'04-A. Comisiones'),(16,4,'04-B. Gastos indirectos ventas'),(17,4,'04-C. Promoción / Publicidad'),(18,5,'05-A. Crédito / Cobranza'),(19,5,'05-B. Ventas'),(20,5,'05-C. Asignación indirectos'),(21,6,'06-A. Anteproyecto'),(22,6,'06-B. Proyecto arquitectónico'),(23,6,'06-C. Ingenierias'),(24,6,'06-D. Especificaciones y detalles'),(25,7,'07-A. Demolición'),(26,7,'07-B. Subcontratista'),(27,7,'07-C. Administración obra'),(28,8,'08-A. Catalogo conceptos'),(29,8,'08-B. Supervisión'),(30,10,'10-A. Estudio ambiental'),(31,10,'10-B. SP luz'),(32,10,'10-C. Otros');
UNLOCK TABLES;
/*!40000 ALTER TABLE `projectTaskHelper` ENABLE KEYS */;

--
-- Table structure for table `provider`
--

DROP TABLE IF EXISTS `provider`;
CREATE TABLE `provider` (
  `idProvider` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`idProvider`),
  UNIQUE KEY `PROV_unique` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `provider`
--


/*!40000 ALTER TABLE `provider` DISABLE KEYS */;
LOCK TABLES `provider` WRITE;
INSERT INTO `provider` (`idProvider`, `name`) VALUES (4,'Administradora Higuera y Sanchez SA de CV'),(3,'Equilibrio Urbano SA de CV'),(2,'Inicio'),(1,'WRW');
UNLOCK TABLES;
/*!40000 ALTER TABLE `provider` ENABLE KEYS */;

--
-- Table structure for table `providerData`
--

DROP TABLE IF EXISTS `providerData`;
CREATE TABLE `providerData` (
  `idProvider` int(11) NOT NULL default '0',
  `documentNumber` varchar(255) default NULL,
  `address` varchar(255) default NULL,
  `address1` varchar(255) default NULL,
  `address2` varchar(255) default NULL,
  `city` varchar(255) default NULL,
  `state` varchar(255) default NULL,
  `postalCode` varchar(255) default NULL,
  `phone1` varchar(255) default NULL,
  `phone2` varchar(255) default NULL,
  `phone3` varchar(255) default NULL,
  `email` varchar(255) default NULL,
  UNIQUE KEY `PROVD_unique` (`idProvider`),
  CONSTRAINT `FK_provider1` FOREIGN KEY (`idProvider`) REFERENCES `provider` (`idProvider`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `providerData`
--


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

--
-- Table structure for table `salesClient`
--

DROP TABLE IF EXISTS `salesClient`;
CREATE TABLE `salesClient` (
  `idSalesClient` int(11) NOT NULL auto_increment,
  `idEmployee` int(11) NOT NULL default '0',
  `dateRegistration` datetime NOT NULL default '0000-00-00 00:00:00',
  `nameFirst` varchar(255) NOT NULL default '',
  `nameFirst1` varchar(255) NOT NULL default '',
  `nameLast` varchar(255) NOT NULL default '',
  `nameLast1` varchar(255) NOT NULL default '',
  `documentNumber` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`idSalesClient`),
  KEY `FK_employee6` (`idEmployee`),
  CONSTRAINT `FK_employee6` FOREIGN KEY (`idEmployee`) REFERENCES `employee` (`idEmployee`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `salesClient`
--


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

--
-- Table structure for table `salesClientData`
--

DROP TABLE IF EXISTS `salesClientData`;
CREATE TABLE `salesClientData` (
  `idSalesClient` int(11) NOT NULL default '0',
  `idSalesContactMedia` int(11) default NULL,
  `idSalesContact` int(11) default NULL,
  `address` varchar(255) NOT NULL default '',
  `address1` varchar(255) NOT NULL default '',
  `address2` varchar(255) NOT NULL default '',
  `city` varchar(255) NOT NULL default '',
  `state` varchar(255) NOT NULL default '',
  `postalCode` varchar(255) NOT NULL default '',
  `phone1` varchar(255) NOT NULL default '',
  `phone2` varchar(255) NOT NULL default '',
  `phone3` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  KEY `FK_salesClient1` (`idSalesClient`),
  KEY `FK_salesContact2` (`idSalesContact`),
  KEY `FK_salesContactMedia2` (`idSalesContactMedia`),
  CONSTRAINT `FK_salesContactMedia2` FOREIGN KEY (`idSalesContactMedia`) REFERENCES `salesContactMedia` (`idSalesContactMedia`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `FK_salesClient1` FOREIGN KEY (`idSalesClient`) REFERENCES `salesClient` (`idSalesClient`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_salesContact2` FOREIGN KEY (`idSalesContact`) REFERENCES `salesContact` (`idSalesContact`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `salesClientData`
--


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

--
-- Table structure for table `salesClientState`
--

DROP TABLE IF EXISTS `salesClientState`;
CREATE TABLE `salesClientState` (
  `idSalesClientState` int(11) NOT NULL auto_increment,
  `name` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`idSalesClientState`),
  KEY `SLS_CS_name` (`name`,`idSalesClientState`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `salesClientState`
--


/*!40000 ALTER TABLE `salesClientState` DISABLE KEYS */;
LOCK TABLES `salesClientState` WRITE;
INSERT INTO `salesClientState` (`idSalesClientState`, `name`) VALUES (20,'Apartado'),(30,'Cliente'),(40,'Escriturado'),(10,'Pendiente'),(1000,'Prospecto vencido'),(999,'Rechazo');
UNLOCK TABLES;
/*!40000 ALTER TABLE `salesClientState` ENABLE KEYS */;

--
-- Table structure for table `salesClientUnit`
--

DROP TABLE IF EXISTS `salesClientUnit`;
CREATE TABLE `salesClientUnit` (
  `idSalesClientUnit` int(11) NOT NULL auto_increment,
  `idSalesClient` int(11) NOT NULL default '0',
  `idSalesUnit` int(11) NOT NULL default '0',
  `idEmployee` int(11) NOT NULL default '0',
  `idSalesPaymentPlan` int(11) default NULL,
  `idSalesClientState` int(11) NOT NULL default '0',
  `idSalesContact` int(11) default NULL,
  `idSalesContactMedia` int(11) default NULL,
  `idProject` int(11) default NULL,
  `dateRegistration` datetime NOT NULL default '0000-00-00 00:00:00',
  `sellPrice` double NOT NULL default '0',
  PRIMARY KEY  (`idSalesClientUnit`),
  KEY `FK_employee7` (`idEmployee`),
  KEY `FK_project13` (`idProject`),
  KEY `FK_salesClient2` (`idSalesClient`),
  KEY `FK_salesClientState1` (`idSalesClientState`),
  KEY `FK_salesContact1` (`idSalesContact`),
  KEY `FK_salesContactMedia1` (`idSalesContactMedia`),
  KEY `FK_salesPaymentPlan1` (`idSalesPaymentPlan`),
  KEY `FK_salesUnit1` (`idSalesUnit`),
  CONSTRAINT `FK_salesUnit1` FOREIGN KEY (`idSalesUnit`) REFERENCES `salesUnit` (`idSalesUnit`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_employee7` FOREIGN KEY (`idEmployee`) REFERENCES `employee` (`idEmployee`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_project13` FOREIGN KEY (`idProject`) REFERENCES `project` (`idProject`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `FK_salesClient2` FOREIGN KEY (`idSalesClient`) REFERENCES `salesClient` (`idSalesClient`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_salesClientState1` FOREIGN KEY (`idSalesClientState`) REFERENCES `salesClientState` (`idSalesClientState`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_salesContact1` FOREIGN KEY (`idSalesContact`) REFERENCES `salesContact` (`idSalesContact`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `FK_salesContactMedia1` FOREIGN KEY (`idSalesContactMedia`) REFERENCES `salesContactMedia` (`idSalesContactMedia`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `FK_salesPaymentPlan1` FOREIGN KEY (`idSalesPaymentPlan`) REFERENCES `salesPaymentPlan` (`idSalesPaymentPlan`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `salesClientUnit`
--


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

--
-- Table structure for table `salesClientUnitReject`
--

DROP TABLE IF EXISTS `salesClientUnitReject`;
CREATE TABLE `salesClientUnitReject` (
  `idSalesClientUnitReject` int(11) NOT NULL auto_increment,
  `idSalesClient` int(11) NOT NULL default '0',
  `idSalesClientUnit` int(11) NOT NULL default '0',
  `idSalesRejectOption` int(11) NOT NULL default '0',
  `date_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `description` text NOT NULL,
  PRIMARY KEY  (`idSalesClientUnitReject`),
  KEY `FK_salesClientUnit1` (`idSalesClientUnit`),
  KEY `FK_salesClinet3` (`idSalesClient`),
  KEY `FK_salesRejectOption1` (`idSalesRejectOption`),
  CONSTRAINT `FK_salesRejectOption1` FOREIGN KEY (`idSalesRejectOption`) REFERENCES `salesRejectOption` (`idSalesRejectOption`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_salesClientUnit1` FOREIGN KEY (`idSalesClientUnit`) REFERENCES `salesClientUnit` (`idSalesClientUnit`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_salesClinet3` FOREIGN KEY (`idSalesClient`) REFERENCES `salesClient` (`idSalesClient`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `salesClientUnitReject`
--


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

--
-- Table structure for table `salesContact`
--

DROP TABLE IF EXISTS `salesContact`;
CREATE TABLE `salesContact` (
  `idSalesContact` int(11) NOT NULL auto_increment,
  `idProject` int(11) default NULL,
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`idSalesContact`),
  KEY `FK_project5` (`idProject`),
  CONSTRAINT `FK_project5` FOREIGN KEY (`idProject`) REFERENCES `project` (`idProject`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `salesContact`
--


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

--
-- Table structure for table `salesContactMedia`
--

DROP TABLE IF EXISTS `salesContactMedia`;
CREATE TABLE `salesContactMedia` (
  `idSalesContactMedia` int(11) NOT NULL auto_increment,
  `idProject` int(11) default NULL,
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`idSalesContactMedia`),
  KEY `FK_project6` (`idProject`),
  CONSTRAINT `FK_project6` FOREIGN KEY (`idProject`) REFERENCES `project` (`idProject`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `salesContactMedia`
--


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

--
-- Table structure for table `salesPaymentPlan`
--

DROP TABLE IF EXISTS `salesPaymentPlan`;
CREATE TABLE `salesPaymentPlan` (
  `idSalesPaymentPlan` int(11) NOT NULL auto_increment,
  `idSalesPaymentPlanType` int(11) NOT NULL default '0',
  `idProject` int(11) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  PRIMARY KEY  (`idSalesPaymentPlan`),
  KEY `FK_project4` (`idProject`),
  KEY `FK_salesPaymentPlanType1` (`idSalesPaymentPlanType`),
  CONSTRAINT `FK_salesPaymentPlanType1` FOREIGN KEY (`idSalesPaymentPlanType`) REFERENCES `salesPaymentPlanType` (`idSalesPaymentPlanType`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_project4` FOREIGN KEY (`idProject`) REFERENCES `project` (`idProject`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `salesPaymentPlan`
--


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

--
-- Table structure for table `salesPaymentPlanType`
--

DROP TABLE IF EXISTS `salesPaymentPlanType`;
CREATE TABLE `salesPaymentPlanType` (
  `idSalesPaymentPlanType` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`idSalesPaymentPlanType`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `salesPaymentPlanType`
--


/*!40000 ALTER TABLE `salesPaymentPlanType` DISABLE KEYS */;
LOCK TABLES `salesPaymentPlanType` WRITE;
INSERT INTO `salesPaymentPlanType` (`idSalesPaymentPlanType`, `name`) VALUES (1,'Contado'),(2,'Financiamiento'),(3,'Credito Hipotecario');
UNLOCK TABLES;
/*!40000 ALTER TABLE `salesPaymentPlanType` ENABLE KEYS */;

--
-- Table structure for table `salesRejectOption`
--

DROP TABLE IF EXISTS `salesRejectOption`;
CREATE TABLE `salesRejectOption` (
  `idSalesRejectOption` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`idSalesRejectOption`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `salesRejectOption`
--


/*!40000 ALTER TABLE `salesRejectOption` DISABLE KEYS */;
LOCK TABLES `salesRejectOption` WRITE;
INSERT INTO `salesRejectOption` (`idSalesRejectOption`, `name`) VALUES (1,'Precio'),(2,'Ingresos'),(3,'Ubicacion'),(4,'Credito rechazado'),(5,'Preferencia estatica'),(6,'Fecha de entrega'),(7,'Dimensiones'),(8,'Areas comunes'),(9,'Acabados'),(10,'Otros');
UNLOCK TABLES;
/*!40000 ALTER TABLE `salesRejectOption` ENABLE KEYS */;

--
-- Table structure for table `salesUnit`
--

DROP TABLE IF EXISTS `salesUnit`;
CREATE TABLE `salesUnit` (
  `idSalesUnit` int(11) NOT NULL auto_increment,
  `idProject` int(11) NOT NULL default '0',
  `idSalesUnitType` int(11) NOT NULL default '0',
  `idSalesUnitState` int(11) NOT NULL default '0',
  `idCurrency` int(11) NOT NULL default '0',
  `number` varchar(255) NOT NULL default '',
  `measureUnit` varchar(255) NOT NULL default '',
  `quantity` double NOT NULL default '0',
  `priceUnitary` double NOT NULL default '0',
  `price` double NOT NULL default '0',
  PRIMARY KEY  (`idSalesUnit`),
  KEY `FK_currency2` (`idCurrency`),
  KEY `FK_project3` (`idProject`),
  KEY `FK_salesUnitState1` (`idSalesUnitState`),
  KEY `FK_salesUnitType1` (`idSalesUnitType`),
  CONSTRAINT `FK_salesUnitType1` FOREIGN KEY (`idSalesUnitType`) REFERENCES `salesUnitType` (`idSalesUnitType`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_currency2` FOREIGN KEY (`idCurrency`) REFERENCES `currency` (`idCurrency`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_project3` FOREIGN KEY (`idProject`) REFERENCES `project` (`idProject`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_salesUnitState1` FOREIGN KEY (`idSalesUnitState`) REFERENCES `salesUnitState` (`idSalesUnitState`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `salesUnit`
--


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

--
-- Table structure for table `salesUnit1`
--

DROP TABLE IF EXISTS `salesUnit1`;
CREATE TABLE `salesUnit1` (
  `idSalesUnit` int(11) NOT NULL default '0',
  `floor` varchar(255) default NULL,
  `rooms` varchar(255) default NULL,
  `bathRooms` varchar(255) default NULL,
  `studio` varchar(255) default NULL,
  PRIMARY KEY  (`idSalesUnit`),
  CONSTRAINT `FK_salesUnit2` FOREIGN KEY (`idSalesUnit`) REFERENCES `salesUnit` (`idSalesUnit`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `salesUnit1`
--


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

--
-- Table structure for table `salesUnitState`
--

DROP TABLE IF EXISTS `salesUnitState`;
CREATE TABLE `salesUnitState` (
  `idSalesUnitState` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`idSalesUnitState`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `salesUnitState`
--


/*!40000 ALTER TABLE `salesUnitState` DISABLE KEYS */;
LOCK TABLES `salesUnitState` WRITE;
INSERT INTO `salesUnitState` (`idSalesUnitState`, `name`) VALUES (1,'Disponible'),(2,'Disponible con interesados'),(3,'Bloqueado'),(4,'Apartado'),(5,'Vendido');
UNLOCK TABLES;
/*!40000 ALTER TABLE `salesUnitState` ENABLE KEYS */;

--
-- Table structure for table `salesUnitType`
--

DROP TABLE IF EXISTS `salesUnitType`;
CREATE TABLE `salesUnitType` (
  `idSalesUnitType` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`idSalesUnitType`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `salesUnitType`
--


/*!40000 ALTER TABLE `salesUnitType` DISABLE KEYS */;
LOCK TABLES `salesUnitType` WRITE;
INSERT INTO `salesUnitType` (`idSalesUnitType`, `name`) VALUES (1,'Unidad estándar');
UNLOCK TABLES;
/*!40000 ALTER TABLE `salesUnitType` ENABLE KEYS */;

--
-- Table structure for table `salesUnitType_FD`
--

DROP TABLE IF EXISTS `salesUnitType_FD`;
CREATE TABLE `salesUnitType_FD` (
  `idSalesUnitType_FD` int(11) NOT NULL auto_increment,
  `idSalesUnitType` int(11) NOT NULL default '0',
  `idFieldType` int(11) NOT NULL default '0',
  `fieldName` varchar(255) NOT NULL default '',
  `isObligatory` char(1) NOT NULL default 'N',
  `showInList` char(1) NOT NULL default 'N',
  PRIMARY KEY  (`idSalesUnitType_FD`),
  KEY `SUT_FD_idSalesUnitType` (`idSalesUnitType`),
  KEY `FK_fieldType1` (`idFieldType`),
  CONSTRAINT `FK_fieldType1` FOREIGN KEY (`idFieldType`) REFERENCES `fieldType` (`idFieldType`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_salesUnitType2` FOREIGN KEY (`idSalesUnitType`) REFERENCES `salesUnitType` (`idSalesUnitType`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `salesUnitType_FD`
--


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

--
-- Table structure for table `serverFile`
--

DROP TABLE IF EXISTS `serverFile`;
CREATE TABLE `serverFile` (
  `idServerFile` int(11) NOT NULL auto_increment,
  `idServerFileType` int(11) NOT NULL default '0',
  `idEmployee` int(11) default NULL,
  `dateCreated` datetime NOT NULL default '0000-00-00 00:00:00',
  `displayName` varchar(255) NOT NULL default '',
  `clientFileName` varchar(255) NOT NULL default '',
  `contentType` varchar(64) NOT NULL default '',
  `fileSize` int(11) NOT NULL default '0',
  `serverFileName` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`idServerFile`),
  UNIQUE KEY `SERV_FL_unique` (`idServerFileType`,`displayName`),
  KEY `SERV_FL_idServerFileType` (`idServerFileType`),
  KEY `SERV_FL_idEmployee` (`idEmployee`),
  CONSTRAINT `FK_serverFileType1` FOREIGN KEY (`idServerFileType`) REFERENCES `serverFileType` (`idServerFileType`),
  CONSTRAINT `FK_employee4` FOREIGN KEY (`idEmployee`) REFERENCES `employee` (`idEmployee`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `serverFile`
--


/*!40000 ALTER TABLE `serverFile` DISABLE KEYS */;
LOCK TABLES `serverFile` WRITE;
INSERT INTO `serverFile` (`idServerFile`, `idServerFileType`, `idEmployee`, `dateCreated`, `displayName`, `clientFileName`, `contentType`, `fileSize`, `serverFileName`) VALUES (1,1,1,'2005-02-01 17:14:22','HyS.small.gif','HyS.small.gif','image/gif',969,'1/HyS.small.gif');
UNLOCK TABLES;
/*!40000 ALTER TABLE `serverFile` ENABLE KEYS */;

--
-- Table structure for table `serverFileType`
--

DROP TABLE IF EXISTS `serverFileType`;
CREATE TABLE `serverFileType` (
  `idServerFileType` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`idServerFileType`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `serverFileType`
--


/*!40000 ALTER TABLE `serverFileType` DISABLE KEYS */;
LOCK TABLES `serverFileType` WRITE;
INSERT INTO `serverFileType` (`idServerFileType`, `name`) VALUES (1,'Logo de la empresa'),(2,'Logo del proyecto'),(3,'Imagen de proyecto'),(4,'Imagen de la factura');
UNLOCK TABLES;
/*!40000 ALTER TABLE `serverFileType` ENABLE KEYS */;

--
-- Table structure for table `systemModule`
--

DROP TABLE IF EXISTS `systemModule`;
CREATE TABLE `systemModule` (
  `idSystemModule` int(11) NOT NULL auto_increment,
  `idParent` int(11) NOT NULL default '0',
  `location` varchar(255) NOT NULL default '',
  `showInMenu` char(1) NOT NULL default '6',
  `displayName` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`idSystemModule`),
  UNIQUE KEY `SMOD_unique` (`idParent`,`location`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `systemModule`
--


/*!40000 ALTER TABLE `systemModule` DISABLE KEYS */;
LOCK TABLES `systemModule` WRITE;
INSERT INTO `systemModule` (`idSystemModule`, `idParent`, `location`, `showInMenu`, `displayName`) VALUES (100,0,'sales','Y','Ventas'),(101,100,'sales/salesClient','Y','Prospectos/Clientes'),(102,100,'sales/salesUnit','Y','Unidades'),(103,100,'sales/salesPaymentPlan','Y','Planes de pago'),(104,100,'sales/salesContact','Y','Contactos'),(105,100,'sales/salesContactMedia','Y','Medios de contacto'),(106,100,'sales/salesClientState','Y','Estados de cliente'),(107,100,'sales/salesUnitState','Y','Estdos de unidad'),(108,100,'sales/salesRejectOption','Y','Opciones de rechazo'),(109,100,'sales/salesPaymentPlanType','Y','Planes de pago'),(110,100,'sales/salesUnitType','Y','Tipos de las unidades'),(111,100,'sales/salesUnitType_FD','Y','Unit type field definition'),(200,0,'humanResources','Y','Recursos humanos'),(201,200,'humanResources/employee','Y','Empleados'),(203,200,'humanResources/company','Y','Empresas'),(204,200,'humanResources/companyDepartment','Y','Areas'),(300,0,'administration','Y','Administracion'),(301,300,'administration/project','Y','Proyectos'),(302,300,'administration/projectActivity','Y','Actividades'),(303,300,'administration/projectTask','Y','Tareas'),(304,300,'administration/projectParcel','Y','Partida'),(305,300,'administration/projectSubParcel','Y','Sub-partida'),(306,300,'administration/paymentRequest','Y','Requisiciones de pago'),(307,300,'administration/paymentRequestDetails','N','Detalles de requisicion'),(308,300,'administration/paymentRequestStateHistory','N','Estsus de requsicion'),(310,300,'administration/provider','Y','Provedores'),(1000,0,'configuration','Y','Configuracion'),(1010,1000,'configuration/accessProfile','Y','Perfiles de acceso'),(1020,1000,'configuration/systemModule','Y','Modulos de sistema'),(1030,1000,'configuration/employeeType','Y','Tipos de empleados'),(1031,1000,'configuration/paymentType','Y','Tipos de pago'),(1032,1000,'configuration/paymentRequestState','Y','Estados de requisicion de pago'),(1040,1000,'configuration/currency','Y','Monedas'),(1050,1000,'configuration/currencyChangeRate','Y','Valores de cambio');
UNLOCK TABLES;
/*!40000 ALTER TABLE `systemModule` ENABLE KEYS */;

/*!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 */;