X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Fen_US-demo.sql;h=d2066ec7a9270ee4e3c6b10d55236db69dbe3ff2;hb=0fcc421f3bc76dbaf2331a11804d804b08f37545;hp=ceaab19592c45ac46a2dbdbf00739b7a90d389e6;hpb=161bba0a7475c63af6951cb1fc465747926f51bf;p=fa-stable.git diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql index ceaab195..d2066ec7 100644 --- a/sql/en_US-demo.sql +++ b/sql/en_US-demo.sql @@ -5,7 +5,7 @@ -- Company: Training Co -- User: Administrator --- Compatibility: 2.4.Beta +-- Compatibility: 2.4.1 -- -- Database: `fatraining` @@ -86,34 +86,34 @@ CREATE TABLE IF NOT EXISTS `0_audit_trail` ( -- INSERT INTO `0_audit_trail` VALUES -('1', '18', '1', '1', '2015-05-05 14:08:02', NULL, '1', '2015-05-05', '0'), -('2', '25', '1', '1', '2015-05-05 14:08:14', NULL, '1', '2015-05-05', '0'), -('3', '30', '1', '1', '2015-05-05 14:09:54', NULL, '1', '2015-05-10', '0'), -('4', '13', '1', '1', '2015-05-05 14:09:55', NULL, '1', '2015-05-10', '0'), -('5', '10', '1', '1', '2015-05-05 14:09:55', NULL, '1', '2015-05-10', '0'), -('6', '12', '1', '1', '2015-05-05 14:09:55', NULL, '1', '2015-05-10', '0'), -('7', '26', '1', '1', '2015-05-05 14:18:49', 'Quick production.', '1', '2015-05-05', '0'), -('8', '18', '2', '1', '2015-05-05 14:22:32', NULL, '1', '2015-05-05', '0'), -('9', '25', '2', '1', '2015-05-05 14:22:32', NULL, '1', '2015-05-05', '0'), -('10', '20', '1', '1', '2015-05-05 14:22:32', NULL, '1', '2015-05-05', '0'), -('11', '30', '2', '1', '2015-05-07 07:55:15', NULL, '1', '2015-05-07', '0'), -('12', '13', '2', '1', '2015-05-07 07:55:16', NULL, '1', '2015-05-07', '0'), -('13', '10', '2', '1', '2015-05-07 07:55:16', NULL, '1', '2015-05-07', '0'), -('14', '12', '2', '1', '2015-05-07 07:55:16', NULL, '1', '2015-05-07', '0'), -('15', '30', '3', '1', '2015-05-07 08:08:24', NULL, '1', '2015-05-07', '0'), -('16', '30', '4', '1', '2015-05-07 09:18:44', NULL, '1', '2015-05-07', '0'), -('17', '30', '5', '1', '2015-05-07 11:42:41', NULL, '1', '2015-05-07', '0'), -('18', '13', '3', '1', '2015-05-07 11:42:41', NULL, '1', '2015-05-07', '0'), -('19', '10', '3', '1', '2015-05-07 11:42:41', NULL, '1', '2015-05-07', '0'), -('20', '30', '6', '1', '2015-05-07 14:02:35', NULL, '1', '2015-05-07', '0'), -('21', '30', '7', '1', '2015-05-07 14:05:38', NULL, '1', '2015-05-07', '0'), -('22', '13', '4', '1', '2015-05-07 14:05:38', NULL, '1', '2015-05-07', '0'), -('23', '10', '4', '1', '2015-05-07 14:05:38', NULL, '1', '2015-05-07', '0'), -('24', '12', '3', '1', '2015-05-07 14:05:38', NULL, '1', '2015-05-07', '0'), -('25', '26', '2', '1', '2015-05-07 15:59:34', NULL, '1', '2015-05-07', NULL), -('26', '26', '3', '1', '2015-05-07 15:59:01', NULL, '1', '2015-05-07', '0'), -('27', '26', '2', '1', '2015-05-07 15:59:34', 'Released.', '1', '2015-05-07', '0'), -('28', '1', '1', '1', '2015-05-07 16:01:00', NULL, '1', '2015-05-07', '0'); +('1', '18', '1', '1', '2016-05-05 14:08:02', NULL, '1', '2016-05-05', '0'), +('2', '25', '1', '1', '2016-05-05 14:08:14', NULL, '1', '2016-05-05', '0'), +('3', '30', '1', '1', '2016-05-05 14:09:54', NULL, '1', '2016-05-10', '0'), +('4', '13', '1', '1', '2016-05-05 14:09:55', NULL, '1', '2016-05-10', '0'), +('5', '10', '1', '1', '2016-05-05 14:09:55', NULL, '1', '2016-05-10', '0'), +('6', '12', '1', '1', '2016-05-05 14:09:55', NULL, '1', '2016-05-10', '0'), +('7', '26', '1', '1', '2016-05-05 14:18:49', 'Quick production.', '1', '2016-05-05', '0'), +('8', '18', '2', '1', '2016-05-05 14:22:32', NULL, '1', '2016-05-05', '0'), +('9', '25', '2', '1', '2016-05-05 14:22:32', NULL, '1', '2016-05-05', '0'), +('10', '20', '1', '1', '2016-05-05 14:22:32', NULL, '1', '2016-05-05', '0'), +('11', '30', '2', '1', '2016-05-07 07:55:15', NULL, '1', '2016-05-07', '0'), +('12', '13', '2', '1', '2016-05-07 07:55:16', NULL, '1', '2016-05-07', '0'), +('13', '10', '2', '1', '2016-05-07 07:55:16', NULL, '1', '2016-05-07', '0'), +('14', '12', '2', '1', '2016-05-07 07:55:16', NULL, '1', '2016-05-07', '0'), +('15', '30', '3', '1', '2016-05-07 08:08:24', NULL, '1', '2016-05-07', '0'), +('16', '30', '4', '1', '2016-05-07 09:18:44', NULL, '1', '2016-05-07', '0'), +('17', '30', '5', '1', '2016-05-07 11:42:41', NULL, '1', '2016-05-07', '0'), +('18', '13', '3', '1', '2016-05-07 11:42:41', NULL, '1', '2016-05-07', '0'), +('19', '10', '3', '1', '2016-05-07 11:42:41', NULL, '1', '2016-05-07', '0'), +('20', '30', '6', '1', '2016-05-07 14:02:35', NULL, '1', '2016-05-07', '0'), +('21', '30', '7', '1', '2016-05-07 14:05:38', NULL, '1', '2016-05-07', '0'), +('22', '13', '4', '1', '2016-05-07 14:05:38', NULL, '1', '2016-05-07', '0'), +('23', '10', '4', '1', '2016-05-07 14:05:38', NULL, '1', '2016-05-07', '0'), +('24', '12', '3', '1', '2016-05-07 14:05:38', NULL, '1', '2016-05-07', '0'), +('25', '26', '2', '1', '2016-05-07 15:59:34', NULL, '1', '2016-05-07', NULL), +('26', '26', '3', '1', '2016-05-07 15:59:01', NULL, '1', '2016-05-07', '0'), +('27', '26', '2', '1', '2016-05-07 15:59:34', 'Released.', '1', '2016-05-07', '0'), +('28', '1', '1', '1', '2016-05-07 16:01:00', NULL, '1', '2016-05-07', '0'); -- -------------------------------------------------------- @@ -181,10 +181,10 @@ CREATE TABLE IF NOT EXISTS `0_bank_trans` ( -- INSERT INTO `0_bank_trans` VALUES -('1', '12', '1', '2', '001/2015', '2015-05-10', '6240', '0', '0', '2', '1', NULL), -('2', '12', '2', '2', '002/2015', '2015-05-07', '300', '0', '0', '2', '1', NULL), -('3', '12', '3', '2', '003/2015', '2015-05-07', '0', '0', '0', '2', '1', NULL), -('4', '1', '1', '1', '001/2015', '2015-05-07', '-5', '0', '0', '0', 'Goods received', NULL); +('1', '12', '1', '2', '001/2016', '2016-05-10', '6240', '0', '0', '2', '1', NULL), +('2', '12', '2', '2', '002/2016', '2016-05-07', '300', '0', '0', '2', '1', NULL), +('3', '12', '3', '2', '003/2016', '2016-05-07', '0', '0', '0', '2', '1', NULL), +('4', '1', '1', '1', '001/2016', '2016-05-07', '-5', '0', '0', '0', 'Goods received', NULL); -- -------------------------------------------------------- @@ -421,11 +421,11 @@ CREATE TABLE IF NOT EXISTS `0_comments` ( -- INSERT INTO `0_comments` VALUES -('12', '1', '2015-05-10', 'Cash invoice 1'), -('12', '2', '2015-05-07', 'Cash invoice 2'), -('13', '4', '2015-05-07', 'Recurrent Invoice covers period 04/01/2015 - 04/07/2015.'), -('10', '4', '2015-05-07', 'Recurrent Invoice covers period 04/01/2015 - 04/07/2015.'), -('12', '3', '2015-05-07', 'Cash invoice 4'); +('12', '1', '2016-05-10', 'Cash invoice 1'), +('12', '2', '2016-05-07', 'Cash invoice 2'), +('13', '4', '2016-05-07', 'Recurrent Invoice covers period 04/01/2016 - 04/07/2016.'), +('10', '4', '2016-05-07', 'Recurrent Invoice covers period 04/01/2016 - 04/07/2016.'), +('12', '3', '2016-05-07', 'Cash invoice 4'); -- -------------------------------------------------------- @@ -605,9 +605,9 @@ CREATE TABLE IF NOT EXISTS `0_cust_allocations` ( -- INSERT INTO `0_cust_allocations` VALUES -('1', '1', '6240', '2015-05-10', '1', '12', '1', '10'), -('2', '1', '300', '2015-05-07', '2', '12', '2', '10'), -('3', '1', '0', '2015-05-07', '3', '12', '4', '10'); +('1', '1', '6240', '2016-05-10', '1', '12', '1', '10'), +('2', '1', '300', '2016-05-07', '2', '12', '2', '10'), +('3', '1', '0', '2016-05-07', '3', '12', '4', '10'); -- -------------------------------------------------------- @@ -718,7 +718,7 @@ CREATE TABLE IF NOT EXISTS `0_debtor_trans` ( `dimension2_id` int(11) NOT NULL DEFAULT '0', `payment_terms` int(11) DEFAULT NULL, `tax_included` tinyint(1) unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`type`,`trans_no`), + PRIMARY KEY (`type`,`trans_no`,`debtor_no`), KEY `debtor_no` (`debtor_no`,`branch_code`), KEY `tran_date` (`tran_date`), KEY `order_` (`order_`) @@ -730,17 +730,17 @@ CREATE TABLE IF NOT EXISTS `0_debtor_trans` ( INSERT INTO `0_debtor_trans` VALUES -('1', '10', '0', '1', '1', '2015-05-10', '2015-05-05', '001/2015', '1', '1', '6240', '0', '0', '0', '0', '6240', '0', '1', '1', '0', '0', '4', '1'), -('2', '10', '0', '1', '1', '2015-05-07', '2015-05-07', '002/2015', '1', '2', '300', '0', '0', '0', '0', '300', '0', '1', '1', '0', '0', '4', '1'), -('3', '10', '0', '2', '2', '2015-05-07', '2015-06-17', '003/2015', '1', '5', '267.14', '0', '0', '0', '0', '0', '0', '1.123', '1', '1', '0', '1', '1'), -('4', '10', '0', '1', '1', '2015-05-07', '2015-05-07', '004/2015', '1', '7', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'), -('1', '12', '0', '1', '1', '2015-05-10', '0000-00-00', '001/2015', '0', '0', '6240', '0', '0', '0', '0', '6240', '0', '1', '0', '0', '0', NULL, '0'), -('2', '12', '0', '1', '1', '2015-05-07', '0000-00-00', '002/2015', '0', '0', '300', '0', '0', '0', '0', '300', '0', '1', '0', '0', '0', NULL, '0'), -('3', '12', '0', '1', '1', '2015-05-07', '0000-00-00', '003/2015', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', NULL, '0'), -('1', '13', '1', '1', '1', '2015-05-10', '2015-05-05', 'auto', '1', '1', '6240', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'), -('2', '13', '1', '1', '1', '2015-05-07', '2015-05-07', 'auto', '1', '2', '300', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'), -('3', '13', '1', '2', '2', '2015-05-07', '2015-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', '2015-05-07', '2015-05-07', 'auto', '1', '7', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'); +('1', '10', '0', '1', '1', '2016-05-10', '2016-05-05', '001/2016', '1', '1', '6240', '0', '0', '0', '0', '6240', '0', '1', '1', '0', '0', '4', '1'), +('2', '10', '0', '1', '1', '2016-05-07', '2016-05-07', '002/2016', '1', '2', '300', '0', '0', '0', '0', '300', '0', '1', '1', '0', '0', '4', '1'), +('3', '10', '0', '2', '2', '2016-05-07', '2016-06-17', '003/2016', '1', '5', '267.14', '0', '0', '0', '0', '0', '0', '1.123', '1', '1', '0', '1', '1'), +('4', '10', '0', '1', '1', '2016-05-07', '2016-05-07', '004/2016', '1', '7', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'), +('1', '12', '0', '1', '1', '2016-05-10', '0000-00-00', '001/2016', '0', '0', '6240', '0', '0', '0', '0', '6240', '0', '1', '0', '0', '0', NULL, '0'), +('2', '12', '0', '1', '1', '2016-05-07', '0000-00-00', '002/2016', '0', '0', '300', '0', '0', '0', '0', '300', '0', '1', '0', '0', '0', NULL, '0'), +('3', '12', '0', '1', '1', '2016-05-07', '0000-00-00', '003/2016', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', NULL, '0'), +('1', '13', '1', '1', '1', '2016-05-10', '2016-05-05', 'auto', '1', '1', '6240', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'), +('2', '13', '1', '1', '1', '2016-05-07', '2016-05-07', 'auto', '1', '2', '300', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'), +('3', '13', '1', '2', '2', '2016-05-07', '2016-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', '2016-05-07', '2016-05-07', 'auto', '1', '7', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'); -- -------------------------------------------------------- @@ -811,7 +811,7 @@ CREATE TABLE IF NOT EXISTS `0_dimensions` ( -- Dumping data for table `0_dimensions` -- -INSERT INTO `0_dimensions` VALUES ('1', '001/2015', 'Cost Centre', '1', '0', '2015-05-05', '2015-05-25'); +INSERT INTO `0_dimensions` VALUES ('1', '001/2016', 'Cost Centre', '1', '0', '2016-05-05', '2016-05-25'); -- -------------------------------------------------------- @@ -834,7 +834,7 @@ CREATE TABLE IF NOT EXISTS `0_exchange_rates` ( -- Dumping data for table `0_exchange_rates` -- -INSERT INTO `0_exchange_rates` VALUES ('1', 'EUR', '1.123', '1.123', '2015-05-07'); +INSERT INTO `0_exchange_rates` VALUES ('1', 'EUR', '1.123', '1.123', '2016-05-07'); -- -------------------------------------------------------- @@ -851,14 +851,13 @@ CREATE TABLE IF NOT EXISTS `0_fiscal_year` ( PRIMARY KEY (`id`), UNIQUE KEY `begin` (`begin`), UNIQUE KEY `end` (`end`) -) ENGINE=InnoDB AUTO_INCREMENT=3 ; +) ENGINE=InnoDB AUTO_INCREMENT=2 ; -- -- Dumping data for table `0_fiscal_year` -- -INSERT INTO `0_fiscal_year` VALUES (1, '2015-01-01', '2015-12-31', 0); -INSERT INTO `0_fiscal_year` VALUES (2, '2016-01-01', '2016-12-31', 0); +INSERT INTO `0_fiscal_year` VALUES (1, '2016-01-01', '2016-12-31', 0); -- -------------------------------------------------------- @@ -892,44 +891,44 @@ CREATE TABLE IF NOT EXISTS `0_gl_trans` ( -- INSERT INTO `0_gl_trans` VALUES -('1', '25', '1', '2015-05-05', '1510', '101', '20000', '0', '0', NULL, NULL), -('2', '25', '1', '2015-05-05', '1510', '102', '15000', '0', '0', NULL, NULL), -('3', '25', '1', '2015-05-05', '1510', '103', '1000', '0', '0', NULL, NULL), -('4', '25', '1', '2015-05-05', '1550', '', '-36000', '0', '0', NULL, NULL), -('5', '13', '1', '2015-05-10', '5010', '', '4000', '0', '0', NULL, NULL), -('6', '13', '1', '2015-05-10', '1510', '', '-4000', '0', '0', NULL, NULL), -('7', '10', '1', '2015-05-10', '4010', '', '-5714.29', '0', '0', NULL, NULL), -('8', '10', '1', '2015-05-10', '4010', '', '-228.57', '0', '0', NULL, NULL), -('9', '10', '1', '2015-05-10', '1200', '', '6240', '0', '0', '2', '1'), -('10', '10', '1', '2015-05-10', '2150', '', '-297.14', '0', '0', NULL, NULL), -('11', '12', '1', '2015-05-10', '1065', '', '6240', '0', '0', NULL, NULL), -('12', '12', '1', '2015-05-10', '1200', '', '-6240', '0', '0', '2', '1'), -('13', '26', '1', '2015-05-05', '1510', '1 * iPad Air 2 16GB', '-400', '0', '0', NULL, NULL), -('14', '26', '1', '2015-05-05', '1510', '1 * iPhone 6 64GB', '-300', '0', '0', NULL, NULL), -('15', '26', '1', '2015-05-05', '1510', '1 * iPhone Cover Case', '-20', '0', '0', NULL, NULL), -('16', '26', '1', '2015-05-05', '1510', 'Produced 2 * AP Surf Set', '720', '0', '0', NULL, NULL), -('17', '25', '2', '2015-05-05', '1510', '101', '3000', '0', '0', NULL, NULL), -('18', '25', '2', '2015-05-05', '1550', '', '-3000', '0', '0', NULL, NULL), -('19', '20', '1', '2015-05-05', '2150', '', '150', '0', '0', NULL, NULL), -('20', '20', '1', '2015-05-05', '2100', '', '-3150', '0', '0', '3', '1'), -('21', '20', '1', '2015-05-05', '1550', '', '3000', '0', '0', NULL, NULL), -('22', '13', '2', '2015-05-07', '5010', '', '200', '0', '0', NULL, NULL), -('23', '13', '2', '2015-05-07', '1510', '', '-200', '0', '0', NULL, NULL), -('24', '10', '2', '2015-05-07', '4010', '', '-285.71', '0', '0', NULL, NULL), -('25', '10', '2', '2015-05-07', '1200', '', '300', '0', '0', '2', '1'), -('26', '10', '2', '2015-05-07', '2150', '', '-14.29', '0', '0', NULL, NULL), -('27', '12', '2', '2015-05-07', '1065', '', '300', '0', '0', NULL, NULL), -('28', '12', '2', '2015-05-07', '1200', '', '-300', '0', '0', '2', '1'), -('29', '13', '3', '2015-05-07', '5010', '', '150', '1', '0', NULL, NULL), -('30', '13', '3', '2015-05-07', '1510', '', '-150', '0', '0', NULL, NULL), -('31', '13', '3', '2015-05-07', '5010', '', '10', '1', '0', NULL, NULL), -('32', '13', '3', '2015-05-07', '1510', '', '-10', '0', '0', NULL, NULL), -('33', '10', '3', '2015-05-07', '4010', '', '-250', '1', '0', NULL, NULL), -('34', '10', '3', '2015-05-07', '4010', '', '-50', '1', '0', NULL, NULL), -('35', '10', '3', '2015-05-07', '1200', '', '300', '0', '0', '2', '2'), -('36', '12', '3', '2015-05-07', '1065', '', '0', '0', '0', NULL, NULL), -('37', '1', '1', '2015-05-07', '5010', '', '5', '1', '0', NULL, NULL), -('38', '1', '1', '2015-05-07', '1060', '', '-5', '0', '0', NULL, NULL); +('1', '25', '1', '2016-05-05', '1510', '101', '20000', '0', '0', NULL, NULL), +('2', '25', '1', '2016-05-05', '1510', '102', '15000', '0', '0', NULL, NULL), +('3', '25', '1', '2016-05-05', '1510', '103', '1000', '0', '0', NULL, NULL), +('4', '25', '1', '2016-05-05', '1550', '', '-36000', '0', '0', NULL, NULL), +('5', '13', '1', '2016-05-10', '5010', '', '4000', '0', '0', NULL, NULL), +('6', '13', '1', '2016-05-10', '1510', '', '-4000', '0', '0', NULL, NULL), +('7', '10', '1', '2016-05-10', '4010', '', '-5714.29', '0', '0', NULL, NULL), +('8', '10', '1', '2016-05-10', '4010', '', '-228.57', '0', '0', NULL, NULL), +('9', '10', '1', '2016-05-10', '1200', '', '6240', '0', '0', '2', '1'), +('10', '10', '1', '2016-05-10', '2150', '', '-297.14', '0', '0', NULL, NULL), +('11', '12', '1', '2016-05-10', '1065', '', '6240', '0', '0', NULL, NULL), +('12', '12', '1', '2016-05-10', '1200', '', '-6240', '0', '0', '2', '1'), +('13', '26', '1', '2016-05-05', '1510', '1 * iPad Air 2 16GB', '-400', '0', '0', NULL, NULL), +('14', '26', '1', '2016-05-05', '1510', '1 * iPhone 6 64GB', '-300', '0', '0', NULL, NULL), +('15', '26', '1', '2016-05-05', '1510', '1 * iPhone Cover Case', '-20', '0', '0', NULL, NULL), +('16', '26', '1', '2016-05-05', '1510', 'Produced 2 * AP Surf Set', '720', '0', '0', NULL, NULL), +('17', '25', '2', '2016-05-05', '1510', '101', '3000', '0', '0', NULL, NULL), +('18', '25', '2', '2016-05-05', '1550', '', '-3000', '0', '0', NULL, NULL), +('19', '20', '1', '2016-05-05', '2150', '', '150', '0', '0', NULL, NULL), +('20', '20', '1', '2016-05-05', '2100', '', '-3150', '0', '0', '3', '1'), +('21', '20', '1', '2016-05-05', '1550', '', '3000', '0', '0', NULL, NULL), +('22', '13', '2', '2016-05-07', '5010', '', '200', '0', '0', NULL, NULL), +('23', '13', '2', '2016-05-07', '1510', '', '-200', '0', '0', NULL, NULL), +('24', '10', '2', '2016-05-07', '4010', '', '-285.71', '0', '0', NULL, NULL), +('25', '10', '2', '2016-05-07', '1200', '', '300', '0', '0', '2', '1'), +('26', '10', '2', '2016-05-07', '2150', '', '-14.29', '0', '0', NULL, NULL), +('27', '12', '2', '2016-05-07', '1065', '', '300', '0', '0', NULL, NULL), +('28', '12', '2', '2016-05-07', '1200', '', '-300', '0', '0', '2', '1'), +('29', '13', '3', '2016-05-07', '5010', '', '150', '1', '0', NULL, NULL), +('30', '13', '3', '2016-05-07', '1510', '', '-150', '0', '0', NULL, NULL), +('31', '13', '3', '2016-05-07', '5010', '', '10', '1', '0', NULL, NULL), +('32', '13', '3', '2016-05-07', '1510', '', '-10', '0', '0', NULL, NULL), +('33', '10', '3', '2016-05-07', '4010', '', '-250', '1', '0', NULL, NULL), +('34', '10', '3', '2016-05-07', '4010', '', '-50', '1', '0', NULL, NULL), +('35', '10', '3', '2016-05-07', '1200', '', '300', '0', '0', '2', '2'), +('36', '12', '3', '2016-05-07', '1065', '', '0', '0', '0', NULL, NULL), +('37', '1', '1', '2016-05-07', '5010', '', '5', '1', '0', NULL, NULL), +('38', '1', '1', '2016-05-07', '1060', '', '-5', '0', '0', NULL, NULL); -- -------------------------------------------------------- @@ -956,8 +955,8 @@ CREATE TABLE IF NOT EXISTS `0_grn_batch` ( -- INSERT INTO `0_grn_batch` VALUES -('1', '1', '1', '001/2015', '2015-05-05', 'DEF', '1'), -('2', '1', '2', 'auto', '2015-05-05', 'DEF', '1'); +('1', '1', '1', '001/2016', '2016-05-05', 'DEF', '1'), +('2', '1', '2', 'auto', '2016-05-05', 'DEF', '1'); -- -------------------------------------------------------- @@ -1352,8 +1351,8 @@ CREATE TABLE IF NOT EXISTS `0_purch_orders` ( -- INSERT INTO `0_purch_orders` VALUES -('1', '1', NULL, '2015-05-05', '001/2015', NULL, 'DEF', 'N/A', '37800', '0', '0', '0'), -('2', '1', NULL, '2015-05-05', 'auto', 'rr4', 'DEF', 'N/A', '3150', '0', '0', '0'); +('1', '1', NULL, '2016-05-05', '001/2016', NULL, 'DEF', 'N/A', '37800', '0', '0', '0'), +('2', '1', NULL, '2016-05-05', 'auto', 'rr4', 'DEF', 'N/A', '3150', '0', '0', '0'); -- -------------------------------------------------------- @@ -1384,10 +1383,10 @@ CREATE TABLE IF NOT EXISTS `0_purch_order_details` ( -- INSERT INTO `0_purch_order_details` VALUES -('1', '1', '101', 'iPad Air 2 16GB', '2015-05-15', '0', '200', '200', '200', '100', '100'), -('2', '1', '102', 'iPhone 6 64GB', '2015-05-15', '0', '150', '150', '150', '100', '100'), -('3', '1', '103', 'iPhone Cover Case', '2015-05-15', '0', '10', '10', '10', '100', '100'), -('4', '2', '101', 'iPad Air 2 16GB', '2015-05-05', '15', '200', '200', '200', '15', '15'); +('1', '1', '101', 'iPad Air 2 16GB', '2016-05-15', '0', '200', '200', '200', '100', '100'), +('2', '1', '102', 'iPhone 6 64GB', '2016-05-15', '0', '150', '150', '150', '100', '100'), +('3', '1', '103', 'iPhone Cover Case', '2016-05-15', '0', '10', '10', '10', '100', '100'), +('4', '2', '101', 'iPad Air 2 16GB', '2016-05-05', '15', '200', '200', '200', '15', '15'); -- -------------------------------------------------------- @@ -1473,7 +1472,7 @@ CREATE TABLE IF NOT EXISTS `0_recurrent_invoices` ( -- Dumping data for table `0_recurrent_invoices` -- -INSERT INTO `0_recurrent_invoices` VALUES ('1', 'Weekly Maintenance', '6', '1', '1', '7', '0', '2015-04-01', '2020-05-07', '2015-04-08'); +INSERT INTO `0_recurrent_invoices` VALUES ('1', 'Weekly Maintenance', '6', '1', '1', '7', '0', '2016-04-01', '2020-05-07', '2016-04-08'); -- -------------------------------------------------------- @@ -1543,24 +1542,24 @@ CREATE TABLE IF NOT EXISTS `0_refs` ( -- INSERT INTO `0_refs` VALUES -('1', '1', '001/2015'), -('1', '10', '001/2015'), -('2', '10', '002/2015'), -('3', '10', '003/2015'), -('4', '10', '004/2015'), -('1', '12', '001/2015'), -('2', '12', '002/2015'), -('3', '12', '003/2015'), -('1', '18', '001/2015'), -('1', '20', '001/2015'), -('1', '25', '001/2015'), -('1', '26', '001/2015'), -('2', '26', '002/2015'), -('3', '26', '003/2015'), -('3', '30', '001/2015'), -('4', '30', '002/2015'), -('6', '30', '003/2015'), -('1', '40', '001/2015'); +('1', '1', '001/2016'), +('1', '10', '001/2016'), +('2', '10', '002/2016'), +('3', '10', '003/2016'), +('4', '10', '004/2016'), +('1', '12', '001/2016'), +('2', '12', '002/2016'), +('3', '12', '003/2016'), +('1', '18', '001/2016'), +('1', '20', '001/2016'), +('1', '25', '001/2016'), +('1', '26', '001/2016'), +('2', '26', '002/2016'), +('3', '26', '003/2016'), +('3', '30', '001/2016'), +('4', '30', '002/2016'), +('6', '30', '003/2016'), +('1', '40', '001/2016'); -- -------------------------------------------------------- @@ -1628,13 +1627,13 @@ CREATE TABLE IF NOT EXISTS `0_sales_orders` ( -- INSERT INTO `0_sales_orders` VALUES -('1', '30', '1', '0', '1', '1', 'auto', '', NULL, '2015-05-10', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2015-05-05', '4', '6240', '0', '0'), -('2', '30', '1', '0', '1', '1', 'auto', '', NULL, '2015-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2015-05-07', '4', '300', '0', '0'), -('3', '30', '0', '0', '1', '1', '001/2015', '', NULL, '2015-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2015-05-08', '4', '300', '0', '0'), -('4', '30', '0', '0', '2', '2', '002/2015', '', NULL, '2015-05-07', '1', '1', 'N/A', NULL, NULL, 'MoneyMaker Ltd.', '0', 'DEF', '2015-05-08', '1', '267.14', '0', '0'), -('5', '30', '1', '0', '2', '2', 'auto', '', NULL, '2015-05-07', '1', '1', 'N/A', NULL, NULL, 'MoneyMaker Ltd.', '0', 'DEF', '2015-06-17', '1', '267.14', '0', '0'), -('6', '30', '0', '1', '1', '1', '003/2015', '', NULL, '2015-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2015-05-08', '4', '450', '0', '0'), -('7', '30', '1', '0', '1', '1', 'auto', '', 'Recurrent Invoice covers period 04/01/2015 - 04/07/2015.', '2015-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2015-05-07', '4', '0', '0', '0'); +('1', '30', '1', '0', '1', '1', 'auto', '', NULL, '2016-05-10', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2016-05-05', '4', '6240', '0', '0'), +('2', '30', '1', '0', '1', '1', 'auto', '', NULL, '2016-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2016-05-07', '4', '300', '0', '0'), +('3', '30', '0', '0', '1', '1', '001/2016', '', NULL, '2016-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2016-05-08', '4', '300', '0', '0'), +('4', '30', '0', '0', '2', '2', '002/2016', '', NULL, '2016-05-07', '1', '1', 'N/A', NULL, NULL, 'MoneyMaker Ltd.', '0', 'DEF', '2016-05-08', '1', '267.14', '0', '0'), +('5', '30', '1', '0', '2', '2', 'auto', '', NULL, '2016-05-07', '1', '1', 'N/A', NULL, NULL, 'MoneyMaker Ltd.', '0', 'DEF', '2016-06-17', '1', '267.14', '0', '0'), +('6', '30', '0', '1', '1', '1', '003/2016', '', NULL, '2016-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2016-05-08', '4', '450', '0', '0'), +('7', '30', '1', '0', '1', '1', 'auto', '', 'Recurrent Invoice covers period 04/01/2016 - 04/07/2016.', '2016-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2016-05-07', '4', '0', '0', '0'); -- -------------------------------------------------------- @@ -1933,21 +1932,21 @@ CREATE TABLE `0_stock_moves` ( -- INSERT INTO `0_stock_moves` VALUES -('1', '1', '101', '25', 'DEF', '2015-05-05', '200', '', '100', '200'), -('2', '1', '102', '25', 'DEF', '2015-05-05', '150', '', '100', '150'), -('3', '1', '103', '25', 'DEF', '2015-05-05', '10', '', '100', '10'), -('4', '1', '101', '13', 'DEF', '2015-05-10', '300', 'auto', '-20', '200'), -('5', '1', '301', '13', 'DEF', '2015-05-10', '80', 'auto', '-3', '0'), -('6', '1', '101', '26', 'DEF', '2015-05-05', '200', '001/2015', '-2', '200'), -('7', '1', '102', '26', 'DEF', '2015-05-05', '150', '001/2015', '-2', '150'), -('8', '1', '103', '26', 'DEF', '2015-05-05', '10', '001/2015', '-2', '10'), -('9', '1', '301', '26', 'DEF', '2015-05-05', '0', '001/2015', '-2', '0'), -('10', '1', '201', '26', 'DEF', '2015-05-05', '0', '001/2015', '2', '0'), -('11', '2', '101', '25', 'DEF', '2015-05-05', '200', '', '15', '200'), -('12', '2', '101', '13', 'DEF', '2015-05-07', '300', 'auto', '-1', '200'), -('13', '3', '102', '13', 'DEF', '2015-05-07', '222.62', 'auto', '-1', '150'), -('14', '3', '103', '13', 'DEF', '2015-05-07', '44.52', 'auto', '-1', '10'), -('15', '4', '202', '13', 'DEF', '2015-05-07', '0', 'auto', '-5', '0'); +('1', '1', '101', '25', 'DEF', '2016-05-05', '200', '', '100', '200'), +('2', '1', '102', '25', 'DEF', '2016-05-05', '150', '', '100', '150'), +('3', '1', '103', '25', 'DEF', '2016-05-05', '10', '', '100', '10'), +('4', '1', '101', '13', 'DEF', '2016-05-10', '300', 'auto', '-20', '200'), +('5', '1', '301', '13', 'DEF', '2016-05-10', '80', 'auto', '-3', '0'), +('6', '1', '101', '26', 'DEF', '2016-05-05', '200', '001/2016', '-2', '200'), +('7', '1', '102', '26', 'DEF', '2016-05-05', '150', '001/2016', '-2', '150'), +('8', '1', '103', '26', 'DEF', '2016-05-05', '10', '001/2016', '-2', '10'), +('9', '1', '301', '26', 'DEF', '2016-05-05', '0', '001/2016', '-2', '0'), +('10', '1', '201', '26', 'DEF', '2016-05-05', '0', '001/2016', '2', '0'), +('11', '2', '101', '25', 'DEF', '2016-05-05', '200', '', '15', '200'), +('12', '2', '101', '13', 'DEF', '2016-05-07', '300', 'auto', '-1', '200'), +('13', '3', '102', '13', 'DEF', '2016-05-07', '222.62', 'auto', '-1', '150'), +('14', '3', '103', '13', 'DEF', '2016-05-07', '44.52', 'auto', '-1', '10'), +('15', '4', '202', '13', 'DEF', '2016-05-07', '0', 'auto', '-5', '0'); -- -------------------------------------------------------- @@ -2070,7 +2069,7 @@ CREATE TABLE IF NOT EXISTS `0_supp_trans` ( `rate` double NOT NULL DEFAULT '1', `alloc` double NOT NULL DEFAULT '0', `tax_included` tinyint(1) NOT NULL DEFAULT '0', - PRIMARY KEY (`type`,`trans_no`), + PRIMARY KEY (`type`,`trans_no`,`debtor_no`), KEY `supplier_id` (`supplier_id`), KEY `tran_date` (`tran_date`) ) ENGINE=InnoDB; @@ -2080,7 +2079,7 @@ CREATE TABLE IF NOT EXISTS `0_supp_trans` ( -- -INSERT INTO `0_supp_trans` VALUES ('1', '20', '1', '001/2015', 'rr4', '2015-05-05', '2015-05-15', '3000', '0', '150', '1', '0', '0'); +INSERT INTO `0_supp_trans` VALUES ('1', '20', '1', '001/2016', 'rr4', '2016-05-05', '2016-05-15', '3000', '0', '150', '1', '0', '0'); -- -------------------------------------------------------- @@ -2117,6 +2116,7 @@ INSERT INTO `0_sys_prefs` VALUES ('domicile', 'setup.company', 'varchar', 55, '' INSERT INTO `0_sys_prefs` VALUES ('curr_default', 'setup.company', 'char', 3, 'USD'); INSERT INTO `0_sys_prefs` VALUES ('use_dimension', 'setup.company', 'tinyint', 1, '1'); INSERT INTO `0_sys_prefs` VALUES ('f_year', 'setup.company', 'int', 11, '1'); +INSERT INTO `0_sys_prefs` VALUES ('shortname_name_in_list','setup.company', 'tinyint', 1, '0'); INSERT INTO `0_sys_prefs` VALUES ('no_item_list', 'setup.company', 'tinyint', 1, '0'); INSERT INTO `0_sys_prefs` VALUES ('no_customer_list', 'setup.company', 'tinyint', 1, '0'); INSERT INTO `0_sys_prefs` VALUES ('no_supplier_list', 'setup.company', 'tinyint', 1, '0'); @@ -2169,6 +2169,7 @@ INSERT INTO `0_sys_prefs` VALUES ('print_invoice_no','glsetup.sales', 'tinyint', INSERT INTO `0_sys_prefs` VALUES ('allow_negative_prices','glsetup.inventory', 'tinyint', 1, '1'); INSERT INTO `0_sys_prefs` VALUES ('print_item_images_on_quote','glsetup.inventory', 'tinyint', 1, '0'); INSERT INTO `0_sys_prefs` VALUES ('suppress_tax_rates','setup.company', 'tinyint', 1, '0'); +INSERT INTO `0_sys_prefs` VALUES ('company_logo_report','setup.company', 'tinyint', 1, '0'); INSERT INTO `0_sys_prefs` VALUES ('default_loss_on_asset_disposal_act', 'glsetup.items', 'varchar', '15', '5660'); INSERT INTO `0_sys_prefs` VALUES ('depreciation_period', 'glsetup.company', 'tinyint', '1', '1'); INSERT INTO `0_sys_prefs` VALUES ('use_manufacturing','setup.company', 'tinyint', 1, '1'); @@ -2308,13 +2309,13 @@ CREATE TABLE IF NOT EXISTS `0_trans_tax_details` ( -- INSERT INTO `0_trans_tax_details` VALUES -('1', '13', '1', '2015-05-10', '1', '5', '1', '1', '5942.86', '297.14', 'auto', NULL), -('2', '10', '1', '2015-05-10', '1', '5', '1', '1', '5942.86', '297.14', '001/2015', '0'), -('3', '20', '1', '2015-05-05', '1', '5', '1', '0', '3000', '150', 'rr4', '1'), -('4', '13', '2', '2015-05-07', '1', '5', '1', '1', '285.71', '14.29', 'auto', NULL), -('5', '10', '2', '2015-05-07', '1', '5', '1', '1', '285.71', '14.29', '002/2015', '0'), -('6', '13', '3', '2015-05-07', '0', '0', '1.123', '1', '267.14', '0', 'auto', NULL), -('7', '10', '3', '2015-05-07', '0', '0', '1.123', '1', '267.14', '0', '003/2015', '0'); +('1', '13', '1', '2016-05-10', '1', '5', '1', '1', '5942.86', '297.14', 'auto', NULL), +('2', '10', '1', '2016-05-10', '1', '5', '1', '1', '5942.86', '297.14', '001/2016', '0'), +('3', '20', '1', '2016-05-05', '1', '5', '1', '0', '3000', '150', 'rr4', '1'), +('4', '13', '2', '2016-05-07', '1', '5', '1', '1', '285.71', '14.29', 'auto', NULL), +('5', '10', '2', '2016-05-07', '1', '5', '1', '1', '285.71', '14.29', '002/2016', '0'), +('6', '13', '3', '2016-05-07', '0', '0', '1.123', '1', '267.14', '0', 'auto', NULL), +('7', '10', '3', '2016-05-07', '0', '0', '1.123', '1', '267.14', '0', '003/2016', '0'); -- -------------------------------------------------------- @@ -2388,7 +2389,7 @@ CREATE TABLE IF NOT EXISTS `0_users` ( -- Dumping data for 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, '2015-05-07 13:58:33', 10, 1, 1, '1', 1, 0, 'orders', 30, 0, 1, 0, 0, 0); +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, '2016-05-07 13:58:33', 10, 1, 1, '1', 1, 0, 'orders', 30, 0, 1, 0, 0, 0); -- -------------------------------------------------------- @@ -2461,9 +2462,9 @@ CREATE TABLE IF NOT EXISTS `0_workorders` ( -- INSERT INTO `0_workorders` VALUES -('1', '001/2015', 'DEF', '2', '201', '2015-05-05', '0', '2015-05-05', '2015-05-05', '2', '1', '1', '0'), -('2', '002/2015', 'DEF', '5', '201', '2015-05-07', '2', '2015-05-27', '2015-05-07', '0', '0', '1', '0'), -('3', '003/2015', 'DEF', '5', '201', '2015-05-07', '2', '2015-05-27', '0000-00-00', '0', '0', '0', '0'); +('1', '001/2016', 'DEF', '2', '201', '2016-05-05', '0', '2016-05-05', '2016-05-05', '2', '1', '1', '0'), +('2', '002/2016', 'DEF', '5', '201', '2016-05-07', '2', '2016-05-27', '2016-05-07', '0', '0', '1', '0'), +('3', '003/2016', 'DEF', '5', '201', '2016-05-07', '2', '2016-05-27', '0000-00-00', '0', '0', '0', '0'); -- --------------------------------------------------------