ea_migrations table does not have any primary key

alextselegidis / easyappointments

:date: Easy!Appointments - Self Hosted Appointment Scheduler

https://easyappointments.org

GNU General Public License v3.0

3.26k stars 1.25k forks source link

Closed rgtzths closed 4 years ago

rgtzths commented 4 years ago

So, I'm trying to create a high availability MySQL Cluster to deploy with the application.

But when using MySQL Group Replication, I need a primary key for the tables.

Can you help me out with this? Just need to have this done and the application will be able to be deployed.

When I'm finished I pretend to leave the docker-compose for a swarm available, so if you could help me out. I would appreciate it.

alextselegidis commented 4 years ago

Hello @rgtzths!

The ea_migrations table is actually based on the CodeIgniter v3 framework, which includes the code required for the migrations to work.

You can simply mark the version field as primary key and you will therefore have no problems with your hosting environment.

Alex Tselegidis, Easy!Appointments Creator
Need a customization? Contact me in person!