Changes between Version 1 and Version 2 of TablesStructure


Ignore:
Timestamp:
Mar 17, 2009, 9:30:53 PM (9 years ago)
Author:
omry
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • TablesStructure

    v1 v2  
    55
    66|| '''Row name''' || '''Description''' ||
    7 || id ||Primary key of this table. an auto incrementing unique id||
    8 || ip_int1 ||The first 64 bits of the IP address in an int format. since FireStats supports ipv6 128 bits are required to hold each ip address ||
    9 || ip_int2 ||The second 64 bits of the IP address in an int format||
    10 || timestamp|| Timestamp of the hit, when it was recorded||
    11 || url_id Hit|| The ID of the hit URL in the urls table (firestats_urls)||
    12 || url_site_id|| The Site ID of url (To which site monitored by FireStats the url belongs ||
    13 || referer_id || The Referer URL id in the urls table (firestats_urls) ||
    14 || useragent_id||The !UserAgent ID in the Useragents table ((firestats_useragents)||
    15 ||session_id || future use ||
    16 || country_code || 2 bytes country code of IP address or NULL if unknown ||
    17 || excluded_by_user || future use ||
    18 || excluded_ip || 1 if this row is excluded by IP address, 0 otherwise ||
     7|| '''id''' ||Primary key of this table. an auto incrementing unique id||
     8|| '''ip_int1''' ||The first 64 bits of the IP address in an int format. since FireStats supports ipv6 128 bits are required to hold each ip address ||
     9|| '''ip_int2''' ||The second 64 bits of the IP address in an int format||
     10|| '''timestamp''' || Timestamp of the hit, when it was recorded||
     11|| '''url_id'''|| The ID of the hit URL in the urls table (firestats_urls)||
     12|| '''url_site_id''' || The Site ID of url (To which site monitored by FireStats the url belongs ||
     13|| '''referer_id''' || The Referer URL id in the urls table (firestats_urls) ||
     14|| '''useragent_id''' ||The !UserAgent ID in the Useragents table ((firestats_useragents)||
     15||'''session_id''' || future use ||
     16|| '''country_code''' || 2 bytes country code of IP address or NULL if unknown ||
     17|| '''excluded_by_user''' || future use ||
     18|| '''excluded_ip''' || 1 if this row is excluded by IP address, 0 otherwise ||
    1919
    2020 == URLs table (firestats_urls) ==
    2121The urls table holds all the urls and referrer information :
    2222|| '''Row name''' || '''Description''' ||
    23 || id || URL id, referenced from other tables ||
    24 || url || URL text as a binary blob ||
    25 || site_id || The site_id this url belongs to ||
    26 || md5 || url md5 checksum, used for indexing purposes ||
    27 || host || url hostname. for http://firestats.cc/wiki that would be firestats.cc ||
    28 ||search_engine_id || The ID of the search engine this url is from or NULL if not from a search engine ||
    29 ||search_terms || Search terms in this url, if from a search engine or NULL for none ||
    30 ||title|| The title of the page referenced by this url. currently only for WordPress posts and pages of monitored blogs ||
    31 || type || URL Type, currently supported types: FS_URL_TYPE_POST=1 - WordPress post or page. FS_URL_TYPE_RSS=2 - RSS page ||
    32 || add_time || The time this url was first added to FireStats||
    33 ||matching_exclude_patterns|| 1 if url matches a url excluding pattern, 0 otherwise ||
     23|| '''id''' || URL id, referenced from other tables ||
     24|| '''url''' || URL text as a binary blob ||
     25|| '''site_id''' || The site_id this url belongs to ||
     26|| '''md5''' || url md5 checksum, used for indexing purposes ||
     27|| '''host''' || url hostname. for http://firestats.cc/wiki that would be firestats.cc ||
     28||'''search_engine_id''' || The ID of the search engine this url is from or NULL if not from a search engine ||
     29||'''search_terms''' || Search terms in this url, if from a search engine or NULL for none ||
     30||'''title'''|| The title of the page referenced by this url. currently only for WordPress posts and pages of monitored blogs ||
     31|| '''type''' || URL Type, currently supported types: FS_URL_TYPE_POST=1 - WordPress post or page. FS_URL_TYPE_RSS=2 - RSS page ||
     32|| '''add_time''' || The time this url was first added to FireStats||
     33||'''matching_exclude_patterns'''|| 1 if url matches a url excluding pattern, 0 otherwise ||
    3434
    3535 == Useragents table (firestats_useragents) ==
    3636The useragents table hold all the useragents (firestats_useragents)
    3737|| '''Row name''' || '''Description''' ||
    38 || id || Useragent ID, referenced from other tables||
    39 || useragent ||Useragent text as a binary blob ||
    40 || md5 || Useragent md5 checksum, used for indexing purposes ||
    41 || match_bots || 1 if useragent matches a useragent excluding pattern, 0 otherwise ||
     38|| '''id''' || Useragent ID, referenced from other tables||
     39|| '''useragent''' ||Useragent text as a binary blob ||
     40|| '''md5''' || Useragent md5 checksum, used for indexing purposes ||
     41|| '''match_bots''' || 1 if useragent matches a useragent excluding pattern, 0 otherwise ||
    4242
    4343
     
    4747The ranges table define the archive ranges. each range has an id, a beginning and end time and is referenced by the other archive tables to specify that some data was collected in this range. currently ranges are always of one day, but this may change in the future.
    4848|| '''Row name''' || '''Description''' ||
    49 || id || Range ID ||
    50 ||range_start || Start time of this range ||
    51 ||range_end || End time of this range ||
     49|| '''id''' || Range ID ||
     50||'''range_start''' || Start time of this range ||
     51||'''range_end''' || End time of this range ||
    5252
    5353 == Archive tables ==