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

START TRANSACTION;



--
-- Database: `angelscloset`
--

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

--
-- Table structure for table `activity_log`
--

CREATE TABLE `activity_log` (
  `id` int(11) NOT NULL,
  `user_type` enum('admin','user') NOT NULL,
  `user_id` int(11) NOT NULL,
  `action` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` varchar(500) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `activity_log`
--

INSERT INTO `activity_log` (`id`, `user_type`, `user_id`, `action`, `description`, `ip_address`, `user_agent`, `created_at`) VALUES
(1, 'admin', 0, 'admin_login_failed', 'Failed login attempt for: admin', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-26 14:29:26'),
(2, 'admin', 1, 'admin_login', 'Admin logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-26 14:29:33'),
(3, 'user', 0, 'booking_created', 'New booking created: BK-20250926-CE11C9', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-26 16:21:48'),
(4, 'admin', 1, 'category_updated', 'Updated category: Hair', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-26 16:45:46'),
(5, 'admin', 1, 'category_created', 'Created category: Perfumes', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-26 16:46:51'),
(6, 'admin', 1, 'category_created', 'Created category: Women clothing', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-26 16:49:03'),
(7, 'admin', 1, 'settings_updated', 'Site settings updated', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-26 21:05:29'),
(8, 'admin', 1, 'settings_updated', 'Site settings updated', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-27 10:14:58'),
(9, 'admin', 1, 'category_updated', 'Updated category: Women clothing', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-27 10:16:16'),
(10, 'admin', 1, 'product_updated', 'Updated product: Elegant Evening Dress', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-27 10:16:55'),
(11, 'user', 1, 'user_register', 'New user registered: Wisdomjp', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-27 10:36:29'),
(12, 'user', 1, 'user_logout', 'User logged out', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-27 10:37:24'),
(13, 'admin', 1, 'blog_post_updated', 'Updated blog post: Summer Fashion Trends 2025', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-27 10:41:14'),
(14, 'admin', 1, 'service_updated', 'Updated service: makeup', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-27 11:13:57'),
(15, 'admin', 1, 'service_updated', 'Updated service: makeup', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-27 11:16:22'),
(16, 'user', 0, 'booking_created', 'New booking created: BK-20250927-25D056', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-27 11:19:46'),
(17, 'admin', 1, 'booking_updated', 'Booking status updated: 2', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-27 11:24:01'),
(18, 'admin', 1, 'product_created', 'Created product: Amour Au Paradis', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-27 12:49:08'),
(19, 'admin', 1, 'product_updated', 'Updated product: Amour Au Paradis', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-27 12:50:02'),
(20, 'user', 0, 'contact_message', 'New contact message from: wisdomjoseph329@gmail.com', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-27 14:15:11'),
(21, 'admin', 1, 'user_status_updated', 'User deactivated: 1', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-27 14:17:19'),
(22, 'admin', 1, 'user_status_updated', 'User activated: 1', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-27 14:17:25'),
(23, 'admin', 1, 'settings_updated', 'Site settings updated', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-29 10:31:48'),
(24, 'admin', 1, 'settings_updated', 'Site settings updated', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-29 10:42:07'),
(25, 'admin', 1, 'settings_updated', 'Site settings updated', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-29 10:44:04'),
(26, 'admin', 1, 'settings_updated', 'Site settings updated', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-29 10:47:22'),
(27, 'admin', 1, 'settings_updated', 'Site settings updated', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-29 11:18:24'),
(28, 'admin', 1, 'settings_updated', 'Site settings updated', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-29 11:18:59'),
(29, 'user', 0, 'booking_created', 'New booking created: BK-20250929-B980BA', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-29 11:20:27'),
(30, 'admin', 1, 'service_updated', 'Updated service: microbladding', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-29 11:29:46'),
(31, 'admin', 1, 'service_updated', 'Updated service: lash extensions', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-29 11:30:29'),
(32, 'admin', 1, 'order_updated', 'Order status updated: 6', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-29 11:47:24'),
(33, 'user', 0, 'booking_created', 'New booking created: BK-20250929-6CFD2B', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-29 13:59:02'),
(34, 'user', 0, 'booking_created', 'New booking created: BK-20250929-BB2CA0', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-29 14:00:11'),
(35, 'admin', 1, 'booking_updated', 'Booking status updated: 5', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-29 14:00:43'),
(36, 'admin', 1, 'admin_login', 'Admin logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-29 17:40:27'),
(37, 'admin', 1, 'admin_login', 'Admin logged in successfully', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-29 21:25:39'),
(38, 'admin', 1, 'settings_updated', 'Site settings updated', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-29 21:55:51'),
(39, 'admin', 1, 'settings_updated', 'Site settings updated', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-29 21:56:12'),
(40, 'admin', 1, 'settings_updated', 'Site settings updated', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-29 21:57:22'),
(41, 'admin', 1, 'settings_updated', 'Site settings updated', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-29 22:01:07'),
(42, 'admin', 1, 'settings_updated', 'Site settings updated', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-29 22:02:22'),
(43, 'admin', 1, 'settings_updated', 'Site settings updated', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-29 22:08:51'),
(44, 'user', 0, 'booking_created', 'New booking created: BK-20250930-E1907F', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '2025-09-29 22:15:42');

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

--
-- Table structure for table `blog_posts`
--

CREATE TABLE `blog_posts` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `content` longtext NOT NULL,
  `excerpt` text DEFAULT NULL,
  `featured_image` varchar(255) DEFAULT NULL,
  `author_id` int(11) DEFAULT NULL,
  `status` enum('draft','published') DEFAULT 'draft',
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `blog_posts`
--

INSERT INTO `blog_posts` (`id`, `title`, `slug`, `content`, `excerpt`, `featured_image`, `author_id`, `status`, `meta_title`, `meta_description`, `created_at`, `updated_at`) VALUES
(1, 'Summer Fashion Trends 2025', 'summer-fashion-trends-2025', '<p>Discover the hottest summer fashion trends for 2025. From vibrant colors to flowing fabrics, this season is all about comfort and style.</p>\r\n<p>Our collection features the latest trends that will keep you looking fabulous all summer long.</p>', 'Discover the hottest summer fashion trends for 2025', 'blog/68d7bf49d89ad_1758969673.webp', 1, 'published', '', '', '2025-09-26 10:35:20', '2025-09-27 10:41:13'),
(2, 'How to Style Your Wardrobe', 'how-to-style-your-wardrobe', '<p>Learn professional styling tips to make the most of your wardrobe. Our expert stylists share their secrets for creating stunning outfits.</p><p>From color coordination to accessorizing, we cover everything you need to know.</p>', 'Professional styling tips to maximize your wardrobe', NULL, 1, 'published', NULL, NULL, '2025-09-26 10:35:20', '2025-09-26 10:35:20'),
(3, 'The Perfect Dress for Every Occasion', 'perfect-dress-every-occasion', '<p>Finding the right dress for different occasions can be challenging. Our guide helps you choose the perfect dress whether it\'s for work, parties, or special events.</p>', 'Guide to choosing the perfect dress for any occasion', NULL, 1, 'published', NULL, NULL, '2025-09-26 10:35:20', '2025-09-26 10:35:20');

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

--
-- Table structure for table `bookings`
--

CREATE TABLE `bookings` (
  `id` int(11) NOT NULL,
  `booking_number` varchar(50) NOT NULL,
  `service_id` int(11) NOT NULL,
  `customer_name` varchar(100) NOT NULL,
  `customer_email` varchar(100) NOT NULL,
  `customer_phone` varchar(20) NOT NULL,
  `booking_date` date NOT NULL,
  `booking_time` time NOT NULL,
  `notes` text DEFAULT NULL,
  `status` enum('pending','confirmed','completed','cancelled') DEFAULT 'pending',
  `total_amount` decimal(10,2) NOT NULL,
  `payment_status` enum('pending','paid','failed') DEFAULT 'pending',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `bookings`
--

INSERT INTO `bookings` (`id`, `booking_number`, `service_id`, `customer_name`, `customer_email`, `customer_phone`, `booking_date`, `booking_time`, `notes`, `status`, `total_amount`, `payment_status`, `created_at`, `updated_at`) VALUES
(1, 'BK-20250926-CE11C9', 2, 'Wisdom Joseph', 'wisdomjoseph329@gmail.com', '09029260613', '2025-09-29', '14:00:00', 'be fast and on time', 'pending', 35000.00, 'pending', '2025-09-26 16:21:48', '2025-09-26 16:21:48'),
(2, 'BK-20250927-25D056', 2, 'Wisdom Joseph', 'wisdomjoseph329@gmail.com', '09029260613', '2025-09-30', '14:00:00', 'sharp', 'confirmed', 35000.00, 'paid', '2025-09-27 11:19:46', '2025-09-27 11:24:01'),
(3, 'BK-20250929-B980BA', 2, 'Wisdom Joseph', 'wisdomjoseph329@gmail.com', '09029260613', '2025-10-08', '16:00:00', 'll', 'pending', 35000.00, 'pending', '2025-09-29 11:20:27', '2025-09-29 11:20:27'),
(4, 'BK-20250929-6CFD2B', 4, 'Wisdom Joseph', 'wisdomjoseph329@gmail.com', '09029260613', '2025-10-08', '16:00:00', 'kjj', 'pending', 45000.00, 'pending', '2025-09-29 13:59:02', '2025-09-29 13:59:02'),
(5, 'BK-20250929-BB2CA0', 3, 'Wisdom Joseph', 'wisdomjoseph329@gmail.com', '09029260613', '2025-10-09', '13:00:00', 'wee', 'completed', 25000.00, 'paid', '2025-09-29 14:00:11', '2025-09-29 14:00:43'),
(6, 'BK-20250930-E1907F', 3, 'Wisdom Joseph', 'wisdomjoseph329@gmail.com', '09029260613', '2025-10-08', '11:00:00', 'pls ben on time', 'pending', 25000.00, 'pending', '2025-09-29 22:15:42', '2025-09-29 22:15:42');

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

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

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `description` text DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `sort_order` int(11) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `categories` (`id`, `name`, `slug`, `description`, `image`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES
(1, 'Dresses', 'dresses', 'Beautiful dresses for every occasion', NULL, 1, 1, '2025-09-26 10:35:20', '2025-09-26 10:35:20'),
(2, 'Shoes', 'shoes', 'Stylish footwear collection', NULL, 1, 2, '2025-09-26 10:35:20', '2025-09-26 10:35:20'),
(3, 'Bags', 'bags', 'Designer handbags and accessories', NULL, 1, 3, '2025-09-26 10:35:20', '2025-09-26 10:35:20'),
(4, 'Accessories', 'accessories', 'Fashion accessories and jewelry', NULL, 1, 4, '2025-09-26 10:35:20', '2025-09-26 10:35:20'),
(5, 'Hair', 'sale-items', 'Discounted fashion items', NULL, 1, 5, '2025-09-26 10:35:20', '2025-09-26 16:45:46'),
(6, 'Perfumes', 'perfumes', 'all kinds of Perfumes', '', 1, 1, '2025-09-26 16:46:51', '2025-09-26 16:46:51'),
(7, 'Women clothing', 'women-clothing', 'all best', 'categories/68d7b96f37c90_1758968175.webp', 1, 0, '2025-09-26 16:49:03', '2025-09-27 10:16:15');

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

--
-- Table structure for table `contact_messages`
--

CREATE TABLE `contact_messages` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `status` enum('new','read','replied') DEFAULT 'new',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `contact_messages`
--

INSERT INTO `contact_messages` (`id`, `name`, `email`, `subject`, `message`, `status`, `created_at`) VALUES
(1, 'bridget', 'wisdomjoseph329@gmail.com', 'shoe', 'i have a problem', 'new', '2025-09-27 14:15:11');

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

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

CREATE TABLE `orders` (
  `id` int(11) NOT NULL,
  `order_number` varchar(50) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `customer_name` varchar(100) NOT NULL,
  `customer_email` varchar(100) NOT NULL,
  `customer_phone` varchar(20) DEFAULT NULL,
  `shipping_address` text NOT NULL,
  `billing_address` text DEFAULT NULL,
  `city` varchar(50) DEFAULT NULL,
  `state` varchar(50) DEFAULT NULL,
  `country` varchar(50) DEFAULT 'Nigeria',
  `total_amount` decimal(10,2) NOT NULL,
  `shipping_fee` decimal(10,2) DEFAULT 0.00,
  `discount` decimal(10,2) DEFAULT 0.00,
  `status` enum('pending','processing','shipped','delivered','cancelled') DEFAULT 'pending',
  `payment_method` varchar(50) DEFAULT NULL,
  `payment_status` enum('pending','paid','failed','refunded') DEFAULT 'pending',
  `notes` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`id`, `order_number`, `user_id`, `customer_name`, `customer_email`, `customer_phone`, `shipping_address`, `billing_address`, `city`, `state`, `country`, `total_amount`, `shipping_fee`, `discount`, `status`, `payment_method`, `payment_status`, `notes`, `created_at`, `updated_at`) VALUES
(1, 'AC-20250927-292BAF', NULL, 'Wisdom Joseph', 'wisdomjoseph329@gmail.com', '09029260613', 'Plot 91 new road borikiri port Harcourt', NULL, 'Port Harcourt', 'River State', 'Nigeria', 120000.00, 0.00, 0.00, 'pending', 'bank_transfer', 'pending', '', '2025-09-27 17:43:46', '2025-09-27 17:43:46'),
(2, 'AC-20250927-1B6123', NULL, 'Wisdom bridget', 'wisdomjoseph329@gmail.com', '07010108258', '5tywy', NULL, 'Lagos', 'Lagos', 'Nigeria', 65000.00, 0.00, 0.00, 'pending', 'bank_transfer', 'pending', '', '2025-09-27 18:07:13', '2025-09-27 18:07:13'),
(3, 'AC-20250927-39770E', NULL, 'Wisdom Joseph', 'wisdomjoseph329@gmail.com', '+2349029260613', 'Plot 91 new road borikiri port Harcourt', NULL, 'Lagos', 'Lagos', 'Nigeria', 31000.00, 0.00, 0.00, 'pending', 'bank_transfer', 'pending', '', '2025-09-27 21:47:31', '2025-09-27 21:47:31'),
(4, 'AC-20250927-E1BE66', NULL, 'Wisdom Joseph', 'wisdomjoseph329@gmail.com', '09029260613', 'Plot 91 new road borikiri port Harcourt', NULL, 'Port Harcourt', 'River State', 'Nigeria', 20000.00, 0.00, 0.00, 'pending', 'bank_transfer', 'pending', '', '2025-09-27 21:58:54', '2025-09-27 21:58:54'),
(5, 'AC-20250929-13D9C2', NULL, 'Wisdom Joseph', 'wisdomjoseph329@gmail.com', '+2349029260613', 'Plot 91 new road borikiri port Harcourt', NULL, 'Lagos', 'Lagos', 'Nigeria', 45000.00, 0.00, 0.00, 'pending', 'bank_transfer', 'pending', 'on time please', '2025-09-29 07:19:13', '2025-09-29 07:19:13'),
(6, 'AC-20250929-BBB75E', NULL, 'Wisdom Joseph', 'wisdomjoseph329@gmail.com', '+2349029260613', 'Plot 91 new road borikiri port Harcourt', NULL, 'Lagos', 'Lagos', 'Nigeria', 35000.00, 0.00, 0.00, 'delivered', 'bank_transfer', 'paid', '', '2025-09-29 11:21:47', '2025-09-29 11:47:24'),
(7, 'AC-20250930-C1C9D4', NULL, 'Wisdom Joseph', 'wisdomjoseph329@gmail.com', '+2349029260613', 'Plot 91 new road borikiri port Harcourt', NULL, 'Lagos', 'Lagos', 'Nigeria', 20000.00, 0.00, 0.00, 'pending', 'bank_transfer', 'pending', '', '2025-09-29 22:14:36', '2025-09-29 22:14:36');

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

--
-- Table structure for table `order_items`
--

CREATE TABLE `order_items` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `product_name` varchar(255) NOT NULL,
  `product_price` decimal(10,2) NOT NULL,
  `quantity` int(11) NOT NULL,
  `total` decimal(10,2) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `order_items`
--

INSERT INTO `order_items` (`id`, `order_id`, `product_id`, `product_name`, `product_price`, `quantity`, `total`, `created_at`) VALUES
(1, 1, 1, 'Elegant Evening Dress', 20000.00, 2, 40000.00, '2025-09-27 17:43:46'),
(2, 1, 2, 'Casual Summer Dress', 15000.00, 2, 30000.00, '2025-09-27 17:43:46'),
(3, 1, 6, 'Amour Au Paradis', 25000.00, 2, 50000.00, '2025-09-27 17:43:46'),
(4, 2, 1, 'Elegant Evening Dress', 20000.00, 2, 40000.00, '2025-09-27 18:07:13'),
(5, 2, 6, 'Amour Au Paradis', 25000.00, 1, 25000.00, '2025-09-27 18:07:13'),
(6, 3, 5, 'Fashion Jewelry Set', 6000.00, 1, 6000.00, '2025-09-27 21:47:31'),
(7, 3, 6, 'Amour Au Paradis', 25000.00, 1, 25000.00, '2025-09-27 21:47:31'),
(8, 4, 1, 'Elegant Evening Dress', 20000.00, 1, 20000.00, '2025-09-27 21:58:54'),
(9, 5, 1, 'Elegant Evening Dress', 20000.00, 1, 20000.00, '2025-09-29 07:19:13'),
(10, 5, 6, 'Amour Au Paradis', 25000.00, 1, 25000.00, '2025-09-29 07:19:13'),
(11, 6, 1, 'Elegant Evening Dress', 20000.00, 1, 20000.00, '2025-09-29 11:21:47'),
(12, 6, 2, 'Casual Summer Dress', 15000.00, 1, 15000.00, '2025-09-29 11:21:48'),
(13, 7, 1, 'Elegant Evening Dress', 20000.00, 1, 20000.00, '2025-09-29 22:14:36');

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

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

CREATE TABLE `products` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` longtext DEFAULT NULL,
  `short_description` text DEFAULT NULL,
  `price` decimal(10,2) NOT NULL,
  `sale_price` decimal(10,2) DEFAULT NULL,
  `sku` varchar(100) DEFAULT NULL,
  `stock_quantity` int(11) DEFAULT 0,
  `category_id` int(11) DEFAULT NULL,
  `images` text DEFAULT NULL,
  `featured_image` varchar(255) DEFAULT NULL,
  `is_featured` tinyint(1) DEFAULT 0,
  `is_active` tinyint(1) DEFAULT 1,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `name`, `slug`, `description`, `short_description`, `price`, `sale_price`, `sku`, `stock_quantity`, `category_id`, `images`, `featured_image`, `is_featured`, `is_active`, `meta_title`, `meta_description`, `created_at`, `updated_at`) VALUES
