Network System Laboratory - Source of OpenSim/UserProfile

View the diff.
Go to OpenSim/UserProfile.
** UserProfile Module [#z55da6e4]

*** DB [#k7dfac55]
**** classifieds [#haaefa8a]
 mysql> show columns from classifieds;
 +-----------------+--------------+------+-----+---------+-------+
 | Field           | Type         | Null | Key | Default | Extra |
 +-----------------+--------------+------+-----+---------+-------+
 | classifieduuid  | char(36)     | NO   | PRI | NULL    |       |
 | creatoruuid     | char(36)     | NO   |     | NULL    |       |
 | creationdate    | int(20)      | NO   |     | NULL    |       |
 | expirationdate  | int(20)      | NO   |     | NULL    |       |
 | category        | varchar(20)  | NO   |     | NULL    |       |
 | name            | varchar(255) | NO   |     | NULL    |       |
 | description     | text         | NO   |     | NULL    |       |
 | parceluuid      | char(36)     | NO   |     | NULL    |       |
 | parentestate    | int(11)      | NO   |     | NULL    |       |
 | snapshotuuid    | char(36)     | NO   |     | NULL    |       |
 | simname         | varchar(255) | NO   |     | NULL    |       |
 | posglobal       | varchar(255) | NO   |     | NULL    |       |
 | parcelname      | varchar(255) | NO   |     | NULL    |       |
 | classifiedflags | int(8)       | NO   |     | NULL    |       |
 | priceforlisting | int(5)       | NO   |     | NULL    |       |
 +-----------------+--------------+------+-----+---------+-------+
 15 rows in set (0.00 sec)
**** userdata [#t23838ca]
 mysql> show columns from userdata;
 +---------+--------------+------+-----+---------+-------+
 | Field   | Type         | Null | Key | Default | Extra |
 +---------+--------------+------+-----+---------+-------+
 | UserId  | char(36)     | NO   | PRI | NULL    |       |
 | TagId   | varchar(64)  | NO   | PRI | NULL    |       |
 | DataKey | varchar(255) | YES  |     | NULL    |       |
 | DataVal | varchar(255) | YES  |     | NULL    |       |
 +---------+--------------+------+-----+---------+-------+
 4 rows in set (0.00 sec)
**** usernotes [#u4b91612]
 mysql> show columns from usernotes ;
 +------------+-------------+------+-----+---------+-------+
 | Field      | Type        | Null | Key | Default | Extra |
 +------------+-------------+------+-----+---------+-------+
 | useruuid   | varchar(36) | NO   | PRI | NULL    |       |
 | targetuuid | varchar(36) | NO   | PRI | NULL    |       |
 | notes      | text        | NO   |     | NULL    |       |
 +------------+-------------+------+-----+---------+-------+
 3 rows in set (0.00 sec)

**** userpicks [#q836110a]
 mysql> show columns from userpicks;
 +--------------+----------------------+------+-----+---------+-------+
 | Field        | Type                 | Null | Key | Default | Extra |
 +--------------+----------------------+------+-----+---------+-------+
 | pickuuid     | varchar(36)          | NO   | PRI | NULL    |       |
 | creatoruuid  | varchar(36)          | NO   |     | NULL    |       |
 | toppick      | enum('true','false') | NO   |     | NULL    |       |
 | parceluuid   | varchar(36)          | NO   |     | NULL    |       |
 | name         | varchar(255)         | NO   |     | NULL    |       |
 | description  | text                 | NO   |     | NULL    |       |
 | snapshotuuid | varchar(36)          | NO   |     | NULL    |       |
 | user         | varchar(255)         | NO   |     | NULL    |       |
 | originalname | varchar(255)         | NO   |     | NULL    |       |
 | simname      | varchar(255)         | NO   |     | NULL    |       |
 | posglobal    | varchar(255)         | NO   |     | NULL    |       |
 | sortorder    | int(2)               | NO   |     | NULL    |       |
 | enabled      | enum('true','false') | NO   |     | NULL    |       |
 | gatekeeper   | varchar(255)         | YES  |     | NULL    |       |
 +--------------+----------------------+------+-----+---------+-------+
 14 rows in set (0.00 sec)
**** userprofile [#f4a0f5a2]
 mysql> show columns from userprofile ;
 +----------------------+--------------+------+-----+---------+-------+
 | Field                | Type         | Null | Key | Default | Extra |
 +----------------------+--------------+------+-----+---------+-------+
 | useruuid             | varchar(36)  | NO   | PRI | NULL    |       |
 | profilePartner       | varchar(36)  | NO   |     | NULL    |       |
 | profileAllowPublish  | binary(1)    | NO   |     | NULL    |       |
 | profileMaturePublish | binary(1)    | NO   |     | NULL    |       |
 | profileURL           | varchar(255) | NO   |     | NULL    |       |
 | profileWantToMask    | int(3)       | NO   |     | NULL    |       |
 | profileWantToText    | text         | NO   |     | NULL    |       |
 | profileSkillsMask    | int(3)       | NO   |     | NULL    |       |
 | profileSkillsText    | text         | NO   |     | NULL    |       |
 | profileLanguages     | text         | NO   |     | NULL    |       |
 | profileImage         | varchar(36)  | NO   |     | NULL    |       |
 | profileAboutText     | text         | NO   |     | NULL    |       |
 | profileFirstImage    | varchar(36)  | NO   |     | NULL    |       |
 | profileFirstText     | text         | NO   |     | NULL    |       |
 +----------------------+--------------+------+-----+---------+-------+
 14 rows in set (0.00 sec)
**** usersettings [#z2e7fe39]
 mysql> show columns from usersettings;
 +------------+----------------------+------+-----+---------+-------+
 | Field      | Type                 | Null | Key | Default | Extra |
 +------------+----------------------+------+-----+---------+-------+
 | useruuid   | varchar(36)          | NO   | PRI | NULL    |       |
 | imviaemail | enum('true','false') | NO   |     | NULL    |       |
 | visible    | enum('true','false') | NO   |     | NULL    |       |
 | email      | varchar(254)         | NO   |     | NULL    |       |
 +------------+----------------------+------+-----+---------+-------+
 4 rows in set (0.00 sec)
« Prev
Backup list of OpenSim/UserProfile
Backup source of OpenSim/UserProfile(No. All)
- 1: 2016-07-20 (Wed) 15:59:20 iseki
- 2: 2016-07-20 (Wed) 16:03:40 iseki
- Cur: 2016-08-08 (Mon) 10:46:51 iseki
Source of OpenSim/UserProfile

Site Search

Login

Sub Menu

Books

mini Calendar

Who's Online

Access Counter

Source of OpenSim​/UserProfile

Site Search

Login

Sub Menu

Books

mini Calendar

Who's Online

Access Counter

Source of OpenSim/UserProfile
