group_active 
MariaDB [opensim_op]> show columns from group_active; +---------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+---------+-------+ | agentid | varchar(64) | NO | PRI | | | | activegroupid | varchar(64) | NO | | | | +---------------+-------------+------+-----+---------+-------+ 2 rows in set (0.00 sec)
- os_groups_principals に相当
group_invite 
MariaDB [opensim_op]> show columns from group_invite;
+----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+-------+ | inviteid | varchar(64) | NO | PRI | | | | groupid | varchar(64) | NO | MUL | | | | roleid | varchar(64) | YES | | NULL | | | agentid | varchar(64) | NO | | | | | tmstamp | bigint(11) | NO | | NULL | | +----------+-------------+------+-----+------- 5 rows in set (0.00 sec)
group_list 
MariaDB [opensim_op]> show columns from group_list; +----------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------------+------+-----+---------+-------+ | groupid | varchar(64) | NO | PRI | | | | name | varchar(255) | NO | UNI | | | | charter | longtext | NO | | NULL | | | insigniaid | varchar(64) | NO | | | | | founderid | varchar(64) | NO | | | | | membershipfee | bigint(11) | NO | | 0 | | | openenrollment | varchar(255) | NO | | | | | showinlist | tinyint(1) | NO | | 0 | | | allowpublish | tinyint(1) | NO | | 0 | | | maturepublish | tinyint(1) | NO | | 0 | | | ownerroleid | varchar(128) | NO | | | | +----------------+--------------+------+-----+---------+-------+ 11 rows in set (0.00 sec)
group_membership 
MariaDB [opensim_op]> show columns from group_membership; +----------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+---------+-------+ | groupid | varchar(64) | NO | PRI | | | | agentid | varchar(64) | NO | PRI | | | | selectedroleid | varchar(64) | NO | | | | | contribution | bigint(11) | NO | | 0 | | | listinprofile | bigint(11) | NO | | 1 | | | acceptnotices | bigint(11) | NO | | 1 | | +----------------+-------------+------+-----+---------+-------+ 6 rows in set (0.00 sec)
group_notice 
MariaDB [opensim_op]> show columns from group_notice; +--------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+---------+-------+ | groupid | varchar(64) | NO | PRI | | | | noticeid | varchar(64) | NO | PRI | | | | timestamp | bigint(11) | NO | MUL | 0 | | | fromname | varchar(255) | NO | | | | | subject | varchar(255) | NO | | | | | message | longtext | NO | | NULL | | | binarybucket | longblob | NO | | NULL | | +--------------+--------------+------+-----+---------+-------+ 7 rows in set (0.00 sec)
group_role 
MariaDB [opensim_op]> show columns from group_role; +-------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+-------+ | groupid | varchar(64) | NO | PRI | | | | roleid | varchar(64) | NO | PRI | | | | name | varchar(255) | NO | | | | | description | varchar(255) | NO | | | | | title | varchar(255) | NO | | | | | powers | bigint(20) | NO | | 0 | | +-------------+--------------+------+-----+---------+-------+ 6 rows in set (0.00 sec)
group_rolemembership 
MariaDB [opensim_op]> show columns from group_rolemembership; +---------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+-------------+------+-----+---------+-------+ | groupid | varchar(64) | NO | PRI | | | | roleid | varchar(64) | NO | PRI | | | | agentid | varchar(64) | NO | PRI | | | +---------+-------------+------+-----+---------+-------+ 3 rows in set (0.00 sec)
Counter: 1251,
today: 1,
yesterday: 0
最終更新: 2016-07-20 (水) 16:58:41 (JST) (3132d) by iseki