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