/[libdata]/trunk/pg/libdata.pgsql
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /trunk/pg/libdata.pgsql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 42 by dpavlin, Thu Mar 4 21:28:31 2004 UTC revision 43 by dpavlin, Fri Mar 5 00:21:54 2004 UTC
# Line 85  CREATE TABLE coursesub ( Line 85  CREATE TABLE coursesub (
85    coursesub varchar(15) DEFAULT NULL,    coursesub varchar(15) DEFAULT NULL,
86    coursesub_descr varchar(100) DEFAULT NULL,    coursesub_descr varchar(100) DEFAULT NULL,
87    cip_code varchar(50) DEFAULT NULL,    cip_code varchar(50) DEFAULT NULL,
88    campus_id INT4 references campus(campus_id),    campus_id INT4 references campus(campus_id) on delete cascade on update cascade,
89    PRIMARY KEY (coursesub_id)    PRIMARY KEY (coursesub_id)
90    
91  );  );
# Line 203  CREATE TABLE page ( Line 203  CREATE TABLE page (
203    account_created varchar(20) DEFAULT NULL,    account_created varchar(20) DEFAULT NULL,
204    account_modified varchar(20) DEFAULT NULL,    account_modified varchar(20) DEFAULT NULL,
205    staff_coordinator INT4 DEFAULT NULL,    staff_coordinator INT4 DEFAULT NULL,
206    style_id INT4 references style(style_id),    style_id INT4 references style(style_id) on delete cascade on update cascade,
207    pagetype_id INT4 references pagetype(pagetype_id),    pagetype_id INT4 references pagetype(pagetype_id) on delete cascade on update cascade,
208    page_title varchar(255) DEFAULT NULL,    page_title varchar(255) DEFAULT NULL,
209    pagetitle_style INT2 references style(style_id),    pagetitle_style INT2 references style(style_id) on delete cascade on update cascade,
210    published char(1) DEFAULT NULL,    published char(1) DEFAULT NULL,
211    display_urls char(1) DEFAULT NULL,    display_urls char(1) DEFAULT NULL,
212    display_toc char(1) DEFAULT NULL,    display_toc char(1) DEFAULT NULL,
# Line 245  CREATE SEQUENCE course_course_id_seq; Line 245  CREATE SEQUENCE course_course_id_seq;
245    
246  CREATE TABLE course (  CREATE TABLE course (
247    course_id INT4 DEFAULT nextval('course_course_id_seq'),    course_id INT4 DEFAULT nextval('course_course_id_seq'),
248    page_id INT4 references page(page_id),    page_id INT4 references page(page_id) on delete cascade on update cascade,
249    coursesub_id INT4 references coursesub(coursesub_id),    coursesub_id INT4 references coursesub(coursesub_id) on delete cascade on update cascade,
250    course_num varchar(50) DEFAULT NULL,    course_num varchar(50) DEFAULT NULL,
251    course_section varchar(10) DEFAULT NULL,    course_section varchar(10) DEFAULT NULL,
252    course_concat varchar(255) DEFAULT NULL,    course_concat varchar(255) DEFAULT NULL,
253    term_id INT4 references term(term_id),    term_id INT4 references term(term_id) on delete cascade on update cascade,
254    course_year varchar(4) DEFAULT NULL,    course_year varchar(4) DEFAULT NULL,
255    campus_id INT4 references campus(campus_id),    campus_id INT4 references campus(campus_id) on delete cascade on update cascade,
256    courseheader varchar(255) DEFAULT NULL,    courseheader varchar(255) DEFAULT NULL,
257    introheader1 text,    introheader1 text,
258    intromessage1 text,    intromessage1 text,
# Line 325  CREATE TABLE staff ( Line 325  CREATE TABLE staff (
325    last_ip varchar(15) DEFAULT NULL,    last_ip varchar(15) DEFAULT NULL,
326    date_created TIMESTAMP DEFAULT NULL,    date_created TIMESTAMP DEFAULT NULL,
327    date_modified TIMESTAMP DEFAULT NULL,    date_modified TIMESTAMP DEFAULT NULL,
328    access_id INT4 references access(access_id),    access_id INT4 references access(access_id) on delete cascade on update cascade,
329    stafftitle_id INT4 references stafftitle(stafftitle_id),    stafftitle_id INT4 references stafftitle(stafftitle_id) on delete cascade on update cascade,
330    PRIMARY KEY (staff_id)    PRIMARY KEY (staff_id)
331    
332  );  );
# Line 384  CREATE SEQUENCE course_personnel_personn Line 384  CREATE SEQUENCE course_personnel_personn
384    
385  CREATE TABLE course_personnel (  CREATE TABLE course_personnel (
386    personnel_id INT4 DEFAULT nextval('course_personnel_personnel_i'),    personnel_id INT4 DEFAULT nextval('course_personnel_personnel_i'),
387    course_id INT4 references course(course_id),    course_id INT4 references course(course_id) on delete cascade on update cascade,
388    stafftitle_id INT4 references stafftitle(stafftitle_id),    stafftitle_id INT4 references stafftitle(stafftitle_id) on delete cascade on update cascade,
389    staff_id INT4 references staff(staff_id),    staff_id INT4 references staff(staff_id) on delete cascade on update cascade,
390    faculty_id INT4 references faculty(faculty_id),    faculty_id INT4 references faculty(faculty_id) on delete cascade on update cascade,
391    pers_email varchar(40) DEFAULT NULL,    pers_email varchar(40) DEFAULT NULL,
392    pers_account varchar(20) DEFAULT NULL,    pers_account varchar(20) DEFAULT NULL,
393    pers_lastname varchar(50) DEFAULT NULL,    pers_lastname varchar(50) DEFAULT NULL,
# Line 517  CREATE TABLE subject ( Line 517  CREATE TABLE subject (
517    subject_id INT4 DEFAULT nextval('subject_subject_id_seq'),    subject_id INT4 DEFAULT nextval('subject_subject_id_seq'),
518    subject varchar(75) NOT NULL DEFAULT '',    subject varchar(75) NOT NULL DEFAULT '',
519    subject_descr text,    subject_descr text,
520    sublocation_id INT4 references location(location_id),    sublocation_id INT4 references location(location_id) on delete cascade on update cascade,
521    rqs_date_created TIMESTAMP DEFAULT NULL,    rqs_date_created TIMESTAMP DEFAULT NULL,
522    rqs_date_modified TIMESTAMP DEFAULT NULL,    rqs_date_modified TIMESTAMP DEFAULT NULL,
523    rqs_account_created varchar(20) DEFAULT NULL,    rqs_account_created varchar(20) DEFAULT NULL,
# Line 590  CREATE SEQUENCE infotype_infotype_id_seq Line 590  CREATE SEQUENCE infotype_infotype_id_seq
590    
591  CREATE TABLE infotype (  CREATE TABLE infotype (
592    infotype_id INT4 DEFAULT nextval('infotype_infotype_id_seq'),    infotype_id INT4 DEFAULT nextval('infotype_infotype_id_seq'),
593    masterinfotype_id INT4 references infotype(infotype_id),    masterinfotype_id INT4 references infotype(infotype_id) on delete cascade on update cascade,
594    mastersubject_id INT4 references mastersubject(mastersubject_id),    mastersubject_id INT4 references mastersubject(mastersubject_id) on delete cascade on update cascade,
595    infotype varchar(75) NOT NULL DEFAULT '',    infotype varchar(75) NOT NULL DEFAULT '',
596    PRIMARY KEY (infotype_id)    PRIMARY KEY (infotype_id)
597    
# Line 742  CREATE TABLE resource ( Line 742  CREATE TABLE resource (
742    url text,    url text,
743    visited varchar(25) DEFAULT NULL,    visited varchar(25) DEFAULT NULL,
744    annotation text,    annotation text,
745    location_id INT4 references location(location_id),    location_id INT4 references location(location_id) on delete cascade on update cascade,
746    infotype_id INT4 references infotype(infotype_id),    infotype_id INT4 references infotype(infotype_id) on delete cascade on update cascade,
747    vendor_id INT4 DEFAULT NULL,                                          -- XXX unused    vendor_id INT4 DEFAULT NULL,                                          -- XXX unused
748    PRIMARY KEY (resource_id)    PRIMARY KEY (resource_id)
749    
# Line 782  CREATE SEQUENCE element_element_id_seq; Line 782  CREATE SEQUENCE element_element_id_seq;
782    
783  CREATE TABLE element (  CREATE TABLE element (
784    element_id INT4 DEFAULT nextval('element_element_id_seq'),    element_id INT4 DEFAULT nextval('element_element_id_seq'),
785    page_id INT4 references page(page_id),    page_id INT4 references page(page_id) on delete cascade on update cascade,
786    parent_id INT4,                       --- XXX references element(element_id),    parent_id INT4,                       --- XXX references element(element_id) on delete cascade on update cascade,
787    resource_id INT4 references resource(resource_id),    resource_id INT4 references resource(resource_id) on delete cascade on update cascade,
788    location_id INT4 references location(location_id),    location_id INT4 references location(location_id) on delete cascade on update cascade,
789    service_id INT4 references service(service_id),    service_id INT4 references service(service_id) on delete cascade on update cascade,
790    staff_id INT4 references staff(staff_id),    staff_id INT4 references staff(staff_id) on delete cascade on update cascade,
791    subject_id INT4 references subject(subject_id),    subject_id INT4 references subject(subject_id) on delete cascade on update cascade,
792    label varchar(200) DEFAULT NULL,    label varchar(200) DEFAULT NULL,
793    label_url varchar(200) DEFAULT NULL,    label_url varchar(200) DEFAULT NULL,
794    element_descr text,    element_descr text,
# Line 890  CREATE TABLE libunit ( Line 890  CREATE TABLE libunit (
890    libunit_id INT4 DEFAULT nextval('libunit_libunit_id_seq'),    libunit_id INT4 DEFAULT nextval('libunit_libunit_id_seq'),
891    libunit varchar(100) DEFAULT NULL,    libunit varchar(100) DEFAULT NULL,
892    libunit_abbrev varchar(25) DEFAULT NULL,    libunit_abbrev varchar(25) DEFAULT NULL,
893    head_staff_id INT4 references staff(staff_id),    head_staff_id INT4 references staff(staff_id) on delete cascade on update cascade,
894    PRIMARY KEY (libunit_id)    PRIMARY KEY (libunit_id)
895    
896  );  );
# Line 906  INSERT INTO libunit VALUES (1,'(N/A)','( Line 906  INSERT INTO libunit VALUES (1,'(N/A)','(
906  --  --
907    
908  CREATE TABLE libunit_staff (  CREATE TABLE libunit_staff (
909    libunit_id INT4 references libunit(libunit_id),    libunit_id INT4 references libunit(libunit_id) on delete cascade on update cascade,
910    staff_id INT4 references staff(staff_id),    staff_id INT4 references staff(staff_id) on delete cascade on update cascade,
911    PRIMARY KEY (libunit_id,staff_id)    PRIMARY KEY (libunit_id,staff_id)
912    
913  );  );
# Line 958  INSERT INTO masterinfotype VALUES (13,'W Line 958  INSERT INTO masterinfotype VALUES (13,'W
958  --  --
959    
960  CREATE TABLE page_staff (  CREATE TABLE page_staff (
961    page_id INT4 references page(page_id),    page_id INT4 references page(page_id) on delete cascade on update cascade,
962    staff_id INT4 references staff(staff_id),    staff_id INT4 references staff(staff_id) on delete cascade on update cascade,
963    PRIMARY KEY (page_id,staff_id)    PRIMARY KEY (page_id,staff_id)
964    
965  );  );
# Line 984  CREATE SEQUENCE pastebuffer_pastebuffer_ Line 984  CREATE SEQUENCE pastebuffer_pastebuffer_
984    
985  CREATE TABLE pastebuffer (  CREATE TABLE pastebuffer (
986    pastebuffer_id INT4 DEFAULT nextval('pastebuffer_pastebuffer_id_s'),    pastebuffer_id INT4 DEFAULT nextval('pastebuffer_pastebuffer_id_s'),
987    paste_staff_id INT4 references staff(staff_id),    paste_staff_id INT4 references staff(staff_id) on delete cascade on update cascade,
988    parent_id INT4 DEFAULT NULL,                                          -- XXX references what?    parent_id INT4 DEFAULT NULL,                                          -- XXX references what? on delete cascade on update cascade
989    resource_id INT4 references resource(resource_id),    resource_id INT4 references resource(resource_id) on delete cascade on update cascade,
990    location_id INT4 references location(location_id),    location_id INT4 references location(location_id) on delete cascade on update cascade,
991    service_id INT4 references service(service_id),    service_id INT4 references service(service_id) on delete cascade on update cascade,
992    staff_id INT4 references staff(staff_id),    staff_id INT4 references staff(staff_id) on delete cascade on update cascade,
993    subject_id INT4 references subject(subject_id),    subject_id INT4 references subject(subject_id) on delete cascade on update cascade,
994    label varchar(200) DEFAULT NULL,    label varchar(200) DEFAULT NULL,
995    label_url varchar(200) DEFAULT NULL,    label_url varchar(200) DEFAULT NULL,
996    element_descr text,    element_descr text,
# Line 1011  CREATE TABLE pastebuffer ( Line 1011  CREATE TABLE pastebuffer (
1011  --  --
1012    
1013  CREATE TABLE res_feature (  CREATE TABLE res_feature (
1014    resource_id INT4 references resource(resource_id),    resource_id INT4 references resource(resource_id) on delete cascade on update cascade,
1015    feature_id INT4 references feature(feature_id),    feature_id INT4 references feature(feature_id) on delete cascade on update cascade,
1016    PRIMARY KEY (resource_id,feature_id)    PRIMARY KEY (resource_id,feature_id)
1017    
1018  );  );
# Line 1035  INSERT INTO res_feature VALUES (20,5); Line 1035  INSERT INTO res_feature VALUES (20,5);
1035  --  --
1036    
1037  CREATE TABLE res_loc (  CREATE TABLE res_loc (
1038    resource_id INT4 references resource(resource_id),    resource_id INT4 references resource(resource_id) on delete cascade on update cascade,
1039    location_id INT4 references location(location_id),    location_id INT4 references location(location_id) on delete cascade on update cascade,
1040    PRIMARY KEY (resource_id,location_id)    PRIMARY KEY (resource_id,location_id)
1041    
1042  );  );
# Line 1060  INSERT INTO res_loc VALUES (19,55); Line 1060  INSERT INTO res_loc VALUES (19,55);
1060  --  --
1061    
1062  CREATE TABLE res_mastersubject (  CREATE TABLE res_mastersubject (
1063    resource_id INT4 references resource(resource_id),    resource_id INT4 references resource(resource_id) on delete cascade on update cascade,
1064    mastersubject_id INT4 references mastersubject(mastersubject_id),    mastersubject_id INT4 references mastersubject(mastersubject_id) on delete cascade on update cascade,
1065    PRIMARY KEY (resource_id,mastersubject_id)    PRIMARY KEY (resource_id,mastersubject_id)
1066    
1067  );  );
# Line 1090  INSERT INTO res_mastersubject VALUES (20 Line 1090  INSERT INTO res_mastersubject VALUES (20
1090  --  --
1091    
1092  CREATE TABLE res_sub_infotype (  CREATE TABLE res_sub_infotype (
1093    resource_id INT4 references resource(resource_id),    resource_id INT4 references resource(resource_id) on delete cascade on update cascade,
1094    subject_id INT4 references subject(subject_id),    subject_id INT4 references subject(subject_id) on delete cascade on update cascade,
1095    infotype_id INT4 references infotype(infotype_id),    infotype_id INT4 references infotype(infotype_id) on delete cascade on update cascade,
1096    highlighted char(1) DEFAULT NULL,    highlighted char(1) DEFAULT NULL,
1097    description text,    description text,
1098    masterinfotype_id INT4 references masterinfotype(masterinfotype_id)    masterinfotype_id INT4 references masterinfotype(masterinfotype_id) on delete cascade on update cascade
1099  );  );
1100    
1101  --  --
# Line 1122  INSERT INTO res_sub_infotype VALUES (20, Line 1122  INSERT INTO res_sub_infotype VALUES (20,
1122    
1123  CREATE TABLE serv_loc (  CREATE TABLE serv_loc (
1124    service_id INT4 NOT NULL DEFAULT '0',    service_id INT4 NOT NULL DEFAULT '0',
1125    location_id INT4 references location(location_id),    location_id INT4 references location(location_id) on delete cascade on update cascade,
1126    allloc char(1) DEFAULT NULL,    allloc char(1) DEFAULT NULL,
1127    PRIMARY KEY (service_id,location_id)    PRIMARY KEY (service_id,location_id)
1128    
# Line 1138  CREATE TABLE serv_loc ( Line 1138  CREATE TABLE serv_loc (
1138  --  --
1139    
1140  CREATE TABLE serv_servtype (  CREATE TABLE serv_servtype (
1141    service_id INT4 references service(service_id),    service_id INT4 references service(service_id) on delete cascade on update cascade,
1142    servicetype_id INT4 references servicetype(servicetype_id),    servicetype_id INT4 references servicetype(servicetype_id) on delete cascade on update cascade,
1143    PRIMARY KEY (service_id,servicetype_id)    PRIMARY KEY (service_id,servicetype_id)
1144    
1145  );  );
# Line 1154  CREATE TABLE serv_servtype ( Line 1154  CREATE TABLE serv_servtype (
1154  --  --
1155    
1156  CREATE TABLE sub_coursesub (  CREATE TABLE sub_coursesub (
1157    subject_id INT4 references subject(subject_id),    subject_id INT4 references subject(subject_id) on delete cascade on update cascade,
1158    coursesub_id INT4 references coursesub(coursesub_id),    coursesub_id INT4 references coursesub(coursesub_id) on delete cascade on update cascade,
1159    PRIMARY KEY (subject_id,coursesub_id)    PRIMARY KEY (subject_id,coursesub_id)
1160    
1161  );  );
# Line 1171  INSERT INTO sub_coursesub VALUES (6,555) Line 1171  INSERT INTO sub_coursesub VALUES (6,555)
1171  --  --
1172    
1173  CREATE TABLE sub_loc (  CREATE TABLE sub_loc (
1174    subject_id INT4 references subject(subject_id),    subject_id INT4 references subject(subject_id) on delete cascade on update cascade,
1175    location_id INT4 references location(location_id),    location_id INT4 references location(location_id) on delete cascade on update cascade,
1176    PRIMARY KEY (subject_id,location_id)    PRIMARY KEY (subject_id,location_id)
1177    
1178  );  );
# Line 1188  INSERT INTO sub_loc VALUES (2,55); Line 1188  INSERT INTO sub_loc VALUES (2,55);
1188  --  --
1189    
1190  CREATE TABLE sub_mastersubject (  CREATE TABLE sub_mastersubject (
1191    subject_id INT4 references subject(subject_id),    subject_id INT4 references subject(subject_id) on delete cascade on update cascade,
1192    mastersubject_id INT4 references mastersubject(mastersubject_id),    mastersubject_id INT4 references mastersubject(mastersubject_id) on delete cascade on update cascade,
1193    PRIMARY KEY (subject_id,mastersubject_id)    PRIMARY KEY (subject_id,mastersubject_id)
1194    
1195  );  );
# Line 1206  INSERT INTO sub_mastersubject VALUES (6, Line 1206  INSERT INTO sub_mastersubject VALUES (6,
1206  --  --
1207    
1208  CREATE TABLE sub_othersub (  CREATE TABLE sub_othersub (
1209    subject_id INT4 references subject(subject_id),    subject_id INT4 references subject(subject_id) on delete cascade on update cascade,
1210    othersub_id INT4 NOT NULL DEFAULT '0',                -- XXX subject or mastersubject?    othersub_id INT4 NOT NULL DEFAULT '0',                -- XXX subject or mastersubject?
1211    PRIMARY KEY (subject_id,othersub_id)    PRIMARY KEY (subject_id,othersub_id)
1212    
# Line 1222  CREATE TABLE sub_othersub ( Line 1222  CREATE TABLE sub_othersub (
1222  --  --
1223    
1224  CREATE TABLE sub_page (  CREATE TABLE sub_page (
1225    subject_id INT4 references subject(subject_id),    subject_id INT4 references subject(subject_id) on delete cascade on update cascade,
1226    page_id INT4 references page(page_id),    page_id INT4 references page(page_id) on delete cascade on update cascade,
1227    PRIMARY KEY (subject_id,page_id)    PRIMARY KEY (subject_id,page_id)
1228    
1229  );  );
# Line 1238  CREATE TABLE sub_page ( Line 1238  CREATE TABLE sub_page (
1238  --  --
1239    
1240  CREATE TABLE sub_staff (  CREATE TABLE sub_staff (
1241    subject_id INT4 references subject(subject_id),    subject_id INT4 references subject(subject_id) on delete cascade on update cascade,
1242    staff_id INT4 references staff(staff_id),    staff_id INT4 references staff(staff_id) on delete cascade on update cascade,
1243    PRIMARY KEY (subject_id,staff_id)    PRIMARY KEY (subject_id,staff_id)
1244    
1245  );  );
Legend:
Removed from v.42  
changed lines
  Added in v.43
  ViewVC Help
Powered by ViewVC 1.1.26