--order 501907

ALTER TABLE TOUCHSCREENPAGE ADD ( APPLICATION NUMBER DEFAULT 1 NOT NULL 
                                    CONSTRAINT Application_valid 
                                      CHECK (APPLICATION IN (1,2)) );

COMMENT ON COLUMN TOUCHSCREENPAGE.APPLICATION IS '1 = Residential services incount + outcount (default)
2 = Soil count ';