---------Order 20011712.80---------

-------------------------UHFANTENNACONFIGURATION---------------------

CREATE SEQUENCE SEQ_UHFANTENNACONFIGURATION
START WITH 1
INCREMENT BY 1;

CREATE TABLE UHFANTENNACONFIGURATION
(
	UHFANTENNACONFIGURATION_ID NUMBER NOT NULL ,
	UHFREADERCONFIGURATION_ID NUMBER NOT NULL ,
	ANTENNANUMBER        NUMBER(1) NOT NULL  CONSTRAINT  AntennaNumber_valid1 CHECK (ANTENNANUMBER BETWEEN 1 AND 4),
	ACTIVE               VARCHAR2(1) DEFAULT  'Y'  NOT NULL  CONSTRAINT  YN_ValidationField51 CHECK (ACTIVE IN ('Y', 'N')),
	UHFANTENNAMODEL_ID   NUMBER NOT NULL ,
	TXPOWERACTUAL        NUMBER NOT NULL ,
	TXPOWERCALCULATED    NUMBER NOT NULL ,
	TXPOWERINDEX         NUMBER NOT NULL ,
	RXSENSITIVITY        NUMBER NOT NULL ,
	RXSENSITIVITYINDEX   NUMBER NOT NULL ,
	CABLELOSS            NUMBER NOT NULL ,
	SYSTEMUSER_ID        NUMBER NOT NULL ,
	TIMESTAMP            DATE NOT NULL 
)
TABLESPACE ABS_DATA;




COMMENT ON COLUMN UHFANTENNACONFIGURATION.ACTIVE IS 'Active means that the antenna is switched on.';



ALTER TABLE UHFANTENNACONFIGURATION
ADD CONSTRAINT  XPKUHFANTENNACONFIGURATION PRIMARY KEY (UHFANTENNACONFIGURATION_ID) USING INDEX TABLESPACE INDX;



CREATE UNIQUE INDEX XAK1UHFANTENNACONFIGURATION ON UHFANTENNACONFIGURATION
(UHFREADERCONFIGURATION_ID   ASC,ANTENNANUMBER   ASC) TABLESPACE INDX;



CREATE  INDEX XIF1UHFANTENNACONFIGURATION ON UHFANTENNACONFIGURATION
(UHFREADERCONFIGURATION_ID   ASC) TABLESPACE INDX;



CREATE  INDEX XIF2UHFANTENNACONFIGURATION ON UHFANTENNACONFIGURATION
(UHFANTENNAMODEL_ID   ASC) TABLESPACE INDX;


------------------------UHFANTENNAMODEL---------------------

CREATE SEQUENCE SEQ_UHFANTENNAMODEL
START WITH 1
INCREMENT BY 1;


CREATE TABLE UHFANTENNAMODEL
(
	UHFANTENNAMODEL_ID   NUMBER NOT NULL ,
	NAME                 VARCHAR2(60) NOT NULL ,
	GAIN                 NUMBER NOT NULL ,
	SYSTEMUSER_ID        NUMBER NOT NULL ,
	TIMESTAMP            DATE NOT NULL 
)
TABLESPACE ABS_DATA;



ALTER TABLE UHFANTENNAMODEL
ADD CONSTRAINT  XPKUHFANTENNAMODEL PRIMARY KEY (UHFANTENNAMODEL_ID) USING INDEX TABLESPACE INDX;



CREATE UNIQUE INDEX XAK1UHFANTENNAMODEL ON UHFANTENNAMODEL
(NAME   ASC) TABLESPACE INDX;




------------------------UHFREADERBRAND---------------------

CREATE SEQUENCE SEQ_UHFREADERBRAND
START WITH 1
INCREMENT BY 1;


CREATE TABLE UHFREADERBRAND
(
	UHFREADERBRAND_ID    NUMBER NOT NULL ,
	BRANDNUMBER          NUMBER NOT NULL ,
	NAME                 VARCHAR2(30) NOT NULL ,
	SYSTEMUSER_ID        NUMBER NOT NULL ,
	TIMESTAMP            DATE NOT NULL 
)
TABLESPACE ABS_DATA;




COMMENT ON COLUMN UHFREADERBRAND.BRANDNUMBER IS 'The IANA Private Enterprise Number (PEN)';


