BEGIN;

---------
-- INT --
---------

CREATE TABLE room_int (
  id UUID PRIMARY KEY,
  time TSTZRANGE NOT NULL,
  audience TEXT NOT NULL,
  created_at TIMESTAMPTZ NOT NULL,
  backend INT NOT NULL
);

WITH backends AS (
  SELECT '{0,1}'::INT[] AS values
)
INSERT INTO room_int (id, time, audience, created_at, backend)
SELECT
  MD5(RANDOM()::TEXT || CLOCK_TIMESTAMP()::TEXT)::UUID AS id,
  '[,)' AS time,
  'dev.svc.example.org' AS audience,
  NOW() AS created_at,
  backends.values[1 + FLOOR(RANDOM() * ARRAY_LENGTH(backends.values, 1))::INT] AS backend
FROM GENERATE_SERIES(1, 1000000) AS i,
     backends;

-------------
-- VARCHAR --
-------------

CREATE TABLE room_varchar (
  id UUID PRIMARY KEY,
  time TSTZRANGE NOT NULL,
  audience TEXT NOT NULL,
  created_at TIMESTAMPTZ NOT NULL,
  backend VARCHAR(32) NOT NULL
);

WITH backends AS (
  SELECT '{none,janus}'::VARCHAR[] AS values
)
INSERT INTO room_varchar (id, time, audience, created_at, backend)
SELECT
  MD5(RANDOM()::TEXT || CLOCK_TIMESTAMP()::TEXT)::UUID AS id,
  '[,)' AS time,
  'dev.svc.example.org' AS audience,
  NOW() AS created_at,
  backends.values[1 + FLOOR(RANDOM() * ARRAY_LENGTH(backends.values, 1))::INT] AS backend
FROM GENERATE_SERIES(1, 1000000) AS i,
     backends;

----------
-- ENUM --
----------

CREATE TYPE room_enum_backend AS ENUM ('none', 'janus');

CREATE TABLE room_enum (
  id UUID PRIMARY KEY,
  time TSTZRANGE NOT NULL,
  audience TEXT NOT NULL,
  created_at TIMESTAMPTZ NOT NULL,
  backend room_enum_backend NOT NULL
);

WITH backends AS (
  SELECT '{none,janus}'::room_enum_backend[] AS values
)
INSERT INTO room_enum (id, time, audience, created_at, backend)
SELECT
  MD5(RANDOM()::TEXT || CLOCK_TIMESTAMP()::TEXT)::UUID AS id,
  '[,)' AS time,
  'dev.svc.example.org' AS audience,
  NOW() AS created_at,
  backends.values[1 + FLOOR(RANDOM() * ARRAY_LENGTH(backends.values, 1))::INT] AS backend
FROM GENERATE_SERIES(1, 1000000) AS i,
     backends;

COMMIT;