After downloading the source code, you can find actual database dumps in the 'sql'-directory. Before importing, create the databases as root:

CREATE DATABASE idoit_beta_sys; CREATE DATABASE idoit_beta_data;

Now import both SQL files into your mySQL 4.1 database:

mysql -h db-host -P db-post -u user -p pass -D idoit_beta_sys < \ setup/sql/idoit_beta_system.sql mysql -h db-host -P db-post -u user -p pass -D idoit_beta_data < \ setup/sql/idoit_beta_data.sql

And give your database-user access rights to the databases:

GRANT ALL PRIVILEGES ON idoit_beta_sys.* TO 'i-doit'@'%' IDENTIFIED BY \ 'we-doit' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON idoit_beta_data.* TO 'i-doit'@'%' IDENTIFIED BY \ 'we-doit' WITH GRANT OPTION;

i-doIT is partitioned across one mandatory system database (in our case idoit_beta_sys) and at least one mandator database (idoit_beta_data). In the system database system and language constants are stored, furthermore the global i-doIT registry and references to all available mandator databases in the table 'isys_mandator'. Let's create at one entry here:

INSERT INTO isys_mandator VALUES( '%', 'Your company name', 'Your company description', 'cache_your_company', 'default', 'localhost', '3306', 'idoit_beta_data', 'i-doit', 'we-doit', '1', 'ISYS_LANGUAGE_GERMAN', // Or use ISYS_LANGUAGE_ENGLISH here 'de' );

If you want to use an english i-doIT version, use ISYS_LANGUAGE_ENGLISH for the XML-Parameter 'isys_mandator__default_lang_const' and 'en' for 'isys_mandator__default_language_short'.

These are the record information for one mandator database, configure this in order to modify mandator-specific database settings.