SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
-- --------------------------------------------------------
-- Table structure for table `accounts`
CREATE TABLE `accounts` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`timezone_id` int(10) unsigned DEFAULT NULL,
`date_format_id` int(10) unsigned DEFAULT NULL,
`datetime_format_id` int(10) unsigned DEFAULT NULL,
`currency_id` int(10) unsigned DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`ip` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`account_key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`last_login` timestamp NULL DEFAULT NULL,
`address1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`address2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`city` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`state` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`postal_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`country_id` int(10) unsigned DEFAULT NULL,
`invoice_terms` text COLLATE utf8_unicode_ci,
`email_footer` text COLLATE utf8_unicode_ci,
`industry_id` int(10) unsigned DEFAULT NULL,
`size_id` int(10) unsigned DEFAULT NULL,
`invoice_taxes` tinyint(1) NOT NULL DEFAULT '1',
`invoice_item_taxes` tinyint(1) NOT NULL DEFAULT '0',
`invoice_design_id` int(10) unsigned NOT NULL DEFAULT '1',
`work_phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`work_email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`language_id` int(10) unsigned NOT NULL DEFAULT '1',
`custom_value1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`custom_value2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`fill_products` tinyint(1) NOT NULL DEFAULT '1',
`update_products` tinyint(1) NOT NULL DEFAULT '1',
`primary_color` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`secondary_color` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`hide_quantity` tinyint(1) NOT NULL DEFAULT '0',
`hide_paid_to_date` tinyint(1) NOT NULL DEFAULT '0',
`custom_invoice_taxes1` tinyint(1) DEFAULT NULL,
`custom_invoice_taxes2` tinyint(1) DEFAULT NULL,
`vat_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`invoice_number_prefix` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`invoice_number_counter` int(11) DEFAULT '1',
`quote_number_prefix` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`quote_number_counter` int(11) DEFAULT '1',
`share_counter` tinyint(1) NOT NULL DEFAULT '1',
`id_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`token_billing_type_id` smallint(6) NOT NULL DEFAULT '4',
`invoice_footer` text COLLATE utf8_unicode_ci,
`pdf_email_attachment` smallint(6) NOT NULL DEFAULT '0',
`subdomain` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`font_size` smallint(6) NOT NULL DEFAULT '9',
`invoice_labels` text COLLATE utf8_unicode_ci,
`custom_design1` mediumtext COLLATE utf8_unicode_ci,
`show_item_taxes` tinyint(1) NOT NULL DEFAULT '0',
`iframe_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`military_time` tinyint(1) NOT NULL DEFAULT '0',
`enable_reminder1` tinyint(1) NOT NULL DEFAULT '0',
`enable_reminder2` tinyint(1) NOT NULL DEFAULT '0',
`enable_reminder3` tinyint(1) NOT NULL DEFAULT '0',
`num_days_reminder1` smallint(6) NOT NULL DEFAULT '7',
`num_days_reminder2` smallint(6) NOT NULL DEFAULT '14',
`num_days_reminder3` smallint(6) NOT NULL DEFAULT '30',
`recurring_hour` smallint(6) NOT NULL DEFAULT '8',
`invoice_number_pattern` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`quote_number_pattern` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`quote_terms` text COLLATE utf8_unicode_ci,
`email_design_id` smallint(6) NOT NULL DEFAULT '1',
`enable_email_markup` tinyint(1) NOT NULL DEFAULT '0',
`website` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`direction_reminder1` smallint(6) NOT NULL DEFAULT '1',
`direction_reminder2` smallint(6) NOT NULL DEFAULT '1',
`direction_reminder3` smallint(6) NOT NULL DEFAULT '1',
`field_reminder1` smallint(6) NOT NULL DEFAULT '1',
`field_reminder2` smallint(6) NOT NULL DEFAULT '1',
`field_reminder3` smallint(6) NOT NULL DEFAULT '1',
`client_view_css` text COLLATE utf8_unicode_ci,
`header_font_id` int(10) unsigned NOT NULL DEFAULT '1',
`body_font_id` int(10) unsigned NOT NULL DEFAULT '1',
`auto_convert_quote` tinyint(1) NOT NULL DEFAULT '1',
`all_pages_footer` tinyint(1) NOT NULL,
`all_pages_header` tinyint(1) NOT NULL,
`show_currency_code` tinyint(1) NOT NULL,
`enable_portal_password` tinyint(1) NOT NULL DEFAULT '0',
`send_portal_password` tinyint(1) NOT NULL DEFAULT '0',
`recurring_invoice_number_prefix` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'R',
`enable_client_portal` tinyint(1) NOT NULL DEFAULT '1',
`invoice_fields` text COLLATE utf8_unicode_ci,
`devices` text COLLATE utf8_unicode_ci,
`logo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`logo_width` int(10) unsigned NOT NULL,
`logo_height` int(10) unsigned NOT NULL,
`logo_size` int(10) unsigned NOT NULL,
`invoice_embed_documents` tinyint(1) NOT NULL DEFAULT '0',
`document_email_attachment` tinyint(1) NOT NULL DEFAULT '0',
`enable_client_portal_dashboard` tinyint(1) NOT NULL DEFAULT '1',
`company_id` int(10) unsigned DEFAULT NULL,
`page_size` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'A4',
`live_preview` tinyint(1) NOT NULL DEFAULT '1',
`invoice_number_padding` smallint(6) NOT NULL DEFAULT '4',
`enable_second_tax_rate` tinyint(1) NOT NULL DEFAULT '0',
`auto_bill_on_due_date` tinyint(1) NOT NULL DEFAULT '0',
`start_of_week` int(11) NOT NULL,
`enable_buy_now_buttons` tinyint(1) NOT NULL DEFAULT '0',
`include_item_taxes_inline` tinyint(1) NOT NULL DEFAULT '0',
`financial_year_start` date DEFAULT NULL,
`enabled_modules` smallint(6) NOT NULL DEFAULT '63',
`enabled_dashboard_sections` smallint(6) NOT NULL DEFAULT '7',
`show_accept_invoice_terms` tinyint(1) NOT NULL DEFAULT '0',
`show_accept_quote_terms` tinyint(1) NOT NULL DEFAULT '0',
`require_invoice_signature` tinyint(1) NOT NULL DEFAULT '0',
`require_quote_signature` tinyint(1) NOT NULL DEFAULT '0',
`client_number_prefix` text COLLATE utf8_unicode_ci,
`client_number_counter` int(11) DEFAULT '0',
`client_number_pattern` text COLLATE utf8_unicode_ci,
`domain_id` tinyint(3) unsigned DEFAULT '1',
`payment_terms` tinyint(4) DEFAULT NULL,
`reset_counter_frequency_id` smallint(6) DEFAULT NULL,
`payment_type_id` smallint(6) DEFAULT NULL,
`gateway_fee_enabled` tinyint(1) NOT NULL DEFAULT '0',
`reset_counter_date` date DEFAULT NULL,
`tax_name1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`tax_rate1` decimal(13,3) NOT NULL,
`tax_name2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`tax_rate2` decimal(13,3) NOT NULL,
`quote_design_id` int(10) unsigned NOT NULL DEFAULT '1',
`custom_design2` mediumtext COLLATE utf8_unicode_ci,
`custom_design3` mediumtext COLLATE utf8_unicode_ci,
`analytics_key` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`credit_number_counter` int(11) DEFAULT '0',
`credit_number_prefix` text COLLATE utf8_unicode_ci,
`credit_number_pattern` text COLLATE utf8_unicode_ci,
`task_rate` decimal(12,4) NOT NULL DEFAULT '0.0000',
`inclusive_taxes` tinyint(1) NOT NULL DEFAULT '0',
`convert_products` tinyint(1) NOT NULL DEFAULT '0',
`enable_reminder4` tinyint(1) NOT NULL DEFAULT '0',
`signature_on_pdf` tinyint(1) NOT NULL DEFAULT '0',
`ubl_email_attachment` tinyint(1) NOT NULL DEFAULT '0',
`auto_archive_invoice` tinyint(1) DEFAULT '0',
`auto_archive_quote` tinyint(1) DEFAULT '0',
`auto_email_invoice` tinyint(1) DEFAULT '1',
`send_item_details` tinyint(1) DEFAULT '0',
`custom_fields` mediumtext COLLATE utf8_unicode_ci,
`background_image_id` int(10) unsigned DEFAULT NULL,
`custom_messages` mediumtext COLLATE utf8_unicode_ci,
`is_custom_domain` tinyint(1) NOT NULL DEFAULT '0',
`show_product_notes` tinyint(1) NOT NULL DEFAULT '0',
UNIQUE KEY `accounts_account_key_unique` (`account_key`),
KEY `accounts_timezone_id_foreign` (`timezone_id`),
KEY `accounts_date_format_id_foreign` (`date_format_id`),
KEY `accounts_datetime_format_id_foreign` (`datetime_format_id`),
KEY `accounts_country_id_foreign` (`country_id`),
KEY `accounts_currency_id_foreign` (`currency_id`),
KEY `accounts_industry_id_foreign` (`industry_id`),
KEY `accounts_size_id_foreign` (`size_id`),
KEY `accounts_invoice_design_id_foreign` (`invoice_design_id`),
KEY `accounts_language_id_foreign` (`language_id`),
KEY `accounts_company_id_foreign` (`company_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
-- Dumping data for table `accounts`
INSERT INTO `accounts` VALUES
(1, NULL, NULL, NULL, 1, '[[regtime]]', '[[regtime]]', NULL, NULL, '[[clientip]]', '[[account_key]]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 1, NULL, NULL, 1, NULL, NULL, 1, 1, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 1, NULL, 1, 1, NULL, 4, NULL, 0, NULL, 9, NULL, NULL, 0, NULL, 0, 0, 0, 0, 7, 14, 30, 8, NULL, NULL, NULL, 1, 0, NULL, 1, 1, 1, 1, 1, 1, NULL, 1, 1, 1, 0, 0, 0, 0, 0, 'R', 1, NULL, NULL, NULL, 0, 0, 0, 0, 0, 1, 1, 'A4', 1, 4, 0, 0, 0, 0, 0, NULL, 63, 7, 0, 0, 0, 0, NULL, 0, NULL, 1, NULL, NULL, NULL, 0, NULL, NULL, '0.000', NULL, '0.000', 1, NULL, NULL, NULL, 0, NULL, NULL, '0.0000', 0, 0, 0, 0, 0, 0, 0, 1, 0, NULL, NULL, NULL, 0, 0);
-- --------------------------------------------------------
-- Table structure for table `account_email_settings`
CREATE TABLE `account_email_settings` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`account_id` int(10) unsigned NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`reply_to_email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`bcc_email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`email_subject_invoice` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`email_subject_quote` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`email_subject_payment` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`email_template_invoice` text COLLATE utf8_unicode_ci NOT NULL,
`email_template_quote` text COLLATE utf8_unicode_ci NOT NULL,
`email_template_payment` text COLLATE utf8_unicode_ci NOT NULL,
`email_subject_reminder1` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`email_subject_reminder2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`email_subject_reminder3` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`email_template_reminder1` text COLLATE utf8_unicode_ci NOT NULL,
`email_template_reminder2` text COLLATE utf8_unicode_ci NOT NULL,
`email_template_reminder3` text COLLATE utf8_unicode_ci NOT NULL,
`late_fee1_amount` decimal(13,2) DEFAULT NULL,
`late_fee1_percent` decimal(13,3) DEFAULT NULL,
`late_fee2_amount` decimal(13,2) DEFAULT NULL,
`late_fee2_percent` decimal(13,3) DEFAULT NULL,
`late_fee3_amount` decimal(13,2) DEFAULT NULL,
`late_fee3_percent` decimal(13,3) DEFAULT NULL,
`email_subject_reminder4` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`email_template_reminder4` text COLLATE utf8_unicode_ci,
`frequency_id_reminder4` int(10) unsigned DEFAULT NULL,
`email_subject_proposal` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`email_template_proposal` text COLLATE utf8_unicode_ci,
`forward_url_for_v5` text COLLATE utf8_unicode_ci NOT NULL,
`is_disabled` tinyint(1) NOT NULL DEFAULT '0',
KEY `account_email_settings_account_id_index` (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
-- Dumping data for table `account_email_settings`
INSERT INTO `account_email_settings` VALUES
(1, 1, '[[regtime]]', '[[regtime]]', NULL, NULL, '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', 0);
-- --------------------------------------------------------
-- Table structure for table `account_gateways`
CREATE TABLE `account_gateways` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`account_id` int(10) unsigned NOT NULL,
`user_id` int(10) unsigned NOT NULL,
`gateway_id` int(10) unsigned NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`config` text COLLATE utf8_unicode_ci NOT NULL,
`public_id` int(10) unsigned NOT NULL,
`accepted_credit_cards` int(10) unsigned DEFAULT NULL,
`show_address` tinyint(1) DEFAULT '1',
`update_address` tinyint(1) DEFAULT '1',
`require_cvv` tinyint(1) DEFAULT '1',
`show_shipping_address` tinyint(1) DEFAULT '0',
UNIQUE KEY `account_gateways_account_id_public_id_unique` (`account_id`,`public_id`),
KEY `account_gateways_gateway_id_foreign` (`gateway_id`),
KEY `account_gateways_user_id_foreign` (`user_id`),
KEY `account_gateways_public_id_index` (`public_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `account_gateway_settings`
CREATE TABLE `account_gateway_settings` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`account_id` int(10) unsigned NOT NULL,
`user_id` int(10) unsigned NOT NULL,
`gateway_type_id` int(10) unsigned DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`min_limit` int(10) unsigned DEFAULT NULL,
`max_limit` int(10) unsigned DEFAULT NULL,
`fee_amount` decimal(13,2) DEFAULT NULL,
`fee_percent` decimal(13,3) DEFAULT NULL,
`fee_tax_name1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`fee_tax_name2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`fee_tax_rate1` decimal(13,3) DEFAULT NULL,
`fee_tax_rate2` decimal(13,3) DEFAULT NULL,
KEY `account_gateway_settings_account_id_foreign` (`account_id`),
KEY `account_gateway_settings_user_id_foreign` (`user_id`),
KEY `account_gateway_settings_gateway_type_id_foreign` (`gateway_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `account_gateway_tokens`
CREATE TABLE `account_gateway_tokens` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`account_id` int(10) unsigned NOT NULL,
`contact_id` int(10) unsigned NOT NULL,
`account_gateway_id` int(10) unsigned NOT NULL,
`client_id` int(10) unsigned NOT NULL,
`token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`default_payment_method_id` int(10) unsigned DEFAULT NULL,
KEY `account_gateway_tokens_account_id_foreign` (`account_id`),
KEY `account_gateway_tokens_contact_id_foreign` (`contact_id`),
KEY `account_gateway_tokens_account_gateway_id_foreign` (`account_gateway_id`),
KEY `account_gateway_tokens_client_id_foreign` (`client_id`),
KEY `account_gateway_tokens_default_payment_method_id_foreign` (`default_payment_method_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `account_tokens`
CREATE TABLE `account_tokens` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`account_id` int(10) unsigned NOT NULL,
`user_id` int(10) unsigned NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`public_id` int(10) unsigned DEFAULT NULL,
UNIQUE KEY `account_tokens_token_unique` (`token`),
UNIQUE KEY `account_tokens_account_id_public_id_unique` (`account_id`,`public_id`),
KEY `account_tokens_user_id_foreign` (`user_id`),
KEY `account_tokens_account_id_index` (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `activities`
CREATE TABLE `activities` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`account_id` int(10) unsigned NOT NULL,
`user_id` int(10) unsigned NOT NULL,
`client_id` int(10) unsigned DEFAULT NULL,
`contact_id` int(10) unsigned DEFAULT NULL,
`payment_id` int(10) unsigned DEFAULT NULL,
`invoice_id` int(10) unsigned DEFAULT NULL,
`credit_id` int(10) unsigned DEFAULT NULL,
`invitation_id` int(10) unsigned DEFAULT NULL,
`task_id` int(10) unsigned DEFAULT NULL,
`json_backup` text COLLATE utf8_unicode_ci,
`activity_type_id` int(11) NOT NULL,
`adjustment` decimal(13,2) DEFAULT NULL,
`balance` decimal(13,2) DEFAULT NULL,
`token_id` int(10) unsigned DEFAULT NULL,
`ip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`is_system` tinyint(1) NOT NULL DEFAULT '0',
`expense_id` int(10) unsigned DEFAULT NULL,
`notes` text COLLATE utf8_unicode_ci,
KEY `activities_account_id_foreign` (`account_id`),
KEY `activities_user_id_index` (`user_id`),
KEY `activities_client_id_foreign` (`client_id`),
KEY `activities_payment_id_index` (`payment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `affiliates`
CREATE TABLE `affiliates` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`affiliate_key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`payment_title` text COLLATE utf8_unicode_ci NOT NULL,
`payment_subtitle` text COLLATE utf8_unicode_ci NOT NULL,
`price` decimal(7,2) DEFAULT NULL,
UNIQUE KEY `affiliates_affiliate_key_unique` (`affiliate_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `banks`
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`remote_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`bank_library_id` int(11) NOT NULL DEFAULT '1',
`config` text COLLATE utf8_unicode_ci NOT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=387 ;
-- Dumping data for table `banks`
INSERT INTO `banks` VALUES
(1, 'ING DIRECT (Canada)', '421', 1, '{"fid":"061400152","org":"INGDirectCanada","url":"https:\\/\\/ofx.ingdirect.ca"}'),
(2, 'Safe Credit Union - OFX Beta', '422', 1, '{"fid":"321173742","org":"DI","url":"https:\\/\\/ofxcert.diginsite.com\\/cmr\\/cmr.ofx"}'),
(3, 'Ascentra Credit Union', '423', 1, '{"fid":"273973456","org":"Alcoa Employees&Community CU","url":"https:\\/\\/alc.usersonlnet.com\\/scripts\\/isaofx.dll"}'),
(4, 'American Express Card', '424', 1, '{"fid":"3101","org":"AMEX","url":"https:\\/\\/online.americanexpress.com\\/myca\\/ofxdl\\/desktop\\/desktopDownload.do?request_type=nl_ofxdownload"}'),
(5, 'TD Ameritrade', '425', 1, '{"fid":"5024","org":"ameritrade.com","url":"https:\\/\\/ofxs.ameritrade.com\\/cgi-bin\\/apps\\/OFX"}'),
(6, 'Truliant FCU', '426', 1, '{"fid":"253177832","org":"DI","url":"https:\\/\\/ofxdi.diginsite.com\\/cmr\\/cmr.ofx"}'),
(7, 'AT&T Universal Card', '427', 1, '{"fid":"24909","org":"Citigroup","url":"https:\\/\\/secureofx2.bankhost.com\\/citi\\/cgi-forte\\/ofx_rt?servicename=ofx_rt&pagename=ofx"}'),
(8, 'Bank One', '428', 1, '{"fid":"5811","org":"B1","url":"https:\\/\\/onlineofx.chase.com\\/chase.ofx"}'),
(9, 'Bank of Stockton', '429', 1, '{"fid":"3901","org":"BOS","url":"https:\\/\\/internetbanking.bankofstockton.com\\/scripts\\/serverext.dll"}'),
(10, 'Bank of the Cascades', '430', 1, '{"fid":"4751","org":"JackHenry","url":"https:\\/\\/directline.netteller.com"}'),
(11, 'Centra Credit Union', '431', 1, '{"fid":"274972883","org":"Centra CU","url":"https:\\/\\/centralink.org\\/scripts\\/isaofx.dll"}'),
(12, 'Centura Bank', '432', 1, '{"fid":"1901","org":"Centura Bank","url":"https:\\/\\/www.oasis.cfree.com\\/1901.ofxgp"}'),
(13, 'Charles Schwab&Co., INC', '433', 1, '{"fid":"5104","org":"ISC","url":"https:\\/\\/ofx.schwab.com\\/cgi_dev\\/ofx_server"}'),
(14, 'JPMorgan Chase Bank (Texas)', '434', 1, '{"fid":"5301","org":"Chase Bank of Texas","url":"https:\\/\\/www.oasis.cfree.com\\/5301.ofxgp"}'),
(15, 'JPMorgan Chase Bank', '435', 1, '{"fid":"1601","org":"Chase Bank","url":"https:\\/\\/www.oasis.cfree.com\\/1601.ofxgp"}'),
(16, 'Colonial Bank', '436', 1, '{"fid":"1046","org":"Colonial Banc Group","url":"https:\\/\\/www.oasis.cfree.com\\/1046.ofxgp"}'),
(17, 'Comerica Bank', '437', 1, '{"fid":"5601","org":"Comerica","url":"https:\\/\\/www.oasis.cfree.com\\/5601.ofxgp"}'),
(18, 'Commerce Bank NJ, PA, NY&DE', '438', 1, '{"fid":"1001","org":"CommerceBank","url":"https:\\/\\/www.commerceonlinebanking.com\\/scripts\\/serverext.dll"}'),
(19, 'Commerce Bank, NA', '439', 1, '{"fid":"4001","org":"Commerce Bank NA","url":"https:\\/\\/www.oasis.cfree.com\\/4001.ofxgp"}'),
(20, 'Commercial Federal Bank', '440', 1, '{"fid":"4801","org":"CommercialFederalBank","url":"https:\\/\\/www.oasis.cfree.com\\/4801.ofxgp"}'),
(21, 'COMSTAR FCU', '441', 1, '{"fid":"255074988","org":"Comstar Federal Credit Union","url":"https:\\/\\/pcu.comstarfcu.org\\/scripts\\/isaofx.dll"}'),
(22, 'SunTrust', '442', 1, '{"fid":"2801","org":"SunTrust PC Banking","url":"https:\\/\\/www.oasis.cfree.com\\/2801.ofxgp"}'),
(23, 'Denali Alaskan FCU', '443', 1, '{"fid":"1","org":"Denali Alaskan FCU","url":"https:\\/\\/remotebanking.denalifcu.com\\/ofx\\/ofx.dll"}'),
(24, 'Discover Card', '444', 1, '{"fid":"7101","org":"Discover Financial Services","url":"https:\\/\\/ofx.discovercard.com"}'),
(25, 'E*TRADE', '446', 1, '{"fid":"fldProv_mProvBankId","org":"fldProv_mId","url":"https:\\/\\/ofx.etrade.com\\/cgi-ofx\\/etradeofx"}'),
(26, 'Eastern Bank', '447', 1, '{"fid":"6201","org":"Eastern Bank","url":"https:\\/\\/www.oasis.cfree.com\\/6201.ofxgp"}'),
(27, 'EDS Credit Union', '448', 1, '{"fid":"311079474","org":"EDS CU","url":"https:\\/\\/eds.usersonlnet.com\\/scripts\\/isaofx.dll"}'),
(28, 'Fidelity Investments', '449', 1, '{"fid":"7776","org":"fidelity.com","url":"https:\\/\\/ofx.fidelity.com\\/ftgw\\/OFX\\/clients\\/download"}'),
(29, 'Fifth Third Bancorp', '450', 1, '{"fid":"5829","org":"Fifth Third Bank","url":"https:\\/\\/banking.53.com\\/ofx\\/OFXServlet"}'),
(30, 'First Tech Credit Union', '451', 1, '{"fid":"2243","org":"First Tech Credit Union","url":"https:\\/\\/ofx.firsttechcu.com"}'),
(31, 'zWachovia', '452', 1, '{"fid":"4301","org":"Wachovia","url":"https:\\/\\/www.oasis.cfree.com\\/4301.ofxgp"}'),
(32, 'KeyBank', '453', 1, '{"fid":"5901","org":"KeyBank","url":"https:\\/\\/www.oasis.cfree.com\\/fip\\/genesis\\/prod\\/05901.ofx"}'),
(33, 'Mellon Bank', '454', 1, '{"fid":"1226","org":"Mellon Bank","url":"https:\\/\\/www.oasis.cfree.com\\/1226.ofxgp"}'),
(34, 'LaSalle Bank Midwest', '455', 1, '{"fid":"1101","org":"LaSalleBankMidwest","url":"https:\\/\\/www.oasis.cfree.com\\/1101.ofxgp"}'),
(35, 'Nantucket Bank', '456', 1, '{"fid":"466","org":"Nantucket","url":"https:\\/\\/ofx.onlinencr.com\\/scripts\\/serverext.dll"}'),
(36, 'National Penn Bank', '457', 1, '{"fid":"6301","org":"National Penn Bank","url":"https:\\/\\/www.oasis.cfree.com\\/6301.ofxgp"}'),
(37, 'Nevada State Bank - New', '458', 1, '{"fid":"1121","org":"295-3","url":"https:\\/\\/quicken.metavante.com\\/ofx\\/OFXServlet"}'),
(38, 'UBS Financial Services Inc.', '459', 1, '{"fid":"7772","org":"Intuit","url":"https:\\/\\/ofx1.ubs.com\\/eftxweb\\/access.ofx"}'),
(39, 'Patelco CU', '460', 1, '{"fid":"2000","org":"Patelco Credit Union","url":"https:\\/\\/ofx.patelco.org"}'),
(40, 'Mercantile Brokerage Services', '461', 1, '{"fid":"011","org":"Mercantile Brokerage","url":"https:\\/\\/ofx.netxclient.com\\/cgi\\/OFXNetx"}'),
(41, 'Regions Bank', '462', 1, '{"fid":"243","org":"regions.com","url":"https:\\/\\/ofx.morgankeegan.com\\/begasp\\/directtocore.asp"}'),
(42, 'Spectrum Connect/Reich&Tang', '463', 1, '{"fid":"6510","org":"SpectrumConnect","url":"https:\\/\\/www.oasis.cfree.com\\/6510.ofxgp"}'),
(43, 'Smith Barney - Transactions', '464', 1, '{"fid":"3201","org":"SmithBarney","url":"https:\\/\\/www.oasis.cfree.com\\/3201.ofxgp"}'),
(44, 'Southwest Airlines FCU', '465', 1, '{"fid":"311090673","org":"Southwest Airlines EFCU","url":"https:\\/\\/www.swacuflashbp.org\\/scripts\\/isaofx.dll"}'),
(45, 'Technology Credit Union - CA', '467', 1, '{"fid":"11257","org":"Tech CU","url":"https:\\/\\/webbranchofx.techcu.com\\/TekPortalOFX\\/servlet\\/TP_OFX_Controller"}'),
(46, 'UMB Bank', '468', 1, '{"fid":"0","org":"UMB","url":"https:\\/\\/pcbanking.umb.com\\/hs_ofx\\/hsofx.dll"}'),
(47, 'Union Bank of California', '469', 1, '{"fid":"2901","org":"Union Bank of California","url":"https:\\/\\/www.oasis.cfree.com\\/2901.ofxgp"}'),
(48, 'United Teletech Financial', '470', 1, '{"fid":"221276011","org":"DI","url":"https:\\/\\/ofxcore.digitalinsight.com:443\\/servlet\\/OFXCoreServlet"}'),
(49, 'US Bank', '471', 1, '{"fid":"1401","org":"US Bank","url":"https:\\/\\/www.oasis.cfree.com\\/1401.ofxgp"}'),
(50, 'Bank of America (All except CA, WA,&ID)', '472', 1, '{"fid":"6812","org":"HAN","url":"https:\\/\\/ofx.bankofamerica.com\\/cgi-forte\\/fortecgi?servicename=ofx_2-3&pagename=ofx"}'),
(51, 'Wells Fargo', '473', 1, '{"fid":"3000","org":"WF","url":"https:\\/\\/ofxdc.wellsfargo.com\\/ofx\\/process.ofx"}'),
(52, 'LaSalle Bank NA', '474', 1, '{"fid":"6501","org":"LaSalle Bank NA","url":"https:\\/\\/www.oasis.cfree.com\\/6501.ofxgp"}'),
(53, 'BB&T', '475', 1, '{"fid":"BB&T","org":"BB&T","url":"https:\\/\\/eftx.bbt.com\\/eftxweb\\/access.ofx"}'),
(54, 'Los Alamos National Bank', '476', 1, '{"fid":"107001012","org":"LANB","url":"https:\\/\\/ofx.lanb.com\\/ofx\\/ofxrelay.dll"}'),
(55, 'Citadel FCU', '477', 1, '{"fid":"citadel","org":"CitadelFCU","url":"https:\\/\\/pcu.citadelfcu.org\\/scripts\\/isaofx.dll"}'),
(56, 'Clearview Federal Credit Union', '478', 1, '{"fid":"243083237","org":"Clearview Federal Credit Union","url":"https:\\/\\/www.pcu.clearviewfcu.org\\/scripts\\/isaofx.dll"}'),
(57, 'Vanguard Group, The', '479', 1, '{"fid":"1358","org":"The Vanguard Group","url":"https:\\/\\/vesnc.vanguard.com\\/us\\/OfxDirectConnectServlet"}'),
(58, 'First Citizens Bank - NC, VA, WV', '480', 1, '{"fid":"5013","org":"First Citizens Bank NC, VA, WV","url":"https:\\/\\/www.oasis.cfree.com\\/5013.ofxgp"}'),
(59, 'Northern Trust - Banking', '481', 1, '{"fid":"5804","org":"ORG","url":"https:\\/\\/www3883.ntrs.com\\/nta\\/ofxservlet"}'),
(60, 'The Mechanics Bank', '482', 1, '{"fid":"121102036","org":"TMB","url":"https:\\/\\/ofx.mechbank.com\\/OFXServer\\/ofxsrvr.dll"}'),
(61, 'USAA Federal Savings Bank', '483', 1, '{"fid":"24591","org":"USAA","url":"https:\\/\\/service2.usaa.com\\/ofx\\/OFXServlet"}'),
(62, 'Florida Telco CU', '484', 1, '{"fid":"FTCU","org":"FloridaTelcoCU","url":"https:\\/\\/ppc.floridatelco.org\\/scripts\\/isaofx.dll"}'),
(63, 'DuPont Community Credit Union', '485', 1, '{"fid":"251483311","org":"DuPont Community Credit Union","url":"https:\\/\\/pcu.mydccu.com\\/scripts\\/isaofx.dll"}'),
(64, 'Central Florida Educators FCU', '486', 1, '{"fid":"590678236","org":"CentralFloridaEduc","url":"https:\\/\\/www.mattweb.cfefcu.com\\/scripts\\/isaofx.dll"}'),
(65, 'California Bank&Trust', '487', 1, '{"fid":"5006","org":"401","url":"https:\\/\\/pfm.metavante.com\\/ofx\\/OFXServlet"}'),
(66, 'First Commonwealth FCU', '488', 1, '{"fid":"231379199","org":"FirstCommonwealthFCU","url":"https:\\/\\/pcu.firstcomcu.org\\/scripts\\/isaofx.dll"}'),
(67, 'Ameriprise Financial Services, Inc.', '489', 1, '{"fid":"3102","org":"AMPF","url":"https:\\/\\/www25.ameriprise.com\\/AMPFWeb\\/ofxdl\\/us\\/download?request_type=nl_desktopdownload"}'),
(68, 'AltaOne Federal Credit Union', '490', 1, '{"fid":"322274462","org":"AltaOneFCU","url":"https:\\/\\/pcu.altaone.org\\/scripts\\/isaofx.dll"}'),
(69, 'A. G. Edwards and Sons, Inc.', '491', 1, '{"fid":"43-0895447","org":"A.G. Edwards","url":"https:\\/\\/ofx.agedwards.com"}'),
(70, 'Educational Employees CU Fresno', '492', 1, '{"fid":"321172594","org":"Educational Employees C U","url":"https:\\/\\/www.eecuonline.org\\/scripts\\/isaofx.dll"}'),
(71, 'Hawthorne Credit Union', '493', 1, '{"fid":"271979193","org":"Hawthorne Credit Union","url":"https:\\/\\/hwt.usersonlnet.com\\/scripts\\/isaofx.dll"}'),
(72, 'Firstar', '494', 1, '{"fid":"1255","org":"Firstar","url":"https:\\/\\/www.oasis.cfree.com\\/1255.ofxgp"}'),
(73, 'myStreetscape', '495', 1, '{"fid":"7784","org":"Fidelity","url":"https:\\/\\/ofx.ibgstreetscape.com:443"}'),
(74, 'Collegedale Credit Union', '496', 1, '{"fid":"35GFA","org":"CollegedaleCU","url":"https:\\/\\/www.netit.financial-net.com\\/ofx"}'),
(75, 'GCS Federal Credit Union', '498', 1, '{"fid":"281076853","org":"Granite City Steel cu","url":"https:\\/\\/pcu.mygcscu.com\\/scripts\\/isaofx.dll"}'),
(76, 'Vantage Credit Union', '499', 1, '{"fid":"281081479","org":"EECU-St. Louis","url":"https:\\/\\/secure2.eecu.com\\/scripts\\/isaofx.dll"}'),
(77, 'Morgan Stanley ClientServ', '500', 1, '{"fid":"1235","org":"msdw.com","url":"https:\\/\\/ofx.morganstanleyclientserv.com\\/ofx\\/ProfileMSMoney.ofx"}'),
(78, 'Kennedy Space Center FCU', '501', 1, '{"fid":"263179532","org":"Kennedy Space Center FCU","url":"https:\\/\\/www.pcu.kscfcu.org\\/scripts\\/isaofx.dll"}'),
(79, 'Sierra Central Credit Union', '502', 1, '{"fid":"321174770","org":"Sierra Central Credit Union","url":"https:\\/\\/www.sierracpu.com\\/scripts\\/isaofx.dll"}'),
(80, 'Virginia Educators Credit Union', '503', 1, '{"fid":"251481355","org":"Virginia Educators CU","url":"https:\\/\\/www.vecumoneylink.org\\/scripts\\/isaofx.dll"}'),
(81, 'Red Crown Federal Credit Union', '504', 1, '{"fid":"303986148","org":"Red Crown FCU","url":"https:\\/\\/cre.usersonlnet.com\\/scripts\\/isaofx.dll"}'),
(82, 'B-M S Federal Credit Union', '505', 1, '{"fid":"221277007","org":"B-M S Federal Credit Union","url":"https:\\/\\/bms.usersonlnet.com\\/scripts\\/isaofx.dll"}'),
(83, 'Fort Stewart GeorgiaFCU', '506', 1, '{"fid":"261271364","org":"Fort Stewart FCU","url":"https:\\/\\/fsg.usersonlnet.com\\/scripts\\/isaofx.dll"}'),
(84, 'Northern Trust - Investments', '507', 1, '{"fid":"6028","org":"Northern Trust Investments","url":"https:\\/\\/www3883.ntrs.com\\/nta\\/ofxservlet?accounttypegroup=INV"}'),
(85, 'Picatinny Federal Credit Union', '508', 1, '{"fid":"221275216","org":"Picatinny Federal Credit Union","url":"https:\\/\\/banking.picacreditunion.com\\/scripts\\/isaofx.dll"}'),
(86, 'SAC FEDERAL CREDIT UNION', '509', 1, '{"fid":"091901480","org":"SAC Federal CU","url":"https:\\/\\/pcu.sacfcu.com\\/scripts\\/isaofx.dll"}'),
(87, 'Merrill Lynch&Co., Inc.', '510', 1, '{"fid":"5550","org":"Merrill Lynch & Co., Inc.","url":"https:\\/\\/taxcert.mlol.ml.com\\/eftxweb\\/access.ofx"}'),
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
