Lib/std/book-cmark/synced.sql

   1 PRAGMA foreign_keys=OFF;
   2 BEGIN TRANSACTION;
   3 CREATE TABLE synced (
   4   file TEXT
   5     CONSTRAINT synced_file_length
   6       CHECK (length(file) > 0)
   7     UNIQUE
   8     NOT NULL,
   9   orig TEXT,
  10   rev TEXT
  11     CONSTRAINT synced_rev_length
  12       CHECK (length(rev) = 40 OR rev = ''),
  13   date TEXT
  14     CONSTRAINT synced_date_length
  15       CHECK (date IS NULL OR length(date) = 19)
  16     CONSTRAINT synced_date_valid
  17       CHECK (date IS NULL OR datetime(date) IS NOT NULL)
  18 );
  19 INSERT INTO "synced" VALUES('.gitattributes','Lib/std/book-cmark/.gitattributes','b51b9ee08973c1bd7cc2afc83bd9c8f7e38e95ec','2015-12-29 00:18:49');
  20 INSERT INTO "synced" VALUES('.gitignore','Lib/std/book-cmark/.gitignore','b51b9ee08973c1bd7cc2afc83bd9c8f7e38e95ec','2015-12-29 00:18:49');
  21 INSERT INTO "synced" VALUES('Makefile','Lib/std/book-cmark/Makefile','80c68f9626ed96fa5610694aa9ba9876b86b9f85','2015-12-30 15:42:34');
  22 INSERT INTO "synced" VALUES('bin/create-html','Lib/std/book-cmark/bin/create-html','d928b064be29cdd7cb766ac83c2f3323654a3beb','2016-05-07 19:00:36');
  23 INSERT INTO "synced" VALUES('bin/loop-stat','Lib/std/book-cmark/bin/loop-stat','d928b064be29cdd7cb766ac83c2f3323654a3beb','2016-05-07 19:00:36');
  24 INSERT INTO "synced" VALUES('bin/stats','Lib/std/book-cmark/bin/stats','d928b064be29cdd7cb766ac83c2f3323654a3beb','2016-05-07 19:00:36');
  25 INSERT INTO "synced" VALUES('dat/STDprojnameDTS.sql','Lib/std/book-cmark/dat/STDprojnameDTS.sql','b51b9ee08973c1bd7cc2afc83bd9c8f7e38e95ec','2015-12-29 00:18:49');
  26 INSERT INTO "synced" VALUES('index.md','Lib/std/book-cmark/index.md','b51b9ee08973c1bd7cc2afc83bd9c8f7e38e95ec','2015-12-29 00:18:49');
  27 INSERT INTO "synced" VALUES('synced.sql','',NULL,NULL);
  28 CREATE TABLE todo (
  29   file TEXT
  30     CONSTRAINT todo_file_length
  31       CHECK(length(file) > 0)
  32     UNIQUE
  33     NOT NULL
  34   ,
  35   pri INTEGER
  36     CONSTRAINT todo_pri_range
  37       CHECK(pri BETWEEN 1 AND 5)
  38   ,
  39   comment TEXT
  40 );
  41 COMMIT;