-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: 
-- サーバのバージョン： 10.1.26-MariaDB
-- PHP Version: 7.1.9

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `dbkiso1-2022renshu`
--
CREATE DATABASE IF NOT EXISTS `dbkiso1-2022renshu` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
USE `dbkiso1-2022renshu`;

-- --------------------------------------------------------

--
-- テーブルの構造 `renshu_uriage`
--

CREATE TABLE `renshu_uriage` (
  `id` int(11) NOT NULL,
  `sales_date` date DEFAULT NULL,
  `item_name` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `item_price` int(11) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- テーブルのデータのダンプ `renshu_uriage`
--

INSERT INTO `renshu_uriage` (`id`, `sales_date`, `item_name`, `item_price`, `quantity`) VALUES
(2, '2017-08-01', 'クレソン', 198, 5),
(3, '2017-08-01', 'サラダ菜', 128, 3),
(4, '2017-08-01', '白菜', 158, 8),
(5, '2017-08-01', 'ブロッコリー', 198, 2),
(6, '2017-08-01', 'ゴーヤ', 138, 1),
(7, '2017-08-01', 'ゴーヤ', 138, 7),
(8, '2017-08-01', 'しいたけ', 118, 9),
(9, '2017-08-01', '白菜', 158, 9),
(10, '2017-08-01', 'サラダ菜', 128, 4),
(11, '2017-08-01', 'しいたけ', 118, 10),
(12, '2017-08-01', 'しいたけ', 118, 4),
(13, '2017-08-02', 'にんじん', 298, 7),
(14, '2017-08-02', 'レンコン', 98, 3),
(15, '2017-08-02', 'ブロッコリー', 198, 4),
(16, '2017-08-02', 'サラダ菜', 128, 4),
(17, '2017-08-02', 'ゴーヤ', 138, 9),
(18, '2017-08-02', 'ナメコ', 158, 7),
(19, '2017-08-02', 'クレソン', 198, 6),
(20, '2017-08-03', '白菜', 158, 10),
(21, '2017-08-03', 'いちご', 528, 2),
(22, '2017-08-03', 'ナメコ', 158, 2),
(23, '2017-08-03', 'サラダ菜', 128, 2),
(24, '2017-08-03', 'サラダ菜', 128, 3),
(25, '2017-08-03', 'しいたけ', 118, 3),
(26, '2017-08-03', 'にんじん', 298, 8),
(27, '2017-08-03', 'ゴーヤ', 138, 2),
(28, '2017-08-03', 'にんじん', 298, 2),
(29, '2017-08-03', 'しいたけ', 118, 2),
(30, '2017-08-03', 'ナメコ', 158, 7),
(31, '2017-08-04', '白菜', 158, 5),
(32, '2017-08-04', 'しいたけ', 118, 3),
(33, '2017-08-04', 'レンコン', 98, 2),
(34, '2017-08-04', 'いちご', 528, 9),
(35, '2017-08-04', 'サラダ菜', 128, 5),
(36, '2017-08-04', 'ブロッコリー', 198, 6),
(37, '2017-08-04', 'クレソン', 198, 10),
(38, '2017-08-04', 'レンコン', 98, 10),
(39, '2017-08-04', 'クレソン', 198, 6),
(40, '2017-08-04', 'いちご', 528, 5),
(41, '2017-08-05', 'ナメコ', 158, 1),
(42, '2017-08-05', 'ナメコ', 158, 4),
(43, '2017-08-05', 'ブロッコリー', 198, 10),
(44, '2017-08-05', 'レンコン', 98, 8),
(45, '2017-08-05', 'いちご', 528, 2),
(46, '2017-08-05', 'いちご', 528, 10),
(47, '2017-08-05', 'サラダ菜', 128, 8),
(48, '2017-08-05', 'レンコン', 98, 4),
(49, '2017-08-05', 'ブロッコリー', 198, 1),
(50, '2017-08-05', '白菜', 158, 7);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `renshu_uriage`
--
ALTER TABLE `renshu_uriage`
  ADD PRIMARY KEY (`id`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;