-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathsample-data.sql
More file actions
42 lines (34 loc) ยท 2.05 KB
/
sample-data.sql
File metadata and controls
42 lines (34 loc) ยท 2.05 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
Use howkiki_db;
-- 1. Store ํ
์ด๋ธ์ ์ด๊ธฐ ๋ฐ์ดํฐ ์ฝ์
INSERT INTO stores (store_name, store_status, created_at, modified_at) VALUES
('ํธ์ฐ์ฌ', 'AVAILABLE', NOW(), NOW());
-- 2. Menu ํ
์ด๋ธ ์ด๊ธฐ ๋ฐ์ดํฐ ์ฝ์
UPDATE menu
SET created_at = NOW(), modified_at = NOW();
INSERT INTO menu (store_Id, menu_name, cost, menu_category, menu_status, menu_img_url)
VALUES
(1, '์๋กฑํฌ', 7500, '๋ค์ฌ', 'AVAILABLE', NULL),
(1, 'ํต์์ฐ ์ผ๋ง์ด', 9500, '๋ค์ฌ', 'AVAILABLE', NULL),
(1, '๋ธ๋ ํ๊ฐ์ฐ', 9500, '๋ค์ฌ', 'AVAILABLE', NULL),
(1, 'ํธ๋ฌํ ์ฐจ์ ๋ฐ์ค', 8000, '๋ค์ฌ', 'AVAILABLE', NULL),
(1, 'ํธ์ฐ์ฌ ์ํ', 9500, '๋ค์ฌ', 'AVAILABLE', NULL),
(1, '๋ง๋์นฉ ๊ฟ๋ฐ์ก', 24500, '๋ฉ์ธ๋ฉ๋ด', 'AVAILABLE', NULL),
(1, 'ํ์ฝฉ์ ๋ญ๋ ๊ฐ ํ๊น', 19000, '๋ฉ์ธ๋ฉ๋ด', 'AVAILABLE', NULL),
(1, '์ฏ๋ ๊ฐ์ค์ง์ด ํ๊น', 19500, '๋ฉ์ธ๋ฉ๋ด', 'AVAILABLE', NULL),
(1, 'ํ์ดํฉ๊ณผ', 5000, '์ฌ์ด๋ ๋ฉ๋ด', 'AVAILABLE', NULL),
(1, 'ํ์ฝฉ์ ๋ฐฐ์ถ์ฐ', 8000, '์ฌ์ด๋ ๋ฉ๋ด', 'AVAILABLE', NULL),
(1, '๊ณต์ฌ์ฑ ๋ณถ์', 8500, '์ฌ์ด๋ ๋ฉ๋ด', 'AVAILABLE', NULL),
(1, '๋ผ๊ตฌ์ง์ฅ & ๊ณ๋ ํ๊น ๋ฝ์ง์ดํ', 15000, '๋ฝ์ง์ดํ', 'AVAILABLE', NULL),
(1, '๋ผ์ง๊ณ ๊ธฐ & ๋งํ๋๋ถ ๋ฝ์ง์ดํ', 16500, '๋ฝ์ง์ดํ', 'AVAILABLE', NULL),
(1, '์์ฐ & ๋ผ์ง๊ณ ๊ธฐ ์์ ๋ฝ์ง์ดํ', 17500, '๋ฝ์ง์ดํ', 'AVAILABLE', NULL),
(1, '์ฐ์ก ๊ฐ์ฅ ์กฐ๋ฆผ ๋ฝ์ง์ดํ', 18000, '๋ฝ์ง์ดํ', 'AVAILABLE', NULL),
(1, '๋ง์ ์ฐ์กํ๋ฉด', 13900, '๋ฉด', 'AVAILABLE', NULL),
(1, '๋งค์ด ์๊ณ ๊ธฐํ๋ฉด', 14900, '๋ฉด', 'AVAILABLE', NULL),
(1, '๋งํ๋๋ถ ๋์ญ๋ฉด', 11000, '๋ฉด', 'AVAILABLE', NULL),
(1, '๋ผ๊ตฌ์ง์ฅ ๋์ญ๋ฉด', 9900, '๋ฉด', 'AVAILABLE', NULL),
(1, 'ํธ์ฐ์ฌ ๋ฐํฌํฐ', 6000, '์๋ฃ', 'AVAILABLE', NULL),
(1, 'ํธ์ฐ์ฌ ๋ ๋ชฌํฐ', 6000, '์๋ฃ', 'AVAILABLE', NULL),
(1, '์ฝ์นด์ฝ๋ผ', 4000, '์๋ฃ', 'AVAILABLE', NULL),
(1, '์ฌ์ด๋ค', 4000, '์๋ฃ', 'AVAILABLE', NULL),
(1, 'ํธ์ฐ์ฌ ํ์ฐจ ๋งฅ์ฃผ', 7500, '์๋ฃ', 'AVAILABLE', NULL),
(1, 'ํ์ด๊ฑฐ ๋งฅ์ฃผ', 7500, '์๋ฃ', 'AVAILABLE', NULL);