From e86359f3e2474ef9a11398b49a84da6cfa0a8a71 Mon Sep 17 00:00:00 2001 From: Alan Date: Fri, 30 Dec 2022 11:38:00 +0800 Subject: [PATCH] fix sql --- sql/core_company.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sql/core_company.sql b/sql/core_company.sql index e6309533..143bf020 100644 --- a/sql/core_company.sql +++ b/sql/core_company.sql @@ -34,7 +34,7 @@ ALTER TABLE core_company ADD COLUMN comptype varchar(32) NOT NULL DEFAULT '' -- not sure if this needs to change.. << there is code in core/update that fills this in?? ALTER TABLE core_company ADD COLUMN comptype_id INT(11) DEFAULT 0; -ALTER TABLE core_company ADD COLUMN parent_id NOT NULL DEFAULT 0; +ALTER TABLE core_company ADD COLUMN parent_id INT NOT NULL DEFAULT 0; -- 2.39.2