Hello. if I implement the security module in my sc project it creates the tables for this purpose in my local database. what is the correct way to recreate the same tables in the production environment database? should I copy the sql code created by sc or what other method?
also I would like to know what happens if I decide to remove the security module from the project does sc drops the tables for me?
thank you
Use phpMyAdmin or a similar tool to export your tables. Make sure that you at least copy the content of the security tables as you will need to have an initial user to be able to logon and add the other preferences. useually you only want to have lookup tables, so in general I dump the current database as sql and import it on the server and then remove what I don’t need. If you remove the security module then scriptcase will not remove the tables for you.
I use mysql workbench. I can export security tables as sql.
Thank you