/[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

Contents of /branches/paul/admin/install/libdata.sql

Parent Directory Parent Directory | Revision Log Revision Log

Revision 67 - (show annotations)
Thu Mar 18 19:24:54 2004 UTC (20 years, 1 month ago) by dpavlin
File size: 33610 byte(s) 
updated to libdata 2.00
1 -- 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-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-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`
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 guide_url text,
668 visited varchar(25) default NULL,
669 annotation text,
670 location_id mediumint(9) default NULL,
671 infotype_id mediumint(9) default NULL,
672 vendor_id mediumint(9) default NULL,
673 resource_message text,
674 resource_status char(1) default NULL,
675 PRIMARY KEY (resource_id)
676 ) TYPE=MyISAM;
677
678 --
679 -- Dumping data for 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,'',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,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,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,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,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,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,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,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`
694 --
695
696 CREATE TABLE serv_loc (
697 service_id mediumint(9) NOT NULL default '0',
698 location_id mediumint(9) NOT NULL default '0',
699 allloc char(1) default NULL,
700 PRIMARY KEY (service_id,location_id)
701 ) TYPE=MyISAM;
702
703 --
704 -- Dumping data for table `serv_loc`
705 --
706
707
708
709 --
710 -- Table structure for table `serv_servtype`
711 --
712
713 CREATE TABLE serv_servtype (
714 service_id mediumint(9) NOT NULL default '0',
715 servicetype_id mediumint(9) NOT NULL default '0',
716 PRIMARY KEY (service_id,servicetype_id)
717 ) TYPE=MyISAM;
718
719 --
720 -- Dumping data for table `serv_servtype`
721 --
722
723
724
725 --
726 -- Table structure for table `service`
727 --
728
729 CREATE TABLE service (
730 service_id mediumint(9) NOT NULL auto_increment,
731 service varchar(100) default NULL,
732 serviceURL varchar(150) default NULL,
733 serviceDescr text,
734 address1 varchar(50) default NULL,
735 address2 varchar(50) default NULL,
736 address3 varchar(50) default NULL,
737 address4 varchar(50) default NULL,
738 telephone varchar(20) default NULL,
739 fax varchar(20) default NULL,
740 email varchar(40) default NULL,
741 nonaff char(1) default NULL,
742 PRIMARY KEY (service_id)
743 ) TYPE=MyISAM;
744
745 --
746 -- Dumping data for table `service`
747 --
748
749
750 INSERT INTO service VALUES (1,'(N/A)','','','','','','','','','','0');
751
752 --
753 -- Table structure for table `servicetype`
754 --
755
756 CREATE TABLE servicetype (
757 servicetype_id mediumint(9) NOT NULL auto_increment,
758 servicetype varchar(75) default NULL,
759 PRIMARY KEY (servicetype_id)
760 ) TYPE=MyISAM;
761
762 --
763 -- Dumping data for table `servicetype`
764 --
765
766
767 INSERT INTO servicetype VALUES (1,'(N/A)');
768
769 --
770 -- Table structure for table `staff`
771 --
772
773 CREATE TABLE staff (
774 staff_id mediumint(9) NOT NULL auto_increment,
775 staff_account varchar(20) default NULL,
776 staff_email varchar(50) default NULL,
777 password varchar(16) default NULL,
778 last_name varchar(75) default NULL,
779 first_name varchar(75) default NULL,
780 last_login datetime default NULL,
781 last_ip varchar(15) default NULL,
782 date_created datetime default NULL,
783 date_modified datetime default NULL,
784 access_id mediumint(9) default NULL,
785 stafftitle_id mediumint(9) default NULL,
786 PRIMARY KEY (staff_id)
787 ) TYPE=MyISAM;
788
789 --
790 -- Dumping data for table `staff`
791 --
792
793
794 INSERT INTO staff VALUES (1,'(N/A)','(N/A)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL);
795 INSERT INTO staff VALUES (2,'admin','admin@yourlibrary.edu',password('libd4t4'),
796 'Administrator','System',NULL,NULL, NULL,NULL,5,3);
797
798 --
799 -- Table structure for table `stafftitle`
800 --
801
802 CREATE TABLE stafftitle (
803 stafftitle_id mediumint(9) NOT NULL auto_increment,
804 stafftitle varchar(50) default NULL,
805 PRIMARY KEY (stafftitle_id)
806 ) TYPE=MyISAM;
807
808 --
809 -- Dumping data for table `stafftitle`
810 --
811
812
813 INSERT INTO stafftitle VALUES (1,'(N/A)');
814 INSERT INTO stafftitle VALUES (2,'Web Applications Developer');
815 INSERT INTO stafftitle VALUES (3,'Info Tech Prof');
816 INSERT INTO stafftitle VALUES (4,'Librarian');
817 INSERT INTO stafftitle VALUES (5,'Faculty');
818 INSERT INTO stafftitle VALUES (6,'Professor');
819 INSERT INTO stafftitle VALUES (7,'Assistant Professor');
820 INSERT INTO stafftitle VALUES (8,'Associate Professor');
821 INSERT INTO stafftitle VALUES (16,'Instructor');
822 INSERT INTO stafftitle VALUES (17,'TA');
823
824 --
825 -- Table structure for table `style`
826 --
827
828 CREATE TABLE style (
829 style_id mediumint(9) NOT NULL auto_increment,
830 style_title varchar(100) default NULL,
831 header_file varchar(255) default NULL,
832 footer_file varchar(255) default NULL,
833 css_file varchar(255) default NULL,
834 PRIMARY KEY (style_id)
835 ) TYPE=MyISAM;
836
837 --
838 -- Dumping data for table `style`
839 --
840
841
842 INSERT INTO style VALUES (1,'(N/A)',NULL,NULL,NULL);
843 INSERT INTO style VALUES (2,'LibData Standard','header.phtml','footer.phtml','libdata.css');
844 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`
848 --
849
850 CREATE TABLE sub_coursesub (
851 subject_id mediumint(9) NOT NULL default '0',
852 coursesub_id mediumint(9) NOT NULL default '0',
853 PRIMARY KEY (subject_id,coursesub_id)
854 ) TYPE=MyISAM;
855
856 --
857 -- Dumping data for table `sub_coursesub`
858 --
859
860
861
862 --
863 -- Table structure for table `sub_loc`
864 --
865
866 CREATE TABLE sub_loc (
867 subject_id mediumint(9) NOT NULL default '0',
868 location_id mediumint(9) NOT NULL default '0',
869 PRIMARY KEY (subject_id,location_id)
870 ) TYPE=MyISAM;
871
872 --
873 -- Dumping data for table `sub_loc`
874 --
875
876
877 INSERT INTO sub_loc VALUES (2,55);
878
879 --
880 -- Table structure for table `sub_mastersubject`
881 --
882
883 CREATE TABLE sub_mastersubject (
884 subject_id mediumint(9) NOT NULL default '0',
885 mastersubject_id mediumint(9) NOT NULL default '0',
886 PRIMARY KEY (subject_id,mastersubject_id)
887 ) TYPE=MyISAM;
888
889 --
890 -- Dumping data for table `sub_mastersubject`
891 --
892
893
894 INSERT INTO sub_mastersubject VALUES (2,6);
895 INSERT INTO sub_mastersubject VALUES (3,6);
896
897 --
898 -- Table structure for table `sub_othersub`
899 --
900
901 CREATE TABLE sub_othersub (
902 subject_id mediumint(9) NOT NULL default '0',
903 othersub_id mediumint(9) NOT NULL default '0',
904 PRIMARY KEY (subject_id,othersub_id)
905 ) TYPE=MyISAM;
906
907 --
908 -- Dumping data for table `sub_othersub`
909 --
910
911
912 INSERT INTO sub_othersub VALUES (2,3);
913
914 --
915 -- Table structure for table `sub_page`
916 --
917
918 CREATE TABLE sub_page (
919 subject_id mediumint(9) NOT NULL default '0',
920 page_id mediumint(9) NOT NULL default '0',
921 PRIMARY KEY (subject_id,page_id)
922 ) TYPE=MyISAM;
923
924 --
925 -- Dumping data for table `sub_page`
926 --
927
928
929
930 --
931 -- Table structure for table `sub_staff`
932 --
933
934 CREATE TABLE sub_staff (
935 subject_id mediumint(9) NOT NULL default '0',
936 staff_id mediumint(9) NOT NULL default '0',
937 PRIMARY KEY (subject_id,staff_id)
938 ) TYPE=MyISAM;
939
940 --
941 -- Dumping data for table `sub_staff`
942 --
943
944
945 INSERT INTO sub_staff VALUES (2,2);
946 INSERT INTO sub_staff VALUES (3,2);
947
948 --
949 -- Table structure for table `subject`
950 --
951
952 CREATE TABLE subject (
953 subject_id mediumint(9) NOT NULL auto_increment,
954 subject varchar(75) NOT NULL default '',
955 subject_descr text,
956 sublocation_id mediumint(9) default NULL,
957 rqs_date_created datetime default NULL,
958 rqs_date_modified datetime default NULL,
959 rqs_account_created varchar(20) default NULL,
960 rqs_account_modified varchar(20) default NULL,
961 rqs_published char(1) default NULL,
962 PRIMARY KEY (subject_id)
963 ) TYPE=MyISAM;
964
965 --
966 -- Dumping data for table `subject`
967 --
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');
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','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-30 13:10:59','admin','admin','1');
973
974 --
975 -- Table structure for table `term`
976 --
977
978 CREATE TABLE term (
979 term_id mediumint(9) NOT NULL auto_increment,
980 term varchar(150) default NULL,
981 PRIMARY KEY (term_id)
982 ) TYPE=MyISAM;
983
984 --
985 -- Dumping data for table `term`
986 --
987
988
989 INSERT INTO term VALUES (1,'(N/A)');
990 INSERT INTO term VALUES (2,'Fall Semester');
991 INSERT INTO term VALUES (3,'Spring Semester');
992 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
  ViewVC Help
Powered by ViewVC 1.1.26