DataObjects/core.sql

diff --git a/DataObjects/core.sql b/DataObjects/core.sql
index af70b76..534aae8 100644 (file)
--- a/DataObjects/core.sql
+++ b/DataObjects/core.sql
@@ -172,7 +172,7 @@ ALTER TABLE Person ADD COLUMN deleted_dt DATETIME ;
 
 # old mysql
 alter table Person change column active active int(11) NOT NULL DEFAULT 1 ;
-alter table Person change role role varchar(254);
+alter table Person change role role varchar(254) NOT NULL DEFAULT '';