I notice that when I delete a web the webid will not get reused even after emptying the recycle bin. Is there a single value in the ispconfig database where I can set this down? (I ask because we are going to transfer several servers from confixx and we want to keep the numbering scheme. Once in a while it may happen that we need to start over with a web because of wrong information typed in - in that case I would like to remove it and then reset the webid as well.)
This happens because the database tables use AUTO_INCREMENT for the doc_id column. You cannot change this.
Ah, right, thanks. I actually think you *can* change that. You can reset the auto_increment value in isp_isp_web and be done. I'll try that, thanks for the hint!
What you should do is run a bunch of queries to see what depends on that auto_increment column first before resetting it. That way you can fix any constraints while resetting. I'm not sure how mysql does it but postgresql stores all of its dependencies | foreign | primary keys in system tables which you can query.
Well, the point is that I want to remove a web in ISPConfig and decrement the auto_increment, so that the next web created gets the same web_id as the deleted web, so that the paths and users don't get out of sync with the old server. Once you remove a web within ISPConfig there should be *no* reference to it anywhere in the database. So it should be safe to set the auto_increment to the desired value. I just tested this. I removed alle customers and all webs and then reset the auto_increment value in each of the isp_isp_* tables either to 1 or to a value that made sense (if there was still a record in the table). I then tested by adding a few customers and domains. Works just fine and web started again from no. 1. So, if you know what you do it just works. Just in case one needs it ... (falko, this is *not* the test setup where I have this bogus domain appearing - just in case you think I messed that with some kind of testing like this. ;-) That one is another testing setup and got only managed by adding and removing domains in ISPConfig and emptying the trash!)
