16 lines
660 B
SQL
16 lines
660 B
SQL
CREATE TABLE IF NOT EXISTS ratings (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
branch_id INT NULL,
|
|
company_id INT NULL,
|
|
rating_type ENUM('staff', 'service') NOT NULL,
|
|
rating_value INT NOT NULL,
|
|
comment TEXT,
|
|
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
|
|
FOREIGN KEY (branch_id) REFERENCES branches(id) ON DELETE SET NULL,
|
|
FOREIGN KEY (company_id) REFERENCES companies(id) ON DELETE SET NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
INSERT IGNORE INTO user_permissions (user_id, page, can_view, can_add, can_edit, can_delete)
|
|
SELECT id, 'ratings.php', 1, 1, 1, 1
|
|
FROM users WHERE role = 'super_admin';
|