ALTER TABLE network ADD COLUMN "source" integer;
ALTER TABLE network ADD COLUMN "target" integer;
-- UPDATE network set geom = ST_Reverse(geom);
ALTER TABLE network ADD CONSTRAINT network_pk PRIMARY KEY (id);
CREATE INDEX network_idx ON network(id);
SELECT pgr_createTopology('network', 0.0000001, 'geom', 'id');
ALTER TABLE network_vertices_pgr RENAME the_geom to geom;
