source: waeup_z2sql/trunk/waeup-schema.sql @ 81

--
-- PostgreSQL database dump
--

SET client_encoding = 'UNICODE';
SET check_function_bodies = false;

SET SESSION AUTHORIZATION 'postgres';

SET search_path = public, pg_catalog;

--
-- TOC entry 34 (OID 31835)
-- Name: plpgsql_call_handler(); Type: FUNC PROCEDURAL LANGUAGE; Schema: public; Owner: postgres
--

CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler
    AS '/usr/lib/postgresql/lib/plpgsql.so', 'plpgsql_call_handler'
    LANGUAGE c;


SET SESSION AUTHORIZATION DEFAULT;

--
-- TOC entry 33 (OID 31836)
-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: public; Owner: 
--

CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER plpgsql_call_handler;


SET SESSION AUTHORIZATION 'postgres';

--
-- TOC entry 4 (OID 2200)
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;
GRANT ALL ON SCHEMA public TO imke;
GRANT CREATE ON SCHEMA public TO "109";


SET SESSION AUTHORIZATION 'postgres';

--
-- TOC entry 35 (OID 74293)
-- Name: char(integer); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION "char"(integer) RETURNS text
    AS '
    SELECT chr($1);
'
    LANGUAGE sql;


--
-- TOC entry 36 (OID 74294)
-- Name: concat(text, text); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION concat(text, text) RETURNS text
    AS '
    SELECT $1 || $2;
'
    LANGUAGE sql;


--
-- TOC entry 37 (OID 74295)
-- Name: insert(text, integer, integer, text); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION "insert"(text, integer, integer, text) RETURNS text
    AS '
    SELECT substring($1 from 1 for $2 - 1) || $4 || substring($1 from $2 + $3);
'
    LANGUAGE sql;


--
-- TOC entry 38 (OID 74296)
-- Name: lcase(text); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION lcase(text) RETURNS text
    AS '
    SELECT lower($1);
'
    LANGUAGE sql;


--
-- TOC entry 39 (OID 74297)
-- Name: left(text, integer); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION "left"(text, integer) RETURNS text
    AS '
    SELECT substring($1 for $2);
'
    LANGUAGE sql;


--
-- TOC entry 40 (OID 74298)
-- Name: locate(text, text); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION locate(text, text) RETURNS integer
    AS '
    SELECT position($1 in $2);
'
    LANGUAGE sql;


--
-- TOC entry 41 (OID 74299)
-- Name: locate(text, text, integer); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION locate(text, text, integer) RETURNS integer
    AS '
    SELECT position($1 in substring($2 from $3)) + $3 - 1;
'
    LANGUAGE sql;


--
-- TOC entry 42 (OID 74300)
-- Name: right(text, integer); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION "right"(text, integer) RETURNS text
    AS '
    SELECT substring($1 from char_length($1) - $2 + 1);
'
    LANGUAGE sql;


--
-- TOC entry 43 (OID 74301)
-- Name: space(integer); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION space(integer) RETURNS text
    AS '
    SELECT repeat('' '', $1);
'
    LANGUAGE sql;


--
-- TOC entry 44 (OID 74302)
-- Name: ucase(text); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION ucase(text) RETURNS text
    AS '
    SELECT upper($1);
'
    LANGUAGE sql;


--
-- TOC entry 45 (OID 74303)
-- Name: ceiling(numeric); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION ceiling(numeric) RETURNS numeric
    AS '
    SELECT ceil($1);
'
    LANGUAGE sql;


--
-- TOC entry 46 (OID 74304)
-- Name: log10(double precision); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION log10(double precision) RETURNS double precision
    AS '
    SELECT log($1);
'
    LANGUAGE sql;


--
-- TOC entry 47 (OID 74305)
-- Name: log10(numeric); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION log10(numeric) RETURNS numeric
    AS '
    SELECT log($1);
'
    LANGUAGE sql;


--
-- TOC entry 48 (OID 74306)
-- Name: power(double precision, double precision); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION power(double precision, double precision) RETURNS double precision
    AS '
    SELECT pow($1, $2);
'
    LANGUAGE sql;


--
-- TOC entry 49 (OID 74307)
-- Name: power(numeric, numeric); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION power(numeric, numeric) RETURNS numeric
    AS '
    SELECT pow($1, $2);
'
    LANGUAGE sql;


