.hipster.sql

CREATE TABLE IF NOT EXISTS `product`(
   `id` VARCHAR(100) NOT NULL COMMENT '唯一不重复',
   `name` VARCHAR(100) NOT NULL,
   `description` VARCHAR(200) NOT NULL,
   `picture` VARCHAR(512) CHARACTER SET 'ascii' COLLATE 'ascii_general_ci' NOT NULL,
   `priceUsd` JSON,
   `categories` JSON,
   PRIMARY KEY ( `id` )
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO product 
(`id`, `name`, `description`, `picture`, `priceUsd`, `categories`) 
VALUES (
   'L9ECAV7KIM',
   'Terrarium', 
   'This terrarium will looks great in your white painted living room.', 
   '/static/img/products/terrarium.jpg', 
   '{"currencyCode":"USD","units":36,"nanos":450000000}', 
   '["gardening"]'
);

INSERT INTO product 
(`id`, `name`, `description`, `picture`, `priceUsd`, `categories`) 
VALUES (
 'OLJCESPC7Z',
 'Vintage Typewriter',
 'This typewriter looks good in your living room.',
 '/static/img/products/typewriter.jpg',
 '{"currencyCode": "USD", "units": 67, "nanos": 990000000}',
 '["vintage"]'
);
INSERT INTO product 
(`id`, `name`, `description`, `picture`, `priceUsd`, `categories`) 
VALUES (
 '66VCHSJNUP',
 'Vintage Camera Lens',
 'You won't have a camera to use it and it probably doesn't work anyway.',
 '/static/img/products/camera-lens.jpg',
 '{"currencyCode": "USD", "units": 12, "nanos": 490000000}',
 '["photography", "vintage"]'
);
INSERT INTO product 
(`id`, `name`, `description`, `picture`, `priceUsd`, `categories`) 
VALUES (
 '1YMWWN1N4O',
 'Home Barista Kit',
 'Always wanted to brew coffee with Chemex and Aeropress at home?',
 '/static/img/products/barista-kit.jpg',
 '{"currencyCode": "USD", "units": 124}',
 '["cookware"]'
);
INSERT INTO product 
(`id`, `name`, `description`, `picture`, `priceUsd`, `categories`) 
VALUES (
 'L9ECAV7KIM',
 'Terrarium',
 'This terrarium will looks great in your white painted living room.',
 '/static/img/products/terrarium.jpg',
 '{"currencyCode": "USD", "units": 36, "nanos": 450000000}',
 '["gardening"]'
);
INSERT INTO product 
(`id`, `name`, `description`, `picture`, `priceUsd`, `categories`) 
VALUES (
 '2ZYFJ3GM2N',
 'Film Camera',
 'This camera looks like it's a film camera, but it's actually digital.',
 '/static/img/products/film-camera.jpg',
 '{"currencyCode": "USD", "units": 2245}',
 '["photography", "vintage"]'