1861254835
a:25:{s:2:"id";a:6:{s:4:"type";s:7:"integer";s:4:"null";b:0;s:7:"default";N;s:6:"length";i:11;s:8:"unsigned";b:0;s:3:"key";s:7:"primary";}s:4:"name";a:6:{s:4:"type";s:6:"string";s:4:"null";b:0;s:7:"default";N;s:6:"length";i:111;s:7:"collate";s:17:"latin1_swedish_ci";s:7:"charset";s:6:"latin1";}s:6:"cat_id";a:6:{s:4:"type";s:6:"string";s:4:"null";b:1;s:7:"default";N;s:6:"length";i:111;s:7:"collate";s:17:"latin1_swedish_ci";s:7:"charset";s:6:"latin1";}s:8:"cat_name";a:6:{s:4:"type";s:6:"string";s:4:"null";b:1;s:7:"default";N;s:6:"length";i:111;s:7:"collate";s:17:"latin1_swedish_ci";s:7:"charset";s:6:"latin1";}s:9:"subcat_id";a:6:{s:4:"type";s:6:"string";s:4:"null";b:1;s:7:"default";N;s:6:"length";i:111;s:7:"collate";s:17:"latin1_swedish_ci";s:7:"charset";s:6:"latin1";}s:11:"subcat_name";a:6:{s:4:"type";s:6:"string";s:4:"null";b:1;s:7:"default";N;s:6:"length";i:111;s:7:"collate";s:17:"latin1_swedish_ci";s:7:"charset";s:6:"latin1";}s:4:"unit";a:6:{s:4:"type";s:6:"string";s:4:"null";b:0;s:7:"default";N;s:6:"length";i:111;s:7:"collate";s:17:"latin1_swedish_ci";s:7:"charset";s:6:"latin1";}s:9:"unit_name";a:6:{s:4:"type";s:6:"string";s:4:"null";b:0;s:7:"default";N;s:6:"length";i:111;s:7:"collate";s:17:"latin1_swedish_ci";s:7:"charset";s:6:"latin1";}s:5:"brand";a:6:{s:4:"type";s:6:"string";s:4:"null";b:1;s:7:"default";N;s:6:"length";i:111;s:7:"collate";s:17:"latin1_swedish_ci";s:7:"charset";s:6:"latin1";}s:5:"price";a:5:{s:4:"type";s:5:"float";s:4:"null";b:0;s:7:"default";N;s:6:"length";N;s:8:"unsigned";b:0;}s:19:"consumption_unit_id";a:5:{s:4:"type";s:7:"integer";s:4:"null";b:1;s:7:"default";N;s:6:"length";i:11;s:8:"unsigned";b:0;}s:21:"consumption_unit_name";a:6:{s:4:"type";s:6:"string";s:4:"null";b:1;s:7:"default";N;s:6:"length";i:111;s:7:"collate";s:17:"latin1_swedish_ci";s:7:"charset";s:6:"latin1";}s:18:"consumption_factor";a:6:{s:4:"type";s:6:"string";s:4:"null";b:1;s:7:"default";N;s:6:"length";i:111;s:7:"collate";s:17:"latin1_swedish_ci";s:7:"charset";s:6:"latin1";}s:22:"consumption_unit_price";a:5:{s:4:"type";s:5:"float";s:4:"null";b:1;s:7:"default";N;s:6:"length";N;s:8:"unsigned";b:0;}s:3:"moq";a:6:{s:4:"type";s:6:"string";s:4:"null";b:0;s:7:"default";s:1:"0";s:6:"length";i:111;s:7:"collate";s:17:"latin1_swedish_ci";s:7:"charset";s:6:"latin1";}s:5:"stock";a:5:{s:4:"type";s:7:"integer";s:4:"null";b:0;s:7:"default";s:1:"0";s:6:"length";i:11;s:8:"unsigned";b:0;}s:5:"yield";a:6:{s:4:"type";s:6:"string";s:4:"null";b:0;s:7:"default";s:1:"1";s:6:"length";i:111;s:7:"collate";s:17:"latin1_swedish_ci";s:7:"charset";s:6:"latin1";}s:9:"food_cost";a:6:{s:4:"type";s:6:"string";s:4:"null";b:0;s:7:"default";s:1:"0";s:6:"length";i:111;s:7:"collate";s:17:"latin1_swedish_ci";s:7:"charset";s:6:"latin1";}s:7:"remarks";a:6:{s:4:"type";s:6:"string";s:4:"null";b:0;s:7:"default";N;s:6:"length";i:111;s:7:"collate";s:17:"latin1_swedish_ci";s:7:"charset";s:6:"latin1";}s:6:"status";a:5:{s:4:"type";s:7:"integer";s:4:"null";b:0;s:7:"default";s:1:"1";s:6:"length";i:11;s:8:"unsigned";b:0;}s:4:"sync";a:6:{s:4:"type";s:7:"integer";s:4:"null";b:0;s:7:"default";s:1:"0";s:6:"length";i:11;s:8:"unsigned";b:0;s:7:"comment";s:13:"local to live";}s:10:"local_sync";a:6:{s:4:"type";s:7:"integer";s:4:"null";b:0;s:7:"default";s:1:"0";s:6:"length";i:11;s:8:"unsigned";b:0;s:7:"comment";s:13:"live to local";}s:7:"created";a:4:{s:4:"type";s:9:"timestamp";s:4:"null";b:0;s:7:"default";N;s:6:"length";N;}s:8:"modified";a:4:{s:4:"type";s:9:"timestamp";s:4:"null";b:0;s:7:"default";N;s:6:"length";N;}s:20:"portion_weight_grams";a:6:{s:4:"type";s:7:"decimal";s:4:"null";b:1;s:7:"default";N;s:6:"length";s:4:"10,4";s:8:"unsigned";b:0;s:7:"comment";s:85:"Weight in grams per 1 portion/yield unit. Used for gram<->portion cross-unit costing.";}}
