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, <h...@apache.org> 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/894407ca > Tree: > http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/tree/894407ca > Diff: > http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/diff/894407ca > > Branch: refs/heads/master > Commit: 894407caa97ecd5b4f034de6b3b0e4deadd253e4 > Parents: 3313cc4 > Author: Hugo Trippaers <htrippa...@schubergphilis.com> > Authored: Mon Jul 30 08:46:56 2012 +0200 > Committer: Hugo Trippaers <htrippa...@schubergphilis.com> > 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/894407ca/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` ( >
