From 22be28318711e0846c9a00ef3a308119f1f3f1b1 Mon Sep 17 00:00:00 2001
From: Kim Alvefur <zash@zash.se>
Date: Mon, 28 Oct 2013 23:20:25 +0100
Subject: util.sql: Support incrementing columns

---
 util/sql.lua | 9 +++++++++
 1 file changed, 9 insertions(+)

(limited to 'util')

diff --git a/util/sql.lua b/util/sql.lua
index 7c9743e1..cab1bcec 100644
--- a/util/sql.lua
+++ b/util/sql.lua
@@ -263,6 +263,15 @@ function engine:_create_table(table)
 		sql = sql.."`"..col.name.."` "..col.type;
 		if col.nullable == false then sql = sql.." NOT NULL"; end
 		if col.primary_key == true then sql = sql.." PRIMARY KEY"; end
+		if col.auto_increment == true then
+			if self.params.driver == "PostgreSQL" then
+				sql = sql.." SERIAL";
+			elseif self.params.driver == "MySQL" then
+				sql = sql.." AUTO_INCREMENT";
+			elseif self.params.driver == "SQLite3" then
+				sql = sql.." AUTOINCREMENT";
+			end
+		end
 		if i ~= #table.c then sql = sql..", "; end
 	end
 	sql = sql.. ");"
-- 
cgit v1.2.3