This page describes which data is needed for a local account in one of the services maemo.org hosts. This data is to be used to specify data fields in LDAP for central storage.
Services
| Service
|
Framework
|
| maemo.org |
Midgard
|
| garage.maemo.org |
G-Forge
|
| bugs.maemo.org |
Bugzilla
|
| talk.maemo.org |
vBulletin
|
| wiki.maemo.org |
Mediawiki
|
maemo.org
| Field
|
Datatype
|
| id |
int(11)
|
| username |
char(255)
|
| firstname |
char(255)
|
| lastname |
char(255)
|
| birthdate |
datetime
|
| street |
char(255)
|
| postcode |
char(255)
|
| city |
char(255)
|
| email |
char(255)
|
| fax |
char(255)
|
| country |
char(255)
|
Garage
| Field
|
Datatype
|
| user_id |
int
|
| user_name |
text
|
| email |
text
|
| realname |
char(32)
|
| jabber_address |
text
|
| address |
text
|
| phone |
text
|
| fax |
text
|
| title |
text
|
| firstname |
text
|
| lastname |
text
|
| address2 |
text
|
| ccode |
char(2)
|
Talk
| Field
|
Datatype
|
| userid |
int(10)
|
| username |
varchar(100)
|
| password |
varchar(32)
|
| joindate |
int(10)
|
| email |
varchar(100)
|
| homepage |
varchar(100)
|
| icq |
varchar(20)
|
| aim |
varchar(20)
|
| yahoo |
varchar(32)
|
| birthday |
varchar(10)
|
| msn |
varchar(100)
|
| jabber |
varchar(250)
|
| skype |
varchar(32)
|
bugs.maemo.org
| Field
|
Datatype
|
| userid |
int(9)
|
| cryptpassword |
char(128)
|
| realname |
char(255)
|
| disabledtext |
char(255)
|
| mybugslink |
int(4)
|
| refreshed_when |
datetime
|
| extern_id |
char(64)
|
wiki.maemo.org
Table mw_user.
There is also mw_user_groups describing access rights the user has.
| Field
|
Datatype
|
| user_id |
int(10) unsigned
|
| user_name |
varchar(255)
|
| user_real_name |
varchar(255)
|
| user_password |
tinyblob
|
| user_newpassword |
tinyblob
|
| user_newpass_time |
binary(14)
|
| user_email |
tinytext
|
| user_options |
blob
|
| user_touched |
binary(14)
|
| user_token |
binary(32)
|
| user_email_authenticated |
binary(14)
|
| user_email_token |
binary(32)
|
| user_email_token_expires |
binary(14)
|
| user_registration |
binary(14)
|
| user_editcount |
int(11)
|
