public $phone_direct; // varchar(32) NOT NULL DEFAULT '';
public $countries; // VARCHAR(128) NULL;
+ public $language;
+
/* the code above is auto generated do not remove the tag below */
###END_AUTOCODE
$this->sessionState(0);
$lang = !$this->authUser || empty($this->authUser->lang ) ? 'en' : $this->authUser->lang;
-
- /// verify the selected language..
+ /// verify the selected language..
$i = DB_DataObject::Factory('I18n');
$i->ltype = 'l'; // string(1) not_null multiple_key
$i->lkey = $lang; // string(8) not_null
$extra[] = "create sequence {$tbl}_seq;";
}
-
+ if ($tbl && preg_match('#engine=\S+#i', $l, $m)) {
+ $l = preg_replace('#engine=\S+#i', '', $l);
+
+ }
if (preg_match('#alter\s+table\s+(\`[a-z0-9_]+\`)#i', $l, $m)){
$l = preg_replace('#alter\s+table\s+(\`[a-z0-9_]+\`)#i', "ALTER TABLE {$tbl}", $l);
}
$g = DB_DataObject::Factory('core_group')->lookup('name',$data['bcc_group']);
- if (empty($g->id)) {
+ if (empty($g->id)) { // Admin group as bcc will not have any member at initialization.
$this->jerr("bcc_group {$data['bcc_group']} does not exist when importing template $name");
}
- if (!$g->members('email') && $g->name != 'Empty Group') {
+ if (!$g->members('email') && $g->name != 'Empty Group' && $g->name != 'Administrators') {
$this->jerr("bcc_group {$data['bcc_group']} does not have any members");
}
id int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (id)
-) ENGINE=InnoDB;
+);
ALTER TABLE i18n ADD COLUMN ltype varchar(1) NOT NULL DEFAULT '';
ALTER TABLE i18n ADD COLUMN lkey varchar(8) NOT NULL DEFAULT '';
-- chose title is like a nickname
-ALTER TABLE core_person ADD COLUMN chosen_title TEXT NOT NULL;
+ALTER TABLE core_person ADD COLUMN chosen_title TEXT NOT NULL DEFAULT '';
ALTER TABLE core_person ADD COLUMN role varchar(254) NOT NULL DEFAULT '';
ALTER TABLE core_person ADD COLUMN deleted_by INT(11) NOT NULL default 0 ;
-ALTER TABLE core_person ADD COLUMN deleted_dt DATETIME ;
+ALTER TABLE core_person ADD COLUMN deleted_dt DATETIME no null default '1000-01-01 00:00:00';
-- social
ALTER TABLE core_person ADD COLUMN url_twitter VARCHAR(256) NULL ;
ALTER TABLE core_person ADD COLUMN linkedin_id VARCHAR(256) NULL ;
ALTER TABLE core_person ADD COLUMN url_linkedin VARCHAR(256) NULL ;
-ALTER TABLE core_person ADD COLUMN url_google_plus TEXT NOT NULL;
-ALTER TABLE core_person ADD COLUMN url_blog2 TEXT NOT NULL;
-ALTER TABLE core_person ADD COLUMN url_blog3 TEXT NOT NULL;
+ALTER TABLE core_person ADD COLUMN url_google_plus TEXT NOT NULL DEFAULT '';
+ALTER TABLE core_person ADD COLUMN url_blog2 TEXT NOT NULL DEFAULT '';
+ALTER TABLE core_person ADD COLUMN url_blog3 TEXT NOT NULL DEFAULT '';