/[libdata]/branches/pear-db/my2pg/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 /branches/pear-db/my2pg/libdata.pgsql

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

branches/pear-db/pg/libdata.pgsql revision 47 by dpavlin, Fri Mar 5 13:42:57 2004 UTC branches/pear-db/my2pg/libdata.pgsql revision 80 by dpavlin, Thu Mar 18 22:49:15 2004 UTC
# Line 577  INSERT INTO mastersubject VALUES (11,'Bi Line 577  INSERT INTO mastersubject VALUES (11,'Bi
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    
# Line 590  CREATE SEQUENCE infotype_infotype_id_seq Line 627  CREATE SEQUENCE infotype_infotype_id_seq
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)
# Line 711  INSERT INTO infotype VALUES (147,13,2,'L Line 748  INSERT INTO infotype VALUES (147,13,2,'L
748  INSERT INTO infotype VALUES (148,13,2,'Campus web site');  INSERT INTO infotype VALUES (148,13,2,'Campus web site');
749  INSERT INTO infotype VALUES (149,6,2,'Electronic Journal Titles');  INSERT INTO infotype VALUES (149,6,2,'Electronic Journal Titles');
750    
751    
752    --
753    -- TOC entry 2 (OID 6065592)
754    -- Name: vendor; Type: TABLE; Schema: public; Owner: dpavlin
755    --
756    
757    CREATE TABLE vendor (
758        vendor_id serial NOT NULL,
759        vendor character varying(255),
760        vendor_descr text,
761        vendor_message text,
762        vendor_status character(1)
763    );
764    
765    
766    --
767    -- Data for TOC entry 5 (OID 6065592)
768    -- Name: vendor; Type: TABLE DATA; Schema: public; Owner: dpavlin
769    --
770    
771    COPY vendor (vendor_id, vendor, vendor_descr, vendor_message, vendor_status) FROM stdin;
772    1       N/A     \N      \N      \N
773    \.
774    
775    
776    --
777    -- TOC entry 4 (OID 6065598)
778    -- Name: vendor_pkey; Type: CONSTRAINT; Schema: public; Owner: dpavlin
779    --
780    
781    ALTER TABLE ONLY vendor
782        ADD CONSTRAINT vendor_pkey PRIMARY KEY (vendor_id);
783    
784    
785    --
786    -- TOC entry 3 (OID 6065590)
787    -- Name: vendor_vendor_id_seq; Type: SEQUENCE SET; Schema: public; Owner: dpavlin
788    --
789    
790    SELECT pg_catalog.setval('vendor_vendor_id_seq', 1, true);
791    
792    
793    
794  --  --
795  -- Table structure for table `resource`  -- Table structure for table `resource`
796  --  --
# Line 744  CREATE TABLE resource ( Line 824  CREATE TABLE resource (
824    annotation text,    annotation text,
825    location_id INT4 references location(location_id) on delete cascade on update cascade,    location_id INT4 references location(location_id) on delete cascade on update cascade,
826    infotype_id INT4 references infotype(infotype_id) on delete cascade on update cascade,    infotype_id INT4 references infotype(infotype_id) on delete cascade on update cascade,
827    vendor_id INT4 DEFAULT NULL,                                          -- XXX unused    vendor_id INT4 references vendor(vendor_id) on delete cascade on update cascade,
828      guide_url text,
829      resource_message text,
830      resource_status char(1) default NULL,
831    PRIMARY KEY (resource_id)    PRIMARY KEY (resource_id)
832    
833  );  );
# Line 753  CREATE TABLE resource ( Line 836  CREATE TABLE resource (
836  -- Dumping data for table `resource`  -- Dumping data for table `resource`
837  --  --
838    
839  INSERT INTO resource VALUES (1,'2003-09-16 15:54:54','2004-03-02 16:15:20','admin','admin','Google','','','','','','','','','','http://www.google.com/',NULL,'Pretraživač weba',NULL,41,0);  INSERT INTO resource VALUES (1,'2003-09-16 15:54:54','2004-03-02 16:15:20','admin','admin','Google','','','','','','','','','','http://www.google.com/',NULL,'Pretraživač weba',NULL,41,1);
840  INSERT INTO resource VALUES (2,'2003-09-16 16:10:13','2003-09-16 16:10:13','admin',NULL,'SETI@Home','','','','','','','','','','http://setiathome.berkeley.edu/',NULL,'SETI@home is a scientific experiment that uses Internet-connected computers in the Search for Extraterrestrial Intelligence (SETI). You can participate by running a free program that downloads and analyzes radio telescope data.',NULL,138,NULL);  INSERT INTO resource VALUES (2,'2003-09-16 16:10:13','2003-09-16 16:10:13','admin',NULL,'SETI@Home','','','','','','','','','','http://setiathome.berkeley.edu/',NULL,'SETI@home is a scientific experiment that uses Internet-connected computers in the Search for Extraterrestrial Intelligence (SETI). You can participate by running a free program that downloads and analyzes radio telescope data.',NULL,138,1);
841  INSERT INTO resource VALUES (3,'2003-09-16 16:13:11','2003-09-24 09:35:24','admin','jtest','SETI Institute','','','','','','','','','','http://www.seti-inst.edu/',NULL,'The mission of the SETI Institute is to explore, understand and explain the origin, nature and prevalence of life in the universe.',NULL,87,0);  INSERT INTO resource VALUES (3,'2003-09-16 16:13:11','2003-09-24 09:35:24','admin','jtest','SETI Institute','','','','','','','','','','http://www.seti-inst.edu/',NULL,'The mission of the SETI Institute is to explore, understand and explain the origin, nature and prevalence of life in the universe.',NULL,87,1);
842  INSERT INTO resource VALUES (4,'2003-09-17 09:35:43','2003-09-17 09:35:43','admin',NULL,'Harvard\'s SETI Project','','','','','','','','','','http://seti.harvard.edu/seti/',NULL,'Project home page for Harvard\'s SETI programs.',NULL,138,NULL);  INSERT INTO resource VALUES (4,'2003-09-17 09:35:43','2003-09-17 09:35:43','admin',NULL,'Harvard\'s SETI Project','','','','','','','','','','http://seti.harvard.edu/seti/',NULL,'Project home page for Harvard\'s SETI programs.',NULL,138,1);
843  INSERT INTO resource VALUES (11,'2003-10-01 09:35:17','2003-10-01 09:35:17','admin',NULL,'Sky & Telescope\'s SETI Page','','','','','','','','','','http://skyandtelescope.com/resources/SETI/',NULL,'Sky & Telescope magazine\'s collection of resources on SETI.',NULL,138,NULL);  INSERT INTO resource VALUES (11,'2003-10-01 09:35:17','2003-10-01 09:35:17','admin',NULL,'Sky & Telescope\'s SETI Page','','','','','','','','','','http://skyandtelescope.com/resources/SETI/',NULL,'Sky & Telescope magazine\'s collection of resources on SETI.',NULL,138,1);
844  INSERT INTO resource VALUES (12,'2003-10-01 09:45:28','2003-10-01 11:54:27','admin','admin','The SETI League','','','','','','','','','','http://seti1.setileague.org/index.html',NULL,'Non-profit organization, primarily of amateur radio astronomers interested in coordinating a private effort (Project Argus) of small radio telescopes in a SETI search.',NULL,24,0);  INSERT INTO resource VALUES (12,'2003-10-01 09:45:28','2003-10-01 11:54:27','admin','admin','The SETI League','','','','','','','','','','http://seti1.setileague.org/index.html',NULL,'Non-profit organization, primarily of amateur radio astronomers interested in coordinating a private effort (Project Argus) of small radio telescopes in a SETI search.',NULL,24,1);
845  INSERT INTO resource VALUES (13,'2003-10-01 09:53:27','2003-10-06 14:48:18','admin','admin','Arecibo Observatory','','','','','','','','','','http://www.naic.edu/',NULL,'The radiotelescope based in Puerto Rico responsible for the feed to SETI@Home.',NULL,87,0);  INSERT INTO resource VALUES (13,'2003-10-01 09:53:27','2003-10-06 14:48:18','admin','admin','Arecibo Observatory','','','','','','','','','','http://www.naic.edu/',NULL,'The radiotelescope based in Puerto Rico responsible for the feed to SETI@Home.',NULL,87,1);
846  INSERT INTO resource VALUES (14,'2003-10-01 09:58:52','2004-01-27 14:35:52','admin','admin','Astrobiology Web','','','','','','','','','','http://www.astrobiology.com/',NULL,'General gateway site to many resources and articles on astrobiology.',NULL,40,0);  INSERT INTO resource VALUES (14,'2003-10-01 09:58:52','2004-01-27 14:35:52','admin','admin','Astrobiology Web','','','','','','','','','','http://www.astrobiology.com/',NULL,'General gateway site to many resources and articles on astrobiology.',NULL,40,1);
847  INSERT INTO resource VALUES (15,'2004-02-16 15:10:51','2004-02-16 15:10:51','admin',NULL,'E-LIS','E-Prints in Library and Information Science','','','','','','','','','http://eprints.rclis.org/',NULL,'',NULL,130,NULL);  INSERT INTO resource VALUES (15,'2004-02-16 15:10:51','2004-02-16 15:10:51','admin',NULL,'E-LIS','E-Prints in Library and Information Science','','','','','','','','','http://eprints.rclis.org/',NULL,'',NULL,130,1);
848  INSERT INTO resource VALUES (16,'2004-02-17 00:41:39','2004-02-27 21:32:33','admin','admin','Classics in the History of psychology','','','','','','','','','','http://psychclassics.yorku.ca/',NULL,'zbirka klasičnih tekstova iz psihologije',NULL,130,0);  INSERT INTO resource VALUES (16,'2004-02-17 00:41:39','2004-02-27 21:32:33','admin','admin','Classics in the History of psychology','','','','','','','','','','http://psychclassics.yorku.ca/',NULL,'zbirka klasičnih tekstova iz psihologije',NULL,130,1);
849  INSERT INTO resource VALUES (17,'2004-03-02 15:37:04','2004-03-02 15:37:15','admin','admin','Katalog knjižnica FF-a','','','FF','2001','','','','','','http://knjiznice.ffzg.hr/webpac/',NULL,'Skupni katalog knjižnica FF-a',NULL,24,0);  INSERT INTO resource VALUES (17,'2004-03-02 15:37:04','2004-03-02 15:37:15','admin','admin','Katalog knjižnica FF-a','','','FF','2001','','','','','','http://knjiznice.ffzg.hr/webpac/',NULL,'Skupni katalog knjižnica FF-a',NULL,24,1);
850  INSERT INTO resource VALUES (18,'2004-03-02 15:53:32','2004-03-02 15:53:57','admin','admin','Skupni katalog knjižnica tehnike','','','','','','','','','','http://mjesec.ffzg.hr/webpac-tehnika/',NULL,'',NULL,24,0);  INSERT INTO resource VALUES (18,'2004-03-02 15:53:32','2004-03-02 15:53:57','admin','admin','Skupni katalog knjižnica tehnike','','','','','','','','','','http://mjesec.ffzg.hr/webpac-tehnika/',NULL,'',NULL,24,1);
851  INSERT INTO resource VALUES (19,'2004-03-02 16:00:19','2004-03-02 16:01:46','admin','admin','Kluwer časopisi','','','Kluwer','','','','','','','http://gateway.ovid.com/autologin.html',NULL,'',NULL,126,0);  INSERT INTO resource VALUES (19,'2004-03-02 16:00:19','2004-03-02 16:01:46','admin','admin','Kluwer časopisi','','','Kluwer','','','','','','','http://gateway.ovid.com/autologin.html',NULL,'',NULL,126,1);
852  INSERT INTO resource VALUES (20,'2004-03-03 20:53:58','2004-03-03 20:54:41','admin','admin','Centar za online baze podataka','','','','','','','','','','http://nippur.irb.hr/ovid/',NULL,'Centar za online baze podataka je projekt Ministarstva znanosti i tehnologije RH  kojim ono osigurava mreľni pristup komercijalnim bazama podataka za članove znanstvene i istraľivačke zajednice RH.',NULL,18,0);  INSERT INTO resource VALUES (20,'2004-03-03 20:53:58','2004-03-03 20:54:41','admin','admin','Centar za online baze podataka','','','','','','','','','','http://nippur.irb.hr/ovid/',NULL,'Centar za online baze podataka je projekt Ministarstva znanosti i tehnologije RH  kojim ono osigurava mreľni pristup komercijalnim bazama podataka za članove znanstvene i istraľivačke zajednice RH.',NULL,18,1);
853    
854  --  --
855  -- Table structure for table `element`  -- Table structure for table `element`
# Line 917  CREATE TABLE libunit_staff ( Line 1000  CREATE TABLE libunit_staff (
1000  --  --
1001    
1002  --  --
 -- 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');  
   
 --  
1003  -- Table structure for table `page_staff`  -- Table structure for table `page_staff`
1004  --  --
1005    
# Line 1399  SELECT SETVAL('campus_campus_id_seq',(se Line 1445  SELECT SETVAL('campus_campus_id_seq',(se
1445  SELECT SETVAL('pagetype_pagetype_id_seq',(select case when max(pagetype_id)>0 then max(pagetype_id)+1 else 1 end from pagetype));  SELECT SETVAL('pagetype_pagetype_id_seq',(select case when max(pagetype_id)>0 then max(pagetype_id)+1 else 1 end from pagetype));
1446    
1447  COMMIT;  COMMIT;
1448    
Legend:
Removed from v.47  
changed lines
  Added in v.80
  ViewVC Help
Powered by ViewVC 1.1.26