Andy Jarrett // Code. Develop. Manage.

Changing UUIDs for INTs in Soundings

Soundings is a great survey app written in CFML by Ray Camden.

My only issue is that the keys are all 35 character UUID's which is fine but sucks for indexing. Below is a script which goes through the application and changes them all to INTS. (Should note that this is for MySQL tables.)

Please note this is still part 1 though. In the Soundings app itself you still need to remove the createUUID() functions if/when you want to add questions etc.

I've made the code available via Gist on github at https://gist.github.com/989931


I’m here, learning and working away. If you liked this content and want to keep me going, consider buying me a coffee.
Your support keeps this site running and the coffee brewing! ☕️