RequestWiki
From CharlieWiki
[edit] Schema
[edit] wiki_requests
| Name | Type | Description |
|---|---|---|
| id | INT | |
| requester_id | INT | Key to user.id of the requester |
| status | INT | ID of the status of the request |
| private | BOOL | Is the request private? |
| name | VARCHAR | Human-friendly name (Site name) |
| short_name | VARCHAR | Internal name, used in subdomain |
| reason | TEXT | What will the wiki be used for? |
[edit] wiki_request_comments
| Name | Type | Description |
|---|---|---|
| id | INT | |
| user | INT | Key to user.id of the comment poster |
| user_text | VARCHAR | Cache of the user's name |
| request_id | INT | Key to the wiki_requests.id of the request |
| timestamp | binary(14) | Timestamp of when the comment was posted |
| text | TEXT | Body of the comment |
