-- ABS-60037/ ABS-60044

ALTER TABLE WORKSTATION ADD (OPERATINGSYSTEM VARCHAR2(50) NULL,
                             OSARCHITECTURE NUMBER DEFAULT 0 NOT NULL CONSTRAINT OSARCHITECTURE_VALID1_1
                                            CHECK (OSARCHITECTURE IN (0, 1, 2)),
                             MAXMEMORY NUMBER NULL);

COMMENT ON COLUMN WORKSTATION.OSARCHITECTURE
  IS '0 = Unknown / Not determined
1 = 32 bit
2 = 64 bit
';

COMMENT ON COLUMN WORKSTATION.MAXMEMORY
  IS 'Memory in Mb allocated for java';