--Order 20012893.80

/* ALTER TABLE AUTOMATICFLAG
	ADD (FLAGTYPE NUMBER  DEFAULT 1 NOT NULL CONSTRAINT FlagType_valid1_1 CHECK (FLAGTYPE IN (1, 2, 3, 4)));

COMMENT ON COLUMN AUTOMATICFLAG.FLAGTYPE IS '1=Garment/wearer flags
2=OR-pack flags
3=Container flags
4=Residential/domestic
The flagtype corresponds with the FlagType from the Flag table. 2 and 3 are not (yet) used for automatic flags.';


insert into automaticflag
          (automaticflag_id,
           event,
           systemuser_id,
           timestamp,
           selectable,
           deletable,
           transferable,
           flagtype)
        values
          (22,
           'Rewashed',
           getminsystemuser(),
           sysdate,
           'Y',
           'Y',
           'Y',
            4);

commit; */
