

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 `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);

