I am just getting started with SQLite and SQL in general. I am using a PHP script to facilitate a secure login process. This script uses an SQLite database with a table users containing user id (primary key) username, email and password hash. I want to store additional information on users (e.g. name), but I don't want to touch the table the script uses, so I'm trying to add another table users_info with a foreign key referencing the user id of the users table. This takes care of deleting a user from the users_info table whenever I delete a user from the login script's users table, but I also want a new row (with the correct user id) to be created in users_info whenever I register a new user to the users table.
Is this possible?
Aucun commentaire:
Enregistrer un commentaire