X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F08postgres-to-mysql.t;h=8146c24e54aa16c92edd12e4d35770f4f624d5c6;hb=56b9e6a566b09e57d63d8b854f80f84002ae0f14;hp=fc4a4980b60f30245e77638243ed8c80741a0042;hpb=e4a9818dd51f752673818986e0419f25ad9f9357;p=dbsrgits%2FSQL-Translator.git

diff --git a/t/08postgres-to-mysql.t b/t/08postgres-to-mysql.t
index fc4a498..8146c24 100644
--- a/t/08postgres-to-mysql.t
+++ b/t/08postgres-to-mysql.t
@@ -59,7 +59,7 @@ COMMENT ON COLUMN cvterm.cv_id IS
  'The cv/ontology/namespace to which this cvterm belongs';
 COMMENT ON COLUMN cvterm.name IS
  'A concise human-readable name describing the meaning of the cvterm';
-COMMENT ON COLUMN cvterm.definition IS
+COMMENT ON COLUMN cvterm.termdefinition IS
  'A human-readable text definition';
 COMMENT ON COLUMN cvterm.dbxref_id IS
  'A human-readable text definition';
@@ -146,6 +146,23 @@ create table cvterm_dbxref (
 create index cvterm_dbxref_idx1 on cvterm_dbxref (cvterm_id);
 create index cvterm_dbxref_idx2 on cvterm_dbxref (dbxref_id);
 
+-- ================================================
+-- TABLE: cvterm_geom
+-- ================================================
+
+create table cvterm_geom (
+       cvterm_geom_id serial not null,
+       primary key (cvterm_geom_id),
+       cvterm_id int not null,
+       foreign key (cvterm_id) references cvterm (cvterm_id),
+       cvterm_geom geometry,
+	   constraint "enforce_dims_cvterm_geom" CHECK ((st_ndims(cvterm_geom) = 2)),
+	   constraint "enforce_srid_cvterm_geom" CHECK ((st_srid(cvterm_geom) = -1)),
+	   constraint "enforce_geotype_cvterm_geom" CHECK ((geometrytype(cvterm_geom) = 'POINT'::text OR cvterm_geom IS NULL)),
+       unique(cvterm_id)
+);
+
+
 |;
 
 my $tr = SQL::Translator->new(
@@ -153,4 +170,4 @@ my $tr = SQL::Translator->new(
     producer => "MySQL"
 );
 
-ok( $tr->translate(\$create), 'Translate PG2My' );
+ok( $tr->translate(\$create), 'Translate PG2My' ) or diag($tr->error);