flagflag  
Page Top

DB anchor.png

Page Top
classifieds anchor.png
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)
Page Top
userdata anchor.png
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)
Page Top
usernotes anchor.png
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)
Page Top
userpicks anchor.png
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)
Page Top
userprofile anchor.png
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)
Page Top
usersettings anchor.png
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)

Front page   Freeze Diff Backup Copy Rename Reload   New List of Pages Search Recent changes   Help   RSS of recent changes (RSS 1.0) RSS of recent changes (RSS 2.0) RSS of recent changes (RSS Atom)
Counter: 1281, today: 1, yesterday: 1
Last-modified: 2016-08-08 (Mon) 10:46:51 (JST) (3249d) by iseki

Site Search

Login

Username:

Password:


Lost Password?
Register now!!

Sub Menu

mini Calendar

Last MonthJul 2025Next Month
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

123 user(s) are online (7 user(s) are browsing xpwiki)

Members: 0
Guests: 123

more...

Access Counter

Today : 1445714457144571445714457
Yesterday : 2172621726217262172621726
Total : 2734463527344635273446352734463527344635273446352734463527344635
Powered by XOOPS Cube 2.1© 2001-2006 XOOPS Cube Project
Design by XoopsDesign.com