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));