# SQL Manager 2007 for MySQL 4.3.4.1
# ---------------------------------------
# Host     : localhost
# Port     : 3306
# Database : hospital




CREATE DATABASE `hospital`
    CHARACTER SET 'latin1'
    COLLATE 'latin1_swedish_ci';

USE `hospital`;

#
# Structure for the `customers` table : 
#

CREATE TABLE `customers` (
  `customerId` INTEGER(11) NOT NULL AUTO_INCREMENT,
  `customerIdentity` VARCHAR(255) COLLATE utf8_general_ci DEFAULT NULL,
  `customerName` VARCHAR(255) COLLATE utf8_general_ci DEFAULT NULL,
  `customerDateOfBirth` DATE DEFAULT NULL,
  `fileNumber` VARCHAR(255) COLLATE utf8_general_ci DEFAULT NULL,
  `address` VARCHAR(255) COLLATE utf8_general_ci DEFAULT NULL,
  `customersDistrict` VARCHAR(255) COLLATE utf8_general_ci DEFAULT NULL,
  `customersPhone` VARCHAR(255) COLLATE utf8_general_ci DEFAULT NULL,
  `customersMobile` VARCHAR(255) COLLATE utf8_general_ci DEFAULT NULL,
  `photo` VARCHAR(255) COLLATE utf8_general_ci DEFAULT NULL,
  `active` VARCHAR(10) COLLATE utf8_general_ci DEFAULT NULL,
  `activeB` VARCHAR(5) COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`customerId`)
)ENGINE=InnoDB
AUTO_INCREMENT=5 CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';

#
# Structure for the `devicecategories` table : 
#

CREATE TABLE `devicecategories` (
  `deviceCategorieId` INTEGER(11) NOT NULL AUTO_INCREMENT,
  `deviceCategorieName` VARCHAR(255) COLLATE utf8_general_ci DEFAULT NULL,
  `deviceCategorieNumber` VARCHAR(255) COLLATE utf8_general_ci DEFAULT NULL,
  `deviceCategoriePhoto` VARCHAR(255) COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`deviceCategorieId`)
)ENGINE=InnoDB
AUTO_INCREMENT=4 CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';

#
# Structure for the `device` table : 
#

CREATE TABLE `device` (
  `deviceId` INTEGER(11) NOT NULL AUTO_INCREMENT,
  `serialNumber` VARCHAR(255) COLLATE utf8_general_ci DEFAULT NULL,
  `model` VARCHAR(255) COLLATE utf8_general_ci DEFAULT NULL,
  `manufactor` VARCHAR(255) COLLATE utf8_general_ci DEFAULT NULL,
  `currentLocation` VARCHAR(255) COLLATE utf8_general_ci DEFAULT NULL,
  `availability` VARCHAR(5) COLLATE utf8_general_ci DEFAULT NULL,
  `workingHoursService` INTEGER(11) DEFAULT NULL,
  `workingMonthsService` INTEGER(11) DEFAULT NULL,
  `workingHoursTotal` INTEGER(11) DEFAULT NULL,
  `hoursToService` DECIMAL(10,2) DEFAULT NULL,
  `monthsToservice` DECIMAL(10,2) DEFAULT NULL,
  `fault` VARCHAR(5) COLLATE utf8_general_ci DEFAULT NULL,
  `purchesDate` DATE DEFAULT NULL,
  `warrantyYears` INTEGER(11) DEFAULT NULL,
  `deviceCategorieId` INTEGER(11) NOT NULL,
  `deviceCreated` DATE DEFAULT NULL,
  `supplierId` INTEGER(11) DEFAULT NULL,
  `hoursToServiceActual` DECIMAL(11,0) DEFAULT NULL,
  `monthsToServiceActual` INTEGER(11) DEFAULT NULL,
  `monthsDateReturnService` DATE DEFAULT NULL,
  `hoursDateReturnService` DATE DEFAULT NULL,
  PRIMARY KEY (`deviceId`, `deviceCategorieId`),
  KEY `fk_device_deviceCategories_idx` (`deviceCategorieId`),
  KEY `deviceId` (`deviceId`),
  KEY `supplierId` (`supplierId`),
  CONSTRAINT `device_fk` FOREIGN KEY (`deviceCategorieId`) REFERENCES `devicecategories` (`deviceCategorieId`) ON DELETE CASCADE
)ENGINE=InnoDB
AUTO_INCREMENT=70 CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';