--
-- TOC entry 50 (OID 74308)
-- Name: rand(); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION rand() RETURNS double precision
    AS '
    SELECT random();
'
    LANGUAGE sql;


--
-- TOC entry 51 (OID 74309)
-- Name: rand(double precision); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION rand(double precision) RETURNS double precision
    AS '
    SELECT setseed($1);
    SELECT random();
'
    LANGUAGE sql;


--
-- TOC entry 52 (OID 74310)
-- Name: truncate(numeric, integer); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION "truncate"(numeric, integer) RETURNS numeric
    AS '
    SELECT trunc($1, $2);
'
    LANGUAGE sql;


--
-- TOC entry 53 (OID 74311)
-- Name: curdate(); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION curdate() RETURNS date
    AS '
    SELECT current_date;
'
    LANGUAGE sql;


--
-- TOC entry 54 (OID 74312)
-- Name: curtime(); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION curtime() RETURNS time with time zone
    AS '
    SELECT current_time;
'
    LANGUAGE sql;


--
-- TOC entry 55 (OID 74313)
-- Name: odbc_timestamp(); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION odbc_timestamp() RETURNS timestamp with time zone
    AS '
    SELECT current_timestamp;
'
    LANGUAGE sql;


--
-- TOC entry 56 (OID 74314)
-- Name: dayname(timestamp without time zone); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION dayname(timestamp without time zone) RETURNS text
    AS '
    SELECT to_char($1,''Day'');
'
    LANGUAGE sql;


--
-- TOC entry 57 (OID 74315)
-- Name: dayofmonth(timestamp without time zone); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION dayofmonth(timestamp without time zone) RETURNS integer
    AS '
    SELECT CAST(EXTRACT(day FROM $1) AS integer);
'
    LANGUAGE sql;


--
-- TOC entry 58 (OID 74316)
-- Name: dayofweek(timestamp without time zone); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION dayofweek(timestamp without time zone) RETURNS integer
    AS '
    SELECT CAST(EXTRACT(dow FROM $1) AS integer) + 1;
'
    LANGUAGE sql;


--
-- TOC entry 59 (OID 74317)
-- Name: dayofyear(timestamp without time zone); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION dayofyear(timestamp without time zone) RETURNS integer
    AS '
    SELECT CAST(EXTRACT(doy FROM $1) AS integer);
'
    LANGUAGE sql;


--
-- TOC entry 60 (OID 74318)
-- Name: hour(timestamp without time zone); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION "hour"(timestamp without time zone) RETURNS integer
    AS '
    SELECT CAST(EXTRACT(hour FROM $1) AS integer);
'
    LANGUAGE sql;


--
-- TOC entry 61 (OID 74319)
-- Name: minute(timestamp without time zone); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION "minute"(timestamp without time zone) RETURNS integer
    AS '
    SELECT CAST(EXTRACT(minute FROM $1) AS integer);
'
    LANGUAGE sql;


--
-- TOC entry 62 (OID 74320)
-- Name: month(timestamp without time zone); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION "month"(timestamp without time zone) RETURNS integer
    AS '
    SELECT CAST(EXTRACT(month FROM $1) AS integer);
'
    LANGUAGE sql;


--
-- TOC entry 63 (OID 74321)
-- Name: monthname(timestamp without time zone); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION monthname(timestamp without time zone) RETURNS text
    AS '
    SELECT to_char($1, ''Month'');
'
    LANGUAGE sql;


--
-- TOC entry 64 (OID 74322)
-- Name: quarter(timestamp without time zone); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION quarter(timestamp without time zone) RETURNS integer
    AS '
    SELECT CAST(EXTRACT(quarter FROM $1) AS integer);
'
    LANGUAGE sql;


--
-- TOC entry 65 (OID 74323)
-- Name: second(timestamp without time zone); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION "second"(timestamp without time zone) RETURNS integer
    AS '
    SELECT CAST(EXTRACT(second FROM $1) AS integer);
'
    LANGUAGE sql;


--
-- TOC entry 66 (OID 74324)
-- Name: week(timestamp without time zone); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION week(timestamp without time zone) RETURNS integer
    AS '
    SELECT CAST(EXTRACT(week FROM $1) AS integer);
'
    LANGUAGE sql;


--
-- TOC entry 67 (OID 74325)
-- Name: year(timestamp without time zone); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION "year"(timestamp without time zone) RETURNS integer
    AS '
    SELECT CAST(EXTRACT(year FROM $1) AS integer);
