Home
News
Forum
Wiki
Blog
Contents
Gallery
Movies
Downloads
About NSL
[
List of Titles
|
List of Pages
|
New
|
Search
|
Recent changes
|
Help
]
OpenSim/OpenProfile
[
Front page
]
[ ]
Start:
** OpenProfile for OpenSim
*** DB
**** profile_classifieds
MariaDB [opensim_op]> show columns from profile_classifi...
+-----------------+--------------+------+-----+---------...
| Field | Type | Null | Key | Default ...
+-----------------+--------------+------+-----+---------...
| classifieduuid | varchar(36) | NO | PRI | ...
| creatoruuid | varchar(36) | NO | | ...
| creationdate | bigint(20) | NO | | NULL ...
| expirationdate | bigint(20) | NO | | NULL ...
| category | varchar(20) | NO | | ...
| name | varchar(255) | NO | | ...
| description | longtext | NO | | NULL ...
| parceluuid | varchar(36) | NO | | ...
| parentestate | bigint(11) | NO | | NULL ...
| snapshotuuid | varchar(36) | NO | | ...
| simname | varchar(255) | NO | | ...
| posglobal | varchar(255) | NO | | ...
| parcelname | varchar(255) | NO | | ...
| classifiedflags | int(8) | NO | | NULL ...
| priceforlisting | mediumint(5) | NO | | NULL ...
+-----------------+--------------+------+-----+---------...
15 rows in set (0.01 sec)
**** profile_usernotes
MariaDB [opensim_op]> show columns from profile_usernotes;
+------------+-------------+------+-----+---------+-----...
| Field | Type | Null | Key | Default | Extr...
+------------+-------------+------+-----+---------+-----...
| useruuid | varchar(36) | NO | PRI | | ...
| targetuuid | varchar(36) | NO | PRI | | ...
| notes | longtext | NO | | NULL | ...
+------------+-------------+------+-----+---------+-----...
3 rows in set (0.00 sec)
**** profile_userpicks
MariaDB [opensim_op]> show columns from profile_userpic...
+--------------+--------------+------+-----+---------+--...
| Field | Type | Null | Key | Default | E...
+--------------+--------------+------+-----+---------+--...
| pickuuid | varchar(36) | NO | PRI | | ...
| creatoruuid | varchar(36) | NO | | | ...
| toppick | varchar(6) | NO | | false | ...
| parceluuid | varchar(36) | NO | | | ...
| name | varchar(255) | NO | | | ...
| description | longtext | NO | | NULL | ...
| snapshotuuid | varchar(36) | NO | | | ...
| user | varchar(255) | NO | | | ...
| originalname | varchar(255) | NO | | | ...
| simname | varchar(255) | NO | | | ...
| posglobal | varchar(255) | NO | | | ...
| sortorder | tinyint(2) | NO | | NULL | ...
| enabled | varchar(6) | NO | | false | ...
+--------------+--------------+------+-----+---------+--...
13 rows in set (0.00 sec)
**** profile_userprofile
MariaDB [opensim_op]> show columns from profile_userprof...
+----------------------+--------------+------+-----+----...
| Field | Type | Null | Key | Def...
+----------------------+--------------+------+-----+----...
| useruuid | varchar(36) | NO | PRI | ...
| profilepartner | varchar(36) | NO | | ...
| profileimage | varchar(36) | NO | | ...
| profileabouttext | longtext | NO | | NUL...
| profileallowpublish | binary(1) | NO | | NUL...
| profilematurepublish | binary(1) | NO | | NUL...
| profileurl | varchar(255) | NO | | ...
| profilewanttomask | smallint(3) | NO | | NUL...
| profilewanttotext | longtext | NO | | NUL...
| profileskillsmask | smallint(3) | NO | | NUL...
| profileskillstext | longtext | NO | | NUL...
| profilelanguagestext | longtext | NO | | NUL...
| profilefirstimage | varchar(36) | NO | | ...
| profilefirsttext | longtext | NO | | NUL...
+----------------------+--------------+------+-----+----...
14 rows in set (0.00 sec)
**** profile_usersettings
MariaDB [opensim_op]> show columns from profile_usersett...
+------------+----------------------+------+-----+------...
| Field | Type | Null | Key | Defau...
+------------+----------------------+------+-----+------...
| useruuid | varchar(36) | NO | PRI | ...
| imviaemail | enum('true','false') | NO | | false...
| visible | enum('true','false') | NO | | true ...
| email | varchar(254) | NO | | ...
+------------+----------------------+------+-----+------...
4 rows in set (0.00 sec)
End:
** OpenProfile for OpenSim
*** DB
**** profile_classifieds
MariaDB [opensim_op]> show columns from profile_classifi...
+-----------------+--------------+------+-----+---------...
| Field | Type | Null | Key | Default ...
+-----------------+--------------+------+-----+---------...
| classifieduuid | varchar(36) | NO | PRI | ...
| creatoruuid | varchar(36) | NO | | ...
| creationdate | bigint(20) | NO | | NULL ...
| expirationdate | bigint(20) | NO | | NULL ...
| category | varchar(20) | NO | | ...
| name | varchar(255) | NO | | ...
| description | longtext | NO | | NULL ...
| parceluuid | varchar(36) | NO | | ...
| parentestate | bigint(11) | NO | | NULL ...
| snapshotuuid | varchar(36) | NO | | ...
| simname | varchar(255) | NO | | ...
| posglobal | varchar(255) | NO | | ...
| parcelname | varchar(255) | NO | | ...
| classifiedflags | int(8) | NO | | NULL ...
| priceforlisting | mediumint(5) | NO | | NULL ...
+-----------------+--------------+------+-----+---------...
15 rows in set (0.01 sec)
**** profile_usernotes
MariaDB [opensim_op]> show columns from profile_usernotes;
+------------+-------------+------+-----+---------+-----...
| Field | Type | Null | Key | Default | Extr...
+------------+-------------+------+-----+---------+-----...
| useruuid | varchar(36) | NO | PRI | | ...
| targetuuid | varchar(36) | NO | PRI | | ...
| notes | longtext | NO | | NULL | ...
+------------+-------------+------+-----+---------+-----...
3 rows in set (0.00 sec)
**** profile_userpicks
MariaDB [opensim_op]> show columns from profile_userpic...
+--------------+--------------+------+-----+---------+--...
| Field | Type | Null | Key | Default | E...
+--------------+--------------+------+-----+---------+--...
| pickuuid | varchar(36) | NO | PRI | | ...
| creatoruuid | varchar(36) | NO | | | ...
| toppick | varchar(6) | NO | | false | ...
| parceluuid | varchar(36) | NO | | | ...
| name | varchar(255) | NO | | | ...
| description | longtext | NO | | NULL | ...
| snapshotuuid | varchar(36) | NO | | | ...
| user | varchar(255) | NO | | | ...
| originalname | varchar(255) | NO | | | ...
| simname | varchar(255) | NO | | | ...
| posglobal | varchar(255) | NO | | | ...
| sortorder | tinyint(2) | NO | | NULL | ...
| enabled | varchar(6) | NO | | false | ...
+--------------+--------------+------+-----+---------+--...
13 rows in set (0.00 sec)
**** profile_userprofile
MariaDB [opensim_op]> show columns from profile_userprof...
+----------------------+--------------+------+-----+----...
| Field | Type | Null | Key | Def...
+----------------------+--------------+------+-----+----...
| useruuid | varchar(36) | NO | PRI | ...
| profilepartner | varchar(36) | NO | | ...
| profileimage | varchar(36) | NO | | ...
| profileabouttext | longtext | NO | | NUL...
| profileallowpublish | binary(1) | NO | | NUL...
| profilematurepublish | binary(1) | NO | | NUL...
| profileurl | varchar(255) | NO | | ...
| profilewanttomask | smallint(3) | NO | | NUL...
| profilewanttotext | longtext | NO | | NUL...
| profileskillsmask | smallint(3) | NO | | NUL...
| profileskillstext | longtext | NO | | NUL...
| profilelanguagestext | longtext | NO | | NUL...
| profilefirstimage | varchar(36) | NO | | ...
| profilefirsttext | longtext | NO | | NUL...
+----------------------+--------------+------+-----+----...
14 rows in set (0.00 sec)
**** profile_usersettings
MariaDB [opensim_op]> show columns from profile_usersett...
+------------+----------------------+------+-----+------...
| Field | Type | Null | Key | Defau...
+------------+----------------------+------+-----+------...
| useruuid | varchar(36) | NO | PRI | ...
| imviaemail | enum('true','false') | NO | | false...
| visible | enum('true','false') | NO | | true ...
| email | varchar(254) | NO | | ...
+------------+----------------------+------+-----+------...
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
104 user(s) are online (16 user(s) are browsing xpwiki)
Members: 0
Guests: 104
more...
Access Counter
Today :
Yesterday :
Total :
Powered by XOOPS Cube 2.1© 2001-2006
XOOPS Cube Project
Design by
XoopsDesign.com