X-Git-Url: https://git.phdru.name/?a=blobdiff_plain;ds=sidebyside;f=tests%2Fmysql2sql%2Ftest.out;h=1bd6b8f2497bfb2da3384e6078dea9f7a6625f81;hb=9bfd0fb291e1ca197ece43bb728f65830289d826;hp=60d32711b11fda8e1037dcb8cedeb4edea95a3bf;hpb=d2badb1547aaf53057acbd9b02b81e1dc385f8ec;p=sqlconvert.git

diff --git a/tests/mysql2sql/test.out b/tests/mysql2sql/test.out
index 60d3271..1bd6b8f 100644
--- a/tests/mysql2sql/test.out
+++ b/tests/mysql2sql/test.out
@@ -1,15 +1,23 @@
-SELECT * FROM mytable; -- line-comment"
+CREATE TABLE mytable (
+  id int(10) unsigned NOT NULL AUTO_INCREMENT,
+  date datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+  flag tinyint(4) NOT NULL DEFAULT '0',
+  PRIMARY KEY (id),
+  UNIQUE KEY date (date)
+) ENGINE="InnoDB" DEFAULT CHARSET=utf8;
 
 INSERT INTO /* inline comment */ mytable VALUES (1, 'тест');
 
+SELECT * FROM mytable; -- line-comment"
+
 
 INSERT INTO "MyTable" ("Id", "Name")
 VALUES (1, 'one');
 
-INSERT INTO mytable VALUES  (1, 'one');
-INSERT INTO mytable VALUES  (2, 'two');
+INSERT INTO mytable VALUES (1, 'one');
+INSERT INTO mytable VALUES (2, 'two');
 
-INSERT INTO mytable (id, name) VALUES  (1, 'one');
-INSERT INTO mytable (id, name) VALUES  (2, 'two');
+INSERT INTO mytable (id, name) VALUES (1, 'one');
+INSERT INTO mytable (id, name) VALUES (2, 'two');
 
 -- The end