#
# Structure for the `devicerendals` table : 
#

CREATE TABLE `devicerendals` (
  `deviceRendalsId` INTEGER(11) NOT NULL AUTO_INCREMENT,
  `deviceId` INTEGER(11) NOT NULL,
  `customerId` INTEGER(11) DEFAULT NULL,
  `number` VARCHAR(250) COLLATE utf8_general_ci DEFAULT NULL,
  `rentalDate` DATETIME DEFAULT NULL,
  `dailyWorkingHours` INTEGER(11) DEFAULT NULL,
  `deviceRendalPrice` DECIMAL(13,2) DEFAULT NULL,
  `rentalDateTo` DATE DEFAULT NULL,
  `dateReturn` DATETIME DEFAULT NULL,
  `info` TEXT COLLATE utf8_general_ci,
  `dateServiceReturn` DATE DEFAULT NULL,
  `ups` VARCHAR(5) COLLATE utf8_general_ci DEFAULT NULL,
  `upsExtendedBattery` VARCHAR(5) COLLATE utf8_general_ci DEFAULT NULL,
  `iventExtendedbattery` VARCHAR(5) COLLATE utf8_general_ci DEFAULT NULL,
  `troxilato` VARCHAR(5) COLLATE utf8_general_ci DEFAULT NULL,
  `oxiReduser` VARCHAR(5) COLLATE utf8_general_ci DEFAULT NULL,
  `carCharger` VARCHAR(5) COLLATE utf8_general_ci DEFAULT NULL,
  `cableExtention` VARCHAR(5) COLLATE utf8_general_ci DEFAULT NULL,
  `adultSensor` VARCHAR(5) COLLATE utf8_general_ci DEFAULT NULL,
  `childSensor` VARCHAR(5) COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`deviceRendalsId`, `deviceId`),
  KEY `fk_deviceRendals_device1_idx` (`deviceId`),
  KEY `deviceRendalsId` (`deviceRendalsId`),
  KEY `customerId` (`customerId`),
  CONSTRAINT `devicerendals_fk` FOREIGN KEY (`deviceId`) REFERENCES `device` (`deviceId`) ON DELETE CASCADE,
  CONSTRAINT `devicerendals_fk1` FOREIGN KEY (`customerId`) REFERENCES `customers` (`customerId`) ON DELETE CASCADE
)ENGINE=InnoDB
AUTO_INCREMENT=37 CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';

#
# Structure for the `customers_has_devicerendals` table : 
#

CREATE TABLE `customers_has_devicerendals` (
  `customerId` INTEGER(11) NOT NULL,
  `deviceRendalsId` INTEGER(11) NOT NULL,
  PRIMARY KEY (`customerId`, `deviceRendalsId`),
  KEY `fk_customers_has_deviceRendals_deviceRendals1_idx` (`deviceRendalsId`),
  KEY `fk_customers_has_deviceRendals_customers1_idx` (`customerId`),
  CONSTRAINT `customers_has_devicerendals_fk` FOREIGN KEY (`deviceRendalsId`) REFERENCES `devicerendals` (`deviceRendalsId`) ON DELETE CASCADE,
  CONSTRAINT `customers_has_devicerendals_fk1` FOREIGN KEY (`customerId`) REFERENCES `customers` (`customerId`) ON DELETE CASCADE
)ENGINE=InnoDB
CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';

#
# Structure for the `device_has_supplier` table : 
#

CREATE TABLE `device_has_supplier` (
  `deviceId` INTEGER(11) NOT NULL,
  `supplierId` INTEGER(11) NOT NULL,
  PRIMARY KEY (`deviceId`, `supplierId`),
  KEY `fk_device_has_supplier_supplier1_idx` (`supplierId`),
  KEY `fk_device_has_supplier_device1_idx` (`deviceId`)
)ENGINE=InnoDB
CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';

#
# Structure for the `devicehistory` table : 
#

