19 lines
917 B
SQL
19 lines
917 B
SQL
-- 1. เพิ่มคอมลัมน์ใหม่ในตาราง jobs
|
|
ALTER TABLE `jobs`
|
|
ADD COLUMN `is_scheduled` TINYINT(1) DEFAULT 0 AFTER `equipment_id`,
|
|
ADD COLUMN `scheduled_time` DATETIME DEFAULT NULL AFTER `is_scheduled`,
|
|
ADD COLUMN `infection_control` TINYINT(1) DEFAULT 0 AFTER `scheduled_time`,
|
|
ADD COLUMN `rating` INT DEFAULT NULL AFTER `completed_at`,
|
|
ADD COLUMN `feedback` TEXT DEFAULT NULL AFTER `rating`;
|
|
|
|
-- 2. สร้างตาราง job_messages (แชท)
|
|
CREATE TABLE IF NOT EXISTS `job_messages` (
|
|
`id` INT AUTO_INCREMENT PRIMARY KEY,
|
|
`job_id` INT NOT NULL,
|
|
`user_id` INT NOT NULL,
|
|
`message` TEXT NOT NULL,
|
|
`created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
|
|
FOREIGN KEY (`job_id`) REFERENCES `jobs`(`id`) ON DELETE CASCADE,
|
|
FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE CASCADE
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|