1715167716
O:32:"Cake\Database\Schema\TableSchema":7:{s:9:" * _table";s:8:"projects";s:11:" * _columns";a:34:{s:2:"id";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:11;s:8:"unsigned";b:0;s:4:"null";b:0;s:7:"default";N;s:7:"comment";s:0:"";s:13:"autoIncrement";b:1;s:8:"baseType";N;s:9:"precision";N;}s:5:"topic";a:8:{s:4:"type";s:4:"text";s:6:"length";N;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:17:"latin1_swedish_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:7:"service";a:9:{s:4:"type";s:6:"string";s:6:"length";i:200;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:17:"latin1_swedish_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:11:"category_id";a:9:{s:4:"type";s:6:"string";s:6:"length";i:250;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:17:"latin1_swedish_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:7:"subject";a:8:{s:4:"type";s:4:"text";s:6:"length";N;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:17:"latin1_swedish_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:5:"pages";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:11;s:8:"unsigned";b:0;s:4:"null";b:0;s:7:"default";N;s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:13:"autoIncrement";N;}s:5:"words";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:11;s:8:"unsigned";b:0;s:4:"null";b:0;s:7:"default";N;s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:13:"autoIncrement";N;}s:5:"price";a:8:{s:4:"type";s:7:"decimal";s:6:"length";i:11;s:9:"precision";i:2;s:8:"unsigned";b:0;s:4:"null";b:0;s:7:"default";N;s:7:"comment";s:0:"";s:8:"baseType";N;}s:8:"order_id";a:9:{s:4:"type";s:6:"string";s:6:"length";i:11;s:4:"null";b:1;s:7:"default";N;s:7:"collate";s:17:"latin1_swedish_ci";s:7:"comment";s:12:"MRP Order Id";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:11:"description";a:8:{s:4:"type";s:4:"text";s:6:"length";N;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:17:"latin1_swedish_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:15:"delivery_policy";a:8:{s:4:"type";s:4:"text";s:6:"length";N;s:4:"null";b:1;s:7:"default";N;s:7:"collate";s:17:"latin1_swedish_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:19:"modification_policy";a:8:{s:4:"type";s:4:"text";s:6:"length";N;s:4:"null";b:1;s:7:"default";N;s:7:"collate";s:17:"latin1_swedish_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:14:"payment_policy";a:8:{s:4:"type";s:4:"text";s:6:"length";N;s:4:"null";b:1;s:7:"default";N;s:7:"collate";s:17:"latin1_swedish_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:7:"website";a:9:{s:4:"type";s:6:"string";s:6:"length";i:10;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:17:"latin1_swedish_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:12:"order_status";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:11;s:8:"unsigned";b:0;s:4:"null";b:1;s:7:"default";N;s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:13:"autoIncrement";N;}s:13:"deadline_date";a:7:{s:4:"type";s:8:"datetime";s:6:"length";N;s:4:"null";b:0;s:7:"default";N;s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:15:"bid_expiry_date";a:7:{s:4:"type";s:8:"datetime";s:6:"length";N;s:4:"null";b:0;s:7:"default";N;s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:8:"language";a:9:{s:4:"type";s:6:"string";s:6:"length";i:50;s:4:"null";b:1;s:7:"default";N;s:7:"collate";s:17:"latin1_swedish_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:7:"created";a:7:{s:4:"type";s:9:"timestamp";s:6:"length";N;s:4:"null";b:0;s:7:"default";s:17:"CURRENT_TIMESTAMP";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:9:"file_data";a:8:{s:4:"type";s:4:"text";s:6:"length";N;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:17:"latin1_swedish_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:8:"modified";a:7:{s:4:"type";s:9:"timestamp";s:6:"length";N;s:4:"null";b:0;s:7:"default";s:17:"CURRENT_TIMESTAMP";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:10:"order_code";a:9:{s:4:"type";s:6:"string";s:6:"length";i:100;s:4:"null";b:1;s:7:"default";N;s:7:"collate";s:17:"latin1_swedish_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:16:"experience_level";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:1;s:8:"unsigned";b:0;s:4:"null";b:1;s:7:"default";N;s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:13:"autoIncrement";N;}s:6:"status";a:9:{s:4:"type";s:6:"string";s:6:"length";i:50;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:17:"latin1_swedish_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:13:"freelancer_id";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:11;s:8:"unsigned";b:0;s:4:"null";b:1;s:7:"default";N;s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:13:"autoIncrement";N;}s:13:"delete_status";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:1;s:8:"unsigned";b:0;s:4:"null";b:0;s:7:"default";s:1:"0";s:7:"comment";s:35:"0 => Not deleted,1=>deleted project";s:8:"baseType";N;s:9:"precision";N;s:13:"autoIncrement";N;}s:9:"delete_by";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:11;s:8:"unsigned";b:0;s:4:"null";b:1;s:7:"default";N;s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:13:"autoIncrement";N;}s:13:"allotted_date";a:7:{s:4:"type";s:8:"datetime";s:6:"length";N;s:4:"null";b:1;s:7:"default";N;s:7:"comment";s:17:"Project Allotment";s:8:"baseType";N;s:9:"precision";N;}s:7:"ratings";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:11;s:8:"unsigned";b:0;s:4:"null";b:0;s:7:"default";s:1:"0";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:13:"autoIncrement";N;}s:10:"pay_status";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:11;s:8:"unsigned";b:0;s:4:"null";b:0;s:7:"default";s:1:"0";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:13:"autoIncrement";N;}s:16:"allotment_remark";a:8:{s:4:"type";s:4:"text";s:6:"length";N;s:4:"null";b:1;s:7:"default";N;s:7:"collate";s:17:"latin1_swedish_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:4:"view";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:11;s:8:"unsigned";b:0;s:4:"null";b:0;s:7:"default";s:1:"0";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:13:"autoIncrement";N;}s:14:"finishing_date";a:7:{s:4:"type";s:8:"datetime";s:6:"length";N;s:4:"null";b:1;s:7:"default";N;s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:11:"cloned_from";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:11;s:8:"unsigned";b:0;s:4:"null";b:1;s:7:"default";N;s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:13:"autoIncrement";N;}}s:11:" * _typeMap";a:34:{s:2:"id";s:7:"integer";s:5:"topic";s:4:"text";s:7:"service";s:6:"string";s:11:"category_id";s:6:"string";s:7:"subject";s:4:"text";s:5:"pages";s:7:"integer";s:5:"words";s:7:"integer";s:5:"price";s:7:"decimal";s:8:"order_id";s:6:"string";s:11:"description";s:4:"text";s:15:"delivery_policy";s:4:"text";s:19:"modification_policy";s:4:"text";s:14:"payment_policy";s:4:"text";s:7:"website";s:6:"string";s:12:"order_status";s:7:"integer";s:13:"deadline_date";s:8:"datetime";s:15:"bid_expiry_date";s:8:"datetime";s:8:"language";s:6:"string";s:7:"created";s:9:"timestamp";s:9:"file_data";s:4:"text";s:8:"modified";s:9:"timestamp";s:10:"order_code";s:6:"string";s:16:"experience_level";s:7:"integer";s:6:"status";s:6:"string";s:13:"freelancer_id";s:7:"integer";s:13:"delete_status";s:7:"integer";s:9:"delete_by";s:7:"integer";s:13:"allotted_date";s:8:"datetime";s:7:"ratings";s:7:"integer";s:10:"pay_status";s:7:"integer";s:16:"allotment_remark";s:4:"text";s:4:"view";s:7:"integer";s:14:"finishing_date";s:8:"datetime";s:11:"cloned_from";s:7:"integer";}s:11:" * _indexes";a:0:{}s:15:" * _constraints";a:1:{s:7:"primary";a:3:{s:4:"type";s:7:"primary";s:7:"columns";a:1:{i:0;s:2:"id";}s:6:"length";a:0:{}}}s:11:" * _options";a:2:{s:6:"engine";s:6:"InnoDB";s:9:"collation";s:17:"latin1_swedish_ci";}s:13:" * _temporary";b:0;}
