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

START TRANSACTION;



--
-- Database: `lovekbkg_rmd`
--

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

--
-- Table structure for table `availability`
--

CREATE TABLE `availability` (
  `id` int(11) NOT NULL,
  `time` time NOT NULL,
  `status` enum('0','1') NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `availability`
--

INSERT INTO `availability` (`id`, `time`, `status`, `created_at`, `updated_at`) VALUES
(1, '00:00:00', '0', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(2, '00:30:00', '0', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(3, '01:00:00', '0', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(4, '01:30:00', '0', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(5, '02:00:00', '0', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(6, '02:30:00', '0', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(7, '03:00:00', '0', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(8, '03:30:00', '0', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(9, '04:00:00', '0', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(10, '04:30:00', '0', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(11, '05:00:00', '0', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(12, '05:30:00', '0', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(13, '06:00:00', '1', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(14, '06:30:00', '1', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(15, '07:00:00', '1', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(16, '07:30:00', '1', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(17, '08:00:00', '1', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(18, '08:30:00', '1', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(19, '09:00:00', '1', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(20, '09:30:00', '1', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(21, '10:00:00', '1', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(22, '10:30:00', '1', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(23, '11:00:00', '1', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(24, '11:30:00', '1', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(25, '12:00:00', '1', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(26, '12:30:00', '1', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(27, '13:00:00', '1', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(28, '13:30:00', '1', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(29, '14:00:00', '1', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(30, '14:30:00', '1', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(31, '15:00:00', '1', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(32, '15:30:00', '1', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(33, '16:00:00', '1', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(34, '16:30:00', '1', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(35, '17:00:00', '1', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(36, '17:30:00', '1', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(37, '18:00:00', '1', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(38, '18:30:00', '1', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(39, '19:00:00', '0', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(40, '19:30:00', '0', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(41, '20:00:00', '0', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(42, '20:30:00', '0', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(43, '21:00:00', '0', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(44, '21:30:00', '0', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(45, '22:00:00', '0', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(46, '22:30:00', '0', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(47, '23:00:00', '0', '2024-11-06 05:12:19', '2024-11-06 13:13:11'),
(48, '23:30:00', '0', '2024-11-06 05:12:19', '2024-11-06 13:13:11');

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

--
-- Table structure for table `banners`
--

CREATE TABLE `banners` (
  `id` int(11) NOT NULL,
  `heading` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `banners`
--

INSERT INTO `banners` (`id`, `heading`, `image`, `created_at`, `updated_at`) VALUES
(1, 'Experience Royalty with Moroccan Dresses', '1730902775main-banner2.jpg', '2024-11-06 19:19:35', '2024-11-06 19:19:35'),
(2, 'Dress to Impress, the Moroccan Way', '1730902801main-banner5.jpg', '2024-11-06 19:20:01', '2024-11-06 19:20:01');

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

--
-- Table structure for table `booking`
--

CREATE TABLE `booking` (
  `id` int(11) NOT NULL,
  `productid` int(11) DEFAULT NULL,
  `fname` text DEFAULT NULL,
  `lname` text DEFAULT NULL,
  `email` text DEFAULT NULL,
  `phone` text DEFAULT NULL,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `message` text DEFAULT NULL,
  `status` enum('active','completed','rejected','pending') NOT NULL DEFAULT 'pending',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `cart`
--

CREATE TABLE `cart` (
  `id` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `productid` int(11) NOT NULL,
  `quantity` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `name` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `name`, `image`, `created_at`, `updated_at`) VALUES
(17, 'Moroccon Dresses', '1730794530logo.jpg', '2024-11-05 13:15:30', '2024-11-05 13:15:30');

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

--
-- Table structure for table `contactus`
--

CREATE TABLE `contactus` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `email` text NOT NULL,
  `phone` text DEFAULT NULL,
  `subject` text DEFAULT NULL,
  `message` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_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_general_ci;

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

--
-- Table structure for table `instagram`
--

CREATE TABLE `instagram` (
  `id` int(11) NOT NULL,
  `image` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `instagram`
--

INSERT INTO `instagram` (`id`, `image`, `created_at`, `updated_at`) VALUES
(1, '1730908401img1.jpg', '2024-11-06 20:53:21', '2024-11-06 20:53:21'),
(2, '1730908488img2.jpg', '2024-11-06 20:54:48', '2024-11-06 20:54:48'),
(3, '1730908628img3.jpg', '2024-11-06 20:57:08', '2024-11-06 20:57:08'),
(4, '1730908635img4.jpg', '2024-11-06 20:57:15', '2024-11-06 20:57:15'),
(5, '1730908641img5.jpg', '2024-11-06 20:57:21', '2024-11-06 20:57:21'),
(6, '1730908647img6.jpg', '2024-11-06 20:57:27', '2024-11-06 20:57:27'),
(7, '1730908653img7.jpg', '2024-11-06 20:57:33', '2024-11-06 20:57:33');

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `orderid` text DEFAULT NULL,
  `fname` text DEFAULT NULL,
  `lname` text DEFAULT NULL,
  `email` text DEFAULT NULL,
  `phone` text DEFAULT NULL,
  `address` text DEFAULT NULL,
  `city` text DEFAULT NULL,
  `zipcode` text DEFAULT NULL,
  `price` text DEFAULT NULL,
  `status` text NOT NULL DEFAULT 'active',
  `promocode` text DEFAULT NULL,
  `discount` int(11) DEFAULT NULL,
  `total_price` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `order_details`
--

CREATE TABLE `order_details` (
  `id` int(11) NOT NULL,
  `orderid` int(11) NOT NULL,
  `productid` int(11) NOT NULL,
  `product_name` text DEFAULT NULL,
  `product_price` text DEFAULT NULL,
  `quantity` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` int(11) NOT NULL,
  `name` text DEFAULT NULL,
  `categoryid` int(11) NOT NULL,
  `cut_price` float DEFAULT NULL,
  `price` float DEFAULT NULL,
  `image` text DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `tags` text DEFAULT NULL,
  `stock` enum('in stock','out of stock') NOT NULL DEFAULT 'in stock',
  `slug` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `product_images`
--

CREATE TABLE `product_images` (
  `id` int(11) NOT NULL,
  `productid` int(11) NOT NULL,
  `image` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `promocodes`
--

CREATE TABLE `promocodes` (
  `id` int(11) NOT NULL,
  `name` text DEFAULT NULL,
  `discount` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `promocodes`
--

INSERT INTO `promocodes` (`id`, `name`, `discount`, `created_at`, `updated_at`) VALUES
(3, 'RING-50', 50, '2024-06-13 11:42:01', '2024-06-13 11:42:01');

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

--
-- Table structure for table `setting`
--

CREATE TABLE `setting` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `logo` varchar(255) NOT NULL,
  `footerlogo` text DEFAULT NULL,
  `favicon` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `setting`
--

INSERT INTO `setting` (`id`, `name`, `phone`, `email`, `location`, `logo`, `footerlogo`, `favicon`, `created_at`, `updated_at`) VALUES
(1, 'Royal Moroccan Dresses', '0628094457', 'royalmoroccandresses@outlook.com', 'Koperweg 11I, 2401LH Alphen aan den Rijn', '1730889278IMG_1808.png', '1730802776bl (1).jpeg', '1730794097favicon.jpg', '2023-03-20 06:55:50', '2024-11-06 15:34:38');

--
-- Indexes for dumped tables
--

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

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

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

--
-- Indexes for table `cart`
--
ALTER TABLE `cart`
  ADD PRIMARY KEY (`id`),
  ADD KEY `productid` (`productid`),
  ADD KEY `userid` (`userid`);

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

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

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `userid` (`userid`);

--
-- Indexes for table `order_details`
--
ALTER TABLE `order_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `orderid` (`orderid`),
  ADD KEY `productid` (`productid`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `products_ibfk_1` (`categoryid`);

--
-- Indexes for table `product_images`
--
ALTER TABLE `product_images`
  ADD PRIMARY KEY (`id`),
  ADD KEY `productid` (`productid`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `availability`
--
ALTER TABLE `availability`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=49;

--
-- AUTO_INCREMENT for table `banners`
--
ALTER TABLE `banners`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `booking`
--
ALTER TABLE `booking`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `cart`
--
ALTER TABLE `cart`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=60;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `contactus`
--
ALTER TABLE `contactus`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=106;

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

--
-- AUTO_INCREMENT for table `instagram`
--
ALTER TABLE `instagram`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `order_details`
--
ALTER TABLE `order_details`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `product_images`
--
ALTER TABLE `product_images`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=93;

--
-- AUTO_INCREMENT for table `promocodes`
--
ALTER TABLE `promocodes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `cart`
--
ALTER TABLE `cart`
  ADD CONSTRAINT `cart_ibfk_1` FOREIGN KEY (`productid`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `cart_ibfk_2` FOREIGN KEY (`userid`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `orders_ibfk_1` FOREIGN KEY (`userid`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `order_details`
--
ALTER TABLE `order_details`
  ADD CONSTRAINT `order_details_ibfk_1` FOREIGN KEY (`orderid`) REFERENCES `orders` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `order_details_ibfk_2` FOREIGN KEY (`productid`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_ibfk_1` FOREIGN KEY (`categoryid`) REFERENCES `categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `product_images`
--
ALTER TABLE `product_images`
  ADD CONSTRAINT `product_images_ibfk_1` FOREIGN KEY (`productid`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

