--ABS-43025/ ABS-54593

---EPCSGTIN96PARTITION table---
CREATE TABLE EPCSGTIN96PARTITION
(
  PARTITIONVALUE      NUMBER NOT NULL,
  COMPANYPREFIXBITS   NUMBER NOT NULL,
  COMPANYPREFIXDIGITS NUMBER NOT NULL,
  ITEMREFERENCEBITS   NUMBER NOT NULL,
  ITEMREFERENCEDIGITS NUMBER NOT NULL
)
;

insert into EPCSGTIN96PARTITION (PARTITIONVALUE, COMPANYPREFIXBITS, COMPANYPREFIXDIGITS, ITEMREFERENCEBITS, ITEMREFERENCEDIGITS)
values (0, 40, 12, 4, 1);
commit;

insert into EPCSGTIN96PARTITION (PARTITIONVALUE, COMPANYPREFIXBITS, COMPANYPREFIXDIGITS, ITEMREFERENCEBITS, ITEMREFERENCEDIGITS)
values (1, 37, 11, 7, 2);
commit;

insert into EPCSGTIN96PARTITION (PARTITIONVALUE, COMPANYPREFIXBITS, COMPANYPREFIXDIGITS, ITEMREFERENCEBITS, ITEMREFERENCEDIGITS)
values (2, 34, 10, 10, 3);
commit;

insert into EPCSGTIN96PARTITION (PARTITIONVALUE, COMPANYPREFIXBITS, COMPANYPREFIXDIGITS, ITEMREFERENCEBITS, ITEMREFERENCEDIGITS)
values (3, 30, 9, 14, 4);
commit;

insert into EPCSGTIN96PARTITION (PARTITIONVALUE, COMPANYPREFIXBITS, COMPANYPREFIXDIGITS, ITEMREFERENCEBITS, ITEMREFERENCEDIGITS)
values (4, 27, 8, 17, 5);
commit;

insert into EPCSGTIN96PARTITION (PARTITIONVALUE, COMPANYPREFIXBITS, COMPANYPREFIXDIGITS, ITEMREFERENCEBITS, ITEMREFERENCEDIGITS)
values (5, 24, 7, 20, 6);
commit;

insert into EPCSGTIN96PARTITION (PARTITIONVALUE, COMPANYPREFIXBITS, COMPANYPREFIXDIGITS, ITEMREFERENCEBITS, ITEMREFERENCEDIGITS)
values (6, 20, 6, 24, 7);
commit;

ALTER TABLE EPCSGTIN96PARTITION READ ONLY;