Task:Single sign-on/Account info stored in ldap

(Add garage info)
(bugs.maemo.org)
 
(4 intermediate revisions not shown)
Line 17: Line 17:
|-
|-
| wiki.maemo.org || Mediawiki
| wiki.maemo.org || Mediawiki
 +
|}
 +
 +
=== maemo.org ===
 +
{| class="wikitable sortable"
 +
|-
 +
! 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)
|}
|}
Line 51: Line 80:
| ccode || char(2)
| ccode || char(2)
|}
|}
 +
 +
=== Talk ===
 +
{| class="wikitable sortable"
 +
|-
 +
! 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 ===
 +
{| class="wikitable sortable"
 +
|-
 +
! 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.
 +
 +
{| class="wikitable sortable"
 +
|-
 +
! 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)
 +
|}
 +
 +
[[Category:Tasks]]

Latest revision as of 12:42, 16 September 2010

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.

Contents

[edit] Services

Service Framework
maemo.org Midgard
garage.maemo.org G-Forge
bugs.maemo.org Bugzilla
talk.maemo.org vBulletin
wiki.maemo.org Mediawiki

[edit] 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)

[edit] 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)

[edit] 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)

[edit] 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)

[edit] 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)