TRUNCATE TABLE NEED_APPROVAL CASCADE;
TRUNCATE TABLE NOTIFY CASCADE;
TRUNCATE TABLE READING_LIST_ITEMS CASCADE;
TRUNCATE TABLE HAS_GENRE CASCADE;
TRUNCATE TABLE PERMISSION_LEVEL CASCADE;
TRUNCATE TABLE ROLES CASCADE;
TRUNCATE TABLE COLLABORATION CASCADE;
TRUNCATE TABLE COMMENT CASCADE;
TRUNCATE TABLE LIKES CASCADE;
TRUNCATE TABLE SUGGESTION_TYPE CASCADE;
TRUNCATE TABLE AI_SUGGESTION CASCADE;
TRUNCATE TABLE CONTENT_TYPE CASCADE;
TRUNCATE TABLE NOTIFICATION CASCADE;
TRUNCATE TABLE READING_LIST CASCADE;
TRUNCATE TABLE CHAPTER CASCADE;
TRUNCATE TABLE STATUS CASCADE;
TRUNCATE TABLE STORY CASCADE;
TRUNCATE TABLE WRITER CASCADE;
TRUNCATE TABLE REGULAR_USER CASCADE;
TRUNCATE TABLE ADMINS CASCADE;
TRUNCATE TABLE USERS CASCADE;
TRUNCATE TABLE GENRE CASCADE;

ALTER SEQUENCE users_user_id_seq RESTART WITH 1;
ALTER SEQUENCE story_story_id_seq RESTART WITH 1;
ALTER SEQUENCE chapter_chapter_id_seq RESTART WITH 1;
ALTER SEQUENCE genre_genre_id_seq RESTART WITH 1;
ALTER SEQUENCE reading_list_list_id_seq RESTART WITH 1;
ALTER SEQUENCE notification_notification_id_seq RESTART WITH 1;
ALTER SEQUENCE ai_suggestion_suggestion_id_seq RESTART WITH 1;
ALTER SEQUENCE comment_comment_id_seq RESTART WITH 1;

INSERT INTO USERS (username, email, name, surname, password, created_at, updated_at) VALUES
('admin_kristina', 'admin@chapterx.com', 'Kristina', 'Srbinoska', '$2a$10$hashedpassword001', '2024-01-15 10:00:00', '2026-02-13 14:30:00'),
('elena_fantasy', 'elena.writer@chapterx.com', 'Elena', 'Dimitrova', '$2a$10$hashedpassword002', '2024-03-20 09:15:00', '2026-02-12 18:45:00'),
('marko_romance', 'marko.author@chapterx.com', 'Marko', 'Velkovski', '$2a$10$hashedpassword003', '2024-05-10 14:22:00', '2026-02-13 11:20:00'),
('sara_reader', 'sara.books@gmail.com', 'Sara', 'Petkovska', '$2a$10$hashedpassword004', '2024-06-05 16:30:00', '2026-02-13 09:00:00'),
('ivan_fan', 'ivan.fantasy@yahoo.com', 'Ivan', 'Stojanovski', '$2a$10$hashedpassword005', '2024-07-18 11:45:00', '2026-02-13 15:10:00'),
('ana_stories', 'ana.writer@chapterx.com', 'Ana', 'Nikolova', '$2a$10$hashedpassword006', '2024-08-22 13:00:00', '2026-02-11 20:30:00'),
('david_reader', 'david.books@hotmail.com', 'David', 'Trajkovski', '$2a$10$hashedpassword007', '2024-09-30 10:20:00', '2026-02-13 12:00:00'),
('maja_newwriter', 'maja.pen@chapterx.com', 'Maja', 'Georgieva', '$2a$10$hashedpassword008', '2025-01-10 15:40:00', '2026-02-13 10:15:00'),
('petra_collab', 'petra.write@chapterx.com', 'Petra', 'Ivanovska', '$2a$10$hashedpassword009', '2024-11-05 12:30:00', '2026-02-12 17:20:00'),
('nikolina_reader', 'nikolina@gmail.com', 'Nikolina', 'Kostova', '$2a$10$hashedpassword010', '2025-02-01 09:50:00', '2026-02-13 08:30:00');

