XF 1.5 Is it possible to clear styles via SQL query?

[Ozan Çorumlu]

Hello everyone. I have a question about deleting and clearing styles except the default one from site.

When we create a new style it's ID become after the last one. For example if latest installed style's ID is 12, new style will be with the ID 13.

So, is it possible to reset all style IDs? What I mean is: I'll delete all styles except the default which's ID is 1. When I install a style it's ID will be 2 instead of 13, 14, 15...

 

[Chris D]

I don't recommend doing this at all. Is there a reason to do this?

If you uninstall all of the styles you want, you could reset the AUTO_INCREMENT value on the xf_style table, but this isn't recommend and could have other repercussions.