=====================================================
SourceForge Research Data Warehouse: Tables and Views
=====================================================

Y. Gao and G. Madey (September, 2005)

The data warehouse has over 100 tables (and views) for each monthly dump. There are a few different tables among the months. These different tables will be noted in this document. When a table is noted as "deprecated", it no longer exists in the subsequent monthly dumps. When a table is noted as "newly added", this typically means it was added in a month following the date is given. By default, the tables exist throughout the data warehouse of the database dumps, unless otherwise indicated. Every table is named as "SCHEMA.Relation_Name", where "SCHEMA" is name of the monthly dump, e.g., sf0103, sf1104, sf1204, sf0205, sf0305, sf0405.

The tables are listed in alphabetic order.


Table "SCHEMA.artifact"
      Column       |  Type   | Null?                           
-------------------+---------+----------
 artifact_id       | integer | not null
 group_artifact_id | integer | not null
 status_id         | integer | not null 
 category_id       | integer | not null 
 artifact_group_id | integer | not null 
 resolution_id     | integer | not null 
 priority          | integer | not null 
 submitted_by      | integer | not null 
 assigned_to       | integer | not null 
 open_date         | integer | not null 
 close_date        | integer | not null 
 summary           | text    | not null
 details           | text    | not null
 closed_by         | integer | 

Table "SCHEMA.artifact_canned_responses"
      Column       |  Type   | Null?                                       
-------------------+---------+----------
 id                | integer | not null
 group_artifact_id | integer | not null
 title             | text    | not null
 body              | text    | not null
 state             | integer | not null 
 added_by          | integer | not null 
 mod_by            | integer | not null 
 last_updated      | integer | not null 


Table "SCHEMA.artifact_category"
      Column       |  Type   | Null?                           
-------------------+---------+----------
 id                | integer | not null
 group_artifact_id | integer | not null
 category_name     | text    | not null
 auto_assign_to    | integer | not null 


Table "SCHEMA.artifact_counts_agg"
      Column       |  Type   | Null? 
-------------------+---------+----------
 group_artifact_id | integer | not null
 count             | integer | not null
 open_count        | integer | 

Table "SCHEMA.artifact_file"
    Column    |  Type   | Null?                         
--------------+---------+----------
 id           | integer | not null 
 artifact_id  | integer | not null
 description  | text    | not null
 bin_data     | text    | not null
 filename     | text    | not null
 filesize     | integer | not null
 filetype     | text    | not null
 adddate      | integer | not null 
 submitted_by | integer | not null


*(Deprecated, Aug. 2005)*	View "SCHEMA.artifact_file_user_vw"
    Column    |         Type          | Null? 
--------------+-----------------------+----------
 id           | integer               | 
 artifact_id  | integer               | 
 description  | text                  | 
 bin_data     | text                  | 
 filename     | text                  | 
 filesize     | integer               | 
 filetype     | text                  | 
 adddate      | integer               | 
 submitted_by | integer               | 
 user_name    | text                  | 
 realname     | character varying(32) | 


  Table "SCHEMA.artifact_group"
      Column       |  Type   | Null?                         
-------------------+---------+----------
 id                | integer | not null 
 group_artifact_id | integer | not null
 group_name        | text    | not null

Table "SCHEMA.artifact_group_list"
       Column        |  Type   | Null?                              
---------------------+---------+----------
 group_artifact_id   | integer | not null
 group_id            | integer | not null
 name                | text    | 
 description         | text    | 
 is_public           | integer | not null 
 allow_anon          | integer | not null 
 email_all_updates   | integer | not null 
 due_period          | integer | not null 
 use_resolution      | integer | not null 
 submit_instructions | text    | 
 browse_instructions | text    | 
 datatype            | integer | not null 
 status_timeout      | integer | 
 due_period_initial  | integer | not null 
 due_period_update   | integer | not null 

Table "SCHEMA.artifact_history"
   Column    |  Type   | Null?                          
-------------+---------+----------
 id          | integer | not null
 artifact_id | integer | not null 
 field_name  | text    | not null 
 old_value   | text    | not null 
 mod_by      | integer | not null 
 entrydate   | integer | not null 

*(Deprecated, Aug. 2005)*	View "SCHEMA.artifact_history_user_vw"
   Column    |  Type   | Null? 
-------------+---------+----------
 id          | integer | 
 artifact_id | integer | 
 field_name  | text    | 
 old_value   | text    | 
 entrydate   | integer | 
 user_name   | text    | 

Table "SCHEMA.artifact_message"
    Column    |  Type   | Null?                          
--------------+---------+----------
 id           | integer | not null 
 artifact_id  | integer | not null
 submitted_by | integer | not null
 adddate      | integer | not null 
 body         | text    | not null

Table "SCHEMA.artifact_perm"
      Column       |  Type   | Null?                         
-------------------+---------+----------
 id                | integer | not null 
 group_artifact_id | integer | not null
 user_id           | integer | not null
 perm_level        | integer | not null 

Table "SCHEMA.artifact_resolution"
     Column      |  Type   | Null?                            
-----------------+---------+----------
 id              | integer | not null 
 resolution_name | text    | 

Table "SCHEMA.artifact_status"
   Column    |  Type   | Null?                          
-------------+---------+----------
 id          | integer | not null 
 status_name | text    | not null

*(Deprecated, Aug. 2005)*	View "SCHEMA.artifactperm_artgrouplist_vw"
      Column       |  Type   | Null? 
