summaryrefslogtreecommitdiff
path: root/recipes-connectivity/midori/files/bookmarks_v2.db
blob: d7c3a01fbb5b804cbbc7651900f90d5788d65242 (plain)
ofshex dumpascii
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