Feat(demo): Add CREATE TABLE

[sqlconvert.git] / demo / demo.sql

diff --git a/demo/demo.sql b/demo/demo.sql
index a3155d591620b1632db33e93c1c669cc509fb374..71535389cd9f9ecb87147c6a9e02792428439884 100644 (file)
--- a/demo/demo.sql
+++ b/demo/demo.sql
@@ -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"
+
 /*! directive*/;
 
 INSERT INTO `MyTable` (`Id`, `Name`)