-- ============================================================
--  Dev / demo seed data.  Import AFTER schema.sql.
--  All passwords are "password123" (hash generated by bcrypt).
--  Admin login:  admin@socialapp.com / admin123
--  ⚠ Delete or change these on production!
-- ============================================================
SET NAMES utf8mb4;

INSERT INTO settings (`key`,`value`) VALUES
  ('site_name','SocialApp'),
  ('registration_open','1'),
  ('require_email_verification','0'),
  ('admin_approval_required','0'),
  ('allow_video_uploads','1'),
  ('max_upload_mb','100'),
  ('enable_groups','1'),
  ('enable_dms','1'),
  ('maintenance_mode','0'),
  ('default_language','en'),
  ('supported_languages','en,ne'),
  ('primary_color','#1877f2');

INSERT INTO admins (name,email,password_hash,role,status) VALUES
  ('Super Admin','admin@socialapp.com','$2y$10$IQN17K4D0DR1HcblOOh2Ke9IBHPPH1misFVNy/nkLXA4STScVnS/K','super','active'),
  ('Rana Moderator','rana@socialapp.com','$2y$10$UvNByAPyWH.B0cnH1wH8u.7MSWcjyI/zJ44jpK6JkQZu6Tbje2/Ju','moderator','active');

INSERT INTO users (name,username,email,phone,password_hash,bio,country,city,status,email_verified_at,created_at) VALUES
  ('Ahmad Mahmoud','ahmad','ahmad@demo.com','+9779800000001','$2y$10$UvNByAPyWH.B0cnH1wH8u.7MSWcjyI/zJ44jpK6JkQZu6Tbje2/Ju','Community volunteer · Public speaking fan','Nepal','Bhaktapur','active',NOW(),'2025-02-01 10:00:00'),
  ('Sara Nasser','sara','sara@demo.com','+9779800000002','$2y$10$UvNByAPyWH.B0cnH1wH8u.7MSWcjyI/zJ44jpK6JkQZu6Tbje2/Ju','Photographer 📸','Nepal','Kathmandu','active',NOW(),'2025-01-15 10:00:00'),
  ('Khaled Omar','khaled','khaled@demo.com','+9779800000003','$2y$10$2MpM09SjHtK/BzuBPt7pyuNAVt4f/5jSQffuviJ7TvAerl.LQNucm','Video maker','Nepal','Pokhara','active',NOW(),'2025-03-10 10:00:00'),
  ('Lina Haddad','lina','lina@demo.com',NULL,'$2y$10$2MpM09SjHtK/BzuBPt7pyuNAVt4f/5jSQffuviJ7TvAerl.LQNucm',NULL,'Nepal','Lalitpur','active',NOW(),'2025-04-02 10:00:00'),
  ('Pending User','pending1','pending1@demo.com',NULL,'$2y$10$2MpM09SjHtK/BzuBPt7pyuNAVt4f/5jSQffuviJ7TvAerl.LQNucm',NULL,'Nepal','Bhaktapur','pending',NULL,'2026-10-01 10:00:00'),
  ('Spam Account','spamboi','spam@demo.com',NULL,'$2y$10$2MpM09SjHtK/BzuBPt7pyuNAVt4f/5jSQffuviJ7TvAerl.LQNucm',NULL,NULL,NULL,'banned',NULL,'2026-09-20 10:00:00');

-- friendships: Ahmad <-> Sara accepted, Lina -> Ahmad pending
INSERT INTO friendships (requester_id,receiver_id,status,created_at) VALUES
  (1,2,'accepted','2025-02-05 10:00:00'),
  (2,1,'accepted','2025-02-05 10:00:00'),
  (1,3,'accepted','2025-03-15 10:00:00'),
  (3,1,'accepted','2025-03-15 10:00:00'),
  (4,1,'pending','2026-10-08 10:00:00');

-- groups
INSERT INTO groups (id,name,slug,description,privacy,join_mode,owner_id,member_count,created_at) VALUES
  (1,'JCI Budhanilkantha Official','jci-budhanilkantha-official','Official community page — announcements and meetups.','public','open',1,3,'2025-02-10 10:00:00'),
  (2,'Photography Club Nepal','photography-club-nepal','Weekend photo walks around the valley.','public','approval',2,2,'2025-05-01 10:00:00'),
  (3,'Alumni 2024','alumni-2024','Invite only.','secret','invite',1,1,'2025-06-01 10:00:00');
