123-purchases-product-column.sql
1 -- Add product column to purchases table. 2 -- All existing purchases are full_audit (the only product that existed before). 3 ALTER TABLE purchases ADD COLUMN product TEXT NOT NULL DEFAULT 'full_audit';
1 -- Add product column to purchases table. 2 -- All existing purchases are full_audit (the only product that existed before). 3 ALTER TABLE purchases ADD COLUMN product TEXT NOT NULL DEFAULT 'full_audit';