<ul>
					<li><i>InitSpatialMetaData()</i></li>
					<li><i>InitAdvancedMetaData()</i></li>
					<li><i>CreateRasterCoveragesTable()</i></li>
					<li><i>CreateVectorCoveragesTables()</i></li>
					<li><i>CreateStylingTables()</i></li>
				</ul>the return type is Integer, with a return value of 1 for TRUE or 0 for FALSE</td></tr>


















			<tr><td><b>InsertEpsgSrid</b></td>
				<td>InsertEpsgSrid( srid <i>Integer</i> ) : <i>Integer</i></td>
				<td></td>
				<td align="center" bgcolor="#d0f0d0">base</td>
				<td>Attempts to insert into <b>spatial_ref_sys</b> the EPSG definition uniquely identified by <b>srid</b><br>
				[the corresponding EPSG SRID definition will be copied from the inlined dataset defined in <b>libspatialite</b>]<hr>
the return type is Integer, with a return value of 1 for success or 0 for failure</td></tr>

				<ul>
					<li><i>InitSpatialMetaData()</i></li>
					<li><i>InitAdvancedMetaData()</i></li>
					<li><i>CreateRasterCoveragesTable()</i></li>
					<li><i>CreateVectorCoveragesTables()</i></li>
					<li><i>CreateStylingTables()</i></li>
				</ul>the return type is Integer, with a return value of 1 for TRUE or 0 for FALSE</td></tr>
			<tr><td><b>CreateMissingSystemTables</b></td>
				<td>CreateMissingSystemTables( void ) : <i>Integer</i><hr>
					CreateMissingSystemTables( relaxed <i>Integer</i> ) : <i>Integer</i><hr>
					CreateMissingSystemTables( relaxed <i>Integer</i> , transaction <i>Integer</i> ) : <i>Integer</i>
				<td></td>
				<td align="center" bgcolor="#d0f0d0">base</td>
				<td>This function will create any missing ancillary metadata table required by <b>libspatialite v.5</b> and subsequent versions.</v><br>
				<ul>
					<li>the <i>optional</i> argument <b>relaxed</b> has the same interpretation as in <b>CreateStylingTables()</b>:
					if it is explicitly set as <b>TRUE</b> then
					a <i>relaxed</i> version of the validating Triggers will be installed (not checking for strict <i><u>XSD schema validation</u></i>).</li>
					<li>if the <i>optional</i> argument <b>transaction</b> is explicitly set as <b>TRUE</b> then 
					the whole operation will be atomically confined within a monolithic SQL transaction</li>
				</ul>
				The return type is Integer, with a return value of 1 on success.<br>
				An exception will be raised on invalid arguments or on failure.<hr>
				<b>Note</b>: this SQL function is intended for safely upgrading
				old databases created by earlier versions; it's absolutely harmless because any existing MetaTable will be left untouched.</td></tr>
			<tr><td><b>InsertEpsgSrid</b></td>
				<td>InsertEpsgSrid( srid <i>Integer</i> ) : <i>Integer</i></td>
				<td></td>
				<td align="center" bgcolor="#d0f0d0">base</td>
				<td>Attempts to insert into <b>spatial_ref_sys</b> the EPSG definition uniquely identified by <b>srid</b><br>
				[the corresponding EPSG SRID definition will be copied from the inlined dataset defined in <b>libspatialite</b>]<hr>
the return type is Integer, with a return value of 1 for success or 0 for failure</td></tr>

#ifdef _WIN32
    SPATIALITE_PRIVATE void splite_pause_windows (void);
#else
    SPATIALITE_PRIVATE void splite_pause_signal (void);
#endif

    SPATIALITE_PRIVATE void finalize_topologies (const void *p_cache);






















































#ifdef __cplusplus
}
#endif

#endif				/* _SPATIALITE_PRIVATE_H */

#ifdef _WIN32
    SPATIALITE_PRIVATE void splite_pause_windows (void);
#else
    SPATIALITE_PRIVATE void splite_pause_signal (void);
#endif

    SPATIALITE_PRIVATE void finalize_topologies (const void *p_cache);

    SPATIALITE_PRIVATE int create_data_licenses (sqlite3 * sqlite);

    SPATIALITE_PRIVATE int create_geometry_columns_time (sqlite3 * sqlite);

    SPATIALITE_PRIVATE int create_spatial_ref_sys_aux (sqlite3 * handle);

    SPATIALITE_PRIVATE int create_raster_coverages (sqlite3 * sqlite);

    SPATIALITE_PRIVATE int create_vector_coverages (sqlite3 * sqlite);

    SPATIALITE_PRIVATE int create_wms_tables (sqlite3 * sqlite);

    SPATIALITE_PRIVATE int create_external_graphics (sqlite3 * sqlite);

    SPATIALITE_PRIVATE int create_fonts (sqlite3 * sqlite);

    SPATIALITE_PRIVATE int create_raster_styles (sqlite3 * sqlite, int relaxed);

    SPATIALITE_PRIVATE int create_raster_styled_layers (sqlite3 * sqlite);

    SPATIALITE_PRIVATE int create_vector_styles (sqlite3 * sqlite, int relaxed);

    SPATIALITE_PRIVATE int create_vector_styled_layers (sqlite3 * sqlite);

    SPATIALITE_PRIVATE int create_iso_metadata (sqlite3 * sqlite, int relaxed);

    SPATIALITE_PRIVATE int create_iso_metadata_reference (sqlite3 * sqlite);

    SPATIALITE_PRIVATE int create_iso_metadata_view (sqlite3 * sqlite);

    SPATIALITE_PRIVATE int create_rl2map_configurations (sqlite3 * sqlite,
							 int relaxed);

    SPATIALITE_PRIVATE int create_rl2map_configurations_view (sqlite3 * sqlite);

    SPATIALITE_PRIVATE int create_external_graphics_view (sqlite3 * sqlite);

    SPATIALITE_PRIVATE int create_fonts_view (sqlite3 * sqlite);

    SPATIALITE_PRIVATE int create_raster_styled_layers_view (sqlite3 * sqlite);

    SPATIALITE_PRIVATE int create_raster_styles_view (sqlite3 * sqlite);

    SPATIALITE_PRIVATE int create_vector_styles_view (sqlite3 * sqlite);

    SPATIALITE_PRIVATE int create_vector_styled_layers_view (sqlite3 * sqlite);

    SPATIALITE_PRIVATE int createMissingSystemTables (sqlite3 * sqlite,
						      const void *cache,
						      int relaxed,
						      int transaction,
						      char **err_msg);

#ifdef __cplusplus
}
#endif

#endif				/* _SPATIALITE_PRIVATE_H */

    if (strcasecmp (tbl_name, "geom_cols_ref_sys") == 0)
      {
	  *sys_scope = sqlite3_mprintf ("CRS Catalog");
	  return 1;
      }
    if (strcasecmp (tbl_name, "spatial_ref_sys_all") == 0)
      {
	  *sys_scope = sqlite3_mprintf ("Spatial Tables Catalog");
	  return 1;
      }
    if (strcasecmp (tbl_name, "raster_coverages_ref_sys") == 0)
      {
	  *sys_scope = sqlite3_mprintf ("Raster Coverages Catalog");
	  return 1;
      }
