Author: desruisseaux Date: Thu Oct 16 12:25:05 2025 New Revision: 1929172 Log: Use database collation in columns of object names.
Modified: sis/data/non-free/EPSG/Tables.sql Modified: sis/data/non-free/EPSG/Tables.sql ============================================================================== --- sis/data/non-free/EPSG/Tables.sql Thu Oct 16 12:10:03 2025 (r1929171) +++ sis/data/non-free/EPSG/Tables.sql Thu Oct 16 12:25:05 2025 (r1929172) @@ -17,13 +17,13 @@ alias_code INTEGER NOT NULL object_table_name "Table Name" NOT NULL, object_code INTEGER NOT NULL, naming_system_code INTEGER NOT NULL, -alias VARCHAR(78) NOT NULL, +alias VARCHAR(78) NOT NULL COLLATE "Ignore Accent and Case", remarks VARCHAR(253), CONSTRAINT pk_alias PRIMARY KEY (alias_code)); CREATE TABLE "Conventional RS" ( conventional_rs_code INTEGER NOT NULL, -conventional_rs_name VARCHAR(42) NOT NULL, +conventional_rs_name VARCHAR(42) NOT NULL COLLATE "Ignore Accent and Case", remarks VARCHAR(75), deprecated BOOLEAN NOT NULL, CONSTRAINT pk_conventional_rs PRIMARY KEY (conventional_rs_code)); @@ -40,7 +40,7 @@ CONSTRAINT pk_coordinateaxis PRIMARY KEY CREATE TABLE "Coordinate Axis Name" ( coord_axis_name_code INTEGER NOT NULL, -coord_axis_name VARCHAR(22) NOT NULL, +coord_axis_name VARCHAR(22) NOT NULL COLLATE "Ignore Accent and Case", description VARCHAR(217), remarks VARCHAR(254), deprecated BOOLEAN NOT NULL, @@ -48,7 +48,7 @@ CONSTRAINT pk_coordinateaxisname PRIMARY CREATE TABLE "Coordinate Reference System" ( coord_ref_sys_code INTEGER NOT NULL, -coord_ref_sys_name VARCHAR(73) NOT NULL, +coord_ref_sys_name VARCHAR(73) NOT NULL COLLATE "Ignore Accent and Case", coord_ref_sys_kind "CRS Kind" NOT NULL, coord_sys_code INTEGER, datum_code INTEGER, @@ -63,7 +63,7 @@ CONSTRAINT pk_coordinatereferencesystem CREATE TABLE "Coordinate System" ( coord_sys_code INTEGER NOT NULL, -coord_sys_name VARCHAR(254) NOT NULL, +coord_sys_name VARCHAR(254) NOT NULL COLLATE "Ignore Accent and Case", coord_sys_type "CS Kind" NOT NULL, dimension SMALLINT NOT NULL, remarks VARCHAR(254), @@ -72,7 +72,7 @@ CONSTRAINT pk_coordinatesystem PRIMARY K CREATE TABLE "Coordinate_Operation" ( coord_op_code INTEGER NOT NULL, -coord_op_name VARCHAR(80) NOT NULL, +coord_op_name VARCHAR(80) NOT NULL COLLATE "Ignore Accent and Case", coord_op_type VARCHAR(22) NOT NULL, source_crs_code INTEGER, target_crs_code INTEGER, @@ -89,7 +89,7 @@ CONSTRAINT pk_coordinate_operation PRIMA CREATE TABLE "Coordinate_Operation Method" ( coord_op_method_code INTEGER NOT NULL, -coord_op_method_name VARCHAR(76) NOT NULL, +coord_op_method_name VARCHAR(76) NOT NULL COLLATE "Ignore Accent and Case", reverse_op BOOLEAN NOT NULL, formula VARCHAR(3967), remarks VARCHAR(339), @@ -98,7 +98,7 @@ CONSTRAINT pk_coordinate_operationmethod CREATE TABLE "Coordinate_Operation Parameter" ( parameter_code INTEGER NOT NULL, -parameter_name VARCHAR(68) NOT NULL, +parameter_name VARCHAR(68) NOT NULL COLLATE "Ignore Accent and Case", description VARCHAR(682), deprecated BOOLEAN NOT NULL, CONSTRAINT pk_coordinate_operationparamet PRIMARY KEY (parameter_code)); @@ -107,7 +107,7 @@ CREATE TABLE "Coordinate_Operation Param coord_op_method_code INTEGER NOT NULL, parameter_code INTEGER NOT NULL, sort_order SMALLINT NOT NULL, -param_sign_reversal BOOLEAN , +param_sign_reversal BOOLEAN, CONSTRAINT pk_coordinate_operationparame2 PRIMARY KEY (parameter_code, coord_op_method_code)); CREATE TABLE "Coordinate_Operation Parameter Value" ( @@ -127,7 +127,7 @@ CONSTRAINT pk_coordinate_operationpath P CREATE TABLE "Datum" ( datum_code INTEGER NOT NULL, -datum_name VARCHAR(76) NOT NULL, +datum_name VARCHAR(76) NOT NULL, -- Collation with LIKE requires PostgreSQL 18. datum_type "Datum Kind" NOT NULL, origin_description VARCHAR(254), anchor_epoch DOUBLE PRECISION, @@ -154,7 +154,7 @@ CONSTRAINT pk_datumensemble_members PRIM CREATE TABLE "Datum Realization Method" ( realization_method_code INTEGER NOT NULL, -realization_method_name VARCHAR(15) NOT NULL, +realization_method_name VARCHAR(15) NOT NULL COLLATE "Ignore Accent and Case", remarks VARCHAR(151), deprecated BOOLEAN NOT NULL, CONSTRAINT pk_datumrealizationmethod PRIMARY KEY (realization_method_code)); @@ -175,7 +175,7 @@ CONSTRAINT pk_deprecation PRIMARY KEY (d CREATE TABLE "Ellipsoid" ( ellipsoid_code INTEGER NOT NULL, -ellipsoid_name VARCHAR(34) NOT NULL, +ellipsoid_name VARCHAR(34) NOT NULL COLLATE "Ignore Accent and Case", semi_major_axis DOUBLE PRECISION NOT NULL, uom_code INTEGER NOT NULL, inv_flattening DOUBLE PRECISION, @@ -187,7 +187,7 @@ CONSTRAINT pk_ellipsoid PRIMARY KEY (ell CREATE TABLE "Extent" ( extent_code INTEGER NOT NULL, -extent_name VARCHAR(79) NOT NULL, +extent_name VARCHAR(79) NOT NULL COLLATE "Ignore Accent and Case", extent_description VARCHAR(3035) NOT NULL, bbox_south_bound_lat DOUBLE PRECISION, bbox_west_bound_lon DOUBLE PRECISION, @@ -214,7 +214,7 @@ CONSTRAINT pk_namingsystem PRIMARY KEY ( CREATE TABLE "Prime Meridian" ( prime_meridian_code INTEGER NOT NULL, -prime_meridian_name VARCHAR(10) NOT NULL, +prime_meridian_name VARCHAR(10) NOT NULL COLLATE "Ignore Accent and Case", greenwich_longitude DOUBLE PRECISION NOT NULL, uom_code INTEGER NOT NULL, remarks VARCHAR(232),
