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

START TRANSACTION;



--
-- Database: `childcare`
--

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

--
-- Table structure for table `center_classes`
--

CREATE TABLE `center_classes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `center_id` int(11) DEFAULT NULL,
  `class` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `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 `center_classes`
--

INSERT INTO `center_classes` (`id`, `center_id`, `class`, `created_at`, `updated_at`) VALUES
(2, 3, 'Second', '2020-11-30 04:43:16', '2020-11-30 04:43:16');

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

--
-- Table structure for table `childcare_center_abouts`
--

CREATE TABLE `childcare_center_abouts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `center_id` int(11) NOT NULL,
  `about` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `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 `childcare_center_abouts`
--

INSERT INTO `childcare_center_abouts` (`id`, `center_id`, `about`, `created_at`, `updated_at`) VALUES
(1, 2, '<div><b><h1>About Us</h1></b></div>', NULL, NULL),
(2, 3, '<div><b><h1>About Us</h1></b></div>', NULL, NULL);

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

--
-- Table structure for table `childcare_center_galleries`
--

CREATE TABLE `childcare_center_galleries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `center_id` int(11) DEFAULT NULL,
  `file` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `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 `childcare_center_galleries`
--

INSERT INTO `childcare_center_galleries` (`id`, `center_id`, `file`, `created_at`, `updated_at`) VALUES
(6, 3, '1/1606285708laugh-n-learn-dewinton-code-and-headphones-1.jpeg', '2020-11-25 00:58:28', '2020-11-25 00:58:28');

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

--
-- Table structure for table `childcare__centers`
--

CREATE TABLE `childcare__centers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `website` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `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 `childcare__centers`
--

INSERT INTO `childcare__centers` (`id`, `user_id`, `name`, `slug`, `phone`, `email`, `website`, `location`, `logo`, `created_at`, `updated_at`) VALUES
(2, 5, 'Baljot', 'baljot', '9878814206', 'baljotsingh50@gmail.com', 'test.com', 'ludhiana', '', '2020-11-12 00:48:58', '2020-11-12 05:01:14'),
(3, 11, 'LAUGH \"N\" LEARN DEWINTON', 'laugh-n-learn-dewinton', '9878814206', 'laughi@gmail.com', NULL, 'Edmonton, AB, Canada', '1/1605852720laugh-n-learn-dewinton-centre2.jpeg', '2020-11-20 00:42:00', '2020-11-20 00:42:00');

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

--
-- Table structure for table `childrens`
--

CREATE TABLE `childrens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `center_id` int(11) DEFAULT NULL,
  `parent_login` int(11) DEFAULT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `class` int(11) DEFAULT NULL,
  `section` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dob` datetime DEFAULT NULL,
  `address` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `img` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `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 `childrens`
--

INSERT INTO `childrens` (`id`, `center_id`, `parent_login`, `name`, `class`, `section`, `dob`, `address`, `img`, `created_at`, `updated_at`) VALUES
(1, 3, 15, 'child', 2, 'A', '2016-12-01 00:00:00', 'ludhiana', 'storage/uploads/parent/child-father/children_images/1606898265child-centre2.jpeg', '2020-12-02 03:07:45', '2020-12-03 00:50:16');

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

--
-- Table structure for table `children_parents`
--

CREATE TABLE `children_parents` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `children_id` int(11) DEFAULT NULL,
  `relation` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `occupation` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `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 `children_parents`
--

INSERT INTO `children_parents` (`id`, `children_id`, `relation`, `name`, `email`, `phone`, `occupation`, `created_at`, `updated_at`) VALUES
(2, 1, 'father', 'child father', 'childfather@gmail.com', '9874563211', NULL, '2020-12-03 01:27:49', '2020-12-03 01:56:17'),
(3, 1, 'mother', 'child Mother', 'childmother@gmail.com', '9874563210', NULL, '2020-12-03 01:27:49', '2020-12-03 01:56:23');

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) 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, '2019_08_19_000000_create_failed_jobs_table', 1),
(5, '2020_11_10_073409_create_roles', 2),
(6, '2020_11_10_074032_add_testfields', 3),
(7, '2020_11_10_090322_add-fields-users', 4),
(8, '2020_11_10_091527_create_childcare__centers_table', 5),
(9, '2020_11_12_104709_create_childcare_center_abouts_table', 6),
(10, '2020_11_16_074729_create_childcare_center_galleries_table', 7),
(11, '2020_11_25_101822_add_profileimg_in_users', 8),
(12, '2020_11_27_040745_create_childrens_table', 9),
(14, '2020_11_27_085545_create_center_clases_table', 10),
(16, '2020_12_01_060201_create_children_parent_table', 11),
(17, '2020_12_03_042436_add_user_fields_in_childrens', 12);

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `role` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `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 `roles`
--

INSERT INTO `roles` (`id`, `role`, `created_at`, `updated_at`) VALUES
(1, 'super-admin', NULL, NULL),
(2, 'childcare-home', NULL, NULL),
(3, 'childcare-center', NULL, NULL),
(4, 'staff', NULL, NULL),
(5, 'parent', NULL, NULL);

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `center_classes`
--
ALTER TABLE `center_classes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `childcare_center_abouts`
--
ALTER TABLE `childcare_center_abouts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `childcare_center_galleries`
--
ALTER TABLE `childcare_center_galleries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `childcare__centers`
--
ALTER TABLE `childcare__centers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `childrens`
--
ALTER TABLE `childrens`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `children_parents`
--
ALTER TABLE `children_parents`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

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

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
COMMIT;

