[jadmin] JUD/Users-Agent and creating DB

[Alessandro Martins]

On 6/27/06, Eddie_Dandrades at waters.com <Eddie_Dandrades at waters.com> wrote:

>
> Can someone give me a hand with this. I'm trying to execute ./createdb so I
> can install and configure Users-Agent but I get this:

[cutted]

> my $sth = $DBHandle->prepare("CREATE TABLE jud (jid VARCHAR(100), name
> VARCHAR(100) INDEX, first VARCHAR(50) INDEX, last VARC
> HAR(50) INDEX, nick VARCHAR(50) INDEX, email VARCHAR(50) INDEX);");

Hi,

I'm not a DB expert, but you can use this SQL statement , see below:

CREATE TABLE `jud` (  `jid` varchar(100) default NULL,  `name`
varchar(100) default NULL,  `first` varchar(50) default NULL,  `last`
varchar(50) default NULL,  `nick` varchar(50) default NULL,  `email`
varchar(50) default NULL) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Regards,

-- 
Alessandro Martins