Branch - Master

actions_log

Field	Type	Collation	Null	Key	Default	Extra
id	bigint(20)		NO	PRIMARY	None	AUTO_INCREMENT
action_id	int(11)		NO		None	FK->actions.action_id
user_id	int(11)		NO		None
time	int(10)		NO		None

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	id
action_id	BTREE	No	No	action_id

actions

Field	Type	Collation	Null	Key	Default	Extra
action_id	int(11)		NO	PRIMARY	None	AUTO_INCREMENT
action	varchar(75)	utf8_general_ci	NO		None
qualifiers	text	utf8_general_ci	NO		None
response	varchar(75)	utf8_general_ci	NO		None
response_vars	text	utf8_general_ci	NO		None
active	tinyint(4)		NO		None

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	action_id

alert

Field	Type	Collation	Null	Key	Default	Extra
id	bigint(20) unsigned		NO	PRIMARY	None	AUTO_INCREMENT
user_id	int(11) unsigned		YES		0	FK->users.id
alert_type	tinyint(4)		NO		None
alert_recipient	varchar(200)	utf8_general_ci	YES		NULL
alert_code	varchar(30)	utf8_general_ci	YES		NULL
alert_confirmed	tinyint(4)		NO		0
alert_lat	varchar(150)	utf8_general_ci	YES		NULL
alert_lon	varchar(150)	utf8_general_ci	YES		NULL
alert_radius	tinyint(4)	utf8_general_ci	NO		20
alert_ip	varchar(100)	utf8_general_ci	YES		NULL

alert_type: 1 - Mobile, 2 - Email
Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	id
uniq_alert_code	BTREE	Yes	0	alert_code
user_id	BTREE	No	0	user_id

alert_category

Field	Type	Collation	Null	Key	Default	Extra
id	int(11)		NO	PRIMARY	None	AUTO_INCREMENT
alert_id	bigint(20) unsigned		YES		NULL	FK->alert.id
category_id	int(11) unsigned		YES		NULL	FK->category.id

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	id
alert_id	BTREE	No	0	alert_id
category_id	BTREE	No	0	category_id

alert_sent

Field	Type	Collation	Null	Key	Default	Extra
id	bigint(20) unsigned		NO	PRIMARY	None	AUTO_INCREMENT
incident_id	bigint(20) unsigned		NO		None	FK->incident.id
alert_id	bigint(20) unsigned		NO		None	FK->alert.id
alert_date	datetime		YES		NULL

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	id
incident_id	BTREE	No	0	incident_id
alert_id	BTREE	No	0	alert_id

api_banned

Field	Type	Collation	Null	Key	Default	Extra
id	int(11) unsigned		NO	PRIMARY	None	AUTO_INCREMENT
banned_ipaddress	varchar(50)	utf8_general_ci	NO		None
banned_date	datetime		NO		None

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	id

api_log

Field	Type	Collation	Null	Key	Default	Extra
id	int(11) unsigned		NO	PRIMARY	None	AUTO_INCREMENT
api_task	varchar(10)	utf8_general_ci	NO		None
api_parameters	varchar(100)	utf8_general_ci	NO		None
api_record	tinyint(11)		NO		None
api_ipaddress	varchar(50)	utf8_general_ci	NO		None
api_date	datetime		NO		None

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	id

api_settings

Field	Type	Collation	Null	Key	Default	Extra
id	int(11)		NO	PRIMARY	None	AUTO_INCREMENT
default_record_limit	int(11)		NO		None
max_record_limit	int(11)		YES		NULL
max_requests_per_ip_address	int(11)		YES		NULL
max_requests_quota_basis	int(11)		YES		NULL
modification_date	datetime		NO		None

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	id

badge

Field	Type	Collation	Null	Key	Default	Extra
id	int(11)		NO	PRIMARY	None	AUTO_INCREMENT
name	varchar(250)	utf8_general_ci	NO		None
description	text	utf8_general_ci	NO		None

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	id

badge_users

Field	Type	Collation	Null	Key	Default	Extra
user_id	int(11) unsigned		NO		None	FK->users.id
badge_id	int(11)		NO		None	FK->badge.id

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	user_id badge_id

category

