cvs: pearweb /sql aggregated_package_stats.sql

cellog          Tue Oct 17 15:23:06 2006 UTC

  Added files:                 
    /pearweb/sql        aggregated_package_stats.sql 
  Log:
  structure of new aggregated statistics table, which will replace the 
downloads table
  

http://cvs.php.net/viewvc.cgi/pearweb/sql/aggregated_package_stats.sql?view=markup&rev=1.1
Index: pearweb/sql/aggregated_package_stats.sql
+++ pearweb/sql/aggregated_package_stats.sql
-- COLUMN          REFERENCES
--
-- package_id      packages(id)
-- release_id      releases(id)

CREATE TABLE aggregated_package_stats (
  package_id int(11) NOT NULL default '0',
  release_id int(11) NOT NULL default '0',
  yearmonth date NOT NULL default '0000-00-00',
  downloads int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (release_id,yearmonth),
  KEY package_id (package_id),
  KEY downloads (downloads)
)

-- 
PEAR CVS Mailing List (http://pear.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php