Package de.uplanet.lucy.server.newsagent


package de.uplanet.lucy.server.newsagent
Used to create and manage persistent Intrexx messages.

Overview

Documentation

The classes operate on the tables LCMESSAGES and LCRECIPIENTS:

CREATE TABLE LCMESSAGES
(
    GUIDMESSAGE VARCHAR(40) NOT NULL,
    GUIDSENDER VARCHAR(40),
    STRAPPGUID VARCHAR(40),
    STRTARGETGUID VARCHAR(40),
    INTRECID INTEGER NOT NULL,
    DTCREATED DATETIME NOT NULL,
    DTEXPIRE DATETIME,
    STRSUBJECT VARCHAR(255),
    TXTBODY TEXT
    PRIMARY KEY (GUIDMESSAGE)
)

CREATE INDEX IX_LCMESSAGES0 ON LCMESSAGES(GUIDMESSAGE)

CREATE TABLE LCRECIPIENTS
(
    GUIDMESSAGE VARCHAR(40) NOT NULL,
    GUIDRECIPIENT VARCHAR(40) NOT NULL,
    INTVISITED INTEGER NOT NULL,
    INTDELETED INTEGER NOT NULL
    PRIMARY KEY (GUIDMESSAGE, GUIDRECIPIENT),
    FOREIGN KEY (GUIDMESSAGE) REFERENCES LCMESSAGES(GUIDMESSAGE)
)

CREATE INDEX IX_LCRECIPIENTS0 ON LCRECIPIENTS(GUIDRECIPIENT)

CREATE TABLE LCMAPAPP
(
    STRAPPGUID VARCHAR(40),
    STRTARGETGUID VARCHAR(40)
    PRIMARY KEY (STRAPPGUID)
)