Shifting to SQlite

So today I have worked on the database creation for the 'Admin' and 'Users' tables - both within the database. It is a simple program only designed for creating the database in the first place, later-on I will be working on the adding and removal of users.

This first image shows the program accessing the database and creating the new table within the database as the program calls it. (shown below)

The second image calls the create_table function , adding a new table to the database and then proceeding to add all the relevant data columns, such as email address, username and user ID.

The user ID is a new addition from the previous excel method - which may be useful in streamlining search methods for calling data from the db later in the program.

*Edit*

This is what the table structure looks like in the database itself. (viewed using the SQlite Inspector program, as recommended by Python Schools)