................................................................................
      }
    if (strcasecmp (tbl_name, "SE_external_graphics_view") == 0
	|| strcasecmp (tbl_name, "SE_fonts_view") == 0
	|| strcasecmp (tbl_name, "SE_vector_styles_view") == 0
	|| strcasecmp (tbl_name, "SE_raster_styles_view") == 0
	|| strcasecmp (tbl_name, "SE_vector_styled_layers_view") == 0
	|| strcasecmp (tbl_name, "SE_raster_styled_layers_view") == 0
	|| strcasecmp (tbl_name, "rl2map_configurations") == 0)

      {
	  *sys_scope = sqlite3_mprintf ("SLD/SE Styling");
	  return 1;
      }
    if (strcasecmp (tbl_name, "ISO_metadata_view") == 0)
      {
	  *sys_scope = sqlite3_mprintf ("ISO Metadata Component");

    if (strcasecmp (tbl_name, "geom_cols_ref_sys") == 0)
      {
	  *sys_scope = sqlite3_mprintf ("CRS Catalog");
	  return 1;
      }
    if (strcasecmp (tbl_name, "spatial_ref_sys_all") == 0)
      {
	  *sys_scope = sqlite3_mprintf ("CRS Catalog");
	  return 1;
      }
    if (strcasecmp (tbl_name, "raster_coverages_ref_sys") == 0)
      {
	  *sys_scope = sqlite3_mprintf ("Raster Coverages Catalog");
	  return 1;
      }
................................................................................
      }
    if (strcasecmp (tbl_name, "SE_external_graphics_view") == 0
	|| strcasecmp (tbl_name, "SE_fonts_view") == 0
	|| strcasecmp (tbl_name, "SE_vector_styles_view") == 0
	|| strcasecmp (tbl_name, "SE_raster_styles_view") == 0
	|| strcasecmp (tbl_name, "SE_vector_styled_layers_view") == 0
	|| strcasecmp (tbl_name, "SE_raster_styled_layers_view") == 0
	|| strcasecmp (tbl_name, "rl2map_configurations") == 0
	|| strcasecmp (tbl_name, "rl2map_configurations_view") == 0)
      {
	  *sys_scope = sqlite3_mprintf ("SLD/SE Styling");
	  return 1;
      }
    if (strcasecmp (tbl_name, "ISO_metadata_view") == 0)
      {
	  *sys_scope = sqlite3_mprintf ("ISO Metadata Component");

#include <spatialite/sqlite.h>
#include <spatialite/debug.h>

#include <spatialite.h>
#include <spatialite_private.h>
#include <spatialite/gaiaaux.h>


#ifdef _WIN32
#define strcasecmp	_stricmp
#endif /* not WIN32 */

static int
check_splite_metacatalog (sqlite3 * sqlite)
................................................................................
	      ok_raster_coverages_keyword = 1;
      }
    sqlite3_free_table (results);

    if (ok_raster_coverages)
      {
	  /* creating the raster_coverages triggers */
	  sql = "CREATE TRIGGER raster_coverages_name_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "coverage_name value must not contain a single quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%''%');\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "coverage_name value must not contain a double quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%\"%');\n"
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER raster_coverages_name_update\n"
	      "BEFORE UPDATE OF 'coverage_name' ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'update on raster_coverages violates constraint: "
	      "coverage_name value must not contain a single quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%''%');\n"
	      "SELECT RAISE(ABORT,'update on raster_coverages violates constraint: "
	      "coverage_name value must not contain a double quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%\"%');\n"
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER raster_coverages_sample_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "sample_type must be one of ''1-BIT'' | ''2-BIT'' | ''4-BIT'' | "
	      "''INT8'' | ''UINT8'' | ''INT16'' | ''UINT16'' | ''INT32'' | "
	      "''UINT32'' | ''FLOAT'' | ''DOUBLE''')\n"
	      "WHERE NEW.sample_type NOT IN ('1-BIT', '2-BIT', '4-BIT', "
	      "'INT8', 'UINT8', 'INT16', 'UINT16', 'INT32', "
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER raster_coverages_sample_update\n"
	      "BEFORE UPDATE OF 'sample_type' ON 'raster_coverages'"
	      "\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "sample_type must be one of ''1-BIT'' | ''2-BIT'' | ''4-BIT'' | "
	      "''INT8'' | ''UINT8'' | ''INT16'' | ''UINT16'' | ''INT32'' | "
	      "''UINT32'' | ''FLOAT'' | ''DOUBLE''')\n"
	      "WHERE NEW.sample_type NOT IN ('1-BIT', '2-BIT', '4-BIT', "
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER raster_coverages_pixel_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "pixel_type must be one of ''MONOCHROME'' | ''PALETTE'' | "
	      "''GRAYSCALE'' | ''RGB'' | ''MULTIBAND'' | ''DATAGRID''')\n"
	      "WHERE NEW.pixel_type NOT IN ('MONOCHROME', 'PALETTE', "
	      "'GRAYSCALE', 'RGB', 'MULTIBAND', 'DATAGRID');\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER raster_coverages_pixel_update\n"
	      "BEFORE UPDATE OF 'pixel_type' ON 'raster_coverages'"
	      "\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "pixel_type must be one of ''MONOCHROME'' | ''PALETTE'' | "
	      "''GRAYSCALE'' | ''RGB'' | ''MULTIBAND'' | ''DATAGRID''')\n"
	      "WHERE NEW.pixel_type NOT IN ('MONOCHROME', 'PALETTE', "
	      "'GRAYSCALE', 'RGB', 'MULTIBAND', 'DATAGRID');\nEND";
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER raster_coverages_bands_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "num_bands must be >= 1')\nWHERE NEW.num_bands < 1;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER raster_coverages_bands_update\n"
	      "BEFORE UPDATE OF 'num_bands' ON 'raster_coverages'"
	      "\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "num_bands must be >= 1')\nWHERE NEW.num_bands < 1;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_compression_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "compression must be one of ''NONE'' | ''DEFLATE'' | ''DEFLATE_NO'' | "
	      "''LZMA'' | ''LZMA_NO'' | ''LZ4'' | ''LZ4_NO'' | ''ZSTD'' | ''ZSTD_NO'' | "
	      "''PNG'' | ''JPEG'' | ''LOSSY_WEBP'' | ''LOSSLESS_WEBP'' | ''CCITTFAX4'' | "
	      "''CHARLS'' | ''LOSSY_JP2'' | ''LOSSLESS_JP2''')\n"
	      "WHERE NEW.compression NOT IN ('NONE', 'DEFLATE',  'DEFLATE_NO', "
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_compression_update\n"
	      "BEFORE UPDATE OF 'compression' ON 'raster_coverages'"
	      "\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "compression must be one of ''NONE'' | ''DEFLATE'' | ''DEFLATE_NO'' | "
	      "''LZMA'' | ''LZMA_NO'' | ''LZ4'' | ''LZ4_NO'' | ''ZSTD'' | ''ZSTD_NO'' | "
	      "''PNG'' | ''JPEG'' | ''LOSSY_WEBP'' | ''LOSSLESS_WEBP'' | ''CCITTFAX4'' | "
	      "''CHARLS'' | ''LOSSY_JP2'' | ''LOSSLESS_JP2''')\n"
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER raster_coverages_quality_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "quality must be between 0 and 100')\n"
	      "WHERE NEW.quality NOT BETWEEN 0 AND 100;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER raster_coverages_quality_update\n"
	      "BEFORE UPDATE OF 'quality' ON 'raster_coverages'"
	      "\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "quality must be between 0 and 100')\n"
	      "WHERE NEW.quality NOT BETWEEN 0 AND 100;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER raster_coverages_tilew_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "tile_width must be an exact multiple of 8 between 256 and 1024')\n"
	      "WHERE CastToInteger(NEW.tile_width) IS NULL OR "
	      "NEW.tile_width NOT BETWEEN 256 AND 1024 OR (NEW.tile_width % 8) <> 0;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER raster_coverages_tilew_update\n"
	      "BEFORE UPDATE OF 'tile_width' ON 'raster_coverages'"
	      "\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "tile_width must be an exact multiple of 8 between 256 and 1024')\n"
	      "WHERE CastToInteger(NEW.tile_width) IS NULL OR "
	      "NEW.tile_width NOT BETWEEN 256 AND 1024 OR (NEW.tile_width % 8) <> 0;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER raster_coverages_tileh_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "tile_height must be an exact multiple of 8 between 256 and 1024')\n"
	      "WHERE CastToInteger(NEW.tile_height) IS NULL OR "
	      "NEW.tile_height NOT BETWEEN 256 AND 1024 OR (NEW.tile_height % 8) <> 0;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER raster_coverages_tileh_update\n"
	      "BEFORE UPDATE OF 'tile_height' ON 'raster_coverages'"
	      "\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "tile_height must be an exact multiple of 8 between 256 and 1024')\n"
	      "WHERE CastToInteger(NEW.tile_height) IS NULL OR "
	      "NEW.tile_height NOT BETWEEN 256 AND 1024 OR (NEW.tile_height % 8) <> 0;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER raster_coverages_horzres_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "horz_resolution must be positive')\n"
	      "WHERE NEW.horz_resolution IS NOT NULL AND "
	      "(NEW.horz_resolution <= 0.0 OR CastToDouble(NEW.horz_resolution) IS NULL);\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER raster_coverages_horzres_update\n"
	      "BEFORE UPDATE OF 'horz_resolution' ON 'raster_coverages'"
	      "\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "horz_resolution must be positive')\n"
	      "WHERE NEW.horz_resolution IS NOT NULL AND "
	      "(NEW.horz_resolution <= 0.0 OR CastToDouble(NEW.horz_resolution) IS NULL);\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER raster_coverages_vertres_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "vert_resolution must be positive')\n"
	      "WHERE NEW.vert_resolution IS NOT NULL AND "
	      "(NEW.vert_resolution <= 0.0 OR CastToDouble(NEW.vert_resolution) IS NULL);\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER raster_coverages_vertres_update\n"
	      "BEFORE UPDATE OF 'vert_resolution' ON 'raster_coverages'"
	      "\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "vert_resolution must be positive')\n"
	      "WHERE NEW.vert_resolution IS NOT NULL AND "
	      "(NEW.vert_resolution <= 0.0 OR CastToDouble(NEW.vert_resolution) IS NULL);\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER raster_coverages_nodata_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "invalid nodata_pixel')\nWHERE NEW.nodata_pixel IS NOT NULL AND "
	      "IsValidPixel(NEW.nodata_pixel, NEW.sample_type, NEW.num_bands) <> 1;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER raster_coverages_nodata_update\n"
	      "BEFORE UPDATE OF 'nodata_pixel' ON 'raster_coverages'"
	      "\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "invalid nodata_pixel')\nWHERE NEW.nodata_pixel IS NOT NULL AND "
	      "IsValidPixel(NEW.nodata_pixel, NEW.sample_type, NEW.num_bands) <> 1;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER raster_coverages_palette_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "invalid palette')\nWHERE NEW.palette IS NOT NULL AND "
	      "(NEW.pixel_type <> 'PALETTE' OR NEW.num_bands <> 1 OR "
	      "IsValidRasterPalette(NEW.palette, NEW.sample_type) <> 1);\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER raster_coverages_palette_update\n"
	      "BEFORE UPDATE OF 'palette' ON 'raster_coverages'"
	      "\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "invalid palette')\nWHERE NEW.palette IS NOT NULL AND "
	      "(NEW.pixel_type <> 'PALETTE' OR NEW.num_bands <> 1 OR "
	      "IsValidRasterPalette(NEW.palette, NEW.sample_type) <> 1);\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_statistics_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "invalid statistics')\nWHERE NEW.statistics IS NOT NULL AND "
	      "IsValidRasterStatistics(NEW.statistics, NEW.sample_type, NEW.num_bands) <> 1;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_statistics_update\n"
	      "BEFORE UPDATE OF 'statistics' ON 'raster_coverages'"
	      "\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "invalid statistics')\nWHERE NEW.statistics IS NOT NULL AND "
	      "IsValidRasterStatistics(NEW.statistics, NEW.sample_type, NEW.num_bands) <> 1;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_monosample_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent MONOCHROME sample_type')\nWHERE NEW.pixel_type = 'MONOCHROME' "
	      "AND NEW.sample_type <> '1-BIT';\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_monosample_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent MONOCHROME sample_type')\nWHERE NEW.pixel_type = 'MONOCHROME' "
	      "AND NEW.sample_type <>'1-BIT';\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_monocompr_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent MONOCHROME compression')\nWHERE NEW.pixel_type = 'MONOCHROME' "
	      "AND NEW.compression NOT IN ('NONE', 'DEFLATE', 'DEFLATE_NO', 'LZMA', "
	      "'LZMA_NO', 'LZ4', 'LZ4_NO', 'ZSTD', 'ZSTD_NO', 'PNG', "
	      "'CCITTFAX4');\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_monocompr_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent MONOCHROME compression')\nWHERE NEW.pixel_type = 'MONOCHROME' "
	      "AND NEW.compression NOT IN ('NONE', 'DEFLATE', 'DEFLATE_NO', 'LZMA', "
	      "'LZMA_NO', 'LZ4', 'LZ4_NO', 'ZSTD', 'ZSTD_NO', 'PNG', 'CCITTFAX4');\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_monobands_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent MONOCHROME num_bands')\nWHERE NEW.pixel_type = 'MONOCHROME' "
	      "AND NEW.num_bands <> 1;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_monobands_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent MONOCHROME num_bands')\nWHERE NEW.pixel_type = 'MONOCHROME' "
	      "AND NEW.num_bands <> 1;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_pltsample_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent PALETTE sample_type')\nWHERE NEW.pixel_type = 'PALETTE' "
	      "AND NEW.sample_type NOT IN ('1-BIT', '2-BIT', '4-BIT', 'UINT8');\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_pltsample_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent PALETTE sample_type')\nWHERE NEW.pixel_type = 'PALETTE' "
	      "AND NEW.sample_type NOT IN ('1-BIT', '2-BIT', '4-BIT', 'UINT8');\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_pltcompr_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent PALETTE compression')\nWHERE NEW.pixel_type = 'PALETTE' "
	      "AND NEW.compression NOT IN ('NONE', 'DEFLATE', 'DEFLATE_NO', 'LZMA', "
	      "'LZMA_NO', 'LZ4', 'LZ4_NO', 'ZSTD', 'ZSTD_NO', 'PNG');\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_pltcompr_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent PALETTE compression')\nWHERE NEW.pixel_type = 'PALETTE' "
	      "AND NEW.compression NOT IN ('NONE', 'DEFLATE', 'DEFLATE_NO', 'LZMA', "
	      "'LZMA_NO', 'LZ4', 'LZ4_NO', 'ZSTD', 'ZSTD_NO', 'PNG');\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_pltbands_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent PALETTE num_bands')\nWHERE NEW.pixel_type = 'PALETTE' "
	      "AND NEW.num_bands <> 1;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_pltbands_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent PALETTE num_bands')\nWHERE NEW.pixel_type = 'PALETTE' "
	      "AND NEW.num_bands <> 1;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_graysample_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent GRAYSCALE sample_type')\nWHERE NEW.pixel_type = 'GRAYSCALE' "
	      "AND NEW.sample_type NOT IN ('2-BIT', '4-BIT', 'UINT8');\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_graysample_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent GRAYSCALE sample_type')\nWHERE NEW.pixel_type = 'GRAYSCALE' "
	      "AND NEW.sample_type NOT IN ('2-BIT', '4-BIT', 'UINT8');\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_graybands_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent GRAYSCALE num_bands')\nWHERE NEW.pixel_type = 'GRAYSCALE' "
	      "AND NEW.num_bands <> 1;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_graybands_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent GRAYSCALE num_bands')\nWHERE NEW.pixel_type = 'GRAYSCALE' "
	      "AND NEW.num_bands <> 1;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_graycompr_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent GRAYSCALE compression')\nWHERE NEW.pixel_type = "
	      "'GRAYSCALE' AND NEW.compression NOT IN ('NONE', 'DEFLATE', 'DEFLATE_NO', "
	      "'LZMA', 'LZMA_NO', 'LZ4', 'LZ4_NO', 'ZSTD', 'ZSTD_NO', 'PNG', "
	      "'JPEG', 'LOSSY_WEBP', 'LOSSLESS_WEBP', 'CHARLS', 'LOSSY_JP2', "
	      "'LOSSLESS_JP2');\nEND";
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_graycompr_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent GRAYSCALE compression')\nWHERE NEW.pixel_type = "
	      "'GRAYSCALE' AND NEW.compression NOT IN ('NONE', 'DEFLATE', 'DEFLATE_NO', "
	      "'LZMA', 'LZMA_NO', 'LZ4', 'LZ4_NO', 'ZSTD', 'ZSTD_NO', 'PNG', "
	      "'JPEG', 'LOSSY_WEBP', 'LOSSLESS_WEBP', 'CHARLS', 'LOSSY_JP2', "
	      "'LOSSLESS_JP2');\nEND";
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_rgbsample_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent RGB sample_type')\nWHERE NEW.pixel_type = 'RGB' "
	      "AND NEW.sample_type NOT IN ('UINT8', 'UINT16');\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_rgbsample_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent RGB sample_type')\nWHERE NEW.pixel_type = 'RGB' "
	      "AND NEW.sample_type NOT IN ('UINT8', 'UINT16');\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_rgbcompr_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent RGB compression')\nWHERE NEW.pixel_type = 'RGB' "
	      "AND ((NEW.sample_type = 'UINT8' AND NEW.compression NOT IN ("
	      "'NONE', 'DEFLATE', 'DEFLATE_NO', 'LZMA', 'LZMA_NO', 'LZ4', 'LZ4_NO', "
	      "'ZSTD', 'ZSTD_NO', 'PNG', 'JPEG', 'LOSSY_WEBP', 'LOSSLESS_WEBP', "
	      "'CHARLS', 'LOSSY_JP2', 'LOSSLESS_JP2') OR (NEW.sample_type = "
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_rgbcompr_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent RGB compression')\nWHERE NEW.pixel_type = 'RGB' "
	      "AND ((NEW.sample_type = 'UINT8' AND NEW.compression NOT IN ("
	      "'NONE', 'DEFLATE', 'DEFLATE_NO', 'LZMA', 'LZMA_NO', 'LZ4', 'LZ4_NO', "
	      "'ZSTD', 'ZSTD_NO', 'PNG', 'JPEG', 'LOSSY_WEBP', 'LOSSLESS_WEBP', "
	      "'CHARLS', 'LOSSY_JP2', 'LOSSLESS_JP2') OR (NEW.sample_type = "
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_rgbbands_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent RGB num_bands')\nWHERE NEW.pixel_type = 'RGB' "
	      "AND NEW.num_bands <> 3;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_rgbbands_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent RGB num_bands')\nWHERE NEW.pixel_type = 'RGB' "
	      "AND NEW.num_bands <> 3;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_multisample_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent MULTIBAND sample_type')\nWHERE NEW.pixel_type = 'MULTIBAND' "
	      "AND NEW.sample_type NOT IN ('UINT8', 'UINT16');\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_multisample_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent MULTIBAND sample_type')\nWHERE NEW.pixel_type = 'MULTIBAND' "
	      "AND NEW.sample_type NOT IN ('UINT8', 'UINT16');\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_multicompr_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent MULTIBAND compression')\nWHERE NEW.pixel_type = "
	      "'MULTIBAND' AND ((NEW.num_bands NOT IN (3, 4) AND "
	      "NEW.compression NOT IN ('NONE', 'DEFLATE', 'DEFLATE_NO', 'LZMA', "
	      "'LZMA_NO', 'LZ4', 'LZ4_NO', 'ZSTD', 'ZSTD_NO')) OR	"
	      "(NEW.sample_type <> 'UINT16' AND NEW.num_bands IN (3, 4) AND "
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_multicompr_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent MULTIBAND compression')\nWHERE NEW.pixel_type = "
	      "'MULTIBAND' AND ((NEW.num_bands NOT IN (3, 4) AND "
	      "NEW.compression NOT IN ('NONE', 'DEFLATE', 'DEFLATE_NO', 'LZMA', "
	      "'LZMA_NO', 'LZ4', 'LZ4_NO', 'ZSTD', 'ZSTD_NO')) OR	"
	      "(NEW.sample_type <> 'UINT16' AND NEW.num_bands IN (3, 4) AND "
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_multibands_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent MULTIBAND num_bands')\nWHERE NEW.pixel_type = 'MULTIBAND' "
	      "AND NEW.num_bands < 2;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_multibands_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent MULTIBAND num_bands')\nWHERE NEW.pixel_type = 'MULTIBAND' "
	      "AND NEW.num_bands < 2;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_gridsample_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent DATAGRID sample_type')\nWHERE NEW.pixel_type = 'DATAGRID' "
	      "AND NEW.sample_type NOT IN ('INT8', 'UINT8', 'INT16', 'UINT16', "
	      "'INT32', 'UINT32', 'FLOAT', 'DOUBLE');\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_gridsample_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent DATAGRID sample_type')\nWHERE NEW.pixel_type = 'DATAGRID' "
	      "AND NEW.sample_type NOT IN ('INT8', 'UINT8', 'INT16', 'UINT16', "
	      "'INT32', 'UINT32', 'FLOAT', 'DOUBLE');\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_gridcompr_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent DATAGRID compression')\nWHERE NEW.pixel_type = 'DATAGRID' "
	      "AND (((NEW.sample_type NOT IN ('UINT8', 'UINT16')) AND NEW.compression "
	      "NOT IN ('NONE', 'DEFLATE', 'DEFLATE_NO', 'LZMA', 'LZMA_NO', 'LZ4', "
	      "'LZ4_NO', 'ZSTD', 'ZSTD_NO')) OR ((NEW.sample_type IN ('UINT8', 'UINT16')) "
	      "AND NEW.compression NOT IN ('NONE', 'DEFLATE', 'DEFLATE_NO', 'LZMA', "
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_gridcompr_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent DATAGRID compression')\nWHERE NEW.pixel_type = 'DATAGRID' "
	      "AND (((NEW.sample_type NOT IN ('UINT8', 'UINT16')) AND NEW.compression "
	      "NOT IN ('NONE', 'DEFLATE', 'DEFLATE_NO', 'LZMA', 'LZMA_NO', 'LZ4', "
	      "'LZ4_NO', 'ZSTD', 'ZSTD_NO')) OR ((NEW.sample_type IN ('UINT8', 'UINT16')) "
	      "AND NEW.compression NOT IN ('NONE', 'DEFLATE', 'DEFLATE_NO', 'LZMA', "
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_gridbands_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent DATAGRID num_bands')\nWHERE NEW.pixel_type = 'DATAGRID' "
	      "AND NEW.num_bands <> 1;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_gridbands_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent DATAGRID num_bands')\nWHERE NEW.pixel_type = 'DATAGRID' "
	      "AND NEW.num_bands <> 1;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER raster_coverages_georef_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent georeferencing infos')\n"
	      "WHERE NOT ((NEW.horz_resolution IS NULL AND NEW.vert_resolution IS NULL "
	      "AND NEW.srid IS NULL) OR (NEW.horz_resolution IS NOT NULL "
	      "AND NEW.vert_resolution IS NOT NULL AND NEW.srid IS NOT NULL));\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER raster_coverages_georef_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'update on raster_coverages violates constraint: "
	      "inconsistent georeferencing infos')\n"
	      "WHERE NOT ((NEW.horz_resolution IS NULL AND NEW.vert_resolution IS NULL "
	      "AND NEW.srid IS NULL) OR (NEW.horz_resolution IS NOT NULL "
	      "AND NEW.vert_resolution IS NOT NULL AND NEW.srid IS NOT NULL));\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER raster_coverages_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "attempting to change the definition of an already populated Coverage')\n"
	      "WHERE IsPopulatedCoverage(NULL, OLD.coverage_name) = 1 AND "
	      "((OLD.sample_type <> NEW.sample_type) AND (OLD.pixel_type <> NEW.sample_type) "
	      "OR (OLD.num_bands <> NEW.num_bands) OR (OLD.compression <> NEW.compression) "
	      "OR (OLD.quality <> NEW.quality) OR (OLD.tile_width <> NEW.tile_width) "
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER raster_coverages_delete\n"
	      "BEFORE DELETE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'delete on raster_coverages violates constraint: "
	      "attempting to delete the definition of an already populated Coverage')\n"
	      "WHERE IsPopulatedCoverage(NULL, OLD.coverage_name) = 1;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
................................................................................
		return 0;
	    }
      }

    if (ok_raster_coverages_srid)
      {
	  /* creating the raster_coverages_srid triggers */

	  sql = "CREATE TRIGGER raster_coverages_srid_name_insert\n"
	      "BEFORE INSERT ON 'raster_coverages_srid'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages_srid violates constraint: "
	      "coverage_name value must not contain a single quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%''%');\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages_srid violates constraint: "
	      "coverage_name value must not contain a double quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%\"%');\n"
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_srid_name_update\n"
	      "BEFORE UPDATE OF 'coverage_name' ON 'raster_coverages_srid'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'update on raster_coverages_srid violates constraint: "
	      "coverage_name value must not contain a single quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%''%');\n"
	      "SELECT RAISE(ABORT,'update on raster_coverages_srid violates constraint: "
	      "coverage_name value must not contain a double quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%\"%');\n"
................................................................................
		return 0;
	    }
      }

    if (ok_raster_coverages_keyword)
      {
	  /* creating the raster_coverages_keyword triggers */

	  sql = "CREATE TRIGGER raster_coverages_keyword_name_insert\n"
	      "BEFORE INSERT ON 'raster_coverages_keyword'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages_keyword violates constraint: "
	      "coverage_name value must not contain a single quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%''%');\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages_keyword violates constraint: "
	      "coverage_name value must not contain a double quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%\"%');\n"
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER raster_coverages_keyword_name_update\n"
	      "BEFORE UPDATE OF 'coverage_name' ON 'raster_coverages_keyword'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'update on raster_coverages_keyword violates constraint: "
	      "coverage_name value must not contain a single quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%''%');\n"
	      "SELECT RAISE(ABORT,'update on raster_coverages_keyword violates constraint: "
	      "coverage_name value must not contain a double quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%\"%');\n"
................................................................................
		sqlite3_free (err_msg);
		return 0;
	    }
      }
    return 1;
}

static int
create_raster_coverages (sqlite3 * sqlite)
{
/* creating the "raster_coverages" table */
    char *sql;
    int ret;
    char *err_msg = NULL;
    sql = "CREATE TABLE raster_coverages (\n"
	"coverage_name TEXT NOT NULL PRIMARY KEY,\n"
	"title TEXT NOT NULL DEFAULT '*** missing Title ***',\n"
	"abstract TEXT NOT NULL DEFAULT '*** missing Abstract ***',\n"
	"sample_type TEXT NOT NULL DEFAULT '*** undefined ***',\n"
	"pixel_type TEXT NOT NULL DEFAULT '*** undefined ***',\n"
	"num_bands INTEGER NOT NULL DEFAULT 1,\n"
	"compression TEXT NOT NULL DEFAULT 'NONE',\n"
................................................................................
      {
	  spatialite_e ("CREATE TABLE 'raster_coverages' error: %s\n", err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }

/* creating the raster_coverages_srid table */
    sql = "CREATE TABLE raster_coverages_srid (\n"
	"coverage_name TEXT NOT NULL,\n"
	"srid INTEGER NOT NULL,\n"
	"extent_minx DOUBLE,\n"
	"extent_miny DOUBLE,\n"
	"extent_maxx DOUBLE,\n"
	"extent_maxy DOUBLE,\n"
	"CONSTRAINT pk_raster_coverages_srid PRIMARY KEY (coverage_name, srid),\n"
................................................................................
	  spatialite_e ("CREATE TABLE 'raster_coverages_srid' error: %s\n",
			err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }

/* creating the raster_coverages_ref_sys view */
    sql = "CREATE VIEW raster_coverages_ref_sys AS\n"
	"SELECT c.coverage_name AS coverage_name, c.title AS title, "
	"c.abstract AS abstract, c.sample_type AS sample_type, "
	"c.pixel_type AS pixel_type, c.num_bands AS num_bands, "
	"c.compression AS compression, c.quality AS quality, "
	"c.tile_width AS tile_width, c.tile_height AS tile_height, "
	"c.horz_resolution AS horz_resolution, c.vert_resolution AS vert_resolution, "
	"c.nodata_pixel AS nodata_pixel, c.palette AS palette, "
................................................................................
	  spatialite_e ("CREATE VIEW 'raster_coverages_ref_sys' error: %s\n",
			err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }

/* creating the raster_coverages_keyword table */
    sql = "CREATE TABLE raster_coverages_keyword (\n"
	"coverage_name TEXT NOT NULL,\n"
	"keyword TEXT NOT NULL,\n"
	"CONSTRAINT pk_raster_coverages_keyword PRIMARY KEY (coverage_name, keyword),\n"
	"CONSTRAINT fk_raster_coverages_keyword FOREIGN KEY (coverage_name) "
	"REFERENCES raster_coverages (coverage_name) ON DELETE CASCADE)";
    ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
    if (ret != SQLITE_OK)
................................................................................
		sqlite3_free (err_msg);
		return 0;
	    }
      }
    return 1;
}

static int
create_rl2map_configurations (sqlite3 * sqlite, int relaxed)
{
/* creating the "rl2map_configurations" table */
    char *sql;
    int ret;
    char *err_msg = NULL;

................................................................................
	      ok_vector_coverages_keyword = 1;
      }
    sqlite3_free_table (results);

    if (ok_vector_coverages)
      {
	  /* creating the vector_coverages triggers */
	  sql = "CREATE TRIGGER vector_coverages_name_insert\n"
	      "BEFORE INSERT ON 'vector_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on vector_coverages violates constraint: "
	      "coverage_name value must not contain a single quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%''%');\n"
	      "SELECT RAISE(ABORT,'insert on vector_coverages violates constraint: "
	      "coverage_name value must not contain a double quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%\"%');\n"
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER vector_coverages_name_update\n"
	      "BEFORE UPDATE OF 'coverage_name' ON 'vector_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'update on vector_coverages violates constraint: "
	      "coverage_name value must not contain a single quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%''%');\n"
	      "SELECT RAISE(ABORT,'update on vector_coverages violates constraint: "
	      "coverage_name value must not contain a double quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%\"%');\n"
................................................................................
		return 0;
	    }
      }

    if (ok_vector_coverages_srid)
      {
	  /* creating the vector_coverages_srid triggers */

	  sql = "CREATE TRIGGER vector_coverages_srid_name_insert\n"
	      "BEFORE INSERT ON 'vector_coverages_srid'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on vector_coverages_srid violates constraint: "
	      "coverage_name value must not contain a single quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%''%');\n"
	      "SELECT RAISE(ABORT,'insert on vector_coverages_srid violates constraint: "
	      "coverage_name value must not contain a double quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%\"%');\n"
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER vector_coverages_srid_name_update\n"
	      "BEFORE UPDATE OF 'coverage_name' ON 'vector_coverages_srid'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'update on vector_coverages_srid violates constraint: "
	      "coverage_name value must not contain a single quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%''%');\n"
	      "SELECT RAISE(ABORT,'update on vector_coverages_srid violates constraint: "
	      "coverage_name value must not contain a double quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%\"%');\n"
................................................................................
		return 0;
	    }
      }

    if (ok_vector_coverages_keyword)
      {
	  /* creating the vector_coverages_keyword triggers */

	  sql = "CREATE TRIGGER vector_coverages_keyword_name_insert\n"
	      "BEFORE INSERT ON 'vector_coverages_keyword'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on vector_coverages_keyword violates constraint: "
	      "coverage_name value must not contain a single quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%''%');\n"
	      "SELECT RAISE(ABORT,'insert on vector_coverages_keyword violates constraint: "
	      "coverage_name value must not contain a double quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%\"%');\n"
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }

	  sql = "CREATE TRIGGER vector_coverages_keyword_name_update\n"
	      "BEFORE UPDATE OF 'coverage_name' ON 'vector_coverages_keyword'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'update on vector_coverages_keyword violates constraint: "
	      "coverage_name value must not contain a single quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%''%');\n"
	      "SELECT RAISE(ABORT,'update on vector_coverages_keyword violates constraint: "
	      "coverage_name value must not contain a double quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%\"%');\n"
................................................................................
		sqlite3_free (err_msg);
		return 0;
	    }
      }
    return 1;
}

static int
create_vector_coverages (sqlite3 * sqlite)
{
/* creating the "vector_coverages" table */
    char *sql;
    int ret;
    char *err_msg = NULL;
    sql = "CREATE TABLE vector_coverages (\n"
	"coverage_name TEXT NOT NULL PRIMARY KEY,\n"
	"f_table_name TEXT,\n"
	"f_geometry_column TEXT,\n"
	"view_name TEXT,\n"
	"view_geometry TEXT,\n"
	"virt_name TEXT,\n"
	"virt_geometry TEXT,\n"
................................................................................
    if (ret != SQLITE_OK)
      {
	  spatialite_e ("CREATE TABLE 'vector_coverages' error: %s\n", err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }
/* creating the VectorLayers index */

    sql = "CREATE UNIQUE INDEX idx_vector_coverages ON vector_coverages "
	"(f_table_name, f_geometry_column)";
    ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
    if (ret != SQLITE_OK)
      {
	  spatialite_e ("CREATE INDEX 'idx_vector_coverages' error: %s\n",
			err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }

/* creating the vector_coverages_srid table */
    sql = "CREATE TABLE vector_coverages_srid (\n"
	"coverage_name TEXT NOT NULL,\n"
	"srid INTEGER NOT NULL,\n"
	"extent_minx DOUBLE,\n"
	"extent_miny DOUBLE,\n"
	"extent_maxx DOUBLE,\n"
	"extent_maxy DOUBLE,\n"
	"CONSTRAINT pk_vector_coverages_srid PRIMARY KEY (coverage_name, srid),\n"
................................................................................
	  spatialite_e ("CREATE TABLE 'vector_coverages_srid' error: %s\n",
			err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }

/* creating the vector_coverages_ref_sys view */
    sql = "CREATE VIEW vector_coverages_ref_sys AS\n"
	"SELECT v.coverage_name AS coverage_name, v.title AS title, v.abstract AS abstract, "
	"v.is_queryable AS is_queryable, v.geo_minx AS geo_minx, v.geo_miny AS geo_miny, "
	"v.geo_maxx AS geo_maxx, v.geo_maxy AS geo_maxy, v.extent_minx AS extent_minx, "
	"v.extent_miny AS extent_miny, v.extent_maxx AS extent_maxx, v.extent_maxy AS extent_maxy, "
	"s.srid AS srid, 1 AS native_srid, s.auth_name AS auth_name, s.auth_srid AS auth_srid, "
	"s.ref_sys_name AS ref_sys_name, s.proj4text AS proj4text\n"
	"FROM vector_coverages AS v\n"
................................................................................
	  spatialite_e ("CREATE VIEW 'vector_coverages_ref_sys' error: %s\n",
			err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }

/* creating the vector_coverages_keyword table */
    sql = "CREATE TABLE vector_coverages_keyword (\n"
	"coverage_name TEXT NOT NULL,\n"
	"keyword TEXT NOT NULL,\n"
	"CONSTRAINT pk_vector_coverages_keyword PRIMARY KEY (coverage_name, keyword),\n"
	"CONSTRAINT fk_vector_coverages_keyword FOREIGN KEY (coverage_name) "
	"REFERENCES vector_coverages (coverage_name) ON DELETE CASCADE)";
    ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
    if (ret != SQLITE_OK)
................................................................................
      }
    for (i = 1; i <= rows; i++)
	exists = 1;
    sqlite3_free_table (results);
    return exists;
}

static int
create_wms_tables (sqlite3 * sqlite)
{
/* creating the WMS support tables */
    char *sql;
    int ret;
    char *err_msg = NULL;
    sql = "CREATE TABLE wms_getcapabilities (\n"
	"id INTEGER PRIMARY KEY AUTOINCREMENT,\n"
	"url TEXT NOT NULL,\n"
	"title TEXT NOT NULL DEFAULT '*** undefined ***',\n"
	"abstract TEXT NOT NULL DEFAULT '*** undefined ***')";
    ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
    if (ret != SQLITE_OK)
      {
	  spatialite_e ("CREATE TABLE 'wms_getcapabilities' error: %s\n",
			err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }
    sql =
	"CREATE UNIQUE INDEX idx_wms_getcapabilities ON wms_getcapabilities (url)";
    ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
    if (ret != SQLITE_OK)
      {
	  spatialite_e ("CREATE INDEX 'idx_wms_getcapabilities' error: %s\n",
			err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }

    sql = "CREATE TABLE wms_getmap (\n"
	"id INTEGER PRIMARY KEY AUTOINCREMENT,\n"
	"parent_id INTEGER NOT NULL,\n"
	"url TEXT NOT NULL,\n"
	"layer_name TEXT NOT NULL,\n"
	"title TEXT NOT NULL DEFAULT '*** undefined ***',\n"
	"abstract TEXT NOT NULL DEFAULT '*** undefined ***',\n"
	"version TEXT NOT NULL,\n"
................................................................................
    if (ret != SQLITE_OK)
      {
	  spatialite_e ("CREATE INDEX 'idx_wms_getmap' error: %s\n", err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }

    sql = "CREATE TABLE wms_settings (\n"
	"id INTEGER PRIMARY KEY AUTOINCREMENT,\n"
	"parent_id INTEGER NOT NULL,\n"
	"key TEXT NOT NULL CHECK (Lower(key) IN ('version', 'format', 'style')),\n"
	"value TEXT NOT NULL,\n"
	"is_default INTEGER NOT NULL CHECK (is_default IN (0, 1)),\n"
	"CONSTRAINT fk_wms_settings FOREIGN KEY (parent_id) "
	"REFERENCES wms_getmap (id) ON DELETE CASCADE)";
................................................................................
    if (ret != SQLITE_OK)
      {
	  spatialite_e ("CREATE INDEX 'idx_wms_settings' error: %s\n", err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }

    sql = "CREATE TABLE wms_ref_sys (\n"
	"id INTEGER PRIMARY KEY AUTOINCREMENT,\n"
	"parent_id INTEGER NOT NULL,\n"
	"srs TEXT NOT NULL,\n"
	"minx DOUBLE NOT NULL,\n"
	"miny DOUBLE NOT NULL,\n"
	"maxx DOUBLE NOT NULL,\n"
	"maxy DOUBLE NOT NULL,\n"
................................................................................
    ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
    if (ret != SQLITE_OK)
      {
	  spatialite_e ("CREATE TABLE 'wms_ref_sys' error: %s\n", err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }

    sql = "CREATE UNIQUE INDEX idx_wms_ref_sys ON wms_ref_sys (parent_id, srs)";
    ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
    if (ret != SQLITE_OK)
      {
	  spatialite_e ("CREATE INDEX 'idx_wms_ref_sys' error: %s\n", err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }
................................................................................
		sqlite3_free (err_msg);
		return 0;
	    }
      }
    return 1;
}

static int
create_external_graphics (sqlite3 * sqlite)
{
/* creating the SE_external_graphics table */
    char *sql;
    int ret;
    char *err_msg = NULL;
    sql = "CREATE TABLE SE_external_graphics (\n"
................................................................................
		sqlite3_free (err_msg);
		return 0;
	    }
      }
    return 1;
}

static int
create_fonts (sqlite3 * sqlite)
{
/* creating the SE_fonts table */
    char *sql;
    int ret;
    char *err_msg = NULL;
    sql = "CREATE TABLE SE_fonts (\n"
................................................................................
		sqlite3_free (err_msg);
		return 0;
	    }
      }
    return 1;
}

static int
create_vector_styles (sqlite3 * sqlite, int relaxed)
{
/* creating the SE_vector_styles table */
    char *sql;
    int ret;
    char *err_msg = NULL;
    sql = "CREATE TABLE SE_vector_styles (\n"
................................................................................
		sqlite3_free (err_msg);
		return 0;
	    }
      }
    return 1;
}

static int
create_vector_styled_layers (sqlite3 * sqlite)
{
/* creating the SE_vector_styled_layers table */
    char *sql;
    int ret;
    char *err_msg = NULL;
    sql = "CREATE TABLE SE_vector_styled_layers (\n"
................................................................................
		sqlite3_free (err_msg);
		return 0;
	    }
      }
    return 1;
}

static int
create_raster_styles (sqlite3 * sqlite, int relaxed)
{
/* creating the SE_raster_styles table */
    char *sql;
    int ret;
    char *err_msg = NULL;
    sql = "CREATE TABLE SE_raster_styles (\n"
................................................................................
		sqlite3_free (err_msg);
		return 0;
	    }
      }
    return 1;
}

static int
create_raster_styled_layers (sqlite3 * sqlite)
{
/* creating the SE_raster_styled_layers table */
    char *sql;
    int ret;
    char *err_msg = NULL;
    sql = "CREATE TABLE SE_raster_styled_layers (\n"
................................................................................
	  return 0;
      }
    if (!create_raster_styled_layers_triggers (sqlite))
	return 0;
    return 1;
}

static int
create_external_graphics_view (sqlite3 * sqlite)
{
/* creating the SE_external_graphics_view view */
    char *sql_statement;
    int ret;
    char *err_msg = NULL;
    sql_statement =
................................................................................
	      ("CREATE VIEW 'SE_external_graphics_view' error: %s\n", err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }
    return 1;
}

static int
create_fonts_view (sqlite3 * sqlite)
{
/* creating the SE_fonts_view view */
    char *sql_statement;
    int ret;
    char *err_msg = NULL;
    sql_statement =
................................................................................
	  spatialite_e ("CREATE VIEW 'SE_fonts_view' error: %s\n", err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }
    return 1;
}