ALTER TABLE UHFREADERBRAND
ADD CONSTRAINT  XPKUHFREADERBRAND PRIMARY KEY (UHFREADERBRAND_ID) USING INDEX TABLESPACE INDX;



CREATE UNIQUE INDEX XAK1UHFREADERBRAND ON UHFREADERBRAND
(BRANDNUMBER   ASC) TABLESPACE INDX;



------------------------UHFREADERCONFIGURATION---------------------

CREATE SEQUENCE SEQ_UHFREADERCONFIGURATION
START WITH 1
INCREMENT BY 1;



CREATE TABLE UHFREADERCONFIGURATION
(
	UHFREADERCONFIGURATION_ID NUMBER NOT NULL ,
	PLANT_ID             NUMBER NOT NULL ,
	SINGLEMULTI          VARCHAR2(1) DEFAULT  'M'  NOT NULL  CONSTRAINT  SingleMulti_valid1 CHECK (SINGLEMULTI IN ('S', 'M')),
	IPADDRESS            VARCHAR2(40) NOT NULL ,
	PORTNUMBER           NUMBER DEFAULT  5084  NOT NULL ,
	DESCRIPTION          VARCHAR2(40) NOT NULL ,
	UHFREADERMODEL_ID    NUMBER NOT NULL ,
	UHFREGION_ID         NUMBER NOT NULL ,
	FREQAUTOSET          NUMBER DEFAULT  1  NOT NULL  CONSTRAINT  FreqAutoSet_valid1 CHECK (FREQAUTOSET IN (1, 2)),
	MAXNUMBERANTENNAS    NUMBER DEFAULT  4  NOT NULL ,
	READERMODE           NUMBER DEFAULT  0  NOT NULL  CONSTRAINT  ReaderMode_valid1 CHECK (READERMODE IN (0, 1, 2, 3, 4, 1000, 1001)),
	SEARCHMODE           NUMBER DEFAULT  0  NOT NULL  CONSTRAINT  SearchMode_valid1 CHECK (SEARCHMODE IN (0, 1, 2, 3)),
	SESSIONNUMBER        NUMBER DEFAULT  0  NOT NULL  CONSTRAINT  SessionNumber_valid1 CHECK (SESSIONNUMBER BETWEEN 0 AND 3),
	MINPOWER             NUMBER NOT NULL ,
	MAXPOWER             NUMBER NOT NULL ,
	INCREMENTPOWER       NUMBER NOT NULL ,
	SYSTEMUSER_ID        NUMBER NOT NULL ,
	TIMESTAMP            DATE NOT NULL 
)
TABLESPACE ABS_DATA;




COMMENT ON COLUMN UHFREADERCONFIGURATION.FREQAUTOSET IS '1 = Reader selects frequency
2 = Select from list';




COMMENT ON COLUMN UHFREADERCONFIGURATION.READERMODE IS '0 = Max throughput
1 = Hybrid
2 = Dense reader M=4
3 = Dense reader M=8
4 = MaxMiller
1000 = Auto set dense reader
1001 = Auto set single reader';




COMMENT ON COLUMN UHFREADERCONFIGURATION.SEARCHMODE IS '0 = Reader selects mode
1 = single target
2 = Dual target
3 = single target with suppression';



ALTER TABLE UHFREADERCONFIGURATION
ADD CONSTRAINT  XPKUHFREADERCONFIGURATION PRIMARY KEY (UHFREADERCONFIGURATION_ID) USING INDEX TABLESPACE INDX;


CREATE UNIQUE INDEX XAK1UHFREADERCONFIGURATION ON UHFREADERCONFIGURATION
(SINGLEMULTI   ASC,IPADDRESS   ASC) TABLESPACE INDX;



CREATE  INDEX XIF1UHFREADERCONFIGURATION ON UHFREADERCONFIGURATION
(PLANT_ID   ASC) TABLESPACE INDX;



CREATE  INDEX XIF2UHFREADERCONFIGURATION ON UHFREADERCONFIGURATION
(UHFREADERMODEL_ID   ASC) TABLESPACE INDX;



CREATE  INDEX XIF3UHFREADERCONFIGURATION ON UHFREADERCONFIGURATION
(UHFREGION_ID   ASC) TABLESPACE INDX;



