diff --git a/calendar/calendar_schema.psql b/calendar/calendar_schema.psql index a29b49c..9a9007f 100755 --- a/calendar/calendar_schema.psql +++ b/calendar/calendar_schema.psql @@ -43,6 +43,7 @@ ( Paper_ID char(18), Section_ID varchar(10), Title text not null, + Continuation text not null, -- needed if a section spans mid-semester break URL text, primary key ( Paper_ID, Section_ID ), @@ -55,7 +56,7 @@ Lecture_Date date check ( Lecture_Date >= Week_Starting ), Title text not null, URL text, - Section_ID varchar(10), + Section_ID varchar(10) not null, Is_Holiday boolean default false not null, primary key ( Paper_ID, Week_Starting, Lecture_Date ), @@ -99,26 +100,26 @@ -- Some test data. -insert into paper_offering (paper_Code, year_offered, period_code, campus_code) values ('INFO212', 2009, 'S1', 'DNS'); -insert into paper_offering (paper_Code, year_offered, period_code, campus_code) values ('INFO321', 2009, 'S2', 'DNS'); - -insert into week values ('INFO212_S1DNS_2009', date '2009-03-02', date '2009-03-06', false); -insert into week values ('INFO212_S1DNS_2009', date '2009-03-09', date '2009-03-13', false); -insert into week values ('INFO212_S1DNS_2009', date '2009-03-30', date '2009-04-03', false); -insert into week values ('INFO212_S1DNS_2009', date '2009-04-13', date '2009-04-17', true); - -insert into section values ('INFO212_S1DNS_2009', 'intro', 'Introduction', 'http://info-nts-12.otago.ac.nz/info212/Lectures/Chapter0combined.pdf'); -insert into section values ('INFO212_S1DNS_2009', 'RDBMS', 'Relational DBMS', 'http://info-nts-12.otago.ac.nz/info212/Lectures/Chapter1combined.pdf'); - -insert into lecture values ('INFO212_S1DNS_2009', date '2009-03-02', date '2009-03-02', 'Introduction', null, 'intro', false); -insert into lecture values ('INFO212_S1DNS_2009', date '2009-03-02', date '2009-03-05', 'What is a DBMS?', null, 'RDBMS', false); -insert into lecture values ('INFO212_S1DNS_2009', date '2009-03-09', date '2009-03-09', 'Functions of a DBMS', null, 'RDBMS', false); -insert into lecture values ('INFO212_S1DNS_2009', date '2009-03-09', date '2009-03-12', 'The relational model', null, 'RDBMS', false); - -insert into other_class values ('INFO212_S1DNS_2009', date '2009-03-09', 'laboratory', 'Introduction (Oracle, TOAD)', 'http://info-nts-12.otago.ac.nz/info212/Labs/lab01/lab01-questions.html'); -insert into other_class values ('INFO212_S1DNS_2009', date '2009-03-09', 'tutorial', 'Database management systems', 'http://info-nts-12.otago.ac.nz/info212/Tutorials/tut01/tut01-questions.html'); - -insert into reading values ('INFO212_S1DNS_2009', date '2009-03-02', 'Text Chs. 1 & 2'); -insert into reading values ('INFO212_S1DNS_2009', date '2009-03-09', 'Text �3.1�3.2'); - -insert into assessment values ('INFO212_S1DNS_2009', date '2009-03-30', timestamp '2009-04-01 17:00:00', 'Assignment 1', 'http://info-nts-12.otago.ac.nz/info212/assessment/Assignment1.html'); +--insert into paper_offering (paper_Code, year_offered, period_code, campus_code) values ('INFO212', 2009, 'S1', 'DNS'); +--insert into paper_offering (paper_Code, year_offered, period_code, campus_code) values ('INFO321', 2009, 'S2', 'DNS'); +-- +--insert into week values ('INFO212_S1DNS_2009', date '2009-03-02', date '2009-03-06', false); +--insert into week values ('INFO212_S1DNS_2009', date '2009-03-09', date '2009-03-13', false); +--insert into week values ('INFO212_S1DNS_2009', date '2009-03-30', date '2009-04-03', false); +--insert into week values ('INFO212_S1DNS_2009', date '2009-04-13', date '2009-04-17', true); +-- +--insert into section values ('INFO212_S1DNS_2009', 'intro', 'Introduction', 'http://info-nts-12.otago.ac.nz/info212/Lectures/Chapter0combined.pdf'); +--insert into section values ('INFO212_S1DNS_2009', 'RDBMS', 'Relational DBMS', 'http://info-nts-12.otago.ac.nz/info212/Lectures/Chapter1combined.pdf'); +-- +--insert into lecture values ('INFO212_S1DNS_2009', date '2009-03-02', date '2009-03-02', 'Introduction', null, 'intro', false); +--insert into lecture values ('INFO212_S1DNS_2009', date '2009-03-02', date '2009-03-05', 'What is a DBMS?', null, 'RDBMS', false); +--insert into lecture values ('INFO212_S1DNS_2009', date '2009-03-09', date '2009-03-09', 'Functions of a DBMS', null, 'RDBMS', false); +--insert into lecture values ('INFO212_S1DNS_2009', date '2009-03-09', date '2009-03-12', 'The relational model', null, 'RDBMS', false); +-- +--insert into other_class values ('INFO212_S1DNS_2009', date '2009-03-09', 'laboratory', 'Introduction (Oracle, TOAD)', 'http://info-nts-12.otago.ac.nz/info212/Labs/lab01/lab01-questions.html'); +--insert into other_class values ('INFO212_S1DNS_2009', date '2009-03-09', 'tutorial', 'Database management systems', 'http://info-nts-12.otago.ac.nz/info212/Tutorials/tut01/tut01-questions.html'); +-- +--insert into reading values ('INFO212_S1DNS_2009', date '2009-03-02', 'Text Chs. 1 & 2'); +--insert into reading values ('INFO212_S1DNS_2009', date '2009-03-09', 'Text �3.1�3.2'); +-- +--insert into assessment values ('INFO212_S1DNS_2009', date '2009-03-30', timestamp '2009-04-01 17:00:00', 'Assignment 1', 'http://info-nts-12.otago.ac.nz/info212/assessment/Assignment1.html');