[prev in list] [next in list] [prev in thread] [next in thread] 

List:       bricolage-commits
Subject:    [6099] fixes the upgrade scripts in 1.8.3 which were
From:       slanning () bricolage ! cc
Date:       2004-12-15 18:15:09
Message-ID: 20041215181509.32411.qmail () x1 ! develooper ! com
[Download RAW message or body]

Revision: 6099
Author:   slanning
Date:     2004-12-15 10:15:06 -0800 (Wed, 15 Dec 2004)
ViewCVS:  http://viewsvn.bricolage.cc/?rev=6099&view=rev

Log Message:
-----------
fixes the upgrade scripts in 1.8.3 which were
failing due to a primary key NOT NULL constraint -
this makes it not possible for there to be
NOT NULL ids  (if I remember right - it was a
few weeks ago)

Modified Files:
--------------
    bricolage/branches/rev_1_8/inst/upgrade/1.8.3/element__site_pk.pl
    bricolage/branches/rev_1_8/inst/upgrade/1.8.3/event_attr_pk.pl
    bricolage/branches/rev_1_8/inst/upgrade/1.8.3/media_uri_pk.pl
    bricolage/branches/rev_1_8/inst/upgrade/1.8.3/story_uri_pk.pl



["r6099-slanning.diff" (r6099-slanning.diff)]

Modified: bricolage/branches/rev_1_8/inst/upgrade/1.8.3/element__site_pk.pl
===================================================================
--- bricolage/branches/rev_1_8/inst/upgrade/1.8.3/element__site_pk.pl	2004-12-15 10:49:16 UTC (rev 6098)
+++ bricolage/branches/rev_1_8/inst/upgrade/1.8.3/element__site_pk.pl	2004-12-15 18:15:06 UTC (rev 6099)
@@ -25,6 +25,9 @@
   qq{update element__site  set id = NEXTVAL('seq_element__site')},
 
   # Make sure it can never be null.
+  qq{ALTER TABLE element__site
+     ALTER COLUMN id SET NOT NULL},
+
   qq{ALTER TABLE    element__site
      ADD CONSTRAINT ck_element__site__id__null CHECK (id IS NOT NULL)},
 

Modified: bricolage/branches/rev_1_8/inst/upgrade/1.8.3/event_attr_pk.pl
===================================================================
--- bricolage/branches/rev_1_8/inst/upgrade/1.8.3/event_attr_pk.pl	2004-12-15 10:49:16 UTC (rev 6098)
+++ bricolage/branches/rev_1_8/inst/upgrade/1.8.3/event_attr_pk.pl	2004-12-15 18:15:06 UTC (rev 6099)
@@ -25,6 +25,9 @@
   qq{update event_attr  set id = NEXTVAL('seq_event_attr')},
 
   # Make sure it can never be null.
+  qq{ALTER TABLE event_attr
+     ALTER COLUMN id SET NOT NULL},
+
   qq{ALTER TABLE    event_attr
      ADD CONSTRAINT ck_event_attr__id__null CHECK (id IS NOT NULL)},
 

Modified: bricolage/branches/rev_1_8/inst/upgrade/1.8.3/media_uri_pk.pl
===================================================================
--- bricolage/branches/rev_1_8/inst/upgrade/1.8.3/media_uri_pk.pl	2004-12-15 10:49:16 UTC (rev 6098)
+++ bricolage/branches/rev_1_8/inst/upgrade/1.8.3/media_uri_pk.pl	2004-12-15 18:15:06 UTC (rev 6099)
@@ -25,6 +25,9 @@
   qq{update media_uri  set id = NEXTVAL('seq_media_uri')},
 
   # Make sure it can never be null.
+  qq{ALTER TABLE media_uri
+     ALTER COLUMN id SET NOT NULL},
+
   qq{ALTER TABLE    media_uri
      ADD CONSTRAINT ck_media_uri__id__null CHECK (id IS NOT NULL)},
 

Modified: bricolage/branches/rev_1_8/inst/upgrade/1.8.3/story_uri_pk.pl
===================================================================
--- bricolage/branches/rev_1_8/inst/upgrade/1.8.3/story_uri_pk.pl	2004-12-15 10:49:16 UTC (rev 6098)
+++ bricolage/branches/rev_1_8/inst/upgrade/1.8.3/story_uri_pk.pl	2004-12-15 18:15:06 UTC (rev 6099)
@@ -25,6 +25,9 @@
   qq{update story_uri  set id = NEXTVAL('seq_story_uri')},
 
   # Make sure it can never be null.
+  qq{ALTER TABLE story_uri
+     ALTER COLUMN id SET NOT NULL},
+
   qq{ALTER TABLE    story_uri
      ADD CONSTRAINT ck_story_uri__id__null CHECK (id IS NOT NULL)},
 


[prev in list] [next in list] [prev in thread] [next in thread]