static int
create_vector_styles_view (sqlite3 * sqlite)
{
/* creating the SE_vector_styles_view view */
    char *sql_statement;
    int ret;
    char *err_msg = NULL;
    sql_statement =
................................................................................
	      ("CREATE VIEW 'SE_vector_styles_view' error: %s\n", err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }
    return 1;
}

static int
create_raster_styles_view (sqlite3 * sqlite)
{
/* creating the SE_raster_styles_view view */
    char *sql_statement;
    int ret;
    char *err_msg = NULL;
    sql_statement =
................................................................................
	      ("CREATE VIEW 'SE_raster_styles_view' error: %s\n", err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }
    return 1;
}

static int
create_rl2map_configurations_view (sqlite3 * sqlite)
{
/* creating the rl2map_configurations_view view */
    char *sql_statement;
    int ret;
    char *err_msg = NULL;
    sql_statement =
................................................................................
	      ("CREATE VIEW 'rl2map_configurations_view' error: %s\n", err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }
    return 1;
}

static int
create_vector_styled_layers_view (sqlite3 * sqlite)
{
/* creating the SE_vector_styled_layers_view view */
    char *sql_statement;
    int ret;
    char *err_msg = NULL;
    sql_statement =
................................................................................
	      ("SELECT SE_AutoRegisterStandardBrushes() error: %s\n", err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }
    return 1;
}

static int
create_raster_styled_layers_view (sqlite3 * sqlite)
{
/* creating the SE_raster_styled_layers_view view */
    char *sql_statement;
    int ret;
    char *err_msg = NULL;
    sql_statement =
................................................................................
      }
    for (i = 1; i <= rows; i++)
	exists = 1;
    sqlite3_free_table (results);
    return exists;
}

static int
create_iso_metadata (sqlite3 * sqlite, int relaxed)
{
/* creating the ISO_metadata table */
    char *sql;
    int ret;
    char *err_msg = NULL;
    sql = "CREATE TABLE ISO_metadata (\n"
................................................................................
			err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }
    return 1;
}

static int
create_iso_metadata_reference (sqlite3 * sqlite)
{
/* creating the ISO_metadata_reference table */
    char *sql;
    int ret;
    char *err_msg = NULL;
    sql = "CREATE TABLE ISO_metadata_reference (\n"
................................................................................
	       err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }
    return 1;
}

static int
create_iso_metadata_view (sqlite3 * sqlite)
{
/* creating the ISO_metadata_view view */
    char *sql;
    int ret;
    char *err_msg = NULL;
    sql = "CREATE VIEW ISO_metadata_view AS\n"
................................................................................
    return 1;

  error:
    return 0;
}

#endif /* end including LIBXML2 */

#include <spatialite/sqlite.h>
#include <spatialite/debug.h>

#include <spatialite.h>
#include <spatialite_private.h>
#include <spatialite/gaiaaux.h>
#include <spatialite/stored_procedures.h>

#ifdef _WIN32
#define strcasecmp	_stricmp
#endif /* not WIN32 */

static int
check_splite_metacatalog (sqlite3 * sqlite)
................................................................................
	      ok_raster_coverages_keyword = 1;
      }
    sqlite3_free_table (results);

    if (ok_raster_coverages)
      {
	  /* creating the raster_coverages triggers */
	  sql = "CREATE TRIGGER IF NOT EXISTS raster_coverages_name_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "coverage_name value must not contain a single quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%''%');\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "coverage_name value must not contain a double quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%\"%');\n"
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER IF NOT EXISTS raster_coverages_name_update\n"
	      "BEFORE UPDATE OF 'coverage_name' ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'update on raster_coverages violates constraint: "
	      "coverage_name value must not contain a single quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%''%');\n"
	      "SELECT RAISE(ABORT,'update on raster_coverages violates constraint: "
	      "coverage_name value must not contain a double quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%\"%');\n"
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER IF NOT EXISTS raster_coverages_sample_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "sample_type must be one of ''1-BIT'' | ''2-BIT'' | ''4-BIT'' | "
	      "''INT8'' | ''UINT8'' | ''INT16'' | ''UINT16'' | ''INT32'' | "
	      "''UINT32'' | ''FLOAT'' | ''DOUBLE''')\n"
	      "WHERE NEW.sample_type NOT IN ('1-BIT', '2-BIT', '4-BIT', "
	      "'INT8', 'UINT8', 'INT16', 'UINT16', 'INT32', "
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER IF NOT EXISTS raster_coverages_sample_update\n"
	      "BEFORE UPDATE OF 'sample_type' ON 'raster_coverages'"
	      "\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "sample_type must be one of ''1-BIT'' | ''2-BIT'' | ''4-BIT'' | "
	      "''INT8'' | ''UINT8'' | ''INT16'' | ''UINT16'' | ''INT32'' | "
	      "''UINT32'' | ''FLOAT'' | ''DOUBLE''')\n"
	      "WHERE NEW.sample_type NOT IN ('1-BIT', '2-BIT', '4-BIT', "
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER IF NOT EXISTS raster_coverages_pixel_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "pixel_type must be one of ''MONOCHROME'' | ''PALETTE'' | "
	      "''GRAYSCALE'' | ''RGB'' | ''MULTIBAND'' | ''DATAGRID''')\n"
	      "WHERE NEW.pixel_type NOT IN ('MONOCHROME', 'PALETTE', "
	      "'GRAYSCALE', 'RGB', 'MULTIBAND', 'DATAGRID');\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER IF NOT EXISTS raster_coverages_pixel_update\n"
	      "BEFORE UPDATE OF 'pixel_type' ON 'raster_coverages'"
	      "\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "pixel_type must be one of ''MONOCHROME'' | ''PALETTE'' | "
	      "''GRAYSCALE'' | ''RGB'' | ''MULTIBAND'' | ''DATAGRID''')\n"
	      "WHERE NEW.pixel_type NOT IN ('MONOCHROME', 'PALETTE', "
	      "'GRAYSCALE', 'RGB', 'MULTIBAND', 'DATAGRID');\nEND";
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER IF NOT EXISTS raster_coverages_bands_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "num_bands must be >= 1')\nWHERE NEW.num_bands < 1;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER IF NOT EXISTS raster_coverages_bands_update\n"
	      "BEFORE UPDATE OF 'num_bands' ON 'raster_coverages'"
	      "\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "num_bands must be >= 1')\nWHERE NEW.num_bands < 1;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_compression_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "compression must be one of ''NONE'' | ''DEFLATE'' | ''DEFLATE_NO'' | "
	      "''LZMA'' | ''LZMA_NO'' | ''LZ4'' | ''LZ4_NO'' | ''ZSTD'' | ''ZSTD_NO'' | "
	      "''PNG'' | ''JPEG'' | ''LOSSY_WEBP'' | ''LOSSLESS_WEBP'' | ''CCITTFAX4'' | "
	      "''CHARLS'' | ''LOSSY_JP2'' | ''LOSSLESS_JP2''')\n"
	      "WHERE NEW.compression NOT IN ('NONE', 'DEFLATE',  'DEFLATE_NO', "
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_compression_update\n"
	      "BEFORE UPDATE OF 'compression' ON 'raster_coverages'"
	      "\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "compression must be one of ''NONE'' | ''DEFLATE'' | ''DEFLATE_NO'' | "
	      "''LZMA'' | ''LZMA_NO'' | ''LZ4'' | ''LZ4_NO'' | ''ZSTD'' | ''ZSTD_NO'' | "
	      "''PNG'' | ''JPEG'' | ''LOSSY_WEBP'' | ''LOSSLESS_WEBP'' | ''CCITTFAX4'' | "
	      "''CHARLS'' | ''LOSSY_JP2'' | ''LOSSLESS_JP2''')\n"
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER IF NOT EXISTS raster_coverages_quality_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "quality must be between 0 and 100')\n"
	      "WHERE NEW.quality NOT BETWEEN 0 AND 100;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER IF NOT EXISTS raster_coverages_quality_update\n"
	      "BEFORE UPDATE OF 'quality' ON 'raster_coverages'"
	      "\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "quality must be between 0 and 100')\n"
	      "WHERE NEW.quality NOT BETWEEN 0 AND 100;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER IF NOT EXISTS raster_coverages_tilew_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "tile_width must be an exact multiple of 8 between 256 and 1024')\n"
	      "WHERE CastToInteger(NEW.tile_width) IS NULL OR "
	      "NEW.tile_width NOT BETWEEN 256 AND 1024 OR (NEW.tile_width % 8) <> 0;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER IF NOT EXISTS raster_coverages_tilew_update\n"
	      "BEFORE UPDATE OF 'tile_width' ON 'raster_coverages'"
	      "\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "tile_width must be an exact multiple of 8 between 256 and 1024')\n"
	      "WHERE CastToInteger(NEW.tile_width) IS NULL OR "
	      "NEW.tile_width NOT BETWEEN 256 AND 1024 OR (NEW.tile_width % 8) <> 0;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER IF NOT EXISTS raster_coverages_tileh_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "tile_height must be an exact multiple of 8 between 256 and 1024')\n"
	      "WHERE CastToInteger(NEW.tile_height) IS NULL OR "
	      "NEW.tile_height NOT BETWEEN 256 AND 1024 OR (NEW.tile_height % 8) <> 0;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER IF NOT EXISTS raster_coverages_tileh_update\n"
	      "BEFORE UPDATE OF 'tile_height' ON 'raster_coverages'"
	      "\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "tile_height must be an exact multiple of 8 between 256 and 1024')\n"
	      "WHERE CastToInteger(NEW.tile_height) IS NULL OR "
	      "NEW.tile_height NOT BETWEEN 256 AND 1024 OR (NEW.tile_height % 8) <> 0;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER IF NOT EXISTS raster_coverages_horzres_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "horz_resolution must be positive')\n"
	      "WHERE NEW.horz_resolution IS NOT NULL AND "
	      "(NEW.horz_resolution <= 0.0 OR CastToDouble(NEW.horz_resolution) IS NULL);\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER IF NOT EXISTS raster_coverages_horzres_update\n"
	      "BEFORE UPDATE OF 'horz_resolution' ON 'raster_coverages'"
	      "\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "horz_resolution must be positive')\n"
	      "WHERE NEW.horz_resolution IS NOT NULL AND "
	      "(NEW.horz_resolution <= 0.0 OR CastToDouble(NEW.horz_resolution) IS NULL);\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER IF NOT EXISTS raster_coverages_vertres_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "vert_resolution must be positive')\n"
	      "WHERE NEW.vert_resolution IS NOT NULL AND "
	      "(NEW.vert_resolution <= 0.0 OR CastToDouble(NEW.vert_resolution) IS NULL);\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER IF NOT EXISTS raster_coverages_vertres_update\n"
	      "BEFORE UPDATE OF 'vert_resolution' ON 'raster_coverages'"
	      "\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "vert_resolution must be positive')\n"
	      "WHERE NEW.vert_resolution IS NOT NULL AND "
	      "(NEW.vert_resolution <= 0.0 OR CastToDouble(NEW.vert_resolution) IS NULL);\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER IF NOT EXISTS raster_coverages_nodata_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "invalid nodata_pixel')\nWHERE NEW.nodata_pixel IS NOT NULL AND "
	      "IsValidPixel(NEW.nodata_pixel, NEW.sample_type, NEW.num_bands) <> 1;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER IF NOT EXISTS raster_coverages_nodata_update\n"
	      "BEFORE UPDATE OF 'nodata_pixel' ON 'raster_coverages'"
	      "\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "invalid nodata_pixel')\nWHERE NEW.nodata_pixel IS NOT NULL AND "
	      "IsValidPixel(NEW.nodata_pixel, NEW.sample_type, NEW.num_bands) <> 1;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER IF NOT EXISTS raster_coverages_palette_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "invalid palette')\nWHERE NEW.palette IS NOT NULL AND "
	      "(NEW.pixel_type <> 'PALETTE' OR NEW.num_bands <> 1 OR "
	      "IsValidRasterPalette(NEW.palette, NEW.sample_type) <> 1);\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER IF NOT EXISTS raster_coverages_palette_update\n"
	      "BEFORE UPDATE OF 'palette' ON 'raster_coverages'"
	      "\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "invalid palette')\nWHERE NEW.palette IS NOT NULL AND "
	      "(NEW.pixel_type <> 'PALETTE' OR NEW.num_bands <> 1 OR "
	      "IsValidRasterPalette(NEW.palette, NEW.sample_type) <> 1);\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_statistics_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "invalid statistics')\nWHERE NEW.statistics IS NOT NULL AND "
	      "IsValidRasterStatistics(NEW.statistics, NEW.sample_type, NEW.num_bands) <> 1;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_statistics_update\n"
	      "BEFORE UPDATE OF 'statistics' ON 'raster_coverages'"
	      "\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "invalid statistics')\nWHERE NEW.statistics IS NOT NULL AND "
	      "IsValidRasterStatistics(NEW.statistics, NEW.sample_type, NEW.num_bands) <> 1;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_monosample_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent MONOCHROME sample_type')\nWHERE NEW.pixel_type = 'MONOCHROME' "
	      "AND NEW.sample_type <> '1-BIT';\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_monosample_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent MONOCHROME sample_type')\nWHERE NEW.pixel_type = 'MONOCHROME' "
	      "AND NEW.sample_type <>'1-BIT';\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_monocompr_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent MONOCHROME compression')\nWHERE NEW.pixel_type = 'MONOCHROME' "
	      "AND NEW.compression NOT IN ('NONE', 'DEFLATE', 'DEFLATE_NO', 'LZMA', "
	      "'LZMA_NO', 'LZ4', 'LZ4_NO', 'ZSTD', 'ZSTD_NO', 'PNG', "
	      "'CCITTFAX4');\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_monocompr_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent MONOCHROME compression')\nWHERE NEW.pixel_type = 'MONOCHROME' "
	      "AND NEW.compression NOT IN ('NONE', 'DEFLATE', 'DEFLATE_NO', 'LZMA', "
	      "'LZMA_NO', 'LZ4', 'LZ4_NO', 'ZSTD', 'ZSTD_NO', 'PNG', 'CCITTFAX4');\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_monobands_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent MONOCHROME num_bands')\nWHERE NEW.pixel_type = 'MONOCHROME' "
	      "AND NEW.num_bands <> 1;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_monobands_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent MONOCHROME num_bands')\nWHERE NEW.pixel_type = 'MONOCHROME' "
	      "AND NEW.num_bands <> 1;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_pltsample_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent PALETTE sample_type')\nWHERE NEW.pixel_type = 'PALETTE' "
	      "AND NEW.sample_type NOT IN ('1-BIT', '2-BIT', '4-BIT', 'UINT8');\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_pltsample_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent PALETTE sample_type')\nWHERE NEW.pixel_type = 'PALETTE' "
	      "AND NEW.sample_type NOT IN ('1-BIT', '2-BIT', '4-BIT', 'UINT8');\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_pltcompr_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent PALETTE compression')\nWHERE NEW.pixel_type = 'PALETTE' "
	      "AND NEW.compression NOT IN ('NONE', 'DEFLATE', 'DEFLATE_NO', 'LZMA', "
	      "'LZMA_NO', 'LZ4', 'LZ4_NO', 'ZSTD', 'ZSTD_NO', 'PNG');\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_pltcompr_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent PALETTE compression')\nWHERE NEW.pixel_type = 'PALETTE' "
	      "AND NEW.compression NOT IN ('NONE', 'DEFLATE', 'DEFLATE_NO', 'LZMA', "
	      "'LZMA_NO', 'LZ4', 'LZ4_NO', 'ZSTD', 'ZSTD_NO', 'PNG');\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_pltbands_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent PALETTE num_bands')\nWHERE NEW.pixel_type = 'PALETTE' "
	      "AND NEW.num_bands <> 1;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_pltbands_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent PALETTE num_bands')\nWHERE NEW.pixel_type = 'PALETTE' "
	      "AND NEW.num_bands <> 1;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_graysample_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent GRAYSCALE sample_type')\nWHERE NEW.pixel_type = 'GRAYSCALE' "
	      "AND NEW.sample_type NOT IN ('2-BIT', '4-BIT', 'UINT8');\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_graysample_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent GRAYSCALE sample_type')\nWHERE NEW.pixel_type = 'GRAYSCALE' "
	      "AND NEW.sample_type NOT IN ('2-BIT', '4-BIT', 'UINT8');\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_graybands_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent GRAYSCALE num_bands')\nWHERE NEW.pixel_type = 'GRAYSCALE' "
	      "AND NEW.num_bands <> 1;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_graybands_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent GRAYSCALE num_bands')\nWHERE NEW.pixel_type = 'GRAYSCALE' "
	      "AND NEW.num_bands <> 1;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_graycompr_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent GRAYSCALE compression')\nWHERE NEW.pixel_type = "
	      "'GRAYSCALE' AND NEW.compression NOT IN ('NONE', 'DEFLATE', 'DEFLATE_NO', "
	      "'LZMA', 'LZMA_NO', 'LZ4', 'LZ4_NO', 'ZSTD', 'ZSTD_NO', 'PNG', "
	      "'JPEG', 'LOSSY_WEBP', 'LOSSLESS_WEBP', 'CHARLS', 'LOSSY_JP2', "
	      "'LOSSLESS_JP2');\nEND";
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_graycompr_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent GRAYSCALE compression')\nWHERE NEW.pixel_type = "
	      "'GRAYSCALE' AND NEW.compression NOT IN ('NONE', 'DEFLATE', 'DEFLATE_NO', "
	      "'LZMA', 'LZMA_NO', 'LZ4', 'LZ4_NO', 'ZSTD', 'ZSTD_NO', 'PNG', "
	      "'JPEG', 'LOSSY_WEBP', 'LOSSLESS_WEBP', 'CHARLS', 'LOSSY_JP2', "
	      "'LOSSLESS_JP2');\nEND";
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_rgbsample_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent RGB sample_type')\nWHERE NEW.pixel_type = 'RGB' "
	      "AND NEW.sample_type NOT IN ('UINT8', 'UINT16');\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_rgbsample_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent RGB sample_type')\nWHERE NEW.pixel_type = 'RGB' "
	      "AND NEW.sample_type NOT IN ('UINT8', 'UINT16');\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_rgbcompr_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent RGB compression')\nWHERE NEW.pixel_type = 'RGB' "
	      "AND ((NEW.sample_type = 'UINT8' AND NEW.compression NOT IN ("
	      "'NONE', 'DEFLATE', 'DEFLATE_NO', 'LZMA', 'LZMA_NO', 'LZ4', 'LZ4_NO', "
	      "'ZSTD', 'ZSTD_NO', 'PNG', 'JPEG', 'LOSSY_WEBP', 'LOSSLESS_WEBP', "
	      "'CHARLS', 'LOSSY_JP2', 'LOSSLESS_JP2') OR (NEW.sample_type = "
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_rgbcompr_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent RGB compression')\nWHERE NEW.pixel_type = 'RGB' "
	      "AND ((NEW.sample_type = 'UINT8' AND NEW.compression NOT IN ("
	      "'NONE', 'DEFLATE', 'DEFLATE_NO', 'LZMA', 'LZMA_NO', 'LZ4', 'LZ4_NO', "
	      "'ZSTD', 'ZSTD_NO', 'PNG', 'JPEG', 'LOSSY_WEBP', 'LOSSLESS_WEBP', "
	      "'CHARLS', 'LOSSY_JP2', 'LOSSLESS_JP2') OR (NEW.sample_type = "
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_rgbbands_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent RGB num_bands')\nWHERE NEW.pixel_type = 'RGB' "
	      "AND NEW.num_bands <> 3;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_rgbbands_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent RGB num_bands')\nWHERE NEW.pixel_type = 'RGB' "
	      "AND NEW.num_bands <> 3;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_multisample_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent MULTIBAND sample_type')\nWHERE NEW.pixel_type = 'MULTIBAND' "
	      "AND NEW.sample_type NOT IN ('UINT8', 'UINT16');\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_multisample_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent MULTIBAND sample_type')\nWHERE NEW.pixel_type = 'MULTIBAND' "
	      "AND NEW.sample_type NOT IN ('UINT8', 'UINT16');\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_multicompr_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent MULTIBAND compression')\nWHERE NEW.pixel_type = "
	      "'MULTIBAND' AND ((NEW.num_bands NOT IN (3, 4) AND "
	      "NEW.compression NOT IN ('NONE', 'DEFLATE', 'DEFLATE_NO', 'LZMA', "
	      "'LZMA_NO', 'LZ4', 'LZ4_NO', 'ZSTD', 'ZSTD_NO')) OR	"
	      "(NEW.sample_type <> 'UINT16' AND NEW.num_bands IN (3, 4) AND "
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_multicompr_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent MULTIBAND compression')\nWHERE NEW.pixel_type = "
	      "'MULTIBAND' AND ((NEW.num_bands NOT IN (3, 4) AND "
	      "NEW.compression NOT IN ('NONE', 'DEFLATE', 'DEFLATE_NO', 'LZMA', "
	      "'LZMA_NO', 'LZ4', 'LZ4_NO', 'ZSTD', 'ZSTD_NO')) OR	"
	      "(NEW.sample_type <> 'UINT16' AND NEW.num_bands IN (3, 4) AND "
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_multibands_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent MULTIBAND num_bands')\nWHERE NEW.pixel_type = 'MULTIBAND' "
	      "AND NEW.num_bands < 2;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_multibands_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent MULTIBAND num_bands')\nWHERE NEW.pixel_type = 'MULTIBAND' "
	      "AND NEW.num_bands < 2;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_gridsample_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent DATAGRID sample_type')\nWHERE NEW.pixel_type = 'DATAGRID' "
	      "AND NEW.sample_type NOT IN ('INT8', 'UINT8', 'INT16', 'UINT16', "
	      "'INT32', 'UINT32', 'FLOAT', 'DOUBLE');\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_gridsample_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent DATAGRID sample_type')\nWHERE NEW.pixel_type = 'DATAGRID' "
	      "AND NEW.sample_type NOT IN ('INT8', 'UINT8', 'INT16', 'UINT16', "
	      "'INT32', 'UINT32', 'FLOAT', 'DOUBLE');\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_gridcompr_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent DATAGRID compression')\nWHERE NEW.pixel_type = 'DATAGRID' "
	      "AND (((NEW.sample_type NOT IN ('UINT8', 'UINT16')) AND NEW.compression "
	      "NOT IN ('NONE', 'DEFLATE', 'DEFLATE_NO', 'LZMA', 'LZMA_NO', 'LZ4', "
	      "'LZ4_NO', 'ZSTD', 'ZSTD_NO')) OR ((NEW.sample_type IN ('UINT8', 'UINT16')) "
	      "AND NEW.compression NOT IN ('NONE', 'DEFLATE', 'DEFLATE_NO', 'LZMA', "
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_gridcompr_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent DATAGRID compression')\nWHERE NEW.pixel_type = 'DATAGRID' "
	      "AND (((NEW.sample_type NOT IN ('UINT8', 'UINT16')) AND NEW.compression "
	      "NOT IN ('NONE', 'DEFLATE', 'DEFLATE_NO', 'LZMA', 'LZMA_NO', 'LZ4', "
	      "'LZ4_NO', 'ZSTD', 'ZSTD_NO')) OR ((NEW.sample_type IN ('UINT8', 'UINT16')) "
	      "AND NEW.compression NOT IN ('NONE', 'DEFLATE', 'DEFLATE_NO', 'LZMA', "
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_gridbands_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent DATAGRID num_bands')\nWHERE NEW.pixel_type = 'DATAGRID' "
	      "AND NEW.num_bands <> 1;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_gridbands_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "inconsistent DATAGRID num_bands')\nWHERE NEW.pixel_type = 'DATAGRID' "
	      "AND NEW.num_bands <> 1;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER IF NOT EXISTS raster_coverages_georef_insert\n"
	      "BEFORE INSERT ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages violates constraint: "
	      "inconsistent georeferencing infos')\n"
	      "WHERE NOT ((NEW.horz_resolution IS NULL AND NEW.vert_resolution IS NULL "
	      "AND NEW.srid IS NULL) OR (NEW.horz_resolution IS NOT NULL "
	      "AND NEW.vert_resolution IS NOT NULL AND NEW.srid IS NOT NULL));\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER IF NOT EXISTS raster_coverages_georef_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'update on raster_coverages violates constraint: "
	      "inconsistent georeferencing infos')\n"
	      "WHERE NOT ((NEW.horz_resolution IS NULL AND NEW.vert_resolution IS NULL "
	      "AND NEW.srid IS NULL) OR (NEW.horz_resolution IS NOT NULL "
	      "AND NEW.vert_resolution IS NOT NULL AND NEW.srid IS NOT NULL));\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER IF NOT EXISTS raster_coverages_update\n"
	      "BEFORE UPDATE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'update on raster_coverages violates constraint: "
	      "attempting to change the definition of an already populated Coverage')\n"
	      "WHERE IsPopulatedCoverage(NULL, OLD.coverage_name) = 1 AND "
	      "((OLD.sample_type <> NEW.sample_type) AND (OLD.pixel_type <> NEW.sample_type) "
	      "OR (OLD.num_bands <> NEW.num_bands) OR (OLD.compression <> NEW.compression) "
	      "OR (OLD.quality <> NEW.quality) OR (OLD.tile_width <> NEW.tile_width) "
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER IF NOT EXISTS raster_coverages_delete\n"
	      "BEFORE DELETE ON 'raster_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT, 'delete on raster_coverages violates constraint: "
	      "attempting to delete the definition of an already populated Coverage')\n"
	      "WHERE IsPopulatedCoverage(NULL, OLD.coverage_name) = 1;\nEND";
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
................................................................................
		return 0;
	    }
      }

    if (ok_raster_coverages_srid)
      {
	  /* creating the raster_coverages_srid triggers */
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_srid_name_insert\n"
	      "BEFORE INSERT ON 'raster_coverages_srid'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages_srid violates constraint: "
	      "coverage_name value must not contain a single quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%''%');\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages_srid violates constraint: "
	      "coverage_name value must not contain a double quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%\"%');\n"
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_srid_name_update\n"
	      "BEFORE UPDATE OF 'coverage_name' ON 'raster_coverages_srid'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'update on raster_coverages_srid violates constraint: "
	      "coverage_name value must not contain a single quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%''%');\n"
	      "SELECT RAISE(ABORT,'update on raster_coverages_srid violates constraint: "
	      "coverage_name value must not contain a double quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%\"%');\n"
................................................................................
		return 0;
	    }
      }

    if (ok_raster_coverages_keyword)
      {
	  /* creating the raster_coverages_keyword triggers */
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_keyword_name_insert\n"
	      "BEFORE INSERT ON 'raster_coverages_keyword'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages_keyword violates constraint: "
	      "coverage_name value must not contain a single quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%''%');\n"
	      "SELECT RAISE(ABORT,'insert on raster_coverages_keyword violates constraint: "
	      "coverage_name value must not contain a double quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%\"%');\n"
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS raster_coverages_keyword_name_update\n"
	      "BEFORE UPDATE OF 'coverage_name' ON 'raster_coverages_keyword'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'update on raster_coverages_keyword violates constraint: "
	      "coverage_name value must not contain a single quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%''%');\n"
	      "SELECT RAISE(ABORT,'update on raster_coverages_keyword violates constraint: "
	      "coverage_name value must not contain a double quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%\"%');\n"
................................................................................
		sqlite3_free (err_msg);
		return 0;
	    }
      }
    return 1;
}

