Annotation of mqtt/etc/mqtt_pub.sql, revision 1.1.2.3
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,
1.1.2.3 ! misho 6: RemotePort smallint unsigned not null,
1.1.2.1 misho 7: Stamp timestamp);
8: CREATE TABLE Topics (
9: id integer not null primary key,
1.1.2.2 misho 10: Retain char not null,
1.1.2.1 misho 11: Topic varchar(255) not null,
12: Value text,
13: PubUser varchar(64) not null,
14: PubDate datetime not null,
15: PubHost varchar(64) not null,
16: Stamp timestamp);
17: CREATE INDEX RemoteHost on Online (RemoteHost);
18: CREATE INDEX Username on Online (Username);
19: CREATE INDEX PubDate on Topics (PubDate);
20: CREATE INDEX PubHost on Topics (PubHost);
21: CREATE INDEX PubUser on Topics (PubUser);
22: CREATE INDEX Topic on Topics (Topic);
23: COMMIT;
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>