-- order 20010804

ALTER TABLE SORTBATCH
	ADD (COLOR VARCHAR2(6),
	     SORTBATCHDEFINITION_ID NUMBER  DEFAULT 0 NOT NULL);


ALTER TABLE SORTBATCHDEFINITION
	ADD (COLOR VARCHAR2(6));



ALTER TABLE SORTBATCHCONTENTS
	ADD (WEARER_ID NUMBER  DEFAULT 0 NOT NULL,
             POSITION NUMBER  DEFAULT 0 NOT NULL);

COMMENT ON COLUMN SORTBATCHCONTENTS.POSITION IS 'Used in module SORTINGSUPPORT to show the position';


ALTER TABLE SERIALDEVICE
	MODIFY ALIBIPRINTER DEFAULT 'N';


ALTER TABLE SERIALDEVICE
	MODIFY ACCURACYLEVELWEIGHT DEFAULT 0;

insert into serialdevice
  (serialdevice_id,
   brandtype,
   name,
   devicetype,
   baudrate,
   parity,
   databits,
   stopbits,
   endcharacter1)
values
  (seq_serialdevice.nextval,
   'Positek',
   'CA Sort for garments',
   'SRT',
   9600,
   'N',
   8,
   1,
   0);

drop sequence seq_soundconfiguration;

create sequence seq_soundconfiguration
start with 20
increment by 1;