github.com/readium/readium-lcp-server@v0.0.0-20240101192032-6e95190e99f1/dbmodel/mysql_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` bigint(20),
     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` int(11) default 0,
    22      FOREIGN KEY(content_fk) REFERENCES content(id)
    23  );