poco urlurl template for following %s

Field	Description	Type	Null	Key	Default	Extra
xchan_hash	calculated hash of this extended channel	char(255)	NO	PRI	NULL
xchan_guid	channel_guid of this extended channel	char(255)	NO	MUL
xchan_guid_sig	base64url encoded signature of the guid	text	NO		NULL
xchan_pubkey	public key for verifying signed data and assertions	text	NO		NULL
xchan_photo_mimetype	mimetype of the profile photo	char(32)	NO		image/jpeg
xchan_photo_l	photo url 300px	char(255)	NO
xchan_photo_m	photo url 80 px	char(255)	NO
xchan_photo_s	photo url 48 px	char(255)	NO
xchan_addr	user@host	char(255)	NO	MUL
xchan_url	url of channel page on primary hub location	char(255)	NO	MUL
xchan_connurl		char(255)	NO	MUL
xchan_follow		char(255)	NO	MUL
xchan_connpage	for premium channels url of channel to display when connecting	char(255)	NO
xchan_name	human readabl name of channel	char(255)	NO	MUL
xchan_network	network of channel for instance 'zot', 'diaspora', 'unknown'	char(255)	NO	MUL
xchan_instance_url	no longer used	char(255)	NO	MUL
xchan_flags	no longer used	int(10) unsigned	NO	MUL	0
xchan_photo_date	timestamp of last photo change in GMT	datetime	NO		0000-00-00 00:00:00
xchan_name_date	timestamp of last name change in GMT	datetime	NO		0000-00-00 00:00:00
xchan_hidden	flag - channel is hidden	int(10) unsigned	NO	MUL	0
xchan_orphan	flag - channel has no known hubloc locations	int(10) unsigned	NO	MUL	0
xchan_censored	flag - channel has been censored	int(10) unsigned	NO	MUL	0
xchan_selfcensored	flag - channel is self censored (adult or nsfw)	int(10) unsigned	NO	MUL	0
xchan_system	flag - this represents a system channel	int(10) unsigned	NO	MUL	0
xchan_pubforum	flag - channel is a public forum	int(10) unsigned	NO	MUL	0
xchan_deleted	flag - channel was deleted	int(10) unsigned	NO	MUL	0

Return to database documentation