Skip to content

Instantly share code, notes, and snippets.

@pdp7
Created January 31, 2014 16:21
Show Gist options
  • Save pdp7/8735425 to your computer and use it in GitHub Desktop.
Save pdp7/8735425 to your computer and use it in GitHub Desktop.
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000077492, 77492, 14, 2439, 17405, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 77492 AND containerID = 1; --username=morgaine,max=34964,sum=17559,diff=17405
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000088845, 88845, 14, 2439, 11406, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 88845 AND containerID = 1; --max=22031,sum=10625,diff=11406
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000105738, 105738, 14, 2439, 9474, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 105738 AND containerID = 1; --max=9815,sum=341,diff=9474
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000101345, 101345, 14, 2439, 7344, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 101345 AND containerID = 1; --max=8312,sum=968,diff=7344
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000110377, 110377, 14, 2439, 7256, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 110377 AND containerID = 1; --max=21344,sum=14088,diff=7256
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000004370, 4370, 14, 2439, 5331, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 4370 AND containerID = 1; --max=31812,sum=26481,diff=5331
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000008030, 8030, 14, 2439, 4745, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 8030 AND containerID = 1; --max=55479,sum=50734,diff=4745
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000051424, 51424, 14, 2439, 1569, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 51424 AND containerID = 1; --max=2626,sum=1057,diff=1569
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000157569, 157569, 14, 2439, 1447, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 157569 AND containerID = 1; --max=1613,sum=166,diff=1447
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000110846, 110846, 14, 2439, 1347, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 110846 AND containerID = 1; --max=3180,sum=1833,diff=1347
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000006871, 6871, 14, 2439, 910, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 6871 AND containerID = 1; --max=950,sum=40,diff=910
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000090735, 90735, 14, 2439, 853, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 90735 AND containerID = 1; --max=16407,sum=15554,diff=853
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000005400, 5400, 14, 2439, 809, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 5400 AND containerID = 1; --max=11127,sum=10318,diff=809
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000165261, 165261, 14, 2439, 711, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 165261 AND containerID = 1; --max=1402,sum=691,diff=711
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000103287, 103287, 14, 2439, 610, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 103287 AND containerID = 1; --max=6613,sum=6003,diff=610
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000096482, 96482, 14, 2439, 544, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 96482 AND containerID = 1; --max=585,sum=41,diff=544
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000164926, 164926, 14, 2439, 492, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 164926 AND containerID = 1; --max=588,sum=96,diff=492
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000070130, 70130, 14, 2439, 422, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 70130 AND containerID = 1; --max=1201,sum=779,diff=422
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000081208, 81208, 14, 2439, 414, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 81208 AND containerID = 1; --max=3308,sum=2894,diff=414
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000164807, 164807, 14, 2439, 387, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 164807 AND containerID = 1; --max=1720,sum=1333,diff=387
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000082879, 82879, 14, 2439, 381, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 82879 AND containerID = 1; --max=11678,sum=11297,diff=381
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000051220, 51220, 14, 2439, 374, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 51220 AND containerID = 1; --max=15170,sum=14796,diff=374
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000093737, 93737, 14, 2439, 345, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 93737 AND containerID = 1; --max=2489,sum=2144,diff=345
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000052282, 52282, 14, 2439, 303, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 52282 AND containerID = 1; --max=32773,sum=32470,diff=303
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000151082, 151082, 14, 2439, 296, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 151082 AND containerID = 1; --max=570,sum=274,diff=296
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000113174, 113174, 14, 2439, 254, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 113174 AND containerID = 1; --max=394,sum=140,diff=254
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000054804, 54804, 14, 2439, 251, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 54804 AND containerID = 1; --max=1983,sum=1732,diff=251
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000182877, 182877, 14, 2439, 219, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 182877 AND containerID = 1; --max=255,sum=36,diff=219
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000087467, 87467, 14, 2439, 200, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 87467 AND containerID = 1; --max=216,sum=16,diff=200
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000089726, 89726, 14, 2439, 196, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 89726 AND containerID = 1; --max=4096,sum=3900,diff=196
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000058767, 58767, 14, 2439, 196, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 58767 AND containerID = 1; --max=4651,sum=4455,diff=196
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000035894, 35894, 14, 2439, 195, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 35894 AND containerID = 1; --max=3205,sum=3010,diff=195
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000210154, 210154, 14, 2439, 180, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 210154 AND containerID = 1; --max=384,sum=204,diff=180
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000007800, 7800, 14, 2439, 178, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 7800 AND containerID = 1; --max=232,sum=54,diff=178
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000130730, 130730, 14, 2439, 175, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 130730 AND containerID = 1; --max=374,sum=199,diff=175
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000107572, 107572, 14, 2439, 173, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 107572 AND containerID = 1; --max=317,sum=144,diff=173
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000171175, 171175, 14, 2439, 171, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 171175 AND containerID = 1; --max=227,sum=56,diff=171
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000008027, 8027, 14, 2439, 170, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 8027 AND containerID = 1; --max=12621,sum=12451,diff=170
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000182901, 182901, 14, 2439, 168, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 182901 AND containerID = 1; --max=1217,sum=1049,diff=168
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000217722, 217722, 14, 2439, 120, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 217722 AND containerID = 1; --max=295,sum=175,diff=120
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000216218, 216218, 14, 2439, 120, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 216218 AND containerID = 1; --max=131,sum=11,diff=120
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000085231, 85231, 14, 2439, 120, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 85231 AND containerID = 1; --max=302,sum=182,diff=120
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000127796, 127796, 14, 2439, 110, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 127796 AND containerID = 1; --max=121,sum=11,diff=110
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000117741, 117741, 14, 2439, 104, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 117741 AND containerID = 1; --max=125,sum=21,diff=104
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000182853, 182853, 14, 2439, 101, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 182853 AND containerID = 1; --max=230,sum=129,diff=101
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000119578, 119578, 14, 2439, 97, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 119578 AND containerID = 1; --max=184,sum=87,diff=97
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000228914, 228914, 14, 2439, 95, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 228914 AND containerID = 1; --max=162,sum=67,diff=95
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000091935, 91935, 14, 2439, 90, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 91935 AND containerID = 1; --max=96,sum=6,diff=90
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000096505, 96505, 14, 2439, 89, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 96505 AND containerID = 1; --max=1449,sum=1360,diff=89
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000209641, 209641, 14, 2439, 78, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 209641 AND containerID = 1; --max=153,sum=75,diff=78
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000012726, 12726, 14, 2439, 75, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 12726 AND containerID = 1; --max=1353,sum=1278,diff=75
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000104825, 104825, 14, 2439, 73, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 104825 AND containerID = 1; --max=154,sum=81,diff=73
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000094922, 94922, 14, 2439, 71, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 94922 AND containerID = 1; --max=172,sum=101,diff=71
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000051436, 51436, 14, 2439, 66, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 51436 AND containerID = 1; --max=87,sum=21,diff=66
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000087258, 87258, 14, 2439, 64, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 87258 AND containerID = 1; --max=125,sum=61,diff=64
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000007578, 7578, 14, 2439, 61, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 7578 AND containerID = 1; --max=391,sum=330,diff=61
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000209869, 209869, 14, 2439, 50, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 209869 AND containerID = 1; --max=51,sum=1,diff=50
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000097381, 97381, 14, 2439, 47, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 97381 AND containerID = 1; --max=68,sum=21,diff=47
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000202163, 202163, 14, 2439, 41, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 202163 AND containerID = 1; --max=64,sum=23,diff=41
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000091565, 91565, 14, 2439, 41, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 91565 AND containerID = 1; --max=116,sum=75,diff=41
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000221834, 221834, 14, 2439, 40, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 221834 AND containerID = 1; --max=80,sum=40,diff=40
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000010567, 10567, 14, 2439, 39, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 10567 AND containerID = 1; --max=6667,sum=6628,diff=39
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000215805, 215805, 14, 2439, 38, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 215805 AND containerID = 1; --max=126,sum=88,diff=38
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000208206, 208206, 14, 2439, 37, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 208206 AND containerID = 1; --max=73,sum=36,diff=37
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000144473, 144473, 14, 2439, 37, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 144473 AND containerID = 1; --max=480,sum=443,diff=37
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000065254, 65254, 14, 2439, 33, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 65254 AND containerID = 1; --max=1723,sum=1690,diff=33
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000212162, 212162, 14, 2439, 32, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 212162 AND containerID = 1; --max=1084,sum=1052,diff=32
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000203837, 203837, 14, 2439, 31, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 203837 AND containerID = 1; --max=54,sum=23,diff=31
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000211728, 211728, 14, 2439, 30, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 211728 AND containerID = 1; --max=61,sum=31,diff=30
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000084850, 84850, 14, 2439, 30, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 84850 AND containerID = 1; --max=106,sum=76,diff=30
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000081444, 81444, 14, 2439, 29, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 81444 AND containerID = 1; --max=192,sum=163,diff=29
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000093156, 93156, 14, 2439, 28, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 93156 AND containerID = 1; --max=30,sum=2,diff=28
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000205383, 205383, 14, 2439, 26, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 205383 AND containerID = 1; --max=42,sum=16,diff=26
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000188544, 188544, 14, 2439, 25, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 188544 AND containerID = 1; --max=51,sum=26,diff=25
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000176741, 176741, 14, 2439, 25, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 176741 AND containerID = 1; --max=348,sum=323,diff=25
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000067118, 67118, 14, 2439, 25, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 67118 AND containerID = 1; --max=9835,sum=9810,diff=25
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000223338, 223338, 14, 2439, 23, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 223338 AND containerID = 1; --max=63,sum=40,diff=23
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000054042, 54042, 14, 2439, 23, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 54042 AND containerID = 1; --max=84,sum=61,diff=23
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000221974, 221974, 14, 2439, 22, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 221974 AND containerID = 1; --max=627,sum=605,diff=22
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000179324, 179324, 14, 2439, 21, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 179324 AND containerID = 1; --max=4137,sum=4116,diff=21
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000212379, 212379, 14, 2439, 20, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 212379 AND containerID = 1; --max=26,sum=6,diff=20
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000124038, 124038, 14, 2439, 20, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 124038 AND containerID = 1; --max=41,sum=21,diff=20
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000083274, 83274, 14, 2439, 20, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 83274 AND containerID = 1; --max=41,sum=21,diff=20
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000006742, 6742, 14, 2439, 20, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 6742 AND containerID = 1; --max=641,sum=621,diff=20
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000213744, 213744, 14, 2439, 19, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 213744 AND containerID = 1; --max=212,sum=193,diff=19
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000091711, 91711, 14, 2439, 19, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 91711 AND containerID = 1; --max=30,sum=11,diff=19
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000196357, 196357, 14, 2439, 15, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 196357 AND containerID = 1; --max=76,sum=61,diff=15
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000025845, 25845, 14, 2439, 15, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 25845 AND containerID = 1; --max=18,sum=3,diff=15
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000006311, 6311, 14, 2439, 15, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 6311 AND containerID = 1; --max=95,sum=80,diff=15
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000005158, 5158, 14, 2439, 15, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 5158 AND containerID = 1; --max=1028,sum=1013,diff=15
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000220468, 220468, 14, 2439, 14, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 220468 AND containerID = 1; --max=47,sum=33,diff=14
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000002362, 2362, 14, 2439, 14, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 2362 AND containerID = 1; --max=34,sum=20,diff=14
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000080970, 80970, 14, 2439, 13, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 80970 AND containerID = 1; --max=719,sum=706,diff=13
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000145112, 145112, 14, 2439, 12, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 145112 AND containerID = 1; --max=66,sum=54,diff=12
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000094282, 94282, 14, 2439, 12, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 94282 AND containerID = 1; --max=35,sum=23,diff=12
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000065762, 65762, 14, 2439, 12, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 65762 AND containerID = 1; --max=18,sum=6,diff=12
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000229777, 229777, 14, 2439, 11, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 229777 AND containerID = 1; --max=28,sum=17,diff=11
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000227095, 227095, 14, 2439, 10, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 227095 AND containerID = 1; --max=34,sum=24,diff=10
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000222292, 222292, 14, 2439, 10, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 222292 AND containerID = 1; --max=42,sum=32,diff=10
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000218242, 218242, 14, 2439, 10, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 218242 AND containerID = 1; --max=40,sum=30,diff=10
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000208773, 208773, 14, 2439, 10, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 208773 AND containerID = 1; --max=11,sum=1,diff=10
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000208483, 208483, 14, 2439, 10, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 208483 AND containerID = 1; --max=98,sum=88,diff=10
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000207338, 207338, 14, 2439, 10, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 207338 AND containerID = 1; --max=381,sum=371,diff=10
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000203646, 203646, 14, 2439, 10, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 203646 AND containerID = 1; --max=91,sum=81,diff=10
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000201351, 201351, 14, 2439, 10, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 201351 AND containerID = 1; --max=36,sum=26,diff=10
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000192002, 192002, 14, 2439, 10, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 192002 AND containerID = 1; --max=211,sum=201,diff=10
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000113583, 113583, 14, 2439, 10, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 113583 AND containerID = 1; --max=56,sum=46,diff=10
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000104914, 104914, 14, 2439, 10, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 104914 AND containerID = 1; --max=404,sum=394,diff=10
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000071725, 71725, 14, 2439, 10, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 71725 AND containerID = 1; --max=1705,sum=1695,diff=10
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000057590, 57590, 14, 2439, 10, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 57590 AND containerID = 1; --max=243,sum=233,diff=10
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000056022, 56022, 14, 2439, 10, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 56022 AND containerID = 1; --max=61,sum=51,diff=10
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000052533, 52533, 14, 2439, 10, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 52533 AND containerID = 1; --max=554,sum=544,diff=10
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000022407, 22407, 14, 2439, 10, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 22407 AND containerID = 1; --max=20,sum=10,diff=10
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000086849, 86849, 14, 2439, 8, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 86849 AND containerID = 1; --max=9,sum=1,diff=8
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000134933, 134933, 14, 2439, 7, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 134933 AND containerID = 1; --max=101,sum=94,diff=7
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000097146, 97146, 14, 2439, 7, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 97146 AND containerID = 1; --max=63,sum=56,diff=7
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000052271, 52271, 14, 2439, 6, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 52271 AND containerID = 1; --max=861,sum=855,diff=6
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000176181, 176181, 14, 2439, 5, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 176181 AND containerID = 1; --max=9,sum=4,diff=5
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000226168, 226168, 14, 2439, 2, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 226168 AND containerID = 1; --max=574,sum=572,diff=2
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000209430, 209430, 14, 2439, 2, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 209430 AND containerID = 1; --max=23,sum=21,diff=2
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000188869, 188869, 14, 2439, 2, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 188869 AND containerID = 1; --max=105,sum=103,diff=2
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000167986, 167986, 14, 2439, 2, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 167986 AND containerID = 1; --max=1550,sum=1548,diff=2
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000140739, 140739, 14, 2439, 2, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 140739 AND containerID = 1; --max=4,sum=2,diff=2
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000226296, 226296, 14, 2439, 1, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 226296 AND containerID = 1; --max=2,sum=1,diff=1
INSERT INTO jiveStatusLevelPnt (pointID, userID, containerType, containerID, points, objectType, objectID, code, creationDate) VALUES (999000083415, 83415, 14, 2439, 1, 102, 53274, 'FixForPFPROJ1860', 1391034885567); UPDATE jiveStatusLevelPntSum SET dirty = 1 WHERE userID = 83415 AND containerID = 1; --max=2,sum=1,diff=1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment