# sql_statements_log

time_start: 2016-01-06T10:40:42.509Z
time_end: 2016-01-06T10:40:42.991Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ROWID, "PK_UID", "Name_l", "Region", "Name_s", "Shape_Leng", "Shape_Area", "Geometry"
FROM "BiogeoRegions2015-1"
ORDER BY ROWID


time_start: 2016-01-06T10:41:05.846Z
time_end: 2016-01-06T10:41:19.081Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ROWID, "PK_UID", "Name_l", "Region", "Name_s", "Shape_Leng", "Shape_Area", st_isvalidreason(Geometry)
FROM "BiogeoRegions2015-1"
where 
st_isvalid(Geometry) = 0


time_start: 2016-01-08T10:00:58.762Z
time_end: 2016-01-08T10:01:00.784Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE BiogeoRegions2015 AS SELECT short_name, pre_2012, code, name, geometry
FROM "BiogeoRegions2015-1"


time_start: 2016-01-08T10:02:43.917Z
time_end: 2016-01-08T10:02:44.168Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE BiogeoRegions2015(
"PK_UID" INTEGER PRIMARY KEY AUTOINCREMENT,
  short_name TEXT,
  pre_2012 TEXT,
  code,
  name TEXT,
  geometry NUM
)


time_start: 2016-01-08T10:03:11.015Z
time_end: 2016-01-08T10:03:11.140Z
user_agent: spatialite_gui
error_cause: SQL error: table BiogeoRegions2015 has 6 columns but 5 values were supplied
sql_statement:
INSERT INTO BiogeoRegions2015 SELECT short_name, pre_2012, code, name, geometry FROM "BiogeoRegions2015-1";


time_start: 2016-01-08T10:03:26.160Z
time_end: 2016-01-08T10:03:27.228Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO BiogeoRegions2015 SELECT PK_UID, short_name, pre_2012, code, name, geometry FROM "BiogeoRegions2015-1";


