File: dbscript

package info (click to toggle)
witty 3.1.2-3
  • links: PTS
  • area: main
  • in suites: squeeze
  • size: 45,512 kB
  • ctags: 35,832
  • sloc: cpp: 69,469; ansic: 66,945; xml: 4,383; sh: 594; perl: 108; makefile: 106
file content (18 lines) | stat: -rw-r--r-- 392 bytes parent folder | download 
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;