From 05f197c5d4ca05cd0b476ec367229cfa3107a312 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Tue, 4 Feb 2020 09:36:12 +0100 Subject: [PATCH] Updated en_US-demo.sql and en_US-new.sql COAs (moved dates 1 year forwards) --- sql/en_US-demo.sql | 404 ++++++++++++++++++++++----------------------- sql/en_US-new.sql | 8 +- 2 files changed, 206 insertions(+), 206 deletions(-) diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql index d536e000..75a7b92d 100644 --- a/sql/en_US-demo.sql +++ b/sql/en_US-demo.sql @@ -1,6 +1,6 @@ -- MySQL dump of database 'en_US-demo' on host 'localhost' --- Backup Date and Time: 2019-01-21 11:16 --- Built by FrontAccounting 2.4.6 +-- Backup Date and Time: 2020-01-21 11:16 +-- Built by FrontAccounting 2.4.7 -- http://frontaccounting.com -- Company: Training Co. -- User: Administrator @@ -70,42 +70,42 @@ CREATE TABLE `0_audit_trail` ( -- Data of table `0_audit_trail` -- INSERT INTO `0_audit_trail` VALUES -('1', '18', '1', '1', '2018-05-05 14:08:02', NULL, '1', '2018-05-05', '0'), -('2', '25', '1', '1', '2018-05-05 14:08:14', NULL, '1', '2018-05-05', '1'), -('3', '30', '1', '1', '2018-05-05 14:09:54', NULL, '1', '2018-05-10', '0'), -('4', '13', '1', '1', '2018-05-05 14:09:55', NULL, '1', '2018-05-10', '13'), -('5', '10', '1', '1', '2018-05-05 14:09:55', NULL, '1', '2018-05-10', '14'), -('6', '12', '1', '1', '2018-05-05 14:09:55', NULL, '1', '2018-05-10', '15'), -('7', '29', '1', '1', '2018-05-05 14:18:49', 'Quick production.', '1', '2018-05-05', '2'), -('8', '18', '2', '1', '2018-05-05 14:22:32', NULL, '1', '2018-05-05', '0'), -('9', '25', '2', '1', '2018-05-05 14:22:32', NULL, '1', '2018-05-05', '3'), -('10', '20', '1', '1', '2018-05-05 14:22:32', NULL, '1', '2018-05-05', '4'), -('11', '30', '2', '1', '2018-05-07 07:55:15', NULL, '1', '2018-05-07', '0'), -('12', '13', '2', '1', '2018-05-07 07:55:16', NULL, '1', '2018-05-07', '7'), -('13', '10', '2', '1', '2018-05-07 07:55:16', NULL, '1', '2018-05-07', '8'), -('14', '12', '2', '1', '2018-05-07 07:55:16', NULL, '1', '2018-05-07', '9'), -('15', '30', '3', '1', '2018-05-07 08:08:24', NULL, '1', '2018-05-07', '0'), -('16', '30', '4', '1', '2018-05-07 09:18:44', NULL, '1', '2018-05-07', '0'), -('17', '30', '5', '1', '2018-05-07 11:42:41', NULL, '1', '2018-05-07', '0'), -('18', '13', '3', '1', '2018-05-07 11:42:41', NULL, '1', '2018-05-07', '10'), -('19', '10', '3', '1', '2018-05-07 11:42:41', NULL, '1', '2018-05-07', '11'), -('20', '30', '6', '1', '2018-05-07 14:02:35', NULL, '1', '2018-05-07', '0'), -('21', '30', '7', '1', '2018-05-07 14:05:38', NULL, '1', '2018-05-07', '0'), -('22', '13', '4', '1', '2018-05-07 14:05:38', NULL, '1', '2018-05-07', '0'), -('23', '10', '4', '1', '2018-05-07 14:05:38', NULL, '1', '2018-05-07', '0'), -('24', '12', '3', '1', '2018-05-07 14:05:38', NULL, '1', '2018-05-07', '0'), -('25', '26', '1', '1', '2018-05-07 15:59:34', NULL, '1', '2018-05-07', NULL), -('26', '29', '1', '1', '2018-05-07 15:59:01', 'Production.', '1', '2018-05-07', '5'), -('27', '26', '1', '1', '2018-05-07 15:59:34', 'Released.', '1', '2018-05-07', '6'), -('28', '1', '1', '1', '2018-05-07 16:01:00', NULL, '1', '2018-05-07', '12'), -('29', '30', '8', '1', '2019-01-21 11:13:06', NULL, '2', '2019-01-21', '0'), -('30', '13', '5', '1', '2019-01-21 11:13:06', NULL, '2', '2019-01-21', '0'), -('31', '10', '5', '1', '2019-01-21 11:13:06', NULL, '2', '2019-01-21', '0'), -('32', '12', '4', '1', '2019-01-21 11:13:06', NULL, '2', '2019-01-21', '0'), -('33', '18', '3', '1', '2019-01-21 11:14:14', NULL, '2', '2019-01-21', '0'), -('34', '25', '3', '1', '2019-01-21 11:14:14', NULL, '2', '2019-01-21', '0'), -('35', '20', '2', '1', '2019-01-21 11:14:14', NULL, '2', '2019-01-21', '0'), -('36', '0', '1', '1', '2019-01-21 11:15:35', NULL, '1', '2018-12-31', '16'); +('1', '18', '1', '1', '2019-05-05 14:08:02', NULL, '1', '2019-05-05', '0'), +('2', '25', '1', '1', '2019-05-05 14:08:14', NULL, '1', '2019-05-05', '1'), +('3', '30', '1', '1', '2019-05-05 14:09:54', NULL, '1', '2019-05-10', '0'), +('4', '13', '1', '1', '2019-05-05 14:09:55', NULL, '1', '2019-05-10', '13'), +('5', '10', '1', '1', '2019-05-05 14:09:55', NULL, '1', '2019-05-10', '14'), +('6', '12', '1', '1', '2019-05-05 14:09:55', NULL, '1', '2019-05-10', '15'), +('7', '29', '1', '1', '2019-05-05 14:18:49', 'Quick production.', '1', '2019-05-05', '2'), +('8', '18', '2', '1', '2019-05-05 14:22:32', NULL, '1', '2019-05-05', '0'), +('9', '25', '2', '1', '2019-05-05 14:22:32', NULL, '1', '2019-05-05', '3'), +('10', '20', '1', '1', '2019-05-05 14:22:32', NULL, '1', '2019-05-05', '4'), +('11', '30', '2', '1', '2019-05-07 07:55:15', NULL, '1', '2019-05-07', '0'), +('12', '13', '2', '1', '2019-05-07 07:55:16', NULL, '1', '2019-05-07', '7'), +('13', '10', '2', '1', '2019-05-07 07:55:16', NULL, '1', '2019-05-07', '8'), +('14', '12', '2', '1', '2019-05-07 07:55:16', NULL, '1', '2019-05-07', '9'), +('15', '30', '3', '1', '2019-05-07 08:08:24', NULL, '1', '2019-05-07', '0'), +('16', '30', '4', '1', '2019-05-07 09:18:44', NULL, '1', '2019-05-07', '0'), +('17', '30', '5', '1', '2019-05-07 11:42:41', NULL, '1', '2019-05-07', '0'), +('18', '13', '3', '1', '2019-05-07 11:42:41', NULL, '1', '2019-05-07', '10'), +('19', '10', '3', '1', '2019-05-07 11:42:41', NULL, '1', '2019-05-07', '11'), +('20', '30', '6', '1', '2019-05-07 14:02:35', NULL, '1', '2019-05-07', '0'), +('21', '30', '7', '1', '2019-05-07 14:05:38', NULL, '1', '2019-05-07', '0'), +('22', '13', '4', '1', '2019-05-07 14:05:38', NULL, '1', '2019-05-07', '0'), +('23', '10', '4', '1', '2019-05-07 14:05:38', NULL, '1', '2019-05-07', '0'), +('24', '12', '3', '1', '2019-05-07 14:05:38', NULL, '1', '2019-05-07', '0'), +('25', '26', '1', '1', '2019-05-07 15:59:34', NULL, '1', '2019-05-07', NULL), +('26', '29', '1', '1', '2019-05-07 15:59:01', 'Production.', '1', '2019-05-07', '5'), +('27', '26', '1', '1', '2019-05-07 15:59:34', 'Released.', '1', '2019-05-07', '6'), +('28', '1', '1', '1', '2019-05-07 16:01:00', NULL, '1', '2019-05-07', '12'), +('29', '30', '8', '1', '2020-01-21 11:13:06', NULL, '2', '2020-01-21', '0'), +('30', '13', '5', '1', '2020-01-21 11:13:06', NULL, '2', '2020-01-21', '0'), +('31', '10', '5', '1', '2020-01-21 11:13:06', NULL, '2', '2020-01-21', '0'), +('32', '12', '4', '1', '2020-01-21 11:13:06', NULL, '2', '2020-01-21', '0'), +('33', '18', '3', '1', '2020-01-21 11:14:14', NULL, '2', '2020-01-21', '0'), +('34', '25', '3', '1', '2020-01-21 11:14:14', NULL, '2', '2020-01-21', '0'), +('35', '20', '2', '1', '2020-01-21 11:14:14', NULL, '2', '2020-01-21', '0'), +('36', '0', '1', '1', '2020-01-21 11:15:35', NULL, '1', '2019-12-31', '16'); -- Structure of table `0_bank_accounts` -- @@ -164,11 +164,11 @@ CREATE TABLE `0_bank_trans` ( -- Data of table `0_bank_trans` -- INSERT INTO `0_bank_trans` VALUES -('1', '12', '1', '2', '001/2018', '2018-05-10', '6240', '0', '0', '2', '1', NULL), -('2', '12', '2', '2', '002/2018', '2018-05-07', '300', '0', '0', '2', '1', NULL), -('3', '12', '3', '2', '003/2018', '2018-05-07', '0', '0', '0', '2', '1', NULL), -('4', '1', '1', '1', '001/2018', '2018-05-07', '-5', '0', '0', '0', 'Goods received', NULL), -('5', '12', '4', '2', '001/2019', '2019-01-21', '1250', '0', '0', '2', '1', NULL); +('1', '12', '1', '2', '001/2019', '2019-05-10', '6240', '0', '0', '2', '1', NULL), +('2', '12', '2', '2', '002/2019', '2019-05-07', '300', '0', '0', '2', '1', NULL), +('3', '12', '3', '2', '003/2019', '2019-05-07', '0', '0', '0', '2', '1', NULL), +('4', '1', '1', '1', '001/2019', '2019-05-07', '-5', '0', '0', '0', 'Goods received', NULL), +('5', '12', '4', '2', '001/2020', '2020-01-21', '1250', '0', '0', '2', '1', NULL); -- Structure of table `0_bom` -- @@ -379,13 +379,13 @@ CREATE TABLE `0_comments` ( -- Data of table `0_comments` -- INSERT INTO `0_comments` VALUES -('12', '1', '2018-05-10', 'Cash invoice 1'), -('12', '2', '2018-05-07', 'Cash invoice 2'), -('13', '4', '2018-05-07', 'Recurrent Invoice covers period 04/01/2018 - 04/07/2018.'), -('10', '4', '2018-05-07', 'Recurrent Invoice covers period 04/01/2018 - 04/07/2018.'), -('12', '3', '2018-05-07', 'Cash invoice 4'), -('12', '4', '2019-01-21', 'Default #5'), -('0', '1', '2018-12-31', 'Closing Year'); +('12', '1', '2019-05-10', 'Cash invoice 1'), +('12', '2', '2019-05-07', 'Cash invoice 2'), +('13', '4', '2019-05-07', 'Recurrent Invoice covers period 04/01/2019 - 04/07/2019.'), +('10', '4', '2019-05-07', 'Recurrent Invoice covers period 04/01/2019 - 04/07/2019.'), +('12', '3', '2019-05-07', 'Cash invoice 4'), +('12', '4', '2020-01-21', 'Default #5'), +('0', '1', '2019-12-31', 'Closing Year'); -- Structure of table `0_credit_status` -- @@ -538,10 +538,10 @@ CREATE TABLE `0_cust_allocations` ( -- Data of table `0_cust_allocations` -- INSERT INTO `0_cust_allocations` VALUES -('1', '1', '6240', '2018-05-10', '1', '12', '1', '10'), -('2', '1', '300', '2018-05-07', '2', '12', '2', '10'), -('3', '1', '0', '2018-05-07', '3', '12', '4', '10'), -('4', '1', '1250', '2019-01-21', '4', '12', '5', '10'); +('1', '1', '6240', '2019-05-10', '1', '12', '1', '10'), +('2', '1', '300', '2019-05-07', '2', '12', '2', '10'), +('3', '1', '0', '2019-05-07', '3', '12', '4', '10'), +('4', '1', '1250', '2020-01-21', '4', '12', '5', '10'); -- Structure of table `0_cust_branch` -- @@ -615,20 +615,20 @@ CREATE TABLE `0_debtor_trans` ( -- Data of table `0_debtor_trans` -- INSERT INTO `0_debtor_trans` VALUES -('1', '10', '0', '1', '1', '2018-05-10', '2018-05-05', '001/2018', '1', '1', '6240', '0', '0', '0', '0', '6240', '0', '1', '1', '0', '0', '4', '1'), -('2', '10', '0', '1', '1', '2018-05-07', '2018-05-07', '002/2018', '1', '2', '300', '0', '0', '0', '0', '300', '0', '1', '1', '0', '0', '4', '1'), -('3', '10', '0', '2', '2', '2018-05-07', '2018-06-17', '003/2018', '1', '5', '267.14', '0', '0', '0', '0', '0', '0', '1.123', '1', '1', '0', '1', '1'), -('4', '10', '0', '1', '1', '2018-05-07', '2018-05-07', '004/2018', '1', '7', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'), -('5', '10', '0', '1', '1', '2019-01-21', '2019-01-21', '001/2019', '1', '8', '1250', '0', '0', '0', '0', '1250', '0', '1', '1', '0', '0', '4', '1'), -('1', '12', '0', '1', '1', '2018-05-10', '0000-00-00', '001/2018', '0', '0', '6240', '0', '0', '0', '0', '6240', '0', '1', '0', '0', '0', NULL, '0'), -('2', '12', '0', '1', '1', '2018-05-07', '0000-00-00', '002/2018', '0', '0', '300', '0', '0', '0', '0', '300', '0', '1', '0', '0', '0', NULL, '0'), -('3', '12', '0', '1', '1', '2018-05-07', '0000-00-00', '003/2018', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', NULL, '0'), -('4', '12', '0', '1', '1', '2019-01-21', '0000-00-00', '001/2019', '0', '0', '1250', '0', '0', '0', '0', '1250', '0', '1', '0', '0', '0', NULL, '0'), -('1', '13', '1', '1', '1', '2018-05-10', '2018-05-05', 'auto', '1', '1', '6240', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'), -('2', '13', '1', '1', '1', '2018-05-07', '2018-05-07', 'auto', '1', '2', '300', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'), -('3', '13', '1', '2', '2', '2018-05-07', '2018-06-17', 'auto', '1', '5', '267.14', '0', '0', '0', '0', '0', '0', '1.123', '1', '1', '0', '1', '1'), -('4', '13', '1', '1', '1', '2018-05-07', '2018-05-07', 'auto', '1', '7', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'), -('5', '13', '1', '1', '1', '2019-01-21', '2019-01-21', 'auto', '1', '8', '1250', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'); +('1', '10', '0', '1', '1', '2019-05-10', '2019-05-05', '001/2019', '1', '1', '6240', '0', '0', '0', '0', '6240', '0', '1', '1', '0', '0', '4', '1'), +('2', '10', '0', '1', '1', '2019-05-07', '2019-05-07', '002/2019', '1', '2', '300', '0', '0', '0', '0', '300', '0', '1', '1', '0', '0', '4', '1'), +('3', '10', '0', '2', '2', '2019-05-07', '2019-06-17', '003/2019', '1', '5', '267.14', '0', '0', '0', '0', '0', '0', '1.123', '1', '1', '0', '1', '1'), +('4', '10', '0', '1', '1', '2019-05-07', '2019-05-07', '004/2019', '1', '7', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'), +('5', '10', '0', '1', '1', '2020-01-21', '2020-01-21', '001/2020', '1', '8', '1250', '0', '0', '0', '0', '1250', '0', '1', '1', '0', '0', '4', '1'), +('1', '12', '0', '1', '1', '2019-05-10', '0000-00-00', '001/2019', '0', '0', '6240', '0', '0', '0', '0', '6240', '0', '1', '0', '0', '0', NULL, '0'), +('2', '12', '0', '1', '1', '2019-05-07', '0000-00-00', '002/2019', '0', '0', '300', '0', '0', '0', '0', '300', '0', '1', '0', '0', '0', NULL, '0'), +('3', '12', '0', '1', '1', '2019-05-07', '0000-00-00', '003/2019', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', NULL, '0'), +('4', '12', '0', '1', '1', '2020-01-21', '0000-00-00', '001/2020', '0', '0', '1250', '0', '0', '0', '0', '1250', '0', '1', '0', '0', '0', NULL, '0'), +('1', '13', '1', '1', '1', '2019-05-10', '2019-05-05', 'auto', '1', '1', '6240', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'), +('2', '13', '1', '1', '1', '2019-05-07', '2019-05-07', 'auto', '1', '2', '300', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'), +('3', '13', '1', '2', '2', '2019-05-07', '2019-06-17', 'auto', '1', '5', '267.14', '0', '0', '0', '0', '0', '0', '1.123', '1', '1', '0', '1', '1'), +('4', '13', '1', '1', '1', '2019-05-07', '2019-05-07', 'auto', '1', '7', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'), +('5', '13', '1', '1', '1', '2020-01-21', '2020-01-21', 'auto', '1', '8', '1250', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'); -- Structure of table `0_debtor_trans_details` -- @@ -724,7 +724,7 @@ CREATE TABLE `0_dimensions` ( -- Data of table `0_dimensions` -- INSERT INTO `0_dimensions` VALUES -('1', '001/2018', 'Cost Centre', '1', '0', '2018-05-05', '2018-05-25'); +('1', '001/2019', 'Cost Centre', '1', '0', '2019-05-05', '2019-05-25'); -- Structure of table `0_exchange_rates` -- @@ -743,7 +743,7 @@ CREATE TABLE `0_exchange_rates` ( -- Data of table `0_exchange_rates` -- INSERT INTO `0_exchange_rates` VALUES -('1', 'EUR', '1.123', '1.123', '2018-05-07'); +('1', 'EUR', '1.123', '1.123', '2019-05-07'); -- Structure of table `0_fiscal_year` -- @@ -762,8 +762,8 @@ CREATE TABLE `0_fiscal_year` ( -- Data of table `0_fiscal_year` -- INSERT INTO `0_fiscal_year` VALUES -('1', '2018-01-01', '2018-12-31', '1'), -('2', '2019-01-01', '2019-12-31', '0'); +('1', '2019-01-01', '2019-12-31', '1'), +('2', '2020-01-01', '2020-12-31', '0'); -- Structure of table `0_gl_trans` -- @@ -792,60 +792,60 @@ CREATE TABLE `0_gl_trans` ( -- Data of table `0_gl_trans` -- INSERT INTO `0_gl_trans` VALUES -('1', '25', '1', '2018-05-05', '1510', '101', '20000', '0', '0', NULL, NULL), -('2', '25', '1', '2018-05-05', '1510', '102', '15000', '0', '0', NULL, NULL), -('3', '25', '1', '2018-05-05', '1510', '103', '1000', '0', '0', NULL, NULL), -('4', '25', '1', '2018-05-05', '1550', '', '-36000', '0', '0', NULL, NULL), -('5', '13', '1', '2018-05-10', '5010', '', '4000', '0', '0', NULL, NULL), -('6', '13', '1', '2018-05-10', '1510', '', '-4000', '0', '0', NULL, NULL), -('7', '10', '1', '2018-05-10', '4010', '', '-5714.29', '0', '0', NULL, NULL), -('8', '10', '1', '2018-05-10', '4010', '', '-228.57', '0', '0', NULL, NULL), -('9', '10', '1', '2018-05-10', '1200', '', '6240', '0', '0', '2', '1'), -('10', '10', '1', '2018-05-10', '2150', '', '-297.14', '0', '0', NULL, NULL), -('11', '12', '1', '2018-05-10', '1065', '', '6240', '0', '0', NULL, NULL), -('12', '12', '1', '2018-05-10', '1200', '', '-6240', '0', '0', '2', '1'), -('13', '29', '1', '2018-05-05', '1510', '1 * iPad Air 2 16GB', '-400', '0', '0', NULL, NULL), -('14', '29', '1', '2018-05-05', '1510', '1 * iPhone 6 64GB', '-300', '0', '0', NULL, NULL), -('15', '29', '1', '2018-05-05', '1510', '1 * iPhone Cover Case', '-20', '0', '0', NULL, NULL), -('16', '29', '1', '2018-05-05', '1530', '1 * Support', '720', '0', '0', NULL, NULL), -('17', '26', '1', '2018-05-05', '1530', '', '-720', '0', '0', NULL, NULL), -('18', '26', '1', '2018-05-05', '1510', '', '720', '0', '0', NULL, NULL), -('19', '25', '2', '2018-05-05', '1510', '101', '3000', '0', '0', NULL, NULL), -('20', '25', '2', '2018-05-05', '1550', '', '-3000', '0', '0', NULL, NULL), -('21', '20', '1', '2018-05-05', '2150', '', '150', '0', '0', NULL, NULL), -('22', '20', '1', '2018-05-05', '2100', '', '-3150', '0', '0', '3', '1'), -('23', '20', '1', '2018-05-05', '1550', '', '3000', '0', '0', NULL, NULL), -('24', '13', '2', '2018-05-07', '5010', '', '200', '0', '0', NULL, NULL), -('25', '13', '2', '2018-05-07', '1510', '', '-200', '0', '0', NULL, NULL), -('26', '10', '2', '2018-05-07', '4010', '', '-285.71', '0', '0', NULL, NULL), -('27', '10', '2', '2018-05-07', '1200', '', '300', '0', '0', '2', '1'), -('28', '10', '2', '2018-05-07', '2150', '', '-14.29', '0', '0', NULL, NULL), -('29', '12', '2', '2018-05-07', '1065', '', '300', '0', '0', NULL, NULL), -('30', '12', '2', '2018-05-07', '1200', '', '-300', '0', '0', '2', '1'), -('31', '13', '3', '2018-05-07', '5010', '', '150', '1', '0', NULL, NULL), -('32', '13', '3', '2018-05-07', '1510', '', '-150', '0', '0', NULL, NULL), -('33', '13', '3', '2018-05-07', '5010', '', '10', '1', '0', NULL, NULL), -('34', '13', '3', '2018-05-07', '1510', '', '-10', '0', '0', NULL, NULL), -('35', '10', '3', '2018-05-07', '4010', '', '-250', '1', '0', NULL, NULL), -('36', '10', '3', '2018-05-07', '4010', '', '-50', '1', '0', NULL, NULL), -('37', '10', '3', '2018-05-07', '1200', '', '300', '0', '0', '2', '2'), -('38', '12', '3', '2018-05-07', '1065', '', '0', '0', '0', NULL, NULL), -('39', '1', '1', '2018-05-07', '5010', '', '5', '1', '0', NULL, NULL), -('40', '1', '1', '2018-05-07', '1060', '', '-5', '0', '0', NULL, NULL), -('41', '13', '5', '2019-01-21', '5010', '', '750', '0', '0', NULL, NULL), -('42', '13', '5', '2019-01-21', '1510', '', '-750', '0', '0', NULL, NULL), -('43', '10', '5', '2019-01-21', '4010', '', '-1190.48', '0', '0', NULL, NULL), -('44', '10', '5', '2019-01-21', '1200', '', '1250', '0', '0', '2', '1'), -('45', '10', '5', '2019-01-21', '2150', '', '-59.52', '0', '0', NULL, NULL), -('46', '12', '4', '2019-01-21', '1065', '', '1250', '0', '0', NULL, NULL), -('47', '12', '4', '2019-01-21', '1200', '', '-1250', '0', '0', '2', '1'), -('48', '25', '3', '2019-01-21', '1510', '102', '900', '0', '0', NULL, NULL), -('49', '25', '3', '2019-01-21', '1550', '', '-900', '0', '0', NULL, NULL), -('50', '20', '2', '2019-01-21', '2150', '', '45', '0', '0', NULL, NULL), -('51', '20', '2', '2019-01-21', '2100', '', '-945', '0', '0', '3', '1'), -('52', '20', '2', '2019-01-21', '1550', '', '900', '0', '0', NULL, NULL), -('53', '0', '1', '2018-12-31', '3590', 'Closing Year', '-2163.57', '0', '0', NULL, NULL), -('54', '0', '1', '2018-12-31', '9990', 'Closing Year', '2163.57', '0', '0', NULL, NULL); +('1', '25', '1', '2019-05-05', '1510', '101', '20000', '0', '0', NULL, NULL), +('2', '25', '1', '2019-05-05', '1510', '102', '15000', '0', '0', NULL, NULL), +('3', '25', '1', '2019-05-05', '1510', '103', '1000', '0', '0', NULL, NULL), +('4', '25', '1', '2019-05-05', '1550', '', '-36000', '0', '0', NULL, NULL), +('5', '13', '1', '2019-05-10', '5010', '', '4000', '0', '0', NULL, NULL), +('6', '13', '1', '2019-05-10', '1510', '', '-4000', '0', '0', NULL, NULL), +('7', '10', '1', '2019-05-10', '4010', '', '-5714.29', '0', '0', NULL, NULL), +('8', '10', '1', '2019-05-10', '4010', '', '-228.57', '0', '0', NULL, NULL), +('9', '10', '1', '2019-05-10', '1200', '', '6240', '0', '0', '2', '1'), +('10', '10', '1', '2019-05-10', '2150', '', '-297.14', '0', '0', NULL, NULL), +('11', '12', '1', '2019-05-10', '1065', '', '6240', '0', '0', NULL, NULL), +('12', '12', '1', '2019-05-10', '1200', '', '-6240', '0', '0', '2', '1'), +('13', '29', '1', '2019-05-05', '1510', '1 * iPad Air 2 16GB', '-400', '0', '0', NULL, NULL), +('14', '29', '1', '2019-05-05', '1510', '1 * iPhone 6 64GB', '-300', '0', '0', NULL, NULL), +('15', '29', '1', '2019-05-05', '1510', '1 * iPhone Cover Case', '-20', '0', '0', NULL, NULL), +('16', '29', '1', '2019-05-05', '1530', '1 * Support', '720', '0', '0', NULL, NULL), +('17', '26', '1', '2019-05-05', '1530', '', '-720', '0', '0', NULL, NULL), +('18', '26', '1', '2019-05-05', '1510', '', '720', '0', '0', NULL, NULL), +('19', '25', '2', '2019-05-05', '1510', '101', '3000', '0', '0', NULL, NULL), +('20', '25', '2', '2019-05-05', '1550', '', '-3000', '0', '0', NULL, NULL), +('21', '20', '1', '2019-05-05', '2150', '', '150', '0', '0', NULL, NULL), +('22', '20', '1', '2019-05-05', '2100', '', '-3150', '0', '0', '3', '1'), +('23', '20', '1', '2019-05-05', '1550', '', '3000', '0', '0', NULL, NULL), +('24', '13', '2', '2019-05-07', '5010', '', '200', '0', '0', NULL, NULL), +('25', '13', '2', '2019-05-07', '1510', '', '-200', '0', '0', NULL, NULL), +('26', '10', '2', '2019-05-07', '4010', '', '-285.71', '0', '0', NULL, NULL), +('27', '10', '2', '2019-05-07', '1200', '', '300', '0', '0', '2', '1'), +('28', '10', '2', '2019-05-07', '2150', '', '-14.29', '0', '0', NULL, NULL), +('29', '12', '2', '2019-05-07', '1065', '', '300', '0', '0', NULL, NULL), +('30', '12', '2', '2019-05-07', '1200', '', '-300', '0', '0', '2', '1'), +('31', '13', '3', '2019-05-07', '5010', '', '150', '1', '0', NULL, NULL), +('32', '13', '3', '2019-05-07', '1510', '', '-150', '0', '0', NULL, NULL), +('33', '13', '3', '2019-05-07', '5010', '', '10', '1', '0', NULL, NULL), +('34', '13', '3', '2019-05-07', '1510', '', '-10', '0', '0', NULL, NULL), +('35', '10', '3', '2019-05-07', '4010', '', '-250', '1', '0', NULL, NULL), +('36', '10', '3', '2019-05-07', '4010', '', '-50', '1', '0', NULL, NULL), +('37', '10', '3', '2019-05-07', '1200', '', '300', '0', '0', '2', '2'), +('38', '12', '3', '2019-05-07', '1065', '', '0', '0', '0', NULL, NULL), +('39', '1', '1', '2019-05-07', '5010', '', '5', '1', '0', NULL, NULL), +('40', '1', '1', '2019-05-07', '1060', '', '-5', '0', '0', NULL, NULL), +('41', '13', '5', '2020-01-21', '5010', '', '750', '0', '0', NULL, NULL), +('42', '13', '5', '2020-01-21', '1510', '', '-750', '0', '0', NULL, NULL), +('43', '10', '5', '2020-01-21', '4010', '', '-1190.48', '0', '0', NULL, NULL), +('44', '10', '5', '2020-01-21', '1200', '', '1250', '0', '0', '2', '1'), +('45', '10', '5', '2020-01-21', '2150', '', '-59.52', '0', '0', NULL, NULL), +('46', '12', '4', '2020-01-21', '1065', '', '1250', '0', '0', NULL, NULL), +('47', '12', '4', '2020-01-21', '1200', '', '-1250', '0', '0', '2', '1'), +('48', '25', '3', '2020-01-21', '1510', '102', '900', '0', '0', NULL, NULL), +('49', '25', '3', '2020-01-21', '1550', '', '-900', '0', '0', NULL, NULL), +('50', '20', '2', '2020-01-21', '2150', '', '45', '0', '0', NULL, NULL), +('51', '20', '2', '2020-01-21', '2100', '', '-945', '0', '0', '3', '1'), +('52', '20', '2', '2020-01-21', '1550', '', '900', '0', '0', NULL, NULL), +('53', '0', '1', '2019-12-31', '3590', 'Closing Year', '-2163.57', '0', '0', NULL, NULL), +('54', '0', '1', '2019-12-31', '9990', 'Closing Year', '2163.57', '0', '0', NULL, NULL); -- Structure of table `0_grn_batch` -- @@ -867,9 +867,9 @@ CREATE TABLE `0_grn_batch` ( -- Data of table `0_grn_batch` -- INSERT INTO `0_grn_batch` VALUES -('1', '1', '1', '001/2018', '2018-05-05', 'DEF', '1'), -('2', '1', '2', 'auto', '2018-05-05', 'DEF', '1'), -('3', '1', '3', 'auto', '2019-01-21', 'DEF', '1'); +('1', '1', '1', '001/2019', '2019-05-05', 'DEF', '1'), +('2', '1', '2', 'auto', '2019-05-05', 'DEF', '1'), +('3', '1', '3', 'auto', '2020-01-21', 'DEF', '1'); -- Structure of table `0_grn_items` -- @@ -1016,7 +1016,7 @@ CREATE TABLE `0_journal` ( -- Data of table `0_journal` -- INSERT INTO `0_journal` VALUES -('0', '1', '2018-12-31', '001/2012', '', '2018-12-31', '2018-12-31', 'USD', '2163.57', '1'); +('0', '1', '2019-12-31', '001/2012', '', '2019-12-31', '2019-12-31', 'USD', '2163.57', '1'); -- Structure of table `0_loc_stock` -- @@ -1201,11 +1201,11 @@ CREATE TABLE `0_purch_order_details` ( -- Data of table `0_purch_order_details` -- INSERT INTO `0_purch_order_details` VALUES -('1', '1', '101', 'iPad Air 2 16GB', '2018-05-15', '0', '200', '200', '200', '100', '100'), -('2', '1', '102', 'iPhone 6 64GB', '2018-05-15', '0', '150', '150', '150', '100', '100'), -('3', '1', '103', 'iPhone Cover Case', '2018-05-15', '0', '10', '10', '10', '100', '100'), -('4', '2', '101', 'iPad Air 2 16GB', '2018-05-05', '15', '200', '200', '200', '15', '15'), -('5', '3', '102', 'iPhone 6 64GB', '2019-01-21', '6', '150', '150', '150', '6', '6'); +('1', '1', '101', 'iPad Air 2 16GB', '2019-05-15', '0', '200', '200', '200', '100', '100'), +('2', '1', '102', 'iPhone 6 64GB', '2019-05-15', '0', '150', '150', '150', '100', '100'), +('3', '1', '103', 'iPhone Cover Case', '2019-05-15', '0', '10', '10', '10', '100', '100'), +('4', '2', '101', 'iPad Air 2 16GB', '2019-05-05', '15', '200', '200', '200', '15', '15'), +('5', '3', '102', 'iPhone 6 64GB', '2020-01-21', '6', '150', '150', '150', '6', '6'); -- Structure of table `0_purch_orders` -- @@ -1231,9 +1231,9 @@ CREATE TABLE `0_purch_orders` ( -- Data of table `0_purch_orders` -- INSERT INTO `0_purch_orders` VALUES -('1', '1', NULL, '2018-05-05', '001/2018', NULL, 'DEF', 'N/A', '37800', '0', '0', '0'), -('2', '1', NULL, '2018-05-05', 'auto', 'rr4', 'DEF', 'N/A', '3150', '0', '0', '0'), -('3', '1', NULL, '2019-01-21', 'auto', 'asd5', 'DEF', 'N/A', '945', '0', '0', '0'); +('1', '1', NULL, '2019-05-05', '001/2019', NULL, 'DEF', 'N/A', '37800', '0', '0', '0'), +('2', '1', NULL, '2019-05-05', 'auto', 'rr4', 'DEF', 'N/A', '3150', '0', '0', '0'), +('3', '1', NULL, '2020-01-21', 'auto', 'asd5', 'DEF', 'N/A', '945', '0', '0', '0'); -- Structure of table `0_quick_entries` -- @@ -1307,7 +1307,7 @@ CREATE TABLE `0_recurrent_invoices` ( -- Data of table `0_recurrent_invoices` -- INSERT INTO `0_recurrent_invoices` VALUES -('1', 'Weekly Maintenance', '6', '1', '1', '7', '0', '2018-04-01', '2020-05-07', '2018-04-08'); +('1', 'Weekly Maintenance', '6', '1', '1', '7', '0', '2019-04-01', '2020-05-07', '2019-04-08'); -- Structure of table `0_reflines` -- @@ -1366,27 +1366,27 @@ CREATE TABLE `0_refs` ( -- Data of table `0_refs` -- INSERT INTO `0_refs` VALUES -('1', '1', '001/2018'), -('1', '10', '001/2018'), -('5', '10', '001/2019'), -('2', '10', '002/2018'), -('3', '10', '003/2018'), -('4', '10', '004/2018'), -('1', '12', '001/2018'), -('4', '12', '001/2019'), -('2', '12', '002/2018'), -('3', '12', '003/2018'), -('1', '18', '001/2018'), -('1', '20', '001/2018'), -('2', '20', '001/2019'), -('1', '25', '001/2018'), -('1', '26', '001/2018'), -('2', '26', '002/2018'), -('3', '26', '003/2018'), -('3', '30', '001/2018'), -('4', '30', '002/2018'), -('6', '30', '003/2018'), -('1', '40', '001/2018'); +('1', '1', '001/2019'), +('1', '10', '001/2019'), +('5', '10', '001/2020'), +('2', '10', '002/2019'), +('3', '10', '003/2019'), +('4', '10', '004/2019'), +('1', '12', '001/2019'), +('4', '12', '001/2020'), +('2', '12', '002/2019'), +('3', '12', '003/2019'), +('1', '18', '001/2019'), +('1', '20', '001/2019'), +('2', '20', '001/2020'), +('1', '25', '001/2019'), +('1', '26', '001/2019'), +('2', '26', '002/2019'), +('3', '26', '003/2019'), +('3', '30', '001/2019'), +('4', '30', '002/2019'), +('6', '30', '003/2019'), +('1', '40', '001/2019'); -- Structure of table `0_sales_order_details` -- @@ -1457,14 +1457,14 @@ CREATE TABLE `0_sales_orders` ( -- Data of table `0_sales_orders` -- INSERT INTO `0_sales_orders` VALUES -('1', '30', '1', '0', '1', '1', 'auto', '', NULL, '2018-05-10', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2018-05-05', '4', '6240', '0', '0'), -('2', '30', '1', '0', '1', '1', 'auto', '', NULL, '2018-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2018-05-07', '4', '300', '0', '0'), -('3', '30', '0', '0', '1', '1', '001/2018', '', NULL, '2018-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2018-05-08', '4', '300', '0', '0'), -('4', '30', '0', '0', '2', '2', '002/2018', '', NULL, '2018-05-07', '1', '1', 'N/A', NULL, NULL, 'MoneyMaker Ltd.', '0', 'DEF', '2018-05-08', '1', '267.14', '0', '0'), -('5', '30', '1', '0', '2', '2', 'auto', '', NULL, '2018-05-07', '1', '1', 'N/A', NULL, NULL, 'MoneyMaker Ltd.', '0', 'DEF', '2018-06-17', '1', '267.14', '0', '0'), -('6', '30', '0', '1', '1', '1', '003/2018', '', NULL, '2018-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2018-05-08', '4', '450', '0', '0'), -('7', '30', '1', '0', '1', '1', 'auto', '', 'Recurrent Invoice covers period 04/01/2018 - 04/07/2018.', '2018-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2018-05-07', '4', '0', '0', '0'), -('8', '30', '1', '0', '1', '1', 'auto', '', NULL, '2019-01-21', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2019-01-21', '4', '1250', '0', '0'); +('1', '30', '1', '0', '1', '1', 'auto', '', NULL, '2019-05-10', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2019-05-05', '4', '6240', '0', '0'), +('2', '30', '1', '0', '1', '1', 'auto', '', NULL, '2019-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2019-05-07', '4', '300', '0', '0'), +('3', '30', '0', '0', '1', '1', '001/2019', '', NULL, '2019-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2019-05-08', '4', '300', '0', '0'), +('4', '30', '0', '0', '2', '2', '002/2019', '', NULL, '2019-05-07', '1', '1', 'N/A', NULL, NULL, 'MoneyMaker Ltd.', '0', 'DEF', '2019-05-08', '1', '267.14', '0', '0'), +('5', '30', '1', '0', '2', '2', 'auto', '', NULL, '2019-05-07', '1', '1', 'N/A', NULL, NULL, 'MoneyMaker Ltd.', '0', 'DEF', '2019-06-17', '1', '267.14', '0', '0'), +('6', '30', '0', '1', '1', '1', '003/2019', '', NULL, '2019-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2019-05-08', '4', '450', '0', '0'), +('7', '30', '1', '0', '1', '1', 'auto', '', 'Recurrent Invoice covers period 04/01/2019 - 04/07/2019.', '2019-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2019-05-07', '4', '0', '0', '0'), +('8', '30', '1', '0', '1', '1', 'auto', '', NULL, '2020-01-21', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2020-01-21', '4', '1250', '0', '0'); -- Structure of table `0_sales_pos` -- @@ -1712,23 +1712,23 @@ CREATE TABLE `0_stock_moves` ( -- Data of table `0_stock_moves` -- INSERT INTO `0_stock_moves` VALUES -('1', '1', '101', '25', 'DEF', '2018-05-05', '200', '', '100', '200'), -('2', '1', '102', '25', 'DEF', '2018-05-05', '150', '', '100', '150'), -('3', '1', '103', '25', 'DEF', '2018-05-05', '10', '', '100', '10'), -('4', '1', '101', '13', 'DEF', '2018-05-10', '300', 'auto', '-20', '200'), -('5', '1', '301', '13', 'DEF', '2018-05-10', '80', 'auto', '-3', '0'), -('6', '1', '101', '29', 'DEF', '2018-05-05', '200', '001/2018', '-2', '200'), -('7', '1', '102', '29', 'DEF', '2018-05-05', '150', '001/2018', '-2', '150'), -('8', '1', '103', '29', 'DEF', '2018-05-05', '10', '001/2018', '-2', '10'), -('9', '1', '301', '29', 'DEF', '2018-05-05', '0', '001/2018', '-2', '0'), -('10', '1', '201', '26', 'DEF', '2018-05-05', '0', '001/2018', '2', '360'), -('11', '2', '101', '25', 'DEF', '2018-05-05', '200', '', '15', '200'), -('12', '2', '101', '13', 'DEF', '2018-05-07', '300', 'auto', '-1', '200'), -('13', '3', '102', '13', 'DEF', '2018-05-07', '222.62', 'auto', '-1', '150'), -('14', '3', '103', '13', 'DEF', '2018-05-07', '44.52', 'auto', '-1', '10'), -('15', '4', '202', '13', 'DEF', '2018-05-07', '0', 'auto', '-5', '0'), -('16', '5', '102', '13', 'DEF', '2019-01-21', '250', 'auto', '-5', '150'), -('17', '3', '102', '25', 'DEF', '2019-01-21', '150', '', '6', '150'); +('1', '1', '101', '25', 'DEF', '2019-05-05', '200', '', '100', '200'), +('2', '1', '102', '25', 'DEF', '2019-05-05', '150', '', '100', '150'), +('3', '1', '103', '25', 'DEF', '2019-05-05', '10', '', '100', '10'), +('4', '1', '101', '13', 'DEF', '2019-05-10', '300', 'auto', '-20', '200'), +('5', '1', '301', '13', 'DEF', '2019-05-10', '80', 'auto', '-3', '0'), +('6', '1', '101', '29', 'DEF', '2019-05-05', '200', '001/2019', '-2', '200'), +('7', '1', '102', '29', 'DEF', '2019-05-05', '150', '001/2019', '-2', '150'), +('8', '1', '103', '29', 'DEF', '2019-05-05', '10', '001/2019', '-2', '10'), +('9', '1', '301', '29', 'DEF', '2019-05-05', '0', '001/2019', '-2', '0'), +('10', '1', '201', '26', 'DEF', '2019-05-05', '0', '001/2019', '2', '360'), +('11', '2', '101', '25', 'DEF', '2019-05-05', '200', '', '15', '200'), +('12', '2', '101', '13', 'DEF', '2019-05-07', '300', 'auto', '-1', '200'), +('13', '3', '102', '13', 'DEF', '2019-05-07', '222.62', 'auto', '-1', '150'), +('14', '3', '103', '13', 'DEF', '2019-05-07', '44.52', 'auto', '-1', '10'), +('15', '4', '202', '13', 'DEF', '2019-05-07', '0', 'auto', '-5', '0'), +('16', '5', '102', '13', 'DEF', '2020-01-21', '250', 'auto', '-5', '150'), +('17', '3', '102', '25', 'DEF', '2020-01-21', '150', '', '6', '150'); -- Structure of table `0_supp_allocations` -- @@ -1806,8 +1806,8 @@ CREATE TABLE `0_supp_trans` ( -- Data of table `0_supp_trans` -- INSERT INTO `0_supp_trans` VALUES -('1', '20', '1', '001/2018', 'rr4', '2018-05-05', '2018-05-15', '3000', '0', '150', '1', '0', '0'), -('2', '20', '1', '001/2019', 'asd5', '2019-01-21', '2019-01-31', '900', '0', '45', '1', '0', '0'); +('1', '20', '1', '001/2019', 'rr4', '2019-05-05', '2019-05-15', '3000', '0', '150', '1', '0', '0'), +('2', '20', '1', '001/2020', 'asd5', '2020-01-21', '2020-01-31', '900', '0', '45', '1', '0', '0'); -- Structure of table `0_suppliers` -- @@ -2045,16 +2045,16 @@ CREATE TABLE `0_trans_tax_details` ( -- Data of table `0_trans_tax_details` -- INSERT INTO `0_trans_tax_details` VALUES -('1', '13', '1', '2018-05-10', '1', '5', '1', '1', '5942.86', '297.14', 'auto', NULL), -('2', '10', '1', '2018-05-10', '1', '5', '1', '1', '5942.86', '297.14', '001/2018', '0'), -('3', '20', '1', '2018-05-05', '1', '5', '1', '0', '3000', '150', 'rr4', '1'), -('4', '13', '2', '2018-05-07', '1', '5', '1', '1', '285.71', '14.29', 'auto', NULL), -('5', '10', '2', '2018-05-07', '1', '5', '1', '1', '285.71', '14.29', '002/2018', '0'), -('6', '13', '3', '2018-05-07', '0', '0', '1.123', '1', '267.14', '0', 'auto', NULL), -('7', '10', '3', '2018-05-07', '0', '0', '1.123', '1', '267.14', '0', '003/2018', '0'), -('8', '13', '5', '2019-01-21', '1', '5', '1', '1', '1190.48', '59.52', 'auto', NULL), -('9', '10', '5', '2019-01-21', '1', '5', '1', '1', '1190.48', '59.52', '001/2019', '0'), -('10', '20', '2', '2019-01-21', '1', '5', '1', '0', '900', '45', 'asd5', '1'); +('1', '13', '1', '2019-05-10', '1', '5', '1', '1', '5942.86', '297.14', 'auto', NULL), +('2', '10', '1', '2019-05-10', '1', '5', '1', '1', '5942.86', '297.14', '001/2019', '0'), +('3', '20', '1', '2019-05-05', '1', '5', '1', '0', '3000', '150', 'rr4', '1'), +('4', '13', '2', '2019-05-07', '1', '5', '1', '1', '285.71', '14.29', 'auto', NULL), +('5', '10', '2', '2019-05-07', '1', '5', '1', '1', '285.71', '14.29', '002/2019', '0'), +('6', '13', '3', '2019-05-07', '0', '0', '1.123', '1', '267.14', '0', 'auto', NULL), +('7', '10', '3', '2019-05-07', '0', '0', '1.123', '1', '267.14', '0', '003/2019', '0'), +('8', '13', '5', '2020-01-21', '1', '5', '1', '1', '1190.48', '59.52', 'auto', NULL), +('9', '10', '5', '2020-01-21', '1', '5', '1', '1', '1190.48', '59.52', '001/2020', '0'), +('10', '20', '2', '2020-01-21', '1', '5', '1', '0', '900', '45', 'asd5', '1'); -- Structure of table `0_useronline` -- @@ -2120,7 +2120,7 @@ CREATE TABLE `0_users` ( -- Data of table `0_users` -- INSERT INTO `0_users` VALUES -('1', 'admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'Administrator', '2', '', 'adm@example.com', 'C', '0', '0', '0', '0', 'default', 'Letter', '2', '2', '4', '1', '1', '0', '0', '2018-05-07 13:58:33', '10', '1', '1', '1', '1', '0', 'orders', '30', '0', '1', '0', '0', '0'); +('1', 'admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'Administrator', '2', '', 'adm@example.com', 'C', '0', '0', '0', '0', 'default', 'Letter', '2', '2', '4', '1', '1', '0', '0', '2019-05-07 13:58:33', '10', '1', '1', '1', '1', '0', 'orders', '30', '0', '1', '0', '0', '0'); -- Structure of table `0_voided` -- @@ -2203,7 +2203,7 @@ CREATE TABLE `0_wo_manufacture` ( -- Data of table `0_wo_manufacture` -- INSERT INTO `0_wo_manufacture` VALUES -('1', '001/2018', '1', '2', '2018-05-05'); +('1', '001/2019', '1', '2', '2019-05-05'); -- Structure of table `0_wo_requirements` -- @@ -2277,6 +2277,6 @@ CREATE TABLE `0_workorders` ( -- Data of table `0_workorders` -- INSERT INTO `0_workorders` VALUES -('1', '001/2018', 'DEF', '2', '201', '2018-05-05', '0', '2018-05-05', '2018-05-05', '2', '1', '1', '0'), -('2', '002/2018', 'DEF', '5', '201', '2018-05-07', '2', '2018-05-27', '2018-05-07', '0', '0', '1', '0'), -('3', '003/2018', 'DEF', '5', '201', '2018-05-07', '2', '2018-05-27', '0000-00-00', '0', '0', '0', '0'); \ No newline at end of file +('1', '001/2019', 'DEF', '2', '201', '2019-05-05', '0', '2019-05-05', '2019-05-05', '2', '1', '1', '0'), +('2', '002/2019', 'DEF', '5', '201', '2019-05-07', '2', '2019-05-27', '2019-05-07', '0', '0', '1', '0'), +('3', '003/2019', 'DEF', '5', '201', '2019-05-07', '2', '2019-05-27', '0000-00-00', '0', '0', '0', '0'); \ No newline at end of file diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql index e1ddc2d7..bef15c4d 100644 --- a/sql/en_US-new.sql +++ b/sql/en_US-new.sql @@ -1,6 +1,6 @@ -- MySQL dump of database 'en_US-new' on host 'localhost' --- Backup Date and Time: 2019-01-21 11:16 --- Built by FrontAccounting 2.4.6 +-- Backup Date and Time: 2020-01-21 11:16 +-- Built by FrontAccounting 2.4.7 -- http://frontaccounting.com -- Company: Training Co. -- User: Administrator @@ -636,7 +636,7 @@ CREATE TABLE `0_fiscal_year` ( -- Data of table `0_fiscal_year` -- INSERT INTO `0_fiscal_year` VALUES -('1', '2018-01-01', '2018-12-31', '1'); +('1', '2019-01-01', '2019-12-31', '1'); -- Structure of table `0_gl_trans` -- @@ -1781,7 +1781,7 @@ CREATE TABLE `0_users` ( -- Data of table `0_users` -- INSERT INTO `0_users` VALUES -('1', 'admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'Administrator', '2', '', 'adm@example.com', 'C', '0', '0', '0', '0', 'default', 'Letter', '2', '2', '4', '1', '1', '0', '0', '2018-05-07 13:58:33', '10', '1', '1', '1', '1', '0', 'orders', '30', '0', '1', '0', '0', '0'); +('1', 'admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'Administrator', '2', '', 'adm@example.com', 'C', '0', '0', '0', '0', 'default', 'Letter', '2', '2', '4', '1', '1', '0', '0', '2019-05-07 13:58:33', '10', '1', '1', '1', '1', '0', 'orders', '30', '0', '1', '0', '0', '0'); -- Structure of table `0_voided` -- -- 2.30.2