Page 1 of 1

Database objects of new application

PostPosted: Mon Nov 19, 2018 2:47 pm
by johnit
If I create a new application with VisionX, which database objects are important? If I do a manual database export, which objects are required.

Re: Database objects of new application

PostPosted: Mon Nov 19, 2018 2:51 pm
by Support@SIB
All objects which were created during application creation are important:

Tables: AUTOLOGIN, ROLES, USERS, WORKSCREENS, USER_ROLE, ROLE_WOSC
Views: V_ACCESSRULES, V_USERROLES, V_USERSCREENS

These objects are needed, if you create a standard VisionX application.

A new work-screen will be inserted in WORKSCREENS and the role reference will be inserted in ROLE_WOSC.

ROLES and USER_ROLE are not relevant for new workscreens, but relevant for security.

AUTOLOGIN is an optional table. It can be used for automatic user logins (by auth key). If this table is not available, the application will also work.