4 lines
421 B
SQL
Executable File
4 lines
421 B
SQL
Executable File
|
|
CREATE TABLE APP_ACT_NOTIFICATION_CFG ( ID char(36) NOT NULL, ISCLOSE char(1), ISSTORE char(1), PRIMARY KEY (ID) );
|
|
CREATE TABLE APP_ACT_NOTIFICATION_MSG ( ID char(36) NOT NULL, REGISTERID varchar(128), APPID varchar(64), OWNERID varchar(36), TARGETID varchar(36), NOTIFYCONTENT ntext, NOTIFYLEVEL char(1), ISCLOSE char(1), CREATETIME datetime, ISSTORE char(1), READTIME datetime, READED char(1), PRIMARY KEY (ID) );
|