Using System State Manager › Create Other Resource and Action Tables › Decide How Many Tables to Define › Sample SQL statement defining an action table

Sample SQL statement defining an action table

SQL CREATE TABLE SSM_ACTIONS (ACTION_PROCESS CHAR(8) UPPER CASE PRIMARY
KEY DEFAULT 'ACTION',
ACTION_CURRENT CHAR(8) UPPER CASE NULL PRIMARY KEY,
ACTION_DESIRED CHAR(8) UPPER CASE PRIMARY KEY DEFAULT '',
ACTION_MODE CHAR(8) UPPER CASE PRIMARY KEY DEFAULT '',
ACTION_RES_TABLE CHAR(18) UPPER CASE PRIMARY KEY DEFAULT '',
ACTION_RES_TYPE CHAR(18) UPPER CASE PRIMARY KEY DEFAULT '',
ACTION_TEXT VARCHAR(450))