-------------------+---------+----------
 group_artifact_id | integer | 
 name              | text    | 
 description       | text    | 
 group_id          | integer | 
 user_id           | integer | 
 perm_level        | integer | 

*(Deprecated, Aug. 2005)*	View "SCHEMA.artifactperm_user_vw"
      Column       |         Type          | Null? 
-------------------+-----------------------+----------
 id                | integer               | 
 group_artifact_id | integer               | 
 user_id           | integer               | 
 perm_level        | integer               | 
 user_name         | text                  | 
 realname          | character varying(32) | 

*(Deprecated, Dec. 2004)*      Table "SCHEMA.audit_trail_group_data"
   Column    |          Type          | Null? 
-------------+------------------------+----------
 event_id    | integer                | not null
 field_name  | character varying(255) | not null
 old_value   | text                   | 
 new_value   | text                   | 
 row_modtime | integer                | 

Table "SCHEMA.db_images"
   Column    |  Type   | Null?                      
-------------+---------+----------
 id          | integer | not null
 group_id    | integer | not null 
 description | text    | not null 
 bin_data    | text    | not null 
 filename    | text    | not null 
 filesize    | integer | not null 
 filetype    | text    | not null 
 width       | integer | not null 
 height      | integer | not null 
 upload_date | integer | 
 version     | integer | 

Table "SCHEMA.doc_data"
   Column    |          Type          | Null?                     
-------------+------------------------+----------
 docid       | integer                | not null 
 stateid     | integer                | not null 
 title       | character varying(255) | not null 
 data        | text                   | not null 
 updatedate  | integer                | not null 
 createdate  | integer                | not null 
 created_by  | integer                | not null 
 doc_group   | integer                | not null 
 description | text                   | 
 language_id | integer                | not null 

Table "SCHEMA.doc_groups"
  Column   |          Type          | Null?                      
-----------+------------------------+----------
 doc_group | integer                | not null 
 groupname | character varying(255) | not null 
 group_id  | integer                | not null 

Table "SCHEMA.doc_states"
 Column  |          Type          | Null?                      
---------+------------------------+----------
 stateid | integer                | not null 
 name    | character varying(255) | not null 

Table "SCHEMA.forum"
      Column      |  Type   | Null?                    
------------------+---------+----------
 msg_id           | integer | not null 
 group_forum_id   | integer | not null 
 posted_by        | integer | not null 
 subject          | text    | not null 
 body             | text    | not null 
 date             | integer | not null 
 is_followup_to   | integer | not null 
 thread_id        | integer | not null 
 has_followups    | integer | 
 most_recent_date | integer | not null 
 is_deleted       | integer | 

Table "SCHEMA.forum_agg_msg_count"
     Column     |  Type   | Null?      
----------------+---------+----------
 group_forum_id | integer | not null 
 count          | integer | not null 

*Newly added, Feb. 2005*       Table "sf0205.forum_ftispool_new"
     Column     |  Type   | Null?                                       
----------------+---------+----------
 msg_id         | integer | not null
 group_id       | integer | 
 group_forum_id | integer | 
 subject        | text    | 
 body           | text    | 
 date           | integer | 
 user_name      | text    | 
 optype         | integer | not null 
 optimestamp    | integer | not null 

Table "SCHEMA.forum_group_list"
     Column      |  Type   | Null?                         
-----------------+---------+----------
 group_forum_id  | integer | not null 
 group_id        | integer | not null 
 forum_name      | text    | not null 
 is_public       | integer | not null 
 description     | text    | 
 allow_anonymous | integer | not null 

Table "SCHEMA.forum_threadinfo"
         Column         |  Type   | Null?                       
------------------------+---------+----------
 threadinfo_id          | integer | not null 
 thread_id              | integer | not null
 thread_topic           | text    | not null 
 thread_starter_user_id | integer | not null
 num_replies            | integer | 
 most_recent_post_date  | integer | 
 group_forum_id         | integer | not null
 msg_id                 | integer | not null

*(Deprecated, Aug. 2005)*	Table "SCHEMA.foundry_data"
          Column          |  Type   | Null?      
--------------------------+---------+----------
 foundry_id               | integer | not null 
 trove_categories         | text    | 
 member_image_id          | integer | 
 featured_member_image_id | integer | 

*(Deprecated, Aug. 2005)*	Table "SCHEMA.foundry_news"
     Column      |  Type   | Null?                       
-----------------+---------+----------
 foundry_news_id | integer | not null 
 foundry_id      | integer | not null 
 news_id         | integer | not null 
 approve_date    | integer | not null 
 is_approved     | integer | not null 

*(Deprecated, Aug. 2005)*	Table "SCHEMA.foundry_preferred_projects"
       Column       |  Type   | Null?                             
--------------------+---------+----------
 foundry_project_id | integer | not null 
 foundry_id         | integer | not null 
 group_id           | integer | not null 
 rank               | integer | not null 

*(Deprecated, Aug. 2005)*	Table "SCHEMA.foundry_project_downloads_agg"
     Column      |         Type          | Null? 
-----------------+-----------------------+----------
 foundry_id      | integer               | 
 downloads       | integer               | 
 group_id        | integer               | 
 group_name      | character varying(40) | 
 unix_group_name | character varying(30) | 

*(Deprecated, Aug. 2005)*	Table "SCHEMA.foundry_project_rankings_agg"
     Column      |         Type          | Null? 
-----------------+-----------------------+----------
 foundry_id      | integer               | 
 group_id        | integer               | 
 group_name      | character varying(40) | 
 unix_group_name | character varying(30) | 
 ranking         | integer               | 
 percentile      | double precision      | 

