· 7 years ago · Dec 12, 2018, 06:32 AM
1-- MySQL dump 10.13 Distrib 5.7.17, for Linux (x86_64)
2--
3-- Host: 127.0.0.1 Database: appetite_till
4-- ------------------------------------------------------
5-- Server version 5.6.35
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `IMPORT_AUDIT`
20--
21
22DROP TABLE IF EXISTS `IMPORT_AUDIT`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `IMPORT_AUDIT` (
26 `IMPORT_ID` bigint(20) NOT NULL AUTO_INCREMENT,
27 `TIMESTAMP` datetime DEFAULT NULL,
28 `IMPORT_FILE` varchar(255) DEFAULT NULL,
29 PRIMARY KEY (`IMPORT_ID`)
30) ENGINE=InnoDB AUTO_INCREMENT=2201 DEFAULT CHARSET=latin1;
31/*!40101 SET character_set_client = @saved_cs_client */;
32
33--
34-- Table structure for table `JOURNAL_BILLS`
35--
36
37DROP TABLE IF EXISTS `JOURNAL_BILLS`;
38/*!40101 SET @saved_cs_client = @@character_set_client */;
39/*!40101 SET character_set_client = utf8 */;
40CREATE TABLE `JOURNAL_BILLS` (
41 `BILL_ID` bigint(20) NOT NULL AUTO_INCREMENT,
42 `EVENT_DATE` datetime DEFAULT NULL,
43 `EVENT_TIME` datetime DEFAULT NULL,
44 `CLERK_ID` varchar(255) DEFAULT NULL,
45 `CLERK` varchar(255) DEFAULT NULL,
46 `SEQUENCE` varchar(255) DEFAULT NULL,
47 `TRAINING` tinyint(1) DEFAULT NULL,
48 `SUBTOTAL` decimal(19,2) DEFAULT NULL,
49 `VAT` decimal(19,2) DEFAULT NULL,
50 `TENDER` varchar(255) DEFAULT NULL,
51 `PAYMENT` decimal(19,2) DEFAULT NULL,
52 `CUST_CHANGE` decimal(19,2) DEFAULT NULL,
53 `DISCOUNT` decimal(19,2) DEFAULT NULL,
54 `TOTAL` decimal(19,2) DEFAULT NULL,
55 `TILL_ID` bigint(20) NOT NULL,
56 PRIMARY KEY (`BILL_ID`),
57 KEY `FKE86816043B0323F0` (`TILL_ID`),
58 CONSTRAINT `FKE86816043B0323F0` FOREIGN KEY (`TILL_ID`) REFERENCES `TILL` (`TIll_ID`)
59) ENGINE=InnoDB AUTO_INCREMENT=235139 DEFAULT CHARSET=latin1;
60/*!40101 SET character_set_client = @saved_cs_client */;
61
62--
63-- Table structure for table `JOURNAL_CA_CHK`
64--
65
66DROP TABLE IF EXISTS `JOURNAL_CA_CHK`;
67/*!40101 SET @saved_cs_client = @@character_set_client */;
68/*!40101 SET character_set_client = utf8 */;
69CREATE TABLE `JOURNAL_CA_CHK` (
70 `CA_CHK_ID` bigint(20) NOT NULL AUTO_INCREMENT,
71 `EVENT_DATE` datetime DEFAULT NULL,
72 `EVENT_TIME` datetime DEFAULT NULL,
73 `CLERK_ID` varchar(255) DEFAULT NULL,
74 `CLERK` varchar(255) DEFAULT NULL,
75 `SEQUENCE` varchar(255) DEFAULT NULL,
76 `TRAINING` tinyint(1) DEFAULT NULL,
77 `TOTAL` decimal(19,2) DEFAULT NULL,
78 `TILL_ID` bigint(20) NOT NULL,
79 PRIMARY KEY (`CA_CHK_ID`),
80 KEY `FK25E7474D3B0323F0` (`TILL_ID`),
81 CONSTRAINT `FK25E7474D3B0323F0` FOREIGN KEY (`TILL_ID`) REFERENCES `TILL` (`TIll_ID`)
82) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
83/*!40101 SET character_set_client = @saved_cs_client */;
84
85--
86-- Table structure for table `JOURNAL_LINES`
87--
88
89DROP TABLE IF EXISTS `JOURNAL_LINES`;
90/*!40101 SET @saved_cs_client = @@character_set_client */;
91/*!40101 SET character_set_client = utf8 */;
92CREATE TABLE `JOURNAL_LINES` (
93 `LINE_ID` bigint(20) NOT NULL AUTO_INCREMENT,
94 `PRODUCT` varchar(255) DEFAULT NULL,
95 `QUANTITY` int(11) DEFAULT NULL,
96 `UNIT_PRICE` decimal(19,2) DEFAULT NULL,
97 `LINE_TOTAL` decimal(19,2) DEFAULT NULL,
98 `BILL_ID` bigint(20) DEFAULT NULL,
99 PRIMARY KEY (`LINE_ID`),
100 KEY `FKE8F507B7BF58F91B` (`BILL_ID`),
101 CONSTRAINT `FKE8F507B7BF58F91B` FOREIGN KEY (`BILL_ID`) REFERENCES `JOURNAL_BILLS` (`BILL_ID`)
102) ENGINE=InnoDB AUTO_INCREMENT=658626 DEFAULT CHARSET=latin1;
103/*!40101 SET character_set_client = @saved_cs_client */;
104
105--
106-- Table structure for table `JOURNAL_NO_SALE`
107--
108
109DROP TABLE IF EXISTS `JOURNAL_NO_SALE`;
110/*!40101 SET @saved_cs_client = @@character_set_client */;
111/*!40101 SET character_set_client = utf8 */;
112CREATE TABLE `JOURNAL_NO_SALE` (
113 `NS_ID` bigint(20) NOT NULL AUTO_INCREMENT,
114 `EVENT_DATE` datetime DEFAULT NULL,
115 `EVENT_TIME` datetime DEFAULT NULL,
116 `CLERK_ID` varchar(255) DEFAULT NULL,
117 `CLERK` varchar(255) DEFAULT NULL,
118 `SEQUENCE` varchar(255) DEFAULT NULL,
119 `TRAINING` tinyint(1) DEFAULT NULL,
120 `TILL_ID` bigint(20) NOT NULL,
121 PRIMARY KEY (`NS_ID`),
122 KEY `FKF4D132DD3B0323F0` (`TILL_ID`),
123 CONSTRAINT `FKF4D132DD3B0323F0` FOREIGN KEY (`TILL_ID`) REFERENCES `TILL` (`TIll_ID`)
124) ENGINE=InnoDB AUTO_INCREMENT=15018 DEFAULT CHARSET=latin1;
125/*!40101 SET character_set_client = @saved_cs_client */;
126
127--
128-- Table structure for table `JOURNAL_PO`
129--
130
131DROP TABLE IF EXISTS `JOURNAL_PO`;
132/*!40101 SET @saved_cs_client = @@character_set_client */;
133/*!40101 SET character_set_client = utf8 */;
134CREATE TABLE `JOURNAL_PO` (
135 `PO_ID` bigint(20) NOT NULL AUTO_INCREMENT,
136 `EVENT_DATE` datetime DEFAULT NULL,
137 `EVENT_TIME` datetime DEFAULT NULL,
138 `CLERK_ID` varchar(255) DEFAULT NULL,
139 `CLERK` varchar(255) DEFAULT NULL,
140 `SEQUENCE` varchar(255) DEFAULT NULL,
141 `TRAINING` tinyint(1) DEFAULT NULL,
142 `TOTAL` decimal(19,2) DEFAULT NULL,
143 `TILL_ID` bigint(20) NOT NULL,
144 PRIMARY KEY (`PO_ID`),
145 KEY `FK56ADC8273B0323F0` (`TILL_ID`),
146 CONSTRAINT `FK56ADC8273B0323F0` FOREIGN KEY (`TILL_ID`) REFERENCES `TILL` (`TIll_ID`)
147) ENGINE=InnoDB AUTO_INCREMENT=1579 DEFAULT CHARSET=latin1;
148/*!40101 SET character_set_client = @saved_cs_client */;
149
150--
151-- Table structure for table `JOURNAL_REPORT`
152--
153
154DROP TABLE IF EXISTS `JOURNAL_REPORT`;
155/*!40101 SET @saved_cs_client = @@character_set_client */;
156/*!40101 SET character_set_client = utf8 */;
157CREATE TABLE `JOURNAL_REPORT` (
158 `REPORT_ID` bigint(20) NOT NULL AUTO_INCREMENT,
159 `EVENT_DATE` datetime DEFAULT NULL,
160 `EVENT_TIME` datetime DEFAULT NULL,
161 `CLERK_ID` varchar(255) DEFAULT NULL,
162 `CLERK` varchar(255) DEFAULT NULL,
163 `SEQUENCE` varchar(255) DEFAULT NULL,
164 `TRAINING` tinyint(1) DEFAULT NULL,
165 `REPORT_TYPE` varchar(255) DEFAULT NULL,
166 `GT1` varchar(255) DEFAULT NULL,
167 `GT2` varchar(255) DEFAULT NULL,
168 `GT3` varchar(255) DEFAULT NULL,
169 `BAL` varchar(255) DEFAULT NULL,
170 `TR` varchar(255) DEFAULT NULL,
171 `NonVat` varchar(255) DEFAULT NULL,
172 `VAT` varchar(255) DEFAULT NULL,
173 `NET1` varchar(255) DEFAULT NULL,
174 `TAX2_ST` varchar(255) DEFAULT NULL,
175 `TTL_TAX` varchar(255) DEFAULT NULL,
176 `NET` varchar(255) DEFAULT NULL,
177 `VOID` varchar(255) DEFAULT NULL,
178 `VOID_TTL` varchar(255) DEFAULT NULL,
179 `VOID_MODE` varchar(255) DEFAULT NULL,
180 `VOID_MODE_TTL` varchar(255) DEFAULT NULL,
181 `MGR_VOID` varchar(255) DEFAULT NULL,
182 `MGR_VOID_TTL` varchar(255) DEFAULT NULL,
183 `SBTLVOID` varchar(255) DEFAULT NULL,
184 `SBTLVOID_TTL` varchar(255) DEFAULT NULL,
185 `NO_SALE` varchar(255) DEFAULT NULL,
186 `GUEST` varchar(255) DEFAULT NULL,
187 `ORDER_TL` varchar(255) DEFAULT NULL,
188 `PAID_TL` varchar(255) DEFAULT NULL,
189 `AVE` varchar(255) DEFAULT NULL,
190 `PO` varchar(255) DEFAULT NULL,
191 `PO_TTL` varchar(255) DEFAULT NULL,
192 `CA_CHK` varchar(255) DEFAULT NULL,
193 `CA_CHK_TTL` varchar(255) DEFAULT NULL,
194 `CASH` varchar(255) DEFAULT NULL,
195 `CASH_TTL` varchar(255) DEFAULT NULL,
196 `CHECK1` varchar(255) DEFAULT NULL,
197 `CHECK1_TTL` varchar(255) DEFAULT NULL,
198 `CID` varchar(255) DEFAULT NULL,
199 `CH_ID` varchar(255) DEFAULT NULL,
200 `CA_CHK_ID` varchar(255) DEFAULT NULL,
201 `CHK_CG` varchar(255) DEFAULT NULL,
202 `TILL_ID` bigint(20) NOT NULL,
203 PRIMARY KEY (`REPORT_ID`),
204 KEY `FK3FB1B35C3B0323F0` (`TILL_ID`),
205 CONSTRAINT `FK3FB1B35C3B0323F0` FOREIGN KEY (`TILL_ID`) REFERENCES `TILL` (`TIll_ID`)
206) ENGINE=InnoDB AUTO_INCREMENT=2777 DEFAULT CHARSET=latin1;
207/*!40101 SET character_set_client = @saved_cs_client */;
208
209--
210-- Table structure for table `JOURNAL_REPORT_LINES`
211--
212
213DROP TABLE IF EXISTS `JOURNAL_REPORT_LINES`;
214/*!40101 SET @saved_cs_client = @@character_set_client */;
215/*!40101 SET character_set_client = utf8 */;
216CREATE TABLE `JOURNAL_REPORT_LINES` (
217 `REPORT_LINE_ID` bigint(20) NOT NULL AUTO_INCREMENT,
218 `LINE` varchar(255) DEFAULT NULL,
219 `REPORT_ID` bigint(20) DEFAULT NULL,
220 PRIMARY KEY (`REPORT_LINE_ID`),
221 KEY `FK9B8A783CE6A0A1BB` (`REPORT_ID`),
222 CONSTRAINT `FK9B8A783CE6A0A1BB` FOREIGN KEY (`REPORT_ID`) REFERENCES `JOURNAL_REPORT` (`REPORT_ID`)
223) ENGINE=InnoDB AUTO_INCREMENT=104970 DEFAULT CHARSET=latin1;
224/*!40101 SET character_set_client = @saved_cs_client */;
225
226--
227-- Table structure for table `JOURNAL_VOID`
228--
229
230DROP TABLE IF EXISTS `JOURNAL_VOID`;
231/*!40101 SET @saved_cs_client = @@character_set_client */;
232/*!40101 SET character_set_client = utf8 */;
233CREATE TABLE `JOURNAL_VOID` (
234 `VOID_ID` bigint(20) NOT NULL AUTO_INCREMENT,
235 `EVENT_DATE` datetime DEFAULT NULL,
236 `EVENT_TIME` datetime DEFAULT NULL,
237 `CLERK_ID` varchar(255) DEFAULT NULL,
238 `CLERK` varchar(255) DEFAULT NULL,
239 `SEQUENCE` varchar(255) DEFAULT NULL,
240 `TRAINING` tinyint(1) DEFAULT NULL,
241 `SUBTOTAL` decimal(19,2) DEFAULT NULL,
242 `VAT` decimal(19,2) DEFAULT NULL,
243 `TENDER` varchar(255) DEFAULT NULL,
244 `PAYMENT` decimal(19,2) DEFAULT NULL,
245 `CUST_CHANGE` decimal(19,2) DEFAULT NULL,
246 `DISCOUNT` decimal(19,2) DEFAULT NULL,
247 `TOTAL` decimal(19,2) DEFAULT NULL,
248 `TILL_ID` bigint(20) NOT NULL,
249 PRIMARY KEY (`VOID_ID`),
250 KEY `FK625F1DBC3B0323F0` (`TILL_ID`),
251 CONSTRAINT `FK625F1DBC3B0323F0` FOREIGN KEY (`TILL_ID`) REFERENCES `TILL` (`TIll_ID`)
252) ENGINE=InnoDB AUTO_INCREMENT=1322 DEFAULT CHARSET=latin1;
253/*!40101 SET character_set_client = @saved_cs_client */;
254
255--
256-- Table structure for table `JOURNAL_VOID_LINES`
257--
258
259DROP TABLE IF EXISTS `JOURNAL_VOID_LINES`;
260/*!40101 SET @saved_cs_client = @@character_set_client */;
261/*!40101 SET character_set_client = utf8 */;
262CREATE TABLE `JOURNAL_VOID_LINES` (
263 `VOID_LINE_ID` bigint(20) NOT NULL AUTO_INCREMENT,
264 `PRODUCT` varchar(255) DEFAULT NULL,
265 `QUANTITY` int(11) DEFAULT NULL,
266 `UNIT_PRICE` decimal(19,2) DEFAULT NULL,
267 `LINE_TOTAL` decimal(19,2) DEFAULT NULL,
268 `VOID_ID` bigint(20) DEFAULT NULL,
269 PRIMARY KEY (`VOID_LINE_ID`),
270 KEY `FK73569A9CEB6DF1FB` (`VOID_ID`),
271 CONSTRAINT `FK73569A9CEB6DF1FB` FOREIGN KEY (`VOID_ID`) REFERENCES `JOURNAL_VOID` (`VOID_ID`)
272) ENGINE=InnoDB AUTO_INCREMENT=3515 DEFAULT CHARSET=latin1;
273/*!40101 SET character_set_client = @saved_cs_client */;
274
275--
276-- Table structure for table `PLU_CODES`
277--
278
279DROP TABLE IF EXISTS `PLU_CODES`;
280/*!40101 SET @saved_cs_client = @@character_set_client */;
281/*!40101 SET character_set_client = utf8 */;
282CREATE TABLE `PLU_CODES` (
283 `PLU_ID` int(11) NOT NULL AUTO_INCREMENT,
284 `PLU_CODE` int(11) NOT NULL,
285 `PLU_NAME` varchar(45) NOT NULL,
286 PRIMARY KEY (`PLU_ID`)
287) ENGINE=InnoDB AUTO_INCREMENT=211 DEFAULT CHARSET=latin1;
288/*!40101 SET character_set_client = @saved_cs_client */;
289
290--
291-- Table structure for table `TILL`
292--
293
294DROP TABLE IF EXISTS `TILL`;
295/*!40101 SET @saved_cs_client = @@character_set_client */;
296/*!40101 SET character_set_client = utf8 */;
297CREATE TABLE `TILL` (
298 `TIll_ID` bigint(20) NOT NULL AUTO_INCREMENT,
299 `TILL_NAME` varchar(255) DEFAULT NULL,
300 PRIMARY KEY (`TIll_ID`)
301) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
302/*!40101 SET character_set_client = @saved_cs_client */;
303
304--
305-- Table structure for table `VAT_CODES`
306--
307
308DROP TABLE IF EXISTS `VAT_CODES`;
309/*!40101 SET @saved_cs_client = @@character_set_client */;
310/*!40101 SET character_set_client = utf8 */;
311CREATE TABLE `VAT_CODES` (
312 `LINE_PRODUCT` varchar(50) NOT NULL,
313 `tillCode` int(11) DEFAULT NULL,
314 `correctCode` int(11) DEFAULT NULL,
315 `comments` varchar(45) DEFAULT NULL,
316 `codeID` int(11) NOT NULL AUTO_INCREMENT,
317 `VAT_CODEScol` varchar(45) DEFAULT NULL,
318 PRIMARY KEY (`codeID`)
319) ENGINE=InnoDB AUTO_INCREMENT=160 DEFAULT CHARSET=latin1;
320/*!40101 SET character_set_client = @saved_cs_client */;
321
322--
323-- Temporary view structure for view `all_lines`
324--
325
326DROP TABLE IF EXISTS `all_lines`;
327/*!50001 DROP VIEW IF EXISTS `all_lines`*/;
328SET @saved_cs_client = @@character_set_client;
329SET character_set_client = utf8;
330/*!50001 CREATE VIEW `all_lines` AS SELECT
331 1 AS `EVENT_DATE`,
332 1 AS `SEQUENCE`,
333 1 AS `LINE_PRODUCT`,
334 1 AS `LINE_TOTAL`,
335 1 AS `QUANTITY`,
336 1 AS `correctCode`*/;
337SET character_set_client = @saved_cs_client;
338
339--
340-- Temporary view structure for view `all_sales`
341--
342
343DROP TABLE IF EXISTS `all_sales`;
344/*!50001 DROP VIEW IF EXISTS `all_sales`*/;
345SET @saved_cs_client = @@character_set_client;
346SET character_set_client = utf8;
347/*!50001 CREATE VIEW `all_sales` AS SELECT
348 1 AS `LINE_PRODUCT`,
349 1 AS `UNIT_PRICE`,
350 1 AS `TOTAL_SOLD`,
351 1 AS `TOTAL_SALES`*/;
352SET character_set_client = @saved_cs_client;
353
354--
355-- Temporary view structure for view `all_vat_bills`
356--
357
358DROP TABLE IF EXISTS `all_vat_bills`;
359/*!50001 DROP VIEW IF EXISTS `all_vat_bills`*/;
360SET @saved_cs_client = @@character_set_client;
361SET character_set_client = utf8;
362/*!50001 CREATE VIEW `all_vat_bills` AS SELECT
363 1 AS `BILL_ID`,
364 1 AS `EVENT_DATE`,
365 1 AS `EVENT_TIME`,
366 1 AS `CLERK_ID`,
367 1 AS `CLERK`,
368 1 AS `SEQUENCE`,
369 1 AS `TRAINING`,
370 1 AS `SUBTOTAL`,
371 1 AS `AllVatAmnt`,
372 1 AS `VAT`,
373 1 AS `TENDER`,
374 1 AS `PAYMENT`,
375 1 AS `CUST_CHANGE`,
376 1 AS `DISCOUNT`,
377 1 AS `TOTAL`,
378 1 AS `TILL_ID`*/;
379SET character_set_client = @saved_cs_client;
380
381--
382-- Temporary view structure for view `all_voids`
383--
384
385DROP TABLE IF EXISTS `all_voids`;
386/*!50001 DROP VIEW IF EXISTS `all_voids`*/;
387SET @saved_cs_client = @@character_set_client;
388SET character_set_client = utf8;
389/*!50001 CREATE VIEW `all_voids` AS SELECT
390 1 AS `LINE_PRODUCT`,
391 1 AS `UNIT_PRICE`,
392 1 AS `TOTAL_SOLD`,
393 1 AS `TOTAL_SALES`*/;
394SET character_set_client = @saved_cs_client;
395
396--
397-- Temporary view structure for view `duplicate_import`
398--
399
400DROP TABLE IF EXISTS `duplicate_import`;
401/*!50001 DROP VIEW IF EXISTS `duplicate_import`*/;
402SET @saved_cs_client = @@character_set_client;
403SET character_set_client = utf8;
404/*!50001 CREATE VIEW `duplicate_import` AS SELECT
405 1 AS `COUNT(*)`,
406 1 AS `SEQUENCE`,
407 1 AS `TILL_ID`*/;
408SET character_set_client = @saved_cs_client;
409
410--
411-- Temporary view structure for view `journal_lines`
412--
413
414DROP TABLE IF EXISTS `journal_lines`;
415/*!50001 DROP VIEW IF EXISTS `journal_lines`*/;
416SET @saved_cs_client = @@character_set_client;
417SET character_set_client = utf8;
418/*!50001 CREATE VIEW `journal_lines` AS SELECT
419 1 AS `TILL_NAME`,
420 1 AS `EVENT_DATE`,
421 1 AS `SEQUENCE`,
422 1 AS `VAT`,
423 1 AS `TOTAL`,
424 1 AS `LINE_PRODUCT`,
425 1 AS `UNIT_PRICE`,
426 1 AS `QUANTITY`,
427 1 AS `LINE_TOTAL`*/;
428SET character_set_client = @saved_cs_client;
429
430--
431-- Temporary view structure for view `void_lines`
432--
433
434DROP TABLE IF EXISTS `void_lines`;
435/*!50001 DROP VIEW IF EXISTS `void_lines`*/;
436SET @saved_cs_client = @@character_set_client;
437SET character_set_client = utf8;
438/*!50001 CREATE VIEW `void_lines` AS SELECT
439 1 AS `TILL_NAME`,
440 1 AS `TILL_ID`,
441 1 AS `EVENT_DATE`,
442 1 AS `SEQUENCE`,
443 1 AS `VAT`,
444 1 AS `TOTAL`,
445 1 AS `LINE_PRODUCT`,
446 1 AS `UNIT_PRICE`,
447 1 AS `QUANTITY`,
448 1 AS `LINE_TOTAL`*/;
449SET character_set_client = @saved_cs_client;
450
451--
452-- Temporary view structure for view `zReport_output`
453--
454
455DROP TABLE IF EXISTS `zReport_output`;
456/*!50001 DROP VIEW IF EXISTS `zReport_output`*/;
457SET @saved_cs_client = @@character_set_client;
458SET character_set_client = utf8;
459/*!50001 CREATE VIEW `zReport_output` AS SELECT
460 1 AS `REPORT_ID`,
461 1 AS `EVENT_DATE`,
462 1 AS `REPORT_DATE`,
463 1 AS `EVENT_TIME`,
464 1 AS `CLERK_ID`,
465 1 AS `CLERK`,
466 1 AS `SEQUENCE`,
467 1 AS `TRAINING`,
468 1 AS `REPORT_TYPE`,
469 1 AS `GT1`,
470 1 AS `GT2`,
471 1 AS `GT3`,
472 1 AS `BAL`,
473 1 AS `TR`,
474 1 AS `NonVat`,
475 1 AS `VAT`,
476 1 AS `NET1`,
477 1 AS `TAX2_ST`,
478 1 AS `TTL_TAX`,
479 1 AS `NET`,
480 1 AS `VOID`,
481 1 AS `VOID_TTL`,
482 1 AS `VOID_MODE`,
483 1 AS `VOID_MODE_TTL`,
484 1 AS `MGR_VOID`,
485 1 AS `MGR_VOID_TTL`,
486 1 AS `SBTLVOID`,
487 1 AS `SBTLVOID_TTL`,
488 1 AS `NO_SALE`,
489 1 AS `GUEST`,
490 1 AS `ORDER_TL`,
491 1 AS `PAID_TL`,
492 1 AS `AVE`,
493 1 AS `PO`,
494 1 AS `PO_TTL`,
495 1 AS `CA_CHK`,
496 1 AS `CA_CHK_TTL`,
497 1 AS `CASH`,
498 1 AS `CASH_TTL`,
499 1 AS `CHECK1`,
500 1 AS `CHECK1_TTL`,
501 1 AS `CID`,
502 1 AS `CH_ID`,
503 1 AS `CA_CHK_ID`,
504 1 AS `CHK_CG`,
505 1 AS `TILL_ID`*/;
506SET character_set_client = @saved_cs_client;
507
508--
509-- Dumping routines for database 'appetite_till'
510--
511/*!50003 DROP PROCEDURE IF EXISTS `clearAll` */;
512/*!50003 SET @saved_cs_client = @@character_set_client */ ;
513/*!50003 SET @saved_cs_results = @@character_set_results */ ;
514/*!50003 SET @saved_col_connection = @@collation_connection */ ;
515/*!50003 SET character_set_client = utf8 */ ;
516/*!50003 SET character_set_results = utf8 */ ;
517/*!50003 SET collation_connection = utf8_general_ci */ ;
518/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
519/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;
520DELIMITER ;;
521CREATE DEFINER=`root`@`localhost` PROCEDURE `clearAll`()
522BEGIN
523
524DELETE FROM IMPORT_AUDIT;
525DELETE FROM JOURNAL_CA_CHK;
526DELETE FROM JOURNAL_NO_SALE;
527DELETE FROM JOURNAL_PO;
528
529DELETE FROM JOURNAL_LINES;
530DELETE FROM JOURNAL_BILLS;
531
532DELETE FROM JOURNAL_REPORT_LINES;
533DELETE FROM JOURNAL_REPORT;
534
535DELETE FROM JOURNAL_VOID_LINES;
536DELETE FROM JOURNAL_VOID;
537
538SET FOREIGN_KEY_CHECKS = 0;
539
540TRUNCATE IMPORT_AUDIT;
541TRUNCATE JOURNAL_CA_CHK;
542TRUNCATE JOURNAL_NO_SALE;
543TRUNCATE JOURNAL_PO;
544
545TRUNCATE JOURNAL_LINES;
546TRUNCATE JOURNAL_BILLS;
547
548TRUNCATE JOURNAL_REPORT_LINES;
549TRUNCATE JOURNAL_REPORT;
550
551TRUNCATE JOURNAL_VOID_LINES;
552TRUNCATE JOURNAL_VOID;
553
554SET FOREIGN_KEY_CHECKS = 1;
555END ;;
556DELIMITER ;
557/*!50003 SET sql_mode = @saved_sql_mode */ ;
558/*!50003 SET character_set_client = @saved_cs_client */ ;
559/*!50003 SET character_set_results = @saved_cs_results */ ;
560/*!50003 SET collation_connection = @saved_col_connection */ ;
561
562--
563-- Final view structure for view `all_lines`
564--
565
566/*!50001 DROP VIEW IF EXISTS `all_lines`*/;
567/*!50001 SET @saved_cs_client = @@character_set_client */;
568/*!50001 SET @saved_cs_results = @@character_set_results */;
569/*!50001 SET @saved_col_connection = @@collation_connection */;
570/*!50001 SET character_set_client = utf8 */;
571/*!50001 SET character_set_results = utf8 */;
572/*!50001 SET collation_connection = utf8_general_ci */;
573/*!50001 CREATE ALGORITHM=UNDEFINED */
574/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
575/*!50001 VIEW `all_lines` AS select `journal_lines`.`EVENT_DATE` AS `EVENT_DATE`,`journal_lines`.`SEQUENCE` AS `SEQUENCE`,`journal_lines`.`LINE_PRODUCT` AS `LINE_PRODUCT`,`journal_lines`.`LINE_TOTAL` AS `LINE_TOTAL`,`journal_lines`.`QUANTITY` AS `QUANTITY`,`VAT_CODES`.`correctCode` AS `correctCode` from (`journal_lines` left join `VAT_CODES` on((`journal_lines`.`LINE_PRODUCT` = `VAT_CODES`.`LINE_PRODUCT`))) union all select `void_lines`.`EVENT_DATE` AS `EVENT_DATE`,`void_lines`.`SEQUENCE` AS `SEQUENCE`,`void_lines`.`LINE_PRODUCT` AS `LINE_PRODUCT`,(`void_lines`.`LINE_TOTAL` * -(1)) AS `LINE_TOTAL`,(`void_lines`.`QUANTITY` * -(1)) AS `QUANTITY`,`VAT_CODES`.`correctCode` AS `correctCode` from (`void_lines` left join `VAT_CODES` on((`void_lines`.`LINE_PRODUCT` = `VAT_CODES`.`LINE_PRODUCT`))) */;
576/*!50001 SET character_set_client = @saved_cs_client */;
577/*!50001 SET character_set_results = @saved_cs_results */;
578/*!50001 SET collation_connection = @saved_col_connection */;
579
580--
581-- Final view structure for view `all_sales`
582--
583
584/*!50001 DROP VIEW IF EXISTS `all_sales`*/;
585/*!50001 SET @saved_cs_client = @@character_set_client */;
586/*!50001 SET @saved_cs_results = @@character_set_results */;
587/*!50001 SET @saved_col_connection = @@collation_connection */;
588/*!50001 SET character_set_client = utf8 */;
589/*!50001 SET character_set_results = utf8 */;
590/*!50001 SET collation_connection = utf8_general_ci */;
591/*!50001 CREATE ALGORITHM=UNDEFINED */
592/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
593/*!50001 VIEW `all_sales` AS select `journal_lines`.`LINE_PRODUCT` AS `LINE_PRODUCT`,`journal_lines`.`UNIT_PRICE` AS `UNIT_PRICE`,sum(`journal_lines`.`QUANTITY`) AS `TOTAL_SOLD`,sum(`journal_lines`.`LINE_TOTAL`) AS `TOTAL_SALES` from `journal_lines` group by `journal_lines`.`LINE_PRODUCT`,`journal_lines`.`UNIT_PRICE` having (sum(`journal_lines`.`QUANTITY`) <> 0) */;
594/*!50001 SET character_set_client = @saved_cs_client */;
595/*!50001 SET character_set_results = @saved_cs_results */;
596/*!50001 SET collation_connection = @saved_col_connection */;
597
598--
599-- Final view structure for view `all_vat_bills`
600--
601
602/*!50001 DROP VIEW IF EXISTS `all_vat_bills`*/;
603/*!50001 SET @saved_cs_client = @@character_set_client */;
604/*!50001 SET @saved_cs_results = @@character_set_results */;
605/*!50001 SET @saved_col_connection = @@collation_connection */;
606/*!50001 SET character_set_client = utf8 */;
607/*!50001 SET character_set_results = utf8 */;
608/*!50001 SET collation_connection = utf8_general_ci */;
609/*!50001 CREATE ALGORITHM=UNDEFINED */
610/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
611/*!50001 VIEW `all_vat_bills` AS select `JOURNAL_BILLS`.`BILL_ID` AS `BILL_ID`,`JOURNAL_BILLS`.`EVENT_DATE` AS `EVENT_DATE`,`JOURNAL_BILLS`.`EVENT_TIME` AS `EVENT_TIME`,`JOURNAL_BILLS`.`CLERK_ID` AS `CLERK_ID`,`JOURNAL_BILLS`.`CLERK` AS `CLERK`,`JOURNAL_BILLS`.`SEQUENCE` AS `SEQUENCE`,`JOURNAL_BILLS`.`TRAINING` AS `TRAINING`,`JOURNAL_BILLS`.`SUBTOTAL` AS `SUBTOTAL`,round((`JOURNAL_BILLS`.`SUBTOTAL` / 6),2) AS `AllVatAmnt`,`JOURNAL_BILLS`.`VAT` AS `VAT`,`JOURNAL_BILLS`.`TENDER` AS `TENDER`,`JOURNAL_BILLS`.`PAYMENT` AS `PAYMENT`,`JOURNAL_BILLS`.`CUST_CHANGE` AS `CUST_CHANGE`,`JOURNAL_BILLS`.`DISCOUNT` AS `DISCOUNT`,`JOURNAL_BILLS`.`TOTAL` AS `TOTAL`,`JOURNAL_BILLS`.`TILL_ID` AS `TILL_ID` from `JOURNAL_BILLS` where ((`JOURNAL_BILLS`.`TRAINING` = 0) and (round((`JOURNAL_BILLS`.`SUBTOTAL` / 6),2) = `JOURNAL_BILLS`.`VAT`)) */;
612/*!50001 SET character_set_client = @saved_cs_client */;
613/*!50001 SET character_set_results = @saved_cs_results */;
614/*!50001 SET collation_connection = @saved_col_connection */;
615
616--
617-- Final view structure for view `all_voids`
618--
619
620/*!50001 DROP VIEW IF EXISTS `all_voids`*/;
621/*!50001 SET @saved_cs_client = @@character_set_client */;
622/*!50001 SET @saved_cs_results = @@character_set_results */;
623/*!50001 SET @saved_col_connection = @@collation_connection */;
624/*!50001 SET character_set_client = utf8 */;
625/*!50001 SET character_set_results = utf8 */;
626/*!50001 SET collation_connection = utf8_general_ci */;
627/*!50001 CREATE ALGORITHM=UNDEFINED */
628/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
629/*!50001 VIEW `all_voids` AS select `void_lines`.`LINE_PRODUCT` AS `LINE_PRODUCT`,`void_lines`.`UNIT_PRICE` AS `UNIT_PRICE`,sum(`void_lines`.`QUANTITY`) AS `TOTAL_SOLD`,sum(`void_lines`.`LINE_TOTAL`) AS `TOTAL_SALES` from `void_lines` group by `void_lines`.`LINE_PRODUCT`,`void_lines`.`UNIT_PRICE` having (sum(`void_lines`.`QUANTITY`) <> 0) */;
630/*!50001 SET character_set_client = @saved_cs_client */;
631/*!50001 SET character_set_results = @saved_cs_results */;
632/*!50001 SET collation_connection = @saved_col_connection */;
633
634--
635-- Final view structure for view `duplicate_import`
636--
637
638/*!50001 DROP VIEW IF EXISTS `duplicate_import`*/;
639/*!50001 SET @saved_cs_client = @@character_set_client */;
640/*!50001 SET @saved_cs_results = @@character_set_results */;
641/*!50001 SET @saved_col_connection = @@collation_connection */;
642/*!50001 SET character_set_client = utf8 */;
643/*!50001 SET character_set_results = utf8 */;
644/*!50001 SET collation_connection = utf8_general_ci */;
645/*!50001 CREATE ALGORITHM=UNDEFINED */
646/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
647/*!50001 VIEW `duplicate_import` AS select count(0) AS `COUNT(*)`,`JOURNAL_BILLS`.`SEQUENCE` AS `SEQUENCE`,`JOURNAL_BILLS`.`TILL_ID` AS `TILL_ID` from `JOURNAL_BILLS` where (`JOURNAL_BILLS`.`TRAINING` = 0) group by `JOURNAL_BILLS`.`SEQUENCE`,`JOURNAL_BILLS`.`TILL_ID` having (count(0) > 1) */;
648/*!50001 SET character_set_client = @saved_cs_client */;
649/*!50001 SET character_set_results = @saved_cs_results */;
650/*!50001 SET collation_connection = @saved_col_connection */;
651
652--
653-- Final view structure for view `journal_lines`
654--
655
656/*!50001 DROP VIEW IF EXISTS `journal_lines`*/;
657/*!50001 SET @saved_cs_client = @@character_set_client */;
658/*!50001 SET @saved_cs_results = @@character_set_results */;
659/*!50001 SET @saved_col_connection = @@collation_connection */;
660/*!50001 SET character_set_client = utf8 */;
661/*!50001 SET character_set_results = utf8 */;
662/*!50001 SET collation_connection = utf8_general_ci */;
663/*!50001 CREATE ALGORITHM=UNDEFINED */
664/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
665/*!50001 VIEW `journal_lines` AS select `TILL`.`TILL_NAME` AS `TILL_NAME`,`JOURNAL_BILLS`.`EVENT_DATE` AS `EVENT_DATE`,`JOURNAL_BILLS`.`SEQUENCE` AS `SEQUENCE`,`JOURNAL_BILLS`.`VAT` AS `VAT`,`JOURNAL_BILLS`.`TOTAL` AS `TOTAL`,(case when (`JOURNAL_LINES`.`PRODUCT` <> '') then `JOURNAL_LINES`.`PRODUCT` else `JOURNAL_LINES`.`UNIT_PRICE` end) AS `LINE_PRODUCT`,`JOURNAL_LINES`.`UNIT_PRICE` AS `UNIT_PRICE`,`JOURNAL_LINES`.`QUANTITY` AS `QUANTITY`,`JOURNAL_LINES`.`LINE_TOTAL` AS `LINE_TOTAL` from ((`JOURNAL_BILLS` join `JOURNAL_LINES` on((`JOURNAL_LINES`.`BILL_ID` = `JOURNAL_BILLS`.`BILL_ID`))) left join `TILL` on((`JOURNAL_BILLS`.`TILL_ID` = `TILL`.`TIll_ID`))) where (`JOURNAL_BILLS`.`TRAINING` = 0) */;
666/*!50001 SET character_set_client = @saved_cs_client */;
667/*!50001 SET character_set_results = @saved_cs_results */;
668/*!50001 SET collation_connection = @saved_col_connection */;
669
670--
671-- Final view structure for view `void_lines`
672--
673
674/*!50001 DROP VIEW IF EXISTS `void_lines`*/;
675/*!50001 SET @saved_cs_client = @@character_set_client */;
676/*!50001 SET @saved_cs_results = @@character_set_results */;
677/*!50001 SET @saved_col_connection = @@collation_connection */;
678/*!50001 SET character_set_client = utf8 */;
679/*!50001 SET character_set_results = utf8 */;
680/*!50001 SET collation_connection = utf8_general_ci */;
681/*!50001 CREATE ALGORITHM=UNDEFINED */
682/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
683/*!50001 VIEW `void_lines` AS select `TILL`.`TILL_NAME` AS `TILL_NAME`,`JOURNAL_VOID`.`TILL_ID` AS `TILL_ID`,`JOURNAL_VOID`.`EVENT_DATE` AS `EVENT_DATE`,`JOURNAL_VOID`.`SEQUENCE` AS `SEQUENCE`,`JOURNAL_VOID`.`VAT` AS `VAT`,`JOURNAL_VOID`.`TOTAL` AS `TOTAL`,(case when (`JOURNAL_VOID_LINES`.`PRODUCT` <> '') then `JOURNAL_VOID_LINES`.`PRODUCT` else `JOURNAL_VOID_LINES`.`UNIT_PRICE` end) AS `LINE_PRODUCT`,`JOURNAL_VOID_LINES`.`UNIT_PRICE` AS `UNIT_PRICE`,`JOURNAL_VOID_LINES`.`QUANTITY` AS `QUANTITY`,`JOURNAL_VOID_LINES`.`LINE_TOTAL` AS `LINE_TOTAL` from ((`JOURNAL_VOID` left join `JOURNAL_VOID_LINES` on((`JOURNAL_VOID_LINES`.`VOID_ID` = `JOURNAL_VOID`.`VOID_ID`))) left join `TILL` on((`JOURNAL_VOID`.`TILL_ID` = `TILL`.`TIll_ID`))) where (`JOURNAL_VOID`.`TRAINING` = 0) */;
684/*!50001 SET character_set_client = @saved_cs_client */;
685/*!50001 SET character_set_results = @saved_cs_results */;
686/*!50001 SET collation_connection = @saved_col_connection */;
687
688--
689-- Final view structure for view `zReport_output`
690--
691
692/*!50001 DROP VIEW IF EXISTS `zReport_output`*/;
693/*!50001 SET @saved_cs_client = @@character_set_client */;
694/*!50001 SET @saved_cs_results = @@character_set_results */;
695/*!50001 SET @saved_col_connection = @@collation_connection */;
696/*!50001 SET character_set_client = utf8 */;
697/*!50001 SET character_set_results = utf8 */;
698/*!50001 SET collation_connection = utf8_general_ci */;
699/*!50001 CREATE ALGORITHM=UNDEFINED */
700/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
701/*!50001 VIEW `zReport_output` AS select `JOURNAL_REPORT`.`REPORT_ID` AS `REPORT_ID`,`JOURNAL_REPORT`.`EVENT_DATE` AS `EVENT_DATE`,date_format(`JOURNAL_REPORT`.`EVENT_DATE`,'%d/%m/%Y') AS `REPORT_DATE`,`JOURNAL_REPORT`.`EVENT_TIME` AS `EVENT_TIME`,`JOURNAL_REPORT`.`CLERK_ID` AS `CLERK_ID`,`JOURNAL_REPORT`.`CLERK` AS `CLERK`,`JOURNAL_REPORT`.`SEQUENCE` AS `SEQUENCE`,`JOURNAL_REPORT`.`TRAINING` AS `TRAINING`,`JOURNAL_REPORT`.`REPORT_TYPE` AS `REPORT_TYPE`,`JOURNAL_REPORT`.`GT1` AS `GT1`,`JOURNAL_REPORT`.`GT2` AS `GT2`,`JOURNAL_REPORT`.`GT3` AS `GT3`,`JOURNAL_REPORT`.`BAL` AS `BAL`,`JOURNAL_REPORT`.`TR` AS `TR`,`JOURNAL_REPORT`.`NonVat` AS `NonVat`,`JOURNAL_REPORT`.`VAT` AS `VAT`,`JOURNAL_REPORT`.`NET1` AS `NET1`,`JOURNAL_REPORT`.`TAX2_ST` AS `TAX2_ST`,`JOURNAL_REPORT`.`TTL_TAX` AS `TTL_TAX`,`JOURNAL_REPORT`.`NET` AS `NET`,`JOURNAL_REPORT`.`VOID` AS `VOID`,`JOURNAL_REPORT`.`VOID_TTL` AS `VOID_TTL`,`JOURNAL_REPORT`.`VOID_MODE` AS `VOID_MODE`,`JOURNAL_REPORT`.`VOID_MODE_TTL` AS `VOID_MODE_TTL`,`JOURNAL_REPORT`.`MGR_VOID` AS `MGR_VOID`,`JOURNAL_REPORT`.`MGR_VOID_TTL` AS `MGR_VOID_TTL`,`JOURNAL_REPORT`.`SBTLVOID` AS `SBTLVOID`,`JOURNAL_REPORT`.`SBTLVOID_TTL` AS `SBTLVOID_TTL`,`JOURNAL_REPORT`.`NO_SALE` AS `NO_SALE`,`JOURNAL_REPORT`.`GUEST` AS `GUEST`,`JOURNAL_REPORT`.`ORDER_TL` AS `ORDER_TL`,`JOURNAL_REPORT`.`PAID_TL` AS `PAID_TL`,`JOURNAL_REPORT`.`AVE` AS `AVE`,`JOURNAL_REPORT`.`PO` AS `PO`,`JOURNAL_REPORT`.`PO_TTL` AS `PO_TTL`,`JOURNAL_REPORT`.`CA_CHK` AS `CA_CHK`,`JOURNAL_REPORT`.`CA_CHK_TTL` AS `CA_CHK_TTL`,`JOURNAL_REPORT`.`CASH` AS `CASH`,`JOURNAL_REPORT`.`CASH_TTL` AS `CASH_TTL`,`JOURNAL_REPORT`.`CHECK1` AS `CHECK1`,`JOURNAL_REPORT`.`CHECK1_TTL` AS `CHECK1_TTL`,`JOURNAL_REPORT`.`CID` AS `CID`,`JOURNAL_REPORT`.`CH_ID` AS `CH_ID`,`JOURNAL_REPORT`.`CA_CHK_ID` AS `CA_CHK_ID`,`JOURNAL_REPORT`.`CHK_CG` AS `CHK_CG`,`JOURNAL_REPORT`.`TILL_ID` AS `TILL_ID` from `JOURNAL_REPORT` where ((`JOURNAL_REPORT`.`TRAINING` = 0) and (`JOURNAL_REPORT`.`REPORT_TYPE` = 'Z1')) */;
702/*!50001 SET character_set_client = @saved_cs_client */;
703/*!50001 SET character_set_results = @saved_cs_results */;
704/*!50001 SET collation_connection = @saved_col_connection */;
705/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
706
707/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
708/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
709/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
710/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
711/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
712/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
713/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
714
715-- Dump completed on 2018-12-12 6:26:12