Field	Type	Collation	Null	Key	Default	Extra
id	int(11) unsigned		NO	PRIMARY	None	AUTO_INCREMENT
parent_id	int(11)		NO		None
locale	varchar(10)	utf8_general_ci	NO		en_US
category_position	tinyint(4)		NO		0
category_title	varchar(255)	utf8_general_ci	YES		NULL
category_description	text	utf8_general_ci	YES		NULL
category_color	varchar(20)	utf8_general_ci	YES		NULL
category_image	varchar(255)	utf8_general_ci	YES		NULL
category_image_ thumb	varchar(255)	utf8_general_ci	YES		NULL
category_visible	tinyint(4)		NO		1
category_trusted	tinyint(4)		NO		0

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	5	id
category_visible	BTREE	No	0	category_visible
parent_id	BTREE	No	0	parent_id

category_lang

Field	Type	Collation	Null	Key	Default	Extra
id	int(11) unsigned		NO	PRIMARY	None	AUTO_INCREMENT
category_id	int(11) unsigned		NO		None	FK->category.id
locale	varchar(10)	utf8_general_ci	YES		NULL
category_title	varchar(255)	utf8_general_ci	YES		NULL
category_description	text	utf8_general_ci	YES		NULL

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	id
category_id	BTREE	No	0	category_id

checkin

Field	Type	Collation	Null	Key	Default	Extra
id	bigint(20) unsigned		NO		None	AUTO_INCREMENT
user_id	int(11) unsigned		NO		None	FK->users.id
location_id	bigint(20) unsigned		NO		None	FK->location.id
incident_id	bigint(20) unsigned		YES		0	FK->incident.id
checkin_ description	varchar(255)	utf8_general_ci	YES		NULL
checkin_date	datetime		NO		None
checkin_auto	enum(‘0’, ‘1’)	utf8_general_ci	YES		0

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	id
incident_id	BTREE	No	0	incident_id
user_id	BTREE	No	0	user_id
location_id	BTREE	No	0	location_id

city

Field	Type	Collation	Null	Key	Default	Extra
id	bigint(20) unsigned		NO	PRIMARY	None	AUTO_INCREMENT
country_id	int(11)		YES		NULL	FK->country.id
city	varchar(200)	utf8_general_ci	YES		NULL
city_lat	varchar(200)	utf8_general_ci	YES		NULL
city_lon	varchar(200)	utf8_general_ci	YES		NULL

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	id
country_id	BTREE	No	0	country_id

cluster

Field	Type	Collation	Null	Key	Default	Extra
id	int(11)		No	PRIMARY	None	AUTO_INCREMENT
location_id	bigint(20) unsigned		No		0	FK->location.id
latitude	double		No		None
longitude	double		No		None
latitude_min	double		No		None
longitude_min	double		No		None
latitude_ max	double		No		None
longitude_max	double		No		None
child_count	int(11)		No		None
parent_id	int(11)		No		None
left_side	int(11)		No		None
right_side	int(11)		No		None
level	int(11)		No		None
incident_id	bigint(20) unsigned		No		None	FK->incident.id
category_id	int(11) unsigned		No		0	FK->category.id

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	id
location_id	BTREE	No	0	location_id
incident_id	BTREE	No	0	incident_id
category_id	BTREE	No	0	category_id

comment

Field	Type	Collation	Null	Key	Default	Extra
id	bigint(20) unsigned		NO	PRIMARY	None	AUTO_INCREMENT
incident_id	bigint(20) unsigned		Yes		NULL	FK->incident.id
checkin_id	bigint(20) unsigned		Yes		NULL	FK->checkin.id
user_id	int(11) unsigned		Yes		NULL	FK->users.id
comment_ author	varchar(100)	utf8_general_ci	Yes		NULL
comment_ email	varchar(120)	utf8_general_ci	Yes		NULL
comment_ description	text	utf8_general_ci	Yes		NULL
comment_ip	varchar(100)	utf8_general_ci	Yes		NULL
comment_ rating	varchar(15)	utf8_general_ci	NO		0
comment_ spam	tinyint(4)		NO		0
comment_ active	tinyint(4)		NO		0
comment_ date	datetime		Yes		NULL
comment_ date_gmt	datetime		Yes		NULL

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	id
incident_id	BTREE	No	0	incident_id
checkin_id	BTREE	No	0	checkin_id
user_id	BTREE	No	0	user_id

country

