Bugzilla – Attachment 18779 Details for
Bug 10296
UT: db schemas are useless
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 10296: UT: t/data/db_schemas not needed
Bug-10296-UT-tdatadbschemas-not-needed.patch (text/plain), 174.50 KB, created by
Chris Cormack
on 2013-06-08 04:04:42 UTC
(
hide
)
Description:
Bug 10296: UT: t/data/db_schemas not needed
Filename:
MIME Type:
Creator:
Chris Cormack
Created:
2013-06-08 04:04:42 UTC
Size:
174.50 KB
patch
obsolete
>From e49dcdc5cf400d7d715577b3a3ff5c738659b05c Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@biblibre.com> >Date: Tue, 21 May 2013 14:54:36 +0200 >Subject: [PATCH] Bug 10296: UT: t/data/db_schemas not needed > >Signed-off-by: Galen Charlton <gmc@esilibrary.com> > >These were added with the intention of writing some >schema verification test cases, but if that idea >gets picked up again in the future, fresher copies >of kohastructure.sql can be obtained from Git. > >Signed-off-by: Chris Cormack <chris@bigballofwax.co.nz> >--- > t/data/db_schemas/koha.mysql-2.2.9 | 1357 ------------- > .../db_schemas/kohastructure.sql-3.00.00-alpha-044 | 1895 ------------------ > .../db_schemas/kohastructure.sql-3.00.00-beta-067 | 2029 -------------------- > 3 files changed, 5281 deletions(-) > delete mode 100644 t/data/db_schemas/koha.mysql-2.2.9 > delete mode 100644 t/data/db_schemas/kohastructure.sql-3.00.00-alpha-044 > delete mode 100644 t/data/db_schemas/kohastructure.sql-3.00.00-beta-067 > >diff --git a/t/data/db_schemas/koha.mysql-2.2.9 b/t/data/db_schemas/koha.mysql-2.2.9 >deleted file mode 100644 >index 85b6442..0000000 >--- a/t/data/db_schemas/koha.mysql-2.2.9 >+++ /dev/null >@@ -1,1357 +0,0 @@ >-# >-# Structure de la table `accountlines` >-# >- >-CREATE TABLE accountlines ( >- borrowernumber int(11) NOT NULL default '0', >- accountno smallint(6) NOT NULL default '0', >- itemnumber int(11) default NULL, >- date date default NULL, >- amount decimal(28,6) default NULL, >- description text, >- dispute text, >- accounttype varchar(5) default NULL, >- amountoutstanding decimal(28,6) default NULL, >- timestamp timestamp(14) NOT NULL, >- KEY acctsborridx (borrowernumber), >- KEY timeidx (timestamp) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la 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(28,6) default NULL, >- timestamp timestamp(14) NOT NULL >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `additionalauthors` >-# >- >-CREATE TABLE additionalauthors ( >- author text NOT NULL, >- biblionumber int(11) NOT NULL default '0', >- KEY bibidx (biblionumber) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `aqbasket` >-# >- >-CREATE TABLE aqbasket ( >- basketno int(11) NOT NULL auto_increment, >- creationdate date default NULL, >- closedate date default NULL, >- booksellerid varchar(10) default NULL, >- authorisedby varchar(10) default NULL, >- booksellerinvoicenumber text, >- PRIMARY KEY (basketno) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `aqbookfund` >-# >- >-CREATE TABLE aqbookfund ( >- bookfundid varchar(5) NOT NULL default '''''', >- bookfundname text, >- bookfundgroup varchar(5) default NULL, >- PRIMARY KEY (bookfundid) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `aqbooksellers` >-# >- >-CREATE TABLE aqbooksellers ( >- id int(11) default NULL, >- 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 int(11) default NULL, >- invoicedisc float(6,4) default NULL >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la 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(13,2) default NULL, >- aqbudgetid tinyint(4) NOT NULL auto_increment, >- PRIMARY KEY (aqbudgetid) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `aqorderbreakdown` >-# >- >-CREATE TABLE aqorderbreakdown ( >- ordernumber int(11) default NULL, >- linenumber int(11) default NULL, >- branchcode char(4) default NULL, >- bookfundid char(5) NOT NULL default '', >- allocation smallint(6) default NULL >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la 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 >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `aqorders` >-# >- >-CREATE TABLE aqorders ( >- ordernumber int(11) NOT NULL auto_increment, >- biblionumber int(11) default NULL, >- title text, >- entrydate date default NULL, >- quantity smallint(6) default NULL, >- currency char(3) default NULL, >- listprice decimal(28,6) default NULL, >- totalamount decimal(28,6) default NULL, >- datereceived date default NULL, >- booksellerinvoicenumber text, >- freight decimal(28,6) default NULL, >- unitprice decimal(28,6) default NULL, >- quantityreceived smallint(6) default NULL, >- cancelledby varchar(10) default NULL, >- datecancellationprinted date default NULL, >- notes text, >- supplierreference text, >- purchaseordernumber text, >- subscription tinyint(1) default NULL, >- serialid varchar(30) default NULL, >- basketno int(11) default NULL, >- biblioitemnumber int(11) default NULL, >- timestamp timestamp(14) NOT NULL, >- rrp decimal(13,2) default NULL, >- ecost decimal(13,2) default NULL, >- gst decimal(13,2) default NULL, >- budgetdate date default NULL, >- sort1 varchar(80) default NULL, >- sort2 varchar(80) default NULL, >- PRIMARY KEY (ordernumber) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `auth_header` >-# >- >-CREATE TABLE auth_header ( >- authid bigint(20) unsigned NOT NULL auto_increment, >- authtypecode char(10) NOT NULL default '', >- datecreated date NOT NULL default '0000-00-00', >- datemodified date default NULL, >- origincode char(20) default NULL, >- PRIMARY KEY (authid), >- KEY origincode (origincode) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `auth_subfield_structure` >-# >- >-CREATE TABLE auth_subfield_structure ( >- authtypecode char(10) NOT NULL default '', >- tagfield char(3) NOT NULL default '', >- tagsubfield char(1) NOT NULL default '', >- liblibrarian char(255) NOT NULL default '', >- libopac char(255) NOT NULL default '', >- repeatable tinyint(4) NOT NULL default '0', >- mandatory tinyint(4) NOT NULL default '0', >- tab tinyint(1) default NULL, >- authorised_value char(10) default NULL, >- value_builder char(80) default NULL, >- seealso char(255) default NULL, >- PRIMARY KEY (authtypecode,tagfield,tagsubfield), >- KEY tab (authtypecode,tab) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `auth_subfield_table` >-# >- >-CREATE TABLE auth_subfield_table ( >- subfieldid bigint(20) unsigned NOT NULL auto_increment, >- authid bigint(20) unsigned NOT NULL default '0', >- tag char(3) NOT NULL default '', >- tagorder tinyint(4) NOT NULL default '1', >- tag_indicator char(2) NOT NULL default '', >- subfieldcode char(1) NOT NULL default '', >- subfieldorder tinyint(4) NOT NULL default '1', >- subfieldvalue varchar(255) default NULL, >- PRIMARY KEY (subfieldid), >- KEY authid (authid), >- KEY tag (tag), >- KEY subfieldcode (subfieldcode), >- KEY subfieldvalue (subfieldvalue) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `auth_tag_structure` >-# >- >-CREATE TABLE auth_tag_structure ( >- authtypecode char(10) NOT NULL default '', >- tagfield char(3) NOT NULL default '', >- liblibrarian char(255) NOT NULL default '', >- libopac char(255) NOT NULL default '', >- repeatable tinyint(4) NOT NULL default '0', >- mandatory tinyint(4) NOT NULL default '0', >- authorised_value char(10) default NULL, >- PRIMARY KEY (authtypecode,tagfield) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `auth_types` >-# >- >-CREATE TABLE auth_types ( >- authtypecode varchar(10) NOT NULL default '', >- authtypetext varchar(255) NOT NULL default '', >- auth_tag_to_report char(3) NOT NULL default '', >- summary text NOT NULL, >- PRIMARY KEY (authtypecode) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `auth_word` >-# >- >-CREATE TABLE auth_word ( >- authid bigint(20) NOT NULL default '0', >- tagsubfield varchar(4) NOT NULL default '', >- tagorder tinyint(4) NOT NULL default '1', >- subfieldorder tinyint(4) NOT NULL default '1', >- word varchar(255) NOT NULL default '', >- sndx_word varchar(255) NOT NULL default '', >- KEY authid (authid), >- KEY marc_search (tagsubfield,word), >- KEY word (word), >- KEY sndx_word (sndx_word) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `authorised_values` >-# >- >-CREATE TABLE authorised_values ( >- id int(11) NOT NULL auto_increment, >- category char(10) NOT NULL default '', >- authorised_value char(80) NOT NULL default '', >- lib char(80) default NULL, >- PRIMARY KEY (id), >- KEY name (category) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la 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, >- abstract text, >- PRIMARY KEY (biblionumber), >- KEY blbnoidx (biblionumber) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `biblio_framework` >-# >- >-CREATE TABLE biblio_framework ( >- frameworkcode char(4) NOT NULL default '', >- frameworktext char(255) NOT NULL default '', >- PRIMARY KEY (frameworkcode) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `biblioanalysis` >-# >- >-CREATE TABLE biblioanalysis ( >- analyticaltitle text, >- biblionumber int(11) NOT NULL default '0', >- analyticalauthor text >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la 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 varchar(50) 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, >- lccn varchar(25) default NULL, >- marc text, >- url varchar(255) default NULL, >- PRIMARY KEY (biblioitemnumber), >- KEY bibinoidx (biblioitemnumber), >- KEY bibnoidx (biblionumber) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `bibliosubject` >-# >- >-CREATE TABLE bibliosubject ( >- subject text NOT NULL, >- biblionumber int(11) NOT NULL default '0' >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `bibliosubtitle` >-# >- >-CREATE TABLE bibliosubtitle ( >- subtitle text NOT NULL, >- biblionumber int(11) NOT NULL default '0', >- KEY bibsubidx (biblionumber) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `bibliothesaurus` >-# >- >-CREATE TABLE bibliothesaurus ( >- id bigint(20) NOT NULL auto_increment, >- freelib char(255) NOT NULL default '', >- stdlib char(255) NOT NULL default '', >- category char(10) NOT NULL default '', >- level tinyint(4) NOT NULL default '1', >- hierarchy char(80) NOT NULL default '', >- father char(80) NOT NULL default '', >- PRIMARY KEY (id), >- KEY freelib (freelib), >- KEY stdlib (stdlib), >- KEY category (category), >- KEY hierarchy (hierarchy), >- FULLTEXT KEY category_2 (category,freelib) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `bookshelf` >-# >- >-CREATE TABLE bookshelf ( >- shelfnumber int(11) NOT NULL auto_increment, >- shelfname char(255) default NULL, >- owner char(80) default NULL, >- category char(1) default NULL, >- PRIMARY KEY (shelfnumber) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `borexp` >-# >- >-CREATE TABLE borexp ( >- borrowernumber int(11) default NULL, >- newexp date default NULL >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `borrowers` >-# >- >-CREATE TABLE borrowers ( >- borrowernumber int(11) NOT NULL auto_increment, >- cardnumber varchar(16) 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, >- textmessaging 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, >- password varchar(30) default NULL, >- flags int(11) default NULL, >- userid varchar(30) default NULL, >- homezipcode varchar(25) default NULL, >- zipcode varchar(25) default NULL, >- sort1 varchar(80) default NULL, >- sort2 varchar(80) default NULL, >- UNIQUE KEY cardnumber (cardnumber), >- KEY borrowernumber (borrowernumber) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `branchcategories` >-# >- >-CREATE TABLE branchcategories ( >- categorycode varchar(4) NOT NULL default '', >- categoryname text, >- codedescription text, >- PRIMARY KEY (categorycode) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la 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, >- UNIQUE KEY branchcode (branchcode) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `branchrelations` >-# >- >-CREATE TABLE branchrelations ( >- branchcode varchar(4) default NULL, >- categorycode varchar(4) default NULL >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `branchtransfers` >-# >- >-CREATE TABLE branchtransfers ( >- itemnumber int(11) NOT NULL default '0', >- datesent datetime default NULL, >- frombranch varchar(4) default NULL, >- datearrived datetime default NULL, >- tobranch varchar(4) default NULL, >- comments text >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la 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=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la 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(28,6) default NULL, >- overduenoticerequired tinyint(1) default NULL, >- issuelimit smallint(6) default NULL, >- reservefee decimal(28,6) default NULL, >- UNIQUE KEY categorycode (categorycode) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `currency` >-# >- >-CREATE TABLE currency ( >- currency varchar(10) default NULL, >- rate float(7,5) default NULL >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la 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, >- marc blob, >- abstract text, >- PRIMARY KEY (biblionumber), >- KEY blbnoidx (biblionumber) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la 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 varchar(50) 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, >- lccn varchar(25) default NULL, >- marc text, >- url varchar(255) default NULL, >- PRIMARY KEY (biblioitemnumber), >- KEY bibinoidx (biblioitemnumber), >- KEY bibnoidx (biblionumber) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la 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, >- KEY borrowernumber (borrowernumber), >- KEY cardnumber (cardnumber) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la 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(28,6) default NULL, >- replacementprice decimal(28,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(28,6) default NULL, >- itemnotes text, >- holdingbranch varchar(4) default NULL, >- interim tinyint(1) default NULL, >- timestamp timestamp(14) NOT NULL, >- marc blob, >- paidfor text, >- PRIMARY KEY (itemnumber), >- UNIQUE KEY barcode (barcode), >- KEY itembarcodeidx (barcode), >- KEY itembinoidx (biblioitemnumber), >- KEY itembibnoidx (biblionumber) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `ethnicity` >-# >- >-CREATE TABLE ethnicity ( >- code varchar(10) NOT NULL default '', >- name varchar(255) default NULL, >- PRIMARY KEY (code) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `issues` >-# >- >-CREATE TABLE issues ( >- borrowernumber int(11) NOT NULL default '0', >- itemnumber int(11) NOT NULL default '0', >- date_due date default NULL, >- 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=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `issuingrules` >-# >- >-CREATE TABLE issuingrules ( >- categorycode char(2) NOT NULL default '', >- itemtype varchar(4) NOT NULL default '', >- restrictedtype tinyint(1) default NULL, >- rentaldiscount decimal(28,6) default NULL, >- reservecharge decimal(28,6) default NULL, >- fine decimal(28,6) default NULL, >- firstremind int(11) default NULL, >- chargeperiod int(11) default NULL, >- accountsent int(11) default NULL, >- chargename varchar(100) default NULL, >- maxissueqty int(4) default NULL, >- issuelength int(4) default NULL, >- branchcode varchar(4) NOT NULL default '', >- PRIMARY KEY (branchcode,categorycode,itemtype) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la 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(20) default NULL, >- dateaccessioned date default NULL, >- booksellerid varchar(10) default NULL, >- homebranch varchar(4) default NULL, >- price decimal(8,2) default NULL, >- replacementprice decimal(8,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, >- itemcallnumber 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(28,6) default NULL, >- itemnotes text, >- holdingbranch varchar(4) default NULL, >- paidfor text, >- timestamp timestamp(14) NOT NULL, >- location varchar(80) default NULL, >- PRIMARY KEY (itemnumber), >- KEY itembarcodeidx (barcode), >- KEY itembinoidx (biblioitemnumber), >- KEY itembibnoidx (biblionumber) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `itemsprices` >-# >- >-CREATE TABLE itemsprices ( >- itemnumber int(11) default NULL, >- price1 decimal(28,6) default NULL, >- price2 decimal(28,6) default NULL >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `itemtypes` >-# >- >-CREATE TABLE itemtypes ( >- itemtype varchar(4) NOT NULL default '', >- description text, >- renewalsallowed smallint(6) default NULL, >- rentalcharge double(16,4) default NULL, >- notforloan smallint(6) default NULL, >- UNIQUE KEY itemtype (itemtype) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `marc_biblio` >-# >- >-CREATE TABLE marc_biblio ( >- bibid bigint(20) unsigned NOT NULL auto_increment, >- biblionumber int(11) NOT NULL default '0', >- datecreated date NOT NULL default '0000-00-00', >- datemodified date default NULL, >- origincode char(20) default NULL, >- frameworkcode char(4) NOT NULL default '', >- PRIMARY KEY (bibid), >- KEY origincode (origincode), >- KEY biblionumber (biblionumber) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `marc_blob_subfield` >-# >- >-CREATE TABLE marc_blob_subfield ( >- blobidlink bigint(20) NOT NULL auto_increment, >- subfieldvalue longtext NOT NULL, >- PRIMARY KEY (blobidlink) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `marc_breeding` >-# >- >-CREATE TABLE marc_breeding ( >- id bigint(20) NOT NULL auto_increment, >- file varchar(80) NOT NULL default '', >- isbn varchar(10) NOT NULL default '', >- title varchar(128) default NULL, >- author varchar(80) default NULL, >- marc text NOT NULL, >- encoding varchar(40) NOT NULL default '''''', >- z3950random varchar(40) default NULL, >- PRIMARY KEY (id), >- KEY title (title), >- KEY isbn (isbn) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `marc_subfield_structure` >-# >-CREATE TABLE marc_subfield_structure ( >- tagfield char(3) NOT NULL default '', >- tagsubfield char(1) NOT NULL default '', >- liblibrarian varchar(255) NOT NULL default '', >- libopac varchar(255) NOT NULL default '', >- repeatable tinyint(4) NOT NULL default '0', >- mandatory tinyint(4) NOT NULL default '0', >- kohafield varchar(40) default NULL, >- tab tinyint(1) default NULL, >- authorised_value varchar(10) default NULL, >- authtypecode varchar(10) default NULL, >- value_builder varchar(80) default NULL, >- isurl tinyint(1) default NULL, >- hidden tinyint(1) default NULL, >- frameworkcode varchar(4) NOT NULL default '', >- seealso text default NULL, >- link varchar(80) default NULL, >- PRIMARY KEY (frameworkcode,tagfield,tagsubfield), >- KEY tab (frameworkcode,tab), >- KEY kohafield (frameworkcode,kohafield), >- KEY kohafield_2 (kohafield) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `marc_subfield_table` >-# >- >-CREATE TABLE marc_subfield_table ( >- subfieldid bigint(20) unsigned NOT NULL auto_increment, >- bibid bigint(20) unsigned NOT NULL default '0', >- tag char(3) NOT NULL default '', >- tagorder tinyint(4) NOT NULL default '1', >- tag_indicator char(2) NOT NULL default '', >- subfieldcode char(1) NOT NULL default '', >- subfieldorder tinyint(4) NOT NULL default '1', >- subfieldvalue varchar(255) default NULL, >- valuebloblink bigint(20) default NULL, >- PRIMARY KEY (subfieldid), >- KEY bibid (bibid), >- KEY tag (tag), >- KEY tag_indicator (tag_indicator), >- KEY subfieldorder (subfieldorder), >- KEY subfieldcode (subfieldcode), >- KEY subfieldvalue (subfieldvalue), >- KEY tagorder (tagorder) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `marc_tag_structure` >-# >- >-CREATE TABLE marc_tag_structure ( >- tagfield char(3) NOT NULL default '', >- liblibrarian char(255) NOT NULL default '', >- libopac char(255) NOT NULL default '', >- repeatable tinyint(4) NOT NULL default '0', >- mandatory tinyint(4) NOT NULL default '0', >- authorised_value char(10) default NULL, >- frameworkcode char(4) NOT NULL default '', >- PRIMARY KEY (frameworkcode,tagfield) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `marc_word` >-# >- >-CREATE TABLE marc_word ( >- bibid bigint(20) NOT NULL default '0', >- tagsubfield varchar(4) NOT NULL default '', >- tagorder tinyint(4) NOT NULL default '1', >- subfieldorder tinyint(4) NOT NULL default '1', >- word varchar(255) NOT NULL default '', >- sndx_word varchar(255) NOT NULL default '', >- KEY bibid (bibid), >- KEY tagorder (tagorder), >- KEY subfieldorder (subfieldorder), >- KEY word (word), >- KEY sndx_word (sndx_word), >- KEY Search_Marc (tagsubfield,word) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `marcrecorddone` >-# >- >-CREATE TABLE marcrecorddone ( >- isbn char(40) default NULL, >- issn char(40) default NULL, >- lccn char(40) default NULL, >- controlnumber char(40) default NULL >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la 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=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la 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=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la 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=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `serial` >-# >- >-CREATE TABLE serial ( >- serialid int(11) NOT NULL auto_increment, >- biblionumber varchar(100) NOT NULL default '', >- subscriptionid varchar(100) NOT NULL default '', >- serialseq varchar(100) NOT NULL default '', >- status tinyint(4) NOT NULL default '0', >- planneddate date NOT NULL default '0000-00-00', >- PRIMARY KEY (serialid) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `sessionqueries` >-# >- >-CREATE TABLE sessionqueries ( >- sessionID varchar(255) NOT NULL default '', >- userid varchar(100) NOT NULL default '', >- ip varchar(18) NOT NULL default '', >- url text NOT NULL >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `sessions` >-# >- >-CREATE TABLE sessions ( >- sessionID varchar(255) NOT NULL default '', >- userid varchar(255) default NULL, >- ip varchar(16) default NULL, >- lasttime int(11) default NULL, >- PRIMARY KEY (sessionID) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `shelfcontents` >-# >- >-CREATE TABLE shelfcontents ( >- shelfnumber int(11) NOT NULL default '0', >- itemnumber int(11) NOT NULL default '0', >- flags int(11) default NULL >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la 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=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `stopwords` >-# >- >-CREATE TABLE stopwords ( >- word varchar(255) default NULL >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `subscription` >-# >- >-CREATE TABLE subscription ( >- biblionumber int(11) NOT NULL default '0', >- subscriptionid int(11) NOT NULL auto_increment, >- librarian varchar(100) default '', >- startdate date default '0000-00-00', >- aqbooksellerid int(11) default '0', >- cost int(11) default '0', >- aqbudgetid int(11) default '0', >- weeklength tinyint(4) default '0', >- monthlength tinyint(4) default '0', >- numberlength tinyint(4) default '0', >- periodicity tinyint(4) default '0', >- dow varchar(100) default '', >- numberingmethod varchar(100) default '', >- notes text, >- status varchar(100) NOT NULL default '', >- add1 int(11) default '0', >- every1 int(11) default '0', >- whenmorethan1 int(11) default '0', >- setto1 int(11) default NULL, >- lastvalue1 int(11) default NULL, >- add2 int(11) default '0', >- every2 int(11) default '0', >- whenmorethan2 int(11) default '0', >- setto2 int(11) default NULL, >- lastvalue2 int(11) default NULL, >- add3 int(11) default '0', >- every3 int(11) default '0', >- innerloop1 int(11) default '0', >- innerloop2 int(11) default '0', >- innerloop3 int(11) default '0', >- whenmorethan3 int(11) default '0', >- setto3 int(11) default NULL, >- lastvalue3 int(11) default NULL, >- PRIMARY KEY (subscriptionid) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `subscriptionhistory` >-# >- >-CREATE TABLE subscriptionhistory ( >- biblionumber int(11) NOT NULL default '0', >- subscriptionid int(11) NOT NULL default '0', >- histstartdate date NOT NULL default '0000-00-00', >- enddate date default '0000-00-00', >- missinglist longtext NOT NULL, >- recievedlist longtext NOT NULL, >- opacnote varchar(150) NOT NULL default '', >- librariannote varchar(150) NOT NULL default '', >- PRIMARY KEY (subscriptionid), >- KEY biblionumber (biblionumber) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `suggestions` >-# >- >-CREATE TABLE suggestions ( >- suggestionid int(8) NOT NULL auto_increment, >- suggestedby int(11) NOT NULL default '0', >- managedby int(11) default NULL, >- STATUS varchar(10) NOT NULL default '', >- note text, >- author varchar(80) default NULL, >- title varchar(80) default NULL, >- copyrightdate smallint(6) default NULL, >- publishercode varchar(255) default NULL, >- date timestamp(8) NOT NULL, >- volumedesc varchar(255) default NULL, >- publicationyear smallint(6) default '0', >- place varchar(255) default NULL, >- isbn varchar(10) default NULL, >- mailoverseeing smallint(1) default '0', >- biblionumber int(11) default NULL, >- PRIMARY KEY (suggestionid), >- KEY suggestedby (suggestedby), >- KEY managedby (managedby) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `systempreferences` >-# >- >-CREATE TABLE systempreferences ( >- variable varchar(50) NOT NULL default '', >- value text, >- options text, >- explanation varchar(80) default NULL, >- type varchar(20) default NULL, >- PRIMARY KEY (variable) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `uploadedmarc` >-# >- >-CREATE TABLE uploadedmarc ( >- id int(11) NOT NULL auto_increment, >- marc longblob, >- hidden smallint(6) default NULL, >- name varchar(255) default NULL, >- PRIMARY KEY (id) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `userflags` >-# >- >-CREATE TABLE userflags ( >- bit int(11) NOT NULL default '0', >- flag char(30) default NULL, >- flagdesc char(255) default NULL, >- defaulton int(11) default NULL >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `users` >-# >- >-CREATE TABLE users ( >- usercode varchar(10) default NULL, >- username text, >- password text, >- level smallint(6) default NULL >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `websites` >-# >- >-CREATE TABLE websites ( >- websitenumber int(11) NOT NULL auto_increment, >- biblionumber int(11) NOT NULL default '0', >- title text, >- description text, >- url varchar(255) default NULL, >- PRIMARY KEY (websitenumber) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `z3950queue` >-# >- >-CREATE TABLE z3950queue ( >- id int(11) NOT NULL auto_increment, >- term text, >- type varchar(10) default NULL, >- startdate int(11) default NULL, >- enddate int(11) default NULL, >- done smallint(6) default NULL, >- results longblob, >- numrecords int(11) default NULL, >- servers text, >- identifier varchar(30) default NULL, >- PRIMARY KEY (id) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `z3950results` >-# >- >-CREATE TABLE z3950results ( >- id int(11) NOT NULL auto_increment, >- queryid int(11) default NULL, >- server varchar(255) default NULL, >- startdate int(11) default NULL, >- enddate int(11) default NULL, >- results longblob, >- numrecords int(11) default NULL, >- numdownloaded int(11) default NULL, >- highestseen int(11) default NULL, >- active smallint(6) default NULL, >- PRIMARY KEY (id), >- UNIQUE KEY query_server (queryid,server) >-) TYPE=MyISAM; >-# -------------------------------------------------------- >- >-# >-# Structure de la table `z3950servers` >-# >- >-CREATE TABLE z3950servers ( >- host varchar(255) default NULL, >- port int(11) default NULL, >- db varchar(255) default NULL, >- userid varchar(255) default NULL, >- password varchar(255) default NULL, >- name text, >- id int(11) NOT NULL auto_increment, >- checked smallint(6) default NULL, >- rank int(11) default NULL, >- syntax varchar(80) default NULL, >- PRIMARY KEY (id) >-) TYPE=MyISAM; >- >diff --git a/t/data/db_schemas/kohastructure.sql-3.00.00-alpha-044 b/t/data/db_schemas/kohastructure.sql-3.00.00-alpha-044 >deleted file mode 100644 >index 937df9b..0000000 >--- a/t/data/db_schemas/kohastructure.sql-3.00.00-alpha-044 >+++ /dev/null >@@ -1,1895 +0,0 @@ >--- MySQL dump 10.9 >--- >--- Host: localhost Database: koha30test >--- ------------------------------------------------------ >--- Server version 4.1.22 >- >-/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; >-/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; >-/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; >-/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; >-/*!40101 SET NAMES utf8 */; >-/*!40103 SET TIME_ZONE='+00:00' */; >-/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; >-/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; >-/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; >-/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; >- >--- >--- Table structure for table `accountlines` >--- >- >-DROP TABLE IF EXISTS `accountlines`; >-CREATE TABLE `accountlines` ( >- `borrowernumber` int(11) NOT NULL default 0, >- `accountno` smallint(6) NOT NULL default 0, >- `itemnumber` int(11) default NULL, >- `date` date default NULL, >- `amount` decimal(28,6) default NULL, >- `description` mediumtext, >- `dispute` mediumtext, >- `accounttype` varchar(5) default NULL, >- `amountoutstanding` decimal(28,6) default NULL, >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, >- `notify_id` int(11) NOT NULL default 0, >- `notify_level` int(2) NOT NULL default 0, >- KEY `acctsborridx` (`borrowernumber`), >- KEY `timeidx` (`timestamp`), >- KEY `itemnumber` (`itemnumber`), >- CONSTRAINT `accountlines_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, >- CONSTRAINT `accountlines_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `accountoffsets` >--- >- >-DROP TABLE IF EXISTS `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(28,6) default NULL, >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, >- CONSTRAINT `accountoffsets_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `action_logs` >--- >- >-DROP TABLE IF EXISTS `action_logs`; >-CREATE TABLE `action_logs` ( >- `action_id` int(11) NOT NULL auto_increment, >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, >- `user` int(11) NOT NULL default 0, >- `module` text, >- `action` text, >- `object` int(11) default NULL, >- `info` text, >- PRIMARY KEY (`action_id`), >- KEY (`timestamp`,`user`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `alert` >--- >- >-DROP TABLE IF EXISTS `alert`; >-CREATE TABLE `alert` ( >- `alertid` int(11) NOT NULL auto_increment, >- `borrowernumber` int(11) NOT NULL default 0, >- `type` varchar(10) NOT NULL default '', >- `externalid` varchar(20) NOT NULL default '', >- PRIMARY KEY (`alertid`), >- KEY `borrowernumber` (`borrowernumber`), >- KEY `type` (`type`,`externalid`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `aqbasket` >--- >- >-DROP TABLE IF EXISTS `aqbasket`; >-CREATE TABLE `aqbasket` ( >- `basketno` int(11) NOT NULL auto_increment, >- `creationdate` date default NULL, >- `closedate` date default NULL, >- `booksellerid` int(11) NOT NULL default 1, >- `authorisedby` varchar(10) default NULL, >- `booksellerinvoicenumber` mediumtext, >- PRIMARY KEY (`basketno`), >- KEY `booksellerid` (`booksellerid`), >- CONSTRAINT `aqbasket_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `aqbookfund` >--- >- >-DROP TABLE IF EXISTS `aqbookfund`; >-CREATE TABLE `aqbookfund` ( >- `bookfundid` varchar(10) NOT NULL default '', >- `bookfundname` mediumtext, >- `bookfundgroup` varchar(5) default NULL, >- `branchcode` varchar(10) NOT NULL default '', >- PRIMARY KEY (`bookfundid`,`branchcode`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `aqbooksellers` >--- >- >-DROP TABLE IF EXISTS `aqbooksellers`; >-CREATE TABLE `aqbooksellers` ( >- `id` int(11) NOT NULL auto_increment, >- `name` mediumtext, >- `address1` mediumtext, >- `address2` mediumtext, >- `address3` mediumtext, >- `address4` mediumtext, >- `phone` varchar(30) default NULL, >- `accountnumber` mediumtext, >- `othersupplier` mediumtext, >- `currency` varchar(3) NOT NULL default '', >- `deliverydays` smallint(6) default NULL, >- `followupdays` smallint(6) default NULL, >- `followupscancel` smallint(6) default NULL, >- `specialty` mediumtext, >- `booksellerfax` mediumtext, >- `notes` mediumtext, >- `bookselleremail` mediumtext, >- `booksellerurl` mediumtext, >- `contact` varchar(100) default NULL, >- `postal` mediumtext, >- `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` mediumtext, >- `active` tinyint(4) default NULL, >- `listprice` varchar(10) default NULL, >- `invoiceprice` varchar(10) 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` int(11) default NULL, >- `invoicedisc` float(6,4) default NULL, >- PRIMARY KEY (`id`), >- KEY `listprice` (`listprice`), >- KEY `invoiceprice` (`invoiceprice`), >- CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE, >- CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `aqbudget` >--- >- >-DROP TABLE IF EXISTS `aqbudget`; >-CREATE TABLE `aqbudget` ( >- `bookfundid` varchar(10) NOT NULL default '', >- `startdate` date NOT NULL default 0, >- `enddate` date default NULL, >- `budgetamount` decimal(13,2) default NULL, >- `aqbudgetid` tinyint(4) NOT NULL auto_increment, >- `branchcode` varchar(10) default NULL, >- PRIMARY KEY (`aqbudgetid`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `aqorderbreakdown` >--- >- >-DROP TABLE IF EXISTS `aqorderbreakdown`; >-CREATE TABLE `aqorderbreakdown` ( >- `ordernumber` int(11) default NULL, >- `linenumber` int(11) default NULL, >- `branchcode` varchar(10) default NULL, >- `bookfundid` varchar(10) NOT NULL default '', >- `allocation` smallint(6) default NULL, >- KEY `ordernumber` (`ordernumber`), >- KEY `bookfundid` (`bookfundid`), >- CONSTRAINT `aqorderbreakdown_ibfk_1` FOREIGN KEY (`ordernumber`) REFERENCES `aqorders` (`ordernumber`) ON DELETE CASCADE ON UPDATE CASCADE, >- CONSTRAINT `aqorderbreakdown_ibfk_2` FOREIGN KEY (`bookfundid`) REFERENCES `aqbookfund` (`bookfundid`) ON DELETE CASCADE ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `aqorderdelivery` >--- >- >-DROP TABLE IF EXISTS `aqorderdelivery`; >-CREATE TABLE `aqorderdelivery` ( >- `ordernumber` date default NULL, >- `deliverynumber` smallint(6) NOT NULL default 0, >- `deliverydate` varchar(18) default NULL, >- `qtydelivered` smallint(6) default NULL, >- `deliverycomments` mediumtext >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `aqorders` >--- >- >-DROP TABLE IF EXISTS `aqorders`; >-CREATE TABLE `aqorders` ( >- `ordernumber` int(11) NOT NULL auto_increment, >- `biblionumber` int(11) default NULL, >- `title` mediumtext, >- `entrydate` date default NULL, >- `quantity` smallint(6) default NULL, >- `currency` varchar(3) default NULL, >- `listprice` decimal(28,6) default NULL, >- `totalamount` decimal(28,6) default NULL, >- `datereceived` date default NULL, >- `booksellerinvoicenumber` mediumtext, >- `freight` decimal(28,6) default NULL, >- `unitprice` decimal(28,6) default NULL, >- `quantityreceived` smallint(6) default NULL, >- `cancelledby` varchar(10) default NULL, >- `datecancellationprinted` date default NULL, >- `notes` mediumtext, >- `supplierreference` mediumtext, >- `purchaseordernumber` mediumtext, >- `subscription` tinyint(1) default NULL, >- `serialid` varchar(30) default NULL, >- `basketno` int(11) default NULL, >- `biblioitemnumber` int(11) default NULL, >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, >- `rrp` decimal(13,2) default NULL, >- `ecost` decimal(13,2) default NULL, >- `gst` decimal(13,2) default NULL, >- `budgetdate` date default NULL, >- `sort1` varchar(80) default NULL, >- `sort2` varchar(80) default NULL, >- PRIMARY KEY (`ordernumber`), >- KEY `basketno` (`basketno`), >- KEY `biblionumber` (`biblionumber`), >- CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE, >- CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE SET NULL >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `auth_header` >--- >- >-DROP TABLE IF EXISTS `auth_header`; >-CREATE TABLE `auth_header` ( >- `authid` bigint(20) unsigned NOT NULL auto_increment, >- `authtypecode` varchar(10) NOT NULL default '', >- `datecreated` date default NULL, >- `datemodified` date default NULL, >- `origincode` varchar(20) default NULL, >- `authtrees` mediumtext, >- `marc` blob, >- `linkid` bigint(20) default NULL, >- `marcxml` longtext NOT NULL, >- PRIMARY KEY (`authid`), >- KEY `origincode` (`origincode`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `auth_subfield_structure` >--- >- >-DROP TABLE IF EXISTS `auth_subfield_structure`; >-CREATE TABLE `auth_subfield_structure` ( >- `authtypecode` varchar(10) NOT NULL default '', >- `tagfield` varchar(3) NOT NULL default '', >- `tagsubfield` varchar(1) NOT NULL default '', >- `liblibrarian` varchar(255) NOT NULL default '', >- `libopac` varchar(255) NOT NULL default '', >- `repeatable` tinyint(4) NOT NULL default 0, >- `mandatory` tinyint(4) NOT NULL default 0, >- `tab` tinyint(1) default NULL, >- `authorised_value` varchar(10) default NULL, >- `value_builder` varchar(80) default NULL, >- `seealso` varchar(255) default NULL, >- `isurl` tinyint(1) default NULL, >- `hidden` tinyint(3) NOT NULL default 0, >- `linkid` tinyint(1) NOT NULL default 0, >- `kohafield` varchar(45) NULL default '', >- `frameworkcode` varchar(8) NOT NULL default '', >- PRIMARY KEY (`authtypecode`,`tagfield`,`tagsubfield`), >- KEY `tab` (`authtypecode`,`tab`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `auth_tag_structure` >--- >- >-DROP TABLE IF EXISTS `auth_tag_structure`; >-CREATE TABLE `auth_tag_structure` ( >- `authtypecode` varchar(10) NOT NULL default '', >- `tagfield` varchar(3) NOT NULL default '', >- `liblibrarian` varchar(255) NOT NULL default '', >- `libopac` varchar(255) NOT NULL default '', >- `repeatable` tinyint(4) NOT NULL default 0, >- `mandatory` tinyint(4) NOT NULL default 0, >- `authorised_value` varchar(10) default NULL, >- PRIMARY KEY (`authtypecode`,`tagfield`), >- CONSTRAINT `auth_tag_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `auth_types` >--- >- >-DROP TABLE IF EXISTS `auth_types`; >-CREATE TABLE `auth_types` ( >- `authtypecode` varchar(10) NOT NULL default '', >- `authtypetext` varchar(255) NOT NULL default '', >- `auth_tag_to_report` varchar(3) NOT NULL default '', >- `summary` mediumtext NOT NULL, >- PRIMARY KEY (`authtypecode`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `authorised_values` >--- >- >-DROP TABLE IF EXISTS `authorised_values`; >-CREATE TABLE `authorised_values` ( >- `id` int(11) NOT NULL auto_increment, >- `category` varchar(10) NOT NULL default '', >- `authorised_value` varchar(80) NOT NULL default '', >- `lib` varchar(80) default NULL, >- PRIMARY KEY (`id`), >- KEY `name` (`category`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `biblio` >--- >- >-DROP TABLE IF EXISTS `biblio`; >-CREATE TABLE `biblio` ( >- `biblionumber` int(11) NOT NULL auto_increment, >- `frameworkcode` varchar(4) NOT NULL default '', >- `author` mediumtext, >- `title` mediumtext, >- `unititle` mediumtext, >- `notes` mediumtext, >- `serial` tinyint(1) default NULL, >- `seriestitle` mediumtext, >- `copyrightdate` smallint(6) default NULL, >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, >- `datecreated` DATE NOT NULL, >- `abstract` mediumtext, >- PRIMARY KEY (`biblionumber`), >- KEY `blbnoidx` (`biblionumber`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `biblio_framework` >--- >- >-DROP TABLE IF EXISTS `biblio_framework`; >-CREATE TABLE `biblio_framework` ( >- `frameworkcode` varchar(4) NOT NULL default '', >- `frameworktext` varchar(255) NOT NULL default '', >- PRIMARY KEY (`frameworkcode`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `biblioitems` >--- >- >-DROP TABLE IF EXISTS `biblioitems`; >-CREATE TABLE `biblioitems` ( >- `biblioitemnumber` int(11) NOT NULL auto_increment, >- `biblionumber` int(11) NOT NULL default 0, >- `volume` mediumtext, >- `number` mediumtext, >- `itemtype` varchar(10) default NULL, >- `isbn` varchar(14) default NULL, >- `issn` varchar(9) default NULL, >- `publicationyear` text, >- `publishercode` varchar(255) default NULL, >- `volumedate` date default NULL, >- `volumedesc` text, >- `collectiontitle` mediumtext default NULL, >- `collectionissn` text default NULL, >- `collectionvolume` mediumtext default NULL, >- `editionstatement` text default NULL, >- `editionresponsibility` text default NULL, >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, >- `illus` varchar(255) default NULL, >- `pages` varchar(255) default NULL, >- `notes` mediumtext, >- `size` varchar(255) default NULL, >- `place` varchar(255) default NULL, >- `lccn` varchar(25) default NULL, >- `marc` longblob, >- `url` varchar(255) default NULL, >- `cn_source` varchar(10) default NULL, >- `cn_class` varchar(30) default NULL, >- `cn_item` varchar(10) default NULL, >- `cn_suffix` varchar(10) default NULL, >- `cn_sort` varchar(30) default NULL, >- `totalissues` int(10), >- `marcxml` longtext NOT NULL, >- PRIMARY KEY (`biblioitemnumber`), >- KEY `bibinoidx` (`biblioitemnumber`), >- KEY `bibnoidx` (`biblionumber`), >- KEY `isbn` (`isbn`), >- KEY `publishercode` (`publishercode`), >- CONSTRAINT `biblioitems_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `borrowers` >--- >- >-DROP TABLE IF EXISTS `borrowers`; >-CREATE TABLE `borrowers` ( >- `borrowernumber` int(11) NOT NULL auto_increment, >- `cardnumber` varchar(16) default NULL, >- `surname` mediumtext NOT NULL, >- `firstname` text, >- `title` mediumtext, >- `othernames` mediumtext, >- `initials` text, >- `streetnumber` varchar(10) default NULL, >- `streettype` varchar(50) default NULL, >- `address` mediumtext NOT NULL, >- `address2` text, >- `city` mediumtext NOT NULL, >- `zipcode` varchar(25) default NULL, >- `email` mediumtext, >- `phone` text, >- `mobile` varchar(50) default NULL, >- `fax` mediumtext, >- `emailpro` text, >- `phonepro` text, >- `B_streetnumber` varchar(10) default NULL, >- `B_streettype` varchar(50) default NULL, >- `B_address` varchar(100) default NULL, >- `B_city` mediumtext, >- `B_zipcode` varchar(25) default NULL, >- `B_email` text, >- `B_phone` mediumtext, >- `dateofbirth` date default NULL, >- `branchcode` varchar(10) NOT NULL default '', >- `categorycode` varchar(10) NOT NULL default '', >- `dateenrolled` date default NULL, >- `dateexpiry` date default NULL, >- `gonenoaddress` tinyint(1) default NULL, >- `lost` tinyint(1) default NULL, >- `debarred` tinyint(1) default NULL, >- `contactname` mediumtext, >- `contactfirstname` text, >- `contacttitle` text, >- `guarantorid` int(11) default NULL, >- `borrowernotes` mediumtext, >- `relationship` varchar(100) default NULL, >- `ethnicity` varchar(50) default NULL, >- `ethnotes` varchar(255) default NULL, >- `sex` varchar(1) default NULL, >- `password` varchar(30) default NULL, >- `flags` int(11) default NULL, >- `userid` varchar(30) default NULL, >- `opacnote` mediumtext, >- `contactnote` varchar(255) default NULL, >- `sort1` varchar(80) default NULL, >- `sort2` varchar(80) default NULL, >- `altcontactfirstname` varchar(255) default NULL, >- `altcontactsurname` varchar(255) default NULL, >- `altcontactaddress1` varchar(255) default NULL, >- `altcontactaddress2` varchar(255) default NULL, >- `altcontactaddress3` varchar(255) default NULL, >- `altcontactzipcode` varchar(50) default NULL, >- `altcontactphone` varchar(50) default NULL, >- UNIQUE KEY `cardnumber` (`cardnumber`), >- PRIMARY KEY `borrowernumber` (`borrowernumber`), >- KEY `categorycode` (`categorycode`), >- KEY `branchcode` (`branchcode`), >- KEY `userid` (`userid`), >- CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`), >- CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `branchcategories` >--- >- >-DROP TABLE IF EXISTS `branchcategories`; >-CREATE TABLE `branchcategories` ( >- `categorycode` varchar(10) NOT NULL default '', >- `categoryname` varchar(32), >- `codedescription` mediumtext, >- `categorytype` varchar(16), >- PRIMARY KEY (`categorycode`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `branches` >--- >- >-DROP TABLE IF EXISTS `branches`; >-CREATE TABLE `branches` ( >- `branchcode` varchar(10) NOT NULL default '', >- `branchname` mediumtext NOT NULL, >- `branchaddress1` mediumtext, >- `branchaddress2` mediumtext, >- `branchaddress3` mediumtext, >- `branchphone` mediumtext, >- `branchfax` mediumtext, >- `branchemail` mediumtext, >- `issuing` tinyint(4) default NULL, >- `branchip` varchar(15) default NULL, >- `branchprinter` varchar(100) default NULL, >- UNIQUE KEY `branchcode` (`branchcode`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `branchrelations` >--- >- >-DROP TABLE IF EXISTS `branchrelations`; >-CREATE TABLE `branchrelations` ( >- `branchcode` varchar(10) NOT NULL default '', >- `categorycode` varchar(10) NOT NULL default '', >- PRIMARY KEY (`branchcode`,`categorycode`), >- KEY `branchcode` (`branchcode`), >- KEY `categorycode` (`categorycode`), >- CONSTRAINT `branchrelations_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, >- CONSTRAINT `branchrelations_ibfk_2` FOREIGN KEY (`categorycode`) REFERENCES `branchcategories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `branchtransfers` >--- >- >-DROP TABLE IF EXISTS `branchtransfers`; >-CREATE TABLE `branchtransfers` ( >- `itemnumber` int(11) NOT NULL default 0, >- `datesent` datetime default NULL, >- `frombranch` varchar(10) NOT NULL default '', >- `datearrived` datetime default NULL, >- `tobranch` varchar(10) NOT NULL default '', >- `comments` mediumtext, >- KEY `frombranch` (`frombranch`), >- KEY `tobranch` (`tobranch`), >- KEY `itemnumber` (`itemnumber`), >- CONSTRAINT `branchtransfers_ibfk_1` FOREIGN KEY (`frombranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, >- CONSTRAINT `branchtransfers_ibfk_2` FOREIGN KEY (`tobranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, >- CONSTRAINT `branchtransfers_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >- >--- >--- Table structure for table `browser` >--- >-DROP TABLE IF EXISTS `browser`; >-CREATE TABLE `browser` ( >- `level` int(11) NOT NULL, >- `classification` varchar(20) NOT NULL, >- `description` varchar(255) NOT NULL, >- `number` bigint(20) NOT NULL, >- `endnode` tinyint(4) NOT NULL >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `categories` >--- >- >-DROP TABLE IF EXISTS `categories`; >-CREATE TABLE `categories` ( >- `categorycode` varchar(10) NOT NULL default '', >- `description` mediumtext, >- `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(28,6) default NULL, >- `overduenoticerequired` tinyint(1) default NULL, >- `issuelimit` smallint(6) default NULL, >- `reservefee` decimal(28,6) default NULL, >- `category_type` varchar(1) NOT NULL default 'A', >- PRIMARY KEY (`categorycode`), >- UNIQUE KEY `categorycode` (`categorycode`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `categorytable` >--- >- >-DROP TABLE IF EXISTS `categorytable`; >-CREATE TABLE `categorytable` ( >- `categorycode` varchar(5) NOT NULL default '', >- `description` text, >- `itemtypecodes` text, >- PRIMARY KEY (`categorycode`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `cities` >--- >- >-DROP TABLE IF EXISTS `cities`; >-CREATE TABLE `cities` ( >- `cityid` int(11) NOT NULL auto_increment, >- `city_name` varchar(100) NOT NULL default '', >- `city_zipcode` varchar(20) default NULL, >- PRIMARY KEY (`cityid`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `class_sort_rules` >--- >- >-DROP TABLE IF EXISTS `class_sort_rules`; >-CREATE TABLE `class_sort_rules` ( >- `class_sort_rule` varchar(10) NOT NULL default '', >- `description` mediumtext, >- `sort_routine` varchar(30) NOT NULL default '', >- PRIMARY KEY (`class_sort_rule`), >- UNIQUE KEY `class_sort_rule_idx` (`class_sort_rule`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `class_sources` >--- >- >-DROP TABLE IF EXISTS `class_sources`; >-CREATE TABLE `class_sources` ( >- `cn_source` varchar(10) NOT NULL default '', >- `description` mediumtext, >- `used` tinyint(4) NOT NULL default 0, >- `class_sort_rule` varchar(10) NOT NULL default '', >- PRIMARY KEY (`cn_source`), >- UNIQUE KEY `cn_source_idx` (`cn_source`), >- KEY `used_idx` (`used`), >- CONSTRAINT `class_source_ibfk_1` FOREIGN KEY (`class_sort_rule`) REFERENCES `class_sort_rules` (`class_sort_rule`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `currency` >--- >- >-DROP TABLE IF EXISTS `currency`; >-CREATE TABLE `currency` ( >- `currency` varchar(10) NOT NULL default '', >- `symbol` varchar(5) default NULL, >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, >- `rate` float(7,5) default NULL, >- PRIMARY KEY (`currency`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `deletedbiblio` >--- >- >-DROP TABLE IF EXISTS `deletedbiblio`; >-CREATE TABLE `deletedbiblio` ( >- `biblionumber` int(11) NOT NULL default 0, >- `frameworkcode` varchar(4) NOT NULL default '', >- `author` mediumtext, >- `title` mediumtext, >- `unititle` mediumtext, >- `notes` mediumtext, >- `serial` tinyint(1) default NULL, >- `seriestitle` mediumtext, >- `copyrightdate` smallint(6) default NULL, >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, >- `datecreated` DATE NOT NULL, >- `abstract` mediumtext, >- PRIMARY KEY (`biblionumber`), >- KEY `blbnoidx` (`biblionumber`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `deletedbiblioitems` >--- >- >-DROP TABLE IF EXISTS `deletedbiblioitems`; >-CREATE TABLE `deletedbiblioitems` ( >- `biblioitemnumber` int(11) NOT NULL default 0, >- `biblionumber` int(11) NOT NULL default 0, >- `volume` mediumtext, >- `number` mediumtext, >- `itemtype` varchar(10) default NULL, >- `isbn` varchar(14) default NULL, >- `issn` varchar(9) default NULL, >- `publicationyear` text, >- `publishercode` varchar(255) default NULL, >- `volumedate` date default NULL, >- `volumedesc` text, >- `collectiontitle` mediumtext default NULL, >- `collectionissn` text default NULL, >- `collectionvolume` mediumtext default NULL, >- `editionstatement` text default NULL, >- `editionresponsibility` text default NULL, >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, >- `illus` varchar(255) default NULL, >- `pages` varchar(255) default NULL, >- `notes` mediumtext, >- `size` varchar(255) default NULL, >- `place` varchar(255) default NULL, >- `lccn` varchar(25) default NULL, >- `marc` longblob, >- `url` varchar(255) default NULL, >- `cn_source` varchar(10) default NULL, >- `cn_class` varchar(30) default NULL, >- `cn_item` varchar(10) default NULL, >- `cn_suffix` varchar(10) default NULL, >- `cn_sort` varchar(30) default NULL, >- `totalissues` int(10), >- `marcxml` longtext NOT NULL, >- PRIMARY KEY (`biblioitemnumber`), >- KEY `bibinoidx` (`biblioitemnumber`), >- KEY `bibnoidx` (`biblionumber`), >- KEY `isbn` (`isbn`), >- KEY `publishercode` (`publishercode`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `deletedborrowers` >--- >- >-DROP TABLE IF EXISTS `deletedborrowers`; >-CREATE TABLE `deletedborrowers` ( >- `borrowernumber` int(11) NOT NULL default 0, >- `cardnumber` varchar(9) NOT NULL default '', >- `surname` mediumtext NOT NULL, >- `firstname` text, >- `title` mediumtext, >- `othernames` mediumtext, >- `initials` text, >- `streetnumber` varchar(10) default NULL, >- `streettype` varchar(50) default NULL, >- `address` mediumtext NOT NULL, >- `address2` text, >- `city` mediumtext NOT NULL, >- `zipcode` varchar(25) default NULL, >- `email` mediumtext, >- `phone` text, >- `mobile` varchar(50) default NULL, >- `fax` mediumtext, >- `emailpro` text, >- `phonepro` text, >- `B_streetnumber` varchar(10) default NULL, >- `B_streettype` varchar(50) default NULL, >- `B_address` varchar(100) default NULL, >- `B_city` mediumtext, >- `B_zipcode` varchar(25) default NULL, >- `B_email` text, >- `B_phone` mediumtext, >- `dateofbirth` date default NULL, >- `branchcode` varchar(10) NOT NULL default '', >- `categorycode` varchar(2) default NULL, >- `dateenrolled` date default NULL, >- `dateexpiry` date default NULL, >- `gonenoaddress` tinyint(1) default NULL, >- `lost` tinyint(1) default NULL, >- `debarred` tinyint(1) default NULL, >- `contactname` mediumtext, >- `contactfirstname` text, >- `contacttitle` text, >- `guarantorid` int(11) default NULL, >- `borrowernotes` mediumtext, >- `relationship` varchar(100) default NULL, >- `ethnicity` varchar(50) default NULL, >- `ethnotes` varchar(255) default NULL, >- `sex` varchar(1) default NULL, >- `password` varchar(30) default NULL, >- `flags` int(11) default NULL, >- `userid` varchar(30) default NULL, >- `opacnote` mediumtext, >- `contactnote` varchar(255) default NULL, >- `sort1` varchar(80) default NULL, >- `sort2` varchar(80) default NULL, >- `altcontactfirstname` varchar(255) default NULL, >- `altcontactsurname` varchar(255) default NULL, >- `altcontactaddress1` varchar(255) default NULL, >- `altcontactaddress2` varchar(255) default NULL, >- `altcontactaddress3` varchar(255) default NULL, >- `altcontactzipcode` varchar(50) default NULL, >- `altcontactphone` varchar(50) default NULL, >- KEY `borrowernumber` (`borrowernumber`), >- KEY `cardnumber` (`cardnumber`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `deleteditems` >--- >- >-DROP TABLE IF EXISTS `deleteditems`; >-CREATE TABLE `deleteditems` ( >- `itemnumber` int(11) NOT NULL default 0, >- `biblionumber` int(11) NOT NULL default 0, >- `biblioitemnumber` int(11) NOT NULL default 0, >- `barcode` varchar(20) default NULL, >- `dateaccessioned` date default NULL, >- `booksellerid` varchar(10) default NULL, >- `homebranch` varchar(10) default NULL, >- `price` decimal(8,2) default NULL, >- `replacementprice` decimal(8,2) default NULL, >- `replacementpricedate` date default NULL, >- `datelastborrowed` date default NULL, >- `datelastseen` date default NULL, >- `stack` tinyint(1) default NULL, >- `notforloan` tinyint(1) NOT NULL default 0, >- `damaged` tinyint(1) NOT NULL default 0, >- `itemlost` tinyint(1) NOT NULL default 0, >- `wthdrawn` tinyint(1) NOT NULL default 0, >- `itemcallnumber` varchar(30) default NULL, >- `issues` smallint(6) default NULL, >- `renewals` smallint(6) default NULL, >- `reserves` smallint(6) default NULL, >- `restricted` tinyint(1) default NULL, >- `itemnotes` mediumtext, >- `holdingbranch` varchar(10) default NULL, >- `paidfor` mediumtext, >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, >- `location` varchar(80) default NULL, >- `onloan` date default NULL, >- `cn_source` varchar(10) default NULL, >- `cn_sort` varchar(30) default NULL, >- `ccode` varchar(10) default NULL, >- `materials` varchar(10) default NULL, >- `uri` varchar(255) default NULL, >- `itype` varchar(10) default NULL, >- `marc` longblob, >- PRIMARY KEY (`itemnumber`), >- KEY `delitembarcodeidx` (`barcode`), >- KEY `delitembinoidx` (`biblioitemnumber`), >- KEY `delitembibnoidx` (`biblionumber`), >- KEY `delhomebranch` (`homebranch`), >- KEY `delholdingbranch` (`holdingbranch`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `ethnicity` >--- >- >-DROP TABLE IF EXISTS `ethnicity`; >-CREATE TABLE `ethnicity` ( >- `code` varchar(10) NOT NULL default '', >- `name` varchar(255) default NULL, >- PRIMARY KEY (`code`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `import_batches` >--- >- >-DROP TABLE IF EXISTS `import_batches`; >-CREATE TABLE `import_batches` ( >- `import_batch_id` int(11) NOT NULL auto_increment, >- `matcher_id` int(11) default NULL, >- `template_id` int(11) default NULL, >- `branchcode` varchar(10) default NULL, >- `num_biblios` int(11) NOT NULL default 0, >- `num_items` int(11) NOT NULL default 0, >- `upload_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, >- `overlay_action` enum('replace', 'create_new', 'use_template') NOT NULL default 'create_new', >- `import_status` enum('staging', 'staged', 'importing', 'imported', 'reverting', 'reverted', 'cleaned') NOT NULL default 'staging', >- `batch_type` enum('batch', 'z3950') NOT NULL default 'batch', >- `file_name` varchar(100), >- `comments` mediumtext, >- PRIMARY KEY (`import_batch_id`), >- KEY `branchcode` (`branchcode`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `import_records` >--- >- >-DROP TABLE IF EXISTS `import_records`; >-CREATE TABLE `import_records` ( >- `import_record_id` int(11) NOT NULL auto_increment, >- `import_batch_id` int(11) NOT NULL, >- `branchcode` varchar(10) default NULL, >- `record_sequence` int(11) NOT NULL default 0, >- `upload_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, >- `import_date` DATE default NULL, >- `marc` longblob NOT NULL, >- `marcxml` longtext NOT NULL, >- `marcxml_old` longtext NOT NULL, >- `record_type` enum('biblio', 'auth', 'holdings') NOT NULL default 'biblio', >- `overlay_status` enum('no_match', 'auto_match', 'manual_match', 'match_applied') NOT NULL default 'no_match', >- `status` enum('error', 'staged', 'imported', 'reverted', 'items_reverted') NOT NULL default 'staged', >- `import_error` mediumtext, >- `encoding` varchar(40) NOT NULL default '', >- `z3950random` varchar(40) default NULL, >- PRIMARY KEY (`import_record_id`), >- CONSTRAINT `import_records_ifbk_1` FOREIGN KEY (`import_batch_id`) >- REFERENCES `import_batches` (`import_batch_id`) ON DELETE CASCADE ON UPDATE CASCADE, >- KEY `branchcode` (`branchcode`), >- KEY `batch_sequence` (`import_batch_id`, `record_sequence`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for `import_record_matches` >--- >-DROP TABLE IF EXISTS `import_record_matches`; >-CREATE TABLE `import_record_matches` ( >- `import_record_id` int(11) NOT NULL, >- `candidate_match_id` int(11) NOT NULL, >- `score` int(11) NOT NULL default 0, >- CONSTRAINT `import_record_matches_ibfk_1` FOREIGN KEY (`import_record_id`) >- REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE, >- KEY `record_score` (`import_record_id`, `score`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `import_biblios` >--- >- >-DROP TABLE IF EXISTS `import_biblios`; >-CREATE TABLE `import_biblios` ( >- `import_record_id` int(11) NOT NULL, >- `matched_biblionumber` int(11) default NULL, >- `control_number` varchar(25) default NULL, >- `original_source` varchar(25) default NULL, >- `title` varchar(128) default NULL, >- `author` varchar(80) default NULL, >- `isbn` varchar(14) default NULL, >- `issn` varchar(9) default NULL, >- `has_items` tinyint(1) NOT NULL default 0, >- CONSTRAINT `import_biblios_ibfk_1` FOREIGN KEY (`import_record_id`) >- REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE, >- KEY `matched_biblionumber` (`matched_biblionumber`), >- KEY `title` (`title`), >- KEY `isbn` (`isbn`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `import_items` >--- >- >-DROP TABLE IF EXISTS `import_items`; >-CREATE TABLE `import_items` ( >- `import_items_id` int(11) NOT NULL auto_increment, >- `import_record_id` int(11) NOT NULL, >- `itemnumber` int(11) default NULL, >- `branchcode` varchar(10) default NULL, >- `status` enum('error', 'staged', 'imported', 'reverted') NOT NULL default 'staged', >- `marcxml` longtext NOT NULL, >- `import_error` mediumtext, >- PRIMARY KEY (`import_items_id`), >- CONSTRAINT `import_items_ibfk_1` FOREIGN KEY (`import_record_id`) >- REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE, >- KEY `itemnumber` (`itemnumber`), >- KEY `branchcode` (`branchcode`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `issues` >--- >- >-DROP TABLE IF EXISTS `issues`; >-CREATE TABLE `issues` ( >- `borrowernumber` int(11) default NULL, >- `itemnumber` int(11) default NULL, >- `date_due` date default NULL, >- `branchcode` varchar(10) default NULL, >- `issuingbranch` varchar(18) default NULL, >- `returndate` date default NULL, >- `lastreneweddate` date default NULL, >- `return` varchar(4) default NULL, >- `renewals` tinyint(4) default NULL, >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, >- `issuedate` date default NULL, >- KEY `issuesborridx` (`borrowernumber`), >- KEY `issuesitemidx` (`itemnumber`), >- KEY `bordate` (`borrowernumber`,`timestamp`), >- CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL, >- CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `issuingrules` >--- >- >-DROP TABLE IF EXISTS `issuingrules`; >-CREATE TABLE `issuingrules` ( >- `categorycode` varchar(10) NOT NULL default '', >- `itemtype` varchar(10) NOT NULL default '', >- `restrictedtype` tinyint(1) default NULL, >- `rentaldiscount` decimal(28,6) default NULL, >- `reservecharge` decimal(28,6) default NULL, >- `fine` decimal(28,6) default NULL, >- `firstremind` int(11) default NULL, >- `chargeperiod` int(11) default NULL, >- `accountsent` int(11) default NULL, >- `chargename` varchar(100) default NULL, >- `maxissueqty` int(4) default NULL, >- `issuelength` int(4) default NULL, >- `branchcode` varchar(10) NOT NULL default '', >- PRIMARY KEY (`branchcode`,`categorycode`,`itemtype`), >- KEY `categorycode` (`categorycode`), >- KEY `itemtype` (`itemtype`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `items` >--- >- >-DROP TABLE IF EXISTS `items`; >-CREATE TABLE `items` ( >- `itemnumber` int(11) NOT NULL auto_increment, >- `biblionumber` int(11) NOT NULL default 0, >- `biblioitemnumber` int(11) NOT NULL default 0, >- `barcode` varchar(20) default NULL, >- `dateaccessioned` date default NULL, >- `booksellerid` varchar(10) default NULL, >- `homebranch` varchar(10) default NULL, >- `price` decimal(8,2) default NULL, >- `replacementprice` decimal(8,2) default NULL, >- `replacementpricedate` date default NULL, >- `datelastborrowed` date default NULL, >- `datelastseen` date default NULL, >- `stack` tinyint(1) default NULL, >- `notforloan` tinyint(1) NOT NULL default 0, >- `damaged` tinyint(1) NOT NULL default 0, >- `itemlost` tinyint(1) NOT NULL default 0, >- `wthdrawn` tinyint(1) NOT NULL default 0, >- `itemcallnumber` varchar(30) default NULL, >- `issues` smallint(6) default NULL, >- `renewals` smallint(6) default NULL, >- `reserves` smallint(6) default NULL, >- `restricted` tinyint(1) default NULL, >- `itemnotes` mediumtext, >- `holdingbranch` varchar(10) default NULL, >- `paidfor` mediumtext, >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, >- `location` varchar(80) default NULL, >- `onloan` date default NULL, >- `cn_source` varchar(10) default NULL, >- `cn_sort` varchar(30) default NULL, >- `ccode` varchar(10) default NULL, >- `materials` varchar(10) default NULL, >- `uri` varchar(255) default NULL, >- `itype` varchar(10) default NULL, >- PRIMARY KEY (`itemnumber`), >- UNIQUE KEY `itembarcodeidx` (`barcode`), >- KEY `itembinoidx` (`biblioitemnumber`), >- KEY `itembibnoidx` (`biblionumber`), >- KEY `homebranch` (`homebranch`), >- KEY `holdingbranch` (`holdingbranch`), >- CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `biblioitems` (`biblioitemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, >- CONSTRAINT `items_ibfk_2` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE, >- CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `itemtypes` >--- >- >-DROP TABLE IF EXISTS `itemtypes`; >-CREATE TABLE `itemtypes` ( >- `itemtype` varchar(10) NOT NULL default '', >- `description` mediumtext, >- `renewalsallowed` smallint(6) default NULL, >- `rentalcharge` double(16,4) default NULL, >- `notforloan` smallint(6) default NULL, >- `imageurl` varchar(200) default NULL, >- `summary` text, >- PRIMARY KEY (`itemtype`), >- UNIQUE KEY `itemtype` (`itemtype`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `labels` >--- >- >-DROP TABLE IF EXISTS `labels`; >-CREATE TABLE `labels` ( >- `labelid` int(11) NOT NULL auto_increment, >- `batch_id` varchar(10) NOT NULL default 1, >- `itemnumber` varchar(100) NOT NULL default '', >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, >- PRIMARY KEY (`labelid`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `labels_conf` >--- >- >-DROP TABLE IF EXISTS `labels_conf`; >-CREATE TABLE `labels_conf` ( >- `id` int(4) NOT NULL auto_increment, >- `barcodetype` char(100) default '', >- `title` int(1) default '0', >- `subtitle` int(1) default '0', >- `itemtype` int(1) default '0', >- `barcode` int(1) default '0', >- `dewey` int(1) default '0', >- `class` int(1) default NULL, >- `subclass` int(1) default '0', >- `itemcallnumber` int(1) default '0', >- `author` int(1) default '0', >- `issn` int(1) default '0', >- `isbn` int(1) default '0', >- `startlabel` int(2) NOT NULL default '1', >- `printingtype` char(32) default 'BAR', >- `layoutname` char(20) NOT NULL default 'TEST', >- `guidebox` int(1) default '0', >- `active` tinyint(1) default '1', >- `fonttype` char(10) collate utf8_unicode_ci default NULL, >- `ccode` char(4) collate utf8_unicode_ci default NULL, >- `callnum_split` int(1) default NULL, >- `text_justify` char(1) collate utf8_unicode_ci default NULL, >- PRIMARY KEY (`id`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `labels_templates` >--- >- >-DROP TABLE IF EXISTS `labels_templates`; >-CREATE TABLE `labels_templates` ( >-`tmpl_id` int(4) NOT NULL auto_increment, >- `tmpl_code` char(100) default '', >- `tmpl_desc` char(100) default '', >- `page_width` float default '0', >- `page_height` float default '0', >- `label_width` float default '0', >- `label_height` float default '0', >- `topmargin` float default '0', >- `leftmargin` float default '0', >- `cols` int(2) default '0', >- `rows` int(2) default '0', >- `colgap` float default '0', >- `rowgap` float default '0', >- `active` int(1) default NULL, >- `units` char(20) default 'PX', >- `fontsize` int(4) NOT NULL default '3', >- PRIMARY KEY (`tmpl_id`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `letter` >--- >- >-DROP TABLE IF EXISTS `letter`; >-CREATE TABLE `letter` ( >- `module` varchar(20) NOT NULL default '', >- `code` varchar(20) NOT NULL default '', >- `name` varchar(100) NOT NULL default '', >- `title` varchar(200) NOT NULL default '', >- `content` text, >- PRIMARY KEY (`module`,`code`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `marc_subfield_structure` >--- >- >-DROP TABLE IF EXISTS `marc_subfield_structure`; >-CREATE TABLE `marc_subfield_structure` ( >- `tagfield` varchar(3) NOT NULL default '', >- `tagsubfield` varchar(1) NOT NULL default '', >- `liblibrarian` varchar(255) NOT NULL default '', >- `libopac` varchar(255) NOT NULL default '', >- `repeatable` tinyint(4) NOT NULL default 0, >- `mandatory` tinyint(4) NOT NULL default 0, >- `kohafield` varchar(40) default NULL, >- `tab` tinyint(1) default NULL, >- `authorised_value` varchar(20) default NULL, >- `authtypecode` varchar(20) default NULL, >- `value_builder` varchar(80) default NULL, >- `isurl` tinyint(1) default NULL, >- `hidden` tinyint(1) default NULL, >- `frameworkcode` varchar(4) NOT NULL default '', >- `seealso` varchar(1100) default NULL, >- `link` varchar(80) default NULL, >- `defaultvalue` text default NULL, >- PRIMARY KEY (`frameworkcode`,`tagfield`,`tagsubfield`), >- KEY `kohafield_2` (`kohafield`), >- KEY `tab` (`frameworkcode`,`tab`), >- KEY `kohafield` (`frameworkcode`,`kohafield`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `marc_tag_structure` >--- >- >-DROP TABLE IF EXISTS `marc_tag_structure`; >-CREATE TABLE `marc_tag_structure` ( >- `tagfield` varchar(3) NOT NULL default '', >- `liblibrarian` varchar(255) NOT NULL default '', >- `libopac` varchar(255) NOT NULL default '', >- `repeatable` tinyint(4) NOT NULL default 0, >- `mandatory` tinyint(4) NOT NULL default 0, >- `authorised_value` varchar(10) default NULL, >- `frameworkcode` varchar(4) NOT NULL default '', >- PRIMARY KEY (`frameworkcode`,`tagfield`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `marc_matchers` >--- >- >-DROP TABLE IF EXISTS `marc_matchers`; >-CREATE TABLE `marc_matchers` ( >- `matcher_id` int(11) NOT NULL auto_increment, >- `code` varchar(10) NOT NULL default '', >- `description` varchar(255) NOT NULL default '', >- `record_type` varchar(10) NOT NULL default 'biblio', >- `threshold` int(11) NOT NULL default 0, >- PRIMARY KEY (`matcher_id`), >- KEY `code` (`code`), >- KEY `record_type` (`record_type`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `matchpoints` >--- >-DROP TABLE IF EXISTS `matchpoints`; >-CREATE TABLE `matchpoints` ( >- `matcher_id` int(11) NOT NULL, >- `matchpoint_id` int(11) NOT NULL auto_increment, >- `search_index` varchar(30) NOT NULL default '', >- `score` int(11) NOT NULL default 0, >- PRIMARY KEY (`matchpoint_id`), >- CONSTRAINT `matchpoints_ifbk_1` FOREIGN KEY (`matcher_id`) >- REFERENCES `marc_matchers` (`matcher_id`) ON DELETE CASCADE ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >- >--- >--- Table structure for table `matchpoint_components` >--- >-DROP TABLE IF EXISTS `matchpoint_components`; >-CREATE TABLE `matchpoint_components` ( >- `matchpoint_id` int(11) NOT NULL, >- `matchpoint_component_id` int(11) NOT NULL auto_increment, >- sequence int(11) NOT NULL default 0, >- tag varchar(3) NOT NULL default '', >- subfields varchar(40) NOT NULL default '', >- offset int(4) NOT NULL default 0, >- length int(4) NOT NULL default 0, >- PRIMARY KEY (`matchpoint_component_id`), >- KEY `by_sequence` (`matchpoint_id`, `sequence`), >- CONSTRAINT `matchpoint_components_ifbk_1` FOREIGN KEY (`matchpoint_id`) >- REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `matcher_component_norms` >--- >-DROP TABLE IF EXISTS `matchpoint_component_norms`; >-CREATE TABLE `matchpoint_component_norms` ( >- `matchpoint_component_id` int(11) NOT NULL, >- `sequence` int(11) NOT NULL default 0, >- `norm_routine` varchar(50) NOT NULL default '', >- KEY `matchpoint_component_norms` (`matchpoint_component_id`, `sequence`), >- CONSTRAINT `matchpoint_component_norms_ifbk_1` FOREIGN KEY (`matchpoint_component_id`) >- REFERENCES `matchpoint_components` (`matchpoint_component_id`) ON DELETE CASCADE ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `matcher_matchpoints` >--- >-DROP TABLE IF EXISTS `matcher_matchpoints`; >-CREATE TABLE `matcher_matchpoints` ( >- `matcher_id` int(11) NOT NULL, >- `matchpoint_id` int(11) NOT NULL, >- CONSTRAINT `matcher_matchpoints_ifbk_1` FOREIGN KEY (`matcher_id`) >- REFERENCES `marc_matchers` (`matcher_id`) ON DELETE CASCADE ON UPDATE CASCADE, >- CONSTRAINT `matcher_matchpoints_ifbk_2` FOREIGN KEY (`matchpoint_id`) >- REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `matchchecks` >--- >-DROP TABLE IF EXISTS `matchchecks`; >-CREATE TABLE `matchchecks` ( >- `matcher_id` int(11) NOT NULL, >- `matchcheck_id` int(11) NOT NULL auto_increment, >- `source_matchpoint_id` int(11) NOT NULL, >- `target_matchpoint_id` int(11) NOT NULL, >- PRIMARY KEY (`matchcheck_id`), >- CONSTRAINT `matcher_matchchecks_ifbk_1` FOREIGN KEY (`matcher_id`) >- REFERENCES `marc_matchers` (`matcher_id`) ON DELETE CASCADE ON UPDATE CASCADE, >- CONSTRAINT `matcher_matchchecks_ifbk_2` FOREIGN KEY (`source_matchpoint_id`) >- REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE, >- CONSTRAINT `matcher_matchchecks_ifbk_3` FOREIGN KEY (`target_matchpoint_id`) >- REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `mediatypetable` >--- >- >-DROP TABLE IF EXISTS `mediatypetable`; >-CREATE TABLE `mediatypetable` ( >- `mediatypecode` varchar(5) NOT NULL default '', >- `description` text, >- `itemtypecodes` text, >- PRIMARY KEY (`mediatypecode`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `notifys` >--- >- >-DROP TABLE IF EXISTS `notifys`; >-CREATE TABLE `notifys` ( >- `notify_id` int(11) NOT NULL default 0, >- `borrowernumber` int(11) NOT NULL default 0, >- `itemnumber` int(11) NOT NULL default 0, >- `notify_date` date default NULL, >- `notify_send_date` date default NULL, >- `notify_level` int(1) NOT NULL default 0, >- `method` varchar(20) NOT NULL default '' >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `nozebra` >--- >-DROP TABLE IF EXISTS `nozebra`; >-CREATE TABLE `nozebra` ( >- `server` varchar(20) NOT NULL, >- `indexname` varchar(40) NOT NULL, >- `value` varchar(250) NOT NULL, >- `biblionumbers` longtext NOT NULL, >- KEY `indexname` (`server`,`indexname`), >- KEY `value` (`server`,`value`)) >- ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `opac_news` >--- >- >-DROP TABLE IF EXISTS `opac_news`; >-CREATE TABLE `opac_news` ( >- `idnew` int(10) unsigned NOT NULL auto_increment, >- `title` varchar(250) NOT NULL default '', >- `new` text NOT NULL, >- `lang` varchar(4) NOT NULL default '', >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, >- `expirationdate` date default NULL, >- `number` int(11) default NULL, >- PRIMARY KEY (`idnew`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `overduerules` >--- >- >-DROP TABLE IF EXISTS `overduerules`; >-CREATE TABLE `overduerules` ( >- `branchcode` varchar(10) NOT NULL default '', >- `categorycode` varchar(2) NOT NULL default '', >- `delay1` int(4) default 0, >- `letter1` varchar(20) default NULL, >- `debarred1` varchar(1) default 0, >- `delay2` int(4) default 0, >- `debarred2` varchar(1) default 0, >- `letter2` varchar(20) default NULL, >- `delay3` int(4) default 0, >- `letter3` varchar(20) default NULL, >- `debarred3` int(1) default 0, >- PRIMARY KEY (`branchcode`,`categorycode`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `printers` >--- >- >-DROP TABLE IF EXISTS `printers`; >-CREATE TABLE `printers` ( >- `printername` varchar(40) NOT NULL default '', >- `printqueue` varchar(20) default NULL, >- `printtype` varchar(20) default NULL, >- PRIMARY KEY (`printername`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `repeatable_holidays` >--- >- >-DROP TABLE IF EXISTS `repeatable_holidays`; >-CREATE TABLE `repeatable_holidays` ( >- `id` int(11) NOT NULL auto_increment, >- `branchcode` varchar(10) NOT NULL default '', >- `weekday` smallint(6) default NULL, >- `day` smallint(6) default NULL, >- `month` smallint(6) default NULL, >- `title` varchar(50) NOT NULL default '', >- `description` text NOT NULL, >- PRIMARY KEY (`id`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `reports_dictionary` >--- >- >-DROP TABLE IF EXISTS `reports_dictionary`; >-CREATE TABLE reports_dictionary ( >- `id` int(11) NOT NULL auto_increment, >- `name` varchar(255) default NULL, >- `description` text, >- `date_created` datetime default NULL, >- `date_modified` datetime default NULL, >- `saved_sql` text, >- `area` int(11) default NULL, >- PRIMARY KEY (`id`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `reserveconstraints` >--- >- >-DROP TABLE IF EXISTS `reserveconstraints`; >-CREATE TABLE `reserveconstraints` ( >- `borrowernumber` int(11) NOT NULL default 0, >- `reservedate` date default NULL, >- `biblionumber` int(11) NOT NULL default 0, >- `biblioitemnumber` int(11) default NULL, >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `reserves` >--- >- >-DROP TABLE IF EXISTS `reserves`; >-CREATE TABLE `reserves` ( >- `borrowernumber` int(11) NOT NULL default 0, >- `reservedate` date default NULL, >- `biblionumber` int(11) NOT NULL default 0, >- `constrainttype` varchar(1) default NULL, >- `branchcode` varchar(10) default NULL, >- `notificationdate` date default NULL, >- `reminderdate` date default NULL, >- `cancellationdate` date default NULL, >- `reservenotes` mediumtext, >- `priority` smallint(6) default NULL, >- `found` varchar(1) default NULL, >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, >- `itemnumber` int(11) default NULL, >- `waitingdate` date default NULL, >- KEY `borrowernumber` (`borrowernumber`), >- KEY `biblionumber` (`biblionumber`), >- KEY `itemnumber` (`itemnumber`), >- KEY `branchcode` (`branchcode`), >- CONSTRAINT `reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, >- CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE, >- CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, >- CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `reviews` >--- >- >-DROP TABLE IF EXISTS `reviews`; >-CREATE TABLE `reviews` ( >- `reviewid` int(11) NOT NULL auto_increment, >- `borrowernumber` int(11) default NULL, >- `biblionumber` int(11) default NULL, >- `review` text, >- `approved` tinyint(4) default NULL, >- `datereviewed` datetime default NULL, >- PRIMARY KEY (`reviewid`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `roadtype` >--- >- >-DROP TABLE IF EXISTS `roadtype`; >-CREATE TABLE `roadtype` ( >- `roadtypeid` int(11) NOT NULL auto_increment, >- `road_type` varchar(100) NOT NULL default '', >- PRIMARY KEY (`roadtypeid`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `saved_sql` >--- >- >-DROP TABLE IF EXISTS `saved_sql`; >-CREATE TABLE saved_sql ( >- `id` int(11) NOT NULL auto_increment, >- `borrowernumber` int(11) default NULL, >- `date_created` datetime default NULL, >- `last_modified` datetime default NULL, >- `savedsql` text, >- `last_run` datetime default NULL, >- `report_name` varchar(255) default NULL, >- `type` varchar(255) default NULL, >- `notes` text, >- PRIMARY KEY (`id`), >- KEY boridx (`borrowernumber`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >- >--- >--- Table structure for `saved_reports` >--- >- >-DROP TABLE IF EXISTS `saved_reports`; >-CREATE TABLE saved_reports ( >- `id` int(11) NOT NULL auto_increment, >- `report_id` int(11) default NULL, >- `report` longtext, >- `date_run` datetime default NULL, >- PRIMARY KEY (`id`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >- >--- >--- Table structure for table `serial` >--- >- >-DROP TABLE IF EXISTS `serial`; >-CREATE TABLE `serial` ( >- `serialid` int(11) NOT NULL auto_increment, >- `biblionumber` varchar(100) NOT NULL default '', >- `subscriptionid` varchar(100) NOT NULL default '', >- `serialseq` varchar(100) NOT NULL default '', >- `status` tinyint(4) NOT NULL default 0, >- `planneddate` date default NULL, >- `notes` text, >- `publisheddate` date default NULL, >- `itemnumber` text, >- `claimdate` date default NULL, >- `routingnotes` text, >- PRIMARY KEY (`serialid`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `sessions` >--- >- >-DROP TABLE IF EXISTS sessions; >-CREATE TABLE sessions ( >- `id` varchar(32) NOT NULL, >- `a_session` text NOT NULL, >- UNIQUE KEY id (id) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `special_holidays` >--- >- >-DROP TABLE IF EXISTS `special_holidays`; >-CREATE TABLE `special_holidays` ( >- `id` int(11) NOT NULL auto_increment, >- `branchcode` varchar(10) NOT NULL default '', >- `day` smallint(6) NOT NULL default 0, >- `month` smallint(6) NOT NULL default 0, >- `year` smallint(6) NOT NULL default 0, >- `isexception` smallint(1) NOT NULL default 1, >- `title` varchar(50) NOT NULL default '', >- `description` text NOT NULL, >- PRIMARY KEY (`id`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `statistics` >--- >- >-DROP TABLE IF EXISTS `statistics`; >-CREATE TABLE `statistics` ( >- `datetime` datetime default NULL, >- `branch` varchar(10) default NULL, >- `proccode` varchar(4) default NULL, >- `value` double(16,4) default NULL, >- `type` varchar(16) default NULL, >- `other` mediumtext, >- `usercode` varchar(10) default NULL, >- `itemnumber` int(11) default NULL, >- `itemtype` varchar(10) default NULL, >- `borrowernumber` int(11) default NULL, >- `associatedborrower` int(11) default NULL, >- KEY `timeidx` (`datetime`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `stopwords` >--- >- >-DROP TABLE IF EXISTS `stopwords`; >- CREATE TABLE `stopwords` ( >- `word` varchar(255) default NULL >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `subcategorytable` >--- >- >-DROP TABLE IF EXISTS `subcategorytable`; >-CREATE TABLE `subcategorytable` ( >- `subcategorycode` varchar(5) NOT NULL default '', >- `description` text, >- `itemtypecodes` text, >- PRIMARY KEY (`subcategorycode`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `subscription` >--- >- >-DROP TABLE IF EXISTS `subscription`; >-CREATE TABLE `subscription` ( >- `biblionumber` int(11) NOT NULL default 0, >- `subscriptionid` int(11) NOT NULL auto_increment, >- `librarian` varchar(100) default '', >- `startdate` date default NULL, >- `aqbooksellerid` int(11) default 0, >- `cost` int(11) default 0, >- `aqbudgetid` int(11) default 0, >- `weeklength` tinyint(4) default 0, >- `monthlength` tinyint(4) default 0, >- `numberlength` tinyint(4) default 0, >- `periodicity` tinyint(4) default 0, >- `dow` varchar(100) default '', >- `numberingmethod` varchar(100) default '', >- `notes` mediumtext, >- `status` varchar(100) NOT NULL default '', >- `add1` int(11) default 0, >- `every1` int(11) default 0, >- `whenmorethan1` int(11) default 0, >- `setto1` int(11) default NULL, >- `lastvalue1` int(11) default NULL, >- `add2` int(11) default 0, >- `every2` int(11) default 0, >- `whenmorethan2` int(11) default 0, >- `setto2` int(11) default NULL, >- `lastvalue2` int(11) default NULL, >- `add3` int(11) default 0, >- `every3` int(11) default 0, >- `innerloop1` int(11) default 0, >- `innerloop2` int(11) default 0, >- `innerloop3` int(11) default 0, >- `whenmorethan3` int(11) default 0, >- `setto3` int(11) default NULL, >- `lastvalue3` int(11) default NULL, >- `issuesatonce` tinyint(3) NOT NULL default 1, >- `firstacquidate` date default NULL, >- `manualhistory` tinyint(1) NOT NULL default 0, >- `irregularity` text, >- `letter` varchar(20) default NULL, >- `numberpattern` tinyint(3) default 0, >- `distributedto` text, >- `internalnotes` longtext, >- `callnumber` text, >- `branchcode` varchar(10) NOT NULL default '', >- `hemisphere` tinyint(3) default 0, >- `lastbranch` varchar(10), >- PRIMARY KEY (`subscriptionid`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `subscriptionhistory` >--- >- >-DROP TABLE IF EXISTS `subscriptionhistory`; >-CREATE TABLE `subscriptionhistory` ( >- `biblionumber` int(11) NOT NULL default 0, >- `subscriptionid` int(11) NOT NULL default 0, >- `histstartdate` date default NULL, >- `enddate` date default NULL, >- `missinglist` longtext NOT NULL, >- `recievedlist` longtext NOT NULL, >- `opacnote` varchar(150) NOT NULL default '', >- `librariannote` varchar(150) NOT NULL default '', >- PRIMARY KEY (`subscriptionid`), >- KEY `biblionumber` (`biblionumber`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `subscriptionroutinglist` >--- >- >-DROP TABLE IF EXISTS `subscriptionroutinglist`; >-CREATE TABLE `subscriptionroutinglist` ( >- `routingid` int(11) NOT NULL auto_increment, >- `borrowernumber` int(11) default NULL, >- `ranking` int(11) default NULL, >- `subscriptionid` int(11) default NULL, >- PRIMARY KEY (`routingid`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `suggestions` >--- >- >-DROP TABLE IF EXISTS `suggestions`; >-CREATE TABLE `suggestions` ( >- `suggestionid` int(8) NOT NULL auto_increment, >- `suggestedby` int(11) NOT NULL default 0, >- `managedby` int(11) default NULL, >- `STATUS` varchar(10) NOT NULL default '', >- `note` mediumtext, >- `author` varchar(80) default NULL, >- `title` varchar(80) default NULL, >- `copyrightdate` smallint(6) default NULL, >- `publishercode` varchar(255) default NULL, >- `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, >- `volumedesc` varchar(255) default NULL, >- `publicationyear` smallint(6) default 0, >- `place` varchar(255) default NULL, >- `isbn` varchar(10) default NULL, >- `mailoverseeing` smallint(1) default 0, >- `biblionumber` int(11) default NULL, >- `reason` text, >- PRIMARY KEY (`suggestionid`), >- KEY `suggestedby` (`suggestedby`), >- KEY `managedby` (`managedby`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `systempreferences` >--- >- >-DROP TABLE IF EXISTS `systempreferences`; >-CREATE TABLE `systempreferences` ( >- `variable` varchar(50) NOT NULL default '', >- `value` text, >- `options` mediumtext, >- `explanation` text, >- `type` varchar(20) default NULL, >- PRIMARY KEY (`variable`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `tags` >--- >- >-DROP TABLE IF EXISTS `tags`; >-CREATE TABLE `tags` ( >- `entry` varchar(255) NOT NULL default '', >- `weight` bigint(20) NOT NULL default 0, >- PRIMARY KEY (`entry`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `userflags` >--- >- >-DROP TABLE IF EXISTS `userflags`; >-CREATE TABLE `userflags` ( >- `bit` int(11) NOT NULL default 0, >- `flag` varchar(30) default NULL, >- `flagdesc` varchar(255) default NULL, >- `defaulton` int(11) default NULL, >- PRIMARY KEY (`bit`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `virtualshelves` >--- >- >-DROP TABLE IF EXISTS `virtualshelves`; >-CREATE TABLE `virtualshelves` ( >- `shelfnumber` int(11) NOT NULL auto_increment, >- `shelfname` varchar(255) default NULL, >- `owner` varchar(80) default NULL, >- `category` varchar(1) default NULL, >- `sortfield` varchar(16) default NULL, >- PRIMARY KEY (`shelfnumber`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `virtualshelfcontents` >--- >- >-DROP TABLE IF EXISTS `virtualshelfcontents`; >-CREATE TABLE `virtualshelfcontents` ( >- `shelfnumber` int(11) NOT NULL default 0, >- `biblionumber` int(11) NOT NULL default 0, >- `flags` int(11) default NULL, >- `dateadded` timestamp NULL default NULL, >- KEY `shelfnumber` (`shelfnumber`), >- KEY `biblionumber` (`biblionumber`), >- CONSTRAINT `virtualshelfcontents_ibfk_1` FOREIGN KEY (`shelfnumber`) REFERENCES `virtualshelves` (`shelfnumber`) ON DELETE CASCADE ON UPDATE CASCADE, >- CONSTRAINT `shelfcontents_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `z3950servers` >--- >- >-DROP TABLE IF EXISTS `z3950servers`; >-CREATE TABLE `z3950servers` ( >- `host` varchar(255) default NULL, >- `port` int(11) default NULL, >- `db` varchar(255) default NULL, >- `userid` varchar(255) default NULL, >- `password` varchar(255) default NULL, >- `name` mediumtext, >- `id` int(11) NOT NULL auto_increment, >- `checked` smallint(6) default NULL, >- `rank` int(11) default NULL, >- `syntax` varchar(80) default NULL, >- `icon` text, >- `position` enum('primary','secondary','') NOT NULL default 'primary', >- `type` enum('zed','opensearch') NOT NULL default 'zed', >- `description` text NOT NULL, >- PRIMARY KEY (`id`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `zebraqueue` >--- >- >-DROP TABLE IF EXISTS `zebraqueue`; >-CREATE TABLE `zebraqueue` ( >- `id` int(11) NOT NULL auto_increment, >- `biblio_auth_number` int(11) NOT NULL default '0', >- `operation` char(20) NOT NULL default '', >- `server` char(20) NOT NULL default '', >- `done` int(11) NOT NULL default '0', >- `time` timestamp NOT NULL default CURRENT_TIMESTAMP, >- PRIMARY KEY (`id`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >-DROP TABLE IF EXISTS `services_throttle`; >-CREATE TABLE `services_throttle` ( >- `service_type` varchar(10) NOT NULL default '', >- `service_count` varchar(45) default NULL, >- PRIMARY KEY (`service_type`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- http://www.w3.org/International/articles/language-tags/ >- >--- RFC4646 >-DROP TABLE IF EXISTS language_subtag_registry; >-CREATE TABLE language_subtag_registry ( >- subtag varchar(25), >- type varchar(25), -- language-script-region-variant-extension-privateuse >- description varchar(25), -- only one of the possible descriptions for ease of reference, see language_descriptions for the complete list >- added date, >- KEY `subtag` (`subtag`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- TODO: add suppress_scripts >--- this maps three letter codes defined in iso639.2 back to their >--- two letter equivilents in rfc4646 (LOC maintains iso639+) >-DROP TABLE IF EXISTS language_rfc4646_to_iso639; >-CREATE TABLE language_rfc4646_to_iso639 ( >- rfc4646_subtag varchar(25), >- iso639_2_code varchar(25), >- KEY `rfc4646_subtag` (`rfc4646_subtag`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >-DROP TABLE IF EXISTS language_descriptions; >-CREATE TABLE language_descriptions ( >- subtag varchar(25), >- type varchar(25), >- lang varchar(25), >- description varchar(255), >- KEY `lang` (`lang`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- bi-directional support, keyed by script subcode >-DROP TABLE IF EXISTS language_script_bidi; >-CREATE TABLE language_script_bidi ( >- rfc4646_subtag varchar(25), -- script subtag, Arab, Hebr, etc. >- bidi varchar(3), -- rtl ltr >- KEY `rfc4646_subtag` (`rfc4646_subtag`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- TODO: need to map language subtags to script subtags for detection >--- of bidi when script is not specified (like ar, he) >-DROP TABLE IF EXISTS language_script_mapping; >-CREATE TABLE language_script_mapping ( >- language_subtag varchar(25), >- script_subtag varchar(25), >- KEY `language_subtag` (`language_subtag`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >-/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; >-/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; >-/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; >-/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; >-/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; >-/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; >-/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; >-/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; >- >diff --git a/t/data/db_schemas/kohastructure.sql-3.00.00-beta-067 b/t/data/db_schemas/kohastructure.sql-3.00.00-beta-067 >deleted file mode 100644 >index 834bb1f..0000000 >--- a/t/data/db_schemas/kohastructure.sql-3.00.00-beta-067 >+++ /dev/null >@@ -1,2029 +0,0 @@ >--- MySQL dump 10.9 >--- >--- Host: localhost Database: koha30test >--- ------------------------------------------------------ >--- Server version 4.1.22 >- >-/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; >-/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; >-/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; >-/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; >-/*!40101 SET NAMES utf8 */; >-/*!40103 SET TIME_ZONE='+00:00' */; >-/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; >-/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; >-/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; >-/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; >- >--- >--- Table structure for table `accountlines` >--- >- >-DROP TABLE IF EXISTS `accountlines`; >-CREATE TABLE `accountlines` ( >- `borrowernumber` int(11) NOT NULL default 0, >- `accountno` smallint(6) NOT NULL default 0, >- `itemnumber` int(11) default NULL, >- `date` date default NULL, >- `amount` decimal(28,6) default NULL, >- `description` mediumtext, >- `dispute` mediumtext, >- `accounttype` varchar(5) default NULL, >- `amountoutstanding` decimal(28,6) default NULL, >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, >- `notify_id` int(11) NOT NULL default 0, >- `notify_level` int(2) NOT NULL default 0, >- KEY `acctsborridx` (`borrowernumber`), >- KEY `timeidx` (`timestamp`), >- KEY `itemnumber` (`itemnumber`), >- CONSTRAINT `accountlines_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, >- CONSTRAINT `accountlines_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `accountoffsets` >--- >- >-DROP TABLE IF EXISTS `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(28,6) default NULL, >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, >- CONSTRAINT `accountoffsets_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `action_logs` >--- >- >-DROP TABLE IF EXISTS `action_logs`; >-CREATE TABLE `action_logs` ( >- `action_id` int(11) NOT NULL auto_increment, >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, >- `user` int(11) NOT NULL default 0, >- `module` text, >- `action` text, >- `object` int(11) default NULL, >- `info` text, >- PRIMARY KEY (`action_id`), >- KEY (`timestamp`,`user`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `alert` >--- >- >-DROP TABLE IF EXISTS `alert`; >-CREATE TABLE `alert` ( >- `alertid` int(11) NOT NULL auto_increment, >- `borrowernumber` int(11) NOT NULL default 0, >- `type` varchar(10) NOT NULL default '', >- `externalid` varchar(20) NOT NULL default '', >- PRIMARY KEY (`alertid`), >- KEY `borrowernumber` (`borrowernumber`), >- KEY `type` (`type`,`externalid`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `aqbasket` >--- >- >-DROP TABLE IF EXISTS `aqbasket`; >-CREATE TABLE `aqbasket` ( >- `basketno` int(11) NOT NULL auto_increment, >- `creationdate` date default NULL, >- `closedate` date default NULL, >- `booksellerid` int(11) NOT NULL default 1, >- `authorisedby` varchar(10) default NULL, >- `booksellerinvoicenumber` mediumtext, >- PRIMARY KEY (`basketno`), >- KEY `booksellerid` (`booksellerid`), >- CONSTRAINT `aqbasket_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `aqbookfund` >--- >- >-DROP TABLE IF EXISTS `aqbookfund`; >-CREATE TABLE `aqbookfund` ( >- `bookfundid` varchar(10) NOT NULL default '', >- `bookfundname` mediumtext, >- `bookfundgroup` varchar(5) default NULL, >- `branchcode` varchar(10) NOT NULL default '', >- PRIMARY KEY (`bookfundid`,`branchcode`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `aqbooksellers` >--- >- >-DROP TABLE IF EXISTS `aqbooksellers`; >-CREATE TABLE `aqbooksellers` ( >- `id` int(11) NOT NULL auto_increment, >- `name` mediumtext, >- `address1` mediumtext, >- `address2` mediumtext, >- `address3` mediumtext, >- `address4` mediumtext, >- `phone` varchar(30) default NULL, >- `accountnumber` mediumtext, >- `othersupplier` mediumtext, >- `currency` varchar(3) NOT NULL default '', >- `deliverydays` smallint(6) default NULL, >- `followupdays` smallint(6) default NULL, >- `followupscancel` smallint(6) default NULL, >- `specialty` mediumtext, >- `booksellerfax` mediumtext, >- `notes` mediumtext, >- `bookselleremail` mediumtext, >- `booksellerurl` mediumtext, >- `contact` varchar(100) default NULL, >- `postal` mediumtext, >- `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` mediumtext, >- `active` tinyint(4) default NULL, >- `listprice` varchar(10) default NULL, >- `invoiceprice` varchar(10) 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` int(11) default NULL, >- `invoicedisc` float(6,4) default NULL, >- PRIMARY KEY (`id`), >- KEY `listprice` (`listprice`), >- KEY `invoiceprice` (`invoiceprice`), >- CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE, >- CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `aqbudget` >--- >- >-DROP TABLE IF EXISTS `aqbudget`; >-CREATE TABLE `aqbudget` ( >- `bookfundid` varchar(10) NOT NULL default '', >- `startdate` date NOT NULL default 0, >- `enddate` date default NULL, >- `budgetamount` decimal(13,2) default NULL, >- `aqbudgetid` tinyint(4) NOT NULL auto_increment, >- `branchcode` varchar(10) default NULL, >- PRIMARY KEY (`aqbudgetid`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `aqorderbreakdown` >--- >- >-DROP TABLE IF EXISTS `aqorderbreakdown`; >-CREATE TABLE `aqorderbreakdown` ( >- `ordernumber` int(11) default NULL, >- `linenumber` int(11) default NULL, >- `branchcode` varchar(10) default NULL, >- `bookfundid` varchar(10) NOT NULL default '', >- `allocation` smallint(6) default NULL, >- KEY `ordernumber` (`ordernumber`), >- KEY `bookfundid` (`bookfundid`), >- CONSTRAINT `aqorderbreakdown_ibfk_1` FOREIGN KEY (`ordernumber`) REFERENCES `aqorders` (`ordernumber`) ON DELETE CASCADE ON UPDATE CASCADE, >- CONSTRAINT `aqorderbreakdown_ibfk_2` FOREIGN KEY (`bookfundid`) REFERENCES `aqbookfund` (`bookfundid`) ON DELETE CASCADE ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `aqorderdelivery` >--- >- >-DROP TABLE IF EXISTS `aqorderdelivery`; >-CREATE TABLE `aqorderdelivery` ( >- `ordernumber` date default NULL, >- `deliverynumber` smallint(6) NOT NULL default 0, >- `deliverydate` varchar(18) default NULL, >- `qtydelivered` smallint(6) default NULL, >- `deliverycomments` mediumtext >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `aqorders` >--- >- >-DROP TABLE IF EXISTS `aqorders`; >-CREATE TABLE `aqorders` ( >- `ordernumber` int(11) NOT NULL auto_increment, >- `biblionumber` int(11) default NULL, >- `title` mediumtext, >- `entrydate` date default NULL, >- `quantity` smallint(6) default NULL, >- `currency` varchar(3) default NULL, >- `listprice` decimal(28,6) default NULL, >- `totalamount` decimal(28,6) default NULL, >- `datereceived` date default NULL, >- `booksellerinvoicenumber` mediumtext, >- `freight` decimal(28,6) default NULL, >- `unitprice` decimal(28,6) default NULL, >- `quantityreceived` smallint(6) default NULL, >- `cancelledby` varchar(10) default NULL, >- `datecancellationprinted` date default NULL, >- `notes` mediumtext, >- `supplierreference` mediumtext, >- `purchaseordernumber` mediumtext, >- `subscription` tinyint(1) default NULL, >- `serialid` varchar(30) default NULL, >- `basketno` int(11) default NULL, >- `biblioitemnumber` int(11) default NULL, >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, >- `rrp` decimal(13,2) default NULL, >- `ecost` decimal(13,2) default NULL, >- `gst` decimal(13,2) default NULL, >- `budgetdate` date default NULL, >- `sort1` varchar(80) default NULL, >- `sort2` varchar(80) default NULL, >- PRIMARY KEY (`ordernumber`), >- KEY `basketno` (`basketno`), >- KEY `biblionumber` (`biblionumber`), >- CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE, >- CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE SET NULL >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `auth_header` >--- >- >-DROP TABLE IF EXISTS `auth_header`; >-CREATE TABLE `auth_header` ( >- `authid` bigint(20) unsigned NOT NULL auto_increment, >- `authtypecode` varchar(10) NOT NULL default '', >- `datecreated` date default NULL, >- `datemodified` date default NULL, >- `origincode` varchar(20) default NULL, >- `authtrees` mediumtext, >- `marc` blob, >- `linkid` bigint(20) default NULL, >- `marcxml` longtext NOT NULL, >- PRIMARY KEY (`authid`), >- KEY `origincode` (`origincode`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `auth_subfield_structure` >--- >- >-DROP TABLE IF EXISTS `auth_subfield_structure`; >-CREATE TABLE `auth_subfield_structure` ( >- `authtypecode` varchar(10) NOT NULL default '', >- `tagfield` varchar(3) NOT NULL default '', >- `tagsubfield` varchar(1) NOT NULL default '', >- `liblibrarian` varchar(255) NOT NULL default '', >- `libopac` varchar(255) NOT NULL default '', >- `repeatable` tinyint(4) NOT NULL default 0, >- `mandatory` tinyint(4) NOT NULL default 0, >- `tab` tinyint(1) default NULL, >- `authorised_value` varchar(10) default NULL, >- `value_builder` varchar(80) default NULL, >- `seealso` varchar(255) default NULL, >- `isurl` tinyint(1) default NULL, >- `hidden` tinyint(3) NOT NULL default 0, >- `linkid` tinyint(1) NOT NULL default 0, >- `kohafield` varchar(45) NULL default '', >- `frameworkcode` varchar(8) NOT NULL default '', >- PRIMARY KEY (`authtypecode`,`tagfield`,`tagsubfield`), >- KEY `tab` (`authtypecode`,`tab`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `auth_tag_structure` >--- >- >-DROP TABLE IF EXISTS `auth_tag_structure`; >-CREATE TABLE `auth_tag_structure` ( >- `authtypecode` varchar(10) NOT NULL default '', >- `tagfield` varchar(3) NOT NULL default '', >- `liblibrarian` varchar(255) NOT NULL default '', >- `libopac` varchar(255) NOT NULL default '', >- `repeatable` tinyint(4) NOT NULL default 0, >- `mandatory` tinyint(4) NOT NULL default 0, >- `authorised_value` varchar(10) default NULL, >- PRIMARY KEY (`authtypecode`,`tagfield`), >- CONSTRAINT `auth_tag_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `auth_types` >--- >- >-DROP TABLE IF EXISTS `auth_types`; >-CREATE TABLE `auth_types` ( >- `authtypecode` varchar(10) NOT NULL default '', >- `authtypetext` varchar(255) NOT NULL default '', >- `auth_tag_to_report` varchar(3) NOT NULL default '', >- `summary` mediumtext NOT NULL, >- PRIMARY KEY (`authtypecode`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `authorised_values` >--- >- >-DROP TABLE IF EXISTS `authorised_values`; >-CREATE TABLE `authorised_values` ( >- `id` int(11) NOT NULL auto_increment, >- `category` varchar(10) NOT NULL default '', >- `authorised_value` varchar(80) NOT NULL default '', >- `lib` varchar(80) default NULL, >- PRIMARY KEY (`id`), >- KEY `name` (`category`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `biblio` >--- >- >-DROP TABLE IF EXISTS `biblio`; >-CREATE TABLE `biblio` ( >- `biblionumber` int(11) NOT NULL auto_increment, >- `frameworkcode` varchar(4) NOT NULL default '', >- `author` mediumtext, >- `title` mediumtext, >- `unititle` mediumtext, >- `notes` mediumtext, >- `serial` tinyint(1) default NULL, >- `seriestitle` mediumtext, >- `copyrightdate` smallint(6) default NULL, >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, >- `datecreated` DATE NOT NULL, >- `abstract` mediumtext, >- PRIMARY KEY (`biblionumber`), >- KEY `blbnoidx` (`biblionumber`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `biblio_framework` >--- >- >-DROP TABLE IF EXISTS `biblio_framework`; >-CREATE TABLE `biblio_framework` ( >- `frameworkcode` varchar(4) NOT NULL default '', >- `frameworktext` varchar(255) NOT NULL default '', >- PRIMARY KEY (`frameworkcode`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `biblioitems` >--- >- >-DROP TABLE IF EXISTS `biblioitems`; >-CREATE TABLE `biblioitems` ( >- `biblioitemnumber` int(11) NOT NULL auto_increment, >- `biblionumber` int(11) NOT NULL default 0, >- `volume` mediumtext, >- `number` mediumtext, >- `itemtype` varchar(10) default NULL, >- `isbn` varchar(14) default NULL, >- `issn` varchar(9) default NULL, >- `publicationyear` text, >- `publishercode` varchar(255) default NULL, >- `volumedate` date default NULL, >- `volumedesc` text, >- `collectiontitle` mediumtext default NULL, >- `collectionissn` text default NULL, >- `collectionvolume` mediumtext default NULL, >- `editionstatement` text default NULL, >- `editionresponsibility` text default NULL, >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, >- `illus` varchar(255) default NULL, >- `pages` varchar(255) default NULL, >- `notes` mediumtext, >- `size` varchar(255) default NULL, >- `place` varchar(255) default NULL, >- `lccn` varchar(25) default NULL, >- `marc` longblob, >- `url` varchar(255) default NULL, >- `cn_source` varchar(10) default NULL, >- `cn_class` varchar(30) default NULL, >- `cn_item` varchar(10) default NULL, >- `cn_suffix` varchar(10) default NULL, >- `cn_sort` varchar(30) default NULL, >- `totalissues` int(10), >- `marcxml` longtext NOT NULL, >- PRIMARY KEY (`biblioitemnumber`), >- KEY `bibinoidx` (`biblioitemnumber`), >- KEY `bibnoidx` (`biblionumber`), >- KEY `isbn` (`isbn`), >- KEY `publishercode` (`publishercode`), >- CONSTRAINT `biblioitems_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `borrowers` >--- >- >-DROP TABLE IF EXISTS `borrowers`; >-CREATE TABLE `borrowers` ( >- `borrowernumber` int(11) NOT NULL auto_increment, >- `cardnumber` varchar(16) default NULL, >- `surname` mediumtext NOT NULL, >- `firstname` text, >- `title` mediumtext, >- `othernames` mediumtext, >- `initials` text, >- `streetnumber` varchar(10) default NULL, >- `streettype` varchar(50) default NULL, >- `address` mediumtext NOT NULL, >- `address2` text, >- `city` mediumtext NOT NULL, >- `zipcode` varchar(25) default NULL, >- `email` mediumtext, >- `phone` text, >- `mobile` varchar(50) default NULL, >- `fax` mediumtext, >- `emailpro` text, >- `phonepro` text, >- `B_streetnumber` varchar(10) default NULL, >- `B_streettype` varchar(50) default NULL, >- `B_address` varchar(100) default NULL, >- `B_city` mediumtext, >- `B_zipcode` varchar(25) default NULL, >- `B_email` text, >- `B_phone` mediumtext, >- `dateofbirth` date default NULL, >- `branchcode` varchar(10) NOT NULL default '', >- `categorycode` varchar(10) NOT NULL default '', >- `dateenrolled` date default NULL, >- `dateexpiry` date default NULL, >- `gonenoaddress` tinyint(1) default NULL, >- `lost` tinyint(1) default NULL, >- `debarred` tinyint(1) default NULL, >- `contactname` mediumtext, >- `contactfirstname` text, >- `contacttitle` text, >- `guarantorid` int(11) default NULL, >- `borrowernotes` mediumtext, >- `relationship` varchar(100) default NULL, >- `ethnicity` varchar(50) default NULL, >- `ethnotes` varchar(255) default NULL, >- `sex` varchar(1) default NULL, >- `password` varchar(30) default NULL, >- `flags` int(11) default NULL, >- `userid` varchar(30) default NULL, >- `opacnote` mediumtext, >- `contactnote` varchar(255) default NULL, >- `sort1` varchar(80) default NULL, >- `sort2` varchar(80) default NULL, >- `altcontactfirstname` varchar(255) default NULL, >- `altcontactsurname` varchar(255) default NULL, >- `altcontactaddress1` varchar(255) default NULL, >- `altcontactaddress2` varchar(255) default NULL, >- `altcontactaddress3` varchar(255) default NULL, >- `altcontactzipcode` varchar(50) default NULL, >- `altcontactphone` varchar(50) default NULL, >- UNIQUE KEY `cardnumber` (`cardnumber`), >- PRIMARY KEY `borrowernumber` (`borrowernumber`), >- KEY `categorycode` (`categorycode`), >- KEY `branchcode` (`branchcode`), >- KEY `userid` (`userid`), >- CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`), >- CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `branchcategories` >--- >- >-DROP TABLE IF EXISTS `branchcategories`; >-CREATE TABLE `branchcategories` ( >- `categorycode` varchar(10) NOT NULL default '', >- `categoryname` varchar(32), >- `codedescription` mediumtext, >- `categorytype` varchar(16), >- PRIMARY KEY (`categorycode`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `branches` >--- >- >-DROP TABLE IF EXISTS `branches`; >-CREATE TABLE `branches` ( >- `branchcode` varchar(10) NOT NULL default '', >- `branchname` mediumtext NOT NULL, >- `branchaddress1` mediumtext, >- `branchaddress2` mediumtext, >- `branchaddress3` mediumtext, >- `branchphone` mediumtext, >- `branchfax` mediumtext, >- `branchemail` mediumtext, >- `issuing` tinyint(4) default NULL, >- `branchip` varchar(15) default NULL, >- `branchprinter` varchar(100) default NULL, >- UNIQUE KEY `branchcode` (`branchcode`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `branchrelations` >--- >- >-DROP TABLE IF EXISTS `branchrelations`; >-CREATE TABLE `branchrelations` ( >- `branchcode` varchar(10) NOT NULL default '', >- `categorycode` varchar(10) NOT NULL default '', >- PRIMARY KEY (`branchcode`,`categorycode`), >- KEY `branchcode` (`branchcode`), >- KEY `categorycode` (`categorycode`), >- CONSTRAINT `branchrelations_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, >- CONSTRAINT `branchrelations_ibfk_2` FOREIGN KEY (`categorycode`) REFERENCES `branchcategories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `branchtransfers` >--- >- >-DROP TABLE IF EXISTS `branchtransfers`; >-CREATE TABLE `branchtransfers` ( >- `itemnumber` int(11) NOT NULL default 0, >- `datesent` datetime default NULL, >- `frombranch` varchar(10) NOT NULL default '', >- `datearrived` datetime default NULL, >- `tobranch` varchar(10) NOT NULL default '', >- `comments` mediumtext, >- KEY `frombranch` (`frombranch`), >- KEY `tobranch` (`tobranch`), >- KEY `itemnumber` (`itemnumber`), >- CONSTRAINT `branchtransfers_ibfk_1` FOREIGN KEY (`frombranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, >- CONSTRAINT `branchtransfers_ibfk_2` FOREIGN KEY (`tobranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, >- CONSTRAINT `branchtransfers_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >- >--- >--- Table structure for table `browser` >--- >-DROP TABLE IF EXISTS `browser`; >-CREATE TABLE `browser` ( >- `level` int(11) NOT NULL, >- `classification` varchar(20) NOT NULL, >- `description` varchar(255) NOT NULL, >- `number` bigint(20) NOT NULL, >- `endnode` tinyint(4) NOT NULL >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `categories` >--- >- >-DROP TABLE IF EXISTS `categories`; >-CREATE TABLE `categories` ( >- `categorycode` varchar(10) NOT NULL default '', >- `description` mediumtext, >- `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(28,6) default NULL, >- `overduenoticerequired` tinyint(1) default NULL, >- `issuelimit` smallint(6) default NULL, >- `reservefee` decimal(28,6) default NULL, >- `category_type` varchar(1) NOT NULL default 'A', >- PRIMARY KEY (`categorycode`), >- UNIQUE KEY `categorycode` (`categorycode`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `categorytable` >--- >- >-DROP TABLE IF EXISTS `categorytable`; >-CREATE TABLE `categorytable` ( >- `categorycode` varchar(5) NOT NULL default '', >- `description` text, >- `itemtypecodes` text, >- PRIMARY KEY (`categorycode`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `cities` >--- >- >-DROP TABLE IF EXISTS `cities`; >-CREATE TABLE `cities` ( >- `cityid` int(11) NOT NULL auto_increment, >- `city_name` varchar(100) NOT NULL default '', >- `city_zipcode` varchar(20) default NULL, >- PRIMARY KEY (`cityid`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `class_sort_rules` >--- >- >-DROP TABLE IF EXISTS `class_sort_rules`; >-CREATE TABLE `class_sort_rules` ( >- `class_sort_rule` varchar(10) NOT NULL default '', >- `description` mediumtext, >- `sort_routine` varchar(30) NOT NULL default '', >- PRIMARY KEY (`class_sort_rule`), >- UNIQUE KEY `class_sort_rule_idx` (`class_sort_rule`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `class_sources` >--- >- >-DROP TABLE IF EXISTS `class_sources`; >-CREATE TABLE `class_sources` ( >- `cn_source` varchar(10) NOT NULL default '', >- `description` mediumtext, >- `used` tinyint(4) NOT NULL default 0, >- `class_sort_rule` varchar(10) NOT NULL default '', >- PRIMARY KEY (`cn_source`), >- UNIQUE KEY `cn_source_idx` (`cn_source`), >- KEY `used_idx` (`used`), >- CONSTRAINT `class_source_ibfk_1` FOREIGN KEY (`class_sort_rule`) REFERENCES `class_sort_rules` (`class_sort_rule`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `currency` >--- >- >-DROP TABLE IF EXISTS `currency`; >-CREATE TABLE `currency` ( >- `currency` varchar(10) NOT NULL default '', >- `symbol` varchar(5) default NULL, >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, >- `rate` float(7,5) default NULL, >- PRIMARY KEY (`currency`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `deletedbiblio` >--- >- >-DROP TABLE IF EXISTS `deletedbiblio`; >-CREATE TABLE `deletedbiblio` ( >- `biblionumber` int(11) NOT NULL default 0, >- `frameworkcode` varchar(4) NOT NULL default '', >- `author` mediumtext, >- `title` mediumtext, >- `unititle` mediumtext, >- `notes` mediumtext, >- `serial` tinyint(1) default NULL, >- `seriestitle` mediumtext, >- `copyrightdate` smallint(6) default NULL, >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, >- `datecreated` DATE NOT NULL, >- `abstract` mediumtext, >- PRIMARY KEY (`biblionumber`), >- KEY `blbnoidx` (`biblionumber`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `deletedbiblioitems` >--- >- >-DROP TABLE IF EXISTS `deletedbiblioitems`; >-CREATE TABLE `deletedbiblioitems` ( >- `biblioitemnumber` int(11) NOT NULL default 0, >- `biblionumber` int(11) NOT NULL default 0, >- `volume` mediumtext, >- `number` mediumtext, >- `itemtype` varchar(10) default NULL, >- `isbn` varchar(14) default NULL, >- `issn` varchar(9) default NULL, >- `publicationyear` text, >- `publishercode` varchar(255) default NULL, >- `volumedate` date default NULL, >- `volumedesc` text, >- `collectiontitle` mediumtext default NULL, >- `collectionissn` text default NULL, >- `collectionvolume` mediumtext default NULL, >- `editionstatement` text default NULL, >- `editionresponsibility` text default NULL, >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, >- `illus` varchar(255) default NULL, >- `pages` varchar(255) default NULL, >- `notes` mediumtext, >- `size` varchar(255) default NULL, >- `place` varchar(255) default NULL, >- `lccn` varchar(25) default NULL, >- `marc` longblob, >- `url` varchar(255) default NULL, >- `cn_source` varchar(10) default NULL, >- `cn_class` varchar(30) default NULL, >- `cn_item` varchar(10) default NULL, >- `cn_suffix` varchar(10) default NULL, >- `cn_sort` varchar(30) default NULL, >- `totalissues` int(10), >- `marcxml` longtext NOT NULL, >- PRIMARY KEY (`biblioitemnumber`), >- KEY `bibinoidx` (`biblioitemnumber`), >- KEY `bibnoidx` (`biblionumber`), >- KEY `isbn` (`isbn`), >- KEY `publishercode` (`publishercode`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `deletedborrowers` >--- >- >-DROP TABLE IF EXISTS `deletedborrowers`; >-CREATE TABLE `deletedborrowers` ( >- `borrowernumber` int(11) NOT NULL default 0, >- `cardnumber` varchar(9) NOT NULL default '', >- `surname` mediumtext NOT NULL, >- `firstname` text, >- `title` mediumtext, >- `othernames` mediumtext, >- `initials` text, >- `streetnumber` varchar(10) default NULL, >- `streettype` varchar(50) default NULL, >- `address` mediumtext NOT NULL, >- `address2` text, >- `city` mediumtext NOT NULL, >- `zipcode` varchar(25) default NULL, >- `email` mediumtext, >- `phone` text, >- `mobile` varchar(50) default NULL, >- `fax` mediumtext, >- `emailpro` text, >- `phonepro` text, >- `B_streetnumber` varchar(10) default NULL, >- `B_streettype` varchar(50) default NULL, >- `B_address` varchar(100) default NULL, >- `B_city` mediumtext, >- `B_zipcode` varchar(25) default NULL, >- `B_email` text, >- `B_phone` mediumtext, >- `dateofbirth` date default NULL, >- `branchcode` varchar(10) NOT NULL default '', >- `categorycode` varchar(2) default NULL, >- `dateenrolled` date default NULL, >- `dateexpiry` date default NULL, >- `gonenoaddress` tinyint(1) default NULL, >- `lost` tinyint(1) default NULL, >- `debarred` tinyint(1) default NULL, >- `contactname` mediumtext, >- `contactfirstname` text, >- `contacttitle` text, >- `guarantorid` int(11) default NULL, >- `borrowernotes` mediumtext, >- `relationship` varchar(100) default NULL, >- `ethnicity` varchar(50) default NULL, >- `ethnotes` varchar(255) default NULL, >- `sex` varchar(1) default NULL, >- `password` varchar(30) default NULL, >- `flags` int(11) default NULL, >- `userid` varchar(30) default NULL, >- `opacnote` mediumtext, >- `contactnote` varchar(255) default NULL, >- `sort1` varchar(80) default NULL, >- `sort2` varchar(80) default NULL, >- `altcontactfirstname` varchar(255) default NULL, >- `altcontactsurname` varchar(255) default NULL, >- `altcontactaddress1` varchar(255) default NULL, >- `altcontactaddress2` varchar(255) default NULL, >- `altcontactaddress3` varchar(255) default NULL, >- `altcontactzipcode` varchar(50) default NULL, >- `altcontactphone` varchar(50) default NULL, >- KEY `borrowernumber` (`borrowernumber`), >- KEY `cardnumber` (`cardnumber`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `deleteditems` >--- >- >-DROP TABLE IF EXISTS `deleteditems`; >-CREATE TABLE `deleteditems` ( >- `itemnumber` int(11) NOT NULL default 0, >- `biblionumber` int(11) NOT NULL default 0, >- `biblioitemnumber` int(11) NOT NULL default 0, >- `barcode` varchar(20) default NULL, >- `dateaccessioned` date default NULL, >- `booksellerid` mediumtext default NULL, >- `homebranch` varchar(10) default NULL, >- `price` decimal(8,2) default NULL, >- `replacementprice` decimal(8,2) default NULL, >- `replacementpricedate` date default NULL, >- `datelastborrowed` date default NULL, >- `datelastseen` date default NULL, >- `stack` tinyint(1) default NULL, >- `notforloan` tinyint(1) NOT NULL default 0, >- `damaged` tinyint(1) NOT NULL default 0, >- `itemlost` tinyint(1) NOT NULL default 0, >- `wthdrawn` tinyint(1) NOT NULL default 0, >- `itemcallnumber` varchar(30) default NULL, >- `issues` smallint(6) default NULL, >- `renewals` smallint(6) default NULL, >- `reserves` smallint(6) default NULL, >- `restricted` tinyint(1) default NULL, >- `itemnotes` mediumtext, >- `holdingbranch` varchar(10) default NULL, >- `paidfor` mediumtext, >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, >- `location` varchar(80) default NULL, >- `onloan` date default NULL, >- `cn_source` varchar(10) default NULL, >- `cn_sort` varchar(30) default NULL, >- `ccode` varchar(10) default NULL, >- `materials` varchar(10) default NULL, >- `uri` varchar(255) default NULL, >- `itype` varchar(10) default NULL, >- `more_subfields_xml` longtext default NULL, >- `enumchron` varchar(80) default NULL, >- `copynumber` smallint(6) default NULL, >- `marc` longblob, >- PRIMARY KEY (`itemnumber`), >- KEY `delitembarcodeidx` (`barcode`), >- KEY `delitembinoidx` (`biblioitemnumber`), >- KEY `delitembibnoidx` (`biblionumber`), >- KEY `delhomebranch` (`homebranch`), >- KEY `delholdingbranch` (`holdingbranch`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `ethnicity` >--- >- >-DROP TABLE IF EXISTS `ethnicity`; >-CREATE TABLE `ethnicity` ( >- `code` varchar(10) NOT NULL default '', >- `name` varchar(255) default NULL, >- PRIMARY KEY (`code`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `import_batches` >--- >- >-DROP TABLE IF EXISTS `import_batches`; >-CREATE TABLE `import_batches` ( >- `import_batch_id` int(11) NOT NULL auto_increment, >- `matcher_id` int(11) default NULL, >- `template_id` int(11) default NULL, >- `branchcode` varchar(10) default NULL, >- `num_biblios` int(11) NOT NULL default 0, >- `num_items` int(11) NOT NULL default 0, >- `upload_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, >- `overlay_action` enum('replace', 'create_new', 'use_template') NOT NULL default 'create_new', >- `import_status` enum('staging', 'staged', 'importing', 'imported', 'reverting', 'reverted', 'cleaned') NOT NULL default 'staging', >- `batch_type` enum('batch', 'z3950') NOT NULL default 'batch', >- `file_name` varchar(100), >- `comments` mediumtext, >- PRIMARY KEY (`import_batch_id`), >- KEY `branchcode` (`branchcode`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `import_records` >--- >- >-DROP TABLE IF EXISTS `import_records`; >-CREATE TABLE `import_records` ( >- `import_record_id` int(11) NOT NULL auto_increment, >- `import_batch_id` int(11) NOT NULL, >- `branchcode` varchar(10) default NULL, >- `record_sequence` int(11) NOT NULL default 0, >- `upload_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, >- `import_date` DATE default NULL, >- `marc` longblob NOT NULL, >- `marcxml` longtext NOT NULL, >- `marcxml_old` longtext NOT NULL, >- `record_type` enum('biblio', 'auth', 'holdings') NOT NULL default 'biblio', >- `overlay_status` enum('no_match', 'auto_match', 'manual_match', 'match_applied') NOT NULL default 'no_match', >- `status` enum('error', 'staged', 'imported', 'reverted', 'items_reverted') NOT NULL default 'staged', >- `import_error` mediumtext, >- `encoding` varchar(40) NOT NULL default '', >- `z3950random` varchar(40) default NULL, >- PRIMARY KEY (`import_record_id`), >- CONSTRAINT `import_records_ifbk_1` FOREIGN KEY (`import_batch_id`) >- REFERENCES `import_batches` (`import_batch_id`) ON DELETE CASCADE ON UPDATE CASCADE, >- KEY `branchcode` (`branchcode`), >- KEY `batch_sequence` (`import_batch_id`, `record_sequence`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for `import_record_matches` >--- >-DROP TABLE IF EXISTS `import_record_matches`; >-CREATE TABLE `import_record_matches` ( >- `import_record_id` int(11) NOT NULL, >- `candidate_match_id` int(11) NOT NULL, >- `score` int(11) NOT NULL default 0, >- CONSTRAINT `import_record_matches_ibfk_1` FOREIGN KEY (`import_record_id`) >- REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE, >- KEY `record_score` (`import_record_id`, `score`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `import_biblios` >--- >- >-DROP TABLE IF EXISTS `import_biblios`; >-CREATE TABLE `import_biblios` ( >- `import_record_id` int(11) NOT NULL, >- `matched_biblionumber` int(11) default NULL, >- `control_number` varchar(25) default NULL, >- `original_source` varchar(25) default NULL, >- `title` varchar(128) default NULL, >- `author` varchar(80) default NULL, >- `isbn` varchar(14) default NULL, >- `issn` varchar(9) default NULL, >- `has_items` tinyint(1) NOT NULL default 0, >- CONSTRAINT `import_biblios_ibfk_1` FOREIGN KEY (`import_record_id`) >- REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE, >- KEY `matched_biblionumber` (`matched_biblionumber`), >- KEY `title` (`title`), >- KEY `isbn` (`isbn`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `import_items` >--- >- >-DROP TABLE IF EXISTS `import_items`; >-CREATE TABLE `import_items` ( >- `import_items_id` int(11) NOT NULL auto_increment, >- `import_record_id` int(11) NOT NULL, >- `itemnumber` int(11) default NULL, >- `branchcode` varchar(10) default NULL, >- `status` enum('error', 'staged', 'imported', 'reverted') NOT NULL default 'staged', >- `marcxml` longtext NOT NULL, >- `import_error` mediumtext, >- PRIMARY KEY (`import_items_id`), >- CONSTRAINT `import_items_ibfk_1` FOREIGN KEY (`import_record_id`) >- REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE, >- KEY `itemnumber` (`itemnumber`), >- KEY `branchcode` (`branchcode`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `issues` >--- >- >-DROP TABLE IF EXISTS `issues`; >-CREATE TABLE `issues` ( >- `borrowernumber` int(11) default NULL, >- `itemnumber` int(11) default NULL, >- `date_due` date default NULL, >- `branchcode` varchar(10) default NULL, >- `issuingbranch` varchar(18) default NULL, >- `returndate` date default NULL, >- `lastreneweddate` date default NULL, >- `return` varchar(4) default NULL, >- `renewals` tinyint(4) default NULL, >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, >- `issuedate` date default NULL, >- KEY `issuesborridx` (`borrowernumber`), >- KEY `issuesitemidx` (`itemnumber`), >- KEY `bordate` (`borrowernumber`,`timestamp`), >- CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL, >- CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `issuingrules` >--- >- >-DROP TABLE IF EXISTS `issuingrules`; >-CREATE TABLE `issuingrules` ( >- `categorycode` varchar(10) NOT NULL default '', >- `itemtype` varchar(10) NOT NULL default '', >- `restrictedtype` tinyint(1) default NULL, >- `rentaldiscount` decimal(28,6) default NULL, >- `reservecharge` decimal(28,6) default NULL, >- `fine` decimal(28,6) default NULL, >- `firstremind` int(11) default NULL, >- `chargeperiod` int(11) default NULL, >- `accountsent` int(11) default NULL, >- `chargename` varchar(100) default NULL, >- `maxissueqty` int(4) default NULL, >- `issuelength` int(4) default NULL, >- `branchcode` varchar(10) NOT NULL default '', >- PRIMARY KEY (`branchcode`,`categorycode`,`itemtype`), >- KEY `categorycode` (`categorycode`), >- KEY `itemtype` (`itemtype`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `items` >--- >- >-DROP TABLE IF EXISTS `items`; >-CREATE TABLE `items` ( >- `itemnumber` int(11) NOT NULL auto_increment, >- `biblionumber` int(11) NOT NULL default 0, >- `biblioitemnumber` int(11) NOT NULL default 0, >- `barcode` varchar(20) default NULL, >- `dateaccessioned` date default NULL, >- `booksellerid` mediumtext default NULL, >- `homebranch` varchar(10) default NULL, >- `price` decimal(8,2) default NULL, >- `replacementprice` decimal(8,2) default NULL, >- `replacementpricedate` date default NULL, >- `datelastborrowed` date default NULL, >- `datelastseen` date default NULL, >- `stack` tinyint(1) default NULL, >- `notforloan` tinyint(1) NOT NULL default 0, >- `damaged` tinyint(1) NOT NULL default 0, >- `itemlost` tinyint(1) NOT NULL default 0, >- `wthdrawn` tinyint(1) NOT NULL default 0, >- `itemcallnumber` varchar(30) default NULL, >- `issues` smallint(6) default NULL, >- `renewals` smallint(6) default NULL, >- `reserves` smallint(6) default NULL, >- `restricted` tinyint(1) default NULL, >- `itemnotes` mediumtext, >- `holdingbranch` varchar(10) default NULL, >- `paidfor` mediumtext, >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, >- `location` varchar(80) default NULL, >- `onloan` date default NULL, >- `cn_source` varchar(10) default NULL, >- `cn_sort` varchar(30) default NULL, >- `ccode` varchar(10) default NULL, >- `materials` varchar(10) default NULL, >- `uri` varchar(255) default NULL, >- `itype` varchar(10) default NULL, >- `more_subfields_xml` longtext default NULL, >- `enumchron` varchar(80) default NULL, >- `copynumber` smallint(6) default NULL, >- PRIMARY KEY (`itemnumber`), >- UNIQUE KEY `itembarcodeidx` (`barcode`), >- KEY `itembinoidx` (`biblioitemnumber`), >- KEY `itembibnoidx` (`biblionumber`), >- KEY `homebranch` (`homebranch`), >- KEY `holdingbranch` (`holdingbranch`), >- CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `biblioitems` (`biblioitemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, >- CONSTRAINT `items_ibfk_2` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE, >- CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `itemtypes` >--- >- >-DROP TABLE IF EXISTS `itemtypes`; >-CREATE TABLE `itemtypes` ( >- `itemtype` varchar(10) NOT NULL default '', >- `description` mediumtext, >- `renewalsallowed` smallint(6) default NULL, >- `rentalcharge` double(16,4) default NULL, >- `notforloan` smallint(6) default NULL, >- `imageurl` varchar(200) default NULL, >- `summary` text, >- PRIMARY KEY (`itemtype`), >- UNIQUE KEY `itemtype` (`itemtype`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `labels` >--- >- >-DROP TABLE IF EXISTS `labels`; >-CREATE TABLE `labels` ( >- `labelid` int(11) NOT NULL auto_increment, >- `batch_id` varchar(10) NOT NULL default 1, >- `itemnumber` varchar(100) NOT NULL default '', >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, >- PRIMARY KEY (`labelid`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `labels_conf` >--- >- >-DROP TABLE IF EXISTS `labels_conf`; >-CREATE TABLE `labels_conf` ( >- `id` int(4) NOT NULL auto_increment, >- `barcodetype` char(100) default '', >- `title` int(1) default '0', >- `subtitle` int(1) default '0', >- `itemtype` int(1) default '0', >- `barcode` int(1) default '0', >- `dewey` int(1) default '0', >- `class` int(1) default NULL, >- `subclass` int(1) default '0', >- `itemcallnumber` int(1) default '0', >- `author` int(1) default '0', >- `issn` int(1) default '0', >- `isbn` int(1) default '0', >- `startlabel` int(2) NOT NULL default '1', >- `printingtype` char(32) default 'BAR', >- `layoutname` char(20) NOT NULL default 'TEST', >- `guidebox` int(1) default '0', >- `active` tinyint(1) default '1', >- `fonttype` char(10) collate utf8_unicode_ci default NULL, >- `ccode` char(4) collate utf8_unicode_ci default NULL, >- `callnum_split` int(1) default NULL, >- `text_justify` char(1) collate utf8_unicode_ci default NULL, >- PRIMARY KEY (`id`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `labels_profile` >--- >- >-DROP TABLE IF EXISTS `labels_profile`; >-CREATE TABLE `labels_profile` ( >- `tmpl_id` int(4) NOT NULL, >- `prof_id` int(4) NOT NULL, >- UNIQUE KEY `tmpl_id` (`tmpl_id`), >- UNIQUE KEY `prof_id` (`prof_id`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `labels_templates` >--- >- >-DROP TABLE IF EXISTS `labels_templates`; >-CREATE TABLE `labels_templates` ( >-`tmpl_id` int(4) NOT NULL auto_increment, >- `tmpl_code` char(100) default '', >- `tmpl_desc` char(100) default '', >- `page_width` float default '0', >- `page_height` float default '0', >- `label_width` float default '0', >- `label_height` float default '0', >- `topmargin` float default '0', >- `leftmargin` float default '0', >- `cols` int(2) default '0', >- `rows` int(2) default '0', >- `colgap` float default '0', >- `rowgap` float default '0', >- `active` int(1) default NULL, >- `units` char(20) default 'PX', >- `fontsize` int(4) NOT NULL default '3', >- `font` char(10) NOT NULL default 'TR', >- PRIMARY KEY (`tmpl_id`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `letter` >--- >- >-DROP TABLE IF EXISTS `letter`; >-CREATE TABLE `letter` ( >- `module` varchar(20) NOT NULL default '', >- `code` varchar(20) NOT NULL default '', >- `name` varchar(100) NOT NULL default '', >- `title` varchar(200) NOT NULL default '', >- `content` text, >- PRIMARY KEY (`module`,`code`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `marc_subfield_structure` >--- >- >-DROP TABLE IF EXISTS `marc_subfield_structure`; >-CREATE TABLE `marc_subfield_structure` ( >- `tagfield` varchar(3) NOT NULL default '', >- `tagsubfield` varchar(1) NOT NULL default '', >- `liblibrarian` varchar(255) NOT NULL default '', >- `libopac` varchar(255) NOT NULL default '', >- `repeatable` tinyint(4) NOT NULL default 0, >- `mandatory` tinyint(4) NOT NULL default 0, >- `kohafield` varchar(40) default NULL, >- `tab` tinyint(1) default NULL, >- `authorised_value` varchar(20) default NULL, >- `authtypecode` varchar(20) default NULL, >- `value_builder` varchar(80) default NULL, >- `isurl` tinyint(1) default NULL, >- `hidden` tinyint(1) default NULL, >- `frameworkcode` varchar(4) NOT NULL default '', >- `seealso` varchar(1100) default NULL, >- `link` varchar(80) default NULL, >- `defaultvalue` text default NULL, >- PRIMARY KEY (`frameworkcode`,`tagfield`,`tagsubfield`), >- KEY `kohafield_2` (`kohafield`), >- KEY `tab` (`frameworkcode`,`tab`), >- KEY `kohafield` (`frameworkcode`,`kohafield`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `marc_tag_structure` >--- >- >-DROP TABLE IF EXISTS `marc_tag_structure`; >-CREATE TABLE `marc_tag_structure` ( >- `tagfield` varchar(3) NOT NULL default '', >- `liblibrarian` varchar(255) NOT NULL default '', >- `libopac` varchar(255) NOT NULL default '', >- `repeatable` tinyint(4) NOT NULL default 0, >- `mandatory` tinyint(4) NOT NULL default 0, >- `authorised_value` varchar(10) default NULL, >- `frameworkcode` varchar(4) NOT NULL default '', >- PRIMARY KEY (`frameworkcode`,`tagfield`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `marc_matchers` >--- >- >-DROP TABLE IF EXISTS `marc_matchers`; >-CREATE TABLE `marc_matchers` ( >- `matcher_id` int(11) NOT NULL auto_increment, >- `code` varchar(10) NOT NULL default '', >- `description` varchar(255) NOT NULL default '', >- `record_type` varchar(10) NOT NULL default 'biblio', >- `threshold` int(11) NOT NULL default 0, >- PRIMARY KEY (`matcher_id`), >- KEY `code` (`code`), >- KEY `record_type` (`record_type`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `matchpoints` >--- >-DROP TABLE IF EXISTS `matchpoints`; >-CREATE TABLE `matchpoints` ( >- `matcher_id` int(11) NOT NULL, >- `matchpoint_id` int(11) NOT NULL auto_increment, >- `search_index` varchar(30) NOT NULL default '', >- `score` int(11) NOT NULL default 0, >- PRIMARY KEY (`matchpoint_id`), >- CONSTRAINT `matchpoints_ifbk_1` FOREIGN KEY (`matcher_id`) >- REFERENCES `marc_matchers` (`matcher_id`) ON DELETE CASCADE ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >- >--- >--- Table structure for table `matchpoint_components` >--- >-DROP TABLE IF EXISTS `matchpoint_components`; >-CREATE TABLE `matchpoint_components` ( >- `matchpoint_id` int(11) NOT NULL, >- `matchpoint_component_id` int(11) NOT NULL auto_increment, >- sequence int(11) NOT NULL default 0, >- tag varchar(3) NOT NULL default '', >- subfields varchar(40) NOT NULL default '', >- offset int(4) NOT NULL default 0, >- length int(4) NOT NULL default 0, >- PRIMARY KEY (`matchpoint_component_id`), >- KEY `by_sequence` (`matchpoint_id`, `sequence`), >- CONSTRAINT `matchpoint_components_ifbk_1` FOREIGN KEY (`matchpoint_id`) >- REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `matcher_component_norms` >--- >-DROP TABLE IF EXISTS `matchpoint_component_norms`; >-CREATE TABLE `matchpoint_component_norms` ( >- `matchpoint_component_id` int(11) NOT NULL, >- `sequence` int(11) NOT NULL default 0, >- `norm_routine` varchar(50) NOT NULL default '', >- KEY `matchpoint_component_norms` (`matchpoint_component_id`, `sequence`), >- CONSTRAINT `matchpoint_component_norms_ifbk_1` FOREIGN KEY (`matchpoint_component_id`) >- REFERENCES `matchpoint_components` (`matchpoint_component_id`) ON DELETE CASCADE ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `matcher_matchpoints` >--- >-DROP TABLE IF EXISTS `matcher_matchpoints`; >-CREATE TABLE `matcher_matchpoints` ( >- `matcher_id` int(11) NOT NULL, >- `matchpoint_id` int(11) NOT NULL, >- CONSTRAINT `matcher_matchpoints_ifbk_1` FOREIGN KEY (`matcher_id`) >- REFERENCES `marc_matchers` (`matcher_id`) ON DELETE CASCADE ON UPDATE CASCADE, >- CONSTRAINT `matcher_matchpoints_ifbk_2` FOREIGN KEY (`matchpoint_id`) >- REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `matchchecks` >--- >-DROP TABLE IF EXISTS `matchchecks`; >-CREATE TABLE `matchchecks` ( >- `matcher_id` int(11) NOT NULL, >- `matchcheck_id` int(11) NOT NULL auto_increment, >- `source_matchpoint_id` int(11) NOT NULL, >- `target_matchpoint_id` int(11) NOT NULL, >- PRIMARY KEY (`matchcheck_id`), >- CONSTRAINT `matcher_matchchecks_ifbk_1` FOREIGN KEY (`matcher_id`) >- REFERENCES `marc_matchers` (`matcher_id`) ON DELETE CASCADE ON UPDATE CASCADE, >- CONSTRAINT `matcher_matchchecks_ifbk_2` FOREIGN KEY (`source_matchpoint_id`) >- REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE, >- CONSTRAINT `matcher_matchchecks_ifbk_3` FOREIGN KEY (`target_matchpoint_id`) >- REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `mediatypetable` >--- >- >-DROP TABLE IF EXISTS `mediatypetable`; >-CREATE TABLE `mediatypetable` ( >- `mediatypecode` varchar(5) NOT NULL default '', >- `description` text, >- `itemtypecodes` text, >- PRIMARY KEY (`mediatypecode`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `notifys` >--- >- >-DROP TABLE IF EXISTS `notifys`; >-CREATE TABLE `notifys` ( >- `notify_id` int(11) NOT NULL default 0, >- `borrowernumber` int(11) NOT NULL default 0, >- `itemnumber` int(11) NOT NULL default 0, >- `notify_date` date default NULL, >- `notify_send_date` date default NULL, >- `notify_level` int(1) NOT NULL default 0, >- `method` varchar(20) NOT NULL default '' >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `nozebra` >--- >- >-DROP TABLE IF EXISTS `nozebra`; >-CREATE TABLE `nozebra` ( >- `server` varchar(20) NOT NULL, >- `indexname` varchar(40) NOT NULL, >- `value` varchar(250) NOT NULL, >- `biblionumbers` longtext NOT NULL, >- KEY `indexname` (`server`,`indexname`), >- KEY `value` (`server`,`value`)) >- ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `old_issues` >--- >- >-DROP TABLE IF EXISTS `old_issues`; >-CREATE TABLE `old_issues` ( >- `borrowernumber` int(11) default NULL, >- `itemnumber` int(11) default NULL, >- `date_due` date default NULL, >- `branchcode` varchar(10) default NULL, >- `issuingbranch` varchar(18) default NULL, >- `returndate` date default NULL, >- `lastreneweddate` date default NULL, >- `return` varchar(4) default NULL, >- `renewals` tinyint(4) default NULL, >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, >- `issuedate` date default NULL, >- KEY `old_issuesborridx` (`borrowernumber`), >- KEY `old_issuesitemidx` (`itemnumber`), >- KEY `old_bordate` (`borrowernumber`,`timestamp`), >- CONSTRAINT `old_issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) >- ON DELETE SET NULL ON UPDATE SET NULL, >- CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) >- ON DELETE SET NULL ON UPDATE SET NULL >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `old_reserves` >--- >-DROP TABLE IF EXISTS `old_reserves`; >-CREATE TABLE `old_reserves` ( >- `borrowernumber` int(11) default NULL, >- `reservedate` date default NULL, >- `biblionumber` int(11) default NULL, >- `constrainttype` varchar(1) default NULL, >- `branchcode` varchar(10) default NULL, >- `notificationdate` date default NULL, >- `reminderdate` date default NULL, >- `cancellationdate` date default NULL, >- `reservenotes` mediumtext, >- `priority` smallint(6) default NULL, >- `found` varchar(1) default NULL, >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, >- `itemnumber` int(11) default NULL, >- `waitingdate` date default NULL, >- KEY `old_reserves_borrowernumber` (`borrowernumber`), >- KEY `old_reserves_biblionumber` (`biblionumber`), >- KEY `old_reserves_itemnumber` (`itemnumber`), >- KEY `old_reserves_branchcode` (`branchcode`), >- CONSTRAINT `old_reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) >- ON DELETE SET NULL ON UPDATE SET NULL, >- CONSTRAINT `old_reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) >- ON DELETE SET NULL ON UPDATE SET NULL, >- CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) >- ON DELETE SET NULL ON UPDATE SET NULL >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `opac_news` >--- >- >-DROP TABLE IF EXISTS `opac_news`; >-CREATE TABLE `opac_news` ( >- `idnew` int(10) unsigned NOT NULL auto_increment, >- `title` varchar(250) NOT NULL default '', >- `new` text NOT NULL, >- `lang` varchar(25) NOT NULL default '', >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, >- `expirationdate` date default NULL, >- `number` int(11) default NULL, >- PRIMARY KEY (`idnew`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `overduerules` >--- >- >-DROP TABLE IF EXISTS `overduerules`; >-CREATE TABLE `overduerules` ( >- `branchcode` varchar(10) NOT NULL default '', >- `categorycode` varchar(2) NOT NULL default '', >- `delay1` int(4) default 0, >- `letter1` varchar(20) default NULL, >- `debarred1` varchar(1) default 0, >- `delay2` int(4) default 0, >- `debarred2` varchar(1) default 0, >- `letter2` varchar(20) default NULL, >- `delay3` int(4) default 0, >- `letter3` varchar(20) default NULL, >- `debarred3` int(1) default 0, >- PRIMARY KEY (`branchcode`,`categorycode`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `patroncards` >--- >- >-DROP TABLE IF EXISTS `patroncards`; >-CREATE TABLE `patroncards` ( >- `cardid` int(11) NOT NULL auto_increment, >- `batch_id` varchar(10) NOT NULL default '1', >- `borrowernumber` int(11) NOT NULL, >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, >- PRIMARY KEY (`cardid`), >- KEY `patroncards_ibfk_1` (`borrowernumber`), >- CONSTRAINT `patroncards_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `patronimage` >--- >- >-DROP TABLE IF EXISTS `patronimage`; >-CREATE TABLE `patronimage` ( >- `cardnumber` varchar(16) NOT NULL, >- `mimetype` varchar(15) NOT NULL, >- `imagefile` mediumblob NOT NULL, >- PRIMARY KEY (`cardnumber`), >- CONSTRAINT `patronimage_fk1` FOREIGN KEY (`cardnumber`) REFERENCES `borrowers` (`cardnumber`) ON DELETE CASCADE ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `printers` >--- >- >-DROP TABLE IF EXISTS `printers`; >-CREATE TABLE `printers` ( >- `printername` varchar(40) NOT NULL default '', >- `printqueue` varchar(20) default NULL, >- `printtype` varchar(20) default NULL, >- PRIMARY KEY (`printername`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `printers_profile` >--- >- >-DROP TABLE IF EXISTS `printers_profile`; >-CREATE TABLE `printers_profile` ( >- `prof_id` int(4) NOT NULL auto_increment, >- `printername` varchar(40) NOT NULL, >- `tmpl_id` int(4) NOT NULL, >- `paper_bin` varchar(20) NOT NULL, >- `offset_horz` float default NULL, >- `offset_vert` float default NULL, >- `creep_horz` float default NULL, >- `creep_vert` float default NULL, >- `unit` char(20) NOT NULL default 'POINT', >- PRIMARY KEY (`prof_id`), >- UNIQUE KEY `printername` (`printername`,`tmpl_id`,`paper_bin`), >- CONSTRAINT `printers_profile_pnfk_1` FOREIGN KEY (`tmpl_id`) REFERENCES `labels_templates` (`tmpl_id`) ON DELETE CASCADE ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `repeatable_holidays` >--- >- >-DROP TABLE IF EXISTS `repeatable_holidays`; >-CREATE TABLE `repeatable_holidays` ( >- `id` int(11) NOT NULL auto_increment, >- `branchcode` varchar(10) NOT NULL default '', >- `weekday` smallint(6) default NULL, >- `day` smallint(6) default NULL, >- `month` smallint(6) default NULL, >- `title` varchar(50) NOT NULL default '', >- `description` text NOT NULL, >- PRIMARY KEY (`id`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `reports_dictionary` >--- >- >-DROP TABLE IF EXISTS `reports_dictionary`; >-CREATE TABLE reports_dictionary ( >- `id` int(11) NOT NULL auto_increment, >- `name` varchar(255) default NULL, >- `description` text, >- `date_created` datetime default NULL, >- `date_modified` datetime default NULL, >- `saved_sql` text, >- `area` int(11) default NULL, >- PRIMARY KEY (`id`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `reserveconstraints` >--- >- >-DROP TABLE IF EXISTS `reserveconstraints`; >-CREATE TABLE `reserveconstraints` ( >- `borrowernumber` int(11) NOT NULL default 0, >- `reservedate` date default NULL, >- `biblionumber` int(11) NOT NULL default 0, >- `biblioitemnumber` int(11) default NULL, >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `reserves` >--- >- >-DROP TABLE IF EXISTS `reserves`; >-CREATE TABLE `reserves` ( >- `borrowernumber` int(11) NOT NULL default 0, >- `reservedate` date default NULL, >- `biblionumber` int(11) NOT NULL default 0, >- `constrainttype` varchar(1) default NULL, >- `branchcode` varchar(10) default NULL, >- `notificationdate` date default NULL, >- `reminderdate` date default NULL, >- `cancellationdate` date default NULL, >- `reservenotes` mediumtext, >- `priority` smallint(6) default NULL, >- `found` varchar(1) default NULL, >- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, >- `itemnumber` int(11) default NULL, >- `waitingdate` date default NULL, >- KEY `borrowernumber` (`borrowernumber`), >- KEY `biblionumber` (`biblionumber`), >- KEY `itemnumber` (`itemnumber`), >- KEY `branchcode` (`branchcode`), >- CONSTRAINT `reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, >- CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE, >- CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, >- CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `reviews` >--- >- >-DROP TABLE IF EXISTS `reviews`; >-CREATE TABLE `reviews` ( >- `reviewid` int(11) NOT NULL auto_increment, >- `borrowernumber` int(11) default NULL, >- `biblionumber` int(11) default NULL, >- `review` text, >- `approved` tinyint(4) default NULL, >- `datereviewed` datetime default NULL, >- PRIMARY KEY (`reviewid`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `roadtype` >--- >- >-DROP TABLE IF EXISTS `roadtype`; >-CREATE TABLE `roadtype` ( >- `roadtypeid` int(11) NOT NULL auto_increment, >- `road_type` varchar(100) NOT NULL default '', >- PRIMARY KEY (`roadtypeid`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `saved_sql` >--- >- >-DROP TABLE IF EXISTS `saved_sql`; >-CREATE TABLE saved_sql ( >- `id` int(11) NOT NULL auto_increment, >- `borrowernumber` int(11) default NULL, >- `date_created` datetime default NULL, >- `last_modified` datetime default NULL, >- `savedsql` text, >- `last_run` datetime default NULL, >- `report_name` varchar(255) default NULL, >- `type` varchar(255) default NULL, >- `notes` text, >- PRIMARY KEY (`id`), >- KEY boridx (`borrowernumber`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >- >--- >--- Table structure for `saved_reports` >--- >- >-DROP TABLE IF EXISTS `saved_reports`; >-CREATE TABLE saved_reports ( >- `id` int(11) NOT NULL auto_increment, >- `report_id` int(11) default NULL, >- `report` longtext, >- `date_run` datetime default NULL, >- PRIMARY KEY (`id`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >- >--- >--- Table structure for table `serial` >--- >- >-DROP TABLE IF EXISTS `serial`; >-CREATE TABLE `serial` ( >- `serialid` int(11) NOT NULL auto_increment, >- `biblionumber` varchar(100) NOT NULL default '', >- `subscriptionid` varchar(100) NOT NULL default '', >- `serialseq` varchar(100) NOT NULL default '', >- `status` tinyint(4) NOT NULL default 0, >- `planneddate` date default NULL, >- `notes` text, >- `publisheddate` date default NULL, >- `itemnumber` text default NULL, >- `claimdate` date default NULL, >- `routingnotes` text, >- PRIMARY KEY (`serialid`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `sessions` >--- >- >-DROP TABLE IF EXISTS sessions; >-CREATE TABLE sessions ( >- `id` varchar(32) NOT NULL, >- `a_session` text NOT NULL, >- UNIQUE KEY id (id) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `special_holidays` >--- >- >-DROP TABLE IF EXISTS `special_holidays`; >-CREATE TABLE `special_holidays` ( >- `id` int(11) NOT NULL auto_increment, >- `branchcode` varchar(10) NOT NULL default '', >- `day` smallint(6) NOT NULL default 0, >- `month` smallint(6) NOT NULL default 0, >- `year` smallint(6) NOT NULL default 0, >- `isexception` smallint(1) NOT NULL default 1, >- `title` varchar(50) NOT NULL default '', >- `description` text NOT NULL, >- PRIMARY KEY (`id`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `statistics` >--- >- >-DROP TABLE IF EXISTS `statistics`; >-CREATE TABLE `statistics` ( >- `datetime` datetime default NULL, >- `branch` varchar(10) default NULL, >- `proccode` varchar(4) default NULL, >- `value` double(16,4) default NULL, >- `type` varchar(16) default NULL, >- `other` mediumtext, >- `usercode` varchar(10) default NULL, >- `itemnumber` int(11) default NULL, >- `itemtype` varchar(10) default NULL, >- `borrowernumber` int(11) default NULL, >- `associatedborrower` int(11) default NULL, >- KEY `timeidx` (`datetime`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `stopwords` >--- >- >-DROP TABLE IF EXISTS `stopwords`; >- CREATE TABLE `stopwords` ( >- `word` varchar(255) default NULL >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `subcategorytable` >--- >- >-DROP TABLE IF EXISTS `subcategorytable`; >-CREATE TABLE `subcategorytable` ( >- `subcategorycode` varchar(5) NOT NULL default '', >- `description` text, >- `itemtypecodes` text, >- PRIMARY KEY (`subcategorycode`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `subscription` >--- >- >-DROP TABLE IF EXISTS `subscription`; >-CREATE TABLE `subscription` ( >- `biblionumber` int(11) NOT NULL default 0, >- `subscriptionid` int(11) NOT NULL auto_increment, >- `librarian` varchar(100) default '', >- `startdate` date default NULL, >- `aqbooksellerid` int(11) default 0, >- `cost` int(11) default 0, >- `aqbudgetid` int(11) default 0, >- `weeklength` int(11) default 0, >- `monthlength` int(11) default 0, >- `numberlength` int(11) default 0, >- `periodicity` tinyint(4) default 0, >- `dow` varchar(100) default '', >- `numberingmethod` varchar(100) default '', >- `notes` mediumtext, >- `status` varchar(100) NOT NULL default '', >- `add1` int(11) default 0, >- `every1` int(11) default 0, >- `whenmorethan1` int(11) default 0, >- `setto1` int(11) default NULL, >- `lastvalue1` int(11) default NULL, >- `add2` int(11) default 0, >- `every2` int(11) default 0, >- `whenmorethan2` int(11) default 0, >- `setto2` int(11) default NULL, >- `lastvalue2` int(11) default NULL, >- `add3` int(11) default 0, >- `every3` int(11) default 0, >- `innerloop1` int(11) default 0, >- `innerloop2` int(11) default 0, >- `innerloop3` int(11) default 0, >- `whenmorethan3` int(11) default 0, >- `setto3` int(11) default NULL, >- `lastvalue3` int(11) default NULL, >- `issuesatonce` tinyint(3) NOT NULL default 1, >- `firstacquidate` date default NULL, >- `manualhistory` tinyint(1) NOT NULL default 0, >- `irregularity` text, >- `letter` varchar(20) default NULL, >- `numberpattern` tinyint(3) default 0, >- `distributedto` text, >- `internalnotes` longtext, >- `callnumber` text, >- `branchcode` varchar(10) NOT NULL default '', >- `hemisphere` tinyint(3) default 0, >- `lastbranch` varchar(10), >- PRIMARY KEY (`subscriptionid`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `subscriptionhistory` >--- >- >-DROP TABLE IF EXISTS `subscriptionhistory`; >-CREATE TABLE `subscriptionhistory` ( >- `biblionumber` int(11) NOT NULL default 0, >- `subscriptionid` int(11) NOT NULL default 0, >- `histstartdate` date default NULL, >- `enddate` date default NULL, >- `missinglist` longtext NOT NULL, >- `recievedlist` longtext NOT NULL, >- `opacnote` varchar(150) NOT NULL default '', >- `librariannote` varchar(150) NOT NULL default '', >- PRIMARY KEY (`subscriptionid`), >- KEY `biblionumber` (`biblionumber`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `subscriptionroutinglist` >--- >- >-DROP TABLE IF EXISTS `subscriptionroutinglist`; >-CREATE TABLE `subscriptionroutinglist` ( >- `routingid` int(11) NOT NULL auto_increment, >- `borrowernumber` int(11) default NULL, >- `ranking` int(11) default NULL, >- `subscriptionid` int(11) default NULL, >- PRIMARY KEY (`routingid`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `suggestions` >--- >- >-DROP TABLE IF EXISTS `suggestions`; >-CREATE TABLE `suggestions` ( >- `suggestionid` int(8) NOT NULL auto_increment, >- `suggestedby` int(11) NOT NULL default 0, >- `managedby` int(11) default NULL, >- `STATUS` varchar(10) NOT NULL default '', >- `note` mediumtext, >- `author` varchar(80) default NULL, >- `title` varchar(80) default NULL, >- `copyrightdate` smallint(6) default NULL, >- `publishercode` varchar(255) default NULL, >- `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, >- `volumedesc` varchar(255) default NULL, >- `publicationyear` smallint(6) default 0, >- `place` varchar(255) default NULL, >- `isbn` varchar(10) default NULL, >- `mailoverseeing` smallint(1) default 0, >- `biblionumber` int(11) default NULL, >- `reason` text, >- PRIMARY KEY (`suggestionid`), >- KEY `suggestedby` (`suggestedby`), >- KEY `managedby` (`managedby`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `systempreferences` >--- >- >-DROP TABLE IF EXISTS `systempreferences`; >-CREATE TABLE `systempreferences` ( >- `variable` varchar(50) NOT NULL default '', >- `value` text, >- `options` mediumtext, >- `explanation` text, >- `type` varchar(20) default NULL, >- PRIMARY KEY (`variable`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `tags` >--- >- >-DROP TABLE IF EXISTS `tags`; >-CREATE TABLE `tags` ( >- `entry` varchar(255) NOT NULL default '', >- `weight` bigint(20) NOT NULL default 0, >- PRIMARY KEY (`entry`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `userflags` >--- >- >-DROP TABLE IF EXISTS `userflags`; >-CREATE TABLE `userflags` ( >- `bit` int(11) NOT NULL default 0, >- `flag` varchar(30) default NULL, >- `flagdesc` varchar(255) default NULL, >- `defaulton` int(11) default NULL, >- PRIMARY KEY (`bit`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `virtualshelves` >--- >- >-DROP TABLE IF EXISTS `virtualshelves`; >-CREATE TABLE `virtualshelves` ( >- `shelfnumber` int(11) NOT NULL auto_increment, >- `shelfname` varchar(255) default NULL, >- `owner` varchar(80) default NULL, >- `category` varchar(1) default NULL, >- `sortfield` varchar(16) default NULL, >- PRIMARY KEY (`shelfnumber`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `virtualshelfcontents` >--- >- >-DROP TABLE IF EXISTS `virtualshelfcontents`; >-CREATE TABLE `virtualshelfcontents` ( >- `shelfnumber` int(11) NOT NULL default 0, >- `biblionumber` int(11) NOT NULL default 0, >- `flags` int(11) default NULL, >- `dateadded` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, >- KEY `shelfnumber` (`shelfnumber`), >- KEY `biblionumber` (`biblionumber`), >- CONSTRAINT `virtualshelfcontents_ibfk_1` FOREIGN KEY (`shelfnumber`) REFERENCES `virtualshelves` (`shelfnumber`) ON DELETE CASCADE ON UPDATE CASCADE, >- CONSTRAINT `shelfcontents_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `z3950servers` >--- >- >-DROP TABLE IF EXISTS `z3950servers`; >-CREATE TABLE `z3950servers` ( >- `host` varchar(255) default NULL, >- `port` int(11) default NULL, >- `db` varchar(255) default NULL, >- `userid` varchar(255) default NULL, >- `password` varchar(255) default NULL, >- `name` mediumtext, >- `id` int(11) NOT NULL auto_increment, >- `checked` smallint(6) default NULL, >- `rank` int(11) default NULL, >- `syntax` varchar(80) default NULL, >- `icon` text, >- `position` enum('primary','secondary','') NOT NULL default 'primary', >- `type` enum('zed','opensearch') NOT NULL default 'zed', >- `encoding` text default NULL, >- `description` text NOT NULL, >- PRIMARY KEY (`id`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- >--- Table structure for table `zebraqueue` >--- >- >-DROP TABLE IF EXISTS `zebraqueue`; >-CREATE TABLE `zebraqueue` ( >- `id` int(11) NOT NULL auto_increment, >- `biblio_auth_number` int(11) NOT NULL default '0', >- `operation` char(20) NOT NULL default '', >- `server` char(20) NOT NULL default '', >- `done` int(11) NOT NULL default '0', >- `time` timestamp NOT NULL default CURRENT_TIMESTAMP, >- PRIMARY KEY (`id`), >- KEY `zebraqueue_lookup` (`server`, `biblio_auth_number`, `operation`, `done`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >-DROP TABLE IF EXISTS `services_throttle`; >-CREATE TABLE `services_throttle` ( >- `service_type` varchar(10) NOT NULL default '', >- `service_count` varchar(45) default NULL, >- PRIMARY KEY (`service_type`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- http://www.w3.org/International/articles/language-tags/ >- >--- RFC4646 >-DROP TABLE IF EXISTS language_subtag_registry; >-CREATE TABLE language_subtag_registry ( >- subtag varchar(25), >- type varchar(25), -- language-script-region-variant-extension-privateuse >- description varchar(25), -- only one of the possible descriptions for ease of reference, see language_descriptions for the complete list >- added date, >- KEY `subtag` (`subtag`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- TODO: add suppress_scripts >--- this maps three letter codes defined in iso639.2 back to their >--- two letter equivilents in rfc4646 (LOC maintains iso639+) >-DROP TABLE IF EXISTS language_rfc4646_to_iso639; >-CREATE TABLE language_rfc4646_to_iso639 ( >- rfc4646_subtag varchar(25), >- iso639_2_code varchar(25), >- KEY `rfc4646_subtag` (`rfc4646_subtag`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >-DROP TABLE IF EXISTS language_descriptions; >-CREATE TABLE language_descriptions ( >- subtag varchar(25), >- type varchar(25), >- lang varchar(25), >- description varchar(255), >- KEY `lang` (`lang`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- bi-directional support, keyed by script subcode >-DROP TABLE IF EXISTS language_script_bidi; >-CREATE TABLE language_script_bidi ( >- rfc4646_subtag varchar(25), -- script subtag, Arab, Hebr, etc. >- bidi varchar(3), -- rtl ltr >- KEY `rfc4646_subtag` (`rfc4646_subtag`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >--- TODO: need to map language subtags to script subtags for detection >--- of bidi when script is not specified (like ar, he) >-DROP TABLE IF EXISTS language_script_mapping; >-CREATE TABLE language_script_mapping ( >- language_subtag varchar(25), >- script_subtag varchar(25), >- KEY `language_subtag` (`language_subtag`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >-DROP TABLE IF EXISTS serialitems; >-CREATE TABLE serialitems ( >- serialid int(11) NOT NULL, >- itemnumber int(11) NOT NULL, >- UNIQUE KEY `serialididx` (`serialid`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >- >-/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; >-/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; >-/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; >-/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; >-/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; >-/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; >-/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; >-/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; >- >-- >1.7.10.4
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 10296
:
18266
|
18534
| 18779