Inhalt
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