Long is the road to MARC..

[koha_gimpoz] / database.mysql

diff --git a/database.mysql b/database.mysql
index 497c365..57c8aaa 100644 (file)
--- a/database.mysql
+++ b/database.mysql
@@ -128,46 +128,50 @@ CREATE TABLE aqorderdelivery (
 # Table structure for table 'aqorders'
 #
 CREATE TABLE aqorders (
-  ordernumber int(11) DEFAULT '0' NOT NULL auto_increment,
-  biblionumber int(11),
+  ordernumber int(11) NOT NULL auto_increment,
+  biblionumber int(11) default NULL,
   title text,
-  requisitionedby varchar(10),
-  authorisedby varchar(10),
-  booksellerid varchar(10) DEFAULT '' NOT NULL,
-  deliverydays smallint(6),
-  followupdays smallint(6),
-  numberfollowupsallowed smallint(6),
-  numberfollowupssent smallint(6),
-  entrydate date,
-  dateprinted date,
-  quantity smallint(6),
-  currency char(3),
-  listprice decimal(28,6),
-  totalamount decimal(28,6),
-  datereceived date,
+  requisitionedby varchar(10) default NULL,
+  authorisedby varchar(10) default NULL,
+  booksellerid varchar(10) NOT NULL default '',
+  deliverydays smallint(6) default NULL,
+  followupdays smallint(6) default NULL,
+  numberfollowupsallowed smallint(6) default NULL,
+  numberfollowupssent smallint(6) default NULL,
+  entrydate date default NULL,
+  dateprinted date default NULL,
+  quantity smallint(6) default NULL,
+  currency char(3) default NULL,
+  listprice decimal(28,6) default NULL,
+  totalamount decimal(28,6) default NULL,
+  datereceived date default NULL,
   booksellerinvoicenumber text,
-  freight decimal(28,6),
-  unitprice decimal(28,6),
-  quantityreceived smallint(6),
+  freight decimal(28,6) default NULL,
+  unitprice decimal(28,6) default NULL,
+  quantityreceived smallint(6) default NULL,
   sourced text,
-  cancelledby varchar(10),
-  quantityreceiveddamaged smallint(6),
-  datecancellationprinted date,
+  cancelledby varchar(10) default NULL,
+  quantityreceiveddamaged smallint(6) default NULL,
+  datecancellationprinted date default NULL,
   notes text,
   supplierreference text,
   purchaseordernumber text,
-  subscription tinyint(1),
-  subscriptionfrom date,
-  subscriptionto date,
-  serialid varchar(30),
-  basketno int(11),
-  biblioitemnumber int(11),
-  timestamp timestamp(14),
-  rrp decimal(13,2),
-  ecost decimal(13,2),
-  gst decimal(13,2),
-  PRIMARY KEY (ordernumber)
-);
+  subscription tinyint(1) default NULL,
+  subscriptionfrom date default NULL,
+  subscriptionto date default NULL,
+  serialid varchar(30) default NULL,
+  basketno int(11) default NULL,
+  biblioitemnumber int(11) default NULL,
+  timestamp timestamp(14) NOT NULL,
+  rrp decimal(13,2) default NULL,
+  ecost decimal(13,2) default NULL,
+  gst decimal(13,2) default NULL,
+  PRIMARY KEY  (ordernumber),
+  KEY booksellerid (booksellerid),
+  KEY biblionumber (biblionumber),
+  KEY biblioitemnumber (biblioitemnumber),
+  KEY biblioitemnumber_2 (biblioitemnumber)
+) TYPE=MyISAM;
 
 #
 # Table structure for table 'biblio'
@@ -178,6 +182,7 @@ CREATE TABLE biblio (
   title text,
   unititle text,
   notes text,
+  abstract text,
   serial tinyint(1),
   seriestitle text,
   copyrightdate smallint(6),
@@ -205,6 +210,7 @@ CREATE TABLE biblioitems (
   number text,
   classification varchar(25),
   itemtype varchar(4),
+  url varchar(255),
   isbn varchar(14),
   issn varchar(9),
   dewey double(8,6),
@@ -302,8 +308,16 @@ CREATE TABLE borrowers (
 #
 CREATE TABLE branchcategories (
   categorycode char(2) DEFAULT '' NOT NULL,
-  branchcode char(4) DEFAULT '' NOT NULL,
-  branchholding int(11)
+  categoryname text,
+  codedescription text,    
+  PRIMARY KEY (categorycode)   
+);      
+
+# Table structure for table 'branchrelations'   
+#
+CREATE TABLE branchrelations (
+  branchcode varchar(4) DEFAULT '' NOT NULL,
+  categorycode varchar(4) DEFAULT '' NOT NULL  
 );
 
 #
@@ -324,12 +338,13 @@ CREATE TABLE branches (
 
 #
 # Table structure for table 'branchtransfers'
+# The date sent and datearrived fields are datetime not just date
 #
 CREATE TABLE branchtransfers (
   itemnumber int(11) DEFAULT '0' NOT NULL,
-  datesent date DEFAULT '0000-00-00' NOT NULL,
+  datesent datetime DEFAULT '0000-00-00' NOT NULL,
   frombranch varchar(4),
-  datearrived date,
+  datearrived datetime,
   tobranch varchar(4),
   comments text
 );
@@ -404,6 +419,7 @@ CREATE TABLE deletedbiblio (
   title text,
   unititle text,
   notes text,
+  abstract text,
   serial tinyint(1),
   seriestitle text,
   copyrightdate smallint(6),
@@ -528,6 +544,16 @@ CREATE TABLE deleteditems (
 );
 
 #
+# Table structure for table 'ethnicity'
+#
+
+CREATE TABLE ethnicity (
+  code varchar(10) NOT NULL default '',
+  name varchar(255) default NULL,
+  PRIMARY KEY  (code)
+);      
+
+#
 # Table structure for table 'issues'
 #
 CREATE TABLE issues (
@@ -772,6 +798,7 @@ CREATE TABLE stopwords (
 CREATE TABLE systempreferences (
   variable char(50) DEFAULT '' NOT NULL,
   value char(200),
+  explanation char(200) default '',
   PRIMARY KEY (variable)
 );
 
@@ -785,3 +812,30 @@ CREATE TABLE users (
   level smallint(6)
 );
 
+#
+# Table structure for 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),
+  PRIMARY KEY (websitenumber)
+) TYPE=ISAM PACK_KEYS=1;
+
+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)
+);
+                                       
+
+CREATE TABLE marcrecorddone (
+  isbn char(40) default NULL,
+  issn char(40) default NULL,
+  lccn char(40) default NULL
+);