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 --- install.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'install.sql') diff --git a/install.sql b/install.sql index 00c67162..1d032114 100644 --- a/install.sql +++ b/install.sql @@ -182,9 +182,9 @@ CREATE TABLE IF NOT EXISTS `pms` ( CREATE TABLE IF NOT EXISTS `posts_b` ( `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