CREATE TABLE `operations` (
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `type` CHAR(1) NOT NULL,
    `reason_id` INT UNSIGNED NOT NULL,
    `sum` DECIMAL(7,2) NOT NULL,
    `notes` TINYTEXT NOT NULL,
    `on_date` DATETIME NOT NULL DEFAULT NOW(),
    `for_date` DATE NULL,
    `user_id` INT UNSIGNED NOT NULL,
    PRIMARY KEY (`id`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1
;