Contents
| Field | Description | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|---|
| cr_id | sequential ID | int(10) unsigned | NO | PRI | NULL | auto_increment |
| cr_aid | account.id of chatroom owner | int(10) unsigned | NO | MUL | 0 | |
| cr_uid | channel.channel_id of chatroom owner | int(10) unsigned | NO | MUL | 0 | |
| cr_name | visible name of chatroom | char(255) | NO | MUL | ||
| cr_created | creation timestampe | datetime | NO | MUL | 0000-00-00 00:00:00 | |
| cr_edited | edited timestamp | datetime | NO | MUL | 0000-00-00 00:00:00 | |
| cr_expire | expiration period for chats in this chatroom in minutes, 0 is no expiration | int(10) unsigned | NO | MUL | 0 | |
| allow_cid | permissions for this room | mediumtext | NO | NULL | ||
| allow_gid | permissions for this room | mediumtext | NO | NULL | ||
| deny_cid | permissions for this room | mediumtext | NO | NULL | ||
| deny_gid | permissions for this room | mediumtext | NO | NULL |
Return to database documentation