SPATIALITE_PRIVATE int
create_raster_coverages (sqlite3 * sqlite)
{
/* creating the "raster_coverages" table */
    char *sql;
    int ret;
    char *err_msg = NULL;
    sql = "CREATE TABLE IF NOT EXISTS raster_coverages (\n"
	"coverage_name TEXT NOT NULL PRIMARY KEY,\n"
	"title TEXT NOT NULL DEFAULT '*** missing Title ***',\n"
	"abstract TEXT NOT NULL DEFAULT '*** missing Abstract ***',\n"
	"sample_type TEXT NOT NULL DEFAULT '*** undefined ***',\n"
	"pixel_type TEXT NOT NULL DEFAULT '*** undefined ***',\n"
	"num_bands INTEGER NOT NULL DEFAULT 1,\n"
	"compression TEXT NOT NULL DEFAULT 'NONE',\n"
................................................................................
      {
	  spatialite_e ("CREATE TABLE 'raster_coverages' error: %s\n", err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }

/* creating the raster_coverages_srid table */
    sql = "CREATE TABLE IF NOT EXISTS raster_coverages_srid (\n"
	"coverage_name TEXT NOT NULL,\n"
	"srid INTEGER NOT NULL,\n"
	"extent_minx DOUBLE,\n"
	"extent_miny DOUBLE,\n"
	"extent_maxx DOUBLE,\n"
	"extent_maxy DOUBLE,\n"
	"CONSTRAINT pk_raster_coverages_srid PRIMARY KEY (coverage_name, srid),\n"
................................................................................
	  spatialite_e ("CREATE TABLE 'raster_coverages_srid' error: %s\n",
			err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }

/* creating the raster_coverages_ref_sys view */
    sql = "CREATE VIEW IF NOT EXISTS raster_coverages_ref_sys AS\n"
	"SELECT c.coverage_name AS coverage_name, c.title AS title, "
	"c.abstract AS abstract, c.sample_type AS sample_type, "
	"c.pixel_type AS pixel_type, c.num_bands AS num_bands, "
	"c.compression AS compression, c.quality AS quality, "
	"c.tile_width AS tile_width, c.tile_height AS tile_height, "
	"c.horz_resolution AS horz_resolution, c.vert_resolution AS vert_resolution, "
	"c.nodata_pixel AS nodata_pixel, c.palette AS palette, "
................................................................................
	  spatialite_e ("CREATE VIEW 'raster_coverages_ref_sys' error: %s\n",
			err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }

/* creating the raster_coverages_keyword table */
    sql = "CREATE TABLE IF NOT EXISTS raster_coverages_keyword (\n"
	"coverage_name TEXT NOT NULL,\n"
	"keyword TEXT NOT NULL,\n"
	"CONSTRAINT pk_raster_coverages_keyword PRIMARY KEY (coverage_name, keyword),\n"
	"CONSTRAINT fk_raster_coverages_keyword FOREIGN KEY (coverage_name) "
	"REFERENCES raster_coverages (coverage_name) ON DELETE CASCADE)";
    ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
    if (ret != SQLITE_OK)
................................................................................
		sqlite3_free (err_msg);
		return 0;
	    }
      }
    return 1;
}

SPATIALITE_PRIVATE int
create_rl2map_configurations (sqlite3 * sqlite, int relaxed)
{
/* creating the "rl2map_configurations" table */
    char *sql;
    int ret;
    char *err_msg = NULL;

................................................................................
	      ok_vector_coverages_keyword = 1;
      }
    sqlite3_free_table (results);

    if (ok_vector_coverages)
      {
	  /* creating the vector_coverages triggers */
	  sql = "CREATE TRIGGER IF NOT EXISTS vector_coverages_name_insert\n"
	      "BEFORE INSERT ON 'vector_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on vector_coverages violates constraint: "
	      "coverage_name value must not contain a single quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%''%');\n"
	      "SELECT RAISE(ABORT,'insert on vector_coverages violates constraint: "
	      "coverage_name value must not contain a double quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%\"%');\n"
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql = "CREATE TRIGGER IF NOT EXISTS vector_coverages_name_update\n"
	      "BEFORE UPDATE OF 'coverage_name' ON 'vector_coverages'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'update on vector_coverages violates constraint: "
	      "coverage_name value must not contain a single quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%''%');\n"
	      "SELECT RAISE(ABORT,'update on vector_coverages violates constraint: "
	      "coverage_name value must not contain a double quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%\"%');\n"
................................................................................
		return 0;
	    }
      }

    if (ok_vector_coverages_srid)
      {
	  /* creating the vector_coverages_srid triggers */
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS vector_coverages_srid_name_insert\n"
	      "BEFORE INSERT ON 'vector_coverages_srid'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on vector_coverages_srid violates constraint: "
	      "coverage_name value must not contain a single quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%''%');\n"
	      "SELECT RAISE(ABORT,'insert on vector_coverages_srid violates constraint: "
	      "coverage_name value must not contain a double quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%\"%');\n"
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS vector_coverages_srid_name_update\n"
	      "BEFORE UPDATE OF 'coverage_name' ON 'vector_coverages_srid'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'update on vector_coverages_srid violates constraint: "
	      "coverage_name value must not contain a single quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%''%');\n"
	      "SELECT RAISE(ABORT,'update on vector_coverages_srid violates constraint: "
	      "coverage_name value must not contain a double quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%\"%');\n"
................................................................................
		return 0;
	    }
      }

    if (ok_vector_coverages_keyword)
      {
	  /* creating the vector_coverages_keyword triggers */
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS vector_coverages_keyword_name_insert\n"
	      "BEFORE INSERT ON 'vector_coverages_keyword'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'insert on vector_coverages_keyword violates constraint: "
	      "coverage_name value must not contain a single quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%''%');\n"
	      "SELECT RAISE(ABORT,'insert on vector_coverages_keyword violates constraint: "
	      "coverage_name value must not contain a double quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%\"%');\n"
................................................................................
	  ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
	  if (ret != SQLITE_OK)
	    {
		spatialite_e ("SQL error: %s\n", err_msg);
		sqlite3_free (err_msg);
		return 0;
	    }
	  sql =
	      "CREATE TRIGGER IF NOT EXISTS vector_coverages_keyword_name_update\n"
	      "BEFORE UPDATE OF 'coverage_name' ON 'vector_coverages_keyword'\nFOR EACH ROW BEGIN\n"
	      "SELECT RAISE(ABORT,'update on vector_coverages_keyword violates constraint: "
	      "coverage_name value must not contain a single quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%''%');\n"
	      "SELECT RAISE(ABORT,'update on vector_coverages_keyword violates constraint: "
	      "coverage_name value must not contain a double quote')\n"
	      "WHERE NEW.coverage_name LIKE ('%\"%');\n"
................................................................................
		sqlite3_free (err_msg);
		return 0;
	    }
      }
    return 1;
}

