mirror of
https://github.com/3ybactuk/marketplace-go-service-project.git
synced 2025-10-30 05:53:45 +03:00
39 lines
624 B
SQL
39 lines
624 B
SQL
-- +goose Up
|
|
INSERT INTO
|
|
stocks (sku, total_count, reserved)
|
|
VALUES
|
|
(139275865, 65534, 0),
|
|
(2956315, 100, 30),
|
|
(1076963, 100, 35),
|
|
(135717466, 100, 20),
|
|
(135937324, 100, 30),
|
|
(1625903, 10000, 0),
|
|
(1148162, 100, 0),
|
|
(2958025, 100, 0),
|
|
(3596599, 100, 0),
|
|
(3618852, 100, 0),
|
|
(4288068, 100, 0),
|
|
(4465995, 100, 0),
|
|
(30816475, 100, 0),
|
|
(2618151, 100, 0);
|
|
|
|
|
|
-- +goose Down
|
|
DELETE FROM stocks
|
|
WHERE
|
|
sku IN (
|
|
139275865,
|
|
2956315,
|
|
1076963,
|
|
135717466,
|
|
135937324,
|
|
1625903,
|
|
1148162,
|
|
2958025,
|
|
3596599,
|
|
3618852,
|
|
4288068,
|
|
4465995,
|
|
30816475,
|
|
2618151
|
|
); |