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