12 lines
361 B
SQL
12 lines
361 B
SQL
CREATE TABLE internal_api_keys (
|
|
id BIGSERIAL PRIMARY KEY,
|
|
program_name VARCHAR(255) NOT NULL,
|
|
api_key VARCHAR(255) NOT NULL,
|
|
created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
|
|
status VARCHAR(20) NOT NULL DEFAULT 'active',
|
|
description TEXT NULL
|
|
);
|
|
|
|
CREATE INDEX idx_internal_api_keys_program_name
|
|
ON internal_api_keys(program_name);
|