/usr/lib/Wt/examples/hangman/dbscript is in witty-examples 3.1.10-1ubuntu2.
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 | create database hangman;
use hangman;
create table users (
user char(50) primary key,
pass char(50),
numgames int,
score int,
lastseen datetime,
index(score)
);
grant insert, select, update on hangman.users
to "hangman"@"localhost" identified by "hangwoman";
insert into hangman.users values ("guest", md5("guest"), 0, 0, now());
#alter table users add lastseen datetime;
|