| 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 08 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 08 | ................................ |
| 0060 | 00 2d e2 28 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 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 00e0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 0100 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 0120 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 0140 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 0160 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 0180 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 01a0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 01c0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 01e0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 0200 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 0220 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 0240 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 0260 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 0280 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 02a0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 02c0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 02e0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 0300 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 0320 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 0340 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 0360 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 0380 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 03a0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 03c0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 03e0 | 00 00 00 00 00 00 00 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 | ................................ |
| 0400 | 0d 00 00 00 00 04 00 00 00 00 00 00 00 00 00 00 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 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 06c0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 06e0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 0700 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 0720 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 0740 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 0760 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 0780 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 07a0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 07c0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 07e0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 0800 | 0d 00 00 00 00 04 00 00 00 00 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 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 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 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 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 |
 |
index : ~~obsolete/parabolaiso | |
| Unnamed repository; edit this file 'description' to name the repository. | git-mirror |
| summaryrefslogtreecommitdiff |
blob: 5da1c3a379be3f3536cbe9b6dd676171e80dbaf6 (plain)