· 5 years ago · Apr 21, 2020, 02:18 AM
1-- SQL for creating admin user table
2
3CREATE TABLE IF NOT EXISTS `php-jquery_example`.`users` (
4 `user_id` INT(11) NOT NULL AUTO_INCREMENT,
5 `user_name` VARCHAR(80) DEFAULT NULL,
6 `user_pass` VARCHAR(47) DEFAULT NULL,
7 `user_email` VARCHAR(80) DEFAULT NULL,
8 PRIMARY KEY (`user_id`),
9 UNIQUE (`user_name`)
10) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci;
11
12
13-- SQL For creating the user (pg 208)
14
15INSERT INTO `php-jquery_example`.`users`
16 (`user_name`, `user_pass`, `user_email`)
17VALUES (
18 'testuser',
19 'hashedpassgoeshere',
20 'admin@example.com'
21);