X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F46xml-to-pg.t;h=04b2f5c54fbd44ffe822e60e9fa37811f6763dbe;hb=3406fd5b1839f1e6d165ae39b86e08effc80ac2c;hp=4747e16ddc4bf44fbca89c7463e27ba800762a2a;hpb=6d80a12008c5cdb4690201259bd4323f55ec6712;p=dbsrgits%2FSQL-Translator.git diff --git a/t/46xml-to-pg.t b/t/46xml-to-pg.t index 4747e16..04b2f5c 100644 --- a/t/46xml-to-pg.t +++ b/t/46xml-to-pg.t @@ -46,19 +46,16 @@ CREATE TABLE "Basic" ( "another_id" integer DEFAULT '2', "timest" timestamp(0), PRIMARY KEY ("id"), - Constraint "emailuniqueindex" UNIQUE ("email") + CONSTRAINT "emailuniqueindex" UNIQUE ("email") ); CREATE INDEX "titleindex" on "Basic" ("title"); - DROP TABLE "Another" CASCADE; CREATE TABLE "Another" ( "id" serial NOT NULL, PRIMARY KEY ("id") ); - - DROP VIEW "email_list"; CREATE VIEW "email_list" ( "email" ) AS ( SELECT email FROM Basic WHERE email IS NOT NULL