View | Details | Raw Unified | Return to bug 2046
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 1969-1975 CREATE TABLE `suggestions` ( -- purchase suggestions Link Here
1969
  `STATUS` varchar(10) NOT NULL default '', -- suggestion status (ASKED, CHECKED, ACCEPTED, or REJECTED)
1969
  `STATUS` varchar(10) NOT NULL default '', -- suggestion status (ASKED, CHECKED, ACCEPTED, or REJECTED)
1970
  `note` mediumtext, -- note entered on the suggestion
1970
  `note` mediumtext, -- note entered on the suggestion
1971
  `author` varchar(80) default NULL, -- author of the suggested item
1971
  `author` varchar(80) default NULL, -- author of the suggested item
1972
  `title` varchar(80) default NULL, -- title of the suggested item
1972
  `title` varchar(255) default NULL, -- title of the suggested item
1973
  `copyrightdate` smallint(6) default NULL, -- copyright date of the suggested item
1973
  `copyrightdate` smallint(6) default NULL, -- copyright date of the suggested item
1974
  `publishercode` varchar(255) default NULL, -- publisher of the suggested item
1974
  `publishercode` varchar(255) default NULL, -- publisher of the suggested item
1975
  `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,  -- date and time the suggestion was updated
1975
  `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,  -- date and time the suggestion was updated
(-)a/installer/data/mysql/updatedatabase.pl (+7 lines)
Lines 6771-6776 if ( CheckVersion($DBversion) ) { Link Here
6771
   SetVersion ($DBversion);
6771
   SetVersion ($DBversion);
6772
}
6772
}
6773
6773
6774
$DBversion = "XXX";
6775
if ( CheckVersion($DBversion) ) {
6776
    $dbh->do(q{ALTER TABLE suggestions CHANGE COLUMN title title VARCHAR(255) DEFAULT NULL;});
6777
    print "Upgrade to $DBversion done (Bug 2046 - increasing title column length for suggestions)\n";
6778
    SetVersion ($DBversion);
6779
}
6780
6774
6781
6775
=head1 FUNCTIONS
6782
=head1 FUNCTIONS
6776
6783
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/suggestion/suggestion.tt (-1 / +1 lines)
Lines 267-273 $(document).ready(function() { calcNewsuggTotal(); }); Link Here
267
        <h1>Enter a new purchase suggestion</h1>
267
        <h1>Enter a new purchase suggestion</h1>
268
    [% END %]
268
    [% END %]
269
    <fieldset class="rows"> <legend>Bibliographic information</legend><ol>
269
    <fieldset class="rows"> <legend>Bibliographic information</legend><ol>
270
        <li><label for="title">Title:</label><input type="text" id="title" name="title" size="50" maxlength="80" value="[% title |html %]"/></li>
270
        <li><label for="title">Title:</label><input type="text" id="title" name="title" size="80" maxlength="255" value="[% title |html %]"/></li>
271
        <li><label for="author">Author:</label><input type="text" id="author" name="author" size="50" maxlength="80" value="[% author %]"/></li>
271
        <li><label for="author">Author:</label><input type="text" id="author" name="author" size="50" maxlength="80" value="[% author %]"/></li>
272
        <li><label for="copyrightdate">Copyright date:</label><input type="text" id="copyrightdate" name="copyrightdate" size="4" maxlength="4" value="[% copyrightdate %]" /></li>
272
        <li><label for="copyrightdate">Copyright date:</label><input type="text" id="copyrightdate" name="copyrightdate" size="4" maxlength="4" value="[% copyrightdate %]" /></li>
273
        <li><label for="isbn">ISBN or ISSN or other standard number:</label><input type="text" id="isbn" name="isbn" size="50" maxlength="80" value="[% isbn %]"/></li>
273
        <li><label for="isbn">ISBN or ISSN or other standard number:</label><input type="text" id="isbn" name="isbn" size="50" maxlength="80" value="[% isbn %]"/></li>
(-)a/koha-tmpl/opac-tmpl/prog/en/modules/opac-suggestions.tt (-2 / +1 lines)
Lines 103-109 $.tablesorter.addParser({ Link Here
103
    <p>Only the title is required, but the more information you enter the easier it will be for the librarians to find the title you're requesting. The "Notes" field can be used to provide any additional information.</p>
103
    <p>Only the title is required, but the more information you enter the easier it will be for the librarians to find the title you're requesting. The "Notes" field can be used to provide any additional information.</p>
104
    <form action="/cgi-bin/koha/opac-suggestions.pl" method="post">
104
    <form action="/cgi-bin/koha/opac-suggestions.pl" method="post">
105
   <fieldset class="rows"> <ol>
105
   <fieldset class="rows"> <ol>
106
    <li><label class="required" for="title">Title:</label><input type="text" id="title" name="title" size="50" maxlength="80" /></li>
106
    <li><label class="required" for="title">Title:</label><input type="text" id="title" name="title" size="80" maxlength="255" /></li>
107
    <li><label for="author">Author:</label><input type="text" id="author" name="author" size="50" maxlength="80" /></li>
107
    <li><label for="author">Author:</label><input type="text" id="author" name="author" size="50" maxlength="80" /></li>
108
    <li><label for="copyrightdate">Copyright Date:</label><input type="text" id="copyrightdate" name="copyrightdate" size="4" maxlength="4" /></li>
108
    <li><label for="copyrightdate">Copyright Date:</label><input type="text" id="copyrightdate" name="copyrightdate" size="4" maxlength="4" /></li>
109
    <li><label for="isbn">Standard Number (ISBN, ISSN or Other):</label><input type="text" id="isbn" name="isbn" size="50" maxlength="80" /></li>
109
    <li><label for="isbn">Standard Number (ISBN, ISSN or Other):</label><input type="text" id="isbn" name="isbn" size="50" maxlength="80" /></li>
110
- 

Return to bug 2046