INSERT INTO ADMINS (user_id) VALUES (1);

INSERT INTO REGULAR_USER (user_id) VALUES 
(4), 
(5), 
(7), 
(10); 

INSERT INTO WRITER (user_id) VALUES
(2),  
(3),  
(6),  
(8), 
(9);  

INSERT INTO GENRE (name) VALUES
('Fantasy'),
('Romance'),
('Mystery'),
('Adventure'),
('Drama'),
('Young Adult'),
('Paranormal'),
('Historical'),
('Contemporary'),
('Dark Fantasy');

INSERT INTO STORY (mature_content, short_description, image, content, user_id, created_at, updated_at) VALUES
(FALSE,
 'The Chronicles of Eldoria: When the last dragon awakens, a young mage must unite the fractured kingdoms', 
 'https://images.unsplash.com/photo-dragon-fantasy.jpg',
 'In the ancient realm of Eldoria, where magic flows through crystalline rivers and dragons once ruled the skies, seventeen-year-old Lyra discovers she is the last descendant of the Dragon Keepers. When the prophecy speaks of the final dragon awakening from its thousand-year slumber, Lyra must embark on a perilous journey to unite five warring kingdoms before an ancient evil consumes the realm. With her loyal companion, a shape-shifting fox named Ember, and a mysterious warrior haunted by his past, Lyra faces impossible choices that will determine the fate of all Eldoria.',
 2, '2024-08-15 10:30:00', '2026-02-10 16:45:00'),

(TRUE,
 'Falling for You: A chance encounter in a Skopje cafe changes everything for two strangers',
 'https://images.unsplash.com/photo-coffee-romance.jpg',
 'Maya is a successful architect who has sworn off love after a devastating breakup. Damjan is a charming musician playing his guitar in Café Renaissance, drowning his own sorrows. When their eyes meet across the crowded café on a rainy October evening, neither expects that this chance encounter will turn their carefully constructed worlds upside down. As they navigate the complexities of trust, vulnerability, and second chances, they discover that sometimes the most beautiful things happen when you least expect them. Set against the vibrant backdrop of Skopje, this is a story about healing, passion, and finding love when you have stopped looking for it.',
 3, '2024-10-05 14:20:00', '2026-02-12 19:30:00'),

(TRUE,
 'Moonlight Promises: A vampire prince and a witch must unite to save both their worlds',
 'https://images.unsplash.com/photo-moonlight-vampire.jpg',
 'For centuries, vampires and witches have been mortal enemies. But when a dark force threatens to destroy both supernatural communities, Daemon, the reluctant vampire prince, and Selene, a powerful witch with a tragic past, are forced into an uneasy alliance. As they work together to uncover ancient secrets and battle shadowy enemies, the forbidden attraction between them ignites into a passionate romance that could either save their worlds or doom them forever. In a race against time, they must decide: follow their hearts or fulfill their destinies?',
 6, '2024-11-20 11:00:00', '2026-02-11 21:15:00'),

(FALSE,
 'The Stolen Crown: A princess in disguise joins a band of thieves to reclaim her kingdom',
 'https://images.unsplash.com/photo-princess-adventure.jpg',
 'Princess Aria watched helplessly as her uncle murdered her family and seized the throne. Forced to flee in the dead of night, she disguises herself as a common thief and joins the notorious Shadow Wolves, a band of outlaws operating in the kingdom capital. As "Ari the street rat," she learns the art of survival, deception, and combat. But when she falls for the charismatic leader of the Shadow Wolves, who has his own reasons for hating the royal family, Aria must choose between revealing her true identity and losing his trust forever, or keeping her secret and watching her kingdom fall into tyranny.',
 2, '2025-01-10 09:45:00', '2026-02-13 10:20:00'),

