--
-- Host: localhost    Database: facturas_javi
-- ------------------------------------------------------


--
-- Table structure for table `ip_client_custom`
--

CREATE TABLE `ip_client_custom` (
  `client_custom_id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  PRIMARY KEY (`client_custom_id`),
  KEY `client_id` (`client_id`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_client_custom`
--

INSERT INTO `ip_client_custom` VALUES (1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7),(8,8),(9,9),(10,10),(11,11),(12,12),(13,13),(14,14),(15,15),(16,16),(17,17),(18,18),(19,19),(20,20),(21,21),(22,22),(23,23),(24,24),(25,25),(26,26),(27,27);

--
-- Table structure for table `ip_client_notes`
--

CREATE TABLE `ip_client_notes` (
  `client_note_id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `client_note_date` date NOT NULL,
  `client_note` longtext NOT NULL,
  PRIMARY KEY (`client_note_id`),
  KEY `client_id` (`client_id`,`client_note_date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_client_notes`
--


--
-- Table structure for table `ip_clients`
--

CREATE TABLE `ip_clients` (
  `client_id` int(11) NOT NULL AUTO_INCREMENT,
  `client_date_created` datetime NOT NULL,
  `client_date_modified` datetime NOT NULL,
  `client_name` varchar(100) NOT NULL,
  `client_address_1` varchar(100) DEFAULT '',
  `client_address_2` varchar(100) DEFAULT '',
  `client_city` varchar(45) DEFAULT '',
  `client_state` varchar(35) DEFAULT '',
  `client_zip` varchar(15) DEFAULT '',
  `client_country` varchar(35) DEFAULT '',
  `client_phone` varchar(20) DEFAULT '',
  `client_fax` varchar(20) DEFAULT '',
  `client_mobile` varchar(20) DEFAULT '',
  `client_email` varchar(100) DEFAULT '',
  `client_web` varchar(100) DEFAULT '',
  `client_vat_id` varchar(100) NOT NULL DEFAULT '',
  `client_tax_code` varchar(100) NOT NULL DEFAULT '',
  `client_active` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`client_id`),
  KEY `client_active` (`client_active`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_clients`
--

INSERT INTO `ip_clients` VALUES (1,'2015-06-08 18:13:50','2015-06-09 14:59:54','Scrivas','1450 Madruga Ave','Suite 405','Coral Gables','FL','33134','US','','','','fmendoza@scrivas.com','www.scrivas.com','','',1),(2,'2015-06-08 18:26:04','2015-06-08 18:26:04','Casto Ocando','','','','','','','305-776-4698','','','casto.ocando@gmail.com','','','',1),(3,'2015-06-08 18:30:16','2015-06-08 18:30:16','Zanmi Beni','','','','','','','','','','lnuell@friendsofzb.org','friendsofzb.org','','',1),(4,'2015-06-08 18:40:15','2015-06-08 18:40:15','CEI Miami','','','','','','','','','','albmul@bellsouth.net','www.ceimiami.org','','',1),(5,'2015-06-17 17:10:06','2015-06-17 17:12:16','Moto Studio','Bruce Mcquiston','','','','','','','','','mctwisted@msn.com','moto-studio.com','','',1),(6,'2015-06-18 13:43:31','2016-05-06 19:34:26','VSBrooks','255 Alhambra Circle','Suite 835','Coral Gables','FL','33134','US','305.443.3500','','','rcanales@vsbrooks.com','www.vsbrooks.com','','',1),(7,'2015-06-19 20:08:11','2015-06-19 20:08:11','Doink Design','4908B SW 72ND Avenue','','Miami','FL','33155','US','305-529-0121','','','charlie@doinkdesign.com','www.doinkdesign.com','','',1),(8,'2015-06-29 18:32:17','2015-06-29 18:32:17','Empire Electric','1041 SW 67th Avenue','','West Miami','FL','33144','US','(305) 264-9982','(305) 264-1974','','fernando@empireelectric.net','http://www.empireelectric.net/','','',1),(9,'2015-06-29 18:34:15','2015-06-29 18:34:25','Empire Safety','1041 SW 67th Ave','','West Miami','FL','33144','US','(305) 264-9982','(305) 264-1974','','fernando@empireelectric.net','http://www.empirefiresafety.net/','','',1),(10,'2015-06-29 19:02:04','2015-06-30 13:06:32','George Santa Marina','','','','','','US','','','','gsantasr@mindspring.com','','','',1),(11,'2015-06-30 15:59:33','2015-06-30 15:59:33','CV Credit Inc','1101 Brickell Ave','Suite 704 South Tower','Miami','Florida','33131','','(305) 792 - 2366','','','lgsegura@cvcredit.com','','','',1),(12,'2015-06-30 16:12:46','2015-06-30 16:12:46','VS BRooks','','','','','','','','','','dtimiraos@vsbrooks.com','','','',1),(13,'2015-07-02 20:15:07','2015-07-02 20:15:07','Rincon Beach Resort','','','','','','','','','','sales@rinconbeach.com','www.rinconbeach.com','','',1),(14,'2015-08-07 20:43:51','2015-08-07 20:43:51','St. Dominic Priory','','','','','','','','','','jenniewblock@gmail.com','','','',1),(15,'2015-09-15 14:50:16','2015-09-15 14:50:16','Miami Schools College Fair','','','','','','','','','','mpatterson@carrollton.org','','','',1),(16,'2015-09-22 17:32:53','2015-09-22 17:32:53','South Miami CritiCare, Inc.','','','','','','','','','','davet@smcriticare.com','','','',1),(17,'2015-09-29 14:50:12','2015-09-29 14:50:12','Tommy de Armas','','','','','','','','','','tommy@greenheads.com','','','',1),(18,'2015-10-26 22:52:59','2015-10-26 22:52:59','Rovira Biscuits','','','','','','','','','','tommy@greenheads.com','','','',1),(19,'2015-11-18 23:27:16','2015-11-18 23:27:16','Univision','8551 NW 30th Terrace','','Doral','FL','33122','US','','','','scolon@univision.net','','','',1),(20,'2015-11-18 23:50:49','2015-11-18 23:50:49','Backroom','','','','','','','','','','javi@backroompr.com','','','',1),(21,'2015-11-24 13:10:16','2015-11-24 13:10:16','Gonzalez and Sons','','','','','','','','','','Maylin.G@gonzalezandsons.net','','','',1),(22,'2015-12-01 17:16:53','2015-12-01 17:16:53','Steam Sauna Experts','','','','','','','','','','anju888511@gmail.com','','','',1),(23,'2015-12-04 20:49:48','2015-12-04 20:49:48','Tailer Senior','','','','','','','','','','tailer@tailermadedesigns.com','','','',1),(24,'2016-04-11 10:40:39','2016-04-11 10:40:39','Miami Yacht Club','','','','','','','','','','jamescravenmyc@gmail.com','','','',1),(25,'2016-05-02 20:18:04','2016-05-02 20:18:04','Daniel Timiraos','','','','','','','','','','danieltimiraos@gmail.com','','','',1),(26,'2016-08-22 10:05:03','2016-08-22 10:12:44','Palacios','','','','','','','','','','yjorge@palaciospr.com','','','',1),(27,'2017-09-02 00:11:43','2017-09-02 00:11:43','FIDA Convention','','','','','','','(242) 602-5336','','','erik@keenimedia.com','','','',1);

--
-- Table structure for table `ip_custom_fields`
--

CREATE TABLE `ip_custom_fields` (
  `custom_field_id` int(11) NOT NULL AUTO_INCREMENT,
  `custom_field_table` varchar(35) NOT NULL,
  `custom_field_label` varchar(64) NOT NULL,
  `custom_field_column` varchar(64) NOT NULL,
  PRIMARY KEY (`custom_field_id`),
  KEY `custom_field_table` (`custom_field_table`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_custom_fields`
--


--
-- Table structure for table `ip_email_templates`
--

CREATE TABLE `ip_email_templates` (
  `email_template_id` int(11) NOT NULL AUTO_INCREMENT,
  `email_template_title` varchar(255) NOT NULL,
  `email_template_type` varchar(255) DEFAULT NULL,
  `email_template_body` longtext NOT NULL,
  `email_template_subject` varchar(255) DEFAULT NULL,
  `email_template_from_name` varchar(255) DEFAULT NULL,
  `email_template_from_email` varchar(255) DEFAULT NULL,
  `email_template_cc` varchar(255) DEFAULT NULL,
  `email_template_bcc` varchar(255) DEFAULT NULL,
  `email_template_pdf_template` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`email_template_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_email_templates`
--


--
-- Table structure for table `ip_families`
--

CREATE TABLE `ip_families` (
  `family_id` int(11) NOT NULL AUTO_INCREMENT,
  `family_name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`family_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_families`
--


--
-- Table structure for table `ip_import_details`
--

CREATE TABLE `ip_import_details` (
  `import_detail_id` int(11) NOT NULL AUTO_INCREMENT,
  `import_id` int(11) NOT NULL,
  `import_lang_key` varchar(35) NOT NULL,
  `import_table_name` varchar(35) NOT NULL,
  `import_record_id` int(11) NOT NULL,
  PRIMARY KEY (`import_detail_id`),
  KEY `import_id` (`import_id`,`import_record_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_import_details`
--


--
-- Table structure for table `ip_imports`
--

CREATE TABLE `ip_imports` (
  `import_id` int(11) NOT NULL AUTO_INCREMENT,
  `import_date` datetime NOT NULL,
  PRIMARY KEY (`import_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_imports`
--


--
-- Table structure for table `ip_invoice_amounts`
--

CREATE TABLE `ip_invoice_amounts` (
  `invoice_amount_id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) NOT NULL,
  `invoice_sign` enum('1','-1') NOT NULL DEFAULT '1',
  `invoice_item_subtotal` decimal(20,2) DEFAULT NULL,
  `invoice_item_tax_total` decimal(20,2) DEFAULT NULL,
  `invoice_tax_total` decimal(20,2) DEFAULT NULL,
  `invoice_total` decimal(20,2) DEFAULT NULL,
  `invoice_paid` decimal(20,2) DEFAULT NULL,
  `invoice_balance` decimal(20,2) DEFAULT NULL,
  PRIMARY KEY (`invoice_amount_id`),
  KEY `invoice_id` (`invoice_id`),
  KEY `invoice_paid` (`invoice_paid`,`invoice_balance`)
) ENGINE=MyISAM AUTO_INCREMENT=48 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_invoice_amounts`
--

INSERT INTO `ip_invoice_amounts` VALUES (1,1,'1',180.00,0.00,0.00,180.00,0.00,180.00),(5,5,'1',250.00,0.00,0.00,250.00,0.00,250.00),(3,3,'1',210.00,0.00,0.00,210.00,210.00,0.00),(8,8,'1',2040.00,0.00,0.00,2040.00,2040.00,0.00),(7,7,'1',425.00,0.00,0.00,425.00,425.00,0.00),(14,14,'1',400.00,0.00,0.00,400.00,400.00,0.00),(10,10,'1',3479.95,0.00,0.00,3479.95,3479.95,0.00),(12,12,'1',255.00,0.00,0.00,255.00,255.00,0.00),(13,13,'1',970.00,0.00,0.00,970.00,970.00,0.00),(21,21,'1',180.00,0.00,0.00,180.00,180.00,0.00),(16,16,'1',95.00,0.00,0.00,95.00,95.00,0.00),(17,17,'1',175.00,0.00,0.00,175.00,175.00,0.00),(18,18,'1',175.00,0.00,0.00,175.00,175.00,0.00),(19,19,'1',175.00,0.00,0.00,175.00,175.00,0.00),(20,20,'1',175.00,0.00,0.00,175.00,175.00,0.00),(22,22,'1',1000.00,0.00,0.00,1000.00,1000.00,0.00),(25,25,'1',400.00,0.00,0.00,400.00,400.00,0.00),(26,26,'1',400.00,0.00,0.00,400.00,400.00,0.00),(27,27,'1',720.00,0.00,0.00,720.00,720.00,0.00),(28,28,'1',4200.00,0.00,0.00,2100.00,2100.00,0.00),(29,29,'1',1400.00,0.00,0.00,1400.00,1400.00,0.00),(31,31,'1',175.00,0.00,0.00,175.00,175.00,0.00),(32,32,'1',175.00,0.00,0.00,175.00,175.00,0.00),(33,33,'1',175.00,0.00,0.00,175.00,175.00,0.00),(34,34,'1',400.00,0.00,0.00,400.00,0.00,400.00),(35,35,'1',400.00,0.00,0.00,400.00,0.00,400.00),(36,36,'1',400.00,0.00,0.00,400.00,0.00,400.00),(37,37,'1',400.00,0.00,0.00,400.00,0.00,400.00),(38,38,'1',400.00,0.00,0.00,400.00,0.00,400.00),(39,39,'1',2000.00,0.00,0.00,2000.00,0.00,2000.00),(40,40,'1',525.00,0.00,0.00,525.00,0.00,525.00),(41,41,'1',1040.00,0.00,0.00,1040.00,0.00,1040.00),(42,42,'1',1530.00,0.00,0.00,1530.00,0.00,1530.00),(43,43,'1',1620.00,0.00,0.00,1620.00,0.00,1620.00),(44,44,'1',340.00,0.00,0.00,340.00,0.00,340.00),(45,45,'1',1579.70,0.00,0.00,1579.70,0.00,1579.70),(46,46,'1',740.00,0.00,0.00,740.00,0.00,740.00),(47,47,'1',3610.00,0.00,0.00,3610.00,0.00,3610.00);

--
-- Table structure for table `ip_invoice_custom`
--

CREATE TABLE `ip_invoice_custom` (
  `invoice_custom_id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) NOT NULL,
  PRIMARY KEY (`invoice_custom_id`),
  KEY `invoice_id` (`invoice_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_invoice_custom`
--


--
-- Table structure for table `ip_invoice_groups`
--

CREATE TABLE `ip_invoice_groups` (
  `invoice_group_id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_group_name` varchar(50) NOT NULL DEFAULT '',
  `invoice_group_identifier_format` varchar(255) NOT NULL,
  `invoice_group_next_id` int(11) NOT NULL,
  `invoice_group_left_pad` int(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`invoice_group_id`),
  KEY `invoice_group_next_id` (`invoice_group_next_id`),
  KEY `invoice_group_left_pad` (`invoice_group_left_pad`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_invoice_groups`
--

INSERT INTO `ip_invoice_groups` VALUES (3,'Invoice Default','{{{id}}}',2178,0),(4,'Quote Default','QUO{{{id}}}',607,0);

--
-- Table structure for table `ip_invoice_item_amounts`
--

CREATE TABLE `ip_invoice_item_amounts` (
  `item_amount_id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `item_subtotal` decimal(20,2) DEFAULT NULL,
  `item_tax_total` decimal(20,2) DEFAULT NULL,
  `item_discount` decimal(20,2) NOT NULL DEFAULT '0.00',
  `item_total` decimal(20,2) DEFAULT NULL,
  PRIMARY KEY (`item_amount_id`),
  KEY `item_id` (`item_id`)
) ENGINE=MyISAM AUTO_INCREMENT=69 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_invoice_item_amounts`
--

INSERT INTO `ip_invoice_item_amounts` VALUES (1,1,180.00,0.00,0.00,180.00),(5,5,250.00,0.00,0.00,250.00),(3,3,210.00,0.00,0.00,210.00),(8,8,2040.00,0.00,0.00,2040.00),(7,7,425.00,0.00,0.00,425.00),(9,9,1400.00,0.00,0.00,1400.00),(10,10,840.00,0.00,0.00,840.00),(11,11,840.00,0.00,0.00,840.00),(12,12,49.95,0.00,0.00,49.95),(13,13,255.00,0.00,0.00,255.00),(14,14,120.00,0.00,0.00,120.00),(15,15,240.00,0.00,0.00,240.00),(16,16,280.00,0.00,0.00,280.00),(17,17,160.00,0.00,0.00,160.00),(18,18,85.00,0.00,0.00,85.00),(19,19,85.00,0.00,0.00,85.00),(20,20,350.00,0.00,0.00,350.00),(21,21,400.00,0.00,0.00,400.00),(28,28,180.00,0.00,0.00,180.00),(23,23,95.00,0.00,0.00,95.00),(24,24,175.00,0.00,0.00,175.00),(25,25,175.00,0.00,0.00,175.00),(26,26,175.00,0.00,0.00,175.00),(27,27,175.00,0.00,0.00,175.00),(29,29,680.00,0.00,0.00,680.00),(30,30,320.00,0.00,0.00,320.00),(32,32,400.00,0.00,0.00,400.00),(33,33,400.00,0.00,0.00,400.00),(34,34,580.00,0.00,0.00,580.00),(36,36,140.00,0.00,0.00,140.00),(37,37,4200.00,0.00,0.00,4200.00),(38,38,385.00,0.00,0.00,385.00),(39,39,890.00,0.00,0.00,890.00),(40,40,125.00,0.00,0.00,125.00),(41,41,0.00,0.00,0.00,0.00),(42,42,175.00,0.00,0.00,175.00),(43,43,175.00,0.00,0.00,175.00),(44,44,175.00,0.00,0.00,175.00),(45,45,400.00,0.00,0.00,400.00),(46,46,400.00,0.00,0.00,400.00),(47,47,400.00,0.00,0.00,400.00),(48,48,400.00,0.00,0.00,400.00),(49,49,400.00,0.00,0.00,400.00),(50,50,400.00,0.00,0.00,400.00),(51,51,400.00,0.00,0.00,400.00),(52,52,400.00,0.00,0.00,400.00),(53,53,400.00,0.00,0.00,400.00),(54,54,400.00,0.00,0.00,400.00),(55,55,175.00,0.00,0.00,175.00),(56,56,175.00,0.00,0.00,175.00),(57,57,175.00,0.00,0.00,175.00),(58,58,1040.00,0.00,0.00,1040.00),(59,59,1500.00,0.00,0.00,1500.00),(60,60,30.00,0.00,0.00,30.00),(61,61,1500.00,0.00,0.00,1500.00),(62,62,120.00,0.00,0.00,120.00),(63,63,340.00,0.00,0.00,340.00),(64,64,1490.00,0.00,0.00,1490.00),(65,65,89.70,0.00,0.00,89.70),(66,66,740.00,0.00,0.00,740.00),(67,67,3250.00,0.00,0.00,3250.00),(68,68,360.00,0.00,0.00,360.00);

--
-- Table structure for table `ip_invoice_items`
--

CREATE TABLE `ip_invoice_items` (
  `item_id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) NOT NULL,
  `item_tax_rate_id` int(11) NOT NULL DEFAULT '0',
  `item_date_added` date NOT NULL,
  `item_name` varchar(100) NOT NULL,
  `item_description` longtext NOT NULL,
  `item_quantity` decimal(10,2) NOT NULL,
  `item_price` decimal(10,2) NOT NULL,
  `item_discount_amount` decimal(20,2) NOT NULL DEFAULT '0.00',
  `item_order` int(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`item_id`),
  KEY `invoice_id` (`invoice_id`,`item_tax_rate_id`,`item_date_added`,`item_order`)
) ENGINE=MyISAM AUTO_INCREMENT=69 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_invoice_items`
--

INSERT INTO `ip_invoice_items` VALUES (1,1,0,'2015-06-17','Web programming','Created 2 new photo galleries and photoshop work.',1.00,180.00,0.00,1),(5,5,0,'2015-06-30','Mena work','',1.00,250.00,0.00,1),(3,3,0,'2015-06-30','HTML Email Newsletter','',1.00,210.00,0.00,1),(8,8,0,'2015-07-08','Make website Responsive','',1.00,2040.00,0.00,1),(7,7,0,'2015-07-02','Cambios a Website','5 horas de trabajo',1.00,425.00,0.00,1),(9,10,0,'2015-09-18','Crear diseno y concepto de website','HTML5/CSS/PHP/Javascript\nCrear las secciones necesarias para el \"Front End\" del website',1.00,1400.00,0.00,1),(10,10,0,'2015-09-18','Crear formularios para llenar','MySQL Databases\nRespuestas por emails a cliente y al usuario\n',1.00,840.00,0.00,2),(11,10,0,'2015-09-18','CMS Backend','Crear sitio administrativo para hacer busqueda de archivos del database\nSe podra imprimir la informacion al igual que se puede \"download\" en formas excel o PDF.\nVisualizacion de archivos ',1.00,840.00,0.00,3),(12,10,0,'2015-09-18','Hosting - Mensual','Costo mensual para  mantener el website en el servidor.',1.00,49.95,0.00,4),(13,12,0,'2015-09-25','South Miami CritiCare Website Consulting','',3.00,85.00,0.00,1),(14,13,0,'2015-10-12','Wordpress Form','',1.00,120.00,0.00,1),(15,13,0,'2015-10-12','PHP Programming','Customize Wordpress Form for download file dependent on input',1.00,240.00,0.00,2),(16,13,0,'2015-10-12','Excel spreadsheet','Create Wordpress plugin to download Excel spreadsheet',1.00,280.00,0.00,3),(17,13,0,'2015-10-12','Install Wordpress','Copy and recreate wordpress website for  Spanish version',1.00,160.00,0.00,4),(18,13,0,'2015-10-12','Spanish Excel','Create Wordpress plugin to download Excel spreadsheet for Spanish version',1.00,85.00,0.00,5),(19,13,0,'2015-10-12','Spanish PHP Programming','Customize Wordpress Form for download file dependent on input for Spanish version',1.00,85.00,0.00,6),(20,10,0,'2015-10-14','Programacion especial','Verificar si los estados son el mismo para Registered Agent',1.00,350.00,0.00,5),(21,14,0,'2015-10-26','Monthly Fee','',1.00,400.00,0.00,1),(28,21,0,'2015-11-02','Website Changes','Added Gallery and changes',1.00,180.00,0.00,1),(29,22,0,'2015-11-09','Programacion Website','Personalizar el template ',1.00,680.00,0.00,1),(23,16,0,'2015-10-26','Recaptcha para Rovira','Integrar Recaptcha de Google en los contact forms de Rovira.  Verificar el usuario con el POST request.',1.00,95.00,0.00,1),(24,17,0,'2015-10-26','Website friendsofzb.org','',1.00,175.00,0.00,1),(25,18,0,'2015-10-26','Website friendsofzb.org','',1.00,175.00,0.00,1),(26,19,0,'2015-10-26','Website friendsofzb.org','',1.00,175.00,0.00,1),(27,20,0,'2015-10-26','Website friendsofzb.org','',1.00,175.00,0.00,1),(30,22,0,'2015-11-09','Form','Crear Database\nEmail\nAdmin area para leer Database',1.00,320.00,0.00,2),(32,25,0,'2015-12-03','Monthly Fee','',1.00,400.00,0.00,1),(33,26,0,'2015-12-08','Monthly Fee','December Monthly Fee',1.00,400.00,0.00,1),(34,27,0,'2016-01-14','Interactive Map','World map\n - pop up windows on click of specific points\n- Create HTML page for map',1.00,580.00,0.00,1),(36,27,0,'2016-01-14','Pop up Projects','- Add projects to map with separate pop up windows.',1.00,140.00,0.00,2),(37,28,0,'2016-01-14','Website (50% Discount)','Includes Design/Concept/Programming:\n -  The Mass and Confession schedule\n - Programs that are offered to the parish such as CCD, Youth Group,\n     retreats, prayer groups, bible study\n -  Special events\n -  Ways to get involved\n -  How to donate\n -  Information on how to schedule a wedding, baptism etc\n - Directory and bios on parish staff and  the Dominican community\n -  Information on the Dominican Order\n- Priest/Pastor Column\n- Bi-Lingual\n- Create Backend CMS (Content Manager) to add/modify/delete information',1.00,4200.00,0.00,1),(38,29,0,'2016-01-22','Moving News Banner','Create front page News area\nNews CMS(Add/Modify/Delete Information)',1.00,385.00,0.00,1),(39,29,0,'2016-01-22','Employees','Employee Directory\nEmployee CMS(Add/Modify/Delete Information)\nAccess to personal CMS for employees - HOME ADDRESS, HOME PHONE NO., CELL PHONE NO., EMAIL ADDRESS, EMERGENCY CONTACT NAME, EMERGENCY CONTACT PHONE NO.\nAdministrator CMS for Employees\nEmail alert on changes\n\n',1.00,890.00,0.00,2),(40,29,0,'2016-01-22','Company Benefits Section','Add Company Benefits Section to website\n',1.00,125.00,0.00,3),(41,29,0,'2016-01-22','Website modifications','Modify Contact Us information',1.00,0.00,0.00,4),(42,31,0,'2016-03-01','Website friendsofzb.org','',1.00,175.00,0.00,1),(43,32,0,'2016-03-01','Website friendsofzb.org','',1.00,175.00,0.00,1),(44,33,0,'2016-03-01','Website friendsofzb.org','',1.00,175.00,0.00,1),(45,34,0,'2016-05-06','Monthly Fee','Januery Monthly Fee',1.00,400.00,0.00,1),(46,35,0,'2016-05-06','Monthly Fee','February Monthly Fee',1.00,400.00,0.00,1),(47,36,0,'2016-05-06','Monthly Fee','March Monthly Fee',1.00,400.00,0.00,1),(48,37,0,'2016-05-06','Monthly Fee','April Monthly Fee',1.00,400.00,0.00,1),(49,38,0,'2016-05-06','Monthly Fee','May Monthly Fee',1.00,400.00,0.00,1),(50,39,0,'2016-05-10','Monthly Fee (January)','January Monthly Fee',1.00,400.00,0.00,1),(51,39,0,'2016-05-10','Monthly Fee (February)','February Monthly Fee',1.00,400.00,0.00,2),(52,39,0,'2016-05-10','Monthly Fee (March)','March Monthly Fee',1.00,400.00,0.00,3),(53,39,0,'2016-05-10','Monthly Fee (April)','April Monthly Fee',1.00,400.00,0.00,4),(54,39,0,'2016-05-10','Monthly Fee (May)','May Monthly Fee',1.00,400.00,0.00,5),(55,40,0,'2016-05-12','Website maintenance friendsofzb.org','March ',1.00,175.00,0.00,1),(56,40,0,'2016-06-22','Website maintenance friendsofzb.org','April',1.00,175.00,0.00,2),(57,40,0,'2016-06-22','Website maintenance friendsofzb.org','May',1.00,175.00,0.00,3),(58,41,0,'2016-11-10','Carusel de fotos interactivo','- Crear carousel de fotos que sea interactivo\n- Cada foto sera linlkeada para ver las fotos en grande\n- Crear database\n- Crear CMS (content manager) de fotos',1.00,1040.00,0.00,1),(59,42,0,'2016-11-16','Website y Cuestionario','- Crear cuestionario con diseño entregado\n- Crear Database que se pueda examinar y filtrar\n- Personalizar web template',1.00,1500.00,0.00,1),(60,42,0,'2016-11-16','Mensualidad (primer mes)','- Incluye hosting mensual',1.00,30.00,0.00,2),(61,43,0,'2016-11-16','Website y Cuestionario','- Crear cuestionario con diseño entregado\n- Crear Database que se pueda examinar y filtrar\n- Personalizar web template',1.00,1500.00,0.00,1),(62,43,0,'2016-11-16','Mensualidad (primer mes)','- Incluye hosting mensual',4.00,30.00,0.00,2),(63,44,0,'2017-01-04','CMS y cambios a site de lifesavingrules.info','',1.00,340.00,0.00,1),(64,45,0,'2017-06-07','Website Heineken','Website de survey de Heineken',1.00,1490.00,0.00,1),(65,45,0,'2017-06-07','Hosting','6 meses de hosting',6.00,14.95,0.00,2),(66,46,0,'2017-11-03','CenPos object integration','-Integrate cenpos payment object on wordpress website',1.00,740.00,0.00,1),(67,47,0,'2017-12-18','Heineken Accident Report Database and Website','',1.00,3250.00,0.00,1),(68,47,0,'2017-12-18','Lifesaving Rules 1 year hosting','',12.00,30.00,0.00,2);

--
-- Table structure for table `ip_invoice_tax_rates`
--

CREATE TABLE `ip_invoice_tax_rates` (
  `invoice_tax_rate_id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) NOT NULL,
  `tax_rate_id` int(11) NOT NULL,
  `include_item_tax` int(1) NOT NULL DEFAULT '0',
  `invoice_tax_rate_amount` decimal(10,2) NOT NULL,
  PRIMARY KEY (`invoice_tax_rate_id`),
  KEY `invoice_id` (`invoice_id`,`tax_rate_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_invoice_tax_rates`
--


--
-- Table structure for table `ip_invoices_recurring`
--

CREATE TABLE `ip_invoices_recurring` (
  `invoice_recurring_id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) NOT NULL,
  `recur_start_date` date NOT NULL,
  `recur_end_date` date NOT NULL,
  `recur_frequency` char(2) NOT NULL,
  `recur_next_date` date NOT NULL,
  PRIMARY KEY (`invoice_recurring_id`),
  KEY `invoice_id` (`invoice_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_invoices_recurring`
--

INSERT INTO `ip_invoices_recurring` VALUES (1,14,'2015-11-26','0000-00-00','1M','2015-11-26');

--
-- Table structure for table `ip_item_lookups`
--

CREATE TABLE `ip_item_lookups` (
  `item_lookup_id` int(11) NOT NULL AUTO_INCREMENT,
  `item_name` varchar(100) NOT NULL DEFAULT '',
  `item_description` longtext NOT NULL,
  `item_price` decimal(10,2) NOT NULL,
  PRIMARY KEY (`item_lookup_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_item_lookups`
--


--
-- Table structure for table `ip_merchant_responses`
--

CREATE TABLE `ip_merchant_responses` (
  `merchant_response_id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) NOT NULL,
  `merchant_response_date` date NOT NULL,
  `merchant_response_driver` varchar(35) NOT NULL,
  `merchant_response` varchar(255) NOT NULL,
  `merchant_response_reference` varchar(255) NOT NULL,
  PRIMARY KEY (`merchant_response_id`),
  KEY `merchant_response_date` (`merchant_response_date`),
  KEY `invoice_id` (`invoice_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_merchant_responses`
--


--
-- Table structure for table `ip_payment_custom`
--

CREATE TABLE `ip_payment_custom` (
  `payment_custom_id` int(11) NOT NULL AUTO_INCREMENT,
  `payment_id` int(11) NOT NULL,
  PRIMARY KEY (`payment_custom_id`),
  KEY `payment_id` (`payment_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_payment_custom`
--


--
-- Table structure for table `ip_payment_methods`
--

CREATE TABLE `ip_payment_methods` (
  `payment_method_id` int(11) NOT NULL AUTO_INCREMENT,
  `payment_method_name` varchar(35) NOT NULL,
  PRIMARY KEY (`payment_method_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_payment_methods`
--


--
-- Table structure for table `ip_payments`
--

CREATE TABLE `ip_payments` (
  `payment_id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) NOT NULL,
  `payment_method_id` int(11) NOT NULL DEFAULT '0',
  `payment_date` date NOT NULL,
  `payment_amount` decimal(10,2) NOT NULL,
  `payment_note` longtext NOT NULL,
  PRIMARY KEY (`payment_id`),
  KEY `invoice_id` (`invoice_id`),
  KEY `payment_method_id` (`payment_method_id`),
  KEY `payment_amount` (`payment_amount`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_payments`
--

INSERT INTO `ip_payments` VALUES (1,8,0,'2015-09-15',2040.00,''),(2,7,0,'2015-09-15',425.00,''),(3,3,0,'2015-09-15',210.00,''),(4,12,0,'2015-10-15',255.00,''),(5,10,0,'2015-10-26',3479.95,''),(6,20,0,'2015-11-02',175.00,''),(7,19,0,'2015-11-02',175.00,''),(8,18,0,'2015-11-02',175.00,''),(9,17,0,'2015-11-02',175.00,''),(10,13,0,'2015-11-13',970.00,''),(11,16,0,'2015-11-24',95.00,''),(12,14,0,'2016-01-13',400.00,''),(13,21,0,'2016-01-13',180.00,''),(14,22,0,'2016-01-13',1000.00,''),(15,25,0,'2016-01-13',400.00,''),(16,26,0,'2016-01-13',400.00,''),(17,27,0,'2016-03-01',720.00,''),(18,29,0,'2016-03-01',1400.00,''),(19,32,0,'2016-03-17',175.00,''),(20,31,0,'2016-03-17',175.00,''),(21,33,0,'2016-03-17',175.00,''),(22,28,0,'2016-05-06',2100.00,'');

--
-- Table structure for table `ip_products`
--

CREATE TABLE `ip_products` (
  `product_id` int(11) NOT NULL AUTO_INCREMENT,
  `family_id` int(11) NOT NULL,
  `product_sku` varchar(15) NOT NULL,
  `product_name` varchar(50) NOT NULL,
  `product_description` longtext NOT NULL,
  `product_price` float(10,2) NOT NULL,
  `purchase_price` float(10,2) NOT NULL,
  `tax_rate_id` int(11) NOT NULL,
  PRIMARY KEY (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_products`
--


--
-- Table structure for table `ip_projects`
--

CREATE TABLE `ip_projects` (
  `project_id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `project_name` varchar(150) NOT NULL,
  PRIMARY KEY (`project_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_projects`
--


--
-- Table structure for table `ip_quote_amounts`
--

CREATE TABLE `ip_quote_amounts` (
  `quote_amount_id` int(11) NOT NULL AUTO_INCREMENT,
  `quote_id` int(11) NOT NULL,
  `quote_item_subtotal` decimal(20,2) DEFAULT NULL,
  `quote_item_tax_total` decimal(20,2) DEFAULT NULL,
  `quote_tax_total` decimal(20,2) DEFAULT NULL,
  `quote_total` decimal(20,2) DEFAULT NULL,
  PRIMARY KEY (`quote_amount_id`),
  KEY `quote_id` (`quote_id`)
) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_quote_amounts`
--

INSERT INTO `ip_quote_amounts` VALUES (1,1,3410.00,0.00,0.00,3410.00),(2,2,9680.00,0.00,0.00,9680.00),(3,3,3230.00,0.00,0.00,3230.00),(4,4,175.00,0.00,0.00,175.00),(5,5,125.00,0.00,0.00,125.00),(6,6,8450.00,0.00,0.00,8450.00),(7,7,320.00,0.00,0.00,320.00),(8,8,250.00,0.00,0.00,250.00),(9,9,2550.00,0.00,0.00,2550.00),(10,10,210.00,0.00,0.00,210.00),(11,11,240.00,0.00,0.00,240.00),(12,12,240.00,0.00,0.00,240.00),(13,13,3129.95,0.00,0.00,3129.95),(14,14,4200.00,0.00,0.00,2100.00),(15,15,39.95,0.00,0.00,19.97),(16,16,2400.00,0.00,0.00,1600.08),(17,17,1620.00,0.00,0.00,1620.00),(18,18,1800.00,0.00,0.00,1800.00),(19,19,1000.00,0.00,0.00,1000.00),(20,20,530.00,0.00,0.00,530.00),(21,21,95.00,0.00,0.00,95.00),(22,22,1.00,0.00,0.00,1.00),(23,23,1.00,0.00,0.00,1.00),(24,24,1400.00,0.00,0.00,1400.00),(25,25,100.00,0.00,0.00,100.00),(26,26,3400.00,0.00,0.00,2600.00),(27,27,609.95,0.00,0.00,609.95),(28,28,1200.00,0.00,0.00,1200.00),(29,29,2100.00,0.00,0.00,2100.00),(31,31,240.00,0.00,0.00,240.00),(32,32,360.00,0.00,0.00,360.00),(33,33,4.00,0.00,0.00,4.00),(34,34,200.00,0.00,0.00,200.00),(35,35,1040.00,0.00,0.00,1040.00),(36,36,680.00,0.00,0.00,680.00),(37,37,1620.00,0.00,0.00,1620.00),(38,38,740.00,0.00,0.00,740.00),(39,39,3610.00,0.00,0.00,3610.00);

--
-- Table structure for table `ip_quote_custom`
--

CREATE TABLE `ip_quote_custom` (
  `quote_custom_id` int(11) NOT NULL AUTO_INCREMENT,
  `quote_id` int(11) NOT NULL,
  PRIMARY KEY (`quote_custom_id`),
  KEY `quote_id` (`quote_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_quote_custom`
--


--
-- Table structure for table `ip_quote_item_amounts`
--

CREATE TABLE `ip_quote_item_amounts` (
  `item_amount_id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `item_subtotal` decimal(20,2) DEFAULT NULL,
  `item_tax_total` decimal(20,2) DEFAULT NULL,
  `item_discount` decimal(20,2) NOT NULL DEFAULT '0.00',
  `item_total` decimal(20,2) DEFAULT NULL,
  PRIMARY KEY (`item_amount_id`),
  KEY `item_id` (`item_id`)
) ENGINE=MyISAM AUTO_INCREMENT=57 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_quote_item_amounts`
--

INSERT INTO `ip_quote_item_amounts` VALUES (1,1,3000.00,0.00,0.00,3000.00),(2,2,410.00,0.00,0.00,410.00),(3,3,11480.00,0.00,1800.00,9680.00),(4,4,2710.00,0.00,0.00,2710.00),(5,5,520.00,0.00,0.00,520.00),(6,6,175.00,0.00,0.00,175.00),(9,9,8450.00,0.00,0.00,8450.00),(8,8,125.00,0.00,0.00,125.00),(10,10,320.00,0.00,0.00,320.00),(11,11,250.00,0.00,0.00,250.00),(12,12,1800.00,0.00,0.00,1800.00),(13,13,210.00,0.00,0.00,210.00),(14,14,240.00,0.00,0.00,240.00),(15,15,240.00,0.00,0.00,240.00),(16,16,1400.00,0.00,0.00,1400.00),(17,17,840.00,0.00,0.00,840.00),(18,18,840.00,0.00,0.00,840.00),(19,19,49.95,0.00,0.00,49.95),(20,20,750.00,0.00,0.00,750.00),(21,21,4200.00,0.00,0.00,4200.00),(22,22,39.95,0.00,0.00,39.95),(23,23,2400.00,0.00,0.00,2400.00),(24,24,1620.00,0.00,0.00,1620.00),(25,25,1800.00,0.00,0.00,1800.00),(26,26,680.00,0.00,0.00,680.00),(27,27,320.00,0.00,0.00,320.00),(28,28,190.00,0.00,0.00,190.00),(29,29,340.00,0.00,0.00,340.00),(30,30,95.00,0.00,0.00,95.00),(31,31,1.00,0.00,0.00,1.00),(32,32,1.00,0.00,0.00,1.00),(33,33,385.00,0.00,0.00,385.00),(34,34,890.00,0.00,0.00,890.00),(35,35,125.00,0.00,0.00,125.00),(36,36,0.00,0.00,0.00,0.00),(37,37,100.00,0.00,0.00,100.00),(38,38,3400.00,0.00,0.00,3400.00),(39,39,580.00,0.00,0.00,580.00),(40,40,29.95,0.00,0.00,29.95),(41,41,440.00,0.00,0.00,440.00),(42,42,580.00,0.00,0.00,580.00),(43,43,180.00,0.00,0.00,180.00),(44,44,2100.00,0.00,0.00,2100.00),(45,45,240.00,0.00,0.00,240.00),(46,46,360.00,0.00,0.00,360.00),(47,47,4.00,0.00,0.00,4.00),(48,48,200.00,0.00,0.00,200.00),(49,49,1040.00,0.00,0.00,1040.00),(50,50,650.00,0.00,0.00,650.00),(51,51,30.00,0.00,0.00,30.00),(52,52,1500.00,0.00,0.00,1500.00),(53,53,120.00,0.00,0.00,120.00),(54,54,740.00,0.00,0.00,740.00),(55,55,3250.00,0.00,0.00,3250.00),(56,56,360.00,0.00,0.00,360.00);

--
-- Table structure for table `ip_quote_items`
--

CREATE TABLE `ip_quote_items` (
  `item_id` int(11) NOT NULL AUTO_INCREMENT,
  `quote_id` int(11) NOT NULL,
  `item_tax_rate_id` int(11) NOT NULL,
  `item_date_added` date NOT NULL,
  `item_name` varchar(100) NOT NULL,
  `item_description` longtext NOT NULL,
  `item_quantity` decimal(10,2) NOT NULL,
  `item_price` decimal(10,2) NOT NULL,
  `item_discount_amount` decimal(20,2) NOT NULL DEFAULT '0.00',
  `item_order` int(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`item_id`),
  KEY `quote_id` (`quote_id`,`item_date_added`,`item_order`),
  KEY `item_tax_rate_id` (`item_tax_rate_id`)
) ENGINE=MyISAM AUTO_INCREMENT=57 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_quote_items`
--

INSERT INTO `ip_quote_items` VALUES (1,1,0,'2015-06-08','Initial Set Up Fee','Programming(HTML5/CSS/JQuery/Ajax/PHP)\nFront End\nCMS - Custom Content Management System for all sections',1.00,3000.00,0.00,1),(2,1,0,'2015-06-08','Monthly Fee','',1.00,410.00,0.00,2),(3,2,0,'2015-06-08','Develop New Website','Programming(HTML5/CSS/JQuery/Ajax/PHP)\nFront End\nCMS - Custom Content Management System for all sections',1.00,11480.00,1800.00,1),(4,3,0,'2015-06-08','Initial Set Up Fee','Wordpress setup and customization',1.00,2710.00,0.00,1),(5,3,0,'2015-06-08','Monthly Fee','Incluye:\nProgramacion y configuracion de tema wordpress\nServicio Tecnico\nManejo de backend de servidor\n\"Post\" 3 a 4 articulos semanales enviados por el cliente',1.00,520.00,0.00,2),(6,4,0,'2015-06-08','Monthly Fee','',1.00,175.00,0.00,1),(8,5,0,'2015-06-08','Monthly Fee','',1.00,125.00,0.00,1),(9,6,0,'2015-06-09','Creacion de Wordpress Site y personalizacion del site','',1.00,8450.00,0.00,1),(10,7,0,'2015-06-09','Monthly Fee','2nd year of contract',1.00,320.00,0.00,1),(11,8,0,'2015-06-09','Monthly Fee','3rd year of contract',1.00,250.00,0.00,1),(12,9,0,'2015-06-18','CarePlus Wordpress Website','Programming - Custom theme ',1.00,1800.00,0.00,1),(13,10,0,'2015-06-19','Programming(HTML5/CSS/JQuery/Ajax)','CV Newsletter HTML',1.00,210.00,0.00,1),(14,11,0,'2015-06-29','Add CenPos Payment Object','',1.00,240.00,0.00,1),(15,12,0,'2015-06-29','Add CenPos Payment Object','',1.00,240.00,0.00,1),(16,13,0,'2015-06-30','Crear diseno y concepto de website','HTML5/CSS/PHP/Javascript\nCrear las secciones necesarias para el \"Front End\" del website',1.00,1400.00,0.00,1),(17,13,0,'2015-06-30','Crear formularios para llenar','MySQL Databases\nRespuestas por emails a cliente y al usuario\n',1.00,840.00,0.00,2),(18,13,0,'2015-06-30','CMS Backend','Crear sitio administrativo para hacer busqueda de archivos del database\nSe podra imprimir la informacion al igual que se puede \"download\" en formas excel o PDF.\nVisualizacion de archivos ',1.00,840.00,0.00,3),(19,13,0,'2015-06-30','Hosting - Mensual','Costo mensual para  mantener el website en el servidor.',1.00,49.95,0.00,4),(20,9,0,'2015-07-06','Create website in second language (Spanish)','',1.00,750.00,0.00,2),(21,14,0,'2015-08-07','Website (50% Discount)','Includes Design/Concept/Programming:\n -  The Mass and Confession schedule\n - Programs that are offered to the parish such as CCD, Youth Group,\n     retreats, prayer groups, bible study\n -  Special events\n -  Ways to get involved\n -  How to donate\n -  Information on how to schedule a wedding, baptism etc\n - Directory and bios on parish staff and  the Dominican community\n -  Information on the Dominican Order\n- Priest/Pastor Column\n- Bi-Lingual\n- Create Backend CMS (Content Manager) to add/modify/delete information',1.00,4200.00,0.00,1),(22,15,0,'2015-08-07','Web Hosting - Monthly Fee (50% Discount)','',1.00,39.95,0.00,1),(23,16,0,'2015-08-11','Website','Recrear website de CEI usando Wordpress\n33% Discount',1.00,2400.00,0.00,1),(24,17,0,'2015-09-15','Website ','Design/Concept/Programming (HTML/CSS/JQuery/PHP)\n-Includes:\nHome\nStudents & Parents\nCollege Reps\nCounselors\nSponsors',1.00,1620.00,0.00,1),(25,18,0,'2015-09-22','Create Wordpress Website','Includes:\nHome\nAbout\nManagement Team\nHospitals Served\nFAQ\nCalendar\nContact Us\nBlog (Login)',1.00,1800.00,0.00,1),(26,19,0,'2015-09-29','Programacion Website','Personalizar el template ',1.00,680.00,0.00,1),(27,19,0,'2015-09-29','Form','Crear Database\nEmail\nAdmin area para leer Database',1.00,320.00,0.00,2),(28,20,0,'2015-10-08','1 Page website','HTML',1.00,190.00,0.00,1),(29,20,0,'2015-10-08','CMS ','Crear CMS para lista',1.00,340.00,0.00,2),(30,21,0,'2015-10-15','Recaptcha para Rovira','Integrar Recaptcha de Google en los contact forms de Rovira.  Verificar el usuario con el POST request.',1.00,95.00,0.00,1),(31,22,0,'2015-11-18','Sample Item','Sample Item',1.00,1.00,0.00,1),(32,23,0,'2015-11-18','1','1',1.00,1.00,0.00,1),(33,24,0,'2015-11-24','Moving News Banner','Create front page News area\nNews CMS(Add/Modify/Delete Information)',1.00,385.00,0.00,1),(34,24,0,'2015-11-24','Employees','Employee Directory\nEmployee CMS(Add/Modify/Delete Information)\nAccess to personal CMS for employees - HOME ADDRESS, HOME PHONE NO., CELL PHONE NO., EMAIL ADDRESS, EMERGENCY CONTACT NAME, EMERGENCY CONTACT PHONE NO.\nAdministrator CMS for Employees\nEmail alert on changes\n\n',1.00,890.00,0.00,2),(35,24,0,'2015-11-24','Company Benefits Section','Add Company Benefits Section to website\n',1.00,125.00,0.00,3),(36,24,0,'2015-11-24','Website modifications','Modify Contact Us information',1.00,0.00,0.00,4),(37,25,0,'2015-12-01','Web Site - Monthly Fee','Create website \nMaintain website\nMinimum 3 years (1st year at 100.00, next 2 years at 125.00)',1.00,100.00,0.00,1),(38,26,0,'2015-12-01','Web Site','Create new website - One time fee\n$800.00 Discount',1.00,3400.00,0.00,1),(39,27,0,'2015-12-04','Interactive Map','World map\n - pop up windows on click of specific points\n- Create HTML page for map',1.00,580.00,0.00,1),(40,27,0,'2015-12-04','Hosting - Monthly Fee','Monthly Fee',1.00,29.95,0.00,2),(41,28,0,'2016-04-11','Calendar','Create and customize events calendar',1.00,440.00,0.00,1),(42,28,0,'2016-04-11','Member','Create members only area',1.00,580.00,0.00,2),(43,28,0,'2016-04-11','Front page blurb','Create button/blurb/starburst for front page to highlight regatta/event/news item',1.00,180.00,0.00,3),(44,29,0,'2016-05-02','Wordpress Website ','Includes 6-7 sections/categories\nCustomize and populate website. \nPhp/HTML/CSS work/MySQL\n\nAllow 3-4 weeks after client  delivers all required materials, for completion of work.',1.00,2100.00,0.00,1),(45,31,0,'2016-05-06','Wordpress microsite modification','- Create a landing page with a \"Happy Birthday\" message using the URL of the page (e.g. http://www.careplus.com/Pedro) \n',1.00,240.00,0.00,1),(46,32,0,'2016-05-09','Wordpress work','Create form on front page for user name, later to be used as a happy birthday message',1.00,360.00,0.00,1),(47,33,0,'2016-06-24','Cuenta de email','Sistema nuevo de emails para Rincon Beach Resort.  \n$4.00 al mes por cada cuenta de email (hasta 10 emails)\n$3.50 al mes (10-20 emails)\n$3.00 al mes  (mas de 20 emails)',1.00,4.00,0.00,1),(48,34,0,'2016-08-22','Crear foto adicional para novias','- Cambiar database\n- Programacion para añadir foto',1.00,200.00,0.00,1),(49,35,0,'2016-09-01','Carusel de fotos interactivo','- Crear carousel de fotos que sea interactivo\n- Cada foto sera linlkeada para ver las fotos en grande\n- Crear database\n- Crear CMS (content manager) de fotos',1.00,1040.00,0.00,1),(50,36,0,'2016-09-26','Cuestionario','- Crear cuestionario con diseño entregado\n- Crear Database que se pueda examinar y filtrar',1.00,650.00,0.00,1),(51,36,0,'2016-09-26','Mensualidad (primer mes)','- Incluye hosting mensual',1.00,30.00,0.00,2),(52,37,0,'2016-10-25','Website y Cuestionario','- Crear cuestionario con diseño entregado\n- Crear Database que se pueda examinar y filtrar\n- Personalizar web template',1.00,1500.00,0.00,1),(53,37,0,'2016-10-25','Mensualidad (primer mes)','- Incluye hosting mensual',4.00,30.00,0.00,2),(54,38,0,'2017-09-02','CenPos object integration','-Integrate cenpos payment object on wordpress website',1.00,740.00,0.00,1),(55,39,0,'2017-12-18','Heineken Accident Report Database and Website','',1.00,3250.00,0.00,1),(56,39,0,'2017-12-18','Lifesaving Rules 1 year hosting','',12.00,30.00,0.00,2);

--
-- Table structure for table `ip_quote_tax_rates`
--

CREATE TABLE `ip_quote_tax_rates` (
  `quote_tax_rate_id` int(11) NOT NULL AUTO_INCREMENT,
  `quote_id` int(11) NOT NULL,
  `tax_rate_id` int(11) NOT NULL,
  `include_item_tax` int(1) NOT NULL DEFAULT '0',
  `quote_tax_rate_amount` decimal(10,2) NOT NULL,
  PRIMARY KEY (`quote_tax_rate_id`),
  KEY `quote_id` (`quote_id`),
  KEY `tax_rate_id` (`tax_rate_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_quote_tax_rates`
--


--
-- Table structure for table `ip_settings`
--

CREATE TABLE `ip_settings` (
  `setting_id` int(11) NOT NULL AUTO_INCREMENT,
  `setting_key` varchar(50) NOT NULL,
  `setting_value` longtext NOT NULL,
  PRIMARY KEY (`setting_id`),
  KEY `setting_key` (`setting_key`)
) ENGINE=MyISAM AUTO_INCREMENT=80 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_settings`
--

INSERT INTO `ip_settings` VALUES (19,'default_language','english'),(20,'date_format','m/d/Y'),(21,'currency_symbol','$'),(22,'currency_symbol_placement','before'),(23,'invoices_due_after','30'),(24,'quotes_expire_after','15'),(25,'default_invoice_group','3'),(26,'default_quote_group','4'),(27,'thousands_separator',','),(28,'decimal_point','.'),(29,'cron_key','95woXEl6zGgV5V9u'),(30,'tax_rate_decimal_places','2'),(31,'pdf_invoice_template','default'),(32,'pdf_invoice_template_paid','default'),(33,'pdf_invoice_template_overdue','default'),(34,'pdf_quote_template','default'),(35,'public_invoice_template','default'),(36,'public_quote_template','default'),(37,'disable_sidebar','1'),(38,'read_only_toggle','paid'),(39,'invoice_pre_password',''),(40,'quote_pre_password',''),(41,'email_pdf_attachment','1'),(42,'first_day_of_week','0'),(43,'default_country',''),(44,'default_list_limit','15'),(45,'quote_overview_period','this-month'),(46,'invoice_overview_period','this-month'),(47,'disable_quickactions','0'),(48,'custom_title',''),(49,'monospace_amounts','0'),(50,'bcc_mails_to_admin','0'),(51,'default_invoice_terms',''),(52,'invoice_default_payment_method',''),(53,'automatic_email_on_recur','0'),(54,'mark_invoices_sent_pdf','0'),(55,'email_invoice_template',''),(56,'email_invoice_template_paid',''),(57,'email_invoice_template_overdue',''),(58,'pdf_invoice_footer',''),(59,'mark_quotes_sent_pdf','0'),(60,'default_quote_notes','All quotes are subject to discussion. Allow 4-6 weeks for completion after client has given all necessary information. '),(61,'email_quote_template',''),(62,'default_invoice_tax_rate',''),(63,'default_include_item_tax',''),(64,'default_item_tax_rate',''),(65,'email_send_method','smtp'),(66,'smtp_server_address','secure.emailsrvr.com'),(67,'smtp_authentication','1'),(68,'smtp_username','javi@javierfigueroa.com'),(69,'smtp_password','L7MFEOjgv3LBy1TEMM+dJRDEkPsnu9dRupgodgXbMYKoSYDF33O9lx/JjBZ/EPDNTVipbpNHGjllZP4DjVpaqQ=='),(70,'smtp_port','465'),(71,'smtp_security','ssl'),(72,'merchant_enabled','0'),(73,'merchant_driver',''),(74,'merchant_test_mode','0'),(75,'merchant_username',''),(76,'merchant_signature',''),(77,'merchant_currency_code',''),(78,'online_payment_method',''),(79,'invoice_logo','logojavi.png');

--
-- Table structure for table `ip_tasks`
--

CREATE TABLE `ip_tasks` (
  `task_id` int(11) NOT NULL AUTO_INCREMENT,
  `project_id` int(11) NOT NULL,
  `task_name` varchar(50) NOT NULL,
  `task_description` longtext NOT NULL,
  `task_price` float(10,2) NOT NULL,
  `task_finish_date` date NOT NULL,
  `task_status` tinyint(1) NOT NULL,
  PRIMARY KEY (`task_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_tasks`
--


--
-- Table structure for table `ip_tax_rates`
--

CREATE TABLE `ip_tax_rates` (
  `tax_rate_id` int(11) NOT NULL AUTO_INCREMENT,
  `tax_rate_name` varchar(60) NOT NULL,
  `tax_rate_percent` decimal(5,2) NOT NULL,
  PRIMARY KEY (`tax_rate_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_tax_rates`
--


--
-- Table structure for table `ip_uploads`
--

CREATE TABLE `ip_uploads` (
  `upload_id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `url_key` char(32) NOT NULL,
  `file_name_original` longtext NOT NULL,
  `file_name_new` longtext NOT NULL,
  `uploaded_date` date NOT NULL,
  PRIMARY KEY (`upload_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_uploads`
--


--
-- Table structure for table `ip_user_clients`
--

CREATE TABLE `ip_user_clients` (
  `user_client_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  PRIMARY KEY (`user_client_id`),
  KEY `user_id` (`user_id`,`client_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_user_clients`
--


--
-- Table structure for table `ip_user_custom`
--

CREATE TABLE `ip_user_custom` (
  `user_custom_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`user_custom_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_user_custom`
--

INSERT INTO `ip_user_custom` VALUES (1,1);

--
-- Table structure for table `ip_versions`
--

CREATE TABLE `ip_versions` (
  `version_id` int(11) NOT NULL AUTO_INCREMENT,
  `version_date_applied` varchar(14) NOT NULL,
  `version_file` varchar(45) NOT NULL,
  `version_sql_errors` int(2) NOT NULL,
  PRIMARY KEY (`version_id`),
  KEY `version_date_applied` (`version_date_applied`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_versions`
--

INSERT INTO `ip_versions` VALUES (1,'1433786852','000_1.0.0.sql',0),(2,'1433786855','001_1.0.1.sql',0),(3,'1433786855','002_1.0.2.sql',0),(4,'1433786855','003_1.1.0.sql',0),(5,'1433786855','004_1.1.1.sql',0),(6,'1433786855','005_1.1.2.sql',0),(7,'1433786855','006_1.2.0.sql',0),(8,'1433786855','007_1.2.1.sql',0),(9,'1433786855','008_1.3.0.sql',0),(10,'1433786855','009_1.3.1.sql',0),(11,'1433786855','010_1.3.2.sql',0),(12,'1433786855','011_1.3.3.sql',0),(13,'1433786855','012_1.4.0.sql',0),(14,'1433786855','013_1.4.1.sql',0),(15,'1447890581','014_1.4.2.sql',0),(16,'1447890581','015_1.4.3.sql',0);

--
-- Dumping events for database 'facturas_javi'
--

--
-- Dumping routines for database 'facturas_javi'
--


