# updated dec 2020 # Creates a Simple User table # Uses an auto-incrementing primary key as userId CREATE TABLE user ( userId INT NOT NULL AUTO_INCREMENT PRIMARY KEY, username VARCHAR(100), password VARCHAR(100) ) ENGINE=InnoDB;