-- SQL Script to insert a new user into the 'ci_news' database.
-- IMPORTANT: This script assumes you have a table named 'users' with 'username' and 'password' columns.
--            Adjust table and column names if yours are different.

-- If your 'users' table has an 'email' column instead of 'username', you might want to use:
-- INSERT INTO users (email, password) VALUES ('rikangebug', '$2y$10$54nJTna.cGRWAnzN3de1mu/npWXC0cgf6Bohfe5g3txbMd1GuSJ7y');

-- Also, if your application's AuthController still checks hardcoded passwords,
-- you WILL need to modify it to query this database table and use `password_verify()`
-- to authenticate users against this hashed password.

INSERT INTO users (username, password) VALUES ('rikangebug', '$2y$10$54nJTna.cGRWAnzN3de1mu/npWXC0cgf6Bohfe5g3txbMd1GuSJ7y');
