# sql_statements_log

time_start: 2019-08-02T12:14:45.426Z
time_end: 2019-08-02T12:14:48.228Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT AddGeometryColumn ('fingerprints', 'Geometry', 32633, 'POINT', 2);

UPDATE fingerprints SET Geometry=MakePoint(x, y, 32633);

SELECT CreateSpatialIndex('fingerprints', 'Geometry');

CREATE INDEX dist_angle
ON "fingerprints"
(
dist,angle
);

CREATE INDEX id_idx
ON "fingerprints"
(
poleid
);


time_start: 2019-08-02T12:15:10.713Z
time_end: 2019-08-02T12:15:12.912Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT AddGeometryColumn ('fingerprintsWalls', 'Geometry', 32633, 'LINESTRING', 2);

UPDATE fingerprintsWalls SET Geometry=MakeLine(MakePoint(x1, y1, 32633),MakePoint(x2, y2, 32633));

SELECT CreateSpatialIndex('fingerprintsWalls', 'Geometry');

CREATE INDEX idwall_idx
ON "fingerprintsWalls"
(
id
);

CREATE INDEX dist_angle_walls
ON "fingerprintsWalls"
(
dist,angle
);

CREATE INDEX oXoY_walls
ON "fingerprintsWalls"
(
oX,oY
);


