Return to mqtt_acc.sql CVS log

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

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;