D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
opt
/
lampp
/
lib
/
php
/
doc
/
Auth_HTTP
/
docs
/
Filename :
sample.sql
back
Copy
-- 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');