1#@!#!123s

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

Filename : init_schema.sql

back

CREATE TABLE IF NOT EXISTS `Application` (
  `id` INTEGER NOT NULL PRIMARY KEY,
  `name` varchar(255) NOT NULL,
  `path` varchar(255) NOT NULL,
  `domainId` varchar(255) NOT NULL,
  `createdDate` DATETIME NOT NULL DEFAULT (strftime('%s','now'))
);

CREATE TABLE IF NOT EXISTS `Package` (
  `id` INTEGER NOT NULL PRIMARY KEY,
  `name` varchar(255) NOT NULL,
  `data` text NOT NULL,
  `applicationId` INTEGER NOT NULL
);

CREATE TABLE IF NOT EXISTS `Setting` (
  `id` INTEGER NOT NULL PRIMARY KEY,
  `property` varchar(255) NOT NULL,
  `data` text NOT NULL,
  `applicationId` INTEGER NOT NULL,
  `createdDate` DATETIME NOT NULL DEFAULT (strftime('%s','now'))
);

CREATE TABLE IF NOT EXISTS `Statistics` (
  `id` INTEGER NOT NULL PRIMARY KEY,
  `property` varchar(255) NOT NULL,
  `data` text NOT NULL,
  `createdDate` DATETIME NOT NULL DEFAULT (strftime('%s','now'))
);