ofs | hex dump | ascii |
---|
0000 | 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 04 00 01 01 00 40 20 20 00 00 00 0f 00 00 00 09 | SQLite.format.3......@.......... |
0020 | 00 00 00 00 00 00 00 00 00 00 00 08 00 00 00 04 00 00 00 00 00 00 00 00 00 00 00 01 00 00 00 00 | ................................ |
0040 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0f | ................................ |
0060 | 00 2d e2 27 05 00 00 00 05 03 e7 00 00 00 00 09 03 fb 03 f6 03 f1 03 ec 03 e7 00 00 00 00 00 00 | .-.'............................ |
0080 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
00a0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
00c0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 82 56 03 07 1b 39 1f 08 84 5f 74 72 69 67 67 65 72 | ................V...9..._trigger |
00e0 | 62 6f 6f 6b 6d 61 72 6b 49 6e 73 65 72 74 50 6f 73 50 61 6e 65 6c 62 6f 6f 6b 6d 61 72 6b 73 43 | bookmarkInsertPosPanelbookmarksC |
0100 | 52 45 41 54 45 20 54 52 49 47 47 45 52 20 62 6f 6f 6b 6d 61 72 6b 49 6e 73 65 72 74 50 6f 73 50 | REATE.TRIGGER.bookmarkInsertPosP |
0120 | 61 6e 65 6c 20 41 46 54 45 52 20 49 4e 53 45 52 54 20 4f 4e 20 62 6f 6f 6b 6d 61 72 6b 73 20 46 | anel.AFTER.INSERT.ON.bookmarks.F |
0140 | 4f 52 20 45 41 43 48 20 52 4f 57 20 42 45 47 49 4e 20 55 50 44 41 54 45 20 62 6f 6f 6b 6d 61 72 | OR.EACH.ROW.BEGIN.UPDATE.bookmar |
0160 | 6b 73 20 53 45 54 20 70 6f 73 5f 70 61 6e 65 6c 20 3d 20 28 53 45 4c 45 43 54 20 69 66 6e 75 6c | ks.SET.pos_panel.=.(SELECT.ifnul |
0180 | 6c 28 4d 41 58 28 70 6f 73 5f 70 61 6e 65 6c 29 2c 30 29 2b 31 20 46 52 4f 4d 20 62 6f 6f 6b 6d | l(MAX(pos_panel),0)+1.FROM.bookm |
01a0 | 61 72 6b 73 20 57 48 45 52 45 20 28 4e 45 57 2e 70 61 72 65 6e 74 69 64 20 49 53 20 4e 4f 54 20 | arks.WHERE.(NEW.parentid.IS.NOT. |
01c0 | 4e 55 4c 4c 20 41 4e 44 20 70 61 72 65 6e 74 69 64 20 3d 20 4e 45 57 2e 70 61 72 65 6e 74 69 64 | NULL.AND.parentid.=.NEW.parentid |
01e0 | 29 20 4f 52 20 28 4e 45 57 2e 70 61 72 65 6e 74 69 64 20 49 53 20 4e 55 4c 4c 20 41 4e 44 20 70 | ).OR.(NEW.parentid.IS.NULL.AND.p |
0200 | 61 72 65 6e 74 69 64 20 49 53 20 4e 55 4c 4c 29 29 20 57 48 45 52 45 20 69 64 20 3d 20 4e 45 57 | arentid.IS.NULL)).WHERE.id.=.NEW |
0220 | 2e 69 64 3b 20 45 4e 44 50 02 06 17 2b 2b 01 59 74 61 62 6c 65 73 71 6c 69 74 65 5f 73 65 71 75 | .id;.ENDP...++.Ytablesqlite_sequ |
0240 | 65 6e 63 65 73 71 6c 69 74 65 5f 73 65 71 75 65 6e 63 65 03 43 52 45 41 54 45 20 54 41 42 4c 45 | encesqlite_sequence.CREATE.TABLE |
0260 | 20 73 71 6c 69 74 65 5f 73 65 71 75 65 6e 63 65 28 6e 61 6d 65 2c 73 65 71 29 83 03 01 07 17 1f | .sqlite_sequence(name,seq)...... |
0280 | 1f 01 85 55 74 61 62 6c 65 62 6f 6f 6b 6d 61 72 6b 73 62 6f 6f 6b 6d 61 72 6b 73 02 43 52 45 41 | ...Utablebookmarksbookmarks.CREA |
02a0 | 54 45 20 54 41 42 4c 45 20 62 6f 6f 6b 6d 61 72 6b 73 20 28 69 64 20 49 4e 54 45 47 45 52 20 50 | TE.TABLE.bookmarks.(id.INTEGER.P |
02c0 | 52 49 4d 41 52 59 20 4b 45 59 20 41 55 54 4f 49 4e 43 52 45 4d 45 4e 54 2c 20 70 61 72 65 6e 74 | RIMARY.KEY.AUTOINCREMENT,.parent |
02e0 | 69 64 20 49 4e 54 45 47 45 52 20 44 45 46 41 55 4c 54 20 4e 55 4c 4c 2c 20 74 69 74 6c 65 20 54 | id.INTEGER.DEFAULT.NULL,.title.T |
0300 | 45 58 54 2c 20 75 72 69 20 54 45 58 54 2c 20 64 65 73 63 20 54 45 58 54 2c 20 61 70 70 20 49 4e | EXT,.uri.TEXT,.desc.TEXT,.app.IN |
0320 | 54 45 47 45 52 2c 20 74 6f 6f 6c 62 61 72 20 49 4e 54 45 47 45 52 2c 20 70 6f 73 5f 70 61 6e 65 | TEGER,.toolbar.INTEGER,.pos_pane |
0340 | 6c 20 49 4e 54 45 47 45 52 2c 20 70 6f 73 5f 62 61 72 20 49 4e 54 45 47 45 52 2c 20 63 72 65 61 | l.INTEGER,.pos_bar.INTEGER,.crea |
0360 | 74 65 64 20 44 41 54 45 20 44 45 46 41 55 4c 54 20 43 55 52 52 45 4e 54 5f 54 49 4d 45 53 54 41 | ted.DATE.DEFAULT.CURRENT_TIMESTA |
0380 | 4d 50 2c 20 6c 61 73 74 5f 76 69 73 69 74 20 44 41 54 45 2c 20 76 69 73 69 74 5f 63 6f 75 6e 74 | MP,.last_visit.DATE,.visit_count |
03a0 | 20 49 4e 54 45 47 45 52 20 44 45 46 41 55 4c 54 20 30 2c 20 6e 69 63 6b 20 54 45 58 54 2c 20 46 | .INTEGER.DEFAULT.0,.nick.TEXT,.F |
03c0 | 4f 52 45 49 47 4e 20 4b 45 59 28 70 61 72 65 6e 74 69 64 29 20 52 45 46 45 52 45 4e 43 45 53 20 | OREIGN.KEY(parentid).REFERENCES. |
03e0 | 62 6f 6f 6b 6d 61 72 00 00 00 08 08 00 00 00 07 06 00 00 00 06 05 00 00 00 05 04 00 00 00 04 03 | bookmar......................... |
0400 | 0d 00 00 00 04 02 a1 00 03 90 03 3b 02 ee 02 a1 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ...........;.................... |
0420 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0440 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0460 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0480 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
04a0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
04c0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
04e0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0500 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0520 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0540 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0560 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0580 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
05a0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
05c0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
05e0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0600 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0620 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0640 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0660 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0680 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
06a0 | 00 4b 04 0e 00 00 25 47 0d 08 08 01 00 33 00 08 00 43 6c 6f 75 64 20 44 65 6d 6f 20 32 68 74 74 | .K....%G.....3...Cloud.Demo.2htt |
06c0 | 70 3a 2f 2f 63 6c 6f 75 64 2e 74 6f 72 61 64 65 78 2e 63 6f 6d 2f 3f 63 3d 32 04 32 30 31 33 2d | p://cloud.toradex.com/?c=2.2013- |
06e0 | 31 30 2d 31 37 20 30 37 3a 33 39 3a 35 31 4b 03 0e 00 00 25 47 0d 08 08 01 00 33 00 08 00 43 6c | 10-17.07:39:51K....%G.....3...Cl |
0700 | 6f 75 64 20 44 65 6d 6f 20 31 68 74 74 70 3a 2f 2f 63 6c 6f 75 64 2e 74 6f 72 61 64 65 78 2e 63 | oud.Demo.1http://cloud.toradex.c |
0720 | 6f 6d 2f 3f 63 3d 31 03 32 30 31 33 2d 31 30 2d 31 37 20 30 37 3a 33 37 3a 31 36 53 02 0e 00 00 | om/?c=1.2013-10-17.07:37:16S.... |
0740 | 35 47 0d 08 08 01 00 33 00 08 00 44 65 76 65 6c 6f 70 65 72 20 52 65 73 73 6f 75 72 63 65 73 68 | 5G.....3...Developer.Ressourcesh |
0760 | 74 74 70 3a 2f 2f 64 65 76 65 6c 6f 70 65 72 2e 74 6f 72 61 64 65 78 2e 63 6f 6d 2f 02 32 30 31 | ttp://developer.toradex.com/.201 |
0780 | 33 2d 31 30 2d 31 37 20 30 37 3a 33 30 3a 35 31 6e 01 0f 00 00 2d 81 05 0d 08 08 09 00 33 00 08 | 3-10-17.07:30:51n....-.......3.. |
07a0 | 00 54 6f 72 61 64 65 78 20 48 6f 6d 65 70 61 67 65 68 74 74 70 3a 2f 2f 77 77 77 2e 74 6f 72 61 | .Toradex.Homepagehttp://www.tora |
07c0 | 64 65 78 2e 63 6f 6d 2f 70 72 6f 64 75 63 74 73 2f 63 6f 6c 69 62 72 69 2d 61 72 6d 2d 63 6f 6d | dex.com/products/colibri-arm-com |
07e0 | 70 75 74 65 72 2d 6d 6f 64 75 6c 65 73 32 30 31 33 2d 31 30 2d 31 37 20 30 37 3a 32 36 3a 35 33 | puter-modules2013-10-17.07:26:53 |
0800 | 0d 00 00 00 01 03 f1 00 03 f1 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0820 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0840 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0860 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0880 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
08a0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
08c0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
08e0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0900 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0920 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0940 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0960 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0980 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
09a0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
09c0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
09e0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0a00 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0a20 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0a40 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0a60 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0a80 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0aa0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0ac0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0ae0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0b00 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0b20 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0b40 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0b60 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0b80 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0ba0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0bc0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0be0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0d 01 03 1f 01 62 6f 6f 6b 6d 61 72 6b 73 04 | ......................bookmarks. |
0c00 | 0d 00 00 00 03 00 cf 00 00 cf 02 55 02 a7 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ...........U.................... |
0c20 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0c40 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0c60 | 00 00 00 00 00 00 00 00 00 00 00 82 56 03 07 1b 39 1f 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ............V...9............... |
0c80 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0ca0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
0cc0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 83 03 01 07 17 1f 1f 01 85 55 74 61 62 6c 65 62 6f | ........................Utablebo |
0ce0 | 6f 6b 6d 61 72 6b 73 62 6f 6f 6b 6d 61 72 6b 73 02 43 52 45 41 54 45 20 54 41 42 4c 45 20 62 6f | okmarksbookmarks.CREATE.TABLE.bo |
0d00 | 6f 6b 6d 61 72 6b 73 20 28 69 64 20 49 4e 54 45 47 45 52 20 50 52 49 4d 41 52 59 20 4b 45 59 20 | okmarks.(id.INTEGER.PRIMARY.KEY. |
0d20 | 41 55 54 4f 49 4e 43 52 45 4d 45 4e 54 2c 20 70 61 72 65 6e 74 69 64 20 49 4e 54 45 47 45 52 20 | AUTOINCREMENT,.parentid.INTEGER. |
0d40 | 44 45 46 41 55 4c 54 20 4e 55 4c 4c 2c 20 74 69 74 6c 65 20 54 45 58 54 2c 20 75 72 69 20 54 45 | DEFAULT.NULL,.title.TEXT,.uri.TE |
0d60 | 58 54 2c 20 64 65 73 63 20 54 45 58 54 2c 20 61 70 70 20 49 4e 54 45 47 45 52 2c 20 74 6f 6f 6c | XT,.desc.TEXT,.app.INTEGER,.tool |
0d80 | 62 61 72 20 49 4e 54 45 47 45 52 2c 20 70 6f 73 5f 70 61 6e 65 6c 20 49 4e 54 45 47 45 52 2c 20 | bar.INTEGER,.pos_panel.INTEGER,. |
0da0 | 70 6f 73 5f 62 61 72 20 49 4e 54 45 47 45 52 2c 20 63 72 65 61 74 65 64 20 44 41 54 45 20 44 45 | pos_bar.INTEGER,.created.DATE.DE |
0dc0 | 46 41 55 4c 54 20 43 55 52 52 45 4e 54 5f 54 49 4d 45 53 54 41 4d 50 2c 20 6c 61 73 74 5f 76 69 | FAULT.CURRENT_TIMESTAMP,.last_vi |
0de0 | 73 69 74 20 44 41 54 45 2c 20 76 69 73 69 74 5f 63 6f 75 6e 74 20 49 4e 54 45 47 45 52 20 44 45 | sit.DATE,.visit_count.INTEGER.DE |
0e00 | 46 41 55 4c 54 20 30 2c 20 6e 69 63 6b 20 54 45 58 54 2c 20 46 4f 52 45 49 47 4e 20 4b 45 59 28 | FAULT.0,.nick.TEXT,.FOREIGN.KEY( |
0e20 | 70 61 72 65 6e 74 69 64 29 20 52 45 46 45 52 45 4e 43 45 53 20 62 6f 6f 6b 6d 61 72 6b 73 28 69 | parentid).REFERENCES.bookmarks(i |
0e40 | 64 29 20 4f 4e 20 44 45 4c 45 54 45 20 43 41 53 43 41 44 45 29 50 02 06 17 2b 2b 01 59 74 61 62 | d).ON.DELETE.CASCADE)P...++.Ytab |
0e60 | 6c 65 73 71 6c 69 74 65 5f 73 65 71 75 65 6e 63 65 73 71 6c 69 74 65 5f 73 65 71 75 65 6e 63 65 | lesqlite_sequencesqlite_sequence |
0e80 | 03 43 52 45 41 54 45 20 54 41 42 4c 45 20 73 71 6c 69 74 65 5f 73 65 71 75 65 6e 63 65 28 6e 61 | .CREATE.TABLE.sqlite_sequence(na |
0ea0 | 6d 65 2c 73 65 71 29 82 56 03 07 1b 39 1f 08 84 5f 74 72 69 67 67 65 72 62 6f 6f 6b 6d 61 72 6b | me,seq).V...9..._triggerbookmark |
0ec0 | 49 6e 73 65 72 74 50 6f 73 50 61 6e 65 6c 62 6f 6f 6b 6d 61 72 6b 73 43 52 45 41 54 45 20 54 52 | InsertPosPanelbookmarksCREATE.TR |
0ee0 | 49 47 47 45 52 20 62 6f 6f 6b 6d 61 72 6b 49 6e 73 65 72 74 50 6f 73 50 61 6e 65 6c 20 41 46 54 | IGGER.bookmarkInsertPosPanel.AFT |
0f00 | 45 52 20 49 4e 53 45 52 54 20 4f 4e 20 62 6f 6f 6b 6d 61 72 6b 73 20 46 4f 52 20 45 41 43 48 20 | ER.INSERT.ON.bookmarks.FOR.EACH. |
0f20 | 52 4f 57 20 42 45 47 49 4e 20 55 50 44 41 54 45 20 62 6f 6f 6b 6d 61 72 6b 73 20 53 45 54 20 70 | ROW.BEGIN.UPDATE.bookmarks.SET.p |
0f40 | 6f 73 5f 70 61 6e 65 6c 20 3d 20 28 53 45 4c 45 43 54 20 69 66 6e 75 6c 6c 28 4d 41 58 28 70 6f | os_panel.=.(SELECT.ifnull(MAX(po |
0f60 | 73 5f 70 61 6e 65 6c 29 2c 30 29 2b 31 20 46 52 4f 4d 20 62 6f 6f 6b 6d 61 72 6b 73 20 57 48 45 | s_panel),0)+1.FROM.bookmarks.WHE |
0f80 | 52 45 20 28 4e 45 57 2e 70 61 72 65 6e 74 69 64 20 49 53 20 4e 4f 54 20 4e 55 4c 4c 20 41 4e 44 | RE.(NEW.parentid.IS.NOT.NULL.AND |
0fa0 | 20 70 61 72 65 6e 74 69 64 20 3d 20 4e 45 57 2e 70 61 72 65 6e 74 69 64 29 20 4f 52 20 28 4e 45 | .parentid.=.NEW.parentid).OR.(NE |
0fc0 | 57 2e 70 61 72 65 6e 74 69 64 20 49 53 20 4e 55 4c 4c 20 41 4e 44 20 70 61 72 65 6e 74 69 64 20 | W.parentid.IS.NULL.AND.parentid. |
0fe0 | 49 53 20 4e 55 4c 4c 29 29 20 57 48 45 52 45 20 69 64 20 3d 20 4e 45 57 2e 69 64 3b 20 45 4e 44 | IS.NULL)).WHERE.id.=.NEW.id;.END |
1000 | 0d 00 00 00 01 02 8c 00 02 8c 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
1020 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
1040 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
1060 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
1080 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
10a0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
10c0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
10e0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
1100 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
1120 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
1140 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
1160 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
1180 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
11a0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
11c0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
11e0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
1200 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
1220 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
1240 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
1260 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
1280 | 00 00 00 00 00 00 00 00 00 00 00 00 82 71 04 07 1b 35 1f 08 85 19 74 72 69 67 67 65 72 62 6f 6f | .............q...5....triggerboo |
12a0 | 6b 6d 61 72 6b 49 6e 73 65 72 74 50 6f 73 42 61 72 62 6f 6f 6b 6d 61 72 6b 73 43 52 45 41 54 45 | kmarkInsertPosBarbookmarksCREATE |
12c0 | 20 54 52 49 47 47 45 52 20 62 6f 6f 6b 6d 61 72 6b 49 6e 73 65 72 74 50 6f 73 42 61 72 20 41 46 | .TRIGGER.bookmarkInsertPosBar.AF |
12e0 | 54 45 52 20 49 4e 53 45 52 54 20 4f 4e 20 62 6f 6f 6b 6d 61 72 6b 73 20 46 4f 52 20 45 41 43 48 | TER.INSERT.ON.bookmarks.FOR.EACH |
1300 | 20 52 4f 57 20 57 48 45 4e 20 4e 45 57 2e 74 6f 6f 6c 62 61 72 3d 31 20 42 45 47 49 4e 20 55 50 | .ROW.WHEN.NEW.toolbar=1.BEGIN.UP |
1320 | 44 41 54 45 20 62 6f 6f 6b 6d 61 72 6b 73 20 53 45 54 20 70 6f 73 5f 62 61 72 20 3d 20 28 53 45 | DATE.bookmarks.SET.pos_bar.=.(SE |
1340 | 4c 45 43 54 20 69 66 6e 75 6c 6c 28 4d 41 58 28 70 6f 73 5f 62 61 72 29 2c 30 29 2b 31 20 46 52 | LECT.ifnull(MAX(pos_bar),0)+1.FR |
1360 | 4f 4d 20 62 6f 6f 6b 6d 61 72 6b 73 20 57 48 45 52 45 20 28 28 4e 45 57 2e 70 61 72 65 6e 74 69 | OM.bookmarks.WHERE.((NEW.parenti |
1380 | 64 20 49 53 20 4e 4f 54 20 4e 55 4c 4c 20 41 4e 44 20 70 61 72 65 6e 74 69 64 20 3d 20 4e 45 57 | d.IS.NOT.NULL.AND.parentid.=.NEW |
13a0 | 2e 70 61 72 65 6e 74 69 64 29 20 4f 52 20 28 4e 45 57 2e 70 61 72 65 6e 74 69 64 20 49 53 20 4e | .parentid).OR.(NEW.parentid.IS.N |
13c0 | 55 4c 4c 20 41 4e 44 20 70 61 72 65 6e 74 69 64 20 49 53 20 4e 55 4c 4c 29 29 20 41 4e 44 20 74 | ULL.AND.parentid.IS.NULL)).AND.t |
13e0 | 6f 6f 6c 62 61 72 3d 31 29 20 57 48 45 52 45 20 69 64 20 3d 20 4e 45 57 2e 69 64 3b 20 45 4e 44 | oolbar=1).WHERE.id.=.NEW.id;.END |
1400 | 0d 00 00 00 01 01 29 00 01 29 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ......)..)...................... |
1420 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
1440 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
1460 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
1480 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
14a0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
14c0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
14e0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
1500 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
1520 | 00 00 00 00 00 00 00 00 00 85 54 05 07 1b 39 1f 08 8a 5b 74 72 69 67 67 65 72 62 6f 6f 6b 6d 61 | ..........T...9...[triggerbookma |
1540 | 72 6b 55 70 64 61 74 65 50 6f 73 50 61 6e 65 6c 62 6f 6f 6b 6d 61 72 6b 73 43 52 45 41 54 45 20 | rkUpdatePosPanelbookmarksCREATE. |
1560 | 54 52 49 47 47 45 52 20 62 6f 6f 6b 6d 61 72 6b 55 70 64 61 74 65 50 6f 73 50 61 6e 65 6c 20 42 | TRIGGER.bookmarkUpdatePosPanel.B |
1580 | 45 46 4f 52 45 20 55 50 44 41 54 45 20 4f 46 20 70 61 72 65 6e 74 69 64 20 4f 4e 20 62 6f 6f 6b | EFORE.UPDATE.OF.parentid.ON.book |
15a0 | 6d 61 72 6b 73 20 46 4f 52 20 45 41 43 48 20 52 4f 57 20 57 48 45 4e 20 28 28 4e 45 57 2e 70 61 | marks.FOR.EACH.ROW.WHEN.((NEW.pa |
15c0 | 72 65 6e 74 69 64 20 49 53 20 4e 55 4c 4c 20 4f 52 20 4f 4c 44 2e 70 61 72 65 6e 74 69 64 20 49 | rentid.IS.NULL.OR.OLD.parentid.I |
15e0 | 53 20 4e 55 4c 4c 29 20 41 4e 44 20 4e 45 57 2e 70 61 72 65 6e 74 69 64 20 49 53 20 4e 4f 54 20 | S.NULL).AND.NEW.parentid.IS.NOT. |
1600 | 4f 4c 44 2e 70 61 72 65 6e 74 69 64 29 20 4f 52 20 28 28 4e 45 57 2e 70 61 72 65 6e 74 69 64 20 | OLD.parentid).OR.((NEW.parentid. |
1620 | 49 53 20 4e 4f 54 20 4e 55 4c 4c 20 41 4e 44 20 4f 4c 44 2e 70 61 72 65 6e 74 69 64 20 49 53 20 | IS.NOT.NULL.AND.OLD.parentid.IS. |
1640 | 4e 4f 54 20 4e 55 4c 4c 29 20 41 4e 44 20 4e 45 57 2e 70 61 72 65 6e 74 69 64 21 3d 4f 4c 44 2e | NOT.NULL).AND.NEW.parentid!=OLD. |
1660 | 70 61 72 65 6e 74 69 64 29 20 42 45 47 49 4e 20 55 50 44 41 54 45 20 62 6f 6f 6b 6d 61 72 6b 73 | parentid).BEGIN.UPDATE.bookmarks |
1680 | 20 53 45 54 20 70 6f 73 5f 70 61 6e 65 6c 20 3d 20 70 6f 73 5f 70 61 6e 65 6c 2d 31 20 57 48 45 | .SET.pos_panel.=.pos_panel-1.WHE |
16a0 | 52 45 20 28 28 4f 4c 44 2e 70 61 72 65 6e 74 69 64 20 49 53 20 4e 4f 54 20 4e 55 4c 4c 20 41 4e | RE.((OLD.parentid.IS.NOT.NULL.AN |
16c0 | 44 20 70 61 72 65 6e 74 69 64 20 3d 20 4f 4c 44 2e 70 61 72 65 6e 74 69 64 29 20 4f 52 20 28 4f | D.parentid.=.OLD.parentid).OR.(O |
16e0 | 4c 44 2e 70 61 72 65 6e 74 69 64 20 49 53 20 4e 55 4c 4c 20 41 4e 44 20 70 61 72 65 6e 74 69 64 | LD.parentid.IS.NULL.AND.parentid |
1700 | 20 49 53 20 4e 55 4c 4c 29 29 20 41 4e 44 20 70 6f 73 5f 70 61 6e 65 6c 20 3e 20 4f 4c 44 2e 70 | .IS.NULL)).AND.pos_panel.>.OLD.p |
1720 | 6f 73 5f 70 61 6e 65 6c 3b 20 55 50 44 41 54 45 20 62 6f 6f 6b 6d 61 72 6b 73 20 53 45 54 20 70 | os_panel;.UPDATE.bookmarks.SET.p |
1740 | 6f 73 5f 70 61 6e 65 6c 20 3d 20 28 53 45 4c 45 43 54 20 69 66 6e 75 6c 6c 28 4d 41 58 28 70 6f | os_panel.=.(SELECT.ifnull(MAX(po |
1760 | 73 5f 70 61 6e 65 6c 29 2c 30 29 2b 31 20 46 52 4f 4d 20 62 6f 6f 6b 6d 61 72 6b 73 20 57 48 45 | s_panel),0)+1.FROM.bookmarks.WHE |
1780 | 52 45 20 28 4e 45 57 2e 70 61 72 65 6e 74 69 64 20 49 53 20 4e 4f 54 20 4e 55 4c 4c 20 41 4e 44 | RE.(NEW.parentid.IS.NOT.NULL.AND |
17a0 | 20 70 61 72 65 6e 74 69 64 20 3d 20 4e 45 57 2e 70 61 72 65 6e 74 69 64 29 20 4f 52 20 28 4e 45 | .parentid.=.NEW.parentid).OR.(NE |
17c0 | 57 2e 70 61 72 65 6e 74 69 64 20 49 53 20 4e 55 4c 4c 20 41 4e 44 20 70 61 72 65 6e 74 69 64 20 | W.parentid.IS.NULL.AND.parentid. |
17e0 | 49 53 20 4e 55 4c 4c 29 29 20 57 48 45 52 45 20 69 64 20 3d 20 4f 4c 44 2e 69 64 3b 20 45 4e 44 | IS.NULL)).WHERE.id.=.OLD.id;.END |
1800 | 0d 00 00 00 01 01 a2 00 01 a2 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
1820 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
1840 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
1860 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
1880 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
18a0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
18c0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
18e0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
1900 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
1920 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
1940 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
1960 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
1980 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
19a0 | 00 00 84 5b 06 07 1b 37 1f 08 88 6b 74 72 69 67 67 65 72 62 6f 6f 6b 6d 61 72 6b 55 70 64 61 74 | ...[...7...ktriggerbookmarkUpdat |
19c0 | 65 50 6f 73 42 61 72 30 62 6f 6f 6b 6d 61 72 6b 73 43 52 45 41 54 45 20 54 52 49 47 47 45 52 20 | ePosBar0bookmarksCREATE.TRIGGER. |
19e0 | 62 6f 6f 6b 6d 61 72 6b 55 70 64 61 74 65 50 6f 73 42 61 72 30 20 41 46 54 45 52 20 55 50 44 41 | bookmarkUpdatePosBar0.AFTER.UPDA |
1a00 | 54 45 20 4f 46 20 70 61 72 65 6e 74 69 64 2c 20 74 6f 6f 6c 62 61 72 20 4f 4e 20 62 6f 6f 6b 6d | TE.OF.parentid,.toolbar.ON.bookm |
1a20 | 61 72 6b 73 20 46 4f 52 20 45 41 43 48 20 52 4f 57 20 57 48 45 4e 20 28 28 4e 45 57 2e 70 61 72 | arks.FOR.EACH.ROW.WHEN.((NEW.par |
1a40 | 65 6e 74 69 64 20 49 53 20 4e 55 4c 4c 20 4f 52 20 4f 4c 44 2e 70 61 72 65 6e 74 69 64 20 49 53 | entid.IS.NULL.OR.OLD.parentid.IS |
1a60 | 20 4e 55 4c 4c 29 20 41 4e 44 20 4e 45 57 2e 70 61 72 65 6e 74 69 64 20 49 53 20 4e 4f 54 20 4f | .NULL).AND.NEW.parentid.IS.NOT.O |
1a80 | 4c 44 2e 70 61 72 65 6e 74 69 64 29 20 4f 52 20 28 28 4e 45 57 2e 70 61 72 65 6e 74 69 64 20 49 | LD.parentid).OR.((NEW.parentid.I |
1aa0 | 53 20 4e 4f 54 20 4e 55 4c 4c 20 41 4e 44 20 4f 4c 44 2e 70 61 72 65 6e 74 69 64 20 49 53 20 4e | S.NOT.NULL.AND.OLD.parentid.IS.N |
1ac0 | 4f 54 20 4e 55 4c 4c 29 20 41 4e 44 20 4e 45 57 2e 70 61 72 65 6e 74 69 64 21 3d 4f 4c 44 2e 70 | OT.NULL).AND.NEW.parentid!=OLD.p |
1ae0 | 61 72 65 6e 74 69 64 29 20 4f 52 20 28 4f 4c 44 2e 74 6f 6f 6c 62 61 72 3d 31 20 41 4e 44 20 4e | arentid).OR.(OLD.toolbar=1.AND.N |
1b00 | 45 57 2e 74 6f 6f 6c 62 61 72 3d 30 29 20 42 45 47 49 4e 20 55 50 44 41 54 45 20 62 6f 6f 6b 6d | EW.toolbar=0).BEGIN.UPDATE.bookm |
1b20 | 61 72 6b 73 20 53 45 54 20 70 6f 73 5f 62 61 72 20 3d 20 4e 55 4c 4c 20 57 48 45 52 45 20 69 64 | arks.SET.pos_bar.=.NULL.WHERE.id |
1b40 | 20 3d 20 4e 45 57 2e 69 64 3b 20 55 50 44 41 54 45 20 62 6f 6f 6b 6d 61 72 6b 73 20 53 45 54 20 | .=.NEW.id;.UPDATE.bookmarks.SET. |
1b60 | 70 6f 73 5f 62 61 72 20 3d 20 70 6f 73 5f 62 61 72 2d 31 20 57 48 45 52 45 20 28 28 4f 4c 44 2e | pos_bar.=.pos_bar-1.WHERE.((OLD. |
1b80 | 70 61 72 65 6e 74 69 64 20 49 53 20 4e 4f 54 20 4e 55 4c 4c 20 41 4e 44 20 70 61 72 65 6e 74 69 | parentid.IS.NOT.NULL.AND.parenti |
1ba0 | 64 20 3d 20 4f 4c 44 2e 70 61 72 65 6e 74 69 64 29 20 4f 52 20 28 4f 4c 44 2e 70 61 72 65 6e 74 | d.=.OLD.parentid).OR.(OLD.parent |
1bc0 | 69 64 20 49 53 20 4e 55 4c 4c 20 41 4e 44 20 70 61 72 65 6e 74 69 64 20 49 53 20 4e 55 4c 4c 29 | id.IS.NULL.AND.parentid.IS.NULL) |
1be0 | 29 20 41 4e 44 20 70 6f 73 5f 62 61 72 20 3e 20 4f 4c 44 2e 70 6f 73 5f 62 61 72 3b 20 45 4e 44 | ).AND.pos_bar.>.OLD.pos_bar;.END |
1c00 | 0d 00 00 00 02 00 7b 00 00 7b 02 c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ......{..{...................... |
1c20 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
1c40 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
1c60 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 84 42 07 07 1b | ............................B... |
1c80 | 37 1f 08 88 39 74 72 69 67 67 65 72 62 6f 6f 6b 6d 61 72 6b 55 70 64 61 74 65 50 6f 73 42 61 72 | 7...9triggerbookmarkUpdatePosBar |
1ca0 | 31 62 6f 6f 6b 6d 61 72 6b 73 43 52 45 41 54 45 20 54 52 49 47 47 45 52 20 62 6f 6f 6b 6d 61 72 | 1bookmarksCREATE.TRIGGER.bookmar |
1cc0 | 6b 55 70 64 61 74 65 50 6f 73 42 61 72 31 20 42 45 46 4f 52 45 20 55 50 44 41 54 45 20 4f 46 20 | kUpdatePosBar1.BEFORE.UPDATE.OF. |
1ce0 | 70 61 72 65 6e 74 69 64 2c 20 74 6f 6f 6c 62 61 72 20 4f 4e 20 62 6f 6f 6b 6d 61 72 6b 73 20 46 | parentid,.toolbar.ON.bookmarks.F |
1d00 | 4f 52 20 45 41 43 48 20 52 4f 57 20 57 48 45 4e 20 28 28 4e 45 57 2e 70 61 72 65 6e 74 69 64 20 | OR.EACH.ROW.WHEN.((NEW.parentid. |
1d20 | 49 53 20 4e 55 4c 4c 20 4f 52 20 4f 4c 44 2e 70 61 72 65 6e 74 69 64 20 49 53 20 4e 55 4c 4c 29 | IS.NULL.OR.OLD.parentid.IS.NULL) |
1d40 | 20 41 4e 44 20 4e 45 57 2e 70 61 72 65 6e 74 69 64 20 49 53 20 4e 4f 54 20 4f 4c 44 2e 70 61 72 | .AND.NEW.parentid.IS.NOT.OLD.par |
1d60 | 65 6e 74 69 64 29 20 4f 52 20 28 28 4e 45 57 2e 70 61 72 65 6e 74 69 64 20 49 53 20 4e 4f 54 20 | entid).OR.((NEW.parentid.IS.NOT. |
1d80 | 4e 55 4c 4c 20 41 4e 44 20 4f 4c 44 2e 70 61 72 65 6e 74 69 64 20 49 53 20 4e 4f 54 20 4e 55 4c | NULL.AND.OLD.parentid.IS.NOT.NUL |
1da0 | 4c 29 20 41 4e 44 20 4e 45 57 2e 70 61 72 65 6e 74 69 64 21 3d 4f 4c 44 2e 70 61 72 65 6e 74 69 | L).AND.NEW.parentid!=OLD.parenti |
1dc0 | 64 29 20 4f 52 20 28 4f 4c 44 2e 74 6f 6f 6c 62 61 72 3d 30 20 41 4e 44 20 4e 45 57 2e 74 6f 6f | d).OR.(OLD.toolbar=0.AND.NEW.too |
1de0 | 6c 62 61 72 3d 31 29 20 42 45 47 49 4e 20 55 50 44 41 54 45 20 62 6f 6f 6b 6d 61 72 6b 73 20 53 | lbar=1).BEGIN.UPDATE.bookmarks.S |
1e00 | 45 54 20 70 6f 73 5f 62 61 72 20 3d 20 28 53 45 4c 45 43 54 20 69 66 6e 75 6c 6c 28 4d 41 58 28 | ET.pos_bar.=.(SELECT.ifnull(MAX( |
1e20 | 70 6f 73 5f 62 61 72 29 2c 30 29 2b 31 20 46 52 4f 4d 20 62 6f 6f 6b 6d 61 72 6b 73 20 57 48 45 | pos_bar),0)+1.FROM.bookmarks.WHE |
1e40 | 52 45 20 28 4e 45 57 2e 70 61 72 65 6e 74 69 64 20 49 53 20 4e 4f 54 20 4e 55 4c 4c 20 41 4e 44 | RE.(NEW.parentid.IS.NOT.NULL.AND |
1e60 | 20 70 61 72 65 6e 74 69 64 20 3d 20 4e 45 57 2e 70 61 72 65 6e 74 69 64 29 20 4f 52 20 28 4e 45 | .parentid.=.NEW.parentid).OR.(NE |
1e80 | 57 2e 70 61 72 65 6e 74 69 64 20 49 53 20 4e 55 4c 4c 20 41 4e 44 20 70 61 72 65 6e 74 69 64 20 | W.parentid.IS.NULL.AND.parentid. |
1ea0 | 49 53 20 4e 55 4c 4c 29 29 20 57 48 45 52 45 20 69 64 20 3d 20 4f 4c 44 2e 69 64 3b 20 45 4e 44 | IS.NULL)).WHERE.id.=.OLD.id;.END |
1ec0 | 82 3d 08 07 1b 39 1f 08 84 2d 74 72 69 67 67 65 72 62 6f 6f 6b 6d 61 72 6b 44 65 6c 65 74 65 50 | .=...9...-triggerbookmarkDeleteP |
1ee0 | 6f 73 50 61 6e 65 6c 62 6f 6f 6b 6d 61 72 6b 73 43 52 45 41 54 45 20 54 52 49 47 47 45 52 20 62 | osPanelbookmarksCREATE.TRIGGER.b |
1f00 | 6f 6f 6b 6d 61 72 6b 44 65 6c 65 74 65 50 6f 73 50 61 6e 65 6c 20 41 46 54 45 52 20 44 45 4c 45 | ookmarkDeletePosPanel.AFTER.DELE |
1f20 | 54 45 20 4f 4e 20 62 6f 6f 6b 6d 61 72 6b 73 20 46 4f 52 20 45 41 43 48 20 52 4f 57 20 42 45 47 | TE.ON.bookmarks.FOR.EACH.ROW.BEG |
1f40 | 49 4e 20 55 50 44 41 54 45 20 62 6f 6f 6b 6d 61 72 6b 73 20 53 45 54 20 70 6f 73 5f 70 61 6e 65 | IN.UPDATE.bookmarks.SET.pos_pane |
1f60 | 6c 20 3d 20 70 6f 73 5f 70 61 6e 65 6c 2d 31 20 57 48 45 52 45 20 28 28 4f 4c 44 2e 70 61 72 65 | l.=.pos_panel-1.WHERE.((OLD.pare |
1f80 | 6e 74 69 64 20 49 53 20 4e 4f 54 20 4e 55 4c 4c 20 41 4e 44 20 70 61 72 65 6e 74 69 64 20 3d 20 | ntid.IS.NOT.NULL.AND.parentid.=. |
1fa0 | 4f 4c 44 2e 70 61 72 65 6e 74 69 64 29 20 4f 52 20 28 4f 4c 44 2e 70 61 72 65 6e 74 69 64 20 49 | OLD.parentid).OR.(OLD.parentid.I |
1fc0 | 53 20 4e 55 4c 4c 20 41 4e 44 20 70 61 72 65 6e 74 69 64 20 49 53 20 4e 55 4c 4c 29 29 20 41 4e | S.NULL.AND.parentid.IS.NULL)).AN |
1fe0 | 44 20 70 6f 73 5f 70 61 6e 65 6c 20 3e 20 4f 4c 44 2e 70 6f 73 5f 70 61 6e 65 6c 3b 20 45 4e 44 | D.pos_panel.>.OLD.pos_panel;.END |
2000 | 0d 00 00 00 01 02 b9 00 02 b9 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
2020 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
2040 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
2060 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
2080 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
20a0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
20c0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
20e0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
2100 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
2120 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
2140 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
2160 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
2180 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
21a0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
21c0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
21e0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
2200 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
2220 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
2240 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
2260 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
2280 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
22a0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 82 44 09 07 1b 35 1f | ..........................D...5. |
22c0 | 08 84 3f 74 72 69 67 67 65 72 62 6f 6f 6b 6d 61 72 6b 44 65 6c 65 74 65 50 6f 73 42 61 72 62 6f | ..?triggerbookmarkDeletePosBarbo |
22e0 | 6f 6b 6d 61 72 6b 73 43 52 45 41 54 45 20 54 52 49 47 47 45 52 20 62 6f 6f 6b 6d 61 72 6b 44 65 | okmarksCREATE.TRIGGER.bookmarkDe |
2300 | 6c 65 74 65 50 6f 73 42 61 72 20 41 46 54 45 52 20 44 45 4c 45 54 45 20 4f 4e 20 62 6f 6f 6b 6d | letePosBar.AFTER.DELETE.ON.bookm |
2320 | 61 72 6b 73 20 46 4f 52 20 45 41 43 48 20 52 4f 57 20 57 48 45 4e 20 4f 4c 44 2e 74 6f 6f 6c 62 | arks.FOR.EACH.ROW.WHEN.OLD.toolb |
2340 | 61 72 3d 31 20 42 45 47 49 4e 20 55 50 44 41 54 45 20 62 6f 6f 6b 6d 61 72 6b 73 20 53 45 54 20 | ar=1.BEGIN.UPDATE.bookmarks.SET. |
2360 | 70 6f 73 5f 62 61 72 20 3d 20 70 6f 73 5f 62 61 72 2d 31 20 57 48 45 52 45 20 28 28 4f 4c 44 2e | pos_bar.=.pos_bar-1.WHERE.((OLD. |
2380 | 70 61 72 65 6e 74 69 64 20 49 53 20 4e 4f 54 20 4e 55 4c 4c 20 41 4e 44 20 70 61 72 65 6e 74 69 | parentid.IS.NOT.NULL.AND.parenti |
23a0 | 64 20 3d 20 4f 4c 44 2e 70 61 72 65 6e 74 69 64 29 20 4f 52 20 28 4f 4c 44 2e 70 61 72 65 6e 74 | d.=.OLD.parentid).OR.(OLD.parent |
23c0 | 69 64 20 49 53 20 4e 55 4c 4c 20 41 4e 44 20 70 61 72 65 6e 74 69 64 20 49 53 20 4e 55 4c 4c 29 | id.IS.NULL.AND.parentid.IS.NULL) |
23e0 | 29 20 41 4e 44 20 70 6f 73 5f 62 61 72 20 3e 20 4f 4c 44 2e 70 6f 73 5f 62 61 72 3b 20 45 4e 44 | ).AND.pos_bar.>.OLD.pos_bar;.END |