· 9 years ago · Dec 04, 2016, 11:00 PM
1-- phpMyAdmin SQL Dump
2-- version 4.0.10.12
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.10.65.2:3306
6-- Generation Time: Dec 04, 2016 at 10:57 PM
7-- Server version: 5.5.52
8-- PHP Version: 5.3.3
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: `ugsec`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `Library`
27--
28
29CREATE TABLE IF NOT EXISTS `Library` (
30 `Checkout ID` int(11) NOT NULL AUTO_INCREMENT,
31 `First Name` varchar(30) NOT NULL,
32 `Last Name` varchar(30) NOT NULL,
33 `Email` varchar(30) NOT NULL,
34 `Book Title` varchar(30) NOT NULL,
35 `Due Date` date NOT NULL,
36 `Overdue` tinyint(1) NOT NULL DEFAULT '0',
37 UNIQUE KEY `Checkout ID` (`Checkout ID`)
38) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
39
40--
41-- Dumping data for table `Library`
42--
43
44INSERT INTO `Library` (`Checkout ID`, `First Name`, `Last Name`, `Email`, `Book Title`, `Due Date`, `Overdue`) VALUES
45(1, 'Kevin', 'Kowalsky', 'kkowalsky@elon.edu', 'The Worst Book', '2016-12-05', 0),
46(3, 'Chris', 'G', 'ChrisG@elon.edu', 'The Second Worst Book', '2016-12-05', 0),
47(4, 'Billy', 'Bobson', 'fake@fake.com', 'hello', '2016-12-04', 0);
48
49/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
50/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
51/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;