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

(-)a/installer/data/mysql/kohastructure.sql (-1 lines)
Lines 2169-2175 CREATE TABLE `suggestions` ( -- purchase suggestions Link Here
2169 
  `publicationyear` smallint(6) default 0,
 2169 
  `publicationyear` smallint(6) default 0,
2170 
  `place` varchar(255) default NULL, -- publication place of the suggested item
 2170 
  `place` varchar(255) default NULL, -- publication place of the suggested item
2171 
  `isbn` varchar(30) default NULL, -- isbn of the suggested item
 2171 
  `isbn` varchar(30) default NULL, -- isbn of the suggested item
2172 
  `mailoverseeing` smallint(1) default 0,
2173 
  `biblionumber` int(11) default NULL, -- foreign key linking the suggestion to the biblio table after the suggestion has been ordered
 2172 
  `biblionumber` int(11) default NULL, -- foreign key linking the suggestion to the biblio table after the suggestion has been ordered
2174 
  `reason` text, -- reason for accepting or rejecting the suggestion
 2173 
  `reason` text, -- reason for accepting or rejecting the suggestion
2175 
  `patronreason` text, -- reason for making the suggestion
 2174 
  `patronreason` text, -- reason for making the suggestion
(-)a/installer/data/mysql/ru-RU/optional/sample_user_suggestions.sql (-2 / +2 lines)
Lines 1-4 Link Here
1 
TRUNCATE suggestions;
 1 
TRUNCATE suggestions;
2 

          2
          

        

          
            

              3
              
INSERT INTO `suggestions` (`suggestionid`, `suggestedby`, `managedby`, `STATUS`, `note`, `author`, `title`, `copyrightdate`, `publishercode`, `date`, `volumedesc`, `publicationyear`, `place`, `isbn`, `mailoverseeing`, `biblionumber`, `reason`) 


              3
              
INSERT INTO `suggestions` (`suggestionid`, `suggestedby`, `managedby`, `STATUS`, `note`, `author`, `title`, `copyrightdate`, `publishercode`, `date`, `volumedesc`, `publicationyear`, `place`, `isbn`, `biblionumber`, `reason`)

            

            

              4
              
VALUES (1,0,NULL,'ASKED','нужна для УКЕ','','Мифы нашего времени',2008,'Часы','2008-05-01 08:02:26',NULL,NULL,NULL,NULL,0,0,NULL);


              4
              
VALUES (1,0,NULL,'ASKED','нужна для УКЕ','','Мифы нашего времени',2008,'Часы','2008-05-01 08:02:26',NULL,NULL,NULL,NULL,0,NULL);

            



(-)a/installer/data/mysql/uk-UA/optional/sample_user_suggestions.sql
      (-2 / +2 lines)




  

    
      
            Lines 1-4
          
      
      
        Link Here
      
    
  

        

          1
          
TRUNCATE suggestions;

          1
          
TRUNCATE suggestions;

        

        

          2
          

          2
          

        

          
            

              3
              
INSERT INTO `suggestions` (`suggestionid`, `suggestedby`, `managedby`, `STATUS`, `note`, `author`, `title`, `copyrightdate`, `publishercode`, `date`, `volumedesc`, `publicationyear`, `place`, `isbn`, `mailoverseeing`, `biblionumber`, `reason`) 


              3
              
INSERT INTO `suggestions` (`suggestionid`, `suggestedby`, `managedby`, `STATUS`, `note`, `author`, `title`, `copyrightdate`, `publishercode`, `date`, `volumedesc`, `publicationyear`, `place`, `isbn`, `biblionumber`, `reason`)

            

            

              4
              
VALUES (1,0,NULL,'ASKED','потрібна для УКЕ','','Міфи нашого часу',2008,'Час','2008-05-01 08:02:26',NULL,NULL,NULL,NULL,0,0,NULL);


              4
              
VALUES (1,0,NULL,'ASKED','потрібна для УКЕ','','Міфи нашого часу',2008,'Час','2008-05-01 08:02:26',NULL,NULL,NULL,NULL,0,NULL);

            



(-)a/installer/data/mysql/updatedatabase.pl
      (-1 / +8 lines)




  

    
      
            Lines 8800-8805
          if ( CheckVersion($DBversion) ) {
      
      
        Link Here
      
    
  

        

          8800
          
    SetVersion($DBversion);

          8800
          
    SetVersion($DBversion);

        

        

          8801
          
}

          8801
          
}

        

        

          8802
          

          8802
          

        

            

              
              
              8803
              
$DBversion = '3.17.00.XXX';

            

            

              8804
              
if ( CheckVersion($DBversion) ) {

            

            

              8805
              
    $dbh->do(q{

            

            

              8806
              
        ALTER TABLE suggestions DROP COLUMN mailoverseeing;

            

            

              8807
              
    });

            

            

              8808
              
    print "Upgrade to $DBversion done (Bug 13006: Drop column suggestion.mailoverseeing)";

            

            

              8809
              
    SetVersion($DBversion);

            

            

              8810
              
}

            

        

          8803
          

          8811
          

        

        

          8804
          
=head1 FUNCTIONS

          8812
          
=head1 FUNCTIONS

        

        

          8805
          

          8813
          

        

            

              8806
              
- 

              
              
            






  

  Return to bug 13006