1#@!#!123s

: / opt / psa / admin / plib / modules / sslit / resources / db /
Filename : init_schema.sql
back
CREATE TABLE IF NOT EXISTS `Orders` (
  `id` INTEGER NOT NULL PRIMARY KEY,
  `vendorId` varchar(255) NOT NULL,
  `productId` varchar(255) NOT NULL,
  `domainGuid` varchar(255) NOT NULL,
  `createdDate` DATETIME NOT NULL DEFAULT (strftime('%s','now')),
  `status` INTEGER NOT NULL DEFAULT 0,
  `certificateId` INTEGER NOT NULL DEFAULT 0
);

CREATE TABLE IF NOT EXISTS `OrderAttribute` (
  `orderId` INTEGER NOT NULL REFERENCES Orders(id) ON DELETE CASCADE,
  `name` varchar(255) NOT NULL,
  `value` TEXT NOT NULL,
  PRIMARY KEY (`orderId`, `name`)
);


CREATE TABLE IF NOT EXISTS `Notification` (
  `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  `createdDate` DATETIME NOT NULL DEFAULT (strftime('%s','now')),
  `updateDate` DATETIME NOT NULL DEFAULT (strftime('%s','now')),
  `state` TEXT CHECK(`state` IN ('pending','skipped','sent')) NOT NULL DEFAULT 'pending',
  `clientId` INTEGER NOT NULL,
  `notificationId` TEXT NOT NULL,
  `params` TEXT NOT NULL
);

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

CREATE TABLE IF NOT EXISTS `PanelNotification` (
  `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  `createdDate` DATETIME NOT NULL DEFAULT (strftime('%s','now')),
  `clientId` INTEGER NOT NULL,
  `notificationId` TEXT NOT NULL
);