(1, 'Elegant Evening Dress', 'elegant-evening-dress', 'A stunning evening dress perfect for special occasions. Made from high-quality fabric with exquisite detailing.', 'Stunning evening dress for special occasions', 25000.00, 20000.00, 'EED001', 2, 1, NULL, 'products/68d7b9972b610_1758968215.webp', 1, 1, NULL, NULL, '2025-09-26 10:35:20', '2025-09-29 22:14:36'),
(2, 'Casual Summer Dress', 'casual-summer-dress', 'Light and comfortable summer dress perfect for casual outings. Available in multiple colors.', 'Light and comfortable summer dress', 15000.00, NULL, 'CSD001', 22, 1, NULL, NULL, 1, 1, NULL, NULL, '2025-09-26 10:35:20', '2025-09-29 11:21:48'),
(3, 'Designer Handbag', 'designer-handbag', 'Premium quality leather handbag with modern design. Perfect for both casual and formal occasions.', 'Premium quality leather handbag', 18000.00, 15000.00, 'DHB001', 15, 3, NULL, NULL, 1, 1, NULL, NULL, '2025-09-26 10:35:20', '2025-09-26 10:35:20'),
(4, 'Stiletto Heels', 'stiletto-heels', 'Elegant stiletto heels that add sophistication to any outfit. Comfortable and stylish.', 'Elegant stiletto heels', 12000.00, NULL, 'SH001', 20, 2, NULL, NULL, 0, 1, NULL, NULL, '2025-09-26 10:35:20', '2025-09-26 10:35:20'),
(5, 'Fashion Jewelry Set', 'fashion-jewelry-set', 'Complete jewelry set including necklace, earrings, and bracelet. Perfect for gifting.', 'Complete fashion jewelry set', 8000.00, 6000.00, 'FJS001', 29, 4, NULL, NULL, 1, 1, NULL, NULL, '2025-09-26 10:35:20', '2025-09-27 21:47:31'),
(6, 'Amour Au Paradis', 'amour-au-paradis', '. These mists are described as being inspired by sunshine and good vibes, with each scent designed to be a ticket to everyday indulgence and a tropical getaway.', 'Amour au Paradis&amp;quot; refers to a line of four body mists by a brand called Amour au Paradis, exclusive to The Perfume Shop', 26000.00, 25000.00, '123', 0, 6, NULL, 'products/68d7dd7a5eaf3_1758977402.webp', 1, 1, NULL, NULL, '2025-09-27 12:49:08', '2025-09-29 07:19:13');

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

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `price` decimal(10,2) NOT NULL,
  `duration` int(11) DEFAULT 60,
  `is_active` tinyint(1) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`id`, `name`, `description`, `price`, `duration`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'microbladding', 'One-on-one styling session to help you discover your perfect look', 15000.00, 120, 1, '2025-09-26 10:35:20', '2025-09-29 11:29:45'),
