text: -- AUTO-GENERATED BY igluctl DO NOT EDIT
  -- Generator: igluctl 0.2.0
  -- Generated: 2017-04-12 13:08
  
  CREATE SCHEMA IF NOT EXISTS atomic;
  
  CREATE TABLE IF NOT EXISTS atomic.com_optimizely_optimizelyx_summary_1 (
      "schema_vendor"  VARCHAR(128)  ENCODE RUNLENGTH NOT NULL,
      "schema_name"    VARCHAR(128)  ENCODE RUNLENGTH NOT NULL,
      "schema_format"  VARCHAR(128)  ENCODE RUNLENGTH NOT NULL,
      "schema_version" VARCHAR(128)  ENCODE RUNLENGTH NOT NULL,
      "root_id"        CHAR(36)      ENCODE RAW       NOT NULL,
      "root_tstamp"    TIMESTAMP     ENCODE LZO       NOT NULL,
      "ref_root"       VARCHAR(255)  ENCODE RUNLENGTH NOT NULL,
      "ref_tree"       VARCHAR(1500) ENCODE RUNLENGTH NOT NULL,
      "ref_parent"     VARCHAR(255)  ENCODE RUNLENGTH NOT NULL,
      "experiment_id"  BIGINT        ENCODE LZO,
      "variation"      BIGINT        ENCODE LZO,
      "variation_name" VARCHAR(255)  ENCODE LZO,
      "visitor_id"     VARCHAR(100)  ENCODE LZO,
      FOREIGN KEY (root_id) REFERENCES atomic.events(event_id)
  )
  DISTSTYLE KEY
  DISTKEY (root_id)
  SORTKEY (root_tstamp);
  
  COMMENT ON TABLE atomic.com_optimizely_optimizelyx_summary_1 IS 'iglu:com.optimizely.optimizelyx/summary/jsonschema/1-0-0';
  