ヤミRoot VoidGate

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

ALTER TABLE `notes` 
ADD `user_id` INT NOT NULL AFTER `id`,
ADD `seller_access` TINYINT NOT NULL DEFAULT '0' COMMENT 'Seller can access admin note;\r\n0 = No\r\n1 = Yes' AFTER `description`;

UPDATE notes
SET user_id = (
    SELECT id 
    FROM users 
    WHERE user_type = 'admin'
    LIMIT 1
);

ALTER TABLE `orders` ADD `delivered_date` TIMESTAMP NULL AFTER `notified`;

ALTER TABLE `personal_access_tokens` ADD `expires_at` TIMESTAMP NULL AFTER `last_used_at`;

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

COMMIT;