

CREATE TABLE `0_kv_bank_trans_settings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `bank_name` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pay_type` int DEFAULT '-1',
  `person_id` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `keyword` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `min_price` int NOT NULL,
  `max_price` int NOT NULL,
  `negative_only` tinyint NOT NULL DEFAULT '0',
  `notes` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  PRIMARY KEY(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

