On 30 March 2017 at 08:08, Saverio Proto <saverio.pr...@switch.ch> wrote:
> Hello, > > I am testing the neutron l2gw in our staging env. > > Because I cant redeploy everything, to retry the installation of the > l2gw, to clean the database I drop the following tables from the neutron > database: > > drop table physical_ports; > drop table physical_locators; > drop table physical_switches; > drop table logical_switches; > drop table ucast_macs_remotes; > drop table ucast_macs_locals; > drop table vlan_bindings; > drop table pending_ucast_macs_remotes; > drop table l2gatewayinterfaces; > drop table l2gatewaydevices; > drop table l2gatewayconnections; > drop table l2gateways; > drop table l2gw_alembic_version; > > I would strongly suggest to have a common prefix like l2gw_ for all the > tables that belong to the same neutron plugin. > > How can I figure out if I missed a table without reading all the code ? > There's no written rule to prefix tables with formal labels. IMO it would largely fail as a rule in practice even if we wrote one down. Have you considered taking a backup of your DB prior to the migration so that you can restore from it? Thanks, Armando > Thank you > > Saverio > > > > -- > SWITCH > Saverio Proto, Peta Solutions > Werdstrasse 2, P.O. Box, 8021 Zurich, Switzerland > phone +41 44 268 15 15, direct +41 44 268 1573 > saverio.pr...@switch.ch, http://www.switch.ch > > http://www.switch.ch/stories > > __________________________________________________________________________ > OpenStack Development Mailing List (not for usage questions) > Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev >
__________________________________________________________________________ OpenStack Development Mailing List (not for usage questions) Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev