-
Notifications
You must be signed in to change notification settings - Fork 11
/
Copy pathelims.sql
206 lines (182 loc) · 10.2 KB
/
elims.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
-- phpMyAdmin SQL Dump
-- version 3.5.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 27, 2014 at 10:20 PM
-- Server version: 5.5.24-log
-- PHP Version: 5.3.13
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `elims`
--
-- --------------------------------------------------------
--
-- Table structure for table `complain`
--
CREATE TABLE `complain` (
`username` varchar(50) NOT NULL,
`subject` text NOT NULL,
`date` text NOT NULL,
`toAdminName` varchar(50) NOT NULL,
`email` varchar(60) NOT NULL,
`Complain` longtext NOT NULL,
`isRead` varchar(5) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `complain`
--
INSERT INTO `complain` VALUES('rohit', 'hjhjh', '2014/04/21 11:27:13 am', 'bulle', '[email protected]', 'ghghghg', '');
INSERT INTO `complain` VALUES('qwerty', 'This is a serious note', '2014/05/05 8:57:36 pm', 'admin', '[email protected]', 'This project is about sending and receiving complains to the specified admins in the whole organization.', 'yes');
INSERT INTO `complain` VALUES('qwerty', 'Hey', '2014/05/05 8:59:08 pm', 'cnayak', '[email protected]', 'Hero k cha halkhabar... Sanchai chau :)', 'yes');
INSERT INTO `complain` VALUES('qwerty', 'Hey', '2014/06/04 10:02:43 pm', 'admin', '[email protected]', 'Hey you\r\nThis is really important', 'yes');
INSERT INTO `complain` VALUES('qwerty', 'About Site Addition', '2014/06/07 9:51:01 am', 'admin', '[email protected]', 'Respected Sir,\r\n\r\nThis message is to inform you that a new site must be added in the respective area.\r\n\r\nGeo-Locaiton: Will send you the details in the email attached\r\nLocation:Taplejung\r\nNo. of clients:58\r\nServer Distribution: Windows NT 2002\r\nOrganisation: Taplejung College of Engineering and Management\r\n\r\nYours Sincerely,\r\nHari Bahadur Sherpa\r\nph no: 987874587\r\nEmail Id: [email protected]', 'yes');
INSERT INTO `complain` VALUES('qwerty', 'ss', '2014/06/07 10:18:01 am', 'hhh', 'hhh@hhh', 'sdfsdf\r\n', 'no');
INSERT INTO `complain` VALUES('qwerty', 'sdd', '2014/06/07 10:49:27 am', 'admin', '[email protected]', 'sdsadas', 'yes');
INSERT INTO `complain` VALUES('qwerty', 'Sir', '2014/06/11 2:57:17 pm', 'prabin', '[email protected]', 'Hello', 'yes');
-- --------------------------------------------------------
--
-- Table structure for table `districtdr`
--
CREATE TABLE `districtdr` (
`district` varchar(50) NOT NULL,
`DR` varchar(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `districtdr`
--
INSERT INTO `districtdr` VALUES('Jhapa', 'EDR');
INSERT INTO `districtdr` VALUES('Ilam', 'EDR');
INSERT INTO `districtdr` VALUES('Panchthar', 'EDR');
INSERT INTO `districtdr` VALUES('Taplejung', 'EDR');
INSERT INTO `districtdr` VALUES('Morang', 'EDR');
INSERT INTO `districtdr` VALUES('Sunsari', 'EDR');
INSERT INTO `districtdr` VALUES('Bhojpur', 'EDR');
INSERT INTO `districtdr` VALUES('Dhankuta', 'EDR');
INSERT INTO `districtdr` VALUES('Terhathum', 'EDR');
INSERT INTO `districtdr` VALUES('Sankhuwasabha', 'EDR');
INSERT INTO `districtdr` VALUES('Saptari', 'EDR');
INSERT INTO `districtdr` VALUES('Siraha', 'EDR');
INSERT INTO `districtdr` VALUES('Udayapur', 'EDR');
INSERT INTO `districtdr` VALUES('Khotang', 'EDR');
INSERT INTO `districtdr` VALUES('Okhaldhunga', 'EDR');
INSERT INTO `districtdr` VALUES('Solukhumbu', 'EDR');
INSERT INTO `districtdr` VALUES('Dhanusa', 'CDR');
INSERT INTO `districtdr` VALUES('Mahottari', 'CDR');
INSERT INTO `districtdr` VALUES('Sarlahi', 'CDR');
INSERT INTO `districtdr` VALUES('Sindhuli', 'CDR');
INSERT INTO `districtdr` VALUES('Ramechhap', 'CDR');
INSERT INTO `districtdr` VALUES('Dolakha', 'CDR');
INSERT INTO `districtdr` VALUES('Bhaktapur', 'CDR');
INSERT INTO `districtdr` VALUES('Dhading', 'CDR');
INSERT INTO `districtdr` VALUES('Kathmandu', 'CDR');
INSERT INTO `districtdr` VALUES('Kavrepalanchok', 'CDR');
INSERT INTO `districtdr` VALUES('Lalitpur', 'CDR');
INSERT INTO `districtdr` VALUES('Nuwakot', 'CDR');
INSERT INTO `districtdr` VALUES('Rasuwa', 'CDR');
INSERT INTO `districtdr` VALUES('Sindhupalchok', 'CDR');
INSERT INTO `districtdr` VALUES('Bara', 'CDR');
INSERT INTO `districtdr` VALUES('Parsa', 'CDR');
INSERT INTO `districtdr` VALUES('Rautahat', 'CDR');
INSERT INTO `districtdr` VALUES('Chitwan', 'CDR');
INSERT INTO `districtdr` VALUES('Makwanpur', 'CDR');
INSERT INTO `districtdr` VALUES('Gorkha', 'WDR');
INSERT INTO `districtdr` VALUES('Kaski', 'WDR');
INSERT INTO `districtdr` VALUES('Lamjung', 'WDR');
INSERT INTO `districtdr` VALUES('Syangja', 'WDR');
INSERT INTO `districtdr` VALUES('Tanahu', 'WDR');
INSERT INTO `districtdr` VALUES('Manang', 'WDR');
INSERT INTO `districtdr` VALUES('Kapilvastu', 'WDR');
INSERT INTO `districtdr` VALUES('Nawalparasi', 'WDR');
INSERT INTO `districtdr` VALUES('Rupandehi', 'WDR');
INSERT INTO `districtdr` VALUES('Arghakhanchi', 'WDR');
INSERT INTO `districtdr` VALUES('Gulmi', 'WDR');
INSERT INTO `districtdr` VALUES('Palpa', 'WDR');
INSERT INTO `districtdr` VALUES('Baglung', 'WDR');
INSERT INTO `districtdr` VALUES('Myagdi', 'WDR');
INSERT INTO `districtdr` VALUES('Parbat', 'WDR');
INSERT INTO `districtdr` VALUES('Mustang', 'WDR');
INSERT INTO `districtdr` VALUES('Dang Deukhuri', 'MWDR');
INSERT INTO `districtdr` VALUES('Pyuthan', 'MWDR');
INSERT INTO `districtdr` VALUES('Rolpa', 'MWDR');
INSERT INTO `districtdr` VALUES('Rukum', 'MWDR');
INSERT INTO `districtdr` VALUES('Salyan', 'MWDR');
INSERT INTO `districtdr` VALUES('Dolpa', 'MWDR');
INSERT INTO `districtdr` VALUES('Humla', 'MWDR');
INSERT INTO `districtdr` VALUES('Jumla', 'MWDR');
INSERT INTO `districtdr` VALUES('Kalikot', 'MWDR');
INSERT INTO `districtdr` VALUES('Mugu', 'MWDR');
INSERT INTO `districtdr` VALUES('Banke', 'MWDR');
INSERT INTO `districtdr` VALUES('Bardiya', 'MWDR');
INSERT INTO `districtdr` VALUES('Surkhet', 'MWDR');
INSERT INTO `districtdr` VALUES('Dailekh', 'MWDR');
INSERT INTO `districtdr` VALUES('Jajarkot', 'MWDR');
INSERT INTO `districtdr` VALUES('Kailali', 'FWDR');
INSERT INTO `districtdr` VALUES('Achham', 'FWDR');
INSERT INTO `districtdr` VALUES('Doti', 'FWDR');
INSERT INTO `districtdr` VALUES('Bajhang', 'FWDR');
INSERT INTO `districtdr` VALUES('Bajura', 'FWDR');
INSERT INTO `districtdr` VALUES('Kanchanpur', 'FWDR');
INSERT INTO `districtdr` VALUES('Dadeldhura', 'FWDR');
INSERT INTO `districtdr` VALUES('Baitadi', 'FWDR');
INSERT INTO `districtdr` VALUES('Darchula', 'FWDR');
-- --------------------------------------------------------
--
-- Table structure for table `elims_users`
--
CREATE TABLE `elims_users` (
`userName` varchar(50) NOT NULL,
`userType` varchar(20) NOT NULL,
`password` varchar(50) NOT NULL,
`firstName` varchar(50) NOT NULL,
`lastName` varchar(100) NOT NULL,
`email` varchar(50) NOT NULL,
`gender` varchar(25) NOT NULL,
`location` varchar(50) NOT NULL,
`phoneNumber` varchar(50) NOT NULL,
`profession` varchar(50) NOT NULL,
PRIMARY KEY (`userName`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `elims_users`
--
INSERT INTO `elims_users` VALUES('sysadmin', 'sysadmin', '48a365b4ce1e322a55ae9017f3daf0c0', 'Hey', 'You', '[email protected]', 'male', 'can', '4545', 'asdf');
INSERT INTO `elims_users` VALUES('prabinraz', 'sysadmin', '176226b2d51002d2590f048881560569', 'prabin', 'gautam', '[email protected]', 'male', '111 gm', '6506198408', 'teacher');
INSERT INTO `elims_users` VALUES('testadmin', 'admin', '9283a03246ef2dacdc21a9b137817ec1', 'Test', 'Admin', '[email protected]', 'male', '100 kathmandu', '0123456789', 'volunteer');
INSERT INTO `elims_users` VALUES('testsysadmin', 'sysadmin', 'f6f10eb1377a4e794adb6b3992c7e8e0', 'Test', 'sysadmin', '[email protected]', 'male', '100 kathmandu', '0123456789', 'volunteer');
INSERT INTO `elims_users` VALUES('testuser', 'user', '5d9c68c6c50ed3d02a2fcf54f63993b6', 'Test', 'user', '[email protected]', 'male', '100 kathmandu', '0123456789', 'volunteer');
-- --------------------------------------------------------
--
-- Table structure for table `site_maps`
--
CREATE TABLE `site_maps` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(256) NOT NULL,
`latitude` float(10,6) NOT NULL,
`longitude` float(10,6) NOT NULL,
`organisationName` varchar(255) NOT NULL,
`district` varchar(50) NOT NULL,
`contactPerson` varchar(255) NOT NULL,
`contactNumber` varchar(100) NOT NULL,
`contactEmail` varchar(100) NOT NULL,
`designation` varchar(50) NOT NULL,
`clientNumber` int(255) NOT NULL,
`serverDist` varchar(255) NOT NULL,
`siteAddedBy` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=34 ;
--
-- Dumping data for table `site_maps`
--
INSERT INTO `site_maps` VALUES(6, 'Kalinchowk', 27.664867, 86.051582, 'Kalinchowk Higher Secondary Schoolq', '', 'Kusang Sherpa', '98185369548', '', '', 50, 'Linux', '');
INSERT INTO `site_maps` VALUES(12, 'Bharatpur Cancer Hospital', 27.678663, 84.430618, 'Cancer hospital', '', 'Dr. Rajendra Baral', '9851045821', '[email protected]', 'Senior Oncologist', 56, 'Windows Server 2003 with SP1', '');
INSERT INTO `site_maps` VALUES(26, 'Chandan Home', 27.005302, 84.870842, 'Home of Chandan', 'Parsa', 'Chandan Nayak', '9841525698', '[email protected]', 'Senior Engineer, NTC, Parsa', 58, 'Windows Server 2003 with SP1', 'admin');
INSERT INTO `site_maps` VALUES(27, 'Biratnagar', 26.455820, 87.292557, 'Ganesh Lal Mill', 'Morang', 'Sahu Ganesh Lal', '9851052684', '[email protected]', 'Head ', 89, 'WIndows NT 2002', 'admin');
INSERT INTO `site_maps` VALUES(29, 'Kathmandu University', 27.617079, 85.539917, 'KU', 'Kavrepalanchok', 'Ram Kantha Makaju', '9851104512', '[email protected]', 'Vice Chancellor', 85, 'Windows Server 2003 with SP1', 'admin');
INSERT INTO `site_maps` VALUES(31, 'Pokara Airport', 28.197927, 84.053993, 'Pokhara Bimansthal', 'Kaski', 'Heor', '8', '[email protected]', 'sdf', 85, 'Windows Server 2003 with SP1', 'admin');
INSERT INTO `site_maps` VALUES(33, 'Darchula NP', 30.185495, 80.950356, 'Bhatte House', 'Darchula', 'Abhishek Bhatta', '9808553841', '[email protected]', 'Senior Engineer, Darchula Roads Dept.', 88, 'Windows Server 2003 with SP1', 'admin');