ALTER TABLE `drugs` ADD `id` INT NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (`id`);
ALTER TABLE `account_entries` ADD `quantity` INT NOT NULL AFTER `cr`;
ALTER TABLE `account_entries` ADD `client_id` VARCHAR(50) NULL AFTER `reference_no`;
ALTER TABLE `account_entries` ADD `txn_status` VARCHAR(50) NULL AFTER `client_id`;

modify procedure, service_transaction, new_drug_sale, customer_deposit