Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Commits on Nov 13, 2007
  1. Moved location of updater scripts to dbms specific dir.

    Chris Nighswonger authored Joshua Ferraro committed
    Signed-off-by: Chris Cormack <crc@liblime.com>
    Signed-off-by: Joshua Ferraro <jmf@liblime.com>
Commits on Nov 12, 2007
  1. updatedatabase for itype.

    Ryan Higgins authored Joshua Ferraro committed
    Signed-off-by: Chris Cormack <crc@liblime.com>
    Signed-off-by: Joshua Ferraro <jmf@liblime.com>
  2. Making SQL more portable

    Chris Cormack authored Joshua Ferraro committed
    Signed-off-by: Chris Cormack <crc@liblime.com>
    Signed-off-by: Joshua Ferraro <jmf@liblime.com>
Commits on Nov 11, 2007
  1. changing biblioitems.itemtype to varchar(10)

    Mason James authored Joshua Ferraro committed
    Signed-off-by: Chris Cormack <crc@liblime.com>
    Signed-off-by: Joshua Ferraro <jmf@liblime.com>
Commits on Nov 9, 2007
  1. adding yuipath system preference to updatedatabase

    Joshua Ferraro authored
  2. fixing failed merge in updatedatabase

    Joshua Ferraro authored
    Signed-off-by: Joshua Ferraro <jmf@liblime.com>
  3. BUMP to 022 : items.damaged added

    Paul POULAIN authored Joshua Ferraro committed
    It was declared in kohastructure, but forgotten in updater. libraries upgrading from 2.2 will have problem...
    
    Signed-off-by: Chris Cormack <crc@liblime.com>
    Signed-off-by: Joshua Ferraro <jmf@liblime.com>
Commits on Nov 8, 2007
  1. extended missed branchcode columns to 10 chars

    Mason James authored Joshua Ferraro committed
    Signed-off-by: Chris Cormack <crc@liblime.com>
    Signed-off-by: Joshua Ferraro <jmf@liblime.com>
Commits on Nov 1, 2007
  1. set DB rev to 020

    Galen Charlton authored Joshua Ferraro committed
    Signed-off-by: Chris Cormack <crc@liblime.com>
    Signed-off-by: Joshua Ferraro <jmf@liblime.com>
  2. made key on deleteditems.barcode non-unique

    Galen Charlton authored Joshua Ferraro committed
    User could conceivable delete an item, add one with the
    same barcode, then delete it again.  If key on
    deleteditems.barcode is unique, second deletion
    will not populate deleteditems.
    
    Signed-off-by: Chris Cormack <crc@liblime.com>
    Signed-off-by: Joshua Ferraro <jmf@liblime.com>
  3. made several PKs be auto_increment columns

    Galen Charlton authored Joshua Ferraro committed
    * biblio.biblionumber
    * biblioitems.biblioitemnumber
    * items.itemnumber
    
    These IDs are no longer increment by the Perl code, thus
    allowing better concurrency during bib/item editing.
    
    Signed-off-by: Chris Cormack <crc@liblime.com>
    Signed-off-by: Joshua Ferraro <jmf@liblime.com>
  4. fix transfer of marc_breeding to import_records/import_biblios

    Galen Charlton authored Joshua Ferraro committed
    Problem was that z3950random is not a good unique key to use
    for linking new import_records and import_biblios rows.
    
    Signed-off-by: Chris Cormack <crc@liblime.com>
    Signed-off-by: Joshua Ferraro <jmf@liblime.com>
  5. bump to 3.00.00.017 : adding columns to zebraqueue

    Paul POULAIN authored Joshua Ferraro committed
    The zebraque_start scripts works, but it not friendly when you try to track what he did
    as records are deleted after done.
    This commit changes the behaviour : 2 columns are added done & timestamp.
    done is set to 1 when a line have been done. And the timestamp contains the timestamp of the last action (either line creation if done=0 or operation if done=1)
    
    should be helpfull to track problem.
    
    the table will grow, but i'll add soon a DELETE FROM zebraqueue WHERE timestamp > 30 days or something like that
    
    Signed-off-by: Chris Cormack <crc@liblime.com>
    Signed-off-by: Joshua Ferraro <jmf@liblime.com>
