ALTER TABLE licenses ADD COLUMN duration_years INTEGER NOT NULL DEFAULT 1;
ALTER TABLE licenses ADD COLUMN expires_at TEXT;
ALTER TABLE licenses ADD COLUMN price_per_seat REAL NOT NULL DEFAULT 3.0;
ALTER TABLE licenses ADD COLUMN discount_rate REAL NOT NULL DEFAULT 0;
ALTER TABLE licenses ADD COLUMN amount TEXT;

ALTER TABLE orders ADD COLUMN years INTEGER NOT NULL DEFAULT 1;
ALTER TABLE orders ADD COLUMN price_per_seat REAL NOT NULL DEFAULT 3.0;
ALTER TABLE orders ADD COLUMN discount_rate REAL NOT NULL DEFAULT 0;