Basic programming techniques you should have learned before building a plugin:
- You can concatenate checks with && (and) and || (or).
- You can (and should) guard each
CREATE
query with its own check
SQL syntax you should have looked into before writing queries on your own:
On a related note, please make sure that you delete these tables when the plugin is uninstalled/deleted.
PS: No offense intended, but it does look like you copy pasted without knowing what the code does. Please be aware that by doing this in a plugin you risk other people’s installations!