Changes between Version 3 and Version 4 of WriterCreatesStory


Ignore:
Timestamp:
08/24/26 15:58:10 (13 days ago)
Author:
211099
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • WriterCreatesStory

    v3 v4  
    1212**4.** The system inserts a new record into the STORY table.
    1313{{{#!sql
    14 INSERT INTO STORY (mature_content, short_description, image, content, user_id, created_at, updated_at)
    15 VALUES (FALSE, 'The Chronicles of Eldoria: When the last dragon awakens, a young mage must unite the fractured kingdoms',
     14INSERT INTO STORY (title, mature_content, short_description, image, story_content, status, user_id, story_created_at, story_updated_at)
     15VALUES ('The Chronicles of Eldoria', FALSE,
     16'When the last dragon awakens, a young mage must unite the fractured kingdoms',
    1617'https://images.unsplash.com/photo-dragon-fantasy.jpg',
    1718'In the ancient realm of Eldoria...',
    18 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
     19'draft', 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
    1920}}}
    2021
    2122**5.** The system sets the story status as draft by default.
    22 
    23 {{{#!sql
    24 INSERT INTO STATUS (story_id, status)
    25 VALUES (1, 'draft');
    26 }}}
    2723
    2824**6.** The system assigns the selected genres to the story.