X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F48xml-to-sqlite.t;h=53f37dbab6b6b2a918877f220c4e96a7ddd290ee;hb=b08b5416f45bfbe381637ee3091202524c78ecab;hp=6ed2a22c17fedde68e1e09ac1f555da9438e14bb;hpb=ef8261d008851ec597bdd3f8d49669cf03239f6a;p=dbsrgits%2FSQL-Translator.git diff --git a/t/48xml-to-sqlite.t b/t/48xml-to-sqlite.t index 6ed2a22..53f37db 100644 --- a/t/48xml-to-sqlite.t +++ b/t/48xml-to-sqlite.t @@ -48,11 +48,18 @@ CREATE TABLE Basic ( explicitemptystring varchar DEFAULT '', -- Hello emptytagdef emptytagdef varchar DEFAULT '', + another_id int(10) DEFAULT '2', timest timestamp ); CREATE INDEX titleindex_Basic on Basic (title); CREATE UNIQUE INDEX emailuniqueindex_Basic on Basic (email); +DROP TABLE Another; +CREATE TABLE Another ( + id INTEGER PRIMARY KEY NOT NULL +); + + COMMIT; SQL