CREATE TABLE `tbl_site_visit` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `fullname` varchar(255) NOT NULL,
 `emailaddress` varchar(255) NOT NULL,
 `phone` varchar(25) NOT NULL,
 `city` varchar(5000) NOT NULL,
 `user_agent` varchar(500) NOT NULL,
 `message` text NOT NULL,
 `referral_page` text NOT NULL,
 `utm_medium` varchar(100) NOT NULL,
 `utm_source` varchar(255) NOT NULL,
 `utm_campaign` varchar(255) NOT NULL,
 `utm_term` varchar(255) NOT NULL,
 `utm_content` varchar(255) NOT NULL,
 `preferred_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 `ipaddress` varchar(50) NOT NULL,
 `page_referer` varchar(555) NOT NULL,
 `otp_value` varchar(10) NOT NULL,
 `otp_is_expired` int(1) NOT NULL,
 `datedon` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `isdeleted` int(1) NOT NULL,
 `ispushedinsalesforce` int(1) NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2969 DEFAULT CHARSET=latin1