| 1 |
lars |
1 |
-- SQLite schema for permission administration
|
|
|
2 |
-- usage: sqlite /tmp/user.db < sample.sql
|
|
|
3 |
|
|
|
4 |
CREATE TABLE auth (
|
|
|
5 |
username VARCHAR(50) NOT NULL, -- username
|
|
|
6 |
password VARCHAR(50) NOT NULL -- password
|
|
|
7 |
);
|
|
|
8 |
|
|
|
9 |
-- plain password
|
|
|
10 |
--INSERT INTO auth VALUES ('taro','secret');
|
|
|
11 |
--INSERT INTO auth VALUES ('jiro','secret');
|
|
|
12 |
|
|
|
13 |
-- md5 hash password: secret
|
|
|
14 |
--INSERT INTO auth VALUES ('taro','5ebe2294ecd0e0f08eab7690d2a6ee69');
|
|
|
15 |
--INSERT INTO auth VALUES ('jiro','5ebe2294ecd0e0f08eab7690d2a6ee69');
|
|
|
16 |
|
|
|
17 |
-- a1 (md5(username:realm:password)) for http digest authentication
|
|
|
18 |
-- realm: sample, password: secret
|
|
|
19 |
INSERT INTO auth VALUES ('taro','d0f7c5ba4f2f2ed16f2a714332633ad5');
|
|
|
20 |
INSERT INTO auth VALUES ('jiro','d41438d297ee671f2249cc0d6c1f3997');
|