721bb987c406979bcfe705fa1ca8d54497d40fcbRobert WapshottCREATE TABLE identity (
721bb987c406979bcfe705fa1ca8d54497d40fcbRobert Wapshottissuer TEXT,
721bb987c406979bcfe705fa1ca8d54497d40fcbRobert WapshottaccountName TEXT,
721bb987c406979bcfe705fa1ca8d54497d40fcbRobert WapshottimageURL TEXT,
721bb987c406979bcfe705fa1ca8d54497d40fcbRobert WapshottbgColor TEXT,
721bb987c406979bcfe705fa1ca8d54497d40fcbRobert WapshottPRIMARY KEY( issuer, accountName ));
721bb987c406979bcfe705fa1ca8d54497d40fcbRobert Wapshott
721bb987c406979bcfe705fa1ca8d54497d40fcbRobert WapshottCREATE TABLE mechanism (
721bb987c406979bcfe705fa1ca8d54497d40fcbRobert WapshottidIssuer TEXT,
721bb987c406979bcfe705fa1ca8d54497d40fcbRobert WapshottidAccountName TEXT,
721bb987c406979bcfe705fa1ca8d54497d40fcbRobert WapshottmechanismUID TEXT UNIQUE,
721bb987c406979bcfe705fa1ca8d54497d40fcbRobert Wapshotttype TEXT,
721bb987c406979bcfe705fa1ca8d54497d40fcbRobert Wapshottversion INTEGER,
721bb987c406979bcfe705fa1ca8d54497d40fcbRobert Wapshottoptions TEXT,
721bb987c406979bcfe705fa1ca8d54497d40fcbRobert WapshottPRIMARY KEY ( idIssuer, idAccountName, type ),
721bb987c406979bcfe705fa1ca8d54497d40fcbRobert WapshottFOREIGN KEY( idIssuer, idAccountName )
721bb987c406979bcfe705fa1ca8d54497d40fcbRobert WapshottREFERENCES identity ( issuer, accountName ));
721bb987c406979bcfe705fa1ca8d54497d40fcbRobert Wapshott
721bb987c406979bcfe705fa1ca8d54497d40fcbRobert WapshottCREATE TABLE notification (
721bb987c406979bcfe705fa1ca8d54497d40fcbRobert WapshottmechanismUID TEXT,
721bb987c406979bcfe705fa1ca8d54497d40fcbRobert WapshotttimeReceived TEXT,
721bb987c406979bcfe705fa1ca8d54497d40fcbRobert WapshotttimeExpired TEXT,
721bb987c406979bcfe705fa1ca8d54497d40fcbRobert Wapshottdata TEXT,
721bb987c406979bcfe705fa1ca8d54497d40fcbRobert Wapshottpending INT,
721bb987c406979bcfe705fa1ca8d54497d40fcbRobert Wapshottapproved INT,
721bb987c406979bcfe705fa1ca8d54497d40fcbRobert WapshottFOREIGN KEY( mechanismUID )
721bb987c406979bcfe705fa1ca8d54497d40fcbRobert WapshottREFERENCES mechanism ( mechanismUID ),
721bb987c406979bcfe705fa1ca8d54497d40fcbRobert WapshottPRIMARY KEY( mechanismUID, timeReceived ));