CREATE TABLE `leadswift_aba_blacklist` (
  `id` int NOT NULL,
  `bank_name` varchar(100) DEFAULT NULL,
  `aba` varchar(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
                                                                                                                                                                                                                     
    
                  CREATE TABLE `leadswift_api_analytics` (
  `utm` varchar(20) NOT NULL,
  `created` date NOT NULL,
  `api` enum('lead_creation') NOT NULL,
  `error_code` smallint NOT NULL,
  `err_message` text,
  `error_count` int NOT NULL,
  PRIMARY KEY (`utm`,`created`,`api`,`error_code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
                                                                                                                                                                                                                     
    
                  CREATE TABLE `leadswift_api_logger` (
  `id` int NOT NULL AUTO_INCREMENT,
  `utm` varchar(20) NOT NULL,
  `app_id` int NOT NULL,
  `api` enum('lead_creation') DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `request` varchar(100) DEFAULT NULL,
  `requesttime` time DEFAULT NULL,
  `responsetime` time DEFAULT NULL,
  `duration` time DEFAULT NULL,
  `response` varchar(225) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `utm` (`utm`),
  KEY `app_id` (`app_id`),
  KEY `api` (`api`),
  KEY `created` (`created`),
  CONSTRAINT `leadswift_api_logger_ibfk_1` FOREIGN KEY (`app_id`) REFERENCES `leadswift_applications` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;
                                                                                                                                                                                                                     
    
                  CREATE TABLE `leadswift_applications` (
  `id` int NOT NULL AUTO_INCREMENT,
  `userid` int DEFAULT NULL,
  `loan_amount` bigint DEFAULT NULL,
  `utm` varchar(20) DEFAULT NULL,
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `approved` tinyint(1) DEFAULT NULL,
  `ip` varchar(20) DEFAULT NULL,
  `os` varchar(100) DEFAULT NULL,
  `device` varchar(30) DEFAULT NULL,
  `browser` varchar(30) DEFAULT NULL,
  `source` varchar(20) DEFAULT NULL,
  `channel` int DEFAULT '1',
  `app_mid` int DEFAULT NULL,
  `lead_mid` int DEFAULT NULL,
  `pid` varchar(250) DEFAULT '0',
  `af_web_id` varchar(250) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `utm` (`utm`),
  KEY `channel` (`channel`),
  KEY `leadswift_applications_ibfk_1` (`userid`),
  CONSTRAINT `leadswift_applications_ibfk_1` FOREIGN KEY (`userid`) REFERENCES `bdloan_usa`.`user_master` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
                                                                                                                                                                                                                     
    
                  CREATE TABLE `leadswift_applications_api_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `app_id` int NOT NULL,
  `lead_creation_success` tinyint(1) DEFAULT NULL,
  `lead_creation_error` smallint DEFAULT NULL,
  `lead_id` varchar(35) DEFAULT NULL,
  `payout` varchar(15) DEFAULT '0',
  `redirection_url` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `lead_creation_error` (`lead_creation_error`),
  KEY `app_id` (`app_id`),
  CONSTRAINT `fk_app_id` FOREIGN KEY (`app_id`) REFERENCES `leadswift_applications` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_lead_creation_error` FOREIGN KEY (`lead_creation_error`) REFERENCES `leadswift_lead_creation_error_master` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
                                                                                                                                                                                                                     
    
                  CREATE TABLE `leadswift_lead_creation_error_master` (
  `id` smallint NOT NULL AUTO_INCREMENT,
  `error` text,
  PRIMARY KEY (`id`),
  KEY `error` (`error`(255))
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
                                                                                                                                                                                                                     
    
                  CREATE TABLE `leadswift_leads_stats` (
  `date` date NOT NULL,
  `status` tinyint NOT NULL DEFAULT '0',
  `leads` int DEFAULT '0',
  PRIMARY KEY (`date`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;