-- ABS-6147

---PROCESS table---
INSERT INTO PROCESS(PROCESS_ID,DESCRIPTION,ACTIVE) VALUES (131,'Import Perl Stock Counts','Y');
commit;

---MOBILEDEVICE table---
ALTER TABLE MOBILEDEVICE
	ADD (IPADDRESS VARCHAR2(30) NULL);

---INTERNETORDER table---
ALTER TABLE INTERNETORDER ADD (PDAEXPORTSTATUS NUMBER DEFAULT 0 NOT NULL CONSTRAINT PDAEXPORTSTATUS_VALID1_1
                                               CHECK (PDAEXPORTSTATUS BETWEEN 0 AND 3),
                               MOBILEDEVICE_ID NUMBER NULL);

COMMENT ON COLUMN INTERNETORDER.PDAEXPORTSTATUS
  IS '0 = New
1 = Pending Request
2 = Expected
3 = Received.
';
COMMENT ON COLUMN INTERNETORDER.MOBILEDEVICE_ID
  IS 'Not a foreign key. Used in Perl Interface.';