a:2:{i:0;a:2:{s:6:"schema";O:18:"yii\db\TableSchema":7:{s:10:"schemaName";N;s:4:"name";s:8:"tbl_user";s:8:"fullName";s:8:"tbl_user";s:10:"primaryKey";a:1:{i:0;s:2:"id";}s:12:"sequenceName";s:0:"";s:11:"foreignKeys";a:2:{s:31:"fk_tbl_user_tbl_salutation1_idx";a:2:{i:0;s:14:"tbl_salutation";s:10:"salutation";s:2:"id";}s:30:"fk_tbl_user_tbl_user_type1_idx";a:2:{i:0;s:13:"tbl_user_type";s:12:"user_type_id";s:2:"id";}}s:7:"columns";a:31:{s:2:"id";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:2:"id";s:9:"allowNull";b:0;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:7:"int(11)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:11;s:9:"precision";i:11;s:5:"scale";N;s:12:"isPrimaryKey";b:1;s:13:"autoIncrement";b:1;s:8:"unsigned";b:0;s:7:"comment";s:0:"";s:18:"disableJsonSupport";b:0;}s:10:"first_name";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"first_name";s:9:"allowNull";b:0;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:12:"varchar(255)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:255;s:9:"precision";i:255;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:15:"User first name";s:18:"disableJsonSupport";b:0;}s:11:"middle_name";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:11:"middle_name";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:12:"varchar(255)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:255;s:9:"precision";i:255;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:16:"User middle name";s:18:"disableJsonSupport";b:0;}s:9:"last_name";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:9:"last_name";s:9:"allowNull";b:0;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:12:"varchar(255)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:255;s:9:"precision";i:255;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:14:"user last name";s:18:"disableJsonSupport";b:0;}s:8:"username";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:8:"username";s:9:"allowNull";b:0;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:12:"varchar(255)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:255;s:9:"precision";i:255;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:10:"User name ";s:18:"disableJsonSupport";b:0;}s:5:"phone";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:5:"phone";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:11:"varchar(43)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:43;s:9:"precision";i:43;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:12:"phone number";s:18:"disableJsonSupport";b:0;}s:5:"email";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:5:"email";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:12:"varchar(255)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:255;s:9:"precision";i:255;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:10:"User email";s:18:"disableJsonSupport";b:0;}s:10:"salutation";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"salutation";s:9:"allowNull";b:1;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:7:"int(11)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:11;s:9:"precision";i:11;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:0:"";s:18:"disableJsonSupport";b:0;}s:5:"photo";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:5:"photo";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:12:"varchar(255)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:255;s:9:"precision";i:255;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:0:"";s:18:"disableJsonSupport";b:0;}s:10:"photo_size";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"photo_size";s:9:"allowNull";b:1;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:7:"int(11)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:11;s:9:"precision";i:11;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:0:"";s:18:"disableJsonSupport";b:0;}s:14:"photo_verified";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:14:"photo_verified";s:9:"allowNull";b:1;s:4:"type";s:7:"tinyint";s:7:"phpType";s:7:"integer";s:6:"dbType";s:10:"tinyint(4)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:4;s:9:"precision";i:4;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:43:"1:Yes is Mine, 2:No is Not Mine, 3:No Image";s:18:"disableJsonSupport";b:0;}s:19:"photo_verified_date";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:19:"photo_verified_date";s:9:"allowNull";b:1;s:4:"type";s:8:"datetime";s:7:"phpType";s:6:"string";s:6:"dbType";s:8:"datetime";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:0:"";s:18:"disableJsonSupport";b:0;}s:3:"sex";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:3:"sex";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:13:"enum('M','F')";s:12:"defaultValue";N;s:10:"enumValues";a:2:{i:0;s:1:"M";i:1;s:1:"F";}s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:26:"1: M (Male), 2: F (Female)";s:18:"disableJsonSupport";b:0;}s:11:"nationality";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:11:"nationality";s:9:"allowNull";b:1;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:7:"int(11)";s:12:"defaultValue";i:177;s:10:"enumValues";N;s:4:"size";i:11;s:9:"precision";i:11;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:23:"fk from tbl_nationality";s:18:"disableJsonSupport";b:0;}s:10:"birth_date";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"birth_date";s:9:"allowNull";b:1;s:4:"type";s:4:"date";s:7:"phpType";s:6:"string";s:6:"dbType";s:4:"date";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:0:"";s:18:"disableJsonSupport";b:0;}s:8:"auth_key";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:8:"auth_key";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:12:"varchar(256)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:256;s:9:"precision";i:256;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:0:"";s:18:"disableJsonSupport";b:0;}s:13:"password_hash";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:13:"password_hash";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:12:"varchar(255)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:255;s:9:"precision";i:255;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:13:"User password";s:18:"disableJsonSupport";b:0;}s:20:"last_password_update";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:20:"last_password_update";s:9:"allowNull";b:1;s:4:"type";s:8:"datetime";s:7:"phpType";s:6:"string";s:6:"dbType";s:8:"datetime";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:26:"last password updated date";s:18:"disableJsonSupport";b:0;}s:16:"password_changed";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:16:"password_changed";s:9:"allowNull";b:1;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:7:"int(11)";s:12:"defaultValue";i:0;s:10:"enumValues";N;s:4:"size";i:11;s:9:"precision";i:11;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:25:"0: Not changed
1: Changed";s:18:"disableJsonSupport";b:0;}s:15:"last_login_date";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:15:"last_login_date";s:9:"allowNull";b:1;s:4:"type";s:8:"datetime";s:7:"phpType";s:6:"string";s:6:"dbType";s:8:"datetime";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:14:"Lat login date";s:18:"disableJsonSupport";b:0;}s:10:"is_deleted";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"is_deleted";s:9:"allowNull";b:0;s:4:"type";s:8:"smallint";s:7:"phpType";s:7:"integer";s:6:"dbType";s:11:"smallint(6)";s:12:"defaultValue";i:1;s:10:"enumValues";N;s:4:"size";i:6;s:9:"precision";i:6;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:13:"1: No, 2: Yes";s:18:"disableJsonSupport";b:0;}s:10:"is_blocked";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"is_blocked";s:9:"allowNull";b:0;s:4:"type";s:8:"smallint";s:7:"phpType";s:7:"integer";s:6:"dbType";s:11:"smallint(6)";s:12:"defaultValue";i:1;s:10:"enumValues";N;s:4:"size";i:6;s:9:"precision";i:6;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:12:"1: No 2: Yes";s:18:"disableJsonSupport";b:0;}s:12:"user_type_id";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:12:"user_type_id";s:9:"allowNull";b:0;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:7:"int(11)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:11;s:9:"precision";i:11;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:24:"type of user foreign key";s:18:"disableJsonSupport";b:0;}s:10:"created_at";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"created_at";s:9:"allowNull";b:0;s:4:"type";s:8:"datetime";s:7:"phpType";s:6:"string";s:6:"dbType";s:8:"datetime";s:12:"defaultValue";O:17:"yii\db\Expression":2:{s:10:"expression";s:17:"CURRENT_TIMESTAMP";s:6:"params";a:0:{}}s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:10:"created at";s:18:"disableJsonSupport";b:0;}s:10:"updated_at";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"updated_at";s:9:"allowNull";b:1;s:4:"type";s:8:"datetime";s:7:"phpType";s:6:"string";s:6:"dbType";s:8:"datetime";s:12:"defaultValue";O:17:"yii\db\Expression":2:{s:10:"expression";s:17:"CURRENT_TIMESTAMP";s:6:"params";a:0:{}}s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:12:"Updated date";s:18:"disableJsonSupport";b:0;}s:4:"nida";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:4:"nida";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:11:"varchar(50)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:50;s:9:"precision";i:50;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:0:"";s:18:"disableJsonSupport";b:0;}s:22:"password_history_count";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:22:"password_history_count";s:9:"allowNull";b:1;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:7:"int(11)";s:12:"defaultValue";i:0;s:10:"enumValues";N;s:4:"size";i:11;s:9:"precision";i:11;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:0:"";s:18:"disableJsonSupport";b:0;}s:19:"is_password_changed";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:19:"is_password_changed";s:9:"allowNull";b:1;s:4:"type";s:7:"tinyint";s:7:"phpType";s:7:"integer";s:6:"dbType";s:10:"tinyint(1)";s:12:"defaultValue";i:0;s:10:"enumValues";N;s:4:"size";i:1;s:9:"precision";i:1;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:38:"0=Default password, 1=Password changed";s:18:"disableJsonSupport";b:0;}s:16:"first_login_date";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:16:"first_login_date";s:9:"allowNull";b:1;s:4:"type";s:8:"datetime";s:7:"phpType";s:6:"string";s:6:"dbType";s:8:"datetime";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:0:"";s:18:"disableJsonSupport";b:0;}s:27:"default_password_changed_at";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:27:"default_password_changed_at";s:9:"allowNull";b:1;s:4:"type";s:8:"datetime";s:7:"phpType";s:6:"string";s:6:"dbType";s:8:"datetime";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:0:"";s:18:"disableJsonSupport";b:0;}s:21:"force_password_change";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:21:"force_password_change";s:9:"allowNull";b:0;s:4:"type";s:7:"tinyint";s:7:"phpType";s:7:"integer";s:6:"dbType";s:10:"tinyint(1)";s:12:"defaultValue";i:0;s:10:"enumValues";N;s:4:"size";i:1;s:9:"precision";i:1;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:0:"";s:18:"disableJsonSupport";b:0;}}}s:12:"cacheVersion";i:1;}i:1;O:25:"yii\caching\TagDependency":3:{s:4:"data";a:1:{s:32:"c13bddfe8939367e0c41d304534323a4";s:21:"0.86168900 1789734290";}s:8:"reusable";b:0;s:4:"tags";s:32:"448596f6b8386d6eafaeca295e344bd2";}}