ヤミRoot VoidGate

Viewing: sample.sql

-- 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');

User / IP	: 216.73.216.110
Host / Server	: 146.88.233.70 / dev.loger.cm
System	: Linux hybrid1120.fr.ns.planethoster.net 3.10.0-957.21.2.el7.x86_64 #1 SMP Wed Jun 5 14:26:44 UTC 2019 x86_64