1 # phpMyAdmin MySQL-Dump
3 # http://phpwizard.net/phpMyAdmin/
4 # http://phpmyadmin.sourceforge.net/ (download page)
7 # Generation Time: May 02, 2002 at 11:13 AM
8 # Server version: 3.23.47
10 # Database : `koha-rc1`
11 # --------------------------------------------------------
14 # Table structure for table `accountlines`
17 CREATE TABLE accountlines (
18 borrowernumber int(11) NOT NULL default '0',
19 accountno smallint(6) NOT NULL default '0',
20 itemnumber int(11) NOT NULL default '0',
21 date date default NULL,
22 amount decimal(26,6) default NULL,
25 accounttype varchar(5) default NULL,
26 amountoutstanding decimal(26,6) default NULL,
27 timestamp timestamp(14) NOT NULL,
28 PRIMARY KEY (borrowernumber,accountno,itemnumber),
29 KEY acctsborridx (borrowernumber),
30 KEY timeidx (timestamp)
31 ) TYPE=ISAM PACK_KEYS=1;
32 # --------------------------------------------------------
35 # Table structure for table `accountoffsets`
38 CREATE TABLE accountoffsets (
39 borrowernumber int(11) NOT NULL default '0',
40 accountno smallint(6) NOT NULL default '0',
41 offsetaccount smallint(6) NOT NULL default '0',
42 offsetamount decimal(26,6) default NULL,
43 timestamp timestamp(14) NOT NULL
44 ) TYPE=ISAM PACK_KEYS=1;
45 # --------------------------------------------------------
48 # Table structure for table `additionalauthors`
51 CREATE TABLE additionalauthors (
53 biblionumber int(11) NOT NULL default '0',
54 KEY bibidx (biblionumber),
55 FULLTEXT KEY authidx (author)
56 ) TYPE=MyISAM PACK_KEYS=1;
57 # --------------------------------------------------------
60 # Table structure for table `aqbookfund`
63 CREATE TABLE aqbookfund (
64 bookfundid varchar(5) NOT NULL default '',
66 bookfundgroup varchar(5) default NULL,
67 PRIMARY KEY (bookfundid)
68 ) TYPE=ISAM PACK_KEYS=1;
69 # --------------------------------------------------------
72 # Table structure for table `aqbooksellers`
75 CREATE TABLE aqbooksellers (
76 id int(11) NOT NULL default '0',
82 phone varchar(30) default NULL,
85 currency char(3) NOT NULL default '',
86 deliverydays smallint(6) default NULL,
87 followupdays smallint(6) default NULL,
88 followupscancel smallint(6) default NULL,
94 contact varchar(100) default NULL,
96 url varchar(255) default NULL,
97 contpos varchar(100) default NULL,
98 contphone varchar(100) default NULL,
99 contfax varchar(100) default NULL,
100 contaltphone varchar(100) default NULL,
101 contemail varchar(100) default NULL,
103 active tinyint(4) default NULL,
104 listprice varchar(5) default NULL,
105 invoiceprice varchar(5) default NULL,
106 gstreg tinyint(4) default NULL,
107 listincgst tinyint(4) default NULL,
108 invoiceincgst tinyint(4) default NULL,
109 discount float(6,4) default NULL,
110 fax varchar(50) default NULL,
111 nocalc tinyint(4) default NULL,
112 invoicedisc tinyint(4) default NULL,
114 ) TYPE=ISAM PACK_KEYS=1;
115 # --------------------------------------------------------
118 # Table structure for table `aqbudget`
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(11,2) default NULL,
126 PRIMARY KEY (bookfundid,bookfundid)
127 ) TYPE=ISAM PACK_KEYS=1;
128 # --------------------------------------------------------
131 # Table structure for table `aqorderbreakdown`
134 CREATE TABLE aqorderbreakdown (
135 ordernumber int(11) NOT NULL default '0',
136 linenumber int(11) NOT NULL default '0',
137 branchcode char(4) NOT NULL default '',
138 bookfundid char(5) NOT NULL default '',
139 allocation smallint(6) default NULL
140 ) TYPE=ISAM PACK_KEYS=1;
141 # --------------------------------------------------------
144 # Table structure for table `aqorderdelivery`
147 CREATE TABLE aqorderdelivery (
148 ordernumber date NOT NULL default '0000-00-00',
149 deliverynumber smallint(6) NOT NULL default '0',
150 deliverydate varchar(18) default NULL,
151 qtydelivered smallint(6) default NULL,
152 deliverycomments text,
153 PRIMARY KEY (ordernumber)
154 ) TYPE=ISAM PACK_KEYS=1;
155 # --------------------------------------------------------
158 # Table structure for table `aqorders`
161 CREATE TABLE aqorders (
162 ordernumber int(11) NOT NULL auto_increment,
163 biblionumber int(11) default NULL,
165 requisitionedby varchar(10) default NULL,
166 authorisedby varchar(10) default NULL,
167 booksellerid varchar(10) NOT NULL default '',
168 deliverydays smallint(6) default NULL,
169 followupdays smallint(6) default NULL,
170 numberfollowupsallowed smallint(6) default NULL,
171 numberfollowupssent smallint(6) default NULL,
172 entrydate date default NULL,
173 dateprinted date default NULL,
174 quantity smallint(6) default NULL,
175 currency char(3) default NULL,
176 listprice decimal(26,6) default NULL,
177 totalamount decimal(26,6) default NULL,
178 datereceived date default NULL,
179 booksellerinvoicenumber text,
180 freight decimal(26,6) default NULL,
181 unitprice decimal(26,6) default NULL,
182 quantityreceived smallint(6) default NULL,
184 cancelledby varchar(10) default NULL,
185 quantityreceiveddamaged smallint(6) default NULL,
186 datecancellationprinted date default NULL,
188 supplierreference text,
189 purchaseordernumber text,
190 subscription tinyint(1) default NULL,
191 subscriptionfrom date default NULL,
192 subscriptionto date default NULL,
193 serialid varchar(30) default NULL,
194 basketno int(11) default NULL,
195 biblioitemnumber int(11) default NULL,
196 timestamp timestamp(14) NOT NULL,
197 rrp decimal(11,2) default NULL,
198 ecost decimal(11,2) default NULL,
199 gst decimal(11,2) default NULL,
200 budgetdate date default NULL,
201 PRIMARY KEY (ordernumber)
202 ) TYPE=ISAM PACK_KEYS=1;
203 # --------------------------------------------------------
206 # Table structure for table `biblio`
209 CREATE TABLE biblio (
210 biblionumber int(11) NOT NULL default '0',
215 serial tinyint(1) default NULL,
217 copyrightdate smallint(6) default NULL,
218 timestamp timestamp(14) NOT NULL,
219 PRIMARY KEY (biblionumber),
220 KEY blbnoidx (biblionumber),
221 FULLTEXT KEY authidx (author)
222 ) TYPE=MyISAM PACK_KEYS=1;
223 # --------------------------------------------------------
226 # Table structure for table `biblioanalysis`
229 CREATE TABLE biblioanalysis (
230 analyticaltitle text,
231 biblionumber int(11) NOT NULL default '0',
232 analyticalauthor text
233 ) TYPE=ISAM PACK_KEYS=1;
234 # --------------------------------------------------------
237 # Table structure for table `biblioitems`
240 CREATE TABLE biblioitems (
241 biblioitemnumber int(11) NOT NULL default '0',
242 biblionumber int(11) NOT NULL default '0',
245 classification varchar(25) default NULL,
246 itemtype varchar(4) default NULL,
247 isbn varchar(14) default NULL,
248 issn varchar(9) default NULL,
249 dewey double(8,6) default NULL,
250 subclass char(3) default NULL,
251 publicationyear smallint(6) default NULL,
252 publishercode varchar(255) default NULL,
253 volumedate date default NULL,
254 volumeddesc varchar(255) default NULL,
255 timestamp timestamp(14) NOT NULL,
256 illus varchar(255) default NULL,
257 pages varchar(255) default NULL,
259 size varchar(255) default NULL,
260 place varchar(255) default NULL,
261 PRIMARY KEY (biblionumber,biblioitemnumber),
262 KEY bibinoidx (biblioitemnumber),
263 KEY bibnoidx (biblionumber)
264 ) TYPE=ISAM PACK_KEYS=1;
265 # --------------------------------------------------------
268 # Table structure for table `bibliosubject`
271 CREATE TABLE bibliosubject (
272 subject text NOT NULL,
273 biblionumber int(11) NOT NULL default '0'
274 ) TYPE=ISAM PACK_KEYS=1;
275 # --------------------------------------------------------
278 # Table structure for table `bibliosubtitle`
281 CREATE TABLE bibliosubtitle (
282 subtitle text NOT NULL,
283 biblionumber int(11) NOT NULL default '0',
284 KEY bibsubidx (biblionumber)
285 ) TYPE=ISAM PACK_KEYS=1;
286 # --------------------------------------------------------
289 # Table structure for table `borexp`
292 CREATE TABLE borexp (
293 borrowernumber int(11) NOT NULL default '0',
294 newexp date NOT NULL default '0000-00-00'
295 ) TYPE=ISAM PACK_KEYS=1;
296 # --------------------------------------------------------
299 # Table structure for table `borrowers`
302 CREATE TABLE borrowers (
303 borrowernumber int(11) NOT NULL default '0',
304 cardnumber varchar(9) NOT NULL default '',
305 surname text NOT NULL,
306 firstname text NOT NULL,
309 initials text NOT NULL,
310 streetaddress text NOT NULL,
316 altstreetaddress text,
320 dateofbirth date default NULL,
321 branchcode varchar(4) NOT NULL default '',
322 categorycode char(2) default NULL,
323 dateenrolled date default NULL,
324 gonenoaddress tinyint(1) default NULL,
325 lost tinyint(1) default NULL,
326 debarred tinyint(1) default NULL,
331 guarantor int(11) default NULL,
332 area char(2) default NULL,
333 ethnicity varchar(50) default NULL,
334 ethnotes varchar(255) default NULL,
335 sex char(1) default NULL,
336 expiry date default NULL,
337 altnotes varchar(255) default NULL,
338 altrelationship varchar(100) default NULL,
340 phoneday varchar(50) default NULL,
341 preferredcont char(1) default NULL,
342 physstreet varchar(100) default NULL,
343 KEY borrowernumber (borrowernumber),
344 KEY cardnumber (cardnumber)
345 ) TYPE=ISAM PACK_KEYS=1;
346 # --------------------------------------------------------
349 # Table structure for table `branches`
352 CREATE TABLE branches (
353 branchcode varchar(4) NOT NULL default '',
354 branchname text NOT NULL,
361 issuing tinyint(4) default NULL,
362 PRIMARY KEY (branchcode)
363 ) TYPE=ISAM PACK_KEYS=1;
364 # --------------------------------------------------------
367 # Table structure for table `branchtransfers`
370 CREATE TABLE branchtransfers (
371 itemnumber int(11) NOT NULL default '0',
372 datesent date NOT NULL default '0000-00-00',
373 frombranch varchar(4) default NULL,
374 datearrived date default NULL,
375 tobranch varchar(4) default NULL,
377 ) TYPE=ISAM PACK_KEYS=1;
378 # --------------------------------------------------------
381 # Table structure for table `catalogueentry`
384 CREATE TABLE catalogueentry (
385 catalogueentry text NOT NULL,
386 entrytype char(2) default NULL,
390 biblionumber int(11) default NULL
391 ) TYPE=ISAM PACK_KEYS=1;
392 # --------------------------------------------------------
395 # Table structure for table `categories`
398 CREATE TABLE categories (
399 categorycode char(2) NOT NULL default '',
401 enrolmentperiod smallint(6) default NULL,
402 upperagelimit smallint(6) default NULL,
403 dateofbirthrequired tinyint(1) default NULL,
404 finetype varchar(30) default NULL,
405 bulk tinyint(1) default NULL,
406 enrolmentfee decimal(26,6) default NULL,
407 overduenoticerequired tinyint(1) default NULL,
408 issuelimit smallint(6) default NULL,
409 reservefee decimal(26,6) default NULL,
410 PRIMARY KEY (categorycode)
411 ) TYPE=ISAM PACK_KEYS=1;
412 # --------------------------------------------------------
415 # Table structure for table `categoryitem`
418 CREATE TABLE categoryitem (
419 categorycode char(2) NOT NULL default '',
420 itemtype varchar(4) NOT NULL default '',
421 restrictedtype tinyint(1) default NULL,
422 rentaldiscount decimal(26,6) default NULL,
423 reservecharge decimal(26,6) default NULL,
424 fine decimal(26,6) default NULL,
425 firstremind int(11) default NULL,
426 chargeperiod int(11) default NULL,
427 accountsent int(11) default NULL,
428 chargename varchar(100) default NULL,
429 PRIMARY KEY (categorycode,itemtype)
430 ) TYPE=ISAM PACK_KEYS=1;
431 # --------------------------------------------------------
434 # Table structure for table `currency`
437 CREATE TABLE currency (
438 currency varchar(10) NOT NULL default '',
439 rate float(7,5) NOT NULL default '0.00000',
440 PRIMARY KEY (currency)
441 ) TYPE=ISAM PACK_KEYS=1;
442 # --------------------------------------------------------
445 # Table structure for table `deletedbiblio`
448 CREATE TABLE deletedbiblio (
449 biblionumber int(11) NOT NULL default '0',
454 serial tinyint(1) default NULL,
456 copyrightdate smallint(6) default NULL,
457 timestamp timestamp(14) NOT NULL,
458 PRIMARY KEY (biblionumber,biblionumber),
459 KEY blbnoidx (biblionumber)
460 ) TYPE=ISAM PACK_KEYS=1;
461 # --------------------------------------------------------
464 # Table structure for table `deletedbiblioitems`
467 CREATE TABLE deletedbiblioitems (
468 biblioitemnumber int(11) NOT NULL default '0',
469 biblionumber int(11) NOT NULL default '0',
472 classification varchar(25) default NULL,
473 itemtype varchar(4) default NULL,
474 isbn varchar(14) default NULL,
475 issn varchar(9) default NULL,
476 dewey double(8,6) default NULL,
477 subclass char(3) default NULL,
478 publicationyear smallint(6) default NULL,
479 publishercode varchar(255) default NULL,
480 volumedate date default NULL,
481 volumeddesc varchar(255) default NULL,
482 timestamp timestamp(14) NOT NULL,
483 illus varchar(255) default NULL,
484 pages varchar(255) default NULL,
486 size varchar(255) default NULL,
487 PRIMARY KEY (biblioitemnumber),
488 KEY bibinoidx (biblioitemnumber),
489 KEY bibnoidx (biblionumber)
490 ) TYPE=ISAM PACK_KEYS=1;
491 # --------------------------------------------------------
494 # Table structure for table `deletedborrowers`
497 CREATE TABLE deletedborrowers (
498 borrowernumber int(11) NOT NULL default '0',
499 cardnumber varchar(9) NOT NULL default '',
500 surname text NOT NULL,
501 firstname text NOT NULL,
504 initials text NOT NULL,
505 streetaddress text NOT NULL,
511 altstreetaddress text,
515 dateofbirth date default NULL,
516 branchcode varchar(4) NOT NULL default '',
517 categorycode char(2) default NULL,
518 dateenrolled date default NULL,
519 gonenoaddress tinyint(1) default NULL,
520 lost tinyint(1) default NULL,
521 debarred tinyint(1) default NULL,
526 guarantor int(11) default NULL,
527 area char(2) default NULL,
528 ethnicity varchar(50) default NULL,
529 ethnotes varchar(255) default NULL,
530 sex char(1) default NULL,
531 expiry date default NULL,
532 altnotes varchar(255) default NULL,
533 altrelationship varchar(100) default NULL,
535 phoneday varchar(50) default NULL,
536 preferredcont varchar(100) default NULL,
537 physstreet varchar(100) default NULL,
538 PRIMARY KEY (borrowernumber),
539 KEY borrowernumber (borrowernumber),
540 KEY cardnumber (cardnumber)
541 ) TYPE=ISAM PACK_KEYS=1;
542 # --------------------------------------------------------
545 # Table structure for table `deleteditems`
548 CREATE TABLE deleteditems (
549 itemnumber int(11) NOT NULL default '0',
550 biblionumber int(11) NOT NULL default '0',
551 multivolumepart varchar(30) default NULL,
552 biblioitemnumber int(11) NOT NULL default '0',
553 barcode varchar(9) NOT NULL default '',
554 dateaccessioned date default NULL,
555 booksellerid varchar(10) default NULL,
556 homebranch varchar(4) default NULL,
557 price decimal(26,6) default NULL,
558 replacementprice decimal(26,6) default NULL,
559 replacementpricedate date default NULL,
560 datelastborrowed date default NULL,
561 datelastseen date default NULL,
562 multivolume tinyint(1) default NULL,
563 stack tinyint(1) default NULL,
564 notforloan tinyint(1) default NULL,
565 itemlost tinyint(1) default NULL,
566 wthdrawn tinyint(1) default NULL,
567 bulk varchar(30) default NULL,
568 issues smallint(6) default NULL,
569 renewals smallint(6) default NULL,
570 reserves smallint(6) default NULL,
571 restricted tinyint(1) default NULL,
572 binding decimal(26,6) default NULL,
574 holdingbranch varchar(4) default NULL,
575 interim tinyint(1) default NULL,
576 timestamp timestamp(14) NOT NULL,
577 PRIMARY KEY (itemnumber),
578 UNIQUE KEY barcode (barcode),
579 KEY itembarcodeidx (barcode),
580 KEY itembinoidx (biblioitemnumber),
581 KEY itembibnoidx (biblionumber)
582 ) TYPE=ISAM PACK_KEYS=1;
583 # --------------------------------------------------------
586 # Table structure for table `issues`
589 CREATE TABLE issues (
590 borrowernumber int(11) NOT NULL default '0',
591 itemnumber int(11) NOT NULL default '0',
592 date_due date NOT NULL default '0000-00-00',
593 branchcode char(4) default NULL,
594 issuingbranch char(18) default NULL,
595 returndate date default NULL,
596 lastreneweddate date default NULL,
597 return char(4) default NULL,
598 renewals tinyint(4) default NULL,
599 timestamp timestamp(14) NOT NULL,
600 KEY issuesborridx (borrowernumber),
601 KEY issuesitemidx (itemnumber),
602 KEY bordate (borrowernumber,timestamp)
603 ) TYPE=ISAM PACK_KEYS=1;
604 # --------------------------------------------------------
607 # Table structure for table `items`
611 itemnumber int(11) NOT NULL default '0',
612 biblionumber int(11) NOT NULL default '0',
613 multivolumepart varchar(30) default NULL,
614 biblioitemnumber int(11) NOT NULL default '0',
615 barcode varchar(9) NOT NULL default '',
616 dateaccessioned date default NULL,
617 booksellerid varchar(10) default NULL,
618 homebranch varchar(4) default NULL,
619 price decimal(6,2) default NULL,
620 replacementprice decimal(6,2) default NULL,
621 replacementpricedate date default NULL,
622 datelastborrowed date default NULL,
623 datelastseen date default NULL,
624 multivolume tinyint(1) default NULL,
625 stack tinyint(1) default NULL,
626 notforloan tinyint(1) default NULL,
627 itemlost tinyint(1) default NULL,
628 wthdrawn tinyint(1) default NULL,
629 bulk varchar(30) default NULL,
630 issues smallint(6) default NULL,
631 renewals smallint(6) default NULL,
632 reserves smallint(6) default NULL,
633 restricted tinyint(1) default NULL,
634 binding decimal(26,6) default NULL,
636 holdingbranch varchar(4) default NULL,
638 timestamp timestamp(14) NOT NULL,
639 PRIMARY KEY (itemnumber),
640 UNIQUE KEY barcode (barcode),
641 KEY itembarcodeidx (barcode),
642 KEY itembinoidx (biblioitemnumber),
643 KEY itembibnoidx (biblionumber)
644 ) TYPE=ISAM PACK_KEYS=1;
645 # --------------------------------------------------------
648 # Table structure for table `itemsprices`
651 CREATE TABLE itemsprices (
652 itemnumber int(11) NOT NULL default '0',
653 price1 decimal(26,6) default NULL,
654 price2 decimal(26,6) default NULL,
655 PRIMARY KEY (itemnumber)
656 ) TYPE=ISAM PACK_KEYS=1;
657 # --------------------------------------------------------
660 # Table structure for table `itemtypes`
663 CREATE TABLE itemtypes (
664 itemtype varchar(4) NOT NULL default '',
666 loanlength smallint(6) default NULL,
667 renewalsallowed smallint(6) default NULL,
668 rentalcharge double(16,4) default NULL,
669 PRIMARY KEY (itemtype)
670 ) TYPE=ISAM PACK_KEYS=1;
671 # --------------------------------------------------------
674 # Table structure for table `printers`
677 CREATE TABLE printers (
678 printername char(40) NOT NULL default '',
679 printqueue char(20) default NULL,
680 printtype char(20) default NULL,
681 PRIMARY KEY (printername)
682 ) TYPE=ISAM PACK_KEYS=1;
683 # --------------------------------------------------------
686 # Table structure for table `reserveconstraints`
689 CREATE TABLE reserveconstraints (
690 borrowernumber int(11) NOT NULL default '0',
691 reservedate date NOT NULL default '0000-00-00',
692 biblionumber int(11) NOT NULL default '0',
693 biblioitemnumber int(11) default NULL,
694 timestamp timestamp(14) NOT NULL
695 ) TYPE=ISAM PACK_KEYS=1;
696 # --------------------------------------------------------
699 # Table structure for table `reserves`
702 CREATE TABLE reserves (
703 borrowernumber int(11) NOT NULL default '0',
704 reservedate date NOT NULL default '0000-00-00',
705 biblionumber int(11) NOT NULL default '0',
706 constrainttype char(1) default NULL,
707 branchcode varchar(4) default NULL,
708 notificationdate date default NULL,
709 reminderdate date default NULL,
710 cancellationdate date default NULL,
712 priority smallint(6) default NULL,
713 found char(1) default NULL,
714 timestamp timestamp(14) NOT NULL,
715 itemnumber int(11) default NULL
716 ) TYPE=ISAM PACK_KEYS=1;
717 # --------------------------------------------------------
720 # Table structure for table `statistics`
723 CREATE TABLE statistics (
724 datetime datetime NOT NULL default '0000-00-00 00:00:00',
725 branch varchar(4) default NULL,
726 proccode varchar(4) default NULL,
727 value double(16,4) default NULL,
728 type varchar(16) default NULL,
730 usercode varchar(10) default NULL,
731 itemnumber int(11) default NULL,
732 itemtype varchar(4) default NULL,
733 borrowernumber int(11) default NULL,
734 KEY timeidx (datetime)
735 ) TYPE=ISAM PACK_KEYS=1;
736 # --------------------------------------------------------
739 # Table structure for table `stopwords`
742 CREATE TABLE stopwords (
743 word varchar(255) NOT NULL default '',
745 ) TYPE=ISAM PACK_KEYS=1;
746 # --------------------------------------------------------
749 # Table structure for table `systempreferences`
752 CREATE TABLE systempreferences (
753 variable char(50) NOT NULL default '',
754 value char(200) default NULL,
755 PRIMARY KEY (variable)
756 ) TYPE=ISAM PACK_KEYS=1;
757 # --------------------------------------------------------
760 # Table structure for table `users`
764 usercode varchar(10) NOT NULL default '',
767 level smallint(6) default NULL,
768 PRIMARY KEY (usercode)
769 ) TYPE=ISAM PACK_KEYS=1;