Field	Type	Collation	Null	Key	Default	Extra
id	int(11)		No	PRIMARY	None	AUTO_INCREMENT
iso	varchar(10)	utf8_general_ci	Yes		NULL
country	varchar(100)	utf8_general_ci	Yes		NULL
capital	varchar(100)	utf8_general_ci	Yes		NULL
cities	tinyint(4)		No		0

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	247	id

externalapp

Field	Type	Collation	Null	Key	Default	Extra
id	int(11)		No	PRIMARY	None	AUTO_INCREMENT
name	varchar(255)	l atin_swedish_ci	No		None
url	varchar(255)	l atin_swedish_ci	No		None

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	2	id

feed

Field	Type	Collation	Null	Key	Default	Extra
id	int(11) unsigned		NO	PRIMARY	None	AUTO_INCREMENT
feed_name	varchar(255)	utf8_general_ci	Yes		NULL
feed_url	varchar(255)	utf8_general_ci	Yes		NULL
feed_cache	text	utf8_general_ci	Yes		NULL
feed_active	tinyint(4)		Yes		1
feed_update	int(11)		No		0

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	1	id

feed_item

Field	Type	Collation	Null	Key	Default	Extra
id	bigint(20) unsigned		No	PRIMARY	None	AUTO_INCREMENT
feed_id	int(11) unsigned		No		None	FK->feed.id
location_id	bigint(20) unsigned		Yes		0	FK ->location.id
incident_id	bigint(20) unsigned		No		0	FK->incident.id
item_title	varchar(255)	utf8_general_ci	Yes		NULL
item_description	text	utf8_general_ci	Yes		NULL
item_link	varchar(255)	utf8_general_ci	Yes		NULL
item_date	datetime		Yes		NULL

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	id
feed_id	BTREE	No	0	feed_id
incident_id	BTREE	No	0	incident_id
location_id	BTREE	No	0	location_id

form

Field	Type	Collation	Null	Key	Default	Extra
id	int(11)		No	PRIMARY	None	AUTO_INCREMENT
form_title	varchar(200)	utf8_general_ci	No		None
form_ description	text	utf8_general_ci	Yes		NULL
form_active	tinyint(4)		Yes		1

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	1	id
form_title	BTREE	Yes	1	form_title

form_field

Field	Type	Collation	Null	Key	Default	Extra
id	int(11)		No	PRIMARY	None	AUTO_INCREMENT
form_id	int(11)		No		1	FK->form.id
field_name	varchar(200)	utf8_general_ci	Yes		NULL
field_type	tinyint(4)		No		1
field_required	tinyint(4)		Yes		0
field_position	tinyint(4)		No		0
field_default	text	utf8_general_ci	Yes		NULL
field_maxlength	int(11)		No		0
field_width	smallint(6)		No		0
field_height	tinyint(4)		Yes		5
field_isdate	tinyint(4)		No		0
field_ispublic_visible	int(11)		No		0
field_ispublic_submit	int(11)		No		0

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	id
fk_form_id	BTREE	No	0	form_id
field_name	BTREE	Yes		field_name form_id

form_field_option

Field	Type	Collation	Null	Key	Default	Extra
id	int(11)		No	PRIMARY	None	AUTO_INCREMENT
form_field_id	int(11)		No		0	FK->form_field.id
option_name	varchar(200)	utf8_general_ci	Yes		NULL
option_value	text	utf8_general_ci	Yes		NULL

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	id
form_field_id	BTREE	No	0	form_field_id

form_response

Field	Type	Collation	Null	Key	Default	Extra
id	bigint(20)		No	PRIMARY	None	AUTO_INCREMENT
form_field_id	int(11)		No		None	FK->form_field.id
incident_id	bigint(20) unsigned		No		None	FK->incident.id
form_response	text	utf8_general_ci	No		None

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	id
fk_form_field_id	BTREE	No	0	form_field_id
incident_id	BTREE	No	0	incident_id

geometry

Field	Type	Collation	Null	Key	Default	Extra
id	int(11) unsigned		No	PRIMARY	None	AUTO_INCREMENT
incident_id	bigint(20) unsigned		No		None	FK->incident.id
geometry	geometry		No		None
geometry_label	varchar(150)	utf8_general_ci	Yes		NULL
geometry_ comment	varchar(255)	utf8_general_ci	Yes		NULL
geometry_ color	varchar(20)	utf8_general_ci	Yes		NULL
geometry_ strokewidth	varchar(5)	utf8_general_ci	Yes		NULL

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	id
geometry	SPATIAL	No	0	geometry(32)
incident_id	BTREE	No	0	incident_id

