[encoded data, 224269 characters]\"></p>','HONOR Pad 9 8GB 256GB 12.1\" Tablet + Klavyeli Kılıf (Honor Türkiye Garantili)');

--
-- Table structure for table `product_license_keys`
--

CREATE TABLE `product_license_keys` (
  `id` int NOT NULL AUTO_INCREMENT,
  `product_id` int DEFAULT NULL,
  `license_key` varchar(500) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `is_used` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_product_id` (`product_id`),
  KEY `idx_is_used` (`is_used`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `product_license_keys`
--


--
-- Table structure for table `product_search_indexes`
--

CREATE TABLE `product_search_indexes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `product_id` int DEFAULT NULL,
  `lang_id` int DEFAULT NULL,
  `search_index` varchar(1000) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_product_id` (`product_id`),
  KEY `idx_lang_id` (`lang_id`),
  FULLTEXT KEY `search_index` (`search_index`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `product_search_indexes`
--

INSERT INTO `product_search_indexes` VALUES (1,1,1,'deneme urun alitek H1G2KQN1F7'),(2,2,3,'xiaomi H1HHXY2Q2'),(3,2,1,'xiaomi H1HHXY2Q2'),(4,3,1,'iphone 16 pro 128 gb H1HH1A2H1A3'),(5,3,3,'iphone 16 pro 128 gb H1HH1A2H1A3'),(6,4,3,'msi thin 15 b12ucx 2634xtr intel core i5 12450h 8gb 512gb ssd rtx2050 freedos 15.6 taşınabilir bilgisayar'),(7,5,3,'msi thin 15 b12ucx 2634xtr intel core i5 12450h 8gb 512gb ssd rtx2050 freedos 15.6 taşınabilir bilgisayar H1HL2N1V78'),(8,6,3,'kumtel siyah cam dijital dokunmatik ankastre set 8 programlı ko 40 tahdf ocak b66 sf2 ddt fırın da6 835 davlumbaz fır H1HM4668'),(9,7,3,'kumtel 4l beyaz mini buzdolabı hmfr 01'),(10,8,3,'tecno camon 40 pro 5g 256 gb 12 ram türkiye garantili buz beyazı H1HP2P02E1'),(11,9,3,'msi mb pro b650 s wifi am5 ddr5 7200mhzoc hdmi dp m.2 usb3.2 2.5g lan wi fi 6e atx H1HQ02F292'),(12,10,3,'honor pad 9 8gb 256gb 12.1 tablet klavyeli kılıf türkiye garantili H1HQ5F2K2');

--
-- Table structure for table `product_settings`
--

CREATE TABLE `product_settings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `marketplace_sku` tinyint(1) DEFAULT '1',
  `marketplace_variations` tinyint(1) DEFAULT '1',
  `marketplace_shipping` tinyint(1) DEFAULT '1',
  `marketplace_product_location` tinyint(1) DEFAULT '1',
  `classified_price` tinyint(1) DEFAULT '1',
  `classified_price_required` tinyint(1) DEFAULT '1',
  `classified_product_location` tinyint(1) DEFAULT '1',
  `classified_external_link` tinyint(1) DEFAULT '1',
  `physical_demo_url` tinyint(1) DEFAULT '0',
  `physical_video_preview` tinyint(1) DEFAULT '1',
  `physical_audio_preview` tinyint(1) DEFAULT '1',
  `digital_demo_url` tinyint(1) DEFAULT '1',
  `digital_video_preview` tinyint(1) DEFAULT '1',
  `digital_audio_preview` tinyint(1) DEFAULT '1',
  `digital_external_link` tinyint(1) DEFAULT '1',
  `digital_allowed_file_extensions` varchar(500) COLLATE utf8mb4_general_ci DEFAULT 'zip',
  `is_product_image_required` tinyint(1) DEFAULT '1',
  `image_file_format` varchar(30) COLLATE utf8mb4_general_ci DEFAULT 'JPG',
  `product_image_limit` smallint DEFAULT '20',
  `brand_status` tinyint(1) DEFAULT '0',
  `is_brand_optional` tinyint(1) DEFAULT '1',
  `brand_where_to_display` tinyint DEFAULT '2',
  `max_file_size_image` bigint DEFAULT '10485760',
  `max_file_size_video` bigint DEFAULT '31457280',
  `max_file_size_audio` bigint DEFAULT '10485760',
  `sitemap_frequency` varchar(30) COLLATE utf8mb4_general_ci DEFAULT 'monthly',
  `sitemap_last_modification` varchar(30) COLLATE utf8mb4_general_ci DEFAULT 'server_response',
  `sitemap_priority` varchar(30) COLLATE utf8mb4_general_ci DEFAULT 'automatically',
  `pagination_per_page` smallint DEFAULT '60',
  `sort_by_featured_products` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `product_settings`
--

INSERT INTO `product_settings` VALUES (1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,'\"zip\"',1,'JPG',20,1,1,1,10485760,31457280,10485760,'daily','server_response','automatically',60,1);

--
-- Table structure for table `product_tags`
--

CREATE TABLE `product_tags` (
  `id` int NOT NULL AUTO_INCREMENT,
  `tag` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `product_id` int DEFAULT NULL,
  `lang_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_tag` (`tag`),
  KEY `idx_product_id` (`product_id`),
  KEY `idx_lang_id` (`lang_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `product_tags`
--

INSERT INTO `product_tags` VALUES (1,'urun',1,1),(2,'alitek',1,1),(3,'deneme',1,1),(4,'iphone 16 pro 128 gb',3,3),(5,'kumtel siyah cam dijital  dokunmatik ankastre set - 8 programlı ko-40 tahdf ocak b66 - sf2 ddt fır',6,3),(6,'kumtel 4l beyaz mini buzdolabı hmfr-01',7,3),(7,'tecno camon 40 pro 5g 256 gb 12 gb ram tecno türkiye garantili buz beyazı',8,3),(8,'msi mb pro b650-s wifi am5 ddr5 7200mhzoc hdmi dp m.2 usb3.2 2.5g lan wi-fi 6e atx',9,3);

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

CREATE TABLE `products` (
  `id` int NOT NULL AUTO_INCREMENT,
  `slug` varchar(500) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `product_type` varchar(20) COLLATE utf8mb4_general_ci DEFAULT 'physical',
  `listing_type` varchar(20) COLLATE utf8mb4_general_ci DEFAULT 'sell_on_site',
  `sku` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `category_id` int DEFAULT NULL,
  `price` bigint DEFAULT NULL,
  `price_discounted` bigint DEFAULT NULL,
  `currency` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `discount_rate` smallint DEFAULT '0',
  `vat_rate` double DEFAULT '0',
  `user_id` int DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `is_promoted` tinyint(1) DEFAULT '0',
  `promote_start_date` timestamp NULL DEFAULT NULL,
  `promote_end_date` timestamp NULL DEFAULT NULL,
  `promote_plan` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `promote_day` int DEFAULT NULL,
  `is_special_offer` tinyint(1) DEFAULT '0',
  `special_offer_date` timestamp NULL DEFAULT NULL,
  `visibility` tinyint(1) NOT NULL DEFAULT '1',
  `rating` varchar(50) COLLATE utf8mb4_general_ci DEFAULT '0',
  `pageviews` int DEFAULT '0',
  `demo_url` varchar(1000) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `external_link` varchar(1000) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `files_included` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `stock` int DEFAULT '1',
  `shipping_class_id` int DEFAULT NULL,
  `shipping_delivery_time_id` int DEFAULT NULL,
  `multiple_sale` tinyint(1) DEFAULT '1',
  `digital_file_download_link` varchar(500) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `country_id` int DEFAULT '0',
  `state_id` int DEFAULT '0',
  `city_id` int DEFAULT '0',
  `address` varchar(500) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `zip_code` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `brand_id` int DEFAULT '0',
  `is_sold` tinyint(1) DEFAULT '0',
  `is_deleted` tinyint(1) DEFAULT '0',
  `is_draft` tinyint(1) DEFAULT '0',
  `is_edited` tinyint(1) DEFAULT '0',
  `is_active` tinyint(1) DEFAULT '1',
  `is_free_product` tinyint(1) DEFAULT '0',
  `is_rejected` tinyint(1) DEFAULT '0',
  `reject_reason` varchar(1000) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `is_affiliate` tinyint(1) DEFAULT '0',
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_category_id` (`category_id`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_status` (`status`),
  KEY `idx_is_promoted` (`is_promoted`),
  KEY `idx_visibility` (`visibility`),
  KEY `idx_is_deleted` (`is_deleted`),
  KEY `idx_is_draft` (`is_draft`),
  KEY `idx_price` (`price`),
  KEY `idx_discount_rate` (`discount_rate`),
  KEY `idx_is_special_offer` (`is_special_offer`),
  KEY `idx_is_sold` (`is_sold`),
  KEY `idx_brand_id` (`brand_id`),
  KEY `idx_price_discounted` (`price_discounted`),
  KEY `idx_rating` (`rating`),
  KEY `idx_country_id` (`country_id`),
  KEY `idx_state_id` (`state_id`),
  KEY `idx_city_id` (`city_id`),
  KEY `idx_slug` (`slug`),
  KEY `idx_sku` (`sku`),
  KEY `idx_is_edited` (`is_edited`),
  KEY `idx_is_active` (`is_active`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `products` VALUES (1,'deneme-urun-1','physical','sell_on_site','H1G2KQN1F7',2,56000,56000,'TRY',0,0,1,1,0,NULL,NULL,'none',0,0,NULL,1,'0',181,'','',NULL,1,0,0,NULL,'',0,0,0,'','',0,0,0,0,0,1,0,0,NULL,0,'2025-07-19 11:52:53','2025-07-19 10:56:56'),(2,'xiaomi-2','physical','sell_on_site','H1HHXY2Q2',15,1700000,1700000,'TRY',0,0,3,1,0,NULL,NULL,'none',0,0,NULL,1,'0',160,'','',NULL,50,0,0,NULL,'',0,0,0,'','',0,0,0,0,0,1,0,0,NULL,0,'2025-07-22 08:37:30','2025-07-22 08:27:33'),(3,'iphone-16-pro-128-gb-3','physical','sell_on_site','H1HH1A2H1A3',15,8000000,8000000,'TRY',0,0,3,1,0,NULL,NULL,'none',0,0,NULL,1,'0',200,'','',NULL,250,0,0,NULL,'',0,0,0,'','',0,0,0,0,0,1,0,0,NULL,0,'2025-07-22 08:58:52','2025-07-22 08:57:56'),(4,'msi-thin-15-b12ucx-2634xtr-intel-core-i5-12450h-8gb-512gb-ssd-rtx2050-freedos-156-tasinabilir-bilgisayar-4','physical','sell_on_site','',13,0,0,'',0,0,1,0,0,NULL,NULL,'none',0,0,NULL,1,'0',0,'','','',1,NULL,0,1,'',0,0,0,'','',0,0,0,1,0,0,0,0,NULL,0,'2025-07-22 21:24:39','2025-07-22 21:24:28'),(5,'msi-thin-15-b12ucx-2634xtr-intel-core-i5-12450h-8gb-512gb-ssd-rtx2050-freedos-156-tasinabilir-bilgisayar-5','physical','sell_on_site','H1HL2N1V78',13,2700000,2700000,'TRY',0,0,1,1,0,NULL,NULL,'none',0,0,NULL,1,'0',343,'','',NULL,0,0,0,NULL,'',0,0,0,'','',0,0,0,0,0,1,0,0,NULL,0,'2025-07-22 21:27:15','2025-07-22 21:25:54'),(6,'kumtel-siyah-cam-dijital-dokunmatik-ankastre-set-8-programli-ko-40-tahdf-ocak-b66-sf2-ddt-firin-da6-835-davlumbaz-6','physical','sell_on_site','H1HM4668',7,1350000,1350000,'TRY',0,0,1,1,0,NULL,NULL,'none',0,0,NULL,1,'0',196,'','',NULL,500,0,0,NULL,'',0,0,0,'','',0,0,0,0,0,1,0,0,NULL,0,'2025-07-22 21:41:22','2025-07-22 21:39:58'),(7,'kumtel-4l-beyaz-mini-buzdolabi-hmfr-01-7','physical','sell_on_site','',7,300000,300000,'TRY',0,0,1,1,0,NULL,NULL,'none',0,0,NULL,1,'0',311,'','',NULL,1,0,0,NULL,'',0,0,0,'','',0,0,0,0,0,1,0,0,NULL,0,'2025-07-22 21:48:40','2025-07-22 21:48:17'),(8,'tecno-camon-40-pro-5g-256-gb-12-gb-ram-tecno-turkiye-garantili-buz-beyazi-8','physical','sell_on_site','H1HP2P02E1',15,2499900,2499900,'TRY',0,0,1,1,0,NULL,NULL,'none',0,0,NULL,1,'0',162,'','',NULL,50,0,0,NULL,'',0,0,0,'','',0,0,0,0,0,1,0,0,NULL,0,'2025-07-23 08:35:57','2025-07-23 08:34:50'),(9,'msi-mb-pro-b650-s-wifi-am5-ddr5-7200mhzoc-hdmi-dp-m2-usb32-25g-lan-wi-fi-6e-atx-9','physical','sell_on_site','H1HQ02F292',17,1050000,1050000,'TRY',0,0,1,1,0,NULL,NULL,'none',0,0,NULL,1,'0',156,'','',NULL,10,0,0,NULL,'',0,0,0,'','',0,0,0,0,0,1,0,0,NULL,0,'2025-07-23 08:42:22','2025-07-23 08:41:15'),(10,'honor-pad-9-8gb-256gb-121-tablet-klavyeli-kilif-honor-turkiye-garantili-10','physical','sell_on_site','H1HQ5F2K2',14,1160000,1160000,'TRY',0,0,1,1,0,NULL,NULL,'none',0,0,NULL,1,'0',173,'','',NULL,150,0,0,NULL,'',0,0,0,'','',0,0,0,0,0,1,0,0,NULL,0,'2025-07-23 08:49:57','2025-07-23 08:48:22');

--
-- Table structure for table `promoted_transactions`
--

CREATE TABLE `promoted_transactions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `payment_method` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `payment_id` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `product_id` int DEFAULT NULL,
  `currency` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `payment_amount` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `payment_status` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `purchased_plan` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `day_count` int DEFAULT NULL,
  `global_taxes_data` text COLLATE utf8mb4_general_ci,
  `ip_address` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `promoted_transactions`
--


--
-- Table structure for table `quote_requests`
--

CREATE TABLE `quote_requests` (
  `id` int NOT NULL AUTO_INCREMENT,
  `product_id` int DEFAULT NULL,
  `product_title` varchar(500) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `product_quantity` mediumint DEFAULT '1',
  `seller_id` int DEFAULT NULL,
  `buyer_id` int DEFAULT NULL,
  `status` varchar(20) COLLATE utf8mb4_general_ci DEFAULT 'pending',
  `price_offered` bigint DEFAULT NULL,
  `price_currency` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `is_buyer_deleted` tinyint(1) DEFAULT '0',
  `is_seller_deleted` tinyint(1) DEFAULT '0',
  `variation_option_ids` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_product_id` (`product_id`),
  KEY `idx_seller_id` (`seller_id`),
  KEY `idx_buyer_id` (`buyer_id`),
  KEY `idx_is_buyer_deleted` (`is_buyer_deleted`),
  KEY `idx_is_seller_deleted` (`is_seller_deleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `quote_requests`
--


--
-- Table structure for table `refund_requests`
--

CREATE TABLE `refund_requests` (
  `id` int NOT NULL AUTO_INCREMENT,
  `buyer_id` int DEFAULT NULL,
  `seller_id` int DEFAULT NULL,
  `order_id` int DEFAULT NULL,
  `order_number` bigint DEFAULT NULL,
  `order_product_id` int DEFAULT NULL,
  `status` tinyint(1) DEFAULT '0',
  `is_completed` tinyint(1) DEFAULT '0',
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_buyer_id` (`buyer_id`),
  KEY `idx_seller_id` (`seller_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `refund_requests`
--


--
-- Table structure for table `refund_requests_messages`
--

CREATE TABLE `refund_requests_messages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `request_id` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `is_buyer` tinyint(1) NOT NULL DEFAULT '1',
  `message` text COLLATE utf8mb4_general_ci,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `refund_requests_messages`
--


--
-- Table structure for table `reviews`
--

CREATE TABLE `reviews` (
  `id` int NOT NULL AUTO_INCREMENT,
  `product_id` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `rating` int DEFAULT NULL,
  `review` varchar(10000) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ip_address` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_product_id` (`product_id`),
  KEY `idx_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `reviews`
--


--
-- Table structure for table `roles_permissions`
--

CREATE TABLE `roles_permissions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `role_name` text COLLATE utf8mb4_general_ci,
  `permissions` text COLLATE utf8mb4_general_ci,
  `is_super_admin` tinyint(1) DEFAULT '0',
  `is_default` tinyint(1) DEFAULT '0',
  `is_admin` tinyint(1) DEFAULT '0',
  `is_vendor` tinyint(1) DEFAULT '0',
  `is_member` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `roles_permissions`
--

INSERT INTO `roles_permissions` VALUES (1,'a:1:{i:0;a:2:{s:7:\"lang_id\";s:1:\"1\";s:4:\"name\";s:11:\"Super Admin\";}}','all',1,1,1,0,0),(2,'a:1:{i:0;a:2:{s:7:\"lang_id\";s:1:\"1\";s:4:\"name\";s:6:\"Vendor\";}}','2',0,1,0,1,0),(3,'a:1:{i:0;a:2:{s:7:\"lang_id\";s:1:\"1\";s:4:\"name\";s:6:\"Member\";}}','',0,1,0,0,1);

--
-- Table structure for table `routes`
--

CREATE TABLE `routes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `route_key` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `route` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `routes`
--

INSERT INTO `routes` VALUES (1,'add_coupon','add-coupon'),(2,'add_product','add-product'),(3,'add_shipping_zone','add-shipping-zone'),(4,'admin','admin'),(5,'affiliate','affiliate'),(6,'affiliate_links','affiliate-links'),(7,'affiliate_program','affiliate-program'),(8,'blog','blog'),(9,'bulk_product_upload','bulk-product-upload'),(10,'cart','cart'),(11,'cash_on_delivery','cash-on-delivery'),(12,'category','category'),(13,'change_password','change-password'),(14,'comments','comments'),(15,'contact','contact'),(16,'coupons','coupons'),(17,'coupon_products','coupon-products'),(18,'dashboard','dashboard'),(19,'delete_account','delete-account'),(20,'downloads','downloads'),(21,'earnings','earnings'),(22,'edit_coupon','edit-coupon'),(23,'edit_product','edit-product'),(24,'edit_profile','edit-profile'),(25,'edit_shipping_zone','edit-shipping-zone'),(26,'featured_products','featured-products'),(27,'followers','followers'),(28,'following','following'),(29,'forgot_password','forgot-password'),(30,'help_center','help-center'),(31,'latest_products','latest-products'),(32,'location','location'),(33,'members','members'),(34,'messages','messages'),(35,'my_coupons','my-coupons'),(36,'my_reviews','my-reviews'),(37,'orders','orders'),(38,'order_completed','order-completed'),(39,'order_details','order-details'),(40,'payment','payment'),(41,'payments','payments'),(42,'payment_method','payment-method'),(43,'product','product'),(44,'products','products'),(45,'product_details','product-details'),(46,'profile','profile'),(47,'quote_requests','quote-requests'),(48,'refund_requests','refund-requests'),(49,'register','register'),(50,'register_success','register-success'),(51,'reset_password','reset-password'),(52,'reviews','reviews'),(53,'rss_feeds','rss-feeds'),(54,'sale','sale'),(55,'sales','sales'),(56,'search','search'),(57,'select_membership_plan','select-membership-plan'),(58,'seller','seller'),(59,'service_payment_completed','service-payment-completed'),(60,'settings','settings'),(61,'shipping','shipping'),(62,'shipping_address','shipping-address'),(63,'shipping_settings','shipping-settings'),(64,'shops','shops'),(65,'shop_policies','shop-policies'),(66,'shop_settings','shop-settings'),(67,'social_media','social-media'),(68,'start_selling','start-selling'),(69,'submit_request','submit-request'),(70,'tag','tag'),(71,'terms_conditions','terms-conditions'),(72,'ticket','ticket'),(73,'tickets','tickets'),(74,'wallet','wallet'),(75,'wishlist','wishlist');

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

CREATE TABLE `settings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `lang_id` int DEFAULT '1',
  `site_font` smallint DEFAULT '19',
  `dashboard_font` smallint DEFAULT '22',
  `site_title` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `homepage_title` varchar(255) COLLATE utf8mb4_general_ci DEFAULT 'Home',
  `site_description` varchar(500) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `keywords` varchar(500) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `social_media_data` text COLLATE utf8mb4_general_ci,
  `about_footer` varchar(1000) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `contact_text` text COLLATE utf8mb4_general_ci,
  `contact_address` varchar(500) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `contact_email` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `contact_phone` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `copyright` varchar(500) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cookies_warning` tinyint(1) DEFAULT '0',
  `cookies_warning_text` text COLLATE utf8mb4_general_ci,
  `affiliate_description` text COLLATE utf8mb4_general_ci,
  `affiliate_content` longtext COLLATE utf8mb4_general_ci,
  `affiliate_faq` mediumtext COLLATE utf8mb4_general_ci,
  `affiliate_works` mediumtext COLLATE utf8mb4_general_ci,
  `bulk_upload_documentation` text COLLATE utf8mb4_general_ci,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `settings` VALUES (1,1,19,22,'Dilek Express','Home','Modesy Index Page','index, home, modesy',NULL,NULL,NULL,NULL,NULL,NULL,'Copyright 2025 Ali TEK - All Rights Reserved.',1,'<p>This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies.</p>','a:2:{s:5:\"title\";s:53:\"Boost Your Earnings with the Modesy Affiliate Program\";s:11:\"description\";s:196:\"Are you a content creator, blogger, influencer, or simply someone with a strong online presence? If so, Modesy has an exciting opportunity for you to turn your online influence into real earnings.\";}','a:2:{s:5:\"title\";s:38:\"Why Join the Modesy Affiliate Program?\";s:7:\"content\";s:1745:\"<p>Modesy, a leading e-commerce platform known for its diverse range of products and exceptional customer service, is thrilled to introduce its Affiliate Program. This program offers you a chance to earn lucrative commissions by promoting Modesy\'s products. Here’s everything you need to know about why the Modesy Affiliate Program is perfect for you.<br><br><strong>1. Attractive Commission Rates</strong><br>Modesy offers competitive commission rates that ensure you are rewarded generously for your efforts. Every time someone makes a purchase through your referral link, you earn a commission. The more you promote, the more you earn.</p>\r\n<p><strong>2. Wide Range of Products</strong><br>With Modesy’s extensive catalog, you have endless opportunities to promote products that resonate with your audience. Whether your niche is tech gadgets, fashion, beauty products, or home decor, Modesy has something for everyone.</p>\r\n<p><strong>3. Easy-to-Use Tools</strong><br>The Modesy Affiliate Program provides you with a suite of tools to make your promotional efforts seamless. From custom referral links to detailed performance reports, you’ll have everything you need to track your success and optimize your strategies.</p>\r\n<p><strong>4. Reliable Support</strong><br>Modesy values its affiliates and offers dedicated support to help you succeed. Whether you have questions about the program or need tips on how to maximize your earnings, the Modesy support team is always ready to assist you.</p>\r\n<p><strong>5. Timely Payments</strong><br>Modesy ensures that your hard-earned commissions are paid out on time. With a straightforward payout process, you can focus on what you do best – promoting great products and earning money.</p>\";}','a:8:{i:0;a:3:{s:1:\"o\";s:1:\"1\";s:1:\"q\";s:36:\"How do I join the Affiliate program?\";s:1:\"a\";s:110:\"Simply click the \"Join Now\" button and fill out the registration form. Once approved, you can start promoting!\";}i:1;a:3:{s:1:\"o\";s:1:\"2\";s:1:\"q\";s:45:\"Who can participate in the Affiliate Program?\";s:1:\"a\";s:215:\"Anyone with an online presence, including bloggers, social media influencers, website owners, and content creators, can join the affiliate program. As long as you can promote our products, you’re welcome to apply!\";}i:2;a:3:{s:1:\"o\";s:1:\"3\";s:1:\"q\";s:40:\"Where can I generate my Affiliate links?\";s:1:\"a\";s:222:\"You can generate your affiliate links directly from any product detail page on our website. Once logged in, visit the product page you want to promote, and you’ll find an option to create your affiliate link right there.\";}i:3;a:3:{s:1:\"o\";s:1:\"4\";s:1:\"q\";s:28:\"What products can I promote?\";s:1:\"a\";s:162:\"You can promote any product from our store that is included in the affiliate program and earn commission on any qualifying sales made through your affiliate link.\";}i:4;a:3:{s:1:\"o\";s:1:\"5\";s:1:\"q\";s:46:\"How long is the validity of an Affiliate link?\";s:1:\"a\";s:211:\"An affiliate link is valid for 30 days from the moment a person clicks on it and opens the product page. If the product is purchased during this period, the affiliate commission will be applied for that product.\";}i:5;a:3:{s:1:\"o\";s:1:\"6\";s:1:\"q\";s:20:\"How much can I earn?\";s:1:\"a\";s:120:\"There is no limit to how much you can earn. Your earnings depend on the sales you generate through your affiliate links.\";}i:6;a:3:{s:1:\"o\";s:1:\"7\";s:1:\"q\";s:37:\"How do I track my Affiliate earnings?\";s:1:\"a\";s:96:\"You can track your affiliate program earnings in the \"Referral Earnings\" section of your wallet.\";}i:7;a:3:{s:1:\"o\";s:1:\"8\";s:1:\"q\";s:35:\"How do I get my Affiliate earnings?\";s:1:\"a\";s:188:\"Once your earnings exceed the minimum payout limit, you can request a payment from the \"Payouts\" section of your wallet. Simply submit a payout request, and your payment will be processed.\";}}','a:3:{i:0;a:2:{s:5:\"title\";s:23:\"Sign up for the program\";s:11:\"description\";s:77:\"Join the Modesy affiliate program by completing a simple registration process\";}i:1;a:2:{s:5:\"title\";s:34:\"Create and share your referral URL\";s:11:\"description\";s:77:\"Generate a referral URL and share it on your website, email, or social media.\";}i:2;a:2:{s:5:\"title\";s:15:\"Earn commission\";s:11:\"description\";s:64:\"Earn commissions on every sale made through your affiliate links\";}}','<p>With the bulk product upload feature, you can upload your products in bulk with the help of a CSV file.<br><br>Bulk upload has options to add new products and edit existing products:<br><br><strong>Add Products: </strong>To add new products, download the CSV template, add your products to this CSV file and upload it from this section. You can see detailed explanations of all required or optional columns in the table below. When adding your data, you need to pay attention to the data type of these columns.<br><br><strong>Edit Products: </strong> To edit products, you need to add an \"id\" column to the CSV template. You can see the ID numbers of your products on the \"products\" page. After adding the \"id\" column, you need to add the column names you want to edit. <br>For example, if you want to update the stock and prices of your products, your CSV template should be like this:<br><span style=\"color: rgb(35, 111, 161);\">\"id\",\"price\",\"price_discounted\",\"stock\"</span><br><br>Example:<br><span style=\"color: rgb(35, 111, 161);\">\"id\",\"price\",\"price_discounted\",\"stock\"</span><br><span style=\"color: rgb(132, 63, 161);\">\"1\",\"30\",\"20\",\"1000\"</span><br><span style=\"color: rgb(132, 63, 161);\">\"5\",\"40\",\"40\",\"500\"</span><br><br><span style=\"color: rgb(186, 55, 42);\">* To update the product price, you need to add both \"price\" and \"price_discounted\" columns to your CSV file.<br><br><br></span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>CSV Columns</strong></span></p>\r\n<table style=\"width: 100%;\" class=\"table table-bordered\">\r\n<tbody>\r\n<tr>\r\n<th>Column</th>\r\n<th>Description</th>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 180px;\">title</td>\r\n<td>Data Type: Text <br><strong>Required</strong><br>Example: Modern grey couch and pillows</td>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 180px;\">slug</td>\r\n<td>Data Type: Text <br><strong>Optional</strong> <small>(If you leave it empty, it will be generated automatically.)</small> <br>Example: modern-grey-couch-and-pillows</td>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 180px;\">sku</td>\r\n<td>Data Type: Text <br><strong>Optional</strong><br>Example: MD-GR-6898</td>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 180px;\">category_id</td>\r\n<td>Data Type: Number <br><strong>Required</strong><br>Example: 1</td>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 180px;\">price</td>\r\n<td>Data Type: Decimal/Number <br><strong>Required</strong><br>Example 1: 50<br>Example 2: 45.90<br>Example 3: 3456.25</td>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 180px;\">price_discounted</td>\r\n<td>Data Type: Decimal/Number <br><strong>Optional</strong><br>Example 1: 40<br>Example 2: 35.90<br>Example 3: 2456.25</td>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 180px;\">vat_rate</td>\r\n<td>Data Type: Number <br><strong>Optional</strong><br>Example: 8</td>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 180px;\">stock</td>\r\n<td>Data Type: Number <br><strong>Required</strong><br>Example: 100</td>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 180px;\">short_description</td>\r\n<td>Data Type: Text <br><strong>Optional</strong><br>Example: It is a nice and comfortable couch</td>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 180px;\">description</td>\r\n<td>Data Type: Text <br><strong>Optional</strong><br>Example: It is a nice and comfortable couch...</td>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 180px;\">tags</td>\r\n<td>Data Type: Text <br><strong>Optional</strong><br>Example: nice, comfortable, couch</td>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 180px;\">image_url</td>\r\n<td>Data Type: Text <br><strong>Optional</strong><br>Example 1:<br>https://upload.wikimedia.org/wikipedia/commons/7/70/Labrador-sea-paamiut.jpg<br><br>Example 2:<br>https://upload.wikimedia.org/wikipedia/commons/7/70/Labrador-sea-paamiut.jpg,<br>https://upload.wikimedia.org/wikipedia/commons/thumb/4/42/Shaqi_jrvej.jpg/1600px-Shaqi_jrvej.jpg<br><br><span style=\"color: rgb(186, 55, 42);\">*You can add multiple image links by placing commas between them.</span></td>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 180px;\">external_link</td>\r\n<td>Data Type: Text <br><strong>Optional</strong><br>Example: https://domain.com/product_url</td>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 180px;\">updated_at</td>\r\n<td>Data Type: Timestamp <br><strong>Optional</strong><br>Example: 2024-06-30 10:27:00 <br><br><span style=\"color: rgb(186, 55, 42);\">*If you leave it blank, the system will not assign an update date.</span></td>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 180px;\">created_at</td>\r\n<td>Data Type: Timestamp <br><strong>Optional</strong><br>Example: 2024-06-30 10:27:00 <br><br><span style=\"color: rgb(186, 55, 42);\">*If you leave it blank, the system will automatically assign the current date.</span></td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<p><br><br><br><br><br></p>','2021-02-20 19:51:50'),(3,3,19,22,'Pazar11','Ana Sayfa','Pazar11','index, anasayfa, pazar11','','<p>TÜM HAKLARI SAKLIDIR </p>','','','','','Copyright 2025 Pazar11.com- All Rights Reserved.',1,'<p>This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies.</p>','a:2:{s:5:\"title\";s:53:\"Boost Your Earnings with the Modesy Affiliate Program\";s:11:\"description\";s:196:\"Are you a content creator, blogger, influencer, or simply someone with a strong online presence? If so, Modesy has an exciting opportunity for you to turn your online influence into real earnings.\";}','a:2:{s:5:\"title\";s:38:\"Why Join the Modesy Affiliate Program?\";s:7:\"content\";s:1745:\"<p>Modesy, a leading e-commerce platform known for its diverse range of products and exceptional customer service, is thrilled to introduce its Affiliate Program. This program offers you a chance to earn lucrative commissions by promoting Modesy\'s products. Here’s everything you need to know about why the Modesy Affiliate Program is perfect for you.<br><br><strong>1. Attractive Commission Rates</strong><br>Modesy offers competitive commission rates that ensure you are rewarded generously for your efforts. Every time someone makes a purchase through your referral link, you earn a commission. The more you promote, the more you earn.</p>\r\n<p><strong>2. Wide Range of Products</strong><br>With Modesy’s extensive catalog, you have endless opportunities to promote products that resonate with your audience. Whether your niche is tech gadgets, fashion, beauty products, or home decor, Modesy has something for everyone.</p>\r\n<p><strong>3. Easy-to-Use Tools</strong><br>The Modesy Affiliate Program provides you with a suite of tools to make your promotional efforts seamless. From custom referral links to detailed performance reports, you’ll have everything you need to track your success and optimize your strategies.</p>\r\n<p><strong>4. Reliable Support</strong><br>Modesy values its affiliates and offers dedicated support to help you succeed. Whether you have questions about the program or need tips on how to maximize your earnings, the Modesy support team is always ready to assist you.</p>\r\n<p><strong>5. Timely Payments</strong><br>Modesy ensures that your hard-earned commissions are paid out on time. With a straightforward payout process, you can focus on what you do best – promoting great products and earning money.</p>\";}','a:8:{i:0;a:3:{s:1:\"o\";s:1:\"1\";s:1:\"q\";s:36:\"How do I join the Affiliate program?\";s:1:\"a\";s:110:\"Simply click the \"Join Now\" button and fill out the registration form. Once approved, you can start promoting!\";}i:1;a:3:{s:1:\"o\";s:1:\"2\";s:1:\"q\";s:45:\"Who can participate in the Affiliate Program?\";s:1:\"a\";s:215:\"Anyone with an online presence, including bloggers, social media influencers, website owners, and content creators, can join the affiliate program. As long as you can promote our products, you’re welcome to apply!\";}i:2;a:3:{s:1:\"o\";s:1:\"3\";s:1:\"q\";s:40:\"Where can I generate my Affiliate links?\";s:1:\"a\";s:222:\"You can generate your affiliate links directly from any product detail page on our website. Once logged in, visit the product page you want to promote, and you’ll find an option to create your affiliate link right there.\";}i:3;a:3:{s:1:\"o\";s:1:\"4\";s:1:\"q\";s:28:\"What products can I promote?\";s:1:\"a\";s:162:\"You can promote any product from our store that is included in the affiliate program and earn commission on any qualifying sales made through your affiliate link.\";}i:4;a:3:{s:1:\"o\";s:1:\"5\";s:1:\"q\";s:46:\"How long is the validity of an Affiliate link?\";s:1:\"a\";s:211:\"An affiliate link is valid for 30 days from the moment a person clicks on it and opens the product page. If the product is purchased during this period, the affiliate commission will be applied for that product.\";}i:5;a:3:{s:1:\"o\";s:1:\"6\";s:1:\"q\";s:20:\"How much can I earn?\";s:1:\"a\";s:120:\"There is no limit to how much you can earn. Your earnings depend on the sales you generate through your affiliate links.\";}i:6;a:3:{s:1:\"o\";s:1:\"7\";s:1:\"q\";s:37:\"How do I track my Affiliate earnings?\";s:1:\"a\";s:96:\"You can track your affiliate program earnings in the \"Referral Earnings\" section of your wallet.\";}i:7;a:3:{s:1:\"o\";s:1:\"8\";s:1:\"q\";s:35:\"How do I get my Affiliate earnings?\";s:1:\"a\";s:188:\"Once your earnings exceed the minimum payout limit, you can request a payment from the \"Payouts\" section of your wallet. Simply submit a payout request, and your payment will be processed.\";}}','a:3:{i:0;a:2:{s:5:\"title\";s:23:\"Sign up for the program\";s:11:\"description\";s:77:\"Join the Modesy affiliate program by completing a simple registration process\";}i:1;a:2:{s:5:\"title\";s:34:\"Create and share your referral URL\";s:11:\"description\";s:77:\"Generate a referral URL and share it on your website, email, or social media.\";}i:2;a:2:{s:5:\"title\";s:15:\"Earn commission\";s:11:\"description\";s:64:\"Earn commissions on every sale made through your affiliate links\";}}','<p>With the bulk product upload feature, you can upload your products in bulk with the help of a CSV file.<br><br>Bulk upload has options to add new products and edit existing products:<br><br><strong>Add Products: </strong>To add new products, download the CSV template, add your products to this CSV file and upload it from this section. You can see detailed explanations of all required or optional columns in the table below. When adding your data, you need to pay attention to the data type of these columns.<br><br><strong>Edit Products: </strong> To edit products, you need to add an \"id\" column to the CSV template. You can see the ID numbers of your products on the \"products\" page. After adding the \"id\" column, you need to add the column names you want to edit. <br>For example, if you want to update the stock and prices of your products, your CSV template should be like this:<br><span style=\"color: rgb(35, 111, 161);\">\"id\",\"price\",\"price_discounted\",\"stock\"</span><br><br>Example:<br><span style=\"color: rgb(35, 111, 161);\">\"id\",\"price\",\"price_discounted\",\"stock\"</span><br><span style=\"color: rgb(132, 63, 161);\">\"1\",\"30\",\"20\",\"1000\"</span><br><span style=\"color: rgb(132, 63, 161);\">\"5\",\"40\",\"40\",\"500\"</span><br><br><span style=\"color: rgb(186, 55, 42);\">* To update the product price, you need to add both \"price\" and \"price_discounted\" columns to your CSV file.<br><br><br></span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>CSV Columns</strong></span></p>\r\n<table style=\"width: 100%;\" class=\"table table-bordered\">\r\n<tbody>\r\n<tr>\r\n<th>Column</th>\r\n<th>Description</th>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 180px;\">title</td>\r\n<td>Data Type: Text <br><strong>Required</strong><br>Example: Modern grey couch and pillows</td>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 180px;\">slug</td>\r\n<td>Data Type: Text <br><strong>Optional</strong> <small>(If you leave it empty, it will be generated automatically.)</small> <br>Example: modern-grey-couch-and-pillows</td>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 180px;\">sku</td>\r\n<td>Data Type: Text <br><strong>Optional</strong><br>Example: MD-GR-6898</td>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 180px;\">category_id</td>\r\n<td>Data Type: Number <br><strong>Required</strong><br>Example: 1</td>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 180px;\">price</td>\r\n<td>Data Type: Decimal/Number <br><strong>Required</strong><br>Example 1: 50<br>Example 2: 45.90<br>Example 3: 3456.25</td>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 180px;\">price_discounted</td>\r\n<td>Data Type: Decimal/Number <br><strong>Optional</strong><br>Example 1: 40<br>Example 2: 35.90<br>Example 3: 2456.25</td>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 180px;\">vat_rate</td>\r\n<td>Data Type: Number <br><strong>Optional</strong><br>Example: 8</td>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 180px;\">stock</td>\r\n<td>Data Type: Number <br><strong>Required</strong><br>Example: 100</td>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 180px;\">short_description</td>\r\n<td>Data Type: Text <br><strong>Optional</strong><br>Example: It is a nice and comfortable couch</td>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 180px;\">description</td>\r\n<td>Data Type: Text <br><strong>Optional</strong><br>Example: It is a nice and comfortable couch...</td>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 180px;\">tags</td>\r\n<td>Data Type: Text <br><strong>Optional</strong><br>Example: nice, comfortable, couch</td>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 180px;\">image_url</td>\r\n<td>Data Type: Text <br><strong>Optional</strong><br>Example 1:<br>https://upload.wikimedia.org/wikipedia/commons/7/70/Labrador-sea-paamiut.jpg<br><br>Example 2:<br>https://upload.wikimedia.org/wikipedia/commons/7/70/Labrador-sea-paamiut.jpg,<br>https://upload.wikimedia.org/wikipedia/commons/thumb/4/42/Shaqi_jrvej.jpg/1600px-Shaqi_jrvej.jpg<br><br><span style=\"color: rgb(186, 55, 42);\">*You can add multiple image links by placing commas between them.</span></td>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 180px;\">external_link</td>\r\n<td>Data Type: Text <br><strong>Optional</strong><br>Example: https://domain.com/product_url</td>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 180px;\">updated_at</td>\r\n<td>Data Type: Timestamp <br><strong>Optional</strong><br>Example: 2024-06-30 10:27:00 <br><br><span style=\"color: rgb(186, 55, 42);\">*If you leave it blank, the system will not assign an update date.</span></td>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 180px;\">created_at</td>\r\n<td>Data Type: Timestamp <br><strong>Optional</strong><br>Example: 2024-06-30 10:27:00 <br><br><span style=\"color: rgb(186, 55, 42);\">*If you leave it blank, the system will automatically assign the current date.</span></td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<p><br><br><br><br><br></p>','2025-07-19 11:46:45');

--
