Set up database schemes

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

CREATE DATABASE databasename
CHARACTER SET utf8
COLLATE utf8_bin;

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.

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

CREATE DATABASE databasename
OWNER = role_name
ENCODING = UTF8;

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

• Currently, only the usage of Latin-1 characters (ISO/IEC 8859-1) will work properly in LUY. It is 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.

Before setting up a LUY database, ensure that the right settings are entered for character set and collation, enabling text in German and English each to be stored correctly. The following properties are required for the database user schema when using an Oracle database system:

• Default character set: WE8ISO8859P1 (or a superset like AL32UTF8)

• Country specific character set: AL16UTF16

• Roles for the database user:

  • CONNECT

• Rights for the database user:

  • CREATE SEQUENCE

  • CREATE TABLE

• Tablespace/quota: Minimum of 10MB, but we recommend 100-200MB and adequate quota for this user on the assigned table space. To provide an unlimited quota, adapt and execute this command:

  • ALTER USER <username> QUOTA UNLIMITED ON <schemaname>;