(FALSE,
 'Letters from Constantinople: A forbidden love story set in the Ottoman Empire',
 'https://images.unsplash.com/photo-ottoman-romance.jpg',
 'In 1520 Constantinople, young scholar Iskender discovers a cache of love letters written by his grandmother, revealing a forbidden romance that spanned decades. As he reads her story of loving a Christian artist in a time of religious tensions, Iskender finds himself drawn to Elena, a Greek artist visiting the city. Their growing connection mirrors the passionate and dangerous love affair documented in the letters, forcing Iskender to confront whether history will repeat itself or if love can truly transcend the boundaries of faith, culture, and time.',
 3, '2025-02-01 13:15:00', '2026-02-13 15:50:00');

INSERT INTO STATUS (story_id, status) VALUES
(1, 'published'),
(2, 'published'),
(3, 'published'),
(4, 'published'),
(5, 'draft');

INSERT INTO CHAPTER (chapter_number, chapter_name, title, content, word_count, rating, published_at, view_count, story_id, created_at, updated_at) VALUES
(1, 'Prologue', 'The Awakening', 'The ground trembled beneath the Crystal Mountains. For a thousand years, the last dragon had slept, bound by ancient magic and forgotten prophecies. But tonight, as three moons aligned in the crimson sky, the seals began to crack. Deep within her chamber, Lyra shot upright in bed, her mark burning with an intensity she had never felt before. The mark of the Dragon Keeper, dormant since birth, now glowed with ethereal fire. She knew, with absolute certainty, that everything was about to change. The dragon was waking, and with it, an age of magic and war would return to Eldoria...', 3200, 4.8, '2024-08-15 11:00:00', 15420, 1, '2024-08-15 10:30:00', '2024-08-15 10:30:00'),

(2, 'Chapter One', 'The Mark Bearer', 'Lyra had spent seventeen years hiding her mark. In the small village of Thornhaven, magic users were feared, hunted, and often killed. Her grandmother had taught her to wrap cloth around her wrist, to never let anyone see the spiraling dragon mark that branded her as different. But as she walked through the morning market, purchasing bread and herbs, she felt eyes upon her. The bandage had slipped. A woman screamed. Fingers pointed. And in that moment, as the village guard moved toward her with weapons drawn, Lyra made a choice that would alter the course of her life forever. She ran...', 4100, 4.9, '2024-08-20 15:30:00', 12890, 1, '2024-08-20 14:45:00', '2024-08-20 14:45:00'),

(3, 'Chapter Two', 'The Fox and the Warrior', 'The forest was supposed to be her sanctuary, but Lyra quickly learned that danger lurked even here. Exhausted and terrified, she collapsed near a crystal-clear stream. That was when she met Ember—a fox with unusual amber eyes that seemed too intelligent, too knowing. When the fox transformed before her eyes into a young woman with fiery red hair and a mischievous grin, Lyra nearly fainted. "You are the one," Ember whispered. "The prophecy speaks of you." Before Lyra could respond, an arrow whistled past her ear. A dark figure emerged from the shadows—Kael, a warrior marked by scars and secrets, sent to protect or destroy the Dragon Keeper. His orders were clear. His heart was not...', 4500, 4.7, '2024-08-25 18:00:00', 11250, 1, '2024-08-25 17:20:00', '2024-08-25 17:20:00'),

(1, 'Chapter One', 'Rainy October', 'Maya hated rain. It reminded her of the day Aleksandar left, taking her trust and her heart with him. But tonight, as October rain drummed against the windows of Café Renaissance, she found herself seeking refuge in the warm, coffee-scented interior. The café was crowded, every table occupied except for one small corner spot. As she settled with her sketchbook, a melody drifted through the air—a guitar playing something hauntingly beautiful. She looked up to find a man with kind eyes and calloused fingers, pouring his soul into every note. Their eyes met. Time stopped. And in that moment, Maya realized that some encounters are not accidents—they are destiny...', 3800, 4.6, '2024-10-05 15:00:00', 9340, 2, '2024-10-05 14:20:00', '2024-10-05 14:20:00'),

