etan39
/
cloudstack
mirror of https://github.com/apache/cloudstack.git
1
0
Fork 0
Code Issues Packages Projects Releases Wiki Activity
cloudstack/setup/db/db
History
Remi Bergsma 8f4abbc7bd disable foreign key checks when altering them 
Upgrades from 4.4 where not working properly due to errors like this:
ERROR 1833 (HY000): Cannot change column 'id': used in a foreign key constraint 'fk_global_load_balancing_rules_region_id' of table 'cloud.global_load_balancing_rules'

The disabling of the checks is for the current session only, so it's safe.

In the 4.4 branch, this file used to be at:
client/target/utilities/scripts/db/db/schema-442to450.sql

It's now moved. We need to edit it in 4.4 and 4.5 to have it effective.

This closes #164

Signed-off-by: Rohit Yadav <rohit.yadav@shapeblue.com>
 		2015-04-14 14:50:58 +05:30
..
data-217to218.sql applying the commits from Chip Childers licensing cleanup 2012-06-26 10:44:04 -04:00
schema-20to21.sql applying the commits from Chip Childers licensing cleanup 2012-06-26 10:44:04 -04:00
schema-21to22-cleanup.sql applying the commits from Chip Childers licensing cleanup 2012-06-26 10:44:04 -04:00
schema-21to22-premium.sql applying the commits from Chip Childers licensing cleanup 2012-06-26 10:44:04 -04:00
schema-21to22.sql applying the commits from Chip Childers licensing cleanup 2012-06-26 10:44:04 -04:00
schema-22beta1to22beta2.sql applying the commits from Chip Childers licensing cleanup 2012-06-26 10:44:04 -04:00
schema-22beta3to22beta4.sql applying the commits from Chip Childers licensing cleanup 2012-06-26 10:44:04 -04:00
schema-30to301.sql Ensuring system user has password set. 2012-10-07 12:51:52 -07:00
schema-40to410-cleanup.sql db: Fix Upgrade40to41 and add cleaning path schema-40to410-cleanup.sql 2013-02-16 12:28:00 +05:30
schema-40to410.sql CLOUDSTACK-6603 [Upgrade]DB Exception while Autoscale monitoring after upgrading from 4.3 to 4.4 2014-10-12 23:46:05 -04:00
schema-217to218.sql applying the commits from Chip Childers licensing cleanup 2012-06-26 10:44:04 -04:00
schema-221to222-cleanup.sql applying the commits from Chip Childers licensing cleanup 2012-06-26 10:44:04 -04:00
schema-221to222-premium.sql applying the commits from Chip Childers licensing cleanup 2012-06-26 10:44:04 -04:00
schema-221to222.sql applying the commits from Chip Childers licensing cleanup 2012-06-26 10:44:04 -04:00
schema-222to224-cleanup.sql applying the commits from Chip Childers licensing cleanup 2012-06-26 10:44:04 -04:00
schema-222to224-premium.sql applying the commits from Chip Childers licensing cleanup 2012-06-26 10:44:04 -04:00
schema-222to224.sql applying the commits from Chip Childers licensing cleanup 2012-06-26 10:44:04 -04:00
schema-224to225-cleanup.sql applying the commits from Chip Childers licensing cleanup 2012-06-26 10:44:04 -04:00
schema-224to225.sql applying the commits from Chip Childers licensing cleanup 2012-06-26 10:44:04 -04:00
schema-225to226.sql applying the commits from Chip Childers licensing cleanup 2012-06-26 10:44:04 -04:00
schema-227to228-premium.sql applying the commits from Chip Childers licensing cleanup 2012-06-26 10:44:04 -04:00
schema-227to228.sql applying the commits from Chip Childers licensing cleanup 2012-06-26 10:44:04 -04:00
schema-228to229.sql applying the commits from Chip Childers licensing cleanup 2012-06-26 10:44:04 -04:00
schema-229to2210.sql applying the commits from Chip Childers licensing cleanup 2012-06-26 10:44:04 -04:00
schema-301to302-cleanup.sql applying the commits from Chip Childers licensing cleanup 2012-06-26 10:44:04 -04:00
schema-301to302.sql Ensuring system user has password set. 2012-10-07 12:51:52 -07:00
schema-302to40-cleanup.sql Fixed version number in upgrade script comment (replaced 3.0.3 with 3.0.2) 2012-08-13 16:50:06 -07:00
schema-302to40.sql CLOUDSTACK-528: Config value has to be encrypted for Hidden category configs 2013-05-24 12:37:18 +05:30
schema-302to303.sql CLOUDSTACK-3936: db upgrade - added upgrade path from CCP 2.2.15,2.2.16 to CS 4.2 2013-07-30 10:53:23 -07:00
schema-304to305-cleanup.sql DB upgrade: upgraded the bunch of db upgrade files with Apache license header 2013-07-26 15:37:07 -07:00
schema-304to305.sql DB upgrade: upgraded the bunch of db upgrade files with Apache license header 2013-07-26 15:37:07 -07:00
schema-305to306-cleanup.sql DB upgrade: upgraded the bunch of db upgrade files with Apache license header 2013-07-26 15:37:07 -07:00
schema-305to306.sql DB upgrade: upgraded the bunch of db upgrade files with Apache license header 2013-07-26 15:37:07 -07:00
schema-306to307.sql DB upgrade: upgraded the bunch of db upgrade files with Apache license header 2013-07-26 15:37:07 -07:00
schema-307to410-cleanup.sql CLOUDSTACK-3898: fixed 303-42 db upgrade - handle situation when the field is already inserted, when try to insert it again with 41-42 upgrade 2013-07-29 10:43:04 -07:00
schema-307to410.sql CLOUDSTACK-3806: There was error in host_view sql, it was using host_details.id for join instead host_details.host_id 2013-08-27 06:17:47 +05:30
schema-410to420-cleanup.sql 41-42 db upgrade - added `cloud` db reference to the upgrade statements for remote access vpn 2013-04-02 11:11:18 -07:00
schema-410to420.sql Revert "CLOUDSTACK-6967: Initial OVM3 drop" 2014-06-24 10:24:01 +02:00
schema-420to421.sql Cloudstack-5077: reserve cpu and memory only when vmware.reserve.cpu/mem are set to true. Insted of setting the ovecommit values to one on upgrade, we popultate them from the global values. 2014-05-05 11:39:10 +05:30
schema-421to430-cleanup.sql Add upgrade path from 4.2.1 to 4.3.0. 2013-10-14 21:56:34 -07:00
schema-421to430.sql CLOUDSTACK-6204: removing realhostip dependency 2014-03-09 13:46:57 -07:00
schema-430to440-cleanup.sql CLOUDSTACK-6231: network acl item cidrs loaded from a seperate table 2014-04-30 15:39:00 +02:00
schema-430to440.sql CLOUDSTACK-6603 [Upgrade]DB Exception while Autoscale monitoring after upgrading from 4.3 to 4.4 2014-10-12 23:46:05 -04:00
schema-440to441-cleanup.sql schema: add upgrade path from 4.4.0 to 4.5.0 via 4.4.1 2014-07-29 00:21:39 +02:00
schema-440to441.sql cleaning more conflicts 2014-10-13 00:19:20 -04:00
schema-441to442.sql 4.4.2 upgrade schema 2014-11-24 16:25:44 +01:00
schema-442to450-cleanup.sql 4.4.2 upgrade schema 2014-11-24 16:25:44 +01:00
schema-442to450.sql disable foreign key checks when altering them 2015-04-14 14:50:58 +05:30
schema-450to451-cleanup.sql engine: Add Upgrade path from 4.5.0 to 4.5.1 2015-03-12 13:02:45 +05:30
schema-450to451.sql CLOUDSTACK-5236 : ability to identify where the user is from (ex. LDAP) 2015-03-16 14:53:53 +05:30
schema-451to460-cleanup.sql engine: Add Upgrade path from 4.5.0 to 4.5.1 2015-03-12 13:02:45 +05:30
schema-451to460.sql db: move bigswitch related sqls to schema-451to460.sql 2015-04-09 13:15:02 +05:30
schema-2210to2211.sql applying the commits from Chip Childers licensing cleanup 2012-06-26 10:44:04 -04:00
schema-2211to2212-premium.sql applying the commits from Chip Childers licensing cleanup 2012-06-26 10:44:04 -04:00
schema-2211to2212.sql applying the commits from Chip Childers licensing cleanup 2012-06-26 10:44:04 -04:00
schema-2212to2213.sql applying the commits from Chip Childers licensing cleanup 2012-06-26 10:44:04 -04:00
schema-2213to2214.sql applying the commits from Chip Childers licensing cleanup 2012-06-26 10:44:04 -04:00
schema-2214to30-cleanup.sql applying the commits from Chip Childers licensing cleanup 2012-06-26 10:44:04 -04:00
schema-2214to30.sql CLOUDSTACK-3005: fix template_spool_ref.local_patch error after upgrade from 2.2.14 to 3.X 2013-06-14 10:32:47 +02:00
schema-level.sql applying the commits from Chip Childers licensing cleanup 2012-06-26 10:44:04 -04:00
schema-snapshot-217to224.sql applying the commits from Chip Childers licensing cleanup 2012-06-26 10:44:04 -04:00
schema-snapshot-223to224.sql applying the commits from Chip Childers licensing cleanup 2012-06-26 10:44:04 -04:00