Return to mqtt_db.sql CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / mqtt / etc

Annotation of mqtt/etc/mqtt_db.sql, revision 1.1.2.1

1.1.2.1 ! misho       1: PRAGMA foreign_keys=ON;
        !             2: BEGIN TRANSACTION;
        !             3: CREATE TABLE Users (
        !             4: uid integer primary key AUTOINCREMENT,
        !             5: Username varchar(64) not null,
        !             6: Password varchar(64) not null,
        !             7: Access integer not null,
        !             8: Stamp timestamp);
        !             9: CREATE TABLE Online (
        !            10: Username varchar(64) not null,
        !            11: RemoteHost varchar(64) not null,
        !            12: RepotePort smallint not null,
        !            13: Stamp timestamp,
        !            14: foreign key (Username) references Users (Username));
        !            15: CREATE TABLE Topics (
        !            16: id integer not null primary key,
        !            17: Topic varchar(255) not null,
        !            18: Value text,
        !            19: PubUser varchar(64) not null,
        !            20: PubDate datetime not null,
        !            21: PubHost varchar(64) not null,
        !            22: Stamp timestamp,
        !            23: foreign key (PubUser) references Users (Username));
        !            24: CREATE UNIQUE INDEX User on Users (UserName);
        !            25: CREATE INDEX RemoteHost on Online (RemoteHost);
        !            26: CREATE INDEX Username on Online (Username);
        !            27: CREATE INDEX PubDate on Topics (PubDate);
        !            28: CREATE INDEX PubHost on Topics (PubHost);
        !            29: CREATE INDEX PubUser on Topics (PubUser);
        !            30: CREATE INDEX Topic on Topics (Topic);
        !            31: COMMIT;