http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11010

            Bug ID: 11010
           Summary: Useless column purchaseordernumber in aqorders table
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: minor
          Priority: P5 - low
         Component: Database
          Assignee: [email protected]
          Reporter: [email protected]
        QA Contact: [email protected]

In Schemaspy, column purchaseordernumber is reported as "not used? always
NULL".
"grep -r cancelledby *" give this result : 

C4/Acquisition.pm:The following keys are used: "biblionumber", "title",
"basketno", "quantity", "notes", "rrp", "ecost", "gstrate", "unitprice",
"subscription", "sort1", "sort2", "booksellerinvoicenumber", "listprice",
"budgetdate", "purchaseordernumber", "branchcode", "booksellerinvoicenumber",
"budget_id".
C4/Acquisition.pm:                datereceived,purchaseordernumber,
installer/data/mysql/update22to30.pl:                field   =>
'purchaseordernumber',
installer/data/mysql/kohastructure.sql:  `purchaseordernumber` mediumtext, --
not used? always NULL
installer/data/Pg/kohastructure.sql:purchaseordernumber text,
t/db_dependent/Acquisition.t:                         purchaseordernumber


In C4::Acquisition.pm::GetParcels, the SELECT statement retreives
purchaseordernumber, but no value is pushed to that column in any part of
Koha's code. So I think it is useless.

I propose the deletion of this column.

M. Saby

-- 
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to