Return to mqtt_acc.sql CVS log

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

add if not exists

    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;