17 lines
567 B
SQL
17 lines
567 B
SQL
-- +goose Up
|
|
CREATE TABLE IF NOT EXISTS master_setting_values (
|
|
setting_key VARCHAR(120) NOT NULL PRIMARY KEY,
|
|
value TEXT NOT NULL,
|
|
is_encrypted TINYINT(1) NOT NULL DEFAULT 0,
|
|
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
created_by BINARY(16) NULL,
|
|
updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
|
updated_by BINARY(16) NULL,
|
|
|
|
KEY idx_master_setting_values_updated_at (updated_at),
|
|
KEY idx_master_setting_values_is_encrypted (is_encrypted)
|
|
);
|
|
|
|
-- +goose Down
|
|
DROP TABLE IF EXISTS master_setting_values;
|