--Order 20013993.90
/*
downgraded to Script_08.03.08.55.sql
---COMPORTCONFIGURATION table---

ALTER TABLE COMPORTCONFIGURATION
	ADD (SORTROWS NUMBER  DEFAULT 0 NOT NULL);

ALTER TABLE COMPORTCONFIGURATION
	ADD (SORTBOXESPERROW NUMBER  DEFAULT 0 NOT NULL);

ALTER TABLE COMPORTCONFIGURATION
	ADD (SORTDEVICENUMBER NUMBER(2)  DEFAULT 0 NOT NULL);

COMMENT ON COLUMN COMPORTCONFIGURATION.SORTROWS IS 'Number of rows in sorting cabinet.';

COMMENT ON COLUMN COMPORTCONFIGURATION.SORTBOXESPERROW IS 'Number of boxes in a row in a sorting cabinet.';

COMMENT ON COLUMN COMPORTCONFIGURATION.SORTDEVICENUMBER IS 'Device number';


---SERIALDEVICE table---

insert into serialdevice
  (serialdevice_id,
   brandtype,
   name,
   devicetype,
   baudrate,
   parity,
   databits,
   stopbits,
   endcharacter1)
values
  (seq_serialdevice.nextval,
   'PNTechnico',
   'Technico Pater Noster',
   'SRT',
   9600,
   'N',
   8,
   1,
   0);

commit;
*/