incident

Field	Type	Collation	Null	Key	Default	Extra
id	bigint(20) unsigned		No	PRIMARY	None	AUTO_INCREMENT
location_id	bigint(20) unsigned		No		None	FK ->location.id
form_id	int(11)		No		1	FK -> form.id
locale	varchar(10)	utf8_general_ci	No		en_US
user_id	int(11) unsigned		Yes		NULL	FK ->users.id
incident_title	varchar(255)	utf8_general_ci	Yes		NULL
incident_ description	longtext	utf8_general_ci	Yes		NULL
incident_date	datetime		Yes		NULL
incident_mode	tinyint(4)		No		1
incident_active	tinyint(4)		No		0
incident_verified	tinyint(4)		No		1
incident_dateadd	datetime		Yes		NULL
incident_dateadd_gmt	datetime		Yes		NULL
incident_ datemodify	datetime		Yes		NULL
incident_alert_ status	tinyint(4)		No		0
incident_zoom	tinyint(4)		Yes		NULL

incident_mode: 1 - Web, 2 - SMS, 3 - Email, 4 - Twitter
incident_alert_status: 0 - Not tagged for sending, 1 - Tagged for sending, 2 - Alerts have been sent
Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	1	id
location_id	BTREE	No	1	location_id
incident_active	BTREE	No	1	incident_active
incident_date	BTREE	No	1	incident_date
form_id	BTREE	No	1	form_id
user_id	BTREE	No	1	user_id
incident_mode	BTREE	No	1	incident_mode
incident_verified	BTREE	No	2	incident_verified

incident_category

Field	Type	Collation	Null	Key	Default	Extra
id	int(11)		No	PRIMARY	None	AUTO_INCREMENT
incident_id	bigint(20) unsigned		No		None
category_id	int(11) unsigned		No		0

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	1	id
incident_category_ids	BTREE	Yes	0 1	incident_id category_id
incident_id	BTREE	Yes	0	incident_id
category_id	BTREE	Yes	1	category_id

incident_lang

Field	Type	Collation	Null	Key	Default	Extra
id	bigint(20) unsigned		No	PRIMARY	None	AUTO_INCREMENT
incident_id	bigint(20) unsigned		No		None	FK ->incident.id
locale	varchar(10)	utf8_general_ci	Yes		NULL
incident_title	varchar(255)	utf8_general_ci	Yes		NULL
incident_ description	longtext	utf8_general_ci	Yes		NULL

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	id
incident_id	BTREE	No	0	incident_id

incident_person

Field	Type	Collation	Null	Key	Default	Extra
id	bigint(20) unsigned		No	PRIMARY	None	AUTO_INCREMENT
incident_id	bigint(20) unsigned		Yes		NULL	FK->incident.id
person_first	varchar(200)	utf8_general_ci	Yes		NULL
person_last	varchar(200)	utf8_general_ci	Yes		NULL
person_email	varchar(120)	utf8_general_ci	Yes		NULL
person_phone	varchar(60)	utf8_general_ci	Yes		NULL
person_ip	varchar(50)	utf8_general_ci	Yes		NULL
person_date	datetime		Yes		NULL

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	id
incident_id	BTREE	No	0	incident_id

layer

Field	Type	Collation	Null	Key	Default	Extra
id	int(11)		No	PRIMARY	None	AUTO_INCREMENT
layer_name	varchar(255)	utf8_general_ci	Yes		NULL
layer_url	varchar(255)	utf8_general_ci	Yes		NULL
layer_file	varchar(100)	utf8_general_ci	Yes		NULL
layer_color	varchar(20)	utf8_general_ci	Yes		NULL
layer_visible	tinyint(4)		No		1

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	id

level

Field	Type	Collation	Null	Key	Default	Extra
id	int(11) unsigned		No	PRIMARY	None	AUTO_INCREMENT
level_title	varchar(200)	utf8_general_ci	Yes		NULL
level_ description	varchar(200)	utf8_general_ci	Yes		NULL
level_weight	tinyint(4)		No		None

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	5	id

location

