Fixed comment for crm_contacts table in init sql files.

[fa-stable.git] / sql / en_US-demo.sql

diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql
index bb7d0cbc03c91d8a93bb69a3bb5c1a590973fa21..ff2055f5419a8d5be60f10ac2924f477b8e86d52 100644 (file)
--- a/sql/en_US-demo.sql
+++ b/sql/en_US-demo.sql
@@ -92,7 +92,7 @@ INSERT INTO `0_audit_trail` VALUES
 ('4', '13', '1', '1', '2017-05-05 14:09:55', NULL, '1', '2017-05-10', '0'),
 ('5', '10', '1', '1', '2017-05-05 14:09:55', NULL, '1', '2017-05-10', '0'),
 ('6', '12', '1', '1', '2017-05-05 14:09:55', NULL, '1', '2017-05-10', '0'),
-('7', '26', '1', '1', '2017-05-05 14:18:49', 'Quick production.', '1', '2017-05-05', '0'),
+('7', '29', '1', '1', '2017-05-05 14:18:49', 'Quick production.', '1', '2017-05-05', '0'),
 ('8', '18', '2', '1', '2017-05-05 14:22:32', NULL, '1', '2017-05-05', '0'),
 ('9', '25', '2', '1', '2017-05-05 14:22:32', NULL, '1', '2017-05-05', '0'),
 ('10', '20', '1', '1', '2017-05-05 14:22:32', NULL, '1', '2017-05-05', '0'),
@@ -110,9 +110,9 @@ INSERT INTO `0_audit_trail` VALUES
 ('22', '13', '4', '1', '2017-05-07 14:05:38', NULL, '1', '2017-05-07', '0'),
 ('23', '10', '4', '1', '2017-05-07 14:05:38', NULL, '1', '2017-05-07', '0'),
 ('24', '12', '3', '1', '2017-05-07 14:05:38', NULL, '1', '2017-05-07', '0'),
-('25', '26', '2', '1', '2017-05-07 15:59:34', NULL, '1', '2017-05-07', NULL),
-('26', '26', '3', '1', '2017-05-07 15:59:01', NULL, '1', '2017-05-07', '0'),
-('27', '26', '2', '1', '2017-05-07 15:59:34', 'Released.', '1', '2017-05-07', '0'),
+('25', '26', '1', '1', '2017-05-07 15:59:34', NULL, '1', '2017-05-07', NULL),
+('26', '29', '1', '1', '2017-05-07 15:59:01', 'Production.', '1', '2017-05-07', '0'),
+('27', '26', '1', '1', '2017-05-07 15:59:34', 'Released.', '1', '2017-05-07', '0'),
 ('28', '1', '1', '1', '2017-05-07 16:01:00', NULL, '1', '2017-05-07', '0');
 
 -- --------------------------------------------------------
@@ -498,7 +498,7 @@ INSERT INTO `0_crm_categories` VALUES (12, 'supplier', 'invoice', 'Invoices', 'I
 DROP TABLE IF EXISTS `0_crm_contacts`;
 CREATE TABLE IF NOT EXISTS `0_crm_contacts` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
-  `person_id` int(11) NOT NULL DEFAULT '0' COMMENT 'foreign key to crm_contacts',
+  `person_id` int(11) NOT NULL DEFAULT '0' COMMENT 'foreign key to crm_persons',
   `type` varchar(20) NOT NULL COMMENT 'foreign key to crm_categories',
   `action` varchar(20) NOT NULL COMMENT 'foreign key to crm_categories',
   `entity_id` varchar(11) DEFAULT NULL COMMENT 'entity id in related class table',
@@ -886,7 +886,7 @@ CREATE TABLE IF NOT EXISTS `0_gl_trans` (
   KEY `dimension2_id` (`dimension2_id`),
   KEY `tran_date` (`tran_date`),
   KEY `account_and_tran_date` (`account`,`tran_date`)
-) ENGINE=InnoDB AUTO_INCREMENT=39 ;
+) ENGINE=InnoDB AUTO_INCREMENT=41 ;
 
 --
 -- Dumping data for table `0_gl_trans`
@@ -905,32 +905,34 @@ INSERT INTO `0_gl_trans` VALUES
 ('10', '10', '1', '2017-05-10', '2150', '', '-297.14', '0', '0', NULL, NULL),
 ('11', '12', '1', '2017-05-10', '1065', '', '6240', '0', '0', NULL, NULL),
 ('12', '12', '1', '2017-05-10', '1200', '', '-6240', '0', '0', '2', '1'),