SPATIALITE_PRIVATE int
create_vector_coverages (sqlite3 * sqlite)
{
/* creating the "vector_coverages" table */
    char *sql;
    int ret;
    char *err_msg = NULL;
    sql = "CREATE TABLE IF NOT EXISTS vector_coverages (\n"
	"coverage_name TEXT NOT NULL PRIMARY KEY,\n"
	"f_table_name TEXT,\n"
	"f_geometry_column TEXT,\n"
	"view_name TEXT,\n"
	"view_geometry TEXT,\n"
	"virt_name TEXT,\n"
	"virt_geometry TEXT,\n"
................................................................................
    if (ret != SQLITE_OK)
      {
	  spatialite_e ("CREATE TABLE 'vector_coverages' error: %s\n", err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }
/* creating the VectorLayers index */
    sql =
	"CREATE UNIQUE INDEX IF NOT EXISTS idx_vector_coverages ON vector_coverages "
	"(f_table_name, f_geometry_column)";
    ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
    if (ret != SQLITE_OK)
      {
	  spatialite_e ("CREATE INDEX 'idx_vector_coverages' error: %s\n",
			err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }

/* creating the vector_coverages_srid table */
    sql = "CREATE TABLE IF NOT EXISTS vector_coverages_srid (\n"
	"coverage_name TEXT NOT NULL,\n"
	"srid INTEGER NOT NULL,\n"
	"extent_minx DOUBLE,\n"
	"extent_miny DOUBLE,\n"
	"extent_maxx DOUBLE,\n"
	"extent_maxy DOUBLE,\n"
	"CONSTRAINT pk_vector_coverages_srid PRIMARY KEY (coverage_name, srid),\n"
................................................................................
	  spatialite_e ("CREATE TABLE 'vector_coverages_srid' error: %s\n",
			err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }

/* creating the vector_coverages_ref_sys view */
    sql = "CREATE VIEW IF NOT EXISTS vector_coverages_ref_sys AS\n"
	"SELECT v.coverage_name AS coverage_name, v.title AS title, v.abstract AS abstract, "
	"v.is_queryable AS is_queryable, v.geo_minx AS geo_minx, v.geo_miny AS geo_miny, "
	"v.geo_maxx AS geo_maxx, v.geo_maxy AS geo_maxy, v.extent_minx AS extent_minx, "
	"v.extent_miny AS extent_miny, v.extent_maxx AS extent_maxx, v.extent_maxy AS extent_maxy, "
	"s.srid AS srid, 1 AS native_srid, s.auth_name AS auth_name, s.auth_srid AS auth_srid, "
	"s.ref_sys_name AS ref_sys_name, s.proj4text AS proj4text\n"
	"FROM vector_coverages AS v\n"
................................................................................
	  spatialite_e ("CREATE VIEW 'vector_coverages_ref_sys' error: %s\n",
			err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }

/* creating the vector_coverages_keyword table */
    sql = "CREATE TABLE IF NOT EXISTS vector_coverages_keyword (\n"
	"coverage_name TEXT NOT NULL,\n"
	"keyword TEXT NOT NULL,\n"
	"CONSTRAINT pk_vector_coverages_keyword PRIMARY KEY (coverage_name, keyword),\n"
	"CONSTRAINT fk_vector_coverages_keyword FOREIGN KEY (coverage_name) "
	"REFERENCES vector_coverages (coverage_name) ON DELETE CASCADE)";
    ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
    if (ret != SQLITE_OK)
................................................................................
      }
    for (i = 1; i <= rows; i++)
	exists = 1;
    sqlite3_free_table (results);
    return exists;
}

SPATIALITE_PRIVATE int
create_wms_tables (sqlite3 * sqlite)
{
/* creating the WMS support tables */
    char *sql;
    int ret;
    char *err_msg = NULL;
    sql = "CREATE TABLE IF NOT EXISTS wms_getcapabilities (\n"
	"id INTEGER PRIMARY KEY AUTOINCREMENT,\n"
	"url TEXT NOT NULL,\n"
	"title TEXT NOT NULL DEFAULT '*** undefined ***',\n"
	"abstract TEXT NOT NULL DEFAULT '*** undefined ***')";
    ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
    if (ret != SQLITE_OK)
      {
	  spatialite_e ("CREATE TABLE 'wms_getcapabilities' error: %s\n",
			err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }
    sql =
	"CREATE UNIQUE INDEX IF NOT EXISTS idx_wms_getcapabilities ON wms_getcapabilities (url)";
    ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
    if (ret != SQLITE_OK)
      {
	  spatialite_e ("CREATE INDEX 'idx_wms_getcapabilities' error: %s\n",
			err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }

    sql = "CREATE TABLE IF NOT EXISTS wms_getmap (\n"
	"id INTEGER PRIMARY KEY AUTOINCREMENT,\n"
	"parent_id INTEGER NOT NULL,\n"
	"url TEXT NOT NULL,\n"
	"layer_name TEXT NOT NULL,\n"
	"title TEXT NOT NULL DEFAULT '*** undefined ***',\n"
	"abstract TEXT NOT NULL DEFAULT '*** undefined ***',\n"
	"version TEXT NOT NULL,\n"
................................................................................
    if (ret != SQLITE_OK)
      {
	  spatialite_e ("CREATE INDEX 'idx_wms_getmap' error: %s\n", err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }

    sql = "CREATE TABLE IF NOT EXISTS wms_settings (\n"
	"id INTEGER PRIMARY KEY AUTOINCREMENT,\n"
	"parent_id INTEGER NOT NULL,\n"
	"key TEXT NOT NULL CHECK (Lower(key) IN ('version', 'format', 'style')),\n"
	"value TEXT NOT NULL,\n"
	"is_default INTEGER NOT NULL CHECK (is_default IN (0, 1)),\n"
	"CONSTRAINT fk_wms_settings FOREIGN KEY (parent_id) "
	"REFERENCES wms_getmap (id) ON DELETE CASCADE)";
................................................................................
    if (ret != SQLITE_OK)
      {
	  spatialite_e ("CREATE INDEX 'idx_wms_settings' error: %s\n", err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }

    sql = "CREATE TABLE IF NOT EXISTS wms_ref_sys (\n"
	"id INTEGER PRIMARY KEY AUTOINCREMENT,\n"
	"parent_id INTEGER NOT NULL,\n"
	"srs TEXT NOT NULL,\n"
	"minx DOUBLE NOT NULL,\n"
	"miny DOUBLE NOT NULL,\n"
	"maxx DOUBLE NOT NULL,\n"
	"maxy DOUBLE NOT NULL,\n"
................................................................................
    ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
    if (ret != SQLITE_OK)
      {
	  spatialite_e ("CREATE TABLE 'wms_ref_sys' error: %s\n", err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }
    sql =
	"CREATE UNIQUE INDEX IF NOT EXISTS idx_wms_ref_sys ON wms_ref_sys (parent_id, srs)";
    ret = sqlite3_exec (sqlite, sql, NULL, NULL, &err_msg);
    if (ret != SQLITE_OK)
      {
	  spatialite_e ("CREATE INDEX 'idx_wms_ref_sys' error: %s\n", err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }
................................................................................
		sqlite3_free (err_msg);
		return 0;
	    }
      }
    return 1;
}

SPATIALITE_PRIVATE int
create_external_graphics (sqlite3 * sqlite)
{
/* creating the SE_external_graphics table */
    char *sql;
    int ret;
    char *err_msg = NULL;
    sql = "CREATE TABLE SE_external_graphics (\n"
................................................................................
		sqlite3_free (err_msg);
		return 0;
	    }
      }
    return 1;
}

SPATIALITE_PRIVATE int
create_fonts (sqlite3 * sqlite)
{
/* creating the SE_fonts table */
    char *sql;
    int ret;
    char *err_msg = NULL;
    sql = "CREATE TABLE SE_fonts (\n"
................................................................................
		sqlite3_free (err_msg);
		return 0;
	    }
      }
    return 1;
}

SPATIALITE_PRIVATE int
create_vector_styles (sqlite3 * sqlite, int relaxed)
{
/* creating the SE_vector_styles table */
    char *sql;
    int ret;
    char *err_msg = NULL;
    sql = "CREATE TABLE SE_vector_styles (\n"
................................................................................
		sqlite3_free (err_msg);
		return 0;
	    }
      }
    return 1;
}

SPATIALITE_PRIVATE int
create_vector_styled_layers (sqlite3 * sqlite)
{
/* creating the SE_vector_styled_layers table */
    char *sql;
    int ret;
    char *err_msg = NULL;
    sql = "CREATE TABLE SE_vector_styled_layers (\n"
................................................................................
		sqlite3_free (err_msg);
		return 0;
	    }
      }
    return 1;
}

SPATIALITE_PRIVATE int
create_raster_styles (sqlite3 * sqlite, int relaxed)
{
/* creating the SE_raster_styles table */
    char *sql;
    int ret;
    char *err_msg = NULL;
    sql = "CREATE TABLE SE_raster_styles (\n"
................................................................................
		sqlite3_free (err_msg);
		return 0;
	    }
      }
    return 1;
}

SPATIALITE_PRIVATE int
create_raster_styled_layers (sqlite3 * sqlite)
{
/* creating the SE_raster_styled_layers table */
    char *sql;
    int ret;
    char *err_msg = NULL;
    sql = "CREATE TABLE SE_raster_styled_layers (\n"
................................................................................
	  return 0;
      }
    if (!create_raster_styled_layers_triggers (sqlite))
	return 0;
    return 1;
}

SPATIALITE_PRIVATE int
create_external_graphics_view (sqlite3 * sqlite)
{
/* creating the SE_external_graphics_view view */
    char *sql_statement;
    int ret;
    char *err_msg = NULL;
    sql_statement =
................................................................................
	      ("CREATE VIEW 'SE_external_graphics_view' error: %s\n", err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }
    return 1;
}

SPATIALITE_PRIVATE int
create_fonts_view (sqlite3 * sqlite)
{
/* creating the SE_fonts_view view */
    char *sql_statement;
    int ret;
    char *err_msg = NULL;
    sql_statement =
................................................................................
	  spatialite_e ("CREATE VIEW 'SE_fonts_view' error: %s\n", err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }
    return 1;
}

SPATIALITE_PRIVATE int
create_vector_styles_view (sqlite3 * sqlite)
{
/* creating the SE_vector_styles_view view */
    char *sql_statement;
    int ret;
    char *err_msg = NULL;
    sql_statement =
................................................................................
	      ("CREATE VIEW 'SE_vector_styles_view' error: %s\n", err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }
    return 1;
}

SPATIALITE_PRIVATE int
create_raster_styles_view (sqlite3 * sqlite)
{
/* creating the SE_raster_styles_view view */
    char *sql_statement;
    int ret;
    char *err_msg = NULL;
    sql_statement =
................................................................................
	      ("CREATE VIEW 'SE_raster_styles_view' error: %s\n", err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }
    return 1;
}

SPATIALITE_PRIVATE int
create_rl2map_configurations_view (sqlite3 * sqlite)
{
/* creating the rl2map_configurations_view view */
    char *sql_statement;
    int ret;
    char *err_msg = NULL;
    sql_statement =
................................................................................
	      ("CREATE VIEW 'rl2map_configurations_view' error: %s\n", err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }
    return 1;
}

SPATIALITE_PRIVATE int
create_vector_styled_layers_view (sqlite3 * sqlite)
{
/* creating the SE_vector_styled_layers_view view */
    char *sql_statement;
    int ret;
    char *err_msg = NULL;
    sql_statement =
................................................................................
	      ("SELECT SE_AutoRegisterStandardBrushes() error: %s\n", err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }
    return 1;
}

SPATIALITE_PRIVATE int
create_raster_styled_layers_view (sqlite3 * sqlite)
{
/* creating the SE_raster_styled_layers_view view */
    char *sql_statement;
    int ret;
    char *err_msg = NULL;
    sql_statement =
................................................................................
      }
    for (i = 1; i <= rows; i++)
	exists = 1;
    sqlite3_free_table (results);
    return exists;
}

SPATIALITE_PRIVATE int
create_iso_metadata (sqlite3 * sqlite, int relaxed)
{
/* creating the ISO_metadata table */
    char *sql;
    int ret;
    char *err_msg = NULL;
    sql = "CREATE TABLE ISO_metadata (\n"
................................................................................
			err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }
    return 1;
}

SPATIALITE_PRIVATE int
create_iso_metadata_reference (sqlite3 * sqlite)
{
/* creating the ISO_metadata_reference table */
    char *sql;
    int ret;
    char *err_msg = NULL;
    sql = "CREATE TABLE ISO_metadata_reference (\n"
................................................................................
	       err_msg);
	  sqlite3_free (err_msg);
	  return 0;
      }
    return 1;
}

SPATIALITE_PRIVATE int
create_iso_metadata_view (sqlite3 * sqlite)
{
/* creating the ISO_metadata_view view */
    char *sql;
    int ret;
    char *err_msg = NULL;
    sql = "CREATE VIEW ISO_metadata_view AS\n"
................................................................................
    return 1;

  error:
    return 0;
}

#endif /* end including LIBXML2 */

static int
do_check_if_table_exists (sqlite3 * sqlite, const char *table)
{
/* checking if a Table is already defined */
    int ret;
    int i;
    char **results;
    int rows;
    int columns;
    int count = 0;
    char *qtable = gaiaDoubleQuotedSql (table);
    char *sql = sqlite3_mprintf ("PRAGMA table_info(\"%s\")", qtable);
    free (qtable);
    ret = sqlite3_get_table (sqlite, sql, &results, &rows, &columns, NULL);
    sqlite3_free (sql);
    if (ret != SQLITE_OK)
	return 0;
    for (i = 1; i <= rows; i++)
	count++;
    sqlite3_free_table (results);
    if (count == 0)
	return 0;
    return 1;
}

