FOR ARCHIVAL PURPOSES ONLY

The information in this wiki hasn't been maintained for a good while. Some of the projects described have since been deprecated.

In particular, the "Ushahidi Platform v3.x" section contains information that is often misleading. Many details about this version of Platform have changed since.

This website is an extraction of the original Ushahidi wiki into a static form. Because of that, functions like logging in, commenting or searching will not work.

For more documentation, please refer to https://docs.ushahidi.com

Community Wiki
…

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

Page History

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

...

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

...

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	varchar(200) 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	tinyintint(411)		No		0
field_ispublic_submit	tinyintint(411)		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

...

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

...

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

...

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

...

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

...

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

...