Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

LimeSurey database

  • andersta
  • andersta's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 11 months ago - 3 years 11 months ago #198337 by andersta
LimeSurey database was created by andersta
Hi, I very need help, maybe someone have LimeSurvey database logical model or some UML diagramas of system?
Last edit: 3 years 11 months ago by andersta.
The topic has been locked.
  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 11 months ago #198368 by Joffm
Replied by Joffm on topic LimeSurey database
Hi,
if you have LimeSurvey installed you may do it by yourself.
With tools that re-engineer the database like fabforce dbdesigner, or MySQL workbench, or others.

Joffm

Volunteers are not paid.
Not because they are worthless, but because they are priceless
The following user(s) said Thank You: andersta
The topic has been locked.
  • andersta
  • andersta's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 11 months ago #198381 by andersta
Replied by andersta on topic LimeSurey database
Thanks for the answer, Yes I know that, I export MySQL dump file from limesurvey and import in MySQL workbench, but I have only tables I don't see relationships connections.
The topic has been locked.
  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 11 months ago #198412 by Joffm
Replied by Joffm on topic LimeSurey database
Are you sure there are some?

Foreign Keys and MyISAM tables?

Joffm

Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.
  • andersta
  • andersta's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 11 months ago #198440 by andersta
Replied by andersta on topic LimeSurey database
When I import database in MySQL workbench I see only tables like in image without tables realationships.
Attachments:
The topic has been locked.
  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 11 months ago #198455 by Joffm
Replied by Joffm on topic LimeSurey database
And I asked: Are you sure there are some?

Foreign keys and MyISAM tables?

Two posts from Stackoverflow:

I can't see any reference elsewhere in the current documentation to indicate that FK constraints are still intended for MyISAM in the future, nor can I see any specific documentation/discussion/record for this change. So yes, I would guess it is no longer planned

I do remember the times when mysql had only myisam and innodedb was in development. MyIsam has no foreign keys because it is old system that does not support relations in database. It will never use foreign keys! To Use it you have innodb. If you don't need all stuff, like relations in DB, use MyISAM to get better performance.


Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose