- Posts: 3
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
LimeSurey database
- andersta
- Topic Author
- Offline
- New Member
Less
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
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 12908
- Thank you received: 3974
3 years 11 months ago #198368
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
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
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
- Topic Author
- Offline
- New Member
Less
More
- Posts: 3
- Thank you received: 0
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
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 12908
- Thank you received: 3974
3 years 11 months ago #198412
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Replied by Joffm on topic LimeSurey database
Are you sure there are some?
Foreign Keys and MyISAM tables?
Joffm
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
- Topic Author
- Offline
- New Member
Less
More
- Posts: 3
- Thank you received: 0
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
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 12908
- Thank you received: 3974
3 years 11 months ago #198455
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
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:
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.