------------------------UHFREADERFREQUENCY---------------------

CREATE SEQUENCE SEQ_UHFREADERFREQUENCY
START WITH 1
INCREMENT BY 1;


CREATE TABLE UHFREADERFREQUENCY
(
	UHFREADERFREQUENCY_ID NUMBER NOT NULL ,
	UHFREADERCONFIGURATION_ID NUMBER NOT NULL ,
	CHANNELINDEX         NUMBER NOT NULL  CONSTRAINT  ChannelIndex_valid1 CHECK (CHANNELINDEX >= 0),
	HOPTABLEID           NUMBER NOT NULL ,
	FREQUENCY            NUMBER NOT NULL ,
	ACTIVE               VARCHAR2(1) DEFAULT  'Y'  NOT NULL  CONSTRAINT  YN_ValidationField50 CHECK (ACTIVE IN ('Y', 'N')),
	SYSTEMUSER_ID        NUMBER NOT NULL ,
	TIMESTAMP            DATE NOT NULL 
)
TABLESPACE ABS_DATA;




COMMENT ON COLUMN UHFREADERFREQUENCY.HOPTABLEID IS 'A hoptable is a table in the reader that contains frequencies. A reader can have multiple hoptables.';


ALTER TABLE UHFREADERFREQUENCY
ADD CONSTRAINT  XPKUHFREADERFREQUENCY PRIMARY KEY (UHFREADERFREQUENCY_ID) USING INDEX TABLESPACE INDX;


CREATE INDEX XIF1UHFREADERFREQUENCY ON UHFREADERFREQUENCY
(UHFREADERCONFIGURATION_ID   ASC) TABLESPACE INDX;


CREATE UNIQUE INDEX XAK1UHFREADERFREQUENCY ON UHFREADERFREQUENCY
(UHFREADERCONFIGURATION_ID   ASC,HOPTABLEID   ASC,FREQUENCY   ASC) TABLESPACE INDX;



------------------------UHFREADERMODEL---------------------

CREATE SEQUENCE SEQ_UHFREADERMODEL
START WITH 1
INCREMENT BY 1;


CREATE TABLE UHFREADERMODEL
(
	UHFREADERMODEL_ID    NUMBER NOT NULL ,
	UHFREADERBRAND_ID    NUMBER NOT NULL ,
	MODELNUMBER          NUMBER NOT NULL ,
	NAME                 VARCHAR2(30) NOT NULL ,
	MAXSENSITIVITY       NUMBER NOT NULL ,
	SYSTEMUSER_ID        NUMBER NOT NULL ,
	TIMESTAMP            DATE NOT NULL 
)
TABLESPACE ABS_DATA;




COMMENT ON COLUMN UHFREADERMODEL.MODELNUMBER IS 'Internal model number as defined by the manufacturer';


ALTER TABLE UHFREADERMODEL
ADD CONSTRAINT  XPKUHFREADERMODEL PRIMARY KEY (UHFREADERMODEL_ID) USING INDEX TABLESPACE INDX;


CREATE UNIQUE INDEX XAK1UHFREADERMODEL ON UHFREADERMODEL
(UHFREADERBRAND_ID   ASC,MODELNUMBER   ASC) TABLESPACE INDX;



CREATE  INDEX XIF1UHFREADERMODEL ON UHFREADERMODEL
(UHFREADERBRAND_ID   ASC) TABLESPACE INDX;



------------------------UHFREGION---------------------

CREATE SEQUENCE SEQ_UHFREGION
START WITH 1
INCREMENT BY 1;


CREATE TABLE UHFREGION
(
	UHFREGION_ID         NUMBER NOT NULL ,
	NAME                 VARCHAR2(30) NOT NULL ,
	MAXPOWER             NUMBER NOT NULL ,
	SYSTEMUSER_ID        NUMBER NOT NULL ,
	TIMESTAMP            DATE NOT NULL 
)
TABLESPACE ABS_DATA;


ALTER TABLE UHFREGION
ADD CONSTRAINT  XPKUHFREGION PRIMARY KEY (UHFREGION_ID) USING INDEX TABLESPACE INDX;


