USE adaptive_php;

INSERT INTO accounts (username, password_md5, role, created_at)
VALUES ('tk1', 'c4ca4238a0b923820dcc509a6f75849b', 'student', NOW())
ON DUPLICATE KEY UPDATE username = VALUES(username);

-- admin account with password md5('1') for convenience
INSERT INTO accounts (username, password_md5, role, created_at)
VALUES ('admin', 'c4ca4238a0b923820dcc509a6f75849b', 'admin', NOW())
ON DUPLICATE KEY UPDATE username = VALUES(username), role = VALUES(role);
