summaryrefslogtreecommitdiffstats
path: root/tests/data/parser/parseCreateTable.in
diff options
context:
space:
mode:
Diffstat (limited to 'tests/data/parser/parseCreateTable.in')
-rw-r--r--tests/data/parser/parseCreateTable.in7
1 files changed, 7 insertions, 0 deletions
diff --git a/tests/data/parser/parseCreateTable.in b/tests/data/parser/parseCreateTable.in
new file mode 100644
index 0000000..e9f0911
--- /dev/null
+++ b/tests/data/parser/parseCreateTable.in
@@ -0,0 +1,7 @@
+CREATE TABLE IF NOT EXISTS users (
+ `id` INT NOT NULL AUTO_INCREMENT,
+ username VARCHAR(64) NULL,
+ `password` VARCHAR(256) DEFAULT '123456',
+ CONSTRAINT pk_id PRIMARY KEY (`id`),
+ UNIQUE (username)
+) ENGINE=InnoDB; \ No newline at end of file