Difference between revisions of "SYSAPPS"
From Lianjapedia
Yvonne.milne (Talk | contribs) (Created page with "==Purpose== System table for Lianja Cloud Server deployed Apps ==See Also== A Guide to Deploying Web Apps, Deployment, :Category:System Tables|...") |
Yvonne.milne (Talk | contribs) (→Description) |
||
Line 6: | Line 6: | ||
==Description== | ==Description== | ||
− | The sysapps table | + | 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. | ||
{| class="wikitable" width="100%" | {| class="wikitable" width="100%" |
Revision as of 06:29, 22 April 2020
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