Commits on Oct 31, 2007
  1. escaping @a to avoid updatedatabase failure

    Joshua Ferraro authored
    Signed-off-by: Joshua Ferraro <jmf@liblime.com>
  2. correct to prior action_logs patch

    Galen Charlton authored Joshua Ferraro committed
    Signed-off-by: Chris Cormack <crc@liblime.com>
    Signed-off-by: Joshua Ferraro <jmf@liblime.com>
  3. added auto_number column as PK for action_logs

    Galen Charlton authored Joshua Ferraro committed
    * prevents PK warnings when logging actions that occur
      faster than once a second (e.g., batch MARC loads) --
      the original PK of timestamp + user not granular enough
    * timestamp + user still indexed for log viewing
    
    Signed-off-by: Chris Cormack <crc@liblime.com>
    Signed-off-by: Joshua Ferraro <jmf@liblime.com>
  4. added missing upgrade message

    Galen Charlton authored Joshua Ferraro committed
    Signed-off-by: Chris Cormack <crc@liblime.com>
    Signed-off-by: Joshua Ferraro <jmf@liblime.com>
Commits on Oct 30, 2007
  1. Adding reports_dictionary table

    Chris Cormack authored Joshua Ferraro committed
    Signed-off-by: Chris Cormack <crc@liblime.com>
    Signed-off-by: Joshua Ferraro <jmf@liblime.com>
  2. fixing conflict in updatedatabase

    Joshua Ferraro authored
    Signed-off-by: Chris Cormack <crc@liblime.com>
    Signed-off-by: Joshua Ferraro <jmf@liblime.com>
Commits on Oct 29, 2007
  1. Updating updatedatabase and kohaversion.pl for new reports tables

    Chris Cormack authored Joshua Ferraro committed
    Signed-off-by: Chris Cormack <crc@liblime.com>
    Signed-off-by: Joshua Ferraro <jmf@liblime.com>
  2. more work on batch import

    Galen Charlton authored Joshua Ferraro committed
    * Completely removed old marc_breeding table
    * Started updated Tools import function to stage records
    
    Signed-off-by: Chris Cormack <crc@liblime.com>
    Signed-off-by: Joshua Ferraro <jmf@liblime.com>
  3. update for missing subscriptions.lastbranch col in serials

    Mason James authored Joshua Ferraro committed
    Signed-off-by: Chris Cormack <crc@liblime.com>
    Signed-off-by: Joshua Ferraro <jmf@liblime.com>
  4. added column to import_records

    Galen Charlton authored Joshua Ferraro committed
    Signed-off-by: Chris Cormack <crc@liblime.com>
    Signed-off-by: Joshua Ferraro <jmf@liblime.com>
  5. DB schema changes for enhancements to reservoir and batch loading

    Galen Charlton authored Joshua Ferraro committed
    Signed-off-by: Chris Cormack <crc@liblime.com>
    Signed-off-by: Joshua Ferraro <jmf@liblime.com>
Commits on Oct 24, 2007
  1. new tables created with innoDB & utf8 automatically

    Paul POULAIN authored Joshua Ferraro committed
    Signed-off-by: Chris Cormack <crc@liblime.com>
    Signed-off-by: Joshua Ferraro <jmf@liblime.com>
Commits on Oct 22, 2007
  1. fixing typo in updatedatabase

    Joshua Ferraro authored
  2. call number patch part 4 -- resolve conflict with another DB schema c…

    Galen Charlton authored Joshua Ferraro committed
    …hange
    
    Signed-off-by: Chris Cormack <crc@liblime.com>
    Signed-off-by: Joshua Ferraro <jmf@liblime.com>
  3. adding missing kohaversion.pl

    Joshua Ferraro authored
    adding missing line to updatedatabase
  4. updatedatabase for branch category types

    Ryan Higgins authored Joshua Ferraro committed
    Signed-off-by: Chris Cormack <crc@liblime.com>
    Signed-off-by: Joshua Ferraro <jmf@liblime.com>
Commits on Oct 20, 2007
  1. merging some SQL commands to speed up updatedatabase

    Paul POULAIN authored Joshua Ferraro committed
    Signed-off-by: Joshua Ferraro <jmf@liblime.com>
