· 7 years ago · Sep 13, 2018, 04:00 AM
1-- phpMyAdmin SQL Dump
2-- version 4.4.15.9
3-- https://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Sep 13, 2018 at 01:21 AM
7-- Server version: 5.6.36
8-- PHP Version: 5.6.30
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 utf8mb4 */;
18
19--
20-- Database: `CMCITHelpDesk_MBR`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `fault_system`
27--
28
29CREATE TABLE IF NOT EXISTS `fault_system` (
30 `job_name` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'Name of issue',
31 `job_ID` int(6) NOT NULL COMMENT 'Job ID',
32 `priority` int(1) NOT NULL DEFAULT '3' COMMENT 'Issue importance',
33 `date` text COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'Date logged',
34 `room` text COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'Room ID',
35 `problem_component` text COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'Part/computer with issue',
36 `category` text COLLATE utf8mb4_unicode_520_ci COMMENT 'Issue category',
37 `details` text COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'Relevant information',
38 `staff_user` text COLLATE utf8mb4_unicode_520_ci COMMENT 'Staff who logged',
39 `technician_user` text COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'Technician assigned'
40) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
41
42--
43-- Dumping data for table `fault_system`
44--
45
46INSERT INTO `fault_system` (`job_name`, `job_ID`, `priority`, `date`, `room`, `problem_component`, `category`, `details`, `staff_user`, `technician_user`) VALUES
47('Printer broken', 98765, 1, '01/01/18', 'E5', 'Printer', 'Hardware', 'Smashed', '123456', '452918'),
48('Laptop virus', 98766, 5, '01/01/18', 'E1', 'Laptop', 'Software', 'Virus', '123456', '452918'),
49('Virus', 98766, 5, '01/01/18', 'office', 'Laptop', 'Software', 'Virus', '123456', '452918'),
50('Update broken', 98766, 5, '01/01/18', 'office', 'PC', 'Software', 'Update didnt work, broken now', '123456', '452918'),
51('Not sure', 98766, 3, '01/01/18', 'office', 'PC', 'Unknown', 'doesnt work at all', '123456', '452918'),
52('', 0, 3, '2018-09-10 02:41:58', '', '', NULL, '', NULL, ''),
53('', 0, 3, '2018-09-10 02:42:06', '', '', NULL, '', NULL, ''),
54('', 0, 3, '2018-09-10 02:42:15', '', '', NULL, '', NULL, ''),
55('', 0, 3, '2018-09-10 02:42:28', '', '', NULL, '', NULL, ''),
56('', 0, 3, '2018-09-10 02:45:55', '', '', NULL, '', NULL, ''),
57('', 0, 3, '2018-09-10 02:50:03', '', '', NULL, '', NULL, ''),
58('', 0, 3, '2018-09-10 02:58:45', '', '', NULL, '', NULL, ''),
59('', 0, 3, '2018-09-10 03:07:57', '', '', NULL, '', NULL, ''),
60('', 0, 3, '2018-09-10 03:08:09', '', '', NULL, '', NULL, ''),
61('', 0, 3, '2018-09-10 03:20:43', '', '', NULL, '', NULL, ''),
62('', 0, 3, '2018-09-10 03:27:30', '', '', NULL, '', NULL, ''),
63('', 0, 3, '2018-09-10 03:27:35', '', '', NULL, '', NULL, ''),
64('', 0, 3, '2018-09-10 03:27:37', '', '', NULL, '', NULL, ''),
65('', 0, 3, '2018-09-10 03:30:20', '', '', NULL, '', NULL, ''),
66('', 0, 3, '2018-09-10 03:31:06', '', '', NULL, '', NULL, ''),
67('', 0, 3, '2018-09-10 03:31:08', '', '', NULL, '', NULL, ''),
68('', 0, 3, '2018-09-10 03:31:50', '', '', NULL, '', NULL, ''),
69('', 0, 3, '2018-09-10 03:32:39', '', '', NULL, '', NULL, ''),
70('', 0, 3, '2018-09-10 03:38:28', '', '', NULL, '', NULL, ''),
71('', 0, 3, '2018-09-10 03:38:37', '', '', NULL, '', NULL, ''),
72('', 0, 3, '2018-09-10 03:38:38', '', '', NULL, '', NULL, ''),
73('', 0, 3, '2018-09-10 03:38:39', '', '', NULL, '', NULL, ''),
74('', 0, 3, '2018-09-10 03:38:58', '', '', NULL, '', NULL, ''),
75('', 0, 3, '2018-09-10 03:38:59', '', '', NULL, '', NULL, ''),
76('', 0, 3, '2018-09-10 03:39:23', '', '', NULL, '', NULL, ''),
77('', 0, 3, '2018-09-10 03:41:23', '', '', NULL, '', NULL, ''),
78('', 0, 3, '2018-09-10 03:41:48', '', '', NULL, '', NULL, ''),
79('', 0, 3, '2018-09-10 03:41:58', '', '', NULL, '', NULL, ''),
80('', 0, 3, '2018-09-10 03:42:20', '', '', NULL, '', NULL, ''),
81('', 0, 3, '2018-09-10 03:42:25', '', '', NULL, '', NULL, ''),
82('', 0, 3, '2018-09-10 03:42:37', '', '', NULL, '', NULL, ''),
83('', 0, 3, '2018-09-10 03:42:41', '', '', NULL, '', NULL, ''),
84('', 0, 3, '2018-09-10 03:42:46', '', '', NULL, '', NULL, ''),
85('', 0, 3, '2018-09-10 03:42:56', '', '', NULL, '', NULL, ''),
86('', 0, 3, '2018-09-10 03:43:14', '', '', NULL, '', NULL, ''),
87('', 0, 3, '2018-09-10 03:50:58', '', '', NULL, '', NULL, ''),
88('', 0, 3, '2018-09-10 03:57:22', '', '', NULL, '', NULL, ''),
89('', 0, 3, '2018-09-10 03:58:06', '', '', NULL, '', NULL, ''),
90('', 0, 3, '2018-09-10 03:58:33', '', '', NULL, '', NULL, ''),
91('', 0, 3, '2018-09-10 03:58:53', '', '', NULL, '', NULL, ''),
92('', 0, 3, '2018-09-10 04:03:44', '', '', NULL, '', NULL, ''),
93('', 0, 3, '2018-09-10 04:03:52', '', '', NULL, '', NULL, ''),
94('', 0, 3, '2018-09-10 04:10:15', '', '', NULL, '', NULL, ''),
95('', 0, 3, '2018-09-10 04:10:32', '', '', NULL, '', NULL, ''),
96('', 0, 3, '2018-09-10 04:10:58', '', '', NULL, '', NULL, ''),
97('', 0, 3, '2018-09-10 04:11:39', '', '', NULL, '', NULL, ''),
98('', 0, 3, '2018-09-10 04:18:31', '', '', NULL, '', NULL, ''),
99('', 0, 3, '2018-09-10 04:18:41', '', '', NULL, '', NULL, ''),
100('', 0, 3, '2018-09-10 04:24:48', '', '', NULL, '', NULL, ''),
101('', 0, 3, '2018-09-10 04:38:45', '', '', NULL, '', NULL, ''),
102('', 0, 3, '2018-09-13 00:29:03', '', '', NULL, '', NULL, ''),
103('', 0, 3, '2018-09-13 00:29:32', '', '', NULL, '', NULL, ''),
104('', 0, 3, '2018-09-13 00:31:07', '', '', NULL, '', NULL, ''),
105('', 0, 3, '2018-09-13 00:37:41', '', '', NULL, '', NULL, ''),
106('', 0, 3, '2018-09-13 00:38:38', '', '', NULL, '', NULL, ''),
107('', 0, 3, '2018-09-13 00:39:16', '', '', NULL, '', NULL, ''),
108('', 0, 3, '2018-09-13 00:39:30', '', '', NULL, '', NULL, ''),
109('', 0, 3, '2018-09-13 00:39:52', '', '', NULL, '', NULL, ''),
110('', 0, 3, '2018-09-13 00:40:06', '', '', NULL, '', NULL, ''),
111('', 0, 3, '2018-09-13 00:40:13', '', '', NULL, '', NULL, ''),
112('', 0, 3, '2018-09-13 00:40:54', '', '', NULL, '', NULL, ''),
113('', 0, 3, '2018-09-13 00:45:15', '', '', NULL, '', NULL, ''),
114('', 0, 3, '2018-09-13 00:49:06', '', '', NULL, '', NULL, ''),
115('', 0, 3, '2018-09-13 00:49:08', '', '', NULL, '', NULL, ''),
116('', 0, 3, '2018-09-13 00:49:13', '', '', NULL, '', NULL, ''),
117('', 0, 3, '2018-09-13 00:52:53', '', '', NULL, '', NULL, ''),
118('', 0, 3, '2018-09-13 00:55:21', '', '', NULL, '', NULL, ''),
119('', 0, 3, '2018-09-13 00:55:45', '', '', NULL, '', NULL, ''),
120('', 0, 3, '2018-09-13 00:55:45', '', '', NULL, '', NULL, ''),
121('', 0, 3, '2018-09-13 00:56:11', '', '', NULL, '', NULL, ''),
122('', 0, 3, '2018-09-13 00:56:13', '', '', NULL, '', NULL, ''),
123('', 0, 3, '2018-09-13 00:57:11', '', '', NULL, '', NULL, ''),
124('', 0, 3, '2018-09-13 01:09:22', '', '', NULL, '', NULL, ''),
125('', 0, 3, '2018-09-13 01:09:25', '', '', NULL, '', NULL, ''),
126('', 0, 3, '2018-09-13 01:09:26', '', '', NULL, '', NULL, ''),
127('', 0, 3, '2018-09-13 01:09:37', '', '', NULL, '', NULL, ''),
128('', 0, 3, '2018-09-13 01:10:28', '', '', NULL, '', NULL, ''),
129('', 0, 3, '2018-09-13 01:11:27', '', '', NULL, '', NULL, ''),
130('', 0, 3, '2018-09-13 01:11:29', '', '', NULL, '', NULL, ''),
131('', 0, 3, '2018-09-13 01:11:35', '', '', NULL, '', NULL, ''),
132('', 0, 3, '2018-09-13 01:13:17', '', '', NULL, '', NULL, ''),
133('', 0, 3, '2018-09-13 01:13:22', '', '', NULL, '', NULL, ''),
134('', 0, 3, '2018-09-13 01:13:56', '', '', NULL, '', NULL, ''),
135('', 0, 3, '2018-09-13 01:18:03', '', '', NULL, '', NULL, '');
136
137-- --------------------------------------------------------
138
139--
140-- Table structure for table `user`
141--
142
143CREATE TABLE IF NOT EXISTS `user` (
144 `name` text COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'Person name',
145 `email` text COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'Email',
146 `phone#` text COLLATE utf8mb4_unicode_520_ci COMMENT 'Phone Number',
147 `password` text COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'Password',
148 `role` text COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'Job Description',
149 `user` text COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'User ID'
150) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
151
152--
153-- Dumping data for table `user`
154--
155
156INSERT INTO `user` (`name`, `email`, `phone#`, `password`, `role`, `user`) VALUES
157('Jorge Mario Bergoglio', 'askjbakjcb@pay-mon.com', '0491 570 156', 'abc', 'Staff', '123456'),
158('Gerard Way', 'kassadc@pay-mon.com', '0491 570 157', 'abc', 'Staff', '135790'),
159('Ben Pelgrave', 'ben@pay-mon.com', '0491 570 159', 'abc', 'Technician', '452918'),
160('Sophie Mouse', '1908sjbbiusdc@pay-mon.com', '0491 570 158', 'abc', 'Staff', '789123'),
161('Richard Head', 'richhead@pay-mon.com', '0491 570 110', 'abc', 'Supervisor', '938145');
162
163--
164-- Indexes for dumped tables
165--
166
167--
168-- Indexes for table `user`
169--
170ALTER TABLE `user`
171 ADD PRIMARY KEY (`user`(10));
172
173/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
174/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
175/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;