relative site URL to visit after logging in

Field	Description	Type	Null	Key	Default	Extra
channel_id	sequential ID	int(10) unsigned	NO	PRI	NULL	auto_increment
channel_account_id	account.id of the account owning this channel	int(10) unsigned	NO	MUL	0
channel_primary	1 = this is the primary instance of this channel	tinyint(1) unsigned	NO	MUL	0
channel_name	Name that this channel is known by	char(255)	NO	MUL
channel_address	"username" or URL-and-email safe nickname	char(255)	NO	UNI
channel_guid	Long hash representing a psuedo-unique ID, does not have ot be globally unique	char(255)	NO	MUL
channel_guid_sig	channel.gui signed with channel.prvkey and base64url_encoded	text	NO		NULL
channel_hash	base64url_encode of a 64-char whirlpool hash of channel.guid and channel_guid_sig concatenated, synonymous with xchan_hash.	char(255)	NO	MUL
channel_timezone	PHP-legal timezone	char(128)	NO	MUL	UTC
channel_location	Default for item.location	char(255)	NO	MUL
channel_theme	channel theme preference	char(255)	NO	MUL
channel_startpage		char(255)	NO
channel_pubkey	RSA public key 4096 bit	text	NO		NULL
channel_prvkey	RSA private key 4096 bit	text	NO		NULL
channel_notifyflags	bifield representing what notification types are active	int(10) unsigned	NO	MUL	65535
channel_pageflags	bitfield of special channel uses	int(10) unsigned	NO	MUL	0
channel_dirdate	time when directory was last pinged. Must do this once a month	datetime	NO	MUL	0000-00-00 00:00:00
channel_lastpost	date of last post for this channel. May not be fully implemented	datetime	NO	MUL	0000-00-00 00:00:00
channel_deleted	time when channel was deleted	datetime	NO	MUL	0000-00-00 00:00:00
channel_max_anon_mail	unused	int(10) unsigned	NO	MUL	10
channel_max_friend_req	unused	int(10) unsigned	NO	MUL	10
channel_expire_days	expire imported content that hasn't been otherwise protected after this many days, 0 is no expiration	int(11)	NO	MUL	0
channel_passwd_reset	password reset token	char(255)	NO
channel_default_group	put all new connections into the group with this name	char(255)	NO	MUL
channel_allow_cid	Default permissions for this channel	mediumtext	NO		NULL
channel_allow_gid	Default permissions for this channel	mediumtext	NO		NULL
channel_deny_cid	Default permissions for this channel	mediumtext	NO		NULL
channel_deny_gid	Default permissions for this channel	mediumtext	NO		NULL
channel_r_stream	specific permission bitfield	int(10) unsigned	NO	MUL	128
channel_r_profile	specific permission bitfield	int(10) unsigned	NO	MUL	128
channel_r_photos	specific permission bitfield	int(10) unsigned	NO	MUL	128
channel_r_abook	specific permission bitfield	int(10) unsigned	NO	MUL	128
channel_w_stream	specific permission bitfield	int(10) unsigned	NO	MUL	128
channel_w_wall	specific permission bitfield	int(10) unsigned	NO	MUL	128
channel_w_tagwall	specific permission bitfield	int(10) unsigned	NO	MUL	128
channel_w_comment	specific permission bitfield	int(10) unsigned	NO	MUL	128
channel_w_mail	specific permission bitfield	int(10) unsigned	NO	MUL	128
channel_w_photos	specific permission bitfield	int(10) unsigned	NO	MUL	128
channel_w_chat	specific permission bitfield	int(10) unsigned	NO	MUL	128
channel_a_delegate	specific permission bitfield	int(10) unsigned	NO	MUL	0
channel_r_storage	specific permission bitfield	int(10) unsigned	NO	MUL	128
channel_w_storage	specific permission bitfield	int(10) unsigned	NO	MUL	128
channel_r_pages	specific permission bitfield	int(10) unsigned	NO	MUL	128
channel_w_pages	specific permission bitfield	int(10) unsigned	NO	MUL	128
channel_a_republish	specific permission bitfield	int(10) unsigned	NO	MUL	128
channel_w_like	specific permission bitfield	int(10) unsigned	NO	MUL	128
channel_removed	if 1, this channel has been deleted	int(10) unsigned	NO	MUL	128
channel_system	if 1, this is the special system channel on this site	int(10) unsigned	NO	MUL	128
channel_moved	URL of relocated channel, making this instance abandoned if set	char(255)	NO	MUL

Return to database documentation