*(Deprecated, Aug. 2005)*	Table "SCHEMA.foundry_projects"
   Column   |  Type   | Null?                         
------------+---------+----------
 id         | integer | not null
 foundry_id | integer | not null 
 project_id | integer | not null 

*(Deprecated, Aug. 2005)*	Table "SCHEMA.frs_dlstats_file_agg"
  Column   |  Type   | Null? 
-----------+---------+----------
 month     | integer | 
 day       | integer | 
 file_id   | integer | 
 downloads | integer | 

*(Deprecated, Aug. 2005)*	Table "SCHEMA.frs_dlstats_filetotal_agg"
  Column   |  Type   | Null? 
-----------+---------+----------
 file_id   | integer | 
 downloads | integer | 

*(Deprecated, Aug. 2005)*	Table "SCHEMA.frs_dlstats_group_agg"
  Column   |  Type   | Null? 
-----------+---------+----------
 group_id  | integer | 
 month     | integer | 
 day       | integer | 
 downloads | integer | 

*(Deprecated, Aug. 2005)*	Table "SCHEMA.frs_dlstats_grouptotal_agg"
  Column   |  Type   | Null? 
-----------+---------+----------
 group_id  | integer | 
 downloads | numeric | 

Table "SCHEMA.frs_file"
    Column    |         Type          | Null?                     
--------------+-----------------------+----------
 file_id      | integer               | not null
 filename     | text                  | 
 release_id   | integer               | not null 
 type_id      | integer               | not null 
 processor_id | integer               | not null 
 release_time | integer               | not null 
 file_size    | integer               | not null 
 post_date    | integer               | not null 
 group_id     | integer               | 
 package_id   | integer               | 
 md5sum       | character varying(32) | 


Table "SCHEMA.frs_filetype"
 Column  |  Type   | Null?                       
---------+---------+----------
 type_id | integer | not null 
 name    | text    | 

Table "SCHEMA.frs_package"
   Column   |  Type   | Null?                       
------------+---------+----------
 package_id | integer | not null 
 group_id   | integer | not null 
 name       | text    | 
 status_id  | integer | not null 


Table "SCHEMA.frs_processor"
    Column    |  Type   | Null?                        
--------------+---------+----------
 processor_id | integer | not null
 name         | text    | 

Table "SCHEMA.frs_release"
    Column    |  Type   | Null?                       
--------------+---------+----------
 release_id   | integer | not null 
 package_id   | integer | not null 
 name         | text    | 
 notes        | text    | 
 changes      | text    | 
 status_id    | integer | not null 
 preformatted | integer | not null 
 release_date | integer | not null 
 released_by  | integer | not null 

*Newly added, Feb. 2005*      Table "sf0205.frs_snapshots"
     Column     |  Type   | Null?         
----------------+---------+----------
 filename       | text    | not null
 group_id       | integer | not null
 notes          | text    | not null
 file_size      | integer | not null
 post_timestamp | integer | not null
 post_uid       | integer | not null
 md5sum         | text    | 
 status_id      | integer | not null 

Table "SCHEMA.frs_status"
  Column   |  Type   | Null?                      
-----------+---------+----------
 status_id | integer | not null
 name      | text    | 

Table "SCHEMA.group_type"
 Column  |  Type   | Null?                      
---------+---------+----------
 type_id | integer | not null
 name    | text    | 

Table "SCHEMA.groups"
           Column           |          Type          | Null?                    
----------------------------+------------------------+----------
 group_id                   | integer                | not null
 group_name                 | character varying(40)  | 
 homepage                   | character varying(128) | 
 is_public                  | integer                | not null 
 status                     | character(1)           | not null
 unix_group_name            | character varying(30)  | not null
 http_domain                | character varying(80)  | 
 short_description          | character varying(255) | 
 license                    | character varying(16)  | 
 register_time              | integer                | not null 
 use_mail                   | integer                | not null 
 use_forum                  | integer                | not null 
 use_pm                     | integer                | not null 
 use_cvs                    | integer                | not null 
 use_news                   | integer                | not null 
 preferred_support_type     | integer                | not null 
 preferred_support_resource | text                   | not null
 type                       | integer                | not null 
 use_docman                 | integer                | not null 
 not_open_source            | integer                | not null 
 send_all_tasks             | integer                | not null 
 use_pm_depend_box          | integer                | not null 
 potm                       | integer                | 
 donation_request           | text                   | 
 donate_optin               | integer                | 
 big_mirror                 | integer                | 
 project_submitter          | integer                | 
 row_modtime                | integer                | 


Table "SCHEMA.groups_historical"
  Column  |  Type   | Null?      
----------+---------+----------
 group_id | integer | not null
 date     | integer | not null
 added_by | integer | not null
 status   | integer | not null 
 url      | text    | 

*(Deprecated, Aug. 2005)*        Table "SCHEMA.groups_moorman"
           Column           |          Type          | Null? 
