/[libdata]/branches/paul/admin/install/libdata.sql
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/paul/admin/install/libdata.sql

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

revision 66 by dpavlin, Wed Jan 28 17:22:41 2004 UTC revision 67 by dpavlin, Thu Mar 18 19:24:54 2004 UTC
# Line 487  CREATE TABLE page ( Line 487  CREATE TABLE page (
487  --  --
488    
489    
490  INSERT INTO page VALUES (4,'2003-09-24 09:29:36','2004-01-27 14:50:00','admin','admin',2,10,2,'Further SETI Resources',NULL,NULL,NULL,'0',NULL,'0','[Return to Top]','',NULL,NULL);  INSERT INTO page VALUES (4,'2003-09-24 09:29:36','2004-01-30 15:05:23','admin','admin',2,1,2,'Further SETI Resources',NULL,NULL,NULL,'0',NULL,'0','[Return to Top]','',NULL,NULL);
491  INSERT INTO page VALUES (15,'2003-10-06 10:01:31','2004-01-15 10:50:59','admin','admin',2,10,3,'Advanced Topics in Astronomy',NULL,'1','0','1','0','1','[Return to Top]',NULL,NULL,NULL);  INSERT INTO page VALUES (15,'2003-10-06 10:01:31','2004-02-19 13:23:11','admin','admin',2,2,3,'Advanced Topics in Astronomy',NULL,'1','0','1','0','1','[Return to Top]',NULL,NULL,NULL);
492    
493  --  --
494  -- Table structure for table `page_staff`  -- Table structure for table `page_staff`
# Line 664  CREATE TABLE resource ( Line 664  CREATE TABLE resource (
664    coverage_detail varchar(255) default NULL,    coverage_detail varchar(255) default NULL,
665    sources_indexed varchar(100) default NULL,    sources_indexed varchar(100) default NULL,
666    url text,    url text,
667      guide_url text,
668    visited varchar(25) default NULL,    visited varchar(25) default NULL,
669    annotation text,    annotation text,
670    location_id mediumint(9) default NULL,    location_id mediumint(9) default NULL,
671    infotype_id mediumint(9) default NULL,    infotype_id mediumint(9) default NULL,
672    vendor_id mediumint(9) default NULL,    vendor_id mediumint(9) default NULL,
673      resource_message text,
674      resource_status char(1) default NULL,
675    PRIMARY KEY  (resource_id)    PRIMARY KEY  (resource_id)
676  ) TYPE=MyISAM;  ) TYPE=MyISAM;
677    
# Line 677  CREATE TABLE resource ( Line 680  CREATE TABLE resource (
680  --  --
681    
682    
683  INSERT INTO resource VALUES (1,'2003-09-16 15:54:54','2003-09-30 10:51:10','admin','admin','Google','','','','','','','','','','http://www.google.com',NULL,'',NULL,18,0);  INSERT INTO resource VALUES (1,'2003-09-16 15:54:54','2003-09-30 10:51:10','admin','admin','Google','','','','','','','','','','http://www.google.com',NULL,NULL,'',NULL,18,0,NULL,NULL);
684  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,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,NULL,NULL);
685  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,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,NULL,NULL);
686  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,NULL,'Project home page for Harvard\'s SETI programs.',NULL,138,NULL,NULL,NULL);
687  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,NULL,'Sky & Telescope magazine\'s collection of resources on SETI.',NULL,138,NULL,NULL,NULL);
688  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,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,NULL,NULL);
689  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,NULL,'The radiotelescope based in Puerto Rico responsible for the feed to SETI@Home.',NULL,87,0,NULL,NULL);
690  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,NULL,'General gateway site to many resources and articles on astrobiology.',NULL,40,0,NULL,NULL);
691    
692  --  --
693  -- Table structure for table `serv_loc`  -- Table structure for table `serv_loc`
# Line 838  CREATE TABLE style ( Line 841  CREATE TABLE style (
841    
842  INSERT INTO style VALUES (1,'(N/A)',NULL,NULL,NULL);  INSERT INTO style VALUES (1,'(N/A)',NULL,NULL,NULL);
843  INSERT INTO style VALUES (2,'LibData Standard','header.phtml','footer.phtml','libdata.css');  INSERT INTO style VALUES (2,'LibData Standard','header.phtml','footer.phtml','libdata.css');
844  INSERT INTO style VALUES (10,'LibData Inverse Demo','styles/libinverse/header.phtml','styles/libinverse/footer.phtml','styles/libinverse/libdata.css');  INSERT INTO style VALUES (10,'LibData Inverse Demo','/var/www/html/libdata_pos/styles/libinverse/header.phtml','/var/www/html/libdata_pos/styles/libinverse/footer.phtml','/var/www/html/libdata_pos/styles/libinverse/libdata.css');
845    
846  --  --
847  -- Table structure for table `sub_coursesub`  -- Table structure for table `sub_coursesub`
# Line 965  CREATE TABLE subject ( Line 968  CREATE TABLE subject (
968    
969    
970  INSERT INTO subject VALUES (1,'(N/A)',NULL,NULL,'2003-08-27 10:07:20','2003-08-27 10:07:50','staff','staff','1');  INSERT INTO subject VALUES (1,'(N/A)',NULL,NULL,'2003-08-27 10:07:20','2003-08-27 10:07:50','staff','staff','1');
971  INSERT INTO subject VALUES (2,'Astrobiology','Encompasses the search for extraterrestrial intelligence (commonly abbreviated as SETI), as well as an interdisciplinary mix of both astronomy and biology.',58,'2003-09-16 16:02:50','2003-11-06 11:33:06','admin','admin','1');  INSERT INTO subject VALUES (2,'Astrobiology','Encompasses the search for extraterrestrial intelligence (commonly abbreviated as SETI), as well as an interdisciplinary mix of both astronomy and biology.',58,'2003-09-16 16:02:50','2004-01-30 13:11:24','admin','admin','1');
972  INSERT INTO subject VALUES (3,'Astronomy','The study of planets, stars, galaxies, and other objects in space.',55,'2003-11-04 12:14:53','2004-01-28 11:01:32','admin','admin','1');  INSERT INTO subject VALUES (3,'Astronomy','The study of planets, stars, galaxies, and other objects in space.',55,'2003-11-04 12:14:53','2004-01-30 13:10:59','admin','admin','1');
973    
974  --  --
975  -- Table structure for table `term`  -- Table structure for table `term`
# Line 988  INSERT INTO term VALUES (2,'Fall Semeste Line 991  INSERT INTO term VALUES (2,'Fall Semeste
991  INSERT INTO term VALUES (3,'Spring Semester');  INSERT INTO term VALUES (3,'Spring Semester');
992  INSERT INTO term VALUES (4,'Summer Term');  INSERT INTO term VALUES (4,'Summer Term');
993    
994    --
995    -- Table structure for table `vendor`
996    --
997    
998    CREATE TABLE vendor (
999      vendor_id mediumint(9) NOT NULL auto_increment,
1000      vendor varchar(255) default NULL,
1001      vendor_descr text,
1002      vendor_message text,
1003      vendor_status char(1) default NULL,
1004      PRIMARY KEY  (vendor_id)
1005    ) TYPE=MyISAM;
1006    
1007    --
1008    -- Dumping data for table `vendor`
1009    --
1010    
1011    
1012    INSERT INTO vendor VALUES (1,'(N/A)',NULL,NULL,NULL);
1013    
Legend:
Removed from v.66  
changed lines
  Added in v.67
  ViewVC Help
Powered by ViewVC 1.1.26