-- phpMyAdmin SQL Dump
-- version 4.8.3
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Nov 16, 2018 at 09:39 AM
-- Server version: 10.1.36-MariaDB
-- PHP Version: 7.2.11

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

--
-- Database: `kibutz`
--

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `ID` int(11) NOT NULL,
  `Name` varchar(100) DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `AGE` tinyint(3) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`ID`, `Name`, `email`, `AGE`) VALUES
(1, 'OLEG', 'oleg@gmail.com', 18),
(2, 'SASHA', 'sasha@gmail.com', 28),
(3, 'PETYA', 'nobody@mail.ru', 55),
(6, 'MASHA', 'maria@yandex.ru', 19),
(7, 'OLYA', 'olga.super@mail.ru', 23),
(8, 'ILYA', 'ilya@gmail.com', 32),
(9, 'IGOR', 'igor@tel-ran.com', 54);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`ID`);

--
-- AUTO_INCREMENT for dumped tables
--
ALTER TABLE `users`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
COMMIT;