12345678910111213 |
- CREATE TABLE IF NOT EXISTS "blobs" (
- `blobId` TEXT NOT NULL,
- `content` TEXT NULL DEFAULT NULL,
- `dateModified` TEXT NOT NULL,
- `utcDateModified` TEXT NOT NULL,
- PRIMARY KEY(`blobId`)
- );
- ALTER TABLE notes ADD blobId TEXT DEFAULT NULL;
- ALTER TABLE note_revisions ADD blobId TEXT DEFAULT NULL;
- CREATE INDEX IF NOT EXISTS IDX_notes_blobId on notes (blobId);
- CREATE INDEX IF NOT EXISTS IDX_note_revisions_blobId on note_revisions (blobId);
|