OrderBackend/init.sql at main · liuzhaoze/OrderBackend · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
CREATE DATABASE IF NOT EXISTS stock;
CREATE DATABASE IF NOT EXISTS stock_test;

GRANT ALL PRIVILEGES ON stock.* TO 'user'@'%';
GRANT ALL PRIVILEGES ON stock_test.* TO 'user'@'%';
FLUSH PRIVILEGES;

USE stock;

DROP TABLE IF EXISTS items;

CREATE TABLE items (
    item_id VARCHAR(255) PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    quantity INT NOT NULL DEFAULT 0,
    price_id VARCHAR(255) NOT NULL,
    version INT NOT NULL DEFAULT 0,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

INSERT INTO items (item_id, name, quantity, price_id, version) VALUES
    ('prod_SNjRcpjxpiazxk', 'Pencil', 100, 'price_1RSxyuPSQHt2xYB8XhSJRSVX', 0),
    ('prod_SNjQpQjNC8QuaD', 'Book', 200, 'price_1RSxy2PSQHt2xYB8uZzd0XQx', 0);