0$HJ  0 HR 20 XR A0X" ' Q2 00:Q BJ 042 0 2A0J 02 02 0HJ402l0H'  2(  ( J'k02l0H@  ( J)n 0002l0H'  ( JN  0002A02 0H'  ( @ J(J( J& 020 H'  ( J1 020 2 0 H@  ( J% 0$20 H@  ( J8 02l0H@  2(   ( Jo 0$00#2 02 02 02  002020$2 0 H'  ( Ji  002 02 02 02  002020$2 0 H'  ( J) 020H@  ( J( 020 H@  ( J0  00H'  2(   ( J 02 0H'J 02-0H'J102 4 00H@  2(J702 0H@  2(  J 02 0H'J 02 0H@J 02 0H@J* 042 0 2A0H'  ( J7 04202A020H@  ( J6 0420H@  (  D ( JD0H@  (    J 0   J 0JD"02 #0H@  (    J 0J0$2-0H@  <"'2 00BJ$02l0H'  ( J'k02l0H@  ( J)n 0002l0H'  ( J( 0 20H@  ( JD0H@  (    J 0   J 0JE 0H@  (    J 0   J 0JE 0H@  (    J 0   J 0JE 0H@  (    J 0   J 0JD"02 #0H@  (    J 0JE 02 #0H@  (    J 0JE 02 #0H@  (    J 0JE 02 #0H@  (    J 0J0$2-0H@  ="'2 00BJ5  00202A0H@  ( J,  002A0H@  ( J1 02A020H@  ( J? 0$2A02 02 02j0H@  ( JD0H@  (    J 0   J 0JE 0H@  (    J 0   J 0JE 0H@  (    J 0   J 0JD"02 #0H@  (    J 0JE 02 #0H@  (    J 0JE 02 #0H@  (    J 0J@ 02 042A02020H@  (  >"20B  0w0J  0HJ  0HJ  02  02w0HJ 042  0HJ  0$HJ  0 HR w0XR  0X"'20: BJ-  002 0H@  ( J6  002 02 0H@  ( J( 02l0H@  ( J= 02l0H@  ( =  J/02-0H@J& 042 0H@  ( J/ 042 02 0H@  ( JD0H@  (    J 0   J 0JD"02 #0H@  (    J 0J02 0H@  ?"620BR 0 XD( R 0 XD( "' Q2 00:QBJ( 02A0H@  ( J*  0002A0H'  ( JD0H@  (    J 0   J 0JD"02 #0H@  (    J 0J02 0H@  @"220BRb0$XTRc0$XT"' Q2 00:QBJH 0$00#2@0 2A020$2 04H'  ( J)  002 04H'  ( J/   00002 04H'  ( J)020H@  ( J=002 i00H'  2(  ( J)n 0002l0H'  ( J   002 0H'J 0J802 4 00H'  2(  JE 0H@  (    J 0   J 0JE 02 #0H@  (    J 0J> 02042 0020H@  ( J02-0H@  A"420BR 0$XTR 0$XT"$' Q2 00:QBB"'2 002 00/BJ'h02 i002j0H@XJ. 0$00#2w0H'  ( J(  002w0H'  ( J.   00002w0H'  ( J,  002w0H@  ( J$02l0H'  ( J'k02l0H@  ( J,02-0H'JD0H@  (    J 0   J 0JD"02 #0H@  (    J 0J0$2-0H@ J7 02 02042j0H@  (  C"'2 00BJ 02 0H'bJ$02l0H'  ( J1 0Q02 0$2 0H'  ( D"p20BR0 XT( R0 XT( R0 XT(R 0$XTR 0$XT"' Q2 00:QBJH 0$00#2@0 2A02020$H'  ( J) 020 H@  ( J> 020 H@  (   =J(k020H@  ( J(02l0H@  ( J8 04202020H@  ( JD0H@  (    J 0   J 0JD"02 #0H@  (    J 0J0$2-0H@  E"Z20BR0$XTR0$XTR0$XTR0$XT"' Q2 00:QBJS 0$00#202 0$20$20 20H'  ( J?  00202 0$20 H@  ( JI  00202A02 0$2  0H@  ( J$k02 0H'  ( JD0H@  (    J 0   J 0JD"02 #0H@  (    J 0J0$2-0H@  F""20BR 0 XT( "' Q20:QBJ2  0020$20H'  ( J6  0020$20H@  ( J8 0$00#20$20H'  ( J)02 0H@  ( J+  0002 0H'  ( J/02 0H@J"02  00H@JD0H@  (    J 0   J 0JE 0H@  (    J 0   J 0JE 0H@  (    J 0   J 0JE 0H@  (    J 0   J 0JD"02 #0H@  (    J 0J> 02#0H@  (    J 0JE 02 #0H@  (    J 0J, 02 #0H@  ( J02 0H@ J"02  00H@  G"Z20BR 0$XTR 0$XTR 0$XTR 0$XT"' Q2 00:QBJ%02 0$H'  ( J. 02 0$20H'  ( J/   00002 0$H'  ( J. 02 0$2 0 H'  ( J* 02l0$2 0H'  ( J* 02l0$2 0H'  ( J3 02l0$20$2 0$H'  ( H"20BR 0 XT( R 0 XT( R 0 XT( R 0 XT( R 0 XT( R 0 XT( "' Q2 00:QBI"'20BJ 0H'  ( J% 0H@  ( =J,02 0H'J' 02 0H@  JD0H@  (    J 0   J 0JD"02 #0H@  (    J 0J02 0H@  J"'2 00BJ)  002 0H'  ( J. 02 0 2 0H'  ( JD0H@  (    J 0   J 0JD"02 #0H@  (    J 0J4 02 042 020H'  (  K"'2 00BJF 02  0 2 02  0 2  0 H'  ( JI  002 02 0 2 0 2 0 H'  ( 7JD0H@  (    J 0   J 0JD"02 #0H@  (    J 0JO 02 0 2 02 0 2 0 2 0420H'  ( JF 02 02 0 2 0 2 0420H'  (  L""20BJ  00H"2 00BJ  00HJ 02 0HJ 02 020HR  08VXA ( !  B  (      08 " Q20: QB{ 0$ 0  0   0   0A ( !  B  (      08 B&  0  0   0 J  0HJ  0 HJ  0 HJ1 02  02  0 2  0 HJ 042  0HJ  0$HJ  0 HR  0 XR  0 XR  0X"20BR0$XTR0$XTR 0$XT R 0$XT R0$XTR0$XT" ' Q2 00:Q BJ. 02 0 H@  ( 7J% 02 0 H'  ( J/  002  0 0H'  ( J) 02 0 H@  ( J1 0 2020H@  ( J. 02}02 0H@  ( JO 0$00#202020 20$H'  ( 7J% 020H'  ( JI 0$00#20202A02 0 H'  ( JE 0$00#20202A0H'  ( 7J2 0202 0H@  ( J2 02020H@  ( Jf 0$00#2 0H'!  J 0J 0J 0@ J(J(J( J"  000H'  ( J 0H'  ( J$  002 0H@J-  002 0 2  00H@J 0H'  ( J102 4 00H@  2(JD0H@  (    J 0   J 0JD"02 #0H@  (    J 0J302l020$20H'  (  M"^'20BJ 0H@  ( J#02 0H'   N"20B  0$  0J  0$HJ  0HJ! 02  0$2  0HJ 042  0HJ  0$HJ  0 HR  0XR  0$X""20BR 0 XT( "' Q20:QBJ& 0$2 0H@  ( JH 02A02 020$2 0$2j0H@  ( J8 02 020$2 0$H@  ( J2 002  00H@  ( J2 002  00H@  ( J2 002  00H@  ( J2 002  00H@  ( J$  00H@  ( J&   0000H'  ( J*n 0002 0H'  ( J,  002A0H@  ( J 02 0H@JE 0H@  (    J 0   J 0JE 02 #0H@  (    J 0 O"'2 00BJ4 0$00#2 i00H'  ( J.  002 i00H'  ( J4 0$00#2 i00H'  ( JA002 i00H@  2(  ( J' 02  0 H'  ( J  0H@J<02 4 00H@  2(  JD0H@  (    J 0   J 0JD"02 #0H@  (    J 0 P""20BJ  00H"2 00BJ  00HJ 02 0HJ 02 020HR  08VXA ( !  B  (      08 " Q20: QBo 0$ 0  0   0A ( !  B  (      08 B  0  0 J  0HJ  0 HJ! 02  02  0 HJ 042  0HJ  0$HJ  0 HR  0 XR  0X""20BJ  00H"2 00BJ  00HJ 02 0HJ 02 020HR  08VXA ( !  B  (      08 " Q20: QBo 0$ 0  0   0A ( !  B  (      08 B  0  0 J  0HJ  0 HJ! 02  02  0 HJ 042  0HJ  0$HJ  0 HR  0XR  0 X"'2 00: BJC  002 0$0H@  2(   ( J. 0202 0H'  ( J. 02 02 0H'  ( JD0H@  (    J 0   J 0JD"02 #0H@  (    J 0 Q"'2 00BJ7 02  0 H'  2(   ( J5 02 0H'  2(   ( JD0H@  (    J 0   J 0JD"02 #0H@  (    J 0 R 1 < com ustadmobile core db ContentJobItemTriggersCallback Companion kotlin Any postgresContentJobItemTriggers Array String sqliteContentJobItemTriggers dumpSqlStatements Unit getStatusOfItemAndChildrenSql contentJobItemUidExpression recursiveStatusCaseClause door !DoorDatabaseCallbackStatementList onCreate collections List DoorSqlDatabase onOpen JobStatus CANCELED Int COMPLETE COMPLETE_MAX COMPLETE_MIN FAILED NOT_QUEUED PARTIAL_FAILED PAUSED QUEUED RUNNING RUNNING_MAX RUNNING_MIN WAITING_FOR_CONNECTION WAITING_MAX WAITING_MIN statusToString status SiteTermsDao dao OneToManyJoinDao lib entities SiteTerms deactivateByUids uidList Long changeTime androidx room Transaction findAllTermsAsFactory DoorDataSourceFactory SiteTermsWithLanguage Query value SELECT SiteTerms.*, Language.* FROM SiteTerms LEFT JOIN Language ON SiteTerms.sTermsLangUid = Language.langUid WHERE CAST(sTermsActive AS INTEGER) = 1 findAllWithLanguageAsList SELECT SiteTerms.*, Language.* FROM SiteTerms LEFT JOIN Language ON SiteTerms.sTermsLangUid = Language.langUid WHERE CAST(sTermsActive AS INTEGER) = 1 findByUidAsync uid .SELECT * FROM SiteTerms WHERE sTermsUid = :uid findSiteTerms langCode  SELECT * FROM SiteTerms WHERE sTermsUid = coalesce( (SELECT sTermsUid FROM SiteTerms st_int WHERE st_int.sTermsLang = :langCode LIMIT 1), (SELECT sTermsUid FROM SiteTerms st_int WHERE st_int.sTermsLang = 'en' LIMIT 1), 0) insertAsync siteTerms Insert replicateOnChange  REPLACE INTO SiteTermsReplicate(stPk, stDestination) SELECT DISTINCT SiteTerms.sTermsUid AS stUid, UserSession.usClientNodeId AS stDestination FROM ChangeLog JOIN SiteTerms ON ChangeLog.chTableId = 272 AND ChangeLog.chEntityPk = SiteTerms.sTermsUid JOIN UserSession ON UserSession.usStatus = 1 WHERE UserSession.usClientNodeId != ( SELECT nodeClientId FROM SyncNode LIMIT 1) AND SiteTerms.sTermsLct != COALESCE( (SELECT stVersionId FROM SiteTermsReplicate WHERE stPk = SiteTerms.sTermsUid AND stDestination = UserSession.usClientNodeId), 0) /*psql ON CONFLICT(stPk, stDestination) DO UPDATE SET stPending = true */ annotation ReplicationRunOnChange 'ReplicationCheckPendingNotificationsFor replicateOnNewNode newNodeId NewNodeIdParam  REPLACE INTO SiteTermsReplicate(stPk, stDestination) SELECT DISTINCT SiteTerms.sTermsUid AS stPk, :newNodeId AS stDestination FROM SiteTerms WHERE SiteTerms.sTermsLct != COALESCE( (SELECT stVersionId FROM SiteTermsReplicate WHERE stPk = SiteTerms.sTermsUid AND stDestination = :newNodeId), 0) /*psql ON CONFLICT(stPk, stDestination) DO UPDATE SET stPending = true */ ReplicationRunOnNewNode updateActiveByUid sTermsUid active Boolean  UPDATE SiteTerms SET sTermsActive = :active, sTermsLct = :changeTime WHERE sTermsUid = :sTermsUid Dao Repository UmAppDatabase MIGRATION_100_101 migration DoorMigrationStatementList MIGRATION_101_102 MIGRATION_102_103 MIGRATION_103_104 MIGRATION_104_105 MIGRATION_105_106 MIGRATION_44_45 DoorMigrationSync MIGRATION_45_46 MIGRATION_46_47 MIGRATION_47_48 MIGRATION_48_49 MIGRATION_49_50 MIGRATION_50_51 MIGRATION_51_52 MIGRATION_52_53 MIGRATION_53_54 MIGRATION_54_55 MIGRATION_55_56 MIGRATION_56_57 MIGRATION_57_58 MIGRATION_58_59 MIGRATION_59_60 MIGRATION_60_61 MIGRATION_61_62 MIGRATION_62_63 MIGRATION_63_64 MIGRATION_64_65 MIGRATION_65_66 MIGRATION_66_67 MIGRATION_68_69 MIGRATION_69_70 MIGRATION_70_71 MIGRATION_71_72 MIGRATION_72_73 MIGRATION_73_74 MIGRATION_74_75 MIGRATION_75_76 MIGRATION_76_77 MIGRATION_77_78 MIGRATION_78_79 MIGRATION_79_80 MIGRATION_80_81 MIGRATION_81_82 MIGRATION_82_83 MIGRATION_83_84 MIGRATION_84_85 MIGRATION_85_86 MIGRATION_86_87 MIGRATION_87_88 MIGRATION_88_89 MIGRATION_89_90 MIGRATION_90_91 MIGRATION_92_93 MIGRATION_93_94 MIGRATION_94_95 MIGRATION_95_96 MIGRATION_96_97 MIGRATION_97_98 MIGRATION_98_99 MIGRATION_99_100 TAG_DB TAG_REPO fooVar migrate67to68 nodeId migrationList DoorMigration DoorDatabase agentDao AgentDao js JsName name chatDao ChatDao chatMemberDao ChatMemberDao clazzAssignmentContentJoinDao ClazzAssignmentContentJoinDao clazzAssignmentDao ClazzAssignmentDao clazzAssignmentRollUpDao ClazzAssignmentRollUpDao cacheClazzAssignmentDao clazzContentJoinDao ClazzContentJoinDao clazzDao ClazzDao clazzEnrolmentDao ClazzEnrolmentDao clazzLogAttendanceRecordDao ClazzLogAttendanceRecordDao clazzLogDao ClazzLogDao commentsDao CommentsDao connectivityStatusDao ConnectivityStatusDao containerDao ContainerDao containerETagDao ContainerETagDao containerEntryDao ContainerEntryDao containerEntryFileDao ContainerEntryFileDao containerImportJobDao ContainerImportJobDao contentCategoryDao ContentCategoryDao contentCategorySchemaDao ContentCategorySchemaDao "contentEntryContentCategoryJoinDao "ContentEntryContentCategoryJoinDao contentEntryDao ContentEntryDao contentEntryParentChildJoinDao ContentEntryParentChildJoinDao contentEntryPictureDao ContentEntryPictureDao contentEntryRelatedEntryJoinDao ContentEntryRelatedEntryJoinDao contentJobDao ContentJobDao contentJobItemDao ContentJobItemDao contextXObjectStatementJoinDao ContextXObjectStatementJoinDao courseAssignmentMarkDao CourseAssignmentMarkDao 'courseAssignmentSubmissionAttachmentDao 'CourseAssignmentSubmissionAttachmentDao courseAssignmentSubmissionDao CourseAssignmentSubmissionDao courseBlockDao CourseBlockDao courseDiscussionDao CourseDiscussionDao courseGroupMemberDao CourseGroupMemberDao courseGroupSetDao CourseGroupSetDao coursePictureDao CoursePictureDao courseTerminologyDao CourseTerminologyDao customFieldDao CustomFieldDao customFieldValueDao CustomFieldValueDao customFieldValueOptionDao CustomFieldValueOptionDao discussionPostDao DiscussionPostDao discussionTopicDao DiscussionTopicDao entityRoleDao EntityRoleDao errorReportDao ErrorReportDao groupLearningSessionDao GroupLearningSessionDao holidayCalendarDao HolidayCalendarDao holidayDao HolidayDao languageDao LanguageDao languageVariantDao LanguageVariantDao learnerGroupDao LearnerGroupDao learnerGroupMemberDao LearnerGroupMemberDao leavingReasonDao LeavingReasonDao locallyAvailableContainerDao LocallyAvailableContainerDao messageDao MessageDao messageReadDao MessageReadDao networkNodeDao NetworkNodeDao personAuth2Dao PersonAuth2Dao personAuthDao PersonAuthDao personDao PersonDao personGroupDao PersonGroupDao personGroupMemberDao PersonGroupMemberDao personParentJoinDao PersonParentJoinDao personPictureDao PersonPictureDao reportDao ReportDao scheduleDao ScheduleDao scheduledCheckDao ScheduledCheckDao schoolDao SchoolDao schoolMemberDao SchoolMemberDao scopedGrantDao ScopedGrantDao scrapeQueueItemDao ScrapeQueueItemDao scrapeRunDao ScrapeRunDao siteDao SiteDao siteTermsDao stateContentDao StateContentDao stateDao StateDao statementDao StatementDao syncNodeDao SyncNodeDao userSessionDao UserSessionDao verbDao VerbDao xLangMapEntryDao XLangMapEntryDao xObjectDao XObjectDao preload MinReplicationVersion &UmAppDatabaseReplicationMigration91_92 addReplicationEntities dropOldPostgresFunctions dropOldPostgresTriggers dropOldSqliteTriggers                         + , - .  / 0 3 5 6 7  9 : ; H  K !L !M !P !R V X !Y Z )  \ +] +d +     1                                                                                !W0 *0H0 *0H0 *0H0 *0H" 0-"Y20BJ 0 J0 20 HJ0 20 R0 0XR 0 0X"@ 20 :BJ0 020HJ0 020H"20BJ)0 2*0R0XT8R0XT0R0XT00H@ <(?J%@02A0H@ <(BJ%C02D0 H@ <(EJF02G0H@ JAI0 H@ <(J" < J 0# < J 0JBN0 2 O0$H@ <(Q%# < J 0J3S0 2T02U0&240H@ <(W '("*20BJ0-20HJ0.020R[0,R^0,R_0,R`0,Ra0,Rb0,Rc0-Re0-Rf0-Rg0-Rh0-Ri0-Rj0-Rk0-Rl0-Rm0-Rn0-Ro0-Rp0-Rq0-Rr0-Rs0-Rt0-Ru0-Rv0-Rw0-Rx0-Ry0-Rz0-R{0-R |0-XR }0-XR~0-R0-R0-R0-R0-R0-R0-R0-R0,R0,R0,R0,R0,R0,R0,R0,R0,R0,R0,R0,R0,R0,R0,R0,R0,R0,R0,R0,R0XTR0XTR08XD"') 20/:BJ 0 H@R008&X2 (R038&X2 (R048&X2 (R058&X2 (R068&X2 (R078&X2 (R088&X2 (R098&X2 (R0:8&X2 (R 0;XR 08&X2 (R0?8&X2 (R0@8&X2 (R0A8&X2 (R0B8&X2 (R0C8&X2 (R0D8&X2 (R0E8&X2 (R0F8&X2 (R0G8&X2 (R0H8&X2 (R0I8&X2 (R0J8&X2 (R 0KXR 0LXR0M8&X2 (R0N8&X2 (R0O8&X2 (R0P8&X2 (R0Q8&X2 (R0R8&X2 (R0S8&X2 (R0T8&X2 (R0U8&X2 (R0V8&X2 (R 0WXR 0XXR 0YXR0Z8&X2 (R0[8&X2 (R0\8&X2 (R 0]XR0^8&X2 (R 0_XR 0`XR0a8&X2 (R0b8&X2 (R0c8&X2 (R0d8&X2 (R0e8&X2 (R 0fXR0g8&X2 (R0h8&X2 (R0i8&X2 (R 0jXR0k8&X2 (R0l8&X2 (R0m8&X2 (R0n8&X2 (R 0oXR0p8&X2 (R0q8&X2 (R 0rXR 0sXR 0tXR0u8&X2 (R 0vXR0w8&X2 (R0x8&X2 (R 0yXR 0XR0z8&X2 (R0{8&X2 (R0|8&X2 (R0}8&X2 (R 0~XR08&X2 (R08&X2 (R08&X2 (  <x