-- MySQL dump 10.13  Distrib 5.7.20, for Linux (x86_64)
--
-- Host: localhost    Database: pos
-- ------------------------------------------------------
-- Server version	5.7.20-0ubuntu0.17.10.1

/*!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 `customer`
--

DROP TABLE IF EXISTS `customer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `customer` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Customer_Name` varchar(100) NOT NULL,
  `Customer_No` bigint(20) NOT NULL,
  `Customer_Address` varchar(150) NOT NULL,
  `Postcode` int(5) NOT NULL,
  `Create_Date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Discont_Date` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `customer`
--

LOCK TABLES `customer` WRITE;
/*!40000 ALTER TABLE `customer` DISABLE KEYS */;
INSERT INTO `customer` VALUES (7,'aaa',1234,'abcd',0,'2017-08-07 17:18:39','2017-10-24 18:42:12'),(8,'test',8998989,'test',70009,'2017-10-25 02:30:23','2018-01-04 23:50:41'),(9,'test2',5465465,'dsfgfdg',56756,'2017-10-25 02:37:47','2018-01-04 14:32:36'),(10,'kaya',650,'bocklinstr',1020,'2018-01-04 14:28:37',NULL),(11,'max musterman',69911111111,'schlachthausgasse 48',1030,'2018-01-04 14:30:54',NULL),(12,'Firma RexxPOS',1111111,'salmgasse 2',1030,'2018-01-04 14:33:47',NULL),(13,'WU Wien',13823,'Welthandelsplatz',1020,'2018-01-04 23:51:05',NULL);
/*!40000 ALTER TABLE `customer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `invoice`
--

DROP TABLE IF EXISTS `invoice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `invoice` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `CustomerID` int(11) NOT NULL,
  `OrderComments` varchar(200) DEFAULT NULL,
  `OrderAmount` double(10,6) NOT NULL,
  `CreateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `DiscontDate` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `I_CusId_Fk` (`CustomerID`),
  CONSTRAINT `I_CusId_Fk` FOREIGN KEY (`CustomerID`) REFERENCES `customer` (`ID`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `invoice`
--

LOCK TABLES `invoice` WRITE;
/*!40000 ALTER TABLE `invoice` DISABLE KEYS */;
INSERT INTO `invoice` VALUES (5,8,'',40.800000,'2017-11-14 17:48:53',NULL),(6,8,'',30.000000,'2017-11-14 18:28:30',NULL),(7,9,'',19.200000,'2017-11-28 15:43:24','2017-12-02 02:41:54'),(8,8,'Kredit',21.600000,'2017-12-02 03:33:29',NULL),(9,8,'Bar',5.500000,'2017-12-02 03:55:59','2017-12-02 04:08:49'),(10,8,'Bar',5.500000,'2017-12-02 04:27:04',NULL),(11,8,'',17.500000,'2017-12-02 06:19:54',NULL),(12,8,'Bar',5.500000,'2017-12-02 06:21:08',NULL),(13,8,'',5.500000,'2017-12-02 06:24:42',NULL),(14,9,'Kredit',12.000000,'2017-12-02 13:51:51','2018-01-05 15:02:40'),(15,9,'',54.000000,'2017-12-02 23:24:38',NULL),(16,9,'',20.400000,'2017-12-03 16:20:50',NULL),(17,8,'',5.500000,'2017-12-12 12:05:17',NULL),(18,10,'',10.800000,'2018-01-06 15:27:41',NULL),(19,10,'',0.000000,'2018-01-06 15:28:55',NULL),(20,10,'',0.000000,'2018-01-06 15:29:04',NULL),(21,10,'',9.600000,'2018-01-08 22:46:30',NULL),(22,11,'',20.400000,'2018-01-09 13:30:41',NULL);
/*!40000 ALTER TABLE `invoice` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `invoice_details`
--

DROP TABLE IF EXISTS `invoice_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `invoice_details` (
  `ItemName` varchar(100) DEFAULT NULL,
  `Quantity` varchar(10) DEFAULT NULL,
  `ItemTax` varchar(3) DEFAULT NULL,
  `ItemPrice` varchar(20) DEFAULT NULL,
  `TotalAmount` varchar(20) DEFAULT NULL,
  `InvoiceID` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `invoice_details`
--

LOCK TABLES `invoice_details` WRITE;
/*!40000 ALTER TABLE `invoice_details` DISABLE KEYS */;
INSERT INTO `invoice_details` VALUES ('pizza salami','2','20','8.0','19.2','5'),('pasta spinaci','2','20','9.0','21.6','5'),('pizza salami','2','20','8.0','19.2','6'),('pasta spinaci','1','20','9.0','10.8','6'),('pizza salami','2','20','8.0','19.2','7'),('pizza salami','1','20','8.0','9.6','8'),('chicken salami with x','1','20','10.0','12.0','8'),('test','1','10','5.0','5.5','9'),('test','1','10','5.0','5.5','10'),('test','1','10','5.0','5.5','11'),('chicken salami with x','1','20','10.0','12.0','11'),('test','1','10','5.0','5.5','12'),('test','1','10','5.0','5.5','13'),('chicken salami with x','1','20','10.0','12.0','14'),('pizza salami','1','20','8.0','9.6','15'),('chicken salami with x','2','20','10.0','24.0','15'),('pasta pronto','1','20','8.0','9.6','15'),('pasta spinaci','1','20','9.0','10.8','15'),('pizza hawai','1','20','9.0','10.8','16'),('pizza salami','1','20','8.0','9.6','16'),('test','1','10','5.0','5.5','17'),('pizza hawai','1','20','9.0','10.8','18'),('pizza salami','1','20','8.0','9.6','21'),('pizza hawai','1','20','9.0','10.8','22'),('pizza salami','1','20','8.0','9.6','22');
/*!40000 ALTER TABLE `invoice_details` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `item`
--

DROP TABLE IF EXISTS `item`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `item` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `ItemType` varchar(100) NOT NULL,
  `ItemName` varchar(100) NOT NULL,
  `ItemTax` int(3) NOT NULL,
  `ItemPrice` decimal(10,3) NOT NULL,
  `CreateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `DiscontDate` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `item`
--

LOCK TABLES `item` WRITE;
/*!40000 ALTER TABLE `item` DISABLE KEYS */;
INSERT INTO `item` VALUES (4,'test','test',10,5.000,'2017-08-07 21:51:33','2017-08-07 22:04:44'),(5,'pizza','pizza salami',20,8.000,'2017-08-07 21:53:05',NULL),(6,'pasta','pasta pronto',20,8.000,'2017-08-07 21:53:20',NULL),(7,'pizza','pizza hawai',20,9.000,'2017-08-07 22:05:00',NULL),(8,'pasta','pasta spinaci',20,9.000,'2017-08-07 22:05:17',NULL),(9,'pizza','chicken salami with x',20,10.000,'2017-11-08 02:17:48',NULL),(10,'drink','cola',20,3.000,'2018-01-04 22:51:33',NULL),(11,'nacspeise','tiramisu',10,4.500,'2018-01-04 22:59:33','2018-01-05 00:00:44'),(12,'nachspeise','tiramisu',10,4.500,'2018-01-04 23:01:47',NULL),(13,'nachspeise','mohr im hemd',10,4.500,'2018-01-04 23:03:03',NULL),(14,'test','testaa',20,5.000,'2018-01-06 13:26:01','2018-01-06 13:28:14');
/*!40000 ALTER TABLE `item` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `print_settings`
--

DROP TABLE IF EXISTS `print_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `print_settings` (
  `name` varchar(50) DEFAULT NULL,
  `address` varchar(100) DEFAULT NULL,
  `phoneno` varchar(30) DEFAULT NULL,
  `cashboxid` varchar(100) DEFAULT NULL,
  `companyid` varchar(100) DEFAULT NULL,
  `aeskey` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `print_settings`
--

LOCK TABLES `print_settings` WRITE;
/*!40000 ALTER TABLE `print_settings` DISABLE KEYS */;
INSERT INTO `print_settings` VALUES ('RexxPOS v1','Hello World Street 2','0122222','CASHBOX-POS','U:ATU12345678','WQRtiiya3hYh/Uz44Bv3x8ETl1nrH6nCdErn69g5/lU=');
/*!40000 ALTER TABLE `print_settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `user_name` varchar(30) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES ('admin','admin123');
/*!40000 ALTER TABLE `users` 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 2018-01-10 22:02:17
