SQLize | PHPize | SQLtest

-- Thêm bảng projects CREATE TABLE projects ( id INT PRIMARY KEY, name NVARCHAR(50) NOT NULL, start_date DATE NOT NULL, end_date DATE NULL, budget DECIMAL(10, 2) NOT NULL ); INSERT INTO projects (id, name, start_date, end_date, budget) VALUES (1, N'Website Relaunch', '2025-01-10', '2025-06-30', 50000.00), (2, N'Mobile App Development', '2025-03-01', NULL, 75000.00), (3, N'Marketing Campaign', '2025-02-15', '2025-05-15', 25000.00), (4, N'Internal Database', '2025-04-20', NULL, 120000.00); -- Thêm bảng project_assignments CREATE TABLE project_assignments ( employee_id INT, project_id INT, assigned_hours INT, PRIMARY KEY (employee_id, project_id), FOREIGN KEY (employee_id) REFERENCES employees(id), FOREIGN KEY (project_id) REFERENCES projects(id) ); INSERT INTO project_assignments (employee_id, project_id, assigned_hours) VALUES (1, 1, 80), -- Alice làm dự án 1 (1, 3, 40), -- Alice làm dự án 3 (2, 1, 120), -- Bob làm dự án 1 (3, 2, 160), -- Charlie làm dự án 2 (4, 3, 100), -- David làm dự án 3 (5, 4, 200); -- Eve làm dự án 4 ; show status like 'Last_query_cost';