· 7 years ago · Dec 06, 2018, 02:56 AM
1-- phpMyAdmin SQL Dump
2-- version 3.2.1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Dec 06, 2018 at 10:51 AM
7-- Server version: 5.1.37
8-- PHP Version: 5.2.10
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11
12--
13-- Database: `dbciscorp`
14--
15
16-- --------------------------------------------------------
17
18--
19-- Table structure for table `bankmaster`
20--
21
22CREATE TABLE IF NOT EXISTS `bankmaster` (
23 `branchid` varchar(20) NOT NULL,
24 `address` varchar(100) NOT NULL,
25 `branchname` varchar(50) NOT NULL,
26 `city` varchar(30) NOT NULL,
27 `state` varchar(30) NOT NULL,
28 `postalcode` varchar(20) NOT NULL,
29 `contactperson` varchar(50) NOT NULL,
30 `contactno` varchar(30) NOT NULL,
31 `branchtype` varchar(100) NOT NULL,
32 `workinghr` varchar(100) NOT NULL,
33 `defaultvendor` varchar(50) NOT NULL,
34 PRIMARY KEY (`branchid`)
35) ENGINE=MyISAM DEFAULT CHARSET=latin1;
36
37--
38-- Dumping data for table `bankmaster`
39--
40
41INSERT INTO `bankmaster` (`branchid`, `address`, `branchname`, `city`, `state`, `postalcode`, `contactperson`, `contactno`, `branchtype`, `workinghr`, `defaultvendor`) VALUES
42('98213', 'No 55 Jalan Meru, Klang', 'CIMB Klang', 'Klang', 'Selangor', '48827', 'George', '033336577', '', '', 'secguard');
43
44-- --------------------------------------------------------
45
46--
47-- Table structure for table `bankmastertest`
48--
49
50CREATE TABLE IF NOT EXISTS `bankmastertest` (
51 `branchid` varchar(20) NOT NULL,
52 `address` varchar(100) NOT NULL,
53 `branchname` varchar(50) NOT NULL,
54 `city` varchar(30) NOT NULL,
55 `state` varchar(30) NOT NULL,
56 `postalcode` varchar(20) NOT NULL,
57 `contactperson` varchar(50) NOT NULL,
58 `contactno` varchar(30) NOT NULL,
59 `branchtype` varchar(100) NOT NULL,
60 `workinghr` varchar(100) NOT NULL,
61 `defaultvendor` varchar(50) NOT NULL,
62 PRIMARY KEY (`branchid`)
63) ENGINE=MyISAM DEFAULT CHARSET=latin1;
64
65--
66-- Dumping data for table `bankmastertest`
67--
68
69
70-- --------------------------------------------------------
71
72--
73-- Table structure for table `comments`
74--
75
76CREATE TABLE IF NOT EXISTS `comments` (
77 `comment_id` int(11) NOT NULL AUTO_INCREMENT,
78 `comment_subject` varchar(250) NOT NULL,
79 `comment_text` text NOT NULL,
80 `comment_status` int(1) NOT NULL,
81 PRIMARY KEY (`comment_id`)
82) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
83
84--
85-- Dumping data for table `comments`
86--
87
88
89-- --------------------------------------------------------
90
91--
92-- Table structure for table `systemparameter`
93--
94
95CREATE TABLE IF NOT EXISTS `systemparameter` (
96 `setting` varchar(30) NOT NULL,
97 `value` varchar(150) NOT NULL
98) ENGINE=MyISAM DEFAULT CHARSET=latin1;
99
100--
101-- Dumping data for table `systemparameter`
102--
103
104INSERT INTO `systemparameter` (`setting`, `value`) VALUES
105('customerid', '1'),
106('bankid', '1'),
107('vendorid', '1'),
108('ticketno', '3'),
109('guardid', '3');
110
111-- --------------------------------------------------------
112
113--
114-- Table structure for table `ticketmaster`
115--
116
117CREATE TABLE IF NOT EXISTS `ticketmaster` (
118 `ReportNo` varchar(20) NOT NULL,
119 `Status` varchar(20) NOT NULL,
120 `BankStaffID` varchar(20) NOT NULL,
121 `BankContactName` varchar(50) NOT NULL,
122 `Branch` varchar(20) NOT NULL,
123 `TypeofGuard` varchar(30) NOT NULL,
124 `Issue` varchar(500) NOT NULL,
125 `Remarks` varchar(200) NOT NULL,
126 `SecurityCompany` varchar(20) NOT NULL,
127 `LeaveFrom` date NOT NULL,
128 `LeaveTo` date NOT NULL,
129 `RequestDate` datetime NOT NULL,
130 `Assignedby` varchar(30) NOT NULL,
131 `Assignee` varchar(30) DEFAULT NULL,
132 `AssignDate` datetime DEFAULT NULL,
133 `ClosedDate` datetime DEFAULT NULL,
134 `ClosedBy` varchar(20) DEFAULT NULL,
135 `ClosedType` varchar(30) DEFAULT NULL
136) ENGINE=MyISAM DEFAULT CHARSET=latin1;
137
138--
139-- Dumping data for table `ticketmaster`
140--
141
142INSERT INTO `ticketmaster` (`ReportNo`, `Status`, `BankStaffID`, `BankContactName`, `Branch`, `TypeofGuard`, `Issue`, `Remarks`, `SecurityCompany`, `LeaveFrom`, `LeaveTo`, `RequestDate`, `Assignedby`, `Assignee`, `AssignDate`, `ClosedDate`, `ClosedBy`, `ClosedType`) VALUES
143('T2', 'ASSIGNED', 'secguard', ' ', ' ', 'Static Guard', 'On Leave', 'Joslee Will be on leave from 02/12/2018 - 04/12/2018', 'secguard', '2018-12-02', '2018-12-04', '2018-11-25 15:06:01', 'admin', 'karthik', '2018-11-25 15:35:51', NULL, NULL, NULL),
144('T1', 'IN PROGRESS', 'cklang', ' ', ' ', 'Arm Guard', 'Absente', 'Please send another guard immediatelly', 'secguard', '0000-00-00', '0000-00-00', '2018-11-23 13:42:44', 'admin', 'karthik', '2018-11-23 14:16:28', NULL, NULL, NULL);
145
146-- --------------------------------------------------------
147
148--
149-- Table structure for table `usermaster`
150--
151
152CREATE TABLE IF NOT EXISTS `usermaster` (
153 `userid` varchar(30) NOT NULL,
154 `username` varchar(50) NOT NULL,
155 `password` varchar(30) NOT NULL,
156 `status` varchar(20) NOT NULL,
157 `level` int(11) NOT NULL,
158 `cimbbranchid` varchar(20) NOT NULL,
159 `vendorid` varchar(30) NOT NULL DEFAULT '0',
160 `userimage` varchar(30) NOT NULL,
161 PRIMARY KEY (`userid`)
162) ENGINE=MyISAM DEFAULT CHARSET=latin1;
163
164--
165-- Dumping data for table `usermaster`
166--
167
168INSERT INTO `usermaster` (`userid`, `username`, `password`, `status`, `level`, `cimbbranchid`, `vendorid`, `userimage`) VALUES
169('admin', 'Administrator', '21232f297a57a5a743894a0e4a801f', 'Active', 1, '0', '0', 'vinyagar.png'),
170('user', 'System User', '202cb962ac59075b964b07152d234b', 'Active', 2, '0', '0', 'corn.jpg'),
171('secguard', 'Secure Guard', '202cb962ac59075b964b07152d234b', 'Active', 5, '98213', 'secguard', 'durian.jpg'),
172('karthik', 'Karthik', '202cb962ac59075b964b07152d234b', 'Active', 2, '0', '0', 'karthik.jpg'),
173('cklang', 'Cimb Klang', '202cb962ac59075b964b07152d234b', 'Active', 3, '98213', 'secguard', 'orange.jpg');
174
175-- --------------------------------------------------------
176
177--
178-- Table structure for table `vendorguards`
179--
180
181CREATE TABLE IF NOT EXISTS `vendorguards` (
182 `guardid` varchar(30) NOT NULL,
183 `vendorid` varchar(20) NOT NULL,
184 `guardname` varchar(30) NOT NULL,
185 `status` varchar(20) NOT NULL,
186 `armed` varchar(20) NOT NULL,
187 `position` varchar(50) NOT NULL,
188 `branchid` varchar(30) NOT NULL
189) ENGINE=MyISAM DEFAULT CHARSET=latin1;
190
191--
192-- Dumping data for table `vendorguards`
193--
194
195INSERT INTO `vendorguards` (`guardid`, `vendorid`, `guardname`, `status`, `armed`, `position`, `branchid`) VALUES
196('G2', 'secguard', 'Josley', 'Active', 'No', 'Guard', '98213'),
197('G1', 'secguard', 'John Jacky', 'Active', 'Yes', 'Senior Guard', '98213');
198
199-- --------------------------------------------------------
200
201--
202-- Table structure for table `vendormaster`
203--
204
205CREATE TABLE IF NOT EXISTS `vendormaster` (
206 `vendorid` varchar(20) NOT NULL,
207 `vendorname` varchar(50) NOT NULL,
208 `address` varchar(100) NOT NULL,
209 `contactno` varchar(30) NOT NULL,
210 PRIMARY KEY (`vendorid`)
211) ENGINE=MyISAM DEFAULT CHARSET=latin1;
212
213--
214-- Dumping data for table `vendormaster`
215--
216
217INSERT INTO `vendormaster` (`vendorid`, `vendorname`, `address`, `contactno`) VALUES
218('secguard', 'Secure Guard', 'No 1 Jalan Besar, Taman Baru , Klang, Selangor', '0377658894');