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

START TRANSACTION;



--
-- Database: `hucpl`
--

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

--
-- Table structure for table `about_uses`
--

CREATE TABLE `about_uses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `big_title` varchar(255) DEFAULT NULL,
  `small_tilte` varchar(255) DEFAULT NULL,
  `big_text` varchar(255) DEFAULT NULL,
  `small_text` varchar(255) DEFAULT NULL,
  `big_text2` varchar(255) DEFAULT NULL,
  `small_text2` varchar(255) DEFAULT NULL,
  `big_heading` varchar(255) DEFAULT NULL,
  `small_heading1` varchar(255) DEFAULT NULL,
  `small_heading2` varchar(255) DEFAULT NULL,
  `small_heading3` varchar(255) DEFAULT NULL,
  `big_heading2` varchar(255) DEFAULT NULL,
  `paragraph` varchar(255) DEFAULT NULL,
  `image1` varchar(255) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description2` text DEFAULT NULL,
  `text_box` varchar(255) NOT NULL,
  `big_heading3` varchar(255) DEFAULT NULL,
  `paragraph2` varchar(255) DEFAULT NULL,
  `image2` varchar(255) NOT NULL,
  `name2` varchar(255) DEFAULT NULL,
  `description3` text DEFAULT NULL,
  `text_box1` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `bloggs`
--

CREATE TABLE `bloggs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `namee` varchar(255) DEFAULT NULL,
  `linkk` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `dlink` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `btn1` varchar(255) DEFAULT NULL,
  `blink` varchar(255) 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 `bloggs`
--

INSERT INTO `bloggs` (`id`, `image`, `name`, `link`, `namee`, `linkk`, `date`, `dlink`, `description`, `btn1`, `blink`, `created_at`, `updated_at`) VALUES
(8, '1712578658.jpeg', 'Bloglll', NULL, 'Teste', 'This is test', '2024-04-09', 'rfre', 'Testing...........', 'Read More..', 'btn', '2024-04-08 05:22:00', '2024-04-08 06:47:38'),
(11, '1712580806.jpeg', 'dsc', NULL, 'tgf', 'This is test', '2024-04-08', 'rfr', 'frefer', 'vvvvvvvvvvvvvvvvv', 'btn', '2024-04-08 07:23:26', '2024-04-08 07:23:26'),
(12, '1712580843.jpeg', 'Values', NULL, 'tgf', 'cd', NULL, 'rfre', 'erer', 'Read More..', 'vvvvvvvvvvvvvvv', '2024-04-08 07:24:03', '2024-04-08 07:24:03'),
(13, '1712580866.jpeg', 'dsc', NULL, 'test', 'This is test', '2024-04-06', 'rfre', 'egge', 'er', 'btn', '2024-04-08 07:24:26', '2024-04-08 07:24:26'),
(14, '1712580888.jpeg', 'dsc', NULL, 'test', 'This is test', '2024-04-03', 'rfre', 'x', 'Read More..', 'btn', '2024-04-08 07:24:48', '2024-04-08 07:24:48'),
(15, '1712580911.jpeg', 'dwdw', NULL, 'tgf', 'This is test', '2024-04-03', 'rfr', 'cdsc', 'vvvvvvvvvvvvvvvvv', 'btn', '2024-04-08 07:25:11', '2024-04-08 07:25:11');

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

--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `image1` varchar(255) NOT NULL,
  `image2` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `col1` varchar(255) DEFAULT NULL,
  `c1link` varchar(255) DEFAULT NULL,
  `col2` varchar(255) DEFAULT NULL,
  `c2link` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `date` varchar(255) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `namee` varchar(255) DEFAULT NULL,
  `paragraph` varchar(255) DEFAULT NULL,
  `btext` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

--
-- Table structure for table `footers`
--

CREATE TABLE `footers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `copyright` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `heading1` varchar(255) DEFAULT NULL,
  `name1` varchar(255) DEFAULT NULL,
  `link1` varchar(255) DEFAULT NULL,
  `name2` varchar(255) DEFAULT NULL,
  `link2` varchar(255) DEFAULT NULL,
  `name3` varchar(255) DEFAULT NULL,
  `link3` varchar(255) DEFAULT NULL,
  `name4` varchar(255) DEFAULT NULL,
  `link4` varchar(255) DEFAULT NULL,
  `name5` varchar(255) DEFAULT NULL,
  `link5` varchar(255) DEFAULT NULL,
  `heading2` varchar(255) DEFAULT NULL,
  `namee1` varchar(255) DEFAULT NULL,
  `linkk1` varchar(255) DEFAULT NULL,
  `namee2` varchar(255) DEFAULT NULL,
  `linkk2` varchar(255) DEFAULT NULL,
  `namee3` varchar(255) DEFAULT NULL,
  `linkk3` varchar(255) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `images`
--

CREATE TABLE `images` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `status` enum('1','0') NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `logos`
--

CREATE TABLE `logos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) 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) 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_reset_tokens_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2023_05_16_104348_alter_users_table', 2),
(6, '2023_05_19_071335_create_categories_table', 3),
(7, '2023_07_02_012345_create_students_table', 4),
(8, '2023_05_06_111403_create_foodcategories_table', 5),
(9, '2023_05_07_050819_create_tabletypes_table', 5),
(10, '2023_05_07_050850_create_tables_table', 5),
(11, '2023_05_07_050914_create_chairtypes_table', 5),
(12, '2023_05_09_061444_create_tablebookings_table', 5),
(13, '2023_07_04_130541_create_sliders_table', 6),
(14, '2023_07_05_093101_create_sliders_table', 7),
(15, '2023_07_06_070456_create_logos_table', 8),
(16, '2023_07_07_054631_create_footers_table', 9),
(17, '2023_07_07_102114_create_about_uses_table', 10),
(18, '2023_07_11_115315_create_contacts_table', 11),
(19, '2023_07_11_125037_create_blogs_table', 12),
(20, '2023_07_12_114744_create_shareholders_table', 13),
(21, '2023_07_12_152346_create_directors_table', 14),
(22, '2023_07_13_025619_create_projects_table', 15),
(23, '2023_07_13_065705_create_completeds_table', 16),
(24, '2023_07_13_094300_create_developments_table', 17),
(25, '2023_07_13_120359_create_constructions_table', 18),
(26, '2023_07_13_175211_create_latestprojects_table', 19),
(27, '2023_07_14_060451_create_bloggs_table', 20),
(28, '2023_07_14_095354_create_terraces_table', 21),
(29, '2023_07_14_113005_create_directos_table', 22);

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

--
-- Table structure for table `sliders`
--

CREATE TABLE `sliders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `namee` varchar(255) DEFAULT NULL,
  `linkk` varchar(255) DEFAULT NULL,
  `status` tinyint(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;

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `blogs`
--
ALTER TABLE `blogs`
  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 `footers`
--
ALTER TABLE `footers`
  ADD PRIMARY KEY (`id`);

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

