Advertisement
Haycore

handelsposten_bestand

Jan 25th, 2017
182
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.72 KB | None | 0 0
  1. CREATE TABLE `handelsposten_bestand` (
  2.     `ID` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  3.     `Name` VARCHAR(45) NOT NULL DEFAULT '' COLLATE 'utf8_unicode_ci',
  4.     `PreisAK` INT(11) NULL DEFAULT NULL,
  5.     `MinAKQuali` INT(11) NULL DEFAULT NULL,
  6.     `AddQuali` INT(11) NULL DEFAULT NULL,
  7.     `AnkaufMax` INT(45) NULL DEFAULT NULL,
  8.     `PreisVK` INT(11) NULL DEFAULT NULL,
  9.     `Begrenzung` INT(11) NULL DEFAULT NULL,
  10.     `QualitaetVK` INT(11) NULL DEFAULT NULL,
  11.     `Bestand` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  12.     `BasePrice` INT(10) UNSIGNED NULL DEFAULT NULL COMMENT,
  13.     `Description` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
  14.     PRIMARY KEY (`ID`)
  15. )
  16. COLLATE='utf8_unicode_ci'
  17. ENGINE=InnoDB
  18. ROW_FORMAT=COMPACT
  19. AUTO_INCREMENT=1438
  20. ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement