DROP TABLE IF EXISTS users;
CREATE TABLE users (
ID INT PRIMARY KEY AUTO_INCREMENT,
short varchar(10) NOT NULL,
vname VARCHAR(50) NOT NULL,
nname VARCHAR(50) NOT NULL,
password char(16) DEFAULT '' NOT NULL,
state char(50) DEFAULT '' NOT NULL,
UNIQUE short (short)
);

INSERT INTO users VALUES ('','admin','Micky','Mouse','admin','');
INSERT INTO users VALUES ('','user1','Donald','Duck','daisy','');
INSERT INTO users VALUES ('','user2','Dagobert','Duck','gold','');

GRANT SELECT, INSERT, UPDATE, DELETE ON usertrack.* TO gunny@localhost IDENTIFIED BY 'RaZoRbLaCk'