search

coldbox-modules / cfmigrations

MIT License
11 stars 8 forks source link

Cfmigration table detected in all available schemes instead of current database #8

Closed wpdebruin closed 5 years ago

wpdebruin commented 6 years ago

Ok, I just tested this in MySQL the point is compileTableExists fires this query SELECT 1 FROM information_schema.tablesWHEREtable_name= 'cfmigrations' if Laur and you are both using the same credentials for your databases you will indeed see each others db. If you would use separate credentials for each db, which is more secure anyway, you will not have this problem

elpete [4:53 PM] qb doesn’t see the connection string. It just uses it. There may be a way to get it from Java, but I think the easier path is to have hasTable take an optional schema parameter.

cvonstetten commented 6 years ago

I'm going to hazard a guess that the same issue will apply to MS SQL, but I haven't verified this.

elpete commented 5 years ago

This is solved by providing a schema to the MigrationService.