API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 28th, 2017
59
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.84 KB | None | 0 0
raw download clone embed print report
  1. CREATE TABLE dbo.cc_ident (
  2. id int8 NOT NULL DEFAULT nextval('cookie_id_seq'::regclass),
  3. id_ekb int8 NULL,
  4. date_insert timestamp NULL,
  5. mode varchar(50) NULL,
  6. source varchar(500) NULL,
  7. source_hash char(128) NULL,
  8. ip_php varchar(25) NULL,
  9. machine_mark varchar(35) NOT NULL,
  10. transition varchar(250) NULL,
  11. id_adm varchar(100) NULL,
  12. user_agent varchar(255) NULL,
  13. visit_num int2 NULL,
  14. ident_type varchar(20) NULL,
  15. charging bool NULL,
  16. chargingtime int4 NULL,
  17. dischargingtime int4 NULL,
  18. level numeric(20,10) NULL,
  19. devicepixelratio int4 NULL,
  20. connection_type varchar(50) NULL,
  21. host varchar(255) NULL,
  22. avail_height int4 NULL DEFAULT 0,
  23. avail_width int4 NULL DEFAULT 0,
  24. window_height int4 NULL DEFAULT 0,
  25. window_width int4 NULL DEFAULT 0,
  26. seance varchar(100) NULL,
  27. redirect_count int4 NULL,
  28. navigation_type int2 NULL,
  29. timezone_js int2 NULL,
  30. work_domen int2 NULL,
  31. utm_jeref varchar(255) NULL,
  32. utm_positionurl int4 NULL,
  33. clear_host varchar(255) NULL,
  34. transition_clear_host varchar(255) NULL,
  35. visit_id varchar(128) NULL,
  36. id_ekb_seance numeric(20,0) NULL,
  37. id_ekb_seance_ident_type varchar(20) NULL,
  38. fingerprint char(32) NULL
  39. )
  40. WITHOUT OIDS
  41. TABLESPACE pg_default
  42. GO
  43. GRANT SELECT(work_domen), INSERT(work_domen), UPDATE(work_domen), REFERENCES(work_domen) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  44. GO
  45. GRANT SELECT(window_width), INSERT(window_width), UPDATE(window_width), REFERENCES(window_width) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  46. GO
  47. GRANT SELECT(window_height), INSERT(window_height), UPDATE(window_height), REFERENCES(window_height) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  48. GO
  49. GRANT SELECT(visit_num), INSERT(visit_num), UPDATE(visit_num), REFERENCES(visit_num) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  50. GO
  51. GRANT SELECT(visit_id), INSERT(visit_id), UPDATE(visit_id), REFERENCES(visit_id) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  52. GO
  53. GRANT SELECT(utm_positionurl), INSERT(utm_positionurl), UPDATE(utm_positionurl), REFERENCES(utm_positionurl) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  54. GO
  55. GRANT SELECT(utm_jeref), INSERT(utm_jeref), UPDATE(utm_jeref), REFERENCES(utm_jeref) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  56. GO
  57. GRANT SELECT(user_agent), INSERT(user_agent), UPDATE(user_agent), REFERENCES(user_agent) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  58. GO
  59. GRANT SELECT(transition_clear_host), INSERT(transition_clear_host), UPDATE(transition_clear_host), REFERENCES(transition_clear_host) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  60. GO
  61. GRANT SELECT(transition), INSERT(transition), UPDATE(transition), REFERENCES(transition) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  62. GO
  63. GRANT SELECT(timezone_js), INSERT(timezone_js), UPDATE(timezone_js), REFERENCES(timezone_js) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  64. GO
  65. GRANT SELECT(source_hash), INSERT(source_hash), UPDATE(source_hash), REFERENCES(source_hash) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  66. GO
  67. GRANT SELECT(source), INSERT(source), UPDATE(source), REFERENCES(source) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  68. GO
  69. GRANT SELECT(seance), INSERT(seance), UPDATE(seance), REFERENCES(seance) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  70. GO
  71. GRANT SELECT(redirect_count), INSERT(redirect_count), UPDATE(redirect_count), REFERENCES(redirect_count) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  72. GO
  73. GRANT SELECT(navigation_type), INSERT(navigation_type), UPDATE(navigation_type), REFERENCES(navigation_type) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  74. GO
  75. GRANT SELECT(mode), INSERT(mode), UPDATE(mode), REFERENCES(mode) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  76. GO
  77. GRANT SELECT(machine_mark), INSERT(machine_mark), UPDATE(machine_mark), REFERENCES(machine_mark) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  78. GO
  79. GRANT SELECT(level), INSERT(level), UPDATE(level), REFERENCES(level) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  80. GO
  81. GRANT SELECT(ip_php), INSERT(ip_php), UPDATE(ip_php), REFERENCES(ip_php) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  82. GO
  83. GRANT SELECT(ident_type), INSERT(ident_type), UPDATE(ident_type), REFERENCES(ident_type) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  84. GO
  85. GRANT SELECT(id_ekb_seance_ident_type), INSERT(id_ekb_seance_ident_type), UPDATE(id_ekb_seance_ident_type), REFERENCES(id_ekb_seance_ident_type) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  86. GO
  87. GRANT SELECT(id_ekb_seance), INSERT(id_ekb_seance), UPDATE(id_ekb_seance), REFERENCES(id_ekb_seance) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  88. GO
  89. GRANT SELECT(id_ekb), INSERT(id_ekb), UPDATE(id_ekb), REFERENCES(id_ekb) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  90. GO
  91. GRANT SELECT(id_adm), INSERT(id_adm), UPDATE(id_adm), REFERENCES(id_adm) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  92. GO
  93. GRANT SELECT(id), INSERT(id), UPDATE(id), REFERENCES(id) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  94. GO
  95. GRANT SELECT(host), INSERT(host), UPDATE(host), REFERENCES(host) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  96. GO
  97. GRANT SELECT(fingerprint), INSERT(fingerprint), UPDATE(fingerprint), REFERENCES(fingerprint) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  98. GO
  99. GRANT SELECT(dischargingtime), INSERT(dischargingtime), UPDATE(dischargingtime), REFERENCES(dischargingtime) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  100. GO
  101. GRANT SELECT(devicepixelratio), INSERT(devicepixelratio), UPDATE(devicepixelratio), REFERENCES(devicepixelratio) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  102. GO
  103. GRANT SELECT(date_insert), INSERT(date_insert), UPDATE(date_insert), REFERENCES(date_insert) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  104. GO
  105. GRANT SELECT(connection_type), INSERT(connection_type), UPDATE(connection_type), REFERENCES(connection_type) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  106. GO
  107. GRANT SELECT(clear_host), INSERT(clear_host), UPDATE(clear_host), REFERENCES(clear_host) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  108. GO
  109. GRANT SELECT(chargingtime), INSERT(chargingtime), UPDATE(chargingtime), REFERENCES(chargingtime) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  110. GO
  111. GRANT SELECT(charging), INSERT(charging), UPDATE(charging), REFERENCES(charging) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  112. GO
  113. GRANT SELECT(avail_width), INSERT(avail_width), UPDATE(avail_width), REFERENCES(avail_width) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  114. GO
  115. GRANT SELECT(avail_height), INSERT(avail_height), UPDATE(avail_height), REFERENCES(avail_height) ON dbo.cc_ident TO bgloader WITH GRANT OPTION
  116. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!