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

START TRANSACTION;



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

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `cat_id` bigint(155) NOT NULL,
  `type` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `catname` varchar(255) NOT NULL,
  `parent` int(11) NOT NULL DEFAULT 0,
  `content` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`cat_id`, `type`, `image`, `url`, `catname`, `parent`, `content`) VALUES
(15, '', '', 'india', 'India', 0, ''),
(16, '', '', 'international', 'International', 0, '');

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

--
-- Table structure for table `moreimages`
--

CREATE TABLE `moreimages` (
  `id` bigint(155) NOT NULL,
  `title` varchar(300) NOT NULL,
  `image` varchar(300) NOT NULL,
  `parent_id` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `themecolor` varchar(255) NOT NULL DEFAULT '2a71e9',
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_keywords` longtext DEFAULT NULL,
  `meta_description` longtext DEFAULT NULL,
  `contactus` longtext DEFAULT NULL,
  `welcom_txt` longtext DEFAULT NULL,
  `why` longtext DEFAULT NULL,
  `mission` longtext DEFAULT NULL,
  `ourvalue` longtext DEFAULT NULL,
  `latest_project` longtext DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `slider`
--

CREATE TABLE `slider` (
  `id` bigint(155) NOT NULL,
  `type` int(2) DEFAULT NULL,
  `image` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `detail` varchar(255) NOT NULL,
  `targetlink` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `slider`
--

INSERT INTO `slider` (`id`, `type`, `image`, `title`, `detail`, `targetlink`) VALUES
(10, NULL, '1672144381kerala3.jpg', 'You will find innumerable holiday packages, but very few that match your requirement', '', ''),
(15, 1, '1677078896Banner_1.1.jpg', 'It\'s Time to Travel', '', ''),
(16, 1, '16770672541672149290pa4.jpg', 'Adventure awaits for you', '', ''),
(20, 1, '1677078630Banner_3.jpg', 'Travel to the Hill stations', '', ''),
(24, 1, '1677078454Banner_2.jpg', 'Honeymoon Tip for you', '', ''),
(28, 2, '1677237850IRCTC_Logo.jpg', '', '', '');

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

--
-- Table structure for table `tbl_gallery`
--

CREATE TABLE `tbl_gallery` (
  `id` bigint(20) NOT NULL,
  `imgurl` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `youtube`
--

CREATE TABLE `youtube` (
  `id` bigint(133) NOT NULL,
  `homepage` int(5) NOT NULL DEFAULT 0,
  `youtubecode` varchar(233) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `youtube`
--

INSERT INTO `youtube` (`id`, `homepage`, `youtubecode`) VALUES
(4, 0, 'iKPwDhMk2BI');

--
-- Indexes for table `category`
--
ALTER TABLE `category`
  ADD PRIMARY KEY (`cat_id`);

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

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

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

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

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

--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
  MODIFY `cat_id` bigint(155) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `moreimages`
--
ALTER TABLE `moreimages`
  MODIFY `id` bigint(155) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `slider`
--
ALTER TABLE `slider`
  MODIFY `id` bigint(155) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `tbl_gallery`
--
ALTER TABLE `tbl_gallery`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `youtube`
--
ALTER TABLE `youtube`
  MODIFY `id` bigint(133) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
COMMIT;

