Re: MySQL Script

2012-07-07 Thread Tomasz Sterna
Dnia 2012-07-07, sob o godzinie 10:30 +0200,
magic-jabbe...@damage.devloop.de pisze:
> I noticed alle the TEXT and TINYTEXT 
> fields in it. Also there are no table references set (which is not
> possible because of the TEXT fields). Is there a reason for that? Can
> I just change the field types? 

DB is just used as a storage backend. We do not enforce much consistency
there, as it's not that needed.
Afterall it's not a banking system or something. ;-)

Besides, jabberd2 storage backend interface is designed to work with
backends that do not support any consistency checks - like pure
filesystem, thus it is simple. It's designed to just get the job of
having some persistency done.


-- 
Tomasz Sterna
Instant Messaging Consultant : Open Source Developer
http://tomasz.sterna.tv/  http://www.xiaoka.com/portfolio





MySQL Script

2012-07-07 Thread magic-jabberd2
Hi,
I decided to switch to jabberd2. Erlang and lua are not my favorite languages 
;) I think C is the best on Linux machines.

However, I have seen the MySQL script provided by jabberd2 which you can use 
to create the database used by jabberd2. I noticed alle the TEXT and TINYTEXT 
fields in it. Also there are no table references set (which is not possible 
because of the TEXT fields). Is there a reason for that? Can I just change the 
field types?

regards
Daniel