Eng 7201 add new ddl statements

These things need to get added back in and made sure they're working.  Looks like you lost them when merging with cwolff's changes.