SPATIALITE_PRIVATE int
createMissingSystemTables (sqlite3 * sqlite, const void *cache, int relaxed,
			   int transaction, char **err_msg)
{
/* attempting to create all missing System Tables required by version 5 */
#ifndef ENABLE_LIBXML2		/* unsupported LIBXML2 */
    *err_msg =
	sqlite3_mprintf
	("this build does not support LIBXML2 ... cowardly quitting");
    return 0;
#endif
#ifndef ENABLE_RTTOPO		/* unsipported RTTOPO */
    *err_msg =
	sqlite3_mprintf
	("this build does not support RTTOPO ... cowardly quitting");
    return 0;
#endif

#ifdef ENABLE_LIBXML2		/* only if LibXML2 support is available */
#ifdef ENABLE_RTTOPO		/* RTTOPO is supported */
    int ret;
    struct str_tables
    {
	const char *table_name;
	int (*creator) (sqlite3 * sqlite);
	int (*creator_void) (void *sqlite);
	int (*creator_relaxed) (sqlite3 * sqlite, int relaxed);
	int (*creator_cache) (sqlite3 * sqlite, const void *cache);
    };
    static struct str_tables tables[] = {
	{"data_licenses", create_data_licenses, NULL, NULL, NULL},
	{"raster_coverages", create_raster_coverages, NULL, NULL, NULL},
	{"raster_coverages_keyword", create_raster_coverages, NULL, NULL, NULL},
	{"raster_coverages_srid", create_raster_coverages, NULL, NULL, NULL},
	{"raster_coverages_ref_sys", create_raster_coverages, NULL, NULL, NULL},
	{"vector_coverages", create_vector_coverages, NULL, NULL, NULL},
	{"vector_coverages_keyword", create_vector_coverages, NULL, NULL, NULL},
	{"vector_coverages_srid", create_vector_coverages, NULL, NULL, NULL},
	{"vector_coverages_ref_sys", create_vector_coverages, NULL, NULL, NULL},
	{"wms_getcapabilities", create_wms_tables, NULL, NULL, NULL},
	{"wms_getmap", create_wms_tables, NULL, NULL, NULL},
	{"wms_ref_sys", create_wms_tables, NULL, NULL, NULL},
	{"wms_settings", create_wms_tables, NULL, NULL, NULL},
	{"topologies", NULL, do_create_topologies, NULL, NULL},
	{"networks", NULL, do_create_networks, NULL, NULL},
	{"SE_external_graphics", create_external_graphics, NULL, NULL, NULL},
	{"SE_external_graphics_view", create_external_graphics_view, NULL, NULL,
	 NULL},
	{"SE_fonts", create_fonts, NULL, NULL, NULL},
	{"SE_fonts_view", create_fonts_view, NULL, NULL, NULL},
	{"SE_raster_styles", NULL, NULL, create_raster_styles, NULL},
	{"SE_raster_styles_view", create_raster_styles_view, NULL, NULL, NULL},
	{"SE_raster_styled_layers", create_raster_styled_layers, NULL, NULL,
	 NULL},
	{"SE_raster_styled_layers_view", create_raster_styled_layers_view, NULL,
	 NULL, NULL},
	{"SE_vector_styles", NULL, NULL, create_vector_styles, NULL},
	{"SE_vector_styles_view", create_vector_styles_view, NULL, NULL, NULL},
	{"SE_vector_styled_layers", create_vector_styled_layers, NULL, NULL,
	 NULL},
	{"SE_vector_styled_layers_view", create_vector_styled_layers_view, NULL,
	 NULL, NULL},
	{"ISO_metadata", NULL, NULL, create_iso_metadata, NULL},
	{"ISO_metadata_reference", create_iso_metadata_reference, NULL, NULL,
	 NULL},
	{"ISO_metadata_view", create_iso_metadata_view, NULL, NULL, NULL},
	{"stored_procedures", NULL, NULL, NULL, gaia_stored_proc_create_tables},
	{"stored_variables", NULL, NULL, NULL, gaia_stored_proc_create_tables},
	{"rl2map_configurations", NULL, NULL, create_rl2map_configurations,
	 NULL},
	{"rl2map_configurations_view", create_rl2map_configurations_view, NULL,
	 NULL, NULL},
	{NULL, NULL, NULL, NULL, NULL}
    };
    struct str_tables *p_table = tables;

    if (transaction)
      {
	  /* starting a Transaction */
	  ret = sqlite3_exec (sqlite, "BEGIN", NULL, NULL, NULL);
	  if (ret != SQLITE_OK)
	    {
		*err_msg =
		    sqlite3_mprintf ("Unable to start a Transaction (BEGIN)");
		return 0;
	    }
      }

    while (p_table->table_name != NULL)
      {
	  int exists = do_check_if_table_exists (sqlite, p_table->table_name);
	  if (!exists)
	    {
		if (p_table->creator != NULL)
		    ret = p_table->creator (sqlite);
		if (p_table->creator_void != NULL)
		    ret = p_table->creator_void ((void *) sqlite);
		if (p_table->creator_relaxed != NULL)
		    ret = p_table->creator_relaxed (sqlite, relaxed);
		if (p_table->creator_cache != NULL)
		    ret = p_table->creator_cache (sqlite, cache);
		if (!ret)
		  {
		      *err_msg =
			  sqlite3_mprintf ("Unable to create \"%s\"",
					   p_table->table_name);
		      return 0;
		  }
	    }
	  if (strcmp (p_table->table_name, "SE_external_graphics") == 0)
	    {
		/* autoregistering all Standard Brushes */
		ret =
		    sqlite3_exec (sqlite,
				  "SELECT SE_AutoRegisterStandardBrushes()",
				  NULL, NULL, NULL);
		if (ret != SQLITE_OK)
		  {
		      *err_msg =
			  sqlite3_mprintf
			  ("Unexpected failure when registering Standard Brushes");
		      return 0;
		  }
	    }
	  p_table++;
      }

    if (transaction)
      {
	  /* confirming the still pending Transaction */
	  ret = sqlite3_exec (sqlite, "COMMIT", NULL, NULL, NULL);
	  if (ret != SQLITE_OK)
	    {
		*err_msg =
		    sqlite3_mprintf
		    ("Unable to confirm a Transaction (COMMIT)");
		return 0;
	    }
      }

/* full success */
    *err_msg = NULL;
    return 1;
#endif /* end RTTOPO */
#endif /* end LIBXML2 */
}

	  spatialite_e ("SQL error: %s: %s\n", sql, errMsg);
	  sqlite3_free (errMsg);
	  return 0;
      }
    return 1;
}

static int
create_geometry_columns_times (sqlite3 * sqlite)
{
    char sql[4186];
    char *errMsg = NULL;
    int ret;

    if (sqlite3_db_readonly (sqlite, "MAIN") == 1)
      {
................................................................................
	  spatialite_e ("SQL error: %s: %s\n", sql, errMsg);
	  sqlite3_free (errMsg);
	  return 0;
      }
    return 1;
}

static int
create_data_licenses (sqlite3 * sqlite)
{
    char sql[4186];
    char *errMsg = NULL;
    int ret;

    if (sqlite3_db_readonly (sqlite, "MAIN") == 1)
................................................................................
	return 0;
    if (!create_geometry_columns_field_infos (sqlite))
	return 0;
    if (!create_views_geometry_columns_field_infos (sqlite))
	return 0;
    if (!create_virts_geometry_columns_field_infos (sqlite))
	return 0;
    if (!create_geometry_columns_times (sqlite))
	return 0;
    if (!create_geometry_columns_auth (sqlite))
	return 0;
    if (!create_views_geometry_columns_auth (sqlite))
	return 0;
    if (!create_virts_geometry_columns_auth (sqlite))
	return 0;

	  spatialite_e ("SQL error: %s: %s\n", sql, errMsg);
	  sqlite3_free (errMsg);
	  return 0;
      }
    return 1;
}

SPATIALITE_PRIVATE int
create_geometry_columns_time (sqlite3 * sqlite)
{
    char sql[4186];
    char *errMsg = NULL;
    int ret;

    if (sqlite3_db_readonly (sqlite, "MAIN") == 1)
      {
................................................................................
	  spatialite_e ("SQL error: %s: %s\n", sql, errMsg);
	  sqlite3_free (errMsg);
	  return 0;
      }
    return 1;
}

SPATIALITE_PRIVATE int
create_data_licenses (sqlite3 * sqlite)
{
    char sql[4186];
    char *errMsg = NULL;
    int ret;

    if (sqlite3_db_readonly (sqlite, "MAIN") == 1)
................................................................................
	return 0;
    if (!create_geometry_columns_field_infos (sqlite))
	return 0;
    if (!create_views_geometry_columns_field_infos (sqlite))
	return 0;
    if (!create_virts_geometry_columns_field_infos (sqlite))
	return 0;
    if (!create_geometry_columns_time (sqlite))
	return 0;
    if (!create_geometry_columns_auth (sqlite))
	return 0;
    if (!create_views_geometry_columns_auth (sqlite))
	return 0;
    if (!create_virts_geometry_columns_auth (sqlite))
	return 0;

	  sqlite3_free (x.z);
      }
    else
      {
	  sqlite3_result_text (context, x.z, x.nUsed, sqlite3_free);
      }
}
















































































static void
fnct_spatialite_version (sqlite3_context * context, int argc,
			 sqlite3_value ** argv)
{
/* SQL function:
/ spatialite_version()
................................................................................
*/
    char *errMsg = NULL;
    int ret;
    int transaction = 0;
    const char *xmode = NULL;
    int retval;
    char *sql;

    sqlite3 *sqlite = sqlite3_context_db_handle (context);
    GAIA_UNUSED ();		/* LCOV_EXCL_LINE */
    if (argc == 1)
      {
	  if (sqlite3_value_type (argv[0]) == SQLITE_TEXT)
	    {
		xmode = (const char *) sqlite3_value_text (argv[0]);
................................................................................
    sqlite3_free (sql);
    if (retval != 1)
	goto error;
    if (!createAdvancedMetaData (sqlite))
	goto error;

#ifdef ENABLE_LIBXML2		/* only if LibXML2 support is available */

    if (xmode != NULL)
      {
	  if (strcasecmp (xmode, "NONE") == 0
	      || strcasecmp (xmode, "EMPTY") == 0)
	      ;
	  else



	    {
		/* executing CreateIsoMetadataTables() */
		sql = sqlite3_mprintf ("SELECT CreateIsoMetadataTables()");
		retval = do_execute_sql_with_retval (sqlite, sql, &errMsg);
		sqlite3_free (sql);
		if (retval != 1)
		    goto error;
	    }
      }
#endif

/* executing CreateRasterCoveragesTable() */
    sql = sqlite3_mprintf ("SELECT CreateRasterCoveragesTable()");
    retval = do_execute_sql_with_retval (sqlite, sql, &errMsg);
    sqlite3_free (sql);
................................................................................
				fnct_spatialite_version, 0, 0,
				splite_close_callback);
#else
    sqlite3_create_function_v2 (db, "spatialite_version", 0,
				SQLITE_UTF8 | SQLITE_DETERMINISTIC, 0,
				fnct_spatialite_version, 0, 0, 0);
#endif











    sqlite3_create_function_v2 (db, "spatialite_target_cpu", 0,
				SQLITE_UTF8 | SQLITE_DETERMINISTIC, 0,
				fnct_spatialite_target_cpu, 0, 0, 0);
    sqlite3_create_function_v2 (db, "check_strict_sql_quoting", 0,
				SQLITE_UTF8 | SQLITE_DETERMINISTIC, 0,
				fnct_check_strict_sql_quoting, 0, 0, 0);

	  sqlite3_free (x.z);
      }
    else
      {
	  sqlite3_result_text (context, x.z, x.nUsed, sqlite3_free);
      }
}

static void
fnct_createMissingSystemTables (sqlite3_context * context, int argc,
				sqlite3_value ** argv)
{
/* SQL function:
/ CreateMissingSystemTables()
/  or
/ CreateMissingSystemTables(bool relaxed)
/  or
/ CreateMissingSystemTables(bool relaxed, bool transaction)
/
/ creates all missing system tables required by version 5
/ returns 1 on success
/ RAISES AN EXCEPTION on failure or on invalid arguments
*/
    int relaxed = 0;
    int transaction = 0;
    int ret;
    char *err_msg = NULL;
    char *msg = NULL;
    sqlite3 *sqlite = sqlite3_context_db_handle (context);
    struct splite_internal_cache *cache = sqlite3_user_data (context);
    GAIA_UNUSED ();		/* LCOV_EXCL_LINE */
    if (argc >= 1)
      {
	  if (sqlite3_value_type (argv[0]) != SQLITE_INTEGER)
	      goto invalid_arg1;
	  relaxed = sqlite3_value_int (argv[0]);
      }
    if (argc >= 2)
      {
	  if (sqlite3_value_type (argv[1]) != SQLITE_INTEGER)
	      goto invalid_arg2;
	  transaction = sqlite3_value_int (argv[1]);
      }

    ret =
	createMissingSystemTables (sqlite, cache, relaxed, transaction,
				   &err_msg);
    if (ret <= 0)
	goto error;
    msg =
	sqlite3_mprintf ("successfully executed (%d Table%s been created)", ret,
			 (ret == 1) ? " has" : "s have");
    updateSpatiaLiteHistory (sqlite, "*** CreateMissingSystemTables ***", NULL,
			     msg);
    sqlite3_free (msg);
    sqlite3_result_int (context, ret);
    return;

  invalid_arg1:
    msg =
	"CreateMissingSystemTables exception - first argument (relaxed) expected to be an INTEGER.";
    sqlite3_result_error (context, msg, -1);
    return;

  invalid_arg2:
    msg =
	"CreateMissingSystemTables exception - second argument (transaction) expected to be an INTEGER.";
    sqlite3_result_error (context, msg, -1);
    return;

  error:
    if (err_msg == NULL)
	msg =
	    sqlite3_mprintf
	    ("CreateMissingSystemTables exception - Unknown failure reason.");
    else
      {
	  msg =
	      sqlite3_mprintf ("CreateMissingSystemTables exception - %s.",
			       err_msg);
	  sqlite3_free (err_msg);
      }
    sqlite3_result_error (context, msg, -1);
    sqlite3_free (msg);
    return;
}

