1 COPY asset.copy_location (id, name, owning_lib, holdable, hold_verify, opac_visible, circulate, label_prefix, label_suffix, checkin_alert, deleted, url) FROM stdin;
2 101 Reference 1 0 0 1 0 \N \N 0 0 \N
3 102 Reference 4 0 0 1 0 \N \N 0 0 \N
4 103 Easy Reader 4 1 0 1 1 \N \N 0 0 \N
5 104 Easy Reader 5 1 0 1 1 \N \N 0 0 \N
6 105 Easy Reader 6 1 0 1 1 \N \N 0 0 \N
7 106 Fiction 2 1 0 1 1 \N \N 0 0 \N
8 107 Fiction 3 1 0 1 1 \N \N 0 0 \N
9 108 Non-Fiction 2 1 0 1 1 \N \N 0 0 \N
10 109 Non-Fiction 3 1 0 1 1 \N \N 0 0 \N
11 110 Juvenile Non-Fiction 2 1 0 1 1 \N \N 0 0 \N
12 111 Juvenile Non-Fiction 3 1 0 1 1 \N \N 0 0 \N
13 112 Young Adult Fiction 2 1 0 1 1 \N \N 0 0 \N
14 113 Young Adult Fiction 4 1 0 1 1 \N \N 0 0 \N
15 114 Young Adult Fiction 5 1 0 1 1 \N \N 0 0 \N
16 115 Young Adult Fiction 6 1 0 1 1 \N \N 0 0 \N
17 116 Children's Fiction 2 1 0 1 1 \N \N 0 0 \N
18 117 Children's Fiction 3 1 0 1 1 \N \N 0 0 \N
19 118 Audio/Video 4 1 0 1 1 \N \N 0 0 \N
20 119 Audio/Video 5 1 0 1 1 \N \N 0 0 \N
21 120 Music 5 1 0 1 1 \N \N 0 0 \N
22 121 Music 6 1 0 1 1 \N \N 0 0 \N
23 122 Audio/Video 6 1 0 1 1 \N \N 0 0 \N
24 123 Science Fiction 4 1 0 1 1 \N \N 0 0 \N
25 124 Science Fiction 7 1 0 1 1 \N \N 0 0 \N
26 125 Genealogy 5 1 0 1 1 \N \N 0 0 \N
27 126 Genealogy 6 1 0 1 1 \N \N 0 0 \N
28 127 Biography 4 1 0 1 1 \N \N 0 0 \N
29 128 Biography 5 1 0 1 1 \N \N 0 0 \N
30 129 Local History 6 1 0 1 1 \N \N 0 0 \N
31 130 Local History 7 1 0 1 1 \N \N 0 0 \N
32 131 Federal Documents 6 1 0 1 1 \N \N 0 0 \N
33 132 Periodicals 4 0 0 1 0 \N \N 0 0 \N
34 133 Periodicals 6 0 0 1 0 \N \N 0 0 \N
35 134 Magazines 5 0 0 1 0 \N \N 0 0 \N
36 135 Magazines 7 0 0 1 0 \N \N 0 0 \N
37 136 Newspapers 4 0 0 1 0 \N \N 0 0 \N
38 137 Reserves 4 0 0 1 1 \N \N 0 0 \N
39 138 Reserves 5 0 0 1 1 \N \N 0 0 \N
40 139 Reserves 3 0 0 1 1 \N \N 0 0 \N
41 140 Theses 5 0 0 1 1 \N \N 0 0 \N
42 141 Theses 7 1 0 1 1 \N \N 0 0 \N
43 142 Special Collections 2 0 0 1 1 \N \N 0 0 \N
44 143 Special Collections 6 0 0 1 1 \N \N 0 0 \N
45 144 Special Collections 7 0 0 1 1 \N \N 0 0 \N
46 145 Display 2 0 0 0 1 \N \N 0 0 \N
47 146 Display 4 0 0 0 0 \N \N 0 0 \N
48 147 Display 5 1 0 0 0 \N \N 0 0 \N
49 148 Display 6 1 0 0 0 \N \N 0 0 \N
50 149 Display 7 0 0 0 0 \N \N 0 0 \N
51 150 New Arrivals 1 1 0 1 1 \N \N 0 0 \N
52 151 New Arrivals 2 0 0 1 1 \N \N 0 0 \N
53 152 New Arrivals 4 1 0 1 0 \N \N 0 0 \N
54 153 New Arrivals 5 1 0 1 1 \N \N 0 0 \N
55 154 Board Books 101 0 0 1 1 BB \N 0 0 \N
56 155 Easy Readers 101 0 0 1 1 EZ \N 0 0 \N
57 156 Children's Fiction 101 1 0 1 1 CF \N 0 0 \N
58 157 Children's Non-Fiction 101 1 0 1 1 CN \N 0 0 \N
59 158 Teen Fiction 101 1 0 1 1 TF \N 0 0 \N
60 159 Teen Non-Fiction 101 1 0 1 1 TN \N 0 0 \N
61 160 Mysteries 101 1 0 1 1 MYS \N 0 0 \N
62 161 Westerns 101 1 0 1 1 W \N 0 0 \N
63 162 Science Fiction & Fantasy 101 1 0 1 1 SFF \N 0 0 \N
64 163 DVDs and Audiobooks 101 1 0 1 1 AV \N 1 0 \N
65 164 New Books 101 0 0 1 1 NEW \N 1 0 \N
66 165 Local Interest 101 1 0 1 1 LOC \N 0 0 \N
67 166 Staff Picks 101 1 0 1 1 REC \N 0 0 \N
68 167 Behind Desk 101 0 0 1 1 DESK \N 0 0 \N
69 168 Fiction 101 1 0 1 1 FIC \N 0 0 \N
70 169 Non-Fiction 101 1 0 1 1 NONFIC \N 0 0 \N
71 170 Do-It-Yourself 101 1 0 1 1 DIY \N 0 0 \N
72 171 Fiction 104 1 0 1 1 \N \N 0 0 \N
73 172 AV 104 1 1 1 1 \N \N 1 0 \N
74 173 Kids & Teens 105 1 0 1 1 \N \N 0 0 \N
75 174 Staff Resources 105 0 0 0 1 \N STAFF 1 0 \N
76 175 Young Adult 107 1 0 1 1 YA \N 0 0 \N
77 176 Children's 107 1 0 1 1 CH \N 0 0 \N
78 177 Genealogy 107 0 0 0 0 G \N 0 1 \N
79 178 Grab 'N Go 108 0 0 1 1 POP \N 1 0 \N
80 179 Mystery 107 1 0 1 1 MYS \N 0 0 \N
81 180 Science Fiction & Fantasy 107 1 0 1 1 SFF \N 0 0 \N
82 181 Movies 107 0 0 1 1 DVD \N 1 0 \N
83 182 Audiobooks 107 1 0 1 1 AUD \N 1 0 \N
84 183 Westerns 108 1 0 1 1 WST \N 0 0 \N
85 184 Genealogy 111 0 0 1 0 GEN \N 0 0 \N
86 185 Local Interest 108 1 0 1 1 LOC \N 0 0 \N
87 186 How To Books 107 1 0 1 1 DIY \N 0 0 \N
88 187 Roaming Bookmobile Collection 109 0 0 1 1 BKM \N 0 0 \N
89 188 Newspapers 6 0 0 1 0 \N \N 0 0 \N
92 \echo sequence update column: id
93 SELECT SETVAL('asset.copy_location_id_seq', (SELECT MAX(id) FROM asset.copy_location));