a:18:{s:13:"announcements";O:32:"Cake\Database\Schema\TableSchema":7:{s:9:"*_table";s:13:"announcements";s:11:"*_columns";a:6:{s:2:"id";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;s:8:"unsigned";b:1;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:"title";a:9:{s:4:"type";s:6:"string";s:6:"length";i:256;s:4:"null";b:0;s:7:"default";s:0:"";s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:9:"published";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:2;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:7:"content";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:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:8:"modified";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:7:"created";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:"*_typeMap";a:6:{s:2:"id";s:10:"biginteger";s:5:"title";s:6:"string";s:9:"published";s:7:"integer";s:7:"content";s:4:"text";s:8:"modified";s:8:"datetime";s:7:"created";s:8:"datetime";}s:11:"*_indexes";a:1:{s:16:"idx_published_id";a:3:{s:4:"type";s:5:"index";s:7:"columns";a:2:{i:0;s:9:"published";i:1;s:2:"id";}s:6:"length";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:15:"utf8_general_ci";}s:13:"*_temporary";b:0;}s:14:"campaign_items";O:32:"Cake\Database\Schema\TableSchema":7:{s:9:"*_table";s:14:"campaign_items";s:11:"*_columns";a:8:{s:2:"id";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;s:8:"unsigned";b:1;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:11:"campaign_id";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;s:8:"unsigned";b:1;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:7:"country";a:9:{s:4:"type";s:6:"string";s:6:"length";i:3;s:4:"null";b:0;s:7:"default";s:0:"";s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:16:"advertiser_price";a:8:{s:4:"type";s:5:"float";s:6:"length";i:50;s:9:"precision";i:6;s:8:"unsigned";b:0;s:4:"null";b:0;s:7:"default";N;s:7:"comment";s:0:"";s:8:"baseType";N;}s:15:"publisher_price";a:8:{s:4:"type";s:5:"float";s:6:"length";i:50;s:9:"precision";i:6;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:"purchase";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:10;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:"views";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:10;s:8:"unsigned";b:1;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:6:"weight";a:8:{s:4:"type";s:5:"float";s:6:"length";i:18;s:9:"precision";i:15;s:8:"unsigned";b:0;s:4:"null";b:0;s:7:"default";s:17:"0.000000000000000";s:7:"comment";s:0:"";s:8:"baseType";N;}}s:11:"*_typeMap";a:8:{s:2:"id";s:10:"biginteger";s:11:"campaign_id";s:10:"biginteger";s:7:"country";s:6:"string";s:16:"advertiser_price";s:5:"float";s:15:"publisher_price";s:5:"float";s:8:"purchase";s:7:"integer";s:5:"views";s:7:"integer";s:6:"weight";s:5:"float";}s:11:"*_indexes";a:2:{s:14:"idx_campaignid";a:3:{s:4:"type";s:5:"index";s:7:"columns";a:1:{i:0;s:11:"campaign_id";}s:6:"length";a:0:{}}s:18:"idx_weight_country";a:3:{s:4:"type";s:5:"index";s:7:"columns";a:2:{i:0;s:6:"weight";i:1;s:7:"country";}s:6:"length";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:15:"utf8_general_ci";}s:13:"*_temporary";b:0;}s:9:"campaigns";O:32:"Cake\Database\Schema\TableSchema":7:{s:9:"*_table";s:9:"campaigns";s:11:"*_columns";a:20:{s:2:"id";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;s:8:"unsigned";b:1;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:16:"default_campaign";a:7:{s:4:"type";s:7:"boolean";s:6:"length";N;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:7:"user_id";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;s:8:"unsigned";b:1;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:7:"ad_type";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:2;s:8:"unsigned";b:1;s:4:"null";b:0;s:7:"default";s:1:"1";s:7:"comment";s:22:"1 = inter., 2 = banner";s:8:"baseType";N;s:9:"precision";N;s:13:"autoIncrement";N;}s:6:"status";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:2;s:8:"unsigned";b:1;s:4:"null";b:0;s:7:"default";s:1:"0";s:7:"comment";s:108:"1=Active, 2=Paused, 3=Canceled, 4=Finished, 5=Under Review, 6=Pending Payment, 7=Invalid Payment, 8=Refunded";s:8:"baseType";N;s:9:"precision";N;s:13:"autoIncrement";N;}s:14:"payment_method";a:9:{s:4:"type";s:6:"string";s:6:"length";i:256;s:4:"null";b:0;s:7:"default";s:0:"";s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:4:"name";a:9:{s:4:"type";s:6:"string";s:6:"length";i:256;s:4:"null";b:1;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:13:"website_title";a:9:{s:4:"type";s:6:"string";s:6:"length";i:256;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:11:"website_url";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:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:11:"banner_name";a:9:{s:4:"type";s:6:"string";s:6:"length";i:256;s:4:"null";b:1;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:11:"banner_size";a:8:{s:4:"type";s:4:"text";s:6:"length";i:255;s:4:"null";b:1;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:11:"banner_code";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:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:5:"price";a:8:{s:4:"type";s:5:"float";s:6:"length";i:50;s:9:"precision";i:6;s:8:"unsigned";b:0;s:4:"null";b:0;s:7:"default";N;s:7:"comment";s:0:"";s:8:"baseType";N;}s:14:"traffic_source";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:2;s:8:"unsigned";b:1;s:4:"null";b:0;s:7:"default";s:1:"1";s:7:"comment";s:32:"1 = all, 2 = Desktop, 3 = Mobile";s:8:"baseType";N;s:9:"precision";N;s:13:"autoIncrement";N;}s:14:"transaction_id";a:9:{s:4:"type";s:6:"string";s:6:"length";i:256;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:19:"transaction_details";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:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:7:"started";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:9:"completed";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:"modified";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:7:"created";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:11:"*_typeMap";a:20:{s:2:"id";s:10:"biginteger";s:16:"default_campaign";s:7:"boolean";s:7:"user_id";s:10:"biginteger";s:7:"ad_type";s:7:"integer";s:6:"status";s:7:"integer";s:14:"payment_method";s:6:"string";s:4:"name";s:6:"string";s:13:"website_title";s:6:"string";s:11:"website_url";s:4:"text";s:11:"banner_name";s:6:"string";s:11:"banner_size";s:4:"text";s:11:"banner_code";s:4:"text";s:5:"price";s:5:"float";s:14:"traffic_source";s:7:"integer";s:14:"transaction_id";s:6:"string";s:19:"transaction_details";s:4:"text";s:7:"started";s:8:"datetime";s:9:"completed";s:8:"datetime";s:8:"modified";s:8:"datetime";s:7:"created";s:8:"datetime";}s:11:"*_indexes";a:2:{s:10:"idx_userid";a:3:{s:4:"type";s:5:"index";s:7:"columns";a:1:{i:0;s:7:"user_id";}s:6:"length";a:0:{}}s:13:"idx_campaigns";a:3:{s:4:"type";s:5:"index";s:7:"columns";a:4:{i:0;s:16:"default_campaign";i:1;s:7:"ad_type";i:2;s:6:"status";i:3;s:14:"traffic_source";}s:6:"length";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:15:"utf8_general_ci";}s:13:"*_temporary";b:0;}s:4:"i18n";O:32:"Cake\Database\Schema\TableSchema":7:{s:9:"*_table";s:4:"i18n";s:11:"*_columns";a:6:{s:2:"id";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;s:8:"unsigned";b:1;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:6:"locale";a:9:{s:4:"type";s:6:"string";s:6:"length";i:6;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:5:"model";a:9:{s:4:"type";s:6:"string";s:6:"length";i:20;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:11:"foreign_key";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:10;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:"field";a:9:{s:4:"type";s:6:"string";s:6:"length";i:20;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:7:"content";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:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}}s:11:"*_typeMap";a:6:{s:2:"id";s:10:"biginteger";s:6:"locale";s:6:"string";s:5:"model";s:6:"string";s:11:"foreign_key";s:7:"integer";s:5:"field";s:6:"string";s:7:"content";s:4:"text";}s:11:"*_indexes";a:1:{s:5:"model";a:3:{s:4:"type";s:5:"index";s:7:"columns";a:3:{i:0;s:5:"model";i:1;s:11:"foreign_key";i:2;s:5:"field";}s:6:"length";a:0:{}}}s:15:"*_constraints";a:2:{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:6:"locale";a:3:{s:4:"type";s:6:"unique";s:7:"columns";a:4:{i:0;s:6:"locale";i:1;s:5:"model";i:2;s:11:"foreign_key";i:3;s:5:"field";}s:6:"length";a:0:{}}}s:11:"*_options";a:2:{s:6:"engine";s:6:"InnoDB";s:9:"collation";s:15:"utf8_general_ci";}s:13:"*_temporary";b:0;}s:8:"invoices";O:32:"Cake\Database\Schema\TableSchema":7:{s:9:"*_table";s:8:"invoices";s:11:"*_columns";a:12:{s:2:"id";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;s:8:"unsigned";b:1;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:6:"status";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:2;s:8:"unsigned";b:1;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:7:"user_id";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;s:8:"unsigned";b:1;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:11:"description";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:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:4:"type";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:2;s:8:"unsigned";b:1;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:6:"rel_id";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;s:8:"unsigned";b:1;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:"payment_method";a:9:{s:4:"type";s:6:"string";s:6:"length";i:255;s:4:"null";b:0;s:7:"default";s:0:"";s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:6:"amount";a:8:{s:4:"type";s:7:"decimal";s:6:"length";i:10;s:9:"precision";i:6;s:8:"unsigned";b:1;s:4:"null";b:0;s:7:"default";s:8:"0.000000";s:7:"comment";s:0:"";s:8:"baseType";N;}s:4:"data";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:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:9:"paid_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:8:"modified";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:7:"created";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:"*_typeMap";a:12:{s:2:"id";s:10:"biginteger";s:6:"status";s:7:"integer";s:7:"user_id";s:10:"biginteger";s:11:"description";s:4:"text";s:4:"type";s:7:"integer";s:6:"rel_id";s:10:"biginteger";s:14:"payment_method";s:6:"string";s:6:"amount";s:7:"decimal";s:4:"data";s:4:"text";s:9:"paid_date";s:8:"datetime";s:8:"modified";s:8:"datetime";s:7:"created";s:8:"datetime";}s:11:"*_indexes";a:1:{s:10:"idx_userId";a:3:{s:4:"type";s:5:"index";s:7:"columns";a:1:{i:0;s:7:"user_id";}s:6:"length";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:15:"utf8_general_ci";}s:13:"*_temporary";b:0;}s:5:"links";O:32:"Cake\Database\Schema\TableSchema":7:{s:9:"*_table";s:5:"links";s:11:"*_columns";a:17:{s:2:"id";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;s:8:"unsigned";b:1;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:7:"user_id";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;s:8:"unsigned";b:1;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:7:"ad_type";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:2;s:8:"unsigned";b:1;s:4:"null";b:0;s:7:"default";s:1:"1";s:7:"comment";s:44:"0=direct, 1=interstitial, 2=banner, 3=random";s:8:"baseType";N;s:9:"precision";N;s:13:"autoIncrement";N;}s:6:"status";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:2;s:8:"unsigned";b:1;s:4:"null";b:0;s:7:"default";s:1:"0";s:7:"comment";s:30:"1=active, 2=hidden, 3=inactive";s:8:"baseType";N;s:9:"precision";N;s:13:"autoIncrement";N;}s:3:"url";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:8:"utf8_bin";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:8:"url_hash";a:9:{s:4:"type";s:6:"string";s:6:"length";i:40;s:4:"null";b:1;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:6:"domain";a:9:{s:4:"type";s:6:"string";s:6:"length";i:255;s:4:"null";b:0;s:7:"default";s:0:"";s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:5:"alias";a:9:{s:4:"type";s:6:"string";s:6:"length";i:30;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:8:"utf8_bin";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:5:"title";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:15:"utf8_general_ci";s:7:"comment";s:0:"";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:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:5:"image";a:9:{s:4:"type";s:6:"string";s:6:"length";i:256;s:4:"null";b:1;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:4:"hits";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;s:8:"unsigned";b:1;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:6:"method";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:2;s:8:"unsigned";b:1;s:4:"null";b:0;s:7:"default";s:1:"0";s:7:"comment";s:52:"1=web, 2=quick, 3=mass, 4=full, 5=api, 6=bookmarklet";s:8:"baseType";N;s:9:"precision";N;s:13:"autoIncrement";N;}s:10:"expiration";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:13:"last_activity";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:8:"modified";a:7:{s:4:"type";s:8:"datetime";s:6:"length";N;s:4:"null";b:0;s:7:"default";s:19:"0000-00-00 00:00:00";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:7:"created";a:7:{s:4:"type";s:8:"datetime";s:6:"length";N;s:4:"null";b:0;s:7:"default";s:19:"0000-00-00 00:00:00";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}}s:11:"*_typeMap";a:17:{s:2:"id";s:10:"biginteger";s:7:"user_id";s:10:"biginteger";s:7:"ad_type";s:7:"integer";s:6:"status";s:7:"integer";s:3:"url";s:4:"text";s:8:"url_hash";s:6:"string";s:6:"domain";s:6:"string";s:5:"alias";s:6:"string";s:5:"title";s:6:"string";s:11:"description";s:4:"text";s:5:"image";s:6:"string";s:4:"hits";s:10:"biginteger";s:6:"method";s:7:"integer";s:10:"expiration";s:8:"datetime";s:13:"last_activity";s:8:"datetime";s:8:"modified";s:8:"datetime";s:7:"created";s:8:"datetime";}s:11:"*_indexes";a:4:{s:11:"idx_urlhash";a:3:{s:4:"type";s:5:"index";s:7:"columns";a:1:{i:0;s:8:"url_hash";}s:6:"length";a:0:{}}s:9:"idx_alias";a:3:{s:4:"type";s:5:"index";s:7:"columns";a:1:{i:0;s:5:"alias";}s:6:"length";a:0:{}}s:10:"idx_userid";a:3:{s:4:"type";s:5:"index";s:7:"columns";a:1:{i:0;s:7:"user_id";}s:6:"length";a:0:{}}s:16:"idx_lastActivity";a:3:{s:4:"type";s:5:"index";s:7:"columns";a:1:{i:0;s:13:"last_activity";}s:6:"length";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:15:"utf8_general_ci";}s:13:"*_temporary";b:0;}s:7:"options";O:32:"Cake\Database\Schema\TableSchema":7:{s:9:"*_table";s:7:"options";s:11:"*_columns";a:3:{s:2:"id";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;s:8:"unsigned";b:1;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:4:"name";a:9:{s:4:"type";s:6:"string";s:6:"length";i:100;s:4:"null";b:0;s:7:"default";s:0:"";s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:5:"value";a:8:{s:4:"type";s:4:"text";s:6:"length";i:4294967295;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}}s:11:"*_typeMap";a:3:{s:2:"id";s:10:"biginteger";s:4:"name";s:6:"string";s:5:"value";s:4:"text";}s:11:"*_indexes";a:0:{}s:15:"*_constraints";a:2:{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:8:"idx_name";a:3:{s:4:"type";s:6:"unique";s:7:"columns";a:1:{i:0;s:4:"name";}s:6:"length";a:0:{}}}s:11:"*_options";a:2:{s:6:"engine";s:6:"InnoDB";s:9:"collation";s:15:"utf8_general_ci";}s:13:"*_temporary";b:0;}s:5:"pages";O:32:"Cake\Database\Schema\TableSchema":7:{s:9:"*_table";s:5:"pages";s:11:"*_columns";a:9:{s:2:"id";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;s:8:"unsigned";b:1;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:"title";a:9:{s:4:"type";s:6:"string";s:6:"length";i:256;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:4:"slug";a:9:{s:4:"type";s:6:"string";s:6:"length";i:255;s:4:"null";b:0;s:7:"default";s:0:"";s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:9:"published";a:9:{s:4:"type";s:7:"integer";s:6:"length";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:9:"precision";N;s:13:"autoIncrement";N;}s:7:"content";a:8:{s:4:"type";s:4:"text";s:6:"length";i:4294967295;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:10:"meta_title";a:9:{s:4:"type";s:6:"string";s:6:"length";i:255;s:4:"null";b:0;s:7:"default";s:0:"";s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:16:"meta_description";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:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:8:"modified";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:7:"created";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:11:"*_typeMap";a:9:{s:2:"id";s:10:"biginteger";s:5:"title";s:6:"string";s:4:"slug";s:6:"string";s:9:"published";s:7:"integer";s:7:"content";s:4:"text";s:10:"meta_title";s:6:"string";s:16:"meta_description";s:4:"text";s:8:"modified";s:8:"datetime";s:7:"created";s:8:"datetime";}s:11:"*_indexes";a:1:{s:18:"idx_slug_published";a:3:{s:4:"type";s:5:"index";s:7:"columns";a:2:{i:0;s:4:"slug";i:1;s:9:"published";}s:6:"length";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:15:"utf8_general_ci";}s:13:"*_temporary";b:0;}s:5:"plans";O:32:"Cake\Database\Schema\TableSchema":7:{s:9:"*_table";s:5:"plans";s:11:"*_columns";a:38:{s:2:"id";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;s:8:"unsigned";b:1;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:"title";a:9:{s:4:"type";s:6:"string";s:6:"length";i:256;s:4:"null";b:0;s:7:"default";s:0:"";s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:6:"enable";a:7:{s:4:"type";s:7:"boolean";s:6:"length";N;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:6:"hidden";a:7:{s:4:"type";s:7:"boolean";s:6:"length";N;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:11:"description";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:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:13:"monthly_price";a:8:{s:4:"type";s:7:"decimal";s:6:"length";i:10;s:9:"precision";i:6;s:8:"unsigned";b:1;s:4:"null";b:0;s:7:"default";s:8:"0.000000";s:7:"comment";s:0:"";s:8:"baseType";N;}s:12:"yearly_price";a:8:{s:4:"type";s:7:"decimal";s:6:"length";i:10;s:9:"precision";i:6;s:8:"unsigned";b:1;s:4:"null";b:0;s:7:"default";s:8:"0.000000";s:7:"comment";s:0:"";s:8:"baseType";N;}s:15:"url_daily_limit";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:10;s:8:"unsigned";b:1;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:17:"url_monthly_limit";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:10;s:8:"unsigned";b:1;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:18:"views_hourly_limit";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:10;s:8:"unsigned";b:1;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:17:"views_daily_limit";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:10;s:8:"unsigned";b:1;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:19:"views_monthly_limit";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:10;s:8:"unsigned";b:1;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:9:"cpm_fixed";a:8:{s:4:"type";s:7:"decimal";s:6:"length";i:50;s:9:"precision";i:9;s:8:"unsigned";b:1;s:4:"null";b:0;s:7:"default";s:11:"0.000000000";s:7:"comment";s:0:"";s:8:"baseType";N;}s:5:"timer";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:10;s:8:"unsigned";b:1;s:4:"null";b:0;s:7:"default";s:1:"5";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:13:"autoIncrement";N;}s:15:"direct_redirect";a:7:{s:4:"type";s:7:"boolean";s:6:"length";N;s:4:"null";b:0;s:7:"default";s:1:"1";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:15:"banner_redirect";a:7:{s:4:"type";s:7:"boolean";s:6:"length";N;s:4:"null";b:0;s:7:"default";s:1:"1";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:21:"interstitial_redirect";a:7:{s:4:"type";s:7:"boolean";s:6:"length";N;s:4:"null";b:0;s:7:"default";s:1:"1";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:15:"random_redirect";a:7:{s:4:"type";s:7:"boolean";s:6:"length";N;s:4:"null";b:0;s:7:"default";s:1:"1";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:9:"edit_link";a:7:{s:4:"type";s:7:"boolean";s:6:"length";N;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:"edit_long_url";a:7:{s:4:"type";s:7:"boolean";s:6:"length";N;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:15:"link_expiration";a:7:{s:4:"type";s:7:"boolean";s:6:"length";N;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:"multi_domains";a:7:{s:4:"type";s:7:"boolean";s:6:"length";N;s:4:"null";b:0;s:7:"default";s:1:"1";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:11:"disable_ads";a:7:{s:4:"type";s:7:"boolean";s:6:"length";N;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:15:"disable_captcha";a:7:{s:4:"type";s:7:"boolean";s:6:"length";N;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:23:"visitors_remove_captcha";a:7:{s:4:"type";s:7:"boolean";s:6:"length";N;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:15:"onetime_captcha";a:7:{s:4:"type";s:7:"boolean";s:6:"length";N;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:6:"direct";a:7:{s:4:"type";s:7:"boolean";s:6:"length";N;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:5:"alias";a:7:{s:4:"type";s:7:"boolean";s:6:"length";N;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:8:"referral";a:7:{s:4:"type";s:7:"boolean";s:6:"length";N;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:19:"referral_percentage";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:10;s:8:"unsigned";b:1;s:4:"null";b:0;s:7:"default";s:2:"20";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:13:"autoIncrement";N;}s:5:"stats";a:7:{s:4:"type";s:7:"boolean";s:6:"length";N;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:9:"api_quick";a:7:{s:4:"type";s:7:"boolean";s:6:"length";N;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:8:"api_mass";a:7:{s:4:"type";s:7:"boolean";s:6:"length";N;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:8:"api_full";a:7:{s:4:"type";s:7:"boolean";s:6:"length";N;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:"api_developer";a:7:{s:4:"type";s:7:"boolean";s:6:"length";N;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:11:"bookmarklet";a:7:{s:4:"type";s:7:"boolean";s:6:"length";N;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:8:"modified";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:7:"created";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:"*_typeMap";a:38:{s:2:"id";s:10:"biginteger";s:5:"title";s:6:"string";s:6:"enable";s:7:"boolean";s:6:"hidden";s:7:"boolean";s:11:"description";s:4:"text";s:13:"monthly_price";s:7:"decimal";s:12:"yearly_price";s:7:"decimal";s:15:"url_daily_limit";s:7:"integer";s:17:"url_monthly_limit";s:7:"integer";s:18:"views_hourly_limit";s:7:"integer";s:17:"views_daily_limit";s:7:"integer";s:19:"views_monthly_limit";s:7:"integer";s:9:"cpm_fixed";s:7:"decimal";s:5:"timer";s:7:"integer";s:15:"direct_redirect";s:7:"boolean";s:15:"banner_redirect";s:7:"boolean";s:21:"interstitial_redirect";s:7:"boolean";s:15:"random_redirect";s:7:"boolean";s:9:"edit_link";s:7:"boolean";s:13:"edit_long_url";s:7:"boolean";s:15:"link_expiration";s:7:"boolean";s:13:"multi_domains";s:7:"boolean";s:11:"disable_ads";s:7:"boolean";s:15:"disable_captcha";s:7:"boolean";s:23:"visitors_remove_captcha";s:7:"boolean";s:15:"onetime_captcha";s:7:"boolean";s:6:"direct";s:7:"boolean";s:5:"alias";s:7:"boolean";s:8:"referral";s:7:"boolean";s:19:"referral_percentage";s:7:"integer";s:5:"stats";s:7:"boolean";s:9:"api_quick";s:7:"boolean";s:8:"api_mass";s:7:"boolean";s:8:"api_full";s:7:"boolean";s:13:"api_developer";s:7:"boolean";s:11:"bookmarklet";s:7:"boolean";s:8:"modified";s:8:"datetime";s:7:"created";s:8:"datetime";}s:11:"*_indexes";a:1:{s:17:"idx_enable_hidden";a:3:{s:4:"type";s:5:"index";s:7:"columns";a:2:{i:0;s:6:"enable";i:1;s:6:"hidden";}s:6:"length";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:15:"utf8_general_ci";}s:13:"*_temporary";b:0;}s:5:"posts";O:32:"Cake\Database\Schema\TableSchema":7:{s:9:"*_table";s:5:"posts";s:11:"*_columns";a:10:{s:2:"id";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;s:8:"unsigned";b:1;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:"title";a:9:{s:4:"type";s:6:"string";s:6:"length";i:256;s:4:"null";b:0;s:7:"default";s:0:"";s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:4:"slug";a:9:{s:4:"type";s:6:"string";s:6:"length";i:255;s:4:"null";b:0;s:7:"default";s:0:"";s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:9:"published";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:2;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:17:"short_description";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:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:11:"description";a:8:{s:4:"type";s:4:"text";s:6:"length";i:4294967295;s:4:"null";b:1;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:10:"meta_title";a:9:{s:4:"type";s:6:"string";s:6:"length";i:255;s:4:"null";b:0;s:7:"default";s:0:"";s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:16:"meta_description";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:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:8:"modified";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:7:"created";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:"*_typeMap";a:10:{s:2:"id";s:10:"biginteger";s:5:"title";s:6:"string";s:4:"slug";s:6:"string";s:9:"published";s:7:"integer";s:17:"short_description";s:4:"text";s:11:"description";s:4:"text";s:10:"meta_title";s:6:"string";s:16:"meta_description";s:4:"text";s:8:"modified";s:8:"datetime";s:7:"created";s:8:"datetime";}s:11:"*_indexes";a:1:{s:16:"idx_published_id";a:3:{s:4:"type";s:5:"index";s:7:"columns";a:2:{i:0;s:9:"published";i:1;s:2:"id";}s:6:"length";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:15:"utf8_general_ci";}s:13:"*_temporary";b:0;}s:15:"queue_processes";O:32:"Cake\Database\Schema\TableSchema":7:{s:9:"*_table";s:15:"queue_processes";s:11:"*_columns";a:7:{s:2:"id";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;s:8:"unsigned";b:1;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:3:"pid";a:9:{s:4:"type";s:6:"string";s:6:"length";i:40;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:18:"utf8mb4_unicode_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:9:"terminate";a:7:{s:4:"type";s:7:"boolean";s:6:"length";N;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:6:"server";a:9:{s:4:"type";s:6:"string";s:6:"length";i:90;s:4:"null";b:1;s:7:"default";N;s:7:"collate";s:18:"utf8mb4_unicode_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:9:"workerkey";a:9:{s:4:"type";s:6:"string";s:6:"length";i:45;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:18:"utf8mb4_unicode_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:8:"modified";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:7:"created";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:11:"*_typeMap";a:7:{s:2:"id";s:10:"biginteger";s:3:"pid";s:6:"string";s:9:"terminate";s:7:"boolean";s:6:"server";s:6:"string";s:9:"workerkey";s:6:"string";s:8:"modified";s:8:"datetime";s:7:"created";s:8:"datetime";}s:11:"*_indexes";a:0:{}s:15:"*_constraints";a:3:{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:13:"idx_workerkey";a:3:{s:4:"type";s:6:"unique";s:7:"columns";a:1:{i:0;s:9:"workerkey";}s:6:"length";a:0:{}}s:14:"idx_pid_server";a:3:{s:4:"type";s:6:"unique";s:7:"columns";a:2:{i:0;s:3:"pid";i:1;s:6:"server";}s:6:"length";a:0:{}}}s:11:"*_options";a:2:{s:6:"engine";s:6:"InnoDB";s:9:"collation";s:15:"utf8_general_ci";}s:13:"*_temporary";b:0;}s:11:"queued_jobs";O:32:"Cake\Database\Schema\TableSchema":7:{s:9:"*_table";s:11:"queued_jobs";s:11:"*_columns";a:15:{s:2:"id";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;s:8:"unsigned";b:1;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:8:"job_type";a:9:{s:4:"type";s:6:"string";s:6:"length";i:45;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:18:"utf8mb4_unicode_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:4:"data";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:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:9:"job_group";a:9:{s:4:"type";s:6:"string";s:6:"length";i:255;s:4:"null";b:1;s:7:"default";N;s:7:"collate";s:18:"utf8mb4_unicode_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:9:"reference";a:9:{s:4:"type";s:6:"string";s:6:"length";i:255;s:4:"null";b:1;s:7:"default";N;s:7:"collate";s:18:"utf8mb4_unicode_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:9:"notbefore";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:6:"failed";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:15:"failure_message";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:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:9:"workerkey";a:9:{s:4:"type";s:6:"string";s:6:"length";i:45;s:4:"null";b:1;s:7:"default";N;s:7:"collate";s:18:"utf8mb4_unicode_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:6:"status";a:9:{s:4:"type";s:6:"string";s:6:"length";i:255;s:4:"null";b:1;s:7:"default";N;s:7:"collate";s:18:"utf8mb4_unicode_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:8:"priority";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:3;s:8:"unsigned";b:0;s:4:"null";b:0;s:7:"default";s:1:"5";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:13:"autoIncrement";N;}s:8:"progress";a:8:{s:4:"type";s:5:"float";s:6:"length";N;s:9:"precision";N;s:8:"unsigned";b:0;s:4:"null";b:1;s:7:"default";N;s:7:"comment";s:0:"";s:8:"baseType";N;}s:7:"fetched";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:9:"completed";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:7:"created";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:11:"*_typeMap";a:15:{s:2:"id";s:10:"biginteger";s:8:"job_type";s:6:"string";s:4:"data";s:4:"text";s:9:"job_group";s:6:"string";s:9:"reference";s:6:"string";s:9:"notbefore";s:8:"datetime";s:6:"failed";s:7:"integer";s:15:"failure_message";s:4:"text";s:9:"workerkey";s:6:"string";s:6:"status";s:6:"string";s:8:"priority";s:7:"integer";s:8:"progress";s:5:"float";s:7:"fetched";s:8:"datetime";s:9:"completed";s:8:"datetime";s:7:"created";s:8:"datetime";}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:15:"utf8_general_ci";}s:13:"*_temporary";b:0;}s:15:"remember_tokens";O:32:"Cake\Database\Schema\TableSchema":7:{s:9:"*_table";s:15:"remember_tokens";s:11:"*_columns";a:7:{s:2:"id";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;s:8:"unsigned";b:1;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:8:"selector";a:9:{s:4:"type";s:6:"string";s:6:"length";i:12;s:4:"null";b:1;s:7:"default";N;s:7:"collate";s:8:"utf8_bin";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:5:"token";a:9:{s:4:"type";s:6:"string";s:6:"length";i:191;s:4:"null";b:1;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:7:"user_id";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;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:7:"expires";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:8:"modified";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:7:"created";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:"*_typeMap";a:7:{s:2:"id";s:10:"biginteger";s:8:"selector";s:6:"string";s:5:"token";s:6:"string";s:7:"user_id";s:10:"biginteger";s:7:"expires";s:8:"datetime";s:8:"modified";s:8:"datetime";s:7:"created";s:8:"datetime";}s:11:"*_indexes";a:1:{s:10:"idx_userid";a:3:{s:4:"type";s:5:"index";s:7:"columns";a:1:{i:0;s:7:"user_id";}s:6:"length";a:0:{}}}s:15:"*_constraints";a:2:{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:12:"idx_selector";a:3:{s:4:"type";s:6:"unique";s:7:"columns";a:1:{i:0;s:8:"selector";}s:6:"length";a:0:{}}}s:11:"*_options";a:2:{s:6:"engine";s:6:"InnoDB";s:9:"collation";s:15:"utf8_general_ci";}s:13:"*_temporary";b:0;}s:15:"social_profiles";O:32:"Cake\Database\Schema\TableSchema":7:{s:9:"*_table";s:15:"social_profiles";s:11:"*_columns";a:13:{s:2:"id";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;s:8:"unsigned";b:1;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:7:"user_id";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;s:8:"unsigned";b:1;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:8:"provider";a:9:{s:4:"type";s:6:"string";s:6:"length";i:255;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:12:"access_token";a:7:{s:4:"type";s:6:"binary";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:10:"identifier";a:9:{s:4:"type";s:6:"string";s:6:"length";i:255;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:8:"username";a:9:{s:4:"type";s:6:"string";s:6:"length";i:255;s:4:"null";b:1;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:10:"first_name";a:9:{s:4:"type";s:6:"string";s:6:"length";i:255;s:4:"null";b:1;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:9:"last_name";a:9:{s:4:"type";s:6:"string";s:6:"length";i:255;s:4:"null";b:1;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:9:"full_name";a:9:{s:4:"type";s:6:"string";s:6:"length";i:255;s:4:"null";b:1;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:5:"email";a:9:{s:4:"type";s:6:"string";s:6:"length";i:255;s:4:"null";b:1;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:14:"email_verified";a:9:{s:4:"type";s:6:"string";s:6:"length";i:255;s:4:"null";b:1;s:7:"default";N;s:7:"collate";s:15:"utf8_general_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: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:8:"modified";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:"*_typeMap";a:13:{s:2:"id";s:10:"biginteger";s:7:"user_id";s:10:"biginteger";s:8:"provider";s:6:"string";s:12:"access_token";s:6:"binary";s:10:"identifier";s:6:"string";s:8:"username";s:6:"string";s:10:"first_name";s:6:"string";s:9:"last_name";s:6:"string";s:9:"full_name";s:6:"string";s:5:"email";s:6:"string";s:14:"email_verified";s:6:"string";s:7:"created";s:8:"datetime";s:8:"modified";s:8:"datetime";}s:11:"*_indexes";a:1:{s:10:"idx_userId";a:3:{s:4:"type";s:5:"index";s:7:"columns";a:1:{i:0;s:7:"user_id";}s:6:"length";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:15:"utf8_general_ci";}s:13:"*_temporary";b:0;}s:10:"statistics";O:32:"Cake\Database\Schema\TableSchema":7:{s:9:"*_table";s:10:"statistics";s:11:"*_columns";a:18:{s:2:"id";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;s:8:"unsigned";b:1;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:7:"link_id";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;s:8:"unsigned";b:1;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:7:"user_id";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;s:8:"unsigned";b:1;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:11:"referral_id";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;s:8:"unsigned";b:1;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:7:"ad_type";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:2;s:8:"unsigned";b:1;s:4:"null";b:0;s:7:"default";s:1:"1";s:7:"comment";s:28:"0=direct, 1=inter., 2=banner";s:8:"baseType";N;s:9:"precision";N;s:13:"autoIncrement";N;}s:11:"campaign_id";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;s:8:"unsigned";b:1;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:"campaign_user_id";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;s:8:"unsigned";b:1;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:"campaign_item_id";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;s:8:"unsigned";b:1;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:2:"ip";a:9:{s:4:"type";s:6:"string";s:6:"length";i:45;s:4:"null";b:0;s:7:"default";s:0:"";s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:7:"country";a:9:{s:4:"type";s:6:"string";s:6:"length";i:6;s:4:"null";b:0;s:7:"default";s:0:"";s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:10:"owner_earn";a:8:{s:4:"type";s:7:"decimal";s:6:"length";i:50;s:9:"precision";i:9;s:8:"unsigned";b:0;s:4:"null";b:0;s:7:"default";s:11:"0.000000000";s:7:"comment";s:0:"";s:8:"baseType";N;}s:14:"publisher_earn";a:8:{s:4:"type";s:7:"decimal";s:6:"length";i:50;s:9:"precision";i:9;s:8:"unsigned";b:0;s:4:"null";b:0;s:7:"default";N;s:7:"comment";s:0:"";s:8:"baseType";N;}s:13:"referral_earn";a:8:{s:4:"type";s:5:"float";s:6:"length";i:50;s:9:"precision";i:6;s:8:"unsigned";b:0;s:4:"null";b:0;s:7:"default";s:8:"0.000000";s:7:"comment";s:0:"";s:8:"baseType";N;}s:14:"referer_domain";a:9:{s:4:"type";s:6:"string";s:6:"length";i:256;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:7:"referer";a:9:{s:4:"type";s:6:"string";s:6:"length";i:256;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:10:"user_agent";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:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:6:"reason";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:10;s:8:"unsigned";b:1;s:4:"null";b:0;s:7:"default";s:1:"0";s:7:"comment";s:206:"1=Earn, 2=Disabled cookie, 3=Anonymous user, 4=Adblock, 5=Proxy, 6=IP changed, 7=Not unique, 8=Full weight, 9=Default campaign, 10=direct, 11=Invalid country, 12=Earnings disabled, 13=User disabled earnings";s:8:"baseType";N;s:9:"precision";N;s:13:"autoIncrement";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:19:"current_timestamp()";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}}s:11:"*_typeMap";a:18:{s:2:"id";s:10:"biginteger";s:7:"link_id";s:10:"biginteger";s:7:"user_id";s:10:"biginteger";s:11:"referral_id";s:10:"biginteger";s:7:"ad_type";s:7:"integer";s:11:"campaign_id";s:10:"biginteger";s:16:"campaign_user_id";s:10:"biginteger";s:16:"campaign_item_id";s:10:"biginteger";s:2:"ip";s:6:"string";s:7:"country";s:6:"string";s:10:"owner_earn";s:7:"decimal";s:14:"publisher_earn";s:7:"decimal";s:13:"referral_earn";s:5:"float";s:14:"referer_domain";s:6:"string";s:7:"referer";s:6:"string";s:10:"user_agent";s:4:"text";s:6:"reason";s:7:"integer";s:7:"created";s:9:"timestamp";}s:11:"*_indexes";a:5:{s:10:"idx_userid";a:3:{s:4:"type";s:5:"index";s:7:"columns";a:1:{i:0;s:7:"user_id";}s:6:"length";a:0:{}}s:6:"idx_ip";a:3:{s:4:"type";s:5:"index";s:7:"columns";a:1:{i:0;s:2:"ip";}s:6:"length";a:0:{}}s:21:"idx_campaignid_userid";a:3:{s:4:"type";s:5:"index";s:7:"columns";a:2:{i:0;s:11:"campaign_id";i:1;s:7:"user_id";}s:6:"length";a:0:{}}s:18:"idx_created_userid";a:3:{s:4:"type";s:5:"index";s:7:"columns";a:2:{i:0;s:7:"created";i:1;s:7:"user_id";}s:6:"length";a:0:{}}s:14:"idx_referralid";a:3:{s:4:"type";s:5:"index";s:7:"columns";a:1:{i:0;s:11:"referral_id";}s:6:"length";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:15:"utf8_general_ci";}s:13:"*_temporary";b:0;}s:12:"testimonials";O:32:"Cake\Database\Schema\TableSchema":7:{s:9:"*_table";s:12:"testimonials";s:11:"*_columns";a:8:{s:2:"id";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;s:8:"unsigned";b:1;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:4:"name";a:9:{s:4:"type";s:6:"string";s:6:"length";i:256;s:4:"null";b:0;s:7:"default";s:0:"";s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:8:"position";a:9:{s:4:"type";s:6:"string";s:6:"length";i:256;s:4:"null";b:0;s:7:"default";s:0:"";s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:5:"image";a:9:{s:4:"type";s:6:"string";s:6:"length";i:256;s:4:"null";b:0;s:7:"default";s:0:"";s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:9:"published";a:7:{s:4:"type";s:7:"boolean";s:6:"length";N;s:4:"null";b:1;s:7:"default";s:1:"0";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:7:"content";a:8:{s:4:"type";s:4:"text";s:6:"length";i:4294967295;s:4:"null";b:1;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:8:"modified";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:7:"created";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:"*_typeMap";a:8:{s:2:"id";s:10:"biginteger";s:4:"name";s:6:"string";s:8:"position";s:6:"string";s:5:"image";s:6:"string";s:9:"published";s:7:"boolean";s:7:"content";s:4:"text";s:8:"modified";s:8:"datetime";s:7:"created";s:8:"datetime";}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:15:"utf8_general_ci";}s:13:"*_temporary";b:0;}s:5:"users";O:32:"Cake\Database\Schema\TableSchema":7:{s:9:"*_table";s:5:"users";s:11:"*_columns";a:32:{s:2:"id";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;s:8:"unsigned";b:1;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:6:"status";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:2;s:8:"unsigned";b:1;s:4:"null";b:0;s:7:"default";s:1:"0";s:7:"comment";s:31:"1=active, 2=pending, 3=inactive";s:8:"baseType";N;s:9:"precision";N;s:13:"autoIncrement";N;}s:8:"username";a:9:{s:4:"type";s:6:"string";s:6:"length";i:150;s:4:"null";b:0;s:7:"default";s:0:"";s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:8:"password";a:9:{s:4:"type";s:6:"string";s:6:"length";i:255;s:4:"null";b:0;s:7:"default";s:0:"";s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:5:"email";a:9:{s:4:"type";s:6:"string";s:6:"length";i:254;s:4:"null";b:0;s:7:"default";s:0:"";s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:10:"temp_email";a:9:{s:4:"type";s:6:"string";s:6:"length";i:254;s:4:"null";b:0;s:7:"default";s:0:"";s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:16:"disable_earnings";a:7:{s:4:"type";s:7:"boolean";s:6:"length";N;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:4:"role";a:9:{s:4:"type";s:6:"string";s:6:"length";i:20;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:7:"plan_id";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;s:8:"unsigned";b:1;s:4:"null";b:0;s:7:"default";s:1:"1";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:13:"autoIncrement";N;}s:9:"api_token";a:9:{s:4:"type";s:6:"string";s:6:"length";i:40;s:4:"null";b:0;s:7:"default";s:0:"";s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:14:"activation_key";a:9:{s:4:"type";s:6:"string";s:6:"length";i:40;s:4:"null";b:0;s:7:"default";s:0:"";s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:12:"wallet_money";a:8:{s:4:"type";s:7:"decimal";s:6:"length";i:50;s:9:"precision";i:9;s:8:"unsigned";b:1;s:4:"null";b:0;s:7:"default";s:11:"0.000000000";s:7:"comment";s:0:"";s:8:"baseType";N;}s:18:"advertiser_balance";a:8:{s:4:"type";s:7:"decimal";s:6:"length";i:50;s:9:"precision";i:9;s:8:"unsigned";b:1;s:4:"null";b:0;s:7:"default";s:11:"0.000000000";s:7:"comment";s:0:"";s:8:"baseType";N;}s:18:"publisher_earnings";a:8:{s:4:"type";s:7:"decimal";s:6:"length";i:50;s:9:"precision";i:9;s:8:"unsigned";b:1;s:4:"null";b:0;s:7:"default";s:11:"0.000000000";s:7:"comment";s:0:"";s:8:"baseType";N;}s:17:"referral_earnings";a:8:{s:4:"type";s:7:"decimal";s:6:"length";i:50;s:9:"precision";i:9;s:8:"unsigned";b:1;s:4:"null";b:0;s:7:"default";s:11:"0.000000000";s:7:"comment";s:0:"";s:8:"baseType";N;}s:11:"referred_by";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;s:8:"unsigned";b:1;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:"first_name";a:9:{s:4:"type";s:6:"string";s:6:"length";i:256;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:9:"last_name";a:9:{s:4:"type";s:6:"string";s:6:"length";i:256;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:8:"address1";a:9:{s:4:"type";s:6:"string";s:6:"length";i:256;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:8:"address2";a:9:{s:4:"type";s:6:"string";s:6:"length";i:256;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:4:"city";a:9:{s:4:"type";s:6:"string";s:6:"length";i:256;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:5:"state";a:9:{s:4:"type";s:6:"string";s:6:"length";i:256;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:3:"zip";a:9:{s:4:"type";s:6:"string";s:6:"length";i:256;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:7:"country";a:9:{s:4:"type";s:6:"string";s:6:"length";i:256;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:12:"phone_number";a:9:{s:4:"type";s:6:"string";s:6:"length";i:256;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:17:"withdrawal_method";a:9:{s:4:"type";s:6:"string";s:6:"length";i:256;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:18:"withdrawal_account";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:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:10:"expiration";a:7:{s:4:"type";s:9:"timestamp";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:8:"login_ip";a:9:{s:4:"type";s:6:"string";s:6:"length";i:45;s:4:"null";b:1;s:7:"default";s:0:"";s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:11:"register_ip";a:9:{s:4:"type";s:6:"string";s:6:"length";i:45;s:4:"null";b:1;s:7:"default";s:0:"";s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:8:"modified";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:7:"created";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:"*_typeMap";a:32:{s:2:"id";s:10:"biginteger";s:6:"status";s:7:"integer";s:8:"username";s:6:"string";s:8:"password";s:6:"string";s:5:"email";s:6:"string";s:10:"temp_email";s:6:"string";s:16:"disable_earnings";s:7:"boolean";s:4:"role";s:6:"string";s:7:"plan_id";s:10:"biginteger";s:9:"api_token";s:6:"string";s:14:"activation_key";s:6:"string";s:12:"wallet_money";s:7:"decimal";s:18:"advertiser_balance";s:7:"decimal";s:18:"publisher_earnings";s:7:"decimal";s:17:"referral_earnings";s:7:"decimal";s:11:"referred_by";s:10:"biginteger";s:10:"first_name";s:6:"string";s:9:"last_name";s:6:"string";s:8:"address1";s:6:"string";s:8:"address2";s:6:"string";s:4:"city";s:6:"string";s:5:"state";s:6:"string";s:3:"zip";s:6:"string";s:7:"country";s:6:"string";s:12:"phone_number";s:6:"string";s:17:"withdrawal_method";s:6:"string";s:18:"withdrawal_account";s:4:"text";s:10:"expiration";s:9:"timestamp";s:8:"login_ip";s:6:"string";s:11:"register_ip";s:6:"string";s:8:"modified";s:8:"datetime";s:7:"created";s:8:"datetime";}s:11:"*_indexes";a:5:{s:14:"idx_referredby";a:3:{s:4:"type";s:5:"index";s:7:"columns";a:1:{i:0;s:11:"referred_by";}s:6:"length";a:0:{}}s:10:"idx_planid";a:3:{s:4:"type";s:5:"index";s:7:"columns";a:1:{i:0;s:7:"plan_id";}s:6:"length";a:0:{}}s:12:"idx_username";a:3:{s:4:"type";s:5:"index";s:7:"columns";a:1:{i:0;s:8:"username";}s:6:"length";a:0:{}}s:9:"idx_email";a:3:{s:4:"type";s:5:"index";s:7:"columns";a:1:{i:0;s:5:"email";}s:6:"length";a:0:{}}s:14:"idx_expiration";a:3:{s:4:"type";s:5:"index";s:7:"columns";a:1:{i:0;s:10:"expiration";}s:6:"length";a:0:{}}}s:15:"*_constraints";a:2:{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:12:"idx_apitoken";a:3:{s:4:"type";s:6:"unique";s:7:"columns";a:1:{i:0;s:9:"api_token";}s:6:"length";a:0:{}}}s:11:"*_options";a:2:{s:6:"engine";s:6:"InnoDB";s:9:"collation";s:15:"utf8_general_ci";}s:13:"*_temporary";b:0;}s:9:"withdraws";O:32:"Cake\Database\Schema\TableSchema":7:{s:9:"*_table";s:9:"withdraws";s:11:"*_columns";a:12:{s:2:"id";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;s:8:"unsigned";b:1;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:7:"user_id";a:9:{s:4:"type";s:10:"biginteger";s:6:"length";i:20;s:8:"unsigned";b:1;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:6:"status";a:9:{s:4:"type";s:7:"integer";s:6:"length";i:2;s:8:"unsigned";b:1;s:4:"null";b:0;s:7:"default";s:1:"0";s:7:"comment";s:58:"1=Approved, 2=Pending, 3=Complete, 4=Cancelled, 5=Returned";s:8:"baseType";N;s:9:"precision";N;s:13:"autoIncrement";N;}s:18:"publisher_earnings";a:8:{s:4:"type";s:5:"float";s:6:"length";i:50;s:9:"precision";i:6;s:8:"unsigned";b:1;s:4:"null";b:0;s:7:"default";s:8:"0.000000";s:7:"comment";s:0:"";s:8:"baseType";N;}s:17:"referral_earnings";a:8:{s:4:"type";s:5:"float";s:6:"length";i:50;s:9:"precision";i:6;s:8:"unsigned";b:1;s:4:"null";b:0;s:7:"default";s:8:"0.000000";s:7:"comment";s:0:"";s:8:"baseType";N;}s:6:"amount";a:8:{s:4:"type";s:5:"float";s:6:"length";i:50;s:9:"precision";i:6;s:8:"unsigned";b:1;s:4:"null";b:0;s:7:"default";s:8:"0.000000";s:7:"comment";s:0:"";s:8:"baseType";N;}s:9:"json_data";a:8:{s:4:"type";s:4:"text";s:6:"length";i:4294967295;s:4:"null";b:1;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:6:"method";a:9:{s:4:"type";s:6:"string";s:6:"length";i:256;s:4:"null";b:0;s:7:"default";s:0:"";s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:7:"account";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:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;}s:9:"user_note";a:9:{s:4:"type";s:6:"string";s:6:"length";i:191;s:4:"null";b:1;s:7:"default";N;s:7:"collate";s:15:"utf8_general_ci";s:7:"comment";s:0:"";s:8:"baseType";N;s:9:"precision";N;s:5:"fixed";N;}s:14:"transaction_id";a:9:{s:4:"type";s:6:"string";s:6:"length";i:256;s:4:"null";b:0;s:7:"default";N;s:7:"collate";s:15:"utf8_general_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: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:11:"*_typeMap";a:12:{s:2:"id";s:10:"biginteger";s:7:"user_id";s:10:"biginteger";s:6:"status";s:7:"integer";s:18:"publisher_earnings";s:5:"float";s:17:"referral_earnings";s:5:"float";s:6:"amount";s:5:"float";s:9:"json_data";s:4:"text";s:6:"method";s:6:"string";s:7:"account";s:4:"text";s:9:"user_note";s:6:"string";s:14:"transaction_id";s:6:"string";s:7:"created";s:8:"datetime";}s:11:"*_indexes";a:2:{s:17:"idx_status_userid";a:3:{s:4:"type";s:5:"index";s:7:"columns";a:2:{i:0;s:6:"status";i:1;s:7:"user_id";}s:6:"length";a:0:{}}s:18:"idx_created_userId";a:3:{s:4:"type";s:5:"index";s:7:"columns";a:2:{i:0;s:7:"created";i:1;s:7:"user_id";}s:6:"length";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:15:"utf8_general_ci";}s:13:"*_temporary";b:0;}}