(2, 'Chapter Two', 'Coffee and Conversations', 'His name was Damjan, and he had a smile that could chase away any storm. They talked for hours that first night—about music, architecture, dreams, and heartbreaks. Maya learned that he was recovering from his own wounds, that his guitar was his therapy, and that he played at Café Renaissance every Thursday night. She learned that he loved old Yugoslav rock, that he believed in second chances, and that his laugh was contagious. When the café closed and they stood outside in the rain, neither wanting to say goodbye, Damjan did something unexpected. He handed her a small piece of paper with his number and whispered, "Thursday. Same café. Same music. But maybe this time, you will stay for more than just the coffee..."', 3950, 4.8, '2024-10-12 16:30:00', 8720, 2, '2024-10-12 16:00:00', '2024-10-12 16:00:00'),

(3, 'Chapter Three', 'The Walls We Build', 'Every Thursday, Maya returned. With each meeting, the walls around her heart crumbled a little more. Damjan was patient, never pushing, always present. He showed her Skopje through new eyes—hidden gardens, rooftop cafes, secret viewpoints where the city spread below them like a tapestry of lights. But fear is a stubborn companion. When Damjan tried to kiss her one evening overlooking Kale Fortress, Maya pulled away. "I cannot do this," she whispered, tears streaming down her face. "I cannot let someone hurt me again." Damjan took her hands gently. "Then let me show you that not everyone will. Give me a chance, Maya. Give us a chance..." The city lights blurred through her tears as she finally nodded...', 4200, 4.9, '2024-10-19 19:45:00', 8200, 2, '2024-10-19 19:00:00', '2024-10-19 19:00:00'),

(1, 'Chapter One', 'Blood Moon Rising', 'The Blood Moon rose over Salem, casting the city in crimson light. Selene stood atop the Witch Council Tower, feeling the ancient magic pulse through her veins. For three centuries, her coven had guarded the northern territories, maintaining the fragile peace between witches and vampires. But tonight, something was wrong. The wards were failing. Dark magic, older and more powerful than anything she had encountered, was breaking through. Then she sensed him—a vampire, crossing into witch territory. Protocol demanded she attack. Instinct told her something else entirely. When she descended to confront him, she found herself face to face with the most dangerous creature she had ever encountered: Daemon, Crown Prince of the Night Court, and the only vampire who had ever made her heart skip a beat...', 4300, 4.7, '2024-11-20 12:00:00', 7890, 3, '2024-11-20 11:00:00', '2024-11-20 11:00:00'),

(2, 'Chapter Two', 'Reluctant Allies', 'The ancient evil that threatened them was called the Void—a primordial darkness that fed on supernatural energy. It had been imprisoned millennia ago by the first witches and vampires working together. Now it was awakening, and the only way to stop it was for old enemies to become allies once more. Daemon explained this to Selene with the same frustration she felt. They hated the situation. They hated each other on principle—or at least, they tried to. But as they stood in her library, poring over dusty prophecies and forbidden texts, Selene found herself stealing glances at him. The way his eyes brightened when he discovered a clue. The gentleness in his hands as he handled ancient manuscripts. This vampire prince was not what she expected. And that terrified her more than any Void ever could...', 4100, 4.5, '2024-11-27 14:30:00', 7200, 3, '2024-11-27 14:00:00', '2024-11-27 14:00:00'),

(1, 'Chapter One', 'The Night of Blood', 'Princess Aria ran through the secret passages of Castle Thornwood, her nightgown soaked with her mother''s blood. Behind her, she heard screams—the palace guard being slaughtered by her uncle''s mercenaries. "Run!" her mother had gasped with her final breath. "Run and do not look back!" So Aria ran. Through passages her brothers had shown her during childhood games of hide and seek, through the catacombs beneath the castle, through the sewers that emptied into the river. She ran until her feet bled and her lungs burned. And when she finally collapsed in a dark alley in the lower city, watching the castle burn against the night sky, Princess Aria died. In her place, a new person was born—Ari, the orphan thief, with only one purpose: revenge...', 3900, 4.6, '2025-01-10 10:00:00', 5430, 4, '2025-01-10 09:45:00', '2025-01-10 09:45:00'),

