-- http://www.phpmyadmin.net
--




--
-- Database: `supertravel`
--

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

--
-- Table structure for table `country`
--

CREATE TABLE `country` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `publish` int(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `country`
--

INSERT INTO `country` (`id`, `name`, `publish`, `created_at`, `updated_at`) VALUES
(1, 'Bangladesh', 1, '2017-07-02 18:00:00', '2017-07-02 18:00:00'),
(2, 'India', 1, '2017-07-02 18:00:00', '2017-07-02 18:00:00'),
(4, 'Bhutan', 1, '2017-07-04 11:06:07', '2017-07-04 11:06:07');

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2017_07_03_121527_create_supertravel_table', 1),
(4, '2017_07_03_130521_create_country_table', 2),
(5, '2017_07_03_131603_add_countryid_to_supertravel_table', 3);

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

--
-- Table structure for table `supertravel`
--

CREATE TABLE `supertravel` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `detail` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `main_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `owner_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `country_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `supertravel`
--

INSERT INTO `supertravel` (`id`, `title`, `detail`, `main_image`, `location`, `owner_id`, `created_at`, `updated_at`, `country_id`) VALUES
(2, 'shylhet', 'demo2', 'Srimangal-Slide-1.jpg', 'srimongal', 1, '2017-07-04 00:34:46', '2017-07-04 06:38:54', 2),
(3, 'Cox Bazar', 'demo', '2.jpg', 'Saint Martin', 1, '2017-07-04 00:58:06', '2017-07-04 05:08:34', 1);

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `supertravel`
--
ALTER TABLE `supertravel`
  ADD PRIMARY KEY (`id`),
  ADD KEY `supertravel_country_id_foreign` (`country_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `country`
--
ALTER TABLE `country`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `supertravel`
--
ALTER TABLE `supertravel`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- Constraints for dumped tables
--

--
-- Constraints for table `supertravel`
--
ALTER TABLE `supertravel`
  ADD CONSTRAINT `supertravel_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `country` (`id`);