-('13', '26', '1', '2017-05-05', '1510', '1 * iPad Air 2 16GB', '-400', '0', '0', NULL, NULL),
-('14', '26', '1', '2017-05-05', '1510', '1 * iPhone 6 64GB', '-300', '0', '0', NULL, NULL),
-('15', '26', '1', '2017-05-05', '1510', '1 * iPhone Cover Case', '-20', '0', '0', NULL, NULL),
-('16', '26', '1', '2017-05-05', '1510', 'Produced 2 * AP Surf Set', '720', '0', '0', NULL, NULL),
-('17', '25', '2', '2017-05-05', '1510', '101', '3000', '0', '0', NULL, NULL),
-('18', '25', '2', '2017-05-05', '1550', '', '-3000', '0', '0', NULL, NULL),
-('19', '20', '1', '2017-05-05', '2150', '', '150', '0', '0', NULL, NULL),
-('20', '20', '1', '2017-05-05', '2100', '', '-3150', '0', '0', '3', '1'),
-('21', '20', '1', '2017-05-05', '1550', '', '3000', '0', '0', NULL, NULL),
-('22', '13', '2', '2017-05-07', '5010', '', '200', '0', '0', NULL, NULL),
-('23', '13', '2', '2017-05-07', '1510', '', '-200', '0', '0', NULL, NULL),
-('24', '10', '2', '2017-05-07', '4010', '', '-285.71', '0', '0', NULL, NULL),
-('25', '10', '2', '2017-05-07', '1200', '', '300', '0', '0', '2', '1'),
-('26', '10', '2', '2017-05-07', '2150', '', '-14.29', '0', '0', NULL, NULL),
-('27', '12', '2', '2017-05-07', '1065', '', '300', '0', '0', NULL, NULL),
-('28', '12', '2', '2017-05-07', '1200', '', '-300', '0', '0', '2', '1'),
-('29', '13', '3', '2017-05-07', '5010', '', '150', '1', '0', NULL, NULL),
-('30', '13', '3', '2017-05-07', '1510', '', '-150', '0', '0', NULL, NULL),
-('31', '13', '3', '2017-05-07', '5010', '', '10', '1', '0', NULL, NULL),
-('32', '13', '3', '2017-05-07', '1510', '', '-10', '0', '0', NULL, NULL),
-('33', '10', '3', '2017-05-07', '4010', '', '-250', '1', '0', NULL, NULL),
-('34', '10', '3', '2017-05-07', '4010', '', '-50', '1', '0', NULL, NULL),
-('35', '10', '3', '2017-05-07', '1200', '', '300', '0', '0', '2', '2'),
-('36', '12', '3', '2017-05-07', '1065', '', '0', '0', '0', NULL, NULL),
-('37', '1', '1', '2017-05-07', '5010', '', '5', '1', '0', NULL, NULL),
-('38', '1', '1', '2017-05-07', '1060', '', '-5', '0', '0', NULL, NULL);
+('13', '29', '1', '2017-05-05', '1510', '1 * iPad Air 2 16GB', '-400', '0', '0', NULL, NULL),
+('14', '29', '1', '2017-05-05', '1510', '1 * iPhone 6 64GB', '-300', '0', '0', NULL, NULL),
+('15', '29', '1', '2017-05-05', '1510', '1 * iPhone Cover Case', '-20', '0', '0', NULL, NULL),
+('16', '29', '1', '2017-05-05', '1530', '1 * Support', '720', '0', '0', NULL, NULL),
+('17', '26', '1', '2017-05-05', '1530', '', '-720', '0', '0', NULL, NULL),
+('18', '26', '1', '2017-05-05', '1510', '', '720', '0', '0', NULL, NULL),
+('19', '25', '2', '2017-05-05', '1510', '101', '3000', '0', '0', NULL, NULL),
+('20', '25', '2', '2017-05-05', '1550', '', '-3000', '0', '0', NULL, NULL),
+('21', '20', '1', '2017-05-05', '2150', '', '150', '0', '0', NULL, NULL),
+('22', '20', '1', '2017-05-05', '2100', '', '-3150', '0', '0', '3', '1'),
+('23', '20', '1', '2017-05-05', '1550', '', '3000', '0', '0', NULL, NULL),
+('24', '13', '2', '2017-05-07', '5010', '', '200', '0', '0', NULL, NULL),
+('25', '13', '2', '2017-05-07', '1510', '', '-200', '0', '0', NULL, NULL),
+('26', '10', '2', '2017-05-07', '4010', '', '-285.71', '0', '0', NULL, NULL),
+('27', '10', '2', '2017-05-07', '1200', '', '300', '0', '0', '2', '1'),
+('28', '10', '2', '2017-05-07', '2150', '', '-14.29', '0', '0', NULL, NULL),
+('29', '12', '2', '2017-05-07', '1065', '', '300', '0', '0', NULL, NULL),
+('30', '12', '2', '2017-05-07', '1200', '', '-300', '0', '0', '2', '1'),
+('31', '13', '3', '2017-05-07', '5010', '', '150', '1', '0', NULL, NULL),
+('32', '13', '3', '2017-05-07', '1510', '', '-150', '0', '0', NULL, NULL),
+('33', '13', '3', '2017-05-07', '5010', '', '10', '1', '0', NULL, NULL),
+('34', '13', '3', '2017-05-07', '1510', '', '-10', '0', '0', NULL, NULL),
+('35', '10', '3', '2017-05-07', '4010', '', '-250', '1', '0', NULL, NULL),
+('36', '10', '3', '2017-05-07', '4010', '', '-50', '1', '0', NULL, NULL),
+('37', '10', '3', '2017-05-07', '1200', '', '300', '0', '0', '2', '2'),
+('38', '12', '3', '2017-05-07', '1065', '', '0', '0', '0', NULL, NULL),
+('39', '1', '1', '2017-05-07', '5010', '', '5', '1', '0', NULL, NULL),
+('40', '1', '1', '2017-05-07', '1060', '', '-5', '0', '0', NULL, NULL);
 
 -- --------------------------------------------------------
 
