X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Fen_US-demo.sql;h=54774a41ff296347541c3b89e34e80339c5d234d;hb=7e6e0807990447d2977b970c3a0fd28dc9250194;hp=222ad624ca400df4522512c4750323b453a8c527;hpb=4cbf62efc1b751d9842fdf8f528e385dab73d50d;p=fa-stable.git diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql index 222ad624..54774a41 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` -- @@ -117,7 +117,7 @@ CREATE TABLE `0_bank_accounts` ( `bank_account_name` varchar(60) NOT NULL DEFAULT '', `bank_account_number` varchar(100) NOT NULL DEFAULT '', `bank_name` varchar(60) NOT NULL DEFAULT '', - `bank_address` tinytext COLLATE utf8_unicode_ci, + `bank_address` tinytext, `bank_curr_code` char(3) NOT NULL DEFAULT '', `dflt_curr_act` tinyint(1) NOT NULL DEFAULT '0', `id` smallint(6) NOT NULL AUTO_INCREMENT, @@ -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` -- @@ -215,7 +215,6 @@ CREATE TABLE `0_budget_trans` ( -- Data of table `0_budget_trans` -- - -- Structure of table `0_chart_class` -- DROP TABLE IF EXISTS `0_chart_class`; @@ -353,9 +352,6 @@ CREATE TABLE `0_chart_types` ( INSERT INTO `0_chart_types` VALUES ('1', 'Current Assets', '1', '', '0'), -('10', 'Cost of Goods Sold', '4', '', '0'), -('11', 'Payroll Expenses', '4', '', '0'), -('12', 'General & Administrative expenses', '4', '', '0'), ('2', 'Inventory Assets', '1', '', '0'), ('3', 'Capital Assets', '1', '', '0'), ('4', 'Current Liabilities', '2', '', '0'), @@ -363,7 +359,10 @@ INSERT INTO `0_chart_types` VALUES ('6', 'Share Capital', '2', '', '0'), ('7', 'Retained Earnings', '2', '', '0'), ('8', 'Sales Revenue', '3', '', '0'), -('9', 'Other Revenue', '3', '', '0'); +('9', 'Other Revenue', '3', '', '0'), +('10', 'Cost of Goods Sold', '4', '', '0'), +('11', 'Payroll Expenses', '4', '', '0'), +('12', 'General & Administrative expenses', '4', '', '0'); -- Structure of table `0_comments` -- @@ -373,20 +372,20 @@ CREATE TABLE `0_comments` ( `type` int(11) NOT NULL DEFAULT '0', `id` int(11) NOT NULL DEFAULT '0', `date_` date DEFAULT '0000-00-00', - `memo_` tinytext COLLATE utf8_unicode_ci, + `memo_` tinytext, KEY `type_and_id` (`type`,`id`) ) ENGINE=InnoDB ; -- 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` -- @@ -474,7 +473,7 @@ CREATE TABLE `0_crm_persons` ( `ref` varchar(30) NOT NULL, `name` varchar(60) NOT NULL, `name2` varchar(60) DEFAULT NULL, - `address` tinytext COLLATE utf8_unicode_ci, + `address` tinytext, `phone` varchar(30) DEFAULT NULL, `phone2` varchar(30) DEFAULT NULL, `fax` varchar(30) DEFAULT NULL, @@ -539,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` -- @@ -616,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` -- @@ -640,7 +639,7 @@ CREATE TABLE `0_debtor_trans_details` ( `debtor_trans_no` int(11) DEFAULT NULL, `debtor_trans_type` int(11) DEFAULT NULL, `stock_id` varchar(20) NOT NULL DEFAULT '', - `description` tinytext COLLATE utf8_unicode_ci, + `description` tinytext, `unit_price` double NOT NULL DEFAULT '0', `unit_tax` double NOT NULL DEFAULT '0', `quantity` double NOT NULL DEFAULT '0', @@ -679,7 +678,7 @@ CREATE TABLE `0_debtors_master` ( `debtor_no` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL DEFAULT '', `debtor_ref` varchar(30) NOT NULL, - `address` tinytext COLLATE utf8_unicode_ci, + `address` tinytext, `tax_id` varchar(55) NOT NULL DEFAULT '', `curr_code` char(3) NOT NULL DEFAULT '', `sales_type` int(11) NOT NULL DEFAULT '1', @@ -725,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` -- @@ -744,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` -- @@ -763,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` -- @@ -793,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` -- @@ -868,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` -- @@ -881,7 +880,7 @@ CREATE TABLE `0_grn_items` ( `grn_batch_id` int(11) DEFAULT NULL, `po_detail_item` int(11) NOT NULL DEFAULT '0', `item_code` varchar(20) NOT NULL DEFAULT '', - `description` tinytext COLLATE utf8_unicode_ci, + `description` tinytext, `qty_recd` double NOT NULL DEFAULT '0', `quantity_inv` double NOT NULL DEFAULT '0', PRIMARY KEY (`id`), @@ -958,7 +957,6 @@ CREATE TABLE `0_item_tax_type_exemptions` ( -- Data of table `0_item_tax_type_exemptions` -- - -- Structure of table `0_item_tax_types` -- DROP TABLE IF EXISTS `0_item_tax_types`; @@ -1018,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` -- @@ -1187,7 +1185,7 @@ CREATE TABLE `0_purch_order_details` ( `po_detail_item` int(11) NOT NULL AUTO_INCREMENT, `order_no` int(11) NOT NULL DEFAULT '0', `item_code` varchar(20) NOT NULL DEFAULT '', - `description` tinytext COLLATE utf8_unicode_ci, + `description` tinytext, `delivery_date` date NOT NULL DEFAULT '0000-00-00', `qty_invoiced` double NOT NULL DEFAULT '0', `unit_price` double NOT NULL DEFAULT '0', @@ -1203,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` -- @@ -1216,10 +1214,10 @@ DROP TABLE IF EXISTS `0_purch_orders`; CREATE TABLE `0_purch_orders` ( `order_no` int(11) NOT NULL AUTO_INCREMENT, `supplier_id` int(11) NOT NULL DEFAULT '0', - `comments` tinytext COLLATE utf8_unicode_ci, + `comments` tinytext, `ord_date` date NOT NULL DEFAULT '0000-00-00', `reference` tinytext NOT NULL, - `requisition_no` tinytext COLLATE utf8_unicode_ci, + `requisition_no` tinytext, `into_stock_location` varchar(5) NOT NULL DEFAULT '', `delivery_address` tinytext NOT NULL, `total` double NOT NULL DEFAULT '0', @@ -1233,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` -- @@ -1309,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` -- @@ -1368,28 +1366,27 @@ CREATE TABLE `0_refs` ( -- Data of table `0_refs` -- INSERT INTO `0_refs` VALUES -('1', '0', '001/2012'), -('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` -- @@ -1400,7 +1397,7 @@ CREATE TABLE `0_sales_order_details` ( `order_no` int(11) NOT NULL DEFAULT '0', `trans_type` smallint(6) NOT NULL DEFAULT '30', `stk_code` varchar(20) NOT NULL DEFAULT '', - `description` tinytext COLLATE utf8_unicode_ci, + `description` tinytext, `qty_sent` double NOT NULL DEFAULT '0', `unit_price` double NOT NULL DEFAULT '0', `quantity` double NOT NULL DEFAULT '0', @@ -1439,7 +1436,7 @@ CREATE TABLE `0_sales_orders` ( `branch_code` int(11) NOT NULL DEFAULT '0', `reference` varchar(100) NOT NULL DEFAULT '', `customer_ref` tinytext NOT NULL, - `comments` tinytext COLLATE utf8_unicode_ci, + `comments` tinytext, `ord_date` date NOT NULL DEFAULT '0000-00-00', `order_type` int(11) NOT NULL DEFAULT '0', `ship_via` int(11) NOT NULL DEFAULT '0', @@ -1455,19 +1452,19 @@ CREATE TABLE `0_sales_orders` ( `prep_amount` double NOT NULL DEFAULT '0', `alloc` double NOT NULL DEFAULT '0', PRIMARY KEY (`trans_type`,`order_no`) -) ENGINE=InnoDB ; +) ENGINE=InnoDB; -- 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` -- @@ -1541,8 +1538,8 @@ CREATE TABLE `0_security_roles` ( `id` int(11) NOT NULL AUTO_INCREMENT, `role` varchar(30) NOT NULL, `description` varchar(50) DEFAULT NULL, - `sections` text COLLATE utf8_unicode_ci, - `areas` text COLLATE utf8_unicode_ci, + `sections` text, + `areas` text, `inactive` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `role` (`role`) @@ -1646,7 +1643,6 @@ CREATE TABLE `0_stock_fa_class` ( -- Data of table `0_stock_fa_class` -- - -- Structure of table `0_stock_master` -- DROP TABLE IF EXISTS `0_stock_master`; @@ -1716,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` -- @@ -1755,7 +1751,6 @@ CREATE TABLE `0_supp_allocations` ( -- Data of table `0_supp_allocations` -- - -- Structure of table `0_supp_invoice_items` -- DROP TABLE IF EXISTS `0_supp_invoice_items`; @@ -1768,11 +1763,11 @@ CREATE TABLE `0_supp_invoice_items` ( `grn_item_id` int(11) DEFAULT NULL, `po_detail_item_id` int(11) DEFAULT NULL, `stock_id` varchar(20) NOT NULL DEFAULT '', - `description` tinytext COLLATE utf8_unicode_ci, + `description` tinytext, `quantity` double NOT NULL DEFAULT '0', `unit_price` double NOT NULL DEFAULT '0', `unit_tax` double NOT NULL DEFAULT '0', - `memo_` tinytext COLLATE utf8_unicode_ci, + `memo_` tinytext, `dimension_id` int(11) NOT NULL DEFAULT '0', `dimension2_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), @@ -1811,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` -- @@ -1868,118 +1863,84 @@ CREATE TABLE `0_sys_prefs` ( -- Data of table `0_sys_prefs` -- INSERT INTO `0_sys_prefs` VALUES -('coy_name', 'setup.company', 'varchar', '60', 'Training Co'), -('gst_no', 'setup.company', 'varchar', '25', '33445566'), -('accounts_alpha', 'glsetup.general', 'tinyint', '1', '0'), -('accumulate_shipping', 'glsetup.customer', 'tinyint', '1', '0'), -('add_pct', 'setup.company', 'int', '5', '-1'), -('allow_negative_prices', 'glsetup.inventory', 'tinyint', '1', '1'), -('allow_negative_stock', 'glsetup.inventory', 'tinyint', '1', '0'), -('alternative_tax_include_on_docs', 'setup.company', 'tinyint', '1', ''), -('auto_curr_reval', 'setup.company', 'smallint', '6', '1'), -('bank_charge_act', 'glsetup.general', 'varchar', '15', '5690'), -('barcodes_on_stock', 'setup.company', 'tinyint', '1', '0'), -('base_sales', 'setup.company', 'int', '11', '1'), -('bcc_email', 'setup.company', 'varchar', '100', ''), -('company_logo_report', 'setup.company', 'tinyint', '1', '0'), -('coy_logo', 'setup.company', 'varchar', '100', 'logo_frontaccounting.jpg'), -('coy_no', 'setup.company', 'varchar', '25', ''), -('creditors_act', 'glsetup.purchase', 'varchar', '15', '2100'), -('curr_default', 'setup.company', 'char', '3', 'USD'), -('debtors_act', 'glsetup.sales', 'varchar', '15', '1200'), -('default_adj_act', 'glsetup.items', 'varchar', '15', '5040'), -('default_cogs_act', 'glsetup.items', 'varchar', '15', '5010'), -('default_credit_limit', 'glsetup.customer', 'int', '11', '1000'), -('default_delivery_required', 'glsetup.sales', 'smallint', '6', '1'), -('default_dim_required', 'glsetup.dims', 'int', '11', '20'), -('default_inv_sales_act', 'glsetup.items', 'varchar', '15', '4010'), -('default_inventory_act', 'glsetup.items', 'varchar', '15', '1510'), -('default_loss_on_asset_disposal_act', 'glsetup.items', 'varchar', '15', '5660'), -('default_prompt_payment_act', 'glsetup.sales', 'varchar', '15', '4500'), -('default_quote_valid_days', 'glsetup.sales', 'smallint', '6', '30'), -('default_receival_required', 'glsetup.purchase', 'smallint', '6', '10'), -('default_sales_act', 'glsetup.sales', 'varchar', '15', '4010'), -('default_sales_discount_act', 'glsetup.sales', 'varchar', '15', '4510'), -('default_wip_act', 'glsetup.items', 'varchar', '15', '1530'), -('default_workorder_required', 'glsetup.manuf', 'int', '11', '20'), +('coy_name', 'setup.company', 'varchar', 60, 'Company name'), +('gst_no', 'setup.company', 'varchar', 25, ''), +('coy_no', 'setup.company', 'varchar', 25, ''), +('tax_prd', 'setup.company', 'int', 11, '1'), +('tax_last', 'setup.company', 'int', 11, '1'), +('postal_address', 'setup.company', 'tinytext', 0, 'N/A'), +('phone', 'setup.company', 'varchar', 30, ''), +('fax', 'setup.company', 'varchar', 30, ''), +('email', 'setup.company', 'varchar', 100, ''), +('coy_logo', 'setup.company', 'varchar', 100, ''), +('domicile', 'setup.company', 'varchar', 55, ''), +('curr_default', 'setup.company', 'char', 3, 'USD'), +('use_dimension', 'setup.company', 'tinyint', 1, '1'), +('f_year', 'setup.company', 'int', 11, '2'), +('shortname_name_in_list','setup.company', 'tinyint', 1, '0'), +('no_item_list', 'setup.company', 'tinyint', 1, '0'), +('no_customer_list', 'setup.company', 'tinyint', 1, '0'), +('no_supplier_list', 'setup.company', 'tinyint', 1, '0'), +('base_sales', 'setup.company', 'int', 11, '1'), +('time_zone', 'setup.company', 'tinyint', 1, '0'), +('add_pct', 'setup.company', 'int', 5, '-1'), +('round_to', 'setup.company', 'int', 5, '1'), +('login_tout', 'setup.company', 'smallint', 6, '600'), +('past_due_days', 'glsetup.general', 'int', 11, '30'), +('profit_loss_year_act', 'glsetup.general', 'varchar', 15, '9990'), +('retained_earnings_act', 'glsetup.general', 'varchar', 15, '3590'), +('bank_charge_act', 'glsetup.general', 'varchar', 15, '5690'), +('exchange_diff_act', 'glsetup.general', 'varchar', 15, '4450'), +('tax_algorithm', 'glsetup.customer', 'tinyint', 1, '1'), +('default_credit_limit', 'glsetup.customer', 'int', 11, '1000'), +('accumulate_shipping', 'glsetup.customer', 'tinyint', 1, '0'), +('legal_text', 'glsetup.customer', 'tinytext', 0, ''), +('freight_act', 'glsetup.customer', 'varchar', 15, '4430'), +('debtors_act', 'glsetup.sales', 'varchar', 15, '1200'), +('default_sales_act', 'glsetup.sales', 'varchar', 15, '4010'), +('default_sales_discount_act', 'glsetup.sales', 'varchar', 15, '4510'), +('default_prompt_payment_act', 'glsetup.sales', 'varchar', 15, '4500'), +('default_delivery_required', 'glsetup.sales', 'smallint', 6, '1'), +('default_receival_required', 'glsetup.purchase', 'smallint', 6, '10'), +('default_quote_valid_days', 'glsetup.sales', 'smallint', 6, '30'), +('default_dim_required', 'glsetup.dims', 'int', 11, '20'), +('pyt_discount_act', 'glsetup.purchase', 'varchar', 15, '5060'), +('creditors_act', 'glsetup.purchase', 'varchar', 15, '2100'), +('po_over_receive', 'glsetup.purchase', 'int', 11, '10'), +('po_over_charge', 'glsetup.purchase', 'int', 11, '10'), +('allow_negative_stock', 'glsetup.inventory', 'tinyint', 1, '0'), +('default_inventory_act', 'glsetup.items', 'varchar', 15, '1510'), +('default_cogs_act', 'glsetup.items', 'varchar', 15, '5010'), +('default_adj_act', 'glsetup.items', 'varchar', 15, '5040'), +('default_inv_sales_act', 'glsetup.items', 'varchar', 15, '4010'), +('default_wip_act', 'glsetup.items', 'varchar', 15, '1530'), +('default_workorder_required', 'glsetup.manuf', 'int', 11, '20'), +('version_id', 'system', 'varchar', 11, '2.4.1'), +('auto_curr_reval', 'setup.company', 'smallint', 6, '1'), +('grn_clearing_act', 'glsetup.purchase', 'varchar', 15, '1550'), +('bcc_email', 'setup.company', 'varchar', 100, ''), ('deferred_income_act', 'glsetup.sales', 'varchar', '15', '2105'), +('gl_closing_date','setup.closing_date', 'date', 8, ''), +('alternative_tax_include_on_docs','setup.company', 'tinyint', 1, '0'), +('no_zero_lines_amount','glsetup.sales', 'tinyint', 1, '1'), +('show_po_item_codes','glsetup.purchase', 'tinyint', 1, '0'), +('accounts_alpha','glsetup.general', 'tinyint', 1, '0'), +('loc_notification','glsetup.inventory', 'tinyint', 1, '0'), +('print_invoice_no','glsetup.sales', 'tinyint', 1, '0'), +('allow_negative_prices','glsetup.inventory', 'tinyint', 1, '1'), +('print_item_images_on_quote','glsetup.inventory', 'tinyint', 1, '0'), +('suppress_tax_rates','setup.company', 'tinyint', 1, '0'), +('company_logo_report','setup.company', 'tinyint', 1, '0'), +('barcodes_on_stock','setup.company', 'tinyint', 1, '0'), +('print_dialog_direct','setup.company', 'tinyint', 1, '0'), +('ref_no_auto_increase','setup.company', 'tinyint', 1, '0'), +('default_loss_on_asset_disposal_act', 'glsetup.items', 'varchar', '15', '5660'), ('depreciation_period', 'glsetup.company', 'tinyint', '1', '1'), -('domicile', 'setup.company', 'varchar', '55', ''), -('email', 'setup.company', 'varchar', '100', 'delta@delta.com'), -('exchange_diff_act', 'glsetup.general', 'varchar', '15', '4450'), -('f_year', 'setup.company', 'int', '11', '2'), -('fax', 'setup.company', 'varchar', '30', ''), -('freight_act', 'glsetup.customer', 'varchar', '15', '4430'), -('gl_closing_date', 'setup.closing_date', 'date', '8', '2018-12-31'), -('grn_clearing_act', 'glsetup.purchase', 'varchar', '15', '1550'), -('legal_text', 'glsetup.customer', 'tinytext', '0', ''), -('loc_notification', 'glsetup.inventory', 'tinyint', '1', '0'), -('login_tout', 'setup.company', 'smallint', '6', '600'), -('no_customer_list', 'setup.company', 'tinyint', '1', '0'), -('no_item_list', 'setup.company', 'tinyint', '1', '0'), -('no_supplier_list', 'setup.company', 'tinyint', '1', '0'), -('no_zero_lines_amount', 'glsetup.sales', 'tinyint', '1', '1'), -('past_due_days', 'glsetup.general', 'int', '11', '30'), -('phone', 'setup.company', 'varchar', '30', ''), -('po_over_charge', 'glsetup.purchase', 'int', '11', '10'), -('po_over_receive', 'glsetup.purchase', 'int', '11', '10'), -('postal_address', 'setup.company', 'tinytext', '0', 'N/A'), -('print_dialog_direct', 'setup.company', 'tinyint', '1', '0'), -('print_invoice_no', 'glsetup.sales', 'tinyint', '1', '0'), -('print_item_images_on_quote', 'glsetup.inventory', 'tinyint', '1', '0'), -('profit_loss_year_act', 'glsetup.general', 'varchar', '15', '9990'), -('pyt_discount_act', 'glsetup.purchase', 'varchar', '15', '5060'), -('ref_no_auto_increase', 'setup.company', 'tinyint', '1', '0'), -('retained_earnings_act', 'glsetup.general', 'varchar', '15', '3590'), -('round_to', 'setup.company', 'int', '5', '1'), -('shortname_name_in_list', 'setup.company', 'tinyint', '1', ''), -('show_po_item_codes', 'glsetup.purchase', 'tinyint', '1', '0'), -('suppress_tax_rates', 'setup.company', 'tinyint', '1', ''), -('tax_algorithm', 'glsetup.customer', 'tinyint', '1', '1'), -('tax_last', 'setup.company', 'int', '11', '1'), -('tax_prd', 'setup.company', 'int', '11', '1'), -('time_zone', 'setup.company', 'tinyint', '1', '0'), -('use_dimension', 'setup.company', 'tinyint', '1', '1'), -('use_fixed_assets', 'setup.company', 'tinyint', '1', '1'), -('use_manufacturing', 'setup.company', 'tinyint', '1', '1'), -('version_id', 'system', 'varchar', '11', '2.4.1'); - --- Structure of table `0_sys_types` -- - -DROP TABLE IF EXISTS `0_sys_types`; - -CREATE TABLE `0_sys_types` ( - `type_id` smallint(6) NOT NULL DEFAULT '0', - `type_no` int(11) NOT NULL DEFAULT '1', - `next_reference` varchar(100) NOT NULL DEFAULT '', - PRIMARY KEY (`type_id`) -) ENGINE=InnoDB ; - --- Data of table `0_sys_types` -- - -INSERT INTO `0_sys_types` VALUES -('0', '19', '3'), -('1', '8', '2'), -('2', '5', '2'), -('4', '3', '1'), -('10', '19', '4'), -('11', '3', '2'), -('12', '6', '1'), -('13', '5', '2'), -('16', '2', '1'), -('17', '2', '1'), -('18', '1', '3'), -('20', '8', '3'), -('21', '1', '1'), -('22', '4', '2'), -('25', '1', '2'), -('26', '1', '8'), -('28', '1', '1'), -('29', '1', '2'), -('30', '5', '6'), -('32', '0', '1'), -('35', '1', '1'), -('40', '1', '3'); +('use_manufacturing','setup.company', 'tinyint', 1, '1'), +('dim_on_recurrent_invoice','setup.company', 'tinyint', 1, '0'), +('long_description_invoice','setup.company', 'tinyint', 1, '0'), +('max_days_in_docs','setup.company', 'smallint', 5, '180'), +('use_fixed_assets','setup.company', 'tinyint', 1, '1'); -- Structure of table `0_tag_associations` -- @@ -1988,12 +1949,11 @@ DROP TABLE IF EXISTS `0_tag_associations`; CREATE TABLE `0_tag_associations` ( `record_id` varchar(15) NOT NULL, `tag_id` int(11) NOT NULL, - UNIQUE KEY `record_id` (`record_id`,`tag_id`) + PRIMARY KEY (`record_id`,`tag_id`) ) ENGINE=InnoDB ; -- Data of table `0_tag_associations` -- - -- Structure of table `0_tags` -- DROP TABLE IF EXISTS `0_tags`; @@ -2010,7 +1970,6 @@ CREATE TABLE `0_tags` ( -- Data of table `0_tags` -- - -- Structure of table `0_tax_group_items` -- DROP TABLE IF EXISTS `0_tax_group_items`; @@ -2079,7 +2038,7 @@ CREATE TABLE `0_trans_tax_details` ( `included_in_price` tinyint(1) NOT NULL DEFAULT '0', `net_amount` double NOT NULL DEFAULT '0', `amount` double NOT NULL DEFAULT '0', - `memo` tinytext COLLATE utf8_unicode_ci, + `memo` tinytext, `reg_type` tinyint(1) DEFAULT NULL, PRIMARY KEY (`id`), KEY `Type_and_Number` (`trans_type`,`trans_no`), @@ -2089,16 +2048,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` -- @@ -2164,7 +2123,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` -- @@ -2197,7 +2156,6 @@ CREATE TABLE `0_wo_costing` ( -- Data of table `0_wo_costing` -- - -- Structure of table `0_wo_issue_items` -- DROP TABLE IF EXISTS `0_wo_issue_items`; @@ -2231,7 +2189,6 @@ CREATE TABLE `0_wo_issues` ( -- Data of table `0_wo_issues` -- - -- Structure of table `0_wo_manufacture` -- DROP TABLE IF EXISTS `0_wo_manufacture`; @@ -2249,7 +2206,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` -- @@ -2323,6 +2280,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