OLD | NEW |
1 /* | 1 /* |
2 The schema of the database is defined by HISTORY_URL_ROW_FIELDS found in | 2 The schema of the database is defined by HISTORY_URL_ROW_FIELDS found in |
3 url_database.h and is equivalent to: | 3 url_database.h and is equivalent to: |
4 | 4 |
5 CREATE TABLE urls(id INTEGER PRIMARY KEY, | 5 CREATE TABLE urls(id INTEGER PRIMARY KEY, |
6 url LONGVARCHAR, | 6 url LONGVARCHAR, |
7 title LONGVARCHAR, | 7 title LONGVARCHAR, |
8 visit_count INTEGER DEFAULT 0 NOT NULL, | 8 visit_count INTEGER DEFAULT 0 NOT NULL, |
9 typed_count INTEGER DEFAULT 0 NOT NULL, | 9 typed_count INTEGER DEFAULT 0 NOT NULL, |
10 last_visit_time INTEGER NOT NULL, | 10 last_visit_time INTEGER NOT NULL, |
(...skipping 39 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
50 INSERT INTO "urls" VALUES(24,'http://www.danilatos.com/event-test/ExperimentTest
.html','Experimentation Harness',6,6,0,0,0); // Qualifies | 50 INSERT INTO "urls" VALUES(24,'http://www.danilatos.com/event-test/ExperimentTest
.html','Experimentation Harness',6,6,0,0,0); // Qualifies |
51 INSERT INTO "urls" VALUES(25,'http://www.codeguru.com/','CodeGuru : codeguru',6,
6,0,0,110); // Qualifies | 51 INSERT INTO "urls" VALUES(25,'http://www.codeguru.com/','CodeGuru : codeguru',6,
6,0,0,110); // Qualifies |
52 INSERT INTO "urls" VALUES(26,'http://www.codeproject.com/','Your Development Res
ource - CodeProject',6,6,0,0,369); // Qualifies | 52 INSERT INTO "urls" VALUES(26,'http://www.codeproject.com/','Your Development Res
ource - CodeProject',6,6,0,0,369); // Qualifies |
53 INSERT INTO "urls" VALUES(27,'http://www.tomshardware.com/us/#redir','Tom''s Har
dware: Hardware News, Tests and Reviews',6,6,0,0,65); // Qualifies | 53 INSERT INTO "urls" VALUES(27,'http://www.tomshardware.com/us/#redir','Tom''s Har
dware: Hardware News, Tests and Reviews',6,6,0,0,65); // Qualifies |
54 INSERT INTO "urls" VALUES(28,'http://www.ddj.com/windows/184416623','Dr. ABRACAD
ABRA''s | Avoiding the Visual C++ Runtime Library | 2 1, 2003',6,6,0,0,0); // Q
ualifies | 54 INSERT INTO "urls" VALUES(28,'http://www.ddj.com/windows/184416623','Dr. ABRACAD
ABRA''s | Avoiding the Visual C++ Runtime Library | 2 1, 2003',6,6,0,0,0); // Q
ualifies |
55 INSERT INTO "urls" VALUES(29,'http://svcs.cnn.com/weather/getForecast?time=34&mo
de=json_html&zipCode=336736767676&locCode=EGLL&celcius=true&csiID=csi2','',6,6,0
,1,0); // Qualifies | 55 INSERT INTO "urls" VALUES(29,'http://svcs.cnn.com/weather/getForecast?time=34&mo
de=json_html&zipCode=336736767676&locCode=EGLL&celcius=true&csiID=csi2','',6,6,0
,1,0); // Qualifies |
56 INSERT INTO "urls" VALUES(30,'http://www.drudgery.com/Dogs%20and%20Mice','Life i
n the Slow Lane',8,2,2,0,0); // Qualifies | 56 INSERT INTO "urls" VALUES(30,'http://www.drudgery.com/Dogs%20and%20Mice','Life i
n the Slow Lane',8,2,2,0,0); // Qualifies |
57 INSERT INTO "urls" VALUES(31,'http://www.redrudgerydo.com/','Music of the Wild L
andscape',0,0,6,0,0); | 57 INSERT INTO "urls" VALUES(31,'http://www.redrudgerydo.com/','Music of the Wild L
andscape',0,0,6,0,0); |
58 INSERT INTO "urls" VALUES(32,'https://NearlyPerfectResult.com/','Practically Per
fect Search Result',99,99,0,0,0); // Qualifies | 58 INSERT INTO "urls" VALUES(32,'https://NearlyPerfectResult.com/','Practically Per
fect Search Result',99,99,0,0,0); // Qualifies |
59 INSERT INTO "urls" VALUES(33,'http://QuiteUselessSearchResultxyz.com/','Practica
lly Useless Search Result',4,0,99,0,0); // Qualifies | 59 INSERT INTO "urls" VALUES(33,'http://QuiteUselessSearchResultxyz.com/','Practica
lly Useless Search Result',4,0,99,0,0); // Qualifies |
| 60 INSERT INTO "urls" VALUES(34,'http://FubarFubarAndFubar.com/','Situation Normal
-- FUBARED',99,99,0,0,0); // Qualifies |
OLD | NEW |