VogueTexDatabase.sql

CREATE DATABASE  IF NOT EXISTS `voguetexsystemdatabase` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `voguetexsystemdatabase`;
-- MySQL dump 10.13  Distrib 5.7.9, for Win64 (x86_64)
--
-- Host: localhost    Database: voguetexsystemdatabase
-- ------------------------------------------------------
-- Server version	5.7.12-log

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `assignmachine`
--

DROP TABLE IF EXISTS `assignmachine`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `assignmachine` (
  `assetID` varchar(45) NOT NULL,
  `styleNo` int(4) NOT NULL,
  `type` varchar(45) NOT NULL,
  `factory` varchar(45) NOT NULL,
  `location` varchar(45) NOT NULL,
  PRIMARY KEY (`assetID`,`styleNo`),
  KEY `fk_StyleMachine_idx` (`styleNo`),
  CONSTRAINT `fk_AssetMachine` FOREIGN KEY (`assetID`) REFERENCES `machine` (`assetID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_StyleMachine` FOREIGN KEY (`styleNo`) REFERENCES `style` (`styleNo`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `assignmachine`
--

LOCK TABLES `assignmachine` WRITE;
/*!40000 ALTER TABLE `assignmachine` DISABLE KEYS */;
INSERT INTO `assignmachine` VALUES ('VTW-M1',3616,'Single needle','VTW','V1'),('VTW-M2',6056,'5 Thread overlock','VTW','V1');
/*!40000 ALTER TABLE `assignmachine` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `assignmaterial`
--

DROP TABLE IF EXISTS `assignmaterial`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `assignmaterial` (
  `assetID` varchar(45) NOT NULL,
  `styleNo` int(4) NOT NULL,
  `type` varchar(45) NOT NULL,
  `quantity` float NOT NULL,
  `factory` varchar(45) NOT NULL,
  `location` varchar(45) NOT NULL,
  PRIMARY KEY (`assetID`,`styleNo`),
  KEY `fk_assignMaterialStyleNo_idx` (`styleNo`),
  CONSTRAINT `fk_assignMaterialAssID` FOREIGN KEY (`assetID`) REFERENCES `material` (`assetID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_assignMaterialStyleNo` FOREIGN KEY (`styleNo`) REFERENCES `style` (`styleNo`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `assignmaterial`
--

LOCK TABLES `assignmaterial` WRITE;
/*!40000 ALTER TABLE `assignmaterial` DISABLE KEYS */;
INSERT INTO `assignmaterial` VALUES ('VTW-MA4',3616,'Nylon Fabric',2500,'VTW','V1');
/*!40000 ALTER TABLE `assignmaterial` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `assignworker`
--

DROP TABLE IF EXISTS `assignworker`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `assignworker` (
  `assetID` char(8) NOT NULL,
  `styleNo` int(4) NOT NULL,
  `type` varchar(45) NOT NULL,
  `operation` varchar(45) NOT NULL,
  `factory` varchar(45) NOT NULL,
  `location` varchar(45) NOT NULL,
  PRIMARY KEY (`assetID`,`styleNo`,`operation`),
  KEY `fk_assignWorkerStyle_idx` (`styleNo`),
  KEY `assetID_UNIQUE` (`assetID`),
  CONSTRAINT `fk_assignWorkerStyle` FOREIGN KEY (`styleNo`) REFERENCES `style` (`styleNo`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `assignworker`
--

LOCK TABLES `assignworker` WRITE;
/*!40000 ALTER TABLE `assignworker` DISABLE KEYS */;
INSERT INTO `assignworker` VALUES ('emp-0005',3616,'Worker','Tack Lable','VTW','V1');
/*!40000 ALTER TABLE `assignworker` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `attendance`
--

DROP TABLE IF EXISTS `attendance`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `attendance` (
  `EmployeeNo` char(8) NOT NULL,
  `Intime` datetime NOT NULL,
  `Offtime` datetime DEFAULT NULL,
  `Date` date NOT NULL,
  `OtHrs` int(11) DEFAULT NULL,
  PRIMARY KEY (`EmployeeNo`,`Date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `attendance`
--

LOCK TABLES `attendance` WRITE;
/*!40000 ALTER TABLE `attendance` DISABLE KEYS */;
INSERT INTO `attendance` VALUES ('Admin123','2016-09-15 12:12:42','2016-09-15 12:12:48','2016-09-15',6),('emp-0002','2016-09-14 02:20:41','2016-09-15 06:52:12','2016-09-15',5),('emp-0004','2016-09-14 05:59:23','2016-09-15 08:58:56','2016-09-15',3);
/*!40000 ALTER TABLE `attendance` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `buyer_details`
--

DROP TABLE IF EXISTS `buyer_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `buyer_details` (
  `buyer_code` int(11) NOT NULL,
  `buyer` varchar(45) NOT NULL,
  `email` varchar(45) NOT NULL,
  `dDate` varchar(50) NOT NULL,
  `delivary_mode` varchar(45) CHARACTER SET dec8 NOT NULL,
  `country` varchar(45) NOT NULL,
  PRIMARY KEY (`buyer_code`),
  UNIQUE KEY `#_UNIQUE` (`buyer_code`),
  UNIQUE KEY `E-mail_UNIQUE` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `buyer_details`
--

LOCK TABLES `buyer_details` WRITE;
/*!40000 ALTER TABLE `buyer_details` DISABLE KEYS */;
INSERT INTO `buyer_details` VALUES (1,'Eddie Bauer','Edd@gmail.com','2016-12-27','Ocean','CANADA'),(2,'Eddie Bauer','info@TM.com.hk','2012-12-30','Ocean','Japan'),(3,'M&S RO','info@NIKE.com.hk','2014-12-28','Ocean','Japan'),(4,'Jacques Vert','info@POLO.com.hk','2014-12-28','Ocean','Japan'),(5,'GW-SMS','info@PAT.com.hk','2014-12-28','Ocean','Japan'),(6,'NTS','info@VICS.com.hk','2015-12-27','Ocean','Japan'),(7,'Marks&Spencer','info@Marks.com.hk','2016-12-27','Ocean','Japan');
/*!40000 ALTER TABLE `buyer_details` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `department_info`
--

DROP TABLE IF EXISTS `department_info`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `department_info` (
  `DepartmentNo` char(6) NOT NULL,
  `DepartmentName` varchar(40) NOT NULL,
  PRIMARY KEY (`DepartmentNo`),
  UNIQUE KEY `DepartmentNo_UNIQUE` (`DepartmentNo`),
  UNIQUE KEY `DepartmentName_UNIQUE` (`DepartmentName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `department_info`
--

LOCK TABLES `department_info` WRITE;
/*!40000 ALTER TABLE `department_info` DISABLE KEYS */;
INSERT INTO `department_info` VALUES ('dep-05','Account Department'),('dep-01','Human Resource Department'),('dep-04','Maintenance Department'),('dep-02','Sales Department'),('dep-03','Style Planning Dept');
/*!40000 ALTER TABLE `department_info` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `driver`
--

DROP TABLE IF EXISTS `driver`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `driver` (
  `driver_ name` varchar(45) NOT NULL,
  `d_NIC` varchar(10) NOT NULL,
  `d_dob` varchar(15) NOT NULL,
  `d_gender` varchar(45) NOT NULL,
  `vType` varchar(45) DEFAULT NULL,
  `vNumber` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`d_NIC`),
  KEY `e_k_idx` (`d_NIC`),
  KEY `f_k_idx` (`vNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `driver`
--

LOCK TABLES `driver` WRITE;
/*!40000 ALTER TABLE `driver` DISABLE KEYS */;
INSERT INTO `driver` VALUES ('Athula Wijesundara','667519836V','23-02-1966','Male','Bus','KK-7575'),('Somapala Wijesinghe','684979214V','01-11-1968','Male',NULL,NULL),('Chandrasiri Rajapakse','887912462V','04-12-1988','Male','Bus','AB-7474'),('Kamal Perera','894216357V','14-06-1989','Male','Bus','KE-0877'),('Sunil Perera','902367892V','07-08-1990','Male','Bus','CAA-4785');
/*!40000 ALTER TABLE `driver` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `employee_info`
--

DROP TABLE IF EXISTS `employee_info`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `employee_info` (
  `FullName` varchar(100) NOT NULL,
  `EmployeeNo` char(8) NOT NULL,
  `EPFNo` int(5) NOT NULL,
  `Address` varchar(100) NOT NULL,
  `DOB` date NOT NULL,
  `NIC` char(10) NOT NULL,
  `Gender` char(6) NOT NULL,
  `MaritalStatus` char(9) DEFAULT NULL,
  `Title` char(4) NOT NULL,
  `PhoneNo` char(10) NOT NULL,
  `Email` varchar(50) DEFAULT NULL,
  `DateJoined` date NOT NULL,
  `Department` char(6) NOT NULL,
  `EmployeeType` varchar(20) NOT NULL,
  `Designation` varchar(20) DEFAULT NULL,
  `Location` char(3) DEFAULT NULL,
  `Route` char(7) DEFAULT NULL,
  `BasicSalary` double NOT NULL,
  `AccountNo` varchar(20) NOT NULL,
  `OT` char(3) NOT NULL,
  `EPF` char(3) NOT NULL,
  `ETF` char(3) NOT NULL,
  `Remarks` varchar(500) DEFAULT NULL,
  `Image` blob,
  `Status` varchar(10) NOT NULL DEFAULT 'work',
  `RetirementDate` date DEFAULT NULL,
  `password` varchar(12) NOT NULL,
  PRIMARY KEY (`EmployeeNo`),
  UNIQUE KEY `EmployeeNo_UNIQUE` (`EmployeeNo`),
  UNIQUE KEY `EPFNo_UNIQUE` (`EPFNo`),
  UNIQUE KEY `IdNo_UNIQUE` (`NIC`),
  UNIQUE KEY `PhoneNo_UNIQUE` (`PhoneNo`),
  UNIQUE KEY `AccountNo_UNIQUE` (`AccountNo`),
  UNIQUE KEY `Email_UNIQUE` (`Email`),
  KEY `fk_empDept` (`Department`),
  CONSTRAINT `fk_empDept` FOREIGN KEY (`Department`) REFERENCES `department_info` (`DepartmentNo`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `employee_info`
--

LOCK TABLES `employee_info` WRITE;
/*!40000 ALTER TABLE `employee_info` DISABLE KEYS */;
INSERT INTO `employee_info` VALUES ('Admin','Admin123',23455,'No.3,galle rd,Galle','1993-03-10','930000000V','Male','Unmarried','Mr.','0719928393','sr@gmail.com','2016-04-04','dep-03','Confirm','System Administrator','V1','Route A',45000,'9379272799','No','Yes','No','hbdbaskd',NULL,'work',NULL,'Admin123'),('A.P. Isuru Jayathilaka','emp-0001',12345,'No.223, Station Rd, Udahamulla','1994-07-22','942040660V','Male','Unmarried','Mr.','0719404659','isuruj.94@gmail.com','2014-03-12','dep-01','Confirm','Manager',NULL,NULL,450000,'12543215','No','Yes','Yes',NULL,NULL,'removed','2016-09-11','emp-0001'),('C.P. Chamara Weerasekara','emp-0002',78945,'No.215, New Kandy Rd, Malabe','1985-08-20','852040660V','Male','Married','Mr.','adsf','adsfa','0214-04-10','dep-01','Confirm','Director','V4','Route c',25000,'7841254632','Yes','Yes','No','shows enthusiasm for work place activities.',NULL,'work',NULL,'emp-0002'),('S.R Rajapakse','emp-0003',78947,'No.215, New Kandy Rd, Malabe','1993-03-10','852040677V','Male','Married','Mr.','0717313761','srrajapakse1@gmail.com','0214-04-10','dep-03','Confirm','Worker','V1','Route A',25000,'784125445','Yes','Yes','No','shows enthusiasm for work place activities.','ÿ\Øÿ\à\0JFIF\0


\0`\0`\0\0ÿ\á\0\"Exif\0\0MM\0*\0\0\0\0

\0\0\0\0
\0
\0\0\0\0\0\0ÿ\í\0¬Photoshop 3.0\08BIM\0\0\0\0\0P\0The Eventorg\0XLFyPSOqclKFKEJErD_N(\0bFBMD01000ad0030000cf1c0000c13000007b340000293800005e3f0000bd5b000004630000c8680000ab6e0000dca60000ÿ\âICC_PROFILE\0

\0\0lcms\0\0mntrRGB XYZ \Ü\0
\0\0\0)\09acspAPPL\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0ö\Ö\0
\0\0\0\0\Ó-lcms\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ndesc\0\0\0ü\0\0\0^cprt\0\0
\\\0\0\0wtpt\0\0
h\0\0\0bkpt\0\0
|\0\0\0rXYZ\0\0
\0\0\0gXYZ\0\0
¤\0\0\0bXYZ\0\0
¸\0\0\0rTRC\0\0
\Ì\0\0\0@gTRC\0\0
\Ì\0\0\0@bTRC\0\0
\Ì\0\0\0@desc\0\0\0\0\0\0\0c2\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0text\0\0\0\0FB\0\0XYZ \0\0\0\0\0\0ö\Ö\0
\0\0\0\0\Ó-XYZ \0\0\0\0\0\0\0\03\0\0¤XYZ \0\0\0\0\0\0o¢\0\08õ\0\0XYZ \0\0\0\0\0\0b™\0\0·…\0\0\ÚXYZ \0\0\0\0\0\0$ \0\0„\0\0¶\Ïcurv\0\0\0\0\0\0\0\Z\0\0\0\Ë
\Éc’kö?Q4!ñ)2;’FQw]\íkpz‰±š|¬i¿}\Ó\Ã\é0ÿÿÿ\Û\0C\0



		\n\n\r\n\n	\rÿ\Û\0C
ÿÀ\0\0¤\0¢
\"\0

ÿ\Ä\0\0\0






\0\0\0\0\0\0\0\0
	\nÿ\Ä\0µ\0
\0\0
}
\0!1AQa\"q2‘¡#B±ÁR\Ñð$3br‚	\n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹º\Â\Ã\Ä\Å\Æ\Ç\È\É\Ê\Ò\Ó\Ô\Õ\Ö\×\Ø\Ù\Ú\á\â\ã\ä\å\æ\ç\è\é\êñòóôõö÷øùúÿ\Ä\0
\0








\0\0\0\0\0\0
	\nÿ\Ä\0µ\0
