Hey David, The upgrade script is updated, was a bit more work than I expected as the unique constraint was unnamed.
Cheers, Hugo -----Original Message----- From: David Nalley [mailto:[email protected]] Sent: Monday, July 30, 2012 2:55 PM To: [email protected] Subject: Re: git commit: rrq 5839: This table should not have a contraint on device and physical network id. This is dealt with in the code and by using the removed field. This changes needs to be propagated to the upgrade scripts as well, otherwise the item you removed will persist in upgrades. --David On Mon, Jul 30, 2012 at 2:47 AM, <[email protected]> wrote: > Updated Branches: > refs/heads/master 3313cc4a8 -> 894407caa > > > rrq 5839: This table should not have a contraint on device and physical > network id. This is dealt with in the code and by using the removed field. > > > Project: > http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/repo > Commit: > http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/commit/894 > 407ca > Tree: > http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/tree/89440 > 7ca > Diff: > http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/diff/89440 > 7ca > > Branch: refs/heads/master > Commit: 894407caa97ecd5b4f034de6b3b0e4deadd253e4 > Parents: 3313cc4 > Author: Hugo Trippaers <[email protected]> > Authored: Mon Jul 30 08:46:56 2012 +0200 > Committer: Hugo Trippaers <[email protected]> > Committed: Mon Jul 30 08:46:56 2012 +0200 > > ---------------------------------------------------------------------- > setup/db/create-schema.sql | 1 - > 1 files changed, 0 insertions(+), 1 deletions(-) > ---------------------------------------------------------------------- > > > http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/blob/89440 > 7ca/setup/db/create-schema.sql > ---------------------------------------------------------------------- > diff --git a/setup/db/create-schema.sql b/setup/db/create-schema.sql > index ae5f581..dc9e7b0 100755 > --- a/setup/db/create-schema.sql > +++ b/setup/db/create-schema.sql > @@ -2000,7 +2000,6 @@ CREATE TABLE > `cloud`.`physical_network_service_providers` ( > PRIMARY KEY (`id`), > CONSTRAINT `fk_pnetwork_service_providers__physical_network_id` FOREIGN > KEY (`physical_network_id`) REFERENCES `physical_network`(`id`) ON DELETE > CASCADE, > CONSTRAINT `uc_service_providers__uuid` UNIQUE (`uuid`), > - UNIQUE KEY(`physical_network_id`, `provider_name`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8; > > CREATE TABLE `cloud`.`external_load_balancer_devices` ( >
