-- Run this once in phpMyAdmin.
-- Adds a per-plan limit on how many Static Paylinks a merchant can create
-- (0 = unlimited, matching the existing max_transactions convention).

ALTER TABLE `subscription_plan`
  ADD COLUMN `static_paylink_limit` INT(11) NOT NULL DEFAULT 1 AFTER `cashier_limit`;
