• Home
• com.squareup.keywhiz
• keywhiz-server
• 0.7.10-mysql
• source code
• V1.4__alter_secrets_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.h2.migration.V1.4__alter_secrets_to_add_columns.sql Maven / Gradle / Ivy

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

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

/* Required update timestamp. Defaults to creation time. */
ALTER TABLE secrets ADD COLUMN updatedDate timestamp NOT NULL DEFAULT NOW();

/* Required text field, username of updater.
     Skipping not null because of existing records. */
ALTER TABLE secrets ADD COLUMN updatedBy 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.
*/