Guest User

SQL for parts

a guest
May 10th, 2017
298
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.40 KB | None | 0 0
  1. CREATE TABLE `parts` (
  2.     `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  3.     `sku` VARCHAR(50) NULL DEFAULT NULL,
  4.     `brand_id` INT(11) NULL DEFAULT NULL,
  5.     `name` VARCHAR(50) NULL DEFAULT NULL,
  6.     `price` DECIMAL(10,2) NULL DEFAULT NULL,
  7.     `mark_id` INT(11) NULL DEFAULT NULL,
  8.     PRIMARY KEY (`id`),
  9.     INDEX `brand_id` (`brand_id`),
  10.     INDEX `mark_id` (`mark_id`)
  11. )
  12. COLLATE='utf8_general_ci'
  13. ENGINE=InnoDB
  14. ;
Advertisement
Add Comment
Please, Sign In to add comment