xCtAePe0

1-- phpMyAdmin SQL Dump
2-- version 4.7.4
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Oct 22, 2018 at 07:33 PM
7-- Server version: 10.1.30-MariaDB
8-- PHP Version: 7.0.27
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: `insertions`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `users`
27--
28
29CREATE TABLE IF NOT EXISTS `users` (
30`id` int(11) NOT NULL,
31  `username` varchar(250) NOT NULL,
32  `password` varchar(250) NOT NULL
33) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
34
35--
36-- Dumping data for table `users`
37--
38
39INSERT INTO `users` (`id`, `username`, `password`) VALUES
40(1, 'jonel', 'jonel');
41
42-- --------------------------------------------------------
43--
44-- Table structure for table `addtable`
45--
46
47CREATE TABLE IF NOT EXISTS `addtable` (
48--
49-- Dumping data for table `addtable`
50--
51
52INSERT INTO `addtable` (`id`, `name`, `mobile`, `plate`, `license`, `Usertype`, `start_time`, `end_time`) VALUES
53
54-- --------------------------------------------------------
55
56--
57-- Table structure for table `admin`
58--
59
60CREATE TABLE IF NOT EXISTS `admin` (
61`id` int(11) NOT NULL,
62  `username` varchar(250) NOT NULL,
63  `password` varchar(250) NOT NULL
64) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
65
66--
67-- Dumping data for table `admin`
68--
69
70INSERT INTO `admin` (`id`, `username`, `password`) VALUES
71(1, 'admin', 'admin');
72
73-- --------------------------------------------------------
74
75--
76-- Table structure for table `slots`
77--
78
79CREATE TABLE IF NOT EXISTS `slots` (
80`slot_id` int(11) NOT NULL,
81`slot_number` int(11) NOT NULL,
82) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;
83
84--
85-- Dumping data for table `slots`
86--
87
88INSERT INTO `slots` (`slot_number`) VALUES
89
90-- --------------------------------------------------------
91
92--
93-- Table structure for table `usertype`
94--
95
96CREATE TABLE IF NOT EXISTS `usertype` (
97`usertype_id int(11) NOT NULL,
98  `usertype_code` varchar(250) NOT NULL,
99  `usertype_description` varchar(250) NOT NULL
100) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;
101
102--
103-- Dumping data for table `usertype`
104--
105
106INSERT INTO `usertype` (`usertype_id`, `usertype_code`, `usertype_description`) VALUES
107(2, 'STD', 'Student'),
108(3, 'FCLT', 'Faculty'),
109(4, 'VST', 'Visitor')
110-- --------------------------------------------------------
111
112--
113-- Table structure for table `timer`
114--
115
116CREATE TABLE IF NOT EXISTS `timer` (
117`id` int(11) NOT NULL,
118  `start_time` varchar(250) NOT NULL,
119  `end_time` varchar(250) NOT NULL
120) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
121
122--
123-- Dumping data for table `timer`
124--
125
126INSERT INTO `timer` (`id`, `start_time`, `end_time`) VALUES
127--
128-- Indexes for dumped tables
129--
130
131--
132-- Indexes for table `users`
133--
134ALTER TABLE `users`
135 ADD PRIMARY KEY (`id`);
136 
137--
138-- Indexes for table `addtable`
139--
140ALTER TABLE `addtable`
141 ADD PRIMARY KEY (`id`);
142
143--
144-- Indexes for table `admin`
145--
146ALTER TABLE `admin`
147 ADD PRIMARY KEY (`id`);
148
149--
150-- Indexes for table `slots`
151--
152ALTER TABLE `slots`
153 ADD PRIMARY KEY (`course_id`);
154
155--
156-- Indexes for table `usertype`
157--
158ALTER TABLE `usertype`
159 ADD PRIMARY KEY (`id`);
160
161--
162-- Indexes for table `timer`
163--
164ALTER TABLE `timer`
165 ADD PRIMARY KEY (`id`);
166
167--
168-- AUTO_INCREMENT for dumped tables
169--
170
171--
172-- AUTO_INCREMENT for table `users`
173--
174ALTER TABLE `users`
175MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=54;
176
177--
178-- AUTO_INCREMENT for table `addtable`
179--
180ALTER TABLE `addtable`
181MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=54;
182--
183-- AUTO_INCREMENT for table `admin`
184--
185ALTER TABLE `admin`
186MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
187--
188-- AUTO_INCREMENT for table `slots`
189--
190ALTER TABLE `slots`
191MODIFY `slots_number` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=18;
192--
193-- AUTO_INCREMENT for table `usertype`
194--
195ALTER TABLE `usertype`
196MODIFY `usertype_id` int(11) NOT NULL AUTO_INCREMENT;
197--
198-- AUTO_INCREMENT for table `timer`
199--
200ALTER TABLE `timer`
201MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=15;
202/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
203/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
204/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;