<?xml version='1.0'?>
<schema>
	<tables>
		<table>
			<name>vtiger_ctfacebookleadintegration_trial_license</name>
			<sql><![CDATA[CREATE TABLE `vtiger_ctfacebookleadintegration_trial_license` (
        `id` int(11) NOT NULL AUTO_INCREMENT,
        `license_key` varchar(255) DEFAULT NULL,
        `status` tinyint(1) DEFAULT NULL,
        `domain` varchar(255) DEFAULT NULL,
        `apikey` varchar(255) DEFAULT NULL,
        `user_type` enum('free','premium') NOT NULL DEFAULT 'free',
        `order_id` varchar(255) DEFAULT NULL,
        PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;]]></sql>
		</table>
		<table>
			<name>ct_facebooklead_configuration</name>
			<sql><![CDATA[CREATE TABLE `ct_facebooklead_configuration` (
  `accesstoken` longtext COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;]]></sql>
		</table>
		<table>
			<name>ct_facebooklead_fieldmapping</name>
			<sql><![CDATA[CREATE TABLE `ct_facebooklead_fieldmapping` (
  `fieldmappingid` int(11) NOT NULL AUTO_INCREMENT,
  `formid` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `vtiger_fields` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `facebook_fields` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_fields` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `editable` int(19) NOT NULL DEFAULT '1',
  `enablesync` tinyint(1) NOT NULL,
    PRIMARY KEY (fieldmappingid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;]]></sql>
		</table>
		<table>
			<name>ct_facebooklead_formstatus</name>
			<sql><![CDATA[CREATE TABLE `ct_facebooklead_formstatus` (
  `formid` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `enable` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;]]></sql>
		</table>
	</tables>
</schema>