SET search_path = public, pg_catalog;

CREATE TABLE program (
    program_id serial NOT NULL,
    program_code text NOT NULL,
    program_name text NOT NULL
);


CREATE TABLE clip (
    clip_id serial NOT NULL,
    clip_name text NOT NULL,
    program_id integer NOT NULL
);


ALTER TABLE ONLY program
    ADD CONSTRAINT program_pkey PRIMARY KEY (program_id);

ALTER TABLE ONLY program
    ADD CONSTRAINT program_program_code_key UNIQUE (program_code);

ALTER TABLE ONLY clip
    ADD CONSTRAINT clip_pkey PRIMARY KEY (clip_id);

ALTER TABLE ONLY clip
    ADD CONSTRAINT "$1" FOREIGN KEY (program_id) REFERENCES program(program_id) ON UPDATE CASCADE ON DELETE CASCADE;



CREATE RULE program_clip_insert_only_1 AS ON INSERT TO clip WHERE ((SELECT count(*) AS count FROM clip WHERE clip.program_id = new.program_id) >= 1) DO INSTEAD NOTHING;


SELECT pg_catalog.setval ('program_program_id_seq', 1706, true);
SELECT pg_catalog.setval ('clip_clip_id_seq', 20348, true);