Red Documentation:

Contents


relative site URL to visit after logging in
FieldDescriptionTypeNullKeyDefaultExtra
channel_idsequential IDint(10) unsignedNOPRINULLauto_increment
channel_account_idaccount.id of the account owning this channelint(10) unsignedNOMUL0
channel_primary1 = this is the primary instance of this channeltinyint(1) unsignedNOMUL0
channel_nameName that this channel is known bychar(255)NOMUL
channel_address"username" or URL-and-email safe nicknamechar(255)NOUNI
channel_guidLong hash representing a psuedo-unique ID, does not have ot be globally uniquechar(255)NOMUL
channel_guid_sigchannel.gui signed with channel.prvkey and base64url_encodedtextNONULL
channel_hashbase64url_encode of a 64-char whirlpool hash of channel.guid and channel_guid_sig concatenated, synonymous with xchan_hash.char(255)NOMUL
channel_timezonePHP-legal timezonechar(128)NOMULUTC
channel_locationDefault for item.locationchar(255)NOMUL
channel_themechannel theme preferencechar(255)NOMUL
channel_startpagechar(255)NO
channel_pubkeyRSA public key 4096 bittextNONULL
channel_prvkeyRSA private key 4096 bittextNONULL
channel_notifyflagsbifield representing what notification types are activeint(10) unsignedNOMUL65535
channel_pageflagsbitfield of special channel usesint(10) unsignedNOMUL0
channel_dirdatetime when directory was last pinged. Must do this once a monthdatetimeNOMUL0000-00-00 00:00:00
channel_lastpostdate of last post for this channel. May not be fully implementeddatetimeNOMUL0000-00-00 00:00:00
channel_deletedtime when channel was deleteddatetimeNOMUL0000-00-00 00:00:00
channel_max_anon_mailunusedint(10) unsignedNOMUL10
channel_max_friend_requnusedint(10) unsignedNOMUL10
channel_expire_daysexpire imported content that hasn't been otherwise protected after this many days, 0 is no expirationint(11)NOMUL0
channel_passwd_resetpassword reset tokenchar(255)NO
channel_default_groupput all new connections into the group with this namechar(255)NOMUL
channel_allow_cidDefault permissions for this channelmediumtextNONULL
channel_allow_gidDefault permissions for this channelmediumtextNONULL
channel_deny_cidDefault permissions for this channelmediumtextNONULL
channel_deny_gidDefault permissions for this channelmediumtextNONULL
channel_r_streamspecific permission bitfieldint(10) unsignedNOMUL128
channel_r_profilespecific permission bitfieldint(10) unsignedNOMUL128
channel_r_photosspecific permission bitfieldint(10) unsignedNOMUL128
channel_r_abookspecific permission bitfieldint(10) unsignedNOMUL128
channel_w_streamspecific permission bitfieldint(10) unsignedNOMUL128
channel_w_wallspecific permission bitfieldint(10) unsignedNOMUL128
channel_w_tagwallspecific permission bitfieldint(10) unsignedNOMUL128
channel_w_commentspecific permission bitfieldint(10) unsignedNOMUL128
channel_w_mailspecific permission bitfieldint(10) unsignedNOMUL128
channel_w_photosspecific permission bitfieldint(10) unsignedNOMUL128
channel_w_chatspecific permission bitfieldint(10) unsignedNOMUL128
channel_a_delegatespecific permission bitfieldint(10) unsignedNOMUL0
channel_r_storagespecific permission bitfieldint(10) unsignedNOMUL128
channel_w_storagespecific permission bitfieldint(10) unsignedNOMUL128
channel_r_pagesspecific permission bitfieldint(10) unsignedNOMUL128
channel_w_pagesspecific permission bitfieldint(10) unsignedNOMUL128
channel_a_republishspecific permission bitfieldint(10) unsignedNOMUL128
channel_w_likespecific permission bitfieldint(10) unsignedNOMUL128
channel_removedif 1, this channel has been deletedint(10) unsignedNOMUL128
channel_systemif 1, this is the special system channel on this siteint(10) unsignedNOMUL128
channel_movedURL of relocated channel, making this instance abandoned if setchar(255)NOMUL


Return to database documentation