USE csc_management;

ALTER TABLE applications
ADD COLUMN certificate_reference_no VARCHAR(100) NULL AFTER application_no;

ALTER TABLE settings
ADD COLUMN email VARCHAR(120) NULL AFTER mobile,
ADD COLUMN website VARCHAR(180) NULL AFTER email;

UPDATE settings
SET centre_name='CSC SORATH',
    owner_name='CSC SORATH',
    mobile='8809810793',
    address='VILL SORATH, PO TAL, PS PANKI, DIST PALAMU, JHARKHAND - 822122'
WHERE id=1;
