create table tbping (
	id integer not null primary key,
	lat float,
	lng float,
	title varchar(255),
	excerpt text,
	url varchar(255),
	blog_name varchar(255),
	created_on timestamp not null,
	modified_on timestamp not null
);
create index tbping_lat on tbping (lat);
create index tbping_lng on tbping (lng);
create index tbping_created_on on tbping (created_on);