Create Database

Creates a database.

Permissions

Command Kind	Needed User Kind
System	Sys, SysTech

Parameters

Name	Type	Description	Required	Default	Values
Database	string	Name of the database ([Database]).	yes
Directory	string	Directory on the server where the files are saved.	yes
AdminPassword	string	Password for the 'Admin' user.	no
Catalog	boolean	If 'True' the database is visible in the 'Show Database Catalog' command. The default value is 'False'.	no	false
CreateAdmin	boolean	If 'True' the 'Admin' user is created. The default value is 'False'.	no	false
CreateDirectory	boolean	If 'True' and the directory does not exist, then the directory is created. The default value is 'False'.	no	false
OffsetMonth	integer	If the fiscal year does not start in january, its start month must be set (1=jan. till 12=dec.) The default value is '1' (jan.).	no	1

Result

Name	Type	Description
Database	string	Name of the database.
Directory	string	Database directory on the server.
Loaded	string	Datetime when the database was loaded.
Saved	string	Last date and time when the database was saved from memory to disk.
SaveEnabled	boolean	If 'True' the database can be saved. It is a temporary value that is not saved in the database settings.
Catalog	boolean	If 'True' the database is visible in the 'Show Database Catalog' command.
OffsetMonth	integer	Start month of the fiscal year (1=jan. till 12=dec.).
WebDirectory	string	Protects a web service directory with 'BasicAuth'. If a value is set, a valid username and password of the database must be used to access the web service directory. E.g. '/MyFiles/SecretFiles/' protects a directory and '/' protects the whole web service.
Dimensions	integer	Number of database dimensions.
Tables	integer	Number of database tables.
Links	integer	Number of database links.
Calculations	integer	Number of database calculations.
Commands	integer	Number of database commands.
CommandGroups	integer	Number of database command groups.
Scripts	integer	Number of database scripts.
Texts	integer	Number of database texts.
UsersTotal	integer	Number of database users (active and inactive).
UsersActive	integer	Number of active database users.
Roles	integer	Number of database roles.
Variables	integer	Number of database variables.
Connections	integer	Number of active database connections.

Code

CREATE DATABASE
DATABASE=[string, Needed]
DIRECTORY=[string, Needed]
ADMINPASSWORD=[string]
CATALOG=[boolean, default=false]
CREATEADMIN=[boolean, default=false]
CREATEDIRECTORY=[boolean, default=false]
OFFSETMONTH=[integer, default=1]