Add sql and tca definition for added properties