Changes between Version 3 and Version 4 of dmlScript.sql
- Timestamp:
- 04/23/26 15:01:15 (9 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
dmlScript.sql
v3 v4 33 33 34 34 35 INSERT INTO USERS (username, email, name, surname, password, created_at,updated_at) VALUES35 INSERT INTO USERS (username, email, user_name, surname, password, user_created_at, user_updated_at) VALUES 36 36 ('admin_kristina', 'admin@chapterx.com', 'Kristina', 'Srbinoska', '$2a$10$TOkY2mRMqfigobJ8/00oZuY3t9M8oSCyx/G8mfPEGiuicIuk5LxL.', '2024-01-15 10:00:00', '2026-02-13 14:30:00'), 37 37 ('elena_fantasy', 'elena.writer@chapterx.com', 'Elena', 'Dimitrova', '$2a$10$9/aPevnGc0mgpfANaRyHsON9v8Lof8OyTTVq0t5F0wN2.bRNPvCkC', '2024-03-20 09:15:00', '2026-02-12 18:45:00'), … … 60 60 (9); 61 61 62 INSERT INTO GENRE ( name) VALUES62 INSERT INTO GENRE (genre_name) VALUES 63 63 ('Fantasy'), 64 64 ('Romance'), … … 72 72 ('Dark Fantasy'); 73 73 74 INSERT INTO STORY (mature_content, short_description, image, content, user_id, created_at,updated_at) VALUES74 INSERT INTO STORY (mature_content, short_description, image, story_content, user_id, story_created_at, story_updated_at) VALUES 75 75 (FALSE, 76 76 'The Chronicles of Eldoria: When the last dragon awakens, a young mage must unite the fractured kingdoms', … … 110 110 (5, 'draft'); 111 111 112 INSERT INTO CHAPTER (chapter_number, chapter_name, title, c ontent, word_count, rating, published_at, view_count, story_id, created_at,updated_at) VALUES112 INSERT INTO CHAPTER (chapter_number, chapter_name, title, chapter_content, word_count, rating, published_at, view_count, story_id, chapter_created_at, chapter_updated_at) VALUES 113 113 (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'), 114 114 … … 140 140 (5, 2), (5, 8), (5, 5); 141 141 142 INSERT INTO LIKES (user_id, story_id, created_at) VALUES142 INSERT INTO LIKES (user_id, story_id, like_created_at) VALUES 143 143 (4, 1, '2024-08-16 10:20:00'), 144 144 (4, 2, '2024-10-06 14:30:00'), … … 160 160 (6, 2, '2024-10-10 17:30:00'); 161 161 162 INSERT INTO COMMENT (co ntent, user_id, story_id, created_at,updated_at) VALUES162 INSERT INTO COMMENT (comment_content, user_id, story_id, comment_created_at, comment_updated_at) VALUES 163 163 ('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'), 164 164 ('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'), … … 173 173 ('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'); 174 174 175 INSERT INTO READING_LIST ( name,content, is_public, user_id) VALUES175 INSERT INTO READING_LIST (list_name, list_content, is_public, user_id) VALUES 176 176 ('Sara''s Fantasy Favorites', 'My collection of the best fantasy stories with strong female leads and epic adventures', TRUE, 4), 177 177 ('Ivan''s Epic Reads', 'Fantasy epics that kept me up all night', TRUE, 5), … … 189 189 (5, 3, '2025-01-05 16:00:00'), (5, 5, '2025-02-03 10:00:00'); 190 190 191 INSERT INTO NOTIFICATION ( content, is_read, recipient_user_id, type, link,created_at) VALUES191 INSERT INTO NOTIFICATION (notification_content, is_read, recipient_user_id, type, link, notification_created_at) VALUES 192 192 ('Sara liked your story "The Chronicles of Eldoria"', TRUE, 2, 'like', '/stories/1', '2024-08-16 10:21:00'), 193 193 ('Ivan commented on your story "The Chronicles of Eldoria"', TRUE, 2, 'comment', '/stories/1', '2024-09-01 14:16:00'), … … 204 204 ('Marko published a new chapter of "Falling for You"', TRUE, 4, 'new_chapter', '/stories/2/chapters/3','2024-10-19 19:46:00'), 205 205 ('Elena published a new story "The Stolen Crown"', FALSE, 5, 'new_story', '/stories/4', '2025-01-10 09:46:00'); 206 207 206 208 207 INSERT INTO CONTENT_TYPE (notification_id, content_type) VALUES … … 228 227 (5, 4, 14); 229 228 230 INSERT INTO AI_SUGGESTION (original_text, suggested_text, accepted, created_at, applied_at, story_id) VALUES229 INSERT INTO AI_SUGGESTION (original_text, suggested_text, accepted, suggestion_created_at, applied_at, story_id) VALUES 231 230 ('Lyra ran through the forest, she was scared and tired.', 232 231 'Lyra sprinted through the dense forest, her heart pounding with fear, exhaustion weighing down each desperate step.', … … 269 268 (6, 3, 7); 270 269 271 INSERT INTO COLLABORATION (user_id, story_id, c reated_at) VALUES270 INSERT INTO COLLABORATION (user_id, story_id, collab_created_at) VALUES 272 271 (3, 5, '2025-02-01 13:15:00'), 273 272 (9, 5, '2025-02-02 10:00:00');
