search

BelledonneCommunications / flexisip

Linphone.org mirror for flexisip (git://git.linphone.org/flexisip.git)
http://flexisip.org
GNU Affero General Public License v3.0
144 stars 69 forks source link

where is the new 2.0 mysql/mariadb schema? #84

Open petervnv opened 4 years ago

petervnv commented 4 years ago

Hi,

Can someone point me to the new schema that is being used with flexisip 2.0 beta?

I can't seem to find it anywhere on here and it seems it has changed a bit from the older flexisip, so upgrading to test the new 2.0 beta version breaks things.

Thanks!

harut420 commented 4 years ago

good question

Tycho-X commented 3 years ago

This is how my flexifax db looks including the conference tables. Take note that i had to reduce some varchar fields from 255 to 128 because of DB errors.

flexisip-wo-data.sql.txt

Tycho-X commented 3 years ago

Depending on the version of flexisip-proxy you have you must remove the table field "state" from the "chat_room_participant_device" table because the conference code seems to have hard coded directives to add this field even if its already there sic