(2, 'Chapter Two', 'The Shadow Wolves', 'Survival in the lower city was brutal. Aria learned quickly—steal food, trust no one, sleep with a knife under your pillow. It was during her third week as a street thief that she encountered the Shadow Wolves. She had been caught stealing bread from the market when they intervened. Flynn, their leader, was magnetic—dangerous smile, quick wit, and eyes that missed nothing. He offered her a choice: join them or face the city guard alone. She chose the Wolves. Over the following months, they became her family. Flynn taught her to fight. Rowan showed her how to pick any lock. Lila schooled her in poisons and disguises. They transformed the terrified princess into a formidable thief. But they did not know her secret. And Aria intended to keep it that way...', 4000, 4.7, '2025-01-17 16:20:00', 5100, 4, '2025-01-17 16:00:00', '2025-01-17 16:00:00'),

(1, 'Prologue', 'The Letters', 'Iskender''s grandmother had been dead for three months when he found the letters. Hidden in a false bottom of her jewelry box, wrapped in faded silk, were dozens of letters written in both Turkish and Greek. As he carefully unfolded the first one, dated 1520, his breath caught. "My beloved Nikos," it began. "I know this letter can never reach you, but I write anyway. They have forbidden me from seeing you. My father says you are the enemy, that our love is impossible. But how can love be the enemy? How can two hearts beating as one be anything but divine?" Iskender read through the night, discovering a grandmother he never knew—young, passionate, defiant. And as dawn broke over modern Istanbul, he made a decision. He would find Nikos''s story. He would understand their love. He never expected to find his own...', 3600, 4.5, '2025-02-01 13:30:00', 3890, 5, '2025-02-01 13:15:00', '2025-02-01 13:15:00');

INSERT INTO HAS_GENRE (story_id, genre_id) VALUES
(1, 1), (1, 4), (1, 6),
(2, 2), (2, 9), (2, 5),
(3, 2), (3, 7), (3, 1),
(4, 1), (4, 4), (4, 2),
(5, 2), (5, 8), (5, 5);

INSERT INTO LIKES (user_id, story_id, created_at) VALUES
(4, 1, '2024-08-16 10:20:00'),
(4, 2, '2024-10-06 14:30:00'),
(4, 3, '2024-11-21 16:45:00'),
(5, 1, '2024-08-17 11:15:00'),
(5, 4, '2025-01-11 12:30:00'),
(7, 1, '2024-08-18 09:00:00'),
(7, 2, '2024-10-08 15:20:00'),
(7, 3, '2024-11-22 18:30:00'),
(7, 4, '2025-01-12 10:45:00'),
(10, 2, '2024-10-09 16:00:00'),
(10, 3, '2024-11-23 19:15:00'),
(10, 5, '2025-02-02 11:20:00'),
(2, 2, '2024-10-07 10:30:00'),
(2, 3, '2024-11-21 12:00:00'),
(3, 1, '2024-08-19 14:15:00'),
(3, 4, '2025-01-13 15:30:00'),
(6, 1, '2024-08-20 16:45:00'),
(6, 2, '2024-10-10 17:30:00');