@@ -1940,10 +1942,10 @@ INSERT INTO `0_stock_moves` VALUES
 ('3', '1', '103', '25', 'DEF', '2017-05-05', '10', '', '100', '10'),
 ('4', '1', '101', '13', 'DEF', '2017-05-10', '300', 'auto', '-20', '200'),
 ('5', '1', '301', '13', 'DEF', '2017-05-10', '80', 'auto', '-3', '0'),
-('6', '1', '101', '26', 'DEF', '2017-05-05', '200', '001/2017', '-2', '200'),
-('7', '1', '102', '26', 'DEF', '2017-05-05', '150', '001/2017', '-2', '150'),
-('8', '1', '103', '26', 'DEF', '2017-05-05', '10', '001/2017', '-2', '10'),
-('9', '1', '301', '26', 'DEF', '2017-05-05', '0', '001/2017', '-2', '0'),
+('6', '1', '101', '29', 'DEF', '2017-05-05', '200', '001/2017', '-2', '200'),
+('7', '1', '102', '29', 'DEF', '2017-05-05', '150', '001/2017', '-2', '150'),
+('8', '1', '103', '29', 'DEF', '2017-05-05', '10', '001/2017', '-2', '10'),
+('9', '1', '301', '29', 'DEF', '2017-05-05', '0', '001/2017', '-2', '0'),
 ('10', '1', '201', '26', 'DEF', '2017-05-05', '0', '001/2017', '2', '360'),
 ('11', '2', '101', '25', 'DEF', '2017-05-05', '200', '', '15', '200'),
 ('12', '2', '101', '13', 'DEF', '2017-05-07', '300', 'auto', '-1', '200'),
@@ -2555,6 +2557,8 @@ CREATE TABLE IF NOT EXISTS `0_wo_manufacture` (
 -- Dumping data for table `0_wo_manufacture`
 --
 
+INSERT INTO `0_wo_manufacture` VALUES (1, '001/2017', 1, 2, '2017-05-05');
+
 -- --------------------------------------------------------
 
 --
@@ -2580,12 +2584,12 @@ CREATE TABLE IF NOT EXISTS `0_wo_requirements` (
 --
 
 INSERT INTO `0_wo_requirements` VALUES
-('1', '1', '101', '1', '1', '0', 'DEF', '2'),
-('2', '1', '102', '1', '1', '0', 'DEF', '2'),
-('3', '1', '103', '1', '1', '0', 'DEF', '2'),
+('1', '1', '101', '1', '1', '200', 'DEF', '2'),
+('2', '1', '102', '1', '1', '150', 'DEF', '2'),
+('3', '1', '103', '1', '1', '10', 'DEF', '2'),
 ('4', '1', '301', '1', '1', '0', 'DEF', '2'),
-('5', '2', '101', '1', '1', '0', 'DEF', '0'),
-('6', '2', '102', '1', '1', '0', 'DEF', '0'),
-('7', '2', '103', '1', '1', '0', 'DEF', '0'),
+('5', '2', '101', '1', '1', '200', 'DEF', '0'),
+('6', '2', '102', '1', '1', '150', 'DEF', '0'),
+('7', '2', '103', '1', '1', '10', 'DEF', '0'),
 ('8', '2', '301', '1', '1', '0', 'DEF', '0');