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

[mir.git] / dbscripts / updates / update20030920.sql

diff --git a/dbscripts/updates/update20030920.sql b/dbscripts/updates/update20030920.sql
new file mode 100755 (executable)
index 0000000..503687d
--- /dev/null
+++ b/dbscripts/updates/update20030920.sql
@@ -0,0 +1,5 @@
+-- parent_id should not NOT NULL and should not have a DEFAULT 
+
+ALTER TABLE topic ALTER parent_id DROP NOT NULL;
+ALTER TABLE topic ALTER parent_id DROP DEFAULT;
+