INSERT INTO COMMENT (content, user_id, story_id, created_at, updated_at) VALUES
('This is absolutely breathtaking! The world-building is incredible. I cannot wait to see what happens next with Lyra and Kael!', 4, 1, '2024-08-26 12:30:00', '2024-08-26 12:30:00'),
('Finally a fantasy story where the female lead is strong without losing her vulnerability. Ember is my favorite character so far!', 5, 1, '2024-09-01 14:15:00', '2024-09-01 14:15:00'),
('The prophecy is so well crafted. I have theories about what the "five kingdoms united" actually means... cannot wait for chapter 4!', 7, 1, '2024-09-10 16:45:00', '2024-09-10 16:45:00'),
('I ugly cried reading chapter 3. This hits so close to home. Maya and Damjan feel so REAL.', 4, 2, '2024-10-20 10:20:00', '2024-10-20 10:20:00'),
('As someone from Skopje, I love the local references! The Café Renaissance detail is perfect!', 10, 2, '2024-10-22 18:30:00', '2024-10-22 18:30:00'),
('This is now my comfort story. The slow burn is killing me but in the best way possible!', 7, 2, '2024-11-05 20:15:00', '2024-11-05 20:15:00'),
('Daemon and Selene have the best chemistry I have read in YEARS. The forbidden enemies-to-lovers trope done RIGHT!', 4, 3, '2024-11-28 21:00:00', '2024-11-28 21:00:00'),
('The world-building is amazing. I love how you have given depth to both vampire and witch societies instead of making them one-dimensional.', 10, 3, '2024-12-05 15:30:00', '2024-12-05 15:30:00'),
('Aria is such a badass! From princess to thief? This is the character arc I needed!', 5, 4, '2025-01-18 11:45:00', '2025-01-18 11:45:00'),
('The tension between Aria and Flynn is electric! Please tell me they will end up together?!', 7, 4, '2025-01-20 14:20:00', '2025-01-20 14:20:00'),
('The dual timeline narrative is beautiful. I am equally invested in both love stories!', 10, 5, '2025-02-03 16:30:00', '2025-02-03 16:30:00');

INSERT INTO READING_LIST (name, content, is_public, user_id) VALUES
('Sara''s Fantasy Favorites', 'My collection of the best fantasy stories with strong female leads and epic adventures', TRUE, 4),
('Ivan''s Epic Reads', 'Fantasy epics that kept me up all night', TRUE, 5),
('David''s Must-Read Collection', 'Stories across all genres that I absolutely loved', TRUE, 7),
('Nikolina''s Romance Library', 'The most swoon-worthy romance stories', TRUE, 10),
('Sara''s TBR List', 'To Be Read - stories I am excited to start', FALSE, 4);

INSERT INTO READING_LIST_ITEMS (list_id, story_id, added_at) VALUES
(1, 1, '2024-09-01 10:30:00'), (1, 4, '2025-01-14 12:00:00'),
(2, 1, '2024-09-15 15:00:00'), (2, 4, '2025-01-15 10:30:00'),
(3, 1, '2024-10-01 16:30:00'), (3, 2, '2024-10-08 17:00:00'),
(3, 3, '2024-11-22 19:00:00'), (3, 4, '2025-01-13 11:00:00'),
(4, 2, '2024-11-10 12:30:00'), (4, 3, '2024-11-23 20:00:00'),
(4, 5, '2025-02-02 12:00:00'),
(5, 3, '2025-01-05 16:00:00'), (5, 5, '2025-02-03 10:00:00');

INSERT INTO NOTIFICATION (content, is_read, created_at) VALUES
('Sara liked your story "The Chronicles of Eldoria"', TRUE, '2024-08-16 10:21:00'),
('Ivan commented on your story "The Chronicles of Eldoria"', TRUE, '2024-09-01 14:16:00'),
('Your story "The Stolen Crown" has reached 5,000 views!', TRUE, '2025-01-25 09:00:00'),
('David added "The Chronicles of Eldoria" to their reading list', TRUE, '2024-10-01 16:31:00'),
('Sara liked your story "Falling for You"', TRUE, '2024-10-06 14:31:00'),
('Nikolina commented on your story "Falling for You"', TRUE, '2024-10-22 18:31:00'),
('Elena liked your story "Falling for You"', TRUE, '2024-10-07 10:31:00'),
('Your story "Falling for You" has been added to 2 reading lists', FALSE, '2024-11-15 10:00:00'),
('David liked your story "Moonlight Promises"', TRUE, '2024-11-22 18:31:00'),
('Nikolina commented on your story "Moonlight Promises"', TRUE, '2024-11-28 21:01:00'),
('Your story "Moonlight Promises" has reached 7,000 views!', FALSE, '2026-02-01 08:00:00'),
('Elena published a new chapter of "The Chronicles of Eldoria"', TRUE, '2024-08-25 18:01:00'),
('Marko published a new chapter of "Falling for You"', TRUE, '2024-10-19 19:46:00'),
('Elena published a new story "The Stolen Crown"', FALSE, '2025-01-10 09:46:00');

