4 lines
421 B
MySQL
4 lines
421 B
MySQL
|
|
||
|
|
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) );
|