I'm creating a plugin that adds some data to a custom table created by my plugin on plugin activations.
I also created a settings page with a form that users can insert their own data to the database.
The problem Everything is working fine but each time i deactivate(i don't mean uninstall) and reactivate the plugin, the data get duplicated in the table.
Mind you, due to the large amount of data, i chose to use "longtext" as the table column type.
Making the columns type is not an UNIQUE.
My question How do i prevent the plugin from inserting the same data that was meant to be inserted int the database just once on plugin activation?