Drop Database if exists Etraining;
Create Database Etraining;
use Etraining;

--
-- Table structure for table 'users'
--

CREATE TABLE users (
  UserKey int(9) NOT NULL auto_increment,
  UserName varchar(15) NOT NULL default '',
  Password varchar(15) NOT NULL default '',
  Active tinyint(1) default '1',
  PRIMARY KEY  (UserKey)
) TYPE=MyISAM;

--
-- Data for table 'users'
--


INSERT INTO users VALUES (1,'Greg','biffle',1);
INSERT INTO users VALUES (2,'Doug','pbmaster',1);
INSERT INTO users VALUES (3,'Stevn','linuxpro',1);
INSERT INTO users VALUES (4,'Skip','noretry',1);

--
-- Table structure for table 'accounts'
--

CREATE TABLE accounts (
  AccountKey int(9) NOT NULL auto_increment,
  UserKey int(9) NOT NULL default '0',
  Balance decimal(9,2) default NULL,
  LastUpdated datetime default NULL,
  PRIMARY KEY  (AccountKey)
) TYPE=MyISAM;

--
-- Data for table 'accounts'
--


INSERT INTO accounts VALUES (1,1,29.96,NULL);
INSERT INTO accounts VALUES (2,2,367.52,NULL);
INSERT INTO accounts VALUES (3,3,18.74,NULL);
INSERT INTO accounts VALUES (4,4,1852.83,NULL);