1 |
dpavlin |
23 |
-- MySQL dump 8.23 |
2 |
|
|
-- |
3 |
|
|
-- Host: localhost Database: libdata |
4 |
|
|
--------------------------------------------------------- |
5 |
|
|
-- Server version 3.23.56 |
6 |
|
|
|
7 |
|
|
-- |
8 |
|
|
-- Table structure for table `access` |
9 |
|
|
-- |
10 |
|
|
|
11 |
|
|
CREATE TABLE access ( |
12 |
|
|
access_id mediumint(9) NOT NULL auto_increment, |
13 |
|
|
access_level mediumint(9) default NULL, |
14 |
|
|
access varchar(25) default NULL, |
15 |
|
|
PRIMARY KEY (access_id) |
16 |
|
|
) TYPE=MyISAM; |
17 |
|
|
|
18 |
|
|
-- |
19 |
|
|
-- Dumping data for table `access` |
20 |
|
|
-- |
21 |
|
|
|
22 |
|
|
|
23 |
|
|
INSERT INTO access VALUES (1,0,'Denied'); |
24 |
|
|
INSERT INTO access VALUES (2,10,'Guest'); |
25 |
|
|
INSERT INTO access VALUES (3,20,'Author'); |
26 |
|
|
INSERT INTO access VALUES (4,100,'Manager'); |
27 |
|
|
INSERT INTO access VALUES (5,1000,'DBA'); |
28 |
|
|
|
29 |
|
|
-- |
30 |
|
|
-- Table structure for table `campus` |
31 |
|
|
-- |
32 |
|
|
|
33 |
|
|
CREATE TABLE campus ( |
34 |
|
|
campus_id mediumint(9) NOT NULL auto_increment, |
35 |
|
|
campus varchar(50) default NULL, |
36 |
|
|
institution varchar(10) default NULL, |
37 |
|
|
PRIMARY KEY (campus_id) |
38 |
|
|
) TYPE=MyISAM; |
39 |
|
|
|
40 |
|
|
-- |
41 |
|
|
-- Dumping data for table `campus` |
42 |
|
|
-- |
43 |
|
|
|
44 |
|
|
|
45 |
|
|
INSERT INTO campus VALUES (1,'(N/A)','(N/A)'); |
46 |
|
|
|
47 |
|
|
-- |
48 |
|
|
-- Table structure for table `course` |
49 |
|
|
-- |
50 |
|
|
|
51 |
|
|
CREATE TABLE course ( |
52 |
|
|
course_id mediumint(9) NOT NULL auto_increment, |
53 |
|
|
page_id mediumint(9) default NULL, |
54 |
|
|
coursesub_id mediumint(9) default NULL, |
55 |
|
|
course_num varchar(50) default NULL, |
56 |
|
|
course_section varchar(10) default NULL, |
57 |
|
|
course_concat varchar(255) default NULL, |
58 |
|
|
term_id mediumint(9) default NULL, |
59 |
|
|
course_year varchar(4) default NULL, |
60 |
|
|
campus_id mediumint(9) default NULL, |
61 |
|
|
courseheader varchar(255) default NULL, |
62 |
|
|
introheader1 text, |
63 |
|
|
intromessage1 text, |
64 |
|
|
introheader2 text, |
65 |
|
|
intromessage2 text, |
66 |
|
|
PRIMARY KEY (course_id) |
67 |
|
|
) TYPE=MyISAM; |
68 |
|
|
|
69 |
|
|
-- |
70 |
|
|
-- Dumping data for table `course` |
71 |
|
|
-- |
72 |
|
|
|
73 |
|
|
|
74 |
|
|
INSERT INTO course VALUES (8,15,554,'909','1','ASTRO 909: Advanced Topics in Astronomy',2,'2003',NULL,'Information Resources for:','Course Description','This course serves as a cross-displinary introduction to xenobiology.',NULL,NULL); |
75 |
|
|
|
76 |
|
|
-- |
77 |
|
|
-- Table structure for table `course_personnel` |
78 |
|
|
-- |
79 |
|
|
|
80 |
|
|
CREATE TABLE course_personnel ( |
81 |
|
|
personnel_id mediumint(9) NOT NULL auto_increment, |
82 |
|
|
course_id mediumint(9) NOT NULL default '0', |
83 |
|
|
stafftitle_id mediumint(9) default NULL, |
84 |
|
|
staff_id mediumint(9) default NULL, |
85 |
|
|
faculty_id mediumint(9) default NULL, |
86 |
|
|
pers_email varchar(40) default NULL, |
87 |
|
|
pers_account varchar(20) default NULL, |
88 |
|
|
pers_lastname varchar(50) default NULL, |
89 |
|
|
pers_firstname varchar(20) default NULL, |
90 |
|
|
PRIMARY KEY (personnel_id) |
91 |
|
|
) TYPE=MyISAM; |
92 |
|
|
|
93 |
|
|
-- |
94 |
|
|
-- Dumping data for table `course_personnel` |
95 |
|
|
-- |
96 |
|
|
|
97 |
|
|
|
98 |
|
|
INSERT INTO course_personnel VALUES (4,8,7,2,NULL,NULL,NULL,NULL,NULL); |
99 |
|
|
|
100 |
|
|
-- |
101 |
|
|
-- Table structure for table `coursesub` |
102 |
|
|
-- |
103 |
|
|
|
104 |
|
|
CREATE TABLE coursesub ( |
105 |
|
|
coursesub_id mediumint(9) NOT NULL auto_increment, |
106 |
|
|
coursesub varchar(15) default NULL, |
107 |
|
|
coursesub_descr varchar(100) default NULL, |
108 |
|
|
cip_code varchar(50) default NULL, |
109 |
|
|
campus_id mediumint(9) default NULL, |
110 |
|
|
PRIMARY KEY (coursesub_id) |
111 |
|
|
) TYPE=MyISAM; |
112 |
|
|
|
113 |
|
|
-- |
114 |
|
|
-- Dumping data for table `coursesub` |
115 |
|
|
-- |
116 |
|
|
|
117 |
|
|
|
118 |
|
|
INSERT INTO coursesub VALUES (1,'(N/A)','(N/A)',NULL,NULL); |
119 |
|
|
INSERT INTO coursesub VALUES (554,'ASTRO','Astronomy','',1); |
120 |
|
|
INSERT INTO coursesub VALUES (553,'ANTH','Anthropology','',1); |
121 |
|
|
|
122 |
|
|
-- |
123 |
|
|
-- Table structure for table `element` |
124 |
|
|
-- |
125 |
|
|
|
126 |
|
|
CREATE TABLE element ( |
127 |
|
|
element_id mediumint(9) NOT NULL auto_increment, |
128 |
|
|
page_id mediumint(9) default NULL, |
129 |
|
|
parent_id mediumint(9) default NULL, |
130 |
|
|
resource_id mediumint(9) default NULL, |
131 |
|
|
location_id mediumint(9) default NULL, |
132 |
|
|
service_id mediumint(9) default NULL, |
133 |
|
|
staff_id mediumint(9) default NULL, |
134 |
|
|
subject_id mediumint(9) default NULL, |
135 |
|
|
label varchar(200) default NULL, |
136 |
|
|
label_url varchar(200) default NULL, |
137 |
|
|
element_descr text, |
138 |
|
|
element_size smallint(6) default NULL, |
139 |
|
|
element_order smallint(6) default NULL, |
140 |
|
|
indent_level smallint(6) default NULL, |
141 |
|
|
PRIMARY KEY (element_id) |
142 |
|
|
) TYPE=MyISAM; |
143 |
|
|
|
144 |
|
|
-- |
145 |
|
|
-- Dumping data for table `element` |
146 |
|
|
-- |
147 |
|
|
|
148 |
|
|
|
149 |
|
|
INSERT INTO element VALUES (21,4,15,14,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,1); |
150 |
|
|
INSERT INTO element VALUES (22,4,15,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,6,1); |
151 |
|
|
INSERT INTO element VALUES (20,4,15,13,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,1); |
152 |
|
|
INSERT INTO element VALUES (15,4,0,NULL,NULL,NULL,NULL,NULL,'Harested Links from the Astrobiology RQS Page','','<i>Note</i> -- these aren\'t actually additional resources. They are duplicated here to demonstrate PageScribe.',2,3,0); |
153 |
|
|
INSERT INTO element VALUES (23,4,15,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,7,1); |
154 |
|
|
INSERT INTO element VALUES (25,4,15,11,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,8,1); |
155 |
|
|
INSERT INTO element VALUES (28,15,0,NULL,NULL,NULL,NULL,NULL,'Library Resources','','',1,8,0); |
156 |
|
|
INSERT INTO element VALUES (29,15,28,NULL,58,NULL,NULL,NULL,NULL,NULL,'\r\n',NULL,10,1); |
157 |
|
|
INSERT INTO element VALUES (30,15,28,NULL,55,NULL,NULL,NULL,NULL,NULL,NULL,NULL,9,1); |
158 |
|
|
INSERT INTO element VALUES (31,15,0,NULL,NULL,NULL,NULL,NULL,'Astrobiology','','',1,1,0); |
159 |
|
|
INSERT INTO element VALUES (32,15,31,13,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,1); |
160 |
|
|
INSERT INTO element VALUES (33,15,31,14,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3,1); |
161 |
|
|
INSERT INTO element VALUES (34,15,31,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,1); |
162 |
|
|
INSERT INTO element VALUES (35,15,31,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,1); |
163 |
|
|
INSERT INTO element VALUES (36,15,31,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,6,1); |
164 |
|
|
INSERT INTO element VALUES (37,15,31,11,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,1); |
165 |
|
|
INSERT INTO element VALUES (49,4,48,2,NULL,NULL,NULL,NULL,'','','',NULL,2,1); |
166 |
|
|
INSERT INTO element VALUES (48,4,0,NULL,NULL,NULL,NULL,NULL,'<IMG SRC=\"http://setiathome.berkeley.edu/images/header-sah.gif\">','','',NULL,1,0); |
167 |
|
|
|
168 |
|
|
-- |
169 |
|
|
-- Table structure for table `faculty` |
170 |
|
|
-- |
171 |
|
|
|
172 |
|
|
CREATE TABLE faculty ( |
173 |
|
|
faculty_id mediumint(9) NOT NULL auto_increment, |
174 |
|
|
faculty_lastname varchar(75) default NULL, |
175 |
|
|
faculty_firstname varchar(75) default NULL, |
176 |
|
|
faculty_email varchar(50) default NULL, |
177 |
|
|
faculty_account varchar(20) default NULL, |
178 |
|
|
PRIMARY KEY (faculty_id) |
179 |
|
|
) TYPE=MyISAM; |
180 |
|
|
|
181 |
|
|
-- |
182 |
|
|
-- Dumping data for table `faculty` |
183 |
|
|
-- |
184 |
|
|
|
185 |
|
|
|
186 |
|
|
INSERT INTO faculty VALUES (1,NULL,NULL,NULL,'(N/A)'); |
187 |
|
|
INSERT INTO faculty VALUES (123,'Smith','Joe','joe001@yourlibrary.edu','joe001'); |
188 |
|
|
|
189 |
|
|
-- |
190 |
|
|
-- Table structure for table `feature` |
191 |
|
|
-- |
192 |
|
|
|
193 |
|
|
CREATE TABLE feature ( |
194 |
|
|
feature_id mediumint(9) NOT NULL auto_increment, |
195 |
|
|
feature varchar(50) default NULL, |
196 |
|
|
image_path varchar(100) default NULL, |
197 |
|
|
image_alt varchar(100) default NULL, |
198 |
|
|
PRIMARY KEY (feature_id) |
199 |
|
|
) TYPE=MyISAM; |
200 |
|
|
|
201 |
|
|
-- |
202 |
|
|
-- Dumping data for table `feature` |
203 |
|
|
-- |
204 |
|
|
|
205 |
|
|
|
206 |
|
|
INSERT INTO feature VALUES (1,'(N/A)',NULL,NULL); |
207 |
|
|
INSERT INTO feature VALUES (2,'CD-ROM','images/cd.gif','On CD-ROM Format'); |
208 |
|
|
INSERT INTO feature VALUES (3,'Full Text','images/fulltext.gif','Available in Full Text'); |
209 |
|
|
INSERT INTO feature VALUES (5,'Restricted','images/lock.gif','Authentication Required'); |
210 |
|
|
|
211 |
|
|
-- |
212 |
|
|
-- Table structure for table `infotype` |
213 |
|
|
-- |
214 |
|
|
|
215 |
|
|
CREATE TABLE infotype ( |
216 |
|
|
infotype_id mediumint(9) NOT NULL auto_increment, |
217 |
|
|
masterinfotype_id mediumint(9) default NULL, |
218 |
|
|
mastersubject_id mediumint(9) default NULL, |
219 |
|
|
infotype varchar(75) NOT NULL default '', |
220 |
|
|
PRIMARY KEY (infotype_id) |
221 |
|
|
) TYPE=MyISAM; |
222 |
|
|
|
223 |
|
|
-- |
224 |
|
|
-- Dumping data for table `infotype` |
225 |
|
|
-- |
226 |
|
|
|
227 |
|
|
|
228 |
|
|
INSERT INTO infotype VALUES (1,1,1,'(N/A)'); |
229 |
|
|
INSERT INTO infotype VALUES (2,2,2,'Almanacs'); |
230 |
|
|
INSERT INTO infotype VALUES (3,2,2,'Encyclopedias'); |
231 |
|
|
INSERT INTO infotype VALUES (4,2,2,'Field Guides'); |
232 |
|
|
INSERT INTO infotype VALUES (5,2,2,'Dictionaries'); |
233 |
|
|
INSERT INTO infotype VALUES (6,2,2,'Handbooks and Manuals'); |
234 |
|
|
INSERT INTO infotype VALUES (7,2,2,'Biographical Sources'); |
235 |
|
|
INSERT INTO infotype VALUES (8,2,2,'Directories'); |
236 |
|
|
INSERT INTO infotype VALUES (9,2,2,'Glossaries'); |
237 |
|
|
INSERT INTO infotype VALUES (10,2,2,'Reports'); |
238 |
|
|
INSERT INTO infotype VALUES (11,2,2,'Public Opinion Resources'); |
239 |
|
|
INSERT INTO infotype VALUES (12,2,2,'Yearbooks'); |
240 |
|
|
INSERT INTO infotype VALUES (13,2,2,'Speeches'); |
241 |
|
|
INSERT INTO infotype VALUES (14,2,2,'Atlases & Maps'); |
242 |
|
|
INSERT INTO infotype VALUES (15,2,2,'Chronologies'); |
243 |
|
|
INSERT INTO infotype VALUES (16,2,2,'Forms, Tests, Inventories'); |
244 |
|
|
INSERT INTO infotype VALUES (17,2,2,'General Reference Works'); |
245 |
|
|
INSERT INTO infotype VALUES (18,3,2,'Academic or Scholarly Articles Subject Indexes'); |
246 |
|
|
INSERT INTO infotype VALUES (19,3,2,'General Indexes to Magazine, Journal & Newspaper Articles'); |
247 |
|
|
INSERT INTO infotype VALUES (20,3,2,'Catalogs & Indexes to Government Publications'); |
248 |
|
|
INSERT INTO infotype VALUES (21,3,2,'Indexes, Other'); |
249 |
|
|
INSERT INTO infotype VALUES (22,4,2,'Bibliographies'); |
250 |
|
|
INSERT INTO infotype VALUES (23,4,2,'National Bibliographies'); |
251 |
|
|
INSERT INTO infotype VALUES (24,4,2,'Catalogs'); |
252 |
|
|
INSERT INTO infotype VALUES (25,5,2,'Reports'); |
253 |
|
|
INSERT INTO infotype VALUES (26,5,2,'Diaries'); |
254 |
|
|
INSERT INTO infotype VALUES (27,5,2,'Correspondence'); |
255 |
|
|
INSERT INTO infotype VALUES (28,5,2,'Speeches'); |
256 |
|
|
INSERT INTO infotype VALUES (29,6,2,'News Sources'); |
257 |
|
|
INSERT INTO infotype VALUES (30,6,2,'Journal Titles'); |
258 |
|
|
INSERT INTO infotype VALUES (31,6,2,'Magazine Titles'); |
259 |
|
|
INSERT INTO infotype VALUES (32,7,2,'Data Resources'); |
260 |
|
|
INSERT INTO infotype VALUES (33,7,2,'Statistical Guides'); |
261 |
|
|
INSERT INTO infotype VALUES (34,7,2,'Statistical Resources'); |
262 |
|
|
INSERT INTO infotype VALUES (35,8,2,'Atlases and Maps'); |
263 |
|
|
INSERT INTO infotype VALUES (37,9,2,'Trade & Professional Associations'); |
264 |
|
|
INSERT INTO infotype VALUES (38,10,2,'Guides to Working with Government Publications'); |
265 |
|
|
INSERT INTO infotype VALUES (39,10,2,'Research Guides'); |
266 |
|
|
INSERT INTO infotype VALUES (40,11,2,'Gateways & Megasites'); |
267 |
|
|
INSERT INTO infotype VALUES (41,11,2,'Search Engines'); |
268 |
|
|
INSERT INTO infotype VALUES (42,12,2,'Related U of M Web Sites'); |
269 |
|
|
INSERT INTO infotype VALUES (43,2,5,'Security Analysts\' Reports'); |
270 |
|
|
INSERT INTO infotype VALUES (44,2,5,'Doing Business in Another Country'); |
271 |
|
|
INSERT INTO infotype VALUES (45,2,5,'Financial Ratios'); |
272 |
|
|
INSERT INTO infotype VALUES (46,2,5,'Industry Profiles'); |
273 |
|
|
INSERT INTO infotype VALUES (47,2,5,'Market Research Surveys'); |
274 |
|
|
INSERT INTO infotype VALUES (48,2,5,'Tax Reporters'); |
275 |
|
|
INSERT INTO infotype VALUES (49,2,5,'Financial Reports'); |
276 |
|
|
INSERT INTO infotype VALUES (50,2,5,'Accounting Standards'); |
277 |
|
|
INSERT INTO infotype VALUES (51,2,5,'Nonprofit Finance'); |
278 |
|
|
INSERT INTO infotype VALUES (52,2,5,'Nonprofit Management'); |
279 |
|
|
INSERT INTO infotype VALUES (53,2,5,'Nonprofit Marketing'); |
280 |
|
|
INSERT INTO infotype VALUES (54,2,5,'Leadership History'); |
281 |
|
|
INSERT INTO infotype VALUES (55,2,5,'Leadership Landscapes, strategies and structures'); |
282 |
|
|
INSERT INTO infotype VALUES (56,2,5,'Books by and about Leaders'); |
283 |
|
|
INSERT INTO infotype VALUES (57,2,6,'Spectra'); |
284 |
|
|
INSERT INTO infotype VALUES (58,2,6,'Spectra, Atomic'); |
285 |
|
|
INSERT INTO infotype VALUES (59,2,6,'Spectra, General'); |
286 |
|
|
INSERT INTO infotype VALUES (60,2,6,'Spectra, Infrared'); |
287 |
|
|
INSERT INTO infotype VALUES (61,2,6,'Spectra, Mass'); |
288 |
|
|
INSERT INTO infotype VALUES (62,2,6,'Spectra, Nuclear Magnetic Resonance'); |
289 |
|
|
INSERT INTO infotype VALUES (63,2,6,'Spectra, Raman'); |
290 |
|
|
INSERT INTO infotype VALUES (64,2,6,'Spectra, Ultraviolet & Visible'); |
291 |
|
|
INSERT INTO infotype VALUES (65,2,6,'Chemical Compounds'); |
292 |
|
|
INSERT INTO infotype VALUES (66,2,6,'Data Compilations/Algorithms'); |
293 |
|
|
INSERT INTO infotype VALUES (67,2,6,'Organic Reactions'); |
294 |
|
|
INSERT INTO infotype VALUES (68,2,6,'Organic Synthesis'); |
295 |
|
|
INSERT INTO infotype VALUES (69,2,6,'Physical Property Data'); |
296 |
|
|
INSERT INTO infotype VALUES (70,2,8,'Federal Law - Administrative Law'); |
297 |
|
|
INSERT INTO infotype VALUES (71,2,8,'Minnesota Law - Constitution, Statutes and Codes'); |
298 |
|
|
INSERT INTO infotype VALUES (72,2,8,'Courts'); |
299 |
|
|
INSERT INTO infotype VALUES (73,2,8,'Attorneys and Law Firms'); |
300 |
|
|
INSERT INTO infotype VALUES (74,2,8,'Minnesota Law - Administrative Law'); |
301 |
|
|
INSERT INTO infotype VALUES (75,2,8,'Minnesota Law - Case Law'); |
302 |
|
|
INSERT INTO infotype VALUES (76,2,8,'Law Schools'); |
303 |
|
|
INSERT INTO infotype VALUES (77,2,8,'Federal Law - Case Law - U.S. Supreme Court'); |
304 |
|
|
INSERT INTO infotype VALUES (78,2,8,'Federal Law - Case Law - U.S. Court of Appeals'); |
305 |
|
|
INSERT INTO infotype VALUES (79,2,8,'Federal Law - Case Law - U.S. District Courts'); |
306 |
|
|
INSERT INTO infotype VALUES (80,2,8,'Laws and Legislation'); |
307 |
|
|
INSERT INTO infotype VALUES (81,2,8,'Official Journal of Legislative Activity'); |
308 |
|
|
INSERT INTO infotype VALUES (82,2,8,'Unofficial Journal of Legislative Activity'); |
309 |
|
|
INSERT INTO infotype VALUES (83,2,8,'Legislative Debates'); |
310 |
|
|
INSERT INTO infotype VALUES (84,2,8,'Federal Law - Constitution, Statutes and Codes'); |
311 |
|
|
INSERT INTO infotype VALUES (85,2,2,'Country Studies'); |
312 |
|
|
INSERT INTO infotype VALUES (130,11,2,'Electronic Texts'); |
313 |
|
|
INSERT INTO infotype VALUES (87,11,2,'Official Agency and Organization Web Sites'); |
314 |
|
|
INSERT INTO infotype VALUES (88,11,2,'Internet Directory'); |
315 |
|
|
INSERT INTO infotype VALUES (105,1,6,'Astronomical Objects'); |
316 |
|
|
INSERT INTO infotype VALUES (124,10,2,'Writing Guides'); |
317 |
|
|
INSERT INTO infotype VALUES (125,2,6,'Safety Information'); |
318 |
|
|
INSERT INTO infotype VALUES (126,6,2,'Electronic Journal Collections'); |
319 |
|
|
INSERT INTO infotype VALUES (127,8,2,'Image Resources'); |
320 |
|
|
INSERT INTO infotype VALUES (128,2,2,'Conferences and Proceedings'); |
321 |
|
|
INSERT INTO infotype VALUES (129,10,2,'Style Manuals'); |
322 |
|
|
INSERT INTO infotype VALUES (131,2,2,'Standards'); |
323 |
|
|
INSERT INTO infotype VALUES (132,2,6,'Analytical Techniques'); |
324 |
|
|
INSERT INTO infotype VALUES (133,2,6,'Chemical Prices'); |
325 |
|
|
INSERT INTO infotype VALUES (134,2,2,'Treatises'); |
326 |
|
|
INSERT INTO infotype VALUES (135,2,2,'Rankings'); |
327 |
|
|
INSERT INTO infotype VALUES (136,2,2,'Technical Reports'); |
328 |
|
|
INSERT INTO infotype VALUES (137,5,2,'Historical Documents'); |
329 |
|
|
INSERT INTO infotype VALUES (138,13,2,'Web Sites'); |
330 |
|
|
INSERT INTO infotype VALUES (139,5,2,'Government Documents'); |
331 |
|
|
INSERT INTO infotype VALUES (140,5,2,'Archival Materials'); |
332 |
|
|
INSERT INTO infotype VALUES (143,2,2,'Dissertations and Theses'); |
333 |
|
|
INSERT INTO infotype VALUES (142,2,2,'Guides'); |
334 |
|
|
INSERT INTO infotype VALUES (147,13,2,'Library Web Sites'); |
335 |
|
|
INSERT INTO infotype VALUES (148,13,2,'Campus web site'); |
336 |
|
|
INSERT INTO infotype VALUES (149,6,2,'Electronic Journal Titles'); |
337 |
|
|
|
338 |
|
|
-- |
339 |
|
|
-- Table structure for table `libunit` |
340 |
|
|
-- |
341 |
|
|
|
342 |
|
|
CREATE TABLE libunit ( |
343 |
|
|
libunit_id mediumint(9) NOT NULL auto_increment, |
344 |
|
|
libunit varchar(100) default NULL, |
345 |
|
|
libunit_abbrev varchar(25) default NULL, |
346 |
|
|
head_staff_id mediumint(9) default NULL, |
347 |
|
|
PRIMARY KEY (libunit_id) |
348 |
|
|
) TYPE=MyISAM; |
349 |
|
|
|
350 |
|
|
-- |
351 |
|
|
-- Dumping data for table `libunit` |
352 |
|
|
-- |
353 |
|
|
|
354 |
|
|
|
355 |
|
|
INSERT INTO libunit VALUES (1,'(N/A)','(N/A)',NULL); |
356 |
|
|
|
357 |
|
|
-- |
358 |
|
|
-- Table structure for table `libunit_staff` |
359 |
|
|
-- |
360 |
|
|
|
361 |
|
|
CREATE TABLE libunit_staff ( |
362 |
|
|
libunit_id mediumint(9) NOT NULL default '0', |
363 |
|
|
staff_id mediumint(9) NOT NULL default '0', |
364 |
|
|
PRIMARY KEY (libunit_id,staff_id) |
365 |
|
|
) TYPE=MyISAM; |
366 |
|
|
|
367 |
|
|
-- |
368 |
|
|
-- Dumping data for table `libunit_staff` |
369 |
|
|
-- |
370 |
|
|
|
371 |
|
|
|
372 |
|
|
|
373 |
|
|
-- |
374 |
|
|
-- Table structure for table `location` |
375 |
|
|
-- |
376 |
|
|
|
377 |
|
|
CREATE TABLE location ( |
378 |
|
|
location_id mediumint(9) NOT NULL auto_increment, |
379 |
|
|
location varchar(255) default NULL, |
380 |
|
|
location_descr text, |
381 |
|
|
campus varchar(255) default NULL, |
382 |
|
|
address1 varchar(255) default NULL, |
383 |
|
|
address2 varchar(255) default NULL, |
384 |
|
|
address3 varchar(255) default NULL, |
385 |
|
|
address4 varchar(255) default NULL, |
386 |
|
|
telephone varchar(100) default NULL, |
387 |
|
|
mainURL varchar(255) default NULL, |
388 |
|
|
referenceURL varchar(255) default NULL, |
389 |
|
|
mapURL varchar(255) default NULL, |
390 |
|
|
hoursURL varchar(255) default NULL, |
391 |
|
|
PRIMARY KEY (location_id) |
392 |
|
|
) TYPE=MyISAM; |
393 |
|
|
|
394 |
|
|
-- |
395 |
|
|
-- Dumping data for table `location` |
396 |
|
|
-- |
397 |
|
|
|
398 |
|
|
|
399 |
|
|
INSERT INTO location VALUES (1,'(N/A)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); |
400 |
|
|
INSERT INTO location VALUES (55,'Virtual Web Library','Resources here are all freely available on the internet.','','','','','','','','','',''); |
401 |
|
|
INSERT INTO location VALUES (58,'Smith Library','State of the art facility with over 120 million print volumes, climate controlled with super computers for public use.','','','','','','','http://www.google.com','','',''); |
402 |
|
|
|
403 |
|
|
-- |
404 |
|
|
-- Table structure for table `masterinfotype` |
405 |
|
|
-- |
406 |
|
|
|
407 |
|
|
CREATE TABLE masterinfotype ( |
408 |
|
|
masterinfotype_id mediumint(9) NOT NULL auto_increment, |
409 |
|
|
masterinfotype varchar(75) NOT NULL default '', |
410 |
|
|
PRIMARY KEY (masterinfotype_id) |
411 |
|
|
) TYPE=MyISAM; |
412 |
|
|
|
413 |
|
|
-- |
414 |
|
|
-- Dumping data for table `masterinfotype` |
415 |
|
|
-- |
416 |
|
|
|
417 |
|
|
|
418 |
|
|
INSERT INTO masterinfotype VALUES (1,'(N/A)'); |
419 |
|
|
INSERT INTO masterinfotype VALUES (2,'General Reference Sources'); |
420 |
|
|
INSERT INTO masterinfotype VALUES (3,'Abstracts and Indexes'); |
421 |
|
|
INSERT INTO masterinfotype VALUES (4,'Catalogs and Bibliographies'); |
422 |
|
|
INSERT INTO masterinfotype VALUES (5,'Primary Source Materials'); |
423 |
|
|
INSERT INTO masterinfotype VALUES (6,'Periodical and Newspaper subscriptions'); |
424 |
|
|
INSERT INTO masterinfotype VALUES (7,'Statistics and Data'); |
425 |
|
|
INSERT INTO masterinfotype VALUES (8,'Images Collections'); |
426 |
|
|
INSERT INTO masterinfotype VALUES (9,'Societies, Agencies, and Organizations'); |
427 |
|
|
INSERT INTO masterinfotype VALUES (10,'Style Manuals and Writing Guides'); |
428 |
|
|
INSERT INTO masterinfotype VALUES (11,'Internet Resources'); |
429 |
|
|
INSERT INTO masterinfotype VALUES (12,'University of Minnesota'); |
430 |
|
|
INSERT INTO masterinfotype VALUES (13,'WWW Resources'); |
431 |
|
|
|
432 |
|
|
-- |
433 |
|
|
-- Table structure for table `mastersubject` |
434 |
|
|
-- |
435 |
|
|
|
436 |
|
|
CREATE TABLE mastersubject ( |
437 |
|
|
mastersubject_id mediumint(9) NOT NULL auto_increment, |
438 |
|
|
mastersubject varchar(50) NOT NULL default '', |
439 |
|
|
PRIMARY KEY (mastersubject_id) |
440 |
|
|
) TYPE=MyISAM; |
441 |
|
|
|
442 |
|
|
-- |
443 |
|
|
-- Dumping data for table `mastersubject` |
444 |
|
|
-- |
445 |
|
|
|
446 |
|
|
|
447 |
|
|
INSERT INTO mastersubject VALUES (1,'(N/A)'); |
448 |
|
|
INSERT INTO mastersubject VALUES (2,'(All)'); |
449 |
|
|
INSERT INTO mastersubject VALUES (3,'Agriculture, Biology, Ecology'); |
450 |
|
|
INSERT INTO mastersubject VALUES (4,'Arts & Humanities'); |
451 |
|
|
INSERT INTO mastersubject VALUES (5,'Business and Economics'); |
452 |
|
|
INSERT INTO mastersubject VALUES (6,'Engineering, Mathematics & Physical Sciences'); |
453 |
|
|
INSERT INTO mastersubject VALUES (7,'Health and Medicine'); |
454 |
|
|
INSERT INTO mastersubject VALUES (8,'Law'); |
455 |
|
|
INSERT INTO mastersubject VALUES (9,'Social Sciences'); |
456 |
|
|
INSERT INTO mastersubject VALUES (10,'General'); |
457 |
|
|
|
458 |
|
|
-- |
459 |
|
|
-- Table structure for table `page` |
460 |
|
|
-- |
461 |
|
|
|
462 |
|
|
CREATE TABLE page ( |
463 |
|
|
page_id mediumint(9) NOT NULL auto_increment, |
464 |
|
|
date_created datetime default NULL, |
465 |
|
|
date_modified datetime default NULL, |
466 |
|
|
account_created varchar(20) default NULL, |
467 |
|
|
account_modified varchar(20) default NULL, |
468 |
|
|
staff_coordinator mediumint(9) default NULL, |
469 |
|
|
style_id mediumint(9) default NULL, |
470 |
|
|
pagetype_id mediumint(9) default NULL, |
471 |
|
|
page_title varchar(255) default NULL, |
472 |
|
|
pagetitle_style smallint(6) default NULL, |
473 |
|
|
published char(1) default NULL, |
474 |
|
|
display_urls char(1) default NULL, |
475 |
|
|
display_toc char(1) default NULL, |
476 |
|
|
wrap_toc char(1) default NULL, |
477 |
|
|
display_up char(1) default NULL, |
478 |
|
|
up_text varchar(50) default NULL, |
479 |
|
|
pageheader mediumtext, |
480 |
|
|
pageHTML mediumtext, |
481 |
|
|
page_debug char(1) default NULL, |
482 |
|
|
PRIMARY KEY (page_id) |
483 |
|
|
) TYPE=MyISAM; |
484 |
|
|
|
485 |
|
|
-- |
486 |
|
|
-- Dumping data for 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); |
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); |
492 |
|
|
|
493 |
|
|
-- |
494 |
|
|
-- Table structure for table `page_staff` |
495 |
|
|
-- |
496 |
|
|
|
497 |
|
|
CREATE TABLE page_staff ( |
498 |
|
|
page_id mediumint(9) NOT NULL default '0', |
499 |
|
|
staff_id mediumint(9) NOT NULL default '0', |
500 |
|
|
PRIMARY KEY (page_id,staff_id) |
501 |
|
|
) TYPE=MyISAM; |
502 |
|
|
|
503 |
|
|
-- |
504 |
|
|
-- Dumping data for table `page_staff` |
505 |
|
|
-- |
506 |
|
|
|
507 |
|
|
|
508 |
|
|
|
509 |
|
|
-- |
510 |
|
|
-- Table structure for table `pagetype` |
511 |
|
|
-- |
512 |
|
|
|
513 |
|
|
CREATE TABLE pagetype ( |
514 |
|
|
pagetype_id mediumint(9) NOT NULL auto_increment, |
515 |
|
|
pagetype varchar(50) default NULL, |
516 |
|
|
PRIMARY KEY (pagetype_id) |
517 |
|
|
) TYPE=MyISAM; |
518 |
|
|
|
519 |
|
|
-- |
520 |
|
|
-- Dumping data for table `pagetype` |
521 |
|
|
-- |
522 |
|
|
|
523 |
|
|
|
524 |
|
|
INSERT INTO pagetype VALUES (1,'(N/A)'); |
525 |
|
|
INSERT INTO pagetype VALUES (2,'Free Form'); |
526 |
|
|
INSERT INTO pagetype VALUES (3,'CourseLib'); |
527 |
|
|
|
528 |
|
|
-- |
529 |
|
|
-- Table structure for table `pastebuffer` |
530 |
|
|
-- |
531 |
|
|
|
532 |
|
|
CREATE TABLE pastebuffer ( |
533 |
|
|
pastebuffer_id mediumint(9) NOT NULL auto_increment, |
534 |
|
|
paste_staff_id mediumint(9) NOT NULL default '0', |
535 |
|
|
parent_id mediumint(9) default NULL, |
536 |
|
|
resource_id mediumint(9) default NULL, |
537 |
|
|
location_id mediumint(9) default NULL, |
538 |
|
|
service_id mediumint(9) default NULL, |
539 |
|
|
staff_id mediumint(9) default NULL, |
540 |
|
|
subject_id mediumint(9) default NULL, |
541 |
|
|
label varchar(200) default NULL, |
542 |
|
|
label_url varchar(200) default NULL, |
543 |
|
|
element_descr text, |
544 |
|
|
element_size smallint(6) default NULL, |
545 |
|
|
element_order smallint(6) default NULL, |
546 |
|
|
indent_level smallint(6) default NULL, |
547 |
|
|
PRIMARY KEY (pastebuffer_id) |
548 |
|
|
) TYPE=MyISAM; |
549 |
|
|
|
550 |
|
|
-- |
551 |
|
|
-- Dumping data for table `pastebuffer` |
552 |
|
|
-- |
553 |
|
|
|
554 |
|
|
|
555 |
|
|
|
556 |
|
|
-- |
557 |
|
|
-- Table structure for table `res_feature` |
558 |
|
|
-- |
559 |
|
|
|
560 |
|
|
CREATE TABLE res_feature ( |
561 |
|
|
resource_id mediumint(9) NOT NULL default '0', |
562 |
|
|
feature_id mediumint(9) NOT NULL default '0', |
563 |
|
|
PRIMARY KEY (resource_id,feature_id) |
564 |
|
|
) TYPE=MyISAM; |
565 |
|
|
|
566 |
|
|
-- |
567 |
|
|
-- Dumping data for table `res_feature` |
568 |
|
|
-- |
569 |
|
|
|
570 |
|
|
|
571 |
|
|
INSERT INTO res_feature VALUES (11,3); |
572 |
|
|
INSERT INTO res_feature VALUES (14,2); |
573 |
|
|
INSERT INTO res_feature VALUES (14,5); |
574 |
|
|
|
575 |
|
|
-- |
576 |
|
|
-- Table structure for table `res_loc` |
577 |
|
|
-- |
578 |
|
|
|
579 |
|
|
CREATE TABLE res_loc ( |
580 |
|
|
resource_id mediumint(9) NOT NULL default '0', |
581 |
|
|
location_id mediumint(9) NOT NULL default '0', |
582 |
|
|
PRIMARY KEY (resource_id,location_id) |
583 |
|
|
) TYPE=MyISAM; |
584 |
|
|
|
585 |
|
|
-- |
586 |
|
|
-- Dumping data for table `res_loc` |
587 |
|
|
-- |
588 |
|
|
|
589 |
|
|
|
590 |
|
|
INSERT INTO res_loc VALUES (2,55); |
591 |
|
|
INSERT INTO res_loc VALUES (3,55); |
592 |
|
|
INSERT INTO res_loc VALUES (11,55); |
593 |
|
|
INSERT INTO res_loc VALUES (12,55); |
594 |
|
|
INSERT INTO res_loc VALUES (13,55); |
595 |
|
|
|
596 |
|
|
-- |
597 |
|
|
-- Table structure for table `res_mastersubject` |
598 |
|
|
-- |
599 |
|
|
|
600 |
|
|
CREATE TABLE res_mastersubject ( |
601 |
|
|
resource_id mediumint(9) NOT NULL default '0', |
602 |
|
|
mastersubject_id mediumint(9) NOT NULL default '0', |
603 |
|
|
PRIMARY KEY (resource_id,mastersubject_id) |
604 |
|
|
) TYPE=MyISAM; |
605 |
|
|
|
606 |
|
|
-- |
607 |
|
|
-- Dumping data for table `res_mastersubject` |
608 |
|
|
-- |
609 |
|
|
|
610 |
|
|
|
611 |
|
|
INSERT INTO res_mastersubject VALUES (1,10); |
612 |
|
|
INSERT INTO res_mastersubject VALUES (2,6); |
613 |
|
|
INSERT INTO res_mastersubject VALUES (3,6); |
614 |
|
|
INSERT INTO res_mastersubject VALUES (4,6); |
615 |
|
|
INSERT INTO res_mastersubject VALUES (11,6); |
616 |
|
|
INSERT INTO res_mastersubject VALUES (12,6); |
617 |
|
|
INSERT INTO res_mastersubject VALUES (13,6); |
618 |
|
|
INSERT INTO res_mastersubject VALUES (14,6); |
619 |
|
|
|
620 |
|
|
-- |
621 |
|
|
-- Table structure for table `res_sub_infotype` |
622 |
|
|
-- |
623 |
|
|
|
624 |
|
|
CREATE TABLE res_sub_infotype ( |
625 |
|
|
resource_id mediumint(9) NOT NULL default '0', |
626 |
|
|
subject_id mediumint(9) NOT NULL default '0', |
627 |
|
|
infotype_id mediumint(9) NOT NULL default '0', |
628 |
|
|
highlighted char(1) default NULL, |
629 |
|
|
description text, |
630 |
|
|
masterinfotype_id mediumint(9) NOT NULL default '0' |
631 |
|
|
) TYPE=MyISAM; |
632 |
|
|
|
633 |
|
|
-- |
634 |
|
|
-- Dumping data for table `res_sub_infotype` |
635 |
|
|
-- |
636 |
|
|
|
637 |
|
|
|
638 |
|
|
INSERT INTO res_sub_infotype VALUES (2,2,138,'1','',13); |
639 |
|
|
INSERT INTO res_sub_infotype VALUES (4,2,138,'0',NULL,13); |
640 |
|
|
INSERT INTO res_sub_infotype VALUES (3,2,87,'0','',11); |
641 |
|
|
INSERT INTO res_sub_infotype VALUES (11,2,138,'0',NULL,13); |
642 |
|
|
INSERT INTO res_sub_infotype VALUES (13,2,87,'0',NULL,11); |
643 |
|
|
INSERT INTO res_sub_infotype VALUES (14,2,40,'0','',11); |
644 |
|
|
INSERT INTO res_sub_infotype VALUES (13,3,87,'0','',11); |
645 |
|
|
|
646 |
|
|
-- |
647 |
|
|
-- Table structure for table `resource` |
648 |
|
|
-- |
649 |
|
|
|
650 |
|
|
CREATE TABLE resource ( |
651 |
|
|
resource_id mediumint(9) NOT NULL auto_increment, |
652 |
|
|
date_created datetime default NULL, |
653 |
|
|
date_modified datetime default NULL, |
654 |
|
|
account_created varchar(20) default NULL, |
655 |
|
|
account_modified varchar(20) default NULL, |
656 |
|
|
title varchar(255) default NULL, |
657 |
|
|
other_title text, |
658 |
|
|
author varchar(125) default NULL, |
659 |
|
|
publisher varchar(255) default NULL, |
660 |
|
|
pub_date varchar(255) default NULL, |
661 |
|
|
edition varchar(25) default NULL, |
662 |
|
|
cat_num varchar(50) default NULL, |
663 |
|
|
call_no text, |
664 |
|
|
coverage_detail varchar(255) default NULL, |
665 |
|
|
sources_indexed varchar(100) default NULL, |
666 |
|
|
url text, |
667 |
|
|
visited varchar(25) default NULL, |
668 |
|
|
annotation text, |
669 |
|
|
location_id mediumint(9) default NULL, |
670 |
|
|
infotype_id mediumint(9) default NULL, |
671 |
|
|
vendor_id mediumint(9) default NULL, |
672 |
|
|
PRIMARY KEY (resource_id) |
673 |
|
|
) TYPE=MyISAM; |
674 |
|
|
|
675 |
|
|
-- |
676 |
|
|
-- Dumping data for table `resource` |
677 |
|
|
-- |
678 |
|
|
|
679 |
|
|
|
680 |
|
|
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); |
681 |
|
|
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); |
682 |
|
|
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); |
683 |
|
|
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); |
684 |
|
|
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); |
685 |
|
|
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); |
686 |
|
|
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); |
687 |
|
|
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); |
688 |
|
|
|
689 |
|
|
-- |
690 |
|
|
-- Table structure for table `serv_loc` |
691 |
|
|
-- |
692 |
|
|
|
693 |
|
|
CREATE TABLE serv_loc ( |
694 |
|
|
service_id mediumint(9) NOT NULL default '0', |
695 |
|
|
location_id mediumint(9) NOT NULL default '0', |
696 |
|
|
allloc char(1) default NULL, |
697 |
|
|
PRIMARY KEY (service_id,location_id) |
698 |
|
|
) TYPE=MyISAM; |
699 |
|
|
|
700 |
|
|
-- |
701 |
|
|
-- Dumping data for table `serv_loc` |
702 |
|
|
-- |
703 |
|
|
|
704 |
|
|
|
705 |
|
|
|
706 |
|
|
-- |
707 |
|
|
-- Table structure for table `serv_servtype` |
708 |
|
|
-- |
709 |
|
|
|
710 |
|
|
CREATE TABLE serv_servtype ( |
711 |
|
|
service_id mediumint(9) NOT NULL default '0', |
712 |
|
|
servicetype_id mediumint(9) NOT NULL default '0', |
713 |
|
|
PRIMARY KEY (service_id,servicetype_id) |
714 |
|
|
) TYPE=MyISAM; |
715 |
|
|
|
716 |
|
|
-- |
717 |
|
|
-- Dumping data for table `serv_servtype` |
718 |
|
|
-- |
719 |
|
|
|
720 |
|
|
|
721 |
|
|
|
722 |
|
|
-- |
723 |
|
|
-- Table structure for table `service` |
724 |
|
|
-- |
725 |
|
|
|
726 |
|
|
CREATE TABLE service ( |
727 |
|
|
service_id mediumint(9) NOT NULL auto_increment, |
728 |
|
|
service varchar(100) default NULL, |
729 |
|
|
serviceURL varchar(150) default NULL, |
730 |
|
|
serviceDescr text, |
731 |
|
|
address1 varchar(50) default NULL, |
732 |
|
|
address2 varchar(50) default NULL, |
733 |
|
|
address3 varchar(50) default NULL, |
734 |
|
|
address4 varchar(50) default NULL, |
735 |
|
|
telephone varchar(20) default NULL, |
736 |
|
|
fax varchar(20) default NULL, |
737 |
|
|
email varchar(40) default NULL, |
738 |
|
|
nonaff char(1) default NULL, |
739 |
|
|
PRIMARY KEY (service_id) |
740 |
|
|
) TYPE=MyISAM; |
741 |
|
|
|
742 |
|
|
-- |
743 |
|
|
-- Dumping data for table `service` |
744 |
|
|
-- |
745 |
|
|
|
746 |
|
|
|
747 |
|
|
INSERT INTO service VALUES (1,'(N/A)','','','','','','','','','','0'); |
748 |
|
|
|
749 |
|
|
-- |
750 |
|
|
-- Table structure for table `servicetype` |
751 |
|
|
-- |
752 |
|
|
|
753 |
|
|
CREATE TABLE servicetype ( |
754 |
|
|
servicetype_id mediumint(9) NOT NULL auto_increment, |
755 |
|
|
servicetype varchar(75) default NULL, |
756 |
|
|
PRIMARY KEY (servicetype_id) |
757 |
|
|
) TYPE=MyISAM; |
758 |
|
|
|
759 |
|
|
-- |
760 |
|
|
-- Dumping data for table `servicetype` |
761 |
|
|
-- |
762 |
|
|
|
763 |
|
|
|
764 |
|
|
INSERT INTO servicetype VALUES (1,'(N/A)'); |
765 |
|
|
|
766 |
|
|
-- |
767 |
|
|
-- Table structure for table `staff` |
768 |
|
|
-- |
769 |
|
|
|
770 |
|
|
CREATE TABLE staff ( |
771 |
|
|
staff_id mediumint(9) NOT NULL auto_increment, |
772 |
|
|
staff_account varchar(20) default NULL, |
773 |
|
|
staff_email varchar(50) default NULL, |
774 |
|
|
password varchar(16) default NULL, |
775 |
|
|
last_name varchar(75) default NULL, |
776 |
|
|
first_name varchar(75) default NULL, |
777 |
|
|
last_login datetime default NULL, |
778 |
|
|
last_ip varchar(15) default NULL, |
779 |
|
|
date_created datetime default NULL, |
780 |
|
|
date_modified datetime default NULL, |
781 |
|
|
access_id mediumint(9) default NULL, |
782 |
|
|
stafftitle_id mediumint(9) default NULL, |
783 |
|
|
PRIMARY KEY (staff_id) |
784 |
|
|
) TYPE=MyISAM; |
785 |
|
|
|
786 |
|
|
-- |
787 |
|
|
-- Dumping data for table `staff` |
788 |
|
|
-- |
789 |
|
|
|
790 |
|
|
|
791 |
|
|
INSERT INTO staff VALUES (1,'(N/A)','(N/A)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL); |
792 |
|
|
INSERT INTO staff VALUES (2,'admin','admin@yourlibrary.edu',password('libd4t4'), |
793 |
|
|
'Administrator','System',NULL,NULL, NULL,NULL,5,3); |
794 |
|
|
|
795 |
|
|
-- |
796 |
|
|
-- Table structure for table `stafftitle` |
797 |
|
|
-- |
798 |
|
|
|
799 |
|
|
CREATE TABLE stafftitle ( |
800 |
|
|
stafftitle_id mediumint(9) NOT NULL auto_increment, |
801 |
|
|
stafftitle varchar(50) default NULL, |
802 |
|
|
PRIMARY KEY (stafftitle_id) |
803 |
|
|
) TYPE=MyISAM; |
804 |
|
|
|
805 |
|
|
-- |
806 |
|
|
-- Dumping data for table `stafftitle` |
807 |
|
|
-- |
808 |
|
|
|
809 |
|
|
|
810 |
|
|
INSERT INTO stafftitle VALUES (1,'(N/A)'); |
811 |
|
|
INSERT INTO stafftitle VALUES (2,'Web Applications Developer'); |
812 |
|
|
INSERT INTO stafftitle VALUES (3,'Info Tech Prof'); |
813 |
|
|
INSERT INTO stafftitle VALUES (4,'Librarian'); |
814 |
|
|
INSERT INTO stafftitle VALUES (5,'Faculty'); |
815 |
|
|
INSERT INTO stafftitle VALUES (6,'Professor'); |
816 |
|
|
INSERT INTO stafftitle VALUES (7,'Assistant Professor'); |
817 |
|
|
INSERT INTO stafftitle VALUES (8,'Associate Professor'); |
818 |
|
|
INSERT INTO stafftitle VALUES (16,'Instructor'); |
819 |
|
|
INSERT INTO stafftitle VALUES (17,'TA'); |
820 |
|
|
|
821 |
|
|
-- |
822 |
|
|
-- Table structure for table `style` |
823 |
|
|
-- |
824 |
|
|
|
825 |
|
|
CREATE TABLE style ( |
826 |
|
|
style_id mediumint(9) NOT NULL auto_increment, |
827 |
|
|
style_title varchar(100) default NULL, |
828 |
|
|
header_file varchar(255) default NULL, |
829 |
|
|
footer_file varchar(255) default NULL, |
830 |
|
|
css_file varchar(255) default NULL, |
831 |
|
|
PRIMARY KEY (style_id) |
832 |
|
|
) TYPE=MyISAM; |
833 |
|
|
|
834 |
|
|
-- |
835 |
|
|
-- Dumping data for table `style` |
836 |
|
|
-- |
837 |
|
|
|
838 |
|
|
|
839 |
|
|
INSERT INTO style VALUES (1,'(N/A)',NULL,NULL,NULL); |
840 |
|
|
INSERT INTO style VALUES (2,'LibData Standard','header.phtml','footer.phtml','libdata.css'); |
841 |
|
|
INSERT INTO style VALUES (10,'LibData Inverse Demo','styles/libinverse/header.phtml','styles/libinverse/footer.phtml','styles/libinverse/libdata.css'); |
842 |
|
|
|
843 |
|
|
-- |
844 |
|
|
-- Table structure for table `sub_coursesub` |
845 |
|
|
-- |
846 |
|
|
|
847 |
|
|
CREATE TABLE sub_coursesub ( |
848 |
|
|
subject_id mediumint(9) NOT NULL default '0', |
849 |
|
|
coursesub_id mediumint(9) NOT NULL default '0', |
850 |
|
|
PRIMARY KEY (subject_id,coursesub_id) |
851 |
|
|
) TYPE=MyISAM; |
852 |
|
|
|
853 |
|
|
-- |
854 |
|
|
-- Dumping data for table `sub_coursesub` |
855 |
|
|
-- |
856 |
|
|
|
857 |
|
|
|
858 |
|
|
|
859 |
|
|
-- |
860 |
|
|
-- Table structure for table `sub_loc` |
861 |
|
|
-- |
862 |
|
|
|
863 |
|
|
CREATE TABLE sub_loc ( |
864 |
|
|
subject_id mediumint(9) NOT NULL default '0', |
865 |
|
|
location_id mediumint(9) NOT NULL default '0', |
866 |
|
|
PRIMARY KEY (subject_id,location_id) |
867 |
|
|
) TYPE=MyISAM; |
868 |
|
|
|
869 |
|
|
-- |
870 |
|
|
-- Dumping data for table `sub_loc` |
871 |
|
|
-- |
872 |
|
|
|
873 |
|
|
|
874 |
|
|
INSERT INTO sub_loc VALUES (2,55); |
875 |
|
|
|
876 |
|
|
-- |
877 |
|
|
-- Table structure for table `sub_mastersubject` |
878 |
|
|
-- |
879 |
|
|
|
880 |
|
|
CREATE TABLE sub_mastersubject ( |
881 |
|
|
subject_id mediumint(9) NOT NULL default '0', |
882 |
|
|
mastersubject_id mediumint(9) NOT NULL default '0', |
883 |
|
|
PRIMARY KEY (subject_id,mastersubject_id) |
884 |
|
|
) TYPE=MyISAM; |
885 |
|
|
|
886 |
|
|
-- |
887 |
|
|
-- Dumping data for table `sub_mastersubject` |
888 |
|
|
-- |
889 |
|
|
|
890 |
|
|
|
891 |
|
|
INSERT INTO sub_mastersubject VALUES (2,6); |
892 |
|
|
INSERT INTO sub_mastersubject VALUES (3,6); |
893 |
|
|
|
894 |
|
|
-- |
895 |
|
|
-- Table structure for table `sub_othersub` |
896 |
|
|
-- |
897 |
|
|
|
898 |
|
|
CREATE TABLE sub_othersub ( |
899 |
|
|
subject_id mediumint(9) NOT NULL default '0', |
900 |
|
|
othersub_id mediumint(9) NOT NULL default '0', |
901 |
|
|
PRIMARY KEY (subject_id,othersub_id) |
902 |
|
|
) TYPE=MyISAM; |
903 |
|
|
|
904 |
|
|
-- |
905 |
|
|
-- Dumping data for table `sub_othersub` |
906 |
|
|
-- |
907 |
|
|
|
908 |
|
|
|
909 |
|
|
INSERT INTO sub_othersub VALUES (2,3); |
910 |
|
|
|
911 |
|
|
-- |
912 |
|
|
-- Table structure for table `sub_page` |
913 |
|
|
-- |
914 |
|
|
|
915 |
|
|
CREATE TABLE sub_page ( |
916 |
|
|
subject_id mediumint(9) NOT NULL default '0', |
917 |
|
|
page_id mediumint(9) NOT NULL default '0', |
918 |
|
|
PRIMARY KEY (subject_id,page_id) |
919 |
|
|
) TYPE=MyISAM; |
920 |
|
|
|
921 |
|
|
-- |
922 |
|
|
-- Dumping data for table `sub_page` |
923 |
|
|
-- |
924 |
|
|
|
925 |
|
|
|
926 |
|
|
|
927 |
|
|
-- |
928 |
|
|
-- Table structure for table `sub_staff` |
929 |
|
|
-- |
930 |
|
|
|
931 |
|
|
CREATE TABLE sub_staff ( |
932 |
|
|
subject_id mediumint(9) NOT NULL default '0', |
933 |
|
|
staff_id mediumint(9) NOT NULL default '0', |
934 |
|
|
PRIMARY KEY (subject_id,staff_id) |
935 |
|
|
) TYPE=MyISAM; |
936 |
|
|
|
937 |
|
|
-- |
938 |
|
|
-- Dumping data for table `sub_staff` |
939 |
|
|
-- |
940 |
|
|
|
941 |
|
|
|
942 |
|
|
INSERT INTO sub_staff VALUES (2,2); |
943 |
|
|
INSERT INTO sub_staff VALUES (3,2); |
944 |
|
|
|
945 |
|
|
-- |
946 |
|
|
-- Table structure for table `subject` |
947 |
|
|
-- |
948 |
|
|
|
949 |
|
|
CREATE TABLE subject ( |
950 |
|
|
subject_id mediumint(9) NOT NULL auto_increment, |
951 |
|
|
subject varchar(75) NOT NULL default '', |
952 |
|
|
subject_descr text, |
953 |
|
|
sublocation_id mediumint(9) default NULL, |
954 |
|
|
rqs_date_created datetime default NULL, |
955 |
|
|
rqs_date_modified datetime default NULL, |
956 |
|
|
rqs_account_created varchar(20) default NULL, |
957 |
|
|
rqs_account_modified varchar(20) default NULL, |
958 |
|
|
rqs_published char(1) default NULL, |
959 |
|
|
PRIMARY KEY (subject_id) |
960 |
|
|
) TYPE=MyISAM; |
961 |
|
|
|
962 |
|
|
-- |
963 |
|
|
-- Dumping data for table `subject` |
964 |
|
|
-- |
965 |
|
|
|
966 |
|
|
|
967 |
|
|
INSERT INTO subject VALUES (1,'(N/A)',NULL,NULL,'2003-08-27 10:07:20','2003-08-27 10:07:50','staff','staff','1'); |
968 |
|
|
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'); |
969 |
|
|
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'); |
970 |
|
|
|
971 |
|
|
-- |
972 |
|
|
-- Table structure for table `term` |
973 |
|
|
-- |
974 |
|
|
|
975 |
|
|
CREATE TABLE term ( |
976 |
|
|
term_id mediumint(9) NOT NULL auto_increment, |
977 |
|
|
term varchar(150) default NULL, |
978 |
|
|
PRIMARY KEY (term_id) |
979 |
|
|
) TYPE=MyISAM; |
980 |
|
|
|
981 |
|
|
-- |
982 |
|
|
-- Dumping data for table `term` |
983 |
|
|
-- |
984 |
|
|
|
985 |
|
|
|
986 |
|
|
INSERT INTO term VALUES (1,'(N/A)'); |
987 |
|
|
INSERT INTO term VALUES (2,'Fall Semester'); |
988 |
|
|
INSERT INTO term VALUES (3,'Spring Semester'); |
989 |
|
|
INSERT INTO term VALUES (4,'Summer Term'); |
990 |
|
|
|