Version 2, last updated by gijzelaerr at 07 Feb 14:52 UTC

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.

database design