----------------------------+------------------------+----------
 group_id                   | integer                | not null
 group_name                 | character varying(40)  | 
 homepage                   | character varying(128) | 
 is_public                  | integer                | 
 status                     | character(1)           | 
 unix_group_name            | character varying(30)  | 
 unix_box                   | character varying(20)  | 
 http_domain                | character varying(80)  | 
 short_description          | character varying(255) | 
 cvs_box                    | character varying(20)  | 
 license                    | character varying(16)  | 
 register_purpose           | text                   | 
 license_other              | text                   | 
 register_time              | integer                | 
 rand_hash                  | text                   | 
 use_mail                   | integer                | 
 use_survey                 | integer                | 
 use_forum                  | integer                | 
 use_pm                     | integer                | 
 use_cvs                    | integer                | 
 use_news                   | integer                | 
 preferred_support_type     | integer                | 
 preferred_support_resource | text                   | 
 donation_digest_email      | text                   | 
 type                       | integer                | 
 use_docman                 | integer                | 
 not_open_source            | integer                | 
 new_task_address           | text                   | 
 send_all_tasks             | integer                | 
 use_pm_depend_box          | integer                | 
 potm                       | integer                | 
 donation_request           | text                   | 
 donate_optin               | integer                | 
 paypal_id                  | character varying(80)  | 
 big_mirror                 | integer                | 
 is_subscribed              | integer                | 
 project_submitter          | integer                | 
 row_modtime                | integer                | 
 use_screenshots            | integer                | 
 use_snapshots              | integer                | 
 status_id                  | integer                | not null

Table "SCHEMA.mail_group_list"
    Column     |  Type   | Null?                         
---------------+---------+----------
 group_list_id | integer | not null 
 group_id      | integer | not null 
 list_name     | text    | 
 is_public     | integer | not null 
 list_admin    | integer | not null 
 status        | integer | not null 
 description   | text    | 
 row_modtime   | integer | 

Table "SCHEMA.mllist_subscriber_count"
      Column      |  Type   | Null? 
------------------+---------+----------
 ml_list_name     | text    | not null
 subscriber_count | integer | 

*Newly added, Aug. 2005*	Table "mysql_auth"
      Column      |  Type   | Modifiers 
------------------+---------+-----------
 group_id         | integer | not null
 passwd_rwuser    | text    | not null
 passwd_rouser    | text    | not null
 passwd_adminuser | text    | not null
 modified_by_uid  | integer | 
 row_modtime      | integer | 

Table "SCHEMA.news_bytes"
    Column    |  Type   | Null?                      
--------------+---------+----------
 id           | integer | not null
 group_id     | integer | not null 
 submitted_by | integer | not null 
 is_approved  | integer | not null 
 date         | integer | not null 
 forum_id     | integer | not null 
 summary      | text    | 
 details      | text    | 

*Newly added, Aug. 2005*	Table "ostg_contest"
  Column   |      Type        |        Modifiers                  
-----------+------------------+----------------------------------
 email     | text             | not null
 contest   | varchar(15)      | not null
 answer    | text             | 
 is_winner | integer          | default 0
 reg_time  | time	      | default 'now'


Table "SCHEMA.people_job"
   Column    |  Type   | Null?                      
-------------+---------+----------
 job_id      | integer | not null 
 group_id    | integer | not null 
 created_by  | integer | not null 
 title       | text    | 
 description | text    | 
 date        | integer | not null 
 status_id   | integer | not null 
 category_id | integer | not null 

Table "SCHEMA.people_job_category"
    Column    |  Type   | Null?                           
--------------+---------+----------
 category_id  | integer | not null 
 name         | text    | 
 private_flag | integer | not null 

Table "SCHEMA.people_job_inventory"
      Column      |  Type   | Null?                           
------------------+---------+----------
 job_inventory_id | integer | not null 
 job_id           | integer | not null 
 skill_id         | integer | not null 
 skill_level_id   | integer | not null 
 skill_year_id    | integer | not null 

Table "SCHEMA.people_job_status"
  Column   |  Type   | Null?                          
-----------+---------+----------
 status_id | integer | not null 
 name      | text    | 

*(Deprecated, Nov. 2004)*    Table "SCHEMA.people_skill"
  Column  |  Type   | Null?                       
----------+---------+----------
 skill_id | integer | not null
 name     | text    | 

Table "SCHEMA.people_skill_inventory"
       Column       |  Type   | Null?                            
--------------------+---------+----------
 skill_inventory_id | integer | not null
 user_id            | integer | not null 
 skill_id           | integer | not null 
 skill_level_id     | integer | not null 
 skill_year_id      | integer | not null 

Table "SCHEMA.people_skill_level"
     Column     |  Type   | Null?                          
----------------+---------+----------
 skill_level_id | integer | not null
 name           | text    | 

Table "SCHEMA.people_skill_year"
    Column     |  Type   | Null?                          
---------------+---------+----------
 skill_year_id | integer | not null
 name          | text    | 

*Newly added, Aug. 2005*	Table "pg_autovac_skip"
   Column   | Type | Modifiers 
------------+------+-----------
 table_name | text | not null

*(Deprecated, Aug. 2005)*	Table "SCHEMA.pgstattuple_type"
       Column       |       Type       
--------------------+------------------
 table_len          | bigint
 tuple_count        | bigint
 tuple_len          | bigint
 tuple_percent      | double precision
 dead_tuple_count   | bigint
 dead_tuple_len     | bigint
 dead_tuple_percent | double precision
 free_space         | bigint
 free_percent       | double precision

Table "SCHEMA.project_assigned_to"
       Column        |  Type   | Null?                           
---------------------+---------+----------
 project_assigned_id | integer | not null
 project_task_id     | integer | not null 
 assigned_to_id      | integer | not null 

Table "SCHEMA.project_dependencies"
         Column          |  Type   | Null?                        
-------------------------+---------+----------
 project_depend_id       | integer | not null
 project_task_id         | integer | not null 
 is_dependent_on_task_id | integer | not null 

Table "SCHEMA.project_group_list"
      Column      |  Type   | Null?                          
