START TRANSACTION;

CREATE TABLE `tblpayment_modes_static` (
  `id` bigint(20) UNSIGNED PRIMARY KEY AUTO_INCREMENT NOT NULL,
  `name` varchar(100) NOT NULL,
  `description` text,
  `show_on_pdf` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
  `invoices_only` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
  `expenses_only` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
  `selected_by_default` bigint(20) UNSIGNED NOT NULL DEFAULT '1',
  `active` tinyint(1) NOT NULL DEFAULT '1'
);

INSERT INTO `tblpayment_modes_static` (`id`, `name`, `description`, `show_on_pdf`, `invoices_only`, `expenses_only`, `selected_by_default`, `active`) VALUES
(1, 'Bank', NULL, 0, 0, 0, 1, 1),
(2, 'Cash', '', 0, 0, 0, 0, 1);

COMMIT;