iolloyd · July 12, 2016 16:33
diff --git a/uuid_indexing.conf b/uuid_indexing.conf
  sql_query_pre = SET @x = 0
  # Since we have a uuid as an id, we need to swap that out
  # for an integer

  sql_query = \
      SELECT \
          @x := @x + 1 as id, user_id, type, name, email, browser, question, unix_timestamp(created) as created \
      FROM \
          contacts
	sql_query_pre = SET @x = 0
	# Since we have a uuid as an id, we need to swap that out
	# for an integer

	sql_query = \
	SELECT \
	@x := @x + 1 as id, user_id, type, name, email, browser, question, unix_timestamp(created) as created \
	FROM \
	contacts