· 10 years ago · Mar 24, 2016, 05:00 PM
1-- phpMyAdmin SQL Dump
2-- version 4.4.3
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Oct 14, 2015 at 05:51 PM
7-- Server version: 5.6.24
8-- PHP Version: 5.6.8
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: `cdcol`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `cds`
27--
28
29CREATE TABLE IF NOT EXISTS `cds` (
30 `titel` varchar(200) DEFAULT NULL,
31 `interpret` varchar(200) DEFAULT NULL,
32 `jahr` int(11) DEFAULT NULL,
33 `id` bigint(20) unsigned NOT NULL
34) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
35
36--
37-- Dumping data for table `cds`
38--
39
40INSERT INTO `cds` (`titel`, `interpret`, `jahr`, `id`) VALUES
41('Beauty', 'Ryuichi Sakamoto', 1990, 1),
42('Goodbye Country (Hello Nightclub)', 'Groove Armada', 2001, 4),
43('Glee', 'Bran Van 3000', 1997, 5);
44
45--
46-- Indexes for dumped tables
47--
48
49--
50-- Indexes for table `cds`
51--
52ALTER TABLE `cds`
53 ADD PRIMARY KEY (`id`);
54
55--
56-- AUTO_INCREMENT for dumped tables
57--
58
59--
60-- AUTO_INCREMENT for table `cds`
61--
62ALTER TABLE `cds`
63 MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=13;--
64-- Database: `crowd`
65--
66
67-- --------------------------------------------------------
68
69--
70-- Table structure for table `actions`
71--
72
73CREATE TABLE IF NOT EXISTS `actions` (
74 `action_id` int(11) NOT NULL,
75 `action` varchar(75) NOT NULL,
76 `qualifiers` text NOT NULL,
77 `response` varchar(75) NOT NULL,
78 `response_vars` text NOT NULL,
79 `active` tinyint(4) NOT NULL
80) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Stores user defined actions triggered by certain events';
81
82--
83-- Dumping data for table `actions`
84--
85
86INSERT INTO `actions` (`action_id`, `action`, `qualifiers`, `response`, `response_vars`, `active`) VALUES
87(1, 'report_add', 'a:7:{s:4:"user";s:1:"0";s:8:"location";s:8:"anywhere";s:7:"keyword";s:0:"";s:8:"category";a:1:{i:0;s:1:"1";}s:17:"on_specific_count";s:0:"";s:28:"on_specific_count_collective";s:1:"0";s:13:"between_times";i:0;}', 'email', 'a:3:{s:18:"email_send_address";s:25:"divyaupadhyay42@gmail.com";s:13:"email_subject";s:4:"Test";s:10:"email_body";s:6:"Report";}', 1);
88
89-- --------------------------------------------------------
90
91--
92-- Table structure for table `actions_log`
93--
94
95CREATE TABLE IF NOT EXISTS `actions_log` (
96 `id` bigint(20) NOT NULL,
97 `action_id` int(11) NOT NULL,
98 `user_id` int(11) NOT NULL,
99 `time` int(10) NOT NULL
100) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stores a log of triggered actions';
101
102-- --------------------------------------------------------
103
104--
105-- Table structure for table `alert`
106--
107
108CREATE TABLE IF NOT EXISTS `alert` (
109 `id` bigint(20) unsigned NOT NULL,
110 `user_id` int(11) unsigned DEFAULT '0',
111 `alert_type` tinyint(4) NOT NULL COMMENT '1 - MOBILE, 2 - EMAIL',
112 `alert_recipient` varchar(200) DEFAULT NULL,
113 `alert_code` varchar(30) DEFAULT NULL,
114 `alert_confirmed` tinyint(4) NOT NULL DEFAULT '0',
115 `alert_lat` varchar(150) DEFAULT NULL,
116 `alert_lon` varchar(150) DEFAULT NULL,
117 `alert_radius` tinyint(4) NOT NULL DEFAULT '20',
118 `alert_ip` varchar(100) DEFAULT NULL
119) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stores alerts subscribers information';
120
121-- --------------------------------------------------------
122
123--
124-- Table structure for table `alert_category`
125--
126
127CREATE TABLE IF NOT EXISTS `alert_category` (
128 `id` int(11) NOT NULL,
129 `alert_id` bigint(20) unsigned DEFAULT NULL,
130 `category_id` int(11) unsigned DEFAULT NULL
131) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stores subscriber alert categories';
132
133-- --------------------------------------------------------
134
135--
136-- Table structure for table `alert_sent`
137--
138
139CREATE TABLE IF NOT EXISTS `alert_sent` (
140 `id` bigint(20) unsigned NOT NULL,
141 `incident_id` bigint(20) unsigned NOT NULL,
142 `alert_id` bigint(20) unsigned NOT NULL,
143 `alert_date` datetime DEFAULT NULL
144) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stores a log of alerts sent out to subscribers';
145
146-- --------------------------------------------------------
147
148--
149-- Table structure for table `api_banned`
150--
151
152CREATE TABLE IF NOT EXISTS `api_banned` (
153 `id` int(11) unsigned NOT NULL,
154 `banned_ipaddress` varchar(50) NOT NULL,
155 `banned_date` datetime NOT NULL
156) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='For logging banned API IP addresses';
157
158-- --------------------------------------------------------
159
160--
161-- Table structure for table `api_log`
162--
163
164CREATE TABLE IF NOT EXISTS `api_log` (
165 `id` int(11) unsigned NOT NULL,
166 `api_task` varchar(10) NOT NULL,
167 `api_parameters` varchar(100) NOT NULL,
168 `api_records` tinyint(11) NOT NULL,
169 `api_ipaddress` varchar(50) NOT NULL,
170 `api_date` datetime NOT NULL
171) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='For logging API activities';
172
173-- --------------------------------------------------------
174
175--
176-- Table structure for table `api_settings`
177--
178
179CREATE TABLE IF NOT EXISTS `api_settings` (
180 `id` int(11) NOT NULL,
181 `default_record_limit` int(11) NOT NULL DEFAULT '20',
182 `max_record_limit` int(11) DEFAULT NULL,
183 `max_requests_per_ip_address` int(11) DEFAULT NULL,
184 `max_requests_quota_basis` int(11) DEFAULT NULL,
185 `modification_date` datetime NOT NULL
186) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='For storing API logging settings';
187
188-- --------------------------------------------------------
189
190--
191-- Table structure for table `badge`
192--
193
194CREATE TABLE IF NOT EXISTS `badge` (
195 `id` int(11) NOT NULL,
196 `name` varchar(250) NOT NULL,
197 `description` text NOT NULL
198) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stores description of badges to be assigned';
199
200-- --------------------------------------------------------
201
202--
203-- Table structure for table `badge_users`
204--
205
206CREATE TABLE IF NOT EXISTS `badge_users` (
207 `user_id` int(11) unsigned NOT NULL,
208 `badge_id` int(11) NOT NULL
209) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stores assigned badge information';
210
211-- --------------------------------------------------------
212
213--
214-- Table structure for table `category`
215--
216
217CREATE TABLE IF NOT EXISTS `category` (
218 `id` int(11) unsigned NOT NULL,
219 `parent_id` int(11) NOT NULL DEFAULT '0',
220 `locale` varchar(10) NOT NULL DEFAULT 'en_US',
221 `category_position` tinyint(4) NOT NULL DEFAULT '0',
222 `category_title` varchar(255) DEFAULT NULL,
223 `category_description` text,
224 `category_color` varchar(20) DEFAULT NULL,
225 `category_image` varchar(255) DEFAULT NULL,
226 `category_image_thumb` varchar(255) DEFAULT NULL,
227 `category_visible` tinyint(4) NOT NULL DEFAULT '1',
228 `category_trusted` tinyint(4) NOT NULL DEFAULT '0'
229) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='Holds information about categories defined for a deployment';
230
231--
232-- Dumping data for table `category`
233--
234
235INSERT INTO `category` (`id`, `parent_id`, `locale`, `category_position`, `category_title`, `category_description`, `category_color`, `category_image`, `category_image_thumb`, `category_visible`, `category_trusted`) VALUES
236(1, 0, 'en_US', 0, 'Teacher needed. Please Volunteer.', 'Category 1', '9900CC', NULL, NULL, 1, 0),
237(2, 0, 'en_US', 1, 'Immediate attention needed!', 'Category 2', '3300FF', 'category_2_1434869357.png', 'category_2_1434869357_16x16.png', 1, 0),
238(3, 0, 'en_US', 2, 'PCV assigned', 'Category 3', '663300', NULL, NULL, 1, 0),
239(4, 0, 'en_US', 4, 'Trusted Reports', 'Reports from trusted reporters', 'ebe575', NULL, NULL, 1, 1),
240(6, 0, 'en_US', 3, 'Healthcare needed', 'Category 4', '6f9e6b', 'category_6_1434869426.png', 'category_6_1434869426_16x16.png', 1, 0);
241
242-- --------------------------------------------------------
243
244--
245-- Table structure for table `category_lang`
246--
247
248CREATE TABLE IF NOT EXISTS `category_lang` (
249 `id` int(11) unsigned NOT NULL,
250 `category_id` int(11) unsigned NOT NULL,
251 `locale` varchar(10) DEFAULT NULL,
252 `category_title` varchar(255) DEFAULT NULL,
253 `category_description` text
254) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Holds translations for category titles and descriptions';
255
256-- --------------------------------------------------------
257
258--
259-- Table structure for table `city`
260--
261
262CREATE TABLE IF NOT EXISTS `city` (
263 `id` bigint(20) unsigned NOT NULL,
264 `country_id` int(11) DEFAULT NULL,
265 `city` varchar(200) DEFAULT NULL,
266 `city_lat` varchar(150) DEFAULT NULL,
267 `city_lon` varchar(200) DEFAULT NULL
268) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stores cities of countries retrieved by user.';
269
270-- --------------------------------------------------------
271
272--
273-- Table structure for table `cluster`
274--
275
276CREATE TABLE IF NOT EXISTS `cluster` (
277 `id` int(11) NOT NULL,
278 `location_id` bigint(20) unsigned NOT NULL DEFAULT '0',
279 `latitude` double NOT NULL,
280 `longitude` double NOT NULL,
281 `latitude_min` double NOT NULL,
282 `longitude_min` double NOT NULL,
283 `latitude_max` double NOT NULL,
284 `longitude_max` double NOT NULL,
285 `child_count` int(11) NOT NULL,
286 `parent_id` int(11) NOT NULL,
287 `left_side` int(11) NOT NULL,
288 `right_side` int(11) NOT NULL,
289 `level` int(11) NOT NULL,
290 `incident_id` bigint(20) unsigned NOT NULL DEFAULT '0',
291 `category_id` int(11) unsigned NOT NULL DEFAULT '0'
292) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stores information used for clustering of reports on the map.';
293
294-- --------------------------------------------------------
295
296--
297-- Table structure for table `comment`
298--
299
300CREATE TABLE IF NOT EXISTS `comment` (
301 `id` bigint(20) unsigned NOT NULL,
302 `incident_id` bigint(20) unsigned DEFAULT NULL,
303 `user_id` int(11) unsigned DEFAULT '0',
304 `comment_author` varchar(100) DEFAULT NULL,
305 `comment_email` varchar(120) DEFAULT NULL,
306 `comment_description` text,
307 `comment_ip` varchar(100) DEFAULT NULL,
308 `comment_spam` tinyint(4) NOT NULL DEFAULT '0',
309 `comment_active` tinyint(4) NOT NULL DEFAULT '0',
310 `comment_date` datetime DEFAULT NULL,
311 `comment_date_gmt` datetime DEFAULT NULL
312) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stores comments made on reports';
313
314-- --------------------------------------------------------
315
316--
317-- Table structure for table `country`
318--
319
320CREATE TABLE IF NOT EXISTS `country` (
321 `id` int(11) NOT NULL,
322 `iso` varchar(10) DEFAULT NULL,
323 `country` varchar(100) DEFAULT NULL,
324 `capital` varchar(100) DEFAULT NULL,
325 `cities` tinyint(4) NOT NULL DEFAULT '0'
326) ENGINE=MyISAM AUTO_INCREMENT=250 DEFAULT CHARSET=utf8 COMMENT='Stores a list of all countries and their capital cities';
327
328--
329-- Dumping data for table `country`
330--
331
332INSERT INTO `country` (`id`, `iso`, `country`, `capital`, `cities`) VALUES
333(1, 'AD', 'Andorra', 'Andorra la Vella', 0),
334(2, 'AE', 'United Arab Emirates', 'Abu Dhabi', 0),
335(3, 'AF', 'Afghanistan', 'Kabul', 0),
336(4, 'AG', 'Antigua and Barbuda', 'St. John''s', 0),
337(5, 'AI', 'Anguilla', 'The Valley', 0),
338(6, 'AL', 'Albania', 'Tirana', 0),
339(7, 'AM', 'Armenia', 'Yerevan', 0),
340(8, 'AN', 'Netherlands Antilles', 'Willemstad', 0),
341(9, 'AO', 'Angola', 'Luanda', 0),
342(10, 'AQ', 'Antarctica', '', 0),
343(11, 'AR', 'Argentina', 'Buenos Aires', 0),
344(12, 'AS', 'American Samoa', 'Pago Pago', 0),
345(13, 'AT', 'Austria', 'Vienna', 0),
346(14, 'AU', 'Australia', 'Canberra', 0),
347(15, 'AW', 'Aruba', 'Oranjestad', 0),
348(16, 'AX', 'Aland Islands', 'Mariehamn', 0),
349(17, 'AZ', 'Azerbaijan', 'Baku', 0),
350(18, 'BA', 'Bosnia and Herzegovina', 'Sarajevo', 0),
351(19, 'BB', 'Barbados', 'Bridgetown', 0),
352(20, 'BD', 'Bangladesh', 'Dhaka', 0),
353(21, 'BE', 'Belgium', 'Brussels', 0),
354(22, 'BF', 'Burkina Faso', 'Ouagadougou', 0),
355(23, 'BG', 'Bulgaria', 'Sofia', 0),
356(24, 'BH', 'Bahrain', 'Manama', 0),
357(25, 'BI', 'Burundi', 'Bujumbura', 0),
358(26, 'BJ', 'Benin', 'Porto-Novo', 0),
359(27, 'BL', 'Saint Barthélemy', 'Gustavia', 0),
360(28, 'BM', 'Bermuda', 'Hamilton', 0),
361(29, 'BN', 'Brunei', 'Bandar Seri Begawan', 0),
362(30, 'BO', 'Bolivia', 'La Paz', 0),
363(31, 'BR', 'Brazil', 'BrasÃÂlia', 0),
364(32, 'BS', 'Bahamas', 'Nassau', 0),
365(33, 'BT', 'Bhutan', 'Thimphu', 0),
366(34, 'BV', 'Bouvet Island', '', 0),
367(35, 'BW', 'Botswana', 'Gaborone', 0),
368(36, 'BY', 'Belarus', 'Minsk', 0),
369(37, 'BZ', 'Belize', 'Belmopan', 0),
370(38, 'CA', 'Canada', 'Ottawa', 0),
371(39, 'CC', 'Cocos Islands', 'West Island', 0),
372(40, 'CD', 'Democratic Republic of the Congo', 'Kinshasa', 0),
373(41, 'CF', 'Central African Republic', 'Bangui', 0),
374(42, 'CG', 'Congo Brazzavile', 'Brazzaville', 0),
375(43, 'CH', 'Switzerland', 'Berne', 0),
376(44, 'CI', 'Ivory Coast', 'Yamoussoukro', 0),
377(45, 'CK', 'Cook Islands', 'Avarua', 0),
378(46, 'CL', 'Chile', 'Santiago', 0),
379(47, 'CM', 'Cameroon', 'Yaoundé', 0),
380(48, 'CN', 'China', 'Beijing', 0),
381(49, 'CO', 'Colombia', 'Bogotá', 0),
382(50, 'CR', 'Costa Rica', 'San José', 0),
383(51, 'CS', 'Serbia and Montenegro', 'Belgrade', 0),
384(52, 'CU', 'Cuba', 'Havana', 0),
385(53, 'CV', 'Cape Verde', 'Praia', 0),
386(54, 'CX', 'Christmas Island', 'Flying Fish Cove', 0),
387(55, 'CY', 'Cyprus', 'Nicosia', 0),
388(56, 'CZ', 'Czech Republic', 'Prague', 0),
389(57, 'DE', 'Germany', 'Berlin', 0),
390(58, 'DJ', 'Djibouti', 'Djibouti', 0),
391(59, 'DK', 'Denmark', 'Copenhagen', 0),
392(60, 'DM', 'Dominica', 'Roseau', 0),
393(61, 'DO', 'Dominican Republic', 'Santo Domingo', 0),
394(62, 'DZ', 'Algeria', 'Algiers', 0),
395(63, 'EC', 'Ecuador', 'Quito', 0),
396(64, 'EE', 'Estonia', 'Tallinn', 0),
397(65, 'EG', 'Egypt', 'Cairo', 0),
398(66, 'EH', 'Western Sahara', 'El-Aaiun', 0),
399(67, 'ER', 'Eritrea', 'Asmara', 0),
400(68, 'ES', 'Spain', 'Madrid', 0),
401(69, 'ET', 'Ethiopia', 'Addis Ababa', 0),
402(70, 'FI', 'Finland', 'Helsinki', 0),
403(71, 'FJ', 'Fiji', 'Suva', 0),
404(72, 'FK', 'Falkland Islands', 'Stanley', 0),
405(73, 'FM', 'Micronesia', 'Palikir', 0),
406(74, 'FO', 'Faroe Islands', 'Tórshavn', 0),
407(75, 'FR', 'France', 'Paris', 0),
408(76, 'GA', 'Gabon', 'Libreville', 0),
409(77, 'GB', 'United Kingdom', 'London', 0),
410(78, 'GD', 'Grenada', 'St. George''s', 0),
411(79, 'GE', 'Georgia', 'Tbilisi', 0),
412(80, 'GF', 'French Guiana', 'Cayenne', 0),
413(81, 'GG', 'Guernsey', 'St Peter Port', 0),
414(82, 'GH', 'Ghana', 'Accra', 0),
415(83, 'GI', 'Gibraltar', 'Gibraltar', 0),
416(84, 'GL', 'Greenland', 'Nuuk', 0),
417(85, 'GM', 'Gambia', 'Banjul', 0),
418(86, 'GN', 'Guinea', 'Conakry', 0),
419(87, 'GP', 'Guadeloupe', 'Basse-Terre', 0),
420(88, 'GQ', 'Equatorial Guinea', 'Malabo', 0),
421(89, 'GR', 'Greece', 'Athens', 0),
422(90, 'GS', 'South Georgia and the South Sandwich Islands', 'Grytviken', 0),
423(91, 'GT', 'Guatemala', 'Guatemala City', 0),
424(92, 'GU', 'Guam', 'Hagåtña', 0),
425(93, 'GW', 'Guinea-Bissau', 'Bissau', 0),
426(94, 'GY', 'Guyana', 'Georgetown', 0),
427(95, 'HK', 'Hong Kong', 'Hong Kong', 0),
428(96, 'HM', 'Heard Island and McDonald Islands', '', 0),
429(97, 'HN', 'Honduras', 'Tegucigalpa', 0),
430(98, 'HR', 'Croatia', 'Zagreb', 0),
431(99, 'HT', 'Haiti', 'Port-au-Prince', 0),
432(100, 'HU', 'Hungary', 'Budapest', 0),
433(101, 'ID', 'Indonesia', 'Jakarta', 0),
434(102, 'IE', 'Ireland', 'Dublin', 0),
435(103, 'IL', 'Israel', 'Jerusalem', 0),
436(104, 'IM', 'Isle of Man', 'Douglas, Isle of Man', 0),
437(105, 'IN', 'India', 'New Delhi', 0),
438(106, 'IO', 'British Indian Ocean Territory', 'Diego Garcia', 0),
439(107, 'IQ', 'Iraq', 'Baghdad', 0),
440(108, 'IR', 'Iran', 'Tehran', 0),
441(109, 'IS', 'Iceland', 'ReykjavÃÂk', 0),
442(110, 'IT', 'Italy', 'Rome', 0),
443(111, 'JE', 'Jersey', 'Saint Helier', 0),
444(112, 'JM', 'Jamaica', 'Kingston', 0),
445(113, 'JO', 'Jordan', 'Amman', 0),
446(114, 'JP', 'Japan', 'Tokyo', 0),
447(115, 'KE', 'Kenya', 'Nairobi', 0),
448(116, 'KG', 'Kyrgyzstan', 'Bishkek', 0),
449(117, 'KH', 'Cambodia', 'Phnom Penh', 0),
450(118, 'KI', 'Kiribati', 'South Tarawa', 0),
451(119, 'KM', 'Comoros', 'Moroni', 0),
452(120, 'KN', 'Saint Kitts and Nevis', 'Basseterre', 0),
453(121, 'KP', 'North Korea', 'Pyongyang', 0),
454(122, 'KR', 'South Korea', 'Seoul', 0),
455(123, 'KW', 'Kuwait', 'Kuwait City', 0),
456(124, 'KY', 'Cayman Islands', 'George Town', 0),
457(125, 'KZ', 'Kazakhstan', 'Astana', 0),
458(126, 'LA', 'Laos', 'Vientiane', 0),
459(127, 'LB', 'Lebanon', 'Beirut', 0),
460(128, 'LC', 'Saint Lucia', 'Castries', 0),
461(129, 'LI', 'Liechtenstein', 'Vaduz', 0),
462(130, 'LK', 'Sri Lanka', 'Colombo', 0),
463(131, 'LR', 'Liberia', 'Monrovia', 0),
464(132, 'LS', 'Lesotho', 'Maseru', 0),
465(133, 'LT', 'Lithuania', 'Vilnius', 0),
466(134, 'LU', 'Luxembourg', 'Luxembourg', 0),
467(135, 'LV', 'Latvia', 'Riga', 0),
468(136, 'LY', 'Libya', 'Tripolis', 0),
469(137, 'MA', 'Morocco', 'Rabat', 0),
470(138, 'MC', 'Monaco', 'Monaco', 0),
471(139, 'MD', 'Moldova', 'Chi_in_u', 0),
472(140, 'ME', 'Montenegro', 'Podgorica', 0),
473(141, 'MF', 'Saint Martin', 'Marigot', 0),
474(142, 'MG', 'Madagascar', 'Antananarivo', 0),
475(143, 'MH', 'Marshall Islands', 'Uliga', 0),
476(144, 'MK', 'Macedonia', 'Skopje', 0),
477(145, 'ML', 'Mali', 'Bamako', 0),
478(146, 'MM', 'Myanmar', 'Yangon', 0),
479(147, 'MN', 'Mongolia', 'Ulan Bator', 0),
480(148, 'MO', 'Macao', 'Macao', 0),
481(149, 'MP', 'Northern Mariana Islands', 'Saipan', 0),
482(150, 'MQ', 'Martinique', 'Fort-de-France', 0),
483(151, 'MR', 'Mauritania', 'Nouakchott', 0),
484(152, 'MS', 'Montserrat', 'Plymouth', 0),
485(153, 'MT', 'Malta', 'Valletta', 0),
486(154, 'MU', 'Mauritius', 'Port Louis', 0),
487(155, 'MV', 'Maldives', 'Malé', 0),
488(156, 'MW', 'Malawi', 'Lilongwe', 0),
489(157, 'MX', 'Mexico', 'Mexico City', 0),
490(158, 'MY', 'Malaysia', 'Kuala Lumpur', 0),
491(159, 'MZ', 'Mozambique', 'Maputo', 0),
492(160, 'NA', 'Namibia', 'Windhoek', 0),
493(161, 'NC', 'New Caledonia', 'Nouméa', 0),
494(162, 'NE', 'Niger', 'Niamey', 0),
495(163, 'NF', 'Norfolk Island', 'Kingston', 0),
496(164, 'NG', 'Nigeria', 'Abuja', 0),
497(165, 'NI', 'Nicaragua', 'Managua', 0),
498(166, 'NL', 'Netherlands', 'Amsterdam', 0),
499(167, 'NO', 'Norway', 'Oslo', 0),
500(168, 'NP', 'Nepal', 'Kathmandu', 0),
501(169, 'NR', 'Nauru', 'Yaren', 0),
502(170, 'NU', 'Niue', 'Alofi', 0),
503(171, 'NZ', 'New Zealand', 'Wellington', 0),
504(172, 'OM', 'Oman', 'Muscat', 0),
505(173, 'PA', 'Panama', 'Panama City', 0),
506(174, 'PE', 'Peru', 'Lima', 0),
507(175, 'PF', 'French Polynesia', 'Papeete', 0),
508(176, 'PG', 'Papua New Guinea', 'Port Moresby', 0),
509(177, 'PH', 'Philippines', 'Manila', 0),
510(178, 'PK', 'Pakistan', 'Islamabad', 0),
511(179, 'PL', 'Poland', 'Warsaw', 0),
512(180, 'PM', 'Saint Pierre and Miquelon', 'Saint-Pierre', 0),
513(181, 'PN', 'Pitcairn', 'Adamstown', 0),
514(182, 'PR', 'Puerto Rico', 'San Juan', 0),
515(183, 'PS', 'Palestinian Territory', 'East Jerusalem', 0),
516(184, 'PT', 'Portugal', 'Lisbon', 0),
517(185, 'PW', 'Palau', 'Koror', 0),
518(186, 'PY', 'Paraguay', 'Asunción', 0),
519(187, 'QA', 'Qatar', 'Doha', 0),
520(188, 'RE', 'Reunion', 'Saint-Denis', 0),
521(189, 'RO', 'Romania', 'Bucharest', 0),
522(190, 'RS', 'Serbia', 'Belgrade', 0),
523(191, 'RU', 'Russia', 'Moscow', 0),
524(192, 'RW', 'Rwanda', 'Kigali', 0),
525(193, 'SA', 'Saudi Arabia', 'Riyadh', 0),
526(194, 'SB', 'Solomon Islands', 'Honiara', 0),
527(195, 'SC', 'Seychelles', 'Victoria', 0),
528(196, 'SD', 'Sudan', 'Khartoum', 0),
529(197, 'SE', 'Sweden', 'Stockholm', 0),
530(198, 'SG', 'Singapore', 'Singapur', 0),
531(199, 'SH', 'Saint Helena', 'Jamestown', 0),
532(200, 'SI', 'Slovenia', 'Ljubljana', 0),
533(201, 'SJ', 'Svalbard and Jan Mayen', 'Longyearbyen', 0),
534(202, 'SK', 'Slovakia', 'Bratislava', 0),
535(203, 'SL', 'Sierra Leone', 'Freetown', 0),
536(204, 'SM', 'San Marino', 'San Marino', 0),
537(205, 'SN', 'Senegal', 'Dakar', 0),
538(206, 'SO', 'Somalia', 'Mogadishu', 0),
539(207, 'SR', 'Suriname', 'Paramaribo', 0),
540(208, 'ST', 'Sao Tome and Principe', 'São Tomé', 0),
541(209, 'SV', 'El Salvador', 'San Salvador', 0),
542(210, 'SY', 'Syria', 'Damascus', 0),
543(211, 'SZ', 'Swaziland', 'Mbabane', 0),
544(212, 'TC', 'Turks and Caicos Islands', 'Cockburn Town', 0),
545(213, 'TD', 'Chad', 'N''Djamena', 0),
546(214, 'TF', 'French Southern Territories', 'Martin-de-Viviès', 0),
547(215, 'TG', 'Togo', 'Lomé', 0),
548(216, 'TH', 'Thailand', 'Bangkok', 0),
549(217, 'TJ', 'Tajikistan', 'Dushanbe', 0),
550(218, 'TK', 'Tokelau', '', 0),
551(219, 'TL', 'East Timor', 'Dili', 0),
552(220, 'TM', 'Turkmenistan', 'Ashgabat', 0),
553(221, 'TN', 'Tunisia', 'Tunis', 0),
554(222, 'TO', 'Tonga', 'Nuku''alofa', 0),
555(223, 'TR', 'Turkey', 'Ankara', 0),
556(224, 'TT', 'Trinidad and Tobago', 'Port of Spain', 0),
557(225, 'TV', 'Tuvalu', 'Vaiaku', 0),
558(226, 'TW', 'Taiwan', 'Taipei', 0),
559(227, 'TZ', 'Tanzania', 'Dar es Salaam', 0),
560(228, 'UA', 'Ukraine', 'Kiev', 0),
561(229, 'UG', 'Uganda', 'Kampala', 0),
562(230, 'UM', 'United States Minor Outlying Islands', '', 0),
563(231, 'US', 'United States', 'Washington', 0),
564(232, 'UY', 'Uruguay', 'Montevideo', 0),
565(233, 'UZ', 'Uzbekistan', 'Tashkent', 0),
566(234, 'VA', 'Vatican', 'Vatican City', 0),
567(235, 'VC', 'Saint Vincent and the Grenadines', 'Kingstown', 0),
568(236, 'VE', 'Venezuela', 'Caracas', 0),
569(237, 'VG', 'British Virgin Islands', 'Road Town', 0),
570(238, 'VI', 'U.S. Virgin Islands', 'Charlotte Amalie', 0),
571(239, 'VN', 'Vietnam', 'Hanoi', 0),
572(240, 'VU', 'Vanuatu', 'Port Vila', 0),
573(241, 'WF', 'Wallis and Futuna', 'Matâ''Utu', 0),
574(242, 'WS', 'Samoa', 'Apia', 0),
575(243, 'YE', 'Yemen', 'San‘a’', 0),
576(244, 'YT', 'Mayotte', 'Mamoudzou', 0),
577(245, 'ZA', 'South Africa', 'Pretoria', 0),
578(246, 'ZM', 'Zambia', 'Lusaka', 0),
579(247, 'ZW', 'Zimbabwe', 'Harare', 0),
580(248, 'XK', 'Kosovo', 'Pristina', 0),
581(249, 'SS', 'South Sudan', 'Juba', 0);
582
583-- --------------------------------------------------------
584
585--
586-- Table structure for table `externalapp`
587--
588
589CREATE TABLE IF NOT EXISTS `externalapp` (
590 `id` int(11) NOT NULL,
591 `name` varchar(255) NOT NULL,
592 `url` varchar(255) NOT NULL
593) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='Info on external apps(mobile) that work with your deployment';
594
595--
596-- Dumping data for table `externalapp`
597--
598
599INSERT INTO `externalapp` (`id`, `name`, `url`) VALUES
600(1, 'iPhone', 'http://download.ushahidi.com/track_download.php?download=ios'),
601(2, 'Android', 'http://download.ushahidi.com/track_download.php?download=android');
602
603-- --------------------------------------------------------
604
605--
606-- Table structure for table `feed`
607--
608
609CREATE TABLE IF NOT EXISTS `feed` (
610 `id` int(11) unsigned NOT NULL,
611 `feed_name` varchar(255) DEFAULT NULL,
612 `feed_url` varchar(255) DEFAULT NULL,
613 `feed_cache` text,
614 `feed_active` tinyint(4) DEFAULT '1',
615 `feed_update` int(11) NOT NULL DEFAULT '0'
616) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Information about RSS Feeds a deployment subscribes to';
617
618-- --------------------------------------------------------
619
620--
621-- Table structure for table `feed_item`
622--
623
624CREATE TABLE IF NOT EXISTS `feed_item` (
625 `id` bigint(20) unsigned NOT NULL,
626 `feed_id` int(11) unsigned NOT NULL,
627 `location_id` bigint(20) unsigned DEFAULT '0',
628 `incident_id` bigint(20) unsigned NOT NULL DEFAULT '0',
629 `item_title` varchar(255) DEFAULT NULL,
630 `item_description` text,
631 `item_link` varchar(255) DEFAULT NULL,
632 `item_date` datetime DEFAULT NULL
633) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stores feed items pulled from each RSS Feed';
634
635-- --------------------------------------------------------
636
637--
638-- Table structure for table `feed_item_category`
639--
640
641CREATE TABLE IF NOT EXISTS `feed_item_category` (
642 `id` int(11) NOT NULL,
643 `feed_item_id` bigint(20) unsigned NOT NULL DEFAULT '0',
644 `category_id` int(11) unsigned NOT NULL DEFAULT '0'
645) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stores fetched feed items categories';
646
647-- --------------------------------------------------------
648
649--
650-- Table structure for table `form`
651--
652
653CREATE TABLE IF NOT EXISTS `form` (
654 `id` int(11) NOT NULL,
655 `form_title` varchar(200) NOT NULL,
656 `form_description` text,
657 `form_active` tinyint(4) DEFAULT '1',
658 `report_title_name` varchar(200) DEFAULT NULL,
659 `description_name` varchar(200) DEFAULT NULL,
660 `description_active` tinyint(4) DEFAULT '1'
661) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Stores all report submission forms created(default+custom)';
662
663--
664-- Dumping data for table `form`
665--
666
667INSERT INTO `form` (`id`, `form_title`, `form_description`, `form_active`, `report_title_name`, `description_name`, `description_active`) VALUES
668(1, 'Student Report', 'Default form, for report entry', 1, NULL, NULL, 0);
669
670-- --------------------------------------------------------
671
672--
673-- Table structure for table `form_field`
674--
675
676CREATE TABLE IF NOT EXISTS `form_field` (
677 `id` int(11) NOT NULL,
678 `form_id` int(11) NOT NULL DEFAULT '1',
679 `field_name` varchar(200) DEFAULT NULL,
680 `field_description` text,
681 `field_type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1 - TEXTFIELD, 2 - TEXTAREA (FREETEXT), 3 - DATE, 4 - PASSWORD, 5 - RADIO, 6 - CHECKBOX',
682 `field_required` tinyint(4) DEFAULT '0',
683 `field_position` tinyint(4) NOT NULL DEFAULT '0',
684 `field_default` text,
685 `field_maxlength` int(11) NOT NULL DEFAULT '0',
686 `field_width` smallint(6) NOT NULL DEFAULT '0',
687 `field_height` tinyint(4) DEFAULT '5',
688 `field_isdate` tinyint(4) NOT NULL DEFAULT '0',
689 `field_ispublic_visible` tinyint(4) NOT NULL DEFAULT '0',
690 `field_ispublic_submit` tinyint(4) NOT NULL DEFAULT '0'
691) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT='Stores all custom form fields created by users';
692
693--
694-- Dumping data for table `form_field`
695--
696
697INSERT INTO `form_field` (`id`, `form_id`, `field_name`, `field_description`, `field_type`, `field_required`, `field_position`, `field_default`, `field_maxlength`, `field_width`, `field_height`, `field_isdate`, `field_ispublic_visible`, `field_ispublic_submit`) VALUES
698(1, 1, 'Name', '', 1, 1, 1, '', 0, 0, 5, 0, 0, 0),
699(2, 1, 'Age', '', 1, 1, 2, '', 0, 0, 5, 0, 0, 0),
700(3, 1, 'Gender', '', 7, 0, 3, 'Male,Female,Other', 0, 0, 5, 0, 0, 0),
701(4, 1, 'Does the child know ASL?', '', 5, 1, 4, 'Yes,No,Not very well', 0, 0, 5, 0, 0, 0),
702(5, 1, 'Does the child go to a school?', '', 5, 1, 5, 'Yes,No', 0, 0, 5, 0, 0, 0),
703(6, 1, 'Previous PCVs teaching', 'Was the child taught by any PCV previously? If yes, give their names.', 1, 0, 6, '', 0, 0, 5, 0, 0, 0),
704(12, 1, 'How much has been taught to the child till now?', 'State topics, subjects etc. covered.', 2, 0, 7, '', 0, 0, 5, 0, 0, 0),
705(11, 1, 'Educational Requirements', 'What needs to be taught to the child at this level? Also, mention if ASL is to be taught as well.', 2, 1, 8, '', 0, 0, 5, 0, 0, 0),
706(13, 1, 'Any Healthcare Requirements', 'Does the child complain of any disease or ailment? Do you think s/he needs a health check-up?', 2, 0, 10, '', 0, 0, 5, 0, 0, 0),
707(10, 1, 'Books or stationery required', 'If yes, state the particular items required and their quantities.', 2, 0, 9, '', 0, 0, 5, 0, 0, 0),
708(14, 1, 'Any other requirements or remarks', '', 1, 0, 11, '', 0, 0, 5, 0, 0, 0);
709
710-- --------------------------------------------------------
711
712--
713-- Table structure for table `form_field_option`
714--
715
716CREATE TABLE IF NOT EXISTS `form_field_option` (
717 `id` int(11) NOT NULL,
718 `form_field_id` int(11) NOT NULL DEFAULT '0',
719 `option_name` varchar(200) DEFAULT NULL,
720 `option_value` text
721) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='Options related to custom form fields';
722
723--
724-- Dumping data for table `form_field_option`
725--
726
727INSERT INTO `form_field_option` (`id`, `form_field_id`, `option_name`, `option_value`) VALUES
728(1, 1, 'field_datatype', 'text'),
729(2, 1, 'field_hidden', '0'),
730(3, 2, 'field_datatype', 'numeric'),
731(4, 2, 'field_hidden', '0'),
732(5, 6, 'field_datatype', 'text'),
733(6, 6, 'field_hidden', '0'),
734(15, 12, 'field_datatype', 'text'),
735(14, 11, 'field_datatype', 'text'),
736(13, 10, 'field_datatype', 'text'),
737(16, 13, 'field_datatype', 'text'),
738(17, 14, 'field_datatype', 'text'),
739(18, 14, 'field_hidden', '0');
740
741-- --------------------------------------------------------
742
743--
744-- Table structure for table `form_response`
745--
746
747CREATE TABLE IF NOT EXISTS `form_response` (
748 `id` bigint(20) NOT NULL,
749 `form_field_id` int(11) NOT NULL,
750 `incident_id` bigint(20) unsigned NOT NULL,
751 `form_response` text NOT NULL
752) ENGINE=MyISAM AUTO_INCREMENT=333 DEFAULT CHARSET=utf8 COMMENT='Stores responses to custom form fields';
753
754--
755-- Dumping data for table `form_response`
756--
757
758INSERT INTO `form_response` (`id`, `form_field_id`, `incident_id`, `form_response`) VALUES
759(50, 14, 20, '---'),
760(49, 13, 20, '---'),
761(48, 10, 20, '---'),
762(47, 11, 20, '---'),
763(46, 12, 20, '---'),
764(45, 6, 20, 'none'),
765(44, 5, 20, 'No'),
766(43, 4, 20, 'No'),
767(42, 3, 20, 'Female'),
768(41, 2, 20, '4'),
769(40, 1, 20, 'princy'),
770(51, 1, 23, 'valeria johns'),
771(52, 2, 23, '4'),
772(53, 3, 23, 'Female'),
773(54, 4, 23, 'No'),
774(55, 5, 23, 'No'),
775(56, 6, 23, 'none'),
776(57, 12, 23, 'test'),
777(58, 11, 23, 'test'),
778(59, 10, 23, 'test'),
779(60, 13, 23, 'test'),
780(61, 14, 23, 'test'),
781(102, 11, 29, 'ASL needed.\nMaths,science and english for 3rd grade.'),
782(101, 12, 29, 'Primary ed'),
783(100, 6, 29, 'Tania Joseph'),
784(99, 5, 29, 'Yes'),
785(98, 4, 29, 'No'),
786(97, 3, 29, 'Female'),
787(96, 2, 29, '7'),
788(95, 1, 29, 'Mary'),
789(103, 10, 29, 'pencils, copies, books'),
790(104, 13, 29, 'yes, she has mild fever'),
791(105, 14, 29, 'no'),
792(106, 1, 4, 'sarah'),
793(107, 2, 4, '4'),
794(108, 3, 4, 'Female'),
795(109, 4, 4, 'Not very well'),
796(110, 5, 4, 'Yes'),
797(111, 6, 4, ''),
798(112, 12, 4, ''),
799(113, 11, 4, 'test'),
800(114, 10, 4, ''),
801(115, 13, 4, ''),
802(116, 14, 4, ''),
803(117, 1, 3, 'Tom'),
804(118, 2, 3, '8'),
805(119, 3, 3, 'Male'),
806(120, 4, 3, 'Yes'),
807(121, 5, 3, 'Yes'),
808(122, 6, 3, 'sample'),
809(123, 12, 3, 'samplesamplesamplesamplesamplesample'),
810(124, 11, 3, 'samplesamplesamplesample'),
811(125, 10, 3, 'samplesample'),
812(126, 13, 3, 'samplesample'),
813(127, 14, 3, 'samplesample'),
814(128, 1, 1, 'sample'),
815(129, 2, 1, '5'),
816(130, 3, 1, 'Male'),
817(131, 4, 1, 'Not very well'),
818(132, 5, 1, 'No'),
819(133, 6, 1, ''),
820(134, 12, 1, ''),
821(135, 11, 1, 'samplesample'),
822(136, 10, 1, ''),
823(137, 13, 1, ''),
824(138, 14, 1, ''),
825(139, 1, 2, 'anothersample'),
826(140, 2, 2, '9'),
827(141, 3, 2, 'Male'),
828(142, 4, 2, 'Not very well'),
829(143, 5, 2, 'No'),
830(144, 6, 2, 'anothersample'),
831(145, 12, 2, 'anothersampleanothersampleanothersample'),
832(146, 11, 2, 'anothersampleanothersampleanothersample'),
833(147, 10, 2, ''),
834(148, 13, 2, 'anothersample'),
835(149, 14, 2, ''),
836(320, 3, 47, 'Male'),
837(319, 2, 47, '9'),
838(318, 1, 47, 'anothersample'),
839(316, 5, 46, 'Yes'),
840(317, 11, 46, 'test'),
841(315, 4, 46, 'Not very well'),
842(314, 3, 46, 'Female'),
843(312, 1, 46, 'sarah'),
844(313, 2, 46, '4'),
845(311, 14, 45, 'samplesample'),
846(310, 13, 45, 'samplesample'),
847(309, 10, 45, 'samplesample'),
848(308, 11, 45, 'samplesamplesamplesample'),
849(307, 12, 45, 'samplesamplesamplesamplesamplesample'),
850(306, 6, 45, 'sample'),
851(305, 5, 45, 'Yes'),
852(304, 4, 45, 'Yes'),
853(303, 3, 45, 'Male'),
854(302, 2, 45, '8'),
855(301, 1, 45, 'Tom'),
856(300, 14, 44, '---'),
857(299, 13, 44, '---'),
858(298, 10, 44, '---'),
859(297, 11, 44, '---'),
860(296, 12, 44, '---'),
861(295, 6, 44, 'none'),
862(294, 5, 44, 'No'),
863(293, 4, 44, 'No'),
864(292, 3, 44, 'Female'),
865(291, 2, 44, '4'),
866(290, 1, 44, 'princy'),
867(288, 13, 43, 'test'),
868(289, 14, 43, 'test'),
869(286, 11, 43, 'test'),
870(287, 10, 43, 'test'),
871(284, 6, 43, 'none'),
872(285, 12, 43, 'test'),
873(283, 5, 43, 'No'),
874(282, 4, 43, 'No'),
875(281, 3, 43, 'Female'),
876(280, 2, 43, '4'),
877(279, 1, 43, 'valeria johns'),
878(278, 14, 42, 'no'),
879(277, 13, 42, 'yes, she has mild fever'),
880(276, 10, 42, 'pencils, copies, books'),
881(275, 11, 42, 'ASL needed.\nMaths,science and english for 3rd grade.'),
882(274, 12, 42, 'Primary ed'),
883(273, 6, 42, 'Tania Joseph'),
884(272, 5, 42, 'Yes'),
885(271, 4, 42, 'No'),
886(270, 3, 42, 'Female'),
887(269, 2, 42, '7'),
888(268, 1, 42, 'Mary'),
889(321, 4, 47, 'Not very well'),
890(322, 5, 47, 'No'),
891(323, 6, 47, 'anothersample'),
892(324, 12, 47, 'anothersampleanothersampleanothersample'),
893(325, 11, 47, 'anothersampleanothersampleanothersample'),
894(326, 13, 47, 'anothersample'),
895(327, 1, 48, 'sample'),
896(328, 2, 48, '5'),
897(329, 3, 48, 'Male'),
898(330, 4, 48, 'Not very well'),
899(331, 5, 48, 'No'),
900(332, 11, 48, 'samplesample');
901
902-- --------------------------------------------------------
903
904--
905-- Table structure for table `geometry`
906--
907
908CREATE TABLE IF NOT EXISTS `geometry` (
909 `id` int(11) unsigned NOT NULL,
910 `incident_id` bigint(20) unsigned NOT NULL,
911 `geometry` geometry NOT NULL,
912 `geometry_label` varchar(150) DEFAULT NULL,
913 `geometry_comment` varchar(255) DEFAULT NULL,
914 `geometry_color` varchar(20) DEFAULT NULL,
915 `geometry_strokewidth` varchar(5) DEFAULT NULL
916) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stores map geometries i.e polygons, lines etc';
917
918-- --------------------------------------------------------
919
920--
921-- Table structure for table `incident`
922--
923
924CREATE TABLE IF NOT EXISTS `incident` (
925 `id` bigint(20) unsigned NOT NULL,
926 `location_id` bigint(20) unsigned NOT NULL,
927 `form_id` int(11) NOT NULL DEFAULT '1',
928 `locale` varchar(10) NOT NULL DEFAULT 'en_US',
929 `user_id` int(11) unsigned DEFAULT NULL,
930 `incident_title` varchar(255) DEFAULT NULL,
931 `incident_description` longtext,
932 `incident_date` datetime DEFAULT NULL,
933 `incident_mode` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1 - WEB, 2 - SMS, 3 - EMAIL, 4 - TWITTER',
934 `incident_active` tinyint(4) NOT NULL DEFAULT '0',
935 `incident_verified` tinyint(4) NOT NULL DEFAULT '0',
936 `incident_dateadd` datetime DEFAULT NULL,
937 `incident_dateadd_gmt` datetime DEFAULT NULL,
938 `incident_datemodify` datetime DEFAULT NULL,
939 `incident_alert_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0 - Not Tagged for Sending, 1 - Tagged for Sending, 2 - Alerts Have Been Sent',
940 `incident_zoom` tinyint(4) DEFAULT NULL
941) ENGINE=MyISAM AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COMMENT='Stores reports submitted';
942
943--
944-- Dumping data for table `incident`
945--
946
947INSERT INTO `incident` (`id`, `location_id`, `form_id`, `locale`, `user_id`, `incident_title`, `incident_description`, `incident_date`, `incident_mode`, `incident_active`, `incident_verified`, `incident_dateadd`, `incident_dateadd_gmt`, `incident_datemodify`, `incident_alert_status`, `incident_zoom`) VALUES
948(1, 1, 1, 'en_US', 1, 'Hello Ushahidi!', NULL, '2012-04-04 12:54:00', 1, 1, 1, NULL, NULL, '2015-06-05 23:32:50', 1, 6),
949(47, 47, 1, 'en_US', 0, 'milton', '', '2015-06-05 17:18:00', 1, 1, 1, '2015-06-05 17:19:29', NULL, NULL, 0, NULL),
950(2, 2, 1, 'en_US', 1, 'test', NULL, '2015-06-05 17:18:00', 1, 1, 1, '2015-06-05 17:19:29', NULL, '2015-06-05 23:31:08', 1, 7),
951(3, 3, 1, 'en_US', 0, 'Tom', NULL, '2015-05-02 01:06:00', 1, 1, 1, '2015-06-05 20:34:54', NULL, '2015-06-05 23:29:44', 1, 6),
952(4, 4, 1, 'en_US', 0, 'Sarah', NULL, '2015-03-03 10:10:00', 1, 1, 1, '2015-06-05 20:34:54', NULL, '2015-06-05 23:28:43', 1, 6),
953(44, 44, 1, 'en_US', 0, 'Paula', '', '2015-05-02 01:06:00', 1, 1, 1, '2015-06-05 23:06:48', NULL, NULL, 0, NULL),
954(23, 23, 1, 'en_US', 0, 'Valeria', '', '2015-05-02 01:06:00', 1, 1, 1, '2015-06-05 23:10:23', NULL, NULL, 0, NULL),
955(20, 20, 1, 'en_US', 0, 'Princy', '', '2015-05-02 01:06:00', 1, 1, 1, '2015-06-05 23:06:48', NULL, NULL, 0, NULL),
956(46, 46, 1, 'en_US', 0, 'Samaira', '', '2015-03-03 10:10:00', 1, 1, 1, '2015-06-05 20:34:54', NULL, NULL, 1, NULL),
957(29, 29, 1, 'en_US', 1, 'Mary Jones Diaz', NULL, '2015-06-05 23:24:00', 1, 1, 1, '2015-06-05 23:27:03', NULL, NULL, 1, 6),
958(45, 45, 1, 'en_US', 0, 'Todd', '', '2015-05-02 01:06:00', 1, 1, 1, '2015-06-05 20:34:54', NULL, NULL, 0, NULL),
959(43, 43, 1, 'en_US', 0, 'Vannessa', '', '2015-05-02 01:06:00', 1, 1, 1, '2015-06-05 23:10:23', NULL, NULL, 0, NULL),
960(42, 42, 1, 'en_US', 0, 'Macy', '', '2015-06-05 23:24:00', 1, 1, 1, '2015-06-05 23:27:03', NULL, NULL, 0, NULL),
961(48, 48, 1, 'en_US', 0, 'ruth', '', '2012-04-04 12:54:00', 1, 1, 1, '2015-06-06 08:54:33', NULL, NULL, 0, NULL);
962
963-- --------------------------------------------------------
964
965--
966-- Table structure for table `incident_category`
967--
968
969CREATE TABLE IF NOT EXISTS `incident_category` (
970 `id` int(11) NOT NULL,
971 `incident_id` bigint(20) unsigned NOT NULL DEFAULT '0',
972 `category_id` int(11) unsigned NOT NULL DEFAULT '0'
973) ENGINE=MyISAM AUTO_INCREMENT=82 DEFAULT CHARSET=utf8 COMMENT='Stores submitted reports categories';
974
975--
976-- Dumping data for table `incident_category`
977--
978
979INSERT INTO `incident_category` (`id`, `incident_id`, `category_id`) VALUES
980(41, 1, 1),
981(39, 2, 3),
982(37, 3, 3),
983(30, 29, 1),
984(33, 29, 6),
985(23, 23, 3),
986(31, 29, 2),
987(21, 20, 3),
988(32, 29, 3),
989(22, 23, 1),
990(34, 29, 4),
991(35, 4, 1),
992(36, 4, 6),
993(40, 2, 6),
994(80, 47, 6),
995(79, 47, 3),
996(78, 46, 6),
997(77, 46, 1),
998(76, 45, 3),
999(75, 44, 3),
1000(74, 43, 3),
1001(73, 43, 1),
1002(72, 42, 4),
1003(71, 42, 6),
1004(70, 42, 3),
1005(69, 42, 2),
1006(68, 42, 1),
1007(81, 48, 1);
1008
1009-- --------------------------------------------------------
1010
1011--
1012-- Table structure for table `incident_lang`
1013--
1014
1015CREATE TABLE IF NOT EXISTS `incident_lang` (
1016 `id` bigint(20) unsigned NOT NULL,
1017 `incident_id` bigint(20) unsigned NOT NULL,
1018 `locale` varchar(10) DEFAULT NULL,
1019 `incident_title` varchar(255) DEFAULT NULL,
1020 `incident_description` longtext
1021) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Holds translations for report titles and descriptions';
1022
1023-- --------------------------------------------------------
1024
1025--
1026-- Table structure for table `incident_person`
1027--
1028
1029CREATE TABLE IF NOT EXISTS `incident_person` (
1030 `id` bigint(20) unsigned NOT NULL,
1031 `incident_id` bigint(20) unsigned DEFAULT NULL,
1032 `person_first` varchar(200) DEFAULT NULL,
1033 `person_last` varchar(200) DEFAULT NULL,
1034 `person_email` varchar(120) DEFAULT NULL,
1035 `person_phone` varchar(60) DEFAULT NULL,
1036 `person_ip` varchar(50) DEFAULT NULL,
1037 `person_date` datetime DEFAULT NULL
1038) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 COMMENT='Holds information provided by people who submit reports';
1039
1040--
1041-- Dumping data for table `incident_person`
1042--
1043
1044INSERT INTO `incident_person` (`id`, `incident_id`, `person_first`, `person_last`, `person_email`, `person_phone`, `person_ip`, `person_date`) VALUES
1045(14, 2, '', '', '', NULL, NULL, '2015-06-05 23:31:09'),
1046(5, 20, '---', '---', 'divya@ushaidi.com', NULL, NULL, '2015-06-05 23:06:53'),
1047(6, 23, 'test', '---', 'divya@ushaidi.com', NULL, NULL, '2015-06-05 23:10:26'),
1048(10, 29, 'dana', 'scott', 'dana@scott.com', NULL, NULL, '2015-06-05 23:27:03'),
1049(11, 4, '', '', '', NULL, NULL, '2015-06-05 23:28:43'),
1050(12, 3, 'samplesample', '', '', NULL, NULL, '2015-06-05 23:29:44'),
1051(15, 1, '', '', '', NULL, NULL, '2015-06-05 23:32:50'),
1052(27, 45, 'samplesample', NULL, NULL, NULL, NULL, '2015-06-05 20:34:54'),
1053(26, 44, '---', '---', 'divya@ushaidi.com', NULL, NULL, '2015-06-05 23:06:48'),
1054(25, 43, 'test', 'test', 'divya@ushaidi.com', NULL, NULL, '2015-06-05 23:10:23'),
1055(24, 42, 'dana', 'dana', 'dana@scott.com', NULL, NULL, '2015-06-05 23:27:03');
1056
1057-- --------------------------------------------------------
1058
1059--
1060-- Table structure for table `layer`
1061--
1062
1063CREATE TABLE IF NOT EXISTS `layer` (
1064 `id` int(11) NOT NULL,
1065 `layer_name` varchar(255) DEFAULT NULL,
1066 `layer_url` varchar(255) DEFAULT NULL,
1067 `layer_file` varchar(100) DEFAULT NULL,
1068 `layer_color` varchar(20) DEFAULT NULL,
1069 `layer_visible` tinyint(4) NOT NULL DEFAULT '1'
1070) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Holds static layer information';
1071
1072-- --------------------------------------------------------
1073
1074--
1075-- Table structure for table `level`
1076--
1077
1078CREATE TABLE IF NOT EXISTS `level` (
1079 `id` int(11) unsigned NOT NULL,
1080 `level_title` varchar(200) DEFAULT NULL,
1081 `level_description` varchar(200) DEFAULT NULL,
1082 `level_weight` tinyint(4) NOT NULL
1083) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='Stores level of trust assigned to reporters of the platform';
1084
1085--
1086-- Dumping data for table `level`
1087--
1088
1089INSERT INTO `level` (`id`, `level_title`, `level_description`, `level_weight`) VALUES
1090(1, 'SPAM + Delete', 'SPAM + Delete', -2),
1091(2, 'SPAM', 'SPAM', -1),
1092(3, 'Untrusted', 'Untrusted', 0),
1093(4, 'Trusted', 'Trusted', 1),
1094(5, 'Trusted + Verify', 'Trusted + Verify', 2);
1095
1096-- --------------------------------------------------------
1097
1098--
1099-- Table structure for table `location`
1100--
1101
1102CREATE TABLE IF NOT EXISTS `location` (
1103 `id` bigint(20) unsigned NOT NULL,
1104 `location_name` varchar(255) DEFAULT NULL,
1105 `country_id` int(11) NOT NULL DEFAULT '0',
1106 `latitude` double NOT NULL DEFAULT '0',
1107 `longitude` double NOT NULL DEFAULT '0',
1108 `location_visible` tinyint(4) NOT NULL DEFAULT '1',
1109 `location_date` datetime DEFAULT NULL
1110) ENGINE=MyISAM AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COMMENT='Stores location information';
1111
1112--
1113-- Dumping data for table `location`
1114--
1115
1116INSERT INTO `location` (`id`, `location_name`, `country_id`, `latitude`, `longitude`, `location_visible`, `location_date`) VALUES
1117(1, 'Guyana', 94, 2.912633, -58.487881, 1, '2015-06-05 23:32:50'),
1118(2, 'anothersample', 94, -1.2873, 36.821451, 1, '2015-06-05 23:31:08'),
1119(3, 'ABC, Guyana', 94, 7.287, -59.821, 1, '2015-06-05 23:29:44'),
1120(4, 'ABCABC, Guyana', 94, 2.55, -59.216667, 1, '2015-06-05 23:28:43'),
1121(47, 'anothersample', 0, -1.2873, 36.821451, 1, '2015-06-06 08:54:33'),
1122(29, 'ds lane', 94, 4.860416, -58.93018, 1, '2015-06-05 23:27:03'),
1123(23, 'ABC, Guyana', 75, 7.287, -59.821, 1, '2015-06-05 23:10:23'),
1124(20, 'ABC, Guyana', 75, 7.287, -59.821, 1, '2015-06-05 23:06:48'),
1125(46, 'ABCABC, Guyana', 0, 2.55, -59.216667, 1, '2015-06-06 08:54:33'),
1126(45, 'ABC, Guyana', 75, 7.287, -59.821, 1, '2015-06-06 08:54:33'),
1127(44, 'ABC, Guyana', 75, 7.287, -59.821, 1, '2015-06-06 08:54:33'),
1128(43, 'ABC, Guyana', 75, 7.287, -59.821, 1, '2015-06-06 08:54:33'),
1129(42, 'ds lane', 231, 4.860416, -58.93018, 1, '2015-06-06 08:54:33'),
1130(48, 'Guyana', 94, 2.912633, -58.487881, 1, '2015-06-06 08:54:33');
1131
1132-- --------------------------------------------------------
1133
1134--
1135-- Table structure for table `maintenance`
1136--
1137
1138CREATE TABLE IF NOT EXISTS `maintenance` (
1139 `allowed_ip` varchar(15) NOT NULL
1140) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Puts a site in maintenance mode if data exists in this table';
1141
1142-- --------------------------------------------------------
1143
1144--
1145-- Table structure for table `media`
1146--
1147
1148CREATE TABLE IF NOT EXISTS `media` (
1149 `id` bigint(20) unsigned NOT NULL,
1150 `location_id` bigint(20) unsigned DEFAULT NULL,
1151 `incident_id` bigint(20) unsigned DEFAULT NULL,
1152 `message_id` bigint(20) unsigned DEFAULT NULL,
1153 `badge_id` int(11) DEFAULT NULL,
1154 `media_type` tinyint(4) DEFAULT NULL COMMENT '1 - IMAGES, 2 - VIDEO, 3 - AUDIO, 4 - NEWS, 5 - PODCAST',
1155 `media_title` varchar(255) DEFAULT NULL,
1156 `media_description` longtext,
1157 `media_link` varchar(255) DEFAULT NULL,
1158 `media_medium` varchar(255) DEFAULT NULL,
1159 `media_thumb` varchar(255) DEFAULT NULL,
1160 `media_date` datetime DEFAULT NULL,
1161 `media_active` tinyint(4) NOT NULL DEFAULT '1'
1162) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stores any media submitted along with a report';
1163
1164-- --------------------------------------------------------
1165
1166--
1167-- Table structure for table `message`
1168--
1169
1170CREATE TABLE IF NOT EXISTS `message` (
1171 `id` bigint(20) unsigned NOT NULL,
1172 `parent_id` bigint(20) DEFAULT '0',
1173 `incident_id` bigint(20) unsigned DEFAULT '0',
1174 `user_id` int(11) unsigned DEFAULT '0',
1175 `reporter_id` bigint(20) unsigned DEFAULT NULL,
1176 `service_messageid` varchar(100) DEFAULT NULL,
1177 `message_from` varchar(100) DEFAULT NULL,
1178 `message_to` varchar(100) DEFAULT NULL,
1179 `message` text,
1180 `message_detail` text,
1181 `message_type` tinyint(4) DEFAULT '1' COMMENT '1 - INBOX, 2 - OUTBOX (From Admin), 3 - DELETED',
1182 `message_date` datetime DEFAULT NULL,
1183 `message_level` tinyint(4) DEFAULT '0' COMMENT '0 - UNREAD, 1 - READ, 99 - SPAM',
1184 `latitude` double DEFAULT NULL,
1185 `longitude` double DEFAULT NULL
1186) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stores tweets, emails and SMS messages';
1187
1188-- --------------------------------------------------------
1189
1190--
1191-- Table structure for table `openid`
1192--
1193
1194CREATE TABLE IF NOT EXISTS `openid` (
1195 `id` int(11) NOT NULL,
1196 `user_id` int(11) unsigned NOT NULL,
1197 `openid` varchar(255) NOT NULL,
1198 `openid_email` varchar(127) NOT NULL,
1199 `openid_server` varchar(255) NOT NULL,
1200 `openid_date` datetime NOT NULL
1201) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stores users’ openid information';
1202
1203-- --------------------------------------------------------
1204
1205--
1206-- Table structure for table `opportunities`
1207--
1208
1209CREATE TABLE IF NOT EXISTS `opportunities` (
1210 `id` int(11) NOT NULL,
1211 `resource_available` varchar(75) NOT NULL,
1212 `pcv_name` varchar(75) NOT NULL,
1213 `available_from` datetime DEFAULT NULL,
1214 `available_until` datetime DEFAULT NULL,
1215 `contact` varchar(75) NOT NULL,
1216 `add_info` text
1217) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stores resources available posted by user';
1218
1219-- --------------------------------------------------------
1220
1221--
1222-- Table structure for table `page`
1223--
1224
1225CREATE TABLE IF NOT EXISTS `page` (
1226 `id` int(11) NOT NULL,
1227 `page_title` varchar(255) NOT NULL,
1228 `page_description` longtext,
1229 `page_tab` varchar(100) NOT NULL,
1230 `page_active` tinyint(4) NOT NULL DEFAULT '0'
1231) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='Stores user created pages';
1232
1233--
1234-- Dumping data for table `page`
1235--
1236
1237INSERT INTO `page` (`id`, `page_title`, `page_description`, `page_tab`, `page_active`) VALUES
1238(2, 'Resources for PCVs', '<h1></h1><ul><li><span style="color:rgb(131,140,149);font-family:''opensans-regular'', sans-serif;font-size:15px;line-height:18px;text-align:justify;background-color:rgb(255,255,255);">A simplistic guide to sign language to aid the PCVs in communicating with the students</span><br /></li><li><span style="color:rgb(131,140,149);font-family:''opensans-regular'', sans-serif;font-size:15px;line-height:18px;text-align:justify;background-color:rgb(255,255,255);">A prescribed syllabus and guidelines given by Peace Corps for the PCVs</span><br /></li></ul>', 'Resources', 1);
1239
1240-- --------------------------------------------------------
1241
1242--
1243-- Table structure for table `permissions`
1244--
1245
1246CREATE TABLE IF NOT EXISTS `permissions` (
1247 `id` int(11) NOT NULL,
1248 `name` varchar(32) NOT NULL
1249) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=latin1 COMMENT='Stores permissions used for access control';
1250
1251--
1252-- Dumping data for table `permissions`
1253--
1254
1255INSERT INTO `permissions` (`id`, `name`) VALUES
1256(1, 'reports_view'),
1257(2, 'reports_edit'),
1258(4, 'reports_comments'),
1259(5, 'reports_download'),
1260(6, 'reports_upload'),
1261(7, 'messages'),
1262(8, 'messages_reporters'),
1263(9, 'stats'),
1264(10, 'settings'),
1265(11, 'manage'),
1266(12, 'users'),
1267(13, 'manage_roles'),
1268(16, 'reports_verify'),
1269(17, 'reports_approve'),
1270(18, 'admin_ui'),
1271(19, 'member_ui'),
1272(20, 'delete_all_reports');
1273
1274-- --------------------------------------------------------
1275
1276--
1277-- Table structure for table `permissions_roles`
1278--
1279
1280CREATE TABLE IF NOT EXISTS `permissions_roles` (
1281 `role_id` int(11) NOT NULL,
1282 `permission_id` int(11) NOT NULL
1283) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Stores permissions assigned to roles';
1284
1285--
1286-- Dumping data for table `permissions_roles`
1287--
1288
1289INSERT INTO `permissions_roles` (`role_id`, `permission_id`) VALUES
1290(1, 14),
1291(2, 1),
1292(2, 2),
1293(2, 4),
1294(2, 5),
1295(2, 6),
1296(2, 7),
1297(2, 8),
1298(2, 9),
1299(2, 10),
1300(2, 11),
1301(2, 12),
1302(2, 14),
1303(2, 15),
1304(2, 16),
1305(2, 17),
1306(2, 18),
1307(3, 1),
1308(3, 2),
1309(3, 4),
1310(3, 5),
1311(3, 6),
1312(3, 7),
1313(3, 8),
1314(3, 9),
1315(3, 10),
1316(3, 11),
1317(3, 12),
1318(3, 13),
1319(3, 14),
1320(3, 15),
1321(3, 16),
1322(3, 17),
1323(3, 18),
1324(3, 20),
1325(4, 19);
1326
1327-- --------------------------------------------------------
1328
1329--
1330-- Table structure for table `plugin`
1331--
1332
1333CREATE TABLE IF NOT EXISTS `plugin` (
1334 `id` int(11) unsigned NOT NULL,
1335 `plugin_name` varchar(100) NOT NULL,
1336 `plugin_url` varchar(250) DEFAULT NULL,
1337 `plugin_description` text,
1338 `plugin_priority` tinyint(4) DEFAULT '0',
1339 `plugin_active` tinyint(4) DEFAULT '0',
1340 `plugin_installed` tinyint(4) DEFAULT '0'
1341) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='Holds a list of all plugins installed on a deployment';
1342
1343--
1344-- Dumping data for table `plugin`
1345--
1346
1347INSERT INTO `plugin` (`id`, `plugin_name`, `plugin_url`, `plugin_description`, `plugin_priority`, `plugin_active`, `plugin_installed`) VALUES
1348(1, 'clickatell', NULL, NULL, 0, 0, 0),
1349(2, 'downloadreports', NULL, NULL, 0, 1, 1),
1350(3, 'frontlinesms', NULL, NULL, 0, 0, 0),
1351(4, 'sharing', NULL, NULL, 0, 0, 0),
1352(5, 'smssync', NULL, NULL, 0, 0, 0);
1353
1354-- --------------------------------------------------------
1355
1356--
1357-- Table structure for table `private_message`
1358--
1359
1360CREATE TABLE IF NOT EXISTS `private_message` (
1361 `id` int(11) NOT NULL,
1362 `parent_id` int(11) NOT NULL DEFAULT '0',
1363 `user_id` int(11) unsigned NOT NULL,
1364 `from_user_id` int(11) DEFAULT '0',
1365 `private_subject` varchar(255) NOT NULL,
1366 `private_message` text NOT NULL,
1367 `private_message_date` datetime NOT NULL,
1368 `private_message_new` tinyint(4) NOT NULL DEFAULT '1'
1369) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stores private messages sent between Members';
1370
1371-- --------------------------------------------------------
1372
1373--
1374-- Table structure for table `rating`
1375--
1376
1377CREATE TABLE IF NOT EXISTS `rating` (
1378 `id` bigint(20) unsigned NOT NULL,
1379 `user_id` int(11) unsigned DEFAULT '0',
1380 `incident_id` bigint(20) unsigned DEFAULT NULL,
1381 `comment_id` bigint(20) unsigned DEFAULT NULL,
1382 `rating` tinyint(4) DEFAULT '0',
1383 `rating_ip` varchar(100) DEFAULT NULL,
1384 `rating_date` datetime DEFAULT NULL
1385) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='Stores credibility ratings for reports and comments';
1386
1387--
1388-- Dumping data for table `rating`
1389--
1390
1391INSERT INTO `rating` (`id`, `user_id`, `incident_id`, `comment_id`, `rating`, `rating_ip`, `rating_date`) VALUES
1392(1, 0, 29, NULL, 1, '127.0.0.1', '2015-08-22 02:58:44'),
1393(2, 3, 29, NULL, 1, '127.0.0.1', '2015-08-24 07:22:31');
1394
1395-- --------------------------------------------------------
1396
1397--
1398-- Table structure for table `reporter`
1399--
1400
1401CREATE TABLE IF NOT EXISTS `reporter` (
1402 `id` bigint(20) unsigned NOT NULL,
1403 `location_id` bigint(20) unsigned DEFAULT NULL,
1404 `user_id` int(11) unsigned DEFAULT NULL,
1405 `service_id` int(10) unsigned DEFAULT NULL,
1406 `level_id` int(11) unsigned DEFAULT NULL,
1407 `service_account` varchar(255) DEFAULT NULL,
1408 `reporter_first` varchar(200) DEFAULT NULL,
1409 `reporter_last` varchar(200) DEFAULT NULL,
1410 `reporter_email` varchar(120) DEFAULT NULL,
1411 `reporter_phone` varchar(60) DEFAULT NULL,
1412 `reporter_ip` varchar(50) DEFAULT NULL,
1413 `reporter_date` datetime DEFAULT NULL
1414) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Information on report submitters via email, twitter and sms';
1415
1416-- --------------------------------------------------------
1417
1418--
1419-- Table structure for table `roles`
1420--
1421
1422CREATE TABLE IF NOT EXISTS `roles` (
1423 `id` int(11) unsigned NOT NULL,
1424 `name` varchar(32) NOT NULL,
1425 `description` varchar(255) NOT NULL,
1426 `access_level` tinyint(4) NOT NULL DEFAULT '0'
1427) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='Defines user access levels and privileges on a deployment';
1428
1429--
1430-- Dumping data for table `roles`
1431--
1432
1433INSERT INTO `roles` (`id`, `name`, `description`, `access_level`) VALUES
1434(1, 'login', 'Login privileges, granted after account confirmation', 0),
1435(2, 'admin', 'Administrative user, has access to almost everything.', 90),
1436(3, 'superadmin', 'Super administrative user, has access to everything.', 100),
1437(4, 'member', 'Regular user with access only to the member area', 10);
1438
1439-- --------------------------------------------------------
1440
1441--
1442-- Table structure for table `roles_users`
1443--
1444
1445CREATE TABLE IF NOT EXISTS `roles_users` (
1446 `user_id` int(11) unsigned NOT NULL,
1447 `role_id` int(11) unsigned NOT NULL
1448) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stores roles assigned to users registered on a deployment';
1449
1450--
1451-- Dumping data for table `roles_users`
1452--
1453
1454INSERT INTO `roles_users` (`user_id`, `role_id`) VALUES
1455(1, 1),
1456(1, 2),
1457(1, 3),
1458(2, 1),
1459(2, 4),
1460(3, 1),
1461(3, 4);
1462
1463-- --------------------------------------------------------
1464
1465--
1466-- Table structure for table `scheduler`
1467--
1468
1469CREATE TABLE IF NOT EXISTS `scheduler` (
1470 `id` int(10) unsigned NOT NULL,
1471 `scheduler_name` varchar(100) NOT NULL,
1472 `scheduler_last` int(10) unsigned NOT NULL DEFAULT '0',
1473 `scheduler_weekday` smallint(6) NOT NULL DEFAULT '-1',
1474 `scheduler_day` smallint(6) NOT NULL DEFAULT '-1',
1475 `scheduler_hour` smallint(6) NOT NULL DEFAULT '-1',
1476 `scheduler_minute` smallint(6) NOT NULL,
1477 `scheduler_controller` varchar(100) NOT NULL,
1478 `scheduler_active` tinyint(4) NOT NULL DEFAULT '1'
1479) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='Stores schedules for cron jobs';
1480
1481--
1482-- Dumping data for table `scheduler`
1483--
1484
1485INSERT INTO `scheduler` (`id`, `scheduler_name`, `scheduler_last`, `scheduler_weekday`, `scheduler_day`, `scheduler_hour`, `scheduler_minute`, `scheduler_controller`, `scheduler_active`) VALUES
1486(1, 'Feeds', 1442242939, -1, -1, -1, 0, 's_feeds', 1),
1487(2, 'Alerts', 1433524755, -1, -1, -1, -1, 's_alerts', 1),
1488(3, 'Email', 1433524102, -1, -1, -1, 0, 's_email', 1),
1489(4, 'Twitter', 1433524102, -1, -1, -1, 0, 's_twitter', 1),
1490(5, 'Cleanup', 1433524102, -1, -1, -1, 0, 's_cleanup', 1);
1491
1492-- --------------------------------------------------------
1493
1494--
1495-- Table structure for table `scheduler_log`
1496--
1497
1498CREATE TABLE IF NOT EXISTS `scheduler_log` (
1499 `id` bigint(20) unsigned NOT NULL,
1500 `scheduler_id` int(10) unsigned NOT NULL,
1501 `scheduler_status` varchar(20) DEFAULT NULL,
1502 `scheduler_date` int(10) unsigned NOT NULL
1503) ENGINE=MyISAM AUTO_INCREMENT=99 DEFAULT CHARSET=utf8 COMMENT='Stores a log of scheduler actions';
1504
1505--
1506-- Dumping data for table `scheduler_log`
1507--
1508
1509INSERT INTO `scheduler_log` (`id`, `scheduler_id`, `scheduler_status`, `scheduler_date`) VALUES
1510(1, 1, '200', 1433523514),
1511(2, 2, '200', 1433523515),
1512(3, 3, '200', 1433523515),
1513(4, 4, '200', 1433523515),
1514(5, 5, '200', 1433523515),
1515(6, 1, '200', 1433524102),
1516(7, 2, '200', 1433524102),
1517(8, 3, '200', 1433524102),
1518(9, 4, '200', 1433524102),
1519(10, 5, '200', 1433524102),
1520(11, 2, '200', 1433524324),
1521(12, 2, '200', 1433524698),
1522(13, 2, '200', 1433524755),
1523(14, 1, '200', 1433527375),
1524(15, 1, '200', 1433532658),
1525(16, 1, '200', 1433534405),
1526(17, 1, '200', 1433542612),
1527(18, 1, '200', 1433545613),
1528(19, 1, '200', 1433580847),
1529(20, 1, '200', 1433584821),
1530(21, 1, '200', 1433788382),
1531(22, 1, '200', 1433977238),
1532(23, 1, '200', 1434062187),
1533(24, 1, '200', 1434064206),
1534(25, 1, '200', 1434067306),
1535(26, 1, '200', 1434354919),
1536(27, 1, '200', 1434355216),
1537(28, 1, '200', 1434362048),
1538(29, 1, '200', 1434362879),
1539(30, 1, '200', 1434366603),
1540(31, 1, '200', 1434380823),
1541(32, 1, '200', 1434398247),
1542(33, 1, '200', 1434832060),
1543(34, 1, '200', 1434868636),
1544(35, 1, '200', 1434871024),
1545(36, 1, '200', 1434882175),
1546(37, 1, '200', 1434891893),
1547(38, 1, '200', 1434904425),
1548(39, 1, '200', 1434949249),
1549(40, 1, '200', 1434974078),
1550(41, 1, '200', 1434976343),
1551(42, 1, '200', 1434984546),
1552(43, 1, '200', 1435061401),
1553(44, 1, '200', 1435116098),
1554(45, 1, '200', 1435118712),
1555(46, 1, '200', 1435311595),
1556(47, 1, '200', 1435582902),
1557(48, 1, '200', 1436495526),
1558(49, 1, '200', 1436497394),
1559(50, 1, '200', 1436505428),
1560(51, 1, '200', 1436609307),
1561(52, 1, '200', 1438175407),
1562(53, 1, '200', 1438276832),
1563(54, 1, '200', 1439465915),
1564(55, 1, '200', 1439467979),
1565(56, 1, '200', 1439706643),
1566(57, 1, '200', 1439709420),
1567(58, 1, '200', 1439719484),
1568(59, 1, '200', 1439725378),
1569(60, 1, '200', 1439784654),
1570(61, 1, '200', 1439790962),
1571(62, 1, '200', 1439792382),
1572(63, 1, '200', 1439809245),
1573(64, 1, '200', 1439891953),
1574(65, 1, '200', 1439968501),
1575(66, 1, '200', 1439972122),
1576(67, 1, '200', 1439977029),
1577(68, 1, '200', 1439983342),
1578(69, 1, '200', 1439986940),
1579(70, 1, '200', 1440146579),
1580(71, 1, '200', 1440147643),
1581(72, 1, '200', 1440159011),
1582(73, 1, '200', 1440162240),
1583(74, 1, '200', 1440211154),
1584(75, 1, '200', 1440212456),
1585(76, 1, '200', 1440222395),
1586(77, 1, '200', 1440223777),
1587(78, 1, '200', 1440398351),
1588(79, 1, '200', 1440400164),
1589(80, 1, '200', 1440416242),
1590(81, 1, '200', 1440418180),
1591(82, 1, '200', 1440580487),
1592(83, 1, '200', 1440583279),
1593(84, 1, '200', 1440589269),
1594(85, 1, '200', 1440590741),
1595(86, 1, '200', 1440595186),
1596(87, 1, '200', 1440678690),
1597(88, 1, '200', 1441623135),
1598(89, 1, '200', 1441626926),
1599(90, 1, '200', 1442133071),
1600(91, 1, '200', 1442212304),
1601(92, 1, '200', 1442214050),
1602(93, 1, '200', 1442222106),
1603(94, 1, '200', 1442225204),
1604(95, 1, '200', 1442229640),
1605(96, 1, '200', 1442232153),
1606(97, 1, '200', 1442242530),
1607(98, 1, '200', 1442242939);
1608
1609-- --------------------------------------------------------
1610
1611--
1612-- Table structure for table `service`
1613--
1614
1615CREATE TABLE IF NOT EXISTS `service` (
1616 `id` int(10) unsigned NOT NULL,
1617 `service_name` varchar(100) DEFAULT NULL,
1618 `service_description` varchar(255) DEFAULT NULL,
1619 `service_url` varchar(255) DEFAULT NULL,
1620 `service_api` varchar(255) DEFAULT NULL
1621) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='Info on input sources i.e SMS, Email, Twitter';
1622
1623--
1624-- Dumping data for table `service`
1625--
1626
1627INSERT INTO `service` (`id`, `service_name`, `service_description`, `service_url`, `service_api`) VALUES
1628(1, 'SMS', 'Text messages from phones', NULL, NULL),
1629(2, 'Email', 'Email messages sent to your deployment', NULL, NULL),
1630(3, 'Twitter', 'Tweets tweets tweets', 'http://twitter.com', NULL);
1631
1632-- --------------------------------------------------------
1633
1634--
1635-- Table structure for table `sessions`
1636--
1637
1638CREATE TABLE IF NOT EXISTS `sessions` (
1639 `session_id` varchar(127) NOT NULL,
1640 `last_activity` int(10) unsigned NOT NULL,
1641 `data` text NOT NULL
1642) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stores session information';
1643
1644--
1645-- Dumping data for table `sessions`
1646--
1647
1648INSERT INTO `sessions` (`session_id`, `last_activity`, `data`) VALUES
1649('ck73g64resd6aeh9bo140riuf2', 1442243128, 'WTrNRdvrEd9MaztFBVFo0nO90BqLX8T18UaOfIaEhj06ZhHsLRi0lSiODSYXV+xzWFOQuiTi1o/uPngCg3mRJbdyxiDgFbVTqDyL95ZwSj1fjgresAbk26h2QYcBllLHmN+9OapOKj192veStvVgisq6O+5n2+9vZDtUeHpBKuL8LbyfxqAn9lKVH5pr9KioAUoLu47HXV1fyHBS2dc5jHjiKAhSbG2rkIczkTUgjvcI6TQoKXYgioiYTBzQEDYVFkzZCtI6ulqp0oXln7j2WzCSaAHE0Y3UBbKIGjwi99bqDi3DkljfGU8y6q9ypqWA3YUtNvhDX+D4YEPbZ/NxMXGSUYiyBCOM4EyMf5yH/QIGHDunMcKAtt5PVr3xOFwKTD4yRkfcoFVKNqTf6otgc5dAjAo2ArbrcnpkL+NufS9FiCAjBjnnbpfOWhtR1RuB5W1kYCbVBG2qxlprNRs7UXg='),
1650('69ifi13dan9qbf5tf5lansjmn5', 1442246283, 'FPoWgwzXEB9lj5sU/vExNDl51KZ787b74UbZFrNWHjYI+aw1/KxGP9HgKif1B0M1xjDfdXdnO3Bua8sDNMdOOpXO78sYHRQfuzfyplMIq8eske1ooKIKATrlXETgTcTg6YHW+XrW911OcFL39cZ6WZhUAGLjrhvBtp+pKbzotIEMLL+2bul5M4bdL/hm9PHhGQK3NH1pnXMvNRnSneMKvrh/bj12jPWWJSuN41lY30uoLmV/+nuK+AaFD8aaTmKG4dxOMTmRiC2PdovP53EvtupyQQxehEZWp8XTJdDwTfRDubtfyRKilKe+PgD+OpVjiPz/RSxmwJmzvHQsJUOYqHnrQmupFflYGvIE0xFxveo6w8pOU1vzR0IPfIlm0u7zIRI9eWDIS2ihuP8WONaZh5WxqEoFii0gqq3bi28p/waBqi1s3FvZt3AtQxrLAflqoQi/aBsO70klV4llW4fxb6Q19rGsOlogK64+vVCNHY4MZ81azzX8PZT5TdXT4JdYrHxSgnRKAUDgGBm8HDC2HXY4DgCJSCvjVuWBaazwUtmbdoYU6MOZB9qo0oNj/5QLe8YC2qZNsAMFMtR4g682LokyB7+zD3Tfky+9JFkROknOxeNIQw+y2b8Kvjd4FAPoVQmmC+mEhtEag7MzBib96rmXYtf7NHbqbOwbb/FGNn7y57CZ/Jd+7uE9b1zIL/f2U5Ncoit3wjvyfiEzAy9nJrIopSXTWkMxM00ivdiU6TilbdWWOuv7icBohPk0QdEYWTexQvAz+nFu7794518sR75FWtiODTC5jjdz4rus8CRQfhDZP9/Z22D5MK1qAQuxfmxdvpXMjJxFCGXCs0p5S3CSs4MDenD1JigW2aKsNLux9NdU6HUSvDy3qrrDqP5MBv5REP0mAv1zB7Djs+Ai8KtwMfh/50sdjSwFGBh1f1wk/1M9PK2f9zxUdqFII6SnEl0/MXLuc/xLzDv5g3SjmYxgC5aYl3T5VOhckq+lW6J7RKxKIX7urO3AKGdRjVoKmMMLeTGIlJgNe/+ol9NeOXrGuVsc+SDGksqnW37fRAJBwaU3dBrpAx835nH88WRNf357ezjsztGFpMuBbiyhNLLBlaLbsIiEjXE/aeOXSPb8k1kb6uABTvwkH806TXG3nfc0MjBgzWGSB/wyiHy9Lx667jKvJEeY6MeWkgMnCg6yO3miOLA/CDnetWe5YkgXTHvcyseqIElFWnwCbxkTKKhodO3RgqYDRS+3ND/lZp/FjVRU5DTiufarkZGgypVWDB9b6Cb3KVa7ehPj6uLcowYhWB2ttpAKcSgVB1T/V4VBAcKIsqlB4hPKEAVlOCVRVw2397w79LDKXrWq61SG8IUoV2QD1Q9UV8w6c3I0gB/R3QctdoRChwyTosWTblELTvn51eeZobo6DFFLuGg1wi/kc/DzMfhpDX0EXucWtlWA2pW++Uw2CL7MJkUU4GwdU5VnCMvaUBm7dCthjxAYw7yElw7YnrRnkIkwzF0SV//XxuXr40A='),
1651('9eascq6mmvieofc579pjrf3oj4', 1442242529, '6mfGsleiN05jNDqOMWks71vfH3BzZt7fSZQFiU8NgGUIezrMlqnYfTRBx4m6AFLlAGzF6f2F47NG7iKI2Jw6LD5mKEoyBaVDApZb9e5ntZttIjpGS185bc4D2wY+m1FYR7xdtUTee1GLeY9y0EU+uFV6H2sfyk6ZG7B+0qDz4lHd/WMYcw2/rpkGwwJ5H4vI/IgGGTA8/5ljw6kkCb5giZdBDVvpM3WCcI65lQ4gNnFGHmggK3ldhEhnzU5pEUUyhpWUy5DozoSkjAeU18+qbCS+sV4sJHudKCIlTgN24wMmXxZdAicpDqHrRJfv1OQgKo1BKfbEZ6TGR+luFMQ/KNGCQ15GqOopt0aiDP/Jro6gS4vI5goCqiaiq19IEyola0w/YoGW2to5j7pNwofnrh9XNEAv91I8P0Yzmsclf2pqUwwmp/HFpyE3PWAAaufbD8UQYCaKpMP6+T7k+lw2IZM='),
1652('f6pq149kfpph1rmb03v37qn4c7', 1442242911, 'a/J9toHuRc2GHdDdVfQdYLrFiUGFfLjRp78AhJtt6ll2kzQQp8FL8udZV2yxCZa3hmVSHt/VZkKqdrUcHLK8hyl45stHolJ2DJAo82yUIoQMaEoSiAV48bubZzM+P6vWmRjrlE/8ypXPLapRvjCsSo8rQUzc99q+4nvxOPZKshZrh7O1yxbfEg7C+OUj1Zg7ZRtSQFO56jNhimL6+95wnXkLh4SgyJuMlwlMyThwhOsvoWVLdHs8csQoI1I+PtwfGbBC+5+E2cvb5D/Y9wZaeweuXM06MpLEaZXnxBZPAOf8nEvW44HKWqT6T/PlQEuXE3SgRmDX8X6Qew+UtDkxpEJkTNcUpz7NDgXF4V1pfA5w8auGnhMwUHL8ja1FZM4UWK/3qMVOO1/rKz/32EV9xZf+Nr8EQa13wTez2Dr4j8NKkc57awAwnuu5KWyaK+tux65UD/3CXc9WvRhX1DR3+PKw55vzy48QRcfLSyNyKjaTuLVcmyrbHXBv7EDNUCSUhnwhD3NKJlqP54wX5KeK1cYp71zrVegZF8Ftnke/ZRaDhEQS8chJH4PKuQ70JwuAYijpO3g+ZknjQWhf2z40K7wD/XNllz7HtwEj+CKflnvi/HfcIFiLj6TQd+uHyHPf547w5Z/C3rs8X5S2muoxubswtTLFmfnqB539wZzE0qvlg3wKME9NsyAehyH0AXijlXUM5z3ECgBzoi9Bl2MHxf7UaW/GWdi7QPsDH1N6yX53fBe1YfhLBH+sBh1TyxoBtdQEf2NW0zFzCW6ZrcsXqE+JYZejaqUzsGl/Y8PthVNnSlJX1cszsYuhgmee9PxeeA/EXctu8+H+BD6+1Tp3Oo/L3olhe18EgW1G2qEW0zXh1riMbb7eDro0q3tgqX7G9ZkZ7sBNleaNgy/G4ydcSASayS09JlnQ9GXSIvkFmUqwi5Xpxp919YOSElOPwCS3fpnMgI1nwl3uKq5J3WGqptUBwapP6V9fejo+aOVVFdpcSA4s5ns5yfkdzy/rUbqvz7CaDBA/sT0lWIAvp3VDle3zpt+vHOlo/siEd6wTUT/ejgB14SU71FAB932aY5udBH3N9CPYSvfCt6LH3iVvJQ3ST7yxH/KKhIV4Zx7ReX9/Vgf7nW58aCq7XcY29Ch4V2Q5mbF7jp8XtE9uNhI3R8ddo4KwC4+li7/huMawWd/dz+ytO1VDy75MwfLmrKAqHVqii5C01v3E77YncmfQFWipw+ESXSbR079C8J+e9lHbsWHNFxVxB8fC2y4wTt/lFNxWwINyIc1pohnasK7tJjmvqA1AJmEeinTHxg0fUg431n6P/hb1n25Z20reU4rBJEkGL1Ap968kQJru975eYT53nAHbJXSCiPZZvsPHknIirbw6kl6M8TwTYkgjlb/ZiSzNqO2Fh76wHFZPJW47iKwvH88KlzHULjP0vMnjvGPyPCmc66D4vdjbHNTRzKepXLIIg7BUQW81b9YU0caT0xn6cHaMe54N/bAtPbsEVIeNK8Wsfdg='),
1653('legu0irptb7rtk03476ckrm726', 1442246330, 'vH9As1zjvdpXRHW2kun/k2yq+rKZHq6ZSkXj0XPpgl201EJwFv78JFlLmfAfOceZCRvHsVMBwXa3FLmz4r5EwUSrDy5l6ocUX5RI8AqFLagTxnSWFREtwmCDbRTL7Esbvr8KAmiOjtTrpZhjB9iAFhURCjZvT5U4oFJZBe3Uo81ogNdsHW3NEl7jnJs1MCR0GsjbIMuwqUWEsLdWsblZ+a0dqS3WKCjw/ICGH++G7l1CmTc+M2xZ8ybIfZVyvBTfHd1aHdHU1t52173V72SOJPESOBy1bAbsfnW9QnPqulRNifUmoT1uamw133j1jf5agFGDAkZovO7el2kVzOSTyQiG2oNraW7kcVK125CphMK9v+2geSdwxQdKoUsC5jh3fEutnp3uXLOyVi8oLSItl8zsMTe70kcLYKPcMRVdAWM9U+Py+JhQ5m8BXPShvVXpdA6/BhYvpZ2mFG+ycifeFl9qfjmg6nfJ9c8jSdoXbgaOijYMeHdPOsFQC8lQ7angW9DIa1dVEagVWry+WQ0Ogkk9GgzqgVQJKwjMiTysnqtM9GkYdqlln1c2Nl5XLa8YD5NmQ+HMEFGOAVzh5jR8kttXXF/5/ubceYeqvM0yYig3LRxwWyiFVStbAJQPdYA7eldZ1r5l7dWWI0b8vi2qxelsSGxZoqPiwPeSyl2jR7yUzVNaZpd4MzmW7hwNPAmjcWg1cQ6XZbYd4vO13kaZbZpcML6F3J3TSw0W+GdjGK79SLmV5UuIUcTrcRcaTM/E3DK2TTSE5x7iG3mYOvebkRSuvKOzWOOnafL776TGbqDIR7BcOg/wV335vRTY7nuXBaSzR6KOfETFlh7A7moQVGD/PivTiOMR+GZDVYYJsDC9ZelDaEx5lpkh++BDZwPoqs4heuYp3FyYNiCCau/0ilNbpKdaNVSSKu5B6IfMhQYJt/DNiZ3P0csOL7Iek58gpnjA7EPYM6zIWzKbKjSh5D5xYtAzSiKNRFWNpBF2Q5vYSyNJAjhTvSGkcshE5aEEmZHJTorWyMqUJBNUhnNWlClJPxk47b36Fs0y95kITnr5wDcjSj9ixXdR/3zjU3ZUD26fE74j2in/Mbb11NVKhC0zr3oNsbwstpIWd4RCHQR6u4i9l4rMmATR3msredYSITBiU3SwzUmn3Jzu2+11bPaf7rDhBbMs0gZA13u8ne7JlIjBjy1PsdP++jTnONEHuK/tntErUwVAhP89zwxR9w5/pQB5wzIPhB16xjyqrGu825zUB1xljKXJbcnAWEPOWtcN5oOaGoRnUoCxcBsbs1ZQsUCf5sQeG2AfZAKmN9NK9LMTw0K+U4juJvYlwXiXMIQWM/iFIBa3gF4Q3Vw6Po4V8T/wX+yxAzzJnJFUVlMWkQnp6DdGowon+v7rg8ZTr6iCQhRiDt7utZo8gH9S1iohM4bEuy36Q0kmkwFNd7T+gfhToxL7N5HO4LYw1dPIk3xq8v1HoeY0E6Y4IVWHdehdkya3u7nvoH1p+/Hog0rEqw7Y74M=');
1654
1655-- --------------------------------------------------------
1656
1657--
1658-- Table structure for table `settings`
1659--
1660
1661CREATE TABLE IF NOT EXISTS `settings` (
1662 `id` int(11) unsigned NOT NULL,
1663 `key` varchar(100) NOT NULL DEFAULT '' COMMENT 'Unique identifier for the configuration parameter',
1664 `value` text COMMENT 'Value for the settings parameter'
1665) ENGINE=MyISAM AUTO_INCREMENT=81 DEFAULT CHARSET=utf8;
1666
1667--
1668-- Dumping data for table `settings`
1669--
1670
1671INSERT INTO `settings` (`id`, `key`, `value`) VALUES
1672(1, 'site_name', 'Guyana Deaf Community'),
1673(2, 'site_tagline', 'Education for all.'),
1674(3, 'site_banner_id', NULL),
1675(4, 'site_email', 'ushahidiguyana@gmail.com'),
1676(5, 'site_key', NULL),
1677(6, 'site_language', 'en_US'),
1678(7, 'site_style', 'default'),
1679(8, 'site_timezone', '0'),
1680(9, 'site_contact_page', '1'),
1681(10, 'site_help_page', '1'),
1682(11, 'site_message', ''),
1683(12, 'site_copyright_statement', ''),
1684(13, 'site_submit_report_message', ''),
1685(14, 'allow_reports', '1'),
1686(15, 'allow_comments', '1'),
1687(16, 'allow_feed', '1'),
1688(17, 'allow_stat_sharing', '1'),
1689(18, 'allow_clustering', '1'),
1690(19, 'cache_pages', '0'),
1691(20, 'cache_pages_lifetime', '1800'),
1692(21, 'private_deployment', '0'),
1693(22, 'default_map', 'google_physical'),
1694(23, 'default_map_all', 'CC0000'),
1695(24, 'default_map_all_icon_id', NULL),
1696(25, 'api_google', ''),
1697(26, 'api_live', 'Apumcka0uPOF2lKLorq8aeo4nuqfVVeNRqJjqOcLMJ9iMCTsnMsNd9_OvpA8gR0i'),
1698(27, 'api_akismet', ''),
1699(28, 'default_country', '94'),
1700(29, 'multi_country', '0'),
1701(30, 'default_city', 'nairobi'),
1702(31, 'default_lat', '4.860416'),
1703(32, 'default_lon', '-58.93018000000001'),
1704(33, 'default_zoom', '6'),
1705(34, 'items_per_page', '5'),
1706(35, 'items_per_page_admin', '20'),
1707(36, 'sms_provider', ''),
1708(37, 'sms_no1', NULL),
1709(38, 'sms_no2', NULL),
1710(39, 'sms_no3', NULL),
1711(40, 'google_analytics', ''),
1712(41, 'twitter_hashtags', NULL),
1713(42, 'blocks', 'news_block|reports_block'),
1714(43, 'blocks_per_row', '2'),
1715(44, 'date_modify', '2015-08-16 07:42:13'),
1716(45, 'stat_id', '69557'),
1717(46, 'stat_key', 'f44a5272a3c4354d8bbb28ea6b6ed0'),
1718(47, 'email_username', 'ushahidiguyana@gmail.com'),
1719(48, 'email_password', 'sys15gsoc'),
1720(49, 'email_port', '993'),
1721(50, 'email_host', 'imap.gmail.com'),
1722(51, 'email_servertype', 'imap'),
1723(52, 'email_ssl', '1'),
1724(53, 'ftp_server', NULL),
1725(54, 'ftp_user_name', NULL),
1726(55, 'alerts_email', 'ushahidiguyana@gmail.com'),
1727(57, 'facebook_appid', NULL),
1728(58, 'facebook_appsecret', NULL),
1729(59, 'db_version', '117'),
1730(60, 'ushahidi_version', '2.7.3'),
1731(61, 'allow_alerts', '1'),
1732(62, 'require_email_confirmation', '0'),
1733(63, 'manually_approve_users', '0'),
1734(64, 'enable_timeline', '1'),
1735(65, 'feed_geolocation_user', ''),
1736(66, 'allow_feed_category', '0'),
1737(67, 'dashboard_redirect', '1'),
1738(68, 'enable_report_notifications', '0'),
1739(69, 'enable_media_filters', '1'),
1740(70, 'enable_chronological_filter', '1'),
1741(71, 'enable_category_filters', '1'),
1742(72, 'enable_category_filters_showhide', '1'),
1743(73, 'show_reporting_options', '1'),
1744(74, 'show_submit_report_tab', '1'),
1745(75, 'enable_filter_search', '0'),
1746(76, 'allow_opportunities', '1'),
1747(77, 'forgot_password_secret', 'hRDzLYhX]u)rnh!`tU%T~j?$*vG;%WhR,nG$9#t95#NuJ%Qeox(Rn62I.&;QwPe&'),
1748(78, 'scheduler_lock', '1442246462'),
1749(79, 'timeline_graph', 'line'),
1750(80, 'timeline_point_label', '0');
1751
1752-- --------------------------------------------------------
1753
1754--
1755-- Table structure for table `user_tokens`
1756--
1757
1758CREATE TABLE IF NOT EXISTS `user_tokens` (
1759 `id` int(11) unsigned NOT NULL,
1760 `user_id` int(11) unsigned NOT NULL,
1761 `user_agent` varchar(40) NOT NULL,
1762 `token` varchar(64) NOT NULL,
1763 `created` int(10) unsigned NOT NULL,
1764 `expires` int(10) unsigned NOT NULL
1765) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='Stores browser tokens assigned to users';
1766
1767--
1768-- Dumping data for table `user_tokens`
1769--
1770
1771INSERT INTO `user_tokens` (`id`, `user_id`, `user_agent`, `token`, `created`, `expires`) VALUES
1772(8, 3, '81695bebd98104d5fbc4db1f011a6b2704476bce', 'TcZyUtUj1eoTTNlG6BpwEGH1ICbtMGSL', 1440398609, 1441608209),
1773(7, 2, '81695bebd98104d5fbc4db1f011a6b2704476bce', 'VAITMBjB23CqWa45AFbC2qmstp8lnSs5', 1440222504, 1441432104),
1774(6, 1, '81695bebd98104d5fbc4db1f011a6b2704476bce', 'xJxCZhY0lgj1z1k6f3yZtuqFX50LneQv', 1439809237, 1441018837);
1775
1776-- --------------------------------------------------------
1777
1778--
1779-- Table structure for table `users`
1780--
1781
1782CREATE TABLE IF NOT EXISTS `users` (
1783 `id` int(11) unsigned NOT NULL,
1784 `riverid` varchar(128) NOT NULL,
1785 `name` varchar(200) DEFAULT NULL,
1786 `email` varchar(127) NOT NULL,
1787 `username` varchar(100) NOT NULL DEFAULT '',
1788 `password` char(50) NOT NULL,
1789 `logins` int(10) unsigned NOT NULL DEFAULT '0',
1790 `last_login` int(10) unsigned DEFAULT NULL,
1791 `notify` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Flag incase admin opts in for email notifications',
1792 `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1793 `color` varchar(6) NOT NULL DEFAULT 'FF0000',
1794 `code` varchar(30) DEFAULT NULL,
1795 `confirmed` tinyint(1) NOT NULL DEFAULT '0',
1796 `public_profile` tinyint(1) NOT NULL DEFAULT '1',
1797 `approved` tinyint(1) NOT NULL DEFAULT '1',
1798 `needinfo` tinyint(1) NOT NULL DEFAULT '0',
1799 `report_notifications` tinyint(4) DEFAULT '0',
1800 `last_reports_view` datetime DEFAULT NULL
1801) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='Stores registered users’ information';
1802
1803--
1804-- Dumping data for table `users`
1805--
1806
1807INSERT INTO `users` (`id`, `riverid`, `name`, `email`, `username`, `password`, `logins`, `last_login`, `notify`, `updated`, `color`, `code`, `confirmed`, `public_profile`, `approved`, `needinfo`, `report_notifications`, `last_reports_view`) VALUES
1808(1, '', 'Administrator', 'divyaupadhyay42@gmail.com', 'admin', '7f1ef9c4347d08e5b78e0e13374713d7d482cce3f74927531d', 32, 1442212861, 0, '2015-09-14 06:49:48', 'FF0000', NULL, 1, 0, 1, 0, 0, '2015-09-14 06:49:48'),
1809(2, '', 'Rohit Kashyap', 'rkgudboy@gmail.com', '1078826600', 'c7631f81440b635e358e10fed1e88df06ea254f64fcbfe59f5', 1, 1440222504, 0, '2015-08-22 05:56:25', 'FF0000', NULL, 0, 1, 1, 0, 0, '2015-08-22 05:56:25'),
1810(3, '', 'Swapnil Palash', 'swapnil.genius@gmail.com', '1122032155', '71fe84afb19330541e70b89eb5d4ac7ef7db89d9b6acc17267', 9, 1442243262, 0, '2015-09-14 15:58:42', 'FF0000', NULL, 0, 1, 1, 0, 0, '2015-09-14 15:58:42');
1811
1812-- --------------------------------------------------------
1813
1814--
1815-- Table structure for table `verified`
1816--
1817
1818CREATE TABLE IF NOT EXISTS `verified` (
1819 `id` bigint(20) unsigned NOT NULL,
1820 `incident_id` bigint(20) unsigned DEFAULT NULL,
1821 `user_id` int(11) DEFAULT NULL,
1822 `verified_date` datetime DEFAULT NULL,
1823 `verified_status` tinyint(4) NOT NULL DEFAULT '0'
1824) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='Stores all verified reports';
1825
1826--
1827-- Dumping data for table `verified`
1828--
1829
1830INSERT INTO `verified` (`id`, `incident_id`, `user_id`, `verified_date`, `verified_status`) VALUES
1831(1, 2, 1, '2015-06-05 17:19:29', 3),
1832(2, 29, 1, '2015-06-05 23:27:03', 3),
1833(3, 4, 1, '2015-06-05 23:28:43', 2),
1834(4, 3, 1, '2015-06-05 23:29:44', 3),
1835(5, 1, 1, '2015-06-05 23:30:19', 3),
1836(6, 2, 1, '2015-06-05 23:31:08', 3),
1837(7, 1, 1, '2015-06-05 23:32:50', 3),
1838(8, 4, 1, '2015-06-06 10:00:51', 3),
1839(9, 46, 1, '2015-06-06 10:00:51', 3);
1840
1841-- --------------------------------------------------------
1842
1843--
1844-- Table structure for table `volunteer`
1845--
1846
1847CREATE TABLE IF NOT EXISTS `volunteer` (
1848 `id` bigint(20) unsigned NOT NULL,
1849 `user_id` int(11) unsigned DEFAULT '0',
1850 `volunteer` tinyint(4) NOT NULL DEFAULT '0',
1851 `incident_id` bigint(20) unsigned DEFAULT NULL,
1852 `volunteer_ip` varchar(100) DEFAULT NULL,
1853 `volunteer_date` datetime DEFAULT NULL
1854) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='Stores Volunteers for a student from his reports';
1855
1856--
1857-- Dumping data for table `volunteer`
1858--
1859
1860INSERT INTO `volunteer` (`id`, `user_id`, `volunteer`, `incident_id`, `volunteer_ip`, `volunteer_date`) VALUES
1861(1, 2, 1, 29, '127.0.0.1', '2015-08-22 05:56:29'),
1862(2, 3, 1, 42, '127.0.0.1', '2015-08-26 09:58:03'),
1863(3, 3, -1, 29, '127.0.0.1', '2015-09-14 15:58:46');
1864
1865--
1866-- Indexes for dumped tables
1867--
1868
1869--
1870-- Indexes for table `actions`
1871--
1872ALTER TABLE `actions`
1873 ADD PRIMARY KEY (`action_id`);
1874
1875--
1876-- Indexes for table `actions_log`
1877--
1878ALTER TABLE `actions_log`
1879 ADD PRIMARY KEY (`id`),
1880 ADD KEY `action_id` (`action_id`);
1881
1882--
1883-- Indexes for table `alert`
1884--
1885ALTER TABLE `alert`
1886 ADD PRIMARY KEY (`id`),
1887 ADD UNIQUE KEY `uniq_alert_code` (`alert_code`),
1888 ADD KEY `user_id` (`user_id`);
1889
1890--
1891-- Indexes for table `alert_category`
1892--
1893ALTER TABLE `alert_category`
1894 ADD PRIMARY KEY (`id`),
1895 ADD KEY `alert_id` (`alert_id`),
1896 ADD KEY `category_id` (`category_id`);
1897
1898--
1899-- Indexes for table `alert_sent`
1900--
1901ALTER TABLE `alert_sent`
1902 ADD PRIMARY KEY (`id`),
1903 ADD KEY `incident_id` (`incident_id`),
1904 ADD KEY `alert_id` (`alert_id`);
1905
1906--
1907-- Indexes for table `api_banned`
1908--
1909ALTER TABLE `api_banned`
1910 ADD PRIMARY KEY (`id`);
1911
1912--
1913-- Indexes for table `api_log`
1914--
1915ALTER TABLE `api_log`
1916 ADD PRIMARY KEY (`id`);
1917
1918--
1919-- Indexes for table `api_settings`
1920--
1921ALTER TABLE `api_settings`
1922 ADD PRIMARY KEY (`id`);
1923
1924--
1925-- Indexes for table `badge`
1926--
1927ALTER TABLE `badge`
1928 ADD PRIMARY KEY (`id`);
1929
1930--
1931-- Indexes for table `badge_users`
1932--
1933ALTER TABLE `badge_users`
1934 ADD PRIMARY KEY (`user_id`,`badge_id`);
1935
1936--
1937-- Indexes for table `category`
1938--
1939ALTER TABLE `category`
1940 ADD PRIMARY KEY (`id`),
1941 ADD KEY `category_visible` (`category_visible`),
1942 ADD KEY `parent_id` (`parent_id`);
1943
1944--
1945-- Indexes for table `category_lang`
1946--
1947ALTER TABLE `category_lang`
1948 ADD PRIMARY KEY (`id`),
1949 ADD KEY `category_id` (`category_id`);
1950
1951--
1952-- Indexes for table `city`
1953--
1954ALTER TABLE `city`
1955 ADD PRIMARY KEY (`id`),
1956 ADD KEY `country_id` (`country_id`);
1957
1958--
1959-- Indexes for table `cluster`
1960--
1961ALTER TABLE `cluster`
1962 ADD PRIMARY KEY (`id`),
1963 ADD KEY `location_id` (`location_id`),
1964 ADD KEY `incident_id` (`incident_id`),
1965 ADD KEY `category_id` (`category_id`);
1966
1967--
1968-- Indexes for table `comment`
1969--
1970ALTER TABLE `comment`
1971 ADD PRIMARY KEY (`id`),
1972 ADD KEY `incident_id` (`incident_id`),
1973 ADD KEY `user_id` (`user_id`);
1974
1975--
1976-- Indexes for table `country`
1977--
1978ALTER TABLE `country`
1979 ADD PRIMARY KEY (`id`);
1980
1981--
1982-- Indexes for table `externalapp`
1983--
1984ALTER TABLE `externalapp`
1985 ADD PRIMARY KEY (`id`);
1986
1987--
1988-- Indexes for table `feed`
1989--
1990ALTER TABLE `feed`
1991 ADD PRIMARY KEY (`id`);
1992
1993--
1994-- Indexes for table `feed_item`
1995--
1996ALTER TABLE `feed_item`
1997 ADD PRIMARY KEY (`id`),
1998 ADD KEY `feed_id` (`feed_id`),
1999 ADD KEY `incident_id` (`incident_id`),
2000 ADD KEY `location_id` (`location_id`);
2001
2002--
2003-- Indexes for table `feed_item_category`
2004--
2005ALTER TABLE `feed_item_category`
2006 ADD PRIMARY KEY (`id`),
2007 ADD UNIQUE KEY `feed_item_category_ids` (`feed_item_id`,`category_id`),
2008 ADD KEY `feed_item_id` (`feed_item_id`),
2009 ADD KEY `category_id` (`category_id`);
2010
2011--
2012-- Indexes for table `form`
2013--
2014ALTER TABLE `form`
2015 ADD PRIMARY KEY (`id`),
2016 ADD UNIQUE KEY `form_title` (`form_title`);
2017
2018--
2019-- Indexes for table `form_field`
2020--
2021ALTER TABLE `form_field`
2022 ADD PRIMARY KEY (`id`),
2023 ADD UNIQUE KEY `field_name` (`field_name`,`form_id`),
2024 ADD KEY `fk_form_id` (`form_id`);
2025
2026--
2027-- Indexes for table `form_field_option`
2028--
2029ALTER TABLE `form_field_option`
2030 ADD PRIMARY KEY (`id`),
2031 ADD KEY `form_field_id` (`form_field_id`);
2032
2033--
2034-- Indexes for table `form_response`
2035--
2036ALTER TABLE `form_response`
2037 ADD PRIMARY KEY (`id`),
2038 ADD KEY `fk_form_field_id` (`form_field_id`),
2039 ADD KEY `incident_id` (`incident_id`);
2040
2041--
2042-- Indexes for table `geometry`
2043--
2044ALTER TABLE `geometry`
2045 ADD PRIMARY KEY (`id`),
2046 ADD SPATIAL KEY `geometry` (`geometry`),
2047 ADD KEY `incident_id` (`incident_id`);
2048
2049--
2050-- Indexes for table `incident`
2051--
2052ALTER TABLE `incident`
2053 ADD PRIMARY KEY (`id`),
2054 ADD KEY `location_id` (`location_id`),
2055 ADD KEY `incident_active` (`incident_active`),
2056 ADD KEY `incident_date` (`incident_date`),
2057 ADD KEY `form_id` (`form_id`),
2058 ADD KEY `user_id` (`user_id`),
2059 ADD KEY `incident_mode` (`incident_mode`),
2060 ADD KEY `incident_verified` (`incident_verified`);
2061
2062--
2063-- Indexes for table `incident_category`
2064--
2065ALTER TABLE `incident_category`
2066 ADD PRIMARY KEY (`id`),
2067 ADD UNIQUE KEY `incident_category_ids` (`incident_id`,`category_id`),
2068 ADD KEY `incident_id` (`incident_id`),
2069 ADD KEY `category_id` (`category_id`);
2070
2071--
2072-- Indexes for table `incident_lang`
2073--
2074ALTER TABLE `incident_lang`
2075 ADD PRIMARY KEY (`id`),
2076 ADD KEY `incident_id` (`incident_id`);
2077
2078--
2079-- Indexes for table `incident_person`
2080--
2081ALTER TABLE `incident_person`
2082 ADD PRIMARY KEY (`id`),
2083 ADD KEY `incident_id` (`incident_id`);
2084
2085--
2086-- Indexes for table `layer`
2087--
2088ALTER TABLE `layer`
2089 ADD PRIMARY KEY (`id`);
2090
2091--
2092-- Indexes for table `level`
2093--
2094ALTER TABLE `level`
2095 ADD PRIMARY KEY (`id`);
2096
2097--
2098-- Indexes for table `location`
2099--
2100ALTER TABLE `location`
2101 ADD PRIMARY KEY (`id`),
2102 ADD KEY `country_id` (`country_id`),
2103 ADD KEY `latitude` (`latitude`),
2104 ADD KEY `longitude` (`longitude`);
2105
2106--
2107-- Indexes for table `maintenance`
2108--
2109ALTER TABLE `maintenance`
2110 ADD PRIMARY KEY (`allowed_ip`);
2111
2112--
2113-- Indexes for table `media`
2114--
2115ALTER TABLE `media`
2116 ADD PRIMARY KEY (`id`),
2117 ADD KEY `incident_id` (`incident_id`),
2118 ADD KEY `location_id` (`location_id`),
2119 ADD KEY `badge_id` (`badge_id`),
2120 ADD KEY `message_id` (`message_id`);
2121
2122--
2123-- Indexes for table `message`
2124--
2125ALTER TABLE `message`
2126 ADD PRIMARY KEY (`id`),
2127 ADD KEY `user_id` (`user_id`),
2128 ADD KEY `incident_id` (`incident_id`),
2129 ADD KEY `reporter_id` (`reporter_id`);
2130
2131--
2132-- Indexes for table `openid`
2133--
2134ALTER TABLE `openid`
2135 ADD PRIMARY KEY (`id`),
2136 ADD KEY `openid` (`openid`),
2137 ADD KEY `user_id` (`user_id`);
2138
2139--
2140-- Indexes for table `opportunities`
2141--
2142ALTER TABLE `opportunities`
2143 ADD PRIMARY KEY (`id`);
2144
2145--
2146-- Indexes for table `page`
2147--
2148ALTER TABLE `page`
2149 ADD PRIMARY KEY (`id`);
2150
2151--
2152-- Indexes for table `permissions`
2153--
2154ALTER TABLE `permissions`
2155 ADD PRIMARY KEY (`id`),
2156 ADD UNIQUE KEY `name_UNIQUE` (`name`);
2157
2158--
2159-- Indexes for table `permissions_roles`
2160--
2161ALTER TABLE `permissions_roles`
2162 ADD PRIMARY KEY (`role_id`,`permission_id`);
2163
2164--
2165-- Indexes for table `plugin`
2166--
2167ALTER TABLE `plugin`
2168 ADD PRIMARY KEY (`id`),
2169 ADD UNIQUE KEY `plugin_name` (`plugin_name`);
2170
2171--
2172-- Indexes for table `private_message`
2173--
2174ALTER TABLE `private_message`
2175 ADD PRIMARY KEY (`id`),
2176 ADD KEY `user_id` (`user_id`);
2177
2178--
2179-- Indexes for table `rating`
2180--
2181ALTER TABLE `rating`
2182 ADD PRIMARY KEY (`id`),
2183 ADD KEY `user_id` (`user_id`),
2184 ADD KEY `incident_id` (`incident_id`),
2185 ADD KEY `comment_id` (`comment_id`);
2186
2187--
2188-- Indexes for table `reporter`
2189--
2190ALTER TABLE `reporter`
2191 ADD PRIMARY KEY (`id`),
2192 ADD KEY `user_id` (`user_id`),
2193 ADD KEY `location_id` (`location_id`),
2194 ADD KEY `service_id` (`service_id`),
2195 ADD KEY `level_id` (`level_id`);
2196
2197--
2198-- Indexes for table `roles`
2199--
2200ALTER TABLE `roles`
2201 ADD PRIMARY KEY (`id`),
2202 ADD UNIQUE KEY `uniq_name` (`name`);
2203
2204--
2205-- Indexes for table `roles_users`
2206--
2207ALTER TABLE `roles_users`
2208 ADD PRIMARY KEY (`user_id`,`role_id`),
2209 ADD KEY `fk_role_id` (`role_id`);
2210
2211--
2212-- Indexes for table `scheduler`
2213--
2214ALTER TABLE `scheduler`
2215 ADD PRIMARY KEY (`id`);
2216
2217--
2218-- Indexes for table `scheduler_log`
2219--
2220ALTER TABLE `scheduler_log`
2221 ADD PRIMARY KEY (`id`),
2222 ADD KEY `scheduler_id` (`scheduler_id`);
2223
2224--
2225-- Indexes for table `service`
2226--
2227ALTER TABLE `service`
2228 ADD PRIMARY KEY (`id`);
2229
2230--
2231-- Indexes for table `sessions`
2232--
2233ALTER TABLE `sessions`
2234 ADD PRIMARY KEY (`session_id`);
2235
2236--
2237-- Indexes for table `settings`
2238--
2239ALTER TABLE `settings`
2240 ADD PRIMARY KEY (`id`),
2241 ADD UNIQUE KEY `uq_settings_key` (`key`);
2242
2243--
2244-- Indexes for table `user_tokens`
2245--
2246ALTER TABLE `user_tokens`
2247 ADD PRIMARY KEY (`id`),
2248 ADD UNIQUE KEY `uniq_token` (`token`),
2249 ADD KEY `fk_user_id` (`user_id`);
2250
2251--
2252-- Indexes for table `users`
2253--
2254ALTER TABLE `users`
2255 ADD PRIMARY KEY (`id`),
2256 ADD UNIQUE KEY `uniq_username` (`username`),
2257 ADD UNIQUE KEY `uniq_email` (`email`);
2258
2259--
2260-- Indexes for table `verified`
2261--
2262ALTER TABLE `verified`
2263 ADD PRIMARY KEY (`id`),
2264 ADD KEY `incident_id` (`incident_id`);
2265
2266--
2267-- Indexes for table `volunteer`
2268--
2269ALTER TABLE `volunteer`
2270 ADD PRIMARY KEY (`id`);
2271
2272--
2273-- AUTO_INCREMENT for dumped tables
2274--
2275
2276--
2277-- AUTO_INCREMENT for table `actions`
2278--
2279ALTER TABLE `actions`
2280 MODIFY `action_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
2281--
2282-- AUTO_INCREMENT for table `actions_log`
2283--
2284ALTER TABLE `actions_log`
2285 MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
2286--
2287-- AUTO_INCREMENT for table `alert`
2288--
2289ALTER TABLE `alert`
2290 MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;
2291--
2292-- AUTO_INCREMENT for table `alert_category`
2293--
2294ALTER TABLE `alert_category`
2295 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
2296--
2297-- AUTO_INCREMENT for table `alert_sent`
2298--
2299ALTER TABLE `alert_sent`
2300 MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;
2301--
2302-- AUTO_INCREMENT for table `api_banned`
2303--
2304ALTER TABLE `api_banned`
2305 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
2306--
2307-- AUTO_INCREMENT for table `api_log`
2308--
2309ALTER TABLE `api_log`
2310 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=19;
2311--
2312-- AUTO_INCREMENT for table `api_settings`
2313--
2314ALTER TABLE `api_settings`
2315 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
2316--
2317-- AUTO_INCREMENT for table `badge`
2318--
2319ALTER TABLE `badge`
2320 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
2321--
2322-- AUTO_INCREMENT for table `category`
2323--
2324ALTER TABLE `category`
2325 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
2326--
2327-- AUTO_INCREMENT for table `category_lang`
2328--
2329ALTER TABLE `category_lang`
2330 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT;
2331--
2332-- AUTO_INCREMENT for table `city`
2333--
2334ALTER TABLE `city`
2335 MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;
2336--
2337-- AUTO_INCREMENT for table `comment`
2338--
2339ALTER TABLE `comment`
2340 MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;
2341--
2342-- AUTO_INCREMENT for table `country`
2343--
2344ALTER TABLE `country`
2345 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=250;
2346--
2347-- AUTO_INCREMENT for table `externalapp`
2348--
2349ALTER TABLE `externalapp`
2350 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
2351--
2352-- AUTO_INCREMENT for table `feed`
2353--
2354ALTER TABLE `feed`
2355 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT;
2356--
2357-- AUTO_INCREMENT for table `feed_item`
2358--
2359ALTER TABLE `feed_item`
2360 MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;
2361--
2362-- AUTO_INCREMENT for table `feed_item_category`
2363--
2364ALTER TABLE `feed_item_category`
2365 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
2366--
2367-- AUTO_INCREMENT for table `form`
2368--
2369ALTER TABLE `form`
2370 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
2371--
2372-- AUTO_INCREMENT for table `form_field`
2373--
2374ALTER TABLE `form_field`
2375 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=15;
2376--
2377-- AUTO_INCREMENT for table `form_field_option`
2378--
2379ALTER TABLE `form_field_option`
2380 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=19;
2381--
2382-- AUTO_INCREMENT for table `form_response`
2383--
2384ALTER TABLE `form_response`
2385 MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=333;
2386--
2387-- AUTO_INCREMENT for table `geometry`
2388--
2389ALTER TABLE `geometry`
2390 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT;
2391--
2392-- AUTO_INCREMENT for table `incident`
2393--
2394ALTER TABLE `incident`
2395 MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=49;
2396--
2397-- AUTO_INCREMENT for table `incident_category`
2398--
2399ALTER TABLE `incident_category`
2400 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=82;
2401--
2402-- AUTO_INCREMENT for table `incident_lang`
2403--
2404ALTER TABLE `incident_lang`
2405 MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;
2406--
2407-- AUTO_INCREMENT for table `incident_person`
2408--
2409ALTER TABLE `incident_person`
2410 MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=28;
2411--
2412-- AUTO_INCREMENT for table `layer`
2413--
2414ALTER TABLE `layer`
2415 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
2416--
2417-- AUTO_INCREMENT for table `level`
2418--
2419ALTER TABLE `level`
2420 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
2421--
2422-- AUTO_INCREMENT for table `location`
2423--
2424ALTER TABLE `location`
2425 MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=49;
2426--
2427-- AUTO_INCREMENT for table `media`
2428--
2429ALTER TABLE `media`
2430 MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;
2431--
2432-- AUTO_INCREMENT for table `message`
2433--
2434ALTER TABLE `message`
2435 MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;
2436--
2437-- AUTO_INCREMENT for table `openid`
2438--
2439ALTER TABLE `openid`
2440 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
2441--
2442-- AUTO_INCREMENT for table `opportunities`
2443--
2444ALTER TABLE `opportunities`
2445 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
2446--
2447-- AUTO_INCREMENT for table `page`
2448--
2449ALTER TABLE `page`
2450 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
2451--
2452-- AUTO_INCREMENT for table `permissions`
2453--
2454ALTER TABLE `permissions`
2455 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=21;
2456--
2457-- AUTO_INCREMENT for table `plugin`
2458--
2459ALTER TABLE `plugin`
2460 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
2461--
2462-- AUTO_INCREMENT for table `private_message`
2463--
2464ALTER TABLE `private_message`
2465 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
2466--
2467-- AUTO_INCREMENT for table `rating`
2468--
2469ALTER TABLE `rating`
2470 MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
2471--
2472-- AUTO_INCREMENT for table `reporter`
2473--
2474ALTER TABLE `reporter`
2475 MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;
2476--
2477-- AUTO_INCREMENT for table `roles`
2478--
2479ALTER TABLE `roles`
2480 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
2481--
2482-- AUTO_INCREMENT for table `scheduler`
2483--
2484ALTER TABLE `scheduler`
2485 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
2486--
2487-- AUTO_INCREMENT for table `scheduler_log`
2488--
2489ALTER TABLE `scheduler_log`
2490 MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=99;
2491--
2492-- AUTO_INCREMENT for table `service`
2493--
2494ALTER TABLE `service`
2495 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
2496--
2497-- AUTO_INCREMENT for table `settings`
2498--
2499ALTER TABLE `settings`
2500 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=81;
2501--
2502-- AUTO_INCREMENT for table `user_tokens`
2503--
2504ALTER TABLE `user_tokens`
2505 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
2506--
2507-- AUTO_INCREMENT for table `users`
2508--
2509ALTER TABLE `users`
2510 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
2511--
2512-- AUTO_INCREMENT for table `verified`
2513--
2514ALTER TABLE `verified`
2515 MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
2516--
2517-- AUTO_INCREMENT for table `volunteer`
2518--
2519ALTER TABLE `volunteer`
2520 MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;--