X-Git-Url: https://git.phdru.name/?a=blobdiff_plain;f=demo%2Fdemo.sql;h=71535389cd9f9ecb87147c6a9e02792428439884;hb=8bb2789efececb3998654539118f92f4270c4f4f;hp=64818c3818e1208d6ccde243a3aadd1e8e7dfd00;hpb=5a69ae8c9e133b96d9a7c880b57d1cbca952ec54;p=sqlconvert.git

diff --git a/demo/demo.sql b/demo/demo.sql
index 64818c3..7153538 100644
--- a/demo/demo.sql
+++ b/demo/demo.sql
@@ -1,6 +1,22 @@
-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, 'тест');
-/*! directive*/ INSERT INTO `MyTable` (`Id`, `Name`)
+
+SELECT * FROM `mytable`; -- line-comment"
+
+/*! directive*/;
+
+INSERT INTO `MyTable` (`Id`, `Name`)
 VALUES (1, 'one');
 
+insert into mytable values (1, 'one'), (2, 'two');
+
+insert into mytable (id, name) values (1, 'one'), (2, 'two');
+
 -- The end