keyhan
055e7a7c8d
Users pick per-service CPU/memory/storage at deploy; admins manage unit rates and deploy defaults. PATCH sends only fields accepted by the pricing-catalog DTO. Co-authored-by: Cursor <cursoragent@cursor.com>
28 lines
1.6 KiB
SQL
28 lines
1.6 KiB
SQL
-- Per-addon consumption footprint and optional resource unit prices (0 = use app runtime rates)
|
|
|
|
ALTER TABLE addon_rates
|
|
ADD COLUMN IF NOT EXISTS cpu_limit VARCHAR,
|
|
ADD COLUMN IF NOT EXISTS memory_limit VARCHAR,
|
|
ADD COLUMN IF NOT EXISTS storage_gi DECIMAL(10, 2) NOT NULL DEFAULT 0,
|
|
ADD COLUMN IF NOT EXISTS log_shipper_cpu_limit VARCHAR,
|
|
ADD COLUMN IF NOT EXISTS log_shipper_memory_limit VARCHAR,
|
|
ADD COLUMN IF NOT EXISTS cpu_hourly_price DECIMAL(12, 2) NOT NULL DEFAULT 0,
|
|
ADD COLUMN IF NOT EXISTS cpu_monthly_price DECIMAL(12, 2) NOT NULL DEFAULT 0,
|
|
ADD COLUMN IF NOT EXISTS cpu_yearly_price DECIMAL(12, 2) NOT NULL DEFAULT 0,
|
|
ADD COLUMN IF NOT EXISTS memory_hourly_price DECIMAL(12, 2) NOT NULL DEFAULT 0,
|
|
ADD COLUMN IF NOT EXISTS memory_monthly_price DECIMAL(12, 2) NOT NULL DEFAULT 0,
|
|
ADD COLUMN IF NOT EXISTS memory_yearly_price DECIMAL(12, 2) NOT NULL DEFAULT 0,
|
|
ADD COLUMN IF NOT EXISTS storage_hourly_price DECIMAL(12, 2) NOT NULL DEFAULT 0,
|
|
ADD COLUMN IF NOT EXISTS storage_monthly_price DECIMAL(12, 2) NOT NULL DEFAULT 0,
|
|
ADD COLUMN IF NOT EXISTS storage_yearly_price DECIMAL(12, 2) NOT NULL DEFAULT 0;
|
|
|
|
UPDATE addon_rates SET cpu_limit = '200m', memory_limit = '256Mi', storage_gi = 1
|
|
WHERE resource_type = 'redis_addon' AND cpu_limit IS NULL;
|
|
|
|
UPDATE addon_rates SET cpu_limit = '500m', memory_limit = '512Mi', storage_gi = 2
|
|
WHERE resource_type = 'rabbitmq_addon' AND cpu_limit IS NULL;
|
|
|
|
UPDATE addon_rates SET cpu_limit = '50m', memory_limit = '64Mi', storage_gi = 0,
|
|
log_shipper_cpu_limit = '50m', log_shipper_memory_limit = '64Mi'
|
|
WHERE resource_type = 'elasticsearch_addon' AND cpu_limit IS NULL;
|