search

chucknorris / roundhouse

RoundhousE is a Database Migration Utility for .NET using sql files and versioning based on source control
http://projectroundhouse.org
916 stars 249 forks source link

Add templates for implicit indexes #197

Open sliekens opened 9 years ago

sliekens commented 9 years ago

The wiki has a drop-create template for user-defined indexes, but fails to even mention implicit indexes that are created for primary keys/unique constraints. It's not clear if primary keys/unique constraints belong in the "indexes" folder.

ferventcoder commented 9 years ago

You think this should just be a documentation add? Implicitly created ones are probably best handled by the database, but if someone wants to be explicit about them, they could potentially put them in the indexes folder and do all of the working against with the database to get them in inside the scripts.

sliekens commented 9 years ago

I don't know. I'm still learning the difference between OneTime and AnyTime scripts, and when or why I should use one over the other. I raised this issue because I genuinely don't know where to put primary keys/unique constraints.

ferventcoder commented 9 years ago

If the database implicitly creates those and you are not doing anything special for them, it's better to let the database handle those.