Bugzilla – Attachment 22507 Details for
Bug 11155
PostgreSQL schema contains syntax errors
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
Fixes syntax errors in PostgreSQL db schema
kohastructure.sql (text/x-sql), 45.05 KB, created by
Dan Scott
on 2013-10-29 03:54:27 UTC
(
hide
)
Description:
Fixes syntax errors in PostgreSQL db schema
Filename:
MIME Type:
Creator:
Dan Scott
Created:
2013-10-29 03:54:27 UTC
Size:
45.05 KB
patch
obsolete
>-- PostgreSQL kohastructure script >-- Initial port 2007/10/22 fbcit >-- This is very 'alpha' at this point since much of the source will have to be mod'd to do data manipulations before it can be fully tested. >-- Many tables lack a primary key and probably need one as that is generally a good db practice. >-- **This script requires plpgsql be loaded into the pg koha db PRIOR to executing.** >-- This could be done in this script. However, the user must have superuser priviledge. I'm not sure how the koha installer handles this. > >--begin; > >-- >-- Function to generate populate timestamp fields on update >-- > >CREATE FUNCTION time_stamp() RETURNS trigger AS $time_stamp$ > BEGIN > -- Update timestamp field on row insert or update > NEW.timestamp := current_timestamp; > RETURN NEW; > END; >$time_stamp$ LANGUAGE plpgsql; > >COMMENT ON FUNCTION time_stamp() IS $$ This function updates the timestamp field on an insert or update. It equates to mysql 'on update CURRENT_TIMESTAMP'. $$; > >-- >-- Table structure for table accountlines >-- > >--DROP TABLE accountlines; --Left the DROP TABLE statements here if needed for some reason... > >CREATE TABLE accountlines ( >borrowernumber int NOT NULL default 0, >accountno int NOT NULL default 0, >itemnumber int 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 NOT NULL default (now()), >notify_id int NOT NULL default 0, >notify_level int NOT NULL default 0 >); >CREATE INDEX accountlines_itemnumber_idx ON accountlines (itemnumber); -- Indecies replace msyql 'enums' datatype. Pg 8.3 will have 'enums' so this may be changed back later... >CREATE INDEX accountlines_acctsborr_idx ON accountlines (borrowernumber); >CREATE INDEX accountlines_time_idx ON accountlines (timestamp); > >-- >-- Create timestamp trigger >-- > >CREATE TRIGGER time_stamp BEFORE INSERT OR UPDATE ON accountlines > FOR EACH ROW EXECUTE PROCEDURE time_stamp(); > >-- >-- Table structure for table accountoffsets >-- > >--DROP TABLE accountoffsets; > >CREATE TABLE accountoffsets ( >borrowernumber int NOT NULL default 0, >accountno int NOT NULL default 0, >offsetaccount int NOT NULL default 0, >offsetamount decimal(28,6) default NULL, >"timestamp" timestamp NOT NULL default (now()) >); > > >-- >-- Create timestamp trigger >-- > >CREATE TRIGGER time_stamp BEFORE INSERT OR UPDATE ON accountoffsets > FOR EACH ROW EXECUTE PROCEDURE time_stamp(); > >-- >-- Table structure for table action_logs >-- > >--DROP TABLE action_logs; > >CREATE TABLE action_logs ( >"timestamp" timestamp NOT NULL default (now()), >"user" int NOT NULL default 0, >module text, >"action" text, >"object" int default NULL, >info text, >PRIMARY KEY (timestamp,"user") >); > >-- >-- Create timestamp trigger >-- > >CREATE TRIGGER time_stamp BEFORE INSERT OR UPDATE ON action_logs > FOR EACH ROW EXECUTE PROCEDURE time_stamp(); > >-- >-- Table structure for table alert >-- > >--DROP TABLE alert; > >CREATE TABLE alert ( >alertid BIGSERIAL, >borrowernumber int NOT NULL default 0, >"type" varchar(10) NOT NULL default '', >externalid varchar(20) NOT NULL default '', >PRIMARY KEY (alertid) >); >CREATE INDEX alert_borrowernumber_idx ON alert (borrowernumber); >CREATE INDEX alert_type_idx ON alert (type,externalid); > >-- >-- Table structure for table aqbasket >-- > >--DROP TABLE aqbasket; > >CREATE TABLE aqbasket ( >basketno BIGSERIAL, >creationdate date default NULL, >closedate date default NULL, >booksellerid int NOT NULL default '1', >authorisedby varchar(10) default NULL, >booksellerinvoicenumber text, >PRIMARY KEY (basketno) >); >CREATE INDEX aqbasket_booksellerid_idx ON aqbasket (booksellerid); > >-- >-- Table structure for table aqbookfund >-- > >--DROP TABLE aqbookfund; > >CREATE TABLE aqbookfund ( >bookfundid varchar(10) UNIQUE NOT NULL default '', >bookfundname text, >bookfundgroup varchar(5) default NULL, >branchcode varchar(10) NOT NULL default '', >PRIMARY KEY (bookfundid,branchcode) >); > >-- >-- Table structure for table aqbooksellers >-- > >--DROP TABLE aqbooksellers; > >CREATE TABLE aqbooksellers ( >id BIGSERIAL, >name text, >address1 text, >address2 text, >address3 text, >address4 text, >phone varchar(30) default NULL, >accountnumber text, >othersupplier text, >currency varchar(3) NOT NULL default '', >deliverydays int default NULL, >followupdays int default NULL, >followupscancel int 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 int default NULL, >listprice varchar(10) default NULL, >invoiceprice varchar(10) default NULL, >gstreg int default NULL, >listincgst int default NULL, >invoiceincgst int default NULL, >discount numeric(6,4) default NULL, >fax varchar(50) default NULL, >nocalc int default NULL, >invoicedisc numeric(6,4) default NULL, >PRIMARY KEY (id) >); >CREATE INDEX aqbooksellers_invoiceprice_idx ON aqbooksellers (invoiceprice); >CREATE INDEX aqbooksellers_listprice_idx ON aqbooksellers (listprice); > >-- >-- Table structure for table aqbudget >-- > >--DROP TABLE aqbudget; > >CREATE TABLE aqbudget ( >bookfundid varchar(10) NOT NULL default '', >startdate date default NULL, >enddate date default NULL, >budgetamount decimal(13,2) default NULL, >aqbudgetid BIGSERIAL, >branchcode varchar(10) default NULL, >PRIMARY KEY (aqbudgetid) >); > >-- >-- Table structure for table aqorderbreakdown >-- > >--DROP TABLE aqorderbreakdown; > >CREATE TABLE aqorderbreakdown ( >ordernumber int default NULL, >"linenumber" int default NULL, >branchcode varchar(10) default NULL, >bookfundid varchar(10) NOT NULL default '', >allocation int default NULL >); >CREATE INDEX aqorderbreakdown_bookfundid_idx ON aqorderbreakdown (bookfundid); >CREATE INDEX aqorderbreakdown_ordernumber_idx ON aqorderbreakdown (ordernumber); > >-- >-- Table structure for table aqorderdelivery >-- > >--DROP TABLE aqorderdelivery; > >CREATE TABLE aqorderdelivery ( >ordernumber date default NULL, >deliverynumber int NOT NULL default 0, >deliverydate varchar(18) default NULL, >qtydelivered int default NULL, >deliverycomments text >); > >-- >-- Table structure for table aqorders >-- > >--DROP TABLE aqorders; > >CREATE TABLE aqorders ( >ordernumber BIGSERIAL, >biblionumber int default NULL, >title text, >entrydate date default NULL, >quantity int default NULL, >currency varchar(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 int default NULL, >cancelledby varchar(10) default NULL, >datecancellationprinted date default NULL, >notes text, >supplierreference text, >purchaseordernumber text, >subscription int default NULL, >serialid varchar(30) default NULL, >basketno int default NULL, >biblioitemnumber int default NULL, >"timestamp" timestamp NOT NULL default (now()), >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) >); >CREATE INDEX aqorders_biblionumber_idx ON aqorders (biblionumber); >CREATE INDEX aqorders_basketno_idx ON aqorders (basketno); > >-- >-- Table structure for table auth_header >-- > >--DROP TABLE auth_header; > >CREATE TABLE auth_header ( >authid BIGSERIAL NOT NULL, >authtypecode varchar(10) NOT NULL default '', >datecreated date default NULL, >datemodified date default NULL, >origincode varchar(20) default NULL, >authtrees text, >marc bytea, >linkid int default NULL, >marcxml text NOT NULL, >PRIMARY KEY (authid) >); >CREATE INDEX auth_header_origincode_idx ON auth_header (origincode); > >-- >-- Table structure for table auth_subfield_structure >-- > >--DROP TABLE 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" int NOT NULL default 0, >mandatory int NOT NULL default 0, >tab int default NULL, >authorised_value varchar(10) default NULL, >value_builder varchar(80) default NULL, >seealso varchar(255) default NULL, >isurl int default NULL, >hidden int NOT NULL default 0, >linkid int NOT NULL default 0, >kohafield varchar(45) NULL default '', >frameworkcode varchar(8) NOT NULL default '', >PRIMARY KEY (authtypecode,tagfield,tagsubfield) >); >CREATE INDEX auth_subfield_structure_tab_idx ON auth_subfield_structure (authtypecode,tab); > >-- >-- Table structure for table auth_tag_structure >-- > >--DROP TABLE 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" int NOT NULL default 0, >mandatory int NOT NULL default 0, >authorised_value varchar(10) default NULL, >PRIMARY KEY (authtypecode,tagfield) >); > >-- >-- Table structure for table auth_types >-- > >--DROP TABLE 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 text NOT NULL, >PRIMARY KEY (authtypecode) >); > >-- >-- Table structure for table authorised_values >-- > >--DROP TABLE authorised_values; > >CREATE TABLE authorised_values ( >id BIGSERIAL, >category varchar(10) NOT NULL default '', >authorised_value varchar(80) NOT NULL default '', >lib varchar(80) default NULL, >PRIMARY KEY (id) >); >CREATE INDEX authorised_values_name_idx ON authorised_values (category); > >-- >-- Table structure for table biblio >-- > >--DROP TABLE biblio; > >CREATE TABLE biblio ( >biblionumber int NOT NULL default 0, >frameworkcode varchar(4) NOT NULL default '', >author text, >title text, >unititle text, >notes text, >serial int default NULL, >seriestitle text, >copyrightdate int default NULL, >"timestamp" timestamp NOT NULL default (now()), >datecreated DATE NOT NULL, >abstract text, >PRIMARY KEY (biblionumber) >); >CREATE INDEX biblio_blbnoidx_idx ON biblio (biblionumber); > >-- >-- Table structure for table biblio_framework >-- > >--DROP TABLE biblio_framework; > >CREATE TABLE biblio_framework ( >frameworkcode varchar(4) NOT NULL default '', >frameworktext varchar(255) NOT NULL default '', >PRIMARY KEY (frameworkcode) >); > >-- >-- Table structure for table biblioitems >-- > >--DROP TABLE biblioitems; > >CREATE TABLE biblioitems ( >biblioitemnumber int NOT NULL default 0, >biblionumber int NOT NULL default 0, >volume text, >number text, >classification varchar(25) default NULL, >itemtype varchar(10) default NULL, >isbn varchar(14) default NULL, >issn varchar(9) default NULL, >dewey varchar(30) default '', >subclass varchar(3) default NULL, >publicationyear text, >publishercode varchar(255) default NULL, >volumedate date default NULL, >volumeddesc text, >collectiontitle text default NULL, >collectionissn text default NULL, >collectionvolume text default NULL, >editionstatement text default NULL, >editionresponsibility text default NULL, >"timestamp" timestamp NOT NULL default (now()), >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 bytea, >url varchar(255) default NULL, >lcsort varchar(25) default NULL, >ccode varchar(4) default NULL, >marcxml text NOT NULL, >PRIMARY KEY (biblioitemnumber) >); >CREATE INDEX biblioitems_publishercode_idx ON biblioitems (publishercode); >CREATE INDEX biblioitems_biblioitemnumber_idx ON biblioitems (biblioitemnumber); >CREATE INDEX biblioitems_biblionumber_idx ON biblioitems (biblionumber); >CREATE INDEX biblioitems_isbn_idx ON biblioitems (isbn); > >-- >-- Table structure for table borrowers >-- > >--DROP TABLE borrowers; > >CREATE TABLE borrowers ( >borrowernumber BIGSERIAL UNIQUE, >cardnumber varchar(16) UNIQUE default NULL, >surname text NOT NULL, >firstname text, >title text, >othernames text, >initials text, >streetnumber varchar(10) default NULL, >streettype varchar(50) default NULL, >address text NOT NULL, >address2 text, >city text NOT NULL, >zipcode varchar(25) default NULL, >country text, >email text, >phone text, >mobile varchar(50) default NULL, >fax text, >emailpro text, >phonepro text, >B_streetnumber varchar(10) default NULL, >B_streettype varchar(50) default NULL, >B_address varchar(100) default NULL, >B_address2 text default NULL, >B_city text, >B_zipcode varchar(25) default NULL, >B_country text, >B_email text, >B_phone text, >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 int default NULL, >lost int default NULL, >debarred int default NULL, >contactname text, >contactfirstname text, >contacttitle text, >guarantorid int default NULL, >borrowernotes text, >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 default NULL, >userid varchar(30) default NULL, >opacnote text, >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, >altcontactcountry text default NULL, >altcontactphone varchar(50) default NULL, >smsalertnumber varchar(50) default NULL >); >CREATE INDEX borrowers_branchcode_idx ON borrowers (branchcode); >CREATE INDEX borrowers_borrowernumber_idx ON borrowers (borrowernumber); >CREATE INDEX borrowers_categorycode_idx ON borrowers (categorycode); > >-- >-- Table structure for table branchcategories >-- > >--DROP TABLE branchcategories; > >CREATE TABLE branchcategories ( >categorycode varchar(4) NOT NULL default '', >categoryname text, >codedescription text, >PRIMARY KEY (categorycode) >); > >-- >-- Table structure for table branches >-- > >--DROP TABLE branches; > >CREATE TABLE branches ( >branchcode varchar(10) UNIQUE NOT NULL default '', >branchname text NOT NULL, >branchaddress1 text, >branchaddress2 text, >branchaddress3 text, >branchzip varchar(25) default NULL, >branchcity text, >branchcountry text, >branchphone text, >branchfax text, >branchemail text, >branchurl text, >issuing int default NULL, >branchip varchar(15) default NULL, >branchprinter varchar(100) default NULL, >branchnotes text >); > >-- >-- Table structure for table branchrelations >-- > >--DROP TABLE branchrelations; > >CREATE TABLE branchrelations ( >branchcode varchar(10) NOT NULL default '', >categorycode varchar(4) NOT NULL default '', >PRIMARY KEY (branchcode,categorycode) >); >CREATE INDEX branchrelations_categorycode_idx ON branchrelations (categorycode); >CREATE INDEX branchrelations_branchcode_idx ON branchrelations (branchcode); > >-- >-- Table structure for table branchtransfers >-- > >--DROP TABLE branchtransfers; > >CREATE TABLE branchtransfers ( >itemnumber int NOT NULL default 0, >datesent timestamp default NULL, >frombranch varchar(10) NOT NULL default '', >datearrived timestamp default NULL, >tobranch varchar(10) NOT NULL default '', >comments text >); >CREATE INDEX branchtransfers_frombranch_idx ON branchtransfers (frombranch); >CREATE INDEX branchtransfers_tobranch_idx ON branchtransfers (tobranch); >CREATE INDEX branchtransfers_itemnumber_idx ON branchtransfers (itemnumber); > >-- >-- Table structure for table browser >-- >--DROP TABLE browser; > >CREATE TABLE browser ( >level int NOT NULL, >classification varchar(20) NOT NULL, >description varchar(255) NOT NULL, >number int NOT NULL, >endnode int NOT NULL >); > >-- >-- Table structure for table categories >-- > >--DROP TABLE categories; > >CREATE TABLE categories ( >categorycode varchar(10) UNIQUE NOT NULL default '', >description text, >enrolmentperiod int default NULL, >upperagelimit int default NULL, >dateofbirthrequired int default NULL, >finetype varchar(30) default NULL, >bulk int default NULL, >enrolmentfee decimal(28,6) default NULL, >overduenoticerequired int default NULL, >issuelimit int default NULL, >reservefee decimal(28,6) default NULL, >category_type varchar(1) NOT NULL default 'A', >PRIMARY KEY (categorycode) >); > >-- >-- Table structure for table cities >-- > >--DROP TABLE cities; > >CREATE TABLE cities ( >cityid BIGSERIAL, >city_name varchar(100) NOT NULL default '', >city_zipcode varchar(20) default NULL, >PRIMARY KEY (cityid) >); > >-- >-- Table structure for table class_sort_rules >-- > >CREATE TABLE class_sort_rules ( > class_sort_rule varchar(10) UNIQUE NOT NULL default '', > description text, > sort_routine varchar(30) NOT NULL default '', > PRIMARY KEY (class_sort_rule) >); >CREATE INDEX class_sort_rule_idx ON class_sort_rules (class_sort_rule); > >-- >-- Table structure for table class_sources >-- > >CREATE TABLE class_sources ( > cn_source varchar(10) NOT NULL default '', > description text, > used int NOT NULL default 0, > class_sort_rule varchar(10) NOT NULL default '', > PRIMARY KEY (cn_source) >-- This seems redundant -fbcit >-- UNIQUE KEY cn_source_idx (cn_source), >); >CREATE INDEX used_idx ON class_sources (used); > >-- >-- Table structure for table currency >-- > >--DROP TABLE currency; > >CREATE TABLE currency ( >currency varchar(10) NOT NULL default '', >rate numeric(7,5) default NULL, >PRIMARY KEY (currency) >); > >-- >-- Table structure for table deletedbiblio >-- > >--DROP TABLE deletedbiblio; > >CREATE TABLE deletedbiblio ( >biblionumber int NOT NULL default 0, >frameworkcode varchar(4) NOT NULL, >author text, >title text, >unititle text, >notes text, >serial int default NULL, >seriestitle text, >copyrightdate int default NULL, >"timestamp" timestamp NOT NULL default (now()), >marc bytea, >abstract text, >PRIMARY KEY (biblionumber) >); >CREATE INDEX deletedbiblio_blbnoidx_idx ON deletedbiblio (biblionumber); > >-- >-- Table structure for table deletedbiblioitems >-- > >--DROP TABLE deletedbiblioitems; > >CREATE TABLE deletedbiblioitems ( >biblioitemnumber int NOT NULL default 0, >biblionumber int NOT NULL default 0, >volume text, >number text, >classification varchar(25) default NULL, >itemtype varchar(10) default NULL, >isbn varchar(14) default NULL, >issn varchar(9) default NULL, >dewey numeric(8,6) default NULL, >subclass varchar(3) default NULL, >publicationyear int default NULL, >publishercode varchar(255) default NULL, >volumedate date default NULL, >volumeddesc varchar(255) default NULL, >"timestamp" timestamp NOT NULL default (now()), >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, >place varchar(255) default NULL, >lcsort varchar(25) default NULL, >ccode varchar(4) default NULL, >marcxml text NOT NULL, >collectiontitle text, >collectionissn text, >collectionvolume text, >editionstatement text, >editionresponsibility text, >PRIMARY KEY (biblioitemnumber) >); >CREATE INDEX deletedbiblioitems_biblioitemnumber_idx ON deletedbiblioitems (biblioitemnumber); >CREATE INDEX deletedbiblioitems_biblionumber_idx ON deletedbiblioitems (biblionumber); > >-- >-- Table structure for table deletedborrowers >-- > >--DROP TABLE deletedborrowers; > >CREATE TABLE deletedborrowers ( >borrowernumber int NOT NULL default 0, >cardnumber varchar(9) NOT NULL default '', >surname text NOT NULL, >firstname text, >title text, >othernames text, >initials text, >streetnumber varchar(10) default NULL, >streettype varchar(50) default NULL, >address text NOT NULL, >address2 text, >city text NOT NULL, >zipcode varchar(25) default NULL, >email text, >phone text, >mobile varchar(50) default NULL, >fax text, >emailpro text, >phonepro text, >B_streetnumber varchar(10) default NULL, >B_streettype varchar(50) default NULL, >B_address varchar(100) default NULL, >B_address2 text default NULL, >B_city text, >B_zipcode varchar(25) default NULL, >B_email text, >B_phone text, >dateofbirth date default NULL, >branchcode varchar(10) NOT NULL default '', >categorycode varchar(2) default NULL, >dateenrolled date default NULL, >dateexpiry date default NULL, >gonenoaddress int default NULL, >lost int default NULL, >debarred int default NULL, >contactname text, >contactfirstname text, >contacttitle text, >guarantorid int default NULL, >borrowernotes text, >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 default NULL, >userid varchar(30) default NULL, >opacnote text, >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, >altcontactcountry text default NULL, >altcontactphone varchar(50) default NULL, >smsalertnumber varchar(50) default NULL >); >CREATE INDEX deletedborrowers_borrowernumber_idx ON deletedborrowers (borrowernumber); >CREATE INDEX deletedborrowers_cardnumber_idx ON deletedborrowers (cardnumber); > >-- >-- Table structure for table deleteditems >-- > >--DROP TABLE deleteditems; > >CREATE TABLE deleteditems ( >itemnumber int NOT NULL default 0, >biblionumber int NOT NULL default 0, >biblioitemnumber int NOT NULL default 0, >barcode varchar(9) UNIQUE 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, >stack int default NULL, >notforloan int default NULL, >damaged int default NULL, >itemlost int default NULL, >withdrawn int default NULL, >bulk varchar(30) default NULL, >issues int default NULL, >renewals int default NULL, >reserves int default NULL, >restricted int default NULL, >itemnotes text, >holdingbranch varchar(4) default NULL, >interim int default NULL, >"timestamp" timestamp NOT NULL default (now()), >marc bytea, >paidfor text, >"location" varchar(80) default NULL, >itemcallnumber varchar(30) default NULL, >onloan date default NULL, >cutterextra varchar(45) default NULL, >itype varchar(10) default NULL, >PRIMARY KEY (itemnumber) >); >CREATE INDEX deleteditems_barcode_idx ON deleteditems (barcode); >CREATE INDEX deleteditems_biblioitemnumber_idx ON deleteditems (biblioitemnumber); >CREATE INDEX deleteditems_itembibnoidx_idx ON deleteditems (biblionumber); > >-- >-- Table structure for table ethnicity >-- > >--DROP TABLE ethnicity; > >CREATE TABLE ethnicity ( >code varchar(10) NOT NULL default '', >name varchar(255) default NULL, >PRIMARY KEY (code) >); > >-- >-- Table structure for table issues >-- > >--DROP TABLE issues; > >CREATE TABLE issues ( >borrowernumber int default NULL, >itemnumber int 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 int default NULL, >"timestamp" timestamp NOT NULL default (now()), >issuedate date default NULL >); >CREATE INDEX issues_borrowernumber_idx ON issues (borrowernumber); >CREATE INDEX issues_itemnumber_idx ON issues (itemnumber); >CREATE INDEX issues_bordate_idx ON issues (borrowernumber,timestamp); > >-- >-- Table structure for table issuingrules >-- > >--DROP TABLE issuingrules; > >CREATE TABLE issuingrules ( >categorycode varchar(10) NOT NULL default '', >itemtype varchar(10) NOT NULL default '', >restrictedtype int default NULL, >rentaldiscount decimal(28,6) default NULL, >reservecharge decimal(28,6) default NULL, >fine decimal(28,6) default NULL, >firstremind int default NULL, >chargeperiod int default NULL, >accountsent int default NULL, >chargename varchar(100) default NULL, >maxissueqty int default NULL, >issuelength int default NULL, >branchcode varchar(10) NOT NULL default '', >PRIMARY KEY (branchcode,categorycode,itemtype) >); >CREATE INDEX issuingrules_categorycode_idx ON issuingrules (categorycode); >CREATE INDEX issuingrules_itemtype_idx ON issuingrules (itemtype); > >-- >-- Table structure for table items >-- > >--DROP TABLE items; > >CREATE TABLE items ( >itemnumber int NOT NULL default 0, >biblionumber int NOT NULL default 0, >biblioitemnumber int 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, >stack int default NULL, >notforloan int default NULL, >damaged int default NULL, >itemlost int default NULL, >withdrawn int default NULL, >itemcallnumber varchar(30) default NULL, >issues int default NULL, >renewals int default NULL, >reserves int default NULL, >restricted int default NULL, >itemnotes text, >holdingbranch varchar(10) default NULL, >paidfor text, >"timestamp" timestamp NOT NULL default (now()), >"location" varchar(80) default NULL, >onloan date default NULL, >cutterextra varchar(45) default NULL, >itype varchar(10) default NULL, >PRIMARY KEY (itemnumber) >); >CREATE INDEX items_barcode_idx ON items (barcode); >CREATE INDEX items_biblioitemnumber_idx ON items (biblioitemnumber); >CREATE INDEX items_biblionumber_idx ON items (biblionumber); >CREATE INDEX items_homebranch_idx ON items (homebranch); >CREATE INDEX items_holdingbranch_idx ON items (holdingbranch); > >-- >-- Table structure for table itemtypes >-- > >--DROP TABLE itemtypes; > >CREATE TABLE itemtypes ( >itemtype varchar(10) UNIQUE NOT NULL default '', >description text, >renewalsallowed int default NULL, >rentalcharge numeric(16,4) default NULL, >notforloan int default NULL, >imageurl varchar(200) default NULL, >summary text, >PRIMARY KEY (itemtype) >); > >-- >-- Table structure for table labels >-- > >--DROP TABLE labels; > >CREATE TABLE labels ( >labelid BIGSERIAL UNIQUE NOT NULL, >batch_id varchar(10) NOT NULL default '1', >itemnumber varchar(100) NOT NULL default '', >"timestamp" timestamp NOT NULL default (now()), >PRIMARY KEY (labelid) >); > >-- >-- Table structure for table labels_conf >-- > >--DROP TABLE labels_conf; > >CREATE TABLE labels_conf ( >id BIGSERIAL UNIQUE NOT NULL, >barcodetype varchar(100) default '', >title int default '0', >itemtype int default '0', >barcode int default '0', >dewey int default '0', >"class" int default '0', >subclass int default '0', >itemcallnumber int default '0', >author int default '0', >issn int default '0', >isbn int default '0', >startlabel int NOT NULL default '1', >printingtype varchar(32) default 'BAR', >layoutname varchar(20) NOT NULL default 'TEST', >guidebox int default '0', >active int default '1', >fonttype varchar(10) default NULL, >subtitle int default NULL, >PRIMARY KEY (id) >); > >-- >-- Table structure for table labels_templates >-- > >--DROP TABLE labels_templates; > >CREATE TABLE labels_templates ( >tmpl_id BIGSERIAL UNIQUE NOT NULL, >tmpl_code varchar(100) default '', >tmpl_desc varchar(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 default '0', >"rows" int default '0', >colgap float default '0', >rowgap float default '0', >active int default NULL, >units varchar(20) default 'PX', >fontsize int NOT NULL default '3', >PRIMARY KEY (tmpl_id) >); > >-- >-- Table structure for table letter >-- > >--DROP TABLE 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) >); > >-- >-- Table structure for table marc_breeding >-- > >--DROP TABLE marc_breeding; > >CREATE TABLE marc_breeding ( >id BIGSERIAL, >file varchar(80) NOT NULL default '', >isbn varchar(10) NOT NULL default '', >title varchar(128) default NULL, >author varchar(80) default NULL, >marc bytea, >"encoding" varchar(40) NOT NULL default '', >z3950random varchar(40) default NULL, >PRIMARY KEY (id) >); >CREATE INDEX marc_breeding_title_idx ON marc_breeding (title); >CREATE INDEX marc_breeding_isbn_idx ON marc_breeding (isbn); > >-- >-- Table structure for table marc_subfield_structure >-- > >--DROP TABLE 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" int NOT NULL default 0, >mandatory int NOT NULL default 0, >kohafield varchar(40) default NULL, >tab int default NULL, >authorised_value varchar(20) default NULL, >authtypecode varchar(20) default NULL, >value_builder varchar(80) default NULL, >isurl int default NULL, >hidden int 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) >); >CREATE INDEX marc_subfield_structure_kohafield_2_idx ON marc_subfield_structure (kohafield); >CREATE INDEX marc_subfield_structure_tab_idx ON marc_subfield_structure (frameworkcode,tab); >CREATE INDEX marc_subfield_structure_kohafield_idx ON marc_subfield_structure (frameworkcode,kohafield); > >-- >-- Table structure for table marc_tag_structure >-- > >--DROP TABLE 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" int NOT NULL default 0, >mandatory int NOT NULL default 0, >authorised_value varchar(10) default NULL, >frameworkcode varchar(4) NOT NULL default '', >PRIMARY KEY (frameworkcode,tagfield) >); > >-- >-- Table structure for table notifys >-- > >--DROP TABLE notifys; > >CREATE TABLE notifys ( >notify_id int NOT NULL default 0, >borrowernumber int NOT NULL default 0, >itemnumber int NOT NULL default 0, >notify_date date default NULL, >notify_send_date date default NULL, >notify_level int NOT NULL default 0, >method varchar(20) NOT NULL default '' >); > >-- >-- Table structure for table nozebra >-- >CREATE TABLE nozebra ( >server varchar(20) NOT NULL, >indexname varchar(40) NOT NULL, >value varchar(250) NOT NULL, >biblionumbers text NOT NULL >); >CREATE INDEX nozebra_indexname_idx ON nozebra (server,indexname); >CREATE INDEX nozebra_value_idx ON nozebra (server,value); > >-- >-- Table structure for table opac_news >-- > >--DROP TABLE opac_news; > >CREATE TABLE opac_news ( >idnew SERIAL NOT NULL, >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 default NULL, >PRIMARY KEY (idnew) >); > >-- >-- Table structure for table overduerules >-- > >--DROP TABLE overduerules; > >CREATE TABLE overduerules ( >branchcode varchar(10) NOT NULL default '', >categorycode varchar(2) NOT NULL default '', >delay1 int default 0, >letter1 varchar(20) default NULL, >debarred1 varchar(1) default 0, >delay2 int default 0, >debarred2 varchar(1) default 0, >letter2 varchar(20) default NULL, >delay3 int default 0, >letter3 varchar(20) default NULL, >debarred3 int default 0, >PRIMARY KEY (branchcode,categorycode) >); > >-- >-- Table structure for table printers >-- > >--DROP TABLE printers; > >CREATE TABLE printers ( >printername varchar(40) NOT NULL default '', >printqueue varchar(20) default NULL, >printtype varchar(20) default NULL, >PRIMARY KEY (printername) >); > >-- >-- Table structure for table repeatable_holidays >-- > >--DROP TABLE repeatable_holidays; > >CREATE TABLE repeatable_holidays ( >id BIGSERIAL, >branchcode varchar(10) NOT NULL default '', >weekday int default NULL, >"day" int default NULL, >"month" int default NULL, >title varchar(50) NOT NULL default '', >description text NOT NULL, >PRIMARY KEY (id) >); > >-- >-- Table structure for table reserveCONSTRAINTs >-- > >--DROP TABLE reserveCONSTRAINTs; > >CREATE TABLE reserveCONSTRAINTs ( >borrowernumber int NOT NULL default 0, >reservedate date default NULL, >biblionumber int NOT NULL default 0, >biblioitemnumber int default NULL, >"timestamp" timestamp NOT NULL default (now()) >); > >-- >-- Table structure for table reserves >-- > >--DROP TABLE reserves; > >CREATE TABLE reserves ( >borrowernumber int NOT NULL default 0, >reservedate date default NULL, >biblionumber int 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 text, >priority int default NULL, >found varchar(1) default NULL, >"timestamp" timestamp NOT NULL default (now()), >itemnumber int default NULL, >waitingdate date default NULL >); >CREATE INDEX reserves_borrowernumber_idx ON reserves (borrowernumber); >CREATE INDEX reserves_biblionumber__idx ON reserves (biblionumber); >CREATE INDEX reserves_itemnumber__idx ON reserves (itemnumber); >CREATE INDEX reserves_branchcode_idx ON reserves (branchcode); > >-- >-- Table structure for table reviews >-- > >--DROP TABLE reviews; > >CREATE TABLE reviews ( >reviewid BIGSERIAL, >borrowernumber int default NULL, >biblionumber int default NULL, >review text, >approved int default NULL, >datereviewed timestamp default NULL, >PRIMARY KEY (reviewid) >); > >-- >-- Table structure for table roadtype >-- > >--DROP TABLE roadtype; > >CREATE TABLE roadtype ( >roadtypeid BIGSERIAL, >road_type varchar(100) NOT NULL default '', >PRIMARY KEY (roadtypeid) >); > >-- >-- Table structure for table serial >-- > >--DROP TABLE serial; > >CREATE TABLE serial ( >serialid BIGSERIAL, >biblionumber varchar(100) NOT NULL default '', >subscriptionid varchar(100) NOT NULL default '', >serialseq varchar(100) NOT NULL default '', >status int 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) >); > >-- >-- Table structure for table sessions >-- > >--DROP TABLE sessions; > >CREATE TABLE sessions ( >id varchar(32) UNIQUE NOT NULL, >a_session text NOT NULL >); > >-- >-- Table structure for table special_holidays >-- > >--DROP TABLE special_holidays; > >CREATE TABLE special_holidays ( >id BIGSERIAL, >branchcode varchar(10) NOT NULL default '', >"day" int NOT NULL default 0, >"month" int NOT NULL default 0, >"year" int NOT NULL default 0, >isexception int NOT NULL default '1', >title varchar(50) NOT NULL default '', >description text NOT NULL, >PRIMARY KEY (id) >); > >-- >-- Table structure for table statistics >-- > >--DROP TABLE statistics; > >CREATE TABLE statistics ( >datetime timestamp default NULL, >"timestamp" timestamp default NULL, >branch varchar(10) default NULL, >proccode varchar(4) default NULL, >value numeric(16,4) default NULL, >"type" varchar(16) default NULL, >other text, >usercode varchar(10) default NULL, >itemnumber int default NULL, >itemtype varchar(10) default NULL, >borrowernumber int default NULL, >associatedborrower int default NULL >); >CREATE INDEX statistics_timeidx_idx ON statistics (datetime); > >-- >-- Table structure for table stopwords >-- > >--DROP TABLE stopwords; > >CREATE TABLE stopwords ( >word varchar(255) default NULL >); > >-- >-- Table structure for table subscription >-- > >--DROP TABLE subscription; > >CREATE TABLE subscription ( >biblionumber int NOT NULL default 0, >subscriptionid BIGSERIAL, >librarian varchar(100) default '', >startdate date default NULL, >aqbooksellerid int default 0, >cost int default 0, >aqbudgetid int default 0, >weeklength int default 0, >monthlength int default 0, >numberlength int default 0, >periodicity int default 0, >dow varchar(100) default '', >numberingmethod varchar(100) default '', >notes text, >status varchar(100) NOT NULL default '', >add1 int default 0, >every1 int default 0, >whenmorethan1 int default 0, >setto1 int default NULL, >lastvalue1 int default NULL, >add2 int default 0, >every2 int default 0, >whenmorethan2 int default 0, >setto2 int default NULL, >lastvalue2 int default NULL, >add3 int default 0, >every3 int default 0, >innerloop1 int default 0, >innerloop2 int default 0, >innerloop3 int default 0, >whenmorethan3 int default 0, >setto3 int default NULL, >lastvalue3 int default NULL, >issuesatonce int NOT NULL default '1', >firstacquidate date default NULL, >manualhistory int NOT NULL default 0, >irregularity text, >letter varchar(20) default NULL, >numberpattern int default 0, >distributedto text, >internalnotes text, >callnumber text, >branchcode varchar(10) NOT NULL default '', >hemisphere int default 0, >PRIMARY KEY (subscriptionid) >); > >-- >-- Table structure for table subscriptionhistory >-- > >--DROP TABLE subscriptionhistory; > >CREATE TABLE subscriptionhistory ( >biblionumber int NOT NULL default 0, >subscriptionid int NOT NULL default 0, >histstartdate date default NULL, >enddate date default NULL, >missinglist text NOT NULL, >recievedlist text NOT NULL, >opacnote varchar(150) NOT NULL default '', >librariannote varchar(150) NOT NULL default '', >PRIMARY KEY (subscriptionid) >); >CREATE INDEX subscriptionhistory_biblionumber_idx ON subscriptionhistory (biblionumber); > >-- >-- Table structure for table subscriptionroutinglist >-- > >--DROP TABLE subscriptionroutinglist; > >CREATE TABLE subscriptionroutinglist ( >routingid BIGSERIAL, >borrowernumber int default NULL, >ranking int default NULL, >subscriptionid int default NULL, >PRIMARY KEY (routingid) >); > >-- >-- Table structure for table suggestions >-- > >--DROP TABLE suggestions; > >CREATE TABLE suggestions ( >suggestionid BIGSERIAL, >suggestedby int NOT NULL default 0, >managedby int default NULL, >STATUS varchar(10) NOT NULL default '', >note text, >author varchar(80) default NULL, >title varchar(80) default NULL, >copyrightdate int default NULL, >publishercode varchar(255) default NULL, >date timestamp NOT NULL default (now()), >volumedesc varchar(255) default NULL, >publicationyear int default 0, >place varchar(255) default NULL, >isbn varchar(10) default NULL, >mailoverseeing int default 0, >biblionumber int default NULL, >reason text, >PRIMARY KEY (suggestionid) >); >CREATE INDEX suggestions_suggestedby_idx ON suggestions (suggestedby); >CREATE INDEX suggestions_managedby_idx ON suggestions (managedby); > >-- >-- Table structure for table systempreferences >-- > >--DROP TABLE systempreferences; > >CREATE TABLE systempreferences ( >variable varchar(50) NOT NULL default '', >value text, >options text, >explanation text, >type varchar(20) default NULL, >PRIMARY KEY (variable) >); > >-- >-- Table structure for table tags >-- > >--DROP TABLE tags; > >CREATE TABLE tags ( >entry varchar(255) NOT NULL default '', >weight int NOT NULL default 0, >PRIMARY KEY (entry) >); > >-- >-- Table structure for table userflags >-- > >--DROP TABLE userflags; > >CREATE TABLE userflags ( >"bit" int NOT NULL default 0, >flag varchar(30) default NULL, >flagdesc varchar(255) default NULL, >defaulton int default NULL, >PRIMARY KEY (bit) >); > >-- >-- Table structure for table virtualshelves >-- > >--DROP TABLE virtualshelves; > >CREATE TABLE virtualshelves ( >shelfnumber BIGSERIAL, >shelfname varchar(255) default NULL, >"owner" varchar(80) default NULL, >category varchar(1) default NULL, >PRIMARY KEY (shelfnumber) >); > >-- >-- Table structure for table virtualshelfcontents >-- > >--DROP TABLE virtualshelfcontents; > >CREATE TABLE virtualshelfcontents ( >shelfnumber int NOT NULL default 0, >biblionumber int NOT NULL default 0, >flags int default NULL, >dateadded timestamp NULL default NULL >); >CREATE INDEX virtualshelfcontents_shelfnumber_idx ON virtualshelfcontents (shelfnumber); >CREATE INDEX virtualshelfcontents_biblionumber_idx ON virtualshelfcontents (biblionumber); > >-- >-- Table structure for table z3950servers >-- > >--DROP TABLE z3950servers; > >CREATE TABLE z3950servers ( >host varchar(255) default NULL, >port int default NULL, >db varchar(255) default NULL, >userid varchar(255) default NULL, >"password" varchar(255) default NULL, >name text, >id BIGSERIAL, >checked int default NULL, >rank int default NULL, >syntax varchar(80) default NULL, >icon text, >"position" varchar(10) NOT NULL default 'primary', >"type" varchar(10) NOT NULL default 'zed', >description text NOT NULL, >CHECK ( position IN ('primary', 'secondary', '' )), >CHECK ( type IN ('zed', 'opensearch', '' )), >PRIMARY KEY (id) >); > >-- >-- Table structure for table zebraqueue >-- > >--DROP TABLE zebraqueue; > >CREATE TABLE zebraqueue ( >id BIGSERIAL, >biblio_auth_number int NOT NULL default 0, >operation varchar(20) NOT NULL default '', >server varchar(20) NOT NULL default '', >PRIMARY KEY (id) >); > >-- >-- Add FK's last... (just because...) >-- > >ALTER TABLE accountlines ADD CONSTRAINT accountlines_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) MATCH SIMPLE ON DELETE CASCADE ON UPDATE CASCADE; >ALTER TABLE accountlines ADD CONSTRAINT accountlines_ibfk_2 FOREIGN KEY (itemnumber) REFERENCES items (itemnumber) ON DELETE SET NULL ON UPDATE SET NULL; > >-- Added this FK based on the FK in other tables referencing borrowers.borrowernumber -fbcit > >ALTER TABLE accountoffsets ADD CONSTRAINT accountoffsets_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) MATCH SIMPLE ON UPDATE CASCADE ON DELETE CASCADE; > >-- > >ALTER TABLE aqbasket ADD CONSTRAINT aqbasket_ibfk_1 FOREIGN KEY (booksellerid) REFERENCES aqbooksellers (id) ON UPDATE CASCADE; >ALTER TABLE aqbooksellers ADD CONSTRAINT aqbooksellers_ibfk_1 FOREIGN KEY (listprice) REFERENCES currency (currency) ON DELETE CASCADE ON UPDATE CASCADE; >ALTER TABLE aqbooksellers ADD CONSTRAINT aqbooksellers_ibfk_2 FOREIGN KEY (invoiceprice) REFERENCES currency (currency) ON DELETE CASCADE ON UPDATE CASCADE; >ALTER TABLE aqorderbreakdown ADD CONSTRAINT aqorderbreakdown_ibfk_1 FOREIGN KEY (ordernumber) REFERENCES aqorders (ordernumber) ON DELETE CASCADE ON UPDATE CASCADE; >ALTER TABLE aqorderbreakdown ADD CONSTRAINT aqorderbreakdown_ibfk_2 FOREIGN KEY (bookfundid) REFERENCES aqbookfund (bookfundid) ON DELETE CASCADE ON UPDATE CASCADE; >ALTER TABLE aqorders ADD CONSTRAINT aqorders_ibfk_1 FOREIGN KEY (basketno) REFERENCES aqbasket (basketno) ON DELETE CASCADE ON UPDATE CASCADE; >ALTER TABLE aqorders ADD CONSTRAINT aqorders_ibfk_2 FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE SET NULL ON UPDATE SET NULL; >ALTER TABLE auth_tag_structure ADD CONSTRAINT auth_tag_structure_ibfk_1 FOREIGN KEY (authtypecode) REFERENCES auth_types (authtypecode) ON DELETE CASCADE ON UPDATE CASCADE; >ALTER TABLE biblioitems ADD CONSTRAINT biblioitems_ibfk_1 FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE; >ALTER TABLE borrowers ADD CONSTRAINT borrowers_ibfk_1 FOREIGN KEY (categorycode) REFERENCES categories (categorycode); >ALTER TABLE borrowers ADD CONSTRAINT borrowers_ibfk_2 FOREIGN KEY (branchcode) REFERENCES branches (branchcode); >ALTER TABLE branchrelations ADD CONSTRAINT branchrelations_ibfk_1 FOREIGN KEY (branchcode) REFERENCES branches (branchcode) ON DELETE CASCADE ON UPDATE CASCADE; >ALTER TABLE branchrelations ADD CONSTRAINT branchrelations_ibfk_2 FOREIGN KEY (categorycode) REFERENCES branchcategories (categorycode) ON DELETE CASCADE ON UPDATE CASCADE; >ALTER TABLE branchtransfers ADD CONSTRAINT branchtransfers_ibfk_1 FOREIGN KEY (frombranch) REFERENCES branches (branchcode) ON DELETE CASCADE ON UPDATE CASCADE; >ALTER TABLE branchtransfers ADD CONSTRAINT branchtransfers_ibfk_2 FOREIGN KEY (tobranch) REFERENCES branches (branchcode) ON DELETE CASCADE ON UPDATE CASCADE; >ALTER TABLE branchtransfers ADD CONSTRAINT branchtransfers_ibfk_3 FOREIGN KEY (itemnumber) REFERENCES items (itemnumber) ON DELETE CASCADE ON UPDATE CASCADE; >ALTER TABLE class_sources ADD CONSTRAINT class_sources_ibfk_1 FOREIGN KEY (class_sort_rule) REFERENCES class_sort_rules (class_sort_rule); >ALTER TABLE issues ADD CONSTRAINT issues_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) MATCH SIMPLE ON DELETE SET NULL ON UPDATE SET NULL; >ALTER TABLE issues ADD CONSTRAINT issues_ibfk_2 FOREIGN KEY (itemnumber) REFERENCES items (itemnumber) ON DELETE SET NULL ON UPDATE SET NULL; >ALTER TABLE items ADD CONSTRAINT items_ibfk_1 FOREIGN KEY (biblioitemnumber) REFERENCES biblioitems (biblioitemnumber) ON DELETE CASCADE ON UPDATE CASCADE; >ALTER TABLE items ADD CONSTRAINT items_ibfk_2 FOREIGN KEY (homebranch) REFERENCES branches (branchcode) ON UPDATE CASCADE; >ALTER TABLE items ADD CONSTRAINT items_ibfk_3 FOREIGN KEY (holdingbranch) REFERENCES branches (branchcode) ON UPDATE CASCADE; >ALTER TABLE reserves ADD CONSTRAINT reserves_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) MATCH SIMPLE ON DELETE CASCADE ON UPDATE CASCADE; >ALTER TABLE reserves ADD CONSTRAINT reserves_ibfk_2 FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE; >ALTER TABLE reserves ADD CONSTRAINT reserves_ibfk_3 FOREIGN KEY (itemnumber) REFERENCES items (itemnumber) ON DELETE CASCADE ON UPDATE CASCADE; >ALTER TABLE reserves ADD CONSTRAINT reserves_ibfk_4 FOREIGN KEY (branchcode) REFERENCES branches (branchcode) ON DELETE CASCADE ON UPDATE CASCADE; >ALTER TABLE virtualshelfcontents ADD CONSTRAINT virtualshelfcontents_ibfk_1 FOREIGN KEY (shelfnumber) REFERENCES virtualshelves (shelfnumber) ON DELETE CASCADE ON UPDATE CASCADE; >ALTER TABLE virtualshelfcontents ADD CONSTRAINT virtualshelfcontents_ibfk_2 FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE; > > >-- >-- Table for branch_transfer_limits >-- >CREATE SEQUENCE branch_transfer_limits_limitId_seq START 1; > >CREATE TABLE branch_transfer_limits ( >limitId int PRIMARY KEY DEFAULT nextval('branch_transfer_limits_limitId_seq'), >toBranch varchar(4) NOT NULL, >fromBranch varchar(4) NOT NULL, >itemtype varchar(4) NOT NULL >); > > >--commit;
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 Raw
Actions:
View
Attachments on
bug 11155
: 22507 |
23500
|
23767
|
23778