Plugin example that creates new tables?

If you just want to add data to the wp_options table (which seems to be common practice), just read through this guide: https://codex.www.ads-software.com/Writing_a_Plugin#Saving_Plugin_Data_to_the_Database

I have only used three plugins that actually create database tables. They appear to create the tables upon activation and seem to require WP’s upgrade scripts to do so. Here are the plugins:

https://www.ioerror.us/software/bad-behavior/
https://unknowngenius.com/blog/wordpress/spam-karma/dev/
https://uberdork.supertwist.net/2005/03/13/plug-it-in-plug-it-in/

thanks, I see the pattern to use now! cheers