Annotation of mqtt/etc/mqtt_acc.sql, revision 1.1.2.3
1.1.2.1 misho 1: PRAGMA foreign_keys=ON;
2: BEGIN TRANSACTION;
1.1.2.3 ! misho 3: CREATE TABLE IF NOT EXISTS Users (
1.1.2.1 misho 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);
1.1.2.3 ! misho 9: CREATE UNIQUE INDEX IF NOT EXISTS User on Users (UserName);
! 10: CREATE TRIGGER IF NOT EXISTS Users_update_t AFTER UPDATE ON Users
1.1.2.2 misho 11: BEGIN
12: UPDATE Users SET Stamp = strftime("%s", "now") WHERE Username = old.Username;
13: END;
1.1.2.3 ! misho 14: CREATE TRIGGER IF NOT EXISTS Users_insert_t AFTER INSERT ON Users
1.1.2.2 misho 15: BEGIN
16: UPDATE Users SET Stamp = strftime("%s", "now") WHERE Username = new.Username;
17: END;
1.1.2.1 misho 18: COMMIT;
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>