Cacher is the code snippet organizer for pro developers

CREATE TABLE `products` (
    `id` INT(20) NOT NULL AUTO_INCREMENT,
    `name` varchar(45) NOT NULL,
    `category_id` INT(20) NOT NULL,
    PRIMARY KEY (`id`)
);

CREATE TABLE `categories` (
    `id` INT(20) NOT NULL AUTO_INCREMENT,
    `name` varchar(45) NOT NULL,
    PRIMARY KEY (`id`)
);

ALTER TABLE `products` ADD CONSTRAINT `products_fk0` 
FOREIGN KEY (`category_id`) REFERENCES `categories`(`id`);