Create One Application for both Desktop and Web

-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.0.45-community-nt


/*!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 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


--
-- Create schema replace_it
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ replace_it;
USE replace_it;

--
-- Table structure for table `replace_it`.`computerpart`
--

DROP TABLE IF EXISTS `computerpart`;
CREATE TABLE `computerpart` (
  `ComputerPartID` char(38) NOT NULL default '',
  `Description` varchar(500) default NULL,
  `Price` decimal(10,2) NOT NULL default '0.00',
  `Stock` int(10) unsigned NOT NULL default '0',
  `Cost` decimal(10,2) NOT NULL default '0.00',
  `PartCode` varchar(45) NOT NULL default '',
  `ComputerPartTypeID` char(38) default NULL,
  PRIMARY KEY  (`ComputerPartID`),
  KEY `FK_computerpart_1` (`ComputerPartTypeID`),
  CONSTRAINT `FK_computerpart_1` FOREIGN KEY (`ComputerPartTypeID`) REFERENCES `computerparttype` (`ComputerPartTypeID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `replace_it`.`computerpart`
--

/*!40000 ALTER TABLE `computerpart` DISABLE KEYS */;
INSERT INTO `computerpart` (`ComputerPartID`,`Description`,`Price`,`Stock`,`Cost`,`PartCode`,`ComputerPartTypeID`) VALUES 
 ('{159D04FF-579C-439B-819E-77532D42C0E0}','Keyboard','7.00',34,'5.00','KEY0125','{335E2BC2-A88F-448C-B07D-25B2CDB2AAC9}'),
 ('{1775B8DA-B2DC-428B-9425-92603220DE8C}','Keyboard advanced','5.00',558,'5.00','KEY0124','{335E2BC2-A88F-448C-B07D-25B2CDB2AAC9}'),
 ('{5B489C6E-F5BB-406D-BC70-51C7B06166A5}','Laser mouse','24.00',3,'6.00','MOU1124','{3B310F6C-F6E2-4788-87F5-B7CE9E294105}'),
 ('{5EB77892-D1FB-4529-B033-0CB4CCE5D6FE}','Optical mouse','12.00',359,'6.00','MOU3954','{3B310F6C-F6E2-4788-87F5-B7CE9E294105}'),
 ('{6494147C-6FD5-43CA-9513-5501378B0337}','15 inch LCD Monitor','54.00',0,'27.00','MON0007','{0F166885-CFB7-46D0-8403-9CAD5D3A1782}'),
 ('{9B386FA2-E4D3-4192-8455-3BC5FBF14C84}','Floppy Disk Drive','3.00',10,'2.00','FDD0003','{B6E0F35D-B76E-4FDB-BDC9-666E863CDFBB}'),
 ('{A28F8029-015D-454C-AF00-640CB6FEECFA}','52x CD ROM','23.00',10,'9.00','CDR0152','{CF25A5C1-58DE-4CA9-8E5F-576ECD9EE872}'),
 ('{A3A1D73E-CF8E-49E8-BA96-9BCC05BEB5BC}','120gb Hard Drive','60.23',50,'44.00','HDD8713','{D65A2A44-9B38-4C1A-A212-4A227DACE13E}');