CREATE UNIQUE INDEX XAK1UHFREGION ON UHFREGION
(NAME   ASC) TABLESPACE INDX;


------------------------UHFTAGFILTER---------------------

CREATE SEQUENCE SEQ_UHFTAGFILTER
START WITH 1
INCREMENT BY 1;


CREATE TABLE UHFTAGFILTER
(
	UHFTAGFILTER_ID      NUMBER NOT NULL ,
	SCANPREFIXFILTER     VARCHAR2(16) NOT NULL CONSTRAINT ScanPrefixFilter_valid1  CHECK (TO_NUMBER(SCANPREFIXFILTER,'XXXXXXXXXXXXXXXX') >= 0),
	REPLACEPREFIX        VARCHAR2(16) NULL CONSTRAINT ReplacePrefix_valid1  CHECK (TO_NUMBER(REPLACEPREFIX,'XXXXXXXXXXXXXXXX') >= 0),
	REPLACEWITH          VARCHAR2(16) NULL CONSTRAINT ReplaceWith_valid1  CHECK (TO_NUMBER(REPLACEWITH,'XXXXXXXXXXXXXXXX') >= 0),
	SYSTEMUSER_ID        NUMBER NOT NULL ,
	TIMESTAMP            DATE NOT NULL 
)
TABLESPACE ABS_DATA;


ALTER TABLE UHFTAGFILTER
ADD CONSTRAINT  XPKUHFTAGFILTER PRIMARY KEY (UHFTAGFILTER_ID) USING INDEX TABLESPACE INDX;


CREATE UNIQUE INDEX XAK1UHFTAGFILTER ON UHFTAGFILTER
(SCANPREFIXFILTER   ASC) TABLESPACE INDX;


------------------------WORKSTATIONUHFREADER---------------------

CREATE SEQUENCE SEQ_WORKSTATIONUHFREADER
START WITH 1
INCREMENT BY 1;


CREATE TABLE WORKSTATIONUHFREADER
(
	WORKSTATIONUHFREADER_ID NUMBER NOT NULL ,
	UHFREADERCONFIGURATION_ID NUMBER NOT NULL ,
	WORKSTATION_ID       NUMBER NOT NULL ,
	SEQUENCENUMBER       NUMBER NOT NULL  CONSTRAINT  SequenceNumber_valid1 CHECK (SEQUENCENUMBER BETWEEN 0 AND 2),
	USEFILTER            VARCHAR2(1) DEFAULT  'Y'  NOT NULL  CONSTRAINT  YN_ValidationField52 CHECK (USEFILTER IN ('Y', 'N')),
	SYSTEMUSER_ID        NUMBER NOT NULL ,
	TIMESTAMP            DATE NOT NULL 
)
TABLESPACE ABS_DATA;




COMMENT ON COLUMN WORKSTATIONUHFREADER.USEFILTER IS 'Filter should not be used for single reader configuration. Using the filter means that the tags are filtered out and are not passed to the client application. So the user does not see that they are scanned.';



ALTER TABLE WORKSTATIONUHFREADER
ADD CONSTRAINT  XPKWORKSTATIONUHFREADER PRIMARY KEY (WORKSTATIONUHFREADER_ID) USING INDEX TABLESPACE INDX;



CREATE UNIQUE INDEX XAK1WORKSTATIONUHFREADER ON WORKSTATIONUHFREADER
(WORKSTATION_ID   ASC,SEQUENCENUMBER   ASC) TABLESPACE INDX;





---------------------BUILDING FK CONSTRAINTS-------------------

ALTER TABLE UHFANTENNACONFIGURATION
ADD CONSTRAINT UHFANTENNACONFIG_UHFREADERCONF FOREIGN KEY (UHFREADERCONFIGURATION_ID) REFERENCES UHFREADERCONFIGURATION (UHFREADERCONFIGURATION_ID) ON DELETE CASCADE;



ALTER TABLE UHFANTENNACONFIGURATION
ADD CONSTRAINT UHFANTENNACONFIG_UHFANTENNAMOD FOREIGN KEY (UHFANTENNAMODEL_ID) REFERENCES UHFANTENNAMODEL (UHFANTENNAMODEL_ID);



