INSERT INTO "blob" VALUES(1,1,160,'85d5623f065ba80b20a035dcb4f9aea045215406',X'000000A0789C1DC8BD0E82301000E0BD4F71334993FE1CB465D507300617C352AED7D0208D011C787BA3E3F75DA0D47294F81A775EDFC739EE34332DB2547105A3B492DA48AD078D7D1B7A6BC54DDC21A14E9E52F059A9C928E4E0950AC133658FC6B118A099B6586986068EED5397DFECE72AFF80463C206DB37802C69CACCB31B8EC983B424D2D2361B04645EE92F802B1932DED');
12
INSERT INTO "blob" VALUES(2,2,10,'da5c8346496f3421cb58f84b6e59e9531d9d424d',X'0000000A789C73E472E272E672E172E5020008CA0182');
13
INSERT INTO "blob" VALUES(3,2,10,'ed24d19d726d173f18dbf4a9a0f8514daa3e3ca4',X'0000000A789CF3E6F2E1F2E5F2E3F2E7020009F601B4');
14
INSERT INTO "blob" VALUES(4,2,10,'278a402316510f6ae4a77186796a6bde78c7dbc1',X'0000000A789C73E372E7F2E0F2E4F2E202000960019B');
15
INSERT INTO "blob" VALUES(5,2,325,'69cc5363f67013c09bf506e3fe9533c32d0bc1ef',X'000000AF789C05C1C10AC2300C00D07BBF621FB0439A365B3B2F0351F426CA2EB24BBAA4AC3005D7FD3FBE47645EC3B96191B91EEBAE3AD7F22D47E16DAEB96C5AEFE3B5F5030E00388DF6D1DADF1048A84397A1A3C401120283235992CF9195C1135AF2D09967B308E788392FA187B8B0042F2E893AC60E803499A9917D35EF2670C09853E0A8092893EF859CB33D6A8414351AFCF0ED72FA03D5E231F2');
16
INSERT INTO "blob" VALUES(6,3,190,'3bfa21d09f8718adc3195848d57114e1fbf564fe',X'000000BE789C8DCC3B0EC2300C00D03DA7C88E2AF9A32475678E5016C49238B6400206D285DB036261E400EFED2301C2843421AE9816A02595B0C65DAF9BC52CAA89337B2E80AC20CD1364633749CCCAD4A1299AFF24A7F15D003ECB78DEA656875D2FF7FFB77088FD710EC758BA6095590C082BEAECEC4AC58CDEBEA2617801EE253190');
17
INSERT INTO "blob" VALUES(7,4,10,'35815cf5804e8933eab64ae34e00bbb381be72c5',X'0000000A789C0BE00AE40AE20AE60AE102000A8C01CD');
18
INSERT INTO "blob" VALUES(8,4,364,'341db367709dc7bc5046ab4fda4f7d9423118cba',X'0000016C789C35CE3B4E44310C85E1FEAE221B1864C78F24B4206A84A0413476EC888A918641B07CEE0CA23D3A9FF4DF158B78FB5CC7AFD3CDF9E7BCDD970A0807AC07C467945BE05B94EDA1FC1F0A4947994B3A70F64194E6CA96C409E0EED4D1B3D57931C78FBC9230999D5879E822AE385DFAEAEC9A327208618CE0CAB193F3FB29FF50C6BEE0885635B0D1C21EBED886C1EA821C6694348D2FE8FB7825B57563A8842A084B2DD95AC3AE6DA8A947B63E5BF8C4EDB1E8985348696903A409C3978026AD4B0F4DAA01FB31D7F65422C1AC73A4A3D5BD7CEF07016B16BBB5C9DB4B89D3FBF65A6C7873C33052034A6D94E82CAED85BA4ACED1765FC64F9');
19
INSERT INTO "blob" VALUES(9,5,294,'9223b4cad40c0bc997b747fe4eee586559a43815',X'00000126789C8D8E310E83300C45774E91B955243B714860EE11E85275B16322A4AA0C0186DEBEA00E5DD9FEF2FE7B37E300C1A2B38803861EA8F7D40CE62295E73C194FA8E2DB18A1D31C2507A096858A3295A81D398F98B2B0918A07B67CDE769FA7B99DB92AAFE379D1BFF7B9FC8231EC2FF630AF759B5FE7DD77A3756A1EC68D0C3E69424DA20E3460804C259172F15E52F305DF884EE5');
20
INSERT INTO "blob" VALUES(10,6,10,'8f09bc55a60eb8ca06f10a3b577aafa869b31695',X'0000000A789C0BE50AE30AE78AE08AE402000B2201E6');
21
INSERT INTO "blob" VALUES(11,6,426,'3d5bce2e44a6b39205eb514c581aa41d86f48540',X'00000116789C458ECB4A04311444F7F98AAC075BEE23B949DA8DA01F203A832082E471C30C6A2FBA47D1BF37BA7157A7288A23DDBCCC3736B7F6BCF5D3A75E9EBFCEE6D612204C4813E21EFD0C7E266AD78F177C9829C4EC8018C52374C9EA7208182524C9529A8658432B15CD9D9554AB67E12E01902BA4D23D8872D7E4992B538331D46EEE6D23AA320E1CE4C6B1A5CCDDA973181C6BF705CCDEEECA9A977AB43B5B56FAE5EDFB7D1AD1EE064C7F90377D3B2DFADF9CD78FE575E0C1B6F5689E6C57284961887A14A89A628B340C2825E118C020A6F0E0AE7E00A7744B2A');
22
INSERT INTO "blob" VALUES(12,7,10,'c6536e40b3d4755ead483c2e0fb2f16ecb751b6a',X'0000000A789C33E032E432E232E632E1020006CC012D');
23
INSERT INTO "blob" VALUES(13,7,424,'b95701e0b73e5ebf452a9a7ae00360bf7fd187fd',X'000001A8789C4590414F83310886EFDFAFE879C90C9496B65E359E8DD18BF10285668B3A936F33EABFB753136FBCC003BC5C05317B3A1EF79F17A7CFD3721D22206C316E11EF315F025FC6B8DC84B7839FEBC124F74A8953E3412962D75C474DCA9E9BB74C68CD524C3691BF91A17326F6044A964ACE2E962AF5E830340E64EF5A322ACB444EBBD57FF7B8CD21D8AC44362C34B09A8E244D60D48CC944C8A94B3A431F6F3F482C55124442CE0883C5939482954B6361352FB517D38ECB6DE0D6FB3C8A061740EAD0746460A771B6409DA2C16CF4B1DC85311D4D9AA4E4DEB21924D10AAA0834AD132CF761A3AB1CFA2E6C82AE74D6C7AFD7ED0CC3668AED8F90A3BFEC0FFE9F39ADEF87E7291F82ADBBE5312895341D420637C74AB5CD6F5185E23AC41B2FDF3224768A');
24
INSERT INTO "blob" VALUES(14,8,11,'6f525ab779ad66e24474d845c5fb7938be42d50d',X'0000000B789C73E4728AE072E672E172E502000C1801DA');
25
INSERT INTO "blob" VALUES(15,8,319,'c19f6ae71a35cddef0d5de3e1e6109c4378c8215',X'000000E0789C0DCA314E04310C05D03EA7C80158E41F27F6646890587A844048681B274E986A4762B6A0E2ECF0EA977FC3B63EC5BED9F56B1C97E3B65F8EFD3AEE6F3FB7708E894027A413F086B292AE00F6C7ED2E7DAC4917CB94185240536C6453C5225AC5A4F9D0A5ABB78EF012A5F65E58788A12B8536DB3900C9EA316E6CEC9E93F8E195EA361641573481EA5D6E900235B422FD49435BC47FFDEC2672469A9CEC98AAEE685672ECD45B28FEA8B590BA99D9FBD3DFC010C0C3CFF');
26
INSERT INTO "blob" VALUES(16,9,11,'b262fee89ed8a27a23a5e09d3917e0bebe22cd24',X'0000000B789C73E372E7F288E0F2E4F2E202000C5A01F3');
27
INSERT INTO "blob" VALUES(17,9,319,'41a02f2b2277d771d85e7f1202c82d4d6675662f',X'000000D8789C0DCE3B4E03410C00D07E4EB107D820DB63CF8F668B488882068890E8BCB6478806258A142ACE4E0EF0A4C77FE96983F56DDC7E1EAEBFD7745C08100E4807C47794017590206CDFAB8F7062C7EE958A63CD139BEF93B52BCC26C8AE9A239BF265A39715CFC3B0CFA25151B3987B4C70F1C8815110BA71AECD1AA1A4D785F5AE4929B07397CADE729F6462358A36F3745AFCF2953E17C9AD30766AA5CE3DD8E27EA1BD548FD80D9C533E3F9FE6C7E33F8FCE3AED');
28
INSERT INTO "blob" VALUES(18,10,187,'6c22c86ee8a603f5e18171efb6ff571b59e35cf3',X'000000BB789C8DCCAD0EC230140650DFA7A8274BFAB5B4B7ADE611862198EEFE30038261787B9843A24F724E3E068409710266E41E6A4776B33FC878A967342B4309236516510B924593420B42E363A2CA3522FF24D76D5FA803FBB2BDEF13AF8F1BFEAEDCD9CB7375176F45D8961C858C9651BED86C080189381621F701B249318A');
29
INSERT INTO "blob" VALUES(19,11,187,'8b9f82378ea7a5f9ef8e80d31929f6dfab988acc',X'000000BB789C8DCC3D0EC2300C06D03DA7C88E22D95F623BEACC11CA8258F24B1718280BB747DD18790778670F620A8CC0BCB22C9497486EF5A75EDEC3272E84890A987533EE59864D06A165F4D4554D54317F92DB7E2CB6408E65FF3C42DB9E77FC5DB98BEFAFCD5DBD0C9E604819AC31D5A489F2906AA5C5AAA4C57D01A0C52E74');
30
INSERT INTO "blob" VALUES(20,12,11,'64a8a5c7320fccfa4b2e5dfc5fd20a5381a86c5b',X'0000000B789CF3E6F2E1F2E5F28BE0F2E702000CA7020C');
31
INSERT INTO "blob" VALUES(21,12,321,'5a71ecd64585155b076a4f1e4d489eb5fe3d05f4',X'00000141789C3D8F314E04310C45FB9C221758643B719C6C0BA246081A44E3C40E53ED48BB23C1F1095B50B8F8FA7A4FDF8F716C7AF9F2DBE7EDD8D76D57F787E3E7084F9100E18474427C433E239D81C273DC2FF73E96C9C4DA459A5A294E394BB69A79F0ECD252ED9EC9186C21FFD258B256E52189608E31357772B6B91823504E15B596C1FD0FFADEEF48A742D3BD36B7AA244A49D9A1596A280EDDBB130DA31C5E6246059AD489444C04ADB2CB44021A952CAF99C265D9C2EBB2226371186AA4C35704D7C252C0B06A1FE13DDA750B1F9111E6C4543CF1C4A1136606582F0FE406D424FC021EAB59DA');
32
INSERT INTO "blob" VALUES(22,13,187,'a2c1640c98b3059a83df0b597d673ad073b782de',X'000000BB789C8DCC310EC2300C00C03DAFC88E22D9899DA49D794259108B93D874818176E1F7805818994FBAA38F80103006C40579C63863718B3F0CD9D5B314D43E327165646E50B290A1D2A03A6963D334808D7E92CBF65D207E96ED790B7DBD5FD3DF953BF9F158DDD96B1EB1D91B92285649B917AD5627A8066842EE05469C30D4');
33
INSERT INTO "blob" VALUES(23,14,10,'6e167b139c294bed560e2e30b352361b101e1f39',X'0000000A789C33E532E332E7B2E0B2E4020007620146');
34
INSERT INTO "blob" VALUES(24,14,388,'8015e80a2391d4497530b5d0f36689f359e374ba',X'00000184789C4590314FC4300C85F7FE8ACC2715D971E234C7086246E8585017277174086851DBD3C1BF27BD85CDCFF6A7F7EC075396F97B5CE749EFC7554A19D749AFE35AE7CBD23D1A0B083DDA1EF184FE8874F4DC3D997D78B7FD6C86153924A4986D74498B6750AB0489BC25C684808A956263B6F3A27A83B45857309660B960A08A4349D54914A88347574448298BDBA1EB7C436C18C48125648F5059D449083870882C9C8A862187923276CF8663CE9E982A0740CA1053F5C04A55A327CA640BB445ADDD8B69E611497373AF425407B0FB19A145C6C04CDDC91CD222533E9B83498BDBF5FAFBD5B7D21C9AE86F4256FD7C9FF4BFB32D97E9A3C9D7F6DA73F7666A96907CB351CB9A23D89CAB44675B50715CA8FB033C856E21');
35
INSERT INTO "blob" VALUES(25,15,11,'e866bb885d5184cba497cfb6a4eb281688519521',X'0000000B789C73E472E272E672E1728DE002000AF201DA');
36
INSERT INTO "blob" VALUES(26,15,372,'b882b17dc56af1e0297bf8a57c9d15050215c64a',X'00000174789C458E414B04310C85EFF32B7A5E1869D23669BD2A9E45D68B78499BD41175166657D47F6F7711841CF2F2DE47DE8D6B8BAC2FF67C3CAC36DD3AF4E067C019600FE97A0CD274E7867775FA3E39CB44B5E69C34418EAD4A2CDC7A25895631030D074A4218C869D9EC0F528C0A451949814387ACB54729E2FB88471509169AC433F475B820C859A2C70094C077128BC20C99B8905055E3DC586B83E9DE51692D050A9DD84368BED49E3C59E85652082DA0FA11B43E3D38EB297266D4D414C427E30E56C2E8D0A1F9D4A7BDDBD54DD6B6B89DAB5B3AEBE3CFC73C56B71B62BE0839DAFBEB6AFF97D3F6B9BE0DF9E8745BA6A7F1463B76C4AC68218D9A1AA216C2D822D4C63CFD0205E667AF');
37
INSERT INTO "blob" VALUES(27,16,11,'e09593950837f76e70ca2f8ff2272ae3df0ba017',X'0000000B789CF38EE0F2E1F2E5F2E3F2E702000DB2020C');
38
INSERT INTO "blob" VALUES(28,16,341,'9df70ff13b57e70ea2de63f655eb72df7b83121a',X'000000EF789C0DCD3D4E03311040E1DEA7F001089AF17AFE360D52525220040D8A846C8FAD5004A4CD8AE5F86CF99AEFD173B8CDA7D8FD6BBDDCD7EBD2FBF1725FFA77B9F5BDB79F708E09100E980E886F4833F28C80BF4FFE90C69C444B86342113C2E0D273114165312E5CBD8B36F1DA306E71B71ED7BF35BCC4AA9A2A8A37E232B04332A9430B493347028284D43897F01AD5D4B077A326640C5981477611A324FB7A84F7E8CB357C441BD51C9407541D0A669433FBA05C26622E14A6069F1B1FFF019008411F');
39
INSERT INTO "blob" VALUES(29,17,11,'5ebb3c9ad50740a7382902657b84a6105c32fc7b',X'0000000B789C73E372E7F2E0F28CE4F2E202000C0101F4');
40
INSERT INTO "blob" VALUES(30,17,322,'94bd3e6b45cc15e86cc76ecfd2207fddbb675b15',X'00000142789C3DCE314E44310C04D0FE9F221758643B711C6F0BA246081A441327B696825D69F9121C9F8010F5F8CDF836F97CDB5F3FF6CFCBE1EAE7FEEEDB5D224038201D109F908F588F85B6FB7439FBCDFEB5276FB59AB5C693B19561BDA88CB0DA8B1B35AC2B4165C245F6D3D5FF10286B56869625A4BAC0E8142D8248A87B9E01D601E507FDBFF22BD9CDF2D03E19A44097DC48812A8BB5D22B028F4C31C4B687A4330422301BCB5AF04ED36B8ECAAB436885D63212F6ED31E56985D1EB2A96A22DFA8800CC6C485A88FAF69CE6F5B4BD24556990111A87AECBEEEAB50C5F8EAB308FED1BE1CB587B');
41
INSERT INTO "blob" VALUES(31,18,11,'85286cb3bc6d9e6f2f586eb5532f6065678f75b9',X'0000000B789C73E372E7F2E0F2E4F28AE402000BA301F4');
42
INSERT INTO "blob" VALUES(32,18,360,'333c4d56d218735e20565944b50202f24827e3b8',X'00000168789C25CF3D4E43311004E0DEA7F00582BCDE1FAFD382A8118206D1ECDA5E250D91C213E1F83C9476349F34F398D73C6F9FDFDBED929E722D500E500F006F20472A47C4F49CE3FCB31EB6DF2D6B94EE83D9A42CD76145028AA1736B66612ADD11A4F36E2E5F77328D8722097509A40AC35943C965715F9D11669F5469EE643B5DD71DADB927D067AB32A161804E0FB26E259481A6192E1C46FFE876B94FE3AA321C7DC8EC4BA206AB2C67C61A5284A56934F69E5E324EF6B1EA223271ECB5F0DE031AAC604630558294A9A4D76C4B54753F568B8B16F4D5102946AD4EA1BAD27B9ED753FAC80338F6EBB37A31F568AD888A556519A32B78FA037C076278');
43
CREATE TABLE delta(
44
rid INTEGER PRIMARY KEY,
45
srcid INTEGER NOT NULL REFERENCES blob
46
);
47
INSERT INTO "delta" VALUES(5,8);
48
INSERT INTO "delta" VALUES(11,32);
49
INSERT INTO "delta" VALUES(15,17);
50
INSERT INTO "delta" VALUES(17,21);
51
INSERT INTO "delta" VALUES(28,30);
52
CREATE TABLE rcvfrom(
53
rcvid INTEGER PRIMARY KEY,
54
uid INTEGER REFERENCES user,
55
mtime DATETIME,
56
nonce TEXT UNIQUE,
57
ipaddr TEXT
58
);
59
INSERT INTO "rcvfrom" VALUES(1,1,2455542.12469579,NULL,NULL);
60
INSERT INTO "rcvfrom" VALUES(2,1,2455542.12638891,NULL,NULL);
61
INSERT INTO "rcvfrom" VALUES(3,1,2455542.12705387,NULL,'127.0.0.1');
62
INSERT INTO "rcvfrom" VALUES(4,1,2455542.12796271,NULL,NULL);
63
INSERT INTO "rcvfrom" VALUES(5,1,2455542.12818105,NULL,'127.0.0.1');
64
INSERT INTO "rcvfrom" VALUES(6,1,2455542.12873891,NULL,NULL);
65
INSERT INTO "rcvfrom" VALUES(7,1,2455542.1294266,NULL,NULL);
66
INSERT INTO "rcvfrom" VALUES(8,1,2455542.12999842,NULL,NULL);
67
INSERT INTO "rcvfrom" VALUES(9,1,2455542.13015219,NULL,NULL);
68
INSERT INTO "rcvfrom" VALUES(10,1,2455542.13073123,NULL,'127.0.0.1');
69
INSERT INTO "rcvfrom" VALUES(11,1,2455542.13090438,NULL,'127.0.0.1');
70
INSERT INTO "rcvfrom" VALUES(12,1,2455542.1333612,NULL,NULL);
71
INSERT INTO "rcvfrom" VALUES(13,1,2455542.13353873,NULL,'127.0.0.1');
72
INSERT INTO "rcvfrom" VALUES(14,1,2455542.13467894,NULL,NULL);
73
INSERT INTO "rcvfrom" VALUES(15,1,2455542.13571911,NULL,NULL);
74
INSERT INTO "rcvfrom" VALUES(16,1,2455542.13623403,NULL,NULL);
75
INSERT INTO "rcvfrom" VALUES(17,1,2455542.13660848,NULL,NULL);
76
INSERT INTO "rcvfrom" VALUES(18,1,2455542.19483546,NULL,NULL);
77
CREATE TABLE user(
78
uid INTEGER PRIMARY KEY,
79
login TEXT,
80
pw TEXT,
81
cap TEXT,
82
cookie TEXT,
83
ipaddr TEXT,
84
cexpire DATETIME,
85
info TEXT,
86
photo BLOB
87
);
88
INSERT INTO "user" VALUES(1,'drh','efbbd0','s',NULL,NULL,NULL,'',NULL);
89
INSERT INTO "user" VALUES(2,'anonymous','42568D1800352E28','ghmncz',NULL,NULL,NULL,'Anon',NULL);
90
INSERT INTO "user" VALUES(3,'nobody','','jor',NULL,NULL,NULL,'Nobody',NULL);
91
INSERT INTO "user" VALUES(4,'developer','','dei',NULL,NULL,NULL,'Dev',NULL);
92
INSERT INTO "user" VALUES(5,'reader','','kptw',NULL,NULL,NULL,'Reader',NULL);
93
CREATE TABLE config(
94
name TEXT PRIMARY KEY NOT NULL,
95
value CLOB,
96
CHECK( typeof(name)='text' AND length(name)>=1 )
97
);
98
INSERT INTO "config" VALUES('server-code','48d0adf1afd58dae13c5b70ff7aff208fb8b9f53');
99
INSERT INTO "config" VALUES('project-code','8201587e22864f2fe6b8eb623626de6f9f747058');
100
INSERT INTO "config" VALUES('autosync','1');
101
INSERT INTO "config" VALUES('localauth','0');
102
INSERT INTO "config" VALUES('project-name','Test Case 1');
103
INSERT INTO "config" VALUES('project-description','Fossil repository for testing');
104
INSERT INTO "config" VALUES('index-page','/timeline');
105
INSERT INTO "config" VALUES('content-schema','1');
106
INSERT INTO "config" VALUES('aux-schema','2010-11-24');
107
CREATE TABLE shun(uuid UNIQUE);
108
CREATE TABLE private(rid INTEGER PRIMARY KEY);
109
CREATE TABLE reportfmt(
110
rn integer primary key,
111
owner text,
112
title text,
113
cols text,
114
sqlcode text
115
);
116
INSERT INTO "reportfmt" VALUES(1,NULL,'All Tickets','#ffffff Key:
117
#f2dcdc Active
118
#e8e8e8 Review
119
#cfe8bd Fixed
120
#bde5d6 Tested
121
#cacae5 Deferred
122
#c8c8c8 Closed','SELECT
123
CASE WHEN status IN (''Open'',''Verified'') THEN ''#f2dcdc''
124
WHEN status=''Review'' THEN ''#e8e8e8''
125
WHEN status=''Fixed'' THEN ''#cfe8bd''
126
WHEN status=''Tested'' THEN ''#bde5d6''
127
WHEN status=''Deferred'' THEN ''#cacae5''
128
ELSE ''#c8c8c8'' END AS ''bgcolor'',
129
substr(tkt_uuid,1,10) AS ''#'',
130
datetime(tkt_mtime) AS ''mtime'',
131
type,
132
status,
133
subsystem,
134
title
135
FROM ticket');
136
CREATE TABLE concealed(
137
hash TEXT PRIMARY KEY,
138
content TEXT
139
);
140
CREATE TABLE filename(
141
fnid INTEGER PRIMARY KEY,
142
name TEXT UNIQUE
143
);
144
INSERT INTO "filename" VALUES(1,'four.txt');
145
INSERT INTO "filename" VALUES(2,'one.txt');
146
INSERT INTO "filename" VALUES(3,'three.txt');
147
INSERT INTO "filename" VALUES(4,'two.txt');
148
INSERT INTO "filename" VALUES(5,'five.txt');
149
INSERT INTO "filename" VALUES(6,'six.txt');
150
INSERT INTO "filename" VALUES(7,'two-rename.txt');
151
CREATE TABLE mlink(
152
mid INTEGER REFERENCES blob,
153
pid INTEGER REFERENCES blob,
154
fid INTEGER REFERENCES blob,
155
fnid INTEGER REFERENCES filename,
156
pfnid INTEGER REFERENCES filename
157
);
158
INSERT INTO "mlink" VALUES(8,0,7,1,0);
159
INSERT INTO "mlink" VALUES(5,0,2,2,0);
160
INSERT INTO "mlink" VALUES(5,0,3,3,0);
161
INSERT INTO "mlink" VALUES(5,0,4,4,0);
162
INSERT INTO "mlink" VALUES(11,0,10,5,0);
163
INSERT INTO "mlink" VALUES(13,0,12,6,0);
164
INSERT INTO "mlink" VALUES(21,3,20,3,0);
165
INSERT INTO "mlink" VALUES(17,4,16,4,0);
166
INSERT INTO "mlink" VALUES(15,2,14,2,0);
167
INSERT INTO "mlink" VALUES(24,0,23,1,0);
168
INSERT INTO "mlink" VALUES(24,2,0,2,0);
169
INSERT INTO "mlink" VALUES(26,2,25,2,0);
170
INSERT INTO "mlink" VALUES(30,4,29,7,0);
171
INSERT INTO "mlink" VALUES(28,3,27,3,0);
172
INSERT INTO "mlink" VALUES(28,4,4,7,4);
173
INSERT INTO "mlink" VALUES(28,4,0,4,0);
174
INSERT INTO "mlink" VALUES(32,4,31,4,0);
175
CREATE TABLE plink(
176
pid INTEGER REFERENCES blob,
177
cid INTEGER REFERENCES blob,
178
isprim BOOLEAN,
179
mtime DATETIME,
180
UNIQUE(pid, cid)
181
);
182
INSERT INTO "plink" VALUES(5,8,1,2455542.12795139);
183
INSERT INTO "plink" VALUES(1,5,1,2455542.12638889);
184
INSERT INTO "plink" VALUES(5,11,1,2455542.12873843);
185
INSERT INTO "plink" VALUES(5,13,1,2455542.1294213);
186
INSERT INTO "plink" VALUES(17,21,1,2455542.13335648);
187
INSERT INTO "plink" VALUES(15,17,1,2455542.13015046);
188
INSERT INTO "plink" VALUES(5,15,1,2455542.12998843);
189
INSERT INTO "plink" VALUES(5,24,1,2455542.13467593);
190
INSERT INTO "plink" VALUES(5,26,1,2455542.13571759);
191
INSERT INTO "plink" VALUES(28,30,1,2455542.13659722);
192
INSERT INTO "plink" VALUES(26,28,1,2455542.13622685);
193
INSERT INTO "plink" VALUES(11,32,1,2455542.19482639);
194
CREATE TABLE event(
195
type TEXT,
196
mtime DATETIME,
197
objid INTEGER PRIMARY KEY,
198
tagid INTEGER,
199
uid INTEGER REFERENCES user,
200
bgcolor TEXT,
201
euser TEXT,
202
user TEXT,
203
ecomment TEXT,
204
comment TEXT,
205
brief TEXT,
206
omtime DATETIME
207
);
208
INSERT INTO "event" VALUES('ci',2455542.1246875,1,NULL,NULL,NULL,NULL,'drh',NULL,'initial empty check-in',NULL,NULL);
209
INSERT INTO "event" VALUES('ci',2455542.12638889,5,NULL,NULL,NULL,NULL,'drh',NULL,'add three initial files',NULL,NULL);
210
INSERT INTO "event" VALUES('ci',2455542.12795139,8,NULL,NULL,NULL,NULL,'drh',NULL,'add four.txt',NULL,2455542.12795139);
211
INSERT INTO "event" VALUES('ci',2455542.12873843,11,NULL,NULL,NULL,NULL,'drh',NULL,'add five.txt',NULL,NULL);
212
INSERT INTO "event" VALUES('ci',2455542.1294213,13,NULL,NULL,NULL,NULL,'drh',NULL,'add six.txt',NULL,NULL);
213
INSERT INTO "event" VALUES('ci',2455542.12998843,15,NULL,NULL,NULL,NULL,'drh',NULL,'changes to one.txt',NULL,NULL);
214
INSERT INTO "event" VALUES('ci',2455542.13015046,17,NULL,NULL,NULL,NULL,'drh',NULL,'changes to two.txt',NULL,NULL);
215
INSERT INTO "event" VALUES('ci',2455542.13335648,21,NULL,NULL,NULL,NULL,'drh',NULL,'changes to three.txt',NULL,2455542.13335648);
216
INSERT INTO "event" VALUES('ci',2455542.13467593,24,NULL,NULL,NULL,NULL,'drh',NULL,'drop one; add new four',NULL,NULL);
217
INSERT INTO "event" VALUES('ci',2455542.13571759,26,NULL,NULL,NULL,NULL,'drh',NULL,'change one',NULL,NULL);
218
INSERT INTO "event" VALUES('ci',2455542.13622685,28,NULL,NULL,NULL,NULL,'drh',NULL,'edit three; rename two',NULL,NULL);
219
INSERT INTO "event" VALUES('ci',2455542.13659722,30,NULL,NULL,NULL,NULL,'drh',NULL,'edit two-rename',NULL,NULL);
220
INSERT INTO "event" VALUES('ci',2455542.19482639,32,NULL,NULL,NULL,NULL,'drh',NULL,'edit two',NULL,NULL);
221
CREATE TABLE phantom(
222
rid INTEGER PRIMARY KEY
223
);
224
CREATE TABLE orphan(
225
rid INTEGER PRIMARY KEY,
226
baseline INTEGER
227
);
228
CREATE TABLE unclustered(
229
rid INTEGER PRIMARY KEY
230
);
231
INSERT INTO "unclustered" VALUES(1);
232
INSERT INTO "unclustered" VALUES(2);
233
INSERT INTO "unclustered" VALUES(3);
234
INSERT INTO "unclustered" VALUES(4);
235
INSERT INTO "unclustered" VALUES(5);
236
INSERT INTO "unclustered" VALUES(6);
237
INSERT INTO "unclustered" VALUES(7);
238
INSERT INTO "unclustered" VALUES(8);
239
INSERT INTO "unclustered" VALUES(9);
240
INSERT INTO "unclustered" VALUES(10);
241
INSERT INTO "unclustered" VALUES(11);
242
INSERT INTO "unclustered" VALUES(12);
243
INSERT INTO "unclustered" VALUES(13);
244
INSERT INTO "unclustered" VALUES(14);
245
INSERT INTO "unclustered" VALUES(15);
246
INSERT INTO "unclustered" VALUES(16);
247
INSERT INTO "unclustered" VALUES(17);
248
INSERT INTO "unclustered" VALUES(18);
249
INSERT INTO "unclustered" VALUES(19);
250
INSERT INTO "unclustered" VALUES(20);
251
INSERT INTO "unclustered" VALUES(21);
252
INSERT INTO "unclustered" VALUES(22);
253
INSERT INTO "unclustered" VALUES(23);
254
INSERT INTO "unclustered" VALUES(24);
255
INSERT INTO "unclustered" VALUES(25);
256
INSERT INTO "unclustered" VALUES(26);
257
INSERT INTO "unclustered" VALUES(27);
258
INSERT INTO "unclustered" VALUES(28);
259
INSERT INTO "unclustered" VALUES(29);
260
INSERT INTO "unclustered" VALUES(30);
261
INSERT INTO "unclustered" VALUES(31);
262
INSERT INTO "unclustered" VALUES(32);
263
CREATE TABLE unsent(
264
rid INTEGER PRIMARY KEY
265
);
266
INSERT INTO "unsent" VALUES(31);
267
INSERT INTO "unsent" VALUES(32);
268
CREATE TABLE tag(
269
tagid INTEGER PRIMARY KEY,
270
tagname TEXT UNIQUE
271
);
272
INSERT INTO "tag" VALUES(1,'bgcolor');
273
INSERT INTO "tag" VALUES(2,'comment');
274
INSERT INTO "tag" VALUES(3,'user');
275
INSERT INTO "tag" VALUES(4,'date');
276
INSERT INTO "tag" VALUES(5,'hidden');
277
INSERT INTO "tag" VALUES(6,'private');
278
INSERT INTO "tag" VALUES(7,'cluster');
279
INSERT INTO "tag" VALUES(8,'branch');
280
INSERT INTO "tag" VALUES(9,'closed');
281
INSERT INTO "tag" VALUES(10,'sym-trunk');
282
INSERT INTO "tag" VALUES(11,'sym-baseline');
283
INSERT INTO "tag" VALUES(12,'sym-br1');
284
INSERT INTO "tag" VALUES(13,'sym-br2');
285
INSERT INTO "tag" VALUES(14,'sym-br3');
286
INSERT INTO "tag" VALUES(15,'sym-chng1');
287
INSERT INTO "tag" VALUES(16,'sym-chng2');
288
INSERT INTO "tag" VALUES(17,'sym-chng3');
289
INSERT INTO "tag" VALUES(18,'sym-br4');
290
INSERT INTO "tag" VALUES(19,'sym-br5');
291
CREATE TABLE tagxref(
292
tagid INTEGER REFERENCES tag,
293
tagtype INTEGER,
294
srcid INTEGER REFERENCES blob,
295
origid INTEGER REFERENCES blob,
296
value TEXT,
297
mtime TIMESTAMP,
298
rid INTEGER REFERENCE blob,
299
UNIQUE(rid, tagid)
300
);
301
INSERT INTO "tagxref" VALUES(8,2,1,1,'trunk',2455542.1246875,1);
302
INSERT INTO "tagxref" VALUES(10,2,1,1,NULL,2455542.1246875,1);
303
INSERT INTO "tagxref" VALUES(4,1,6,5,'2010-12-11 15:02:00',2455542.12704861,5);
304
INSERT INTO "tagxref" VALUES(11,1,6,5,NULL,2455542.12704861,5);
305
INSERT INTO "tagxref" VALUES(8,2,0,1,'trunk',2455542.1246875,5);
306
INSERT INTO "tagxref" VALUES(10,2,0,1,NULL,2455542.1246875,5);
307
INSERT INTO "tagxref" VALUES(8,2,9,8,'br1',2455542.1281713,8);
308
INSERT INTO "tagxref" VALUES(12,2,9,8,NULL,2455542.1281713,8);
309
INSERT INTO "tagxref" VALUES(4,1,9,8,'2010-12-11 15:04:15',2455542.1281713,8);
310
INSERT INTO "tagxref" VALUES(10,0,9,8,NULL,2455542.1281713,8);
311
INSERT INTO "tagxref" VALUES(8,2,11,11,'br2',2455542.12873843,11);
312
INSERT INTO "tagxref" VALUES(13,2,11,11,NULL,2455542.12873843,11);
313
INSERT INTO "tagxref" VALUES(11,0,11,11,NULL,2455542.12873843,11);
314
INSERT INTO "tagxref" VALUES(10,0,11,11,NULL,2455542.12873843,11);
315
INSERT INTO "tagxref" VALUES(8,2,13,13,'br3',2455542.1294213,13);
316
INSERT INTO "tagxref" VALUES(14,2,13,13,NULL,2455542.1294213,13);
317
INSERT INTO "tagxref" VALUES(11,0,13,13,NULL,2455542.1294213,13);
318
INSERT INTO "tagxref" VALUES(10,0,13,13,NULL,2455542.1294213,13);
319
INSERT INTO "tagxref" VALUES(4,1,18,15,'2010-12-11 15:07:11',2455542.13072917,15);
320
INSERT INTO "tagxref" VALUES(15,1,18,15,NULL,2455542.13072917,15);
321
INSERT INTO "tagxref" VALUES(4,1,19,17,'2010-12-11 15:07:25',2455542.13090278,17);
322
INSERT INTO "tagxref" VALUES(16,1,19,17,NULL,2455542.13090278,17);
323
INSERT INTO "tagxref" VALUES(8,2,0,1,'trunk',2455542.1246875,15);
324
INSERT INTO "tagxref" VALUES(8,2,0,1,'trunk',2455542.1246875,17);
325
INSERT INTO "tagxref" VALUES(8,2,0,1,'trunk',2455542.1246875,21);
326
INSERT INTO "tagxref" VALUES(10,2,0,1,NULL,2455542.1246875,15);
327
INSERT INTO "tagxref" VALUES(10,2,0,1,NULL,2455542.1246875,17);
328
INSERT INTO "tagxref" VALUES(10,2,0,1,NULL,2455542.1246875,21);
329
INSERT INTO "tagxref" VALUES(4,1,22,21,'2010-12-11 15:12:02',2455542.13353009,21);
330
INSERT INTO "tagxref" VALUES(17,1,22,21,NULL,2455542.13353009,21);
331
INSERT INTO "tagxref" VALUES(8,2,24,24,'br4',2455542.13467593,24);
332
INSERT INTO "tagxref" VALUES(18,2,24,24,NULL,2455542.13467593,24);
333
INSERT INTO "tagxref" VALUES(11,0,24,24,NULL,2455542.13467593,24);
334
INSERT INTO "tagxref" VALUES(10,0,24,24,NULL,2455542.13467593,24);
335
INSERT INTO "tagxref" VALUES(8,2,26,26,'br5',2455542.13571759,26);
336
INSERT INTO "tagxref" VALUES(19,2,26,26,NULL,2455542.13571759,26);
337
INSERT INTO "tagxref" VALUES(11,0,26,26,NULL,2455542.13571759,26);
338
INSERT INTO "tagxref" VALUES(10,0,26,26,NULL,2455542.13571759,26);
339
INSERT INTO "tagxref" VALUES(8,2,0,26,'br5',2455542.13571759,28);
340
INSERT INTO "tagxref" VALUES(8,2,0,26,'br5',2455542.13571759,30);
341
INSERT INTO "tagxref" VALUES(19,2,0,26,NULL,2455542.13571759,28);
342
INSERT INTO "tagxref" VALUES(19,2,0,26,NULL,2455542.13571759,30);
343
INSERT INTO "tagxref" VALUES(8,2,0,11,'br2',2455542.12873843,32);
344
INSERT INTO "tagxref" VALUES(13,2,0,11,NULL,2455542.12873843,32);
345
CREATE TABLE backlink(
346
target TEXT,
347
srctype INT,
348
srcid INT,
349
mtime TIMESTAMP,
350
UNIQUE(target, srctype, srcid)
351
);
352
CREATE TABLE attachment(
353
attachid INTEGER PRIMARY KEY,
354
isLatest BOOLEAN DEFAULT 0,
355
mtime TIMESTAMP,
356
src TEXT,
357
target TEXT,
358
filename TEXT,
359
comment TEXT,
360
user TEXT
361
);
362
CREATE TABLE ticket(
363
-- Do not change any column that begins with tkt_
364
tkt_id INTEGER PRIMARY KEY,
365
tkt_uuid TEXT UNIQUE,
366
tkt_mtime DATE,
367
-- Add as many field as required below this line
368
type TEXT,
369
status TEXT,
370
subsystem TEXT,
371
priority TEXT,
372
severity TEXT,
373
foundin TEXT,
374
private_contact TEXT,
375
resolution TEXT,
376
title TEXT,
377
comment TEXT
378
);
379
CREATE INDEX delta_i1 ON delta(srcid);
380
CREATE INDEX mlink_i1 ON mlink(mid);
381
CREATE INDEX mlink_i2 ON mlink(fnid);
382
CREATE INDEX mlink_i3 ON mlink(fid);
383
CREATE INDEX mlink_i4 ON mlink(pid);
384
CREATE INDEX plink_i2 ON plink(cid,pid);
385
CREATE INDEX event_i1 ON event(mtime);
386
CREATE INDEX orphan_baseline ON orphan(baseline);
387
CREATE INDEX tagxref_i1 ON tagxref(tagid, mtime);
388
CREATE INDEX backlink_src ON backlink(srcid, srctype);
389
CREATE INDEX attachment_idx1 ON attachment(target, filename, mtime);