ヤミRoot VoidGate

User / IP	: 216.73.216.219
Host / Server	: 147.79.79.61 / www.jigishaelectronics.com
System	: Linux us-bos-web1572.main-hosting.eu 5.14.0-611.38.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Mar 10 17:21:28 EDT 2026 x86_64

: /home/u852776893/domains/jigishaelectronics.com/public_html/sqlupdates/

Viewing: v612.sql

CREATE TABLE `product_queries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `customer_id` int(11) NOT NULL,
  `seller_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `question` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `reply` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

ALTER TABLE `product_queries`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `product_queries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;


UPDATE `business_settings` SET `value` = '6.1.2' WHERE `business_settings`.`type` = 'current_version';

COMMIT;