
DROP TABLE QUEST.SM_MACHINE_IDS;

#SYNC 10;

CREATE TABLE QUEST.SM_MACHINE_IDS
 (MACHINE_NAME  VARCHAR(255)    NOT NULL,
  MACHINE_OS    SMALLINT        NOT NULL,
  MACHINE_ID    INTEGER         NOT NULL
 )
  DATA CAPTURE NONE
  IN USERSPACE1;

#SYNC 20;
ALTER TABLE QUEST.SM_MACHINE_IDS
  ADD CONSTRAINT SQL010119134331520 UNIQUE
   (MACHINE_NAME,
    MACHINE_OS
   );
   
#SYNC 30;

ALTER TABLE QUEST.SM_MACHINE_IDS
  LOCKSIZE ROW
  APPEND OFF
  NOT VOLATILE;
  
#SYNC 40;

COMMENT ON TABLE QUEST.SM_MACHINE_IDS
  IS 'SMUDB REPO V01.01A';

#SYNC 50;

  INSERT INTO QUEST.SM_MACHINE_IDS 
  		 VALUES('xxxxxxx', 0, 1);

#SYNC 60;

