Context Navigation

← Previous Change
Wiki History
Next Change →

Changes between Version 1 and Version 2 of dmlScript.sql

Timestamp:: 03/03/26 23:57:19 (3 weeks ago)
Author:: 211099
Comment:: --

Legend:

: Unmodified
: Added
: Removed
: Modified

dmlScript.sql

-              v1
+              v2
 {{{#!sql
+TRUNCATE TABLE NEED_APPROVAL CASCADE;
+TRUNCATE TABLE NOTIFY CASCADE;
 TRUNCATE TABLE READING_LIST_ITEMS CASCADE;
 TRUNCATE TABLE HAS_GENRE CASCADE;
 …
 (10);
+INSERT INTO WRITER (user_id, created_story) VALUES
+(2, TRUE),
+(3, TRUE),
+(6, TRUE),
+(8, FALSE),
+(9, TRUE);
+INSERT INTO WRITER (user_id) VALUES
+(2),
+(3),
+(6),
+(8),
+(9);
 INSERT INTO GENRE (name) VALUES
 …
  '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.',
+,
+ '2024-08-15 10:30:00',
+ '2026-02-10 16:45:00'),
+, '2024-08-15 10:30:00', '2026-02-10 16:45:00'),
 (TRUE,
 …
  '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.',
+,
+ '2024-10-05 14:20:00',
+ '2026-02-12 19:30:00'),
+, '2024-10-05 14:20:00', '2026-02-12 19:30:00'),
 (TRUE,
 …
  '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?',
+,
+ '2024-11-20 11:00:00',
+ '2026-02-11 21:15:00'),
+, '2024-11-20 11:00:00', '2026-02-11 21:15:00'),
 (FALSE,
 …
  '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.',
+,
+ '2025-01-10 09:45:00',
+ '2026-02-13 10:20:00'),
+, '2025-01-10 09:45:00', '2026-02-13 10:20:00'),
 (FALSE,
 …
  '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.',
+,
+ '2025-02-01 13:15:00',
+ '2026-02-13 15:50:00');
+, '2025-02-01 13:15:00', '2026-02-13 15:50:00');
 INSERT INTO STATUS (story_id, status) VALUES
 …
 (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'),
 …
 (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);
+(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'),
 …
 (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!',
+, 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!',
+, 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!',
+, 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.',
+, 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!',
+, 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!',
+, 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!',
+, 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.',
+, 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!',
+, 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?!',
+, 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!',
+, 5, '2025-02-03 16:30:00', '2025-02-03 16:30:00');
+('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
 …
 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'),
+(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, user_id, created_at) VALUES
+('Sara liked your story "The Chronicles of Eldoria"', TRUE, 2, '2024-08-16 10:21:00'),
+('Ivan commented on your story "The Chronicles of Eldoria"', TRUE, 2, '2024-09-01 14:16:00'),
+('Your story "The Stolen Crown" has reached 5,000 views!', TRUE, 2, '2025-01-25 09:00:00'),
+('David added "The Chronicles of Eldoria" to their reading list', TRUE, 2, '2024-10-01 16:31:00'),
+('Sara liked your story "Falling for You"', TRUE, 3, '2024-10-06 14:31:00'),
+('Nikolina commented on your story "Falling for You"', TRUE, 3, '2024-10-22 18:31:00'),
+('Elena liked your story "Falling for You"', TRUE, 3, '2024-10-07 10:31:00'),
+('Your story "Falling for You" has been added to 2 reading lists', FALSE, 3, '2024-11-15 10:00:00'),
+('David liked your story "Moonlight Promises"', TRUE, 6, '2024-11-22 18:31:00'),
+('Nikolina commented on your story "Moonlight Promises"', TRUE, 6, '2024-11-28 21:01:00'),
+('Your story "Moonlight Promises" has reached 7,000 views!', FALSE, 6, '2026-02-01 08:00:00'),
+('Elena published a new chapter of "The Chronicles of Eldoria"', TRUE, 4, '2024-08-25 18:01:00'),
+('Marko published a new chapter of "Falling for You"', TRUE, 4, '2024-10-19 19:46:00'),
+('Elena published a new story "The Stolen Crown"', FALSE, 5, '2025-01-10 09:46: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 AI_SUGGESTION (original_text, suggested_text, accepted, story_id, created_at, applied_at) 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, 1, '2024-08-19 10:00:00', '2024-08-19 10:15:00'),
+ 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, 1, '2024-08-22 14:30:00', '2024-08-22 14:45:00'),
+ 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, 1, '2024-08-24 16:00:00', NULL),
+ 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, 2, '2024-10-08 11:00:00', '2024-10-08 11:20:00'),
+ 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, 2, '2024-10-15 13:45:00', '2024-10-15 14:00:00'),
+ 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, 3, '2024-11-25 15:30:00', '2024-11-25 15:50:00');
+ 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'),
+(1, 'style'), (1, 'grammar'),
 (2, 'style'),
 (3, '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'),