UPDATE `tblpayment_modes_static` SET `name` = 'Cash' WHERE `tblpayment_modes_static`.`id` = 1;
UPDATE `tblpayment_modes_static` SET `name` = 'Cheque' WHERE `tblpayment_modes_static`.`id` = 2;
UPDATE `tblpayment_modes_static` SET `selected_by_default` = '0' WHERE `tblpayment_modes_static`.`id` = 1;
INSERT INTO `tblpayment_modes_static` (`id`, `name`, `description`, `show_on_pdf`, `invoices_only`, `expenses_only`, `selected_by_default`, `active`) VALUES (NULL, 'Bank Transfer', NULL, '0', '0', '0', '0', '1'), (NULL, 'Other', NULL, '0', '0', '0', '0', '1');


CREATE TABLE `tblexpenses_categories_static` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `description` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `tblexpenses_categories_static` (`id`, `name`, `description`) VALUES
(1, 'Advertising Expenses', ''),
(2, 'Business Vehicle(s)', ''),
(3, 'Payroll', ''),
(4, 'Employee Benefits', ''),
(5, 'Meals & Entertainment Expenses', ''),
(6, 'Office Expenses ', ''),
(7, 'Office Supplies', ''),
(8, 'Professional Services', ''),
(9, 'Rent, Utilities & Phone', ''),
(10, 'Travel Expenses', '');


ALTER TABLE `tblexpenses_categories_static`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `tblexpenses_categories_static`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

CREATE TABLE `tbltaxes_static` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `taxrate` decimal(15,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `tbltaxes_static` (`id`, `name`, `taxrate`) VALUES
(1, 'Sales Tax', '7.5');

ALTER TABLE `tbltaxes_static`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `tbltaxes_static`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;