create_scopus.sql 1.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354
  1. #CREATE DATABASE scopus;
  2. #USE scopus;
  3. #
  4. # Table structure for table ‘publications’
  5. #
  6. CREATE TABLE IF NOT EXISTS publications (
  7. id INT AUTO_INCREMENT PRIMARY KEY,
  8. scopusid varchar(255) default NULL,
  9. eid varchar(255) default NULL,
  10. wpid int default NULL,
  11. citedbycount int default NULL,
  12. citesloaded int default NULL,
  13. categories varchar(255) default NULL,
  14. doi varchar(255) default NULL,
  15. scopusdata text default NULL,
  16. title varchar(255) default NULL,
  17. abstract text,
  18. bibtex text,
  19. ts datetime,
  20. UNIQUE KEY(scopusid)
  21. );
  22. CREATE TABLE IF NOT EXISTS citations (
  23. id INT AUTO_INCREMENT PRIMARY KEY,
  24. scopusid varchar(255) default NULL,
  25. eid varchar(255) default NULL,
  26. wpid int default NULL,
  27. wpcommentid int default NULL,
  28. citedbycount int default NULL,
  29. citesloaded int default NULL,
  30. categories varchar(255) default NULL,
  31. doi varchar(255) default NULL,
  32. scopusdata text default NULL,
  33. author varchar(255) default NULL,
  34. title varchar(255) default NULL,
  35. journal varchar(255) default NULL,
  36. volume varchar(255) default NULL,
  37. pages varchar(255) default NULL,
  38. articleno varchar(255) default NULL,
  39. abstract text,
  40. bibtex text,
  41. ts datetime,
  42. UNIQUE KEY(wpid,scopusid)
  43. );
  44. # Todo: Save the full details of all publications
  45. # Use json serialisation !!!
  46. #