------------------+---------+----------
 group_project_id | integer | not null
 group_id         | integer | not null 
 project_name     | text    | not null
 is_public        | integer | not null 
 description      | text    | 

Table "SCHEMA.project_history"
       Column       |  Type   | Null?                         
--------------------+---------+----------
 project_history_id | integer | not null
 project_task_id    | integer | not null 
 field_name         | text    | not null
 old_value          | text    | not null
 mod_by             | integer | not null 
 date               | integer | not null 

*(Deprecated, Aug. 2005)*	Table "SCHEMA.project_metric"
   Column   |       Type       | Null?                        
------------+------------------+----------
 ranking    | integer          | not null 
 percentile | double precision | 
 group_id   | integer          | not null 

Table "SCHEMA.project_status"
   Column    |  Type   | Null?                        
-------------+---------+----------
 status_id   | integer | not null
 status_name | text    | not null

Table "SCHEMA.project_sums_agg"
  Column  |     Type     | Null?      
----------+--------------+----------
 group_id | integer      | not null 
 type     | character(4) | 
 count    | integer      | not null 

Table "SCHEMA.project_task"
      Column      |       Type       | Null?                      
------------------+------------------+----------
 project_task_id  | integer          | not null 
 group_project_id | integer          | not null 
 summary          | text             | not null 
 details          | text             | not null 
 percent_complete | integer          | not null 
 priority         | integer          | not null 
 hours            | double precision | not null 
 start_date       | integer          | not null 
 end_date         | integer          | not null 
 created_by       | integer          | not null 
 status_id        | integer          | not null 

*(Deprecated, Aug. 2005)*	Table "SCHEMA.project_weekly_metric"
   Column   |       Type       | Null?                            
------------+------------------+----------
 ranking    | integer          | not null 
 percentile | double precision | 
 group_id   | integer          | not null 

*Newly added, Dec. 2004*      Table "SCHEMA.ref_timezones"
    Column     |  Type   | Null?                        
---------------+---------+----------
 timezone_id   | integer | not null
 timezone_name | text    | not null
 row_modtime   | integer | 

*Newly added, Dec. 2004*       Table "SCHEMA.screenshots"
        Column        |         Type          | Null?             
----------------------+-----------------------+----------
 screenshot_id        | integer               | not null
 group_id             | integer               | not null 
 main_image_id        | integer               | not null 
 thumb_image_id       | integer               | not null 
 main_width           | integer               | not null 
 main_height          | integer               | not null 
 thumb_width          | integer               | not null 
 thumb_height         | integer               | not null 
 description          | character varying(60) | not null 
 lastchange_timestamp | integer               | not null 
 lastchange_uid       | integer               | not null 

*(Deprecated, Aug. 2005)*	Table "SCHEMA.search_data_groups"
      Column       |          Type          | Null? 
-------------------+------------------------+----------
 group_id          | integer                | not null
 group_name        | character varying(40)  | 
 unix_group_name   | character varying(30)  | 
 short_description | character varying(255) | 
 group_ranking     | integer                | 
 has_file          | integer                | 
 percentile        | double precision       | 
 is_subscribed     | integer                | 

*(Deprecated, Aug. 2005)*	Table "SCHEMA.stats_agg_logo_by_day"
 Column |  Type   | Null? 
--------+---------+----------
 day    | integer | 
 count  | integer | 

*(Deprecated, Aug. 2005)*	Table "SCHEMA.stats_agg_logo_by_group"
  Column  |  Type   | Null? 
----------+---------+----------
 month    | integer | 
 day      | integer | 
 group_id | integer | 
 count    | integer | 

*(Deprecated, Aug. 2005)*	Table "SCHEMA.stats_agg_pages_by_day"
 Column |  Type   | Null?      
--------+---------+----------
 day    | integer | not null 
 count  | integer | not null 

*(Deprecated, Aug. 2005)*	Table "SCHEMA.stats_agg_site_by_group"
  Column  |  Type   | Null? 
----------+---------+----------
 month    | integer | 
 day      | integer | 
 group_id | integer | 
 count    | integer | 

Table "SCHEMA.stats_cvs_group"
  Column   |  Type   | Null?      
-----------+---------+----------
 month     | integer | not null 
 day       | integer | not null 
 group_id  | integer | not null 
 checkouts | integer | not null 
 commits   | integer | not null 
 adds      | integer | not null 

*(Deprecated, Aug. 2005)*	Table "SCHEMA.stats_ftp_downloads"
     Column     |  Type   | Null?      
----------------+---------+----------
 day            | integer | not null 
 filerelease_id | integer | not null 
 group_id       | integer | not null 
 downloads      | integer | not null 

*Newly added, Aug. 2005*	Table "SCHEMA.stats_fileid_alltime_agg"
  Column   |  Type   |          Modifiers           
-----------+---------+------------------------------
 file_id   | integer | not null default 0
 downloads | integer | not null default 0
 bytes     | bigint  | not null default (0)::bigint

*Newly added, Mar. 2005*	Table "SCHEMA.stats_group_rank"
 Column  |  Type   | Null?      
---------+---------+----------
 groupid | integer | not null 
 score   | integer | not null 
 rank    | integer | not null 

*Newly added, Mar. 2005*	Table "stats_group_rank_alltime"
   Column   |       Type       |     Modifiers      
------------+------------------+--------------------
 group_id   | integer          | not null default 0
 ranking    | integer          | not null default 0
 percentile | double precision | 

*Newly added, Mar. 2005*	Table "stats_group_rank_byday"
   Column   |       Type       |     Modifiers      
