flagflag  If you want to see English page, please click "English" Button at Left.
Page Top

DB anchor.png

Page Top
group_active anchor.png
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 に相当
     
Page Top
group_invite anchor.png

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)
Page Top
group_list anchor.png
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)
Page Top
group_membership anchor.png
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)
Page Top
group_notice anchor.png
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)
Page Top
group_role anchor.png
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)
Page Top
group_rolemembership anchor.png
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)

トップ   凍結 差分 バックアップ 複製 名前変更 リロード   新規 ページ一覧 単語検索 最終更新   ヘルプ   最終更新のRSS 1.0 最終更新のRSS 2.0 最終更新のRSS Atom
Counter: 1168, today: 1, yesterday: 1
最終更新: 2016-07-20 (水) 16:58:41 (JST) (2890d) by iseki

サイト内 検索

ログイン

ユーザー名:

パスワード:


パスワード紛失
新規登録

サブ メニュー

ミニカレンダー

前月2024年 6月翌月
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
<今日>

オンライン状況

54 人のユーザが現在オンラインです。 (6 人のユーザが xpwiki を参照しています。)

登録ユーザ: 0
ゲスト: 54

もっと...

アクセスカウンタ

今日 : 4813481348134813
昨日 : 9225922592259225
総計 : 2384711723847117238471172384711723847117238471172384711723847117
Powered by XOOPS Cube 2.1© 2001-2006 XOOPS Cube Project
Design by XoopsDesign.com