SQLite format 3@   kE ]-TPSGR3 NONEGR-3Integrated, model GR-3,p/n: 01-050901-04?YJ?bM?˅Q?=b?|ǿRn/?*6C- ))QUNKNOWNUnknownUnknown antenna that is not used in calculations. SS*!MM=tabletblAntennaModelstblAntennaModelsCREATE TABLE tblAntennaModels ( keyAntennaModel INTEGER PRIMARY KEY DEFAULT 0, RinexName TEXT(50) NOT NULL DEFAULT '0', ShortDescription TEXT(50), Description TEXT(255), R REAL NOT NULL DEFAULT 0, CL1 REAL NOT NULL DEFAULT 0, AL1 REAL NOT NULL DEFAULT 0, CL2 REAL NOT NULL DEFAULT 0, AL2 REAL NOT NULL DEFAULT 0, E REAL NOT NULL DEFAULT 0, N REAL NOT NULL DEFAULT 0 ) ef ( keyCodeAttrDef INTEGER PRIMARY KEY AUTOINCREMENT, nameAttr TEXT(50) NOT NULL DEFAULT '0', fkeyCode INTEGER NOT NULL DEFAULT 0 REFERENCES tblCodeDefs(keyCodeDef) ON DELETE CASCADE ON UPDATE CASCADE, typeOfVal INTEGER NOT NULL DEFAULT 0, defVal TEXT(80), minVal TEXT(80), maxVal TEXT(80), CanBe0 INTEGER NOT NULL DEFAULT 0, MaxLength INTEGER NOT NULL DEFAULT 0, MaxLenOfFract INTEGER NOT NULL DEFAULT 0, MenuOrderType INTEGER NOT NULL DEFAULT 0 ) ggx!EEitabletblCodeAttrDeftblCodeAttrDefCREATE TABLE tblCodeAttrD!II%tablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)v!]]5tabletblCodeAttrMenuListstblCodeAttrMenuListsCREATE TABLE tblCodeAttrMenuLists ( CreationOrdNum INTEGER PRIMARY KEY AUTOINCREMENT, fkeyAttrDef INTEGER NOT NULL DEFAULT 0 REFERENCES tblCodeAttrDef(keyCodeAttrDef) ON DELETE CASCADE ON UPDATE CASCADE, MenuItem TEXT(255) NOT NULL DEFAULT '0' ) ~lP* ~( UtblIdenticalPoints AtblCrdGnssRaw" ItblObsEquipment =tblCrdBaseStAtblCrdRawMeas $MtblCrdObsSession9tblSoPoints9tblStations9tblCodeDefs1tblLayers9tblDatasets&QtblVersionHistory   \!EE1tabletblCodeAttrValtblCodeAttrVal CREATE TABLE tblCodeAttrVal ( fkeyCodesToPoints INTEGER NOT NULL DEFAULT 0 REFERENCES tblCodesToPts(keyCodesToPoints) ON DELETE CASCADE ON UPDATE CASCADE, fkeyAttrDef INTEGER NOT NULL DEFAULT 0 REFERENCES tblCodeAttrDef(keyCodeAttrDef) ON UPDATE CASCADE, fkeyPoint INTEGER NOT NULL DEFAULT 0 REFERENCES tblSoPoints(keySoPoint) ON UPDATE CASCADE, textValue TEXT(255) ) - E{|HiddenCode|} !99tabletblCodeDefstblCodeDefs CREATE TABLE tblCodeDefs ( keyCodeDef INTEGER PRIMARY KEY AUTOINCREMENT, nameCode TEXT(50) NOT NULL DEFAULT 0, LineColor INTEGER, LineStyleIndex INTEGER, LineWidth INTEGER, MarkColor INTEGER, MarkStyleIndex INTEGER, fkeyLayer INTEGER REFERENCES tblLayers(keyLayers) ON UPDATE CASCADE, DescName TEXT(255) )2!AAetabletblCodesToPtstblCodesToPts CREATE TABLE tblC odesToPts ( keyCodesToPoints INTEGER PRIMARY KEY AUTOINCREMENT, fkeyPoint INTEGER NOT NULL DEFAULT 0 REFERENCES tblSoPoints(keySoPoint) ON DELETE CASCADE ON UPDATE CASCADE, fkeyCodeDef INTEGER NOT NULL DEFAULT 0 REFERENCES tblCodeDefs(keyCodeDef) ON UPDATE CASCADE, CodeString TEXT(16), fkeyCtrlCode1 INTEGER REFERENCES tblCtrlCodesLib(keyCtrlCode) ON UPDATE CASCADE, fkeyCtrlCode2 INTEGER REFERENCES tblCtrlCodesLib(keyCtrlCode) ON UPDATE CASCADE ) F<!Base4@I= @3UC @vVl!<!Base3@I?[v6vm@3_ÅG@x^5?|<!Base2@I?r@3^s4@wB<!Base1@I:JyPL@3]>@wDO;dlAntennaModels(keyAntennaModel) ON UPDATE CASCADE, AntennaSlant INTEGER, fkeySoPoint INTEGER REFERENCES tblSoPoints(keySoPoint) ON UPDATE CASCADE, BaseNumId INTEGER, dLatOffset REAL NOT NULL DEFAULT 0, dLonOffset REAL NOT NULL DEFAULT 0, dHtOffset REAL NOT NULL DEFAULT 0, fkeyGnssRawForKP INTEGER REFERENCES tblCrdGnssRaw(keyCrdGnssRaw), fkeyKnownPoint INTEGER REFERENCES tblSoPoints(keySoPoint) ON UPDATE CASCADE, UseRelativeAntCal INTEGER NOT NULL DEFAULT 0 ) ??6!==utabletblCrdBaseSttblCrdBaseStCREATE TABLE tblCrdBaseSt ( keyCrdBaseSt INTEGER PRIMARY KEY AUTOINCREMENT, Name TEXT(50), Lat REAL, Lon REAL, Hgt REAL, AntHgt REAL, fkeyCrdRawMeas INTEGER NOT NULL DEFAULT 0 REFERENCES tblCrdRawMeas(keyCrdRawMeas) ON UPDATE CASCADE, fkeyAntennaModel INTEGER REFERENCES tb  J !QQutabletblCrdBgImageDatatblCrdBgImageDataCREATE TABLE tblCrdBgImageData ( keyImage INTEGER PRIMARY KEY AUTOINCREMENT, ImageFileName TEXT(255) NOT NULL DEFAULT '0', fkeyLayer INTEGER NOT NULL DEFAULT 0 REFERENCES tblLayers(keyLayers) ON DELETE CASCADE ON UPDATE CASCADE ) ww=C0Localization? 3y||lA=xzHA+5fffvx'@3]h'X@I:K=a'@vx'A=xzHA+5fffAL NOT NULL DEFAULT 0, Q REAL NOT NULL DEFAULT 0, Ce REAL NOT NULL DEFAULT 0, Cn REAL NOT NULL DEFAULT 0, Ah REAL NOT NULL DEFAULT 0, Bh REAL NOT NULL DEFAULT 0, Ch REAL NOT NULL DEFAULT 0, L0 REAL NOT NULL DEFAULT 0, B0 REAL NOT NULL DEFAULT 0, H0 REAL NOT NULL DEFAULT 0, Ox REAL NOT NULL DEFAULT 0, Oy REAL NOT NULL DEFAULT 0, Oh REAL NOT NULL DEFAULT 0, Placement INTEGER NOT NULL DEFAULT 0, isConsistent INTEGER NOT NULL DEFAULT 0 )  !UU]tabletblCrdCalibrationstblCrdCalibrationsCREATE TABLE tblCrdCalibrations ( keyCalibration INTEGER PRIMARY KEY DEFAULT 0, Id TEXT(8) NOT NULL DEFAULT '0', Name TEXT(50) NOT NULL DEFAULT '0', Type INTEGER NOT NULL DEFAULT 0, P RE  aa !MM!tabletblCrdDLevelRunstblCrdDLevelRunsCREATE TABLE tblCrdDLevelRuns ( fkeyCrdDlOccStart INTEGER PRIMARY KEY DEFAULT 0 REFERENCES tblCrdDlOccs(fkeyCrdRawMeas), Name TEXT(50) NOT NULL DEFAULT '0', fkeyCrdDlOccFinish INTEGER NOT NULL DEFAULT 0 REFERENCES tblCrdDlOccs(fkeyCrdRawMeas), Description TEXT(100) )  ~ !==tabletblCrdDlOccstblCrdDlOccsCREATE TABLE tblCrdDlOccs ( fkeyCrdRawMeas INTEGER PRIMARY KEY DEFAULT 0 REFERENCES tblCrdRawMeas(keyCrdRawMeas) ON DELETE CASCADE ON UPDATE CASCADE, SumOfBs REAL NOT NULL DEFAULT 0, SumOfFs REAL NOT NULL DEFAULT 0, fkeyCrdLevelRun INTEGER REFERENCES tblCrdDLevelRuns(fkeyCrdDlOccStart) ON DELETE CASCADE ON UPDATE CASCADE )  CASCADE, fkeyStation INTEGER NOT NULL DEFAULT 0 REFERENCES tblStations(keyStation) ON UPDATE CASCADE, TopWire REAL NOT NULL DEFAULT 0, MidWire REAL NOT NULL DEFAULT 0, BtmWire REAL NOT NULL DEFAULT 0, Distance REAL NOT NULL DEFAULT 0, NumOfMeas INTEGER NOT NULL DEFAULT 0, MeasMode INTEGER NOT NULL DEFAULT 0, ShotType INTEGER NOT NULL DEFAULT 0, VOffset REAL NOT NULL DEFAULT 0, Flags INTEGER NOT NULL DEFAULT 0, MeasType INTEGER NOT NULL DEFAULT 0 ) Z !AA5tabletblCrdDlShotstblCrdDlShotsCREATE TABLE tblCrdDlShots ( fkeyCrdRawMeas INTEGER PRIMARY KEY DEFAULT 0 REFERENCES tblCrdRawMeas(keyCrdRawMeas) ON DELETE CASCADE ON UPDATE CASCADE, fkeyDlOcc INTEGER NOT NULL DEFAULT 0 REFERENCES tblCrdDlOccs(fkeyCrdRawMeas) ON DELETE CASCADE ON UPDATE  mm!QQtabletblCrdFindStaInfotblCrdFindStaInfoCREATE TABLE tblCrdFindStaInfo ( keyFindStaMeas INTEGER PRIMARY KEY AUTOINCREMENT, fkeyAlignment INTEGER NOT NULL DEFAULT 0 REFERENCES tblLineAlntRoads(keyAlignment) ON DELETE CASCADE ON UPDATE CASCADE, fkeySoPoint INTEGER NOT NULL DEFAULT 0 REFERENCES tblSoPoints(keySoPoint), Chainage REAL NOT NULL DEFAULT 0, Offset REAL NOT NULL DEFAULT 0, CutFill REAL NOT NULL DEFAULT 0 ) ON UPDATE CASCADE, fkeyStationOrg INTEGER NOT NULL DEFAULT 0 REFERENCES tblStations(keyStation) ON UPDATE CASCADE, Azimuth REAL NOT NULL DEFAULT 0, VAngle REAL NOT NULL DEFAULT 0, Distance REAL NOT NULL DEFAULT 0, Slope INTEGER NOT NULL DEFAULT 0, fkeyAzPt INTEGER REFERENCES tblSoPoints(keySoPoint) ON UPDATE CASCADE, RepresentationType INTEGER NOT NULL DEFAULT 0, fkeyCrdRawMeas INTEGER NOT NULL DEFAULT 0 REFERENCES tblCrdRawMeas(keyCrdRawMeas) ON UPDATE CASCADE ) ??)8!MMYtabletblCrdGnssOffsettblCrdGnssOffset CREATE TABLE tblCrdGnssOffset ( fkeyStation INTEGER PRIMARY KEY DEFAULT 0 REFERENCES tblStations(keyStation) !!YY tabletblCrdGnssPtlOffsettblCrdGnssPtlOffset#CREATE TABLE tblCrdGnssPtlOffset $H!AAtabletblCrdGnssRawtblCrdGnssRaw%CREATE TABLE tblCrdGnssRaw ( keyCrdGnssRaw INTEGER PRIMARY KE&  ( fkeyStation INTEGER PRIMARY KEY DEFAULT 0 REFERENCES tblStations(keyStation) ON UPDATE CASCADE, fkeyStation1 INTEGER NOT NULL DEFAULT 0 REFERENCES tblStations(keyStation) ON UPDATE CASCADE, fkeyStation2 INTEGER NOT NULL DEFAULT 0 REFERENCES tblStations(keyStation) ON UPDATE CASCADE, CrdAlong REAL NOT NULL DEFAULT 0, CrdAcross REAL NOT NULL DEFAULT 0, CrdHgt REAL, fkeyCrdRawMeas INTEGER NOT NULL DEFAULT 0 REFERENCES tblCrdRawMeas(keyCrdRawMeas) ON UPDATE CASCADE ) f"Dfm>s?7?XbM?+H?7<@?3fķx@),> ?@@@m)C@&87n y?XbM?# 6 ?t] ?!RO / ?5?=m>Q> Z%:O'?XbM?f#@?ؠv ?$%f )#?%?@m?O?BLn Z?XbM?+}T?F @?*C" % ?E?Q m?[d]?YQG]?XbM?&,e ?n?$tm_ %,?(J? m >mf2? [? Ȃ$?XbM?7/1Z?…~`@?-m< Y ? ?\~'Y AUTOINCREMENT, fkeyRoverStation INTEGER NOT NULL DEFAULT 0 REFERENCES tblStations(keyStation) ON UPDATE CASCADE, fKeyBaseStation INTEGER REFERENCES tblCrdBaseSt(keyCrdBaseSt) ON UPDATE CASCADE, DLat REAL NOT NULL DEFAULT 0, DLon REAL NOT NULL DEFAULT 0, DHgt REAL NOT NULL DEFAULT 0, fkeyAntennaModel INTEGER NOT NULL DEFAULT 0 REFERENCES tblAntennaModels(keyAntennaModel) ON UPDATE CASCADE, TargetAntHeight REAL NOT NULL DEFAULT 0, AntennaSlant INTEGER NOT NULL DEFAULT 0, xx REAL NOT NULL DEFAULT 0, yy REAL NOT NULL DEFAULT 0, zz REAL NOT NULL DEFAULT 0, xy INTEGER NOT NULL DEFAULT 0, xz INTEGER NOT NULL DEFAULT 0, yz INTEGER NOT NULL DEFAULT 0, SolutionType INTEGER NOT NULL DEFAULT 0, ObsDuration INTEGER, fkeyCrdRawMeas INTEGER NOT NULL DEFAULT 0 REFERENCES tblCrdRawMeas(keyCrdRawMeas) ON UPDATE CASCADE, NumOfEpochs INTEGER, HDop REAL, VDop REAL, NumOfGpsSats INTEGER, NumOfGlonassSats INTEGER )  ##Z!QQtabletblCrdImageCameratblCrdImageCamera(CREATE TABLE tblCrdImageCamera ( keyCamera INTEGER PRIMARY KEY AUTOINCREMENT, ViewOffsetXInM REAL NOT NULL DEFAULT 0, ViewOffsetYInM REAL NOT NULL DEFAULT 0, ViewOffsetZInM REAL NOT NULL DEFAULT 0, ViewRotYtoZInDeg REAL NOT NULL DEFAULT 0, ViewRotZtoXInDeg REAL NOT NULL DEFAULT 0, ViewRotXtoYInDeg REAL NOT NULL DEFAULT 0, fkeyPhotoCamera INTEGER REFERENCES tblPhotoCamera(keyCamera) ON UPDATE CASCADE )  ++R!IItabletblCrdImageDatatblCrdImageData*CREATE TABLE tblCrdImageData ( keyImage INTEGER PRIMARY KEY AUTOINCREMENT, fkeyShot INTEGER NOT NULL DEFAULT 0 REFERENCES tblTsShots(keyTsShot) ON DELETE CASCADE ON UPDATE CASCADE, ImageFileName TEXT(255) NOT NULL DEFAULT '0', Dx INTEGER NOT NULL DEFAULT 0, Dy INTEGER NOT NULL DEFAULT 0, ImageType INTEGER NOT NULL DEFAULT 0, fkeyCameraInfo INTEGER REFERENCES tblCrdImageCamera(keyCamera) ON UPDATE CASCADE )  Iy Ird Ic% Iy Iu Iu Ird Ij7 f!MM5tabletblCrdObsSessiontblCrdObsSession,CREATE TABLE tblCrdObsSession ( keyObsSession INTEGER PRIMARY KEY AUTOINCREMENT, StartSecondsFrom1970 REAL NOT NULL DEFAULT 0, EndSecondsFrom1970 REAL, fkeyObsEquipment INTEGER REFERENCES tblObsEquipment(keyObsEquipment) ON UPDATE CASCADE )  ee!11QtabletblCrdPtltblCrdPtl.CREATE TABLE tblCrdPtl ( fkeyStation INTEGER PRIMARY KEY DEFAULT 0 REFERENCES tblStations(keyStation) ON DELETE CASCADE ON UPDATE CASCADE, fkeyP1 INTEGER NOT NULL DEFAULT 0 REFERENCES tblSoPoints(keySoPoint) ON UPDATE CASCADE, fkeyP2 INTEGER NOT NULL DEFAULT 0 REFERENCES tblSoPoints(keySoPoint) ON UPDATE CASCADE, CrdAlong REAL NOT NULL DEFAULT 0, CrdAcross REAL NOT NULL DEFAULT 0, CrdHgt REAL ) VxgV Iy IuIrdIj7IfIehIyIuIrdIc% 6!AAmtabletblCrdRawMeastblCrdRawMeas0CREATE TABLE tblCrdRawMeas ( keyCrdRawMeas INTEGER PRIMARY KEY AUTOINCREMENT, MeasType INTEGER NOT NULL DEFAULT 0, MeasExtraType INTEGER NOT NULL DEFAULT 0, SecondsFrom1970 REAL NOT NULL DEFAULT 0, TimeSystem INTEGER NOT NULL DEFAULT 0, fkeyObsSession INTEGER REFERENCES tblCrdObsSession(keyObsSession) ON DELETE CASCADE ON UPDATE CASCADE )  Z!II%tabletblCtrlCodesLibtblCtrlCodesLib2CREATE TABLE tblCtrlCodesLib ( keyCtrlCode INTEGER PRIMARY KEY AUTOINCREMENT, CtrlCode TEXT(20) NOT NULL DEFAULT '0' )   !vWGS84WGS84 World Geodetic Sys. 1984 WGS84 0 0 0 0 0 0 0 0    !99)tabletblDatasetstblDatasets4CREATE TABLE tblDatasets ( keyDataset INTEGER PRIMARY KEY AUTOINCREMENT, CsType INTEGER NOT NULL DEFAULT 0, DatumId TEXT(50), ProjectionId TEXT(50), UseGeoid INTEGER NOT NULL DEFAULT 0, DatumData BLOB, ProjectionData BLOB, IsUserDatum INTEGER NOT NULL DEFAULT 0, IsUserProjection INTEGER NOT NULL DEFAULT 0 )  "!MM-tabletblExternalNotestblExternalNotes6CREATE TABLE tblExternalNotes ( keyExternalNote INTEGER PRIMARY KEY AUTOINCREMENT, Format INTEGER NOT NULL DEFAULT 0, SecondsFrom1970 REAL NOT NULL DEFAULT 0, FileName TEXT(255), ShortNotes TEXT(255) ) 3K3V)10691069LOK@3U¦@I= 6u@vY'AGA+N> =q^%1pp0168PP0168LOK@3_ۑ^(@I?ZН@wxAFhQA+X0(^%1pp1091PP1091LOK@3^-C@I?H@vABoRA+VE(Y)33573357LOK@3^1@I:B,@vx'A? =A+7?u\ X)14561456LOK@3]h'X@I:K=a'@w'T'A=xzHA+5fff T(80), FromC1 REAL NOT NULL DEFAULT 0, FromC2 REAL NOT NULL DEFAULT 0, FromC3 REAL NOT NULL DEFAULT 0, ToC1 REAL NOT NULL DEFAULT 0, ToC2 REAL NOT NULL DEFAULT 0, ToC3 REAL NOT NULL DEFAULT 0, useH INTEGER NOT NULL DEFAULT 0, useV INTEGER NOT NULL DEFAULT 0, Rx REAL, Ry REAL, Rz REAL, fkeyLocalStation INTEGER REFERENCES tblStations(keyStation) ON UPDATE CASCADE, fkeyWgsStation INTEGER REFERENCES tblStations(keyStation) ON UPDATE CASCADE ) ..T!UUtabletblIdenticalPointstblIdenticalPoints8CREATE TABLE tblIdenticalPoints ( keyIp INTEGER PRIMARY KEY AUTOINCREMENT, fkeyCalibration INTEGER NOT NULL DEFAULT 0 REFERENCES tblCrdCalibrations(keyCalibration) ON DELETE CASCADE ON UPDATE CASCADE, LocalName TEXT(80), WgsName TEX9p!EEYtabletblJobPrimOptstblJobPrimOpts;CREATE TABLE tblJobPrimOpts ( FieldId INTEGER PRIMARY KEY DEFAULT -1, FieldType INTEGER NOT NULL DEFAULT 0, binaryValue BLOB ) apR$,F B     0POREBALOK F ?      WGS84      >lxDA  0 ~!11tabletblLayerstblLayersCREATE TABLE tblLineAlntHals ( keyHal INTEGER PRIMARY KEY AUTOINCREMENT, Name TEXT(40) NOT NULL DEFAULT '0', fkeyCrdDataset INTEGER REFERENCES tblDatasets(keyDataset), StartPosCrd1 REAL, StartPosCrd2 REAL, fkeySoPoint INTEGER REFERENCES tblSoPoints(keySoPoint), IniStation REAL NOT NULL DEFAULT 0 ) EFERENCES tblLineAlntHals(keyHal) ON DELETE CASCADE ON UPDATE CASCADE, OrderingNumber REAL NOT NULL DEFAULT 0, IpPosCrd1 REAL NOT NULL DEFAULT 0, IpPosCrd2 REAL NOT NULL DEFAULT 0, fkeyCrdDataset INTEGER NOT NULL DEFAULT 0 REFERENCES tblDatasets(keyDataset), SpiralL1 REAL NOT NULL DEFAULT 0, Radius REAL NOT NULL DEFAULT 0, SpiralL2 REAL NOT NULL DEFAULT 0, RepresentationType INTEGER NOT NULL DEFAULT 0, fkeySoPoint INTEGER REFERENCES tblSoPoints(keySoPoint) ) ..V!UUtabletblLineAlntHElmIpstblLineAlntHElmIps@CREATE TABLE tblLineAlntHElmIps ( keyAlntIp INTEGER PRIMARY KEY AUTOINCREMENT, fkeyHal INTEGER NOT NULL DEFAULT 0 RAf!MM5tabletblLineAlntHElmstblLineAlntHElmsCCREATE TABLED  tblLineAlntHElms ( keyAlntHe INTEGER PRIMARY KEY AUTOINCREMENT, fkeyHal INTEGER NOT NULL DEFAULT 0 REFERENCES tblLineAlntHals(keyHal) ON DELETE CASCADE ON UPDATE CASCADE, OrderingNumber REAL NOT NULL DEFAULT 0, TurnAngleOrAzimut REAL NOT NULL DEFAULT 0, TurnAngleIsAzimut INTEGER NOT NULL DEFAULT 0, HLength REAL NOT NULL DEFAULT 0, StartCurvature REAL NOT NULL DEFAULT 0, EndCurvature REAL NOT NULL DEFAULT 0, RepresentationType INTEGER NOT NULL DEFAULT 0 )  qq !MMtabletblLineAlntRoadstblLineAlntRoadsECREATE TABLE tblLineAlntRoads ( keyAlignment INTEGER PRIMARY KEY AUTOINCREMENT, Name TEXT(40) NOT NULL DEFAULT '0', IniStation REAL, StationingInterval REAL, fkeyHal INTEGER REFERENCES tblLineAlntHals(keyHal), fkeyVal INTEGER REFERENCES tblLineAlntVals(keyVal), fkeyXsSf INTEGER REFERENCES tblLineAlntXsSf(keyXsSf), fkeyLayer INTEGER REFERENCES tblLayers(keyLayers) )  [["!!II5tabletblLineAlntValstblLineAlntValsGCREATE TABLE tblLineAlntVals ( keyVal INTEGER PRIMARY KEY AUTOINCREMENT, Name TEXT(40) NOT NULL DEFAULT '0', fkeyCrdDataset INTEGER REFERENCES tblDatasets(keyDataset), StartElevation REAL, fkeySoPoint INTEGER REFERENCES tblSoPoints(keySoPoint), IniStation REAL )  ))T"!UUtabletblLineAlntVElmLSstblLineAlntVElmLSsICREATE TABLE tblLineAlntVElmLSs ( keyAlntVeLs INTEGER PRIMARY KEY AUTOINCREMENT, fkeyVal INTEGER NOT NULL DEFAULT 0 REFERENCES tblLineAlntVals(keyVal) ON DELETE CASCADE ON UPDATE CASCADE, OrderingNumber REAL NOT NULL DEFAULT 0, Stationing REAL NOT NULL DEFAULT 0, HLength REAL NOT NULL DEFAULT 0, Height REAL NOT NULL DEFAULT 0, ArcRadius REAL NOT NULL DEFAULT 0, LsType INTEGER NOT NULL DEFAULT 0 ) E tblLineAlntVElms ( keyAlntVe INTEGER PRIMARY KEY AUTOINCREMENT, fkeyVal INTEGER NOT NULL DEFAULT 0 REFERENCES tblLineAlntVals(keyVal) ON DELETE CASCADE ON UPDATE CASCADE, OrderingNumber REAL NOT NULL DEFAULT 0, HLength REAL NOT NULL DEFAULT 0, StartGrade REAL NOT NULL DEFAULT 0, FinalGrade REAL NOT NULL DEFAULT 0, RepresentationType INTEGER NOT NULL DEFAULT 0, ArcRadius REAL NOT NULL DEFAULT 0 ) EEd#!MM1tabletblLineAlntVElmstblLineAlntVElmsKCREATE TABLLJ$!IItabletblLineAlntXsSftblLineAlntXsSfNCREATE TABLE tblLineAlntXsSf ( keyXsSf INTEGER PRIMARY KEY AUTOINCREMENT, Name TEXT(40) NOT NULL DEFAULT '0' )   t%!uutabletblLineAlntXsSfToTemplatestblLineAlntXsSfToTemplatesOCREATE TABLE tblLineAlntXsSfToTemplates ( keyXTplToAlnt INTEGER PRIMARY KEY AUTOINCREMENT, fkeyXsSf INTEGER NOT NULL DEFAULT 0 REFERENCES tblLineAlntXsSf(keyXsSf) ON DELETE CASCADE ON UPDATE CASCADE, Chainage REAL NOT NULL DEFAULT 0, IsRight INTEGER NOT NULL DEFAULT 0, fkeyXTplate INTEGER NOT NULL DEFAULT 0 REFERENCES tblXSectTplates(keyRdTplate) )  "&!MM-tabletblLinePlotAttrstblLinePlotAttrsQCREATE TABLE tblLinePlotAttrs ( fkeyLine INTEGER PRIMARY KEY DEFAULT 0 REFERENCES tblLineProps(fkeyPtList) ON DELETE CASCADE ON UPDATE CASCADE, LineColor INTEGER, LineStyleIndex INTEGER, LineWidth INTEGER )  %%X'!==9tabletblLinePropstblLinePropsSCREATE TABLE tblLineProps ( fkeyPtList INTEGER PRIMARY KEY DEFAULT 0 REFERENCES tblSetOfPoints(keySetOfPoints) ON DELETE CASCADE ON UPDATE CASCADE, fkeyCodeDef INTEGER NOT NULL DEFAULT 0 REFERENCES tblCodeDefs(keyCodeDef) ON UPDATE CASCADE, CodeString TEXT(16) NOT NULL DEFAULT '0', fkeyLayer INTEGER REFERENCES tblLayers(keyLayers) ON UPDATE CASCADE, isClosed INTEGER NOT NULL DEFAULT 0, Flags INTEGER NOT NULL DEFAULT 0 ) TABLE tblMissingLineMeas ( keyMissingLineMeas INTEGER PRIMARY KEY AUTOINCREMENT, fkeyFirstPt INTEGER NOT NULL DEFAULT 0 REFERENCES tblSoPoints(keySoPoint) ON UPDATE CASCADE, fkeySecondPt INTEGER NOT NULL DEFAULT 0 REFERENCES tblSoPoints(keySoPoint) ON UPDATE CASCADE, dHD REAL NOT NULL DEFAULT 0, dVD REAL NOT NULL DEFAULT 0, dSD REAL NOT NULL DEFAULT 0, fkeyCrdRawMeas INTEGER NOT NULL DEFAULT 0 REFERENCES tblCrdRawMeas(keyCrdRawMeas) ON UPDATE CASCADE ) uJ(!UUmtabletblMissingLineMeastblMissingLineMeasUCREATE V)!IItabletblObsEquipmenttblObsEquipmentXCREATE TABLE tblObsEquipment ( keyObsEquipment INTEGER PRIMARY KEY AUTOINCREMENT, TextId TEXT(128), ObsType INTEGER NOT NULL DEFAULT 0 ) 9P8ID27O1GXS9P8ID27O1GXS9P8ID27O1GXS9P8ID27O1GXS  z*!EEmtabletblPhotoCameratblPhotoCameraYCREATE TABLE tblPhotoCamera ( keyCamera INTEGER PRIMARY KEY AUTOINCREMENT, CameraDescription TEXT(255) NOT NULL DEFAULT '0', FocalLength REAL NOT NULL DEFAULT 0, PrincipalPointX REAL NOT NULL DEFAULT 0, PrincipalPointY REAL NOT NULL DEFAULT 0, ResolutionX REAL NOT NULL DEFAULT 0, ResolutionY REAL NOT NULL DEFAULT 0, DistortionModel INTEGER NOT NULL DEFAULT 0 )  T+!]]qtabletblPhotoCameraParamstblPhotoCameraParams[CREATE TABLE tblPhotoCameraParams ( fkeyCamera INTEGER NOT NULL DEFAULT 0 REFERENCES tblPhotoCamera(keyCamera) ON DELETE CASCADE ON UPDATE CASCADE, ParameterId INTEGER NOT NULL DEFAULT 0, ParameterValue REAL NOT NULL DEFAULT 0 )   ,!]] tabletblPhotoCamOriPointstblPhotoCamOriPoints]CREATE TABLE tblPhotoCamOriPoints ( fkeyPhotoImage INTEGER NOT NULL DEFAULT 0 REFERENCES tblPhotoImage(keyImage) ON DELETE CASCADE ON UPDATE CASCADE, fkeySoPoint INTEGER NOT NULL DEFAULT 0 REFERENCES tblSoPoints(keySoPoint) ON DELETE CASCADE ON UPDATE CASCADE, ImageX REAL NOT NULL DEFAULT 0, ImageY REAL NOT NULL DEFAULT 0 )  >-!AA}tabletblPhotoImagetblPhotoImage_CREATE TABLE tblPhotoImage ( keyImage INTEGER PRIMARY KEY AUTOINCREMENT, fkeyCamera INTEGER NOT NULL DEFAULT 0 REFERENCES tblPhotoCamera(keyCamera) ON DELETE CASCADE ON UPDATE CASCADE, ImageFileName TEXT(255) NOT NULL DEFAULT '0' )  v.!II]tabletblPhotoPolygontblPhotoPolygonaCREATE TABLE tblPhotoPolygon ( keyPhotoPolygon INTEGER PRIMARY KEY AUTOINCREMENT, fkeyPhotoImage INTEGER NOT NULL DEFAULT 0 REFERENCES tblPhotoImage(keyImage) ON DELETE CASCADE ON UPDATE CASCADE )  ss /!IItabletblPhotoPolyPtstblPhotoPolyPtscCREATE TABLE tblPhotoPolyPts ( fkeyPhotoPolygon INTEGER NOT NULL DEFAULT 0 REFERENCES tblPhotoPolygon(keyPhotoPolygon) ON DELETE CASCADE ON UPDATE CASCADE, OrderingNumber REAL NOT NULL DEFAULT 0, ImageX REAL NOT NULL DEFAULT 0, ImageY REAL NOT NULL DEFAULT 0 )  P0!eeYtabletblPhotoPolyToSessionstblPhotoPolyToSessionseCREATE TABLE tblPhotoPolyToSessions ( fkeyScanSession INTEGER NOT NULL DEFAULT 0 REFERENCES tblPhotoScanSession(keyScanSession) ON DELETE CASCADE ON UPDATE CASCADE, fkeyPhotoPolygon INTEGER NOT NULL DEFAULT 0 REFERENCES tblPhotoPolygon(keyPhotoPolygon) ON DELETE CASCADE ON UPDATE CASCADE, fkeyFirstScannedSt INTEGER, fkeyLastScannedSt INTEGER )  ( keyScanSession INTEGER PRIMARY KEY AUTOINCREMENT, SessionName TEXT(255) NOT NULL DEFAULT '0', fkeyFirstScannedSt INTEGER NOT NULL DEFAULT 0, fkeyLastScannedSt INTEGER NOT NULL DEFAULT 0, ScanMode INTEGER NOT NULL DEFAULT 0, ScanningHInterval REAL NOT NULL DEFAULT 0, ScanningHIntervalType INTEGER NOT NULL DEFAULT 0, ScanningVInterval REAL NOT NULL DEFAULT 0, ScanningVIntervalType INTEGER NOT NULL DEFAULT 0, ScanMeasMode INTEGER NOT NULL DEFAULT 0 ) \\1!YYtabletblPhotoScanSessiontblPhotoScanSessiongCREATE TABLE tblPhotoScanSessionh|2!QQYtabletblPointPlotAttrstblPointPlotAttrsjCREATE TABLE tblPointPlotAttrs ( fkeySoPoint INTEGER PRIMARY KEY DEFAULT 0 REFERENCES tblSoPoints(keySoPoint) ON DELETE CASCADE ON UPDATE CASCADE, MarkColor INTEGER, MarkStyleIndex INTEGER )   ee3!aaqtabletblPtsToExternalNotestblPtsToExternalNoteskCREATE TABLE tblPtsToExternalNotes ( fkeyPoint INTEGER NOT NULL DEFAULT 0 REFERENCES tblSoPoints(keySoPoint) ON DELETE CASCADE ON UPDATE CASCADE, fkeyNotes INTEGER NOT NULL DEFAULT 0 REFERENCES tblExternalNotes(keyExternalNote) ON DELETE CASCADE ON UPDATE CASCADE )  4!AA tabletblPtsToRoadstblPtsToRoadsmCREATE TABLE tblPtsToRoads ( fkeyStation INTEGER PRIMARY KEY DEFAULT 0 REFERENCES tblStations(keyStation), fkeyAlnt INTEGER NOT NULL DEFAULT 0 REFERENCES tblLineAlntRoads(keyAlignment) ON DELETE CASCADE ON UPDATE CASCADE, Chainage REAL NOT NULL DEFAULT 0, Offset REAL NOT NULL DEFAULT 0, DeltaH REAL NOT NULL DEFAULT 0 )  j5!QQ5tabletblPtsToStakedPtstblPtsToStakedPtsoCREATE TABLE tblPtsToStakedPts ( fkeyStakedStation INTEGER PRIMARY KEY DEFAULT 0 REFERENCES tblStations(keyStation) ON DELETE CASCADE ON UPDATE CASCADE, fkeyDesignPoint INTEGER NOT NULL DEFAULT 0 REFERENCES tblSoPoints(keySoPoint) ON UPDATE CASCADE )z6!EEmtabletblSetOfPointstblSetOfPointsqCREATE TABLE tblSetOfPoints ( keySetOfPoints INTEGER PRIMARY KEY AUTOINCREMENT, Flags INTEGER, Name TEXT(80) NOT NULL DEFAULT '0' )   d7!QQ)tabletblSetOfPtsPointstblSetOfPtsPointsrCREATE TABLE tblSetOfPtsPoints ( fkeySetOfPoints INTEGER NOT NULL DEFAULT 0 REFERENCES tblSetOfPoints(keySetOfPoints) ON DELETE CASCADE ON UPDATE CASCADE, OrderingNumber REAL NOT NULL DEFAULT 0, fkeySoPoint INTEGER NOT NULL DEFAULT 0 REFERENCES tblSoPoints(keySoPoint) ON DELETE CASCADE ON UPDATE CASCADE ) p@d8 _"7 )1069LOK @I= 6u@3U¦@vY'; 1PP0168LOK @I?ZН@3_ۑ^(@wx; 1PP1091LOK @I?H@3^-C@v9 -PP258LOK @I=)q/@3hCUW@wZ7 )3357LOK @I:B,@3^1@vx'7 )1456LOK @I:K=a'@3]h'X@w'T'* 3357 A+7?u\A? =* 3199 A+N܅RAQ* 3196 A+N =A"0zH* 3195 A+N1A&ZG* 1456A+5fffA=xzH* 1070A+M43333A!x =* 1069A+N> =qAG. %pp1144A+QfffAi\(. %pp1091A+VE(ABoR. %pp1080A+ZRAKIQ. %pp0168A+X0(AFhQnts ( keySoPoint INTEGER PRIMARY KEY AUTOINCREMENT, Name TEXT(54) NOT NULL DEFAULT '0', Type INTEGER NOT NULL DEFAULT 0, fkeyStationDef INTEGER NOT NULL DEFAULT 0 REFERENCES tblStations(keyStation), C1 REAL, C2 REAL, C3 REAL, fkeyDataset INTEGER NOT NULL DEFAULT 0, StationType INTEGER NOT NULL DEFAULT 0, ExraTypeFlags INTEGER NOT NULL DEFAULT 0, fkeyLayer INTEGER REFERENCES tblLayers(keyLayers) ON UPDATE CASCADE )wv fkeySoPoint INTEGER REFERENCES tblSoPoints(keySoPoint) ON DELETE CASCADE ON UPDATE CASCADE, Name TEXT(50), StationType INTEGER NOT NULL DEFAULT 0, C1 REAL, C2 REAL, C3 REAL, fkeyDataset INTEGER REFERENCES tblDatasets(keyDataset) ON UPDATE CASCADE, Notes TEXT(128), DeletedFlag INTEGER NOT NULL DEFAULT 0, SecondsFrom1970 REAL NOT NULL DEFAULT 0, TimeSystem INTEGER NOT NULL DEFAULT 0, UseInWA INTEGER NOT NULL DEFAULT 0, WaSwitchEnabed INTEGER ) 77$8!99YtabletblSoPointstblSoPointstCREATE TABLE tblSoPoiub9!99UtabletblStationstblStationsvCREATE TABLE tblStations ( keyStation INTEGER PRIMARY KEY AUTOINCREMENT, w:!]]}tabletblTapeDimensionMeastblTapeDimensionMeasyCREz ATE TABLE tblTapeDimensionMeas ( keyTapeDimensionMeas INTEGER PRIMARY KEY AUTOINCREMENT, fkeyTapeDimensionPts INTEGER NOT NULL DEFAULT 0 REFERENCES tblTapeDimensionPts(keyTapeDimensionPts) ON UPDATE CASCADE, fkeyTargetStation INTEGER NOT NULL DEFAULT 0 REFERENCES tblStations(keyStation) ON UPDATE CASCADE, TapeMeas REAL NOT NULL DEFAULT 0, fkeyCrdRawMeas INTEGER NOT NULL DEFAULT 0 REFERENCES tblCrdRawMeas(keyCrdRawMeas) ON UPDATE CASCADE )  KK2;!YY5tabletblTapeDimensionPtstblTapeDimensionPts{CREATE TABLE tblTapeDimensionPts ( keyTapeDimensionPts INTEGER PRIMARY KEY AUTOINCREMENT, fkeyFirstPt INTEGER NOT NULL DEFAULT 0 REFERENCES tblSoPoints(keySoPoint) ON UPDATE CASCADE, fkeySecondPt INTEGER NOT NULL DEFAULT 0 REFERENCES tblSoPoints(keySoPoint) ON UPDATE CASCADE )  tt <!999tabletblTsOccupstblTsOccups}CREATE TABLE tblTsOccups ( keyTsOccupations INTEGER PRIMARY KEY AUTOINCREMENT, fkeySoPoint INTEGER REFERENCES tblSoPoints(keySoPoint) ON UPDATE CASCADE, InstrumentHt REAL, fkeyCrdRawMeas INTEGER NOT NULL DEFAULT 0 REFERENCES tblCrdRawMeas(keyCrdRawMeas) ON UPDATE CASCADE )j=!55mtabletblTsShotstblTsShotsCREATE TABLE tblTsShots ( keyTsShot INTEGER PRIMARY KEY AUTOINCREMENT, fkeyTs Occupations INTEGER NOT NULL DEFAULT 0 REFERENCES tblTsOccups(keyTsOccupations) ON DELETE CASCADE ON UPDATE CASCADE, fkeyTargetStation INTEGER REFERENCES tblStations(keyStation) ON UPDATE CASCADE, HAngle REAL NOT NULL DEFAULT 0, VAngle REAL NOT NULL DEFAULT 0, SDistance REAL NOT NULL DEFAULT 0, TargetAntHeight REAL NOT NULL DEFAULT 0, aFlag INTEGER NOT NULL DEFAULT 0, fkeyCrdRawMeas INTEGER NOT NULL DEFAULT 0 REFERENCES tblCrdRawMeas(keyCrdRawMeas) ON UPDATE CASCADE )  K>!QQutabletblXSectSurveyPtstblXSectSurveyPtsCREATE TABLE tblXSectSurveyPts ( keyXSectSurvey INTEGER PRIMARY KEY AUTOINCREMENT, Chainage REAL NOT NULL DEFAULT 0, fkeySoPoint INTEGER NOT NULL DEFAULT 0 REFERENCES tblSoPoints(keySoPoint), CLFlag INTEGER NOT NULL DEFAULT 0, fkeyAlignment INTEGER NOT NULL DEFAULT 0 REFERENCES tblLineAlntRoads(keyAlignment) ON DELETE CASCADE ON UPDATE CASCADE )  q?!IIQtabletblXSectTplatestblXSectTplatesCREATE TABLE tblXSectTplates ( keyRdTplate INTEGER PRIMARY KEY AUTOINCREMENT, Name TEXT(80) NOT NULL DEFAULT '0', CutValue REAL NOT NULL DEFAULT 0, FillValue REAL NOT NULL DEFAULT 0 )@!eeutabletblXSectTplatesOffsetstblXSectTplatesOffset sCREATE TABLE tblXSectTplatesOffsets ( keyRdTplatePt INTEGER PRIMARY KEY AUTOINCREMENT, fkeyRdTplate INTEGER NOT NULL DEFAULT 0 REFERENCES tblXSectTplates(keyRdTplate) ON DELETE CASCADE ON UPDATE CASCADE, HOffset REAL NOT NULL DEFAULT 0, VOffset REAL NOT NULL DEFAULT 0, OrderOnTheOffset REAL NOT NULL DEFAULT 0, fkeyCodeDef INTEGER REFERENCES tblCodeDefs(keyCodeDef) ON UPDATE CASCADE, RepresentationType INTEGER NOT NULL DEFAULT 0 )  yA!UUItabletblVectorImageRefstblVectorImageRefsCREATE TABLE tblVectorImageRefs ( keyVectorImageRef INTEGER PRIMARY KEY AUTOINCREMENT, FilePath TEXT(260) NOT NULL DEFAULT '0', fkeyDataset INTEGER NOT NULL DEFAULT 0 REFERENCES tblDatasets(keyDataset) ON UPDATE CASCADE, fkeyLayer INTEGER NOT NULL DEFAULT 0 REFERENCES tblLayers(keyLayers) ON UPDATE CASCADE )   B!QQitabletblVersionHistorytblVersionHistoryCREATE TABLE tblVersionHistory ( keyVersionHistory INTEGER PRIMARY KEY AUTOINCREMENT, Major INTEGER NOT NULL DEFAULT 0, Medium INTEGER NOT NULL DEFAULT 0, Minor INTEGER NOT NULL DEFAULT 0 )mC!yEindexndx_tblCodeAttrDef_nameAttrtblCodeAttrDefCREATE INDEX ndx_tblCodeAttrDef_nameAttr ON tblCodeAttrDef(nameAttr)   tD!A]Iindexndx_tblCodeAttrMenuLists_fkeyAttrDef_MenuItemtblCodeAttrMenuListsCREATE UNIQUE INDEX ndx_tblCodeAttrMenuLists_fkeyAttrDef_MenuItem ON tblCodeAttrMenuLists(fkeyAttrDef,MenuItem)sE!}E%indexndx_tblCodeAttrVal_fkeyPointtblCodeAttrValCREATE INDEX ndx_tblCodeAttrVal_fkeyPoint ON tblCodeAttrVal(fkeyPoint)zF!MEaindexndx_tblCodeAttrVal_fkeyCodesToPoints_fkeyAttrDeftblCodeAttrValCREATE UNIQUE INDEX ndx_tblCodeAttrVal_fkeyCodesToPoints_fkeyAttrDef ON tblCodeAttrVal(fkeyCodesToPoints,fkeyAttrDef)    E{|HiddenCode|} cG!m9!indexndx_tblCodeDefs_nameCodetblCodeDefsCREATE UNIQUE INDEX ndx_tblCodeDefs_nameCode ON tblCodeDefs(nameCode)kH!yAindexndx_tblCodesToPts_fkeyPointtblCodesToPtsCREATE INDEX ndx_tblCodesToPts_fkeyPoint ON tblCodesToPts(fkeyPoint)I! =Yindexndx_tblCrdBaseSt_fkeyCrdRawMeastblCrdBaseStCREATE UNIQUE INDEX ndx_tblCrdBaseSt_fkeyCrdRawMeas ON tblCrdBaseSt(fkeyCrdRawMeas)    LL~J!UQUindexndx_tblCrdFindStaInfo_fkeyAlignment_keyFindStaMeastblCrdFindStaInfoCREATE INDEX ndx_tblCrdFindStaInfo_fkeyAlignment_keyFindStaMeas ON tblCrdFindStaInfo(fkeyAlignment,keyFindStaMeas)0K!Myindexndx_tblCrdGnssOffset_fkeyCrdRawMeastblCrdGnssOffsetCREATE UNIQUE INDEX ndx_tblCrdGnssOffset_fkeyCrdRawMeas ON tblCrdGnssOffset(fkeyCrdRawMeas)   HL!%Yindexndx_tblCrdGnssPtlOffset_fkeyCrdRawMeastblCrdGnssPtlOffsetCREATE UNIQUE INDEX ndx_tblCrdGnssPtlOffset_fkeyCrdRawMeas ON tblCrdGnssPtlOffset(fkeyCrdRawMeas)M! Aaindexndx_tblCrdGnssRaw_fkeyCrdRawMeastblCrdGnssRawCREATE UNIQUE INDEX ndx_tblCrdGnssRaw_fkeyCrdRawMeas ON tblCrdGnssRaw(fkeyCrdRawMeas)N!AUindexndx_tblCrdGnssRaw_fkeyRoverStationtblCrdGnssRawCREATE INDEX ndx_tblCrdGnssRaw_fkeyRoverStation ON tblCrdGnssRaw(fkeyRoverStation)       "O!Iiindexndx_tblCrdImageData_ImageFileNametblCrdImageDataCREATE UNIQUE INDEX ndx_tblCrdImageData_ImageFileName ON tblCrdImageData(ImageFileName)uP!}I%indexndx_tblCrdImageData_fkeyShottblCrdImageDataCREATE INDEX ndx_tblCrdImageData_fkeyShot ON tblCrdImageData(fkeyShot)Q!}IAindexndx_tblCtrlCodesLib_CtrlCodetblCtrlCodesLibCREATE UNIQUE INDEX ndx_tblCtrlCodesLib_CtrlCode ON tblCtrlCodesLib(CtrlCode)    zz@R!)=indexndx_tblLineProps_fkeyCodeDef_CodeStringtblLinePropsCREATE UNIQUE INDEX ndx_tblLineProps_fkeyCodeDef_CodeString ON tblLineProps(fkeyCodeDef,CodeString)@S!!U indexndx_tblMissingLineMeas_fkeyCrdRawMeastblMissingLineMeasCREATE UNIQUE INDEX ndx_tblMissingLineMeas_fkeyCrdRawMeas ON tblMissingLineMeas(fkeyCrdRawMeas)   eT!I]Yindexndx_tblPhotoCameraParams_fkeyCamera_ParameterIdtblPhotoCameraParamsCREATE UNIQUE INDEX ndx_tblPhotoCameraParams_fkeyCamera_ParameterId ON tblPhotoCameraParams(fkeyCamera,ParameterId)U!Y]yindexndx_tblPhotoCamOriPoints_fkeyPhotoImage_fkeySoPointtblPhotoCamOriPointsCREATE UNIQUE INDEX ndx_tblPhotoCamOriPoints_fkeyPhotoImage_fkeySoPoint ON tblPhotoCamOriPoints(fkeyPhotoImage,fkeySoPoint)   ZZoV! AYindexndx_tblPhotoImage_ImageFileNametblPhotoImageCREATE UNIQUE INDEX ndx_tblPhotoImage_ImageFileName ON tblPhotoImage(ImageFileName)W!YIyindexndx_tblPhotoPolyPts_fkeyPhotoPolygon_OrderingNumbertblPhotoPolyPtsCREATE UNIQUE INDEX ndx_tblPhotoPolyPts_fkeyPhotoPolygon_OrderingNumber ON tblPhotoPolyPts(fkeyPhotoPolygon,OrderingNumber)   LX!ye9indexndx_tblPhotoPolyToSessions_fkeyScanSession_fkeyPhotoPolygontblPhotoPolyToSessionsCREATE UNIQUE INDEX ndx_tblPhotoPolyToSessions_fkeyScanSession_fkeyPhotoPolygon ON tblPhotoPolyToSessions(fkeyScanSession,fkeyPhotoPolygon)vY!AaIindexndx_tblPtsToExternalNotes_fkeyPoint_fkeyNotestblPtsToExternalNotesCREATE UNIQUE INDEX ndx_tblPtsToExternalNotes_fkeyPoint_fkeyNotes ON tblPtsToExternalNotes(fkeyPoint,fkeyNotes)   LLe0Z!!Qmindexndx_tblPtsToStakedPts_fkeyDesignPointtblPtsToStakedPtsCREATE INDEX ndx_tblPtsToStakedPts_fkeyDesignPoint ON tblPtsToStakedPts(fkeyDesignPoint)c[!iEindexndx_tblSetOfPoints_NametblSetOfPointsCREATE UNIQUE INDEX ndx_tblSetOfPoints_Name ON tblSetOfPoints(Name)\!]Qindexndx_tblSetOfPtsPoints_fkeySetOfPoints_OrderingNumbertblSetOfPtsPointsCREATE UNIQUE INDEX ndx_tblSetOfPtsPoints_fkeySetOfPoints_OrderingNumber ON tblSetOfPtsPoints(fkeySetOfPoints,OrderingNumber)   N{na;&)1069LOK1PP0168LOK1PP1091LOK-PP258LOK)3357LOK )1456LOK 3357 3199 3196 3195 1456 1070 1069%pp1144%pp1091%pp1080%pp0168 K]!]9indexndx_tblSoPoints_NametblSoPointsCREATE UNIQUE INDEX ndx_tblSoPoints_Name ON tblSoPoints(Name)P^!)]indexndx_tblTapeDimensionMeas_fkeyCrdRawMeastblTapeDimensionMeasCREATE UNIQUE INDEX ndx_tblTapeDimensionMeas_fkeyCrdRawMeas ON tblTapeDimensionMeas(fkeyCrdRawMeas)_!9Qindexndx_tblTsOccups_fkeyCrdRawMeastblTsOccupsCREATE UNIQUE INDEX ndx_tblTsOccups_fkeyCrdRawMeas ON tblTsOccups(fkeyCrdRawMeas)    `!5Iindexndx_tblTsShots_fkeyCrdRawMeastblTsShotsCREATE UNIQUE INDEX ndx_tblTsShots_fkeyCrdRawMeas ON tblTsShots(fkeyCrdRawMeas)~a!UQUindexndx_tblXSectSurveyPts_fkeyAlignment_keyXSectSurveytblXSectSurveyPtsCREATE INDEX ndx_tblXSectSurveyPts_fkeyAlignment_keyXSectSurvey ON tblXSectSurveyPts(fkeyAlignment,keyXSectSurvey)kb!mI!indexndx_tblXSectTplates_NametblXSectTplatesCREATE UNIQUE INDEX ndx_tblXSectTplates_Name ON tblXSectTplates(Name)   mc) M}triggeron_delete_from_tblAntennaModelstblAntennaModelsCREATE TRIGGER on_delete_from_tblAntennaModels BEFORE DELETE ON [tblAntennaModels] BEGIN SELECT RAISE(ABORT,'Records removal is not allowed on table [tblAntennaModels]'); END -d))Eetriggeron_update_field_tblCodeAttrDef_fkeyCodetblCodeAttrDefCREATE TRIGGER on_update_field_tblCodeAttrDef_fkeyCode BEFORE UPDATE OF [fkeyCode] ON [tblCodeAttrDef] BEGIN SELECT RAISE(ABORT,'Field [tblCodeAttrDef].[fkeyCode] can be set only once in Insert'); END NN/e)!Eqtriggeron_delete_key_cascade_tblCodeAttrDef_tblCodeAttrMenuLists_fkeyAttrDeftblCodeAttrDefCREATE TRIGGER on_delete_key_cascade_tblCodeAttrDef_tblCodeAttrMenuLists_fkeyAttrDef BEFORE DELETE ON [tblCodeAttrDef] FOR EACH ROW BEGIN DELETE FROM tblCodeAttrMenuLists WHERE tblCodeAttrMenuLists.fkeyAttrDef = OLD.keyCodeAttrDef; END ZZ#f) Eqtriggeron_delete_key_forbide_tblCodeAttrDef_tblCodeAttrVal_fkeyAttrDeftblCodeAttrDefCREATE TRIGGER on_delete_key_forbide_tblCodeAttrDef_tblCodeAttrVal_fkeyAttrDef BEFORE DELETE ON [tblCodeAttrDef] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblCodeAttrDef] violates foreign key constraint for [tblCodeAttrVal].[fkeyAttrDef]') WHERE (SELECT fkeyAttrDef FROM tblCodeAttrVal WHERE fkeyAttrDef = OLD.keyCodeAttrDef) IS NOT NULL; END ||g)M]Qtriggeron_update_field_tblCodeAttrMenuLists_fkeyAttrDeftblCodeAttrMenuListsCREATE TRIGGER on_update_field_tblCodeAttrMenuLists_fkeyAttrDef BEFORE UPDATE OF [fkeyAttrDef] ON [tblCodeAttrMenuLists] BEGIN SELECT RAISE(ABORT,'Field [tblCodeAttrMenuLists].[fkeyAttrDef] can be set only once in Insert'); END uh)MEQtriggeron_update_field_tblCodeAttrVal_fkeyCodesToPointstblCodeAttrValCREATE TRIGGER on_update_field_tblCodeAttrVal_fkeyCodesToPoints BEFORE UPDATE OF [fkeyCodesToPoints] ON [tblCodeAttrVal] BEGIN SELECT RAISE(ABORT,'Field [tblCodeAttrVal].[fkeyCodesToPoints] can be set only once in Insert'); END Ei)5E triggeron_update_field_tblCodeAttrVal_fkeyAttrDeftblCodeAttrValCREATE TRIGGER on_update_field_tblCodeAttrVal_fkeyAttrDef BEFORE UPDATE OF [fkeyAttrDef] ON [tblCodeAttrVal] BEGIN SELECT RAISE(ABORT,'Field [tblCodeAttrVal].[fkeyAttrDef] can be set only once in Insert'); END 5j)-Eqtriggeron_update_field_tblCodeAttrVal_fkeyPointtblCodeAttrValCREATE TRIGGER on_update_field_tblCodeAttrVal_fkeyPoint BEFORE UPDATE OF [fkeyPoint] ON [tblCodeAttrVal] BEGIN SELECT RAISE(ABORT,'Field [tblCodeAttrVal].[fkeyPoint] can be set only once in Insert'); END k)9atriggeron_update_fk_tblCodeDefs_fkeyLayertblCodeDefsCREATE TRIGGER on_update_fk_tblCodeDefs_fkeyLayer BEFORE UPDATE OF [fkeyLayer] ON [tblCodeDefs] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblCodeDefs].[fkeyLayer]') WHERE NEW.fkeyLayer IS NOT NULL AND (SELECT keyLayers FROM tblLayers WHERE keyLayers = NEW.fkeyLayer) IS NULL; END Ml)q9itriggeron_delete_key_cascade_tblCodeDefs_tblCodeAttrDef_fkeyCodetblCodeDefsCREATE TRIGGER on_delete_key_cascade_tblCodeDefs_tblCodeAttrDef_fkeyCode BEFORE DELETE ON [tblCodeDefs] FOR EACH ROW BEGIN DELETE FROM tblCodeAttrDef WHERE tblCodeAttrDef.fkeyCode = OLD.keyCodeDef; END um)y91triggeron_delete_key_forbide_tblCodeDefs_tblCodesToPts_fkeyCodeDeftblCodeDefsCREATE TRIGGER on_delete_key_forbide_tblCodeDefs_tblCodesToPts_fkeyCodeDef BEFORE DELETE ON [tblCodeDefs] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblCodeDefs] violates foreign key constraint for [tblCodesToPts].[fkeyCodeDef]') WHERE (SELECT fkeyCodeDef FROM tblCodesToPts WHERE fkeyCodeDef = OLD.keyCodeDef) IS NOT NULL; END mn)u9%triggeron_delete_key_forbide_tblCodeDefs_tblLineProps_fkeyCodeDeftblCodeDefsCREATE TRIGGER on_delete_key_forbide_tblCodeDefs_tblLineProps_fkeyCodeDef BEFORE DELETE ON [tblCodeDefs] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblCodeDefs] violates foreign key constraint for [tblLineProps].[fkeyCodeDef]') WHERE (SELECT fkeyCodeDef FROM tblLineProps WHERE fkeyCodeDef = OLD.keyCodeDef) IS NOT NULL; END @@=o)9triggeron_delete_key_forbide_tblCodeDefs_tblXSectTplatesOffsets_fkeyCodeDeftblCodeDefsCREATE TRIGGER on_delete_key_forbide_tblCodeDefs_tblXSectTplatesOffsets_fkeyCodeDef BEFORE DELETE ON [tblCodeDefs] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblCodeDefs] violates foreign key constraint for [tblXSectTplatesOffsets].[fkeyCodeDef]') WHERE (SELECT fkeyCodeDef FROM tblXSectTplatesOffsets WHERE fkeyCodeDef = OLD.keyCodeDef) IS NOT NULL; END +p))Aetriggeron_update_field_tblCodesToPts_fkeyPointtblCodesToPtsCREATE TRIGGER on_update_field_tblCodesToPts_fkeyPoint BEFORE UPDATE OF [fkeyPoint] ON [tblCodesToPts] BEGIN SELECT RAISE(ABORT,'Field [tblCodesToPts].[fkeyPoint] can be set only once in Insert'); END ;q)1A}triggeron_update_field_tblCodesToPts_fkeyCodeDeftblCodesToPtsCREATE TRIGGER on_update_field_tblCodesToPts_fkeyCodeDef BEFORE UPDATE OF [fkeyCodeDef] ON [tblCodesToPts] BEGIN SELECT RAISE(ABORT,'Field [tblCodesToPts].[fkeyCodeDef] can be set only once in Insert'); END sr)-Aqtriggeron_update_fk_tblCodesToPts_fkeyCtrlCode1tblCodesToPtsCREATE TRIGGER on_update_fk_tblCodesToPts_fkeyCtrlCode1 BEFORE UPDATE OF [fkeyCtrlCode1] ON [tblCodesToPts] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblCodesToPts].[fkeyCtrlCode1]') WHERE NEW.fkeyCtrlCode1 IS NOT NULL AND (SELECT keyCtrlCode FROM tblCtrlCodesLib WHERE keyCtrlCode = NEW.fkeyCtrlCode1) IS NULL; END ss)-Aqtriggeron_update_fk_tblCodesToPts_fkeyCtrlCode2tblCodesToPtsCREATE TRIGGER on_update_fk_tblCodesToPts_fkeyCtrlCode2 BEFORE UPDATE OF [fkeyCtrlCode2] ON [tblCodesToPts] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblCodesToPts].[fkeyCtrlCode2]') WHERE NEW.fkeyCtrlCode2 IS NOT NULL AND (SELECT keyCtrlCode FROM tblCtrlCodesLib WHERE keyCtrlCode = NEW.fkeyCtrlCode2) IS NULL; END ^^t)AYtriggeron_delete_key_cascade_tblCodesToPts_tblCodeAttrVal_fkeyCodesToPointstblCodesToPtsCREATE TRIGGER on_delete_key_cascade_tblCodesToPts_tblCodeAttrVal_fkeyCodesToPoints BEFORE DELETE ON [tblCodesToPts] FOR EACH ROW BEGIN DELETE FROM tblCodeAttrVal WHERE tblCodeAttrVal.fkeyCodesToPoints = OLD.keyCodesToPoints; END Iu)9=triggeron_update_field_tblCrdBaseSt_fkeyCrdRawMeastblCrdBaseStCREATE TRIGGER on_update_field_tblCrdBaseSt_fkeyCrdRawMeas BEFORE UPDATE OF [fkeyCrdRawMeas] ON [tblCrdBaseSt] BEGIN SELECT RAISE(ABORT,'Field [tblCrdBaseSt].[fkeyCrdRawMeas] can be set only once in Insert'); END ^^v)5=Etriggeron_update_fk_tblCrdBaseSt_fkeyAntennaModeltblCrdBaseStCREATE TRIGGER on_update_fk_tblCrdBaseSt_fkeyAntennaModel BEFORE UPDATE OF [fkeyAntennaModel] ON [tblCrdBaseSt] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblCrdBaseSt].[fkeyAntennaModel]') WHERE NEW.fkeyAntennaModel IS NOT NULL AND (SELECT keyAntennaModel FROM tblAntennaModels WHERE keyAntennaModel = NEW.fkeyAntennaModel) IS NULL; END llw)5=)triggeron_update_fk_tblCrdBaseSt_fkeyGnssRawForKPtblCrdBaseStCREATE TRIGGER on_update_fk_tblCrdBaseSt_fkeyGnssRawForKP BEFORE UPDATE OF [fkeyGnssRawForKP] ON [tblCrdBaseSt] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblCrdBaseSt].[fkeyGnssRawForKP]') WHERE NEW.fkeyGnssRawForKP IS NOT NULL AND (SELECT keyCrdGnssRaw FROM tblCrdGnssRaw WHERE keyCrdGnssRaw = NEW.fkeyGnssRawForKP) IS NULL; END Ex)!=%triggeron_update_fk_tblCrdBaseSt_fkeySoPointtblCrdBaseStCREATE TRIGGER on_update_fk_tblCrdBaseSt_fkeySoPoint BEFORE UPDATE OF [fkeySoPoint] ON [tblCrdBaseSt] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblCrdBaseSt].[fkeySoPoint]') WHERE NEW.fkeySoPoint IS NOT NULL AND (SELECT keySoPoint FROM tblSoPoints WHERE keySoPoint = NEW.fkeySoPoint) IS NULL; END iy)-=atriggeron_update_fk_tblCrdBaseSt_fkeyKnownPointtblCrdBaseStCREATE TRIGGER on_update_fk_tblCrdBaseSt_fkeyKnownPoint BEFORE UPDATE OF [fkeyKnownPoint] ON [tblCrdBaseSt] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblCrdBaseSt].[fkeyKnownPoint]') WHERE NEW.fkeyKnownPoint IS NOT NULL AND (SELECT keySoPoint FROM tblSoPoints WHERE keySoPoint = NEW.fkeyKnownPoint) IS NULL; END 99Dz)y=Mtriggeron_delete_from_tblCrdBaseSttblCrdBaseStCREATE TRIGGER on_delete_from_tblCrdBaseSt BEFORE DELETE ON [tblCrdBaseSt] BEGIN SELECT RAISE(ABORT,'Records removal is not allowed on table [tblCrdBaseSt]'); END {)-Q1triggeron_update_fk_tblCrdBgImageData_fkeyLayertblCrdBgImageDataCREATE TRIGGER on_update_fk_tblCrdBgImageData_fkeyLayer BEFORE UPDATE OF [fkeyLayer] ON [tblCrdBgImageData] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblCrdBgImageData].[fkeyLayer]') WHERE (SELECT keyLayers FROM tblLayers WHERE keyLayers = NEW.fkeyLayer) IS NULL; END &&W|)9Utriggeron_delete_key_cascade_tblCrdCalibrations_tblIdenticalPoints_fkeyCalibrationtblCrdCalibrationsCREATE TRIGGER on_delete_key_cascade_tblCrdCalibrations_tblIdenticalPoints_fkeyCalibration BEFORE DELETE ON [tblCrdCalibrations] FOR EACH ROW BEGIN DELETE FROM tblIdenticalPoints WHERE tblIdenticalPoints.fkeyCalibration = OLD.keyCalibration; END xx})MMitriggeron_update_fk_tblCrdDLevelRuns_fkeyCrdDlOccFinishtblCrdDLevelRunsCREATE TRIGGER on_update_fk_tblCrdDLevelRuns_fkeyCrdDlOccFinish BEFORE UPDATE OF [fkeyCrdDlOccFinish] ON [tblCrdDLevelRuns] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblCrdDLevelRuns].[fkeyCrdDlOccFinish]') WHERE (SELECT fkeyCrdRawMeas FROM tblCrdDlOccs WHERE fkeyCrdRawMeas = NEW.fkeyCrdDlOccFinish) IS NULL; END m~) M}triggeron_delete_from_tblCrdDLevelRunstblCrdDLevelRunsCREATE TRIGGER on_delete_from_tblCrdDLevelRuns BEFORE DELETE ON [tblCrdDLevelRuns] BEGIN SELECT RAISE(ABORT,'Records removal is not allowed on table [tblCrdDLevelRuns]'); END I)9=triggeron_update_field_tblCrdDlOccs_fkeyCrdRawMeastblCrdDlOccsCREATE TRIGGER on_update_field_tblCrdDlOccs_fkeyCrdRawMeas BEFORE UPDATE OF [fkeyCrdRawMeas] ON [tblCrdDlOccs] BEGIN SELECT RAISE(ABORT,'Field [tblCrdDlOccs].[fkeyCrdRawMeas] can be set only once in Insert'); END aa)1=Atriggeron_update_fk_tblCrdDlOccs_fkeyCrdLevelRuntblCrdDlOccsCREATE TRIGGER on_update_fk_tblCrdDlOccs_fkeyCrdLevelRun BEFORE UPDATE OF [fkeyCrdLevelRun] ON [tblCrdDlOccs] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblCrdDlOccs].[fkeyCrdLevelRun]') WHERE NEW.fkeyCrdLevelRun IS NOT NULL AND (SELECT fkeyCrdDlOccStart FROM tblCrdDLevelRuns WHERE fkeyCrdDlOccStart = NEW.fkeyCrdLevelRun) IS NULL; END 88D)y=Mtriggeron_delete_from_tblCrdDlOccstblCrdDlOccsCREATE TRIGGER on_delete_from_tblCrdDlOccs BEFORE DELETE ON [tblCrdDlOccs] BEGIN SELECT RAISE(ABORT,'Records removal is not allowed on table [tblCrdDlOccs]'); END S)=A!triggeron_update_field_tblCrdDlShots_fkeyCrdRawMeastblCrdDlShotsCREATE TRIGGER on_update_field_tblCrdDlShots_fkeyCrdRawMeas BEFORE UPDATE OF [fkeyCrdRawMeas] ON [tblCrdDlShots] BEGIN SELECT RAISE(ABORT,'Field [tblCrdDlShots].[fkeyCrdRawMeas] can be set only once in Insert'); END +))Aetriggeron_update_field_tblCrdDlShots_fkeyDlOcctblCrdDlShotsCREATE TRIGGER on_update_field_tblCrdDlShots_fkeyDlOcc BEFORE UPDATE OF [fkeyDlOcc] ON [tblCrdDlShots] BEGIN SELECT RAISE(ABORT,'Field [tblCrdDlShots].[fkeyDlOcc] can be set only once in Insert'); END )%A1triggeron_update_fk_tblCrdDlShots_fkeyStationtblCrdDlShotsCREATE TRIGGER on_update_fk_tblCrdDlShots_fkeyStation BEFORE UPDATE OF [fkeyStation] ON [tblCrdDlShots] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblCrdDlShots].[fkeyStation]') WHERE (SELECT keyStation FROM tblStations WHERE keyStation = NEW.fkeyStation) IS NULL; END ..N)}AYtriggeron_delete_from_tblCrdDlShotstblCrdDlShotsCREATE TRIGGER on_delete_from_tblCrdDlShots BEFORE DELETE ON [tblCrdDlShots] BEGIN SELECT RAISE(ABORT,'Records removal is not allowed on table [tblCrdDlShots]'); END s)IQEtriggeron_update_field_tblCrdFindStaInfo_fkeyAlignmenttblCrdFindStaInfoCREATE TRIGGER on_update_field_tblCrdFindStaInfo_fkeyAlignment BEFORE UPDATE OF [fkeyAlignment] ON [tblCrdFindStaInfo] BEGIN SELECT RAISE(ABORT,'Field [tblCrdFindStaInfo].[fkeyAlignment] can be set only once in Insert'); END 7)5Qatriggeron_update_fk_tblCrdFindStaInfo_fkeySoPointtblCrdFindStaInfoCREATE TRIGGER on_update_fk_tblCrdFindStaInfo_fkeySoPoint BEFORE UPDATE OF [fkeySoPoint] ON [tblCrdFindStaInfo] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblCrdFindStaInfo].[fkeySoPoint]') WHERE (SELECT keySoPoint FROM tblSoPoints WHERE keySoPoint = NEW.fkeySoPoint) IS NULL; END Y)=M!triggeron_update_field_tblCrdGnssOffset_fkeyStationtblCrdGnssOffsetCREATE TRIGGER on_update_field_tblCrdGnssOffset_fkeyStation BEFORE UPDATE OF [fkeyStation] ON [tblCrdGnssOffset] BEGIN SELECT RAISE(ABORT,'Field [tblCrdGnssOffset].[fkeyStation] can be set only once in Insert'); END q )IMEtriggeron_update_field_tblCrdGnssOffset_fkeyCrdRawMeastblCrdGnssOffsetCREATE TRIGGER on_update_field_tblCrdGnssOffset_fkeyCrdRawMeas BEFORE UPDATE OF [fkeyCrdRawMeas] ON [tblCrdGnssOffset] BEGIN SELECT RAISE(ABORT,'Field [tblCrdGnssOffset].[fkeyCrdRawMeas] can be set only once in Insert'); END I )%Mtriggeron_update_fk_tblCrdGnssOffset_fkeyAzPttblCrdGnssOffsetCREATE TRIGGER on_update_fk_tblCrdGnssOffset_fkeyAzPt BEFORE UPDATE OF [fkeyAzPt] ON [tblCrdGnssOffset] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblCrdGnssOffset].[fkeyAzPt]') WHERE NEW.fkeyAzPt IS NOT NULL AND (SELECT keySoPoint FROM tblSoPoints WHERE keySoPoint = NEW.fkeyAzPt) IS NULL; END K )=Mtriggeron_update_fk_tblCrdGnssOffset_fkeyStationOrgtblCrdGnssOffsetCREATE TRIGGER on_update_fk_tblCrdGnssOffset_fkeyStationOrg BEFORE UPDATE OF [fkeyStationOrg] ON [tblCrdGnssOffset] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblCrdGnssOffset].[fkeyStationOrg]') WHERE (SELECT keyStation FROM tblStations WHERE keyStation = NEW.fkeyStationOrg) IS NULL; END m ) M}triggeron_delete_from_tblCrdGnssOffsettblCrdGnssOffsetCREATE TRIGGER on_delete_from_tblCrdGnssOffset BEFORE DELETE ON [tblCrdGnssOffset] BEGIN SELECT RAISE(ABORT,'Records removal is not allowed on table [tblCrdGnssOffset]'); END w )IYEtriggeron_update_field_tblCrdGnssPtlOffset_fkeyStationtblCrdGnssPtlOffsetCREATE TRIGGER on_update_field_tblCrdGnssPtlOffset_fkeyStation BEFORE UPDATE OF [fkeyStation] ON [tblCrdGnssPtlOffset] BEGIN SELECT RAISE(ABORT,'Field [tblCrdGnssPtlOffset].[fkeyStation] can be set only once in Insert'); END mm)UYitriggeron_update_field_tblCrdGnssPtlOffset_fkeyCrdRawMeastblCrdGnssPtlOffsetCREATE TRIGGER on_update_field_tblCrdGnssPtlOffset_fkeyCrdRawMeas BEFORE UPDATE OF [fkeyCrdRawMeas] ON [tblCrdGnssPtlOffset] BEGIN SELECT RAISE(ABORT,'Field [tblCrdGnssPtlOffset].[fkeyCrdRawMeas] can be set only once in Insert'); END U)AY triggeron_update_fk_tblCrdGnssPtlOffset_fkeyStation1tblCrdGnssPtlOffsetCREATE TRIGGER on_update_fk_tblCrdGnssPtlOffset_fkeyStation1 BEFORE UPDATE OF [fkeyStation1] ON [tblCrdGnssPtlOffset] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblCrdGnssPtlOffset].[fkeyStation1]') WHERE (SELECT keyStation FROM tblStations WHERE keyStation = NEW.fkeyStation1) IS NULL; END U)AY triggeron_update_fk_tblCrdGnssPtlOffset_fkeyStation2tblCrdGnssPtlOffsetCREATE TRIGGER on_update_fk_tblCrdGnssPtlOffset_fkeyStation2 BEFORE UPDATE OF [fkeyStation2] ON [tblCrdGnssPtlOffset] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblCrdGnssPtlOffset].[fkeyStation2]') WHERE (SELECT keyStation FROM tblStations WHERE keyStation = NEW.fkeyStation2) IS NULL; END  )Y!triggeron_delete_from_tblCrdGnssPtlOffsettblCrdGnssPtlOffsetCREATE TRIGGER on_delete_from_tblCrdGnssPtlOffset BEFORE DELETE ON [tblCrdGnssPtlOffset] BEGIN SELECT RAISE(ABORT,'Records removal is not allowed on table [tblCrdGnssPtlOffset]'); END c)EA9triggeron_update_field_tblCrdGnssRaw_fkeyRoverStationtblCrdGnssRawCREATE TRIGGER on_update_field_tblCrdGnssRaw_fkeyRoverStation BEFORE UPDATE OF [fkeyRoverStation] ON [tblCrdGnssRaw] BEGIN SELECT RAISE(ABORT,'Field [tblCrdGnssRaw].[fkeyRoverStation] can be set only once in Insert'); END [)AA-triggeron_update_field_tblCrdGnssRaw_fKeyBaseStationtblCrdGnssRawCREATE TRIGGER on_update_field_tblCrdGnssRaw_fKeyBaseStation BEFORE UPDATE OF [fKeyBaseStation] ON [tblCrdGnssRaw] BEGIN SELECT RAISE(ABORT,'Field [tblCrdGnssRaw].[fKeyBaseStation] can be set only once in Insert'); END )A)triggeron_update_field_tblCrdGnssRaw_DLattblCrdGnssRawCREATE TRIGGER on_update_field_tblCrdGnssRaw_DLat BEFORE UPDATE OF [DLat] ON [tblCrdGnssRaw] BEGIN SELECT RAISE(ABORT,'Field [tblCrdGnssRaw].[DLat] can be set only once in Insert'); END )A)triggeron_update_field_tblCrdGnssRaw_DLontblCrdGnssRawCREATE TRIGGER on_update_field_tblCrdGnssRaw_DLon BEFORE UPDATE OF [DLon] ON [tblCrdGnssRaw] BEGIN SELECT RAISE(ABORT,'Field [tblCrdGnssRaw].[DLon] can be set only once in Insert'); END )A)triggeron_update_field_tblCrdGnssRaw_DHgttblCrdGnssRawCREATE TRIGGER on_update_field_tblCrdGnssRaw_DHgt BEFORE UPDATE OF [DHgt] ON [tblCrdGnssRaw] BEGIN SELECT RAISE(ABORT,'Field [tblCrdGnssRaw].[DHgt] can be set only once in Insert'); END S)=A!triggeron_update_field_tblCrdGnssRaw_fkeyCrdRawMeastblCrdGnssRawCREATE TRIGGER on_update_field_tblCrdGnssRaw_fkeyCrdRawMeas BEFORE UPDATE OF [fkeyCrdRawMeas] ON [tblCrdGnssRaw] BEGIN SELECT RAISE(ABORT,'Field [tblCrdGnssRaw].[fkeyCrdRawMeas] can be set only once in Insert'); END _)9A=triggeron_update_fk_tblCrdGnssRaw_fkeyAntennaModeltblCrdGnssRawCREATE TRIGGER on_update_fk_tblCrdGnssRaw_fkeyAntennaModel BEFORE UPDATE OF [fkeyAntennaModel] ON [tblCrdGnssRaw] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblCrdGnssRaw].[fkeyAntennaModel]') WHERE (SELECT keyAntennaModel FROM tblAntennaModels WHERE keyAntennaModel = NEW.fkeyAntennaModel) IS NULL; END ..N)}AYtriggeron_delete_from_tblCrdGnssRawtblCrdGnssRawCREATE TRIGGER on_delete_from_tblCrdGnssRaw BEFORE DELETE ON [tblCrdGnssRaw] BEGIN SELECT RAISE(ABORT,'Records removal is not allowed on table [tblCrdGnssRaw]'); END SS))EQ5triggeron_update_fk_tblCrdImageCamera_fkeyPhotoCameratblCrdImageCameraCREATE TRIGGER on_update_fk_tblCrdImageCamera_fkeyPhotoCamera BEFORE UPDATE OF [fkeyPhotoCamera] ON [tblCrdImageCamera] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblCrdImageCamera].[fkeyPhotoCamera]') WHERE NEW.fkeyPhotoCamera IS NOT NULL AND (SELECT keyCamera FROM tblPhotoCamera WHERE keyCamera = NEW.fkeyPhotoCamera) IS NULL; END w) Q triggeron_delete_from_tblCrdImageCameratblCrdImageCameraCREATE TRIGGER on_delete_from_tblCrdImageCamera BEFORE DELETE ON [tblCrdImageCamera] BEGIN SELECT RAISE(ABORT,'Records removal is not allowed on table [tblCrdImageCamera]'); END mm)9Itriggeron_update_fk_tblCrdImageData_fkeyCameraInfotblCrdImageDataCREATE TRIGGER on_update_fk_tblCrdImageData_fkeyCameraInfo BEFORE UPDATE OF [fkeyCameraInfo] ON [tblCrdImageData] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblCrdImageData].[fkeyCameraInfo]') WHERE NEW.fkeyCameraInfo IS NOT NULL AND (SELECT keyCamera FROM tblCrdImageCamera WHERE keyCamera = NEW.fkeyCameraInfo) IS NULL; END {{)QM]triggeron_update_field_tblCrdObsSession_fkeyObsEquipmenttblCrdObsSessionCREATE TRIGGER on_update_field_tblCrdObsSession_fkeyObsEquipment BEFORE UPDATE OF [fkeyObsEquipment] ON [tblCrdObsSession] BEGIN SELECT RAISE(ABORT,'Field [tblCrdObsSession].[fkeyObsEquipment] can be set only once in Insert'); END m) M}triggeron_delete_from_tblCrdObsSessiontblCrdObsSessionCREATE TRIGGER on_delete_from_tblCrdObsSession BEFORE DELETE ON [tblCrdObsSession] BEGIN SELECT RAISE(ABORT,'Records removal is not allowed on table [tblCrdObsSession]'); END )!1Mtriggeron_update_field_tblCrdPtl_fkeyStationtblCrdPtlCREATE TRIGGER on_update_field_tblCrdPtl_fkeyStation BEFORE UPDATE OF [fkeyStation] ON [tblCrdPtl] BEGIN SELECT RAISE(ABORT,'Field [tblCrdPtl].[fkeyStation] can be set only once in Insert'); END GG5 )11triggeron_update_fk_tblCrdPtl_fkeyP1tblCrdPtlCREATE TRIGGER on_update_fk_tblCrdPtl_fkeyP1 BEFORE UPDATE OF [fkeyP1] ON [tblCrdPtl] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblCrdPtl].[fkeyP1]') WHERE (SELECT keySoPoint FROM tblSoPoints WHERE keySoPoint = NEW.fkeyP1) IS NULL; END GG5!)11triggeron_update_fk_tblCrdPtl_fkeyP2tblCrdPtlCREATE TRIGGER on_update_fk_tblCrdPtl_fkeyP2 BEFORE UPDATE OF [fkeyP2] ON [tblCrdPtl] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblCrdPtl].[fkeyP2]') WHERE (SELECT keySoPoint FROM tblSoPoints WHERE keySoPoint = NEW.fkeyP2) IS NULL; END G.Gc#)Iqtriggeron_delete_from_tblCtrlCodesLibtblCtrlCodesLibCREATE TRIGGER on_delete_from_tblCtrlCodesLib BEFORE DELETE ON [tblCtrlCodesLib] BEGIN SELECT RAISE(ABORT,'Records removal is not allowed on table [tblCtrlCodesLib]'); ENDN")}AYtriggeron_delete_from_tblCrdRawMeastblCrdRawMeasCREATE TRIGGER on_delete_from_tblCrdRawMeas BEFORE DELETE ON [tblCrdRawMeas] BEGIN SELECT RAISE(ABORT,'Records removal is not allowed on table [tblCrdRawMeas]'); END{zz $).38=BGLQV[`ejoty~ #(-27<AFLRX^djpv|       ")+-/1357:=?BF H!J"M$P%R&T'W)Z*\+^,`-b.d/f0i2l3n4p6s7x:|;~=>@ACFIKNQSUWY\_bcdefghijklmnopqrstuvwxyz{|}~ԁՁցׁ؁فځہ܁݁ ށ ߁  BB:$)u9Atriggeron_delete_from_tblDatasetstblDatasetsCREATE TRIGGER on_delete_from_tblDatasets BEFORE DELETE ON [tblDatasets] BEGIN SELECT RAISE(ABORT,'Records removal is not allowed on table [tblDatasets]'); END ??=%)%Mtriggeron_delete_key_cascade_tblExternalNotes_tblPtsToExternalNotes_fkeyNotestblExternalNotesCREATE TRIGGER on_delete_key_cascade_tblExternalNotes_tblPtsToExternalNotes_fkeyNotes BEFORE DELETE ON [tblExternalNotes] FOR EACH ROW BEGIN DELETE FROM tblPtsToExternalNotes WHERE tblPtsToExternalNotes.fkeyNotes = OLD.keyExternalNote; END ??=&)MUQtriggeron_update_fk_tblIdenticalPoints_fkeyLocalStationtblIdenticalPointsCREATE TRIGGER on_update_fk_tblIdenticalPoints_fkeyLocalStation BEFORE UPDATE OF [fkeyLocalStation] ON [tblIdenticalPoints] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblIdenticalPoints].[fkeyLocalStation]') WHERE NEW.fkeyLocalStation IS NOT NULL AND (SELECT keyStation FROM tblStations WHERE keyStation = NEW.fkeyLocalStation) IS NULL; END WW%')EU)triggeron_update_fk_tblIdenticalPoints_fkeyWgsStationtblIdenticalPointsCREATE TRIGGER on_update_fk_tblIdenticalPoints_fkeyWgsStation BEFORE UPDATE OF [fkeyWgsStation] ON [tblIdenticalPoints] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblIdenticalPoints].[fkeyWgsStation]') WHERE NEW.fkeyWgsStation IS NOT NULL AND (SELECT keyStation FROM tblStations WHERE keyStation = NEW.fkeyWgsStation) IS NULL; END ;()a1]triggeron_delete_key_forbide_tblLayers_tblCodeDefs_fkeyLayertblLayersCREATE TRIGGER on_delete_key_forbide_tblLayers_tblCodeDefs_fkeyLayer BEFORE DELETE ON [tblLayers] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblLayers] violates foreign key constraint for [tblCodeDefs].[fkeyLayer]') WHERE (SELECT fkeyLayer FROM tblCodeDefs WHERE fkeyLayer = OLD.keyLayers) IS NOT NULL; END Y))y1triggeron_delete_key_cascade_tblLayers_tblCrdBgImageData_fkeyLayertblLayersCREATE TRIGGER on_delete_key_cascade_tblLayers_tblCrdBgImageData_fkeyLayer BEFORE DELETE ON [tblLayers] FOR EACH ROW BEGIN DELETE FROM tblCrdBgImageData WHERE tblCrdBgImageData.fkeyLayer = OLD.keyLayers; END c*)u1triggeron_delete_key_forbide_tblLayers_tblLineAlntRoads_fkeyLayertblLayersCREATE TRIGGER on_delete_key_forbide_tblLayers_tblLineAlntRoads_fkeyLayer BEFORE DELETE ON [tblLayers] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblLayers] violates foreign key constraint for [tblLineAlntRoads].[fkeyLayer]') WHERE (SELECT fkeyLayer FROM tblLineAlntRoads WHERE fkeyLayer = OLD.keyLayers) IS NOT NULL; END C+)e1itriggeron_delete_key_forbide_tblLayers_tblLineProps_fkeyLayertblLayersCREATE TRIGGER on_delete_key_forbide_tblLayers_tblLineProps_fkeyLayer BEFORE DELETE ON [tblLayers] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblLayers] violates foreign key constraint for [tblLineProps].[fkeyLayer]') WHERE (SELECT fkeyLayer FROM tblLineProps WHERE fkeyLayer = OLD.keyLayers) IS NOT NULL; END ;,)a1]triggeron_delete_key_forbide_tblLayers_tblSoPoints_fkeyLayertblLayersCREATE TRIGGER on_delete_key_forbide_tblLayers_tblSoPoints_fkeyLayer BEFORE DELETE ON [tblLayers] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblLayers] violates foreign key constraint for [tblSoPoints].[fkeyLayer]') WHERE (SELECT fkeyLayer FROM tblSoPoints WHERE fkeyLayer = OLD.keyLayers) IS NOT NULL; END s-)}11triggeron_delete_key_forbide_tblLayers_tblVectorImageRefs_fkeyLayertblLayersCREATE TRIGGER on_delete_key_forbide_tblLayers_tblVectorImageRefs_fkeyLayer BEFORE DELETE ON [tblLayers] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblLayers] violates foreign key constraint for [tblVectorImageRefs].[fkeyLayer]') WHERE (SELECT fkeyLayer FROM tblVectorImageRefs WHERE fkeyLayer = OLD.keyLayers) IS NOT NULL; END uu.)9Itriggeron_update_fk_tblLineAlntHals_fkeyCrdDatasettblLineAlntHalsCREATE TRIGGER on_update_fk_tblLineAlntHals_fkeyCrdDataset BEFORE UPDATE OF [fkeyCrdDataset] ON [tblLineAlntHals] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblLineAlntHals].[fkeyCrdDataset]') WHERE NEW.fkeyCrdDataset IS NOT NULL AND (SELECT keyDataset FROM tblDatasets WHERE keyDataset = NEW.fkeyCrdDataset) IS NULL; END c/)-IItriggeron_update_fk_tblLineAlntHals_fkeySoPointtblLineAlntHalsCREATE TRIGGER on_update_fk_tblLineAlntHals_fkeySoPoint BEFORE UPDATE OF [fkeySoPoint] ON [tblLineAlntHals] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblLineAlntHals].[fkeySoPoint]') WHERE NEW.fkeySoPoint IS NOT NULL AND (SELECT keySoPoint FROM tblSoPoints WHERE keySoPoint = NEW.fkeySoPoint) IS NULL; END }}0) I!triggeron_delete_key_cascade_tblLineAlntHals_tblLineAlntHElmIps_fkeyHaltblLineAlntHalsCREATE TRIGGER on_delete_key_cascade_tblLineAlntHals_tblLineAlntHElmIps_fkeyHal BEFORE DELETE ON [tblLineAlntHals] FOR EACH ROW BEGIN DELETE FROM tblLineAlntHElmIps WHERE tblLineAlntHElmIps.fkeyHal = OLD.keyHal; END}uflrx~ &,28>DJPV\bhntz "(.4:@FLRX^djpv|`ZTNHB<60*$t srqonmlkjihgf !#$%&'()*+,-./0123 4 5 6 7 89:;<=>?@ABCDEFGHIJ K!L"M#N$O%P&R'S(T)U*V+W,X-Y.Z/[0\1]2^3_4`5a6b7c8d9e:f;gj?k@lAmBnCoDpEqFrGsHtIuJvKwLxMyNzO{P|Q}R~STUVWXYZ[\] _ ` a bcde o1)I triggeron_delete_key_cascade_tblLineAlntHals_tblLineAlntHElms_fkeyHaltblLineAlntHalsCREATE TRIGGER on_delete_key_cascade_tblLineAlntHals_tblLineAlntHElms_fkeyHal BEFORE DELETE ON [tblLineAlntHals] FOR EACH ROW BEGIN DELETE FROM tblLineAlntHElms WHERE tblLineAlntHElms.fkeyHal = OLD.keyHal; END ww2)I5triggeron_delete_key_forbide_tblLineAlntHals_tblLineAlntRoads_fkeyHaltblLineAlntHalsCREATE TRIGGER on_delete_key_forbide_tblLineAlntHals_tblLineAlntRoads_fkeyHal BEFORE DELETE ON [tblLineAlntHals] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblLineAlntHals] violates foreign key constraint for [tblLineAlntRoads].[fkeyHal]') WHERE (SELECT fkeyHal FROM tblLineAlntRoads WHERE fkeyHal = OLD.keyHal) IS NOT NULL; END M3)5U triggeron_update_field_tblLineAlntHElmIps_fkeyHaltblLineAlntHElmIpsCREATE TRIGGER on_update_field_tblLineAlntHElmIps_fkeyHal BEFORE UPDATE OF [fkeyHal] ON [tblLineAlntHElmIps] BEGIN SELECT RAISE(ABORT,'Field [tblLineAlntHElmIps].[fkeyHal] can be set only once in Insert'); END _4)EUtriggeron_update_fk_tblLineAlntHElmIps_fkeyCrdDatasettblLineAlntHElmIpsCREATE TRIGGER on_update_fk_tblLineAlntHElmIps_fkeyCrdDataset BEFORE UPDATE OF [fkeyCrdDataset] ON [tblLineAlntHElmIps] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblLineAlntHElmIps].[fkeyCrdDataset]') WHERE (SELECT keyDataset FROM tblDatasets WHERE keyDataset = NEW.fkeyCrdDataset) IS NULL; END {{5)9Umtriggeron_update_fk_tblLineAlntHElmIps_fkeySoPointtblLineAlntHElmIpsCREATE TRIGGER on_update_fk_tblLineAlntHElmIps_fkeySoPoint BEFORE UPDATE OF [fkeySoPoint] ON [tblLineAlntHElmIps] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblLineAlntHElmIps].[fkeySoPoint]') WHERE NEW.fkeySoPoint IS NOT NULL AND (SELECT keySoPoint FROM tblSoPoints WHERE keySoPoint = NEW.fkeySoPoint) IS NULL; END 96)-Mqtriggeron_update_field_tblLineAlntHElms_fkeyHaltblLineAlntHElmsCREATE TRIGGER on_update_field_tblLineAlntHElms_fkeyHal BEFORE UPDATE OF [fkeyHal] ON [tblLineAlntHElms] BEGIN SELECT RAISE(ABORT,'Field [tblLineAlntHElms].[fkeyHal] can be set only once in Insert'); END M7))Mtriggeron_update_fk_tblLineAlntRoads_fkeyLayertblLineAlntRoadsCREATE TRIGGER on_update_fk_tblLineAlntRoads_fkeyLayer BEFORE UPDATE OF [fkeyLayer] ON [tblLineAlntRoads] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblLineAlntRoads].[fkeyLayer]') WHERE NEW.fkeyLayer IS NOT NULL AND (SELECT keyLayers FROM tblLayers WHERE keyLayers = NEW.fkeyLayer) IS NULL; END 58)!Mutriggeron_update_fk_tblLineAlntRoads_fkeyHaltblLineAlntRoadsCREATE TRIGGER on_update_fk_tblLineAlntRoads_fkeyHal BEFORE UPDATE OF [fkeyHal] ON [tblLineAlntRoads] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblLineAlntRoads].[fkeyHal]') WHERE NEW.fkeyHal IS NOT NULL AND (SELECT keyHal FROM tblLineAlntHals WHERE keyHal = NEW.fkeyHal) IS NULL; END 59)!Mutriggeron_update_fk_tblLineAlntRoads_fkeyValtblLineAlntRoadsCREATE TRIGGER on_update_fk_tblLineAlntRoads_fkeyVal BEFORE UPDATE OF [fkeyVal] ON [tblLineAlntRoads] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblLineAlntRoads].[fkeyVal]') WHERE NEW.fkeyVal IS NOT NULL AND (SELECT keyVal FROM tblLineAlntVals WHERE keyVal = NEW.fkeyVal) IS NULL; END E:)%Mtriggeron_update_fk_tblLineAlntRoads_fkeyXsSftblLineAlntRoadsCREATE TRIGGER on_update_fk_tblLineAlntRoads_fkeyXsSf BEFORE UPDATE OF [fkeyXsSf] ON [tblLineAlntRoads] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblLineAlntRoads].[fkeyXsSf]') WHERE NEW.fkeyXsSf IS NOT NULL AND (SELECT keyXsSf FROM tblLineAlntXsSf WHERE keyXsSf = NEW.fkeyXsSf) IS NULL; END MM/;)%Metriggeron_delete_key_cascade_tblLineAlntRoads_tblCrdFindStaInfo_fkeyAlignmenttblLineAlntRoadsCREATE TRIGGER on_delete_key_cascade_tblLineAlntRoads_tblCrdFindStaInfo_fkeyAlignment BEFORE DELETE ON [tblLineAlntRoads] FOR EACH ROW BEGIN DELETE FROM tblCrdFindStaInfo WHERE tblCrdFindStaInfo.fkeyAlignment = OLD.keyAlignment; END q<)M triggeron_delete_key_cascade_tblLineAlntRoads_tblPtsToRoads_fkeyAlnttblLineAlntRoadsCREATE TRIGGER on_delete_key_cascade_tblLineAlntRoads_tblPtsToRoads_fkeyAlnt BEFORE DELETE ON [tblLineAlntRoads] FOR EACH ROW BEGIN DELETE FROM tblPtsToRoads WHERE tblPtsToRoads.fkeyAlnt = OLD.keyAlignment; END MM/=)%Metriggeron_delete_key_cascade_tblLineAlntRoads_tblXSectSurveyPts_fkeyAlignmenttblLineAlntRoadsCREATE TRIGGER on_delete_key_cascade_tblLineAlntRoads_tblXSectSurveyPts_fkeyAlignment BEFORE DELETE ON [tblLineAlntRoads] FOR EACH ROW BEGIN DELETE FROM tblXSectSurveyPts WHERE tblXSectSurveyPts.fkeyAlignment = OLD.keyAlignment; END uu>)9Itriggeron_update_fk_tblLineAlntVals_fkeyCrdDatasettblLineAlntValsCREATE TRIGGER on_update_fk_tblLineAlntVals_fkeyCrdDataset BEFORE UPDATE OF [fkeyCrdDataset] ON [tblLineAlntVals] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblLineAlntVals].[fkeyCrdDataset]') WHERE NEW.fkeyCrdDataset IS NOT NULL AND (SELECT keyDataset FROM tblDatasets WHERE keyDataset = NEW.fkeyCrdDataset) IS NULL; END c?)-IItriggeron_update_fk_tblLineAlntVals_fkeySoPointtblLineAlntValsCREATE TRIGGER on_update_fk_tblLineAlntVals_fkeySoPoint BEFORE UPDATE OF [fkeySoPoint] ON [tblLineAlntVals] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblLineAlntVals].[fkeySoPoint]') WHERE NEW.fkeySoPoint IS NOT NULL AND (SELECT keySoPoint FROM tblSoPoints WHERE keySoPoint = NEW.fkeySoPoint) IS NULL; END ww@)I5triggeron_delete_key_forbide_tblLineAlntVals_tblLineAlntRoads_fkeyValtblLineAlntValsCREATE TRIGGER on_delete_key_forbide_tblLineAlntVals_tblLineAlntRoads_fkeyVal BEFORE DELETE ON [tblLineAlntVals] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblLineAlntVals] violates foreign key constraint for [tblLineAlntRoads].[fkeyVal]') WHERE (SELECT fkeyVal FROM tblLineAlntRoads WHERE fkeyVal = OLD.keyVal) IS NOT NULL; END }}A) I!triggeron_delete_key_cascade_tblLineAlntVals_tblLineAlntVElmLSs_fkeyValtblLineAlntValsCREATE TRIGGER on_delete_key_cascade_tblLineAlntVals_tblLineAlntVElmLSs_fkeyVal BEFORE DELETE ON [tblLineAlntVals] FOR EACH ROW BEGIN DELETE FROM tblLineAlntVElmLSs WHERE tblLineAlntVElmLSs.fkeyVal = OLD.keyVal; END oB)I triggeron_delete_key_cascade_tblLineAlntVals_tblLineAlntVElms_fkeyValtblLineAlntValsCREATE TRIGGER on_delete_key_cascade_tblLineAlntVals_tblLineAlntVElms_fkeyVal BEFORE DELETE ON [tblLineAlntVals] FOR EACH ROW BEGIN DELETE FROM tblLineAlntVElms WHERE tblLineAlntVElms.fkeyVal = OLD.keyVal; END MC)5U triggeron_update_field_tblLineAlntVElmLSs_fkeyValtblLineAlntVElmLSsCREATE TRIGGER on_update_field_tblLineAlntVElmLSs_fkeyVal BEFORE UPDATE OF [fkeyVal] ON [tblLineAlntVElmLSs] BEGIN SELECT RAISE(ABORT,'Field [tblLineAlntVElmLSs].[fkeyVal] can be set only once in Insert'); END 9D)-Mqtriggeron_update_field_tblLineAlntVElms_fkeyValtblLineAlntVElmsCREATE TRIGGER on_update_field_tblLineAlntVElms_fkeyVal BEFORE UPDATE OF [fkeyVal] ON [tblLineAlntVElms] BEGIN SELECT RAISE(ABORT,'Field [tblLineAlntVElms].[fkeyVal] can be set only once in Insert'); END kkE) IItriggeron_delete_key_forbide_tblLineAlntXsSf_tblLineAlntRoads_fkeyXsSftblLineAlntXsSfCREATE TRIGGER on_delete_key_forbide_tblLineAlntXsSf_tblLineAlntRoads_fkeyXsSf BEFORE DELETE ON [tblLineAlntXsSf] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblLineAlntXsSf] violates foreign key constraint for [tblLineAlntRoads].[fkeyXsSf]') WHERE (SELECT fkeyXsSf FROM tblLineAlntRoads WHERE fkeyXsSf = OLD.keyXsSf) IS NOT NULL; END 55GF)1I triggeron_delete_key_cascade_tblLineAlntXsSf_tblLineAlntXsSfToTemplates_fkeyXsSftblLineAlntXsSfCREATE TRIGGER on_delete_key_cascade_tblLineAlntXsSf_tblLineAlntXsSfToTemplates_fkeyXsSf BEFORE DELETE ON [tblLineAlntXsSf] FOR EACH ROW BEGIN DELETE FROM tblLineAlntXsSfToTemplates WHERE tblLineAlntXsSfToTemplates.fkeyXsSf = OLD.keyXsSf; END WW%G)Yuutriggeron_update_field_tblLineAlntXsSfToTemplates_fkeyXsSftblLineAlntXsSfToTemplatesCREATE TRIGGER on_update_field_tblLineAlntXsSfToTemplates_fkeyXsSf BEFORE UPDATE OF [fkeyXsSf] ON [tblLineAlntXsSfToTemplates] BEGIN SELECT RAISE(ABORT,'Field [tblLineAlntXsSfToTemplates].[fkeyXsSf] can be set only once in Insert'); END __H)Yuetriggeron_update_fk_tblLineAlntXsSfToTemplates_fkeyXTplatetblLineAlntXsSfToTemplatesCREATE TRIGGER on_update_fk_tblLineAlntXsSfToTemplates_fkeyXTplate BEFORE UPDATE OF [fkeyXTplate] ON [tblLineAlntXsSfToTemplates] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblLineAlntXsSfToTemplates].[fkeyXTplate]') WHERE (SELECT keyRdTplate FROM tblXSectTplates WHERE keyRdTplate = NEW.fkeyXTplate) IS NULL; END I)%M)triggeron_update_fk_tblLinePlotAttrs_fkeyLinetblLinePlotAttrsCREATE TRIGGER on_update_fk_tblLinePlotAttrs_fkeyLine BEFORE UPDATE OF [fkeyLine] ON [tblLinePlotAttrs] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblLinePlotAttrs].[fkeyLine]') WHERE (SELECT fkeyPtList FROM tblLineProps WHERE fkeyPtList = NEW.fkeyLine) IS NULL; END )J))=etriggeron_update_field_tblLineProps_fkeyPtListtblLinePropsCREATE TRIGGER on_update_field_tblLineProps_fkeyPtList BEFORE UPDATE OF [fkeyPtList] ON [tblLineProps] BEGIN SELECT RAISE(ABORT,'Field [tblLineProps].[fkeyPtList] can be set only once in Insert'); END 1K)-=qtriggeron_update_field_tblLineProps_fkeyCodeDeftblLinePropsCREATE TRIGGER on_update_field_tblLineProps_fkeyCodeDef BEFORE UPDATE OF [fkeyCodeDef] ON [tblLineProps] BEGIN SELECT RAISE(ABORT,'Field [tblLineProps].[fkeyCodeDef] can be set only once in Insert'); END %L)=mtriggeron_update_fk_tblLineProps_fkeyLayertblLinePropsCREATE TRIGGER on_update_fk_tblLineProps_fkeyLayer BEFORE UPDATE OF [fkeyLayer] ON [tblLineProps] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblLineProps].[fkeyLayer]') WHERE NEW.fkeyLayer IS NOT NULL AND (SELECT keyLayers FROM tblLayers WHERE keyLayers = NEW.fkeyLayer) IS NULL; END eM)}= triggeron_delete_key_cascade_tblLineProps_tblLinePlotAttrs_fkeyLinetblLinePropsCREATE TRIGGER on_delete_key_cascade_tblLineProps_tblLinePlotAttrs_fkeyLine BEFORE DELETE ON [tblLineProps] FOR EACH ROW BEGIN DELETE FROM tblLinePlotAttrs WHERE tblLinePlotAttrs.fkeyLine = OLD.fkeyPtList; END wwN)QU]triggeron_update_field_tblMissingLineMeas_fkeyCrdRawMeastblMissingLineMeasCREATE TRIGGER on_update_field_tblMissingLineMeas_fkeyCrdRawMeas BEFORE UPDATE OF [fkeyCrdRawMeas] ON [tblMissingLineMeas] BEGIN SELECT RAISE(ABORT,'Field [tblMissingLineMeas].[fkeyCrdRawMeas] can be set only once in Insert'); END AO)9Umtriggeron_update_fk_tblMissingLineMeas_fkeyFirstPttblMissingLineMeasCREATE TRIGGER on_update_fk_tblMissingLineMeas_fkeyFirstPt BEFORE UPDATE OF [fkeyFirstPt] ON [tblMissingLineMeas] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblMissingLineMeas].[fkeyFirstPt]') WHERE (SELECT keySoPoint FROM tblSoPoints WHERE keySoPoint = NEW.fkeyFirstPt) IS NULL; END KP)=U}triggeron_update_fk_tblMissingLineMeas_fkeySecondPttblMissingLineMeasCREATE TRIGGER on_update_fk_tblMissingLineMeas_fkeySecondPt BEFORE UPDATE OF [fkeySecondPt] ON [tblMissingLineMeas] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblMissingLineMeas].[fkeySecondPt]') WHERE (SELECT keySoPoint FROM tblSoPoints WHERE keySoPoint = NEW.fkeySecondPt) IS NULL; END cR)Iqtriggeron_delete_from_tblObsEquipmenttblObsEquipmentCREATE TRIGGER on_delete_from_tblObsEquipment BEFORE DELETE ON [tblObsEquipment] BEGIN SELECT RAISE(ABORT,'Records removal is not allowed on table [tblObsEquipment]'); ENDQ)Utriggeron_delete_from_tblMissingLineMeastblMissingLineMeasCREATE TRIGGER on_delete_from_tblMissingLineMeas BEFORE DELETE ON [tblMissingLineMeas] BEGIN SELECT RAISE(ABORT,'Records removal is not allowed on table [tblMissingLineMeas]'); END ##YS)Eetriggeron_delete_from_tblPhotoCameratblPhotoCameraCREATE TRIGGER on_delete_from_tblPhotoCamera BEFORE DELETE ON [tblPhotoCamera] BEGIN SELECT RAISE(ABORT,'Records removal is not allowed on table [tblPhotoCamera]'); END UT)A]triggeron_update_fk_tblPhotoCamOriPoints_fkeySoPointtblPhotoCamOriPointsCREATE TRIGGER on_update_fk_tblPhotoCamOriPoints_fkeySoPoint BEFORE UPDATE OF [fkeySoPoint] ON [tblPhotoCamOriPoints] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblPhotoCamOriPoints].[fkeySoPoint]') WHERE (SELECT keySoPoint FROM tblSoPoints WHERE keySoPoint = NEW.fkeySoPoint) IS NULL; END U)!A%triggeron_update_fk_tblPhotoImage_fkeyCameratblPhotoImageCREATE TRIGGER on_update_fk_tblPhotoImage_fkeyCamera BEFORE UPDATE OF [fkeyCamera] ON [tblPhotoImage] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblPhotoImage].[fkeyCamera]') WHERE (SELECT keyCamera FROM tblPhotoCamera WHERE keyCamera = NEW.fkeyCamera) IS NULL; END OO-V))Aitriggeron_delete_key_cascade_tblPhotoImage_tblPhotoCamOriPoints_fkeyPhotoImagetblPhotoImageCREATE TRIGGER on_delete_key_cascade_tblPhotoImage_tblPhotoCamOriPoints_fkeyPhotoImage BEFORE DELETE ON [tblPhotoImage] FOR EACH ROW BEGIN DELETE FROM tblPhotoCamOriPoints WHERE tblPhotoCamOriPoints.fkeyPhotoImage = OLD.keyImage; END wwW)A-triggeron_delete_key_cascade_tblPhotoImage_tblPhotoPolygon_fkeyPhotoImagetblPhotoImageCREATE TRIGGER on_delete_key_cascade_tblPhotoImage_tblPhotoPolygon_fkeyPhotoImage BEFORE DELETE ON [tblPhotoImage] FOR EACH ROW BEGIN DELETE FROM tblPhotoPolygon WHERE tblPhotoPolygon.fkeyPhotoImage = OLD.keyImage; END MM/X)%Iitriggeron_delete_key_cascade_tblPhotoPolygon_tblPhotoPolyPts_fkeyPhotoPolygontblPhotoPolygonCREATE TRIGGER on_delete_key_cascade_tblPhotoPolygon_tblPhotoPolyPts_fkeyPhotoPolygon BEFORE DELETE ON [tblPhotoPolygon] FOR EACH ROW BEGIN DELETE FROM tblPhotoPolyPts WHERE tblPhotoPolyPts.fkeyPhotoPolygon = OLD.keyPhotoPolygon; END gY)AI=triggeron_delete_key_cascade_tblPhotoPolygon_tblPhotoPolyToSessions_fkeyPhotoPolygontblPhotoPolygonCREATE TRIGGER on_delete_key_cascade_tblPhotoPolygon_tblPhotoPolyToSessions_fkeyPhotoPolygon BEFORE DELETE ON [tblPhotoPolygon] FOR EACH ROW BEGIN DELETE FROM tblPhotoPolyToSessions WHERE tblPhotoPolyToSessions.fkeyPhotoPolygon = OLD.keyPhotoPolygon; END GG5Z)eetriggeron_update_field_tblPhotoPolyToSessions_fkeyScanSessiontblPhotoPolyToSessionsCREATE TRIGGER on_update_field_tblPhotoPolyToSessions_fkeyScanSession BEFORE UPDATE OF [fkeyScanSession] ON [tblPhotoPolyToSessions] BEGIN SELECT RAISE(ABORT,'Field [tblPhotoPolyToSessions].[fkeyScanSession] can be set only once in Insert'); END ??=[)ie%triggeron_update_field_tblPhotoPolyToSessions_fkeyPhotoPolygontblPhotoPolyToSessionsCREATE TRIGGER on_update_field_tblPhotoPolyToSessions_fkeyPhotoPolygon BEFORE UPDATE OF [fkeyPhotoPolygon] ON [tblPhotoPolyToSessions] BEGIN SELECT RAISE(ABORT,'Field [tblPhotoPolyToSessions].[fkeyPhotoPolygon] can be set only once in Insert'); END \)MYQtriggeron_delete_key_cascade_tblPhotoScanSession_tblPhotoPolyToSessions_fkeyScanSessiontblPhotoScanSessionCREATE TRIGGER on_delete_key_cascade_tblPhotoScanSession_tblPhotoPolyToSessions_fkeyScanSession BEFORE DELETE ON [tblPhotoScanSession] FOR EACH ROW BEGIN DELETE FROM tblPhotoPolyToSessions WHERE tblPhotoPolyToSessions.fkeyScanSession = OLD.keyScanSession; END ;])1A}triggeron_update_field_tblPtsToRoads_fkeyStationtblPtsToRoadsCREATE TRIGGER on_update_field_tblPtsToRoads_fkeyStation BEFORE UPDATE OF [fkeyStation] ON [tblPtsToRoads] BEGIN SELECT RAISE(ABORT,'Field [tblPtsToRoads].[fkeyStation] can be set only once in Insert'); END #^)%AYtriggeron_update_field_tblPtsToRoads_fkeyAlnttblPtsToRoadsCREATE TRIGGER on_update_field_tblPtsToRoads_fkeyAlnt BEFORE UPDATE OF [fkeyAlnt] ON [tblPtsToRoads] BEGIN SELECT RAISE(ABORT,'Field [tblPtsToRoads].[fkeyAlnt] can be set only once in Insert'); END i_)}E triggeron_delete_key_cascade_tblSetOfPoints_tblLineProps_fkeyPtListtblSetOfPointsCREATE TRIGGER on_delete_key_cascade_tblSetOfPoints_tblLineProps_fkeyPtList BEFORE DELETE ON [tblSetOfPoints] FOR EACH ROW BEGIN DELETE FROM tblLineProps WHERE tblLineProps.fkeyPtList = OLD.keySetOfPoints; END MM/`)%Emtriggeron_delete_key_cascade_tblSetOfPoints_tblSetOfPtsPoints_fkeySetOfPointstblSetOfPointsCREATE TRIGGER on_delete_key_cascade_tblSetOfPoints_tblSetOfPtsPoints_fkeySetOfPoints BEFORE DELETE ON [tblSetOfPoints] FOR EACH ROW BEGIN DELETE FROM tblSetOfPtsPoints WHERE tblSetOfPtsPoints.fkeySetOfPoints = OLD.keySetOfPoints; END yya)QQ]triggeron_update_field_tblSetOfPtsPoints_fkeySetOfPointstblSetOfPtsPointsCREATE TRIGGER on_update_field_tblSetOfPtsPoints_fkeySetOfPoints BEFORE UPDATE OF [fkeySetOfPoints] ON [tblSetOfPtsPoints] BEGIN SELECT RAISE(ABORT,'Field [tblSetOfPtsPoints].[fkeySetOfPoints] can be set only once in Insert'); END cb)AQ-triggeron_update_field_tblSetOfPtsPoints_fkeySoPointtblSetOfPtsPointsCREATE TRIGGER on_update_field_tblSetOfPtsPoints_fkeySoPoint BEFORE UPDATE OF [fkeySoPoint] ON [tblSetOfPtsPoints] BEGIN SELECT RAISE(ABORT,'Field [tblSetOfPtsPoints].[fkeySoPoint] can be set only once in Insert'); END c)9atriggeron_update_fk_tblSoPoints_fkeyLayertblSoPointsCREATE TRIGGER on_update_fk_tblSoPoints_fkeyLayer BEFORE UPDATE OF [fkeyLayer] ON [tblSoPoints] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblSoPoints].[fkeyLayer]') WHERE NEW.fkeyLayer IS NOT NULL AND (SELECT keyLayers FROM tblLayers WHERE keyLayers = NEW.fkeyLayer) IS NULL; END d))9Itriggeron_update_fk_tblSoPoints_fkeyStationDeftblSoPointsCREATE TRIGGER on_update_fk_tblSoPoints_fkeyStationDef BEFORE UPDATE OF [fkeyStationDef] ON [tblSoPoints] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblSoPoints].[fkeyStationDef]') WHERE (SELECT keyStation FROM tblStations WHERE keyStation = NEW.fkeyStationDef) IS NULL; END ie)u9triggeron_delete_key_forbide_tblSoPoints_tblCodeAttrVal_fkeyPointtblSoPointsCREATE TRIGGER on_delete_key_forbide_tblSoPoints_tblCodeAttrVal_fkeyPoint BEFORE DELETE ON [tblSoPoints] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblSoPoints] violates foreign key constraint for [tblCodeAttrVal].[fkeyPoint]') WHERE (SELECT fkeyPoint FROM tblCodeAttrVal WHERE fkeyPoint = OLD.keySoPoint) IS NOT NULL; END Kf)q9etriggeron_delete_key_cascade_tblSoPoints_tblCodesToPts_fkeyPointtblSoPointsCREATE TRIGGER on_delete_key_cascade_tblSoPoints_tblCodesToPts_fkeyPoint BEFORE DELETE ON [tblSoPoints] FOR EACH ROW BEGIN DELETE FROM tblCodesToPts WHERE tblCodesToPts.fkeyPoint = OLD.keySoPoint; END mg)u9%triggeron_delete_key_forbide_tblSoPoints_tblCrdBaseSt_fkeySoPointtblSoPointsCREATE TRIGGER on_delete_key_forbide_tblSoPoints_tblCrdBaseSt_fkeySoPoint BEFORE DELETE ON [tblSoPoints] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblSoPoints] violates foreign key constraint for [tblCrdBaseSt].[fkeySoPoint]') WHERE (SELECT fkeySoPoint FROM tblCrdBaseSt WHERE fkeySoPoint = OLD.keySoPoint) IS NOT NULL; END qq h)9Utriggeron_delete_key_forbide_tblSoPoints_tblCrdBaseSt_fkeyKnownPointtblSoPointsCREATE TRIGGER on_delete_key_forbide_tblSoPoints_tblCrdBaseSt_fkeyKnownPoint BEFORE DELETE ON [tblSoPoints] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblSoPoints] violates foreign key constraint for [tblCrdBaseSt].[fkeyKnownPoint]') WHERE (SELECT fkeyKnownPoint FROM tblCrdBaseSt WHERE fkeyKnownPoint = OLD.keySoPoint) IS NOT NULL; END ggi) 9atriggeron_delete_key_forbide_tblSoPoints_tblCrdFindStaInfo_fkeySoPointtblSoPointsCREATE TRIGGER on_delete_key_forbide_tblSoPoints_tblCrdFindStaInfo_fkeySoPoint BEFORE DELETE ON [tblSoPoints] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblSoPoints] violates foreign key constraint for [tblCrdFindStaInfo].[fkeySoPoint]') WHERE (SELECT fkeySoPoint FROM tblCrdFindStaInfo WHERE fkeySoPoint = OLD.keySoPoint) IS NOT NULL; END oj)y9%triggeron_delete_key_forbide_tblSoPoints_tblCrdGnssOffset_fkeyAzPttblSoPointsCREATE TRIGGER on_delete_key_forbide_tblSoPoints_tblCrdGnssOffset_fkeyAzPt BEFORE DELETE ON [tblSoPoints] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblSoPoints] violates foreign key constraint for [tblCrdGnssOffset].[fkeyAzPt]') WHERE (SELECT fkeyAzPt FROM tblCrdGnssOffset WHERE fkeyAzPt = OLD.keySoPoint) IS NOT NULL; END #k)U91triggeron_delete_key_forbide_tblSoPoints_tblCrdPtl_fkeyP1tblSoPointsCREATE TRIGGER on_delete_key_forbide_tblSoPoints_tblCrdPtl_fkeyP1 BEFORE DELETE ON [tblSoPoints] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblSoPoints] violates foreign key constraint for [tblCrdPtl].[fkeyP1]') WHERE (SELECT fkeyP1 FROM tblCrdPtl WHERE fkeyP1 = OLD.keySoPoint) IS NOT NULL; END #l)U91triggeron_delete_key_forbide_tblSoPoints_tblCrdPtl_fkeyP2tblSoPointsCREATE TRIGGER on_delete_key_forbide_tblSoPoints_tblCrdPtl_fkeyP2 BEFORE DELETE ON [tblSoPoints] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblSoPoints] violates foreign key constraint for [tblCrdPtl].[fkeyP2]') WHERE (SELECT fkeyP2 FROM tblCrdPtl WHERE fkeyP2 = OLD.keySoPoint) IS NOT NULL; END wwm)9Itriggeron_delete_key_forbide_tblSoPoints_tblLineAlntHals_fkeySoPointtblSoPointsCREATE TRIGGER on_delete_key_forbide_tblSoPoints_tblLineAlntHals_fkeySoPoint BEFORE DELETE ON [tblSoPoints] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblSoPoints] violates foreign key constraint for [tblLineAlntHals].[fkeySoPoint]') WHERE (SELECT fkeySoPoint FROM tblLineAlntHals WHERE fkeySoPoint = OLD.keySoPoint) IS NOT NULL; END __n) 9mtriggeron_delete_key_forbide_tblSoPoints_tblLineAlntHElmIps_fkeySoPointtblSoPointsCREATE TRIGGER on_delete_key_forbide_tblSoPoints_tblLineAlntHElmIps_fkeySoPoint BEFORE DELETE ON [tblSoPoints] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblSoPoints] violates foreign key constraint for [tblLineAlntHElmIps].[fkeySoPoint]') WHERE (SELECT fkeySoPoint FROM tblLineAlntHElmIps WHERE fkeySoPoint = OLD.keySoPoint) IS NOT NULL; END wwo)9Itriggeron_delete_key_forbide_tblSoPoints_tblLineAlntVals_fkeySoPointtblSoPointsCREATE TRIGGER on_delete_key_forbide_tblSoPoints_tblLineAlntVals_fkeySoPoint BEFORE DELETE ON [tblSoPoints] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblSoPoints] violates foreign key constraint for [tblLineAlntVals].[fkeySoPoint]') WHERE (SELECT fkeySoPoint FROM tblLineAlntVals WHERE fkeySoPoint = OLD.keySoPoint) IS NOT NULL; END __p) 9mtriggeron_delete_key_forbide_tblSoPoints_tblMissingLineMeas_fkeyFirstPttblSoPointsCREATE TRIGGER on_delete_key_forbide_tblSoPoints_tblMissingLineMeas_fkeyFirstPt BEFORE DELETE ON [tblSoPoints] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblSoPoints] violates foreign key constraint for [tblMissingLineMeas].[fkeyFirstPt]') WHERE (SELECT fkeyFirstPt FROM tblMissingLineMeas WHERE fkeyFirstPt = OLD.keySoPoint) IS NOT NULL; END UU'q)9}triggeron_delete_key_forbide_tblSoPoints_tblMissingLineMeas_fkeySecondPttblSoPointsCREATE TRIGGER on_delete_key_forbide_tblSoPoints_tblMissingLineMeas_fkeySecondPt BEFORE DELETE ON [tblSoPoints] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblSoPoints] violates foreign key constraint for [tblMissingLineMeas].[fkeySecondPt]') WHERE (SELECT fkeySecondPt FROM tblMissingLineMeas WHERE fkeySecondPt = OLD.keySoPoint) IS NOT NULL; END mmr)9Itriggeron_delete_key_cascade_tblSoPoints_tblPhotoCamOriPoints_fkeySoPointtblSoPointsCREATE TRIGGER on_delete_key_cascade_tblSoPoints_tblPhotoCamOriPoints_fkeySoPoint BEFORE DELETE ON [tblSoPoints] FOR EACH ROW BEGIN DELETE FROM tblPhotoCamOriPoints WHERE tblPhotoCamOriPoints.fkeySoPoint = OLD.keySoPoint; END ws) 9%triggeron_delete_key_cascade_tblSoPoints_tblPointPlotAttrs_fkeySoPointtblSoPointsCREATE TRIGGER on_delete_key_cascade_tblSoPoints_tblPointPlotAttrs_fkeySoPoint BEFORE DELETE ON [tblSoPoints] FOR EACH ROW BEGIN DELETE FROM tblPointPlotAttrs WHERE tblPointPlotAttrs.fkeySoPoint = OLD.keySoPoint; END qq t)9Etriggeron_delete_key_cascade_tblSoPoints_tblPtsToExternalNotes_fkeyPointtblSoPointsCREATE TRIGGER on_delete_key_cascade_tblSoPoints_tblPtsToExternalNotes_fkeyPoint BEFORE DELETE ON [tblSoPoints] FOR EACH ROW BEGIN DELETE FROM tblPtsToExternalNotes WHERE tblPtsToExternalNotes.fkeyPoint = OLD.keySoPoint; END ??=u)9!triggeron_delete_key_forbide_tblSoPoints_tblPtsToStakedPts_fkeyDesignPointtblSoPointsCREATE TRIGGER on_delete_key_forbide_tblSoPoints_tblPtsToStakedPts_fkeyDesignPoint BEFORE DELETE ON [tblSoPoints] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblSoPoints] violates foreign key constraint for [tblPtsToStakedPts].[fkeyDesignPoint]') WHERE (SELECT fkeyDesignPoint FROM tblPtsToStakedPts WHERE fkeyDesignPoint = OLD.keySoPoint) IS NOT NULL; END wv) 9%triggeron_delete_key_cascade_tblSoPoints_tblSetOfPtsPoints_fkeySoPointtblSoPointsCREATE TRIGGER on_delete_key_cascade_tblSoPoints_tblSetOfPtsPoints_fkeySoPoint BEFORE DELETE ON [tblSoPoints] FOR EACH ROW BEGIN DELETE FROM tblSetOfPtsPoints WHERE tblSetOfPtsPoints.fkeySoPoint = OLD.keySoPoint; END Gw)q9]triggeron_delete_key_cascade_tblSoPoints_tblStations_fkeySoPointtblSoPointsCREATE TRIGGER on_delete_key_cascade_tblSoPoints_tblStations_fkeySoPoint BEFORE DELETE ON [tblSoPoints] FOR EACH ROW BEGIN DELETE FROM tblStations WHERE tblStations.fkeySoPoint = OLD.keySoPoint; END WW%x)9ytriggeron_delete_key_forbide_tblSoPoints_tblTapeDimensionPts_fkeyFirstPttblSoPointsCREATE TRIGGER on_delete_key_forbide_tblSoPoints_tblTapeDimensionPts_fkeyFirstPt BEFORE DELETE ON [tblSoPoints] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblSoPoints] violates foreign key constraint for [tblTapeDimensionPts].[fkeyFirstPt]') WHERE (SELECT fkeyFirstPt FROM tblTapeDimensionPts WHERE fkeyFirstPt = OLD.keySoPoint) IS NOT NULL; END MM/y)9 triggeron_delete_key_forbide_tblSoPoints_tblTapeDimensionPts_fkeySecondPttblSoPointsCREATE TRIGGER on_delete_key_forbide_tblSoPoints_tblTapeDimensionPts_fkeySecondPt BEFORE DELETE ON [tblSoPoints] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblSoPoints] violates foreign key constraint for [tblTapeDimensionPts].[fkeySecondPt]') WHERE (SELECT fkeySecondPt FROM tblTapeDimensionPts WHERE fkeySecondPt = OLD.keySoPoint) IS NOT NULL; END ez)q9triggeron_delete_key_forbide_tblSoPoints_tblTsOccups_fkeySoPointtblSoPointsCREATE TRIGGER on_delete_key_forbide_tblSoPoints_tblTsOccups_fkeySoPoint BEFORE DELETE ON [tblSoPoints] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblSoPoints] violates foreign key constraint for [tblTsOccups].[fkeySoPoint]') WHERE (SELECT fkeySoPoint FROM tblTsOccups WHERE fkeySoPoint = OLD.keySoPoint) IS NOT NULL; END gg{) 9atriggeron_delete_key_forbide_tblSoPoints_tblXSectSurveyPts_fkeySoPointtblSoPointsCREATE TRIGGER on_delete_key_forbide_tblSoPoints_tblXSectSurveyPts_fkeySoPoint BEFORE DELETE ON [tblSoPoints] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblSoPoints] violates foreign key constraint for [tblXSectSurveyPts].[fkeySoPoint]') WHERE (SELECT fkeySoPoint FROM tblXSectSurveyPts WHERE fkeySoPoint = OLD.keySoPoint) IS NOT NULL; END ;|)9triggeron_update_fk_tblStations_fkeyDatasettblStationsCREATE TRIGGER on_update_fk_tblStations_fkeyDataset BEFORE UPDATE OF [fkeyDataset] ON [tblStations] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblStations].[fkeyDataset]') WHERE NEW.fkeyDataset IS NOT NULL AND (SELECT keyDataset FROM tblDatasets WHERE keyDataset = NEW.fkeyDataset) IS NULL; END ;})9triggeron_update_fk_tblStations_fkeySoPointtblStationsCREATE TRIGGER on_update_fk_tblStations_fkeySoPoint BEFORE UPDATE OF [fkeySoPoint] ON [tblStations] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblStations].[fkeySoPoint]') WHERE NEW.fkeySoPoint IS NOT NULL AND (SELECT keySoPoint FROM tblSoPoints WHERE keySoPoint = NEW.fkeySoPoint) IS NULL; END u~)y91triggeron_delete_key_forbide_tblStations_tblCrdDlShots_fkeyStationtblStationsCREATE TRIGGER on_delete_key_forbide_tblStations_tblCrdDlShots_fkeyStation BEFORE DELETE ON [tblStations] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblStations] violates foreign key constraint for [tblCrdDlShots].[fkeyStation]') WHERE (SELECT fkeyStation FROM tblCrdDlShots WHERE fkeyStation = OLD.keyStation) IS NOT NULL; END oo )9Utriggeron_delete_key_forbide_tblStations_tblCrdGnssOffset_fkeyStationtblStationsCREATE TRIGGER on_delete_key_forbide_tblStations_tblCrdGnssOffset_fkeyStation BEFORE DELETE ON [tblStations] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblStations] violates foreign key constraint for [tblCrdGnssOffset].[fkeyStation]') WHERE (SELECT fkeyStation FROM tblCrdGnssOffset WHERE fkeyStation = OLD.keyStation) IS NOT NULL; END QQ+)9triggeron_delete_key_forbide_tblStations_tblCrdGnssOffset_fkeyStationOrgtblStationsCREATE TRIGGER on_delete_key_forbide_tblStations_tblCrdGnssOffset_fkeyStationOrg BEFORE DELETE ON [tblStations] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblStations] violates foreign key constraint for [tblCrdGnssOffset].[fkeyStationOrg]') WHERE (SELECT fkeyStationOrg FROM tblCrdGnssOffset WHERE fkeyStationOrg = OLD.keyStation) IS NOT NULL; END WW%)9ytriggeron_delete_key_forbide_tblStations_tblCrdGnssPtlOffset_fkeyStationtblStationsCREATE TRIGGER on_delete_key_forbide_tblStations_tblCrdGnssPtlOffset_fkeyStation BEFORE DELETE ON [tblStations] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblStations] violates foreign key constraint for [tblCrdGnssPtlOffset].[fkeyStation]') WHERE (SELECT fkeyStation FROM tblCrdGnssPtlOffset WHERE fkeyStation = OLD.keyStation) IS NOT NULL; END MM/)9 triggeron_delete_key_forbide_tblStations_tblCrdGnssPtlOffset_fkeyStation1tblStationsCREATE TRIGGER on_delete_key_forbide_tblStations_tblCrdGnssPtlOffset_fkeyStation1 BEFORE DELETE ON [tblStations] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblStations] violates foreign key constraint for [tblCrdGnssPtlOffset].[fkeyStation1]') WHERE (SELECT fkeyStation1 FROM tblCrdGnssPtlOffset WHERE fkeyStation1 = OLD.keyStation) IS NOT NULL; END MM/)9 triggeron_delete_key_forbide_tblStations_tblCrdGnssPtlOffset_fkeyStation2tblStationsCREATE TRIGGER on_delete_key_forbide_tblStations_tblCrdGnssPtlOffset_fkeyStation2 BEFORE DELETE ON [tblStations] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblStations] violates foreign key constraint for [tblCrdGnssPtlOffset].[fkeyStation2]') WHERE (SELECT fkeyStation2 FROM tblCrdGnssPtlOffset WHERE fkeyStation2 = OLD.keyStation) IS NOT NULL; END UU') 9triggeron_delete_key_forbide_tblStations_tblCrdGnssRaw_fkeyRoverStationtblStationsCREATE TRIGGER on_delete_key_forbide_tblStations_tblCrdGnssRaw_fkeyRoverStation BEFORE DELETE ON [tblStations] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblStations] violates foreign key constraint for [tblCrdGnssRaw].[fkeyRoverStation]') WHERE (SELECT fkeyRoverStation FROM tblCrdGnssRaw WHERE fkeyRoverStation = OLD.keyStation) IS NOT NULL; END 7)i9Etriggeron_delete_key_cascade_tblStations_tblCrdPtl_fkeyStationtblStationsCREATE TRIGGER on_delete_key_cascade_tblStations_tblCrdPtl_fkeyStation BEFORE DELETE ON [tblStations] FOR EACH ROW BEGIN DELETE FROM tblCrdPtl WHERE tblCrdPtl.fkeyStation = OLD.keyStation; END --O)!9=triggeron_delete_key_forbide_tblStations_tblIdenticalPoints_fkeyLocalStationtblStationsCREATE TRIGGER on_delete_key_forbide_tblStations_tblIdenticalPoints_fkeyLocalStation BEFORE DELETE ON [tblStations] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblStations] violates foreign key constraint for [tblIdenticalPoints].[fkeyLocalStation]') WHERE (SELECT fkeyLocalStation FROM tblIdenticalPoints WHERE fkeyLocalStation = OLD.keyStation) IS NOT NULL; END AA;)9triggeron_delete_key_forbide_tblStations_tblIdenticalPoints_fkeyWgsStationtblStationsCREATE TRIGGER on_delete_key_forbide_tblStations_tblIdenticalPoints_fkeyWgsStation BEFORE DELETE ON [tblStations] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblStations] violates foreign key constraint for [tblIdenticalPoints].[fkeyWgsStation]') WHERE (SELECT fkeyWgsStation FROM tblIdenticalPoints WHERE fkeyWgsStation = OLD.keyStation) IS NOT NULL; END u)y91triggeron_delete_key_forbide_tblStations_tblPtsToRoads_fkeyStationtblStationsCREATE TRIGGER on_delete_key_forbide_tblStations_tblPtsToRoads_fkeyStation BEFORE DELETE ON [tblStations] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblStations] violates foreign key constraint for [tblPtsToRoads].[fkeyStation]') WHERE (SELECT fkeyStation FROM tblPtsToRoads WHERE fkeyStation = OLD.keyStation) IS NOT NULL; END ai )-9etriggeron_delete_key_forbide_tblStations_tblTape^ )!9Utriggeron_delete_key_cascade_tblStations_tblPtsToStakedPts_fkeyStakedStationtblStationsCREATE TRIGGER on_delete_key_cascade_tblStations_tblPtsToStakedPts_fkeyStakedStation BEFORE DELETE ON [tblStations] FOR EACH ROW BEGIN DELETE FROM tblPtsToStakedPts WHERE tblPtsToStakedPts.fkeyStakedStation = OLD.keyStation; ENDDimensionMeas_fkeyTargetStationtblStationsCREATE TRIGGER on_delete_key_forbide_tblStations_tblTapeDimensionMeas_fkeyTargetStation BEFORE DELETE ON [tblStations] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblStations] violates foreign key constraint for [tblTapeDimensionMeas].[fkeyTargetStation]') WHERE (SELECT fkeyTargetStation FROM tblTapeDimensionMeas WHERE fkeyTargetStation = OLD.keyStation) IS NOT NULL; END cc )9mtriggeron_delete_key_forbide_tblStations_tblTsShots_fkeyTargetStationtblStationsCREATE TRIGGER on_delete_key_forbide_tblStations_tblTsShots_fkeyTargetStation BEFORE DELETE ON [tblStations] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblStations] violates foreign key constraint for [tblTsShots].[fkeyTargetStation]') WHERE (SELECT fkeyTargetStation FROM tblTsShots WHERE fkeyTargetStation = OLD.keyStation) IS NOT NULL; END 33I )q]=triggeron_update_field_tblTapeDimensionMeas_fkeyTapeDimensionPtstblTapeDimensionMeasCREATE TRIGGER on_update_field_tblTapeDimensionMeas_fkeyTapeDimensionPts BEFORE UPDATE OF [fkeyTapeDimensionPts] ON [tblTapeDimensionMeas] BEGIN SELECT RAISE(ABORT,'Field [tblTapeDimensionMeas].[fkeyTapeDimensionPts] can be set only once in Insert'); END KK1 )e]triggeron_update_field_tblTapeDimensionMeas_fkeyTargetStationtblTapeDimensionMeasCREATE TRIGGER on_update_field_tblTapeDimensionMeas_fkeyTargetStation BEFORE UPDATE OF [fkeyTargetStation] ON [tblTapeDimensionMeas] BEGIN SELECT RAISE(ABORT,'Field [tblTapeDimensionMeas].[fkeyTargetStation] can be set only once in Insert'); END cc)Y]utriggeron_update_field_tblTapeDimensionMeas_fkeyCrdRawMeastblTapeDimensionMeasCREATE TRIGGER on_update_field_tblTapeDimensionMeas_fkeyCrdRawMeas BEFORE UPDATE OF [fkeyCrdRawMeas] ON [tblTapeDimensionMeas] BEGIN SELECT RAISE(ABORT,'Field [tblTapeDimensionMeas].[fkeyCrdRawMeas] can be set only once in Insert'); END )]-triggeron_delete_from_tblTapeDimensionMeastblTapeDimensionMeasCREATE TRIGGER on_delete_from_tblTapeDimensionMeas BEFORE DELETE ON [tblTapeDimensionMeas] BEGIN SELECT RAISE(ABORT,'Records removal is not allowed on table [tblTapeDimensionMeas]'); END K)=Yytriggeron_update_fk_tblTapeDimensionPts_fkeyFirstPttblTapeDimensionPtsCREATE TRIGGER on_update_fk_tblTapeDimensionPts_fkeyFirstPt BEFORE UPDATE OF [fkeyFirstPt] ON [tblTapeDimensionPts] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblTapeDimensionPts].[fkeyFirstPt]') WHERE (SELECT keySoPoint FROM tblSoPoints WHERE keySoPoint = NEW.fkeyFirstPt) IS NULL; END U)AY triggeron_update_fk_tblTapeDimensionPts_fkeySecondPttblTapeDimensionPtsCREATE TRIGGER on_update_fk_tblTapeDimensionPts_fkeySecondPt BEFORE UPDATE OF [fkeySecondPt] ON [tblTapeDimensionPts] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblTapeDimensionPts].[fkeySecondPt]') WHERE (SELECT keySoPoint FROM tblSoPoints WHERE keySoPoint = NEW.fkeySecondPt) IS NULL; END  )Y!triggeron_delete_from_tblTapeDimensionPtstblTapeDimensionPtsCREATE TRIGGER on_delete_from_tblTapeDimensionPts BEFORE DELETE ON [tblTapeDimensionPts] BEGIN SELECT RAISE(ABORT,'Records removal is not allowed on table [tblTapeDimensionPts]'); END ?)59 triggeron_update_field_tblTsOccups_fkeyCrdRawMeastblTsOccupsCREATE TRIGGER on_update_field_tblTsOccups_fkeyCrdRawMeas BEFORE UPDATE OF [fkeyCrdRawMeas] ON [tblTsOccups] BEGIN SELECT RAISE(ABORT,'Field [tblTsOccups].[fkeyCrdRawMeas] can be set only once in Insert'); END ;)9triggeron_update_fk_tblTsOccups_fkeySoPointtblTsOccupsCREATE TRIGGER on_update_fk_tblTsOccups_fkeySoPoint BEFORE UPDATE OF [fkeySoPoint] ON [tblTsOccups] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblTsOccups].[fkeySoPoint]') WHERE NEW.fkeySoPoint IS NOT NULL AND (SELECT keySoPoint FROM tblSoPoints WHERE keySoPoint = NEW.fkeySoPoint) IS NULL; END BB:)u9Atriggeron_delete_from_tblTsOccupstblTsOccupsCREATE TRIGGER on_delete_from_tblTsOccups BEFORE DELETE ON [tblTsOccups] BEGIN SELECT RAISE(ABORT,'Records removal is not allowed on table [tblTsOccups]'); END M)=5!triggeron_update_field_tblTsShots_fkeyTsOccupationstblTsShotsCREATE TRIGGER on_update_field_tblTsShots_fkeyTsOccupations BEFORE UPDATE OF [fkeyTsOccupations] ON [tblTsShots] BEGIN SELECT RAISE(ABORT,'Field [tblTsShots].[fkeyTsOccupations] can be set only once in Insert'); END 5)15}triggeron_update_field_tblTsShots_fkeyCrdRawMeastblTsShotsCREATE TRIGGER on_update_field_tblTsShots_fkeyCrdRawMeas BEFORE UPDATE OF [fkeyCrdRawMeas] ON [tblTsShots] BEGIN SELECT RAISE(ABORT,'Field [tblTsShots].[fkeyCrdRawMeas] can be set only once in Insert'); END y)15triggeron_update_fk_tblTsShots_fkeyTargetStationtblTsShotsCREATE TRIGGER on_update_fk_tblTsShots_fkeyTargetStation BEFORE UPDATE OF [fkeyTargetStation] ON [tblTsShots] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblTsShots].[fkeyTargetStation]') WHERE NEW.fkeyTargetStation IS NOT NULL AND (SELECT keyStation FROM tblStations WHERE keyStation = NEW.fkeyTargetStation) IS NULL; END LL0)q55triggeron_delete_from_tblTsShotstblTsShotsCREATE TRIGGER on_delete_from_tblTsShots BEFORE DELETE ON [tblTsShots] BEGIN SELECT RAISE(ABORT,'Records removal is not allowed on table [tblTsShots]'); END c)AQ-triggeron_update_field_tblXSectSurveyPts_fkeySoPointtblXSectSurveyPtsCREATE TRIGGER on_update_field_tblXSectSurveyPts_fkeySoPoint BEFORE UPDATE OF [fkeySoPoint] ON [tblXSectSurveyPts] BEGIN SELECT RAISE(ABORT,'Field [tblXSectSurveyPts].[fkeySoPoint] can be set only once in Insert'); END )=Itriggeron_delete_key_forbide_tblXSectTplates_tblps)IQEtriggeron_update_field_tblXSectSurveyPts_fkeyAlignmenttblXSectSurveyPtsCREATE TRIGGER on_update_field_tblXSectSurveyPts_fkeyAlignment BEFORE UPDATE OF [fkeyAlignment] ON [tblXSectSurveyPts] BEGIN SELECT RAISE(ABORT,'Field [tblXSectSurveyPts].[fkeyAlignment] can be set only once in Insert'); ENDLineAlntXsSfToTemplates_fkeyXTplatetblXSectTplatesCREATE TRIGGER on_delete_key_forbide_tblXSectTplates_tblLineAlntXsSfToTemplates_fkeyXTplate BEFORE DELETE ON [tblXSectTplates] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'delete on table [tblXSectTplates] violates foreign key constraint for [tblLineAlntXsSfToTemplates].[fkeyXTplate]') WHERE (SELECT fkeyXTplate FROM tblLineAlntXsSfToTemplates WHERE fkeyXTplate = OLD.keyRdTplate) IS NOT NULL; END 55G)1I triggeron_delete_key_cascade_tblXSectTplates_tblXSectTplatesOffsets_fkeyRdTplatetblXSectTplatesCREATE TRIGGER on_delete_key_cascade_tblXSectTplates_tblXSectTplatesOffsets_fkeyRdTplate BEFORE DELETE ON [tblXSectTplates] FOR EACH ROW BEGIN DELETE FROM tblXSectTplatesOffsets WHERE tblXSectTplatesOffsets.fkeyRdTplate = OLD.keyRdTplate; END SS))Ietriggeron_update_fk_tblXSectTplatesOffsets_fkeyCodeDeftblXSectTplatesOffsetsCREATE TRIGGER on_update_fk_tblXSectTplatesOffsets_fkeyCodeDef BEFORE UPDATE OF [fkeyCodeDef] ON [tblXSectTplatesOffsets] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblXSectTplatesOffsets].[fkeyCodeDef]') WHERE NEW.fkeyCodeDef IS NOT NULL AND (SELECT keyCodeDef FROM tblCodeDefs WHERE keyCodeDef = NEW.fkeyCodeDef) IS NULL; END }})MeEtriggeron_update_fk_tblXSectTplatesOffsets_fkeyRdTplatetblXSectTplatesOffsetsCREATE TRIGGER on_update_fk_tblXSectTplatesOffsets_fkeyRdTplate BEFORE UPDATE OF [fkeyRdTplate] ON [tblXSectTplatesOffsets] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblXSectTplatesOffsets].[fkeyRdTplate]') WHERE (SELECT keyRdTplate FROM tblXSectTplates WHERE keyRdTplate = NEW.fkeyRdTplate) IS NULL; END A )9Umtriggeron_update_fk_tblVectorImageRefs_fkeyDatasettblVectorImageRefsCREATE TRIGGER on_update_fk_tblVectorImageRefs_fkeyDataset BEFORE UPDATE OF [fkeyDataset] ON [tblVectorImageRefs] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblVectorImageRefs].[fkeyDataset]') WHERE (SELECT keyDataset FROM tblDatasets WHERE keyDataset = NEW.fkeyDataset) IS NULL; END %!)1U=triggeron_update_fk_tblVectorImageRefs_fkeyLayertblVectorImageRefsCREATE TRIGGER on_update_fk_tblVectorImageRefs_fkeyLayer BEFORE UPDATE OF [fkeyLayer] ON [tblVectorImageRefs] FOR EACH ROW BEGIN SELECT RAISE(ABORT,'update violates foreign key constraint for [tblVectorImageRefs].[fkeyLayer]') WHERE (SELECT keyLayers FROM tblLayers WHERE keyLayers = NEW.fkeyLayer) IS NULL; END j]$Lx6jjD1PP1091LOK@I?H@3^-C@v=B-PP258LOK@I=)q/@3hCUW@wZ=@) 3357LOK@I:B,@3^1@vx'=@ ) 1456LOK@I:K=a'@3]h'X@w'T'=3  3357A+7?u\A? ==3  3199A+N܅RAQ=3  3196A+N =A"0zH=3 3195A+N1A&ZG=31456A+5fffA=xzH=31070A+M43333A!x ==31069A+N> =qAG=7%pp1144A+QfffAi\(=7%pp1091A+VE(ABoR=7%pp1080A+ZRAKIQ=7%pp0168A+X0(AFhQ=1Adummy station xx@)1069LOK@I= 6u@3U¦@vY'=D1PP0168LOK@I?ZН@3_ۑ^(@wx=