DROP  database IF EXISTS myrealm;

CREATE database myrealm;

USE myrealm;

CREATE TABLE roles (
  Username varchar(15) default NULL,
  Role varchar(32) NOT NULL default ''
);

--
-- Dumping data for table `roles`
--

INSERT INTO roles VALUES ('admin','admin');
INSERT INTO roles VALUES ('admin','manager');
INSERT INTO roles VALUES ('rich','customer');

--
-- Table structure for table `users`
--

CREATE TABLE users (
  Username varchar(15) NOT NULL default '',
  Password varchar(32) NOT NULL default '',
  PRIMARY KEY  (Username)
);

--
-- Dumping data for table `users`
--

INSERT INTO users VALUES ('admin','password');
INSERT INTO users VALUES ('george','washington');

