X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=sql%2Fcore_email.sql;h=d3a74dd7a1f4ead1db170840960f82ea1016d2c6;hb=bf4e091d5ce02c5f5b4f8fc9e9669b1b34a4f559;hp=1b72ae9c6be86377e40f5ba7173b8edf3d6b60a1;hpb=202de2cda672bdda5614a2e530234db2ac9a9c67;p=Pman.Core diff --git a/sql/core_email.sql b/sql/core_email.sql index 1b72ae9c..d3a74dd7 100644 --- a/sql/core_email.sql +++ b/sql/core_email.sql @@ -23,8 +23,8 @@ ALTER TABLE core_email MODIFY COLUMN bcc_group INT(11) NOT NULL DEFAULT 0; ALTER TABLE core_email ADD COLUMN test_class VARCHAR(254) NOT NULL DEFAULT ''; ALTER TABLE core_email MODIFY COLUMN test_class VARCHAR(254) NOT NULL DEFAULT ''; -ALTER TABLE coba_person_investor_profile CHANGE COLUMN in_group to_group INT(11) NOT NULL DEFAULT -1; -ALTER TABLE core_email ADD COLUMN to_group INT(11) NOT NULL DEFAULT -1; +ALTER TABLE core_email CHANGE COLUMN in_group to_group INT(11) NOT NULL DEFAULT -1; +ALTER TABLE core_email ADD COLUMN to_group INT(11) NOT NULL DEFAULT -1; UPDATE core_email SET updated_dt = NOW() where updated_dt IS NULL;