\0
w\0
!1AQaq\"2B‘¡±Á	#3Rðbr\Ñ\n$4\á%ñ\Z&\'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz‚ƒ„…†‡ˆ‰Š’“”•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹º\Â\Ã\Ä\Å\Æ\Ç\È\É\Ê\Ò\Ó\Ô\Õ\Ö\×\Ø\Ù\Ú\â\ã\ä\å\æ\ç\è\é\êòóôõö÷øùúÿ\Ú\0
\0\0?\0ý\ØIšö\Ð|¥d\è:St\Í\ê\×Q\Ë1e?Út&L†V\ïÖ¬}ªVmۅp\Ç(\Ù\Î[ôq­F\Ì\Î\Ö4\é.d‘YXŒ\äTö:\åbö\Æ	«E\\œ\î½\åcó5gS!£:ž\ÒG_ö›QI¦Œ¶\×iŸ–5\ç­v“`_›AYó@\Ï\ÌÙ¦&cò\È\Çñ®\Ê|i&¢÷9§Ž\ç~ñ[\Åo,\n\Ç\å$dך|aðmÞ¯¯\Û\\Cn\Ò,qü\ÇÒ½:\â\ÚF;|Ã¥|\íûXþ֚gÁ·š\Æ\â\ãl\Ð\ÆLÁXn\Üu\æ\â¸>†`Ú©6®\ï }r¤Ú„\ê\Z\î‹\áXóª7s\"#Š#»p\Âx£öª\Óü8ñM«mmdŠ\Û\Ñý}\ï_|bÿ\0‚‘\èŸ\ÚWVöחHAKi\ÐdÁ\í\ë_0üEý¢µßˆ·7^[_B\ÓuucŸÜ€1šûLƒƒð9t:0I¾®\×c”]¯;¿Cô/öŠý¶t\ÝoÓfxg¹Ž&4(\è\Ø\ä\å5ñE\Ï\í‡gln\"\×t»Xõy˜^An|—\'¦Bñ\íÒ¼2\×T\Ö/¦™¦’\ê+€H3™=°*\Üvە°\Ì\Ó0\ÆݛÁ5÷X<\r(;7s‚µI5\îF\Èú[öKÿ\0‚ø»\àŸ\Ä]6\ã\í2I¡\Ït<\ØCE哃Ú¿k¾~\Ò~ø X\Ïi¨\Âó]F¬Puö=«ðÁ†\ÓKðº\Ú\É\Ã%\ßȾ\\Cp\'Ž=\ë\è߀¿µU·Â–m\â;‰!R;IÉ…#=oJ\ä\Î2šx¯z´—aa\å(?yŸ¶\É\æ¨a÷}MK^qû)|F\â§À_kKp\×Mqj’1\ä°\à\çÞ½5ù½H¸M\Â]MJ\ê\è( t¢  ¢Š(\0¢Š(;b\Ç\å\Í3s\ã\ïʬGugxs\Ä-øԋf§\æ­\ì+¯\Úo#+\Âûûu«²\ã4\ï²l\äŠiU„助÷4¹®.[m\rú\n¶®?:‡ib­žù©ƒdûšQ̙5ð_\í
ð\n?ˆ´G\ĽkAš\î\Î8-n;y·\ã_y™¶°ýk€ø½k5\æŸx\Æ>tù\Î:֔kʕ\åÇ¡ƒ§UŒ^\Ç\æ.‹ûxgOñZ\Éý—k!ܤ\îL\í?{­\×\ì¡\áK\rÆ£Kӛ÷c8„sW¼V’[kn°\ÆŔòTu\"˜5-IQL\Ê\Û1œgšø¹\ã\ëԬܤ\Ï\Þ#¥O\r­c‡¶ý“ü/ö©t»4“\Êq_%þ\Ö_,~ø±mm˜œ\äþElžõ÷r\ë\Ën:²žù¯Œÿ\0\à¥z~£ªI\Ò\ÙHö%8¹Q•ŒƒÞ¾Ë…ñ%‹Œe-\âl=?ª9(Ý®\Ç\Ïþ1\èºü·Ú•\Ôl¶e…’‹ÁüûûTמ —SŽ\Úy®1q2±X±\'šó»M~g\Ó>\ÎU•|¶$ó×µu_ºÆ­öm乖ù„aw7 \â¿h§G‘ûI£ñ:ؗ/\Ý\Ãsö\ëþñªI«þ\Ç\Zl\Ì۔]ϱ}
s_UWÉ¿ðG6]öFƒOž9!š\ÎþTx\Ýv²œ\çW\ÖD\×\ã™Å¾¹R\Ûs3\è0\×öQ¾ö\Õ¢Š+\Î7\n(¢€\n(¢€<N\Û>VdÀ\ÏZ»c\â\Ë@fl)\Æ	¯Í‡¿ðq_\Ã=|C³£\ë\ZK7\Ê\ìcÞ«ùWП?ୟ>\"¤+m\â›{w“IÁŒþ¢½g¬·‹<X\Ô[£\뫈W’\\\Çmen	É­\Ôd½½M\Ç\ï0ȯ#ðŸ\í\à\ÏM¶ºþŸ\"\È7.\ÙG\"»ÿ\0x\ËL\Ô\ï\"ò/m\æV9ʾk	Sq\Ó_¸\Ö5Vz +ò¯µ0α?\ëUVµ)\æ4Ë´w\ÏN\ã\Å\Z\\,Y¯ ¹qR©I»Ø¿i®l;¬£\æ\ãÒ¾ý©ÿ\0müÖ¿°õ\Énm\î.P”[³B
\î\\p?\Zôø½›\Â\×_\Ø÷Vò޸€\ã?…y~\é?´_Á[K¾ó\á\Ô%šhwIž~S\ÆE)R•ùZv=¶¥8\ÕS“\Û\æxO‰þ2\éRi\íª\Å}m5À2$Ѷ\å#\ë^m¤~\Þ~\Z¬¶ö¶\Z†¢Ð¶\Â\ë\î\Éõ¹\à_\Ø:O‡\r5›=[^¼›LÓ®X\Ç/\Ùv“\Õ<ž™5\Çx\ÃöRðÿ\0Á\íû_\Â\Ú$µ\Ô\0žVž@¡p\0μ|6SG\ÚMI\ß\æ~¯[>s£Ù®\Çm§~\Ö\Z/Œfxo4¹4\ÞÁ\È›¬x\Ã\Þ&°¸\Ó\î&·ºµ¸]¬®3Áô®\'\á\'\Ãk‘˨i\"\Ò\Ò7̱\ïfyrÀ\Æq^›}ðKºñd—\Ú]¼\ÖZ*¸û4ʀu\Ï\ã^\á\èI.k?¼ó¥ˆ­Rñ\ämwz#\àÚ£öv\Ó|ñI¥\ê^MŽ \à€D|\ÙXñ…Ž¾õô—\ìEð\n\×\à\r²\ÝxŽKXµ\Í`,ù˜l¤qŒ÷\æ½ö€ý™­¾%\Ý\èwв\Ãq¢Ì…8`~•\ÐüVð[x«Æ—Ø– H*q\Ñ\0\ë_M˜g\Õ\'‚…\Éß«<,¯!¥\Âu*%k]vG\Ø°ó^|1¾V‰wA¨Hžwy:sý+\Üûו~\Çþ	›Á?t\è®ch\î.N\ê\Ý~c‘ŸzõAÀük\ä·Õž6g(\Ë9Ck\è:Š( \à\n(¢€\n(¢€?‹}{ŋ\Øû0¹\èGZ\é¼\âT‚\êI\ZNr¤\äW©ø\ÏöDµ\Ô\ä‰lU—§ WO\à؎¤n<ߘs_¦ai\ÎK™Ÿ#R¼#¢g\á\Ú\ß\\\Ñn\Ö8<C®G\åð‚;†À¯\Ñ\ïø&—\í!ªk>
·›Xñ•ô·lͅžL²úu¯—|!ÿ\0ù\ÑQ£gŽG|÷\ï^\íð¿öN\ÂQB4ù®\í\ÕOE~+lF½cŽ¥y¿„ú\Ïöýý§5¯~αC\áŸ][kWo‰¡ ¸\äþ•\æß³\ç\ì«ûA~Ҟ¶\×\âu݌7K•Y\ä!˜uþQ§\ìó/ ·‡Vºº¼Ž<mW9+\é/7>&øO\á«}3K¼g
\ÂG$A¶­y˜\êuia¹0<ªW\ÕȚt\ÕZ—\Ä7o#\Å\åýŸ¾5ü#ñ\\z}\ç\ï\ïZ̎@\Ê߁õ·ƒ>2\ê\Þ
øqq\â\ã›T«\Ê€\âª\Åi}\â=Cíº”‹4\ÌA\'h¡\ãÿ\0G\âÿ\0†º–•¯qnûq†\ä+\Æ\Í*\âqe\n–R]V‡\Òpý*41‘”\î\ãٍ\×þ-藿\r\íþ\Ý-«CyjiX~\ìn9üñ_0xÿ\0Œøk\Äñiþ¼µÕ¼3\"\ï¸ÛÝ“œ^o§h¾+ñ\Â\ÝF\ÇT\Õ5&²¸}?\ÊU‡iÀ#Ž£©¯6¶ øK\à‹øWV¸¼º†f\ÙÖq\éšù`¹š©\ïzŸ¶\à+B’MR|ºùŸc|1ñŸ‡c³\Â[\0\ìIR]-ψ!¼,aV28ú\×\ȳ\Ä=w\Å\×\rF²´l6Œu¯|—\Æ?ل+IŒ€Eq\Ñ\Â:u¹»GN+\n‘ö±VñKⅿ…/a·i}&Punk\Ú?g/\Ýøó\ì—zŠ\Ù\Éý \ÂH\äK*ú\ê+\ä_‰~2´Ôµ‰/¯!\å·_ú
_D|ø«ªhß³÷ˆôݱ\êV62\ÜÙ«r7*’?•}…\\¹N„Vχ\Äcª\Òsp\íøxiv¥XCn§+\n…ø«#­|\ïû\'~֗?|9£¦´akBu•F\ÝďO­}rïn}\ë\Í\Æ`\êaª{:‹S\åi֍U̇”f\n\\\×)£\n)3Jhó\0¢Š(ºð\Ã_­\Çþ‹3\ÜW¨xW\ánŸ,qþ\æ>qü5\ì–4ˆ\ÑH¶Uc\Ðt5\Ôi?ô\Ûh”ˆú•úö…ôG\Ìÿ\0g´\Î\Â\ß	4\âіO\á^™áŸƒ–;¢ý\Êõô­\rN±\Ò\î²t<W xzûOH\ã\0.\ï­cSú\\¸\àõÔ¯\á߅v0,¹Q·ž•\ÔYxJ\ÖԅŽöÀ«¶ZŜ8\Ë\Û\ìk¢\Òu}%•ŒQ±þó\×«K½Î…‡Kc\Z\Ç\Â?l+û°‹\Ó\ë]Ÿð\ê²²³m\Ü1\Ïôª¾3ø­¥ø\ÒòV\è¾a±\åŒ÷¯ý¨i\rB\â\çNo\ß}—쮆H\Î.Aa\ÆG#\ÖQ§^¿º•—™µ<:N\åK\Ï]k^ñ…¿‡¾\Ã\rþ“¨\Ë\æ­\È\ÌL\à	㜌W\Ïúo†5\ë\Ù$mV\×J[¶\äF»s\Ôf¼\×ö»ý¬|sðW\ãV·¥hw‘\Ãk­L<ø\åbw9\ã?\çÒ¾nøûs|Pð7‰\æ\Ònô\É-n£;LÏ»aø‡N+‹0\á¼O2ö6Qz\Þ\ç\è™S£Eýbí¯™öþ£\á\ë\Ü\ÆX efŒm\Î+‡ñ\Ç\Ç\Ý\Ò\Í\Æ\É.n°B7Nk\å\'ö¦ñ‹¥o\í\ßC“ò\ÇG\å?^sShQjŸu3\r\Äϴ˃ӹ\\P|ø™^\Ç}\\\âXˆÚ„w\èz_ƒnõ/>3û#¶­\"£\í?(^§šû&\Ç\Ä\Ö\ß\rþ6_°\Úژü²2®¸Á\ÏÖ¼w\à—\Ã\Û?‡ú>Z†¸\0y’\Ë\Z\Íø\ãñI£‚\â\ÎW\Ê`\Çw^+z˜\Å^²Œ‰\èe±r7Sv?\á\×\íFº.»m\ršýŒirmGˆT1 ô¯·ü/ÿ\0\"µ¾ñm¾Œt¿µ7Ù¢y^)Õ³t\íÞ¿üñ+\Å\r5\íú\Å4ò3(߀£\'^\Ñû&üB¾\ÒtkWo%õ\ä¤G+7£;q_£f%MÊ¢\Õ$~IG(֔v~\Ø|9ø¯o\ãÉ®-ü¿³\Þ\Û\à¼e²6·!­OxûOð]ª\Íy6\Ð\ßuG\Þü«ò3\à?ü+Zø[s©\Ù\ë¯u-˜¯#m³*v“\ß\ë\Ößµ\å¿\Æûxõ=Jòxm@e”gא+\ãjp¼£Z÷÷OZž%µn§\èDŽüw§ø\Æ\Ð\Ég6ÿ\0Ua‚+`±V¯\Ìø?j=C@h²¼–W)„“hlt&»oÁE|Ie­\ÍÕ½\Ó/¼\Çó®Z\Ü1Y;Ò±¤k1÷\è<Q_\Z\Åÿ\05¼h”¶Ÿkœ\à\Ñ\\\êþ3²+\Û\Äø\ßþ-û@ø›ödø:u\Ï\Ý-\êK\î+¸`œ\Z\Êÿ\0‚\'~מ*ý¯´[‰<eq\r\Äöòº.\Õ\Ú\Çó¬Oø8$o\Ùjc\'¬\Ч©ù«\Í\à\Û\çFžügþZ\Èzû-a\Z“X7+\ër©òºÜ¨õ\ïø)?ü\IJ/\í\'\áÿ\0\r\è\Ú}­ÖŸ«\ÝC!ÁP\çöÖ¥s%\ÂM/Vµ„\ÉwyNQFyl~Uÿ\0Áy\"\ßû\\x%¡V•Ž©h¡Uw3|\ç¥~™x‡\â\êø7\ᑦ¬‘[\ê1\é\Ñn,~d;
\Æ=k«F¶#’7\Þ\ìs•:r”^·\Û\æ\\Ò¾$4\ÉóI\n\ÜF¹ki>÷\çŸ\éX>(ý¤-\ì\çû<\Ñ\ÇGHI:W\É~:ý¥$:l—P\ÞGý ¬Àɟ˜žzגø‡öŽ¾ñ5\ä\Í4Š³H¡r¦¾¯\êô ¬\è\àý\ã\ë\æýª¦º\Õ\î,uWK›Ea\äÍ¿\r·ß±\Åh\Þ\ÿm5öŸ©y\ÑȹX÷e¯ˆ´Ÿ\Z\\][\Ü	ye#q\ê8­?|a\Ô<$‘\É̛GQ¿Ò´R¶\Çw\Ôv±\ÜÁP¼/a\à\ÝO\Ã÷šµ\è†ûT\Ò\ã¹\çb:“\ï\Åx~5[ø\ÃD\Òu¨%32\Û-´\å°\âFA·\'\ëÖ«þ\×5/ŽSEý¥ª\Íqm¥\Æcµ…\ÎD`œœw\ë_1\\\é·Zi\Û\É\ägvÀÿ\0.~•\Ýõ\n°Ñ…f›^v·‘\çS̱X<\\\åAY=,õ¹õÿ\è¾+\Ôb·º±\Ò\Úgpš5Sù\×Ô¾ðY±±…\ím\ã\ìZü°›PÔ¬J\Éò6\̍\Û\èz\×\Ò³ü\'^øi¦Vµk=„\Â\Ò\ä\Ɂ»\Ó8¯Ž\Î8s\×6W]™ö9/a¤ùq\Ð\å}\Ñõ\Ç?ŽQü\Ð%’ò\éV_,´q\nϏA_xóö—\Õ|q}4÷³Iol\ÇýDo\Ë\Ó&¸‹?u¯Œ\Þ1º\Öu+¯6iœ\ìü.xE€VŽ›ö‰w0,ô<\çñ¯§\È8zjQž\'ޝ¾\ã\åø‹‰ª\ã*J{\Ʋ¶\ï͚¾»¸¶¾{ c.re\Û=3\Ð㸯¢<\ã¹,þ\íÿ\0w˜#׎µó\ç’cڈ¿3| \nõ½Ó¼3co! \Æ<\Ç\Ï&¾¶u\ÌùZT\ê9+lH¿ù][\n\Þt@>{šÀðϏ5†º“O¦\ÌV9~üg•a\î*ޑ©R\rŠ­4Š8Ø¥¹ª:w‚<G\â+\Ù#µ\Ðu+ˆ÷cx…¶©ú\â¼Z؊pþ$’>“—׫¥9?$ή\ç㜺µ¬ù~`\Þцû­\\\Ô\î™\æ\Ýr\Ë\rª™\\oÁ8\íV¼û\"ø\ËXñ\r\â\Ý[ɦð²–Á\Ï\ášð‹q\Í\à¦62Mº\î\âv[ž@S¿Î§Š\Âכ…ó5½3l§€§\n˜ºn–\×\êzt¿µg\'‘¤„²\Â\ä´k“žƒò¢¼ž-dˆ—ý0¯Œô¢½-;µ]\Ï\ÑOø8_Áÿ\0eû\Û\á¿m¼\Ðóž3º¼\'þ\r¿\Õc\ÄZ…»¶ù8\'\Ùk\Íÿ\0\à§ðYöÀø\'s\á})f\ÝxSw™\Üm9\ë^•ÿ\0/ýœ|kð\ç\á\í\Ç\Å-RA£ø_R‚a¦–!f¹~ŠÁOð–­~I‡ÀÔ©†t³³šœ*sÀû£öŸýŸ¼Ÿ#ø“\âuMkH;´\Ønb¶q$+܎qšø\×\ãG\íE}\âO\Ï·#JWpnÕ·ñ›ö´ã†·\á\Û\Íi´\ßD\íG;a¹\ÇLv\ä~µò?|7\âm\Å-¡Š\âP»Áܧ\'\0\æ¾\χ†\n‡*Z\ÛVva麵9\ß}\ß\Þk‰®=\Âù…YX\篽b¤[oq¹Ž1“^\Ñ\àOø\'ž¥9µ¸\Ô5GH¥Œ;yr|\Üó\é^\ï\à¿\Ø#Á6\Ð\Æןl½“qyH\Ï\åŠùŠ¼Mƒ][g\ê\Ô|;\Í\å“\î|¯\áq‹W\ÌÊ°\êz֔^i\ìUm\ãšL\ç$)nk\îÿ\0\nþ\Ë>ðôj-ü?o&\ßù\ëû\Ìþf»­\'\áރ Û…³\Ñôûu^w\nŠ\æ©\ÅTš´ þgDx´_\ï*%\è™ùS\â_ُ\Ä#¸i,ôû¹|Á\ÆPŠÊ²ý‚üg¨¿™un\Öqû€xü\ëõ—[Ó­\ÑK$1(\Ù\æ~.µŽ\æVU\ë\è+\Ê\Äñf&~\É#\ë²_òªó_Z“g\ç݇ü\Þ{vݨkR*ÿ\0v4
\ãG\ì\Ùû0\é>(>.–ûΑt½A¬­¥þ!·©?}s\ãKO\ì\ÛY[™®$R‘3`þU\ìoû%ø»\Ưµ]7E’{}[W¼‘\ßpRYe(r	\ÏðŠ\æ\Ãñ6eZ%\Î省øŸQ™p	\à+\áH\ÅA¹ss5®š\Z\ßðOo\\[F\Ð_jЫ.v«®?•:\×þ	Ý£8U¶\Ö5ÿ\0\Þ óùW\Ùz\'\ì}ñ\Z\Âö\Þ9<>þNќºñú\Ò\ëÿ\0³\ïŒ<\'ª*\ã\Ì<€\0aJ9þqw9¸o€\ë\ɝ:W\è\ÓKõ>uøAÿ\0\åðþ\âKmCTººÔ£·8‰ð\ãœjú:_þÕ¬\ÂI\áý%\Öµ\Ù\Ç\Ýøöhøƒ\â(¢k›lcb?Ö°z×£\è?²½m+$—\Öj\Ìzoÿ\0\ëT\Ô\Çf8§\í*\Ê^Z\Øùš“\á\\¦2¡E\Ó×¢³üOŸ´_\0h>‘†Ÿ¤\é\Ö}ó#-ø\Óõ‰\Ö\Îmª5“°\ìM¯m	$¿²Ž\ß=UùþU\Ð/\ì]¡¨G\Ô//&pB8\Ûü«–X<Ugi6ü\Û:\éñ·`\Ôe	\'¦\ÑKþ
ñ§‰µF¶Ô„\ÂM²BwŸ½\í_™?µ\Ä?eý 5\èƒcm\ÛMMÿ\07õ¯\è\ïöið>‡e4H.ð\Ï33ùšü@ÿ\0‚½xZ?þ\ß\Þ4†\Ö\Ùml\ä[ya\0U\0Ľ?\×\ßp.[W‰›œ—½}\Ç\ä\Þ-qö]ž\à)ap´\åBW\æv\Ú\ÞMŸ;=Áf?3uõ¢ª«³\àóE~¡\Ï\Ç\á~\ç󪳷üw\áÿ\0\ì‰\á\Ñ\ã\é´Kqwxcsu*¶\ï¿Ô© ¥`~\ѵt~\Ò[IððŠMQkŸn›#Š
@\ïVÿ\0i\Ï\Ú\×CñF¡q¤iúÅ¿‡\çG¦\\b‚Ž\Ê~\í|£\ãHu+g–i¥†\æ$\"e•O\â+\ã¨\áiaܧMk\'C\èðx]=ý\Î/\âU®‹ñ/T“P\Óu[ö“xGb“F}=x¦ø7\Ç>.\Ón\í\ìõI$¾³ŽE_2@±5‹\â4û\éšFO³Ü¨\á€Á¡µñoö4j\ÍtdXö“ϧ5\Í*÷½\Ïb”$¥\Øý¢ðW†\ïüK\á-&ht›\É>\Ñk)[s†Êj\ï4O\Ùó\ÅZ\ÂF\Öú-\Äk\Ðù€.?:÷\Ù\Åö\Þ(ý˜þ\ê\íe¼\Ð\íd\Ç9ŒW­[J\Ì2:W\ær\Ëc\Ïv~™[\Åg³P¥IGÕ·þG\Î\Z\ì\âY\ãVœ\Û\Û.pA“œWw¡þ\É6ö\Ê\×\×SI\'ño—ùW°Fû¹üªaó/ñq\íÖº#„§|®+3:\íûü¾‡š\Åû4xF\Þ!\çi\í3z»³f’\ç\à‡„\ìò|;¦³\ã’\Çó¯A;v7\ãÚ³/\ìg\Çðñ\ê\ÕJ%\Ðó?¶±\Ò\ÖU¥÷³Š›ÀZN&cÒ¬b\Ú26¼~•\Îø\á\Ü4©\ìt³\Û\Ù=\Ü÷b<\ã+—oԚô[\í[Ÿùi³z½c\'…\î,\æý\å\å¾\Üô_›úWM(\ìr\â1*iRn^­¿\ÌÍ·ŽiY\ÚY#›\Ël÷kb\ËWY:z²n5r-*\Üǃr§w\\!ÿ\0\n–=\nܧú\æ\Çl#…k:‰œ¼Ü¿	³\Û\ÝD\Ò,£w`½ª\Ü7¡ì••D›F25ø6ݟp‘¾oúfjՖ†šo\Ýy\ä_A\â¦5\Ð\Îz«õ+‰ôFI8À\Æ­fjhn->V\åzk¨M>7˜e“MµV\æ\Þ\Ö\Ù6‹XW¿\Ï\'¥kJ²¾\Æ},yιh\×Q\íUb\Ù\É\0u¯\Èÿ\0ø8\àUցñ‹\Â~4þ\Ïhíµ«eq.:\ÉpO\àߥ~\Î\Í<¿+mû°Ç´~|W̟ðS\ß\Ø\çXý¯¾I¤\èvkq¨i\Óý®\Ý\nü\ÎÁH\Æ\ïS_G”f>Ƽe;%\Ôòñ\Ô\\\áe¹üù¾Œ»\Ï\îÛ­úU§ÿ\0Á½Ÿ®´ø$w\Ðai#Vh\Ú\è\îBFpx\ê:Q_ý¯•ÿ\0\Ï\Øý\çƒõ\Zÿ\0\Ê|\Ïû|<\Ôÿ\0gߊ:ׁüq¤\É$vó·\Ø5@¿-\Üg%Xôü\ë\ä´3\è\×\rq£k\É\åù.\Å[\èE~\ÜÁT\ßß¼e®ü\"ñ½¯öu®¸\â\ã\Ãþ\"$—•F=@,8õ¯\Ã_ŽŸ5Oƒ¿u?ꑵ¾±¥\Êcw^c™GFS\Ü\Í~eÍ¾´š¿½úvi”\ÖÁFZ‹Ý¨“OôõF…ÿ\0\Å;\Ë\åd¼·\n\Ì1¸µ‡{\â\É>\Å$k»\çR=q\\ñ\Ö\Ú\íTœ–§5g\ìR<HûNf`Ö½hÅ·¡\àʶºŸ\Òwü»\â_ü-ø\'§\ÃkÖ¸¶…¬\ì¾\ÂÁŸ.<¦d\é×µ}©¦4kÿ\0¬/ñ”W\à\ßügþ\nY¦ü\nM\àžµ¤\Þ-滩yV\Z•²†´¬R	\äžk÷\ÂisœªcG }\é_q?Zùœvq“l\ÑTU4;˜§\Ôyex4ùj\çs{óŠ\ÌÓ­%xD’M\Çp£VdhNa­yn,|®ö#šþ5$·“ÿ\0’ªËªG»\æû&\ß÷³ŸÒ´´ ÿ\0©Œma~\ìkùQ\Ë\Ô\Öö0_REqµ­‡\Ñ	¢MWø|Áø@k¡\n­Ÿ‘xö§…\\g\å\ÏҚ¶Èžfr¾kK6\ãð„\Óc·›q`\×\ì=vWQ\"‘\ßnM4œ\î횲Nr5˜œÿ\0\Ä\Ä\àúZ²-¤ÿ\0«¾ofaþ5ª\×,‹\Û\×5·{†\ß\ëTN\ÅHt\éŠÿ\0Ç»{oq\ÍGq¥NyU·‡±À\Üj\ê\ÜHžx\ÍJ²ùŸýz¯z:™\ÊW2,¼?\Z>\é¤i\ØúôJ贋/\"=\Ûzôã ªp³\Ì0:w°‹±q\éX֨ތ˜G¨Âœÿ\0«%\Îh~\\þÕ¿\n\íj?„w±^HOˆ¬óykr‡rp\ç_¾5ø	sûI\êk ø³Móu+Uò¡Ö­A[ˆ‚—ztpÒ¿G<9¯H·‘žªx<u\æ¼\Ç\·\Ðþ=\Ï\Z¯\Íö—ÛŸ\î°\ãô5\æ\å5œ1*I\ï¹û^>œ^Xz±RQ\Ö)ôò\îÊ¿\ZþÁW\ß\rRmJ\ã\Å^»\Ð\"%£¹QA< q·\Éûû¸\Æ1Ö¨\éþЭ絹B\Ó4*\nn—8\ëŠ\Õý¦þ\Zýƒ\ã/‰¬ü\É?\Ð5)¢\n‡=ª¶‹ð\Å\ÚΆ·–¶¯%ˆ\ë2:W\ÚG‰\é\Åû-$ÿ\0ó:<)Š\ÄA\â9c\æ{üÀÖ¾9ÿ\0‚ü3µw\Éý¥ö–aþ³ÿ\0Jþ|?ZM$l~Ul\×\àOü\ç\áUÄ¿ðRÿ\0\È\Ì\Ìú=¼÷\r\ÇO\Ý2ÿ\0Zþ‚í´¶ L½\Éɬ1˜·Qû\êǑSNGK˜Ð·›t*‹R\ÜCû\Î\Ý\ë]‹ó5+.\ÐY»šòù‘1܆$*6ÿ\0:“<}\à8\Å1X©úzT…C\Z¾m\n•˜©s\Å(“w©!h§\È\íQ\Í\Ü̈³/V’6?‡8§I\Ö\íø\Ò-“ò\Õ\Ä%\ËӜb«´LOC\ÓÖ®8\È5]\Âÿ\0y¹«ˆ–\àŸ*r)S\åúœþ”²}\ßÆ£€\âm¦¯¡„‹újfN¸­:£¦3z½\\u74ŽÁEVe–¾mֈ\Ün\ÇZ\å/ ý¤­\ÙI`Œ·¹\Ú(¢¼LƽQû–?e\æ\Ì\ïÚ¶/7öªø\æ	ýµrpûd× |7ø‡¨\è\ß͜F‡\Ë#\ç-ù\ÑE|õ?\í‹õ>Ò¤Wö2\Ó\ì¯\Èúþ\rûQ«ÿ\0ÁI5¶Ÿ\æòt]=ŽTZý\ÐÓ¢Sm·QE~•‹m\Úý‘ü\ÅSø\Òõe¸\Ðy\Û{t¨®þO—µW,H\êU\È\ãÞ®m\Ê\ÑEi-Š\rŠ’Š+32¥\ÍW\Î\Ý\ÔQZDº~•R\áð£ÚŠ*¡¹›\Ü7n¨\Ô\â\áMV\Æ264õ\Û}jÓ±\rE\ÇSsH\ì7qõ¢Š*¬Š?ÿ\Ù','work',NULL,'emp-0003'),('C.P. Chamara Weerasekara','emp-0004',78942,'No.215, New Kandy Rd, Malabe','1985-08-20','877040660V','Male','Married','Mr.','656565','adfadf','0214-04-10','dep-04','Confirm','Director','V4','Route B',25000,'7841254611','Yes','Yes','No','shows enthusiasm for work place activities.','‰PNG\r\n\Z\n\0\0\0\rIHDR\0\0\0¤\0\0\0¤\0\0\0µ…A\0\0\0
sRGB\0®\Î\é\0\0\0gAMA\0\0±üa\0\0\0	pHYs\0\0\Ä\0\0\Ä
•+\0\0\0tEXtSoftware\0Adobe ImageReadyq\Ée<\0\0šIDATx^\í	ŒT\ņ\ÙA
u„
AQT`‹h@c0Š‰	¢Q\ЕDŸ\Ñĸq«‰¢ \"FÁT6‡T”UQdqAz÷;\Î}o„\î™\î¹÷vWÝ®?©\Ì\Ò\Ýukùû\Ô9§Nª¡=(‡\áرc\ê\ï¿ÿVüñ‡Ú¿¿úý÷\ßՏ?þ¨V­Z¥Ö¬Y£¾ÿþ{µo\ß>µw\ï^ùyô\èQù\\­ZµT“&M\Ôi§&?[µj¥ºv\íªzö쩚7o®\êׯ¯òòòT½zõT\íÚµU͚5\åsÿ‡#d9rDýò\Ë/B>H÷\Í7ߨ¥K—ª\ï¾ûNýù\çŸBL\nd…„¼ŸŸþÖ¨QCHy\ÒI\'\ÉOH	)u\ë\ÖUgŸ}¶\êׯŸ:\çœs„¬´iÓ¦ò~‡\à\é
RAÄ­[·ªyó\æ©%K–ˆ\äó%$d:LRú	:`À\05j\Ô(Õºuk!&$\Îu8Bz€|s\ç\ÎUo½õ–*))Q»v\í\é%Šgœq†\êÔ©“ºò\Ê+\Õ5\×\\#$\Íu\ä´ƒ®ø믿ªO?ýT}ø\á‡\ê\ã?V?üðC\äd<ƒgñLžMhm\Êe䤄Düù矅\0H\Äɓ\'«\Ò\ÒRù\Û7P2–\éSN9Eu\ì\ØQ\Ýq\Ç\"1ùû\ÔSO4אs„ü믿\ÄR~\å•WԆ\rÔ¶m\ÛĀ¤\Ù\ä\Ã\ÐiÙ²¥º\à‚\Ô\èÑ£U·n\Ý\Ô\É\'Ÿ\\þŽ
„\Ì>|X/_¾\\iO\nio²µglð…4¢\Ð\ÚD\Ûh#m¥Í¹„œ!¤g1\Ë÷\é\ÓG&=!L*´‘¶\Òfڞ+\È	B2¡‹/Ö½zõ²‚Œ~¡­´™¶\ç\n)s\Â\Ê\Æ\Ñ=e\Êõ\å—_Ših+m¦\íô!{Bb9¯^½Z}ñ\Å\â\è¶\r´™¶\ÓúwĖH¬gv]ž~úiµ{÷\îòW\ìm§ô…>\Ù$\å\ÓE,\Ý>L\ØgŸ}¦žz\ê)q83¡¶O¢§Oª\ÓO?]õ\è\ÑCM˜0A]r\É%ñt	‰&#=zT—””\è!C†\èF\Z`(\Ø^\è}£ô5nˆÝ’M0Ļﾫ֮]«:Tþ\ßø€>\Ñ7úH_\ã†X’e™Ý—Ù³g«Ÿ~ú)p„Ž‰ Oô>\Ò\×\Ø\é“\"\'c€cǎ\éo¿ýV<XשS焥.n…>\ÒWúL\ß\ã‚\ØHH¢d#Û²e‹:|øpù\ãúH_\ésœ\"„bCH\"¹¿ú\ê«X\ê\É@_\é3}bAHOÒ«;wª_|Qô«\\
}¥\Ïô1ˆbAH$!e›7oŽµ\Óøx\ÐWú\Ìöb\\¤d,‰\ã{\êÔ©F\ï\Æpd¡E‹ª]»vRš5k\Ê\Zú<m\Ú4£ûž¬\'$\Êýž={Ԏ;²d[ˆ\0\'\"|Ö¬Y\ê…^Pw\Þy§\êÒ¥‹ø\â\0XuAŸ·o\ß.„Œ…1\'¶¶\Å(--\Õ\ãƍ\Óyyy\'¸FL)„‘\ë\r6h@Rö\î\Ý+±ŽÃ‡\×ùùùړ 	?›Jiܸ±¾ù\æ›õƍ\ËG\Å^X/!9ƒe²u\Íô­·\Þ*\ç²Yº)H̋/¾X\Ýs\Ï=r\\s4\Õ\Åo¿ý&cÀQ^\Ûa-!ñ½±DA\Äl\ÎJœ\Å\æŒ\ä#a@E°\\“Ù¢oß¾ª{÷\î\'¼ž*\è;ۈŒcb³_\ÒZBbar°Ÿbªe\ÑÒ¦Mu\Ýu\×Iz•D€°½zõIy\ÑEU›”6ŒG*¨õ\å¿[|p\î_¼x±úú믍S\èY–\Ï<óLYŽ\ÉNAfŠDƋŸÑ‚÷ž{î¹¢‚ \éȖ‘Ž\Ô÷\Ô/	\æ\ås\íÛ·W\Z5*\Å2ü£J\ڏ„z\èСºAƒºf͚	•ýlO*Jˆ˜G.=a\½i\Ó&}\äȑòVWLړpzΜ9ړ–i:Œ
cÁ˜06¶\Â\Ê%\Ûk·H‚ƒŠBoŠÎ„Td‰&5\Ê-·\Ü\"C&Uc:uTAAº\ì²\Ëԍ7\Þ(~\ËT]BŒ
cÁ˜„‘‹([°’8\ÉL²¬‰Þ¾ð\ÂÅ¿8q\âDu\Ã\r7¨¶m\Û\nI\ÓY\Ñú÷\ï/\Ëy:`Lülm6\ÂJB\"	\Ø*4Á́\Ã!\äO<!:#º ‰£ªCF€D…\Ì::tHkG‡1al#a­„d—\å)ۀ,HFι\àOL‡@ɀ\Ä%dQQQZ\nc\Â\Ø8	™A9Œ\ìµÙ¶¬\Ãò#&õþùi\Õ˘06™\È\à¬$$û·œÏ†`ƧHb($\â}÷\Ý\'§\0	–ž\Õ,¾IŒ›T¥.c\Âؘ¼¯_¬$$þ9|n©J
rycÁ\É\éMv²üü|\ÙqÁz~üñ\Ç\Õs\Ï=§(p£H	\Ï:\ë,uù嗧¼µÈ˜06¦\î\\U+		\Òqk i.½ôR1\Z6lX¥+…\×!ŸC:¡#ª‡zH͜9S?^]q\Å\ê¼ó\έSp¨>\\~¦\n[]>À\ÊD
eeeꪫ®’ŸU%–d $\r€d3f̐c¤l¯\Ñu$\n\Å\'!R‰ŸXɤ\\\æ`>†\nw$\Íô\í	$\ßgû‘v§²ó\Å{ó\Í7\å§mˆ=!‘p#FŒP<ð€\èy\ÄN\â¡Û’CRü}H!$(¤„\ÈXºüݸq\ãP,\ç\êpÒ¤I’d•4\ÐUÁfB21ցHo°ù\"UY<騧Nª÷\ï\ß_þ\éÿ\ÃÓ³$\ͯ<xP{5òH\é¡C‡´GFݹs\ç„}<¾06Œ‘°V‡L¸LH“œ(K/’	ˆ$d©ŽR¬.h’}5\î\È	Bb\'\"¤-€¸šð\ı\'$º_P—O¶\á\\6÷!UÄ¿‡VÁZBš¨\ë™›\Ç\ÆJB²£\àW7š&\Î`L›lº©‚ÀJB¢Oq’/\ÝXÁ\\\0c\Â\Ø0F6\ÂJB\"8F\êy\"\Æ\Æ\Ö\Õ\ÃJB2\è\rÀw\èðo0&Œ­_V+	\É~2qˆ©õ\åYeöÁ9)HI5ú(]\ÐvúJc\Â\Ø0F6\"öòÀjÓ¦M¡\ÅN\êò€ήpEw\ȆF\áwþ\Çk¼‡÷†
\ÚN\èKU°]BZy.·“óÁHnD$G²\É\ç½H\"ºƒœU\æa@82×®\\¹R=û\ì³júô\ér\ß5½÷\Þ{jݺuò~$\Z\Ä\äùAóD€¿üò\Ër\Õ	u&õ³+\ÅyB\ã\Ð#m„µ÷\Ôp\ëÿK/½¤–-[&— \'»‘\0\å¾s\ç\Î\ê\ÕW_•3*逡XD\ÛPHJ0þ|9H…\Ô\â\'Á°þB>\\.,›H(~iD/¡kș®Ÿð³k¯½V­_¿>©Z——\'08Nqýõ\×K蜕€6‚(²²2‰\äiݺµD¹$+mÛ¶\Õ+V¬hžª\àM¸d&Û¼y³d+[¸p¡9r¤D\r5k\ÖL
$zF¢\Â{ùŸ¥\ê¢N\ê\æ<«*\Ðf\ÚN=\Ã/Œ
cÁ˜06¶\ÂZB:\æI)½h\Ñ\"ݾ}û„“\äOR\é‰\'\ê={ö”:9E›={¶=z´ö¤&ƒ÷W{KbºS)|–:¨‹:©›g$\n‰;´™¶Ó‡Duû…1`,\Æ\ÆVXi\Ô\0t&–?”x–«\Êv&Hw\\RR\"\Ëk\"x\ã \ÇG‰\È^¾|¹\è„\Ô
²«±\Òù,uPuúõó,žÉ³iC\"ø\Éü+K\ÙL\ß\Æ\Âö@k“Mù úC+}/ ºdqq±\èVþ„q\0¢…\r18\æ0g\Îɵˆ
“Š›¥: d)C÷---B¢[²\Ã\â¹\Ð\éYw‰tOFZŒ5ôTú\Å\é\ÇL\Âú\Ë7™\Ü\Ï?ÿ\\3F\È\'ÀlL:\ÒCIõö\Ûoÿ\Ïp©h¤D\r\ßò\ržaÆI^~\çÿ|a{\ì11Ȓm€,\Ü\ÆÀ‰H$¤Íˆ\Åm°ñ¦›nRŸ|òI\ÒCPHE¬\ì\Ûo¿]}ô\ÑGÿó\ëQ°–£’†©©ˆUNô:÷M\ïÞ½\Õ3\Ï<#Vv2•/\'*Ÿþy!¦\íˆ!Y¶‘rH¿\ÊA1yD^CB$aUz¡\ïº!\Ú<\è0!\r9T滌*_$$\Ä\ÄY\ÙICŽg E‘®¶\î\ÎTD,IHZ:n\Ü8‘’L| 	u’b/™ÿ/U \Ã\âP\çúŒ”0À\éHœO׿i\"bAH€¥ú\Æo¨û\ï¿_®	,™O>ù¤,ŸA‡	² &”\n•!pV\è\á‡V#GŽ´7c\îq°\×?pü\ÄL©\ìo§\nôJ¤­¿|)\ÔA]a\êªô5\ÝdT¦#6„D\ï\"\Û\ËkX–&y\Ìq\Í }ƒ‚:¨+¬»\é#}¥\Ï6ûO\0Kv\\pøða½l\Ù2\Ùñt6\Ö\Ø@\Å\Ó\ÑtϞ=C\É\ÙM\ÔE‰ž•N¡oô‘¾\Ò\ç8!F_­”|\î„!\â J>K,iœ\Øɜ\î©Àw„SWPƒ‹>\Ñ7úH_\és¬PN\Ì؀}ܒ’=d\ȹ\r.)H´>}ú\È5pՑF|†\ÏzR(ґ>\Ñ7úH_\ã†\Ø@ϒ\ÕW_}µnÕªU`\"xúšE¤KJŸŒEEE\ÛÀ\ç\é}¢o\Õùr؀X0aÛ¶mÓ¯¿þºH¸0HI=\ï¿ÿ¾Þ²e‹Þµk—„y«œŠ\ßù¯ñ\ÞƳù<õ\ÐúW2‚\Øø!“\à‰%K–¨»\îºK‚0‚\0÷\n)–qBw\ê\ÔI\r:T¶\ëü`\\:lc²k´q\ãF\Ùò#\Â\'\è\åꤏ&߀
]\ÒibOH\0¹«zÑ¢EIC\ÐR\î\Ò,CHŽ\nT¼	BrĜ„8\è=i&¯Uø/¬&Ož,Č;r‚\ì¯X±B=ø\àƒr.%ˆ¥‹\Ï\Ï[BeŸiA}kž¡„€Heˆ\Ïs‚/\Ï!±>\ÉV½%\Ûڃ[i
B\æ\Ð\í00\Â\Ð\é2Q|½‘6\Óö\\A\Î`øV/G\n˜tOº%$D6\nm¡M´6¦k\Õ\Ç
9±dW\Ë(W¯‘¯{Æ\rʳZE\ÇL%™|” 4‘p2\Þ\\Q×­[·ø9¾«@\Î@>2M \ëq\Öƒ£üfðC*À B\å¦/Œ%þ\æX$\Í5\ä$!} K°\îªU«\äÀ…C	¤H„\á>\âx«`‰4‘»=÷À\Ä#¸‹†³,´g\É$˜6jðž\Å3y6m -¹LF\Ó\Ò\Ë4G€˜7ož8\Ò9uˆ\ë†\ÃU¸‚®!\Ü66÷H\ØŽ\îQ£F\É\Õt•ðý™¹G\È\n\à˜\Ä\äô!†;-K—.•\Ýv[È«CÁ\×X\Õy$>J‚h)\ìò°«Ó¯_?9l†
\Ã\éBˆ˜	‰l!\0²aøø’Cd\ä\â¼:–yUہ°  @R\ãq\î…ó\à\Âò%$K®/ω\à™\"\ÜEA$$\îG\Ç!9!Œ‚[3Œ‚#¤ƒQp„t0\nŽFÁ\ÒÁ(8B:GH£`Œ’m;\"o\Ø	\Zú_\ØS6ù†~vˆH*PUÚ¾ ÀI³ž#\"ŒLÙ¾4†\ä¼!ÿö;\ï¼#û\ÈA\Ó\ß%;(\ì%\ßv\Ûm’¨\ÉD®;p*KT\Zýô!C†\ÈU\"¦¤‚\Î\Z!y,\Ûpeee²/L@C¦	}ôQI·Çž³){ʐ± ]ß½÷\Þ+\Ä\Ì!	ô`,:t\è [\Ù\Ú\æ\Ì\n!Y’\ÉtK”6)‹·o\ß.ÿ\ËԒM\") ™\ÎY›’[‘\à`ÿ¦R4W–\r8(Ž_²	ö\àx\ïøñ\ã%z1\Ê\Êñ	™)x\ßv\í\rº^\Z<x°nÓ¦d„ðöe¬xƒ¯=R6̘ƒTþ
4\ÚD\Ûhc¢¶GY<ʜ8P2«y\"\ãùƒ2FHO\êiOʅA=zôОa‘pP2Yü\ÄM\Ü~•é¯žM\ÂJ´ $˜£Y³fiOJ§tZXˆüž\Z¢±YŠ\È
\Î0S¦L‘ƒU,\ËنóH\à,†\áb\Ù\0º4Y5^{\í59|–m0g\èô谌A\Ä‹\á,\'f$\à›\Ï7l\æ̙\Ú\Ó\Ùd9¨•\Æ]™(,Hƒl-\ÝþRM²±LWV˜«‚‚=f\Ì\í	\훑¯$‘\Ò3P´§œ\ë\Â\ÂB\í)\ÏƑ\Ñ/¨ƒ\r\Êø\Òͳx&\Ï6A…IT˜3\Ï\è\ÑÝ»w\×3f\ÌH\é~\Æ ˆTþ²ü̝;W\äc=³˜\ÐøüH•IU‚gñLž¥<˜3¼¨Y€‹Z¥ˆŒø\Ópa\à\ÚAG2´‘/NUge\Â\Ï\â™6Œ犘\Ë0\ÒVŠrI*p\ï°õ\ë\×ϊ\ÄN”L\ë’&\ëŽ\É\nsɜ2·\ÌqˆDBòm\âBL,k¬\éT€Å½n\Ý:õ\È#È[Q\í\0\ê\æ<‹gf;¯Pª`.™S\æ–9Ž‘’À€\éÓ§\ËO›€\Ç\Êq\×(u%\ê\æ<\ËT\Ý1¢ž\Û\Ð	\É4>¬;wZóͯzÚ´i²}\çoi†\ê¢N\ê\æ¶}a
s\Ê\Ü2Ǒ\Ä”/Ý¡Ád}÷\Ýw\ë¦M›&\ÔCl(¸`:v\ì¨ÇŽ«7m\ÚŠ+ˆ:¨‹:©\ÛT7O*…¹eŽ™\ë°º„\ÄEÀjü´žÁ!®˜õ\ë׋®†¤§\ê¢N\ê\æ¶\"\Ê9Žd\É&?NT\ác™€÷E•ösWuX® \ß\ÅC\Ô\Í3lE”s‰Q \ï\áfO7ˆ.\Ég©ƒº¨\Ó!9B%$\ßz<û6û+·Á¼¤ê«Ž+ˆ\ÏðY\ê .Û¬\êdˆj®C%$’€´\È6/\×\Ç¡÷¡3U\Ç÷\Ægø,uąŒ€9f®\ÃôB€\Ð%dœ\È\èc÷\î\Ý\â¦Y»vmZÀ{ùŸ¥Ž¸
\éo´„$,>ŽY`±\Ó\Ýűu7&0\ßaŸ½qFMŠ`¹\ÅJ\æ\0V*»8¼‡÷Ú¸“M8B¦
Ž\êb)“A·*ð\Þ\ËgR‡#d\ZÀ™Í¥š+W®\ÉGxÿñ\à¼\Æ{x¯\ÍðlÀ2M°‡\Ë\Ñ].[\âüxE}’\ßù¯ñ\Þ\ë!\Óú ·2¬^½ZtĊ® ~\ç¼\Æ{œ\î˜>!«
$!ûфaù® \ß\Å\Ãÿx-K\Ü\áD8BV\è†8»q\ë`ÀPøÿ9½±úp„\0–d\ß\Èñ·Lƒ#d@`¸Lš4IŠ3b‚\Ã2 pó°LS¹҃#¤ƒQp„t0\nŽFÁ\ÒÁ(8B:GH£\à\é`!Œ‚#¤ƒQp„t0\nŽFÁ\ÒÁ(8B:GH£\à\é`!Œ‚#¤ƒQp„t0\nŽFÁ\ÒÁ(8B:GH£\à\é`!Œ‚#¤ƒQp„t0\nŽFÁ\ÒÁ(8B:…P	\É%:a_¤\ã`.¢˜o\'!ŒB¨„¬]»¶jØ°a,oórø7˜c\æš9¡’FÖ«WOÕ­[7ô+\Ç\Ì
s\Ë3\×aŸÐ—\ìF\Z©nݺɷ\Ç!ž`n™c\æ:l„N\È\æ͛«±cǪv\íÚ¹¥;†`N™[昹¡¢u\ëÖª°°\ÐI\É‚9en™\ã°õG:!AýúõU—.]T‹-œ”Œ˜K¤\"s\ËGHÉ·¨oß¾ªÿþªe˖ªN:\å¯8\Ø\n搹,..VEEE‘­~5tDž\ì#GŽ\È\íV‹-Ró\ç\ÏW[·n•»\0÷\ï\ß/\×g¸«\×\ÌF͚5Ŋ\Î\Ë\ËS\r\Z4%zĈjРAª   ’\å\ZDFH\0\é8 ö\íÛ§v\ì\Ø!S.X°@­Y³\Æ\Ýxe8p\ët\í\ÚU\r>\\õ\î\Ý[\å\ç\ç«&Mš¨ÆY£Rÿ¢E\êð™o\è\0\0\0\0IEND®B`‚','work',NULL,'emp-0004'),('Nadith Weerasekara','emp-0005',34566,'No.215, New Kandy Rd, Malabe','1985-08-20','877045656V','Male','Married','Mr.','6565','asdasd','0214-04-10','dep-03','Confirm','Worker','V1','Route D',25000,'7834535434','Yes','Yes','No','shows enthusiasm for work place activities.','?','work',NULL,'emp-0005'),('A.D. Karunarathne','emp-0006',99664,'No.215, New Kandy Rd, Malabe','1985-08-20','863123450V','Male','Married','Mr.','0112833235','karuna@gmail.com','0214-04-10','dep-01','Confirm','Director','V4','Route C',25000,'558844331','Yes','Yes','No','shows enthusiasm for work place activities.',NULL,'work',NULL,'emp-0006');
/*!40000 ALTER TABLE `employee_info` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `event`
--

DROP TABLE IF EXISTS `event`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `event` (
  `ideventID` varchar(45) NOT NULL,
  `venue` varchar(45) DEFAULT NULL,
  `eventName` varchar(45) DEFAULT NULL,
  `date` varchar(45) DEFAULT NULL,
  `comment` varchar(45) DEFAULT NULL,
  `cost` int(11) DEFAULT NULL,
  PRIMARY KEY (`ideventID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `event`
--

LOCK TABLES `event` WRITE;
/*!40000 ALTER TABLE `event` DISABLE KEYS */;
INSERT INTO `event` VALUES ('ASALA1','Head Office','Asala Kalapaya','2016-08-04','high participation',55000),('ASALA2','Weligama Branch','Asala Kalapaya','2016-08-12','high participation',5600),('ASALA3','Kosgoda Branch','Asala Kalapaya','2016-09-02','The date wasnt supporting',44000),('AURUDU1','Head Office','Newyear Festival','2015-12-12','Rain Ruined the Event',20000),('AURUDU3','Koggla Branch','Newyear Festival','2016-02-12','high participation',30000),('PIRITHA1','Weligama Branch','Piritha','2016-10-23','Very Heigh Participation',52000),('PIRITHA2','Head Office','Annual Piritha','2016-05-30','low Participation',56000),('PIRITHA3','Weligama Branch','Piritha Chanting Ceromony','2016-04-06','low Participation',42000),('PIRITHA4','Kosgoda Branch','Piritha','2016-09-02','low Participation',42000);
/*!40000 ALTER TABLE `event` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `expenseactual`
--

DROP TABLE IF EXISTS `expenseactual`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `expenseactual` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Date` varchar(12) DEFAULT NULL,
  `productioncharges` double NOT NULL,
  `salaries` double NOT NULL,
  `travelling` double NOT NULL,
  `repair` double NOT NULL,
  `water` double NOT NULL,
  `insurance` double NOT NULL,
  `rent` double NOT NULL,
  `electricity` double NOT NULL,
  `security` double NOT NULL,
  `communication` double NOT NULL,
  `furniture` double NOT NULL,
  `other` double NOT NULL,
  `totalexpense` double NOT NULL,
  `totalbudget` double NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `expenseactual`
--

LOCK TABLES `expenseactual` WRITE;
/*!40000 ALTER TABLE `expenseactual` DISABLE KEYS */;
INSERT INTO `expenseactual` VALUES (26,'2016-10-28',100000,3000000,100000,10000,10000,15678,45789,12395,10569,15908,12967,12890,3346196,106200),(27,'2016-11-30',100000,3000000,100000,10000,10000,15678,45789,12395,10569,15908,12967,12890,3346196,106200),(28,'2016-09-24',100000,3000000,100000,10000,10000,15678,45789,12395,10569,15908,12967,12890,3346196,106200),(29,'2016-05-28',678000,3000000,30700,5600,4000,1200,4500,5400,4657,7000,2000,3800,3746857,106200),(30,'2016-04-16',678000,600000,30700,7600,3000,2000,6500,5900,4600,6000,2000,3800,1350100,106200),(31,'2016-09-16',100000,23364.583333333332,100000,10000,10000,15678,45789,12395,10569,15908,12967,12890,369560.5833333333,106200);
/*!40000 ALTER TABLE `expenseactual` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `expensebudget`
--

DROP TABLE IF EXISTS `expensebudget`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `expensebudget` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Frombud` varchar(12) DEFAULT NULL,
  `Tobud` varchar(12) DEFAULT NULL,
  `budproductioncharges` double NOT NULL,
  `budsalaries` double NOT NULL,
  `budtravelling` double NOT NULL,
  `budrepair` double NOT NULL,
  `budwater` double NOT NULL,
  `budelectricity` double NOT NULL,
  `budinsurance` double NOT NULL,
  `budrent` double NOT NULL,
  `budsecurity` double NOT NULL,
  `budcommunication` double NOT NULL,
  `budfurniture` double NOT NULL,
  `budother` double NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `expensebudget`
--

LOCK TABLES `expensebudget` WRITE;
/*!40000 ALTER TABLE `expensebudget` DISABLE KEYS */;
INSERT INTO `expensebudget` VALUES (23,'2016-06-01','2016-06-30',2000000,1000000,1000000,2000000,50000,50000,1000000,200000,50000,50000,5000,10000),(24,'2016-07-01','2016-07-30',2000000,1000000,1000000,2000000,50000,50000,1000000,200000,50000,50000,5000,10000),(25,'2016-08-01','2016-08-30',3000000,4000000,1000000,2000000,50000,50000,1000000,200000,50000,50000,5000,10000),(26,'2016-09-01','2016-09-30',3000000,4000000,2000000,2000000,60000,50000,1000000,200000,50000,50000,5000,10000),(27,'2016-10-01','2016-10-31',20000,15500,15500,2000,5500,5000,1400,8200,5000,5000,5000,14500),(28,'2016-11-01','2016-11-30',20000,15500,15500,2000,5500,5000,1400,8200,5000,5000,5000,14500),(29,'2016-09-01','2016-09-30',20000,15500,15500,2000,5500,5000,1400,8200,5000,5000,5000,14500);
/*!40000 ALTER TABLE `expensebudget` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `fabric_inspection`
--

DROP TABLE IF EXISTS `fabric_inspection`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fabric_inspection` (
  `colourNo` int(11) NOT NULL,
  `pieceNo` int(11) NOT NULL,
  `ticket` int(10) NOT NULL,
  `Act` int(10) NOT NULL,
  `1point` varchar(30) NOT NULL,
  `2point` varchar(30) NOT NULL,
  `3point` varchar(30) NOT NULL,
  `4point` varchar(30) NOT NULL,
  `comments` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`pieceNo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `fabric_inspection`
--

LOCK TABLES `fabric_inspection` WRITE;
/*!40000 ALTER TABLE `fabric_inspection` DISABLE KEYS */;
INSERT INTO `fabric_inspection` VALUES (2367,0,10,9,'A3T2Y1','I3C2','B2','H1D1','No defects found'),(1245,11,19,25,'A3T2','I3C2','B2K2','H1D1','more defects found'),(2367,12,10,9,'A3T2Y1','I3C2','B2','H1D1','No defects found'),(2367,13,19,9,'A3T2Y1','I3C2','B2','H1D1','No defects found'),(2367,15,11,10,'A3T2Y1','I3C1','no','M11','No defects found'),(2439,16,33,17,'A3T2Y1','I3C2','B2','H1D1',''),(2034,26,29,30,'no','no','no','no',''),(2300,30,25,19,'A1T2Y2','I3C1','B2','H1D1','No defects found'),(2367,34,23,12,'A1','no','no','no','No defects found'),(2367,55,40,14,'no','no','no','H1D1','No defects found');
/*!40000 ALTER TABLE `fabric_inspection` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `fabricregular_information`
--

DROP TABLE IF EXISTS `fabricregular_information`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fabricregular_information` (
  `date` date NOT NULL,
  `dyeLotNo` int(11) NOT NULL,
  `rollNo` int(11) NOT NULL,
  `contractWidth` double NOT NULL,
  `fabricDescription` varchar(45) NOT NULL,
  `fabricComposition` varchar(45) NOT NULL,
  `fabricConstruction` varchar(45) NOT NULL,
  PRIMARY KEY (`dyeLotNo`,`rollNo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `fabricregular_information`
--

LOCK TABLES `fabricregular_information` WRITE;
/*!40000 ALTER TABLE `fabricregular_information` DISABLE KEYS */;
INSERT INTO `fabricregular_information` VALUES ('2016-08-04',13,3,123,'lines','Double Line','ABC Holders'),('2016-08-04',23,11,187,'Dotted','Line','ABC Holders'),('2016-08-04',25,12,254,'Dotted','Double Line','ABC Holders'),('2016-08-09',26,13,254,'Dotted','Double Line','ABC Holders'),('2016-08-04',34,72,254,'Dotted','Double Line','ABC Holders'),('2016-08-04',35,12,254,'Dotted','Double Line','ABC Holders'),('2016-09-14',44,41,176,'Dotted','Single Line','ABC Holders'),('2016-08-04',53,76,132,'Dotted','Double Line','ABC Holders'),('2016-08-04',59,33,254,'Dotted','Double Line','ABC Holders'),('2016-08-04',66,72,254,'Dotted','Double Line','ABC Holders'),('2016-08-04',71,31,254,'Dotted','Double Line','ABC Holders'),('2016-08-04',91,31,254,'Dotted','Double Line','ABC Holders'),('2016-08-04',94,42,254,'Dotted','Double Line','ABC Holders');
/*!40000 ALTER TABLE `fabricregular_information` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `facilitybreakdown`
--

DROP TABLE IF EXISTS `facilitybreakdown`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `facilitybreakdown` (
  `idfacilityBreakdownID` varchar(45) NOT NULL,
  `facilityType` varchar(45) DEFAULT NULL,
  `reportedBy` varchar(45) DEFAULT NULL,
  `date` varchar(45) DEFAULT NULL,
  `locationDeails` varchar(45) DEFAULT NULL,
  `breakdownDetails` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`idfacilityBreakdownID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `facilitybreakdown`
--

LOCK TABLES `facilitybreakdown` WRITE;
/*!40000 ALTER TABLE `facilitybreakdown` DISABLE KEYS */;
INSERT INTO `facilitybreakdown` VALUES ('CPUY6666','Buildings','ENG-6666','2016-08-04','MATARA','Should be rapaired'),('RRT56666','Buildings','MECH-666','2016-08-05','KOSGA','Should be rapaired'),('TY6655444','Cafeteria','ENG-7689','2016-08-04','MAIN','Should be rapaired');
/*!40000 ALTER TABLE `facilitybreakdown` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `final_transport`
--

DROP TABLE IF EXISTS `final_transport`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `final_transport` (
  `styleID` int(11) NOT NULL AUTO_INCREMENT,
  `quantity` int(11) NOT NULL,
  `net_weight` float NOT NULL,
  `transport_type` varchar(45) NOT NULL,
  `request_date` date DEFAULT NULL,
  PRIMARY KEY (`styleID`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `final_transport`
--

LOCK TABLES `final_transport` WRITE;
/*!40000 ALTER TABLE `final_transport` DISABLE KEYS */;
INSERT INTO `final_transport` VALUES (1,100,750,'Sea','2016-08-24'),(2,100,750,'select one','2016-08-24'),(3,500,1000,'Sea','2016-08-26'),(4,5500,15000.8,'Sea','2016-08-27'),(5,25000,10000,'Sea','2016-08-30');
/*!40000 ALTER TABLE `final_transport` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `finalproduct_inspection`
--

DROP TABLE IF EXISTS `finalproduct_inspection`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `finalproduct_inspection` (
  `date` date NOT NULL,
  `pieceId` int(11) NOT NULL,
  `buyer` varchar(45) DEFAULT NULL,
  `orderNo` int(11) NOT NULL,
  `orderQty` int(11) NOT NULL,
  `styleNo` int(11) NOT NULL,
  `productType` varchar(45) NOT NULL,
  `sampleSize` varchar(45) NOT NULL,
  `fabric` varchar(45) NOT NULL,
  `construction` varchar(45) NOT NULL,
  `trims` varchar(45) NOT NULL,
  `print` varchar(45) NOT NULL,
  `wash` varchar(45) NOT NULL,
  `clean` varchar(45) NOT NULL,
  `measurements` varchar(45) NOT NULL,
  PRIMARY KEY (`pieceId`,`orderNo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `finalproduct_inspection`
--

LOCK TABLES `finalproduct_inspection` WRITE;
/*!40000 ALTER TABLE `finalproduct_inspection` DISABLE KEYS */;
INSERT INTO `finalproduct_inspection` VALUES ('2016-08-14',15,'TOMMY',76,500,1323,'Shirt','M','No','No','no','No','no','Min1&M2','No'),('2016-08-14',23,'Lango',73,200,2434,'Trouser','S','No','No','Min2','No','Min1','Min1&M2','No'),('2016-08-14',24,'M&S',22,500,2245,'Skirt','S','No','No','Min2','No','Min1','Min1&M2','No'),('2016-08-14',32,'TOMMY',73,500,2425,'Jump Suit','M','No','No','Min2','No','Min1','Min1&M2','No'),('2016-08-14',35,'TOMMY',12,400,2425,'Jacket','XL','No','No','Min2','No','Min1','Min1&M2','No'),('2016-08-14',67,'M&S',21,500,2425,'Shirt','M','No','No','Min2','No','Min1','Min1&M2','No'),('2016-08-14',87,'Lango',57,400,1546,'Skirt','L','No','No','Min2','No','Min1M1','Min1&M2','No');
/*!40000 ALTER TABLE `finalproduct_inspection` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `income`
--

DROP TABLE IF EXISTS `income`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `income` (
  `Code` int(11) NOT NULL AUTO_INCREMENT,
  `Incomedate` varchar(20) DEFAULT NULL,
  `Sales` double NOT NULL,
  `totalExpense` double NOT NULL,
  `Grossprofit` double NOT NULL,
  `Interest` double NOT NULL,
  `Netincome` double NOT NULL,
  PRIMARY KEY (`Code`)
) ENGINE=InnoDB AUTO_INCREMENT=114 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `income`
--

LOCK TABLES `income` WRITE;
/*!40000 ALTER TABLE `income` DISABLE KEYS */;
INSERT INTO `income` VALUES (101,'2016-08-02',4300000,1350100,1649900,10000,1659900),(102,'2016-09-02',3000000,1350100,1649900,1000,1649900),(103,'2016-07-04',7689000,1220100,6468900,5000,6473900),(104,'2016-06-09',9089000,8900100,188900,1000,189900),(105,'2016-06-09',8089000,7100100,988900,1000,989900),(111,'2016-09-05',3000000,1350100,1649900,10000,1659900),(113,'2016-09-30',1000000,1350100,-350100,10000,-340100);
/*!40000 ALTER TABLE `income` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `leave_info`
--

DROP TABLE IF EXISTS `leave_info`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `leave_info` (
  `LeaveNo` char(7) NOT NULL,
  `EmployeeNo` char(8) NOT NULL,
  `DepartmentNo` char(6) NOT NULL,
  `Type` varchar(10) NOT NULL,
  `FromDate` date NOT NULL,
  `ToDate` date NOT NULL,
  `FullDays` int(11) DEFAULT NULL,
  `HalfDays` int(11) DEFAULT NULL,
  `Reason` varchar(45) NOT NULL,
  `PhoneNo` char(10) NOT NULL,
  `Status` varchar(10) NOT NULL DEFAULT 'Pending',
  `ApprovedBy` char(8) DEFAULT NULL,
  PRIMARY KEY (`LeaveNo`),
  UNIQUE KEY `LeaveNo_UNIQUE` (`LeaveNo`),
  KEY `fk2_levDept` (`DepartmentNo`),
  KEY `fk1_levEmp` (`EmployeeNo`),
  CONSTRAINT `fk1_levEmp` FOREIGN KEY (`EmployeeNo`) REFERENCES `employee_info` (`EmployeeNo`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk2_levDept` FOREIGN KEY (`DepartmentNo`) REFERENCES `department_info` (`DepartmentNo`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `leave_info`
--

LOCK TABLES `leave_info` WRITE;
/*!40000 ALTER TABLE `leave_info` DISABLE KEYS */;
INSERT INTO `leave_info` VALUES ('lev-001','emp-0001','dep-01','Casual','2016-09-01','2016-09-02',1,1,'Personal','','Pending',NULL),('lev-002','emp-0002','dep-01','No-Pay','2016-09-01','2016-09-03',1,0,'Personal','4498','Pending',NULL),('lev-003','emp-0002','dep-01','No-Pay','2016-09-01','2016-09-02',1,0,'Personal','34234','Accepted',NULL),('lev-004','emp-0002','dep-01','Casual','2016-09-02','2016-09-09',1,0,'Personalad','asdf','Accepted',NULL),('lev-005','emp-0004','dep-04','Casual','2016-10-05','2016-11-02',6,1,'Personal','5478656','Pending',NULL),('lev-006','emp-0004','dep-04','No-Pay','2016-09-01','2016-09-03',1,0,'Personal','7879898','Pending',NULL),('lev-007','emp-0004','dep-04','Casual','2016-09-08','2016-09-08',1,0,'Personal','7985','Rejected',NULL),('lev-008','emp-0004','dep-04','Medical','2016-09-08','2016-09-17',7,2,'Personal','0714455507','Pending',NULL),('lev-009','Admin123','dep-03','Casual','2016-09-21','2016-09-30',1,1,'Personal','0123456789','Pending',NULL),('lev-010','Admin123','dep-03','Casual','2016-09-16','2016-09-18',2,0,'Personal','0123456789','Pending',NULL);
/*!40000 ALTER TABLE `leave_info` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `machine`
--

DROP TABLE IF EXISTS `machine`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `machine` (
  `assetID` varchar(45) NOT NULL,
  `brand` varchar(45) NOT NULL,
  `modelNumber` varchar(45) NOT NULL,
  `serialNumber` varchar(45) NOT NULL,
  `type` varchar(45) NOT NULL,
  `ownership` varchar(45) NOT NULL,
  `factory` varchar(45) NOT NULL,
  `location` varchar(45) NOT NULL,
  PRIMARY KEY (`assetID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `machine`
--

LOCK TABLES `machine` WRITE;
/*!40000 ALTER TABLE `machine` DISABLE KEYS */;
INSERT INTO `machine` VALUES ('VTW-M1','Brother','001','1234','Single needle','Company Owned','VTW','V1'),('VTW-M10','JUKI','43566','2233','5 Thread overlock','Rent','TGK','V9'),('VTW-M2','ZOJE','002','123456','5 Thread overlock','Rent','VTW','V1'),('VTW-M3','ZOJE','567','45354','5 Thread overlock','Rent','VTW','V1'),('VTW-M4','ZOJE','098','0898776','5 Thread overlock','Company Owned','VTW','V2'),('VTW-M5','JAPSEW','2313','313','5 Thread overlock','Company Owned','VTW','V1'),('VTW-M6','JAPSEW','32423','434234','Pearl stitch','Company Owned','VTW','V1'),('VTW-M7','Veit 2003','43234','432434','Pearl stitch','Rent','VTW','V2'),('VTW-M8','JUKI','32424','4324','Iron','Company Owned','VTW','V1');
/*!40000 ALTER TABLE `machine` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `machine_registration`
--

DROP TABLE IF EXISTS `machine_registration`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `machine_registration` (
  `MachineID` int(11) NOT NULL AUTO_INCREMENT,
  `Brand` varchar(45) NOT NULL,
  `Model_Number` int(11) NOT NULL,
  `AssetID` int(11) NOT NULL,
  `Ownership` varchar(45) NOT NULL,
  `Factory` varchar(45) NOT NULL,
  `Location` varchar(45) NOT NULL,
  `Type` varchar(45) NOT NULL,
  PRIMARY KEY (`MachineID`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `machine_registration`
--

LOCK TABLES `machine_registration` WRITE;
/*!40000 ALTER TABLE `machine_registration` DISABLE KEYS */;
INSERT INTO `machine_registration` VALUES (2,'JAPSEW',1,122,'Rent','TGZ','V5','Pearl stitch'),(3,'JUKI',3,123,'Company own ','TGK','V4','Iron'),(4,'Veit 2003',4,124,'Rent','UTH','V1','5 thread overlocks'),(5,'Brother',5,125,'Rent','TGZ','V7','Pearl stitch'),(6,'Brother',6,126,'Rent','TGK','CPU','Iron');
/*!40000 ALTER TABLE `machine_registration` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `machinebreakdown`
--

DROP TABLE IF EXISTS `machinebreakdown`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `machinebreakdown` (
  `breakdownID` varchar(45) NOT NULL,
  `serialNum` varchar(45) DEFAULT NULL,
  `lineNum` varchar(45) DEFAULT NULL,
  `date` varchar(45) DEFAULT NULL,
  `reporter` varchar(45) DEFAULT NULL,
  `requstedSparePart` varchar(45) DEFAULT NULL,
  `error` varchar(45) DEFAULT NULL,
  `errorInDetails` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`breakdownID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `machinebreakdown`
--

LOCK TABLES `machinebreakdown` WRITE;
/*!40000 ALTER TABLE `machinebreakdown` DISABLE KEYS */;
INSERT INTO `machinebreakdown` VALUES ('ABCD4556','V45','ENG-4567','2012-01-11','CHAIN-1234567','CHAIN-1234567','Abnormal Sound','The chain is over used'),('ABCDE2345','V45','ENG-4567','2012-01-21','CHAIN-1234567','CHAIN-1234567','Abnormal Sound','The chain is over used'),('ASC34456','ASDC445566','V13','2016-01-08','ENG-7890','NEEDLE-456','Brocken Needle','need to repair immediatly'),('ASCD4556','FGBFGBF566','V7','2016-01-06','ENG-6677','NEDDLE-678','ttBrocken Needle','need to repair immediatly'),('ASD003444','DFDG556677','V5','2016-01-02','ENG-5678','NEEDLE-45','Brocken Needle','need to repair immediatly'),('WER0025','WERT22334','MEC66','2016-01-02','ENG-6474','BEARING-008','Heating','Mechanicall repair'),('WER0043','RFGT34566','MEC66','2011-12-5','MECH-7887','NEEDLE-003','Brocken Needle','Immediatly Repair this');
/*!40000 ALTER TABLE `machinebreakdown` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `machinedifference`
--

DROP TABLE IF EXISTS `machinedifference`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `machinedifference` (
  `nextStyleNo` int(4) NOT NULL,
  `type` varchar(45) NOT NULL,
  `difference` int(11) NOT NULL,
  `status` varchar(45) NOT NULL,
  PRIMARY KEY (`nextStyleNo`,`type`),
  CONSTRAINT `fk_MachineDiff` FOREIGN KEY (`nextStyleNo`) REFERENCES `style` (`styleNo`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `machinedifference`
--

LOCK TABLES `machinedifference` WRITE;
/*!40000 ALTER TABLE `machinedifference` DISABLE KEYS */;
INSERT INTO `machinedifference` VALUES (6056,'Flat Lock',0,'1'),(6056,'Single Needle',0,'1'),(6056,'Thread Overlock',1,'1'),(6098,'Flat Lock',0,'1'),(6098,'Pearl Stitch',-6,'1'),(6098,'Single Needle',7,'1'),(6098,'Thread Overlock',1,'1');
/*!40000 ALTER TABLE `machinedifference` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `manpowerdifference`
--

DROP TABLE IF EXISTS `manpowerdifference`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `manpowerdifference` (
  `styleNo` int(4) NOT NULL,
  `type` varchar(45) NOT NULL,
  `difference` int(11) NOT NULL,
  `status` varchar(45) NOT NULL,
  PRIMARY KEY (`styleNo`,`type`),
  CONSTRAINT `fk_StyleNoManPowerDiff` FOREIGN KEY (`styleNo`) REFERENCES `style` (`styleNo`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `manpowerdifference`
--

LOCK TABLES `manpowerdifference` WRITE;
/*!40000 ALTER TABLE `manpowerdifference` DISABLE KEYS */;
INSERT INTO `manpowerdifference` VALUES (6056,'Direct',5,'1'),(6056,'Indirect',3,'1');
/*!40000 ALTER TABLE `manpowerdifference` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `material`
--

DROP TABLE IF EXISTS `material`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `material` (
  `assetID` varchar(45) NOT NULL,
  `brand` varchar(45) NOT NULL,
  `quantity` float NOT NULL,
  `serialNumber` varchar(45) NOT NULL,
  `type` varchar(45) NOT NULL,
  `color` varchar(45) NOT NULL,
  `factory` varchar(45) NOT NULL,
  `location` varchar(45) NOT NULL,
  PRIMARY KEY (`assetID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `material`
--

LOCK TABLES `material` WRITE;
/*!40000 ALTER TABLE `material` DISABLE KEYS */;
INSERT INTO `material` VALUES ('VTW-MA1','JUKI',10000,'01234','Wool Fabric','Black','VTW','CPU'),('VTW-MA2','Veit 2003',100,'10294','Silk Fabric','Yellow','VTW','V1'),('VTW-MA3','JAPSEW',2500,'68392','Cotton Fabric','White','VTW','V1'),('VTW-MA4','Veit 2003',4500,'86823','Nylon Fabric','Black','VTW','V1'),('VTW-MA5','JUKI',995000,'23442','Cotton Fabric','Yellow','VTW','CPU'),('VTW-MA6','Veit 2003',31924,'3242','Nylon Fabric','Green','VTW','V1');
/*!40000 ALTER TABLE `material` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `material_registration`
--

DROP TABLE IF EXISTS `material_registration`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `material_registration` (
  `MaterialID` int(11) NOT NULL AUTO_INCREMENT,
  `Brand` varchar(45) NOT NULL,
  `Serial_Number` int(11) NOT NULL,
  `AssetID` int(11) NOT NULL,
  `Color` varchar(45) NOT NULL,
  `Factory` varchar(45) NOT NULL,
  `Location` varchar(45) NOT NULL,
  `Type` varchar(45) NOT NULL,
  PRIMARY KEY (`MaterialID`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `material_registration`
--

LOCK TABLES `material_registration` WRITE;
/*!40000 ALTER TABLE `material_registration` DISABLE KEYS */;
INSERT INTO `material_registration` VALUES (11,'JUKI',1,1,'White','TGK','V4','Silk Fabric'),(12,'JAPSEW',2,2,'Yellow','TGZ','V4','Silk Fabric'),(13,'JUKI',3,33,'White','VTW','V3','Cotton Fabric'),(14,'JAPSEW',4,4,'Yellow','TGK','V2','Silk Fabric'),(15,'Brother',5,5,'White','TGZ','V5','Nylon Fabric'),(16,'Brother',4,6,'Black','VTW','CPU','Silk Fabric');
/*!40000 ALTER TABLE `material_registration` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `materialdifference`
--

DROP TABLE IF EXISTS `materialdifference`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `materialdifference` (
  `styleNo` int(4) NOT NULL,
  `type` varchar(45) NOT NULL,
  `difference` float NOT NULL,
  `status` varchar(45) NOT NULL,
  PRIMARY KEY (`styleNo`,`type`),
  CONSTRAINT `fk_StyleNomaterialDiff` FOREIGN KEY (`styleNo`) REFERENCES `style` (`styleNo`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `materialdifference`
--

LOCK TABLES `materialdifference` WRITE;
/*!40000 ALTER TABLE `materialdifference` DISABLE KEYS */;
INSERT INTO `materialdifference` VALUES (6056,'Cotton Fabric',0,'1'),(6056,'Nylon Fabric',0,'1'),(6056,'Silk Fabric',3456,'1'),(6056,'Wool Fabric',-1668,'1');
/*!40000 ALTER TABLE `materialdifference` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `order_details`
--

DROP TABLE IF EXISTS `order_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `order_details` (
  `order_no` int(11) NOT NULL,
  `item` varchar(20) NOT NULL,
  `country_origin` varchar(15) NOT NULL,
  `season` varchar(10) NOT NULL,
  `account_no` varchar(19) NOT NULL,
  `issueDate` varchar(20) NOT NULL,
  `endDate` varchar(20) NOT NULL,
  `supplier` varchar(15) NOT NULL,
  `supplier_no` int(11) NOT NULL,
  `country` varchar(20) NOT NULL,
  `delivary_mode` varchar(10) NOT NULL,
  `quntity` int(11) NOT NULL,
  `unit_price` double NOT NULL,
  `cost` double NOT NULL,
  PRIMARY KEY (`order_no`),
  UNIQUE KEY `Account_code_UNIQUE` (`account_no`),
  UNIQUE KEY `Order No_UNIQUE` (`order_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `order_details`
--

LOCK TABLES `order_details` WRITE;
/*!40000 ALTER TABLE `order_details` DISABLE KEYS */;
INSERT INTO `order_details` VALUES (1,'Skirt','Sri Lanka','AU12','142235426','2016-12-27','2016-12-27','POLO',1,'','Ocean',230,4.12,972),(2,'skirt','Sri Lanka','AU12','835601623','2016-12-27','2016-12-27','NIKE',2,'','Ocean',203,3.8,771.4),(3,'Blouse','select','AU23','584934839','2016-12-27','2016-12-27','PATAGONI',3,'','Ocean',340,3.1,1054),(5,'short','Sri Lanka','AU01','386456426','2016-12-27','2016-12-27','Grimx',10,'','Ocean',678,5,3390);
/*!40000 ALTER TABLE `order_details` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `packing_inspection`
--

DROP TABLE IF EXISTS `packing_inspection`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `packing_inspection` (
  `date` varchar(20) NOT NULL,
  `buyer` varchar(45) NOT NULL,
  `orderNo` int(11) NOT NULL,
  `orderQty` int(11) NOT NULL,
  `size` varchar(45) NOT NULL,
  `incorrectInfo` varchar(45) NOT NULL,
  `IncorrectPolyBagSize` varchar(45) NOT NULL,
  `cartonSizeOutOfSpec` varchar(45) NOT NULL,
  `contentIncorrect` varchar(45) NOT NULL,
  `quantityIncorrect` varchar(45) NOT NULL,
  `incorrectCartonMarks` varchar(45) NOT NULL,
  `poorCartonQuantity` varchar(45) NOT NULL,
  `other` varchar(45) NOT NULL,
  `describeOther` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`buyer`,`orderNo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `packing_inspection`
--

LOCK TABLES `packing_inspection` WRITE;
/*!40000 ALTER TABLE `packing_inspection` DISABLE KEYS */;
INSERT INTO `packing_inspection` VALUES ('2016-08-18','Lango',49,500,'XS','false','false','false','false','false','false','false','false',''),('2016-08-18','Lango',72,500,'XS','true','false','false','false','false','true','false','true',NULL),('2016-08-18','Lango',73,500,'M','true','false','false','true','false','false','false','true',NULL),('2016-08-18','M&S',74,500,'S','false','false','false','false','false','false','false','true',NULL),('2016-08-14','M&SNew',33,500,'XS','false','false','false','false','false','false','false','false',''),('2016-08-14','TOMMY',2,500,'XS','false','false','false','false','false','false','false','false','');
/*!40000 ALTER TABLE `packing_inspection` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `preventivemaintenance`
--

DROP TABLE IF EXISTS `preventivemaintenance`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `preventivemaintenance` (
  `pvLogID` varchar(45) NOT NULL,
  `assetID` varchar(45) DEFAULT NULL,
  `serialNum` varchar(45) DEFAULT NULL,
  `LSDate` varchar(45) DEFAULT NULL,
  `NSDate` varchar(45) DEFAULT NULL,
  `conditionDetails` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`pvLogID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `preventivemaintenance`
--

LOCK TABLES `preventivemaintenance` WRITE;
/*!40000 ALTER TABLE `preventivemaintenance` DISABLE KEYS */;
INSERT INTO `preventivemaintenance` VALUES ('JUKI-4556','VTW-857','GVH54678','2016-01-01','2016-09-02','Bearing was replaced'),('JUKI4455','VTW-004','FG467844','2016-03-01','2016-09-02','Needle reconditioned'),('JUKI4567','VTW-756','ADC456677','2016-07-01','2016-12-06','Electirlal system was replaced'),('JUKI567','VTW-758','NFJJJ4778','2016-08-01','2016-10-12','Needle replaced');
/*!40000 ALTER TABLE `preventivemaintenance` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `purchase_order`
--

DROP TABLE IF EXISTS `purchase_order`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `purchase_order` (
  `Company_code` int(11) NOT NULL,
  `Order_no` int(11) NOT NULL,
  `company_name` varchar(45) NOT NULL,
  `Supplier_code` int(11) NOT NULL,
  `Supplier_name` varchar(45) NOT NULL,
  `country_origin` varchar(45) NOT NULL,
  `Date` varchar(45) NOT NULL,
  `Country` varchar(45) NOT NULL,
  `shipment_mode` varchar(20) NOT NULL,
  `Currency` double NOT NULL,
  `Exchange_rate` double NOT NULL,
  `credit_trem` varchar(45) NOT NULL,
  PRIMARY KEY (`Company_code`),
  UNIQUE KEY `Supplier_code_UNIQUE` (`Supplier_code`),
  UNIQUE KEY `Company_code_UNIQUE` (`Company_code`),
  UNIQUE KEY `Order_no_UNIQUE` (`Order_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `purchase_order`
--

LOCK TABLES `purchase_order` WRITE;
/*!40000 ALTER TABLE `purchase_order` DISABLE KEYS */;
/*!40000 ALTER TABLE `purchase_order` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `purchaseorder`
--

DROP TABLE IF EXISTS `purchaseorder`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `purchaseorder` (
  `purchaseOrderID` int(11) NOT NULL,
  `styleNo` int(11) NOT NULL,
  `size` varchar(45) NOT NULL,
  `color` varchar(45) NOT NULL,
  `quantity` int(11) NOT NULL,
  `remarks` longtext NOT NULL,
  PRIMARY KEY (`purchaseOrderID`,`styleNo`,`size`,`color`),
  KEY `styleNo_idx` (`styleNo`),
  CONSTRAINT `fk_StyleNo` FOREIGN KEY (`styleNo`) REFERENCES `style` (`styleNo`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `purchaseorder`
--

LOCK TABLES `purchaseorder` WRITE;
/*!40000 ALTER TABLE `purchaseorder` DISABLE KEYS */;
INSERT INTO `purchaseorder` VALUES (1,3616,'L','Black',150,''),(1,3616,'L','White',150,''),(1,3616,'XL','Grey',50,''),(1,3616,'XXL','Black',100,'black buttons'),(1,4567,'M','White',1000,'First Order'),(1,4598,'M','Ginger',200,''),(1,5225,'S','Pumice',500,''),(1,6056,'L','White',200,''),(1,6056,'XXL','White',34,''),(2,3616,'M','Grey',500,''),(2,3616,'XXL','White',1500,''),(2,4510,'XXL','White',500,''),(3,5225,'M','Pumice',1200,'');
/*!40000 ALTER TABLE `purchaseorder` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `regularinformation`
--

DROP TABLE IF EXISTS `regularinformation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `regularinformation` (
  `BuyerName` varchar(45) NOT NULL,
  `SupplierNo` varchar(10) NOT NULL,
  `Season` date NOT NULL,
  `LaunchPack` varchar(5) NOT NULL,
  `Description` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`SupplierNo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `regularinformation`
--

LOCK TABLES `regularinformation` WRITE;
/*!40000 ALTER TABLE `regularinformation` DISABLE KEYS */;
INSERT INTO `regularinformation` VALUES ('M&S','11','2016-08-04','P21','sample discripton'),('Lango','12','2016-09-20','P24','sample discripton'),('M&S','22','2016-08-04','P21','sample discripton'),('M&S','25','2016-08-04','P21','sample discripton'),('Lango','32','2016-08-18','P21','discripton'),('M&S','43','2016-09-02','43','some'),('TOMMY','45','2016-08-08','45',' discripton'),('TOMMY','51','2016-08-23','P68','sample discripton'),('Lango','52','2016-08-04','P34','sample discripton'),('M&S','53','2016-08-04','P34','sample discripton'),('M&S','65','2016-08-04','P21','sample discripton'),('M&S','66','2016-08-04','P24','sample discripton'),('M&S','67','2016-08-27','P32','sample discripton'),('M&S','78','2016-08-04','P21','sample discripton'),('M&S','79','2016-08-17','P28','sample discripton'),('M&S','83','2016-08-04','P21','sample discripton'),('M&S','84','2016-08-04','P21','sample discripton'),('TOMMY','86','2016-12-20','86','sample discripton'),('TOMMY','89','2016-10-12','P21','sample discripton'),('M&S','99','2016-08-04','P21','sample discripton');
/*!40000 ALTER TABLE `regularinformation` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `return_goods`
--

DROP TABLE IF EXISTS `return_goods`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `return_goods` (
  `returnBy` varchar(45) NOT NULL,
  `productType` varchar(45) NOT NULL,
  `buyer` varchar(45) NOT NULL,
  `orderNo` int(11) NOT NULL,
  `DefectType` varchar(45) NOT NULL,
  `returnState` varchar(45) NOT NULL,
  PRIMARY KEY (`buyer`,`orderNo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `return_goods`
--

LOCK TABLES `return_goods` WRITE;
/*!40000 ALTER TABLE `return_goods` DISABLE KEYS */;
INSERT INTO `return_goods` VALUES ('Company','Skirt','Lango',23,'Cutting','Cannot Repair'),('Company','Shirt','TOMMY',29,'Trims','Cannot Repair'),('Customer','Shirt','TOMMY',33,'','Can Repair'),('Customer','Label','TOMMY',240,'Trims','Can Repair');
/*!40000 ALTER TABLE `return_goods` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `rg_type`
--

DROP TABLE IF EXISTS `rg_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rg_type` (
  `returnBy` varchar(20) NOT NULL,
  `productType` varchar(30) NOT NULL,
  PRIMARY KEY (`returnBy`,`productType`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rg_type`
--

LOCK TABLES `rg_type` WRITE;
/*!40000 ALTER TABLE `rg_type` DISABLE KEYS */;
INSERT INTO `rg_type` VALUES ('Company','Button'),('Company','Lable'),('Company','Zipper'),('Customer','Jacket'),('Customer','Jump Suit'),('Customer','Shirt'),('Customer','Skirt'),('Customer','Trouser');
/*!40000 ALTER TABLE `rg_type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `salary_info`
--

DROP TABLE IF EXISTS `salary_info`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `salary_info` (
  `SalaryId` int(11) NOT NULL AUTO_INCREMENT,
  `Month` varchar(10) NOT NULL,
  `Year` int(11) NOT NULL,
  `EmployeeNo` char(8) NOT NULL,
  `Name` varchar(100) NOT NULL,
  `EPFNo` char(5) NOT NULL,
  `BasicSalary` double NOT NULL,
  `EPF` double NOT NULL,
  `ETF` double DEFAULT NULL,
  `NoPayLeave` double DEFAULT NULL,
  `Deductions` double NOT NULL,
  `Bonus` double DEFAULT NULL,
  `OtAmount` double DEFAULT NULL,
  `GrossSalary` double NOT NULL,
  `NetSalary` double NOT NULL,
  PRIMARY KEY (`SalaryId`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `salary_info`
--

LOCK TABLES `salary_info` WRITE;
/*!40000 ALTER TABLE `salary_info` DISABLE KEYS */;
INSERT INTO `salary_info` VALUES (1,'September',2016,'emp-0004','C.P. Chamara Weerasekara','78942',25000,2000,750,1666.66,4416.66,2000,1562.5,28562.5,24145.83),(2,'September',2016,'emp-0002','C.P. Chamara Weerasekara','78945',25000,2000,750,1666.6666666666667,4416.666666666667,2000,781.25,27781.25,23364.583333333332);
/*!40000 ALTER TABLE `salary_info` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sample_approve`
--

DROP TABLE IF EXISTS `sample_approve`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sample_approve` (
  `Type` varchar(10) NOT NULL,
  `size` int(11) NOT NULL,
  `colour` varchar(20) NOT NULL,
  `styleNo` int(11) NOT NULL,
  `PONo` int(11) NOT NULL,
  `recivedQty` int(11) NOT NULL,
  `status` varchar(5) NOT NULL,
  `chkQuantity` int(11) NOT NULL,
  `rejectQuantity` int(11) NOT NULL,
  `defectType` varchar(25) NOT NULL,
  `remarks` varchar(50) DEFAULT NULL,
  `date` date NOT NULL,
  PRIMARY KEY (`styleNo`,`PONo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sample_approve`
--

LOCK TABLES `sample_approve` WRITE;
/*!40000 ALTER TABLE `sample_approve` DISABLE KEYS */;
INSERT INTO `sample_approve` VALUES ('Button',5,'Off White',312,97,1,'1',100,2,'Indentation',NULL,'2016-08-04'),('Button',3,'Perl White',1245,23,400,'1',200,5,'patches',NULL,'2016-08-04'),('Zipper',2,'black',2413,65,1,'1',100,45,'Indentation',NULL,'2016-09-04'),('Zipper',8,'dark blue',3111,25,100,'1',50,0,'no',NULL,'2016-08-04'),('Button',7,'Off White',3123,25,1,'0',100,50,'Indentation',NULL,'2016-08-04'),('Button',5,'Off White',3124,12,1,'0',100,2,'Indentation',NULL,'2016-08-04'),('Zipper',5,'Off White',3143,85,1,'0',100,2,'Indentation',NULL,'2016-08-09'),('Button',5,'Off White',3199,28,1,'0',100,2,'Indentation',NULL,'2016-08-04'),('Button',5,'Off White',3199,81,1,'1',100,2,'Indentation',NULL,'2016-08-04'),('Button',3,'Off White',3213,43,300,'false',150,2,'Indentation','','2016-08-04'),('Label',6,'Black',3921,35,200,'1',100,3,'wrog marks',NULL,'2016-08-04');
/*!40000 ALTER TABLE `sample_approve` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `stockissue`
--

DROP TABLE IF EXISTS `stockissue`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stockissue` (
  `stockissueID` int(11) NOT NULL AUTO_INCREMENT,
  `Date` varchar(11) DEFAULT NULL,
  `OrderID` int(11) NOT NULL,
  `Order_Type` varchar(45) NOT NULL,
  `To_Department` varchar(45) NOT NULL,
  `From_Department` varchar(45) NOT NULL,
  `To_location` varchar(45) NOT NULL,
  `Total_Amount` double NOT NULL,
  PRIMARY KEY (`stockissueID`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `stockissue`
--

LOCK TABLES `stockissue` WRITE;
/*!40000 ALTER TABLE `stockissue` DISABLE KEYS */;
INSERT INTO `stockissue` VALUES (1,'15-07-2016',8,'Cotton Fabric','muttm','nkr','V2',25),(3,'28-09-2016',465465,'Wool Fabric','njsrnjsy ','evt','CPU',5465645),(4,'21-09-2016',1234,'Wool Fabric','njsrnjsy ','evt','CPU',5000),(5,'21-09-2016',1234,'Wool Fabric','njsrnjsy ','evt','CPU',6000),(6,'21-09-2016',123,'Wool Fabric','njsrnjsy ','evt','CPU',435345);
/*!40000 ALTER TABLE `stockissue` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `stockorder`
--

DROP TABLE IF EXISTS `stockorder`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stockorder` (
  `OrderID` int(11) NOT NULL,
  `Date` varchar(12) DEFAULT NULL,
  `CompID` int(11) NOT NULL,
  `SupplierID` int(11) NOT NULL,
  `Order_Type` varchar(45) NOT NULL,
  `Delivery_Date` varchar(15) DEFAULT NULL,
  `Unit_price` double NOT NULL,
  `Total_Amount` double NOT NULL,
  `Payment_Method` varchar(45) NOT NULL,
  PRIMARY KEY (`OrderID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `stockorder`
--

LOCK TABLES `stockorder` WRITE;
/*!40000 ALTER TABLE `stockorder` DISABLE KEYS */;
INSERT INTO `stockorder` VALUES (1,'12-09-2016',1,1,'Cotton Fabric','12-09-2016',3445,45667,'Cash'),(2,'13-09-2016',2,2,'Single needle','13-09-2016',3465,34544,'Check'),(3,'11-09-2016',3,3,'Cotton Fabric','11-09-2016',3645,34546,'Check'),(4,'21-09-2016',4,4,'5 thread overlocks','21-09-2016',6000,34657,'Cash');
/*!40000 ALTER TABLE `stockorder` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `stockreceipt`
--

DROP TABLE IF EXISTS `stockreceipt`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stockreceipt` (
  `stockreceiptID` int(11) NOT NULL AUTO_INCREMENT,
  `Date` varchar(12) DEFAULT NULL,
  `Receipt_No` int(11) NOT NULL,
  `CompID` int(11) NOT NULL,
  `SupplierID` int(11) NOT NULL,
  `OrderID` int(11) NOT NULL,
  `Order_Type` varchar(45) NOT NULL,
  `Invoice_No` int(11) NOT NULL,
  `Invoice_Date` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`stockreceiptID`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `stockreceipt`
--

LOCK TABLES `stockreceipt` WRITE;
/*!40000 ALTER TABLE `stockreceipt` DISABLE KEYS */;
INSERT INTO `stockreceipt` VALUES (30,'09-08-2016',12,1,3,488,'Pearl stitch',23,'15-08-2016'),(31,'11-08-2016',50,5,2,429,'Overlock',34,'08-08-2016'),(32,'07-08-2016',56,4,3,722,'Single needle',86,'10-08-2016'),(33,'16-08-2016',36,6,4,266,'Wool Fabric',74,'11-08-2016');
/*!40000 ALTER TABLE `stockreceipt` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `stockrequistion`
--

DROP TABLE IF EXISTS `stockrequistion`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stockrequistion` (
  `StockrequistionID` int(11) NOT NULL AUTO_INCREMENT,
  `Date` varchar(14) DEFAULT NULL,
  `OrderID` int(11) NOT NULL,
  `Order_Type` varchar(45) NOT NULL,
  `Amount` int(11) NOT NULL,
  `Remarks` varchar(45) NOT NULL,
  `From_Department` varchar(45) NOT NULL,
  `To_Department` varchar(45) NOT NULL,
  `To_Location` int(11) NOT NULL,
  PRIMARY KEY (`StockrequistionID`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `stockrequistion`
--

LOCK TABLES `stockrequistion` WRITE;
/*!40000 ALTER TABLE `stockrequistion` DISABLE KEYS */;
INSERT INTO `stockrequistion` VALUES (19,'05-09-2016',1,'Nylon Fabric',54657,'expected','V4','V5',4),(20,'02-09-2016',7,'Iron',30000,'expected','V6','V8',8),(21,'12-09-2016',3,'Pearl stitch',57768,'expected','V3','V5',8),(23,'07-09-2016',4,'Iron',64646,'expected','V7','V5',8),(25,'01-09-2016',6,'Single needle',36457,'expected','V9','V8',8),(26,'02-09-2016',1,'Nylon Fabric',54657,'expected','V4','V5',4);
/*!40000 ALTER TABLE `stockrequistion` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `style`
--

DROP TABLE IF EXISTS `style`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `style` (
  `styleNo` int(4) NOT NULL,
  `buyer` varchar(45) NOT NULL,
  `prototype` varchar(45) NOT NULL,
  `factory` varchar(45) NOT NULL,
  `location` varchar(45) NOT NULL,
  `startDate` date NOT NULL,
  `endDate` date NOT NULL,
  PRIMARY KEY (`styleNo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `style`
--

LOCK TABLES `style` WRITE;
/*!40000 ALTER TABLE `style` DISABLE KEYS */;
INSERT INTO `style` VALUES (3616,'M&S','Trouser','VTW','V1','2016-08-05','2016-08-22'),(3968,'EddieBaur','Shirt','TGK','V1','2016-08-10','2016-08-30'),(4510,'Dean','Shirt','VTW','V2','2016-08-03','2016-08-13'),(4520,'Dean','Shirt','TGK','V2','2016-08-01','2016-08-17'),(4536,'Deutch','Denim','VTW','V3','2016-08-10','2016-08-27'),(4567,'Tommy','Touser','TGK','V2','2016-08-18','2016-08-30'),(4598,'Deutch','Dress','VTW','V3','2016-08-28','2016-09-15'),(5225,'EddieBaur','Trouser','TGK','V1','2016-08-31','2016-09-22'),(6056,'M&S','Long Dress','VTW','V1','2016-08-23','2016-09-09'),(6098,'M&S','Trouser','VTW','V1','2016-09-10','2016-09-28'),(8716,'Lewis','Denim','VTW','V2','2016-08-14','2016-08-25');
/*!40000 ALTER TABLE `style` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `stylemanamount`
--

DROP TABLE IF EXISTS `stylemanamount`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stylemanamount` (
  `styleNo` int(4) NOT NULL,
  `direct` int(11) DEFAULT NULL,
  `indirect` int(11) DEFAULT NULL,
  `total` int(11) DEFAULT NULL,
  `difference` int(11) DEFAULT '0',
  `type` varchar(45) DEFAULT 's',
  PRIMARY KEY (`styleNo`),
  CONSTRAINT `fk2_StyleNo` FOREIGN KEY (`styleNo`) REFERENCES `style` (`styleNo`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `stylemanamount`
--

LOCK TABLES `stylemanamount` WRITE;
/*!40000 ALTER TABLE `stylemanamount` DISABLE KEYS */;
INSERT INTO `stylemanamount` VALUES (3616,39,9,48,0,'s'),(3968,40,10,50,0,'s'),(4510,35,10,45,0,'s'),(4520,38,8,46,0,'s'),(4536,23,10,33,0,'s'),(4598,60,20,80,0,'s'),(5225,45,8,53,0,'s'),(6056,34,6,40,0,'s'),(6098,50,10,60,0,'s'),(8716,40,10,50,0,'s');
/*!40000 ALTER TABLE `stylemanamount` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `stylematerial`
--

DROP TABLE IF EXISTS `stylematerial`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stylematerial` (
  `styleNo` int(4) NOT NULL,
  `materialNo` int(11) NOT NULL,
  `type` varchar(45) NOT NULL,
  `color` varchar(45) NOT NULL,
  `quantity` float NOT NULL,
  `remarks` varchar(45) DEFAULT NULL,
  `difference` int(11) DEFAULT '5',
  PRIMARY KEY (`styleNo`,`materialNo`,`type`,`color`),
  CONSTRAINT `fk_StyleNoMaterial` FOREIGN KEY (`styleNo`) REFERENCES `style` (`styleNo`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `stylematerial`
--

LOCK TABLES `stylematerial` WRITE;
/*!40000 ALTER TABLE `stylematerial` DISABLE KEYS */;
INSERT INTO `stylematerial` VALUES (3616,1,'Silk Fabric','Grey',1000,'',5),(3616,1,'Silk Fabric','White',3456,'mix with Wool Fabric',5),(3616,1,'Wool Fabric','Black',900.6,'',5),(3616,2,'Cotton Fabric','Baltic',10000,'',5),(3616,2,'Nylon Fabric','Taupe Mix',1500,'',5),(3616,2,'Wool Fabric','Baltic',3500,'',5),(3968,1,'Wool Fabric','Silver',2450,'',5),(4510,1,'Cotton Fabric','Baltic',3000,'',5),(4598,1,'Wool Fabric','Baltic',7800,'',5),(5225,1,'Cotton Fabric','Grey',5000,'',5),(6056,1,'Cotton Fabric','Black',5000,'',5),(6056,1,'Cotton Fabric','White',8000,'',5),(6056,1,'Wool Fabric','Black',2568,'',5),(6098,1,'Nylon Fabric','Baltic',5000,'',5),(6098,1,'Wool Fabric','Pumice',4500,'',5),(6098,2,'Cotton Fabric','Baltic',4500,'',5);
/*!40000 ALTER TABLE `stylematerial` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `styleoperation`
--

DROP TABLE IF EXISTS `styleoperation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `styleoperation` (
  `styleNo` int(4) NOT NULL,
  `operationNo` int(11) NOT NULL,
  `type` varchar(45) NOT NULL,
  `machine` varchar(45) NOT NULL,
  `quantity` int(11) NOT NULL,
  `speciality` varchar(45) NOT NULL,
  `remarks` varchar(45) NOT NULL,
  `mc` double NOT NULL,
  `ma` double NOT NULL,
  PRIMARY KEY (`styleNo`,`operationNo`),
  CONSTRAINT `fk_STyleNoOperation` FOREIGN KEY (`styleNo`) REFERENCES `style` (`styleNo`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `styleoperation`
--

LOCK TABLES `styleoperation` WRITE;
/*!40000 ALTER TABLE `styleoperation` DISABLE KEYS */;
INSERT INTO `styleoperation` VALUES (3616,1,'Tack Lable','5 Thread Overlock',5,'Without Lights','Start Of Style',0.75,1),(3616,2,'Bundle & sort','Overlock',4,'Extra Table','',1.2,1.8),(3616,3,'Sew loop','Overlock',6,'With Light','',1.7999999999999998,2.7),(3616,4,'Measure & cut loop','Single Needle',10,'Without Lights','',1.2,1.5),(3616,5,'Fold & iron waist band','Iron',5,'Without Lights','',6.5,7.25),(6056,1,'Tack Lable','5 Thread Overlock',4,'Without Lights','',0.6,0.8),(6056,2,'Bundle & sort','Overlock',4,'Extra Table','',1.92,2.2800000000000002),(6056,3,'Measure & cut loop','Single Needle',5,'Without Lights','',0.6,0.75),(6056,4,'Join waist band','Pearl Stitch',4,'With Light','',0.52,0.6),(6056,5,'Tack fly box Ovl thread edge','5 Thread Overlock',4,'With Light','',0.6,0.8),(6098,1,'Tack Lable','Single Needle',3,'Without Lights','',0.36,0.44999999999999996),(6098,2,'Bundle & sort','5 Thread Overlock',4,'Without Lights','',0.6,0.8),(6098,3,'Measure & cut loop','Pearl Stitch',6,'With Light','',0.78,0.8999999999999999),(6098,4,'Fold & iron waist band','Iron',3,'Extra Table','',3.9000000000000004,4.35);
/*!40000 ALTER TABLE `styleoperation` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `supplier_details`
--

DROP TABLE IF EXISTS `supplier_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `supplier_details` (
  `Supplier_Code` varchar(45) NOT NULL,
  `Supplier` varchar(45) NOT NULL,
  `email` varchar(50) NOT NULL,
  `Date` varchar(45) NOT NULL,
  `Description` varchar(50) NOT NULL,
  `Cost` double NOT NULL,
  `Delivary_Mode` varchar(10) NOT NULL,
  `Currency` double NOT NULL,
  `Country` varchar(45) NOT NULL,
  PRIMARY KEY (`Supplier_Code`),
  UNIQUE KEY `E-mail_UNIQUE` (`email`),
  UNIQUE KEY `Supplier_Code_UNIQUE` (`Supplier_Code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `supplier_details`
--

LOCK TABLES `supplier_details` WRITE;
/*!40000 ALTER TABLE `supplier_details` DISABLE KEYS */;
INSERT INTO `supplier_details` VALUES ('123','afsf','fasfs','2016-08-03','safsf',4124,'Ocean',214,'asff'),('224','sfasrf','rwrr','2016-08-11','rrr',3434,'Ocean',414,'sdgd'),('2414','safsf','sfasf','2016-08-04','sfsf',424,'Ocean',2424,'sdsdf'),('242','dfsdf','42424fsdfsdf','2016-08-11','fsdfsdf',24214,'Ocean',412,'dfdf'),('2424','erwer','rrer','2016-08-05','erer',2224,'Ocean',2424,'sfdf'),('3123','asfsf','waf','2016-08-04','sdfsd',214,'Ocean',124,'sfdgd'),('4124','asfs','fasf','2016-08-04','safsa',1424,'Ocean',2324,'sfsf'),('4214','fafasf','fdsff','2016-08-05','fdsf',4342,'Ocean',24,'fff'),('5','sup',' 2','2016-12-02','df',22,'Ocean',2,'ee'),('9','ffffffffff','fffffffffffffff','2016-08-04','ffffff',12,'Ocean',56,'fffffffff');
/*!40000 ALTER TABLE `supplier_details` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `utilitybreakdown`
--

DROP TABLE IF EXISTS `utilitybreakdown`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `utilitybreakdown` (
  `utilityBreakdownID` varchar(45) NOT NULL,
  `utilityType` varchar(45) DEFAULT NULL,
  `date` varchar(45) DEFAULT NULL,
  `repoter` varchar(45) DEFAULT NULL,
  `locationDetails` varchar(45) DEFAULT NULL,
  `breakdownDetails` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`utilityBreakdownID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `utilitybreakdown`
--

LOCK TABLES `utilitybreakdown` WRITE;
/*!40000 ALTER TABLE `utilitybreakdown` DISABLE KEYS */;
INSERT INTO `utilitybreakdown` VALUES ('ELEC4354','Steam Distribution System','2016-08-11','MEC-5567','KOK-LINE3343','A Replacement '),('ELEC4567','Electrical System','2016-08-11','MEC-4567','KOK-CPU005','A Replacement '),('ELEC4568','Generator','2016-08-03','MEC-5567','KOK-CPU005','NEED QUICK ATTENTION'),('MEC127','Generator','','ENG-400000','VET-LINE4456','Need quick attention'),('MEC5678','Steam Distribution','2016-05-11','ENG-0034','KOK-CPU005','An Electrical Repair'),('MECH556','Electrical System','2016-08-13','ELEC-4567','vet-005678','A Mechanical Repair');
/*!40000 ALTER TABLE `utilitybreakdown` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `vehicle`
--

DROP TABLE IF EXISTS `vehicle`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vehicle` (
  `vehicle_number` varchar(8) NOT NULL,
  `vehicle_type` varchar(10) NOT NULL,
  `vehicle_capacity` int(3) NOT NULL,
  `route` char(7) DEFAULT NULL,
  `driverAssigned` char(1) DEFAULT NULL,
  `avalable_capacity` int(3) DEFAULT NULL,
  PRIMARY KEY (`vehicle_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vehicle`
--

LOCK TABLES `vehicle` WRITE;
/*!40000 ALTER TABLE `vehicle` DISABLE KEYS */;
INSERT INTO `vehicle` VALUES ('AB-7474','Bus',60,'Route C','Y',60),('CAA-4785','Bus',40,'Route C','Y',40),('KE-0877','Bus',40,'Route A','Y',-60),('KK-7575','Bus',60,'Route B','Y',60),('LC-6523','Lorry',20000,'Route B','N',20000),('NA-2465','Lorry',12000,'Route B','N',12000);
/*!40000 ALTER TABLE `vehicle` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2017-03-05  6:36:03