• Home
• com.squareup.keywhiz
• keywhiz-server
• 0.7.10-mysql
• source code
• V1.6__alter_clients_to_add_columns.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.postgres.migration.V1.6__alter_clients_to_add_columns.sql Maven / Gradle / Ivy

/* Arbitrary text field, optional. */
ALTER TABLE clients ADD COLUMN description text;

/* Required text field, username of creator.
     Skipping not null because of existing records. */
ALTER TABLE clients ADD COLUMN createdBy text;

/* Required text field, username of updater.
     Skipping not null because of existing records. */
ALTER TABLE clients ADD COLUMN updatedBy text;

ALTER TABLE clients ADD COLUMN enabled boolean NOT NULL DEFAULT FALSE;

/* Required text field, base64 certificate of the client.
     Skipping not null because of existing records.
     Need to import certs later.
*/
ALTER TABLE clients ADD COLUMN certificate text;

/*
Risk:
  This migration should not pose any risk. It is only additive.
  The only added constraint is a NOT NULL on a new column where a default IS specified.
*/