SYSAPPS

From Lianjapedia
Jump to: navigation, search

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