# phpMyAdmin MySQL-Dump
# version 2.2.6-rc1
# http://phpwizard.net/phpMyAdmin/
# http://phpmyadmin.sourceforge.net/ (download page)
#
# Host: localhost
# Generation Time: May 02, 2002 at 11:13 AM
# Server version: 3.23.47
# PHP Version: 4.1.2
# Database : `koha-rc1`
# --------------------------------------------------------

#
# Table structure for table `accountlines`
#

CREATE TABLE accountlines (
  borrowernumber int(11) NOT NULL default '0',
  accountno smallint(6) NOT NULL default '0',
  itemnumber int(11) NOT NULL default '0',
  date date default NULL,
  amount decimal(26,6) default NULL,
  description text,
  dispute text,
  accounttype varchar(5) default NULL,
  amountoutstanding decimal(26,6) default NULL,
  timestamp timestamp(14) NOT NULL,
  PRIMARY KEY  (borrowernumber,accountno,itemnumber),
  KEY acctsborridx (borrowernumber),
  KEY timeidx (timestamp)
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `accountoffsets`
#

CREATE TABLE accountoffsets (
  borrowernumber int(11) NOT NULL default '0',
  accountno smallint(6) NOT NULL default '0',
  offsetaccount smallint(6) NOT NULL default '0',
  offsetamount decimal(26,6) default NULL,
  timestamp timestamp(14) NOT NULL
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `additionalauthors`
#

CREATE TABLE additionalauthors (
  author text NOT NULL,
  biblionumber int(11) NOT NULL default '0',
  KEY bibidx (biblionumber),
  FULLTEXT KEY authidx (author)
) TYPE=MyISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `aqbookfund`
#

CREATE TABLE aqbookfund (
  bookfundid varchar(5) NOT NULL default '',
  bookfundname text,
  bookfundgroup varchar(5) default NULL,
  PRIMARY KEY  (bookfundid)
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `aqbooksellers`
#

CREATE TABLE aqbooksellers (
  id int(11) NOT NULL default '0',
  name text,
  address1 text,
  address2 text,
  address3 text,
  address4 text,
  phone varchar(30) default NULL,
  accountnumber text,
  othersupplier text,
  currency char(3) NOT NULL default '',
  deliverydays smallint(6) default NULL,
  followupdays smallint(6) default NULL,
  followupscancel smallint(6) default NULL,
  specialty text,
  booksellerfax text,
  notes text,
  bookselleremail text,
  booksellerurl text,
  contact varchar(100) default NULL,
  postal text,
  url varchar(255) default NULL,
  contpos varchar(100) default NULL,
  contphone varchar(100) default NULL,
  contfax varchar(100) default NULL,
  contaltphone varchar(100) default NULL,
  contemail varchar(100) default NULL,
  contnotes text,
  active tinyint(4) default NULL,
  listprice varchar(5) default NULL,
  invoiceprice varchar(5) default NULL,
  gstreg tinyint(4) default NULL,
  listincgst tinyint(4) default NULL,
  invoiceincgst tinyint(4) default NULL,
  discount float(6,4) default NULL,
  fax varchar(50) default NULL,
  nocalc tinyint(4) default NULL,
  invoicedisc tinyint(4) default NULL,
  PRIMARY KEY  (id)
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `aqbudget`
#

CREATE TABLE aqbudget (
  bookfundid char(5) NOT NULL default '',
  startdate date NOT NULL default '0000-00-00',
  enddate date default NULL,
  budgetamount decimal(11,2) default NULL,
  PRIMARY KEY  (bookfundid,bookfundid)
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `aqorderbreakdown`
#

CREATE TABLE aqorderbreakdown (
  ordernumber int(11) NOT NULL default '0',
  linenumber int(11) NOT NULL default '0',
  branchcode char(4) NOT NULL default '',
  bookfundid char(5) NOT NULL default '',
  allocation smallint(6) default NULL
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `aqorderdelivery`
#

CREATE TABLE aqorderdelivery (
  ordernumber date NOT NULL default '0000-00-00',
  deliverynumber smallint(6) NOT NULL default '0',
  deliverydate varchar(18) default NULL,
  qtydelivered smallint(6) default NULL,
  deliverycomments text,
  PRIMARY KEY  (ordernumber)
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `aqorders`
#

CREATE TABLE aqorders (
  ordernumber int(11) NOT NULL auto_increment,
  biblionumber int(11) default NULL,
  title text,
  requisitionedby varchar(10) default NULL,
  authorisedby varchar(10) default NULL,
  booksellerid varchar(10) NOT NULL default '',
  deliverydays smallint(6) default NULL,
  followupdays smallint(6) default NULL,
  numberfollowupsallowed smallint(6) default NULL,
  numberfollowupssent smallint(6) default NULL,
  entrydate date default NULL,
  dateprinted date default NULL,
  quantity smallint(6) default NULL,
  currency char(3) default NULL,
  listprice decimal(26,6) default NULL,
  totalamount decimal(26,6) default NULL,
  datereceived date default NULL,
  booksellerinvoicenumber text,
  freight decimal(26,6) default NULL,
  unitprice decimal(26,6) default NULL,
  quantityreceived smallint(6) default NULL,
  sourced text,
  cancelledby varchar(10) default NULL,
  quantityreceiveddamaged smallint(6) default NULL,
  datecancellationprinted date default NULL,
  notes text,
  supplierreference text,
  purchaseordernumber text,
  subscription tinyint(1) default NULL,
  subscriptionfrom date default NULL,
  subscriptionto date default NULL,
  serialid varchar(30) default NULL,
  basketno int(11) default NULL,
  biblioitemnumber int(11) default NULL,
  timestamp timestamp(14) NOT NULL,
  rrp decimal(11,2) default NULL,
  ecost decimal(11,2) default NULL,
  gst decimal(11,2) default NULL,
  budgetdate date default NULL,
  PRIMARY KEY  (ordernumber)
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `biblio`
#

CREATE TABLE biblio (
  biblionumber int(11) NOT NULL default '0',
  author text,
  title text,
  unititle text,
  notes text,
  serial tinyint(1) default NULL,
  seriestitle text,
  copyrightdate smallint(6) default NULL,
  timestamp timestamp(14) NOT NULL,
  PRIMARY KEY  (biblionumber),
  KEY blbnoidx (biblionumber),
  FULLTEXT KEY authidx (author)
) TYPE=MyISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `biblioanalysis`
#

CREATE TABLE biblioanalysis (
  analyticaltitle text,
  biblionumber int(11) NOT NULL default '0',
  analyticalauthor text
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `biblioitems`
#

CREATE TABLE biblioitems (
  biblioitemnumber int(11) NOT NULL default '0',
  biblionumber int(11) NOT NULL default '0',
  volume text,
  number text,
  classification varchar(25) default NULL,
  itemtype varchar(4) default NULL,
  isbn varchar(14) default NULL,
  issn varchar(9) default NULL,
  dewey double(8,6) default NULL,
  subclass char(3) default NULL,
  publicationyear smallint(6) default NULL,
  publishercode varchar(255) default NULL,
  volumedate date default NULL,
  volumeddesc varchar(255) default NULL,
  timestamp timestamp(14) NOT NULL,
  illus varchar(255) default NULL,
  pages varchar(255) default NULL,
  notes text,
  size varchar(255) default NULL,
  place varchar(255) default NULL,
  PRIMARY KEY  (biblionumber,biblioitemnumber),
  KEY bibinoidx (biblioitemnumber),
  KEY bibnoidx (biblionumber)
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `bibliosubject`
#

CREATE TABLE bibliosubject (
  subject text NOT NULL,
  biblionumber int(11) NOT NULL default '0'
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `bibliosubtitle`
#

CREATE TABLE bibliosubtitle (
  subtitle text NOT NULL,
  biblionumber int(11) NOT NULL default '0',
  KEY bibsubidx (biblionumber)
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `borexp`
#

CREATE TABLE borexp (
  borrowernumber int(11) NOT NULL default '0',
  newexp date NOT NULL default '0000-00-00'
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `borrowers`
#

CREATE TABLE borrowers (
  borrowernumber int(11) NOT NULL default '0',
  cardnumber varchar(9) NOT NULL default '',
  surname text NOT NULL,
  firstname text NOT NULL,
  title text,
  othernames text,
  initials text NOT NULL,
  streetaddress text NOT NULL,
  suburb text,
  city text NOT NULL,
  phone text NOT NULL,
  emailaddress text,
  faxnumber text,
  altstreetaddress text,
  altsuburb text,
  altcity text,
  altphone text,
  dateofbirth date default NULL,
  branchcode varchar(4) NOT NULL default '',
  categorycode char(2) default NULL,
  dateenrolled date default NULL,
  gonenoaddress tinyint(1) default NULL,
  lost tinyint(1) default NULL,
  debarred tinyint(1) default NULL,
  studentnumber text,
  school text,
  contactname text,
  borrowernotes text,
  guarantor int(11) default NULL,
  area char(2) default NULL,
  ethnicity varchar(50) default NULL,
  ethnotes varchar(255) default NULL,
  sex char(1) default NULL,
  expiry date default NULL,
  altnotes varchar(255) default NULL,
  altrelationship varchar(100) default NULL,
  streetcity text,
  phoneday varchar(50) default NULL,
  preferredcont char(1) default NULL,
  physstreet varchar(100) default NULL,
  KEY borrowernumber (borrowernumber),
  KEY cardnumber (cardnumber)
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `branches`
#

CREATE TABLE branches (
  branchcode varchar(4) NOT NULL default '',
  branchname text NOT NULL,
  branchaddress1 text,
  branchaddress2 text,
  branchaddress3 text,
  branchphone text,
  branchfax text,
  branchemail text,
  issuing tinyint(4) default NULL,
  PRIMARY KEY  (branchcode)
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `branchtransfers`
#

CREATE TABLE branchtransfers (
  itemnumber int(11) NOT NULL default '0',
  datesent date NOT NULL default '0000-00-00',
  frombranch varchar(4) default NULL,
  datearrived date default NULL,
  tobranch varchar(4) default NULL,
  comments text
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `catalogueentry`
#

CREATE TABLE catalogueentry (
  catalogueentry text NOT NULL,
  entrytype char(2) default NULL,
  see text,
  seealso text,
  seeinstead text,
  biblionumber int(11) default NULL
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `categories`
#

CREATE TABLE categories (
  categorycode char(2) NOT NULL default '',
  description text,
  enrolmentperiod smallint(6) default NULL,
  upperagelimit smallint(6) default NULL,
  dateofbirthrequired tinyint(1) default NULL,
  finetype varchar(30) default NULL,
  bulk tinyint(1) default NULL,
  enrolmentfee decimal(26,6) default NULL,
  overduenoticerequired tinyint(1) default NULL,
  issuelimit smallint(6) default NULL,
  reservefee decimal(26,6) default NULL,
  PRIMARY KEY  (categorycode)
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `categoryitem`
#

CREATE TABLE categoryitem (
  categorycode char(2) NOT NULL default '',
  itemtype varchar(4) NOT NULL default '',
  restrictedtype tinyint(1) default NULL,
  rentaldiscount decimal(26,6) default NULL,
  reservecharge decimal(26,6) default NULL,
  fine decimal(26,6) default NULL,
  firstremind int(11) default NULL,
  chargeperiod int(11) default NULL,
  accountsent int(11) default NULL,
  chargename varchar(100) default NULL,
  PRIMARY KEY  (categorycode,itemtype)
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `currency`
#

CREATE TABLE currency (
  currency varchar(10) NOT NULL default '',
  rate float(7,5) NOT NULL default '0.00000',
  PRIMARY KEY  (currency)
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `deletedbiblio`
#

CREATE TABLE deletedbiblio (
  biblionumber int(11) NOT NULL default '0',
  author text,
  title text,
  unititle text,
  notes text,
  serial tinyint(1) default NULL,
  seriestitle text,
  copyrightdate smallint(6) default NULL,
  timestamp timestamp(14) NOT NULL,
  PRIMARY KEY  (biblionumber,biblionumber),
  KEY blbnoidx (biblionumber)
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `deletedbiblioitems`
#

CREATE TABLE deletedbiblioitems (
  biblioitemnumber int(11) NOT NULL default '0',
  biblionumber int(11) NOT NULL default '0',
  volume text,
  number text,
  classification varchar(25) default NULL,
  itemtype varchar(4) default NULL,
  isbn varchar(14) default NULL,
  issn varchar(9) default NULL,
  dewey double(8,6) default NULL,
  subclass char(3) default NULL,
  publicationyear smallint(6) default NULL,
  publishercode varchar(255) default NULL,
  volumedate date default NULL,
  volumeddesc varchar(255) default NULL,
  timestamp timestamp(14) NOT NULL,
  illus varchar(255) default NULL,
  pages varchar(255) default NULL,
  notes text,
  size varchar(255) default NULL,
  PRIMARY KEY  (biblioitemnumber),
  KEY bibinoidx (biblioitemnumber),
  KEY bibnoidx (biblionumber)
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `deletedborrowers`
#

CREATE TABLE deletedborrowers (
  borrowernumber int(11) NOT NULL default '0',
  cardnumber varchar(9) NOT NULL default '',
  surname text NOT NULL,
  firstname text NOT NULL,
  title text,
  othernames text,
  initials text NOT NULL,
  streetaddress text NOT NULL,
  suburb text,
  city text NOT NULL,
  phone text NOT NULL,
  emailaddress text,
  faxnumber text,
  altstreetaddress text,
  altsuburb text,
  altcity text,
  altphone text,
  dateofbirth date default NULL,
  branchcode varchar(4) NOT NULL default '',
  categorycode char(2) default NULL,
  dateenrolled date default NULL,
  gonenoaddress tinyint(1) default NULL,
  lost tinyint(1) default NULL,
  debarred tinyint(1) default NULL,
  studentnumber text,
  school text,
  contactname text,
  borrowernotes text,
  guarantor int(11) default NULL,
  area char(2) default NULL,
  ethnicity varchar(50) default NULL,
  ethnotes varchar(255) default NULL,
  sex char(1) default NULL,
  expiry date default NULL,
  altnotes varchar(255) default NULL,
  altrelationship varchar(100) default NULL,
  streetcity text,
  phoneday varchar(50) default NULL,
  preferredcont varchar(100) default NULL,
  physstreet varchar(100) default NULL,
  PRIMARY KEY  (borrowernumber),
  KEY borrowernumber (borrowernumber),
  KEY cardnumber (cardnumber)
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `deleteditems`
#

CREATE TABLE deleteditems (
  itemnumber int(11) NOT NULL default '0',
  biblionumber int(11) NOT NULL default '0',
  multivolumepart varchar(30) default NULL,
  biblioitemnumber int(11) NOT NULL default '0',
  barcode varchar(9) NOT NULL default '',
  dateaccessioned date default NULL,
  booksellerid varchar(10) default NULL,
  homebranch varchar(4) default NULL,
  price decimal(26,6) default NULL,
  replacementprice decimal(26,6) default NULL,
  replacementpricedate date default NULL,
  datelastborrowed date default NULL,
  datelastseen date default NULL,
  multivolume tinyint(1) default NULL,
  stack tinyint(1) default NULL,
  notforloan tinyint(1) default NULL,
  itemlost tinyint(1) default NULL,
  wthdrawn tinyint(1) default NULL,
  bulk varchar(30) default NULL,
  issues smallint(6) default NULL,
  renewals smallint(6) default NULL,
  reserves smallint(6) default NULL,
  restricted tinyint(1) default NULL,
  binding decimal(26,6) default NULL,
  itemnotes text,
  holdingbranch varchar(4) default NULL,
  interim tinyint(1) default NULL,
  timestamp timestamp(14) NOT NULL,
  PRIMARY KEY  (itemnumber),
  UNIQUE KEY barcode (barcode),
  KEY itembarcodeidx (barcode),
  KEY itembinoidx (biblioitemnumber),
  KEY itembibnoidx (biblionumber)
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `issues`
#

CREATE TABLE issues (
  borrowernumber int(11) NOT NULL default '0',
  itemnumber int(11) NOT NULL default '0',
  date_due date NOT NULL default '0000-00-00',
  branchcode char(4) default NULL,
  issuingbranch char(18) default NULL,
  returndate date default NULL,
  lastreneweddate date default NULL,
  return char(4) default NULL,
  renewals tinyint(4) default NULL,
  timestamp timestamp(14) NOT NULL,
  KEY issuesborridx (borrowernumber),
  KEY issuesitemidx (itemnumber),
  KEY bordate (borrowernumber,timestamp)
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `items`
#

CREATE TABLE items (
  itemnumber int(11) NOT NULL default '0',
  biblionumber int(11) NOT NULL default '0',
  multivolumepart varchar(30) default NULL,
  biblioitemnumber int(11) NOT NULL default '0',
  barcode varchar(9) NOT NULL default '',
  dateaccessioned date default NULL,
  booksellerid varchar(10) default NULL,
  homebranch varchar(4) default NULL,
  price decimal(6,2) default NULL,
  replacementprice decimal(6,2) default NULL,
  replacementpricedate date default NULL,
  datelastborrowed date default NULL,
  datelastseen date default NULL,
  multivolume tinyint(1) default NULL,
  stack tinyint(1) default NULL,
  notforloan tinyint(1) default NULL,
  itemlost tinyint(1) default NULL,
  wthdrawn tinyint(1) default NULL,
  bulk varchar(30) default NULL,
  issues smallint(6) default NULL,
  renewals smallint(6) default NULL,
  reserves smallint(6) default NULL,
  restricted tinyint(1) default NULL,
  binding decimal(26,6) default NULL,
  itemnotes text,
  holdingbranch varchar(4) default NULL,
  paidfor text,
  timestamp timestamp(14) NOT NULL,
  PRIMARY KEY  (itemnumber),
  UNIQUE KEY barcode (barcode),
  KEY itembarcodeidx (barcode),
  KEY itembinoidx (biblioitemnumber),
  KEY itembibnoidx (biblionumber)
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `itemsprices`
#

CREATE TABLE itemsprices (
  itemnumber int(11) NOT NULL default '0',
  price1 decimal(26,6) default NULL,
  price2 decimal(26,6) default NULL,
  PRIMARY KEY  (itemnumber)
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `itemtypes`
#

CREATE TABLE itemtypes (
  itemtype varchar(4) NOT NULL default '',
  description text,
  loanlength smallint(6) default NULL,
  renewalsallowed smallint(6) default NULL,
  rentalcharge double(16,4) default NULL,
  PRIMARY KEY  (itemtype)
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `printers`
#

CREATE TABLE printers (
  printername char(40) NOT NULL default '',
  printqueue char(20) default NULL,
  printtype char(20) default NULL,
  PRIMARY KEY  (printername)
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `reserveconstraints`
#

CREATE TABLE reserveconstraints (
  borrowernumber int(11) NOT NULL default '0',
  reservedate date NOT NULL default '0000-00-00',
  biblionumber int(11) NOT NULL default '0',
  biblioitemnumber int(11) default NULL,
  timestamp timestamp(14) NOT NULL
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `reserves`
#

CREATE TABLE reserves (
  borrowernumber int(11) NOT NULL default '0',
  reservedate date NOT NULL default '0000-00-00',
  biblionumber int(11) NOT NULL default '0',
  constrainttype char(1) default NULL,
  branchcode varchar(4) default NULL,
  notificationdate date default NULL,
  reminderdate date default NULL,
  cancellationdate date default NULL,
  reservenotes text,
  priority smallint(6) default NULL,
  found char(1) default NULL,
  timestamp timestamp(14) NOT NULL,
  itemnumber int(11) default NULL
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `statistics`
#

CREATE TABLE statistics (
  datetime datetime NOT NULL default '0000-00-00 00:00:00',
  branch varchar(4) default NULL,
  proccode varchar(4) default NULL,
  value double(16,4) default NULL,
  type varchar(16) default NULL,
  other text,
  usercode varchar(10) default NULL,
  itemnumber int(11) default NULL,
  itemtype varchar(4) default NULL,
  borrowernumber int(11) default NULL,
  KEY timeidx (datetime)
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `stopwords`
#

CREATE TABLE stopwords (
  word varchar(255) NOT NULL default '',
  PRIMARY KEY  (word)
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `systempreferences`
#

CREATE TABLE systempreferences (
  variable char(50) NOT NULL default '',
  value char(200) default NULL,
  PRIMARY KEY  (variable)
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `users`
#

CREATE TABLE users (
  usercode varchar(10) NOT NULL default '',
  username text,
  password text,
  level smallint(6) default NULL,
  PRIMARY KEY  (usercode)
) TYPE=ISAM PACK_KEYS=1;