------------+------------------+--------------------
 rankdate   | integer          | not null default 0
 group_id   | integer          | not null default 0
 ranking    | integer          | not null default 0
 percentile | double precision | 
 score      | integer          | not null default 0

*Newly added, Mar. 2005*	Table "stats_group_rank_bymonth"
   Column   |       Type       |          Modifiers           
------------+------------------+------------------------------
 group_id   | integer          | not null default 0
 rankdate   | integer          | not null default 0
 ranking    | integer          | not null default 0
 percentile | double precision | default 0.0
 score      | bigint           | not null default (0)::bigint

*Newly added, Mar. 2005*	Table "stats_groupid_alltime_agg"
  Column   |  Type   |          Modifiers           
-----------+---------+------------------------------
 group_id  | integer | not null default 0
 downloads | integer | not null default 0
 bytes     | bigint  | not null default (0)::bigint

*Newly added, Mar. 2005*	Table "stats_multi_rank_history_byday"
          Column           |       Type       |               Modifiers        
---------------------------+------------------+--------------------------------
 group_id                  | integer          | not null default 0
 timekey                   | integer          | not null default 0
 prweb_7day                | integer          | not null default 0
 prweb_7day_rank           | integer          | not null default 0
 prweb_7day_percentile     | double precision | default (0)::dp
 sflogo_7day               | integer          | not null default 0
 sflogo_7day_rank          | integer          | not null default 0
 sflogo_7day_percentile    | double precision | default (0)::dp
 sfweb_7day                | integer          | not null default 0
 sfweb_7day_rank           | integer          | not null default 0
 sfweb_7day_percentile     | double precision | default (0)::dp
 forum_7day                | integer          | not null default 0
 forum_7day_rank           | integer          | not null default 0
 forum_7day_percentile     | double precision | default (0)::dp
 downloads_7day            | integer          | not null default 0
 downloads_7day_rank       | integer          | not null default 0
 downloads_7day_percentile | double precision | default (0)::dp
 tracker_7day              | integer          | not null default 0
 tracker_7day_rank         | integer          | not null default 0
 tracker_7day_percentile   | double precision | default (0)::dp
 cvs_7day                  | integer          | not null default 0
 cvs_7day_rank             | integer          | not null default 0
 cvs_7day_percentile       | double precision | not null default (0)::dp
 mlist_7day                | integer          | 
 mlist_7day_rank           | integer          | 
 mlist_7day_percentile     | integer          | 
 last_file_release         | integer          | 
 last_admin_login          | integer          | 

*(Deprecated, Aug. 2005)*	Table "SCHEMA.stats_http_downloads"
     Column     |  Type   | Null?      
----------------+---------+----------
 day            | integer | not null 
 filerelease_id | integer | not null 
 group_id       | integer | not null 
 downloads      | integer | not null 

*(Deprecated, Aug. 2005)*	Table "SCHEMA.stats_project"
      Column      |  Type   | Null?      
------------------+---------+----------
 month            | integer | not null 
 day              | integer | not null 
 group_id         | integer | not null 
 file_releases    | integer | 
 msg_posted       | integer | 
 msg_uniq_auth    | integer | 
 bugs_opened      | integer | 
 bugs_closed      | integer | 
 support_opened   | integer | 
 support_closed   | integer | 
 patches_opened   | integer | 
 patches_closed   | integer | 
 artifacts_opened | integer | 
 artifacts_closed | integer | 
 tasks_opened     | integer | 
 tasks_closed     | integer | 
 help_requests    | integer | 

Table "SCHEMA.stats_project_all"
      Column      |       Type       | Null? 
------------------+------------------+----------
 group_id         | integer          | 
 developers       | integer          | 
 group_ranking    | integer          | 
 group_metric     | double precision | 
 logo_showings    | integer          | 
 downloads        | integer          | 
 site_views       | integer          | 
 subdomain_views  | integer          | 
 page_views       | integer          | 
 msg_posted       | integer          | 
 msg_uniq_auth    | integer          | 
 bugs_opened      | integer          | 
 bugs_closed      | integer          | 
 support_opened   | integer          | 
 support_closed   | integer          | 
 patches_opened   | integer          | 
 patches_closed   | integer          | 
 artifacts_opened | integer          | 
 artifacts_closed | integer          | 
 tasks_opened     | integer          | 
 tasks_closed     | integer          | 
 help_requests    | integer          | 
 cvs_checkouts    | integer          | 
 cvs_commits      | integer          | 
 cvs_adds         | integer          | 

*Newly added, Mar. 2005*	Table "stats_rank_oldformula_byday"
   Column   |       Type       |     Modifiers          
------------+------------------+--------------------------------
 rankdate   | integer          | not null default 0
 group_id   | integer          | not null default 0
 ranking    | integer          | not null default 0
 percentile | double precision | not null default 0


*Newly added, Mar. 2005*	Table "stats_sfweb_recent_hit"
   Column   |  Type   |     Modifiers      
------------+---------+--------------------
 group_id   | integer | not null default 0
 week_hits  | integer | not null default 0
 month_hits | integer | not null default 0

*(Deprecated, Aug. 2005)*	Table "SCHEMA.stats_project_developers"
   Column   |  Type   | Null?      
------------+---------+----------
 month      | integer | not null 
 day        | integer | not null 
 group_id   | integer | not null 
 developers | integer | not null 

*(Deprecated, Aug. 2005)*	Table "SCHEMA.stats_project_developers_last30"
   Column   |  Type   | Null? 
