Added a field to the barcodes sql search, now it returns the holding branch as well.

[koha.git] / database.mysql

diff --git a/database.mysql b/database.mysql
index 5cae357..57c8aaa 100644 (file)
--- a/database.mysql
+++ b/database.mysql
@@ -338,6 +338,7 @@ 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,
@@ -418,6 +419,7 @@ CREATE TABLE deletedbiblio (
   title text,
   unititle text,
   notes text,
+  abstract text,
   serial tinyint(1),
   seriestitle text,
   copyrightdate smallint(6),
@@ -541,6 +543,16 @@ CREATE TABLE deleteditems (
   UNIQUE barcode (barcode)
 );
 
+#
+# 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'
 #
@@ -786,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)
 );
 
@@ -799,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
+);