Annotation of mqtt/etc/mqtt_pub.sql, revision 1.1.2.1
1.1.2.1 ! misho 1: PRAGMA foreign_keys=ON;
! 2: BEGIN TRANSACTION;
! 3: CREATE TABLE Online (
! 4: Username varchar(64) not null,
! 5: RemoteHost varchar(64) not null,
! 6: RepotePort smallint not null,
! 7: Stamp timestamp);
! 8: CREATE TABLE Topics (
! 9: id integer not null primary key,
! 10: Topic varchar(255) not null,
! 11: Value text,
! 12: PubUser varchar(64) not null,
! 13: PubDate datetime not null,
! 14: PubHost varchar(64) not null,
! 15: Stamp timestamp);
! 16: CREATE INDEX RemoteHost on Online (RemoteHost);
! 17: CREATE INDEX Username on Online (Username);
! 18: CREATE INDEX PubDate on Topics (PubDate);
! 19: CREATE INDEX PubHost on Topics (PubHost);
! 20: CREATE INDEX PubUser on Topics (PubUser);
! 21: CREATE INDEX Topic on Topics (Topic);
! 22: COMMIT;
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>