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

START TRANSACTION;



--
-- Database: `ecommerce`
--

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

--
-- 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;

--
-- Dumping data for table `about_uses`
--

INSERT INTO `about_uses` (`id`, `title`, `image`, `description`, `big_title`, `small_tilte`, `big_text`, `small_text`, `big_text2`, `small_text2`, `big_heading`, `small_heading1`, `small_heading2`, `small_heading3`, `big_heading2`, `paragraph`, `image1`, `name`, `description2`, `text_box`, `big_heading3`, `paragraph2`, `image2`, `name2`, `description3`, `text_box1`, `created_at`, `updated_at`) VALUES
(1, 'FEW DESCRIPTION', '1688972431.png', 'There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum.\r\n\r\n\r\nThere are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum.', 'CALL US :', 'ABOUT HOMY', 'APPARTMENT OR HOUSE', 'ergfer', 'WE ARE READY TO RECEIVE YOUR CALL', '+0412 001 123', 'VISION MISSION VALUE', 'VISION', 'MISSION', 'VALUE', 'SHAREHOLDERS', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Earum totam et dolores voluptatem porro tempore temporibus ducimus', '1688972360.jpg', 'DIRECTORS /', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Earum totam et dolores voluptatem porro tempore temporibus ducimus', 'Enterprising', 'Team', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Earum totam et dolores voluptatem porro tempore temporibus ducimus', '1688972360.png', 'erfer', 'Our', 'efer', '2023-07-07 05:46:03', '2023-07-14 07:39:46');

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

--
-- 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
(1, '1689326220.jpg', 'Mark Jonson', '#', 'LATEST DESIGN OF HOUSE', '#', '2023-07-14', '#', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard', 'Read More', '#', '2023-07-14 03:47:00', '2023-07-14 03:47:00'),
(2, '1689327145.jpg', 'Mark Jonson', '#', 'LATEST DESIGN OF HOUSE', '#', '2023-07-14', '#', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard', 'Read More', '#', '2023-07-14 03:56:24', '2023-07-14 04:02:25'),
(3, '1689327200.jpg', 'Thomas Roy', '#', 'LATEST DESIGN OF HOUSE', '#', '2023-07-15', '#', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard', 'Read More', '#', '2023-07-14 04:03:20', '2023-07-14 04:03:20'),
(4, '1689327297.jpg', 'Nelson Monika', '#', 'POPULAR DESIGN OF HOUSE', '#', '2023-07-27', '#', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard', 'Read More', '#', '2023-07-14 04:04:57', '2023-07-14 04:04:57'),
(5, '1689327328.jpg', 'New Superb Villa', '#', 'LATEST DESIGN OF HOUSE', '#', '2023-07-21', '#', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard', 'Read More', '#', '2023-07-14 04:05:28', '2023-07-14 04:05:28'),
(6, '1689327373.jpg', 'Properties', '#', 'LATEST DESIGN OF HOUSE', '#', '2023-07-21', '#', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard', 'Read More', '#', '2023-07-14 04:06:13', '2023-07-14 04:06:21');

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

--
-- 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;

--
-- Dumping data for table `blogs`
--

INSERT INTO `blogs` (`id`, `title`, `image1`, `image2`, `description`, `col1`, `c1link`, `col2`, `c2link`, `name`, `date`, `link`, `namee`, `paragraph`, `btext`, `created_at`, `updated_at`) VALUES
(1, 'OUR BLOG', '1689157508.jpg', '1689157496.jpg', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard', 'HOME', '#', 'BLOG', 'OUR', 'SUBSCRIBE', '2023-07-11', '#', 'NEWSLETTER', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard', 'Subscribe', NULL, '2023-07-13 11:51:21');

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

--
-- Table structure for table `completeds`
--

CREATE TABLE `completeds` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `btn1` varchar(255) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `text1` varchar(255) DEFAULT NULL,
  `text2` varchar(255) DEFAULT NULL,
  `col1` varchar(255) DEFAULT NULL,
  `col2` varchar(255) DEFAULT NULL,
  `col3` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `linkk` varchar(255) DEFAULT NULL,
  `description` text 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 `completeds`
--

INSERT INTO `completeds` (`id`, `btn1`, `link`, `image`, `text1`, `text2`, `col1`, `col2`, `col3`, `name`, `linkk`, `description`, `created_at`, `updated_at`) VALUES
(1, 'View Detailss', NULL, '1689239498.jpg', 'For Sale', '$59,999', '520 Sq ft', '6', '3', 'NEW SUPERB VILLA', NULL, '123 1st Width Road, , Summit, New York', '2023-07-13 03:13:01', '2023-07-13 03:55:29'),
(2, 'View Details', '#', '1689240490.jpg', 'For Sale', '$59,999', '520 Sq ft', '6', '3', 'New Superb Villa', '#', '123 1st Width Road, , summit, new york', '2023-07-13 03:58:10', '2023-07-13 03:58:10'),
(3, 'View Details', '#', '1689240678.jpg', 'For Sale', '$59,999', '520 Sq ft', '6', '3', 'NEW SUPERB VILLA', '#', '123 1st Width Road, , Summit, New York', '2023-07-13 04:01:18', '2023-07-13 04:01:18'),
(4, 'View Details', '#', '1689240729.jpg', 'For Sale', '$59,999', '520 Sq ft', '6', '3', 'New Superb Villa', '#', '123 1st Width Road, , Summit, New York', '2023-07-13 04:02:09', '2023-07-13 04:02:09'),
(5, 'View Details', '#', '1689240896.jpg', 'For Sale', '$59,999', '520 Sq ft', '6', '3', 'New Superb Villa', '#', '123 1st Width Road, , Summit, New York', '2023-07-13 04:04:56', '2023-07-13 04:04:56'),
(6, 'View Details', '#', '1689240965.jpg', 'For Sale', '$59,999', '520 Sq ft', '6', '3', 'New Superb Villa', '#', '123 1st Width Road, , Summit, New York', '2023-07-13 04:05:18', '2023-07-13 04:06:05'),
(8, 'View Details', '#', '1689244873.jpg', 'For Sale', '$59,999', '520 Sq ft', '6', '3', 'New Superb Villa', '#', '123 1st Width Road, , Summit, New York', '2023-07-13 05:11:13', '2023-07-13 05:11:13');

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

--
-- Table structure for table `constructions`
--

CREATE TABLE `constructions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `cbtn1` varchar(255) DEFAULT NULL,
  `clink` varchar(255) DEFAULT NULL,
  `cimage` varchar(255) DEFAULT NULL,
  `ctext1` varchar(255) DEFAULT NULL,
  `ctext2` varchar(255) DEFAULT NULL,
  `ccol1` varchar(255) DEFAULT NULL,
  `ccol2` varchar(255) DEFAULT NULL,
  `ccol3` varchar(255) DEFAULT NULL,
  `cname` varchar(255) DEFAULT NULL,
  `clinkk` varchar(255) DEFAULT NULL,
  `cdescription` text 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 `constructions`
--

INSERT INTO `constructions` (`id`, `cbtn1`, `clink`, `cimage`, `ctext1`, `ctext2`, `ccol1`, `ccol2`, `ccol3`, `cname`, `clinkk`, `cdescription`, `created_at`, `updated_at`) VALUES
(1, 'View Detailss', '#', '1689261037.jpg', 'For Sale', '$59,999', '520 sq ft', '6', '3', 'New Superb Villa', '#', '123 1st Width Road, , Summit, New York', NULL, '2023-07-13 09:42:53'),
(2, 'View Detailss', '#', '1689262048.jpg', 'For Sale', '$59,999', '520 sq ft', '6', '3', 'New Superb Villa', '#', '123 1st Width Road, , Summit, New York', '2023-07-13 09:57:28', '2023-07-13 09:57:28');

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

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `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,
  `mail` varchar(255) DEFAULT NULL,
  `namee` varchar(255) DEFAULT NULL,
  `linkk` 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 `contacts`
--

INSERT INTO `contacts` (`id`, `title`, `image`, `description`, `name`, `mail`, `namee`, `linkk`, `created_at`, `updated_at`) VALUES
(1, 'Contact Us', '1689077869.png', '99, Big Building, Glasgow, United Kingdom.', 'HOME', 'excellia@gmail.com', 'Contact us', '+0123 (123) 6719900', NULL, '2023-07-12 12:15:33');

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

--
-- Table structure for table `developments`
--

CREATE TABLE `developments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `dbtn1` varchar(255) DEFAULT NULL,
  `dlink` varchar(255) DEFAULT NULL,
  `dimage` varchar(255) DEFAULT NULL,
  `dtext1` varchar(255) DEFAULT NULL,
  `dtext2` varchar(255) DEFAULT NULL,
  `dcol1` varchar(255) DEFAULT NULL,
  `dcol2` varchar(255) DEFAULT NULL,
  `dcol3` varchar(255) DEFAULT NULL,
  `dname` varchar(255) DEFAULT NULL,
  `dlinkk` varchar(255) DEFAULT NULL,
  `ddescription` text 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 `developments`
--

INSERT INTO `developments` (`id`, `dbtn1`, `dlink`, `dimage`, `dtext1`, `dtext2`, `dcol1`, `dcol2`, `dcol3`, `dname`, `dlinkk`, `ddescription`, `created_at`, `updated_at`) VALUES
(1, 'View details', '#', '1689247844.jpg', 'For Sale', '$59,999', '520 sq ft', '6', '3', 'New Superb Villa', '#', '123 1st Width Road, , Summit, New York', NULL, '2023-07-13 06:00:44'),
(2, 'View Detail', '#', '1689246865.jpg', 'For Sale', '$59,999', '520 sq ft', '6', '3', 'New Superb Villa', '#', '123 1st Width Road, , Summit, New York', '2023-07-13 05:44:25', '2023-07-13 06:01:17'),
(3, 'View Detail', '#', '1689248691.jpg', 'For Sale', '$59,999', '520 sq ft', '6', '3', 'New Superb Villa', '#', '123 1st Width Road, , Summit, New York', '2023-07-13 06:14:39', '2023-07-13 06:15:01');

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

--
-- Table structure for table `directors`
--

CREATE TABLE `directors` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title1` varchar(255) DEFAULT NULL,
  `title2` varchar(255) DEFAULT NULL,
  `image1` varchar(255) DEFAULT NULL,
  `paragraph` text 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 `directors`
--

INSERT INTO `directors` (`id`, `title1`, `title2`, `image1`, `paragraph`, `created_at`, `updated_at`) VALUES
(1, 'DIRECTORS /', 'SHAREHOLDERS', '1689184478.png', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Earum totam et dolores voluptatem porro tempore temporibus ducimus', NULL, '2023-07-12 12:32:16');

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

--
-- Table structure for table `directos`
--

CREATE TABLE `directos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `dimage` varchar(255) DEFAULT NULL,
  `dname` varchar(255) DEFAULT NULL,
  `dlink` varchar(255) DEFAULT NULL,
  `paragraph` text DEFAULT NULL,
  `dbtn` varchar(255) DEFAULT NULL,
  `link` 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 `directos`
--

INSERT INTO `directos` (`id`, `dimage`, `dname`, `dlink`, `paragraph`, `dbtn`, `link`, `created_at`, `updated_at`) VALUES
(1, '1689337339.png', 'RAJEEV BUNDHOO', '#', 'Shareholder & Director With over 20 years of experience in large-scale project management, the construction, energy and telecommunication sectors, Rajeev Bundhoo is at the helm of business development and the global expansion of the company.', 'Enterprising', '#', '2023-07-14 06:52:19', '2023-07-14 06:52:19'),
(2, '1689337580.png', 'ZENO FLECK', '#', 'Shareholder & Director With an outstanding track record as a financial advisor in Germany, Zeno Fleck is responsible for the financing of our projects and will guide you in every investment choice.', 'Insightful', '#', '2023-07-14 06:56:20', '2023-07-14 07:01:08'),
(3, '1689337683.png', 'BHIMAL GOOROOCHURN', '#', 'Shareholder & Director Bhimal Gooroochurn has over 25 years of experience in the energy, construction and asset management sectors. His financial expertise is key to directing Excellia Properties’ global growth objectives.', 'Rigorous', '#', '2023-07-14 06:58:03', '2023-07-14 06:58:03'),
(4, '1689337799.png', 'ASLAM HOSANY', '#', 'Shareholder & Director Aslam Hosany is our Customer Relations expert. After more than 34 years in the import-export sector, he has developed a keen sense of listening to better understand our clients’ needs and find optimal solutions.', 'Epicurean', '#', '2023-07-14 06:59:59', '2023-07-14 06:59:59');

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

--
-- 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;

--
-- Dumping data for table `footers`
--

INSERT INTO `footers` (`id`, `copyright`, `image`, `description`, `heading1`, `name1`, `link1`, `name2`, `link2`, `name3`, `link3`, `name4`, `link4`, `name5`, `link5`, `heading2`, `namee1`, `linkk1`, `namee2`, `linkk2`, `namee3`, `linkk3`, `address`, `created_at`, `updated_at`) VALUES
(1, '@skylabs2024', '1688712634.png', 'testing', 'edw', 'wedwe', 'wedwe', 'cewd', 'cwcdw', 'dewd', 'ecewc', 'edew', 'cwdw', 'edewd', 'cewdew', 'cwcdew', 'cwedwe', 'ff', 'dew', 'w', 'weg', 'tgtr', 'Mauritius', NULL, '2023-07-07 01:44:54');

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

--
-- 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 `latestprojects`
--

CREATE TABLE `latestprojects` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `lbtn1` varchar(255) DEFAULT NULL,
  `llink` varchar(255) DEFAULT NULL,
  `limage` varchar(255) DEFAULT NULL,
  `ltext1` varchar(255) DEFAULT NULL,
  `ltext2` varchar(255) DEFAULT NULL,
  `lcol1` varchar(255) DEFAULT NULL,
  `lcol2` varchar(255) DEFAULT NULL,
  `lcol3` varchar(255) DEFAULT NULL,
  `lname` varchar(255) DEFAULT NULL,
  `llinkk` varchar(255) DEFAULT NULL,
  `ldescription` text 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 `latestprojects`
--

INSERT INTO `latestprojects` (`id`, `lbtn1`, `llink`, `limage`, `ltext1`, `ltext2`, `lcol1`, `lcol2`, `lcol3`, `lname`, `llinkk`, `ldescription`, `created_at`, `updated_at`) VALUES
(1, 'View Details', '#', '1689313117.jpg', 'For Sale', '$59,999', '520 sq ft', '6', NULL, 'New Superb Villa', '#', '123 1st Width Road, , Summit, New York', '2023-07-13 23:53:04', '2023-07-14 00:08:37'),
(2, 'View Details', '#', '1689313127.jpg', 'For Sale', '$59,999', '520 sq ft', '6', NULL, 'New Superb Villa', '#', '123 1st Width Road, , Summit, New York', '2023-07-13 23:57:45', '2023-07-14 00:08:47'),
(3, 'View Details', '#', '1689313244.jpg', 'For Sale', '$59,999', '520 sq ft', '6', '3', 'New Superb Villa', '#', '123 1st Width Road, , Summit, New York', '2023-07-14 00:10:44', '2023-07-14 00:10:44'),
(4, 'View Details', '#', '1689313277.jpg', 'For Sale', '$59,999', '520 sq ft', '6', '3', 'New Superb Villa', '#', '123 1st Width Road, , Summit, New York', '2023-07-14 00:11:17', '2023-07-14 00:11:17'),
(5, 'View Details', '#', '1689313299.jpg', 'For Sale', '$59,999', '520 sq ft', '6', '3', 'New Superb Villa', '#', '123 1st Width Road, , Summit, New York', '2023-07-14 00:11:39', '2023-07-14 00:11:39'),
(6, 'View Details', '#', '1689313322.jpg', 'For Sale', '$59,999', '520 sq ft', '6', '3', 'New Superb Villa', '#', '123 1st Width Road, , Summit, New York', '2023-07-14 00:12:02', '2023-07-14 00:12:02');

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

--
-- 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;

--
-- Dumping data for table `logos`
--

INSERT INTO `logos` (`id`, `image`, `created_at`, `updated_at`) VALUES
(1, '1688733056.png', NULL, '2023-07-07 07:00:56');

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

--
-- 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 `projects`
--

CREATE TABLE `projects` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title1` varchar(255) DEFAULT NULL,
  `title2` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `btn1` varchar(255) DEFAULT NULL,
  `name1` varchar(255) DEFAULT NULL,
  `name2` varchar(255) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `col1` varchar(255) DEFAULT NULL,
  `col2` varchar(255) DEFAULT NULL,
  `linkk` varchar(255) DEFAULT NULL,
  `title3` varchar(255) DEFAULT NULL,
  `title4` varchar(255) DEFAULT NULL,
  `text1` varchar(255) DEFAULT NULL,
  `text2` varchar(255) DEFAULT NULL,
  `paragraph1` text DEFAULT NULL,
  `image1` varchar(255) DEFAULT NULL,
  `image2` varchar(255) DEFAULT NULL,
  `uname1` varchar(255) DEFAULT NULL,
  `uname2` varchar(255) DEFAULT NULL,
  `ulink` varchar(255) DEFAULT NULL,
  `ucol1` varchar(255) DEFAULT NULL,
  `ucol2` varchar(255) DEFAULT NULL,
  `ulinkk` varchar(255) DEFAULT NULL,
  `utitle3` varchar(255) DEFAULT NULL,
  `utitle4` varchar(255) DEFAULT NULL,
  `utext1` varchar(255) DEFAULT NULL,
  `utext2` varchar(255) DEFAULT NULL,
  `uparagraph1` text DEFAULT NULL,
  `uimage1` varchar(255) DEFAULT NULL,
  `uimage2` varchar(255) DEFAULT NULL,
  `cname1` varchar(255) DEFAULT NULL,
  `cname2` varchar(255) DEFAULT NULL,
  `clink` varchar(255) DEFAULT NULL,
  `ccol1` varchar(255) DEFAULT NULL,
  `ccol2` varchar(255) DEFAULT NULL,
  `clinkk` varchar(255) DEFAULT NULL,
  `ctitle3` varchar(255) DEFAULT NULL,
  `ctitle4` varchar(255) DEFAULT NULL,
  `ctext1` varchar(255) DEFAULT NULL,
  `ctext2` varchar(255) DEFAULT NULL,
  `cparagraph1` text DEFAULT NULL,
  `cimage1` varchar(255) DEFAULT NULL,
  `cimage2` 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 `projects`
--

INSERT INTO `projects` (`id`, `title1`, `title2`, `description`, `btn1`, `name1`, `name2`, `link`, `col1`, `col2`, `linkk`, `title3`, `title4`, `text1`, `text2`, `paragraph1`, `image1`, `image2`, `uname1`, `uname2`, `ulink`, `ucol1`, `ucol2`, `ulinkk`, `utitle3`, `utitle4`, `utext1`, `utext2`, `uparagraph1`, `uimage1`, `uimage2`, `cname1`, `cname2`, `clink`, `ccol1`, `ccol2`, `clinkk`, `ctitle3`, `ctitle4`, `ctext1`, `ctext2`, `cparagraph1`, `cimage1`, `cimage2`, `created_at`, `updated_at`) VALUES
(1, 'Latest', 'projects', 'After make a primary deposit you can be a ownner of a property', 'More Properties', 'complete Project', NULL, NULL, 'Home', 'complete Project', NULL, 'Completed', 'projects', NULL, NULL, 'After make a primary deposit you can be a ownner of a property', '1689228757.jpg', '1689228757.png', 'UNDER DEVELOPMENT PROJECT', NULL, NULL, 'HOME', 'UNDER DEVELOPMENT PROJECT', NULL, 'UNDER', 'DEVELOPMENT PROJECT', NULL, NULL, 'After make a primary deposit you can be a ownner of a property', '1689228757.jpg', '1689228757.jpg', 'Under Construction', NULL, NULL, 'HOME', 'Under Construction', NULL, 'UNDER', 'Construction', NULL, NULL, 'After making a primary deposit you can be a owner of a property.', '1689228757.jpg', '1689228757.jpg', NULL, '2023-07-13 00:42:37');

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

--
-- Table structure for table `shareholders`
--

CREATE TABLE `shareholders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title1` varchar(255) DEFAULT NULL,
  `title2` varchar(255) DEFAULT NULL,
  `image1` varchar(255) DEFAULT NULL,
  `paragraph` text DEFAULT NULL,
  `image2` varchar(255) DEFAULT NULL,
  `flink` varchar(255) DEFAULT NULL,
  `tlink` varchar(255) DEFAULT NULL,
  `llink` varchar(255) DEFAULT NULL,
  `vlink` varchar(255) DEFAULT NULL,
  `contact` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `namee` 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 `shareholders`
--

INSERT INTO `shareholders` (`id`, `title1`, `title2`, `image1`, `paragraph`, `image2`, `flink`, `tlink`, `llink`, `vlink`, `contact`, `name`, `link`, `namee`, `created_at`, `updated_at`) VALUES
(1, 'DIRECTORS /', 'SHAREHOLDERS', '1689167806.png', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Earum totam et dolores voluptatem porro tempore temporibus ducimus', '1689167825.png', 'fewfdw', 'fewfd', 'wefewf', 'wfewf', '+9178383999393', 'ASLAM HOSANY', 'ferf', 'Enterprising', NULL, '2023-07-12 07:47:05'),
(2, 'DIRECTORS /', 'SHAREHOLDERS', '1689168439.png', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Earum totam et dolores voluptatem porro tempore temporibus ducimus', '1689168250.png', 'facebook.com', 'twitter.com', 'linkedin.com', 'viemo.com', '+87574893738', 'ZENO FLECK', NULL, 'Insightful', '2023-07-12 07:14:28', '2023-07-12 07:57:19');

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

--
-- 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;

--
-- Dumping data for table `sliders`
--

INSERT INTO `sliders` (`id`, `title`, `image`, `description`, `name`, `link`, `namee`, `linkk`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Ocean Terraces', '1688556544.jpg', 'Ocean Terraces is nestled on the beautiful East Coast of the island and presents', 'Properties', 'https://www.youtube.com/watch?v=2OXAZasseaI&list=PLIeKz8l1eVaP4A4rN129dUqKhBAeBvN3z', 'Contact Us', 'sdsd', 1, '2023-07-05 04:10:26', '2023-07-06 01:06:58'),
(2, 'Ocean Suites', '1688556814.jpg', 'Located right  Ocean Suites is nestled on the beautiful East Coast of the island and presents', 'Properties', 'yth', 'Contact Us', 'tty', 1, '2023-07-05 04:20:24', '2023-07-05 06:03:34'),
(7, 'saa', '1688551150.jpg', 'sad', 'dwq', 'sdw', 'dwd', 'dwq', 1, '2023-07-05 04:29:10', '2023-07-05 04:29:10'),
(8, 'qswq', '1688551223.jpg', 'qsq', 'qswq', 'qsqw', 'wqsq', 'wsqw', 1, '2023-07-05 04:30:23', '2023-07-05 04:30:23'),
(9, 'wxw', '1688551319.jpg', 'edwq', 'ed', 'dwe', 'ewf', 'dwe', 1, '2023-07-05 04:31:59', '2023-07-05 04:31:59');

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

--
-- Table structure for table `terraces`
--

CREATE TABLE `terraces` (
  `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,
  `text1` text DEFAULT NULL,
  `text2` varchar(255) DEFAULT NULL,
  `text3` varchar(255) DEFAULT NULL,
  `text4` 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 `terraces`
--

INSERT INTO `terraces` (`id`, `image`, `name`, `link`, `namee`, `linkk`, `date`, `dlink`, `text1`, `text2`, `text3`, `text4`, `created_at`, `updated_at`) VALUES
(1, '1689331766.png', 'Mark Jonson', '#', 'KAREN EILLA BOYETTE', '#', '2023-07-13', '#', 'Project value: EUR 9 M.', 'Completion: March 2023.', 'Location: Post Lafayette', '14 apartments.', '2023-07-14 04:57:33', '2023-07-14 05:19:26'),
(2, '1689330488.png', 'Mark Jonson', '#', 'LATEST DESIGN OF HOUSE', '#', '2023-07-15', '#', 'Project value: EUR 9 M.', 'Completion: March 2023.', 'Location: Post Lafayette', '14 apartments.', '2023-07-14 04:58:08', '2023-07-14 05:00:30'),
(3, '1689330539.png', 'Thomas Roy', '#', 'LATEST DESIGN OF HOUSE', '#', '2023-07-15', '#', 'Project value: EUR 9 M.', 'Completion: March 2023.', 'Location: Post Lafayette', '14 apartments.', '2023-07-14 04:58:59', '2023-07-14 04:58:59');

--
-- 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 `completeds`
--
ALTER TABLE `completeds`
  ADD PRIMARY KEY (`id`);

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

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

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

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

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

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

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

--
-- Indexes for table `terraces`
--
ALTER TABLE `terraces`
  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=8;

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `directos`
--
ALTER TABLE `directos`
  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 `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 `latestprojects`
--
ALTER TABLE `latestprojects`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- 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 `projects`
--
ALTER TABLE `projects`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

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

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

