stackrender
diff --git a/‎src/column.js‎
Lines changed: 2 additions & 2 deletions b/‎src/column.js‎
Lines changed: 2 additions & 2 deletions
diff --git a/‎src/util.js‎
Lines changed: 13 additions & 4 deletions b/‎src/util.js‎
Lines changed: 13 additions & 4 deletions
diff --git a/‎test/sqlite.spec.js‎
Lines changed: 8 additions & 1 deletion b/‎test/sqlite.spec.js‎
Lines changed: 8 additions & 1 deletion
@@ -3,7 +3,7 @@ import { exprToSQL } from './expr'
 import { castToSQL } from './func'
 import { tablesToSQL } from './tables'
 import {
-  autoIncreatementToSQL,
+  autoIncrementToSQL,
   columnIdentifierToSql,
   commonOptionConnector,
   commonTypeValue,
@@ -88,7 +88,7 @@ function columnOption(definition) {
     columnOpt.push(type.toUpperCase(), exprToSQL(value))
   }
   columnOpt.push(constraintDefinitionToSQL(check))
-  columnOpt.push(autoIncreatementToSQL(autoIncrement), toUpper(uniquePrimary), commentToSQL(comment))
+  columnOpt.push(autoIncrementToSQL(autoIncrement), toUpper(uniquePrimary), commentToSQL(comment))
   columnOpt.push(...commonTypeValue(characterSet))
   columnOpt.push(...commonTypeValue(collate))
   columnOpt.push(...commonTypeValue(columnFormat))
 
@@ -328,9 +328,18 @@ function commonKeywordArgsToSQL(kwArgs) {
   return [toUpper(kwArgs.keyword), toUpper(kwArgs.args)]
 }
 
-function autoIncreatementToSQL(autoIncreatement) {
-  if (!autoIncreatement || typeof autoIncreatement === 'string') return toUpper(autoIncreatement)
-  const { keyword, seed, increment, parentheses } = autoIncreatement
+function autoIncrementToSQL(autoIncrement) {
+  if (!autoIncrement) return
+  if (typeof autoIncrement === 'string') {
+    const { database } = getParserOpt()
+    switch (database && database.toLowerCase()) {
+      case 'sqlite':
+        return 'AUTOINCREMENT'
+      default:
+        return 'AUTO_INCREMENT'
+    }
+  }
+  const { keyword, seed, increment, parentheses } = autoIncrement
   let result = toUpper(keyword)
   if (parentheses) result += `(${literalToSQL(seed)}, ${literalToSQL(increment)})`
   return result
@@ -342,7 +351,7 @@ function columnOrderListToSQL(columnOrderList) {
 }
 
 export {
-  arrayStructTypeToSQL, autoIncreatementToSQL,
+  arrayStructTypeToSQL, autoIncrementToSQL,
   columnOrderListToSQL, commonKeywordArgsToSQL, commonOptionConnector,
   connector, commonTypeValue,commentToSQL, createBinaryExpr,
   createValueExpr, dataTypeToSQL, DEFAULT_OPT, escape, literalToSQL, columnIdentifierToSql,
 
@@ -3,8 +3,9 @@ const Parser = require('../src/parser').default
 
 describe('sqlite', () => {
   const parser = new Parser();
+  const DEFAULT_OPT =  { database: 'sqlite' }
 
-  function getParsedSql(sql, opt = { database: 'sqlite' }) {
+  function getParsedSql(sql, opt = DEFAULT_OPT) {
     const ast = parser.astify(sql, opt);
     return parser.sqlify(ast, opt);
   }
@@ -144,4 +145,10 @@ describe('sqlite', () => {
     const sql = 'CREATE TABLE IF NOT EXISTS "Test" (Id INTEGER NOT NULL UNIQUE, like TEXT NOT NULL, Difficulty TEXT, PRIMARY KEY(Id));'
     expect(getParsedSql(sql)).to.be.equal('CREATE TABLE IF NOT EXISTS `Test` (`Id` INTEGER NOT NULL UNIQUE, `like` TEXT NOT NULL, `Difficulty` TEXT, PRIMARY KEY (`Id`))')
   })
+
+  it('should support sqlify autoincrement to other db', () => {
+    const sql = 'CREATE TABLE IF NOT EXISTS "SampleTable" ( "ID" INTEGER NOT NULL AUTOINCREMENT UNIQUE, "Name" TEXT NOT NULL);'
+    const ast = parser.astify(sql, DEFAULT_OPT)
+    expect(parser.sqlify(ast, { database: 'mariadb'})).to.be.equal('CREATE TABLE IF NOT EXISTS `SampleTable` (`ID` INTEGER NOT NULL AUTO_INCREMENT UNIQUE, `Name` TEXT NOT NULL)')
+  })
 })