| CREATE TABLE roles |
| ( |
| id INT NOT NULL PRIMARY KEY, |
| role VARCHAR(100) NOT NULL UNIQUE |
| ); |
| |
| CREATE TABLE users |
| ( |
| id INT NOT NULL PRIMARY KEY, |
| username VARCHAR(100) NOT NULL UNIQUE, |
| pwd VARCHAR(50) NOT NULL |
| ); |
| |
| CREATE TABLE user_roles |
| ( |
| user_id INT NOT NULL, |
| role_id INT NOT NULL, |
| UNIQUE(user_id, role_id) |
| ); |
| |
| INSERT INTO roles VALUES |
| (0,'user'), |
| (1,'admin'); |
| |
| INSERT INTO users VALUES |
| (1,'jetty','MD5:164c88b302622e17050af52c89945d44'), |
| (2,'admin','CRYPT:adpexzg3FUZAk'), |
| (3,'other','OBF:1xmk1w261u9r1w1c1xmq'), |
| (4,'plain','plain'), |
| (5,'user','password'), |
| (6,'digest','MD5:6e120743ad67abfbc385bc2bb754e297'); |
| |
| INSERT INTO user_roles VALUES |
| (1,1), |
| (2,1), |
| (2,2), |
| (3,1), |
| (4,1), |
| (5,1), |
| (6,1); |