Schema

A schema is a set of database tables, and is used by the application to store timesheet data and settings. If you are hosting the application yourself you can review your schema settings, as well as edit or create a new schema. Normally you would use the schema created by the installer and never change these settings. But if you would like to use an external database like Microsoft SQL Server or Oracle, or if you installed the WAR version of the application, you will need to create a new schema before you can use the system.

For a list of supported databases and versions refer to the System Requirements topic. The installer provides the following database:

The Schema page is located at the following address:

http://localhost/timesheet/system/db-show.do

If you changed the default HTTP port from 80 then you will need to specify the port number, too, for example:

http://localhost:8080/timesheet/system/db-show.do

This will load a page showing the current schema configuration. You can edit this schema configuration by clicking the Edit button, or create a new schema by clicking the Create button. Note that for security reasons you need to be using a browser on the same machine that the application is installed on.

Editing the schema configuration will not alter the schema, just the settings that the application uses to connect to the schema. Creating a new schema will not delete or alter the old schema, but will create a new schema and update the settings so that the application will use the new one.

Schema Properties

Database Type

The type of database management system (DBMS) to be used. The following types are supported:

Server Address

The TCP/IP address or host name of the database server. Use localhost if the database server is running on the same computer as the application.

Server Port

The TCP/IP port number used by the database server. The value will default to the number appropriate for the database type, which is generally the value you want to use.

Schema Name/Oracle SID

For Microsoft and MySQL the schema name is the name of the database. For Oracle you would use the SID (Server IDentifier).

Login Name

The login name for the database account to use when connecting to the database server.

Password

The password for the login.

When creating a new schema you have the following additional properties:

Admin Login

The login name for the administrative account for the database server. Note that if creating a new schema or database using the bundled MySQL database, the default administrative login is root with the password is timesheet.

Admin Password

The password for the administrative account. Note that if creating a new schema or database using the bundled MySQL database, the default administrative login is root with the password is timesheet.

New Schema Name

For Microsoft and MySQL this is the name of the new database to create. For Oracle this is the name of the new tablespace to create.

New Login

The login name for the new database account to use when connecting to the database server.

New Password

The password for the new login.