ALTER TABLE UHFREADERCONFIGURATION
ADD CONSTRAINT UHFREADERCONFIGURATION_PLANT FOREIGN KEY (PLANT_ID) REFERENCES PLANT (PLANT_ID);



ALTER TABLE UHFREADERCONFIGURATION
ADD CONSTRAINT UHFREADERCONFIG_UHFREADERMODEL FOREIGN KEY (UHFREADERMODEL_ID) REFERENCES UHFREADERMODEL (UHFREADERMODEL_ID);



ALTER TABLE UHFREADERCONFIGURATION
ADD CONSTRAINT UHFREADERCONFIG_UHFREGION FOREIGN KEY (UHFREGION_ID) REFERENCES UHFREGION (UHFREGION_ID);



ALTER TABLE UHFREADERFREQUENCY
ADD CONSTRAINT UHFREADERFREQ_UHFREADERCONFIG FOREIGN KEY (UHFREADERCONFIGURATION_ID) REFERENCES UHFREADERCONFIGURATION (UHFREADERCONFIGURATION_ID) ON DELETE CASCADE;



ALTER TABLE UHFREADERMODEL
ADD CONSTRAINT UHFREADERMODEL_UHFREADERBRAND FOREIGN KEY (UHFREADERBRAND_ID) REFERENCES UHFREADERBRAND (UHFREADERBRAND_ID);




ALTER TABLE WORKSTATIONUHFREADER
ADD CONSTRAINT WORKSTATIONUHFR_UHFREADERCONFI FOREIGN KEY (UHFREADERCONFIGURATION_ID) REFERENCES UHFREADERCONFIGURATION (UHFREADERCONFIGURATION_ID);



ALTER TABLE WORKSTATIONUHFREADER
ADD CONSTRAINT WORKSTATIONUHFR_WORKSTATION FOREIGN KEY (WORKSTATION_ID) REFERENCES WORKSTATION (WORKSTATION_ID) ON DELETE CASCADE;



-----------------------insert records----------------------

insert into UHFREADERBRAND (UHFREADERBRAND_ID, BRANDNUMBER, NAME, SYSTEMUSER_ID, TIMESTAMP)
values (1, 25882, 'Impinj', 1, to_date('01-01-2011', 'dd-mm-yyyy'));
commit;

insert into UHFREADERMODEL (UHFREADERMODEL_ID, MODELNUMBER, NAME, UHFREADERBRAND_ID, MAXSENSITIVITY, SYSTEMUSER_ID, TIMESTAMP)
values (1, 1000000, 'R1000', 1, -80, 1, to_date('01-01-2011', 'dd-mm-yyyy'));
commit;
insert into UHFREADERMODEL (UHFREADERMODEL_ID, MODELNUMBER, NAME, UHFREADERBRAND_ID, MAXSENSITIVITY, SYSTEMUSER_ID, TIMESTAMP)
values (2, 1005000, 'R1005', 1, -80, 1, to_date('01-01-2011', 'dd-mm-yyyy'));
commit;
insert into UHFREADERMODEL (UHFREADERMODEL_ID, MODELNUMBER, NAME, UHFREADERBRAND_ID, MAXSENSITIVITY, SYSTEMUSER_ID, TIMESTAMP)
values (3, 2001001, 'R220', 1, -80, 1, to_date('01-01-2011', 'dd-mm-yyyy'));
commit;
insert into UHFREADERMODEL (UHFREADERMODEL_ID, MODELNUMBER, NAME, UHFREADERBRAND_ID, MAXSENSITIVITY, SYSTEMUSER_ID, TIMESTAMP)
values (4, 2001002, 'R420', 1, -80, 1, to_date('01-01-2011', 'dd-mm-yyyy'));
commit;
insert into UHFREADERMODEL (UHFREADERMODEL_ID, MODELNUMBER, NAME, UHFREADERBRAND_ID, MAXSENSITIVITY, SYSTEMUSER_ID, TIMESTAMP)
values (5, 2001003, 'R640', 1, -80, 1, to_date('01-01-2011', 'dd-mm-yyyy'));
commit;

