| Field | Description | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|---|
| channel_id | int(10) unsigned | NO | PRI | NULL | auto_increment | |
| channel_account_id | int(10) unsigned | NO | MUL | 0 | ||
| channel_primary | tinyint(1) unsigned | NO | MUL | 0 | ||
| channel_name | char(255) | NO | MUL | |||
| channel_address | char(255) | NO | UNI | |||
| channel_guid | char(255) | NO | MUL | |||
| channel_guid_sig | text | NO | NULL | |||
| channel_hash | char(255) | NO | MUL | |||
| channel_timezone | char(128) | NO | MUL | UTC | ||
| channel_location | char(255) | NO | MUL | |||
| channel_theme | char(255) | NO | MUL | |||
| channel_startpage | char(255) | NO | ||||
| channel_pubkey | text | NO | NULL | |||
| channel_prvkey | text | NO | NULL | |||
| channel_notifyflags | int(10) unsigned | NO | MUL | 65535 | ||
| channel_pageflags | int(10) unsigned | NO | MUL | 0 | ||
| channel_dirdate | datetime | NO | MUL | 0000-00-00 00:00:00 | ||
| channel_deleted | datetime | NO | MUL | 0000-00-00 00:00:00 | ||
| channel_max_anon_mail | int(10) unsigned | NO | MUL | 10 | ||
| channel_max_friend_req | int(10) unsigned | NO | MUL | 10 | ||
| channel_expire_days | int(11) | NO | MUL | 0 | ||
| channel_passwd_reset | char(255) | NO | ||||
| channel_default_group | char(255) | NO | MUL | |||
| channel_allow_cid | mediumtext | NO | NULL | |||
| channel_allow_gid | mediumtext | NO | NULL | |||
| channel_deny_cid | mediumtext | NO | NULL | |||
| channel_deny_gid | mediumtext | NO | NULL | |||
| channel_r_stream | int(10) unsigned | NO | MUL | 128 | ||
| channel_r_profile | int(10) unsigned | NO | MUL | 128 | ||
| channel_r_photos | int(10) unsigned | NO | MUL | 128 | ||
| channel_r_abook | int(10) unsigned | NO | MUL | 128 | ||
| channel_w_stream | int(10) unsigned | NO | MUL | 128 | ||
| channel_w_wall | int(10) unsigned | NO | MUL | 128 | ||
| channel_w_tagwall | int(10) unsigned | NO | MUL | 128 | ||
| channel_w_comment | int(10) unsigned | NO | MUL | 128 | ||
| channel_w_mail | int(10) unsigned | NO | MUL | 128 | ||
| channel_w_photos | int(10) unsigned | NO | MUL | 128 | ||
| channel_w_chat | int(10) unsigned | NO | MUL | 128 | ||
| channel_a_delegate | int(10) unsigned | NO | MUL | 0 | ||
| channel_r_storage | int(10) unsigned | NO | MUL | 128 | ||
| channel_w_storage | int(10) unsigned | NO | MUL | 128 | ||
| channel_r_pages | int(10) unsigned | NO | MUL | 128 | ||
| channel_w_pages | int(10) unsigned | NO | MUL | 128 | ||
| channel_a_republish | int(10) unsigned | NO | MUL | 128 | ||
| channel_w_like | int(10) unsigned | NO | MUL | 128 |
Return to database documentation