github.com/readium/readium-lcp-server@v0.0.0-20240509124024-799e77a0bbd6/dbmodel/sqlite_db_setup_lcpserver.sql (about)

     1  CREATE TABLE content (
     2    id varchar(255) PRIMARY KEY NOT NULL,
     3    encryption_key varchar(64) NOT NULL,
     4    location text NOT NULL, 
     5    length bigint,
     6    sha256 varchar(64),
     7    "type" varchar(255) NOT NULL DEFAULT 'application/epub+zip'
     8  );
     9  
    10  CREATE TABLE license (
    11    id varchar(255) PRIMARY KEY NOT NULL,
    12    user_id varchar(255) NOT NULL,
    13    provider varchar(255) NOT NULL,
    14    issued datetime NOT NULL,
    15    updated datetime DEFAULT NULL,
    16    rights_print int(11) DEFAULT NULL,
    17    rights_copy int(11) DEFAULT NULL,
    18    rights_start datetime DEFAULT NULL,
    19    rights_end datetime DEFAULT NULL,
    20    content_fk varchar(255) NOT NULL,
    21    lsd_status integer default 0,
    22    FOREIGN KEY(content_fk) REFERENCES content(id)
    23  );