|
1: 2016-07-20 (水) 16:08:06 iseki |
| + | ** OpenProfile for OpenSim [#ra0d1a6b] |
| + | *** DB [#n8639779] |
| + | **** profile_classifieds [#gaf6de43] |
| + | MariaDB [opensim_op]> show columns from profile_classifieds; |
| + | +-----------------+--------------+------+-----+---------+-------+ |
| + | | Field | Type | Null | Key | Default | Extra | |
| + | +-----------------+--------------+------+-----+---------+-------+ |
| + | | 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 [#saa08676] |
| + | MariaDB [opensim_op]> show columns from profile_usernotes; |
| + | +------------+-------------+------+-----+---------+-------+ |
| + | | Field | Type | Null | Key | Default | Extra | |
| + | +------------+-------------+------+-----+---------+-------+ |
| + | | useruuid | varchar(36) | NO | PRI | | | |
| + | | targetuuid | varchar(36) | NO | PRI | | | |
| + | | notes | longtext | NO | | NULL | | |
| + | +------------+-------------+------+-----+---------+-------+ |
| + | 3 rows in set (0.00 sec) |