-- phpMyAdmin SQL Dump -- version 4.0.10.14 -- http://www.phpmyadmin.net -- -- Host: localhost:3306 -- Generation Time: Sep 19, 2016 at 12:29 PM -- Server version: 5.6.31 -- PHP Version: 5.6.20 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `tmiva_smittys` -- -- -------------------------------------------------------- -- -- Table structure for table `conference_calendar` -- CREATE TABLE IF NOT EXISTS `conference_calendar` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '', `link` varchar(50) NOT NULL DEFAULT '', `notes` varchar(255) NOT NULL DEFAULT '', `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `end_time` datetime DEFAULT NULL, `conference_room` varchar(12) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ; -- -- Dumping data for table `conference_calendar` -- INSERT INTO `conference_calendar` (`id`, `title`, `link`, `notes`, `date`, `end_time`, `conference_room`) VALUES (5, 'Test', 'eventID=5', 'test', '2007-05-09 05:00:00', '2007-05-09 00:00:00', 'Alexandria'), (6, 'sdf', 'eventID=6', 'f', '2007-05-09 05:00:00', '2007-05-09 00:00:00', 'Alexandria'), (4, 'Blah', 'eventID=4', '', '2007-05-10 11:30:00', '2007-05-10 15:30:00', 'Alexandria'), (7, 'New Event', 'eventID=7', 'Something', '2007-05-09 05:00:00', '2007-05-09 05:00:00', ''), (8, 'f', 'eventID=8', 'f', '2007-06-09 05:00:00', '2007-06-09 05:00:00', ''), (9, 'asdf', 'eventID=9', 'a', '2007-06-09 05:00:00', '2007-06-09 05:00:00', 'Alexandria'), (10, 'new event', 'eventID=10', 'this is a discription', '2007-04-04 11:00:00', '2007-04-04 14:00:00', 'Alexandria'), (11, 'does this event work?', 'eventID=11', '', '2007-04-10 10:00:00', '2007-04-10 13:30:00', 'Crestwood'), (12, 'New Even', 'eventID=12', '', '2007-08-16 05:00:00', '2007-08-16 05:00:00', 'Alexandria'), (13, 'Another Event', 'eventID=13', 'This is a sample event. Anything can go here.', '2007-08-16 09:30:00', '2007-08-16 10:30:00', 'Alexandria'); -- -------------------------------------------------------- -- -- Table structure for table `employees` -- CREATE TABLE IF NOT EXISTS `employees` ( `id` smallint(6) NOT NULL AUTO_INCREMENT, `first_name` varchar(30) DEFAULT NULL, `last_name` varchar(30) DEFAULT NULL, `email` varchar(40) DEFAULT NULL, `business_phone1` varchar(12) DEFAULT NULL, `business_phone2` varchar(17) DEFAULT NULL, `mobile_phone` varchar(12) DEFAULT NULL, `radio_phone` varchar(12) DEFAULT NULL, `fax` varchar(12) DEFAULT NULL, `position` varchar(45) DEFAULT NULL, `location` varchar(45) DEFAULT NULL, `company` varchar(60) DEFAULT NULL, `business_address` varchar(100) DEFAULT NULL, `business_city` varchar(70) DEFAULT NULL, `business_state` char(2) DEFAULT NULL, `business_zip` varchar(5) DEFAULT NULL, `department` varchar(45) DEFAULT NULL, `department_number` smallint(6) unsigned DEFAULT NULL, `notes` varchar(200) DEFAULT NULL, `supervisor` varchar(30) DEFAULT NULL, `supervisor_contact` varchar(24) DEFAULT NULL, `backup` varchar(30) DEFAULT NULL, `file_number` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6503 ; -- -- Dumping data for table `employees` -- INSERT INTO `employees` (`id`, `first_name`, `last_name`, `email`, `business_phone1`, `business_phone2`, `mobile_phone`, `radio_phone`, `fax`, `position`, `location`, `company`, `business_address`, `business_city`, `business_state`, `business_zip`, `department`, `department_number`, `notes`, `supervisor`, `supervisor_contact`, `backup`, `file_number`) VALUES (6264, 'Terry', 'Beavers', 'tbeavers@smittys.com', '703-704-5532', '703-780-7800 x482', '571-221-8557', '164*21*47205', '703-361-2307', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Sales', 65535, '', 'Al Mayo', 'Ext. 324 703-704-5555', 'Rusty Snyder', 0), (6265, 'Billy', 'Donnelly', 'wpdonnelly@smittys.com', '703-704-5520', '703-780-7800 x305', '703-929-7964', '164*21*4567', '703-530-0090', '', 'Crestwood', 'Smitty's Building Supply', '10535 Crestwood Dr. # 201', 'Manassas', 'VA', '20109', 'Sales', 65535, '', 'Al Mayo', 'Ext. 324 703-704-5555', 'Pennny Mitchell', 0), (6266, 'Ben', 'Haines', 'ben.haines@smittys.com', '703-704-5584', '703-780-7800 x306', '571-436-6747', '164*117*1744', '703-530-0090', '', 'Crestwood', 'Smitty's Building Supply', '10535 Crestwood Dr. # 201', 'Manassas', 'VA', '20109', 'Sales', 65535, '', 'Al Mayo', 'Ext. 324 703-704-5555', 'Ken Fallon', 0), (6267, 'Steve', 'Heath', 'sheath@smittys.com', '703-704-5535', '703-780-7800 x307', '571-220-8802', '164*21*4552', '703-530-0090', '', 'Crestwood', 'Smitty's Building Supply', '10535 Crestwood Dr. # 201', 'Manassas', 'VA', '20109', 'Sales', 65535, '', 'Al Mayo', 'Ext. 324 703-704-5555', 'BJ Ritenour', 0), (6268, 'George', 'Lollar', 'glollar@smittys.com', '703-704-5537', '703-780-7800 x315', '703-906-5977', '164*21*20488', '703-530-0090', '', 'Crestwood', 'Smitty's Building Supply', '10535 Crestwood Dr. # 201', 'Manassas', 'VA', '20109', 'Sales', 65535, '', 'Al Mayo', 'Ext. 324 703-704-5555', 'Ron Tindell', 0), (6269, 'Rick', 'Luskey', 'rluskey@smittys.com', '703-704-5545', '703-780-7800 x304', '571-221-8929', '164 *21*4733', '703-530-0090', '', 'Crestwood', 'Smitty's Building Supply', '10535 Crestwood Dr. # 201', 'Manassas', 'VA', '20109', 'Sales', 65535, '', 'Al Mayo', 'Ext. 324 703-704-5555', '', 0), (6270, 'Richard', 'Morningstar', 'rmorningstar@smittys.com', '703-704-5547', '703-780-7800 x406', '703-929-4697', '164*21*39897', '703-361-2307', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Sales', 65535, '', 'Al Mayo', 'Ext. 324 703-704-5555', '', 0), (6271, 'Fatimah', 'Murphy', 'fatimah.murphy@smittys.com', '703-704-5593', '703-780-7800 x313', '', '', '703-530-0090', '', 'Crestwood', 'Smitty's Building Supply', '10535 Crestwood Dr. # 201', 'Manassas', 'VA', '20109', 'Sales Support', 65535, '', 'Al Mayo', 'Ext. 324 703-704-5555', '', 0), (6272, 'Greg', 'Rhatican', 'grhatican@smittys.com', '703-704-5534', '703-780-7800 x314', '703-906-8213', '164*21*34452', '703-530-0090', '', 'Crestwood', 'Smitty's Building Supply', '10535 Crestwood Dr. # 201', 'Manassas', 'VA', '20109', 'Sales', 65535, '', 'Al Mayo', 'Ext. 324 703-704-5555', '', 0), (6273, 'Tina', 'Ritenour', 'tritenour@smittys.com', '703-780-5558', '703-780-7800 x301', '', '', '703-530-0090', '', 'Crestwood', 'Smitty's Building Supply', '10535 Crestwood Dr. # 201', 'Manassas', 'VA', '20109', 'Admin', 65535, '', 'Al Mayo', 'Ext. 324 703-704-5555', '', 0), (6274, 'BJ', 'Ritenour', 'eritenour@smittys.com', '703-704-5527', '703-780-7800 x332', '', '', '703-530-0090', '', 'Crestwood', 'Smitty's Building Supply', '10535 Crestwood Dr. # 201', 'Manassas', 'VA', '20109', 'Sales Support', 65535, '', 'Al Mayo', 'Ext. 324 703-704-5555', '', 0), (6275, 'Ron', 'Tindell', 'rtindell@smittys.com', '703-704-5549', '703-780-7800 x331', '', '', '703-530-0090', '', 'Crestwood', 'Smitty's Building Supply', '10535 Crestwood Dr. # 201', 'Manassas', 'VA', '20109', 'Sales Support', 65535, '', 'Al Mayo', 'Ext. 324 703-704-5555', '', 0), (6276, 'Jason', 'Worrell', 'jworrell@smittys.com', '703-704-5556', '703-780-7800 x303', '703-906-5974', '164*21*20485', '703-530-0090', '', 'Crestwood', 'Smitty's Building Supply', '10535 Crestwood Dr. # 201', 'Manassas', 'VA', '20109', 'Sales', 65535, '', 'Al Mayo', 'Ext. 324 703-704-5555', 'Fatimah Murphy', 0), (6277, 'Kenny', 'Fallon', 'kfallon@smittys.com', '703-704-5595', '703-780-7800 x325', '703-906-9191', '164*21*13533', '703-530-0090', '', 'Crestwood', 'Smitty's Building Supply', '10537 Crestwood Dr. # 201', 'Manassas', 'VA', '20109', 'Sales Support', 65535, '', 'Ben Haines', '571-436-6747', '', 0), (6278, 'Penny', 'Mitchell', 'pmitchell@smittys.com', '703-704-5552', '703-780-7800 x318', '', '', '703-530-0090', 'Sales Coordinator', 'Crestwood', 'Smitty's Building Supply', '10538 Crestwood Dr. # 201', 'Manassas', 'VA', '20109', 'Sales Support', 65535, '', 'Billy Donnelly', '703-929-7964', '', 0), (6279, 'Juan', 'Calderon', '', '', '', '', '', '', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Yard-Day', 65535, '', 'Bobby Smith', '703-856-4922', '', 0), (6280, 'Cornell', 'Evans', '', '', '', '', '', '', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Yard-Night', 65535, '', 'Bobby Smith', '703-856-4922', '', 0), (6281, 'Justin', 'Fadely', '', '', '', '', '', '', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Yard-Night', 65535, '', 'Bobby Smith', '703-856-4922', '', 0), (6282, 'Jose Israel Calderon', 'Favela', '', '', '', '', '', '', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Yard-Night', 65535, '', 'Bobby Smith', '703-856-4922', '', 0), (6283, 'Ric', 'Herbst', 'rherbst@smittys.com', '703-704-5594', '703-780-7800 x522', '', '', '703-780-2066', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Sales', 65535, '', 'Bobby Smith', '703-856-4922', '', 0), (6284, 'Jaime', 'Lopez', '', '', '', '571-237-8811', '164*21*40669', '', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Warehouse', 65535, '', 'Bobby Smith', '703-856-4922', '', 0), (6285, 'John', 'Ocasio', '', '', '', '', '', '', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Yard-Night', 65535, '', 'Bobby Smith', '703-856-4922', '', 0), (6286, 'Calvin', 'Rhodes II', '', '', '', '', '', '', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Yard-Night', 65535, '', 'Bobby Smith', '703-856-4922', '', 0), (6287, 'Duval', 'Robinson', '', '', '', '', '', '', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Yard-Night', 65535, '', 'Bobby Smith', '703-856-4922', '', 0), (6288, 'Edgar', 'Rodriguez', '', '', '', '', '', '', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Yard-Night', 65535, '', 'Bobby Smith', '703-856-4922', '', 0), (6289, 'Doug', 'Thorson', 'dthorson@smittys.com', '703-704-5596', '703-780-7800 x309', '571-221-7210', '164*21*50995', '703-780-7638', '', 'Alexandria', 'Smitty's Industrial Division', '8457 Richmond Highway', 'Alexandria', 'VA', '22230', 'Industrial', 65535, '', 'Bobby Smith', '703-856-4922', 'Jim Weston', 0), (6290, 'Travis', 'Courtney', 'tcourtney@smittys.com', '', '703-778-8269', '571-221-6438', '164*157368*7', '703-778-8271', '', 'Notes Whse', '', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Windowsmith', 65535, '', 'Butch Jones', '571-221-6424', '', 0), (6291, 'Mary', 'Donatella', 'mdonatella@smittys.com', '703-704-5559', '703-780-7800 x420', '', '', '703-530-1254', '', 'Notes Whse', 'Windowsmith', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Windows Scheduling', 65535, '', 'Butch Jones', '571-221-6424', '', 0), (6292, 'Michael', 'Doyal', '', '', '', '', '', '', '', 'Notes Whse', 'Smitty's Building Supply', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Installation-windowsmith', 65535, '', 'Butch Jones', '571-221-6424', '', 0), (6293, 'Wladyslaw', 'Herbut', '', '', '', '', '', '', '', 'Notes Whse', 'Smitty's Building Supply', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Windows', 65535, '', 'Butch Jones', '571-221-6424', '', 0), (6294, 'Paul', 'Hughes', '', '', '', '', '', '', '', 'Notes Whse', 'Smitty's Building Supply', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Installation-windowsmith', 65535, '', 'Butch Jones', '571-221-6424', '', 0), (6295, 'Kevin', 'Jett', '', '', '', '', '', '', '', 'Notes Whse', 'Windowsmith', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Installation-windowsmith', 65535, '', 'Butch Jones', '571-221-6424', '', 0), (6296, 'Dennis', 'Morrison', '', '', '703-780-7800', '571-220-2941', '164*21*24265', '703-530-1252', '', 'Notes Whse', 'Smitty's Building Supply', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Installer', 65535, '', 'Butch Jones', '571-221-6424', '', 0), (6297, 'Dora', 'Perkins', 'dperkins@smittys.com', '703-704-5548', '703-780-7800 x428', '571-237-0838', '164*21*54130', '703-530-1254', '', 'Notes Whse', 'Windowsmith', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Windowsmith', 65535, '', 'Butch Jones', '571-221-6424', '', 0), (6298, 'Lonnie', 'Whitlow', 'lwhitlow@smittys.com', '', '703-780-7800 x432', '571-220-1067', '164*24*6583', '703-530-1254', '', 'Notes Whse', 'Windowsmith', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Windowsmith', 65535, '', 'Butch Jones', '571-221-6424', '', 0), (6299, 'James', 'Dudley', 'jdudley@smittys.com', '703-704-5521', '703-780-7800 x562', '571-221-1914', '165*1056*177', '703-780-4867', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Operations', 65535, '', 'Don Belt', '571-220-9885', '', 0), (6300, 'John', 'Gendreau', 'jgendreau@smittys.com', '703-704-5588', '703-780-7800 x308', '571-237-8231', '164*24*52183', '703-530-0090', '', 'Crestwood', 'Smitty's Building Supply', '10538 Crestwood Dr. # 201', 'Manassas', 'VA', '20109', 'Sales', 65535, '', 'Don Belt', '571-220-9885', '', 0), (6301, 'Roy', 'Herndon', 'rherndon@smittys.com', '703-704-5591', '703-780-7800 x483', '571-722-2075', '165*1056*187', '703-361-2307', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Procurement', 65535, '', 'Don Belt', '571-220-9885', '', 0), (6302, 'Mark', 'Jones', 'mjones@smittys.com', '703-704-5562', '703-780-7800 x485', '571-722-2637', '165*1056*203', '703-361-2307', 'Sr. Millwork Buyer', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Procurement', 65535, '', 'Don Belt', '571-220-9885', '', 0), (6303, 'Rich', 'Kniatt', 'rjkniatt@smittys.com', '703-704-5511', '703-780-7800 x326', '703-898-0470', '164*21*10657', '', '', 'Crestwood', 'Smitty's Millwork and Supply', '10535 Crestwood Dr. # 201', 'Manassas', 'VA', '20109', 'Commercial Sales', 65535, '', 'Don Belt', '571-220-9885', 'KT Thomas', 0), (6304, 'Al', 'Mayo', 'amayo@smittys.com', '703-704-5555', '703-780-7800 x324', '703-906-5971', '164*21*20482', '703-530-7924', '', 'Crestwood', 'Smitty's Building Supply', '10536 Crestwood Dr. # 201', 'Manassas', 'VA', '20109', 'Sales', 65535, '', 'Don Belt', '571-220-9885', '', 0), (6305, 'Pam', 'Montano', 'pmontano@smittys.com', '703-704-5509', '703-780-7800 x302', '703-629-6857', '164*21*40214', '703-530-0090', 'VP Marketing', 'Crestwood', 'Smitty's Building Supply', '10535 Crestwood Dr. # 201', 'Manassas', 'VA', '20109', 'Marketing', 65535, '', 'Don Belt', '571-220-9885', 'Tina Ritenour', 0), (6306, 'Charlie', 'Pleasants', 'cpleasants@smittys.com', '703-704-5599', '703-780-7800 x410', '703-906-5969', '164*21*20481', '703-530-0090', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Inventory Management', 65535, '', 'Don Belt', '571-220-9885', '', 0), (6307, 'Jim', 'Reetz', 'jreetz@smittys.com', '703-704-5572', '703-780-7800 x423', '703-906-5961', '164*21*20474', '703-530-1252', '', 'Notes Whse', 'Smitty's Building Supply', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Operations', 65535, '', 'Don Belt', '571-220-9885', '', 0), (6308, 'Finley', 'Revels', 'frevels@smittys.com', '703-704-5587', '703-780-7800 x411', '703-955-9774', '165*325024*7', '703-361-2307', 'Distribution Manager', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Operations', 65535, '', 'Don Belt', '571-220-9885', '', 0), (6309, 'Tim', 'Tobin', 'ttobin@smittys.com', '703-644-4058', '703-644-4045', '703-898-3599', '164*21*39936', '703-913-9178', '', 'Millwork', 'Smitty's Millwork and Supply', '7622 Backlick Road', 'Springfield', 'VA', '22150', 'Sales', 65535, '', 'Don Belt', '571-220-9885', '', 0), (6310, 'Marty', 'Winslow', 'mwinslow@smittys.com', '703-365-9396', '', '703-929-7963', '164*21*4566', '703-365-9398', '', 'Shelter', 'Smitty's Building Supply', '7905 Notes Drive', 'Manassas', 'VA', '20109', 'Procurement', 65535, '', 'Don Belt', '571-220-9885', '', 0), (6311, 'Jim', 'Weston', 'jweston@smittys.com', '703-704-5519', '703-780-7800 x550', '', '', '703-780-7638', '', 'Alexandria', 'Smitty's Industrial Division', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Industrial', 65535, '', 'Doug Thorson', '571-221-7210', '', 0), (6312, 'Daniel', 'Herndon', '', '', '', '', '', '', '', 'Crestwood', 'Smitty's Building Supply', '10535 Crestwood Dr. # 201', 'Manassas', 'VA', '20109', 'Sales Support', 65535, '', 'Dwayne Paugh', '703-906-5975', '', 0), (6313, 'Boadi Mensah', 'Addai', '', '', '', '', '', '', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Warehouse', 65535, '', 'Eric Chaney', '703-929-4441', '', 0), (6314, 'Sylvester', 'Boateng', '', '', '', '', '', '', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Warehouse', 65535, '', 'Eric Chaney', '703-929-4442', '', 0), (6315, 'Juan Jose', 'Gomez', '', '', '', '', '', '', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Yard-Day', 65535, '', 'Eric Chaney', '703-929-4443', '', 0), (6316, 'Joel', 'Jones', '', '', '703-780-7800 x405', '571-221-8859', '164*21*18815', '', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Operations', 65535, '', 'Eric Chaney', '703-929-4444', '', 0), (6317, 'Kenneth', 'Lartey', '', '', '', '', '', '', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Warehouse', 65535, '', 'Eric Chaney', '703-929-4445', '', 0), (6318, 'Cecil', 'Shellington', '', '', '', '571-436-1885', '164*21*64067', '', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Warehouse', 65535, '', 'Eric Chaney', '703-929-4446', '', 0), (6319, 'Emmanuel', 'Antwi', '', '', '', '', '', '', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Traffic', 65535, '', 'Finley Revels', 'Ext. 411 703-704-5587', '', 0), (6320, 'Craig', 'Bronzert', 'cbronzert@smittys.com', '703-704-5581', '703-780-7800 x404', '703-926-9973', '164*21*52513', '703-530-0680', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Receiving', 65535, '', 'Finley Revels', 'Ext. 411 703-704-5587', '', 0), (6321, 'Woody', 'Broyles', '', '', '703-780-7800', '703-906-5962', '164*21*20475', '', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Driver', 65535, '', 'Finley Revels', 'Ext. 411 703-704-5587', '', 0), (6322, 'Eric', 'Chaney', 'echaney@smittys.com', '', '703-780-7800 x488', '703-929-4441', '164*1043*41', '', 'Will Call Supervisor', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Warehouse', 65535, '', 'Finley Revels', 'Ext. 411 703-704-5587', 'backup', 0), (6323, 'Nelson', 'Donham', '', '', '', '571-221-6080', '165*320025*1', '', 'Driver', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Driver', 65535, '', 'Finley Revels', 'Ext. 411 703-704-5587', '', 0), (6324, 'James', 'Ford Jr', '', '', '', '703-906-5948', '164*21*20463', '', 'Driver', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Driver', 65535, '', 'Finley Revels', 'Ext. 411 703-704-5587', '', 0), (6325, 'Bobby', 'Green', '', '', '', '703-906-5960', '164*21*20472', '', 'Driver', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Driver', 65535, '', 'Finley Revels', 'Ext. 411 703-704-5587', '', 0), (6326, 'David', 'Joines', '', '', '', '571-237-9056', '164*21*8984', '', 'Driver', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Driver', 65535, '', 'Finley Revels', 'Ext. 411 703-704-5587', '', 0), (6327, 'Charles', 'Jones', '', '', '', '571-221-9630', '164*21*3134', '', 'Driver', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Driver', 65535, '', 'Finley Revels', 'Ext. 411 703-704-5587', '', 0), (6328, 'Mario', 'Marquina', '', '', '', '703-955-9611', '165*325024*4', '', 'Driver', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Driver', 65535, '', 'Finley Revels', 'Ext. 411 703-704-5587', '', 0), (6329, 'Stoney', 'McGowan', 'stoney@smittys.com', '703-704-5544', '703-780-7800 x444', '703-906-5950', '164*21*20466', '', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Driver', 65535, '', 'Finley Revels', 'Ext. 411 703-704-5587', '', 0), (6330, 'Francisco', 'Ortega', '', '', '', '703-843-1876', '165*1043-915', '', 'Driver', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Driver', 65535, '', 'Finley Revels', 'Ext. 411 703-704-5587', '', 0), (6331, 'Wayne', 'Preston', '', '', '', '571-220-8377', '164*21*58350', '', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Driver', 65535, '', 'Finley Revels', 'Ext. 411 703-704-5587', '', 0), (6332, 'Franklin', 'Reyes', '', '', '', '571-221-9295', '164*21*1933', '', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Driver', 65535, '', 'Finley Revels', 'Ext. 411 703-704-5587', '', 0), (6333, 'Maurice', 'Robinson', '', '', '', '', '', '', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Driver', 65535, '', 'Finley Revels', 'Ext. 411 703-704-5587', '', 0), (6334, 'Marvin', 'Rodriguez', '', '', '', '', '', '', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Driver', 65535, '', 'Finley Revels', 'Ext. 411 703-704-5587', '', 0), (6335, 'Willie', 'Schisler III', 'wschisler@smittys.com', '', '703-780-7800 x432', '571-237-0885', '164*21*38448', '703-530-1252', '', 'Notes Whse', 'Smitty's Building Supply', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Operations', 65535, '', 'Finley Revels', 'Ext. 411 703-704-5587', '', 0), (6336, 'Earl', 'Skinner', '', '', '', '703-906-7731', '164*21*31748', '', 'Driver', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Driver', 65535, '', 'Finley Revels', 'Ext. 411 703-704-5587', '', 0), (6337, 'Bobby', 'Smith', 'bsmith@smittys.com', '703-704-5503', '703-780-7800 x403', '703-856-4922', '164*21*949', '703-530-0669', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Operations', 65535, '', 'Finley Revels', 'Ext. 411 703-704-5587', '', 0), (6338, 'Will', 'Stewart', 'wstewart@smittys.com', '', '703-780-7800', '571-221-9652', '164*21*42891', '703-530-0680', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Warehouse', 65535, '', 'Finley Revels', 'Ext. 411 703-704-5587', '', 0), (6339, 'Ronald', 'Van Reuth', 'rvanreuth@smittys.com', '', '703-780-7800 x444', '571-238-0668', '164*21*7571', '', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Driver', 65535, '', 'Finley Revels', 'Ext. 411 703-704-5587', '', 0), (6340, 'Bobby', 'Womack', 'bwomack@smittys.com', '703-704-5512', '703-780-7800 x457', '', '', '703-361-2307', 'Sales Coordinator', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Sales', 65535, '', 'Finley Revels', 'Ext. 411 703-704-5587', '', 0), (6341, 'James', 'Wren Jr.', '', '', '', '571-436-9878', '164*21*36400', '', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Driver', 65535, '', 'Finley Revels', 'Ext. 411 703-704-5587', '', 0), (6342, 'Trish', 'Giles', 'tgiles@smittys.com', '703-704-5505', '703-780-7800 x401', '703-906-5409', '164*21*61642', '703-361-2307', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'HR', 65535, '', 'Gary Davis', 'Ext. 554 703-704-5510', 'Wanda Kwok', 0), (6343, 'Lori', 'Kellenberger', 'lorik@smittys.com', '703-704-5579', '703-780-7800 x524', '571-237-3820', '164*24*52190', '703-780-7072', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22039', 'AP', 65535, '', 'Gary Davis', 'Ext. 554 703-704-5511', '', 0), (6344, 'Wanda', 'Kwok', 'wkwok@smittys.com', '703-704-5561', '703-780-7800 x521', '', '', '703-780-3500', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'HR', 65535, '', 'Gary Davis', 'Ext. 554 703-704-5512', 'Trish Giles', 0), (6345, 'Sheryl', 'McTighe', 'smctighe@smittys.com', '703-704-5590', '703-780-7800 x560', '571-233-4668', '164*157368*1', '703-780-7072', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Admin', 65535, '', 'Gary Davis', 'Ext. 554 703-704-5513', '', 0), (6346, 'Michele', 'McTighe', 'mmctighe@smittys.com', '703-704-5514', '703-780-7800 x321', '571-233-4670', '164*157368*2', '703-530-7924', 'Director Information Tech', 'Crestwood', 'Smitty's Building Supply', '10535 Crestwood Dr. # 201', 'Manassas', 'VA', '20109', 'IT', 65535, '', 'Gary Davis', 'Ext. 554 703-704-5514', '', 0), (6347, 'John', 'Pearce', 'jpearce@smittys.com', '703-704-5583', '703-780-7800 x495', '571-274-2394', '165*1056*136', '', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Admin', 65535, '', 'Gary Davis', 'Ext. 554 703-704-5515', '', 0), (6348, 'Steve', 'Randall', 'srandall@smittys.com', '703-704-5564', '703-780-7800 x564', '', '', '703-780-7072', 'Credit Manager', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'AR', 65535, '', 'Gary Davis', 'Ext. 554 703-704-5516', '', 0), (6349, 'Robert', 'Weghorst', 'rweghorst@smittys.com', '703-704-5589', '703-780-7800 x408', '703-926-1864', '164*21*65412', '703-361-2307', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Operations', 65535, '', 'Gary Davis', 'Ext. 554 703-704-5517', '', 0), (6350, 'Bruce', 'Bowen', 'bbowen@smittys.com', '703-506-3660', '', '703-626-9063', '', '703-506-3660', '', 'WS-Mclean', 'Smitty's Marvin Window and Door Showplace', '6832 Old Dominion Drive', 'McLean', 'VA', '22101', 'Showplace', 65535, '', 'Gary Natovitz', '571-221-6434', '', 0), (6351, 'Cheryl', 'Caldwell', 'ccaldwell@smittys.com', '703-530-7153', '703-530-7496', '571-242-6655', '', '703-530-1254', '', 'Notes Whse', 'Smitty's Marvin Window and Door Showplace', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Showplace', 65535, '', 'Gary Natovitz', '571-221-6434', '', 0), (6352, 'Kevin', 'Fish', 'kfish@smittys.com', '703-736-9600', '', '', '', '703-961-1706', 'Outside Sales', 'WS-Chantilly', 'Smitty's Windowsmith', '13890 Metrotech Drive', 'Chantilly', 'VA', '20151', 'Windowsmith', 65535, '', 'Gary Natovitz', '571-221-6434', '', 0), (6353, 'Judy', 'Held', 'jheld@smittys.com', '301-315-8104', '', '240-441-1009', '', '301-315-8104', '', 'WS-Rockville', 'Smitty's Marvin Window and Door Showplace', '1036 Rockville Pike', 'Rockville', 'MD', '20852', 'Showplace', 65535, '', 'Gary Natovitz', '571-221-6434', '', 0), (6354, 'Stephanie', 'Hinkle', 'shinkle@smittys.com', '301-315-8100', '', '', '', '301-315-8104', 'Sales Support', 'WS-Rockville', 'Windowsmith', '1036 Rockville Pike', 'Rockville', 'MD', '20852', 'Showplace', 65535, '', 'Gary Natovitz', '571-221-6434', '', 0), (6355, 'Butch', 'Jones', 'bjones@smittys.com', '703-704-5530', '703-780-7800 x426', '571-221-6424', '164*157368*5', '703-530-1254', '', 'Notes Whse', 'Windowsmith', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Windowsmith', 65535, '', 'Gary Natovitz', '571-221-6434', '', 0), (6356, 'Tracy', 'Nelson', 'tnelson@smittys.com', '', '703-530-7520', '703-403-9790', '', '703-530-1252', 'Sales Coordinator', 'Notes Whse', 'Windowsmith', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Windowsmith', 65535, '', 'Gary Natovitz', '571-221-6434', '', 0), (6357, 'Brian', 'Post', 'bpost@smittys.com', '703-560-6625', '', '703-929-4325', '164 *1043*97', '', '', 'WS-Falls Church', 'Windowsmith', '7249 Arlington Blvd. #10A', 'Falls Church', 'VA', '22042', 'Windowsmith', 65535, '', 'Gary Natovitz', '571-221-6434', '', 0), (6358, 'Michelle', 'Reynolds', 'mreynolds@smittys.com', '301-315-8104', '', '240-483-3068', '', '301-315-8104', '', 'WS-Rockville', 'Smitty's Marvin Window and Door Showplace', '1036 Rockville Pike', 'Rockville', 'MD', '20852', 'Showplace', 65535, '', 'Gary Natovitz', '571-221-6434', '', 0), (6359, 'Ryan', 'Rodgers', 'rrodgers@smittys.com', '', '', '571-2378234', '164*24*52186', '', '', '', 'Smitty's Building Supply', '', '', '', '', 'Sales', 65535, '', 'Gary Natovitz', '571-221-6434', '', 0), (6360, 'Charles', 'Solomon', '', '', '', '', '', '', '', 'WS-Rockville', 'Smitty's Marvin Window and Door Showplace', '1036 Rockville Pike', 'Rockville', 'MD', '20852', 'Windowsmith', 65535, '', 'Gary Natovitz', '571-221-6434', '', 0), (6361, 'Scott', 'Thompson', '', '', '', '', '', '', '', 'Notes Whse', 'Smitty's Building Supply', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Installation-windowsmith', 65535, '', 'Gary Natovitz', '571-221-6434', '', 0), (6362, 'Allison', 'Vickery', 'avickery@smittys.com', '', '', '', '', '703-530-1254', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Windows Scheduling', 65535, '', 'Gary Natovitz', '571-221-6434', '', 0), (6363, 'Eric', 'Addy', '', '', '', '', '', '', '', 'Notes Whse', 'Smitty's Building Supply', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Warehouse', 65535, '', 'Jacob Bigley', 'Ext. 417 571-221-6339', '', 0), (6364, 'Matt', 'Allen', '', '', '', '703-843-1877', '165*1043*138', '', '', 'Notes Whse', 'Smitty's Building Supply', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Driver', 65535, '', 'Jacob Bigley', 'Ext. 417 571-221-6339', '', 0), (6365, 'Herb', 'Allen', '', '', '', '', '', '', '', 'Notes Whse', 'Smitty's Building Supply', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Warehouse', 65535, '', 'Jacob Bigley', 'Ext. 417 571-221-6339', '', 0), (6366, 'Joseph', 'Asare', '', '', '', '', '', '', '', 'Notes Whse', 'Smitty's Building Supply', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Warehouse', 65535, '', 'Jacob Bigley', 'Ext. 417 571-221-6339', '', 0), (6367, 'Khalid', 'Baig', '', '', '', '703-928-1239', '164*24*3234', '', 'Driver', 'Notes Whse', 'Smitty's Building Supply', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Driver', 65535, '', 'Jacob Bigley', 'Ext. 417 571-221-6339', '', 0), (6368, 'Stephen', 'Boampong', '', '', '', '', '', '', '', 'Notes Whse', 'Smitty's Building Supply', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Warehouse', 65535, '', 'Jacob Bigley', 'Ext. 417 571-221-6339', '', 0), (6369, 'Edward', 'Faust', '', '', '', '', '', '', '', 'Notes Whse', 'Smitty's Building Supply', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Driver Support', 65535, '', 'Jacob Bigley', 'Ext. 417 571-221-6339', '', 0), (6370, 'Brian (Maestro)', 'Ferguson', '', '', '', '571-237-8236', '164*24*52188', '703-530-0090', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Operations', 65535, '', 'Jacob Bigley', 'Ext. 417 571-221-6339', '', 0), (6371, 'Bruce', 'Gatewood', '', '', '', '', '', '', '', 'Notes Whse', 'Smitty's Building Supply', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Warehouse', 65535, '', 'Jacob Bigley', 'Ext. 417 571-221-6339', '', 0), (6372, 'Luiz', 'Gonzalez', '', '', '', '', '', '', '', 'Notes Whse', 'Smitty's Building Supply', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Warehouse', 65535, '', 'Jacob Bigley', 'Ext. 417 571-221-6339', '', 0), (6373, 'Andrew', 'Grisham', '', '', '', '703-926-2847', '164*21*49847', '', 'Driver', 'Notes Whse', 'Smitty's Building Supply', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Driver', 65535, '', 'Jacob Bigley', 'Ext. 417 571-221-6339', '', 0), (6374, 'Jose', 'Hernandez', '', '', '703-780-7800', '571-237-2685', '164*21*55191', '', '', 'Notes Whse', 'Smitty's Building Supply', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Driver', 65535, '', 'Jacob Bigley', 'Ext. 417 571-221-6339', '', 0), (6375, 'Rafael', 'Machuca', '', '', '', '571-220-4101', '164*21*28295', '', '', 'Notes Whse', 'Smitty's Building Supply', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Driver', 65535, '', 'Jacob Bigley', 'Ext. 417 571-221-6339', '', 0), (6376, 'Jose', 'Morales', '', '', '', '571-221-7471', '', '', '', 'Notes Whse', 'Smitty's Building Supply', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Driver', 65535, '', 'Jacob Bigley', 'Ext. 417 571-221-6339', '', 0), (6377, 'Won', 'Paik', 'wpaik@smittys.com', '703-704-5567', '703-780-7800 x421', '', '', '703-530-1252', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Warehouse', 65535, '', 'Jacob Bigley', 'Ext. 417 571-221-6339', '', 0), (6378, 'James', 'Payne', '', '', '', '', '', '', '', 'Notes Whse', 'Smitty's Building Supply', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Warehouse', 65535, '', 'Jacob Bigley', 'Ext. 417 571-221-6339', '', 0), (6379, 'Kevin', 'Perry', '', '', '', '703-930-1092', '164*1043*87', '', '', 'Notes Whse', 'Smitty's Building Supply', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Driver', 65535, '', 'Jacob Bigley', 'Ext. 417 571-221-6339', '', 0), (6380, 'William', 'Proctor', '', '', '', '571-221-7471', '', '', 'Driver', 'Notes Whse', 'Smitty's Building Supply', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Driver', 65535, '', 'Jacob Bigley', 'Ext. 417 571-221-6339', '', 0), (6381, 'Jose', 'Rios', '', '', '', '', '', '', '', 'Notes Whse', 'Smitty's Building Supply', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Driver Support', 65535, '', 'Jacob Bigley', 'Ext. 417 571-221-6339', '', 0), (6382, 'George', 'Russell', '', '', '', '', '', '', '', 'Notes Whse', 'Smitty's Building Supply', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Driver Support', 65535, '', 'Jacob Bigley', 'Ext. 417 571-221-6339', '', 0), (6383, 'Zaniel', 'Scott', '', '', '703-780-7800 x419', '571-237-2363', '164*117*1293', '703-530-1252', '', 'Notes Whse', 'Smitty's Building Supply', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Operations', 65535, '', 'Jacob Bigley', 'Ext. 417 571-221-6339', '', 0), (6384, 'Kenneth', 'Wheaton', '', '', '', '', '', '', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Warehouse', 65535, '', 'Jacob Bigley', 'Ext. 417 571-221-6339', '', 0), (6385, 'John', 'Crocker', '', '', '', '571-237-1198', '164*24*52181', '', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Warehouse', 65535, '', 'James Dudley', 'Ext. 562 571-221-1914', '', 0), (6386, 'Isaac', 'Kodua', '', '', '', '', '', '', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Warehouse', 65535, '', 'James Dudley', 'Ext. 562 571-221-1914', '', 0), (6387, 'Kwasi', 'Kwakye', '', '', '', '', '', '', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Warehouse', 65535, '', 'James Dudley', 'Ext. 562 571-221-1914', '', 0), (6388, 'Charles', 'Lomax', '', '', '', '', '', '', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Warehouse', 65535, '', 'James Dudley', 'Ext. 562 571-221-1914', '', 0), (6389, 'Richard', 'Owusu', '', '', '', '571-259-3336', '165*1056*462', '', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Warehouse', 65535, '', 'James Dudley', 'Ext. 562 571-221-1914', '', 0), (6390, 'Jim', 'Pate', 'jpate@smittys.com', '703-704-5543', '703-780-7800 x543', '703-906-5968', '164*21*20480', '703-780-4867', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Receiving', 65535, '', 'James Dudley', 'Ext. 562 571-221-1914', '', 0), (6391, 'Jerry', 'Patnode', '', '', '', '703-955-9591', '165*325024*2', '', 'Driver', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Driver', 65535, '', 'James Dudley', 'Ext. 562 571-221-1914', '', 0), (6392, 'Alana', 'Schisler', 'reception@smittys.com', '', '703-780-7800 x510', '', '', '703-780-7072', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Admin', 65535, '', 'James Dudley', 'Ext. 562 571-221-1914', '', 0), (6393, 'Gene', 'Smith', '', '', '', '', '', '', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Warehouse', 65535, '', 'James Dudley', 'Ext. 562 571-221-1914', '', 0), (6394, 'Ransom', 'Washington', '', '', '', '703-928-1448', '164*24*6398', '', 'Driver', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Driver', 65535, '', 'James Dudley', 'Ext. 562 571-221-1914', '', 0), (6395, 'Randolf', 'Wilds', '', '', '', '', '', '', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Warehouse', 65535, '', 'James Dudley', 'Ext. 562 571-221-1914', '', 0), (6396, 'Robert', 'Young', '', '', '', '703-856-4923', '164*21*950', '', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Warehouse', 65535, '', 'James Dudley', 'Ext. 562 571-221-1914', '', 0), (6397, 'Gardy', 'Morales', 'gmorales@smittys.com', '703-704-5539', '703-780-7800 x319', '571-251-2973', '150*61910*2', '703-530-7924', '', 'Crestwood', 'Smitty's Building Supply', '10535 Crestwood Dr. # 201', 'Manassas', 'VA', '20109', 'EWP', 65535, '', 'Jeff Lindstrom', 'Ext. 316 703-987-1986', '', 0), (6398, 'Don', 'Belt', 'dbelt@smittys.com', '703-704-5569', '703-780-7800 x486', '571-220-9885', '164*21*23516', '703-780-7072', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Admin', 65535, '', 'Jeff Smith', '703-906-5973', '', 0), (6399, 'Gary', 'Natovitz', 'gnatovitz@smittys.com', '', '703-560-6625', '571-221-6434', '164*157368*6', '703-560-6628', '', 'WS-Falls Church', 'Windowsmith', '7249 Arlington Blvd. #10A', 'Falls Church', 'VA', '22042', 'Windowsmith', 65535, '', 'Jeff Smith', '703-906-5973', '', 0), (6400, 'Jacob', 'Bigley', 'jbigley@smittys.com', '703-704-5522', '703-780-7800 x417', '571-436-1957', '164*21*64070', '703-530-1252', '', 'Notes Whse', 'Smitty's Building Supply', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Operations', 65535, '', 'Jim Reetz', 'Ext. 423 703-906-5961', '', 0), (6401, 'Miguel', 'Calderon', '', '703-704-5551', '703-780-7800', '571-436-1892', '164*21*64068', '', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Warehouse', 65535, '', 'Jim Reetz', 'Ext. 423 703-906-5961', '', 0), (6402, 'John', 'Clark II', '', '', '', '', '', '', '', 'Notes Whse', 'Smitty's Building Supply', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'Warehouse', 65535, '', 'Jim Reetz', 'Ext. 423 703-906-5961', '', 0), (6403, 'Wilson', 'Ordonez', '', '', '703-780-7800', '703-926-3549', '164*21*60296', '703-530-1252', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Warehouse', 65535, '', 'Jim Reetz', 'Ext. 423 703-906-5961', '', 0), (6404, 'Jeff', 'Wells', 'jwells@smittys.com', '703-704-5592', '703-780-7800 x492', '703-906-5959', '164*21*20471', '703-530-1252', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Receiving', 65535, '', 'Jim Reetz', 'Ext. 423 703-906-5961', '', 0), (6405, 'JC', 'Combs', 'jcombs@smittys.com', '703-704-5542', '703-780-7800 x309', '571-237-8233', '164*24*52185', '703-530-7924', '', 'Crestwood', 'Smitty's Building Supply', '10538 Crestwood Dr. # 201', 'Manassas', 'VA', '20109', 'Sales', 65535, '', 'John Gendreau', 'Ext. 308 571-237-8231', 'Rana Shtayyeh', 0), (6406, 'Jeff', 'Lindstrom', 'jlindstrom@smittys.com', '703-704-5586', '703-780-7800 x316', '703-987-1986', '', '703-530-0090', 'EWP', 'Crestwood', 'Smitty's Building Supply', '10538 Crestwood Dr. # 201', 'Manassas', 'VA', '20109', 'Sales', 65535, '', 'John Gendreau', 'Ext. 308 571-237-8231', 'Gardy Morales', 0), (6407, 'Scott', 'Moyer', 'smoyer@smittys.com', '', '540-371-7788', '703-906-1539', '164*21*47498', '', 'Sales', 'Fredericksburg', 'Smitty's Building Supply', '325 B Wallace Street', 'Fredericksburg', 'VA', '22401', 'Sales', 65535, '', 'John Gendreau', 'Ext. 308 571-237-8231', 'Jamie Rose', 0), (6408, 'Rana', 'Shtayyeh', 'ranas@smittys.com', '703-704-5531', '703-780-7800 x330', '571-221-7660', '164*21*48818', '703-530-0090', 'Sales Coordinator', 'Crestwood', 'Smitty's Building Supply', '10538 Crestwood Dr. # 201', 'Manassas', 'VA', '20109', 'Sales Support', 65535, '', 'John Gendreau', 'Ext. 308 571-237-8231', '', 0), (6409, 'Clyde', 'Sutphin', 'csutphin@smittys.com', '703-704-5526', '703-780-7800 x311', '571-220-1783', '164*21*50501', '703-530-0090', '', 'Crestwood', 'Smitty's Building Supply', '10538 Crestwood Dr. # 201', 'Manassas', 'VA', '20109', 'Sales', 65535, '', 'John Gendreau', 'Ext. 308 571-237-8231', 'Ryan Tracy', 0), (6410, 'Ryan', 'Tracy', 'rtracy@smittys.com', '', '703-780-7800 x312', '571-4367820', '165*321066*4', '703-530-0090', '', 'Crestwood', 'Smitty's Building Supply', '10538 Crestwood Dr. # 201', 'Manassas', 'VA', '20109', 'Sales Support', 65535, '', 'John Gendreau', 'Ext. 308 571-237-8231', '', 0), (6411, 'Kenny', 'Valentine', 'kennyv@smittys.com', '', '540-371-7788', '571-220-8893', '164*21*4644', '', '', 'Fredericksburg', 'Smitty's Building Supply', '325 B Wallace Street', 'Fredericksburg', 'VA', '22401', 'Sales', 65535, '', 'John Gendreau', 'Ext. 308 571-237-8231', '', 0), (6412, 'Shelby', 'Lawhorne', 'slawhorne@smittys.com', '', '703-780-7800 x548', '', '', '703-780-7072', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'AP', 65535, '', 'Lori Kellenberger', 'Ext. 524 703-704-5579', '', 0), (6413, 'Mireille', 'Lowe', 'mlowe@smittys.com', '', '703-780-7800 x515', '', '', '703-780-7072', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'AP', 65535, '', 'Lori Kellenberger', 'Ext. 524 703-704-5579', '', 0), (6414, 'Sheryl', 'Wright', 'swright@smittys.com', '', '703-780-7800 x553', '', '', '703-780-7072', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'AP', 65535, '', 'Lori Kellenberger', 'Ext. 524 703-704-5579', '', 0), (6415, 'Dwayne', 'Paugh', 'dpaugh@smittys.com', '703-704-5557', '703-780-7800 x427', '703-906-5975', '164*21*20486', '703-530-1254', '', 'Crestwood', 'Smitty's Building Supply', '10535 Crestwood Dr. # 201', 'Manassas', 'VA', '20109', 'Sales', 65535, '', 'Lynn S. Pedrotti', '571-220-8251', '', 0), (6416, 'Kelly', 'Corron', 'kcorron@smittys.com', '703-365-9395', '', '703-675-9707', '164*21*43431', '703-365-9398', '', 'Shelter', 'Smitty's Building Supply', '7905 Notes Drive', 'Manassas', 'VA', '20109', 'Procurement', 65535, '', 'Marty Winslow', '703-929-7963', '', 0), (6417, 'Daniel', 'Lee', '', '', '', '', '', '', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Retail Sales', 65535, '', 'Michael R. Bush', 'Ext. 540', '', 0), (6418, 'Helen Evelyn', 'McGhee', '', '', '', '', '', '', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Retail Sales', 65535, '', 'Michael R. Bush', 'Ext. 540', '', 0), (6419, 'Luis', 'Parra', '', '', '', '', '', '', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Retail Sales', 65535, '', 'Michael R. Bush', 'Ext. 540', '', 0), (6420, 'Evangelina', 'Ferman', '', '', '', '', '', '', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Retail Sales', 65535, '', 'Mike Bush', 'Ext. 540', '', 0), (6421, 'Nolvia', 'Benitez', 'nbenitez@smittys.com', '703-704-5524', '703-780-7800 x551', '', '', '703-780-2066', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Sales Support', 65535, '', 'Ric Herbst', 'Ext. 522 703-704-5594', '', 0), (6422, 'Mike', 'Bush', 'mbush@smittys.com', '703-704-5540', '703-780-7800 x540', '', '', '703-780-2066', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Sales Retail Floor', 65535, '', 'Ric Herbst', 'Ext. 522 703-704-5594', '', 0), (6423, 'Julie', 'Eldridge', 'jeldridge@smittys.com', '703-704-5551', '703-780-7800 x533', '', '', '703-780-2066', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Kitchen Cabinets and Bath', 65535, '', 'Ric Herbst', 'Ext. 522 703-704-5594', '', 0), (6424, 'Tom', 'Fallon', 'tom.fallon@smittys.com', '703-704-5598', '703-780-7800 x530', '571-237-3216', '164*21*13714', '703-530-0090', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Sales', 65535, '', 'Ric Herbst', 'Ext. 522 703-704-5594', '', 0), (6425, 'Frank', 'Freitag', 'ffreitag@smittys.com', '703-704-5597', '703-780-7800 x557', '', '', '703-780-2066', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Sales', 65535, '', 'Ric Herbst', 'Ext. 522 703-704-5594', '', 0), (6426, 'Gary', 'Gordon', 'ggordon@smittys.com', '703-704-5565', '703-780-7800 x535', '', '', '703-780-2066', 'Sales', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Sales', 65535, '', 'Ric Herbst', 'Ext. 522 703-704-5594', '', 0), (6427, 'Romelia', 'Hashida', 'rhashida@smittys.com', '703-704-5563', '703-780-7800 x527', '', '', '703-780-2066', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Sales Support', 65535, '', 'Ric Herbst', 'Ext. 522 703-704-5594', '', 0), (6428, 'Gregg', 'Lindahl', 'glindahl@smittys.com', '703-704-5577', '703-780-7800 x537', '', '150*61910*4', '703-530-0090', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Sales', 65535, '', 'Ric Herbst', 'Ext. 522 703-704-5594', '', 0), (6429, 'Chris', 'Miller', 'cmiller@smittys.com', '703-704-5538', '703-780-7800 x538', '571-259-1416', '164*167376*2', '703-780-2066', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Sales', 65535, '', 'Ric Herbst', 'Ext. 522 703-704-5594', '', 0), (6430, 'Scott', 'Patton', 'spatton@smittys.com', '703-704-5513', '703-780-7800 x513', '571-221-7134', '164*21*43775', '703-780-2066', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Sales', 65535, '', 'Ric Herbst', 'Ext. 522 703-704-5594', 'Fallan Plivelich', 0), (6431, 'Mike', 'Bowen', 'mbowen@smittys.com', '703-704-5550', '703-780-7800 x327', '703-930-7409', '164*21*14415', '703-530-7924', 'Account Manager', 'Crestwood', 'Smitty's Building Supply', '10538 Crestwood Dr. # 201', 'Manassas', 'VA', '20109', 'Sales', 65535, '', 'Rich Kniatt', 'Ext. 326 703-704-5511', 'KT Thomas', 0), (6432, 'Don', 'Haines', 'dhaines@smittys.com', '703-704-5595', '703-780-7800 x325', '571-220-9530', '164*117*2026', '703-530-0090', 'Commercial Sales', 'Crestwood', 'Smitty's Building Supply', '10535 Crestwood Dr. # 201', 'Manassas', 'VA', '20109', 'Commercial Sales', 65535, '', 'Rich Kniatt', 'Ext. 326 703-704-5511', 'KT Thomas', 0), (6433, 'Karie KT', 'Thomas', 'kthomas@smittys.com', '703-704-5515', '703-780-7800 x322', '703-929-4467', '164*21*8988', '703-530-7924', 'Sales Coordinator', 'Crestwood', 'Smitty's Building Supply', '10538 Crestwood Dr. # 201', 'Manassas', 'VA', '20109', 'Commercial Sales', 65535, '', 'Rich Kniatt', 'Ext. 326 703-704-5511', '', 0), (6434, 'Mike', 'Bigley', 'mbigley@smittys.com', '703-704-5536', '703-780-7800 x484', '703-929-4941', '164*21*39899', '703-361-2307', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Sales', 65535, '', 'Richard S. Morningstar', 'Ext. 409 703-704-5547', 'Rusty Snyder', 0), (6435, 'Rusty', 'Snyder', 'rsnyder@smittys.com', '703-704-5512', '703-780-7800 x457', '571-237-8645', '164*21*31418', '703-530-0090', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Sales Support', 65535, '', 'Richard S. Morningstar', 'Ext. 409 703-704-5547', '', 0), (6436, 'Gary', 'Davis', 'gdavis@smittys.com', '703-704-5510', '703-780-7800 x554', '571-238-9421', '164*21*40535', '703-780-7072', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'CFO', 65535, '', 'Rick Smith', 'Ext. 526 703-704-5501', 'Sheryl McTighe', 0), (6437, 'Lynn', 'Pedrotti', 'lpedrotti@smittys.com', '703-704-5504', '703-780-7800 x429', '571-220-8251', '164*21*58349', '703-530-1254', '', 'Notes Whse', 'Smitty's Building Supply', '7898 Notes Drive', 'Manassas', 'VA', '20109', 'WindowSmith', 65535, '', 'Rick Smith', 'Ext. 526 703-704-5501', 'Dwayne Paugh', 0), (6438, 'Scott', 'Smith', 'ssmith@smittys.com', '703-704-5507', '703-780-7800 x518', '703-906-5972', '164*21*20483', '703-780-4867', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Admin', 65535, '', 'Rick Smith', 'Ext. 526 703-704-5501', '', 0), (6439, 'Jeff', 'Smith', 'jsmith@smittys.com', '703-365-9397', '703-369-1552', '703-906-5973', '164*21*20484', '703-365-9398', '', 'Shelter', 'Smitty's Building Supply', '7905 Notes Drive', 'Manassas', 'VA', '20109', 'Windowsmith', 65535, '', 'Rick Smith', 'Ext. 526 703-704-5501', '', 0), (6440, 'Michelle', 'Herndon', 'mherndon@smittys.com', '703-704-5528', '703-780-7800 x489', '', '', '703-361-2307', 'Procurment Admin', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Inventory Management', 65535, '', 'Robert Weghorst Jr', '703-926-1864', '', 0), (6441, 'Gordon', 'Lackey', '', '703-704-5573', '703-780-7800 x415', '571-237-4278', '164*157368*8', '703-361-2307', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Operations', 65535, '', 'Robert Weghorst Jr', '703-926-1864', '', 0), (6442, 'Karen', 'Pearson', 'kpearson@smittys.com', '', '703-780-7800 x491', '', '', '703-361-2307', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Inventory Management', 65535, '', 'Robert Weghorst Jr', '703-926-1864', '', 0), (6443, 'Greg', 'Walthall', 'gwalthall@smittys.com', '703-704-5571', '703-780-7800 x402', '703-906-5963', '164*21*20476', '703-361-2307', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Inventory Management', 65535, '', 'Robert Weghorst Jr', '703-926-1864', '', 0), (6444, 'Tim', 'Moon', 'tmoon@smittys.com', '703-778-8269', '', '', '', '', 'Sales', 'WS-Falls Church', 'Windowsmith', '7249 Arlington Blvd. #10A', 'Falls Church', 'VA', '22042', 'Windowsmith', 65535, '', 'Ryan E Rodgers', '571-237-8234', '', 0), (6445, 'William', 'Suter', 'bsuter@smittys.com', '703-736-9600', '', '', '', '703-961-1706', 'Outside Sales', 'WS-Chantilly', 'Smitty's Windowsmith', '13890 Metrotech Drive', 'Chantilly', 'VA', '20151', 'Windowsmith', 65535, '', 'Ryan E Rodgers', '571-237-8234', '', 0), (6446, 'Jamie', 'Rose', 'jrose@smittys.com', '', '540-371-7788', '571-221-9898', '164*21*23943', '', 'Sales Coordinator', 'Fredericksburg', 'Smitty's Building Supply', '325 B Wallace Street', 'Fredericksburg', 'VA', '22401', 'Sales Support', 65535, '', 'Scott Moyer', '703-906-1539', '', 0); INSERT INTO `employees` (`id`, `first_name`, `last_name`, `email`, `business_phone1`, `business_phone2`, `mobile_phone`, `radio_phone`, `fax`, `position`, `location`, `company`, `business_address`, `business_city`, `business_state`, `business_zip`, `department`, `department_number`, `notes`, `supervisor`, `supervisor_contact`, `backup`, `file_number`) VALUES (6447, 'Fallan', 'Plivelich', 'fplivelich@smittys.com', '703-704-5575', '703-780-7800 x542', '', '', '703-780-2066', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Sales Support', 65535, '', 'Scott Patton', '571-221-7134', '', 0), (6448, 'Alvin', 'Hensley', '', '', '', '571-221-8735', '164*21*47208', '', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Driver', 65535, '', 'Sheryl McTighe', 'Ext. 560 703-704-5590', '', 0), (6449, 'Billy', 'Schisler', '', '703-704-5560', '703-780-7800 x523', '571-221-9682', '164*21*53281', '703-780-4867', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Operations', 65535, '', 'Sheryl McTighe', 'Ext. 560 703-704-5590', '', 0), (6450, 'Rosalie', 'Christiansen', 'rosaliec@smittys.com', '703-704-5516', '703-780-7800 x516', '', '', '703-780-7072', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'AR', 65535, '', 'Steven Randall', 'Ext. 564 703-704-5564', '', 0), (6451, 'Lyndsey', 'Haughie', 'lhaughie@smittys.com', '', '703-780-7800 x519', '', '', '703-780-7072', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'AR', 65535, '', 'Steven Randall', 'Ext. 564 703-704-5564', '', 0), (6452, 'Barney', 'Tesoriero', 'barney@smittys.com', '703-704-5546', '703-780-7800 x546', '', '', '703-780-7072', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'AR', 0, '', 'Steven Randall', 'Ext. 564 703-704-5564', '', 0), (6453, 'Joseph', 'Agyenim', '', '', '703-644-4045', '', '', '', '', 'Millwork', 'Smitty's Millwork and Supply', '7622 Backlick Road', 'Springfield', 'VA', '22150', 'Interior Door Shop', 65535, '', 'Tim Tobin', '703-898-3599', '', 0), (6454, 'Larry', 'Burner', '', '', '703-644-4045', '', '', '', '', 'Millwork', 'Smitty's Millwork and Supply', '7622 Backlick Road', 'Springfield', 'VA', '22150', 'Millwork Production', 65535, '', 'Tim Tobin', '703-898-3599', '', 0), (6455, 'Garry', 'Burner Jr.', '', '', '', '', '', '', '', 'Millwork', 'Smitty's Millwork and Supply', '7622 Backlick Road', 'Springfield', 'VA', '22150', 'Millwork Production', 65535, '', 'Tim Tobin', '703-898-3599', '', 0), (6456, 'Garry', 'Burner Sr', '', '703-644-4078', '703-644-4045', '571-221-2530', '164*33034*1', '', '', 'Millwork', 'Smitty's Millwork and Supply', '7622 Backlick Road', 'Springfield', 'VA', '22150', 'Mill Mechanic', 65535, '', 'Tim Tobin', '703-898-3599', '', 0), (6457, 'Julio', 'Casillas', '', '', '', '', '', '', '', 'Millwork', 'Smitty's Millwork and Supply', '7622 Backlick Road', 'Springfield', 'VA', '22150', 'Interior Door Shop', 65535, '', 'Tim Tobin', '703-898-3599', '', 0), (6458, 'Ed', 'Chase', 'echase@smittys.com', '703-644-4054', '703-644-4045', '571-237-6169', '164*33034*5', '703-644-4270', '', 'Millwork', 'Smitty's Millwork and Supply', '7622 Backlick Road', 'Springfield', 'VA', '22150', 'Procurement', 65535, '', 'Tim Tobin', '703-898-3599', '', 0), (6459, 'Ivan', 'Chirinos', '', '', '', '', '', '', '', 'Millwork', 'Smitty's Millwork and Supply', '7622 Backlick Road', 'Springfield', 'VA', '22150', 'Millwork Production', 65535, '', 'Tim Tobin', '703-898-3599', '', 0), (6460, 'Mike', 'Clough', 'mclough@smittys.com', '', '', '443-415-2862', '150*61910*3', '703-644-2937', 'Outside Sales', 'Millwork', 'Smitty's Millwork and Supply', '7622 Backlick Road', 'Springfield', 'VA', '22150', 'Sales', 65535, '', 'Tim Tobin', '703-898-3599', 'Jaon Huber', 0), (6461, 'Javier', 'Cruz', '', '', '', '', '', '', '', 'Millwork', 'Smitty's Millwork and Supply', '7622 Backlick Road', 'Springfield', 'VA', '22150', 'Millwork Production', 65535, '', 'Tim Tobin', '703-898-3599', '', 0), (6462, 'Carl', 'Davis', '', '', '', '571-237-9474', '', '', 'Driver', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Driver', 65535, '', 'Tim Tobin', '703-898-3599', '', 0), (6463, 'Orlando', 'Gonzales', '', '', '', '', '', '', '', 'Millwork', 'Smitty's Millwork and Supply', '7622 Backlick Road', 'Springfield', 'VA', '22150', 'Millwork', 65535, '', 'Tim Tobin', '703-898-3599', '', 0), (6464, 'Kathy', 'Harris-Short', 'khshort@smittys.com', '703-644-2040', '703-644-4045', '703-929-1849', '164*21*45612', '703-644-2937', '', 'Millwork', 'Smitty's Millwork and Supply', '7622 Backlick Road', 'Springfield', 'VA', '22150', 'Sales Support', 65535, '', 'Tim Tobin', '703-898-3599', '', 0), (6465, 'Jason', 'Huber', 'jhuber@smittys.com', '703-644-4055', '', '571-220-2198', '', '703-644-2937', 'Sales Coordinator', 'Millwork', 'Smitty's Millwork and Supply', '7622 Backlick Road', 'Springfield', 'VA', '22150', 'Sales Support', 65535, '', 'Tim Tobin', '703-898-3599', '', 0), (6466, 'Chuck', 'Jenkins', 'cjenkins@smittys.com', '', '', '', '', '', '', 'Millwork', 'Smitty's Millwork and Supply', '7622 Backlick Road', 'Springfield', 'VA', '22150', 'Millmech/cad Drawings', 65535, '', 'Tim Tobin', '703-898-3599', '', 0), (6467, 'Garry', 'Karpowicz', '', '', '', '', '', '', '', 'Millwork', 'Smitty's Millwork and Supply', '7622 Backlick Road', 'Springfield', 'VA', '22150', 'Millwork Production', 65535, '', 'Tim Tobin', '703-898-3599', '', 0), (6468, 'Tom', 'Lane', 'tlane@smittys.com', '', '', '571-237-9678', '164*157368*4', '703-550-0669', '', 'Millwork', 'Smitty's Millwork and Supply', '7622 Backlick Road', 'Springfield', 'VA', '22150', 'Operations', 65535, '', 'Tim Tobin', '703-898-3599', '', 0), (6469, 'Freda', 'Little', 'flittle@smittys.com', '703-644-4045', '703-644-4045', '571-220-4349', '164*21*24518', '703-644-2937', '', 'Millwork', 'Smitty's Millwork and Supply', '7622 Backlick Road', 'Springfield', 'VA', '22150', 'Sales Support', 65535, '', 'Tim Tobin', '703-898-3599', '', 0), (6470, 'Publio', 'Lopez', '', '', '', '', '', '', '', 'Millwork', 'Smitty's Millwork and Supply', '7622 Backlick Road', 'Springfield', 'VA', '22150', 'Millwork Production', 65535, '', 'Tim Tobin', '703-898-3599', '', 0), (6471, 'Richard', 'Mulner', '', '', '', '', '', '', '', 'Millwork', 'Smitty's Millwork and Supply', '7622 Backlick Road', 'Springfield', 'VA', '22150', 'Millwork', 65535, '', 'Tim Tobin', '703-898-3599', '', 0), (6472, 'Jeffrey', 'Phillips', '', '', '', '', '', '', '', 'Millwork', 'Smitty's Millwork and Supply', '7622 Backlick Road', 'Springfield', 'VA', '22150', 'Millwork', 65535, '', 'Tim Tobin', '703-898-3599', '', 0), (6473, 'Kenny', 'Randall', '', '703-644-4078', '703-644-4045', '703-928-0772', '164*135103.3', '', '', 'Millwork', 'Smitty's Millwork and Supply', '7622 Backlick Road', 'Springfield', 'VA', '22150', 'Mill Mechanic', 65535, '', 'Tim Tobin', '703-898-3599', '', 0), (6474, 'Brian', 'Shoemaker', 'bshoemaker@smittys.com', '703-644-4053', '703-644-4045', '571-259-1256', '164*33034*4', '703-455-2346', '', 'Millwork', 'Smitty's Millwork and Supply', '7622 Backlick Road', 'Springfield', 'VA', '22150', 'Operations', 65535, '', 'Tim Tobin', '703-898-3599', '', 0), (6475, 'Wyatt', 'Strickland', 'wstrickland@smittys.com', '703-644-4052', '703-644-4045', '571-237-6970', '164*33034*2', '703-644-3806', '', 'Millwork', 'Smitty's Millwork and Supply', '7622 Backlick Road', 'Springfield', 'VA', '22150', 'Sales', 65535, '', 'Tim Tobin', '703-898-3599', 'Ken Carroll', 0), (6476, 'Lisa', 'Toombs', 'ltoombs@smittys.com', '703-644-4045', '', '', '', '703-913-9178', '', 'Millwork', 'Smitty's Millwork and Supply', '7622 Backlick Road', 'Springfield', 'VA', '22150', 'Admin', 65535, '', 'Tim Tobin', '703-898-3599', '', 0), (6477, 'Hoa', 'Truong', '', '', '', '', '', '', '', 'Millwork', 'Smitty's Millwork and Supply', '7622 Backlick Road', 'Springfield', 'VA', '22150', 'Interior Door Shop', 65535, '', 'Tim Tobin', '703-898-3599', '', 0), (6478, 'Jose', 'Vasquez', '', '', '', '', '', '', '', 'Millwork', 'Smitty's Millwork and Supply', '7622 Backlick Road', 'Springfield', 'VA', '22150', 'Interior Door Shop', 65535, '', 'Tim Tobin', '703-898-3599', '', 0), (6479, 'Bob', 'Weaver', 'bweaver@smittys.com', '703-644-2587', '703-644-4045', '571-237-4799', '164*33034*3', '703-644-2937', '', 'Millwork', 'Smitty's Millwork and Supply', '7622 Backlick Road', 'Springfield', 'VA', '22150', 'Sales', 65535, '', 'Tim Tobin', '703-898-3599', '', 0), (6480, 'Don', 'Windsor', '', '', '', '571-220-9969', '164*21*45516', '', '', 'Millwork', 'Smitty's Millwork and Supply', '7622 Backlick Road', 'Springfield', 'VA', '22150', 'Driver', 65535, '', 'Tim Tobin', '703-898-3599', '', 0), (6481, 'Kelvin', 'Hamlet', '', '', '703-780-7800', '571-436-2016', '164*21*64075', '', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Warehouse', 65535, '', 'William S. Stewart', '571-221-9652', '', 0), (6482, 'Thomas', 'Kelley', '', '', '', '', '', '', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Yard-Day', 65535, '', 'William S. Stewart', '571-221-9652', '', 0), (6483, 'David', 'Shellington', '', '', '', '571-259-4491', '', '', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Warehouse', 65535, '', 'William S. Stewart', '571-221-9652', '', 0), (6484, 'Ken', 'Carroll', 'kcarroll@smittys.com', '703-644-4045', '', '703-906-1632', '164*21*3683', '703-655-2937', '', 'Millwork', 'Smitty's Millwork and Supply', '7622 Backlick Road', 'Springfield', 'VA', '22150', 'Sales', 65535, '', 'Wyatt Strickland', '571-237-6970', 'Wyatt Strickland', 0), (6485, 'Ujee', 'Bishop', '', '', '', '', '', '', '', 'Millwork', 'Smitty's Millwork and Supply', '7622 Backlick Road', 'Springfield', 'VA', '22150', 'Interior Door Shop', 65535, '', '', '', '', 0), (6486, 'Edwin', 'Caballero', '', '', '', '', '', '', '', 'Millwork', 'Smitty's Millwork and Supply', '7622 Backlick Road', 'Springfield', 'VA', '22150', 'Interior Door Shop', 65535, '', '', '', '', 0), (6487, 'Marlene', 'Connors', 'mconnors@smittys.com', '301-315-8100', '', '', '', '301-315-8104', 'Sales Coordinator', 'WS-Rockville', 'Smitty's Wholesale Sales', '1036 Rockville Pike', 'Rockville', 'MD', '20852', 'Sales Support', 65535, '', '', '', '', 0), (6488, 'Blake', 'Dutton', 'bdutton@smittys.com', '301-315-8104', '', '301-370-5818', '', '301-315-8104', '', 'WS-Rockville', 'Smitty's Marvin Window and Door Showplace', '1036 Rockville Pike', 'Rockville', 'MD', '20852', 'Showplace', 65535, '', '', '', '', 0), (6489, 'David', 'Hawkins', 'dhawkins@smittys.com', '703-506-9650', '', '571-221-6261', '', '703-506-3660', 'Outside Sales', 'WS-Mclean', 'Smitty's Wholesale Sales', '6832 Old Dominion Drive', 'McLean', 'VA', '22101', 'Sales', 65535, '', '', '', '', 0), (6490, 'Dick', 'Irwin', 'dirwin@smitty.com', '', '', '571-221-7579', '164*21*20582', '703-560-6628', '', 'WS-Falls Church', 'Windowsmith', '7249 Arlington Blvd. #10A', 'Falls Church', 'VA', '22042', 'Windowsmith', 65535, '', '', '', '', 0), (6491, 'Louis', 'Leon', '', '', '', '', '', '', '', 'Millwork', 'Smitty's Millwork and Supply', '7622 Backlick Road', 'Springfield', 'VA', '22150', 'Interior Door Shop', 65535, '', '', '', '', 0), (6492, 'James', 'May', 'jmay@smittys.com', '', '703-560-6625', '', '', '703-560-6628', '', 'WS-Falls Church', 'Windowsmith', '7249 Arlington Blvd. #10A', 'Falls Church', 'VA', '22042', 'Windowsmith', 65535, '', '', '', '', 0), (6493, 'Donnie', 'Reed', '', '', '', '', '165*326735*4', '703-530-0090', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Warehouse', 65535, '', '', '', '', 0), (6494, 'Rick', 'Smith', 'rsmith@smittys.com', '703-704-5501', '703-780-7800 x526', '703-989-5310', '164*21*17033', '703-780-7072', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'President', 65535, '', '', '', '', 0), (6495, 'Industrial', '', 'industrial@smittys.com', '', '', '', '', '703-780-7638', '', 'Alexandria', 'Smitty's Industrial Division', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', 'Industrial', 0, '', '', '', '', 0), (6496, 'Contractor Sales', '', 'cs@smittys.com', '', '703-780-7800', '703-906-5947', '164*21*20461', '703-780-2006', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', '', 0, '', '', '', '', 0), (6497, 'Outside Sales', '', 'os@smittys.com', '', '703-780-7800', '', '', '703-780-4867', '', 'Alexandria', 'Smitty's Building Supply', '8457 Richmond Highway', 'Alexandria', 'VA', '22309', '', 0, '', '', '', '', 0), (6498, 'Procurement', '', 'pur@smittys.com', '', '703-780-7800', '', '', '', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', '', 0, '', '', '', '', 0), (6499, 'BFR Sales', '', 'msales@smittys.com', '', '', '', '', '703-361-2307', '', 'Balls Ford Rd', 'Smitty's Building Supply', '11801 Balls Ford Road', 'Manassas', 'VA', '20109', 'Sales', 0, '', '', '', '', 0), (6500, 'All Sales', '', 'allsales@smittys.com', '', '', '', '', '', '', '', 'Smitty's Building Supply', '', '', 'VA', '', '', 0, '', '', '', '', 0), (6501, 'Dispatch', '', 'dispatch@smittys.com', '', '703-780-7800', '', '', '', '', '', 'Smitty's Building Supply', '', '', '', '', '', 0, '', '', '', '', 0), (6502, 'Everybody', '', 'everybody@smittys.com', '', '703-780-7800', '', '', '', '', '', 'Smitty's Building Supply', '', '', '', '', '', 0, '', '', '', '', 0); -- -------------------------------------------------------- -- -- Table structure for table `marketing_calendar` -- CREATE TABLE IF NOT EXISTS `marketing_calendar` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '', `link` varchar(50) NOT NULL DEFAULT '', `notes` varchar(255) NOT NULL DEFAULT '', `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -------------------------------------------------------- -- -- Table structure for table `operations_calendar` -- CREATE TABLE IF NOT EXISTS `operations_calendar` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '', `link` varchar(50) NOT NULL DEFAULT '', `notes` varchar(255) NOT NULL DEFAULT '', `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ; -- -- Dumping data for table `operations_calendar` -- INSERT INTO `operations_calendar` (`id`, `title`, `link`, `notes`, `date`) VALUES (3, 'Friday', 'eventID=1', '', '2007-01-01 05:00:00'), (4, 'New Years Day', '', '', '2007-01-01 00:00:00'), (5, 'MLK Day', '', '', '2007-01-15 00:00:00'), (6, 'Presidents Day', '', '', '2007-02-19 00:00:00'), (7, 'Memorial Day', '', '', '2007-05-28 00:00:00'), (8, 'Independence Day', '', '', '2007-07-04 00:00:00'), (9, 'Labor Day', '', '', '2007-09-03 00:00:00'), (10, 'Columbus Day', '', '', '2007-10-08 00:00:00'), (11, 'Veterans Day', '', '', '2007-11-11 00:00:00'), (12, 'Thanksgiving', '', '', '2007-11-22 00:00:00'), (13, 'Christmas', '', '', '2007-12-25 00:00:00'), (14, 'Valentines Day', '', '', '2007-02-14 00:00:00'), (15, 'Halloween', '', '', '2007-10-31 00:00:00'), (16, 'Mother''s Day', '', '', '2007-05-13 00:00:00'), (17, 'Father''s Day', '', '', '2007-06-17 00:00:00'), (18, 'St. Patrick''s Day', '', '', '2007-03-17 00:00:00'), (19, 'Groundhog Day', '', '', '2007-02-02 00:00:00'), (20, 'Begin Daylight Saving', '', '', '2007-04-01 00:00:00'), (21, 'End Daylight Saving', '', '', '2007-10-28 00:00:00'), (22, 'New Years Eve', '', '', '2007-12-31 00:00:00'); -- -------------------------------------------------------- -- -- Table structure for table `page_content` -- CREATE TABLE IF NOT EXISTS `page_content` ( `id` int(11) NOT NULL AUTO_INCREMENT, `section_name` varchar(80) NOT NULL DEFAULT '', `content` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ; -- -- Dumping data for table `page_content` -- INSERT INTO `page_content` (`id`, `section_name`, `content`) VALUES (1, 'home content', 'Welcome\r
\r
This is Smitty''s In-House resource center. This can not be accessed from the Internet. All information contained here is to be considered Company Confidential.\r
\r
Thank you'), (3, 'sales content', 'Al is a pack rat.'), (9, 'hr content', 'This is where you can put news and information about the HR department. Users with a administrative login can also change the placeholder picture above to something else.'), (10, 'hr image', 'place holder.jpg'), (11, 'training content', 'This is where a description of / news about the training section of this website would go.\r
\r
This section (like all the others) may also have a picture uploaded to it if you wish.'), (12, 'training image', 'place holder.jpg'), (13, 'cip content', 'This is where descriptions of / news about the CIP section of this website will go.\r
\r
You can also upload a picture here if you would like.'), (14, 'cip image', ''), (2, 'employee spotlight', 'John Pearce is the BEST!'), (5, 'home image', 'place holder.jpg'), (6, 'sales image', 'place holder.jpg'), (7, 'operations content', 'This is a description of the Operations segment of this website.'), (8, 'opertations image', ''), (4, 'marketing content', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. \r
\r
Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. \r
\r
Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of "de Finibus Bonorum et Malorum" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, "Lorem ipsum dolor sit amet..", comes from a line in section 1.10.32. '), (15, 'technology image', ''), (16, 'technology content', ''), (17, 'inventory image', ''), (18, 'inventory content', 'Inventory News goes here'), (19, 'inventory image', ''), (20, 'inventory content', ''); -- -------------------------------------------------------- -- -- Table structure for table `pto_calendar` -- CREATE TABLE IF NOT EXISTS `pto_calendar` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '', `link` varchar(50) NOT NULL DEFAULT '', `notes` varchar(255) NOT NULL DEFAULT '', `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ; -- -- Dumping data for table `pto_calendar` -- INSERT INTO `pto_calendar` (`id`, `title`, `link`, `notes`, `date`) VALUES (4, 'John''s vacation', '', '', '2007-04-07 00:00:00'), (5, 'John''s vacation', '', '', '2007-04-08 00:00:00'), (6, 'John''s vacation', '', '', '2007-04-09 00:00:00'), (7, 'John''s vacation', '', '', '2007-04-10 00:00:00'), (8, 'Jason''s Vacation', '', '', '2007-08-21 00:00:00'), (9, 'Jason''s Vacation', '', '', '2007-08-22 00:00:00'), (10, 'Jason''s Vacation', '', '', '2007-08-23 00:00:00'), (11, 'Jason''s Vacation', '', '', '2007-08-24 00:00:00'), (12, 'Jason''s Vacation', '', '', '2007-08-25 00:00:00'), (13, 'Jason''s Vacation', '', '', '2007-08-26 00:00:00'), (14, 'Jason''s Vacation', '', '', '2007-08-27 00:00:00'), (15, 'Jason''s Vacation', '', '', '2007-08-28 00:00:00'), (16, 'Jason''s Vacation', '', '', '2007-08-29 00:00:00'), (17, 'Craig Bronzert - Opener', '', '', '0001-05-08 00:00:00'), (18, 'rdon', '', '', '0000-00-00 00:00:00'), (19, '00\rTom Fallon - Opener', '', '', '0000-00-00 00:00:00'), (20, 'll', '', '', '0008-09-08 00:00:00'), (21, 't Patton - Opener', '', '', '0000-00-00 00:00:00'); -- -------------------------------------------------------- -- -- Table structure for table `sales_calendar` -- CREATE TABLE IF NOT EXISTS `sales_calendar` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '', `link` varchar(50) NOT NULL DEFAULT '', `notes` varchar(255) NOT NULL DEFAULT '', `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `end_time` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ; -- -- Dumping data for table `sales_calendar` -- INSERT INTO `sales_calendar` (`id`, `title`, `link`, `notes`, `date`, `end_time`) VALUES (1, 'New Event', 'eventID=1', 'This is a note for this event', '2007-01-17 11:13:07', NULL), (2, 'Office Closed', 'eventID=2', 'no work today', '2007-01-01 06:00:00', NULL), (6, 'Sales Figures Due', 'eventID=6', '', '2007-01-26 05:00:00', NULL), (5, 'Josh''s Birthday', 'eventID=5', 'I was born a while ago', '2007-03-04 05:00:00', NULL), (7, 'Test Event', 'eventID=7', 'test', '2007-05-11 05:00:00', '2007-05-11 12:00:00'); -- -------------------------------------------------------- -- -- Table structure for table `technology_calendar` -- CREATE TABLE IF NOT EXISTS `technology_calendar` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '', `link` varchar(50) NOT NULL DEFAULT '', `notes` varchar(255) NOT NULL DEFAULT '', `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ; -- -- Dumping data for table `technology_calendar` -- INSERT INTO `technology_calendar` (`id`, `title`, `link`, `notes`, `date`) VALUES (1, 'New Years Day', '', '', '2007-01-01 00:00:00'), (2, 'MLK Day', '', '', '2007-01-15 00:00:00'), (3, 'Presidents Day', '', '', '2007-02-19 00:00:00'), (4, 'Memorial Day', '', '', '2007-05-28 00:00:00'), (5, 'Independence Day', '', '', '2007-07-04 00:00:00'), (6, 'Labor Day', '', '', '2007-09-03 00:00:00'), (7, 'Columbus Day', '', '', '2007-10-08 00:00:00'), (8, 'Veterans Day', '', '', '2007-11-11 00:00:00'), (9, 'Thanksgiving', '', '', '2007-11-22 00:00:00'), (10, 'Christmas', '', '', '2007-12-25 00:00:00'), (11, 'Valentines Day', '', '', '2007-02-14 00:00:00'), (12, 'Halloween', '', '', '2007-10-31 00:00:00'), (13, 'Mother''s Day', '', '', '2007-05-13 00:00:00'), (14, 'Father''s Day', '', '', '2007-06-17 00:00:00'), (15, 'St. Patrick''s Day', '', '', '2007-03-17 00:00:00'), (16, 'Groundhog Day', '', '', '2007-02-02 00:00:00'), (17, 'Begin Daylight Saving', '', '', '2007-04-01 00:00:00'), (18, 'End Daylight Saving', '', '', '2007-10-28 00:00:00'), (19, 'New Years Eve', '', '', '2007-12-31 00:00:00'); -- -------------------------------------------------------- -- -- Table structure for table `training_calendar` -- CREATE TABLE IF NOT EXISTS `training_calendar` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '', `link` varchar(50) NOT NULL DEFAULT '', `notes` varchar(255) NOT NULL DEFAULT '', `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ; -- -- Dumping data for table `training_calendar` -- INSERT INTO `training_calendar` (`id`, `title`, `link`, `notes`, `date`) VALUES (2, 'Company Event', 'eventID=2', 'This is the events description', '2007-01-16 15:30:00'), (5, 'Company Potluck', 'eventID=5', 'Bring food', '2007-01-19 18:00:00'), (4, 'My Birthday', 'eventID=4', 'i was born', '2007-03-04 00:00:00'), (6, 'Test Event', 'eventID=6', '', '2007-03-19 05:00:00'), (10, 'Last Date to Register', 'eventID=10', '', '2007-01-26 05:00:00'), (11, 'Work Orders Due', 'eventID=11', 'Turn in your order forms or else!', '2007-01-19 18:00:00'), (16, 'Happy Hour', 'eventID=16', 'Cheap Booze. Bring Cash.', '2007-03-08 17:00:00'), (15, 'Happy New Years!', 'eventID=15', '', '2007-01-01 00:00:00'), (17, 'Hangover', 'eventID=17', 'everyone has a headache', '2007-03-09 05:00:00'), (20, 'August Meeting', 'eventID=18', 'this is all we have to do, all August. Yes!', '2007-08-16 10:00:00'), (21, 'Sara is old', 'eventID=21', 'Sara''s Birthday', '2007-02-21 08:00:00'), (23, 'Today''s Event', 'eventID=23', 'This event happens today!', '2007-02-20 13:00:00'), (29, 'Another Event', 'eventID=29', '', '2007-02-20 05:00:00'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE IF NOT EXISTS `users` ( `id` smallint(6) NOT NULL AUTO_INCREMENT, `user_name` varchar(30) NOT NULL DEFAULT '', `password` varchar(30) NOT NULL DEFAULT '', `level` varchar(12) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `user_name`, `password`, `level`) VALUES (9, 'calendar', 'cal', 'calendar'), (10, 'hr_employee', 'catbert', 'directory'), (12, 'admin', 'tmiva', 'super'), (13, 'operations', 'password', 'operations'); /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;