### Initializing the database system as a non-admin database user

The database initialization system allows you to use a non-admin database user for JReport Enterprise Server. However, the database initialization has to be divided into three phases:

1. The database administrator creates new database tables using script files.
2. The non-admin database user starts JReport Enterprise Server. In this phase, the old version's database tables will be updated if they exist. If the server has updated the old version's table data, you will be able to see a record of it in the debug file.
3. The database administrator deletes the old version' tables in the database using script files.

#### Script files

JReport Enterprise Server supports these different databases: HSQLDB, Microsoft Access, MySQL, Microsoft SQL Server, IBM DB2, Oracle, Sybase, and Informix.

The script files are stored in `<install_root>\script_files`. There are three types of script files:

##### Script files used for creating new database tables

The following files are used to create new database tables, and are stored in `<install_root>\script_files\create_new_tables`:

- hsqldb_c.txt - Creates new tables for HSQLDB database.
- access_c.txt - Creates new tables for Microsoft Access database.
- mysql_c.txt - Creates new tables for MySQL database.
- sqlserver2000_c.txt - Creates new tables for Microsoft SQL Server database.
- db2_c.txt - Creates new tables for DB2 database.
- oracle_c.txt - Creates new tables for Oracle database.
- sybase_c.txt - Creates new tables for Sybase database.
- informix_c.txt - Creates new tables for Informix database.

##### Script files used for deleting the old version' tables

The following files are used to delete the old version' tables, and are stored in `<install_root>\script_files\delete_old_tables`:

- hsqldb_do.txt - Deletes old version tables for HSQLDB database.
- access_do.txt - Deletes old version tables for Microsoft Access database.
- mysql_do.txt - Deletes old version tables for MySQL database.
- sqlserver2000_do.txt - Deletes old version tables for Microsoft SQL Server database.
- db2_do.txt - Deletes old version tables for DB2 database.
- oracle_do.txt - Deletes old version tables for Oracle database.
- sybase_do.txt - Deletes old version tables for Sybase database.
- informix_do.txt - Deletes old version tables for Informix database.

##### Script files used for deleting the current version' tables

The following files are used to delete the current version' tables, and are stored in `<install_root>\script_files\delete_current_tables`:

- hsqldb_dc.txt - Deletes current version tables for HSQLDB database.
- access_dc.txt - Deletes current version tables for Microsoft Access database.
- mysql_dc.txt - Deletes current version tables for MySQL database.
- sqlserver2000_dc.txt - Deletes current version tables for Microsoft SQL Server database.
- db2_dc.txt - Deletes current version tables for DB2 database.
- oracle_dc.txt - Deletes current version tables for Oracle database.
- sybase_dc.txt - Deletes current version tables for Sybase database.
- informix_dc.txt - Deletes current version tables for Informix database.