# phpMyAdmin MySQL-Dump
# version 2.5.1
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: Oct 15, 2003 at 08:49 PM
# Server version: 4.0.15
# PHP Version: 4.3.3
# Database : `nozicle_demodb`
# --------------------------------------------------------

#
# Table structure for table `employee`
#
# Creation: Oct 15, 2003 at 08:49 PM
# Last update: Oct 15, 2003 at 08:49 PM
#

DROP TABLE IF EXISTS `employee`;
CREATE TABLE `employee` (
  `EmpNo` varchar(32) NOT NULL default '0',
  `LastName` varchar(20) NOT NULL default '',
  `FirstName` varchar(15) NOT NULL default '',
  `PhoneExt` varchar(4) NOT NULL default '',
  `HireDate` date NOT NULL default '0000-00-00',
  `Salary` float NOT NULL default '0',
  PRIMARY KEY  (`EmpNo`)
) TYPE=MyISAM;

#
# Dumping data for table `employee`
#

INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('2', 'Nelson', 'Roberto', '250', '1998-12-28', '40000');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('4', 'Young', 'Bruce', '233', '1988-12-28', '55500');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('5', 'Lambert', 'Kim', '22', '1989-02-06', '25000');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('8', 'Johnson', 'Leslie', '410', '1989-04-05', '25050');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('9', 'Forest', 'Phil', '229', '1989-04-17', '25050');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('11', 'Weston', 'K. J.', '34', '1990-01-17', '33292.9');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('12', 'Lee', 'Terri', '256', '1990-01-01', '45332');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('14', 'Hall', 'Stewart', '227', '1990-06-04', '34482.6');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('15', 'Young', 'Katherine', '231', '1990-06-14', '24400');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('20', 'Papadopoulos', 'Chris', '887', '1990-01-01', '25050');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('24', 'Fisher', 'Pete', '888', '1990-09-12', '23040');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('28', 'Bennet', 'Ann', '5', '1991-02-18', '34482.8');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('29', 'De Souza', 'Roger', '288', '1991-02-18', '25500');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('34', 'Baldwin', 'Janet', '2', '1991-03-21', '23300');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('36', 'Reeves', 'Roger', '6', '1991-04-25', '33620');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('37', 'Stansbury', 'Willie', '7', '1991-04-25', '39224');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('44', 'Phong', 'Leslie', '216', '1991-06-03', '40350');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('45', 'Ramanathan', 'Ashok', '209', '1991-08-01', '33292.9');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('46', 'Steadman', 'Walter', '210', '1991-08-09', '19599');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('52', 'Nordstrom', 'Carol', '420', '1991-10-02', '4500');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('61', 'Leung', 'Luke', '3', '1992-02-18', '34500');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('65', 'O Brien', 'Sue Anne', '877', '1992-03-23', '31275');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('71', 'Burbank', 'Jennifer M.', '289', '1992-04-15', '45332');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('72', 'Sutherland', 'Claudia', '', '1992-04-21', '35699');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('83', 'Bishop', 'Dana', '290', '1992-06-01', '45000');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('85', 'MacDonald', 'Mary S.', '477', '1992-06-01', '35699');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('94', 'Williams', 'Randy', '892', '1992-08-08', '28900');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('105', 'Bender', 'Oliver H.', '255', '1992-10-08', '36799');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('107', 'Cook', 'Kevin', '894', '1993-02-01', '35500');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('109', 'Brown', 'Kelly', '202', '1993-02-01', '27000');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('110', 'Ichida', 'Yuki', '22', '1993-02-04', '25689');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('113', 'Page', 'Mary', '845', '1993-04-12', '48000');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('114', 'Parker', 'Bill', '247', '1993-06-01', '35000');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('118', 'Yamamoto', 'Takashi', '23', '1993-07-01', '32500');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('121', 'Ferrari', 'Roberto', '1', '1993-07-12', '40500');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('127', 'Yanowski', 'Michael', '492', '1993-08-09', '44000');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('134', 'Glon', 'Jacques', '', '1993-08-23', '24855');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('136', 'Johnson', 'Scott', '265', '1993-09-13', '30589');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('138', 'Green', 'T.J.', '218', '1993-11-01', '36000');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('141', 'Osborne', 'Pierre', '', '1994-01-03', '35600');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('144', 'Montgomery', 'John', '820', '1994-03-30', '35699');
INSERT INTO `employee` (`EmpNo`, `LastName`, `FirstName`, `PhoneExt`, `HireDate`, `Salary`) VALUES ('145', 'Guckenheimer', 'Mark', '221', '1994-05-02', '32000');
# --------------------------------------------------------

#
# Table structure for table `user`
#
# Creation: Oct 15, 2003 at 06:54 PM
# Last update: Oct 15, 2003 at 06:55 PM
#

DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `user_id` varchar(32) NOT NULL default '',
  `user_first_name` varchar(50) NOT NULL default '',
  `user_last_name` varchar(50) NOT NULL default '',
  `user_login` varchar(10) NOT NULL default '',
  `user_password` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`user_id`)
) TYPE=MyISAM;

#
# Dumping data for table `user`
#

INSERT INTO `user` (`user_id`, `user_first_name`, `user_last_name`, `user_login`, `user_password`) VALUES ('4FE664FE96F2445E8933BB78B3A9', 'system', 'administrator', 'login', 'password');