------------+---------+----------
 month      | integer | 
 day        | integer | 
 group_id   | integer | 
 developers | integer | 

*(Deprecated, Aug. 2005)*	Table "SCHEMA.stats_project_last_30"
      Column      |       Type       | Null? 
------------------+------------------+----------
 month            | integer          | 
 day              | integer          | 
 group_id         | integer          | 
 developers       | integer          | 
 group_ranking    | integer          | 
 group_metric     | double precision | 
 logo_showings    | integer          | 
 downloads        | integer          | 
 site_views       | integer          | 
 subdomain_views  | integer          | 
 page_views       | integer          | 
 filereleases     | integer          | 
 msg_posted       | integer          | 
 msg_uniq_auth    | integer          | 
 bugs_opened      | integer          | 
 bugs_closed      | integer          | 
 support_opened   | integer          | 
 support_closed   | integer          | 
 patches_opened   | integer          | 
 patches_closed   | integer          | 
 artifacts_opened | integer          | 
 artifacts_closed | integer          | 
 tasks_opened     | integer          | 
 tasks_closed     | integer          | 
 help_requests    | integer          | 
 cvs_checkouts    | integer          | 
 cvs_commits      | integer          | 
 cvs_adds         | integer          | 

*(Deprecated, Aug. 2005)*	Table "SCHEMA.stats_project_metric"
   Column   |       Type       | Null?      
------------+------------------+----------
 month      | integer          | not null 
 day        | integer          | not null 
 ranking    | integer          | not null 
 percentile | double precision | not null 
 group_id   | integer          | not null 

*(Deprecated, Aug. 2005)*	Table "SCHEMA.stats_project_months"
      Column      |       Type       | Null? 
------------------+------------------+----------
 month            | integer          | 
 group_id         | integer          | 
 developers       | integer          | 
 group_ranking    | integer          | 
 group_metric     | double precision | 
 logo_showings    | integer          | 
 downloads        | integer          | 
 site_views       | integer          | 
 subdomain_views  | integer          | 
 page_views       | integer          | 
 file_releases    | integer          | 
 msg_posted       | integer          | 
 msg_uniq_auth    | integer          | 
 bugs_opened      | integer          | 
 bugs_closed      | integer          | 
 support_opened   | integer          | 
 support_closed   | integer          | 
 patches_opened   | integer          | 
 patches_closed   | integer          | 
 artifacts_opened | integer          | 
 artifacts_closed | integer          | 
 tasks_opened     | integer          | 
 tasks_closed     | integer          | 
 help_requests    | integer          | 
 cvs_checkouts    | integer          | 
 cvs_commits      | integer          | 
 cvs_adds         | integer          | 

*(Deprecated, Aug. 2005)*	Table "SCHEMA.stats_site"
    Column    |  Type   | Null? 
--------------+---------+----------
 month        | integer | 
 day          | integer | 
 uniq_users   | integer | 
 sessions     | integer | 
 total_users  | integer | 
 new_users    | integer | 
 new_projects | integer | 

*(Deprecated, Aug. 2005)*	View "SCHEMA.stats_site_all"
      Column      |  Type  | Null? 
------------------+--------+----------
 site_page_views  | bigint | 
 downloads        | bigint | 
 subdomain_views  | bigint | 
 msg_posted       | bigint | 
 bugs_opened      | bigint | 
 bugs_closed      | bigint | 
 support_opened   | bigint | 
 support_closed   | bigint | 
 patches_opened   | bigint | 
 patches_closed   | bigint | 
 artifacts_opened | bigint | 
 artifacts_closed | bigint | 
 tasks_opened     | bigint | 
 tasks_closed     | bigint | 
 help_requests    | bigint | 
 cvs_checkouts    | bigint | 
 cvs_commits      | bigint | 
 cvs_adds         | bigint | 

*(Deprecated, Aug. 2005)*	Table "SCHEMA.stats_site_last_30"
      Column      |  Type   | Null? 
------------------+---------+----------
 month            | integer | 
 day              | integer | 
 site_page_views  | integer | 
 downloads        | integer | 
 subdomain_views  | integer | 
 msg_posted       | integer | 
 bugs_opened      | integer | 
 bugs_closed      | integer | 
 support_opened   | integer | 
 support_closed   | integer | 
 patches_opened   | integer | 
 patches_closed   | integer | 
 artifacts_opened | integer | 
 artifacts_closed | integer | 
 tasks_opened     | integer | 
 tasks_closed     | integer | 
 help_requests    | integer | 
 cvs_checkouts    | integer | 
 cvs_commits      | integer | 
 cvs_adds         | integer | 

*(Deprecated, Aug. 2005)*	Table "SCHEMA.stats_site_months"
      Column      |  Type   | Null? 
------------------+---------+----------
 month            | integer | 
 site_page_views  | integer | 
 downloads        | integer | 
 subdomain_views  | integer | 
 msg_posted       | integer | 
 bugs_opened      | integer | 
 bugs_closed      | integer | 
 support_opened   | integer | 
 support_closed   | integer | 
 patches_opened   | integer | 
 patches_closed   | integer | 
 artifacts_opened | integer | 
 artifacts_closed | integer | 
 tasks_opened     | integer | 
 tasks_closed     | integer | 
 help_requests    | integer | 
 cvs_checkouts    | integer | 
 cvs_commits      | integer | 
 cvs_adds         | integer | 

*(Deprecated, Aug. 2005)*	Table "SCHEMA.stats_site_pages_by_day"
     Column      |  Type   | Null? 
