authenticator-ios-v2/ForgeRock-Authenticator/schema.sql

	schema.sql revision f023b5f548a10c190b01ea4259aedeee0796cbd2
CREATE TABLE identity (
issuer         TEXT,
accountName    TEXT,
imageURL       TEXT,
bgColor        TEXT,
PRIMARY KEY( issuer,  accountName ));

CREATE TABLE  mechanism (
idIssuer        TEXT,
idAccountName   TEXT,
mechanismUID    TEXT UNIQUE,
type            TEXT,
version         INTEGER,
options         TEXT,
PRIMARY KEY ( idIssuer, idAccountName, type ),
FOREIGN KEY( idIssuer,  idAccountName )
REFERENCES  identity ( issuer,  accountName ));

CREATE TABLE  notification  (
mechanismUID    TEXT,
timeReceived    TEXT,
timeExpired     TEXT,
data            TEXT,
pending         INT,
approved        INT,
FOREIGN KEY( mechanismUID )
REFERENCES  mechanism ( mechanismUID ),
PRIMARY KEY( mechanismUID,  timeReceived ));