X-Git-Url: https://git.phdru.name/?p=sqlconvert.git;a=blobdiff_plain;f=tests%2Fmysql2sql%2Ftest.out;h=0026e62c383433df8c6f1f6b139a2782ee43a940;hp=60d32711b11fda8e1037dcb8cedeb4edea95a3bf;hb=93c260c6aa3ef8211663e8f98a2adcdb2107c7a2;hpb=b72239847f13152061182973ea573dd2e835a89e diff --git a/tests/mysql2sql/test.out b/tests/mysql2sql/test.out index 60d3271..0026e62 100644 --- a/tests/mysql2sql/test.out +++ b/tests/mysql2sql/test.out @@ -1,7 +1,15 @@ -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');