From c96b27eb5ba544b0be4aec59af0b2b587cfaf06e Mon Sep 17 00:00:00 2001
From: Michael Save <savetheinternet@tinyboard.org>
Date: Mon, 27 Aug 2012 02:52:31 +1000
Subject: use UNSIGNED for `id` columns

---
 templates/posts.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'templates/posts.sql')

diff --git a/templates/posts.sql b/templates/posts.sql
index ef8d403e..d10749f8 100644
--- a/templates/posts.sql
+++ b/templates/posts.sql
@@ -1,5 +1,5 @@
 CREATE TABLE IF NOT EXISTS `posts_{{ board }}` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
   `thread` int(11) DEFAULT NULL,
   `subject` varchar(100) DEFAULT NULL,
   `email` varchar(30) DEFAULT NULL,
-- 
cgit v1.3