Field	Type	Collation	Null	Key	Default	Extra
id	bigint(20) unsigned		No	PRIMARY	None	AUTO_INCREMENT
location_name	varchar(255)	utf8_general_ci	Yes		NULL
country_id	int(11)		No		0	FK->country.id
latitude	double		No		0
longitude	double		No		0
location_visible	tinyint(4)		No		1
location_date	datetime		Yes		NULL

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	1	id
country_id	BTREE	No	1	country_id
latitude	BTREE	No	1	latitude
longitude	BTREE	No	1	longitude

maintenance

Field	Type	Collation	Null	Key	Default	Extra
allowed_ip	varchar(15)	utf_general_ci	No	PRIMARY	NONE

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	allowed_ip

media

Field	Type	Collation	Null	Key	Default	Extra
id	bigint(20) unsigned		No	PRIMARY	None	AUTO_INCREMENT
location_id	bigint(20) unsigned		Yes		NULL	FK->location.id
incident_id	bigint(20) unsigned		Yes		NULL	FK ->incident.id
checkin_id	bigint(20) unsigned		Yes		NULL	FK ->checkin.id
message_id	bigint(20) unsigned		Yes		NULL	FK ->message.id
badge_id	int(11)		Yes		NULL
media_type	tinyint(4)		Yes		NULL
media_title	varchar(255)	utf8_general_ci	Yes		NULL
media_ description	longtext	utf8_general_ci	Yes		NULL
media_link	varchar(255)	utf8_general_ci	Yes		NULL
media_medium	varchar(255)	utf8_general_ci	Yes		NULL
media_thumb	varchar(255)	utf8_general_ci	Yes		NULL
media_date	datetime		Yes		NULL
media_active	tinyint(4)		No		1

media_type: 1 - Images, 2 - Video, 3 - Audio, 4 - News, 5 - Podcast
Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	id
location_id	BTREE	No	0	location_id
incident_id	BTREE	No	0	incident_id
badge_id	BTREE	No	0	badge_id
checkin_id	BTREE	No	0	checkin_id
message_id	BTREE	No	0	message_id

message

Field	Type	Collation	Null	Key	Default	Extra
id	bigint(20) unsigned		No	PRIMARY	None	AUTO_INCREMENT
parent_id	bigint(20)		Yes		0
incident_id	bigint(20) unsigned		Yes		NULL	FK->incident.id
user_id	int(11) unsigned		Yes		0	FK->users.id
reporter_id	bigint(20) unsigned		Yes		NULL	FK ->reporter.id
service_messageid	varchar(100)	utf8_general_ci	Yes		NULL
message_ from	varchar(100)	utf8_general_ci	Yes		NULL
message_to	varchar(100)	utf8_general_ci	Yes		NULL
message	text	utf8_general_ci	Yes		NULL
message_ detail	text	utf8_general_ci	Yes		NULL
message_ type	tinyint(4)		Yes		1
message_ date	datetime		Yes		NULL
message_ level	tinyint(4)		Yes		0
latitude	double		Yes		NULL
longitude	double		Yes		NULL

message_type: 1 - Inbox, 2 - Outbox(from admin), 3 - Deleted
message_level: 0 - Unread, 1 - Read, 99 - Spam
Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	id
user_id	BTREE	No	0	user_id
incident_id	BTREE	No	0	incident_id
reporter_id	BTREE	No	0	reporter_id

openid

Field	Type	Collation	Null	Key	Default	Extra
id	int(11)		No	PRIMARY	None	AUTO_INCREMENT
user_id	int(11) unsigned		No		None	FK->users.id
openid	varchar(255)	utf8_general_ci	No		None
openid_email	varchar(127)	utf8_general_ci	No		None
openid_server	varchar(255)	utf8_general_ci	No		None
openid_date	datetime		No		None

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	id
openid	BTREE	No	0	openid
user_id	BTREE	No	0	user_id

page

Field	Type	Collation	Null	Key	Default	Extra
id	int(11)		No	PRIMARY	None	AUTO_INCREMENT
page_title	varchar(255)	utf8_general_ci	No		None
page_description	longtext	utf8_general_ci	Yes		NULL
page_tab	varchar(100)	utf8_general_ci	No		None
page_active	tinyint(4)		No		0

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	id

permissions

Field	Type	Collation	Null	Key	Default	Extra
id	int(11)		No	PRIMARY	None	AUTO_INCREMENT
name	varchar(32)	latin1_swedish_ci	No		None

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	18	id
name_UNIQUE	BTREE	Yes	18

permissions_roles

