--
-- Host: localhost    Database: facturas
-- ------------------------------------------------------


--
-- 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=37 DEFAULT CHARSET=utf8;

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

INSERT INTO `ip_client_custom` VALUES (20,592),(3,38),(5,590),(7,316),(8,591),(9,53),(11,67),(12,93),(13,225),(15,247),(17,310),(18,383),(19,511),(22,594),(25,597),(26,598),(27,599),(31,603),(34,607),(35,256);

--
-- 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=609 DEFAULT CHARSET=utf8;

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

INSERT INTO `ip_clients` VALUES (38,'2015-06-04 00:00:00','2015-06-05 18:01:00','Bayamon Community College','PO Box 55176','','Bayamon','PR  ','00960','US','','','','saadt@baccpr.org','www.bccpr.org','','',1),(53,'2015-06-04 00:00:00','2015-06-05 18:01:46','Cap Clutch','PMB 1138','PO Box 4956','Caguas','Puerto Rico ','00726','US','','','','carmen.morales@capclutch.com','www.capclutch.com','','',1),(67,'2015-06-04 00:00:00','2015-06-05 18:04:24','Cenrealty','Karina Nazario','Calle 2 #A7','Villas de San Francisco','San Juan, PR 00927','','US','','','','nazario.karina@gmail.com','cenrealty.com','','',1),(69,'2015-06-04 00:00:00','2015-06-04 00:00:00','Christiansen and Portela','P.O. Box 192121','Hato Rey, Puuuerto RRRRico 00919-2121','','','','','','','','','','','',1),(93,'2015-06-04 00:00:00','2015-06-05 18:06:06','De la Cruz Collection','c/o    Ybett    Yanez','23 NE 41st. St.','Miami, Fla 33137','','','US','','','','mariomgonzalez@delacruzcollection.org','www.delacruzcollection.org','','',1),(225,'2015-06-04 00:00:00','2015-06-05 18:06:45','Ediciones Universal','P.O Box 450353','','Miami','Florida ','33245-0353','US','','','','jms@ediciones.com','www.ediciones.com','','',1),(247,'2015-06-04 00:00:00','2015-06-05 18:08:20','Francisco de Armas','P.O. Box 190085','','San Jua','Puerto Rico ','00919','US','','','','fdearmas@ciacpr.com','www.ciacpr.com','','',1),(256,'2015-06-04 00:00:00','2016-08-08 09:48:33','Gonzalez & Sons','P.O. Box 126370','Hialeah, Florida 33012','','','','US','','','','','','','',1),(281,'2015-06-04 00:00:00','2015-06-04 00:00:00','Inseco Inc.','P.O. Box 361598','San Juan, Puerto Rico','00936-1598','','','','','','','','','','',1),(310,'2015-06-04 00:00:00','2018-01-03 13:55:50','Libros de Barlovento','P.O. Box 17090','','Tucson','Arizona','85731-7090','US','','','','dhull@prtc.net','www.librosdebarlovento.com','','',1),(316,'2015-06-04 00:00:00','2015-06-05 18:12:53','Luis B. Gonzalez','P.O. Box 191689','','San Juan','Puerto Rico','00919-1689','US','','','','luis@lbgonzalezcpa.com','www.lbgonzalezcpa.com','','',1),(383,'2015-06-04 00:00:00','2015-06-05 18:14:12','Palacios','271 Ave. de Diego','Urb. Puerto Nuevo Att.:Maria Teresa G ','Puerto Nuevo','Puerto Rico ','00920-2203','US','','','','astrid@palaciospr.com','www.palaciospr.com','','',1),(397,'2015-06-04 00:00:00','2015-06-04 00:00:00','Plaza Provision','P.O. Box 363328','San Juan, Puerto Rico 00936-3328','','','','','','','','','','','',1),(455,'2015-06-04 00:00:00','2015-06-04 00:00:00','The Moore Space Web Site','23 NE 41 St.','Miami, Fl. 33137','','','','','','','','','','','',1),(511,'2015-06-04 00:00:00','2015-06-05 18:16:11','Tommy de Armas','P.O. Box 195201','','San Juan','Puerto Rico','00919-5201','US','','787-753-4642','','tommy@greenheads.com','','','',1),(607,'2016-07-01 14:10:30','2016-07-01 14:10:30','Friends of Zanmi Beni ','6201 Riviera Dr.','','Coral Gables','Florida','33146','US','','','','','','','',1),(603,'2015-11-23 03:55:00','2015-11-23 03:55:57','Condotte America','10790 NW 127th Street','','Medley ','Florida','33178','US','','','','','','','',1),(599,'2015-06-16 15:02:38','2015-06-16 15:02:38','District View Plaza','644 Ave. Fernandez Juncos','Suite 301','San Juan','Puerto Rico','00907','US','','','','','districtviewpr.com','','',1),(598,'2015-06-09 14:45:45','2015-06-09 14:45:45','Youth and Family Counseling','193A South Street','','Oyster Bay','New York','11771','US','','','','','','','',1),(597,'2015-06-09 14:40:48','2015-06-09 14:40:48','OMNI Realty Partners','Metro Office Park','14 Calle 2 Suite 305','Guaynabo','Puerto Rico','00968','US','','','','','','','',1),(594,'2015-06-09 14:31:39','2015-06-09 14:31:39','Atlantic Beach Hotel','One Vendig Street','Condado','San Juan','Puerto Rico','00907','US','','','','','','','',1),(591,'2015-06-05 17:08:20','2015-06-05 17:08:20','Flood Barrier, Inc.','7314 N.W. 46th Street. ','','Miami','Florida ','33166','US','','','','guy@floodbarrier.com','www.floodbarrier.com','','',1),(592,'2015-06-08 12:40:43','2015-06-16 14:41:12','Rincon Beach Resort','PO Box 1406','','Anasco','','00610','US','','','','sales@rinconbeach.com','www.rinconbeach.com','','',1),(590,'2015-06-05 15:56:01','2016-08-27 10:19:35','Acampa','','517 Calle  Andalucia','San Juan','PR','00920','US','','','','acampapr@hotmail.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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

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

INSERT INTO `ip_families` VALUES (1,'Hosting');

--
-- 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 AUTO_INCREMENT=587 DEFAULT CHARSET=utf8;

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

INSERT INTO `ip_import_details` VALUES (1,5,'clients','ip_clients',2),(2,5,'clients','ip_clients',3),(3,5,'clients','ip_clients',4),(4,5,'clients','ip_clients',5),(5,5,'clients','ip_clients',6),(6,5,'clients','ip_clients',7),(7,5,'clients','ip_clients',8),(8,5,'clients','ip_clients',9),(9,5,'clients','ip_clients',10),(10,5,'clients','ip_clients',11),(11,5,'clients','ip_clients',12),(12,5,'clients','ip_clients',13),(13,5,'clients','ip_clients',14),(14,5,'clients','ip_clients',15),(15,5,'clients','ip_clients',16),(16,5,'clients','ip_clients',17),(17,5,'clients','ip_clients',18),(18,5,'clients','ip_clients',19),(19,5,'clients','ip_clients',20),(20,5,'clients','ip_clients',21),(21,5,'clients','ip_clients',22),(22,5,'clients','ip_clients',23),(23,5,'clients','ip_clients',24),(24,5,'clients','ip_clients',25),(25,5,'clients','ip_clients',26),(26,5,'clients','ip_clients',27),(27,5,'clients','ip_clients',28),(28,5,'clients','ip_clients',29),(29,5,'clients','ip_clients',30),(30,5,'clients','ip_clients',31),(31,5,'clients','ip_clients',32),(32,5,'clients','ip_clients',33),(33,5,'clients','ip_clients',34),(34,5,'clients','ip_clients',35),(35,5,'clients','ip_clients',36),(36,5,'clients','ip_clients',37),(37,5,'clients','ip_clients',38),(38,5,'clients','ip_clients',39),(39,5,'clients','ip_clients',40),(40,5,'clients','ip_clients',41),(41,5,'clients','ip_clients',42),(42,5,'clients','ip_clients',43),(43,5,'clients','ip_clients',44),(44,5,'clients','ip_clients',45),(45,5,'clients','ip_clients',46),(46,5,'clients','ip_clients',47),(47,5,'clients','ip_clients',48),(48,5,'clients','ip_clients',49),(49,5,'clients','ip_clients',50),(50,5,'clients','ip_clients',51),(51,5,'clients','ip_clients',52),(52,5,'clients','ip_clients',53),(53,5,'clients','ip_clients',54),(54,5,'clients','ip_clients',55),(55,5,'clients','ip_clients',56),(56,5,'clients','ip_clients',57),(57,5,'clients','ip_clients',58),(58,5,'clients','ip_clients',59),(59,5,'clients','ip_clients',60),(60,5,'clients','ip_clients',61),(61,5,'clients','ip_clients',62),(62,5,'clients','ip_clients',63),(63,5,'clients','ip_clients',64),(64,5,'clients','ip_clients',65),(65,5,'clients','ip_clients',66),(66,5,'clients','ip_clients',67),(67,5,'clients','ip_clients',68),(68,5,'clients','ip_clients',69),(69,5,'clients','ip_clients',70),(70,5,'clients','ip_clients',71),(71,5,'clients','ip_clients',72),(72,5,'clients','ip_clients',73),(73,5,'clients','ip_clients',74),(74,5,'clients','ip_clients',75),(75,5,'clients','ip_clients',76),(76,5,'clients','ip_clients',77),(77,5,'clients','ip_clients',78),(78,5,'clients','ip_clients',79),(79,5,'clients','ip_clients',80),(80,5,'clients','ip_clients',81),(81,5,'clients','ip_clients',82),(82,5,'clients','ip_clients',83),(83,5,'clients','ip_clients',84),(84,5,'clients','ip_clients',85),(85,5,'clients','ip_clients',86),(86,5,'clients','ip_clients',87),(87,5,'clients','ip_clients',88),(88,5,'clients','ip_clients',89),(89,5,'clients','ip_clients',90),(90,5,'clients','ip_clients',91),(91,5,'clients','ip_clients',92),(92,5,'clients','ip_clients',93),(93,5,'clients','ip_clients',94),(94,5,'clients','ip_clients',95),(95,5,'clients','ip_clients',96),(96,5,'clients','ip_clients',97),(97,5,'clients','ip_clients',98),(98,5,'clients','ip_clients',99),(99,5,'clients','ip_clients',100),(100,5,'clients','ip_clients',101),(101,5,'clients','ip_clients',102),(102,5,'clients','ip_clients',103),(103,5,'clients','ip_clients',104),(104,5,'clients','ip_clients',105),(105,5,'clients','ip_clients',106),(106,5,'clients','ip_clients',107),(107,5,'clients','ip_clients',108),(108,5,'clients','ip_clients',109),(109,5,'clients','ip_clients',110),(110,5,'clients','ip_clients',111),(111,5,'clients','ip_clients',112),(112,5,'clients','ip_clients',113),(113,5,'clients','ip_clients',114),(114,5,'clients','ip_clients',115),(115,5,'clients','ip_clients',116),(116,5,'clients','ip_clients',117),(117,5,'clients','ip_clients',118),(118,5,'clients','ip_clients',119),(119,5,'clients','ip_clients',120),(120,5,'clients','ip_clients',121),(121,5,'clients','ip_clients',122),(122,5,'clients','ip_clients',123),(123,5,'clients','ip_clients',124),(124,5,'clients','ip_clients',125),(125,5,'clients','ip_clients',126),(126,5,'clients','ip_clients',127),(127,5,'clients','ip_clients',128),(128,5,'clients','ip_clients',129),(129,5,'clients','ip_clients',130),(130,5,'clients','ip_clients',131),(131,5,'clients','ip_clients',132),(132,5,'clients','ip_clients',133),(133,5,'clients','ip_clients',134),(134,5,'clients','ip_clients',135),(135,5,'clients','ip_clients',136),(136,5,'clients','ip_clients',137),(137,5,'clients','ip_clients',138),(138,5,'clients','ip_clients',139),(139,5,'clients','ip_clients',140),(140,5,'clients','ip_clients',141),(141,5,'clients','ip_clients',142),(142,5,'clients','ip_clients',143),(143,5,'clients','ip_clients',144),(144,5,'clients','ip_clients',145),(145,5,'clients','ip_clients',146),(146,5,'clients','ip_clients',147),(147,5,'clients','ip_clients',148),(148,5,'clients','ip_clients',149),(149,5,'clients','ip_clients',150),(150,5,'clients','ip_clients',151),(151,5,'clients','ip_clients',152),(152,5,'clients','ip_clients',153),(153,5,'clients','ip_clients',154),(154,5,'clients','ip_clients',155),(155,5,'clients','ip_clients',156),(156,5,'clients','ip_clients',157),(157,5,'clients','ip_clients',158),(158,5,'clients','ip_clients',159),(159,5,'clients','ip_clients',160),(160,5,'clients','ip_clients',161),(161,5,'clients','ip_clients',162),(162,5,'clients','ip_clients',163),(163,5,'clients','ip_clients',164),(164,5,'clients','ip_clients',165),(165,5,'clients','ip_clients',166),(166,5,'clients','ip_clients',167),(167,5,'clients','ip_clients',168),(168,5,'clients','ip_clients',169),(169,5,'clients','ip_clients',170),(170,5,'clients','ip_clients',171),(171,5,'clients','ip_clients',172),(172,5,'clients','ip_clients',173),(173,5,'clients','ip_clients',174),(174,5,'clients','ip_clients',175),(175,5,'clients','ip_clients',176),(176,5,'clients','ip_clients',177),(177,5,'clients','ip_clients',178),(178,5,'clients','ip_clients',179),(179,5,'clients','ip_clients',180),(180,5,'clients','ip_clients',181),(181,5,'clients','ip_clients',182),(182,5,'clients','ip_clients',183),(183,5,'clients','ip_clients',184),(184,5,'clients','ip_clients',185),(185,5,'clients','ip_clients',186),(186,5,'clients','ip_clients',187),(187,5,'clients','ip_clients',188),(188,5,'clients','ip_clients',189),(189,5,'clients','ip_clients',190),(190,5,'clients','ip_clients',191),(191,5,'clients','ip_clients',192),(192,5,'clients','ip_clients',193),(193,5,'clients','ip_clients',194),(194,5,'clients','ip_clients',195),(195,5,'clients','ip_clients',196),(196,5,'clients','ip_clients',197),(197,5,'clients','ip_clients',198),(198,5,'clients','ip_clients',199),(199,5,'clients','ip_clients',200),(200,5,'clients','ip_clients',201),(201,5,'clients','ip_clients',202),(202,5,'clients','ip_clients',203),(203,5,'clients','ip_clients',204),(204,5,'clients','ip_clients',205),(205,5,'clients','ip_clients',206),(206,5,'clients','ip_clients',207),(207,5,'clients','ip_clients',208),(208,5,'clients','ip_clients',209),(209,5,'clients','ip_clients',210),(210,5,'clients','ip_clients',211),(211,5,'clients','ip_clients',212),(212,5,'clients','ip_clients',213),(213,5,'clients','ip_clients',214),(214,5,'clients','ip_clients',215),(215,5,'clients','ip_clients',216),(216,5,'clients','ip_clients',217),(217,5,'clients','ip_clients',218),(218,5,'clients','ip_clients',219),(219,5,'clients','ip_clients',220),(220,5,'clients','ip_clients',221),(221,5,'clients','ip_clients',222),(222,5,'clients','ip_clients',223),(223,5,'clients','ip_clients',224),(224,5,'clients','ip_clients',225),(225,5,'clients','ip_clients',226),(226,5,'clients','ip_clients',227),(227,5,'clients','ip_clients',228),(228,5,'clients','ip_clients',229),(229,5,'clients','ip_clients',230),(230,5,'clients','ip_clients',231),(231,5,'clients','ip_clients',232),(232,5,'clients','ip_clients',233),(233,5,'clients','ip_clients',234),(234,5,'clients','ip_clients',235),(235,5,'clients','ip_clients',236),(236,5,'clients','ip_clients',237),(237,5,'clients','ip_clients',238),(238,5,'clients','ip_clients',239),(239,5,'clients','ip_clients',240),(240,5,'clients','ip_clients',241),(241,5,'clients','ip_clients',242),(242,5,'clients','ip_clients',243),(243,5,'clients','ip_clients',244),(244,5,'clients','ip_clients',245),(245,5,'clients','ip_clients',246),(246,5,'clients','ip_clients',247),(247,5,'clients','ip_clients',248),(248,5,'clients','ip_clients',249),(249,5,'clients','ip_clients',250),(250,5,'clients','ip_clients',251),(251,5,'clients','ip_clients',252),(252,5,'clients','ip_clients',253),(253,5,'clients','ip_clients',254),(254,5,'clients','ip_clients',255),(255,5,'clients','ip_clients',256),(256,5,'clients','ip_clients',257),(257,5,'clients','ip_clients',258),(258,5,'clients','ip_clients',259),(259,5,'clients','ip_clients',260),(260,5,'clients','ip_clients',261),(261,5,'clients','ip_clients',262),(262,5,'clients','ip_clients',263),(263,5,'clients','ip_clients',264),(264,5,'clients','ip_clients',265),(265,5,'clients','ip_clients',266),(266,5,'clients','ip_clients',267),(267,5,'clients','ip_clients',268),(268,5,'clients','ip_clients',269),(269,5,'clients','ip_clients',270),(270,5,'clients','ip_clients',271),(271,5,'clients','ip_clients',272),(272,5,'clients','ip_clients',273),(273,5,'clients','ip_clients',274),(274,5,'clients','ip_clients',275),(275,5,'clients','ip_clients',276),(276,5,'clients','ip_clients',277),(277,5,'clients','ip_clients',278),(278,5,'clients','ip_clients',279),(279,5,'clients','ip_clients',280),(280,5,'clients','ip_clients',281),(281,5,'clients','ip_clients',282),(282,5,'clients','ip_clients',283),(283,5,'clients','ip_clients',284),(284,5,'clients','ip_clients',285),(285,5,'clients','ip_clients',286),(286,5,'clients','ip_clients',287),(287,5,'clients','ip_clients',288),(288,5,'clients','ip_clients',289),(289,5,'clients','ip_clients',290),(290,5,'clients','ip_clients',291),(291,5,'clients','ip_clients',292),(292,5,'clients','ip_clients',293),(293,5,'clients','ip_clients',294),(294,5,'clients','ip_clients',295),(295,5,'clients','ip_clients',296),(296,5,'clients','ip_clients',297),(297,5,'clients','ip_clients',298),(298,5,'clients','ip_clients',299),(299,5,'clients','ip_clients',300),(300,5,'clients','ip_clients',301),(301,5,'clients','ip_clients',302),(302,5,'clients','ip_clients',303),(303,5,'clients','ip_clients',304),(304,5,'clients','ip_clients',305),(305,5,'clients','ip_clients',306),(306,5,'clients','ip_clients',307),(307,5,'clients','ip_clients',308),(308,5,'clients','ip_clients',309),(309,5,'clients','ip_clients',310),(310,5,'clients','ip_clients',311),(311,5,'clients','ip_clients',312),(312,5,'clients','ip_clients',313),(313,5,'clients','ip_clients',314),(314,5,'clients','ip_clients',315),(315,5,'clients','ip_clients',316),(316,5,'clients','ip_clients',317),(317,5,'clients','ip_clients',318),(318,5,'clients','ip_clients',319),(319,5,'clients','ip_clients',320),(320,5,'clients','ip_clients',321),(321,5,'clients','ip_clients',322),(322,5,'clients','ip_clients',323),(323,5,'clients','ip_clients',324),(324,5,'clients','ip_clients',325),(325,5,'clients','ip_clients',326),(326,5,'clients','ip_clients',327),(327,5,'clients','ip_clients',328),(328,5,'clients','ip_clients',329),(329,5,'clients','ip_clients',330),(330,5,'clients','ip_clients',331),(331,5,'clients','ip_clients',332),(332,5,'clients','ip_clients',333),(333,5,'clients','ip_clients',334),(334,5,'clients','ip_clients',335),(335,5,'clients','ip_clients',336),(336,5,'clients','ip_clients',337),(337,5,'clients','ip_clients',338),(338,5,'clients','ip_clients',339),(339,5,'clients','ip_clients',340),(340,5,'clients','ip_clients',341),(341,5,'clients','ip_clients',342),(342,5,'clients','ip_clients',343),(343,5,'clients','ip_clients',344),(344,5,'clients','ip_clients',345),(345,5,'clients','ip_clients',346),(346,5,'clients','ip_clients',347),(347,5,'clients','ip_clients',348),(348,5,'clients','ip_clients',349),(349,5,'clients','ip_clients',350),(350,5,'clients','ip_clients',351),(351,5,'clients','ip_clients',352),(352,5,'clients','ip_clients',353),(353,5,'clients','ip_clients',354),(354,5,'clients','ip_clients',355),(355,5,'clients','ip_clients',356),(356,5,'clients','ip_clients',357),(357,5,'clients','ip_clients',358),(358,5,'clients','ip_clients',359),(359,5,'clients','ip_clients',360),(360,5,'clients','ip_clients',361),(361,5,'clients','ip_clients',362),(362,5,'clients','ip_clients',363),(363,5,'clients','ip_clients',364),(364,5,'clients','ip_clients',365),(365,5,'clients','ip_clients',366),(366,5,'clients','ip_clients',367),(367,5,'clients','ip_clients',368),(368,5,'clients','ip_clients',369),(369,5,'clients','ip_clients',370),(370,5,'clients','ip_clients',371),(371,5,'clients','ip_clients',372),(372,5,'clients','ip_clients',373),(373,5,'clients','ip_clients',374),(374,5,'clients','ip_clients',375),(375,5,'clients','ip_clients',376),(376,5,'clients','ip_clients',377),(377,5,'clients','ip_clients',378),(378,5,'clients','ip_clients',379),(379,5,'clients','ip_clients',380),(380,5,'clients','ip_clients',381),(381,5,'clients','ip_clients',382),(382,5,'clients','ip_clients',383),(383,5,'clients','ip_clients',384),(384,5,'clients','ip_clients',385),(385,5,'clients','ip_clients',386),(386,5,'clients','ip_clients',387),(387,5,'clients','ip_clients',388),(388,5,'clients','ip_clients',389),(389,5,'clients','ip_clients',390),(390,5,'clients','ip_clients',391),(391,5,'clients','ip_clients',392),(392,5,'clients','ip_clients',393),(393,5,'clients','ip_clients',394),(394,5,'clients','ip_clients',395),(395,5,'clients','ip_clients',396),(396,5,'clients','ip_clients',397),(397,5,'clients','ip_clients',398),(398,5,'clients','ip_clients',399),(399,5,'clients','ip_clients',400),(400,5,'clients','ip_clients',401),(401,5,'clients','ip_clients',402),(402,5,'clients','ip_clients',403),(403,5,'clients','ip_clients',404),(404,5,'clients','ip_clients',405),(405,5,'clients','ip_clients',406),(406,5,'clients','ip_clients',407),(407,5,'clients','ip_clients',408),(408,5,'clients','ip_clients',409),(409,5,'clients','ip_clients',410),(410,5,'clients','ip_clients',411),(411,5,'clients','ip_clients',412),(412,5,'clients','ip_clients',413),(413,5,'clients','ip_clients',414),(414,5,'clients','ip_clients',415),(415,5,'clients','ip_clients',416),(416,5,'clients','ip_clients',417),(417,5,'clients','ip_clients',418),(418,5,'clients','ip_clients',419),(419,5,'clients','ip_clients',420),(420,5,'clients','ip_clients',421),(421,5,'clients','ip_clients',422),(422,5,'clients','ip_clients',423),(423,5,'clients','ip_clients',424),(424,5,'clients','ip_clients',425),(425,5,'clients','ip_clients',426),(426,5,'clients','ip_clients',427),(427,5,'clients','ip_clients',428),(428,5,'clients','ip_clients',429),(429,5,'clients','ip_clients',430),(430,5,'clients','ip_clients',431),(431,5,'clients','ip_clients',432),(432,5,'clients','ip_clients',433),(433,5,'clients','ip_clients',434),(434,5,'clients','ip_clients',435),(435,5,'clients','ip_clients',436),(436,5,'clients','ip_clients',437),(437,5,'clients','ip_clients',438),(438,5,'clients','ip_clients',439),(439,5,'clients','ip_clients',440),(440,5,'clients','ip_clients',441),(441,5,'clients','ip_clients',442),(442,5,'clients','ip_clients',443),(443,5,'clients','ip_clients',444),(444,5,'clients','ip_clients',445),(445,5,'clients','ip_clients',446),(446,5,'clients','ip_clients',447),(447,5,'clients','ip_clients',448),(448,5,'clients','ip_clients',449),(449,5,'clients','ip_clients',450),(450,5,'clients','ip_clients',451),(451,5,'clients','ip_clients',452),(452,5,'clients','ip_clients',453),(453,5,'clients','ip_clients',454),(454,5,'clients','ip_clients',455),(455,5,'clients','ip_clients',456),(456,5,'clients','ip_clients',457),(457,5,'clients','ip_clients',458),(458,5,'clients','ip_clients',459),(459,5,'clients','ip_clients',460),(460,5,'clients','ip_clients',461),(461,5,'clients','ip_clients',462),(462,5,'clients','ip_clients',463),(463,5,'clients','ip_clients',464),(464,5,'clients','ip_clients',465),(465,5,'clients','ip_clients',466),(466,5,'clients','ip_clients',467),(467,5,'clients','ip_clients',468),(468,5,'clients','ip_clients',469),(469,5,'clients','ip_clients',470),(470,5,'clients','ip_clients',471),(471,5,'clients','ip_clients',472),(472,5,'clients','ip_clients',473),(473,5,'clients','ip_clients',474),(474,5,'clients','ip_clients',475),(475,5,'clients','ip_clients',476),(476,5,'clients','ip_clients',477),(477,5,'clients','ip_clients',478),(478,5,'clients','ip_clients',479),(479,5,'clients','ip_clients',480),(480,5,'clients','ip_clients',481),(481,5,'clients','ip_clients',482),(482,5,'clients','ip_clients',483),(483,5,'clients','ip_clients',484),(484,5,'clients','ip_clients',485),(485,5,'clients','ip_clients',486),(486,5,'clients','ip_clients',487),(487,5,'clients','ip_clients',488),(488,5,'clients','ip_clients',489),(489,5,'clients','ip_clients',490),(490,5,'clients','ip_clients',491),(491,5,'clients','ip_clients',492),(492,5,'clients','ip_clients',493),(493,5,'clients','ip_clients',494),(494,5,'clients','ip_clients',495),(495,5,'clients','ip_clients',496),(496,5,'clients','ip_clients',497),(497,5,'clients','ip_clients',498),(498,5,'clients','ip_clients',499),(499,5,'clients','ip_clients',500),(500,5,'clients','ip_clients',501),(501,5,'clients','ip_clients',502),(502,5,'clients','ip_clients',503),(503,5,'clients','ip_clients',504),(504,5,'clients','ip_clients',505),(505,5,'clients','ip_clients',506),(506,5,'clients','ip_clients',507),(507,5,'clients','ip_clients',508),(508,5,'clients','ip_clients',509),(509,5,'clients','ip_clients',510),(510,5,'clients','ip_clients',511),(511,5,'clients','ip_clients',512),(512,5,'clients','ip_clients',513),(513,5,'clients','ip_clients',514),(514,5,'clients','ip_clients',515),(515,5,'clients','ip_clients',516),(516,5,'clients','ip_clients',517),(517,5,'clients','ip_clients',518),(518,5,'clients','ip_clients',519),(519,5,'clients','ip_clients',520),(520,5,'clients','ip_clients',521),(521,5,'clients','ip_clients',522),(522,5,'clients','ip_clients',523),(523,5,'clients','ip_clients',524),(524,5,'clients','ip_clients',525),(525,5,'clients','ip_clients',526),(526,5,'clients','ip_clients',527),(527,5,'clients','ip_clients',528),(528,5,'clients','ip_clients',529),(529,5,'clients','ip_clients',530),(530,5,'clients','ip_clients',531),(531,5,'clients','ip_clients',532),(532,5,'clients','ip_clients',533),(533,5,'clients','ip_clients',534),(534,5,'clients','ip_clients',535),(535,5,'clients','ip_clients',536),(536,5,'clients','ip_clients',537),(537,5,'clients','ip_clients',538),(538,5,'clients','ip_clients',539),(539,5,'clients','ip_clients',540),(540,5,'clients','ip_clients',541),(541,5,'clients','ip_clients',542),(542,5,'clients','ip_clients',543),(543,5,'clients','ip_clients',544),(544,5,'clients','ip_clients',545),(545,5,'clients','ip_clients',546),(546,5,'clients','ip_clients',547),(547,5,'clients','ip_clients',548),(548,5,'clients','ip_clients',549),(549,5,'clients','ip_clients',550),(550,5,'clients','ip_clients',551),(551,5,'clients','ip_clients',552),(552,5,'clients','ip_clients',553),(553,5,'clients','ip_clients',554),(554,5,'clients','ip_clients',555),(555,5,'clients','ip_clients',556),(556,5,'clients','ip_clients',557),(557,5,'clients','ip_clients',558),(558,5,'clients','ip_clients',559),(559,5,'clients','ip_clients',560),(560,5,'clients','ip_clients',561),(561,5,'clients','ip_clients',562),(562,5,'clients','ip_clients',563),(563,5,'clients','ip_clients',564),(564,5,'clients','ip_clients',565),(565,5,'clients','ip_clients',566),(566,5,'clients','ip_clients',567),(567,5,'clients','ip_clients',568),(568,5,'clients','ip_clients',569),(569,5,'clients','ip_clients',570),(570,5,'clients','ip_clients',571),(571,5,'clients','ip_clients',572),(572,5,'clients','ip_clients',573),(573,5,'clients','ip_clients',574),(574,5,'clients','ip_clients',575),(575,5,'clients','ip_clients',576),(576,5,'clients','ip_clients',577),(577,5,'clients','ip_clients',578),(578,5,'clients','ip_clients',579),(579,5,'clients','ip_clients',580),(580,5,'clients','ip_clients',581),(581,5,'clients','ip_clients',582),(582,5,'clients','ip_clients',583),(583,5,'clients','ip_clients',584),(584,5,'clients','ip_clients',585),(585,5,'clients','ip_clients',586),(586,5,'clients','ip_clients',587);

--
-- 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 AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

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

INSERT INTO `ip_imports` VALUES (5,'2015-06-04 23:22:38');

--
-- 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=762 DEFAULT CHARSET=utf8;

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

INSERT INTO `ip_invoice_amounts` VALUES (20,19,'1',19.95,0.00,0.00,19.95,0.00,19.95),(19,18,'1',49.95,0.00,0.00,49.95,0.00,49.95),(18,17,'1',29.95,0.00,0.00,29.95,0.00,29.95),(23,22,'1',49.95,0.00,0.00,49.95,0.00,49.95),(515,514,'1',61.95,0.00,0.00,61.95,0.00,61.95),(510,509,'1',49.95,0.00,0.00,49.95,0.00,49.95),(24,23,'1',14.95,0.00,0.00,14.95,0.00,14.95),(25,24,'1',49.95,0.00,0.00,49.95,0.00,49.95),(493,492,'1',61.95,0.00,0.00,61.95,0.00,61.95),(501,500,'1',49.95,0.00,0.00,49.95,0.00,49.95),(28,27,'1',55.95,0.00,0.00,55.95,0.00,55.95),(32,31,'1',61.95,0.00,0.00,61.95,0.00,61.95),(30,29,'1',49.95,0.00,0.00,49.95,0.00,49.95),(34,33,'1',49.95,0.00,0.00,49.95,0.00,49.95),(480,479,'1',49.95,0.00,0.00,49.95,0.00,49.95),(39,38,'1',49.95,0.00,0.00,49.95,0.00,49.95),(38,37,'1',49.95,0.00,0.00,49.95,0.00,49.95),(48,47,'1',168.00,0.00,0.00,168.00,0.00,168.00),(43,42,'1',49.95,0.00,0.00,49.95,0.00,49.95),(42,41,'1',49.95,0.00,0.00,49.95,0.00,49.95),(44,43,'1',49.95,0.00,0.00,49.95,0.00,49.95),(45,44,'1',37.95,0.00,0.00,37.95,0.00,37.95),(46,45,'1',96.00,0.00,0.00,96.00,0.00,96.00),(49,48,'1',359.40,0.00,0.00,359.40,0.00,359.40),(50,49,'1',359.40,0.00,0.00,359.40,0.00,359.40),(687,686,'1',19.95,0.00,0.00,19.95,0.00,19.95),(52,51,'1',419.40,0.00,0.00,419.40,0.00,419.40),(727,726,'1',49.95,0.00,0.00,49.95,0.00,49.95),(54,53,'1',39.95,0.00,0.00,39.95,0.00,39.95),(56,55,'1',29.95,0.00,0.00,29.95,0.00,29.95),(57,56,'1',49.95,0.00,0.00,49.95,0.00,49.95),(58,57,'1',NULL,NULL,NULL,NULL,NULL,NULL),(59,58,'1',19.95,0.00,0.00,19.95,0.00,19.95),(509,508,'1',19.95,0.00,0.00,19.95,0.00,19.95),(514,513,'1',39.95,0.00,0.00,39.95,0.00,39.95),(62,61,'1',49.95,0.00,0.00,49.95,0.00,49.95),(63,62,'1',14.95,0.00,0.00,14.95,0.00,14.95),(64,63,'1',49.95,0.00,0.00,49.95,0.00,49.95),(65,64,'1',39.95,0.00,0.00,39.95,0.00,39.95),(66,65,'1',61.95,0.00,0.00,61.95,0.00,61.95),(500,499,'1',73.95,0.00,0.00,73.95,0.00,73.95),(68,67,'1',37.95,0.00,0.00,37.95,0.00,37.95),(70,69,'1',59.95,0.00,0.00,59.95,0.00,59.95),(71,70,'1',49.95,0.00,0.00,49.95,0.00,49.95),(465,464,'1',49.95,0.00,0.00,49.95,0.00,49.95),(492,491,'1',39.95,0.00,0.00,39.95,0.00,39.95),(74,73,'1',49.95,0.00,0.00,49.95,0.00,49.95),(75,74,'1',49.95,0.00,0.00,49.95,0.00,49.95),(76,75,'1',49.95,0.00,0.00,49.95,0.00,49.95),(77,76,'1',49.95,0.00,0.00,49.95,0.00,49.95),(78,77,'1',49.95,0.00,0.00,49.95,0.00,49.95),(79,78,'1',49.95,0.00,0.00,49.95,0.00,49.95),(88,87,'1',49.95,0.00,0.00,49.95,0.00,49.95),(81,80,'1',49.95,0.00,0.00,49.95,0.00,49.95),(82,81,'1',39.95,0.00,0.00,39.95,0.00,39.95),(508,507,'1',49.95,0.00,0.00,49.95,0.00,49.95),(513,512,'1',49.95,0.00,0.00,49.95,0.00,49.95),(85,84,'1',49.95,0.00,0.00,49.95,0.00,49.95),(86,85,'1',14.95,0.00,0.00,14.95,0.00,14.95),(87,86,'1',NULL,NULL,NULL,NULL,NULL,NULL),(499,498,'1',49.95,0.00,0.00,49.95,0.00,49.95),(90,89,'1',49.95,0.00,0.00,49.95,0.00,49.95),(91,90,'1',49.95,0.00,0.00,49.95,0.00,49.95),(92,91,'1',49.95,0.00,0.00,49.95,0.00,49.95),(93,92,'1',49.95,0.00,0.00,49.95,0.00,49.95),(95,94,'1',49.95,0.00,0.00,49.95,0.00,49.95),(96,95,'1',49.95,0.00,0.00,49.95,0.00,49.95),(491,490,'1',49.95,0.00,0.00,49.95,0.00,49.95),(99,98,'1',49.95,0.00,0.00,49.95,0.00,49.95),(100,99,'1',59.95,0.00,0.00,59.95,0.00,59.95),(101,100,'1',37.95,0.00,0.00,37.95,0.00,37.95),(102,101,'1',61.95,0.00,0.00,61.95,0.00,61.95),(103,102,'1',39.95,0.00,0.00,39.95,0.00,39.95),(104,103,'1',29.95,0.00,0.00,29.95,0.00,29.95),(105,104,'1',39.95,0.00,0.00,39.95,0.00,39.95),(106,105,'1',61.95,0.00,0.00,61.95,0.00,61.95),(115,114,'1',49.95,0.00,0.00,49.95,0.00,49.95),(109,108,'1',39.95,0.00,0.00,39.95,0.00,39.95),(110,109,'1',59.95,0.00,0.00,59.95,0.00,59.95),(111,110,'1',49.95,0.00,0.00,49.95,0.00,49.95),(114,113,'1',49.95,0.00,0.00,49.95,0.00,49.95),(490,489,'1',49.95,0.00,0.00,49.95,0.00,49.95),(116,115,'1',49.95,0.00,0.00,49.95,0.00,49.95),(117,116,'1',49.95,0.00,0.00,49.95,0.00,49.95),(118,117,'1',49.95,0.00,0.00,49.95,0.00,49.95),(119,118,'1',49.95,0.00,0.00,49.95,0.00,49.95),(498,497,'1',49.95,0.00,0.00,49.95,0.00,49.95),(121,120,'1',49.95,0.00,0.00,49.95,0.00,49.95),(122,121,'1',14.95,0.00,0.00,14.95,0.00,14.95),(512,511,'1',49.95,0.00,0.00,49.95,0.00,49.95),(124,123,'1',49.95,0.00,0.00,49.95,0.00,49.95),(507,506,'1',29.95,0.00,0.00,29.95,0.00,29.95),(126,125,'1',39.95,0.00,0.00,39.95,0.00,39.95),(127,126,'1',49.95,0.00,0.00,49.95,0.00,49.95),(128,127,'1',29.95,0.00,0.00,29.95,0.00,29.95),(129,128,'1',49.95,0.00,0.00,49.95,0.00,49.95),(130,129,'1',39.95,0.00,0.00,39.95,0.00,39.95),(506,505,'1',49.95,0.00,0.00,49.95,0.00,49.95),(511,510,'1',14.95,0.00,0.00,14.95,0.00,14.95),(133,132,'1',49.95,0.00,0.00,49.95,0.00,49.95),(134,133,'1',14.95,0.00,0.00,14.95,0.00,14.95),(135,134,'1',49.95,0.00,0.00,49.95,0.00,49.95),(136,135,'1',39.95,0.00,0.00,39.95,0.00,39.95),(137,136,'1',61.95,0.00,0.00,61.95,0.00,61.95),(138,137,'1',39.95,0.00,0.00,39.95,0.00,39.95),(497,496,'1',49.95,0.00,0.00,49.95,0.00,49.95),(140,139,'1',59.95,0.00,0.00,59.95,0.00,59.95),(141,140,'1',49.95,0.00,0.00,49.95,0.00,49.95),(489,488,'1',14.95,0.00,0.00,14.95,0.00,14.95),(488,487,'1',49.95,0.00,0.00,49.95,0.00,49.95),(144,143,'1',49.95,0.00,0.00,49.95,0.00,49.95),(145,144,'1',49.95,0.00,0.00,49.95,0.00,49.95),(146,145,'1',49.95,0.00,0.00,49.95,0.00,49.95),(147,146,'1',49.95,0.00,0.00,49.95,0.00,49.95),(148,147,'1',49.95,0.00,0.00,49.95,0.00,49.95),(149,148,'1',49.95,0.00,0.00,49.95,0.00,49.95),(153,152,'1',29.95,0.00,0.00,29.95,0.00,29.95),(154,153,'1',NULL,NULL,NULL,NULL,NULL,NULL),(155,154,'1',49.95,0.00,0.00,49.95,0.00,49.95),(156,155,'1',39.95,0.00,0.00,39.95,0.00,39.95),(505,504,'1',49.95,0.00,0.00,49.95,0.00,49.95),(158,157,'1',49.95,0.00,0.00,49.95,0.00,49.95),(159,158,'1',14.95,0.00,0.00,14.95,0.00,14.95),(160,159,'1',49.95,0.00,0.00,49.95,0.00,49.95),(161,160,'1',39.95,0.00,0.00,39.95,0.00,39.95),(162,161,'1',61.95,0.00,0.00,61.95,0.00,61.95),(163,162,'1',39.95,0.00,0.00,39.95,0.00,39.95),(496,495,'1',175.00,0.00,0.00,175.00,0.00,175.00),(165,164,'1',59.95,0.00,0.00,59.95,0.00,59.95),(166,165,'1',49.95,0.00,0.00,49.95,0.00,49.95),(487,486,'1',19.95,0.00,0.00,19.95,0.00,19.95),(168,167,'1',49.95,0.00,0.00,49.95,0.00,49.95),(169,168,'1',49.95,0.00,0.00,49.95,0.00,49.95),(170,169,'1',49.95,0.00,0.00,49.95,0.00,49.95),(171,170,'1',49.95,0.00,0.00,49.95,0.00,49.95),(172,171,'1',49.95,0.00,0.00,49.95,0.00,49.95),(173,172,'1',49.95,0.00,0.00,49.95,0.00,49.95),(181,180,'1',29.95,0.00,0.00,29.95,0.00,29.95),(479,478,'1',73.95,0.00,0.00,73.95,0.00,73.95),(180,179,'1',49.95,0.00,0.00,49.95,0.00,49.95),(707,706,'1',14.95,0.00,0.00,14.95,0.00,14.95),(182,181,'1',49.95,0.00,0.00,49.95,0.00,49.95),(183,182,'1',39.95,0.00,0.00,39.95,0.00,39.95),(723,722,'1',49.95,0.00,0.00,49.95,0.00,49.95),(185,184,'1',49.95,0.00,0.00,49.95,0.00,49.95),(186,185,'1',14.95,0.00,0.00,14.95,0.00,14.95),(187,186,'1',49.95,0.00,0.00,49.95,0.00,49.95),(188,187,'1',49.95,0.00,0.00,49.95,0.00,49.95),(189,188,'1',49.95,0.00,0.00,49.95,0.00,49.95),(190,189,'1',61.95,0.00,0.00,61.95,0.00,61.95),(191,190,'1',39.95,0.00,0.00,39.95,0.00,39.95),(495,494,'1',63.95,0.00,0.00,63.95,0.00,63.95),(193,192,'1',59.95,0.00,0.00,59.95,0.00,59.95),(194,193,'1',49.95,0.00,0.00,49.95,0.00,49.95),(485,484,'1',49.95,0.00,0.00,49.95,0.00,49.95),(196,195,'1',49.95,0.00,0.00,49.95,0.00,49.95),(197,196,'1',49.95,0.00,0.00,49.95,0.00,49.95),(198,197,'1',49.95,0.00,0.00,49.95,0.00,49.95),(478,477,'1',49.95,0.00,0.00,49.95,0.00,49.95),(200,199,'1',49.95,0.00,0.00,49.95,0.00,49.95),(201,200,'1',49.95,0.00,0.00,49.95,0.00,49.95),(202,201,'1',49.95,0.00,0.00,49.95,0.00,49.95),(706,705,'1',49.95,0.00,0.00,49.95,0.00,49.95),(204,203,'1',0.00,0.00,0.00,0.00,0.00,0.00),(205,204,'1',29.95,0.00,0.00,29.95,0.00,29.95),(206,205,'1',49.95,0.00,0.00,49.95,0.00,49.95),(207,206,'1',39.95,0.00,0.00,39.95,0.00,39.95),(503,502,'1',NULL,NULL,NULL,NULL,NULL,NULL),(209,208,'1',49.95,0.00,0.00,49.95,0.00,49.95),(210,209,'1',14.95,0.00,0.00,14.95,0.00,14.95),(211,210,'1',49.95,0.00,0.00,49.95,0.00,49.95),(212,211,'1',49.95,0.00,0.00,49.95,0.00,49.95),(213,212,'1',39.95,0.00,0.00,39.95,0.00,39.95),(214,213,'1',61.95,0.00,0.00,61.95,0.00,61.95),(215,214,'1',59.95,0.00,0.00,59.95,0.00,59.95),(216,215,'1',49.95,0.00,0.00,49.95,0.00,49.95),(484,483,'1',29.95,0.00,0.00,29.95,0.00,29.95),(218,217,'1',49.95,0.00,0.00,49.95,0.00,49.95),(219,218,'1',49.95,0.00,0.00,49.95,0.00,49.95),(220,219,'1',49.95,0.00,0.00,49.95,0.00,49.95),(477,476,'1',49.95,0.00,0.00,49.95,0.00,49.95),(222,221,'1',49.95,0.00,0.00,49.95,0.00,49.95),(223,222,'1',49.95,0.00,0.00,49.95,0.00,49.95),(224,223,'1',49.95,0.00,0.00,49.95,0.00,49.95),(705,704,'1',29.95,0.00,0.00,29.95,0.00,29.95),(226,225,'1',29.95,0.00,0.00,29.95,0.00,29.95),(227,226,'1',49.95,0.00,0.00,49.95,0.00,49.95),(228,227,'1',19.95,0.00,0.00,19.95,0.00,19.95),(502,501,'1',49.95,0.00,0.00,49.95,0.00,49.95),(230,229,'1',49.95,0.00,0.00,49.95,0.00,49.95),(231,230,'1',14.95,0.00,0.00,14.95,0.00,14.95),(232,231,'1',NULL,NULL,NULL,NULL,NULL,NULL),(233,232,'1',49.95,0.00,0.00,49.95,0.00,49.95),(234,233,'1',49.95,0.00,0.00,49.95,0.00,49.95),(235,234,'1',39.95,0.00,0.00,39.95,0.00,39.95),(236,235,'1',61.95,0.00,0.00,61.95,0.00,61.95),(494,493,'1',39.95,0.00,0.00,39.95,0.00,39.95),(238,237,'1',59.95,0.00,0.00,59.95,0.00,59.95),(239,238,'1',49.95,0.00,0.00,49.95,0.00,49.95),(483,482,'1',49.95,0.00,0.00,49.95,0.00,49.95),(241,240,'1',49.95,0.00,0.00,49.95,0.00,49.95),(242,241,'1',49.95,0.00,0.00,49.95,0.00,49.95),(243,242,'1',49.95,0.00,0.00,49.95,0.00,49.95),(476,475,'1',49.95,0.00,0.00,49.95,0.00,49.95),(245,244,'1',49.95,0.00,0.00,49.95,0.00,49.95),(246,245,'1',49.95,0.00,0.00,49.95,0.00,49.95),(247,246,'1',49.95,0.00,0.00,49.95,0.00,49.95),(704,703,'1',49.95,0.00,0.00,49.95,0.00,49.95),(249,248,'1',29.95,0.00,0.00,29.95,0.00,29.95),(250,249,'1',49.95,0.00,0.00,49.95,0.00,49.95),(251,250,'1',19.95,0.00,0.00,19.95,0.00,19.95),(252,251,'1',14.95,0.00,0.00,14.95,0.00,14.95),(726,725,'1',49.95,0.00,0.00,49.95,0.00,49.95),(254,253,'1',359.40,0.00,0.00,359.40,0.00,359.40),(255,254,'1',49.95,0.00,0.00,49.95,0.00,49.95),(256,255,'1',49.95,0.00,0.00,49.95,0.00,49.95),(257,256,'1',39.95,0.00,0.00,39.95,0.00,39.95),(258,257,'1',61.95,0.00,0.00,61.95,0.00,61.95),(259,258,'1',39.95,0.00,0.00,39.95,0.00,39.95),(260,259,'1',59.95,0.00,0.00,59.95,0.00,59.95),(261,260,'1',49.95,0.00,0.00,49.95,0.00,49.95),(722,721,'1',49.95,0.00,0.00,49.95,0.00,49.95),(263,262,'1',49.95,0.00,0.00,49.95,0.00,49.95),(264,263,'1',49.95,0.00,0.00,49.95,0.00,49.95),(265,264,'1',49.95,0.00,0.00,49.95,0.00,49.95),(475,474,'1',175.00,0.00,0.00,175.00,0.00,175.00),(267,266,'1',49.95,0.00,0.00,49.95,0.00,49.95),(268,267,'1',49.95,0.00,0.00,49.95,0.00,49.95),(269,268,'1',359.40,0.00,0.00,359.40,0.00,359.40),(270,269,'1',49.95,0.00,0.00,49.95,0.00,49.95),(703,702,'1',49.95,0.00,0.00,49.95,0.00,49.95),(686,685,'1',49.95,0.00,0.00,49.95,0.00,49.95),(273,272,'1',419.40,0.00,0.00,419.40,0.00,419.40),(464,463,'1',29.95,0.00,0.00,29.95,0.00,29.95),(275,274,'1',29.95,0.00,0.00,29.95,0.00,29.95),(276,275,'1',49.95,0.00,0.00,49.95,0.00,49.95),(277,276,'1',19.95,0.00,0.00,19.95,0.00,19.95),(278,277,'1',49.95,0.00,0.00,49.95,0.00,49.95),(279,278,'1',14.95,0.00,0.00,14.95,0.00,14.95),(280,279,'1',49.95,0.00,0.00,49.95,0.00,49.95),(281,280,'1',49.95,0.00,0.00,49.95,0.00,49.95),(282,281,'1',39.95,0.00,0.00,39.95,0.00,39.95),(283,282,'1',61.95,0.00,0.00,61.95,0.00,61.95),(284,283,'1',39.95,0.00,0.00,39.95,0.00,39.95),(285,284,'1',59.95,0.00,0.00,59.95,0.00,59.95),(286,285,'1',49.95,0.00,0.00,49.95,0.00,49.95),(481,480,'1',49.95,0.00,0.00,49.95,0.00,49.95),(288,287,'1',49.95,0.00,0.00,49.95,0.00,49.95),(289,288,'1',49.95,0.00,0.00,49.95,0.00,49.95),(290,289,'1',49.95,0.00,0.00,49.95,0.00,49.95),(474,473,'1',63.95,0.00,0.00,63.95,0.00,63.95),(292,291,'1',49.95,0.00,0.00,49.95,0.00,49.95),(293,292,'1',49.95,0.00,0.00,49.95,0.00,49.95),(294,293,'1',49.95,0.00,0.00,49.95,0.00,49.95),(295,294,'1',49.95,0.00,0.00,49.95,0.00,49.95),(702,701,'1',49.95,0.00,0.00,49.95,0.00,49.95),(304,303,'1',49.95,0.00,0.00,49.95,0.00,49.95),(305,304,'1',14.95,0.00,0.00,14.95,0.00,14.95),(299,298,'1',29.95,0.00,0.00,29.95,0.00,29.95),(301,300,'1',49.95,0.00,0.00,49.95,0.00,49.95),(303,302,'1',19.95,0.00,0.00,19.95,0.00,19.95),(307,306,'1',49.95,0.00,0.00,49.95,0.00,49.95),(308,307,'1',49.95,0.00,0.00,49.95,0.00,49.95),(309,308,'1',39.95,0.00,0.00,39.95,0.00,39.95),(310,309,'1',61.95,0.00,0.00,61.95,0.00,61.95),(311,310,'1',39.95,0.00,0.00,39.95,0.00,39.95),(312,311,'1',59.95,0.00,0.00,59.95,0.00,59.95),(313,312,'1',49.95,0.00,0.00,49.95,0.00,49.95),(314,313,'1',49.95,0.00,0.00,49.95,0.00,49.95),(315,314,'1',49.95,0.00,0.00,49.95,0.00,49.95),(316,315,'1',49.95,0.00,0.00,49.95,0.00,49.95),(473,472,'1',39.95,0.00,0.00,39.95,0.00,39.95),(318,317,'1',49.95,0.00,0.00,49.95,0.00,49.95),(319,318,'1',49.95,0.00,0.00,49.95,0.00,49.95),(320,319,'1',49.95,0.00,0.00,49.95,0.00,49.95),(721,720,'1',49.95,0.00,0.00,49.95,0.00,49.95),(468,467,'1',14.95,0.00,0.00,14.95,0.00,14.95),(323,322,'1',29.95,0.00,0.00,29.95,0.00,29.95),(324,323,'1',49.95,0.00,0.00,49.95,0.00,49.95),(325,324,'1',49.95,0.00,0.00,49.95,0.00,49.95),(326,325,'1',14.95,0.00,0.00,14.95,0.00,14.95),(327,326,'1',NULL,NULL,NULL,NULL,NULL,NULL),(328,327,'1',49.95,0.00,0.00,49.95,0.00,49.95),(329,328,'1',49.95,0.00,0.00,49.95,0.00,49.95),(330,329,'1',39.95,0.00,0.00,39.95,0.00,39.95),(331,330,'1',19.95,0.00,0.00,19.95,0.00,19.95),(332,331,'1',61.95,0.00,0.00,61.95,0.00,61.95),(333,332,'1',39.95,0.00,0.00,39.95,0.00,39.95),(334,333,'1',59.95,0.00,0.00,59.95,0.00,59.95),(335,334,'1',49.95,0.00,0.00,49.95,0.00,49.95),(336,335,'1',49.95,0.00,0.00,49.95,0.00,49.95),(337,336,'1',49.95,0.00,0.00,49.95,0.00,49.95),(338,337,'1',49.95,0.00,0.00,49.95,0.00,49.95),(472,471,'1',61.95,0.00,0.00,61.95,0.00,61.95),(340,339,'1',49.95,0.00,0.00,49.95,0.00,49.95),(341,340,'1',49.95,0.00,0.00,49.95,0.00,49.95),(720,719,'1',73.95,0.00,0.00,73.95,0.00,73.95),(467,466,'1',49.95,0.00,0.00,49.95,0.00,49.95),(344,343,'1',49.95,0.00,0.00,49.95,0.00,49.95),(701,700,'1',73.95,0.00,0.00,73.95,0.00,73.95),(348,347,'1',29.95,0.00,0.00,29.95,0.00,29.95),(349,348,'1',49.95,0.00,0.00,49.95,0.00,49.95),(350,349,'1',19.95,0.00,0.00,19.95,0.00,19.95),(351,350,'1',49.95,0.00,0.00,49.95,0.00,49.95),(352,351,'1',14.95,0.00,0.00,14.95,0.00,14.95),(353,352,'1',49.95,0.00,0.00,49.95,0.00,49.95),(354,353,'1',49.95,0.00,0.00,49.95,0.00,49.95),(356,355,'1',39.95,0.00,0.00,39.95,0.00,39.95),(357,356,'1',61.95,0.00,0.00,61.95,0.00,61.95),(358,357,'1',39.95,0.00,0.00,39.95,0.00,39.95),(359,358,'1',59.95,0.00,0.00,59.95,0.00,59.95),(360,359,'1',49.95,0.00,0.00,49.95,0.00,49.95),(361,360,'1',49.95,0.00,0.00,49.95,0.00,49.95),(362,361,'1',49.95,0.00,0.00,49.95,0.00,49.95),(363,362,'1',49.95,0.00,0.00,49.95,0.00,49.95),(471,470,'1',39.95,0.00,0.00,39.95,0.00,39.95),(365,364,'1',49.95,0.00,0.00,49.95,0.00,49.95),(366,365,'1',49.95,0.00,0.00,49.95,0.00,49.95),(719,718,'1',49.95,0.00,0.00,49.95,0.00,49.95),(466,465,'1',19.95,0.00,0.00,19.95,0.00,19.95),(369,368,'1',49.95,0.00,0.00,49.95,0.00,49.95),(700,699,'1',49.95,0.00,0.00,49.95,0.00,49.95),(371,370,'1',175.00,0.00,0.00,175.00,0.00,175.00),(372,371,'1',29.95,0.00,0.00,29.95,0.00,29.95),(373,372,'1',49.95,0.00,0.00,49.95,0.00,49.95),(374,373,'1',19.95,0.00,0.00,19.95,0.00,19.95),(375,374,'1',49.95,0.00,0.00,49.95,0.00,49.95),(376,375,'1',14.95,0.00,0.00,14.95,0.00,14.95),(377,376,'1',49.95,0.00,0.00,49.95,0.00,49.95),(378,377,'1',49.95,0.00,0.00,49.95,0.00,49.95),(379,378,'1',39.95,0.00,0.00,39.95,0.00,39.95),(380,379,'1',61.95,0.00,0.00,61.95,0.00,61.95),(381,380,'1',39.95,0.00,0.00,39.95,0.00,39.95),(382,381,'1',59.95,0.00,0.00,59.95,0.00,59.95),(387,386,'1',49.95,0.00,0.00,49.95,0.00,49.95),(384,383,'1',175.00,0.00,0.00,175.00,0.00,175.00),(385,384,'1',49.95,0.00,0.00,49.95,0.00,49.95),(386,385,'1',49.95,0.00,0.00,49.95,0.00,49.95),(388,387,'1',49.95,0.00,0.00,49.95,0.00,49.95),(470,469,'1',99.90,0.00,0.00,99.90,0.00,99.90),(391,390,'1',49.95,0.00,0.00,49.95,0.00,49.95),(392,391,'1',49.95,0.00,0.00,49.95,0.00,49.95),(718,717,'1',49.95,0.00,0.00,49.95,0.00,49.95),(394,393,'1',49.95,0.00,0.00,49.95,0.00,49.95),(699,698,'1',49.95,0.00,0.00,49.95,0.00,49.95),(396,395,'1',29.95,0.00,0.00,29.95,0.00,29.95),(399,398,'1',49.95,0.00,0.00,49.95,0.00,49.95),(400,399,'1',19.95,0.00,0.00,19.95,0.00,19.95),(401,400,'1',49.95,0.00,0.00,49.95,0.00,49.95),(402,401,'1',49.95,0.00,0.00,49.95,0.00,49.95),(403,402,'1',49.95,0.00,0.00,49.95,0.00,49.95),(404,403,'1',14.95,0.00,0.00,14.95,0.00,14.95),(405,404,'1',39.95,0.00,0.00,39.95,0.00,39.95),(406,405,'1',61.95,0.00,0.00,61.95,0.00,61.95),(407,406,'1',39.95,0.00,0.00,39.95,0.00,39.95),(408,407,'1',59.95,0.00,0.00,59.95,0.00,59.95),(409,408,'1',175.00,0.00,0.00,175.00,0.00,175.00),(410,409,'1',49.95,0.00,0.00,49.95,0.00,49.95),(411,410,'1',49.95,0.00,0.00,49.95,0.00,49.95),(412,411,'1',49.95,0.00,0.00,49.95,0.00,49.95),(413,412,'1',49.95,0.00,0.00,49.95,0.00,49.95),(469,468,'1',49.95,0.00,0.00,49.95,0.00,49.95),(415,414,'1',49.95,0.00,0.00,49.95,0.00,49.95),(717,716,'1',49.95,0.00,0.00,49.95,0.00,49.95),(417,416,'1',49.95,0.00,0.00,49.95,0.00,49.95),(698,697,'1',49.95,0.00,0.00,49.95,0.00,49.95),(419,418,'1',29.95,0.00,0.00,29.95,0.00,29.95),(420,419,'1',49.95,0.00,0.00,49.95,0.00,49.95),(421,420,'1',19.95,0.00,0.00,19.95,0.00,19.95),(422,421,'1',49.95,0.00,0.00,49.95,0.00,49.95),(423,422,'1',14.95,0.00,0.00,14.95,0.00,14.95),(424,423,'1',49.95,0.00,0.00,49.95,0.00,49.95),(425,424,'1',49.95,0.00,0.00,49.95,0.00,49.95),(426,425,'1',39.95,0.00,0.00,39.95,0.00,39.95),(427,426,'1',61.95,0.00,0.00,61.95,0.00,61.95),(428,427,'1',59.95,0.00,0.00,59.95,0.00,59.95),(432,431,'1',49.95,0.00,0.00,49.95,0.00,49.95),(431,430,'1',175.00,0.00,0.00,175.00,0.00,175.00),(433,432,'1',49.95,0.00,0.00,49.95,0.00,49.95),(434,433,'1',49.95,0.00,0.00,49.95,0.00,49.95),(435,434,'1',49.95,0.00,0.00,49.95,0.00,49.95),(436,435,'1',49.95,0.00,0.00,49.95,0.00,49.95),(437,436,'1',49.95,0.00,0.00,49.95,0.00,49.95),(716,715,'1',175.00,0.00,0.00,175.00,0.00,175.00),(439,438,'1',49.95,0.00,0.00,49.95,0.00,49.95),(697,696,'1',175.00,0.00,0.00,175.00,0.00,175.00),(441,440,'1',29.95,0.00,0.00,29.95,0.00,29.95),(442,441,'1',49.95,0.00,0.00,49.95,0.00,49.95),(443,442,'1',19.95,0.00,0.00,19.95,0.00,19.95),(444,443,'1',49.95,0.00,0.00,49.95,0.00,49.95),(445,444,'1',14.95,0.00,0.00,14.95,0.00,14.95),(446,445,'1',49.95,0.00,0.00,49.95,0.00,49.95),(447,446,'1',49.95,0.00,0.00,49.95,0.00,49.95),(449,448,'1',39.95,0.00,0.00,39.95,0.00,39.95),(450,449,'1',61.95,0.00,0.00,61.95,0.00,61.95),(451,450,'1',39.95,0.00,0.00,39.95,0.00,39.95),(452,451,'1',63.95,0.00,0.00,63.95,0.00,63.95),(453,452,'1',175.00,0.00,0.00,175.00,0.00,175.00),(455,454,'1',49.95,0.00,0.00,49.95,0.00,49.95),(456,455,'1',49.95,0.00,0.00,49.95,0.00,49.95),(457,456,'1',49.95,0.00,0.00,49.95,0.00,49.95),(458,457,'1',73.95,0.00,0.00,73.95,0.00,73.95),(459,458,'1',49.95,0.00,0.00,49.95,0.00,49.95),(460,459,'1',49.95,0.00,0.00,49.95,0.00,49.95),(715,714,'1',63.95,0.00,0.00,63.95,0.00,63.95),(462,461,'1',49.95,0.00,0.00,49.95,0.00,49.95),(696,695,'1',63.95,0.00,0.00,63.95,0.00,63.95),(516,515,'1',39.95,0.00,0.00,39.95,0.00,39.95),(517,516,'1',63.95,0.00,0.00,63.95,0.00,63.95),(518,517,'1',175.00,0.00,0.00,175.00,0.00,175.00),(519,518,'1',49.95,0.00,0.00,49.95,0.00,49.95),(520,519,'1',49.95,0.00,0.00,49.95,0.00,49.95),(521,520,'1',49.95,0.00,0.00,49.95,0.00,49.95),(522,521,'1',73.95,0.00,0.00,73.95,0.00,73.95),(523,522,'1',49.95,0.00,0.00,49.95,0.00,49.95),(524,523,'1',49.95,0.00,0.00,49.95,0.00,49.95),(714,713,'1',39.95,0.00,0.00,39.95,0.00,39.95),(526,525,'1',49.95,0.00,0.00,49.95,0.00,49.95),(695,694,'1',39.95,0.00,0.00,39.95,0.00,39.95),(528,527,'1',29.95,0.00,0.00,29.95,0.00,29.95),(529,528,'1',359.40,0.00,0.00,359.40,0.00,359.40),(725,724,'1',29.95,0.00,0.00,29.95,0.00,29.95),(531,530,'1',49.95,0.00,0.00,49.95,0.00,49.95),(532,531,'1',19.95,0.00,0.00,19.95,0.00,19.95),(533,532,'1',49.95,0.00,0.00,49.95,0.00,49.95),(534,533,'1',14.95,0.00,0.00,14.95,0.00,14.95),(535,534,'1',49.95,0.00,0.00,49.95,0.00,49.95),(536,535,'1',49.95,0.00,0.00,49.95,0.00,49.95),(537,536,'1',39.95,0.00,0.00,39.95,0.00,39.95),(538,537,'1',61.95,0.00,0.00,61.95,0.00,61.95),(539,538,'1',NULL,NULL,NULL,NULL,NULL,NULL),(540,539,'1',39.95,0.00,0.00,39.95,0.00,39.95),(541,540,'1',63.95,0.00,0.00,63.95,0.00,63.95),(542,541,'1',175.00,0.00,0.00,175.00,0.00,175.00),(543,542,'1',49.95,0.00,0.00,49.95,0.00,49.95),(544,543,'1',49.95,0.00,0.00,49.95,0.00,49.95),(545,544,'1',49.95,0.00,0.00,49.95,0.00,49.95),(546,545,'1',73.95,0.00,0.00,73.95,0.00,73.95),(547,546,'1',49.95,0.00,0.00,49.95,0.00,49.95),(548,547,'1',49.95,0.00,0.00,49.95,0.00,49.95),(713,712,'1',61.95,0.00,0.00,61.95,0.00,61.95),(550,549,'1',359.40,0.00,0.00,359.40,0.00,359.40),(551,550,'1',49.95,0.00,0.00,49.95,0.00,49.95),(694,693,'1',61.95,0.00,0.00,61.95,0.00,61.95),(553,552,'1',419.40,0.00,0.00,419.40,0.00,419.40),(554,553,'1',29.95,0.00,0.00,29.95,0.00,29.95),(555,554,'1',49.95,0.00,0.00,49.95,0.00,49.95),(556,555,'1',19.95,0.00,0.00,19.95,0.00,19.95),(557,556,'1',49.95,0.00,0.00,49.95,0.00,49.95),(558,557,'1',14.95,0.00,0.00,14.95,0.00,14.95),(559,558,'1',49.95,0.00,0.00,49.95,0.00,49.95),(560,559,'1',49.95,0.00,0.00,49.95,0.00,49.95),(561,560,'1',39.95,0.00,0.00,39.95,0.00,39.95),(562,561,'1',61.95,0.00,0.00,61.95,0.00,61.95),(563,562,'1',39.95,0.00,0.00,39.95,0.00,39.95),(564,563,'1',63.95,0.00,0.00,63.95,0.00,63.95),(565,564,'1',175.00,0.00,0.00,175.00,0.00,175.00),(566,565,'1',49.95,0.00,0.00,49.95,0.00,49.95),(567,566,'1',49.95,0.00,0.00,49.95,0.00,49.95),(568,567,'1',49.95,0.00,0.00,49.95,0.00,49.95),(569,568,'1',73.95,0.00,0.00,73.95,0.00,73.95),(570,569,'1',49.95,0.00,0.00,49.95,0.00,49.95),(571,570,'1',49.95,0.00,0.00,49.95,0.00,49.95),(712,711,'1',39.95,0.00,0.00,39.95,0.00,39.95),(573,572,'1',49.95,0.00,0.00,49.95,0.00,49.95),(693,692,'1',39.95,0.00,0.00,39.95,0.00,39.95),(724,723,'1',49.95,0.00,0.00,49.95,0.00,49.95),(576,575,'1',29.95,0.00,0.00,29.95,0.00,29.95),(577,576,'1',49.95,0.00,0.00,49.95,0.00,49.95),(578,577,'1',19.95,0.00,0.00,19.95,0.00,19.95),(579,578,'1',49.95,0.00,0.00,49.95,0.00,49.95),(580,579,'1',14.95,0.00,0.00,14.95,0.00,14.95),(581,580,'1',49.95,0.00,0.00,49.95,0.00,49.95),(582,581,'1',49.95,0.00,0.00,49.95,0.00,49.95),(583,582,'1',39.95,0.00,0.00,39.95,0.00,39.95),(584,583,'1',61.95,0.00,0.00,61.95,0.00,61.95),(585,584,'1',39.95,0.00,0.00,39.95,0.00,39.95),(586,585,'1',63.95,0.00,0.00,63.95,0.00,63.95),(587,586,'1',175.00,0.00,0.00,175.00,0.00,175.00),(588,587,'1',49.95,0.00,0.00,49.95,0.00,49.95),(589,588,'1',49.95,0.00,0.00,49.95,0.00,49.95),(590,589,'1',199.95,0.00,0.00,199.95,0.00,199.95),(591,590,'1',49.95,0.00,0.00,49.95,0.00,49.95),(592,591,'1',49.95,0.00,0.00,49.95,0.00,49.95),(593,592,'1',49.95,0.00,0.00,49.95,0.00,49.95),(711,710,'1',61.95,0.00,0.00,61.95,0.00,61.95),(595,594,'1',49.95,0.00,0.00,49.95,0.00,49.95),(692,691,'1',49.95,0.00,0.00,49.95,0.00,49.95),(597,596,'1',29.95,0.00,0.00,29.95,0.00,29.95),(598,597,'1',49.95,0.00,0.00,49.95,0.00,49.95),(599,598,'1',19.95,0.00,0.00,19.95,0.00,19.95),(600,599,'1',49.95,0.00,0.00,49.95,0.00,49.95),(601,600,'1',14.95,0.00,0.00,14.95,0.00,14.95),(602,601,'1',49.95,0.00,0.00,49.95,0.00,49.95),(603,602,'1',49.95,0.00,0.00,49.95,0.00,49.95),(604,603,'1',39.95,0.00,0.00,39.95,0.00,39.95),(605,604,'1',61.95,0.00,0.00,61.95,0.00,61.95),(606,605,'1',39.95,0.00,0.00,39.95,0.00,39.95),(607,606,'1',63.95,0.00,0.00,63.95,0.00,63.95),(608,607,'1',175.00,0.00,0.00,175.00,0.00,175.00),(609,608,'1',49.95,0.00,0.00,49.95,0.00,49.95),(610,609,'1',49.95,0.00,0.00,49.95,0.00,49.95),(611,610,'1',49.95,0.00,0.00,49.95,0.00,49.95),(612,611,'1',73.95,0.00,0.00,73.95,0.00,73.95),(613,612,'1',49.95,0.00,0.00,49.95,0.00,49.95),(614,613,'1',49.95,0.00,0.00,49.95,0.00,49.95),(710,709,'1',39.95,0.00,0.00,39.95,0.00,39.95),(616,615,'1',49.95,0.00,0.00,49.95,0.00,49.95),(691,690,'1',49.95,0.00,0.00,49.95,0.00,49.95),(618,617,'1',29.95,0.00,0.00,29.95,0.00,29.95),(619,618,'1',49.95,0.00,0.00,49.95,0.00,49.95),(620,619,'1',19.95,0.00,0.00,19.95,0.00,19.95),(621,620,'1',49.95,0.00,0.00,49.95,0.00,49.95),(622,621,'1',14.95,0.00,0.00,14.95,0.00,14.95),(623,622,'1',49.95,0.00,0.00,49.95,0.00,49.95),(624,623,'1',49.95,0.00,0.00,49.95,0.00,49.95),(625,624,'1',39.95,0.00,0.00,39.95,0.00,39.95),(626,625,'1',61.95,0.00,0.00,61.95,0.00,61.95),(627,626,'1',39.95,0.00,0.00,39.95,0.00,39.95),(628,627,'1',63.95,0.00,0.00,63.95,0.00,63.95),(629,628,'1',175.00,0.00,0.00,175.00,0.00,175.00),(630,629,'1',49.95,0.00,0.00,49.95,0.00,49.95),(631,630,'1',49.95,0.00,0.00,49.95,0.00,49.95),(632,631,'1',49.95,0.00,0.00,49.95,0.00,49.95),(633,632,'1',73.95,0.00,0.00,73.95,0.00,73.95),(634,633,'1',49.95,0.00,0.00,49.95,0.00,49.95),(635,634,'1',49.95,0.00,0.00,49.95,0.00,49.95),(709,708,'1',49.95,0.00,0.00,49.95,0.00,49.95),(637,636,'1',49.95,0.00,0.00,49.95,0.00,49.95),(690,689,'1',NULL,NULL,NULL,NULL,NULL,NULL),(639,638,'1',29.95,0.00,0.00,29.95,0.00,29.95),(640,639,'1',49.95,0.00,0.00,49.95,0.00,49.95),(641,640,'1',160.00,0.00,0.00,160.00,0.00,160.00),(642,641,'1',19.95,0.00,0.00,19.95,0.00,19.95),(644,643,'1',49.95,0.00,0.00,49.95,0.00,49.95),(645,644,'1',14.95,0.00,0.00,14.95,0.00,14.95),(646,645,'1',49.95,0.00,0.00,49.95,0.00,49.95),(647,646,'1',49.95,0.00,0.00,49.95,0.00,49.95),(648,647,'1',39.95,0.00,0.00,39.95,0.00,39.95),(650,649,'1',61.95,0.00,0.00,61.95,0.00,61.95),(651,650,'1',39.95,0.00,0.00,39.95,0.00,39.95),(652,651,'1',63.95,0.00,0.00,63.95,0.00,63.95),(653,652,'1',175.00,0.00,0.00,175.00,0.00,175.00),(654,653,'1',49.95,0.00,0.00,49.95,0.00,49.95),(655,654,'1',49.95,0.00,0.00,49.95,0.00,49.95),(656,655,'1',49.95,0.00,0.00,49.95,0.00,49.95),(657,656,'1',73.95,0.00,0.00,73.95,0.00,73.95),(658,657,'1',49.95,0.00,0.00,49.95,0.00,49.95),(659,658,'1',49.95,0.00,0.00,49.95,0.00,49.95),(708,707,'1',49.95,0.00,0.00,49.95,0.00,49.95),(661,660,'1',49.95,0.00,0.00,49.95,0.00,49.95),(689,688,'1',1495.00,0.00,0.00,1495.00,0.00,1495.00),(685,684,'1',29.95,0.00,0.00,29.95,0.00,29.95),(665,664,'1',29.95,0.00,0.00,29.95,0.00,29.95),(666,665,'1',49.95,0.00,0.00,49.95,0.00,49.95),(667,666,'1',19.95,0.00,0.00,19.95,0.00,19.95),(668,667,'1',49.95,0.00,0.00,49.95,0.00,49.95),(669,668,'1',14.95,0.00,0.00,14.95,0.00,14.95),(670,669,'1',49.95,0.00,0.00,49.95,0.00,49.95),(671,670,'1',49.95,0.00,0.00,49.95,0.00,49.95),(672,671,'1',39.95,0.00,0.00,39.95,0.00,39.95),(673,672,'1',61.95,0.00,0.00,61.95,0.00,61.95),(674,673,'1',39.95,0.00,0.00,39.95,0.00,39.95),(675,674,'1',67.95,0.00,0.00,67.95,0.00,67.95),(676,675,'1',175.00,0.00,0.00,175.00,0.00,175.00),(677,676,'1',49.95,0.00,0.00,49.95,0.00,49.95),(678,677,'1',49.95,0.00,0.00,49.95,0.00,49.95),(679,678,'1',49.95,0.00,0.00,49.95,0.00,49.95),(680,679,'1',73.95,0.00,0.00,73.95,0.00,73.95),(681,680,'1',49.95,0.00,0.00,49.95,0.00,49.95),(682,681,'1',49.95,0.00,0.00,49.95,0.00,49.95),(683,682,'1',49.95,0.00,0.00,49.95,0.00,49.95),(688,687,'1',49.95,0.00,0.00,49.95,0.00,49.95),(728,727,'1',14.95,0.00,0.00,14.95,0.00,14.95),(729,728,'1',49.95,0.00,0.00,49.95,0.00,49.95),(730,729,'1',49.95,0.00,0.00,49.95,0.00,49.95),(731,730,'1',39.95,0.00,0.00,39.95,0.00,39.95),(732,731,'1',61.95,0.00,0.00,61.95,0.00,61.95),(733,732,'1',39.95,0.00,0.00,39.95,0.00,39.95),(734,733,'1',175.00,0.00,0.00,175.00,0.00,175.00),(735,734,'1',49.95,0.00,0.00,49.95,0.00,49.95),(737,736,'1',49.95,0.00,0.00,49.95,0.00,49.95),(738,737,'1',49.95,0.00,0.00,49.95,0.00,49.95),(739,738,'1',73.95,0.00,0.00,73.95,0.00,73.95),(740,739,'1',63.95,0.00,0.00,63.95,0.00,63.95),(741,740,'1',49.95,0.00,0.00,49.95,0.00,49.95),(742,741,'1',49.95,0.00,0.00,49.95,0.00,49.95),(743,742,'1',49.95,0.00,0.00,49.95,0.00,49.95),(744,743,'1',29.95,0.00,0.00,29.95,0.00,29.95),(745,744,'1',49.95,0.00,0.00,49.95,0.00,49.95),(746,745,'1',49.95,0.00,0.00,49.95,0.00,49.95),(747,746,'1',0.00,0.00,0.00,0.00,0.00,0.00),(748,747,'1',49.95,0.00,0.00,49.95,0.00,49.95),(749,748,'1',49.95,0.00,0.00,49.95,0.00,49.95),(750,749,'1',39.95,0.00,0.00,39.95,0.00,39.95),(751,750,'1',61.95,0.00,0.00,61.95,0.00,61.95),(752,751,'1',39.95,0.00,0.00,39.95,0.00,39.95),(753,752,'1',63.95,0.00,0.00,63.95,0.00,63.95),(754,753,'1',175.00,0.00,0.00,175.00,0.00,175.00),(755,754,'1',49.95,0.00,0.00,49.95,0.00,49.95),(756,755,'1',49.95,0.00,0.00,49.95,0.00,49.95),(757,756,'1',49.95,0.00,0.00,49.95,0.00,49.95),(758,757,'1',73.95,0.00,0.00,73.95,0.00,73.95),(759,758,'1',49.95,0.00,0.00,49.95,0.00,49.95),(760,759,'1',49.95,0.00,0.00,49.95,0.00,49.95),(761,760,'1',49.95,0.00,0.00,49.95,0.00,49.95);

--
-- 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=6 DEFAULT CHARSET=utf8;

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

INSERT INTO `ip_invoice_groups` VALUES (3,'Invoice Default','{{{id}}}',7555,0),(4,'Quote Default','QUO{{{id}}}',8,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=719 DEFAULT CHARSET=utf8;

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

INSERT INTO `ip_invoice_item_amounts` VALUES (9,9,19.95,0.00,0.00,19.95),(7,7,29.95,0.00,0.00,29.95),(8,8,49.95,0.00,0.00,49.95),(474,474,49.95,0.00,0.00,49.95),(479,479,175.00,0.00,0.00,175.00),(12,12,49.95,0.00,0.00,49.95),(13,13,14.95,0.00,0.00,14.95),(14,14,49.95,0.00,0.00,49.95),(20,20,61.95,0.00,0.00,61.95),(681,681,49.95,0.00,0.00,49.95),(17,17,55.95,0.00,0.00,55.95),(18,18,49.95,0.00,0.00,49.95),(457,457,63.95,0.00,0.00,63.95),(22,22,49.95,0.00,0.00,49.95),(680,680,49.95,0.00,0.00,49.95),(24,24,49.95,0.00,0.00,49.95),(25,25,49.95,0.00,0.00,49.95),(26,26,49.95,0.00,0.00,49.95),(27,27,49.95,0.00,0.00,49.95),(28,28,49.95,0.00,0.00,49.95),(29,29,37.95,0.00,0.00,37.95),(30,30,96.00,0.00,0.00,96.00),(32,32,168.00,0.00,0.00,168.00),(33,33,359.40,0.00,0.00,359.40),(34,34,359.40,0.00,0.00,359.40),(645,645,49.95,0.00,0.00,49.95),(36,36,419.40,0.00,0.00,419.40),(37,37,39.95,0.00,0.00,39.95),(39,39,29.95,0.00,0.00,29.95),(40,40,49.95,0.00,0.00,49.95),(41,41,19.95,0.00,0.00,19.95),(473,473,49.95,0.00,0.00,49.95),(478,478,63.95,0.00,0.00,63.95),(44,44,49.95,0.00,0.00,49.95),(45,45,14.95,0.00,0.00,14.95),(46,46,49.95,0.00,0.00,49.95),(47,47,39.95,0.00,0.00,39.95),(48,48,61.95,0.00,0.00,61.95),(464,464,49.95,0.00,0.00,49.95),(50,50,37.95,0.00,0.00,37.95),(52,52,59.95,0.00,0.00,59.95),(53,53,49.95,0.00,0.00,49.95),(456,456,39.95,0.00,0.00,39.95),(55,55,49.95,0.00,0.00,49.95),(56,56,49.95,0.00,0.00,49.95),(57,57,49.95,0.00,0.00,49.95),(58,58,49.95,0.00,0.00,49.95),(59,59,49.95,0.00,0.00,49.95),(60,60,49.95,0.00,0.00,49.95),(68,68,49.95,0.00,0.00,49.95),(62,62,49.95,0.00,0.00,49.95),(63,63,39.95,0.00,0.00,39.95),(472,472,14.95,0.00,0.00,14.95),(477,477,39.95,0.00,0.00,39.95),(66,66,49.95,0.00,0.00,49.95),(67,67,14.95,0.00,0.00,14.95),(463,463,49.95,0.00,0.00,49.95),(70,70,49.95,0.00,0.00,49.95),(71,71,49.95,0.00,0.00,49.95),(72,72,49.95,0.00,0.00,49.95),(73,73,49.95,0.00,0.00,49.95),(75,75,49.95,0.00,0.00,49.95),(76,76,49.95,0.00,0.00,49.95),(455,455,61.95,0.00,0.00,61.95),(79,79,49.95,0.00,0.00,49.95),(80,80,59.95,0.00,0.00,59.95),(81,81,37.95,0.00,0.00,37.95),(82,82,61.95,0.00,0.00,61.95),(83,83,39.95,0.00,0.00,39.95),(84,84,29.95,0.00,0.00,29.95),(85,85,39.95,0.00,0.00,39.95),(86,86,61.95,0.00,0.00,61.95),(87,87,39.95,0.00,0.00,39.95),(88,88,59.95,0.00,0.00,59.95),(89,89,49.95,0.00,0.00,49.95),(454,454,39.95,0.00,0.00,39.95),(92,92,49.95,0.00,0.00,49.95),(93,93,49.95,0.00,0.00,49.95),(94,94,49.95,0.00,0.00,49.95),(95,95,49.95,0.00,0.00,49.95),(96,96,49.95,0.00,0.00,49.95),(97,97,49.95,0.00,0.00,49.95),(462,462,73.95,0.00,0.00,73.95),(99,99,49.95,0.00,0.00,49.95),(100,100,14.95,0.00,0.00,14.95),(476,476,61.95,0.00,0.00,61.95),(102,102,49.95,0.00,0.00,49.95),(471,471,49.95,0.00,0.00,49.95),(104,104,39.95,0.00,0.00,39.95),(105,105,49.95,0.00,0.00,49.95),(106,106,29.95,0.00,0.00,29.95),(107,107,49.95,0.00,0.00,49.95),(108,108,39.95,0.00,0.00,39.95),(470,470,19.95,0.00,0.00,19.95),(475,475,39.95,0.00,0.00,39.95),(111,111,49.95,0.00,0.00,49.95),(112,112,14.95,0.00,0.00,14.95),(113,113,49.95,0.00,0.00,49.95),(114,114,39.95,0.00,0.00,39.95),(115,115,61.95,0.00,0.00,61.95),(116,116,39.95,0.00,0.00,39.95),(461,461,49.95,0.00,0.00,49.95),(118,118,59.95,0.00,0.00,59.95),(119,119,49.95,0.00,0.00,49.95),(453,453,49.95,0.00,0.00,49.95),(452,452,49.95,0.00,0.00,49.95),(122,122,49.95,0.00,0.00,49.95),(123,123,49.95,0.00,0.00,49.95),(124,124,49.95,0.00,0.00,49.95),(125,125,49.95,0.00,0.00,49.95),(126,126,49.95,0.00,0.00,49.95),(127,127,49.95,0.00,0.00,49.95),(429,429,49.95,0.00,0.00,49.95),(428,428,19.95,0.00,0.00,19.95),(131,131,29.95,0.00,0.00,29.95),(132,132,49.95,0.00,0.00,49.95),(133,133,39.95,0.00,0.00,39.95),(469,469,49.95,0.00,0.00,49.95),(135,135,49.95,0.00,0.00,49.95),(136,136,14.95,0.00,0.00,14.95),(137,137,49.95,0.00,0.00,49.95),(138,138,39.95,0.00,0.00,39.95),(139,139,61.95,0.00,0.00,61.95),(140,140,39.95,0.00,0.00,39.95),(460,460,49.95,0.00,0.00,49.95),(142,142,59.95,0.00,0.00,59.95),(143,143,49.95,0.00,0.00,49.95),(451,451,14.95,0.00,0.00,14.95),(145,145,49.95,0.00,0.00,49.95),(146,146,49.95,0.00,0.00,49.95),(147,147,49.95,0.00,0.00,49.95),(148,148,49.95,0.00,0.00,49.95),(149,149,49.95,0.00,0.00,49.95),(150,150,49.95,0.00,0.00,49.95),(443,443,49.95,0.00,0.00,49.95),(665,665,14.95,0.00,0.00,14.95),(153,153,49.95,0.00,0.00,49.95),(154,154,29.95,0.00,0.00,29.95),(155,155,49.95,0.00,0.00,49.95),(156,156,39.95,0.00,0.00,39.95),(468,468,29.95,0.00,0.00,29.95),(158,158,49.95,0.00,0.00,49.95),(159,159,14.95,0.00,0.00,14.95),(160,160,49.95,0.00,0.00,49.95),(161,161,49.95,0.00,0.00,49.95),(162,162,49.95,0.00,0.00,49.95),(163,163,61.95,0.00,0.00,61.95),(164,164,39.95,0.00,0.00,39.95),(459,459,49.95,0.00,0.00,49.95),(166,166,59.95,0.00,0.00,59.95),(167,167,49.95,0.00,0.00,49.95),(450,450,49.95,0.00,0.00,49.95),(169,169,49.95,0.00,0.00,49.95),(170,170,49.95,0.00,0.00,49.95),(171,171,49.95,0.00,0.00,49.95),(442,442,49.95,0.00,0.00,49.95),(173,173,49.95,0.00,0.00,49.95),(174,174,49.95,0.00,0.00,49.95),(175,175,49.95,0.00,0.00,49.95),(664,664,49.95,0.00,0.00,49.95),(177,177,0.00,0.00,0.00,0.00),(178,178,29.95,0.00,0.00,29.95),(179,179,49.95,0.00,0.00,49.95),(180,180,39.95,0.00,0.00,39.95),(467,467,49.95,0.00,0.00,49.95),(182,182,49.95,0.00,0.00,49.95),(183,183,14.95,0.00,0.00,14.95),(184,184,49.95,0.00,0.00,49.95),(185,185,49.95,0.00,0.00,49.95),(186,186,39.95,0.00,0.00,39.95),(187,187,61.95,0.00,0.00,61.95),(188,188,59.95,0.00,0.00,59.95),(189,189,49.95,0.00,0.00,49.95),(449,449,19.95,0.00,0.00,19.95),(191,191,49.95,0.00,0.00,49.95),(192,192,49.95,0.00,0.00,49.95),(193,193,49.95,0.00,0.00,49.95),(441,441,73.95,0.00,0.00,73.95),(195,195,49.95,0.00,0.00,49.95),(196,196,49.95,0.00,0.00,49.95),(197,197,49.95,0.00,0.00,49.95),(663,663,29.95,0.00,0.00,29.95),(199,199,29.95,0.00,0.00,29.95),(200,200,49.95,0.00,0.00,49.95),(201,201,19.95,0.00,0.00,19.95),(466,466,49.95,0.00,0.00,49.95),(203,203,49.95,0.00,0.00,49.95),(204,204,14.95,0.00,0.00,14.95),(205,205,49.95,0.00,0.00,49.95),(206,206,49.95,0.00,0.00,49.95),(207,207,39.95,0.00,0.00,39.95),(208,208,61.95,0.00,0.00,61.95),(458,458,175.00,0.00,0.00,175.00),(210,210,59.95,0.00,0.00,59.95),(211,211,49.95,0.00,0.00,49.95),(447,447,49.95,0.00,0.00,49.95),(213,213,49.95,0.00,0.00,49.95),(214,214,49.95,0.00,0.00,49.95),(215,215,49.95,0.00,0.00,49.95),(440,440,49.95,0.00,0.00,49.95),(217,217,49.95,0.00,0.00,49.95),(218,218,49.95,0.00,0.00,49.95),(219,219,49.95,0.00,0.00,49.95),(662,662,49.95,0.00,0.00,49.95),(221,221,29.95,0.00,0.00,29.95),(222,222,49.95,0.00,0.00,49.95),(223,223,19.95,0.00,0.00,19.95),(224,224,14.95,0.00,0.00,14.95),(684,684,49.95,0.00,0.00,49.95),(226,226,359.40,0.00,0.00,359.40),(227,227,49.95,0.00,0.00,49.95),(228,228,49.95,0.00,0.00,49.95),(229,229,39.95,0.00,0.00,39.95),(230,230,61.95,0.00,0.00,61.95),(231,231,39.95,0.00,0.00,39.95),(232,232,59.95,0.00,0.00,59.95),(233,233,49.95,0.00,0.00,49.95),(446,446,29.95,0.00,0.00,29.95),(235,235,49.95,0.00,0.00,49.95),(236,236,49.95,0.00,0.00,49.95),(237,237,49.95,0.00,0.00,49.95),(439,439,49.95,0.00,0.00,49.95),(239,239,49.95,0.00,0.00,49.95),(240,240,49.95,0.00,0.00,49.95),(241,241,359.40,0.00,0.00,359.40),(242,242,49.95,0.00,0.00,49.95),(661,661,49.95,0.00,0.00,49.95),(644,644,29.95,0.00,0.00,29.95),(245,245,419.40,0.00,0.00,419.40),(427,427,49.95,0.00,0.00,49.95),(426,426,29.95,0.00,0.00,29.95),(248,248,29.95,0.00,0.00,29.95),(249,249,49.95,0.00,0.00,49.95),(250,250,19.95,0.00,0.00,19.95),(251,251,49.95,0.00,0.00,49.95),(252,252,14.95,0.00,0.00,14.95),(253,253,49.95,0.00,0.00,49.95),(254,254,49.95,0.00,0.00,49.95),(255,255,39.95,0.00,0.00,39.95),(256,256,61.95,0.00,0.00,61.95),(257,257,39.95,0.00,0.00,39.95),(258,258,59.95,0.00,0.00,59.95),(259,259,49.95,0.00,0.00,49.95),(445,445,49.95,0.00,0.00,49.95),(261,261,49.95,0.00,0.00,49.95),(262,262,49.95,0.00,0.00,49.95),(263,263,49.95,0.00,0.00,49.95),(438,438,49.95,0.00,0.00,49.95),(265,265,49.95,0.00,0.00,49.95),(266,266,49.95,0.00,0.00,49.95),(267,267,49.95,0.00,0.00,49.95),(268,268,49.95,0.00,0.00,49.95),(660,660,49.95,0.00,0.00,49.95),(274,274,19.95,0.00,0.00,19.95),(275,275,49.95,0.00,0.00,49.95),(272,272,29.95,0.00,0.00,29.95),(273,273,49.95,0.00,0.00,49.95),(276,276,14.95,0.00,0.00,14.95),(277,277,49.95,0.00,0.00,49.95),(278,278,49.95,0.00,0.00,49.95),(279,279,39.95,0.00,0.00,39.95),(280,280,61.95,0.00,0.00,61.95),(281,281,39.95,0.00,0.00,39.95),(282,282,59.95,0.00,0.00,59.95),(283,283,49.95,0.00,0.00,49.95),(284,284,49.95,0.00,0.00,49.95),(285,285,49.95,0.00,0.00,49.95),(286,286,49.95,0.00,0.00,49.95),(437,437,175.00,0.00,0.00,175.00),(288,288,49.95,0.00,0.00,49.95),(289,289,49.95,0.00,0.00,49.95),(290,290,49.95,0.00,0.00,49.95),(679,679,49.95,0.00,0.00,49.95),(432,432,99.90,0.00,0.00,99.90),(293,293,29.95,0.00,0.00,29.95),(294,294,49.95,0.00,0.00,49.95),(295,295,49.95,0.00,0.00,49.95),(296,296,14.95,0.00,0.00,14.95),(297,297,49.95,0.00,0.00,49.95),(298,298,49.95,0.00,0.00,49.95),(299,299,39.95,0.00,0.00,39.95),(300,300,19.95,0.00,0.00,19.95),(301,301,61.95,0.00,0.00,61.95),(302,302,39.95,0.00,0.00,39.95),(303,303,59.95,0.00,0.00,59.95),(304,304,49.95,0.00,0.00,49.95),(305,305,49.95,0.00,0.00,49.95),(306,306,49.95,0.00,0.00,49.95),(307,307,49.95,0.00,0.00,49.95),(436,436,63.95,0.00,0.00,63.95),(309,309,49.95,0.00,0.00,49.95),(310,310,49.95,0.00,0.00,49.95),(678,678,73.95,0.00,0.00,73.95),(431,431,49.95,0.00,0.00,49.95),(313,313,49.95,0.00,0.00,49.95),(659,659,73.95,0.00,0.00,73.95),(317,317,29.95,0.00,0.00,29.95),(318,318,49.95,0.00,0.00,49.95),(319,319,19.95,0.00,0.00,19.95),(320,320,49.95,0.00,0.00,49.95),(321,321,14.95,0.00,0.00,14.95),(322,322,49.95,0.00,0.00,49.95),(323,323,49.95,0.00,0.00,49.95),(325,325,39.95,0.00,0.00,39.95),(326,326,61.95,0.00,0.00,61.95),(327,327,39.95,0.00,0.00,39.95),(328,328,59.95,0.00,0.00,59.95),(329,329,49.95,0.00,0.00,49.95),(330,330,49.95,0.00,0.00,49.95),(331,331,49.95,0.00,0.00,49.95),(332,332,49.95,0.00,0.00,49.95),(435,435,39.95,0.00,0.00,39.95),(334,334,49.95,0.00,0.00,49.95),(335,335,49.95,0.00,0.00,49.95),(677,677,49.95,0.00,0.00,49.95),(430,430,14.95,0.00,0.00,14.95),(338,338,49.95,0.00,0.00,49.95),(658,658,49.95,0.00,0.00,49.95),(340,340,175.00,0.00,0.00,175.00),(341,341,29.95,0.00,0.00,29.95),(342,342,49.95,0.00,0.00,49.95),(343,343,19.95,0.00,0.00,19.95),(344,344,49.95,0.00,0.00,49.95),(345,345,14.95,0.00,0.00,14.95),(346,346,49.95,0.00,0.00,49.95),(347,347,49.95,0.00,0.00,49.95),(348,348,39.95,0.00,0.00,39.95),(349,349,61.95,0.00,0.00,61.95),(350,350,39.95,0.00,0.00,39.95),(351,351,59.95,0.00,0.00,59.95),(352,352,175.00,0.00,0.00,175.00),(353,353,49.95,0.00,0.00,49.95),(354,354,49.95,0.00,0.00,49.95),(355,355,49.95,0.00,0.00,49.95),(356,356,49.95,0.00,0.00,49.95),(434,434,61.95,0.00,0.00,61.95),(358,358,49.95,0.00,0.00,49.95),(359,359,49.95,0.00,0.00,49.95),(676,676,49.95,0.00,0.00,49.95),(361,361,49.95,0.00,0.00,49.95),(657,657,49.95,0.00,0.00,49.95),(363,363,29.95,0.00,0.00,29.95),(364,364,49.95,0.00,0.00,49.95),(365,365,19.95,0.00,0.00,19.95),(366,366,49.95,0.00,0.00,49.95),(367,367,49.95,0.00,0.00,49.95),(368,368,49.95,0.00,0.00,49.95),(369,369,14.95,0.00,0.00,14.95),(370,370,39.95,0.00,0.00,39.95),(371,371,61.95,0.00,0.00,61.95),(372,372,39.95,0.00,0.00,39.95),(373,373,59.95,0.00,0.00,59.95),(374,374,175.00,0.00,0.00,175.00),(375,375,49.95,0.00,0.00,49.95),(376,376,49.95,0.00,0.00,49.95),(377,377,49.95,0.00,0.00,49.95),(378,378,49.95,0.00,0.00,49.95),(433,433,39.95,0.00,0.00,39.95),(380,380,49.95,0.00,0.00,49.95),(675,675,49.95,0.00,0.00,49.95),(382,382,49.95,0.00,0.00,49.95),(656,656,49.95,0.00,0.00,49.95),(384,384,29.95,0.00,0.00,29.95),(385,385,49.95,0.00,0.00,49.95),(386,386,19.95,0.00,0.00,19.95),(387,387,49.95,0.00,0.00,49.95),(388,388,14.95,0.00,0.00,14.95),(389,389,49.95,0.00,0.00,49.95),(390,390,49.95,0.00,0.00,49.95),(391,391,39.95,0.00,0.00,39.95),(392,392,61.95,0.00,0.00,61.95),(393,393,59.95,0.00,0.00,59.95),(394,394,175.00,0.00,0.00,175.00),(395,395,49.95,0.00,0.00,49.95),(396,396,49.95,0.00,0.00,49.95),(397,397,49.95,0.00,0.00,49.95),(398,398,49.95,0.00,0.00,49.95),(399,399,49.95,0.00,0.00,49.95),(400,400,49.95,0.00,0.00,49.95),(674,674,175.00,0.00,0.00,175.00),(402,402,49.95,0.00,0.00,49.95),(655,655,175.00,0.00,0.00,175.00),(404,404,29.95,0.00,0.00,29.95),(405,405,49.95,0.00,0.00,49.95),(406,406,19.95,0.00,0.00,19.95),(407,407,49.95,0.00,0.00,49.95),(408,408,14.95,0.00,0.00,14.95),(409,409,49.95,0.00,0.00,49.95),(410,410,49.95,0.00,0.00,49.95),(412,412,39.95,0.00,0.00,39.95),(413,413,61.95,0.00,0.00,61.95),(414,414,39.95,0.00,0.00,39.95),(415,415,63.95,0.00,0.00,63.95),(416,416,175.00,0.00,0.00,175.00),(417,417,49.95,0.00,0.00,49.95),(418,418,49.95,0.00,0.00,49.95),(419,419,49.95,0.00,0.00,49.95),(420,420,73.95,0.00,0.00,73.95),(421,421,49.95,0.00,0.00,49.95),(422,422,49.95,0.00,0.00,49.95),(673,673,63.95,0.00,0.00,63.95),(424,424,49.95,0.00,0.00,49.95),(654,654,63.95,0.00,0.00,63.95),(480,480,49.95,0.00,0.00,49.95),(481,481,49.95,0.00,0.00,49.95),(482,482,49.95,0.00,0.00,49.95),(483,483,73.95,0.00,0.00,73.95),(484,484,49.95,0.00,0.00,49.95),(485,485,49.95,0.00,0.00,49.95),(672,672,39.95,0.00,0.00,39.95),(487,487,49.95,0.00,0.00,49.95),(653,653,39.95,0.00,0.00,39.95),(489,489,29.95,0.00,0.00,29.95),(490,490,359.40,0.00,0.00,359.40),(683,683,29.95,0.00,0.00,29.95),(492,492,49.95,0.00,0.00,49.95),(493,493,19.95,0.00,0.00,19.95),(494,494,49.95,0.00,0.00,49.95),(495,495,14.95,0.00,0.00,14.95),(496,496,49.95,0.00,0.00,49.95),(497,497,49.95,0.00,0.00,49.95),(498,498,39.95,0.00,0.00,39.95),(499,499,61.95,0.00,0.00,61.95),(500,500,39.95,0.00,0.00,39.95),(501,501,63.95,0.00,0.00,63.95),(502,502,175.00,0.00,0.00,175.00),(503,503,49.95,0.00,0.00,49.95),(504,504,49.95,0.00,0.00,49.95),(505,505,49.95,0.00,0.00,49.95),(506,506,73.95,0.00,0.00,73.95),(507,507,49.95,0.00,0.00,49.95),(508,508,49.95,0.00,0.00,49.95),(671,671,61.95,0.00,0.00,61.95),(510,510,359.40,0.00,0.00,359.40),(511,511,49.95,0.00,0.00,49.95),(652,652,61.95,0.00,0.00,61.95),(513,513,419.40,0.00,0.00,419.40),(514,514,29.95,0.00,0.00,29.95),(515,515,49.95,0.00,0.00,49.95),(516,516,19.95,0.00,0.00,19.95),(517,517,49.95,0.00,0.00,49.95),(518,518,14.95,0.00,0.00,14.95),(519,519,49.95,0.00,0.00,49.95),(520,520,49.95,0.00,0.00,49.95),(521,521,39.95,0.00,0.00,39.95),(522,522,61.95,0.00,0.00,61.95),(523,523,39.95,0.00,0.00,39.95),(524,524,63.95,0.00,0.00,63.95),(525,525,175.00,0.00,0.00,175.00),(526,526,49.95,0.00,0.00,49.95),(527,527,49.95,0.00,0.00,49.95),(528,528,49.95,0.00,0.00,49.95),(529,529,73.95,0.00,0.00,73.95),(530,530,49.95,0.00,0.00,49.95),(531,531,49.95,0.00,0.00,49.95),(670,670,39.95,0.00,0.00,39.95),(533,533,49.95,0.00,0.00,49.95),(651,651,39.95,0.00,0.00,39.95),(682,682,49.95,0.00,0.00,49.95),(536,536,29.95,0.00,0.00,29.95),(537,537,49.95,0.00,0.00,49.95),(538,538,19.95,0.00,0.00,19.95),(539,539,49.95,0.00,0.00,49.95),(540,540,14.95,0.00,0.00,14.95),(541,541,49.95,0.00,0.00,49.95),(542,542,49.95,0.00,0.00,49.95),(543,543,39.95,0.00,0.00,39.95),(544,544,61.95,0.00,0.00,61.95),(545,545,39.95,0.00,0.00,39.95),(546,546,63.95,0.00,0.00,63.95),(547,547,175.00,0.00,0.00,175.00),(548,548,49.95,0.00,0.00,49.95),(549,549,49.95,0.00,0.00,49.95),(550,550,49.95,0.00,0.00,49.95),(551,551,150.00,0.00,0.00,150.00),(552,552,49.95,0.00,0.00,49.95),(553,553,49.95,0.00,0.00,49.95),(554,554,49.95,0.00,0.00,49.95),(669,669,61.95,0.00,0.00,61.95),(556,556,49.95,0.00,0.00,49.95),(650,650,49.95,0.00,0.00,49.95),(558,558,29.95,0.00,0.00,29.95),(559,559,49.95,0.00,0.00,49.95),(560,560,19.95,0.00,0.00,19.95),(561,561,49.95,0.00,0.00,49.95),(562,562,14.95,0.00,0.00,14.95),(563,563,49.95,0.00,0.00,49.95),(564,564,49.95,0.00,0.00,49.95),(565,565,39.95,0.00,0.00,39.95),(566,566,61.95,0.00,0.00,61.95),(567,567,39.95,0.00,0.00,39.95),(568,568,63.95,0.00,0.00,63.95),(569,569,175.00,0.00,0.00,175.00),(570,570,49.95,0.00,0.00,49.95),(571,571,49.95,0.00,0.00,49.95),(572,572,49.95,0.00,0.00,49.95),(573,573,73.95,0.00,0.00,73.95),(574,574,49.95,0.00,0.00,49.95),(575,575,49.95,0.00,0.00,49.95),(668,668,39.95,0.00,0.00,39.95),(577,577,49.95,0.00,0.00,49.95),(649,649,49.95,0.00,0.00,49.95),(579,579,29.95,0.00,0.00,29.95),(580,580,49.95,0.00,0.00,49.95),(581,581,19.95,0.00,0.00,19.95),(582,582,49.95,0.00,0.00,49.95),(583,583,14.95,0.00,0.00,14.95),(584,584,49.95,0.00,0.00,49.95),(585,585,49.95,0.00,0.00,49.95),(586,586,39.95,0.00,0.00,39.95),(587,587,61.95,0.00,0.00,61.95),(588,588,39.95,0.00,0.00,39.95),(589,589,63.95,0.00,0.00,63.95),(590,590,175.00,0.00,0.00,175.00),(591,591,49.95,0.00,0.00,49.95),(592,592,49.95,0.00,0.00,49.95),(593,593,49.95,0.00,0.00,49.95),(594,594,73.95,0.00,0.00,73.95),(595,595,49.95,0.00,0.00,49.95),(596,596,49.95,0.00,0.00,49.95),(667,667,49.95,0.00,0.00,49.95),(598,598,49.95,0.00,0.00,49.95),(648,648,1495.00,0.00,0.00,1495.00),(600,600,29.95,0.00,0.00,29.95),(601,601,49.95,0.00,0.00,49.95),(602,602,160.00,0.00,0.00,160.00),(603,603,19.95,0.00,0.00,19.95),(605,605,49.95,0.00,0.00,49.95),(606,606,14.95,0.00,0.00,14.95),(607,607,49.95,0.00,0.00,49.95),(608,608,49.95,0.00,0.00,49.95),(609,609,39.95,0.00,0.00,39.95),(611,611,61.95,0.00,0.00,61.95),(612,612,39.95,0.00,0.00,39.95),(613,613,63.95,0.00,0.00,63.95),(614,614,175.00,0.00,0.00,175.00),(615,615,49.95,0.00,0.00,49.95),(616,616,49.95,0.00,0.00,49.95),(617,617,49.95,0.00,0.00,49.95),(618,618,73.95,0.00,0.00,73.95),(619,619,49.95,0.00,0.00,49.95),(620,620,49.95,0.00,0.00,49.95),(666,666,49.95,0.00,0.00,49.95),(622,622,49.95,0.00,0.00,49.95),(647,647,49.95,0.00,0.00,49.95),(624,624,29.95,0.00,0.00,29.95),(625,625,49.95,0.00,0.00,49.95),(626,626,19.95,0.00,0.00,19.95),(627,627,49.95,0.00,0.00,49.95),(628,628,14.95,0.00,0.00,14.95),(629,629,49.95,0.00,0.00,49.95),(630,630,49.95,0.00,0.00,49.95),(631,631,39.95,0.00,0.00,39.95),(632,632,61.95,0.00,0.00,61.95),(633,633,39.95,0.00,0.00,39.95),(634,634,67.95,0.00,0.00,67.95),(635,635,175.00,0.00,0.00,175.00),(636,636,49.95,0.00,0.00,49.95),(637,637,49.95,0.00,0.00,49.95),(638,638,49.95,0.00,0.00,49.95),(639,639,73.95,0.00,0.00,73.95),(640,640,49.95,0.00,0.00,49.95),(641,641,49.95,0.00,0.00,49.95),(642,642,49.95,0.00,0.00,49.95),(646,646,19.95,0.00,0.00,19.95),(685,685,49.95,0.00,0.00,49.95),(686,686,14.95,0.00,0.00,14.95),(687,687,49.95,0.00,0.00,49.95),(688,688,49.95,0.00,0.00,49.95),(689,689,39.95,0.00,0.00,39.95),(690,690,61.95,0.00,0.00,61.95),(691,691,39.95,0.00,0.00,39.95),(692,692,175.00,0.00,0.00,175.00),(693,693,49.95,0.00,0.00,49.95),(694,694,49.95,0.00,0.00,49.95),(695,695,49.95,0.00,0.00,49.95),(696,696,73.95,0.00,0.00,73.95),(697,697,63.95,0.00,0.00,63.95),(698,698,49.95,0.00,0.00,49.95),(699,699,49.95,0.00,0.00,49.95),(700,700,49.95,0.00,0.00,49.95),(701,701,29.95,0.00,0.00,29.95),(702,702,49.95,0.00,0.00,49.95),(703,703,49.95,0.00,0.00,49.95),(704,704,0.00,0.00,0.00,0.00),(705,705,49.95,0.00,0.00,49.95),(706,706,49.95,0.00,0.00,49.95),(707,707,39.95,0.00,0.00,39.95),(708,708,61.95,0.00,0.00,61.95),(709,709,39.95,0.00,0.00,39.95),(710,710,63.95,0.00,0.00,63.95),(711,711,175.00,0.00,0.00,175.00),(712,712,49.95,0.00,0.00,49.95),(713,713,49.95,0.00,0.00,49.95),(714,714,49.95,0.00,0.00,49.95),(715,715,73.95,0.00,0.00,73.95),(716,716,49.95,0.00,0.00,49.95),(717,717,49.95,0.00,0.00,49.95),(718,718,49.95,0.00,0.00,49.95);

--
-- 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=719 DEFAULT CHARSET=utf8;

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

INSERT INTO `ip_invoice_items` VALUES (9,19,0,'2015-06-05','Servicio de e-mails','',1.00,19.95,0.00,1),(7,17,0,'2015-06-05','Hosting','',1.00,29.95,0.00,1),(8,18,0,'2015-06-05','Hosting and Maintenance','',1.00,49.95,0.00,1),(470,508,0,'2017-02-01','webhosting','',1.00,19.95,0.00,1),(471,509,0,'2017-02-01','web hosting and maintenance','Por favor envie pagos atrasados. Gracias!',1.00,49.95,0.00,1),(12,22,0,'2015-06-05','Hosting and maintenance','',1.00,49.95,0.00,1),(13,23,0,'2015-06-05','Servicio de e-mails','',1.00,14.95,0.00,1),(14,24,0,'2015-06-05','Hosting and maintenance','',1.00,49.95,0.00,1),(461,498,0,'2017-01-03','Web hosting and maintenance','',1.00,49.95,0.00,1),(17,27,0,'2015-06-05','Hosting, maintenance and email service','',1.00,55.95,0.00,1),(18,29,0,'2015-06-05','Hosting and maintenance','',1.00,49.95,0.00,1),(20,31,0,'2015-06-05','Hosting, maintenance and e-mail service','',1.00,61.95,0.00,1),(455,492,0,'2017-01-03','Web hosting and maintenance','',1.00,61.95,0.00,1),(22,33,0,'2015-06-05','Hosting and maintenance','',1.00,49.95,0.00,1),(443,480,0,'2016-12-05','Web hosting and maintenance','',1.00,49.95,0.00,1),(674,715,0,'2017-11-07','Web hosting and maintenance','',1.00,175.00,0.00,1),(445,482,0,'2016-12-05','Web hosting and maintenance','',1.00,49.95,0.00,1),(24,37,0,'2015-06-05','Hosting and maintenance','',1.00,49.95,0.00,1),(25,38,0,'2015-06-05','Hosting and maintenance','',1.00,49.95,0.00,1),(26,41,0,'2015-06-05','Hosting and maintenance','',1.00,49.95,0.00,1),(27,42,0,'2015-06-05','Hosting and maintenance','',1.00,49.95,0.00,1),(28,43,0,'2015-06-05','Hosting and maintenance','',1.00,49.95,0.00,1),(29,44,0,'2015-06-05','Hosting, maintenance and e-mail services','Option #1 \nHosting, maintenance and e-mail services monthly is $29.95 + 8.00=37.95\nor\nHosting, maintenance and e-mail services annually is\n$299.40 + 96.00= $395.40',1.00,37.95,0.00,1),(30,45,0,'2015-06-05','E-mail services','1 email de atommyco.com (4.00)\n1 email de greenheads.com (4.00)\nTotal por el ano es $96.00',1.00,96.00,0.00,1),(32,47,0,'2015-06-09','E-mail service','E-mail service for one year at $14.00 a month.',1.00,168.00,0.00,1),(33,48,0,'2015-06-09','Hosting service for one year','Hosting web site from 5/1/2015 to\n 5/1 2016\n29.95 a month for 12 = 359.40',12.00,29.95,0.00,1),(34,49,0,'2015-06-09','Website hosting','Website hosting from 7/2015 to 7/2016',12.00,29.95,0.00,1),(645,685,0,'2017-10-04','webhosting and maintenance','',1.00,49.95,0.00,1),(646,686,0,'2017-10-04','Hosting and email services','',1.00,19.95,0.00,1),(36,51,0,'2015-06-09','Website hosting','Website hosting for one year:\nFrom 04/01/2015 to 04/01/2016',12.00,34.95,0.00,1),(37,53,0,'2015-06-16','Hosting and maintenance','Monthly price $39.95 for website hosting and maintenance',1.00,39.95,0.00,1),(39,55,0,'2015-07-03','Hosting and maintenance','',1.00,29.95,0.00,1),(40,56,0,'2015-07-03','Hosting and maintenance','',1.00,49.95,0.00,1),(41,58,0,'2015-07-03','Hosting and email service','',1.00,19.95,0.00,1),(469,507,0,'2017-02-01','webhosting and maintenance','',1.00,49.95,0.00,1),(44,61,0,'2015-07-03','Hosting and maintenance','',1.00,49.95,0.00,1),(45,62,0,'2015-07-03','E-mail service','',1.00,14.95,0.00,1),(46,63,0,'2015-07-03','Hosting and maintenance','',1.00,49.95,0.00,1),(47,64,0,'2015-07-03','Hosting and maintenance','',1.00,39.95,0.00,1),(48,65,0,'2015-07-03','Hosting, maintenance, email service','',1.00,61.95,0.00,1),(460,497,0,'2017-01-03','Web hosting and maintenance','',1.00,49.95,0.00,1),(50,67,0,'2015-07-03','Hosting and maintenance','',1.00,37.95,0.00,1),(52,69,0,'2015-07-03','Hosting and emails service','Nuevo servicio de email, $4.00 mensual se ha añadido a la mensualidad.',1.00,59.95,0.00,1),(53,70,0,'2015-07-03','Hosting and maintenance','',1.00,49.95,0.00,1),(454,491,0,'2017-01-03','Web hosting and maintenance','',1.00,39.95,0.00,1),(55,73,0,'2015-07-03','Hosting and maintenance','',1.00,49.95,0.00,1),(56,74,0,'2015-07-03','Hosting and maintenance','',1.00,49.95,0.00,1),(57,75,0,'2015-07-03','Hosting and maintenance','',1.00,49.95,0.00,1),(58,76,0,'2015-07-03','Hosting and maintenance','',1.00,49.95,0.00,1),(59,77,0,'2015-07-03','Hosting and maintenance','',1.00,49.95,0.00,1),(60,78,0,'2015-07-03','Hosting and maintenance','',1.00,49.95,0.00,1),(68,87,0,'2015-07-28','Hosting and maintenance','',1.00,49.95,0.00,1),(62,80,0,'2015-07-28','Hosting and maintenance','',1.00,49.95,0.00,1),(63,81,0,'2015-07-28','Hosting and maintenance','',1.00,39.95,0.00,1),(467,505,0,'2017-01-03','Web hosting and maintenance','',1.00,49.95,0.00,1),(468,506,0,'2017-02-01','website hostibng','',1.00,29.95,0.00,1),(66,84,0,'2015-07-28','Hosting and maintenance','',1.00,49.95,0.00,1),(67,85,0,'2015-07-28','E-mail service','',1.00,14.95,0.00,1),(70,89,0,'2015-07-29','Hosting and maintenance','',1.00,49.95,0.00,1),(71,90,0,'2015-07-29','Hosting and maintenance','',1.00,49.95,0.00,1),(72,91,0,'2015-07-29','Hosting and Maintenance','',1.00,49.95,0.00,1),(73,92,0,'2015-07-29','Hosting and maintenance','',1.00,49.95,0.00,1),(75,94,0,'2015-07-29','Hosting and maintenance','',1.00,49.95,0.00,1),(76,95,0,'2015-07-29','Hosting and maintenance','',1.00,49.95,0.00,1),(79,98,0,'2015-07-29','Hosting and maintenance','',1.00,49.95,0.00,1),(80,99,0,'2015-07-29','Email services','',1.00,59.95,0.00,1),(81,100,0,'2015-07-29','Hosting and maintenance','',1.00,37.95,0.00,1),(82,101,0,'2015-07-29','Hosting, maintenance, email servicews','',1.00,61.95,0.00,1),(83,102,0,'2015-07-29','Hosting and maintenance','',1.00,39.95,0.00,1),(84,103,0,'2015-09-04','Hosting','',1.00,29.95,0.00,1),(85,104,0,'2015-09-04','Hosting and maintenance','',1.00,39.95,0.00,1),(86,105,0,'2015-09-04','Hosting, maintenance, email services','',1.00,61.95,0.00,1),(87,108,0,'2015-09-04','Hosting and maintenance','',1.00,39.95,0.00,1),(88,109,0,'2015-09-04','Hosting and email services','Segun su requerimiento, se añadieron unos servicios a su email. Su factura desde el mes de junio es de $59.95. Solo se esta recibiendo los pagos por $19.95. Por favor envie el pago correcto. De lo contrario cesaremos de darle el servicio. Es el ultimo aviso que le enviamos.',1.00,59.95,0.00,1),(89,110,0,'2015-09-04','Hosting and maintenance','',1.00,49.95,0.00,1),(453,490,0,'2017-01-03','Web hosting and maintenance','',1.00,49.95,0.00,1),(92,113,0,'2015-09-04','Hosting and maintenance','',1.00,49.95,0.00,1),(93,114,0,'2015-09-04','Hosting and maiantenance','',1.00,49.95,0.00,1),(94,115,0,'2015-09-04','Hosting and maintenance','',1.00,49.95,0.00,1),(95,116,0,'2015-09-04','Hosting and maintenance','',1.00,49.95,0.00,1),(96,117,0,'2015-09-04','Hosting and maintenance','',1.00,49.95,0.00,1),(97,118,0,'2015-09-04','Hosting and maintenance','',1.00,49.95,0.00,1),(459,496,0,'2017-01-03','Web hosting and maintenace','',1.00,49.95,0.00,1),(99,120,0,'2015-09-04','Hosting and maintenance','',1.00,49.95,0.00,1),(100,121,0,'2015-09-04','Email services','',1.00,14.95,0.00,1),(102,123,0,'2015-09-04','Hosting and maintenance','',1.00,49.95,0.00,1),(104,125,0,'2015-09-04','Hosting and maintenance','',1.00,39.95,0.00,1),(105,126,0,'2015-09-04','hosting and maintenance','El servicio de hosting and maintenance se les da completamente. Por favor envie el pago por $49.95. Deben una cantidad considerable por los descuentos efectuados en sus pagos sin autorizacion.',1.00,49.95,0.00,1),(106,127,0,'2015-09-28','web hosting and maintenance','',1.00,29.95,0.00,1),(107,128,0,'2015-09-28','web hosting and maintenance','',1.00,49.95,0.00,1),(108,129,0,'2015-09-28','hosting and maintenance','',1.00,39.95,0.00,1),(673,714,0,'2017-11-07','Web hosting and email services','',1.00,63.95,0.00,1),(466,504,0,'2017-01-03','Web hosting and maintenance','',1.00,49.95,0.00,1),(111,132,0,'2015-09-28','Hosting and maintenance','',1.00,49.95,0.00,1),(112,133,0,'2015-09-28','email services','',1.00,14.95,0.00,1),(113,134,0,'2015-09-28','Hosting and maintenance ','',1.00,49.95,0.00,1),(114,135,0,'2015-09-28','Hosting and maintenance','',1.00,39.95,0.00,1),(115,136,0,'2015-09-28','Web hosting and maintenance','',1.00,61.95,0.00,1),(116,137,0,'2015-09-28','Hosting and maintenance','',1.00,39.95,0.00,1),(458,495,0,'2017-01-03','Web hosting and maintenance','',1.00,175.00,0.00,1),(118,139,0,'2015-09-28','Email services and maintenance','',1.00,59.95,0.00,1),(119,140,0,'2015-09-28','Hosting and maintenance','',1.00,49.95,0.00,1),(452,489,0,'2017-01-03','Web hosting and maintenance','',1.00,49.95,0.00,1),(451,488,0,'2017-01-03','Email services','',1.00,14.95,0.00,1),(122,143,0,'2015-09-28','Hosting and maintenance','',1.00,49.95,0.00,1),(123,144,0,'2015-09-28','Hosting and maintenance','',1.00,49.95,0.00,1),(124,145,0,'2015-09-28','Hosting and maintenance','',1.00,49.95,0.00,1),(125,146,0,'2015-09-28','Hosting and maintenance','',1.00,49.95,0.00,1),(126,147,0,'2015-09-28','Hosting and maintenance','',1.00,49.95,0.00,1),(127,148,0,'2015-09-28','Hosting and maintenance','',1.00,49.95,0.00,1),(429,466,0,'2016-12-05','Web hosting and maintenance','',1.00,49.95,0.00,1),(430,467,0,'2016-12-05','e-mails services','',1.00,14.95,0.00,1),(428,465,0,'2016-12-05','E-mail services','',1.00,19.95,0.00,1),(131,152,0,'2015-11-04','web hosting','',1.00,29.95,0.00,1),(132,154,0,'2015-11-04','web hosting and maintenance','Por favor envie la cantidad atrasada. Cada fatura es de $49.95. Se les da todo el servicio y a la vez nuestra firma tiene que pagar por los servicios de server. Es urgente que pague la cantidad completa.',1.00,49.95,0.00,1),(133,155,0,'2015-11-04','Web hosting and maintenance','',1.00,39.95,0.00,1),(464,501,0,'2017-01-03','Web hosting and maintenance','',1.00,49.95,0.00,1),(135,157,0,'2015-11-04','Web hosting and maintenane','',1.00,49.95,0.00,1),(136,158,0,'2015-11-04','Email services','',1.00,14.95,0.00,1),(137,159,0,'2015-11-04','Web hosting and maintenance','',1.00,49.95,0.00,1),(138,160,0,'2015-11-04','Web hosting and maintenance','',1.00,39.95,0.00,1),(139,161,0,'2015-11-04','Web hosting and maintenance','',1.00,61.95,0.00,1),(140,162,0,'2015-11-04','web hosting and maintenance','',1.00,39.95,0.00,1),(457,494,0,'2017-01-03','Web hosting and maintenance','',1.00,63.95,0.00,1),(142,164,0,'2015-11-04','web hosting, maintenance and email services','',1.00,59.95,0.00,1),(143,165,0,'2015-11-04','web hosting and maintenance','',1.00,49.95,0.00,1),(145,167,0,'2015-11-04','web hosting and maintenance','',1.00,49.95,0.00,1),(146,168,0,'2015-11-04','Web hosting and maintenance','',1.00,49.95,0.00,1),(147,169,0,'2015-11-04','web hosting and maintenance','',1.00,49.95,0.00,1),(148,170,0,'2015-11-04','Web hosting and maintenance','',1.00,49.95,0.00,1),(149,171,0,'2015-11-04','Web hosting and maintenance','',1.00,49.95,0.00,1),(150,172,0,'2015-11-04','Web hosting and maintenance','',1.00,49.95,0.00,1),(442,479,0,'2016-12-05','Web hosting and maintenance','',1.00,49.95,0.00,1),(662,703,0,'2017-10-04','Web hosting and maintenance','',1.00,49.95,0.00,1),(153,179,0,'2015-11-23','Web hosting and services','',1.00,49.95,0.00,1),(154,180,0,'2015-12-01','Web hosting','',1.00,29.95,0.00,1),(155,181,0,'2015-12-04','Hosting and maintenance web site','',1.00,49.95,0.00,1),(156,182,0,'2015-12-04','Web site hosting and maintenance','',1.00,39.95,0.00,1),(463,500,0,'2017-01-03','Web hosting and maintenance','',1.00,49.95,0.00,1),(158,184,0,'2015-12-04','Website hosting and maintenance','',1.00,49.95,0.00,1),(159,185,0,'2015-12-04','Email services','',1.00,14.95,0.00,1),(160,186,0,'2015-12-04','Website hosting and maintenance','',1.00,49.95,0.00,1),(161,187,0,'2015-12-04','Website hosting and maintenance','',1.00,49.95,0.00,1),(162,188,0,'2015-12-04','Website hosting and maintenance','',1.00,49.95,0.00,1),(163,189,0,'2015-12-04','Website emails services','',1.00,61.95,0.00,1),(164,190,0,'2015-12-04','Website hosting and maintenance','',1.00,39.95,0.00,1),(456,493,0,'2017-01-03','Web hosting and maintenance','',1.00,39.95,0.00,1),(166,192,0,'2015-12-04','Website hosting and maintenace, email services','',1.00,59.95,0.00,1),(167,193,0,'2015-12-04','Website hosting and maintenance','',1.00,49.95,0.00,1),(449,486,0,'2017-01-03','Web hosting','',1.00,19.95,0.00,1),(169,195,0,'2015-12-04','Website hosting and maintenance','',1.00,49.95,0.00,1),(170,196,0,'2015-12-04','Website hosting and maintenance','',1.00,49.95,0.00,1),(171,197,0,'2015-12-04','Website hosting and maintenance','',1.00,49.95,0.00,1),(441,478,0,'2016-12-05','Web hosting, maintenance, email services','',1.00,73.95,0.00,1),(173,199,0,'2015-12-04','Webhosting and maintenance','',1.00,49.95,0.00,1),(174,200,0,'2015-12-04','Web hosting and maintenance','',1.00,49.95,0.00,1),(175,201,0,'2015-12-04','Web site hosting and maintenance','',1.00,49.95,0.00,1),(177,203,0,'2015-12-30','Hosting of website','',0.00,29.95,0.00,1),(178,204,0,'2015-12-30','Hosting of website','',1.00,29.95,0.00,1),(179,205,0,'2015-12-30','Hosting and maintenance of website','',1.00,49.95,0.00,1),(180,206,0,'2015-12-30','Hosting and maintenance website','',1.00,39.95,0.00,1),(462,499,0,'2017-01-03','Web hosting and maintenance','',1.00,73.95,0.00,1),(182,208,0,'2015-12-30','Hosting and Maintenance','',1.00,49.95,0.00,1),(183,209,0,'2015-12-30','Email services','',1.00,14.95,0.00,1),(184,210,0,'2015-12-30','Hosting and Maintenance website','',1.00,49.95,0.00,1),(185,211,0,'2015-12-30','Hosting and maintenance website','',1.00,49.95,0.00,1),(186,212,0,'2015-12-30','Hosting and maintenance website','',1.00,39.95,0.00,1),(187,213,0,'2015-12-30','Hosting and maintenance website. Email Services','',1.00,61.95,0.00,1),(188,214,0,'2015-12-30','Hosting and email services','',1.00,59.95,0.00,1),(189,215,0,'2015-12-30','Hosting and maintenance website','',1.00,49.95,0.00,1),(450,487,0,'2017-01-03','Web hosting and maintenance','',1.00,49.95,0.00,1),(191,217,0,'2015-12-30','Hosting and maintenance','',1.00,49.95,0.00,1),(192,218,0,'2015-12-30','Hosting and maintenance website','',1.00,49.95,0.00,1),(193,219,0,'2015-12-30','Hosting and maintenance website','',1.00,49.95,0.00,1),(440,477,0,'2016-12-05','Web hosting and maintenance','',1.00,49.95,0.00,1),(195,221,0,'2015-12-30','Website hosting and maintenance','',1.00,49.95,0.00,1),(196,222,0,'2015-12-30','Website hosting and maintenance','',1.00,49.95,0.00,1),(197,223,0,'2015-12-30','Website Hosting and maintenance','',1.00,49.95,0.00,1),(661,702,0,'2017-10-04','Web hosting and maintenance','',1.00,49.95,0.00,1),(199,225,0,'2016-02-03','Hosting','',1.00,29.95,0.00,1),(200,226,0,'2016-02-03','Hosting and maintenance','',1.00,49.95,0.00,1),(201,227,0,'2016-02-03','Hosting','',1.00,19.95,0.00,1),(203,229,0,'2016-02-03','Hosting and maintenance','',1.00,49.95,0.00,1),(204,230,0,'2016-02-03','Email services','',1.00,14.95,0.00,1),(205,232,0,'2016-02-03','Hosting and maintenance','',1.00,49.95,0.00,1),(206,233,0,'2016-02-03','Hosting and maintenance','',1.00,49.95,0.00,1),(207,234,0,'2016-02-03','Hosting and maintenance','',1.00,39.95,0.00,1),(208,235,0,'2016-02-03','Hosting and maintenance','',1.00,61.95,0.00,1),(210,237,0,'2016-02-03','Hosting and maintenance. email services','',1.00,59.95,0.00,1),(211,238,0,'2016-02-03','Hosting and maintenance','',1.00,49.95,0.00,1),(447,484,0,'2017-01-03','Web hosting and maintenance','',1.00,49.95,0.00,1),(213,240,0,'2016-02-03','Hosting and maintenance','',1.00,49.95,0.00,1),(214,241,0,'2016-02-03','Hosting and maintenance','',1.00,49.95,0.00,1),(215,242,0,'2016-02-03','Hosting and Maintenance','',1.00,49.95,0.00,1),(217,244,0,'2016-02-03','Hosting and maintenance','',1.00,49.95,0.00,1),(218,245,0,'2016-02-03','Hosting and maintenance','',1.00,49.95,0.00,1),(219,246,0,'2016-02-03','Hosting and maintenance','',1.00,49.95,0.00,1),(660,701,0,'2017-10-04','Web hosting and maintenance','',1.00,49.95,0.00,1),(221,248,0,'2016-03-01','Web hosting','',1.00,29.95,0.00,1),(222,249,0,'2016-03-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(223,250,0,'2016-03-01','Web hosting','',1.00,19.95,0.00,1),(224,251,0,'2016-03-01','Web hosting','',1.00,14.95,0.00,1),(676,717,0,'2017-11-07','Web hosting and maintenance','',1.00,49.95,0.00,1),(226,253,0,'2016-03-01','Web hosting and maintenance','',12.00,29.95,0.00,1),(227,254,0,'2016-03-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(228,255,0,'2016-03-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(229,256,0,'2016-03-01','Web hosting and maintenance','',1.00,39.95,0.00,1),(230,257,0,'2016-03-01','Web hosting, maintenance, email service','',1.00,61.95,0.00,1),(231,258,0,'2016-03-01','Web hosting and maintenance','',1.00,39.95,0.00,1),(232,259,0,'2016-03-01','Web hosting, maintenance and email service','',1.00,59.95,0.00,1),(233,260,0,'2016-03-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(446,483,0,'2017-01-03','Web hosting','',1.00,29.95,0.00,1),(235,262,0,'2016-03-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(236,263,0,'2016-03-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(237,264,0,'2016-03-01','web hosting and maintenance','',1.00,49.95,0.00,1),(439,476,0,'2016-12-05','Web hosting and maintenance','',1.00,49.95,0.00,1),(239,266,0,'2016-03-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(240,267,0,'2016-03-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(241,268,0,'2016-03-01','Web hosting and maintenance','',12.00,29.95,0.00,1),(242,269,0,'2016-03-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(644,684,0,'2017-10-04','Website hosting','',1.00,29.95,0.00,1),(245,272,0,'2016-03-01','Web hosting and maintenance for one year','',12.00,34.95,0.00,1),(427,464,0,'2016-12-05','Web hosting and maintenance','',1.00,49.95,0.00,1),(426,463,0,'2016-12-05','Web hosting ','',1.00,29.95,0.00,1),(248,274,0,'2016-04-04','Web hosting 1','',1.00,29.95,0.00,1),(249,275,0,'2016-04-04','Web hosting and maintenance','',1.00,49.95,0.00,1),(250,276,0,'2016-04-04','servicios de website y correos','',1.00,19.95,0.00,1),(251,277,0,'2016-04-04','website and maintenance','',1.00,49.95,0.00,1),(252,278,0,'2016-04-04','email services','',1.00,14.95,0.00,1),(253,279,0,'2016-04-04','website and maintenance','',1.00,49.95,0.00,1),(254,280,0,'2016-04-04','website and maintenance','',1.00,49.95,0.00,1),(255,281,0,'2016-04-04','website and maintenance','',1.00,39.95,0.00,1),(256,282,0,'2016-04-04','website, maintenance and email services','',1.00,61.95,0.00,1),(257,283,0,'2016-04-04','website and maintenance','',1.00,39.95,0.00,1),(258,284,0,'2016-04-04','website, maintenance and email services','',1.00,59.95,0.00,1),(259,285,0,'2016-04-04','website and maintenance','',1.00,49.95,0.00,1),(261,287,0,'2016-04-04','website and maintenance','',1.00,49.95,0.00,1),(262,288,0,'2016-04-04','website and maintenance','',1.00,49.95,0.00,1),(263,289,0,'2016-04-04','Website and maintenance','',1.00,49.95,0.00,1),(438,475,0,'2016-12-05','Web hosting and maintenance','',1.00,49.95,0.00,1),(265,291,0,'2016-04-04','website and maintenance','',1.00,49.95,0.00,1),(266,292,0,'2016-04-04','website and maintenance','',1.00,49.95,0.00,1),(267,293,0,'2016-04-04','website and maintenance','',1.00,49.95,0.00,1),(268,294,0,'2016-04-04','website and maintenance','',1.00,49.95,0.00,1),(659,700,0,'2017-10-04','Web hosting, maintenance and email services','',1.00,73.95,0.00,1),(274,302,0,'2016-05-06','Email services','',1.00,19.95,0.00,1),(275,303,0,'2016-05-06','Web hosting and maintenance','',1.00,49.95,0.00,1),(272,298,0,'2016-05-02','Web hosting','',1.00,29.95,0.00,1),(273,300,0,'2016-05-02','Webhosting and maintenance','Urgente! Favor de enviar pago de facturas pendientes.',1.00,49.95,0.00,1),(276,304,0,'2016-05-06','Email service','',1.00,14.95,0.00,1),(277,306,0,'2016-05-06','Web hosting and maintenance','',1.00,49.95,0.00,1),(278,307,0,'2016-05-06','Web hosting and maintenance','',1.00,49.95,0.00,1),(279,308,0,'2016-05-06','Web hosting and maintenance','',1.00,39.95,0.00,1),(280,309,0,'2016-05-06','Website hosting, maintenance and email services','',1.00,61.95,0.00,1),(281,310,0,'2016-05-06','Web hosting and maintenance','',1.00,39.95,0.00,1),(282,311,0,'2016-05-06','Web hosting, maintenance and email services','',1.00,59.95,0.00,1),(283,312,0,'2016-05-06','Website hosting and maintenance','',1.00,49.95,0.00,1),(284,313,0,'2016-05-06','Website hosting and maintenance','',1.00,49.95,0.00,1),(285,314,0,'2016-05-06','Website hosting and maintenance','',1.00,49.95,0.00,1),(286,315,0,'2016-05-06','Web hosting and maintenance','',1.00,49.95,0.00,1),(288,317,0,'2016-05-06','Web hosting and maintenance','',1.00,49.95,0.00,1),(289,318,0,'2016-05-06','Web hosting and maintenance','',1.00,49.95,0.00,1),(290,319,0,'2016-05-06','Web hosting and maintenance','',1.00,49.95,0.00,1),(672,713,0,'2017-11-07','Web hosting and maintenance','',1.00,39.95,0.00,1),(433,470,0,'2016-12-05','Web hosting and maintenance','',1.00,39.95,0.00,1),(434,471,0,'2016-12-05','Web hosting and maintenance','',1.00,61.95,0.00,1),(293,322,0,'2016-06-01','Web hosting and maintenance','',1.00,29.95,0.00,1),(294,323,0,'2016-06-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(295,324,0,'2016-06-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(296,325,0,'2016-06-01','Email serv ices','',1.00,14.95,0.00,1),(297,327,0,'2016-06-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(298,328,0,'2016-06-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(299,329,0,'2016-06-01','Web hosting and maintenance','',1.00,39.95,0.00,1),(300,330,0,'2016-06-01','Hosting and maintenance','',1.00,19.95,0.00,1),(301,331,0,'2016-06-01','Web hosting and maintenance','',1.00,61.95,0.00,1),(302,332,0,'2016-06-01','Web hosting and maintenance','',1.00,39.95,0.00,1),(303,333,0,'2016-06-01','Web hosting, maintenance, email services','',1.00,59.95,0.00,1),(304,334,0,'2016-06-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(305,335,0,'2016-06-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(306,336,0,'2016-06-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(307,337,0,'2016-06-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(437,474,0,'2016-12-05','Web hosting and maintenance','',1.00,175.00,0.00,1),(309,339,0,'2016-06-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(310,340,0,'2016-06-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(432,469,0,'2016-12-05','web hosting and maintenance','',2.00,49.95,0.00,1),(313,343,0,'2016-06-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(658,699,0,'2017-10-04','Web hosting and maintenance','',1.00,49.95,0.00,1),(317,347,0,'2016-07-01','webhosting','',1.00,29.95,0.00,1),(318,348,0,'2016-07-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(319,349,0,'2016-07-01','web hosting1','',1.00,19.95,0.00,1),(320,350,0,'2016-07-01','web hosting and maintenance','',1.00,49.95,0.00,1),(321,351,0,'2016-07-01','email services','',1.00,14.95,0.00,1),(322,352,0,'2016-07-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(323,353,0,'2016-07-01','webhosting and maintenance','',1.00,49.95,0.00,1),(325,355,0,'2016-07-01','web hosting and maintenance','',1.00,39.95,0.00,1),(326,356,0,'2016-07-01','web hosting and maintenance','',1.00,61.95,0.00,1),(327,357,0,'2016-07-01','Web hosting and maintenance','',1.00,39.95,0.00,1),(328,358,0,'2016-07-01','email services and maintenance','',1.00,59.95,0.00,1),(329,359,0,'2016-07-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(330,360,0,'2016-07-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(331,361,0,'2016-07-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(332,362,0,'2016-07-01','web hosting and maintenance','',1.00,49.95,0.00,1),(436,473,0,'2016-12-05','Web hosting and email services','',1.00,63.95,0.00,1),(334,364,0,'2016-07-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(335,365,0,'2016-07-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(671,712,0,'2017-11-07','Web hosting and maintenance','',1.00,61.95,0.00,1),(431,468,0,'2016-12-05','Web hosting and maintenance','',1.00,49.95,0.00,1),(338,368,0,'2016-07-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(657,698,0,'2017-10-04','Web hosting and maintenance','',1.00,49.95,0.00,1),(340,370,0,'2016-07-01','Web hosting and maintenance','',1.00,175.00,0.00,1),(341,371,0,'2016-08-06','Web hosting','',1.00,29.95,0.00,1),(342,372,0,'2016-08-06','Web hosting and maintenance','',1.00,49.95,0.00,1),(343,373,0,'2016-08-06','Web hosting','',1.00,19.95,0.00,1),(344,374,0,'2016-08-06','Web hosting and maintenance','',1.00,49.95,0.00,1),(345,375,0,'2016-08-06','E-mail services','',1.00,14.95,0.00,1),(346,376,0,'2016-08-06','Web hosting and maintenance','',1.00,49.95,0.00,1),(347,377,0,'2016-08-06','Web hosting and maintenance','',1.00,49.95,0.00,1),(348,378,0,'2016-08-06','Web hosting and maintenance','',1.00,39.95,0.00,1),(349,379,0,'2016-08-06','Web hosting and maintenance','',1.00,61.95,0.00,1),(350,380,0,'2016-08-06','Web hosting and maintenance','',1.00,39.95,0.00,1),(351,381,0,'2016-08-06','Web hosting and maintenance','',1.00,59.95,0.00,1),(352,383,0,'2016-08-06','Web hosting and maintenance','',1.00,175.00,0.00,1),(353,384,0,'2016-08-06','Web hosting and maintenace','',1.00,49.95,0.00,1),(354,385,0,'2016-08-06','Web hosting and maiantenance','',1.00,49.95,0.00,1),(355,386,0,'2016-08-06','Web hosting and maintenance','',1.00,49.95,0.00,1),(356,387,0,'2016-08-06','Web hosting and maintenance','',1.00,49.95,0.00,1),(435,472,0,'2016-12-05','Web hosting and maintenance','',1.00,39.95,0.00,1),(358,390,0,'2016-08-06','Web hosting and maintenance','',1.00,49.95,0.00,1),(359,391,0,'2016-08-06','Web hosting and maintenance','',1.00,49.95,0.00,1),(670,711,0,'2017-11-07','Web hosting and maintenance','',1.00,39.95,0.00,1),(361,393,0,'2016-08-06','Web hosting and maintenance','',1.00,49.95,0.00,1),(363,395,0,'2016-08-27','Web hosting','',1.00,29.95,0.00,1),(364,398,0,'2016-08-27','Web hosting and maintenance','',1.00,49.95,0.00,1),(365,399,0,'2016-08-27','Web hosting and maintenance','',1.00,19.95,0.00,1),(366,400,0,'2016-08-27','Web hosting and maintenance','',1.00,49.95,0.00,1),(367,401,0,'2016-08-27','Web hosting and maintenance','',1.00,49.95,0.00,1),(368,402,0,'2016-08-27','Web hosting and maintenance','',1.00,49.95,0.00,1),(369,403,0,'2016-08-27','E-mail services','',1.00,14.95,0.00,1),(370,404,0,'2016-08-27','Web hosting and maintenance','',1.00,39.95,0.00,1),(371,405,0,'2016-08-27','web hosting and maintenance','',1.00,61.95,0.00,1),(372,406,0,'2016-08-27','Web hosting and maintenance','',1.00,39.95,0.00,1),(373,407,0,'2016-08-27','Web hosting an dmaintenance email services','',1.00,59.95,0.00,1),(374,408,0,'2016-08-27','Web hosting and maintenance','',1.00,175.00,0.00,1),(375,409,0,'2016-08-27','Web hosting and maintenance','',1.00,49.95,0.00,1),(376,410,0,'2016-08-27','Web hosting and maintenance','',1.00,49.95,0.00,1),(377,411,0,'2016-08-27','Web hosting and maintenance','',1.00,49.95,0.00,1),(378,412,0,'2016-08-27','Web hosting and maintenance','',1.00,49.95,0.00,1),(380,414,0,'2016-08-27','Web hosting and maintenance','',1.00,49.95,0.00,1),(382,416,0,'2016-08-27','Web hosting and maintenance','',1.00,49.95,0.00,1),(656,697,0,'2017-10-04','Web hosting and maintenance. Email services','',1.00,49.95,0.00,1),(384,418,0,'2016-09-22','Web hosting','',1.00,29.95,0.00,1),(385,419,0,'2016-09-22','web hosting and maintenance','Favor de enviar los pagos atrasados. Gracias',1.00,49.95,0.00,1),(386,420,0,'2016-09-22','Web hosting and services','',1.00,19.95,0.00,1),(387,421,0,'2016-09-22','Web hosting and maintenance','',1.00,49.95,0.00,1),(388,422,0,'2016-09-22','E mail services','',1.00,14.95,0.00,1),(389,423,0,'2016-09-22','Web hosting and maintenance','',1.00,49.95,0.00,1),(390,424,0,'2016-09-22','Web hosting and maintenance','',1.00,49.95,0.00,1),(391,425,0,'2016-09-22','Web hosting and maintenance','',1.00,39.95,0.00,1),(392,426,0,'2016-09-22','Web hosting and maintenance','',1.00,61.95,0.00,1),(393,427,0,'2016-09-22','Web hosrting and maintenance','',1.00,59.95,0.00,1),(394,430,0,'2016-09-22','Web hosting and maintenance','',1.00,175.00,0.00,1),(395,431,0,'2016-09-22','Web hosting and maintenance','',1.00,49.95,0.00,1),(396,432,0,'2016-09-22','Web hosting and maintenance','',1.00,49.95,0.00,1),(397,433,0,'2016-09-22','Web hosting and maintenance','',1.00,49.95,0.00,1),(398,434,0,'2016-09-22','Web hosting and maintenance','',1.00,49.95,0.00,1),(399,435,0,'2016-09-22','Web hosting and maintenance','',1.00,49.95,0.00,1),(400,436,0,'2016-09-22','Web hosting and maintenance','',1.00,49.95,0.00,1),(669,710,0,'2017-11-07','Web hosting and maintenance. Email services','',1.00,61.95,0.00,1),(402,438,0,'2016-09-22','Web hosting and maintenance','',1.00,49.95,0.00,1),(404,440,0,'2016-11-02','Webhosting','',1.00,29.95,0.00,1),(405,441,0,'2016-11-02','Web hosting and maintenance','',1.00,49.95,0.00,1),(406,442,0,'2016-11-02','Web hosting','',1.00,19.95,0.00,1),(407,443,0,'2016-11-02','Web hosting and maintenance','Por favor envien pago! Tienen varios meses en atrasos.\nGracias!',1.00,49.95,0.00,1),(408,444,0,'2016-11-02','Servicios de email','',1.00,14.95,0.00,1),(409,445,0,'2016-11-02','Web hosting and maintenance','',1.00,49.95,0.00,1),(410,446,0,'2016-11-02','Web hosting and maintenance','',1.00,49.95,0.00,1),(412,448,0,'2016-11-02','Web hosting and maintenance','',1.00,39.95,0.00,1),(413,449,0,'2016-11-02','Web hosting and maintenance','',1.00,61.95,0.00,1),(414,450,0,'2016-11-02','Web hosting and maintenance','',1.00,39.95,0.00,1),(415,451,0,'2016-11-02','Web hosting and maintenance','',1.00,63.95,0.00,1),(416,452,0,'2016-11-02','Web hosting and  maintenance','',1.00,175.00,0.00,1),(417,454,0,'2016-11-02','Web hosting and maintenance','',1.00,49.95,0.00,1),(418,455,0,'2016-11-02','Web hosting and maintenance','',1.00,49.95,0.00,1),(419,456,0,'2016-11-02','Web hosting and maintenance','',1.00,49.95,0.00,1),(420,457,0,'2016-11-02','Web hosting and maintenance','',1.00,73.95,0.00,1),(421,458,0,'2016-11-02','Web hosting and maintenance','',1.00,49.95,0.00,1),(422,459,0,'2016-11-02','Web hosting and maintenance','',1.00,49.95,0.00,1),(668,709,0,'2017-11-07','Web hosting and maintenance','',1.00,39.95,0.00,1),(424,461,0,'2016-11-02','Web hosting and maintenance','',1.00,49.95,0.00,1),(655,696,0,'2017-10-04','Web hosting and maintenance','',1.00,175.00,0.00,1),(472,510,0,'2017-02-01','Email services','',1.00,14.95,0.00,1),(473,511,0,'2017-02-01','Webhosting and maintenance','',1.00,49.95,0.00,1),(474,512,0,'2017-02-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(475,513,0,'2017-02-01','web hosting and maintenance','',1.00,39.95,0.00,1),(476,514,0,'2017-02-01','Web hosting, maintenance, email services','',1.00,61.95,0.00,1),(477,515,0,'2017-02-01','Web hosting and maintenance','',1.00,39.95,0.00,1),(478,516,0,'2017-02-01','Web hosting, maintenance, email services','Favor de enviar los pagos atrasados. Gracias',1.00,63.95,0.00,1),(479,517,0,'2017-02-01','Web hosting and maintenance','',1.00,175.00,0.00,1),(480,518,0,'2017-02-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(481,519,0,'2017-02-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(482,520,0,'2017-02-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(483,521,0,'2017-02-01','Web hosting, maintenance, email services','Favor de enviar pagos atrasados. Gracias',1.00,73.95,0.00,1),(484,522,0,'2017-02-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(485,523,0,'2017-02-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(487,525,0,'2017-02-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(654,695,0,'2017-10-04','Web hosting and email services','',1.00,63.95,0.00,1),(489,527,0,'2017-03-06','Web hosting','',1.00,29.95,0.00,1),(490,528,0,'2017-03-06','Web hosting and maintenance','Invoice for 12 months: from 3/17-3/18',12.00,29.95,0.00,1),(675,716,0,'2017-11-07','Web hosting and maintenance','',1.00,49.95,0.00,1),(492,530,0,'2017-03-06','Web hosting and maintenance','',1.00,49.95,0.00,1),(493,531,0,'2017-03-06','e-mail services','',1.00,19.95,0.00,1),(494,532,0,'2017-03-06','Web hosting and maintenance','favor enviar pagos atrasados. Gracias!',1.00,49.95,0.00,1),(495,533,0,'2017-03-06','E-mail services','',1.00,14.95,0.00,1),(496,534,0,'2017-03-06','Web hosting and maintenance','',1.00,49.95,0.00,1),(497,535,0,'2017-03-06','Web hosting and maintenance','',1.00,49.95,0.00,1),(498,536,0,'2017-03-06','Web hosting and maintenance','',1.00,39.95,0.00,1),(499,537,0,'2017-03-06','Web hosting and maintenance','',1.00,61.95,0.00,1),(500,539,0,'2017-03-06','Web hosting and maintenance','',1.00,39.95,0.00,1),(501,540,0,'2017-03-06','Web hosting and maintenance','',1.00,63.95,0.00,1),(502,541,0,'2017-03-06','Web hosting and maintenance','',1.00,175.00,0.00,1),(503,542,0,'2017-03-06','Web hosting and maintenance','',1.00,49.95,0.00,1),(504,543,0,'2017-03-06','Web hosting and maintenance','',1.00,49.95,0.00,1),(505,544,0,'2017-03-06','Web hosting and maintenance','',1.00,49.95,0.00,1),(506,545,0,'2017-03-06','Web hosting and maintenance','',1.00,73.95,0.00,1),(507,546,0,'2017-03-06','Web hosting and maintenance','',1.00,49.95,0.00,1),(508,547,0,'2017-03-06','Web hosting and maintenance','',1.00,49.95,0.00,1),(667,708,0,'2017-11-07','Web hosting and maintenance','',1.00,49.95,0.00,1),(510,549,0,'2017-03-06','Web hosting and maintenance','Invoice for 12 months: from 3/17 ti 3/18',12.00,29.95,0.00,1),(511,550,0,'2017-03-06','Web hosting and maintenance','',1.00,49.95,0.00,1),(513,552,0,'2017-03-06','Web hosting and maintenance','Invoice for 12 months service: 3/17 to 3/18',12.00,34.95,0.00,1),(514,553,0,'2017-04-04','Web hosting','',1.00,29.95,0.00,1),(515,554,0,'2017-04-04','Web hosting and mainteance','',1.00,49.95,0.00,1),(516,555,0,'2017-04-04','Web hosting','',1.00,19.95,0.00,1),(517,556,0,'2017-04-04','Web hosting and maintenance','Favor enviar los pagos atrasados. Gracias!',1.00,49.95,0.00,1),(518,557,0,'2017-04-04','E-mail services','',1.00,14.95,0.00,1),(519,558,0,'2017-04-04','Web hosting and maintenance','',1.00,49.95,0.00,1),(520,559,0,'2017-04-04','We bhosting and maintenance','',1.00,49.95,0.00,1),(521,560,0,'2017-04-04','Web hosting and maintenance','',1.00,39.95,0.00,1),(522,561,0,'2017-04-04','Web hosting and maintenance','',1.00,61.95,0.00,1),(523,562,0,'2017-04-04','Web hosting and maintenance','',1.00,39.95,0.00,1),(524,563,0,'2017-04-04','Web hosting, maintenance, email services','',1.00,63.95,0.00,1),(525,564,0,'2017-04-04','Web hosting and maintenance','',1.00,175.00,0.00,1),(526,565,0,'2017-04-04','Web hosting and maintenance','',1.00,49.95,0.00,1),(527,566,0,'2017-04-04','Web hosting and maintenance','',1.00,49.95,0.00,1),(528,567,0,'2017-04-04','Web hosting and maintenance','',1.00,49.95,0.00,1),(529,568,0,'2017-04-04','Web hosting and maintenance','',1.00,73.95,0.00,1),(530,569,0,'2017-04-04','Web hosting and maintenance','',1.00,49.95,0.00,1),(531,570,0,'2017-04-04','Web hosting and maintenance','',1.00,49.95,0.00,1),(664,705,0,'2017-11-07','Web hosting and maintenance','',1.00,49.95,0.00,1),(533,572,0,'2017-04-04','Web hosting and maintenance','',1.00,49.95,0.00,1),(652,693,0,'2017-10-04','Web hosting and email services','',1.00,61.95,0.00,1),(653,694,0,'2017-10-04','Web hosting and maintenance','',1.00,39.95,0.00,1),(536,575,0,'2017-05-08','Webhosting','',1.00,29.95,0.00,1),(537,576,0,'2017-05-08','Web hosting and maintenance','',1.00,49.95,0.00,1),(538,577,0,'2017-05-08','Hosting and email services','',1.00,19.95,0.00,1),(539,578,0,'2017-05-08','Web hosting and maintenance','Por favor envien pagos atrasados. Evite que se le desconecte el website.\nGracias!',1.00,49.95,0.00,1),(540,579,0,'2017-05-08','Email services','',1.00,14.95,0.00,1),(541,580,0,'2017-05-08','Webhosting and maintenance','',1.00,49.95,0.00,1),(542,581,0,'2017-05-08','Webhosting and maintenance','',1.00,49.95,0.00,1),(543,582,0,'2017-05-08','Web hosting and maintenance','',1.00,39.95,0.00,1),(544,583,0,'2017-05-08','Web hosting and maintenance','',1.00,61.95,0.00,1),(545,584,0,'2017-05-08','SWeb hosting and maintenance','',1.00,39.95,0.00,1),(546,585,0,'2017-05-08','Webhosting and maintenance','Por favor envie pagos atrasados. Evite la cancelacion de sus servicios.',1.00,63.95,0.00,1),(547,586,0,'2017-05-08','Web hosting and maintenance','',1.00,175.00,0.00,1),(548,587,0,'2017-05-08','Web hossting and maintenance','',1.00,49.95,0.00,1),(549,588,0,'2017-05-08','Webhosting and maintenance','',1.00,49.95,0.00,1),(550,589,0,'2017-05-08','Webhosting and maintenance','',1.00,49.95,0.00,1),(551,589,0,'2017-05-08','Renovacion del domain name por 5 anos','',1.00,150.00,0.00,2),(552,590,0,'2017-05-08','Web hosting and maiantenance','',1.00,49.95,0.00,1),(553,591,0,'2017-05-08','Web hosting and maintenance','',1.00,49.95,0.00,1),(554,592,0,'2017-05-08','Web hosting and maintenance','',1.00,49.95,0.00,1),(556,594,0,'2017-05-08','Web hosting and maintenance','',1.00,49.95,0.00,1),(651,692,0,'2017-10-04','web hosting and maintenance','',1.00,39.95,0.00,1),(558,596,0,'2017-06-02','Web hosting','',1.00,29.95,0.00,1),(559,597,0,'2017-06-02','web hosting and maintenance','Por favor envie todos los pagos atrasados. Evite suspension de servicio.',1.00,49.95,0.00,1),(560,598,0,'2017-06-02','web hosting and email services','',1.00,19.95,0.00,1),(561,599,0,'2017-06-02','web hosting and maintenance','Por favor envie pagos atrasados. Evite suspension de servicio.',1.00,49.95,0.00,1),(562,600,0,'2017-06-02','E-mail services','',1.00,14.95,0.00,1),(563,601,0,'2017-06-02','web hosting and maintenance','',1.00,49.95,0.00,1),(564,602,0,'2017-06-02','Web hosting and maintenance','',1.00,49.95,0.00,1),(565,603,0,'2017-06-02','Web hosting and maintenance','',1.00,39.95,0.00,1),(566,604,0,'2017-06-02','Web hosting and maintenance','',1.00,61.95,0.00,1),(567,605,0,'2017-06-02','Web hosting and maintenance','',1.00,39.95,0.00,1),(568,606,0,'2017-06-02','Web hosting and maintenance, email services','',1.00,63.95,0.00,1),(569,607,0,'2017-06-02','Web hosting and maintenance','',1.00,175.00,0.00,1),(570,608,0,'2017-06-02','Web hosting and maintenance','',1.00,49.95,0.00,1),(571,609,0,'2017-06-02','Web hosting and maintenance','',1.00,49.95,0.00,1),(572,610,0,'2017-06-02','Web hosting and maintenance','',1.00,49.95,0.00,1),(573,611,0,'2017-06-02','Web hosting and maintenance, email services','',1.00,73.95,0.00,1),(574,612,0,'2017-06-02','Web hosting and maintenance','',1.00,49.95,0.00,1),(575,613,0,'2017-06-02','Web hosting and maintenance','',1.00,49.95,0.00,1),(665,706,0,'2017-11-07','Email services','',1.00,14.95,0.00,1),(577,615,0,'2017-06-02','Web hosting and maintenance','',1.00,49.95,0.00,1),(579,617,0,'2017-07-01','WEb hosting','',1.00,29.95,0.00,1),(580,618,0,'2017-07-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(581,619,0,'2017-07-01','Email services','',1.00,19.95,0.00,1),(582,620,0,'2017-07-01','Webhosting and maintenance','',1.00,49.95,0.00,1),(583,621,0,'2017-07-01','Maintenance and email services','',1.00,14.95,0.00,1),(584,622,0,'2017-07-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(585,623,0,'2017-07-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(586,624,0,'2017-07-01','Web hosting and maintenance','',1.00,39.95,0.00,1),(587,625,0,'2017-07-01','Web hosting, maintenance, email services','',1.00,61.95,0.00,1),(588,626,0,'2017-07-01','Web hosting and maintenance','',1.00,39.95,0.00,1),(589,627,0,'2017-07-01','Web hosting and maintenance','',1.00,63.95,0.00,1),(590,628,0,'2017-07-01','Web hosting and maintenance','',1.00,175.00,0.00,1),(591,629,0,'2017-07-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(592,630,0,'2017-07-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(593,631,0,'2017-07-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(594,632,0,'2017-07-01','Web hosting andmaintenance','',1.00,73.95,0.00,1),(595,633,0,'2017-07-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(596,634,0,'2017-07-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(666,707,0,'2017-11-07','Web hosting and maintenance','',1.00,49.95,0.00,1),(598,636,0,'2017-07-01','Web hosting and maintenace','',1.00,49.95,0.00,1),(650,691,0,'2017-10-04','webhosting and maintenance','',1.00,49.95,0.00,1),(600,638,0,'2017-08-02','web hosting','',1.00,29.95,0.00,1),(601,639,0,'2017-08-02','web hosting and maintenance','',1.00,49.95,0.00,1),(602,640,0,'2017-08-02','Renovacion Domain Name por 3 anos','',1.00,160.00,0.00,1),(603,641,0,'2017-08-02','hosting and email services','',1.00,19.95,0.00,1),(605,643,0,'2017-08-02','web hosting and maintenance','',1.00,49.95,0.00,1),(606,644,0,'2017-08-02','E-mail services.','',1.00,14.95,0.00,1),(607,645,0,'2017-08-02','Web hosting and maintenance','',1.00,49.95,0.00,1),(608,646,0,'2017-08-02','web hosting and maintenance','',1.00,49.95,0.00,1),(609,647,0,'2017-08-02','Web hosting and maintenance','',1.00,39.95,0.00,1),(611,649,0,'2017-08-02','Web hosting and1 maintenance- email services','',1.00,61.95,0.00,1),(612,650,0,'2017-08-02','Web hosting and maintenance','',1.00,39.95,0.00,1),(613,651,0,'2017-08-02','Web hosting and maintenance - email services','',1.00,63.95,0.00,1),(614,652,0,'2017-08-02','Web hosting and maintenance','',1.00,175.00,0.00,1),(615,653,0,'2017-08-02','Web hosting and maintenance','',1.00,49.95,0.00,1),(616,654,0,'2017-08-02','Web hosting and maintenance','',1.00,49.95,0.00,1),(617,655,0,'2017-08-02','Web hosting and maintenance','',1.00,49.95,0.00,1),(618,656,0,'2017-08-02','Web hosting and maintenance- email services','',1.00,73.95,0.00,1),(619,657,0,'2017-08-02','Web hosting and maintenance','',1.00,49.95,0.00,1),(620,658,0,'2017-08-02','Web hosting and maintenance','',1.00,49.95,0.00,1),(663,704,0,'2017-11-07','Web hosting','',1.00,29.95,0.00,1),(622,660,0,'2017-08-02','Web hosting and maintenance','',1.00,49.95,0.00,1),(648,688,0,'2017-10-04','Email services','',1.00,1495.00,0.00,1),(649,690,0,'2017-10-04','Web hosting and maintenance','',1.00,49.95,0.00,1),(624,664,0,'2017-09-05','Web hosting','',1.00,29.95,0.00,1),(625,665,0,'2017-09-05','Web hosting and maintenanced','',1.00,49.95,0.00,1),(626,666,0,'2017-09-05','Email services','',1.00,19.95,0.00,1),(627,667,0,'2017-09-05','Web hosting and maintenance','',1.00,49.95,0.00,1),(628,668,0,'2017-09-05','Email services','',1.00,14.95,0.00,1),(629,669,0,'2017-09-05','Web hosting and maintenance','',1.00,49.95,0.00,1),(630,670,0,'2017-09-05','Web hosting and maintenance','',1.00,49.95,0.00,1),(631,671,0,'2017-09-05','Web hosting and maintenance','Por favor envie pagos atrasados. Evite la desconexion.',1.00,39.95,0.00,1),(632,672,0,'2017-09-05','Web hosting and maintenance','',1.00,61.95,0.00,1),(633,673,0,'2017-09-05','Web hosting and maintenance','',1.00,39.95,0.00,1),(634,674,0,'2017-09-05','Web hosting and email services','',1.00,67.95,0.00,1),(635,675,0,'2017-09-05','Web hosting and maintenance','',1.00,175.00,0.00,1),(636,676,0,'2017-09-05','Web hosting and maintenance','',1.00,49.95,0.00,1),(637,677,0,'2017-09-05','Web hosting and maintenance','',1.00,49.95,0.00,1),(638,678,0,'2017-09-05','web hosting and maintenance','',1.00,49.95,0.00,1),(639,679,0,'2017-09-05','Web hosting and maintenance and email services','',1.00,73.95,0.00,1),(640,680,0,'2017-09-05','Web hosting and maintenance','',1.00,49.95,0.00,1),(641,681,0,'2017-09-05','Web hosting and maintenance','',1.00,49.95,0.00,1),(642,682,0,'2017-09-05','Web hosting and maintenance','',1.00,49.95,0.00,1),(647,687,0,'2017-10-04','Web hosting and maintenance','',1.00,49.95,0.00,1),(677,718,0,'2017-11-07','Web hosting and maintenance','',1.00,49.95,0.00,1),(678,719,0,'2017-11-07','Web hosting and maintenance','',1.00,73.95,0.00,1),(679,720,0,'2017-11-07','Web hosting and maintenance','',1.00,49.95,0.00,1),(680,721,0,'2017-11-07','Web hosting and maintenance','',1.00,49.95,0.00,1),(681,722,0,'2017-11-07','Web hosting and maintenance','',1.00,49.95,0.00,1),(682,723,0,'2017-11-07','Web hosting and maintenance','',1.00,49.95,0.00,1),(683,724,0,'2017-12-01','Web hosting ','',1.00,29.95,0.00,1),(684,725,0,'2017-12-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(685,726,0,'2017-12-01','webhosting and maintenance','Por favor envie pagos atrasados. Evite que el website sea cancelado.',1.00,49.95,0.00,1),(686,727,0,'2017-12-01','email services','',1.00,14.95,0.00,1),(687,728,0,'2017-12-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(688,729,0,'2017-12-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(689,730,0,'2017-12-01','Web hosting and maintenance','',1.00,39.95,0.00,1),(690,731,0,'2017-12-01','Web hosting and maintenance','',1.00,61.95,0.00,1),(691,732,0,'2017-12-01','Web hosting and maintenance','',1.00,39.95,0.00,1),(692,733,0,'2017-12-01','Web hosting and maintenance','',1.00,175.00,0.00,1),(693,734,0,'2017-12-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(694,736,0,'2017-12-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(695,737,0,'2017-12-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(696,738,0,'2017-12-01','Web hosting and maintenance','',1.00,73.95,0.00,1),(697,739,0,'2017-12-01','Web hosting, maintenance and services','',1.00,63.95,0.00,1),(698,740,0,'2017-12-01','Web hosting and maintenancer','',1.00,49.95,0.00,1),(699,741,0,'2017-12-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(700,742,0,'2017-12-01','Web hosting and maintenance','',1.00,49.95,0.00,1),(701,743,0,'2018-01-03','Web hosting and maintenance','',1.00,29.95,0.00,1),(702,744,0,'2018-01-03','Web hosting and maintenance','',1.00,49.95,0.00,1),(703,745,0,'2018-01-03','web hosting and maintenance','',1.00,49.95,0.00,1),(704,746,0,'2018-01-03','email services','',0.00,1.00,14.95,1),(705,747,0,'2018-01-03','Web hosting and maintenance','',1.00,49.95,0.00,1),(706,748,0,'2018-01-03','Web hosting and maintenance','',1.00,49.95,0.00,1),(707,749,0,'2018-01-03','Web hosting and maintenance','',1.00,39.95,0.00,1),(708,750,0,'2018-01-03','Web hosting and maintenance','',1.00,61.95,0.00,1),(709,751,0,'2018-01-03','Web hosting and maintenance','',1.00,39.95,0.00,1),(710,752,0,'2018-01-03','Web hosting, maintenance, email services','',1.00,63.95,0.00,1),(711,753,0,'2018-01-03','Web hosting and maintenance','',1.00,175.00,0.00,1),(712,754,0,'2018-01-03','Web hosting and maintenance','',1.00,49.95,0.00,1),(713,755,0,'2018-01-03','Web hosting and maintenance','',1.00,49.95,0.00,1),(714,756,0,'2018-01-03','Web hosting and maintenance','',1.00,49.95,0.00,1),(715,757,0,'2018-01-03','Web hosting and maintenance, email services','',1.00,73.95,0.00,1),(716,758,0,'2018-01-03','Web hosting and maintenance','',1.00,49.95,0.00,1),(717,759,0,'2018-01-03','Web hosting and maintenance','',1.00,49.95,0.00,1),(718,760,0,'2018-01-03','Web hosting and maintenance','',1.00,49.95,0.00,1);

--
-- 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=29 DEFAULT CHARSET=utf8;

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

INSERT INTO `ip_invoices_recurring` VALUES (1,11,'2015-07-05','0000-00-00','1M','2015-07-05'),(2,11,'2015-07-05','0000-00-00','1M','2015-07-05'),(3,17,'2015-07-05','0000-00-00','1M','2015-07-05'),(4,18,'2015-07-05','0000-00-00','1M','2015-07-05'),(5,19,'2015-07-05','0000-00-00','1M','2015-07-05'),(6,20,'2015-07-05','0000-00-00','1M','2015-07-05'),(7,21,'2015-07-05','0000-00-00','1M','2015-07-05'),(8,22,'2015-07-05','0000-00-00','1M','2015-07-05'),(9,23,'2015-07-05','0000-00-00','1M','2015-07-05'),(10,24,'2015-07-05','0000-00-00','1M','2015-07-05'),(11,25,'2015-07-05','0000-00-00','1M','2015-07-05'),(12,26,'2015-07-05','0000-00-00','1M','2015-07-05'),(13,27,'2015-07-05','0000-00-00','1M','2015-07-05'),(14,29,'2015-07-05','0000-00-00','1M','2015-07-05'),(15,30,'2015-07-05','0000-00-00','1M','2015-07-05'),(16,31,'2015-07-05','0000-00-00','1M','2015-07-05'),(17,32,'2015-07-05','0000-00-00','1M','2015-07-05'),(18,33,'2015-07-05','0000-00-00','1M','2015-07-05'),(19,34,'2015-07-05','0000-00-00','1M','2015-07-05'),(20,37,'2015-07-05','0000-00-00','1M','2015-07-05'),(21,38,'2015-07-05','0000-00-00','1M','2015-07-05'),(22,41,'2015-07-05','0000-00-00','1M','2015-07-05'),(23,42,'2015-07-05','0000-00-00','1M','2015-07-05'),(24,43,'2015-07-05','0000-00-00','1M','2015-07-05'),(25,44,'2015-07-05','0000-00-00','1M','2015-07-05'),(26,55,'2015-08-03','0000-00-00','1M','2015-08-03'),(27,79,'2015-09-01','0000-00-00','1M','2015-09-01'),(28,80,'2015-09-01','0000-00-00','1M','2015-09-01');

--
-- 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 DEFAULT CHARSET=utf8;

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


--
-- 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=7 DEFAULT CHARSET=utf8;

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


--
-- 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=6 DEFAULT CHARSET=utf8;

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


--
-- 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=6 DEFAULT CHARSET=utf8;

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


--
-- 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','0'),(24,'quotes_expire_after','15'),(25,'default_invoice_group','3'),(26,'default_quote_group','4'),(27,'thousands_separator',','),(28,'decimal_point','.'),(29,'cron_key','GmWIBHnbPaHeNS3r'),(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','US'),(44,'default_list_limit','100'),(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',''),(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','8gkMfBUgDl/iEehnOxPQhNekBuFhDA0zcUyWX8XJCtlNIpaty5APbbTy9ITtaCdWf1ZQBgbJGRtrVhEf/FaJvg=='),(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','logo.gif');

--
-- 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 AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

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

INSERT INTO `ip_uploads` VALUES (1,601,'ZMd8r5PGbrc9rlc','-uploads-archive-2016-08-06_Invoice_7182.pdf','ZMd8r5PGbrc9rlc_-uploads-archive-2016-08-06_Invoice_7182.pdf','2016-08-06'),(2,601,'sznEmNANW1kKaqd','-uploads-archive-2016-08-27_Invoice_7207.pdf','sznEmNANW1kKaqd_-uploads-archive-2016-08-27_Invoice_7207.pdf','2016-08-27'),(3,601,'sznEmNANW1kKaqd','-uploads-archive-2016-08-27_Invoice_7207.pdf','sznEmNANW1kKaqd_-uploads-archive-2016-08-27_Invoice_7207.pdf','2016-08-27'),(4,601,'sznEmNANW1kKaqd','-uploads-archive-2016-08-27_Invoice_7207.pdf','sznEmNANW1kKaqd_-uploads-archive-2016-08-27_Invoice_7207.pdf','2016-08-27');

--
-- 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=14 DEFAULT CHARSET=utf8;

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

INSERT INTO `ip_versions` VALUES (1,'1433435890','000_1.0.0.sql',0),(2,'1433435893','001_1.0.1.sql',0),(3,'1433435893','002_1.0.2.sql',0),(4,'1433435893','003_1.1.0.sql',0),(5,'1433435893','004_1.1.1.sql',0),(6,'1433435893','005_1.1.2.sql',0),(7,'1433435893','006_1.2.0.sql',0),(8,'1433435893','007_1.2.1.sql',0),(9,'1433435893','008_1.3.0.sql',0),(10,'1433435893','009_1.3.1.sql',0),(11,'1433435893','010_1.3.2.sql',0),(12,'1433435893','011_1.3.3.sql',0),(13,'1433435893','012_1.4.0.sql',0);

--
-- Dumping events for database 'facturas'
--

--
-- Dumping routines for database 'facturas'
--


