| Field | Description | Type | Null | Key | Default |
|---|
| channel_id | | int(10) unsigned | NO | PRI | NULL |
| channel_account_id | | int(10) unsigned | NO | MUL | 0 |
| channel_primary | | tinyint(1) unsigned | NO | MUL | 0 |
| channel_name | | char(191) | NO | MUL | |
| channel_address | | char(191) | NO | MUL | |
| channel_guid | | char(191) | NO | MUL | |
| channel_guid_sig | | text | NO | | |
| channel_hash | | char(191) | NO | MUL | |
| channel_portable_id | | char(191) | NO | MUL | |
| channel_timezone | | char(128) | NO | MUL | UTC |
| channel_location | | char(191) | NO | MUL | |
| channel_theme | | char(191) | NO | MUL | |
| channel_startpage | | char(191) | NO | | |
| channel_pubkey | | text | NO | | |
| channel_prvkey | | text | NO | | |
| channel_epubkey | | text | NO | | |
| channel_eprvkey | | text | NO | | |
| channel_notifyflags | | int(10) unsigned | NO | MUL | 65535 |
| channel_pageflags | | int(10) unsigned | NO | MUL | 0 |
| channel_dirdate | | datetime | NO | MUL | 0001-01-01 00:00:00 |
| channel_lastpost | | datetime | NO | MUL | 0001-01-01 00:00:00 |
| channel_deleted | | datetime | NO | MUL | 0001-01-01 00:00:00 |
| channel_active | | datetime | NO | MUL | 0001-01-01 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(191) | NO | | |
| channel_default_group | | char(191) | NO | MUL | |
| channel_allow_cid | | mediumtext | NO | | |
| channel_allow_gid | | mediumtext | NO | | |
| channel_deny_cid | | mediumtext | NO | | |
| channel_deny_gid | | mediumtext | NO | | |
| channel_removed | | tinyint(1) | NO | MUL | 0 |
| channel_system | | tinyint(1) | NO | MUL | 0 |
| channel_moved | | char(191) | NO | MUL | |
| channel_password | | varchar(191) | NO | | |
| channel_salt | | varchar(191) | NO | | |
➔ Datenbank