'
    LANGUAGE sql;


--
-- TOC entry 68 (OID 74326)
-- Name: odbc_user(); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION odbc_user() RETURNS text
    AS '
    SELECT CAST(current_user AS TEXT);
'
    LANGUAGE sql;


--
-- TOC entry 69 (OID 74327)
-- Name: odbc_current_user(); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION odbc_current_user() RETURNS text
    AS '
    SELECT CAST(current_user AS TEXT);
'
    LANGUAGE sql;


--
-- TOC entry 70 (OID 74328)
-- Name: odbc_session_user(); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION odbc_session_user() RETURNS text
    AS '
    SELECT CAST(session_user AS TEXT);
'
    LANGUAGE sql;


SET SESSION AUTHORIZATION 'toni';

--
-- TOC entry 5 (OID 114993)
-- Name: waeup_usedscratchcards; Type: TABLE; Schema: public; Owner: toni
--

CREATE TABLE waeup_usedscratchcards (
    pin character(16) NOT NULL,
    sold timestamp without time zone,
    bank character varying(30),
    used_by character(16) NOT NULL,
    used_on timestamp without time zone NOT NULL,
    used_for character varying(20) NOT NULL
);


--
-- TOC entry 6 (OID 114993)
-- Name: waeup_usedscratchcards; Type: ACL; Schema: public; Owner: toni
--

REVOKE ALL ON TABLE waeup_usedscratchcards FROM PUBLIC;
GRANT ALL ON TABLE waeup_usedscratchcards TO imke;


SET SESSION AUTHORIZATION 'toni';

--
-- TOC entry 7 (OID 115157)
-- Name: waeup_scratchcard; Type: TABLE; Schema: public; Owner: toni
--

CREATE TABLE waeup_scratchcard (
    pin character varying(16) NOT NULL,
    value integer NOT NULL,
    used_by character varying(16),
    used_on timestamp with time zone,
    used_for character varying(20)
);


--
-- TOC entry 8 (OID 115157)
-- Name: waeup_scratchcard; Type: ACL; Schema: public; Owner: toni
--

REVOKE ALL ON TABLE waeup_scratchcard FROM PUBLIC;
GRANT ALL ON TABLE waeup_scratchcard TO imke;


SET SESSION AUTHORIZATION 'toni';

--
-- TOC entry 9 (OID 123388)
-- Name: waeup_jamb_student; Type: TABLE; Schema: public; Owner: toni
--

CREATE TABLE waeup_jamb_student (
    fname character varying(64) NOT NULL,
    lname character varying(64) NOT NULL,
    bdate date NOT NULL,
    gender character(1) NOT NULL,
    studentid character(16) NOT NULL,
    course_of_study character varying(100),
    faculty character varying(100) NOT NULL,
    state_of_origin character varying(100) NOT NULL,
    mark_english integer,
    subject2 character(32),
    subject2marks integer,
    subject1 character(32),
    subject1marks integer,
    subject3 character(32),
    subject3marks integer,
    CONSTRAINT waeup_jamb_student_gender CHECK (((gender = 'm'::bpchar) OR (gender = 'f'::bpchar)))
);


--
-- TOC entry 10 (OID 123388)
-- Name: waeup_jamb_student; Type: ACL; Schema: public; Owner: toni
--

REVOKE ALL ON TABLE waeup_jamb_student FROM PUBLIC;
GRANT ALL ON TABLE waeup_jamb_student TO imke;


SET SESSION AUTHORIZATION 'toni';

--
-- TOC entry 11 (OID 123393)
-- Name: waeup_student; Type: TABLE; Schema: public; Owner: toni
--

CREATE TABLE waeup_student (
    studentid character(16) NOT NULL,
    matno character varying(20) NOT NULL,
    "password" character varying(35),
    clearance_on date,
    housing timestamp without time zone,
    school_fee timestamp without time zone
);


--
-- TOC entry 12 (OID 123393)
-- Name: waeup_student; Type: ACL; Schema: public; Owner: toni
--

REVOKE ALL ON TABLE waeup_student FROM PUBLIC;
GRANT ALL ON TABLE waeup_student TO imke;


SET SESSION AUTHORIZATION 'toni';

--
-- TOC entry 13 (OID 123406)
-- Name: waeup_acc_house; Type: TABLE; Schema: public; Owner: toni
--

