Playing With Alfresco - INDEX KEY (Duplicate key name 'FK_BYTEBLOCK_FILE')

I started playing with Alfresco a while ago and started noticing some issues. This would help others who run to same problems and also myself in the sense that I have a place to check so that I don't waste much time trying to retrace my steps. .

I found the information here useful: http://michielverkaik.blogspot.com/2010/05/recreating-alfresco-instance.html