CREATE TABLE `tblleads_thumbtack_mapping`
  (
     `id`                     BIGINT(20) NOT NULL auto_increment,
     `tenant_id`              BIGINT(20) NOT NULL,
     `lead_id`                BIGINT(20) NOT NULL,
     `thumbtack_lead_id`      BIGINT(20) NOT NULL,
     `thumbtack_request_body` TEXT NOT NULL,
     `addedon`                DATETIME NOT NULL,
     PRIMARY KEY (`id`),
     INDEX (`tenant_id`),
     INDEX (`lead_id`),
     INDEX (`thumbtack_lead_id`)
  )
engine = innodb; 


CREATE TABLE `tbltenant_thumbtack_mapping`
  (
     `id`                     BIGINT(20) NOT NULL auto_increment,
     `tenant_id`              BIGINT(20) NOT NULL,
     `business_id`            BIGINT(20) NOT NULL,
     `thumbtack_request_body` TEXT NOT NULL,
     `addedon`                DATETIME NOT NULL,
     PRIMARY KEY (`id`),
     INDEX (`tenant_id`),
     INDEX (`business_id`)
  )
engine = innodb;



INSERT INTO `tblapad_emailtemplates` (`emailtemplateid`, `type`, `slug`, `language`, `name`, `subject`, `message`, `fromname`, `fromemail`, `plaintext`, `active`, `order`, `is_tenant_email_config_allowed`, `is_tenant`) VALUES (NULL, 'thumbtack_expired', 'thumbtack-expired', "English", 'Thumbtack authorization expired', 'Thumbtack authorization expired', '<span style=\"font-size: 12pt;\">Hi {tenant_first_name},</span><br/><br/><span style=\"font-size: 12pt;\">You had your Thumbtack linked to Contractor+ via Thumbtack lead option from sidebar.</span><br/><br/><span style=\"font-size: 12pt;\">We noticed the link is no longer working. This could be due to an expired token, a changed password, or for a routine security checkup. Please login to Contractor+ and re-authorize your Thumbtack account ASAP to avoid any interruption in this service.</span><br/><br/><span style=\"font-size: 12pt;\">Regards,</span><br/><br/><span style=\"font-size: 12pt;\">Contractor+ App</span><br/><span style=\"font-size: 12pt;\">www.contractorplus.app</span>', '', NULL, '0', '1', '0', '0', '0');