From: Janusz Dobrowolski Date: Mon, 17 Sep 2018 06:32:24 +0000 (+0200) Subject: Fixed comment for crm_contacts table in init sql files. X-Git-Url: https://delta.frontaccounting.com/gitweb/?p=fa-stable.git;a=commitdiff_plain;h=317210096efdbe5b375d5a0112d4f10a3c3c0b53 Fixed comment for crm_contacts table in init sql files. --- diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql index a062309c..ff2055f5 100644 --- a/sql/en_US-demo.sql +++ b/sql/en_US-demo.sql @@ -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', diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql index 1abe56cd..b025189a 100644 --- a/sql/en_US-new.sql +++ b/sql/en_US-new.sql @@ -447,7 +447,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',