--Updated by UAL (01/25/2019). Updated the X,Y and Z coordinates of ARA4 and ARA5

--Note: local* entries are no longer used as of PR#59 https://github.com/ara-software/AraRoot/pull/59 -- MSM (02/15/2024)

PRAGMA foreign_keys=OFF;

BEGIN TRANSACTION;

CREATE TABLE ARA(stationId integer primary key, stationName text, electronicsType text, stationEasting real, stationNorthing real, stationElevation real, local00 real, local01 real, local02 real, local10 real, local11 real, local12 real, local20 real, local21 real, local22 real);

INSERT INTO "ARA" VALUES(0,'TestBed','ICRR',5256.79,-164.84,-6.66,-0.598647,0.801013,-0.000402669,-0.801013,-0.598647,-0.000305758,-0.000485973,0.000139502,1.0);

INSERT INTO "ARA" VALUES(1,'ARA1Old','ICRR',4999.24,-864.22,-7.82,-0.5986468915,0.8010128758,-0.000333208,-0.801013,-0.598647,-0.000401329,-0.00052094,2.6495e-05,1.0);

INSERT INTO "ARA" VALUES(2,'ARA2','ATRI',4001.02,-2597.78,-5.71,-0.5986437007,0.8010086064,-0.000970503,-0.801013,-0.598647,-0.000401329,-0.00311277,-0.00111477,0.999994533955);

INSERT INTO "ARA" VALUES(3,'ARA3','ATRI',3001.78,-864.17,-3.87,-0.5986439636,0.8010089581,-0.00198193,-0.801013,-0.598647,-0.000401329,-0.00316902,0.000105871,0.999994973049);

INSERT INTO "ARA" VALUES(4,'ARA4','ATRI',3977.14,903.912,-7.33958,-0.5986439636,0.8010089581,-0.00198193,-0.801013,-0.598647,-0.000401329,-0.00316902,0.000105871,0.999994973049);

INSERT INTO "ARA" VALUES(5,'ARA5','ATRI',3042.04,-4321.13,-5.5626,-0.5986439636,0.8010089581,-0.00198193,-0.801013,-0.598647,-0.000401329,-0.00316902,0.000105871,0.999994973049);

INSERT INTO "ARA" VALUES(6,'ARA6','ATRI',3001.78,-864.17,-3.87,-0.5986439636,0.8010089581,-0.00198193,-0.801013,-0.598647,-0.000401329,-0.00316902,0.000105871,0.999994973049);

INSERT INTO "ARA" VALUES(100,'ARA1','ATRI',4999.24,-864.22,-7.82,-0.5986468915,0.8010128758,-0.000333208,-0.801013,-0.598647,-0.000401329,-0.00052094,2.6495e-05,1.0);

COMMIT;