/[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 57 by dpavlin, Fri Mar 5 13:45:55 2004 UTC revision 58 by dpavlin, Sat Mar 6 04:25:59 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 917  CREATE TABLE libunit_staff ( Line 954  CREATE TABLE libunit_staff (
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    
Legend:
Removed from v.57  
changed lines
  Added in v.58
  ViewVC Help
Powered by ViewVC 1.1.26