/[A3C]/data/stats/stats.sql
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /data/stats/stats.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 246 by dpavlin, Mon Oct 13 12:30:59 2008 UTC revision 247 by dpavlin, Mon Oct 13 13:48:00 2008 UTC
# Line 43  order by l, o Line 43  order by l, o
43  ;  ;
44    
45  select * from stats.instance_organization limit 1;  select * from stats.instance_organization limit 1;
46    
47    create table stats.monthly_visits (
48            instance text not null,
49            visits int not null,
50            month int not null,
51            first timestamp,
52            last timestamp,
53            primary key(instance,month)
54    );
55    
56    \copy stats.monthly_visits from 'monthly-visits.tsv'
57    
58    select * from stats.monthly_visits limit 1;
59    
60    create table stats.monthly_changes (
61            instance text not null,
62            changes int not null,
63            month int not null,
64            first timestamp,
65            last timestamp,
66            primary key(instance,month)
67    );
68    
69    \copy stats.monthly_changes from 'monthly-changes.tsv'
70    
71    select * from stats.monthly_changes limit 1;

Legend:
Removed from v.246  
changed lines
  Added in v.247

  ViewVC Help
Powered by ViewVC 1.1.26