name your tables and views in lower case
Posted: 2019-09-29 13:09
Hi,
I place this here in the tips-section as it cost me quite some time and work to correct "nice" tablenames.
My testserver is a Linux system. I have exported everything and it's running on a windows server now - no problem. But when I tried the other way around, getting the "live"-system back to my test-setting I had quite a lot of problems, all of those because of case sensitivity of Linux (and thus: MySQL tablenames!)
For this I strongly suggest,
-> that you name your tables with lowercase only !
-> that you name your views in the database with lowercase only (as you might later create a pseudo-table in AppGini with that same name)!
Example: Not like this: My_Table . But like this: my_table.
Take care and hopefully do not repeat my mistake
Olaf
I place this here in the tips-section as it cost me quite some time and work to correct "nice" tablenames.
My testserver is a Linux system. I have exported everything and it's running on a windows server now - no problem. But when I tried the other way around, getting the "live"-system back to my test-setting I had quite a lot of problems, all of those because of case sensitivity of Linux (and thus: MySQL tablenames!)
For this I strongly suggest,
-> that you name your tables with lowercase only !
-> that you name your views in the database with lowercase only (as you might later create a pseudo-table in AppGini with that same name)!
Example: Not like this: My_Table . But like this: my_table.
Take care and hopefully do not repeat my mistake
Olaf