Usage notes for SQL scripts to cleanup access log data in a 5.4.1 database
--------------------------------------------------------------------------

In this folder there are two sql scripts, which do the same, but for different database systems:

1. cleanup_access_log_sqlite.sql
   MUST ONLY BE USED if your G/On database is installed in the SQLite database system (the one built into G/On)

2. cleanup_access_log_mssql.sql
   MUST ONLY BE USED if your G/On database is installed in a Microsoft SQL-Server database system



Both scripts delete all access log data concerning user sessions, which were started prior to a given cut-off date.

Use the scripts as follows: 

1) Make sure you have a backup of your database. This is needed in case something goes wrong during the next step,
   and in case you later want to retrieve the old (deleted) access log entries.

2) Edit the script for your type of database, using notepad. In the top of the script, define the cut-off date.
   The default, if you do not edit the file is that the cut-off date is three months prior to today.

3) Run the script using your favorite SQL tool. For SQLite, you can for instance use the Firefox
   browser, with the extension: SQLite Manager. 

4) After running the script, make sure your changes are committed. For SQLite, this is done by saving the 
   changed database.