text: BEGIN; 
  
  DROP TABLE IF EXISTS measurements;
  CREATE TABLE measurements (
    sensor_id INTEGER PRIMARY KEY,
    floats FLOAT[],
    ints INT[]
  );
  CREATE INDEX idx_measurements_sensor_id ON measurements (sensor_id);
  
  INSERT INTO measurements
  VALUES
  (1, NULL, NULL),
  (2, ARRAY[NULL, NULL, NULL]::float[], ARRAY[NULL, NULL, NULL]::int[]),
  (3, ARRAY[1, 2, 3], ARRAY[1, 2, 3]),
  (4, ARRAY[1, NULL, 2], ARRAY[1, NULL, 2])
  ;
  
  COMMIT;
  