Dashboard > Penrose > Use Cases > Confluence
Confluence
Added by Jim Yang, last edited by Jim Yang on Nov 05, 2007  (view change)
Labels: 
(None)


Tables Listing in Confluence

mysql> show tables;
+----------------------+
| Tables_in_confluence |
+----------------------+
| ATTACHMENTDATA       |
| ATTACHMENTS          |
| BANDANA              |
| BODYCONTENT          |
| CLUSTERSAFETY        |
| CONFANCESTORS        |
| CONFVERSION          |
| CONTENT              |
| CONTENTLOCK          |
| CONTENT_LABEL        |
| CONTENT_PERM         |
| CONTENT_PERM_SET     |
| DECORATOR            |
| DRAFT                |
| EXTRNLNKS            |
| INDEXQUEUEENTRIES    |
| LABEL                |
| LINKS                |
| NOTIFICATIONS        |
| OS_PROPERTYENTRY     |
| PAGETEMPLATES        |
| PLUGINDATA           |
| SPACEGROUPS          |
| SPACEPERMISSIONS     |
| SPACES               |
| TRACKBACKLINKS       |
| external_entities    |
| external_members     |
| groups               |
| hibernate_unique_key |
| local_members        |
| os_group             |
| os_user              |
| os_user_group        |
| users                |
+----------------------+

How Confluence Stores Its Users and Groups

Confluence stores its users and groups information in four tables, namely users, os_user, os_group and os_user_group.

mysql> describe users;
+----------+--------------+------+-----+---------+-------+
| Field    | Type         | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+-------+
| id       | bigint(20)   |      | PRI | 0       |       |
| name     | varchar(255) |      |     |         |       |
| password | varchar(255) | YES  |     | NULL    |       |
| email    | varchar(255) | YES  |     | NULL    |       |
| created  | datetime     | YES  |     | NULL    |       |
| fullname | varchar(255) | YES  |     | NULL    |       |
+----------+--------------+------+-----+---------+-------+
mysql> describe os_group;
+-----------+--------------+------+-----+---------+-------+
| Field     | Type         | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+-------+
| id        | bigint(20)   |      | PRI | 0       |       |
| groupname | varchar(255) |      | UNI |         |       |
+-----------+--------------+------+-----+---------+-------+
mysql> describe os_user; 
+----------+--------------+------+-----+---------+-------+
| Field    | Type         | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+-------+
| id       | bigint(20)   |      | PRI | 0       |       |
| username | varchar(255) |      | UNI |         |       |
| passwd   | varchar(255) | YES  |     | NULL    |       |
+----------+--------------+------+-----+---------+-------+
mysql> describe os_user_group;
+----------+------------+------+-----+---------+-------+
| Field    | Type       | Null | Key | Default | Extra |
+----------+------------+------+-----+---------+-------+
| group_id | bigint(20) |      | PRI | 0       |       |
| user_id  | bigint(20) |      | PRI | 0       |       |
+----------+------------+------+-----+---------+-------+

Reference

Site running on a free Atlassian Confluence Open Source Project License granted to Safehaus. Evaluate Confluence today.
Powered by Atlassian Confluence, the Enterprise Wiki. (Version: 2.5.4 Build:#809 Jun 12, 2007) - Bug/feature request - Contact Administrators