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; |