ALTER TABLE ZH_REPOSITORY ADD NEW_STRUCTURE VARCHAR2(1) DEFAULT 'N' NOT NULL
/
ALTER TABLE ZH_REPOSITORY ADD WORDS_PATH VARCHAR2(300)
/
ALTER TABLE ZH_REPOSITORY ADD MESSAGES_FILE VARCHAR2(300)
/
ALTER TABLE ZH_REPOSITORY ADD MESSAGES_STRUCTURE VARCHAR2(300)
/
ALTER TABLE ZH_REPOSITORY ADD CONSTRAINT CHECK_NEW_STRUCTURE_VALUE CHECK ("NEW_STRUCTURE" IN ('Y', 'N') )
/ 