File:
[ELWIX - Embedded LightWeight unIX -] /
mqtt /
etc /
mqtt_acc.sql
Revision
1.2:
download - view:
text,
annotated -
select for diffs -
revision graph
Fri Jan 27 15:05:38 2012 UTC (12 years, 8 months ago) by
misho
Branches:
MAIN
CVS tags:
mqtt2_1,
mqtt2_0,
mqtt1_3,
mqtt1_2,
mqtt1_1,
MQTT2_0,
MQTT1_3,
MQTT1_2,
MQTT1_1,
HEAD
added new files
PRAGMA foreign_keys=ON;
BEGIN TRANSACTION;
CREATE TABLE IF NOT EXISTS Users (
uid integer primary key AUTOINCREMENT,
Username varchar(64) not null,
Password varchar(64) not null,
Access integer not null,
Stamp timestamp);
CREATE UNIQUE INDEX IF NOT EXISTS User on Users (UserName);
CREATE TRIGGER IF NOT EXISTS Users_update_t AFTER UPDATE ON Users
BEGIN
UPDATE Users SET Stamp = strftime('%s', 'now') WHERE Username = old.Username;
END;
CREATE TRIGGER IF NOT EXISTS Users_insert_t AFTER INSERT ON Users
BEGIN
UPDATE Users SET Stamp = strftime('%s', 'now') WHERE Username = new.Username;
END;
COMMIT;
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>