CREATE TABLE `devicehistory` (
  `deviceHistoryId` INTEGER(11) NOT NULL AUTO_INCREMENT,
  `serviceDate` DATE DEFAULT NULL,
  `faultRepaired` DATE DEFAULT NULL,
  `deviceHistoryDescription` VARCHAR(500) COLLATE utf8_general_ci DEFAULT NULL,
  `deviceId` INTEGER(11) NOT NULL,
  `internal` VARCHAR(5) COLLATE utf8_general_ci DEFAULT '0',
  `flowSensors` VARCHAR(5) COLLATE utf8_general_ci DEFAULT '0',
  `o2Calibration` VARCHAR(5) COLLATE utf8_general_ci DEFAULT '0',
  `batteryClibration` VARCHAR(5) COLLATE utf8_general_ci DEFAULT '0',
  `vvtTest` VARCHAR(5) COLLATE utf8_general_ci DEFAULT '0',
  `alarmsTest` VARCHAR(5) COLLATE utf8_general_ci DEFAULT '0',
  `operationalPerformance` VARCHAR(5) COLLATE utf8_general_ci DEFAULT '0',
  `puHours` VARCHAR(200) COLLATE utf8_general_ci DEFAULT '0',
  `performance` VARCHAR(5) COLLATE utf8_general_ci DEFAULT '0',
  `o2SensorReplace` VARCHAR(5) COLLATE utf8_general_ci DEFAULT '0',
  `pneumaticUnitReplace` VARCHAR(5) COLLATE utf8_general_ci DEFAULT '0',
  `pneumaticUnitFactoryCal` VARCHAR(5) COLLATE utf8_general_ci DEFAULT '0',
  `touchScreenCalib` VARCHAR(5) COLLATE utf8_general_ci DEFAULT '0',
  `backupBatteryReplace` VARCHAR(5) COLLATE utf8_general_ci DEFAULT '0',
  `fanKitReplace` VARCHAR(5) COLLATE utf8_general_ci DEFAULT '0',
  `cpuBoardReplace` VARCHAR(5) COLLATE utf8_general_ci DEFAULT '0',
  `fullService` VARCHAR(5) COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`deviceHistoryId`, `deviceId`),
  KEY `fk_deviceHistory_device1_idx` (`deviceId`),
  KEY `deviceHistoryId` (`deviceHistoryId`),
  CONSTRAINT `devicehistory_fk` FOREIGN KEY (`deviceId`) REFERENCES `device` (`deviceId`) ON DELETE CASCADE
)ENGINE=InnoDB
AUTO_INCREMENT=101 CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';

#
# Structure for the `spareparts` table : 
#

CREATE TABLE `spareparts` (
  `sparePartsId` INTEGER(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) COLLATE utf8_general_ci DEFAULT NULL,
  `sparePartsSerial` VARCHAR(255) COLLATE utf8_general_ci DEFAULT NULL,
  `supplierId` INTEGER(11) DEFAULT NULL,
  `deviceCategorieId` INTEGER(11) DEFAULT NULL,
  `price` DECIMAL(13,2) DEFAULT NULL,
  PRIMARY KEY (`sparePartsId`)
)ENGINE=InnoDB
AUTO_INCREMENT=4 CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';

#
# Structure for the `devicehistory_has_spareparts` table : 
#

CREATE TABLE `devicehistory_has_spareparts` (
  `deviceHistoryId` INTEGER(11) NOT NULL,
  `sparePartsId` INTEGER(11) NOT NULL,
  PRIMARY KEY (`deviceHistoryId`, `sparePartsId`),
  KEY `fk_deviceHistory_has_spareParts_spareParts1_idx` (`sparePartsId`),
  KEY `fk_deviceHistory_has_spareParts_deviceHistory1_idx` (`deviceHistoryId`),
  CONSTRAINT `devicehistory_has_spareparts_fk` FOREIGN KEY (`deviceHistoryId`) REFERENCES `devicehistory` (`deviceHistoryId`) ON DELETE CASCADE,
  CONSTRAINT `devicehistory_has_spareparts_fk1` FOREIGN KEY (`sparePartsId`) REFERENCES `spareparts` (`sparePartsId`)
)ENGINE=InnoDB
CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';

#
# Structure for the `devicesgroups` table : 
#

CREATE TABLE `devicesgroups` (
  `devicesGroupsId` INTEGER(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`devicesGroupsId`)
)ENGINE=InnoDB
AUTO_INCREMENT=1 CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';

#
# Structure for the `software` table : 
#

