fYpMMux4

1-- phpMyAdmin SQL Dump
2-- version 4.2.7.1
3-- http://www.phpmyadmin.net
4--
5-- Host: sql2.njit.edu
6-- Generation Time: Sep 23, 2019 at 03:49 PM
7-- Server version: 8.0.17
8-- PHP Version: 5.6.40
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `pjz3`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `TestUsers`
27--
28
29CREATE TABLE IF NOT EXISTS `TestUsers` (
30`id` int(11) NOT NULL,
31  `username` varchar(30) NOT NULL,
32  `pin` int(11) DEFAULT '0'
33) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
34
35--
36-- Dumping data for table `TestUsers`
37--
38
39INSERT INTO `TestUsers` (`id`, `username`, `pin`) VALUES
40(1, 'Joe', 1234);
41
42--
43-- Indexes for dumped tables
44--
45
46--
47-- Indexes for table `TestUsers`
48--
49ALTER TABLE `TestUsers`
50 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `username` (`username`);
51
52--
53-- AUTO_INCREMENT for dumped tables
54--
55
56--
57-- AUTO_INCREMENT for table `TestUsers`
58--
59ALTER TABLE `TestUsers`
60MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
61/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
62/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
63/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;