/*!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_purabi`;
CREATE DATABASE `pos_purabi` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `pos_purabi`;
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 (1,'PURABI','19ARIPS6603G1ZI','2022-04-01','2023-03-31','pos_purabi2223','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=10 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');
INSERT INTO `customer` VALUES (5,'testing 1st','1234567890');
INSERT INTO `customer` VALUES (6,'testing 1st','1234567890');
INSERT INTO `customer` VALUES (7,'testing 1st','1234567890');
INSERT INTO `customer` VALUES (8,'testing 1st','1234567890');
INSERT INTO `customer` VALUES (9,'testing 1st','1234567890');
CREATE TABLE `loc` (
  `LOCID` int(11) NOT NULL AUTO_INCREMENT,
  `LOCCODE` varchar(2) DEFAULT '-',
  `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=3 DEFAULT CHARSET=latin1;
INSERT INTO `loc` VALUES (1,'TH','TOWN HALL','G. T. ROAD','BURDWAN','9999999999','9999999999','email@TownHall','I00001','TOWN HALL');
INSERT INTO `loc` VALUES (2,'PL','POLICE LINE','G. T. ROAD','BURDWAN','9999999999','9999999999','email@PoliceLine','I00002','POLICE LINE');
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 '-',
  `SMSOTP` varchar(10) DEFAULT '-',
  `SMSDATE` date DEFAULT '2001-01-01',
  `EMAIL` varchar(30) DEFAULT '-',
  `MOBILE` varchar(15) DEFAULT '-',
  `USERROLE` int(3) DEFAULT '0',
  `ISACTIVE` int(3) DEFAULT '1',
  `ISSALESPERSON` int(11) DEFAULT '0',
  `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=3 DEFAULT CHARSET=latin1;
INSERT INTO `login` VALUES (2,'ADMIN','1234','1','EXbfF2T4/c6gc','7386','2023-02-10','amitava.esi@gmail.com','-',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,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=3 DEFAULT CHARSET=latin1;
INSERT INTO `wh` VALUES (1,1,'TOWN HALL',1);
INSERT INTO `wh` VALUES (2,2,'POLICE LINE',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=3 DEFAULT CHARSET=latin1;
INSERT INTO `whmap` VALUES (1,1,1);
INSERT INTO `whmap` VALUES (2,2,2);

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