Table: System
System properties are stored as a combination of parameter name and value. It is highly recommended not to change any entry.
| ColumnName | DataType | Key | Not Null | Default Value | Comment |
|---|---|---|---|---|---|
| SystemID | INTEGER | PK | NN | ||
| ParamName | NVARCHAR(255) | NN | |||
| ParamVal | NVARCHAR(255) | NN |
| IndexName | IndexType | Columns |
|---|---|---|
| PRIMARY | PRIMARY | SystemID |
how to create
CREATE TABLE System(
SystemID INTEGER NOT NULL,
ParamName NVARCHAR(255) NOT NULL,
ParamVal NVARCHAR(255) NOT NULL,
PRIMARY KEY (SystemID));