INSERT INTO `computerpart` (`ComputerPartID`,`Description`,`Price`,`Stock`,`Cost`,`PartCode`,`ComputerPartTypeID`) VALUES 
 ('{A77E2EC7-7188-48AA-A0EA-E19CC634127D}','48x CD ROM','22.00',27,'4.00','CDR1152','{CF25A5C1-58DE-4CA9-8E5F-576ECD9EE872}'),
 ('{AC253161-DFE7-401B-9387-890DE5ABF4B0}','DVD Writer 28x','50.00',26,'25.00','DVD0122','{DC004E68-9702-421E-A882-CE81A866CCB2}'),
 ('{C8FD81E1-6C14-47B4-87B6-79D6D3DEEEC5}','Keyboard with USB slot','18.00',15,'10.00','KEY0195','{335E2BC2-A88F-448C-B07D-25B2CDB2AAC9}'),
 ('{CA3A56ED-DAB0-4D78-8698-AAF03D95A883}','160gb Hard Drive','53.00',15,'30.00','HDD2663','{D65A2A44-9B38-4C1A-A212-4A227DACE13E}'),
 ('{CC87DF53-1F89-4FB7-83E4-2255EAEA3CED}','DVD Roms','35.00',52,'30.00','DVD0140','{DC004E68-9702-421E-A882-CE81A866CCB2}'),
 ('{E07681CA-2292-488D-A9F1-68B4771D5C5F}','19 inch LCD Monitor','65.00',10,'35.00','MON1560','{0F166885-CFB7-46D0-8403-9CAD5D3A1782}'),
 ('{E8F8AD12-79C5-426F-9EDE-7D09E86378B7}','Black Case','11.00',30,'5.00','CAS0011','{0DBC5F38-374B-40BD-993B-03E87950F2BD}');
/*!40000 ALTER TABLE `computerpart` ENABLE KEYS */;


--
-- Table structure for table `replace_it`.`computerparttype`
--

