--Order 20011530.50

ALTER TABLE USERGROUP
	ADD (SWITCHBOARDWEARERS NUMBER  DEFAULT 0 NOT NULL CONSTRAINT SwitchboardWearers_valid1 CHECK (SWITCHBOARDWEARERS IN (0, 1, 2)));



ALTER TABLE USERGROUP
	ADD (SWITCHBOARDCLIENTS NUMBER  DEFAULT 0 NOT NULL CONSTRAINT SwitchboardClients_valid1 CHECK (SWITCHBOARDCLIENTS IN (0, 1, 2)));



COMMENT ON COLUMN USERGROUP.DASHBOARD IS '0 = No access (default)

1 = Inquiry only

2 = Inquiry and modify
Note : Dashboard is the same as switchboard. This setting is used for the customers switchboard.';



COMMENT ON COLUMN USERGROUP.SWITCHBOARDWEARERS IS '0 = No access (default)
1 = Inquiry only
2 = Inquiry and modify
';



COMMENT ON COLUMN USERGROUP.SWITCHBOARDCLIENTS IS '0 = No access (default)
1 = Inquiry only
2 = Inquiry and modify';


update usergroup u set u.switchboardwearers = u.dashboard;
commit;