CREATE TABLE waeup_acc_house (
    house character varying(30) NOT NULL,
    gender character(1) NOT NULL,
    beds integer NOT NULL,
    CONSTRAINT waeup_acc_house_beds CHECK ((beds > 0))
);


--
-- TOC entry 14 (OID 123406)
-- Name: waeup_acc_house; Type: ACL; Schema: public; Owner: toni
--

REVOKE ALL ON TABLE waeup_acc_house FROM PUBLIC;
GRANT ALL ON TABLE waeup_acc_house TO imke;


SET SESSION AUTHORIZATION 'toni';

--
-- TOC entry 15 (OID 123411)
-- Name: waeup_acc_floor; Type: TABLE; Schema: public; Owner: toni
--

CREATE TABLE waeup_acc_floor (
    floorno integer NOT NULL,
    house character varying(30) NOT NULL,
    gender character(1) NOT NULL,
    rooms integer NOT NULL
);


--
-- TOC entry 16 (OID 123411)
-- Name: waeup_acc_floor; Type: ACL; Schema: public; Owner: toni
--

REVOKE ALL ON TABLE waeup_acc_floor FROM PUBLIC;
GRANT ALL ON TABLE waeup_acc_floor TO imke;


SET SESSION AUTHORIZATION 'toni';

--
-- TOC entry 17 (OID 123435)
-- Name: waeup_acc_bedlist; Type: TABLE; Schema: public; Owner: toni
--

CREATE TABLE waeup_acc_bedlist (
    house character varying(30) NOT NULL,
    floor integer NOT NULL,
    room integer NOT NULL,
    bed integer NOT NULL,
    gender character(1) NOT NULL,
    used_by character varying(16),
    CONSTRAINT waeup_acc_bedlist_bed CHECK ((bed > 0)),
    CONSTRAINT waeup_acc_bedlist_gender CHECK (((gender = 'm'::bpchar) OR (gender = 'f'::bpchar))),
    CONSTRAINT waeup_acc_bedlist_room CHECK ((room > 0))
);


--
-- TOC entry 18 (OID 123435)
-- Name: waeup_acc_bedlist; Type: ACL; Schema: public; Owner: toni
--

REVOKE ALL ON TABLE waeup_acc_bedlist FROM PUBLIC;
GRANT ALL ON TABLE waeup_acc_bedlist TO imke;


SET SESSION AUTHORIZATION 'toni';

--
-- TOC entry 19 (OID 123450)
-- Name: waeup_acc_bed; Type: VIEW; Schema: public; Owner: toni
--

CREATE VIEW waeup_acc_bed AS
    SELECT h.house, bl.floor, bl.room, bl.bed, h.gender FROM waeup_acc_house h, waeup_acc_bedlist bl WHERE ((h.house)::text = (bl.house)::text);


--
-- TOC entry 20 (OID 123450)
-- Name: waeup_acc_bed; Type: ACL; Schema: public; Owner: toni
--

REVOKE ALL ON TABLE waeup_acc_bed FROM PUBLIC;
GRANT ALL ON TABLE waeup_acc_bed TO imke;


SET SESSION AUTHORIZATION 'toni';

--
-- TOC entry 21 (OID 123451)
-- Name: waeup_faculties; Type: TABLE; Schema: public; Owner: toni
--

CREATE TABLE waeup_faculties (
    faculty character varying(30) NOT NULL,
    school_fee integer NOT NULL,
    CONSTRAINT school_fee CHECK ((school_fee >= 0))
);


--
-- TOC entry 22 (OID 123451)
-- Name: waeup_faculties; Type: ACL; Schema: public; Owner: toni
--

REVOKE ALL ON TABLE waeup_faculties FROM PUBLIC;
GRANT ALL ON TABLE waeup_faculties TO imke;


SET SESSION AUTHORIZATION 'toni';

--
-- TOC entry 23 (OID 123828)
-- Name: waeup_course; Type: TABLE; Schema: public; Owner: toni
--

CREATE TABLE waeup_course (
    faculty character varying(30),
    title character varying(60) NOT NULL,
    courseno character varying(10) NOT NULL,
    workload integer NOT NULL,
    CONSTRAINT waeup_course_workload CHECK ((workload >= 0))
);


--
-- TOC entry 24 (OID 123837)
-- Name: waeup_courseentry; Type: TABLE; Schema: public; Owner: toni
--