static void
fnct_spatialite_version (sqlite3_context * context, int argc,
			 sqlite3_value ** argv)
{
/* SQL function:
/ spatialite_version()
................................................................................
*/
    char *errMsg = NULL;
    int ret;
    int transaction = 0;
    const char *xmode = NULL;
    int retval;
    char *sql;
    int ok_isometa = 0;
    sqlite3 *sqlite = sqlite3_context_db_handle (context);
    GAIA_UNUSED ();		/* LCOV_EXCL_LINE */
    if (argc == 1)
      {
	  if (sqlite3_value_type (argv[0]) == SQLITE_TEXT)
	    {
		xmode = (const char *) sqlite3_value_text (argv[0]);
................................................................................
    sqlite3_free (sql);
    if (retval != 1)
	goto error;
    if (!createAdvancedMetaData (sqlite))
	goto error;

#ifdef ENABLE_LIBXML2		/* only if LibXML2 support is available */
    ok_isometa = 1;
    if (xmode != NULL)
      {
	  if (strcasecmp (xmode, "NONE") == 0
	      || strcasecmp (xmode, "EMPTY") == 0)


	      ok_isometa = 0;
      }
    if (ok_isometa)
      {
	  /* executing CreateIsoMetadataTables() */
	  sql = sqlite3_mprintf ("SELECT CreateIsoMetadataTables()");
	  retval = do_execute_sql_with_retval (sqlite, sql, &errMsg);
	  sqlite3_free (sql);
	  if (retval != 1)
	      goto error;

      }
#endif

/* executing CreateRasterCoveragesTable() */
    sql = sqlite3_mprintf ("SELECT CreateRasterCoveragesTable()");
    retval = do_execute_sql_with_retval (sqlite, sql, &errMsg);
    sqlite3_free (sql);
................................................................................
				fnct_spatialite_version, 0, 0,
				splite_close_callback);
#else
    sqlite3_create_function_v2 (db, "spatialite_version", 0,
				SQLITE_UTF8 | SQLITE_DETERMINISTIC, 0,
				fnct_spatialite_version, 0, 0, 0);
#endif

    sqlite3_create_function_v2 (db, "CreateMissingSystemTables", 0,
				SQLITE_UTF8 | SQLITE_DETERMINISTIC, cache,
				fnct_createMissingSystemTables, 0, 0, 0);
    sqlite3_create_function_v2 (db, "CreateMissingSystemTables", 1,
				SQLITE_UTF8 | SQLITE_DETERMINISTIC, cache,
				fnct_createMissingSystemTables, 0, 0, 0);
    sqlite3_create_function_v2 (db, "CreateMissingSystemTables", 2,
				SQLITE_UTF8 | SQLITE_DETERMINISTIC, cache,
				fnct_createMissingSystemTables, 0, 0, 0);

    sqlite3_create_function_v2 (db, "spatialite_target_cpu", 0,
				SQLITE_UTF8 | SQLITE_DETERMINISTIC, 0,
				fnct_spatialite_target_cpu, 0, 0, 0);
    sqlite3_create_function_v2 (db, "check_strict_sql_quoting", 0,
				SQLITE_UTF8 | SQLITE_DETERMINISTIC, 0,
				fnct_check_strict_sql_quoting, 0, 0, 0);

      {
	  pn = p->next;
	  free_epsg_def (p);
	  p = pn;
      }
}

static void
create_spatial_ref_sys_aux (sqlite3 * handle)
{
/* just in case, we'll create the SPATIAL_REF_SYS_AUX table */

    const char *sql = "CREATE TABLE IF NOT EXISTS spatial_ref_sys_aux (\n"
	"\tsrid INTEGER NOT NULL PRIMARY KEY,\n"
	"\tis_geographic INTEGER,\n"
	"\thas_flipped_axes INTEGER,\n"
	"\tspheroid TEXT,\n"
	"\tprime_meridian TEXT,\n"
	"\tdatum TEXT,\n"
................................................................................
	"\tunit TEXT,\n"
	"\taxis_1_name TEXT,\n"
	"\taxis_1_orientation TEXT,\n"
	"\taxis_2_name TEXT,\n"
	"\taxis_2_orientation TEXT,\n"
	"\tCONSTRAINT fk_sprefsys FOREIGN KEY (srid) "
	"\tREFERENCES spatial_ref_sys (srid))";
    sqlite3_exec (handle, sql, NULL, NULL, NULL);


/* creating the SPATIAL_REF_SYS_ALL view */
    sql = "CREATE VIEW IF NOT EXISTS spatial_ref_sys_all AS\n"
	"SELECT a.srid AS srid, a.auth_name AS auth_name, "
	"a.auth_srid AS auth_srid, a.ref_sys_name AS ref_sys_name,\n"
	"b.is_geographic AS is_geographic, "
	"b.has_flipped_axes AS has_flipped_axes, "
	"b.spheroid AS spheroid, b.prime_meridian AS prime_meridian, "
................................................................................
	"b.axis_1_name AS axis_1_name, "
	"b.axis_1_orientation AS axis_1_orientation,\n"
	"b.axis_2_name AS axis_2_name, "
	"b.axis_2_orientation AS axis_2_orientation,\n"
	"a.proj4text AS proj4text, a.srtext AS srtext\n"
	"FROM spatial_ref_sys AS a\n"
	"LEFT JOIN spatial_ref_sys_aux AS b ON (a.srid = b.srid)";
    sqlite3_exec (handle, sql, NULL, NULL, NULL);



}

static int
populate_spatial_ref_sys (sqlite3 * handle, int mode, int metadata)
{
/* populating the EPSG dataset into the SPATIAL_REF_SYS table */
    struct epsg_defs *first = NULL;

      {
	  pn = p->next;
	  free_epsg_def (p);
	  p = pn;
      }
}

SPATIALITE_PRIVATE int
create_spatial_ref_sys_aux (sqlite3 * handle)
{
/* just in case, we'll create the SPATIAL_REF_SYS_AUX table */
int ret;
    const char *sql = "CREATE TABLE IF NOT EXISTS spatial_ref_sys_aux (\n"
	"\tsrid INTEGER NOT NULL PRIMARY KEY,\n"
	"\tis_geographic INTEGER,\n"
	"\thas_flipped_axes INTEGER,\n"
	"\tspheroid TEXT,\n"
	"\tprime_meridian TEXT,\n"
	"\tdatum TEXT,\n"
................................................................................
	"\tunit TEXT,\n"
	"\taxis_1_name TEXT,\n"
	"\taxis_1_orientation TEXT,\n"
	"\taxis_2_name TEXT,\n"
	"\taxis_2_orientation TEXT,\n"
	"\tCONSTRAINT fk_sprefsys FOREIGN KEY (srid) "
	"\tREFERENCES spatial_ref_sys (srid))";
    ret = sqlite3_exec (handle, sql, NULL, NULL, NULL);
	if (ret != SQLITE_OK)
	  return 0;
/* creating the SPATIAL_REF_SYS_ALL view */
    sql = "CREATE VIEW IF NOT EXISTS spatial_ref_sys_all AS\n"
	"SELECT a.srid AS srid, a.auth_name AS auth_name, "
	"a.auth_srid AS auth_srid, a.ref_sys_name AS ref_sys_name,\n"
	"b.is_geographic AS is_geographic, "
	"b.has_flipped_axes AS has_flipped_axes, "
	"b.spheroid AS spheroid, b.prime_meridian AS prime_meridian, "
................................................................................
	"b.axis_1_name AS axis_1_name, "
	"b.axis_1_orientation AS axis_1_orientation,\n"
	"b.axis_2_name AS axis_2_name, "
	"b.axis_2_orientation AS axis_2_orientation,\n"
	"a.proj4text AS proj4text, a.srtext AS srtext\n"
	"FROM spatial_ref_sys AS a\n"
	"LEFT JOIN spatial_ref_sys_aux AS b ON (a.srid = b.srid)";
    ret = sqlite3_exec (handle, sql, NULL, NULL, NULL);
	if (ret != SQLITE_OK)
	  return 0;
    return 1;
}

static int
populate_spatial_ref_sys (sqlite3 * handle, int mode, int metadata)
{
/* populating the EPSG dataset into the SPATIAL_REF_SYS table */
    struct epsg_defs *first = NULL;

	  gaia_sql_proc_set_error (cache, errmsg);
	  sqlite3_free (errmsg);
	  return 0;
      }

/* creating Triggers supporting STORED_PROCEDURES */
    sprintf (sql,
	     "CREATE TRIGGER storproc_ins BEFORE INSERT ON stored_procedures\n"
	     "FOR EACH ROW BEGIN\n"
	     "SELECT RAISE(ROLLBACK, 'Invalid \"sql_proc\": not a BLOB of the SQL Procedure type')\n"
	     "WHERE SqlProc_IsValid(NEW.sql_proc) <> 1;\nEND");
    ret = sqlite3_exec (handle, sql, NULL, NULL, &errMsg);
    if (ret != SQLITE_OK)
      {
	  char *errmsg =
................................................................................
	      sqlite3_mprintf ("gaia_stored_create \"storproc_ins\": %s",
			       sqlite3_errmsg (handle));
	  gaia_sql_proc_set_error (cache, errmsg);
	  sqlite3_free (errmsg);
	  return 0;
      }
    sprintf (sql,
	     "CREATE TRIGGER storproc_upd BEFORE UPDATE OF sql_proc ON stored_procedures\n"
	     "FOR EACH ROW BEGIN\n"
	     "SELECT RAISE(ROLLBACK, 'Invalid \"sql_proc\": not a BLOB of the SQL Procedure type')\n"
	     "WHERE SqlProc_IsValid(NEW.sql_proc) <> 1;\nEND");
    ret = sqlite3_exec (handle, sql, NULL, NULL, &errMsg);
    if (ret != SQLITE_OK)
      {
	  char *errmsg =

	  gaia_sql_proc_set_error (cache, errmsg);
	  sqlite3_free (errmsg);
	  return 0;
      }

/* creating Triggers supporting STORED_PROCEDURES */
    sprintf (sql,
	     "CREATE TRIGGER IF NOT EXISTS storproc_ins BEFORE INSERT ON stored_procedures\n"
	     "FOR EACH ROW BEGIN\n"
	     "SELECT RAISE(ROLLBACK, 'Invalid \"sql_proc\": not a BLOB of the SQL Procedure type')\n"
	     "WHERE SqlProc_IsValid(NEW.sql_proc) <> 1;\nEND");
    ret = sqlite3_exec (handle, sql, NULL, NULL, &errMsg);
    if (ret != SQLITE_OK)
      {
	  char *errmsg =
................................................................................
	      sqlite3_mprintf ("gaia_stored_create \"storproc_ins\": %s",
			       sqlite3_errmsg (handle));
	  gaia_sql_proc_set_error (cache, errmsg);
	  sqlite3_free (errmsg);
	  return 0;
      }
    sprintf (sql,
	     "CREATE TRIGGER IF NOT EXISTS storproc_upd BEFORE UPDATE OF sql_proc ON stored_procedures\n"
	     "FOR EACH ROW BEGIN\n"
	     "SELECT RAISE(ROLLBACK, 'Invalid \"sql_proc\": not a BLOB of the SQL Procedure type')\n"
	     "WHERE SqlProc_IsValid(NEW.sql_proc) <> 1;\nEND");
    ret = sqlite3_exec (handle, sql, NULL, NULL, &errMsg);
    if (ret != SQLITE_OK)
      {
	  char *errmsg =

	addparentid7.testcase \
	createisometa1.testcase \
	createisometa2.testcase \
	createisometa3.testcase \
	createisometa4.testcase \
	createisometa5.testcase \
	createisometa6.testcase \










	createstyling1.testcase \
	createstyling2.testcase \
	createstyling3.testcase \
	createstyling4.testcase \
	createstyling5.testcase \
	createstyling6.testcase \
	createstyling7.testcase \

	addparentid7.testcase \
	createisometa1.testcase \
	createisometa2.testcase \
	createisometa3.testcase \
	createisometa4.testcase \
	createisometa5.testcase \
	createisometa6.testcase \
	createmissingtables1.testcase \
	createmissingtables2.testcase \
	createmissingtables3.testcase \
	createmissingtables4.testcase \
	createmissingtables5.testcase \
	createmissingtables6.testcase \
	createmissingtables7.testcase \
	createmissingtables8.testcase \
	createmissingtables9.testcase \
	createmissingtables10.testcase \
	createstyling1.testcase \
	createstyling2.testcase \
	createstyling3.testcase \
	createstyling4.testcase \
	createstyling5.testcase \
	createstyling6.testcase \
	createstyling7.testcase \

	addparentid7.testcase \
	createisometa1.testcase \
	createisometa2.testcase \
	createisometa3.testcase \
	createisometa4.testcase \
	createisometa5.testcase \
	createisometa6.testcase \










	createstyling1.testcase \
	createstyling2.testcase \
	createstyling3.testcase \
	createstyling4.testcase \
	createstyling5.testcase \
	createstyling6.testcase \
	createstyling7.testcase \

	addparentid7.testcase \
	createisometa1.testcase \
	createisometa2.testcase \
	createisometa3.testcase \
	createisometa4.testcase \
	createisometa5.testcase \
	createisometa6.testcase \
	createmissingtables1.testcase \
	createmissingtables2.testcase \
	createmissingtables3.testcase \
	createmissingtables4.testcase \
	createmissingtables5.testcase \
	createmissingtables6.testcase \
	createmissingtables7.testcase \
	createmissingtables8.testcase \
	createmissingtables9.testcase \
	createmissingtables10.testcase \
	createstyling1.testcase \
	createstyling2.testcase \
	createstyling3.testcase \
	createstyling4.testcase \
	createstyling5.testcase \
	createstyling6.testcase \
	createstyling7.testcase \

CreateMissingSystemTables - NULL relaxed
:memory: #use in-memory database
SELECT CreateMissingSystemTables(NULL);
1 # rows (not including the header row)
1 # columns
CreateMissingSystemTables(NULL)
CreateMissingSystemTables exception - first argument (relaxed) expected to be an INTEGER.

CreateMissingSystemTables - INTEGER relaxed, INTEGER transaction
:memory: #use in-memory database
SELECT CreateMissingSystemTables(0, 1);
1 # rows (not including the header row)
1 # columns
CreateMissingSystemTables(0, 1)
1

CreateMissingSystemTables - TEXT relaxed
:memory: #use in-memory database
SELECT CreateMissingSystemTables('no');
1 # rows (not including the header row)
1 # columns
CreateMissingSystemTables('no')
CreateMissingSystemTables exception - first argument (relaxed) expected to be an INTEGER.

CreateMissingSystemTables - BLOB relaxed
:memory: #use in-memory database
SELECT CreateMissingSystemTables(zeroblob(4));
1 # rows (not including the header row)
1 # columns
CreateMissingSystemTables(zeroblob(4))
CreateMissingSystemTables exception - first argument (relaxed) expected to be an INTEGER.

CreateMissingSystemTables - DOUBLE relaxed
:memory: #use in-memory database
SELECT CreateMissingSystemTables(1.5);
1 # rows (not including the header row)
1 # columns
CreateMissingSystemTables(1.5)
CreateMissingSystemTables exception - first argument (relaxed) expected to be an INTEGER.

CreateMissingSystemTables - INTEGER relaxed
:memory: #use in-memory database
SELECT CreateMissingSystemTables(1);
1 # rows (not including the header row)
1 # columns
CreateMissingSystemTables(1)
1

CreateMissingSystemTables - INTEGER relaxed, NULL transaction
:memory: #use in-memory database
SELECT CreateMissingSystemTables(1, NULL);
1 # rows (not including the header row)
1 # columns
CreateMissingSystemTables(1, NULL)
CreateMissingSystemTables exception - second argument (transaction) expected to be an INTEGER.

CreateMissingSystemTables - INTEGER relaxed, TEXT transaction
:memory: #use in-memory database
SELECT CreateMissingSystemTables(0, 'no');
1 # rows (not including the header row)
1 # columns
CreateMissingSystemTables(0, 'no')
CreateMissingSystemTables exception - second argument (transaction) expected to be an INTEGER.

CreateMissingSystemTables - INTEGER relaxed, BLOB transaction
:memory: #use in-memory database
SELECT CreateMissingSystemTables(1, zeroblob(4));
1 # rows (not including the header row)
1 # columns
CreateMissingSystemTables(1, zeroblob(4))
CreateMissingSystemTables exception - second argument (transaction) expected to be an INTEGER.

CreateMissingSystemTables - INTEGER relaxed, DOUBLE transaction
:memory: #use in-memory database
SELECT CreateMissingSystemTables(0, 1.5);
1 # rows (not including the header row)
1 # columns
CreateMissingSystemTables(0, 1.5)
CreateMissingSystemTables exception - second argument (transaction) expected to be an INTEGER.

AS = as
AUTOCONF = autoconf
AUTOHEADER = autoheader
AUTOMAKE = automake-1.16
AWK = gawk
CC = gcc
CCDEPMODE = depmode=gcc3
CFLAGS = -Wall -Wextra -Wunused -pedantic -g -O0 -I/home/sandro/Scaricati/gdal/include -fprofile-arcs -ftest-coverage -g
CPP = gcc -E
CPPFLAGS = 
CXX = g++
CXXCPP = g++ -E
CXXDEPMODE = depmode=gcc3
CXXFLAGS = -g -O2
CYGPATH_W = echo
................................................................................
GREP = /usr/bin/grep
INSTALL = /usr/bin/install -c
INSTALL_DATA = ${INSTALL} -m 644
INSTALL_PROGRAM = ${INSTALL}
INSTALL_SCRIPT = ${INSTALL}
INSTALL_STRIP_PROGRAM = $(install_sh) -c -s
LD = /usr/bin/ld -m elf_x86_64
LDFLAGS = -L/home/sandro/Scaricati/gdal/lib
LIBOBJS = 
LIBS = -lminizip -lrttopo -lfreexl -lproj -lsqlite3 -lz -lsqlite3  -L/usr/lib64 -lgeos_c
LIBTOOL = $(SHELL) $(top_builddir)/libtool
LIBXML2_CFLAGS = -I/usr/include/libxml2 
LIBXML2_LIBS = -lxml2 
LIPO = 
LN_S = ln -s

AS = as
AUTOCONF = autoconf
AUTOHEADER = autoheader
AUTOMAKE = automake-1.16
AWK = gawk
CC = gcc
CCDEPMODE = depmode=gcc3
CFLAGS = -Wall -Wextra -Wunused -pedantic -g -O0 -fprofile-arcs -ftest-coverage -g
CPP = gcc -E
CPPFLAGS = 
CXX = g++
CXXCPP = g++ -E
CXXDEPMODE = depmode=gcc3
CXXFLAGS = -g -O2
CYGPATH_W = echo
................................................................................
GREP = /usr/bin/grep
INSTALL = /usr/bin/install -c
INSTALL_DATA = ${INSTALL} -m 644
INSTALL_PROGRAM = ${INSTALL}
INSTALL_SCRIPT = ${INSTALL}
INSTALL_STRIP_PROGRAM = $(install_sh) -c -s
LD = /usr/bin/ld -m elf_x86_64
LDFLAGS = 
LIBOBJS = 
LIBS = -lminizip -lrttopo -lfreexl -lproj -lsqlite3 -lz -lsqlite3  -L/usr/lib64 -lgeos_c
LIBTOOL = $(SHELL) $(top_builddir)/libtool
LIBXML2_CFLAGS = -I/usr/include/libxml2 
LIBXML2_LIBS = -lxml2 
LIPO = 
LN_S = ln -s