github.com/unirita/cuto@v0.9.8-0.20160830082821-aa6652f877b7/_release/linux/data/dbinit.query (about)

     1  .mode csv
     2  .output bk_jobnet.csv
     3  SELECT * FROM JOBNETWORK ORDER BY CREATEDATE;
     4  .output bk_job.csv
     5  SELECT * FROM JOB ORDER BY CREATEDATE;
     6  DROP TABLE JOB;
     7  DROP TABLE JOBNETWORK;
     8  vacuum;
     9  CREATE TABLE "JOBNETWORK" (
    10    "ID" INTEGER PRIMARY KEY  NOT NULL ,
    11    "JOBNETWORK" TEXT NOT NULL ,
    12    "STARTDATE" TEXT NOT NULL ,
    13    "ENDDATE" TEXT ,
    14    "STATUS" INTEGER NOT NULL ,
    15    "DETAIL" TEXT NOT NULL ,
    16    "PID" INTEGER NOT NULL ,
    17    "CREATEDATE" TEXT NOT NULL ,
    18    "UPDATEDATE" TEXT NOT NULL
    19  );
    20  CREATE TABLE "JOB" (
    21    "ID" INTEGER NOT NULL,
    22    "JOBID" TEXT NOT NULL,
    23    "JOBNAME" TEXT NOT NULL,
    24    "STARTDATE" TEXT NOT NULL,
    25    "ENDDATE" TEXT,
    26    "STATUS" INTEGER NOT NULL,
    27    "DETAIL" TEXT,
    28    "RC" INTEGER  NOT NULL,
    29    "NODE" TEXT NOT NULL DEFAULT localhost,
    30    "PORT" INTEGER NOT NULL,
    31    "VARIABLE" TEXT,
    32    "CREATEDATE" TEXT NOT NULL,
    33    "UPDATEDATE" TEXT NOT NULL,
    34    PRIMARY KEY ("ID", "JOBID"),
    35    FOREIGN KEY(ID) REFERENCES JOBNETWORK(ID)
    36  );