Version 2, last updated by gijzelaerr at 07 Feb 14:52 UTC
Technical design - SQL
SQL
scripts/filesender_db.sql
Description: This file is used to populate a database.
The script creates 2 tables, files and logs. files is used to store information about uploaded files. The logs table is used for storing all events.
There are also 2 sequences, log_id_seq and download_id_seq. download_id_seq is unused, log_id_seq is used for the auto incrementation of a new logid. This can be replaced by the 'serial' field in future versions.
