1#@!#!123s

: / opt / psa / admin / plib / modules / sslit / resources / db / migrations /

Filename : 20180618-1200_CreateTableOrders.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
);