/usr/share/php/test/Auth_HTTP/tests/sample.sql is in php-auth-http 2.1.6-4.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
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');
|