to_parent aatribute without NOT NULL and DEFAULT value. Needed for parent-child-relation

[mir.git] / dbscripts / create_pg.sql

diff --git a/dbscripts/create_pg.sql b/dbscripts/create_pg.sql
index d9ce6ab..5dcdbc7 100755 (executable)
--- a/dbscripts/create_pg.sql
+++ b/dbscripts/create_pg.sql
@@ -105,7 +105,7 @@ CREATE SEQUENCE "topic_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue
 
 CREATE TABLE "topic" (
        "id" integer DEFAULT nextval('topic_id_seq'::text) NOT NULL,
-       "parent_id" integer DEFAULT '0' NOT NULL,
+       "parent_id" integer,
        "title" character varying(80) NOT NULL,
        "description" text,
        "filename" character varying(20) NOT NULL,