RelationalDesign: polnenje.sql

INSERT INTO User (email, password) VALUES
('john.doe@example.com', '5f4dcc3b5aa765d61d8327deb882cf99'),
('jane.smith@example.com', '7c6a180b36896a0a8c02787eeafb0e4c'),
('michael.jones@example.com', 'e99a18c428cb38d5f260853678922e03'),
('lisa.brown@example.com', '25f9e794323b453885f5181f1b624d0b');

INSERT INTO Project (project_id, name, user_email) VALUES
(1, 'Website Development', 'john.doe@example.com'),
(2, 'Mobile App Launch', 'jane.smith@example.com'),
(3, 'Marketing Campaign', 'michael.jones@example.com'),
(4, 'Product Research', 'lisa.brown@example.com');

INSERT INTO Task (task_id, name, tag, completion_percentage, description, project_id, user_email) VALUES
(1, 'Create local repository', 'Setup', 20, 'Initialize a local Git repository for the project.', 1, 'john.doe@example.com'),
(2, 'Design UI/UX', 'Design', 40, 'Create wireframes and mockups for the app interface.', 2, 'jane.smith@example.com'),
(3, 'Social Media Strategy', 'Marketing', 30, 'Develop a strategy for promoting the project on social media platforms.', 3, 'michael.jones@example.com'),
(4, 'Competitor Analysis', 'Research', 50, 'Analyze the strengths and weaknesses of competitors in the market.', 4, 'lisa.brown@example.com'),
(5, 'Implement Authentication', 'Development', 60, 'Develop a secure authentication system for the website.', 1, 'john.doe@example.com'),
(6, 'Beta Testing', 'Testing', 70, 'Conduct beta testing with a select group of users to gather feedback.', 2, 'jane.smith@example.com'),
(7, 'Refine UI/UX', 'Design', 45, 'Make adjustments to the user interface based on feedback.', 2, 'jane.smith@example.com'),
(8, 'Create Style Guide', 'Design', 30, 'Develop a comprehensive style guide for the project.', 1, 'john.doe@example.com');

INSERT INTO Category (category_id, name, task_id) VALUES
(1, 'Development', 1),
(2, 'Design', 2),
(3, 'Marketing', 3),
(4, 'Research', 4),
(5, 'Security', 5),
(6, 'Quality Assurance', 6),
(7, 'Design', 7),
(8, 'Design', 8);

INSERT INTO Reminder (reminder_id, date_and_time, task_id) VALUES
(1, '2024-02-16 10:00:00', 1),
(2, '2024-02-17 15:00:00', 2),
(3, '2024-03-01 09:00:00', 3),
(4, '2024-03-05 14:30:00', 4),
(5, '2024-03-10 11:00:00', 5),
(6, '2024-03-15 16:00:00', 6),
(7, '2024-03-20 13:00:00', 7),
(8, '2024-03-25 10:30:00', 8);