challenges-dump

--
-- PostgreSQL database dump
--

-- Dumped from database version 15.3
-- Dumped by pg_dump version 15.3

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

--
-- Name: core_db; Type: DATABASE; Schema: -; Owner: postgres
--

CREATE DATABASE core_db;

\connect core_db

--
-- Name: challenges_schema; Type: SCHEMA; Schema: -; Owner: postgres
--

CREATE SCHEMA challenges_schema;

ALTER SCHEMA challenges_schema OWNER TO postgres;

SET search_path TO challenges_schema;

--
-- Name: challenges; Type: TABLE; Schema: challenges_schema; Owner: postgres
--

CREATE TABLE challenges (
    id serial4 NOT NULL,
    name varchar(50) NOT NULL,
    description text,
    endpoint varchar(50) NOT NULL,
    test_cases json,
    java text,
    python text,
    CONSTRAINT challenges_endpoint_key UNIQUE (endpoint),
    CONSTRAINT challenges_pkey PRIMARY KEY (id)
);

ALTER TABLE challenges OWNER TO postgres;

--
-- Data for Name: challenges; Type: TABLE DATA; Schema: challenges_schema; Owner: postgres
--

COPY challenges (id, name, description, endpoint, test_cases, java, python) FROM stdin;
1   Quick Sort    Sort the array using quick sort   /quick-sort    {"input":["3 2 1","14 9 10","-1 0 0"], "output":["1 2 3", "9 10 14", "-1 0 0"]}    import java.util.*;
public class Answer{
public static List<Integer> compute(List<Integer> input){ return input;}}    python-quick-sort
2   Is Palindrome Check if the string is palindrome /is-palindrome {"input":["abba", "abcd", "dkd"], "output":[true, false, true]}    import java.util.*;    python-is-palindrome
3   Fibonacci Series  Generate Fibonacci Series /fibonacci  {"input":[10, 1, 2], "output":["0 1 1 2 3 5 8 13 21 34", "0", "0 1"]}    import java.util.*;
public class Answer{
public static List<Integer> compute(int n){
}
}    python-fibonacci
\.

--
-- Name: challenges_id_seq; Type: SEQUENCE; Schema: challenges_schema; Owner: postgres
--

ALTER SEQUENCE challenges_id_seq OWNED BY challenges.id;

--
-- PostgreSQL database dump complete
--