

DROP DATABASE IF EXISTS `pos_konar`;
CREATE DATABASE `pos_konar` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `pos_konar`;
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','pos_konar2223','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 `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);

