From fc417bc44625a509fdcc5b1320f5d5511223823c Mon Sep 17 00:00:00 2001 From: Savetheinternet Date: Mon, 5 Dec 2011 10:47:30 +1100 Subject: use NULL in database where possible --- templates/posts.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'templates/posts.sql') diff --git a/templates/posts.sql b/templates/posts.sql index e3a81ee1..59df4705 100644 --- a/templates/posts.sql +++ b/templates/posts.sql @@ -1,9 +1,9 @@ CREATE TABLE IF NOT EXISTS `posts_{{ board }}` ( `id` int(11) NOT NULL AUTO_INCREMENT, `thread` int(11) DEFAULT NULL, - `subject` varchar(100) NOT NULL, - `email` varchar(30) NOT NULL, - `name` varchar(35) NOT NULL, + `subject` varchar(100) DEFAULT NULL, + `email` varchar(30) DEFAULT NULL, + `name` varchar(35) DEFAULT NULL, `trip` varchar(15) DEFAULT NULL, `capcode` varchar(50) DEFAULT NULL, `body` text NOT NULL, -- cgit v1.3