SYSAPPS
From Lianjapedia
Contents
Purpose
System table for Lianja Cloud Server deployed Apps
See Also
A Guide to Deploying Web Apps, Deployment, System Tables
Description
System Tables are system defined read-only tables. You can query these tables using the SELECT statement.
The sysapps table returns information on the Lianja Cloud Server deployed Apps.
| Column | Data Type | Width | Description |
|---|---|---|---|
| AUTHOR | C | 80 | App author. |
| CATEGORY | C | 80 | App App Center Tile category. |
| APP | C | 80 | App name. |
| VERSION | C | 25 | App version. |
| BUILDMODE | C | 25 | App build mode: Debug or Release. |
| CAPTION | C | 80 | App App Center Tile caption. |
| PERMCREATE | C | 255 | App create permission roles. |
| PERMREAD | C | 255 | App read permission roles. |
| PERMUPDATE | C | 255 | App update permission roles. |
| PERMDELETE | C | 255 | App delete permission roles. |
| DATE | C | 255 | App last modification date. |
| TIME | C | 255 | App last modification time. |
Supported from Lianja v5.3.
Example
select * from sysapps
