· 7 years ago · Jan 17, 2019, 02:40 AM
1create table if not exists [EventLog] (
2Id INTEGER PRIMARY KEY ASC,
3DocumentId TEXT NOT NULL,
4Event TEXT NOT NULL,
5Content TEXT NOT NULL,
6TransactionId TEXT NOT NULL,
7Date INTEGER NOT NULL,
8User TEXT NOT NULL)
9
10create index if not exists DocumentId ON EventLog (DocumentId)
11
12create index if not exists TransactionId ON EventLog (TransactionId)
13
14create index if not exists Date ON EventLog (Date)