Changes between Version 2 and Version 3 of dmlScript.sql


Ignore:
Timestamp:
03/25/26 11:37:50 (3 weeks ago)
Author:
211099
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • dmlScript.sql

    v2 v3  
    3232ALTER SEQUENCE comment_comment_id_seq RESTART WITH 1;
    3333
     34
    3435INSERT INTO USERS (username, email, name, surname, password, created_at, updated_at) VALUES
    35 ('admin_kristina', 'admin@chapterx.com', 'Kristina', 'Srbinoska', '$2a$10$hashedpassword001', '2024-01-15 10:00:00', '2026-02-13 14:30:00'),
    36 ('elena_fantasy', 'elena.writer@chapterx.com', 'Elena', 'Dimitrova', '$2a$10$hashedpassword002', '2024-03-20 09:15:00', '2026-02-12 18:45:00'),
    37 ('marko_romance', 'marko.author@chapterx.com', 'Marko', 'Velkovski', '$2a$10$hashedpassword003', '2024-05-10 14:22:00', '2026-02-13 11:20:00'),
    38 ('sara_reader', 'sara.books@gmail.com', 'Sara', 'Petkovska', '$2a$10$hashedpassword004', '2024-06-05 16:30:00', '2026-02-13 09:00:00'),
    39 ('ivan_fan', 'ivan.fantasy@yahoo.com', 'Ivan', 'Stojanovski', '$2a$10$hashedpassword005', '2024-07-18 11:45:00', '2026-02-13 15:10:00'),
    40 ('ana_stories', 'ana.writer@chapterx.com', 'Ana', 'Nikolova', '$2a$10$hashedpassword006', '2024-08-22 13:00:00', '2026-02-11 20:30:00'),
    41 ('david_reader', 'david.books@hotmail.com', 'David', 'Trajkovski', '$2a$10$hashedpassword007', '2024-09-30 10:20:00', '2026-02-13 12:00:00'),
    42 ('maja_newwriter', 'maja.pen@chapterx.com', 'Maja', 'Georgieva', '$2a$10$hashedpassword008', '2025-01-10 15:40:00', '2026-02-13 10:15:00'),
    43 ('petra_collab', 'petra.write@chapterx.com', 'Petra', 'Ivanovska', '$2a$10$hashedpassword009', '2024-11-05 12:30:00', '2026-02-12 17:20:00'),
    44 ('nikolina_reader', 'nikolina@gmail.com', 'Nikolina', 'Kostova', '$2a$10$hashedpassword010', '2025-02-01 09:50:00', '2026-02-13 08:30:00');
     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('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'),
     38('marko_romance', 'marko.author@chapterx.com', 'Marko', 'Velkovski', '$2a$10$9/aPevnGc0mgpfANaRyHsON9v8Lof8OyTTVq0t5F0wN2.bRNPvCkC', '2024-05-10 14:22:00', '2026-02-13 11:20:00'),
     39('sara_reader', 'sara.books@gmail.com', 'Sara', 'Petkovska', '$2a$10$JlQeommNlQakb2cjxF/i3eEgBbRsDvNUVl8dy6hr3Q8IwOCmsv4Sq', '2024-06-05 16:30:00', '2026-02-13 09:00:00'),
     40('ivan_fan', 'ivan.fantasy@yahoo.com', 'Ivan', 'Stojanovski', '$2a$10$JlQeommNlQakb2cjxF/i3eEgBbRsDvNUVl8dy6hr3Q8IwOCmsv4Sq', '2024-07-18 11:45:00', '2026-02-13 15:10:00'),
     41('ana_stories', 'ana.writer@chapterx.com', 'Ana', 'Nikolova', '$2a$10$9/aPevnGc0mgpfANaRyHsON9v8Lof8OyTTVq0t5F0wN2.bRNPvCkC', '2024-08-22 13:00:00', '2026-02-11 20:30:00'),
     42('david_reader', 'david.books@hotmail.com', 'David', 'Trajkovski', '$2a$10$JlQeommNlQakb2cjxF/i3eEgBbRsDvNUVl8dy6hr3Q8IwOCmsv4Sq', '2024-09-30 10:20:00', '2026-02-13 12:00:00'),
     43('maja_newwriter', 'maja.pen@chapterx.com', 'Maja', 'Georgieva', '$2a$10$9/aPevnGc0mgpfANaRyHsON9v8Lof8OyTTVq0t5F0wN2.bRNPvCkC', '2025-01-10 15:40:00', '2026-02-13 10:15:00'),
     44('petra_collab', 'petra.write@chapterx.com', 'Petra', 'Ivanovska', '$2a$10$9/aPevnGc0mgpfANaRyHsON9v8Lof8OyTTVq0t5F0wN2.bRNPvCkC', '2024-11-05 12:30:00', '2026-02-12 17:20:00'),
     45('nikolina_reader', 'nikolina@gmail.com', 'Nikolina', 'Kostova', '$2a$10$JlQeommNlQakb2cjxF/i3eEgBbRsDvNUVl8dy6hr3Q8IwOCmsv4Sq', '2025-02-01 09:50:00', '2026-02-13 08:30:00');
    4546
    4647INSERT INTO ADMINS (user_id) VALUES (1);
     
    188189(5, 3, '2025-01-05 16:00:00'), (5, 5, '2025-02-03 10:00:00');
    189190
    190 INSERT INTO NOTIFICATION (content, is_read, created_at) VALUES
    191 ('Sara liked your story "The Chronicles of Eldoria"', TRUE, '2024-08-16 10:21:00'),
    192 ('Ivan commented on your story "The Chronicles of Eldoria"', TRUE, '2024-09-01 14:16:00'),
    193 ('Your story "The Stolen Crown" has reached 5,000 views!', TRUE, '2025-01-25 09:00:00'),
    194 ('David added "The Chronicles of Eldoria" to their reading list', TRUE, '2024-10-01 16:31:00'),
    195 ('Sara liked your story "Falling for You"', TRUE, '2024-10-06 14:31:00'),
    196 ('Nikolina commented on your story "Falling for You"', TRUE, '2024-10-22 18:31:00'),
    197 ('Elena liked your story "Falling for You"', TRUE, '2024-10-07 10:31:00'),
    198 ('Your story "Falling for You" has been added to 2 reading lists', FALSE, '2024-11-15 10:00:00'),
    199 ('David liked your story "Moonlight Promises"', TRUE, '2024-11-22 18:31:00'),
    200 ('Nikolina commented on your story "Moonlight Promises"', TRUE, '2024-11-28 21:01:00'),
    201 ('Your story "Moonlight Promises" has reached 7,000 views!', FALSE, '2026-02-01 08:00:00'),
    202 ('Elena published a new chapter of "The Chronicles of Eldoria"', TRUE, '2024-08-25 18:01:00'),
    203 ('Marko published a new chapter of "Falling for You"', TRUE, '2024-10-19 19:46:00'),
    204 ('Elena published a new story "The Stolen Crown"', FALSE, '2025-01-10 09:46:00');
     191INSERT INTO NOTIFICATION (content, is_read, recipient_user_id, type, link, created_at) VALUES
     192('Sara liked your story "The Chronicles of Eldoria"',          TRUE,  2, 'like',         '/stories/1',           '2024-08-16 10:21:00'),
     193('Ivan commented on your story "The Chronicles of Eldoria"',   TRUE,  2, 'comment',      '/stories/1',           '2024-09-01 14:16:00'),
     194('Your story "The Stolen Crown" has reached 5,000 views!',     TRUE,  2, 'milestone',    '/stories/4',           '2025-01-25 09:00:00'),
     195('David added "The Chronicles of Eldoria" to their reading list', TRUE, 2, 'reading_list', '/stories/1',          '2024-10-01 16:31:00'),
     196('Sara liked your story "Falling for You"',                    TRUE,  3, 'like',         '/stories/2',           '2024-10-06 14:31:00'),
     197('Nikolina commented on your story "Falling for You"',         TRUE,  3, 'comment',      '/stories/2',           '2024-10-22 18:31:00'),
     198('Elena liked your story "Falling for You"',                   TRUE,  3, 'like',         '/stories/2',           '2024-10-07 10:31:00'),
     199('Your story "Falling for You" has been added to 2 reading lists', FALSE, 3, 'reading_list', '/stories/2',        '2024-11-15 10:00:00'),
     200('David liked your story "Moonlight Promises"',                TRUE,  6, 'like',         '/stories/3',           '2024-11-22 18:31:00'),
     201('Nikolina commented on your story "Moonlight Promises"',      TRUE,  6, 'comment',      '/stories/3',           '2024-11-28 21:01:00'),
     202('Your story "Moonlight Promises" has reached 7,000 views!',   FALSE, 6, 'milestone',    '/stories/3',           '2026-02-01 08:00:00'),
     203('Elena published a new chapter of "The Chronicles of Eldoria"', TRUE, 4, 'new_chapter',  '/stories/1/chapters/3','2024-08-25 18:01:00'),
     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('Elena published a new story "The Stolen Crown"',             FALSE, 5, 'new_story',    '/stories/4',           '2025-01-10 09:46:00');
     206
    205207
    206208INSERT INTO CONTENT_TYPE (notification_id, content_type) VALUES