Set up database schemes with docker

To effectively use LUY, a Database Management System (DBMS) is required. The process of creating a database schema for LUY is outlined on this page.

Additionally, our iTURM identity management solution, integrated in LUY, requires a separate database dedicated to storing authentication and authorization data.

MySQL / MariaDB

Before setting up a LUY database, ensure that the right settings are entered for character set and collation, enabling text both in German and English to be stored correctly. Therefore, set up the LUY database with the following SQL command:

CREATE DATABASE databasename
CHARACTER SET utf8
COLLATE utf8_general_ci;

After that, create a new database user with full access privileges for the LUY database. The following SQL commands are required to give this user both local and remote access to the database:

GRANT ALL PRIVILEGES
ON databasename.*
TO 'username'@'localhost'
IDENTIFIED BY 'userpassword';

If the user in question does not already exist, executing these commands will automatically create a new user.

MS SQL Server

Before setting up a LUY database, ensure that the right settings are entered for character set and collation, enabling text both in German and English each to be stored correctly. Therefore, set up the LUY database, e.g., with Microsoft SQL Server Management Studio:

Currently, exclusively Latin-1 characters (ISO/IEC 8859-1) work properly in LUY. It is therefore recommended to set up the database with the standard collation Latin1_General_CI_AS.
The server login used for LUY must have sufficient privileges to create and alter tables insert, update, delete data. Please ensure that you run the installer and migration/initialization/repair scripts with the login that you configured for the LUY application. This is necessary because the login user's default schema must be the same schema which contains the tables for LUY.
We recommend using server authentication with a local SQL user username and password. The Windows authentication method is more elaborate and needs additionally configured infrastructure.