• Home
• com.squareup.keywhiz
• keywhiz-server
• 0.7.10-mysql
• source code
• V1__create_tables.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db.h2.migration.V1__create_tables.sql Maven / Gradle / Ivy

CREATE TABLE secrets (
  id SERIAL primary key,
  name varchar(255), // Changed to varchar. H2 does not support text for indexed columns.
  secret text,
  version varchar(20),
  owner text,
  mode text,
  createdAt timestamp,
  updatedAt timestamp
);

CREATE TABLE groups (
  id SERIAL primary key,
  name varchar(255) unique, // Changed to varchar. H2 does not support text for indexed columns.
  createdAt timestamp,
  updatedAt timestamp
);

CREATE TABLE clients (
  id SERIAL primary key,
  name varchar(255) unique, // Changed to varchar. H2 does not support text for indexed columns.
  createdAt timestamp,
  updatedAt timestamp
);

CREATE TABLE accessGrants (
  id SERIAL primary key,
  groupId int REFERENCES groups ON DELETE CASCADE,
  secretId int REFERENCES secrets ON DELETE CASCADE,
  createdAt timestamp,
  updatedAt timestamp
);

CREATE TABLE memberships (
  id SERIAL primary key,
  groupId int REFERENCES groups ON DELETE CASCADE,
  clientId int REFERENCES clients ON DELETE CASCADE,
  createdAt timestamp,
  updatedAt timestamp
);