Posted to tcl by mjanssen at Mon Jan 28 18:21:19 GMT 2008view raw

  1. $ fossil clone --sqltrace http://fossil-scm.hwaci.com/fossil fossil-co
  2. ATTACH DATABASE 'fossil-co' AS repository
  3. BEGIN
  4. REPLACE INTO config(name,value) VALUES('content-schema','1')
  5. REPLACE INTO config(name,value) VALUES('aux-schema','2006-12-23')
  6. SELECT 1 FROM global_config WHERE name='autosync'
  7. REPLACE INTO config(name,value) VALUES('autosync',1)
  8. SELECT 1 FROM global_config WHERE name='safemerge'
  9. REPLACE INTO config(name,value) VALUES('safemerge',0)
  10. SELECT 1 FROM global_config WHERE name='localauth'
  11. REPLACE INTO config(name,value) VALUES('localauth',0)
  12. SELECT value FROM config WHERE name='default-user'
  13. SELECT value FROM global_config WHERE name='default-user'
  14. INSERT INTO user(login, pw, cap, info)VALUES('Administrator','','s','')
  15. INSERT INTO user(login,pw,cap,info) VALUES('anonymous','anonymous','hjkorw','Anon');
  16. INSERT INTO user(login,pw,cap,info) VALUES('nobody','','jor','Nobody');
  17. SELECT value FROM config WHERE name='default-user'
  18. SELECT value FROM global_config WHERE name='default-user'
  19. SELECT uid, login FROM user WHERE login NOT IN ('anonymous','nobody')
  20. REPLACE INTO config(name,value) VALUES('content-schema','1')
  21. REPLACE INTO config(name,value) VALUES('aux-schema','2006-12-23')
  22. REPLACE INTO config(name,value) VALUES('last-sync-url','http://fossil-scm.hwaci.com/fossil')
  23. INSERT INTO config(name,value) VALUES('server-code', lower(hex(randomblob(20))));
  24. SELECT value FROM config WHERE name='server-code'
  25. SELECT value FROM config WHERE name='project-code'
  26. SELECT value FROM global_config WHERE name='project-code'
  27. SELECT value FROM config WHERE name='max-upload'
  28. SELECT value FROM global_config WHERE name='max-upload'
  29. CREATE TEMP TABLE onremote(rid INTEGER PRIMARY KEY);
  30. SELECT value FROM config WHERE name='cookie'
  31. SELECT value FROM global_config WHERE name='cookie'
  32. SELECT uuid FROM phantom JOIN blob USING(rid) WHERE NOT EXISTS(SELECT 1 FROM shun WHERE uuid=blob.uuid)
  33. Send: 6 bytes, 1 messages, 0 files (0+0)
  34. SELECT pw FROM user WHERE uid=1
  35. REPLACE INTO config(name,value) VALUES('project-code','CE59BB9F186226D80E49D1FA2DB29F935CCA0333')
  36. SELECT 1 FROM blob WHERE uuid='cb8f4040e3b3bc26f188ec4228c8b8e4a3b74b27' AND size>=0
  37. SELECT rid, size FROM blob WHERE uuid='cb8f4040e3b3bc26f188ec4228c8b8e4a3b74b27'
  38. INSERT INTO blob(rcvid,size,uuid,content)VALUES(0,-1,'cb8f4040e3b3bc26f188ec4228c8b8e4a3b74b27',:data)
  39. INSERT OR IGNORE INTO phantom VALUES(1)
  40. INSERT OR IGNORE INTO unclustered VALUES(1)
  41. INSERT OR IGNORE INTO onremote VALUES(1)
  42. SELECT 1 FROM blob WHERE uuid='1b7107cc28dddc37ab00286102b826fb51b14a77' AND size>=0
  43. SELECT rid, size FROM blob WHERE uuid='1b7107cc28dddc37ab00286102b826fb51b14a77'
  44. INSERT INTO blob(rcvid,size,uuid,content)VALUES(0,-1,'1b7107cc28dddc37ab00286102b826fb51b14a77',:data)
  45. INSERT OR IGNORE INTO phantom VALUES(2)
  46. INSERT OR IGNORE INTO unclustered VALUES(2)
  47. INSERT OR IGNORE INTO onremote VALUES(2)
  48. SELECT 1 FROM blob WHERE uuid='bb5f385c20a6dcda261855ed270445a4b4e12ecc' AND size>=0
  49. SELECT rid, size FROM blob WHERE uuid='bb5f385c20a6dcda261855ed270445a4b4e12ecc'
  50. INSERT INTO blob(rcvid,size,uuid,content)VALUES(0,-1,'bb5f385c20a6dcda261855ed270445a4b4e12ecc',:data)
  51. INSERT OR IGNORE INTO phantom VALUES(3)
  52. INSERT OR IGNORE INTO unclustered VALUES(3)
  53. INSERT OR IGNORE INTO onremote VALUES(3)
  54. SELECT 1 FROM blob WHERE uuid='97e0e9dda94ea0fe577408ff08e894f68b9c19c2' AND size>=0
  55. SELECT rid, size FROM blob WHERE uuid='97e0e9dda94ea0fe577408ff08e894f68b9c19c2'
  56. INSERT INTO blob(rcvid,size,uuid,content)VALUES(0,-1,'97e0e9dda94ea0fe577408ff08e894f68b9c19c2',:data)
  57. INSERT OR IGNORE INTO phantom VALUES(4)
  58. INSERT OR IGNORE INTO unclustered VALUES(4)
  59. INSERT OR IGNORE INTO onremote VALUES(4)
  60. SELECT 1 FROM blob WHERE uuid='f56e45ca7ec484ccd8e11e7d08edde2553fb3ecb' AND size>=0
  61. SELECT rid, size FROM blob WHERE uuid='f56e45ca7ec484ccd8e11e7d08edde2553fb3ecb'
  62. INSERT INTO blob(rcvid,size,uuid,content)VALUES(0,-1,'f56e45ca7ec484ccd8e11e7d08edde2553fb3ecb',:data)
  63. INSERT OR IGNORE INTO phantom VALUES(5)
  64. INSERT OR IGNORE INTO unclustered VALUES(5)
  65. INSERT OR IGNORE INTO onremote VALUES(5)
  66. SELECT 1 FROM blob WHERE uuid='808fbc474536c2f5bc5bf912b5212387ea7c2b4f' AND size>=0
  67. SELECT rid, size FROM blob WHERE uuid='808fbc474536c2f5bc5bf912b5212387ea7c2b4f'
  68. INSERT INTO blob(rcvid,size,uuid,content)VALUES(0,-1,'808fbc474536c2f5bc5bf912b5212387ea7c2b4f',:data)
  69. INSERT OR IGNORE INTO phantom VALUES(6)
  70. INSERT OR IGNORE INTO unclustered VALUES(6)
  71. INSERT OR IGNORE INTO onremote VALUES(6)
  72. SELECT 1 FROM blob WHERE uuid='7383c81d45fc3ee64493b995e53e35206bae9201' AND size>=0
  73. SELECT rid, size FROM blob WHERE uuid='7383c81d45fc3ee64493b995e53e35206bae9201'
  74. INSERT INTO blob(rcvid,size,uuid,content)VALUES(0,-1,'7383c81d45fc3ee64493b995e53e35206bae9201',:data)
  75. INSERT OR IGNORE INTO phantom VALUES(7)
  76. INSERT OR IGNORE INTO unclustered VALUES(7)
  77. INSERT OR IGNORE INTO onremote VALUES(7)
  78. SELECT 1 FROM blob WHERE uuid='f7fe15cd0cb6cc28a32cc40c13bb12b9faccd673' AND size>=0
  79. SELECT rid, size FROM blob WHERE uuid='f7fe15cd0cb6cc28a32cc40c13bb12b9faccd673'
  80. INSERT INTO blob(rcvid,size,uuid,content)VALUES(0,-1,'f7fe15cd0cb6cc28a32cc40c13bb12b9faccd673',:data)
  81. INSERT OR IGNORE INTO phantom VALUES(8)
  82. INSERT OR IGNORE INTO unclustered VALUES(8)
  83. INSERT OR IGNORE INTO onremote VALUES(8)
  84. SELECT 1 FROM blob WHERE uuid='a1d2da3e5f367be732ab5c9da0ae0cd912e7c385' AND size>=0
  85. SELECT rid, size FROM blob WHERE uuid='a1d2da3e5f367be732ab5c9da0ae0cd912e7c385'
  86. INSERT INTO blob(rcvid,size,uuid,content)VALUES(0,-1,'a1d2da3e5f367be732ab5c9da0ae0cd912e7c385',:data)
  87. INSERT OR IGNORE INTO phantom VALUES(9)
  88. INSERT OR IGNORE INTO unclustered VALUES(9)
  89. INSERT OR IGNORE INTO onremote VALUES(9)
  90. SELECT 1 FROM blob WHERE uuid='eb98d9f2255dac4dab66734bd1eb5ee5f2bc026e' AND size>=0
  91. SELECT rid, size FROM blob WHERE uuid='eb98d9f2255dac4dab66734bd1eb5ee5f2bc026e'
  92. INSERT INTO blob(rcvid,size,uuid,content)VALUES(0,-1,'eb98d9f2255dac4dab66734bd1eb5ee5f2bc026e',:data)
  93. INSERT OR IGNORE INTO phantom VALUES(10)
  94. INSERT OR IGNORE INTO unclustered VALUES(10)
  95. INSERT OR IGNORE INTO onremote VALUES(10)
  96. SELECT 1 FROM blob WHERE uuid='e15992f475760cdf3a9564d8f88cacb659ab4b07' AND size>=0
  97. SELECT rid, size FROM blob WHERE uuid='e15992f475760cdf3a9564d8f88cacb659ab4b07'
  98. INSERT INTO blob(rcvid,size,uuid,content)VALUES(0,-1,'e15992f475760cdf3a9564d8f88cacb659ab4b07',:data)
  99. INSERT OR IGNORE INTO phantom VALUES(11)
  100. INSERT OR IGNORE INTO unclustered VALUES(11)
  101. INSERT OR IGNORE INTO onremote VALUES(11)
  102. SELECT 1 FROM blob WHERE uuid='db6c6f303b21eceadada9c00063d371dc9f9c481' AND size>=0
  103. SELECT rid, size FROM blob WHERE uuid='db6c6f303b21eceadada9c00063d371dc9f9c481'
  104. INSERT INTO blob(rcvid,size,uuid,content)VALUES(0,-1,'db6c6f303b21eceadada9c00063d371dc9f9c481',:data)
  105. INSERT OR IGNORE INTO phantom VALUES(12)
  106. INSERT OR IGNORE INTO unclustered VALUES(12)
  107. INSERT OR IGNORE INTO onremote VALUES(12)
  108. SELECT 1 FROM blob WHERE uuid='a795dc49f1ddae659feef0e7218c756bb71ba41d' AND size>=0
  109. SELECT rid, size FROM blob WHERE uuid='a795dc49f1ddae659feef0e7218c756bb71ba41d'
  110. INSERT INTO blob(rcvid,size,uuid,content)VALUES(0,-1,'a795dc49f1ddae659feef0e7218c756bb71ba41d',:data)
  111. INSERT OR IGNORE INTO phantom VALUES(13)
  112. INSERT OR IGNORE INTO unclustered VALUES(13)
  113. INSERT OR IGNORE INTO onremote VALUES(13)
  114. SELECT 1 FROM blob WHERE uuid='53c15e41ed45b5d59a34038107c62b8406f393da' AND size>=0
  115. SELECT rid, size FROM blob WHERE uuid='53c15e41ed45b5d59a34038107c62b8406f393da'
  116. INSERT INTO blob(rcvid,size,uuid,content)VALUES(0,-1,'53c15e41ed45b5d59a34038107c62b8406f393da',:data)
  117. INSERT OR IGNORE INTO phantom VALUES(14)
  118. INSERT OR IGNORE INTO unclustered VALUES(14)
  119. INSERT OR IGNORE INTO onremote VALUES(14)
  120. SELECT 1 FROM blob WHERE uuid='80b7efbe0d7c90514a7306c634b2f4daf880c995' AND size>=0
  121. SELECT rid, size FROM blob WHERE uuid='80b7efbe0d7c90514a7306c634b2f4daf880c995'
  122. INSERT INTO blob(rcvid,size,uuid,content)VALUES(0,-1,'80b7efbe0d7c90514a7306c634b2f4daf880c995',:data)
  123. INSERT OR IGNORE INTO phantom VALUES(15)
  124. INSERT OR IGNORE INTO unclustered VALUES(15)
  125. INSERT OR IGNORE INTO onremote VALUES(15)
  126. SELECT 1 FROM blob WHERE uuid='6af8fdc230b34ef61f6baab75a370c2647d8e470' AND size>=0
  127. SELECT rid, size FROM blob WHERE uuid='6af8fdc230b34ef61f6baab75a370c2647d8e470'
  128. INSERT INTO blob(rcvid,size,uuid,content)VALUES(0,-1,'6af8fdc230b34ef61f6baab75a370c2647d8e470',:data)
  129. INSERT OR IGNORE INTO phantom VALUES(16)
  130. INSERT OR IGNORE INTO unclustered VALUES(16)
  131. INSERT OR IGNORE INTO onremote VALUES(16)
  132. SELECT 1 FROM blob WHERE uuid='8de6139917a2fb718bf461b8bff79aae51beab4c' AND size>=0
  133. SELECT rid, size FROM blob WHERE uuid='8de6139917a2fb718bf461b8bff79aae51beab4c'
  134. INSERT INTO blob(rcvid,size,uuid,content)VALUES(0,-1,'8de6139917a2fb718bf461b8bff79aae51beab4c',:data)
  135. INSERT OR IGNORE INTO phantom VALUES(17)
  136. INSERT OR IGNORE INTO unclustered VALUES(17)
  137. INSERT OR IGNORE INTO onremote VALUES(17)
  138. SELECT 1 FROM blob WHERE uuid='08cfcb070657d93c73f2a33f15d9d726182c3eda' AND size>=0
  139. SELECT rid, size FROM blob WHERE uuid='08cfcb070657d93c73f2a33f15d9d726182c3eda'
  140. INSERT INTO blob(rcvid,size,uuid,content)VALUES(0,-1,'08cfcb070657d93c73f2a33f15d9d726182c3eda',:data)
  141. INSERT OR IGNORE INTO phantom VALUES(18)
  142. INSERT OR IGNORE INTO unclustered VALUES(18)
  143. INSERT OR IGNORE INTO onremote VALUES(18)
  144. SELECT 1 FROM blob WHERE uuid='87c45ff178028416d2913fb9c08c3f0bcbd1423f' AND size>=0
  145. SELECT rid, size FROM blob WHERE uuid='87c45ff178028416d2913fb9c08c3f0bcbd1423f'
  146. INSERT INTO blob(rcvid,size,uuid,content)VALUES(0,-1,'87c45ff178028416d2913fb9c08c3f0bcbd1423f',:data)
  147. INSERT OR IGNORE INTO phantom VALUES(19)
  148. INSERT OR IGNORE INTO unclustered VALUES(19)
  149. INSERT OR IGNORE INTO onremote VALUES(19)
  150. SELECT 1 FROM blob WHERE uuid='a9820cd0e44b51ade84f38f88da4a8831cc3e34e' AND size>=0
  151. SELECT rid, size FROM blob WHERE uuid='a9820cd0e44b51ade84f38f88da4a8831cc3e34e'
  152. INSERT INTO blob(rcvid,size,uuid,content)VALUES(0,-1,'a9820cd0e44b51ade84f38f88da4a8831cc3e34e',:data)
  153. INSERT OR IGNORE INTO phantom VALUES(20)
  154. INSERT OR IGNORE INTO unclustered VALUES(20)
  155. INSERT OR IGNORE INTO onremote VALUES(20)
  156. SELECT 1 FROM blob WHERE uuid='6809145eb16fb372e2e15f2dbc76b024db4fd095' AND size>=0
  157. SELECT rid, size FROM blob WHERE uuid='6809145eb16fb372e2e15f2dbc76b024db4fd095'
  158. INSERT INTO blob(rcvid,size,uuid,content)VALUES(0,-1,'6809145eb16fb372e2e15f2dbc76b024db4fd095',:data)
  159. INSERT OR IGNORE INTO phantom VALUES(21)
  160. INSERT OR IGNORE INTO unclustered VALUES(21)
  161. INSERT OR IGNORE INTO onremote VALUES(21)
  162. SELECT 1 FROM blob WHERE uuid='ec6d87872c45f2d466ad310b89d42965bf026dfa' AND size>=0
  163. SELECT rid, size FROM blob WHERE uuid='ec6d87872c45f2d466ad310b89d42965bf026dfa'
  164. INSERT INTO blob(rcvid,size,uuid,content)VALUES(0,-1,'ec6d87872c45f2d466ad310b89d42965bf026dfa',:data)
  165. INSERT OR IGNORE INTO phantom VALUES(22)
  166. INSERT OR IGNORE INTO unclustered VALUES(22)
  167. INSERT OR IGNORE INTO onremote VALUES(22)
  168. SELECT 1 FROM blob WHERE uuid='727f370c2927c0788f0adc64f16d67258b237c34' AND size>=0
  169. SELECT rid, size FROM blob WHERE uuid='727f370c2927c0788f0adc64f16d67258b237c34'
  170. INSERT INTO blob(rcvid,size,uuid,content)VALUES(0,-1,'727f370c2927c0788f0adc64f16d67258b237c34',:data)
  171. INSERT OR IGNORE INTO phantom VALUES(23)
  172. INSERT OR IGNORE INTO unclustered VALUES(23)
  173. INSERT OR IGNORE INTO onremote VALUES(23)
  174. SELECT 1 FROM blob WHERE uuid='f9acec5443fd63bd4d01a1a341e27b5eac09596a' AND size>=0
  175. SELECT rid, size FROM blob WHERE uuid='f9acec5443fd63bd4d01a1a341e27b5eac09596a'
  176. INSERT INTO blob(rcvid,size,uuid,content)VALUES(0,-1,'f9acec5443fd63bd4d01a1a341e27b5eac09596a',:data)
  177. INSERT OR IGNORE INTO phantom VALUES(24)
  178. INSERT OR IGNORE INTO unclustered VALUES(24)
  179. INSERT OR IGNORE INTO onremote VALUES(24)
  180. SELECT 1 FROM blob WHERE uuid='0adaabf11231d63b5ded188dc7fe95d987257a88' AND size>=0
  181. SELECT rid, size FROM blob WHERE uuid='0adaabf11231d63b5ded188dc7fe95d987257a88'
  182. INSERT INTO blob(rcvid,size,uuid,content)VALUES(0,-1,'0adaabf11231d63b5ded188dc7fe95d987257a88',:data)
  183. INSERT OR IGNORE INTO phantom VALUES(25)
  184. INSERT OR IGNORE INTO unclustered VALUES(25)
  185. INSERT OR IGNORE INTO onremote VALUES(25)
  186. SELECT 1 FROM blob WHERE uuid='139ee190b530b01a248101b5b7259190566e24f3' AND size>=0
  187. SELECT rid, size FROM blob WHERE uuid='139ee190b530b01a248101b5b7259190566e24f3'
  188. INSERT INTO blob(rcvid,size,uuid,content)VALUES(0,-1,'139ee190b530b01a248101b5b7259190566e24f3',:data)
  189. INSERT OR IGNORE INTO phantom VALUES(26)
  190. INSERT OR IGNORE INTO unclustered VALUES(26)
  191. INSERT OR IGNORE INTO onremote VALUES(26)
  192. SELECT 1 FROM blob WHERE uuid='d3aa33884b6ce408dc8ad45fa2a28a43fbc788ac' AND size>=0
  193. SELECT rid, size FROM blob WHERE uuid='d3aa33884b6ce408dc8ad45fa2a28a43fbc788ac'
  194. INSERT INTO blob(rcvid,size,uuid,content)VALUES(0,-1,'d3aa33884b6ce408dc8ad45fa2a28a43fbc788ac',:data)
  195. INSERT OR IGNORE INTO phantom VALUES(27)
  196. INSERT OR IGNORE INTO unclustered VALUES(27)
  197. INSERT OR IGNORE INTO onremote VALUES(27)
  198. SELECT 1 FROM blob WHERE uuid='928c3acc9184fb994e891c613f90d942c4c134d1' AND size>=0
  199. SELECT rid, size FROM blob WHERE uuid='928c3acc9184fb994e891c613f90d942c4c134d1'
  200. INSERT INTO blob(rcvid,size,uuid,content)VALUES(0,-1,'928c3acc9184fb994e891c613f90d942c4c134d1',:data)
  201. INSERT OR IGNORE INTO phantom VALUES(28)
  202. INSERT OR IGNORE INTO unclustered VALUES(28)
  203. INSERT OR IGNORE INTO onremote VALUES(28)
  204. SELECT 1 FROM blob WHERE uuid='970be48fce64bb2aeca497ef96d8d8989bf0d936' AND size>=0
  205. SELECT rid, size FROM blob WHERE uuid='970be48fce64bb2aeca497ef96d8d8989bf0d936'
  206. INSERT INTO blob(rcvid,size,uuid,content)VALUES(0,-1,'970be48fce64bb2aeca497ef96d8d8989bf0d936',:data)
  207. INSERT OR IGNORE INTO phantom VALUES(29)
  208. INSERT OR IGNORE INTO unclustered VALUES(29)
  209. INSERT OR IGNORE INTO onremote VALUES(29)
  210. SELECT 1 FROM blob WHERE uuid='01daf9fb8c586e98d352884a2e5f4101389adcf6' AND size>=0
  211. SELECT rid, size FROM blob WHERE uuid='01daf9fb8c586e98d352884a2e5f4101389adcf6'
  212. INSERT INTO blob(rcvid,size,uuid,content)VALUES(0,-1,'01daf9fb8c586e98d352884a2e5f4101389adcf6',:data)
  213. INSERT OR IGNORE INTO phantom VALUES(30)
  214. INSERT OR IGNORE INTO unclustered VALUES(30)
  215. INSERT OR IGNORE INTO onremote VALUES(30)
  216. SELECT 1 FROM blob WHERE uuid='e60ba158215dea5ca57084010bea46b6b36ee425' AND size>=0
  217. SELECT rid, size FROM blob WHERE uuid='e60ba158215dea5ca57084010bea46b6b36ee425'
  218. INSERT INTO blob(rcvid,size,uuid,content)VALUES(0,-1,'e60ba158215dea5ca57084010bea46b6b36ee425',:data)
  219. INSERT OR IGNORE INTO phantom VALUES(31)
  220. INSERT OR IGNORE INTO unclustered VALUES(31)
  221. INSERT OR IGNORE INTO onremote VALUES(31)
  222. Received: 1513 bytes, 33 messages, 0 files (0+0+0)
  223. SELECT 1 FROM phantom
  224. SELECT value FROM config WHERE name='cookie'
  225. SELECT value FROM global_config WHERE name='cookie'
  226. SELECT uuid FROM phantom JOIN blob USING(rid) WHERE NOT EXISTS(SELECT 1 FROM shun WHERE uuid=blob.uuid)
  227. Send: 1463 bytes, 31 messages, 0 files (0+0)
  228. SELECT pw FROM user WHERE uid=1
  229. SELECT 1 FROM shun WHERE uuid='cb8f4040e3b3bc26f188ec4228c8b8e4a3b74b27'
  230. SELECT rid, size FROM blob WHERE uuid='cb8f4040e3b3bc26f188ec4228c8b8e4a3b74b27'
  231. INSERT INTO rcvfrom(uid, mtime, nonce, ipaddr)VALUES(1, julianday('now'), NULL, '67.18.92.124')
  232. UPDATE blob SET rcvid=1, size=4421, content=:data WHERE rid=1
  233. DELETE FROM phantom WHERE rid=1
  234. SELECT rid FROM delta WHERE srcid=1
  235. SELECT rid FROM blob WHERE uuid='04dc95a1eba04a6241eccd0626ef7dc4a2bf7154'
  236. SELECT rid, size FROM blob WHERE uuid='04dc95a1eba04a6241eccd0626ef7dc4a2bf7154'
  237. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'04dc95a1eba04a6241eccd0626ef7dc4a2bf7154',:data)
  238. INSERT OR IGNORE INTO phantom VALUES(32)
  239. INSERT OR IGNORE INTO unclustered VALUES(32)
  240. DELETE FROM unclustered WHERE rid=32
  241. SELECT rid FROM blob WHERE uuid='060513f2a9d9794936741279999fb6266b03032f'
  242. SELECT rid, size FROM blob WHERE uuid='060513f2a9d9794936741279999fb6266b03032f'
  243. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'060513f2a9d9794936741279999fb6266b03032f',:data)
  244. INSERT OR IGNORE INTO phantom VALUES(33)
  245. INSERT OR IGNORE INTO unclustered VALUES(33)
  246. DELETE FROM unclustered WHERE rid=33
  247. SELECT rid FROM blob WHERE uuid='07887bbda89f650ab1b7c76fd97bf6b33fa041eb'
  248. SELECT rid, size FROM blob WHERE uuid='07887bbda89f650ab1b7c76fd97bf6b33fa041eb'
  249. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'07887bbda89f650ab1b7c76fd97bf6b33fa041eb',:data)
  250. INSERT OR IGNORE INTO phantom VALUES(34)
  251. INSERT OR IGNORE INTO unclustered VALUES(34)
  252. DELETE FROM unclustered WHERE rid=34
  253. SELECT rid FROM blob WHERE uuid='08f8085700fef9944101ad38f239acfb7ad3b192'
  254. SELECT rid, size FROM blob WHERE uuid='08f8085700fef9944101ad38f239acfb7ad3b192'
  255. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'08f8085700fef9944101ad38f239acfb7ad3b192',:data)
  256. INSERT OR IGNORE INTO phantom VALUES(35)
  257. INSERT OR IGNORE INTO unclustered VALUES(35)
  258. DELETE FROM unclustered WHERE rid=35
  259. SELECT rid FROM blob WHERE uuid='0a082ba7c7e0bbc5008c8054ab65e71a3d741ec2'
  260. SELECT rid, size FROM blob WHERE uuid='0a082ba7c7e0bbc5008c8054ab65e71a3d741ec2'
  261. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'0a082ba7c7e0bbc5008c8054ab65e71a3d741ec2',:data)
  262. INSERT OR IGNORE INTO phantom VALUES(36)
  263. INSERT OR IGNORE INTO unclustered VALUES(36)
  264. DELETE FROM unclustered WHERE rid=36
  265. SELECT rid FROM blob WHERE uuid='0ee9711e2e4cc2bf754951a1f4ab156f927be865'
  266. SELECT rid, size FROM blob WHERE uuid='0ee9711e2e4cc2bf754951a1f4ab156f927be865'
  267. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'0ee9711e2e4cc2bf754951a1f4ab156f927be865',:data)
  268. INSERT OR IGNORE INTO phantom VALUES(37)
  269. INSERT OR IGNORE INTO unclustered VALUES(37)
  270. DELETE FROM unclustered WHERE rid=37
  271. SELECT rid FROM blob WHERE uuid='12046e11b2f0a29885e378f73a59c9bb7a5d5e5a'
  272. SELECT rid, size FROM blob WHERE uuid='12046e11b2f0a29885e378f73a59c9bb7a5d5e5a'
  273. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'12046e11b2f0a29885e378f73a59c9bb7a5d5e5a',:data)
  274. INSERT OR IGNORE INTO phantom VALUES(38)
  275. INSERT OR IGNORE INTO unclustered VALUES(38)
  276. DELETE FROM unclustered WHERE rid=38
  277. SELECT rid FROM blob WHERE uuid='15271012d788c088df754658468db43f91900ee1'
  278. SELECT rid, size FROM blob WHERE uuid='15271012d788c088df754658468db43f91900ee1'
  279. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'15271012d788c088df754658468db43f91900ee1',:data)
  280. INSERT OR IGNORE INTO phantom VALUES(39)
  281. INSERT OR IGNORE INTO unclustered VALUES(39)
  282. DELETE FROM unclustered WHERE rid=39
  283. SELECT rid FROM blob WHERE uuid='15df8101524f815ebb17242245ecbb9446e3bb44'
  284. SELECT rid, size FROM blob WHERE uuid='15df8101524f815ebb17242245ecbb9446e3bb44'
  285. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'15df8101524f815ebb17242245ecbb9446e3bb44',:data)
  286. INSERT OR IGNORE INTO phantom VALUES(40)
  287. INSERT OR IGNORE INTO unclustered VALUES(40)
  288. DELETE FROM unclustered WHERE rid=40
  289. SELECT rid FROM blob WHERE uuid='1601bf3ce0199a486bdaaf3cb569da4c2775c1dc'
  290. SELECT rid, size FROM blob WHERE uuid='1601bf3ce0199a486bdaaf3cb569da4c2775c1dc'
  291. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'1601bf3ce0199a486bdaaf3cb569da4c2775c1dc',:data)
  292. INSERT OR IGNORE INTO phantom VALUES(41)
  293. INSERT OR IGNORE INTO unclustered VALUES(41)
  294. DELETE FROM unclustered WHERE rid=41
  295. SELECT rid FROM blob WHERE uuid='16fbb59b96bd8731edd17d952c11fd31e78e1a43'
  296. SELECT rid, size FROM blob WHERE uuid='16fbb59b96bd8731edd17d952c11fd31e78e1a43'
  297. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'16fbb59b96bd8731edd17d952c11fd31e78e1a43',:data)
  298. INSERT OR IGNORE INTO phantom VALUES(42)
  299. INSERT OR IGNORE INTO unclustered VALUES(42)
  300. DELETE FROM unclustered WHERE rid=42
  301. SELECT rid FROM blob WHERE uuid='18fbb9c52d0ff928fc7ddbb85233e2ce4c396aca'
  302. SELECT rid, size FROM blob WHERE uuid='18fbb9c52d0ff928fc7ddbb85233e2ce4c396aca'
  303. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'18fbb9c52d0ff928fc7ddbb85233e2ce4c396aca',:data)
  304. INSERT OR IGNORE INTO phantom VALUES(43)
  305. INSERT OR IGNORE INTO unclustered VALUES(43)
  306. DELETE FROM unclustered WHERE rid=43
  307. SELECT rid FROM blob WHERE uuid='1a20a81f33681c6a06a36e149567b80b350ad9c9'
  308. SELECT rid, size FROM blob WHERE uuid='1a20a81f33681c6a06a36e149567b80b350ad9c9'
  309. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'1a20a81f33681c6a06a36e149567b80b350ad9c9',:data)
  310. INSERT OR IGNORE INTO phantom VALUES(44)
  311. INSERT OR IGNORE INTO unclustered VALUES(44)
  312. DELETE FROM unclustered WHERE rid=44
  313. SELECT rid FROM blob WHERE uuid='1ea5bdca20350ae0b0f2ddcef8ec602e0839cfef'
  314. SELECT rid, size FROM blob WHERE uuid='1ea5bdca20350ae0b0f2ddcef8ec602e0839cfef'
  315. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'1ea5bdca20350ae0b0f2ddcef8ec602e0839cfef',:data)
  316. INSERT OR IGNORE INTO phantom VALUES(45)
  317. INSERT OR IGNORE INTO unclustered VALUES(45)
  318. DELETE FROM unclustered WHERE rid=45
  319. SELECT rid FROM blob WHERE uuid='1f8711cf17b684cf2893bdcde310ae1601e2d181'
  320. SELECT rid, size FROM blob WHERE uuid='1f8711cf17b684cf2893bdcde310ae1601e2d181'
  321. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'1f8711cf17b684cf2893bdcde310ae1601e2d181',:data)
  322. INSERT OR IGNORE INTO phantom VALUES(46)
  323. INSERT OR IGNORE INTO unclustered VALUES(46)
  324. DELETE FROM unclustered WHERE rid=46
  325. SELECT rid FROM blob WHERE uuid='20553a420cb6c453a82924e8edbe11b0f0cbbf40'
  326. SELECT rid, size FROM blob WHERE uuid='20553a420cb6c453a82924e8edbe11b0f0cbbf40'
  327. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'20553a420cb6c453a82924e8edbe11b0f0cbbf40',:data)
  328. INSERT OR IGNORE INTO phantom VALUES(47)
  329. INSERT OR IGNORE INTO unclustered VALUES(47)
  330. DELETE FROM unclustered WHERE rid=47
  331. SELECT rid FROM blob WHERE uuid='229050721f10aa7c9a12a1fdb0c4ea96cfc33494'
  332. SELECT rid, size FROM blob WHERE uuid='229050721f10aa7c9a12a1fdb0c4ea96cfc33494'
  333. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'229050721f10aa7c9a12a1fdb0c4ea96cfc33494',:data)
  334. INSERT OR IGNORE INTO phantom VALUES(48)
  335. INSERT OR IGNORE INTO unclustered VALUES(48)
  336. DELETE FROM unclustered WHERE rid=48
  337. SELECT rid FROM blob WHERE uuid='28af7570f15551cb5edce769100f4145c8424612'
  338. SELECT rid, size FROM blob WHERE uuid='28af7570f15551cb5edce769100f4145c8424612'
  339. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'28af7570f15551cb5edce769100f4145c8424612',:data)
  340. INSERT OR IGNORE INTO phantom VALUES(49)
  341. INSERT OR IGNORE INTO unclustered VALUES(49)
  342. DELETE FROM unclustered WHERE rid=49
  343. SELECT rid FROM blob WHERE uuid='2edf9bde578614e292ace9fbbd5daab36e491e7a'
  344. SELECT rid, size FROM blob WHERE uuid='2edf9bde578614e292ace9fbbd5daab36e491e7a'
  345. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'2edf9bde578614e292ace9fbbd5daab36e491e7a',:data)
  346. INSERT OR IGNORE INTO phantom VALUES(50)
  347. INSERT OR IGNORE INTO unclustered VALUES(50)
  348. DELETE FROM unclustered WHERE rid=50
  349. SELECT rid FROM blob WHERE uuid='368156861d49a97d7b41576a3f3f633381653104'
  350. SELECT rid, size FROM blob WHERE uuid='368156861d49a97d7b41576a3f3f633381653104'
  351. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'368156861d49a97d7b41576a3f3f633381653104',:data)
  352. INSERT OR IGNORE INTO phantom VALUES(51)
  353. INSERT OR IGNORE INTO unclustered VALUES(51)
  354. DELETE FROM unclustered WHERE rid=51
  355. SELECT rid FROM blob WHERE uuid='36f1bd89218a9679207c375df1f66287f2aca21c'
  356. SELECT rid, size FROM blob WHERE uuid='36f1bd89218a9679207c375df1f66287f2aca21c'
  357. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'36f1bd89218a9679207c375df1f66287f2aca21c',:data)
  358. INSERT OR IGNORE INTO phantom VALUES(52)
  359. INSERT OR IGNORE INTO unclustered VALUES(52)
  360. DELETE FROM unclustered WHERE rid=52
  361. SELECT rid FROM blob WHERE uuid='371dd6574c3aa26439bb597f9bd69f0a88e7b3f5'
  362. SELECT rid, size FROM blob WHERE uuid='371dd6574c3aa26439bb597f9bd69f0a88e7b3f5'
  363. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'371dd6574c3aa26439bb597f9bd69f0a88e7b3f5',:data)
  364. INSERT OR IGNORE INTO phantom VALUES(53)
  365. INSERT OR IGNORE INTO unclustered VALUES(53)
  366. DELETE FROM unclustered WHERE rid=53
  367. SELECT rid FROM blob WHERE uuid='3c0ef2c3799a576cd72e0240545289d6e383225e'
  368. SELECT rid, size FROM blob WHERE uuid='3c0ef2c3799a576cd72e0240545289d6e383225e'
  369. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'3c0ef2c3799a576cd72e0240545289d6e383225e',:data)
  370. INSERT OR IGNORE INTO phantom VALUES(54)
  371. INSERT OR IGNORE INTO unclustered VALUES(54)
  372. DELETE FROM unclustered WHERE rid=54
  373. SELECT rid FROM blob WHERE uuid='3f3d02eb9464a3b590257b442f20a3e9c9a57ad4'
  374. SELECT rid, size FROM blob WHERE uuid='3f3d02eb9464a3b590257b442f20a3e9c9a57ad4'
  375. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'3f3d02eb9464a3b590257b442f20a3e9c9a57ad4',:data)
  376. INSERT OR IGNORE INTO phantom VALUES(55)
  377. INSERT OR IGNORE INTO unclustered VALUES(55)
  378. DELETE FROM unclustered WHERE rid=55
  379. SELECT rid FROM blob WHERE uuid='44f7ae687cb0fc07949bf6dc8caab7ea50985dd3'
  380. SELECT rid, size FROM blob WHERE uuid='44f7ae687cb0fc07949bf6dc8caab7ea50985dd3'
  381. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'44f7ae687cb0fc07949bf6dc8caab7ea50985dd3',:data)
  382. INSERT OR IGNORE INTO phantom VALUES(56)
  383. INSERT OR IGNORE INTO unclustered VALUES(56)
  384. DELETE FROM unclustered WHERE rid=56
  385. SELECT rid FROM blob WHERE uuid='490b79f397c887c6d5a94f3678f951000d202975'
  386. SELECT rid, size FROM blob WHERE uuid='490b79f397c887c6d5a94f3678f951000d202975'
  387. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'490b79f397c887c6d5a94f3678f951000d202975',:data)
  388. INSERT OR IGNORE INTO phantom VALUES(57)
  389. INSERT OR IGNORE INTO unclustered VALUES(57)
  390. DELETE FROM unclustered WHERE rid=57
  391. SELECT rid FROM blob WHERE uuid='4abbbbdcddcdb207f30f8ccc074e36d1029561d6'
  392. SELECT rid, size FROM blob WHERE uuid='4abbbbdcddcdb207f30f8ccc074e36d1029561d6'
  393. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'4abbbbdcddcdb207f30f8ccc074e36d1029561d6',:data)
  394. INSERT OR IGNORE INTO phantom VALUES(58)
  395. INSERT OR IGNORE INTO unclustered VALUES(58)
  396. DELETE FROM unclustered WHERE rid=58
  397. SELECT rid FROM blob WHERE uuid='4af951798271e71f10805c516b9b224bccf171f4'
  398. SELECT rid, size FROM blob WHERE uuid='4af951798271e71f10805c516b9b224bccf171f4'
  399. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'4af951798271e71f10805c516b9b224bccf171f4',:data)
  400. INSERT OR IGNORE INTO phantom VALUES(59)
  401. INSERT OR IGNORE INTO unclustered VALUES(59)
  402. DELETE FROM unclustered WHERE rid=59
  403. SELECT rid FROM blob WHERE uuid='50ae29e5d87a2f84e1604daab40cf24f8d9573fb'
  404. SELECT rid, size FROM blob WHERE uuid='50ae29e5d87a2f84e1604daab40cf24f8d9573fb'
  405. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'50ae29e5d87a2f84e1604daab40cf24f8d9573fb',:data)
  406. INSERT OR IGNORE INTO phantom VALUES(60)
  407. INSERT OR IGNORE INTO unclustered VALUES(60)
  408. DELETE FROM unclustered WHERE rid=60
  409. SELECT rid FROM blob WHERE uuid='5249ff2f884de82f9bed8490119e4e99a01df759'
  410. SELECT rid, size FROM blob WHERE uuid='5249ff2f884de82f9bed8490119e4e99a01df759'
  411. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'5249ff2f884de82f9bed8490119e4e99a01df759',:data)
  412. INSERT OR IGNORE INTO phantom VALUES(61)
  413. INSERT OR IGNORE INTO unclustered VALUES(61)
  414. DELETE FROM unclustered WHERE rid=61
  415. SELECT rid FROM blob WHERE uuid='5435deb8410083ce4a3920403f72e7f99e89cd03'
  416. SELECT rid, size FROM blob WHERE uuid='5435deb8410083ce4a3920403f72e7f99e89cd03'
  417. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'5435deb8410083ce4a3920403f72e7f99e89cd03',:data)
  418. INSERT OR IGNORE INTO phantom VALUES(62)
  419. INSERT OR IGNORE INTO unclustered VALUES(62)
  420. DELETE FROM unclustered WHERE rid=62
  421. SELECT rid FROM blob WHERE uuid='565865cf886e13041e87b76bfdb52b1d4d24dcbf'
  422. SELECT rid, size FROM blob WHERE uuid='565865cf886e13041e87b76bfdb52b1d4d24dcbf'
  423. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'565865cf886e13041e87b76bfdb52b1d4d24dcbf',:data)
  424. INSERT OR IGNORE INTO phantom VALUES(63)
  425. INSERT OR IGNORE INTO unclustered VALUES(63)
  426. DELETE FROM unclustered WHERE rid=63
  427. SELECT rid FROM blob WHERE uuid='5721cadfcc1ec2ad857b156ebf22d45d3a21d437'
  428. SELECT rid, size FROM blob WHERE uuid='5721cadfcc1ec2ad857b156ebf22d45d3a21d437'
  429. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'5721cadfcc1ec2ad857b156ebf22d45d3a21d437',:data)
  430. INSERT OR IGNORE INTO phantom VALUES(64)
  431. INSERT OR IGNORE INTO unclustered VALUES(64)
  432. DELETE FROM unclustered WHERE rid=64
  433. SELECT rid FROM blob WHERE uuid='59c3833ae178d91df5e3c8bc3aed00869969e9aa'
  434. SELECT rid, size FROM blob WHERE uuid='59c3833ae178d91df5e3c8bc3aed00869969e9aa'
  435. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'59c3833ae178d91df5e3c8bc3aed00869969e9aa',:data)
  436. INSERT OR IGNORE INTO phantom VALUES(65)
  437. INSERT OR IGNORE INTO unclustered VALUES(65)
  438. DELETE FROM unclustered WHERE rid=65
  439. SELECT rid FROM blob WHERE uuid='59ef48a9b8851e680f238e1243e86c05a81428c8'
  440. SELECT rid, size FROM blob WHERE uuid='59ef48a9b8851e680f238e1243e86c05a81428c8'
  441. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'59ef48a9b8851e680f238e1243e86c05a81428c8',:data)
  442. INSERT OR IGNORE INTO phantom VALUES(66)
  443. INSERT OR IGNORE INTO unclustered VALUES(66)
  444. DELETE FROM unclustered WHERE rid=66
  445. SELECT rid FROM blob WHERE uuid='5b2d15f18356351f18a69fa57f148971dc770e62'
  446. SELECT rid, size FROM blob WHERE uuid='5b2d15f18356351f18a69fa57f148971dc770e62'
  447. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'5b2d15f18356351f18a69fa57f148971dc770e62',:data)
  448. INSERT OR IGNORE INTO phantom VALUES(67)
  449. INSERT OR IGNORE INTO unclustered VALUES(67)
  450. DELETE FROM unclustered WHERE rid=67
  451. SELECT rid FROM blob WHERE uuid='5bb47f2e683e7118cdd1199256b85a82a80c6e66'
  452. SELECT rid, size FROM blob WHERE uuid='5bb47f2e683e7118cdd1199256b85a82a80c6e66'
  453. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'5bb47f2e683e7118cdd1199256b85a82a80c6e66',:data)
  454. INSERT OR IGNORE INTO phantom VALUES(68)
  455. INSERT OR IGNORE INTO unclustered VALUES(68)
  456. DELETE FROM unclustered WHERE rid=68
  457. SELECT rid FROM blob WHERE uuid='5ff9bfc14734487793d3335341f30b0c1a2e37be'
  458. SELECT rid, size FROM blob WHERE uuid='5ff9bfc14734487793d3335341f30b0c1a2e37be'
  459. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'5ff9bfc14734487793d3335341f30b0c1a2e37be',:data)
  460. INSERT OR IGNORE INTO phantom VALUES(69)
  461. INSERT OR IGNORE INTO unclustered VALUES(69)
  462. DELETE FROM unclustered WHERE rid=69
  463. SELECT rid FROM blob WHERE uuid='6518936d0c3152fb53024c91aa587de15b354262'
  464. SELECT rid, size FROM blob WHERE uuid='6518936d0c3152fb53024c91aa587de15b354262'
  465. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'6518936d0c3152fb53024c91aa587de15b354262',:data)
  466. INSERT OR IGNORE INTO phantom VALUES(70)
  467. INSERT OR IGNORE INTO unclustered VALUES(70)
  468. DELETE FROM unclustered WHERE rid=70
  469. SELECT rid FROM blob WHERE uuid='676d19419e60b2c5516d86436ad58d06c5c8b2a9'
  470. SELECT rid, size FROM blob WHERE uuid='676d19419e60b2c5516d86436ad58d06c5c8b2a9'
  471. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'676d19419e60b2c5516d86436ad58d06c5c8b2a9',:data)
  472. INSERT OR IGNORE INTO phantom VALUES(71)
  473. INSERT OR IGNORE INTO unclustered VALUES(71)
  474. DELETE FROM unclustered WHERE rid=71
  475. SELECT rid FROM blob WHERE uuid='6d553315880f6054c1bf453a26a91732cc1dc504'
  476. SELECT rid, size FROM blob WHERE uuid='6d553315880f6054c1bf453a26a91732cc1dc504'
  477. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'6d553315880f6054c1bf453a26a91732cc1dc504',:data)
  478. INSERT OR IGNORE INTO phantom VALUES(72)
  479. INSERT OR IGNORE INTO unclustered VALUES(72)
  480. DELETE FROM unclustered WHERE rid=72
  481. SELECT rid FROM blob WHERE uuid='6d7e82940621f9e9bbe77cf929469fc35329fbf0'
  482. SELECT rid, size FROM blob WHERE uuid='6d7e82940621f9e9bbe77cf929469fc35329fbf0'
  483. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'6d7e82940621f9e9bbe77cf929469fc35329fbf0',:data)
  484. INSERT OR IGNORE INTO phantom VALUES(73)
  485. INSERT OR IGNORE INTO unclustered VALUES(73)
  486. DELETE FROM unclustered WHERE rid=73
  487. SELECT rid FROM blob WHERE uuid='6e1ccf1f24809c1a4ea99eb91e7fc9033486b3dd'
  488. SELECT rid, size FROM blob WHERE uuid='6e1ccf1f24809c1a4ea99eb91e7fc9033486b3dd'
  489. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'6e1ccf1f24809c1a4ea99eb91e7fc9033486b3dd',:data)
  490. INSERT OR IGNORE INTO phantom VALUES(74)
  491. INSERT OR IGNORE INTO unclustered VALUES(74)
  492. DELETE FROM unclustered WHERE rid=74
  493. SELECT rid FROM blob WHERE uuid='6f1c4424b4d53322ece0345231e1358b7f912849'
  494. SELECT rid, size FROM blob WHERE uuid='6f1c4424b4d53322ece0345231e1358b7f912849'
  495. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'6f1c4424b4d53322ece0345231e1358b7f912849',:data)
  496. INSERT OR IGNORE INTO phantom VALUES(75)
  497. INSERT OR IGNORE INTO unclustered VALUES(75)
  498. DELETE FROM unclustered WHERE rid=75
  499. SELECT rid FROM blob WHERE uuid='6f6c62303afeab9c319cc63de0ae84cd1618f18c'
  500. SELECT rid, size FROM blob WHERE uuid='6f6c62303afeab9c319cc63de0ae84cd1618f18c'
  501. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'6f6c62303afeab9c319cc63de0ae84cd1618f18c',:data)
  502. INSERT OR IGNORE INTO phantom VALUES(76)
  503. INSERT OR IGNORE INTO unclustered VALUES(76)
  504. DELETE FROM unclustered WHERE rid=76
  505. SELECT rid FROM blob WHERE uuid='711e000206259f355854b886f14b25e6d9601389'
  506. SELECT rid, size FROM blob WHERE uuid='711e000206259f355854b886f14b25e6d9601389'
  507. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'711e000206259f355854b886f14b25e6d9601389',:data)
  508. INSERT OR IGNORE INTO phantom VALUES(77)
  509. INSERT OR IGNORE INTO unclustered VALUES(77)
  510. DELETE FROM unclustered WHERE rid=77
  511. SELECT rid FROM blob WHERE uuid='773050316bf1ec612989f087ded00ff4d4298f41'
  512. SELECT rid, size FROM blob WHERE uuid='773050316bf1ec612989f087ded00ff4d4298f41'
  513. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'773050316bf1ec612989f087ded00ff4d4298f41',:data)
  514. INSERT OR IGNORE INTO phantom VALUES(78)
  515. INSERT OR IGNORE INTO unclustered VALUES(78)
  516. DELETE FROM unclustered WHERE rid=78
  517. SELECT rid FROM blob WHERE uuid='7bea1e82e636be48b0ac405b9fb5ab23131c931d'
  518. SELECT rid, size FROM blob WHERE uuid='7bea1e82e636be48b0ac405b9fb5ab23131c931d'
  519. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'7bea1e82e636be48b0ac405b9fb5ab23131c931d',:data)
  520. INSERT OR IGNORE INTO phantom VALUES(79)
  521. INSERT OR IGNORE INTO unclustered VALUES(79)
  522. DELETE FROM unclustered WHERE rid=79
  523. SELECT rid FROM blob WHERE uuid='7e073778fc4cfbb9c4db7ec4369c1befe7eb5a90'
  524. SELECT rid, size FROM blob WHERE uuid='7e073778fc4cfbb9c4db7ec4369c1befe7eb5a90'
  525. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'7e073778fc4cfbb9c4db7ec4369c1befe7eb5a90',:data)
  526. INSERT OR IGNORE INTO phantom VALUES(80)
  527. INSERT OR IGNORE INTO unclustered VALUES(80)
  528. DELETE FROM unclustered WHERE rid=80
  529. SELECT rid FROM blob WHERE uuid='8078e5556bdc21931ff0e0aa9f36c2140a90697e'
  530. SELECT rid, size FROM blob WHERE uuid='8078e5556bdc21931ff0e0aa9f36c2140a90697e'
  531. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'8078e5556bdc21931ff0e0aa9f36c2140a90697e',:data)
  532. INSERT OR IGNORE INTO phantom VALUES(81)
  533. INSERT OR IGNORE INTO unclustered VALUES(81)
  534. DELETE FROM unclustered WHERE rid=81
  535. SELECT rid FROM blob WHERE uuid='82e35d330423ddb6cdf0236db95ba18637063df2'
  536. SELECT rid, size FROM blob WHERE uuid='82e35d330423ddb6cdf0236db95ba18637063df2'
  537. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'82e35d330423ddb6cdf0236db95ba18637063df2',:data)
  538. INSERT OR IGNORE INTO phantom VALUES(82)
  539. INSERT OR IGNORE INTO unclustered VALUES(82)
  540. DELETE FROM unclustered WHERE rid=82
  541. SELECT rid FROM blob WHERE uuid='84d0049634e4c32b97b1e6a9dd40de73626cb875'
  542. SELECT rid, size FROM blob WHERE uuid='84d0049634e4c32b97b1e6a9dd40de73626cb875'
  543. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'84d0049634e4c32b97b1e6a9dd40de73626cb875',:data)
  544. INSERT OR IGNORE INTO phantom VALUES(83)
  545. INSERT OR IGNORE INTO unclustered VALUES(83)
  546. DELETE FROM unclustered WHERE rid=83
  547. SELECT rid FROM blob WHERE uuid='87cc4829ade8aa1f9eae261de7bc0ce7d79774bc'
  548. SELECT rid, size FROM blob WHERE uuid='87cc4829ade8aa1f9eae261de7bc0ce7d79774bc'
  549. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'87cc4829ade8aa1f9eae261de7bc0ce7d79774bc',:data)
  550. INSERT OR IGNORE INTO phantom VALUES(84)
  551. INSERT OR IGNORE INTO unclustered VALUES(84)
  552. DELETE FROM unclustered WHERE rid=84
  553. SELECT rid FROM blob WHERE uuid='88675c9828695558803e9f4cec25ae3c0c05c386'
  554. SELECT rid, size FROM blob WHERE uuid='88675c9828695558803e9f4cec25ae3c0c05c386'
  555. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'88675c9828695558803e9f4cec25ae3c0c05c386',:data)
  556. INSERT OR IGNORE INTO phantom VALUES(85)
  557. INSERT OR IGNORE INTO unclustered VALUES(85)
  558. DELETE FROM unclustered WHERE rid=85
  559. SELECT rid FROM blob WHERE uuid='89b2ca9e018fe41c0da7661d0d028660da693466'
  560. SELECT rid, size FROM blob WHERE uuid='89b2ca9e018fe41c0da7661d0d028660da693466'
  561. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'89b2ca9e018fe41c0da7661d0d028660da693466',:data)
  562. INSERT OR IGNORE INTO phantom VALUES(86)
  563. INSERT OR IGNORE INTO unclustered VALUES(86)
  564. DELETE FROM unclustered WHERE rid=86
  565. SELECT rid FROM blob WHERE uuid='8bd2fe1f5820aa6043d5841e5434e6bceeb03bac'
  566. SELECT rid, size FROM blob WHERE uuid='8bd2fe1f5820aa6043d5841e5434e6bceeb03bac'
  567. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'8bd2fe1f5820aa6043d5841e5434e6bceeb03bac',:data)
  568. INSERT OR IGNORE INTO phantom VALUES(87)
  569. INSERT OR IGNORE INTO unclustered VALUES(87)
  570. DELETE FROM unclustered WHERE rid=87
  571. SELECT rid FROM blob WHERE uuid='98d1ccdb7b4b2f9c80fcf511382cc57c63fd2bfa'
  572. SELECT rid, size FROM blob WHERE uuid='98d1ccdb7b4b2f9c80fcf511382cc57c63fd2bfa'
  573. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'98d1ccdb7b4b2f9c80fcf511382cc57c63fd2bfa',:data)
  574. INSERT OR IGNORE INTO phantom VALUES(88)
  575. INSERT OR IGNORE INTO unclustered VALUES(88)
  576. DELETE FROM unclustered WHERE rid=88
  577. SELECT rid FROM blob WHERE uuid='9943947d7e001b1c0b42717a06423c0101e6011d'
  578. SELECT rid, size FROM blob WHERE uuid='9943947d7e001b1c0b42717a06423c0101e6011d'
  579. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'9943947d7e001b1c0b42717a06423c0101e6011d',:data)
  580. INSERT OR IGNORE INTO phantom VALUES(89)
  581. INSERT OR IGNORE INTO unclustered VALUES(89)
  582. DELETE FROM unclustered WHERE rid=89
  583. SELECT rid FROM blob WHERE uuid='9958d4b1a2edd41bd9bc34448043b68e153043cc'
  584. SELECT rid, size FROM blob WHERE uuid='9958d4b1a2edd41bd9bc34448043b68e153043cc'
  585. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'9958d4b1a2edd41bd9bc34448043b68e153043cc',:data)
  586. INSERT OR IGNORE INTO phantom VALUES(90)
  587. INSERT OR IGNORE INTO unclustered VALUES(90)
  588. DELETE FROM unclustered WHERE rid=90
  589. SELECT rid FROM blob WHERE uuid='9a763fe59632c27e7ff0e88e5a593763e4e5f354'
  590. SELECT rid, size FROM blob WHERE uuid='9a763fe59632c27e7ff0e88e5a593763e4e5f354'
  591. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'9a763fe59632c27e7ff0e88e5a593763e4e5f354',:data)
  592. INSERT OR IGNORE INTO phantom VALUES(91)
  593. INSERT OR IGNORE INTO unclustered VALUES(91)
  594. DELETE FROM unclustered WHERE rid=91
  595. SELECT rid FROM blob WHERE uuid='9b0d3d53604c99a5f3339f92232ab45262dea23d'
  596. SELECT rid, size FROM blob WHERE uuid='9b0d3d53604c99a5f3339f92232ab45262dea23d'
  597. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'9b0d3d53604c99a5f3339f92232ab45262dea23d',:data)
  598. INSERT OR IGNORE INTO phantom VALUES(92)
  599. INSERT OR IGNORE INTO unclustered VALUES(92)
  600. DELETE FROM unclustered WHERE rid=92
  601. SELECT rid FROM blob WHERE uuid='a15a465f391ee03f22bc7591d5a5a09e3a3548d5'
  602. SELECT rid, size FROM blob WHERE uuid='a15a465f391ee03f22bc7591d5a5a09e3a3548d5'
  603. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'a15a465f391ee03f22bc7591d5a5a09e3a3548d5',:data)
  604. INSERT OR IGNORE INTO phantom VALUES(93)
  605. INSERT OR IGNORE INTO unclustered VALUES(93)
  606. DELETE FROM unclustered WHERE rid=93
  607. SELECT rid FROM blob WHERE uuid='a36f7cb9bcc38dfcb3521b0baceec22d0e9830d2'
  608. SELECT rid, size FROM blob WHERE uuid='a36f7cb9bcc38dfcb3521b0baceec22d0e9830d2'
  609. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'a36f7cb9bcc38dfcb3521b0baceec22d0e9830d2',:data)
  610. INSERT OR IGNORE INTO phantom VALUES(94)
  611. INSERT OR IGNORE INTO unclustered VALUES(94)
  612. DELETE FROM unclustered WHERE rid=94
  613. SELECT rid FROM blob WHERE uuid='a54672e2c88f1c1a50f0f6a9e3cbb3768d8520fd'
  614. SELECT rid, size FROM blob WHERE uuid='a54672e2c88f1c1a50f0f6a9e3cbb3768d8520fd'
  615. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'a54672e2c88f1c1a50f0f6a9e3cbb3768d8520fd',:data)
  616. INSERT OR IGNORE INTO phantom VALUES(95)
  617. INSERT OR IGNORE INTO unclustered VALUES(95)
  618. DELETE FROM unclustered WHERE rid=95
  619. SELECT rid FROM blob WHERE uuid='ab72e745345b7539f9cb2fffd24182c3961e03ef'
  620. SELECT rid, size FROM blob WHERE uuid='ab72e745345b7539f9cb2fffd24182c3961e03ef'
  621. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'ab72e745345b7539f9cb2fffd24182c3961e03ef',:data)
  622. INSERT OR IGNORE INTO phantom VALUES(96)
  623. INSERT OR IGNORE INTO unclustered VALUES(96)
  624. DELETE FROM unclustered WHERE rid=96
  625. SELECT rid FROM blob WHERE uuid='b1c125a0626a3d8e7194c2c59d8d3710e963a355'
  626. SELECT rid, size FROM blob WHERE uuid='b1c125a0626a3d8e7194c2c59d8d3710e963a355'
  627. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'b1c125a0626a3d8e7194c2c59d8d3710e963a355',:data)
  628. INSERT OR IGNORE INTO phantom VALUES(97)
  629. INSERT OR IGNORE INTO unclustered VALUES(97)
  630. DELETE FROM unclustered WHERE rid=97
  631. SELECT rid FROM blob WHERE uuid='b261253ccef6558a1bcf5a653efa9687b1fa5b02'
  632. SELECT rid, size FROM blob WHERE uuid='b261253ccef6558a1bcf5a653efa9687b1fa5b02'
  633. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'b261253ccef6558a1bcf5a653efa9687b1fa5b02',:data)
  634. INSERT OR IGNORE INTO phantom VALUES(98)
  635. INSERT OR IGNORE INTO unclustered VALUES(98)
  636. DELETE FROM unclustered WHERE rid=98
  637. SELECT rid FROM blob WHERE uuid='b2ddfe62f2727495b0338bc7a8f5f3fbc7c4526c'
  638. SELECT rid, size FROM blob WHERE uuid='b2ddfe62f2727495b0338bc7a8f5f3fbc7c4526c'
  639. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'b2ddfe62f2727495b0338bc7a8f5f3fbc7c4526c',:data)
  640. INSERT OR IGNORE INTO phantom VALUES(99)
  641. INSERT OR IGNORE INTO unclustered VALUES(99)
  642. DELETE FROM unclustered WHERE rid=99
  643. SELECT rid FROM blob WHERE uuid='b59cdc7f8a605c0baa16c27e603fbbb912f4347f'
  644. SELECT rid, size FROM blob WHERE uuid='b59cdc7f8a605c0baa16c27e603fbbb912f4347f'
  645. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'b59cdc7f8a605c0baa16c27e603fbbb912f4347f',:data)
  646. INSERT OR IGNORE INTO phantom VALUES(100)
  647. INSERT OR IGNORE INTO unclustered VALUES(100)
  648. DELETE FROM unclustered WHERE rid=100
  649. SELECT rid FROM blob WHERE uuid='b6bf21e2a81ce241a94584d9fca9accf5d97276b'
  650. SELECT rid, size FROM blob WHERE uuid='b6bf21e2a81ce241a94584d9fca9accf5d97276b'
  651. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'b6bf21e2a81ce241a94584d9fca9accf5d97276b',:data)
  652. INSERT OR IGNORE INTO phantom VALUES(101)
  653. INSERT OR IGNORE INTO unclustered VALUES(101)
  654. DELETE FROM unclustered WHERE rid=101
  655. SELECT rid FROM blob WHERE uuid='b81901adcb9d1a51828d311dd58ab219c3650c3f'
  656. SELECT rid, size FROM blob WHERE uuid='b81901adcb9d1a51828d311dd58ab219c3650c3f'
  657. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'b81901adcb9d1a51828d311dd58ab219c3650c3f',:data)
  658. INSERT OR IGNORE INTO phantom VALUES(102)
  659. INSERT OR IGNORE INTO unclustered VALUES(102)
  660. DELETE FROM unclustered WHERE rid=102
  661. SELECT rid FROM blob WHERE uuid='b8d8d7414375f66cb7817719a8b2763e8f92d077'
  662. SELECT rid, size FROM blob WHERE uuid='b8d8d7414375f66cb7817719a8b2763e8f92d077'
  663. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'b8d8d7414375f66cb7817719a8b2763e8f92d077',:data)
  664. INSERT OR IGNORE INTO phantom VALUES(103)
  665. INSERT OR IGNORE INTO unclustered VALUES(103)
  666. DELETE FROM unclustered WHERE rid=103
  667. SELECT rid FROM blob WHERE uuid='bc1fe01638f0cb36455c225af63bc17f94ba0ac3'
  668. SELECT rid, size FROM blob WHERE uuid='bc1fe01638f0cb36455c225af63bc17f94ba0ac3'
  669. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'bc1fe01638f0cb36455c225af63bc17f94ba0ac3',:data)
  670. INSERT OR IGNORE INTO phantom VALUES(104)
  671. INSERT OR IGNORE INTO unclustered VALUES(104)
  672. DELETE FROM unclustered WHERE rid=104
  673. SELECT rid FROM blob WHERE uuid='bd89b94e5f31aa5d3a00c2fb839b20cfa821cfa2'
  674. SELECT rid, size FROM blob WHERE uuid='bd89b94e5f31aa5d3a00c2fb839b20cfa821cfa2'
  675. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'bd89b94e5f31aa5d3a00c2fb839b20cfa821cfa2',:data)
  676. INSERT OR IGNORE INTO phantom VALUES(105)
  677. INSERT OR IGNORE INTO unclustered VALUES(105)
  678. DELETE FROM unclustered WHERE rid=105
  679. SELECT rid FROM blob WHERE uuid='bf0b70d5e08fe0d6747e3c6e6687b18aa531f3a9'
  680. SELECT rid, size FROM blob WHERE uuid='bf0b70d5e08fe0d6747e3c6e6687b18aa531f3a9'
  681. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'bf0b70d5e08fe0d6747e3c6e6687b18aa531f3a9',:data)
  682. INSERT OR IGNORE INTO phantom VALUES(106)
  683. INSERT OR IGNORE INTO unclustered VALUES(106)
  684. DELETE FROM unclustered WHERE rid=106
  685. SELECT rid FROM blob WHERE uuid='c4003e7b9365bf8f26b8e1a1a22cf431279d6d7c'
  686. SELECT rid, size FROM blob WHERE uuid='c4003e7b9365bf8f26b8e1a1a22cf431279d6d7c'
  687. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'c4003e7b9365bf8f26b8e1a1a22cf431279d6d7c',:data)
  688. INSERT OR IGNORE INTO phantom VALUES(107)
  689. INSERT OR IGNORE INTO unclustered VALUES(107)
  690. DELETE FROM unclustered WHERE rid=107
  691. SELECT rid FROM blob WHERE uuid='c5fb9baccf9457612f4aff097c15d41e688fbbbb'
  692. SELECT rid, size FROM blob WHERE uuid='c5fb9baccf9457612f4aff097c15d41e688fbbbb'
  693. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'c5fb9baccf9457612f4aff097c15d41e688fbbbb',:data)
  694. INSERT OR IGNORE INTO phantom VALUES(108)
  695. INSERT OR IGNORE INTO unclustered VALUES(108)
  696. DELETE FROM unclustered WHERE rid=108
  697. SELECT rid FROM blob WHERE uuid='c7d0900794b2be39e003522407571e41c8510f73'
  698. SELECT rid, size FROM blob WHERE uuid='c7d0900794b2be39e003522407571e41c8510f73'
  699. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'c7d0900794b2be39e003522407571e41c8510f73',:data)
  700. INSERT OR IGNORE INTO phantom VALUES(109)
  701. INSERT OR IGNORE INTO unclustered VALUES(109)
  702. DELETE FROM unclustered WHERE rid=109
  703. SELECT rid FROM blob WHERE uuid='d0305b305ad0a15a1aa38dbd1830bc9b7654eb69'
  704. SELECT rid, size FROM blob WHERE uuid='d0305b305ad0a15a1aa38dbd1830bc9b7654eb69'
  705. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'d0305b305ad0a15a1aa38dbd1830bc9b7654eb69',:data)
  706. INSERT OR IGNORE INTO phantom VALUES(110)
  707. INSERT OR IGNORE INTO unclustered VALUES(110)
  708. DELETE FROM unclustered WHERE rid=110
  709. SELECT rid FROM blob WHERE uuid='d4951ef6037a6683579d4928cc8604ce1825771a'
  710. SELECT rid, size FROM blob WHERE uuid='d4951ef6037a6683579d4928cc8604ce1825771a'
  711. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'d4951ef6037a6683579d4928cc8604ce1825771a',:data)
  712. INSERT OR IGNORE INTO phantom VALUES(111)
  713. INSERT OR IGNORE INTO unclustered VALUES(111)
  714. DELETE FROM unclustered WHERE rid=111
  715. SELECT rid FROM blob WHERE uuid='d9ba82df4d6ff07fb65d6cd2b4ad9c8443127809'
  716. SELECT rid, size FROM blob WHERE uuid='d9ba82df4d6ff07fb65d6cd2b4ad9c8443127809'
  717. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'d9ba82df4d6ff07fb65d6cd2b4ad9c8443127809',:data)
  718. INSERT OR IGNORE INTO phantom VALUES(112)
  719. INSERT OR IGNORE INTO unclustered VALUES(112)
  720. DELETE FROM unclustered WHERE rid=112
  721. SELECT rid FROM blob WHERE uuid='d9fc75e58714bc3006917ddd5383d7224761b734'
  722. SELECT rid, size FROM blob WHERE uuid='d9fc75e58714bc3006917ddd5383d7224761b734'
  723. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'d9fc75e58714bc3006917ddd5383d7224761b734',:data)
  724. INSERT OR IGNORE INTO phantom VALUES(113)
  725. INSERT OR IGNORE INTO unclustered VALUES(113)
  726. DELETE FROM unclustered WHERE rid=113
  727. SELECT rid FROM blob WHERE uuid='dab15ea695bf5df78c21e8a14e03fc335bc4e228'
  728. SELECT rid, size FROM blob WHERE uuid='dab15ea695bf5df78c21e8a14e03fc335bc4e228'
  729. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'dab15ea695bf5df78c21e8a14e03fc335bc4e228',:data)
  730. INSERT OR IGNORE INTO phantom VALUES(114)
  731. INSERT OR IGNORE INTO unclustered VALUES(114)
  732. DELETE FROM unclustered WHERE rid=114
  733. SELECT rid FROM blob WHERE uuid='dc611498354d21e93c444696f8faf3ee133df502'
  734. SELECT rid, size FROM blob WHERE uuid='dc611498354d21e93c444696f8faf3ee133df502'
  735. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'dc611498354d21e93c444696f8faf3ee133df502',:data)
  736. INSERT OR IGNORE INTO phantom VALUES(115)
  737. INSERT OR IGNORE INTO unclustered VALUES(115)
  738. DELETE FROM unclustered WHERE rid=115
  739. SELECT rid FROM blob WHERE uuid='dff17229ff68a85ef38dcc2c15fcb127700a7698'
  740. SELECT rid, size FROM blob WHERE uuid='dff17229ff68a85ef38dcc2c15fcb127700a7698'
  741. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'dff17229ff68a85ef38dcc2c15fcb127700a7698',:data)
  742. INSERT OR IGNORE INTO phantom VALUES(116)
  743. INSERT OR IGNORE INTO unclustered VALUES(116)
  744. DELETE FROM unclustered WHERE rid=116
  745. SELECT rid FROM blob WHERE uuid='e040b7b8d724998c092672e9b38b199314c1215f'
  746. SELECT rid, size FROM blob WHERE uuid='e040b7b8d724998c092672e9b38b199314c1215f'
  747. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'e040b7b8d724998c092672e9b38b199314c1215f',:data)
  748. INSERT OR IGNORE INTO phantom VALUES(117)
  749. INSERT OR IGNORE INTO unclustered VALUES(117)
  750. DELETE FROM unclustered WHERE rid=117
  751. SELECT rid FROM blob WHERE uuid='e100314ec2deed52da780bd226ab583efd59271b'
  752. SELECT rid, size FROM blob WHERE uuid='e100314ec2deed52da780bd226ab583efd59271b'
  753. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'e100314ec2deed52da780bd226ab583efd59271b',:data)
  754. INSERT OR IGNORE INTO phantom VALUES(118)
  755. INSERT OR IGNORE INTO unclustered VALUES(118)
  756. DELETE FROM unclustered WHERE rid=118
  757. SELECT rid FROM blob WHERE uuid='e288af39955b2602cd601c2cd928b8e68c7ff8d9'
  758. SELECT rid, size FROM blob WHERE uuid='e288af39955b2602cd601c2cd928b8e68c7ff8d9'
  759. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'e288af39955b2602cd601c2cd928b8e68c7ff8d9',:data)
  760. INSERT OR IGNORE INTO phantom VALUES(119)
  761. INSERT OR IGNORE INTO unclustered VALUES(119)
  762. DELETE FROM unclustered WHERE rid=119
  763. SELECT rid FROM blob WHERE uuid='e5b344f6b26dffaaaaa0c4991b39d84e6372b1e9'
  764. SELECT rid, size FROM blob WHERE uuid='e5b344f6b26dffaaaaa0c4991b39d84e6372b1e9'
  765. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'e5b344f6b26dffaaaaa0c4991b39d84e6372b1e9',:data)
  766. INSERT OR IGNORE INTO phantom VALUES(120)
  767. INSERT OR IGNORE INTO unclustered VALUES(120)
  768. DELETE FROM unclustered WHERE rid=120
  769. SELECT rid FROM blob WHERE uuid='e6c7fc923e4b6db057cc0800202b87dfea169a19'
  770. SELECT rid, size FROM blob WHERE uuid='e6c7fc923e4b6db057cc0800202b87dfea169a19'
  771. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'e6c7fc923e4b6db057cc0800202b87dfea169a19',:data)
  772. INSERT OR IGNORE INTO phantom VALUES(121)
  773. INSERT OR IGNORE INTO unclustered VALUES(121)
  774. DELETE FROM unclustered WHERE rid=121
  775. SELECT rid FROM blob WHERE uuid='e70131373302d41968d95982033ddf3ef3de54f9'
  776. SELECT rid, size FROM blob WHERE uuid='e70131373302d41968d95982033ddf3ef3de54f9'
  777. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'e70131373302d41968d95982033ddf3ef3de54f9',:data)
  778. INSERT OR IGNORE INTO phantom VALUES(122)
  779. INSERT OR IGNORE INTO unclustered VALUES(122)
  780. DELETE FROM unclustered WHERE rid=122
  781. SELECT rid FROM blob WHERE uuid='ea7746207cc6bf4b8ba475123e25b52d19864d4c'
  782. SELECT rid, size FROM blob WHERE uuid='ea7746207cc6bf4b8ba475123e25b52d19864d4c'
  783. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'ea7746207cc6bf4b8ba475123e25b52d19864d4c',:data)
  784. INSERT OR IGNORE INTO phantom VALUES(123)
  785. INSERT OR IGNORE INTO unclustered VALUES(123)
  786. DELETE FROM unclustered WHERE rid=123
  787. SELECT rid FROM blob WHERE uuid='ebb0d19e1f32a9e3c4feb1e6257c38341b58ff3a'
  788. SELECT rid, size FROM blob WHERE uuid='ebb0d19e1f32a9e3c4feb1e6257c38341b58ff3a'
  789. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'ebb0d19e1f32a9e3c4feb1e6257c38341b58ff3a',:data)
  790. INSERT OR IGNORE INTO phantom VALUES(124)
  791. INSERT OR IGNORE INTO unclustered VALUES(124)
  792. DELETE FROM unclustered WHERE rid=124
  793. SELECT rid FROM blob WHERE uuid='ebb2765954407a3ebe5b252130f3f7d7f0230330'
  794. SELECT rid, size FROM blob WHERE uuid='ebb2765954407a3ebe5b252130f3f7d7f0230330'
  795. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'ebb2765954407a3ebe5b252130f3f7d7f0230330',:data)
  796. INSERT OR IGNORE INTO phantom VALUES(125)
  797. INSERT OR IGNORE INTO unclustered VALUES(125)
  798. DELETE FROM unclustered WHERE rid=125
  799. SELECT rid FROM blob WHERE uuid='ec1fbd7f687d2bd87b6e9e608a56583de900e37c'
  800. SELECT rid, size FROM blob WHERE uuid='ec1fbd7f687d2bd87b6e9e608a56583de900e37c'
  801. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'ec1fbd7f687d2bd87b6e9e608a56583de900e37c',:data)
  802. INSERT OR IGNORE INTO phantom VALUES(126)
  803. INSERT OR IGNORE INTO unclustered VALUES(126)
  804. DELETE FROM unclustered WHERE rid=126
  805. SELECT rid FROM blob WHERE uuid='efaf06a56a2b23193383cdc442fbb371fa22480e'
  806. SELECT rid, size FROM blob WHERE uuid='efaf06a56a2b23193383cdc442fbb371fa22480e'
  807. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'efaf06a56a2b23193383cdc442fbb371fa22480e',:data)
  808. INSERT OR IGNORE INTO phantom VALUES(127)
  809. INSERT OR IGNORE INTO unclustered VALUES(127)
  810. DELETE FROM unclustered WHERE rid=127
  811. SELECT rid FROM blob WHERE uuid='f2b05566df6493264361ee3ffdc1d1c8f4f568e3'
  812. SELECT rid, size FROM blob WHERE uuid='f2b05566df6493264361ee3ffdc1d1c8f4f568e3'
  813. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'f2b05566df6493264361ee3ffdc1d1c8f4f568e3',:data)
  814. INSERT OR IGNORE INTO phantom VALUES(128)
  815. INSERT OR IGNORE INTO unclustered VALUES(128)
  816. DELETE FROM unclustered WHERE rid=128
  817. SELECT rid FROM blob WHERE uuid='f5a1fffb8ffa22edb543af6c0d859359c3121caf'
  818. SELECT rid, size FROM blob WHERE uuid='f5a1fffb8ffa22edb543af6c0d859359c3121caf'
  819. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'f5a1fffb8ffa22edb543af6c0d859359c3121caf',:data)
  820. INSERT OR IGNORE INTO phantom VALUES(129)
  821. INSERT OR IGNORE INTO unclustered VALUES(129)
  822. DELETE FROM unclustered WHERE rid=129
  823. SELECT rid FROM blob WHERE uuid='f692396968e7e06de9259097922cd926bfbaa88d'
  824. SELECT rid, size FROM blob WHERE uuid='f692396968e7e06de9259097922cd926bfbaa88d'
  825. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'f692396968e7e06de9259097922cd926bfbaa88d',:data)
  826. INSERT OR IGNORE INTO phantom VALUES(130)
  827. INSERT OR IGNORE INTO unclustered VALUES(130)
  828. DELETE FROM unclustered WHERE rid=130
  829. SELECT rid FROM blob WHERE uuid='fb90abe5bdfb92223dfcc291441868be1c2029af'
  830. SELECT rid, size FROM blob WHERE uuid='fb90abe5bdfb92223dfcc291441868be1c2029af'
  831. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'fb90abe5bdfb92223dfcc291441868be1c2029af',:data)
  832. INSERT OR IGNORE INTO phantom VALUES(131)
  833. INSERT OR IGNORE INTO unclustered VALUES(131)
  834. DELETE FROM unclustered WHERE rid=131
  835. SELECT rid FROM blob WHERE uuid='fde79c6697f59e09ef7d9a3d2bb48e6695cf1329'
  836. SELECT rid, size FROM blob WHERE uuid='fde79c6697f59e09ef7d9a3d2bb48e6695cf1329'
  837. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'fde79c6697f59e09ef7d9a3d2bb48e6695cf1329',:data)
  838. INSERT OR IGNORE INTO phantom VALUES(132)
  839. INSERT OR IGNORE INTO unclustered VALUES(132)
  840. DELETE FROM unclustered WHERE rid=132
  841. SELECT rid FROM blob WHERE uuid='fe8089aded0fe6cc51c22df98eb5ff17aedf2516'
  842. SELECT rid, size FROM blob WHERE uuid='fe8089aded0fe6cc51c22df98eb5ff17aedf2516'
  843. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'fe8089aded0fe6cc51c22df98eb5ff17aedf2516',:data)
  844. INSERT OR IGNORE INTO phantom VALUES(133)
  845. INSERT OR IGNORE INTO unclustered VALUES(133)
  846. DELETE FROM unclustered WHERE rid=133
  847. INSERT OR IGNORE INTO onremote VALUES(1)
  848. SELECT 1 FROM shun WHERE uuid='1b7107cc28dddc37ab00286102b826fb51b14a77'
  849. SELECT rid, size FROM blob WHERE uuid='1b7107cc28dddc37ab00286102b826fb51b14a77'
  850. UPDATE blob SET rcvid=1, size=5961, content=:data WHERE rid=2
  851. DELETE FROM phantom WHERE rid=2
  852. SELECT rid FROM delta WHERE srcid=2
  853. SELECT julianday('2007-12-07T18:29:00')
  854. SELECT tagid FROM tag WHERE tagname='wiki-Import CVS Repositories'
  855. INSERT INTO tag(tagname) VALUES('wiki-Import CVS Repositories')
  856. SELECT tagid FROM tag WHERE tagname='wiki-Import CVS Repositories'
  857. SELECT 1 FROM tagxref WHERE tagid=5 AND rid=2 AND mtime>=:mtime
  858. REPLACE INTO tagxref(tagid,tagtype,srcId,value,mtime,rid) VALUES(5,1,2,NULL,:mtime,2)
  859. SELECT rid FROM tagxref WHERE tagid=5 AND mtime<2454442.270138889 ORDER BY mtime DESC
  860. INSERT INTO event(type,mtime,objid,user,comment, bgcolor,brbgcolor,euser,ecomment)VALUES('w',2454442.270138889,2,'a
  861. ku','Changes to wiki page [Import CVS Repositories]', (SELECT value FROM tagxref WHERE tagid=1 AND rid=2 AND tagtype=1),(SELECT valu
  862. e FROM tagxref WHERE tagid=1 AND rid=2 AND tagtype!=1), (SELECT value FROM tagxref WHERE tagid=3 AND rid=2), (SELECT value FROM ta
  863. gxref WHERE tagid=2 AND rid=2));
  864. INSERT OR IGNORE INTO onremote VALUES(2)
  865. SELECT 1 FROM shun WHERE uuid='bb5f385c20a6dcda261855ed270445a4b4e12ecc'
  866. SELECT rid, size FROM blob WHERE uuid='bb5f385c20a6dcda261855ed270445a4b4e12ecc'
  867. UPDATE blob SET rcvid=1, size=4233, content=:data WHERE rid=3
  868. DELETE FROM phantom WHERE rid=3
  869. SELECT rid FROM delta WHERE srcid=3
  870. INSERT OR IGNORE INTO onremote VALUES(3)
  871. SELECT 1 FROM shun WHERE uuid='97e0e9dda94ea0fe577408ff08e894f68b9c19c2'
  872. SELECT rid FROM blob WHERE uuid='808fbc474536c2f5bc5bf912b5212387ea7c2b4f'
  873. SELECT srcid FROM delta WHERE rid=6
  874. SELECT content FROM blob WHERE rid=6 AND size>=0
  875. SELECT rid, size FROM blob WHERE uuid='97e0e9dda94ea0fe577408ff08e894f68b9c19c2'
  876. UPDATE blob SET rcvid=1, size=355, content=:data WHERE rid=4
  877. DELETE FROM phantom WHERE rid=4
  878. SELECT size FROM blob WHERE rid=6
  879. REPLACE INTO delta(rid,srcid) VALUES(4,6)
  880. SELECT 1 FROM shun WHERE uuid='f56e45ca7ec484ccd8e11e7d08edde2553fb3ecb'
  881. SELECT rid FROM blob WHERE uuid='8de6139917a2fb718bf461b8bff79aae51beab4c'
  882. SELECT srcid FROM delta WHERE rid=17
  883. SELECT content FROM blob WHERE rid=17 AND size>=0
  884. SELECT rid, size FROM blob WHERE uuid='f56e45ca7ec484ccd8e11e7d08edde2553fb3ecb'
  885. UPDATE blob SET rcvid=1, size=133, content=:data WHERE rid=5
  886. DELETE FROM phantom WHERE rid=5
  887. SELECT size FROM blob WHERE rid=17
  888. REPLACE INTO delta(rid,srcid) VALUES(5,17)
  889. SELECT 1 FROM shun WHERE uuid='808fbc474536c2f5bc5bf912b5212387ea7c2b4f'
  890. SELECT rid FROM blob WHERE uuid='f7fe15cd0cb6cc28a32cc40c13bb12b9faccd673'
  891. SELECT srcid FROM delta WHERE rid=8
  892. SELECT content FROM blob WHERE rid=8 AND size>=0
  893. SELECT rid, size FROM blob WHERE uuid='808fbc474536c2f5bc5bf912b5212387ea7c2b4f'
  894. UPDATE blob SET rcvid=1, size=431, content=:data WHERE rid=6
  895. DELETE FROM phantom WHERE rid=6
  896. SELECT size FROM blob WHERE rid=8
  897. REPLACE INTO delta(rid,srcid) VALUES(6,8)
  898. SELECT 1 FROM shun WHERE uuid='7383c81d45fc3ee64493b995e53e35206bae9201'
  899. SELECT rid, size FROM blob WHERE uuid='7383c81d45fc3ee64493b995e53e35206bae9201'
  900. UPDATE blob SET rcvid=1, size=10106, content=:data WHERE rid=7
  901. DELETE FROM phantom WHERE rid=7
  902. SELECT rid FROM delta WHERE srcid=7
  903. INSERT OR IGNORE INTO onremote VALUES(7)
  904. SELECT 1 FROM shun WHERE uuid='f7fe15cd0cb6cc28a32cc40c13bb12b9faccd673'
  905. SELECT rid FROM blob WHERE uuid='6809145eb16fb372e2e15f2dbc76b024db4fd095'
  906. SELECT srcid FROM delta WHERE rid=21
  907. SELECT content FROM blob WHERE rid=21 AND size>=0
  908. SELECT rid, size FROM blob WHERE uuid='f7fe15cd0cb6cc28a32cc40c13bb12b9faccd673'
  909. UPDATE blob SET rcvid=1, size=557, content=:data WHERE rid=8
  910. DELETE FROM phantom WHERE rid=8
  911. SELECT size FROM blob WHERE rid=21
  912. REPLACE INTO delta(rid,srcid) VALUES(8,21)
  913. SELECT 1 FROM shun WHERE uuid='a1d2da3e5f367be732ab5c9da0ae0cd912e7c385'
  914. SELECT rid FROM blob WHERE uuid='eb98d9f2255dac4dab66734bd1eb5ee5f2bc026e'
  915. SELECT srcid FROM delta WHERE rid=10
  916. SELECT content FROM blob WHERE rid=10 AND size>=0
  917. SELECT rid, size FROM blob WHERE uuid='a1d2da3e5f367be732ab5c9da0ae0cd912e7c385'
  918. UPDATE blob SET rcvid=1, size=156, content=:data WHERE rid=9
  919. DELETE FROM phantom WHERE rid=9
  920. SELECT size FROM blob WHERE rid=10
  921. REPLACE INTO delta(rid,srcid) VALUES(9,10)
  922. SELECT 1 FROM shun WHERE uuid='eb98d9f2255dac4dab66734bd1eb5ee5f2bc026e'
  923. SELECT rid FROM blob WHERE uuid='db6c6f303b21eceadada9c00063d371dc9f9c481'
  924. SELECT srcid FROM delta WHERE rid=12
  925. SELECT content FROM blob WHERE rid=12 AND size>=0
  926. SELECT rid, size FROM blob WHERE uuid='eb98d9f2255dac4dab66734bd1eb5ee5f2bc026e'
  927. UPDATE blob SET rcvid=1, size=147, content=:data WHERE rid=10
  928. DELETE FROM phantom WHERE rid=10
  929. SELECT size FROM blob WHERE rid=12
  930. REPLACE INTO delta(rid,srcid) VALUES(10,12)
  931. SELECT 1 FROM shun WHERE uuid='e15992f475760cdf3a9564d8f88cacb659ab4b07'
  932. SELECT rid, size FROM blob WHERE uuid='e15992f475760cdf3a9564d8f88cacb659ab4b07'
  933. UPDATE blob SET rcvid=1, size=318, content=:data WHERE rid=11
  934. DELETE FROM phantom WHERE rid=11
  935. SELECT rid FROM delta WHERE srcid=11
  936. SELECT julianday('2007-12-31T11:20:33')
  937. SELECT tagid FROM tag WHERE tagname='wiki-Opera'
  938. INSERT INTO tag(tagname) VALUES('wiki-Opera')
  939. SELECT tagid FROM tag WHERE tagname='wiki-Opera'
  940. SELECT 1 FROM tagxref WHERE tagid=6 AND rid=11 AND mtime>=:mtime
  941. REPLACE INTO tagxref(tagid,tagtype,srcId,value,mtime,rid) VALUES(6,1,11,NULL,:mtime,11)
  942. SELECT rid FROM tagxref WHERE tagid=6 AND mtime<2454465.972604167 ORDER BY mtime DESC
  943. INSERT INTO event(type,mtime,objid,user,comment, bgcolor,brbgcolor,euser,ecomment)VALUES('w',2454465.972604167,11,'
  944. anonymous','Changes to wiki page [Opera]', (SELECT value FROM tagxref WHERE tagid=1 AND rid=11 AND tagtype=1),(SELECT value FROM tag
  945. xref WHERE tagid=1 AND rid=11 AND tagtype!=1), (SELECT value FROM tagxref WHERE tagid=3 AND rid=11), (SELECT value FROM tagxref WH
  946. ERE tagid=2 AND rid=11));
  947. INSERT OR IGNORE INTO onremote VALUES(11)
  948. SELECT 1 FROM shun WHERE uuid='db6c6f303b21eceadada9c00063d371dc9f9c481'
  949. SELECT rid, size FROM blob WHERE uuid='db6c6f303b21eceadada9c00063d371dc9f9c481'
  950. UPDATE blob SET rcvid=1, size=1613, content=:data WHERE rid=12
  951. DELETE FROM phantom WHERE rid=12
  952. SELECT rid FROM delta WHERE srcid=12
  953. SELECT rid FROM delta WHERE srcid=10
  954. SELECT rid FROM delta WHERE srcid=9
  955. SELECT srcid FROM delta WHERE rid=9
  956. SELECT srcid FROM delta WHERE rid=10
  957. SELECT srcid FROM delta WHERE rid=12
  958. SELECT content FROM blob WHERE rid=12 AND size>=0
  959. SELECT content FROM blob WHERE rid=10 AND size>=0
  960. SELECT content FROM blob WHERE rid=9 AND size>=0
  961. SELECT julianday('2007-12-13T16:24:25')
  962. SELECT tagid FROM tag WHERE tagname='wiki-To Do List'
  963. INSERT INTO tag(tagname) VALUES('wiki-To Do List')
  964. SELECT tagid FROM tag WHERE tagname='wiki-To Do List'
  965. SELECT 1 FROM tagxref WHERE tagid=7 AND rid=9 AND mtime>=:mtime
  966. REPLACE INTO tagxref(tagid,tagtype,srcId,value,mtime,rid) VALUES(7,1,9,NULL,:mtime,9)
  967. SELECT rid FROM tagxref WHERE tagid=7 AND mtime<2454448.183622686 ORDER BY mtime DESC
  968. INSERT INTO event(type,mtime,objid,user,comment, bgcolor,brbgcolor,euser,ecomment)VALUES('w',2454448.183622686,9,'j
  969. eremy_c','Changes to wiki page [To Do List]', (SELECT value FROM tagxref WHERE tagid=1 AND rid=9 AND tagtype=1),(SELECT value FROM t
  970. agxref WHERE tagid=1 AND rid=9 AND tagtype!=1), (SELECT value FROM tagxref WHERE tagid=3 AND rid=9), (SELECT value FROM tagxref WH
  971. ERE tagid=2 AND rid=9));
  972. SELECT srcid FROM delta WHERE rid=10
  973. SELECT srcid FROM delta WHERE rid=12
  974. SELECT content FROM blob WHERE rid=12 AND size>=0
  975. SELECT content FROM blob WHERE rid=10 AND size>=0
  976. SELECT julianday('2007-12-31T11:17:57')
  977. SELECT tagid FROM tag WHERE tagname='wiki-To Do List'
  978. SELECT tagid FROM tag WHERE tagname='wiki-To Do List'
  979. SELECT 1 FROM tagxref WHERE tagid=7 AND rid=10 AND mtime>=:mtime
  980. REPLACE INTO tagxref(tagid,tagtype,srcId,value,mtime,rid) VALUES(7,1,10,NULL,:mtime,10)
  981. SELECT rid FROM tagxref WHERE tagid=7 AND mtime<2454465.970798612 ORDER BY mtime DESC
  982. INSERT INTO event(type,mtime,objid,user,comment, bgcolor,brbgcolor,euser,ecomment)VALUES('w',2454465.970798612,10,'
  983. anonymous','Changes to wiki page [To Do List]', (SELECT value FROM tagxref WHERE tagid=1 AND rid=10 AND tagtype=1),(SELECT value FRO
  984. M tagxref WHERE tagid=1 AND rid=10 AND tagtype!=1), (SELECT value FROM tagxref WHERE tagid=3 AND rid=10), (SELECT value FROM tagxr
  985. ef WHERE tagid=2 AND rid=10));
  986. SELECT julianday('2008-01-02T14:53:47')
  987. SELECT tagid FROM tag WHERE tagname='wiki-To Do List'
  988. SELECT tagid FROM tag WHERE tagname='wiki-To Do List'
  989. SELECT 1 FROM tagxref WHERE tagid=7 AND rid=12 AND mtime>=:mtime
  990. REPLACE INTO tagxref(tagid,tagtype,srcId,value,mtime,rid) VALUES(7,1,12,NULL,:mtime,12)
  991. SELECT rid FROM tagxref WHERE tagid=7 AND mtime<2454468.120682871 ORDER BY mtime DESC
  992. INSERT INTO event(type,mtime,objid,user,comment, bgcolor,brbgcolor,euser,ecomment)VALUES('w',2454468.120682871,12,'
  993. anonymous','Changes to wiki page [To Do List]', (SELECT value FROM tagxref WHERE tagid=1 AND rid=12 AND tagtype=1),(SELECT value FRO
  994. M tagxref WHERE tagid=1 AND rid=12 AND tagtype!=1), (SELECT value FROM tagxref WHERE tagid=3 AND rid=12), (SELECT value FROM tagxr
  995. ef WHERE tagid=2 AND rid=12));
  996. INSERT OR IGNORE INTO onremote VALUES(12)
  997. SELECT 1 FROM shun WHERE uuid='a795dc49f1ddae659feef0e7218c756bb71ba41d'
  998. SELECT rid, size FROM blob WHERE uuid='a795dc49f1ddae659feef0e7218c756bb71ba41d'
  999. UPDATE blob SET rcvid=1, size=38733, content=:data WHERE rid=13
  1000. DELETE FROM phantom WHERE rid=13
  1001. SELECT rid FROM delta WHERE srcid=13
  1002. INSERT OR IGNORE INTO onremote VALUES(13)
  1003. SELECT 1 FROM shun WHERE uuid='53c15e41ed45b5d59a34038107c62b8406f393da'
  1004. SELECT rid, size FROM blob WHERE uuid='53c15e41ed45b5d59a34038107c62b8406f393da'
  1005. UPDATE blob SET rcvid=1, size=30438, content=:data WHERE rid=14
  1006. DELETE FROM phantom WHERE rid=14
  1007. SELECT rid FROM delta WHERE srcid=14
  1008. INSERT OR IGNORE INTO onremote VALUES(14)
  1009. SELECT 1 FROM shun WHERE uuid='80b7efbe0d7c90514a7306c634b2f4daf880c995'
  1010. SELECT rid, size FROM blob WHERE uuid='80b7efbe0d7c90514a7306c634b2f4daf880c995'
  1011. UPDATE blob SET rcvid=1, size=8665, content=:data WHERE rid=15
  1012. DELETE FROM phantom WHERE rid=15
  1013. SELECT rid FROM delta WHERE srcid=15
  1014. INSERT OR IGNORE INTO onremote VALUES(15)
  1015. SELECT 1 FROM shun WHERE uuid='6af8fdc230b34ef61f6baab75a370c2647d8e470'
  1016. SELECT rid, size FROM blob WHERE uuid='6af8fdc230b34ef61f6baab75a370c2647d8e470'
  1017. UPDATE blob SET rcvid=1, size=11220, content=:data WHERE rid=16
  1018. DELETE FROM phantom WHERE rid=16
  1019. SELECT rid FROM delta WHERE srcid=16
  1020. SELECT julianday('2007-12-04T13:05:35')
  1021. SELECT 1 FROM mlink WHERE mid=16
  1022. SELECT rid FROM blob WHERE uuid='ebb2765954407a3ebe5b252130f3f7d7f0230330'
  1023. INSERT OR IGNORE INTO plink(pid, cid, isprim, mtime)VALUES(125, 16, 1, 2454439.045543982)
  1024. SELECT 1 FROM mlink WHERE mid=16
  1025. SELECT srcid FROM delta WHERE rid=125
  1026. SELECT content FROM blob WHERE rid=125 AND size>=0
  1027. SELECT cid FROM plink WHERE pid=16 AND isprim
  1028. INSERT INTO event(type,mtime,objid,user,comment, bgcolor,brbgcolor,euser,ecomment)VALUES('ci',2454439.045543982,16,
  1029. 'drh','Generate CGI replies as separate header and body so that the header
  1030. can be extended during the construction of the body.', (SELECT value FROM tagxref WHERE tagid=1 AND rid=16 AND tagtype=1),(SELECT va
  1031. lue FROM tagxref WHERE tagid=1 AND rid=16 AND tagtype!=1), (SELECT value FROM tagxref WHERE tagid=3 AND rid=16), (SELECT value FRO
  1032. M tagxref WHERE tagid=2 AND rid=16));
  1033. SELECT tagid, tagtype, mtime, value FROM tagxref WHERE rid=125 AND (tagtype=0 OR tagtype=2)
  1034. INSERT OR IGNORE INTO onremote VALUES(16)
  1035. SELECT 1 FROM shun WHERE uuid='8de6139917a2fb718bf461b8bff79aae51beab4c'
  1036. SELECT rid, size FROM blob WHERE uuid='8de6139917a2fb718bf461b8bff79aae51beab4c'
  1037. UPDATE blob SET rcvid=1, size=24707, content=:data WHERE rid=17
  1038. DELETE FROM phantom WHERE rid=17
  1039. SELECT rid FROM delta WHERE srcid=17
  1040. SELECT rid FROM delta WHERE srcid=5
  1041. SELECT srcid FROM delta WHERE rid=5
  1042. SELECT srcid FROM delta WHERE rid=17
  1043. SELECT content FROM blob WHERE rid=17 AND size>=0
  1044. SELECT content FROM blob WHERE rid=5 AND size>=0
  1045. INSERT OR IGNORE INTO onremote VALUES(17)
  1046. SELECT 1 FROM shun WHERE uuid='08cfcb070657d93c73f2a33f15d9d726182c3eda'
  1047. SELECT rid, size FROM blob WHERE uuid='08cfcb070657d93c73f2a33f15d9d726182c3eda'
  1048. UPDATE blob SET rcvid=1, size=46843, content=:data WHERE rid=18
  1049. DELETE FROM phantom WHERE rid=18
  1050. SELECT rid FROM delta WHERE srcid=18
  1051. INSERT OR IGNORE INTO onremote VALUES(18)
  1052. SELECT 1 FROM shun WHERE uuid='87c45ff178028416d2913fb9c08c3f0bcbd1423f'
  1053. SELECT rid, size FROM blob WHERE uuid='87c45ff178028416d2913fb9c08c3f0bcbd1423f'
  1054. UPDATE blob SET rcvid=1, size=15115, content=:data WHERE rid=19
  1055. DELETE FROM phantom WHERE rid=19
  1056. SELECT rid FROM delta WHERE srcid=19
  1057. INSERT OR IGNORE INTO onremote VALUES(19)
  1058. SELECT 1 FROM shun WHERE uuid='a9820cd0e44b51ade84f38f88da4a8831cc3e34e'
  1059. SELECT rid, size FROM blob WHERE uuid='a9820cd0e44b51ade84f38f88da4a8831cc3e34e'
  1060. UPDATE blob SET rcvid=1, size=17869, content=:data WHERE rid=20
  1061. DELETE FROM phantom WHERE rid=20
  1062. SELECT rid FROM delta WHERE srcid=20
  1063. INSERT OR IGNORE INTO onremote VALUES(20)
  1064. SELECT 1 FROM shun WHERE uuid='6809145eb16fb372e2e15f2dbc76b024db4fd095'
  1065. SELECT rid FROM blob WHERE uuid='727f370c2927c0788f0adc64f16d67258b237c34'
  1066. SELECT srcid FROM delta WHERE rid=23
  1067. SELECT content FROM blob WHERE rid=23 AND size>=0
  1068. SELECT rid, size FROM blob WHERE uuid='6809145eb16fb372e2e15f2dbc76b024db4fd095'
  1069. UPDATE blob SET rcvid=1, size=373, content=:data WHERE rid=21
  1070. DELETE FROM phantom WHERE rid=21
  1071. SELECT size FROM blob WHERE rid=23
  1072. REPLACE INTO delta(rid,srcid) VALUES(21,23)
  1073. SELECT 1 FROM shun WHERE uuid='ec6d87872c45f2d466ad310b89d42965bf026dfa'
  1074. SELECT rid, size FROM blob WHERE uuid='ec6d87872c45f2d466ad310b89d42965bf026dfa'
  1075. UPDATE blob SET rcvid=1, size=38676, content=:data WHERE rid=22
  1076. DELETE FROM phantom WHERE rid=22
  1077. SELECT rid FROM delta WHERE srcid=22
  1078. INSERT OR IGNORE INTO onremote VALUES(22)
  1079. SELECT 1 FROM shun WHERE uuid='727f370c2927c0788f0adc64f16d67258b237c34'
  1080. SELECT rid FROM blob WHERE uuid='0adaabf11231d63b5ded188dc7fe95d987257a88'
  1081. SELECT srcid FROM delta WHERE rid=25
  1082. SELECT content FROM blob WHERE rid=25 AND size>=0
  1083. SELECT rid, size FROM blob WHERE uuid='727f370c2927c0788f0adc64f16d67258b237c34'
  1084. UPDATE blob SET rcvid=1, size=392, content=:data WHERE rid=23
  1085. DELETE FROM phantom WHERE rid=23
  1086. SELECT size FROM blob WHERE rid=25
  1087. REPLACE INTO delta(rid,srcid) VALUES(23,25)
  1088. SELECT 1 FROM shun WHERE uuid='f9acec5443fd63bd4d01a1a341e27b5eac09596a'
  1089. SELECT rid, size FROM blob WHERE uuid='f9acec5443fd63bd4d01a1a341e27b5eac09596a'
  1090. UPDATE blob SET rcvid=1, size=43418, content=:data WHERE rid=24
  1091. DELETE FROM phantom WHERE rid=24
  1092. SELECT rid FROM delta WHERE srcid=24
  1093. INSERT OR IGNORE INTO onremote VALUES(24)
  1094. SELECT 1 FROM shun WHERE uuid='0adaabf11231d63b5ded188dc7fe95d987257a88'
  1095. SELECT rid FROM blob WHERE uuid='d3aa33884b6ce408dc8ad45fa2a28a43fbc788ac'
  1096. SELECT srcid FROM delta WHERE rid=27
  1097. SELECT content FROM blob WHERE rid=27 AND size>=0
  1098. SELECT rid, size FROM blob WHERE uuid='0adaabf11231d63b5ded188dc7fe95d987257a88'
  1099. UPDATE blob SET rcvid=1, size=485, content=:data WHERE rid=25
  1100. DELETE FROM phantom WHERE rid=25
  1101. SELECT size FROM blob WHERE rid=27
  1102. REPLACE INTO delta(rid,srcid) VALUES(25,27)
  1103. SELECT 1 FROM shun WHERE uuid='139ee190b530b01a248101b5b7259190566e24f3'
  1104. SELECT rid, size FROM blob WHERE uuid='139ee190b530b01a248101b5b7259190566e24f3'
  1105. UPDATE blob SET rcvid=1, size=9667, content=:data WHERE rid=26
  1106. DELETE FROM phantom WHERE rid=26
  1107. SELECT rid FROM delta WHERE srcid=26
  1108. INSERT OR IGNORE INTO onremote VALUES(26)
  1109. SELECT 1 FROM shun WHERE uuid='d3aa33884b6ce408dc8ad45fa2a28a43fbc788ac'
  1110. SELECT rid FROM blob WHERE uuid='970be48fce64bb2aeca497ef96d8d8989bf0d936'
  1111. SELECT srcid FROM delta WHERE rid=29
  1112. SELECT content FROM blob WHERE rid=29 AND size>=0
  1113. SELECT rid, size FROM blob WHERE uuid='d3aa33884b6ce408dc8ad45fa2a28a43fbc788ac'
  1114. UPDATE blob SET rcvid=1, size=447, content=:data WHERE rid=27
  1115. DELETE FROM phantom WHERE rid=27
  1116. SELECT size FROM blob WHERE rid=29
  1117. REPLACE INTO delta(rid,srcid) VALUES(27,29)
  1118. SELECT 1 FROM shun WHERE uuid='928c3acc9184fb994e891c613f90d942c4c134d1'
  1119. SELECT rid, size FROM blob WHERE uuid='928c3acc9184fb994e891c613f90d942c4c134d1'
  1120. UPDATE blob SET rcvid=1, size=17839, content=:data WHERE rid=28
  1121. DELETE FROM phantom WHERE rid=28
  1122. SELECT rid FROM delta WHERE srcid=28
  1123. INSERT OR IGNORE INTO onremote VALUES(28)
  1124. SELECT 1 FROM shun WHERE uuid='970be48fce64bb2aeca497ef96d8d8989bf0d936'
  1125. SELECT rid FROM blob WHERE uuid='e60ba158215dea5ca57084010bea46b6b36ee425'
  1126. SELECT srcid FROM delta WHERE rid=31
  1127. SELECT content FROM blob WHERE rid=31 AND size>=0
  1128. SELECT rid, size FROM blob WHERE uuid='970be48fce64bb2aeca497ef96d8d8989bf0d936'
  1129. UPDATE blob SET rcvid=1, size=394, content=:data WHERE rid=29
  1130. DELETE FROM phantom WHERE rid=29
  1131. SELECT size FROM blob WHERE rid=31
  1132. REPLACE INTO delta(rid,srcid) VALUES(29,31)
  1133. SELECT 1 FROM shun WHERE uuid='01daf9fb8c586e98d352884a2e5f4101389adcf6'
  1134. SELECT rid, size FROM blob WHERE uuid='01daf9fb8c586e98d352884a2e5f4101389adcf6'
  1135. UPDATE blob SET rcvid=1, size=4902, content=:data WHERE rid=30
  1136. DELETE FROM phantom WHERE rid=30
  1137. SELECT rid FROM delta WHERE srcid=30
  1138. INSERT OR IGNORE INTO onremote VALUES(30)
  1139. SELECT 1 FROM shun WHERE uuid='e60ba158215dea5ca57084010bea46b6b36ee425'
  1140. SELECT rid, size FROM blob WHERE uuid='e60ba158215dea5ca57084010bea46b6b36ee425'
  1141. UPDATE blob SET rcvid=1, size=11900, content=:data WHERE rid=31
  1142. DELETE FROM phantom WHERE rid=31
  1143. SELECT rid FROM delta WHERE srcid=31
  1144. SELECT rid FROM delta WHERE srcid=29
  1145. SELECT rid FROM delta WHERE srcid=27
  1146. SELECT rid FROM delta WHERE srcid=25
  1147. SELECT rid FROM delta WHERE srcid=23
  1148. SELECT rid FROM delta WHERE srcid=21
  1149. SELECT rid FROM delta WHERE srcid=8
  1150. SELECT rid FROM delta WHERE srcid=6
  1151. SELECT rid FROM delta WHERE srcid=4
  1152. SELECT srcid FROM delta WHERE rid=4
  1153. SELECT srcid FROM delta WHERE rid=6
  1154. SELECT srcid FROM delta WHERE rid=8
  1155. SELECT srcid FROM delta WHERE rid=21
  1156. SELECT srcid FROM delta WHERE rid=23
  1157. SELECT srcid FROM delta WHERE rid=25
  1158. SELECT srcid FROM delta WHERE rid=27
  1159. SELECT srcid FROM delta WHERE rid=29
  1160. SELECT srcid FROM delta WHERE rid=31
  1161. SELECT content FROM blob WHERE rid=31 AND size>=0
  1162. SELECT content FROM blob WHERE rid=29 AND size>=0
  1163. SELECT content FROM blob WHERE rid=27 AND size>=0
  1164. SELECT content FROM blob WHERE rid=25 AND size>=0
  1165. SELECT content FROM blob WHERE rid=23 AND size>=0
  1166. SELECT content FROM blob WHERE rid=21 AND size>=0
  1167. SELECT content FROM blob WHERE rid=8 AND size>=0
  1168. SELECT content FROM blob WHERE rid=6 AND size>=0
  1169. SELECT content FROM blob WHERE rid=4 AND size>=0
  1170. SELECT julianday('2007-12-07T08:55:21')
  1171. SELECT 1 FROM mlink WHERE mid=4
  1172. SELECT rid FROM blob WHERE uuid='9a763fe59632c27e7ff0e88e5a593763e4e5f354'
  1173. INSERT OR IGNORE INTO plink(pid, cid, isprim, mtime)VALUES(91, 4, 1, 2454441.871770834)
  1174. SELECT 1 FROM mlink WHERE mid=4
  1175. SELECT srcid FROM delta WHERE rid=91
  1176. SELECT content FROM blob WHERE rid=91 AND size>=0
  1177. SELECT cid FROM plink WHERE pid=4 AND isprim
  1178. INSERT INTO event(type,mtime,objid,user,comment, bgcolor,brbgcolor,euser,ecomment)VALUES('ci',2454441.871770834,4,'
  1179. aku','Removed two unused classes.', (SELECT value FROM tagxref WHERE tagid=1 AND rid=4 AND tagtype=1),(SELECT value FROM tagxref WHE
  1180. RE tagid=1 AND rid=4 AND tagtype!=1), (SELECT value FROM tagxref WHERE tagid=3 AND rid=4), (SELECT value FROM tagxref WHERE tagid=
  1181. 2 AND rid=4));
  1182. SELECT tagid, tagtype, mtime, value FROM tagxref WHERE rid=91 AND (tagtype=0 OR tagtype=2)
  1183. SELECT srcid FROM delta WHERE rid=6
  1184. SELECT srcid FROM delta WHERE rid=8
  1185. SELECT srcid FROM delta WHERE rid=21
  1186. SELECT srcid FROM delta WHERE rid=23
  1187. SELECT srcid FROM delta WHERE rid=25
  1188. SELECT srcid FROM delta WHERE rid=27
  1189. SELECT srcid FROM delta WHERE rid=29
  1190. SELECT srcid FROM delta WHERE rid=31
  1191. SELECT content FROM blob WHERE rid=31 AND size>=0
  1192. SELECT content FROM blob WHERE rid=29 AND size>=0
  1193. SELECT content FROM blob WHERE rid=27 AND size>=0
  1194. SELECT content FROM blob WHERE rid=25 AND size>=0
  1195. SELECT content FROM blob WHERE rid=23 AND size>=0
  1196. SELECT content FROM blob WHERE rid=21 AND size>=0
  1197. SELECT content FROM blob WHERE rid=8 AND size>=0
  1198. SELECT content FROM blob WHERE rid=6 AND size>=0
  1199. SELECT julianday('2007-12-08T02:59:09')
  1200. SELECT 1 FROM mlink WHERE mid=6
  1201. SELECT rid FROM blob WHERE uuid='97e0e9dda94ea0fe577408ff08e894f68b9c19c2'
  1202. INSERT OR IGNORE INTO plink(pid, cid, isprim, mtime)VALUES(4, 6, 1, 2454442.624409723)
  1203. SELECT 1 FROM mlink WHERE mid=6
  1204. SELECT srcid FROM delta WHERE rid=4
  1205. SELECT srcid FROM delta WHERE rid=6
  1206. SELECT srcid FROM delta WHERE rid=8
  1207. SELECT srcid FROM delta WHERE rid=21
  1208. SELECT srcid FROM delta WHERE rid=23
  1209. SELECT srcid FROM delta WHERE rid=25
  1210. SELECT srcid FROM delta WHERE rid=27
  1211. SELECT srcid FROM delta WHERE rid=29
  1212. SELECT srcid FROM delta WHERE rid=31
  1213. SELECT content FROM blob WHERE rid=31 AND size>=0
  1214. SELECT content FROM blob WHERE rid=29 AND size>=0
  1215. SELECT content FROM blob WHERE rid=27 AND size>=0
  1216. SELECT content FROM blob WHERE rid=25 AND size>=0
  1217. SELECT content FROM blob WHERE rid=23 AND size>=0
  1218. SELECT content FROM blob WHERE rid=21 AND size>=0
  1219. SELECT content FROM blob WHERE rid=8 AND size>=0
  1220. SELECT content FROM blob WHERE rid=6 AND size>=0
  1221. SELECT content FROM blob WHERE rid=4 AND size>=0
  1222. SELECT julianday('2007-12-07T08:55:21')
  1223. SELECT srcid FROM delta WHERE rid=4
  1224. SELECT fnid FROM filename WHERE name='tools/cvs2fossil/lib/c2f_pcollrev.tcl'
  1225. INSERT INTO filename(name) VALUES('tools/cvs2fossil/lib/c2f_pcollrev.tcl')
  1226. SELECT rid FROM blob WHERE uuid='5bb47f2e683e7118cdd1199256b85a82a80c6e66'
  1227. SELECT rid FROM blob WHERE uuid='f56e45ca7ec484ccd8e11e7d08edde2553fb3ecb'
  1228. INSERT INTO mlink(mid,pid,fid,fnid)VALUES(6,68,5,1)
  1229. SELECT srcid FROM delta WHERE rid=68
  1230. SELECT srcid FROM delta WHERE rid=5
  1231. SELECT srcid FROM delta WHERE rid=17
  1232. SELECT srcid FROM delta WHERE rid=5
  1233. SELECT srcid FROM delta WHERE rid=17
  1234. SELECT content FROM blob WHERE rid=17 AND size>=0
  1235. SELECT content FROM blob WHERE rid=5 AND size>=0
  1236. SELECT srcid FROM delta WHERE rid=68
  1237. SELECT content FROM blob WHERE rid=68 AND size>=0
  1238. SELECT cid FROM plink WHERE pid=6 AND isprim
  1239. INSERT INTO event(type,mtime,objid,user,comment, bgcolor,brbgcolor,euser,ecomment)VALUES('ci',2454442.624409723,6,'
  1240. aku','Added comments explaining the select statement checking revision/file/project/metadata integrity', (SELECT value FROM tagxref
  1241. WHERE tagid=1 AND rid=6 AND tagtype=1),(SELECT value FROM tagxref WHERE tagid=1 AND rid=6 AND tagtype!=1), (SELECT value FROM tagxr
  1242. ef WHERE tagid=3 AND rid=6), (SELECT value FROM tagxref WHERE tagid=2 AND rid=6));
  1243. SELECT tagid, tagtype, mtime, value FROM tagxref WHERE rid=4 AND (tagtype=0 OR tagtype=2)
  1244. SELECT srcid FROM delta WHERE rid=8
  1245. SELECT srcid FROM delta WHERE rid=21
  1246. SELECT srcid FROM delta WHERE rid=23
  1247. SELECT srcid FROM delta WHERE rid=25
  1248. SELECT srcid FROM delta WHERE rid=27
  1249. SELECT srcid FROM delta WHERE rid=29
  1250. SELECT srcid FROM delta WHERE rid=31
  1251. SELECT content FROM blob WHERE rid=31 AND size>=0
  1252. SELECT content FROM blob WHERE rid=29 AND size>=0
  1253. SELECT content FROM blob WHERE rid=27 AND size>=0
  1254. SELECT content FROM blob WHERE rid=25 AND size>=0
  1255. SELECT content FROM blob WHERE rid=23 AND size>=0
  1256. SELECT content FROM blob WHERE rid=21 AND size>=0
  1257. SELECT content FROM blob WHERE rid=8 AND size>=0
  1258. SELECT julianday('2007-12-08T03:39:27')
  1259. SELECT 1 FROM mlink WHERE mid=8
  1260. SELECT rid FROM blob WHERE uuid='808fbc474536c2f5bc5bf912b5212387ea7c2b4f'
  1261. INSERT OR IGNORE INTO plink(pid, cid, isprim, mtime)VALUES(6, 8, 1, 2454442.652395834)
  1262. SELECT 1 FROM mlink WHERE mid=8
  1263. SELECT srcid FROM delta WHERE rid=6
  1264. SELECT srcid FROM delta WHERE rid=8
  1265. SELECT srcid FROM delta WHERE rid=21
  1266. SELECT srcid FROM delta WHERE rid=23
  1267. SELECT srcid FROM delta WHERE rid=25
  1268. SELECT srcid FROM delta WHERE rid=27
  1269. SELECT srcid FROM delta WHERE rid=29
  1270. SELECT srcid FROM delta WHERE rid=31
  1271. SELECT content FROM blob WHERE rid=31 AND size>=0
  1272. SELECT content FROM blob WHERE rid=29 AND size>=0
  1273. SELECT content FROM blob WHERE rid=27 AND size>=0
  1274. SELECT content FROM blob WHERE rid=25 AND size>=0
  1275. SELECT content FROM blob WHERE rid=23 AND size>=0
  1276. SELECT content FROM blob WHERE rid=21 AND size>=0
  1277. SELECT content FROM blob WHERE rid=8 AND size>=0
  1278. SELECT content FROM blob WHERE rid=6 AND size>=0
  1279. SELECT julianday('2007-12-08T02:59:09')
  1280. SELECT srcid FROM delta WHERE rid=6
  1281. SELECT fnid FROM filename WHERE name='tools/cvs2fossil/lib/c2f_pcollsym.tcl'
  1282. INSERT INTO filename(name) VALUES('tools/cvs2fossil/lib/c2f_pcollsym.tcl')
  1283. SELECT rid FROM blob WHERE uuid='50ae29e5d87a2f84e1604daab40cf24f8d9573fb'
  1284. SELECT rid FROM blob WHERE uuid='7383c81d45fc3ee64493b995e53e35206bae9201'
  1285. INSERT INTO mlink(mid,pid,fid,fnid)VALUES(8,60,7,2)
  1286. SELECT srcid FROM delta WHERE rid=60
  1287. SELECT srcid FROM delta WHERE rid=7
  1288. SELECT srcid FROM delta WHERE rid=7
  1289. SELECT content FROM blob WHERE rid=7 AND size>=0
  1290. SELECT srcid FROM delta WHERE rid=60
  1291. SELECT content FROM blob WHERE rid=60 AND size>=0
  1292. SELECT cid FROM plink WHERE pid=8 AND isprim
  1293. INSERT INTO event(type,mtime,objid,user,comment, bgcolor,brbgcolor,euser,ecomment)VALUES('ci',2454442.652395834,8,'
  1294. aku','More comments on sql statements, slight reordering of some tables and conditions.', (SELECT value FROM tagxref WHERE tagid=1 A
  1295. ND rid=8 AND tagtype=1),(SELECT value FROM tagxref WHERE tagid=1 AND rid=8 AND tagtype!=1), (SELECT value FROM tagxref WHERE tagid=
  1296. 3 AND rid=8), (SELECT value FROM tagxref WHERE tagid=2 AND rid=8));
  1297. SELECT tagid, tagtype, mtime, value FROM tagxref WHERE rid=6 AND (tagtype=0 OR tagtype=2)
  1298. SELECT srcid FROM delta WHERE rid=21
  1299. SELECT srcid FROM delta WHERE rid=23
  1300. SELECT srcid FROM delta WHERE rid=25
  1301. SELECT srcid FROM delta WHERE rid=27
  1302. SELECT srcid FROM delta WHERE rid=29
  1303. SELECT srcid FROM delta WHERE rid=31
  1304. SELECT content FROM blob WHERE rid=31 AND size>=0
  1305. SELECT content FROM blob WHERE rid=29 AND size>=0
  1306. SELECT content FROM blob WHERE rid=27 AND size>=0
  1307. SELECT content FROM blob WHERE rid=25 AND size>=0
  1308. SELECT content FROM blob WHERE rid=23 AND size>=0
  1309. SELECT content FROM blob WHERE rid=21 AND size>=0
  1310. SELECT julianday('2008-01-19T06:07:49')
  1311. SELECT 1 FROM mlink WHERE mid=21
  1312. SELECT rid FROM blob WHERE uuid='f7fe15cd0cb6cc28a32cc40c13bb12b9faccd673'
  1313. INSERT OR IGNORE INTO plink(pid, cid, isprim, mtime)VALUES(8, 21, 1, 2454484.755428241)
  1314. SELECT 1 FROM mlink WHERE mid=21
  1315. SELECT srcid FROM delta WHERE rid=8
  1316. SELECT srcid FROM delta WHERE rid=21
  1317. SELECT srcid FROM delta WHERE rid=23
  1318. SELECT srcid FROM delta WHERE rid=25
  1319. SELECT srcid FROM delta WHERE rid=27
  1320. SELECT srcid FROM delta WHERE rid=29
  1321. SELECT srcid FROM delta WHERE rid=31
  1322. SELECT content FROM blob WHERE rid=31 AND size>=0
  1323. SELECT content FROM blob WHERE rid=29 AND size>=0
  1324. SELECT content FROM blob WHERE rid=27 AND size>=0
  1325. SELECT content FROM blob WHERE rid=25 AND size>=0
  1326. SELECT content FROM blob WHERE rid=23 AND size>=0
  1327. SELECT content FROM blob WHERE rid=21 AND size>=0
  1328. SELECT content FROM blob WHERE rid=8 AND size>=0
  1329. SELECT julianday('2007-12-08T03:39:27')
  1330. SELECT srcid FROM delta WHERE rid=8
  1331. SELECT fnid FROM filename WHERE name='tools/cvs2fossil/lib/c2f_pcollrev.tcl'
  1332. SELECT rid FROM blob WHERE uuid='f56e45ca7ec484ccd8e11e7d08edde2553fb3ecb'
  1333. SELECT rid FROM blob WHERE uuid='8de6139917a2fb718bf461b8bff79aae51beab4c'
  1334. INSERT INTO mlink(mid,pid,fid,fnid)VALUES(21,5,17,1)
  1335. SELECT srcid FROM delta WHERE rid=5
  1336. SELECT fnid FROM filename WHERE name='tools/cvs2fossil/lib/c2f_pfiltersym.tcl'
  1337. INSERT INTO filename(name) VALUES('tools/cvs2fossil/lib/c2f_pfiltersym.tcl')
  1338. SELECT rid FROM blob WHERE uuid='84d0049634e4c32b97b1e6a9dd40de73626cb875'
  1339. SELECT rid FROM blob WHERE uuid='a9820cd0e44b51ade84f38f88da4a8831cc3e34e'
  1340. INSERT INTO mlink(mid,pid,fid,fnid)VALUES(21,83,20,3)
  1341. SELECT srcid FROM delta WHERE rid=83
  1342. SELECT srcid FROM delta WHERE rid=20
  1343. SELECT srcid FROM delta WHERE rid=20
  1344. SELECT content FROM blob WHERE rid=20 AND size>=0
  1345. SELECT srcid FROM delta WHERE rid=83
  1346. SELECT content FROM blob WHERE rid=83 AND size>=0
  1347. SELECT fnid FROM filename WHERE name='tools/cvs2fossil/lib/c2f_prev.tcl'
  1348. INSERT INTO filename(name) VALUES('tools/cvs2fossil/lib/c2f_prev.tcl')
  1349. SELECT rid FROM blob WHERE uuid='28af7570f15551cb5edce769100f4145c8424612'
  1350. SELECT rid FROM blob WHERE uuid='08cfcb070657d93c73f2a33f15d9d726182c3eda'
  1351. INSERT INTO mlink(mid,pid,fid,fnid)VALUES(21,49,18,4)
  1352. SELECT srcid FROM delta WHERE rid=49
  1353. SELECT srcid FROM delta WHERE rid=18
  1354. SELECT srcid FROM delta WHERE rid=18
  1355. SELECT content FROM blob WHERE rid=18 AND size>=0
  1356. SELECT srcid FROM delta WHERE rid=49
  1357. SELECT content FROM blob WHERE rid=49 AND size>=0
  1358. SELECT fnid FROM filename WHERE name='tools/cvs2fossil/lib/c2f_repository.tcl'
  1359. INSERT INTO filename(name) VALUES('tools/cvs2fossil/lib/c2f_repository.tcl')
  1360. SELECT rid FROM blob WHERE uuid='6b33138cb4b327fe004cdc2193b0ceb2716f9afc'
  1361. SELECT rid, size FROM blob WHERE uuid='6b33138cb4b327fe004cdc2193b0ceb2716f9afc'
  1362. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'6b33138cb4b327fe004cdc2193b0ceb2716f9afc',:data)
  1363. INSERT OR IGNORE INTO phantom VALUES(134)
  1364. INSERT OR IGNORE INTO unclustered VALUES(134)
  1365. SELECT rid FROM blob WHERE uuid='87c45ff178028416d2913fb9c08c3f0bcbd1423f'
  1366. INSERT INTO mlink(mid,pid,fid,fnid)VALUES(21,134,19,5)
  1367. SELECT srcid FROM delta WHERE rid=134
  1368. SELECT srcid FROM delta WHERE rid=19
  1369. SELECT srcid FROM delta WHERE rid=19
  1370. SELECT content FROM blob WHERE rid=19 AND size>=0
  1371. SELECT srcid FROM delta WHERE rid=134
  1372. SELECT content FROM blob WHERE rid=134 AND size>=0
  1373. SELECT cid FROM plink WHERE pid=21 AND isprim
  1374. INSERT INTO event(type,mtime,objid,user,comment, bgcolor,brbgcolor,euser,ecomment)VALUES('ci',2454484.755428241,21,
  1375. 'aku','More comments on sql statements.', (SELECT value FROM tagxref WHERE tagid=1 AND rid=21 AND tagtype=1),(SELECT value FROM tagx
  1376. ref WHERE tagid=1 AND rid=21 AND tagtype!=1), (SELECT value FROM tagxref WHERE tagid=3 AND rid=21), (SELECT value FROM tagxref WHE
  1377. RE tagid=2 AND rid=21));
  1378. SELECT tagid, tagtype, mtime, value FROM tagxref WHERE rid=8 AND (tagtype=0 OR tagtype=2)
  1379. SELECT srcid FROM delta WHERE rid=23
  1380. SELECT srcid FROM delta WHERE rid=25
  1381. SELECT srcid FROM delta WHERE rid=27
  1382. SELECT srcid FROM delta WHERE rid=29
  1383. SELECT srcid FROM delta WHERE rid=31
  1384. SELECT content FROM blob WHERE rid=31 AND size>=0
  1385. SELECT content FROM blob WHERE rid=29 AND size>=0
  1386. SELECT content FROM blob WHERE rid=27 AND size>=0
  1387. SELECT content FROM blob WHERE rid=25 AND size>=0
  1388. SELECT content FROM blob WHERE rid=23 AND size>=0
  1389. SELECT julianday('2008-01-27T20:38:17')
  1390. SELECT 1 FROM mlink WHERE mid=23
  1391. SELECT rid FROM blob WHERE uuid='6809145eb16fb372e2e15f2dbc76b024db4fd095'
  1392. INSERT OR IGNORE INTO plink(pid, cid, isprim, mtime)VALUES(21, 23, 1, 2454493.359918982)
  1393. SELECT 1 FROM mlink WHERE mid=23
  1394. SELECT srcid FROM delta WHERE rid=21
  1395. SELECT srcid FROM delta WHERE rid=23
  1396. SELECT srcid FROM delta WHERE rid=25
  1397. SELECT srcid FROM delta WHERE rid=27
  1398. SELECT srcid FROM delta WHERE rid=29
  1399. SELECT srcid FROM delta WHERE rid=31
  1400. SELECT content FROM blob WHERE rid=31 AND size>=0
  1401. SELECT content FROM blob WHERE rid=29 AND size>=0
  1402. SELECT content FROM blob WHERE rid=27 AND size>=0
  1403. SELECT content FROM blob WHERE rid=25 AND size>=0
  1404. SELECT content FROM blob WHERE rid=23 AND size>=0
  1405. SELECT content FROM blob WHERE rid=21 AND size>=0
  1406. SELECT julianday('2008-01-19T06:07:49')
  1407. SELECT srcid FROM delta WHERE rid=21
  1408. SELECT fnid FROM filename WHERE name='tools/cvs2fossil/lib/c2f_integrity.tcl'
  1409. INSERT INTO filename(name) VALUES('tools/cvs2fossil/lib/c2f_integrity.tcl')
  1410. SELECT rid FROM blob WHERE uuid='565865cf886e13041e87b76bfdb52b1d4d24dcbf'
  1411. SELECT rid FROM blob WHERE uuid='ec6d87872c45f2d466ad310b89d42965bf026dfa'
  1412. INSERT INTO mlink(mid,pid,fid,fnid)VALUES(23,63,22,6)
  1413. SELECT srcid FROM delta WHERE rid=63
  1414. SELECT srcid FROM delta WHERE rid=22
  1415. SELECT srcid FROM delta WHERE rid=22
  1416. SELECT content FROM blob WHERE rid=22 AND size>=0
  1417. SELECT srcid FROM delta WHERE rid=63
  1418. SELECT content FROM blob WHERE rid=63 AND size>=0
  1419. SELECT cid FROM plink WHERE pid=23 AND isprim
  1420. INSERT INTO event(type,mtime,objid,user,comment, bgcolor,brbgcolor,euser,ecomment)VALUES('ci',2454493.359918982,23,
  1421. 'aku','Added comments to the sql commands in the integrity checks.', (SELECT value FROM tagxref WHERE tagid=1 AND rid=23 AND tagtype
  1422. =1),(SELECT value FROM tagxref WHERE tagid=1 AND rid=23 AND tagtype!=1), (SELECT value FROM tagxref WHERE tagid=3 AND rid=23), (SE
  1423. LECT value FROM tagxref WHERE tagid=2 AND rid=23));
  1424. SELECT tagid, tagtype, mtime, value FROM tagxref WHERE rid=21 AND (tagtype=0 OR tagtype=2)
  1425. SELECT srcid FROM delta WHERE rid=25
  1426. SELECT srcid FROM delta WHERE rid=27
  1427. SELECT srcid FROM delta WHERE rid=29
  1428. SELECT srcid FROM delta WHERE rid=31
  1429. SELECT content FROM blob WHERE rid=31 AND size>=0
  1430. SELECT content FROM blob WHERE rid=29 AND size>=0
  1431. SELECT content FROM blob WHERE rid=27 AND size>=0
  1432. SELECT content FROM blob WHERE rid=25 AND size>=0
  1433. SELECT julianday('2008-01-27T20:40:48')
  1434. SELECT 1 FROM mlink WHERE mid=25
  1435. SELECT rid FROM blob WHERE uuid='727f370c2927c0788f0adc64f16d67258b237c34'
  1436. INSERT OR IGNORE INTO plink(pid, cid, isprim, mtime)VALUES(23, 25, 1, 2454493.361666667)
  1437. SELECT 1 FROM mlink WHERE mid=25
  1438. SELECT srcid FROM delta WHERE rid=23
  1439. SELECT srcid FROM delta WHERE rid=25
  1440. SELECT srcid FROM delta WHERE rid=27
  1441. SELECT srcid FROM delta WHERE rid=29
  1442. SELECT srcid FROM delta WHERE rid=31
  1443. SELECT content FROM blob WHERE rid=31 AND size>=0
  1444. SELECT content FROM blob WHERE rid=29 AND size>=0
  1445. SELECT content FROM blob WHERE rid=27 AND size>=0
  1446. SELECT content FROM blob WHERE rid=25 AND size>=0
  1447. SELECT content FROM blob WHERE rid=23 AND size>=0
  1448. SELECT julianday('2008-01-27T20:38:17')
  1449. SELECT srcid FROM delta WHERE rid=23
  1450. SELECT fnid FROM filename WHERE name='tools/cvs2fossil/lib/c2f_file.tcl'
  1451. INSERT INTO filename(name) VALUES('tools/cvs2fossil/lib/c2f_file.tcl')
  1452. SELECT rid FROM blob WHERE uuid='59c3833ae178d91df5e3c8bc3aed00869969e9aa'
  1453. SELECT rid FROM blob WHERE uuid='f9acec5443fd63bd4d01a1a341e27b5eac09596a'
  1454. INSERT INTO mlink(mid,pid,fid,fnid)VALUES(25,65,24,7)
  1455. SELECT srcid FROM delta WHERE rid=65
  1456. SELECT srcid FROM delta WHERE rid=24
  1457. SELECT srcid FROM delta WHERE rid=24
  1458. SELECT content FROM blob WHERE rid=24 AND size>=0
  1459. SELECT srcid FROM delta WHERE rid=65
  1460. SELECT content FROM blob WHERE rid=65 AND size>=0
  1461. SELECT cid FROM plink WHERE pid=25 AND isprim
  1462. INSERT INTO event(type,mtime,objid,user,comment, bgcolor,brbgcolor,euser,ecomment)VALUES('ci',2454493.361666667,25,
  1463. 'aku','Fixed bug in the code detaching a vendor branch. Left link to removed parent dangling, and killed connection to first on bran
  1464. ch. No more.', (SELECT value FROM tagxref WHERE tagid=1 AND rid=25 AND tagtype=1),(SELECT value FROM tagxref WHERE tagid=1 AND rid=2
  1465. 5 AND tagtype!=1), (SELECT value FROM tagxref WHERE tagid=3 AND rid=25), (SELECT value FROM tagxref WHERE tagid=2 AND rid=25));
  1466. SELECT tagid, tagtype, mtime, value FROM tagxref WHERE rid=23 AND (tagtype=0 OR tagtype=2)
  1467. SELECT srcid FROM delta WHERE rid=27
  1468. SELECT srcid FROM delta WHERE rid=29
  1469. SELECT srcid FROM delta WHERE rid=31
  1470. SELECT content FROM blob WHERE rid=31 AND size>=0
  1471. SELECT content FROM blob WHERE rid=29 AND size>=0
  1472. SELECT content FROM blob WHERE rid=27 AND size>=0
  1473. SELECT julianday('2008-01-27T20:42:01')
  1474. SELECT 1 FROM mlink WHERE mid=27
  1475. SELECT rid FROM blob WHERE uuid='0adaabf11231d63b5ded188dc7fe95d987257a88'
  1476. INSERT OR IGNORE INTO plink(pid, cid, isprim, mtime)VALUES(25, 27, 1, 2454493.362511575)
  1477. SELECT 1 FROM mlink WHERE mid=27
  1478. SELECT srcid FROM delta WHERE rid=25
  1479. SELECT srcid FROM delta WHERE rid=27
  1480. SELECT srcid FROM delta WHERE rid=29
  1481. SELECT srcid FROM delta WHERE rid=31
  1482. SELECT content FROM blob WHERE rid=31 AND size>=0
  1483. SELECT content FROM blob WHERE rid=29 AND size>=0
  1484. SELECT content FROM blob WHERE rid=27 AND size>=0
  1485. SELECT content FROM blob WHERE rid=25 AND size>=0
  1486. SELECT julianday('2008-01-27T20:40:48')
  1487. SELECT srcid FROM delta WHERE rid=25
  1488. SELECT fnid FROM filename WHERE name='tools/cvs2fossil/lib/c2f_fsym.tcl'
  1489. INSERT INTO filename(name) VALUES('tools/cvs2fossil/lib/c2f_fsym.tcl')
  1490. SELECT rid FROM blob WHERE uuid='b2ddfe62f2727495b0338bc7a8f5f3fbc7c4526c'
  1491. SELECT rid FROM blob WHERE uuid='139ee190b530b01a248101b5b7259190566e24f3'
  1492. INSERT INTO mlink(mid,pid,fid,fnid)VALUES(27,99,26,8)
  1493. SELECT srcid FROM delta WHERE rid=99
  1494. SELECT srcid FROM delta WHERE rid=26
  1495. SELECT srcid FROM delta WHERE rid=26
  1496. SELECT content FROM blob WHERE rid=26 AND size>=0
  1497. SELECT srcid FROM delta WHERE rid=99
  1498. SELECT content FROM blob WHERE rid=99 AND size>=0
  1499. SELECT cid FROM plink WHERE pid=27 AND isprim
  1500. INSERT INTO event(type,mtime,objid,user,comment, bgcolor,brbgcolor,euser,ecomment)VALUES('ci',2454493.362511575,27,
  1501. 'aku','Allow for detached branches when checking lod consistency. Fixed formatting nit. Added debug helper method.', (SELECT value F
  1502. ROM tagxref WHERE tagid=1 AND rid=27 AND tagtype=1),(SELECT value FROM tagxref WHERE tagid=1 AND rid=27 AND tagtype!=1), (SELECT va
  1503. lue FROM tagxref WHERE tagid=3 AND rid=27), (SELECT value FROM tagxref WHERE tagid=2 AND rid=27));
  1504. SELECT tagid, tagtype, mtime, value FROM tagxref WHERE rid=25 AND (tagtype=0 OR tagtype=2)
  1505. SELECT srcid FROM delta WHERE rid=29
  1506. SELECT srcid FROM delta WHERE rid=31
  1507. SELECT content FROM blob WHERE rid=31 AND size>=0
  1508. SELECT content FROM blob WHERE rid=29 AND size>=0
  1509. SELECT julianday('2008-01-27T20:43:19')
  1510. SELECT 1 FROM mlink WHERE mid=29
  1511. SELECT rid FROM blob WHERE uuid='d3aa33884b6ce408dc8ad45fa2a28a43fbc788ac'
  1512. INSERT OR IGNORE INTO plink(pid, cid, isprim, mtime)VALUES(27, 29, 1, 2454493.363414352)
  1513. SELECT 1 FROM mlink WHERE mid=29
  1514. SELECT srcid FROM delta WHERE rid=27
  1515. SELECT srcid FROM delta WHERE rid=29
  1516. SELECT srcid FROM delta WHERE rid=31
  1517. SELECT content FROM blob WHERE rid=31 AND size>=0
  1518. SELECT content FROM blob WHERE rid=29 AND size>=0
  1519. SELECT content FROM blob WHERE rid=27 AND size>=0
  1520. SELECT julianday('2008-01-27T20:42:01')
  1521. SELECT srcid FROM delta WHERE rid=27
  1522. SELECT fnid FROM filename WHERE name='tools/cvs2fossil/lib/c2f_frev.tcl'
  1523. INSERT INTO filename(name) VALUES('tools/cvs2fossil/lib/c2f_frev.tcl')
  1524. SELECT rid FROM blob WHERE uuid='72b07e1bd51da1c7273808716c20a00e09c3a8c4'
  1525. SELECT rid, size FROM blob WHERE uuid='72b07e1bd51da1c7273808716c20a00e09c3a8c4'
  1526. INSERT INTO blob(rcvid,size,uuid,content)VALUES(1,-1,'72b07e1bd51da1c7273808716c20a00e09c3a8c4',:data)
  1527. INSERT OR IGNORE INTO phantom VALUES(135)
  1528. INSERT OR IGNORE INTO unclustered VALUES(135)
  1529. SELECT rid FROM blob WHERE uuid='928c3acc9184fb994e891c613f90d942c4c134d1'
  1530. INSERT INTO mlink(mid,pid,fid,fnid)VALUES(29,135,28,9)
  1531. SELECT srcid FROM delta WHERE rid=135
  1532. SELECT srcid FROM delta WHERE rid=28
  1533. SELECT srcid FROM delta WHERE rid=28
  1534. SELECT content FROM blob WHERE rid=28 AND size>=0
  1535. SELECT srcid FROM delta WHERE rid=135
  1536. SELECT content FROM blob WHERE rid=135 AND size>=0
  1537. SELECT cid FROM plink WHERE pid=29 AND isprim
  1538. INSERT INTO event(type,mtime,objid,user,comment, bgcolor,brbgcolor,euser,ecomment)VALUES('ci',2454493.363414352,29,
  1539. 'aku','Added debug helper methods. Fixed description of symbol reference in instances.', (SELECT value FROM tagxref WHERE tagid=1 AN
  1540. D rid=29 AND tagtype=1),(SELECT value FROM tagxref WHERE tagid=1 AND rid=29 AND tagtype!=1), (SELECT value FROM tagxref WHERE tagid
  1541. =3 AND rid=29), (SELECT value FROM tagxref WHERE tagid=2 AND rid=29));
  1542. SELECT tagid, tagtype, mtime, value FROM tagxref WHERE rid=27 AND (tagtype=0 OR tagtype=2)
  1543. SELECT julianday('2008-01-27T20:43:58')
  1544. SELECT 1 FROM mlink WHERE mid=31
  1545. SELECT rid FROM blob WHERE uuid='970be48fce64bb2aeca497ef96d8d8989bf0d936'
  1546. INSERT OR IGNORE INTO plink(pid, cid, isprim, mtime)VALUES(29, 31, 1, 2454493.363865741)
  1547. SELECT 1 FROM mlink WHERE mid=31
  1548. SELECT srcid FROM delta WHERE rid=29
  1549. SELECT srcid FROM delta WHERE rid=31
  1550. SELECT content FROM blob WHERE rid=31 AND size>=0
  1551. SELECT content FROM blob WHERE rid=29 AND size>=0
  1552. SELECT julianday('2008-01-27T20:43:19')
  1553. SELECT srcid FROM delta WHERE rid=29
  1554. SELECT fnid FROM filename WHERE name='tools/cvs2fossil/lib/c2f_fossil.tcl'
  1555. INSERT INTO filename(name) VALUES('tools/cvs2fossil/lib/c2f_fossil.tcl')
  1556. SELECT rid FROM blob WHERE uuid='ebb0d19e1f32a9e3c4feb1e6257c38341b58ff3a'
  1557. SELECT rid FROM blob WHERE uuid='01daf9fb8c586e98d352884a2e5f4101389adcf6'
  1558. INSERT INTO mlink(mid,pid,fid,fnid)VALUES(31,124,30,10)
  1559. SELECT srcid FROM delta WHERE rid=124
  1560. SELECT srcid FROM delta WHERE rid=30
  1561. SELECT srcid FROM delta WHERE rid=30
  1562. SELECT content FROM blob WHERE rid=30 AND size>=0
  1563. SELECT srcid FROM delta WHERE rid=124
  1564. SELECT content FROM blob WHERE rid=124 AND size>=0
  1565. SELECT cid FROM plink WHERE pid=31 AND isprim
  1566. INSERT INTO event(type,mtime,objid,user,comment, bgcolor,brbgcolor,euser,ecomment)VALUES('ci',2454493.363865741,31,
  1567. 'aku','Added log output to make the log during file import more complete.', (SELECT value FROM tagxref WHERE tagid=1 AND rid=31 AND
  1568. tagtype=1),(SELECT value FROM tagxref WHERE tagid=1 AND rid=31 AND tagtype!=1), (SELECT value FROM tagxref WHERE tagid=3 AND rid=31
  1569. ), (SELECT value FROM tagxref WHERE tagid=2 AND rid=31));
  1570. SELECT tagid, tagtype, mtime, value FROM tagxref WHERE rid=29 AND (tagtype=0 OR tagtype=2)
  1571. INSERT OR IGNORE INTO onremote VALUES(31)
  1572. SELECT 1 FROM blob WHERE uuid='cb8f4040e3b3bc26f188ec4228c8b8e4a3b74b27' AND size>=0
  1573. SELECT rid FROM blob WHERE uuid='cb8f4040e3b3bc26f188ec4228c8b8e4a3b74b27'
  1574. INSERT OR IGNORE INTO onremote VALUES(1)
  1575. SELECT 1 FROM blob WHERE uuid='1b7107cc28dddc37ab00286102b826fb51b14a77' AND size>=0
  1576. SELECT rid FROM blob WHERE uuid='1b7107cc28dddc37ab00286102b826fb51b14a77'
  1577. INSERT OR IGNORE INTO onremote VALUES(2)
  1578. SELECT 1 FROM blob WHERE uuid='bb5f385c20a6dcda261855ed270445a4b4e12ecc' AND size>=0
  1579. SELECT rid FROM blob WHERE uuid='bb5f385c20a6dcda261855ed270445a4b4e12ecc'
  1580. INSERT OR IGNORE INTO onremote VALUES(3)
  1581. SELECT 1 FROM blob WHERE uuid='97e0e9dda94ea0fe577408ff08e894f68b9c19c2' AND size>=0
  1582. SELECT rid FROM blob WHERE uuid='97e0e9dda94ea0fe577408ff08e894f68b9c19c2'
  1583. INSERT OR IGNORE INTO onremote VALUES(4)
  1584. SELECT 1 FROM blob WHERE uuid='f56e45ca7ec484ccd8e11e7d08edde2553fb3ecb' AND size>=0
  1585. SELECT rid FROM blob WHERE uuid='f56e45ca7ec484ccd8e11e7d08edde2553fb3ecb'
  1586. INSERT OR IGNORE INTO onremote VALUES(5)
  1587. SELECT 1 FROM blob WHERE uuid='808fbc474536c2f5bc5bf912b5212387ea7c2b4f' AND size>=0
  1588. SELECT rid FROM blob WHERE uuid='808fbc474536c2f5bc5bf912b5212387ea7c2b4f'
  1589. INSERT OR IGNORE INTO onremote VALUES(6)
  1590. SELECT 1 FROM blob WHERE uuid='7383c81d45fc3ee64493b995e53e35206bae9201' AND size>=0
  1591. SELECT rid FROM blob WHERE uuid='7383c81d45fc3ee64493b995e53e35206bae9201'
  1592. INSERT OR IGNORE INTO onremote VALUES(7)
  1593. SELECT 1 FROM blob WHERE uuid='f7fe15cd0cb6cc28a32cc40c13bb12b9faccd673' AND size>=0
  1594. SELECT rid FROM blob WHERE uuid='f7fe15cd0cb6cc28a32cc40c13bb12b9faccd673'
  1595. INSERT OR IGNORE INTO onremote VALUES(8)
  1596. SELECT 1 FROM blob WHERE uuid='a1d2da3e5f367be732ab5c9da0ae0cd912e7c385' AND size>=0
  1597. SELECT rid FROM blob WHERE uuid='a1d2da3e5f367be732ab5c9da0ae0cd912e7c385'
  1598. INSERT OR IGNORE INTO onremote VALUES(9)
  1599. SELECT 1 FROM blob WHERE uuid='eb98d9f2255dac4dab66734bd1eb5ee5f2bc026e' AND size>=0
  1600. SELECT rid FROM blob WHERE uuid='eb98d9f2255dac4dab66734bd1eb5ee5f2bc026e'
  1601. INSERT OR IGNORE INTO onremote VALUES(10)
  1602. SELECT 1 FROM blob WHERE uuid='e15992f475760cdf3a9564d8f88cacb659ab4b07' AND size>=0
  1603. SELECT rid FROM blob WHERE uuid='e15992f475760cdf3a9564d8f88cacb659ab4b07'
  1604. INSERT OR IGNORE INTO onremote VALUES(11)
  1605. SELECT 1 FROM blob WHERE uuid='db6c6f303b21eceadada9c00063d371dc9f9c481' AND size>=0
  1606. SELECT rid FROM blob WHERE uuid='db6c6f303b21eceadada9c00063d371dc9f9c481'
  1607. INSERT OR IGNORE INTO onremote VALUES(12)
  1608. SELECT 1 FROM blob WHERE uuid='a795dc49f1ddae659feef0e7218c756bb71ba41d' AND size>=0
  1609. SELECT rid FROM blob WHERE uuid='a795dc49f1ddae659feef0e7218c756bb71ba41d'
  1610. INSERT OR IGNORE INTO onremote VALUES(13)
  1611. SELECT 1 FROM blob WHERE uuid='53c15e41ed45b5d59a34038107c62b8406f393da' AND size>=0
  1612. SELECT rid FROM blob WHERE uuid='53c15e41ed45b5d59a34038107c62b8406f393da'
  1613. INSERT OR IGNORE INTO onremote VALUES(14)
  1614. SELECT 1 FROM blob WHERE uuid='80b7efbe0d7c90514a7306c634b2f4daf880c995' AND size>=0
  1615. SELECT rid FROM blob WHERE uuid='80b7efbe0d7c90514a7306c634b2f4daf880c995'
  1616. INSERT OR IGNORE INTO onremote VALUES(15)
  1617. SELECT 1 FROM blob WHERE uuid='6af8fdc230b34ef61f6baab75a370c2647d8e470' AND size>=0
  1618. SELECT rid FROM blob WHERE uuid='6af8fdc230b34ef61f6baab75a370c2647d8e470'
  1619. INSERT OR IGNORE INTO onremote VALUES(16)
  1620. SELECT 1 FROM blob WHERE uuid='8de6139917a2fb718bf461b8bff79aae51beab4c' AND size>=0
  1621. SELECT rid FROM blob WHERE uuid='8de6139917a2fb718bf461b8bff79aae51beab4c'
  1622. INSERT OR IGNORE INTO onremote VALUES(17)
  1623. SELECT 1 FROM blob WHERE uuid='08cfcb070657d93c73f2a33f15d9d726182c3eda' AND size>=0
  1624. SELECT rid FROM blob WHERE uuid='08cfcb070657d93c73f2a33f15d9d726182c3eda'
  1625. INSERT OR IGNORE INTO onremote VALUES(18)
  1626. SELECT 1 FROM blob WHERE uuid='87c45ff178028416d2913fb9c08c3f0bcbd1423f' AND size>=0
  1627. SELECT rid FROM blob WHERE uuid='87c45ff178028416d2913fb9c08c3f0bcbd1423f'
  1628. INSERT OR IGNORE INTO onremote VALUES(19)
  1629. SELECT 1 FROM blob WHERE uuid='a9820cd0e44b51ade84f38f88da4a8831cc3e34e' AND size>=0
  1630. SELECT rid FROM blob WHERE uuid='a9820cd0e44b51ade84f38f88da4a8831cc3e34e'
  1631. INSERT OR IGNORE INTO onremote VALUES(20)
  1632. SELECT 1 FROM blob WHERE uuid='6809145eb16fb372e2e15f2dbc76b024db4fd095' AND size>=0
  1633. SELECT rid FROM blob WHERE uuid='6809145eb16fb372e2e15f2dbc76b024db4fd095'
  1634. INSERT OR IGNORE INTO onremote VALUES(21)
  1635. SELECT 1 FROM blob WHERE uuid='ec6d87872c45f2d466ad310b89d42965bf026dfa' AND size>=0
  1636. SELECT rid FROM blob WHERE uuid='ec6d87872c45f2d466ad310b89d42965bf026dfa'
  1637. INSERT OR IGNORE INTO onremote VALUES(22)
  1638. SELECT 1 FROM blob WHERE uuid='727f370c2927c0788f0adc64f16d67258b237c34' AND size>=0
  1639. SELECT rid FROM blob WHERE uuid='727f370c2927c0788f0adc64f16d67258b237c34'
  1640. INSERT OR IGNORE INTO onremote VALUES(23)
  1641. SELECT 1 FROM blob WHERE uuid='f9acec5443fd63bd4d01a1a341e27b5eac09596a' AND size>=0
  1642. SELECT rid FROM blob WHERE uuid='f9acec5443fd63bd4d01a1a341e27b5eac09596a'
  1643. INSERT OR IGNORE INTO onremote VALUES(24)
  1644. SELECT 1 FROM blob WHERE uuid='0adaabf11231d63b5ded188dc7fe95d987257a88' AND size>=0
  1645. SELECT rid FROM blob WHERE uuid='0adaabf11231d63b5ded188dc7fe95d987257a88'
  1646. INSERT OR IGNORE INTO onremote VALUES(25)
  1647. SELECT 1 FROM blob WHERE uuid='139ee190b530b01a248101b5b7259190566e24f3' AND size>=0
  1648. SELECT rid FROM blob WHERE uuid='139ee190b530b01a248101b5b7259190566e24f3'
  1649. INSERT OR IGNORE INTO onremote VALUES(26)
  1650. SELECT 1 FROM blob WHERE uuid='d3aa33884b6ce408dc8ad45fa2a28a43fbc788ac' AND size>=0
  1651. SELECT rid FROM blob WHERE uuid='d3aa33884b6ce408dc8ad45fa2a28a43fbc788ac'
  1652. INSERT OR IGNORE INTO onremote VALUES(27)
  1653. SELECT 1 FROM blob WHERE uuid='928c3acc9184fb994e891c613f90d942c4c134d1' AND size>=0
  1654. SELECT rid FROM blob WHERE uuid='928c3acc9184fb994e891c613f90d942c4c134d1'
  1655. INSERT OR IGNORE INTO onremote VALUES(28)
  1656. SELECT 1 FROM blob WHERE uuid='970be48fce64bb2aeca497ef96d8d8989bf0d936' AND size>=0
  1657. SELECT rid FROM blob WHERE uuid='970be48fce64bb2aeca497ef96d8d8989bf0d936'
  1658. INSERT OR IGNORE INTO onremote VALUES(29)
  1659. SELECT 1 FROM blob WHERE uuid='01daf9fb8c586e98d352884a2e5f4101389adcf6' AND size>=0
  1660. SELECT rid FROM blob WHERE uuid='01daf9fb8c586e98d352884a2e5f4101389adcf6'
  1661. INSERT OR IGNORE INTO onremote VALUES(30)
  1662. SELECT 1 FROM blob WHERE uuid='e60ba158215dea5ca57084010bea46b6b36ee425' AND size>=0
  1663. SELECT rid FROM blob WHERE uuid='e60ba158215dea5ca57084010bea46b6b36ee425'
  1664. INSERT OR IGNORE INTO onremote VALUES(31)
  1665. Received: 354059 bytes, 33 messages, 31 files (20+0+11)
  1666. SELECT 1 FROM phantom
  1667. SELECT value FROM config WHERE name='cookie'
  1668. SELECT value FROM global_config WHERE name='cookie'
  1669. SELECT uuid FROM phantom JOIN blob USING(rid) WHERE NOT EXISTS(SELECT 1 FROM shun WHERE uuid=blob.uuid)
  1670. Send: 5411 bytes, 115 messages, 0 files (0+0)
  1671. SELECT pw FROM user WHERE uid=1
  1672. SELECT 1 FROM shun WHERE uuid='808fbc474536c2f5bc5bf912b5212387ea7c2b4f'
  1673. SELECT rid FROM blob WHERE uuid='f7fe15cd0cb6cc28a32cc40c13bb12b9faccd673'
  1674. SELECT srcid FROM delta WHERE rid=8
  1675. SELECT srcid FROM delta WHERE rid=21
  1676. SELECT srcid FROM delta WHERE rid=23
  1677. SELECT srcid FROM delta WHERE rid=25
  1678. SELECT srcid FROM delta WHERE rid=27
  1679. SELECT srcid FROM delta WHERE rid=29
  1680. SELECT srcid FROM delta WHERE rid=31
  1681. SELECT content FROM blob WHERE rid=31 AND size>=0
  1682. SELECT content FROM blob WHERE rid=29 AND size>=0
  1683. SELECT content FROM blob WHERE rid=27 AND size>=0
  1684. SELECT content FROM blob WHERE rid=25 AND size>=0
  1685. SELECT content FROM blob WHERE rid=23 AND size>=0
  1686. SELECT content FROM blob WHERE rid=21 AND size>=0
  1687. SELECT content FROM blob WHERE rid=8 AND size>=0
  1688. SELECT rid, size FROM blob WHERE uuid='808fbc474536c2f5bc5bf912b5212387ea7c2b4f'
  1689. SELECT julianday('2007-12-08T02:59:09')
  1690. SELECT 1 FROM mlink WHERE mid=6
  1691. INSERT OR IGNORE INTO onremote VALUES(6)
  1692. SELECT 1 FROM shun WHERE uuid='8de6139917a2fb718bf461b8bff79aae51beab4c'
  1693. SELECT rid, size FROM blob WHERE uuid='8de6139917a2fb718bf461b8bff79aae51beab4c'
  1694. INSERT OR IGNORE INTO onremote VALUES(17)
  1695. SELECT 1 FROM shun WHERE uuid='f7fe15cd0cb6cc28a32cc40c13bb12b9faccd673'
  1696. SELECT rid FROM blob WHERE uuid='6809145eb16fb372e2e15f2dbc76b024db4fd095'
  1697. SELECT srcid FROM delta WHERE rid=21
  1698. SELECT srcid FROM delta WHERE rid=23
  1699. SELECT srcid FROM delta WHERE rid=25
  1700. SELECT srcid FROM delta WHERE rid=27
  1701. SELECT srcid FROM delta WHERE rid=29
  1702. SELECT srcid FROM delta WHERE rid=31
  1703. SELECT content FROM blob WHERE rid=31 AND size>=0
  1704. SELECT content FROM blob WHERE rid=29 AND size>=0
  1705. SELECT content FROM blob WHERE rid=27 AND size>=0
  1706. SELECT content FROM blob WHERE rid=25 AND size>=0
  1707. SELECT content FROM blob WHERE rid=23 AND size>=0
  1708. SELECT content FROM blob WHERE rid=21 AND size>=0
  1709. SELECT rid, size FROM blob WHERE uuid='f7fe15cd0cb6cc28a32cc40c13bb12b9faccd673'
  1710. SELECT julianday('2007-12-08T03:39:27')
  1711. SELECT 1 FROM mlink WHERE mid=8
  1712. INSERT OR IGNORE INTO onremote VALUES(8)
  1713. SELECT 1 FROM shun WHERE uuid='6809145eb16fb372e2e15f2dbc76b024db4fd095'
  1714. SELECT rid FROM blob WHERE uuid='727f370c2927c0788f0adc64f16d67258b237c34'
  1715. SELECT srcid FROM delta WHERE rid=23
  1716. SELECT srcid FROM delta WHERE rid=25
  1717. SELECT srcid FROM delta WHERE rid=27
  1718. SELECT srcid FROM delta WHERE rid=29
  1719. SELECT srcid FROM delta WHERE rid=31
  1720. SELECT content FROM blob WHERE rid=31 AND size>=0
  1721. SELECT content FROM blob WHERE rid=29 AND size>=0
  1722. SELECT content FROM blob WHERE rid=27 AND size>=0
  1723. SELECT content FROM blob WHERE rid=25 AND size>=0
  1724. SELECT content FROM blob WHERE rid=23 AND size>=0
  1725. SELECT rid, size FROM blob WHERE uuid='6809145eb16fb372e2e15f2dbc76b024db4fd095'
  1726. SELECT julianday('2008-01-19T06:07:49')
  1727. SELECT 1 FROM mlink WHERE mid=21
  1728. INSERT OR IGNORE INTO onremote VALUES(21)
  1729. SELECT 1 FROM shun WHERE uuid='eb98d9f2255dac4dab66734bd1eb5ee5f2bc026e'
  1730. SELECT rid FROM blob WHERE uuid='db6c6f303b21eceadada9c00063d371dc9f9c481'
  1731. SELECT srcid FROM delta WHERE rid=12
  1732. SELECT content FROM blob WHERE rid=12 AND size>=0
  1733. SELECT rid, size FROM blob WHERE uuid='eb98d9f2255dac4dab66734bd1eb5ee5f2bc026e'
  1734. SELECT julianday('2007-12-31T11:17:57')
  1735. SELECT tagid FROM tag WHERE tagname='wiki-To Do List'
  1736. SELECT tagid FROM tag WHERE tagname='wiki-To Do List'
  1737. SELECT 1 FROM tagxref WHERE tagid=7 AND rid=10 AND mtime>=:mtime
  1738. SELECT rid FROM tagxref WHERE tagid=7 AND mtime<2454465.970798612 ORDER BY mtime DESC
  1739. INSERT INTO event(type,mtime,objid,user,comment, bgcolor,brbgcolor,euser,ecomment)VALUES('w',2454465.970798612,10,'
  1740. anonymous','Changes to wiki page [To Do List]', (SELECT value FROM tagxref WHERE tagid=1 AND rid=10 AND tagtype=1),(SELECT value FRO
  1741. M tagxref WHERE tagid=1 AND rid=10 AND tagtype!=1), (SELECT value FROM tagxref WHERE tagid=3 AND rid=10), (SELECT value FROM tagxr
  1742. ef WHERE tagid=2 AND rid=10));
  1743. C:\msys\bin\fossil.exe: PRIMARY KEY must be unique
  1744. INSERT INTO event(type,mtime,objid,user,comment, bgcolor,brbgcolor,euser,ecomment)VALUES('w',2454465.970798612,10,'
  1745. anonymous','Changes to wiki page [To Do List]', (SELECT value FROM tagxref WHERE tagid=1 AND rid=10 AND tagtype=1),(SELECT value FRO
  1746. M tagxref WHERE tagid=1 AND rid=10 AND tagtype!=1), (SELECT value FROM tagxref WHERE tagid=3 AND rid=10), (SELECT value FROM tagxr
  1747. ef WHERE tagid=2 AND rid=10));
  1748. ROLLBACK