CREATE TABLE `software` (
  `id` INTEGER(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(250) COLLATE utf8_general_ci DEFAULT NULL,
  `serial` VARCHAR(250) COLLATE utf8_general_ci DEFAULT NULL,
  `place` VARCHAR(500) COLLATE utf8_general_ci DEFAULT NULL,
  `os` VARCHAR(20) COLLATE utf8_general_ci DEFAULT NULL,
  `service` VARCHAR(20) COLLATE utf8_general_ci DEFAULT NULL,
  `office` VARCHAR(20) COLLATE utf8_general_ci DEFAULT NULL,
  `firmware` VARCHAR(20) COLLATE utf8_general_ci DEFAULT NULL,
  `type` VARCHAR(250) COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
)ENGINE=InnoDB
AUTO_INCREMENT=1 CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';

#
# Structure for the `supplier` table : 
#

CREATE TABLE `supplier` (
  `supplierId` INTEGER(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) COLLATE utf8_general_ci DEFAULT NULL,
  `address` VARCHAR(255) COLLATE utf8_general_ci DEFAULT NULL,
  `email` VARCHAR(255) COLLATE utf8_general_ci DEFAULT NULL,
  `vat` VARCHAR(255) COLLATE utf8_general_ci DEFAULT NULL,
  `phones` VARCHAR(255) COLLATE utf8_general_ci DEFAULT NULL,
  `supplierIdentity` VARCHAR(255) COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`supplierId`)
)ENGINE=InnoDB
AUTO_INCREMENT=11 CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';

#
# Structure for the `spareparts_has_supplier` table : 
#

CREATE TABLE `spareparts_has_supplier` (
  `spareParts_sparePartsId` INTEGER(11) NOT NULL,
  `supplier_supplierId` INTEGER(11) NOT NULL,
  PRIMARY KEY (`spareParts_sparePartsId`, `supplier_supplierId`),
  KEY `fk_spareParts_has_supplier_supplier1_idx` (`supplier_supplierId`),
  KEY `fk_spareParts_has_supplier_spareParts1_idx` (`spareParts_sparePartsId`),
  CONSTRAINT `fk_spareParts_has_supplier_spareParts1` FOREIGN KEY (`spareParts_sparePartsId`) REFERENCES `spareparts` (`sparePartsId`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_spareParts_has_supplier_supplier1` FOREIGN KEY (`supplier_supplierId`) REFERENCES `supplier` (`supplierId`) ON DELETE NO ACTION ON UPDATE NO ACTION
)ENGINE=InnoDB
CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';

#
# Structure for the `suppliersdivices` table : 
#

CREATE TABLE `suppliersdivices` (
  `diviceId` INTEGER(11) DEFAULT NULL,
  `supplierId` INTEGER(11) DEFAULT NULL,
  KEY `diviceId` (`diviceId`),
  KEY `supplierId` (`supplierId`)
)ENGINE=InnoDB
CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';

#
# Data for the `customers` table  (LIMIT 0,500)
#

INSERT INTO `customers` (`customerId`, `customerIdentity`, `customerName`, `customerDateOfBirth`, `fileNumber`, `address`, `customersDistrict`, `customersPhone`, `customersMobile`, `photo`, `active`, `activeB`) VALUES 
  (1,'653615671','Prassas Georgios','1976-03-02','6567626986','Renou Fragoudi 14 Flat 301 Limassol Tsirio 3080','Limassol','13144','1431244143','images/Koala.jpg','1',NULL),
  (2,'764527892','Panagios Delaportas','1977-05-07','9867256','Test','','255425','9956464','','1',NULL),
  (3,'826478','test','1976-07-07','4252545','','','','',NULL,'1',NULL),
  (4,'4525425','Ελα ρε μεγαλε',NULL,'','','','','',NULL,'0',NULL);
COMMIT;

#
# Data for the `devicecategories` table  (LIMIT 0,500)
#

INSERT INTO `devicecategories` (`deviceCategorieId`, `deviceCategorieName`, `deviceCategorieNumber`, `deviceCategoriePhoto`) VALUES 
  (1,'First','3455','images/Desert.jpg'),
  (2,'Rebreathers','124532','temp/Koala.jpg'),
  (3,'Kidney Cleaners','2232','images/Jellyfish.jpg');
COMMIT;

#
# Data for the `device` table  (LIMIT 0,500)
#

INSERT INTO `device` (`deviceId`, `serialNumber`, `model`, `manufactor`, `currentLocation`, `availability`, `workingHoursService`, `workingMonthsService`, `workingHoursTotal`, `hoursToService`, `monthsToservice`, `fault`, `purchesDate`, `warrantyYears`, `deviceCategorieId`, `deviceCreated`, `supplierId`, `hoursToServiceActual`, `monthsToServiceActual`, `monthsDateReturnService`, `hoursDateReturnService`) VALUES 
  (52,'982758274857','Ford Focus','','Panagios Delaportas','0',15000,10,0,87.28,12.50,'0',NULL,0,3,NULL,NULL,13092,38,'2015-05-01','2018-03-19'),
  (53,'436456bgcgd','Panda','','','1',10000,8,0,91.26,0.00,'0',NULL,0,1,NULL,NULL,9126,0,'2015-03-01',NULL),
  (57,'dfyg4e563','Honda','','','1',12000,10,0,97.53,32.67,'0',NULL,0,2,NULL,NULL,11704,99,'2015-07-01',NULL),
  (60,'testlong1234','Test Long','','','1',15000,9,0,32.86,0.00,'0',NULL,0,1,NULL,10,4928,0,'2015-02-01',NULL),
  (62,'647463yytye','','','','1',20000,10,0,99.42,33.33,'0',NULL,0,1,NULL,NULL,19884,101,'2015-07-03',NULL),
  (63,'hyfdghgfdh','','','Prassas Georgios','0',10000,6,0,76.33,20.99,'0',NULL,0,1,NULL,NULL,7633,38,'2015-05-01','2016-06-15'),
  (69,'ελλα ','','','Panagios Delaportas','0',0,0,0,100.00,100.00,'0',NULL,0,1,NULL,NULL,0,0,NULL,NULL);
COMMIT;

#
# Data for the `devicerendals` table  (LIMIT 0,500)
#

INSERT INTO `devicerendals` (`deviceRendalsId`, `deviceId`, `customerId`, `number`, `rentalDate`, `dailyWorkingHours`, `deviceRendalPrice`, `rentalDateTo`, `dateReturn`, `info`, `dateServiceReturn`, `ups`, `upsExtendedBattery`, `iventExtendedbattery`, `troxilato`, `oxiReduser`, `carCharger`, `cableExtention`, `adultSensor`, `childSensor`) VALUES 
  (8,53,1,'','2014-11-01 14:20:01',16,0.00,NULL,'2014-11-12 00:00:00','',NULL,'1','0','0','1','0','0','0','0','0'),
  (9,52,1,'','2014-11-01 14:24:46',16,0.00,NULL,'2014-11-12 00:00:00','36363563\n633653\n3635635\n356',NULL,'1','0','0','0','1','0','0','0','0'),
  (12,57,2,'','2014-11-10 11:26:20',18,0.00,NULL,'2014-11-20 00:00:00','234567\n3456gfghs\n6476hjjhhj',NULL,'1','0','0','0','1','0','0','0','1'),
  (15,57,1,'','2014-11-20 18:27:27',16,0.00,NULL,'2014-11-20 19:08:34','',NULL,'1','0','0','1','0','0','1','0','0'),
  (16,60,1,'','2013-02-01 00:00:00',15,0.00,NULL,'2014-11-20 19:09:56','62452568, \n876872687267, \n897658767842578, \n',NULL,'1','0','0','1','1','0','0','0','1'),
  (17,57,1,'','2014-11-20 19:08:58',16,0.00,NULL,'2014-11-21 17:40:54','',NULL,'1','0','0','1','0','0','0','1','0'),
  (18,60,1,'','2014-11-20 19:10:25',12,0.00,NULL,'2014-11-20 19:13:22','',NULL,'1','0','0','0','1','0','0','0','1'),
  (19,60,2,'','2014-11-20 19:26:54',17,0.00,NULL,'2014-11-20 19:32:33','',NULL,'1','0','0','0','1','0','0','1','0'),
  (20,60,1,'','2014-11-20 19:32:51',10,0.00,NULL,'2014-11-21 12:22:12','',NULL,'0','0','0','0','0','0','0','0','0'),
  (21,62,1,'','2014-11-16 19:33:38',16,0.00,NULL,'2014-11-21 17:24:04','',NULL,'1','0','0','0','1','0','0','1','0'),
  (22,60,1,'453656d756','2014-11-21 12:28:16',11,0.00,NULL,'2014-11-23 00:00:00','',NULL,'0','1','0','1','0','0','1','0','0'),
  (24,53,2,'','2014-11-12 12:34:16',17,0.00,NULL,'2014-11-15 00:00:00','',NULL,'1','0','1','0','0','1','0','0','0'),
  (25,53,2,'','2014-11-15 12:49:12',19,0.00,NULL,'2014-11-22 00:00:00','',NULL,'0','0','0','0','1','0','0','0','1'),
  (26,53,2,'','2014-11-22 13:37:29',18,0.00,NULL,'2014-11-23 00:00:00','',NULL,'0','0','0','0','0','0','0','0','0'),
  (27,57,1,'','2014-11-21 18:41:22',19,0.00,NULL,'2014-11-22 00:00:00','',NULL,'1','0','0','1','0','0','1','0','0'),
  (28,52,1,'','2014-11-12 13:44:46',16,0.00,NULL,'2014-11-24 00:00:00','',NULL,'1','0','0','0','0','1','0','0','1'),
  (29,62,2,'','2014-11-21 18:30:02',12,0.00,NULL,'2014-11-24 16:51:39','',NULL,'1','0','0','0','0','1','0','1','0'),
  (30,52,1,'','2014-11-24 16:42:42',13,0.00,NULL,'2014-11-24 16:48:17','',NULL,'1','0','0','0','1','0','0','1','0'),
  (31,63,1,'','2014-11-05 00:00:00',17,0.00,NULL,NULL,'',NULL,'1','0','0','1','0','0','0','0','0'),
  (34,69,2,'','2014-12-02 00:00:00',0,0.00,NULL,'2014-12-03 00:00:00','',NULL,'1','0','0','0','0','1','0','0','0'),
  (35,69,2,'','2014-12-03 00:00:00',0,0.00,NULL,NULL,'',NULL,'0','1','0','0','1','0','0','1','0'),
  (36,52,2,'','2014-12-01 00:00:00',12,0.00,NULL,NULL,'',NULL,'0','0','0','0','0','0','0','0','0');
COMMIT;

#
# Data for the `devicehistory` table  (LIMIT 0,500)
#

INSERT INTO `devicehistory` (`deviceHistoryId`, `serviceDate`, `faultRepaired`, `deviceHistoryDescription`, `deviceId`, `internal`, `flowSensors`, `o2Calibration`, `batteryClibration`, `vvtTest`, `alarmsTest`, `operationalPerformance`, `puHours`, `performance`, `o2SensorReplace`, `pneumaticUnitReplace`, `pneumaticUnitFactoryCal`, `touchScreenCalib`, `backupBatteryReplace`, `fanKitReplace`, `cpuBoardReplace`, `fullService`) VALUES 
  (78,'2014-07-01',NULL,'',53,'1','0','0','1','0','0','1','','0','0','0','0','0','0','0','0','1'),
  (79,'2014-07-01',NULL,'',52,'1','0','0','0','0','1','0','','0','0','0','0','0','0','0','0','1'),
  (86,'2014-06-01',NULL,NULL,57,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1'),
  (87,'2014-09-01',NULL,NULL,57,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',NULL),
  (93,'2012-08-01',NULL,NULL,60,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1'),
  (94,'2014-05-01',NULL,NULL,60,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',NULL),
  (97,'2014-05-01',NULL,NULL,62,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1'),
  (98,'2014-09-03',NULL,NULL,62,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',NULL),
  (99,'2014-10-02',NULL,NULL,63,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1'),
  (100,'2014-11-01',NULL,NULL,63,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',NULL);
COMMIT;

#
# Data for the `spareparts` table  (LIMIT 0,500)
#

INSERT INTO `spareparts` (`sparePartsId`, `name`, `sparePartsSerial`, `supplierId`, `deviceCategorieId`, `price`) VALUES 
  (1,'Μπρατσο','356365',NULL,1,23.00),
  (2,'Κοφτης','2355353',NULL,1,23.00),
  (3,'Τεστ','3474γθυτ43γ',NULL,2,23.00);
COMMIT;

#
# Data for the `supplier` table  (LIMIT 0,500)
#

INSERT INTO `supplier` (`supplierId`, `name`, `address`, `email`, `vat`, `phones`, `supplierIdentity`) VALUES 
  (10,'Prassas','','','23242','','245252525');
COMMIT;
COMMIT;



