diff options
author | Yorhel <git@yorhel.nl> | 2015-10-12 19:25:37 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2015-10-17 17:20:41 +0200 |
commit | eed1eced579e022135f98f3f733ecab88e3b6b6e (patch) | |
tree | 88e15c1475a9bf4f7b15c2c6ff1661fb52b77716 /util/sqleditfunc.pl | |
parent | 61251790bd1da10eebee3c56a70a9711e7680ce8 (diff) |
SQL: Convert all item-tables to a different schema
This commit breaks pretty much everything. Lots of code will have to be
fixed to work with this new schema.
The basic idea is to separate live data from archived data, which allows
for smaller and more effective indices on the live data, and the
archived data doesn't need such indices and have to be accessed at all
for most operations. Another goal is to eliminate table joins to fetch
some necessary information, e.g. it's not necessary anymore to join the
main item tables in order to fetch only the latest revision of some item
data.
This is very much work in progress. I might stumble upon some weird
issue while fixing the code, and might have to redesign everything
from scratch again. Let's just see how things go.
Diffstat (limited to 'util/sqleditfunc.pl')
0 files changed, 0 insertions, 0 deletions