[jadmin] JUD/Users-Agent and creating DB

[Eddie_Dandrades at waters.com]

Alessandro,

Thanks for your reply. It appears that worked. I'm most certainly not an 
SQL expert so I appreciate your help.



Eddie Dandrades
IT Technician - Beverly
Office: 508-482-4604
Cell:    508-400-0762
eddie_dandrades at waters.com



"Alessandro Martins" <alessandro.martins at gmail.com> 
Sent by: jadmin-bounces at jabber.org
06/28/2006 08:30 AM
Please respond to
"Jabber server administration list" <jadmin at jabber.org>


To
"Jabber server administration list" <jadmin at jabber.org>
cc

Subject
Re: [jadmin] JUD/Users-Agent and creating DB






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
_______________________________________________
jadmin mailing list
jadmin at jabber.org
http://mail.jabber.org/mailman/listinfo/jadmin
FAQ: http://www.jabber.org/about/jadminfaq.shtml
_______________________________________________



===========================================================

The information in this email is confidential, and is intended solely for the addressee(s). Access to this email by anyone else is unauthorized and therefore prohibited.  If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful.

===========================================================
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.jabber.org/pipermail/jadmin/attachments/20060628/483058aa/attachment-0004.htm