SQLQuery for inserting data.sql

INSERT INTO Admin (AdminID, Username, Password)
VALUES
(1, 'nimal.admin', 'admin123'),
(2, 'sajith.admin', 'admin234'),
(3, 'thilina.admin', 'admin345'),
(4, 'sachini.admin', 'admin456'),
(5, 'dilshan.admin', 'admin567'),
(6, 'bimal.admin', 'admin678'),
(7, 'gayan.admin', 'admin789'),
(8, 'pavithra.admin', 'admin890'),
(9, 'lakshika.admin', 'admin901'),
(10, 'samadhi.admin', 'admin012');


INSERT INTO Users (UserID, Username, Password, FName, LName, Location)
VALUES
(1, 'kamal123', 'pass123', 'Kamal', 'Perera', 'Colombo'),
(2, 'sandaruwan', 'pass234', 'Sandaruwan', 'Fernando', 'Kandy'),
(3, 'nethmi.k', 'pass345', 'Nethmi', 'Karunaratne', 'Galle'),
(4, 'janith.d', 'pass456', 'Janith', 'Dissanayake', 'Kurunegala'),
(5, 'tharushi.r', 'pass567', 'Tharushi', 'Rajapaksha', 'Matara'),
(6, 'pasan.k', 'pass678', 'Pasan', 'Kumara', 'Jaffna'),
(7, 'ishani.s', 'pass789', 'Ishani', 'Silva', 'Trincomalee'),
(8, 'danushka.j', 'pass890', 'Danushka', 'Jayawardena', 'Badulla'),
(9, 'malsha.n', 'pass901', 'Malsha', 'Nawaratne', 'Ampara'),
(10, 'shehan.l', 'pass012', 'Shehan', 'Lakmal', 'Hambantota');


INSERT INTO UserContact (UserID, ContactNo)
VALUES
(1, '0771111111'),
(2, '0772222222'),
(3, '0773333333'),
(4, '0774444444'),
(5, '0775555555'),
(6, '0776666666'),
(7, '0777777777'),
(8, '0778888888'),
(9, '0779999999'),
(10, '0770000000').


INSERT INTO Photographer (PhotographerID, AdminID, Username, Password, FName, LName, Location)
VALUES
(1, 1, 'lakshan.p', 'photo123', 'Lakshan', 'Perera', 'Negombo'),
(2, 2, 'dilani.s', 'photo234', 'Dilani', 'Samarasinghe', 'Gampaha'),
(3, 3, 'kasun.j', 'photo345', 'Kasun', 'Jayasinghe', 'Kalutara'),
(4, 4, 'ishara.w', 'photo456', 'Ishara', 'Wijesinghe', 'Anuradhapura'),
(5, 5, 'amaya.k', 'photo567', 'Amaya', 'Kumari', 'Badulla'),
(6, 6, 'thilina.r', 'photo678', 'Thilina', 'Rathnayake', 'Polonnaruwa'),
(7, 7, 'madushani.t', 'photo789', 'Madushani', 'Tharuka', 'Ratnapura'),
(8, 8, 'vimukthi.s', 'photo890', 'Vimukthi', 'Senanayake', 'Monaragala'),
(9, 9, 'ravindu.a', 'photo901', 'Ravindu', 'Abeywickrama', 'Vavuniya'),
(10, 10, 'isuru.h', 'photo012', 'Isuru', 'Herath', 'Nuwara Eliya');


INSERT INTO PhotographerContact (PhotographerID, ContactNo)
VALUES
(1, '0711111111'),
(2, '0712222222'),
(3, '0713333333'),
(4, '0714444444'),
(5, '0715555555'),
(6, '0716666666'),
(7, '0717777777'),
(8, '0718888888'),
(9, '0719999999'),
(10, '0710000000');


INSERT INTO PhotographerCategories (PhotographerID, CategoryName)
VALUES
(1, 'Wedding'),
(2, 'Birthday'),
(3, 'Fashion'),
(4, 'Nature'),
(5, 'Corporate'),
(6, 'Travel'),
(7, 'Newborn'),
(8, 'Cultural'),
(9, 'Event'),
(10, 'Engagement');


INSERT INTO Portfolio (PhotographerID, Ratings, About, SocialMediaLinks)
VALUES
(1, 4.5, 'Experienced wedding photographer.', 'facebook.com/lakshanphoto'),
(2, 4.2, 'Birthday shoots expert.', 'instagram.com/dilanis'),
(3, 4.8, 'Fashion shoot perfectionist.', 'linkedin.com/kasunphotos'),
(4, 4.0, 'Lover of nature photography.', 'instagram.com/isharaw'),
(5, 4.6, 'Creative corporate portfolios.', 'facebook.com/amayak'),
(6, 4.1, 'Travel and exploration visuals.', 'instagram.com/thilinar'),
(7, 4.3, 'Captures newborn memories.', 'facebook.com/madushanit'),
(8, 4.7, 'Cultural stories in frames.', 'youtube.com/vimukthis'),
(9, 4.0, 'Event shoot specialist.', 'instagram.com/ravindua'),
(10, 4.9, 'Engagement elegance.', 'facebook.com/isuruh');


INSERT INTO Review (PhotographerID, UserID, AdminID, Comment, ReviewDate)
VALUES
(1, 1, 1, 'Amazing wedding shots!', '2024-12-01'),
(2, 2, 2, 'Fun and vibrant photos.', '2025-01-10'),
(3, 3, 3, 'Professional and sharp.', '2025-01-20'),
(4, 4, 4, 'Loved the nature shots.', '2025-02-01'),
(5, 5, 5, 'Very creative edits.', '2025-02-10'),
(6, 6, 6, 'Good storytelling style.', '2025-03-01'),
(7, 7, 7, 'Excellent baby photos.', '2025-03-15'),
(8, 8, 8, 'Impressive cultural moments.', '2025-04-01'),
(9, 9, 9, 'Captured the energy well.', '2025-04-10'),
(10, 10, 10, 'So romantic and dreamy.', '2025-04-20');