--
-- Host: localhost    Database: invoice
-- ------------------------------------------------------


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

CREATE TABLE `ip_client_custom` (
  `client_custom_id` int NOT NULL AUTO_INCREMENT,
  `client_id` int NOT NULL,
  `client_custom_fieldid` int NOT NULL,
  `client_custom_fieldvalue` text,
  PRIMARY KEY (`client_custom_id`),
  UNIQUE KEY `client_id` (`client_id`,`client_custom_fieldid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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


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

CREATE TABLE `ip_client_notes` (
  `client_note_id` int NOT NULL AUTO_INCREMENT,
  `client_id` int 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 NOT NULL AUTO_INCREMENT,
  `client_date_created` datetime NOT NULL,
  `client_date_modified` datetime NOT NULL,
  `client_name` text,
  `client_address_1` text,
  `client_address_2` text,
  `client_city` text,
  `client_state` text,
  `client_zip` text,
  `client_country` text,
  `client_phone` text,
  `client_fax` text,
  `client_mobile` text,
  `client_email` text,
  `client_web` text,
  `client_vat_id` text,
  `client_tax_code` text,
  `client_language` varchar(255) DEFAULT 'system',
  `client_active` int NOT NULL DEFAULT '1',
  `client_surname` varchar(255) DEFAULT NULL,
  `client_avs` varchar(16) DEFAULT NULL,
  `client_insurednumber` varchar(30) DEFAULT NULL,
  `client_veka` varchar(30) DEFAULT NULL,
  `client_birthdate` date DEFAULT NULL,
  `client_gender` int DEFAULT '0',
  PRIMARY KEY (`client_id`),
  KEY `client_active` (`client_active`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

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

INSERT INTO `ip_clients` VALUES (1,'2020-11-28 15:42:05','2020-11-28 15:42:05','Test Client','','','','','','IN','','','','','','','','system',1,'',NULL,NULL,NULL,'0000-00-00',0);

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

CREATE TABLE `ip_custom_fields` (
  `custom_field_id` int NOT NULL AUTO_INCREMENT,
  `custom_field_table` varchar(50) DEFAULT NULL,
  `custom_field_label` varchar(50) DEFAULT NULL,
  `custom_field_type` varchar(255) NOT NULL DEFAULT 'TEXT',
  `custom_field_location` int DEFAULT '0',
  `custom_field_order` int DEFAULT '999',
  PRIMARY KEY (`custom_field_id`),
  UNIQUE KEY `custom_field_table_2` (`custom_field_table`,`custom_field_label`),
  KEY `custom_field_table` (`custom_field_table`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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


--
-- Table structure for table `ip_custom_values`
--

CREATE TABLE `ip_custom_values` (
  `custom_values_id` int NOT NULL AUTO_INCREMENT,
  `custom_values_field` int NOT NULL,
  `custom_values_value` text NOT NULL,
  PRIMARY KEY (`custom_values_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_custom_values`
--


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

CREATE TABLE `ip_email_templates` (
  `email_template_id` int NOT NULL AUTO_INCREMENT,
  `email_template_title` text,
  `email_template_type` varchar(255) DEFAULT NULL,
  `email_template_body` longtext NOT NULL,
  `email_template_subject` text,
  `email_template_from_name` text,
  `email_template_from_email` text,
  `email_template_cc` text,
  `email_template_bcc` text,
  `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 NOT NULL AUTO_INCREMENT,
  `family_name` text,
  PRIMARY KEY (`family_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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


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

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

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


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

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

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


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

CREATE TABLE `ip_invoice_amounts` (
  `invoice_amount_id` int NOT NULL AUTO_INCREMENT,
  `invoice_id` int 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=2 DEFAULT CHARSET=utf8;

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

INSERT INTO `ip_invoice_amounts` VALUES (1,1,'1',18000.00,0.00,0.00,18000.00,0.00,18000.00);

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

CREATE TABLE `ip_invoice_custom` (
  `invoice_custom_id` int NOT NULL AUTO_INCREMENT,
  `invoice_id` int NOT NULL,
  `invoice_custom_fieldid` int NOT NULL,
  `invoice_custom_fieldvalue` text,
  PRIMARY KEY (`invoice_custom_id`),
  UNIQUE KEY `invoice_id` (`invoice_id`,`invoice_custom_fieldid`)
) ENGINE=InnoDB 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 NOT NULL AUTO_INCREMENT,
  `invoice_group_name` text,
  `invoice_group_identifier_format` varchar(255) NOT NULL,
  `invoice_group_next_id` int NOT NULL,
  `invoice_group_left_pad` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`invoice_group_id`),
  KEY `invoice_group_next_id` (`invoice_group_next_id`),
  KEY `invoice_group_left_pad` (`invoice_group_left_pad`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

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

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

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

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

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

INSERT INTO `ip_invoice_item_amounts` VALUES (1,1,9000.00,0.00,0.00,9000.00),(2,2,9000.00,0.00,0.00,9000.00);

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

CREATE TABLE `ip_invoice_items` (
  `item_id` int NOT NULL AUTO_INCREMENT,
  `invoice_id` int NOT NULL,
  `item_tax_rate_id` int NOT NULL DEFAULT '0',
  `item_product_id` int DEFAULT NULL,
  `item_date_added` date NOT NULL,
  `item_task_id` int DEFAULT NULL,
  `item_name` text,
  `item_description` longtext,
  `item_quantity` decimal(10,2) NOT NULL,
  `item_price` decimal(20,2) DEFAULT NULL,
  `item_discount_amount` decimal(20,2) DEFAULT NULL,
  `item_order` int NOT NULL DEFAULT '0',
  `item_is_recurring` tinyint(1) DEFAULT NULL,
  `item_product_unit` varchar(50) DEFAULT NULL,
  `item_product_unit_id` int DEFAULT NULL,
  `item_date` date DEFAULT NULL,
  PRIMARY KEY (`item_id`),
  KEY `invoice_id` (`invoice_id`,`item_tax_rate_id`,`item_date_added`,`item_order`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

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

INSERT INTO `ip_invoice_items` VALUES (1,1,0,NULL,'2020-11-28',NULL,'Development for October','',1.00,9000.00,NULL,1,NULL,NULL,NULL,NULL),(2,1,0,NULL,'2020-11-28',NULL,'Development for November','',1.00,9000.00,NULL,2,NULL,NULL,NULL,NULL);

--
-- Table structure for table `ip_invoice_sumex`
--

CREATE TABLE `ip_invoice_sumex` (
  `sumex_id` int NOT NULL AUTO_INCREMENT,
  `sumex_invoice` int NOT NULL,
  `sumex_reason` int NOT NULL,
  `sumex_diagnosis` varchar(500) NOT NULL,
  `sumex_observations` varchar(500) NOT NULL,
  `sumex_treatmentstart` date NOT NULL,
  `sumex_treatmentend` date NOT NULL,
  `sumex_casedate` date NOT NULL,
  `sumex_casenumber` varchar(35) DEFAULT NULL,
  PRIMARY KEY (`sumex_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_invoice_sumex`
--


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

CREATE TABLE `ip_invoice_tax_rates` (
  `invoice_tax_rate_id` int NOT NULL AUTO_INCREMENT,
  `invoice_id` int NOT NULL,
  `tax_rate_id` int NOT NULL,
  `include_item_tax` int NOT NULL DEFAULT '0',
  `invoice_tax_rate_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  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 NOT NULL AUTO_INCREMENT,
  `invoice_id` int NOT NULL,
  `recur_start_date` date NOT NULL,
  `recur_end_date` date NOT NULL,
  `recur_frequency` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `recur_next_date` date NOT NULL,
  PRIMARY KEY (`invoice_recurring_id`),
  KEY `invoice_id` (`invoice_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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


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

CREATE TABLE `ip_item_lookups` (
  `item_lookup_id` int 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 NOT NULL AUTO_INCREMENT,
  `invoice_id` int NOT NULL,
  `merchant_response_successful` tinyint(1) DEFAULT '1',
  `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 NOT NULL AUTO_INCREMENT,
  `payment_id` int NOT NULL,
  `payment_custom_fieldid` int NOT NULL,
  `payment_custom_fieldvalue` text,
  PRIMARY KEY (`payment_custom_id`),
  UNIQUE KEY `payment_id` (`payment_id`,`payment_custom_fieldid`)
) ENGINE=InnoDB 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 NOT NULL AUTO_INCREMENT,
  `payment_method_name` text,
  PRIMARY KEY (`payment_method_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

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

INSERT INTO `ip_payment_methods` VALUES (1,'Cash'),(2,'Credit Card');

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

CREATE TABLE `ip_payments` (
  `payment_id` int NOT NULL AUTO_INCREMENT,
  `invoice_id` int NOT NULL,
  `payment_method_id` int NOT NULL DEFAULT '0',
  `payment_date` date NOT NULL,
  `payment_amount` decimal(20,2) DEFAULT 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 NOT NULL AUTO_INCREMENT,
  `family_id` int DEFAULT NULL,
  `product_sku` text,
  `product_name` text,
  `product_description` longtext NOT NULL,
  `product_price` decimal(20,2) DEFAULT NULL,
  `purchase_price` decimal(20,2) DEFAULT NULL,
  `provider_name` text,
  `tax_rate_id` int DEFAULT NULL,
  `unit_id` int DEFAULT NULL,
  `product_tariff` int DEFAULT 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 NOT NULL AUTO_INCREMENT,
  `client_id` int NOT NULL,
  `project_name` text,
  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 NOT NULL AUTO_INCREMENT,
  `quote_id` int 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 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 NOT NULL AUTO_INCREMENT,
  `quote_id` int NOT NULL,
  `quote_custom_fieldid` int NOT NULL,
  `quote_custom_fieldvalue` text,
  PRIMARY KEY (`quote_custom_id`),
  UNIQUE KEY `quote_id` (`quote_id`,`quote_custom_fieldid`)
) ENGINE=InnoDB 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 NOT NULL AUTO_INCREMENT,
  `item_id` int NOT NULL,
  `item_subtotal` decimal(20,2) DEFAULT NULL,
  `item_tax_total` decimal(20,2) DEFAULT NULL,
  `item_discount` decimal(20,2) DEFAULT NULL,
  `item_total` decimal(20,2) DEFAULT NULL,
  PRIMARY KEY (`item_amount_id`),
  KEY `item_id` (`item_id`)
) ENGINE=MyISAM 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 NOT NULL AUTO_INCREMENT,
  `quote_id` int NOT NULL,
  `item_tax_rate_id` int NOT NULL,
  `item_product_id` int DEFAULT NULL,
  `item_date_added` date NOT NULL,
  `item_name` text,
  `item_description` text,
  `item_quantity` decimal(20,2) DEFAULT NULL,
  `item_price` decimal(20,2) DEFAULT NULL,
  `item_discount_amount` decimal(20,2) DEFAULT NULL,
  `item_order` int NOT NULL DEFAULT '0',
  `item_product_unit` varchar(50) DEFAULT NULL,
  `item_product_unit_id` int DEFAULT NULL,
  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 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 NOT NULL AUTO_INCREMENT,
  `quote_id` int NOT NULL,
  `tax_rate_id` int NOT NULL,
  `include_item_tax` int NOT NULL DEFAULT '0',
  `quote_tax_rate_amount` decimal(20,2) DEFAULT 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_sessions`
--

CREATE TABLE `ip_sessions` (
  `id` varchar(128) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `timestamp` int unsigned NOT NULL DEFAULT '0',
  `data` blob NOT NULL,
  KEY `ip_sessions_timestamp` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_sessions`
--


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

CREATE TABLE `ip_settings` (
  `setting_id` int 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=257 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,'currency_code','INR'),(24,'invoices_due_after','30'),(25,'quotes_expire_after','15'),(26,'default_invoice_group','3'),(27,'default_quote_group','4'),(28,'thousands_separator',','),(29,'decimal_point','.'),(30,'cron_key','4neRDtdQ1M8ijZ3p'),(31,'tax_rate_decimal_places','2'),(32,'pdf_invoice_template','InvoicePlane'),(33,'pdf_invoice_template_paid','InvoicePlane - paid'),(34,'pdf_invoice_template_overdue','InvoicePlane - overdue'),(35,'pdf_quote_template','InvoicePlane'),(36,'public_invoice_template','InvoicePlane_Web'),(37,'public_quote_template','InvoicePlane_Web'),(38,'disable_sidebar','1'),(39,'read_only_toggle','4'),(40,'invoice_pre_password',''),(41,'quote_pre_password',''),(42,'email_pdf_attachment','1'),(43,'generate_invoice_number_for_draft','1'),(44,'generate_quote_number_for_draft','1'),(45,'sumex','0'),(46,'sumex_sliptype','1'),(47,'sumex_canton','0'),(48,'system_theme','invoiceplane'),(49,'default_hourly_rate','0.00'),(50,'projects_enabled','1'),(51,'pdf_quote_footer',''),(52,'first_day_of_week','0'),(53,'default_country','IN'),(54,'default_list_limit','15'),(55,'number_format','number_format_us_uk'),(56,'quote_overview_period','this-year'),(57,'invoice_overview_period','this-month'),(58,'disable_quickactions','0'),(59,'custom_title',''),(60,'monospace_amounts','0'),(61,'reports_in_new_tab','0'),(62,'bcc_mails_to_admin','0'),(63,'default_invoice_terms',''),(64,'invoice_default_payment_method',''),(65,'mark_invoices_sent_pdf','0'),(66,'include_zugferd','0'),(67,'pdf_watermark','0'),(68,'email_invoice_template',''),(69,'email_invoice_template_paid',''),(70,'email_invoice_template_overdue',''),(71,'pdf_invoice_footer',''),(72,'automatic_email_on_recur','0'),(73,'sumex_role','0'),(74,'sumex_place','0'),(75,'default_quote_notes',''),(76,'mark_quotes_sent_pdf','0'),(77,'email_quote_template',''),(78,'default_invoice_tax_rate',''),(79,'default_item_tax_rate',''),(80,'default_include_item_tax',''),(81,'email_send_method',''),(82,'smtp_server_address',''),(83,'smtp_mail_from',''),(84,'smtp_authentication','0'),(85,'smtp_username',''),(86,'smtp_port',''),(87,'smtp_security',''),(88,'smtp_verify_certs','1'),(89,'enable_online_payments','0'),(90,'gateway_authorizenet_aim_enabled','0'),(91,'gateway_authorizenet_aim_apiLoginId',''),(92,'gateway_authorizenet_aim_transactionKey',''),(93,'gateway_authorizenet_aim_testMode','0'),(94,'gateway_authorizenet_aim_developerMode','0'),(95,'gateway_authorizenet_aim_currency','ARS'),(96,'gateway_authorizenet_aim_payment_method',''),(97,'gateway_authorizenet_sim_enabled','0'),(98,'gateway_authorizenet_sim_apiLoginId',''),(99,'gateway_authorizenet_sim_transactionKey',''),(100,'gateway_authorizenet_sim_testMode','0'),(101,'gateway_authorizenet_sim_developerMode','0'),(102,'gateway_authorizenet_sim_currency','ARS'),(103,'gateway_authorizenet_sim_payment_method',''),(104,'gateway_buckaroo_ideal_enabled','0'),(105,'gateway_buckaroo_ideal_websiteKey',''),(106,'gateway_buckaroo_ideal_testMode','0'),(107,'gateway_buckaroo_ideal_currency','ARS'),(108,'gateway_buckaroo_ideal_payment_method',''),(109,'gateway_buckaroo_paypal_enabled','0'),(110,'gateway_buckaroo_paypal_websiteKey',''),(111,'gateway_buckaroo_paypal_testMode','0'),(112,'gateway_buckaroo_paypal_currency','ARS'),(113,'gateway_buckaroo_paypal_payment_method',''),(114,'gateway_cardsave_enabled','0'),(115,'gateway_cardsave_merchantId',''),(116,'gateway_cardsave_currency','ARS'),(117,'gateway_cardsave_payment_method',''),(118,'gateway_coinbase_enabled','0'),(119,'gateway_coinbase_apiKey',''),(120,'gateway_coinbase_accountId',''),(121,'gateway_coinbase_currency','ARS'),(122,'gateway_coinbase_payment_method',''),(123,'gateway_eway_rapid_enabled','0'),(124,'gateway_eway_rapid_apiKey',''),(125,'gateway_eway_rapid_testMode','0'),(126,'gateway_eway_rapid_currency','ARS'),(127,'gateway_eway_rapid_payment_method',''),(128,'gateway_firstdata_connect_enabled','0'),(129,'gateway_firstdata_connect_storeId',''),(130,'gateway_firstdata_connect_testMode','0'),(131,'gateway_firstdata_connect_currency','ARS'),(132,'gateway_firstdata_connect_payment_method',''),(133,'gateway_gocardless_enabled','0'),(134,'gateway_gocardless_appId',''),(135,'gateway_gocardless_merchantId',''),(136,'gateway_gocardless_accessToken',''),(137,'gateway_gocardless_testMode','0'),(138,'gateway_gocardless_currency','ARS'),(139,'gateway_gocardless_payment_method',''),(140,'gateway_migs_threeparty_enabled','0'),(141,'gateway_migs_threeparty_merchantId',''),(142,'gateway_migs_threeparty_merchantAccessCode',''),(143,'gateway_migs_threeparty_secureHash',''),(144,'gateway_migs_threeparty_currency','ARS'),(145,'gateway_migs_threeparty_payment_method',''),(146,'gateway_migs_twoparty_enabled','0'),(147,'gateway_migs_twoparty_merchantId',''),(148,'gateway_migs_twoparty_merchantAccessCode',''),(149,'gateway_migs_twoparty_secureHash',''),(150,'gateway_migs_twoparty_currency','ARS'),(151,'gateway_migs_twoparty_payment_method',''),(152,'gateway_mollie_enabled','0'),(153,'gateway_mollie_apiKey',''),(154,'gateway_mollie_currency','ARS'),(155,'gateway_mollie_payment_method',''),(156,'gateway_multisafepay_enabled','0'),(157,'gateway_multisafepay_accountId',''),(158,'gateway_multisafepay_siteId',''),(159,'gateway_multisafepay_siteCode',''),(160,'gateway_multisafepay_testMode','0'),(161,'gateway_multisafepay_currency','ARS'),(162,'gateway_multisafepay_payment_method',''),(163,'gateway_netaxept_enabled','0'),(164,'gateway_netaxept_merchantId',''),(165,'gateway_netaxept_testMode','0'),(166,'gateway_netaxept_currency','ARS'),(167,'gateway_netaxept_payment_method',''),(168,'gateway_netbanx_enabled','0'),(169,'gateway_netbanx_accountNumber',''),(170,'gateway_netbanx_storeId',''),(171,'gateway_netbanx_testMode','0'),(172,'gateway_netbanx_currency','ARS'),(173,'gateway_netbanx_payment_method',''),(174,'gateway_payfast_enabled','0'),(175,'gateway_payfast_merchantId',''),(176,'gateway_payfast_merchantKey',''),(177,'gateway_payfast_pdtKey',''),(178,'gateway_payfast_testMode','0'),(179,'gateway_payfast_currency','ARS'),(180,'gateway_payfast_payment_method',''),(181,'gateway_payflow_pro_enabled','0'),(182,'gateway_payflow_pro_username',''),(183,'gateway_payflow_pro_vendor',''),(184,'gateway_payflow_pro_partner',''),(185,'gateway_payflow_pro_testMode','0'),(186,'gateway_payflow_pro_currency','ARS'),(187,'gateway_payflow_pro_payment_method',''),(188,'gateway_paymentexpress_pxpay_enabled','0'),(189,'gateway_paymentexpress_pxpay_username',''),(190,'gateway_paymentexpress_pxpay_pxPostUsername',''),(191,'gateway_paymentexpress_pxpay_testMode','0'),(192,'gateway_paymentexpress_pxpay_currency','ARS'),(193,'gateway_paymentexpress_pxpay_payment_method',''),(194,'gateway_paymentexpress_pxpost_enabled','0'),(195,'gateway_paymentexpress_pxpost_username',''),(196,'gateway_paymentexpress_pxpost_testMode','0'),(197,'gateway_paymentexpress_pxpost_currency','ARS'),(198,'gateway_paymentexpress_pxpost_payment_method',''),(199,'gateway_paypal_express_enabled','0'),(200,'gateway_paypal_express_username',''),(201,'gateway_paypal_express_testMode','0'),(202,'gateway_paypal_express_currency','ARS'),(203,'gateway_paypal_express_payment_method',''),(204,'gateway_paypal_pro_enabled','0'),(205,'gateway_paypal_pro_username',''),(206,'gateway_paypal_pro_signature',''),(207,'gateway_paypal_pro_testMode','0'),(208,'gateway_paypal_pro_currency','ARS'),(209,'gateway_paypal_pro_payment_method',''),(210,'gateway_pin_enabled','0'),(211,'gateway_pin_testMode','0'),(212,'gateway_pin_currency','ARS'),(213,'gateway_pin_payment_method',''),(214,'gateway_sagepay_direct_enabled','0'),(215,'gateway_sagepay_direct_vendor',''),(216,'gateway_sagepay_direct_testMode','0'),(217,'gateway_sagepay_direct_referrerId',''),(218,'gateway_sagepay_direct_currency','ARS'),(219,'gateway_sagepay_direct_payment_method',''),(220,'gateway_sagepay_server_enabled','0'),(221,'gateway_sagepay_server_vendor',''),(222,'gateway_sagepay_server_testMode','0'),(223,'gateway_sagepay_server_referrerId',''),(224,'gateway_sagepay_server_currency','ARS'),(225,'gateway_sagepay_server_payment_method',''),(226,'gateway_securepay_directpost_enabled','0'),(227,'gateway_securepay_directpost_merchantId',''),(228,'gateway_securepay_directpost_testMode','0'),(229,'gateway_securepay_directpost_currency','ARS'),(230,'gateway_securepay_directpost_payment_method',''),(231,'gateway_stripe_enabled','0'),(232,'gateway_stripe_currency','ARS'),(233,'gateway_stripe_payment_method',''),(234,'gateway_targetpay_directebanking_enabled','0'),(235,'gateway_targetpay_directebanking_subAccountId',''),(236,'gateway_targetpay_directebanking_currency','ARS'),(237,'gateway_targetpay_directebanking_payment_method',''),(238,'gateway_targetpay_ideal_enabled','0'),(239,'gateway_targetpay_ideal_subAccountId',''),(240,'gateway_targetpay_ideal_currency','ARS'),(241,'gateway_targetpay_ideal_payment_method',''),(242,'gateway_targetpay_mrcash_enabled','0'),(243,'gateway_targetpay_mrcash_subAccountId',''),(244,'gateway_targetpay_mrcash_currency','ARS'),(245,'gateway_targetpay_mrcash_payment_method',''),(246,'gateway_twocheckout_enabled','0'),(247,'gateway_twocheckout_accountNumber',''),(248,'gateway_twocheckout_testMode','0'),(249,'gateway_twocheckout_currency','ARS'),(250,'gateway_twocheckout_payment_method',''),(251,'gateway_worldpay_enabled','0'),(252,'gateway_worldpay_installationId',''),(253,'gateway_worldpay_accountId',''),(254,'gateway_worldpay_testMode','0'),(255,'gateway_worldpay_currency','ARS'),(256,'gateway_worldpay_payment_method','');

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

CREATE TABLE `ip_tasks` (
  `task_id` int NOT NULL AUTO_INCREMENT,
  `project_id` int NOT NULL,
  `task_name` text,
  `task_description` longtext NOT NULL,
  `task_price` decimal(20,2) DEFAULT NULL,
  `task_finish_date` date NOT NULL,
  `task_status` tinyint(1) NOT NULL,
  `tax_rate_id` int 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 NOT NULL AUTO_INCREMENT,
  `tax_rate_name` text,
  `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_units`
--

CREATE TABLE `ip_units` (
  `unit_id` int NOT NULL AUTO_INCREMENT,
  `unit_name` varchar(50) DEFAULT NULL,
  `unit_name_plrl` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`unit_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ip_units`
--


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

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

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


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

CREATE TABLE `ip_user_clients` (
  `user_client_id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `client_id` int 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 NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `user_custom_fieldid` int NOT NULL,
  `user_custom_fieldvalue` text,
  PRIMARY KEY (`user_custom_id`),
  UNIQUE KEY `user_id` (`user_id`,`user_custom_fieldid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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


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

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

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

INSERT INTO `ip_versions` VALUES (1,'1606574686','000_1.0.0.sql',0),(2,'1606574697','001_1.0.1.sql',0),(3,'1606574697','002_1.0.2.sql',0),(4,'1606574698','003_1.1.0.sql',0),(5,'1606574698','004_1.1.1.sql',0),(6,'1606574698','005_1.1.2.sql',0),(7,'1606574698','006_1.2.0.sql',0),(8,'1606574698','007_1.2.1.sql',0),(9,'1606574698','008_1.3.0.sql',0),(10,'1606574698','009_1.3.1.sql',0),(11,'1606574698','010_1.3.2.sql',0),(12,'1606574698','011_1.3.3.sql',0),(13,'1606574698','012_1.4.0.sql',0),(14,'1606574698','013_1.4.1.sql',0),(15,'1606574698','014_1.4.2.sql',0),(16,'1606574698','015_1.4.3.sql',0),(17,'1606574698','016_1.4.4.sql',0),(18,'1606574698','017_1.4.5.sql',0),(19,'1606574698','018_1.4.6.sql',0),(20,'1606574700','019_1.4.7.sql',0),(21,'1606574700','020_1.4.8.sql',0),(22,'1606574700','021_1.4.9.sql',0),(23,'1606574700','022_1.4.10.sql',0),(24,'1606574701','023_1.5.0.sql',0),(25,'1606574701','024_1.5.1.sql',0),(26,'1606574701','025_1.5.2.sql',0),(27,'1606574701','026_1.5.3.sql',0),(28,'1606574701','027_1.5.4.sql',0),(29,'1606574701','028_1.5.5.sql',0),(30,'1606574701','029_1.5.6.sql',0),(31,'1606574701','030_1.5.7.sql',0),(32,'1606574701','031_1.5.8.sql',0),(33,'1606574701','032_1.5.9.sql',0),(34,'1606574701','033_1.5.10.sql',0),(35,'1606574701','034_1.5.11.sql',0);


