On Thu, 28 Jan 2010, Victor Engmark wrote: >> All the ones from tabcreate.sql are in tabdrop.sql. The problem is with >> dynamic tables, created on run time by the admins, such as new ``book >> price'' index, etc. See my other email. > > That's odd, because I would have thought at least inveniocfg would be > aware of the tables /it/ has created, which doesn't seem to be the > case (--load-webstat-conf creates table staEVENT01, which is not > removed by --drop-tables).
Currently, `--drop-tables' removes tables created by `--create-tables'. It is a mirror option. `--load-webstat-conf' does not have its `--unload-webstat-conf' mirror option. It should probably behave as `--reload-webstat-conf'; that is, destroy whatever WebStat config is in place, and load the new config from the file. >> This would be dangerous, since some Invenio installations can choose >> storing their custom tables we don't know anything about. E.g. some >> Invenio installations use their own submission systems, not WebSubmit. >> inveniocfg --drop-tables should drop only tables managed by Invenio >> core. > > Who is going to rewrite all the code that we use to create dynamic > tables, so that Invenio tables are recorded somewhere? No need for that. We know what they are (idxWORD33F, etc) so we can code their deletion. Best regards -- Tibor Simko ** CERN Document Server ** <http://cds.cern.ch/>