insert into UHFREGION (UHFREGION_ID, NAME, MAXPOWER, SYSTEMUSER_ID, TIMESTAMP)
values (0, ' Unspecified', 32.5, 1, to_date('01-01-2011', 'dd-mm-yyyy'));
commit;
insert into UHFREGION (UHFREGION_ID, NAME, MAXPOWER, SYSTEMUSER_ID, TIMESTAMP)
values (1, 'US_FCC_Part_15', 32.5, 1, to_date('01-01-2011', 'dd-mm-yyyy'));
commit;
insert into UHFREGION (UHFREGION_ID, NAME, MAXPOWER, SYSTEMUSER_ID, TIMESTAMP)
values (2, 'ETSI_302_208', 30, 1, to_date('01-01-2011', 'dd-mm-yyyy'));
commit;
insert into UHFREGION (UHFREGION_ID, NAME, MAXPOWER, SYSTEMUSER_ID, TIMESTAMP)
values (3, 'ETSI_300_220', 32.5, 1, to_date('01-01-2011', 'dd-mm-yyyy'));
commit;
insert into UHFREGION (UHFREGION_ID, NAME, MAXPOWER, SYSTEMUSER_ID, TIMESTAMP)
values (4, 'Australia_LIPD_1W', 32.5, 1, to_date('01-01-2011', 'dd-mm-yyyy'));
commit;
insert into UHFREGION (UHFREGION_ID, NAME, MAXPOWER, SYSTEMUSER_ID, TIMESTAMP)
values (5, 'Australia_LIPD_4W', 32.5, 1, to_date('01-01-2011', 'dd-mm-yyyy'));
commit;
insert into UHFREGION (UHFREGION_ID, NAME, MAXPOWER, SYSTEMUSER_ID, TIMESTAMP)
values (6, 'Japan_ARIB_STD_T89', 10, 1, to_date('01-01-2011', 'dd-mm-yyyy'));
commit;
insert into UHFREGION (UHFREGION_ID, NAME, MAXPOWER, SYSTEMUSER_ID, TIMESTAMP)
values (7, 'Hong_Kong_OFTA_1049', 32.5, 1, to_date('01-01-2011', 'dd-mm-yyyy'));
commit;
insert into UHFREGION (UHFREGION_ID, NAME, MAXPOWER, SYSTEMUSER_ID, TIMESTAMP)
values (8, 'Taiwan_DGT_LP0002', 32.5, 1, to_date('01-01-2011', 'dd-mm-yyyy'));
commit;
insert into UHFREGION (UHFREGION_ID, NAME, MAXPOWER, SYSTEMUSER_ID, TIMESTAMP)
values (9, 'Korea_MIC_Article_5_2', 32.5, 1, to_date('01-01-2011', 'dd-mm-yyyy'));
commit;

