Lines 1-1357
Link Here
|
1 |
# |
|
|
2 |
# Structure de la table `accountlines` |
3 |
# |
4 |
|
5 |
CREATE TABLE accountlines ( |
6 |
borrowernumber int(11) NOT NULL default '0', |
7 |
accountno smallint(6) NOT NULL default '0', |
8 |
itemnumber int(11) default NULL, |
9 |
date date default NULL, |
10 |
amount decimal(28,6) default NULL, |
11 |
description text, |
12 |
dispute text, |
13 |
accounttype varchar(5) default NULL, |
14 |
amountoutstanding decimal(28,6) default NULL, |
15 |
timestamp timestamp(14) NOT NULL, |
16 |
KEY acctsborridx (borrowernumber), |
17 |
KEY timeidx (timestamp) |
18 |
) TYPE=MyISAM; |
19 |
# -------------------------------------------------------- |
20 |
|
21 |
# |
22 |
# Structure de la table `accountoffsets` |
23 |
# |
24 |
|
25 |
CREATE TABLE accountoffsets ( |
26 |
borrowernumber int(11) NOT NULL default '0', |
27 |
accountno smallint(6) NOT NULL default '0', |
28 |
offsetaccount smallint(6) NOT NULL default '0', |
29 |
offsetamount decimal(28,6) default NULL, |
30 |
timestamp timestamp(14) NOT NULL |
31 |
) TYPE=MyISAM; |
32 |
# -------------------------------------------------------- |
33 |
|
34 |
# |
35 |
# Structure de la table `additionalauthors` |
36 |
# |
37 |
|
38 |
CREATE TABLE additionalauthors ( |
39 |
author text NOT NULL, |
40 |
biblionumber int(11) NOT NULL default '0', |
41 |
KEY bibidx (biblionumber) |
42 |
) TYPE=MyISAM; |
43 |
# -------------------------------------------------------- |
44 |
|
45 |
# |
46 |
# Structure de la table `aqbasket` |
47 |
# |
48 |
|
49 |
CREATE TABLE aqbasket ( |
50 |
basketno int(11) NOT NULL auto_increment, |
51 |
creationdate date default NULL, |
52 |
closedate date default NULL, |
53 |
booksellerid varchar(10) default NULL, |
54 |
authorisedby varchar(10) default NULL, |
55 |
booksellerinvoicenumber text, |
56 |
PRIMARY KEY (basketno) |
57 |
) TYPE=MyISAM; |
58 |
# -------------------------------------------------------- |
59 |
|
60 |
# |
61 |
# Structure de la table `aqbookfund` |
62 |
# |
63 |
|
64 |
CREATE TABLE aqbookfund ( |
65 |
bookfundid varchar(5) NOT NULL default '''''', |
66 |
bookfundname text, |
67 |
bookfundgroup varchar(5) default NULL, |
68 |
PRIMARY KEY (bookfundid) |
69 |
) TYPE=MyISAM; |
70 |
# -------------------------------------------------------- |
71 |
|
72 |
# |
73 |
# Structure de la table `aqbooksellers` |
74 |
# |
75 |
|
76 |
CREATE TABLE aqbooksellers ( |
77 |
id int(11) default NULL, |
78 |
name text, |
79 |
address1 text, |
80 |
address2 text, |
81 |
address3 text, |
82 |
address4 text, |
83 |
phone varchar(30) default NULL, |
84 |
accountnumber text, |
85 |
othersupplier text, |
86 |
currency char(3) NOT NULL default '', |
87 |
deliverydays smallint(6) default NULL, |
88 |
followupdays smallint(6) default NULL, |
89 |
followupscancel smallint(6) default NULL, |
90 |
specialty text, |
91 |
booksellerfax text, |
92 |
notes text, |
93 |
bookselleremail text, |
94 |
booksellerurl text, |
95 |
contact varchar(100) default NULL, |
96 |
postal text, |
97 |
url varchar(255) default NULL, |
98 |
contpos varchar(100) default NULL, |
99 |
contphone varchar(100) default NULL, |
100 |
contfax varchar(100) default NULL, |
101 |
contaltphone varchar(100) default NULL, |
102 |
contemail varchar(100) default NULL, |
103 |
contnotes text, |
104 |
active tinyint(4) default NULL, |
105 |
listprice varchar(5) default NULL, |
106 |
invoiceprice varchar(5) default NULL, |
107 |
gstreg tinyint(4) default NULL, |
108 |
listincgst tinyint(4) default NULL, |
109 |
invoiceincgst tinyint(4) default NULL, |
110 |
discount float(6,4) default NULL, |
111 |
fax varchar(50) default NULL, |
112 |
nocalc int(11) default NULL, |
113 |
invoicedisc float(6,4) default NULL |
114 |
) TYPE=MyISAM; |
115 |
# -------------------------------------------------------- |
116 |
|
117 |
# |
118 |
# Structure de la table `aqbudget` |
119 |
# |
120 |
|
121 |
CREATE TABLE aqbudget ( |
122 |
bookfundid char(5) NOT NULL default '', |
123 |
startdate date NOT NULL default '0000-00-00', |
124 |
enddate date default NULL, |
125 |
budgetamount decimal(13,2) default NULL, |
126 |
aqbudgetid tinyint(4) NOT NULL auto_increment, |
127 |
PRIMARY KEY (aqbudgetid) |
128 |
) TYPE=MyISAM; |
129 |
# -------------------------------------------------------- |
130 |
|
131 |
# |
132 |
# Structure de la table `aqorderbreakdown` |
133 |
# |
134 |
|
135 |
CREATE TABLE aqorderbreakdown ( |
136 |
ordernumber int(11) default NULL, |
137 |
linenumber int(11) default NULL, |
138 |
branchcode char(4) default NULL, |
139 |
bookfundid char(5) NOT NULL default '', |
140 |
allocation smallint(6) default NULL |
141 |
) TYPE=MyISAM; |
142 |
# -------------------------------------------------------- |
143 |
|
144 |
# |
145 |
# Structure de la table `aqorderdelivery` |
146 |
# |
147 |
|
148 |
CREATE TABLE aqorderdelivery ( |
149 |
ordernumber date NOT NULL default '0000-00-00', |
150 |
deliverynumber smallint(6) NOT NULL default '0', |
151 |
deliverydate varchar(18) default NULL, |
152 |
qtydelivered smallint(6) default NULL, |
153 |
deliverycomments text |
154 |
) TYPE=MyISAM; |
155 |
# -------------------------------------------------------- |
156 |
|
157 |
# |
158 |
# Structure de la table `aqorders` |
159 |
# |
160 |
|
161 |
CREATE TABLE aqorders ( |
162 |
ordernumber int(11) NOT NULL auto_increment, |
163 |
biblionumber int(11) default NULL, |
164 |
title text, |
165 |
entrydate date default NULL, |
166 |
quantity smallint(6) default NULL, |
167 |
currency char(3) default NULL, |
168 |
listprice decimal(28,6) default NULL, |
169 |
totalamount decimal(28,6) default NULL, |
170 |
datereceived date default NULL, |
171 |
booksellerinvoicenumber text, |
172 |
freight decimal(28,6) default NULL, |
173 |
unitprice decimal(28,6) default NULL, |
174 |
quantityreceived smallint(6) default NULL, |
175 |
cancelledby varchar(10) default NULL, |
176 |
datecancellationprinted date default NULL, |
177 |
notes text, |
178 |
supplierreference text, |
179 |
purchaseordernumber text, |
180 |
subscription tinyint(1) default NULL, |
181 |
serialid varchar(30) default NULL, |
182 |
basketno int(11) default NULL, |
183 |
biblioitemnumber int(11) default NULL, |
184 |
timestamp timestamp(14) NOT NULL, |
185 |
rrp decimal(13,2) default NULL, |
186 |
ecost decimal(13,2) default NULL, |
187 |
gst decimal(13,2) default NULL, |
188 |
budgetdate date default NULL, |
189 |
sort1 varchar(80) default NULL, |
190 |
sort2 varchar(80) default NULL, |
191 |
PRIMARY KEY (ordernumber) |
192 |
) TYPE=MyISAM; |
193 |
# -------------------------------------------------------- |
194 |
|
195 |
# |
196 |
# Structure de la table `auth_header` |
197 |
# |
198 |
|
199 |
CREATE TABLE auth_header ( |
200 |
authid bigint(20) unsigned NOT NULL auto_increment, |
201 |
authtypecode char(10) NOT NULL default '', |
202 |
datecreated date NOT NULL default '0000-00-00', |
203 |
datemodified date default NULL, |
204 |
origincode char(20) default NULL, |
205 |
PRIMARY KEY (authid), |
206 |
KEY origincode (origincode) |
207 |
) TYPE=MyISAM; |
208 |
# -------------------------------------------------------- |
209 |
|
210 |
# |
211 |
# Structure de la table `auth_subfield_structure` |
212 |
# |
213 |
|
214 |
CREATE TABLE auth_subfield_structure ( |
215 |
authtypecode char(10) NOT NULL default '', |
216 |
tagfield char(3) NOT NULL default '', |
217 |
tagsubfield char(1) NOT NULL default '', |
218 |
liblibrarian char(255) NOT NULL default '', |
219 |
libopac char(255) NOT NULL default '', |
220 |
repeatable tinyint(4) NOT NULL default '0', |
221 |
mandatory tinyint(4) NOT NULL default '0', |
222 |
tab tinyint(1) default NULL, |
223 |
authorised_value char(10) default NULL, |
224 |
value_builder char(80) default NULL, |
225 |
seealso char(255) default NULL, |
226 |
PRIMARY KEY (authtypecode,tagfield,tagsubfield), |
227 |
KEY tab (authtypecode,tab) |
228 |
) TYPE=MyISAM; |
229 |
# -------------------------------------------------------- |
230 |
|
231 |
# |
232 |
# Structure de la table `auth_subfield_table` |
233 |
# |
234 |
|
235 |
CREATE TABLE auth_subfield_table ( |
236 |
subfieldid bigint(20) unsigned NOT NULL auto_increment, |
237 |
authid bigint(20) unsigned NOT NULL default '0', |
238 |
tag char(3) NOT NULL default '', |
239 |
tagorder tinyint(4) NOT NULL default '1', |
240 |
tag_indicator char(2) NOT NULL default '', |
241 |
subfieldcode char(1) NOT NULL default '', |
242 |
subfieldorder tinyint(4) NOT NULL default '1', |
243 |
subfieldvalue varchar(255) default NULL, |
244 |
PRIMARY KEY (subfieldid), |
245 |
KEY authid (authid), |
246 |
KEY tag (tag), |
247 |
KEY subfieldcode (subfieldcode), |
248 |
KEY subfieldvalue (subfieldvalue) |
249 |
) TYPE=MyISAM; |
250 |
# -------------------------------------------------------- |
251 |
|
252 |
# |
253 |
# Structure de la table `auth_tag_structure` |
254 |
# |
255 |
|
256 |
CREATE TABLE auth_tag_structure ( |
257 |
authtypecode char(10) NOT NULL default '', |
258 |
tagfield char(3) NOT NULL default '', |
259 |
liblibrarian char(255) NOT NULL default '', |
260 |
libopac char(255) NOT NULL default '', |
261 |
repeatable tinyint(4) NOT NULL default '0', |
262 |
mandatory tinyint(4) NOT NULL default '0', |
263 |
authorised_value char(10) default NULL, |
264 |
PRIMARY KEY (authtypecode,tagfield) |
265 |
) TYPE=MyISAM; |
266 |
# -------------------------------------------------------- |
267 |
|
268 |
# |
269 |
# Structure de la table `auth_types` |
270 |
# |
271 |
|
272 |
CREATE TABLE auth_types ( |
273 |
authtypecode varchar(10) NOT NULL default '', |
274 |
authtypetext varchar(255) NOT NULL default '', |
275 |
auth_tag_to_report char(3) NOT NULL default '', |
276 |
summary text NOT NULL, |
277 |
PRIMARY KEY (authtypecode) |
278 |
) TYPE=MyISAM; |
279 |
# -------------------------------------------------------- |
280 |
|
281 |
# |
282 |
# Structure de la table `auth_word` |
283 |
# |
284 |
|
285 |
CREATE TABLE auth_word ( |
286 |
authid bigint(20) NOT NULL default '0', |
287 |
tagsubfield varchar(4) NOT NULL default '', |
288 |
tagorder tinyint(4) NOT NULL default '1', |
289 |
subfieldorder tinyint(4) NOT NULL default '1', |
290 |
word varchar(255) NOT NULL default '', |
291 |
sndx_word varchar(255) NOT NULL default '', |
292 |
KEY authid (authid), |
293 |
KEY marc_search (tagsubfield,word), |
294 |
KEY word (word), |
295 |
KEY sndx_word (sndx_word) |
296 |
) TYPE=MyISAM; |
297 |
# -------------------------------------------------------- |
298 |
|
299 |
# |
300 |
# Structure de la table `authorised_values` |
301 |
# |
302 |
|
303 |
CREATE TABLE authorised_values ( |
304 |
id int(11) NOT NULL auto_increment, |
305 |
category char(10) NOT NULL default '', |
306 |
authorised_value char(80) NOT NULL default '', |
307 |
lib char(80) default NULL, |
308 |
PRIMARY KEY (id), |
309 |
KEY name (category) |
310 |
) TYPE=MyISAM; |
311 |
# -------------------------------------------------------- |
312 |
|
313 |
# |
314 |
# Structure de la table `biblio` |
315 |
# |
316 |
|
317 |
CREATE TABLE biblio ( |
318 |
biblionumber int(11) NOT NULL default '0', |
319 |
author text, |
320 |
title text, |
321 |
unititle text, |
322 |
notes text, |
323 |
serial tinyint(1) default NULL, |
324 |
seriestitle text, |
325 |
copyrightdate smallint(6) default NULL, |
326 |
timestamp timestamp(14) NOT NULL, |
327 |
abstract text, |
328 |
PRIMARY KEY (biblionumber), |
329 |
KEY blbnoidx (biblionumber) |
330 |
) TYPE=MyISAM; |
331 |
# -------------------------------------------------------- |
332 |
|
333 |
# |
334 |
# Structure de la table `biblio_framework` |
335 |
# |
336 |
|
337 |
CREATE TABLE biblio_framework ( |
338 |
frameworkcode char(4) NOT NULL default '', |
339 |
frameworktext char(255) NOT NULL default '', |
340 |
PRIMARY KEY (frameworkcode) |
341 |
) TYPE=MyISAM; |
342 |
# -------------------------------------------------------- |
343 |
|
344 |
# |
345 |
# Structure de la table `biblioanalysis` |
346 |
# |
347 |
|
348 |
CREATE TABLE biblioanalysis ( |
349 |
analyticaltitle text, |
350 |
biblionumber int(11) NOT NULL default '0', |
351 |
analyticalauthor text |
352 |
) TYPE=MyISAM; |
353 |
# -------------------------------------------------------- |
354 |
|
355 |
# |
356 |
# Structure de la table `biblioitems` |
357 |
# |
358 |
|
359 |
CREATE TABLE biblioitems ( |
360 |
biblioitemnumber int(11) NOT NULL default '0', |
361 |
biblionumber int(11) NOT NULL default '0', |
362 |
volume text, |
363 |
number text, |
364 |
classification varchar(25) default NULL, |
365 |
itemtype varchar(4) default NULL, |
366 |
isbn varchar(14) default NULL, |
367 |
issn varchar(9) default NULL, |
368 |
dewey varchar(50) default NULL, |
369 |
subclass char(3) default NULL, |
370 |
publicationyear smallint(6) default NULL, |
371 |
publishercode varchar(255) default NULL, |
372 |
volumedate date default NULL, |
373 |
volumeddesc varchar(255) default NULL, |
374 |
timestamp timestamp(14) NOT NULL, |
375 |
illus varchar(255) default NULL, |
376 |
pages varchar(255) default NULL, |
377 |
notes text, |
378 |
size varchar(255) default NULL, |
379 |
place varchar(255) default NULL, |
380 |
lccn varchar(25) default NULL, |
381 |
marc text, |
382 |
url varchar(255) default NULL, |
383 |
PRIMARY KEY (biblioitemnumber), |
384 |
KEY bibinoidx (biblioitemnumber), |
385 |
KEY bibnoidx (biblionumber) |
386 |
) TYPE=MyISAM; |
387 |
# -------------------------------------------------------- |
388 |
|
389 |
# |
390 |
# Structure de la table `bibliosubject` |
391 |
# |
392 |
|
393 |
CREATE TABLE bibliosubject ( |
394 |
subject text NOT NULL, |
395 |
biblionumber int(11) NOT NULL default '0' |
396 |
) TYPE=MyISAM; |
397 |
# -------------------------------------------------------- |
398 |
|
399 |
# |
400 |
# Structure de la table `bibliosubtitle` |
401 |
# |
402 |
|
403 |
CREATE TABLE bibliosubtitle ( |
404 |
subtitle text NOT NULL, |
405 |
biblionumber int(11) NOT NULL default '0', |
406 |
KEY bibsubidx (biblionumber) |
407 |
) TYPE=MyISAM; |
408 |
# -------------------------------------------------------- |
409 |
|
410 |
# |
411 |
# Structure de la table `bibliothesaurus` |
412 |
# |
413 |
|
414 |
CREATE TABLE bibliothesaurus ( |
415 |
id bigint(20) NOT NULL auto_increment, |
416 |
freelib char(255) NOT NULL default '', |
417 |
stdlib char(255) NOT NULL default '', |
418 |
category char(10) NOT NULL default '', |
419 |
level tinyint(4) NOT NULL default '1', |
420 |
hierarchy char(80) NOT NULL default '', |
421 |
father char(80) NOT NULL default '', |
422 |
PRIMARY KEY (id), |
423 |
KEY freelib (freelib), |
424 |
KEY stdlib (stdlib), |
425 |
KEY category (category), |
426 |
KEY hierarchy (hierarchy), |
427 |
FULLTEXT KEY category_2 (category,freelib) |
428 |
) TYPE=MyISAM; |
429 |
# -------------------------------------------------------- |
430 |
|
431 |
# |
432 |
# Structure de la table `bookshelf` |
433 |
# |
434 |
|
435 |
CREATE TABLE bookshelf ( |
436 |
shelfnumber int(11) NOT NULL auto_increment, |
437 |
shelfname char(255) default NULL, |
438 |
owner char(80) default NULL, |
439 |
category char(1) default NULL, |
440 |
PRIMARY KEY (shelfnumber) |
441 |
) TYPE=MyISAM; |
442 |
# -------------------------------------------------------- |
443 |
|
444 |
# |
445 |
# Structure de la table `borexp` |
446 |
# |
447 |
|
448 |
CREATE TABLE borexp ( |
449 |
borrowernumber int(11) default NULL, |
450 |
newexp date default NULL |
451 |
) TYPE=MyISAM; |
452 |
# -------------------------------------------------------- |
453 |
|
454 |
# |
455 |
# Structure de la table `borrowers` |
456 |
# |
457 |
|
458 |
CREATE TABLE borrowers ( |
459 |
borrowernumber int(11) NOT NULL auto_increment, |
460 |
cardnumber varchar(16) NOT NULL default '', |
461 |
surname text NOT NULL, |
462 |
firstname text NOT NULL, |
463 |
title text, |
464 |
othernames text, |
465 |
initials text NOT NULL, |
466 |
streetaddress text NOT NULL, |
467 |
suburb text, |
468 |
city text NOT NULL, |
469 |
phone text NOT NULL, |
470 |
emailaddress text, |
471 |
faxnumber text, |
472 |
textmessaging text, |
473 |
altstreetaddress text, |
474 |
altsuburb text, |
475 |
altcity text, |
476 |
altphone text, |
477 |
dateofbirth date default NULL, |
478 |
branchcode varchar(4) NOT NULL default '', |
479 |
categorycode char(2) default NULL, |
480 |
dateenrolled date default NULL, |
481 |
gonenoaddress tinyint(1) default NULL, |
482 |
lost tinyint(1) default NULL, |
483 |
debarred tinyint(1) default NULL, |
484 |
studentnumber text, |
485 |
school text, |
486 |
contactname text, |
487 |
borrowernotes text, |
488 |
guarantor int(11) default NULL, |
489 |
area char(2) default NULL, |
490 |
ethnicity varchar(50) default NULL, |
491 |
ethnotes varchar(255) default NULL, |
492 |
sex char(1) default NULL, |
493 |
expiry date default NULL, |
494 |
altnotes varchar(255) default NULL, |
495 |
altrelationship varchar(100) default NULL, |
496 |
streetcity text, |
497 |
phoneday varchar(50) default NULL, |
498 |
preferredcont char(1) default NULL, |
499 |
physstreet varchar(100) default NULL, |
500 |
password varchar(30) default NULL, |
501 |
flags int(11) default NULL, |
502 |
userid varchar(30) default NULL, |
503 |
homezipcode varchar(25) default NULL, |
504 |
zipcode varchar(25) default NULL, |
505 |
sort1 varchar(80) default NULL, |
506 |
sort2 varchar(80) default NULL, |
507 |
UNIQUE KEY cardnumber (cardnumber), |
508 |
KEY borrowernumber (borrowernumber) |
509 |
) TYPE=MyISAM; |
510 |
# -------------------------------------------------------- |
511 |
|
512 |
# |
513 |
# Structure de la table `branchcategories` |
514 |
# |
515 |
|
516 |
CREATE TABLE branchcategories ( |
517 |
categorycode varchar(4) NOT NULL default '', |
518 |
categoryname text, |
519 |
codedescription text, |
520 |
PRIMARY KEY (categorycode) |
521 |
) TYPE=MyISAM; |
522 |
# -------------------------------------------------------- |
523 |
|
524 |
# |
525 |
# Structure de la table `branches` |
526 |
# |
527 |
|
528 |
CREATE TABLE branches ( |
529 |
branchcode varchar(4) NOT NULL default '', |
530 |
branchname text NOT NULL, |
531 |
branchaddress1 text, |
532 |
branchaddress2 text, |
533 |
branchaddress3 text, |
534 |
branchphone text, |
535 |
branchfax text, |
536 |
branchemail text, |
537 |
issuing tinyint(4) default NULL, |
538 |
UNIQUE KEY branchcode (branchcode) |
539 |
) TYPE=MyISAM; |
540 |
# -------------------------------------------------------- |
541 |
|
542 |
# |
543 |
# Structure de la table `branchrelations` |
544 |
# |
545 |
|
546 |
CREATE TABLE branchrelations ( |
547 |
branchcode varchar(4) default NULL, |
548 |
categorycode varchar(4) default NULL |
549 |
) TYPE=MyISAM; |
550 |
# -------------------------------------------------------- |
551 |
|
552 |
# |
553 |
# Structure de la table `branchtransfers` |
554 |
# |
555 |
|
556 |
CREATE TABLE branchtransfers ( |
557 |
itemnumber int(11) NOT NULL default '0', |
558 |
datesent datetime default NULL, |
559 |
frombranch varchar(4) default NULL, |
560 |
datearrived datetime default NULL, |
561 |
tobranch varchar(4) default NULL, |
562 |
comments text |
563 |
) TYPE=MyISAM; |
564 |
# -------------------------------------------------------- |
565 |
|
566 |
# |
567 |
# Structure de la table `catalogueentry` |
568 |
# |
569 |
|
570 |
CREATE TABLE catalogueentry ( |
571 |
catalogueentry text NOT NULL, |
572 |
entrytype char(2) default NULL, |
573 |
see text, |
574 |
seealso text, |
575 |
seeinstead text, |
576 |
biblionumber int(11) default NULL |
577 |
) TYPE=MyISAM; |
578 |
# -------------------------------------------------------- |
579 |
|
580 |
# |
581 |
# Structure de la table `categories` |
582 |
# |
583 |
|
584 |
CREATE TABLE categories ( |
585 |
categorycode char(2) NOT NULL default '', |
586 |
description text, |
587 |
enrolmentperiod smallint(6) default NULL, |
588 |
upperagelimit smallint(6) default NULL, |
589 |
dateofbirthrequired tinyint(1) default NULL, |
590 |
finetype varchar(30) default NULL, |
591 |
bulk tinyint(1) default NULL, |
592 |
enrolmentfee decimal(28,6) default NULL, |
593 |
overduenoticerequired tinyint(1) default NULL, |
594 |
issuelimit smallint(6) default NULL, |
595 |
reservefee decimal(28,6) default NULL, |
596 |
UNIQUE KEY categorycode (categorycode) |
597 |
) TYPE=MyISAM; |
598 |
# -------------------------------------------------------- |
599 |
|
600 |
# |
601 |
# Structure de la table `currency` |
602 |
# |
603 |
|
604 |
CREATE TABLE currency ( |
605 |
currency varchar(10) default NULL, |
606 |
rate float(7,5) default NULL |
607 |
) TYPE=MyISAM; |
608 |
# -------------------------------------------------------- |
609 |
|
610 |
# |
611 |
# Structure de la table `deletedbiblio` |
612 |
# |
613 |
|
614 |
CREATE TABLE deletedbiblio ( |
615 |
biblionumber int(11) NOT NULL default '0', |
616 |
author text, |
617 |
title text, |
618 |
unititle text, |
619 |
notes text, |
620 |
serial tinyint(1) default NULL, |
621 |
seriestitle text, |
622 |
copyrightdate smallint(6) default NULL, |
623 |
timestamp timestamp(14) NOT NULL, |
624 |
marc blob, |
625 |
abstract text, |
626 |
PRIMARY KEY (biblionumber), |
627 |
KEY blbnoidx (biblionumber) |
628 |
) TYPE=MyISAM; |
629 |
# -------------------------------------------------------- |
630 |
|
631 |
# |
632 |
# Structure de la table `deletedbiblioitems` |
633 |
# |
634 |
|
635 |
CREATE TABLE deletedbiblioitems ( |
636 |
biblioitemnumber int(11) NOT NULL default '0', |
637 |
biblionumber int(11) NOT NULL default '0', |
638 |
volume text, |
639 |
number text, |
640 |
classification varchar(25) default NULL, |
641 |
itemtype varchar(4) default NULL, |
642 |
isbn varchar(14) default NULL, |
643 |
issn varchar(9) default NULL, |
644 |
dewey varchar(50) default NULL, |
645 |
subclass char(3) default NULL, |
646 |
publicationyear smallint(6) default NULL, |
647 |
publishercode varchar(255) default NULL, |
648 |
volumedate date default NULL, |
649 |
volumeddesc varchar(255) default NULL, |
650 |
timestamp timestamp(14) NOT NULL, |
651 |
illus varchar(255) default NULL, |
652 |
pages varchar(255) default NULL, |
653 |
notes text, |
654 |
size varchar(255) default NULL, |
655 |
lccn varchar(25) default NULL, |
656 |
marc text, |
657 |
url varchar(255) default NULL, |
658 |
PRIMARY KEY (biblioitemnumber), |
659 |
KEY bibinoidx (biblioitemnumber), |
660 |
KEY bibnoidx (biblionumber) |
661 |
) TYPE=MyISAM; |
662 |
# -------------------------------------------------------- |
663 |
|
664 |
# |
665 |
# Structure de la table `deletedborrowers` |
666 |
# |
667 |
|
668 |
CREATE TABLE deletedborrowers ( |
669 |
borrowernumber int(11) NOT NULL default '0', |
670 |
cardnumber varchar(9) NOT NULL default '', |
671 |
surname text NOT NULL, |
672 |
firstname text NOT NULL, |
673 |
title text, |
674 |
othernames text, |
675 |
initials text NOT NULL, |
676 |
streetaddress text NOT NULL, |
677 |
suburb text, |
678 |
city text NOT NULL, |
679 |
phone text NOT NULL, |
680 |
emailaddress text, |
681 |
faxnumber text, |
682 |
altstreetaddress text, |
683 |
altsuburb text, |
684 |
altcity text, |
685 |
altphone text, |
686 |
dateofbirth date default NULL, |
687 |
branchcode varchar(4) NOT NULL default '', |
688 |
categorycode char(2) default NULL, |
689 |
dateenrolled date default NULL, |
690 |
gonenoaddress tinyint(1) default NULL, |
691 |
lost tinyint(1) default NULL, |
692 |
debarred tinyint(1) default NULL, |
693 |
studentnumber text, |
694 |
school text, |
695 |
contactname text, |
696 |
borrowernotes text, |
697 |
guarantor int(11) default NULL, |
698 |
area char(2) default NULL, |
699 |
ethnicity varchar(50) default NULL, |
700 |
ethnotes varchar(255) default NULL, |
701 |
sex char(1) default NULL, |
702 |
expiry date default NULL, |
703 |
altnotes varchar(255) default NULL, |
704 |
altrelationship varchar(100) default NULL, |
705 |
streetcity text, |
706 |
phoneday varchar(50) default NULL, |
707 |
preferredcont varchar(100) default NULL, |
708 |
physstreet varchar(100) default NULL, |
709 |
KEY borrowernumber (borrowernumber), |
710 |
KEY cardnumber (cardnumber) |
711 |
) TYPE=MyISAM; |
712 |
# -------------------------------------------------------- |
713 |
|
714 |
# |
715 |
# Structure de la table `deleteditems` |
716 |
# |
717 |
|
718 |
CREATE TABLE deleteditems ( |
719 |
itemnumber int(11) NOT NULL default '0', |
720 |
biblionumber int(11) NOT NULL default '0', |
721 |
multivolumepart varchar(30) default NULL, |
722 |
biblioitemnumber int(11) NOT NULL default '0', |
723 |
barcode varchar(9) NOT NULL default '', |
724 |
dateaccessioned date default NULL, |
725 |
booksellerid varchar(10) default NULL, |
726 |
homebranch varchar(4) default NULL, |
727 |
price decimal(28,6) default NULL, |
728 |
replacementprice decimal(28,6) default NULL, |
729 |
replacementpricedate date default NULL, |
730 |
datelastborrowed date default NULL, |
731 |
datelastseen date default NULL, |
732 |
multivolume tinyint(1) default NULL, |
733 |
stack tinyint(1) default NULL, |
734 |
notforloan tinyint(1) default NULL, |
735 |
itemlost tinyint(1) default NULL, |
736 |
wthdrawn tinyint(1) default NULL, |
737 |
bulk varchar(30) default NULL, |
738 |
issues smallint(6) default NULL, |
739 |
renewals smallint(6) default NULL, |
740 |
reserves smallint(6) default NULL, |
741 |
restricted tinyint(1) default NULL, |
742 |
binding decimal(28,6) default NULL, |
743 |
itemnotes text, |
744 |
holdingbranch varchar(4) default NULL, |
745 |
interim tinyint(1) default NULL, |
746 |
timestamp timestamp(14) NOT NULL, |
747 |
marc blob, |
748 |
paidfor text, |
749 |
PRIMARY KEY (itemnumber), |
750 |
UNIQUE KEY barcode (barcode), |
751 |
KEY itembarcodeidx (barcode), |
752 |
KEY itembinoidx (biblioitemnumber), |
753 |
KEY itembibnoidx (biblionumber) |
754 |
) TYPE=MyISAM; |
755 |
# -------------------------------------------------------- |
756 |
|
757 |
# |
758 |
# Structure de la table `ethnicity` |
759 |
# |
760 |
|
761 |
CREATE TABLE ethnicity ( |
762 |
code varchar(10) NOT NULL default '', |
763 |
name varchar(255) default NULL, |
764 |
PRIMARY KEY (code) |
765 |
) TYPE=MyISAM; |
766 |
# -------------------------------------------------------- |
767 |
|
768 |
# |
769 |
# Structure de la table `issues` |
770 |
# |
771 |
|
772 |
CREATE TABLE issues ( |
773 |
borrowernumber int(11) NOT NULL default '0', |
774 |
itemnumber int(11) NOT NULL default '0', |
775 |
date_due date default NULL, |
776 |
branchcode char(4) default NULL, |
777 |
issuingbranch char(18) default NULL, |
778 |
returndate date default NULL, |
779 |
lastreneweddate date default NULL, |
780 |
`return` char(4) default NULL, |
781 |
renewals tinyint(4) default NULL, |
782 |
timestamp timestamp(14) NOT NULL, |
783 |
KEY issuesborridx (borrowernumber), |
784 |
KEY issuesitemidx (itemnumber), |
785 |
KEY bordate (borrowernumber,timestamp) |
786 |
) TYPE=MyISAM; |
787 |
# -------------------------------------------------------- |
788 |
|
789 |
# |
790 |
# Structure de la table `issuingrules` |
791 |
# |
792 |
|
793 |
CREATE TABLE issuingrules ( |
794 |
categorycode char(2) NOT NULL default '', |
795 |
itemtype varchar(4) NOT NULL default '', |
796 |
restrictedtype tinyint(1) default NULL, |
797 |
rentaldiscount decimal(28,6) default NULL, |
798 |
reservecharge decimal(28,6) default NULL, |
799 |
fine decimal(28,6) default NULL, |
800 |
firstremind int(11) default NULL, |
801 |
chargeperiod int(11) default NULL, |
802 |
accountsent int(11) default NULL, |
803 |
chargename varchar(100) default NULL, |
804 |
maxissueqty int(4) default NULL, |
805 |
issuelength int(4) default NULL, |
806 |
branchcode varchar(4) NOT NULL default '', |
807 |
PRIMARY KEY (branchcode,categorycode,itemtype) |
808 |
) TYPE=MyISAM; |
809 |
# -------------------------------------------------------- |
810 |
|
811 |
# |
812 |
# Structure de la table `items` |
813 |
# |
814 |
|
815 |
CREATE TABLE items ( |
816 |
itemnumber int(11) NOT NULL default '0', |
817 |
biblionumber int(11) NOT NULL default '0', |
818 |
multivolumepart varchar(30) default NULL, |
819 |
biblioitemnumber int(11) NOT NULL default '0', |
820 |
barcode varchar(20) default NULL, |
821 |
dateaccessioned date default NULL, |
822 |
booksellerid varchar(10) default NULL, |
823 |
homebranch varchar(4) default NULL, |
824 |
price decimal(8,2) default NULL, |
825 |
replacementprice decimal(8,2) default NULL, |
826 |
replacementpricedate date default NULL, |
827 |
datelastborrowed date default NULL, |
828 |
datelastseen date default NULL, |
829 |
multivolume tinyint(1) default NULL, |
830 |
stack tinyint(1) default NULL, |
831 |
notforloan tinyint(1) default NULL, |
832 |
itemlost tinyint(1) default NULL, |
833 |
wthdrawn tinyint(1) default NULL, |
834 |
itemcallnumber varchar(30) default NULL, |
835 |
issues smallint(6) default NULL, |
836 |
renewals smallint(6) default NULL, |
837 |
reserves smallint(6) default NULL, |
838 |
restricted tinyint(1) default NULL, |
839 |
binding decimal(28,6) default NULL, |
840 |
itemnotes text, |
841 |
holdingbranch varchar(4) default NULL, |
842 |
paidfor text, |
843 |
timestamp timestamp(14) NOT NULL, |
844 |
location varchar(80) default NULL, |
845 |
PRIMARY KEY (itemnumber), |
846 |
KEY itembarcodeidx (barcode), |
847 |
KEY itembinoidx (biblioitemnumber), |
848 |
KEY itembibnoidx (biblionumber) |
849 |
) TYPE=MyISAM; |
850 |
# -------------------------------------------------------- |
851 |
|
852 |
# |
853 |
# Structure de la table `itemsprices` |
854 |
# |
855 |
|
856 |
CREATE TABLE itemsprices ( |
857 |
itemnumber int(11) default NULL, |
858 |
price1 decimal(28,6) default NULL, |
859 |
price2 decimal(28,6) default NULL |
860 |
) TYPE=MyISAM; |
861 |
# -------------------------------------------------------- |
862 |
|
863 |
# |
864 |
# Structure de la table `itemtypes` |
865 |
# |
866 |
|
867 |
CREATE TABLE itemtypes ( |
868 |
itemtype varchar(4) NOT NULL default '', |
869 |
description text, |
870 |
renewalsallowed smallint(6) default NULL, |
871 |
rentalcharge double(16,4) default NULL, |
872 |
notforloan smallint(6) default NULL, |
873 |
UNIQUE KEY itemtype (itemtype) |
874 |
) TYPE=MyISAM; |
875 |
# -------------------------------------------------------- |
876 |
|
877 |
# |
878 |
# Structure de la table `marc_biblio` |
879 |
# |
880 |
|
881 |
CREATE TABLE marc_biblio ( |
882 |
bibid bigint(20) unsigned NOT NULL auto_increment, |
883 |
biblionumber int(11) NOT NULL default '0', |
884 |
datecreated date NOT NULL default '0000-00-00', |
885 |
datemodified date default NULL, |
886 |
origincode char(20) default NULL, |
887 |
frameworkcode char(4) NOT NULL default '', |
888 |
PRIMARY KEY (bibid), |
889 |
KEY origincode (origincode), |
890 |
KEY biblionumber (biblionumber) |
891 |
) TYPE=MyISAM; |
892 |
# -------------------------------------------------------- |
893 |
|
894 |
# |
895 |
# Structure de la table `marc_blob_subfield` |
896 |
# |
897 |
|
898 |
CREATE TABLE marc_blob_subfield ( |
899 |
blobidlink bigint(20) NOT NULL auto_increment, |
900 |
subfieldvalue longtext NOT NULL, |
901 |
PRIMARY KEY (blobidlink) |
902 |
) TYPE=MyISAM; |
903 |
# -------------------------------------------------------- |
904 |
|
905 |
# |
906 |
# Structure de la table `marc_breeding` |
907 |
# |
908 |
|
909 |
CREATE TABLE marc_breeding ( |
910 |
id bigint(20) NOT NULL auto_increment, |
911 |
file varchar(80) NOT NULL default '', |
912 |
isbn varchar(10) NOT NULL default '', |
913 |
title varchar(128) default NULL, |
914 |
author varchar(80) default NULL, |
915 |
marc text NOT NULL, |
916 |
encoding varchar(40) NOT NULL default '''''', |
917 |
z3950random varchar(40) default NULL, |
918 |
PRIMARY KEY (id), |
919 |
KEY title (title), |
920 |
KEY isbn (isbn) |
921 |
) TYPE=MyISAM; |
922 |
# -------------------------------------------------------- |
923 |
|
924 |
# |
925 |
# Structure de la table `marc_subfield_structure` |
926 |
# |
927 |
CREATE TABLE marc_subfield_structure ( |
928 |
tagfield char(3) NOT NULL default '', |
929 |
tagsubfield char(1) NOT NULL default '', |
930 |
liblibrarian varchar(255) NOT NULL default '', |
931 |
libopac varchar(255) NOT NULL default '', |
932 |
repeatable tinyint(4) NOT NULL default '0', |
933 |
mandatory tinyint(4) NOT NULL default '0', |
934 |
kohafield varchar(40) default NULL, |
935 |
tab tinyint(1) default NULL, |
936 |
authorised_value varchar(10) default NULL, |
937 |
authtypecode varchar(10) default NULL, |
938 |
value_builder varchar(80) default NULL, |
939 |
isurl tinyint(1) default NULL, |
940 |
hidden tinyint(1) default NULL, |
941 |
frameworkcode varchar(4) NOT NULL default '', |
942 |
seealso text default NULL, |
943 |
link varchar(80) default NULL, |
944 |
PRIMARY KEY (frameworkcode,tagfield,tagsubfield), |
945 |
KEY tab (frameworkcode,tab), |
946 |
KEY kohafield (frameworkcode,kohafield), |
947 |
KEY kohafield_2 (kohafield) |
948 |
) TYPE=MyISAM; |
949 |
# -------------------------------------------------------- |
950 |
|
951 |
# |
952 |
# Structure de la table `marc_subfield_table` |
953 |
# |
954 |
|
955 |
CREATE TABLE marc_subfield_table ( |
956 |
subfieldid bigint(20) unsigned NOT NULL auto_increment, |
957 |
bibid bigint(20) unsigned NOT NULL default '0', |
958 |
tag char(3) NOT NULL default '', |
959 |
tagorder tinyint(4) NOT NULL default '1', |
960 |
tag_indicator char(2) NOT NULL default '', |
961 |
subfieldcode char(1) NOT NULL default '', |
962 |
subfieldorder tinyint(4) NOT NULL default '1', |
963 |
subfieldvalue varchar(255) default NULL, |
964 |
valuebloblink bigint(20) default NULL, |
965 |
PRIMARY KEY (subfieldid), |
966 |
KEY bibid (bibid), |
967 |
KEY tag (tag), |
968 |
KEY tag_indicator (tag_indicator), |
969 |
KEY subfieldorder (subfieldorder), |
970 |
KEY subfieldcode (subfieldcode), |
971 |
KEY subfieldvalue (subfieldvalue), |
972 |
KEY tagorder (tagorder) |
973 |
) TYPE=MyISAM; |
974 |
# -------------------------------------------------------- |
975 |
|
976 |
# |
977 |
# Structure de la table `marc_tag_structure` |
978 |
# |
979 |
|
980 |
CREATE TABLE marc_tag_structure ( |
981 |
tagfield char(3) NOT NULL default '', |
982 |
liblibrarian char(255) NOT NULL default '', |
983 |
libopac char(255) NOT NULL default '', |
984 |
repeatable tinyint(4) NOT NULL default '0', |
985 |
mandatory tinyint(4) NOT NULL default '0', |
986 |
authorised_value char(10) default NULL, |
987 |
frameworkcode char(4) NOT NULL default '', |
988 |
PRIMARY KEY (frameworkcode,tagfield) |
989 |
) TYPE=MyISAM; |
990 |
# -------------------------------------------------------- |
991 |
|
992 |
# |
993 |
# Structure de la table `marc_word` |
994 |
# |
995 |
|
996 |
CREATE TABLE marc_word ( |
997 |
bibid bigint(20) NOT NULL default '0', |
998 |
tagsubfield varchar(4) NOT NULL default '', |
999 |
tagorder tinyint(4) NOT NULL default '1', |
1000 |
subfieldorder tinyint(4) NOT NULL default '1', |
1001 |
word varchar(255) NOT NULL default '', |
1002 |
sndx_word varchar(255) NOT NULL default '', |
1003 |
KEY bibid (bibid), |
1004 |
KEY tagorder (tagorder), |
1005 |
KEY subfieldorder (subfieldorder), |
1006 |
KEY word (word), |
1007 |
KEY sndx_word (sndx_word), |
1008 |
KEY Search_Marc (tagsubfield,word) |
1009 |
) TYPE=MyISAM; |
1010 |
# -------------------------------------------------------- |
1011 |
|
1012 |
# |
1013 |
# Structure de la table `marcrecorddone` |
1014 |
# |
1015 |
|
1016 |
CREATE TABLE marcrecorddone ( |
1017 |
isbn char(40) default NULL, |
1018 |
issn char(40) default NULL, |
1019 |
lccn char(40) default NULL, |
1020 |
controlnumber char(40) default NULL |
1021 |
) TYPE=MyISAM; |
1022 |
# -------------------------------------------------------- |
1023 |
|
1024 |
# |
1025 |
# Structure de la table `printers` |
1026 |
# |
1027 |
|
1028 |
CREATE TABLE printers ( |
1029 |
printername char(40) NOT NULL default '''''', |
1030 |
printqueue char(20) default NULL, |
1031 |
printtype char(20) default NULL, |
1032 |
PRIMARY KEY (printername) |
1033 |
) TYPE=MyISAM; |
1034 |
# -------------------------------------------------------- |
1035 |
|
1036 |
# |
1037 |
# Structure de la table `reserveconstraints` |
1038 |
# |
1039 |
|
1040 |
CREATE TABLE reserveconstraints ( |
1041 |
borrowernumber int(11) NOT NULL default '0', |
1042 |
reservedate date NOT NULL default '0000-00-00', |
1043 |
biblionumber int(11) NOT NULL default '0', |
1044 |
biblioitemnumber int(11) default NULL, |
1045 |
timestamp timestamp(14) NOT NULL |
1046 |
) TYPE=MyISAM; |
1047 |
# -------------------------------------------------------- |
1048 |
|
1049 |
# |
1050 |
# Structure de la table `reserves` |
1051 |
# |
1052 |
|
1053 |
CREATE TABLE reserves ( |
1054 |
borrowernumber int(11) NOT NULL default '0', |
1055 |
reservedate date NOT NULL default '0000-00-00', |
1056 |
biblionumber int(11) NOT NULL default '0', |
1057 |
constrainttype char(1) default NULL, |
1058 |
branchcode varchar(4) default NULL, |
1059 |
notificationdate date default NULL, |
1060 |
reminderdate date default NULL, |
1061 |
cancellationdate date default NULL, |
1062 |
reservenotes text, |
1063 |
priority smallint(6) default NULL, |
1064 |
found char(1) default NULL, |
1065 |
timestamp timestamp(14) NOT NULL, |
1066 |
itemnumber int(11) default NULL |
1067 |
) TYPE=MyISAM; |
1068 |
# -------------------------------------------------------- |
1069 |
|
1070 |
# |
1071 |
# Structure de la table `serial` |
1072 |
# |
1073 |
|
1074 |
CREATE TABLE serial ( |
1075 |
serialid int(11) NOT NULL auto_increment, |
1076 |
biblionumber varchar(100) NOT NULL default '', |
1077 |
subscriptionid varchar(100) NOT NULL default '', |
1078 |
serialseq varchar(100) NOT NULL default '', |
1079 |
status tinyint(4) NOT NULL default '0', |
1080 |
planneddate date NOT NULL default '0000-00-00', |
1081 |
PRIMARY KEY (serialid) |
1082 |
) TYPE=MyISAM; |
1083 |
# -------------------------------------------------------- |
1084 |
|
1085 |
# |
1086 |
# Structure de la table `sessionqueries` |
1087 |
# |
1088 |
|
1089 |
CREATE TABLE sessionqueries ( |
1090 |
sessionID varchar(255) NOT NULL default '', |
1091 |
userid varchar(100) NOT NULL default '', |
1092 |
ip varchar(18) NOT NULL default '', |
1093 |
url text NOT NULL |
1094 |
) TYPE=MyISAM; |
1095 |
# -------------------------------------------------------- |
1096 |
|
1097 |
# |
1098 |
# Structure de la table `sessions` |
1099 |
# |
1100 |
|
1101 |
CREATE TABLE sessions ( |
1102 |
sessionID varchar(255) NOT NULL default '', |
1103 |
userid varchar(255) default NULL, |
1104 |
ip varchar(16) default NULL, |
1105 |
lasttime int(11) default NULL, |
1106 |
PRIMARY KEY (sessionID) |
1107 |
) TYPE=MyISAM; |
1108 |
# -------------------------------------------------------- |
1109 |
|
1110 |
# |
1111 |
# Structure de la table `shelfcontents` |
1112 |
# |
1113 |
|
1114 |
CREATE TABLE shelfcontents ( |
1115 |
shelfnumber int(11) NOT NULL default '0', |
1116 |
itemnumber int(11) NOT NULL default '0', |
1117 |
flags int(11) default NULL |
1118 |
) TYPE=MyISAM; |
1119 |
# -------------------------------------------------------- |
1120 |
|
1121 |
# |
1122 |
# Structure de la table `statistics` |
1123 |
# |
1124 |
|
1125 |
CREATE TABLE statistics ( |
1126 |
datetime datetime NOT NULL default '0000-00-00 00:00:00', |
1127 |
branch varchar(4) default NULL, |
1128 |
proccode varchar(4) default NULL, |
1129 |
value double(16,4) default NULL, |
1130 |
type varchar(16) default NULL, |
1131 |
other text, |
1132 |
usercode varchar(10) default NULL, |
1133 |
itemnumber int(11) default NULL, |
1134 |
itemtype varchar(4) default NULL, |
1135 |
borrowernumber int(11) default NULL, |
1136 |
KEY timeidx (datetime) |
1137 |
) TYPE=MyISAM; |
1138 |
# -------------------------------------------------------- |
1139 |
|
1140 |
# |
1141 |
# Structure de la table `stopwords` |
1142 |
# |
1143 |
|
1144 |
CREATE TABLE stopwords ( |
1145 |
word varchar(255) default NULL |
1146 |
) TYPE=MyISAM; |
1147 |
# -------------------------------------------------------- |
1148 |
|
1149 |
# |
1150 |
# Structure de la table `subscription` |
1151 |
# |
1152 |
|
1153 |
CREATE TABLE subscription ( |
1154 |
biblionumber int(11) NOT NULL default '0', |
1155 |
subscriptionid int(11) NOT NULL auto_increment, |
1156 |
librarian varchar(100) default '', |
1157 |
startdate date default '0000-00-00', |
1158 |
aqbooksellerid int(11) default '0', |
1159 |
cost int(11) default '0', |
1160 |
aqbudgetid int(11) default '0', |
1161 |
weeklength tinyint(4) default '0', |
1162 |
monthlength tinyint(4) default '0', |
1163 |
numberlength tinyint(4) default '0', |
1164 |
periodicity tinyint(4) default '0', |
1165 |
dow varchar(100) default '', |
1166 |
numberingmethod varchar(100) default '', |
1167 |
notes text, |
1168 |
status varchar(100) NOT NULL default '', |
1169 |
add1 int(11) default '0', |
1170 |
every1 int(11) default '0', |
1171 |
whenmorethan1 int(11) default '0', |
1172 |
setto1 int(11) default NULL, |
1173 |
lastvalue1 int(11) default NULL, |
1174 |
add2 int(11) default '0', |
1175 |
every2 int(11) default '0', |
1176 |
whenmorethan2 int(11) default '0', |
1177 |
setto2 int(11) default NULL, |
1178 |
lastvalue2 int(11) default NULL, |
1179 |
add3 int(11) default '0', |
1180 |
every3 int(11) default '0', |
1181 |
innerloop1 int(11) default '0', |
1182 |
innerloop2 int(11) default '0', |
1183 |
innerloop3 int(11) default '0', |
1184 |
whenmorethan3 int(11) default '0', |
1185 |
setto3 int(11) default NULL, |
1186 |
lastvalue3 int(11) default NULL, |
1187 |
PRIMARY KEY (subscriptionid) |
1188 |
) TYPE=MyISAM; |
1189 |
# -------------------------------------------------------- |
1190 |
|
1191 |
# |
1192 |
# Structure de la table `subscriptionhistory` |
1193 |
# |
1194 |
|
1195 |
CREATE TABLE subscriptionhistory ( |
1196 |
biblionumber int(11) NOT NULL default '0', |
1197 |
subscriptionid int(11) NOT NULL default '0', |
1198 |
histstartdate date NOT NULL default '0000-00-00', |
1199 |
enddate date default '0000-00-00', |
1200 |
missinglist longtext NOT NULL, |
1201 |
recievedlist longtext NOT NULL, |
1202 |
opacnote varchar(150) NOT NULL default '', |
1203 |
librariannote varchar(150) NOT NULL default '', |
1204 |
PRIMARY KEY (subscriptionid), |
1205 |
KEY biblionumber (biblionumber) |
1206 |
) TYPE=MyISAM; |
1207 |
# -------------------------------------------------------- |
1208 |
|
1209 |
# |
1210 |
# Structure de la table `suggestions` |
1211 |
# |
1212 |
|
1213 |
CREATE TABLE suggestions ( |
1214 |
suggestionid int(8) NOT NULL auto_increment, |
1215 |
suggestedby int(11) NOT NULL default '0', |
1216 |
managedby int(11) default NULL, |
1217 |
STATUS varchar(10) NOT NULL default '', |
1218 |
note text, |
1219 |
author varchar(80) default NULL, |
1220 |
title varchar(80) default NULL, |
1221 |
copyrightdate smallint(6) default NULL, |
1222 |
publishercode varchar(255) default NULL, |
1223 |
date timestamp(8) NOT NULL, |
1224 |
volumedesc varchar(255) default NULL, |
1225 |
publicationyear smallint(6) default '0', |
1226 |
place varchar(255) default NULL, |
1227 |
isbn varchar(10) default NULL, |
1228 |
mailoverseeing smallint(1) default '0', |
1229 |
biblionumber int(11) default NULL, |
1230 |
PRIMARY KEY (suggestionid), |
1231 |
KEY suggestedby (suggestedby), |
1232 |
KEY managedby (managedby) |
1233 |
) TYPE=MyISAM; |
1234 |
# -------------------------------------------------------- |
1235 |
|
1236 |
# |
1237 |
# Structure de la table `systempreferences` |
1238 |
# |
1239 |
|
1240 |
CREATE TABLE systempreferences ( |
1241 |
variable varchar(50) NOT NULL default '', |
1242 |
value text, |
1243 |
options text, |
1244 |
explanation varchar(80) default NULL, |
1245 |
type varchar(20) default NULL, |
1246 |
PRIMARY KEY (variable) |
1247 |
) TYPE=MyISAM; |
1248 |
# -------------------------------------------------------- |
1249 |
|
1250 |
# |
1251 |
# Structure de la table `uploadedmarc` |
1252 |
# |
1253 |
|
1254 |
CREATE TABLE uploadedmarc ( |
1255 |
id int(11) NOT NULL auto_increment, |
1256 |
marc longblob, |
1257 |
hidden smallint(6) default NULL, |
1258 |
name varchar(255) default NULL, |
1259 |
PRIMARY KEY (id) |
1260 |
) TYPE=MyISAM; |
1261 |
# -------------------------------------------------------- |
1262 |
|
1263 |
# |
1264 |
# Structure de la table `userflags` |
1265 |
# |
1266 |
|
1267 |
CREATE TABLE userflags ( |
1268 |
bit int(11) NOT NULL default '0', |
1269 |
flag char(30) default NULL, |
1270 |
flagdesc char(255) default NULL, |
1271 |
defaulton int(11) default NULL |
1272 |
) TYPE=MyISAM; |
1273 |
# -------------------------------------------------------- |
1274 |
|
1275 |
# |
1276 |
# Structure de la table `users` |
1277 |
# |
1278 |
|
1279 |
CREATE TABLE users ( |
1280 |
usercode varchar(10) default NULL, |
1281 |
username text, |
1282 |
password text, |
1283 |
level smallint(6) default NULL |
1284 |
) TYPE=MyISAM; |
1285 |
# -------------------------------------------------------- |
1286 |
|
1287 |
# |
1288 |
# Structure de la table `websites` |
1289 |
# |
1290 |
|
1291 |
CREATE TABLE websites ( |
1292 |
websitenumber int(11) NOT NULL auto_increment, |
1293 |
biblionumber int(11) NOT NULL default '0', |
1294 |
title text, |
1295 |
description text, |
1296 |
url varchar(255) default NULL, |
1297 |
PRIMARY KEY (websitenumber) |
1298 |
) TYPE=MyISAM; |
1299 |
# -------------------------------------------------------- |
1300 |
|
1301 |
# |
1302 |
# Structure de la table `z3950queue` |
1303 |
# |
1304 |
|
1305 |
CREATE TABLE z3950queue ( |
1306 |
id int(11) NOT NULL auto_increment, |
1307 |
term text, |
1308 |
type varchar(10) default NULL, |
1309 |
startdate int(11) default NULL, |
1310 |
enddate int(11) default NULL, |
1311 |
done smallint(6) default NULL, |
1312 |
results longblob, |
1313 |
numrecords int(11) default NULL, |
1314 |
servers text, |
1315 |
identifier varchar(30) default NULL, |
1316 |
PRIMARY KEY (id) |
1317 |
) TYPE=MyISAM; |
1318 |
# -------------------------------------------------------- |
1319 |
|
1320 |
# |
1321 |
# Structure de la table `z3950results` |
1322 |
# |
1323 |
|
1324 |
CREATE TABLE z3950results ( |
1325 |
id int(11) NOT NULL auto_increment, |
1326 |
queryid int(11) default NULL, |
1327 |
server varchar(255) default NULL, |
1328 |
startdate int(11) default NULL, |
1329 |
enddate int(11) default NULL, |
1330 |
results longblob, |
1331 |
numrecords int(11) default NULL, |
1332 |
numdownloaded int(11) default NULL, |
1333 |
highestseen int(11) default NULL, |
1334 |
active smallint(6) default NULL, |
1335 |
PRIMARY KEY (id), |
1336 |
UNIQUE KEY query_server (queryid,server) |
1337 |
) TYPE=MyISAM; |
1338 |
# -------------------------------------------------------- |
1339 |
|
1340 |
# |
1341 |
# Structure de la table `z3950servers` |
1342 |
# |
1343 |
|
1344 |
CREATE TABLE z3950servers ( |
1345 |
host varchar(255) default NULL, |
1346 |
port int(11) default NULL, |
1347 |
db varchar(255) default NULL, |
1348 |
userid varchar(255) default NULL, |
1349 |
password varchar(255) default NULL, |
1350 |
name text, |
1351 |
id int(11) NOT NULL auto_increment, |
1352 |
checked smallint(6) default NULL, |
1353 |
rank int(11) default NULL, |
1354 |
syntax varchar(80) default NULL, |
1355 |
PRIMARY KEY (id) |
1356 |
) TYPE=MyISAM; |
1357 |
|