· 8 years ago · Jan 15, 2018, 02:48 AM
1Table structure
2CREATE TABLE IF NOT EXISTS users (
3 id int(11) NOT NULL AUTO_INCREMENT,
4 username varchar(50) NOT NULL,
5 password varchar(50) NOT NULL,
6 salt varchar(50) NOT NULL,
7 role varchar(50) NOT NULL,
8 date_created datetime NOT NULL,
9 PRIMARY KEY (id)
10)
11
12Data:
13
14INSERT INTO users (username, password, salt, role, date_created)
15VALUES ('admin', SHA1('passwordce8d96d579d389e783f95b3772785783ea1a9854'),
16 'ce8d96d579d389e783f95b3772785783ea1a9854', 'administrator', NOW());