--- data/stats/stats.sql 2008/10/13 12:30:59 246 +++ data/stats/stats.sql 2008/10/13 13:48:00 247 @@ -43,3 +43,29 @@ ; select * from stats.instance_organization limit 1; + +create table stats.monthly_visits ( + instance text not null, + visits int not null, + month int not null, + first timestamp, + last timestamp, + primary key(instance,month) +); + +\copy stats.monthly_visits from 'monthly-visits.tsv' + +select * from stats.monthly_visits limit 1; + +create table stats.monthly_changes ( + instance text not null, + changes int not null, + month int not null, + first timestamp, + last timestamp, + primary key(instance,month) +); + +\copy stats.monthly_changes from 'monthly-changes.tsv' + +select * from stats.monthly_changes limit 1;