insert into UHFANTENNAMODEL (UHFANTENNAMODEL_ID, NAME, SYSTEMUSER_ID, TIMESTAMP, GAIN)
values (1, 'Laird Technologies S9028PC L/R', 1, to_date('01-01-2011', 'dd-mm-yyyy'), 6);
commit;
insert into UHFANTENNAMODEL (UHFANTENNAMODEL_ID, NAME, SYSTEMUSER_ID, TIMESTAMP, GAIN)
values (2, 'Laird Technologies S8658PC L/R ', 1, to_date('01-01-2011', 'dd-mm-yyyy'), 3.85);
commit;
insert into UHFANTENNAMODEL (UHFANTENNAMODEL_ID, NAME, SYSTEMUSER_ID, TIMESTAMP, GAIN)
values (3, 'Impinj IPJ-A0301-USA (Mini-Guardrail)', 1, to_date('01-01-2011', 'dd-mm-yyyy'), 15);
commit;
insert into UHFANTENNAMODEL (UHFANTENNAMODEL_ID, NAME, SYSTEMUSER_ID, TIMESTAMP, GAIN)
values (4, 'Impinj IPJ-A0310-USA (Threshold-T Antenna) ', 1, to_date('01-01-2011', 'dd-mm-yyyy'), 6);
commit;
insert into UHFANTENNAMODEL (UHFANTENNAMODEL_ID, NAME, SYSTEMUSER_ID, TIMESTAMP, GAIN)
values (5, 'Impinj  IPJ-A0400-USA, CSL CS-777-2 (Brickyard', 1, to_date('01-01-2011', 'dd-mm-yyyy'), 2);
commit;
insert into UHFANTENNAMODEL (UHFANTENNAMODEL_ID, NAME, SYSTEMUSER_ID, TIMESTAMP, GAIN)
values (6, 'Impinj  IPJ-A0400-EU1, CSL CS-777-1 (Brickyard) ', 1, to_date('01-01-2011', 'dd-mm-yyyy'), 0);
commit;
insert into UHFANTENNAMODEL (UHFANTENNAMODEL_ID, NAME, SYSTEMUSER_ID, TIMESTAMP, GAIN)
values (7, 'Impinj  IPJ-A0401-USA or IPJ-A0402-USA (both Guardwall)', 1, to_date('01-01-2011', 'dd-mm-yyyy'), 6);
commit;
insert into UHFANTENNAMODEL (UHFANTENNAMODEL_ID, NAME, SYSTEMUSER_ID, TIMESTAMP, GAIN)
values (8, 'MA/COM MAAN-000246-FL1 integrated RFID floor-mounted stand', 1, to_date('01-01-2011', 'dd-mm-yyyy'), 6);
commit;
insert into UHFANTENNAMODEL (UHFANTENNAMODEL_ID, NAME, SYSTEMUSER_ID, TIMESTAMP, GAIN)
values (9, 'MA/COM MAAN-000246-WL1 integrated RFID wall-mounted stand', 1, to_date('01-01-2011', 'dd-mm-yyyy'), 6);
commit;
insert into UHFANTENNAMODEL (UHFANTENNAMODEL_ID, NAME, SYSTEMUSER_ID, TIMESTAMP, GAIN)
values (10, 'MTI MT-262006/TLH  or MT-262006/TRH', 1, to_date('01-01-2011', 'dd-mm-yyyy'), 6);
commit;
insert into UHFANTENNAMODEL (UHFANTENNAMODEL_ID, NAME, SYSTEMUSER_ID, TIMESTAMP, GAIN)
values (11, 'MTI MT-262013/NLH or MT-262013/NRH', 1, to_date('01-01-2011', 'dd-mm-yyyy'), 4.5);
commit;
insert into UHFANTENNAMODEL (UHFANTENNAMODEL_ID, NAME, SYSTEMUSER_ID, TIMESTAMP, GAIN)
values (12, 'MTI MT-262013/TLH or MT-262013/TRH', 1, to_date('01-01-2011', 'dd-mm-yyyy'), 4.5);
commit;
insert into UHFANTENNAMODEL (UHFANTENNAMODEL_ID, NAME, SYSTEMUSER_ID, TIMESTAMP, GAIN)
values (13, 'MTI MT-242032/NLH or MT-242032/NRH', 1, to_date('01-01-2011', 'dd-mm-yyyy'), 1.85);
commit;
insert into UHFANTENNAMODEL (UHFANTENNAMODEL_ID, NAME, SYSTEMUSER_ID, TIMESTAMP, GAIN)
values (14, 'Sensormatic Electronics Corp.  IDANT20CNA25 with 25 ft cable', 1, to_date('01-01-2011', 'dd-mm-yyyy'), 5.5);
commit;
insert into UHFANTENNAMODEL (UHFANTENNAMODEL_ID, NAME, SYSTEMUSER_ID, TIMESTAMP, GAIN)
values (15, 'Sensormatic Electronics Corp.  IDANT10CNA25 with 25 ft cable', 1, to_date('01-01-2011', 'dd-mm-yyyy'), 3.5);
commit;
insert into UHFANTENNAMODEL (UHFANTENNAMODEL_ID, NAME, SYSTEMUSER_ID, TIMESTAMP, GAIN)
values (16, 'Sensormatic Electronics Corp.  IDANT10CNA25 with 6 ft cable', 1, to_date('01-01-2011', 'dd-mm-yyyy'), 5.4);
commit;
insert into UHFANTENNAMODEL (UHFANTENNAMODEL_ID, NAME, SYSTEMUSER_ID, TIMESTAMP, GAIN)
values (17, 'Sensormatic Electronics Corp.  IDANT10CEU25 with 6 ft cable', 1, to_date('01-01-2011', 'dd-mm-yyyy'), 3.25);
commit;
