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) |
||
| (One intermediate revision by the same user not shown) | |||
| 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%" | ||
| Line 48: | Line 50: | ||
[[Category:Reference]] | [[Category:Reference]] | ||
[[Category:Lianja v5.3]] | [[Category:Lianja v5.3]] | ||
| + | [[Category:System Tables]] | ||
Latest revision as of 09:37, 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
