[haiku-depot-web] [haiku-depot-web-app] push by haiku.li...@xxxxxxxxx - prominence; split the data migration across two migrations on 2014-08-07 19:32 GMT

  • From: haiku-depot-web-app@xxxxxxxxxxxxxx
  • To: haiku-depot-web@xxxxxxxxxxxxx
  • Date: Thu, 07 Aug 2014 19:33:26 +0000

Revision: 4eefd302db94
Author:   Andrew Lindesay <apl@xxxxxxxxxxxxxx>
Date:     Thu Aug  7 19:32:33 2014 UTC
Log:      prominence; split the data migration across two migrations

http://code.google.com/p/haiku-depot-web-app/source/detail?r=4eefd302db94

Modified:
/haikudepotserver-webapp/src/main/resources/db/haikudepot/migration/V1.14__Prominence.sql /haikudepotserver-webapp/src/main/resources/db/haikudepot/migration/V1.15__Prominence_2.sql

=======================================
--- /haikudepotserver-webapp/src/main/resources/db/haikudepot/migration/V1.14__Prominence.sql Wed Aug 6 19:25:45 2014 UTC +++ /haikudepotserver-webapp/src/main/resources/db/haikudepot/migration/V1.14__Prominence.sql Thu Aug 7 19:32:33 2014 UTC
@@ -22,6 +22,4 @@
 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 ADD FOREIGN KEY (prominence_id) REFERENCES haikudepot.prominence (id);
-
INSERT INTO haikudepot.permission (id, code, name) VALUES ((SELECT nextval('haikudepot.permission_seq')), 'pkg_editprominence', 'Edit Package Prominence');
=======================================
--- /haikudepotserver-webapp/src/main/resources/db/haikudepot/migration/V1.15__Prominence_2.sql Wed Aug 6 19:25:45 2014 UTC +++ /haikudepotserver-webapp/src/main/resources/db/haikudepot/migration/V1.15__Prominence_2.sql Thu Aug 7 19:32:33 2014 UTC
@@ -1,1 +1,3 @@
 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-07 19:32 GMT - haiku-depot-web-app