-- CareBill — document numbering keyed by series. Existing database:  mysql carebill < sql/numbering.sql
-- Run this BEFORE the first live invoice. Changing the numbering after numbers
-- have been issued in a financial year is a question for your CA.
ALTER TABLE doc_series ADD COLUMN series_key VARCHAR(60) NOT NULL DEFAULT '' AFTER fy_code;
UPDATE doc_series SET series_key = CONCAT('LEGACY|', brand_id, '|', doc_type, '|', fy_code) WHERE series_key = '';
ALTER TABLE doc_series DROP INDEX uq_series, ADD UNIQUE KEY uq_series (series_key);
INSERT INTO settings (k,v) VALUES ('doc_number_format','{prefix}/{yy}/{mm}/{n4}') ON DUPLICATE KEY UPDATE v=v;
UPDATE brands SET invoice_prefix='CSPL', cn_prefix='CSCN', proforma_prefix='CSPF' WHERE code='CSPL';