Na}{

File Content: `init_schema.sql`

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'))
);

Name	Size	Permission	Action
migrations	---	0755
init_schema.sql	868 bytes	0644

File Content: init_schema.sql

File Content: `init_schema.sql`