daily pastebin goal
42%
SHARE
TWEET

Untitled

a guest May 17th, 2018 89 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE clickstream (
  2.     clickstream_id bigint DEFAULT nextval('clickstream_seq'::regclass) NOT NULL,
  3.     cookie_id character varying(255),
  4.     user_id character varying(255),
  5.     start_date timestamp without time zone,
  6.     end_date timestamp without time zone,
  7.     referer character varying(255),
  8.     remote_address character varying(255),
  9.     remote_hostname character varying(255),
  10.     user_agent character varying(255),
  11.     bot boolean,
  12.     host_id character varying(50),
  13.     last_page_id character varying(50),
  14.     first_page_id character varying(50),
  15.     operating_system character varying(50),
  16.     browser_name character varying(50),
  17.     browser_version character varying(50),
  18.     mobile_device boolean,
  19.     number_of_requests integer
  20. );
  21.  
  22.  
  23. ALTER TABLE public.clickstream OWNER TO root;
  24.  
  25. --
  26. -- Name: clickstream_pkey; Type: CONSTRAINT; Schema: public; Owner: root; Tablespace:
  27. --
  28.  
  29. ALTER TABLE ONLY clickstream
  30.     ADD CONSTRAINT clickstream_pkey PRIMARY KEY (clickstream_id);
  31.  
  32. CREATE INDEX clickstream_cookieid_idx ON clickstream USING btree (cookie_id);
  33.  
  34. CREATE TABLE clickstream_request (
  35.     clickstream_request_id bigint DEFAULT nextval('clickstream_request_seq'::regclass) NOT NULL,
  36.     clickstream_id bigint,
  37.     server_name character varying(255),
  38.     protocol character varying(255),
  39.     server_port integer,
  40.     request_uri character varying(255),
  41.     request_order integer,
  42.     query_string text,
  43.     language_id bigint,
  44.     timestampper timestamp without time zone,
  45.     host_id character varying(255),
  46.     associated_identifier character varying(50)
  47. );
  48.  
  49.  
  50. ALTER TABLE public.clickstream_request OWNER TO root;
  51.  
  52. --
  53. -- Name: clickstream_request_pkey; Type: CONSTRAINT; Schema: public; Owner: root; Tablespace:
  54. --
  55.  
  56. ALTER TABLE ONLY clickstream_request
  57.     ADD CONSTRAINT clickstream_request_pkey PRIMARY KEY (clickstream_request_id);
  58.  
  59.  
  60. --
  61. -- Name: clickstream_timestamp_idx; Type: INDEX; Schema: public; Owner: root; Tablespace:
  62. --
  63.  
  64. CREATE INDEX clickstream_timestamp_idx ON clickstream_request USING btree (timestampper);
  65.  
  66.  
  67. --
  68. -- Name: clickstrem_request_host_idx; Type: INDEX; Schema: public; Owner: root; Tablespace:
  69. --
  70.  
  71. CREATE INDEX clickstrem_request_host_idx ON clickstream_request USING btree (host_id);
RAW Paste Data
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
 
Top