-----------------+---------+----------
 month           | integer | 
 day             | integer | 
 site_page_views | integer | 

*(Deprecated, Aug. 2005)*	View "SCHEMA.stats_site_pages_by_month"
     Column      |  Type   | Null? 
-----------------+---------+----------
 month           | integer | 
 site_page_views | bigint  | 

*(Deprecated, Aug. 2005)*	Table "SCHEMA.stats_subd_pages"
  Column   |  Type   | Null?      
-----------+---------+----------
 month     | integer | not null 
 day       | integer | not null 
 group_id  | integer | not null 
 pages     | integer | not null 
 bytecount | bigint  | 

Table "SCHEMA.supported_languages"
    Column     |     Type     | Null?                           
---------------+--------------+----------
 language_id   | integer      | not null 
 name          | text         | 
 filename      | text         | 
 classname     | text         | 
 language_code | character(2) | 

Table "SCHEMA.top_group"
          Column          |         Type          | Null?      
--------------------------+-----------------------+----------
 group_id                 | integer               | not null 
 group_name               | character varying(40) | 
 downloads_all            | integer               | not null 
 rank_downloads_all       | integer               | not null 
 rank_downloads_all_old   | integer               | not null 
 downloads_week           | integer               | not null 
 rank_downloads_week      | integer               | not null 
 rank_downloads_week_old  | integer               | not null 
 userrank                 | integer               | not null 
 rank_userrank            | integer               | not null 
 rank_userrank_old        | integer               | not null 
 forumposts_week          | integer               | not null 
 rank_forumposts_week     | integer               | not null 
 rank_forumposts_week_old | integer               | not null 
 pageviews_proj           | integer               | not null 
 rank_pageviews_proj      | integer               | not null 
 rank_pageviews_proj_old  | integer               | not null 

Table "SCHEMA.trove_agg"
      Column       |          Type          | Null? 
-------------------+------------------------+----------
 trove_cat_id      | integer                | 
 group_id          | integer                | 
 group_name        | character varying(40)  | 
 unix_group_name   | character varying(30)  | 
 status            | character(1)           | 
 register_time     | integer                | 
 short_description | character varying(255) | 
 donate_optin      | integer                | 
 percentile        | double precision       | 
 ranking           | integer                | 

Table "SCHEMA.trove_agg_counts"
    Column    |  Type   | Null? 
--------------+---------+----------
 trove_cat_id | integer | not null
 group_count  | integer | 

*Newly added, Aug. 2005*	Table "trove_agg_minix"

Table "SCHEMA.trove_cat"
    Column    |          Type          | Null?                      
--------------+------------------------+----------
 trove_cat_id | integer                | not null
 version      | integer                | not null 
 parent       | integer                | not null 
 root_parent  | integer                | not null 
 shortname    | character varying(80)  | 
 fullname     | character varying(80)  | 
 description  | character varying(255) | 
 fullpath     | text                   | not null
 fullpath_ids | text                   | 
 parent_only  | integer                | not null 

Table "SCHEMA.trove_group_link"
      Column       |  Type   | Null?                         
-------------------+---------+----------
 trove_group_id    | integer | not null 
 trove_cat_id      | integer | not null 
 trove_cat_version | integer | not null 
 group_id          | integer | not null 
 trove_cat_root    | integer | not null 

*Newly added, Dec. 2004*       Table "SCHEMA.trove_ref_translation_to_iso639"
    Column    |  Type   | Null? 
--------------+---------+----------
 trove_cat_id | integer | not null
 lang_code    | text    | not null

Table "SCHEMA.trove_treesums"
      Column       |  Type   | Null?                              
-------------------+---------+----------
 trove_treesums_id | integer | not null
 trove_cat_id      | integer | not null 
 subprojects       | integer | not null 

*(Deprecated, Aug. 2005)*	Table "SCHEMA.tsdebug"
   Column    |  Type  
-------------+--------
 ts_name     | text
 tok_type    | text
 description | text
 token       | text
 dict_name   | text[]

Table "SCHEMA.user_diary"
   Column    |  Type   | Null?                      
-------------+---------+----------
 id          | integer | not null
 user_id     | integer | not null 
 date_posted | integer | not null 
 summary     | text    | 
 details     | text    | 
 is_public   | integer | not null 

Table "SCHEMA.user_group"
     Column     |     Type      | Null?                      
----------------+---------------+----------
 user_group_id  | integer       | not null 
 user_id        | integer       | not null 
 group_id       | integer       | not null 
 admin_flags    | character(16) | not null 
 forum_flags    | integer       | not null 
 project_flags  | integer       | not null 
 doc_flags      | integer       | not null 
 member_role    | integer       | not null 
 release_flags  | integer       | not null 
 artifact_flags | integer       | 
 added_by       | integer       | not null 
 grantcvs       | integer       | not null 
 grantshell     | integer       | not null 
 row_modtime    | integer       | 

Table "SCHEMA.users"
        Column        |         Type          | Null?                    
----------------------+-----------------------+----------
 user_id              | integer               | not null
 user_name            | text                  | not null
 realname             | character varying(32) | not null
 status               | character(1)          | not null
 unix_uid             | integer               | 
 add_date             | integer               | not null 
 people_resume        | text                  | not null 
 timezone             | character varying(64) | 
 language             | integer               | not null 
 cf_uid               | integer               | 
 stay_anon            | integer               | 
 donation_request     | text                  | 
 donate_optin         | integer               | 
 last_sitestatus_view | integer               | 
 row_modtime          | integer               |