ABillS

Документация:
http://abills.net.ua:8090/pages/viewpage.action?pageId=31883907#id-%D0%A0%D0%B0%D0%B1%D0%BE%D1%82%D0%B0%D1%81%D0%BD%D0%B0%D0%BA%D0%BB%D0%B0%D0%B4%D0%BD%D1%8B%D0%BC%D0%B8-%D0%9E%D0%BF%D0%BB%D0%B0%D1%82%D1%8B%D0%BF%D0%BE%D0%BD%D0%B0%D0%BA%D0%BB%D0%B0%D0%B4%D0%BD%D1%8B%D0%BC

В меню Настройки/Sql Commander/SQL Commander добавить:

CREATE TABLE IF NOT EXISTS  `storage_invoices_payments` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `invoice_id` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
  `sum` DOUBLE(10, 2) UNSIGNED NOT NULL DEFAULT '0.00',
  `actual_sum` DOUBLE(10, 2) UNSIGNED NOT NULL DEFAULT '0.00',
  `date` DATETIME NOT NULL,
  `aid` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `comments` TEXT,
  PRIMARY KEY (`id`),
  KEY `invoice_id` (`invoice_id`)
)
  DEFAULT CHARSET=utf8 COMMENT = 'Storage payments for invoice';