CREATE DATABASE sitename;
USE sitename;
TRUNCATE users;
CREATE TABLE users (
   user_id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
    first_name VARCHAR(15) NOT NULL,
    last_name VARCHAR(30) NOT NULL,
    email VARCHAR(40) NOT NULL,
    password CHAR(40) NOT NULL,
    registration_date DATETIME NOT NULL,
     PRIMARY KEY (user_id)
);
SHOW TABLES;
SHOW COLUMNS FROM users;
DESCRIBE users;

INSERT INTO users (first_name, last_name, email, password, registration_date) VALUES ('Anabella', 'Ion', 'anabella@yahoo.com', SHA('furnica'), NOW());
INSERT INTO users (first_name, last_name, email, password, registration_date) VALUES
('John', 'Lennon', 'john@beatles.com', SHA('Happin3ss'), NOW()),
('Paul', 'McCartney', 'paul@beatles.com', SHA('letITbe'), NOW()),
('George', 'Harrison', 'george@beatles.com', SHA('something'), NOW()),
('Ringo', 'Starr', 'ringo@beatles.com', SHA('thisboy'), NOW());
INSERT INTO users (first_name, last_name, email, password, registration_date) VALUES ('Phil', 'Bank', 'phil@yahoo.com', SHA('phil'), NOW());
INSERT INTO users (first_name, last_name, email, password, registration_date) VALUES ('Tyler', 'Banks', 'Banks@yahoo.com', SHA('phili'), NOW());
INSERT INTO users (first_name, last_name, email, password, registration_date) VALUES ('Eric', 'Simpson', 'erc@yahoo.com', SHA('phile'), NOW());
INSERT INTO users (first_name, last_name, email, password, registration_date) VALUES ('George', 'Bush', 'gb@yahoo.com', SHA('philc'), NOW());
INSERT INTO users (first_name, last_name, email, password, registration_date) VALUES ('George', 'Bushon', 'gb1@yahoo.com', SHA('philf'), NOW());
INSERT INTO users (first_name, last_name, email, password, registration_date) VALUES ('George', 'Bushons', 'gbs1@yahoo.com', SHA('phill'), NOW());
INSERT INTO users (first_name, last_name, email, password, registration_date) VALUES ('George', 'bush', 'gbs12@yahoo.com', SHA('phily'), NOW());
INSERT INTO users (first_name, last_name, email, password, registration_date) VALUES ('George', 'Banc', 'banc@yahoo.com', SHA('philg'), NOW());
INSERT INTO users (first_name, last_name, email, password, registration_date) VALUES ('George', 'Banca', 'banca@yahoo.com', SHA('philh'), NOW());
INSERT INTO users (first_name, last_name, email, password, registration_date) VALUES ('Will','Esmith', 'esmith@autor.com', SHA('philt'), NOW());
INSERT INTO users (first_name, last_name, email, password, registration_date) VALUES ('William', 'Esmiths', 'esmits@yahoo.com', SHA('philh'), NOW());
INSERT INTO users (first_name, last_name, email, password, registration_date) VALUES ('Di', 'Smith', 'di@yahoo.com', SHA('philn'), NOW());