• Home
• im.actor.server
• actor-persist
• 3.0.0
• source code
• V20160119175838__CreateEncryption.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.

sql.migration.V20160119175838__CreateEncryption.sql Maven / Gradle / Ivy

CREATE TABLE encryption_key_groups (
  user_id INT NOT NULL,
  id BIGINT NOT NULL,
  body BYTEA NOT NULL,
  PRIMARY KEY (user_id, id)
);

CREATE INDEX ON encryption_key_groups(user_id);

CREATE TABLE ephermal_public_keys (
  user_id INT NOT NULL,
  key_group_id INT NOT NULL,
  key_id BIGINT NOT NULL,
  body BYTEA,
  PRIMARY KEY (user_id, key_group_id, key_id)
);

CREATE INDEX ON ephermal_public_keys(user_id, key_group_id);