To delete old data for registrators which do not make sense, use the following::

   delete from stats_datapoint where id in (select stats_datapoint.id from stats_datapoint join stats_datatype on stats_datapoint.data_type_id = stats_datatype.id where code_name='domains_by_registrator' and date < '2003-09-1');



To fix two missing points in the number of domains statistics::

   UPDATE stats_datapoint SET amount=220910 FROM stats_datatype WHERE data_type_id=stats_datatype.id AND code_name='number_of_domains' AND date='2005-11-11' AND amount=0;

   UPDATE stats_datapoint SET amount=201196 FROM stats_datatype WHERE data_type_id=stats_datatype.id AND code_name='number_of_domains' AND date='2003-05-28' AND amount=0;



Rename www to web in hosting statistics::

   update stats_texttointmap set text='web' where text='www';
