# use these commands if you use CockroachDB
kubectl exec -ti cockroachdb-0 sh
./cockroach sql --execute "CREATE DATABASE cp_test_db" --insecure

CREATE TABLE "people" (
  "id" SERIAL PRIMARY KEY,
  "first_name" varchar NOT NULL,
  "last_name" varchar NOT NULL,
  "age" int NOT NULL,
  "employment" varchar NOT NULL,
  "location" varchar NOT NULL,
  "pet_name" varchar NOT NULL,
  "favorite_color" varchar NOT NULL,
  "server_id" int NOT NULL,
  "add_timestamp" varchar NOT NULL
);