Archive old numbers

[pitpalme]

Maybe we should archive old/expired numbers, so performance of primary numbers table is kept high?

Additionally I don't know about reusage of numbers, so having it already stored with old timestamp might prevent it from being entered (in bad circumstances; unlikely, but possible).

One suggestion could be a regular cron job (maybe put into a shell skript):

sqlite3 --batch --cmd "BEGIN TRANSACTION;" lagesonr.db <<EOM
CREATE TABLE IF NOT EXISTS numbers_old(time TIMESTAMP NOT NULL, numbers VARCHAR(30) NOT NULL, user VARCHAR(10) NOT NULL, place VARCHAR(20) NOT  NULL, fingerprint VARCHAR(32) NOT NULL);
CREATE INDEX IF NOT EXISTS i_old_num ON numbers(number, fingerprint);
INSERT INTO numbers_old SELECT * FROM numbers WHERE time < date('now', '-30 days');
DELETE FROM numbers WHERE time < date('now', '-30 days');
COMMIT TRANSACTION;
EOM