Installation
Configuration
Administration
Usage
Development
F.A.Q.
Step 2. Create Database
MySQL
You have to create initial data schema by executing '/tools/sql/mysql50.sql' script. This script will create database named 'etraxis' and all required tables. If you would like to have database with another name, please change following lines accordingly:
create database etraxis; use etraxis;
Also this script will create one predefined user with 'root' login, empty password and administrator permissions. You may use this account for first log in eTraxis. Please do not forget to set its password!
Microsoft SQL Server
You have to create initial data schema by executing '/tools/sql/mssql2k.sql' script. This script will create database named 'etraxis' and all required tables. If you would like to have database with another name, please change following lines accordingly:
create database etraxis; use etraxis;
Also this script will create one predefined user with 'root' login, empty password and administrator permissions. You may use this account for first log in eTraxis. Please do not forget to set its password!
Oracle
You have to create initial data schema by executing '/tools/sql/ora9i.sql' script. Before executing the script you have to create new Oracle user that will be used to work with database. The script will connect to database as this user and create all required tables. Please set valid username, password and database in the following line before executing the script:
connect etraxis/password@database;
Also this script will create one predefined user with 'root' login, empty password and administrator permissions. You may use this account for first log in eTraxis. Please do not forget to set its password!
PostgreSQL
At first you have to create new database by executing the following SQL command (if you would like to have database with another name, please change the command accordingly):
create database etraxis with encoding 'unicode'
The important thing here is to use UNICODE as encoding of the database. When database is created, you have to create initial data schema by executing '/tools/sql/pgsql80.sql' script, which will create all required tables. Also this script will create one predefined user with 'root' login, empty password and administrator permissions. You may use this account for first log in eTraxis. Please do not forget to set its password!
Last update: 2009-10-10