Message Management

By default, our user management system manages reports according to the __messagesTable__ table. You can refer to the following SQL statement to establish __ messagesTable__ table.

CREATE __messagesTable__ 
1
2
3
4
5
6
7
 
CREATE TABLE IF NOT EXISTS __messagesTable__ (
  sender TEXT NOT NULL,
  receiver TEXT NOT NULL,
  validTime DATETIME DEFAULT (DATETIME('now', 'localtime')) NOT NULL,
  expireTime DATETIME DEFAULT (DATETIME('now', 'localtime', '+90 day')),
  content TEXT NOT NULL
);

In the __ messagesTable__ , you need to create at least the following cloumns: sender, receiver, validTime, expireTime, content, other cloumns can be created or deleted according to your needs.


sender and receiver represent message sender and receiver respectively. Both of them need to be associated with userName defined in user management system. sender and receiver can be the same person, representing users leave a message to themselves (or add a memorandum).

validTime and expireTime define the validity period of message information. From validTime to expireTime end, the message will be pushed to receiver constantly. If you want to leave a message that will never expire, just set these two cloumns as infinitesimal and infinitesimal dates respectively.

content is message information, the length can not exceed 25 letters. If the message content is relatively long, users need to be divide it into several messages, and the report platform will present the message information according to the time user leave the message.

__ messagesTable__ will be updated automatically according to the actual situation of the user’s message. In theory, you do not need to do any maintenance work.