CREATE TABLE IF NOT EXISTS `kfh_1_data` (
  `dfield` varchar(50) DEFAULT NULL,
  `dcaption` varchar(500) DEFAULT NULL,
  `doptions` varchar(500) DEFAULT NULL,
  `ddata` varchar(20) DEFAULT NULL,
  `dat_function` varchar(50) NOT NULL,
  `scores` tinyint(2) unsigned DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `kfh_agents`
--

CREATE TABLE IF NOT EXISTS `kfh_agents` (
  `id` int(11) NOT NULL,
  `agent_name_ar` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `agent_name_en` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kfh_agents`
--

INSERT INTO `kfh_agents` (`id`, `agent_name_ar`, `agent_name_en`) VALUES
(1, '', 'Agent');

-- --------------------------------------------------------

--
-- Table structure for table `kfh_bank`
--

CREATE TABLE IF NOT EXISTS `kfh_bank` (
  `bank_code` int(11) NOT NULL DEFAULT '0',
  `bank_desc` char(80) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `kfh_branches`
--

CREATE TABLE IF NOT EXISTS `kfh_branches` (
  `id` int(11) NOT NULL,
  `br_name_ar` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `br_name_en` varchar(100) DEFAULT NULL,
  `br_section` varchar(10) DEFAULT NULL,
  `br_area` varchar(30) DEFAULT NULL,
  `total_visit` int(11) DEFAULT NULL,
  `cso` int(11) DEFAULT NULL,
  `teller` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kfh_branches`
--

INSERT INTO `kfh_branches` (`id`, `br_name_ar`, `br_name_en`, `br_section`, `br_area`, `total_visit`, `cso`, `teller`) VALUES
(1, 'الجهراء', '', 'Men ', 'Area one', 5, 3, 2),
(2, 'العارضية', '', 'Men ', 'Area one', 5, 3, 2),
(3, 'القصر', '', 'Men ', 'Area one', 5, 3, 2),
(4, 'الرحاب', '', 'Men ', 'Area one', 4, 2, 2),
(5, 'الصليبيخات', '', 'Men ', 'Area one', 4, 2, 2),
(6, 'صباح الناصر', '', 'Men ', 'Area one', 5, 3, 2),
(7, 'الأندلس', '', 'Men ', 'Area one', 4, 2, 2),
(8, 'عبدالله المبارك', '', 'Men ', 'Area one', 4, 2, 2),
(9, 'المركز التجاري الجهراء', '', 'Men ', 'Area one', 5, 3, 2),
(10, 'جليب الشيوخ', '', 'Men ', 'Area one', 4, 2, 2),
(11, 'غرناطة', '', 'Men ', 'Area one', 4, 2, 2),
(12, 'مركز علياء', '', 'Men ', 'Area one', 4, 2, 2),
(13, 'الجهراء', '', 'Women ', 'Area one', 5, 3, 2),
(14, 'العارضية', '', 'Women ', 'Area one', 5, 3, 2),
(15, 'القصر', '', 'Women ', 'Area one', 5, 3, 2),
(16, 'الرحاب', '', 'Women ', 'Area one', 5, 3, 2),
(17, 'الصليبيخات', '', 'Women ', 'Area one', 5, 3, 2),
(18, 'صباح الناصر', '', 'Women ', 'Area one', 4, 2, 2),
(19, 'الأندلس', '', 'Women ', 'Area one', 5, 3, 2),
(20, 'عبدالله المبارك', '', 'Women ', 'Area one', 5, 3, 2),
(21, 'المركز التجاري الجهراء', '', 'Women ', 'Area one', 4, 2, 2),
(22, 'غرناطة', '', 'Women ', 'Area one', 4, 2, 2),
(23, 'مركز علياء', '', 'Women ', 'Area one', 4, 2, 2),
(24, 'الÙروانية', '', 'Men ', 'Area Two', 5, 3, 2),
(25, 'صبحان', '', 'Men ', 'Area Two', 6, 3, 3),
(26, 'خيطان', '', 'Men ', 'Area Two', 5, 3, 2),
(27, 'الخالدية', '', 'Men ', 'Area Two', 5, 3, 2),
(28, 'الشويخ', '', 'Men ', 'Area Two', 6, 3, 3),
(29, 'قرطبة', '', 'Men ', 'Area Two', 4, 2, 2),
(30, 'الضجيج', '', 'Men ', 'Area Two', 4, 2, 2),
(31, 'كيÙان', '', 'Men ', 'Area Two', 5, 3, 2),
(32, 'اليرموك', '', 'Men ', 'Area Two', 4, 2, 2),
(33, 'الأÙينيوز', '', 'Men ', 'Area Two', 3, 2, 1),
(34, 'المطار', '', 'Men ', 'Area Two', 6, 3, 3),
(35, 'الÙروانية 2', '', 'Men ', 'Area Two', 5, 3, 2),
(36, 'مركز تمويل الشويخ تجارى ', '', 'Men ', 'Area Two', 4, 2, 2),
(37, 'مركز تمويل الضجيج ', '', 'Men ', 'Area Two', 4, 2, 2),
(38, 'مركز تمويل الرى الدائرى الرابع ', '', 'Men ', 'Area Two', 4, 2, 2),
(39, 'الÙروانية', '', 'Women ', 'Area Two', 4, 2, 2),
(40, 'خيطان', '', 'Women ', 'Area Two', 4, 2, 2),
(41, 'الخالدية', '', 'Women ', 'Area Two', 5, 3, 2),
(42, 'قرطبة', '', 'Women ', 'Area Two', 4, 2, 2),
(43, 'الضجيج', '', 'Women ', 'Area Two', 4, 2, 2),
(44, 'كيÙان', '', 'Women ', 'Area Two', 4, 2, 2),
(45, 'مركز تمويل الشويخ تجارى ', '', 'Women ', 'Area Two', 4, 2, 2),
(46, 'مركز تمويل الضجيج ', '', 'Women ', 'Area Two', 4, 2, 2),
(47, 'Ùهد الاحمد', '', 'Men ', 'Area Three', 4, 2, 2),
(48, 'الÙحيحيل', '', 'Men ', 'Area Three', 6, 3, 3),
(49, 'صباح السالم', '', 'Men ', 'Area Three', 5, 3, 2),
(50, 'الÙنطاس', '', 'Men ', 'Area Three', 4, 2, 2),
(51, 'مبارك الكبير', '', 'Men ', 'Area Three', 5, 3, 2),
(52, 'الأحمدي', '', 'Men ', 'Area Three', 4, 2, 2),
(53, 'المنشر', '', 'Men ', 'Area Three', 4, 2, 2),
(54, 'الصباحية', '', 'Men ', 'Area Three', 5, 3, 2),
(55, 'ابو حليÙة', '', 'Men ', 'Area Three', 4, 2, 2),
(56, 'الظهر', '', 'Men ', 'Area Three', 4, 2, 2),
(57, 'المهبولة', '', 'Men ', 'Area Three', 4, 2, 2),
(58, 'مركز تمويل الأحمدى ', '', 'Men ', 'Area Three', 4, 2, 2),
(59, 'Ùهد الاحمد', '', 'Women ', 'Area Three', 6, 3, 3),
(60, 'الÙحيحيل', '', 'Women ', 'Area Three', 5, 3, 2),
(61, 'صباح السالم', '', 'Women ', 'Area Three', 6, 3, 3),
(62, 'الÙنطاس', '', 'Women ', 'Area Three', 4, 2, 2),
(63, 'مبارك الكبير', '', 'Women ', 'Area Three', 5, 3, 2),
(64, 'الأحمدي', '', 'Women ', 'Area Three', 4, 2, 2),
(65, 'الصباحية', '', 'Women ', 'Area Three', 5, 3, 2),
(66, 'ابو حليÙة', '', 'Women ', 'Area Three', 4, 2, 2),
(67, 'الظهر', '', 'Women ', 'Area Three', 4, 2, 2),
(68, 'المهبولة', '', 'Women ', 'Area Three', 4, 2, 2),
(69, 'مركز تمويل الأحمدى ', '', 'Women ', 'Area Three', 4, 2, 2),
(70, 'المركز الرئيسي', '', 'Men ', 'Area Four', 6, 3, 3),
(71, 'شرق', '', 'Men ', 'Area Four', 5, 3, 2),
(72, 'الÙيحاء', '', 'Men ', 'Area Four', 6, 3, 3),
(73, 'مجمع الوزارات', '', 'Men ', 'Area Four', 4, 2, 2),
(74, 'المثنى', '', 'Men ', 'Area Four', 4, 2, 2),
(75, 'الشامية', '', 'Men ', 'Area Four', 4, 2, 2),
(76, 'العديلية', '', 'Men ', 'Area Four', 4, 2, 2),
(77, 'عبدالله السالم', '', 'Men ', 'Area Four', 4, 2, 2),
(78, 'برج التحرير', '', 'Men ', 'Area Four', 3, 2, 1),
(79, 'السور', '', 'Men ', 'Area Four', 4, 2, 2),
(80, 'برج بيتك', '', 'Men ', 'Area Four', 2, 1, 1),
(81, 'شارع عبدالله الاحمد', '', 'Men ', 'Area Four', 4, 2, 2),
(82, 'برج المتحدة', '', 'Men ', 'Area Four', 4, 2, 2),
(83, 'القبلة', '', 'Men ', 'Area Four', 5, 3, 2),
(84, 'المركز الرئيسي', '', 'Women ', 'Area Four', 4, 2, 2),
(85, 'الÙيحاء', '', 'Women ', 'Area Four', 6, 3, 3),
(86, 'مجمع الوزارات', '', 'Women ', 'Area Four', 4, 2, 2),
(87, 'الشامية', '', 'Women ', 'Area Four', 4, 2, 2),
(88, 'العديلية', '', 'Women ', 'Area Four', 4, 2, 2),
(89, 'عبدالله السالم', '', 'Women ', 'Area Four', 4, 2, 2),
(90, 'برج بيتك', '', 'Women ', 'Area Four', 2, 1, 1),
(91, 'شارع عبدالله الاحمد', '', 'Women ', 'Area Four', 4, 2, 2),
(92, 'السالمية', '', 'Men ', 'Area Five', 4, 2, 2),
(93, 'حولي', '', 'Men ', 'Area Five', 6, 3, 3),
(94, 'الشعب', '', 'Men ', 'Area Five', 4, 2, 2),
(95, 'بيان', '', 'Men ', 'Area Five', 4, 2, 2),
(96, 'الروضة', '', 'Men ', 'Area Five', 4, 2, 2),
(97, 'القادسية', '', 'Men ', 'Area Five', 4, 2, 2),
(98, 'حطين', '', 'Men ', 'Area Five', 5, 3, 2),
(99, 'سلوى', '', 'Men ', 'Area Five', 5, 3, 2),
(100, 'مبارك العبدالله', '', 'Men ', 'Area Five', 4, 2, 2),
(101, 'شارع ابن خلدون', '', 'Men ', 'Area Five', 4, 2, 2),
(102, 'شارع سالم المبارك', '', 'Men ', 'Area Five', 4, 2, 2),
(103, 'مجمع البحر', '', 'Men ', 'Area Five', 4, 2, 2),
(104, 'مجمع الوطنية', '', 'Men ', 'Area Five', 5, 3, 2),
(105, 'الزهراء', '', 'Men ', 'Area Five', 4, 2, 2),
(106, 'السالمية', '', 'Women ', 'Area Five', 4, 2, 2),
(107, 'حولي', '', 'Women ', 'Area Five', 5, 3, 2),
(108, 'الشعب', '', 'Women ', 'Area Five', 4, 2, 2),
(109, 'بيان', '', 'Women ', 'Area Five', 4, 2, 2),
(110, 'الروضة', '', 'Women ', 'Area Five', 4, 2, 2),
(111, 'القادسية', '', 'Women ', 'Area Five', 4, 2, 2),
(112, 'حطين', '', 'Women ', 'Area Five', 5, 3, 2),
(113, 'سلوى', '', 'Women ', 'Area Five', 4, 2, 2),
(114, 'مبارك العبدالله', '', 'Women ', 'Area Five', 4, 2, 2),
(115, 'الزهراء', '', 'Women ', 'Area Five', 4, 2, 2);

-- --------------------------------------------------------

--
-- Table structure for table `kfh_detail_1`
--

CREATE TABLE IF NOT EXISTS `kfh_detail_1` (
  `id` int(11) NOT NULL,
  `client_open` tinyint(1) DEFAULT NULL,
  `interviewer_no` varchar(10) COLLATE utf8_bin DEFAULT NULL,
  `approved` tinyint(1) DEFAULT NULL,
  `approved_date` datetime DEFAULT NULL,
  `date_Insert` datetime DEFAULT NULL,
  `user_id` int(10) unsigned DEFAULT NULL,
  `serial_no` varchar(10) COLLATE utf8_bin DEFAULT NULL,
  `day` int(2) DEFAULT NULL,
  `month` int(2) DEFAULT NULL,
  `year` int(4) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `wday` tinyint(1) DEFAULT NULL,
  `quarter` int(11) DEFAULT NULL,
  `tofv_hr` int(2) DEFAULT NULL,
  `tofv_min` int(2) DEFAULT NULL,
  `tofv` datetime DEFAULT NULL,
  `branch_id` int(11) DEFAULT NULL,
  `agent_id` int(11) DEFAULT NULL,
  `shopper_id` int(11) DEFAULT NULL,
  `transation_id` int(11) DEFAULT NULL,
  `service_location` int(11) DEFAULT NULL,
  `no_waiting_cus` int(11) DEFAULT NULL,
  `no_recp_agnts` int(11) DEFAULT NULL,
  `rec_starttime_hr` int(2) DEFAULT NULL,
  `rec_starttime_min` int(2) DEFAULT NULL,
  `rec_start_time` datetime DEFAULT NULL,
  `rec_endtime_hr` int(2) DEFAULT NULL,
  `rec_endtime_min` int(2) DEFAULT NULL,
  `rec_end_time` datetime DEFAULT NULL,
  `rec_vduration_min` int(4) DEFAULT NULL,
  `bvar_1` tinyint(1) DEFAULT NULL,
  `bvar_2` tinyint(1) DEFAULT NULL,
  `bvar_3` tinyint(1) DEFAULT NULL,
  `bvar_4` tinyint(1) DEFAULT NULL,
  `bvar_5` tinyint(1) DEFAULT NULL,
  `bvar_6` tinyint(1) DEFAULT NULL,
  `bvar_7` tinyint(1) DEFAULT NULL,
  `bvar_8` tinyint(1) DEFAULT NULL,
  `bvar_9` tinyint(1) DEFAULT NULL,
  `bvar_10` tinyint(1) DEFAULT NULL,
  `bvar_11` tinyint(1) DEFAULT NULL,
  `bvar_12` tinyint(1) DEFAULT NULL,
  `bvar_13` tinyint(1) DEFAULT NULL,
  `bvar_14` tinyint(1) DEFAULT NULL,
  `bvar_15` tinyint(1) DEFAULT NULL,
  `bvar_16` tinyint(1) DEFAULT NULL,
  `bvar_17` tinyint(1) DEFAULT NULL,
  `bvar_18` tinyint(1) DEFAULT NULL,
  `bvar_19` tinyint(1) DEFAULT NULL,
  `bvar_20` tinyint(1) DEFAULT NULL,
  `bvar_21` tinyint(1) DEFAULT NULL,
  `bvar_22` tinyint(1) DEFAULT NULL,
  `bvar_23` tinyint(1) DEFAULT NULL,
  `bvar_com_1` text COLLATE utf8_bin,
  `bvar_com_2` text COLLATE utf8_bin,
  `bvar_com_3` text COLLATE utf8_bin,
  `bvar_com_4` text COLLATE utf8_bin,
  `bvar_com_5` text COLLATE utf8_bin,
  `bvar_com_6` text COLLATE utf8_bin,
  `bvar_com_7` text COLLATE utf8_bin,
  `bvar_com_8` text COLLATE utf8_bin,
  `bvar_com_9` text COLLATE utf8_bin,
  `bvar_com_10` text COLLATE utf8_bin,
  `bvar_com_11` text COLLATE utf8_bin,
  `bvar_com_12` text COLLATE utf8_bin,
  `bvar_com_13` text COLLATE utf8_bin,
  `bvar_com_14` text COLLATE utf8_bin,
  `bvar_com_15` text COLLATE utf8_bin,
  `bvar_com_16` text COLLATE utf8_bin,
  `bvar_com_17` text COLLATE utf8_bin,
  `bvar_com_18` text COLLATE utf8_bin,
  `bvar_com_19` text COLLATE utf8_bin,
  `bvar_com_20` text COLLATE utf8_bin,
  `bvar_com_21` text COLLATE utf8_bin,
  `bvar_com_22` text COLLATE utf8_bin,
  `bvar_com_23` text COLLATE utf8_bin,
  `score_a_point` int(11) DEFAULT NULL,
  `score_a_allot` int(11) DEFAULT NULL,
  `score_b_point` int(11) DEFAULT NULL,
  `score_b_allot` int(11) DEFAULT NULL,
  `score_c_point` int(11) DEFAULT NULL,
  `score_c_allot` int(11) DEFAULT NULL,
  `score_d_point` int(11) DEFAULT NULL,
  `score_d_allot` int(11) DEFAULT NULL,
  `total_point` int(11) DEFAULT NULL,
  `total_allot` int(11) DEFAULT NULL,
  `comment1` text COLLATE utf8_bin
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- --------------------------------------------------------

--
-- Table structure for table `kfh_failed_sql`
--

CREATE TABLE IF NOT EXISTS `kfh_failed_sql` (
  `id` int(11) NOT NULL,
  `msql` text
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;


-- --------------------------------------------------------

--
-- Table structure for table `kfh_location`
--

CREATE TABLE IF NOT EXISTS `kfh_location` (
  `id` int(11) NOT NULL,
  `loc_name_ar` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `loc_name_en` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kfh_location`
--

INSERT INTO `kfh_location` (`id`, `loc_name_ar`, `loc_name_en`) VALUES
(1, '', 'Teller'),
(2, NULL, 'Office'),
(3, NULL, 'Reception');

-- --------------------------------------------------------

--
-- Table structure for table `kfh_qtr`
--

CREATE TABLE IF NOT EXISTS `kfh_qtr` (
  `id` int(11) NOT NULL,
  `qrt_desc` varchar(30) DEFAULT NULL,
  `sdate` date DEFAULT NULL,
  `edate` date DEFAULT NULL,
  `active` tinyint(3) unsigned DEFAULT '0'
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kfh_qtr`
--

INSERT INTO `kfh_qtr` (`id`, `qrt_desc`, `sdate`, `edate`, `active`) VALUES
(1, 'Quarter 1', '2016-06-01', '2016-12-31', 1);

-- --------------------------------------------------------

--
-- Table structure for table `kfh_shopper`
--

CREATE TABLE IF NOT EXISTS `kfh_shopper` (
  `shopper_id` int(11) NOT NULL,
  `id` int(10) unsigned NOT NULL,
  `shopper_name` varchar(255) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kfh_shopper`
--

INSERT INTO `kfh_shopper` (`shopper_id`, `id`, `shopper_name`) VALUES
(1, 1, 'Parc Kuwait');

-- --------------------------------------------------------

--
-- Table structure for table `kfh_trans`
--

CREATE TABLE IF NOT EXISTS `kfh_trans` (
  `id` int(11) NOT NULL,
  `trans_name_ar` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `trans_name_en` varchar(100) DEFAULT NULL,
  `job_title` varchar(100) DEFAULT NULL,
  `location` varchar(100) DEFAULT NULL
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kfh_trans`
--

INSERT INTO `kfh_trans` (`id`, `trans_name_ar`, `trans_name_en`, `job_title`, `location`) VALUES
(1, '-Ùتح حساب راتب', NULL, 'CSO – Customer Service ', 'Branches '),
(2, '-Ùتح حساب توÙير', NULL, 'CSO – Customer Service ', 'Branches '),
(3, '-Ùتح حساب اطÙال', NULL, 'CSO – Customer Service ', 'Branches '),
(4, '-ودائع', NULL, 'CSO – Customer Service ', 'Branches '),
(5, '-بطاقات ائتمانية', NULL, 'CSO – Customer Service ', 'Branches '),
(6, '-بطاقات مسبقة الدÙع', NULL, 'CSO – Customer Service ', 'Branches '),
(7, '-مرابحة اثاث منزلي', NULL, 'CSO – Customer Service ', 'Branches '),
(8, '-مرابحة اجهزة كهربائية', NULL, 'CSO – Customer Service ', 'Branches '),
(9, '-تورق', NULL, 'CSO – Customer Service ', 'Branches '),
(10, '-ايداع أو سحب نقدي', NULL, 'Tellers ', 'Branches '),
(11, '-ايداع أو سحب شيك', NULL, 'Tellers ', 'Branches '),
(12, '-تحويل مالي ', NULL, 'Tellers ', 'Branches '),
(13, '-مرابحة اثاث منزلي', NULL, 'CSO – Customer Service ', 'Financing Centers '),
(14, '-مرابحة اجهزة كهربائية', NULL, 'CSO – Customer Service ', 'Financing Centers '),
(15, '-تورق', NULL, 'CSO – Customer Service ', 'Financing Centers '),
(16, '- مرابحة سيارة جديدة مختارة من داخل الوكالة ', NULL, 'CSO – Customer Service ', 'Cars Dealers ');

-- --------------------------------------------------------

--
-- Table structure for table `kfh_visit_plan_master`
--

CREATE TABLE IF NOT EXISTS `kfh_visit_plan_master` (
  `row_id` int(10) NOT NULL,
  `shopper_id` int(11) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `quarter_id` int(11) NOT NULL,
  `status` int(1) DEFAULT '0',
  `stype` int(10) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `kfh_zone`
--

CREATE TABLE IF NOT EXISTS `kfh_zone` (
  `id` int(11) DEFAULT NULL,
  `zone` varchar(50) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `kfh_agents`
--
ALTER TABLE `kfh_agents`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `kfh_bank`
--
ALTER TABLE `kfh_bank`
  ADD PRIMARY KEY (`bank_code`);

--
-- Indexes for table `kfh_detail_1`
--
ALTER TABLE `kfh_detail_1`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uniq` (`shopper_id`,`quarter`,`serial_no`);

--
-- Indexes for table `kfh_failed_sql`
--
ALTER TABLE `kfh_failed_sql`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `kfh_location`
--
ALTER TABLE `kfh_location`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `kfh_qtr`
--
ALTER TABLE `kfh_qtr`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `kfh_shopper`
--
ALTER TABLE `kfh_shopper`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique` (`shopper_id`);

--
-- Indexes for table `kfh_trans`
--
ALTER TABLE `kfh_trans`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `kfh_visit_plan_master`
--
ALTER TABLE `kfh_visit_plan_master`
  ADD PRIMARY KEY (`row_id`),
  ADD UNIQUE KEY `shopper_id` (`quarter_id`,`shopper_id`,`stype`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `kfh_detail_1`
--
ALTER TABLE `kfh_detail_1`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `kfh_failed_sql`
--
ALTER TABLE `kfh_failed_sql`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `kfh_qtr`
--
ALTER TABLE `kfh_qtr`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `kfh_shopper`
--
ALTER TABLE `kfh_shopper`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=74;
--
-- AUTO_INCREMENT for table `kfh_trans`
--
ALTER TABLE `kfh_trans`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT for table `kfh_visit_plan_master`
--
ALTER TABLE `kfh_visit_plan_master`
  MODIFY `row_id` int(10) NOT NULL AUTO_INCREMENT;
