Table: Local
Each entry describes an application of type APPLTYPE_LOCALSHELL.
ColumnName | DataType | Key | Not Null | Default Value | Comment | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ApplicationID | INTEGER | PK, FK | NN | Unique application ID (foreign key refers to table Application) | |||||||||||||||||||||||
Type | NVARCHAR(255) | Local
application type
|
|||||||||||||||||||||||||
Parameter | NVARCHAR(255) | Command
line parameter string For custom applications, this is the complete command string including all parameters |
|||||||||||||||||||||||||
Hidden | SMALLINT(6) | Application
is hidden to the user 0|1 |
|||||||||||||||||||||||||
ReservedString1 | NVARCHAR(255) | ||||||||||||||||||||||||||
ReservedString2 | NVARCHAR(255) | ||||||||||||||||||||||||||
ReservedInt1 | INTEGER | ||||||||||||||||||||||||||
ReservedInt2 | INTEGER |
IndexName | IndexType | Columns |
---|---|---|
PRIMARY | PRIMARY | ApplicationID |
How to create
CREATE TABLE Local(
ApplicationID INTEGER NOT NULL,
Type NVARCHAR(255),
Parameter NVARCHAR(255),
Hidden SMALLINT,
ReservedString1 NVARCHAR(255),
ReservedString2 NVARCHAR(255),
ReservedInt1 INTEGER,
ReservedInt2 INTEGER,
CONSTRAINT FK_LocalApplicationID_Application_ApplicationID FOREIGN KEY (ApplicationID) REFERENCES Application (ApplicationID),
PRIMARY KEY (ApplicationID));