how to create my table

[xiaowei chen <ch...@hotmail.co.uk>]

hi,

  I connect james with a mySQL database, and create a db named mail. I con 
work with this database very well. but i think the attribute of the table 
users in the mail database is to simple, there are just 7 collums, so i want 
to create another table name 'userInfo' to store more information about a 
user. I have read lots of article about james, and notic that i must config 
the sqlResources.xml. But all the articles a talked not enough, can you give 
me some help, or refer some good article to me.


thank you very much!

_________________________________________________________________
Upload 500 photos a month & blog with your Messenger buddies on Windows Live 
Spaces. Get yours now, FREE! http://specials.uk.msn.com/spaces/default.aspx


---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org

Re: how to create my table

[Stefano Bagnara <ap...@bago.org>]

Just add the columns you want allowing them to be null or adding a 
default value: James will simply ignore that columns.

If you need instead to change names of already existing columns you can 
change the sqlResources file.

Stefano

xiaowei chen ha scritto:
> hi,
> 
>  I connect james with a mySQL database, and create a db named mail. I 
> con work with this database very well. but i think the attribute of the 
> table users in the mail database is to simple, there are just 7 collums, 
> so i want to create another table name 'userInfo' to store more 
> information about a user. I have read lots of article about james, and 
> notic that i must config the sqlResources.xml. But all the articles a 
> talked not enough, can you give me some help, or refer some good article 
> to me.
> 
> 
> thank you very much!




---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org