Guest User

Untitled

a guest
Nov 17th, 2017
130
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE `operations` (
  2.     `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  3.     `type` CHAR(1) NOT NULL,
  4.     `reason_id` INT UNSIGNED NOT NULL,
  5.     `sum` DECIMAL(7,2) NOT NULL,
  6.     `notes` TINYTEXT NOT NULL,
  7.     `on_date` DATETIME NOT NULL DEFAULT NOW(),
  8.     `for_date` DATE NULL,
  9.     `user_id` INT UNSIGNED NOT NULL,
  10.     PRIMARY KEY (`id`)
  11. )
  12. COLLATE='utf8_general_ci'
  13. ENGINE=InnoDB
  14. AUTO_INCREMENT=1
  15. ;
RAW Paste Data