/[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

revision 79 by dpavlin, Sat Mar 6 04:25:59 2004 UTC revision 80 by dpavlin, Thu Mar 18 22:49:15 2004 UTC
# Line 748  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 781  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 790  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 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.79  
changed lines
  Added in v.80
  ViewVC Help
Powered by ViewVC 1.1.26