Category: mysql

Create a MySQL users Table

Code for Creating `users` Table inside PhpMyAdmin


CREATE TABLE `users` (
  `id` int NOT NULL AUTO_INCREMENT,
  `employee_id` int DEFAULT NULL,
  `user_type` varchar(50) DEFAULT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `users` (`employee_id`, `user_type`, `username`, `password`) VALUES
                   (NULL, 'SUPER ADMIN', 'admin', 'admin'),
                   (1, 'NORMAL', 'robin', 'robin'),
                   (2, 'ADMIN', 'taylor', 'taylor'),
                   (3, 'ADMIN', 'vivian', 'vivian'),
                   (4, 'NORMAL', 'harry', 'harry'),
                   (7, 'ADMIN', 'melinda', 'melinda'),
                   (8, 'NORMAL', 'harley', 'harley');

Command line code for Creating `user` from a users.sql file


mysql> use db_name;
mysql> source users.sql;