(2, 'makeup', 'Complete wardrobe analysis and makeover service', 35000.00, 240, 1, '2025-09-26 10:35:20', '2025-09-27 11:16:22'),
(3, 'lash extensions', 'Styling service for weddings, parties, and special events', 25000.00, 180, 1, '2025-09-26 10:35:20', '2025-09-29 11:30:29'),
(4, 'Fashion Photography Session', 'Professional fashion photoshoot with styling included', 45000.00, 180, 1, '2025-09-26 10:35:20', '2025-09-26 10:35:20');

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `setting_key` varchar(100) NOT NULL,
  `setting_value` longtext DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `setting_key`, `setting_value`, `created_at`, `updated_at`) VALUES
(1, 'site_title', 'Everything Angel\'s', '2025-09-26 10:35:20', '2025-09-29 22:08:50'),
(2, 'site_description', 'Angel’s closet looking good is our priority', '2025-09-26 10:35:20', '2025-09-26 20:58:52'),
(3, 'currency_symbol', '₦', '2025-09-26 10:35:20', '2025-09-26 10:35:20'),
(4, 'currency_code', 'NGN', '2025-09-26 10:35:20', '2025-09-26 10:35:20'),
(5, 'admin_email', 'Angelalawrence9060@gmail.com', '2025-09-26 10:35:20', '2025-09-29 11:18:23'),
(6, 'notification_phone', '09073299804', '2025-09-26 10:35:20', '2025-09-26 20:58:52'),
(7, 'smtp_host', 'smtp.gmail.com', '2025-09-26 10:35:20', '2025-09-26 10:35:20'),
(8, 'smtp_port', '587', '2025-09-26 10:35:20', '2025-09-26 10:35:20'),
(9, 'smtp_username', '', '2025-09-26 10:35:20', '2025-09-26 10:35:20'),
(10, 'smtp_password', '', '2025-09-26 10:35:20', '2025-09-26 10:35:20'),
(11, 'smtp_encryption', 'tls', '2025-09-26 10:35:20', '2025-09-26 10:35:20'),
(12, 'company_address', 'Shop B10 the rich plaza beside PDP junction Otio tio express and shop 11 opposite Kilimanjaro ekeki, yenagoa, bayelsa state.', '2025-09-26 10:35:20', '2025-09-26 20:58:52'),
(13, 'company_phone', '09130356003', '2025-09-26 10:35:20', '2025-09-26 20:58:52'),
(14, 'company_email', 'Angelalawrence9060@gmail.com', '2025-09-26 10:35:20', '2025-09-26 20:58:52'),
(15, 'facebook_url', 'https://facebook.com/angelscloset', '2025-09-26 10:35:20', '2025-09-26 10:35:20'),
(16, 'instagram_url', 'https://instagram.com/angelscloset', '2025-09-26 10:35:20', '2025-09-26 10:35:20'),
(17, 'twitter_url', 'https://twitter.com/angelscloset', '2025-09-26 10:35:20', '2025-09-26 10:35:20'),
(18, 'whatsapp_number', '+2348123456789', '2025-09-26 10:35:20', '2025-09-26 10:35:20'),
(37, 'twilio_account_sid', '', '2025-09-26 20:58:53', '2025-09-26 20:58:53'),
(38, 'twilio_auth_token', '', '2025-09-26 20:58:53', '2025-09-26 20:58:53'),
(39, 'twilio_phone_number', '', '2025-09-26 20:58:53', '2025-09-26 20:58:53'),
(40, 'termii_api_key', '', '2025-09-26 20:58:53', '2025-09-26 20:58:53'),
(41, 'termii_sender_id', 'N-Alert', '2025-09-26 20:58:53', '2025-09-26 20:58:53'),
(42, 'whatsapp_access_token', '', '2025-09-26 20:58:53', '2025-09-26 20:58:53'),
(43, 'whatsapp_phone_number_id', '', '2025-09-26 20:58:53', '2025-09-26 20:58:53'),
(119, 'site_logo', 'settings/68da627f4e1c2_1759142527.webp', '2025-09-27 10:14:58', '2025-09-29 10:42:07'),
(297, 'company_logo', 'logo_1759182972.jpeg', '2025-09-29 21:55:51', '2025-09-29 21:56:12');

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

