Return to mqtt_acc.sql CVS log | Up to [ELWIX - Embedded LightWeight unIX -] / mqtt / etc |
1.1.2.1 ! misho 1: PRAGMA foreign_keys=ON; ! 2: BEGIN TRANSACTION; ! 3: CREATE TABLE 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 User on Users (UserName); ! 10: COMMIT;