#!/usr/bin/perl
+# vim: set ft=perl:
use strict;
-use Test::More tests => 76;
+use Test::More;
use SQL::Translator;
use SQL::Translator::Schema::Constants;
-use SQL::Translator::Parser::Oracle qw(parse);
+use Test::SQL::Translator qw(maybe_plan);
+
+maybe_plan(76, 'SQL::Translator::Parser::Oracle');
+SQL::Translator::Parser::Oracle->import('parse');
my $t = SQL::Translator->new( trace => 0 );
my $sql = q[
start_position NUMBER(11,2) NOT NULL,
stop_position NUMBER(11,2) NOT NULL,
comments long,
- UNIQUE ( qtl_accession_id ),
FOREIGN KEY ( qtl_trait_id ) REFERENCES qtl_trait
);
+ CREATE UNIQUE INDEX qtl_accession ON qtl ( qtl_accession_id );
+
CREATE TABLE qtl_trait_synonym
(
qtl_trait_synonym_id NUMBER(11) NOT NULL