CREATE TABLE waeup_courseentry (
    courseno character varying(10),
    e integer NOT NULL,
    s1 character(4) NOT NULL,
    m1 integer NOT NULL,
    s2 character(4) NOT NULL,
    m2 integer NOT NULL,
    s3 character(4) NOT NULL,
    m3 integer NOT NULL,
    CONSTRAINT waeup_courseentry_e CHECK ((e >= 0)),
    CONSTRAINT waeup_courseentry_m1 CHECK ((m1 >= 0)),
    CONSTRAINT waeup_courseentry_m2 CHECK ((m2 >= 0)),
    CONSTRAINT waeup_courseentry_m3 CHECK ((m3 >= 0))
);


--
-- TOC entry 25 (OID 114995)
-- Name: waeup_usedscratchcards_pkey; Type: CONSTRAINT; Schema: public; Owner: toni
--

ALTER TABLE ONLY waeup_usedscratchcards
    ADD CONSTRAINT waeup_usedscratchcards_pkey PRIMARY KEY (pin);


--
-- TOC entry 26 (OID 115159)
-- Name: waeup_scratchcard_pkey; Type: CONSTRAINT; Schema: public; Owner: toni
--

ALTER TABLE ONLY waeup_scratchcard
    ADD CONSTRAINT waeup_scratchcard_pkey PRIMARY KEY (pin);


--
-- TOC entry 27 (OID 123391)
-- Name: waeup_jamb_student_studentid_key; Type: CONSTRAINT; Schema: public; Owner: toni
--

ALTER TABLE ONLY waeup_jamb_student
    ADD CONSTRAINT waeup_jamb_student_studentid_key UNIQUE (studentid);


--
-- TOC entry 29 (OID 123398)
-- Name: waeup_student_studentid_key; Type: CONSTRAINT; Schema: public; Owner: toni
--

ALTER TABLE ONLY waeup_student
    ADD CONSTRAINT waeup_student_studentid_key UNIQUE (studentid);


--
-- TOC entry 28 (OID 123400)
-- Name: waeup_student_matno_key; Type: CONSTRAINT; Schema: public; Owner: toni
--

ALTER TABLE ONLY waeup_student
    ADD CONSTRAINT waeup_student_matno_key UNIQUE (matno);


--
-- TOC entry 30 (OID 123409)
-- Name: waeup_acc_house_house_key; Type: CONSTRAINT; Schema: public; Owner: toni
--

ALTER TABLE ONLY waeup_acc_house
    ADD CONSTRAINT waeup_acc_house_house_key UNIQUE (house);


--
-- TOC entry 31 (OID 123453)
-- Name: waeup_faculties_faculty_key; Type: CONSTRAINT; Schema: public; Owner: toni
--

ALTER TABLE ONLY waeup_faculties
    ADD CONSTRAINT waeup_faculties_faculty_key UNIQUE (faculty);


--
-- TOC entry 32 (OID 123831)
-- Name: waeup_course_courseno_key; Type: CONSTRAINT; Schema: public; Owner: toni
--

ALTER TABLE ONLY waeup_course
    ADD CONSTRAINT waeup_course_courseno_key UNIQUE (courseno);


--
-- TOC entry 71 (OID 123402)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: toni
--

ALTER TABLE ONLY waeup_student
    ADD CONSTRAINT "$1" FOREIGN KEY (studentid) REFERENCES waeup_jamb_student(studentid);


--
-- TOC entry 72 (OID 123413)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: toni
--

ALTER TABLE ONLY waeup_acc_floor
    ADD CONSTRAINT "$1" FOREIGN KEY (house) REFERENCES waeup_acc_house(house);


--
-- TOC entry 73 (OID 123444)
-- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: toni
--

ALTER TABLE ONLY waeup_acc_bedlist
    ADD CONSTRAINT "$2" FOREIGN KEY (used_by) REFERENCES waeup_student(matno);


--
-- TOC entry 74 (OID 123833)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: toni
--

ALTER TABLE ONLY waeup_course
    ADD CONSTRAINT "$1" FOREIGN KEY (faculty) REFERENCES waeup_faculties(faculty);


--
-- TOC entry 75 (OID 123843)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: toni
--

ALTER TABLE ONLY waeup_courseentry
    ADD CONSTRAINT "$1" FOREIGN KEY (courseno) REFERENCES waeup_course(courseno);


SET SESSION AUTHORIZATION 'postgres';

--
-- TOC entry 3 (OID 2200)
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA public IS 'Standard public namespace';