Database |
Top Previous Next |
The database is based on Microsoft Northwind database.
The primary keys where replaced with string 12 characters codes. Two fields where added to each table: - sid - code of the last user who modified the record - mdl - datetime of the last update of the record
There are three databases servers to chose from:
- Ms. SQL database - PostgreSQL - Sqlite 3.0
The application work in the same manner with all of them (Sqlite 3.0 can be used with fewer users only).
By default the server is installed with the Sqlite 3.0 database as there no installation is required for the database.
The databases backups for PostgreSql and Ms. SQL are in the DB_back directory. To change the database just install the databases from backup and modify the server connection strings as follow.
There are two connections strings to be modified: - server main connection (server configuration program) - reports management - connections
Samples of connection strings:
|