Created new application db in mySQL Workbench for tracking bugs

1.0 Complete.
Having become more familiar with this tool, now able to crank out new apps much faster. the sync function is amazing. Had to watch out a bit for the fact that you can enter defaults in non-varchar fields that are not valid and also datatypes not used in mysql so then the sync stop working but if you change the datatype in workbench for the relevant fields to what is available in mysql (and what workbench itself would convert it into) sync is ok again.
It's also helpful to hide the 'user stamps' relationships that all tables have to the user table for create/update user id stamps (diagram is too messy otherwise).
Note when changing table/column names, sometimes indexes don't change names, so can be good to change them manually for consistency (though not required).

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s