-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `kap`
--

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

--
-- Table structure for table `kap_activities`
--

CREATE TABLE `kap_activities` (
  `act_id` int(11) NOT NULL,
  `act_cat_id` int(11) NOT NULL,
  `act_age_group` int(11) NOT NULL,
  `act_topic_id` int(11) NOT NULL,
  `act_title` varchar(250) NOT NULL,
  `act_create_date` date NOT NULL,
  `act_status` tinyint(4) NOT NULL DEFAULT 2 COMMENT '1-Live, 2-Test, 3-Inactive',
  `act_short_descript` varchar(500) NOT NULL,
  `act_long_descript` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kap_activities`
--

INSERT INTO `kap_activities` (`act_id`, `act_cat_id`, `act_age_group`, `act_topic_id`, `act_title`, `act_create_date`, `act_status`, `act_short_descript`, `act_long_descript`) VALUES
(1, 11, 11, 0, 'aa1', '0000-00-00', 1, 'aa1', 'bb1'),
(2, 1, 1, 0, 'aaa', '2016-05-05', 2, 'vvvv', 'bbbb'),
(3, 1, 1, 0, 'aa', '2016-05-05', 1, 'dsd', 'dsds');

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

--
-- Table structure for table `kap_activity_categories`
--

CREATE TABLE `kap_activity_categories` (
  `act_cat_id` int(11) NOT NULL,
  `act_cat_name` varchar(100) NOT NULL,
  `act_question_action` varchar(100) DEFAULT NULL,
  `act_template` varchar(200) DEFAULT NULL,
  `act_cat_status` tinyint(4) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kap_activity_categories`
--

INSERT INTO `kap_activity_categories` (`act_cat_id`, `act_cat_name`, `act_question_action`, `act_template`, `act_cat_status`) VALUES
(2, 'Fill in the blanks', NULL, NULL, 1),
(3, 'Match the Columns', 'matchingxml', 'matching.html', 1),
(4, 'aaaa', NULL, NULL, 1),
(5, 'test', NULL, NULL, 1);

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

--
-- Table structure for table `kap_age_groups`
--

CREATE TABLE `kap_age_groups` (
  `age_group_id` int(11) NOT NULL,
  `age_group_name` varchar(50) NOT NULL,
  `age_group_status` tinyint(4) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kap_age_groups`
--

INSERT INTO `kap_age_groups` (`age_group_id`, `age_group_name`, `age_group_status`) VALUES
(1, 'Play Group', 1),
(2, 'ddd', 1);

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

--
-- Table structure for table `kap_contacts`
--

CREATE TABLE `kap_contacts` (
  `con_id` bigint(20) NOT NULL,
  `con_name` varchar(100) NOT NULL,
  `con_email` varchar(100) NOT NULL,
  `con_phone` varchar(30) NOT NULL,
  `con_country_id` int(11) NOT NULL,
  `con_is_member` tinyint(4) DEFAULT 0,
  `con_date_time` datetime NOT NULL,
  `con_message` text NOT NULL,
  `con_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0-unread, 1-read, 2-replied'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `kap_countries`
--

CREATE TABLE `kap_countries` (
  `country_id` int(11) NOT NULL,
  `country_name` varchar(100) NOT NULL,
  `country_flag` varchar(100) NOT NULL,
  `country_status` tinyint(4) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `kap_faq`
--

CREATE TABLE `kap_faq` (
  `faq_id` int(11) NOT NULL,
  `faq_title` varchar(1000) NOT NULL,
  `faq_details` text NOT NULL,
  `faq_adm_id` int(11) NOT NULL,
  `faq_date_time` datetime NOT NULL,
  `faq_status` tinyint(4) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kap_faq`
--

INSERT INTO `kap_faq` (`faq_id`, `faq_title`, `faq_details`, `faq_adm_id`, `faq_date_time`, `faq_status`) VALUES
(1, 'Who are you?', 'I am Angsuman Chatterjee. I live in New Delhi, India with my family.', 1, '2014-06-08 00:00:00', 1),
(3, 'Maria Sharapova beats Simona Halep to win second French Open title', '&lt;div style=&quot;text-align: justify;&quot;&gt;\r\n	PARIS: Maria Sharapova won her second French Open title in three years at Roland Garros on Saturday, defeating Romania&amp;#39;s Simona Halep 6-4, 6-7 (5/7), 6-4 in a gripping final, the first to go the full distance in Paris in 13 years and the second longest on record.&lt;/div&gt;\r\n&lt;div style=&quot;text-align: justify;&quot;&gt;\r\n	&amp;nbsp;&lt;/div&gt;\r\n&lt;div style=&quot;text-align: justify;&quot;&gt;\r\n	It was the 27-year-old Russian&amp;#39;s fifth Grand Slam title, bringing her level with Martina Hingis on the all-time list and it came 10 years after she won her first major at Wimbledon 2004.&lt;/div&gt;\r\n&lt;div style=&quot;text-align: justify;&quot;&gt;\r\n	&amp;nbsp;&lt;/div&gt;\r\n&lt;div style=&quot;text-align: justify;&quot;&gt;\r\n	Sharapova, who completed a career sweep of all four Grand Slam titles in Paris in 2012 before losing to Serena Williams last year, also moved to number two on the all-time prize money earnings, with only the American ahead of her.&lt;/div&gt;\r\n&lt;div style=&quot;text-align: justify;&quot;&gt;\r\n	&amp;nbsp;&lt;/div&gt;\r\n&lt;div style=&quot;text-align: justify;&quot;&gt;\r\n	But it took all her legendary grit and resolve to recover from the loss of the second set on a tie-break after she had stood just two points away from the title at 5/3.&lt;/div&gt;\r\n&lt;div style=&quot;text-align: justify;&quot;&gt;\r\n	&amp;nbsp;&lt;/div&gt;\r\n&lt;div style=&quot;text-align: justify;&quot;&gt;\r\n	&amp;quot;It&amp;#39;s the toughest Grand Slam final I have ever played,&amp;quot; said Sharapova.&lt;/div&gt;\r\n&lt;div style=&quot;text-align: justify;&quot;&gt;\r\n	&amp;nbsp;&lt;/div&gt;\r\n&lt;div style=&quot;text-align: justify;&quot;&gt;\r\n	&amp;quot;I can&amp;#39;t believe that at 27 I have won the French Open more times than any other Grand Slam.&amp;quot;&lt;/div&gt;\r\n&lt;div style=&quot;text-align: justify;&quot;&gt;\r\n	&amp;nbsp;&lt;/div&gt;\r\n&lt;div style=&quot;text-align: justify;&quot;&gt;\r\n	The consolation for Halep, whose meteoric rise to the top bracket in women&amp;#39;s tennis over the last 18 months has projected her as a potential champion, was that she will climb to a career-high third in the world rankings.&lt;/div&gt;\r\n&lt;div style=&quot;text-align: justify;&quot;&gt;\r\n	&amp;nbsp;&lt;/div&gt;\r\n&lt;div style=&quot;text-align: justify;&quot;&gt;\r\n	The two finalists reached the championship match in starkly contrasting styles.&lt;/div&gt;\r\n&lt;div style=&quot;text-align: justify;&quot;&gt;\r\n	&amp;nbsp;&lt;/div&gt;\r\n&lt;div style=&quot;text-align: justify;&quot;&gt;\r\n	Fourth-seeded Halep did not drop a single set in her six matches, while seventh-seed Sharapova needed to battle back from first set losses in her three previous outings.&lt;/div&gt;', 1, '2014-06-08 17:13:59', 1);

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

--
-- Table structure for table `kap_feedbacks`
--

CREATE TABLE `kap_feedbacks` (
  `fd_id` bigint(20) NOT NULL,
  `fd_name` varchar(100) NOT NULL,
  `fd_email` varchar(100) NOT NULL,
  `fd_country_id` int(11) NOT NULL,
  `fd_is_member` tinyint(4) NOT NULL DEFAULT 0,
  `fd_message` text NOT NULL,
  `fd_date_time` datetime NOT NULL,
  `fd_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0-Unread, 1-read, 2-replied'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `kap_matching`
--

CREATE TABLE `kap_matching` (
  `match_id` int(11) NOT NULL,
  `activity_id` int(11) NOT NULL,
  `match_title` varchar(50) NOT NULL,
  `match_desc` text NOT NULL,
  `match_status` tinyint(4) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kap_matching`
--

INSERT INTO `kap_matching` (`match_id`, `activity_id`, `match_title`, `match_desc`, `match_status`) VALUES
(1, 1, 'aaa', 'sssss', 1);

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

--
-- Table structure for table `kap_match_ques_detail`
--

CREATE TABLE `kap_match_ques_detail` (
  `match_ques_id` int(11) NOT NULL,
  `match_id` int(11) NOT NULL,
  `match_ques_term_text` varchar(225) NOT NULL,
  `match_ques_answer` varchar(50) NOT NULL,
  `match_ques_status` tinyint(4) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kap_match_ques_detail`
--

INSERT INTO `kap_match_ques_detail` (`match_ques_id`, `match_id`, `match_ques_term_text`, `match_ques_answer`, `match_ques_status`) VALUES
(1, 1, 'no, not, without, absence of', 'a-', 1),
(2, 1, 'before, forward', 'ante-', 1);

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

--
-- Table structure for table `kap_pages`
--

CREATE TABLE `kap_pages` (
  `pg_id` int(11) NOT NULL,
  `pg_title` varchar(200) NOT NULL,
  `pg_content` text NOT NULL,
  `pg_meta_title` varchar(300) NOT NULL,
  `pg_meta_keywords` varchar(500) NOT NULL,
  `pg_meta_description` varchar(750) NOT NULL,
  `pg_status` tinyint(4) NOT NULL DEFAULT 1,
  `pg_last_updated_by` int(11) NOT NULL,
  `pg_last_updated_on` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kap_pages`
--

INSERT INTO `kap_pages` (`pg_id`, `pg_title`, `pg_content`, `pg_meta_title`, `pg_meta_keywords`, `pg_meta_description`, `pg_status`, `pg_last_updated_by`, `pg_last_updated_on`) VALUES
(1, 'Test Page\'s title (updated)', 'This is an updated test page.&lt;br /&gt;\r\n&lt;br /&gt;', 'meta title2', 'key1, key2, key3, key4', 'this is angsuman\'s meta descriptions', 1, 1, '2014-06-15 21:32:34'),
(2, 'Second test with image', 'Image testing&lt;br /&gt;\r\n&lt;img alt=&quot;&quot; src=&quot;http://localhost/kap/js/ckfinder/userfiles/images/home.png&quot; style=&quot;width: 128px; height: 128px;&quot; /&gt;&lt;br /&gt;', 'image', '', '', 1, 1, '2014-06-15 20:58:34');

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

--
-- Table structure for table `kap_settings`
--

CREATE TABLE `kap_settings` (
  `set_id` int(11) NOT NULL,
  `set_caption` varchar(200) NOT NULL,
  `set_value` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kap_settings`
--

INSERT INTO `kap_settings` (`set_id`, `set_caption`, `set_value`) VALUES
(1, 'CONTACT_EMAIL', 'info@kidslearningpoint.com'),
(2, 'CONTACT_PHONE', '+91 931 307 9985');

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

--
-- Table structure for table `kap_topics`
--

CREATE TABLE `kap_topics` (
  `topic_id` int(11) NOT NULL,
  `topic_name` varchar(50) NOT NULL,
  `topic_status` tinyint(4) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kap_topics`
--

INSERT INTO `kap_topics` (`topic_id`, `topic_name`, `topic_status`) VALUES
(1, 'test1', 1),
(2, 'ddd', 1),
(3, '1', 1),
(4, '1', 1);

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

--
-- Table structure for table `kap_users`
--

CREATE TABLE `kap_users` (
  `user_id` int(11) NOT NULL,
  `user_fname` varchar(50) NOT NULL,
  `user_mname` varchar(50) NOT NULL,
  `user_lname` varchar(50) NOT NULL,
  `user_email` varchar(100) NOT NULL,
  `user_dob` date NOT NULL,
  `user_country_id` int(11) NOT NULL,
  `user_status` tinyint(4) NOT NULL DEFAULT 0,
  `user_last_login` datetime NOT NULL,
  `user_last_login_ip` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `kap_videos`
--

CREATE TABLE `kap_videos` (
  `video_id` int(11) NOT NULL,
  `age_group` int(11) NOT NULL,
  `video_title` varchar(50) NOT NULL,
  `video_thumbnail` varchar(50) NOT NULL,
  `video_embed_code` varchar(225) NOT NULL,
  `video_description` text NOT NULL,
  `video_status` tinyint(4) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kap_videos`
--

INSERT INTO `kap_videos` (`video_id`, `age_group`, `video_title`, `video_thumbnail`, `video_embed_code`, `video_description`, `video_status`) VALUES
(1, 1, 'Meena Episode', 'hqdefault.jpg', '<iframe width=\"420\" height=\"315\" src=\"https://www.youtube.com/embed/C_2DRqKAvFA\" frameborder=\"0\" allowfullscreen></iframe>', 'Meena Ki Teen Ichhaye is the 7th Episode of Meena (Unicef) Series.', 1),
(2, 1, 'qq', 'logo.png', 'qq', 'qq', 1);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `kap_activities`
--
ALTER TABLE `kap_activities`
  ADD PRIMARY KEY (`act_id`),
  ADD KEY `act_cat_id` (`act_cat_id`,`act_age_group`);

--
-- Indexes for table `kap_activity_categories`
--
ALTER TABLE `kap_activity_categories`
  ADD PRIMARY KEY (`act_cat_id`);

--
-- Indexes for table `kap_age_groups`
--
ALTER TABLE `kap_age_groups`
  ADD PRIMARY KEY (`age_group_id`);

--
-- Indexes for table `kap_contacts`
--
ALTER TABLE `kap_contacts`
  ADD PRIMARY KEY (`con_id`);

--
-- Indexes for table `kap_countries`
--
ALTER TABLE `kap_countries`
  ADD PRIMARY KEY (`country_id`);

--
-- Indexes for table `kap_faq`
--
ALTER TABLE `kap_faq`
  ADD PRIMARY KEY (`faq_id`);

--
-- Indexes for table `kap_feedbacks`
--
ALTER TABLE `kap_feedbacks`
  ADD PRIMARY KEY (`fd_id`);

--
-- Indexes for table `kap_matching`
--
ALTER TABLE `kap_matching`
  ADD PRIMARY KEY (`match_id`);

--
-- Indexes for table `kap_match_ques_detail`
--
ALTER TABLE `kap_match_ques_detail`
  ADD PRIMARY KEY (`match_ques_id`);

--
-- Indexes for table `kap_pages`
--
ALTER TABLE `kap_pages`
  ADD PRIMARY KEY (`pg_id`);

--
-- Indexes for table `kap_settings`
--
ALTER TABLE `kap_settings`
  ADD PRIMARY KEY (`set_id`);

--
-- Indexes for table `kap_topics`
--
ALTER TABLE `kap_topics`
  ADD PRIMARY KEY (`topic_id`);

--
-- Indexes for table `kap_users`
--
ALTER TABLE `kap_users`
  ADD PRIMARY KEY (`user_id`),
  ADD UNIQUE KEY `user_email` (`user_email`);

--
-- Indexes for table `kap_videos`
--
ALTER TABLE `kap_videos`
  ADD PRIMARY KEY (`video_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `kap_activities`
--
ALTER TABLE `kap_activities`
  MODIFY `act_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `kap_activity_categories`
--
ALTER TABLE `kap_activity_categories`
  MODIFY `act_cat_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `kap_age_groups`
--
ALTER TABLE `kap_age_groups`
  MODIFY `age_group_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `kap_contacts`
--
ALTER TABLE `kap_contacts`
  MODIFY `con_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `kap_countries`
--
ALTER TABLE `kap_countries`
  MODIFY `country_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `kap_faq`
--
ALTER TABLE `kap_faq`
  MODIFY `faq_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `kap_feedbacks`
--
ALTER TABLE `kap_feedbacks`
  MODIFY `fd_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `kap_matching`
--
ALTER TABLE `kap_matching`
  MODIFY `match_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `kap_match_ques_detail`
--
ALTER TABLE `kap_match_ques_detail`
  MODIFY `match_ques_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `kap_pages`
--
ALTER TABLE `kap_pages`
  MODIFY `pg_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `kap_settings`
--
ALTER TABLE `kap_settings`
  MODIFY `set_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `kap_topics`
--
ALTER TABLE `kap_topics`
  MODIFY `topic_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `kap_users`
--
ALTER TABLE `kap_users`
  MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `kap_videos`
--
ALTER TABLE `kap_videos`
  MODIFY `video_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;