INSERT INTO CONTENT_TYPE (notification_id, content_type) VALUES
(1, 'like'), (2, 'comment'), (3, 'milestone'), (4, 'reading_list'),
(5, 'like'), (6, 'comment'), (7, 'like'), (8, 'reading_list'),
(9, 'like'), (10, 'comment'), (11, 'milestone'),
(12, 'new_chapter'), (13, 'new_chapter'), (14, 'new_story');

INSERT INTO NOTIFY (user_id, story_id, notification_id) VALUES
(2, 1, 1),
(2, 1, 2),
(2, 4, 3),
(2, 1, 4),
(3, 2, 5),
(3, 2, 6),
(3, 2, 7),
(3, 2, 8),
(6, 3, 9),
(6, 3, 10),
(6, 3, 11),
(4, 1, 12),
(4, 2, 13),
(5, 4, 14);

INSERT INTO AI_SUGGESTION (original_text, suggested_text, accepted, created_at, applied_at, story_id) VALUES
('Lyra ran through the forest, she was scared and tired.',
 'Lyra sprinted through the dense forest, her heart pounding with fear, exhaustion weighing down each desperate step.',
 TRUE, '2024-08-19 10:00:00', '2024-08-19 10:15:00', 1),

('The dragon was big and had red scales.', 
 'The dragon towered above them, its massive form covered in crimson scales that shimmered like molten rubies in the firelight.',
 TRUE, '2024-08-22 14:30:00', '2024-08-22 14:45:00', 1),

('Kael looked at her with a serious expression.',
 'Kael''s gaze locked onto hers, his storm-gray eyes betraying a mix of duty and something deeper—something dangerous.',
 FALSE, '2024-08-24 16:00:00', NULL, 1),

('Maya felt sad when she thought about her ex-boyfriend.',
 'A wave of melancholy washed over Maya whenever Aleksandar''s memory surfaced, the ache of betrayal still fresh despite the passing months.',
 TRUE, '2024-10-08 11:00:00', '2024-10-08 11:20:00', 2),

('Damjan played the guitar very well.',
 'Damjan''s fingers danced across the guitar strings with practiced grace, coaxing melodies that seemed to speak directly to the soul.',
 TRUE, '2024-10-15 13:45:00', '2024-10-15 14:00:00', 2),

('The vampire and witch did not trust each other.',
 'Centuries of bloodshed and betrayal stood between them, making trust not just difficult—but seemingly impossible.',
 TRUE, '2024-11-25 15:30:00', '2024-11-25 15:50:00', 3);

INSERT INTO SUGGESTION_TYPE (suggestion_id, suggestion_type) VALUES
(1, 'style'), (1, 'grammar'),
(2, 'style'),
(3, 'style'),
(4, 'style'),
(5, 'style'),
(6, 'pacing');

INSERT INTO NEED_APPROVAL (suggestion_id, story_id, chapter_id) VALUES
(1, 1, 1),
(2, 1, 2),
(3, 1, 3),
(4, 2, 4),
(5, 2, 5),
(6, 3, 7);

INSERT INTO COLLABORATION (user_id, story_id, created_at) VALUES
(3, 5, '2025-02-01 13:15:00'),
(9, 5, '2025-02-02 10:00:00');

INSERT INTO ROLES (user_id, story_id, roles) VALUES
(3, 5, 'lead-author'),
(9, 5, 'co-author');

INSERT INTO PERMISSION_LEVEL (user_id, story_id, permission_level) VALUES
(3, 5, 5),
(9, 5, 4);