
-- Insert dummy users (admin and regular users)
INSERT INTO users (username, password, role) VALUES
('admin', '$2y$10$6QH4YoNN3T1G.NP1R7JHme3P5ntal0BdMZsIvFBVah9DGA.pP9a9O', 'admin'),  -- password: admin123
('user1', '$2y$10$6QH4YoNN3T1G.NP1R7JHme3P5ntal0BdMZsIvFBVah9DGA.pP9a9O', 'user'),  -- password: user123
('user2', '$2y$10$6QH4YoNN3T1G.NP1R7JHme3P5ntal0BdMZsIvFBVah9DGA.pP9a9O', 'user');  -- password: user123

-- Insert dummy categories
INSERT INTO categories (name) VALUES
('Technology'),
('Science'),
('Health');

-- Insert dummy articles
INSERT INTO articles (title, content, category_id) VALUES
('The Future of Technology', 'Technology is constantly evolving, and the future holds exciting possibilities...', 1),
('Advancements in Science', 'Recent advancements in science have revolutionized many fields...', 2),
('Staying Healthy in a Busy World', 'With hectic schedules, staying healthy becomes a challenge...', 3);