DROP TABLE IF EXISTS `computerparttype`;
CREATE TABLE `computerparttype` (
  `ComputerPartTypeID` char(38) NOT NULL default '',
  `Name` varchar(45) NOT NULL default '',
  `Code` varchar(3) NOT NULL default '',
  PRIMARY KEY  (`ComputerPartTypeID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `replace_it`.`computerparttype`
--

/*!40000 ALTER TABLE `computerparttype` DISABLE KEYS */;
INSERT INTO `computerparttype` (`ComputerPartTypeID`,`Name`,`Code`) VALUES 
 ('{0DBC5F38-374B-40BD-993B-03E87950F2BD}','Cases','CAS'),
 ('{0F166885-CFB7-46D0-8403-9CAD5D3A1782}','Monitors','MON'),
 ('{335E2BC2-A88F-448C-B07D-25B2CDB2AAC9}','Keyboards','KEY'),
 ('{3B310F6C-F6E2-4788-87F5-B7CE9E294105}','Mouse','MOU'),
 ('{3C566777-77FE-4BF6-8AD6-B5536C337D1B}','Flash Sticks','FLA'),
 ('{B32A35F1-EC42-42B0-9A24-4C22007B3849}','lkjsdflkj','sdf'),
 ('{B6E0F35D-B76E-4FDB-BDC9-666E863CDFBB}','Floppy Disk Drives','FDD'),
 ('{CA18F733-FFAD-4875-A31A-0A83DD0CEF84}','Printer','PRN'),
 ('{CF25A5C1-58DE-4CA9-8E5F-576ECD9EE872}','CD-Roms','CDR'),
 ('{D65A2A44-9B38-4C1A-A212-4A227DACE13E}','Hard Disk Drives','HDD'),
 ('{DC004E68-9702-421E-A882-CE81A866CCB2}','DVD-Roms','DVD');
/*!40000 ALTER TABLE `computerparttype` ENABLE KEYS */;


--
-- Table structure for table `replace_it`.`customerorder`
--

DROP TABLE IF EXISTS `customerorder`;
CREATE TABLE `customerorder` (
  `CustomerOrderID` char(38) NOT NULL default '',
  `PartsOrderID` char(38) NOT NULL default '',
  `Address` varchar(200) default NULL,
  PRIMARY KEY  (`CustomerOrderID`),
  KEY `FK_customerorder_1` (`PartsOrderID`),
  CONSTRAINT `FK_customerorder_1` FOREIGN KEY (`PartsOrderID`) REFERENCES `partsorder` (`PartsOrderID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `replace_it`.`customerorder`
--

/*!40000 ALTER TABLE `customerorder` DISABLE KEYS */;
INSERT INTO `customerorder` (`CustomerOrderID`,`PartsOrderID`,`Address`) VALUES 
 ('{1F728C6E-CF1A-41CB-A21D-1D4E827CEBFC}','{1F728C6E-CF1A-41CB-A21D-1D4E827CEBFC}',NULL),
 ('{20C99292-07AC-4A38-88F1-68622F4CC01E}','{20C99292-07AC-4A38-88F1-68622F4CC01E}',NULL),
 ('{44FCEE6E-ED0C-485A-A448-B374072FCC05}','{44FCEE6E-ED0C-485A-A448-B374072FCC05}','lkj'),
 ('{780F409E-1C73-40B7-8FC0-82CF7CFE3C83}','{780F409E-1C73-40B7-8FC0-82CF7CFE3C83}',NULL),
 ('{80EDF9E5-6FE8-4D2D-8829-56D2D111806C}','{80EDF9E5-6FE8-4D2D-8829-56D2D111806C}','slkdjf'),
 ('{C69A4DFA-4CF2-4543-8006-36530A1255E8}','{C69A4DFA-4CF2-4543-8006-36530A1255E8}','lkjl'),
 ('{FB39FD73-789E-4B2F-8154-2033A0224F7E}','{FB39FD73-789E-4B2F-8154-2033A0224F7E}','slkjdflkj');
/*!40000 ALTER TABLE `customerorder` ENABLE KEYS */;


--
-- Table structure for table `replace_it`.`orderitem`
--

DROP TABLE IF EXISTS `orderitem`;
CREATE TABLE `orderitem` (
  `OrderItemID` char(38) NOT NULL default '',
  `ComputerPartID` char(38) default NULL,
  `Quantity` int(10) unsigned NOT NULL default '0',
  `PartsOrderID` char(38) NOT NULL default '',
  PRIMARY KEY  (`OrderItemID`),
  KEY `FK_customerorderitem_1` (`PartsOrderID`),
  CONSTRAINT `FK_orderitem_1` FOREIGN KEY (`PartsOrderID`) REFERENCES `partsorder` (`PartsOrderID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `replace_it`.`orderitem`
--

/*!40000 ALTER TABLE `orderitem` DISABLE KEYS */;
INSERT INTO `orderitem` (`OrderItemID`,`ComputerPartID`,`Quantity`,`PartsOrderID`) VALUES 
 ('{12A3EEA9-0CF8-459E-9198-2176CB643096}','{CA3A56ED-DAB0-4D78-8698-AAF03D95A883}',1,'{1F728C6E-CF1A-41CB-A21D-1D4E827CEBFC}'),
 ('{17EA814E-224C-44B0-94C8-51F5447EE72A}','{AC253161-DFE7-401B-9387-890DE5ABF4B0}',1,'{44FCEE6E-ED0C-485A-A448-B374072FCC05}'),
 ('{48A38574-4411-4787-870B-E86736F3B8AE}','{A77E2EC7-7188-48AA-A0EA-E19CC634127D}',15,'{D4DD5CCD-5495-4C4D-B73B-7B8DD4BD3145}'),
 ('{49020208-A764-4DF3-981C-9777A1DD2D95}','{9B386FA2-E4D3-4192-8455-3BC5FBF14C84}',1,'{1F728C6E-CF1A-41CB-A21D-1D4E827CEBFC}'),
 ('{5FEEFD79-4A8C-43FB-8E93-5CF425429EBC}','{AC253161-DFE7-401B-9387-890DE5ABF4B0}',1,'{1F728C6E-CF1A-41CB-A21D-1D4E827CEBFC}'),
 ('{7356F1B2-6435-4086-ACA1-E77FCE7D8D12}','{A28F8029-015D-454C-AF00-640CB6FEECFA}',2,'{D4DD5CCD-5495-4C4D-B73B-7B8DD4BD3145}'),
 ('{75A6D377-0737-4A76-B5DD-383421DA0214}','{5EB77892-D1FB-4529-B033-0CB4CCE5D6FE}',2,'{20C99292-07AC-4A38-88F1-68622F4CC01E}'),
 ('{7B0C8B70-FA56-44D8-9E27-1FDF354DA1A3}','{5EB77892-D1FB-4529-B033-0CB4CCE5D6FE}',355,'{D4DD5CCD-5495-4C4D-B73B-7B8DD4BD3145}'),
 ('{9E4BB71D-653B-49B2-AA4B-099534ECC4FF}','{5EB77892-D1FB-4529-B033-0CB4CCE5D6FE}',100,'{13AA8E0A-F2AD-415D-88C4-825AABE50741}');
INSERT INTO `orderitem` (`OrderItemID`,`ComputerPartID`,`Quantity`,`PartsOrderID`) VALUES 
 ('{A0BA8DAA-144F-450A-B647-544AF0A39D34}','{159D04FF-579C-439B-819E-77532D42C0E0}',2,'{1F728C6E-CF1A-41CB-A21D-1D4E827CEBFC}'),
 ('{A23304BA-4ECF-422F-98B3-E94D047EB983}','{AC253161-DFE7-401B-9387-890DE5ABF4B0}',2,'{C69A4DFA-4CF2-4543-8006-36530A1255E8}'),
 ('{A45EC0CB-EA16-42DA-A12F-E926FCD268C1}','{E8F8AD12-79C5-426F-9EDE-7D09E86378B7}',5,'{44FCEE6E-ED0C-485A-A448-B374072FCC05}'),
 ('{A85B4BF9-D4EF-470F-978A-144C4FE660DA}','{AC253161-DFE7-401B-9387-890DE5ABF4B0}',4,'{C69A4DFA-4CF2-4543-8006-36530A1255E8}'),
 ('{AC87EA03-0398-4E5A-B25E-F8EDF2FCA61E}','{9B386FA2-E4D3-4192-8455-3BC5FBF14C84}',3,'{C69A4DFA-4CF2-4543-8006-36530A1255E8}'),
 ('{AE09E577-6163-4A78-A107-402F05209D22}','{5B489C6E-F5BB-406D-BC70-51C7B06166A5}',457,'{D7395877-3AB2-4B27-BE39-A9B83D2C0C41}'),
 ('{B7C9B776-C7BC-457E-B56A-748272A06D19}','{CC87DF53-1F89-4FB7-83E4-2255EAEA3CED}',3,'{C69A4DFA-4CF2-4543-8006-36530A1255E8}'),
 ('{C7915F2C-A1F0-4471-8FA5-7106D0F0DC65}','{CC87DF53-1F89-4FB7-83E4-2255EAEA3CED}',1,'{20C99292-07AC-4A38-88F1-68622F4CC01E}'),
 ('{C8A75F6C-9FB6-46D6-A624-74DA636D7F8F}','{159D04FF-579C-439B-819E-77532D42C0E0}',2,'{780F409E-1C73-40B7-8FC0-82CF7CFE3C83}');
INSERT INTO `orderitem` (`OrderItemID`,`ComputerPartID`,`Quantity`,`PartsOrderID`) VALUES 
 ('{D08C843A-32CF-4A03-8DAA-8EE7B7846E6D}','{CC87DF53-1F89-4FB7-83E4-2255EAEA3CED}',30,'{13AA8E0A-F2AD-415D-88C4-825AABE50741}'),
 ('{DF6F24A5-DA6C-4919-B9D7-AAC2911C5DE0}','{9B386FA2-E4D3-4192-8455-3BC5FBF14C84}',1,'{1F728C6E-CF1A-41CB-A21D-1D4E827CEBFC}');
/*!40000 ALTER TABLE `orderitem` ENABLE KEYS */;


--
-- Table structure for table `replace_it`.`partsorder`
--

DROP TABLE IF EXISTS `partsorder`;
CREATE TABLE `partsorder` (
  `PartsOrderID` char(38) NOT NULL default '',
  `OrderNumber` varchar(45) NOT NULL default '',
  `Name` varchar(80) NOT NULL default '',
  `TotalCharge` decimal(12,2) NOT NULL default '0.00',
  `Delivered` tinyint(1) unsigned NOT NULL default '0',
  `OrderDate` datetime default NULL,
  PRIMARY KEY  (`PartsOrderID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `replace_it`.`partsorder`
--

/*!40000 ALTER TABLE `partsorder` DISABLE KEYS */;
INSERT INTO `partsorder` (`PartsOrderID`,`OrderNumber`,`Name`,`TotalCharge`,`Delivered`,`OrderDate`) VALUES 
 ('{13AA8E0A-F2AD-415D-88C4-825AABE50741}','9915','Emeritus Parts','234.00',0,NULL),
 ('{1F728C6E-CF1A-41CB-A21D-1D4E827CEBFC}','983','Mary Morrison','123.00',0,'2007-11-20 12:09:36'),
 ('{20C99292-07AC-4A38-88F1-68622F4CC01E}','1188','Bobby Burbels','12.00',1,'2006-11-20 12:09:39'),
 ('{44FCEE6E-ED0C-485A-A448-B374072FCC05}','11114444444444444444444444','bob','12.00',0,NULL),
 ('{780F409E-1C73-40B7-8FC0-82CF7CFE3C83}','234','Jack Johnson','23.00',1,'2007-10-20 12:09:45'),
 ('{80EDF9E5-6FE8-4D2D-8829-56D2D111806C}','dave','4333','3.00',0,NULL),
 ('{C69A4DFA-4CF2-4543-8006-36530A1255E8}','22222','sam','135.00',0,NULL),
 ('{D4DD5CCD-5495-4C4D-B73B-7B8DD4BD3145}','hh234jjk','IT source','2345.00',1,NULL),
 ('{D7395877-3AB2-4B27-BE39-A9B83D2C0C41}','XK22233442','JetSet Inc','252.00',1,NULL),
 ('{FB39FD73-789E-4B2F-8154-2033A0224F7E}','6666666','angus','3.00',0,NULL);
/*!40000 ALTER TABLE `partsorder` ENABLE KEYS */;


--
-- Table structure for table `replace_it`.`settings`
--

DROP TABLE IF EXISTS `settings`;
CREATE TABLE `settings` (
  `SettingName` varchar(50) NOT NULL default '',
  `SettingValue` varchar(1000) NOT NULL default '',
  `StartDate` datetime default NULL,
  `EndDate` datetime default NULL,
  PRIMARY KEY  (`SettingName`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `replace_it`.`settings`
--

/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
INSERT INTO `settings` (`SettingName`,`SettingValue`,`StartDate`,`EndDate`) VALUES 
 ('DATABASE_VERSION','4','2007-07-13 15:50:15',NULL);
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;


--
-- Table structure for table `replace_it`.`supplierorder`
--

DROP TABLE IF EXISTS `supplierorder`;
CREATE TABLE `supplierorder` (
  `SupplierOrderID` char(38) NOT NULL default '',
  `PartsOrderID` char(38) NOT NULL default '',
  PRIMARY KEY  (`SupplierOrderID`),
  KEY `FK_supplierorder_1` (`PartsOrderID`),
  CONSTRAINT `FK_supplierorder_1` FOREIGN KEY (`PartsOrderID`) REFERENCES `partsorder` (`PartsOrderID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `replace_it`.`supplierorder`
--

/*!40000 ALTER TABLE `supplierorder` DISABLE KEYS */;
INSERT INTO `supplierorder` (`SupplierOrderID`,`PartsOrderID`) VALUES 
 ('{13AA8E0A-F2AD-415D-88C4-825AABE50741}','{13AA8E0A-F2AD-415D-88C4-825AABE50741}'),
 ('{D4DD5CCD-5495-4C4D-B73B-7B8DD4BD3145}','{D4DD5CCD-5495-4C4D-B73B-7B8DD4BD3145}'),
 ('{D7395877-3AB2-4B27-BE39-A9B83D2C0C41}','{D7395877-3AB2-4B27-BE39-A9B83D2C0C41}');
/*!40000 ALTER TABLE `supplierorder` ENABLE KEYS */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;