577 |
INSERT INTO mastersubject VALUES (12,'Tehnika'); |
INSERT INTO mastersubject VALUES (12,'Tehnika'); |
578 |
|
|
579 |
-- |
-- |
580 |
|
-- Table structure for table `masterinfotype` |
581 |
|
-- |
582 |
|
|
583 |
|
|
584 |
|
|
585 |
|
-- |
586 |
|
-- Sequences for table MASTERINFOTYPE |
587 |
|
-- |
588 |
|
|
589 |
|
CREATE SEQUENCE masterinfotype_masterinfotyp; |
590 |
|
|
591 |
|
CREATE TABLE masterinfotype ( |
592 |
|
masterinfotype_id INT4 DEFAULT nextval('masterinfotype_masterinfotyp'), |
593 |
|
masterinfotype varchar(75) NOT NULL DEFAULT '', |
594 |
|
PRIMARY KEY (masterinfotype_id) |
595 |
|
|
596 |
|
); |
597 |
|
|
598 |
|
-- |
599 |
|
-- Dumping data for table `masterinfotype` |
600 |
|
-- |
601 |
|
|
602 |
|
INSERT INTO masterinfotype VALUES (1,'(N/A)'); |
603 |
|
INSERT INTO masterinfotype VALUES (2,'General Reference Sources'); |
604 |
|
INSERT INTO masterinfotype VALUES (3,'Abstracts and Indexes'); |
605 |
|
INSERT INTO masterinfotype VALUES (4,'Catalogs and Bibliographies'); |
606 |
|
INSERT INTO masterinfotype VALUES (5,'Primary Source Materials'); |
607 |
|
INSERT INTO masterinfotype VALUES (6,'Periodical and Newspaper subscriptions'); |
608 |
|
INSERT INTO masterinfotype VALUES (7,'Statistics and Data'); |
609 |
|
INSERT INTO masterinfotype VALUES (8,'Images Collections'); |
610 |
|
INSERT INTO masterinfotype VALUES (9,'Societies, Agencies, and Organizations'); |
611 |
|
INSERT INTO masterinfotype VALUES (10,'Style Manuals and Writing Guides'); |
612 |
|
INSERT INTO masterinfotype VALUES (11,'Internet Resources'); |
613 |
|
INSERT INTO masterinfotype VALUES (12,'University of Minnesota'); |
614 |
|
INSERT INTO masterinfotype VALUES (13,'WWW Resources'); |
615 |
|
|
616 |
|
-- |
617 |
-- Table structure for table `infotype` |
-- Table structure for table `infotype` |
618 |
-- |
-- |
619 |
|
|
627 |
|
|
628 |
CREATE TABLE infotype ( |
CREATE TABLE infotype ( |
629 |
infotype_id INT4 DEFAULT nextval('infotype_infotype_id_seq'), |
infotype_id INT4 DEFAULT nextval('infotype_infotype_id_seq'), |
630 |
masterinfotype_id INT4 references infotype(infotype_id) on delete cascade on update cascade, |
masterinfotype_id INT4 references masterinfotype(masterinfotype_id) on delete cascade on update cascade, |
631 |
mastersubject_id INT4 references mastersubject(mastersubject_id) on delete cascade on update cascade, |
mastersubject_id INT4 references mastersubject(mastersubject_id) on delete cascade on update cascade, |
632 |
infotype varchar(75) NOT NULL DEFAULT '', |
infotype varchar(75) NOT NULL DEFAULT '', |
633 |
PRIMARY KEY (infotype_id) |
PRIMARY KEY (infotype_id) |
954 |
-- |
-- |
955 |
|
|
956 |
-- |
-- |
|
-- Table structure for table `masterinfotype` |
|
|
-- |
|
|
|
|
|
|
|
|
|
|
|
-- |
|
|
-- Sequences for table MASTERINFOTYPE |
|
|
-- |
|
|
|
|
|
CREATE SEQUENCE masterinfotype_masterinfotyp; |
|
|
|
|
|
CREATE TABLE masterinfotype ( |
|
|
masterinfotype_id INT4 DEFAULT nextval('masterinfotype_masterinfotyp'), |
|
|
masterinfotype varchar(75) NOT NULL DEFAULT '', |
|
|
PRIMARY KEY (masterinfotype_id) |
|
|
|
|
|
); |
|
|
|
|
|
-- |
|
|
-- Dumping data for table `masterinfotype` |
|
|
-- |
|
|
|
|
|
INSERT INTO masterinfotype VALUES (1,'(N/A)'); |
|
|
INSERT INTO masterinfotype VALUES (2,'General Reference Sources'); |
|
|
INSERT INTO masterinfotype VALUES (3,'Abstracts and Indexes'); |
|
|
INSERT INTO masterinfotype VALUES (4,'Catalogs and Bibliographies'); |
|
|
INSERT INTO masterinfotype VALUES (5,'Primary Source Materials'); |
|
|
INSERT INTO masterinfotype VALUES (6,'Periodical and Newspaper subscriptions'); |
|
|
INSERT INTO masterinfotype VALUES (7,'Statistics and Data'); |
|
|
INSERT INTO masterinfotype VALUES (8,'Images Collections'); |
|
|
INSERT INTO masterinfotype VALUES (9,'Societies, Agencies, and Organizations'); |
|
|
INSERT INTO masterinfotype VALUES (10,'Style Manuals and Writing Guides'); |
|
|
INSERT INTO masterinfotype VALUES (11,'Internet Resources'); |
|
|
INSERT INTO masterinfotype VALUES (12,'University of Minnesota'); |
|
|
INSERT INTO masterinfotype VALUES (13,'WWW Resources'); |
|
|
|
|
|
-- |
|
957 |
-- Table structure for table `page_staff` |
-- Table structure for table `page_staff` |
958 |
-- |
-- |
959 |
|
|