/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40103 SET SQL_NOTES='ON' */;


DROP DATABASE IF EXISTS `pos`;
CREATE DATABASE `pos` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `pos`;
CREATE TABLE `compinf` (
  `sl` int(1) NOT NULL DEFAULT '0',
  `C_NAME` varchar(50) DEFAULT 'null',
  `GSTIN` varchar(50) DEFAULT '-',
  `s_opdt` date DEFAULT '0000-00-00',
  `s_cldt` date DEFAULT '0000-00-00',
  `DBNAME` varchar(30) DEFAULT 'null',
  `selected` char(1) DEFAULT 'N',
  PRIMARY KEY (`sl`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `compinf` VALUES (4,'KONAR DIST','19AAJFP6705A1ZD','2019-04-01','2020-03-31','pos2122','Y');
CREATE TABLE `customer` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `CUSTNAME` varchar(30) DEFAULT '-',
  `MOBILE` varchar(15) DEFAULT '-',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
INSERT INTO `customer` VALUES (1,'1ST CUSTOMER','9563356053');
INSERT INTO `customer` VALUES (2,'2ND CUSTOMER','7001624904');
INSERT INTO `customer` VALUES (3,'3RD CUSTOMER','7001624913');
INSERT INTO `customer` VALUES (4,'4TH CUSTOMER','7797795423');
CREATE TABLE `loc` (
  `LOCID` int(11) NOT NULL AUTO_INCREMENT,
  `LOCNAME` varchar(50) DEFAULT NULL,
  `ADDRESS1` varchar(30) DEFAULT '',
  `ADDRESS2` varchar(60) DEFAULT '',
  `MOB1` varchar(15) DEFAULT '',
  `MOB2` varchar(15) DEFAULT '',
  `EMAIL` varchar(50) DEFAULT '',
  `CASHACCT` varchar(10) DEFAULT '-',
  `LOCPRINT` varchar(30) DEFAULT '-',
  PRIMARY KEY (`LOCID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
INSERT INTO `loc` VALUES (1,'FIRST LOC','CC','DD','9234567890','9345678901','SKSSKS','I00001','-');
INSERT INTO `loc` VALUES (2,'SECOND LOCATION','SJD','DDDK','1234567890','23568797100','DD','I00002','-');
INSERT INTO `loc` VALUES (3,'THIRD LOC','BWN','WB','1234567890','1234567890','NO MAIL','I00003','THIRD LOC PRINT NAME');
CREATE TABLE `logdet` (
  `LogId` int(11) NOT NULL AUTO_INCREMENT,
  `UserName` varchar(10) DEFAULT '-',
  `EmpName` varchar(30) DEFAULT '-',
  `HostName` varchar(30) DEFAULT '-',
  `IPAdd` varchar(30) DEFAULT '-',
  `UserInDate` date DEFAULT '1900-01-01',
  `UserOutDate` date DEFAULT '1900-01-01',
  `UserInTime` time DEFAULT '00:00:00',
  `UserOutTime` time DEFAULT '00:00:00',
  PRIMARY KEY (`LogId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `login` (
  `UID` int(11) NOT NULL AUTO_INCREMENT,
  `EMPNAME` varchar(30) DEFAULT '+',
  `EMPID` varchar(10) DEFAULT '-',
  `USERID` varchar(15) DEFAULT '-',
  `USERPWD` varchar(15) DEFAULT '-',
  `USERROLE` int(3) DEFAULT '0',
  `ISACTIVE` int(3) DEFAULT '1',
  `LOCID` int(3) DEFAULT '0',
  `C1` int(1) DEFAULT '0',
  `C2` int(1) DEFAULT '0',
  `C3` int(1) DEFAULT '0',
  `C4` int(1) DEFAULT '0',
  `C5` int(1) DEFAULT '0',
  `C6` int(1) DEFAULT '0',
  `C7` int(1) DEFAULT '0',
  `C8` int(1) DEFAULT '0',
  `C9` int(1) DEFAULT '0',
  `C10` int(1) DEFAULT '0',
  `C11` int(1) DEFAULT '0',
  `C12` int(1) DEFAULT '0',
  `C13` int(1) DEFAULT '0',
  `C14` int(1) DEFAULT '0',
  `C15` int(1) DEFAULT '0',
  `C16` int(1) DEFAULT '0',
  `C17` int(1) DEFAULT '0',
  `C18` int(1) DEFAULT '0',
  `C19` int(1) DEFAULT '0',
  `C20` int(1) DEFAULT '0',
  `C21` int(1) DEFAULT '0',
  `C22` int(1) DEFAULT '0',
  `C23` int(1) DEFAULT '0',
  `C24` int(1) DEFAULT '0',
  `C25` int(1) DEFAULT '0',
  `C26` int(1) DEFAULT '0',
  `C27` int(1) DEFAULT '0',
  `C28` int(1) DEFAULT '0',
  `C29` int(1) DEFAULT '0',
  `C30` int(1) DEFAULT '0',
  `C31` int(1) DEFAULT '0',
  `C32` int(1) DEFAULT '0',
  `C33` int(1) DEFAULT '0',
  `C34` int(1) DEFAULT '0',
  `C35` int(1) DEFAULT '0',
  `C36` int(1) DEFAULT '0',
  `C37` int(1) DEFAULT '0',
  `C38` int(1) DEFAULT '0',
  `C39` int(1) DEFAULT '0',
  `C40` int(1) DEFAULT '0',
  `C41` int(1) DEFAULT '0',
  `C42` int(1) DEFAULT '0',
  `C43` int(1) DEFAULT '0',
  `C44` int(1) DEFAULT '0',
  `C45` int(1) DEFAULT '0',
  `C46` int(1) DEFAULT '0',
  `C47` int(1) DEFAULT '0',
  `C48` int(1) DEFAULT '0',
  `C49` int(1) DEFAULT '0',
  `C50` int(1) DEFAULT '0',
  `C51` int(1) DEFAULT '0',
  `C52` int(1) DEFAULT '0',
  `C53` int(1) DEFAULT '0',
  `C54` int(1) DEFAULT '0',
  `C55` int(1) DEFAULT '0',
  `C56` int(1) DEFAULT '0',
  `C57` int(1) DEFAULT '0',
  `C58` int(1) DEFAULT '0',
  `C59` int(1) DEFAULT '0',
  `C60` int(1) DEFAULT '0',
  `C61` int(1) DEFAULT '0',
  `C62` int(1) DEFAULT '0',
  `C63` int(1) DEFAULT '0',
  `C64` int(1) DEFAULT '0',
  `C65` int(1) DEFAULT '0',
  PRIMARY KEY (`UID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
INSERT INTO `login` VALUES (2,'POS USER','1234','1','1',1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,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);
CREATE TABLE `wh` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `WHID` int(3) DEFAULT '0',
  `WHNAME` varchar(30) DEFAULT '-',
  `ISACTIVE` int(3) DEFAULT '1',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
INSERT INTO `wh` VALUES (1,1,'WEAR HOUSE 1',1);
INSERT INTO `wh` VALUES (2,2,'WEAR HOUSE 2',1);
INSERT INTO `wh` VALUES (3,3,'WEAR HOUSE 3',1);
CREATE TABLE `whmap` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `WHID` int(3) DEFAULT '0',
  `LOCID` int(3) DEFAULT '0',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
INSERT INTO `whmap` VALUES (1,1,1);
INSERT INTO `whmap` VALUES (2,1,1);
INSERT INTO `whmap` VALUES (4,1,1);
INSERT INTO `whmap` VALUES (5,2,1);
INSERT INTO `whmap` VALUES (6,2,2);
INSERT INTO `whmap` VALUES (7,2,3);
INSERT INTO `whmap` VALUES (8,3,1);
INSERT INTO `whmap` VALUES (9,3,2);
INSERT INTO `whmap` VALUES (10,3,3);

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;