3 # Host: localhost Database: dombes
4 #-------------------------------------------------------
5 # Server version 3.23.52-log
8 # Table structure for table 'accountlines'
11 CREATE TABLE `accountlines` (
12 `borrowernumber` int(11) NOT NULL default '0',
13 `accountno` smallint(6) NOT NULL default '0',
14 `itemnumber` int(11) default NULL,
15 `date` date default NULL,
16 `amount` decimal(28,6) default NULL,
19 `accounttype` varchar(5) default NULL,
20 `amountoutstanding` decimal(28,6) default NULL,
21 `timestamp` timestamp(14) NOT NULL,
22 KEY `acctsborridx` (`borrowernumber`),
23 KEY `timeidx` (`timestamp`)
27 # Table structure for table 'accountoffsets'
30 CREATE TABLE `accountoffsets` (
31 `borrowernumber` int(11) NOT NULL default '0',
32 `accountno` smallint(6) NOT NULL default '0',
33 `offsetaccount` smallint(6) NOT NULL default '0',
34 `offsetamount` decimal(28,6) default NULL,
35 `timestamp` timestamp(14) NOT NULL
39 # Table structure for table 'additionalauthors'
42 CREATE TABLE `additionalauthors` (
43 `author` text NOT NULL,
44 `biblionumber` int(11) NOT NULL default '0',
45 KEY `bibidx` (`biblionumber`)
49 # Table structure for table 'aqbookfund'
52 CREATE TABLE `aqbookfund` (
53 `bookfundid` varchar(5) NOT NULL default '',
55 `bookfundgroup` varchar(5) default NULL
59 # Table structure for table 'aqbooksellers'
62 CREATE TABLE `aqbooksellers` (
63 `id` int(11) default NULL,
69 `phone` varchar(30) default NULL,
72 `currency` char(3) NOT NULL default '',
73 `deliverydays` smallint(6) default NULL,
74 `followupdays` smallint(6) default NULL,
75 `followupscancel` smallint(6) default NULL,
79 `bookselleremail` text,
81 `contact` varchar(100) default NULL,
83 `url` varchar(255) default NULL,
84 `contpos` varchar(100) default NULL,
85 `contphone` varchar(100) default NULL,
86 `contfax` varchar(100) default NULL,
87 `contaltphone` varchar(100) default NULL,
88 `contemail` varchar(100) default NULL,
90 `active` tinyint(4) default NULL,
91 `listprice` varchar(5) default NULL,
92 `invoiceprice` varchar(5) default NULL,
93 `gstreg` tinyint(4) default NULL,
94 `listincgst` tinyint(4) default NULL,
95 `invoiceincgst` tinyint(4) default NULL,
96 `discount` float(6,4) default NULL,
97 `fax` varchar(50) default NULL
101 # Table structure for table 'aqbudget'
104 CREATE TABLE `aqbudget` (
105 `bookfundid` char(5) NOT NULL default '',
106 `startdate` date NOT NULL default '0000-00-00',
107 `enddate` date default NULL,
108 `budgetamount` decimal(13,2) default NULL
112 # Table structure for table 'aqorderbreakdown'
115 CREATE TABLE `aqorderbreakdown` (
116 `ordernumber` int(11) default NULL,
117 `linenumber` int(11) default NULL,
118 `branchcode` char(4) default NULL,
119 `bookfundid` char(5) NOT NULL default '',
120 `allocation` smallint(6) default NULL
124 # Table structure for table 'aqorderdelivery'
127 CREATE TABLE `aqorderdelivery` (
128 `ordernumber` date NOT NULL default '0000-00-00',
129 `deliverynumber` smallint(6) NOT NULL default '0',
130 `deliverydate` varchar(18) default NULL,
131 `qtydelivered` smallint(6) default NULL,
132 `deliverycomments` text
136 # Table structure for table 'aqorders'
139 CREATE TABLE `aqorders` (
140 `ordernumber` int(11) NOT NULL auto_increment,
141 `biblionumber` int(11) default NULL,
143 `requisitionedby` varchar(10) default NULL,
144 `authorisedby` varchar(10) default NULL,
145 `booksellerid` varchar(10) NOT NULL default '',
146 `deliverydays` smallint(6) default NULL,
147 `followupdays` smallint(6) default NULL,
148 `numberfollowupsallowed` smallint(6) default NULL,
149 `numberfollowupssent` smallint(6) default NULL,
150 `entrydate` date default NULL,
151 `dateprinted` date default NULL,
152 `quantity` smallint(6) default NULL,
153 `currency` char(3) default NULL,
154 `listprice` decimal(28,6) default NULL,
155 `totalamount` decimal(28,6) default NULL,
156 `datereceived` date default NULL,
157 `booksellerinvoicenumber` text,
158 `freight` decimal(28,6) default NULL,
159 `unitprice` decimal(28,6) default NULL,
160 `quantityreceived` smallint(6) default NULL,
162 `cancelledby` varchar(10) default NULL,
163 `quantityreceiveddamaged` smallint(6) default NULL,
164 `datecancellationprinted` date default NULL,
166 `supplierreference` text,
167 `purchaseordernumber` text,
168 `subscription` tinyint(1) default NULL,
169 `subscriptionfrom` date default NULL,
170 `subscriptionto` date default NULL,
171 `serialid` varchar(30) default NULL,
172 `basketno` int(11) default NULL,
173 `biblioitemnumber` int(11) default NULL,
174 `timestamp` timestamp(14) NOT NULL,
175 `rrp` decimal(13,2) default NULL,
176 `ecost` decimal(13,2) default NULL,
177 `gst` decimal(13,2) default NULL,
178 PRIMARY KEY (`ordernumber`)
182 # Table structure for table 'biblio'
185 CREATE TABLE `biblio` (
186 `biblionumber` int(11) NOT NULL default '0',
191 `serial` tinyint(1) default NULL,
193 `copyrightdate` smallint(6) default NULL,
194 `timestamp` timestamp(14) NOT NULL,
195 PRIMARY KEY (`biblionumber`),
196 KEY `blbnoidx` (`biblionumber`)
200 # Table structure for table 'biblioanalysis'
203 CREATE TABLE `biblioanalysis` (
204 `analyticaltitle` text,
205 `biblionumber` int(11) NOT NULL default '0',
206 `analyticalauthor` text
210 # Table structure for table 'biblioitems'
213 CREATE TABLE `biblioitems` (
214 `biblioitemnumber` int(11) NOT NULL default '0',
215 `biblionumber` int(11) NOT NULL default '0',
218 `classification` varchar(25) default NULL,
219 `itemtype` varchar(4) default NULL,
220 `isbn` varchar(14) default NULL,
221 `issn` varchar(9) default NULL,
222 `dewey` double(8,6) default NULL,
223 `subclass` char(3) default NULL,
224 `publicationyear` smallint(6) default NULL,
225 `publishercode` varchar(255) default NULL,
226 `volumedate` date default NULL,
227 `volumeddesc` varchar(255) default NULL,
228 `timestamp` timestamp(14) NOT NULL,
229 `illus` varchar(255) default NULL,
230 `pages` varchar(255) default NULL,
232 `size` varchar(255) default NULL,
233 `place` varchar(255) default NULL,
234 PRIMARY KEY (`biblioitemnumber`),
235 KEY `bibinoidx` (`biblioitemnumber`),
236 KEY `bibnoidx` (`biblionumber`)
240 # Table structure for table 'bibliosubject'
243 CREATE TABLE `bibliosubject` (
244 `subject` text NOT NULL,
245 `biblionumber` int(11) NOT NULL default '0'
249 # Table structure for table 'bibliosubtitle'
252 CREATE TABLE `bibliosubtitle` (
253 `subtitle` text NOT NULL,
254 `biblionumber` int(11) NOT NULL default '0',
255 KEY `bibsubidx` (`biblionumber`)
259 # Table structure for table 'borexp'
262 CREATE TABLE `borexp` (
263 `borrowernumber` int(11) default NULL,
264 `newexp` date default NULL
268 # Table structure for table 'borrowers'
271 CREATE TABLE `borrowers` (
272 `borrowernumber` int(11) NOT NULL default '0',
273 `cardnumber` varchar(16) NOT NULL default '',
274 `surname` text NOT NULL,
275 `firstname` text NOT NULL,
278 `initials` text NOT NULL,
279 `streetaddress` text NOT NULL,
281 `city` text NOT NULL,
282 `phone` text NOT NULL,
285 `textmessaging` text,
286 `altstreetaddress` text,
290 `dateofbirth` date default NULL,
291 `branchcode` varchar(4) NOT NULL default '',
292 `categorycode` char(2) default NULL,
293 `dateenrolled` date default NULL,
294 `gonenoaddress` tinyint(1) default NULL,
295 `lost` tinyint(1) default NULL,
296 `debarred` tinyint(1) default NULL,
297 `studentnumber` text,
300 `borrowernotes` text,
301 `guarantor` int(11) default NULL,
302 `area` char(2) default NULL,
303 `ethnicity` varchar(50) default NULL,
304 `ethnotes` varchar(255) default NULL,
305 `sex` char(1) default NULL,
306 `expiry` date default NULL,
307 `altnotes` varchar(255) default NULL,
308 `altrelationship` varchar(100) default NULL,
310 `phoneday` varchar(50) default NULL,
311 `preferredcont` char(1) default NULL,
312 `physstreet` varchar(100) default NULL,
313 KEY `borrowernumber` (`borrowernumber`),
314 UNIQUE KEY `cardnumber` (`cardnumber`)
318 # Table structure for table 'branchcategories'
321 CREATE TABLE `branchcategories` (
322 `categorycode` char(2) NOT NULL default '',
323 `branchcode` char(4) NOT NULL default '',
324 `branchholding` int(11) default NULL
328 # Table structure for table 'branches'
331 CREATE TABLE `branches` (
332 `branchcode` varchar(4) NOT NULL default '',
333 `branchname` text NOT NULL,
334 `branchaddress1` text,
335 `branchaddress2` text,
336 `branchaddress3` text,
340 `issuing` tinyint(4) default NULL,
341 UNIQUE KEY `branchcode` (`branchcode`)
345 # Table structure for table 'branchtransfers'
348 CREATE TABLE `branchtransfers` (
349 `itemnumber` int(11) NOT NULL default '0',
350 `datesent` date NOT NULL default '0000-00-00',
351 `frombranch` varchar(4) default NULL,
352 `datearrived` date default NULL,
353 `tobranch` varchar(4) default NULL,
358 # Table structure for table 'catalogueentry'
361 CREATE TABLE `catalogueentry` (
362 `catalogueentry` text NOT NULL,
363 `entrytype` char(2) default NULL,
367 `biblionumber` int(11) default NULL
371 # Table structure for table 'categories'
374 CREATE TABLE `categories` (
375 `categorycode` char(2) NOT NULL default '',
377 `enrolmentperiod` smallint(6) default NULL,
378 `upperagelimit` smallint(6) default NULL,
379 `dateofbirthrequired` tinyint(1) default NULL,
380 `finetype` varchar(30) default NULL,
381 `bulk` tinyint(1) default NULL,
382 `enrolmentfee` decimal(28,6) default NULL,
383 `overduenoticerequired` tinyint(1) default NULL,
384 `issuelimit` smallint(6) default NULL,
385 `reservefee` decimal(28,6) default NULL,
386 UNIQUE KEY `categorycode` (`categorycode`)
390 # Table structure for table 'categoryitem'
393 CREATE TABLE `categoryitem` (
394 `categorycode` char(2) NOT NULL default '',
395 `itemtype` varchar(4) NOT NULL default '',
396 `restrictedtype` tinyint(1) default NULL,
397 `rentaldiscount` decimal(28,6) default NULL,
398 `reservecharge` decimal(28,6) default NULL,
399 `fine` decimal(28,6) default NULL,
400 `firstremind` int(11) default NULL,
401 `chargeperiod` int(11) default NULL,
402 `accountsent` int(11) default NULL,
403 `chargename` varchar(100) default NULL
407 # Table structure for table 'classification'
410 CREATE TABLE `classification` (
411 `classification` varchar(12) NOT NULL default ''
415 # Table structure for table 'currency'
418 CREATE TABLE `currency` (
419 `currency` varchar(10) default NULL,
420 `rate` float(7,5) default NULL
424 # Table structure for table 'deletedbiblio'
427 CREATE TABLE `deletedbiblio` (
428 `biblionumber` int(11) NOT NULL default '0',
433 `serial` tinyint(1) default NULL,
435 `copyrightdate` smallint(6) default NULL,
436 `timestamp` timestamp(14) NOT NULL,
437 PRIMARY KEY (`biblionumber`),
438 KEY `blbnoidx` (`biblionumber`)
442 # Table structure for table 'deletedbiblioitems'
445 CREATE TABLE `deletedbiblioitems` (
446 `biblioitemnumber` int(11) NOT NULL default '0',
447 `biblionumber` int(11) NOT NULL default '0',
450 `classification` varchar(25) default NULL,
451 `itemtype` varchar(4) default NULL,
452 `isbn` varchar(14) default NULL,
453 `issn` varchar(9) default NULL,
454 `dewey` double(8,6) default NULL,
455 `subclass` char(3) default NULL,
456 `publicationyear` smallint(6) default NULL,
457 `publishercode` varchar(255) default NULL,
458 `volumedate` date default NULL,
459 `volumeddesc` varchar(255) default NULL,
460 `timestamp` timestamp(14) NOT NULL,
461 `illus` varchar(255) default NULL,
462 `pages` varchar(255) default NULL,
464 `size` varchar(255) default NULL,
465 PRIMARY KEY (`biblioitemnumber`),
466 KEY `bibinoidx` (`biblioitemnumber`),
467 KEY `bibnoidx` (`biblionumber`)
471 # Table structure for table 'deletedborrowers'
474 CREATE TABLE `deletedborrowers` (
475 `borrowernumber` int(11) NOT NULL default '0',
476 `cardnumber` varchar(9) NOT NULL default '',
477 `surname` text NOT NULL,
478 `firstname` text NOT NULL,
481 `initials` text NOT NULL,
482 `streetaddress` text NOT NULL,
484 `city` text NOT NULL,
485 `phone` text NOT NULL,
488 `altstreetaddress` text,
492 `dateofbirth` date default NULL,
493 `branchcode` varchar(4) NOT NULL default '',
494 `categorycode` char(2) default NULL,
495 `dateenrolled` date default NULL,
496 `gonenoaddress` tinyint(1) default NULL,
497 `lost` tinyint(1) default NULL,
498 `debarred` tinyint(1) default NULL,
499 `studentnumber` text,
502 `borrowernotes` text,
503 `guarantor` int(11) default NULL,
504 `area` char(2) default NULL,
505 `ethnicity` varchar(50) default NULL,
506 `ethnotes` varchar(255) default NULL,
507 `sex` char(1) default NULL,
508 `expiry` date default NULL,
509 `altnotes` varchar(255) default NULL,
510 `altrelationship` varchar(100) default NULL,
512 `phoneday` varchar(50) default NULL,
513 `preferredcont` varchar(100) default NULL,
514 `physstreet` varchar(100) default NULL,
515 KEY `borrowernumber` (`borrowernumber`),
516 KEY `cardnumber` (`cardnumber`)
520 # Table structure for table 'deleteditems'
523 CREATE TABLE `deleteditems` (
524 `itemnumber` int(11) NOT NULL default '0',
525 `biblionumber` int(11) NOT NULL default '0',
526 `multivolumepart` varchar(30) default NULL,
527 `biblioitemnumber` int(11) NOT NULL default '0',
528 `barcode` varchar(9) NOT NULL default '',
529 `dateaccessioned` date default NULL,
530 `booksellerid` varchar(10) default NULL,
531 `homebranch` varchar(4) default NULL,
532 `price` decimal(28,6) default NULL,
533 `replacementprice` decimal(28,6) default NULL,
534 `replacementpricedate` date default NULL,
535 `datelastborrowed` date default NULL,
536 `datelastseen` date default NULL,
537 `multivolume` tinyint(1) default NULL,
538 `stack` tinyint(1) default NULL,
539 `notforloan` tinyint(1) default NULL,
540 `itemlost` tinyint(1) default NULL,
541 `wthdrawn` tinyint(1) default NULL,
542 `bulk` varchar(30) default NULL,
543 `issues` smallint(6) default NULL,
544 `renewals` smallint(6) default NULL,
545 `reserves` smallint(6) default NULL,
546 `restricted` tinyint(1) default NULL,
547 `binding` decimal(28,6) default NULL,
549 `holdingbranch` varchar(4) default NULL,
550 `interim` tinyint(1) default NULL,
551 `timestamp` timestamp(14) NOT NULL,
552 PRIMARY KEY (`itemnumber`),
553 UNIQUE KEY `barcode` (`barcode`),
554 KEY `itembarcodeidx` (`barcode`),
555 KEY `itembinoidx` (`biblioitemnumber`),
556 KEY `itembibnoidx` (`biblionumber`)
560 # Table structure for table 'issues'
563 CREATE TABLE `issues` (
564 `borrowernumber` int(11) NOT NULL default '0',
565 `itemnumber` int(11) NOT NULL default '0',
566 `date_due` date default NULL,
567 `branchcode` char(4) default NULL,
568 `issuingbranch` char(18) default NULL,
569 `returndate` date default NULL,
570 `lastreneweddate` date default NULL,
571 `return` char(4) default NULL,
572 `renewals` tinyint(4) default NULL,
573 `timestamp` timestamp(14) NOT NULL,
574 KEY `issuesborridx` (`borrowernumber`),
575 KEY `issuesitemidx` (`itemnumber`),
576 KEY `bordate` (`borrowernumber`,`timestamp`)
580 # Table structure for table 'items'
583 CREATE TABLE `items` (
584 `itemnumber` int(11) NOT NULL default '0',
585 `biblionumber` int(11) NOT NULL default '0',
586 `multivolumepart` varchar(30) default NULL,
587 `biblioitemnumber` int(11) NOT NULL default '0',
588 `barcode` varchar(9) NOT NULL default '',
589 `dateaccessioned` date default NULL,
590 `booksellerid` varchar(10) default NULL,
591 `homebranch` varchar(4) default NULL,
592 `price` decimal(8,2) default NULL,
593 `replacementprice` decimal(8,2) default NULL,
594 `replacementpricedate` date default NULL,
595 `datelastborrowed` date default NULL,
596 `datelastseen` date default NULL,
597 `multivolume` tinyint(1) default NULL,
598 `stack` tinyint(1) default NULL,
599 `notforloan` tinyint(1) default NULL,
600 `itemlost` tinyint(1) default NULL,
601 `wthdrawn` tinyint(1) default NULL,
602 `bulk` varchar(30) default NULL,
603 `issues` smallint(6) default NULL,
604 `renewals` smallint(6) default NULL,
605 `reserves` smallint(6) default NULL,
606 `restricted` tinyint(1) default NULL,
607 `binding` decimal(28,6) default NULL,
609 `holdingbranch` varchar(4) default NULL,
611 `timestamp` timestamp(14) NOT NULL,
612 PRIMARY KEY (`itemnumber`),
613 UNIQUE KEY `barcode` (`barcode`),
614 KEY `itembarcodeidx` (`barcode`),
615 KEY `itembinoidx` (`biblioitemnumber`),
616 KEY `itembibnoidx` (`biblionumber`)
620 # Table structure for table 'itemsprices'
623 CREATE TABLE `itemsprices` (
624 `itemnumber` int(11) default NULL,
625 `price1` decimal(28,6) default NULL,
626 `price2` decimal(28,6) default NULL
630 # Table structure for table 'itemtypes'
633 CREATE TABLE `itemtypes` (
634 `itemtype` varchar(4) NOT NULL default '',
636 `loanlength` smallint(6) default NULL,
637 `renewalsallowed` smallint(6) default NULL,
638 `rentalcharge` double(16,4) default NULL,
639 UNIQUE KEY `itemtype` (`itemtype`)
643 # Table structure for table 'multipart'
646 CREATE TABLE `multipart` (
647 `itemnumber` int(11) NOT NULL default '0',
648 `other` int(11) NOT NULL default '0'
652 # Table structure for table 'multivolume'
655 CREATE TABLE `multivolume` (
656 `biblionumber` int(11) NOT NULL default '0',
657 `multivolumepart` varchar(30) NOT NULL default ''
661 # Table structure for table 'newitems'
664 CREATE TABLE `newitems` (
665 `itemnumber` int(11) NOT NULL default '0',
666 `publishercode` varchar(18) default NULL,
667 `biblionumber` int(11) NOT NULL default '0',
668 `multivolumepart` varchar(30) default NULL,
669 `barcode` varchar(9) NOT NULL default '',
670 `dateaccessioned` date default NULL,
671 `booksellerid` varchar(10) default NULL,
672 `homebranch` varchar(4) default NULL,
673 `price` decimal(28,6) default NULL,
674 `replacementprice` decimal(28,6) default NULL,
675 `replacementpricedate` date default NULL,
676 `datelastborrowed` date default NULL,
677 `datelastseen` date default NULL,
678 `multivolume` tinyint(1) default NULL,
679 `stack` tinyint(1) default NULL,
680 `notforloan` tinyint(1) default NULL,
681 `itemlost` tinyint(1) default NULL,
682 `wthdrawn` tinyint(1) default NULL,
683 `bulk` varchar(30) default NULL,
684 `issues` smallint(6) default NULL,
685 `renewals` smallint(6) default NULL,
686 `reserves` smallint(6) default NULL,
687 `restricted` tinyint(1) default NULL,
688 `binding` decimal(28,6) default NULL,
690 `holdingbranch` varchar(4) default NULL,
691 `interim` tinyint(1) default NULL,
694 `classification` varchar(12) default NULL,
695 `itemtype` varchar(4) default NULL,
696 `isbn` varchar(14) default NULL,
697 `issn` varchar(9) default NULL,
698 `dewey` double(16,4) default NULL,
699 `subclass` char(3) default NULL,
700 `publicationyear` smallint(6) default NULL,
701 PRIMARY KEY (`itemnumber`),
702 KEY `itembarcodeidx` (`barcode`),
703 KEY `itembibnoidx` (`biblionumber`)
707 # Table structure for table 'printers'
710 CREATE TABLE `printers` (
711 `printername` char(40) default NULL,
712 `printqueue` char(20) default NULL,
713 `printtype` char(20) default NULL
717 # Table structure for table 'procedures'
720 CREATE TABLE `procedures` (
721 `proccode` varchar(4) default NULL,
723 `proclevel` smallint(6) default NULL
727 # Table structure for table 'publisher'
730 CREATE TABLE `publisher` (
731 `publishercode` varchar(18) NOT NULL default '',
732 `publishername` text NOT NULL
736 # Table structure for table 'reserveconstraints'
739 CREATE TABLE `reserveconstraints` (
740 `borrowernumber` int(11) NOT NULL default '0',
741 `reservedate` date NOT NULL default '0000-00-00',
742 `biblionumber` int(11) NOT NULL default '0',
743 `biblioitemnumber` int(11) default NULL,
744 `timestamp` timestamp(14) NOT NULL
748 # Table structure for table 'reserves'
751 CREATE TABLE `reserves` (
752 `borrowernumber` int(11) NOT NULL default '0',
753 `reservedate` date NOT NULL default '0000-00-00',
754 `biblionumber` int(11) NOT NULL default '0',
755 `constrainttype` char(1) default NULL,
756 `branchcode` varchar(4) default NULL,
757 `notificationdate` date default NULL,
758 `reminderdate` date default NULL,
759 `cancellationdate` date default NULL,
761 `priority` smallint(6) default NULL,
762 `found` char(1) default NULL,
763 `timestamp` timestamp(14) NOT NULL,
764 `itemnumber` int(11) default NULL
768 # Table structure for table 'searchstats'
771 CREATE TABLE `searchstats` (
772 `time` datetime default NULL,
777 # Table structure for table 'serialissues'
780 CREATE TABLE `serialissues` (
781 `biblionumber` int(11) NOT NULL default '0',
782 `volume` varchar(20) NOT NULL default '',
783 `number` varchar(20) NOT NULL default '',
784 `ordernumber` smallint(6) default NULL,
785 `issuedate` varchar(20) default NULL,
786 `received` varchar(18) default NULL
790 # Table structure for table 'statistics'
793 CREATE TABLE `statistics` (
794 `datetime` datetime NOT NULL default '0000-00-00 00:00:00',
795 `branch` varchar(4) default NULL,
796 `proccode` varchar(4) default NULL,
797 `value` double(16,4) default NULL,
798 `type` varchar(16) default NULL,
800 `usercode` varchar(10) default NULL,
801 `itemnumber` int(11) default NULL,
802 `itemtype` varchar(4) default NULL,
803 `borrowernumber` int(11) default NULL,
804 KEY `timeidx` (`datetime`)
808 # Table structure for table 'stopwords'
811 CREATE TABLE `stopwords` (
812 `word` varchar(255) default NULL
816 # Table structure for table 'systempreferences'
819 CREATE TABLE `systempreferences` (
820 `variable` char(50) NOT NULL default '',
821 `value` char(200) default NULL,
822 PRIMARY KEY (`variable`)
826 # Table structure for table 'users'
829 CREATE TABLE `users` (
830 `usercode` varchar(10) default NULL,
833 `level` smallint(6) default NULL