From 7e78b2ec373f4596f986bb75a0e6c33bd67a82b4 Mon Sep 17 00:00:00 2001 From: alecpl <alec@alec.pl> Date: Sat, 07 Jun 2008 15:33:07 -0400 Subject: [PATCH] -segfault (#1485109) --- SQL/mysql.initial.sql | 10 ++++++---- 1 files changed, 6 insertions(+), 4 deletions(-) diff --git a/SQL/mysql.initial.sql b/SQL/mysql.initial.sql index ae195e4..fadc072 100644 --- a/SQL/mysql.initial.sql +++ b/SQL/mysql.initial.sql @@ -50,12 +50,12 @@ `user_id` int(10) unsigned NOT NULL default '0', `del` tinyint(1) NOT NULL default '0', `standard` tinyint(1) NOT NULL default '0', - `name` varchar(128) NOT NULL default '', + `name` varchar(128) NOT NULL, `organization` varchar(128) NOT NULL default '', - `email` varchar(128) NOT NULL default '', + `email` varchar(128) NOT NULL, `reply-to` varchar(128) NOT NULL default '', `bcc` varchar(128) NOT NULL default '', - `signature` text NOT NULL, + `signature` text NOT NULL default '', `html_signature` tinyint(1) NOT NULL default '0', PRIMARY KEY (`identity_id`), KEY `user_id` (`user_id`) @@ -91,7 +91,9 @@ `last_login` datetime NOT NULL default '0000-00-00 00:00:00', `language` varchar(5) NOT NULL default 'en', `preferences` text, - PRIMARY KEY (`user_id`) + PRIMARY KEY (`user_id`), + INDEX `username_index` (`username`), + INDEX `alias_index` (`alias`) ); -- -------------------------------------------------------- -- Gitblit v1.9.1