1#@!#!123s

: / opt / psa / admin / plib / modules / letsencrypt / resources / db /

Filename : init_schema.sql

back

CREATE TABLE IF NOT EXISTS `statisticsMeasurement` (
  `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  `createdDate` DATETIME NOT NULL DEFAULT (strftime('%s','now')),
  `name` TEXT NOT NULL,
  `value` REAL NOT NULL DEFAULT 0
);

CREATE TABLE IF NOT EXISTS `requestLog` (
  `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  `domainGuid` varchar(255) NOT NULL,
  `requestDateTime` DATETIME NOT NULL DEFAULT (strftime('%s','now')),
  `requestType` varchar(20) NOT NULL,
  `status` varchar(20) NOT NULL,
  `errorCode` INTEGER NOT NULL DEFAULT 0,
  `errorType` varchar(100) NOT NULL,
  `errorMessage` varchar(255) NOT NULL
);