From 3350c151bed8ec9f5134bd7f3b0f819e79cb3235 Mon Sep 17 00:00:00 2001 From: benny Date: Fri, 7 Sep 2018 10:24:10 +0800 Subject: [PATCH] sql/core_company.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 58620f82..ad5c5186 100644 --- a/sql/core_company.sql +++ b/sql/core_company.sql @@ -48,7 +48,7 @@ ALTER TABLE core_company ADD INDEX name_lookup (name); ALTER TABLE core_company ADD COLUMN deleted_by INT(11) NOT NULL DEFAULT 0; -ALTER TABLE core_company ADD COLUMN deleted_dt DATETIME NOT NULL DEFAULT '0000-00-00'; +ALTER TABLE core_company ADD COLUMN deleted_dt DATETIME NOT NULL DEFAULT '0000-00-00'; -- our new code should have this fixed now.. -- UPDATE core_company set comptype='OWNER' where isOwner=1; -- 2.39.2