SQLite format 3@ ¯_._Fh¯ûöñìçâÝØÓÎÉľ¸²¬¦ š”Žˆ‚|vpjd^XRLF@:4.(" þøòìæàÚÔÎȼ¶°ª¤ž˜’Œ†€ztnhABLE Holiday ( holMasterCsn INTEGER NOT NULL , holLocalCsn INTEGER NOT NULL , holLastModBy INTEGER NOT NULL , holLct INTEGER NOT NULL , holActive INTEGER NOT NULL , holHolidayCalendarUid INTEGER NOT NULL , holStartTime INTEGER NOT NULL , holEndTime INTEGER NOT NULL , holName TEXT , holUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )ƒ! ++…ytableHolidayCalendarHolidayCalendar CREATE TABLE HolidayCalendar ( umCalendarName TEXT , umCalendarCategory INTEGER NOT NULL , umCalendarActive INTEGER NOT NULL , umCalendarMasterChangeSeqNum INTEGER NOT NULL , umCalendarLocalChangeSeqNum INTEGER NOT NULL , umCalendarLastChangedBy INTEGER NOT NULL , umCalendarLct INTEGER NOT NULL , umCalendarUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )ƒm‡)tableDateRangeDateRange CREATE TABLE DateRange ( dateRangeLocalChangeSeqNum INTEGER NOT NULL , dateRangeMasterChangeSeqNum INTEGER NOT NULL , dateRangLastChangedBy INTEGER NOT NULL , dateRangeLct INTEGER NOT NULL , dateRangeFromDate INTEGER NOT NULL , dateRangeToDate INTEGER NOT NULL , dateRangeUMCalendarUid INTEGER NOT NULL , dateRangeName TEXT , dateRangeDesc TEXT , dateRangeActive INTEGER NOT NULL , dateRangeUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )„LˆktableScheduleScheduleCREATE TABLE Schedule ( sceduleStartTime INTEGER NOT NULL , scheduleEndTime INTEGER NOT NULL , scheduleDay INTEGER NOT NULL , scheduleMonth INTEGER NOT NULL , scheduleFrequency INTEGER NOT NULL , umCalendarUid INTEGER NOT NULL , scheduleClazzUid INTEGER NOT NULL , scheduleMasterChangeSeqNum INTEGER NOT NULL , scheduleLocalChangeSeqNum INTEGER NOT NULL , scheduleLastChangedBy INTEGER NOT NULL , scheduleLastChangedTime INTEGER NOT NULL , scheduleActive INTEGER NOT NULL , scheduleUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )„?==ˆtableClazzLogAttendanceRecordClazzLogAttendanceRecordCREATE TABLE ClazzLogAttendanceRecord ( clazzLogAttendanceRecordClazzLogUid INTEGER NOT NULL , clazzLogAttendanceRecordPersonUid INTEGER NOT NULL , attendanceStatus INTEGER NOT NULL , clazzLogAttendanceRecordMasterChangeSeqNum INTEGER NOT NULL , clazzLogAttendanceRecordLocalChangeSeqNum INTEGER NOT NULL , clazzLogAttendanceRecordLastChangedBy INTEGER NOT NULL , clazzLogAttendanceRecordLastChangedTime INTEGER NOT NULL , clazzLogAttendanceRecordUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )…‰ytableClazzLogClazzLogCREATE TABLE ClazzLog ( clazzLogClazzUid INTEGER NOT NULL , logDate INTEGER NOT NULL , timeRecorded INTEGER NOT NULL , clazzLogDone INTEGER NOT NULL , cancellationNote TEXT , clazzLogCancelled INTEGER NOT NULL , clazzLogNumPresent INTEGER NOT NULL , clazzLogNumAbsent INTEGER NOT NULL , clazzLogNumPartial INTEGER NOT NULL , clazzLogScheduleUid INTEGER NOT NULL , clazzLogStatusFlag INTEGER NOT NULL , clazzLogMSQN INTEGER NOT NULL , clazzLogLCSN INTEGER NOT NULL , clazzLogLCB INTEGER NOT NULL , clazzLogLastChangedTime INTEGER NOT NULL , clazzLogUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)ƒ^##‡tableNetworkNodeNetworkNodeCREATE TABLE NetworkNode ( bluetoothMacAddress TEXT , ipAddress TEXT , wifiDirectMacAddress TEXT , deviceWifiDirectName TEXT , endpointUrl TEXT , lastUpdateTimeStamp INTEGER NOT NULL , networkServiceLastUp®…­…¬…«…ª„|©„v¨„m§„c¦„]¥„R¤„J£„B¢„;¡„2 „*Ÿ„!ž„„œ„ ›„š„™ƒ}˜ƒw—ƒp–ƒi•ƒa”ƒ_“ƒX’ƒP‘ƒIƒAƒ8Žƒ0ƒ(Œƒ"‹ƒŠƒ‰ƒˆƒ ‡ƒ†‚{…‚u„‚p~‚jr‚_`‚RQ‚A=‚2)‚!‚}ôkáZÏI¿7­*™‡vuge\YROJG@@87+/# úú k ûû k  ú è|á;­”~V$Bâʲ“`F, è&CContextXObjectStatementJoinâ8B—}`+StatementEntityâ8B—}`'XObjectEntityâ8B—}`'XLangMapEntryâ8B—}`+LanguageVariantâ8B—}`!VerbEntityâ8B—}`1StateContentEntityâ8Byg #StateEntityâ8Byg  #AgentEntityâ8B—}` 1ContainerEntryFile 4 ContainerEntry4 )ContainerEntry  !ContentJobï ContentJo )ContentJobItem&CContentEntryParentChildJoinâ8:ßëpContainerâ8=ýg %ContentEntryâ8:ßëpSiteâ8Byg  Language''LeavingReason' Report†¥VerbEntity'        ø ÖN¿ m  …Cô`Öøƒ …etablƒ …etableHolidayHoliday CREATE TABLE Holiday ( holMasterCsn INTEGER NOT NULL , holLocalCsn INTEGER NOT NULL , holLastModBy INTEGER NOT NULL , holLct INTEGER NOT NULL , holActive INTEGER NOT NULL , holHolidayCalendarUid INTEGER NOT NULL , holStartTime INTEGER NOT NULL , holEndTime INTEGER NOT NULL , holName TEXT , holUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )ƒ! ++…ytableHolidayCalendarHolidayCalendar CREATE TABLE HolidayCalendar ( umCalendarName TEXT , umCalendarCategory INTEGER NOT NULL , umCalendarActive INTEGER NOT NULL , umCalendarMasterChangeSeqNum INTEGER NOT NULL , umCalendarLocalChangeSeqNum INTEGER NOT NULL , umCalendarLastChangedBy INTEGER NOT NULL , umCalendarLct INTEGER NOT NULL , umCalendarUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )ƒm‡)tableDateRangeDateRange CREATE TABLE DateRange ( dateRangeLocalChangeSeqNum INTEGER NOT NULL , dateRangeMasterChangeSeqNum INTEGER NOT NULL , dateRangLastChangedBy INTEGER NOT NULL , dateRangeLct INTEGER NOT NULL , dateRangeFromDate INTEGER NOT NULL , dateRangeToDate INTEGER NOT NULL , dateRangeUMCalendarUid INTEGER NOT NULL , dateRangeName TEXT , dateRangeDesc TEXT , dateRangeActive INTEGER NOT NULL , dateRangeUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )„LˆktableScheduleScheduleCREATE TABLE Schedule ( sceduleStartTime INTEGER NOT NULL , scheduleEndTime INTEGER NOT NULL , scheduleDay INTEGER NOT NULL , scheduleMonth INTEGER NOT NULL , scheduleFrequency INTEGER NOT NULL , umCalendarUid INTEGER NOT NULL , scheduleClazzUid INTEGER NOT NULL , scheduleMasterChangeSeqNum INTEGER NOT NULL , scheduleLocalChangeSeqNum INTEGER NOT NULL , scheduleLastChangedBy INTEGER NOT NULL , scheduleLastChangedTime INTEGER NOT NULL , scheduleActive INTEGER NOT NULL , scheduleUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )„?==ˆtableClazzLogAttendanceRecordClazzLogAttendanceRecordCREATE TABLE ClazzLogAttendanceRecord ( clazzLogAttendanceRecordClazzLogUid INTEGER NOT NULL , clazzLogAttendanceRecordPersonUid INTEGER NOT NULL , attendanceStatus INTEGER NOT NULL , clazzLogAttendanceRecordMasterChangeSeqNum INTEGER NOT NULL , clazzLogAttendanceRecordLocalChangeSeqNum INTEGER NOT NULL , clazzLogAttendanceRecordLastChangedBy INTEGER NOT NULL , clazzLogAttendanceRecordLastChangedTime INTEGER NOT NULL , clazzLogAttendanceRecordUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )…‰ytableClazzLogClazzLogCREATE TABLE ClazzLog ( clazzLogClazzUid INTEGER NOT NULL , logDate INTEGER NOT NULL , timeRecorded INTEGER NOT NULL , clazzLogDone INTEGER NOT NULL , cancellationNote TEXT , clazzLogCancelled INTEGER NOT NULL , clazzLogNumPresent INTEGER NOT NULL , clazzLogNumAbsent INTEGER NOT NULL , clazzLogNumPartial INTEGER NOT NULL , clazzLogScheduleUid INTEGER NOT NULL , clazzLogStatusFlag INTEGER NOT NULL , clazzLogMSQN INTEGER NOT NULL , clazzLogLCSN INTEGER NOT NULL , clazzLogLCB INTEGER NOT NULL , clazzLogLastChangedTime INTEGER NOT NULL , clazzLogUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)ƒ^##‡tableNetworkNodeNetworkNodeCREATE TABLE NetworkNode ( bluetoothMacAddress TEXT , ipAddress TEXT , wifiDirectMacAddress TEXT , deviceWifiDirectName TEXT , endpointUrl TEXT , lastUpdateTimeStamp INTEGER NOT NULL , networkServiceLastUpdated INTEGER NOT NULL , nsdServiceName TEXT , port INTEGER NOT NULL , numFailureCount INTEGER NOT NULL , wifiDirectDeviceStatus INTEGER NOT NULL , groupSsid TEXT , nodeId INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )o%%!table_doorwayinfo_doorwayinfoCREATE TABLE _doorwayinfo (dbVersion int primary key, dbHash varchar(255))7K%indexsqlite_autoindex__doorwayinfo_1_doorwayinfo â PÅÕ 4 ,‡„C99ˆ!tableCustomFieldValueOptionCustomFieldValueOptionCREATE TABLE CustomFieldValueOption ( customFieldValueOptionName TEXT , customFieldValueOptionFieldUid INTEGER NOT NULL , customFieldValueOptionIcon TEXT , customFieldValueOptionMessageId INTEGER NOT NULL , customFieldValueOptionActive INTEGER NOT NULL , customFieldValueOptionMCSN INTEGER NOT NULL , customFieldValueOptionLCSN INTEGER NOT NULL , customFieldValueOptionLCB INTEGER NOT NULL , customFieldValueLct INTEGER NOT NULL , customFieldValueOptionUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )ƒm--‡ tableCustomFieldValueCustomFieldValueCREATE TABLE CustomFieldValue ( customFieldValueFieldUid INTEGER NOT NULL , customFieldValueEntityUid INTEGER NOT NULL , customFieldValueValue TEXT , customFieldValueCustomFieldValueOptionUid INTEGER NOT NULL , customFieldValueMCSN INTEGER NOT NULL , customFieldValueLCSN INTEGER NOT NULL , customFieldValueLCB INTEGER NOT NULL , customFieldLct INTEGER NOT NULL , customFieldValueUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )… ##‰WtableCustomFieldCustomFieldCREATE TABLE CustomField ( customFieldName TEXT , customFieldNameAlt TEXT , customFieldLabelMessageID INTEGER NOT NULL , customFieldIcon TEXT , customFieldIconId INTEGER NOT NULL , actionOnClick TEXT , customFieldType INTEGER NOT NULL , customFieldEntityType INTEGER NOT NULL , customFieldActive INTEGER NOT NULL , customFieldDefaultValue TEXT , customFieldMCSN INTEGER NOT NULL , customFieldLCSN INTEGER NOT NULL , customFieldLCB INTEGER NOT NULL , customFieldLct INTEGER NOT NULL , customFieldInputType INTEGER NOT NULL , customFieldUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )ƒF †_tableAuditLogAuditLogCREATE TABLE AuditLog ( auditLogMasterChangeSeqNum INTEGER NOT NULL , auditLogLocalChangeSeqNum INTEGER NOT NULL , auditLogLastChangedBy INTEGER NOT NULL , auditLogLct INTEGER NOT NULL , auditLogActorPersonUid INTEGER NOT NULL , auditLogTableUid INTEGER NOT NULL , auditLogEntityUid INTEGER NOT NULL , auditLogDate INTEGER NOT NULL , notes TEXT , auditLogUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )ƒF ))†GtableScheduledCheckScheduledCheck CREATE TABLE ScheduledCheck ( checkTime INTEGER NOT NULL , checkType INTEGER NOT NULL , checkUuid TEXT , checkParameters TEXT , scClazzLogUid INTEGER NOT NULL , scheduledCheckMasterCsn INTEGER NOT NULL , scheduledCheckLocalCsn INTEGER NOT NULL , scheduledCheckLastChangedBy INTEGER NOT NULL , scheduledCheckLct INTEGER NOT NULL , scheduledCheckUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )R…etableHolidayHoliday CREATE TABLE Holiday ( holMasterCsn INTEGER NOT NULL , holLocalCsn INTEGER NOT NULL , holLastModBy INTEGER NOT NULL , holLct INTEGER NOT NULL , holActive INTEGER NOT NULL , holHolidayCalendarUid INTEGER NOT NULL , holStartTime INTEGER NOT NULL , holEndTime INTEGER NOT NULL , holName TEXT , holUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )ƒ! ++…ytableHolidayCalendarHolidayCalendar CREATE TABLE HolidayCalendar ( umCalendarName TEXT , umCalendarCategory INTEGER NOT NULL , umCalendarActive INTEGER NOT NULL , umCalendarMas…IŠmtablePersonPersonCREATE TABLE Person ( username TEXT , firstNames TEXT , lastName TEXT , emailAddr TEXT , phoneNum TEXT , gender INTEGER NOT NULL , active INTEGER NOT NULL , admin INTEGER NOT NULL , personNotes TEXT , fatherName TEXT , fatherNumber TEXT , motherName TEXT , motherNum TEXT , dateOfBirth INTEGER NOT NULL , personAddress TEXT , personOrgId TEXT , personGroupUid INTEGER NOT NULL , personMasterChangeSeqNum INTEGER NOT NULL , personLocalChangeSeqNum INTEGER NOT NULL , personLastChangedBy INTEGER NOT NULL , personLct INTEGER NOT NULL , personCountry TEXT , personType INTEGER NOT NULL DEFAULT 0 , personUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )       ©  2<F_"©¡†v%%/tableContentEntryContentEntryCREATE TABLE ContentEntry ( title TEXT , description TEXT , entryId TEXT , author TEXT , publisher TEXT , licenseType INTEGER NOT NULL , licenseName TEXT , licenseUrl TEXT , sourceUrl TEXT , thumbnailUrl TEXT , lastModified INTEGER NOT NULL , primaryLanguageUid INTEGER NOT NULL , languageVariantUid INTEGER NOT NULL , contentFlags INTEGER NOT NULL , leaf INTEGER NOT NULL , publik INTEGER NOT NULL , ceInactive INTEGER NOT NULL , completionCriteria INTEGER NOT NULL , minScore INTEGER NOT NULL , contentTypeFlag INTEGER NOT NULL , contentOwner INTEGER NOT NULL , contentEntryLocalChangeSeqNum INTEGER NOT NULL , contentEntryMasterChangeSeqNum INTEGER NOT NULL , contentEntryLastChangedBy INTEGER NOT NULL , contentEntryLct INTEGER NOT NULL , contentEntryUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )‚:''„3tableLeavingReasonLeavingReasonCREATE TABLE LeavingReason ( leavingReasonTitle TEXT , leavingReasonMCSN INTEGER NOT NULL , leavingReasonCSN INTEGER NOT NULL , leavingReasonLCB INTEGER NOT NULL , leavingReasonLct INTEGER NOT NULL , leavingReasonUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )d )‚!indexindex_ClazzEnrolment_clazzEnrolmentClazzUid_clazzEnrolmentRoleClazzEnrolmentCREATE INDEX index_ClazzEnrolment_clazzEnrolmentClazzUid_clazzEnrolmentRole ON ClazzEnrolment (clazzEnrolmentClazzUid, clazzEnrolmentRole)s)‚5indexindex_ClazzEnrolment_clazzEnrolmentClazzUid_clazzEnrolmentPersonUidClazzEnrolmentCREATE INDEX index_ClazzEnrolment_clazzEnrolmentClazzUid_clazzEnrolmentPersonUid ON ClazzEnrolment (clazzEnrolmentClazzUid, clazzEnrolmentPersonUid)s)‚5indexindex_ClazzEnrolment_clazzEnrolmentPersonUid_clazzEnrolmentClazzUidClazzEnrolmentCREATE INDEX index_ClazzEnrolment_clazzEnrolmentPersonUid_clazzEnrolmentClazzUid ON ClazzEnrolment (clazzEnrolmentPersonUid, clazzEnrolmentClazzUid)…f))‹tableClazzEnrolmentClazzEnrolmentCREATE TABLE ClazzEnrolment ( clazzEnrolmentPersonUid INTEGER NOT NULL , clazzEnrolmentClazzUid INTEGER NOT NULL , clazzEnrolmentDateJoined INTEGER NOT NULL , clazzEnrolmentDateLeft INTEGER NOT NULL , clazzEnrolmentRole INTEGER NOT NULL , clazzEnrolmentAttendancePercentage REAl NOT NULL , clazzEnrolmentActive INTEGER NOT NULL , clazzEnrolmentLeavingReasonUid INTEGER NOT NULL , clazzEnrolmentOutcome INTEGER NOT NULL , clazzEnrolmentLocalChangeSeqNum INTEGER NOT NULL , clazzEnrolmentMasterChangeSeqNum INTEGER NOT NULL , clazzEnrolmentLastChangedBy INTEGER NOT NULL , clazzEnrolmentLct INTEGER NOT NULL , clazzEnrolmentUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )‡b#tableClazzClazzCREATE TABLE Clazz ( clazzName TEXT , clazzDesc TEXT , attendanceAverage REAl NOT NULL , clazzHolidayUMCalendarUid INTEGER NOT NULL , clazzScheuleUMCalendarUid INTEGER NOT NULL , isClazzActive INTEGER NOT NULL , clazzLocationUid INTEGER NOT NULL , clazzStartTime INTEGER NOT NULL , clazzEndTime INTEGER NOT NULL , clazzFeatures INTEGER NOT NULL , clazzSchoolUid INTEGER NOT NULL , clazzEnrolmentPolicy INTEGER NOT NULL DEFAULT 102 , clazzTerminologyUid INTEGER NOT NULL DEFAULT 25966 , clazzMasterChangeSeqNum INTEGER NOT NULL , clazzLocalChangeSeqNum INTEGER NOT NULL , clazzLastChangedBy INTEGER NOT NULL , clazzLct INTEGER NOT NULL , clazzTimeZone TEXT , clazzStudentsPersonGroupUid INTEGER NOT NULL , clazzTeachersPersonGroupUid INTEGER NOT NULL , clazzPendingStudentsPersonGroupUid INTEGER NOT NULL , clazzParentsPersonGroupUid INTEGER NOT NULL , clazzCode TEXT , clazzUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )     QQQQQQ¯#Passed test†Zª±”#Failed test†Zª±y;Family economic problem†Zª±R9Transportation problem†Zª±,Medical†Zª±Moved†Zª± þƒÖÿÖð title 4title 4†ZåŃÖÿÖð title 2title 2†ZàŒƒÖÿÖð title 2title 2†ZÛSƒÖÿÖð/; Lorem ipsum titleLorem ipsum description†ZÏ    ‘È!*}ä\ Ú - ö > 2*nAindexindex_Role_rolePermissionsRole)CREATE INDEX index_Role_rolePermissions ON Role (rolePermissions)‚A#„etableRoleRole(CREATE TABLE Role ( roleName TEXT , roleActive INTEGER NOT NULL , roleMasterCsn INTEGER NOT NULL , roleLocalCsn INTEGER NOT NULL , roleLastChangedBy INTEGER NOT NULL , roleLct INTEGER NOT NULL , rolePermissions INTEGER NOT NULL , roleUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )ƒ++…ctableContentCategoryContentCategory"CREATE TABLE ContentCategory ( ctnCatContentCategorySchemaUid INTEGER NOT NULL , name TEXT , contentCategoryLocalChangeSeqNum INTEGER NOT NULL , contentCategoryMasterChangeSeqNum INTEGER NOT NULL , contentCategoryLastChangedBy INTEGER NOT NULL , contentCategoryLct INTEGER NOT NULL , contentCategoryUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )ƒ*77…stableContentCategorySchemaContentCategorySchema!CREATE TABLE ContentCategorySchema ( schemaName TEXT , schemaUrl TEXT , contentCategorySchemaLocalChangeSeqNum INTEGER NOT NULL , contentCategorySchemaMasterChangeSeqNum INTEGER NOT NULL , contentCategorySchemaLastChangedBy INTEGER NOT NULL , contentCategorySchemaLct INTEGER NOT NULL , contentCategorySchemaUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )ƒtEE†ktableContentEntryRelatedEntryJoinContentEntryRelatedEntryJoin CREATE TABLE ContentEntryRelatedEntryJoin ( cerejContentEntryUid INTEGER NOT NULL , cerejRelatedEntryUid INTEGER NOT NULL , cerejLastChangedBy INTEGER NOT NULL , relType INTEGER NOT NULL , comment TEXT , cerejRelLanguageUid INTEGER NOT NULL , cerejLocalChangeSeqNum INTEGER NOT NULL , cerejMasterChangeSeqNum INTEGER NOT NULL , cerejLct INTEGER NOT NULL , cerejUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )$%Cmindexparent_childContentEntryParentChildJoinCREATE INDEX parent_child ON ContentEntryParentChildJoin (cepcjChildContentEntryUid, cepcjParentContentEntryUid)ƒFCC†tableContentEntryParentChildJoinContentEntryParentChildJoinCREATE TABLE ContentEntryParentChildJoin ( cepcjLocalChangeSeqNum INTEGER NOT NULL , cepcjMasterChangeSeqNum INTEGER NOT NULL , cepcjLastChangedBy INTEGER NOT NULL , cepcjLct INTEGER NOT NULL , cepcjParentContentEntryUid INTEGER NOT NULL , cepcjChildContentEntryUid INTEGER NOT NULL , childIndex INTEGER NOT NULL , cepcjUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )ƒ*KK…KtableContentEntryContentCategoryJoinContentEntryContentCategoryJoinCREATE TABLE ContentEntryContentCategoryJoin ( ceccjContentEntryUid INTEGER NOT NULL , ceccjContentCategoryUid INTEGER NOT NULL , ceccjLocalChangeSeqNum INTEGER NOT NULL , ceccjMasterChangeSeqNum INTEGER NOT NULL , ceccjLastChangedBy INTEGER NOT NULL , ceccjLct INTEGER NOT NULL , ceccjUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )5"!!‚5tablePersonAuthPersonAuth'CREATE TABLE PersonAuth ( passwordHash TEXT , personAuthStatus INTEGER NOT NULL , personAuthUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )5!I#indexsqlite_autoindex_AccessToken_1AccessToken&* ##‚tableAccessTokenAccessToken%CREATE TABLE AccessToken ( token TEXT PRIMARY KEY NOT NULL , accessTokenPersonUid INTEGER NOT NULL , expires INTEGER NOT NULL )‚++…5tableLanguageVariantLanguageVariant$CREATE TABLE LanguageVariant ( langUid INTEGER NOT NULL , countryCode TEXT , name TEXT , langVariantLocalChangeSeqNum INTEGER NOT NULL , langVariantMasterChangeSeqNum INTEGER NOT NULL , langVariantLastChangedBy INTEGER NOT NULL , langVariantLct INTEGER NOT NULL , langVariantUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )ƒ!†tableLanguageLanguage#CREATE TABLE Language ( name TEXT , iso_639_1_standard TEXT , iso_639_2_standard TEXT , iso_639_3_standard TEXT , Language_Type TEXT , languageActive INTEGER NOT NULL , langLocalChangeSeqNum INTEGER NOT NULL , langMasterChangeSeqNum INTEGER NOT NULL , langLastChangedBy INTEGER NOT NULL , langLct INTEGER NOT NULL , langUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL ) ………{ƒÖÿÖð †Zõâ8:ßëpâ8:ßëpRƒÖÿÖð †Zõâ8:ßëpâ8:ßëp)ƒÖÿÖð †Zõâ8:ßëpâ8:ßëp ©©©Wâ8:ßëpâ8:ßëpâ8:ßëp:â8:ßëpâ8:ßëpâ8:ßëpâ8:ßëpâ8:ßëpâ8:ßëp    ^^^^^^^^^^¢% Тоҷикӣtgtgktgk†ZªÁy) руÑÑкийrurusrus†ZªÁN! Ùارسیfaperfas†ZªÁ' پښتوpspuspus†ZªÁ1 नेपालीnenepnep†ZªÁÓ% Ikinyarwandarwkinkin†ZªÁª1 မြန်မာmyburmya†ZªÁ{+ বাংলাbnbenben†ZªÁO) العربيةararaara†ZªÁ$Î  Englishen†Z«< ««U„”Ýúà ''USUnited States†Z«+„”Ýúà )'GBUnited Kingdom†Zªÿ       Œ O #ùCã1# Ø < r ‘O ˜ Æ ƒQ.†qtableContainerContainer4CREATE TABLE Container ( cntLocalCsn INTEGER NOT NULL , cntMasterCsn INTEGER NOT NULL , cntLastModBy INTEGER NOT NULL , cntLct INTEGER NOT NULL , fileSize INTEGER NOT NULL , containerContentEntryUid INTEGER NOT NULL , cntLastModified INTEGER NOT NULL , mimeType TEXT , remarks TEXT , mobileOptimized INTEGER NOT NULL , cntNumEntries INTEGER NOT NULL , containerUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )„ )''‡UtablePersonPicturePersonPicture/CREATE TABLE PersonPicture ( personPicturePersonUid INTEGER NOT NULL , personPictureMasterCsn INTEGER NOT NULL , personPictureLocalCsn INTEGER NOT NULL , personPictureLastChangedBy INTEGER NOT NULL , personPictureLct INTEGER NOT NULL , personPictureUri TEXT , personPictureMd5 TEXT , fileSize INTEGER NOT NULL , picTimestamp INTEGER NOT NULL , mimeType TEXT , personPictureActive INTEGER NOT NULL , personPictureUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )ƒ/(//† tablePersonGroupMemberPersonGroupMember.CREATE TABLE PersonGroupMember ( groupMemberActive INTEGER NOT NULL , groupMemberPersonUid INTEGER NOT NULL , groupMemberGroupUid INTEGER NOT NULL , groupMemberMasterCsn INTEGER NOT NULL , groupMemberLocalCsn INTEGER NOT NULL , groupMemberLastChangedBy INTEGER NOT NULL , groupMemberLct INTEGER NOT NULL , groupMemberUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )‚]'##…tablePersonGroupPersonGroup-CREATE TABLE PersonGroup ( groupMasterCsn INTEGER NOT NULL , groupLocalCsn INTEGER NOT NULL , groupLastChangedBy INTEGER NOT NULL , groupLct INTEGER NOT NULL , groupName TEXT , groupActive INTEGER NOT NULL , personGroupFlag INTEGER NOT NULL , groupUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )3&k!gindexindex_EntityRole_erGroupUid_erRoleUid_erTableIdEntityRole,CREATE INDEX index_EntityRole_erGroupUid_erRoleUid_erTableId ON EntityRole (erGroupUid, erRoleUid, erTableId)ƒ%!!…ktableEntityRoleEntityRole*CREATE TABLE EntityRole ( erMasterCsn INTEGER NOT NULL , erLocalCsn INTEGER NOT NULL , erLastChangedBy INTEGER NOT NULL , erLct INTEGER NOT NULL , erTableId INTEGER NOT NULL , erEntityUid INTEGER NOT NULL , erGroupUid INTEGER NOT NULL , erRoleUid INTEGER NOT NULL , erActive INTEGER NOT NULL , erUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL ) Aindexindex_Role_rolePermissionsRole)CREATE INDEX O0))‚YtableContainerEntryContainerEntry6CREATE TABLE ContainerEntry ( ceContainerUid INTEGER NOT NULL , cePath TEXT , ceCefUid INTEGER NOT NULL , ceUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )/9Eindexcnt_uid_to_most_recentContainer5CREATE INDEX cnt_uid_to_most_recent ON Container (containerContentEntryUid, cntLastModified)l$Aindexindex_Role_rolePermissionsRole)CREATE INDEX index_Role_rolePermissions ON Role (rolePermissions)^-11‚gtableConnectivityStatusConnectivityStatus3CREATE TABLE ConnectivityStatus ( csUid INTEGER PRIMARY KEY NOT NULL , connectivityState INTEGER NOT NULL , wifiSsid TEXT , connectedOrConnecting INTEGER NOT NULL )G,‚]tableScrapeRunScrapeRun2CREATE TABLE ScrapeRun ( scrapeType TEXT , scrapeRunStatus INTEGER NOT NULL , conversionParams TEXT , scrapeRunUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )+W+=indexindex_ScrapeQueueItem_status_itemTypeScrapeQueueItem1CREATE INDEX index_ScrapeQueueItem_status_itemType ON ScrapeQueueItem (status, itemType)„%*++ˆtableScrapeQueueItemScrapeQueueItem0CREATE TABLE ScrapeQueueItem ( sqiContentEntryParentUid INTEGER NOT NULL , sqiContentEntryUid INTEGER NOT NULL , destDir TEXT , scrapeUrl TEXT , status INTEGER NOT NULL , runId INTEGER NOT NULL , itemType INTEGER NOT NULL , errorCode INTEGER NOT NULL , contentType TEXT , timeAdded INTEGER NOT NULL , timeStarted INTEGER NOT NULL , timeFinished INTEGER NOT NULL , priority INTEGER NOT NULL , overrideEntry INTEGER NOT NULL , sqiUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )         ß{{…ƒÖÿÖð †Zðôâ8:ßëp†ZÏXƒÖÿÖð †Zëôâ8:ßëp†ZÏ+ƒÖÿÖð!ƒíñ…à †Z˜`L× ó¯¯Qâ8:ßëp†ZÏâ8:ßëp6â8:ßëp†ZÏâ8:ßëpâ8:ßëp â8=¼Bà ±±O=â8=¼Bàsubfolder/test file2.png ';â8=¼Bàsubfolder/testfile1.png ´´L=‚ 5yNp8Lo0mmpOeUrsfKGqYQ==/tmp/junit14246350745897323828/TestMountedContainerResponder-containerTmp/423963152728907776/e72369f0ba349a6a4e794aec7ca1aa61FàDa§=‚ tYGzA5WhWM5X+CoL6GQREw==/tmp/junit14246350745897323828/TestMountedContainerResponder-containerTmp/423963152728907776/b581b30395a158ce57f82a0be8641113@v M. ÷ µ ¹{åM ƒƒ67##†3tableAgentEntityAgentEntity>CREATE TABLE AgentEntity ( agentMbox TEXT , agentMbox_sha1sum TEXT , agentOpenid TEXT , agentAccountName TEXT , agentHomePage TEXT , agentPersonUid INTEGER NOT NULL , statementMasterChangeSeqNum INTEGER NOT NULL , statementLocalChangeSeqNum INTEGER NOT NULL , statementLastChangedBy INTEGER NOT NULL , agentLct INTEGER NOT NULL , agentUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )ƒ\6CC†?tableContextXObjectStatementJoinContextXObjectStatementJoin=CREATE TABLE ContextXObjectStatementJoin ( contextActivityFlag INTEGER NOT NULL , contextStatementUid INTEGER NOT NULL , contextXObjectUid INTEGER NOT NULL , verbMasterChangeSeqNum INTEGER NOT NULL , verbLocalChangeSeqNum INTEGER NOT NULL , verbLastChangedBy INTEGER NOT NULL , contextXObjectLct INTEGER NOT NULL , contextXObjectStatementJoinUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )ƒ5{+„ indexindex_StatementEntity_statementContentEntryUid_statementPersonUid_contentEntryRoot_timestamp_statementLocalChangeSeqNumStatementEntity¶ P†Z©Ðec531277-b57b-4c15-8d91-d292c5b2b8f7Example virtual meeting software6690e6c9-3ef0-4ed3-8b37-7f3964730bee{"actor":{"name":"Team PB","mbox":"mailto:teampb@example.com","objectType":"Group"},"verb":{"id":"http://adlnet.gov/expapi/verbs/attended","display":{"en-GB":"attended","en-US":"attended"}},"result":{"completion":true,"success":true,"duration":"PT1H0M0S","response":"We agreed on some example actions.","extensions":{"http://example.com/profiles/meetings/resultextensions/minuteslocation":"X:\\meetings\\minutes\\examplemeeting.one"}},"context":{"instructor":{"name":"Andrew Downes","objectType":"Agent","account":{"name":"13936749","homePage":"http://www.example.com"}},"registration":"ec531277-b57b-4c15-8d91-d292c5b2b8f7","language":"tlh","platform":"Example virtual meeting software","team":{"name":"Team PB","mbox":"mailto:teampb@example.com","objectType":"Group"},"statement":{"id":"6690e6c9-3ef0-4ed3-8b37-7f3964730bee","objectType":"StatementRef","statementRefUid":0},"contextActivities":{"parent":[{"id":"http://www.example.com/meetings/series/267","objectType":"Activity","statementRefUid":0}],"category":[{"id":"http://www.example.com/meetings/categories/teammeeting","definition":{"name":{"en":"team meeting"},"description":{"en":"A category of meeting used for regular team meetings."},"type":"http://example.com/expapi/activities/meetingcategory"},"objectType":"Activity","statementRefUid":0}],"other":[{"id":"http://www.example.com/meetings/occurances/34257","objectType":"Activity","statementRefUid":0},{"id":"http://www.example.com/meetings/occurances/3425567","objectType":"Activity","statementRefUid":0}]}},"timestamp":"2013-05-18T05:32:34.804+00:00","stored":"2023-02-16T11:53:38.254Z","authority":{"objectType":"Agent","account":{"name":"anonymous","homePage":"http://cloud.scorm.com/"}},"version":"1.0.0","id":"6690e6c9-3ef0-4ed3-8b37-7f3964730bee","object":{"id":"http://www.example.com/meetings/occurances/34534","definition":{"name":{"en-GB":"example meeting","en-US":"example meeting"},"description":{"en-GB":"An example meeting that happened on a specific occasion with certain people present.","en-US":"An example meeting that happened on a specific occasion with certain people present."},"type":"http://adlnet.gov/expapi/activities/meeting","extensions":{"http://example.com/profiles/meetings/activitydefinitionextensions/room":{"name":"Kilby","id":"http://example.com/rooms/342"}},"moreInfo":"http://virtualmeeting.example.com/345256"},"objectType":"Activity","statementRefUid":0}}†Z«]Ò' èÒ>¶ Pâ8B—}` ZZZZ¦„”Ýúà â8B—}`â8B—}`†Z«Ÿ|„”Ýúà â8B—}`â8B—}`†Z«ŽR„”Ýúà â8B—}`â8B—}`†Z«~)„”Ýúà â8B—}`â8B—}`†Z«n UUU«„”Ýúà 913936749http://www.example.com†Z«Oq„”Ýúà ;anonymoushttp://cloud.scorm.com/†Z«"5„”Ýúà ?mailto:teampb@example.com†Zªð ”l„“åÏ  KS http://www.example.com/states/1â8Byg http://www.example.com/activities/1†Zª †Zª Ò ¤ #UdîR̤ È ¸ °œ†%>Œ%tableSchoolSchoolFCREATE TABLE School ( schoolName TEXT , schoolDesc TEXT , schoolAddress TEXT , schoolActive INTEGER NOT NULL , schoolPhoneNumber TEXT , schoolGender INTEGER NOT NULL , schoolHolidayCalendarUid INTEGER NOT NULL , schoolFeatures INTEGER NOT NULL , schoolLocationLong REAl NOT NULL , schoolLocationLatt REAl NOT NULL , schoolEmailAddress TEXT , schoolTeachersPersonGroupUid INTEGER NOT NULL , schoolStudentsPersonGroupUid INTEGER NOT NULL , schoolPendingStudentsPersonGroupUid INTEGER NOT NULL , schoolCode TEXT , schoolMasterChangeSeqNum INTEGER NOT NULL , schoolLocalChangeSeqNum INTEGER NOT NULL , schoolLastChangedBy INTEGER NOT NULL , schoolLct INTEGER NOT NULL , schoolTimeZone TEXT , schoolUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )=''EtableContainerETagContainerETagECREATE TABLE ContainerETag ( ceContainerUid INTEGER PRIMARY KEY NOT NULL , cetag TEXT )<??AtableLocallyAvailableContainerLocallyAvailableContainerDCREATE TABLE LocallyAvailableContainer ( laContainerUid INTEGER PRIMARY KEY NOT NULL )t;;tableSyncNodeSyncNodeCCREATE TABLE SyncNode ( nodeClientId INTEGER NOT NULL , PRIMARY KEY (nodeClientId) )ƒn:''‡tableXLangMapEntryXLangMapEntryBCREATE TABLE XLangMapEntry ( verbLangMapUid INTEGER NOT NULL , objectLangMapUid INTEGER NOT NULL , languageLangMapUid INTEGER NOT NULL , languageVariantLangMapUid INTEGER NOT NULL , valueLangMap TEXT , statementLangMapMasterCsn INTEGER NOT NULL , statementLangMapLocalCsn INTEGER NOT NULL , statementLangMapLcb INTEGER NOT NULL , statementLangMapLct INTEGER NOT NULL , statementLangMapUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )ƒK911†AtableStateContentEntityStateContentEntityACREATE TABLE StateContentEntity ( stateContentStateUid INTEGER NOT NULL , stateContentKey TEXT , stateContentValue TEXT , isIsactive INTEGER NOT NULL , stateContentMasterChangeSeqNum INTEGER NOT NULL , stateContentLocalChangeSeqNum INTEGER NOT NULL , stateContentLastChangedBy INTEGER NOT NULL , stateContentLct INTEGER NOT NULL , stateContentUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )ƒ,8##†tableStateEntityStateEntity?CREATE TABLE StateEntity ( stateId TEXT , agentUid INTEGER NOT NULL , activityId TEXT , registration TEXT , isIsactive INTEGER NOT NULL , timestamp INTEGER NOT NULL , stateMasterChangeSeqNum INTEGER NOT NULL , stateLocalChangeSeqNum INTEGER NOT NULL , stateLastChangedBy INTEGER NOT NULL , stateLct INTEGER NOT NULL , stateUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )æ##†3tableAgentEntityAgentEntity>CREATE TABLE AgentEntity ( agentMbox TEXT , agentMbox_sha1sum TEXT , agentOpenid TEXT , agentAccountName TEXT , agentHomePage TEXT , agentPersonUid INTEGER NOT NULL , statementMasterChangeSeqNum INTEGER NOT NULL , statementLocalChangeSeqNum INTEGER NOT NULL , statementLastChangedBy INTEGER NOT NULL , agentLct INTEGER NOT NULL , agentUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )ƒ\6CC†?tableContextXObjectStatemenA‚ @%%‚[indexindex_SchoolMember_schoolMemberSchoolUid_schoolMemberActive_schoolMemberRoleSchoolMemberHCREATE INDEX index_SchoolMember_schoolMemberSchoolUid_schoolMemberActive_schoolMemberRole ON SchoolMember (schoolMemberSchoolUid, schoolMemberActive, schoolMemberRole)„5?%%ˆ-tableSchoolMemberSchoolMemberGCREATE TABLE SchoolMember ( schoolMemberPersonUid INTEGER NOT NULL , schoolMemberSchoolUid INTEGER NOT NULL , schoolMemberJoinDate INTEGER NOT NULL , schoolMemberLeftDate INTEGER NOT NULL , schoolMemberRole INTEGER NOT NULL , schoolMemberActive INTEGER NOT NULL , schoolMemberLocalChangeSeqNum INTEGER NOT NULL , schoolMemberMasterChangeSeqNum INTEGER NOT NULL , schoolMemberLastChangedBy INTEGER NOT NULL , schoolMemberLct INTEGER NOT NULL , schoolMemberUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )          ð„“åÏ   â8Byg lat36.1499†ZªPÄ„“åÏ  3 â8Byg tc_idhttp://id.tincanapi.com/activity/tincan-prototypes/nashville-museums-tour/parthenon†ZªIIÇ„“åÏ  #ƒS â8Byg descriptionThe Parthenon in Nashville, Tennessee is a full-scale replica of the original Parthenon in Athens. It was built in 1897 as part of the Tennessee Centennial Exposition. The Parthenon serves as the city of Nashville's art museum.†ZªC7„“åÏ   â8Byg visitedfalse†Zª< „“åÏ  1 â8Byg iconimg/notvisited.png†Zª5Ñ„“åÏ   â8Byg nameParthenon†Zª&¢„“åÏ  ! â8Byg visitrange.25†Zªs„“åÏ  ! â8Byg lng-86.812935†ZªD„“åÏ  C â8Byg website{name=Parthenon, icon=Part}†Zª â„”Ýúà +â8B—}`'â8B—}`example meeting†Z«E¦„”Ýúà +â8B—}`'â8B—}`example meeting†Z«Ej„”Ýúà â8B—}`'â8B—}`attended†Z«5„”Ýúà â8B—}`'â8B—}`attended†Z« ô ºµÅÞð       þv ;Ú”q…ovõƒvG55‡tableGroupLearningSessionGroupLearningSessionPCREATE TABLE GroupLearningSession ( groupLearningSessionContentUid INTEGER NOT NULL , groupLearningSessionLearnerGroupUid INTEGER NOT NULL , groupLearningSessionInactive INTEGER NOT NULL , groupLearningSessionMCSN INTEGER NOT NULL , groupLearningSessionCSN INTEGER NOT NULL , groupLearningSessionLCB INTEGER NOT NULL , groupLearningSessionLct INTEGER NOT NULL , groupLearningSessionUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )ƒF11‡)tableLearnerGroupMemberLearnerGroupMemberOCREATE TABLE LearnerGroupMember ( learnerGroupMemberPersonUid INTEGER NOT NULL , learnerGroupMemberLgUid INTEGER NOT NULL , learnerGroupMemberRole INTEGER NOT NULL , learnerGroupMemberActive INTEGER NOT NULL , learnerGroupMemberMCSN INTEGER NOT NULL , learnerGroupMemberCSN INTEGER NOT NULL , learnerGroupMemberLCB INTEGER NOT NULL , learnerGroupMemberLct INTEGER NOT NULL , learnerGroupMemberUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )„ D11‡ktableContainerImportJobContainerImportJobMCREATE TABLE ContainerImportJob ( cijContainerUid INTEGER NOT NULL , cijUri TEXT , cijImportMode INTEGER NOT NULL , cijContainerBaseDir TEXT , cijContentEntryUid INTEGER NOT NULL , cijMimeType TEXT , cijSessionId TEXT , cijJobStatus INTEGER NOT NULL , cijBytesSoFar INTEGER NOT NULL , cijImportCompleted INTEGER NOT NULL , cijContentLength INTEGER NOT NULL , cijContainerEntryFileUids TEXT , cijConversionParams TEXT , cijUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )‚CC„itableSiteSiteLCREATE TABLE Site ( sitePcsn INTEGER NOT NULL , siteLcsn INTEGER NOT NULL , siteLcb INTEGER NOT NULL , siteLct INTEGER NOT NULL , siteName TEXT , guestLogin INTEGER NOT NULL , registrationAllowed INTEGER NOT NULL , authSalt TEXT , siteUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )†^BtableReportReportKCREATE TABLE Report ( reportOwnerUid INTEGER NOT NULL , xAxis INTEGER NOT NULL , reportDateRangeSelection INTEGER NOT NULL , fromDate INTEGER NOT NULL , fromRelTo INTEGER NOT NULL , fromRelOffSet INTEGER NOT NULL , fromRelUnit INTEGER NOT NULL , toDate INTEGER NOT NULL , toRelTo INTEGER NOT NULL , toRelOffSet INTEGER NOT NULL , toRelUnit INTEGER NOT NULL , reportTitle TEXT , reportDescription TEXT , reportSeries TEXT , reportInactive INTEGER NOT NULL , isTemplate INTEGER NOT NULL , priority INTEGER NOT NULL , reportTitleId INTEGER NOT NULL , reportDescId INTEGER NOT NULL , reportMasterChangeSeqNum INTEGER NOT NULL , reportLocalChangeSeqNum INTEGER NOT NULL , reportLastChangedBy INTEGER NOT NULL , reportLct INTEGER NOT NULL , reportUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )…@AŠStableCommentsCommentsICREATE TABLE Comments ( commentsText TEXT , commentsEntityType INTEGER NOT NULL , commentsEntityUid INTEGER NOT NULL , commentsPublic INTEGER NOT NULL , commentsStatus INTEGER NOT NULL , commentsPersonUid INTEGER NOT NULL , commentsToPersonUid INTEGER NOT NULL , commentSubmitterUid INTEGER NOT NULL , commentsFlagged INTEGER NOT NULL , commentsInActive INTEGER NOT NULL , commentsDateTimeAdded INTEGER NOT NULL , commentsDateTimeUpdated INTEGER NOT NULL , commentsMCSN INTEGER NOT NULL , commentsLCSN INTEGER NOT NULL , commentsLCB INTEGER NOT NULL , commentsLct INTEGER NOT NULL , commentsUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )‡11‡)tableLearnerGroupMemberLearnerGroupMemberOCREATE TABLE LearnerGroupMember ( learnerGroupMemberPersonUid INTEGER NOT NULL ,‚xE%%…3tableLearnerGroupLearnerGroupNCREATE TABLE LearnerGroup ( learnerGroupName TEXT , learnerGroupDescription TEXT , learnerGroupActive INTEGER NOT NULL , learnerGroupMCSN INTEGER NOT NULL , learnerGroupCSN INTEGER NOT NULL , learnerGroupLCB INTEGER NOT NULL , learnerGroupLct INTEGER NOT NULL , learnerGroupUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )  $ $ $ $ $ $Ü%1y‚Q 0Content completionNumber of students who have completed selected content[{ "reportSeriesUid": 0, "reportSeriesName": "Series 1", "reportSeriesYAxis": 206, "reportSeriesVisualType": 100, "reportSeriesSubGroup": 0 }] †Zª¢É$9i‚W 3Content usage by classTotal content usage duration subgroup by class[{ "reportSeriesUid ": 0, "reportSeriesName ": " Series 1", "reportSeriesYAxis": 200, "reportSeriesVisualType": 100, "reportSeriesSubGroup": 0 }] †Zª¢·#Ga‚7 3Attendance over time by classPercentage of students attending over time[{ "reportSeriesUid": 0, "reportSeriesName": "Series 1", "reportSeriesYAxis": 211, "reportSeriesVisualType": 100, "reportSeriesSubGroup": 0 }]†Zª¢²"IM‚3 .Unique content users over timeNumber of active users over time[{ "reportSeriesUid": 0, "reportSeriesName": "Series 1", "reportSeriesYAxis": 204, "reportSeriesVisualType": 100, "reportSeriesSubGroup": 0 }]†Zª¢¸!;)‚= 2Content usage over timeTotal content [{ "reportSeriesUid": 0, "reportSeriesName": "Series 1", "reportSeriesYAxis": 200, "reportSeriesVisualType": 100, "reportSeriesSubGroup": 0 }]†Zª¢Ò %‚=  ,Blank reportStart [{ "reportSeriesUid": 0, "reportSeriesName": "Series 1", "reportSeriesYAxis": 200, "reportSeriesVisualType": 100, "reportSeriesSubGroup": 0 }]†Zª¢ Ò.„“åÏ   -†Z©ãTestcz5qjm872jbwmcpi      / iâÎ+š / Û|t³AA…ktableClazzAssignmentContentJoinClazzAssignmentContentJoinZCREATE TABLE ClazzAssignmentContentJoin ( cacjContentUid INTEGER NOT NULL , cacjAssignmentUid INTEGER NOT NULL , cacjActive INTEGER NOT NULL , cacjWeight INTEGER NOT NULL DEFAULT 0 , cacjMCSN INTEGER NOT NULL , cacjLCSN INTEGER NOT NULL , cacjLCB INTEGER NOT NULL , cacjLct INTEGER NOT NULL , cacjUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )ƒWN##†utableErrorReportErrorReportXCREATE TABLE ErrorReport ( errPcsn INTEGER NOT NULL , errLcsn INTEGER NOT NULL , errLcb INTEGER NOT NULL , errLct INTEGER NOT NULL , severity INTEGER NOT NULL , timestamp INTEGER NOT NULL , presenterUri TEXT , appVersion TEXT , versionCode INTEGER NOT NULL , errorCode INTEGER NOT NULL , operatingSys TEXT , osVersion TEXT , stackTrace TEXT , message TEXT , errUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )M3#Sindexidx_entity_to_groupScopedGrantWCREATE INDEX idx_entity_to_group ON ScopedGrant (sgTableId, sgEntityUid, sgPermissions, sgGroupUid)L3#Sindexidx_group_to_entityScopedGrantVCREATE INDEX idx_group_to_entity ON ScopedGrant (sgGroupUid, sgPermissions, sgTableId, sgEntityUid)ƒ K##†tableScopedGrantScopedGrantUCREATE TABLE ScopedGrant ( sgPcsn INTEGER NOT NULL , sgLcsn INTEGER NOT NULL , sgLcb INTEGER NOT NULL , sgLct INTEGER NOT NULL , sgTableId INTEGER NOT NULL , sgEntityUid INTEGER NOT NULL , sgPermissions INTEGER NOT NULL , sgGroupUid INTEGER NOT NULL , sgIndex INTEGER NOT NULL , sgFlags INTEGER NOT NULL , sgUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )„J--‡UtablePersonParentJoinPersonParentJoinTCREATE TABLE PersonParentJoin ( ppjPcsn INTEGER NOT NULL , ppjLcsn INTEGER NOT NULL , ppjLcb INTEGER NOT NULL , ppjLct INTEGER NOT NULL , ppjParentPersonUid INTEGER NOT NULL , ppjMinorPersonUid INTEGER NOT NULL , ppjRelationship INTEGER NOT NULL , ppjEmail TEXT , ppjPhone TEXT , ppjInactive INTEGER NOT NULL , ppjStatus INTEGER NOT NULL , ppjApprovalTiemstamp INTEGER NOT NULL , ppjApprovalIpAddr TEXT , ppjUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )ƒI--…;tableClazzContentJoinClazzContentJoinSCREATE TABLE ClazzContentJoin ( ccjContentEntryUid INTEGER NOT NULL , ccjClazzUid INTEGER NOT NULL , ccjActive INTEGER NOT NULL , ccjLocalChangeSeqNum INTEGER NOT NULL , ccjMasterChangeSeqNum INTEGER NOT NULL , ccjLastChangedBy INTEGER NOT NULL , ccjLct INTEGER NOT NULL , ccjUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )‚oH…-tableSiteTermsSiteTermsQCREATE TABLE SiteTerms ( termsHtml TEXT , sTermsLang TEXT , sTermsLangUid INTEGER NOT NULL , sTermsActive INTEGER NOT NULL , sTermsLastChangedBy INTEGER NOT NULL , sTermsPrimaryCsn INTEGER NOT NULL , sTermsLocalCsn INTEGER NOT NULL , sTermsLct INTEGER NOT NULL , sTermsUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )ˆ"O++{tableClazzAssignmentClazzAssignmentYCREATE TABLE ClazzAssignment ( caTitle TEXT , caDescription TEXT , caGroupUid INTEGER NOT NULL DEFAULT 0 , caActive INTEGER NOT NULL , caClassCommentEnabled INTEGER NOT NULL , caPrivateCommentsEnabled INTEGER NOT NULL DEFAULT 1 , caCompletionCriteria INTEGER NOT NULL DEFAULT 100 , caRequireFileSubmission INTEGER NOT NULL DEFAULT 1 , caFileType INTEGER NOT NULL DEFAULT 0 , caSizeLimit INTEGER NOT NULL DEFAULT 50 , caNumberOfFiles INTEGER NOT NULL DEFAULT 1 , caSubmissionPolicy INTEGER NOT NULL DEFAULT 1 , caMarkingType INTEGER NOT NULL DEFAULT 1 , caRequireTextSubmission INTEGER NOT NULL DEFAULT 1 , caTextLimitType INTEGER NOT NULL DEFAULT 1 , caTextLimit INTEGER NOT NULL DEFAULT 500 , caXObjectUid INTEGER NOT NULL DEFAULT 0 , caClazzUid INTEGER NOT NULL , caLocalChangeSeqNum INTEGER NOT NULL , caMasterChangeSeqNum INTEGER NOT NULL , caLastChangedBy INTEGER NOT NULL , caLct INTEGER NOT NULL , caUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )          ( D é½F”SD' œ ^ K ö‚ V##ƒ_tablePersonAuth2PersonAuth2aCREATE TABLE PersonAuth2 ( pauthUid INTEGER PRIMARY KEY NOT NULL , pauthMechanism TEXT , pauthAuth TEXT , pauthLcsn INTEGER NOT NULL , pauthPcsn INTEGER NOT NULL , pauthLcb INTEGER NOT NULL , pauthLct INTEGER NOT NULL )‚>U;7ƒindexindex_ClazzAssignmentRollUp_cachePersonUid_cacheContentEntryUid_cacheClazzAssignmentUidClazzAssignmentRollUp`CREATE UNIQUE INDEX index_ClazzAssignmentRollUp_cachePersonUid_cacheContentEntryUid_cacheClazzAssignmentUid ON ClazzAssignmentRollUp (cachePersonUid, cacheContentEntryUid, cacheClazzAssignmentUid)„zT77‰tableClazzAssignmentRollUpClazzAssignmentRollUp_CREATE TABLE ClazzAssignmentRollUp ( cachePersonUid INTEGER NOT NULL , cacheContentEntryUid INTEGER NOT NULL , cacheClazzAssignmentUid INTEGER NOT NULL , cacheStudentScore INTEGER NOT NULL , cacheMaxScore INTEGER NOT NULL , cacheFinalWeightScoreWithPenalty REAl NOT NULL DEFAULT 0 , cacheWeight INTEGER NOT NULL DEFAULT 0 , cacheProgress INTEGER NOT NULL , cacheContentComplete INTEGER NOT NULL , cacheSuccess INTEGER NOT NULL , cachePenalty INTEGER NOT NULL , lastCsnChecked INTEGER NOT NULL , cacheUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )‚2S55„tableCourseAssignmentMarkCourseAssignmentMark^CREATE TABLE CourseAssignmentMark ( camAssignmentUid INTEGER NOT NULL , camSubmitterUid INTEGER NOT NULL , camMark REAl NOT NULL , camPenalty INTEGER NOT NULL , camLct INTEGER NOT NULL , camUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )‚tRUU„KtableCourseAssignmentSubmissionAttachmentCourseAssignmentSubmissionAttachment]CREATE TABLE CourseAssignmentSubmissionAttachment ( casaSubmissionUid INTEGER NOT NULL , casaMimeType TEXT , casaFileName TEXT , casaUri TEXT , casaMd5 TEXT , casaSize INTEGER NOT NULL , casaTimestamp INTEGER NOT NULL , casaUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )‚hQAA„[tableCourseAssignmentSubmissionCourseAssignmentSubmission[CREATE TABLE CourseAssignmentSubmission ( casAssignmentUid INTEGER NOT NULL , casSubmitterUid INTEGER NOT NULL , casSubmitterPersonUid INTEGER NOT NULL , casText TEXT , casType INTEGER NOT NULL , casTimestamp INTEGER NOT NULL , casUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )6AA…ktableClazzAssignmentConte‚Z!!ƒktableContentJobContentJobeCREATE TABLE ContentJob ( toUri TEXT , cjProgress INTEGER NOT NULL , cjTotal INTEGER NOT NULL , cjNotificationTitle TEXT , cjIsMeteredAllowed INTEGER NOT NULL , params TEXT , cjUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )Y9#Aindexnode_status_person_idxUserSessiondCREATE INDEX node_status_person_idx ON UserSession (usClientNodeId, usStatus, usPersonUid)ƒ0PAA…ktableClazzAssignmentContentJoinClazzAssignmentContentJoinZCREATE TABLE ClazzAssignmentContentJoin ( cacjContentUid INTEGER NOT NULL , cacjAssignmentUid INTEGER NOT NULL , cacjActive INTEGER NOT NULL , cacjWeight INTEGER NOT NULL DEFAULT 0 , cacjMCSN INTEGER NOT NULL , cacjLCSN INTEGER NOT NULL , cacjLCB INTEGER NOT NULL , cacjLct INTEGER NOT NULL , cacjUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )X9#Aindexperson_status_node_idxUserSessioncCREATE INDEX person_status_node_idx ON UserSession (usPersonUid, usStatus, usClientNodeId)ƒVW##†stableUserSessionUserSessionbCREATE TABLE UserSession ( usPcsn INTEGER NOT NULL , usLcsn INTEGER NOT NULL , usLcb INTEGER NOT NULL , usLct INTEGER NOT NULL , usPersonUid INTEGER NOT NULL , usClientNodeId INTEGER NOT NULL , usStartTime INTEGER NOT NULL , usEndTime INTEGER NOT NULL , usStatus INTEGER NOT NULL , usReason INTEGER NOT NULL , usAuth TEXT , usSessionType INTEGER NOT NULL , usUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )         ò2749 ‡y! http://localhost/umapp/#/ContentEntryListView?entityUid=423963139269242880â8:š°â8:š°  ›@ ^“Ìïô8 dS›$  w)/indextable_node_idxReplicationStatusrCREATE UNIQUE INDEX table_node_idx ON ReplicationStatus (tableId, nodeId)ƒ"e//…stableReplicationStatusReplicationStatusqCREATE TABLE ReplicationStatus ( lastFetchReplicationCompleteTime INTEGER NOT NULL , lastLocalChangeTime INTEGER NOT NULL , lastRemoteChangeTime INTEGER NOT NULL , lastSendReplicationCompleteTime INTEGER NOT NULL , nodeId INTEGER NOT NULL , priority INTEGER NOT NULL , tableId INTEGER NOT NULL , repStatusId INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )‚Z!!ƒktableContentJobContentJobeCREATE TABLE ContentJob ( toUri TEXT , cjProgress INTEGER NOT NULL , cjTotal INTEGER NOT NULL , cjNotificationTitle TEXT , cjIsMeteredAllowed INTEGER NOT NULL , params TEXT , cjUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )d‚tableDoorNodeDoorNodepCREATE TABLE DoorNode ( auth TEXT , nodeId INTEGER NOT NULL , rel INTEGER NOT NULL DEFAULT 2 , PRIMARY KEY (nodeId) )‚_))ƒYtableCourseGroupSetCourseGroupSetkCREATE TABLE CourseGroupSet ( cgsName TEXT , cgsTotalGroups INTEGER NOT NULL , cgsActive INTEGER NOT NULL , cgsClazzUid INTEGER NOT NULL , cgsLct INTEGER NOT NULL , cgsUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )H^//‚?tableCourseTerminologyCourseTerminologyjCREATE TABLE CourseTerminology ( ctTitle TEXT , ctTerminology TEXT , ctLct INTEGER NOT NULL , ctUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )…D]##ŠOtableCourseBlockCourseBlockiCREATE TABLE CourseBlock ( cbType INTEGER NOT NULL , cbIndentLevel INTEGER NOT NULL , cbModuleParentBlockUid INTEGER NOT NULL , cbTitle TEXT , cbDescription TEXT , cbCompletionCriteria INTEGER NOT NULL , cbHideUntilDate INTEGER NOT NULL , cbDeadlineDate INTEGER NOT NULL , cbLateSubmissionPenalty INTEGER NOT NULL , cbGracePeriodDate INTEGER NOT NULL , cbMaxPoints INTEGER NOT NULL , cbMinPoints INTEGER NOT NULL , cbIndex INTEGER NOT NULL , cbClazzUid INTEGER NOT NULL , cbActive INTEGER NOT NULL , cbHidden INTEGER NOT NULL , cbEntityUid INTEGER NOT NULL , cbLct INTEGER NOT NULL , cbUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )H\w)}indexindex_ContentJobItem_cjiContentEntryUid_cjiFinishTimeContentJobItemhCREATE INDEX index_ContentJobItem_cjiContentEntryUid_cjiFinishTime ON ContentJobItem (cjiContentEntryUid, cjiFinishTime)‡$[))ŽtableContentJobItemContentJobItemfCREATE TABLE ContentJobItem ( cjiJobUid INTEGER NOT NULL , sourceUri TEXT , cjiIsLeaf INTEGER NOT NULL , cjiContentEntryUid INTEGER NOT NULL , cjiParentContentEntryUid INTEGER NOT NULL , cjiContainerUid INTEGER NOT NULL , cjiItemProgress INTEGER NOT NULL , cjiItemTotal INTEGER NOT NULL , cjiRecursiveProgress INTEGER NOT NULL , cjiRecursiveTotal INTEGER NOT NULL , cjiStatus INTEGER NOT NULL , cjiRecursiveStatus INTEGER NOT NULL , cjiConnectivityNeeded INTEGER NOT NULL , cjiPluginId INTEGER NOT NULL , cjiAttemptCount INTEGER NOT NULL , cjiParentCjiUid INTEGER NOT NULL , cjiServerJobId INTEGER NOT NULL , cjiStartTime INTEGER NOT NULL , cjiFinishTime INTEGER NOT NULL , cjiUploadSessionUid TEXT , cjiContentDeletedOnCancellation INTEGER NOT NULL , cjiContainerProcessed INTEGER NOT NULL , cjiUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )_U/indexsqlite_autoindex_ClazzLogReplicate_1ClazzLogReplicatet¸)/indextable_node_idxc55_tableZombieAttachmentDataZombieAttachmentDataoCREATE TABLE ZombieAttachmentData ( zaUri TEXT , zaUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )1bEindexsqlite_autoindex_ChangeLog_1ChangeLogn9a‚AtableChangeLogChangeLogmCREATE TABLE ChangeLog ( chEntityPk INTEGER NOT NULL , chTableId INTEGER NOT NULL , chType INTEGER NOT NULL , PRIMARY KEY (chTableId, chEntityPk) )‚ `//ƒAtableCourseGroupMemberCourseGroupMemberlCREATE TABLE CourseGroupMember ( cgmSetUid INTEGER NOT NULL , cgmGroupNumber INTEGER NOT NULL , cgmPersonUid INTEGER NOT NULL , cgmLct INTEGER NOT NULL , cgmUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL ) òâ8:š°      t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t tŒ†¥e†¤ev†£ek†¢e`†¡eU† eJâ8B—}`J:â8B—}`J*â8B—}`Jâ8B—}`J â8B—}`Dúâ8B—}`Dêâ8B—}`DÚâ8B—}`BÊâ8B—}`Bºâ8B—}`Bªâ8B—}`Bšâ8B—}`<Šâ8B—}`@zâ8B—}`@jâ8B—}`@Zâ8B—}`@Jâ8B—}`@:â8B—}`>*'> '>'> '>'>ø'>î'>ä'>Ú'>Ð'>Æâ8B—}` ¶â8B—}` ¦' œ' ’' ˆ' ~' t' j' `' V' L' B'š7'š,'š!'š'š 'š  © © © © © © © © © © © © © © © © © © © © © © © © © © © © © © © © © © © © © © © © © © © © © ©ÅÅÅÅÅÅWe†¥4Me†¤3Ce†£29e†¢1/e†¡0%e† /Jâ8B—}`. Jâ8B—}`-ýJâ8B—}`,îJâ8B—}`+ßDâ8B—}`*ÐDâ8B—}`)ÁDâ8B—}`(²Bâ8B—}`'£Bâ8B—}`&”Bâ8B—}`%…Bâ8B—}`$v<â8B—}`#g@â8B—}`"X@â8B—}`!I@â8B—}` :@â8B—}`+@â8B—}`>â8B—}` >'>'û>'ò>'é>'à>'×>'Î>'Å>'¼>'³ â8B—}`¤ â8B—}`• 'Œ 'ƒ 'z ' q ' h ' _ ' V ' M 'D ';š'1š''š'š'š' š'        ½ö³ á % ß | W N¡}rŠ½ƒ ·oGGƒatableC:+g‚eindexindex_CourseAssignmentSubmissionAttachmentReplicate_casaDestination_casaPendingCourseAssignmentSubmissionAttachmentReplicateƒCREATE INDEX index_CourseAssignmentSubmissionAttachmentReplicate_casaDestination_casaPending ON CourseAssignmentSubmissionAttachmentReplicate (casaDestination, casaPending)‚Su=gƒ indexindex_CourseAssignmentSubmissionAttachmentReplicate_casaPk_casaDestination_casaVersionIdCourseAssignmentSubmissionAttachmentReplicate‚CREATE INDEX index_CourseAssignmentSubmissionAttachmentReplicate_casaPk_casaDestination_casaVersionId ON CourseAssignmentSubmissionAttachmentReplicate (casaPk, casaDestination, casaVersionId)uf)/indextable_node_idxReplicationStatusrCREATE UNIQUE INDEX table_node_idx ON ReplicationStatus (tableId, nodeId){t gindexsqlite_autoindex_CourseAssignmentSubmissionAttachmentReplicate_1CourseAssignmentSubmissionAttachmentReplicate‚hsgg„ tableCourseAssignmentSubmissionAttachmentReplicateCourseAssignmentSubmissionAttachmentReplicate€CREATE TABLE CourseAssignmentSubmissionAttachmentReplicate ( casaPk INTEGER NOT NULL , casaVersionId INTEGER NOT NULL DEFAULT 0 , casaDestination INTEGER NOT NULL , casaPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (casaPk, casaDestination) )‚rS‚5indexindex_CourseAssignmentSubmissionReplicate_casDestination_casPendingCourseAssignmentSubmissionReplicateCREATE INDEX index_CourseAssignmentSubmissionReplicate_casDestination_casPending ON CourseAssignmentSubmissionReplicate (casDestination, casPending)‚!q#S‚Windexindex_CourseAssignmentSubmissionReplicate_casPk_casDestination_casVersionIdCourseAssignmentSubmissionReplicate~CREATE INDEX index_CourseAssignmentSubmissionReplicate_casPk_casDestination_casVersionId ON CourseAssignmentSubmissionReplicate (casPk, casDestination, casVersionId)epySindexsqlite_autoindex_CourseAssignmentSubmissionReplicate_1CourseAssignmentSubmissionReplicate}‚CoSSƒmtableCourseAssignmentSubmissionReplicateCourseAssignmentSubmissionReplicate|CREATE TABLE CourseAssignmentSubmissionReplicate ( casPk INTEGER NOT NULL , casVersionId INTEGER NOT NULL DEFAULT 0 , casDestination INTEGER NOT NULL , casPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (casPk, casDestination) )‚nO‚5indexindex_ClazzLogAttendanceRecordReplicate_clarDestination_clarPendingClazzLogAttendanceRecordReplicate{CREATE INDEX index_ClazzLogAttendanceRecordReplicate_clarDestination_clarPending ON ClazzLogAttendanceRecordReplicate (clarDestination, clarPending)‚"m%O‚[indexindex_ClazzLogAttendanceRecordReplicate_clarPk_clarDestination_clarVersionIdClazzLogAttendanceRecordReplicatezCREATE INDEX index_ClazzLogAttendanceRecordReplicate_clarPk_clarDestination_clarVersionId ON ClazzLogAttendanceRecordReplicate (clarPk, clarDestination, clarVersionId)aluOindexsqlite_autoindex_ClazzLogAttendanceRecordReplicate_1ClazzLogAttendanceRecordReplicatey‚CkOOƒutableClazzLogAttendanceRecordReplicateClazzLogAttendanceRecordReplicatexCREATE TABLE ClazzLogAttendanceRecordReplicate ( clarPk INTEGER NOT NULL , clarVersionId INTEGER NOT NULL DEFAULT 0 , clarDestination INTEGER NOT NULL , clarPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (clarPk, clarDestination) )9jk/eindexindex_ClazzLogReplicate_clDestination_clPendingClazzLogReplicatewCREATE INDEX index_ClazzLogReplicate_clDestination_clPending ON ClazzLogReplicate (clDestination, clPending)Oiy/‚indexindex_ClazzLogReplicate_clPk_clDestination_clVersionIdClazzLogReplicateuCREATE INDEX index_ClazzLogReplicate_clPk_clDestination_clVersionId ON ClazzLogReplicate (clPk, clDestination, clVersionId)AhU/indexsqlite_autoindex_ClazzLogReplicate_1ClazzLogReplicatet‚g//ƒ=tableClazzLogReplicateClazzLogReplicatesCREATE TABLE ClazzLogReplicate ( clPk INTEGER NOT NULL , clVersionId INTEGER NOT NULL DEFAULT 0 , clDestination INTEGER NOT NULL , clPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (clPk, clDestination) )                 kËo b n Z  1 hBëò웥bC }<a;indexsqbA‚3indexindex_CourseGr-AAƒ[tableCourseGroupMemberReplicateCourseGroupMemberReplicate•CREATE TABLE CourseGroupMemberReplicate ( cgmPk INTEGER NOT NULL , cgmVersionId INTEGER NOT NULL DEFAULT 0 , cgmDestination INTEGER NOT NULL , cgmPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (cgmPk, cgmDestination) )X{;‚indexindex_CourseGroupSetReplicate_cgsDestination_cgsPendingCourseGroupSetReplicate”CREATE INDEX index_CourseGroupSetReplicate_cgsDestination_cgsPending ON CourseGroupSetReplicate (cgsDestination, cgsPending)‚7v+g‚eindexindex_CourseAssignmentSubmissionAttachmentReplicate_casaDestination_casaPendingCourseAssignmentSubmissionAttachmentReplicateƒCREATE INDEX index_CourseAssignmentSubmissionAttachmentReplicate_casaDestination_casaPending ON CourseAssignmentSubmissionAttachmentReplicate (casaDestination, casaPending)r ;‚'indexindex_CourseGroupSetReplicate_cgsPk_cgsDestination_cgsVersionIdCourseGroupSetReplicate“CREATE INDEX index_CourseGroupSetReplicate_cgsPk_cgsDestination_cgsVersionId ON CourseGroupSetReplicate (cgsPk, cgsDestination, cgsVersionId)Na;indexsqlite_autoindex_CourseGroupSetReplicate_1CourseGroupSetReplicate’‚ ;;ƒUtableCourseGroupSetReplicateCourseGroupSetReplicate‘CREATE TABLE CourseGroupSetReplicate ( cgsPk INTEGER NOT NULL , cgsVersionId INTEGER NOT NULL DEFAULT 0 , cgsDestination INTEGER NOT NULL , cgsPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (cgsPk, cgsDestination) )^}A‚ indexindex_CourseTerminologyReplicate_ctDestination_ctPendingCourseTerminologyReplicateCREATE INDEX index_CourseTerminologyReplicate_ctDestination_ctPending ON CourseTerminologyReplicate (ctDestination, ctPending)u A‚'indexindex_CourseTerminologyReplicate_ctPk_ctDestination_ctVersionIdCourseTerminologyReplicateCREATE INDEX index_CourseTerminologyReplicate_ctPk_ctDestination_ctVersionId ON CourseTerminologyReplicate (ctPk, ctDestination, ctVersionId)TgAindexsqlite_autoindex_CourseTerminologyReplicate_1CourseTerminologyReplicateŽ‚#AAƒOtableCourseTerminologyReplicateCourseTerminologyReplicateCREATE TABLE CourseTerminologyReplicate ( ctPk INTEGER NOT NULL , ctVersionId INTEGER NOT NULL DEFAULT 0 , ctDestination INTEGER NOT NULL , ctPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (ctPk, ctDestination) )F~q5qindexindex_CourseBlockReplicate_cbDestination_cbPendingCourseBlockReplicateŒCREATE INDEX index_CourseBlockReplicate_cbDestination_cbPending ON CourseBlockReplicate (cbDestination, cbPending)\}5‚indexindex_CourseBlockReplicate_cbPk_cbDestination_cbVersionIdCourseBlockReplicate‹CREATE INDEX index_CourseBlockReplicate_cbPk_cbDestination_cbVersionId ON CourseBlockReplicate (cbPk, cbDestination, cbVersionId)H|[5indexsqlite_autoindex_CourseBlockReplicate_1CourseBlockReplicateŠ‚{55ƒCtableCourseBlockReplicateCourseBlockReplicate‰CREATE TABLE CourseBlockReplicate ( cbPk INTEGER NOT NULL , cbVersionId INTEGER NOT NULL DEFAULT 0 , cbDestination INTEGER NOT NULL , cbPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (cbPk, cbDestination) )qzG‚indexindex_CourseAssignmentMarkReplicate_camDestination_camPendingCourseAssignmentMarkReplicateˆCREATE INDEX index_CourseAssignmentMarkReplicate_camDestination_camPending ON CourseAssignmentMarkReplicate (camDestination, camPending)‚ yG‚?indexindex_CourseAssignmentMarkReplicate_camPk_camDestination_camVersionIdCourseAssignmentMarkReplicate†CREATE INDEX index_CourseAssignmentMarkReplicate_camPk_camDestination_camVersionId ON CourseAssignmentMarkReplicate (camPk, camDestination, camVersionId)ZxmGindexsqlite_autoindex_CourseAssignmentMarkReplicate_1CourseAssignmentMarkReplicate…‚2wGGƒatableCourseAssignmentMarkReplicateCourseAssignmentMarkReplicate„CREATE TABLE CourseAssignmentMarkReplicate ( camPk INTEGER NOT NULL , camVersionId INTEGER NOT NULL DEFAULT 0 , camDestination INTEGER NOT NULL , camPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (camPk, camDestination) )                  ‘Ó| z ‘ a   . ºÉïÈ…‡¯‘P_‚#--ƒwt2 +‚+indexindex_PersonReplicate_personPk_personDestination_personVersionIdPersonReplicate¨CREATE INDEX index_PersonReplicate_personPk_personDestination_personVersionId ON PersonReplicate (personPk, personDestination, personVersionId)>Q+indexsqlite_autoindex_PersonReplicate_1PersonReplicate§‚++ƒitablePersonReplicatePersonReplicate¦CREATE TABLE PersonReplicate ( personPk INTEGER NOT NULL , personVersionId INTEGER NOT NULL DEFAULT 0 , personDestination INTEGER NOT NULL , personPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (personPk, personDestination) )T}-‚ indexindex_HolidayReplicate_holidayDestination_holidayPendingHolidayReplicate¥CREATE INDEX index_HolidayReplicate_holidayDestination_holidayPending ON HolidayReplicate (holidayDestination, holidayPending)z-‚;indexindex_HolidayReplicate_holidayPk_holidayDestination_holidayVersionIdHolidayReplicate¤CREATE INDEX index_HolidayReplicate_holidayPk_holidayDestination_holidayVersionId ON HolidayReplicate (holidayPk, holidayDestination, holidayVersionId)@S-indexsqlite_autoindex_HolidayReplicate_1HolidayReplicate£‚#--ƒwtableHolidayReplicateHolidayReplicate¢CREATE TABLE HolidayReplicate ( holidayPk INTEGER NOT NULL , holidayVersionId INTEGER NOT NULL DEFAULT 0 , holidayDestination INTEGER NOT NULL , holidayPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (holidayPk, holidayDestination) )Vy=‚indexindex_HolidayCalendarReplicate_hcDestination_hcPendingHolidayCalendarReplicate¡CREATE INDEX index_HolidayCalendarReplicate_hcDestination_hcPending ON HolidayCalendarReplicate (hcDestination, hcPending)m=‚indexindex_HolidayCalendarReplicate_hcPk_hcDestination_hcVersionIdHolidayCalendarReplicate CREATE INDEX index_HolidayCalendarReplicate_hcPk_hcDestination_hcVersionId ON HolidayCalendarReplicate (hcPk, hcDestination, hcVersionId)Pc=indexsqlite_autoindex_HolidayCalendarReplicate_1HolidayCalendarReplicateŸ‚==ƒKtableHolidayCalendarReplicateHolidayCalendarReplicatežCREATE TABLE HolidayCalendarReplicate ( hcPk INTEGER NOT NULL , hcVersionId INTEGER NOT NULL DEFAULT 0 , hcDestination INTEGER NOT NULL , hcPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (hcPk, hcDestination) )_/‚indexindex_ScheduleReplicate_scheduleDestination_schedulePendingScheduleReplicateCREATE INDEX index_ScheduleReplicate_scheduleDestination_schedulePending ON ScheduleReplicate (scheduleDestination, schedulePending)‚ /‚Kindexindex_ScheduleReplicate_schedulePk_scheduleDestination_scheduleVersionIdScheduleReplicateœCREATE INDEX index_ScheduleReplicate_schedulePk_scheduleDestination_scheduleVersionId ON ScheduleReplicate (schedulePk, scheduleDestination, scheduleVersionId)B U/indexsqlite_autoindex_ScheduleReplicate_1ScheduleReplicate›‚, //„tableScheduleReplicateScheduleReplicatešCREATE TABLE ScheduleReplicate ( schedulePk INTEGER NOT NULL , scheduleVersionId INTEGER NOT NULL DEFAULT 0 , scheduleDestination INTEGER NOT NULL , schedulePending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (schedulePk, scheduleDestination) )e A‚indexindex_CourseGroupMemberReplicate_cgmDestination_cgmPendingCourseGroupMemberReplicate˜CREATE INDEX index_CourseGroupMemberReplicate_cgmDestination_cgmPending ON CourseGroupMemberReplicate (cgmDestination, cgmPending)~ A‚3indexindex_CourseGroupMemberReplicate_cgmPk_cgmDestination_cgmVersionIdCourseGroupMemberReplicate—CREATE INDEX index_CourseGroupMemberReplicate_cgmPk_cgmDestination_cgmVersionId ON CourseGroupMemberReplicate (cgmPk, cgmDestination, cgmVersionId)TgAindexsqlite_autoindex_CourseGroupMemberReplicate_1CourseGroupMemberReplicate–‚)AAƒ[tableCourseGroupMemberReplicateCourseGroupMemberReplicate•CREATE TABLE CourseGroupMemberReplicate ( cgmPk INTEGER NOT NULL , cgmVersionId INTEGER NOT NULL DEFAULT 0 , cgmDestination INTEGER NOT NULL , cgmPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (cgmPk, cgmDestination) )                    •Tc2 Þ ú 6  Ç Ú éš±ßÇz••2c]]„tableContentEntryContentCategoryJoinReplicateContentEntryContentCategoryJoinReplicate»CREATE TABLE ContentEntryContentCategoryJoinReplicate ( ceccjPk INTEGER NOT NULL , ceccjVersionId INTEGER NOT NULL DEFAULT 0 , ceccjDestination INTEGER NOT NULL , ceccjPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (ceccjPk, ceccjDestination) )J*s7uindexindex_ContentEntryReplicate_ceDestination_cePendingContentEntryReplicateºCREATE INDEX index_ContentEntryReplicate_ceDestination_cePending ON ContentEntryReplicate (ceDestination, cePending)m +‚+indexindex_PersonReplicate_personPk_personDestination_personVersionIdPersonReplicate¨CREATE INDEX index_PersonReplicate_personPk_personDestination_personVersionId ON PersonReplicate (personPk, personDestination, personVersionId)>Q+indexsqlite_autoindex_PersonReplicate_1PersonReplicate§a)7‚indexindex_ContentEntryReplicate_cePk_ceDestination_ceVersionIdContentEntryReplicate¹CREATE INDEX index_ContentEntryReplicate_cePk_ceDestination_ceVersionId ON ContentEntryReplicate (cePk, ceDestination, ceVersionId)J(]7indexsqlite_autoindex_ContentEntryReplicate_1ContentEntryReplicate¸‚'77ƒEtableContentEntryReplicateContentEntryReplicate·CREATE TABLE ContentEntryReplicate ( cePk INTEGER NOT NULL , ceVersionId INTEGER NOT NULL DEFAULT 0 , ceDestination INTEGER NOT NULL , cePending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (cePk, ceDestination) )N&u9yindexindex_LeavingReasonReplicate_lrDestination_lrPendingLeavingReasonReplicate¶CREATE INDEX index_LeavingReasonReplicate_lrDestination_lrPending ON LeavingReasonReplicate (lrDestination, lrPending)e%9‚indexindex_LeavingReasonReplicate_lrPk_lrDestination_lrVersionIdLeavingReasonReplicateµCREATE INDEX index_LeavingReasonReplicate_lrPk_lrDestination_lrVersionId ON LeavingReasonReplicate (lrPk, lrDestination, lrVersionId)L$_9indexsqlite_autoindex_LeavingReasonReplicate_1LeavingReasonReplicate´‚#99ƒGtableLeavingReasonReplicateLeavingReasonReplicate³CREATE TABLE LeavingReasonReplicate ( lrPk INTEGER NOT NULL , lrVersionId INTEGER NOT NULL DEFAULT 0 , lrDestination INTEGER NOT NULL , lrPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (lrPk, lrDestination) )R"w;}indexindex_ClazzEnrolmentReplicate_ceDestination_cePendingClazzEnrolmentReplicate²CREATE INDEX index_ClazzEnrolmentReplicate_ceDestination_cePending ON ClazzEnrolmentReplicate (ceDestination, cePending)i!;‚indexindex_ClazzEnrolmentReplicate_cePk_ceDestination_ceVersionIdClazzEnrolmentReplicate±CREATE INDEX index_ClazzEnrolmentReplicate_cePk_ceDestination_ceVersionId ON ClazzEnrolmentReplicate (cePk, ceDestination, ceVersionId)N a;indexsqlite_autoindex_ClazzEnrolmentReplicate_1ClazzEnrolmentReplicate°‚;;ƒItableClazzEnrolmentReplicateClazzEnrolmentReplicate¯CREATE TABLE ClazzEnrolmentReplicate ( cePk INTEGER NOT NULL , ceVersionId INTEGER NOT NULL DEFAULT 0 , ceDestination INTEGER NOT NULL , cePending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (cePk, ceDestination) )@q)qindexindex_ClazzReplicate_clazzDestination_clazzPendingClazzReplicate®CREATE INDEX index_ClazzReplicate_clazzDestination_clazzPending ON ClazzReplicate (clazzDestination, clazzPending)`)‚indexindex_ClazzReplicate_clazzPk_clazzDestination_clazzVersionIdClazzReplicate¬CREATE INDEX index_ClazzReplicate_clazzPk_clazzDestination_clazzVersionId ON ClazzReplicate (clazzPk, clazzDestination, clazzVersionId)<O)indexsqlite_autoindex_ClazzReplicate_1ClazzReplicate«‚))ƒ[tableClazzReplicateClazzReplicateªCREATE TABLE ClazzReplicate ( clazzPk INTEGER NOT NULL , clazzVersionId INTEGER NOT NULL DEFAULT 0 , clazzDestination INTEGER NOT NULL , clazzPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (clazzPk, clazzDestination) )Jw+}indexindex_PersonReplicate_personDestination_personPendingPersonReplicate©CREATE INDEX index_PersonReplicate_personDestination_personPending ON PersonReplicate (personDestination, personPending)                  é N [ p®rUŽèN : >< é <!==ƒKtabl éI‚Cindexindex_ContentCategorySchemaReplicate_ccsPk_ccsDestination_ccsVersionIdContentCategorySchemaReplicateÊCREATE INDEX index_ContentCategorySchemaReplicate_ccsPk_ccsDestination_ccsVersionId ON ContentCategorySchemaReplicate (ccsPk, ccsDestination, ccsVersionId)‚<53W‚windexindex_ContentEntryRelatedEntryJoinReplicate_cerejPk_cerejDestination_cerejVersionIdContentEntryRelatedEntryJoinReplicateÆCREATE INDEX index_ContentEntryRelatedEntryJoinReplicate_cerejPk_cerejDestination_cerejVersionId ON ContentEntryRelatedEntryJoinReplicate (cerejPk, cerejDestination, cerejVersionId)‚V3WW„ tableContentEntryRelatedEntryJoinReplicateContentEntryRelatedEntryJoinReplicateÄCREATE TABLE ContentEntryRelatedEntryJoinReplicate ( cerejPk INTEGER NOT NULL , cerejVersionId INTEGER NOT NULL DEFAULT 0 , cerejDestination INTEGER NOT NULL , cerejPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (cerejPk, cerejDestination) )j4}Windexsqlite_autoindex_ContentEntryRelatedEntryJoinReplicate_1ContentEntryRelatedEntryJoinReplicateÅ‚2U‚Iindexindex_ContentEntryParentChildJoinReplicate_cepcjDestination_cepcjPendingContentEntryParentChildJoinReplicateÃCREATE INDEX index_ContentEntryParentChildJoinReplicate_cepcjDestination_cepcjPending ON ContentEntryParentChildJoinReplicate (cepcjDestination, cepcjPending)‚811U‚sindexindex_ContentEntryParentChildJoinReplicate_cepcjPk_cepcjDestination_cepcjVersionIdContentEntryParentChildJoinReplicateÂCREATE INDEX index_ContentEntryParentChildJoinReplicate_cepcjPk_cepcjDestination_cepcjVersionId ON ContentEntryParentChildJoinReplicate (cepcjPk, cepcjDestination, cepcjVersionId)‚S/UU„tableContentEntryParentChildJoinReplicateContentEntryParentChildJoinReplicateÀCREATE TABLE ContentEntryParentChildJoinReplicate ( cepcjPk INTEGER NOT NULL , cepcjVersionId INTEGER NOT NULL DEFAULT 0 , cepcjDestination INTEGER NOT NULL , cepcjPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (cepcjPk, cepcjDestination) )h0{Uindexsqlite_autoindex_ContentEntryParentChildJoinReplicate_1ContentEntryParentChildJoinReplicateÁ‚).%]‚Yindexindex_ContentEntryContentCategoryJoinReplicate_ceccjDestination_ceccjPendingContentEntryContentCategoryJoinReplicate¾CREATE INDEX index_ContentEntryContentCategoryJoinReplicate_ceccjDestination_ceccjPending ON ContentEntryContentCategoryJoinReplicate (ceccjDestination, ceccjPending)‚H-9]ƒindexindex_ContentEntryContentCategoryJoinReplicate_ceccjPk_ceccjDestination_ceccjVersionIdContentEntryContentCategoryJoinReplicate½CREATE INDEX index_ContentEntryContentCategoryJoinReplicate_ceccjPk_ceccjDestination_ceccjVersionId ON ContentEntryContentCategoryJoinReplicate (ceccjPk, ceccjDestination, ceccjVersionId) Ïc=indexsqlite_aut‚57IIƒctableContentCategorySchemaReplicateContentCategorySchemaReplicateÈCREATE TABLE ContentCategorySchemaReplicate ( ccsPk INTEGER NOT NULL , ccsVersionId INTEGER NOT NULL DEFAULT 0 , ccsDestination INTEGER NOT NULL , ccsPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (ccsPk, ccsDestination) )‚6W‚Mindexindex_ContentEntryRelatedEntryJoinReplicate_cerejDestination_cerejPendingContentEntryRelatedEntryJoinReplicateÇCREATE INDEX index_ContentEntryRelatedEntryJoinReplicate_cerejDestination_cerejPending ON ContentEntryRelatedEntryJoinReplicate (cerejDestination, cerejPending)q,]indexsqlite_autoindex_ContentEntryContentCategoryJoinReplicate_1ContentEntryContentCategoryJoinReplicate¼Î]]„tableContentEntryContentCategoryJoinReplicateContentEntryContentCategoryJoinReplicate»CREATE TABLE \8oIindexsqlite_autoindex_ContentCategorySchemaReplicate_1ContentCategorySchemaReplicateÉ‚_+]]„tableContentEntryContentCategoryJoinReplicateContentEntryContentCategoryJoinReplicate»CREATE TABLE ContentEntryContentCategoryJoinReplicate ( ceccjPk INTEGER NOT NULL , ceccjVersionId INTEGER NOT NULL DEFAULT 0 , ceccjDestination INTEGER NOT NULL , ceccjPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (ceccjPk, ceccjDestination) )                ˆ) ߌ › Á ‘ L A ^=êùzÔ)_ˆÊq5qindexindex_PersonGroupReplicate_pgDestination_pgPendingPersonGroupReplicateÜCREATE INDEX index_PersonGroupReplicate_pgDestination_pgPending ON PersonGroupReplicate (pgDestination, pgPending)\I5‚indexindex_PersonGroupReplicate_pgPk_pgDestination_pgVersionIdPersonGroupReplicateÛCREATE INDEX index_PersonGroupReplicate_pgPk_pgDestination_pgVersionId ON PersonGroupReplicate (pgPk, pgDestination, pgVersionId)‚9I‚Cindexindex_ContentCategorySchemaReplicate_ccsPk_ccsDestination_ccsVersionIdContentCategorySchemaReplicateÊCREATE INDEX index_ContentCategorySchemaReplicate_ccsPk_ccsDestination_ccsVersionId ON ContentCategorySchemaReplicate (ccsPk, ccsDestination, ccsVersionId)\8oIindexsqlite_autoindex_ContentCategorySchemaReplicate_1ContentCategorySchemaReplicateÉ‚G55ƒCtablePersonGroupReplicatePersonGroupReplicateÙCREATE TABLE PersonGroupReplicate ( pgPk INTEGER NOT NULL , pgVersionId INTEGER NOT NULL DEFAULT 0 , pgDestination INTEGER NOT NULL , pgPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (pgPk, pgDestination) )u: I‚!indexindex_ContentCategorySchemaReplicate_ccsDestination_ccsPendingContentCategorySchemaReplicateËCREATE INDEX index_ContentCategorySchemaReplicate_ccsDestination_ccsPending ON ContentCategorySchemaReplicate (ccsDestination, ccsPending)LI‚Cindexindex_ContentCategorySchemaReplicate_ccsPk_ccsDestination_cHH[5indexsqlite_autoindex_PersonGroupReplicate_1PersonGroupReplicateÚVFy=‚indexindex_LanguageVariantReplicate_lvDestination_lvPendingLanguageVariantReplicateØCREATE INDEX index_LanguageVariantReplicate_lvDestination_lvPending ON LanguageVariantReplicate (lvDestination, lvPending)mE=‚indexindex_LanguageVariantReplicate_lvPk_lvDestination_lvVersionIdLanguageVariantReplicate×CREATE INDEX index_LanguageVariantReplicate_lvPk_lvDestination_lvVersionId ON LanguageVariantReplicate (lvPk, lvDestination, lvVersionId)PDc=indexsqlite_autoindex_LanguageVariantReplicate_1LanguageVariantReplicateÖ‚C==ƒKtableLanguageVariantReplicateLanguageVariantReplicateÕCREATE TABLE LanguageVariantReplicate ( lvPk INTEGER NOT NULL , lvVersionId INTEGER NOT NULL DEFAULT 0 , lvDestination INTEGER NOT NULL , lvPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (lvPk, lvDestination) )_B/‚indexindex_LanguageReplicate_languageDestination_languagePendingLanguageReplicateÔCREATE INDEX index_LanguageReplicate_languageDestination_languagePending ON LanguageReplicate (languageDestination, languagePending)‚A/‚Kindexindex_LanguageReplicate_languagePk_languageDestination_languageVersionIdLanguageReplicateÓCREATE INDEX index_LanguageReplicate_languagePk_languageDestination_languageVersionId ON LanguageReplicate (languagePk, languageDestination, languageVersionId)B@U/indexsqlite_autoindex_LanguageReplicate_1LanguageReplicateÒ‚,?//„tableLanguageReplicateLanguageReplicateÑCREATE TABLE LanguageReplicate ( languagePk INTEGER NOT NULL , languageVersionId INTEGER NOT NULL DEFAULT 0 , languageDestination INTEGER NOT NULL , languagePending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (languagePk, languageDestination) )V>y=‚indexindex_ContentCategoryReplicate_ccDestination_ccPendingContentCategoryReplicateÐCREATE INDEX index_ContentCategoryReplicate_ccDestination_ccPending ON ContentCategoryReplicate (ccDestination, ccPending)m==‚indexindex_ContentCategoryReplicate_ccPk_ccDestination_ccVersionIdContentCategoryReplicateÎCREATE INDEX index_ContentCategoryReplicate_ccPk_ccDestination_ccVersionId ON ContentCategoryReplicate (ccPk, ccDestination, ccVersionId)P<c=indexsqlite_autoindex_ContentCategoryReplicate_1ContentCategoryReplicateÍ‚;==ƒKtableContentCategoryReplicateContentCategoryReplicateÌCREATE TABLE ContentCategoryReplicate ( ccPk INTEGER NOT NULL , ccVersionId INTEGER NOT NULL DEFAULT 0 , ccDestination INTEGER NOT NULL , ccPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (ccPk, ccDestination) )                    Ó| z ‘ v ' > l3ìÔçÕŒ°êÿ°LL¤®c=indexsqlite_autoindex_StatementEntityReplicate_1Stab 9‚#indexindex_XObjectEntityReplp_9indexsqlite_autoindex_XObjectEntityReplicate_1XObjectEntityReplicateï‚[99ƒStableXObjectEntityReplicateXObjectEntityReplicateîCREATE TABLE XObjectEntityReplicate ( xoePk INTEGER NOT NULL , xoeVersionId INTEGER NOT NULL DEFAULT 0 , xoeDestination INTEGER NOT NULL , xoePending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (xoePk, xoeDestination) )FJq5qindexindex_PersonGroupReplicate_pgDestination_pgPendingPersonGroupReplicateÜCREATE INDEX index_PersonGroupReplicate_pgDestination_pgPending ON PersonGroupReplicate (pgDestination, pgPending)BZo3mindexindex_VerbEntityReplicate_veDestination_vePendingVerbEntityReplicateíCREATE INDEX index_VerbEntityReplicate_veDestination_vePending ON VerbEntityReplicate (veDestination, vePending)XY}3‚ indexindex_VerbEntityReplicate_vePk_veDestination_veVersionIdVerbEntityReplicateìCREATE INDEX index_VerbEntityReplicate_vePk_veDestination_veVersionId ON VerbEntityReplicate (vePk, veDestination, veVersionId)FXY3indexsqlite_autoindex_VerbEntityReplicate_1VerbEntityReplicateë‚W33ƒAtableVerbEntityReplicateVerbEntityReplicateêCREATE TABLE VerbEntityReplicate ( vePk INTEGER NOT NULL , veVersionId INTEGER NOT NULL DEFAULT 0 , veDestination INTEGER NOT NULL , vePending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (vePk, veDestination) )iV 1‚!indexindex_ContainerReplicate_containerDestination_containerPendingContainerReplicateéCREATE INDEX index_ContainerReplicate_containerDestination_containerPending ON ContainerReplicate (containerDestination, containerPending)‚U%1‚[indexindex_ContainerReplicate_containerPk_containerDestination_containerVersionIdContainerReplicateèCREATE INDEX index_ContainerReplicate_containerPk_containerDestination_containerVersionId ON ContainerReplicate (containerPk, containerDestination, containerVersionId)DTW1indexsqlite_autoindex_ContainerReplicate_1ContainerReplicateç‚5S11„tableContainerReplicateContainerReplicateæCREATE TABLE ContainerReplicate ( containerPk INTEGER NOT NULL , containerVersionId INTEGER NOT NULL DEFAULT 0 , containerDestination INTEGER NOT NULL , containerPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (containerPk, containerDestination) )NRu9yindexindex_PersonPictureReplicate_ppDestination_ppPendingPersonPictureReplicateåCREATE INDEX index_PersonPictureReplicate_ppDestination_ppPending ON PersonPictureReplicate (ppDestination, ppPending)eQ9‚indexindex_PersonPictureReplicate_ppPk_ppDestination_ppVersionIdPersonPictureReplicateäCREATE INDEX index_PersonPictureReplicate_ppPk_ppDestination_ppVersionId ON PersonPictureReplicate (ppPk, ppDestination, ppVersionId)LP_9indexsqlite_autoindex_PersonPictureReplicate_1PersonPictureReplicateã‚O99ƒGtablePersonPictureReplicatePersonPictureReplicateâCREATE TABLE PersonPictureReplicate ( ppPk INTEGER NOT NULL , ppVersionId INTEGER NOT NULL DEFAULT 0 , ppDestination INTEGER NOT NULL , ppPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (ppPk, ppDestination) )eNA‚indexindex_PersonGroupMemberReplicate_pgmDestination_pgmPendingPersonGroupMemberReplicateàCREATE INDEX index_PersonGroupMemberReplicate_pgmDestination_pgmPending ON PersonGroupMemberReplicate (pgmDestination, pgmPending)~MA‚3indexindex_PersonGroupMemberReplicate_pgmPk_pgmDestination_pgmVersionIdPersonGroupMemberReplicateßCREATE INDEX index_PersonGroupMemberReplicate_pgmPk_pgmDestination_pgmVersionId ON PersonGroupMemberReplicate (pgmPk, pgmDestination, pgmVersionId)TLgAindexsqlite_autoindex_PersonGroupMemberReplicate_1PersonGroupMemberReplicateÞ‚)KAAƒ[tablePersonGroupMemberReplicatePersonGroupMemberReplicateÝCREATE TABLE PersonGroupMemberReplicate ( pgmPk INTEGER NOT NULL , pgmVersionId INTEGER NOT NULL DEFAULT 0 , pgmDestination INTEGER NOT NULL , pgmPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (pgmPk, pgmDestination) )                   Ó,ß ž û Ú ‡–¼úQ¾¡AV ¾ ô,L ÓVCCƒ]tableStateConten Óõq5qindexindex_StateEntityReplicate_seDestination_sePendingStateEntityReplicateCREATE INDEX index_StateEntityReplicate_seDestination_sePending ON StateEntityReplicate (seDestination, sePending)\m5‚indexindex_‚k55ƒCtableStateEntityReplicateStateEntityReplicateÿCREATE TABLE StateEntityReplicate ( sePk INTEGER NOT NULL , seVersionId INTEGER NOT NULL DEFAULT 0 , seDestination INTEGER NOT NULL , sePending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (sePk, seDestination) )‚g55ƒCtableAgentEntityReplicateAgentEntityReplicateûCREATE TABLE AgentEntityReplicate ( aePk INTEGER NOT NULL , aeVersionId INTEGER NOT NULL DEFAULT 0 , aeDestination INTEGER NOT NULL , aePending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (aePk, aeDestination) )Hh[5indexsqlite_autoindex_AgentEntityReplicate_1AgentEntityReplicateü‚fU‚Iindexindex_ContextXObjectStatementJoinReplicate_cxosjDestination_cxosjPendingContextXObjectStatementJoinReplicateúCREATE INDEX index_ContextXObjectStatementJoinReplicate_cxosjDestination_cxosjPending ON ContextXObjectStatementJoinReplicate (cxosjDestination, cxosjPending)‚8e1U‚sindexindex_ContextXObjectStatementJoinReplicate_cxosjPk_cxosjDestination_cxosjVersionIdContextXObjectStatementJoinReplicateùCREATE INDEX index_ContextXObjectStatementJoinReplicate_cxosjPk_cxosjDestination_cxosjVersionId ON ContextXObjectStatementJoinReplicate (cxosjPk, cxosjDestination, cxosjVersionId)‚ScUU„tableContextXObjectStatementJoinReplicateContextXObjectStatementJoinReplicate÷CREATE TABLE ContextXObjectStatementJoinReplicate ( cxosjPk INTEGER NOT NULL , cxosjVersionId INTEGER NOT NULL DEFAULT 0 , cxosjDestination INTEGER NOT NULL , cxosjPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (cxosjPk, cxosjDestination) )hd{Uindexsqlite_autoindex_ContextXObjectStatementJoinReplicate_1ContextXObjectStatementJoinReplicateøVby=‚indexindex_StatementEntityReplicate_seDestination_sePendingStatementEntityReplicateöCREATE INDEX index_StatementEntityReplicate_seDestination_sePending ON StatementEntityReplicate (seDestination, sePending)ma=‚indexindex_StatementEntityReplicate_sePk_seDestination_seVersionIdStatementEntityReplicateõCREATE INDEX index_StatementEntityReplicate_sePk_seDestination_seVersionId ON StatementEntityReplicate (sePk, seDestination, seVersionId)P`c=indexsqlite_autoindex_StatementEntityReplicate_1StatementEntityReplicateó‚_==ƒKtableStatementEntityReplicateStatementEntityReplicateòCREATE TABLE StatementEntityReplicate ( sePk INTEGER NOT NULL , seVersionId INTEGER NOT NULL DEFAULT 0 , seDestination INTEGER NOT NULL , sePending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (sePk, seDestination) )T^y9‚indexindex_XObjectEntityReplicate_xoeDestination_xoePendingXObjectEntityReplicateñCREATE INDEX index_XObjectEntityReplicate_xoeDestination_xoePending ON XObjectEntityReplicate (xoeDestination, xoePending)!iCindexsqlite_autoindex_StFjq5qindexindex_AgentEntityReplicate_aeDestination_aePendingAgentEntityReplicateþCREATE INDEX index_AgentEntityReplicate_aeDestination_aePending ON AgentEntityReplicate (aeDestination, aePending)\i5‚indexindex_AgentEntityReplicate_aePk_aeDestination_aeVersionIdAgentEntityReplicateýCREATE INDEX index_AgentEntityReplicate_aePk_aeDestination_aeVersionId ON AgentEntityReplicate (aePk, aeDestination, aeVersionId)n] 9‚#indexindex_XObjectEntityReplicate_xoePk_xoeDestination_xoeVersionIdXObjectEntityReplicateðCREATE INDEX index_XObjectEntityReplicate_xoePk_xoeDestination_xoeVersionId ON XObjectEntityReplicate (xoePk, xoeDestination, xoeVersionId)L\_9indexsqlite_autoindex_XObjectEntityReplicate_1XObjectEntityReplicateï‚[99ƒStableXObjectEntityReplicateXObjectEntityReplicateîCREATE TABLE XObjectEntityReplicate ( xoePk INTEGER NOT NULL , xoeVersionId INTEGER NOT NULL DEFAULT 0 , xoeDestination INTEGER NOT NULL , xoePending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (xoePk, xoeDestination) )                  À  À ö 7 1DÎõÓõ–´¥ ( Û¿ À&/‚Kindexindex_CommentsReplicate_commentsPk_commentsDest ÀÎs7uindexindex_SchoolMemberReplicate_smDestination_smPendingSchoolMemberReplicateCREATE INDEX index_SchoolMemberReplicate_smDestination_smPending ON SchoolMemberReplicate (smDestination, smPending)‚{77ƒEtableSchoolMemberReplicateSchoolMemberReplicateCREATE TABLE SchoolMemberReplicate ( smPk INTEGER NOT NULL , smVersionId INTEGER NOT NULL DEFAULT 0 , smDestination INTEGER NOT NULL , smPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (smPk, smDestination) )my +‚+indexindex_SchoolReplicate_schoolPk_schoolDestination_schoolVersionIdSchoolReplicateCREATE INDEX index_SchoolReplicate_schoolPk_schoolDestination_schoolVersionId ON SchoolReplicate (schoolPk, schoolDestination, schoolVersionId)‚w++ƒitableSchoolReplicateSchoolReplicate CREATE TABLE SchoolReplicate ( schoolPk INTEGER NOT NULL , schoolVersionId INTEGER NOT NULL DEFAULT 0 , schoolDestination INTEGER NOT NULL , schoolPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (schoolPk, schoolDestination) )>xQ+indexsqlite_autoindex_SchoolReplicate_1SchoolReplicate Zv}9‚ indexindex_XLangMapEntryReplicate_xlmeDestination_xlmePendingXLangMapEntryReplicate CREATE INDEX index_XLangMapEntryReplicate_xlmeDestination_xlmePending ON XLangMapEntryReplicate (xlmeDestination, xlmePending)wu9‚/indexindex_XLangMapEntryReplicate_xlmePk_xlmeDestination_xlmeVersionIdXLangMapEntryReplicate CREATE INDEX index_XLangMapEntryReplicate_xlmePk_xlmeDestination_xlmeVersionId ON XLangMapEntryReplicate (xlmePk, xlmeDestination, xlmeVersionId)‚#s99ƒ_tableXLangMapEntryReplicateXLangMapEntryReplicateCREATE TABLE XLangMapEntryReplicate ( xlmePk INTEGER NOT NULL , xlmeVersionId INTEGER NOT NULL DEFAULT 0 , xlmeDestination INTEGER NOT NULL , xlmePending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (xlmePk, xlmeDestination) )Lt_9indexsqlite_autoindex_XLangMapEntryReplicate_1XLangMapEntryReplicate irC‚indexindex_StateContentEntityReplicate_sceDestination_scePendingStateContentEntityReplicateCREATE INDEX index_StateContentEntityReplicate_sceDestination_scePending ON StateContentEntityReplicate (sceDestination, scePending)‚qC‚7indexindex_StateContentEntityReplicate_scePk_sceDestination_sceVersionIdStateContentEntityReplicateCREATE INDEX index_StateContentEntityReplicate_scePk_sceDestination_sceVersionId ON StateContentEntityReplicate (scePk, sceDestination, sceVersionId)VpiCindexsqlite_autoindex_StateContentEntityReplicate_1StateContentEntityReplicate‚,oCCƒ]tableStateContentEntityReplicateStateContentEntityReplicateCREATE TABLE StateContentEntityReplicate ( scePk INTEGER NOT NULL , sceVersionId INTEGER NOT NULL DEFAULT 0 , sceDestination INTEGER NOT NULL , scePending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (scePk, sceDestination) )ë//„tableCommentsRepJ|]7indexsqlite_autoindex_SchoolMemberReplicate_1SchoolMemberReplicateJzw+}indexindex_SchoolReplicate_schoolDestination_schoolPendingSchoolReplicateCREATE INDEX index_SchoolReplicate_schoolDestination_schoolPending ON SchoolReplicate (schoolDestination, schoolPending)Fnq5qindexindex_StateEntityReplicate_seDestination_sePendingStateEntityReplicateCREATE INDEX index_StateEntityReplicate_seDestination_sePending ON StateEntityReplicate (seDestination, sePending)\m5‚indexindex_StateEntityReplicate_sePk_seDestination_seVersionIdStateEntityReplicateCREATE INDEX index_StateEntityReplicate_sePk_seDestination_seVersionId ON StateEntityReplicate (sePk, seDestination, seVersionId)Hl[5indexsqlite_autoindex_StateEntityReplicate_1StateEntityReplicate055ƒCtableStateEntityReplicateStateEntityRa}7‚indexindex_SchoolMemberReplicate_smPk_smDestination_smVersionIdSchoolMemberReplicateCREATE INDEX index_SchoolMemberReplicate_smPk_smDestination_smVersionId ON SchoolMemberReplicate (smPk, smDestination, smVersionId)                  72 ½ ² Ï ± p ±¥h’ØÀsŽÀ71C‚7indexindex_LearnerGroupMemberReplicate_lgmPk_lgmDestination_lgmVersionIdLearnerGroupMemberReplicate'CREATE INDEX index_LearnerGroupMemberReplicate_lgmPk_lgmDestination_lgmVersionId ON LearnerGroupMemberReplicate (lgmPk, lgmDestination, lgmVersionId)V‚iCindexsqlite_autoindex_LearnerGroupMemberReplicate_1LearnerGroupMemberReplicate&‚,‚CCƒ]tableLearnerGroupMemberReplicateLearnerGroupMemberReplicate%CREATE TABLE LearnerGroupMemberReplicate ( lgmPk INTEGER NOT NULL , lgmVersionId INTEGER NOT NULL DEFAULT 0 , lgmDestination INTEGER NOT NULL , lgmPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (lgmPk, lgmDestination) )J‚s7uindexindex_LearnerGroupReplicate_lgDestination_lgPendingLearnerGroupReplicate$CREATE INDEX index_LearnerGroupReplicate_lgDestination_lgPending ON LearnerGroupReplicate (lgDestination, lgPending)a‚ 7‚indexindex_LearnerGroupReplicate_lgPk_lgDestination_lgVersionIdLearnerGroupReplicate#CREATE INDEX index_LearnerGroupReplicate_lgPk_lgDestination_lgVersionId ON LearnerGroupReplicate (lgPk, lgDestination, lgVersionId)J‚ ]7indexsqlite_autoindex_LearnerGroupReplicate_1LearnerGroupReplicate"‚‚ 77ƒEtableLearnerGroupReplicateLearnerGroupReplicate!CREATE TABLE LearnerGroupReplicate ( lgPk INTEGER NOT NULL , lgVersionId INTEGER NOT NULL DEFAULT 0 , lgDestination INTEGER NOT NULL , lgPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (lgPk, lgDestination) )6‚ k'eindexindex_SiteReplicate_siteDestination_sitePendingSiteReplicate CREATE INDEX index_SiteReplicate_siteDestination_sitePending ON SiteReplicate (siteDestination, sitePending)R‚ }'‚ indexindex_SiteReplicate_sitePk_siteDestination_siteVersionIdSiteReplicateCREATE INDEX index_SiteReplicate_sitePk_siteDestination_siteVersionId ON SiteReplicate (sitePk, siteDestination, siteVersionId):‚M'indexsqlite_autoindex_SiteReplicate_1SiteReplicate‚‚''ƒMtableSiteReplicateSiteReplicateCREATE TABLE SiteReplicate ( sitePk INTEGER NOT NULL , siteVersionId INTEGER NOT NULL DEFAULT 0 , siteDestination INTEGER NOT NULL , sitePending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (sitePk, siteDestination) )J‚w+}indexindex_ReportReplicate_reportDestination_reportPendingReportReplicateCREATE INDEX index_ReportReplicate_reportDestination_reportPending ON ReportReplicate (reportDestination, reportPending)m‚ +‚+indexindex_ReportReplicate_reportPk_reportDestination_reportVersionIdReportReplicateCREATE INDEX index_ReportReplicate_reportPk_reportDestination_reportVersionId ON ReportReplicate (reportPk, reportDestination, reportVersionId)>‚Q+indexsqlite_autoindex_ReportReplicate_1ReportReplicate‚‚++ƒitableReportReplicateReportReplicateCREATE TABLE ReportReplicate ( reportPk INTEGER NOT NULL , reportVersionId INTEGER NOT NULL DEFAULT 0 , reportDestination INTEGER NOT NULL , reportPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (reportPk, reportDestination) )_‚/‚indexindex_CommentsReplicate_commentsDestination_commentsPendingCommentsReplicateCREATE INDEX index_CommentsReplicate_commentsDestination_commentsPending ON CommentsReplicate (commentsDestination, commentsPending)‚‚/‚Kindexindex_CommentsReplicate_commentsPk_commentsDestination_commentsVersionIdCommentsReplicateCREATE INDEX index_CommentsReplicate_commentsPk_commentsDestination_commentsVersionId ON CommentsReplicate (commentsPk, commentsDestination, commentsVersionId)B‚U/indexsqlite_autoindex_CommentsReplicate_1CommentsReplicate‚,//„tableCommentsReplicateCommentsReplicateCREATE TABLE CommentsReplicate ( commentsPk INTEGER NOT NULL , commentsVersionId INTEGER NOT NULL DEFAULT 0 , commentsDestination INTEGER NOT NULL , commentsPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (commentsPk, commentsDestination) )J~s7uindexindex_SchoolMemberReplicate_smDestination_smPendingSchoolMemberReplicateCREATE INDEX index_SchoolMemberReplicate_smDestination_smPending ON SchoolMemberReplicate (smDestination, smPending)                 Vf { iÖ ÈÓ}Œ¥ãdŽ s Öf‚ V V55ƒCtableScopedGrantReplicateScopedGrantRe Vä?‚ indexindex_PersonParentJoinReplicate_ppjDestination_ppjPendingPersonParentJoinReplicate9CREATE INDEX index_PersonParentJoinReplicate_ppjDestination_ppjPending ON PersonParentJoinReplicate (ppjDestination, ppjPending)z‚!?‚/indexindex_PersonParentJoinReplicate_ppjPk_ppjDestination_ppjVersionIdPersonParentJoinReplicate8CREATE INDEX index_PersonParentJoinReplicate_ppjPk_ppjDestination_ppjVersionId ON PersonParentJoinReplicate (ppjPk, ppjDestination, ppjVersionId)‚&‚??ƒYtableClazzContentJoinReplicateClazzContentJoinReplicate2CREATE TABLE ClazzContentJoinReplicate ( ccjPk INTEGER NOT NULL , ccjVersionId INTEGER NOT NULL DEFAULT 0 , ccjDestination INTEGER NOT NULL , ccjPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (ccjPk, ccjDestination) )R‚e?indexsqlite_autoindex_ClazzContentJoinReplicate_1ClazzContentJoinReplicate3>‚m1iindexindex_SiteTermsReplicate_stDestination_stPendingSiteTermsReplicate1CREATE INDEX index_SiteTermsReplicate_stDestination_stPending ON SiteTermsReplicate (stDestination, stPending)T‚{1‚indexindex_SiteTermsReplicate_stPk_stDestination_stVersionIdSiteTermsReplicate0CREATE INDEX index_SiteTermsReplicate_stPk_stDestination_stVersionId ON SiteTermsReplicate (stPk, stDestination, stVersionId)‚ ‚11ƒ?tableSiteTermsReplicateSiteTermsReplicate.CREATE TABLE SiteTermsReplicate ( stPk INTEGER NOT NULL , stVersionId INTEGER NOT NULL DEFAULT 0 , stDestination INTEGER NOT NULL , stPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (stPk, stDestination) )D‚W1indexsqlite_autoindex_SiteTermsReplicate_1SiteTermsReplicate/q‚G‚indexindex_GroupLearningSessionReplicate_glsDestination_glsPendingGroupLearningSessionReplicate-CREATE INDEX index_GroupLearningSessionReplicate_glsDestination_glsPending ON GroupLearningSessionReplicate (glsDestination, glsPending)‚ ‚G‚?indexindex_GroupLearningSessionReplicate_glsPk_glsDestination_glsVersionIdGroupLearningSessionReplicate,CREATE INDEX index_GroupLearningSessionReplicate_glsPk_glsDestination_glsVersionId ON GroupLearningSessionReplicate (glsPk, glsDestination, glsVersionId)‚2‚GGƒatableGroupLearningSessionReplicateGroupLearningSessionReplicate*CREATE TABLE GroupLearningSessionReplicate ( glsPk INTEGER NOT NULL , glsVersionId INTEGER NOT NULL DEFAULT 0 , glsDestination INTEGER NOT NULL , glsPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (glsPk, glsDestination) )Z‚mGindexsqlite_autoindex_GroupLearningSessionReplicate_1GroupLearningSessionReplicate+i‚C‚indexindex_LearnerGroupMemberReplicate_lgmDestination_lgmPendingLearnerGroupMemberReplicate(CREATE INDEX index_LearnerGroupMemberReplicate_lgmDestination_lgmPending ON LearnerGroupMemberReplicate (lgmDestination, lgmPending) q9[5indexsqlite_autoindex_ScopedGrantReplicate_1Scop`‚?‚ indexindex_ClazzContentJoinReplicate_ccjDestination_ccjPendingClazzContentJoinReplicate5CREATE INDEX index_ClazzContentJoinReplicate_ccjDestination_ccjPending ON ClazzContentJoinReplicate (ccjDestination, ccjPending)z‚?‚/indexindex_ClazzContentJoinReplicate_ccjPk_ccjDestination_ccjVersionIdClazzContentJoinReplicate4CREATE INDEX index_ClazzContentJoinReplicate_ccjPk_ccjDestination_ccjVersionId ON ClazzContentJoinReplicate (ccjPk, ccjDestination, ccjVersionId) C‚‚C‚7indexindex_LearnerGroupMemberReplicate_lgmPk_lgmDestination_lgmVersionIdLearnerGroupMemberReplicate'CREATE INDEX index_LearnerGroupMemberReplicate_lgmPk_lgmDestination_lgmVersionId ON LearnerGroupMemberReplicate (lgmPk, lgmDestination, lgmVersionId)R‚ e?indexsqlite_autoindex_PersonParentJoinReplicate_1PersonParentJoinReplicate7‚&‚??ƒYtablePersonParentJoinReplicatePersonParentJoinReplicate6CREATE TABLE PersonParentJoinReplicate ( ppjPk INTEGER NOT NULL , ppjVersionId INTEGER NOT NULL DEFAULT 0 , ppjDestination INTEGER NOT NULL , ppjPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (ppjPk, ppjDestination) )                    Ðãë  À ö á – ¶ ìËx‡­_öÇлpkk rÉ`[5indexsqlite_autoindex_PersonAuth2Replicate_1PersonAuth2ReplicateL‚‚355ƒCtablePersonAuth2ReplicatePersonAuth2ReplicateKCREATE TABLE PersonAuth2Replicate ( paPk INTEGER NOT NULL , paVersionId INTEGER NOT NULL DEFAULT 0 , paDestination INTEGER NOT NULL , paPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (paPk, paDestination) )‚‚2S‚=indexindex_ClazzAssignmentContentJoinReplicate_cacjDestination_cacjPendingClazzAssignmentContentJoinReplicateJCREATE INDEX index_ClazzAssignmentContentJoinReplicate_cacjDestination_cacjPending ON ClazzAssignmentContentJoinReplicate (cacjDestination, cacjPending)`‚"?‚ indexindex_PersonParentJoinReplicate_ppjDestination_ppjPendingPersonParentJoinReplicate9CREATE INDEX index_PersonParentJoinReplicate_ppjDestination_ppjPending ON PersonParentJoinReplicate (ppjDestination, ppjPending)‚+‚1)S‚cindexindex_ClazzAssignmentContentJoinReplicate_cacjPk_cacjDestination_cacjVersionIdClazzAssignmentContentJoinReplicateICREATE INDEX index_ClazzAssignmentContentJoinReplicate_cacjPk_cacjDestination_cacjVersionId ON ClazzAssignmentContentJoinReplicate (cacjPk, cacjDestination, cacjVersionId)f‚0ySindexsqlite_autoindex_ClazzAssignmentContentJoinReplicate_1ClazzAssignmentContentJoinReplicateH‚J‚/SSƒytableClazzAssignmentContentJoinReplicateClazzAssignmentContentJoinReplicateGCREATE TABLE ClazzAssignmentContentJoinReplicate ( cacjPk INTEGER NOT NULL , cacjVersionId INTEGER NOT NULL DEFAULT 0 , cacjDestination INTEGER NOT NULL , cacjPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (cacjPk, cacjDestination) )V‚.y=‚indexindex_ClazzAssignmentReplicate_caDestination_caPendingClazzAssignmentReplicateFCREATE INDEX index_ClazzAssignmentReplicate_caDestination_caPending ON ClazzAssignmentReplicate (caDestination, caPending)m‚-=‚indexindex_ClazzAssignmentReplicate_caPk_caDestination_caVersionIdClazzAssignmentReplicateECREATE INDEX index_ClazzAssignmentReplicate_caPk_caDestination_caVersionId ON ClazzAssignmentReplicate (caPk, caDestination, caVersionId)P‚,c=indexsqlite_autoindex_ClazzAssignmentReplicate_1ClazzAssignmentReplicateD‚‚+==ƒKtableClazzAssignmentReplicateClazzAssignmentReplicateCCREATE TABLE ClazzAssignmentReplicate ( caPk INTEGER NOT NULL , caVersionId INTEGER NOT NULL DEFAULT 0 , caDestination INTEGER NOT NULL , caPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (caPk, caDestination) )F‚*q5qindexindex_ErrorReportReplicate_erDestination_erPendingErrorReportReplicateBCREATE INDEX index_ErrorReportReplicate_erDestination_erPending ON ErrorReportReplicate (erDestination, erPending)\‚)5‚indexindex_ErrorReportReplicate_erPk_erDestination_erVersionIdErrorReportReplicateACREATE INDEX index_ErrorReportReplicate_erPk_erDestination_erVersionId ON ErrorReportReplicate (erPk, erDestination, erVersionId)H‚([5indexsqlite_autoindex_ErrorReportReplicate_1ErrorReportReplicate@‚‚'55ƒCtableErrorReportReplicateErrorReportReplicate?CREATE TABLE ErrorReportReplicate ( erPk INTEGER NOT NULL , erVersionId INTEGER NOT NULL DEFAULT 0 , erDestination INTEGER NOT NULL , erPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (erPk, erDestination) )F‚&q5qindexindex_ScopedGrantReplicate_sgDestination_sgPendingScopedGrantReplicate>CREATE INDEX index_ScopedGrantReplicate_sgDestination_sgPending ON ScopedGrantReplicate (sgDestination, sgPending)\‚%5‚indexindex_ScopedGrantReplicate_sgPk_sgDestination_sgVersionIdScopedGrantReplicate9‚indexindex_CoursePictureReplicate_cpPk_cpDestination_cpVersionIdCoursePictureReplicateWCREATE INDEX index_CoursePictureReplicate_cpPk_cpDestination_cpVersionId ON CoursePictureReplicate (cpPk, cpDestination, cpVersionId)L‚=_9indexsqlite_autoindex_CoursePictureReplicate_1CoursePictureReplicateV‚‚<99ƒGtableCoursePictureReplicateCoursePictureReplicateUCREATE TABLE CoursePictureReplicate ( cpPk INTEGER NOT NULL , cpVersionId INTEGER NOT NULL DEFAULT 0 , cpDestination INTEGER NOT NULL , cpPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (cpPk, cpDestination) )„/‚;''ˆtableCoursePictureCoursePictureTCREATE TABLE CoursePicture ( coursePictureClazzUid INTEGER NOT NULL , coursePictureMasterCsn INTEGER NOT NULL , coursePictureLocalCsn INTEGER NOT NULL , coursePictureLastChangedBy INTEGER NOT NULL , coursePictureLct INTEGER NOT NULL , coursePictureUri TEXT , coursePictureMd5 TEXT , coursePictureFileSize INTEGER NOT NULL , coursePictureTimestamp INTEGER NOT NULL , coursePictureMimeType TEXT , coursePictureActive INTEGER NOT NULL , coursePictureUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )F‚:q5qindexindex_UserSessionReplicate_usDestination_usPendingUserSessionReplicateSCREATE INDEX index_UserSessionReplicate_usDestination_usPending ON UserSessionReplicate (usDestination, usPending)\‚95‚indexindex_UserSessionReplicate_usPk_usDestination_usVersionIdUserSessionReplicateRCREATE INDEX index_UserSessionReplicate_usPk_usDestination_usVersionId ON UserSessionReplicate (usPk, usDestination, usVersionId)H‚8[5indexsqlite_autoindex_UserSessionReplicate_1UserSessionReplicateP‚‚755ƒCtableUserSessionReplicateUserSessionReplicateOCREATE TABLE UserSessionReplicate ( usPk INTEGER NOT NULL , usVersionId INTEGER NOT NULL DEFAULT 0 , usDestination INTEGER NOT NULL , usPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (usPk, usDestination) )F‚6q5qindexindex_PersonAuth2Replicate_paDestination_paPendingPersonAuth2ReplicateNCREATE INDEX index_PersonAuth2Replicate_paDestination_paPending ON PersonAuth2Replicate (paDestination, paPending)\‚55‚indexindex_PersonAuth2Replicate_paPk_paDestination_paVersionIdPersonAuth2ReplicateMCREATE INDEX index_PersonAuth2Replicate_paPk_paDestination_paVersionId ON PersonAuth2Replicate (paPk, paDestination, paVersionId)               ]Œ‚7 ó ‹ d ! #K?,r0ç]fQþ”[5indexsqlite_÷3‚-indexindex_ChatMemberReplicate_chatMemberDestination_chatMemberPendingChatMemberReplicatemCREATE INDEX index_ChatMemberReplicate_chatMemberDestination_chatMemberPending ON ChatMemberReplicate (chatMemberDestination, chatMemberPending)‚!‚R-3‚kindexindex_ChatMemberReplicate_chatMemberPk_chatMemberDestination_chatMemberVersionIdChatMemberReplicatelCREATE INDEX index_ChatMemberReplicate_chatMemberPk_chatMemberDestination_chatMemberVersionId ON ChatMemberReplicate (chatMemberPk, chatMemberDestination, chatMemberVersionId)‚‚CE‚;indexindex_ContentEntryPictureReplicate_cepPk_cepDestination_cepVersionIdContentEntryPictureReplicate\CREATE INDEX index_ContentEntryPictureReplicate_cepPk_cepDestination_cepVersionId ON ContentEntryPictureReplicate (cepPk, cepDestination, cepVersionId)X‚BkEindexsqlite_autoindex_ContentEntryPictureReplicate_1ContentEntryPictureReplicate[F‚QY3indexsqlite_autoindex_ChatMemberReplicate_1ChatMemberReplicatek‚>‚P33„!tableChatMemberReplicateChatMemberReplicatejCREATE TABLE ChatMemberReplicate ( chatMemberPk INTEGER NOT NULL , chatMemberVersionId INTEGER NOT NULL DEFAULT 0 , chatMemberDestination INTEGER NOT NULL , chatMemberPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (chatMemberPk, chatMemberDestination) )6‚Ok'eindexindex_ChatReplicate_chatDestination_chatPendingChatReplicateiCREATE INDEX index_ChatReplicate_chatDestination_chatPending ON ChatReplicate (chatDestination, chatPending)R‚N}'‚ indexindex_ChatReplicate_chatPk_chatDestination_chatVersionIdChatReplicatehCREATE INDEX index_ChatReplicate_chatPk_chatDestination_chatVersionId ON ChatReplicate (chatPk, chatDestination, chatVersionId):‚MM'indexsqlite_autoindex_ChatReplicate_1ChatReplicateg‚‚L''ƒMtableChatReplicateChatReplicatefCREATE TABLE ChatReplicate ( chatPk INTEGER NOT NULL , chatVersionId INTEGER NOT NULL DEFAULT 0 , chatDestination INTEGER NOT NULL , chatPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (chatPk, chatDestination) )T‚K}-‚ indexindex_MessageReplicate_messageDestination_messagePendingMessageReplicateeCREATE INDEX index_MessageReplicate_messageDestination_messagePending ON MessageReplicate (messageDestination, messagePending)z‚J-‚;indexindex_MessageReplicate_messagePk_messageDestination_messageVersionIdMessageReplicatedCREATE INDEX index_MessageReplicate_messagePk_messageDestination_messageVersionId ON MessageReplicate (messagePk, messageDestination, messageVersionId)@‚IS-indexsqlite_autoindex_MessageReplicate_1MessageReplicatec‚#‚H--ƒwtableMessageReplicateMessageReplicatebCREATE TABLE MessageReplicate ( messagePk INTEGER NOT NULL , messageVersionId INTEGER NOT NULL DEFAULT 0 , messageDestination INTEGER NOT NULL , messagePending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (messagePk, messageDestination) )‚d‚G…tableMessageMessageaCREATE TABLE Message ( messageSenderPersonUid INTEGER NOT NULL , messageTableId INTEGER NOT NULL , messageEntityUid INTEGER NOT NULL , messageText TEXT , messageTimestamp INTEGER NOT NULL , messageClazzUid INTEGER NOT NULL , messageLct INTEGER NOT NULL , messageUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )‚@‚F!!„ItableChatMemberChatMember_CREATE TABLE ChatMember ( chatMemberChatUid INTEGER NOT NULL , chatMemberPersonUid INTEGER NOT NULL , chatMemberJoinedDate INTEGER NOT NULL , chatMemberLeftDate INTEGER NOT NULL , chatMemberLct INTEGER NOT NULL , chatMemberUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )T‚Eƒ tableChatChat^CREATE TABLE Chat ( chatStartDate INTEGER NOT NULL , chatTitle TEXT , chatGroup INTEGER NOT NULL , chatLct INTEGER NOT NULL , chatUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )m‚DE‚indexindex_ContentEntryPictureReplicate_cepDestination_cepPendingContentEntryPictureReplicate]CREATE INDEX index_ContentEntryPictureReplicate_cepDestination_cepPending ON ContentEntryPictureReplicate (cepDestination, cepPending)                   fÕ ¾ è kj?·Ì ‹ ÷f  ¢==„gtableDiscussionTopicReplicateDiscussionTopicRepli‚k‚_==„gtableDiscussionTopicReplicateDiscussionTopicReplicatezCREATE TABLE DiscussionTopicReplicate ( discussionTopicPk INTEGER NOT NULL , discussionTopicVersionId INTEGER NOT NULL DEFAULT 0 , discussionTopicDestination INTEGER NOT NULL , discussionTopicPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (discussionTopicPk, discussionTopicDestination) )s‚S3‚-indexindex_ChatMemberReplicate_chatMemberDestination_chatMemberPendingChatMemberReplicatemCREATE INDEX index_ChatMemberReplicate_chatMemberDestination_chatMemberPending ON ChatMemberReplicate (chatMemberDestination, chatMemberPending)‚o‚\]?ƒKindexindex_CourseDiscussionReplicate_courseDiscussionPk_courseDiscussionDestination_courseDiscussionVersionIdCourseDiscussionReplicatewCREATE INDEX index_CourseDiscussionReplicate_courseDiscussionPk_courseDiscussionDestination_courseDiscussionVersionId ON CourseDiscussionReplicate (courseDiscussionPk, courseDiscussionDestination, courseDiscussionVersionId)‚t‚Z??„utableCourseDiscussionReplicateCourseDiscussionReplicateuCREATE TABLE CourseDiscussionReplicate ( courseDiscussionPk INTEGER NOT NULL , courseDiscussionVersionId INTEGER NOT NULL DEFAULT 0 , courseDiscussionDestination INTEGER NOT NULL , courseDiscussionPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (courseDiscussionPk, courseDiscussionDestination) )R‚[e?indexsqlite_autoindex_CourseDiscussionReplicate_1CourseDiscussionReplicatev 3 ‚Q‚Y--„StableCourseDiscussionCourseDiscussiontCREATE TABLE CourseDiscussion ( courseDiscussionTitle TEXT , courseDiscussionDesc TEXT , courseDiscussionClazzUid INTEGER NOT NULL , courseDiscussionActive INTEGER NOT NULL , courseDiscussionLct INTEGER NOT NULL , courseDiscussionUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )}‚X5‚9indexindex_MessageReadReplicate_messageReadDestination_messageReadPendingMessageReadReplicatesCREATE INDEX index_MessageReadReplicate_messageReadDestination_messageReadPending ON MessageReadReplicate (messageReadDestination, messageReadPending)‚.‚W55‚{indexindex_MessageReadReplicate_messageReadPk_messageReadDestination_messageReadVersionIdMessageReadReplicateqCREATE INDEX index_MessageReadReplicate_messageReadPk_messageReadDestination_messageReadVersionId ON MessageReadReplicate (messageReadPk, messageReadDestination, messageReadVersionId)H‚V[5indexsqlite_autoindex_MessageReadReplicate_1MessageReadReplicatep‚G‚U55„/tableMessageReadReplicateMessageReadReplicateoCREATE TABLE MessageReadReplicate ( messageReadPk INTEGER NOT NULL , messageReadVersionId INTEGER NOT NULL DEFAULT 0 , messageReadDestination INTEGER NOT NULL , messageReadPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (messageReadPk, messageReadDestination) ) äX##„ tableMessageReadMessageReadnCREATE TABLE MessageRead ( messageReadPersonUid‚/‚]3?‚uindexindex_CourseDiscussionReplicate_courseDiscussionDestination_courseDiscussionPendingCourseDiscussionReplicatexCREATE INDEX index_CourseDiscussionReplicate_courseDiscussionDestination_courseDiscussionPending ON CourseDiscussionReplicate (courseDiscussionDestination, courseDiscussionPending)‚"‚T##„ tableMessageReadMessageReadnCREATE TABLE MessageRead ( messageReadPersonUid INTEGER NOT NULL , messageReadMessageUid INTEGER NOT NULL , messageReadEntityUid INTEGER NOT NULL , messageReadLct INTEGER NOT NULL , messageReadUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )3‚-indexin„‚^++‡?tableDiscussionTopicDiscussionTopicyCREATE TABLE DiscussionTopic ( discussionTopicTitle TEXT , discussionTopicDesc TEXT , discussionTopicStartDate INTEGER NOT NULL , discussionTopicCourseDiscussionUid INTEGER NOT NULL , discussionTopicVisible INTEGER NOT NULL , discussionTopicArchive INTEGER NOT NULL , discussionTopicIndex INTEGER NOT NULL , discussionTopicClazzUid INTEGER NOT NULL , discussionTopicLct INTEGER NOT NULL , discussionTopicUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )            a ò  œsjªQ2òÀ € £‚<‚h„Gtriggerch_ins_14ClazzLogCREATE TRIGGER ch_ins_14 AFTER INSERT ON ClazzLog BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 14 AS chTableId, NEW.clazzLogUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 14 AND chEntityPk = NEW.clazzLogUid); END‚‚g';‚]indexindex_DiscussionPostReplicate_discussionPostDestination_discussionPostPendingDiscussionPostReplicateƒCREATE INDEX index_DiscussionPostReplicate_discussionPostDestination_discussionPostPending ON DiscussionPostReplicate (discussionPostDestination, discussionPostPending)‚U‚fM;ƒ+indexindex_DiscussionPostReplicate_discussionPostPk_discussionPostDestination_discussionPostVersionIdDiscussionPostReplicate‚CREATE INDEX index_DiscussionPostReplicate_discussionPostPk_discussionPostDestination_discussionPostVersionId ON DiscussionPostReplicate (discussionPostPk, discussionPostDestination, discussionPostVersionId)‚b‚d;;„YtableDiscussionPostReplicateDiscussionPostReplicate€CREATE TABLE DiscussionPostReplicate ( discussionPostPk INTEGER NOT NULL , discussionPostVersionId INTEGER NOT NULL DEFAULT 0 , discussionPostDestination INTEGER NOT NULL , discussionPostPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (discussionPostPk, discussionPostDestination) )N‚ea;indexsqlite_autoindex_DiscussionPostReplicate_1DiscussionPostReplicate U „‚c))‡CtableDiscussionPostDiscussionPostCREATE TABLE DiscussionPost ( discussionPostTitle TEXT , discussionPostMessage TEXT , discussionPostStartDate INTEGER NOT NULL , discussionPostDiscussionTopicUid INTEGER NOT NULL , discussionPostVisible INTEGER NOT NULL , discussionPostArchive INTEGER NOT NULL , discussionPostStartedPersonUid INTEGER NOT NULL , discussionPostClazzUid INTEGER NOT NULL , discussionPostLct INTEGER NOT NULL , discussionPostUid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL )‚%‚b-=‚iindexindex_DiscussionTopicReplicate_discussionTopicDestination_discussionTopicPendingDiscussionTopicReplicate}CREATE INDEX index_DiscussionTopicReplicate_discussionTopicDestination_discussionTopicPending ON DiscussionTopicReplicate (discussionTopicDestination, discussionTopicPending)‚b‚aU=ƒ;indexindex_DiscussionTopicReplicate_discussionTopicPk_discussionTopicDestination_discussionTopicVersionIdDiscussionTopicReplicate|CREATE INDEX index_DiscussionTopicReplicate_discussionTopicPk_discussionTopicDestination_discussionTopicVersionId ON DiscussionTopicReplicate (discussionTopicPk, discussionTopicDestination, discussionTopicVersionId)P‚`c=indexsqlite_autoindex_DiscussionTopicReplicate_1DiscussionTopicReplicate{+==„gtableDiscussionTopicReplicateDiscussionTopicReplicatezCREATE TABLE DiscussionTopicReplicate ( discussionTopicPk INTEGER NOT NULL , discussionTopicVersionId INTEGER NOT NULL DEFAULT 0 , discussionTopicDestination INTEGER NOT NULL , discussionTopicPending INTEGER NOT NULL DEFAULT 1 , PRIMARY KEY (discussionTopicY‚k55‚YviewClazzLog_ReceiveViewClazzLog_ReceiveViewCREATE VIEW ClazzLog_ReceiveView AS SELECT ClazzLog.*, ClazzLogReplicate.* FROM ClazzLog LEFT JOIN ClazzLogReplicate ON ClazzLogReplicate.clPk = ClazzLog.clazzLogUid‚<‚j„Gtriggerch_del_14ClazzLogCREATE TRIGGER ch_del_14 AFTER DELETE ON ClazzLog BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 14 AS chTableId, OLD.clazzLogUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 14 AND chEntityPk = OLD.clazzLogUid); END‚<‚i„Gtriggerch_upd_14ClazzLogCREATE TRIGGER ch_upd_14 AFTER UPDATE ON ClazzLog BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 14 AS chTableId, NEW.clazzLogUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 14 AND chEntityPk = NEW.clazzLogUid); END      €1 £±1±1 €UU„]viewClazzLogAttendanceRecord_ReceiveViewClazzLogAttendanceRecord_ReceiveViewCREATE VIEW ClazzLogAttendanceRecord_ReceiveView AS SELECT ClazzLogAttendanceRecord.*, ClazzLogAttendanceRecordReplicate.* FROM ClazzLogAttendanceRecord LEFT JOIN ClazzLogAttendanceRecordReplicate ON ClazzLogAttendanceRecordReplicate.clarPk = ClazzLogAttendanceRecord.clazzLogAttendanceRecordUid‚|‚o=…'triggerch_del_15ClazzLogAttendanceRecordCREATE TRIGGER ch_del_15 AFTER DELETE ON ClazzLogAttendanceRecord BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 15 AS chTableId, OLD.clazzLogAttendanceRecordUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 15 AND chEntityPk = OLD.clazzLogAttendanceRecordUid); END‚|‚n=…'triggerch_upd_15ClazzLogAttendanceRecordCREATE TRIGGER ch_upd_15 AFTER UPDATE ON ClazzLogAttendanceRecord BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 15 AS chTableId, NEW.clazzLogAttendanceRecordUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 15 AND chEntityPk = NEW.clazzLogAttendanceRecordUid); END‚|‚m=…'triggerch_ins_15ClazzLogAttendanceRecordCREATE TRIGGER ch_ins_15 AFTER INSERT ON ClazzLogAttendanceRecord BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 15 AS chTableId, NEW.clazzLogAttendanceRecordUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 15 AND chEntityPk = NEW.clazzLogAttendanceRecordUid); END‹n‚lA5–qtriggerclazzlog_remote_insert_insClazzLog_ReceiveViewCREATE TRIGGER clazzlog_remote_insert_ins INSTEAD OF INSERT ON ClazzLog_ReceiveView FOR EACH ROW BEGIN REPLACE INTO ClazzLog(clazzLogUid, clazzLogClazzUid, logDate, timeRecorded, clazzLogDone, cancellationNote, clazzLogCancelled, clazzLogNumPresent, clazzLogNumAbsent, clazzLogNumPartial, clazzLogScheduleUid, clazzLogStatusFlag, clazzLogMSQN, clazzLogLCSN, clazzLogLCB, clazzLogLastChangedTime) VALUES (NEW.clazzLogUid, NEW.clazzLogClazzUid, NEW.logDate, NEW.timeRecorded, NEW.clazzLogDone, NEW.cancellationNote, NEW.clazzLogCancelled, NEW.clazzLogNumPresent, NEW.clazzLogNumAbsent, NEW.clazzLogNumPartial, NEW.clazzLogScheduleUid, NEW.clazzLogStatusFlag, NEW.clazzLogMSQN, NEW.clazzLogLCSN, NEW.clazzLogLCB, NEW.clazzLogLastChangedTime) /*psql ON CONFLICT (clazzLogUid) DO UPDATE SET clazzLogClazzUid = EXCLUDED.clazzLogClazzUid, logDate = EXCLUDED.logDate, timeRecorded = EXCLUDED.timeRecorded, clazzLogDone = EXCLUDED.clazzLogDone, cancellationNote = EXCLUDED.cancellationNote, clazzLogCancelled = EXCLUDED.clazzLogCancelled, clazzLogNumPresent = EXCLUDED.clazzLogNumPresent, clazzLogNumAbsent = EXCLUDED.clazzLogNumAbsent, clazzLogNumPartial = EXCLUDED.clazzLogNumPartial, clazzLogScheduleUid = EXCLUDED.clazzLogScheduleUid, clazzLogStatusFlag = EXCLUDED.clazzLogStatusFlag, clazzLogMSQN = EXCLUDED.clazzLogMSQN, clazzLogLCSN = EXCLUDED.clazzLogLCSN, clazzLogLCB = EXCLUDED.clazzLogLCB, clazzLogLastChangedTime = EXCLUDED.clazzLogLastChangedTime */; ENDY‚k55‚YviewClazzLog_ReceiveViewClazzLog_ReceiveViewCREATE VIEW ClazzLog_ReceiveView AS SELECT ClazzLog.*, ClazzLogReplicate.* FROM ClazzLog LEFT JOIN ClazzLogReplicate ON ClazzLogReplicate.clPk = ClazzLog.clazzLogUid„Gtriggerch_del_14ClazzLogCREATE TRIGGER ch_del_14 AFTER DELETE ON ClazzLog BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 14 AS chTableId, OLD.clazzLogUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM Change‚{‚pUU„]viewClazzLogAttendanceRecord_ReceiveViewClazzLogAttendanceRecord_ReceiveViewCREATE VIEW ClazzLogAttendanceRecord_ReceiveView AS SELECT ClazzLogAttendanceRecord.*, ClazzLogAttendanceRecordReplicate.* FROM ClazzLogAttendanceRecord LEFT JOIN ClazzLogAttendanceRecordReplicate ON ClazzLogAttendanceRecordReplicate.clarPk = ClazzLogAttendanceRecord.clazzLogAttendanceRecordUid  ƒCÀ à#55‚eviewSchedule_ReceiveViewSchedule_ReceiveViewCREATE VIEW Schedule_ReceiveView AS SELECT Schedule.*, ScheduleReplicate.* FROM Schedule LEFT JOIN ScheduleReplicate ON ScheduleReplicate.schedulePk = Schedule.scheduleUid‚<‚t„Gtriggerch_del_21ScheduleCREATE TRIGGER ch_del_21 AFTER DELETE ON Schedule BEGIN IN_‚u55‚eviewSchedule_ReceiveViewSchedule_ReceiveViewCREATE VIEW Schedule_ReceiveView AS SELECT Schedule.*, ScheduleReplicate.* FROM Schedule LEFT JOIN ScheduleReplicate ON ScheduleReplicate.schedulePk = Schedule.scheduleUid‚<‚s„Gtriggerch_upd_21ScheduleCREATE TRIGGER ch_upd_21 AFTER UPDATE ON Schedule BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 21 AS chTableId, NEW.scheduleUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 21 AND chEntityPk = NEW.scheduleUid); END‚<‚r„Gtriggerch_ins_21ScheduleCREATE TRIGGER ch_ins_21 AFTER INSERT ON Schedule BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 21 AS chTableId, NEW.scheduleUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 21 AND chEntityPk = NEW.scheduleUid); END‹z‚qaU–Itriggerclazzlogattendancerecord_remote_insert_insClazzLogAttendanceRecord_ReceiveViewCREATE TRIGGER clazzlogattendancerecord_remote_insert_ins INSTEAD OF INSERT ON ClazzLogAttendanceRecord_ReceiveView FOR EACH ROW BEGIN REPLACE INTO ClazzLogAttendanceRecord(clazzLogAttendanceRecordUid, clazzLogAttendanceRecordClazzLogUid, clazzLogAttendanceRecordPersonUid, attendanceStatus, clazzLogAttendanceRecordMasterChangeSeqNum, clazzLogAttendanceRecordLocalChangeSeqNum, clazzLogAttendanceRecordLastChangedBy, clazzLogAttendanceRecordLastChangedTime) VALUES (NEW.clazzLogAttendanceRecordUid, NEW.clazzLogAttendanceRecordClazzLogUid, NEW.clazzLogAttendanceRecordPersonUid, NEW.attendanceStatus, NEW.clazzLogAttendanceRecordMasterChangeSeqNum, NEW.clazzLogAttendanceRecordLocalChangeSeqNum, NEW.clazzLogAttendanceRecordLastChangedBy, NEW.clazzLogAttendanceRecordLastChangedTime) /*psql ON CONFLICT (clazzLogAttendanceRecordUid) DO UPDATE SET clazzLogAttendanceRecordClazzLogUid = EXCLUDED.clazzLogAttendanceRecordClazzLogUid, clazzLogAttendanceRecordPersonUid = EXCLUDED.clazzLogAttendanceRecordPersonUid, attendanceStatus = EXCLUDED.attendanceStatus, clazzLogAttendanceRecordMasterChangeSeqNum = EXCLUDED.clazzLogAttendanceRecordMasterChangeSeqNum, clazzLogAttendanceRecordLocalChangeSeqNum = EXCLUDED.clazzLogAttendanceRecordLocalChangeSeqNum, clazzLogAttendanceRecordLastChangedBy = EXCLUDED.clazzLogAttendanceRecordLastChangedBy, clazzLogAttendanceRecordLastChangedTime = EXCLUDED.clazzLogAttendanceRecordLastChangedTime */; END?UU„]viewClazzLogAttendanceRecord_ReceiveViewClazzLogAtte‚<‚t„Gtriggerch_del_21ScheduleCREATE TRIGGER ch_del_21 AFTER DELETE ON Schedule BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 21 AS chTableId, OLD.scheduleUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 21 AND chEntityPk = OLD.scheduleUid); END } ˜ Fô¢„}IY„1triggerch_ins_99HolidayCREATE TRIGGER ch_ins_99 AFTER INSERT ON Holiday BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 99 AS chTableId, NEW.holUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 99 AND chEntityPk = NEW.holUid); ENDˆ‚{OCŽtriggerholidaycalendar_remote_insert_insHolidayCalendar_ReceiveViewCREATE TRIGGER holidaycalendar_remote_insert_ins INSTEAD OF INSERT ON HolidayCalendar_ReceiveView FOR EACH ROW BEGIN REPLACE INTO HolidayCalendar(umCalendarUid, umCalendarName, umCalendarCategory, umCalendarActive, umCalendarMasterChangeSeqNum, umCalendarLocalChangeSeqNum, umCalendarLastChangedBy, umCalendarLct) VALUES (NEW.umCalendarUid, NEW.umCalendarName, NEW.umCalendarCategory, NEW.umCalendarActive, NEW.umCalendarMasterChangeSeqNum, NEW.umCalendarLocalChangeSeqNum, NEW.umCalendarLastChangedBy, NEW.umCalendarLct) /*psql ON CONFLICT (umCalendarUid) DO UPDATE SET umCalendarName = EXCLUDED.umCalendarName, umCalendarCategory = EXCLUDED.umCalendarCategory, umCalendarActive = EXCLUDED.umCalendarActive, umCalendarMasterChangeSeqNum = EXCLUDED.umCalendarMasterChangeSeqNum, umCalendarLocalChangeSeqNum = EXCLUDED.umCalendarLocalChangeSeqNum, umCalendarLastChangedBy = EXCLUDED.umCalendarLastChangedBy, umCalendarLct = EXCLUDED.umCalendarLct */; END‚‚zCCƒ?viewHolidayCalendar_ReceiveViewHolidayCalendar_ReceiveViewCREATE VIEW HolidayCalendar_ReceiveView AS SELECT HolidayCalendar.*, HolidayCalendarReplicate.* FROM HolidayCalendar LEFT JOIN HolidayCalendarReplicate ON HolidayCalendarReplicate.hcPk = HolidayCalendar.umCalendarUid‚N‚y+„]triggerch_del_28HolidayCalendarCREATE TRIGGER ch_del_28 AFTER DELETE ON HolidayCalendar BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 28 AS chTableId, OLD.umCalendarUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 28 AND chEntityPk = OLD.umCalendarUid); END‚N‚x+„]triggerch_upd_28HolidayCalendarCREATE TRIGGER ch_upd_28 AFTER UPDATE ON HolidayCalendar BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 28 AS chTableId, NEW.umCalendarUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 28 AND chEntityPk = NEW.umCalendarUid); END‚N‚w+„]triggerch_ins_28HolidayCalendarCREATE TRIGGER ch_ins_28 AFTER INSERT ON HolidayCalendar BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 28 AS chTableId, NEW.umCalendarUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 28 AND chEntityPk = NEW.umCalendarUid); ENDŠd‚vA5”]triggerschedule_remote_insert_insSchedule_ReceiveViewCREATE TRIGGER schedule_remote_insert_ins INSTEAD OF INSERT ON Schedule_ReceiveView FOR EACH ROW BEGIN REPLACE INTO Schedule(scheduleUid, sceduleStartTime, scheduleEndTime, scheduleDay, scheduleMonth, scheduleFrequency, umCalendarUid, scheduleClazzUid, scheduleMasterChangeSeqNum, scheduleLocalChangeSeqNum, scheduleLastChangedBy, scheduleLastChangedTime, scheduleActive) VALUES (NEW.scheduleUid, NEW.sceduleStartTime, NEW.scheduleEndTime, NEW.scheduleDay, NEW.scheduleMonth, NEW.scheduleFrequency, NEW.umCalendarUid, NEW.scheduleClazzUid, NEW.scheduleMasterChangeSeqNum, NEW.scheduleLocalChangeSeqNum, NEW.scheduleLastChangedBy, NEW.scheduleLastChangedTime, NEW.scheduleActive) /*psql ON CONFLICT (scheduleUid) DO UPDATE SET sceduleStartTime = EXCLUDED.sceduleStartTime, scheduleEndTime = EXCLUDED.scheduleEndTime, scheduleDay = EXCLUDED.scheduleDay, scheduleMonth = EXCLUDED.scheduleMonth, scheduleFrequency = EXCLUDED.scheduleFrequency, umCalendarUid = EXCLUDED.umCalendarUid, scheduleClazzUid = EXCLUDED.scheduleClazzUid, scheduleMasterChangeSeqNum = EXCLUDED.scheduleMasterChangeSeqNum, scheduleLocalChangeSeqNum = EXCLUDED.scheduleLocalChangeSeqNum, scheduleLastChangedBy = EXCLUDED.scheduleLastChangedBy, scheduleLastChangedTime = EXCLUDED.scheduleLastChangedTime, scheduleActive = EXCLUDED.scheduleActive */; END Û © §s?kÝ©Ì ÿ‚0ƒ„5triggerch_upd_9PersonCREATE TRIGGER ch_upd_9 AFTER UPDATE ON Person BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 9 AS chTableId, NEW.personUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 9 AND chEntityPk = NEW.personUid); END‚0ƒ„5triggerch_ins_9PersonCREATE TRIGGER ch_ins_9 AFTER INSERT ON Person BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 9 AS chTableId, NEW.personUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 9 AND chEntityPk = NEW.personUid); END†Vƒ?3ŒEtriggerholiday_remote_insert_insHoliday_ReceiveViewCREATE TRIGGER holiday_remote_insert_ins INSTEAD OF INSERT ON Holiday_ReceiveView FOR EACH ROW BEGIN REPLACE INTO Holiday(holUid, holMasterCsn, holLocalCsn, holLastModBy, holLct, holActive, holHolidayCalendarUid, holStartTime, holEndTime, holName) VALUES (NEW.holUid, NEW.holMasterCsn, NEW.holLocalCsn, NEW.holLastModBy, NEW.holLct, NEW.holActive, NEW.holHolidayCalendarUid, NEW.holStartTime, NEW.holEndTime, NEW.holName) /*psql ON CONFLICT (holUid) DO UPDATE SET holMasterCsn = EXCLUDED.holMasterCsn, holLocalCsn = EXCLUDED.holLocalCsn, holLastModBy = EXCLUDED.holLastModBy, holLct = EXCLUDED.holLct, holActive = EXCLUDED.holActive, holHolidayCalendarUid = EXCLUDED.holHolidayCalendarUid, holStartTime = EXCLUDED.holStartTime, holEndTime = EXCLUDED.holEndTime, holName = EXCLUDED.holName */; ENDP‚33‚KviewHoliday_ReceiveViewHoliday_ReceiveViewCREATE VIEW Holiday_ReceiveView AS SELECT Holiday.*, HolidayReplicate.* FROM Holiday LEFT JOIN HolidayReplicate ON HolidayReplicate.holidayPk = Holiday.holUid‚0‚~„1triggerch_del_99HolidayCREATE TRIGGER ch_del_99 AFTER DELETE ON Holiday BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 99 AS chTableId, OLD.holUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 99 AND chEntityPk = OLD.holUid); END‚0‚}„1triggerch_upd_99HolidayCREATE TRIGGER ch_upd_99 AFTER UPDATE ON Holiday BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 99 AS chTableId, NEW.holUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 99 AND chEntityPk = NEW.holUid); END‚0‚|„1triggerch_ins_99HolidayCREATE TRIGGER ch_ins_99 AFTER INSERT ON Holiday BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 99 AS chTableId, NEW.holUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 99 AND chEntityPk = NEW.holUid); END$OCŽtriggerholidaycalendar_remote_insert_insHolidayCalendar_ReceiveViewCREATE TRIGGER holidaycalendar_remote_insert_ins INSTEAD OF INSERT ON HolidayCalendar_ReceiveView FOR EACH ROW BEGIN REPLACE INTO HolidayCalendar(umCalendarUid, umCalendarName, umCalendarCategory, umCalendarActive, umCalendarMasterChangeSeqNum, umCalendarLocalChangeSeqNum, umCalendarLastChangedBy, umCalendarLct) VALUES (NEW.umCalendarUid, NEW.umCalendarName, NEW.umCalendarCategory, NEW.umCalendarActive, NEW.umCalendarMasterChangeSeqNum, NEW.umCalendarLocalChangeSeqNum, NEW.umCalendarLastChangedBy, NEW.umCalendarLct) /*psql ON CONFLICT (umCalendarUid) DO UPDATE SET umCalendarName = EXCLUDED.umCalendarName, umCalendarCategory = EXCLUDED.umCalendarCategory, umCalendarActive = EXCLUDED.umCalendarActive, umCalendarMasterCIƒ11‚AviewPerson_ReceiveViewPerson_ReceiveViewCREATE VIEW Person_ReceiveView AS SELECT Person.*, PersonReplicate.* FROM Person LEFT JOIN PersonReplicate ON PersonReplicate.personPk = Person.personUid‚0ƒ„5triggerch_del_9PersonCREATE TRIGGER ch_del_9 AFTER DELETE ON Person BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 9 AS chTableId, OLD.personUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 9 AND chEntityPk = OLD.personUid); END 3•%õÅ•>3Â//‚/viewClazz_ReceiveViewClazz_ReceiveViewCREATE VIEW Clazz_ReceiveView AS SELECT Clazz.*, ClazzReplicate.* FROM Clazz LEFT JOIN ClazzReplicate ON ClazzReplicate.clazzPk = Clazz.clazzUid‚,ƒ„/triggerch_del_6ClazzCREATE TRIGGER ch_del_6 AFTER DELETE ON Clazz BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 6 AS chTableId, OLD.clazzUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 6 AND chEntityPk = OLD.clazzUid); END‚,ƒ„/triggerch_upd_6ClazzCREATE TRIGGER ch_upd_6 AFTER UPDATE ON Clazz BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 6 AS chTableId, NEW.clazzUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 6 AND chEntityPk = NEW.clazzUid); END‚,ƒ„/triggerch_ins_6ClazzCREATE TRIGGER ch_ins_6 AFTER INSERT ON Clazz BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 6 AS chTableId, NEW.clazzUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 6 AND chEntityPk = NEW.clazzUid); ENDŽ ƒ=1›1triggerperson_remote_insert_insPerson_ReceiveViewCREATE TRIGGER person_remote_insert_ins INSTEAD OF INSERT ON Person_ReceiveView FOR EACH ROW BEGIN REPLACE INTO Person(personUid, username, firstNames, lastName, emailAddr, phoneNum, gender, active, admin, personNotes, fatherName, fatherNumber, motherName, motherNum, dateOfBirth, personAddress, personOrgId, personGroupUid, personMasterChangeSeqNum, personLocalChangeSeqNum, personLastChangedBy, personLct, personCountry, personType) VALUES (NEW.personUid, NEW.username, NEW.firstNames, NEW.lastName, NEW.emailAddr, NEW.phoneNum, NEW.gender, NEW.active, NEW.admin, NEW.personNotes, NEW.fatherName, NEW.fatherNumber, NEW.motherName, NEW.motherNum, NEW.dateOfBirth, NEW.personAddress, NEW.personOrgId, NEW.personGroupUid, NEW.personMasterChangeSeqNum, NEW.personLocalChangeSeqNum, NEW.personLastChangedBy, NEW.personLct, NEW.personCountry, NEW.personType) /*psql ON CONFLICT (personUid) DO UPDATE SET username = EXCLUDED.username, firstNames = EXCLUDED.firstNames, lastName = EXCLUDED.lastName, emailAddr = EXCLUDED.emailAddr, phoneNum = EXCLUDED.phoneNum, gender = EXCLUDED.gender, active = EXCLUDED.active, admin = EXCLUDED.admin, personNotes = EXCLUDED.personNotes, fatherName = EXCLUDED.fatherName, fatherNumber = EXCLUDED.fatherNumber, motherName = EXCLUDED.motherName, motherNum = EXCLUDED.motherNum, dateOfBirth = EXCLUDED.dateOfBirth, personAddress = EXCLUDED.personAddress, personOrgId = EXCLUDED.personOrgId, personGroupUid = EXCLUDED.personGroupUid, personMasterChangeSeqNum = EXCLUDED.personMasterChangeSeqNum, personLocalChangeSeqNum = EXCLUDED.personLocalChangeSeqNum, personLastChangedBy = EXCLUDED.personLastChangedBy, personLct = EXCLUDED.personLct, personCountry = EXCLUDED.personCountry, personType = EXCLUDED.personType */; END 11‚A>ƒ //‚/viewClazz_ReceiveViewClazz_ReceiveViewCREATE VIEW Clazz_ReceiveView AS SELECT Clazz.*, ClazzReplicate.* FROM Clazz LEFT JOIN ClazzReplicate ON ClazzReplicate.clazzPk = Clazz.clazzUid >¯Ðx ȯ‚ƒAAƒ9viewClazzEnrolment_ReceiveViewClazzEnrolment_ReceiveViewCREATE VIEW ClazzEnrolment_ReceiveView AS SELECT ClazzEnrolment.*, ClazzEnrolmentReplicate.* FROM ClazzEnrolment LEFT JOIN ClazzEnrolmentReplicate ON ClazzEnrolmentReplicate.cePk = ClazzEnrolment.clazzEnrolmentUid‚Tƒ )„ktriggerch_del_65ClazzEnrolmentCREATE TRIGGER ch_del_65 AFTER DELETE ON ClazzEnrolment BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 65 AS chTableId, OLD.clazzEnrolmentUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 65 AND chEntityPk = OLD.clazzEnrolmentUid); END‚Tƒ )„ktriggerch_upd_65ClazzEnrolmentCREATE TRIGGER ch_upd_65 AFTER UPDATE ON ClazzEnrolment BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 65 AS chTableId, NEW.clazzEnrolmentUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 65 AND chEntityPk = NEW.clazzEnrolmentUid); END‚Tƒ )„ktriggerch_ins_65ClazzEnrolmentCREATE TRIGGER ch_ins_65 AFTER INSERT ON ClazzEnrolment BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 65 AS chTableId, NEW.clazzEnrolmentUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 65 AND chEntityPk = NEW.clazzEnrolmentUid); END’jƒ ;/¤utriggerclazz_remote_insert_insClazz_ReceiveViewCREATE TRIGGER clazz_remote_insert_ins INSTEAD OF INSERT ON Clazz_ReceiveView FOR EACH ROW BEGIN REPLACE INTO Clazz(clazzUid, clazzName, clazzDesc, attendanceAverage, clazzHolidayUMCalendarUid, clazzScheuleUMCalendarUid, isClazzActive, clazzLocationUid, clazzStartTime, clazzEndTime, clazzFeatures, clazzSchoolUid, clazzEnrolmentPolicy, clazzTerminologyUid, clazzMasterChangeSeqNum, clazzLocalChangeSeqNum, clazzLastChangedBy, clazzLct, clazzTimeZone, clazzStudentsPersonGroupUid, clazzTeachersPersonGroupUid, clazzPendingStudentsPersonGroupUid, clazzParentsPersonGroupUid, clazzCode) VALUES (NEW.clazzUid, NEW.clazzName, NEW.clazzDesc, NEW.attendanceAverage, NEW.clazzHolidayUMCalendarUid, NEW.clazzScheuleUMCalendarUid, NEW.isClazzActive, NEW.clazzLocationUid, NEW.clazzStartTime, NEW.clazzEndTime, NEW.clazzFeatures, NEW.clazzSchoolUid, NEW.clazzEnrolmentPolicy, NEW.clazzTerminologyUid, NEW.clazzMasterChangeSeqNum, NEW.clazzLocalChangeSeqNum, NEW.clazzLastChangedBy, NEW.clazzLct, NEW.clazzTimeZone, NEW.clazzStudentsPersonGroupUid, NEW.clazzTeachersPersonGroupUid, NEW.clazzPendingStudentsPersonGroupUid, NEW.clazzParentsPersonGroupUid, NEW.clazzCode) /*psql ON CONFLICT (clazzUid) DO UPDATE SET clazzName = EXCLUDED.clazzName, clazzDesc = EXCLUDED.clazzDesc, attendanceAverage = EXCLUDED.attendanceAverage, clazzHolidayUMCalendarUid = EXCLUDED.clazzHolidayUMCalendarUid, clazzScheuleUMCalendarUid = EXCLUDED.clazzScheuleUMCalendarUid, isClazzActive = EXCLUDED.isClazzActive, clazzLocationUid = EXCLUDED.clazzLocationUid, clazzStartTime = EXCLUDED.clazzStartTime, clazzEndTime = EXCLUDED.clazzEndTime, clazzFeatures = EXCLUDED.clazzFeatures, clazzSchoolUid = EXCLUDED.clazzSchoolUid, clazzEnrolmentPolicy = EXCLUDED.clazzEnrolmentPolicy, clazzTerminologyUid = EXCLUDED.clazzTerminologyUid, clazzMasterChangeSeqNum = EXCLUDED.clazzMasterChangeSeqNum, clazzLocalChangeSeqNum = EXCLUDED.clazzLocalChangeSeqNum, clazzLastChangedBy = EXCLUDED.clazzLastChangedBy, clazzLct = EXCLUDED.clazzLct, clazzTimeZone = EXCLUDED.clazzTimeZone, clazzStudentsPersonGroupUid = EXCLUDED.clazzStudentsPersonGroupUid, clazzTeachersPersonGroupUid = EXCLUDED.clazzTeachersPersonGroupUid, clazzPendingStudentsPersonGroupUid = EXCLUDED.clazzPendingStudentsPersonGroupUid, clazzParentsPersonGroupUid = EXCLUDED.clazzParentsPersonGroupUid, clazzCode = EXCLUDED.clazzCode */; ENDÂ//‚/viewClazz_ReceiveViewClazz_ReceiveViewCREATE VIEW Clazz_ReceiveView AS SELECT Clazz.*, ClazzReplicate.* FROM Clazz LEFT JOIN ClazzReplicate ON ClazzReplicate.clazzPk = Clazz.clazzUid …–>掅…vƒK?Šmtriggerleavingreason_remote_insert_insLeavingReason_ReceiveViewCREATE TRIGGER leavingreason_remote_insert_ins INSTEAD OF INSERT ON LeavingReason_ReceiveView FOR EACH ROW BEGIN REPLACE INTO LeavingReason(leavingReasonUid, leavingReasonTitle, leavingReasonMCSN, leavingReasonCSN, leavingReasonLCB, leavingReasonLct) VALUES (NEW.leavingReasonUid, NEW.leavingReasonTitle, NEW.leavingReasonMCSN, NEW.leavingReasonCSN, NEW.leavingReasonLCB, NEW.leavingReasonLct) /*psql ON CONFLICT (leavingReasonUid) DO UPDATE SET leavingReasonTitle = EXCLUDED.leavingReasonTitle, leavingReasonMCSN = EXCLUDED.leavingReasonMCSN, leavingReasonCSN = EXCLUDED.leavingReasonCSN, leavingReasonLCB = EXCLUDED.leavingReasonLCB, leavingReasonLct = EXCLUDED.leavingReasonLct */; END‚ ƒ??ƒ)viewLeavingReason_ReceiveViewLeavingReason_ReceiveViewCREATE VIEW LeavingReason_ReceiveView AS SELECT LeavingReason.*, LeavingReasonReplicate.* FROM LeavingReason LEFT JOIN LeavingReasonReplicate ON LeavingReasonReplicate.lrPk = LeavingReason.leavingReasonUid‚Tƒ!'„ktriggerch_del_410LeavingReasonCREATE TRIGGER ch_del_410 AFTER DELETE ON LeavingReason BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 410 AS chTableId, OLD.leavingReasonUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 410 AND chEntityPk = OLD.leavingReasonUid); END‚Tƒ!'„ktriggerch_upd_410LeavingReasonCREATE TRIGGER ch_upd_410 AFTER UPDATE ON LeavingReason BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 410 AS chTableId, NEW.leavingReasonUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 410 AND chEntityPk = NEW.leavingReasonUid); END‚Tƒ!'„ktriggerch_ins_410LeavingReasonCREATE TRIGGER ch_ins_410 AFTER INSERT ON LeavingReason BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 410 AS chTableId, NEW.leavingReasonUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 410 AND chEntityPk = NEW.leavingReasonUid); ENDŽfƒMAœItriggerclazzenrolment_remote_insert_insClazzEnrolment_ReceiveViewCREATE TRIGGER clazzenrolment_remote_insert_ins INSTEAD OF INSERT ON ClazzEnrolment_ReceiveView FOR EACH ROW BEGIN REPLACE INTO ClazzEnrolment(clazzEnrolmentUid, clazzEnrolmentPersonUid, clazzEnrolmentClazzUid, clazzEnrolmentDateJoined, clazzEnrolmentDateLeft, clazzEnrolmentRole, clazzEnrolmentAttendancePercentage, clazzEnrolmentActive, clazzEnrolmentLeavingReasonUid, clazzEnrolmentOutcome, clazzEnrolmentLocalChangeSeqNum, clazzEnrolmentMasterChangeSeqNum, clazzEnrolmentLastChangedBy, clazzEnrolmentLct) VALUES (NEW.clazzEnrolmentUid, NEW.clazzEnrolmentPersonUid, NEW.clazzEnrolmentClazzUid, NEW.clazzEnrolmentDateJoined, NEW.clazzEnrolmentDateLeft, NEW.clazzEnrolmentRole, NEW.clazzEnrolmentAttendancePercentage, NEW.clazzEnrolmentActive, NEW.clazzEnrolmentLeavingReasonUid, NEW.clazzEnrolmentOutcome, NEW.clazzEnrolmentLocalChangeSeqNum, NEW.clazzEnrolmentMasterChangeSeqNum, NEW.clazzEnrolmentLastChangedBy, NEW.clazzEnrolmentLct) /*psql ON CONFLICT (clazzEnrolmentUid) DO UPDATE SET clazzEnrolmentPersonUid = EXCLUDED.clazzEnrolmentPersonUid, clazzEnrolmentClazzUid = EXCLUDED.clazzEnrolmentClazzUid, clazzEnrolmentDateJoined = EXCLUDED.clazzEnrolmentDateJoined, clazzEnrolmentDateLeft = EXCLUDED.clazzEnrolmentDateLeft, clazzEnrolmentRole = EXCLUDED.clazzEnrolmentRole, clazzEnrolmentAttendancePercentage = EXCLUDED.clazzEnrolmentAttendancePercentage, clazzEnrolmentActive = EXCLUDED.clazzEnrolmentActive, clazzEnrolmentLeavingReasonUid = EXCLUDED.clazzEnrolmentLeavingReasonUid, clazzEnrolmentOutcome = EXCLUDED.clazzEnrolmentOutcome, clazzEnrolmentLocalChangeSeqNum = EXCLUDED.clazzEnrolmentLocalChangeSeqNum, clazzEnrolmentMasterChangeSeqNum = EXCLUDED.clazzEnrolmentMasterChangeSeqNum, clazzEnrolmentLastChangedBy = EXCLUDED.clazzEnrolmentLastChangedBy, clazzEnrolmentLct = EXCLUDED.clazzEnrolmentLct */; END >° `  ¢>‚`ƒK„ctriggerch_ins_3ContentEntryContentCategoryJoinCREATE TRIGGER ch_ins_3 AFTER INSERT ON ContentEntryContentCategoryJoin BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 3 AS chTableId, NEW.ceccjUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 3 AND chEntityPk = NEW.ceccjUid); ENDeƒI= Otriggercontententry_remote_insert_insContentEntry_ReceiveViewCREATE TRIGGER contententry_remote_insert_ins INSTEAD OF INSERT ON ContentEntry_ReceiveView FOR EACH ROW BEGIN REPLACE INTO ContentEntry(contentEntryUid, title, description, entryId, author, publisher, licenseType, licenseName, licenseUrl, sourceUrl, thumbnailUrl, lastModified, primaryLanguageUid, languageVariantUid, contentFlags, leaf, publik, ceInactive, completionCriteria, minScore, contentTypeFlag, contentOwner, contentEntryLocalChangeSeqNum, contentEntryMasterChangeSeqNum, contentEntryLastChangedBy, contentEntryLct) VALUES (NEW.contentEntryUid, NEW.title, NEW.description, NEW.entryId, NEW.author, NEW.publisher, NEW.licenseType, NEW.licenseName, NEW.licenseUrl, NEW.sourceUrl, NEW.thumbnailUrl, NEW.lastModified, NEW.primaryLanguageUid, NEW.languageVariantUid, NEW.contentFlags, NEW.leaf, NEW.publik, NEW.ceInactive, NEW.completionCriteria, NEW.minScore, NEW.contentTypeFlag, NEW.contentOwner, NEW.contentEntryLocalChangeSeqNum, NEW.contentEntryMasterChangeSeqNum, NEW.contentEntryLastChangedBy, NEW.contentEntryLct) /*psql ON CONFLICT (contentEntryUid) DO UPDATE SET title = EXCLUDED.title, description = EXCLUDED.description, entryId = EXCLUDED.entryId, author = EXCLUDED.author, publisher = EXCLUDED.publisher, licenseType = EXCLUDED.licenseType, licenseName = EXCLUDED.licenseName, licenseUrl = EXCLUDED.licenseUrl, sourceUrl = EXCLUDED.sourceUrl, thumbnailUrl = EXCLUDED.thumbnailUrl, lastModified = EXCLUDED.lastModified, primaryLanguageUid = EXCLUDED.primaryLanguageUid, languageVariantUid = EXCLUDED.languageVariantUid, contentFlags = EXCLUDED.contentFlags, leaf = EXCLUDED.leaf, publik = EXCLUDED.publik, ceInactive = EXCLUDED.ceInactive, completionCriteria = EXCLUDED.completionCriteria, minScore = EXCLUDED.minScore, contentTypeFlag = EXCLUDED.contentTypeFlag, contentOwner = EXCLUDED.contentOwner, contentEntryLocalChangeSeqNum = EXCLUDED.contentEntryLocalChangeSeqNum, contentEntryMasterChangeSeqNum = EXCLUDED.contentEntryMasterChangeSeqNum, contentEntryLastChangedBy = EXCLUDED.contentEntryLastChangedBy, contentEntryLct = EXCLUDED.contentEntryLct*/; END‚ƒ==ƒviewContentEntry_ReceiveViewContentEntry_ReceiveViewCREATE VIEW ContentEntry_ReceiveView AS SELECT ContentEntry.*, ContentEntryReplicate.* FROM ContentEntry LEFT JOIN ContentEntryReplicate ON ContentEntryReplicate.cePk = ContentEntry.contentEntryUid‚Lƒ%„_triggerch_del_42ContentEntryCREATE TRIGGER ch_del_42 AFTER DELETE ON ContentEntry BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 42 AS chTableId, OLD.contentEntryUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 42 AND chEntityPk = OLD.contentEntryUid); END‚Lƒ%„_triggerch_upd_42ContentEntryCREATE TRIGGER ch_upd_42 AFTER UPDATE ON ContentEntry BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 42 AS chTableId, NEW.contentEntryUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 42 AND chEntityPk = NEW.contentEntryUid); END‚Lƒ%„_triggerch_ins_42ContentEntryCREATE TRIGGER ch_ins_42 AFTER INSERT ON ContentEntry BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 42 AS chTableId, NEW.contentEntryUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 42 AND chEntityPk = NEW.contentEntryUid); END œ 8 Ô (Zþ¤¢¾@[[„cviewContentEntryParentChildJoin_ReceiveViewContentEntryParentChildJoin_ReceiveViewCREATE VIEW ContentEntryParentChildJoin_ReceiveView AS SELECT ContentEntryParentChildJoin.*, ContentEntryParentChildJoinReplicate.* FROM ContentEntryParentChildJoin LEFT JOIN ContentEntryParentChildJoinReplicate ON ContentEntryParentChildJoinReplicate.ceƒƒ"[[„cviewContentEntryParentChildJoin_ReceiveViewContentEntryParentChildJoin_ReceiveViewCREATE VIEW ContentEntryParentChildJoin_ReceiveView AS SELECT ContentEntryParentChildJoin.*, ContentEntryParentChildJoinReplicate.* FROM ContentEntryParentChildJoin LEFT JOIN ContentEntryParentChildJoinReplicate ON ContentEntryParentChildJoinReplicate.cepcjPk = ContentEntryParentChildJoin.cepcjUid‚Xƒ!C„[triggerch_del_7ContentEntryParentChildJoinCREATE TRIGGER ch_del_7 AFTER DELETE ON ContentEntryParentChildJoin BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 7 AS chTableId, OLD.cepcjUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 7 AND chEntityPk = OLD.cepcjUid); END‚XƒC„[triggerch_ins_7ContentEntryParentChildJoinCREATE TRIGGER ch_ins_7 AFTER INSERT ON ContentEntryParentChildJoin BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 7 AS chTableId, NEW.cepcjUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 7 AND chEntityPk = NEW.cepcjUid); END‡JƒocMtriggercontententrycontentcategoryjoin_remote_insert_insContentEntryContentCategoryJoin_ReceiveViewCREATE TRIGGER contententrycontentcategoryjoin_remote_insert_ins INSTEAD OF INSERT ON ContentEntryContentCategoryJoin_ReceiveView FOR EACH ROW BEGIN REPLACE INTO ContentEntryContentCategoryJoin(ceccjUid, ceccjContentEntryUid, ceccjContentCategoryUid, ceccjLocalChangeSeqNum, ceccjMasterChangeSeqNum, ceccjLastChangedBy, ceccjLct) VALUES (NEW.ceccjUid, NEW.ceccjContentEntryUid, NEW.ceccjContentCategoryUid, NEW.ceccjLocalChangeSeqNum, NEW.ceccjMasterChangeSeqNum, NEW.ceccjLastChangedBy, NEW.ceccjLct) /*psql ON CONFLICT (ceccjUid) DO UPDATE SET ceccjContentEntryUid = EXCLUDED.ceccjContentEntryUid, ceccjContentCategoryUid = EXCLUDED.ceccjContentCategoryUid, ceccjLocalChangeSeqNum = EXCLUDED.ceccjLocalChangeSeqNum, ceccjMasterChangeSeqNum = EXCLUDED.ceccjMasterChangeSeqNum, ceccjLastChangedBy = EXCLUDED.ceccjLastChangedBy, ceccjLct = EXCLUDED.ceccjLct */; ENDƒ(ƒcc…viewContentEntryContentCategoryJoin_ReceiveViewContentEntryContentCategoryJoin_ReceiveViewCREATE VIEW ContentEntryContentCategoryJoin_ReceiveView AS SELECT ContentEntryContentCategoryJoin.*, ContentEntryContentCategoryJoinReplicate.* FROM ContentEntryContentCategoryJoin LEFT JOIN ContentEntryContentCategoryJoinReplicate ON ContentEntryContentCategoryJoinReplicate.ceccjPk = ContentEntryContentCategoryJoin.ceccjUid‚`ƒK„ctriggerch_del_3ContentEntryContentCategoryJoinCREATE TRIGGER ch_del_3 AFTER DELETE ON ContentEntryContentCategoryJoin BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 3 AS chTableId, OLD.ceccjUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 3 AND chEntityPk = OLD.ceccjUid); END‚`ƒK„ctriggerch_upd_3ContentEntryContentCategoryJoinCREATE TRIGGER ch_upd_3 AFTER UPDATE ON ContentEntryContentCategoryJoin BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 3 AS chTableId, NEW.ceccjUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 3 AND chEntityPk = NEW.ceccjUid); ENDK‚Xƒ C„[triggerch_upd_7ContentEntryParentChildJoinCREATE TRIGGER ch_upd_7 AFTER UPDATE ON ContentEntryParentChildJoin BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 7 AS chTableId, NEW.cepcjUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 7 AND chEntityPk = NEW.cepcjUid); END Ä è Š ,Î=ÄTp7…triggerch_ins_2ContentCategorySchemaCREATE TRIGGER ch_ins_2 AFTER INSERT ON ContentCategorySchema BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 2 AS chTableId, NEW.contentCategorySchemaUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 2 AND chEntityPk = NEW.contentCategorySchemaUid); ENDˆuƒ(i]/triggercontententryrelatedentryjoin_remote_insert_insContentEntryRelatedEntryJoin_ReceiveViewCREATE TRIGGER contententryrelatedentryjoin_remote_insert_ins INSTEAD OF INSERT ON ContentEntryRelatedEntryJoin_ReceiveView FOR EACH ROW BEGIN REPLACE INTO ContentEntryRelatedEntryJoin(cerejUid, cerejContentEntryUid, cerejRelatedEntryUid, cerejLastChangedBy, relType, comment, cerejRelLanguageUid, cerejLocalChangeSeqNum, cerejMasterChangeSeqNum, cerejLct) VALUES (NEW.cerejUid, NEW.cerejContentEntryUid, NEW.cerejRelatedEntryUid, NEW.cerejLastChangedBy, NEW.relType, NEW.comment, NEW.cerejRelLanguageUid, NEW.cerejLocalChangeSeqNum, NEW.cerejMasterChangeSeqNum, NEW.cerejLct) /*psql ON CONFLICT (cerejUid) DO UPDATE SET cerejContentEntryUid = EXCLUDED.cerejContentEntryUid, cerejRelatedEntryUid = EXCLUDED.cerejRelatedEntryUid, cerejLastChangedBy = EXCLUDED.cerejLastChangedBy, relType = EXCLUDED.relType, comment = EXCLUDED.comment, cerejRelLanguageUid = EXCLUDED.cerejRelLanguageUid, cerejLocalChangeSeqNum = EXCLUDED.cerejLocalChangeSeqNum, cerejMasterChangeSeqNum = EXCLUDED.cerejMasterChangeSeqNum, cerejLct = EXCLUDED.cerejLct */; ENDƒ ƒ']]„qviewContentEntryRelatedEntryJoin_ReceiveViewContentEntryRelatedEntryJoin_ReceiveViewCREATE VIEW ContentEntryRelatedEntryJoin_ReceiveView AS SELECT ContentEntryRelatedEntryJoin.*, ContentEntryRelatedEntryJoinReplicate.* FROM ContentEntryRelatedEntryJoin LEFT JOIN ContentEntryRelatedEntryJoinReplicate ON ContentEntryRelatedEntryJoinReplicate.cerejPk = ContentEntryRelatedEntryJoin.cerejUid‚Zƒ&E„]triggerch_del_8ContentEntryRelatedEntryJoinCREATE TRIGGER ch_del_8 AFTER DELETE ON ContentEntryRelatedEntryJoin BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 8 AS chTableId, OLD.cerejUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 8 AND chEntityPk = OLD.cerejUid); END‚Zƒ%E„]triggerch_upd_8ContentEntryRelatedEntryJoinCREATE TRIGGER ch_upd_8 AFTER UPDATE ON ContentEntryRelatedEntryJoin BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 8 AS chTableId, NEW.cerejUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 8 AND chEntityPk = NEW.cerejUid); END‚Zƒ$E„]triggerch_ins_8ContentEntryRelatedEntryJoinCREATE TRIGGER ch_ins_8 AFTER INSERT ON ContentEntryRelatedEntryJoin BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 8 AS chTableId, NEW.cerejUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 8 AND chEntityPk = NEW.cerejUid); ENDˆƒ#g[Žqtriggercontententryparentchildjoin_remote_insert_insContentEntryParentChildJoin_ReceiveViewCREATE TRIGGER contententryparentchildjoin_remote_insert_ins INSTEAD OF INSERT ON ContentEntryParentChildJoin_ReceiveView FOR EACH ROW BEGIN REPLACE INTO ContentEntryParentChildJoin(cepcjParentContentEntryUid, cepcjChildContentEntryUid, childIndex, cepcjUid, cepcjLocalChangeSeqNum, cepcjMasterChangeSeqNum, cepcjLastChangedBy, cepcjLct) VALUES (NEW.cepcjParentContentEntryUid, NEW.cepcjChildContentEntryUid, NEW.childIndex, NEW.cepcjUid, NEW.cepcjLocalChangeSeqNum, NEW.cepcjMasterChangeSeqNum, NEW.cepcjLastChangedBy, NEW.cepcjLct) /*psql ON CONFLICT (cepcjUid) DO UPDATE SET cepcjParentContentEntryUid = EXCLUDED.cepcjParentContentEntryUid, cepcjChildContentEntryUid = EXCLUDED.cepcjChildContentEntryUid, childIndex = EXCLUDED.childIndex, cepcjLocalChangeSeqNum = EXCLUDED.cepcjLocalChangeSeqNum, cepcjMasterChangeSeqNum = EXCLUDED.cepcjMasterChangeSeqNum, cepcjLastChangedBy = EXCLUDED.cepcjLastChangedBy, cepcjLct = EXCLUDED.cepcjLct */; END k à§7×k¨ P ˆH #CCƒIviewContentCategory_ReceiveViewContentCategory_ReceiveViewCREATE VIEW ContentCategory_ReceiveView AS SELECT ContentCategory.*, ContentCategoryReplicate.* FROM ContentCategory LEFT JOIN ContentCategoryReplicate ON ContentCategoryReplicate.ccPk = ContentCategory.contentCategoryUidˆhƒ-1triggercontentcategoryschema_remote_insert_insContentCategorySchema_ReceiveViewCREATE TRIGGER contentcategoryschema_remote_insert_ins INSTEAD OF INSERT ON ContentCategorySchema_ReceiveView FOR EACH ROW BEGIN REPLACE INTO ContentCategorySchema(contentCategorySchemaUid, schemaName, schemaUrl, contentCategorySchemaLocalChangeSeqNum, contentCategorySchemaMasterChangeSeqNum, contentCategorySchemaLastChangedBy, contentCategorySchemaLct) VALUES (NEW.contentCategorySchemaUid, NEW.schemaName, NEW.schemaUrl, NEW.contentCategorySchemaLocalChangeSeqNum, NEW.contentCategorySchemaMasterChangeSeqNum, NEW.contentCategorySchemaLastChangedBy, NEW.contentCategorySchemaLct) /*psql ON CONFLICT (contentCategorySchemaUid) DO UPDATE SET schemaName = EXCLUDED.schemaName, schemaUrl = EXCLUDED.schemaUrl, contentCategorySchemaLocalChangeSeqNum = EXCLUDED.contentCategorySchemaLocalChangeSeqNum, contentCategorySchemaMasterChangeSeqNum = EXCLUDED.contentCategorySchemaMasterChangeSeqNum, contentCategorySchemaLastChangedBy = EXCLUDED.contentCategorySchemaLastChangedBy, contentCategorySchemaLct = EXCLUDED.contentCategorySchemaLct */; END‚\ƒ,OO„+viewContentCategorySchema_ReceiveViewContentCategorySchema_ReceiveViewCREATE VIEW ContentCategorySchema_ReceiveView AS SELECT ContentCategorySchema.*, ContentCategorySchemaReplicate.* FROM ContentCategorySchema LEFT JOIN ContentCategorySchemaReplicate ON ContentCategorySchemaReplicate.ccsPk = ContentCategorySchema.contentCategorySchemaUid‚lƒ+7…triggerch_del_2ContentCategorySchemaCREATE TRIGGER ch_del_2 AFTER DELETE ON ContentCategorySchema BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 2 AS chTableId, OLD.contentCategorySchemaUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 2 AND chEntityPk = OLD.contentCategorySchemaUid); END‚lƒ*7…triggerch_upd_2ContentCategorySchemaCREATE TRIGGER ch_upd_2 AFTER UPDATE ON ContentCategorySchema BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 2 AS chTableId, NEW.contentCategorySchemaUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 2 AND chEntityPk = NEW.contentCategorySchemaUid); ENDq7…triggerch_ins_2ContentCategorySchemaCREATE TRIGGER ch_ins_2 AFTER INSERT ON ContentCategorySchema BEGI‚Tƒ0+„ktriggerch_del_1ContentCategoryCREATE TRIGGER ch_del_1 AFTER DELETE ON ContentCategory BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 1 AS chTableId, OLD.contentCategoryUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 1 AND chEntityPk = OLD.contentCategoryUid); END‚lƒ)7…triggerch_ins_2ContentCategorySchemaCREATE TRIGGER ch_ins_2 AFTER INSERT ON ContentCategorySchema BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 2 AS chTableId, NEW.contentCategorySchemaUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 2 AND chEntityPk = NEW.contentCategorySchemaUid); END‚Tƒ/+„ktriggerch_upd_1ContentCategoryCREATE TRIGGER ch_upd_1 AFTER UPDATE ON ContentCategory BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 1 AS chTableId, NEW.contentCategoryUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 1 AND chEntityPk = NEW.contentCategoryUid); END‚Tƒ.+„ktriggerch_ins_1ContentCategoryCREATE TRIGGER ch_ins_1 AFTER INSERT ON ContentCategory BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 1 AS chTableId, NEW.contentCategoryUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 1 AND chEntityPk = NEW.contentCategoryUid); END ¢ö è ° x@a¢¨+„atriggerch_upd_10LanguageVariantCREATE ‚Pƒ8+„atriggerch_ins_10LanguageVariantCREATE TRIGGER ch_ins_10 AFTER INSERT ON LanguageVariant BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 10 AS chTableId, NEW.langVariantUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 10 AND chEntityPk = NEW.langVariantUid); END‚ƒ1CCƒIviewContentCategory_ReceiveViewContentCategory_ReceiveViewCREATE VIEW ContentCategory_ReceiveView AS SELECT ContentCategory.*, ContentCategoryReplicate.* FROM ContentCategory LEFT JOIN ContentCategoryReplicate ON ContentCategoryReplicate.ccPk = ContentCategory.contentCategoryUidˆDƒ7A5triggerlanguage_remote_insert_insLanguage_ReceiveViewCREATE TRIGGER language_remote_insert_ins INSTEAD OF INSERT ON Language_ReceiveView FOR EACH ROW BEGIN REPLACE INTO Language(langUid, name, iso_639_1_standard, iso_639_2_standard, iso_639_3_standard, Language_Type, languageActive, langLocalChangeSeqNum, langMasterChangeSeqNum, langLastChangedBy, langLct) VALUES (NEW.langUid, NEW.name, NEW.iso_639_1_standard, NEW.iso_639_2_standard, NEW.iso_639_3_standard, NEW.Language_Type, NEW.languageActive, NEW.langLocalChangeSeqNum, NEW.langMasterChangeSeqNum, NEW.langLastChangedBy, NEW.langLct) /*psql ON CONFLICT (langUid) DO UPDATE SET name = EXCLUDED.name, iso_639_1_standard = EXCLUDED.iso_639_1_standard, iso_639_2_standard = EXCLUDED.iso_639_2_standard, iso_639_3_standard = EXCLUDED.iso_639_3_standard, Language_Type = EXCLUDED.Language_Type, languageActive = EXCLUDED.languageActive, langLocalChangeSeqNum = EXCLUDED.langLocalChangeSeqNum, langMasterChangeSeqNum = EXCLUDED.langMasterChangeSeqNum, langLastChangedBy = EXCLUDED.langLastChangedBy, langLct = EXCLUDED.langLct */; END[ƒ655‚]viewLanguage_ReceiveViewLanguage_ReceiveViewCREATE VIEW Language_ReceiveView AS SELECT Language.*, LanguageReplicate.* FROM Language LEFT JOIN LanguageReplicate ON LanguageReplicate.languagePk = Language.langUid‚4ƒ5„7triggerch_del_13LanguageCREATE TRIGGER ch_del_13 AFTER DELETE ON Language BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 13 AS chTableId, OLD.langUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 13 AND chEntityPk = OLD.langUid); END‚4ƒ4„7triggerch_upd_13LanguageCREATE TRIGGER ch_upd_13 AFTER UPDATE ON Language BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 13 AS chTableId, NEW.langUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 13 AND chEntityPk = NEW.langUid); END‚4ƒ3„7triggerch_ins_13LanguageCREATE TRIGGER ch_ins_13 AFTER INSERT ON Language BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 13 AS chTableId, NEW.langUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 13 AND chEntityPk = NEW.langUid); ENDˆƒ2OC!triggercontentcategory_remote_insert_insContentCategory_ReceiveViewCREATE TRIGGER contentcategory_remote_insert_ins INSTEAD OF INSERT ON ContentCategory_ReceiveView FOR EACH ROW BEGIN REPLACE INTO ContentCategory(contentCategoryUid, ctnCatContentCategorySchemaUid, name, contentCategoryLocalChangeSeqNum, contentCategoryMasterChangeSeqNum, contentCategoryLastChangedBy, contentCategoryLct) VALUES (NEW.contentCategoryUid, NEW.ctnCatContentCategorySchemaUid, NEW.name, NEW.contentCategoryLocalChangeSeqNum, NEW.contentCategoryMasterChangeSeqNum, NEW.contentCategoryLastChangedBy, NEW.contentCategoryLct) /*psql ON CONFLICT (contentCategoryUid) DO UPDATE SET ctnCatContentCategorySchemaUid = EXCLUDED.ctnCatContentCategorySchemaUid, name = EXCLUDED.name, contentCategoryLocalChangeSeqNum = EXCLUDED.contentCategoryLocalChangeSeqNum, contentCategoryMasterChangeSeqNum = EXCLUDED.contentCategoryMasterChangeSeqNum, contentCategoryLastChangedBy = EXCLUDED.contentCategoryLastChangedBy, contentCategoryLct = EXCLUDED.contentCategoryLct */; END º¬ X 9‡GÇÒº‚<ƒ>#„Atriggerch_upd_43PersonGroupCREATE TRIGGER ch_upd_43 AFTER UPDATE ON †ƒAG;‹1triggerpersongroup_remote_insert_insPersonGroup_ReceiveViewCREATE TRIGGER persongroup_remote_insert_ins INSTEAD OF INSERT ON PersonGroup_ReceiveView FOR EACH ROW BEGIN REPLACE INTO PersonGroup(groupUid, groupMasterCsn, groupLocalCsn, groupLastChangedBy, groupLct, groupName, groupActive, personGroupFlag) VALUES (NEW.groupUid, NEW.groupMasterCsn, NEW.groupLocalCsn, NEW.groupLastChangedBy, NEW.groupLct, NEW.groupName, NEW.groupActive, NEW.personGroupFlag) /*psql ON CONFLICT (groupUid) DO UPDATE SET groupMasterCsn = EXCLUDED.groupMasterCsn, groupLocalCsn = EXCLUDED.groupLocalCsn, groupLastChangedBy = EXCLUDED.groupLastChangedBy, groupLct = EXCLUDED.groupLct, groupName = EXCLUDED.groupName, groupActive = EXCLUDED.groupActive, personGroupFlag = EXCLUDED.personGroupFlag */; ENDqƒ@;;‚}viewPersonGroup_ReceiveViewPersonGroup_ReceiveViewCREATE VIEW PersonGroup_ReceiveView AS SELECT PersonGroup.*, PersonGroupReplicate.* FROM PersonGroup LEFT JOIN PersonGroupReplicate ON PersonGroupReplicate.pgPk = PersonGroup.groupUid‚<ƒ?#„Atriggerch_del_43PersonGroupCREATE TRIGGER ch_del_43 AFTER DELETE ON PersonGroup BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 43 AS chTableId, OLD.groupUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 43 AND chEntityPk = OLD.groupUid); END‚<ƒ>#„Atriggerch_upd_43PersonGroupCREATE TRIGGER ch_upd_43 AFTER UPDATE ON PersonGroup BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 43 AS chTableId, NEW.groupUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 43 AND chEntityPk = NEW.groupUid); END‚<ƒ=#„Atriggerch_ins_43PersonGroupCREATE TRIGGER ch_ins_43 AFTER INSERT ON PersonGroup BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 43 AS chTableId, NEW.groupUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 43 AND chEntityPk = NEW.groupUid); END‡.ƒ<OCUtriggerlanguagevariant_remote_insert_insLanguageVariant_ReceiveViewCREATE TRIGGER languagevariant_remote_insert_ins INSTEAD OF INSERT ON LanguageVariant_ReceiveView FOR EACH ROW BEGIN REPLACE INTO LanguageVariant(langVariantUid, langUid, countryCode, name, langVariantLocalChangeSeqNum, langVariantMasterChangeSeqNum, langVariantLastChangedBy, langVariantLct) VALUES (NEW.langVariantUid, NEW.langUid, NEW.countryCode, NEW.name, NEW.langVariantLocalChangeSeqNum, NEW.langVariantMasterChangeSeqNum, NEW.langVariantLastChangedBy, NEW.langVariantLct) /*psql ON CONFLICT (langVariantUid) DO UPDATE SET langUid = EXCLUDED.langUid, countryCode = EXCLUDED.countryCode, name = EXCLUDED.name, langVariantLocalChangeSeqNum = EXCLUDED.langVariantLocalChangeSeqNum, langVariantMasterChangeSeqNum = EXCLUDED.langVariantMasterChangeSeqNum, langVariantLastChangedBy = EXCLUDED.langVariantLastChangedBy, langVariantLct = EXCLUDED.langVariantLct */; END‚ƒ;CCƒAviewLanguageVariant_ReceiveViewLanguageVariant_ReceiveViewCREATE VIEW LanguageVariant_ReceiveView AS SELECT LanguageVariant.*, LanguageVariantReplicate.* FROM LanguageVariant LEFT JOIN LanguageVariantReplicate ON LanguageVariantReplicate.lvPk = LanguageVariant.langVariantUid‚Pƒ:+„atriggerch_del_10LanguageVariantCREATE TRIGGER ch_del_10 AFTER DELETE ON LanguageVariant BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 10 AS chTableId, OLD.langVariantUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 10 AND chEntityPk = OLD.langVariantUid); END‚Pƒ9+„atriggerch_upd_10LanguageVariantCREATE TRIGGER ch_upd_10 AFTER UPDATE ON LanguageVariant BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 10 AS chTableId, NEW.langVariantUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 10 AND chEntityPk = NEW.langVariantUid); END ³) [«y})¬ X I‚PƒG'„etriggerch_ins_50PersonPictureCREATE TRIGGER ch_ins_50 AFTER INSERT ON PersonPicture BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 50 AS chTableId, NEW.personPictureUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 50 AND chEntityPk = NEW.personPictureUid); END‡xƒFSGŽatriggerpersongroupmember_remote_insert_insPersonGroupMember_ReceiveViewCREATE TRIGGER persongroupmember_remote_insert_ins INSTEAD OF INSERT ON PersonGroupMember_ReceiveView FOR EACH ROW BEGIN REPLACE INTO PersonGroupMember(groupMemberUid, groupMemberActive, groupMemberPersonUid, groupMemberGroupUid, groupMemberMasterCsn, groupMemberLocalCsn, groupMemberLastChangedBy, groupMemberLct) VALUES (NEW.groupMemberUid, NEW.groupMemberActive, NEW.groupMemberPersonUid, NEW.groupMemberGroupUid, NEW.groupMemberMasterCsn, NEW.groupMemberLocalCsn, NEW.groupMemberLastChangedBy, NEW.groupMemberLct) /*psql ON CONFLICT (groupMemberUid) DO UPDATE SET groupMemberActive = EXCLUDED.groupMemberActive, groupMemberPersonUid = EXCLUDED.groupMemberPersonUid, groupMemberGroupUid = EXCLUDED.groupMemberGroupUid, groupMemberMasterCsn = EXCLUDED.groupMemberMasterCsn, groupMemberLocalCsn = EXCLUDED.groupMemberLocalCsn, groupMemberLastChangedBy = EXCLUDED.groupMemberLastChangedBy, groupMemberLct = EXCLUDED.groupMemberLct */; END‚.ƒEGGƒ_viewPersonGroupMember_ReceiveViewPersonGroupMember_ReceiveViewCREATE VIEW PersonGroupMember_ReceiveView AS SELECT PersonGroupMember.*, PersonGroupMemberReplicate.* FROM PersonGroupMember LEFT JOIN PersonGroupMemberReplicate ON PersonGroupMemberReplicate.pgmPk = PersonGroupMember.groupMemberUid‚TƒD/„etriggerch_del_44PersonGroupMemberCREATE TRIGGER ch_del_44 AFTER DELETE ON PersonGroupMember BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 44 AS chTableId, OLD.groupMemberUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 44 AND chEntityPk = OLD.groupMemberUid); END‚TƒC/„etriggerch_upd_44PersonGroupMemberCREATE TRIGGER ch_upd_44 AFTER UPDATE ON PersonGroupMember BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 44 AS chTableId, NEW.groupMemberUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 44 AND chEntityPk = NEW.groupMemberUid); END‚TƒB/„etriggerch_ins_44PersonGroupMemberCREATE TRIGGER ch_ins_44 AFTER INSERT ON PersonGroupMember BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 44 AS chTableId, NEW.groupMemberUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 44 AND chEntityPk = NEW.groupMemberUid); END¥G;‹1triggerpersongroup_remote_insert_insPersonGroup_ReceiveViewCREATE TRIGGER persongroup_remote_insert_ins INSTEAD OF INSERT ON PersonGroup_ReceiveView FOR EACH ROW BEGIN REPLACE INTO PersonGroup(groupUid, groupMasterCsn, groupLocalCsn, groupLastChangedBy, groupLct, groupName, groupActive, personGroupFlag) VALUES (NEW.groupUid, NEW.groupMasterCsn, NEW.groupLocalCsn, NEW.groupLastChangedBy, NEW.g‚ ƒJ??ƒ)viewPersonPicture_ReceiveViewPersonPicture_ReceiveViewCREATE VIEW PersonPicture_ReceiveView AS SELECT PersonPicture.*, PersonPictureReplicate.* FROM PersonPicture LEFT JOIN PersonPictureReplicate ON PersonPictureReplicate.ppPk = PersonPicture.personPictureUid‚PƒI'„etriggerch_del_50PersonPictureCREATE TRIGGER ch_del_50 AFTER DELETE ON PersonPicture BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 50 AS chTableId, OLD.personPictureUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 50 AND chEntityPk = OLD.personPictureUid); END‚PƒH'„etriggerch_upd_50PersonPictureCREATE TRIGGER ch_upd_50 AFTER UPDATE ON PersonPicture BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 50 AS chTableId, NEW.personPictureUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 50 AND chEntityPk = NEW.personPictureUid); END XÏ I/½¼ xÏG¬v77‚wviewContainer_ReceiveViewContainer_ReceiveViewCREATE VIEW Container_ReceiveView AS SELECT Container.*, ContainerReplicate.* FROM Container LEFT JOIN ContainerReplicate ON ContainerReplicate.containerPk = Container.containerUid‚@ƒO„Mtriggerch_del_51ContainerCREATE TRIGGER ch_del_51 AFTER DELETE ON Container BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 51 AS chTableId, OLD.containerUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 51 AND chEntityPk = OLD.containerUid); END‚@ƒN„Mtriggerch_upd_51ContainerCREATE TRIGGER ch_upd_51 AFTER UPDATE ON ContainerjƒP77‚wviewContainer_ReceiveViewContainer_ReceiveViewCREATE VIEW Container_ReceiveView AS SELECT Container.*, ContainerReplicate.* FROM Container LEFT JOIN ContainerReplicate ON ContainerReplicate.containerPk = Container.containerUid‚@ƒM„Mtriggerch_ins_51ContainerCREATE TRIGGER ch_ins_51 AFTER INSERT ON Container BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 51 AS chTableId, NEW.containerUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 51 AND chEntityPk = NEW.containerUid); END„*ƒL5'ˆtriggerATTUPD_PersonPicturePersonPictureCREATE TRIGGER ATTUPD_PersonPicture AFTER UPDATE ON PersonPicture FOR EACH ROW WHEN OLD.personPictureMd5 IS NOT NULL BEGIN INSERT INTO ZombieAttachmentData(zaUri) SELECT OLD.personPictureUri AS zaUri FROM PersonPicture WHERE PersonPicture.personPictureUid = OLD.personPictureUid AND (SELECT COUNT(*) FROM PersonPicture WHERE personPictureMd5 = OLD.personPictureMd5) = 0 ; ENDŠƒKK?“-triggerpersonpicture_remote_insert_insPersonPicture_ReceiveViewCREATE TRIGGER personpicture_remote_insert_ins INSTEAD OF INSERT ON PersonPicture_ReceiveView FOR EACH ROW BEGIN REPLACE INTO PersonPicture(personPictureUid, personPicturePersonUid, personPictureMasterCsn, personPictureLocalCsn, personPictureLastChangedBy, personPictureLct, personPictureUri, personPictureMd5, fileSize, picTimestamp, mimeType, personPictureActive) VALUES (NEW.personPictureUid, NEW.personPicturePersonUid, NEW.personPictureMasterCsn, NEW.personPictureLocalCsn, NEW.personPictureLastChangedBy, NEW.personPictureLct, NEW.personPictureUri, NEW.personPictureMd5, NEW.fileSize, NEW.picTimestamp, NEW.mimeType, NEW.personPictureActive) /*psql ON CONFLICT (personPictureUid) DO UPDATE SET personPicturePersonUid = EXCLUDED.personPicturePersonUid, personPictureMasterCsn = EXCLUDED.personPictureMasterCsn, personPictureLocalCsn = EXCLUDED.personPictureLocalCsn, personPictureLastChangedBy = EXCLUDED.personPictureLastChangedBy, personPictureLct = EXCLUDED.personPictureLct, personPictureUri = EXCLUDED.personPictureUri, personPictureMd5 = EXCLUDED.personPictureMd5, fileSize = EXCLUDED.fileSize, picTimestamp = EXCLUDED.picTimestamp, mimeType = EXCLUDED.mimeType, personPictureActive = EXCLUDED.personPictureActive */; END‚ ƒJ??ƒ)viewPersonPicture_ReceiveViewPersonPicture_ReceiveViewCREATE VIEW PersonPicture_ReceiveView AS SELECT PersonPicture.*, PersonPictureReplicate.* FROM PersonPicture LEFT JOIN PersonPictureReplicate ON PersonPictureReplicate.ppPk = PersonPicture.personPictureUid '„etriggerch_del_50Perso‚@ƒO„Mtriggerch_del_51ContainerCREATE TRIGGER ch_del_51 AFTER DELETE ON Container BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 51 AS chTableId, OLD.containerUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 51 AND chEntityPk = OLD.containerUid); END‚@ƒN„Mtriggerch_upd_51ContainerCREATE TRIGGER ch_upd_51 AFTER UPDATE ON Container BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 51 AS chTableId, NEW.containerUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 51 AND chEntityPk = NEW.containerUid); END 5 N Öš¯Å}5 ŠÕE9ŠYtriggerverbentity_remote_insert_insVerbEntity_ReceiveViewCREATE TRIGGER verbentity_remote_insert_ins INSTEAD OF INSERT ON VerbEntity_ReceiveView FOR EACH ROW BEGIN REPLACE INTO VerbEntity(verbUid, urlId, verbInActive, v‚DƒX'„Mtriggerch_upd_64XObjectEntityCREATE TRIGGER ch_upd_64 AFTER UPDATE ON XObjectEntity BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 64 AS chTableId, NEW.xObjectUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 64 AND chEntityPk = NEW.xObjectUid); END‚DƒW'„Mtriggerch_ins_64XObjectEntityCREATE TRIGGER ch_ins_64 AFTER INSERT ON XObjectEntity BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 64 AS chTableId, NEW.xObjectUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 64 AND chEntityPk = NEW.xObjectUid); END…fƒVE9ŠYtriggerverbentity_remote_insert_insVerbEntity_ReceiveViewCREATE TRIGGER verbentity_remote_insert_ins INSTEAD OF INSERT ON VerbEntity_ReceiveView FOR EACH ROW BEGIN REPLACE INTO VerbEntity(verbUid, urlId, verbInActive, verbMasterChangeSeqNum, verbLocalChangeSeqNum, verbLastChangedBy, verbLct) VALUES (NEW.verbUid, NEW.urlId, NEW.verbInActive, NEW.verbMasterChangeSeqNum, NEW.verbLocalChangeSeqNum, NEW.verbLastChangedBy, NEW.verbLct) /*psql ON CONFLICT (verbUid) DO UPDATE SET urlId = EXCLUDED.urlId, verbInActive = EXCLUDED.verbInActive, verbMasterChangeSeqNum = EXCLUDED.verbMasterChangeSeqNum, verbLocalChangeSeqNum = EXCLUDED.verbLocalChangeSeqNum, verbLastChangedBy = EXCLUDED.verbLastChangedBy, verbLct = EXCLUDED.verbLct */; ENDgƒU99‚mviewVerbEntity_ReceiveViewVerbEntity_ReceiveViewCREATE VIEW VerbEntity_ReceiveView AS SELECT VerbEntity.*, VerbEntityReplicate.* FROM VerbEntity LEFT JOIN VerbEntityReplicate ON VerbEntityReplicate.vePk = VerbEntity.verbUid‚8ƒT!„;triggerch_del_62VerbEntityCREATE TRIGGER ch_del_62 AFTER DELETE ON VerbEntity BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 62 AS chTableId, OLD.verbUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 62 AND chEntityPk = OLD.verbUid); END‚8ƒS!„;triggerch_upd_62VerbEntityCREATE TRIGGER ch_upd_62 AFTER UPDATE ON VerbEntity BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 62 AS chTableId, NEW.verbUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 62 AND chEntityPk = NEW.verbUid); END‚8ƒR!„;triggerch_ins_62VerbEntityCREATE TRIGGER ch_ins_62 AFTER INSERT ON VerbEntity BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 62 AS chTableId, NEW.verbUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 62 AND chEntityPk = NEW.verbUid); END‰.ƒQC7‘mtriggercontainer_remote_insert_insContainer_ReceiveViewCREATE TRIGGER container_remote_insert_ins INSTEAD OF INSERT ON Container_ReceiveView FOR EACH ROW BEGIN REPLACE INTO Container(containerUid, cntLocalCsn, cntMasterCsn, cntLastModBy, cntLct, fileSize, containerContentEntryUid, cntLastModified, mimeType, remarks, mobileOptimized, cntNumEntries) SELECT NEW.containerUid, NEW.cntLocalCsn, NEW.cntMasterCsn, NEW.cntLastModBy, NEW.cntLct, NEW.fileSize, NEW.containerContentEntryUid, NEW.cntLastModified, NEW.mimeType, NEW.remarks, NEW.mobileOptimized, NEW.cntNumEntries WHERE NEW.cntLct > (SELECT COALESCE( (SELECT ContainerInt.cntLct FROM Container ContainerInt WHERE ContainerInt.containerUid = NEW.containerUid), 0)) /*psql ON CONFLICT (containerUid) DO UPDATE SET cntLocalCsn = EXCLUDED.cntLocalCsn, cntMasterCsn = EXCLUDED.cntMasterCsn, cntLastModBy = EXCLUDED.cntLastModBy, cntLct = EXCLUDED.cntLct, fileSize = EXCLUDED.fileSize, containerContentEntryUid = EXCLUDED.containerContentEntryUid, cntLastModified = EXCLUDED.cntLastModified, mimeType = EXCLUDED.mimeType, remarks = EXCLUDED.remarks, mobileOptimized = EXCLUDED.mobileOptimized, cntNumEntries = EXCLUDED.cntNumEntries */; END ›æSI6æ° ` C‚Lƒ\+„Ytriggerch_ins_60StatementEntityCREATE TRIGGER ch_ins_60 AFTER INSERT ON StatementEntity BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 60 AS chTableId, NEW.statementUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 60 AND chEntityPk = NEW.statementUid); ENDŠƒ[K?“triggerxobjectentity_remote_insert_insXObjectEntity_ReceiveViewCREATE TRIGGER xobjectentity_remote_insert_ins INSTEAD OF INSERT ON XObjectEntity_ReceiveView FOR EACH ROW BEGIN REPLACE INTO XObjectEntity(xObjectUid, objectType, objectId, definitionType, interactionType, correctResponsePattern, objectContentEntryUid, objectStatementRefUid, xObjectMasterChangeSeqNum, xObjectocalChangeSeqNum, xObjectLastChangedBy, xObjectLct) VALUES (NEW.xObjectUid, NEW.objectType, NEW.objectId, NEW.definitionType, NEW.interactionType, NEW.correctResponsePattern, NEW.objectContentEntryUid, NEW.objectStatementRefUid, NEW.xObjectMasterChangeSeqNum, NEW.xObjectocalChangeSeqNum, NEW.xObjectLastChangedBy, NEW.xObjectLct) /*psql ON CONFLICT (xObjectUid) DO UPDATE SET objectType = EXCLUDED.objectType, objectId = EXCLUDED.objectId, definitionType = EXCLUDED.definitionType, interactionType = EXCLUDED.interactionType, correctResponsePattern = EXCLUDED.correctResponsePattern, objectContentEntryUid = EXCLUDED.objectContentEntryUid,objectStatementRefUid = EXCLUDED.objectStatementRefUid, xObjectMasterChangeSeqNum = EXCLUDED.xObjectMasterChangeSeqNum, xObjectocalChangeSeqNum = EXCLUDED.xObjectocalChangeSeqNum, xObjectLastChangedBy = EXCLUDED.xObjectLastChangedBy, xObjectLct = EXCLUDED.xObjectLct */; END‚ƒZ??ƒviewXObjectEntity_ReceiveViewXObjectEntity_ReceiveViewCREATE VIEW XObjectEntity_ReceiveView AS SELECT XObjectEntity.*, XObjectEntityReplicate.* FROM XObjectEntity LEFT JOIN XObjectEntityReplicate ON XObjectEntityReplicate.xoePk = XObjectEntity.xObjectUid‚DƒY'„Mtriggerch_del_64XObjectEntityCREATE TRIGGER ch_del_64 AFTER DELETE ON XObjectEntity BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 64 AS chTableId, OLD.xObjectUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 64 AND chEntityPk = OLD.xObjectUid); END¨'„Mtriggerch_upd_64XObjectEntityCREATE TRIGGER ch_upd_64 AFTER UPDATE ON XObjectEntity BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 64 AS chTableId, NEW.xObjectUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 64 AND chEntityPk = NEW.xObjectUid); END`'„Mtriggerch_ins_64XObjectEntityCREATE TRIGGER ch_ins_64 AFTER INSERT ON XObjectEntity BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 64 AS chTableId, NEW.xObjectUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 64 AND chEntityPk = NEW.xObjectUid); END…fƒVE9ŠYtriggerverben‚ƒ_CCƒ=viewStatementEntity_ReceiveViewStatementEntity_ReceiveViewCREATE VIEW StatementEntity_ReceiveView AS SELECT StatementEntity.*, StatementEntityReplicate.* FROM StatementEntity LEFT JOIN StatementEntityReplicate ON StatementEntityReplicate.sePk = StatementEntity.statementUid‚Lƒ^+„Ytriggerch_del_60StatementEntityCREATE TRIGGER ch_del_60 AFTER DELETE ON StatementEntity BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 60 AS chTableId, OLD.statementUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 60 AND chEntityPk = OLD.statementUid); END‚Lƒ]+„Ytriggerch_upd_60StatementEntityCREATE TRIGGER ch_upd_60 AFTER UPDATE ON StatementEntity BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 60 AS chTableId, NEW.statementUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 60 AND chEntityPk = NEW.statementUid); END êvê^C…9triggerch_upd_66ContextXObjectStatementJoinCREATE TRIGGER ch_upd_66 AFTER UPDATE ON ContextXObjectStatementJoin BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 66 AS chTableId, NEW.contextXObjectStatementJoinUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 66 AND chEntityPk = NEW.contextXObjectStatementJoinUid); ENDƒƒaC…9triggerch_ins_66ContextXObjectStatementJoinCREATE TRIGGER ch_ins_66 AFTER INSERT ON ContextXObjectStatementJoin BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 66 AS chTableId, NEW.contextXObjectStatementJoinUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 66 AND chEntityPk = NEW.contextXObjectStatementJoinUid); END™ƒ`OC±triggerstatemententity_remote_insert_insStatementEntity_ReceiveViewCREATE TRIGGER statemententity_remote_insert_ins INSTEAD OF INSERT ON StatementEntity_ReceiveView FOR EACH ROW BEGIN REPLACE INTO StatementEntity(statementUid, statementId, statementPersonUid, statementVerbUid, xObjectUid, subStatementActorUid, substatementVerbUid, subStatementObjectUid, agentUid, instructorUid, authorityUid, teamUid, resultCompletion, resultSuccess, resultScoreScaled, resultScoreRaw, resultScoreMin, resultScoreMax, resultDuration, resultResponse, timestamp, stored, contextRegistration, contextPlatform, contextStatementId, fullStatement, statementMasterChangeSeqNum, statementLocalChangeSeqNum, statementLastChangedBy, statementLct, extensionProgress, contentEntryRoot, statementContentEntryUid, statementLearnerGroupUid, statementClazzUid) VALUES (NEW.statementUid, NEW.statementId, NEW.statementPersonUid, NEW.statementVerbUid, NEW.xObjectUid, NEW.subStatementActorUid, NEW.substatementVerbUid, NEW.subStatementObjectUid, NEW.agentUid, NEW.instructorUid, NEW.authorityUid, NEW.teamUid, NEW.resultCompletion, NEW.resultSuccess, NEW.resultScoreScaled, NEW.resultScoreRaw, NEW.resultScoreMin, NEW.resultScoreMax, NEW.resultDuration, NEW.resultResponse, NEW.timestamp, NEW.stored, NEW.contextRegistration, NEW.contextPlatform, NEW.contextStatementId, NEW.fullStatement, NEW.statementMasterChangeSeqNum, NEW.statementLocalChangeSeqNum, NEW.statementLastChangedBy, NEW.statementLct, NEW.extensionProgress, NEW.contentEntryRoot, NEW.statementContentEntryUid, NEW.statementLearnerGroupUid, NEW.statementClazzUid) /*psql ON CONFLICT (statementUid) DO UPDATE SET statementId = EXCLUDED.statementId, statementPersonUid = EXCLUDED.statementPersonUid, statementVerbUid = EXCLUDED.statementVerbUid, xObjectUid = EXCLUDED.xObjectUid, subStatementActorUid = EXCLUDED.subStatementActorUid, substatementVerbUid = EXCLUDED.substatementVerbUid, subStatementObjectUid = EXCLUDED.subStatementObjectUid, agentUid = EXCLUDED.agentUid, instructorUid = EXCLUDED.instructorUid, authorityUid = EXCLUDED.authorityUid, teamUid = EXCLUDED.teamUid, resultCompletion = EXCLUDED.resultCompletion, resultSuccess = EXCLUDED.resultSuccess, resultScoreScaled = EXCLUDED.resultScoreScaled, resultScoreRaw = EXCLUDED.resultScoreRaw, resultScoreMin = EXCLUDED.resultScoreMin, resultScoreMax = EXCLUDED.resultScoreMax, resultDuration = EXCLUDED.resultDuration, resultResponse = EXCLUDED.resultResponse, timestamp = EXCLUDED.timestamp, stored = EXCLUDED.stored, contextRegistration = EXCLUDED.contextRegistration, contextPlatform = EXCLUDED.contextPlatform, contextStatementId = EXCLUDED.contextStatementId, fullStatement = EXCLUDED.fullStatement, statementMasterChangeSeqNum = EXCLUDED.statementMasterChangeSeqNum, statementLocalChangeSeqNum = EXCLUDED.statementLocalChangeSeqNum, statementLastChangedBy = EXCLUDED.statementLastChangedBy, statementLct = EXCLUDED.statementLct, extensionProgress = EXCLUDED.extensionProgress, contentEntryRoot = EXCLUDED.contentEntryRoot, statementContentEntryUid = EXCLUDED.statementContentEntryUid, statementLearnerGroupUid = EXCLUDED.statementLearnerGroupUid, statementClazzUid = EXCLUDED.statementClazzUid */; END tï è \ ¾d$Àäï¯u;;‚}viewAgentEntity_ReceiveViewAgentEntity_ReceiveViewCREATE VIEW AgentEntity_ReceiveView AS SELECT AgentEntity.*, AgentEntityReplicate.* FROM AgentEntity LEFT JOIN AgentEntityReplicate ON AgentEntityReplicate.aePk = AgentEntity.agentUid‚<ƒh#„Atriggerch_del_68AgentEntityCREATE TRIGGER ch_del_68 AFTER DELETEqƒi;;‚}viewAgentEntity_ReceiveViewAgentEntity_ReceiveViewCREATE VIEW AgentEntity_ReceiveView AS SELECT AgentEntity.*, AgentEntityReplicate.* FROM AgentEntity LEFT JOIN AgentEntityReplicate ON AgentEntityReplicate.aePk = AgentEntity.agentUid‚<ƒh#„Atriggerch_del_68AgentEntityCREATE TRIGGER ch_del_68 AFTER DELETE ON AgentEntity BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 68 AS chTableId, OLD.agentUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 68 AND chEntityPk = OLD.agentUid); END‚<ƒf#„Atriggerch_ins_68AgentEntityCREATE TRIGGER ch_ins_68 AFTER INSERT ON AgentEntity BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 68 AS chTableId, NEW.agentUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 68 AND chEntityPk = NEW.agentUid); ENDˆVƒeg[utriggercontextxobjectstatementjoin_remote_insert_insContextXObjectStatementJoin_ReceiveViewCREATE TRIGGER contextxobjectstatementjoin_remote_insert_ins INSTEAD OF INSERT ON ContextXObjectStatementJoin_ReceiveView FOR EACH ROW BEGIN REPLACE INTO ContextXObjectStatementJoin(contextXObjectStatementJoinUid, contextActivityFlag, contextStatementUid, contextXObjectUid, verbMasterChangeSeqNum, verbLocalChangeSeqNum, verbLastChangedBy, contextXObjectLct) VALUES (NEW.contextXObjectStatementJoinUid, NEW.contextActivityFlag, NEW.contextStatementUid, NEW.contextXObjectUid, NEW.verbMasterChangeSeqNum, NEW.verbLocalChangeSeqNum, NEW.verbLastChangedBy, NEW.contextXObjectLct) /*psql ON CONFLICT (contextXObjectStatementJoinUid) DO UPDATE SET contextActivityFlag = EXCLUDED.contextActivityFlag, contextStatementUid = EXCLUDED.contextStatementUid, contextXObjectUid = EXCLUDED.contextXObjectUid, verbMasterChangeSeqNum = EXCLUDED.verbMasterChangeSeqNum, verbLocalChangeSeqNum = EXCLUDED.verbLocalChangeSeqNum, verbLastChangedBy = EXCLUDED.verbLastChangedBy, contextXObjectLct = EXCLUDED.contextXObjectLct */; ENDƒƒd[[…viewContextXObjectStatementJoin_ReceiveViewContextXObjectStatementJoin_ReceiveViewCREATE VIEW ContextXObjectStatementJoin_ReceiveView AS SELECT ContextXObjectStatementJoin.*, ContextXObjectStatementJoinReplicate.* FROM ContextXObjectStatementJoin LEFT JOIN ContextXObjectStatementJoinReplicate ON ContextXObjectStatementJoinReplicate.cxosjPk = ContextXObjectStatementJoin.contextXObjectStatementJoinUidƒƒcC…9triggerch_del_66ContextXObjectStatementJoinCREATE TRIGGER ch_del_66 AFTER DELETE ON ContextXObjectStatementJoin BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 66 AS chTableId, OLD.contextXObjectStatementJoinUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 66 AND chEntityPk = OLD.contextXObjectStatementJoinUid); ENDƒƒbC…9triggerch_upd_66ContextXObjectStatementJoinCREATE TRIGGER ch_upd_66 AFTER UPDATE ON ContextXObjectStatementJoin BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 66 AS chTableId, NEW.contextXObjectStatementJoinUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 66 AND chEntityPk = NEW.contextXObjectStatementJoinUid); ENDLC…9triggerch_ins_66ContextXObjectStatementJoinCREATE TRIGGER ch_ins_‚<ƒg#„Atriggerch_upd_68AgentEntityCREATE TRIGGER ch_upd_68 AFTER UPDATE ON AgentEntity BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 68 AS chTableId, NEW.agentUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 68 AND chEntityPk = NEW.agentUid); END t { ;û»ÆÐt®1„ktriggerch_upd_72StateContentEntityCREATE TRIGGER ch_upd_72 AFTER UPDATE ON StateContentEntity BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 72 AS chTableId, NEW.stateContentUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 72 AND chEntityPk = NEW.stateContentUid); END‚Xƒp1„ktriggerch_ins_72StateContentEntityCREATE TRIGGER ch_ins_72 AFTER INSERT ON StateContentEntity BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 72 AS chTableId, NEW.stateContentUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 72 AND chEntityPk = NEW.stateContentUid); END‡rƒoG;Žmtriggerstateentity_remote_insert_insStateEntity_ReceiveViewCREATE TRIGGER stateentity_remote_insert_ins INSTEAD OF INSERT ON StateEntity_ReceiveView FOR EACH ROW BEGIN REPLACE INTO StateEntity(stateUid, stateId, agentUid, activityId, registration, isIsactive, timestamp, stateMasterChangeSeqNum, stateLocalChangeSeqNum, stateLastChangedBy, stateLct) VALUES (NEW.stateUid, NEW.stateId, NEW.agentUid, NEW.activityId, NEW.registration, NEW.isIsactive, NEW.timestamp, NEW.stateMasterChangeSeqNum, NEW.stateLocalChangeSeqNum, NEW.stateLastChangedBy, NEW.stateLct) /*psql ON CONFLICT (stateUid) DO UPDATE SET stateId = EXCLUDED.stateId, agentUid = EXCLUDED.agentUid, activityId = EXCLUDED.activityId, registration = EXCLUDED.registration, isIsactive = EXCLUDED.isIsactive, timestamp = EXCLUDED.timestamp, stateMasterChangeSeqNum = EXCLUDED.stateMasterChangeSeqNum, stateLocalChangeSeqNum = EXCLUDED.stateLocalChangeSeqNum, stateLastChangedBy = EXCLUDED.stateLastChangedBy, stateLct = EXCLUDED.stateLct */; ENDqƒn;;‚}viewStateEntity_ReceiveViewStateEntity_ReceiveViewCREATE VIEW StateEntity_ReceiveView AS SELECT StateEntity.*, StateEntityReplicate.* FROM StateEntity LEFT JOIN StateEntityReplicate ON StateEntityReplicate.sePk = StateEntity.stateUid‚<ƒm#„Atriggerch_del_70StateEntityCREATE TRIGGER ch_del_70 AFTER DELETE ON StateEntity BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 70 AS chTableId, OLD.stateUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 70 AND chEntityPk = OLD.stateUid); END‚<ƒl#„Atriggerch_upd_70StateEntityCREATE TRIGGER ch_upd_70 AFTER UPDATE ON StateEntity BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 70 AS chTableId, NEW.stateUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 70 AND chEntityPk = NEW.stateUid); END‚<ƒk#„Atriggerch_ins_70StateEntityCREATE TRIGGER ch_ins_70 AFTER INSERT ON StateEntity BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 70 AS chTableId, NEW.stateUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 70 AND chEntityPk = NEW.stateUid); END‰ƒjG;‘ triggeragententity_remote_insert_insAgentEntity_ReceiveViewCREATE TRIGGER agententity_remote_insert_ins INSTEAD OF INSERT ON AgentEntity_ReceiveView FOR EACH ROW BEGIN REPLACE INTO AgentEntity(agentUid, agentMbox, agentMbox_sha1sum, agentOpenid, agentAccountName, agentHomePage, agentPersonUid, statementMasterChangeSeqNum, statementLocalChangeSeqNum, statementLastChangedBy, agentLct) VALUES (NEW.agentUid, NEW.agentMbox, NEW.agentMbox_sha1sum, NEW.agentOpenid, NEW.agentAccountName, NEW.agentHomePage, NEW.agentPersonUid, NEW.statementMasterChangeSeqNum, NEW.statementLocalChangeSeqNum, NEW.statementLastChangedBy, NEW.agentLct) /*psql ON CONFLICT (agentUid) DO UPDATE SET agentMbox = EXCLUDED.agentMbox, agentMbox_sha1sum = EXCLUDED.agentMbox_sha1sum, agentOpenid = EXCLUDED.agentOpenid, agentAccountName = EXCLUDED.agentAccountName, agentHomePage = EXCLUDED.agentHomePage, agentPersonUid = EXCLUDED.agentPersonUid, statementMasterChangeSeqNum = EXCLUDED.statementMasterChangeSeqNum, statementLocalChangeSeqNum = EXCLUDED.statementLocalChangeSeqNum, statementLastChangedBy = EXCLUDED.statementLastChangedBy, agentLct = EXCLUDED.agentLct*/; END ®Ö Röº0Ö¦ L L 8‚Vƒu'„qtriggerch_ins_74XLangMapEntryCREATE TRIGGER ch_ins_74 AFTER INSERT ON XLangMapEntry BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 74 AS chTableId, NEW.statementLangMapUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 74 AND chEntityPk = NEW.statementLangMapUid); END‰ƒtUIytriggerstatecontententity_remote_insert_insStateContentEntity_ReceiveViewCREATE TRIGGER statecontententity_remote_insert_ins INSTEAD OF INSERT ON StateContentEntity_ReceiveView FOR EACH ROW BEGIN REPLACE INTO StateContentEntity(stateContentUid, stateContentStateUid, stateContentKey, stateContentValue, isIsactive, stateContentMasterChangeSeqNum, stateContentLocalChangeSeqNum, stateContentLastChangedBy, stateContentLct) VALUES (NEW.stateContentUid, NEW.stateContentStateUid, NEW.stateContentKey, NEW.stateContentValue, NEW.isIsactive, NEW.stateContentMasterChangeSeqNum, NEW.stateContentLocalChangeSeqNum, NEW.stateContentLastChangedBy, NEW.stateContentLct) /*psql ON CONFLICT (stateContentUid) DO UPDATE SET stateContentStateUid = EXCLUDED.stateContentStateUid, stateContentKey = EXCLUDED.stateContentKey, stateContentValue = EXCLUDED.stateContentValue, isIsactive = EXCLUDED.isIsactive, stateContentMasterChangeSeqNum = EXCLUDED.stateContentMasterChangeSeqNum, stateContentLocalChangeSeqNum = EXCLUDED.stateContentLocalChangeSeqNum, stateContentLastChangedBy = EXCLUDED.stateContentLastChangedBy, stateContentLct = EXCLUDED.stateContentLct */; END‚8ƒsIIƒoviewStateContentEntity_ReceiveViewStateContentEntity_ReceiveViewCREATE VIEW StateContentEntity_ReceiveView AS SELECT StateContentEntity.*, StateContentEntityReplicate.* FROM StateContentEntity LEFT JOIN StateContentEntityReplicate ON StateContentEntityReplicate.scePk = StateContentEntity.stateContentUid‚Xƒr1„ktriggerch_del_72StateContentEntityCREATE TRIGGER ch_del_72 AFTER DELETE ON StateContentEntity BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 72 AS chTableId, OLD.stateContentUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 72 AND chEntityPk = OLD.stateContentUid); END‚Xƒq1„ktriggerch_upd_72StateContentEntityCREATE TRIGGER ch_upd_72 AFTER UPDATE ON StateContentEntity BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 72 AS chTableId, NEW.stateContentUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 72 AND chEntityPk = NEW.stateContentUid); ENDž1„ktriggerch_ins_72StateContentEntityCREATE TRIGGER ch_ins_72 AFTER INSERT ON StateContentEntity BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 72 AS chTableId, NEW.stateContentUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 72 AND chEntityPk = NEW.stateContentUid); ENDœG;Žmtriggerstateentity_remote_insert_in‚ƒx??ƒ3viewXLangMapEntry_ReceiveViewXLangMapEntry_ReceiveViewCREATE VIEW XLangMapEntry_ReceiveView AS SELECT XLangMapEntry.*, XLangMapEntryReplicate.* FROM XLangMapEntry LEFT JOIN XLangMapEntryReplicate ON XLangMapEntryReplicate.xlmePk = XLangMapEntry.statementLangMapUid‚Vƒw'„qtriggerch_del_74XLangMapEntryCREATE TRIGGER ch_del_74 AFTER DELETE ON XLangMapEntry BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 74 AS chTableId, OLD.statementLangMapUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 74 AND chEntityPk = OLD.statementLangMapUid); END‚Vƒv'„qtriggerch_upd_74XLangMapEntryCREATE TRIGGER ch_upd_74 AFTER UPDATE ON XLangMapEntry BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 74 AS chTableId, NEW.statementLangMapUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 74 AND chEntityPk = NEW.statementLangMapUid); END ¦R ’Ó—[RIƒ}11‚AviewSchool_ReceiveViewSchool_ReceiveViewCREATE VIEW School_ReceiveView AS SELECT School.*, SchoolReplicate.* FROM School LEFT JOIN SchoolReplicate ON SchoolReplicate.schoolPk = School.schoolUid‚8ƒ|!„Atriggerch_del_164SchoolCREATE TRIGGER ch_del_164 AFTER DELETE ON School BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 164 AS chTableId, OLD.schoolUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 164 AND chEntityPk = OLD.schoolUid); END‚8ƒ{!„Atriggerch_upd_164SchoolCREATE TRIGGER ch_upd_164 AFTER UPDATE ON School BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 164 AS chTableId, NEW.schoolUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 164 AND chEntityPk = NEW.schoolUid); END‚8ƒz!„Atriggerch_ins_164SchoolCREATE TRIGGER ch_ins_164 AFTER INSERT ON School BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 164 AS chTableId, NEW.schoolUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 164 AND chEntityPk = NEW.schoolUid); END‰;ƒyK?‘wtriggerxlangmapentry_remote_insert_insXLangMapEntry_ReceiveViewCREATE TRIGGER xlangmapentry_remote_insert_ins INSTEAD OF INSERT ON XLangMapEntry_ReceiveView FOR EACH ROW BEGIN REPLACE INTO XLangMapEntry(verbLangMapUid, objectLangMapUid, languageLangMapUid, languageVariantLangMapUid, valueLangMap, statementLangMapMasterCsn, statementLangMapLocalCsn, statementLangMapLcb, statementLangMapLct, statementLangMapUid) VALUES (NEW.verbLangMapUid, NEW.objectLangMapUid, NEW.languageLangMapUid, NEW.languageVariantLangMapUid, NEW.valueLangMap, NEW.statementLangMapMasterCsn, NEW.statementLangMapLocalCsn, NEW.statementLangMapLcb, NEW.statementLangMapLct, NEW.statementLangMapUid) /*psql ON CONFLICT (statementLangMapUid) DO UPDATE SET verbLangMapUid = EXCLUDED.verbLangMapUid, objectLangMapUid = EXCLUDED.objectLangMapUid, languageLangMapUid = EXCLUDED.languageLangMapUid, languageVariantLangMapUid = EXCLUDED.languageVariantLangMapUid, valueLangMap = EXCLUDED.valueLangMap, statementLangMapMasterCsn = EXCLUDED.statementLangMapMasterCsn, statementLangMapLocalCsn = EXCLUDED.statementLangMapLocalCsn, statementLangMapLcb = EXCLUDED.statementLangMapLcb, statementLangMapLct = EXCLUDED.statementLangMapLct */; END‚ƒx??ƒ3viewXLangMapEntry_ReceiveViewXLangMapEntry_ReceiveViewCREATE VIEW XLangMapEntry_ReceiveView AS SELECT XLangMapEntry.*, XLangMapEntryReplicate.* FROM XLangMapEntry LEFT JOIN XLangMapEntryReplicate ON XLangMapEntryReplicate.xlmePk = XLangMapEntry.statementLangMapUidZ'„qtriggerch_del_74XLangMapEntryCREATE TRIGGER ch_del_74 AFTER DELETE ON XLangMapEntry BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 74 AS chTableId, OLD.statementLangMapUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 74 AND chEntityPk = OLD.statementLangMapUid); END ´°\´¯­==ƒviewSchoolMember_ReceiveViewSchoolMember_ReceiveViewCREATE VIEW SchoolMember_ReceiveView AS SELECT SchoolMember.*, SchoolMemberReplicate.* FROM SchoolMember LEFT JOIN SchoolMemberReplicate ON SchoolMemberReplicate.smPk = SchoolMember.schoolMemberUid‚P„!%„etriggerch_del_200SchoolMemberCREATE TRIGGER ch_del_200 AFTER DELETE ON SchoolMember BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 200 AS chTableId, OLD.schoolMemberUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 200 AND chEntityPk = OLD.schoolMemberUid); END‚P„!%„etriggerch_upd_200SchoolMemberCREATE TRIGGER ch_upd_200 AFTER UPDATE ON SchoolMember BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 200 AS chTableId, NEW.schoolMemberUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 200 AND chEntityPk = NEW.schoolMemberUid); END‚Pƒ!%„etriggerch_ins_200SchoolMemberCREATE TRIGGER ch_ins_200 AFTER INSERT ON SchoolMember BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 200 AS chTableId, NEW.schoolMemberUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 200 AND chEntityPk = NEW.schoolMemberUid); ENDLƒ~=1 5triggerschool_remote_insert_insSchool_ReceiveViewCREATE TRIGGER school_remote_insert_ins INSTEAD OF INSERT ON School_ReceiveView FOR EACH ROW BEGIN REPLACE INTO School(schoolUid, schoolName, schoolDesc, schoolAddress, schoolActive, schoolPhoneNumber, schoolGender, schoolHolidayCalendarUid, schoolFeatures, schoolLocationLong, schoolLocationLatt, schoolEmailAddress, schoolTeachersPersonGroupUid, schoolStudentsPersonGroupUid, schoolPendingStudentsPersonGroupUid, schoolCode, schoolMasterChangeSeqNum, schoolLocalChangeSeqNum, schoolLastChangedBy, schoolLct, schoolTimeZone) VALUES (NEW.schoolUid, NEW.schoolName, NEW.schoolDesc, NEW.schoolAddress, NEW.schoolActive, NEW.schoolPhoneNumber, NEW.schoolGender, NEW.schoolHolidayCalendarUid, NEW.schoolFeatures, NEW.schoolLocationLong, NEW.schoolLocationLatt, NEW.schoolEmailAddress, NEW.schoolTeachersPersonGroupUid, NEW.schoolStudentsPersonGroupUid, NEW.schoolPendingStudentsPersonGroupUid, NEW.schoolCode, NEW.schoolMasterChangeSeqNum, NEW.schoolLocalChangeSeqNum, NEW.schoolLastChangedBy, NEW.schoolLct, NEW.schoolTimeZone) /*psql ON CONFLICT (schoolUid) DO UPDATE SET schoolName = EXCLUDED.schoolName, schoolDesc = EXCLUDED.schoolDesc, schoolAddress = EXCLUDED.schoolAddress, schoolActive = EXCLUDED.schoolActive, schoolPhoneNumber = EXCLUDED.schoolPhoneNumber, schoolGender = EXCLUDED.schoolGender, schoolHolidayCalendarUid = EXCLUDED.schoolHolidayCalendarUid, schoolFeatures = EXCLUDED.schoolFeatures, schoolLocationLong = EXCLUDED.schoolLocationLong, schoolLocationLatt = EXCLUDED.schoolLocationLatt, schoolEmailAddress = EXCLUDED.schoolEmailAddress, schoolTeachersPersonGroupUid = EXCLUDED.schoolTeachersPersonGroupUid, schoolStudentsPersonGroupUid = EXCLUDED.schoolStudentsPersonGroupUid, schoolPendingStudentsPersonGroupUid = EXCLUDED.schoolPendingStudentsPersonGroupUid, schoolCode = EXCLUDED.schoolCode, schoolMasterChangeSeqNum = EXCLUDED.schoolMasterChangeSeqNum, schoolLocalChangeSeqNum = EXCLUDED.schoolLocalChangeSeqNum, schoolLastChangedBy = EXCLUDED.schoolLastChangedBy, schoolLct = EXCLUDED.schoolLct, schoolTimeZone = EXCLUDED.schoolTimeZone */; END X SãŸ[ Xã55‚eviewComments_ReceiveViewComments_ReceiveViewCREATE VIEW Comments_ReceiveView AS SELECT Comments.*, CommentsReplicate.* FROM Comments LEFT JOIN CommentsReplicate ON CommentsReplicate.commentsPk = Comments.commentsUid‚@„!„Mtriggerch_del_208CommentsCREATE TRIGGER ch_del_208 AFTER DELETE ON Comments BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 208 AS chTableId, OLD.commentsUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 208 AND chEntityPk = OLD.commentsUid); END‚@„!„Mtriggerch_upd_208CommentsCREATE TRIGGER ch_upd_208 AFTER UPDATE ON Comments BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 208 AS chTableId, NEW.commentsUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 208 AND chEntityPk = NEW.commentsUid); END‚@„!„Mtriggerch_ins_208CommentsCREATE TRIGGER ch_ins_208 AFTER INSERT ON Comments BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 208 AS chTableId, NEW.commentsUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 208 AND chEntityPk = NEW.commentsUid); ENDŠl„I=”]triggerschoolmember_remote_insert_insSchoolMember_ReceiveViewCREATE TRIGGER schoolmember_remote_insert_ins INSTEAD OF INSERT ON SchoolMember_ReceiveView FOR EACH ROW BEGIN REPLACE INTO SchoolMember(schoolMemberUid, schoolMemberPersonUid, schoolMemberSchoolUid, schoolMemberJoinDate, schoolMemberLeftDate, schoolMemberRole, schoolMemberActive, schoolMemberLocalChangeSeqNum, schoolMemberMasterChangeSeqNum, schoolMemberLastChangedBy, schoolMemberLct) VALUES (NEW.schoolMemberUid, NEW.schoolMemberPersonUid, NEW.schoolMemberSchoolUid, NEW.schoolMemberJoinDate, NEW.schoolMemberLeftDate, NEW.schoolMemberRole, NEW.schoolMemberActive, NEW.schoolMemberLocalChangeSeqNum, NEW.schoolMemberMasterChangeSeqNum, NEW.schoolMemberLastChangedBy, NEW.schoolMemberLct) /*psql ON CONFLICT (schoolMemberUid) DO UPDATE SET schoolMemberPersonUid = EXCLUDED.schoolMemberPersonUid, schoolMemberSchoolUid = EXCLUDED.schoolMemberSchoolUid, schoolMemberJoinDate = EXCLUDED.schoolMemberJoinDate, schoolMemberLeftDate = EXCLUDED.schoolMemberLeftDate, schoolMemberRole = EXCLUDED.schoolMemberRole, schoolMemberActive = EXCLUDED.schoolMemberActive, schoolMemberLocalChangeSeqNum = EXCLUDED.schoolMemberLocalChangeSeqNum, schoolMemberMasterChangeSeqNum = EXCLUDED.schoolMemberMasterChangeSeqNum, schoolMemberLastChangedBy = EXCLUDED.schoolMemberLastChangedBy, schoolMemberLct = EXCLUDED.schoolMemberLct */; END‚„==ƒviewSchoolMember_ReceiveViewSchoolMember_ReceiveViewCREATE VIEW SchoolMember_ReceiveView AS SELECT SchoolMember.*, SchoolMemberReplicate.* FROM SchoolMember LEFT JOIN SchoolMemberReplicate ON SchoolMemberReplicate.smPk = SchoolMember.schoolMemberUidÅ!%„etriggerch_del_200SchoolMemberCREATE TRIGGER ch_del_200 AFTER DELETE ON SchoolMember BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 200 AS chTableId, OLD.schoolMemberUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 200 AND chEntityPk = OLD.schoolMemberUid); END‚P„!%„etriggerch_upd_200SchoolMemberCREATE TRIGGER ch_upd_200 AFTER UPDATE ON SchoolMember BEGIN INSERT INTO _„55‚eviewComments_ReceiveViewComments_ReceiveViewCREATE VIEW Comments_ReceiveView AS SELECT Comments.*, CommentsReplicate.* FROM Comments LEFT JOIN CommentsReplicate ON CommentsReplicate.commentsPk = Comments.commentsUid ¹}A3Í11‚AviewReport_ReceiveViewReport_ReceiveViewCREATE VIEW Report_ReceiveView AS SELECT Report.*, ReportReplicate.* FROM Report LEFT JOIN ReportReplicate ON ReportReplicate.reportPk = Report.reportUid‚8„ !„Atriggerch_del_101ReportCREATE TRIGGER ch_del_101 AFTER DELETE ON Report BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 101 AS chTableId, OLD.reportUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 101 AND chEntityPk = OLD.reportUid); END‚8„ !„Atriggerch_upd_101ReportCREATE TRIGGER ch_upd_101 AFTER UPDATE ON Report BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 101 AS chTableId, NEW.reportUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 101 AND chEntityPk = NEW.reportUid); END‚8„ !„Atriggerch_ins_101ReportCREATE TRIGGER ch_ins_101 AFTER INSERT ON Report BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 101 AS chTableId, NEW.reportUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 101 AND chEntityPk = NEW.reportUid); ENDŒ`„A5˜Utriggercomments_remote_insert_insComments_ReceiveViewCREATE TRIGGER comments_remote_insert_ins INSTEAD OF INSERT ON Comments_ReceiveView FOR EACH ROW BEGIN REPLACE INTO Comments(commentsUid, commentsText, commentsEntityType, commentsEntityUid, commentsPublic, commentsStatus, commentsPersonUid, commentsToPersonUid, commentSubmitterUid, commentsFlagged, commentsInActive, commentsDateTimeAdded, commentsDateTimeUpdated, commentsMCSN, commentsLCSN, commentsLCB, commentsLct) VALUES (NEW.commentsUid, NEW.commentsText, NEW.commentsEntityType, NEW.commentsEntityUid, NEW.commentsPublic, NEW.commentsStatus, NEW.commentsPersonUid, NEW.commentsToPersonUid, NEW.commentSubmitterUid, NEW.commentsFlagged, NEW.commentsInActive, NEW.commentsDateTimeAdded, NEW.commentsDateTimeUpdated, NEW.commentsMCSN, NEW.commentsLCSN, NEW.commentsLCB, NEW.commentsLct) /*psql ON CONFLICT (commentsUid) DO UPDATE SET commentsText = EXCLUDED.commentsText, commentsEntityType = EXCLUDED.commentsEntityType, commentsEntityUid = EXCLUDED.commentsEntityUid, commentsPublic = EXCLUDED.commentsPublic, commentsStatus = EXCLUDED.commentsStatus, commentsPersonUid = EXCLUDED.commentsPersonUid, commentsToPersonUid = EXCLUDED.commentsToPersonUid, commentSubmitterUid = EXCLUDED.commentSubmitterUid, commentsFlagged = EXCLUDED.commentsFlagged, commentsInActive = EXCLUDED.commentsInActive, commentsDateTimeAdded = EXCLUDED.commentsDateTimeAdded, commentsDateTimeUpdated = EXCLUDED.commentsDateTimeUpdated, commentsMCSN = EXCLUDED.commentsMCSN, commentsLCSN = EXCLUDED.commentsLCSN, commentsLCB = EXCLUDED.commentsLCB, commentsLct = EXCLUDED.commentsLct */; END55‚eviewCommentI„ 11‚AviewReport_ReceiveViewReport_ReceiveViewCREATE VIEW Report_ReceiveView AS SELECT Report.*, ReportReplicate.* FROM Report LEFT JOIN ReportReplicate ON ReportReplicate.reportPk = Report.reportUid 3>­yEI>‡ò9-ŠCtriggersite_remote_insert_insSite_ReceiveViewCREATE TRIGGER site_remote_insert_ins INSTEAD OF INSERT ON Site_ReceiveView FOR EACH ROW BEGIN REPLACE INTO Site(siteUid, siteP…O„9-ŠCtriggersite_remote_insert_insSite_ReceiveViewCREATE TRIGGER site_remote_insert_ins INSTEAD OF INSERT ON Site_ReceiveView FOR EACH ROW BEGIN REPLACE INTO Site(siteUid, sitePcsn, siteLcsn, siteLcb, siteLct, siteName, guestLogin, registrationAllowed, authSalt) VALUES (NEW.siteUid, NEW.sitePcsn, NEW.siteLcsn, NEW.siteLcb, NEW.siteLct, NEW.siteName, NEW.guestLogin, NEW.registrationAllowed, NEW.authSalt) /*psql ON CONFLICT (siteUid) DO UPDATE SET sitePcsn = EXCLUDED.sitePcsn, siteLcsn = EXCLUDED.siteLcsn, siteLcb = EXCLUDED.siteLcb, siteLct = EXCLUDED.siteLct, siteName = EXCLUDED.siteName, guestLogin = EXCLUDED.guestLogin, registrationAllowed = EXCLUDED.registrationAllowed, authSalt = EXCLUDED.authSalt*/; END‚0„!„5triggerch_del_189SiteCREATE TRIGGER ch_del_189 AFTER DELETE ON Site BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 189 AS chTableId, OLD.siteUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 189 AND chEntityPk = OLD.siteUid); END‚0„!„5triggerch_upd_189SiteCREATE TRIGGER ch_upd_189 AFTER UPDATE ON Site BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 189 AS chTableId, NEW.siteUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 189 AND chEntityPk = NEW.siteUid); END‚0„!„5triggerch_ins_189SiteCREATE TRIGGER ch_ins_189 AFTER INSERT ON Site BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 189 AS chTableId, NEW.siteUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 189 AND chEntityPk = NEW.siteUid); END„ =1!triggerreport_remote_insert_insReport_ReceiveViewCREATE TRIGGER report_remote_insert_ins INSTEAD OF INSERT ON Report_ReceiveView FOR EACH ROW BEGIN REPLACE INTO Report(reportUid, reportOwnerUid, xAxis, reportDateRangeSelection, fromDate, fromRelTo, fromRelOffSet, fromRelUnit, toDate, toRelTo, toRelOffSet, toRelUnit, reportTitle, reportDescription, reportSeries, reportInactive, isTemplate, priority, reportTitleId, reportDescId, reportMasterChangeSeqNum, reportLocalChangeSeqNum, reportLastChangedBy, reportLct) VALUES (NEW.reportUid, NEW.reportOwnerUid, NEW.xAxis, NEW.reportDateRangeSelection, NEW.fromDate, NEW.fromRelTo, NEW.fromRelOffSet, NEW.fromRelUnit, NEW.toDate, NEW.toRelTo, NEW.toRelOffSet, NEW.toRelUnit, NEW.reportTitle, NEW.reportDescription, NEW.reportSeries, NEW.reportInactive, NEW.isTemplate, NEW.priority, NEW.reportTitleId, NEW.reportDescId, NEW.reportMasterChangeSeqNum, NEW.reportLocalChangeSeqNum, NEW.reportLastChangedBy, NEW.reportLct) /*psql ON CONFLICT (reportUid) DO UPDATE SET reportOwnerUid = EXCLUDED.reportOwnerUid, xAxis = EXCLUDED.xAxis, reportDateRangeSelection = EXCLUDED.reportDateRangeSelection, fromDate = EXCLUDED.fromDate, fromRelTo = EXCLUDED.fromRelTo, fromRelOffSet = EXCLUDED.fromRelOffSet, fromRelUnit = EXCLUDED.fromRelUnit, toDate = EXCLUDED.toDate, toRelTo = EXCLUDED.toRelTo, toRelOffSet = EXCLUDED.toRelOffSet, toRelUnit = EXCLUDED.toRelUnit, reportTitle = EXCLUDED.reportTitle, reportDescription = EXCLUDED.reportDescription, reportSeries = EXCLUDED.reportSeries, reportInactive = EXCLUDED.reportInactive, isTemplate = EXCLUDED.isTemplate, priority = EXCLUDED.priority, reportTitleId = EXCLUDED.reportTitleId, reportDescId = EXCLUDED.reportDescId, reportMasterChangeSeqNum = EXCLUDED.reportMasterChangeSeqNum, reportLocalChangeSeqNum = EXCLUDED.reportLocalChangeSeqNum, reportLastChangedBy = EXCLUDED.reportLastChangedBy, reportLct = EXCLUDED.reportLct */; END11‚AviewReport_3„--‚viewSite_ReceiveViewSite_ReceiveViewCREATE VIEW Site_ReceiveView AS SELECT Site.*, SiteReplicate.* FROM Site LEFT JOIN SiteReplicate ON SiteReplicate.sitePk = Site.siteUid  cºf c” ( ¼ z‡&„I=Qtriggerlearnergroup_remote_insert_insLearnerGroup_ReceiveViewCREATE TRIGGER learnergroup_remote_insert_ins INSTEAD OF INSERT ON LearnerGroup_ReceiveView FOR EACH ROW BEGIN REPLACE INTO LearnerGroup(learnerGroupUid, learnerGroupName, learnerGroupDescription, learnerGroupActive, learnerGroupMCSN, learnerGroupCSN, learnerGroupLCB, learnerGroupLct) VALUES (NEW.learnerGroupUid, NEW.learnerGroupName, NEW.learnerGroupDescription, NEW.learnerGroupActive, NEW.learnerGroupMCSN, NEW.learnerGroupCSN, NEW.learnerGroupLCB, NEW.learnerGroupLct) /*psql ON CONFLICT (learnerGroupUid) DO UPDATE SET learnerGroupName = EXCLUDED.learnerGroupName, learnerGroupDescription = EXCLUDED.learnerGroupDescription, learnerGroupActive = EXCLUDED.learnerGroupActive, learnerGroupMCSN = EXCLUDED.learnerGroupMCSN, learnerGroupCSN = EXCLUDED.learnerGroupCSN, learnerGroupLCB = EXCLUDED.learnerGroupLCB, learnerGroupLct = EXCLUDED.learnerGroupLct */; END‚„==ƒviewLearnerGroup_ReceiveViewLearnerGroup_ReceiveViewCREATE VIEW LearnerGroup_ReceiveView AS SELECT LearnerGroup.*, LearnerGroupReplicate.* FROM LearnerGroup LEFT JOIN LearnerGroupReplicate ON LearnerGroupReplicate.lgPk = LearnerGroup.learnerGroupUid‚P„!%„etriggerch_del_301LearnerGroupCREATE TRIGGER ch_del_301 AFTER DELETE ON LearnerGroup BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 301 AS chTableId, OLD.learnerGroupUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 301 AND chEntityPk = OLD.learnerGroupUid); END‚P„!%„etriggerch_upd_301LearnerGroupCREATE TRIGGER ch_upd_301 AFTER UPDATE ON LearnerGroup BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 301 AS chTableId, NEW.learnerGroupUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 301 AND chEntityPk = NEW.learnerGroupUid); END‚P„!%„etriggerch_ins_301LearnerGroupCREATE TRIGGER ch_ins_301 AFTER INSERT ON LearnerGroup BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 301 AS chTableId, NEW.learnerGroupUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 301 AND chEntityPk = NEW.learnerGroupUid); ENDl9-ŠCtriggersite_remote_insert_insSite_ReceiveViewCREATE TRIGGER site_remote_insert_ins INSTEAD OF INS‚>„IIƒ{viewLearnerGroupMember_ReceiveViewLearnerGroupMember_ReceiveViewCREATE VIEW LearnerGroupMember_ReceiveView AS SELECT LearnerGroupMember.*, LearnerGroupMemberReplicate.* FROM LearnerGroupMember LEFT JOIN LearnerGroupMemberReplicate ON LearnerGroupMemberReplicate.lgmPk = LearnerGroupMember.learnerGroupMemberUid‚h„!1… triggerch_del_300LearnerGroupMemberCREATE TRIGGER ch_del_300 AFTER DELETE ON LearnerGroupMember BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 300 AS chTableId, OLD.learnerGroupMemberUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 300 AND chEntityPk = OLD.learnerGroupMemberUid); END‚h„!1… triggerch_upd_300LearnerGroupMemberCREATE TRIGGER ch_upd_300 AFTER UPDATE ON LearnerGroupMember BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 300 AS chTableId, NEW.learnerGroupMemberUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 300 AND chEntityPk = NEW.learnerGroupMemberUid); END‚h„!1… triggerch_ins_300LearnerGroupMemberCREATE TRIGGER ch_ins_300 AFTER INSERT ON LearnerGroupMember BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 300 AS chTableId, NEW.learnerGroupMemberUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 300 AND chEntityPk = NEW.learnerGroupMemberUid); END h   ,¸bh‰v„!YM’Qtriggergrouplearningsession_remote_insert_insGroupLearningSession_ReceiveViewCREATE TRIGGER grouplearningsession_remote_insert_ins INSTEAD OF INSERT ON GroupLearningSession_ReceiveView FOR EACH ROW BEGIN REPLACE INTO GroupLearningSession(groupLearningSessionUid, groupLearningSessionContentUid, groupLearningSessionLearnerGroupUid, groupLearningSessionInactive, groupLearningSessionMCSN, groupLearningSessionCSN, groupLearningSessionLCB, groupLearningSessionLct) VALUES (NEW.groupLearningSessionUid, NEW.groupLearningSessionContentUid, NEW.groupLearningSessionLearnerGroupUid, NEW.groupLearningSessionInactive, NEW.groupLearningSessionMCSN, NEW.groupLearningSessionCSN, NEW.groupLearningSessionLCB, NEW.groupLearningSessionLct) /*psql ON CONFLICT (groupLearningSessionUid) DO UPDATE SET groupLearningSessionContentUid = EXCLUDED.groupLearningSessionContentUid, groupLearningSessionLearnerGroupUid = EXCLUDED.groupLearningSessionLearnerGroupUid, groupLearningSessionInactive = EXCLUDED.groupLearningSessionInactive, groupLearningSessionMCSN = EXCLUDED.groupLearningSessionMCSN, groupLearningSessionCSN = EXCLUDED.groupLearningSessionCSN, groupLearningSessionLCB = EXCLUDED.groupLearningSessionLCB, groupLearningSessionLct = EXCLUDED.groupLearningSessionLct */; END‚R„ MM„viewGroupLearningSession_ReceiveViewGroupLearningSession_ReceiveViewCREATE VIEW GroupLearningSession_ReceiveView AS SELECT GroupLearningSession.*, GroupLearningSessionReplicate.* FROM GroupLearningSession LEFT JOIN GroupLearningSessionReplicate ON GroupLearningSessionReplicate.glsPk = GroupLearningSession.groupLearningSessionUid‚p„!5…triggerch_del_302GroupLearningSessionCREATE TRIGGER ch_del_302 AFTER DELETE ON GroupLearningSession BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 302 AS chTableId, OLD.groupLearningSessionUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 302 AND chEntityPk = OLD.groupLearningSessionUid); END‚p„!5…triggerch_upd_302GroupLearningSessionCREATE TRIGGER ch_upd_302 AFTER UPDATE ON GroupLearningSession BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 302 AS chTableId, NEW.groupLearningSessionUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 302 AND chEntityPk = NEW.groupLearningSessionUid); END‚p„!5…triggerch_ins_302GroupLearningSessionCREATE TRIGGER ch_ins_302 AFTER INSERT ON GroupLearningSession BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 302 AS chTableId, NEW.groupLearningSessionUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 302 AND chEntityPk = NEW.groupLearningSessionUid); END‰h„UI’=triggerlearnergroupmember_remote_insert_insLearnerGroupMember_ReceiveViewCREATE TRIGGER learnergroupmember_remote_insert_ins INSTEAD OF INSERT ON LearnerGroupMember_ReceiveView FOR EACH ROW BEGIN REPLACE INTO LearnerGroupMember(learnerGroupMemberUid, learnerGroupMemberPersonUid, learnerGroupMemberLgUid, learnerGroupMemberRole, learnerGroupMemberActive, learnerGroupMemberMCSN, learnerGroupMemberCSN, learnerGroupMemberLCB, learnerGroupMemberLct) VALUES (NEW.learnerGroupMemberUid, NEW.learnerGroupMemberPersonUid, NEW.learnerGroupMemberLgUid, NEW.learnerGroupMemberRole, NEW.learnerGroupMemberActive, NEW.learnerGroupMemberMCSN, NEW.learnerGroupMemberCSN, NEW.learnerGroupMemberLCB, NEW.learnerGroupMemberLct) /*psql ON CONFLICT (learnerGroupMemberUid) DO UPDATE SET learnerGroupMemberPersonUid = EXCLUDED.learnerGroupMemberPersonUid, learnerGroupMemberLgUid = EXCLUDED.learnerGroupMemberLgUid, learnerGroupMemberRole = EXCLUDED.learnerGroupMemberRole, learnerGroupMemberActive = EXCLUDED.learnerGroupMemberActive, learnerGroupMemberMCSN = EXCLUDED.learnerGroupMemberMCSN, learnerGroupMemberCSN = EXCLUDED.learnerGroupMemberCSN, learnerGroupMemberLCB = EXCLUDED.learnerGroupMemberLCB, learnerGroupMemberLct = EXCLUDED.learnerGroupMemberLct */; END ° ]n,ê§]¶ l K‚F„'!-„Itriggerch_ins_134ClazzContentJoinCREATE TRIGGER ch_ins_134 AFTER INSERT ON ClazzContentJoin BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 134 AS chTableId, NEW.ccjUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 134 AND chEntityPk = NEW.ccjUid); END†[„&C7ŒGtriggersiteterms_remote_insert_insSiteTerms_ReceiveViewCREATE TRIGGER siteterms_remote_insert_ins INSTEAD OF INSERT ON SiteTerms_ReceiveView FOR EACH ROW BEGIN REPLACE INTO SiteTerms(sTermsUid, termsHtml, sTermsLang, sTermsLangUid, sTermsActive, sTermsLastChangedBy, sTermsPrimaryCsn, sTermsLocalCsn, sTermsLct) VALUES (NEW.sTermsUid, NEW.termsHtml, NEW.sTermsLang, NEW.sTermsLangUid, NEW.sTermsActive, NEW.sTermsLastChangedBy, NEW.sTermsPrimaryCsn, NEW.sTermsLocalCsn, NEW.sTermsLct) /*psql ON CONFLICT (sTermsUid) DO UPDATE SET termsHtml = EXCLUDED.termsHtml, sTermsLang = EXCLUDED.sTermsLang, sTermsLangUid = EXCLUDED.sTermsLangUid, sTermsActive = EXCLUDED.sTermsActive, sTermsLastChangedBy = EXCLUDED.sTermsLastChangedBy, sTermsPrimaryCsn = EXCLUDED.sTermsPrimaryCsn, sTermsLocalCsn = EXCLUDED.sTermsLocalCsn, sTermsLct = EXCLUDED.sTermsLct */; END`„%77‚cviewSiteTerms_ReceiveViewSiteTerms_ReceiveViewCREATE VIEW SiteTerms_ReceiveView AS SELECT SiteTerms.*, SiteTermsReplicate.* FROM SiteTerms LEFT JOIN SiteTermsReplicate ON SiteTermsReplicate.stPk = SiteTerms.sTermsUid‚>„$!„Gtriggerch_del_272SiteTermsCREATE TRIGGER ch_del_272 AFTER DELETE ON SiteTerms BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 272 AS chTableId, OLD.sTermsUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 272 AND chEntityPk = OLD.sTermsUid); END‚>„#!„Gtriggerch_upd_272SiteTermsCREATE TRIGGER ch_upd_272 AFTER UPDATE ON SiteTerms BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 272 AS chTableId, NEW.sTermsUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 272 AND chEntityPk = NEW.sTermsUid); END‚>„"!„Gtriggerch_ins_272SiteTermsCREATE TRIGGER ch_ins_272 AFTER INSERT ON SiteTerms BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 272 AS chTableId, NEW.sTermsUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 272 AND chEntityPk = NEW.sTermsUid); END›YM’Qtriggergrouplearningsession_remote_insert_insGroupLearningSession_ReceiveViewCREATE TRIGGER grouplearningsession_remote_insert_ins INSTEAD OF INSERT ON GroupLearningSession_ReceiveView FOR EACH ROW BEGIN REPLACE INTO GroupLearningSession(groupLearningSessionUid, groupLearningSessionContentUid, groupLearningSessionLearnerGroupUid, groupLearningSessionInactive, groupLearningSessionMCSN, groupLearningSessionCSN, groupLearningSessionLCB, groupLearningSessionLct) VALUES (NEW.groupLearningSessionUid, NEW.groupLearningSessionContentUid, NEW.groupLearningSessionLearnerGroupUid, NEW.groupLearningSessionInactive, NEW.groupLearningSessionMCSN, NEW.groupLearni‚„*EEƒAviewClazzContentJoin_ReceiveViewClazzContentJoin_ReceiveViewCREATE VIEW ClazzContentJoin_ReceiveView AS SELECT ClazzContentJoin.*, ClazzContentJoinReplicate.* FROM ClazzContentJoin LEFT JOIN ClazzContentJoinReplicate ON ClazzContentJoinReplicate.ccjPk = ClazzContentJoin.ccjUid‚F„)!-„Itriggerch_del_134ClazzContentJoinCREATE TRIGGER ch_del_134 AFTER DELETE ON ClazzContentJoin BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 134 AS chTableId, OLD.ccjUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 134 AND chEntityPk = OLD.ccjUid); END‚F„(!-„Itriggerch_upd_134ClazzContentJoinCREATE TRIGGER ch_upd_134 AFTER UPDATE ON ClazzContentJoin BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 134 AS chTableId, NEW.ccjUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 134 AND chEntityPk = NEW.ccjUid); END ‹ ¡ W âÿÅ‹‚6„2#„5triggerch_upd_48ScopedGrantCREATE TRIGGER ch_upd_48 AFTER UPDATE ON ScopedGrant BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 48 AS chTableId, NEW.sgUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 48 AND chEntityPk = NEW.sgUid); END‚6„1#„5triggerch_ins_48ScopedGrantCREATE TRIGGER ch_ins_48 AFTER INSERT ON ScopedGrant BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 48 AS chTableId, NEW.sgUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 48 AND chEntityPk = NEW.sgUid); END‰„0QE‘3triggerpersonparentjoin_remote_insert_insPersonParentJoin_ReceiveViewCREATE TRIGGER personparentjoin_remote_insert_ins INSTEAD OF INSERT ON PersonParentJoin_ReceiveView FOR EACH ROW BEGIN REPLACE INTO PersonParentJoin(ppjUid, ppjPcsn, ppjLcsn, ppjLcb, ppjLct, ppjParentPersonUid, ppjMinorPersonUid, ppjRelationship, ppjEmail, ppjPhone, ppjInactive, ppjStatus, ppjApprovalTiemstamp, ppjApprovalIpAddr) VALUES (NEW.ppjUid, NEW.ppjPcsn, NEW.ppjLcsn, NEW.ppjLcb, NEW.ppjLct, NEW.ppjParentPersonUid, NEW.ppjMinorPersonUid, NEW.ppjRelationship, NEW.ppjEmail, NEW.ppjPhone, NEW.ppjInactive, NEW.ppjStatus, NEW.ppjApprovalTiemstamp, NEW.ppjApprovalIpAddr) /*psql ON CONFLICT (ppjUid) DO UPDATE SET ppjPcsn = EXCLUDED.ppjPcsn, ppjLcsn = EXCLUDED.ppjLcsn, ppjLcb = EXCLUDED.ppjLcb, ppjLct = EXCLUDED.ppjLct, ppjParentPersonUid = EXCLUDED.ppjParentPersonUid, ppjMinorPersonUid = EXCLUDED.ppjMinorPersonUid, ppjRelationship = EXCLUDED.ppjRelationship, ppjEmail = EXCLUDED.ppjEmail, ppjPhone = EXCLUDED.ppjPhone, ppjInactive = EXCLUDED.ppjInactive, ppjStatus = EXCLUDED.ppjStatus, ppjApprovalTiemstamp = EXCLUDED.ppjApprovalTiemstamp, ppjApprovalIpAddr = EXCLUDED.ppjApprovalIpAddr */; END‚„/EEƒAviewPersonParentJoin_ReceiveViewPersonParentJoin_ReceiveViewCREATE VIEW PersonParentJoin_ReceiveView AS SELECT PersonParentJoin.*, PersonParentJoinReplicate.* FROM PersonParentJoin LEFT JOIN PersonParentJoinReplicate ON PersonParentJoinReplicate.ppjPk = PersonParentJoin.ppjUid‚F„.!-„Itriggerch_del_512PersonParentJoinCREATE TRIGGER ch_del_512 AFTER DELETE ON PersonParentJoin BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 512 AS chTableId, OLD.ppjUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 512 AND chEntityPk = OLD.ppjUid); END‚F„-!-„Itriggerch_upd_512PersonParentJoinCREATE TRIGGER ch_upd_512 AFTER UPDATE ON PersonParentJoin BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 512 AS chTableId, NEW.ppjUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 512 AND chEntityPk = NEW.ppjUid); END‚F„,!-„Itriggerch_ins_512PersonParentJoinCREATE TRIGGER ch_ins_512 AFTER INSERT ON PersonParentJoin BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 512 AS chTableId, NEW.ppjUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 512 AND chEntityPk = NEW.ppjUid); END†[„+QEŒ+triggerclazzcontentjoin_remote_insert_insClazzContentJoin_ReceiveViewCREATE TRIGGER clazzcontentjoin_remote_insert_ins INSTEAD OF INSERT ON ClazzContentJoin_ReceiveView FOR EACH ROW BEGIN REPLACE INTO ClazzContentJoin(ccjUid, ccjContentEntryUid, ccjClazzUid, ccjActive, ccjLocalChangeSeqNum, ccjMasterChangeSeqNum, ccjLastChangedBy, ccjLct) VALUES (NEW.ccjUid, NEW.ccjContentEntryUid, NEW.ccjClazzUid, NEW.ccjActive, NEW.ccjLocalChangeSeqNum, NEW.ccjMasterChangeSeqNum, NEW.ccjLastChangedBy, NEW.ccjLct) /*psql ON CONFLICT (ccjUid) DO UPDATE SET ccjContentEntryUid = EXCLUDED.ccjContentEntryUid, ccjClazzUid = EXCLUDED.ccjClazzUid, ccjActive = EXCLUDED.ccjActive, ccjLocalChangeSeqNum = EXCLUDED.ccjLocalChangeSeqNum, ccjMasterChangeSeqNum = EXCLUDED.ccjMasterChangeSeqNum, ccjLastChangedBy = EXCLUDED.ccjLastChangedBy, ccjLct = EXCLUDED.ccjLct */; END r › j*êª r Ç,F!+„Ctriggerch_upd_520ClazzAssignmentCREATE TRIGGER ch_upd_520 AFTER UPDATE ON ClazzAssignment BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 520 AS chTableId, NEW.caUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 520 AND chEntityPk = NEW.caUid); ENDˆ4„:G;qtriggererrorreport_remote_insert_insErrorReport_ReceiveViewCREATE TRIGGER errorreport_remote_insert_ins INSTEAD OF INSERT ON ErrorReport_ReceiveView FOR EACH ROW BEGIN REPLACE INTO ErrorReport(errUid, errPcsn, errLcsn, errLcb, errLct, severity, timestamp, presenterUri, appVersion, versionCode, errorCode, operatingSys, osVersion, stackTrace, message) VALUES (NEW.errUid, NEW.errPcsn, NEW.errLcsn, NEW.errLcb, NEW.errLct, NEW.severity, NEW.timestamp, NEW.presenterUri, NEW.appVersion, NEW.versionCode, NEW.errorCode, NEW.operatingSys, NEW.osVersion, NEW.stackTrace, NEW.message) /*psql ON CONFLICT (errUid) DO UPDATE SET errPcsn = EXCLUDED.errPcsn, errLcsn = EXCLUDED.errLcsn, errLcb = EXCLUDED.errLcb, errLct = EXCLUDED.errLct, severity = EXCLUDED.severity, timestamp = EXCLUDED.timestamp, presenterUri = EXCLUDED.presenterUri, appVersion = EXCLUDED.appVersion, versionCode = EXCLUDED.versionCode, errorCode = EXCLUDED.errorCode, operatingSys = EXCLUDED.operatingSys, osVersion = EXCLUDED.osVersion, stackTrace = EXCLUDED.stackTrace, message = EXCLUDED.message */; END‚<„8!#„?triggerch_del_419ErrorReportCREATE TRIGGER ch_del_419 AFTER DELETE ON ErrorReport BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 419 AS chTableId, OLD.errUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 419 AND chEntityPk = OLD.errUid); END‚<„7!#„?triggerch_upd_419ErrorReportCREATE TRIGGER ch_upd_419 AFTER UPDATE ON ErrorReport BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 419 AS chTableId, NEW.errUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 419 AND chEntityPk = NEW.errUid); END‚<„6!#„?triggerch_ins_419ErrorReportCREATE TRIGGER ch_ins_419 AFTER INSERT ON ErrorReport BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 419 AS chTableId, NEW.errUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 419 AND chEntityPk = NEW.errUid); END„-„55;‡utriggersg_remote_insert_insScopedGrant_ReceiveViewCREATE TRIGGER sg_remote_insert_ins INSTEAD OF INSERT ON ScopedGrant_ReceiveView FOR EACH ROW BEGIN REPLACE INTO ScopedGrant(sgUid, sgPcsn, sgLcsn, sgLcb, sgLct, sgTableId, sgEntityUid, sgPermissions, sgGroupUid, sgIndex, sgFlags) VALUES (NEW.sgUid, NEW.sgPcsn, NEW.sgLcsn, NEW.sgLcb, NEW.sgLct, NEW.sgTableId, NEW.sgEntityUid, NEW.sgPermissions, NEW.sgGroupUid, NEW.sgIndex, NEW.sgFlags) /*psql ON CONFLICT(sgUid) DO UPDATE SET sgLct = EXCLUDED.sgLct, sgPermissions = EXCLUDED.sgPermissions */ ; ENDn„4;;‚wviewScopedGrant_ReceiveViewScopedGrant_ReceiveViewCREATE VIEW ScopedGrant_ReceiveView AS SELECT ScopedGrant.*, ScopedGrantReplicate.* FROM ScopedGrant LEFT JOIN ScopedGrantReplicate ON ScopedGrantReplicate.sgPk = ScopedGrant.sgUid‚6„3#„5triggerch_del_48ScopedGrantCREATE TRIGGER ch_del_48 AFTER DELETE ON ScopedGrant BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 48 AS chTableId, OLD.sgUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 48 AND chEntityPk = OLD.sgUid); END‚B„;!+„Ctriggerch_ins_520ClazzAssignmentCREATE TRIGGER ch_ins_520 AFTER INSERT ON ClazzAssignment BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 520 AS chTableId, NEW.caUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 520 AND chEntityPk = NEW.caUid); ENDo„9;;‚yviewErrorReport_ReceiveViewErrorReport_ReceiveViewCREATE VIEW ErrorReport_ReceiveView AS SELECT ErrorReport.*, ErrorReportReplicate.* FROM ErrorReport LEFT JOIN ErrorReportReplicate ON ErrorReportReplicate.erPk = ErrorReport.errUid Œì Z D’ 2ŒÝYY„QviewClazzAssignmentContentJoin_ReceiveViewCl‚\„B!A„atriggerch_del_521ClazzAssignmentContentJoinCREATE TRIGGER ch_del_521 AFTER DELETE ON ClazzAssignmentContentJoin BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 521 AS chTableId, OLD.cacjUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 521 AND chEntityPk = OLD.cacjUid); END‚B„<!+„Ctriggerch_upd_520ClazzAssignmentCREATE TRIGGER ch_upd_520 AFTER UPDATE ON ClazzAssignment BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 520 AS chTableId, NEW.caUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 520 AND chEntityPk = NEW.caUid); END‚\„A!A„atriggerch_upd_521ClazzAssignmentContentJoinCREATE TRIGGER ch_upd_521 AFTER UPDATE ON ClazzAssignmentContentJoin BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 521 AS chTableId, NEW.cacjUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 521 AND chEntityPk = NEW.cacjUid); END.„?OCUtriggerclazzassignment_remote_insert_insClazzAssignment_ReceiveViewCREATE TRIGGER clazzassignment_remote_insert_ins INSTEAD OF INSERT ON ClazzAssignment_ReceiveView FOR EACH ROW BEGIN REPLACE INTO ClazzAssignment(caUid, caTitle, caDescription, caGroupUid, caActive, caClassCommentEnabled, caPrivateCommentsEnabled, caRequireFileSubmission, caFileType, caSizeLimit, caNumberOfFiles, caSubmissionPolicy, caMarkingType, caRequireTextSubmission, caTextLimitType, caTextLimit, caXObjectUid, caClazzUid, caLocalChangeSeqNum, caMasterChangeSeqNum, caLastChangedBy, caLct) VALUES (NEW.caUid, NEW.caTitle, NEW.caDescription, NEW.caGroupUid, NEW.caActive, NEW.caClassCommentEnabled, NEW.caPrivateCommentsEnabled, NEW.caRequireFileSubmission, NEW.caFileType, NEW.caSizeLimit, NEW.caNumberOfFiles, NEW.caSubmissionPolicy, NEW.caMarkingType,NEW.caRequireTextSubmission, NEW.caTextLimitType, NEW.caTextLimit, NEW.caXObjectUid, NEW.caClazzUid, NEW.caLocalChangeSeqNum, NEW.caMasterChangeSeqNum, NEW.caLastChangedBy, NEW.caLct) /*psql ON CONFLICT (caUid) DO UPDATE SET caTitle = EXCLUDED.caTitle, caDescription = EXCLUDED.caDescription, caGroupUid = EXCLUDED.caGroupUid, caActive = EXCLUDED.caActive, caClassCommentEnabled = EXCLUDED.caClassCommentEnabled, caPrivateCommentsEnabled = EXCLUDED.caPrivateCommentsEnabled, caRequireFileSubmission = EXCLUDED.caRequireFileSubmission, caFileType = EXCLUDED.caFileType, caSizeLimit = EXCLUDED.caSizeLimit, caNumberOfFiles = EXCLUDED.caNumberOfFiles, caSubmissionPolicy = EXCLUDED.caSubmissionPolicy, caMarkingType = EXCLUDED.caMarkingType, caRequireTextSubmission = EXCLUDED.caRequireTextSubmission, caTextLimitType = EXCLUDED.caTextLimitType, caTextLimit = EXCLUDED.caTextLimit, caXObjectUid = EXCLUDED.caXObjectUid, caClazzUid = EXCLUDED.caClazzUid, caLocalChangeSeqNum = EXCLUDED.caLocalChangeSeqNum, caMasterChangeSeqNum = EXCLUDED.caMasterChangeSeqNum, caLastChangedBy = EXCLUDED.caLastChangedBy, caLct = EXCLUDED.caLct */; END‚„>CCƒ/viewClazzAssignment_ReceiveViewClazzAssignment_ReceiveViewCREATE VIEW ClazzAssignment_ReceiveView AS SELECT ClazzAssignment.*, ClazzAssignmentReplicate.* FROM ClazzAssignment LEFT JOIN ClazzAssignmentReplicate ON ClazzAssignmentReplicate.caPk = ClazzAssignment.caUid‚B„=!+„Ctriggerch_del_520ClazzAssignmentCREATE TRIGGER ch_del_520 AFTER DELETE ON ClazzAssignment BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 520 AS chTableId, OLD.caUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 520 AND chEntityPk = OLD.caUid); END‚\„@!A„atriggerch_ins_521ClazzAssignmentContentJoinCREATE TRIGGER ch_ins_521 AFTER INSERT ON ClazzAssignmentContentJoin BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 521 AS chTableId, NEW.cacjUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 521 AND chEntityPk = NEW.cacjUid); END ƒ * Ìn•v‚l„JU„otriggerch_ins_90CourseAssignmentSubmissionAttachmentCREATE TRIGGER ch_ins_90 AFTER INSERT ON CourseAssignmentSubmissionAttachment BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 90 AS chTableId, NEW.casaUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 90 AND chEntityPk = NEW.casaUid); END†„IeY‹triggercourseassignmentsubmission_remote_insert_insCourseAssignmentSubmission_ReceiveViewCREATE TRIGGER courseassignmentsubmission_remote_insert_ins INSTEAD OF INSERT ON CourseAssignmentSubmission_ReceiveView FOR EACH ROW BEGIN REPLACE INTO CourseAssignmentSubmission(casUid, casAssignmentUid, casSubmitterUid, casSubmitterPersonUid, casText, casType, casTimestamp) VALUES (NEW.casUid, NEW.casAssignmentUid, NEW.casSubmitterUid, NEW.casSubmitterPersonUid, NEW.casText, NEW.casType, NEW.casTimestamp) /*psql ON CONFLICT (casUid) DO UPDATE SET casAssignmentUid = EXCLUDED.casAssignmentUid, casSubmitterUid = EXCLUDED.casSubmitterUid, casSubmitterPersonUid = EXCLUDED.casSubmitterPersonUid, casText = EXCLUDED.casText, casType = EXCLUDED.casType, casTimestamp = EXCLUDED.casTimestamp */; END‚w„HYY„MviewCourseAssignmentSubmission_ReceiveViewCourseAssignmentSubmission_ReceiveViewCREATE VIEW CourseAssignmentSubmission_ReceiveView AS SELECT CourseAssignmentSubmission.*, CourseAssignmentSubmissionReplicate.* FROM CourseAssignmentSubmission LEFT JOIN CourseAssignmentSubmissionReplicate ON CourseAssignmentSubmissionReplicate.casPk = CourseAssignmentSubmission.casUid‚Z„G!A„]triggerch_del_522CourseAssignmentSubmissionCREATE TRIGGER ch_del_522 AFTER DELETE ON CourseAssignmentSubmission BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 522 AS chTableId, OLD.casUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 522 AND chEntityPk = OLD.casUid); END‚Z„F!A„]triggerch_upd_522CourseAssignmentSubmissionCREATE TRIGGER ch_upd_522 AFTER UPDATE ON CourseAssignmentSubmission BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 522 AS chTableId, NEW.casUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 522 AND chEntityPk = NEW.casUid); END‚Z„E!A„]triggerch_ins_522CourseAssignmentSubmissionCREATE TRIGGER ch_ins_522 AFTER INSERT ON CourseAssignmentSubmission BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 522 AS chTableId, NEW.casUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 522 AND chEntityPk = NEW.casUid); END†U„DeY‹wtriggerclazzassignmentcontentjoin_remote_insert_insClazzAssignmentContentJoin_ReceiveViewCREATE TRIGGER clazzassignmentcontentjoin_remote_insert_ins INSTEAD OF INSERT ON ClazzAssignmentContentJoin_ReceiveView FOR EACH ROW BEGIN REPLACE INTO ClazzAssignmentContentJoin(cacjUid, cacjContentUid, cacjAssignmentUid, cacjActive,cacjWeight, cacjMCSN, cacjLCSN, cacjLCB, cacjLct) VALUES (NEW.cacjUid, NEW.cacjContentUid, NEW.cacjAssignmentUid, NEW.cacjActive, NEW.cacjWeight, NEW.cacjMCSN, NEW.cacjLCSN, NEW.cacjLCB, NEW.cacjLct) /*psql ON CONFLICT (cacjUid) DO UPDATE SET cacjContentUid = EXCLUDED.cacjContentUid, cacjAssignmentUid = EXCLUDED.cacjAssignmentUid, cacjActive = EXCLUDED.cacjActive, cacjWeight = EXCLUDED.cacjWeight, cacjMCSN = EXCLUDED.cacjMCSN, cacjLCSN = EXCLUDED.cacjLCSN, cacjLCB = EXCLUDED.cacjLCB, cacjLct = EXCLUDED.cacjLct */; END‚y„CYY„QviewClazzAssignmentContentJoin_ReceiveViewClazzAssignmentContentJoin_ReceiveViewCREATE VIEW ClazzAssignmentContentJoin_ReceiveView AS SELECT ClazzAssignmentContentJoin.*, ClazzAssignmentContentJoinReplicate.* FROM ClazzAssignmentContentJoin LEFT JOIN ClazzAssignmentContentJoinReplicate ON ClazzAssignmentContentJoinReplicate.cacjPk = ClazzAssignmentContentJoin.cacjUid qµ ‘ºY g µ ‚N„R!5„Qtriggerch_del_523CourseAssignmentMarkCREATE TRIGGER ch_del_523 AFTER DELETE ON CourseAssignmentMark BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 523 AS chTableId, OLD.camUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 523 AND chEntityPk = OLD.camUid); END‚N„Q!5„Qtriggerch_upd_523CourseAssignmentMarkCREATE TRIGGER ch_upd_523 AFTER UPDATE ON CourseAssignmentMark BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 523 AS chTableId, NEW.camUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 523 AND chEntityPk = NEW.camUid); END†]„Nym‹_triggercourseassignmentsubmissionattachment_remote_insert_insCourseAssignmentSubmissionAttachment_ReceiveViewCREATE TRIGGER courseassignmentsubmissionattachment_remote_insert_ins INSTEAD OF INSERT ON CourseAssignmentSubmissionAttachment_ReceiveView FOR EACH ROW BEGIN REPLACE INTO CourseAssignmentSubmissionAttachment(casaUid, casaSubmissionUid, casaMimeType,casaFileName, casaUri, casaMd5, casaSize, casaTimestamp) VALUES (NEW.casaUid, NEW.casaSubmissionUid, NEW.casaMimeType, NEW.casaFileName, NEW.casaUri, NEW.casaMd5, NEW.casaSize, NEW.casaTimestamp) /*psql ON CONFLICT (casaUid) DO UPDATE SET casaSubmissionUid = EXCLUDED.casaSubmissionUid, casaMimeType = EXCLUDED.casaMimeType, casaFileName = EXCLUDED.casaFileName, casaUri = EXCLUDED.casaUri, casaMd5 = EXCLUDED.casaMd5, casaSize = EXCLUDED.casaSize, casaTimestamp = EXCLUDED.casaTimestamp */; ENDƒS„Mmm…]viewCourseAssignmentSubmissionAttachment_ReceiveViewCourseAssignmentSubmissionAttachment_ReceiveViewCREATE VIEW CourseAssignmentSubmissionAttachment_ReceiveView AS SELECT CourseAssignmentSubmissionAttachment.*, CourseAssignmentSubmissionAttachmentReplicate.* FROM CourseAssignmentSubmissionAttachment LEFT JOIN CourseAssignmentSubmissionAttachmentReplicate ON CourseAssignmentSubmissionAttachmentReplicate.casaPk = CourseAssignmentSubmissionAttachment.casaUid‚l„LU„otriggerch_del_90CourseAssignmentSubmissionAttachmentCREATE TRIGGER ch_del_90 AFTER DELETE ON CourseAssignmentSubmissionAttachment BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 90 AS chTableId, OLD.casaUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 90 AND chEntityPk = OLD.casaUid); END‚l„KU„otriggerch_upd_90CourseAssignmentSubmissionAttachmentCREATE TRIGGER ch_upd_90 AFTER UPDATE ON CourseAssignmentSubmissionAttachment BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 90 AS chTableId, NEW.casaUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 90 AND chEntityPk = NEW.casaUid); END¤U„otriggerch_ins_90CourseAssignmentSubmissionAttachmentCREATE TRIGGER ch_ins_90 AFTER INSERT ON CourseAssignmentSubmissionAttachment BEG„S‚N„R!5„Q‚N„P!5„Qtriggerch_ins_523CourseAssignmentMarkCREATE TRIGGER ch_ins_523 AFTER INSERT ON CourseAssignmentMark BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 523 AS chTableId, NEW.camUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 523 AND chEntityPk = NEW.camUid); END…„OcUˆ}triggerATTUPD_CourseAssignmentSubmissionAttachmentCourseAssignmentSubmissionAttachmentCREATE TRIGGER ATTUPD_CourseAssignmentSubmissionAttachment AFTER UPDATE ON CourseAssignmentSubmissionAttachment FOR EACH ROW WHEN OLD.casaMd5 IS NOT NULL BEGIN INSERT INTO ZombieAttachmentData(zaUri) SELECT OLD.casaUri AS zaUri FROM CourseAssignmentSubmissionAttachment WHERE CourseAssignmentSubmissionAttachment.casaUid = OLD.casaUid AND (SELECT COUNT(*) FROM CourseAssignmentSubmissionAttachment WHERE casaMd5 = OLD.casaMd5) = 0 ; END ={ð¬h$/ z < þ À=n„];;‚wviewUserSession_ReceiveViewUserSession_ReceiveViewCREATE VIEW UserSession_ReceiveView AS SELECT UserSession.*, UserSessionReplicate.* FROM UserSession LEFT JOIN UserSessionReplicate ON UserSessionReplicate.usPk = UserSession.usUidq„X;;‚}viewPersonAuth2_ReceiveViewPersonAuth2_ReceiveViewCREATE VIEW PersonAuth2_ReceiveView AS SELECT PersonAuth2.*, PersonAuth2Replicate.* FROM PersonAuth2 LEFT JOIN PersonAuth2Replicate ON PersonAuth2Replicate.paPk = PersonAuth2.pauthUid‚@„W!#„Gtriggerch_del_678PersonAuth2CREATE TRIGGER ch_del_678 AFTER DELETE ON PersonAuth2 BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 678 AS chTableId, OLD.pauthUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 678 AND chEntityPk = OLD.pauthUid); END‚@„V!#„Gtriggerch_upd_678PersonAuth2CREATE TRIGGER ch_upd_678 AFTER UPDATE ON PersonAuth2 BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 678 AS chTableId, NEW.pauthUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 678 AND chEntityPk = NEW.pauthUid); END‚@„U!#„Gtriggerch_ins_678PersonAuth2CREATE TRIGGER ch_ins_678 AFTER INSERT ON PersonAuth2 BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 678 AS chTableId, NEW.pauthUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 678 AND chEntityPk = NEW.pauthUid); END…„TYMˆstriggercourseassignmentmark_remote_insert_insCourseAssignmentMark_ReceiveViewCREATE TRIGGER courseassignmentmark_remote_insert_ins INSTEAD OF INSERT ON CourseAssignmentMark_ReceiveView FOR EACH ROW BEGIN REPLACE INTO CourseAssignmentMark(camUid, camAssignmentUid, camSubmitterUid, camMark, camPenalty, camLct) VALUES (NEW.camUid, NEW.camAssignmentUid, NEW.camSubmitterUid, NEW.camMark, NEW.camPenalty, NEW.camLct) /*psql ON CONFLICT (camUid) DO UPDATE SET camAssignmentUid = EXCLUDED.camAssignmentUid, camSubmitterUid = EXCLUDED.camSubmitterUid, camMark = EXCLUDED.camMark, camPenalty = EXCLUDED.camPenalty, camLct = EXCLUDED.camLct */; END‚A„SMMƒyviewCourseAssignmentMark_ReceiveViewCourseAssignmentMark_ReceiveViewCREATE VIEW CourseAssignmentMark_ReceiveView AS SELECT CourseAssignmentMark.*, CourseAssignmentMarkReplicate.* FROM CourseAssignmentMark LEFT JOIN CourseAssignmentMarkReplicate ON CourseAssignmentMarkReplicate.camPk = CourseAssignmentMark.camUid‚:„\!#„;triggerch_del_679UserSessionCREATE TRIGGER ch_del_679 AFTER DELETE ON UserSession BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 679 AS chTableId, OLD.usUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 679 AND chEntityPk = OLD.usUid); END‚:„[!#„;triggerch_upd_679UserSessionCREATE TRIGGER ch_upd_679 AFTER UPDATE ON UserSession BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 679 AS chTableId, NEW.usUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 679 AND chEntityPk = NEW.usUid); END‚:„Z!#„;triggerch_ins_679UserSessionCREATE TRIGGER ch_ins_679 AFTER INSERT ON UserSession BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 679 AS chTableId, NEW.usUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 679 AND chEntityPk = NEW.usUid); END…„YG;‰ triggerpersonauth2_remote_insert_insPersonAuth2_ReceiveViewCREATE TRIGGER personauth2_remote_insert_ins INSTEAD OF INSERT ON PersonAuth2_ReceiveView FOR EACH ROW BEGIN REPLACE INTO PersonAuth2(pauthUid, pauthMechanism, pauthAuth, pauthLcsn, pauthPcsn, pauthLcb, pauthLct) VALUES (NEW.pauthUid, NEW.pauthMechanism, NEW.pauthAuth, NEW.pauthLcsn, NEW.pauthPcsn, NEW.pauthLcb, NEW.pauthLct) /*psql ON CONFLICT (pauthUid) DO UPDATE SET pauthMechanism = EXCLUDED.pauthMechanism, pauthAuth = EXCLUDED.pauthAuth, pauthLcsn = EXCLUDED.pauthLcsn, pauthPcsn = EXCLUDED.pauthPcsn, pauthLcb = EXCLUDED.pauthLcb, pauthLct = EXCLUDED.pauthLct */; END ‘ K Ï‘Ÿ‘GJ!/„Gtriggerch_ins_450CourseTerminologyCREATE TRIGGER ch_ins_450 AFTER INSERT ON CourseTerminology BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 450 AS chTableId, NEW.ctUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 450 AND chEntityPk = NEW.ctUid); ENDŒ „cG;—triggercourseblock_remote_insert_insCourseBlock_ReceiveViewCREATE TRIGGER courseblock_remote_insert_ins INSTEAD OF INSERT ON CourseBlock_ReceiveView FOR EACH ROW BEGIN REPLACE INTO CourseBlock(cbUid, cbType, cbIndentLevel, cbModuleParentBlockUid, cbTitle, cbDescription, cbCompletionCriteria, cbHideUntilDate, cbDeadlineDate, cbLateSubmissionPenalty, cbGracePeriodDate, cbMaxPoints,cbMinPoints, cbIndex, cbClazzUid, cbActive,cbHidden, cbEntityUid, cbLct) VALUES (NEW.cbUid, NEW.cbType, NEW.cbIndentLevel, NEW.cbModuleParentBlockUid, NEW.cbTitle, NEW.cbDescription, NEW.cbCompletionCriteria, NEW.cbHideUntilDate, NEW.cbDeadlineDate, NEW.cbLateSubmissionPenalty, NEW.cbGracePeriodDate, NEW.cbMaxPoints,NEW.cbMinPoints, NEW.cbIndex, NEW.cbClazzUid,NEW.cbActive, NEW.cbHidden, NEW.cbEntityUid, NEW.cbLct) /*psql ON CONFLICT (cbUid) DO UPDATE SET cbType = EXCLUDED.cbType, cbIndentLevel = EXCLUDED.cbIndentLevel, cbModuleParentBlockUid = EXCLUDED.cbModuleParentBlockUid, cbTitle = EXCLUDED.cbTitle, cbDescription = EXCLUDED.cbDescription, cbCompletionCriteria = EXCLUDED.cbCompletionCriteria, cbHideUntilDate = EXCLUDED.cbHideUntilDate,cbDeadlineDate = EXCLUDED.cbDeadlineDate, cbLateSubmissionPenalty = EXCLUDED.cbLateSubmissionPenalty, cbGracePeriodDate= EXCLUDED.cbGracePeriodDate, cbMaxPoints = EXCLUDED.cbMaxPoints, cbMinPoints = EXCLUDED.cbMinPoints, cbIndex = EXCLUDED.cbIndex,cbClazzUid = EXCLUDED.cbClazzUid, cbActive = EXCLUDED.cbActive, cbHidden = EXCLUDED.cbHidden, cbEntityUid = EXCLUDED.cbEntityUid, cbLct = EXCLUDED.cbLct */; ENDn„b;;‚wviewCourseBlock_ReceiveViewCourseBlock_ReceiveViewCREATE VIEW CourseBlock_ReceiveView AS SELECT CourseBlock.*, CourseBlockReplicate.* FROM CourseBlock LEFT JOIN CourseBlockReplicate ON CourseBlockReplicate.cbPk = CourseBlock.cbUid‚:„a!#„;triggerch_del_124CourseBlockCREATE TRIGGER ch_del_124 AFTER DELETE ON CourseBlock BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 124 AS chTableId, OLD.cbUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 124 AND chEntityPk = OLD.cbUid); END‚:„`!#„;triggerch_upd_124CourseBlockCREATE TRIGGER ch_upd_124 AFTER UPDATE ON CourseBlock BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 124 AS chTableId, NEW.cbUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 124 AND chEntityPk = NEW.cbUid); END‚:„_!#„;triggerch_ins_124CourseBlockCREATE TRIGGER ch_ins_124 AFTER INSERT ON CourseBlock BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 124 AS chTableId, NEW.cbUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 124 AND chEntityPk = NEW.cbUid); END‡1„^G;ktriggerusersession_remote_insert_insUserSession_ReceiveViewCREATE TRIGGER usersession_remote_insert_ins INSTEAD OF INSERT ON UserSession_ReceiveView FOR EACH ROW BEGIN REPLACE INTO UserSession(usUid, usPcsn, usLcsn, usLcb, usLct, usPersonUid, usClientNodeId, usStartTime, usEndTime, usStatus, usReason, usAuth, usSessionType) VALUES (NEW.usUid, NEW.usPcsn, NEW.usLcsn, NEW.usLcb, NEW.usLct, NEW.usPersonUid, NEW.usClientNodeId, NEW.usStartTime, NEW.usEndTime, NEW.usStatus, NEW.usReason, NEW.usAuth, NEW.usSessionType) /*psql ON CONFLICT (usUid) DO UPDATE SET usPcsn = EXCLUDED.usPcsn, usLcsn = EXCLUDED.usLcsn, usLcb = EXCLUDED.usLcb, usLct = EXCLUDED.usLct, usPersonUid = EXCLUDED.usPersonUid, usClientNodeId = EXCLUDED.usClientNodeId, usStartTime = EXCLUDED.usStartTime, usEndTime = EXCLUDED.usEndTime, usStatus = EXCLUDED.usStatus, usReason = EXCLUDED.usReason, usAuth = EXCLUDED.usAuth, usSessionType = EXCLUDED.usSessionType */; END ïï¶ l D k %ß™Š9¡˜!/„Ktriggerch_upd_243CourseGroupMemberCREATE TRIGGER ch_upd_243 AFTER UPDATE ON CourseGroupMember BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 243 AS chTableId, NEW.cgmUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 243 AND chEntityPk = NEW.cgmUid); END‚H‚F„d!/„Gtriggerch_ins_450CourseTerminologyCREATE TRIGGER ch_ins_450 AFTER INSERT ON CourseTerminology BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 450 AS chTableId, NEW.ctUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 450 AND chEntityPk = NEW.ctUid); END„M„mMAˆtriggercoursegroupset_remote_insert_insCourseGroupSet_ReceiveViewCREATE TRIGGER coursegroupset_remote_insert_ins INSTEAD OF INSERT ON CourseGroupSet_ReceiveView FOR EACH ROW BEGIN REPLACE INTO CourseGroupSet(cgsUid, cgsName, cgsTotalGroups, cgsActive, cgsClazzUid, cgsLct) VALUES (NEW.cgsUid, NEW.cgsName, NEW.cgsTotalGroups, NEW.cgsActive, NEW.cgsClazzUid, NEW.cgsLct) /*psql ON CONFLICT (cgsUid) DO UPDATE SET cgsName = EXCLUDED.cgsName, cgsTotalGroups = EXCLUDED.cgsTotalGroups, cgsActive = EXCLUDED.cgsActive, cgsClazzUid = EXCLUDED.cgsClazzUid, cgsLct = EXCLUDED.cgsLct */; END‚ „lAAƒ%viewCourseGroupSet_ReceiveViewCourseGroupSet_ReceiveViewCREATE VIEW CourseGroupSet_ReceiveView AS SELECT CourseGroupSet.*, CourseGroupSetReplicate.* FROM CourseGroupSet LEFT JOIN CourseGroupSetReplicate ON CourseGroupSetReplicate.cgsPk = CourseGroupSet.cgsUid‚B„k!)„Etriggerch_del_242CourseGroupSetCREATE TRIGGER ch_del_242 AFTER DELETE ON CourseGroupSet BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 242 AS chTableId, OLD.cgsUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 242 AND chEntityPk = OLD.cgsUid); END‚B„j!)„Etriggerch_upd_242CourseGroupSetCREATE TRIGGER ch_upd_242 AFTER UPDATE ON CourseGroupSet BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 242 AS chTableId, NEW.cgsUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 242 AND chEntityPk = NEW.cgsUid); END‚B„i!)„Etriggerch_ins_242CourseGroupSetCREATE TRIGGER ch_ins_242 AFTER INSERT ON CourseGroupSet BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 242 AS chTableId, NEW.cgsUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 242 AND chEntityPk = NEW.cgsUid); ENDƒU„hSG†triggercourseterminology_remote_insert_insCourseTerminology_ReceiveViewCREATE TRIGGER courseterminology_remote_insert_ins INSTEAD OF INSERT ON CourseTerminology_ReceiveView FOR EACH ROW BEGIN REPLACE INTO CourseTerminology(ctUid, ctTitle, ctTerminology, ctLct) VALUES (NEW.ctUid, NEW.ctTitle, NEW.ctTerminology, NEW.ctLct) /*psql ON CONFLICT (ctUid) DO UPDATE SET ctTitle = EXCLUDED.ctTitle, ctTerminology = EXCLUDED.ctTerminology, ctLct = EXCLUDED.ctLct */; END‚$„gGGƒKviewCourseTerminology_ReceiveViewCourseTerminology_ReceiveViewCREATE VIEW CourseTerminology_ReceiveView AS SELECT CourseTerminology.*, CourseTerminologyReplicate.* FROM CourseTerminology LEFT JOIN CourseTerminologyReplicate ON CourseTerminologyReplicate.ctPk = CourseTerminology.ctUid‚F„f!/„Gtriggerch_del_450CourseTerminologyCREATE TRIGGER ch_del_450 AFTER DELETE ON CourseTerminology BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 450 AS chTableId, OLD.ctUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 450 AND chEntityPk = OLD.ctUid); END‚F„e!/„Gtriggerch_upd_450CourseTerminologyCREATE TRIGGER ch_upd_450 AFTER UPDATE ON CourseTerminology BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 450 AS chTableId, NEW.ctUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 450 AND chEntityPk = NEW.ctUid); END  I´ h¼’`°XI‚ „v??ƒ)viewCoursePicture_ReceiveViewCoursePicture_ReceiveViewCREATE VIEW CoursePicture_ReceiveView AS SELECT CoursePicture.*, CoursePictureReplicate.* FROM CoursePicture LEFT JOIN CoursePictureReplicate ON CoursePictureReplicate.cpPk = CoursePicture.coursePictureUid‚T„u!'„ktriggerch_del_125CoursePictureCREATE TRIGGER ch_del_125 AFTER DELETE ON CoursePicture BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 125 AS chTableId, OLD.coursePictureUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 125 AND chEntityPk = OLD.coursePictureUid); END‚T„t!'„ktriggerch_upd_125CoursePictureCREATE TRIGGER ch_upd_125 AFTER UPDATE ON CoursePicture BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 125 AS chTableId, NEW.coursePictureUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 125 AND chEntityPk = NEW.coursePictureUid); END‚T„s!'„ktriggerch_ins_125CoursePictureCREATE TRIGGER ch_ins_125 AFTER INSERT ON CoursePicture BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 125 AS chTableId, NEW.coursePictureUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 125 AND chEntityPk = NEW.coursePictureUid); END„.„rSG‡Mtriggercoursegroupmember_remote_insert_insCourseGroupMember_ReceiveViewCREATE TRIGGER coursegroupmember_remote_insert_ins INSTEAD OF INSERT ON CourseGroupMember_ReceiveView FOR EACH ROW BEGIN REPLACE INTO CourseGroupMember(cgmUid, cgmSetUid, cgmGroupNumber, cgmPersonUid, cgmLct) VALUES (NEW.cgmUid, NEW.cgmSetUid, NEW.cgmGroupNumber, NEW.cgmPersonUid, NEW.cgmLct) /*psql ON CONFLICT (cgmUid) DO UPDATE SET cgmSetUid = EXCLUDED.cgmSetUid, cgmGroupNumber = EXCLUDED.cgmGroupNumber, cgmPersonUid = EXCLUDED.cgmPersonUid, cgmLct = EXCLUDED.cgmLct */; END‚&„qGGƒOviewCourseGroupMember_ReceiveViewCourseGroupMember_ReceiveViewCREATE VIEW CourseGroupMember_ReceiveView AS SELECT CourseGroupMember.*, CourseGroupMemberReplicate.* FROM CourseGroupMember LEFT JOIN CourseGroupMemberReplicate ON CourseGroupMemberReplicate.cgmPk = CourseGroupMember.cgmUid‚H„p!/„Ktriggerch_del_243CourseGroupMemberCREATE TRIGGER ch_del_243 AFTER DELETE ON CourseGroupMember BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 243 AS chTableId, OLD.cgmUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 243 AND chEntityPk = OLD.cgmUid); END`!/„Ktriggerch_upd_243CourseGroupMemberCREATE TRIGGER ch_upd_243 AFTER UPDAT‹"„wK?•Etriggercoursepicture_remote_insert_insCoursePicture_ReceiveViewCREATE TRIGGER coursepicture_remote_insert_ins INSTEAD OF INSERT ON CoursePicture_ReceiveView FOR EACH ROW BEGIN REPLACE INTO CoursePicture(coursePictureUid, coursePictureClazzUid, coursePictureMasterCsn, coursePictureLocalCsn, coursePictureLastChangedBy, coursePictureLct, coursePictureUri, coursePictureMd5, coursePictureFileSize, coursePictureTimestamp, coursePictureMimeType, coursePictureActive) VALUES (NEW.coursePictureUid, NEW.coursePictureClazzUid, NEW.coursePictureMasterCsn, NEW.coursePictureLocalCsn, NEW.coursePictureLastChangedBy, NEW.coursePictureLct, NEW.coursePictureUri, NEW.coursePictureMd5, NEW.coursePictureFileSize, NEW.coursePictureTimestamp, NEW.coursePictureMimeType, NEW.coursePictu‚H„o!/„Ktriggerch_upd_243CourseGroupMemberCREATE TRIGGER ch_upd_243 AFTER UPDATE ON CourseGroupMember BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 243 AS chTableId, NEW.cgmUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 243 AND chEntityPk = NEW.cgmUid); END‚H„n!/„Ktriggerch_ins_243CourseGroupMemberCREATE TRIGGER ch_ins_243 AFTER INSERT ON CourseGroupMember BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 243 AS chTableId, NEW.cgmUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 243 AND chEntityPk = NEW.cgmUid); END  Z,ÜŒ<‚8„|KKƒkviewContentEntryPicture_ReceiveViewContentEntryPicture_ReceiveViewCREATE VIEW ContentEntryPicture_ReceiveView AS SELECT ContentEntryPicture.*, ContentEntryPictureReplicate.* FROM ContentEntryPicture LEFT JOIN ContentEntryPictureReplicate ON ContentEntryPictureReplicate.cepPk = ContentEntryPicture.cepUid‚L„{!3„Otriggerch_del_138ContentEntryPictureCREATE TRIGGER ch_del_138 AFTER DELETE ON ContentEntryPicture BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 138 AS chTableId, OLD.cepUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 138 AND chEntityPk = OLD.cepUid); END‚L„z!3„Otriggerch_upd_138ContentEntryPictureCREATE TRIGGER ch_upd_138 AFTER UPDATE ON ContentEntryPicture BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 138 AS chTableId, NEW.cepUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 138 AND chEntityPk = NEW.cepUid); END‚L„y!3„Otriggerch_ins_138ContentEntryPictureCREATE TRIGGER ch_ins_138 AFTER INSERT ON ContentEntryPicture BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 138 AS chTableId, NEW.cepUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 138 AND chEntityPk = NEW.cepUid); END„*„x5'ˆtriggerATTUPD_CoursePictureCoursePictureCREATE TRIGGER ATTUPD_CoursePicture AFTER UPDATE ON CoursePicture FOR EACH ROW WHEN OLD.coursePictureMd5 IS NOT NULL BEGIN INSERT INTO ZombieAttachmentData(zaUri) SELECT OLD.coursePictureUri AS zaUri FROM CoursePicture WHERE CoursePicture.coursePictureUid = OLD.coursePictureUid AND (SELECT COUNT(*) FROM CoursePicture WHERE coursePictureMd5 = OLD.coursePictureMd5) = 0 ; END‹"„wK?•Etriggercoursepicture_remote_insert_insCoursePicture_ReceiveViewCREATE TRIGGER coursepicture_remote_insert_ins INSTEAD OF INSERT ON CoursePicture_ReceiveView FOR EACH ROW BEGIN REPLACE INTO CoursePicture(coursePictureUid, coursePictureClazzUid, coursePictureMasterCsn, coursePictureLocalCsn, coursePictureLastChangedBy, coursePictureLct, coursePictureUri, coursePictureMd5, coursePictureFileSize, coursePictureTimestamp, coursePictureMimeType, coursePictureActive) VALUES (NEW.coursePictureUid, NEW.coursePictureClazzUid, NEW.coursePictureMasterCsn, NEW.coursePictureLocalCsn, NEW.coursePictureLastChangedBy, NEW.coursePictureLct, NEW.coursePictureUri, NEW.coursePictureMd5, NEW.coursePictureFileSize, NEW.coursePictureTimestamp, NEW.coursePictureMimeType, NEW.coursePictureActive) /*psql ON CONFLICT (coursePictureUid) DO UPDATE SET coursePictureClazzUid = EXCLUDED.coursePictureClazzUid, coursePictureMasterCsn = EXCLUDED.coursePictureMasterCsn, coursePictureLocalCsn = EXCLUDED.coursePictureLocalCsn, coursePictureLastChangedBy = EXCLUDED.coursePictureLastChangedBy, coursePictureLct = EXCLUDED.coursePictureLct, coursePictureUri = EXCLUDED.coursePictureUri, coursePictureMd5 = EXCLUDED.coursePictureMd5, coursePictureFileSize = EXCLUDED.coursePictureFileSize, coursePictureTimestamp = EXCLUDED.coursePictureTimestamp, coursePictureMimeType = EXCLUDED.coursePictureMimeType, coursePictureActive = EXCLUDED.coursePictureActive */; END h D |`,øÄIÜ ýDЂH…!!„Ytriggerch_del_128ChatMemberCREATE TRIGGER ch_del_128 AFTER DELETE ON ChatMember BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 128 AS chTableId, OLD.chatMemberUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 128 AND chEntityPk = OLD.chatMemberUid); END‚H…!!„Ytriggerch_upd_128ChatMemberCREATE TRIGGER ch_upd_128 AFTER UPDATE ON ChatMember BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 128 AS chTableId, NEW.chatMemberUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 128 AND chEntityPk = NEW.chatMemberUid); ENDƒd…9-†mtriggerchat_remote_insert_insChat_ReceiveViewCREATE TRIGGER chat_remote_insert_ins INSTEAD OF INSERT ON Chat_ReceiveView FOR EACH ROW BEGIN REPLACE INTO Chat(chatUid, chatStartDate, chatTitle, chatGroup, chatLct) VALUES(NEW.chatUid, NEW.chatStartDate, NEW.chatTitle, NEW.chatGroup, NEW.chatLct) /*psql ON CONFLICT (chatUid) DO UPDATE SET chatStartDate = EXCLUDED.chatStartDate, chatTitle = EXCLUDED.chatTitle, chatGroup = EXCLUDED.chatGroup, chatLct = EXCLUDED.chatLct */ ; END‚0…!„5triggerch_del_127ChatCREATE TRIGGER ch_del_127 AFTER DELETE ON Chat BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 127 AS chTableId, OLD.chatUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 127 AND chEntityPk = OLD.chatUid); END‚0…!„5triggerch_upd_127ChatCREATE TRIGGER ch_upd_127 AFTER UPDATE ON Chat BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 127 AS chTableId, NEW.chatUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 127 AND chEntityPk = NEW.chatUid); END‚0„!„5triggerch_ins_127ChatCREATE TRIGGER ch_ins_127 AFTER INSERT ON Chat BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 127 AS chTableId, NEW.chatUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 127 AND chEntityPk = NEW.chatUid); END„„~A3‡GtriggerATTUPD_ContentEntryPictureContentEntryPictureCREATE TRIGGER ATTUPD_ContentEntryPicture AFTER UPDATE ON ContentEntryPicture FOR EACH ROW WHEN OLD.cepMd5 IS NOT NULL BEGIN INSERT INTO ZombieAttachmentData(zaUri) SELECT OLD.cepUri AS zaUri FROM ContentEntryPicture WHERE ContentEntryPicture.cepUid = OLD.cepUid AND (SELECT COUNT(*) FROM ContentEntryPicture WHERE cepMd5 = OLD.cepMd5) = 0 ; END…h„}EKŠKtriggerceppicture_remote_insert_insContentEntryPicture_ReceiveViewCREATE TRIGGER ceppicture_remote_insert_ins INSTEAD OF INSERT ON ContentEntryPicture_ReceiveView FOR EACH ROW BEGIN REPLACE INTO ContentEntryPicture(cepUid, cepContentEntryUid, cepUri, cepMd5, cepFileSize, cepTimestamp, cepMimeType, cepActive) VALUES (NEW.cepUid, NEW.cepContentEntryUid, NEW.cepUri, NEW.cepMd5, NEW.cepFileSize, NEW.cepTimestamp, NEW.cepMimeType, NEW.cepActive) /*psql ON CONFLICT (cepUid) DO UPDATE SET cepContentEntryUid = EXCLUDED.cepContentEntryUid, cepUri = EXCLUDED.cepUri, cepMd5 = EXCLUDED.cepMd5, cepFileSize = EXCLUDED.cepFileSize, cepTimestamp = EXCLUDED.cepTimestamp, cepMimeType = EXCLUDED.cepMimeType, cepActive = EXCLUDED.cepActive */; END•!!„Ytriggerch_upd_128ChatMemberCREATE TRIGGER ch_upd_128 AFTER UPDATE ON ChatMember BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType)‚H…!!„Ytriggerch_ins_128ChatMemberCREATE TRIGGER ch_ins_128 AFTER INSERT ON ChatMember BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 128 AS chTableId, NEW.chatMemberUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 128 AND chEntityPk = NEW.chatMemberUid); END3…--‚viewChat_ReceiveViewChat_ReceiveViewCREATE VIEW Chat_ReceiveView AS SELECT Chat.*, ChatReplicate.* FROM Chat LEFT JOIN ChatReplicate ON ChatReplicate.chatPk = Chat.chatUid “  Õ •U}3ã“C: P!#„_triggerch_del_129MessageReadCREATE TRIGGER ch_del_129 AFTER DELETE ON MessageRead BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 129 AS chTableId, OLD.messageReadUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 129 AND chEntityPk = OLD.messageReadUid); END‚L…!#„_triggerch_upd_129MessageReadCREATE TRIGGER ch_upd_129 AFTER UPDATE ON MessageRead BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 129 AS chTableId, NEW.messageReadUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 129 AND chEntityPk = NEW.messageReadUid); END‚L…!#„_triggerch_ins_129MessageReadCREATE TRIGGER ch_ins_129 AFTER INSERT ON MessageRead BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 129 AS chTableId, NEW.messageReadUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 129 AND chEntityPk = NEW.messageReadUid); END†F… ?3Œ%triggermessage_remote_insert_insMessage_ReceiveViewCREATE TRIGGER message_remote_insert_ins INSTEAD OF INSERT ON Message_ReceiveView FOR EACH ROW BEGIN REPLACE INTO Message(messageUid, messageSenderPersonUid, messageTableId, messageEntityUid, messageText, messageTimestamp, messageClazzUid, messageLct) VALUES(NEW.messageUid, NEW.messageSenderPersonUid, NEW.messageTableId, NEW.messageEntityUid, NEW.messageText, NEW.messageTimestamp, NEW.messageClazzUid, NEW.messageLct) /*psql ON CONFLICT (messageUid) DO UPDATE SET messageSenderPersonUid = EXCLUDED.messageSenderPersonUid, messageTableId = EXCLUDED.messageTableId, messageEntityUid = EXCLUDED.messageEntityUid, messageText = EXCLUDED.messageText, messageTimestamp = EXCLUDED.messageTimestamp, messageClazzUid = EXCLUDED.messageClazzUid, messageLct = EXCLUDED.messageLct */ ; ENDT… 33‚SviewMessage_ReceiveViewMessage_ReceiveViewCREATE VIEW Message_ReceiveView AS SELECT Message.*, MessageReplicate.* FROM Message LEFT JOIN MessageReplicate ON MessageReplicate.messagePk = Message.messageUid‚<… !„Gtriggerch_del_126MessageCREATE TRIGGER ch_del_126 AFTER DELETE ON Message BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 126 AS chTableId, OLD.messageUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 126 AND chEntityPk = OLD.messageUid); END‚<… !„Gtriggerch_upd_126MessageCREATE TRIGGER ch_upd_126 AFTER UPDATE ON Message BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 126 AS chTableId, NEW.messageUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 126 AND chEntityPk = NEW.messageUid); END‚<… !„Gtriggerch_ins_126MessageCREATE TRIGGER ch_ins_126 AFTER INSERT ON Message BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 126 AS chTableId, NEW.messageUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 126 AND chEntityPk = NEW.messageUid); END…n…E9Šitriggerchatmember_remote_insert_insChatMember_ReceiveViewCREATE TRIGGER chatmember_remote_insert_ins INSTEAD OF INSERT ON ChatMember_ReceiveView FOR EACH ROW BEGIN REPLACE INTO ChatMember(chatMemberUid, chatMemberChatUid, chatMemberPersonUid, chatMemberJoinedDate, chatMemberLeftDate, chatMemberLct) VALUES(NEW.chatMemberUid, NEW.chatMemberChatUid, NEW.chatMemberPersonUid, NEW.chatMemberJoinedDate, NEW.chatMemberLeftDate, NEW.chatMemberLct) /*psql ON CONFLICT (chatMemberUid) DO UPDATE SET chatMemberChatUid = EXCLUDED.chatMemberChatUid, chatMemberPersonUid = EXCLUDED.chatMemberPersonUid, chatMemberJoinedDate = EXCLUDED.chatMemberJoinedDate, chatMemberLeftDate = EXCLUDED.chatMemberLeftDate, chatMemberLct = EXCLUDED.chatMemberLct */ ; ENDu…99ƒ viewChatMember_ReceiveViewChatMember_ReceiveViewCREATE VIEW ChatMember_ReceiveView AS SELECT ChatMember.*, ChatMemberReplicate.* FROM ChatMember LEFT JOIN ChatMemberReplicate ON ChatMemberReplicate.chatMemberPk = ChatMember.chatMemberUid e u a ­Iåų eÎ!+„wtriggerch_upd_131DiscussionTopicCREATE TRIGGER ch_upd_131 AFTER UPDATE ON DiscussionTopic BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 131 AS chTableId, NEW.discussionTopicUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 131 AND chEntityPk = NEW.discussionTopicUid); END†j…QEŒItriggercoursediscussion_remote_insert_insCourseDiscussion_ReceiveViewCREATE TRIGGER coursediscussion_remote_insert_ins INSTEAD OF INSERT ON CourseDiscussion_ReceiveView FOR EACH ROW BEGIN REPLACE INTO CourseDiscussion(courseDiscussionUid, courseDiscussionActive, courseDiscussionTitle, courseDiscussionDesc, courseDiscussionClazzUid, courseDiscussionLct) VALUES(NEW.courseDiscussionUid, NEW.courseDiscussionActive, NEW.courseDiscussionTitle, NEW.courseDiscussionDesc, NEW.courseDiscussionClazzUid, NEW.courseDiscussionLct) /*psql ON CONFLICT (courseDiscussionUid) DO UPDATE SET courseDiscussionActive = EXCLUDED.courseDiscussionActive, courseDiscussionTitle = EXCLUDED.courseDiscussionTitle, courseDiscussionDesc = EXCLUDED.courseDiscussionDesc, courseDiscussionClazzUid = EXCLUDED.courseDiscussionClazzUid, courseDiscussionLct = EXCLUDED.courseDiscussionLct */ ; END‚`…!-„}triggerch_del_130CourseDiscussionCREATE TRIGGER ch_del_130 AFTER DELETE ON CourseDiscussion BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 130 AS chTableId, OLD.courseDiscussionUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 130 AND chEntityPk = OLD.courseDiscussionUid); END‚`…!-„}triggerch_upd_130CourseDiscussionCREATE TRIGGER ch_upd_130 AFTER UPDATE ON CourseDiscussion BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 130 AS chTableId, NEW.courseDiscussionUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 130 AND chEntityPk = NEW.courseDiscussionUid); END‚`…!-„}triggerch_ins_130CourseDiscussionCREATE TRIGGER ch_ins_130 AFTER INSERT ON CourseDiscussion BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 130 AS chTableId, NEW.courseDiscussionUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 130 AND chEntityPk = NEW.courseDiscussionUid); END…0…G;‰itriggermessageread_remote_insert_insMessageRead_ReceiveViewCREATE TRIGGER messageread_remote_insert_ins INSTEAD OF INSERT ON MessageRead_ReceiveView FOR EACH ROW BEGIN REPLACE INTO MessageRead(messageReadUid, messageReadPersonUid, messageReadMessageUid, messageReadEntityUid, messageReadLct) VALUES(NEW.messageReadUid, NEW.messageReadPersonUid, NEW.messageReadMessageUid, NEW.messageReadEntityUid, NEW.messageReadLct) /*psql ON CONFLICT (messageReadUid) DO UPDATE SET messageReadPersonUid = EXCLUDED.messageReadPersonUid, messageReadMessageUid = EXCLUDED.messageReadMessageUid, messageReadEntityUid = EXCLUDED.messageReadEntityUid, messageReadLct = EXCLUDED.messageReadLct */ ; END‚…;;ƒviewMessageRead_ReceiveViewMessageRead_ReceiveViewCREATE VIEW MessageRead_ReceiveView AS SELECT MessageRead.*, MessageReadReplicate.* FROM MessageRead LEFT JOIN MessageReadReplicate ON MessageReadReplicate.messageReadPk = MessageRead.messageReadUid!+„wtrigg‚L…!#„_triggerch_del_129MessageReadCREATE TRIGGER ch_del_129 AFTER DELETE ON MessageRead BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 129 AS chTableId, OLD.messageReadUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 129 AND chEntityPk = OLD.messageReadUid); END‚7…EEƒuviewCourseDiscussion_ReceiveViewCourseDiscussion_ReceiveViewCREATE VIEW CourseDiscussion_ReceiveView AS SELECT CourseDiscussion.*, CourseDiscussionReplicate.* FROM CourseDiscussion LEFT JOIN CourseDiscussionReplicate ON CourseDiscussionReplicate.courseDiscussionPk = CourseDiscussion.courseDiscussionUid 2¨  ÒrB¨ H #‚X…!)„qtriggerch_ins_132DiscussionPostCREATE TRIGGER ch_ins_132 AFTER INSERT ON DiscussionPost BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 132 AS chTableId, NEW.discussionPostUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 132 AND chEntityPk = NEW.discussionPostUid); ENDŠ:…OC“mtriggerdiscussiontopic_remote_insert_insDiscussionTopic_ReceiveViewCREATE TRIGGER discussiontopic_remote_insert_ins INSTEAD OF INSERT ON DiscussionTopic_ReceiveView FOR EACH ROW BEGIN REPLACE INTO DiscussionTopic(discussionTopicUid, discussionTopicTitle, discussionTopicDesc, discussionTopicStartDate, discussionTopicCourseDiscussionUid, discussionTopicVisible, discussionTopicArchive, discussionTopicIndex, discussionTopicClazzUid, discussionTopicLct) VALUES(NEW.discussionTopicUid, NEW.discussionTopicTitle, NEW.discussionTopicDesc, NEW.discussionTopicStartDate, NEW.discussionTopicCourseDiscussionUid, NEW.discussionTopicVisible, NEW.discussionTopicArchive, NEW.discussionTopicIndex, NEW.discussionTopicClazzUid, NEW.discussionTopicLct) /*psql ON CONFLICT (discussionTopicUid) DO UPDATE SET discussionTopicTitle = EXCLUDED.discussionTopicTitle, discussionTopicDesc = EXCLUDED.discussionTopicDesc, discussionTopicStartDate = EXCLUDED.discussionTopicStartDate, discussionTopicCourseDiscussionUid = EXCLUDED.discussionTopicCourseDiscussionUid, discussionTopicVisible = EXCLUDED.discussionTopicVisible, discussionTopicArchive = EXCLUDED.discussionTopicArchive, discussionTopicIndex = EXCLUDED.discussionTopicIndex, discussionTopicClazzUid = EXCLUDED.discussionTopicClazzUid, discussionTopicLct = EXCLUDED.discussionTopicLct */ ; END‚,…CCƒcviewDiscussionTopic_ReceiveViewDiscussionTopic_ReceiveViewCREATE VIEW DiscussionTopic_ReceiveView AS SELECT DiscussionTopic.*, DiscussionTopicReplicate.* FROM DiscussionTopic LEFT JOIN DiscussionTopicReplicate ON DiscussionTopicReplicate.discussionTopicPk = DiscussionTopic.discussionTopicUid‚\…!+„wtriggerch_del_131DiscussionTopicCREATE TRIGGER ch_del_131 AFTER DELETE ON DiscussionTopic BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 131 AS chTableId, OLD.discussionTopicUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 131 AND chEntityPk = OLD.discussionTopicUid); END‚\…!+„wtriggerch_upd_131DiscussionTopicCREATE TRIGGER ch_upd_131 AFTER UPDATE ON DiscussionTopic BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 131 AS chTableId, NEW.discussionTopicUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 131 AND chEntityPk = NEW.discussionTopicUid); ENDn!+„wtriggerch_ins_131DiscussionTopicCREATE TRIGGER ch_ins_131 AFTER INSERT ON DiscussionTopic BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 131 AS chTableId, NEW.discussionTopicUid AS chEntityPk, 1 AS chType WHERE ‚!… AAƒQviewDiscussionPost_ReceiveViewDiscussionPost_ReceiveViewCREATE VIEW DiscussionPost_ReceiveView AS SELECT DiscussionPost.*, DiscussionPostReplicate.* FROM DiscussionPost LEFT JOIN DiscussionPostReplicate ON DiscussionPostReplicate.discussionPostPk = DiscussionPost.discussionPostUid‚X…!)„qtriggerch_del_132DiscussionPostCREATE TRIGGER ch_del_132 AFTER DELETE ON DiscussionPost BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 132 AS chTableId, OLD.discussionPostUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 132 AND chEntityPk = OLD.discussionPostUid);‚\…!+„wtriggerch_ins_131DiscussionTopicCREATE TRIGGER ch_ins_131 AFTER INSERT ON DiscussionTopic BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 131 AS chTableId, NEW.discussionTopicUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 131 AND chEntityPk = NEW.discussionTopicUid); END פ H #׊H…!MA” triggerdiscussionpost_remote_insert_insDiscussionPost_ReceiveViewCREATE TRIGGER discussionpost_remote_insert_ins INSTEAD OF INSERT ON DiscussionPost_ReceiveView FOR EACH ROW BEGIN REPLACE INTO DiscussionPost(discussionPostUid, discussionPostTitle, discussionPostMessage, discussionPostStartDate, discussionPostDiscussionTopicUid, discussionPostVisible, discussionPostArchive, discussionPostStartedPersonUid, discussionPostClazzUid, discussionPostLct) VALUES(NEW.discussionPostUid, NEW.discussionPostTitle, NEW.discussionPostMessage, NEW.discussionPostStartDate, NEW.discussionPostDiscussionTopicUid, NEW.discussionPostVisible, NEW.discussionPostArchive, NEW.discussionPostStartedPersonUid, NEW.discussionPostClazzUid, NEW.discussionPostLct) /*psql ON CONFLICT (discussionPostUid) DO UPDATE SET discussionPostTitle = EXCLUDED.discussionPostTitle , discussionPostMessage = EXCLUDED.discussionPostMessage , discussionPostStartDate = EXCLUDED.discussionPostStartDate , discussionPostDiscussionTopicUid = EXCLUDED.discussionPostDiscussionTopicUid, discussionPostVisible = EXCLUDED.discussionPostVisible , discussionPostArchive = EXCLUDED.discussionPostArchive , discussionPostStartedPersonUid = EXCLUDED.discussionPostStartedPersonUid , discussionPostClazzUid = EXCLUDED.discussionPostClazzUid, discussionPostLct = EXCLUDED.discussionPostLct */ ; END‚!… AAƒQviewDiscussionPost_ReceiveViewDiscussionPost_ReceiveViewCREATE VIEW DiscussionPost_ReceiveView AS SELECT DiscussionPost.*, DiscussionPostReplicate.* FROM DiscussionPost LEFT JOIN DiscussionPostReplicate ON DiscussionPostReplicate.discussionPostPk = DiscussionPost.discussionPostUid‚X…!)„qtriggerch_del_132DiscussionPostCREATE TRIGGER ch_del_132 AFTER DELETE ON DiscussionPost BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 132 AS chTableId, OLD.discussionPostUid AS chEntityPk, 2 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 132 AND chEntityPk = OLD.discussionPostUid); END‚X…!)„qtriggerch_upd_132DiscussionPostCREATE TRIGGER ch_upd_132 AFTER UPDATE ON DiscussionPost BEGIN INSERT INTO ChangeLog(chTableId, chEntityPk, chType) SELECT 132 AS chTableId, NEW.discussionPostUid AS chEntityPk, 1 AS chType WHERE NOT EXISTS( SELECT chTableId FROM ChangeLog WHERE chTableId = 132 AND chEntityPk = NEW.discussionPostUid); END