Skip to main content
The Deno 2 Release Candidate is here
Learn more
Module

x/earthstar/src/replica/replica-driver-sqlite.shared.ts>CREATE_DOCS_TABLE_QUERY

A specification and Javascript library for building online tools you can truly call your own.
Go to Latest
variable CREATE_DOCS_TABLE_QUERY
import { CREATE_DOCS_TABLE_QUERY } from "https://deno.land/x/earthstar@v9.3.3/src/replica/replica-driver-sqlite.shared.ts";

type

`CREATE TABLE IF NOT EXISTS docs ( format TEXT NOT NULL, workspace TEXT NOT NULL, path TEXT NOT NULL, contentHash TEXT NOT NULL, content BLOB NOT NULL, author TEXT NOT NULL, timestamp NUMBER NOT NULL, deleteAfter NUMBER, -- can be null signature TEXT NOT NULL, localIndex NUMBER NOT NULL UNIQUE, PRIMARY KEY(path, author) );`