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

DB anchor.png

Page Top
os_groups_groups anchor.png
MariaDB [jogrid_db]> show columns from os_groups_groups;
+----------------+--------------+------+-----+---------+-------+
| Field          | Type         | Null | Key | Default | Extra |
+----------------+--------------+------+-----+---------+-------+
| GroupID        | char(36)     | NO   | PRI |         |       |
| Location       | varchar(255) | NO   |     |         |       |
| Name           | varchar(255) | NO   | UNI |         |       |
| Charter        | text         | NO   |     | NULL    |       |
| InsigniaID     | char(36)     | NO   |     |         |       |
| FounderID      | char(36)     | NO   |     |         |       |
| MembershipFee  | int(11)      | NO   |     | 0       |       |
| OpenEnrollment | varchar(255) | NO   |     |         |       |
| ShowInList     | int(4)       | NO   |     | 0       |       |
| AllowPublish   | int(4)       | NO   |     | 0       |       |
| MaturePublish  | int(4)       | NO   |     | 0       |       |
| OwnerRoleID    | char(36)     | NO   |     |         |       |
+----------------+--------------+------+-----+---------+-------+
12 rows in set (0.00 sec)
Page Top
os_groups_invites anchor.png
MariaDB [jogrid_db]> show columns from os_groups_invites;
+-------------+--------------+------+-----+-------------------+-----------------------------+
| Field       | Type         | Null | Key | Default           | Extra                       |
+-------------+--------------+------+-----+-------------------+-----------------------------+
| InviteID    | char(36)     | NO   | PRI |                   |                             |
| GroupID     | char(36)     | NO   | MUL |                   |                             |
| RoleID      | char(36)     | NO   |     |                   |                             |
| PrincipalID | varchar(255) | NO   |     |                   |                             |
| TMStamp     | timestamp    | NO   |     | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
+-------------+--------------+------+-----+-------------------+-----------------------------+
5 rows in set (0.00 sec)
Page Top
os_groups_membership anchor.png
MariaDB [jogrid_db]> show columns from os_groups_membership;
+----------------+--------------+------+-----+---------+-------+
| Field          | Type         | Null | Key | Default | Extra |
+----------------+--------------+------+-----+---------+-------+
| GroupID        | char(36)     | NO   | PRI |         |       |
| PrincipalID    | varchar(255) | NO   | PRI |         |       |
| SelectedRoleID | char(36)     | NO   |     |         |       |
| Contribution   | int(11)      | NO   |     | 0       |       |
| ListInProfile  | int(4)       | NO   |     | 1       |       |
| AcceptNotices  | int(4)       | NO   |     | 1       |       |
| AccessToken    | char(36)     | NO   |     |         |       |
+----------------+--------------+------+-----+---------+-------+
7 rows in set (0.00 sec)
Page Top
os_groups_notices anchor.png
MariaDB [jogrid_db]> show columns from os_groups_notices;
+-------------------+------------------+------+-----+---------+-------+
| Field             | Type             | Null | Key | Default | Extra |
+-------------------+------------------+------+-----+---------+-------+
| GroupID           | char(36)         | NO   | MUL |         |       |
| NoticeID          | char(36)         | NO   | PRI |         |       |
| TMStamp           | int(10) unsigned | NO   | MUL | 0       |       |
| FromName          | varchar(255)     | NO   |     |         |       |
| Subject           | varchar(255)     | NO   |     |         |       |
| Message           | text             | NO   |     | NULL    |       |
| HasAttachment     | int(4)           | NO   |     | 0       |       |
| AttachmentType    | int(4)           | NO   |     | 0       |       |
| AttachmentName    | varchar(128)     | NO   |     |         |       |
| AttachmentItemID  | char(36)         | NO   |     |         |       |
| AttachmentOwnerID | varchar(255)     | NO   |     |         |       |
+-------------------+------------------+------+-----+---------+-------+
11 rows in set (0.00 sec)
Page Top
os_groups_principals anchor.png
MariaDB [jogrid_db]> show columns from os_groups_principals;
+---------------+--------------+------+-----+---------+-------+
| Field         | Type         | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+-------+
| PrincipalID   | varchar(255) | NO   | PRI |         |       |
| ActiveGroupID | char(36)     | NO   |     |         |       |
+---------------+--------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
Page Top
os_groups_rolemembership anchor.png
MariaDB [jogrid_db]> show columns from os_groups_rolemembership;
+-------------+--------------+------+-----+---------+-------+
| Field       | Type         | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+-------+
| GroupID     | char(36)     | NO   | PRI |         |       |
| RoleID      | char(36)     | NO   | PRI |         |       |
| PrincipalID | varchar(255) | NO   | PRI |         |       |
+-------------+--------------+------+-----+---------+-------+
3 rows in set (0.02 sec)
Page Top
os_groups_roles; anchor.png
MariaDB [jogrid_db]> show columns from os_groups_roles;
+-------------+---------------------+------+-----+---------+-------+
| Field       | Type                | Null | Key | Default | Extra |
+-------------+---------------------+------+-----+---------+-------+
| GroupID     | char(36)            | NO   | PRI |         |       |
| RoleID      | char(36)            | NO   | PRI |         |       |
| Name        | varchar(255)        | NO   |     |         |       |
| Description | varchar(255)        | NO   |     |         |       |
| Title       | varchar(255)        | NO   |     |         |       |
| Powers      | bigint(20) unsigned | NO   |     | 0       |       |
+-------------+---------------------+------+-----+---------+-------+
6 rows in set (0.00 sec)

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

サイト内 検索

ログイン

ユーザー名:

パスワード:


パスワード紛失
新規登録

サブ メニュー

ミニカレンダー

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

オンライン状況

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

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

もっと...

アクセスカウンタ

今日 : 1356135613561356
昨日 : 7844784478447844
総計 : 2368522023685220236852202368522023685220236852202368522023685220
Powered by XOOPS Cube 2.1© 2001-2006 XOOPS Cube Project
Design by XoopsDesign.com