Return to mqtt_acc.sql CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / mqtt / etc

Annotation of mqtt/etc/mqtt_acc.sql, revision 1.1.2.4

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
1.1.2.4 ! misho      12:        UPDATE Users SET Stamp = strftime('%s', 'now') WHERE Username = old.Username;
1.1.2.2   misho      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
1.1.2.4 ! misho      16:        UPDATE Users SET Stamp = strftime('%s', 'now') WHERE Username = new.Username;
1.1.2.2   misho      17: END;
1.1.2.1   misho      18: COMMIT;