[haiku-depot-web] [haiku-depot-web-app] push by haiku.li...@xxxxxxxxx - prominence; split the data migration across two migrations on 2014-08-06 19:26 GMT
- From: haiku-depot-web-app@xxxxxxxxxxxxxx
- To: haiku-depot-web@xxxxxxxxxxxxx
- Date: Wed, 06 Aug 2014 19:26:19 +0000
Revision: bb3fd12d4b79
Author: Andrew Lindesay <apl@xxxxxxxxxxxxxx>
Date: Wed Aug 6 19:25:45 2014 UTC
Log: prominence; split the data migration across two migrations
http://code.google.com/p/haiku-depot-web-app/source/detail?r=bb3fd12d4b79
Added:
/haikudepotserver-webapp/src/main/resources/db/haikudepot/migration/V1.15__Prominence_2.sql
Modified:
/haikudepotserver-webapp/src/main/resources/db/haikudepot/migration/V1.14__Prominence.sql
=======================================
--- /dev/null
+++
/haikudepotserver-webapp/src/main/resources/db/haikudepot/migration/V1.15__Prominence_2.sql
Wed Aug 6 19:25:45 2014 UTC
@@ -0,0 +1,1 @@
+ALTER TABLE haikudepot.pkg ALTER COLUMN prominence_id SET NOT NULL;
=======================================
---
/haikudepotserver-webapp/src/main/resources/db/haikudepot/migration/V1.14__Prominence.sql
Wed Aug 6 09:46:44 2014 UTC
+++
/haikudepotserver-webapp/src/main/resources/db/haikudepot/migration/V1.14__Prominence.sql
Wed Aug 6 19:25:45 2014 UTC
@@ -21,7 +21,6 @@
ALTER TABLE haikudepot.pkg ADD COLUMN prominence_id BIGINT;
UPDATE haikudepot.pkg SET prominence_id = (SELECT id FROM
haikudepot.prominence WHERE ordering=1000);
-ALTER TABLE haikudepot.pkg ALTER COLUMN prominence_id SET NOT NULL;
ALTER TABLE haikudepot.pkg ADD FOREIGN KEY (prominence_id) REFERENCES
haikudepot.prominence (id);
Other related posts:
- » [haiku-depot-web] [haiku-depot-web-app] push by haiku.li...@xxxxxxxxx - prominence; split the data migration across two migrations on 2014-08-06 19:26 GMT - haiku-depot-web-app
