Home
News
Forum
Wiki
Blog
Contents
Gallery
Movies
Downloads
About NSL
[
List of Titles
|
List of Pages
|
New
|
Search
|
Recent changes
|
Help
]
OpenSim/UserProfile
[
Front page
]
[ ]
Start:
** UserProfile Module
*** DB
**** classifieds
mysql> show columns from classifieds;
+-----------------+--------------+------+-----+---------...
| Field | Type | Null | Key | Default ...
+-----------------+--------------+------+-----+---------...
| 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
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
mysql> show columns from usernotes ;
+------------+-------------+------+-----+---------+-----...
| Field | Type | Null | Key | Default | Extr...
+------------+-------------+------+-----+---------+-----...
| useruuid | varchar(36) | NO | PRI | NULL | ...
| targetuuid | varchar(36) | NO | PRI | NULL | ...
| notes | text | NO | | NULL | ...
+------------+-------------+------+-----+---------+-----...
3 rows in set (0.00 sec)
**** userpicks
mysql> show columns from userpicks;
+--------------+----------------------+------+-----+----...
| Field | Type | Null | Key | Def...
+--------------+----------------------+------+-----+----...
| pickuuid | varchar(36) | NO | PRI | NUL...
| creatoruuid | varchar(36) | NO | | NUL...
| toppick | enum('true','false') | NO | | NUL...
| parceluuid | varchar(36) | NO | | NUL...
| name | varchar(255) | NO | | NUL...
| description | text | NO | | NUL...
| snapshotuuid | varchar(36) | NO | | NUL...
| user | varchar(255) | NO | | NUL...
| originalname | varchar(255) | NO | | NUL...
| simname | varchar(255) | NO | | NUL...
| posglobal | varchar(255) | NO | | NUL...
| sortorder | int(2) | NO | | NUL...
| enabled | enum('true','false') | NO | | NUL...
| gatekeeper | varchar(255) | YES | | NUL...
+--------------+----------------------+------+-----+----...
14 rows in set (0.00 sec)
**** userprofile
mysql> show columns from userprofile ;
+----------------------+--------------+------+-----+----...
| Field | Type | Null | Key | Def...
+----------------------+--------------+------+-----+----...
| useruuid | varchar(36) | NO | PRI | NUL...
| profilePartner | varchar(36) | NO | | NUL...
| profileAllowPublish | binary(1) | NO | | NUL...
| profileMaturePublish | binary(1) | NO | | NUL...
| profileURL | varchar(255) | NO | | NUL...
| profileWantToMask | int(3) | NO | | NUL...
| profileWantToText | text | NO | | NUL...
| profileSkillsMask | int(3) | NO | | NUL...
| profileSkillsText | text | NO | | NUL...
| profileLanguages | text | NO | | NUL...
| profileImage | varchar(36) | NO | | NUL...
| profileAboutText | text | NO | | NUL...
| profileFirstImage | varchar(36) | NO | | NUL...
| profileFirstText | text | NO | | NUL...
+----------------------+--------------+------+-----+----...
14 rows in set (0.00 sec)
**** usersettings
mysql> show columns from usersettings;
+------------+----------------------+------+-----+------...
| Field | Type | Null | Key | Defau...
+------------+----------------------+------+-----+------...
| 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)
End:
** UserProfile Module
*** DB
**** classifieds
mysql> show columns from classifieds;
+-----------------+--------------+------+-----+---------...
| Field | Type | Null | Key | Default ...
+-----------------+--------------+------+-----+---------...
| 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
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
mysql> show columns from usernotes ;
+------------+-------------+------+-----+---------+-----...
| Field | Type | Null | Key | Default | Extr...
+------------+-------------+------+-----+---------+-----...
| useruuid | varchar(36) | NO | PRI | NULL | ...
| targetuuid | varchar(36) | NO | PRI | NULL | ...
| notes | text | NO | | NULL | ...
+------------+-------------+------+-----+---------+-----...
3 rows in set (0.00 sec)
**** userpicks
mysql> show columns from userpicks;
+--------------+----------------------+------+-----+----...
| Field | Type | Null | Key | Def...
+--------------+----------------------+------+-----+----...
| pickuuid | varchar(36) | NO | PRI | NUL...
| creatoruuid | varchar(36) | NO | | NUL...
| toppick | enum('true','false') | NO | | NUL...
| parceluuid | varchar(36) | NO | | NUL...
| name | varchar(255) | NO | | NUL...
| description | text | NO | | NUL...
| snapshotuuid | varchar(36) | NO | | NUL...
| user | varchar(255) | NO | | NUL...
| originalname | varchar(255) | NO | | NUL...
| simname | varchar(255) | NO | | NUL...
| posglobal | varchar(255) | NO | | NUL...
| sortorder | int(2) | NO | | NUL...
| enabled | enum('true','false') | NO | | NUL...
| gatekeeper | varchar(255) | YES | | NUL...
+--------------+----------------------+------+-----+----...
14 rows in set (0.00 sec)
**** userprofile
mysql> show columns from userprofile ;
+----------------------+--------------+------+-----+----...
| Field | Type | Null | Key | Def...
+----------------------+--------------+------+-----+----...
| useruuid | varchar(36) | NO | PRI | NUL...
| profilePartner | varchar(36) | NO | | NUL...
| profileAllowPublish | binary(1) | NO | | NUL...
| profileMaturePublish | binary(1) | NO | | NUL...
| profileURL | varchar(255) | NO | | NUL...
| profileWantToMask | int(3) | NO | | NUL...
| profileWantToText | text | NO | | NUL...
| profileSkillsMask | int(3) | NO | | NUL...
| profileSkillsText | text | NO | | NUL...
| profileLanguages | text | NO | | NUL...
| profileImage | varchar(36) | NO | | NUL...
| profileAboutText | text | NO | | NUL...
| profileFirstImage | varchar(36) | NO | | NUL...
| profileFirstText | text | NO | | NUL...
+----------------------+--------------+------+-----+----...
14 rows in set (0.00 sec)
**** usersettings
mysql> show columns from usersettings;
+------------+----------------------+------+-----+------...
| Field | Type | Null | Key | Defau...
+------------+----------------------+------+-----+------...
| 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)
Page:
Site Search
Advanced Search
Login
Username:
Password:
Lost Password?
Register now!!
Sub Menu
New Arrivals
Books
Web Links
Site Map
e-Learning
TUIS Certificate
mini Calendar
May 2025
Su
Mo
Tu
We
Th
Fr
Sa
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Today
Who's Online
72 user(s) are online (7 user(s) are browsing xpwiki)
Members: 0
Guests: 72
more...
Access Counter
Today :
Yesterday :
Total :
Powered by XOOPS Cube 2.1© 2001-2006
XOOPS Cube Project
Design by
XoopsDesign.com