Rename oc_filecache to oc_fileindex

[PVince81]

The problem:

• many people believe this table is just a cache that can be cleared and sometimes resort to clearing it
• clearing the file cache loses association of shares, tags, etc with files

Solution:

• rename oc_filecache to oc_fileindex

Also: the file cache table is really more an index or a metadata index than a cache.
If people do find about old blogs advising to clear oc_filecache, they won't find this table.
Having the table as oc_fileindex will give the impression that it is something different, so more of a psychological solution 😄

Not sure if the table can be rename properly with a change of db_structure.xml.

@icewind1991 @DeepDiver1975 @karlitschek @schiesbn @nickvergessen

[DeepDiver1975]

Well - people need to learn not to play around with the database.

Regarding the migration - db_structure.xml cannot handle this.

I vote for won't fix

[MorrisJobke]

I also think that this will add more trouble. Don't mess around with the DB - that's it.

[PVince81]

Okay, thanks for the feedback.

[ghost]

don't truncate the filecache table, EVER. You will lose data. Don't do it. Don't!!!!

[gael-ian]

Well - people need to learn not to play around with the database.

So don't give them a way to do it easily via occ

[PVince81]

@gael-ian I wasn't aware that there was an occ command to allow this... Will investigate and destroy it

[PVince81]

There's a command occ files:cleanup. I tested it and it doesn't clear the file cache but only tries to repair and remove orphaned entries.

[lock]

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.