PageRenderTime 56ms CodeModel.GetById 30ms RepoModel.GetById 0ms app.codeStats 0ms

/misc/keywords.sql

http://github.com/nodemaker/Shell
SQL | 38 lines | 38 code | 0 blank | 0 comment | 0 complexity | 178e7b18d348236f8fa3f9ee75c2efb0 MD5 | raw file
    

  1. BEGIN TRANSACTION;
    2. 

  2. CREATE TABLE "keywords" (id INTEGER PRIMARY KEY,short_name VARCHAR NOT NULL,keyword VARCHAR NOT NULL,favicon_url VARCHAR NOT NULL,url VARCHAR NOT NULL,show_in_default_list INTEGER,safe_for_autoreplace INTEGER,originating_url VARCHAR,date_created INTEGER DEFAULT 0,usage_count INTEGER DEFAULT 0,input_encodings VARCHAR,suggest_url VARCHAR,prepopulate_id INTEGER DEFAULT 0,autogenerate_keyword INTEGER DEFAULT 0,logo_id INTEGER DEFAULT 0,created_by_policy INTEGER DEFAULT 0,instant_url VARCHAR);
    3. 

  3. INSERT INTO "keywords" VALUES(2,'Google (Default) (Default)','ggle','http://www.google.com/favicon.ico','{google:baseURL}search?{google:RLZ}{google:acceptedSuggestion}{google:originalQueryForSuggestion}sourceid=chrome&ie={inputEncoding}&q={searchTerms}',1,0,'',0,5,'UTF-8','{google:baseSuggestURL}search?client=chrome&hl={language}&q={searchTerms}',1,0,6256,0,'{google:baseURL}webhp?{google:RLZ}sourceid=chrome-instant&ie={inputEncoding}&ion=1{searchTerms}&nord=1');
    4. 

  4. INSERT INTO "keywords" VALUES(4,'Bing','bing','http://www.bing.com/s/wlflag.ico','http://www.bing.com/search?setmkt=en-US&q={searchTerms}',1,0,'',0,1,'UTF-8','http://api.bing.com/osjson.aspx?query={searchTerms}&language={language}',3,0,6250,0,'');
    5. 

  5. INSERT INTO "keywords" VALUES(8,'youtube.com','utube','http://www.youtube.com/favicon.ico','http://www.youtube.com/results?search_query={searchTerms}&page={startPage?}&utm_source=opensearch',0,0,'http://www.youtube.com/opensearch?locale=en_US',1262593880,2,'','',0,0,0,0,'');
    6. 

  6. INSERT INTO "keywords" VALUES(15,'ufl.edu','ufl','http://www.ufl.edu/favicon.ico','http://search.ufl.edu/web?query={searchTerms}',0,0,'http://www.ufl.edu/opensearch.xml',1273185159,0,'','',0,0,0,0,'');
    7. 

  7. INSERT INTO "keywords" VALUES(16,'Grooveshark','gshark','http://listen.grooveshark.com/webincludes/images/favicon.ico?1','http://listen.grooveshark.com/#/search/songs/?query={searchTerms}',0,0,'http://listen.grooveshark.com/litesearch.xml',1273205764,0,'UTF-8','',0,0,0,0,'');
    8. 

  8. INSERT INTO "keywords" VALUES(18,'CNN.com','cnn','http://www.cnn.com/favicon.ico','http://www.cnn.com/search/?query={searchTerms}',0,0,'http://www.cnn.com/tools/search/cnncom.xml',1273546684,0,'UTF-8','',0,0,0,0,'');
    9. 

  9. INSERT INTO "keywords" VALUES(21,'Facebook','fb','http://www.facebook.com/favicon.ico','http://www.facebook.com/search/?src=os&q={searchTerms}',0,0,'http://b.static.ak.fbcdn.net/rsrc.php/yJ/r/H2SSvhJMJA-.xml',1297497157,4,'UTF-8','',0,0,0,0,'');
    10. 

  10. INSERT INTO "keywords" VALUES(22,'rapidlibrary.com','rlib','http://rapidlibrary.com/favicon.ico','http://rapidlibrary.com/index.php?q={searchTerms}&filetype=0',0,0,'',1299451958,0,'UTF-8','',0,0,0,0,'');
    11. 

  11. INSERT INTO "keywords" VALUES(24,'TechCrunch','tcrunch','http://techcrunch.com/favicon.ico','http://techcrunch.com/?s={searchTerms}',0,0,'http://techcrunch.com/osd.xml',1300514112,1,'UTF-8','',0,0,0,0,'');
    12. 

  12. INSERT INTO "keywords" VALUES(25,'amazon.com','amzn','http://www.amazon.com/favicon.ico','http://www.amazon.com/s/ref=nb_sb_noss?url=search-alias%3Daps&field-keywords={searchTerms}&x=0&y=0',0,0,'',1300518675,3,'ISO-8859-1','',0,0,0,0,'');
    13. 

  13. INSERT INTO "keywords" VALUES(26,'apetube.com','atube','http://www.apetube.com/favicon.ico','http://www.apetube.com/search/?q={searchTerms}',0,0,'',1301979486,2,'UTF-8','',0,0,0,0,'');
    14. 

  14. INSERT INTO "keywords" VALUES(27,'Wikipedia (en)','wiki','http://en.wikipedia.org/favicon.ico','http://en.wikipedia.org/wiki/Special:Search?search={searchTerms}',1,0,'',1302319126,1,'UTF-8','http://en.wikipedia.org/w/api.php?action=opensearch&search={searchTerms}',0,0,0,0,'');
    15. 

  15. INSERT INTO "keywords" VALUES(28,'eBay','ebay','http://rover.ebay.com/favicon.ico','http://rover.ebay.com/rover/1/711-47294-18009-3/4?satitle={searchTerms}',1,0,'',1302319126,0,'ISO-8859-1','',0,0,0,0,'');
    16. 

  16. INSERT INTO "keywords" VALUES(29,'Creative Commons','ccmn','http://search.creativecommons.org/favicon.ico','http://search.creativecommons.org/?q={searchTerms}',1,0,'',1302319126,1,'utf-8','',0,0,0,0,'');
    17. 

  17. INSERT INTO "keywords" VALUES(30,'Answers.com','answer','http://www.answers.com/favicon.ico','http://www.answers.com/main/ntquery?s={searchTerms}&gwp=13',1,0,'',1302319126,0,'UTF-8','http://www.answers.com/main/startswith?output=json&s={searchTerms}',0,0,0,0,'');
    18. 

  18. INSERT INTO "keywords" VALUES(31,'linkedin.com','lin','http://www.linkedin.com/favicon.ico','http://www.linkedin.com/search/fpsearch?type=people&keywords={searchTerms}&pplSearchOrigin=GLHD&pageKey=member-home&search=Search',0,0,'',1302322882,2,'UTF-8','',0,0,0,0,'');
    19. 

  19. INSERT INTO "keywords" VALUES(32,'blekko','bkko','http://blekko.com/favicon.ico','http://blekko.com/ws/+{searchTerms}',0,0,'http://blekko.com/s/blekko.xml',1302324998,2,'UTF-8','http://blekko.com/autocomplete?term={searchTerms}&lang={language?}&form=opensearch',0,0,0,0,'');
    20. 

  20. INSERT INTO "keywords" VALUES(33,'DuckDuckGo','ddgo','http://duckduckgo.com/favicon.ico','http://duckduckgo.com/?q={searchTerms}',0,0,'http://duckduckgo.com/opensearch.xml',1302325104,12,'UTF-8','',0,0,0,0,'');
    21. 

  21. INSERT INTO "keywords" VALUES(34,'Wolfram|Alpha','walpha','http://www.wolframalpha.com/favicon_calculate.png','http://www.wolframalpha.com/input/?i={searchTerms}',0,0,'http://www.wolframalpha.com/searchDescription.xml',1302325135,22,'UTF-8','',0,0,0,0,'');
    22. 

  22. INSERT INTO "keywords" VALUES(35,'Dogpile','dpile','http://ttl30d.images.infospace.com.edgesuite.net/search/images/200902/favicon.ico','http://www.dogpile.com/dogpile_prefer/ws/redir/_iceUrlFlag=11?_IceUrl=true&qkw={searchTerms}',0,0,'http://ttl30d.images.infospace.com.edgesuite.net/search/images/xml/provider.xml',1302325674,1,'','',0,0,0,0,'');
    23. 

  23. INSERT INTO "keywords" VALUES(36,'ask.com','ask','http://www.ask.com/favicon.ico','http://www.ask.com/web?q={searchTerms}&search=&qsrc=0&o=0&l=dir',0,0,'',1302325816,1,'UTF-8','',0,0,0,0,'');
    24. 

  24. INSERT INTO "keywords" VALUES(37,'Yippy','yippy','http://clusty.com/images/clusty-favicon.ico','http://clusty.com/search?query={searchTerms}&tb=opensearch&',0,0,'http://clusty.com/search?v%3aproject=opensearch-desc&v%3aframe=form&',1302326122,0,'','',0,0,0,0,'');
    25. 

  25. INSERT INTO "keywords" VALUES(38,'mahalo.com','mahalo','','http://mahalo.com/{searchTerms}/',0,0,'',1302326289,6,'','',0,0,0,0,'');
    26. 

  26. INSERT INTO "keywords" VALUES(39,'Indeed Job Search','indeed','http://www.indeed.com/favicon.ico','http://www.indeed.com/jobs?q={searchTerms}&from=opensearch',0,0,'http://www.indeed.com/indeedsearchdescription.xml',1302326461,2,'','',0,0,0,0,'');
    27. 

  27. INSERT INTO "keywords" VALUES(40,'Simply Hired Job Search','shired','','http://www.simplyhired.com/a/jobs/list/q-{searchTerms}',0,0,'',1302326657,1,'','',0,0,0,0,'');
    28. 

  28. INSERT INTO "keywords" VALUES(41,'Stack Overflow','sflow','http://sstatic.net/stackoverflow/img/favicon.ico','http://stackoverflow.com/search?q={searchTerms}',0,0,'http://stackoverflow.com/opensearch.xml',1302326951,2,'UTF-8','',0,0,0,0,'');
    29. 

  29. INSERT INTO "keywords" VALUES(42,'Oodle','oodle','http://www.oodle.com/favicon.ico','http://www.oodle.com/browse_redir/?reset=1&c=&t=&g=usa%3Ava%3Aalexandria&r=50&s=&v=&inbs=&q={searchTerms}',0,0,'',1302327159,0,'UTF-8','',0,0,0,0,'');
    30. 

  30. INSERT INTO "keywords" VALUES(43,'Google Mail','gmail','','https://mail.google.com/mail/?hl=en&shva=1#search/{searchTerms}',0,0,'',1302327597,2,'','',0,0,0,0,'');
    31. 

  31. INSERT INTO "keywords" VALUES(44,'Google Images','images','','http://www.google.com/images?um=1&hl=en&biw=1280&bih=680&tbm=isch&sa=1&q={searchTerms}&aq=f&aqi=&aql=&oq=',0,0,'',1302327698,3,'','',0,0,0,0,'');
    32. 

  32. INSERT INTO "keywords" VALUES(45,'Google Videos','videos','','http://www.google.com/search?q={searchTerms}&tbo=p&tbm=vid&source=vgc&aq=f',0,0,'',1302327747,3,'','',0,0,0,0,'');
    33. 

  33. INSERT INTO "keywords" VALUES(46,'Google News','news','','http://www.google.com/webhp?sourceid=chrome-instant&ie=UTF-8&ion=1&nord=1#hl=en&nord=1&q={searchTerms}&ion=1&um=1&ie=UTF-8&tbo=u&tbs=nws:1&source=og&sa=N&tab=wn&bav=on.2,or.r_gc.r_pw.&fp=87ee1625006e7e2a&ion=1',0,0,'',1302328027,5,'','',0,0,0,0,'');
    34. 

  34. INSERT INTO "keywords" VALUES(47,'Google Shopping','shop','','http://www.google.com/#hl=en&sugexp=ldymls&xhr=t&q={searchTerms}&cp=3&qe=bG92&qesig=0lEcXgb6VtM5-ElwNMqDjA&pkc=AFgZ2tnw2RKKC-lGXQenepItOpULQ49_sJxOQjiIBLue1zWxr9w8pzzwY8ZZFCit95Cwf-mlHxi7vmq3syfeJ6zKHUkVAfyDfA&um=1&ie=UTF-8&tbo=u&tbs=shop:1&source=og&sa=N&tab=wf&biw=1280&bih=680&bav=on.2,or.r_gc.r_pw.&fp=2c1304d622775efd',0,0,'',1302328121,2,'','',0,0,0,0,'');
    35. 

  35. INSERT INTO "keywords" VALUES(48,'Google Maps','maps','','http://maps.google.com/?q={searchTerms}',0,0,'',1302328401,7,'','',0,0,0,0,'');
    36. 

  36. INSERT INTO "keywords" VALUES(49,'Apple Reference','apsdk','','http://developer.apple.com/search/index.php?q={searchTerms}',0,0,'',1302482013,1,'','',0,0,0,0,'');
    37. 

  37. INSERT INTO "keywords" VALUES(50,'TweetDeck','td','','chrome-extension://hbdpomandigafcibbmofojjchbcdagbl/?q={searchTerms}',0,0,'',1302585416,0,'','',0,0,0,0,'');
    38. 

  38. COMMIT;
    39. 

  39.