diff --git a/README.md b/README.md deleted file mode 100644 index d7028d7..0000000 --- a/README.md +++ /dev/null @@ -1,3 +0,0 @@ -2022-Database -=============== -[Web???](../../pages/) diff --git a/init.sql b/init.sql deleted file mode 100644 index e69de29..0000000 --- a/init.sql +++ /dev/null diff --git a/menu.csv b/menu.csv deleted file mode 100644 index ab176ed..0000000 --- a/menu.csv +++ /dev/null @@ -1,20 +0,0 @@ -1,肉カレーうどん丼,450 -2,ブラウンソース定食,750 -3,担々うどん,450 -4,オリジナルカレーうどん,350 -5,豆腐キムチ牛とじ丼,550 -6,プレミアムキムチチゲカルビ丼,650 -7,プレミアム牛めし,300 -8,豚バラ生姜焼定食,550 -9,キムチ牛めし,450 -10,ビビン丼,550 -11,牛肉カレーうどん,450 -12,レッドソース定食,750 -13,甘々うどん,450 -14,低糖質うどん,350 -15,マンナキムチうどん,550 -16,鬼辛子冷凍うどん,650 -17,隣の家からのお裾分けうどん,300 -18,コシ強めうどん,550 -19,ラーメンうどん,450 -20,ごん兵衛の白い雪うどん,550 diff --git a/restaurant.db b/restaurant.db deleted file mode 100644 index 3ed57a1..0000000 --- a/restaurant.db +++ /dev/null Binary files differ diff --git a/restaurant/README.md b/restaurant/README.md new file mode 100644 index 0000000..d7028d7 --- /dev/null +++ b/restaurant/README.md @@ -0,0 +1,3 @@ +2022-Database +=============== +[Web???](../../pages/) diff --git a/restaurant/init.sql b/restaurant/init.sql new file mode 100644 index 0000000..e69de29 --- /dev/null +++ b/restaurant/init.sql diff --git a/restaurant/menu.csv b/restaurant/menu.csv new file mode 100644 index 0000000..ab176ed --- /dev/null +++ b/restaurant/menu.csv @@ -0,0 +1,20 @@ +1,肉カレーうどん丼,450 +2,ブラウンソース定食,750 +3,担々うどん,450 +4,オリジナルカレーうどん,350 +5,豆腐キムチ牛とじ丼,550 +6,プレミアムキムチチゲカルビ丼,650 +7,プレミアム牛めし,300 +8,豚バラ生姜焼定食,550 +9,キムチ牛めし,450 +10,ビビン丼,550 +11,牛肉カレーうどん,450 +12,レッドソース定食,750 +13,甘々うどん,450 +14,低糖質うどん,350 +15,マンナキムチうどん,550 +16,鬼辛子冷凍うどん,650 +17,隣の家からのお裾分けうどん,300 +18,コシ強めうどん,550 +19,ラーメンうどん,450 +20,ごん兵衛の白い雪うどん,550 diff --git a/restaurant/restaurant.db b/restaurant/restaurant.db new file mode 100644 index 0000000..4dec463 --- /dev/null +++ b/restaurant/restaurant.db Binary files differ diff --git a/restaurant/sales.csv b/restaurant/sales.csv new file mode 100644 index 0000000..3602428 --- /dev/null +++ b/restaurant/sales.csv @@ -0,0 +1,20 @@ +1,13,100,2020-04-30 12:00:00.000 +2,15,101,2020-04-30 14:30:00.000 +3,11,104,2020-04-30 18:30:00.000 +4,17,105,2020-04-30 20:20:00.000 +5,17,110,2020-04-30 20:30:00.000 +6,11,108,2020-05-01 10:30:00.000 +7,13,102,2020-05-01 11:30:00.000 +8,11,101,2020-05-01 12:30:00.000 +9,6,108,2020-05-01 13:30:00.000 +10,1,103,2020-05-01 20:15:00.000 +11,13,105,2020-04-30 12:00:00.000 +12,15,106,2020-04-30 14:30:00.000 +13,1,107,2020-04-30 18:30:00.000 +14,17,104,2020-04-30 20:20:00.000 +15,7,110,2020-04-30 20:30:00.000 +16,1,104,2020-05-01 10:30:00.000 +17,3,105,2020-05-01 11:30:00.000 +18,1,106,2020-05-01 12:30:00.000 +19,16,107,2020-05-01 13:30:00.000 +20,20,108,2020-05-01 20:15:00.000 diff --git a/restaurant/usr.csv b/restaurant/usr.csv new file mode 100644 index 0000000..ba77342 --- /dev/null +++ b/restaurant/usr.csv @@ -0,0 +1,11 @@ +100,煉杏寿郎,ren@com,837456352983 +101,竈炭治郎,tan@com,374564536475 +102,うろこだ象根治,uro@com,84756364758 +103,tomi岡義勇,tomi@com,37465847563 +104,サビと,sabi@com,74635273847 +105,禰󠄀子,nezu@com,93847563527 +106,伊助,ino@com,73625474059 +107,時とお無一郎,toki@com,8102948576 +108,継国縁二,tugi@com,16253748596 +109,赤座,aka@com,7263452417198 +110,被験のエース,fire@com,917237464652 diff --git a/sales.csv b/sales.csv deleted file mode 100644 index 3602428..0000000 --- a/sales.csv +++ /dev/null @@ -1,20 +0,0 @@ -1,13,100,2020-04-30 12:00:00.000 -2,15,101,2020-04-30 14:30:00.000 -3,11,104,2020-04-30 18:30:00.000 -4,17,105,2020-04-30 20:20:00.000 -5,17,110,2020-04-30 20:30:00.000 -6,11,108,2020-05-01 10:30:00.000 -7,13,102,2020-05-01 11:30:00.000 -8,11,101,2020-05-01 12:30:00.000 -9,6,108,2020-05-01 13:30:00.000 -10,1,103,2020-05-01 20:15:00.000 -11,13,105,2020-04-30 12:00:00.000 -12,15,106,2020-04-30 14:30:00.000 -13,1,107,2020-04-30 18:30:00.000 -14,17,104,2020-04-30 20:20:00.000 -15,7,110,2020-04-30 20:30:00.000 -16,1,104,2020-05-01 10:30:00.000 -17,3,105,2020-05-01 11:30:00.000 -18,1,106,2020-05-01 12:30:00.000 -19,16,107,2020-05-01 13:30:00.000 -20,20,108,2020-05-01 20:15:00.000 diff --git a/usr.csv b/usr.csv deleted file mode 100644 index ba77342..0000000 --- a/usr.csv +++ /dev/null @@ -1,11 +0,0 @@ -100,煉杏寿郎,ren@com,837456352983 -101,竈炭治郎,tan@com,374564536475 -102,うろこだ象根治,uro@com,84756364758 -103,tomi岡義勇,tomi@com,37465847563 -104,サビと,sabi@com,74635273847 -105,禰󠄀子,nezu@com,93847563527 -106,伊助,ino@com,73625474059 -107,時とお無一郎,toki@com,8102948576 -108,継国縁二,tugi@com,16253748596 -109,赤座,aka@com,7263452417198 -110,被験のエース,fire@com,917237464652