db

-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Feb 02, 2017 at 04:27 PM
-- Server version: 10.1.13-MariaDB
-- PHP Version: 5.6.23

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `test`
--

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

--
-- Table structure for table `data_test`
--

CREATE TABLE `data_test` (
  `data_id` int(5) NOT NULL,
  `data_name` varchar(100) NOT NULL,
  `data_price` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `data_test`
--

INSERT INTO `data_test` (`data_id`, `data_name`, `data_price`) VALUES
(1, 'item 1', '$1'),
(2, 'item 2', '$2'),
(3, 'item 3', '$3'),
(4, 'item 4', '$4'),
(5, 'item 5', '$5'),
(6, 'item 6', '$6'),
(7, 'item 7', '$7'),
(8, 'item 8', '$8'),
(9, 'item 9', '$9'),
(10, 'item 10', '$10'),
(11, 'item 11', '$11'),
(12, 'item 12', '$12'),
(13, 'item 13', '$13'),
(14, 'item 14', '$14'),
(15, 'item 15', '$15'),
(16, 'item 16', '$16');

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

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `user_id` int(5) NOT NULL,
  `user_email` varchar(50) NOT NULL,
  `user_pass` varchar(50) NOT NULL,
  `user_login` int(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`user_id`, `user_email`, `user_pass`, `user_login`) VALUES
(200, 'test1@gmail.com', '784823b9227d2786db80b3e2defc048e', 0),
(201, 'test2@gmail.com', 'c12e01f2a13ff5587e1e9e4aedb8242d', 0),
(202, 'test3@gmail.com', '01cfcd4f6b8770febfb40cb906715822', 0),
(203, 'test4@gmail.com', '098f6bcd4621d373cade4e832627b4f6', 0),
(204, 'test5@gmail.com', '581da7d4ad6d325419f0d4900f463400', 0);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `data_test`
--
ALTER TABLE `data_test`
  ADD PRIMARY KEY (`data_id`);

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`user_id`),
  ADD UNIQUE KEY `user_email` (`user_email`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `data_test`
--
ALTER TABLE `data_test`
  MODIFY `data_id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `user_id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=218;
/*!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 */;