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

     1  CREATE TABLE content (
     2      id varchar(255) PRIMARY KEY NOT NULL,
     3      encryption_key varbinary(64) NOT NULL,
     4      location text NOT NULL,
     5      length int,
     6      sha256 varchar(64),
     7      type varchar(255)
     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 smallint DEFAULT NULL,
    17      rights_copy smallint DEFAULT NULL,
    18      rights_start datetime DEFAULT NULL,
    19      rights_end datetime DEFAULT NULL,
    20      content_fk varchar(255) NOT NULL,
    21      lsd_status tinyint default 0,
    22      FOREIGN KEY(content_fk) REFERENCES content(id)
    23  );