From 5fd86868e8963ea305ce40fc7c5f1ab07c51d286 Mon Sep 17 00:00:00 2001 From: tonnesen Date: Wed, 15 Jan 2003 18:39:31 +0000 Subject: [PATCH] Added extra field for itemtypes table to sample data --- sampledata-1.2 | 38 +++++++++++++++++++------------------- 1 file changed, 19 insertions(+), 19 deletions(-) diff --git a/sampledata-1.2 b/sampledata-1.2 index 8e9dbb9ef2..18d326b3ca 100644 --- a/sampledata-1.2 +++ b/sampledata-1.2 @@ -2008,25 +2008,25 @@ INSERT INTO additionalauthors VALUES ('KOVALSKI, MARYANN.',223); -- -INSERT INTO itemtypes VALUES ('JNF','Junior Non-Fiction',7,10,0.0000); -INSERT INTO itemtypes VALUES ('NFYA','Young Adult Non-Fiction',7,10,0.0000); -INSERT INTO itemtypes VALUES ('NF','Non-Fiction',7,10,0.0000); -INSERT INTO itemtypes VALUES ('JF','Junior Fiction',7,10,0.0000); -INSERT INTO itemtypes VALUES ('FYA','Young Adult Fiction',7,10,0.0000); -INSERT INTO itemtypes VALUES ('F','Fiction',7,10,0.0000); -INSERT INTO itemtypes VALUES ('PER','Periodicals Stand',0,0,0.0000); -INSERT INTO itemtypes VALUES ('REF','Reference Books',0,0,0.0000); -INSERT INTO itemtypes VALUES ('VID','Video',7,10,1.5000); -INSERT INTO itemtypes VALUES ('CD','Compact disc',7,10,1.5000); -INSERT INTO itemtypes VALUES ('CAS','Cassette',7,10,1.50000); -INSERT INTO itemtypes VALUES ('ROM','CD-Rom',7,10,1.5000); -INSERT INTO itemtypes VALUES ('JIG','Jigsaw Puzzle',7,10,0.0000); -INSERT INTO itemtypes VALUES ('MAP','Maps',7,10,0.0000); -INSERT INTO itemtypes VALUES ('ART','Art Prints',7,10,0.0000); -INSERT INTO itemtypes VALUES ('PHOT','Photograph',7,10,0.0000); -INSERT INTO itemtypes VALUES ('TREF','Teacher Reference',7,10,0.0000); -INSERT INTO itemtypes VALUES ('E','Easy / Picture Books',7,10,0.0000); -INSERT INTO itemtypes VALUES ('ER','Easy Reader',7,10,0.0000); +INSERT INTO itemtypes VALUES ('JNF','Junior Non-Fiction',7,10,0.0000,NULL); +INSERT INTO itemtypes VALUES ('NFYA','Young Adult Non-Fiction',7,10,0.0000,NULL); +INSERT INTO itemtypes VALUES ('NF','Non-Fiction',7,10,0.0000,NULL); +INSERT INTO itemtypes VALUES ('JF','Junior Fiction',7,10,0.0000,NULL); +INSERT INTO itemtypes VALUES ('FYA','Young Adult Fiction',7,10,0.0000,NULL); +INSERT INTO itemtypes VALUES ('F','Fiction',7,10,0.0000,NULL); +INSERT INTO itemtypes VALUES ('PER','Periodicals Stand',0,0,0.0000,NULL); +INSERT INTO itemtypes VALUES ('REF','Reference Books',0,0,0.0000,NULL); +INSERT INTO itemtypes VALUES ('VID','Video',7,10,1.5000,NULL); +INSERT INTO itemtypes VALUES ('CD','Compact disc',7,10,1.5000,NULL); +INSERT INTO itemtypes VALUES ('CAS','Cassette',7,10,1.50000,NULL); +INSERT INTO itemtypes VALUES ('ROM','CD-Rom',7,10,1.5000,NULL); +INSERT INTO itemtypes VALUES ('JIG','Jigsaw Puzzle',7,10,0.0000,NULL); +INSERT INTO itemtypes VALUES ('MAP','Maps',7,10,0.0000,NULL); +INSERT INTO itemtypes VALUES ('ART','Art Prints',7,10,0.0000,NULL); +INSERT INTO itemtypes VALUES ('PHOT','Photograph',7,10,0.0000,NULL); +INSERT INTO itemtypes VALUES ('TREF','Teacher Reference',7,10,0.0000,NULL); +INSERT INTO itemtypes VALUES ('E','Easy / Picture Books',7,10,0.0000,NULL); +INSERT INTO itemtypes VALUES ('ER','Easy Reader',7,10,0.0000,NULL); # # Dumping data for table 'bibliosubject' -- 2.39.5