[haiku-depot-web] [haiku-depot-web-app] push by haiku.li...@xxxxxxxxx - + fix for database schema migration on 2014-07-29 10:10 GMT
- From: haiku-depot-web-app@xxxxxxxxxxxxxx
- To: haiku-depot-web@xxxxxxxxxxxxx
- Date: Tue, 29 Jul 2014 10:11:12 +0000
Revision: d0f77bc7ea14
Author: Andrew Lindesay <apl@xxxxxxxxxxxxxx>
Date: Tue Jul 29 10:08:03 2014 UTC
Log: + fix for database schema migration
http://code.google.com/p/haiku-depot-web-app/source/detail?r=d0f77bc7ea14
Added:
/haikudepotserver-webapp/src/main/resources/db/haikudepot/migration/V1.12__Add_Timestamps.sql
/haikudepotserver-webapp/src/main/resources/db/haikudepot/migration/V1.13__Add_Timestamps_2.sql
Modified:
/haikudepotserver-webapp/src/main/resources/db/haikudepot/migration/V1.11__Authorization_2.sql
=======================================
--- /dev/null
+++
/haikudepotserver-webapp/src/main/resources/db/haikudepot/migration/V1.12__Add_Timestamps.sql
Tue Jul 29 10:08:03 2014 UTC
@@ -0,0 +1,8 @@
+-- ------------------------------------------------------
+-- ADD SOME MODIFY + CREATE TIMESTAMPS
+-- ------------------------------------------------------
+
+ALTER TABLE haikudepot.pkg_version_localization ADD COLUMN
modify_timestamp TIMESTAMP;
+ALTER TABLE haikudepot.pkg_version_localization ADD COLUMN
create_timestamp TIMESTAMP;
+UPDATE haikudepot.pkg_version_localization pvl SET
modify_timestamp=(SELECT create_timestamp FROM haikudepot.pkg_version pv
WHERE pv.id=pvl.pkg_version_id);
+UPDATE haikudepot.pkg_version_localization pvl SET
create_timestamp=modify_timestamp;
=======================================
--- /dev/null
+++
/haikudepotserver-webapp/src/main/resources/db/haikudepot/migration/V1.13__Add_Timestamps_2.sql
Tue Jul 29 10:08:03 2014 UTC
@@ -0,0 +1,6 @@
+-- ------------------------------------------------------
+-- ADD SOME MODIFY + CREATE TIMESTAMPS
+-- ------------------------------------------------------
+
+ALTER TABLE haikudepot.pkg_version_localization ALTER COLUMN
modify_timestamp SET NOT NULL;
+ALTER TABLE haikudepot.pkg_version_localization ALTER COLUMN
create_timestamp SET NOT NULL;
=======================================
---
/haikudepotserver-webapp/src/main/resources/db/haikudepot/migration/V1.11__Authorization_2.sql
Mon Jul 28 09:04:02 2014 UTC
+++
/haikudepotserver-webapp/src/main/resources/db/haikudepot/migration/V1.11__Authorization_2.sql
Tue Jul 29 10:08:03 2014 UTC
@@ -27,12 +27,3 @@
ALTER TABLE haikudepot.permission_user_pkg ALTER COLUMN pkg_id DROP NOT
NULL;
-- ------------------------------------------------------
--- SNEAK IN A COUPLE OF ADDITIONAL CHANGES...
--- ------------------------------------------------------
-
-ALTER TABLE haikudepot.pkg_version_localization ADD COLUMN
modify_timestamp TIMESTAMP;
-ALTER TABLE haikudepot.pkg_version_localization ADD COLUMN
create_timestamp TIMESTAMP;
-UPDATE haikudepot.pkg_version_localization pvl SET
modify_timestamp=(SELECT create_timestamp FROM haikudepot.pkg_version pv
WHERE pv.id=pvl.pkg_version_id);
-UPDATE haikudepot.pkg_version_localization pvl SET
create_timestamp=modify_timestamp;
-ALTER TABLE haikudepot.pkg_version_localization ALTER COLUMN
modify_timestamp SET NOT NULL;
-ALTER TABLE haikudepot.pkg_version_localization ALTER COLUMN
create_timestamp SET NOT NULL;
Other related posts:
- » [haiku-depot-web] [haiku-depot-web-app] push by haiku.li...@xxxxxxxxx - + fix for database schema migration on 2014-07-29 10:10 GMT - haiku-depot-web-app