Field	Type	Collation	Null	Key	Default	Extra
role_id	int(11) unsigned		No		None	FK->roles.id
permission_id	int(11)		No		None	FK->permissions.id

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0 35	role_id permission_id

plugin

Field	Type	Collation	Null	Key	Default	Extra
id	int(11) unsigned		No	PRIMARY	None	AUTO_INCREMENT
plugin_name	varchar(100)	utf8_general_ci	No		None
plugin_url	varchar(250)	utf8_general_ci	Yes		NULL
plugin_ description	text	utf8_general_ci	Yes		NULL
plugin_priority	tinyint(4)		Yes		0
plugin_active	tinyint(4)		Yes		0
plugin_installed	tinyint(4)		Yes		0

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	5	id
plugin_name	BTREE	No	5	plugin_name

private_message

Field	Type	Collation	Null	Key	Default	Extra
id	int(11)		No	PRIMARY	None	AUTO_INCREMENT
parent_id	int(11)		No		None
user_id	int(11) unsigned		No		None	FK->users.id
from_user_id	int(11)		Yes		0	FK ->users.id
private_ subject	varchar(255)	utf8_general_ci	No		None
private_ message	text	utf8_general_ci	No		None
private_ message_date	datetime		No		None
private_ message_new	tinyint(4)		No		1

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	id
user_id	BTREE	No	0	user_id

rating

Field	Type	Collation	Null	Key	Default	Extra
id	bigint(20) unsigned		No	PRIMARY	None	AUTO_INCREMENT
user_id	int(11) unsigned		Yes		0	FK->users.id
incident_id	bigint(20) unsigned		Yes		NULL	FK->incident_id
comment_id	bigint(20) unsigned		Yes		0	FK->comment.id
rating	tinyint(4)		Yes		0
rating_ip	varchar(100)	utf8_general_ci	Yes		NULL
rating_date	datetime		Yes		NULL

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	id
user_id	BTREE	No	0	user_id
incident_id	BTREE	No	0	incident_id
comment_id	BTREE	No	0	comment_id

reporter

Field	Type	Collation	Null	Key	Default	Extra
id	bigint(20) unsigned		No	PRIMARY	None	AUTO_INCREMENT
location_id	bigint(20) unsigned		Yes		NULL	FK->location.id
user_id	int(11) unisigned		Yes		NULL	FK->users.if
service_id	int(10) unsigned		Yes		NULL	FK->service.id
level_id	int(11) unsigned		Yes		NULL	FK->level.id
service_ account	varchar(255)	utf8_general_ci	Yes		NULL
reporter_first	varchar(200)	utf8_general_ci	Yes		NULL
reporter_last	varchar(200)	utf8_general_ci	Yes		NULL
reporter_email	varchar(120)	utf8_general_ci	Yes		NULL
reporter_phone	varchar(60)	utf8_general_ci	Yes		NULL
reporter_ip	varchar(50)	utf8_general_ci	Yes		NULL
reporter_date	datetime		Yes		NULL

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	id
user_id	BTREE	No	0	user_id
location_id	BTREE	No	0	location_id
service_id	BTREE	No	0	service_id
level_id	BTREE	No	0	level_id

roles

Field	Type	Collation	Null	Key	Default	Extra
id	int(11) unsigned		NO	PRIMARY	None	AUTO_INCREMENT
name	varchar(32)	utf8_general_ci	No		None
description	varchar(255)	utf8_general_ci	No		None
access_level	tinyint(4)		No		0

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	4	id
uniq_name	BTREE	Yes	4	name

roles_users

Field	Type	Collation	Null	Key	Default	Extra
user_id	int(11) unsigned		No		None	FK->users.id
role_id	int(11)		No		None	FK->roles. id

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0 3	user_id role_id
fk_role_id	BTREE	No	0	role_id

scheduler

Field	Type	Collation	Null	Key	Default	Extra
id	int(10) unsigned		No	PRIMARY	None	AUTO_INCREMENT
scheduler_ name	varchar(100)	utf8_general_ci	No		None
scheduler_last	int(10) unsigned		No		0
scheduler_ weekday	smallint(6)		No		-1
scheduler_day	smallint(6)		No		-1
scheduler_hour	smallint(6)		No		-1
scheduler_ minute	smallint(6)		No		None
scheduler_ controller	varchar(100)	utf8_general_ci	No		None
scheduler_ active	tinyint(4)		No		1

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	5	id

scheduler_log

