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

(-)a/installer/data/mysql/atomicupdate/bug_5260_acq_email_orders.sql (-1 / +3 lines)
Line 1 Link Here
1 
ALTER TABLE `aqcontacts` ADD `orderacquisition` BOOLEAN NOT NULL DEFAULT 0 AFTER `notes`;
 1 
ALTER TABLE `aqcontacts` ADD `orderacquisition` BOOLEAN NOT NULL DEFAULT 0 AFTER `notes`;
2 
-
2 

            

            

              
              

              3
              
INSERT IGNORE INTO `letter` (module, code, name, title, content, message_transport_type) VALUES

            

            


              4
              
('orderacquisition','ACQORDER','Acquisition order','Order','<<aqbooksellers.name>>\r\n<<aqbooksellers.address1>>\r\n<<aqbooksellers.address2>>\r\n<<aqbooksellers.address3>>\r\n<<aqbooksellers.address4>>\r\n<<aqbooksellers.phone>>\r\n\r\nPlease order for the library:\r\n\r\n<order>Ordernumber <<aqorders.ordernumber>> (<<biblio.title>>) (quantity: <<aqorders.quantity>>) ($<<aqorders.listprice>> each).</order>\r\n\r\nThank you,\n\n<<branches.branchname>>', 'email');

            






  

  Return to bug 5260