<!DOCTYPE HTML PUBLIC '-//W3C//DTD HTML 4.01 Transitional//EN' 'http://www.w3.org/TR/html4/loose.dtd'> <html> <head> <!-- SchemaSpy rev 590 --> <title>SchemaSpy - Table zot.channel</title> <link rel=stylesheet href='../schemaSpy.css' type='text/css'> <meta HTTP-EQUIV='Content-Type' CONTENT='text/html; charset=ISO-8859-1'> <SCRIPT LANGUAGE='JavaScript' TYPE='text/javascript' SRC='../jquery.js'></SCRIPT> <SCRIPT LANGUAGE='JavaScript' TYPE='text/javascript' SRC='../schemaSpy.js'></SCRIPT> <SCRIPT LANGUAGE='JavaScript' TYPE='text/javascript'> table='channel'; </SCRIPT> </head> <body> <table id='headerHolder' cellspacing='0' cellpadding='0'><tr><td> <div id='header'> <ul> <li><a href='../index.html' title='All tables and views in the schema'>Tables</a></li> <li><a href='../relationships.html' title='Diagram of table relationships'>Relationships</a></li> <li><a href='../utilities.html' title='View of tables with neither parents nor children'>Utility Tables</a></li> <li><a href='../constraints.html' title='Useful for diagnosing error messages that just give constraint name or number'>Constraints</a></li> <li><a href='../anomalies.html' title="Things that might not be quite right">Anomalies</a></li> <li><a href='../columns.byTable.html' title="All of the columns in the schema">Columns</a></li> <li><a href='http://sourceforge.net/donate/index.php?group_id=137197' title='Please help keep SchemaSpy alive' target='_blank'>Donate</a></li> </ul> </div> </td></tr></table> <div class='content' style='clear:both;'> <table width='100%' border='0' cellpadding='0'> <tr> <td class='heading' valign='middle'><span class='header'>Table <span title='Database'>zot</span>.<span title='Table'>channel</span></span></td> <td class='heading' align='right' valign='top' title='John Currier - Creator of Cool Tools'><span class='indent'>Generated by</span><br><span class='indent'><span class='signature'><a href='http://schemaspy.sourceforge.net' target='_blank'>SchemaSpy</a></span></span></td> </tr> </table> <table width='100%' border='0'> <tr valign='top'><td class='container' align='left' valign='top'> <form name='options' action=''> <label for='implied'><input type=checkbox id='implied'>Implied relationships</label> <label for='showRelatedCols'><input type=checkbox id='showRelatedCols'>Related columns</label> <label for='showConstNames'><input type=checkbox id='showConstNames'>Constraints</label> <label for='showComments'><input type=checkbox id='showComments'>Comments</label> <label for='showLegend'><input type=checkbox checked id='showLegend'>Legend</label> </form> </td><td class='container' rowspan='2' align='right' valign='top'> <table class='legend' border='0'> <tr> <td class='dataTable' valign='bottom'>Legend:</td> <td class='container' align='right' valign='top'><a href='http://sourceforge.net' target='_blank'><img src='http://sourceforge.net/sflogo.php?group_id=137197&type=1' alt='SourceForge.net' border='0' height='31' width='88'></a></td> </tr> <tr><td class='container' colspan='2'> <table class='dataTable' border='1'> <tbody> <tr><td class='primaryKey'>Primary key columns</td></tr> <tr><td class='indexedColumn'>Columns with indexes</td></tr> <tr class='impliedRelationship'><td class='detail'><span class='impliedRelationship'>Implied relationships</span></td></tr> <tr><td class='excludedColumn'>Excluded column relationships</td></tr> <tr><td class='legendDetail'>< <em>n</em> > number of related tables</td></tr> </table> </td></tr> </table> <div style="margin-right: 2pt;"> <script type="text/javascript"><!-- google_ad_client = "pub-9598353634003340"; google_ad_channel ="SchemaSpy-generated"; google_ad_width = 234; google_ad_height = 60; google_ad_format = "234x60_as"; google_ad_type = "text"; google_color_border = "9bab96"; google_color_link = "489148"; google_color_text = "000000"; //--> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script> </div> </td><tr valign='top'><td class='container' align='left' valign='top'> <a name='columns'></a> <table id='columns' class='dataTable' border='1' rules='groups'> <colgroup> <colgroup> <colgroup> <colgroup> <colgroup> <colgroup> <colgroup> <colgroup> <colgroup class='comment'> <thead align='left'> <tr> <th>Column</th> <th>Type</th> <th>Size</th> <th title='Are nulls allowed?'>Nulls</th> <th title='Is column automatically updated?'>Auto</th> <th title='Default value'>Default</th> <th title='Columns in tables that reference this column'><span class='notSortedByColumn'>Children</span></th> <th title='Columns in tables that are referenced by this column'><span class='notSortedByColumn'>Parents</span></th> <th title='Comments' class='comment'><span class='notSortedByColumn'>Comments</span></th> </tr> </thead> <tbody valign='top'> <tr class='even'> <td class='primaryKey' title='Primary Key'>channel_id</td> <td class='detail'>int unsigned</td> <td class='detail' align='right'>10</td> <td class='detail' align='center'></td> <td class='detail' align='center' title='Automatically updated by the database'> √ </td> <td class='detail'></td> <td class='detail'> <table border='0' width='100%' cellspacing='0' cellpadding='0'> <tr class='impliedRelationship relative even' valign='top'> <td class='relatedTable detail' title="likes.channel_id's name implies that it's a child of channel.channel_id, but it doesn't reference that column."><a href='likes.html'>likes</a><span class='relatedKey'>.channel_id</span> </td> <td class='constraint detail'>Implied Constraint<span title='Restrict delete: Parent cannot be deleted if children exist'> R</span></td> </tr> <tr class='impliedRelationship relative even' valign='top'> <td class='relatedTable detail' title="mail.channel_id's name implies that it's a child of channel.channel_id, but it doesn't reference that column."><a href='mail.html'>mail</a><span class='relatedKey'>.channel_id</span> </td> <td class='constraint detail'>Implied Constraint<span title='Restrict delete: Parent cannot be deleted if children exist'> R</span></td> </tr> <tr class='impliedRelationship relative even' valign='top'> <td class='relatedTable detail' title="profext.channel_id's name implies that it's a child of channel.channel_id, but it doesn't reference that column."><a href='profext.html'>profext</a><span class='relatedKey'>.channel_id</span> </td> <td class='constraint detail'>Implied Constraint<span title='Restrict delete: Parent cannot be deleted if children exist'> R</span></td> </tr> </table> </td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='odd'> <td class='indexedColumn' title='Indexed'>channel_account_id</td> <td class='detail'>int unsigned</td> <td class='detail' align='right'>10</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'>0</td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='even'> <td class='indexedColumn' title='Indexed'>channel_primary</td> <td class='detail'>bit</td> <td class='detail' align='right'>0</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'>0</td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='odd'> <td class='indexedColumn' title='Indexed'>channel_name</td> <td class='detail'>char</td> <td class='detail' align='right'>255</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'></td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='even'> <td class='indexedColumn' title='Indexed'>channel_address</td> <td class='detail'>char</td> <td class='detail' align='right'>255</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'></td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='odd'> <td class='indexedColumn' title='Indexed'>channel_guid</td> <td class='detail'>char</td> <td class='detail' align='right'>255</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'></td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='even'> <td class='detail'>channel_guid_sig</td> <td class='detail'>text</td> <td class='detail' align='right'>65535</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail'></td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='odd'> <td class='indexedColumn' title='Indexed'>channel_hash</td> <td class='detail'>char</td> <td class='detail' align='right'>255</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'></td> <td class='detail'> <table border='0' width='100%' cellspacing='0' cellpadding='0'> <tr class='relative odd' valign='top'> <td class='relatedTable detail' title="attach.hash refs channel.channel_hash"><a href='attach.html'>attach</a><span class='relatedKey'>.hash</span> </td> <td class='constraint detail'>Defined in XML<span title='Restrict delete: Parent cannot be deleted if children exist'> R</span></td> </tr> <tr class='relative odd' valign='top'> <td class='relatedTable detail' title="event.event_hash refs channel.channel_hash"><a href='event.html'>event</a><span class='relatedKey'>.event_hash</span> </td> <td class='constraint detail'>Defined in XML<span title='Restrict delete: Parent cannot be deleted if children exist'> R</span></td> </tr> <tr class='relative odd' valign='top'> <td class='relatedTable detail' title="groups.hash refs channel.channel_hash"><a href='groups.html'>groups</a><span class='relatedKey'>.hash</span> </td> <td class='constraint detail'>Defined in XML<span title='Restrict delete: Parent cannot be deleted if children exist'> R</span></td> </tr> <tr class='relative odd' valign='top'> <td class='relatedTable detail' title="hubloc.hubloc_hash refs channel.channel_hash"><a href='hubloc.html'>hubloc</a><span class='relatedKey'>.hubloc_hash</span> </td> <td class='constraint detail'>Defined in XML<span title='Restrict delete: Parent cannot be deleted if children exist'> R</span></td> </tr> <tr class='relative odd' valign='top'> <td class='relatedTable detail' title="notify.hash refs channel.channel_hash"><a href='notify.html'>notify</a><span class='relatedKey'>.hash</span> </td> <td class='constraint detail'>Defined in XML<span title='Restrict delete: Parent cannot be deleted if children exist'> R</span></td> </tr> <tr class='relative odd' valign='top'> <td class='relatedTable detail' title="outq.outq_hash refs channel.channel_hash"><a href='outq.html'>outq</a><span class='relatedKey'>.outq_hash</span> </td> <td class='constraint detail'>Defined in XML<span title='Restrict delete: Parent cannot be deleted if children exist'> R</span></td> </tr> <tr class='relative odd' valign='top'> <td class='relatedTable detail' title="profext.hash refs channel.channel_hash"><a href='profext.html'>profext</a><span class='relatedKey'>.hash</span> </td> <td class='constraint detail'>Defined in XML<span title='Restrict delete: Parent cannot be deleted if children exist'> R</span></td> </tr> <tr class='relative odd' valign='top'> <td class='relatedTable detail' title="register.hash refs channel.channel_hash"><a href='register.html'>register</a><span class='relatedKey'>.hash</span> </td> <td class='constraint detail'>Defined in XML<span title='Restrict delete: Parent cannot be deleted if children exist'> R</span></td> </tr> <tr class='relative odd' valign='top'> <td class='relatedTable detail' title="term.parent_hash refs channel.channel_hash"><a href='term.html'>term</a><span class='relatedKey'>.parent_hash</span> </td> <td class='constraint detail'>Defined in XML<span title='Restrict delete: Parent cannot be deleted if children exist'> R</span></td> </tr> <tr class='relative odd' valign='top'> <td class='relatedTable detail' title="term.term_hash refs channel.channel_hash"><a href='term.html'>term</a><span class='relatedKey'>.term_hash</span> </td> <td class='constraint detail'>Defined in XML<span title='Restrict delete: Parent cannot be deleted if children exist'> R</span></td> </tr> <tr class='relative odd' valign='top'> <td class='relatedTable detail' title="updates.ud_hash refs channel.channel_hash"><a href='updates.html'>updates</a><span class='relatedKey'>.ud_hash</span> </td> <td class='constraint detail'>Defined in XML<span title='Restrict delete: Parent cannot be deleted if children exist'> R</span></td> </tr> <tr class='relative odd' valign='top'> <td class='relatedTable detail' title="xchan.xchan_hash refs channel.channel_hash"><a href='xchan.html'>xchan</a><span class='relatedKey'>.xchan_hash</span> </td> <td class='constraint detail'>Defined in XML<span title='Restrict delete: Parent cannot be deleted if children exist'> R</span></td> </tr> <tr class='relative odd' valign='top'> <td class='relatedTable detail' title="xprof.xprof_hash refs channel.channel_hash"><a href='xprof.html'>xprof</a><span class='relatedKey'>.xprof_hash</span> </td> <td class='constraint detail'>Defined in XML<span title='Restrict delete: Parent cannot be deleted if children exist'> R</span></td> </tr> <tr class='relative odd' valign='top'> <td class='relatedTable detail' title="xtag.xtag_hash refs channel.channel_hash"><a href='xtag.html'>xtag</a><span class='relatedKey'>.xtag_hash</span> </td> <td class='constraint detail'>Defined in XML<span title='Restrict delete: Parent cannot be deleted if children exist'> R</span></td> </tr> </table> </td> <td class='detail'> <table border='0' width='100%' cellspacing='0' cellpadding='0'> <tr class='relative odd' valign='top'> <td class='relatedTable detail' title="channel.channel_hash refs xchan.xchan_hash"><a href='xchan.html'>xchan</a><span class='relatedKey'>.xchan_hash</span> </td> <td class='constraint detail'>Defined in XML<span title='Restrict delete: Parent cannot be deleted if children exist'> R</span></td> </tr> </table> </td> <td class='comment detail'></td> </tr> <tr class='even'> <td class='indexedColumn' title='Indexed'>channel_timezone</td> <td class='detail'>char</td> <td class='detail' align='right'>128</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'>UTC</td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='odd'> <td class='indexedColumn' title='Indexed'>channel_location</td> <td class='detail'>char</td> <td class='detail' align='right'>255</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'></td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='even'> <td class='indexedColumn' title='Indexed'>channel_theme</td> <td class='detail'>char</td> <td class='detail' align='right'>255</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'></td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='odd'> <td class='detail'>channel_startpage</td> <td class='detail'>char</td> <td class='detail' align='right'>255</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'></td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='even'> <td class='detail'>channel_pubkey</td> <td class='detail'>text</td> <td class='detail' align='right'>65535</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail'></td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='odd'> <td class='detail'>channel_prvkey</td> <td class='detail'>text</td> <td class='detail' align='right'>65535</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail'></td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='even'> <td class='indexedColumn' title='Indexed'>channel_notifyflags</td> <td class='detail'>int unsigned</td> <td class='detail' align='right'>10</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'>65535</td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='odd'> <td class='indexedColumn' title='Indexed'>channel_pageflags</td> <td class='detail'>int unsigned</td> <td class='detail' align='right'>10</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'>0</td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='even'> <td class='indexedColumn' title='Indexed'>channel_dirdate</td> <td class='detail'>datetime</td> <td class='detail' align='right'>19</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'>0000-00-00 00:00:00</td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='odd'> <td class='indexedColumn' title='Indexed'>channel_lastpost</td> <td class='detail'>datetime</td> <td class='detail' align='right'>19</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'>0000-00-00 00:00:00</td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='even'> <td class='indexedColumn' title='Indexed'>channel_deleted</td> <td class='detail'>datetime</td> <td class='detail' align='right'>19</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'>0000-00-00 00:00:00</td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='odd'> <td class='indexedColumn' title='Indexed'>channel_max_anon_mail</td> <td class='detail'>int unsigned</td> <td class='detail' align='right'>10</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'>10</td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='even'> <td class='indexedColumn' title='Indexed'>channel_max_friend_req</td> <td class='detail'>int unsigned</td> <td class='detail' align='right'>10</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'>10</td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='odd'> <td class='indexedColumn' title='Indexed'>channel_expire_days</td> <td class='detail'>int</td> <td class='detail' align='right'>10</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'>0</td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='even'> <td class='detail'>channel_passwd_reset</td> <td class='detail'>char</td> <td class='detail' align='right'>255</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'></td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='odd'> <td class='indexedColumn' title='Indexed'>channel_default_group</td> <td class='detail'>char</td> <td class='detail' align='right'>255</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'></td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='even'> <td class='detail'>channel_allow_cid</td> <td class='detail'>mediumtext</td> <td class='detail' align='right'>16777215</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail'></td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='odd'> <td class='detail'>channel_allow_gid</td> <td class='detail'>mediumtext</td> <td class='detail' align='right'>16777215</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail'></td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='even'> <td class='detail'>channel_deny_cid</td> <td class='detail'>mediumtext</td> <td class='detail' align='right'>16777215</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail'></td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='odd'> <td class='detail'>channel_deny_gid</td> <td class='detail'>mediumtext</td> <td class='detail' align='right'>16777215</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail'></td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='even'> <td class='indexedColumn' title='Indexed'>channel_r_stream</td> <td class='detail'>int unsigned</td> <td class='detail' align='right'>10</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'>0</td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='odd'> <td class='indexedColumn' title='Indexed'>channel_r_profile</td> <td class='detail'>int unsigned</td> <td class='detail' align='right'>10</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'>0</td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='even'> <td class='indexedColumn' title='Indexed'>channel_r_photos</td> <td class='detail'>int unsigned</td> <td class='detail' align='right'>10</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'>0</td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='odd'> <td class='indexedColumn' title='Indexed'>channel_r_abook</td> <td class='detail'>int unsigned</td> <td class='detail' align='right'>10</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'>0</td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='even'> <td class='indexedColumn' title='Indexed'>channel_w_stream</td> <td class='detail'>int unsigned</td> <td class='detail' align='right'>10</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'>0</td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='odd'> <td class='indexedColumn' title='Indexed'>channel_w_wall</td> <td class='detail'>int unsigned</td> <td class='detail' align='right'>10</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'>0</td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='even'> <td class='indexedColumn' title='Indexed'>channel_w_tagwall</td> <td class='detail'>int unsigned</td> <td class='detail' align='right'>10</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'>0</td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='odd'> <td class='indexedColumn' title='Indexed'>channel_w_comment</td> <td class='detail'>int unsigned</td> <td class='detail' align='right'>10</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'>0</td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='even'> <td class='indexedColumn' title='Indexed'>channel_w_mail</td> <td class='detail'>int unsigned</td> <td class='detail' align='right'>10</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'>0</td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='odd'> <td class='indexedColumn' title='Indexed'>channel_w_photos</td> <td class='detail'>int unsigned</td> <td class='detail' align='right'>10</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'>0</td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='even'> <td class='indexedColumn' title='Indexed'>channel_w_chat</td> <td class='detail'>int unsigned</td> <td class='detail' align='right'>10</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'>0</td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='odd'> <td class='indexedColumn' title='Indexed'>channel_a_delegate</td> <td class='detail'>int unsigned</td> <td class='detail' align='right'>10</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'>0</td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='even'> <td class='indexedColumn' title='Indexed'>channel_r_storage</td> <td class='detail'>int unsigned</td> <td class='detail' align='right'>10</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'>0</td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='odd'> <td class='indexedColumn' title='Indexed'>channel_w_storage</td> <td class='detail'>int unsigned</td> <td class='detail' align='right'>10</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'>0</td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='even'> <td class='indexedColumn' title='Indexed'>channel_r_pages</td> <td class='detail'>int unsigned</td> <td class='detail' align='right'>10</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'>0</td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='odd'> <td class='indexedColumn' title='Indexed'>channel_w_pages</td> <td class='detail'>int unsigned</td> <td class='detail' align='right'>10</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'>0</td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='even'> <td class='indexedColumn' title='Indexed'>channel_a_republish</td> <td class='detail'>int unsigned</td> <td class='detail' align='right'>10</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'>0</td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='odd'> <td class='indexedColumn' title='Indexed'>channel_w_like</td> <td class='detail'>int unsigned</td> <td class='detail' align='right'>10</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'>0</td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='even'> <td class='indexedColumn' title='Indexed'>channel_removed</td> <td class='detail'>bit</td> <td class='detail' align='right'>0</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'>0</td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> <tr class='odd'> <td class='indexedColumn' title='Indexed'>channel_system</td> <td class='detail'>bit</td> <td class='detail' align='right'>0</td> <td class='detail' align='center'></td> <td class='detail' align='center'></td> <td class='detail' align='right'>0</td> <td class='detail'></td> <td class='detail'> </td> <td class='comment detail'></td> </tr> </table> <p title='48 columns'>Table contained 12 rows at fr nov 06 17:11 CET 2015<p/> </td></tr></table> <div class='indent'> <b>Indexes:</b> <table class='dataTable' border='1' rules='groups'><colgroup><colgroup><colgroup><colgroup> <thead> <tr> <th>Column(s)</th> <th>Type</th> <th>Sort</th> <th class='constraint' style='text-align:left;'>Constraint Name</th> </tr> </thead> <tbody> <tr> <td class='primaryKey'>channel_id</td> <td class='detail'>Primary key</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>PRIMARY</td> </tr> <tr> <td class='indexedColumn'>channel_a_delegate</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_a_delegate</td> </tr> <tr> <td class='indexedColumn'>channel_a_republish</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_a_republish</td> </tr> <tr> <td class='indexedColumn'>channel_account_id</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_account_id</td> </tr> <tr> <td class='indexedColumn'>channel_address</td> <td class='detail'>Must be unique</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_address_unique</td> </tr> <tr> <td class='indexedColumn'>channel_default_group</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_default_gid</td> </tr> <tr> <td class='indexedColumn'>channel_deleted</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_deleted</td> </tr> <tr> <td class='indexedColumn'>channel_dirdate</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_dirdate</td> </tr> <tr> <td class='indexedColumn'>channel_expire_days</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_expire_days</td> </tr> <tr> <td class='indexedColumn'>channel_guid</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_guid</td> </tr> <tr> <td class='indexedColumn'>channel_hash</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_hash</td> </tr> <tr> <td class='indexedColumn'>channel_lastpost</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_lastpost</td> </tr> <tr> <td class='indexedColumn'>channel_location</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_location</td> </tr> <tr> <td class='indexedColumn'>channel_max_anon_mail</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_max_anon_mail</td> </tr> <tr> <td class='indexedColumn'>channel_max_friend_req</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_max_friend_req</td> </tr> <tr> <td class='indexedColumn'>channel_name</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_name</td> </tr> <tr> <td class='indexedColumn'>channel_notifyflags</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_notifyflags</td> </tr> <tr> <td class='indexedColumn'>channel_pageflags</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_pageflags</td> </tr> <tr> <td class='indexedColumn'>channel_primary</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_primary</td> </tr> <tr> <td class='indexedColumn'>channel_r_abook</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_r_abook</td> </tr> <tr> <td class='indexedColumn'>channel_r_pages</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_r_pages</td> </tr> <tr> <td class='indexedColumn'>channel_r_photos</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_r_photos</td> </tr> <tr> <td class='indexedColumn'>channel_r_profile</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_r_profile</td> </tr> <tr> <td class='indexedColumn'>channel_r_storage</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_r_storage</td> </tr> <tr> <td class='indexedColumn'>channel_r_stream</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_r_stream</td> </tr> <tr> <td class='indexedColumn'>channel_removed</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_removed</td> </tr> <tr> <td class='indexedColumn'>channel_system</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_system</td> </tr> <tr> <td class='indexedColumn'>channel_theme</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_theme</td> </tr> <tr> <td class='indexedColumn'>channel_timezone</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_timezone</td> </tr> <tr> <td class='indexedColumn'>channel_w_chat</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_w_chat</td> </tr> <tr> <td class='indexedColumn'>channel_w_comment</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_w_comment</td> </tr> <tr> <td class='indexedColumn'>channel_w_like</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_w_like</td> </tr> <tr> <td class='indexedColumn'>channel_w_mail</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_w_mail</td> </tr> <tr> <td class='indexedColumn'>channel_w_pages</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_w_pages</td> </tr> <tr> <td class='indexedColumn'>channel_w_photos</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_w_photos</td> </tr> <tr> <td class='indexedColumn'>channel_w_storage</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_w_storage</td> </tr> <tr> <td class='indexedColumn'>channel_w_stream</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_w_stream</td> </tr> <tr> <td class='indexedColumn'>channel_w_tagwall</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_w_tagwall</td> </tr> <tr> <td class='indexedColumn'>channel_w_wall</td> <td class='detail'>Performance</td> <td class='detail' style='text-align:left;'><span title='Ascending'>Asc</span></td> <td class='constraint' style='text-align:left;'>channel_w_wall</td> </tr> </table> </div> <table width='100%' border='0'><tr><td class='container'> <br><form action='get'><b>Close relationships</b><span class='degrees' id='degrees' title='Detail diminishes with increased separation from channel'> within <label for='oneDegree'><input type='radio' name='degrees' id='oneDegree' checked>one</label> <label for='twoDegrees'><input type='radio' name='degrees' id='twoDegrees'>two degrees</label> of separation</span><b>:</b></form> <map id="oneDegreeRelationshipsDiagram" name="oneDegreeRelationshipsDiagram"> <area shape="rect" id="node1" href="attach.html" title="attach" alt="" coords="931,2508,1083,3087"> <area shape="rect" id="node3" href="channel.html" title="channel" alt="" coords="528,1003,878,2154"> <area shape="rect" id="node5" href="hubloc.html" title="hubloc" alt="" coords="27,1130,224,1641"> <area shape="rect" id="node7" href="xchan.html" title="xchan" alt="" coords="271,1198,482,1845"> <area shape="rect" id="node9" href="event.html" title="event" alt="" coords="923,3104,1091,3773"> <area shape="rect" id="node14" href="groups.html" title="groups" alt="" coords="942,419,1072,613"> <area shape="rect" id="node20" href="notify.html" title="notify" alt="" coords="939,2093,1075,2491"> <area shape="rect" id="node24" href="outq.html" title="outq" alt="" coords="927,793,1087,1122"> <area shape="rect" id="node28" href="profext.html" title="profext" alt="" coords="942,1139,1072,1309"> <area shape="rect" id="node32" href="register.html" title="register" alt="" coords="943,1650,1071,1843"> <area shape="rect" id="node36" href="term.html" title="term" alt="" coords="926,1327,1088,1633"> <area shape="rect" id="node43" href="updates.html" title="updates" alt="" coords="944,1860,1070,2076"> <area shape="rect" id="node49" href="xprof.html" title="xprof" alt="" coords="930,5,1084,403"> <area shape="rect" id="node53" href="xtag.html" title="xtag" alt="" coords="943,629,1071,777"> </map> <a name='diagram'><img id='oneDegreeImg' src='../diagrams/channel.1degree.png' usemap='#oneDegreeRelationshipsDiagram' class='diagram' border='0' alt='' align='left'></a> <map id="impliedTwoDegreesRelationshipsDiagram" name="impliedTwoDegreesRelationshipsDiagram"> <area shape="rect" id="node1" href="abook.html" title="abook" alt="" coords="933,2393,1069,2473"> <area shape="rect" id="node3" href="xchan.html" title="xchan" alt="" coords="662,2925,873,3571"> <area shape="rect" id="node11" href="channel.html" title="channel" alt="" coords="22,2611,372,3762"> <area shape="rect" id="node13" href="hubloc.html" title="hubloc" alt="" coords="418,2857,616,3367"> <area shape="rect" id="node4" href="addon.html" title="addon" alt="" coords="1148,2795,1276,2875"> <area shape="rect" id="node6" href="notify.html" title="notify" alt="" coords="922,2844,1080,3241"> <area shape="rect" id="node7" href="app.html" title="app" alt="" coords="1152,2892,1272,2972"> <area shape="rect" id="node9" href="attach.html" title="attach" alt="" coords="925,5,1077,584"> <area shape="rect" id="node16" href="verify.html" title="verify" alt="" coords="704,1305,832,1385"> <area shape="rect" id="node18" href="chat.html" title="chat" alt="" coords="941,3295,1061,3375"> <area shape="rect" id="node20" href="chatpresence.html" title="chatpresence" alt="" coords="936,3392,1066,3472"> <area shape="rect" id="node22" href="dreport.html" title="dreport" alt="" coords="926,3489,1076,3569"> <area shape="rect" id="node24" href="event.html" title="event" alt="" coords="1128,2108,1296,2777"> <area shape="rect" id="node30" href="fserver.html" title="fserver" alt="" coords="1150,2989,1273,3069"> <area shape="rect" id="node32" href="fsuggest.html" title="fsuggest" alt="" coords="1149,3087,1274,3167"> <area shape="rect" id="node34" href="group_member.html" title="group_member" alt="" coords="924,1111,1078,1191"> <area shape="rect" id="node37" href="groups.html" title="groups" alt="" coords="936,601,1066,794"> <area shape="rect" id="node42" href="hook.html" title="hook" alt="" coords="1148,3184,1276,3264"> <area shape="rect" id="node46" href="item.html" title="item" alt="" coords="922,2296,1080,2376"> <area shape="rect" id="node51" href="likes.html" title="likes" alt="" coords="936,810,1066,1094"> <area shape="rect" id="node54" href="mail.html" title="mail" alt="" coords="925,1402,1077,1958"> <area shape="rect" id="node56" href="account.html" title="account" alt="" coords="706,1515,829,1595"> <area shape="rect" id="node61" href="manage.html" title="manage" alt="" coords="1149,3476,1274,3556"> <area shape="rect" id="node67" href="outq.html" title="outq" alt="" coords="921,4073,1081,4402"> <area shape="rect" id="node71" href="pconfig.html" title="pconfig" alt="" coords="1142,2011,1281,2091"> <area shape="rect" id="node74" href="cache.html" title="cache" alt="" coords="700,2136,836,2216"> <area shape="rect" id="node75" href="photo.html" title="photo" alt="" coords="926,1208,1076,1288"> <area shape="rect" id="node78" href="profext.html" title="profext" alt="" coords="936,1975,1066,2145"> <area shape="rect" id="node85" href="profile.html" title="profile" alt="" coords="1148,3281,1276,3361"> <area shape="rect" id="node87" href="register.html" title="register" alt="" coords="937,2598,1065,2791"> <area shape="rect" id="node92" href="shares.html" title="shares" alt="" coords="941,3587,1061,3667"> <area shape="rect" id="node94" href="source.html" title="source" alt="" coords="941,3684,1061,3764"> <area shape="rect" id="node97" href="spam.html" title="spam" alt="" coords="1152,3379,1272,3459"> <area shape="rect" id="node99" href="term.html" title="term" alt="" coords="920,4419,1082,4725"> <area shape="rect" id="node106" href="updates.html" title="updates" alt="" coords="938,4743,1064,4959"> <area shape="rect" id="node110" href="vote.html" title="vote" alt="" coords="941,3781,1061,3861"> <area shape="rect" id="node114" href="xchat.html" title="xchat" alt="" coords="941,3879,1061,3959"> <area shape="rect" id="node116" href="xconfig.html" title="xconfig" alt="" coords="940,2199,1062,2279"> <area shape="rect" id="node120" href="xign.html" title="xign" alt="" coords="941,1305,1061,1385"> <area shape="rect" id="node123" href="xlink.html" title="xlink" alt="" coords="926,3976,1076,4056"> <area shape="rect" id="node125" href="xprof.html" title="xprof" alt="" coords="924,4976,1078,5373"> <area shape="rect" id="node129" href="xtag.html" title="xtag" alt="" coords="937,5390,1065,5538"> </map> <a name='diagram'><img id='impliedTwoDegreesImg' src='../diagrams/channel.implied2degrees.png' usemap='#impliedTwoDegreesRelationshipsDiagram' class='diagram' border='0' alt='' align='left'></a> <map id="twoDegreesRelationshipsDiagram" name="twoDegreesRelationshipsDiagram"> <area shape="rect" id="node1" href="abook.html" title="abook" alt="" coords="934,2631,1070,2711"> <area shape="rect" id="node3" href="xchan.html" title="xchan" alt="" coords="662,3118,872,3765"> <area shape="rect" id="node6" href="channel.html" title="channel" alt="" coords="22,2453,371,3603"> <area shape="rect" id="node8" href="hubloc.html" title="hubloc" alt="" coords="418,2546,615,3057"> <area shape="rect" id="node4" href="attach.html" title="attach" alt="" coords="926,1139,1078,1717"> <area shape="rect" id="node11" href="chat.html" title="chat" alt="" coords="942,2728,1062,2808"> <area shape="rect" id="node13" href="chatpresence.html" title="chatpresence" alt="" coords="936,2825,1067,2905"> <area shape="rect" id="node15" href="dreport.html" title="dreport" alt="" coords="927,2923,1076,3003"> <area shape="rect" id="node17" href="event.html" title="event" alt="" coords="918,1735,1086,2404"> <area shape="rect" id="node22" href="group_member.html" title="group_member" alt="" coords="924,3020,1079,3100"> <area shape="rect" id="node24" href="groups.html" title="groups" alt="" coords="936,5,1067,198"> <area shape="rect" id="node30" href="item.html" title="item" alt="" coords="923,3117,1080,3197"> <area shape="rect" id="node34" href="mail.html" title="mail" alt="" coords="938,3215,1066,3295"> <area shape="rect" id="node37" href="manage.html" title="manage" alt="" coords="939,3312,1064,3392"> <area shape="rect" id="node39" href="notify.html" title="notify" alt="" coords="934,215,1070,612"> <area shape="rect" id="node43" href="outq.html" title="outq" alt="" coords="922,793,1082,1122"> <area shape="rect" id="node47" href="photo.html" title="photo" alt="" coords="927,3409,1076,3489"> <area shape="rect" id="node49" href="profext.html" title="profext" alt="" coords="936,4603,1067,4773"> <area shape="rect" id="node53" href="register.html" title="register" alt="" coords="938,2421,1066,2614"> <area shape="rect" id="node57" href="shares.html" title="shares" alt="" coords="942,3507,1062,3587"> <area shape="rect" id="node59" href="source.html" title="source" alt="" coords="942,3604,1062,3684"> <area shape="rect" id="node62" href="term.html" title="term" alt="" coords="920,4791,1083,5097"> <area shape="rect" id="node69" href="updates.html" title="updates" alt="" coords="939,5115,1064,5331"> <area shape="rect" id="node73" href="vote.html" title="vote" alt="" coords="942,3701,1062,3781"> <area shape="rect" id="node77" href="xchat.html" title="xchat" alt="" coords="942,3799,1062,3879"> <area shape="rect" id="node79" href="xconfig.html" title="xconfig" alt="" coords="940,3896,1063,3976"> <area shape="rect" id="node81" href="xign.html" title="xign" alt="" coords="942,3993,1062,4073"> <area shape="rect" id="node83" href="xlink.html" title="xlink" alt="" coords="927,4091,1076,4171"> <area shape="rect" id="node85" href="xprof.html" title="xprof" alt="" coords="924,4188,1079,4585"> <area shape="rect" id="node89" href="xtag.html" title="xtag" alt="" coords="938,629,1066,777"> </map> <a name='diagram'><img id='twoDegreesImg' src='../diagrams/channel.2degrees.png' usemap='#twoDegreesRelationshipsDiagram' class='diagram' border='0' alt='' align='left'></a> </td></tr></table> </div> </body> </html>