adding prop_info DDL and DML statements