08-25-2016, 07:01 PM
I can't think of an easy way to do this.
My thought would be to temporarily rename your table to settings3. Install userspice. Rename the userspice table to settings2 and your settings 3 back to settings.
From there you can do a find/replace and there are only a few changes...
To take care of the queries...
Find
FROM settings
replace with
FROM settings2
To take care of the times we update the settings....
update('settings'
and replace with
update('settings2'
My gut says userspice will work fine if you do that. If not, you can always reinstall.
My thought would be to temporarily rename your table to settings3. Install userspice. Rename the userspice table to settings2 and your settings 3 back to settings.
From there you can do a find/replace and there are only a few changes...
To take care of the queries...
Find
FROM settings
replace with
FROM settings2
To take care of the times we update the settings....
update('settings'
and replace with
update('settings2'
My gut says userspice will work fine if you do that. If not, you can always reinstall.