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

Skip to end of metadata
Go to start of metadata

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_idBTREENo0parent_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_modeBTREENo1incident_mode
incident_verifiedBTREENo2incident_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_idBTREEYes0incident_id
category_idBTREEYes1category_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

latitudeBTREENo1latitude
longitudeBTREENo1longitude

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