[jbpm-issues] [JBoss JIRA] Resolved: (JBPM-2410) clean up obsolete qa dbs

[ https://jira.jboss.org/jira/browse/JBPM-2410?page=com.atlassian.jira.plug... ] Joram Barrez resolved JBPM-2410. -------------------------------- Resolution: Done Used Squirel v3.0.2 (http://www.squirrelsql.org/), 'drop table' script Specific drop statements / database: * MySQL: SET FOREIGN_KEY_CHECKS=0; drop table a; drop table b; SET FOREIGN_KEY_CHECKS=1; * Postgres: DROP TABLE a CASCADE; DROP TABLE b CASCADE; * Oracle: Connecting to the Oracle DB on the qa lab takes several minutes. It is easier to use the SqlDeveloper tool from Oracle itself (http://www.oracle.com/technology/products/database/sql_developer/index.html): DROP TABLE a CASCADE constraints; DROP TABLE b CASCADE constraints; If in the future this work is needed again, it may be better to create a script for it ... so keep your unit tests clean ;-) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira