ヤミRoot VoidGate

User / IP	: 216.73.216.82
Host / Server	: 84.32.84.157 / 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: v28.sql

ALTER TABLE `order_details` ADD `product_referral_code` VARCHAR(255) NULL DEFAULT NULL AFTER `pickup_point_id`;

ALTER TABLE `categories` ADD `digital` INT(1) NOT NULL DEFAULT '0' AFTER `top`;

ALTER TABLE `products` ADD `digital` INT(1) NOT NULL DEFAULT '0' AFTER `barcode`, ADD `file_name` VARCHAR(255) NULL DEFAULT NULL AFTER `digital`, ADD `file_path` VARCHAR(255) NULL DEFAULT NULL AFTER `file_name`;

INSERT INTO `business_settings` (`id`, `type`, `value`, `created_at`, `updated_at`) VALUES (NULL, 'pos_activation_for_seller', '1', current_timestamp(), current_timestamp());

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

COMMIT;