Field	Type	Collation	Null	Key	Default	Extra
id	bigint(20) unsigned		No	PRIMARY	None	AUTO_INCREMENT
scheduler_id	int(10) unsigned		No		None	FK->scheduler.id
scheduler_ status	varchar(20)	utf8_general_ci	Yes		NULL
scheduler_date	int(10) unsigned		No		None

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	id
scheduler_id	BTREE	No	0	scheduler_id

service

Field	Type	Collation	Null	Key	Default	Extra
id	int(10) unsigned		No	PRIMARY	None	AUTO_INCREMENT
service_name	varchar(100)	utf8_general_ci	Yes		NULL
service_ description	varchar(255)	utf8_general_ci	Yes		NULL
service_url	varchar(255)	utf8_general_ci	Yes		NULL
service_api	varchar(255)	utf8_general_ci	Yes		NULL

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	3	id

sessions

Field	Type	Collation	Null	Key	Default	Extra
session_id	varchar(127)	utf8_general_ci	No		None
last_activity	int(10) unsigned		No		None
data	text	utf8_general_ci	No		None

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	No	0	session_id

settings

Field	Type	Collation	Null	Key	Default	Extra
id	int(11) unsigned		No	PRIMARY	None	AUTO_INCREMENT
key	varchar(100)	utf8_general_ci	No
value	text	utf8_general_ci	Yes		Null

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	1	id
uq_settings_key	BTREE	Yes	1	key

users

Field	Type	Collation	Null	Key	Default	Extra
id	int(11) unsigned		No	PRIMARY	None	AUTO_INCREMENT
riverid	varchar(128)	utf8_general_ci	No		None
name	varchar(200)	utf8_general_ci	Yes		NULL
email	varchar(127)	utf8_general_ci	No		None
username	varchar(100)	utf8_general_ci	No		None
password	char(50)	utf8_general_ci	No		None
logins	int(10) unsigned		No		0
last_login	int(10) unsigned		No		0
notify	tinyint(1)		No		0
updated	timestamp on update CURRENT_ TIMESTAMP		No		CURRENT_ TIMESTAMP	ON UPDATE CURRENT_TIMESTAMP
color	varchar(6)	utf8_general_ci	No		FF0000
code	varchar(30)	utf8_general_ci	Yes		NULL
confirmed	tinyint(1)		No		1
public_profile	tinyint(1)		No		1
approved	tinyint(1)		No		1
needinfo	tinyint(1)		No		0

notify: Flag incase admin opts for email_notifications

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	1	id
uniq_username	BTREE	Yes	1	username
uniq_email	BTREE	Yes	1	email

user_devices

Field	Type	Collation	Null	Key	Default	Extra
id	varchar(255)	utf8_general_ci	No	PRIMARY	None
user_id	int(11) unsigned		No		None	FK->users.id

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	id
user_id	BTREE	No	0	user_id

user_tokens

Field	Type	Collation	Null	Key	Default	Extra
id	int(11) unsigned		No	PRIMARY	None	AUTO_INCREMENT
user_id	int(11) unsigned		No		None	FK->users.id
user_agent	varchar(40)	utf8_general_ci	No		None
token	varchar(64)	utf8_general_ci	No		None
created	int(10) unsigned		No		None
expires	int(10)		No		None

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	id
uniq_token	BTREE	Yes	0	token
fk_user_id	BTREE	No	0	user_id

verified

Field	Type	Collation	Null	Key	Default	Extra
id	bigint(20) unsigned		No	PRIMARY	None	AUTO_INCREMENT
incident_id	bigint(20)		Yes		NULL	FK->incident.id
user_id	int(11)		Yes		NULL	FK->users.id
verified_date	datetime		Yes		NULL
verified_status	tinyint(4)		No		0

Indexes

Keyname	Type	Unique	Cardinality	Field
PRIMARY	BTREE	Yes	0	id
incident_id	BTREE	No	0	incident_id

FOR ARCHIVAL PURPOSES ONLY

Community Wiki … Welcome to the Ushahidi wiki! Our Products Ushahidi Platform v2.x Ushahidi v2.X Developer Guide Architecture Database Description Table Details Branch - Master

Community Wiki
…

Welcome to the Ushahidi wiki!
Our Products
Ushahidi Platform v2.x
Ushahidi v2.X Developer Guide
Architecture
Database Description
Table Details

Branch - Master