-- Drop the table if exists
DROP TABLE IF EXISTS data_collector;

-- Create the table and then add the geometry column to the table
CREATE TABLE data_collector (
	cartodb_id bigserial primary key,
	description varchar(70),
	name varchar(35)
);

SELECT AddGeometryColumn('', 'data_collector', 'dc_geom', 4326, 'GEOMETRY', 2);