--
-- Table structure for table `wishlist`
--

CREATE TABLE `wishlist` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `activity_log`
--
ALTER TABLE `activity_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_type_id` (`user_type`,`user_id`);

--
-- Indexes for table `blog_posts`
--
ALTER TABLE `blog_posts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slug` (`slug`),
  ADD KEY `author_id` (`author_id`);

--
-- Indexes for table `bookings`
--
ALTER TABLE `bookings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `booking_number` (`booking_number`),
  ADD KEY `service_id` (`service_id`);

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

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

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

--
-- Indexes for table `order_items`
--
ALTER TABLE `order_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_id` (`order_id`),
  ADD KEY `product_id` (`product_id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slug` (`slug`),
  ADD KEY `category_id` (`category_id`);

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

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `setting_key` (`setting_key`);

--
-- Indexes for table `wishlist`
--
ALTER TABLE `wishlist`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `user_product` (`user_id`,`product_id`),
  ADD KEY `product_id` (`product_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `wishlist`
--
ALTER TABLE `wishlist`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `blog_posts`
--
ALTER TABLE `blog_posts`
  ADD CONSTRAINT `blog_posts_ibfk_1` FOREIGN KEY (`author_id`) REFERENCES `admins` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `bookings`
--
ALTER TABLE `bookings`
  ADD CONSTRAINT `bookings_ibfk_1` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `orders_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `order_items`
--
ALTER TABLE `order_items`
  ADD CONSTRAINT `order_items_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `order_items_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `wishlist`
--
ALTER TABLE `wishlist`
  ADD CONSTRAINT `wishlist_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `wishlist_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;
COMMIT;