Commits on Oct 19, 2007
  1. Adding index on userid in the borrowers table

    Chris Cormack authored Joshua Ferraro committed
    Signed-off-by: Joshua Ferraro <jmf@liblime.com>
  2. Patch from Galen Charlton, removing $Id$ $Log$ and $Revision$ from files

    Chris Cormack authored Joshua Ferraro committed
    Signed-off-by: Joshua Ferraro <jmf@liblime.com>
  3. start of reworking call number handling and other Biblio changes

    Galen Charlton authored Joshua Ferraro committed
    Most of this commit by Joshua Ferraro.
    updatedatabase changes by Galen Charlton.
    
    Major changes:
    
    This commit includes a lot of fairly major changes
    to Koha's Biblio handling, largest is the addition
    and deletion of several columns in the biblioitems,
    items tables, as well as cleanup of deletedbiblioitems,
    deleteditems tables. Some of the changes are simple
    cleanup, but most have to do with improvements to
    storage of call numbers in Koha.
    
    Also, I had to clean up the _koha_* routines quite a
    lot to make them work -- there was lots of data just
    being lost because columns weren't being updated.
    
    I'm still not completely convinced that the items
    table is being treated as authoritative for items
    data, investigating further.
    
    DB Changes (updated in kohastructure.sql and in
    updatedatabases):
    
    ADDED:
    biblioitems.cn_source   ( auth value, CN_SOURCE, stores the source of the
                              call number: DDC, LCC, NLM, etc.)
    biblioitems.cn_class    ( plugin, marc21_callnumber.pl, helps fill in
                              the rest of the biblio-level fields)
    biblioitems.cn_item
    biblioitems.cn_suffix
    biblioitems.cn_sort     ( for zebra sorting, stored as a decimal number)
    biblioitems.totalissues ( for counting the total times issued )
    
    items.cn_source         ( auth value, CN_SOURCE, stores DDC, LCC, NLM, etc.)
    items.itemcallnumber    ( plugin, marc21_itemcallnumber.pl, helps fill in
                              the itemcallnumber based on the record data )
    items.cn_sort           ( for zebra sorting, stored as a decimal number)
    items.ccode             ( auth value, CCODE, stores the Collection Code
                              of the item, can be used as call number prefix
                              by some libraries )
    items.uri
    items.materials
    items.damaged
    
    DELETED:
    items.itype
    items.cutterextra
    biblioitems.classification
    biblioitems.subclass
    biblioitems.dewey
    biblioitems.lcsort
    biblioitems.lccn
    biblioitems.ccode
    
    DB version now 3.00.00.009.
    
    Minor changes:
    
    * Drop revision history from C4/Biblio.pm
    * GetMarcAuthors now returns additional authors (7XX), not
      main authors (1XX)
    * Debug warnings in C4/Search.pm commented out
    
    Signed-off-by: Chris Cormack <crc@liblime.com>
    Signed-off-by: Joshua Ferraro <jmf@liblime.com>
Commits on Oct 18, 2007
  1. Patch from Joe Atzberger to remove $Id$ and $Log$ from scripts

    Chris Cormack authored Joshua Ferraro committed
    Signed-off-by: Joshua Ferraro <jmf@liblime.com>
Commits on Oct 13, 2007
  1. #1485 (issuing rules improvement) continued

    Paul POULAIN authored Joshua Ferraro committed
    IMPORTANT NOTE : all existing test database for 3.0 must manually delete ALL constraints on issuingrules table
    (the update22to30.pl don't contain the constraints anymore, as kohastructure.sql, so are concerned only the existing 3.0 tests databases)
    
    Filling issuingrules table :
    - the issuingrules table can't have a constraint on categorycode, as we have a '*' categorycode (=default issuingrule)
    - reintroducing the "default" issuingrule column
    - changing some text ('*' replaced by something more explanatory)
    - handling correctly the '0' (that is different from 'undefined'
    
    Signed-off-by: Chris Cormack <crc@liblime.com>
    Signed-off-by: Joshua Ferraro <jmf@liblime.com>
Something went wrong with that request. Please try again.