update opl_preference set val=replace(val,',5001,',',8026,5001,') where var='useAttOrder' && val not regexp ',8026,';

replace into opl_authCtrl(tag,sfCode,sfData) values
("586","a","American Book Awards"),
("586","a","Booker Prize"),
("586","a","Caldecott Medal Award"),
("586","a","Carnegie Medal"),
("586","a","CBC Canada Reads"),
("586","a","Coretta Scott Kinf Award"),
("586","a","Independent Publishers Book Award"),
("586","a","Newbery Medal Award"),
("586","a","Nobel Prize for Literature"),
("586","a","Pulitzer Prize Fiction"),
("586","a","Pulitzer Price Non-Fiction"),
("586","a","Taylor Prize"),
("586","a","Trillium Book Award"),
("586","a","Alex Awards (Book, Print & Media Awards)"),
("586","a","Andrew Carnegie Medals for Excellence in Fiction and Nonfiction (Book, Print & Media Awards)"),
("586","a","Mildred L. Batchelder Award (Book, Print & Media Awards)"),
("586","a","Pura Belpré Award (Book, Print & Media Awards)"),
("586","a","The Amelia Bloomer Book List (Book, Print & Media Awards)"),
("586","a","Randolph Caldecott Medal (Book, Print & Media Awards)"),
("586","a","Andrew Carnegie Medal for Excellence in Children's Video (Book, Print & Media Awards)"),
("586","a","Charlotte Award (New York State)"),
("586","a","Margaret A. Edwards Award (Book, Print & Media Awards)"),
("586","a","Excellence in Nonfiction for Young Adults (Book, Print & Media Awards)"),
("586","a","Theodor Seuss Geisel Award (Book, Print & Media Awards)"),
("586","a","Coretta Scott King Book Awards (Book, Print & Media Awards)"),
("586","a","Coretta Scott King - John Steptoe Award for New Talent (Book, Print & Media Awards)"),
("586","a","William C. Morris Debut YA Award (Book, Print & Media Awards)"),
("586","a","John Newbery Medal (Book, Print & Media Awards)"),
("586","a","Michael L. Printz Award (Book, Print & Media Awards)"),
("586","a","Quick Picks for Reluctant Young Adult Readers (Book, Print & Media Awards)"),
("586","a","Schneider Family Book Award (Book, Print & Media Awards)"),
("586","a","Robert F. Sibert Informational Book Medal (Book, Print & Media Awards)"),
("586","a","Stonewall Book Awards (Book, Print & Media Awards)"),
("586","a","Stonewall Book Awards - Mike Morgan & Larry Romans Children’s & Young Adult Literature Award (Book, Print & Media Awards)"),
("586","a","Teen's Top Ten (Book, Print & Media Awards)"),
("586","a","Three Apples Book Award (New York State)"),
("586","a","Laura Ingalls Wilder Award (Book, Print & Media Awards)")

;
ALTER TABLE opl_marcExport add  expParams  mediumtext after exclRecFormat;

CREATE TABLE IF NOT EXISTS  `opl_classif` (
  `cid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` int(10) unsigned NOT NULL DEFAULT '0',
  `className` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `description` text,
  `iconURL` varchar(255) DEFAULT NULL,
  `createdDate` datetime DEFAULT NULL,
  `modDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`cid`),
  UNIQUE KEY `cid` (`cid`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS  `opl_classifItem` (
  `cid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `rid` int(10) unsigned NOT NULL DEFAULT '0',
  UNIQUE KEY `cid` (`cid`,`rid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; 

alter table tb_transactions add pid int(10) unsigned DEFAULT NULL after ptid;

CREATE TABLE IF NOT EXISTS `tb_paymentReceipt` (
  `pid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `received` float(10,2) DEFAULT '0.00',
  `withdrawn` float(10,2) DEFAULT '0.00',
  `accountBalance` float(10,2) DEFAULT '0.00',
  `payMethod` varchar(50) DEFAULT 'cash',
  `tender` float(10,2) DEFAULT '0.00',
  `changeAmnt` float(10,2) DEFAULT '0.00',
  `ondate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB;

