Changes between Version 4 and Version 5 of ddlScript.sql

Timestamp:

07/02/26 18:23:14 (3 days ago)

Author:

211099

Comment:

--

ddlScript.sql

@@ -1 +1 @@
 {{{#!sql
+
+ 
 -- Delete tables if they exist
 DROP TABLE IF EXISTS NEED_APPROVAL CASCADE;
@@ -61 +63 @@
 CREATE TABLE STORY(
     story_id SERIAL PRIMARY KEY,
+    title VARCHAR(200) NOT NULL DEFAULT '',
     mature_content BOOLEAN NOT NULL,
     short_description VARCHAR(500) NOT NULL,
@@ -280 +283 @@
         ON DELETE CASCADE
         ON UPDATE CASCADE
-);
+); 
+}}}