>_
.issue.db
/highway-workflow-engine
Dashboard
Issues
Memory
Lessons
Audit Log
New Issue
Edit Issue #72
Update issue details
Title *
Description
Create database migration for API keys table. Migration File: engine/migrations/sql/XXX_api_keys_table.sql Table: api_keys Columns: - id: uuid primary key - user_id: uuid (foreign key to users) - tenant_id: varchar(100) - name: varchar(100) - key_hash: varchar(64) unique (SHA256 of API key) - key_prefix: varchar(8) (for identification, e.g., 'hw_live_') - permissions: text[] (array of permissions) - created_at: timestamp - expires_at: timestamp - last_used_at: timestamp - last_used_ip: inet - is_active: boolean default true - revoked_at: timestamp - revoked_by: uuid Indexes: - idx_api_keys_user_id - idx_api_keys_tenant_active - idx_api_keys_key_hash - idx_api_keys_expires_at With ultra attention to details and correctness. Before closing: write comment summarizing implementation with screenshot.
Priority
Low
Medium
High
Critical
Status
Open
In Progress
Closed
Due Date (YYYY-MM-DD)
Tags (comma separated)
Related Issues (IDs)
Enter IDs of issues related to this one. They will be linked as 'related'.
Update Issue
Cancel