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