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;
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>