mirror of
https://gitee.com/wanwujie/sub2api
synced 2026-04-03 15:02:13 +08:00
21 lines
1.0 KiB
MySQL
21 lines
1.0 KiB
MySQL
|
-- Migration: Add quota fields to api_keys table
|
||
|
|
-- This migration adds independent quota and expiration support for API keys
|
||
|
|
|
||
|
|
-- Add quota limit field (0 = unlimited)
|
||
|
|
ALTER TABLE api_keys ADD COLUMN IF NOT EXISTS quota DECIMAL(20, 8) NOT NULL DEFAULT 0;
|
||
|
|
|
||
|
|
-- Add used quota amount field
|
||
|
|
ALTER TABLE api_keys ADD COLUMN IF NOT EXISTS quota_used DECIMAL(20, 8) NOT NULL DEFAULT 0;
|
||
|
|
|
||
|
|
-- Add expiration time field (NULL = never expires)
|
||
|
|
ALTER TABLE api_keys ADD COLUMN IF NOT EXISTS expires_at TIMESTAMPTZ;
|
||
|
|
|
||
|
|
-- Add indexes for efficient quota queries
|
||
|
|
CREATE INDEX IF NOT EXISTS idx_api_keys_quota_quota_used ON api_keys(quota, quota_used) WHERE deleted_at IS NULL;
|
||
|
|
CREATE INDEX IF NOT EXISTS idx_api_keys_expires_at ON api_keys(expires_at) WHERE deleted_at IS NULL;
|
||
|
|
|
||
|
|
-- Comment on columns for documentation
|
||
|
|
COMMENT ON COLUMN api_keys.quota IS 'Quota limit in USD for this API key (0 = unlimited)';
|
||
|
|
COMMENT ON COLUMN api_keys.quota_used IS 'Used quota amount in USD';
|
||
|
|
COMMENT ON COLUMN api_keys.expires_at IS 'Expiration time for this API key (null = never expires)';
|