INSERT INTO group_members (group_id,user_id,role,status) VALUES
  (1,1,'owner','active'),(1,2,'member','active'),(1,3,'member','active'),
  (2,2,'owner','active'),(2,1,'member','active'),
  (3,1,'owner','active');

-- posts
INSERT INTO posts (id,user_id,group_id,audience,body,created_at) VALUES
  (1,2,NULL,'public','Just uploaded the photos from yesterday''s meetup! 🎉 #community','2026-10-10 08:00:00'),
  (2,3,NULL,'public','New video coming soon 🎬 #filmmaking','2026-10-10 06:00:00'),
  (3,1,1,'group','Reminder: monthly meetup this Friday 7 PM! 📌','2026-10-09 15:00:00'),
  (4,1,NULL,'friends','Great session today 💪','2026-10-08 12:00:00'),
  (5,6,NULL,'public','🔥 CHEAP FOLLOWERS click this link → bit.ly/xxx','2026-10-10 09:00:00');
INSERT INTO post_media (post_id,type,path,order_no) VALUES
  (1,'image','posts/2026/10/meetup1.jpg',0),
  (1,'image','posts/2026/10/meetup2.jpg',1);
INSERT INTO post_likes (post_id,user_id,reaction) VALUES (1,1,'love'),(1,3,'like'),(3,2,'like');
INSERT INTO post_comments (post_id,user_id,body,created_at) VALUES
  (1,1,'The second one 🔥','2026-10-10 08:30:00'),
  (1,3,'Missed it 😢 next time!','2026-10-10 09:00:00');
INSERT INTO post_shares (post_id,user_id,quote) VALUES (3,2,'Spread the word!');
INSERT INTO hashtags (name,posts_count,is_trending) VALUES ('community',2,1),('filmmaking',1,1);
INSERT INTO post_hashtags (post_id,hashtag_id) VALUES (1,1),(3,1),(2,2);

-- reports (spam post reported)
INSERT INTO reports (target_type,target_id,reporter_id,reason,details,created_at) VALUES
  ('post',5,2,'Spam','Fake follower link','2026-10-10 09:10:00'),
  ('user',6,3,'Spam','Posting spam everywhere','2026-10-10 09:15:00');

-- banned words
INSERT INTO banned_words (word,action,scope) VALUES
  ('cheap followers','hide','all'),
  ('bit.ly','queue','posts'),
  ('giveaway','queue','all');

-- chat: direct conversation Ahmad <-> Sara with messages
INSERT INTO conversations (id,type,creator_id,last_message_at,created_at) VALUES
  (1,'direct',1,'2026-10-10 10:35:00','2026-10-10 10:00:00'),
  (2,'group',1,'2026-10-10 09:15:00','2026-10-09 10:00:00');
INSERT INTO conversation_participants (conversation_id,user_id,role,last_read_at) VALUES
  (1,1,'owner','2026-10-10 10:36:00'),(1,2,'member','2026-10-10 10:42:00'),
  (2,1,'owner','2026-10-10 09:20:00'),(2,2,'member',NULL),(2,3,'member',NULL);
INSERT INTO messages (conversation_id,sender_id,type,body,created_at) VALUES
  (1,2,'text','Hi! Are you coming Friday?','2026-10-10 10:31:00'),
  (1,1,'text','Yes! Can I bring my camera? 📷','2026-10-10 10:33:00'),
  (1,2,'text','Perfect, see you at the main hall 👋','2026-10-10 10:35:00'),
  (2,2,'text','Agenda for Friday?','2026-10-10 09:15:00');

-- notifications
INSERT INTO notifications (user_id,actor_id,type,title,body,data_json,created_at) VALUES
  (1,2,'like','Sara Nasser liked your post','"Great session today 💪"','{"post_id":4}','2026-10-10 10:12:00'),
  (1,4,'friend_request','Lina Haddad sent you a friend request','','{"user_id":4}','2026-10-08 10:00:00');

-- verification request sample (users.is_verified flow uses reports table? keep simple: flag on user)
UPDATE users SET is_verified = 0 WHERE id = 2;